MPS Data, Records and Schedule Construction

Introduction

The master production schedule (MPS) converts aggregate production intentions and the demand plan into a time-phased statement of which finished goods, modules, or critical components must be completed, and when. It is the principal interface between sales and operations planning, material requirements planning (MRP), capacity planning, procurement, and shop-floor control.

An MPS is not simply a forecast displayed by week. It is a controlled set of planned supply decisions. Each decision must be consistent with beginning inventory, customer and forecast demand, scheduled receipts, lot-sizing rules, safety-stock policies, lead times, capacity limitations, and the organization’s planning calendar. Poor-quality MPS data can create nervousness, shortages, excessive inventory, expediting, and loss of credibility across the supply chain.

This chapter explains how to select master-scheduled items, establish planning calendars and horizons, construct projected-available-balance records, interpret available-to-promise quantities, and evaluate the managerial implications of alternative schedule designs.

Learning Objectives

After studying this chapter, the reader should be able to:

1. Identify the data required to construct an MPS record.
2. Distinguish master-scheduled items from items planned only through MRP.
3. Establish planning periods, time fences, and planning horizons.
4. Calculate projected available balance, net requirements, and MPS receipts.
5. Apply lot-sizing, scheduled-receipt, safety-stock, and lead-time rules.
6. Construct and interpret a time-phased MPS record.
7. Evaluate schedule feasibility, stability, and customer-service implications.
8. Explain how ERP systems, analytics, and governance support MPS quality.

1. The Role and Scope of the MPS

The MPS specifies the planned production or completion of selected end items over successive planning periods. Depending on the industry, a period may be a day, week, or month. The MPS is normally expressed in units of a stock-keeping unit (SKU), product family configuration, service module, or major subassembly.

The MPS has three connected roles:

• Translation: It translates aggregate plans into item-level production quantities.
• Coordination: It provides the independent-demand input to MRP and capacity planning.
• Commitment control: It creates a disciplined basis for promising deliveries and authorizing manufacturing activity.

The MPS is neither a final shop order nor an unrestricted forecast. It is a planned supply statement that can be revised within defined governance rules. A production order is released only after material, capacity, engineering, and authorization conditions have been satisfied.

Independent and dependent demand

Independent demand originates outside the firm’s production system, such as customer orders, market forecasts, service requirements, or spare-parts demand. Dependent demand is calculated from the planned production of a parent item through the bill of material (BOM). For example, demand for finished bicycles may be independent, whereas demand for wheels and brake assemblies is dependent.

Usually, finished products and selected important modules are candidates for the MPS. Components below the master-scheduling level are planned by MRP, although critical or long-lead components may also be master-scheduled.

2. Selecting Master-Scheduled Items

Selecting the correct planning level is a strategic design decision. If the MPS includes every low-level component, it becomes difficult to maintain and may duplicate MRP logic. If it includes only highly aggregated families, it may fail to represent configuration, capacity, or customer-service requirements.

Criteria for selection

An item is a strong candidate for master scheduling when it has one or more of the following characteristics:

• It is sold or promised directly to customers.
• It has significant value, volume, or strategic importance.
• It has a long cumulative lead time.
• It constrains a bottleneck resource.
• It requires final assembly, testing, customization, or regulatory release.
• Its demand is volatile or difficult to forecast at lower levels.
• It is a service part with high availability expectations.
• It represents a meaningful planning family or option mix.

The choice should also reflect the production environment. Make-to-stock firms commonly schedule finished goods. Make-to-order firms may schedule common modules, option families, or final-assembly capacity. Assemble-to-order firms often master-schedule standard subassemblies and use customer orders to configure final products.

The planning bill of material

A planning bill of material represents product families and option percentages for aggregate planning. The MPS may then be generated for family members or standard modules. A planning BOM must be governed carefully: inaccurate mix percentages can produce a mathematically balanced family plan but an infeasible component plan.

Master-scheduled item versus MRP item

The distinction is not absolute. A component may be master-scheduled if it is critical, common to many products, or subject to a supplier constraint.

3. MPS Data Architecture

A reliable MPS depends on synchronized master data and transaction data. The principal data elements are shown below.

Demand data

Demand may be represented by forecast, booked orders, or a combination. A common policy is to consume forecast with customer orders rather than add both indiscriminately. For period t, one possible demand rule is:

where D_t is planning demand, F_t is forecast demand, and O_t is firm customer-order demand in period t. This is appropriate only when orders are assumed to replace, rather than supplement, the forecast. In other systems, orders consume forecast across a future time window. The policy must be explicit to avoid double counting.

Beginning inventory and inventory status

Beginning inventory is the quantity available at the start of the first planning period. It should exclude unusable, quality-held, allocated, or otherwise unavailable stock unless the planning system models those categories separately. Inventory accuracy is therefore a prerequisite for a credible MPS.

Scheduled receipts

A scheduled receipt is supply already authorized or released, with a known expected receipt period. It may be a purchase order, production order, transfer, or subcontract order. Scheduled receipts must not be confused with planned MPS receipts: the former already exists in the execution system; the latter is a future planning decision.

Lot-sizing rules

Common MPS lot-sizing policies include:

• Lot-for-lot: Planned receipt equals the net requirement.
• Fixed lot size: Every receipt is a specified quantity or a multiple of that quantity.
• Minimum lot size: A receipt must be at least a specified quantity.
• Fixed-period or period-order quantity: One receipt covers requirements over a defined number of periods.
• Economic order quantity: A cost-based quantity may be used where assumptions about setup, holding, and demand are credible.

A lot-sizing policy must be evaluated against setup costs, storage capacity, shelf life, obsolescence, supplier terms, and production flexibility. The lowest apparent unit cost is not necessarily the best policy.

Safety stock

Safety stock protects against demand variation, supply uncertainty, or service-level requirements. It is a policy minimum, not an automatic production quantity. If the projected balance falls below safety stock, the shortfall becomes part of the net requirement.

4. Planning Calendars, Horizons, and Time Fences

Planning calendar

The planning calendar establishes the time buckets used by the MPS. A calendar may include working days, weekends, plant shutdowns, public holidays, maintenance periods, and supplier calendars. Calendar periods must be consistent with the precision of demand and the responsiveness of production. Weekly buckets are useful for medium-term planning, whereas daily buckets may be necessary for short lead-time or highly variable products.

A calendar should specify:

1. Period number and start and end dates.
2. Working-time availability.
3. Fiscal and reporting relationships.
4. Period opening and closing rules.
5. Whether demand is aggregated, shifted, or prorated.
6. Treatment of holidays, shutdowns, and exceptional events.

Planning horizon

The planning horizon is the future interval covered by the MPS. It should be at least as long as the cumulative lead time of the item and its critical components, plus a meaningful decision buffer. If the horizon is shorter than the lead time, the organization cannot see far enough ahead to initiate the actions required to meet future demand.

A useful distinction is:

• Frozen zone: Changes are prohibited or require senior authorization.
• Slushy or partially firm zone: Changes are permitted within limits.
• Liquid zone: Forecast-based replanning is relatively flexible.

The exact boundaries depend on setup time, material lead time, customer commitments, and the cost of schedule changes. Time fences should be based on economic and operational consequences, not arbitrary calendar conventions.

Planning horizon and visibility

A longer horizon improves visibility but does not create accurate knowledge. Forecast uncertainty generally increases with time. Therefore, the MPS should combine a sufficiently long horizon with appropriate aggregation, scenario analysis, and controlled revision. Extending a detailed SKU schedule far into the future may create false precision.

5. Constructing the Projected-Available-Balance Record

The central MPS record tracks supply, demand, and the balance available after each period.

Let:

• PAB_t = projected available balance at the end of period t;
• PAB_{t−1} = projected available balance at the end of the previous period;
• SR_t = scheduled receipts in period t;
• MPS_t = planned MPS receipt in period t;
• D_t = demand in period t.

The fundamental recurrence is:

For the first period, beginning inventory replaces the previous balance:

where BI is beginning inventory. All quantities must use the same item, unit of measure, and time bucket. The equation assumes that receipts are available within the stated period and that demand is deducted in a consistent sequence. If the organization distinguishes beginning-of-period and end-of-period availability, the convention must be documented.

Net requirement with safety stock

If no MPS receipt is yet planned, the quantity required to preserve safety stock is:

where NR_t is the net requirement and SS is the safety-stock level. This formula assumes that the scheduled receipt is usable in period t and that safety stock is measured as an end-of-period minimum.

Under lot-for-lot sizing, the planned receipt equals the net requirement:

For a fixed lot size L, a positive net requirement is rounded upward to a multiple of L:

If NR_t = 0, the planned receipt is zero unless another policy creates an intentional build. The ceiling operator, ⌈x⌉, means the smallest integer greater than or equal to x. This formula applies when partial lots are prohibited and excess supply is permitted.

Worked example: fixed-lot MPS record

An item has the following parameters:

• Beginning inventory: 80 units
• Safety stock: 20 units
• Fixed lot size: 50 units
• Scheduled receipt: 30 units in period 2
• Demand: 60, 70, 40, and 90 units in periods 1–4

Assume receipts are available in the period shown and no opening MPS receipt exists.

In period 2, without an MPS receipt, the projected balance would be −20 units. To finish at or above the 20-unit safety stock, the net requirement is 40 units. The fixed lot size requires a 50-unit receipt, producing a 30-unit ending balance. In period 3, the balance before planned supply would be −10 units, so 30 units are required to preserve safety stock; the 50-unit lot creates a 40-unit balance. In period 4, 70 units are required, and the 100-unit lot is selected.

The schedule is feasible only if the production orders can be released early enough to arrive in periods 2–4. If the manufacturing lead time is two periods, receipts in periods 2, 3, and 4 require releases in periods 0, 1, and 2, respectively, subject to the organization’s period-numbering convention.

6. Lead Time and Order Release

The MPS record normally shows receipts, while execution requires release dates. If the lead time is LT periods and there is no additional queue, inspection, or transport delay, a receipt due in period t should be released in period:

This is a planning relationship, not a guarantee. Actual release timing must also consider material availability, capacity, operation sequence, supplier calendars, and order authorization.

Lead time may be fixed, variable, or capacity-dependent. Treating a variable lead time as fixed can produce a formally balanced MPS that cannot be executed. Conversely, inflating every lead time to protect against uncertainty may increase inventory and obscure the real causes of delay.

7. Available-to-Promise and Customer Commitments

Available-to-promise (ATP) identifies supply that can be committed to unallocated customer demand. A simplified first-period calculation is:

The expression must deduct demand already committed through the next relevant supply point. In a standard discrete MPS, if C_1 is customer orders due before the next MPS receipt, then:

For later MPS receipt periods, ATP generally includes the MPS receipt plus scheduled receipts in that interval and subtracts customer orders from the preceding ATP boundary to the current boundary. Organizations vary in whether forecast demand is included in ATP; the policy must be explicit.

ATP is not identical to projected available balance. PAB evaluates total projected inventory after planned demand, whereas ATP evaluates the portion available for additional customer commitments. Confusing the two can lead to over-promising.

8. Schedule Construction Procedure

A disciplined construction procedure is as follows:

1. Define the item and unit of measure. Confirm SKU, configuration, revision, and ownership.
2. Validate the calendar. Confirm periods, working time, holidays, and shutdowns.
3. Establish the horizon and time fences. Ensure adequate visibility for cumulative lead time.
4. Load beginning inventory. Reconcile the quantity with physical and system records.
5. Load demand. Separate firm orders, forecast, interplant demand, service demand, and exceptional requirements.
6. Load scheduled receipts. Verify order status, quantity, due date, and expected quality release.
7. Apply the projected-balance equation. Calculate the balance period by period.
8. Identify safety-stock violations. Calculate net requirements where the balance would fall below policy minimum.
9. Apply lot-sizing rules. Round receipts as required and recalculate all subsequent balances.
10. Offset receipts by lead time. Determine planned release timing.
11. Check capacity and material feasibility. Feed the MPS into rough-cut capacity planning and MRP.
12. Review customer commitments and exceptions. Evaluate shortages, late orders, excess inventory, and ATP.
13. Approve and publish under governance rules. Record assumptions, overrides, and responsible decision makers.

The order matters. Rounding a receipt before calculating the net requirement or failing to roll the resulting excess inventory into later periods can materially distort the schedule.

9. Feasibility, Stability, and Performance

A mathematically valid record may still be operationally infeasible. MPS review should address four dimensions.

Material feasibility

The BOM and inventory records must support the planned completion. Component shortages, supplier minimums, engineering changes, and quality holds may prevent execution.

Capacity feasibility

The schedule must fit labor, machine, tooling, warehouse, and supplier capacity. Rough-cut capacity planning tests key resources at the MPS level. A planned receipt should not be accepted merely because the PAB remains positive.

Stability

Frequent changes to near-term quantities or dates create setup losses, overtime, shortages, and mistrust. Schedule stability can be monitored through the number and magnitude of changes inside the frozen and slushy zones. Stability should not become an excuse to preserve an impossible schedule; controlled exception management is preferable to silent failure.

Performance measures

Useful measures include:

• MPS attainment: actual completion compared with planned completion.
• Schedule adherence: production completed in the planned period.
• Forecast accuracy and bias.
• Customer-service level and late-order rate.
• Inventory turns and days of supply.
• Number of expedites and reschedules.
• Capacity overload by critical work centre.
• Percentage of planned orders released on time.

No single metric is sufficient. Maximizing schedule adherence while creating excessive inventory is not necessarily good performance.

10. Illustrative Case: Northstar Medical Pump Assembly

The following case is fictional and illustrative.

Background

Northstar Medical Devices assembles a regulated infusion-pump module. Demand is independent at the module level, while circuit boards, housings, and tested power units are planned through MRP. The module has a two-week assembly and release lead time. Because of service obligations, the firm maintains a safety stock of 15 modules. Production is carried out in fixed lots of 40.

Problem

Sales has accepted a new hospital order, but the MPS shows positive total inventory over the next six weeks. Customer service believes additional orders can be promised immediately. Operations argues that the positive balances are partly committed to existing orders and that testing capacity is constrained in week 4.

Analysis

The planning team first separates forecast from firm orders and applies the company’s forecast-consumption rule. It then validates the opening inventory, excluding eight units awaiting regulatory inspection. Scheduled receipts are checked against actual test completion dates. The PAB remains positive after these corrections, but ATP is limited because most early supply is allocated to existing customer orders.

The team then offsets planned receipts by the two-week lead time and performs rough-cut capacity analysis. The fixed 40-unit lot in week 4 would exceed testing capacity by 12 units. Two alternatives are evaluated:

1. Move part of the lot into week 3, requiring an earlier release and additional component availability.
2. Retain the week-4 receipt, but negotiate a later customer delivery and protect the frozen zone.

The first alternative is selected after procurement confirms component availability. The revised schedule remains above safety stock, satisfies the hospital due date, and avoids a week-4 testing overload.

Outcome

The MPS is approved with a documented override, a revised ATP promise date, and a capacity exception linked to the testing work centre. The organization avoids both over-promising and unnecessary emergency production.

Learning points

1. Positive PAB does not automatically imply positive ATP.
2. Unusable inventory must not be counted as available supply.
3. Lot size can create excess inventory and capacity peaks.
4. Lead-time offsetting connects planning receipts to executable releases.
5. MPS decisions require cross-functional review rather than isolated spreadsheet manipulation.

11. Technology, Data Governance, and AI

ERP and advanced planning systems automate PAB calculations, BOM explosion, order offsetting, exception messages, and ATP. Their value depends on master-data quality. A sophisticated algorithm cannot correct an incorrect calendar, stale lead time, duplicate order, or wrong unit of measure.

Data governance should assign ownership for item masters, BOMs, lead times, calendars, order status, and safety-stock policies. Changes should be traceable, version-controlled, and approved according to their impact on customers and operations.

AI and machine-learning tools can support demand sensing, anomaly detection, lead-time estimation, and scenario comparison. They should supplement—not replace—planner judgment. In regulated or safety-critical settings, the organization must preserve explainability, authorization, audit trails, and human accountability. Automated recommendations should identify their data sources and confidence limits, particularly when historical patterns are disrupted by product launches, shortages, or geopolitical events.

12. Challenges and Limitations

MPS construction is affected by several recurring limitations:

• Forecast error and demand substitution.
• Inaccurate inventory, BOM, routing, or lead-time data.
• Unrecorded scrap, yield loss, and rework.
• Supplier unreliability and transportation variability.
• Capacity constraints omitted from the initial calculation.
• Excessive schedule nervousness caused by frequent parameter changes.
• False precision from overly detailed long-range forecasts.
• Conflicting objectives among sales, operations, finance, and procurement.

The response is not always to add more safety stock. Better responses may include shorter lead times, improved data discipline, postponement, flexible capacity, supplier collaboration, product modularity, and explicit scenario planning.

Best-Practice Guidelines

1. Master-schedule at the level where meaningful independent decisions are made.
2. Use one agreed calendar and define receipt availability clearly.
3. Reconcile beginning inventory and scheduled receipts before each MPS cycle.
4. State the forecast-consumption and safety-stock policies explicitly.
5. Apply lot sizing consistently and roll excess quantities forward.
6. Offset receipts by realistic, capacity-aware lead times.
7. Separate PAB, ATP, and capacity feasibility measures.
8. Protect near-term commitments with time fences and controlled overrides.
9. Review the MPS cross-functionally and document assumptions.
10. Use exception management to focus attention on material, capacity, and customer risks.

Chapter Summary

The MPS is a time-phased supply plan for selected finished goods, modules, or strategically important components. Its quality depends on accurate demand, beginning inventory, scheduled receipts, safety stock, lot-sizing rules, lead times, calendars, BOMs, and capacity information. Master-scheduled items should be selected where independent demand, customer commitments, bottlenecks, value, or lead-time risk justify direct planning control.

The projected-available-balance record is constructed by adding scheduled and planned receipts to the previous balance and subtracting demand. Net requirements arise when the balance would fall below safety stock, after which lot-sizing rules determine the planned receipt. Lead time converts planned receipts into release requirements. ATP must be distinguished from PAB because positive projected inventory may already be committed.

Effective MPS practice combines quantitative calculation with governance. Planning horizons and time fences balance visibility against uncertainty; feasibility checks connect the schedule to material and capacity realities; and ERP or AI tools are useful only when supported by reliable data, clear accountability, and auditable decisions.

Key Terms

Master production schedule: A time-phased plan for producing or completing selected items.

Master-scheduled item: An item planned directly in the MPS.

Independent demand: Demand originating from customers, markets, or external requirements.

Dependent demand: Demand calculated from the requirements of a parent item.

Projected available balance: Expected inventory balance after receipts and demand in each period.

Beginning inventory: Usable inventory available at the start of the planning horizon.

Scheduled receipt: Previously authorized supply expected in a specified period.

MPS receipt: Planned future supply added by the MPS.

Safety stock: Inventory maintained to protect against uncertainty or service failure.

Net requirement: Supply needed to prevent the projected balance from falling below policy minimum.

Lot size: Quantity rule governing the size of a planned receipt.

Lot-for-lot: A rule in which planned supply equals the calculated net requirement.

Lead time: Time required between release of an order and availability of its output.

Time fence: A boundary controlling the extent to which schedule changes are allowed.

Frozen zone: Near-term planning interval in which changes are prohibited or tightly controlled.

Planning horizon: Future period covered by the MPS.

Available-to-promise: Supply that can be committed to additional customer demand.

Rough-cut capacity planning: High-level test of whether key resources can support the MPS.

Planning bill of material: A family-level BOM used to support aggregate and option planning.

Schedule nervousness: Disruptive instability caused by frequent changes to planned quantities or dates.

Review Questions

Short Answer Questions

1. What is the principal purpose of the master production schedule?
2. Distinguish independent demand from dependent demand.
3. Why must scheduled receipts be separated from MPS receipts?
4. What is the function of a safety stock in an MPS record?
5. Why should the MPS horizon normally cover cumulative lead time?

Long Answer Questions

1. Explain the criteria an organization should use when selecting master-scheduled items.
2. Describe how planning calendars, horizons, and time fences influence MPS quality.
3. Derive and explain the projected-available-balance and net-requirement calculations.
4. Compare lot-for-lot, fixed-lot, and fixed-period lot-sizing policies.
5. Discuss why a positive projected available balance may not justify accepting a new customer order.

Analytical / Application Questions

1. Beginning inventory is 100 units, safety stock is 20 units, demand is 70 units in period 1, 90 in period 2, and 60 in period 3, and a scheduled receipt of 30 units arrives in period 2. With a fixed lot size of 50 units, construct the PAB and MPS receipt record.
2. A planned receipt is required in week 8 and the cumulative lead time is three weeks. Identify the planned release week and discuss two operational conditions that could alter the release decision.
3. A company has positive PAB but repeatedly promises late deliveries. Diagnose three possible data or policy causes and recommend controls for each.

Multiple Choice Questions with Answers

Question 1

Which item is generally the strongest candidate for direct master scheduling?

A. A low-value washer whose demand is fully determined by a parent assembly

B. A finished product with significant customer demand and a constrained final-assembly resource

C. An unissued internal component with no independent demand

D. A packaging label consumed in fixed proportion to production

Correct Answer: B. A finished product with significant customer demand and a constrained final-assembly resource

Question 2

Beginning inventory is 80 units, demand is 60 units, and there are no receipts in period 1. What is the projected available balance?

A. 20 units

B. 60 units

C. 80 units

D. 140 units

Correct Answer: A. 20 units

Question 3

Which equation correctly represents projected available balance for period t?

A. PAB_t = D_t − SR_t − MPS_t

B. PAB_t = PAB_{t−1} − SR_t − MPS_t + D_t

C. PAB_t = PAB_{t−1} + SR_t + MPS_t − D_t

D. PAB_t = PAB_{t−1} × D_t

Correct Answer: C. PAB_t = PAB_{t−1} + SR_t + MPS_t − D_t

Question 4

If the projected balance before planned supply is −10 units and safety stock is 20 units, what is the net requirement before lot-size rounding?

A. 10 units

B. 20 units

C. 30 units

D. −30 units

Correct Answer: C. 30 units

Question 5

A fixed lot size is 50 units and the net requirement is 70 units. What planned receipt is required when partial lots are not allowed?

A. 20 units

B. 50 units

C. 70 units

D. 100 units

Correct Answer: D. 100 units

Question 6

What is the main difference between PAB and ATP?

A. PAB measures capacity, whereas ATP measures labor

B. PAB measures projected inventory, whereas ATP measures supply available for additional commitments

C. PAB applies only to components, whereas ATP applies only to raw materials

D. PAB excludes demand, whereas ATP excludes receipts

Correct Answer: B. PAB measures projected inventory, whereas ATP measures supply available for additional commitments

Question 7

A receipt is required in period 7 and the applicable lead time is two periods. In the simplest offsetting convention, when should the order be released?

A. Period 5

B. Period 6

C. Period 7

D. Period 9

Correct Answer: A. Period 5

Question 8

What is the principal purpose of a frozen time zone?

A. To eliminate all forecasts from the planning system

B. To prevent or tightly control disruptive near-term schedule changes

C. To ensure that every order is planned lot-for-lot

D. To extend the planning horizon indefinitely

Correct Answer: B. To prevent or tightly control disruptive near-term schedule changes

Question 9

Which statement about scheduled receipts is correct?

A. They are future supplies created only by the current MPS calculation

B. They are already authorized supplies expected in specified periods

C. They represent forecast demand not yet converted into orders

D. They are always equal to safety stock

Correct Answer: B. They are already authorized supplies expected in specified periods

Question 10

Why is a capacity check required after constructing a mathematically balanced MPS?

A. A positive PAB guarantees sufficient machine time

B. Capacity constraints can make planned receipts infeasible even when inventory balances are positive

C. Capacity checks replace the need for a BOM

D. Capacity is relevant only after customer delivery

Correct Answer: B. Capacity constraints can make planned receipts infeasible even when inventory balances are positive