Question

In: Accounting

Shown here is an income statement in the traditional format for a firm with a sales...

Shown here is an income statement in the traditional format for a firm with a sales volume of 7,500 units. Cost formulas also are shown:

Revenues

$

34,100

Cost of goods sold ($5,600 + $2.15/unit)

21,725

Gross profit

$

12,375

Operating expenses:

Selling ($1,170 + $0.10/unit)

1,920

Administration ($3,650 + $0.20/unit)

5,150

Operating income

$

5,305

Required:

a. Prepare an income statement in the contribution margin format.

Contribution Margin Income Statement

Revenue

$34,100

Variable expenses:

Cost of goods sold

$16,125

Selling expenses

750

Administrative expenses

1,500

Total variable expenses

18,375

Contribution margin

15,725

Fixed expenses:

Cost of goods sold

5,600

Selling expenses

1,170

Administrative expenses

3,650

Total fixed expenses

10,420

$5,305

b. Calculate the contribution margin per unit and the contribution margin ratio. (Do not round intermediate calculations. Round contribution margin per unit to 2 decimal places.)

c-1. Calculate the firm's operating income (or loss) if the volume changed from 7,500 units to 11,250 units. (Do not round intermediate calculations.)

c-2. Calculate the firm's operating income (or loss) if the volume changed from 7,500 units to 3,750 units. (Do not round intermediate calculations.)

Refer to your answer to part a for total revenues of $34,100.

d-1. Calculate the firm’s operating income (or loss) if unit selling price and variable expenses per unit do not change and total revenues increase by $12,500. (Round intermediate calculations to 2 decimal places.)

d-2. Calculate the firm's operating income (or loss) if unit selling price and variable expenses per unit do not change and total revenues decrease by $3,500. (Round intermediate calculations to 2 decimal places.)

Solutions

Expert Solution

  • All working forms part of the answer
  • Requirement ‘b’

A

Contribution margin

$                             15,725.00

B

Units

7500

C = A/B

Contribution margin per unit

$                                        2.10

D

Sales

$                             34,100.00

E = A/D

Contribution Margin ratio

46.11%

  • Requirement ‘c1’ and ‘c2’

Contribution Margin Income Statement

No. of units

7500

11250

3750

Original Data [Req ‘a’]

Requirement “c- 1”

Requirement “c- 2”

Revenue

$               34,100.00

$                        51,150.00

$                                                 17,050.00

Variable expenses:

Cost of goods sold

$                             16,125.00

$                     24,187.50

$                     8,062.50

Selling expenses

$                                   750.00

$                       1,125.00

$                         375.00

Administrative expenses

$                               1,500.00

$                       2,250.00

$                         750.00

Total variable expenses

$               18,375.00

$                        27,562.50

$                                                    9,187.50

Contribution margin

$               15,725.00

$                        23,587.50

$                                                    7,862.50

Fixed expenses:

Cost of goods sold

$                               5,600.00

$                       5,600.00

$                     5,600.00

Selling expenses

$                               1,170.00

$                       1,170.00

$                     1,170.00

Administrative expenses

$                               3,650.00

$                       3,650.00

$                     3,650.00

Total fixed expenses

$               10,420.00

$                        10,420.00

$                                                 10,420.00

Net Operating Income

$                 5,305.00

$                        13,167.50

$                                                 (2,557.50)

  • Requirement ‘d’

Working

A

Contribution margin

$                             15,725.00

B

Net Operating Income

$                               5,305.00

C = A/B

Degree of Operating Leverage

2.964184731

Working and Answer:

Working

Answer d-1

Answer d-2

A

Increase (Decrease) in Revenue

$                             12,500.00

$               (3,500.00)

B

Original Sales Revenue

$                             34,100.00

$               34,100.00

C = (A/B)x100

% Increase (Decrease) In Sales Revenue

36.66%

-10.26%

D

Degree of Operating Leverage

2.964184731

2.964184731

E = C x D

% Increase (Decrease) in Operating Income

108.66%

-30.42%

F

Original Operating Income

$                               5,305.00

$                 5,305.00

G = F + (FxE)

New Operating Income

$                             11,069.30

$                 3,691.00


Related Solutions

Shown here is an income statement in the traditional format for a firm with a sales...
Shown here is an income statement in the traditional format for a firm with a sales volume of 7,600 units. Cost formulas also are shown: Revenues $ 34,600 Cost of goods sold ($5,700 + $2.10/unit) 21,660 Gross profit $ 12,940 Operating expenses: Selling ($1,190 + $0.09/unit) 1,874 Administration ($3,550 + $0.15/unit) 4,690 Operating income $ 6,376 Required: a. Prepare an income statement in the contribution margin format. b. Calculate the contribution margin per unit and the contribution margin ratio. (Do...
Shown here is an income statement in the traditional format for a firm with a sales...
Shown here is an income statement in the traditional format for a firm with a sales volume of 7,900 units. Cost formulas also are shown: Revenues $ 34,200 Cost of goods sold ($5,700 + $2.20/unit) 23,080 Gross profit $ 11,120 Operating expenses: Selling ($1,180 + $0.09/unit) 1,891 Administration ($3,550 + $0.20/unit) 5,130 Operating income $ 4,099 Required: a. Prepare an income statement in the contribution margin format. b. Calculate the contribution margin per unit and the contribution margin ratio. (Do...
Shown here is an income statement in the traditional format for a firm with a sales...
Shown here is an income statement in the traditional format for a firm with a sales volume of 7,600 units. Cost formulas also are shown: Revenues $ 34,100 Cost of goods sold ($5,900 + $2.20/unit) 22,620 Gross profit $ 11,480 Operating expenses: Selling ($1,170 + $0.11/unit) 2,006 Administration ($3,800 + $0.20/unit) 5,320 Operating income $ 4,154 a. Prepare an income statement in the contribution margin format. Contribution Margin Income Statement Variable expenses: Total variable expenses Fixed expenses: Total fixed expenses...
Shown below is an income statement in the traditional format for April Corp. that sells a...
Shown below is an income statement in the traditional format for April Corp. that sells a single product having a sales volume of 15,000 units. Cost formulas are also shown (for example, COGS includes fixed costs of $23,000 and variable costs of $3.20 per unit): Sales ………………………………………………………………… $108,000 Cost of goods sold ($23,000 + $3.20 per unit) ……………………… (71,000) Gross profit ………………………………………………………… $ 37,000 Operating expenses: Selling ($9,000 + $0.82 per unit) …………………………………… (21,300) Administrative ($12,800 +$0.07 per unit)…………………………… (13,850)...
Miller Company’s contribution format income statement for the most recent month is shown below: Sales (37,000...
Miller Company’s contribution format income statement for the most recent month is shown below: Sales (37,000 units) $ 259,000 $ 7.00 Variable expenses 148,000 4.00 Contribution margin 111,000 $ 3.00 Fixed expenses 42,000 Net operating income $ 69,000 Consider each case independently): 1. What is the revised net operating income if unit sales increase by 19%? 2. What is the revised net operating income if the selling price decreases by $1.40 per unit and the number of units sold increases...
Frieden Company's contribution format income statement for last month is shown below:   Sales (30,000 units) $...
Frieden Company's contribution format income statement for last month is shown below:   Sales (30,000 units) $ 1,200,000   Variable expenses 720,000   Contribution margin 480,000   Fixed expenses 384,000   Operating income $ 96,000 Competition is intense, and Frieden Company’s profits vary considerably from one year to the next. Management is exploring opportunities to increase profitability. Required: 1. Frieden’s management is considering a major upgrade to the manufacturing equipment, which would result in fixed expenses increasing by $480,000 per month. However, variable expenses would...
Frieden Company's contribution format income statement for last month is shown below:   Sales (42,000 units) $...
Frieden Company's contribution format income statement for last month is shown below:   Sales (42,000 units) $ 1,050,000   Variable expenses 630,000   Contribution margin 420,000   Fixed expenses 378,000   Operating income $ 42,000 Competition is intense, and Frieden Company’s profits vary considerably from one year to the next. Management is exploring opportunities to increase profitability. Required: 1. Frieden’s management is considering a major upgrade to the manufacturing equipment, which would result in fixed expenses increasing by $420,000 per month. However, variable expenses would...
Frieden Company's contribution format income statement for last month is shown below:   Sales (35,000 units) $...
Frieden Company's contribution format income statement for last month is shown below:   Sales (35,000 units) $ 700,000   Variable expenses 490,000   Contribution margin 210,000   Fixed expenses 189,000   Operating income $ 21,000 Competition is intense, and Frieden Company’s profits vary considerably from one year to the next. Management is exploring opportunities to increase profitability. Required: 1. Frieden’s management is considering a major upgrade to the manufacturing equipment, which would result in fixed expenses increasing by $210,000 per month. However, variable expenses would...
Frieden Company's contribution format income statement for last month is shown below:   Sales (46,000 units) $...
Frieden Company's contribution format income statement for last month is shown below:   Sales (46,000 units) $ 920,000   Variable expenses 690,000   Contribution margin 230,000   Fixed expenses 207,000   Operating income $ 23,000 Competition is intense, and Frieden Company’s profits vary considerably from one year to the next. Management is exploring opportunities to increase profitability. Required: 1. Frieden’s management is considering a major upgrade to the manufacturing equipment, which would result in fixed expenses increasing by $230,000 per month. However, variable expenses would...
The most recent financial statements for GPS, Inc., are shown here: Income Statement Sales $23,852 Costs...
The most recent financial statements for GPS, Inc., are shown here: Income Statement Sales $23,852 Costs $11,902 Taxable Income ? Taxes (40%) ? Net Income ? Balance Sheet Assets $56,455 Debt $18,576 Equity ? Assets and costs are proportional to sales. Debt and equity are not. A dividend of $1,980 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected to be $29,412. What is the external financing needed? (Negative amount should be...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT