Master Production Schedule
The Master Production Schedule (MPS) represents the critical disaggregation of the Aggregate Production Plan. While APP deals in product families or general capacity limits, the MPS dictates the exact quantity and timing of specific end products for a short-term horizon (typically 8 to 12 weeks). It balances the master schedule against hard constraints, driving the exact lot-sizing rules, Projected On-Hand inventory, and precisely calculating the Available-to-Promise (ATP) inventory for the sales department.
Projected On Hand (POH)
Inventory expected to be available at the end of each period.
POH = Starting Inventory + MPS - MAX(Forecast, Customer Orders)
Available-to-Promise (ATP)
The uncommitted inventory maintained to support customer order promising.
ATP (Period 1) = On-hand + MPS - (Sum of orders before next MPS)
Click highlighted cells (POH, MPS, ATP) to view the step-by-step logic.
Fill in the table below based on the Forecast and Customer Orders from the Auto tab. Click "Verify" to check your answers.