Departmental Cost Allocation using step method for P1 and P2

Check the final answer first, then review the worked steps.

Answer

\(P1: 146,300; P2: 295,300\)

Work

S1: $195,000. S2: $68,000 + ($195,000 \times 0.20) = $107,000.
P1: $45,000 + ($195,000 \times 0.30) + ($107,000 \times 0.40) = $146,300.
P2: $155,000 + ($195,000 \times 0.50) + ($107,000 \times 0.40) = $295,300.

Step-by-step solution

  1. Determine the missing percentages: For S1, the total is 100%, so $100\% - 20\% - 30\% = 50\%$. For S2, $100\% - 20\% - 40\% = 40\%$.
  2. Allocate S1 costs: S1 has $195,000. Allocate to S2 ($195,000 \times 0.20 = 39,000$), P1 ($195,000 \times 0.30 = 58,500$), and P2 ($195,000 \times 0.50 = 97,500$).
  3. Allocate S2 costs: S2 now has its original $68,000 plus the $39,000 from S1, totaling $107,000. Allocate this to P1 ($107,000 \times 0.40 = 42,800$) and P2 ($107,000 \times 0.40 = 42,800$).
  4. Calculate total costs: For P1, add original $45,000 + 58,500 + 42,800 = 146,300$. For P2, add original $155,000 + 97,500 + 42,800 = 295,300$.