I need help finding the allocation rate, allocation costs and net income. Thank you.

Exhibit 3 Part A2 Patient Services Housekeeping Labor Hours % of total %oftotal Department %Of total sales Square Feet %Of total sales sales Salary Dollars sales 3 Primary Patlient CareS 4Labs 5 Imaging 6 Total 40,000,000 34,000,000 6,000,000 80,000,000 12% $ 45,984,800 6% $ 36,080,600 29% $ 8,509,200 11% $ 90,574,600 87% 199,800 39,600 61,200 300,600 0.43% 0.11% 0.72% 0.33% 76,000 6,000 9,000 91,000 0.17% $ 5,709,000 0.02% $ 2,035,000 0.11% $ 2,439,000 0.10% $10,183,000 8 To get allocation percentages we divded department cost by total costs for each department 10 11 WENEED TO ADD: 12 Prepare a schedule illustrating the allocation of support department costs to each of the production departments 13 and calculate the total costs (allocated support department costs+ direct costs) and the net income of each production department after all costs have been allocated. Department Financlal Services Facilities Cost Pool (Total C Cost Driver Patient Revenue Total UtilizationAllocation Rate 15 16 80000000 are Feet Labor Hours Salary Dollar Salary Dollar 18 91000 10183000 10183000 Administration 2S50000 Primary Patlent Care 25 Direct Costs Allocated Costs Total Costs 3000000 sum of three above Net Income Total should be total net income reported in exibit 1 5 51,850,000 31 32 35