Master Production Scheduling

Introduction and Context

Master Production Scheduling (MPS) is the formal process of translating the aggregate production plan, demand information, and material and capacity constraints into a time-phased schedule for specific end items. It is the principal link between business planning and Material Requirements Planning (MRP). Whereas an aggregate plan may state that a product family should produce 10,000 units in a quarter, the MPS specifies which finished products will be completed, in what quantities, and in which planning periods.

The MPS is both a planning instrument and a managerial commitment. It communicates expected production to manufacturing, procurement, logistics, sales, and finance. It also provides the demand signal from which the MRP system calculates component requirements. A poor MPS can therefore cause material shortages, excessive inventory, unstable priorities, overtime, expediting, and unreliable customer promises.

An effective MPS must balance three objectives:

1. satisfy customer and market demand;
2. use available resources efficiently; and
3. remain sufficiently stable to support orderly execution.

These objectives often conflict. Increasing output to meet a sales opportunity may exceed available capacity. Protecting schedule stability may require declining a late order. Producing to forecast may improve delivery performance for standard items but create obsolete inventory when demand is uncertain. MPS development is consequently a constrained decision-making process rather than a simple forecast-to-production conversion.

Learning Objectives

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

• explain the purpose, structure, and role of the MPS in an MRP system;
• distinguish forecasts, customer orders, independent demand, and dependent demand;
• construct a time-phased MPS using projected available balance and available-to-promise calculations;
• apply planning time fences and appropriate order-promising rules;
• evaluate feasibility using rough-cut capacity planning and capable-to-promise logic;
• manage schedule stability, exception messages, and authorized changes;
• assess the managerial, technological, and governance implications of MPS decisions.

1. The MPS in the Planning and Control Hierarchy

Production planning normally operates at several levels. Strategic planning addresses facilities, technology, and long-term capacity. Sales and Operations Planning (S&OP) balances demand and supply at the product-family level, usually over months or quarters. The MPS converts this aggregate plan into end-item quantities by week or another suitable period. MRP then explodes the MPS through bills of material and inventory records to determine component requirements. Purchasing and shop-floor control execute the resulting plans.

The hierarchy can be represented as:

Business plan → S&OP or aggregate plan → MPS → MRP → purchasing and production control

The MPS should remain consistent with the aggregate plan. If the aggregate plan authorizes 1,000 units of a product family in a month but the MPS schedules 1,400 units of specific end items, the discrepancy must be resolved rather than hidden in the MRP system.

1.1 What the MPS specifies

An MPS record commonly includes:

• item or end-product identifier;
• planning periods and their dates;
• forecast demand;
• customer orders or other booked demand;
• scheduled receipts;
• projected available balance;
• MPS quantities and completion dates;
• available-to-promise quantities;
• planning time fences and status indicators.

The MPS is usually prepared for items with independent demand, such as finished products, service parts, or major assemblies sold directly to customers. Components whose demand is calculated from parent items are generally planned by MRP, although some major assemblies may be separately scheduled.

1.2 Independent and dependent demand

Independent demand originates outside the production system. It includes customer orders, forecasts, service requirements, and replacement demand for finished goods. Dependent demand is derived from the quantity and timing of a parent item through the bill of material. For example, demand for 40 bicycles may create dependent demand for 80 wheels, assuming two wheels per bicycle.

This distinction matters because independent demand must be estimated or received from customers, whereas dependent demand can usually be calculated once the MPS and product structure are known.

2. Demand Inputs and the Master Schedule Record

Demand information is rarely a single number. The planner must reconcile forecasts, booked orders, safety-stock requirements, promotions, service parts, interplant requirements, and strategic allocations.

For a standard make-to-stock product, a common period demand used for planning is the greater of forecast and customer orders:

where:

• D_t = planning demand in period t;
• F_t = forecast demand in period t;
• O_t = qualifying customer orders due in period t.

This rule prevents double counting when orders are already included in the forecast. It is not universally appropriate: organizations may instead use orders plus an independently calculated remaining forecast, or use separate demand classes. The chosen rule must be documented in the planning policy.

A typical MPS table is shown below.

The planner must also identify opening inventory, scheduled receipts, lot-size rules, safety stock, lead time, capacity, and any inventory already allocated to customers.

3. Projected Available Balance and MPS Quantities

The projected available balance (PAB) estimates inventory remaining at the end of each period after satisfying demand and receiving planned production. A general period-by-period relationship is:

where:

• PAB_t = projected available balance at the end of period t, in units;
• PAB_t-1 = prior period projected balance, in units;
• SR_t = scheduled receipt arriving in period t, in units;
• MPS_t = MPS receipt or production completion in period t, in units;
• D_t = planning demand in period t, in units.

The formula assumes that all quantities use the same unit of measure and that receipts are available at the beginning of, or sufficiently early within, the period to satisfy that period's demand. If receipts arrive at the end of the period, the timing convention must be changed.

A minimum inventory condition can be expressed as:

where SS_t is the required safety stock in period t. If safety stock is zero, the condition becomes PAB_t ≥ 0. A negative PAB indicates a projected shortage, not necessarily a confirmed physical shortage; it signals that the schedule requires revision or an exception decision.

Lot sizing and timing

The MPS quantity is influenced by lot-for-lot, fixed-order quantity, minimum batch size, economic considerations, campaign requirements, and setup costs. If a fixed production lot of Q units is used, the planned receipt may be expressed as:

This is a policy constraint, not a universal law. A planner may authorize an exceptional quantity when capacity, customer commitments, or shelf-life considerations justify it.

4. Worked Example: Constructing a Feasible MPS

Consider an illustrative make-to-stock product. The opening inventory is 140 units, safety stock is 40 units, and there are no scheduled receipts. The planning demand is the greater of forecast and customer orders. Production is made in lots of 100 units. The preliminary capacity limit is 120 units per period.

A feasible schedule is developed by selecting the smallest permitted lot that keeps the PAB at or above 40 units.

• Period 1: Without production, PAB = 140 − 80 = 60; no receipt is needed.
• Period 2: Without production, PAB = 60 − 120 = −60. One 100-unit lot gives PAB = 40, so MPS = 100.
• Period 3: PAB = 40 − 120 = −80. One 100-unit lot gives PAB = 20, still below safety stock. Two lots give PAB = 120, so MPS = 200. This exceeds the stated capacity limit of 120 and is therefore infeasible under the initial capacity assumption.

The planner must not simply accept the 200-unit receipt. Alternatives include advancing production into period 2 if capacity and storage permit, authorizing overtime, using a substitute resource, negotiating delivery dates, reducing safety stock temporarily through governance, or revising the demand plan. This example illustrates why inventory arithmetic alone does not establish a feasible MPS.

Suppose management authorizes 80 units of overtime capacity in period 3, raising its maximum to 200 units. The resulting schedule is:

Each PAB is calculated sequentially. For example, period 4 is 120 + 100 − 130 = 90. The schedule meets the safety-stock requirement and remains within the revised capacities of 120, 120, 200, 120, and 120 units.

The schedule nevertheless deserves managerial review. It creates a high balance after period 3 and may incur storage or obsolescence cost. A different lot-sizing policy, postponement strategy, or demand allocation may produce a better total solution. Feasibility is necessary but not sufficient; cost, responsiveness, and stability must also be assessed.

5. Planning Time Fences and Schedule Stability

A planning time fence divides the planning horizon into zones with different degrees of change control. The exact terminology differs among organizations, but a useful structure is:

The frozen zone protects execution from frequent rescheduling. Its length should reflect cumulative lead time, supplier commitments, setup patterns, customer-service requirements, and the cost of disruption. A fence that is too short encourages instability; one that is too long can make the organization unresponsive.

A schedule change should be evaluated for its effect on:

• component and raw-material availability;
• supplier commitments and cancellation costs;
• work-centre capacity and overtime;
• setup and sequence efficiency;
• customer delivery dates;
• inventory and safety-stock exposure;
• downstream MRP nervousness.

Schedule stability does not mean refusing all changes. It means changing the plan deliberately, transparently, and only when the benefit exceeds the operational disruption. Useful governance mechanisms include an authorized change log, approval thresholds, reason codes, exception review, and measurement of changes inside the frozen zone.

6. Available-to-Promise and Order Promising

Available-to-promise (ATP) represents the uncommitted quantity that can be promised to customers. It is not identical to projected inventory. Inventory may exist physically but already be allocated to orders, quality holds, service requirements, or other priorities.

For a simple discrete MPS with no prior backlog, ATP in the first period is commonly:

For subsequent MPS receipts:

where the summation covers qualifying customer orders, not necessarily forecast demand. The formulas assume that the beginning inventory and each MPS receipt are available for allocation and that orders are assigned according to the organization's promising policy.

For example, beginning inventory is 50 units, MPS receipts are 100 units in period 2 and 120 units in period 4, and orders are 30, 40, 50, and 60 units in periods 1 through 4. Then:

• ATP through the first MPS receipt: 50 + 100 − (30 + 40) = 80 units;
• ATP associated with the period 4 receipt: 120 − (50 + 60) = 10 units.

Forecast is excluded from this basic ATP calculation because ATP measures uncommitted supply after booked orders. Some organizations use forecast consumption rules, in which customer orders consume forecast quantities and only the remaining forecast is considered. The policy must be explicit to avoid promising the same supply twice.

ATP should be time-phased. A customer requesting delivery in period 4 cannot automatically receive an earlier period's ATP if transportation, shelf life, configuration, or reservation rules prevent such use.

7. Capable-to-Promise

ATP asks whether supply is uncommitted; capable-to-promise (CTP) asks whether the organization can create supply by using available material, capacity, and lead time. CTP is therefore more powerful but also more data-intensive.

A CTP decision evaluates:

1. the requested item, quantity, configuration, and date;
2. existing MPS and ATP;
3. component and raw-material availability;
4. bottleneck and labour capacity;
5. routing, setup, queue, and transportation time;
6. permissible alternatives, subcontracting, or overtime;
7. the effect on existing commitments.

A simplified logic is:

The expression is a decision condition rather than a complete production model. “Feasible incremental supply” must be calculated using valid capacity and material data, and the resulting promise must not violate higher-priority commitments.

ATP is appropriate when the item is standard and the MPS already represents available supply. CTP is appropriate when the customer requests a nonstandard configuration, a quantity beyond ATP, or a date requiring additional production. In engineer-to-order and configure-to-order environments, CTP may need finite-capacity scheduling and multi-level component checks.

8. Capacity Feasibility and Rough-Cut Capacity Planning

An MPS is not feasible merely because its PAB never becomes negative. Capacity must also be tested. Rough-cut capacity planning (RCCP) compares the capacity implied by the MPS with available capacity at critical work centres.

For a work centre, the gross load in period t can be estimated as:

where:

• Load_t is required work-centre time in hours;
• MPS_i,t is the quantity of item i scheduled in period t;
• StandardTime_i is the work-centre time per unit of item i in hours.

If available capacity is based on scheduled operating time, a simple utilization measure is:

A value above 1, or above a management-approved threshold, indicates overload. The calculation assumes that standard times are credible and that the work centre is the relevant capacity constraint. For more precise analysis, planners should account for setup time, yield loss, downtime, labour availability, sequence dependence, and finite-capacity constraints.

RCCP is deliberately approximate. It is a screening method that identifies likely bottlenecks before detailed MRP and shop-floor scheduling. It does not prove that every operation can be executed in sequence.

9. Managing Exceptions and Schedule Nervousness

MRP systems can generate large numbers of rescheduling messages when minor demand or inventory changes propagate through bills of material. This phenomenon is often called nervousness. It can be reduced through:

• appropriate time fences;
• order modifiers and minimum change quantities;
• frozen component commitments;
• stable forecast-consumption rules;
• planned safety time where justified;
• exception thresholds;
• disciplined master-data maintenance;
• separate treatment of urgent orders.

Common MPS exceptions include projected shortages, excess inventory, late scheduled receipts, capacity overload, orders inside the frozen zone, and demand exceeding ATP. Exceptions should be prioritized by customer impact, financial exposure, constraint severity, and reversibility rather than by the number of system messages alone.

10. Integrated Illustrative Case: Orion Appliances

The following is a fictional illustrative case.

Background

Orion Appliances produces two refrigerator models, Standard and Premium. Demand is seasonal, Premium uses a compressor shared with another product, and the compressor work centre is frequently constrained. The sales team has promised several large retailers delivery in the next six weeks. The company uses a weekly MPS and a two-week frozen zone.

Problem

The initial MPS satisfies the aggregate monthly plan but schedules a large quantity of Premium units in week 3. RCCP shows that compressor demand reaches 125% of available capacity. At the same time, the MPS promises more Standard units than the finished-goods inventory and week-4 production can support. Sales requests that the frozen schedule be changed immediately.

Analysis

The planner first validates demand classifications and discovers that several customer orders were already included in the forecast. Treating both as additive overstated demand. The planner then calculates PAB and ATP separately for each model, checks compressor requirements using the bill of material, and identifies week 3 as the bottleneck period. A CTP review shows that moving some Premium production to week 2 is possible only if a supplier accelerates compressor delivery and overtime is authorized.

Approach and solution

Orion adopts the following actions:

• removes double-counted demand from the MPS input;
• keeps week 1 frozen because materials are issued and production is released;
• moves a portion of Premium production from week 3 to week 4;
• uses 60 units of approved overtime in week 3;
• promises Standard units only against verified ATP;
• uses CTP for two strategic retailer orders, subject to supplier confirmation;
• records all changes inside the frozen zone with executive approval;
• revises the next S&OP cycle to reflect the compressor constraint.

Outcome

The revised MPS eliminates the projected compressor overload, protects confirmed customer deliveries, and avoids unnecessary production caused by forecast double counting. The schedule does not maximize immediate sales promises; instead, it creates credible commitments supported by material and capacity evidence.

Learning points

The case demonstrates that MPS quality depends on demand governance, not merely spreadsheet arithmetic. ATP and CTP must be distinguished, capacity constraints must be visible at the end-item planning stage, and time fences must be supported by an authorization process. A stable schedule can still be changed when the organization understands the cost and formally accepts the consequences.

11. Technology, Data, and Governance

Contemporary enterprise resource planning and advanced planning systems can calculate PAB, ATP, CTP, RCCP, exception messages, and alternative scenarios rapidly. Integration with order management, supplier portals, shop-floor systems, and customer-relationship platforms can improve visibility. However, automation does not correct inaccurate lead times, bills of material, routings, inventory balances, or order statuses.

Artificial intelligence and machine-learning tools can improve demand sensing, anomaly detection, and scenario generation. Their use should remain decision-supportive unless the organization has strong controls. Planners should be able to inspect the demand signals, constraints, assumptions, and confidence associated with a recommendation. Automated order promising must also respect customer allocation rules, contractual priorities, export controls, and privacy requirements.

Good MPS governance includes:

• one authorized source of item, order, inventory, and capacity data;
• documented forecast-consumption and ATP rules;
• clear ownership of frozen-zone changes;
• audit trails for overrides and manual adjustments;
• segregation between commercial promises and operations approval;
• periodic review of forecast error, schedule adherence, and promise accuracy.

Ethically, organizations should avoid promising dates that are known to be infeasible merely to win orders. Transparent communication of constraints supports fair customer treatment and protects employees from unsafe or unreasonable expediting. Regulatory requirements may also affect allocation, traceability, product safety, and export-restricted items.

12. Performance Measures and Best Practices

MPS performance should be measured across service, stability, inventory, and feasibility. Useful indicators include:

• customer promise-date adherence;
• schedule attainment or adherence;
• forecast accuracy and bias;
• ATP promise accuracy;
• number and value of changes inside the frozen fence;
• projected and actual stockouts;
• inventory turns and excess inventory;
• capacity overload hours;
• MRP exception volume;
• percentage of orders requiring manual intervention.

No single metric is sufficient. Maximizing schedule adherence while ignoring customer service can reward the wrong behaviour. Similarly, minimizing inventory may create excessive expediting and lost sales.

Best practice is to establish a regular MPS review cycle involving sales, operations, procurement, finance, and product management. The review should examine demand changes, constrained resources, material risks, customer priorities, and authorized exceptions. Scenarios should be compared on total business consequences rather than on production volume alone.

Challenges and Limitations

MPS decisions are limited by uncertain demand, inaccurate master data, variable supplier performance, finite capacity, long lead times, engineering changes, and conflicting commercial priorities. Forecasts are especially unreliable at detailed item-period levels, so planners should avoid false precision and use scenario ranges where appropriate.

PAB calculations also simplify reality. They may not represent quality holds, location-specific inventory, yield loss, batch expiry, labour skill restrictions, or sequence-dependent setups. ATP can be misleading if orders are not properly allocated, while CTP can be overly optimistic if capacity data are theoretical rather than demonstrated. Finally, an MPS optimized for average conditions may fail during disruptions; resilience requires contingency capacity, alternate sources, and explicit recovery policies.

Chapter Summary

Master Production Scheduling converts aggregate production intentions and independent demand into a time-phased plan for specific end items. It is the principal input to MRP and must balance customer service, inventory, capacity, cost, and schedule stability.

The projected available balance is calculated from prior balance, scheduled receipts, MPS receipts, and planning demand. Forecasts and customer orders must be combined according to a documented demand policy that avoids double counting. Lot sizes, safety stock, lead times, and capacity constraints shape the resulting schedule.

Planning time fences create frozen, slushy, and liquid zones that control the degree of permitted change. ATP measures uncommitted supply, whereas CTP evaluates whether additional supply can be created using real material and capacity. RCCP provides an early test of bottleneck feasibility, but detailed scheduling may still be required.

Effective MPS practice depends on accurate data, cross-functional governance, transparent customer promises, exception management, and balanced performance measures. Technology and AI can improve visibility and scenario analysis, but they do not replace managerial accountability or sound master data.

Key Terms

Master Production Schedule: A time-phased plan specifying end-item production quantities and completion periods.

Independent Demand: Demand originating from customers, markets, forecasts, or other external sources.

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

Projected Available Balance: Expected inventory remaining after demand and planned receipts.

Scheduled Receipt: A previously authorized supply receipt expected in a specified period.

MPS Receipt: Planned completion quantity recorded in the master schedule.

Safety Stock: Inventory held to protect against uncertainty in demand or supply.

Planning Time Fence: A boundary that controls the extent to which schedule changes are permitted.

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

Available-to-Promise: Uncommitted supply that can be allocated to customer orders.

Capable-to-Promise: A promise based on the ability to create additional supply using material and capacity.

Rough-Cut Capacity Planning: Approximate comparison of MPS-implied load with key resource capacity.

Lot Size: Quantity produced or ordered as one planning increment.

Schedule Nervousness: Excessive plan changes caused by small changes in demand, inventory, or timing.

Forecast Consumption: The process of using customer orders to consume previously forecast demand.

Bottleneck: A resource whose limited capacity restricts system output.

Exception Message: A planning alert indicating a shortage, overload, lateness, or other deviation.

Schedule Adherence: Degree to which actual production follows the authorized schedule.

Review Questions

Short Answer Questions

1. What is the principal relationship between the MPS and MRP?
2. Distinguish independent demand from dependent demand.
3. What information is represented by projected available balance?
4. Why are planning time fences used?
5. How does capable-to-promise differ from available-to-promise?

Long Answer Questions

1. Explain how forecasts and customer orders should be reconciled when constructing an MPS. Include the risk of double counting.
2. Describe the role of frozen, slushy, and liquid planning zones in schedule governance.
3. Explain the assumptions and limitations of projected available balance calculations.
4. Discuss how rough-cut capacity planning can identify an infeasible MPS.
5. Evaluate the contribution and limitations of ERP, advanced planning, and AI tools in MPS management.

Analytical / Application Questions

1. A product has opening inventory of 90 units, demand of 70 units in period 1 and 100 units in period 2, a safety stock of 30 units, and a fixed lot size of 100 units. Construct the smallest feasible MPS receipts and calculate the ending PAB for both periods. State any capacity assumptions.
2. A customer requests 150 units in week 4. ATP is 80 units, but an additional 100 units could be produced in week 3 only by using a constrained work centre already at 95% load. Explain the information required before making a CTP promise.
3. An organization experiences frequent changes inside its two-week frozen zone. Diagnose likely causes and recommend a governance and data-quality improvement plan.

Multiple Choice Questions with Answers

Question 1

What is the primary role of the Master Production Schedule?

A. To calculate only purchased raw-material quantities

B. To specify time-phased production of end items

C. To replace the sales and operations planning process

D. To record actual machine maintenance activities

Correct Answer: B. To specify time-phased production of end items

Question 2

If opening inventory is 140 units, demand is 80 units, and there is no receipt or production, what is the ending projected available balance?

A. 60 units

B. 80 units

C. 140 units

D. 220 units

Correct Answer: A. 60 units

Question 3

Which demand is normally calculated through the bill of material?

A. Independent demand for finished goods

B. Customer orders for service parts

C. Dependent demand for components

D. Market demand for product families

Correct Answer: C. Dependent demand for components

Question 4

What is the principal purpose of a frozen planning zone?

A. To permit unlimited schedule changes

B. To prevent all forecasting activity

C. To protect near-term execution from unauthorized changes

D. To eliminate the need for capacity planning

Correct Answer: C. To protect near-term execution from unauthorized changes

Question 5

Which statement best distinguishes ATP from CTP?

A. ATP evaluates uncommitted supply; CTP evaluates feasible additional supply

B. ATP applies only to components; CTP applies only to finished goods

C. ATP ignores customer orders; CTP ignores capacity

D. ATP is always more detailed than CTP

Correct Answer: A. ATP evaluates uncommitted supply; CTP evaluates feasible additional supply

Question 6

A work centre has a load of 900 hours and available capacity of 1,000 hours. What is its utilization?

A. 9%

B. 90%

C. 100%

D. 111%

Correct Answer: B. 90%

Question 7

Which situation most directly indicates MPS infeasibility despite a nonnegative inventory balance?

A. Forecast demand is stable

B. The schedule exceeds bottleneck capacity

C. ATP is calculated by period

D. The item uses a fixed lot size

Correct Answer: B. The schedule exceeds bottleneck capacity

Question 8

Why should forecast and customer-order treatment be explicitly documented?

A. To ensure every forecast is increased by the order quantity

B. To prevent double counting and inconsistent promises

C. To eliminate all demand uncertainty

D. To make safety stock unnecessary

Correct Answer: B. To prevent double counting and inconsistent promises

Question 9

What is schedule nervousness?

A. A systematic increase in finished-goods quality

B. Frequent and disruptive changes to planned production

C. A method for calculating safety stock

D. A customer allocation procedure

Correct Answer: B. Frequent and disruptive changes to planned production

Question 10

Which activity is most appropriate for rough-cut capacity planning?

A. Checking likely load on critical work centres from the MPS

B. Calculating every component requirement at shop-floor operation level

C. Auditing employee attendance records

D. Determining the selling price of finished goods

Correct Answer: A. Checking likely load on critical work centres from the MPS