The Manes Company has two products. Product 1 is manufactured entirely in Department X. Product 2 is manufactured entirely in Department Y. To produce these two products, the Manes Company has two service departments: A (a material handling department) and B (a power-generating department). An analysis of the work done by Departments A and B in a typical period is as follows:
|
Used by |
|||||
|
A |
B |
X |
Y |
||
|
Supplied by |
|||||
|
A |
--- |
100 |
250 |
150 |
|
|
B |
500 |
--- |
100 |
400 |
The work done in Department A is measured by the direct labour hours of material-handling time. The work done in Department B is measured by the kilowatt hours of power.
The budgeted costs of the service departments for the coming year are:
Department A Department B
Variable indirect costs $70,000 $10,000
Supervision $10,000 $10,000
Depreciation $20,000 $20,000
Total $100,000 $40,000
REQUIRED:
| The Manes Company | ||||
| Direct Method | ||||
| Supplied to | ||||
| Supplied by | Department X | Department Y | ||
| A | (250/(250+150))*$100000= | $ 62,500.00 | (150/250+150))*$100000= | $ 37,500.00 |
| B | (100/(100+400))*$40000= | $ 8,000.00 | (400/(100+400)*$40000= | $ 32,000.00 |
| $ 70,500.00 | $ 69,500.00 | |||
| Reciprocal Method | ||||
| Support Department | Operating Department | |||
| A | B | X | Y | |
| Manufacturing overhead cost | $ 1,00,000 | $ 40,000 | ||
| Allocation of departent A cost in the ratio of (100/500),(250/500),(150/500) to B,X and Y | $ -1,00,000 | $ 20,000 | $ 50,000 | $ 30,000 |
| $ 60,000 | ||||
| Allocation of departent B cost in the ratio of (500/1000),(100/1000),(400/1000) to A,X and Y | $ 30,000 | $ -60,000 | $ 6,000 | $ 24,000 |
| Allocation of departent A cost in the ratio of (100/500),(250/500),(150/500) to B,X and Y | $ -30,000 | $ 6,000 | $ 15,000 | $ 9,000 |
| Allocation of departent B cost in the ratio of (500/1000),(100/1000),(400/1000) to A,X and Y | $ 3,000 | $ -6,000 | $ 600 | $ 2,400 |
| Allocation of departent A cost in the ratio of (100/500),(250/500),(150/500) to B,X and Y | $ -3,000 | $ 600 | $ 1,500 | $ 900 |
| Allocation of departent B cost in the ratio of (500/1000),(100/1000),(400/1000) to A,X and Y | $ 300 | $ -600 | $ 60 | $ 240 |
| Allocation of departent A cost in the ratio of (100/500),(250/500),(150/500) to B,X and Y | $ -300 | $ 60 | $ 150 | $ 90 |
| Allocation of departent B cost in the ratio of (500/1000),(100/1000),(400/1000) to A,X and Y | $ 30 | $ -60 | $ 6 | $ 24 |
| Allocation of departent A cost in the ratio of (100/500),(250/500),(150/500) to B,X and Y | $ -30 | $ 6 | $ 15 | $ 9 |
| Allocation of departent B cost in the ratio of (500/1000),(100/1000),(400/1000) to A,X and Y | $ 3 | $ -6 | $ 1 | $ 2 |
| Allocation of departent A cost in the ratio of (100/500),(250/500),(150/500) to B,X and Y | $ -3 | $ - | $ 2 | $ 1 |
| Total budgeted overhead to operating depatment under reciprocal method | $ - | $ - | $ 73,333 | $ 66,666 |
The Manes Company has two products. Product 1 is manufactured entirely in Department X. Product 2...
Please, someone walk me through this :)
Davy Company has three products. Product 1 is manufactured
entirely in Department P1. Product 2 is manufactured entirely in
Department P2. Product 3 is manufactured entirely in Department P3.
To produce these products, Davy has three support departments: S1
(materials handling), S2 (milling), and S3 (power). Davy is
considering buying its power from an external supplier for $110.00
per kilowatt-hour (KWH). The budgeted variable costs and the
allocation bases for each support department...
2. The Galaxy Company has two service departments (Power and maintenance) and two production departments (Machinery and Assembly). Additional information is given below: Kilowatt Maintenance Cost Hours Hours Machinery 450,000 39,000 1,600 Assembly 210.000 15,000 2,400 Power 135,000 5,500 1,000 Maintenance 90,000 6,000 600 Costs of Power department are allocated on the basis of Kilowatt Hours. The Costs of Maintenance department are allocated on the basis of Maintenance Hours. Total machine hours worked in Machinery Department is 2,500 and total...
2. The Galaxy Company has two service departments (Power and maintenance) and two production departments (Machinery and Assembly). Additional information is given below: Kilowatt Maintenance Cost Hours Hours Machinery 450,000 39,000 1,600 Assembly 210.000 15,000 2,400 Power 135,000 5,500 1,000 Maintenance 90,000 6,000 600 Costs of Power department are allocated on the basis of Kilowatt Hours. The Costs of Maintenance department are allocated on the basis of Maintenance Hours. Total machine hours worked in Machinery Department is 2,500 and total...
Logan Products has two production departments—assembly and finishing. These are supported by two service departments—sourcing (purchasing and handling of materials and human resources) and operations (work scheduling, supervision, and inspection). Logan has the following labor hours devoted by each of the service departments to the other departments. Total Labor Hours Used by Departments Sourcing Operations Assembly Finishing Sourcing - 20,000 40,000 60,000 Operations 10,000 - 60,000 50,000 The costs incurred in the plant are as follows: Departments Departmental Costs Sourcing...
The Real McCoys Company has two service departments (S1 and S2) and two production departments (P1 and P2). Department S1 allocates service costs based on machine hours. S2 allocates service costs based on kilowatt hours. The company does NOT make a distinction between fixed and variable costs when allocating service costs. The budgeted total costs in the service departments for 2019 are $70,000 for S1 and $98,800 for S2. Budgeted machine hours and kilowatt hours for the year are as...
Hotchkiss Company has two support departments, Maintenance Department (MD) and Personnel Department (PD), and two producing departments, P1 and P2. The Maintenance Department costs of $90,000 are allocated on the basis of standard service hours used. The Personnel Department costs of $9,000 are allocated on the basis of number of employees. The direct costs of Departments P1 and P2 are $36,000 and $60,000, respectively. Data on standard service hours and number of employees are as follows: Maint. Dept. Person. Dept....
Seattle Western University has provided the following data to be used in its service department cost allocations: Service Departments Operating Departments Administration Facility Services Undergraduate Programs Graduate Programs Departmental costs before allocations $2,400,000 $1,600,000 $26,800,000 $5,700,000 Student credit-hours 20,000 5,000 Space occupied—square feet 25,000 10,000 70,000 30,000 Required: Using the direct method, allocate the costs of the service departments to the two operating departments. Allocate the Administration cost on the basis of student credit-hours and the Facility Services cost on...
Seattle Western University has provided the following data to be used in its service department cost allocations: Service Departments Facility Administration Services $2,400,000 $1,600,000 Operating Departments Undergraduate Graduate Programs Programs $26,800,000 $5,700,000 20,000 5,000 70,000 30,000 Departmental costs before allocations Student credit-hours Space occupied-square feet 25,000 10,000 Required: Using the direct method, allocate the costs of the service departments to the two operating departments. Allocate the Administration cost on the basis of student credit hours and the Facility Services cost...
Seattle Western University has provided the following data to be used in its service department cost allocations: Service Departments Operating Departments Facility Undergraduate Graduate Administration Services Programs Programs Departmental costs $2,400,000 $1,600,000 $26,800,000 $5,700,000 before allocations Student credit-hours 20,000 5,000 Space occupied-square 25,000 10,000 70,000 30,000 feet Required: Using the direct method, allocate the costs of the service departments to the two operating departments. Allocate the Administration cost on the basis of student credit hours and the Facility Services cost...
Clic Seattle Western University has provided the following data to be used in its service department cost allocations: Service Departments Facility Administration Services $1,600,000 Operating Departments Undergraduate Graduate Programs Programs $26,800,000 $5,700,000 20,000 5,000 70,000 30,000 Departmental costs before allocations Student credit hours Space occupied-square feet 25,000 10,000 Required: Using the direct method, allocate the costs of the service departments to the two operating departments. Allocate the Administration cost on the basis of student credit hours and the Facility Services...