Objective 3 - Apply cost-volume-profit analysis in a multiple-product setting.More-Power Company has projected sales of 75,000 regular sanders and30,000 mini-sanders for next year. The projected income statement is asfollows:Regular SanderMini-SanderTotal$3,000,0001,800,000$1,200,000250,000$ 950,000SalesS1,800,000$4,800,00Less: Variable expensesContribution marginLess: Direct fixed expensesProduct marginLess: Common fixed expenses900,0002.700,00S 900,000450,000$ 450,000$2,100,00700,00S1,400,00600,00Operating incomeS 800,00com/staticinb/ulevolindexhtml?elSBN=97813059707248id=187456248&nbid=5246498snapshotid=524649&dockAppuld=1. 2/12Print PreviewRequired:1. Set up the given income statement on a spreadsheet (e.g., ExcelM). Then,substitute the following sales mixes, and calculate operating income. Be sureto print the results for each sales mix (a through d).Regular SanderMini-Sander75,00037,500a.b.60,00060,000C.30,00090,000d.30,00060,0002. Calculate the break-even units for each product for each of the precedingsales mixes.

Break Even Point is the situation for a manufacturing firm when the total revenues of a firm are…

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).

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).

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter6: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 3PA

See similar textbooks

Related questions

Q: cion's contribution format income statement for last P 2,000,000 ble Costs 1400.000 ribution Margin…

A: Contribution margin ratio is the ratio of the contribution margin to sales revenue Breakeven point…

Q: Assume the following cost behavior data for Graphic Arts Company: Sales price $18.00 per unit…

A: Formula: Contribution margin ratio = [ ( Sales price - variable cost ) / sales price ] x 100

Q: Net Income Planning Midvale Corporation sells a single product for $100 per unit, of which $40 is…

A: Solution:Break even Point is the point where company is at zero profit i.e., No loss-No profit…

Q: I. What is the break- even point in dollar sales? J. How many units must be sold to achieve a…

A: “Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Concept explainers

Cost-Volume-Profit Analysis

Cost Volume Profit (CVP) analysis is a cost accounting method that analyses the effect of fluctuating cost and volume on the operating profit. Also known as break-even analysis, CVP determines the break-even point for varying volumes of sales and cost structures. This information helps the managers make economic decisions on a short-term basis. CVP analysis is based on many assumptions. Sales price, variable costs, and fixed costs per unit are assumed to be constant. The analysis also assumes that all units produced are sold and costs get impacted due to changes in activities. All costs incurred by the company like administrative, manufacturing, and selling costs are identified as either fixed or variable.

Marginal Costing

Marginal cost is defined as the change in the total cost which takes place when one additional unit of a product is manufactured. The marginal cost is influenced only by the variations which generally occur in the variable costs because the fixed costs remain the same irrespective of the output produced. The concept of marginal cost is used for product pricing when the customers want the lowest possible price for a certain number of orders. There is no accounting entry for marginal cost and it is only used by the management for taking effective decisions.

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.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2 Part 1

VIEW

Step 3 Part 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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

Olivian Company wants to earn 420,000 in net (after-tax) income next year. Its product is priced at 275 per unit. Product costs include: Variable selling expense is 14 per unit; fixed selling and administrative expense totals 290,000. Olivian has a tax rate of 40 percent. Required: 1. Calculate the before-tax profit needed to achieve an after-tax target of 420,000. 2. Calculate the number of units that will yield operating income calculated in Requirement 1 above. (Round to the nearest unit.) 3. Prepare an income statement for Olivian Company for the coming year based on the number of units computed in Requirement 2. 4. What if Olivian had a 35 percent tax rate? Would the units sold to reach a 420,000 target net income be higher or lower than the units calculated in Requirement 3? Calculate the number of units needed at the new tax rate. (Round dollar amounts to the nearest dollar and unit amounts to the nearest unit.)
Cost-Volume-Profit Chart For the coming year, Loudermilk Inc. anticipates fixed costs of $600,000, a unit variable cost of $75, and a unit selling price of $125. The maximum sales within the relevant range are $2,500,000. a. Construct a cost-volume-profit chart on a sheet of paper. Indicate whether each of the following levels of sales (units or dollars) is in the operating profit area, operating loss area, or at the break-even point. 4,800 units 12,000 units $1,500,000 20,000 units $2,500,000 b. Estimate the break-even sales (dollars) by using the cost-volume-profit chart constructed in part (a). c. The graphic format permits the user to visually determine the and the * for any given level of
Please help me figure a-e
CVP Analysis, *What IT?" AnalysisKevin Co. projected contribution-format income statement for the upcoming month is shownBelow Sales (500 units) $10000Variable expenses. 4000Contributions margin. 6000Fixed expenses. 1000Net operating income. 5000Required:a.) Compute the breakeven point in units.b) Compute the breakeven paint in dollars.c.) If the company wishes to earn a monthly target profit of $10,000, how many units must be sold each month?d.) Compute the company's margin of safety. State your answer in both dollar and percentage terms,e.) The company's manager thinks that adding a salaried sales staff member at a cost of 52,000 per month will increase sales by $4,000 per month. If he is correct, what will be the net dollar advantage or disadvantage of making this change?t.) Refer to the original data, the company's manager believes that a new production process will improve profitability. He plans to add new machinery that will cut variable expenses…
CVP Analysis using a chart: The cost-volume-profit chart for Byron Manufacturing is shown in the screenshot. Use the graph to complete the sentences given below. Byron Manufacturing reaches its break-even level of activity when it sells _____________ (200, 400, 500, 600) units and generates __________ ($5,000, $10,000, $12,000, $15,000) in revenue, because at this level of activity the firm's revenue ____________ (is greater than, is less than, equals) its total cost. In addition, you can determine from the chart that Byron Manufacturing's fixed costs are ________ (5,000, $6,000, $10,000, $12,000) and its price per unit is __________ ($.04, $10.00, $24.00, $30.00) and variable cost per unit is __________ ($.04, $10.00, $12.00, $24.00) A. If fixed costs increase, what will happen to the break-even point? ______ a. The break-even point will increase. b. The break-even point will decrease. B. If the price per unit decreases, what will happen to the break-even point? ________ a. The…
18. Assume the company's monthly target profit is $17,000. The dollar sales to attain that target profit is closest to:A. $387,392B. $635,069C. $671,925D. $993,313
Matamad Inc. Provides you with the following data on its operation for analysis:Unit selling priceP40Variable costs and expenses per unit.P30Fixed cost and expenses per annum.P48,000REQUIRED:a. Contribution margin per unitb. Contribution margin percentagec. BEP sales volume (units)d. BEP peso salese. Peso sales with desired income of P9,000f. Peso sales with desired income P13,000 after 32% income tax
Net Income Planning Midvale Corporation sells a single product for $100 per unit, of which $40 is contribution margin. Fixed costs total $180, 000 and net income before income tax is $48, 000. Determine the following a. The present sales volume in dollars. $Answer 570, 000 b. The break - even point in units. Answer 4, 500 units c. The sales volume in units necessary to attain a net income before income tax of $60, 000 Answer 6, 000 units d. The sales volume in units necessary to attain a net income before income tax equal to 10% of sales revenue. Answer 5, 925 units e. The sales volume in units necessary to attain an after - tax net income of $54, 000 if the tax rate is 40% Answer 6,750 units.
Data concerning Celenza Corporation's single product appear below: selling price per unit- $230 Variable expense per unit- 59.80 fixed expense per month- 697,820 Assume the company's monthly target profit is $18,000. The dollar sales to attain that target profit are closest to: Select one: a. $967,324 b. $1,478,766 c. $715,820 d. $2,753,154
1. Assuming that sales revenue is increases by 10 percent, calculate the net income of DEF Company, 2. assuming that sales revenue is increases by 10 percent, find out the net income of ABC Company.
Student ID #: 11. George Corporation has the following information for the current year: Selling price per Variable costs per unit Fixed costs unit 2$ 10.00 2$ 6.00 $1,000.00 Required: Prepare a cost-volume-profit graph identifying the following items: Total fixed costs line Total variable costs line Total costs line Total revenues line Breakeven point in sales dollars Breakeven point in units Profit area A. B. С. D. Е. F. G. Н. Loss area 6,000 5,000 4,000 3,000 2,000 1,000 Retm 100 200 300 400 500 Earnin Qty (# Units) 3 Dollars ($)
what is the dollar sales to attain that target profit is closest to Data concerning Strite Corporation's single product appear below: Selling price per unit Variable expense per unit Fixed expense per month $ 150.00 $ 42.00 $421,200 He Assume the company's target profit is $8,000. The dollar sales to attain that target profit is closest to: (Round your i calculations to 2 decimal places.)