Which demand-forecasting approach would you fund for a retail inventory rollout?
Instruction: Calculate the cost and service tradeoffs, choose an approach, and explain how the backtest and rollout would support that decision.
A fictional retailer must choose its current seasonal forecast or a machine-learning forecast for replenishment. Both were evaluated on the same eight unseen weeks, using only information available at each forecast date and the same two-week lead time and ordering policy. The holdout covers the stores and product groups in the proposed rollout, including ordinary promotions. Daily requests include recorded unfilled orders, so demand is not limited to completed sales.
The exhibit reports weekly averages. Every week has 10,000 requested units. Each unfilled unit costs an expected $12 in lost contribution; each excess unit costs $3 in holding or disposal for the period. These charges are not counted elsewhere. Incremental forecast operating cost is shown separately. All figures and costs are invented for this exercise.
| Weekly measure | Seasonal baseline | Machine-learning forecast |
|---|---|---|
| Unfilled requested units | 400 | 250 |
| Excess units | 600 | 700 |
| Incremental forecast operating cost | $0 | $300 |
| Worst weekly unit fill rate in the holdout | 95.7% | 97.3% |
| Highest weekly excess stock | 650 units | 760 units |
The minimum weekly unit fill rate is 97%; storage can accommodate up to 800 excess units. The machine-learning option saved $900–$1,500 in each holdout week after its operating cost. Either approach can use the current replenishment integration. There is no separate implementation charge for this decision. Recommend which approach to fund for the represented stores.
Updated
Official answer available
Read the opening below, then unlock the full answer and practical guidance.
I would fund the machine-learning forecast for the represented stores. The seasonal baseline costs $6,600 a week under the stated assumptions; the machine-learning option costs $5,400 including its $300 operating cost. That is a $1,200 weekly improvement, about 18.2%, with positive savings in all eight holdout weeks. The service constraint also favors that choice. Average unit fill rate rises from 96% to 97.5%, and the model’s worst week remains above the required 97%...
Related Questions
-
easy
-
easy
-
easy
-
easy
-
easy
-
easy