Question

In: Accounting

Exercise 7-29 Departmental Cost Allocation [LO 7-3] Robinson Products Company has two service departments (S1 and...

Exercise 7-29 Departmental Cost Allocation [LO 7-3]

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 $ 170,000
S2 64,000
P1 51,000
P2 125,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 step method.

3. Determine the total cost of P1 and P2 using the reciprocal method.

Solutions

Expert Solution

Solution:

Workings:

Let X be the total cost of S1 Department

   & Y be the total cost of S2 Department

Then,

                X = $170,000 + 20% of Y

                Y = $64,000 + 20% of X

Therefore, the equations will be:

                X = $170,000 + 0.2 Y              ......................           (1)

                Y = $64,000 + 0.2 X                ......................           (2)

Solving the Above Two Equation:

On Multiplying both equation by 10, we get

10 X = $1,700,000 + 2 Y                         ......................           (3)

10 Y =    $640,000 + 2 X                         ......................           (4)

Now, multiplying equation (3) by 5, we get

50 X = $8,500,000 + 10 Y                   ......................           (5)

Rearranging & adding equation (4) & (5), we get

                 50 X = $8,500,000 + 10 Y

                - 2 X =     $640,000 – 10 Y

                48 X = $9,140,000

                       X = $190,417

Substituting this value in equation (4), we get

10 Y = $640,000 + 2 X

10 Y = $640,000 + 2 × $190,417

10 Y = $1,020,834

     Y = $102,083

Hence, Total cost of S1 Dept. = $190,416.67 & S2 Dept. = $102,083


Related Solutions

Exercise 7-28 Departmental Cost Allocation [LO 7-3, 7-5] HomeLife Life Insurance Company has two service departments...
Exercise 7-28 Departmental Cost Allocation [LO 7-3, 7-5] HomeLife Life Insurance Company has two service departments (actuarial and premium rating) and two production departments (advertising and sales). The distribution of each service department’s efforts (in percentages) to the other departments is shown in the following table: To From Actuarial Premium Rating Advertising Sales Actuarial — 80 % 10 % 10 % Premium 20 % — 20 60 The direct operating costs of the departments (including both variable and fixed costs)...
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...
Exercise 11-29 Cost Allocation: Step Method (LO 11-3) Caro Manufacturing has two production departments, Machining and...
Exercise 11-29 Cost Allocation: Step Method (LO 11-3) Caro Manufacturing has two production departments, Machining and Assembly, and two service departments, Maintenance and Cafeteria. Direct costs for each department and the proportion of service costs used by the various departments for the month of August follow: Proportion of Services Used by Department Direct Costs Maintenance Cafeteria Machining Assembly Machining $ 120,000 Assembly 80,000 Maintenance 53,000 — 0.2 0.5 0.3 Cafeteria 42,000 0.7 — 0.2 0.1 Required: Use the step method...
The following information is departmental cost allocation with two service departments and two production departments. Percentage...
The following information is departmental cost allocation with two service departments and two production departments. Percentage Service Provided to Department Cost S1 S2 P1 P2 Service 1 (S1) $ 30,000 0 % 30 % 35 % 35 % Service 2 (S2) 20,000 20 0 20 60 Production 1 (P1) 100,000 Production 2 (P2) 150,000 REQ1. What is the amount of service department cost allocated to P1 and P2 using the direct method? REQ2. What is the total cost in P1...
The following information is departmental cost allocation with two service departments and two production departments. Percentage...
The following information is departmental cost allocation with two service departments and two production departments. Percentage Service Provided to Department Cost S1 S2 P1 P2 Service 1 (S1) $ 42,000 0 % 25 % 45 % 30 % Service 2 (S2) 32,000 20 0 20 60 Production 1 (P1) 220,000 Production 2 (P2) 270,000 What is the amount of service department cost allocated to P1 and P2 using the direct method?
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....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT