Need the following question answered...

Using this format in Excel...

54. CVP Analysis and Sales Mix (Multiple Products). Math Products, Inc., produces two different products with the following monthly data (this is the base case) Finance Calculator Solar Calculator Total $100 60 21,000 $12 Selling price per unit Variable cost per unit Expected unit sales Sales mix Fixed costs 14,000 35,000 100 percent $750,000 60 percent 40 percent Assume the sales mix remains the same at all levels of sales except for requirement i Required: Round to the nearest unit of product, hundredth of a percent, and nearest cent where appropriate. (An example for unit calculations is 3,231.15 3,231; an example for percentage calculations is o.434532 0.4345 43.45 percent; an example for dollar calculations is $3789787 = $378.98.) a. Calculate the weighted average contribution margin per unit. b. 1. How many units in total must be sold to break even? 2. How many units of each product must be sold to break even? C. 1 How many units in total must be sold to earn a monthly profit of $10o,ooo? 2. How many units of each product must be sold to earn a monthly profit of $10o,ooo? d. Using the base case information, prepare a contribution margin income statement for the month similar to the one in Figure 6.5 e. Calculate the weighted average contribution margin ratio f. Find the break-even point in sales dollars g. What amount of sales dollars is required to earn a monthly profit of $80,000? h. Assume the contribution margin income statement prepared in requirement d is the company's base case. What is the margin of safety in sales dollars:? i. If the sales mix shifts more toward the Finance Calculator product than the Solar Calculator product, would the break even point in units increase or decrease? Explain. (Detail calculations are not necessary, but may be helpful in confirming your answer.)