lamp.
ResourcesPricingAbout

Moving average

A moving average is the average of a fixed number of the most recent periods, recalculated as each new period arrives, used to smooth short-term swings.

What it means

A three-month moving average adds the last three months and divides by three, then drops the oldest month when the next arrives. It reduces the noise from one unusually strong or weak month and makes the direction clearer. The cost is lag: it reacts slowly to a real change. Planners use it for rough demand forecasts and for stock reorder levels.

Example

A spare parts dealer sells 420, 380 and 460 units over three months, a three-month average of 420. When the next month sells 500, the average becomes 447, using 380, 460 and 500. The dealer uses 447 to plan next month's purchase.

Records and checks

  • Record the period values used, the window length and the date the average was calculated.
  • Verify the window drops the oldest value each time and that no month is missing.
  • The planner maintains it, and the purchase head uses it with a review for known seasonal peaks.

Common mistakes

  • Choosing a window so long that the average is always behind real demand.
  • Using it on seasonal products without adjusting for the season.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →