Question

Hard Corporation is a wholesale distributor of office products. It purchases office products from manufacturers and distributes them in the West, Central, and East regions. Each of these regions is about the same size and each has its own manager and sales staff. The company has been experiencing losses for many months. In an effort to improve performance, management has requested that the monthly income statement be segmented by sales region. The company's first effort at preparing a segmented income statement for May is given below. West $313,000 Sales Region Central East $797,000 $701,000 Sales Regional expenses (traceable): Cost of goods sold Advertising Salaries Utilities Depreciation Shipping expense Total regional expenses Regional income (loss) before corporate expenses Corporate expenses: Advertising (general) General administrative expense Total corporate expenses Net operating income (loss) 95,000 107,000 52,000 8,600 23,000 13,000 298,600 242,000 243,000 57,000 15,800 31,000 33,00 621,800 313,000 237,000 105,000 13,600 30,000 44,000 742,600 14,400 175,200 (41,600) 17,000 19,000 36,000 $(21,600) 39,000 19,000 58,000 $117,200 37,000 19,000 56,000 $(97,600) The cost of goods sold and shipping expense are both variable. All other costs are fixed. Required: 3. Prepare a new contribution format segmented income statement for May. (Round percentage answers to 1 decimal place.) Total Company Amount % West Amount Central Amount East Amount % % % Variable expenses: Total variable expenses Traceable fixed expenses: Total traceable fixed expenses Common fixed expenses: Total common fixed expense Net operating income (loss)

Answer 1

	Total Company		Divisions
			West		Central		East
	Amount	%	Amount	%	Amount	%	Amount	%
Sales	$             1,811,000	100.0%	$ 313,000	100.0%	$       797,000	100.0%	$       701,000	100.0%
Variable Expenses:
Cost of Goods sold	$                650,000	35.9%	$    95,000	30.4%	$       242,000	30.4%	$       313,000	44.7%
Shipping Expenses	$                  90,000	5.0%	$    13,000	4.2%	$         33,000	4.1%	$         44,000	6.3%
Total Variable Expenses	$                740,000	40.9%	$ 108,000	34.5%	$       275,000	34.5%	$       357,000	50.9%
Contribution margin	$            1,071,000	59.1%	$ 205,000	65.5%	$       522,000	65.5%	$       344,000	49.1%
Traceable Fixed Expenses
Advertising	$                587,000	32.3%	$ 107,000	34.2%	$       243,000	30.3%	$       237,000	33.8%
Salaries	$                214,000	11.8%	$    52,000	16.6%	$         57,000	7.1%	$       105,000	15.0%
Utilities	$                  38,000	2.1%	$      8,600	2.7%	$         15,800	2.0%	$         13,600	1.9%
Depreciation	$                  84,000	4.6%	$    23,000	7.3%	$         31,000	3.9%	$         30,000	4.3%
Total Traceable Fixed Expenses	$                923,000	51%	$ 190,600	61%	$       346,800	43%	$       385,600	55%
Territorial Segment margin	$                148,000	8.3%	$   14,400	4.6%	$       175,200	22.3%	$       (41,600)	-5.9%
Common Fixed Expenses
Advertising (general)	$                  93,000	5.1%
General adminitrative expenses	$                  57,000	3.1%
Total Common Fixed Expenses	$                150,000	8.3%
Net Operating Income (loss)	$                  (2,000)	-0.1%

Feel free to ask any clarification, if required. Kindly provide feedback by thumbs up, if satisfied. It will be highly appreciated.
Thank you.