Master Production Schedule (MPS): Steps & Example
6 min read
By
TranZact Solutions Team
· Published


A master production schedule (MPS) is a week-by-week plan that says which finished products a factory will make, how many and when. It is built from customer orders, the sales forecast, stock on hand and plant capacity. The MPS then drives material planning (MRP). Once you know what you will build each week, the BOM tells you what raw material to buy and when.
Any manufacturer that has to match orders, stock and capacity week by week needs one.
What is a master production schedule?
An MPS lists finished goods only, by week, with quantities. A valve maker's line might read: "2-inch gate valve: 200 in week 1, 200 in week 4."
It is not a raw-material plan or a daily machine schedule.
Our guide on aggregate planning vs MPS covers the step above it: the monthly plan by product family.
What goes into an MPS
Customer orders: confirmed quantities and due dates.
Sales forecast: what you expect to sell but have not booked yet.
Opening stock: finished goods on hand today.
Safety stock: the buffer you never want to go below.
Lot or batch size: the quantity you make in one run.
Lead time: how long it takes to buy material and make the product.
Capacity: machine and labour hours available each week.
What an MPS looks like
An MPS is a grid. Weeks run across the top and five rows run down the side.
Forecast: expected demand per week.
Customer orders: demand already booked.
Projected available balance (PAB): stock you expect at the end of each week.
MPS quantity: what you plan to finish that week.
Available to promise (ATP): what sales can still promise (explained under time fences below).
How to create a master production schedule in 6 steps
List the end items. Plan finished products or key assemblies, not every part.
Pick weekly buckets and a horizon. Look ahead at least as far as your longest buy-plus-make lead time.
Enter orders and forecast. For each week, plan to the larger of the two numbers.
Calculate projected stock. Start from opening stock and subtract demand each week. When the balance drops below safety stock, add one MPS lot.
Check capacity. Compare the hours your MPS needs with the hours you have. Our guide to capacity requirements planning covers this check.
Freeze, release and plan material. Lock the near weeks, release work orders and run MRP.
Worked example: a 6-week MPS for a valve maker
Take a small valve maker planning its 2-inch gate valve. Opening stock is 120, safety stock is 50 and each production lot is 200. The numbers are illustrative.
The grid is turned sideways here, so weeks run down the page.
Step 1: Demand per week
Week | Forecast | Customer orders | Demand used |
|---|---|---|---|
1 | 80 | 100 | 100 |
2 | 80 | 70 | 80 |
3 | 90 | 60 | 90 |
4 | 90 | 40 | 90 |
5 | 100 | 20 | 100 |
6 | 100 | 0 | 100 |
Demand used is the larger of the two.
Step 2: Lots, balance and ATP
Week | MPS lot | Projected balance | ATP |
|---|---|---|---|
1 | 200 | 220 | 90 |
2 | – | 140 | – |
3 | – | 50 | – |
4 | 200 | 160 | 140 |
5 | – | 60 | – |
6 | 200 | 160 | 200 |
Week 1: 120 minus 100 leaves 20, below safety stock. One lot of 200 brings the balance to 220.
Weeks 2–3: The balance falls to 140, then 50. That still meets safety stock, so no new lot.
Week 4: 50 minus 90 would be minus 40. A lot of 200 lifts it to 160.
Weeks 5–6: In week 5, 160 minus 100 leaves 60. In week 6 it would drop to minus 40, so another lot brings it to 160.
ATP: stock plus the lot, minus orders booked until the next lot. Week 1 is 120 + 200 − 230 = 90. Week 4 is 200 − 60 = 140.
Each lot then becomes a material plan: 200 valves times the BOM gives the bodies, wedges and stems to buy.
In a spreadsheet, every new order means redoing this grid and the purchase list by hand.
MPS vs MRP vs production schedule
Plan | What it plans | Time bucket | Output |
|---|---|---|---|
MPS | Finished products | Weekly | What to make and when |
MRP | Raw material and parts | Weekly or daily | What to buy and when |
Production schedule | Machines, shifts and operators | Daily or by shift | Who runs which job, where |
From MPS to the shop floor
MPS sets weekly finished-goods quantities
MRP works out material from the BOM
Indent raised, RFQ sent to suppliers
PO placed, material received on GRN
Work order releases the job
Time fences and available to promise, in plain words
A time fence splits the plan into zones by how easy it is to change.
Frozen zone: the next week or two. Material is bought and jobs are on the floor. Changes need the plant head's sign-off.
Slushy zone: the weeks after that. You can swap products or quantities if material is available.
Free zone: the far weeks. Nothing is committed yet, so anything can change.
Available to promise is what sales can still commit without disturbing the plan. In the example, a new order for 80 valves in week 2 fits inside the ATP of 90. An order for 120 would have to wait for the week 4 lot.
Who owns the MPS and how often to update it
The production planner owns it. In a smaller plant, that is usually the plant head or the owner.
Review it every week with sales and purchase team members.
Weekly MPS review checklist
Load new orders and updated forecast
Recheck finished stock against safety stock
Run a rough-cut capacity check
Lock the frozen weeks
Rerun the material plan
5 MPS mistakes small factories make
Planning from the forecast only. Booked orders get missed when the forecast runs low.
No safety stock. One rush order empties the shelf.
No capacity check. The plan needs more hours than the plant has.
Changing this week's plan every day. The floor stops trusting it.
Copying the plan by hand into the purchase list. Quantities get missed or copied wrong.
Where TranZact fits
TranZact does not build your MPS for you. The demand forecast, shift plans and headcount calls stay with your planner.
TranZact's MRP engine runs through the orders and BOMs behind your MPS, then tells you what to buy and when.
From there, purchase runs as MRP report, indent, RFQ, PO and GRN in TranZact's purchase management. TranZact's AI reads supplier invoices and matches them to the POs they belong to.
On the floor, production management covers multi-level BOM, work orders, process routing, sub-contracting and production costing. Machine planning is on the Dominate plan.
Accounts stay in Tally, with one-way sync and no double entry. Planning (MRP + Indent) is on every current plan, from Grow at ₹8,333 a month billed yearly (see pricing).
TranZact is manufacturing AI software used by 10,000+ manufacturers. Live in 2–3 weeks. Comparing tools? Our MRP software buying guide lists what to check.
Plan the week, not the firefight
See your own orders and BOMs run through MRP in TranZact. Don't be the bottleneck. Become the AI-Run Factory.




