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. What is the optimal order size for JBL? For Beats? show your work on the excel sheet. JBL=245, Beats=123 JBL=500, Beats= 245 JBL= 764, Beats=327 JBL= 1024, Beats= 416 1,200 1,440 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 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. What is the optimal order size for JBL? For Beats? show your work on the excel sheet. JBL=245, Beats=123 JBL=500, Beats= 245 JBL= 764, Beats=327 JBL= 1024, Beats= 416 1,200 1,440 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 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