Master Production Schedule Calculator

About the Master Production Schedule Calculator

The Master Production Schedule (MPS) is the primary driver of manufacturing activity. It translates demand (from forecasts and customer orders) into a production plan that specifies what to produce, how much, and when. The MPS bridges sales planning and shop floor execution.

The core calculation is: Planned Production = max(Forecast, Customer Orders) − On-Hand Inventory − Scheduled Receipts. When projected on-hand inventory drops below zero, a planned production order is triggered to bring it back to the target level.

This calculator performs a simplified single-period MPS calculation showing gross requirements, available inventory, net requirements, and planned production. It is essential for anyone learning MPS logic or doing quick planning calculations before entering data into an ERP system.

When This Page Helps

The MPS is the plan that drives MRP, capacity planning, and purchasing. Getting it right means materials arrive on time, capacity is available, and customers get what they ordered when they need it.

How to Use the Inputs

1. Enter the demand forecast for the period in units.
2. Enter confirmed customer orders for the period.
3. Enter current on-hand inventory.
4. Enter any scheduled receipts (open production or purchase orders).
5. Enter minimum production lot size if applicable.
6. View gross requirements, net requirements, and planned production quantity.

Example Calculation

Tips & Best Practices

• Use the greater of forecast and orders as gross requirement to avoid under-planning.
• Review MPS weekly and adjust as forecasts and orders change.
• Lot size should reflect setup economics and container quantities.
• Consider safety stock as a floor for projected on-hand.
• MPS changes inside the frozen zone should require management approval.
• Ensure MPS quantities are validated against available capacity.

MPS in Different Manufacturing Environments

Make-to-stock (MTS) environments use MPS driven by forecasts. Make-to-order (MTO) environments use MPS driven by actual orders. Assemble-to-order (ATO) environments may MPS components to forecast and final assembly to order. The MPS logic adapts to each strategy.

MPS and Capacity Validation

An MPS that exceeds available capacity is useless. After generating the MPS, validate it against rough-cut capacity to confirm feasibility. If it overloads key work centers, adjust quantities or timing before releasing to MRP.

Time Fences and Change Management

Time fences divide the planning horizon into zones with different change rules. The frozen zone allows minimal changes. The slushy zone allows changes with approval. The liquid zone allows free changes. This structure balances responsiveness with shop floor stability.

Frequently Asked Questions

• What is the difference between MPS and MRP?

  MPS plans finished goods production based on demand. MRP explodes the MPS through the bill of materials to plan component and raw material requirements. MPS drives MRP.

• What is the frozen zone?

  The frozen zone is a near-term period (often 1-4 weeks) where the MPS is locked and changes are restricted. This gives the shop floor stability and prevents constant plan changes that disrupt execution.

• Why use max(forecast, orders) instead of sum?

  Using the maximum avoids double-counting. Customer orders are expected to consume the forecast. Taking the max means you plan for whichever is higher — actual orders if they exceed forecast, or forecast if orders haven't materialized yet.

• What about safety stock?

  Safety stock acts as a floor for projected on-hand. If projected inventory would drop below safety stock, a planned production order is triggered to restore the buffer. Add safety stock to the net requirement calculation.

• How far out should the MPS extend?

  At minimum, the MPS should cover the cumulative lead time for the product (including purchased material lead time). Typically, MPS horizons are 12-26 weeks for make-to-stock environments.

• What is Available-to-Promise (ATP)?

  ATP is the quantity of finished goods that sales can commit to customers. It is the MPS quantity minus customer orders already booked. ATP helps sales make reliable delivery promises.