Question

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

	Sales Region
	West				Central			East
Sales	$	312,000			$	795,000		$	698,000
Regional expenses (traceable):
Cost of goods sold		98,000				242,000			318,000
Advertising		102,000				238,000			242,000
Salaries		52,000				56,000			112,000
Utilities		9,500				16,300			13,500
Depreciation		19,000				29,000			28,000
Shipping expense		15,000				28,000			43,000
Total regional expenses		295,500				609,300			756,500
Regional income (loss) before corporate expenses		16,500				185,700			(58,500	)
Corporate expenses:
Advertising (general)		18,000				38,000			37,000
General administrative expense		22,000				22,000			22,000
Total corporate expenses		40,000				60,000			59,000
Net operating income (loss)	$	(23,500	)		$	125,700		$	(117,500	)

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.

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

Solution SEGMENTED INCOME STATEMENT Total Company Central West East Amount Amount Amount Amount Sales Variable expenses $698,000 $1,805,000 100.00 $312,000 $795,000 100.00 100.00 100.00 $658,000 Cost of Goods sold $98,000 31.41 $242,000 $318,000 45.56 36.45 30.44 Shipping expense $86,000 4,76 $15,000 $28,000 $43,000 4.81 3.52 6.16 Total variable expenses Contribution margin Traceable fixed expenses: $270,000 $744,000 $1,061,000 41.22 $113,000 36.22 $361,000 $337,000 33.96 51.72 $199,000 63.78 $525,000 58.78 66.04 48.28 $582,000 $220,000 $39,300 $76,000 $238,000 $56,000 $16,300 $29,000 Advertising 32.24 $102,000 $242,000 $112,000 $13,500 32.69 29.94 34.67 Salaries $52,000 7.04 12.19 16.67 16.05 $9,500 Utilities 2.18 3.04 2.05 1.93 $19,000 $28,000 Depreciation 4.21 6.09 3.65 4.01 Total traceable fixed expenses $182,500 $16,500 $917,300 $339,300 $185,700 $395,500 ($58,500) 56.66 50.82 58.49 42.68 Regional segment margin $143,700 23.36 7.96 5.29 -8.38 Common fixed expenses: Advertising (general) (WN-1) General administrative expense (WN-2) $93,000 5.15 $66,000 3.66 Total common fixed expense $159,000 8.81 ($15,300) Net operating income (loss) -0.85 WN-1: Advertising (general) Total Advertising (general) expense $18,000+ $38,000 + $37,0000 = $93,000 WN-2: General Administrative expense Total General Administrative expense $22,000+ $22,000 $66,000 $22,000