Excel file attached. Please review the question as I didn't find it on the website.

Chapter 5 UNDERSTANDING HEALTHCARE FINANCIAL MANAGEMENT, Problem 5.2 Consider the data in the table below for three independent health services organizations: Revenues a. $ 2,000 b. c. $ 4,000 Total Variable Costs Fixed Costs Total Costs $ 1,400 $ 2,000 $ 1,000 $ 1,600 $ 600 Fill in the missing data indicated in blue Profit $ $ 2,400 400 INANCIAL MANAGEMENT, 6th ed Chapter 5 UNDERSTANDING HEALTHCARE FINANCIAL MANAGEMENT, 6th ed Problem 5.3 Assume that a radiologist group practice has the following cost structure: Fixed Costs Variable cost per procedure Charge (revenue) per procedure $500,000 25 100 Furthermore, assume that the group expects to perform 7,5000 procedures in the coming year. a. Construct the group's base case projected P&L statement Total revenues Total variable costs Total contribution margin Fixed costs Profit (net income) b. What is the group's contribution margin? What is its breakeven point? Revenue per procedure Variable cost per procedure Contribution margin per procedure Fixed costs Contribution margin per procedure Accounting Breakeven visits c.1 What volume is required to provide a pretax profit of $100,000? Fixed costs Target profit Contribution margin per procedure Economic Breakeven visits c.2 What volume is required to provide a pretax profit of $200,000? Fixed costs Target profit Contribution margin per procedure Economic Breakeven visits d. We are skipping e. now assume a 20 percent discount from charges. Redo questions a, b, and c under these conditions. redo a. Construct the group's base case projected P&L statement Total revenues Total variable costs Total contribution margin Fixed costs Profit (net income) redo b. What is the group's contribution margin? What is its breakeven point? Revenue per procedure Variable cost per procedure Contribution margin per procedure Fixed costs Contribution margin per procedure Accounting Breakeven visits redo c.1 What volume is required to provide a pretax profit of $100,000? Fixed costs Target profit Contribution margin per procedure Economic Breakeven visits redo c.2 What volume is required to provide a pretax profit of $200,000? Fixed costs Target profit Contribution margin per procedure Economic Breakeven visits ANAGEMENT, 6th ed