Master Production Schedule: A Practical MPS Guide

Home » Resources » Master Production Schedule: A Practical MPS Guide

Estimated reading time: 13 minutes

A master production schedule (MPS) states which products or selected planning items a manufacturer intends to produce, in what quantities and in which periods. It connects demand with build commitments. A detailed production schedule then assigns the operations behind those commitments to resources and times.

Consider products A and B. Their projected inventory can look sufficient for the next planning period while their production jobs compete for the same workstation. The product plan balances, but the execution sequence may not fit. A useful MPS process identifies that conflict before the factory promises a delivery date.

What belongs in a master production schedule?

The MPS sits between the business’s aggregate production direction and the detailed work needed to deliver individual items. It makes selected item-level commitments visible to sales, purchasing and production, so they can work from the same plan.

Choose the planning level to suit the manufacturing environment. A make-to-stock business commonly plans finished items against demand and inventory targets. A make-to-order business may base the selected items on firm customer commitments. An assemble-to-order business may plan important assemblies or options before the final configuration is known. The practical test is whether the chosen item level supports a meaningful build decision.

Each MPS record needs an item, a period and a planned quantity available in that period. Supporting information normally includes beginning inventory, demand, already scheduled receipts and projected available balance. Keep completion or availability dates distinct from operation start dates: a receipt belongs in the period when the product is available, even if its manufacturing starts earlier.

Planning layer	Main decision	What it means for A and B
S&OP and aggregate production planning	Product-family demand and supply direction	Agree the overall volume and resource direction for their family
MPS	Selected item quantities and availability periods	Commit to builds of A and B
MRP, material requirements planning	Time-phased component requirements	Calculate components needed behind those builds
Detailed production scheduling and APS	Resource assignment, timing and sequence	Place A and B’s operations on workstations with their constraints

Planning hierarchy sources: OptiProERP’s MPS explanation and MRPeasy’s MPS guide, reviewed October 4, 2026. The table is an instructional summary, not either vendor’s interface.

The S&OP process in manufacturing provides the family-level context. MRP here means material requirements planning, sometimes called MRP I. Manufacturing resource planning, or MRP II, is a broader planning concept; it is not a different name for this component calculation alone.

Build an MPS example with your own A and B figures

Start with A and B’s actual demand, inventory and open production records. The table below is a reader-input calculation layout: its symbols represent quantities from your records, not a factory benchmark. Use successive planning periods that match your decision process.

For each item and period, use these quantities:

• I: beginning inventory available to the plan.
• O: firm customer orders due in the period.
• F: residual forecast demand after the applicable forecast-consumption process.
• R: scheduled receipts from production already included in the plan.
• Q: new MPS receipts proposed for the period.
• D: demand counted by the agreed demand policy.
• P: projected available balance at the end of the period.

Item and period	Beginning inventory	Firm orders	Residual forecast	Scheduled receipts	New MPS quantity	Projected balance
A, current period	I(A)	O(A)	F(A)	R(A)	Q(A)	I(A) + R(A) + Q(A) − D(A)
A, next period	Previous P(A)	Next O(A)	Next F(A)	Next R(A)	Next Q(A)	I(A) + R(A) + Q(A) − D(A)
B, current period	I(B)	O(B)	F(B)	R(B)	Q(B)	I(B) + R(B) + Q(B) − D(B)
B, next period	Previous P(B)	Next O(B)	Next F(B)	Next R(B)	Next Q(B)	I(B) + R(B) + Q(B) − D(B)

Calculation concepts: the MPS inputs, inventory, demand and lot-sizing sections of the MRPeasy guide linked above, reviewed October 4, 2026. This original A/B layout uses reader records and separates existing receipts from new proposals.

First settle forecast consumption. If customer orders have already consumed part of the forecast, adding those orders to the original total forecast counts some demand twice. Where your policy defines demand as firm orders plus remaining, unconsumed forecast, D is O + F. A policy that uses the larger of orders and forecast needs its own matching assumptions about periods and consumption. That shortcut is not a universal substitute for forecast consumption.

Next calculate the balance: beginning inventory plus scheduled receipts plus new MPS receipts, minus demand. Carry the result forward as the next period’s beginning inventory. A production quantity must appear once. When a proposed Q becomes an existing scheduled receipt R, remove it from the proposal column or the plan will count the same supply twice.

Now compare each projected balance with the item’s inventory target. If A falls below its safety-stock target, its proposed build may need to increase or arrive earlier. Apply A’s actual lot-size constraint to that proposal, then recalculate later balances. Rounding a batch upward changes inventory and resource load; it is not a free correction. Repeat for B with B’s own lot-size and inventory settings.

Available-to-promise, or ATP, is uncommitted supply still available to promise against firm orders over the relevant interval. Projected ending inventory is a period balance after subtracting all demand counted by the planning policy, including residual forecast where applicable. Use the ATP method defined by your planning system when making an additional customer promise.

The table gives an inventory test. The next test is whether A and B can actually be built in time.

Check capacity before accepting A and B’s build dates

A rough-cut capacity planning check compares the critical-resource load implied by the MPS with available capacity. For A and B, begin with their shared workstation. Use the planned quantities, relevant processing requirements and available shift capacity to see whether their combined load fits the intended period.

An overload calls for a business decision. You might change a build quantity, move a commitment, authorize a different shift pattern or choose a different priority. Verify that the chosen option is genuinely available before revising the customer promise.

Even a passing period-level check leaves a sequencing question. A and B can both fit in the total workstation hours yet conflict at a particular time because one needs an earlier process step, a setup, an operator or material that is not ready. Period totals compress those relationships.

That is where finite capacity scheduling becomes useful. The detailed model needs routings, operation durations, setup times, resource availability and dependencies. The inventory balance says A and B’s planned supply is sufficient. The resource sequence shows whether the operations can deliver that supply by the planned dates.

Where the MPS becomes an executable schedule in SkyPlanner

In SkyPlanner, define the workstations, shifts, operators, priorities and materials behind A and B, and keep those inputs current as conditions change. Their order items contain products and process steps, including time calculation and setup settings. The King button triggers Arcturus to recalculate the production schedule using priorities, workstation capacities and tool availability. With Consider the materials enabled, available materials, incoming shipments and inventory also influence start timing. Inspect A and B in the Gantt’s workstation lanes, follow the connected process steps and open Job Details to check the work behind each commitment. This is the detailed execution layer of advanced planning and scheduling software; the product-level MPS remains the planning context.

SkyPlanner integrates with any ERP or MES system through its open REST API. It complements your ERP with automatic job scheduling, so the product commitments and relevant orders can be connected to their execution through an ERP and MES integration. Planners decide the priorities; Arcturus calculates the resulting schedule. To explore that handoff, try SkyPlanner with demo data or Book a demo using A and B’s routing and resource constraints as the discussion case.

Keep A and B stable when demand or materials change

Suppose B’s incoming material arrives later than the plan expected. Updating only B’s product-level receipt date leaves the detailed production input out of sync. Update the material information used for scheduling, confirm that Consider the materials is enabled, recalculate and inspect where B now sits relative to A.

Use an exception card to connect the business decision to the scheduling action:

A/B exception	Planner decision	Scheduling input or control	Inspect after recalculation
A and B compete for their shared workstation	Confirm which commitment has priority, or revise capacity or dates	Current workstation and shift data; selected Dynamic Priorities; King button	A/B placement in the workstation lane and connected process steps
B’s incoming material slips	Decide whether B’s commitment must move	Updated material arrival information; Consider the materials enabled; King button	B’s new timing and its position relative to A
Near-term A work must remain stable	Choose the jobs to protect while later work changes	Running Time Lock for near-term jobs	Protected A jobs and the remaining B sequence

Control mapping sources: SkyPlanner knowledge-base articles 775, SkyPlanner: The Basics; 835, Consider the Materials; and 632, master schedule and project detail, reviewed October 4, 2026. This is an instructional mapping, not a measured production result.

A planning time fence governs which business-level MPS changes need control or approval. SkyPlanner’s Running Time Lock protects near-term jobs from Arcturus rescheduling. Keep the two responsibilities clear: a job lock protects scheduling placement, while the planner still decides whether an MPS commitment should change.

The documented setup guidance also matters when A and B compete. Setting every Dynamic Priorities bar to maximum makes everything equally important. Adjust the relevant priorities selectively, and check process durations, setup, shifts and dependencies before judging the new placement. A stronger priority does not create another workstation or make B’s missing material arrive.

MPS vs MRP: what goes into each plan?

The MPS specifies the product-level supply decision. MRP works through the material requirements behind that decision. For A and B, their planned build quantities provide demand for components; the bills of materials, inventory and lead times determine what materials are needed and when.

Question	MPS	MRP
What is being planned?	Selected products or planning items	Components and materials behind planned production
What drives the calculation?	Demand policy, inventory, receipts and build commitments	Product requirements, BOMs, inventory and lead times
What does the planner inspect?	Build quantities, periods and projected balances	Time-phased material requirements and resulting supply proposals
What changes when B moves?	B’s planned availability period	Timing of the component requirements associated with B

Relationship sources: OptiProERP and MRPeasy guides linked above, reviewed October 4, 2026.

The MRP guide explains the material-planning layer; the ERP bill of materials guide explains the product structures it relies on. Keep the records aligned when revising A or B. Moving B’s build period without reviewing its component timing can leave purchasing and production working toward different dates.

Detailed scheduling adds the operation-level check. A component plan can identify material demand, while the job sequence still has to account for the actual workstation timing and dependencies. Treat the item balance, material plan and resource schedule as connected decisions with different outputs.

Decide the next step from the failure you find

Choose the corrective action by the level at which A and B’s plan fails:

• If A’s projected inventory is below target, reconcile demand, receipts and its proposed build quantity first.
• If A and B overload the critical resource, revisit capacity or commitments before accepting the period.
• If the totals fit but B cannot start because of material timing or dependencies, validate the detailed scheduling inputs and inspect the operation sequence.
• If the schedule repeatedly moves protected near-term work, check how the stability decision is represented through job locking.

For an execution-focused evaluation, bring the selected A/B items and build periods, their routings, processing and setup information, workstations and shifts, chosen priorities, and current material arrival information. These make the planning handoff concrete. Accurate inputs let you evaluate the schedule behind your commitments; software cannot make an incorrect inventory record true.

Frequently asked questions

What is a master production schedule?

An MPS is an item-level production plan specifying quantities and availability periods. Its planning items depend on the manufacturing environment: finished products, selected assemblies or other appropriate items. For A and B, the useful output is a clear build commitment supported by a consistent inventory balance and a capacity check.

What is the difference between MPS and MRP?

MPS establishes the selected product builds; MRP calculates the material requirements behind them. If B’s planned production moves, its component timing may need to move too. Keep product commitments and material planning connected, while checking the detailed resource sequence separately before treating the changed build date as executable.

How do you calculate projected available balance in an MPS?

Add beginning inventory, existing scheduled receipts and new MPS receipts, then subtract the demand defined by your planning policy. Carry the ending balance into the next period. In the A/B table, keep a build in either existing receipts or new proposals so that its supply is counted only once.

Should you add forecast demand and customer orders together?

Only when the forecast portion represents demand still unconsumed by those orders under your company’s policy. Adding firm orders to the original total forecast can double-count demand. Check which periods and items the consumption process covers before using A and B’s demand totals to calculate their proposed builds.

What is the difference between an MPS and a detailed production schedule?

A revision to B’s MPS changes the product commitment; a revision to B’s detailed schedule changes how its work is carried out. When inspecting a change, ask whether it affects the promised supply, the operation placement, or both. That distinction identifies which planning records and execution inputs need updating together.

How do safety stock, lot sizes and capacity affect an MPS?

Safety stock sets an inventory target, lot sizes constrain build quantities, and capacity tests whether the resulting workload fits. Increasing A’s batch to satisfy its lot size may raise inventory while worsening its shared-resource conflict with B. Recheck both the inventory balances and the resource load after changing the quantity.

Can you use Excel for master production scheduling?

A spreadsheet can represent the MPS grid and its inventory calculations. The practical challenge is maintaining consistent demand, receipts and inventory while conditions change. For A and B, also evaluate how you will check the shared-resource sequence and keep the product plan aligned with the detailed schedule used by production.

Does SkyPlanner replace the MPS or ERP?

SkyPlanner complements ERP with automatic detailed production scheduling. In this workflow, keep A and B’s product-level build commitments in their planning context and use SkyPlanner to schedule the jobs behind them. Its open REST API supports ERP or MES integration; the Gantt lets you inspect the resulting workstation sequence.