Need to complete the table in the first photo

4 Format Painter Formatting Table - Styles Styles Chiboard Font Alignment Number Ceils L18 D F G H M N 0 Question 18 COMPLETE TAILLE (A bolded areas) 3 points Patient Services Department Support Department Routine Care Laboratory Radiology 10 11 12 13 Financial Services Facts Housekeeping Administration Human Resources 16 Total Indirect costs 17 Direct cost O 19 20 Total cost 21 23 24 25 What is the resulting profitability of eachi Department and the organization as a whole? 226 27 Anal C. Wrap Test General - Copy BIU- BH - & A. Merge & Center $ . % Format Painter Conditional Forma Formatting Tabl Styles Clipboard Font Alignment Number 31 D G H Keyintommal Com Devers Unit Measure Financial Services Facilities Housekeeping Administration Personnel Patient Services Revenue Square Footage Labor Hours Salary Dolls Salary Dol Patient Service Revenue Squwet Salary Dollar Housekeeping Labor Hours Houtine care Laboratory Aadiology 24.000.000 15,000,000 14.000.000 185.000 25.000 55 000 72,000 4.200 8.000 + 12.000,000 1 3.000.000 3.500.000 Total 153.000.000 265.000 84200 11.500.000 COMPLETE THE TABLE (Need to calculate allocation rate) Overhead Allocation Rates CourA Com Driver Totallion Allocation Rate $ Financial Services Facilities Housekeeping Administrin Human Resources 3,000 000 5.600.000 3.000.000 4.000.000 2,400 000 Patient Services Rever 53.000.000 Square Footage 265,000 Labor Hours 84,200 Sway Do 1 18.500.000 Salary Dola 113.500.000 $3,000,000/153,000 0.06 $5,500,000/265,000 2113 $3,000,000784 2400 35 63 14,000,000/10.500,0 0.22 $2,400,000/18 500,0 0.13 9 D E F G H A B C Cost Allocation Exercise Use the Direct Method Approach Projected Revenues by patient services department Amount 6 Routine care Laboratory Radiology $ 24,000,000 15,000,000 14,000,000 Total Revenues $ 53,000,000 Projected Costs for all departments: Patient Services Departments (Direct Cost) 64 Routine care Laboratory Radiology 18,000,000 8,000,000 7,000,000 Total Costs $ 33,000,000 Support Services Department (Overhead Costs) $ $ $ $ $ 3,000,000 5.600.000 3,000,000 4,000,000 2,400,000 3 Financial Services 4 Facilities Housekeeping 06 Administration 27 Human Resources 28 Totals Costs 30 31 Total Costs of both patient and support services 32 33 Projected Profit 18,000,000 51000.000 2.000.000 35 38 37 138