JBL and Beats carry spare parts for their dealers at their warehouse location. Demand for JBL spare parts is 100 units per month while demand for Beats parts is 120 per month. Each spare part costs $100 and both companies have a holding cost of 20 percent. Currently, each company uses a separate truck to ship these parts. Each truck has a fixed cost of $500. a Now, what is the annual ordering and holding cost for Beats? Show your work on the excel file. Annual ordering for Beast 3578.11 Annual holding for Beats=3578.11 Annual ordering for Beats= 2683.28 Annual holding for Beats=3578.11 Annual ordering for Beats= 3578.11Annual holding for Beats=2683.28 Annual ordering for Beats= 2683.28 Annual holding for Beats=2683.28 Input Annual demand for JBL spare parts, D1 Annual demand for Beats parts, D2 Cost per JBL part, C1 Cost per Beats part, C2 Holding cost, h Fixed cost per shipment, S 1,200 1,440 100 $ $ 100 20% 500 $ JBL and Beats Optimal order size for JBL Cycle inventory of JBL (optional) Annual holding cost for JBL Annualshipping cost for JBL Optimal order size for Beats Cycle inventory for Beats (optional) Annual holding cost for Beats Annual shipping cost for Beats JBL and Beats carry spare parts for their dealers at their warehouse location. Demand for JBL spare parts is 100 units per month while demand for Beats parts is 120 per month. Each spare part costs $100 and both companies have a holding cost of 20 percent. Currently, each company uses a separate truck to ship these parts. Each truck has a fixed cost of $500. a Now, what is the annual ordering and holding cost for Beats? Show your work on the excel file. Annual ordering for Beast 3578.11 Annual holding for Beats=3578.11 Annual ordering for Beats= 2683.28 Annual holding for Beats=3578.11 Annual ordering for Beats= 3578.11Annual holding for Beats=2683.28 Annual ordering for Beats= 2683.28 Annual holding for Beats=2683.28 Input Annual demand for JBL spare parts, D1 Annual demand for Beats parts, D2 Cost per JBL part, C1 Cost per Beats part, C2 Holding cost, h Fixed cost per shipment, S 1,200 1,440 100 $ $ 100 20% 500 $ JBL and Beats Optimal order size for JBL Cycle inventory of JBL (optional) Annual holding cost for JBL Annualshipping cost for JBL Optimal order size for Beats Cycle inventory for Beats (optional) Annual holding cost for Beats Annual shipping cost for Beats