← All expertise Expertise

Forecasting & demand planning

Annual targets into daily plans, with forecasting methods from my MSc.

Excel/VBAForecasting & MAPEPower BI (developing)
~20dealerships planned (freelance)
365days of plan per dealer and model

Day to day

A developing capability: demand turned into plans at Atlas Honda and in freelance work, with forecasting methods from my MSc.

  • At Atlas Honda, converted sales requirements into build plans.
  • Freelance: split annual dealer targets by model and month, with launch-month rules, into whole-number daily plans.
  • Independent rebuild on invented data: pace tracking against plan and monthly dealer reports.
  • MSc: moving averages, exponential smoothing, MAPE and forecast bias, intermittent and promotional demand, and what each means for safety stock.

How it runs

  1. TargetOne number per dealer for the year.
  2. SeasonalityTwelve monthly percentages that always add to 100.
  3. Model mixSplit by model, honouring launch timing.
  4. Daily planWhole-number daily figures, tracked against actuals.

What I know

Methods

Moving averagesExponential smoothingMAPE & forecast biasIntermittent demandPromotional demandSeasonality splitsSafety stock links

What I improved

Planning should turn complexity into action.

Open to Production Planner, Materials Planner, Production Controller and Supply Chain Planning roles in the UK.

ContactStraight to my inbox

Send me a message

I’ll reply to the email address you give here.