The organization's vice president has asked you to determine the breakeven point of a new walk-in clinic that they are proposing. 

• Answer questions a, b, and c.
• Recommend whether you should accept the project.
• Calculations need to be in the cells of the excel spreadsheet or shown in the excel spreadsheet

5.3 Questions:

Assume that a radiologist group practice has the following cost

structure:

Fixed costs $500,000

Variable cost per procedure 25

Charge (revenue) per procedure 100

Furthermore, assume that the group expects to perform 7,500

procedures in the coming year.

a. Construct the group's base case projected P&L statement.

b. What is the group's contribution margin? What is its accounting

breakeven point?

c. What volume is required to produce a pretax profit of $100,000? A pretax profit of $200,000?