Objective 3- Apply cost-volume-profit analysis in a multiple-product setting. More-Power Company has projected sales of 75,000 regular sanders and 30,000 mini-sanders for next year. The projected income statement is as follows: Regular Sander Mini-Sander Total S1,500,000 900,000 $ 900,000 Sales Less Variable espenses Contribution margin Less Direct fised expenses Product margin Less: Common fised expenses Operating income $3,000,000 1,500,000 31,200,000 250,000 $ 950,000 S4.800,00 2.700,00 $2,100,00 700,00 S1.400,00 450,000 450,000 600,00 S S00,00 comitaticinblulevolndex.hemitelsaN97813osaror24idr18745624rbidis24anapshotidis2464dockAppluidet. 212 Print Preview 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).

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter3: Cost-volume-profit Analysis
Section: Chapter Questions
Problem 4PB: West Island distributes a single product. The companys sales and expenses for the month of June are...
icon
Related questions
icon
Concept explainers
Question
Objective 3 - Apply cost-volume-profit analysis in a multiple-product setting.
More-Power Company has projected sales of 75,000 regular sanders and
30,000 mini-sanders for next year. The projected income statement is as
follows:
Regular Sander
Mini-Sander
Total
$3,000,000
1,800,000
$1,200,000
250,000
$ 950,000
Sales
S1,800,000
$4,800,00
Less: Variable expenses
Contribution margin
Less: Direct fixed expenses
Product margin
Less: Common fixed expenses
900,000
2.700,00
S 900,000
450,000
$ 450,000
$2,100,00
700,00
S1,400,00
600,00
Operating income
S 800,00
com/staticinb/ulevolindexhtml?elSBN=97813059707248id=187456248&nbid=5246498snapshotid=524649&dockAppuld=1. 2/12
Print Preview
Required:
1. Set up the given income statement on a spreadsheet (e.g., ExcelM). Then,
substitute the following sales mixes, and calculate operating income. Be sure
to print the results for each sales mix (a through d).
Regular Sander
Mini-Sander
75,000
37,500
a.
b.
60,000
60,000
C.
30,000
90,000
d.
30,000
60,000
2. Calculate the break-even units for each product for each of the preceding
sales mixes.
Transcribed Image Text:Objective 3 - Apply cost-volume-profit analysis in a multiple-product setting. More-Power Company has projected sales of 75,000 regular sanders and 30,000 mini-sanders for next year. The projected income statement is as follows: Regular Sander Mini-Sander Total $3,000,000 1,800,000 $1,200,000 250,000 $ 950,000 Sales S1,800,000 $4,800,00 Less: Variable expenses Contribution margin Less: Direct fixed expenses Product margin Less: Common fixed expenses 900,000 2.700,00 S 900,000 450,000 $ 450,000 $2,100,00 700,00 S1,400,00 600,00 Operating income S 800,00 com/staticinb/ulevolindexhtml?elSBN=97813059707248id=187456248&nbid=5246498snapshotid=524649&dockAppuld=1. 2/12 Print Preview Required: 1. Set up the given income statement on a spreadsheet (e.g., ExcelM). Then, substitute the following sales mixes, and calculate operating income. Be sure to print the results for each sales mix (a through d). Regular Sander Mini-Sander 75,000 37,500 a. b. 60,000 60,000 C. 30,000 90,000 d. 30,000 60,000 2. Calculate the break-even units for each product for each of the preceding sales mixes.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Cost volume profit (CVP) analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage