please do question 4

4-1 and 4-2 answer typed please

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 . Facilities RE Medium room Indonesia Philippines Operation Weekly demands (independent) (Dando) - Medium roast coffee P3100 bags per week with standard deviation of bags per week Dark roast coffee 2) 125 bags per week with standard deviation of 10 bags per week Inventory holding (H) Raw coffee beans for medium roast coffee Paper bager os of product cost/price Raw coffee beans for dark roast coffee (P2) So per bat per year(10 of product.com/price) Monkoffee uses continuous review policy Lists to replenish coffee beans from supplies in Indonesia or Philippe scalated using economic order quantity OQI Cycle service level (CSL) Raw coffee beans for medium ront coffee (P11099 Raw coffee beans for dark roast coffee (2) 1099 Replenishment lead time and ) For medium roast coffee (1) A weeks from Indonesia For dark roast coffee (P2) weeks from Philippines Fixed order cost (S) Row coffee beans for medium roast coffee (1): 5200 per order Row coffee beans for dark roast coffee (2) 5200 per ordet 3 4/25/2022 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 (0) . From supplier to roasting facility - (1-2) Safety inventory (55) Safety inventory of raw coffee beans at roasting facility -(1-3) Annual ordering cost - (1-4) Annual holding cost 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 Mat Dart Indonesia Pippines 5 4/25/2022 Operation Weekly demands (independent) (D anda) - 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 sire () 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 (Land) 4 weeks for jointly delivering from Indonesia and Philippines Fixed order cost (5) $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 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 4/25/2022 Facilities Memo Dar Indonesia Operation Weekly demands (independent) (D and d.) - 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) $40 per bag per year (10% of product cost/price) Monkoffee uses continuous review policy - Lot size (0) to replenish coffee beans from Indonesia is calculated using economic order quantity EOQ) Cycle service level (CSL) -0.99 Inventory-replenishment lead time (t and s.) 4 weeks Fixed order cost (S) $200 per order 8 4/25/2022 Question 3 Calculate following for raw coffee beans from Indonesia (at R1) for the single-source operation -(3-1) Lot size (0) 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 4 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)? 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 . Facilities RE Medium room Indonesia Philippines Operation Weekly demands (independent) (Dando) - Medium roast coffee P3100 bags per week with standard deviation of bags per week Dark roast coffee 2) 125 bags per week with standard deviation of 10 bags per week Inventory holding (H) Raw coffee beans for medium roast coffee Paper bager os of product cost/price Raw coffee beans for dark roast coffee (P2) So per bat per year(10 of product.com/price) Monkoffee uses continuous review policy Lists to replenish coffee beans from supplies in Indonesia or Philippe scalated using economic order quantity OQI Cycle service level (CSL) Raw coffee beans for medium ront coffee (P11099 Raw coffee beans for dark roast coffee (2) 1099 Replenishment lead time and ) For medium roast coffee (1) A weeks from Indonesia For dark roast coffee (P2) weeks from Philippines Fixed order cost (S) Row coffee beans for medium roast coffee (1): 5200 per order Row coffee beans for dark roast coffee (2) 5200 per ordet 3 4/25/2022 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 (0) . From supplier to roasting facility - (1-2) Safety inventory (55) Safety inventory of raw coffee beans at roasting facility -(1-3) Annual ordering cost - (1-4) Annual holding cost 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 Mat Dart Indonesia Pippines 5 4/25/2022 Operation Weekly demands (independent) (D anda) - 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 sire () 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 (Land) 4 weeks for jointly delivering from Indonesia and Philippines Fixed order cost (5) $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 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 4/25/2022 Facilities Memo Dar Indonesia Operation Weekly demands (independent) (D and d.) - 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) $40 per bag per year (10% of product cost/price) Monkoffee uses continuous review policy - Lot size (0) to replenish coffee beans from Indonesia is calculated using economic order quantity EOQ) Cycle service level (CSL) -0.99 Inventory-replenishment lead time (t and s.) 4 weeks Fixed order cost (S) $200 per order 8 4/25/2022 Question 3 Calculate following for raw coffee beans from Indonesia (at R1) for the single-source operation -(3-1) Lot size (0) 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 4 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)