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	$	312,000			$	804,000		$	697,000
Regional expenses (traceable):
Cost of goods sold		99,000				242,000			313,000
Advertising		102,000				242,000			237,000
Salaries		57,000				55,000			115,000
Utilities		8,900				16,100			13,600
Depreciation		22,000				30,000			30,000
Shipping expense		16,000				26,000			45,000
Total regional expenses		304,900				611,100			753,600
Regional income (loss) before corporate expenses		7,100				192,900			(56,600	)
Corporate expenses:
Advertising (general)		17,000				41,000			33,000
General administrative expense		18,000				18,000			18,000
Total corporate expenses		35,000				59,000			51,000
Net operating income (loss)	$	(27,900	)		$	133,900		$	(107,600	)

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

Required:

3. Prepare a new contribution format segmented income statement for May. (Round percentage answers to 1 decimal place.) Percent in terms of total sales

	Total Company West Central East Amount % Amount % Amount % Amount % Variable expenses: Cost of goods sold Shipping expense Total variable expenses 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 Traceable fixed expenses: Total traceable fixed expenses 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 $0 0.0 $0 0.0 $0 0.0 Common fixed expenses: Total common fixed expense 0 0.0 Net operating income (loss) $0 0.0

Answer 1