Master Production Schedule (MPS): Steps & Example

6 min read

By

TranZact Solutions Team

· Published

Hero Background
Functions of ERP System Explained

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

  1. List the end items. Plan finished products or key assemblies, not every part.

  2. Pick weekly buckets and a horizon. Look ahead at least as far as your longest buy-plus-make lead time.

  3. Enter orders and forecast. For each week, plan to the larger of the two numbers.

  4. Calculate projected stock. Start from opening stock and subtract demand each week. When the balance drops below safety stock, add one MPS lot.

  5. Check capacity. Compare the hours your MPS needs with the hours you have. Our guide to capacity requirements planning covers this check.

  6. 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.

Book a demo →

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
  1. MPS sets weekly finished-goods quantities

  2. MRP works out material from the BOM

  3. Indent raised, RFQ sent to suppliers

  4. PO placed, material received on GRN

  5. 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

  1. Planning from the forecast only. Booked orders get missed when the forecast runs low.

  2. No safety stock. One rush order empties the shelf.

  3. No capacity check. The plan needs more hours than the plant has.

  4. Changing this week's plan every day. The floor stops trusting it.

  5. 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.

Book a demo →

Check out other blogs

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders