Demand Forecast Model Comparison
Budget: $10 – $30 USD
I’m working with a time-series of more than 200 sales records and want a clear, side-by-side evaluation of three forecasting techniques. Inside a single Excel workbook, build:
• Moving Average, Exponential Smoothing, and ARIMA forecasts, each driven by visible cell formulas (no hidden VBA or plug-ins).
• Accuracy metrics—at least MAPE and MAD—for every method so I can instantly see which line tracks actual demand most closely.
• Clean tables of the calculated values plus overlaid charts that plot actual vs. forecast for each technique as well as a concise error-comparison dashboard.
The sheet should remain fully editable: if I drop in fresh sales data the formulas must update and the charts realign automatically. Feel free to stage intermediate calculations on separate tabs, but keep the final summary intuitive and print-ready.
I’ll provide the raw sales data as soon as we start; you return the finished workbook along with a short note explaining any model assumptions or parameter choices.
• Moving Average, Exponential Smoothing, and ARIMA forecasts, each driven by visible cell formulas (no hidden VBA or plug-ins).
• Accuracy metrics—at least MAPE and MAD—for every method so I can instantly see which line tracks actual demand most closely.
• Clean tables of the calculated values plus overlaid charts that plot actual vs. forecast for each technique as well as a concise error-comparison dashboard.
The sheet should remain fully editable: if I drop in fresh sales data the formulas must update and the charts realign automatically. Feel free to stage intermediate calculations on separate tabs, but keep the final summary intuitive and print-ready.
I’ll provide the raw sales data as soon as we start; you return the finished workbook along with a short note explaining any model assumptions or parameter choices.