5. PROJECTED REVENUES AND COSTS PER DEPARTMENT Revenues Inpatient Services Outpatient Services Clinic Services Total revenues Direct Costs Inpatient Services Outpatient Services Clinic Services Total costs Service Department Costs Financial Services Facilities Housekeeping General Administration Total overhead costs Total Costs Projected Profit Department Financial Services Facilities Housekeeping General Administration Utlization information for allocations: Cost Driver Patient Revenue Square Feet Housekeeping Hours Salary Dollars $ $ $ $ Revenue Direct Costs Indirect Costs Total Costs Profit using only Direct Costs Profit margin % only Direct Costs Profit using Total Costs Profit margin % using Total Costs $ $ $ $ Management considered various cost drivers and made the determiniation to use the following as the most relevant for each service department: 18,500,000 32,600,000 6,250,000 57,350,000 9,275,000 18,250,000 4,500,000 32,025,000 4,750,000 8,500,000 2,750,000 3,500,000 19,500,000 51,525,000 5,825,000 Cost Driver Patient revenue Square feet Housekeeping hrs Salary dollars Inpatient $18,500,000 255,000 90,000 $6,500,000 Outpatient $32,600,000 C. Using Exhibit 6.8 as a guide, complete the P&L projections below. P&L Inpatient 175,000 55,000 $9,000,000 Use Exhibit 6.6 as a guideto complete this table and calculate the allocation rates. Be sure to use Excel functions/formulas to show your w Department Cost Pool Amount Cost Driver Total Utilization Allocation Rate Financial Services Facilities 18,500,000 4,750,000 or rev Sept Housekeeping General Administration Clinic $6,250,000 65,000 30,000 $2,500,000 Use Exhibit 6.7 as a guide to complete the indirect cost allocations to each patient service area. Indirect Cost Allocations Inpatient Outpatient Financial Services Facilities Housekeeping General Administration Total Indirect Costs Outpatient 57,350,000 495,000 Clinic Total $57,350,000 495,000 175,000 $18,000,000 Clinic Total Total