NAME: Problem #2 INPUT: Product A Product B Variable cost of Variable selling & administrative expenses per unit Total Fixed cost of goods sold Total Fixed Selling & administrative expenses 83.00 $ 53.00 S 3.00 $ 46.00 20.00 1.00 NOTE:. Each of the highlighted cells should contain an Excel formula Formulas should use cell references to refer back to input data. ds sold per unit 100,000.00 90,000.00 For percentages, go out 2 places after the decimal & round to one place. For units, round to whole units. For money, round to nearest cent. Adjust spacing as needed. Be sure to check that your unit of measure is correct (e.g. units, dollars, etc.) PURPOSE To determine which product would yield the highest profit Product A Product B OUTPUT Contribution margin per unit Contribution margin percentage Break even point in units Break even point in sales dollars Number of units to be sold to earn profit of $50,000 The profit if the company sold 20,000 units REQUIRED: 1.Create the Excel formulas required for each output listed above. Ue cell references back to Input data. 2. If the company had the money to produce only one of the products. What would be your recommendation? Explain