In: Accounting
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 and in P2 after allocation using the direct method?
REQ3. What is the total cost in P1 and P2 and what is the amount of service department cost allocated to P1 and P2 using the step method with S1 going first?
REQ4. What is the amount of service department cost allocated to P1 and P2 using the direct method if the cost in P1 is changed from $100,000 to $120,000?
Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Answer 1 and 2- Direct Method | S 1 | S 2 | P 1 | P 2 | Total |
S 1 | 35.00% | 35.00% | 70.00% | ||
S 1 % | 50.00% | 50.00% | 100.00% | ||
S 2 | 20.00 | 60.00 | 80.00 | ||
S 2 % | 25.00% | 75.00% | 100.00% | ||
Total costs | 30,000.00 | 20,000.00 | 100,000.00 | 150,000.00 | 300,000.00 |
S 1 costs allocated | (30,000.00) | 15,000.00 | 15,000.00 | - | |
S 2 costs allocated | (20,000.00) | 5,000.00 | 15,000.00 | - | |
Total cost after allocation | - | - | 120,000.00 | 180,000.00 | 300,000.00 |
Answer 3- Step Method | S 1 | S 2 | P 1 | P 2 | Total |
S 1 | 30% | 35.00% | 35.00% | 100% | |
S 1 % | 30.00% | 35.00% | 35.00% | 100.00% | |
S 2 | 20.00 | 60.00 | 80.00 | ||
S 2 % | 25.00% | 75.00% | 100.00% | ||
Total costs | 30,000.00 | 20,000.00 | 100,000.00 | 150,000.00 | 300,000.00 |
S 1 costs allocated | (30,000.00) | 9,000.00 | 10,500.00 | 10,500.00 | - |
Total | - | 29,000.00 | 110,500.00 | 160,500.00 | 300,000.00 |
S 2 costs allocated | - | (29,000.00) | 7,250.00 | 21,750.00 | - |
Total cost after allocation | - | - | 117,750.00 | 182,250.00 | 300,000.00 |
Answer 4- Direct Method | S 1 | S 2 | P 1 | P 2 | Total |
S 1 | 35.00% | 35.00% | 70.00% | ||
S 1 % | 50.0% | 50.0% | 100.00% | ||
S 2 | 20.00 | 60.00 | 80.00 | ||
S 2 % | 25.00% | 75.00% | 100.00% | ||
Total costs | 30,000.00 | 20,000.00 | 120,000.00 | 150,000.00 | 320,000.00 |
S 1 costs allocated | (30,000.00) | 15,000.00 | 15,000.00 | - | |
S 2 costs allocated | (20,000.00) | 5,000.00 | 15,000.00 | - | |
Total cost after allocation | - | - | 140,000.00 | 180,000.00 | 320,000.00 |