Millard Corporation is a wholesale distributor of office products. It purchases
ID: 2329549 • Letter: M
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 Central West East Sales Regional expenses (traceable): 311,00 802,000 696,000 Cost of goods sold Advertising Salaries Utilities Depreciation Shipping expense 95,000 106,000 52,000 8,600 19,000 15,000 295,600 244,000e 243,00e 57,000 15,600 32,000 34,000 625,600 315,000 242,000 111,000 14,200 26,000 39,000 747, 200 Total regional expenses 15,400 (51,200) Regional income (loss) before corporate expenses Corporate expenses: 176,400 39,000 57,000 Advertising (general) General administrative expense Total corporate expense:s Net operating income (loss) 33,000 18,00018,000 51,000 $(15,600) 119,400 (102,200) 13,000 18,000 31,000 The cost of goods sold and shipping expense are both variable. All other costs are fixedExplanation / Answer
Total Company West Central East Amount % Amount % Amount % Amount % Sale 1,809,000 100.00% 311,000 100.00% 802,000 100.00% 696,000 100.00% Variable expense Cost of goods sold 654,000 36.15% 95,000 30.55% 244,000 30.42% 315,000 45.26% Shipping expense 88,000 4.86% 15,000 4.82% 34,000 4.24% 39,000 5.60% Total variable expense 742,000 41.02% 110,000 35.37% 278,000 34.66% 354,000 50.86% Contribution margin 1,067,000 58.98% 201,000 64.63% 524,000 65.34% 342,000 49.14% Traceble fixed expense Advertising 591,000 32.67% 106,000 34.08% 243,000 30.30% 242,000 34.77% Salaries 220,000 12.16% 52,000 16.72% 57,000 7.11% 111,000 15.95% Utilities 38,400 2.12% 8,600 2.77% 15,600 1.95% 14,200 2.04% Depreciation 77,000 4.26% 19,000 6.11% 32,000 3.99% 26,000 3.74% Total Traceble fixed expense 926,400 51.21% 185,600 59.68% 347,600 43.34% 393,200 56.49% Regional Segment Margin 140,600 7.77% 15,400 4.95% 176,400 22.00% (51,200) -7.36% Common Fixed expense Advertising General 85,000 General Administrative expense 54,000 Total Common fixed expense 139,000 Net Operating income/loss 1,600