6.4 Assume that the hospital users 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.)

WHAT IS THE DIRECT COST HIGHLIGHTED IN GREEN AND ALL IN YELLO ON THE EXCEL SHEET PLEASE HELP!!!***************************************

Problem 6.4 General admin allocation rate Direct costs Total salary Allocation rate S30,000,000 $0.000 Facilities Direct costs Housekeeping hours Allocation rate 220,000 $0.00 Financial services Direct costs Patient services revenue Allocation rate 50,000,000 $0.00 b. Allocation to Patient services Allocation Routine Other Total Intensive care $0.00 $0.00 $0.00 $0 Rate Diagnostic General admin Facilities Financial services Total indirect costs 0.00 $0.00 $0.00 S0 $0 0.00 $0 $0.000 $0.00 $0.00 $0 0.00 0.00 0.00 $0 S0 S0 $0 10,000,000 allocation target