Please use Excel to keep answers easy to follow, I filled in some of them from a previous Chegg answer BUT much of it was out of order and possibly incorrect! Please double-check them. Thank you

1. Determine the contribution margin per machine hour that each product generates. Product G Product B Contribution margin per unit $ 45.00 $ 36.00 Machine hours per unit 112.5 36.0 Contribution margin per machine hour $ 0.40 $ 1.00 Product G Product B Maximum number of units to be sold 600 200 Hours required to produce maximum units 240 200 $ Total 440 2. How many units of Product G and Product B should the company produce if it continues to operate with only one shift? How much total contribution margin does this mix produce each month? Product G Product B Total Hours dedicated to the production of each product 176 176 Units produced for most profitable sales mix 440 Contribution margin per unit $ 45.00 Total contribution margin-one shift $ 19,800 $ 19,800 3. If the company adds another shift, how many units of Product G and Product B should it produce? How much total incremental income would this mix produce each month? Should the company add the new shift? Product G Product B Total Hours dedicated to the production of each product 240 112 352 Units produced for most profitable sales mix 600 1121 Contribution margin per unit $ 45.00 $ 36.00 Total contribution margin-two shifts $ 27,000 $ 4,032 $ 31,023 Total contribution margin-one shift 19,800 Change in contribution margin 11,232 Change in fixed costs 4,500 Change in operating income(loss) $ 6,732 Total incremental income Should the company add another shift? Yes $ 4. Suppose the company determines that it can increase Product G's maximum sales to 700 units per month by spending $3,500 per month in marketing efforts. Should the company pursue this strategy and the double shift? Compute total incremental income. Product G Product B Total Second shift without marketing campaign: Units produced for most profitable sales mix 400 720 Contribution margin per unit $ 45.00 $ 36.00 Contribution margin 18,000 $ 2,592 $ 34,092 Additional fixed costs $ 4,500 Incremental income $ (4,940) $ Second shift with marketing campaign: Units produced for most profitable sales mix Contribution margin per unit Contribution margin $ 0 $ 0