Worked example: a moving-average forecast and a plan above the trend
A brand plans next week’s sales of a style. The weekly sales and the plan figure are illustrative.
Figures
- Sales over 4 weeks
- 100, 120, 110, 130 pcs
- Moving average (calculation)
- (100 + 120 + 110 + 130) / 4 = 115 pcs
- Plan for the week
- 135 pcs
- Plan versus average (calculation)
- 135 / 115 − 1 ≈ +17.4%
Lesson
If the plan is clearly above a simple average, it needs a reason: a promotion, a delivery, a season. Write it next to the figure and compare the plan with actual a week later: this shows systematic overstating.