Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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 fixed

Explanation / 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