Using a Computer Spreadsheet to Solve Multiple- Product Break-Even: Varying Sales MixMore-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 SanderMini-SanderTotalSales$3,000,000$1,800,000$4,800,000Less: Variable expenses1,800,000900,0002,700,000Contribution margin$1,200,000$900,000$2,100,000Less: Direct fixed expenses700,000250,000450,000$450,000Product margin$950,000$1,400,000Less: Common fixed600,000expenses$800,000Operating incomeRequired:1. For each of the following possible sales mixes, calculate operating income:Regular Sander Mini-Sander37,50075,000а.b.60,00060,00030,00090,000C.d.30,00060,000Operating Incomeа.b.C.d.2. Calculate the break-even units for each product for each of the preceding sales mixes. Round the number of break-even packages to two decimal places (and use this figure for intermediate calculations). Round the number of break-even regular and mini-sanders to the nearestwhole unit.baCBreak-even packagesBreak-even regular sandersBreak-even mini-sanders

Using the information in question, we shall calculate the per unit sales price & cost prices for…

Answered: Using a Computer Spreadsheet to Solve…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Chovanec Corporation produces and sells a single product. Data concerning that product appear below: Per Unit Percent of Sales Selling price $ 170 100% Variable expenses 68 40% Contribution margin $ 102 60% Fixed expenses are $521,000 per month. The company is currently selling 7,000 units per month. Management is considering using a new component that would increase the unit variable cost by $6. Since the new component would increase the features of the company's product, the marketing manager predicts that monthly sales would increase by 500 units. What should be the overall effect on the company's monthly net operating income of this change? Multiple Choice increase of $6,000 decrease of $6,000 decrease of $48,000 increase of $48,000
Only typing answer Please explain step by step
Please do not give solution in image format thanku
i need the answer quickly
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 Sales $3,000,000 $1,800,000 $4,800,000 Less: Variable expenses 1,800,000 900,000 2,700,000 Contribution margin $1,200,000 $900,000 $2,100,000 Less: Direct fixed expenses 250,000 450,000 700,000 Product margin $950,000 $450,000 $1,400,000 Less: Common fixed expenses 600,000 Operating income $800,000 Required: 1. For each of the following possible sales mixes, calculate operating income: Regular Sander Mini-Sander a. 75,000 37,500 b. 60,000 60,000 c. 30,000 90,000 d. 30,000 60,000 Operating Income a. $_________ b. $______ c. $________ d. $_________ 2. Calculate the break-even units for each product for each of the preceding sales mixes. Round the number of break-even packages to two decimal…
Assume a retailing company has two departments-Department A and Department B. The company's most recent contribution format income statement follows: Sales Variable expenses Contribution margin Fixed expenses Net operating income (loss) Multiple Choice O The company says that $110,000 of the fixed expenses being charged to Department B are sunk costs or allocated costs that will continue if the segment is discontinued. However, if Department B is discontinued the sales in Department A will drop by 12%. What is the financial advantage (disadvantage) of discontinuing Department B? O O O $(148,000) $(152,000) $(147,600) Total $ 800,000 320,000 $(127,600) 480,000 400,000 $ 80,000 Department A Department B $ 350,000 $ 450,000 120,000 200,000 230,000 250,000 260,000 140,000 $ 90,000 $ (10,000)
ces Data for Hermann Corporation are shown below: Selling price Variable expenses Contribution margin Fixed expenses are $72,000 per month and the company is selling 4,200 units per month. Percent Per Unit of Sales $60 100% 39 65 $21 35% Required (see below for a hint if you get stuck): 1-a. How much will net operating income increase (decrease) per month if the monthly advertising budget increases by $9,600 and the monthly sales volume increases by 100 units? 1-b. Should the advertising budget be increased? Complete this question by entering your answers in the tabs below. Req 1A Req 1B How much will net operating income increase (decrease) per month if the monthly advertising budget increases by $9,600, the monthly sales volume increases by 100 units, and the total monthly sales increase by $6,000? (Do not round intermediate calculations.) Net operating income by
Using this information, what is Your Company's expected total contribution margin when 5,000 units are sold? Expected sales in units 5,000 Sales price per unit $20 Margin of safety in units 3,750 Expected Breakeven Contribution margin ratio 35% $35,000 $48,750 $65,000 $26,250
Naumann Corporation produces and sells a single product. Data concerning that product appear below: Percent of Sales 100% 18% 82% Selling price Variable expenses Contribution margin Per Unit $ 200 36 $164 Fixed expenses are $130,000 per month. The company is currently selling 1,200 units per month. Required: Management is considering using a new component that would increase the unit variable cost by $46. Since the new component would improve the company's product, the marketing manager predicts that monthly sales would increase by 400 units. What should be the overall effect on the company's monthly net operating income of this change if fixed expenses are unaffected? Note: Negative amounts should be indicated by a minus sign. Change in net operating income
A company that produces and sells a single product has the following characteristics: Selling price Variable expenses Contribution margin Per Unit $220 44 $176 Multiple Choice Percent of Sales 100% 20% 80% The company is currently selling 8,000 units per month. Fixed expenses are $901,000 per month. Management is considering using a new component that would increase the unit variable cost by $10. Since the new component would increase the features of the company's product, the marketing manager predicts that monthly sales would increase by 500 units. What should be the overall effect or the company's monthly net operating income of this change?
Rahul

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS