Worked example: one number, two definitions of forecast error
The sales forecast for a style was 120 units, actual 100. Two departments calculate the error differently. The numbers are illustrative.
Figures
- Forecast and actual
- 120 and 100 pcs
- Error to actual (calculation)
- (120 − 100) / 100 = +20%
- Error to forecast (calculation)
- (120 − 100) / 120 ≈ +16.7%
Lesson
Without a written definition the indicator is disputed: 20% and 16.7% describe the same thing. Keep an indicator dictionary with the formula, unit and source and check reports against it.