Please show all work!!! Thank you!

Gordon County Hospital (GCH) is a rural hospital. The financial statements for GCH are provided in Exhibit 1. The new CEO of the hospital is concerned that GCH does not have appropriate costing for management purposes. Accordingly she has discussed with the hospitals controller the current costing methodology.

The controller has explained that the revenue centers are considered profit centers so that all direct costs of each revenue center are subtracted from revenues generated in primary patient care, labs and imaging. All of the support department costs are considered overhead and not currently allocated to any of the profit centers.

The controller who began in the financial services area as an Accounts Receivable clerk and worked her way up the chain of command to controller indicates that the hospital is operating at a profit of about $12 million. Furthermore she states that each of the profit centers are profitable. the primary patient care profit center has a $20 million profit followed closely by labs as can be seen through Exhibit 1.

The CEO has asked the controller to allocate the overhead, or support service department cost, to each of the profit centers. Accordingly controller returns to her office and is contemplating how to allocate support Service department costs to each of the profit centers. She knows that you have recently completed an MBA and asked for your advice about how to allocate support service department costs.

You tell her that there are several methodologies that would be appropriate. You know that perhaps the simplest approach would be to use the direct method to allocate service department cost to each of the profit centers. She responds that she knows that the overhead cost allocation should follow some logical and systematic basis along the lines of what has caused the cost. She asked for your advice about what you believe would be the best method to allocate each service department cost.

You reflect on the nature of each service department one by one. You know that financial services essentially does all the billing and handling of insurance. Facilities you understand takes care of all of the maintenance of the hospital. Maintenance of equipment for specialized equipment is done by technicians who are specially contracted by each profit center and their costs are therefore considered direct to each profit center. The hospital employs housekeeping personnel that clean the hospital, wash laundry and so forth. Administration is responsible for overseeing the operations of the hospital. Personnel department is essentially a human resource department.

In your opinion, with this limited data, what are the cost drivers of each support department cost? Provide a rationale for each driver.

Exhibit 1
Gordon County Hospital
Projected Revenues by Patient Services Department
Primary Patient Care	$ 40,000,000
Labs	$ 34,000,000
Imaging	$ 6,000,000
Total Revenues	$ 80,000,000
Projected direct Costs
Primary Patient Care	$ 20,000,000
Labs	$ 15,000,000
Imaging	$ 3,000,000
Total Costs	$ 38,000,000
Support Services Departments (Overhead Costs):
Financial Services	$ 1,500,000
Facilities	$ 3,800,000
Housekeeping	$ 1,600,000
Administration	$ 4,400,000
Personnel	$ 2,550,000
Total Costs	$ 13,850,000
Total costs of both patient and support services	$ 51,850,000
Projected profit	$ 28,150,000

Part A, 2

Next, make the allocation on the basis of the following data. Exhibit 3 shows data for square feet, housekeeping labor hours and salaries for each of the three production departments. First calculate an allocation rate (show your work), then allocate costs and calculate profit (including direct costs) for each of the production departments. Cost drivers and total cost pool for each support department is listed below:

Department	Cost Pool (Total Costs)	Cost Driver	Total Utilization
Financial Services	$ 1,500,000	Patient Revenue	$ 80,000,000
Facilities	$ 3,800,000	Square Feet	$ 300,600
Housekeeping	$ 1,600,000	Labor Hours	$ 91,000
Administration	$ 4,400,000	Salary Dollars	$ 10,183,000
Personnel	$ 2,550,000	Salary Dollars	$ 10,183,000

Exhibit 3 Part A2
Department	Patient Services Revenue	Square Feet	Housekeeping Labor Hours	Salary Dollars
Primary Patient Care	$ 40,000,000	199,800	76,000	$ 5,709,000
Labs	$ 34,000,000	39,600	6,000	$ 2,035,000
Imaging	$ 6,000,000	61,200	9,000	$ 2,439,000
Total	$ 80,000,000	300,600	91,000	$ 10,183,000

Prepare a schedule illustrating the allocation of support department costs to each of the production departments 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.