Master production schedule: example and Excel template

A master production schedule, or MPS, sets the finished products you plan to make, their quantities and the periods in which you need them. In Optiwise, we connect that plan with orders, stock, material requirements and production work, so you can check what is ready and what still needs action.

Download the weekly finished-goods planning worksheet

weekly finished-goods planning worksheet (Excel workbook) includes a worked example and a separate sheet for your inputs. Blue cells are editable; formula cells calculate the result. Replace the illustrative figures with your factory records.

Build the plan from demand and usable finished stock

Choose one finished item and a common unit. Enter customer demand once for each period. If you also use a forecast, decide how actual orders replace or consume it; adding both in full can double the requirement. Start from usable finished goods, keeping rejected or quality-held stock out of that opening quantity.

The worksheet carries each closing balance into the next period. Closing stock equals opening stock plus confirmed other receipts plus planned output, less demand. Its gap column shows when the planned closing balance falls below your chosen buffer. Other receipts exclude the new output already entered in the plan.

Work through four weeks before releasing jobs

Our illustrative example begins with 300 pieces. Weekly demand is 200, 350, 250 and 200 pieces: 1,000 in total. Planned output of zero, 350, 250 and 200 pieces totals 800. With no other receipts, the plan closes each week at 100 pieces. Across the full horizon, 300 + 800 − 1,000 = 100.

That arithmetic establishes a quantity plan. Before releasing week two’s 350 pieces, check the approved BOM, material availability, machine capacity, skilled people and delivery dates. A positive month-end balance does not prove that material will be available on the day a job starts.

Separate finished-goods planning from material planning

The MPS identifies finished output. Material requirements planning uses the BOM and supply position to determine what must be bought, made or sent outside. Our material planning guide follows a bearing shortage through that decision. Odoo’s MPS documentation illustrates the distinction between planned demand and replenishment; the worksheet here is our original example.

Use the plan in Optiwise

Review sales demand, BOMs, available stock, open purchase orders and existing production in one system. Smart Suggest helps identify the quantities still needing in-house work, buying or subcontracting. The planner reviews the proposed work and resource availability before release; supervisors then record progress against the job.

If a customer brings a delivery date forward, identify the affected period and linked work. Recheck material and capacity before changing the promise. Keep the earlier plan and reason for the change so the next review can explain what happened.

Plan one finished item with your team

Bring its demand, usable stock, BOM and one constrained operation. Follow the planned quantity into material and production work. Explore the Optiwise workflow or book a factory walkthrough. We charge ₹0 for implementation. Subscription, optional add-ons and IoT hardware are separate.