Question

In: Accounting

Woodbury Hospital has three service departments and three operating departments. Estimated cost and operating data for...

Woodbury Hospital has three service departments and three operating departments. Estimated cost and operating data for all departments in the hospital for the forthcoming quarter are presented in the table below:

Service Departments

Operating Departments

Housekeeping Services Food Services Administrative Services Laboratory Radiology General Hospital Total
Total cost $93,000 $313,060 $261,020 $420,900 $544,500 $496,800 $2,129,280
Meals served 1,400 3,200 1,600 71,600 77,800
Square feet of space 5,600 14,800 7,700 11,800 8,100 114,000 162,000
Files processed 17,000 10,000 31,000 58,000

The costs of the service departments are allocated by the step-down method using the allocation bases and in the order shown in the following table:

Service Department Allocation Bases
Housekeeping Services Square feet of space
Food Services Meals served
Administrative Services Files processed

All billing in the hospital is done through Laboratory, Radiology, or General Hospital. The hospital’s administrator wants the costs of the three service departments allocated to these three billing centers.

Required:

Using the step-down method, prepare the cost allocation desired by the hospital administrator. Include under each billing center the direct costs of the center, as well as the costs allocated from the service departments. (Please enter allocations from a department as negative and allocations to a department as positive. The line should add across to zero. Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.)

Solutions

Expert Solution

Housekeeping services Food services Administartive services Laboratory Radiology General hospital
Departmental costs before allocations $93,000 $313,060 $261,020 $420,900 $544,500 $496,800
Allocations
Housekeeping services costs ($93,000) $8,800 $4,579 $7,017 $4,816 $67,788
Food service costs ($321,860) $5,792 $13,238 $6,620 $296,210
Administrative service cost ($271,391) $79,545 $46,792 $145,054
Total $0 $0 $0 $520,700 $602,728 $1,005,852

Explanation:

Housekeeping:

Food services =$93,000×14,800/156,400 =$8,800

Administrative=$93,000×7,700/156,400 =$4,579

Laboratory=$93,000×11,800/156,400 =$7,017

Radiology=$93,000×8,100/156,400 =$4,816

General hospital=$93,000×114,000/156,400 =$67,788

Food services:

Administrative =$321,860×1,400/77,800 =$5,792

Laboratory =$321,860×3,200/77,800 =$13,238

Radiology=$321,860×1,600/77,800 =$6,620

General hospital=$321,860 ×71,600/77,800 =$296,210

Administrative :

Laboratory=$271,391×17,000/58,000 =$79,545

Radiology=$271,391 ×10,000/58,000 =$46,792

General hospital =$271,391 ×31,000/58,000 =$145,054


Related Solutions

Woodbury Hospital has three service departments and three operating departments. Estimated cost and operating data for...
Woodbury Hospital has three service departments and three operating departments. Estimated cost and operating data for all departments in the hospital for the forthcoming quarter are presented in the table below: Service Departments Operating Departments Housekeeping Services Food Services Administrative Services Laboratory Radiology General Hospital Total Total cost $107,000 $341,060 $289,020 $455,900 $600,500 $545,800 $2,339,280 Meals served 2,800 6,000 3,000 80,000 91,800 Square feet of space 7,000 19,000 10,500 16,000 9,500 128,000 190,000 Files processed 24,000 17,000 45,000 86,000 The...
Woodbury Hospital has three service departments and three operating departments. Estimated cost and operating data for...
Woodbury Hospital has three service departments and three operating departments. Estimated cost and operating data for all departments in the hospital for the forthcoming quarter are presented in the table below: Service Departments Operating Departments Housekeeping Services Food Services Administrative Services Laboratory Radiology General Hospital Total Total cost $105,000 $337,060 $285,020 $450,900 $592,500 $538,800 $2,309,280 Meals served 2,600 5,600 2,800 78,800 89,800 Square feet of space 6,800 18,400 10,100 15,400 9,300 126,000 186,000 Files processed 23,000 16,000 43,000 82,000 The...
Arbon Company has three service departments and two operating departments. Selected data concerning the five departments...
Arbon Company has three service departments and two operating departments. Selected data concerning the five departments are presented below: Service Departments Operating Departments Administrative Janitorial Equipment Maintenance Prep Finishing Total   Costs $ 92,000 $ 67,800 $ 36,000 $ 256,100 $ 498,600 $ 950,500   Number of employees 80 60 240 600 300 1,280   Square metres of space occupied 300 1,200 1,000 2,000 7,000 11,500   Machine-hours 26,000 54,000 80,000      The company allocates service department costs by the step-down method in the following...
The Ferre Publishing Company has three service departments and two operating departments. Selected data from a...
The Ferre Publishing Company has three service departments and two operating departments. Selected data from a recent period on the five departments follow: Service Departments Operating Departments Administration Janitorial Maintenance Binding Printing Total Costs $72,000 $73,000 $44,000 $245,000 $545,000 $979,000 Number of employees 112 80 320 800 400 1,712 Square feet of space occupied 3,000 12,000 10,000 20,000 70,000 115,000 Hours of press time 18,000 37,000 55,000 The company allocates service department costs by the step-down method in the following...
The Ferre Publishing Company has three service departments and two operating departments. Selected data from a...
The Ferre Publishing Company has three service departments and two operating departments. Selected data from a recent period on the five departments follow: Service Departments Operating Departments Administrative Janitorial Maintenance Binding Printing Total   Costs $93,300 $66,200 $44,800 $248,300 $490,600 $943,200   Number of employees 60 90 260 630 320 1,360   Square feet of space occupied 3,100 11,800 8,800 10,400 68,900 103,000   Hours of press time 9,600 28,200 37,800 Required: Assuming that the company uses the direct method rather than the step-down...
Macy Manufacturing Corporation has two service departments, Custodial Services and Maintenance, and three production (operating) departments,...
Macy Manufacturing Corporation has two service departments, Custodial Services and Maintenance, and three production (operating) departments, Cutting, Milling, and Assembly. The company allocates the cost of Custodial Services on the basis of square footage and Maintenance on the basis of labor-hours. No distinction is made between variable and fixed costs. Budgeted operating data for the year just completed follow: Service Departments Operating Departments Custodial Maintenance Cutting Milling Assembly Budgeted costs before allocation $24,000 $12,000 $120,000 $75,000 $135,000 Square feet 2,000...
ABC Corporation has three service departments with the following costs and activity base: Service Department Cost...
ABC Corporation has three service departments with the following costs and activity base: Service Department Cost Activity Base for Allocation Graphics Production $200,000 # of copies Accounting $500,000 # of invoices processed Personnel Department $400,000 # of employees ABC has three operating divisions, Micro, Macro and Super. Their revenue, cost and activity information for December 31, 2017 are as follows: Micro Macro Super Direct Revenues $700,000 $850,000 $650,000 Direct Operating Expenses $50,000 $70,000 $100,000 # of copies made 20,000 30,000...
Problem 1 The All Souls Hospital has three service departments (Nursing Support, Maintenance and Administration) and...
Problem 1 The All Souls Hospital has three service departments (Nursing Support, Maintenance and Administration) and two operating departments (Inpatient and Outpatient.) Selected data from a recent period on the five departments follows. Service Departments Operating Departments Nursing Support Maintenance Administration Inpatient Outpatient Total Direct Costs $140,000 $105,000 $48,000 $275,000 $430,000 $998,000 Number of Employees 60 35 140 315 210 760 Square Feet of Space Occupied 15,000 10,000 20,000 40,000 100,000 185,000 Patient Hours 30,000 60,000 90,000 Hospital Administrators use...
Andy Corp. has two service departments and two operating departments. The company allocates service departmental costs...
Andy Corp. has two service departments and two operating departments. The company allocates service departmental costs to operating departments using the step-down method. Operating data for these departments for last year are as follows: Service Departments Operating Departments Personnel Maintenance Assembly Machining Departmental costs $144,000 $84,000 $12,000 $34,000 Number of employees 35 30 90 60 Machine-hours 0 0 330 170 Personnel costs are allocated first on the basis of number of employees and Maintenance costs are allocated second on the...
Andy Corp. has two service departments and two operating departments. The company allocates service departmental costs...
Andy Corp. has two service departments and two operating departments. The company allocates service departmental costs to operating departments using the step-down method. Operating data for these departments for last year are as follows: Service Departments Operating Departments Personnel Maintenance Assembly Machining Departmental costs $144,000 $84,000 $12,000 $34,000 Number of employees 35 30 90 60 Machine-hours 0 0 210 290 Personnel costs are allocated first on the basis of number of employees and Maintenance costs are allocated second on the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT