Does 100% attainment mean perfect forecasting?

No. Offsetting errors can produce an exact total match.

Is 120% always better than 100%?

No. It can indicate underforecasting and unexpected operational pressure.

Why preserve forecast snapshots?

They show what was anticipated when the relevant decision had to be made, allowing a fair comparison with later outcomes.

AI Glossary / Statistics and probability / Intermediate

Forecast attainment

Definition

Forecast attainment is an operational comparison of an actual outcome with the forecast prepared for that outcome. A common aggregate definition is total actual quantity divided by total forecast quantity, multiplied by 100 to express a percentage. In demand planning, the forecast should be a preserved snapshot from an explicitly chosen earlier date or decision lag. An attainment of 100% means the selected actual and forecast totals match. It does not mean every item was forecast correctly or that the forecast was a perfectly accurate prediction.

What it means

The measure describes how realized activity compares with the anticipated total for a stated scope. Values above 100% indicate that actual quantity exceeded forecast quantity, while values below 100% indicate the opposite when the denominator is positive. Neither direction is automatically desirable. Unexpectedly high demand can strain capacity, and an intentionally low forecast can make attainment look impressive without improving planning. A forecast is an expectation; a target or quota is an aspiration. Comparing results with a target is a different exercise even if the arithmetic looks similar.

How it works

Choose the actual measure, reference period, aggregation level and forecast snapshot before calculating the ratio. Align products, locations, units and timing between numerator and denominator. Sum actuals and forecasts over that same scope, then divide total actuals by total forecasts. Keep the forecast version available when the relevant planning decision was made, rather than replacing it with a later revision. Specify how returns, cancellations, substitutions and zero forecasts are handled. If the forecast total is zero, the ordinary ratio is undefined. Inspect absolute errors and segment-level results alongside attainment because positive and negative item errors can cancel in the aggregate.

Three practical examples

Demand planning: compare monthly shipments with the forecast frozen at the replenishment decision horizon.
Capacity review: examine whether realized workload matched the volume anticipated when staffing was arranged.
Sales operations: compare actual revenue with a dated revenue forecast while keeping quota attainment and price effects separate.

Think of it this way

Think of checking the total weight of a packed suitcase against the planned weight. The total might match exactly even if one needed item is missing and another is duplicated. Matching the overall quantity does not guarantee that the composition was right.

Worked example

Suppose a hypothetical planning snapshot forecasts 80 units of product A and 120 of product B. Actual shipments are 110 and 90 units. Total forecast and actual shipments both equal 200, so aggregate attainment is 200/200 times 100 = 100%. Yet item errors, defined as actual minus forecast, are +30 and -30. Total absolute error is 60 units, and absolute error divided by total actual volume is 60/200 = 30%. Product-level attainment is 137.5% for A and 75% for B. Their unweighted average is 106.25%, which is not the aggregate ratio. Weighting each item ratio by its share of forecast quantity, 40% and 60%, gives 100%. Thus the definition of aggregation materially changes the reported number. This example demonstrates arithmetic and cancellation; it does not assign a universal acceptable error threshold.

Illustrative case study

Fictional case: Maple Supply Review reports overall attainment near 100% and initially assumes its demand plan was reliable. Analysts break the result down by product family and find offsetting shortages and excess stock. They retain attainment as a top-level comparison but add item-level absolute errors and service measures. They also preserve the forecast available when purchase orders were placed. This invented case illustrates why a balanced total can coexist with an operationally troublesome mix and why historical forecast versions belong in performance records.

Common misconceptions and mistakes

Do not label attainment as accuracy without explaining its limits. Do not average item percentages and assume the result equals the ratio of totals. A shipment shortfall may reflect supply constraints rather than weak customer demand. A revenue ratio can change because of prices or mix, even when unit demand behaves differently. Comparing actuals with a revised forecast published after much of the period has elapsed can obscure the quality of the original decision. Zero or negative denominators require explicit treatment rather than arbitrary replacement values. One period's imbalance is not conclusive evidence of persistent bias.

Business use

Businesses can use attainment to start a planning review, provided its scope and timing are visible. Pair it with measures of error magnitude, service, capacity and inventory that reveal different consequences. Drill down where aggregate cancellation hides important variation. Establish whether actuals represent orders, unconstrained demand, shipments or recognized revenue; these quantities are not interchangeable. Keep policy thresholds tied to the organization's decisions and costs rather than treating a particular percentage band as a universal standard. A useful review explains discrepancies and improves future assumptions instead of rewarding low forecasts for being easy to exceed.

Check your understanding

Two products have equal and opposite quantity errors. Can total attainment still equal 100%?

Answer: Yes. The errors cancel in the total, so an absolute-error measure and product-level review are needed to expose the mismatch.

Related terms

Forecast bias
Forecast horizon
forecast accuracy
forecast snapshot
weighted absolute percentage error
sales and operations planning
quota attainment
demand planning

Learn next

Learn how signed and absolute forecast errors answer different questions. Then study aggregation, decision horizons and the distinction between unconstrained demand and shipments before choosing an operational forecasting dashboard.

Sources

Mark Chockalingam, conference presentation, forecast attainment calculation: https://www.newenglandsupplychainconference.org/docs/2005/Chockalingam_Optimizing%20Inventory%20Management%20Using%20Demand%20Me.pdf Demand Planning LLC, Key Demand Metrics: https://demandplanning.net/demand-metrics-wmape-wape/ Hyndman and Athanasopoulos, Forecasting: Principles and Practice, forecast evaluation: https://otexts.com/fpp3/toolbox.html

Previous: Force control Next: Forecast bias