Question

In: Accounting

Margin of Safety Kearney Company, operating at full capacity, sold 400,000 units at a price of...

Margin of Safety

Kearney Company, operating at full capacity, sold 400,000 units at a price of $246.60 per unit during 2015. Its income statement for 2015 is as follows:

Sales $ 98,640,000
Cost of goods sold (44,500,000)
Gross profit $ 54,140,000
Expenses:
    Selling expenses $8,000,000
    Administrative expenses 3,000,000
        Total expenses (11,000,000)
Income from operations $ 43,140,000

The division of costs between fixed and variable is as follows:

Fixed Variable
Cost of good sold 28% 72%
Selling expenses 25% 75%
Administrative expenses 80% 20%

Management is considering a plant expansion program that will permit an increase of $8,631,000 (35,000 units at $246.60) in yearly sales. The expansion will increase fixed costs by $3,600,000 but will not affect the relationship between sales and variable costs.

Round the answers to one decimal place.

1. Margin of safety for 2015.
%

2. Margin of safety under the proposed program assuming 2015 sales.
%

Solutions

Expert Solution

Current Scenario
Break even sales = Fixed Cost / Cont. Margin ratio
= $ 16860000 / ($ 60000000 / $ 98640000)
= $ 27,717,840.00
Margin of Safety % = (Actual Sales - Break Even sales) / Actual Sales
= ($ 98640000 - $ 27717840) / $ 98640000
= 71.90%
Proposed Scenario
Break even sales = Fixed Cost / Cont. Margin ratio
= $ 20460000 / ($ 62500000 / $ 107217000)
= $ 33,636,240.00
Margin of Safety % = (Actual Sales - Break Even sales) / Actual Sales
= ($ 107271000 - $ 33636240) / $ 107271000
= 68.64%

Workings:

Scenarios
Particulars Current Per unit Proposed Per unit
Units 400000 435000
Sales $ 98,640,000.00 $ 246.60 $ 107,271,000.00 $ 246.60
Less: Variable Expenses $ 38,640,000.00 $    96.60 $   42,021,000.00 $    96.60
Contribution Margin $ 60,000,000.00 $ 150.00 $   65,250,000.00 $ 150.00
Less: Fixed Expenses $ 16,860,000.00 $   20,460,000.00
Income from operations $ 43,140,000.00 $   44,790,000.00
Particulars Total Fixed Variable
Cost of Goods sold $ 44,500,000.00 $ 12,460,000.00 (28%) $ 32,040,000.00 (72%)
Selling Expense $   8,000,000.00 $   2,000,000.00 (25%) $   6,000,000.00 (75%)
Administrative Expense $   3,000,000.00 $   2,400,000.00 (80%) $      600,000.00 (20%)
Total $ 55,500,000.00 $ 16,860,000.00 $ 38,640,000.00

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Darby Company, operating at full capacity, sold 159,800 units at a price of $51 per unit...
Darby Company, operating at full capacity, sold 159,800 units at a price of $51 per unit during the current year. Its income statement is as follows: Sales $8,149,800 Cost of goods sold 2,890,000 Gross profit $5,259,800 Expenses: Selling expenses $1,445,000 Administrative expenses 867,000 Total expenses 2,312,000 Income from operations $2,947,800 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50% Administrative expenses 30% 70% Management is considering...
Company A is operating at full capacity, sold 45,600 units during the current year. Its income...
Company A is operating at full capacity, sold 45,600 units during the current year. Its income statement is as follows: Sales $5,654,400 Cost of goods sold 3,618,816 Gross profit $2,035,584 Expenses: Selling expenses $984,000 Administrative expenses 430,000 Total expenses 1,414,000 Income from operations $ 621,584 The division of costs between variable and fixed is as follows: (round to nearest dollar) Variable Fixed Cost of goods sold 70% 30% Selling expenses 20% 80% Administrative expenses 10% 90% Management is planning to...
Hall Industries operates at full capacity. It sold 64,000 units at a price of $45 per...
Hall Industries operates at full capacity. It sold 64,000 units at a price of $45 per unit during the current year. Its profit & loss statement is as follows: Sales                                                                                                   $ 2,880,000 Cost of goods sold                                                                              1,400,000 Gross profit                                                                                       $ 1,480,000 Expenses: Selling expenses $400,000 Administrative expenses 387,500                    787,500 Income from operations                                                                    $ 692,500 The division of costs between variable and fixed is as follows:                                                                                     Variable                    Fixed Cost of goods sold 75%                         25%             Selling expenses                                           60%                         40%             Administrative expenses                                80%                         20% Management is considering a plant expansion program for the following...
Darby Company, operating at full capacity, sold 163,500 units at a price of $66 per unit during the current year. Its income statement is as follows
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 163,500 units at a price of $66 per unit during the current year. Its income statement is as follows Sales     $10,791,000 Cost of goods sold     3,828,000 Gross profit     $6,963,000 Expenses:       Selling expenses $1,914,000     Administrative expenses 1,144,000     Total expenses     3,058,000 Income from operations     $3,905,000 The division of costs between variable...
Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units...
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 Cost of goods sold         (98,000,000) Gross profit         $90,000,000 Expenses:            Selling expenses   $14,000,000         Administrative expenses   17,800,000         Total expenses         (31,800,000) Operating income         $58,200,000 The division of costs between variable and...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 163,500 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 163,500 units at a price of $66 per unit during the current year. Its income statement is as follows Sales $10,791,000 Cost of goods sold 3,828,000 Gross profit $6,963,000 Expenses: Selling expenses $1,914,000 Administrative expenses 1,144,000 Total expenses 3,058,000 Income from operations $3,905,000 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50%...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 97,700 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 97,700 units at a price of $93 per unit during the current year. Its income statement is as follows Sales  $9,086,100Cost of goods sold  3,224,000Gross profit  $5,862,100Expenses:   Selling expenses$1,612,000  Administrative expenses961,000  Total expenses  2,573,000Income from operations  $3,289,100 The division of costs between variable and fixed is as follows:  VariableFixedCost of goods sold60% 40% Selling expenses50% 50% Administrative expenses30% 70%  Management is considering a plant expansion program for the following year that will permit an increase of $744,000 in yearly...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 167,200 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 167,200 units at a price of $111 per unit during the current year. Its income statement is as follows: Sales $18,559,200 Cost of goods sold 6,586,000 Gross profit $11,973,200 Expenses: Selling expenses $3,293,000 Administrative expenses 1,961,000 Total expenses 5,254,000 Income from operations $6,719,200 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50%...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 139,000 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 139,000 units at a price of $72 per unit during the current year. Its income statement is as follows: Sales $10,008,000 Cost of goods sold 3,552,000 Gross profit $6,456,000 Expenses: Selling expenses $1,776,000 Administrative expenses 1,056,000 Total expenses 2,832,000 Income from operations $3,624,000 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50%...
Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units...
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 Cost of goods sold (100,000,000) 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 variable and fixed is as follows: Variable Fixed Cost of goods sold 70% 30% Selling expenses 75% 25% Administrative...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT