Demand Planning

11
Nov
Do You Even Need a Demand Forecast?

Do You Even Need a Demand Forecast?

In the Beer Game, a team that just passes orders upstream beats a typical team by two thirds. So why forecast at all? I tested five ordering policies to find out where a forecast earns its keep, and where it gets in the way.
6 min read
03
Nov
The Beer Game: Why Steady Demand Still Wrecks Your Supply Chain

The Beer Game: Why Steady Demand Still Wrecks Your Supply Chain

Consumer demand changes once, from 4 cases to 8. By the time the signal reaches the factory, orders hit 37. The Beer Game shows why, and you can now play it yourself in the browser.
5 min read
16
Oct
How to Build a Seasonal Forecast in Excel, Step by Step

How to Build a Seasonal Forecast in Excel, Step by Step

A moving average will always be late to a seasonal peak. A seasonal index fixes that with one extra column and an AVERAGEIFS. Here is the method, tested on two years of data.
5 min read