Each one on different spreadsheet

Problem 16.32 Using a Computer Spreadsheet to Solve Muitiple-Product Br Varying Sales Mix reak 3 er Company has projected sales of 75,000 regular sanders and 30,000 m for next year. The projected income statement is as follows: Mini-Sander Regular Sander S3,000,000 1,800,000 $1,200,000 $1,800,000 900,000 $ 900,000 450,000 S 450,000 Total 4,800,00 Sales Less: Variable expenses Contribution margin Less: Direct fixed expenses $2,100,000 00,000 $1,400,000 250,000 S 950,000 Product margin Less: Common fixed expenses 800.000 Operating income Required: 1. Set up the given income statement on a spreadsheet (e.g., ExcelTM). Then, substitute the fo lowing sales mixes, and calculate operating income. Be sure to print the results for each sales mix (a through d). Regular Sander Mini-Sander a. 75,000 b. 60,000 c. 30,000 d. 30,000 37,500 60,000 90,000 60,000 Calculate the break-even units for each product for each of the preceding sales mi xes 2