Historical vs forecast sales
Trend analysis
Business Challenge
Purchasing and staffing are planned on instinct, leading to stock-outs in some periods and excess inventory in others.
Forecasting Methodology
Historical sales are cleaned, decomposed into trend and seasonality, and projected with statistical time-series methods. Forecasts are shown with a confidence interval to express uncertainty.
Model Evaluation
Models are validated by holding back recent periods and comparing actual against forecast. No accuracy figures are reported here because this demonstration has not been calculated on real data.
Results
The chart shows the intended output: actual history, a dashed forecast and a shaded interval that widens further into the future. Values are illustrative.
Business Recommendations
Use forecasts to set reorder points, plan seasonal stock ahead, review forecasts against actuals each period, and treat the interval, not a single number, as the planning range.
