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 СМ 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? 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?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

can u solve question E and  H 

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?
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
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Balance Of Payment
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education