Question

In: Accounting

Exercise 6-16 Working with a Segmented Income Statement; Break-Even Analysis [LO6-4, LO6-5] [The following information applies...

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 Minneapolis
Sales $ 975,000 100.0 % $ 195,000 100 % $ 780,000 100 %
Variable expenses 526,500 54.0 % 58,500 30 % 468,000 60 %
Contribution margin 448,500 46.0 % 136,500 70 % 312,000 40 %
Traceable fixed expenses 218,400 22.4 % 101,400 52 % 117,000 15 %
Office segment margin 230,100 23.6 % $ 35,100 18 % $ 195,000 25 %
Common fixed expenses not traceable to offices 156,000 16.0 %
Net operating income $ 74,100 7.6 %

Exercise 6-16 Part 1

Questions to answer: (Round "CM ratio" to 2 decimal places and final answers to the nearest whole dollar amount.)

1-a. Compute the company wide break-even point in dollar sales.

1-b. 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?

Solutions

Expert Solution

ANSWER

1-a

Company wide Break even point

= Total Fixed cost / Overall contribution margin ratio

=(218,400+156,000) / (526,500/975,000)

=374,400/54%
=$202,176

Company wide Break even point =$202,176

____________________________________________

1-b

Break even point for Chicago office

= Traceable Fixed cost of segment / Contribution margin ratio of segment

=101,400/ 70%

=$70,980

Break even point for Chicago office =$70,980

Break even point for Minneapolis office

= Traceable Fixed cost of segment / Contribution margin ratio of segment

=117,000/ 40%

=$46,800

Break even point for Minneapolis office =$46,800

______________________________________________

1-c

company wide break-even point greater than, sum of the Chicago and Minneapolis break-even points

company wide break-even point =$202,176

sum of the Chicago and Minneapolis break-even points =(70,980+46,800)=$117,780

So we can say that, company wide break-even point greater than, sum of the Chicago and Minneapolis break-even points

---------------------------------------------------------------------

DEAR STUDENT,
If you have any query or any Explanation please ask me in the comment box, i am here to helps you.please give me positive rating.

*****************THANK YOU**************


Related Solutions

Exercise 6-16 Working with a Segmented Income Statement; Break-Even Analysis [LO6-4, LO6-5] [The following information applies...
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 7-16 Working with a Segmented Income Statement; Break-Even Analysis [LO7-4, LO7-5] [The following information applies...
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: Office Total Company...
Exercise 7-16 Working with a Segmented Income Statement; Break-Even Analysis [LO7-4, LO7-5] [The following information applies...
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: Office Total Company...
Required information Exercise 7-16 Working with a Segmented Income Statement; Break-Even Analysis [LO7-4, LO7-5] [The following...
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: Office...
Exercise 6-17 Working with a Segmented Income Statement [LO6-4] Raner, Harris & Chan is a consulting...
Exercise 6-17 Working with a Segmented Income Statement [LO6-4] 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: Assume that Minneapolis’ sales by major market are: Market Minneapolis Medical Dental Sales $ 870,000 100...
Exercise 6-18 Break-Even and Target Profit Analysis; Margin of Safety; CM Ratio [LO6-1, LO6-3, LO6-5, LO6-6,...
Exercise 6-18 Break-Even and Target Profit Analysis; Margin of Safety; CM Ratio [LO6-1, LO6-3, LO6-5, LO6-6, LO6-7] Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 450,000 $ 30 Variable expenses 180,000 12 Contribution margin 270,000 $ 18 Fixed expenses 216,000 Net operating income $ 54,000 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the...
Problem 6-25 Changes in Fixed and Variable Costs; Break-Even and Target Profit Analysis [LO6-4, LO6-5, LO6-6]...
Problem 6-25 Changes in Fixed and Variable Costs; Break-Even and Target Profit Analysis [LO6-4, LO6-5, LO6-6] Neptune Company produces toys and other items for use in beach and resort areas. A small, inflatable toy has come onto the market that the company is anxious to produce and sell. The new toy will sell for $2.60 per unit. Enough capacity exists in the company’s plant to produce 30,300 units of the toy each month. Variable expenses to manufacture and sell one...
Problem 6-25 Changes in Fixed and Variable Costs; Break-Even and Target Profit Analysis [LO6-4, LO6-5, LO6-6]...
Problem 6-25 Changes in Fixed and Variable Costs; Break-Even and Target Profit Analysis [LO6-4, LO6-5, LO6-6] Neptune Company produces toys and other items for use in beach and resort areas. A small, inflatable toy has come onto the market that the company is anxious to produce and sell. The new toy will sell for $2.90 per unit. Enough capacity exists in the company’s plant to produce 30,500 units of the toy each month. Variable expenses to manufacture and sell one...
Exercise 6-7 Segmented Income Statement [LO6-4] Shannon Company segments its income statement into its North and...
Exercise 6-7 Segmented Income Statement [LO6-4] Shannon Company segments its income statement into its North and South Divisions. The company’s overall sales, contribution margin ratio, and net operating income are $700,000, 50%, and $56,000, respectively. The North Division’s contribution margin and contribution margin ratio are $217,500 and 75%, respectively. The South Division’s segment margin is $60,000. The company has $84,000 of common fixed expenses that cannot be traced to either division.    Required: Prepare an income statement for Shannon Company...
Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-8]...
Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-8] Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 36,000 of these balls, with the following results: Sales (36,000 balls) $ 900,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT