I will build an excel demand forecasting model with accuracy tracking

Need a reliable demand forecast without buying expensive planning software? I will build a demand forecasting model in Excel that tests several forecasting methods on your own sales history, picks the most accurate one for each product and turns it into a 12-month plan.

WHAT YOU GET

• Backtest of up to 5 methods per SKU: naive, moving average, seasonal naive, exponential smoothing and linear trend
• - Automatic best-method selection per SKU, ranked by WAPE
• - Forecast accuracy, bias and tracking signal with GOOD / WATCH / POOR flags
• - 12-month forecast plan in units and value
• - Safety stock and reorder points by ABC service level (Premium)
• - Dashboard with KPIs, accuracy by product family, exception list and charts

WHY WORK WITH ME

I am a supply chain and operations manager with 10+ years in manufacturing and FMCG, an MBA in Supply Chain Management and CMRP certification. I build the planning tools I use at work.

Fully formula-driven, no macros. You paste your sales history and everything updates. The gallery shows a sample deliverable with illustrative data.

Please message me before ordering with your number of SKUs and months of history.