Study guide

6.1 Creating the Master Schedule

APICS CPIM Certified in Planning and Inventory Management Exam

Track your progress as you read

Finished sections get a check mark.

1 Introduction & Exam Overview

1.1 Current Exam Facts 1.2 ECM 9.0 Domains and Weights 1.3 How to Study for CPIM

2 Supply Chain Strategy Foundations

2.1 Supply Chains, the Environment, and Strategy 2.2 Environment Analysis and Strategic Scope 2.3 Developing and Managing Organizational Strategy 2.4 Competitive Analysis: Five Forces, Benchmarking, and Value Chain

3 Strategy Performance and Operations Choices

3.1 Performance Monitoring and KPIs 3.2 Functional and Operational Strategies 3.3 Environments, Types, and Layouts 3.4 Service Process Design and Product-Process Trade-offs

4 Sales and Operations Planning

4.1 S&OP Purpose and Process 4.2 Aggregate Demand and Supply Plans 4.3 Reconciling S&OP Plans 4.4 Portfolio, New Product Introduction, and Life-Cycle Planning in S&OP 4.5 Strategic Buffers, Bottlenecks, and Capacity-Constrained Resources

5 Plan and Manage Demand

5.1 Demand Management 5.2 Sources of Demand and Forecasting 5.3 Forecast Performance 5.4 Marketing, Promotions, and Product Management 5.5 Qualitative, Associative, and AI-Driven Forecasting

6 Master Scheduling

6.1 Creating the Master Schedule 6.2 Rough-Cut Capacity Planning and MPS Validation 6.3 Using and Maintaining the Master Schedule 6.4 Planning Bills and Two-Level Master Scheduling 6.5 NPI, DFMA, Prototype, and End-of-Life Schedules

7 MRP, CRP, and Supply Disruptions

7.1 Material Requirements Planning 7.2 CRP, Order Promising, and Final Assembly Scheduling 7.3 Changes and Supply Disruptions 7.4 Product Costing and Variance Analysis for Planners

8 External Supply Sources

8.1 Suppliers and Procurement 8.2 Purchasing and Maintenance 8.3 Supply Chain Risk Management 8.4 Sourcing Footprint and Supplier Relationship Types 8.5 Supplier Release Mechanics and Inbound Logistics

9 Sustainability and Reverse Logistics

9.1 Sustainability Strategies 9.2 Waste Hierarchy and Reverse Logistics 9.3 Sustainability Standards, Reporting, and Life-Cycle Assessment

10 Inventory Planning and Costs

10.1 Inventory Planning 10.2 Inventory Costs, Accounting, Costing, and Metrics 10.3 EOQ, Reorder Point, and Safety Stock

11 Inventory Management and Control

11.1 Inventory Management Policies 11.2 Inventory Control 11.3 Service Levels and Inventory Tradeoffs 11.4 MRO Inventory and Maintenance Planning Inputs 11.5 Traceability Standards and Off-Site Inventory

12 Detailed Schedules and PAC

12.1 Planning Detailed Schedules 12.2 Scheduling and PAC Methods 12.3 Creating Production and Service Schedules 12.4 Managing Detailed Schedules and Scheduling Materials 12.5 Sequencing Rules, Lot Splitting, and Overlapped Scheduling 12.6 Capacity Types, Safety Capacity, and Labor Scheduling 12.7 Process Batches, Transfer Batches, and Backflushing

13 Plan and Manage Distribution

13.1 Planning Distribution 13.2 Replenishment and DRP 13.3 Order Management, Trace/Track, and KPIs

14 Quality and Business Investments

14.1 Quality Systems and Tools 14.2 Capital Equipment and Facilities 14.3 Technology in Planning and Inventory 14.4 The Seven Basic and Seven New Quality Tools 14.5 SPC Charts and Variation Types 14.6 Systems Requirements, Master Data, and Emerging Technologies

15 Continuous Improvement

15.1 Continuous Improvement Overview 15.2 Lean, JIT, and the Seven Wastes 15.3 Six Sigma, Kaizen, and Root Cause Tools 15.4 TPM, SMED, Standardized Work, and Visual Management

16 Integration and Exam Readiness

16.1 Planning Hierarchy Integration 16.2 High-Yield Calculations Drill 16.3 Exam Day, Scoring, and Credential Maintenance

6.1 Creating the Master Schedule

Key Takeaways Explain This Topic AI

The master production schedule (MPS) is the disaggregated statement of what the firm will build by period; it is not the forecast and not the customer-order book by itself.

MPS demand inputs combine forecast, customer orders, and interplant/distribution requirements; the planner chooses the MPS quantity that balances service and capacity.

Available-to-promise (ATP) tells order promising how much of each MPS receipt remains uncommitted after firm customer orders are allocated.

Discrete ATP allocates only within the period of an MPS receipt; cumulative ATP with look-ahead lets surplus forward-cover later shortages.

Planning horizon and time fences (especially the demand time fence and planning time fence) constrain how freely the MPS may be changed as a period approaches.

Last updated: July 2026

6.1 Creating the Master Schedule

Quick Answer: The master production schedule (MPS) is the authorized, time-phased plan of end-item (or planning-item) production. It is built from forecasts and customer orders but is a planner decision, not a passive copy of either. Available-to-promise (ATP) is the uncommitted portion of MPS supply used for order promising.

Domain IV of the CPIM ECM 9.0 asks you to plan and manage internal supply sources . After S&OP sets the aggregate rate of supply, the master schedule is the first detailed commitment: what will be finished, how many , and when . Everything downstream—MRP, purchasing, and shop-floor execution—explodes from this schedule. Weak MPS logic creates either stockouts or excess WIP; strong MPS logic turns the production plan into a feasible, promiseable plan.

Where the MPS Sits in the Planning Hierarchy

Recall the cascade you will see again in later Domain IV and Domain VII material:

  • Strategic / business plan → long-horizon volume and mix targets
  • S&OP / production plan → aggregate families by month or week
  • Master schedule (MPS) → specific items (or planning bills) by week or day
  • MRP → component and raw-material requirements
  • Detailed scheduling / PAC → operations on the floor

The MPS is therefore the disaggregation of the production plan. If the production plan says "build 4,000 finished goods of Family A in July," the MPS assigns those units to SKUs A1, A2, and A3 across the weeks of July, subject to capacity and materials.

MPS vs. Forecast vs. Customer Orders

Exam questions frequently try to equate three different numbers. Keep them separate:

Concept What it is Role in MPS

Forecast Unconsumed estimate of future independent demand Planning input; soft demand beyond the demand time fence

Customer orders Firm booked demand (and often backlog) Hard demand; consumes forecast and reduces ATP

MPS (scheduled receipts / MPS row) Planner-authorized build quantities by period Supply plan that MRP and promising use

In a make-to-stock environment, early periods often show forecast as the demand driver until orders arrive; as orders book, they consume the forecast so you do not double-count. In make-to-order or assemble-to-order, the MPS may be driven more by backlog and planning bills, with forecast still shaping the longer horizon.

Critical CPIM distinction: The forecast is a prediction . Customer orders are commitments . The MPS is a decision . Changing the forecast does not automatically change the MPS; the master scheduler updates the MPS deliberately.

Building the Time-Phased MPS Grid

A classic MPS worksheet has rows such as:

  • Forecast
  • Customer orders
  • Projected available balance (PAB)
  • Available-to-promise (ATP)
  • Master production schedule (MPS)

Projected available balance in period t is typically:

PAB(t) = PAB(t−1) + MPS(t) - Demand(t)

where Demand is the greater of forecast and customer orders inside the demand time fence (or customer orders only, depending on policy), and often the greater of forecast and orders outside the fence—exact rule is policy-driven, but the exam expects you to apply the stated rule consistently.

Worked Example: Eight-Week MPS Setup

Starting on-hand inventory = 120 units. Lot size / MPS receipts are planned in multiples of 100 . Safety stock target = 40 (the planner will not let PAB fall below 40 without action).

  • Week 1 2 3 4 5 6 7 8
  • Forecast 80 80 75 75 90 90 85 85
  • Customer orders 95 70 40 20 10 0 0 0
  • MPS 100 0 100 0 100 100 0 100

Demand used for PAB (policy: max(forecast, orders) each week):

  • Week 1 2 3 4 5 6 7 8
  • Demand 95 80 75 75 90 90 85 85

PAB walk-forward:

  • Week 1: 120 + 100 - 95 = 125
  • Week 2: 125 + 0 - 80 = 45
  • Week 3: 45 + 100 - 75 = 70
  • Week 4: 70 + 0 - 75 = -5 ← problem : below safety stock and negative

The planner must add or pull forward an MPS receipt (for example, move 100 into Week 4 or increase Week 3).

Revised Week 4 MPS = 100 , then:

  • Week 4: 70 + 100 - 75 = 95
  • Week 5: 95 + 100 - 90 = 105
  • Week 6: 105 + 100 - 90 = 115
  • Week 7: 115 + 0 - 85 = 30 ← below safety stock of 40 → add MPS in Week 7
  • With Week 7 MPS = 100: 115 + 100 - 85 = 130
  • Week 8: 130 + 100 - 85 = 145

This is the craft of master scheduling: you do not "accept" a negative PAB; you adjust MPS quantities and timing until inventory and service policies hold.

Available-to-Promise (ATP)

ATP answers the sales question: "How many more firm orders can we accept against the current MPS without creating a shortfall?"

Discrete ATP (non-cumulative)

For the first period with an MPS receipt:

ATP(1) = On-hand + MPS(1) - Σ Customer orders until next MPS

For later MPS periods:

ATP(t) = MPS(t) - Σ Customer orders from t until next MPS

Using the revised schedule (MPS in weeks 1, 3, 4, 5, 6, 7, 8) and the customer-order row above:

  • ATP Week 1 (covers weeks 1–2 until next MPS in 3): 120 + 100 - (95+70) = 55
  • ATP Week 3 (covers week 3 only if next MPS is week 4): 100 - 40 = 60
  • ATP Week 4 : 100 - 20 = 80
  • ATP Week 5 : 100 - 10 = 90

ATP Weeks 6–8 : MPS minus remaining orders (mostly 0) → ATP equals MPS in those weeks under discrete logic when no orders remain

If a salesperson wants to book 50 more units for Week 2, discrete ATP in the Week 1 bucket is 55, so the promise is feasible without changing the MPS. Booking 70 would exceed ATP 55 and require either a schedule change or a later promise date.

Cumulative ATP with Look-Ahead

Cumulative methods allow unused ATP in earlier periods to cover later periods, and look-ahead variants prevent promising into a future negative ATP. On the exam, read the stem carefully: if it says discrete , do not "borrow" forward; if it says cumulative , sum remaining ATP correctly.

Planning Horizon and Time Fences (Creation Context)

When creating the MPS you must choose a planning horizon long enough to cover the cumulative lead time of the product (longest path of manufactured and purchased lead times). Too short a horizon means MRP will see demand too late to order long-lead components.

Time fences (covered in depth in 6.3) already shape creation:

Inside the demand time fence (DTF) , actual orders dominate; forecasts are typically ignored for demand calculation.

Inside the planning time fence (PTF) , changes to the MPS usually require senior approval; the system may freeze MPS receipts.

Beyond the PTF (liquid zone), the planner (or planning logic) can insert MPS receipts more freely to chase forecast.

Practical Creation Checklist for CPIM

Confirm the item is a true MPS item (end item, product family planning bill, or critical intermediate).

Load forecast and current customer orders into the horizon.

Set lot-size / policy and safety-stock or days-of-supply rules.

Place trial MPS receipts; compute PAB; eliminate negatives and policy violations.

Compute ATP for order promising.

Hold the candidate MPS for rough-cut capacity planning (RCCP) before firming and releasing to MRP (next section).

Master scheduling is judgment under constraints: you are authorizing supply, enabling promises, and protecting the factory from chaos—all before detailed material explosion begins.