Required Information [The following information applies to the questions displayed below.] 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: Total Company $ 975, eee 180.8% 526,5ee 54.8% 448,500 46.8% 218,488 22.4% 230, 180 23.6% 156, Bee 16.0% $ 74,100 7.6% Sales Variable expenses Contribution margin Traceable fixed expenses Office segment margin Common fixed expenses not traceable to offices Net operating income Office Chicago Minneapolis $ 195,800 100% $ 780, eee 100% 58,5ee 30% 468,888 60% 136, See 70% 312, eee 40% 101,400 52% 117, eee $ 35,1ee 18% $ 195, Bee 25% 15% Required: 1-a. Compute the companywide break-even point in dollar sales. 1-6. Compute the break-even point for the Chicago office and for the Minneapolis office. 1-c. Is the companywide break-even point greater than, less than or equal to the sum of the Chicago and Minneapolis break-even points? Complete this question by entering your answers in the tabs below. Reg 1A Reg 1B Reg 10 Compute the companywide break-even point in dollar sales. (Round "CM ratio" to 2 decimal places and final answers to the nearest whole dollar amount.) Break-even point in dollar sales Variable expenses Contribution margin Traceable fixed expenses Office segment margin Common fixed expenses not traceable to offices Net operating income 526,583 448,5ee 218,480 230, 100 156, Bee 74,100 54.6 46.ex 22.4% 23.6% 16.0% 7.6% 58, Sea 136, see 101, 4ee 35,180 70% 52% 18% 458,888 312, Bee 117, see $ 195,800 48% 15% 25% $ $ Required: 1-a. Compute the companywide break-even point in dollar sales. 1-5. Compute the break-even point for the Chicago office and for the Minneapolis office. 1-c. Is the companywide break-even point greater than, less than or equal to the sum of the Chicago and Minneapolis break-even points? Complete this question by entering your answers in the tabs below. Req 1A Reg 1B Reg 10 Compute the break-even point for the Chicago office and for the Minneapolis office. (Round "CM ratio" to 2 decimal places and final answers to the nearest whole dollar amount.) Break-even Point Chicago office Minneapolis office ! Required Information [The following information applies to the questions displayed below.] 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: Sales Variable expenses Contribution margin Traceable fixed expenses Office segment margin Common fixed expenses not traceable to offices Net operating income Total Company $ 975, eee 180.0% 526,500 54.8% 448,500 46.8% 218,480 22.4% 230, 180 23.6% 156,800 16.8% $ 74,180 7.6% Office Chicago Minneapolis $ 195,800 100% $ 780,eee 100 58, See 30% 468, eee 60% 136,500 70% 312,000 40% 101,400 52% 117, eee 15% $ 35,180 18% $ 195, eee 25% 2 By how much would the company's net operating income increase if Minneapolis increased its sales by $97.500 per year? Assume no change in cost behavior patterns. Net operating income increase 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: Sales Variable expenses Contribution margin Traceable fixed expenses Office segment margin Common fixed expenses not traceable to offices Net operating income Total Company $ 975,000 180.0% 526,5ee 54.2% 448,500 46.0% 218, 4ee 22.4% 230, 100 23.6% 156,800 16.9 $ 74, 120 7.6% Office Chicago Minneapolis $ 195, eee 100% $ 780,eee 100% 58,500 30% 468, eee 60% 136,5ee 70% 312, Bee 40% 101,400 52% 117, Bea 15% 35, 18e 18% $ 195, eee 25% $ 3. Assume that sales in Chicago increase by $65.000 next year and that sales in Minneapolis remain unchanged. Assume no chang in fixed costs. a. Prepare a new segmented income statement for the company. (Round your percentage answers to 1 decimal place (1.e. 0.1234 should be entered as 12.3).) Segments Chicago Minneapolis Total Company Amount % Amount % Amount % Administrative expenses Advertising Beginning merchandise inventory Commissions Common fixed expenses not traceable to segments 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: Sales Variable expenses Contribution margin Traceable fixed expenses Office segment margin Common fixed expenses not traceable to offices Net operating income Total Company $ 975, eee 18e.es 526, See 54.0% 448,5ee 46.2% 218,400 22.4% 230, 1ee 23.6% 156,000 16.8% $ 74,1ee 7.6% Office Chicago Minneapolis $ 195, eee 100% $ 780,eee 100% 58,500 3e% 468,eee 6ex 136,500 70% 312,eee 40% 101,400 52% 117,eee 15% $ 35,180 18% $ 195, eee 25% 3. Assume that sales in Chicago increase by $65.000 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 percentage answers to 1 decimal place (1.e. 0.1234 should be entered as 12.3).) Segments Total Company Chicago Minneapolis Amount % Amount % Amount Common fixed expenses not traceable to segments Cost of goods sold Depreciation Direct labor Direct materials 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: Sales Variable expenses Contribution margin Traceable fixed expenses office segment margin Common fixed expenses not traceable to offices Net operating income Total Company $ 975, eee 182.e% 526,500 54.8% 448, 5ea 46. ex 218,488 22.4% 230, 180 23.6% 156, ee9 16.0% $ 74,100 7.6% Office Chicago Minneapolis $ 195,00 100% $ 780, eee 100% 58, see 30% 468, Bee 60% 136,5ee 312, see 40% 181,488 52% 117, Bee 15% $ 35, 100 18% $ 195,880 25% 3. Assume that sales in Chicago increase by $65,000 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 percentage answers to 1 decimal place (1.e. 0.1234 should be entered as 12.3).) Total Company Chicago Segments Minneapolis Amount % Amount Amount % Ending merchandise inventory Fixed manufacturing overhead Indirect labor Indirect materials Purchases 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: Sales Variable expenses Contribution margin Traceable fixed expenses Office segment margin Common fixed expenses not traceable to offices Net operating income Total Company $ 975, eee 100.0% 526,5ee 54.2% 448,5ee 46.ex 218, 4ee 22.4% 230, 1ee 23.6% 156, Bee 16.0% $ 74,100 7.6% Office Chicago Minneapolis $ 195, Bee 100% $ 780, eee 100% 58,500 30% 468, eee 60% 136,5ee 70% 312, Bee 40% 101,400 52% 117, see 15% $ 35,1ee 18% $ 195, eee 25% 3. Assume that sales in Chicago increase by $65.000 next year and that sales in Minneapolis remain unchanged. Assume no char in fixed costs. a. Prepare a new segmented income statement for the company. (Round your percentage answers to 1 decimal place (I.e. 0.1234 should be entered as 12.3).) Segments Chicago Minneapolis Total Company Amount % Amount % Amount % Purchases Sales Traceable fixed expenses Variable expenses Variable manufacturing overhead 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: Sales Variable expenses Contribution margin Traceable fixed expenses Office segment margin Common fixed expenses not traceable to offices Net operating income Total Company $ 975, eee 100.0% 526, 5ee 54.2% 448, 5ee 46.2% 218,400 22.4% 230, 180 23.6% 156, Bea 16.0% $ 74,100 7.6% Office Chicago Minneapolis $ 195, eee 100% $ 780,800 100% 58, 509 30% 468, see 60% 136,5ee 70% 312,800 40% 101,400 52% 117,000 15% $ 35,180 18% $ 195, Bee 25% 3. Assume that sales in Chicago increase by $65.000 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 percentage answers to 1 decimal place (I.e. 0.1234 should be entered as 12.3).) Segments Chicago Minneapolis Total Company Amount % Amount % Amount % 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: Sales Variable expenses Contribution margin Traceable fixed expenses Office segment margin Common fixed expenses not traceable to offices Net operating income Total Company $ 975, eee 100.0% 526, 5ee 54.2% 448, 5ee 46.2% 218,400 22.4% 230, 180 23.6% 156, Bea 16.0% $ 74,100 7.6% Office Chicago Minneapolis $ 195, eee 100% $ 780,800 100% 58, 509 30% 468, see 60% 136,5ee 70% 312,800 40% 101,400 52% 117,000 15% $ 35,180 18% $ 195, Bee 25% 3. Assume that sales in Chicago increase by $65.000 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 percentage answers to 1 decimal place (I.e. 0.1234 should be entered as 12.3).) Segments Chicago Minneapolis Total Company Amount % Amount % Amount %