Question

In: Accounting

Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s...

Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below:

Total
Company
Commercial Residential
Sales $ 1,050,000 $ 350,000 $ 700,000
Cost of goods sold 682,500 178,500 504,000
Gross margin 367,500 171,500 196,000
Selling and administrative expenses 320,000 144,000 176,000
Net operating income $ 47,500 $ 27,500 $ 20,000

In preparing these statements, the intern determined that Toxaway’s only variable selling and administrative expense is a 10% sales commission on all sales. The company’s total fixed expenses include $57,000 of common fixed expenses that would continue to be incurred even if the Commercial or Residential segments are discontinued, $90,000 of fixed expenses that would be avoided if the Commericial segment is dropped, and $68,000 of fixed expenses that would be avoided if the Residential segment is dropped.

Required:

1. Redo the intern’s segmented income statement using the contribution format.

2. Compute the companywide break-even point in dollar sales.

3. Compute the break-even point in dollar sales for the Commercial Division and for the Residential Division.

4. Assume the company decided to pay its sales representatives in the Commercial and Residential Divisions a total monthly salary of $17,500 and $35,000, respectively, and to lower its companywide sales commission percentage from 10% to 5%. Calculate the new break-even point in dollar sales for the Commercial Division and the Residential Division.

Solutions

Expert Solution

1. Contribution Margin Income Statement
Taxway Company
Income Statement (Contribution Margin Format)
Commercial Residential Total
Sales $         350,000 $       700,000 $         1,050,000
Less: Variable Cost:
Cost of Goods Sold: $       (178,500) $     (504,000) $          (682,500)
Var. Sell. & Admin. Exp. $         (35,000) $       (70,000) $          (105,000)
      Contribution Margin $       136,500 $     126,000 $          262,500
Less: Traceable Fixed Exp. $          90,000 $        68,000 $            158,000
Segment Margin $          46,500 $        58,000 $            104,500
Less: Common Fixed Expense $                 -   $               -   $              57,000
Net Operating Income $              47,500
3. Commercial & Residential 2.Companywide
CM Ratio = CM ÷ Sales 136,500/350,000 126,000/700,000 262,500/1,05,0000
39% 18% 25%
B.E.P. = (Total Fixed Cost ÷ CMR) $ 90,000 ÷ 0.39 $68,000 ÷ 0.18 215,000 ÷ 0.25
2 &3. Break-Even-Point: $       230,769 $     377,778 $          860,000

4. When Company pays $17,500 and $35,000 fixed monthly salaries and only 5% commission on sales that is

for Commercial $17,500 and Residential $35,000.

New Contribution Margin for Commercial segment = $350,000 - $178,500 -$17,500= $154,000

New Contribution Margin for Residential segment = $700,000 - $504,000 -$35,000= $161,000

New CM Ratio Com. Segment = $154,000 ÷ $350,0000 = 0.44

New CM Ratio Res. Segment = $161,000 ÷ $700,0000 = 0.23

New Total Fixed Cost for Com. Segment = $90,000 + 17,500 =$107,500

New Total Fixed Cost for Res. Segment = $68,000 + 35,000 = $103,000

New B.E.P for Com. Segment = New Total Fixed Cost ÷ CM Ratio = $107,500 ÷ 0.44 = $244,318

New B.E.P for Res. Segment = New Total Fixed Cost ÷ CM Ratio = $103,000 ÷ 0.23 = $447,826


Related Solutions

Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential Sales $ 960,000 $ 320,000 $ 640,000 Cost of goods sold 636,800 169,600 467,200 Gross margin 323,200 150,400...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential Sales $ 750,000 $ 250,000 $ 500,000 Cost of goods sold 500,000 140,000 360,000 Gross margin 250,000 110,000...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential Sales $ 1,050,000 $ 350,000 $ 700,000 Cost of goods sold 682,500 178,500 504,000 Gross margin 367,500 171,500...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below:     Total Company   Commercial   Residential Sales   $   945,000      $   315,000      $   630,000   Cost of goods sold      630,000          ...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential Sales $ 885,000 $ 295,000 $ 590,000 Cost of goods sold 572,300 153,400 418,900 Gross margin 312,700 141,600...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential Sales $ 885,000 $ 295,000 $ 590,000 Cost of goods sold 572,300 153,400 418,900 Gross margin 312,700 141,600...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential Sales $ 900,000 $ 300,000 $ 600,000 Cost of goods sold 579,000 153,000 426,000 Gross margin 321,000 147,000...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential Sales $ 870,000 $ 290,000 $ 580,000 Cost of goods sold 571,300 153,700 417,600 Gross margin 298,700 136,300...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential Sales $ 810,000 $ 270,000 $ 540,000 Cost of goods sold 548,100 153,900 394,200 Gross margin 261,900 116,100...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential Sales $ 990,000 $ 330,000 $ 660,000 Cost of goods sold 663,300 181,500 481,800 Gross margin 326,700 148,500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT