Question

In: Accounting

Shown as follows is a segmented income statement for Drexel-Hall during the current month. Profit Centers...

Shown as follows is a segmented income statement for Drexel-Hall during the current month.

Profit Centers

Drexel-Hall

Store 1

Store 2

Store 3

Dollars % Dollars % Dollars % Dollars %
Sales $ 1,800,000 100 % $ 600,000 100 % $ 600,000 100 % $ 600,000 100 %
Variable costs 1,080,000 60 372,000 62 378,000 63 330,000 55
Contribution margin $ 720,000 40 % $ 228,000 38 % $ 222,000 37 % $ 270,000 45 %
Traceable fixed costs: controllable 432,000 24 120,000 20 102,000 17 210,000 35
Performance margin $ 288,000 16 % $ 108,000 18 % $ 120,000 20 % $ 60,000 10 %
Traceable fixed costs: committed 180,000 10 48,000 8 66,000 11 66,000 11
Store responsibility margin $ 108,000 6 % $ 60,000 10 % $ 54,000 9 % $ (6,000 ) (1 ) %
Common fixed costs 36,000 2
Income from operations $ 72,000 4 %

All stores are similar in size, carry similar products, and operate in similar neighborhoods. Store 1 was established first and was built at a lower cost than were Stores 2 and 3. This lower cost results in less depreciation expense for Store 1. Store 2 follows a policy of minimizing both costs and sales prices. Store 3 follows a policy of providing extensive customer service and charges slightly higher prices than the other two stores.

Top management of Drexel-Hall is considering closing Store 3. The three stores are close enough together that management estimates closing Store 3 would cause sales at Store 1 to increase by $84,000, and sales at Store 2 to increase by $150,000. Closing Store 3 is not expected to cause any change in common fixed costs.


Compute the increase or decrease that closing Store 3 should cause in:

a. Total monthly sales for Drexel-Hall stores.

b. The monthly responsibility margin of Stores 1 and 2.

c. The company's monthly income from operations.

Solutions

Expert Solution

Drexel-Hall Store 1 Store 2 Store 3
Dollars % Dollars % Dollars % Dollars %
Sales $    14,34,000 100 $   6,84,000 100 $ 7,50,000 100 0 0
Variable costs $      8,96,580 63 $   4,24,080 62 $ 4,72,500 63 0 0
Contribution margin $      5,37,420 37 $   2,59,920 38 $ 2,77,500 37 0 0
Traceable fixed costs: controllable $      2,22,000 15 $   1,20,000 18 $ 1,02,000 14 0 0
Performance margin $      3,15,420 22 $   1,39,920 20 $ 1,75,500 23 0 0
Traceable fixed costs: committed $      1,14,000 8 $       48,000 7 $      66,000 9 0 0
Store responsibility margin $      2,01,420 14 $       91,920 13 $ 1,09,500 15 0 0
Common fixed costs $         36,000 3
Income from operations $      1,65,420 12
ANSWERS:
Total monthly sales $    14,34,000
Monthly responsibility $       91,920 $ 1,09,500
Company's monthly income from operations $      1,65,420

REVISED SOLUTION:

Drexel-Hall Store 1 Store 2 Store 3
Dollars % Dollars % Dollars % Dollars %
Sales $     14,34,000 100 $ 6,84,000 100 $ 7,50,000 100 0 0
Variable costs $        8,96,580 63 $ 4,24,080 62 $ 4,72,500 63 0 0
Contribution margin $        5,37,420 37 $ 2,59,920 38 $ 2,77,500 37 0 0
Traceable fixed costs: controllable $        2,22,000 15 $ 1,20,000 18 $ 1,02,000 14 0 0
Performance margin $        3,15,420 22 $ 1,39,920 20 $ 1,75,500 23 0 0
Traceable fixed costs: committed $        1,80,000 13 $     48,000 7 $      66,000 9 66,000 0
Store responsibility margin $        1,35,420 9 $     91,920 13 $ 1,09,500 15 0 0
Common fixed costs $           36,000 3
Income from operations $           99,420 7
ANSWERS:
a) Total monthly sales $     14,34,000
b) Monthly responsibility margin $     91,920 $ 1,09,500
c) Company's monthly income from operations $           99,420

Related Solutions

Shown as follows is a segmented income statement for Drexel-Hall during the current month. Profit Centers...
Shown as follows is a segmented income statement for Drexel-Hall during the current month. Profit Centers Drexel-Hall Store 1 Store 2 Store 3 Dollars % Dollars % Dollars % Dollars % Sales $ 1,800,000 100 % $ 600,000 100 % $ 600,000 100 % $ 600,000 100 % Variable costs 1,080,000 60 372,000 62 378,000 63 330,000 55 Contribution margin $ 720,000 40 % $ 228,000 38 % $ 222,000 37 % $ 270,000 45 % Traceable fixed costs: controllable...
the segmented income statement for XYZ Company for the year ended December 31, 2016, follows: XYZ...
the segmented income statement for XYZ Company for the year ended December 31, 2016, follows: XYZ COMPANY Segmented Income Statement For the Year Ended December 31, 2016 Total Company Product A Product B Product C Sales $ 592,000 $ 297,000 $ 118,000 $ 177,000 Variable expenses 273,000 154,000 49,000 70,000 Contribution margin $ 319,000 $ 143,000 $ 69,000 $ 107,000 Fixed expenses 283,000 165,000 47,000 71,000 Operating income $ 36,000 $ (22,000 ) $ 22,000 $ 36,000 The company is...
The segmented income statement for XYZ Company for the year ended December 31, 2016, follows: XYZ...
The segmented income statement for XYZ Company for the year ended December 31, 2016, follows: XYZ COMPANY Segmented Income Statement For the Year Ended December 31, 2016 Total Company Product A Product B Product C Sales $ 610,000 $ 305,000   $ 118,000 $ 187,000 Vari. expenses 273,000 146,000 53,000 74,000 Cont. margin $ 337,000 $ 159,000 $ 65,000 $ 113,000 Fixed expenses 283,000 164,000 49,000 70,000 Oper. income $ 54,000 $ (5,000 ) $ 16,000 $ 43,000 The company is...
Structuring a Keep-or-Drop Product Line Problem Shown below is a segmented income statement for Hickory Company's...
Structuring a Keep-or-Drop Product Line Problem Shown below is a segmented income statement for Hickory Company's three wooden flooring product lines: Strip Plank Parquet Total Sales revenue $400,000 $200,000 $300,000 $900,000 Less: Variable expenses 225,000 120,000 250,000 595,000 Contribution margin $175,000 $ 80,000 $ 50,000 $305,000 Less direct fixed expenses:    Machine rent (5,000) (20,000) (50,000) (75,000)    Supervision (15,000) (10,000) (20,000) (45,000)    Depreciation (35,000) (10,000) (25,000) (70,000) Segment margin $120,000 $ 40,000 $ (45,000) $115,000 Hickory's management is deciding whether to...
Structuring a Keep-or-Drop Product Line Problem with Complementary Effects Shown below is a segmented income statement...
Structuring a Keep-or-Drop Product Line Problem with Complementary Effects Shown below is a segmented income statement for Hickory Company's three wooden flooring product lines: Strip Plank Parquet Total Sales revenue $400,000 $200,000 $300,000 $900,000 Less: Variable expenses 225,000 120,000 250,000 595,000 Contribution margin $175,000 $ 80,000 $ 50,000 $305,000 Less direct fixed expenses:    Machine rent (5,000) (20,000) (30,000) (55,000)    Supervision (15,000) (10,000) (5,000) (30,000)    Depreciation (35,000) (10,000) (25,000) (70,000) Segment margin $120,000 $ 40,000 $ (10,000) $150,000 Hickory's management is...
Structuring a Keep-or-Drop Product Line Problem with Complementary Effects Shown below is a segmented income statement...
Structuring a Keep-or-Drop Product Line Problem with Complementary Effects Shown below is a segmented income statement for Hickory Company's three wooden flooring product lines: Strip Plank Parquet Total Sales revenue $400,000 $200,000 $300,000 $900,000 Less: Variable expenses 225,000 120,000 250,000 595,000 Contribution margin $175,000 $ 80,000 $ 50,000 $305,000 Less direct fixed expenses: Machine rent (5,000) (20,000) (30,000) (55,000) Supervision (15,000) (10,000) (5,000) (30,000) Depreciation (35,000) (10,000) (25,000) (70,000) Segment margin $120,000 $ 40,000 $ (10,000) $150,000 Hickory's management is...
Structuring a Keep-or-Drop Product Line Problem with Complementary Effects Shown below is a segmented income statement...
Structuring a Keep-or-Drop Product Line Problem with Complementary Effects Shown below is a segmented income statement for Hickory Company's three wooden flooring product lines: Strip Plank Parquet Total Sales revenue $400,000 $200,000 $300,000 $900,000 Less: Variable expenses 225,000 120,000 250,000 595,000 Contribution margin $175,000 $ 80,000 $ 50,000 $305,000 Less direct fixed expenses:    Machine rent (5,000) (20,000) (30,000) (55,000)    Supervision (15,000) (10,000) (5,000) (30,000)    Depreciation (35,000) (10,000) (25,000) (70,000) Segment margin $120,000 $ 40,000 $ (10,000) $150,000 Hickory's management is...
Shown as follows are responsibility income statements for Butterfield, Inc., for the month of March. Investment...
Shown as follows are responsibility income statements for Butterfield, Inc., for the month of March. Investment Centers Butterfield, Inc Division 1 Division 2 Dollars % Dollars % Dollars % Sales $ 470,000 100.00 % $ 290,000 100 % $ 180,000 100 % Variable costs 228,000 48.51 174,000 60 54,000 30 Contribution margin $ 242,000 51.49 % $ 116,000 40 % $ 126,000 70 % Fixed costs traceable to divisions 147,300 31.34 60,900 21 86,400 48 Division responsibility margin $ 94,700...
O'Neill, Incorporated's segmented income statement for the most recent month is given below. Total Company Store...
O'Neill, Incorporated's segmented income statement for the most recent month is given below. Total Company Store A Store B Sales $407,000 $133,000 $274,000 Variable expenses 264,230 97,090 167,140 Contribution margin 142,770 35,910 106,860 Traceable fixed expenses 89,800 31,600 58,200 Segment margin 52,970 $4,310 $48,660 Common fixed expenses 28,350 Net operating income $24,620 For each of the following questions, refer back to the above original data. A proposal has been made that will lower variable expenses in Store A to 62%...
1) The summary of balance sheet and income statement of Manok Corporation are shown as follows:...
1) The summary of balance sheet and income statement of Manok Corporation are shown as follows: Manok Corporation Table 1: Income statement and Balance Sheet Balance Sheet Income Statement Asset: Cash RM150,000 Account Receivables 450,000 Inventory 600,000 Net-non current asset 1,800,000 Liabilities and Equities: Account payable 150,000 Notes payable 150,000 Non-current liabilities 1,200,000 Equities 1,500,000 Sales (All credit) RM6,000,000 Cost of good sold 3,000,000 Operating expenses 750,000 Interest expenses 750,000 Tax 420,000 Net Profit 1,080,000 Calculate the financial ratios for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT