More-Power Company has projected sales of 75,000 regular sanders and 30,000 minisanders for next year. The projected income statement is as follows:

Required:
1. Set up the given income statement on a spreadsheet (e.g., Excel). Then, substitute the following sales mixes, and calculate operating income. Be sure to print the results for each sales mix (a through d).LO1

Transcribed Image Text:

Sales Less: Variable expenses Contribution margin Less: Direct fixed expenses Product margin Less: Common fixed expenses Operating income Regular Mini- Sander Sander Total $3,000,000 $1,800,000 $4,800,000 1,800,000 900,000 2,700,000 $1,200,000 $ 900,000 $2,100,000 250,000 450,000 700,000 $ 950,000 $ 450,000 $1,400,000 600,000 $ 800,000