Question 4 (4-1) Calculate a total of annual ordering cost and annual holding cost for the above three cases -Current (Question 1) Two suppliers delivering independently -Joint ordering (Question 2) Two suppliers delivering jointly - Single source (Question 3) Single supplier (4-2) Based on the above calculations, what should Monkoffee do (current, joint ordering, or single source)? 4 Operation Weekly demands (independent) (D and .) Medium roast coffee (P1): 100 bags per week with standard deviation of 40 bags per week Dark roast coffee (P2) 25 bags per week with standard deviation of 10 bags per week Inventory holding (H) Raw coffee beans for medium roast coffee (P1): $40 per bag per year (10% of product cost/price) Raw coffee beans for dark roast coffee (P2) - $40 per bag per year(10% of product cost/price) Monkoffee uses continuous review policy Lot size (0) to replenish coffee beans from suppliers in Indonesia or Philippines is calculated using economic order quantity (EOO) Cycle service level (CSL) Raw coffee beans for medium roast coffee (P1): 0.99 Raw coffee beans for dark roast coffee (P2) Replenishment lead time (L and s) 0.99 For medium roast coffee (P1): 4 weeks from Indonesia For dark roast coffee (P2) : 4 weeks from Philippines Fixed order cost (S) Raw coffee beans for medium roast coffee (P1): $200 per order Raw coffee beans for dark roast coffee (P2) : $200 per order Question 1 Calculate followings for raw coffee beans from Indonesia (for P1) and from Philippines (for P2) for the current operation -(1-1) Lot size (Q) From supplier to roasting facility -(1-2) Safety inventory (ss) Safety inventory of raw coffee beans at roasting facility -(1-3) Annual ordering cost -(1-4) Annual holding cost 3 4/25/2022 FERT Monkoffee Monkoffee is a startup company that imports organic Kopi Luwak coffee beans from Indonesia and Philippines, exquisitely roasts the beans, and sells whole coffee beans online all year long (52 weeks a year) Monkoffee operates roast-to-order business model Roasts coffee beans after an order is received Ships roasted coffee beans directly from its roasting facility within 24 hours after an order is received Monkoffee currently sells two products in one-pound bags Medium roast coffees (P1) - made from coffee beans imported from Indonesia Dark roast coffees (P2) - made from coffee beans imported from Philippines Raw coffee beans are delivered to the roasting facility in Illinois in one-pound bags from suppliers in Indonesia and Philippines Inventories of raw coffee beans are kept as one-pound bags A bag of raw coffee beans costs $400 per bag [Source] http://kurniaone in-fakta-unik dan menarik-mengenal kotora.xhin Source http://thecoffeelocator.com/market/ground coffee/the-world-s-moil-cav.com.cCS KA luwak-blinded ground pourmet coffeehtml Facilities Roasting facility Medium roast (P1) Dark roast (P2) Indonesia Philippines (Source) https:/www.samwomen-uune.orgmaman 2 Operation Weekly demands (independent) (D and ) Medium roast coffee (P1): 100 bags per week with standard deviation of 40 bags per week Dark roast coffee (P2) bags per week Inventory holding (H) : 25 bags per week with standard deviation of 10 $40 per bag per year (10% of product cost/price) Monkoffee uses continuous review policy Lot size (Q) to replenish coffee beans from Indonesia is calculated using economic order quantity (EOQ) Cycle service level (CSL) 0.99 Inventory-replenishment lead time (L and s) 4 weeks Fixed order cost (S) $200 per order Question 3 Calculate following for raw coffee beans from Indonesia (at R1) for the single-source operation -(3-1) Lot size (Q) From supplier to roasting facility -(3-2) Safety inventory (ss) Safety inventory of raw coffee beans at roasting facility -(3-3) Annual ordering cost -(3-4) Annual holding cost 8 4/25/2022 Single Source Monkoffee is further considering to source coffee beans only from Indonesia for both medium and dark roast coffees - Use same coffee beans from Indonesia but separately roast for medium roast and dark roast Fixed order cost is $200 Inventory replenishment lead time is 4 weeks from Indonesia Facilities Roasting facility Medium roast (P1) Dark roast (P2) Indonesia 4/25/2022 Operation Weekly demands (independent) (D and .) Medium roast coffee (P1): 100 bags per week with standard deviation of 40 bags per week Dark roast coffee (P2) week Inventory holding (H) : 25 bags per week with standard deviation of 10 bags per Raw coffee beans for medium roast coffee (P1): $40 per bag per year (10% of product cost/price) Raw coffee beans for dark roast coffee (P2) : $40 per bag per year (10% of product cost/price) Monkoffee uses continuous review policy Lot size (Q) to replenish coffee beans from suppliers in Indonesia or Philippines is calculated for joint ordering Cycle service level (CSL) Raw coffee beans for medium roast coffee (P1): 0.99 Raw coffee beans for dark roast coffee (P2) : 0.99 Replenishment lead time (L and s) 4 weeks for jointly delivering from Indonesia and Philippines Fixed order cost (S) $300 per joint order Question 2 Calculate following for the current operation at the new aggregate warehouse -(2-1) Lot size (Q) From supplier to roasting facility For each coffee bean -(2-2) Safety inventory (ss) Safety inventory of raw coffee beans at roasting facility . For each coffee bean -(2-3) Annual ordering cost Jointly for both coffee beans -(2-4) Annual holding cost . For each coffee bean Joint Ordering Monkoffee is now considering to order coffee beans jointly from Indonesia and Philippines, delivered together to roasting facility Fixed order cost is now $300 for jointly ordering coffees Inventory replenishment lead time is 4 weeks for jointly delivering from Indonesia and Philippines Facilities Roasting facility Medium roast (P1) Dark roast (P2) Indonesia Philippines 13 5 4/25/2022