Model library › Why stock levels swing when demand rises
Why stock levels swing when demand rises
Customers buy 20% more, once. A shop, a wholesaler and a factory each order from the next one up and wait three weeks for deliveries, and the factory swings far more than anyone expected. With scenarios for the fixes.
Open it, press Play, then move the sliders and compare the scenarios.
What the model shows
Customers buy 20% more from week 5 and keep doing so. The shop orders a little more, the wholesaler more still, and the factory swings hardest: first far too much, then far too little. Nobody does anything wrong: each stage forecasts its incoming orders, refills its own stock, and waits three weeks for deliveries. Try: the scenario "Count the orders already on the way" (Pipeline_Weight = 1), slower stock correction, or faster deliveries. What this model leaves out: limited production capacity, stock-outs that lose sales, information shared along the chain, and costs. Time unit: weeks.
Scenarios to compare
- Count the orders already on the way
- Correct stock more slowly
- Faster deliveries
What is in the model
- Factory InventoryGoods in stock at the factory. Negative = orders it could not fill yet (backlog).
- Factory PipelineGoods the factory has ordered that are still on their way.
- Shop InventoryGoods in stock at the shop. Negative = orders it could not fill yet (backlog).
- Shop PipelineGoods the shop has ordered that are still on their way.
- Wholesaler InventoryGoods in stock at the wholesaler. Negative = orders it could not fill yet (backlog).
- Wholesaler PipelineGoods the wholesaler has ordered that are still on their way.
- Factory OrderingThe factory's orders entering its supply line.
- Factory ReceiptsDeliveries arriving at the factory.
- Factory ShipmentsWhat the factory sends on each week: the orders it receives.
- Shop OrderingThe shop's orders entering its supply line.
- Shop ReceiptsDeliveries arriving at the shop.
- Shop ShipmentsWhat the shop sends on each week: the orders it receives.
- Wholesaler OrderingThe wholesaler's orders entering its supply line.
- Wholesaler ReceiptsDeliveries arriving at the wholesaler.
- Wholesaler ShipmentsWhat the wholesaler sends on each week: the orders it receives.
- Adjust WeeksHow quickly each stage tries to bring its stock back to the target. Small = aggressive.
- Customer DemandWhat customers buy each week: 100 items, and from week 5 more by Demand_Rise.
- Delay WeeksHow long it takes, on average, until ordered goods arrive.
- Demand RiseHow much more customers buy each week from week 5 on.
- Factory ExpectedThe factory's forecast of incoming orders: a smoothed average.
- Factory OrdersWhat the factory orders each week: the forecast, plus a correction towards its target stock, plus (if Pipeline_Weight > 0) a correction for goods already on their way.
- Pipeline WeightDoes a stage count the goods it has already ordered but not yet received? 0 = no (common in practice), 1 = fully.
- Shop ExpectedThe shop's forecast of incoming orders: a smoothed average.
- Shop OrdersWhat the shop orders each week: the forecast, plus a correction towards its target stock, plus (if Pipeline_Weight > 0) a correction for goods already on their way.
- Smooth WeeksHow quickly each stage updates its forecast of incoming orders.
- Target StockThe stock each stage wants to keep.
- Wholesaler ExpectedThe wholesaler's forecast of incoming orders: a smoothed average.
- Wholesaler OrdersWhat the wholesaler orders each week: the forecast, plus a correction towards its target stock, plus (if Pipeline_Weight > 0) a correction for goods already on their way.