Health Co-op is an outpatient surgical clinic that wants to better understand its costs. It decides to prepare an activity-based cost analysis, including an estimate of the average cost of both general surgery and orthopedic surgery. The clinic's three cost centers and their cost drivers follow.

The two main surgical units and their related data follow.

* Orthopedic surgery requires more space for patients, supplies, and equipment.

Required

Assume costs are allocated based on number of patients. Compute the average cost per patient. (Round to the nearest whole dollar.)

Compute the cost per cost driver for each of the three cost centers.

Use the results from part 1 to allocate costs from each of the three cost centers to the general surgery unit. Compute total cost and average cost per patient for the general surgery unit.

Please use excel.

Cost Center Patient services and supplies Building cost $1600,000 27.000 50.000 Cost Driver Number of patients Square feet Driver Quantity