Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...

Transcribed Image Text:

Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices-one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company's most recent year is given: office Total Company Sales $ 480,000 100% Chicago 100% $ 165,000 Minneapolis $ 315,000 100% Variable expenses 238,500 50% 49,500 30% 189,000 60% Contribution margin 241,500 50% 115,500 70% 126,000 40% Traceable fixed expenses 136,200 Office segment margin Common fixed expenses not traceable to offices Net operating income. 105,300 67,200 288 228 148 85,800 528 50,400 16% $ 29,700 188 $ 75,600 24 $ 38,100 88 3. Assume that sales in Chicago increase by $57,500 next year and that sales in Minneapolis remain unchanged. Assume no change in fixed costs. a. Prepare a new segmented income statement for the company. (Round your intermediate calculations and percentage answers to 1 decimal place (i.e. 0.1234 should be entered as 12.3 and other answers to the nearest whole dollar.)) Segments Total Company Chicago Minneapolis Amount % Amount % Amount % Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices-one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company's most recent year is given: office Total Company Sales $ 480,000 100% Chicago 100% $ 165,000 Minneapolis $ 315,000 100% Variable expenses 238,500 50% 49,500 30% 189,000 60% Contribution margin 241,500 50% 115,500 70% 126,000 40% Traceable fixed expenses 136,200 Office segment margin Common fixed expenses not traceable to offices Net operating income. 105,300 67,200 288 228 148 85,800 528 50,400 16% $ 29,700 188 $ 75,600 24 $ 38,100 88 3. Assume that sales in Chicago increase by $57,500 next year and that sales in Minneapolis remain unchanged. Assume no change in fixed costs. a. Prepare a new segmented income statement for the company. (Round your intermediate calculations and percentage answers to 1 decimal place (i.e. 0.1234 should be entered as 12.3 and other answers to the nearest whole dollar.)) Segments Total Company Chicago Minneapolis Amount % Amount % Amount %