Key Information Cost Drivers Unit Measure Financial Services Facilities Housekeeping Administration Personnel Patient Services Revenue Square Footage Labor Hours Salary Dollars Salary Dollars Patient Services Revenue Square Ft Housekeeping Labor Hours Salary Dollars Eint Routine care Laboratory Radiology $ 24,000,000 $ 15,000,000 $ 14,000,000 185,000 25,000 55,000 72,000 4,200 8,000 $ 12,000,000 $ 3,000,000 $ 3,500,000 Total $ 53,000,000 265,000 84.200 $ 18,500,000 COMPLETE THE TABLE (Need to calculate allocation rate) Overhead Allocation Rates Cost Pool Cost Driver Total utilization Allocation Rate Financial Services Facilities Housekeeping Administration Human Resources $3,000,000 $5,600,000 $3,000,000 $4,000,000 $2,400,000 Patient Services Revenue $ 53,000,000 Square Footage 265,000 Labor Hours 84,200 Salary Dollars $ 18,500,000 Salary Dollars $ 18,500,000 0.0566 21.1321 35.6295 0.2162 0.1297 Complere the Allocation Rate for each driver Please provide your ideas on other data points not listed in row 12 of this spreadsheet that could be used as cost drivers for each of the non-revenue generating departments listed, List 2 for financial services, 1 for facilities, 1 for housekeeping, 2 for administration and 1 for HR Key Information Cost Drivers Unit Measure Financial Services Facilities Housekeeping Administration Personnel Patient Services Revenue Square Footage Labor Hours Salary Dollars Salary Dollars Patient Services Revenue Square Ft Housekeeping Labor Hours Salary Dollars Eint Routine care Laboratory Radiology $ 24,000,000 $ 15,000,000 $ 14,000,000 185,000 25,000 55,000 72,000 4,200 8,000 $ 12,000,000 $ 3,000,000 $ 3,500,000 Total $ 53,000,000 265,000 84.200 $ 18,500,000 COMPLETE THE TABLE (Need to calculate allocation rate) Overhead Allocation Rates Cost Pool Cost Driver Total utilization Allocation Rate Financial Services Facilities Housekeeping Administration Human Resources $3,000,000 $5,600,000 $3,000,000 $4,000,000 $2,400,000 Patient Services Revenue $ 53,000,000 Square Footage 265,000 Labor Hours 84,200 Salary Dollars $ 18,500,000 Salary Dollars $ 18,500,000 0.0566 21.1321 35.6295 0.2162 0.1297 Complere the Allocation Rate for each driver Please provide your ideas on other data points not listed in row 12 of this spreadsheet that could be used as cost drivers for each of the non-revenue generating departments listed, List 2 for financial services, 1 for facilities, 1 for housekeeping, 2 for administration and 1 for HR