Prepare a master schedule based on the following information Week 1 2 3 4 5 6 7
ID: 429299 • Letter: P
Question
Prepare a master schedule based on the following information Week 1 2 3 4 5 6 7 8 Forecast 100 100 120 120 150 150 180 180 Orders 106 94 65 40 21 9 2 0 Projected On-Hand MPS ATP Currently there are 145 units in inventory. Policy calls for a fixed order quantity of 250 units Prepare a master schedule based on the following information Week 1 2 3 4 5 6 7 8 Forecast 100 100 120 120 150 150 180 180 Orders 106 94 65 40 21 9 2 0 Projected On-Hand MPS ATP Currently there are 145 units in inventory. Policy calls for a fixed order quantity of 250 unitsExplanation / Answer
Here is your master schedule table:
Week 1 2 3 4 5 6 7 8 Forecast 100 100 120 120 150 150 180 180 Orders 106 94 65 40 21 9 2 0 Projected On-Hand 39 189 69 199 49 149 219 39 MPS 0 250 0 250 0 250 250 0 ATP -55 145 0 189 0 239 248 0