Construct the group-s base case projected p-l statement

Question

1) 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.

1. Construct the group's base case projected P&L statement.
2. What is the group's contribution margin? What is its breakeven point?
3. What volume is required to provide a pretax profit of $100,000? A pretax profit of $200,000?
4. Sketch out a CVP analysis graph depicting the base case situation. Now assume that the practice contracts with one HMO, and the plan proposes a 20 percent discount from charges. Redo questions a, b, c, and d under these conditions.

2) General Hospital, a not-for-profit acute care facility, has the following cost structure for its inpatient services:

Fixed Costs:                                         $10,000,000

Variable cost per inpatient day:              $200

Charge (revenue) per inpatient day:        $1,000

The hospital expects to have a patient load of 15,000 inpatient days next year.

1. Construct the hospital's base case projected P&L statement.
2. What is the hospital's breakeven point?
3. What volume is required to provide a profit of $1,000,000? A profit of $500,000?
4. Now assume that 20 percent of the hospital's inpatient days come from a managed care plan that wants a 25 percent discount from charges. Should the hospital agree to the discounted proposal?

3) You are considering starting a walk-in clinic. Your financial projections for the first year of operations are as follows:

Revenues:                             $400,000

Wages & Benefits:                  $220,000

Rent:                                     $5,000

Depreciation:                          $30,000

Utilities:                                  $2,500

Medical Supplies:                     $50,000

Administrative Supplies:           $10,000

Assume that all costs are fixed, except supply costs, which are variable. Furthermore, assume that the clinic must pay taxes at a 20 percent rate.

1. Construct the clinic's projected P&L statement.
2. What number of visits is required to break even?
3. What number of visits is required to provide you with an after-tax profit of $100,000?
   

4) The housekeeping services department of Ruger Clinic, a multi-specialty practice in Toledo, Ohio had $100,000 in direct costs during 2011. These costs must be allocated to Ruger's three revenue-producing patient services departments using the direct method. Two cost drivers are under consideration: patient services revenue and hours of housekeeping services used. The patient services departments generated $5 million in total revenues during 2011, and to support these clinical activities, they used 5,000 hours of housekeeping services.

1. What is the value of the cost pool?
2. What is the allocation rate if:
   1. Patient services revenue is used as the cost driver?
   2. House of housekeeping services is used as the cost driver?

5) Refer to Problem 4. Assume that the three patient services departments are adult services, pediatric services, and other services. The patients services revenue and house of housekeeping services for departments are:

Department	Revenue	Housekeeping Hours
Adult Services	3,000,000	1500
Pediatric Services	1,500,000	3000
Other Services	500,000	500
Total	5,000,000	5000

1. What is the dollar allocation to each patient services department if patient services revenue is used as the cost driver?
2. What is the dollar allocation to each patient services department if hours of housekeeping support are used as the cost driver?
3. What is the difference in the allocation to each department between the two drivers?

Which of the two drivers is better? Why?