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,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 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,900 units to 11,850 units. (Do not round intermediate calculations.)

c-2. Calculate the firm's operating income (or loss) if the volume changed from 7,900 units to 3,950 units. (Do not round intermediate calculations.) Refer to your answer to part a for total revenues of $34,200.

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 $11,000. (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 $2,500. (Round intermediate calculations to 2 decimal places.)

Solutions

Expert Solution

calculation in $
a) 7900 Unit Per Unit
sale 34200             4.33
less cost of goods sold -23080           -2.92
gross profit 11120             1.41
less: Selling expense -1891           -0.24
Administration expense -5130           -0.65
operating income 4099             0.52
b) contribution margin per unit:
sales-variable cost
sales per unit 4.33
less: cost of goods sold -2.2
gross profit per unit 2.13
Selling expense per unit -0.09
Administration expense per unit -0.2
contribution per unit 1.84
contribution margin ratio:
contribution/sales 1.84/4.33
0.424942
c1) (11850 units) Assuming fixed cost would remain same irrespective of output )
sales value 51310.5 11850*4.33
less cost of goods sold -31770 5700+(2.2*11850)
gross profit 19540.5
less: Selling expense -2246.5 1180+0.09*11850
Administration expense -5920 (3550+(0.2*11850))
operating income 11374
c2) 3950 units
sales value 17103.5 3950*4.33
less cost of goods sold -14390 5700+(2.2*3950)
gross profit 2713.5
less: Selling expense -1535.5 1180+0.09*3950
Administration expense -4340 (3550+(0.2*3950))
operating loss -3162
d1) if total revenue increase by 11000
45200 34200+11000
S.P.per unit 4.33
total sale qty 10438.8 45200/4.33
10439 rounded off
10439 units rounded off
sales value 45200.87 3950*4.33
less cost of goods sold -28665.8 5700+(2.2*10439)
gross profit 16535.07
less: Selling expense -2119.51 1180+0.09*10439
Administration expense -5637.8 (3550+(0.2*10439))
operating profit 8777.76
d2) if total revenue decrease by 2500
31700 34200-2500
4.33 s.p per unit
total sales qty
7321.016166 31700/4.33
7321 qty (rounded off)
sales value 31699.93 7321*4.33
cost of goods sold -21806.2 5700+(2.2*7321)
gross profit 9893.73
Selling expense -1838.89 1180+0.09*7321
Administration expense -5014.2 (3550+(0.2*7321))
operating profit 3040.64

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,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...
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,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