Project #154709 - finance Break even point MBA

Business Tutors

Subject Business
Due By (Pacific Time) 11/20/2016 05:00 pm

Break-even exercise

Break-Even Analysis or Cost Volume Profit Analysis (CVP)

 

The California Medical Hospital is a full service hospital in Burbank, CA.  Kathy Potts, the Chief Surgeon and Regina Johnson, the Hospital Administrator, have been working on a project to bring a new product to their hospital, knee replacements, to expand the services provided in hopes of bringing in additional revenue.

 

After much analysis and market studies the two are ready to present their findings to the board.  You are the Finance Director who has put the information together. 

 

They have decided that a new knee replacement will cost $17,000.  The supplies used will cost the hospital $9,500 and the selling expenses paid amount to $3,000 per knee.  The wing they will use will rent for $15,500 per month and the surgeon will receive a fixed salary of $25,000 per month.  (Show your work on all problems)

1.     1.Determine the number of knee replacements (in units) that particular wing must perform each month to break even.  (Break-Even Point or BEP).  In other words how many knee replacements must the surgeon perform each month to break-even?

2.   2.  Determine the number of knee replacements that particular wing must perform in order to generate a profit of $100,000 per month.

3.     3.Assume that the surgeon can now open a clinic on his own with the following costs:

Variable costs = $9,500 per knee

One additional employee at a cost of $1,000 per month

Everything else remains the same from above

4.Determine the number of knee replacements to break-even.

4.     5.Determine the number of knee replacements needed to generate a profit of $100,000 per month

What scenario would you recommend and why?

  

5.     6. Please graph scenario #1 only.  You may use excel or draw and attach the graph.  I encourage you to try MS Excel for the experience.  Label the X and Y axis.  Plot the break-even point and show the fixed cost line.  ( I only want to see three lines on the graph and the rest should be labelled)

TutorRating
pallavi

out of 1971 reviews
amosmm

out of 766 reviews
PhyzKyd

out of 1164 reviews
rajdeep77

out of 721 reviews
sctys

out of 1600 reviews
sharadgreen

out of 770 reviews
topnotcher

out of 766 reviews
XXXIAO

out of 680 reviews