Study guide
5.3 Forecast Performance
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
5.3 Forecast Performance
Key Takeaways Explain This Topic AI
Bias is the average signed error and reveals systematic over- or under-forecasting; MAD averages absolute errors and measures magnitude.
MAPE expresses average absolute error as a percent of actual demand, enabling comparison across items with different volumes.
Tracking signal = running sum of forecast errors ÷ MAD; values beyond control limits indicate the model is out of control.
Pyramid forecasting forces consistency between family-level and SKU-level forecasts through aggregation and disaggregation.
Forecast consumption replaces forecast with actual customer orders as bookings arrive so supply plans are not double-counted.
Last updated: July 2026
A forecast that is never measured never improves. CPIM Domain III expects you to compute and interpret core error metrics, recognize when a model is drifting, keep hierarchical forecasts consistent, and understand how actual orders consume the forecast inside master planning.
Forecast Error Basics
For any period t:
e(t) = A(t) − F(t)
Sign convention matters for bias . If actuals consistently exceed forecasts, errors are positive and the forecast is biased low (under-forecasting). If forecasts exceed actuals, errors are negative and the forecast is biased high (over-forecasting). Some texts define error as F - A; on the exam, read the stem carefully and stay consistent with the formula given.
Bias (Mean Error)
Bias (mean forecast error) over n periods:
Bias = (Σ e(t)) / n = (Σ (A(t) − F(t))) / n
Worked example. Four periods:
- Period Actual A Forecast F Error A−F
- 1 100 90 +10
- 2 110 100 +10
- 3 95 105 −10
- 4 120 100 +20
Sum of errors = 10 + 10 − 10 + 20 = +30. Bias = 30 / 4 = +7.5 . On average the forecast is 7.5 units too low. Bias near zero can still hide large misses that cancel (over one month, under the next), so bias alone is incomplete.
- MAD — Mean Absolute Deviation
- MAD = (Σ |e(t)|) / n
Using the same table, absolute errors are 10, 10, 10, 20. Sum = 50. MAD = 50 / 4 = 12.5 . MAD answers “how large are typical errors?” regardless of direction. Safety-stock formulas in many APICS contexts use MAD (or a related σ estimate) as the variability input.
- MAPE — Mean Absolute Percentage Error
- MAPE = (100% / n) × Σ | (A(t) − F(t)) / A(t) |
(undefined if any actual is zero—another exam trap).
For period 1: |100−90|/100 = 0.10. Period 2: 10/110 ≈ 0.0909. Period 3: 10/95 ≈ 0.1053. Period 4: 20/120 ≈ 0.1667. Average ≈ 0.1157 → MAPE ≈ 11.6% .
MAPE lets you compare a high-volume SKU (errors of 500 units) with a low-volume SKU (errors of 5 units) on a common percentage scale. It can overweight periods with tiny actuals, so interpret cautiously for intermittent demand.
- Metric Captures Limitation
- Bias Systematic direction Cancelling errors look “good”
- MAD Typical error size Units not comparable across SKUs
- MAPE Relative error % Unstable near zero actuals
- Tracking signal Persistent bias vs noise Needs stable MAD denominator
- Tracking Signal — Worked Example
The tracking signal (TS) monitors whether bias is accumulating beyond what random error would explain:
- TS = (Σ e(t)) / MAD
- (Algebraic sum of errors, sometimes called the running sum of forecast errors / RSFE, divided by MAD.)
Continuing the example: RSFE = +30, MAD = 12.5, so TS = 30 / 12.5 = +2.4 .
Organizations set control limits such as ±3 or ±4. If TS exceeds the limit, the forecast is out of control —investigate level shifts, missing seasonality, or broken promotions assumptions; do not silently keep using the model. A TS near zero with a high MAD means errors are large but not systematically one-sided.
MSE, CFE, and Demand Filters
The ECM names three more error tools that candidates routinely skip.
Mean squared error (MSE) squares each error before averaging:
MSE = (Σ e(t)²) / n
Using the same four periods (errors +10, +10, −10, +20): 100 + 100 + 100 + 400 = 700, so MSE = 700 / 4 = 175 . Taking the square root gives the root mean squared error (RMSE) ≈ 13.2 units , which is back in the original unit of measure. Because squaring inflates large misses, MSE punishes a single big miss far more than several small ones . Compare it with MAD = 12.5 on the identical data: MAD treats a 20-unit error as twice a 10-unit error, while MSE treats it as four times worse. Choose MSE when one catastrophic miss hurts more than steady small noise; choose MAD when all misses hurt proportionally.
Cumulative forecast error (CFE) is the running algebraic sum of errors — the same quantity as the RSFE in the tracking-signal numerator:
CFE = Σ e(t)
Here CFE = +30 units . A CFE that drifts steadily away from zero is the signature of bias; a CFE that oscillates around zero is random noise. This is why TS = CFE / MAD: it scales accumulated bias against typical error size.
Demand filters work in the opposite direction — they screen the incoming actual before it corrupts history. A demand filter sets a threshold, commonly a multiple of MAD (3 × MAD or 4 × MAD is typical), beyond which an actual demand value is held for human review rather than absorbed automatically.
With MAD = 12.5 and a 4 × MAD filter, the tripwire is 50 units from forecast. A period that forecasts 100 and books 165 (error +65) breaks the filter and gets reviewed: was it a genuine market shift, a one-time tender, or a data-entry error of 165 for 16.5? Without the filter, that single record inflates the average, raises the safety stock calculation, and pushes a phantom requirement through MRP.
- Tool What it answers Exam trap
- MSE / RMSE How bad are the worst misses? Squaring means MSE is not in demand units; RMSE is
- CFE (RSFE) Is error accumulating in one direction? Near-zero CFE does not mean small errors
Demand filter Is this actual believable enough to keep? Filters flag data for review; they do not delete demand
Pyramid Forecasting
Pyramid forecasting maintains consistency across hierarchy levels (SKU → family → category → total business):
Force-down / top-down — management sets a family or business total; the system disaggregates to SKUs using historical mix percentages or planning bills.
Bottom-up — SKU forecasts sum to the family total.
Middle-out / reconciliation — both directions are prepared, then adjusted so the pyramid adds up.
Without a pyramid discipline, marketing’s family outlook of 10,000 units can coexist with SKU forecasts that sum to 12,500—guaranteeing either phantom shortages or excess. CPIM emphasizes that aggregation reduces noise (family forecasts are often more accurate percentage-wise) while disaggregation is required for execution at SKU-location. Pyramid logic is how you get both.
Forecast Consumption by Actual Orders
In master scheduling, the demand time fence and consumption logic determine how customer orders interact with the forecast :
As orders book in a period, they consume (reduce) the remaining forecast for that period so total demand is not forecast + orders.
If orders exceed the forecast, many systems display the overage as additional demand (and may consume adjacent periods depending on rules).
Inside the demand time fence, management often relies more on orders than on forecast; outside the fence, forecast dominates.
Simple illustration. Week 5 forecast = 100. By Monday, firm orders = 40. Remaining forecast to plan = 60 (unless policy says otherwise), and total projected demand still centers on 100 unless orders exceed it. If firm orders reach 120, projected customer demand becomes 120—not 220.
Consumption rules vary by software, but the principle is universal: never double-count . Planners who add bookings on top of an unconsumed forecast inflate the MPS, overload capacity, and then wonder why inventory explodes when the “extra” never was real incremental demand.
Closing the Performance Loop
Measure bias, MAD, and MAPE by item family on a regular cadence. Watch tracking signals for model failure. Reconcile hierarchies with pyramid forecasting. Configure consumption so actual orders displace forecast cleanly. Together these practices turn forecasting from a monthly argument into a controlled process—and that is exactly the competence Domain III assesses.