# Master Production Schedule (MPS) Template > Source: https://netray.co/tools/master-production-schedule-template > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A weekly MPS grid with forecast, customer orders, projected on hand and planned production quantity for a single product. ## Category manufacturing ## Audience - Master scheduler - Production planner - Operations manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Week **Key:** week **Type:** text #### Forecast **Key:** forecast **Type:** number **Unit:** units #### Customer orders **Key:** orders **Type:** number **Unit:** units #### Demand used **Key:** demand **Type:** number **Expr:** max(forecast, orders) **Unit:** units **Help:** Larger of forecast and booked orders #### Projected available (start) **Key:** begin_oh **Type:** number **Unit:** units **Help:** Previous row ending balance #### MPS quantity **Key:** mps **Type:** number **Unit:** units **Help:** Planned production completing this week #### Projected available (end) **Key:** end_oh **Type:** number **Expr:** begin_oh - demand + mps **Unit:** units #### Shortfall **Key:** short **Type:** number **Expr:** max(0, 0 - (begin_oh - demand + mps)) **Unit:** units **Rows:** **Week:** W1 **Forecast:** 60 **Orders:** 70 **Begin oh:** 40 **Mps:** 100 **Week:** W2 **Forecast:** 60 **Orders:** 55 **Begin oh:** 70 **Mps:** 0 **Week:** W3 **Forecast:** 60 **Orders:** 40 **Begin oh:** 10 **Mps:** 100 **Week:** W4 **Forecast:** 60 **Orders:** 20 **Begin oh:** 50 **Mps:** 100 **Week:** W5 **Forecast:** 60 **Orders:** 10 **Begin oh:** 90 **Mps:** 0 **Week:** W6 **Forecast:** 60 **Orders:** 0 **Begin oh:** 30 **Mps:** 100 **Totals:** #### Total demand used **Key:** demand **Agg:** sum **Format:** integer #### Total MPS quantity **Key:** mps **Agg:** sum **Format:** integer #### Lowest projected available **Key:** end_oh **Agg:** min **Format:** integer **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How to use the template **Body:** 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 **Body:** 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. **Bullets:** - 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 **Body:** 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 **Body:** 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. **Cta:** 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. **Faq:** #### What is a master production schedule? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms master production schedule template, mps template excel, master production schedule example, mps projected available balance, how to create a master production schedule, master schedule worksheet, mps forecast vs customer orders --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json