The bullwhip effect is the tendency for orders to vary more than the end-customer demand behind them as you move up a supply chain. It leads to excess inventory, capacity swings and poor service.
Paste a series of demand and the orders placed over the same periods. The calculator compares their variability.
Bullwhip Effect Calculator
Enter your numbers to see the result.
Estimates for planning only. Results depend on the accuracy of the inputs and the assumptions of the standard formula.
The measure
Bullwhip ratio = variance of orders / variance of demand
Use sample variance for both series, over the same number of periods. A ratio above 1 means orders are more variable than demand, so the supply chain amplifies swings. The square root of the ratio gives the same comparison in standard deviations. The coefficient of variation, standard deviation divided by mean, shows variability relative to the level.
Measure at one stage at a time, such as store to distributor, and use enough periods, at least 8 to 12, for a stable result.
Worked example
Demand: 100, 105, 95, 110, 90, 100, 108, 92. Orders: 90, 120, 80, 130, 70, 115, 95, 100. Both average 100.
- Sum of squared deviations for demand = 378, so sample variance = 378 / 7 = 54
- Sum of squared deviations for orders = 2,950, so sample variance = 2,950 / 7 = 421.4
- Bullwhip ratio = 2,950 / 378 = 7.8, or 2.8 times in standard deviations
Orders swing far more than demand in this series.
Causes and fixes
Common causes are demand forecasting that reacts to every change, order batching, price promotions and shortage gaming. Sharing real demand data upstream, ordering more often in smaller lots, stabilising prices and using forecasts based on end demand reduce amplification.
Do not read one number in isolation. Seasonality or planned promotions can raise order variance for good reasons. Remove known patterns or compare similar periods before drawing conclusions. See the guide on the bullwhip effect and AI and our demand planning guides.
Common questions
What is a normal bullwhip ratio?
A ratio near 1 means orders follow demand. Values well above 1 indicate amplification. What is acceptable depends on batch sizes, lead times and promotions, so compare with your own history and with the same stage over earlier periods rather than with a fixed target.
Why use variance instead of the range?
Variance and standard deviation use every period, while the range depends on only the highest and lowest values and is easily distorted by one extreme period. Variance is also the standard basis for the bullwhip ratio, which keeps results comparable between studies.
How many periods are needed?
At least 8 to 12 give a more stable estimate, and more is better when demand is seasonal. The calculator runs with 3 periods, but with so few points one unusual week can swing the ratio widely, so treat that result as a rough signal only.
Should orders placed or shipments received be used?
Use orders placed by the stage on its supplier. Shipments received reflect the supplier's lead time and allocation decisions and can hide how erratically the stage orders. Keep demand and orders in the same unit and the same time buckets.
Does a high ratio always mean something is wrong?
No. Planned promotions, seasonal build-ups and deliberate batching can raise order variance for sound reasons. Check whether the swings come from known events before acting. A high ratio in an ordinary period, with no explanation, deserves a closer look.