I ONLY NEED #4, 5, & 6 Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these estimates is as follows:   Estimated Fixed Cost   Estimated Variable Cost (per unit sold)         Production costs:                 Direct materials — $26           Direct labor — 17           Factory overhead $265,400 13         Selling expenses:                 Sales salaries and commissions 55,200 6           Advertising 18,700 —           Travel 4,100 —           Miscellaneous selling expense 4,600 5         Administrative expenses:                 Office and officers' salaries 53,900 —           Supplies 6,600 2           Miscellaneous administrative expense 6,220 3           Total $414,720 $72         It is expected that 8,960 units will be sold at a price of $144 a unit. Maximum sales within the relevant range are 11,000 units. Required: 1. Prepare an estimated income statement for 20Y7. Belmain Co.Estimated Income StatementFor the Year Ended December 31, 20Y7 - Select -     $ Cost of goods sold:       - Select -   $   - Select -   $   - Select -   $   Total cost of goods sold     $ Gross profit     $ Expenses:       Selling expenses:       - Select - $     - Select - $     - Select - $     - Select - $     Total selling expenses   $   Administrative expenses:       - Select - $     - Select - $     - Select - $     Total administrative expenses   $   Total expenses     $ Operating income     $ Question Content Area 2. What is the expected contribution margin ratio? Round to the nearest whole percent. fill in the blank 1 % 3. Determine the break-even sales in units and dollars. Units fill in the blank 2 units Dollars $fill in the blank 3 4. Construct a cost-volume-profit chart on your own paper. What is the break-even sales? $ fill in the blank 4 5. What is the expected margin of safety in dollars and as a percentage of sales? Dollars: $ fill in the blank 5   Percentage: (Round to the nearest whole percent.) fill in the blank 6 % 6. Determine the operating leverage. Round to one decimal place. fill in the blank 7   net income = $230,400 50% Break even units = 5,760 Dollars = $829,440

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

I ONLY NEED #4, 5, & 6

Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage

Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these estimates is as follows:

 

Estimated

Fixed Cost

 

Estimated Variable Cost

(per unit sold)

       

Production costs:

 

 

 

 

 

   

 

Direct materials

$26

 

 

 

 

 

Direct labor

17

 

 

 

 

 

Factory overhead

$265,400

13

 

 

 

 

Selling expenses:

 

 

 

 

 

   

 

Sales salaries and commissions

55,200

6

 

 

 

 

 

Advertising

18,700

 

 

 

 

 

Travel

4,100

 

 

 

 

 

Miscellaneous selling expense

4,600

5

 

 

 

 

Administrative expenses:

 

 

 

 

 

   

 

Office and officers' salaries

53,900

 

 

 

 

 

Supplies

6,600

2

 

 

 

 

 

Miscellaneous administrative expense

6,220

3

 

 

 

 

 

Total

$414,720

$72

 

 

 

 

It is expected that 8,960 units will be sold at a price of $144 a unit. Maximum sales within the relevant range are 11,000 units.

Required:

1. Prepare an estimated income statement for 20Y7.

Belmain Co.Estimated Income StatementFor the Year Ended December 31, 20Y7

- Select -

 

 

$

Cost of goods sold:

 

 

 

- Select -

 

$

 

- Select -

 

$

 

- Select -

 

$

 

Total cost of goods sold

 

 

$

Gross profit

 

 

$

Expenses:

 

 

 

Selling expenses:

 

 

 

- Select -

$

 

 

- Select -

$

 

 

- Select -

$

 

 

- Select -

$

 

 

Total selling expenses

 

$

 

Administrative expenses:

 

 

 

- Select -

$

 

 

- Select -

$

 

 

- Select -

$

 

 

Total administrative expenses

 

$

 

Total expenses

 

 

$

Operating income

 

 

$

Question Content Area

2. What is the expected contribution margin ratio? Round to the nearest whole percent.
fill in the blank 1 %

3. Determine the break-even sales in units and dollars.

Units

fill in the blank 2 units

Dollars

$fill in the blank 3

4. Construct a cost-volume-profit chart on your own paper. What is the break-even sales?
$ fill in the blank 4

5. What is the expected margin of safety in dollars and as a percentage of sales?

Dollars:

$ fill in the blank 5

 

Percentage: (Round to the nearest whole percent.)

fill in the blank 6

%

6. Determine the operating leverage. Round to one decimal place.
fill in the blank 7

 

  1. net income = $230,400
  2. 50%
  3. Break even units = 5,760

Dollars = $829,440

A
1. Income statement
1
2
3 Sales
4 Less: Cost of goods sold
Direct material
5
6
Direct Labor
7 Factory overhead
8 Gross profit
9 Less: Selling expenses
10 Sales salaries and commissions
11
12 Travel
Advertising
Particulars
13 Miscellaneous selling expense
14 Less: Administrative expenses:
15 Office and officers salaries
16 Supplies
17
18 Net income
19
20
21 Sales
22 Variable cost
23 Contribution per unit
24 Contribution Margin
25
26
27 Fixed cost
28 Break even in units
29 Break even in dollars
Amount
$ 1,290,240
$
$
$
Ś
3. Breakeven
$
$
$
$
Miscellaneous administrative expense $
$
$
$
2. Expected contribution Margin
$
$
$
$
B
$
232,960
152,320
381,880
523,080
108,960
18,700
4,100
49,400
53,900
24,520
33,100
230,400
144
72
72
50%
414,720
5,760
829,440
Transcribed Image Text:A 1. Income statement 1 2 3 Sales 4 Less: Cost of goods sold Direct material 5 6 Direct Labor 7 Factory overhead 8 Gross profit 9 Less: Selling expenses 10 Sales salaries and commissions 11 12 Travel Advertising Particulars 13 Miscellaneous selling expense 14 Less: Administrative expenses: 15 Office and officers salaries 16 Supplies 17 18 Net income 19 20 21 Sales 22 Variable cost 23 Contribution per unit 24 Contribution Margin 25 26 27 Fixed cost 28 Break even in units 29 Break even in dollars Amount $ 1,290,240 $ $ $ Ś 3. Breakeven $ $ $ $ Miscellaneous administrative expense $ $ $ $ 2. Expected contribution Margin $ $ $ $ B $ 232,960 152,320 381,880 523,080 108,960 18,700 4,100 49,400 53,900 24,520 33,100 230,400 144 72 72 50% 414,720 5,760 829,440
1
2
3 Sales
4 Less: Cost of goods sold
5
Direct material
6
Direct Labor
7 Factory overhead
8 Gross profit
9 Less: Selling expenses
10
11
12
13
Miscellaneous selling expense
14 Less: Administrative expenses:
15 Office and officers salaries
Supplies
Advertising
Travel
A
Particulars
Sales salaries and commissions
16
17
18 Net income
19
20
21 Sales
22 Variable cost
23 Contribution per unit
24 Contribution Margin
25
Miscellaneous administrative expense
26
27 Fixed cost
28 Break even in units
29 Break even in dollars
1. Income statement
-8960* 144
-8960*26
-8960*17
=265400+(13*8960)
=B3-SUM(B5:B7)
|=55200+(8960*6)
18700
4100
=4600+(5*8960)
53900
|-6600+(2*8960)
=6220+(3*8960)
|=B8-SUM(B10:B17)
2. Expected contribution Margin
144
|=26+17+13+6+5+2+3
=B21-B22
=B23/B21
3. Breakeven
B
=B27/B23
=B27/B24
Amount
|=265400+55200+18700+4100+4600+53900+6600+6220
Transcribed Image Text:1 2 3 Sales 4 Less: Cost of goods sold 5 Direct material 6 Direct Labor 7 Factory overhead 8 Gross profit 9 Less: Selling expenses 10 11 12 13 Miscellaneous selling expense 14 Less: Administrative expenses: 15 Office and officers salaries Supplies Advertising Travel A Particulars Sales salaries and commissions 16 17 18 Net income 19 20 21 Sales 22 Variable cost 23 Contribution per unit 24 Contribution Margin 25 Miscellaneous administrative expense 26 27 Fixed cost 28 Break even in units 29 Break even in dollars 1. Income statement -8960* 144 -8960*26 -8960*17 =265400+(13*8960) =B3-SUM(B5:B7) |=55200+(8960*6) 18700 4100 =4600+(5*8960) 53900 |-6600+(2*8960) =6220+(3*8960) |=B8-SUM(B10:B17) 2. Expected contribution Margin 144 |=26+17+13+6+5+2+3 =B21-B22 =B23/B21 3. Breakeven B =B27/B23 =B27/B24 Amount |=265400+55200+18700+4100+4600+53900+6600+6220
Expert Solution
steps

Step by step

Solved in 5 steps

Blurred answer
Similar 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