Question

In: Accounting

Direct, sequential, and reciprocal allocation Ming Company has two service departments (S1 and S2) and two...

Direct, sequential, and reciprocal allocation
Ming Company has two service departments (S1 and S2) and two production departments (P1 and P2). Last year, directly identified overhead costs were $255,000 for S1 and $320,000 for S2.
Information on the consumption of their services follows:

Supplying User Departments
Departments S1 S2 P1 P2
S1 500 1,200 6,000 1,300
S2 800 200 7,000 9,000

(a) Determine the service department costs allocated to the two production departments using the direct method.
Note: Round each rate to two decimal places before calculating the allocated amounts. Round answers to the nearest dollar.

Rate Total
(rounded to 2 decimals) Total P1 Total P2 (any diff due to rounding)
S1 allocation amount Answer Answer Answer
S1 allocation amount Answer Answer Answer
Total service department costs Answer Answer Answer

(b) Determine the service department costs allocated to the two production departments using the sequential method beginning with the allocation of S1 department costs.
Note: Round each rate to two decimal places before calculating the allocated amounts. Round answers to the nearest dollar.

Total allocated service
department costs
P1 Answer
P2 Answer
Total (any diff due to rounding) Answer

(c) Determine the service department costs allocated to the two production departments using the reciprocal method.

Note: Do not round your computations; however, round your final answers to the nearest dollar.

Total allocated service
department costs
P1 Answer
P2 Answer
Answer

Solutions

Expert Solution

Hope you understood the solution. If you have any doubt please leave your doubt in the comment section so that I can clarify your doubt.

Thank You.

a P1 Allocation of Service department costs on the basis of Direct Method Particulars Total Cost P2 S1 Cost Distribution $255,000 $209,589 $45,411 S2 Cost distribution $320,000 $140,000 $180,000 $575,000 $349,589 $225,411 S1 Cost Allocation Cost allocated to P1 = (Total S1 cost) x (P1 Consumption/P1 Consumption+P2 Consumption) = $255,000 (6,000/(6,000 + 1,300)) = $209,589 Cost allocated to P2 = (Total S1 cost) x (P2 Consumption/P1 Consumption+P2 Consumption) = $255,000 X (1,300/(6,000 + 1,300)) = $45,411 S2 Cost Allocation Cost allocated to P1 = (Total S2 cost) (P1 Consumption/P1 Consumption+P2 Consumption) = $320,000 x (7,000/(7,000 + 9,000)) = $140,000 Cost allocated to P2 = (Total S2 cost) x (P2 Consumption/P1 Consumption+P2 Consumption) = $320,000 x (9,000/(7,000 + 9,000)) = $180,000

P1 b Allocation of Service department costs on the basis of Sequential Method Particulars si S2 P2 TOTAL COST $255,000 $320,000 S1 Cost Distribution $36,000 $180,000 $39,000 S2 Cost Distribution ($356,000) $155,750 $200,250 TOTAL COST ALLOCATED $335,750 $239,250 S1 Cost Allocation Cost allocated to P1 = (Total S1 cost) x (P1 Consumption/P1 Consumption+P2 Consumption+S2consumption) = $255,000 X (6,000/6,000 + 1,300 +1,200)) = $180,000 Cost allocated to P2 = (Total S1 cost) x (P2 Consumption/P1 Consumption+P2 Consumption+S2consumption) = $255,000 X (6,000/6,000 + 1,300 +1,200)) = $39,000 Cost allocated to S2 = (Total S1 cost) x (S2 Consumption/P1 Consumption+P2 Consumption+S2consumption) = $255,000 X (1,200/6,000 + 1,300 +1,200)) = $36,000 S2 Cost Allocation Cost allocated to P1 = (Total S2 cost) x (P1 Consumption/P1 Consumption+P2 Consumption) = $356,000 x (7,000/(7,000 + 9,000)) = $155,750 Cost allocated to P2 = (Total S2 cost) x (P2 Consumption/P1 Consumption+P2 Consumption) = $356,000 x (9,000/(7,000+ 9,000)) = $200,250


Related Solutions

Direct, sequential, and reciprocal allocation Ming Company has two service departments (S1 and S2) and two...
Direct, sequential, and reciprocal allocation Ming Company has two service departments (S1 and S2) and two production departments (P1 and P2). Last year, directly identified overhead costs were $300,000 for S1 and $300,000 for S2. Information on the consumption of their services was as follows: User Departments Supplying Departments S1 S2 P1 P2 S1 0% 40% 30% 30% S2 25% 0% 25% 50% Required: a) Determine the service department costs allocated to the two production departments using the direct method....
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and...
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 — 10 % 20 % ? % S2 10 % — ? 30 The direct operating costs of the departments (including both variable and fixed costs) are: S1 $ 180,000 S2 60,000 P1 50,000 P2 120,000 Required: 1. Determine the total cost...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and...
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 $220,000 S2 $74,000 P1 $61,000 P2 $175,000 Required: 1. Determine the total cost of...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and...
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 $ 265,000 S2 83,000 P1 70,000 P2 220,000 Required: 1. Determine the total cost...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and...
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 - 20% 30% ?% S2 20% - ? 40% The direct operating costs of the departments (including both variable and fixed costs) are: S1 $ 220,000 S2 $74,000 P1 $ 61,000 P2 $175,000 Required: 1. Determine the total cost of P1 and...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and...
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 $ 250,000 S2 80,000 P1 67,000 P2 205,000 Required: 1. Determine the total cost...
Motorcade Company has three service departments (S1, S2, and S3) and two production departments (P1 and...
Motorcade Company has three service departments (S1, S2, and S3) and two production departments (P1 and P2). The following data relate to Motorcade's allocation of service department costs: Round to two decimal places. Budgeted Costs Nbr of Employees S1 $3,120,000 75 S2 2,060,000 50 S3 1,000,000 25 P1 150 P2 225 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...
Craylon Corp has two service departments, S1 and S2, and two production departments, P1 and P2....
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 25% 40% 35% S2 $80,000 10% 55% 35% Fixed Costs P1 $400,000 P2 $500,000 One of the algebraic equations in linear form for an activity using the reciprocal method is S2 = 80,000 +.25S1 S1=100,000 + .25S2 S2 = 80,000 + .35S1 S1 = 100,000 +.10S2
Campaign Printing has two service departments, S1 and S2, and two production departments, P1 and P2....
Campaign Printing has two service departments, S1 and S2, and two production departments, P1 and P2. The data for May were as follows: Services provided to: Activity Pre-allocation Costs S1 S2 P1 P2 S1 $90,000 10% 40% 50% S2 $60,000 20% 55% 25% Pre-allocation Costs P1 $360,000 P2 $520,000 Required: Allocate service departments costs (S1 & S2) to the production departments (P1 & P2) using reciprocal method Set up linear equations to solve for the total costs incurred in S1...
Leader Company has two support departments (S1 and S2) and two producing departments (P1 and P2)....
Leader Company has two support departments (S1 and S2) and two producing departments (P1 and P2). Estimated direct costs and percentages of services used by these departments are as follows: Allocation of support departments S1 S2 P1 P2 S1              - 10% 40% 50% S2 20% - 50% 30% Direct costs £4,500 £8,000 £10,000 £15,000         Required: a. Prepare a schedule allocating the support department costs to the producing departments using the direct allocation method. b. Prepare a schedule allocating the support...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT