How to Build a Master Production Schedule (MPS) Step by Step

This guide is the how-to: the steps to build a master production schedule (MPS) from scratch, and the weekly routine that keeps it accurate. If you want the definition first, with the projected available balance and available-to-promise formulas and three worked examples, start with what is a master production schedule, then come back here.

Without a reliable MPS, material requirements planning cannot function accurately, capacity problems go undetected, and the detailed production schedule lacks a foundation to build on. Despite its importance, the MPS is one of the most poorly maintained planning tools in manufacturing. Below: how to create one, how to maintain it, and how it connects to the detailed production scheduling that drives your shop floor. To follow along with real numbers, download the free master production schedule Excel template; it calculates gross requirements, projected balance and available to promise for you.

Before You Start: What Goes In and What Comes Out

The MPS sits between demand management and shop floor execution. Collect the inputs before step 1:

Inputs to the MPS:

• Customer orders (confirmed demand)
• Sales forecasts (anticipated demand)
• Safety stock requirements
• Current inventory levels
• Available capacity (rough-cut)

Outputs from the MPS:

• Time-phased production plan by product and period
• Input to MRP for material requirements calculation
• Input to rough-cut capacity planning to validate feasibility
• Foundation for detailed production scheduling

In simple terms, the MPS answers: How much of each product will we produce in each of the next 8-16 weeks?

MPS vs. Detailed Production Scheduling

Understanding the distinction between the MPS and the detailed production schedule is critical. They operate at different levels:

The MPS tells you what and how much. Detailed scheduling tells you where, when, and in what order. Both are necessary. See our article on production scheduling vs production planning for more on this distinction.

How to Create an MPS: Step by Step

Step 1: Gather Demand Data

Compile all demand sources into a single view:

• Confirmed orders - customer purchase orders with firm quantities and dates
• Forecast - anticipated demand from the sales team or statistical forecasting
• Interplant transfers - if you supply other facilities
• Safety stock replenishment - quantities needed to maintain buffer inventory

For make-to-order manufacturers, confirmed orders are the primary input. For make-to-stock, forecasts play a larger role.

Step 2: Define Time Fences

Time fences establish zones of schedule stability:

• Frozen zone (0-2 weeks): The schedule is locked. Changes require management approval and must be justified by exceptional circumstances (major customer, quality emergency).
• Slushy zone (3-6 weeks): Changes are permitted with documented impact analysis. The planner evaluates material and capacity implications before approving.
• Flexible zone (7+ weeks): Changes are routinely accommodated as demand signals evolve.

Time fences protect the near-term schedule from constant churning while allowing flexibility further out. Without them, every sales call triggers a schedule change, and the shop floor never has a stable plan.

Step 3: Calculate Available-to-Promise (ATP)

Available-to-Promise (ATP) tells your sales team what quantities can be promised for delivery without disrupting existing commitments:

ATP = MPS quantity - Committed orders for the period

ATP visibility prevents over-promising. When a salesperson can see that 50 units are already committed in Week 12 out of a planned 75, they know only 25 units remain available to promise. In practice "the period" runs from one MPS receipt to the next, and the first period also counts on-hand stock. The full discrete and cumulative ATP calculation, with a worked customer request, is in worked example 3 of what is a master production schedule.

Step 4: Run Rough-Cut Capacity Planning (RCCP)

Before finalizing the MPS, validate that you have the capacity to execute it. RCCP checks aggregate capacity at critical resources:

• Does the MPS overload any key work center?
• Are any weeks significantly over or under capacity?
• Are capacity shortfalls addressable through overtime, subcontracting, or schedule smoothing?

If RCCP reveals capacity problems, adjust the MPS before it drives MRP and detailed scheduling. It is much cheaper to move orders between weeks at the MPS level than to discover the problem on the shop floor.

Step 5: Finalize and Publish

Once the MPS is validated against capacity, publish it. The MPS becomes the driving input for:

• MRP - calculating material requirements and generating purchase orders
• Detailed scheduling - loading jobs against specific machines using finite capacity scheduling
• Sales - confirming delivery dates and managing customer expectations

Maintaining the MPS

An MPS is a living document. Here is how to keep it accurate and useful:

Weekly MPS Review Meeting

Hold a 30-60 minute weekly meeting with representatives from sales, operations, and materials. The agenda:

1. Review MPS performance from the prior week (did actual production match the plan?)
2. Update the demand picture (new orders, forecast changes, cancellations)
3. Address capacity issues for the coming weeks
4. Extend the MPS horizon by one week
5. Approve any changes to the frozen zone

This meeting is the single most important planning discipline a manufacturer can adopt.

Performance Metrics

Track MPS adherence - the percentage of MPS line items produced as planned:

MPS Adherence = (MPS items produced on schedule / Total MPS items) x 100

Target: 95%+ in the frozen zone. If adherence is consistently below 90%, either the MPS is unrealistic or shop floor execution needs improvement.

Managing Demand Changes

When demand changes (and it always does):

• Evaluate the impact on materials and capacity before approving
• Respect time fences - push back on changes in the frozen zone unless truly exceptional
• Document changes and their reasons to identify patterns (if the same customer constantly changes, address it commercially)
• Communicate approved changes to all affected departments immediately

Connecting MPS to Detailed Scheduling

The MPS generates planned orders that feed into detailed scheduling. Here is how the handoff works:

1. The MPS says "Produce 200 units of Part A in Week 15"
2. MRP explodes this into raw material requirements and generates planned production orders
3. The planned orders are released to the scheduling system
4. RMDB from User Solutions, now continued as EDGEBIC (RMDB 2.0) by User Solutions, loads these orders against specific machines using finite capacity scheduling
5. The scheduler uses EDGEBI's Gantt chart to visualize and fine-tune the detailed schedule
6. The shop floor executes the schedule and reports completions

When this chain works smoothly, the MPS targets become the shop floor reality. When it breaks - typically due to poor MPS maintenance, inaccurate data, or lack of finite capacity scheduling - the gap between plan and execution widens.

Common MPS Mistakes

Over-stating the MPS. Loading more into the MPS than the plant can produce creates a permanent state of being behind schedule. Be honest about capacity when setting MPS quantities.

No time fences. Without frozen and slushy zones, the MPS changes constantly, MRP churns, purchase orders are revised daily, and the shop floor cannot execute.

Disconnected from scheduling. An MPS that is not validated against finite capacity at the detailed level may be infeasible even though RCCP approved it. The aggregate view can hide bottleneck-level overloading.

No weekly review. An MPS that is set once and not maintained degrades rapidly as demand changes and actual production deviates from plan.

The MPS is not glamorous, but it is foundational. Manufacturers who maintain a disciplined MPS consistently outperform those who do not - in delivery performance, material availability, and scheduling effectiveness.

For the software side, see master production schedule software. Contact User Solutions to learn how RMDB and EDGEBIC connect your MPS to detailed finite capacity scheduling for seamless planning-to-execution flow.