Syntha Lab RU

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.

Example illustrative example

Open interactively →

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.

Where to apply it in Lab

Open interactively →