A manufacturing company enters 2016 with a forecast and customer orders as shown in the table. They have a beginning inventory of 25 units and a batch size of 25 units (all MPS quantities must be in multiples of 25)

Complete the rest of the master production schedule by filling in the projected ending inventory, master production schedule quantity, and available to promise rows.

Month 1 2 3 4 5 6
Forecast 140 150 170 190 225 275
Booked Orders 145 120 95 50 0 0
Projected Ending Inventory
Master Production Schedule
Available to Promise
What will be an ideal response?

Answer:
Month 1 2 3 4 5 6
Forecast 140 150 170 190 225 275
Booked Orders 145 120 95 50 0 0
Projected Ending Inventory 5 5 10 20 20 20
Master Production Schedule 125 150 175 200 225 275
Available to Promise 5 30 80 150 225 275