Please show work

B D E F G M 8 10 11 12 13 Q3) Bexar Community Hospital has been under increasing pressure to be accountable for its patient charges. The hospital currently uses the traditional allocation method and allocates its total costs to its three Departments: Surgery, Outpatient, and Post-Surgical Care based on square feet in each of the Departments. The hospital's CFO has suggested that the hospital improve pricing policies by seeking a tighter relationship between costs and pricing. She has suggested using ac- tivity based costing method and has determined that costs can be assigned to one of three cost pools. The three cost pools follow along with the estimated amounts and activity drivers. Activity Center Costs Activity Driver Quantity Professional Salaries $950,900 Professional Hours 25,554 Medical Supplies $99.200 Patients Served 8.255 Building costs $77.085 Square Feet Used 35.210 Details for each Department follow: 15 7 8 9 000 SOVER PAGE 01 02 03 04 D F H 19 20 21 22 3 Details for each Department follow: Department Square Feet Professional Hours Number of Patients Surgery 11.250 8,460 1,100 Outpatient 12,850 4,474 3,130 Post-Surgical Care 11,110 12,620 4.025 3A) What is the cost allocation to each Department under the traditional method? 3B) What is the cost allocation to each Department under the ABC method? Show all your work in the excel sheet below. Write your final answer for each section in the cor- responding space in the Tab marked "COVER_PAGE". PARA