ATC $4-6($Static$)$ Spreadsheet Assignment: Using Excel

Brook Health Cate Center Incorporated has three clinics servicing the Birmingham metropolitan area. The company's legal services department supports the clinics. Moreover, its computer services department supports all of the clinics and the legal services department. The company uses the number of computer workstations as the cost driver for allocating the cost of computer services and the number of patients as the cost driver for allocating the cost of legal services. The annual cost of the Department of Legal Services was $$340,000,$ and the annual cost of the Department of Computer Services was $$250,000.$ Other relevant information follows.

$\backslash$table$[[,\backslash$table$[[$Number of$],[$Patients$]],\backslash$table$[[$Number of$],[$Workstations$]]],[$Hoover Clinic,$3,100,17],[$Eastwood Clinic,$2,300,13],[$Gardendale Clinic,$2,800,6],[$Legal Services,$0,14]]$

Required

Complete the spreadsheet to allocate the service costs using the step method.

Spreadsheet Tip

The supporting calculation section must be completed simultaneously with the allocation table. However, most of the supporting calculations can be completed first. The exception is that the value in cell C$25$ refers to the sum of cells C$18$ and C$19.$