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	$	313,000			$	796,000		$	701,000
Regional expenses (traceable):
Cost of goods sold		94,000				238,000			318,000
Advertising		102,000				242,000			241,000
Salaries		57,000				60,000			111,000
Utilities		9,200				16,200			13,700
Depreciation		18,000				35,000			29,000
Shipping expense		14,000				28,000			42,000
Total regional expenses		294,200				619,200			754,700
Regional income (loss) before corporate expenses		18,800				176,800			(53,700	)
Corporate expenses:
Advertising (general)		14,000				38,000			35,000
General administrative expense		22,000				22,000			22,000
Total corporate expenses		36,000				60,000			57,000
Net operating income (loss)	$	(17,200	)		$	116,800		$	(110,700	)

The cost of goods sold and shipping expense are both variable. All other costs are fixed.

Prepare a new contribution format segmented income statement for May. (Round percentage answers to 1 decimal place.)

	Total Company West Central East Amount % Amount % Amount % 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		West		Central		East
			Amount	%	Amount	%	Amount	%	Amount	%
Sales			1,810,000	100.0%	313,000	100.0%	796,000	100.0%	701,000	100.0%
Variable expenses
Cost of goods sold			650,000	35.9%	94,000	30.0%	238,000	29.9%	318,000	45.4%
Shipping expense			84,000	4.6%	14,000	4.5%	28,000	3.5%	42,000	6.0%
total variable expenses			734,000	40.6%	108,000	34.5%	266,000	33.4%	360,000	51.4%
Contribution margin			1,076,000	59.4%	205,000	65.5%	530,000	66.6%	341,000	48.6%
Traceable fixed expenses
Salaries			228,000	12.6%	57,000	18.2%	60,000	7.5%	111,000	15.8%
Utilities			39,100	2.2%	9,200	2.9%	16,200	2.0%	13,700	2.0%
Advertising(traceable)			585,000	32.3%	102,000	32.6%	242,000	30.4%	241,000	34.4%
Depreciation			82,000	4.5%	18,000	5.8%	35,000	4.4%	29,000	4.1%
Total Traceable fixed expenses			934,100	51.6%	186,200	59.5%	353,200	44.4%	394,700	56.3%
Regional segment margin			141,900	7.8%	18,800	6.0%	176,800	22.2%	-53,700	-7.7%
Common fixed expenses
Advertising(general)			87000	4.8%
General Administrative expense			66000	3.6%
total common fixed expense			153000	8.5%
Net operating income(loss)			-11,100	-0.6%