Over the past 10 weeks, demand for gears at Michael’s Metals has been 140, 230, 100, 175, 165, 220, 200, and 178. Michael has placed weekly orders of 140, 250, 90, 190, 140, 240, 190, and 168 units.

The sample variance of a data set can be found by using the VAR.S function in Excel or by plugging each value (x) of the data set into the formula:

where x is the mean of the data set and n is the number of values in the set. Using Equation (S11-2), calculate the bullwhip measure for Michael’s Metals over the 10-week period.

Transcribed Image Text:

Variance= 2(x-x) (n - 1)