Question

In: Accounting

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 @ 170 = 129,200 950 174,800
Fixed cost (19,000 ) (73,000 ) (92,000 )
Net income $ 26,600 $ 56,200 $ 82,800

   Required:

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

  2. Determine the weighted-average contribution margin per unit.

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

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

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

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

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

Relative percentage for Power %
Relative percentage for Lite %

Determine the weighted-average contribution margin per unit.

Weighted-average contribution margin per unit

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

Break-even point units

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

Required sales for Power units
Required sales for Lite units

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

Power Lite Total
Sales
Variable costs
Contribution margin
Fixed cost
Net income (Loss)

Determine the margin of safety based on the combined sales of the two products. (Round your answer to 1 decimal place.(i.e., 0.234 should be entered as 23.4))

Margin of safety %

Solutions

Expert Solution

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

Relative percentage for Power 190/950 = 20 %
Relative percentage for Lite 80% %

Determine the weighted-average contribution margin per unit.

Weighted-average contribution margin per unit 240*20%+170*80% = 184

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

Break-even point 92000/184 = 500 units

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

Required sales for Power 500*20% = 100 units
Required sales for Lite 400 units

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

Power Lite Total
Sales 59000 224000 283000
Variable costs 35000 156000 191000
Contribution margin 24000 68000 92000
Fixed cost 92000
Net income (Loss) 0

Determine the margin of safety based on the combined sales of the two products. (Round your answer to 1 decimal place.(i.e., 0.234 should be entered as 23.4))

Margin of safety (537700-283000/537700) = 47.4 %

Related Solutions

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