Book Sales Demand Forecasting
Weekly demand forecasting for two long-selling book titles, comparing statistical, machine-learning, deep-learning and hybrid models on the final 32 weeks of sales.
The Challenge
A seasonal SARIMA model forecast 32 weeks of sales with 19.6% MAPE for one title and matched an LSTM on the other, while hybrid models added nothing.
Publishers decide on reorders, reprints and stock levels months ahead. Some titles sell steadily for years with strong seasonal peaks; others spike and fade. The question was which forecasting approach gives reliable weekly demand projections for long-selling titles, and whether more complex models are worth their cost.
Approach
Results
| Model (32-week test) | Title A MAE | Title A error | Title B MAE | Title B error |
|---|---|---|---|---|
| SARIMA | 169.3 | MAPE 31.9% | 382.3 | MAPE 19.6% |
| LSTM | 170.6 | MAPE 22.2% | 592.2 | MAPE 28.1% |
| Parallel hybrid | 181.6 | sMAPE 34.8% | 1,174.4 | sMAPE 61.8% |
| Sequential hybrid | 214.3 | sMAPE 39.8% | 1,096.5 | sMAPE 56.6% |
SARIMA was the best model for Title B. For Title A, SARIMA and the LSTM were level on absolute error, with the LSTM ahead on percentage error. Neither hybrid improved on the single models; the optimised blend weight came out at zero, meaning one model on its own was preferred.
For planning, the practical finding is that a well-specified seasonal model is a strong default for long-selling titles, and more complex models should be adopted only where they beat it on held-out data.
Known issues: the weekly XGBoost forecasts stayed flat at about 50 units against actual sales of 1,000-3,500 (a feature-update bug), so XGBoost is excluded. Title B's series was smoothed before the train/test split, which flatters its SARIMA error. Hybrid errors are sMAPE, not MAPE, so they are not directly comparable with the first two rows. Monthly SARIMA failed to produce forecasts; monthly XGBoost MAPE was 48.3% and 27.4%.
How it was tested
- Every model scored on the same held-out final 32 weeks, on MAE and percentage error, for two titles.
- Decomposition, ACF/PACF and stationarity tests before SARIMA; LSTM tuned with KerasTuner.
- The weekly XGBoost forecasts stayed flat at about 50 units against actual sales of 1,000-3,500, a feature-update bug, so XGBoost is excluded.
- Title B's series was smoothed before the train/test split, which flatters its SARIMA error.
- Neither hybrid improved on the single models; the optimised blend weight came out at zero.
- Monthly SARIMA failed to produce forecasts.
- Hybrid errors are sMAPE, not MAPE, so they are not directly comparable with the single models' percentage errors.