Question

In: Accounting

Solomon Company produces two products. Budgeted annual income statements for the two products are provided here:...

Solomon Company produces two products. Budgeted annual income statements for the two products are provided here:

Power Lite Total
Budgeted Per Budgeted Budgeted Per Budgeted Budgeted Budgeted
Number Unit Amount Number Unit Amount Number Amount
Sales 170 @ $ 760 = $ 129,200 680 @ $ 550 = $ 374,000 850 $ 503,200
Variable cost 170 @ 420 = (71,400 ) 680 @ 290 = (197,200 ) 850 (268,600 )
Contribution margin 170 @ 340 = 57,800 680 @ 260 = 176,800 850 234,600
Fixed cost (18,000 ) (120,000 ) (138,000 )
Net income $ 39,800 $ 56,800 $ 96,600

    

Required:

Based on budgeted sales, determine the relative sales mix between the two products.

Determine the weighted-average contribution margin per unit.

Calculate the break-even point in total number of units.

Determine the number of units of each product Solomon must sell to break even.

Verify the break-even point by preparing an income statement for each product as well as an income statement for the combined products.

Determine the margin of safety based on the combined sales of the two products.

Solutions

Expert Solution

a. Sales mix:

Power: 170/850 = 20%

Lite: 680/850 = 80%

b.

Power Lite Total
Contribution per unit $ 340 260 600
Sales Mix (2 : 8) 2 8 10
Total contribution $ 680 2080 2760

Total weighted average contribution per unit = $2760 / 10 = $276

c. Break-even point in total number of units: 500 units

Assume the total volume of sales (units) = X

For break-even: Weighted average contribution per unit x X - Total Fixed costs = Operating income

$276X - $138000 = $0

$276X = $138000

X = $138000/$276 = 500 units

d. Number of break-even units of each product

Power: 500 units x 20% = 100 units

Lite: 500 units x 80% = 400 units

e.

Power Lite Total
Sales 76000 220000 296000
Variable costs 42000 116000 158000
Contribution margin 34000 104000 138000
Fixed cost 18000 120000 138000
Net income (Loss) 16000 -16000 0

f. Margin of safety = Actual sales - Break-even sales = $503200 - $296000 = $207200

Margin of safety % = Margin of safety/Actual sales = $207200/$503200 = 41.2%


Related Solutions

Kidd Company produces two products. Budgeted annual income statements for the two products are provided here:...
Kidd Company produces two products. Budgeted annual income statements for the two products are provided here: Power Lite Total Budgeted Per Budgeted Budgeted Per Budgeted Budgeted Budgeted Number Unit Amount Number Unit Amount Number Amount Sales 200 @ $ 500 = $ 100,000 800 @ $ 560 = $ 448,000 1,000 $ 548,000 Variable cost 200 @ 290 = (58,000 ) 800 @ 380 = (304,000 ) 1,000 (362,000 ) Contribution margin 200 @ 210 = 42,000 800 @ 180...
Watt Company produces two products. Budgeted annual income statements for the two products are provided here:...
Watt Company produces two products. Budgeted annual income statements for the two products are provided here: Power Lite Total Budgeted Per Budgeted Budgeted Per Budgeted Budgeted Budgeted Number Unit Amount Number Unit Amount Number Amount   Sales 200     @ $ 500 = $ 100,000 800     @ $ 560 = $ 448,000 1,000     $ 548,000   Variable cost 200     @ 290 = (58,000 ) 800     @ 380 = (304,000 ) 1,000     (362,000 )   Contribution margin 200    ...
Fanning Company produces two products. Budgeted annual income statements for the two products are provided here:...
Fanning Company produces two products. Budgeted annual income statements for the two products are provided here: Power Lite Total Budgeted Per Budgeted Budgeted Per Budgeted Budgeted Budgeted Number Unit Amount Number Unit Amount Number Amount Sales 190 @ $ 590 = $ 112,100 760 @ $ 560 = $ 425,600 950 $ 537,700 Variable cost 190 @ 350 = (66,500 ) 760 @ 390 = (296,400 ) 950 (362,900 ) Contribution margin 190 @ 240 = 45,600 760 @ 170...
Kidd Company produces two products. Budgeted annual income statements for the two products are provided here:...
Kidd Company produces two products. Budgeted annual income statements for the two products are provided here: Power Lite Total Budgeted Per Budgeted Budgeted Per Budgeted Budgeted Budgeted Number Unit Amount Number Unit Amount Number Amount Sales 160 @ $ 500 = $ 80,000 640 @ $ 450 = $ 288,000 800 $ 368,000 Variable cost 160 @ 320 = (51,200 ) 640 @ 330 = (211,200 ) 800 (262,400 ) Contribution margin 160 @ 180 = 28,800 640 @ 120...
Vernon Company produces two products. Budgeted annual income statements for the two products are provided here:...
Vernon Company produces two products. Budgeted annual income statements for the two products are provided here: Power Lite Total Budgeted Per Budgeted Budgeted Per Budgeted Budgeted Budgeted Number Unit Amount Number Unit Amount Number Amount Sales 270 @ $ 690 = $ 186,300 630 @ $ 580 = $ 365,400 900 $ 551,700 Variable cost 270 @ 420 = (113,400 ) 630 @ 350 = (220,500 ) 900 (333,900 ) Contribution margin 270 @ 270 = 72,900 630 @ 230...
Fanning Company produces two products. Budgeted annual income statements for the two products are provided as...
Fanning Company produces two products. Budgeted annual income statements for the two products are provided as follows. Power Lite Total Budgeted Per Budgeted Budgeted Per Budgeted Budgeted Budgeted Number Unit Amount Number Unit Amount Number Amount Sales 190 @ $ 590 = $ 112,100 760 @ $ 560 = $ 425,600 950 $ 537,700 Variable cost 190 @ 350 = (66,500 ) 760 @ 390 = (296,400 ) 950 (362,900 ) Contribution margin 190 @ 240 = 45,600 760 @...
Portions of the financial statements for Myriad Products are provided below. MYRIAD PRODUCTS COMPANY Income Statement...
Portions of the financial statements for Myriad Products are provided below. MYRIAD PRODUCTS COMPANY Income Statement For the Year Ended December 31, 2018 ($ in millions) Sales $ 840 Cost of goods sold 294 Gross margin 546 Salaries expense $ 135 Depreciation expense 92 Patent amortization expense 5 Interest expense 32 Loss on sale of land 4 268 Income before taxes 278 Income tax expense 139 Net Income $ 139 MYRIAD PRODUCTS COMPANY Selected Accounts from Comparative Balance Sheets December...
Portions of the financial statements for Myriad Products are provided below. MYRIAD PRODUCTS COMPANY Income Statement...
Portions of the financial statements for Myriad Products are provided below. MYRIAD PRODUCTS COMPANY Income Statement For the Year Ended December 31, 2016 ($ in millions) Sales $ 700 Cost of goods sold (245 ) Gross margin 455 Salaries expense $ 100 Depreciation expense 78 Patent amortization expense 5 Interest expense 18 Loss on sale of land 4 (205 ) Income before taxes 250 Income tax expense (125 ) Net Income $ 125 MYRIAD PRODUCTS COMPANY Selected Accounts from Comparative...
Portions of the financial statements for Myriad Products are provided below. MYRIAD PRODUCTS COMPANY Income Statement...
Portions of the financial statements for Myriad Products are provided below. MYRIAD PRODUCTS COMPANY Income Statement For the Year Ended December 31, 2018 ($ in millions) Sales $ 700 Cost of goods sold 245 Gross margin 455 Salaries expense $ 100 Depreciation expense 78 Patent amortization expense 5 Interest expense 18 Loss on sale of land 4 205 Income before taxes 250 Income tax expense 125 Net Income $ 125 MYRIAD PRODUCTS COMPANY Selected Accounts from Comparative Balance Sheets December...
Portions of the financial statements for Myriad Products are provided below. MYRIAD PRODUCTS COMPANY Income Statement...
Portions of the financial statements for Myriad Products are provided below. MYRIAD PRODUCTS COMPANY Income Statement For the Year Ended December 31, 2018 ($ in millions) Sales $ 720 Cost of goods sold 252 Gross margin 468 Salaries expense $ 105 Depreciation expense 80 Patent amortization expense 5 Interest expense 20 Loss on sale of land 4 214 Income before taxes 254 Income tax expense 127 Net Income $ 127 MYRIAD PRODUCTS COMPANY Selected Accounts from Comparative Balance Sheets December...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT