Question

In: Accounting

Franklin Health Care Center, Inc. has three clinics servicing the Seattle metropolitan area. The company’s legal...

Franklin Health Care Center, Inc. has three clinics servicing the Seattle 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 annual cost of operating the legal services department is $511,900. The annual cost of operating the computer services department is $318,200. The company uses the number of patients served as the cost driver for allocating the cost of legal services and the number of computer workstations as the cost driver for allocating the cost of computer services. Other relevant information follows.

Number of Number of
Patients Workstations
Sewell clinic 6,200 20
Alphretta clinic 6,000 12
Gwinnett clinic 6,800 7
Legal services 4
Computer services 19


Required

  1. Allocate the cost of computer services to all of the clinics and the legal services department.

  2. After allocating the cost of computer services, allocate the cost of legal services to the three clinics.

  3. Compute the total allocated cost of service centers for each clinic.

Solutions

Expert Solution

Requirement (a):

Annual cost of Operating Computer Service Department = $318,200

Number of workstations in three clinics and legal service department = 20 + 12 + 7 + 4 i.e. 43 workstations

Accocation Rate of Computer Department = Annual Cost / Number of Workstations

= $318,200 / 43 workstations

= $7,400 each workstations

Computer Department Cost allocated to:

Sewell Clinic : 20 workstations * $7,400 each workstation : $148,000

Alphretta Clinic : 12 workstations * $7,400 each workstation : $88,800

Gwinnett Clinic : 7 workstations * $7,400 each workstation : $51,800

Legal Department : 4 workstations * $7,400 each workstation : $29,600

Requirement (b):

Cost in Legal Service Department = Annual Operating Cost of Legal Department + Cost allocated from Computer Department

= $511,900 + $29,600

= $541,500

Number of patients in three clinics = 6,200 + 6,000 + 6,800 i.e. 19,000 patients

Cost allocation rate of Legal Service Department = Cost in Legal Service Department / Total number of patients

= $541,500 / 19,000 patients

= $28.50 per patient

Legal Service Department Cost allocated to:

Sewell Clinic : 6,200 patients * $28.50 per patient : $176,700

Alphretta Clinic : 6,000 patients * $28.50 per patient : $171,000

Gwinnett Clinic : 6,800 patients * $28.50 per patient : $193,800

Requirement (c):

Computer Service Legal Service Sewel Clinic Alphretta Clinic Gwinnett Clinic
Annual Cost $             318,200 $ 511,900
Allocation of Computer Service Cost $           -318,200 $           29,600 $ 148,000 $            88,800 $           51,800
Allocation of Legal Service Cost $ -541,500 $ 176,700 $ 171,000 $ 193,800
Total cost allocated $ -   $                    -   $ 324,700 $ 259,800 $ 245,600

Related Solutions

There are three health clinics in Bangkok, Thailand, area. The following data show the number of...
There are three health clinics in Bangkok, Thailand, area. The following data show the number of outpatient surgeries performed on Monday, Tuesday, Wednesday, Thursday, and Friday at each hospital last week. At the 0.01 significance level, can we conclude there is a difference in the mean number of surgeries performed by hospital or by day of the week? Number of Surgeries Performed Day St. Luke's St. Vincent Mercy Monday 45 31 28 Tuesday 26 35 19 Wednesday 21 35 24...
Franklin Technologies, Inc. has three divisions. Franklin has a desired rate of return of 12.0 percent....
Franklin Technologies, Inc. has three divisions. Franklin has a desired rate of return of 12.0 percent. The operating assets and income for each division are as follows:       Divisions Operating Assets Operating Income Printer $ 610,000 $ 102,480 Copier 880,000 99,440 Fax 430,000 61,060 Total $ 1,920,000 $ 262,980 Franklin headquarters has $127,000 of additional cash to invest in one of its divisions. The division managers have identified investment opportunities that are expected to yield the following ROIs: Expected ROIs...
Describe three Federal legal trends that are occurring in health care today. What are the implications...
Describe three Federal legal trends that are occurring in health care today. What are the implications to the health care entity? What is the best way to stay abreast of any changes? (minimum of 250 words)
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income...
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income statement for the company for the last quarter is given below: Superior Markets, Inc. Income Statement For the Quarter Ended September 30 Total North Store South Store East Store Sales $ 3,500,000 $ 780,000 $ 1,400,000 $ 1,320,000 Cost of goods sold 1,925,000 450,000 749,000 726,000 Gross margin 1,575,000 330,000 651,000 594,000 Selling and administrative expenses: Selling expenses 827,000 236,400 317,500 273,100 Administrative expenses...
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income...
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income statement for the company for the last quarter is given below: Superior Markets, Inc. Income Statement For the Quarter Ended September 30 Total North Store South Store East Store Sales $ 4,800,000 $ 960,000 $ 1,920,000 $ 1,920,000 Cost of goods sold 2,640,000 600,000 984,000 1,056,000 Gross margin 2,160,000 360,000 936,000 864,000 Selling and administrative expenses: Selling expenses 853,000 249,400 324,000 279,600 Administrative expenses...
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income...
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income statement for the company for the last quarter is given below: Superior Markets, Inc. Income Statement For the Quarter Ended September 30 Total North Store South Store East Store Sales $ 4,000,000 $ 840,000 $ 1,600,000 $ 1,560,000 Cost of goods sold 2,200,000 495,000 847,000 858,000 Gross margin 1,800,000 345,000 753,000 702,000 Selling and administrative expenses: Selling expenses 837,000 241,400 320,000 275,600 Administrative expenses...
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income...
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income statement for the company for the last quarter is given below: Superior Markets, Inc. Income Statement For the Quarter Ended September 30 Total North Store South Store East Store Sales $ 4,000,000 $ 840,000 $ 1,600,000 $ 1,560,000 Cost of goods sold 2,200,000 495,000 847,000 858,000 Gross margin 1,800,000 345,000 753,000 702,000 Selling and administrative expenses: Selling expenses 837,000 241,400 320,000 275,600 Administrative expenses...
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income...
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income statement for the company for the last quarter is given below: Superior Markets, Inc. Income Statement For the Quarter Ended September 30 Total North Store South Store East Store Sales $ 3,500,000 $ 780,000 $ 1,400,000 $ 1,320,000 Cost of goods sold 1,925,000 450,000 749,000 726,000 Gross margin 1,575,000 330,000 651,000 594,000 Selling and administrative expenses: Selling expenses 827,000 236,400 317,500 273,100 Administrative expenses...
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income...
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income statement for the company for the last quarter is given below: Superior Markets, Inc. Income Statement For the Quarter Ended September 30 Total North Store South Store East Store Sales $ 3,600,000 $ 800,000 $ 1,440,000 $ 1,360,000 Cost of goods sold 1,980,000 470,000 762,000 748,000 Gross margin 1,620,000 330,000 678,000 612,000 Selling and administrative expenses: Selling expenses 829,000 237,400 318,000 273,600 Administrative expenses...
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income...
Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income statement for the company for the last quarter is given below: Superior Markets, Inc. Income Statement For the Quarter Ended September 30 Total North Store South Store East Store Sales $ 3,600,000 $ 800,000 $ 1,440,000 $ 1,360,000 Cost of goods sold 1,980,000 470,000 762,000 748,000 Gross margin 1,620,000 330,000 678,000 612,000 Selling and administrative expenses: Selling expenses 829,000 237,400 318,000 273,600 Administrative expenses...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT