Question

In: Accounting

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 the following for cost allocation:

Allocates Nursing Support based upon Number of Employees

Allocates Maintenance based upon Square Feet of Space Occupied

Allocates Administration based upon Patient Hours

Complete the following:

Use the step method to allocate the service department costs to the operating departments based upon the information above and determine the new costs for Inpatient and Outpatient. Use the following order: Nursing Support, Maintenance, Administration.

Use the direct method to allocate the service department costs to the operating departments.

Problem 2

Betty's Beauty Supply Company purchases a Cremex which is then processed to yield three moisturizing lotions: Angelic Crème, Ageless Crème and Antique Crème. In February, Betty purchased 10,000 gallons of Cremex at a cost of $250,000, and the company incurred $100,000 of additional joint conversion costs. June sales and production information are as follows:

Gallons Produced Sales Price at Split-off Further Processing Cost per Gallon Final Sales Price
Angelic Crème 2,000 $55 $0 $55
Ageless Crème 3,000 $40 $0 $40
Antique Crème 5,000 $30 $5 $60

Angelic and Ageless can be sold to other beauty supply stores at the split-off point. Antique can be sold at the split-off point or processed further and packaged for sale as an asthma medication. Allocate the $350,000 of joint cost to the three lotions using:

Physical units method

Sales value at split off method

NRV method

Constant gross margin method

Physical Units Method Sales Value at Split Off Method NRV Method Constant Gross Margin Method
Angelic Crème
Ageless Crème
Antique Crème

Solutions

Expert Solution

Solution to Problem 1

Allocation of cost of service departments using the step method

Under Step Method - The cost of each service department is allocated to other service departments and operating departments. However, the cost is not allocated to the same department as the cost incurred by each department pertains to providing the service to other departments and once the cost of a service department is allocated, the cost of other service department will not be allocated to that department.

As mentioned in the question, the cost of service department would be allocated in the following order

1) Nursing Support

2) Maintenance

3) Administration Department

Table showing the allocation of service departments using step method

Direct method of cost allocation

Under direct method the cost of each service department is allocated to operating department. Under this method the services used by other service departments are ignored for cost allocation.

Table showing the allocation of service departments using direct method

Workings


Related Solutions

HSU Corporation has two service departments, Maintenance and Administration, and two producing departments A and B....
HSU Corporation has two service departments, Maintenance and Administration, and two producing departments A and B. The direct costs of each department for the last year is as follows: Administration                $   80,000 Maintenance                       60,000 Department A                      5,000 Department B                      20,000 Information on the proportion of services supplied and used is: User Departments Administration Maintenance Dept. A Dept. B Administration 10% 60% 30% Maintenance 30% 20% 50% Using the reciprocal method of service department cost allocation Administration costs allocated to Department B is: a. $24,000...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and packaging. Information for the three service departments is given below: Admin Maint Person Directly traced overhead $68,000 $46,000 $77,000 Square feet occupied 2,000 3,500 3,000 Number of employees 36 24 30 Maintenance hours 2,500 2,000 4,000 Information for the two production departments is given below: Assembly Packaging Directly traced overhead $167,060 $120,090 Square feet occupied 2,100 1,400 Number of employees 42 18 Maintenance hours...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and packaging. Information for the three service departments is given below: Admin Maint Person Directly traced overhead $65,000 $33,000 $74,000 Square feet occupied 2,000 3,500 3,000 Number of employees 42 24 30 Maintenance hours 2,500 2,000 4,000 Information for the two production departments is given below: Assembly Packaging Directly traced overhead $167,030 $114,090 Square feet occupied 2,100 1,400 Number of employees 36 18 Maintenance hours...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and packaging. Information for the three service departments is given below: Admin Maint Person Directly traced overhead $68,000 $46,000 $77,000 Square feet occupied 2,000 3,500 3,000 Number of employees 36 24 30 Maintenance hours 2,500 2,000 4,000 Information for the two production departments is given below: Assembly Packaging Directly traced overhead $167,060 $120,090 Square feet occupied 2,100 1,400 Number of employees 42 18 Maintenance hours...
A Company has two support departments (Administration and Janitorial) and three producing departments (Fabricating, Assembly, and...
A Company has two support departments (Administration and Janitorial) and three producing departments (Fabricating, Assembly, and Finishing). Costs and activities are as follows:                                          Administration      Janitorial       Fabricating       Assembly      Finishing Direct costs........................      $50,000            $30,000         $40,000         $50,000         $25,000 Number of employees.......                                        10                  30                  40                  20 Square feet........................          2,000                                    10,000           28,000           15,000 Direct labor hours..............                                                         5,000             6,000             2,000 Administrative services are allocated based on the number of employees; janitorial services are allocated based on square footage. Overhead rates for...
1.Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and...
1.Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded: Supplying Department Using Department Engineering Administration Maintenance Fabrication Assembly Engineering 0 50 % 0 10 % 40 % Administration 10 % 0 20 % 50 % 20 % Maintenance 0 20 % 0 20 % 60 % Direct cost $ 22,000 $ 193,300 $ 25,000 $ 180,000 $ 50,000    Required:...
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 $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...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded. Supplying Department Using Department Engineering Administration Maintenance Fabrication Assembly Engineering 0 40 % 0 15 % 45 % Administration 20 % 0 25 % 45 % 10 % Maintenance 0 30 % 0 15 % 55 % Direct cost $ 42,000 $ 248,550 $ 45,000 $ 230,000 $ 80,000 Required: Allocate...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT