Active forecasts include planned business changes, while passive forecasts extend historical demand. Compare both approaches on the same sales rows, retain an assumption bridge and measure errors without hiding offsetting misses.
Active and passive demand forecasting differ in whether the forecast explicitly incorporates planned business changes or extends a historical baseline. Use a passive forecast as the reference case and an active forecast when documented changes justify adjustments. Compare both with the same actual demand before deciding which assumptions deserve to remain.
These labels describe planning approaches, rather than a required pair of statistical methods. For this comparison, passive means a forecast based on historical demand patterns, without separately adding a planned commercial change. Active means that same baseline plus explicit adjustments for changes the business expects to implement.
| Question | Passive approach | Active approach |
|---|---|---|
| Starting point | Historical demand baseline | The same historical baseline |
| Planned business changes | No separate adjustment | Explicit additions or reductions |
| Typical use | Comparable operations and a benchmark | New distribution, promotions or other changes |
| Evidence needed | Relevant, consistently defined history | History plus support for each adjustment |
| Main review question | Does history remain representative? | Did the adjustment improve the forecast? |
A passive forecast can still reflect seasonality or an established trend. Active does not mean more complicated arithmetic, and passive does not mean the business has stopped making decisions. Both are estimates of demand under assumptions.
The demand forecasting guide covers the broader planning choices. Keep the approach distinct from a management target: a target records what the business wants to achieve, while the forecast estimates what it expects.
Use a sales or order workbook with product, channel, period and net units. Choose one demand measure and retain it throughout; do not compare a forecast of booked orders with actual shipments.
Save the historical baseline, forecast date, adjustment amount, adjustment reason and actual demand on each product-period row. Separate reasons matter. A distribution expansion and a promotion can overlap, so adding both at their full estimated effect may double count the same purchases.
The authors of Forecasting: Principles and Practice recommend making judgmental adjustments when important additional information is available, rather than making unsupported changes to a statistical forecast. Apply the same discipline to a simple workbook: record why history alone misses something relevant.
The comparison is:
Passive forecast = historical baseline
Active forecast = historical baseline + documented demand adjustments
Signed miss = forecast − actual demand
Positive signed misses indicate overforecasting; negative misses indicate underforecasting. Keep absolute misses alongside them to reveal offsetting errors.
A fictional US office-products supplier prepares its April 2026 forecast on March 1, 2026. Its passive baseline repeats April 2025 net order units without a growth adjustment. The active scenario adds quantities supplied by the commercial team; these are planning assumptions, not measured effects.
| Product | April 2025 units / passive baseline | Planned change | Incremental units | Active forecast | April 2026 actual units |
|---|---|---|---|---|---|
| Task lamps | 1,000 | Promotion | 150 | 1,150 | 1,120 |
| Monitor arms | 1,200 | Additional distributor | 240 | 1,440 | 1,390 |
| Desk organizers | 800 | Bundle offer | 80 | 880 | 790 |
| Total | 3,000 | — | 470 | 3,470 | 3,300 |
With this table in A:F, calculate the active forecast in E2 and fill down:
=B2+D2
The bridge reconciles: 3,000 baseline units + 470 adjustment units = 3,470 active units. Each adjusted forecast still needs evaluation against the same actual row.
| Product | Passive signed miss | Passive absolute miss | Active signed miss | Active absolute miss |
|---|---|---|---|---|
| Task lamps | -120 | 120 | 30 | 30 |
| Monitor arms | -190 | 190 | 50 | 50 |
| Desk organizers | 10 | 10 | 90 | 90 |
| Total | -300 | 320 | 170 | 170 |
Add G:J to the first table for the error calculations:
=B2-F2
=ABS(G2)
=E2-F2
=ABS(I2)
The active signed miss must equal the passive signed miss plus the adjustment. For task lamps, −120 + 150 = 30; for monitor arms, −190 + 240 = 50; for organizers, 10 + 80 = 90. The total also reconciles: −300 + 470 = 170.
Across products, divide summed absolute misses by summed actual demand:
=SUM(H2:H4)/SUM(F2:F4)
=SUM(J2:J4)/SUM(F2:F4)
Passive absolute error is 320 / 3,300 = 9.7%; active absolute error is 170 / 3,300 = 5.2%, rounded to one decimal place. Active performs better overall in this example, yet the organizer adjustment makes that product's miss worse.
Use passive forecasting when recent patterns remain relevant and no additional evidence supports a change. Use active forecasting when a known business event changes the expected demand, with an owner and a stated quantity behind each adjustment.
Evaluate saved forecasts on periods that were unknown when the estimates were made. The textbook's forecast evaluation guidance distinguishes performance on new data from how closely a method fits historical observations. One successful month does not establish a lasting advantage.
Review several comparable periods and retain both the total and product-level results. The forecast accuracy guide explains why horizon matters, while demand forecast bias by SKU and site addresses persistent directional misses.
Keep ownership and version dates explicit through the demand forecasting process. That makes the next comparison reproducible.
Upload a file or Google Sheet containing baseline forecasts, documented adjustments and actual demand. Covirage maps the columns, and its tools compute and check the comparisons; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See forecast analysis for the supporting workflow.
It is especially useful when operations and demand patterns remain comparable, but it also provides a benchmark during growth. Retaining the historical baseline helps a changing business test whether its additional assumptions improved the forecast.
No. A target states the result management wants; a forecast estimates the result expected under stated assumptions. Planned commercial activity can inform a forecast, but its expected demand effect needs evidence rather than a target gap.
Yes. Keep a baseline column, separate adjustment columns, an active total and actual demand for each product-period row. Preserve the dated version used for planning so later revisions do not overwrite the comparison.