Sinbad manufactures decorative iron railings. In preparing for next year's operations, management has developed th following estimates: (LO# 3) Units Total Per unit Sales 20,000 1,000,000 50 Variable Expenses 600,000 30 СМ 400,000 20 Total Fixed Expenses 110,000 Operating Profit 290,000 Required: EXCEL Compute the following items: a. Unit contribution margin. b. Contribution margin ratio. c. Break-even in units and dollar sales. d. Margin of safety in dollar amount and percentage. e. If the sales volume increases by 20% with no change in total fixed expenses, what will be the change in net operating income? Verify your answer f. If the per unit variable production costs increase by 15%, and if fixed selling and administrative expenses increase by 12%, what will be the new break-even point in dollar sales?
Sinbad manufactures decorative iron railings. In preparing for next year's operations, management has developed th following estimates: (LO# 3) Units Total Per unit Sales 20,000 1,000,000 50 Variable Expenses 600,000 30 СМ 400,000 20 Total Fixed Expenses 110,000 Operating Profit 290,000 Required: EXCEL Compute the following items: a. Unit contribution margin. b. Contribution margin ratio. c. Break-even in units and dollar sales. d. Margin of safety in dollar amount and percentage. e. If the sales volume increases by 20% with no change in total fixed expenses, what will be the change in net operating income? Verify your answer f. If the per unit variable production costs increase by 15%, and if fixed selling and administrative expenses increase by 12%, what will be the new break-even point in dollar sales?
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
could you please start from question d
![Sinbad manufactures decorative iron railings. In preparing for next year's operations, management has developed the
following estimates: (LO# 3)
Units
Total
Per unit
Sales
20,000
1,000,000
50
Variable Expenses
600,000
30
CM
400,000
20
Total Fixed Ex
ses
110,000
Operating Profit
290,000
Required: EXCEL
Compute the following items:
a. Unit contribution margin.
b. Contribution margin ratio.
c. Break-even in units and dollar sales.
d. Margin of safety in dollar amount and percentage.
e. If the sales volume increases by 20% with no change in total fixed expenses, what will be the change in net operating
income? Verify your answer
f. If the per unit variable production costs increase by 15%, and if fixed selling and administrative expenses increase by
12%, what will be the new break-even point in dollar sales?
g. if the company would like to achieve a profit of $90,000 next year, what would be the break-even point in units and dollar
amount to earn that target?
h. If monthly sales increase by $80,000 and there is no change in fixed expenses, by how much would you expect monthly
net operating income to increase?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F942b06a1-e1f1-4dbe-a5b9-420ebd6fee65%2F2eed48b7-cead-4a9f-90bd-911450622aca%2Fm0qzqf_processed.png&w=3840&q=75)
Transcribed Image Text:Sinbad manufactures decorative iron railings. In preparing for next year's operations, management has developed the
following estimates: (LO# 3)
Units
Total
Per unit
Sales
20,000
1,000,000
50
Variable Expenses
600,000
30
CM
400,000
20
Total Fixed Ex
ses
110,000
Operating Profit
290,000
Required: EXCEL
Compute the following items:
a. Unit contribution margin.
b. Contribution margin ratio.
c. Break-even in units and dollar sales.
d. Margin of safety in dollar amount and percentage.
e. If the sales volume increases by 20% with no change in total fixed expenses, what will be the change in net operating
income? Verify your answer
f. If the per unit variable production costs increase by 15%, and if fixed selling and administrative expenses increase by
12%, what will be the new break-even point in dollar sales?
g. if the company would like to achieve a profit of $90,000 next year, what would be the break-even point in units and dollar
amount to earn that target?
h. If monthly sales increase by $80,000 and there is no change in fixed expenses, by how much would you expect monthly
net operating income to increase?
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education