I am having issue with this problem. Any help will be highly appreciated... Thanks

Activities LibreOffice Calc Jun 4 20:10:06 20.5 C 825 Summer 2019 Module 5 Excel Workbook Assiqnment.xisx- Libre Office Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help abs AL : A E BIUA : T% 74 00 00 Calibri 11 fx 2 835 Ifthe company adds anather shift, how many units of the Right Car and Left Carshould it produce to achicve the maximum CM? GI H M O Solution 6 A 7Giol Company can produce two toy products, a Right Giol Car and a Left Giol Car, with the same machine. Only ONE ca can be manufactured at a time using this machine. The Company currently makes both cars, but company thinks that this is not giving them maximum benefits. Company wants to add another shift and wants your plan. 1 Company gave this info: 1 Contribution Margin by Machine Hour for each Oven: for 11 12 FirstPoint Info: Right Giol Left Giol 13 2 units of each Oven thatc hi uld produce to maximize Contribution Margin, Selling price per unit 135.00 80,00 14 37.00 21.00 only one production s per Contribution margin per unit Machine hours to produce ONE unit uni 15 assu $ $ 98.00 59.00 16 1 hour 2/3 hour 17 Maximum customer demand for each car per month i.e. maximum they can sell 540 310 3 Total Contribution Margin resulting from solution to Item 2: 22 The machine for the firm operates for a single eight-hour shift for 26 working days each month. Operating the machine for two shifts, will increase its productivity by 2 another eight hours per day for 26 days per month. This change would require 13,500 additional fixed costs per month. 24 26 27 4 Units of each Oven that company should produce to maximize Contribution Margin, assuming TWO production shifts: 28 1 Determine the contribution margin per machine hour that each product generates. 29 30 2 How many units of the Right and Left Cars should the company produce to achieve the maximum CM if it continues to operate with only one shift? Need to assume that all the cars have sold. 31 32 Problem C Problem U Froblem A Problem i See 3 of 4 | PaqeStyle Probam C. Englsh (U56 T- LasoN AraqeSum: 0 Activities LibreOffice Calc Jun 4 20:10:20 20.5 C 825 Summer 2019 Module 5 Excel Workbook Assignment.xlsx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help abs AL : A % 74 00 00 - A 2 Calibri BIU 11 H26 A H 26 A 4 Units of ea tion chieshould produce to maximize Contribution Margin, assuming TWO prod 27 28 1 Determine the contribution margin per machine hour that each product generates. 29 30 How many units of the Right and Left Cars should the company produce to achieve fw the maximum CM if it continues to operate with only one shift? Need to assume that all the cars have 31 32 33 3 5 Total Contribution Margin resulting from solution to Item 4: How much total contribution margin does this sales mix produce each month? 35 4 34 should pany adds another shift, how many units of the Right Car and Left Car produce to achieve e maximum C 36 37 5 How much total contribution margin would this mix produce each month? 38 39 6 Should the company add the new shift? Why or why not? 40 7 6 Should the company add the second shift? why or why not? 41 The firm determines that can increase the Right Car's maximum sales to 390 units per month by spenaling 0,0 the double chiKeting efforts. Should the company pursue this strategy ar 47 43 AA 45 46 Check Figures: Item 4: Right Cars 310 Units; there is No check figure given for the Left... Item 7: Left Cars Contribution Margin $2,301 rtising campaign and the second shift? Why or why not? show all relevant calculations. 4/ 48 45 50 51 52 Problem C. Problem U Froblem A Problem IPraeStale Proben C Englsh (USA) T- Se3of 4 Ausrage: Sum. 0