A diaper manufacturer, DiaperCo, is experiencing high variability in the volume of incoming orders from a distributor for a particular SKU. This causes problems for DiaperCo -- aggregate planning becomes difficult, and there is a large risk of overage as well as underage in every planning period.

The manufacturer suspects the high variability is due to the bullwhip effect. The distributor receives incoming orders from a retailer. Initial discussions with the distributor indicate that it is also experiencing high variability in incoming orders, although not as high as the manufacturer. Owing to this, DiaperCo wants to explore how different ordering behaviors from the retailer and the distributor affect variability in the orders it receives. Since stabilizing the order pattern would lead to lower costs, the retailer has agreed to share its 20-period demand forecast with DiaperCo as long as any future cost reductions also lead to lower prices.

A forecast for the demand faced by the retailer is given in thisExcel-file. Both the retailer and the distributor use a 20-period rolling horizon when planning how much to order.

Assume the following sequence of events at both the retailer and the distributor. In the beginning of a period, they review inventory and decide how much to order. Orders are placed and arrive immediately, and can be sold in the same period. DiaperCo learns that, as of now, both the retailer and the distributor use (S,Q)-policies. The (S,Q) policy is also known as the Order-Point, Order-Quantity policy, and is essentially a two-bin system. The policy is "Order Q units when Inventory Position is less than the re-order point S".

This means that:

• - All orders have the same quantity Q (which you need to calculate as explained in the next bullet point).
• - The retailer and the distributor each use the EOQ formula to find the order quantity (Q), using the forecasted demand for the next 20 periods (have this in mind when determining your D for calculations).
• -Remember that what is considered demand for the distributor is not the same than what is considered demand for the retailer!
• -The holding cost for the 20 periods is $1 per unit for the retailer, and $0.5 per unit for the distributor.
• -The ordering cost is $1,000 for the retailer and $2,000 for the distributor.

For both the retailer and the distributor, an order is placed when the inventory on hand in the beginning of a period is below certain level, S. This level is given by the average sales in a period plus a safety stock. For the retailer, the safety stock is 5,000 units. For the distributor the safety stock is 10,000 units.

DiaperCo wants to measure the "size" of bullwhip effect as the ratio between the variance in incoming orders (to DiaperCo) over the variance of the demand.

Using EOQ ordering at both the retailer and the distributor, what is the size of the bullwhip effect at DiaperCo? Answer without commas or decimals.