1. Break Even of Company in $ Sales
Fixed Cost / Contribution Margin %
Total Fixed cost = (63000 + 126000) = 189000
189000 / 50% = $ 378000/-
Break Even of Chicago
78000 / 70% = $111430
Break even of Minneapolis
48000 / 40% = $ 120000 /-
Total Break even of Offices = $ 231430
The company break even is greater than the sum of Break even sales of the offices. This is due to the untraceable fixed expenses in the company
2.
Particulars | Company | % | Chicago | % | Minneapolis | % |
Sales | 5,25,000 | 100% | 1,50,000 | 100% | 3,75,000 | 100% |
Variable expenses | 2,70,000 | 51% | 45,000 | 30% | 2,25,000 | 60% |
Conribution margin | 2,55,000 | 49% | 1,05,000 | 70% | 1,50,000 | 40% |
Traceable Fixed Expenses | 1,26,000 | 24% | 78,000 | 52% | 48,000 | 13% |
Office segment margin | 1,29,000 | 25% | 27,000 | 18% | 1,02,000 | 27% |
Common Fixed expenses not traceable to offices | 63,000 | 12% | ||||
Net operating income | 66,000 | 13% |
3.
Particulars | Company | % | Chicago | % | Minneapolis | % |
Sales | 5,00,000 | 100% | 2,00,000 | 100% | 3,00,000 | 100% |
Variable expenses | 2,40,000 | 48% | 60,000 | 30% | 1,80,000 | 60% |
Conribution margin | 2,60,000 | 52% | 1,40,000 | 70% | 1,20,000 | 40% |
Traceable Fixed Expenses | 1,26,000 | 25% | 78,000 | 39% | 48,000 | 16% |
Office segment margin | 1,34,000 | 27% | 62,000 | 31% | 72,000 | 24% |
Common Fixed expenses not traceable to offices | 63,000 | 13% | ||||
Net operating income | 71,000 | 14% |
The reason for the change in the office segment margin ratio is due to the unchanged fixed expense in the chicago office though the corresponding sale have increased for the same.
2. Prepare an incohne s 6-16 Working with a Segmented Income Statement; Break-Even Statement; Break-Even Analysis...
Exercise 7-16 Working with a Segmented Income Statement; Break-Even Analysis (LO7-4, LO7-5) [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...
Required information Exercise 4-16 (Algo) Working with a Segmented Income Statement; Break-Even Analysis [LO4-4, LO4-5] [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: Office...
Exercise 6-16 Working with a Segmented Income Statement; Break-Even Analysis (L06-4, LO6-5) 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. Office Sales Variable expenses...
chapter 7 h 1 Required information Exercise 7-16 Working with a Segmented Income Statement; Break-Even Analysis [LO7-4, LO7-5] [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...
Required information Exercise 6-16 Working with a Segmented Income Statement; Break-Even Analysis (L06-4, LO6-5] [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...
Required information Exercise 7-16 Working with a Segmented Income Statement: Break-Even Analysis (L07-4, L07-5) 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...
Exercise 6-16 Working with a Segmented Income Statement; Break-Even Analysis [LO6-4, LO6-5] [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: Office Total Company...
Exercise 6-16 Working with a Segmented Income Statement; Break-Even Analysis [LO6-4, LO6-5] [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: Office Total Company Chicago...
A) B) Required information Exercise 6-16 Working with a Segmented Income Statement; Break-Even Analysis (L06-4, LO6-5) [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:...
Required information Exercise 7-16 Working with a Segmented Income Statement; Break-Even Analysis (LO7-4, LO7-5) [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...