Prepare a master schedule given this information: It is now the end of week 1; c
ID: 451654 • Letter: P
Question
Prepare a master schedule given this information: It is now the end of week 1; customer orders are 25 for week 2, 16 for week 3, 11 for week 4, 8 for week 5, and 3 for week 6. Use the MPS rule of ordering production when projected on-hand inventory would be negative without production. Suppose that a production lot size of 70 pumps is used. (Leave no cells blank - be certain to enter "0" wherever required.) June July 64 1 2 3 4 5 6 7 8 Forecast 30 30 30 30 40 40 40 40 Customer orders (committed) 33 25 16 11 8 3 Projected on-hand inventory MPS 0 0 70 0 70 0 70 70 ATP 31 31 0 0 0 0 70 70
Explanation / Answer
The given information is stated as follows:
JUNE JULY Inventory-64 Week1 Week2 Week3 Week4 Week5 Week6 Week7 Week8 Forecasts 30 30 30 30 40 40 40 40 Customer orders 33 25 16 11 8 3 0 0 Projected on hand 31 1 -29 11 -29 1 -39 -9 MPS 0 0 70 0 70 0 70 70 Available to promise 31 31 0 0 0 0 70 70