50.1K

Verified Solution

Link Copied!

Key Information

Cost Drivers Unit Measure

Financial Services Patient Services Revenue

Facilities Square Footage

Housekeeping Labor Hours

Administration Salary Dollars

Personnel Salary Dollars

Patient Services Square Ft Housekeeping Salary Dollars

Revenue Labor Hours

Routine care $$36,000,000185,00072,000$ $$15,000,000$

Laboratory $$19,000,00025,0004,200$ $$3,800,000$

Radiology $$17,000,00055,0008,000$ $$4,200,000$

Total $$72,000,000265,00084,200$ $$23,000,000$

COMPLETE THE TABLE $($Need to calculate allocation rate$)$

Overhead Allocation Rates

Cost Pool Cost Driver Total utilization Allocation Rate

Financial Services $$5,000,000$ Patient Services Revenue $$72,000,000$

Facilities $$7,200,000$ Square Footage $265,000$

Housekeeping $$3,500,000$ Labor Hours $84,200$

Administration $$5,000,000$ Salary Dollars $$23,000,000$

Human Resources $$3,200,000$ Salary Dollars $$23,000,000$

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

Answer & Explanation Solved by verified expert

See Answer