Bullwhip Effect Calculator
The bullwhip effect is the growth of order variability as you move upstream from the customer. A stable end demand can turn into wild swings at the raw material supplier. This calculator uses the well known Lee, Padmanabhan and Whang lower bound to show how lead time and forecast smoothing drive it.
Your numbers
Order to receipt, in forecast periods.
Each stage is assumed to use the same policy, so the effect compounds.
Your results
Based on the order-up-to policy with moving average forecasting and no price fluctuation or batching. Real chains add batching, promotions and rationing, so treat the value as a lower bound.
Variance amplification vs lead time (one stage)
Sweeps Replenishment lead time from 0 to 20, holding your other inputs fixed.
Measure your real bullwhip
Optional: we can compare order and demand variance from your ERP history and report the ratio per product family.
Optional. The tool and every export work without this. No spam.
How to use it
Enter the standard deviation of end customer demand per period, the replenishment lead time in the same periods, and the number of periods in the moving average that your replenishment forecast uses. Set the number of stages that follow the same logic, for example retailer, distributor and plant. The tool shows the variance ratio at one stage and compounded over the chain.
- Use consistent period lengths
- Lead time includes review period
- Try a longer moving average to see the damping
- Chart shows the cost of long lead times
The formula
For an order-up-to policy with a p-period moving average and lead time L, the variance of orders divided by the variance of demand is at least one plus 2L over p plus 2L squared over p squared. The ratio rises with lead time and falls when p grows. Compounding across stages multiplies the ratios, which is why a few stages can produce a many-fold amplification.
Reading the result
With L of 4 and p of 6 the single stage ratio is 2.78, so order standard deviation is about 1.7 times demand. Over three stages the variance ratio is about 21 and standard deviation is 4.6 times. Doubling p to 12 brings the single stage ratio to 1.89. Shorter lead times, shared point of sale data and smaller order batches all pull the number down.
Practical countermeasures
Share end demand with suppliers instead of passing on your orders, shorten lead times, stabilise pricing so forward buying disappears, cut order batch sizes, and avoid rationing games during shortages. Inside one company, a stable production plan with a frozen horizon also damps the whip between sales, planning and the shop floor. Do not smooth so heavily that you cannot react to a real change in demand.
Frequently Asked Questions
What is the bullwhip effect?
It is the increase in demand variability moving up a supply chain from retailer to manufacturer to supplier, caused by forecast updating, order batching, price fluctuation and shortage gaming.
How do you measure the bullwhip ratio in practice?
Divide the variance of orders placed by the variance of demand received over the same periods, per item or family. A ratio above 1 means amplification.
Why does a longer lead time increase it?
Longer lead times require covering more periods of demand with the order-up-to level, so a small change in the forecast produces a larger change in the order. The formula grows with L and L squared.
Is the calculated value exact?
No. It is a lower bound under simple assumptions. Batching, promotions and rationing push real ratios higher.
Netray can compare actual order variance against demand variance across your ERP's customers, plants and suppliers and show where the whip is largest.
Related Tools
MAD to Safety Stock Forecast Error Calculator
Use your measured mean absolute deviation of forecast error to set safety stock and reorder point instead of a guessed buffer.
Supply Chain & InventoryDemand Variability CV and XYZ Classification Calculator
Turn mean demand, standard deviation and average demand interval into a CV, an XYZ class and a Syntetos-Boylan demand pattern so you can pick the right forecast method.
Supply Chain & InventoryStatistical vs Sales Forecast Blend Calculator
Weight the statistical forecast and the sales or customer forecast by how accurate each has been, and see the consensus number and the gap between sources.
Supply Chain & InventoryPromotion Lift and Cannibalization Calculator
Convert baseline demand, promo lift, cannibalization and pull-forward into net incremental units and promotion profit, so the demand plan carries the real effect.
More Supply Chain & Inventory tools
See all- Oracle Fusion Inventory Turns and Carrying Cost Calculator
- Distribution ERP Fill Rate Calculator
- Distributor Rebate Tracking Worksheet
- Branch Transfer Planning Worksheet
- Distributor Slow-Moving Inventory Review Worksheet
- Distributor Vendor Performance Scorecard Worksheet
- Distributor GMROI Calculator
- Distributor Backorder Cost and Fill Rate Calculator
- EOQ with Vendor Minimum Order Calculator