| Distribution table | ||||
| To | ||||
| From | S1 | S2 | P1 | P2 |
| S1 | - | 20% | 30% | 50% |
| S2 | 20% | - | 40% | 40% |
| 1) | Direct Method | ||||||
| Under this method, the cost of service dept. are directly apportioned | |||||||
| to production depts. , without taking into consideration any service | |||||||
| from one service dept. to another service dept. | |||||||
| Particulars | P1 | P2 | S1 | S2 | |||
| Total Costs | $ 63,000.00 | $ 185,000.00 | $ 255,000.00 | $ 85,000.00 | |||
| Distribution of : | |||||||
| S1 | $ 95,625.00 | $ 159,375.00 | $ (255,000.00) | ||||
| S2 | $ 42,500.00 | $ 42,500.00 | $ (85,000.00) | ||||
| Total | $ 201,125.00 | $ 386,875.00 | $ - | $ - | |||
| 2) | Step Method | ||||||
| In this method, the cost of most serviceable dept. is first apportioned to | |||||||
| other service dept. and production depts. The next service dept. is taken | |||||||
| up and its cost is apportioned and this process goes on till the cost of last | |||||||
| service dept. is apportioned. The cost of last service dept. among production | |||||||
| dept. only. | |||||||
| Particulars | P1 | P2 | S1 | S2 | |||
| Total Costs | $ 63,000.00 | $ 185,000.00 | $ 255,000.00 | $ 85,000.00 | |||
| Distribution of: | |||||||
| S1 | $ 76,500.00 | $ 127,500.00 | $ (255,000.00) | $ 51,000.00 | |||
| $ 139,500.00 | $ 312,500.00 | $ - | $ 136,000.00 | ||||
| S2 | $ 54,400.00 | $ 54,400.00 | $ 27,200.00 | $ (136,000.00) | |||
| $ 193,900.00 | $ 366,900.00 | $ 27,200.00 | $ - | ||||
| S1 | $ 8,160.00 | $ 13,600.00 | $ (27,200.00) | $ 5,440.00 | |||
| $ 202,060.00 | $ 380,500.00 | $ - | $ 5,440.00 | ||||
| S2 | $ 2,176.00 | $ 2,176.00 | $ 1,088.00 | $ (5,440.00) | |||
| $ 204,236.00 | $ 382,676.00 | $ 1,088.00 | $ - | ||||
| S1 | $ 326.40 | $ 544.00 | $ (1,088.00) | $ 217.60 | |||
| $ 204,562.40 | $ 383,220.00 | $ - | $ 217.60 | ||||
| S2 | $ 108.80 | $ 108.80 | $ (217.60) | ||||
| $ 204,671.20 | $ 383,328.80 | $ - | $ - | ||||
| 3) | Reciprocal Method | ||||||
| This method gives cognizance to the fact that where there are two | |||||||
| or more service depts, they may render services to each other, and | |||||||
| therefore these inter-departmental services are to be given due weight | |||||||
| in distributing the expenses of service depts. There are three methods | |||||||
| available to deal with inter service departmental transfer: | |||||||
| 1) Simultaneous equation method (I'll be using this one) | |||||||
| 2) Repeated Distribution method | |||||||
| 3)Trial and error method | |||||||
| Let the total cost of Dept. S1 be "x" and that of S2 be "y" | |||||||
| Therefore, x = $ 255,000 + 20% of y | y = $ 85,000 + 20% of x | ||||||
| or, | x = $ 255,000 + 0.2y…(1) | or, y = $ 85,000 + 0.2x…(2) | |||||
| Now, putting the value of "y" in (1), we get | |||||||
| x = $ 255,000 + 0.2 ( $ 85,000 + 0.2x) | |||||||
| x= $ 255,000 + $ 17000 + 0.04 x | |||||||
| 0.96 x = $ 272,000 | |||||||
| x = $ 283,333 | |||||||
| and | y = $ 85,000 + 0.2 ( $ 283,333) | ||||||
| y = $ 141,666 | |||||||
| Particulars | P1 | P2 | S1 | S2 | |||
| Total Costs | $ 63,000.00 | $ 185,000.00 | $ 255,000.00 | $ 85,000.00 | |||
| Distribution of: | |||||||
| S1 | $ 84,999.90 | $ 141,666.50 | $ (283,333.00) | $ 56,666.60 | |||
| $ 147,999.90 | $ 326,666.50 | $ (28,333.00) | $ 141,666.60 | ||||
| S2 | $ 56,666.40 | $ 56,666.40 | $ 28,333.20 | $ (141,666.00) | |||
| Total | $ 204,666.30 | $ 383,332.90 | $ - | $ - | |||
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department's efforts (in percentages) to the other d...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department's efforts (in percentages) to the other departments is: To From S1 S2 P1 P2 S1 78 -20% 30% S2 20% 2 40 The direct operating costs of the departments (including both variable and fixed costs) are: Si $255,000 85,000 63,000 P2 185,000 S2 P1 Required: 1. Determine the total cost of P1 and P2 using the direct...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2) The distribution of each service department's efforts (in percentages) to the other departments is: 20 7 30 The direct operating costs of the departments (including both variable and fixed costs) are: S1 $225,000 $2 $2 2,000 P2 165,000 Required 1. Determine the total cost of P1 and P2 using the direct method. 2. Determine the total cost of P1 and P2 using the...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department's efforts (in percentages) to the other departments is: To S1 P1 From S1 S2 S2 10% 20% ? P2 ?% 30 10% The direct operating costs of the departments (including both variable and fixed costs) are: S1 S2 P1 P2 $ 225,000 72,000 59,000 165,000 Required: 1. Determine the total cost of P1 and P2 using the...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department’s efforts (in percentages) to the other departments is: From To S1 S2 P1 P2 S1 — 20% 30% ? % S2 20% — ? 40 The direct operating costs of the departments (including both variable and fixed costs) are: S1 $ 205,000 S2 71,000 P1 58,000 P2 160,000 Required: 1. Determine the total cost of P1 and...
Robinson Products Company has two service departments (51 and 52) and two production departments (P1 and P2). The distribution of each service department's efforts in percentages) to the other departments is: S1 From S1 S2 To S2 P1 20% 30% P2 ?% 40 20% The direct operating costs of the departments (including both variable and fixed costs) are: S1 S2 P1 P2 $ 235,000 77,000 64,000 190,000 Required: 1. Determine the total cost of P1 and P2 using the direct...
Craylon Corp has two service departments, S1 and S2, and two production departments, P1 and P2. The data for April were as follows: Services provided to: Activity Costs S1 S2 P1 P2 S1 (cost)$100,000 S1 none S2 20% p1 40% p2 50% S2 cost $80,000 s110% S2 none p1 55% p2 25% Fixed Costs P1 $400,000 P2 $500,000 Required: Allocate the service departments' (S1 & S2) costs to the two operating divisions using the reciprocal method.
Craylon Corp has two service departments, S1 and S2, and two production departments, P1 and P2. The data for April were as follows: Services provided to: Activity Costs S1 S2 P1 P2 S1 $100,000 20% 40% 50% S2 $80,000 10% 55% 25% Fixed Costs P1 $400,000 P2 $500,000 Required: Allocate the service departments' (S1 & S2) costs to the two operating divisions using the reciprocal method.
Cordner Corporation has two production departments, P1 and P2, and two service departments, S1 and S2. Direct costs for each department and the proportion of service costs used by the various departments for the month of July are as follows: Proportion of Services Used by: S1 S2 P1 0.70 0.10 0.20 0.20 0.30 0.50 Department Direct costs $ 60,000 $100,000 $160,000 $140,000 P2 Under the direct method of cost allocation, the amount of S1 costs allocated to S2 would be:...
The DuffyDog Company has three service departments, S1, S2, and
S3, and two production departments, P1 and P2. The following data
relate to DuffyDog’s allocation of service department costs:
Budgeted Costs
Number of Employees
S1
$4,637,000
89
S2
3,262,000
58
S3
2,618,000
40
P1
196
P2
294
Service department costs are allocated by the direct method. The
number of employees is used as the allocation base for all service
department costs.
(a)
Your answer is correct.
Allocate service department costs...
The Ceradyne Company has three service departments, S1, S2, and
S3, and two production departments, P1 and P2. The following data
relate to Ceradyne’s allocation of service department
costs:
Budgeted Costs
Number of Employees
S1
$4,101,000
87
S2
3,110,000
58
S3
2,865,000
37
P1
204
P2
306
Service department costs are allocated by the direct method. The
number of employees is used as the allocation base for all service
department costs.
Calculate the total service department cost allocated to each...