Master Production Scheduling

Introduction and context

Master Production Scheduling (MPS) is the formal process of translating aggregate production plans, customer orders, forecasts, inventory policies, and capacity constraints into a time-phased schedule for specific end items. It answers three operational questions:

1. What finished products or major assemblies should be produced?
2. How many should be produced?
3. In which time period should production be completed?

The MPS is a central interface between strategic planning and detailed shop-floor control. The aggregate plan may state that a plant should produce 12,000 units during a quarter, whereas the MPS identifies the models, quantities, and weeks in which those units are required. The MPS then becomes a principal input to Material Requirements Planning (MRP), purchasing, capacity planning, and production dispatching.

An effective MPS must balance three potentially conflicting objectives: customer service, operational efficiency, and schedule stability. Producing too little creates shortages and late deliveries; producing too much increases inventory and obsolescence; changing the schedule excessively creates disruption, expediting, overtime, and loss of credibility.

Learning objectives

By the end of this chapter, the learner should be able to:

• explain the purpose, structure, and planning logic of an MPS;
• distinguish independent demand from dependent demand;
• construct an MPS using forecasts, customer orders, projected inventory, and lot-sizing rules;
• apply planning time fences and evaluate schedule changes;
• calculate available-to-promise (ATP);
• perform a rough-cut capacity check;
• assess schedule stability, customer priorities, and exception conditions; and
• evaluate the managerial, technological, and governance issues surrounding MPS decisions.

1. The role and architecture of the MPS

The MPS normally operates at the end-item or major-assembly level. End items are products sold to customers or items stocked as identifiable finished goods. Components such as motors, fasteners, and circuit boards are generally planned by MRP after the MPS has established the required end-item quantities.

The planning hierarchy is commonly represented as follows:

Strategic business plan → aggregate production plan → master production schedule → MRP and capacity requirements planning → purchasing and shop-floor control

The MPS is not simply a sales forecast. It is a feasible commitment that reconciles:

• anticipated demand;
• confirmed customer orders;
• beginning inventory and safety stock;
• production lead times;
• lot-sizing policies;
• available labour, equipment, and tooling; and
• customer delivery priorities.

A master schedule may be developed for finished products, product families, or important modules. The appropriate level depends on the product structure, demand pattern, planning system, and management needs. A schedule that is too aggregated cannot support detailed execution; one that is excessively detailed becomes costly to maintain and may encourage false precision.

Independent and dependent demand

Independent demand arises directly from external customers and is usually forecast or observed as orders. Dependent demand is derived from the requirement for another item. For example, demand for bicycles is independent, while demand for two wheels per bicycle is dependent. The MPS primarily controls independent-demand items; MRP explodes the bill of materials to calculate dependent requirements.

Planning horizons

The MPS horizon should cover at least the cumulative lead time of the product and often extends beyond it to support purchasing and capacity decisions. It is divided into discrete periods, such as days, weeks, or months. Weekly buckets are common for medium-term planning, while daily buckets may be used near production.

The time bucket must be consistent with the information available. A weekly schedule cannot meaningfully promise a customer a specific Tuesday unless a separate detailed scheduling system supports that promise.

2. Core MPS records and calculations

A typical MPS record contains:

• forecast demand;
• booked customer orders;
• total demand used for planning;
• scheduled receipts or opening supply;
• MPS planned production receipts;
• projected available balance (PAB);
• available-to-promise quantity; and
• exception messages.

Demand used for planning

Many systems use the larger of forecast and customer orders in each period, particularly when orders consume forecast demand. Let:

• Fₜ = forecast demand in period t;
• Oₜ = customer orders in period t;
• Dₜ = demand used for MPS planning.

A common rule is:

This rule is appropriate when orders are assumed to replace, rather than add to, the forecast. If orders are genuinely incremental, the organization must instead define Dₜ as Fₜ + Oₜ or use another agreed demand policy. The rule must therefore be documented; otherwise demand may be double-counted.

Projected available balance

Projected available balance estimates inventory remaining after satisfying planned demand. For period t:

where:

• PABₜ = projected available balance at the end of period t, in units;
• PABₜ₋₁ = projected available balance at the end of the preceding period;
• MPSₜ = planned production receipt in period t;
• SRₜ = other scheduled receipts arriving in period t; and
• Dₜ = demand used for planning in period t.

The opening PAB is the usable beginning inventory, normally adjusted for allocations, quality holds, or safety-stock policy. All quantities must be expressed in the same unit and time period. The calculation assumes that supply received in period t is available to satisfy demand in that period. If the operating convention is that receipts are available only at the end of the period, the timing logic must be altered.

A safety-stock constraint may be stated as:

where SSₜ is the required safety stock in units. If projected inventory would fall below safety stock, the planner adds a planned receipt according to the lot-sizing rule.

Lot-sizing rules

Lot sizing determines the quantity produced when replenishment is required. Common rules include:

For a fixed lot size Q, a planned receipt is generally Q whenever the projected balance would otherwise violate the inventory constraint. The economic order quantity, when its assumptions are appropriate, is:

where Q* is the economic quantity in units per order or setup, D is annual demand in units per year, S is ordering or setup cost per order, and H is annual holding cost per unit. The formula assumes relatively stable demand, constant replenishment lead time, known costs, and no significant quantity discounts or capacity restrictions. It is not automatically an appropriate MPS lot size, especially where setup sequence, perishability, service requirements, or finite capacity dominate.

Worked example: constructing a simple MPS

A company produces Model X. Beginning usable inventory is 80 units and the required safety stock is 20 units. There are no scheduled receipts. The fixed production lot is 100 units. Forecast and customer orders are shown below; orders replace forecast demand when they are higher.

For week 1:

PAB₁ = 80 + 0 − 60 = 20 units.

For week 2, without production the balance would be −70 units, below the 20-unit safety stock. A 100-unit fixed lot is therefore scheduled:

PAB₂ = 20 + 100 − 90 = 30 units.

For week 3:

PAB₃ = 30 + 100 − 80 = 50 units.

For week 4, a 100-unit receipt maintains the balance above safety stock:

PAB₄ = 50 + 100 − 110 = 40 units.

The schedule is inventory-feasible under the stated assumptions. It must still be checked for capacity and material availability.

3. Planning time fences and schedule stability

A planning time fence is a boundary in the planning horizon that governs the degree of change permitted. Time fences are essential because not all future decisions have the same reversibility.

A common structure is:

• Frozen zone: near-term work is protected. Changes require formal authorization because materials may have been purchased, labour assigned, and production orders released.
• Slushy or trading zone: limited changes may be accepted if capacity, materials, and customer impact are assessed.
• Liquid or flexible zone: forecasts and planned orders may be changed relatively freely.

The exact length of each zone depends on cumulative lead time, supplier responsiveness, setup requirements, customer commitments, and production technology. A frozen zone is not necessarily a period in which no change is possible; it is a governance rule requiring a higher level of justification.

A sound change-control process should identify:

1. the requested change and its customer or commercial reason;
2. material, labour, tooling, and capacity consequences;
3. effects on other orders and promised dates;
4. inventory, overtime, subcontracting, and expediting costs;
5. approval authority; and
6. the revised schedule and communication responsibilities.

Schedule stability can be monitored through measures such as the number of changes per period, percentage of orders changed inside the frozen zone, quantity rescheduled, and schedule adherence. A low change count is not automatically good: refusing necessary changes can damage service. Stability must therefore be judged together with delivery performance, inventory, and total cost.

4. Available-to-promise and customer priorities

Available-to-promise (ATP) represents the uncommitted quantity that can be promised to new or existing customers. It must not be confused with projected inventory. Inventory may be physically present but already allocated to customer orders, safety stock, quality investigations, or strategic requirements.

For the first MPS period, a common discrete ATP calculation is:

For a later period containing an MPS receipt:

The summation includes customer orders, not forecast demand, because ATP concerns uncommitted order-taking capacity. The exact convention varies by software and by whether beginning inventory is treated as a receipt. The organization should define whether ATP is calculated by period, customer segment, product variant, or family.

Suppose beginning inventory is 80 units, MPS receipts are 0, 100, 100, and 100 units in weeks 1–4, and customer orders are 50, 90, 60, and 110. ATP is:

• Week 1: 80 − (50) = 30 units, because the next MPS receipt is in week 2.
• Week 2: 100 − (90 + 60) = −50 units. This indicates that the scheduled receipt is already overcommitted if both orders must be supplied from it; the planner must review allocations or promise dates.
• Week 3: 100 − (60 + 110) = −70 units.
• Week 4: 100 − 110 = −10 units.

Negative ATP is a warning, not a quantity that can be promised. It indicates that orders exceed the supply interval and that the MPS, allocations, dates, or customer priorities require review.

Customer priorities should be governed by transparent rules rather than informal pressure. Relevant criteria include contractual due dates, strategic accounts, product criticality, penalty exposure, fairness, and the feasibility of changing production sequence. A priority rule should not conceal poor planning or systematically discriminate against smaller customers.

5. Rough-cut capacity planning

Rough-cut capacity planning (RCCP) tests whether the MPS is broadly feasible at critical resources. It is less detailed than capacity requirements planning because it uses planning bills, historical capacity factors, or key-resource rates rather than every operation and work-centre detail.

For a resource r in period t:

where MPSᵢₜ is the quantity of item i scheduled in period t, Standard hoursᵢᵣ is the required capacity at resource r per unit of item i, and Setup hoursᵣₜ is the planned setup time. Required capacity and available capacity must use the same unit, such as machine-hours per week.

A simple load ratio is:

A ratio above 1.00 indicates overload under the stated assumptions. In practice, organizations may set a lower control limit, such as 0.85 or 0.90, to allow variability, maintenance, absenteeism, and urgent work. The appropriate limit is managerial, not universal.

Available capacity may be estimated as:

Utilization and efficiency must be defined carefully. Utilization commonly represents the proportion of scheduled time during which a resource is operating; efficiency compares achieved output with a standard. Multiplying them can be useful for planning, but double-counting must be avoided.

RCCP example

A weekly MPS schedules 120 units of A and 80 units of B. Each A requires 1.5 hours on the bottleneck machine and each B requires 2 hours. Setup time is 10 hours. The machine has 240 scheduled hours, with expected utilization of 0.85 and efficiency of 0.90.

Required capacity:

(120 × 1.5) + (80 × 2) + 10 = 350 machine-hours.

Available effective capacity:

240 × 0.85 × 0.90 = 183.6 machine-hours.

The load ratio is:

350 ÷ 183.6 ≈ 1.91.

The MPS is clearly infeasible at this resource. Possible responses include moving orders, revising lot sizes, adding shifts, reducing setup time, subcontracting, using an alternate resource, or negotiating delivery dates. Simply releasing the schedule would transfer the problem to the shop floor.

6. Integrated MPS decision process

A professional MPS cycle generally follows these steps:

1. Collect demand information. Integrate forecasts, customer orders, returns, promotions, cancellations, and service obligations.
2. Validate the planning basis. Confirm units of measure, opening inventory, safety stock, scheduled receipts, lead times, and product status.
3. Calculate demand and projected balances. Apply the agreed forecast-order policy and identify shortages or excessive inventory.
4. Apply lot-sizing and timing rules. Place planned receipts in periods that protect inventory and customer commitments.
5. Calculate ATP. Identify uncommitted quantities and possible promise dates.
6. Perform RCCP. Check bottlenecks and other strategically important resources.
7. Apply time-fence governance. Escalate changes in frozen or slushy zones.
8. Resolve exceptions. Reconcile supply, demand, capacity, materials, and customer priorities.
9. Approve and publish. Communicate the authorized MPS to MRP, purchasing, production, sales, and logistics.
10. Monitor execution. Compare actual output, inventory, orders, capacity, and changes with the plan.

The MPS is therefore a recurring decision process rather than a one-time spreadsheet. A rolling horizon adds a new future period as the current period closes, while past periods become actual results for performance analysis.

7. Illustrative case: Northstar Appliances

The following is a fictional illustrative case.

Background

Northstar Appliances manufactures two refrigerator models: Standard (S) and Premium (P). The plant has one compressor-test station that limits weekly output. Management plans a four-week MPS. Beginning finished-goods inventory is 70 S units and 30 P units. Safety stock is 20 units for each model. Production lots are 50 S and 40 P units. Customer orders are firm; forecasts represent additional expected demand only where the planning policy states so.

Problem

Sales has accepted a large Premium order in week 3. The production supervisor reports that the compressor-test station has insufficient capacity if all proposed receipts are retained. The operations manager must construct a feasible MPS while protecting key customer commitments and avoiding unnecessary schedule changes.

Analysis

The proposed demand and capacity data are:

The planning policy uses the larger of forecast and orders. Thus S demand is 40, 60, 50, 60 and P demand is 25, 35, 70, 35. Without production, S inventory falls below safety stock during week 2 and P inventory becomes negative in week 3. Initial lot-sizing suggests S receipts of 50 in weeks 2 and 4, and P receipts of 40 in weeks 2 and 3, subject to capacity.

The compressor-test requirements are 1.0 hour per S and 1.5 hours per P. Weekly effective capacity is 150 hours. The initial proposal for week 3 requires:

(50 × 1.0) + (40 × 1.5) = 110 hours.

This is feasible. However, if the Premium order is treated as requiring an additional 40 units beyond the planning demand, week 3 would require 150 hours for P-related production alone when combined with the standard requirement, leaving no flexibility. The demand policy must therefore be clarified to avoid double-counting the order and forecast.

Approach and solution

The planning team confirms that the week-3 order replaces, rather than adds to, the Premium forecast. It schedules:

This first schedule is not acceptable because it violates safety stock and creates shortages. The team advances one S lot to week 3 and one P lot to week 1, then reviews capacity and supplier readiness. A revised schedule is:

The Premium result remains infeasible because its beginning inventory and lot sizes do not cover week 3 and week 4 demand while maintaining safety stock. Management chooses to authorize an exceptional 40-unit Premium receipt in week 3 from a qualified subcontractor. This is not merely a spreadsheet adjustment: purchasing must confirm quality, capacity, cost, and delivery date.

With the subcontracted receipt, Premium week-3 PAB becomes 20 units and week-4 PAB becomes 25 units if the week-4 lot is retained. The revised plan protects the customer order and remains within the internal test-station capacity, but it creates subcontracting cost and supplier risk.

Outcome and learning points

The case demonstrates that:

• an order-versus-forecast policy must be explicit;
• inventory feasibility does not prove capacity feasibility;
• ATP should be calculated from uncommitted orders, not simply from physical stock;
• time-fence changes need authorization and communication; and
• subcontracting may be a rational capacity response, but it must be governed by quality and commercial controls.

8. Technology, data quality, and contemporary practice

Enterprise resource planning (ERP) systems calculate PAB, ATP, planned orders, and exception messages rapidly, but they do not remove the need for managerial judgment. A system can produce a mathematically consistent schedule from incorrect inventory, obsolete bills of material, inaccurate lead times, or duplicated orders.

Advanced planning and scheduling systems may use finite-capacity algorithms, constraint programming, optimization, and scenario analysis. Artificial intelligence can assist with demand sensing, anomaly detection, parameter recommendation, and identification of likely bottlenecks. Such tools should support—not replace—human review of customer commitments, data provenance, explainability, and operational constraints.

Important controls include:

• cycle counting and inventory reconciliation;
• ownership of forecast and order data;
• version control for schedules;
• audit trails for changes inside time fences;
• master-data governance for lead times, yields, and capacities;
• segregation of duties for schedule approval and order acceptance; and
• monitoring for systematic bias in customer-priority decisions.

Sustainability is also relevant. Lot sizes and schedule choices influence energy consumption, changeover waste, scrap, emissions, overtime, and transport. A schedule that minimizes finished-goods inventory may increase urgent shipments or setup waste. Evaluation should therefore consider total cost and environmental impact rather than a single efficiency measure.

9. Challenges and limitations

MPS quality is limited by uncertainty. Forecast error, order cancellation, supplier disruption, machine breakdown, absenteeism, yield loss, and engineering changes can invalidate assumptions. Other limitations include:

• Aggregation error: family-level capacity may conceal a model-specific bottleneck.
• Parameter instability: changing lead times or lot sizes can cause planning nervousness.
• False precision: a weekly quantity may be interpreted as a guaranteed daily sequence.
• Local optimization: maximizing utilization at one resource may increase total flow time or inventory.
• Inadequate governance: frequent overrides weaken trust in the schedule.
• Inconsistent definitions: different departments may calculate ATP, safety stock, or available capacity differently.

These limitations are managed through scenario planning, frozen-zone discipline, frequent but controlled replanning, cross-functional review, accurate master data, and explicit performance measures.

10. Best-practice performance measures

Useful MPS measures include:

• schedule adherence;
• customer service level and on-time delivery;
• forecast accuracy and forecast bias;
• inventory turns and days of supply;
• number and size of changes inside each time fence;
• ATP accuracy;
• percentage of MPS periods with capacity overload;
• planned-versus-actual production; and
• premium freight, overtime, and expediting cost.

No single measure is sufficient. For example, high schedule adherence may result from maintaining an unrealistic schedule, while high utilization may conceal late orders and excessive work-in-process. A balanced scorecard is more reliable.

Chapter Summary

Master Production Scheduling converts aggregate intentions and customer demand into a time-phased plan for specific end items. Its central calculations include planning demand, projected available balance, lot-sized planned receipts, and available-to-promise. The PAB equation tracks expected inventory, while ATP identifies supply that remains uncommitted to customer orders. Planning time fences protect near-term execution and establish rules for schedule changes. Rough-cut capacity planning tests whether the proposed MPS is feasible at critical resources before detailed release. Effective practice integrates demand policy, inventory, capacity, customer priorities, data governance, and controlled change management. Technology can improve speed and visibility, but accurate data and accountable managerial judgment remain essential.

Key Terms

Available-to-promise (ATP): Uncommitted supply that may be promised to customers.

Aggregate production plan: Medium-term plan for product families, capacity, workforce, and inventory.

Dependent demand: Demand derived from the requirement for another item.

End item: Finished product or major assembly planned directly in the MPS.

Frozen zone: Near-term planning interval in which changes require formal authorization.

Independent demand: Demand originating from external customers or markets.

Lot-for-lot: Lot-sizing rule that produces the exact net requirement.

Lot size: Quantity produced or ordered when replenishment occurs.

Master Production Schedule: Time-phased plan specifying end-item quantities and completion periods.

Material Requirements Planning: Process that derives component and material requirements from the MPS.

Planning horizon: Future time span covered by the schedule.

Projected available balance: Expected inventory after demand and planned supply are considered.

Rough-cut capacity planning: High-level check of MPS load against key-resource capacity.

Safety stock: Inventory held to protect against uncertainty or variation.

Scheduled receipt: Supply already expected to arrive in a specified period.

Schedule nervousness: Excessive change to planned orders as new information enters the system.

Slushy zone: Intermediate planning interval allowing limited, evaluated changes.

Time fence: Boundary governing the extent to which schedule changes are permitted.

Review Questions

Short Answer Questions

1. What is the primary purpose of a Master Production Schedule?
2. Distinguish independent demand from dependent demand.
3. Define projected available balance.
4. Why is ATP different from physical inventory?
5. What does an overload indicated by RCCP imply?

Long Answer Questions

1. Explain how an MPS connects aggregate planning with MRP and shop-floor control.
2. Discuss the purpose and governance of frozen, slushy, and liquid planning zones.
3. Compare lot-for-lot, fixed-lot, and economic-order-quantity approaches to MPS lot sizing.
4. Explain how customer priorities should be incorporated without destabilizing the schedule.
5. Evaluate the benefits and limitations of using ERP and AI-supported planning systems.

Analytical / Application Questions

1. Beginning inventory is 100 units, safety stock is 20 units, and weekly demand is 70, 90, and 80 units. With a fixed lot size of 100 units and no scheduled receipts, construct the three-week MPS and calculate each ending PAB.
2. An MPS requires 90 units of Product A at 1.2 machine-hours each and 60 units of Product B at 1.5 machine-hours each. Setup time is 12 hours. Available effective capacity is 180 hours. Calculate required capacity and the load ratio, then recommend a response.
3. A customer requests an order inside the frozen zone. Develop a decision process for accepting, postponing, subcontracting, or reallocating the order while protecting existing commitments.

Multiple Choice Questions with Answers

Question 1

Which statement best describes the purpose of a Master Production Schedule?

A. It specifies component quantities for every operation only after production begins.

B. It converts aggregate intentions and demand into time-phased end-item production quantities.

C. It replaces all capacity planning and shop-floor dispatching activities.

D. It records only historical customer orders.

Correct Answer: B. It converts aggregate intentions and demand into time-phased end-item production quantities.

Question 2

If beginning PAB is 50 units, MPS receipt is 100 units, and planning demand is 80 units, what is ending PAB?

A. 30 units

B. 50 units

C. 70 units

D. 230 units

Correct Answer: C. 70 units

Question 3

When customer orders replace rather than add to the forecast, which rule is commonly used for planning demand?

A. Dₜ = Fₜ + Oₜ

B. Dₜ = Fₜ − Oₜ

C. Dₜ = max(Fₜ, Oₜ)

D. Dₜ = min(Fₜ, Oₜ)

Correct Answer: C. Dₜ = max(Fₜ, Oₜ)

Question 4

What is the main purpose of a frozen planning zone?

A. To prohibit all future forecasting

B. To protect near-term production from uncontrolled changes

C. To maximize the number of schedule revisions

D. To eliminate safety stock

Correct Answer: B. To protect near-term production from uncontrolled changes

Question 5

ATP is primarily intended to identify:

A. Total physical inventory, including allocated stock

B. Uncommitted supply available for customer promises

C. Total annual production capacity

D. The standard cost of a finished product

Correct Answer: B. Uncommitted supply available for customer promises

Question 6

If required capacity is 240 machine-hours and available capacity is 200 machine-hours, the load ratio is:

A. 0.83

B. 1.00

C. 1.20

D. 1.40

Correct Answer: C. 1.20

Question 7

Which lot-sizing rule produces exactly the calculated net requirement?

A. Fixed lot size

B. Lot-for-lot

C. Minimum batch size

D. Period-order quantity

Correct Answer: B. Lot-for-lot

Question 8

Rough-cut capacity planning is best described as:

A. A detailed inspection of every individual operator task

B. A high-level feasibility check of the MPS against critical resources

C. A method for calculating customer credit limits

D. A replacement for demand forecasting

Correct Answer: B. A high-level feasibility check of the MPS against critical resources

Question 9

Why can negative ATP not normally be promised to a new customer?

A. It represents supply already overcommitted within the relevant receipt interval.

B. It means the product has no bill of materials.

C. It indicates that safety stock is too high.

D. It proves that demand is zero.

Correct Answer: A. It represents supply already overcommitted within the relevant receipt interval.

Question 10

Which is a likely consequence of excessive schedule changes inside the frozen zone?

A. Reduced expediting and improved stability

B. Lower data requirements

C. Disruption, overtime, and loss of schedule credibility

D. Automatic elimination of capacity bottlenecks

Correct Answer: C. Disruption, overtime, and loss of schedule credibility