Master Production Schedule (MPS) Template
The master production schedule says what you will build and when, and it drives the whole MRP run underneath. This template gives a master scheduler a simple weekly grid to balance demand, supply and inventory for one product.
| Week | Forecast (units) | Customer orders (units) | Demand used (units) | Projected available (start) (units) | MPS quantity (units) | Projected available (end) (units) | Shortfall (units) | |
|---|---|---|---|---|---|---|---|---|
70 | 70 | 0 | ||||||
60 | 10 | 0 | ||||||
60 | 50 | 0 | ||||||
60 | 90 | 0 | ||||||
60 | 30 | 0 | ||||||
60 | 70 | 0 |
This sheet uses the larger of forecast and orders as demand, a common simplification. Many plants use forecast beyond the demand time fence and orders inside it. Copy each end balance into the next week's start balance. A positive shortfall means the MPS quantity must increase or the date must move.
Connect your MPS to live ERP data
Optional: ask how forecast, orders and stock could feed this grid automatically.
Optional. The tool and every export work without this. No spam.
How to use the template
Enter the weekly forecast and booked customer orders. The sheet uses the larger of the two as demand. Enter the starting available balance, then the MPS quantity you plan to complete each week. The ending balance is start minus demand plus MPS. Adjust MPS quantities, usually in multiples of your build lot, until the balance never falls below zero or your safety level.
The logic of an MPS
An MPS is built for end items or key planning items, in time buckets, within a planning horizon longer than cumulative lead time. It must respect capacity, which is why a rough cut capacity check follows. Orders inside the demand time fence are firm and forecast beyond it. The schedule is the input to MRP: whatever you put in the MPS row becomes gross requirement for components.
- Plan on end items or planning bills.
- Respect the build lot or run size.
- Check capacity before releasing.
- Keep the near term firm.
Reading the example
Weeks 1, 3, 4 and 6 receive a batch of 100, with nothing built in weeks 2 and 5 when balance is sufficient. The lowest balance is 10 in week 2, which is thin but positive. A scheduler would look at that and decide whether the 10 units is enough safety against a demand spike, or whether week 2 needs an extra smaller run.
Common mistakes
Planners often load the MPS without checking capacity, then spend weeks expediting. Others change near term quantities freely, causing component churn. A third mistake is netting forecast against orders twice, inflating demand. Agree a change policy: what can move, by whom, and how far out.
Frequently Asked Questions
What is a master production schedule?
It is a time phased plan of quantities of end items to be produced, derived from forecast and customer orders, constrained by capacity and inventory targets. It feeds MRP, which plans the components.
How far ahead should the MPS plan?
At least as far as the cumulative lead time of the product, so long lead components can be ordered in time. Many plants plan 3 to 12 months, with weekly buckets near term and monthly further out.
What is the difference between MPS and MRP?
MPS plans finished goods or key items and is controlled by a master scheduler. MRP takes that plan and explodes it to components, planning purchase and shop orders for everything beneath.
Why use the larger of forecast and orders?
It prevents under-planning when orders exceed forecast and avoids double counting when orders are part of the forecast. It is a simple rule; consumption based methods are more accurate but need more setup.
Netray can pull forecast, orders and on hand from your ERP into a live MPS view so the scheduler works from current data instead of a pasted spreadsheet.
Related Tools
Available to Promise (ATP) Calculator
Calculate discrete ATP from on hand, scheduled MPS quantities and committed customer orders, and find the earliest period that can cover a new request.
Supply Chain & InventoryMRP Planning Time Fence Calculator
Derive a demand time fence and planning time fence from your lead times and see how much of the horizon is frozen.
Supply Chain & InventoryMRP Gross to Net Calculation Worksheet
Work the classic MRP logic row by row: gross requirements, scheduled receipts, projected on hand and safety stock into net requirements and planned receipts.
Supply Chain & InventoryLot for Lot vs Fixed Order Quantity Simulator
Compare the annual cost of ordering exactly what is needed each week against ordering a fixed batch, and see where the cost curve bottoms out.
More Discrete Manufacturing tools
See all- OEE Calculator (Overall Equipment Effectiveness)
- Scrap Rate Cost Calculator
- Takt Time Calculator
- Cycle Time & Capacity Calculator
- Inventory Carrying Cost Calculator
- Economic Order Quantity (EOQ) Calculator
- MRP Nervousness Assessment
- Production Scheduling Maturity Assessment
- Shop Floor Digitization Scorecard
Keep exploring
Free tools
- Production Schedule TemplateGenerate a printable weekly production schedule with jobs, setups, due dates, assumptions, risks and sign-off lines.
- Production Schedule Release ChecklistCheck capacity, material, tooling, people, quality and communication before you release a schedule to the floor.
- Planned Order Release Schedule WorksheetTrack planned and firm planned orders to convert or release, with quantities, dates and extended cost. Edit rows and export to Excel.
ERP fixes and how-tos
- MPS in SAP PP: PIRs (MD61), MPS Items and the MD40 RunHow master production scheduling works in SAP PP: the MPS item flag, planned independent requirements in MD61, running MD40, and reviewing results.
- Odoo Manufacturing Reports: Production Analysis, Cost and ForecastBuilt-in Odoo manufacturing and production reports, how to forecast demand and component needs, and how to build custom MRP reports with SQL or Studio.
- How Sales Schedules Work in Infor LN: Releases and Cumulative QuantitiesHow sales schedules work in Infor LN: releases, firm versus planned quantities, cumulative received and shipped, and how to fix a schedule that does not match.
Guides
- Master Production Scheduling Best Practices for SyteLineMaster production scheduling in SyteLine with planning bill configuration, time fence management, rough-cut capacity checks, and schedule stabilization techniques.
- Infor M3 Demand Planning and Forecasting ConfigurationConfigure Infor M3 demand planning with statistical forecasting, forecast consumption, MPS integration, and demand sensing for accurate production scheduling.
- How to Create Production Orders in Infor SyteLineStep-by-step guide to creating and managing production orders in Infor SyteLine CloudSuite Industrial, including job orders, planned orders, and firming workflows.
AI on your ERP
- AI for Dynamics 365 Production Control: Orders, Planning and SchedulingAI for Dynamics 365 F&SCM production control: production orders, BOM and route data, master planning and scheduling, explained in plain English on private servers.
- AI for Sales and Operations Planning, Built on the Numbers Already in Your ERPAI on ERP data for S&OP: forecast review, supply-demand gaps, scenario questions and meeting packs, with the numbers traceable and run on-prem if needed.