Prepare an MPS table like that shown in Figure 12-11 for the following situation. The forecast for each of the next four weeks is 70 units. The starting inventory is zero. The MPS rule is to schedule production if the projected inventory on hand will be negative. The production lot size is 100 units. The following table shows customer (committed) orders. Week Customer Orders  1 80  2 50  3 30  4 10 Calculate the available-to-promise (ATP) quantities for each period. (Do not leave any empty spaces; input a "0" wherever it is required.)       June            1 2 3 4  Forecast   70 70 70 70  Committed            Projected on hand (min = 0) 0          Produce (lot size = 100)            Available-to-promise

Update the MPS table shown in Figure 12-11 given these inputs: It is now the end of week 1; customer orders are 35 units for week 2, 16 for week 3, 11 for week 4, 8 for week 5, and 3 for week 6. Inventory on hand is now 33 units. Use the MPS rule of ordering production when projected on-hand inventory would be negative without production.     June       July          2 3 4   5 6 7 8  Forecast 30 30 30   40 40 40 40  Committed 35 16 11   8 3 0 0  Project on hand (min = 0)  33                  Product (lot size = 70)                  Available-to-promise

Which of the following options are true for a master production schedule (MPS)?(Multiple options may be correct) MPS breaks down the production plan to show in each period, the production quantity of each final itemStock inventory level and available production capacity are among the inputs feeding the MPSMPS works best for very long time periods, usually extending beyond 24 months MPS helps to decide the sequence of production and batch sizeMPS acts as a forecast in manufacturing

A manufacturing firm is preparing its production budget for the year. Projected sales are as follows: Q1 Q2 Q3 Q4 Sales budget (units) 75 122 203 188 The firm's policy is to have finished goods inventory equal to 25% of next month's projected sales. The opening inventory in Q1 is 120 units. How many units need to be produced in Q3? (hint - you need to remember to calculate the opening inventory for Q3)

Question: A manager has prepared a forecast of expected aggregate demand for the next six months. Develop an aggregate plan to meet this demand given this additional information: A level production rate of 100 units per month will be used. Back orders are allowed, and they are charged at the rate of $8 per unit per month. Inventory holding costs are $1 per unit perA manager has prepared a forecast of expected aggregate demand for the next six months. Develop an aggregate plan to meet this demand given this additional information: A level production rate of 100 units per month will be used. Back orders are allowed, and they are charged at the rate of $8 per unit per month. Inventory holding costs are $1 per unit per month in ending inventory. Determine the cost of this plan if regular time cost is $20 per unit and beginning inventory is zero.Month Forecast1 802 1003 1204 1105 1006 90

An aggregate plan shows inventory at the end of February = 40 units.Forecast demand for March = 600 units Production output expected during March = 700 units.Number of back orders at the end of February = 80 units. What is the expected inventory at the end of March?Multiple Choice40 units50 units60 units100 units