Study guide

6.2 Aggregate Planning Strategies & Master Production Scheduling (MPS)

PE Industrial and Systems Exam

Track your progress as you read

Finished sections get a check mark.

1 Exam Overview, Strategy & Systems Foundations

1.1 PE Industrial Exam Format, Official Specification & Reference Handbook Strategy 1.2 System Analysis Tools, Process Definition, Requirements Engineering & QFD 1.3 Performance Measures: Output, Productivity, OEE, Cost & Environmental Sustainability 1.4 Process Types (Discrete, Continuous, Manufacturing, Service) & Value Analysis/Engineering

2 Optimization, Queueing, Simulation, Networks & Markov Chains

2.1 Linear Programming Formulation, Graphical Solutions & Sensitivity Analysis 2.2 Queueing Theory Models (M/M/1, M/M/s) & Little's Law Applications 2.3 Discrete-Event Simulation, Random Variates & Model Validation 2.4 Graph Theory & Network Models: Shortest Path, Minimal Spanning Tree & Maximum Flow 2.5 Markov Chains: Transition Matrices, Steady-State Probabilities & Absorbing States 2.6 Decision Trees, Expected Value & Bottleneck Analysis (Theory of Constraints)

3 Project Management & Planning

3.1 Project Scheduling with CPM and PERT: Critical Path, Float, Probability & Crashing 3.2 Project Planning & Control: Scope and WBS, Gantt Charts, Critical Chain (CCPM), Risk & Earned Value

4 Facility Layout, Space, Capacity & Material Handling

4.1 Systematic Layout Planning (SLP) & Activity Relationship (REL) Analysis 4.2 Workstation Design, Aisle Sizing & Space Requirements Planning 4.3 Capacity Analysis: Machine Requirements, Scrap Allowances & Personnel Requirements 4.4 Material Handling Equipment Selection, Unit Loads & Handling Principles

5 Site Location, Warehousing & Facility Economics

5.1 Facility Location Models: Center of Gravity & Minisum / Minimax Distance 5.2 Warehousing Systems, Storage Assignment & Order Picking Operations 5.3 Facility Life-Cycle Economics, Replacement Analysis & Rearrangement Costs

6 Demand Forecasting, Production Planning, MRP & JIT

6.1 Demand Forecasting Methods: Moving Averages, Exponential Smoothing & Error Metrics 6.2 Aggregate Planning Strategies & Master Production Scheduling (MPS) 6.3 Material Requirements Planning (MRP), Bill of Materials & Capacity Planning 6.4 Just-in-Time & Lean Production Planning: Pull Systems, Kanban Sizing, Heijunka & SMED

7 Inventory Systems, Scheduling, Logistics & Transportation Modes

7.1 Deterministic Inventory Control: Classical EOQ, EPQ & Quantity Discounts 7.2 Stochastic Inventory Management: Safety Stock, Continuous / Periodic Review & Newsvendor 7.3 Production Sequencing, Dispatching Rules & Johnson's Algorithm 7.4 Supply Chain Logistics, Transportation Simplex & Distribution Network Design 7.5 Transportation Modes, Freight Economics & the Transshipment Model

8 Engineering Economics, Break-Even Analysis & Costing Systems

8.1 Equivalence, Cash Flow Analysis & Discounted Cash Flow Metrics (PW, FW, EAC) 8.2 Rate of Return Analysis (IRR, Incremental IRR) & Benefit-Cost (B/C) Ratios 8.3 Asset Depreciation (MACRS, Straight-Line), Tax Effects & Replacement Decisions 8.4 Break-Even Analysis, Technical Capability Assessment & Costing Systems (Traditional, ABC & Standard Costs)

9 Methods Engineering, Work Measurement, Learning Curves, Line Balancing & Process Planning

9.1 Methods Analysis, Process Charting & Motion Study (Therbligs, 5S) 9.2 Worker–Machine (Man–Machine) Charts, Multiple Activity Analysis & Synchronous Servicing 9.3 Time Study Fundamentals, Performance Rating & Allowance Factors 9.4 Predetermined Motion Time Systems (PMTS, MTM, MOST) & Work Sampling 9.5 Learning Curves: Unit and Cumulative-Average Models, Learning Rates & Applications 9.6 Assembly Line Balancing, Precedence Constraints & Efficiency Heuristics 9.7 Manufacturing & Service Process Planning: Operation Selection, Sequencing, Route Sheets, Fixturing & Mistake Proofing

10 Ergonomics, Human Capacity, Occupational Safety & DART Rates

10.1 Anthropometry, Percentile Design, Workstation Ergonomics & Link Analysis 10.2 Industrial Biomechanics, the NIOSH Lifting Equation & Lifting Aids 10.3 Limits of Human Capacity & Risk-Factor Tools: Work Physiology, Strength, Range of Motion, Vision, RULA & Slip Resistance 10.4 Environmental Ergonomics (Noise, Heat, Illumination), Human-Machine Systems & OSHA Safety 10.5 Safety Codes, Standards & Voluntary Guidelines (OSHA, ANSI, NIOSH, MIL-STD) and DART Rate Calculations

11 Statistical Process Control & Process Capability

11.1 Statistical Process Control for Variables (X-bar/R and X-bar/s Charts) 11.2 Statistical Process Control for Attributes (p, np, c, and u Charts) 11.3 Process Capability Indices (Cp, Cpk, Cpm, Pp, Ppk) & Sigma Levels

12 Design of Experiments, Acceptance Sampling & Quality Systems

12.1 Design of Experiments: 2^k Factorials, ANOVA & Taguchi Robust Design 12.2 Acceptance Sampling: OC Curves, AQL, LTPD, AOQL, Z1.4/MIL-STD-105E & Dodge-Romig 12.3 Quality Systems (Deming, TQM, ISO 9000, Benchmarking), Root Cause Analysis & DMAIC

13 Reliability Engineering & Maintenance Systems

13.1 Reliability Modeling, Failure Rates (lambda) & Life Distributions (Exponential, Weibull) 13.2 System Reliability Architecture: Series, Parallel, k-out-of-n & Redundancy 13.3 Equipment Maintenance Engineering, Availability (A), MTBF/MTTR & RCM

6.2 Aggregate Planning Strategies & Master Production Scheduling (MPS)

Key Takeaways Explain This Topic AI

Aggregate planning translates long-range strategic business goals into intermediate (3–18 month) operational schedules for product families, establishing baseline workforce levels, inventory policies, and subcontracting limits.

The pure Chase strategy modulates capacity directly against fluctuating demand via hiring, layoffs, and overtime to keep finished-goods inventory near zero, but incurs substantial labor volatility and turnover costs.

The pure Level strategy maintains a constant production rate and fixed workforce, absorbing demand oscillations through finished goods inventory accumulations in trough periods and backorders or stockouts during demand peaks.

Mathematical programming models for aggregate planning minimize total operating expenditures (regular wages, overtime, hiring, termination, holding, backorders, and subcontracting) subject to workforce transitions and material conservation constraints.

The Master Production Schedule (MPS) disaggregates aggregate plans into specific finished SKUs across frozen, slushy, and liquid time fences; Available-to-Promise (ATP) mechanics calculate uncommitted stock for prospective customer delivery commitments.

Last updated: October 2026

Aggregate Planning Strategies & Master Production Scheduling (MPS)

Core Principle: Industrial operations link high-level corporate strategy to day-to-day manufacturing through a multi-tiered planning hierarchy. Aggregate Sales & Operations Planning (S&OP) establishes intermediate capacity and workforce policies, which are disaggregated into end-item Master Production Schedules (MPS) and validated through Rough-Cut Capacity Planning (RCCP).

Manufacturing organizations cannot make optimal shop-floor operational decisions in isolation from strategic corporate plans. If an operations facility reacts to daily demand spikes without an intermediate aggregate plan, it faces oscillating hiring cycles, excessive overtime, elevated inventory carrying expenses, and frequent delivery stockouts. Aggregate planning coordinates marketing projections, financial targets, and operational capabilities across a rolling medium-term planning horizon.

1. The Production Planning Hierarchy

Production planning operates across a structured, multi-echelon hierarchy where time horizons compress and product granularity increases as planning moves closer to shop-floor execution: Production Planning & Execution Hierarchy

  • [Strategic Business Plan] (2-5 Years)
  • │ Corporate strategy, capital investment, facility locations
  • ▼
  • [Aggregate Sales & Operations Plan (S&OP)] (3-18 Months)
  • │ Product families, aggregate labor hours, baseline output rates
  • ▼
  • [Master Production Schedule (MPS)] (1-6 Months)
  • │ Specific finished end-items (SKUs), weekly/daily buckets
  • ├── [Rough-Cut Capacity Planning (RCCP)] (Checks bottleneck capacity)
  • ▼
  • [Material Requirements Planning (MRP)] (1-12 Weeks)
  • │ Component BOM explosion, purchase orders, shop work orders
  • ├── [Capacity Requirements Planning (CRP)] (Validates work center loads)
  • ▼
  • [Shop-Floor Dispatching & Execution] (Days / Hours)
  • │ Priority dispatching rules (FIFO, SPT, EDD), machine loading

Planning Level Horizon Time Bucket Product Granularity Primary Decision Variables

Strategic Plan 2–5 years Quarters / Years Total revenue / market share Plant construction, technological capabilities, acquisitions

Aggregate Plan (S&OP) 3–18 months Months / Quarters Product families (e.g., total tons, aggregate labor hours) Workforce sizing, aggregate inventory, overtime, subcontracting

Master Production Schedule 1–6 months Weeks / Days Finished end-item SKUs Specific lot sizes, planned completion dates, Available-to-Promise (ATP)

MRP & Shop Scheduling Days–Weeks Shifts / Days / Hours Components, raw materials, routing operations Purchase requisitions, shop orders, dispatch priority, tool setup

2. Aggregate Planning Strategies: Chase, Level, and Hybrid

Aggregate planning balances anticipated demand against available operational capacity. When demand fluctuates across seasons, management selects from two pure boundary strategies or deploys a hybrid mixed strategy. Chase vs Level Production Profiles

  • Units ^
  • | /\ <-- Customer Demand Profile
  • | / \
  • | ---------/----
  • | | / \ [Chase Strategy: Matches Demand Exactly]
  • | | / \ [Level Strategy: Flat Output Rate (===)]
  • | |========================== Level Production Rate (P_avg)
  • | | / \
  • | | / \ <-- Excess Inventory Accumulated (Holding Cost)
  • | | / \ <-- Backorders / Stockouts Incurred (Shortage Cost)
  • +--+---------------------------------------------> Time (Months)
  • 1. Pure Chase Strategy

In a Chase Strategy , production output in each period t t t is set to equal forecasted demand D t D_t D t ​ exactly ( P t = D t P_t = D_t P t ​ = D t ​ ):

Mechanisms: The workforce is dynamically adjusted through aggressive hiring and firing, or plant work hours are modulated via variable workweeks.

Inventory Impact: Finished-goods inventory is held at or near zero ( I t ≈ 0 I_t \approx 0 I t ​ ≈ 0 ), eliminating inventory holding costs and warehouse space requirements.

Cost Drivers: Severe hiring, onboarding, training, and severance expenses. High workforce turnover reduces operator morale, degrades process capability, and increases product defect rates.

Application: Suitable for non-storable products (e.g., commercial airlines, fast food, custom made-to-order capital equipment) or industries where carrying costs are prohibitive.

2. Pure Level Strategy

In a Level Strategy , the production rate is held strictly constant in every period at the average demand rate ( P t = P ˉ = ∑ D t N P_t = \bar{P} = \frac{\sum D_t}{N} P t ​ = P ˉ = N ∑ D t ​ ​ ), maintaining an entirely stable workforce:

Mechanisms: The workforce remains unchanged. When demand is below P ˉ \bar{P} P ˉ (demand troughs), the excess production accumulates as finished-goods inventory. When demand exceeds P ˉ \bar{P} P ˉ (demand peaks), inventory buffers are depleted to fulfill customer orders.

Inventory Impact: Significant inventory holding costs accumulate during off-peak periods. If demand exceeds accumulated stock, backorders, customer delays, or lost sales occur.

Cost Drivers: Finished goods carrying costs, warehouse storage, insurance, capital costs, and potential shortage/stockout penalties.

Application: High-capital, automated, or continuous-flow industries (e.g., petroleum refining, semiconductor fabrication, chemicals) where adjusting workforce size is impractical or specialized skilled labor cannot easily be hired.

3. Hybrid / Mixed Strategies

Real-world manufacturing systems utilize Hybrid (Mixed) Strategies , combining workforce stability with tactical flexibility:

Maintaining a baseline core permanent workforce sized for minimum baseline demand.

Utilizing scheduled overtime ( O T OT OT ) or undertime during moderate fluctuations.

Engaging subcontractors ( S C SC SC ) or third-party contract manufacturers to absorb extreme peak surges without expanding permanent facility infrastructure.

3. Mathematical Optimization of Aggregate Planning

Aggregate planning can be formulated as a Linear Programming (LP) model to identify the minimum-cost production plan over an N N N -period horizon.

LP Decision Variables (for Period t = 1 , … , N t = 1, \dots, N t = 1 , … , N )

W t W_t W t ​ : Workforce level (number of equivalent full-time workers).

H t H_t H t ​ : Number of workers hired at the start of period t t t .

L t L_t L t ​ : Number of workers laid off at the start of period t t t .

P t P_t P t ​ : Units produced on regular time.

O t O_t O t ​ : Units produced on overtime.

S t S_t S t ​ : Units acquired via subcontracting.

I t I_t I t ​ : Finished-goods inventory held at the end of period t t t .

B t B_t B t ​ : Unfulfilled backordered units at the end of period t t t .

Objective Function (Minimize Total System Cost)

min ⁡ Z = ∑ t = 1 N ( c r P t + c o O t + c s S t + c h H t + c l L t + c i I t + c b B t ) \min Z = \sum_{t=1}^N \left( c_r P_t + c_o O_t + c_s S_t + c_h H_t + c_l L_t + c_i I_t + c_b B_t \right) min Z = ∑ t = 1 N ​ ( c r ​ P t ​ + c o ​ O t ​ + c s ​ S t ​ + c h ​ H t ​ + c l ​ L t ​ + c i ​ I t ​ + c b ​ B t ​ )

Where:

c r c_r c r ​ : Regular-time direct production cost per unit.

c o c_o c o ​ : Overtime production cost per unit.

c s c_s c s ​ : Subcontracting cost per unit.

c h c_h c h ​ : Cost to hire and train one worker.

c l c_l c l ​ : Cost to lay off one worker.

c i c_i c i ​ : Inventory holding cost per unit per period.

c b c_b c b ​ : Backorder shortage cost per unit per period.

System Constraints

Workforce Balance Constraint:

W t = W t − 1 + H t − L t , ∀ t W_t = W_{t-1} + H_t - L_t, \quad \forall t W t ​ = W t − 1 ​ + H t ​ − L t ​ , ∀ t

Regular-Time Production Capacity Constraint: (Assuming each worker contributes K K K labor-hours per period and each product requires k k k labor-hours):

P t ≤ K k W t , ∀ t P_t \le \frac{K}{k} W_t, \quad \forall t P t ​ ≤ k K ​ W t ​ , ∀ t

Overtime Capacity Constraint: (Overtime is restricted to a fraction γ \gamma γ of regular hours):

O t ≤ γ ( K k W t ) , ∀ t O_t \le \gamma \left(\frac{K}{k} W_t\right), \quad \forall t O t ​ ≤ γ ( k K ​ W t ​ ) , ∀ t

Inventory & Backorder Flow Conservation:

I t − 1 − B t − 1 + P t + O t + S t − D t = I t − B t , ∀ t I_{t-1} - B_{t-1} + P_t + O_t + S_t - D_t = I_t - B_t, \quad \forall t I t − 1 ​ − B t − 1 ​ + P t ​ + O t ​ + S t ​ − D t ​ = I t ​ − B t ​ , ∀ t

Non-negativity Bounds:

W t , H t , L t , P t , O t , S t , I t , B t ≥ 0 , ∀ t W_t, H_t, L_t, P_t, O_t, S_t, I_t, B_t \ge 0, \quad \forall t W t ​ , H t ​ , L t ​ , P t ​ , O t ​ , S t ​ , I t ​ , B t ​ ≥ 0 , ∀ t

4. Master Production Schedule (MPS) Mechanics & Time Fences

The Master Production Schedule (MPS) translates aggregate planning product family targets into specific, time-phased manufacturing batches for independent-demand finished items.

Time Fences and Planning Horizons

To balance manufacturing stability against market flexibility, the MPS planning horizon is divided into three distinct zones demarcated by time fences : MPS Time Fences & Operational Zones

  • Today Demand Time Fence (DTF) Planning Time Fence (PTF)
  • │ │ │
  • ▼ ▼ ▼
  • ┌───────────────────────────┬───────────────────────────┬───────────────────────────┐
  • │ FROZEN ZONE │ SLUSHY ZONE │ LIQUID ZONE │
  • │ - Customer orders rule │ - Trade-offs allowed │ - Forecast rules │
  • │ - Zero unauthorized mod │ - Material committed │ - Free optimization │
  • │ - Emergency changes only │ - Mix changes permitted │ - Long-range procurement │
  • └───────────────────────────┴───────────────────────────┴───────────────────────────┘
  • <------ Near-Term ---------> <------ Intermediate -----> <------- Long-Term -------->

Frozen Zone (Near-term, e.g., Weeks 1–3): Inside the Demand Time Fence (DTF) . Production batches are already released to the shop floor or in setup. Demand is driven entirely by booked customer orders, not forecasts. Schedule changes are strictly prohibited without executive authorization because disruptions cause component shortages and scrap.

Slushy Zone (Intermediate, e.g., Weeks 4–8): Between the Demand Time Fence and the Planning Time Fence (PTF) . Long lead-time raw materials are ordered, but capacity allocation can shift between product variations. Changes in product mix are allowed if total capacity is preserved.

Liquid Zone (Long-term, e.g., Weeks 9–24): Beyond the Planning Time Fence. The schedule is driven primarily by statistical forecasts. Schedulers have complete freedom to optimize batch sizes and reallocate capacity.

5. Available-to-Promise (ATP) Mathematics

Available-to-Promise (ATP) is the uncommitted portion of a company's finished inventory and planned production, maintained in the MPS to support sales order promising. When a sales representative receives a customer order, the ATP value dictates whether delivery can be confirmed immediately without disrupting existing commitments.

Projected Available Balance (PAB)

Before calculating ATP, the Projected Available Balance (PAB) tracks anticipated inventory across time buckets:

Prior to the Demand Time Fence (Inside Frozen Zone): Demand is determined strictly by committed Customer Orders ( C O CO CO ):

P A B t = P A B t − 1 + M P S t − C O t PAB_t = PAB_{t-1} + MPS_t - CO_t P A B t ​ = P A B t − 1 ​ + MP S t ​ − C O t ​

Beyond the Demand Time Fence (Slushy/Liquid Zones): Schedulers take the conservative maximum between forecast ( F t F_t F t ​ ) and committed customer orders ( C O t CO_t C O t ​ ):

P A B t = P A B t − 1 + M P S t − max ⁡ ( F t , C O t ) PAB_t = PAB_{t-1} + MPS_t - \max(F_t, CO_t) P A B t ​ = P A B t − 1 ​ + MP S t ​ − max ( F t ​ , C O t ​ )

Discrete Available-to-Promise (ATP) Formulas

Under standard discrete ATP logic (without lookahead consumption):

For the First Period ( t = 1 t = 1 t = 1 ): Includes starting on-hand inventory ( I 0 I_0 I 0 ​ ):

A T P 1 = I 0 + M P S 1 − ∑ k = 1 m − 1 C O k ATP_1 = I_0 + MPS_1 - \sum_{k=1}^{m-1} CO_k A T P 1 ​ = I 0 ​ + MP S 1 ​ − ∑ k = 1 m − 1 ​ C O k ​

Where m m m is the index of the next period in which an M P S MPS MPS replenishment receipt occurs ( M P S m > 0 MPS_m > 0 MP S m ​ > 0 ). Customer orders are summed across all periods up to the next replenishment.

For Subsequent Periods with an MPS Receipt ( M P S t > 0 MPS_t > 0 MP S t ​ > 0 ): Inventory carried from prior periods is already committed to earlier orders, so ATP depends solely on the new production batch:

A T P t = M P S t − ∑ k = t m − 1 C O k ATP_t = MPS_t - \sum_{k=t}^{m-1} CO_k A T P t ​ = MP S t ​ − ∑ k = t m − 1 ​ C O k ​

Where customer orders C O k CO_k C O k ​ are summed from period t t t up to, but not including, the next period m m m with an M P S MPS MPS receipt.

For Periods Without an MPS Receipt ( M P S t = 0 MPS_t = 0 MP S t ​ = 0 ):

  • A T P t = 0 ATP_t = 0 A T P t ​ = 0
  • 6. Worked Numerical Example: MPS and ATP Calculation

An industrial manufacturer schedules production of an automated hydraulic manifold. The operational parameters are:

Starting On-Hand Inventory: I 0 = 60 I_0 = 60 I 0 ​ = 60 units.

Fixed MPS Batch Lot Size: 150 150 150 units.

Demand Time Fence (DTF): End of Week 2.

Planning Horizon: 6 Weeks.

Schedule Data

  • Operational Parameter Week 1 Week 2 Week 3 Week 4 Week 5 Week 6
  • Demand Forecast ( F t F_t F t ​ ) 40 50 60 60 50 50
  • Committed Customer Orders ( C O t CO_t C O t ​ ) 48 35 30 18 10 5
  • Master Production Schedule ( M P S t MPS_t MP S t ​ ) 0 150 0 150 0 150
  • Step-by-Step Mathematical Calculation

1. Projected Available Balance (PAB):

Week 1 (Inside DTF): P A B 1 = I 0 + M P S 1 − C O 1 = 60 + 0 − 48 = 12 PAB_1 = I_0 + MPS_1 - CO_1 = 60 + 0 - 48 = 12 P A B 1 ​ = I 0 ​ + MP S 1 ​ − C O 1 ​ = 60 + 0 − 48 = 12

Week 2 (Inside DTF): P A B 2 = P A B 1 + M P S 2 − C O 2 = 12 + 150 − 35 = 127 PAB_2 = PAB_1 + MPS_2 - CO_2 = 12 + 150 - 35 = 127 P A B 2 ​ = P A B 1 ​ + MP S 2 ​ − C O 2 ​ = 12 + 150 − 35 = 127

Week 3 (Beyond DTF): max ⁡ ( F 3 , C O 3 ) = max ⁡ ( 60 , 30 ) = 60 \max(F_3, CO_3) = \max(60, 30) = 60 max ( F 3 ​ , C O 3 ​ ) = max ( 60 , 30 ) = 60 . P A B 3 = P A B 2 + M P S 3 − max ⁡ ( F 3 , C O 3 ) = 127 + 0 − 60 = 67 PAB_3 = PAB_2 + MPS_3 - \max(F_3, CO_3) = 127 + 0 - 60 = 67 P A B 3 ​ = P A B 2 ​ + MP S 3 ​ − max ( F 3 ​ , C O 3 ​ ) = 127 + 0 − 60 = 67

Week 4 (Beyond DTF): max ⁡ ( F 4 , C O 4 ) = max ⁡ ( 60 , 18 ) = 60 \max(F_4, CO_4) = \max(60, 18) = 60 max ( F 4 ​ , C O 4 ​ ) = max ( 60 , 18 ) = 60 . P A B 4 = P A B 3 + M P S 4 − max ⁡ ( F 4 , C O 4 ) = 67 + 150 − 60 = 157 PAB_4 = PAB_3 + MPS_4 - \max(F_4, CO_4) = 67 + 150 - 60 = 157 P A B 4 ​ = P A B 3 ​ + MP S 4 ​ − max ( F 4 ​ , C O 4 ​ ) = 67 + 150 − 60 = 157

Week 5 (Beyond DTF): max ⁡ ( F 5 , C O 5 ) = max ⁡ ( 50 , 10 ) = 50 \max(F_5, CO_5) = \max(50, 10) = 50 max ( F 5 ​ , C O 5 ​ ) = max ( 50 , 10 ) = 50 . P A B 5 = P A B 4 + M P S 5 − max ⁡ ( F 5 , C O 5 ) = 157 + 0 − 50 = 107 PAB_5 = PAB_4 + MPS_5 - \max(F_5, CO_5) = 157 + 0 - 50 = 107 P A B 5 ​ = P A B 4 ​ + MP S 5 ​ − max ( F 5 ​ , C O 5 ​ ) = 157 + 0 − 50 = 107

Week 6 (Beyond DTF): max ⁡ ( F 6 , C O 6 ) = max ⁡ ( 50 , 5 ) = 50 \max(F_6, CO_6) = \max(50, 5) = 50 max ( F 6 ​ , C O 6 ​ ) = max ( 50 , 5 ) = 50 . P A B 6 = P A B 5 + M P S 6 − max ⁡ ( F 6 , C O 6 ) = 107 + 150 − 50 = 207 PAB_6 = PAB_5 + MPS_6 - \max(F_6, CO_6) = 107 + 150 - 50 = 207 P A B 6 ​ = P A B 5 ​ + MP S 6 ​ − max ( F 6 ​ , C O 6 ​ ) = 107 + 150 − 50 = 207

2. Available-to-Promise (ATP):

Week 1 ( t = 1 t = 1 t = 1 ): Starting stock I 0 = 60 I_0 = 60 I 0 ​ = 60 . The next MPS receipt occurs at Week 2 ( m = 2 m = 2 m = 2 ). A T P 1 = I 0 + M P S 1 − C O 1 = 60 + 0 − 48 = 12 units ATP_1 = I_0 + MPS_1 - CO_1 = 60 + 0 - 48 = 12 \text{ units} A T P 1 ​ = I 0 ​ + MP S 1 ​ − C O 1 ​ = 60 + 0 − 48 = 12 units

Week 2 ( t = 2 t = 2 t = 2 ): M P S 2 = 150 MPS_2 = 150 MP S 2 ​ = 150 . The next MPS receipt occurs at Week 4 ( m = 4 m = 4 m = 4 ). We sum customer orders for Week 2 and Week 3: A T P 2 = M P S 2 − ( C O 2 + C O 3 ) = 150 − ( 35 + 30 ) = 150 − 65 = 85 units ATP_2 = MPS_2 - (CO_2 + CO_3) = 150 - (35 + 30) = 150 - 65 = 85 \text{ units} A T P 2 ​ = MP S 2 ​ − ( C O 2 ​ + C O 3 ​ ) = 150 − ( 35 + 30 ) = 150 − 65 = 85 units

Week 3 ( t = 3 t = 3 t = 3 ): No MPS replenishment ( M P S 3 = 0 MPS_3 = 0 MP S 3 ​ = 0 ), so A T P 3 = 0 ATP_3 = 0 A T P 3 ​ = 0 .

Week 4 ( t = 4 t = 4 t = 4 ): M P S 4 = 150 MPS_4 = 150 MP S 4 ​ = 150 . The next MPS replenishment occurs at Week 6 ( m = 6 m = 6 m = 6 ). We sum customer orders for Week 4 and Week 5: A T P 4 = M P S 4 − ( C O 4 + C O 5 ) = 150 − ( 18 + 10 ) = 150 − 28 = 122 units ATP_4 = MPS_4 - (CO_4 + CO_5) = 150 - (18 + 10) = 150 - 28 = 122 \text{ units} A T P 4 ​ = MP S 4 ​ − ( C O 4 ​ + C O 5 ​ ) = 150 − ( 18 + 10 ) = 150 − 28 = 122 units

Week 5 ( t = 5 t = 5 t = 5 ): No MPS replenishment ( M P S 5 = 0 MPS_5 = 0 MP S 5 ​ = 0 ), so A T P 5 = 0 ATP_5 = 0 A T P 5 ​ = 0 .

Week 6 ( t = 6 t = 6 t = 6 ): M P S 6 = 150 MPS_6 = 150 MP S 6 ​ = 150 . No further replenishment is scheduled within the horizon. Subtract C O 6 CO_6 C O 6 ​ : A T P 6 = M P S 6 − C O 6 = 150 − 5 = 145 units ATP_6 = MPS_6 - CO_6 = 150 - 5 = 145 \text{ units} A T P 6 ​ = MP S 6 ​ − C O 6 ​ = 150 − 5 = 145 units

Master Production Schedule Master Table

  • Week 1 2 3 4 5 6
  • Demand Forecast ( F t F_t F t ​ ) 40 50 60 60 50 50
  • Committed Customer Orders ( C O t CO_t C O t ​ ) 48 35 30 18 10 5
  • Projected Available Balance ( P A B t PAB_t P A B t ​ ) 12 127 67 157 107 207
  • Master Production Schedule ( M P S t MPS_t MP S t ​ ) 0 150 0 150 0 150
  • Available-to-Promise ( A T P t ATP_t A T P t ​ ) 12 85 0 122 0 145
  • 7. Rough-Cut Capacity Planning (RCCP)

Before releasing the Master Production Schedule to MRP, the proposed schedule must be validated against critical facility constraints via Rough-Cut Capacity Planning (RCCP) . RCCP prevents the company from committing to an infeasible MPS that would bottleneck key work centers.

Three RCCP Methodologies

Capacity Planning using Overall Factors (CPOF): The simplest macro-level method. Takes total direct labor or machine hours required per finished unit and allocates them across work centers based on historical percentage usage.

Bill of Resources (Capacity Bills): Utilizes the detailed engineering standard hours required at each specific bottleneck work center per unit of product, multiplying MPS batch sizes by work center standard hours. It assumes all capacity is consumed in the completion period (ignoring lead times).

Resource Profile Approach: The most sophisticated RCCP method. Incorporates operation lead-time offsets, mapping exactly when hours will hit each work center prior to final product delivery.

If RCCP detects that required load exceeds available rated capacity at a bottleneck resource, schedulers resolve the infeasibility by authorizing planned overtime, advancing lot production to earlier open periods, subcontracting components, or shifting mix within the slushy zone.