Posted: April 17th, 2016

What are the appropriate allocation rates?

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.
a. Construct the hospital’s base case projected P&L statement.
b. What is the hospital’s breakeven point?
c. What volume is required to provide a profit of $1,000,000? A profit of $500,000?
d. 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?

5.5
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.
a. Construct the clinic’s projected P&L statement.
b. What number of visits is required to break even?
c. What number of visits is required to provide you with an after-tax profit of $100,000?

6.1
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.
a. What is the value of the cost pool?
b. What is the allocation rate if:
a. Patient services revenue is used as the cost driver?
b. House of housekeeping services is used as the cost driver?

6.2
Refer to Problem 6.1. 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

a. What is the dollar allocation to each patient services department if patient services revenue is used as the cost driver?
b. What is the dollar allocation to each patient services department if hours of housekeeping support are used as the cost driver?
c. What is the difference in the allocation to each department between the two drivers?
d. Which of the two drivers is better? Why?

6.3
St. Benedict’s Hospital has three support departments and four patients services departments. The direct costs to each of the support departments are:
General Admin: $2,000,000
Facilities: $5,000,000
Financial Services: $3,000,000

Selected data for the three support and four patient services department are:

Assume that the hospital uses the direct method for cost allocation. Furthermore, the cost driver for general administration and financial services patient services revenue, while the cost driver for facilities is space utilization.
a. What are the appropriate allocation rates?
b. Use a allocation table similar to Exhibit 6.7 (below) to allocate the hospital’s overhead costs to the patient services departments.

Exhibit 6.7

6.4
Assume that the hospital uses salary dollars as the cost driver for general administration, housekeeping labor hours as the cost driver for facilities, and patient services revenue as the cost driver for financial services. (The majority of the costs of the facilities department stem from the provision of housekeeping services.)
a. What are the appropriate allocation rates?
b. Use an allocation table similar to the one used for Problem 6.3 to allocate the hospital’s overhead costs to the patient services departments.
c. Compare the dollar allocations with those obtained in Problem 6.3. Explain the differences.
d. Which of the two cost driver schemes is better? Explain.
Newer Entries
Older Entries