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 $ 803,000 $ 310,000 $ 701,000 Sales Regional expenses (traceable): Cost of goods sold Advertising 95,000 106,000 51,000 240,000 237,000 59,000 16,200 310,000 241,000 106,000 14,300 26,000 40,000 Salaries Utilities 8,900 21,000 18,000 Depreciation Shipping expense Total regional expenses Regional income (loss) before corporate expenses Corporate expenses: Advertising (general) General administrative expense 32,000 26,000 299,900 610,200 737,300 10,100 192,800 (36,300) 16,000 42,000 22,000 35,000 22,000 22,000 38,000 $ (27,900) 57,000 $ (93,300) Total corporate expenses 64,000 $ 128,800 Net operating income (loss) The cost of goods sold and shipping expense are both variable. All other costs are fixed.

Answer 1

Particulars	Total Company		West		Central		East
	Amount	%	Amount	%	Amount	%	Amount	%
Sales	18,14,000	100%	3,10,000	17%	8,03,000	44%	7,01,000	39%
Variable Expenses:
Cost of Goods Sold	6,45,000	100%	95,000	15%	2,40,000	37%	3,10,000	48%
Shipping Expense	84,000	100%	18,000	21%	26,000	31%	40,000	48%
Total Variable Expenses	7,29,000	100%	1,13,000	16%	2,66,000	36%	3,50,000	48%
Traceable Fixed Expenses:
Advertising	5,84,000	100%	1,06,000	18%	2,37,000	41%	2,41,000	41%
Salaries	2,16,000	100%	51,000	24%	59,000	27%	1,06,000	49%
Utilities	39,400	100%	8,900	23%	16,200	41%	14,300	36%
Depreciation	79,000	100%	21,000	27%	32,000	41%	26,000	33%
Total Traceable Fixed Expenses	9,18,400	100%	1,86,900	20%	3,44,200	37%	3,87,300	42%
Common Fixed Expenses
Advertising(General)	93,000
General Administrative Expenses	66,000
Total Common Fixed Expense	1,59,000
Net Operating Income	7,600