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 | $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 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
| Thank you for your patience. Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
| Woodbury Hospital |
| Note: Under step down method the support department with highest cost is allocated first among other service and operating dept. Then service dept. with next highest cost is allocated and so on. Here Food Services dept. has highest cost so it is allocated first and then admin dept. and at last Housekeeping dept. |
| Step Down Method | Housekeeping | Food | Admin | Laboratory | Radiology | General Hospital | Total |
| Square feet of space | 7,000.00 | 19,000.00 | 10,500.00 | 16,000.00 | 9,500.00 | 128,000.00 | 190,000.00 |
| Meals served | 2,800.00 | 6,000.00 | 3,000.00 | 80,000.00 | 91,800.00 | ||
| Files processed | 24,000.00 | 17,000.00 | 45,000.00 | 86,000.00 | |||
| Costs before allocation | 107,000.00 | 341,060.00 | 289,020.00 | 455,900.00 | 600,500.00 | 545,800.00 | 2,339,280.00 |
| Allocation of Food dept. in the ratio of meals served | (289,020.00) | ||||||
| Allocation % | 3.05% | 6.54% | 3.27% | 87.15% | 100.00% | ||
| Allocation amount | - | (341,060.00) | 10,402.70 | 22,291.50 | 11,145.75 | 297,220.04 | - |
| Costs after allocation | 107,000.00 | - | 299,422.70 | 478,191.50 | 611,645.75 | 843,020.04 | 2,339,280.00 |
| Allocation of admin dept. in the ratio of files | |||||||
| Allocation % | - | 27.91% | 19.77% | 52.33% | 100.00% | ||
| Allocation amount | - | - | (299,422.70) | 83,559.82 | 59,188.21 | 156,674.67 | - |
| Costs after allocation | 107,000.00 | - | - | 561,751.33 | 670,833.96 | 999,694.71 | 2,339,280.00 |
| Allocation of admin dept. in the ratio of space | |||||||
| Allocation % | 10.42% | 6.19% | 83.39% | 100.00% | |||
| Allocation amount | (107,000.00) | 11,153.09 | 6,622.15 | 89,224.76 | - | ||
| Costs after allocation | - | - | - | 572,904.00 | 677,456.00 | 1,088,920.00 | 2,339,280.00 |
ekkarill92 answered 1 year agoRelated 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
$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...
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
Latest Questions
- (Subject is Marketing Management MGT-201) A marketing mix is a group of marketing variables that a...
- Competition to increase one's market share is natural in the pursuit of businesses. Explain whether any...
- Demonstrate why is not enough to use an asymmetric crypting scheme such as RSA to allow...
- Phosphorous acid, H3PO3(aq), is a diprotic oxyacid that is an important compound in industry and agriculture....
- A person standing on the ground is holding a spinning bicycle wheel. he reaches up and...
- Describe supply chain management along with its impact on business.
- Compute the check sum for each of the following data. a. 0x1243 0xFFE0 b. 0xFF34 0xEFD0...
ADVERTISEMENT