Study guide
12.2 Aggregate Planning, Master Production Scheduling (MPS), and MRP
FE Industrial and Systems Study Guide Exam
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Exam Overview, CBT Strategy & Handbook Navigation
1.1 FE Industrial Exam Structure, CBT Logistics, and Pacing 1.2 Using the NCEES FE Reference Handbook and Approved Calculators
2 Chapter 2: Mathematics for Industrial Engineers
2.1 Analytic Geometry, Coordinate Systems, and Trigonometry 2.2 Calculus: Differential, Integral, and Series Approximations 2.3 Linear Algebra: Matrix Operations, Systems of Equations, and Vectors
3 Chapter 3: Engineering Sciences Core
3.1 Thermodynamics Fundamentals and Fluid Flow Principles 3.2 Statics, Dynamics, and Mechanics of Materials Core 3.3 Electrical Circuits, DC/AC Analysis, and Power in Industrial Systems
4 Chapter 4: Ethics and Professional Practice
4.1 NCEES Model Rules of Professional Conduct and Technical Society Ethics 4.2 Engineering Licensure, Public Welfare, and Professional Liability 4.3 Engineering Contracts, Intellectual Property, and Conflicts of Interest
5 Chapter 5: Engineering Economics
5.1 Time Value of Money, Discount Factors, and Equivalence 5.2 Evaluating Alternatives: Present Worth, Equivalent Annual Cost, and IRR 5.3 Incremental Rate of Return, Replacement Analysis, and Break-Even 5.4 Depreciation Methods, MACRS, Income Taxes, and Inflation
6 Chapter 6: Probability Foundations & Distributions
6.1 Basic Probability Concepts, Conditional Probability, and Bayes' Theorem 6.2 Discrete Probability Distributions 6.3 Continuous Probability Distributions
7 Chapter 7: Statistical Inference, Regression & Design of Experiments
7.1 Sampling Distributions, Central Limit Theorem, and Confidence Intervals 7.2 Hypothesis Testing: Means, Proportions, and Variances 7.3 Linear Regression, Correlation Analysis, and Design of Experiments (ANOVA)
8 Chapter 8: Data, Logic, Modeling & Linear Programming
8.1 Optimization Modeling: Decision Variables, Objectives, and Constraints 8.2 Linear Programming: Graphical Solutions and Simplex Fundamentals 8.3 Duality, Sensitivity Analysis, and Integer Linear Programming 8.4 Data, Logic Development, and Analytics
9 Chapter 9: Stochastic Models & Simulation
9.1 Queuing Theory: Little's Law, M/M/1, and Multi-Server Systems 9.2 Discrete-Time Markov Chains: Transition Matrices and Steady-State Probabilities 9.3 Discrete-Event Simulation Principles and Monte Carlo Modeling
10 Chapter 10: Engineering Management, Project Planning & Performance Measurement
10.1 Organizational Structure, Leadership, and Worker Motivation Theories 10.2 Project Management: WBS, Critical Path Method (CPM), PERT, and Crashing 10.3 Earned Value Management (EVM), Decision Trees, and Risk Preference 10.4 Performance Measurement: Productivity, KPIs, Wage Systems, and the Balanced Scorecard
11 Chapter 11: Manufacturing & Production Systems
11.1 Manufacturing Processes, Material Processing, and Tolerancing 11.2 Assembly Line Balancing, Takt Time, Cycle Time, and Throughput 11.3 Sustainable Manufacturing, Waste Minimization, and Life-Cycle Assessment
12 Chapter 12: Production Planning, Inventory Control & Sequencing
12.1 Demand Forecasting Methods and Forecast Error Tracking 12.2 Aggregate Planning, Master Production Scheduling (MPS), and MRP 12.3 Deterministic Inventory Models: EOQ, EPQ, and Safety Stock 12.4 Job Sequencing, Dispatching Rules, and Flow Shop Scheduling
13 Chapter 13: Lean Systems & Theory of Constraints
13.1 Lean Foundations: Value Stream Mapping, Seven Wastes, and 5S 13.2 Pull Systems, Kanban, Just-In-Time (JIT), and SMED Setup Reduction 13.3 Theory of Constraints: Bottleneck Identification and Drum-Buffer-Rope
14 Chapter 14: Facilities Planning & Material Handling
14.1 Facility Location Analysis: Qualitative Factor Rating and Centroid Method 14.2 Facility Layout Design and Flow Analysis 14.3 Material Handling Equipment, Warehousing, and AS/RS
15 Chapter 15: Supply Chain Design & Logistics
15.1 Supply Chain Network Architecture and Transportation Modes 15.2 Distribution Strategies, Cross-Docking, and Vehicle Routing 15.3 The Bullwhip Effect, Risk Pooling, and Supply Chain Coordination
16 Chapter 16: Human Factors & Cognitive Ergonomics
16.1 Cognitive Engineering, Human-Machine Interface, Displays, and Controls 16.2 Anthropometric Principles, Percentile Design, and Biomechanical Posture 16.3 Environmental Ergonomics: Industrial Noise, Lighting, and Heat Stress
17 Chapter 17: Physical Ergonomics & Workplace Safety
17.1 Physical Ergonomics: The NIOSH Manual Lifting Equation 17.2 Cumulative Trauma Disorders and Postural Assessment 17.3 Workplace Safety: OSHA Standards, Hazard Analysis, and Control Hierarchy
18 Chapter 18: Work Design & Measurement
18.1 Methods Engineering, Process Charting, and Principles of Motion Economy 18.2 Direct Stopwatch Time Study: Observed Time, Performance Rating, and Allowances 18.3 Predetermined Time Systems, Work Sampling, and Learning Curves
19 Chapter 19: Quality Management, Six Sigma & Analytical Tools
19.1 Quality Philosophies, Total Quality Management, and Cost of Quality 19.2 Six Sigma DMAIC Methodology and Quality Function Deployment 19.3 The Seven Basic Quality Tools, Root Cause Analysis, and Taguchi Loss Function
20 Chapter 20: Statistical Process Control
20.1 Statistical Process Control Principles, Variation, and Run Rules 20.2 Variable Control Charts: X-bar & R, X-bar & S, and Individual-Moving Range 20.3 Attribute Control Charts: Defectives (p, np) and Defects (c, u)
21 Chapter 21: Process Capability & Acceptance Sampling
21.1 Process Capability Indices and Defect Levels 21.2 Acceptance Sampling Concepts and Operating Characteristic Curves 21.3 Sampling Risks, AQL, LTPD, and Standard Sampling Plans
22 Chapter 22: Systems Engineering & Life-Cycle Management
22.1 The Systems Engineering V-Model, Stakeholder Requirements, and Functional Architecture 22.2 Configuration Management, Interface Control, and Verification & Validation 22.3 Life-Cycle Costing, Maintainability, and System Availability
23 Chapter 23: Reliability Engineering & Risk Analysis
23.1 Reliability Mathematics, Hazard Rates, and the Bathtub Curve 23.2 System Reliability Configurations: Series, Parallel, and k-out-of-n Systems 23.3 Failure Modes and Effects Analysis and Fault Tree Analysis
12.2 Aggregate Planning, Master Production Scheduling (MPS), and MRP
Key Takeaways Explain This Topic AI
Aggregate planning establishes medium-range workforce, production, and inventory levels for product families, balancing the high inventory holding costs of a Level strategy against the hiring and layoff adjustment costs of a Chase strategy.
The Master Production Schedule (MPS) disaggregates aggregate plans into specific finished SKUs and time buckets, establishing Available-to-Promise (ATP) quantities to govern customer order commitments.
Material Requirements Planning (MRP) translates independent master schedule demand into time-phased dependent demand for subassemblies and components using the Bill of Materials (BOM) and Inventory Records.
Low-level coding assigns each part to the lowest level in any product tree, ensuring gross requirements from all parent assemblies are fully aggregated before exploding downward.
MRP time-phasing calculates Net Requirements = max(0, Gross Req - PAB_{t-1} - Scheduled Receipts + Safety Stock) and offsets Planned Order Releases backward by component lead time.
Last updated: September 2026
Manufacturing operations rely on a hierarchical production planning architecture to convert corporate business goals into shop-floor fabrication and assembly schedules. Strategic planning dictates multi-year capacity; aggregate planning optimizes monthly workforce and inventory levels; the Master Production Schedule (MPS) establishes specific finished goods delivery targets; and Material Requirements Planning (MRP) coordinates the purchasing and release of every subcomponent.
- 1. The Production Planning Hierarchy Production Planning Hierarchy
- ├── Strategic Business Plan (1–5+ Years, Corporate Strategy & Facility Capital)
- ├── Aggregate Production Plan (3–18 Months, Product Families & Monthly Labor/Inventory)
- │ ├── Resource Requirements Planning (RRP / Rough-Cut Capacity)
- ├── Master Production Schedule (Weeks–Months, Specific Finished SKUs & ATP Quantities)
- │ ├── Rough-Cut Capacity Planning (RCCP / Bottleneck Work Centers)
- ├── Material Requirements Planning (Days–Weeks, Dependent Demand Components & BOM Explosion)
- │ ├── Capacity Requirements Planning (CRP / Machine & Labor Workload)
- └── Shop Floor Control & Purchasing (Hours–Days, Dispatch Lists, POs, Vendor Expediting)
Independent Demand : Demand for finished goods, replacement spare parts, or service components that originates directly from external customers. Must be forecasted.
Dependent Demand : Demand for raw materials, subassemblies, and fabricated components that is directly calculated from the production schedule of parent assemblies. Governed strictly by MRP and BOM relationships, never forecasted independently.
2. Aggregate Production Planning Strategies
Aggregate Planning addresses intermediate-range operations (typically 3 to 18 months in monthly or quarterly buckets). Demand is aggregated into broad product families (e.g., "total gallons of paint" or "total automotive chassis") rather than individual SKUs, aiming to minimize total production costs while satisfying anticipated demand.
Pure Aggregate Planning Strategies
Strategy Operational Mechanism Cost Trade-Offs Primary Advantages & Disadvantages
Chase Strategy Matches production rate exactly to demand rate in each period by dynamically hiring, laying off, or furloughing workers. High hiring, training, severance, and layoff costs; virtually zero finished goods inventory holding cost. Advantage : Low capital tie-up, eliminates obsolescence.; Disadvantage : Severe workforce morale problems, union resistance, recruitment bottlenecks, lower quality from newly trained hires.
Level Strategy Maintains a constant production rate and constant workforce headcount across the entire horizon. Demand variations are absorbed via inventory build-up and stockouts. High inventory holding costs during seasonal troughs; potential stockout, lost sales, or backorder penalties during demand peaks; zero hiring/layoff volatility. Advantage : Stable workforce, predictable labor costs, high employee retention and skill proficiency.; Disadvantage : High inventory holding costs, warehouse storage constraints, risk of product obsolescence.
Hybrid / Mixed Strategy Combines a stable baseline workforce with secondary capacity adjustments: overtime, second/third shifts, subcontracting, and modest inventory buffering. Balances moderate inventory holding costs, premium overtime rates, and subcontracting surcharges. Advantage : Real-world optimal cost profile; avoids extreme workforce volatility while capping peak inventory exposure.
Mathematical Formulation of Aggregate Planning Costs
Total aggregate planning cost over planning horizon T T T is formulated as: TC = ∑ t = 1 T [ C reg W t + C OT O t + C sub S t + C hire H t + C lay L t + C hold I t + C back B t ] \text{TC} = \sum_{t=1}^T \left[ C_{\text{reg}} W_t + C_{\text{OT}} O_t + C_{\text{sub}} S_t + C_{\text{hire}} H_t + C_{\text{lay}} L_t + C_{\text{hold}} I_t + C_{\text{back}} B_t \right] TC = t = 1 ∑ T [ C reg W t + C OT O t + C sub S t + C hire H t + C lay L t + C hold I t + C back B t ]
where:
- W t W_t W t = regular workforce hours (or workers) in period t t t
- O t O_t O t = overtime hours worked
- S t S_t S t = units subcontracted
- H t , L t H_t, L_t H t , L t = number of workers hired and laid off
- I t , B t I_t, B_t I t , B t = ending inventory and backorder units in period t t t
- 3. The Master Production Schedule (MPS) and Available-to-Promise (ATP)
The Master Production Schedule (MPS) disaggregates the aggregate plan into specific finished end items, exact batch quantities, and weekly time buckets. The MPS forms the binding contract between marketing/sales and manufacturing operations.
Available-to-Promise (ATP) Logic
Available-to-Promise (ATP) represents the uncommitted portion of finished goods inventory and scheduled production maintained in the master schedule. Sales and customer service personnel use ATP to promise realistic delivery dates for incoming customer orders without disrupting the shop floor.
ATP Calculation Convention (Non-Cumulative / Discrete Method)
For the First Period ( t = 1 t = 1 t = 1 ) : ATP 1 = ( I 0 + MPS 1 ) − ∑ τ = 1 k − 1 Booked Orders τ \text{ATP}_1 = (I_0 + \text{MPS}_1) - \sum_{\tau=1}^{k-1} \text{Booked Orders}_\tau ATP 1 = ( I 0 + MPS 1 ) − τ = 1 ∑ k − 1 Booked Orders τ
where I 0 I_0 I 0 is the beginning on-hand inventory, MPS 1 \text{MPS}_1 MPS 1 is the planned production completion in period 1, and booked orders are summed across all periods up to (but not including) the next period k k k that has a scheduled MPS receipt.
For Subsequent Periods ( t > 1 t > 1 t > 1 with MPS t > 0 \text{MPS}_t > 0 MPS t > 0 ) : ATP t = MPS t − ∑ τ = t m − 1 Booked Orders τ \text{ATP}_t = \text{MPS}_t - \sum_{\tau=t}^{m-1} \text{Booked Orders}_\tau ATP t = MPS t − τ = t ∑ m − 1 Booked Orders τ
where booked orders are summed from period t t t until the next scheduled MPS replenishment period m m m .
If MPS t = 0 \text{MPS}_t = 0 MPS t = 0 , ATP is typically not calculated for that period (or defined as zero).
MPS Time Fences and Zones
To balance schedule stability against customer responsiveness, companies establish time fences : Time Fences & Planning Zones
- ├────── Frozen Zone ──────┼────── Slushy Zone ──────┼────── Liquid Zone ──────>
- Current Demand Planning Future
- Time Time Fence Time Fence Horizon
- (No changes allowed) (Trade-offs allowed) (System auto-generates)
Frozen Zone (Inside Demand Time Fence) : Near-term schedule. Capacity and materials are committed. No modifications permitted without executive authorization; expediting causes severe shop chaos.
Slushy Zone (Between Demand and Planning Time Fences) : Intermediate term. Minor volume and product mix trade-offs are permissible if raw materials and capacity constraints permit.
Liquid / Open Zone (Beyond Planning Time Fence) : Long term. The MRP computer algorithm can freely reschedule, increase, or cancel planned orders based on changing demand forecasts.
4. Material Requirements Planning (MRP) Structure and Inputs
Material Requirements Planning (MRP) is a computer-based computational engine that explodes the independent demand of the MPS into time-phased dependent demand schedules for every subassembly, component, and raw material required. MRP System Architecture
- ┌─────────────────────────┐ ┌─────────────────────────┐ ┌─────────────────────────┐
- │ Master Production │ │ Bill of Materials (BOM) │ │ Inventory Records File │
- │ Schedule (MPS) │ │ (Product Structure Tree)│ │ (On-Hand, Lead Times, SS)│
- └───────────┬─────────────┘ └───────────┬─────────────┘ └───────────┬─────────────┘
- │ │ │
- └───────────────────────┐ │ ┌───────────────────────┘
- ▼ ▼ ▼
- ┌───────────────────────┐
- │ MRP Computer Engine │
- │ (Explosion & Offsets) │
- └───────────┬───────────┘
- │
- ┌─────────────────────┴─────────────────────┐
- ▼ ▼
- ┌───────────────────────────┐ ┌───────────────────────────┐
- │ Planned Order Releases │ │ Secondary Exception │
- │ (Purchase & Shop Orders) │ │ Reports (Expedites, Resch)│
- └───────────────────────────┘ └───────────────────────────┘
- The Three Core MRP Inputs
Master Production Schedule (MPS) : Specifies which finished end items will be completed, in what quantities, and in which time buckets.
Bill of Materials (BOM) : An engineering document detailing the complete hierarchical list of raw materials, parts, and subassemblies required to manufacture one unit of an end item, including precise quantities per assembly.
Inventory Records File (Item Master File) : Contains real-time inventory status for every part number: physical on-hand inventory, scheduled receipts (open purchase orders already placed), safety stock, purchasing/manufacturing lead time ( L L L ), and assigned lot-sizing rules.
Product Structure Trees and Low-Level Coding
In a product structure tree , finished end items reside at Level 0 . Direct subassemblies reside at Level 1 , their child components at Level 2 , and basic raw materials at the lowest leaf nodes.
Low-Level Coding Rule : If an identical part number appears at multiple distinct levels within one product tree—or across several different product trees—it is assigned a low-level code equal to the lowest level (highest numeric index) at which it appears anywhere in the system.
Why Low-Level Coding is Mandatory : The MRP processing engine explodes requirements level-by-level (Level 0, then Level 1, then Level 2). By assigning a component its lowest level code, the algorithm guarantees that all gross requirements generated by every parent assembly are fully compiled before the system calculates net requirements and releases orders for that component. Without low-level coding, duplicate, disjointed orders would be triggered for the same component.
5. MRP Record Mechanics and Grid Formulations
For every item in the inventory file, the MRP system maintains a standardized time-phased grid. The row definitions and computational formulas for each period t t t are:
Gross Requirements ( G R t GR_t G R t ) : Total anticipated demand for the item during period t t t . For end items, this comes directly from the MPS; for components, it equals the sum of ( P O R e l × usage quantity ) (PORel \times \text{usage quantity}) ( POR e l × usage quantity ) across all parent items.
Scheduled Receipts ( S R t SR_t S R t ) : Open orders previously released to the shop floor or purchase orders dispatched to outside vendors, legally due to arrive at the beginning of period t t t .
Projected Available Balance ( P A B t PAB_t P A B t ) : The expected physical inventory on hand at the end of period t t t : P A B t = P A B t − 1 + S R t + P O R e c t − G R t PAB_t = PAB_{t-1} + SR_t + PORec_t - GR_t P A B t = P A B t − 1 + S R t + POR e c t − G R t (where P A B 0 PAB_0 P A B 0 is initial on-hand inventory) .
Net Requirements ( N R t NR_t N R t ) : The actual shortage that must be fulfilled in period t t t to satisfy demand and maintain the mandated safety stock ( S S SS SS ): N R t = max ( 0 , G R t − P A B t − 1 − S R t + S S ) NR_t = \max\left(0, \; GR_t - PAB_{t-1} - SR_t + SS\right) N R t = max ( 0 , G R t − P A B t − 1 − S R t + SS )
Planned Order Receipts ( P O R e c t PORec_t POR e c t ) : The replenishment batch quantity scheduled to arrive at the start of period t t t . If N R t > 0 NR_t > 0 N R t > 0 , P O R e c t ≥ N R t PORec_t \ge NR_t POR e c t ≥ N R t , dictated by the item's lot-sizing rule.
Planned Order Releases ( P O R e l t − L PORel_{t-L} POR e l t − L ) : The replenishment quantity that must be launched or ordered L L L periods earlier (where L L L is lead time) so that it arrives exactly when needed: P O R e l t − L = P O R e c t PORel_{t-L} = PORec_t POR e l t − L = POR e c t
6. Lot-Sizing Techniques in MRP
When net requirements are positive ( N R t > 0 NR_t > 0 N R t > 0 ), the lot-sizing rule dictates the order quantity ( P O R e c t PORec_t POR e c t ):
Lot-for-Lot (L4L) : P O R e c t = N R t PORec_t = NR_t POR e c t = N R t Orders exactly what is needed in each period. Eliminates ending inventory ( P A B t = S S PAB_t = SS P A B t = SS ), driving inventory holding costs to zero. Highly advantageous when setup costs are minimal (Lean/JIT) or when components are expensive and subject to rapid obsolescence. However, if setup costs are significant, L4L incurs severe setup penalties.
Economic Order Quantity (EOQ) :
Calculates a constant order quantity Q ∗ = 2 D S / H Q^* = \sqrt{2DS/H} Q ∗ = 2 D S / H based on average annualized demand. Whenever N R t > 0 NR_t > 0 N R t > 0 , an order of size Q ∗ Q^* Q ∗ (or integer multiples if N R t > Q ∗ NR_t > Q^* N R t > Q ∗ ) is placed. Produces substantial leftover inventory in non-uniform demand environments.
Periodic Order Quantity (POQ) :
Converts the calculated EOQ into an equivalent number of periods P P P : P = round ( Q ∗ d ˉ ) P = \text{round}\left(\frac{Q^*}{\bar{d}}\right) P = round ( d ˉ Q ∗ ) Whenever an order is triggered, P O R e c t PORec_t POR e c t is sized to cover the exact net requirements for the next P P P periods. Eliminates leftover inventory between orders while reducing order frequency.
- 7. Evolution: Closed-Loop MRP, MRP II, and ERP Evolution of Manufacturing Enterprise Systems
- ┌───────────────────────────┐
- │ Basic MRP │ Time-phased material explosion (Materials only, infinite capacity assumption)
- └─────────────┬─────────────┘
- ▼
- ┌───────────────────────────┐ Adds Capacity Requirements Planning (CRP) feedback loop to verify work center
- │ Closed-Loop MRP │ labor hours and machine capacity before finalizing shop releases
- └─────────────┬─────────────┘
- ▼
- ┌───────────────────────────┐ Integrates operational manufacturing with financial accounting, purchasing,
- │ MRP II (Mfg Resource Plan)│ master business planning, engineering design, and sales forecasting
- └─────────────┬─────────────┘
- ▼
┌───────────────────────────┐ Enterprise-wide relational database unifying manufacturing, global supply chains,
- │ ERP (Enterprise Resource) │ human capital, customer relationship management (CRM), and corporate financials
- └───────────────────────────┘
Closed-Loop MRP : Adds a closed feedback loop via Capacity Requirements Planning (CRP) . If planned order releases overload machine work centers, the master schedule is revised before release.
Manufacturing Resource Planning (MRP II) : Broadens closed-loop MRP to integrate all manufacturing resources: tooling, human resource capacity, direct cash flows, capital budgeting, and marketing sales plans.
Enterprise Resource Planning (ERP) : Modular, enterprise-spanning software platforms (SAP, Oracle) built upon unified central relational databases. ERP eliminates data silos across accounting, procurement, human resources, shop operations, and global logistics.
- 8. Step-by-Step Worked Engineering Calculations
- Worked Example 12.2.1: Aggregate Planning Cost Comparison (Chase vs. Level)
Problem : A manufacturer of commercial power equipment prepares an aggregate plan for the next 4 quarters. Demand forecasts are:
- Q1: 1,000 units
- Q2: 1,400 units
- Q3: 1,800 units
- Q4: 1,000 units
Total demand over the horizon is 5,200 units ( 1 , 300 units/quarter average 1,300\text{ units/quarter average} 1 , 300 units/quarter average ). Initial inventory at the start of Q1 is 0 units, and desired ending inventory at the end of Q4 is 0 units.
Operating parameters:
Each worker produces 100 units per quarter.
Current workforce at t = 0 t = 0 t = 0 : 10 workers (producing 1,000 units/quarter).
Regular time labor cost: $3,000 per worker per quarter.
Cost to hire a worker: $500.
Cost to lay off a worker: $800.
Inventory holding cost: $10 per unit remaining in inventory at the end of a quarter.
Backorders are strictly prohibited.
Compare the total cost of a Pure Chase Strategy versus a Pure Level Strategy .
Solution :
Plan A: Pure Chase Strategy (Match Demand Exactly Each Quarter)
Q1 : Demand = 1,000 units. Workers needed = 1 , 000 / 100 = 10 1,000 / 100 = 10 1 , 000/100 = 10 . Current workforce = 10. Hires = 0, Layoffs = 0. Cost = 0 0 0 .
Q2 : Demand = 1,400 units. Workers needed = 1 , 400 / 100 = 14 1,400 / 100 = 14 1 , 400/100 = 14 . Must hire 14 − 10 = 4 14 - 10 = 4 14 − 10 = 4 workers. Hiring cost = 4 × 500 = $ 2 , 000 4 \times 500 = \text{\textdollar}2,000 4 × 500 = $ 2 , 000 .
Q3 : Demand = 1,800 units. Workers needed = 1 , 800 / 100 = 18 1,800 / 100 = 18 1 , 800/100 = 18 . Must hire 18 − 14 = 4 18 - 14 = 4 18 − 14 = 4 workers. Hiring cost = 4 × 500 = $ 2 , 000 4 \times 500 = \text{\textdollar}2,000 4 × 500 = $ 2 , 000 .
Q4 : Demand = 1,000 units. Workers needed = 1 , 000 / 100 = 10 1,000 / 100 = 10 1 , 000/100 = 10 . Must lay off 18 − 10 = 8 18 - 10 = 8 18 − 10 = 8 workers. Layoff cost = 8 × 800 = $ 6 , 400 8 \times 800 = \text{\textdollar}6,400 8 × 800 = $ 6 , 400 .
Total Workforce Adjustment Cost : 2 , 000 + 2 , 000 + 6 , 400 = $ 10 , 400 2,000 + 2,000 + 6,400 = \text{\textdollar}10,400 2 , 000 + 2 , 000 + 6 , 400 = $ 10 , 400 .
Regular Labor Cost : Total worker-quarters = 10 + 14 + 18 + 10 = 52 10 + 14 + 18 + 10 = 52 10 + 14 + 18 + 10 = 52 worker-quarters. Labor Cost = 52 × 3 , 000 = $ 156 , 000 \text{Labor Cost} = 52 \times 3,000 = \$156,000 Labor Cost = 52 × 3 , 000 = $156 , 000
Inventory Holding Cost : Ending inventory is 0 at the end of every quarter ⟹ $ 0 \implies \text{\textdollar}0 ⟹ $ 0 .
Total Chase Cost : TC chase = $ 156 , 000 + $ 10 , 400 + $ 0 = $ 166 , 400 \text{TC}_{\text{chase}} = \$156,000 + \$10,400 + \$0 = \$166,400 TC chase = $156 , 000 + $10 , 400 + $0 = $166 , 400
Plan B: Pure Level Strategy (Constant Workforce & Output, Zero Backorders)
Because backorders are prohibited, the level production rate must be set high enough that cumulative production never falls below cumulative demand.
Let us evaluate cumulative demand:
End of Q1: 1,000 units
End of Q2: 1 , 000 + 1 , 400 = 2 , 400 units 1,000 + 1,400 = 2,400\text{ units} 1 , 000 + 1 , 400 = 2 , 400 units
End of Q3: 2 , 400 + 1 , 800 = 4 , 200 units 2,400 + 1,800 = 4,200\text{ units} 2 , 400 + 1 , 800 = 4 , 200 units
End of Q4: 4 , 200 + 1 , 000 = 5 , 200 units 4,200 + 1,000 = 5,200\text{ units} 4 , 200 + 1 , 000 = 5 , 200 units
If we produce the average demand of 1,300 units/quarter ( 5 , 200 / 4 5,200 / 4 5 , 200/4 ):
Cumulative production by Q3 = 3 × 1 , 300 = 3 , 900 units 3 \times 1,300 = 3,900\text{ units} 3 × 1 , 300 = 3 , 900 units . But cumulative demand is 4,200 units! This would cause a 300-unit stockout in Q3.
To prevent any stockout without backorders, peak cumulative demand occurs in Q3 (4,200 units over 3 quarters), requiring an output rate of at least 4 , 200 / 3 = 1 , 400 units/quarter 4,200 / 3 = 1,400\text{ units/quarter} 4 , 200/3 = 1 , 400 units/quarter !
Workers required = 1 , 400 / 100 = 14 1,400 / 100 = 14 1 , 400/100 = 14 workers constant throughout all 4 quarters.
Hiring / Layoff Cost : At start of Q1, hire 14 − 10 = 4 14 - 10 = 4 14 − 10 = 4 workers: 4 × 500 = $ 2 , 000 4 \times 500 = \text{\textdollar}2,000 4 × 500 = $ 2 , 000 . Retained for all 4 quarters; 0 layoffs.
Regular Labor Cost : 14 × 4 × 3 , 000 = 56 × 3 , 000 = $ 168 , 000 14 \times 4 \times 3,000 = 56 \times 3,000 = \text{\textdollar}168,000 14 × 4 × 3 , 000 = 56 × 3 , 000 = $ 168 , 000 .
Quarterly Inventory Tracking :
Q1 : Produce 1,400, Demand 1,000 ⟹ \implies ⟹ Ending Inventory I 1 = 0 + 1 , 400 − 1 , 000 = 400 units I_1 = 0 + 1,400 - 1,000 = 400\text{ units} I 1 = 0 + 1 , 400 − 1 , 000 = 400 units .
Q2 : Produce 1,400, Demand 1,400 ⟹ \implies ⟹ Ending Inventory I 2 = 400 + 1 , 400 − 1 , 400 = 400 units I_2 = 400 + 1,400 - 1,400 = 400\text{ units} I 2 = 400 + 1 , 400 − 1 , 400 = 400 units .
Q3 : Produce 1,400, Demand 1,800 ⟹ \implies ⟹ Ending Inventory I 3 = 400 + 1 , 400 − 1 , 800 = 0 units I_3 = 400 + 1,400 - 1,800 = 0\text{ units} I 3 = 400 + 1 , 400 − 1 , 800 = 0 units .
Q4 : Produce 1,400, Demand 1,000 ⟹ \implies ⟹ Ending Inventory I 4 = 0 + 1 , 400 − 1 , 000 = 400 units I_4 = 0 + 1,400 - 1,000 = 400\text{ units} I 4 = 0 + 1 , 400 − 1 , 000 = 400 units .
Inventory Holding Cost : Holding Cost = ( 400 + 400 + 0 + 400 ) × $ 10 = 1 , 200 × 10 = $ 12 , 000 \text{Holding Cost} = (400 + 400 + 0 + 400) \times \$10 = 1,200 \times 10 = \$12,000 Holding Cost = ( 400 + 400 + 0 + 400 ) × $10 = 1 , 200 × 10 = $12 , 000
Total Level Cost : TC level = $ 168 , 000 + $ 2 , 000 + $ 12 , 000 = $ 182 , 000 \text{TC}_{\text{level}} = \$168,000 + \$2,000 + \$12,000 = \$182,000 TC level = $168 , 000 + $2 , 000 + $12 , 000 = $182 , 000
Cost Difference : The Chase Strategy is more economical by $ 182 , 000 − $ 166 , 400 = $ 15 , 600 \text{\textdollar}182,000 - \text{\textdollar}166,400 = \text{\textdollar}15,600 $ 182 , 000 − $ 166 , 400 = $ 15 , 600 under these strict no-backorder conditions.
Worked Example 12.2.2: Available-to-Promise (ATP) Calculation
Problem : An electronics plant schedules production for a high-end industrial router. The current on-hand inventory is 60 units. The master production schedule has planned completions of 200 units in Week 1 and 200 units in Week 4. Customer booked orders are logged as shown below:
- Week 1 2 3 4 5 6
- MPS Replenishment 200 0 0 200 0 0
- Customer Booked Orders 90 50 40 110 30 20
Calculate the Available-to-Promise (ATP) quantities for Week 1 and Week 4.
Solution :
Step 1: Calculate ATP for Week 1
For Week 1 ( t = 1 t = 1 t = 1 ), ATP incorporates beginning on-hand inventory ( I 0 = 60 I_0 = 60 I 0 = 60 ) plus the MPS receipt ( MPS 1 = 200 \text{MPS}_1 = 200 MPS 1 = 200 ).
Booked customer orders are accumulated across all weeks up to, but not including, the next MPS replenishment week (Week 4). Thus, sum booked orders for Weeks 1, 2, and 3: ∑ Orders = 90 + 50 + 40 = 180 units \sum \text{Orders} = 90 + 50 + 40 = 180\text{ units} ∑ Orders = 90 + 50 + 40 = 180 units
Calculate ATP 1 \text{ATP}_1 ATP 1 : ATP 1 = ( I 0 + MPS 1 ) − ∑ τ = 1 3 Orders τ = ( 60 + 200 ) − 180 = 260 − 180 = 80 units \text{ATP}_1 = (I_0 + \text{MPS}_1) - \sum_{\tau=1}^3 \text{Orders}_\tau = (60 + 200) - 180 = 260 - 180 = 80\text{ units} ATP 1 = ( I 0 + MPS 1 ) − τ = 1 ∑ 3 Orders τ = ( 60 + 200 ) − 180 = 260 − 180 = 80 units
Step 2: Calculate ATP for Week 4
For Week 4 ( t = 4 t = 4 t = 4 ), a new MPS replenishment of 200 units arrives. On-hand inventory is not added again because it was fully accounted for in Week 1.
Sum booked customer orders from Week 4 up to the end of the horizon (Weeks 4, 5, and 6): ∑ Orders = 110 + 30 + 20 = 160 units \sum \text{Orders} = 110 + 30 + 20 = 160\text{ units} ∑ Orders = 110 + 30 + 20 = 160 units
Calculate ATP 4 \text{ATP}_4 ATP 4 : ATP 4 = MPS 4 − ∑ τ = 4 6 Orders τ = 200 − 160 = 40 units \text{ATP}_4 = \text{MPS}_4 - \sum_{\tau=4}^6 \text{Orders}_\tau = 200 - 160 = 40\text{ units} ATP 4 = MPS 4 − τ = 4 ∑ 6 Orders τ = 200 − 160 = 40 units
Operational Result : Sales representatives can immediately promise up to 80 additional units for delivery anytime in Weeks 1–3, and up to 40 additional units for delivery in Weeks 4–6.
9. NCEES Reference Handbook Tips & Realistic Exam Traps
ATP Lookahead Order Summing Trap : In discrete ATP calculations, remember to sum all booked customer orders between the current MPS replenishment and the next MPS replenishment. Do not subtract only the current week's order. For Week 1, subtract booked orders for Weeks 1, 2, and 3!
On-Hand Inventory in ATP : Beginning on-hand inventory ( I 0 I_0 I 0 ) is added only to the first ATP period ( ATP 1 \text{ATP}_1 ATP 1 ). Never add beginning inventory to subsequent MPS replenishment periods ( ATP 4 , ATP 7 \text{ATP}_4, \text{ATP}_7 ATP 4 , ATP 7 , etc.).
Lead Time Offsetting Direction : Planned Order Receipts occur when the material is needed ( t t t ). Planned Order Releases occur at t − L t - L t − L . A common exam error is adding lead time ( t + L t + L t + L ), which would schedule the release after the assembly is already due!
Dependent vs. Independent Demand : Never apply statistical forecasting methods (SES, moving average) to subassemblies or component parts with dependent demand. Component demand is strictly exploded mathematically from parent Planned Order Releases via the BOM.
Low-Level Code Numbering : Level 0 is the top-level finished product. The higher the numeric level code (Level 1, Level 2, Level 3), the lower the part is in the product hierarchy. Low-level coding assigns a shared component its highest numerical level index .