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.

The cost of goods sold and shipping expense are both variable. All other costs are fixed.
Required:
1. List any weaknesses that you see in the company’s segmented income statement given above.
2. Explain the basis that is apparently being used to allocate the corporate expenses to the regions. Do you agree with these allocations? Explain.
3. Prepare a new contribution format segmented income statement for May. Show a Total column as well as data for each region. In addition, for the company as a whole and for each sales region, show each item on the segmented income statement as a percent of sales.
4. Analyze the statement that you prepared in part (3) above. What insights do those statements reveal that you would bring to management’s attention?

Transcribed Image Text:

West Sales Region Central East Sales .... $450,000 $800,000 $750,000 Regional expenses (traceable): Cost of goods sold. 162,900 280,000 376,500 Advertising 108,000 200,000 210,000 Salaries 90,000 88,000 135,000 Utilities 13,500 12,000 15,000 Depreciation Shipping expense. Total regional expenses 27,000 28,000 30,000 17,100 32,000 28,500 418,500 640,000 795,000 Regional Income (loss) before corporate expenses 31,500 160,000 (45,000) Corporate expenses: Advertising (general) General administrative expense Total corporate expenses Net operating Income (loss) 18,000 32,000 30,000 50,000 50,000 50,000 68,000 82,000 80,000 $ (36,500) $ 78,000 $(125,000)