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 JBL company? based on your answers from the previous question. Show your work on the excel file. Annual ordering for JBL= 1867.32 Annual holding for JBL=1867.32 Annual ordering for JBL= 2,4449.49 Annual holding for JBL=2,4449.49 Annual ordering for JBL= 2,4449.49 Annual holding for JBL=1867.32 Annual ordering for JBL= 1867.32 Annual holding for JBL=1867.32 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 JBL company? based on your answers from the previous question. Show your work on the excel file. Annual ordering for JBL= 1867.32 Annual holding for JBL=1867.32 Annual ordering for JBL= 2,4449.49 Annual holding for JBL=2,4449.49 Annual ordering for JBL= 2,4449.49 Annual holding for JBL=1867.32 Annual ordering for JBL= 1867.32 Annual holding for JBL=1867.32 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