Department		Direct Costs		Space (Square Feet)		Housekeeping Labor Hours		Salary Dollars
Support:
General Admin		$4,000,000		8,000		3,000		$2,000,000
Facilities		6,000,000		25,000		6,000		4,000,000
Financial Services		3,000,000		10,000		4,000		2,500,000
Total		$13,000,000		43,000		13,000		$8,500,000
Patient Services:		Patient Services Revenue
Routine Care		$40,000,000		400,000		150,000		$12,000,000
Intensive Care		5,000,000		40,000		30,000		5,000,000
Diagnostic Services		8,000,000		60,000		15,000		6,000,000
Other Services		12,000,000		100,000		25,000		7,000,000
Total		$65,000,000		600,000		220,000		$30,000,000
Grand Total		$65,000,000		643,000		233,000		$38,500,000

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

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 your answer

 

Patient Services Department Support Department Routine Care Laboratory Radiology Financial Services ($o.05556) x $16,000,000 = $ 888,960 x $5,000,000 = $ 277,800 x $6,000,000 = $ 33.360 Facilities ($12.64) 199,800 = 2,525,472 39,600 = 500,544 61,200 = 773.568 Housekeeping ($17.58) 76,000 = 1,336,080 6,000 = 105,480 9,000 = 158,220 Administration ($0.432) X 5.709,000 = 2,466,288 X 2,035,000 = 879,120 X 2,439,000 = 1,053,648 Personnel ($0.250) X 5.709,000 = 1,427,250 X 2,035,000 = 508,750 X 2,439,000 = 609.750 $ 8,644,050 $ 2,271,694 $ 3,300,000 $ 2,928,546 $ 2,800,000 Total indirect costs Direct costs $ 5.500,000 Total costs $ 14,144,050 $ 5.571,694 $ 5,728,546 Total indirect costs = $8,644,050 + $2,271,694 + $2,928,546 = $13,844,290 Total costs = $14.144.050 + $5.571,694 + $5.728,546 = $25,444,290 Note: Because of rounding in the allocation process, thetotals here differ slightly from the values contained in Exhibit 6.3.