Obj. 2.3 PR 6-2A Break-even sales under present and proposed conditions Portmann Company, operating at full capacity, sold 1.000.000 units at a price of $188 per unit during the current year. Its income statement is as follows: Sales.... Cost of goods sold $ 188,000,000 (100,000,000) $ 88,000,000 Gross profit.. Expenses: Selling expenses.. $16,000,000 Administrative expenses... 12,000,000 Total expenses (28,000,000) $ 60,000,000 Operating income.. The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 70% 30%

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

The fields in yellow require an answer.  Thank you.

Obj. 2.3
PR 6-2A Break-even sales under present and proposed conditions
Portmann Company operating at full capacity, sold 1.000.000 units at a price of $188 per unit
during the current year. Its income statement is as follows:
Sales....
$ 188,000,000
(100,000,000)
Cost of goods sold
Gross profit...
$ 88,000,000
Expenses:
Selling expenses.....
$16,000,000
Administrative expenses... 12,000,000
Total expenses..
(28,000,000)
Operating income.
60,000,000
The division of costs between yariable and fixed is as follows:
Variable
Fixed
Z0%
30%
Cost of goods sold
Selling expenses
Z5%
25%
Administrative expenses
50%
50%
Management is considering a plant expansion program for the following year that will permit
an increase of $11,280,000 in yearly sales. The expansion will increase fixed costs by $5,000,000
but will not affect the relationship between sales and variable costs.
Instructions
1. Determine the total variable costs and the total fixed costs for the current year.
2. Determine (a) the unit variable cost and (b) the unit contribution margin for the current year.
3. Compute the break-even sales (units) for the current year.
4. Compute the break-even sales (units) under the proposed program for the following year.
5. Determine the amount of sales (units) that would be necessary under the proposed program to
realize the $60,000,000 of operating income that was earned in the current year.
6. Determine the maximum operating income possible with the expanded plant.
7. If the proposal is accepted and sales remain at the current level, what will the operating in-
come or loss be for the following year?
8.
Based on the data given, would you recommend accepting the proposal? Explain.
A
B
C
D
E
1
Bee Gee Company
Income Statement
2
3
For the Year Ended December 31, 2021
4
Actual
5
$ 199,280,000
6
70,000,000
7
$ 129,280,000
8
$ 12,000,000
6,000,000
18,000,000
$ 111,280,000
Fixed
Sales
Cost of goods sold
Gross profit
Operating Expenses:
Selling expenses
Administrative expenses
Total operating expenses
9
10
11
12
Income from operations
13
14
15
Division of costs between variable and fixed:
16
Variable
17
Cost of goods sold
70%
18
Selling expenses
75%
19
Administrative expenses
50%
20
21
Fixed costs of goods sold
$ 21,000,000
22
Fixed selling expenses
3,000,000
3,000,000
23
Fixed administrative expenses
24
Total fixed costs
$ 27,000,000
25
26
Variable cost of goods sold
$ 49,000,000
27
Variable selling expenses
9,000,000
3,000,000
28
Variable administrative expenses
29
Total variable costs
$ 61,000,000
30
31
Total fixed and variable costs
$ 88,000,000
32
88,000,000
Total costs from income statement
Check figure
33
34
35
2 Total variable costs
$ 61,000,000
36
Units sold
A
B
D
37 a. Unit variable cost
38
39
Total sales
40
Units sold
41
Sales per unit
42
Variable cost per unit
43 b. Unit contribution margin
44
45
3 Total fixed costs
46
Unit contribution margin
47
Break-even sales (units)
48
49
Current fixed cost
50
Proposed increase
51
Proposed fixed cost
52
34
35
53
Unit contribution margin
54
55
Proposed break even sales (units)
56
57
57 5 Proposed fixed costs
Target profit
58
59
60
61
62 Targeted sales (units)
63
64 6 Current sales
65
66
67
68
69
70
71
72
73
74
75
76
77
78 8
79
Unit contribution margin
Maximum sales increase
Maximum proposes sales (dollars)
Variable costs
Contribution margin
Proposed fixed costs
Maximum income from operations
7 Current sales
Variable costs
Contribution margin
Proposed fixed costs
Income from operations
с
#DIV/0!
$ 199,280,000
#DIV/0!
#DIV/0!
#DIV/0!
$ 27,000,000
#DIV/0!
#DIV/0!
$ 27,000,000
$ 27,000,000
#DIV/0!
#DIV/0!
$ 27,000,000
$ 111,280,000
#DIV/0!
#DIV/0!
$ 199,280,000
199,280,000
#DIV/0!
#DIV/0!
27,000,000
#DIV/0!
$ 199,280,000
#DIV/0!
#DIV/0!
27,000,000
#DIV/0!
#DIV/0!
30%
25%
50%
Check figure (s/b0)
E
F
G
Contribution margin ratio
Transcribed Image Text:Obj. 2.3 PR 6-2A Break-even sales under present and proposed conditions Portmann Company operating at full capacity, sold 1.000.000 units at a price of $188 per unit during the current year. Its income statement is as follows: Sales.... $ 188,000,000 (100,000,000) Cost of goods sold Gross profit... $ 88,000,000 Expenses: Selling expenses..... $16,000,000 Administrative expenses... 12,000,000 Total expenses.. (28,000,000) Operating income. 60,000,000 The division of costs between yariable and fixed is as follows: Variable Fixed Z0% 30% Cost of goods sold Selling expenses Z5% 25% Administrative expenses 50% 50% Management is considering a plant expansion program for the following year that will permit an increase of $11,280,000 in yearly sales. The expansion will increase fixed costs by $5,000,000 but will not affect the relationship between sales and variable costs. Instructions 1. Determine the total variable costs and the total fixed costs for the current year. 2. Determine (a) the unit variable cost and (b) the unit contribution margin for the current year. 3. Compute the break-even sales (units) for the current year. 4. Compute the break-even sales (units) under the proposed program for the following year. 5. Determine the amount of sales (units) that would be necessary under the proposed program to realize the $60,000,000 of operating income that was earned in the current year. 6. Determine the maximum operating income possible with the expanded plant. 7. If the proposal is accepted and sales remain at the current level, what will the operating in- come or loss be for the following year? 8. Based on the data given, would you recommend accepting the proposal? Explain. A B C D E 1 Bee Gee Company Income Statement 2 3 For the Year Ended December 31, 2021 4 Actual 5 $ 199,280,000 6 70,000,000 7 $ 129,280,000 8 $ 12,000,000 6,000,000 18,000,000 $ 111,280,000 Fixed Sales Cost of goods sold Gross profit Operating Expenses: Selling expenses Administrative expenses Total operating expenses 9 10 11 12 Income from operations 13 14 15 Division of costs between variable and fixed: 16 Variable 17 Cost of goods sold 70% 18 Selling expenses 75% 19 Administrative expenses 50% 20 21 Fixed costs of goods sold $ 21,000,000 22 Fixed selling expenses 3,000,000 3,000,000 23 Fixed administrative expenses 24 Total fixed costs $ 27,000,000 25 26 Variable cost of goods sold $ 49,000,000 27 Variable selling expenses 9,000,000 3,000,000 28 Variable administrative expenses 29 Total variable costs $ 61,000,000 30 31 Total fixed and variable costs $ 88,000,000 32 88,000,000 Total costs from income statement Check figure 33 34 35 2 Total variable costs $ 61,000,000 36 Units sold A B D 37 a. Unit variable cost 38 39 Total sales 40 Units sold 41 Sales per unit 42 Variable cost per unit 43 b. Unit contribution margin 44 45 3 Total fixed costs 46 Unit contribution margin 47 Break-even sales (units) 48 49 Current fixed cost 50 Proposed increase 51 Proposed fixed cost 52 34 35 53 Unit contribution margin 54 55 Proposed break even sales (units) 56 57 57 5 Proposed fixed costs Target profit 58 59 60 61 62 Targeted sales (units) 63 64 6 Current sales 65 66 67 68 69 70 71 72 73 74 75 76 77 78 8 79 Unit contribution margin Maximum sales increase Maximum proposes sales (dollars) Variable costs Contribution margin Proposed fixed costs Maximum income from operations 7 Current sales Variable costs Contribution margin Proposed fixed costs Income from operations с #DIV/0! $ 199,280,000 #DIV/0! #DIV/0! #DIV/0! $ 27,000,000 #DIV/0! #DIV/0! $ 27,000,000 $ 27,000,000 #DIV/0! #DIV/0! $ 27,000,000 $ 111,280,000 #DIV/0! #DIV/0! $ 199,280,000 199,280,000 #DIV/0! #DIV/0! 27,000,000 #DIV/0! $ 199,280,000 #DIV/0! #DIV/0! 27,000,000 #DIV/0! #DIV/0! 30% 25% 50% Check figure (s/b0) E F G Contribution margin ratio
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Ratio Analysis
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