Question: A plastic surgery center performs a procedure whose gross charge is $7,000 of which $3,500 is collected. The variable cost per procedure is $1,500. The

A plastic surgery center performs a procedure whose gross charge is $7,000 of which $3,500 is collected. The variable cost per procedure is $1,500. The monthly fixed cost assigned to doing this procedure is $33,000. The center wants to generate a $27,000 profit each month in doing this procedure.

a. How many procedures per month, rounding up to the next highest whole number if necessary, would it need to do to achieve its profit target?

b. How many procedures per month, rounding up to the next highest whole number, would it need to perform to break-even?

c. On your Excel spreadsheet note the algebraic formula you used to solve these two problems. Using the Excel skills developed in the program so far, make your spreadsheet so that it prints on one page, and is readable. Use virtual cell references so that your work can be easily adapted to test other assumptions. Label each tab. Put your name in a footer on each tab. And, include your name in the filename. Use any other formatting features that you feel appropriate in preparing your spreadsheet

DO A SPREADSHEET !!!!!!!! spreadsheet please !!!!!!!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!