Bookmark this page 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 this Excel-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). - 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. 20 D Note. The formula of the Economic Order Quantity (EOQ) is EOQ = and Ce the excess holding cost. Where ce is the ordering cost, D the demand, ce For more information about the EOQ check the SC1x section of the Key Concepts Document. Submit You have used 0 of 2 attempts Save Part 2 0.0/5.0 points (graded) DiaperCo wants to explore the effect of using a lot-for-lot ordering policy instead, for both the retailer and the distributor. The lot-for-lot policy means that you order or produce exactly what is demanded in the specific period. With lot-for-lot ordering at both the retailer and the distributor, what is the size of the bullwhip effect at DiaperCo? Answer without commas or decimals, and make sure you read the tiny hint below before proceeding! Hint: Please take another look to the Bulwheep effect concept and the lot-for-lot ordering policy. If you need further details on both, check the Key Concept Document. I promise you can solve this question even without calculations if you got both concepts correctly! If you still got the time, make your numbers. You should get the same answer you thought of. Good luck! Retailer Time period Demand orders Retailer Distributor Inventory orders 12000 Distributor Inventory 25000 1 N 3 3 4 5 6 00 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 10580 11501 9778 12804 12033 10102 10995 9880 9750 10200 12956 9909 10002 12034 11444 7899 10223 10433 10563 9797 Bookmark this page 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 this Excel-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). - 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. 20 D Note. The formula of the Economic Order Quantity (EOQ) is EOQ = and Ce the excess holding cost. Where ce is the ordering cost, D the demand, ce For more information about the EOQ check the SC1x section of the Key Concepts Document. Submit You have used 0 of 2 attempts Save Part 2 0.0/5.0 points (graded) DiaperCo wants to explore the effect of using a lot-for-lot ordering policy instead, for both the retailer and the distributor. The lot-for-lot policy means that you order or produce exactly what is demanded in the specific period. With lot-for-lot ordering at both the retailer and the distributor, what is the size of the bullwhip effect at DiaperCo? Answer without commas or decimals, and make sure you read the tiny hint below before proceeding! Hint: Please take another look to the Bulwheep effect concept and the lot-for-lot ordering policy. If you need further details on both, check the Key Concept Document. I promise you can solve this question even without calculations if you got both concepts correctly! If you still got the time, make your numbers. You should get the same answer you thought of. Good luck! Retailer Time period Demand orders Retailer Distributor Inventory orders 12000 Distributor Inventory 25000 1 N 3 3 4 5 6 00 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 10580 11501 9778 12804 12033 10102 10995 9880 9750 10200 12956 9909 10002 12034 11444 7899 10223 10433 10563 9797