Determine the total estimated overhead cost for each of the producing departments a...

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

Answer

a. P1: $219,000, P2: $283,500; b. P1: $187,000, P2: $315,500; c. P1: $195,000, P2: $307,500; d. P1: $207,000, P2: $295,500

Work

a. P1: 159,000 + (80,000 0.75) = 219,000; P2: 263,500 + (80,000 0.25) = 283,500
b. P1: 159,000 + (80,000 0.35) = 187,000; P2: 263,500 + (80,000 0.65) = 315,500
c. P1: 159,000 + (80,000 0.45) = 195,000; P2: 263,500 + (80,000 0.55) = 307,500
d. P1: 159,000 + (80,000 0.60) = 207,000; P2: 263,500 + (80,000 0.40) = 295,500

Step-by-step solution

  1. Identify the total service department cost to allocate: $S1 = \$80,000$.
  2. For each base, find the total units (or percentage) used by P1 and P2, then calculate the allocation ratio for each department.
  3. Multiply the $S1$ cost by the ratio and add it to the department's existing overhead ($P1 = \$159,000$, $P2 = \$263,500$).
  • Employee Headcount: Total = $60 + 20 = 80$. P1 share = $60/80 = 0.75$; P2 share = $20/80 = 0.25$. Allocation: P1 = $159,000 + (80,000 \times 0.75) = 219,000$; P2 = $263,500 + (80,000 \times 0.25) = 283,500$.
  • Space Used: Total = $4,900 + 9,100 = 14,000$. P1 share = $4,900/14,000 = 0.35$; P2 share = $9,100/14,000 = 0.65$. Allocation: P1 = $159,000 + (80,000 \times 0.35) = 187,000$; P2 = $263,500 + (80,000 \times 0.65) = 315,500$.
  • Productive Capacity: Total = $58,950 + 72,050 = 131,000$. P1 share = $58,950/131,000 \approx 0.45$; P2 share = $72,050/131,000 \approx 0.55$. Allocation: P1 = $159,000 + (80,000 \times 0.45) = 195,000$; P2 = $263,500 + (80,000 \times 0.55) = 307,500$.
  • 3-year Average: P1 share = $60\%$; P2 share = $40\%$. Allocation: P1 = $159,000 + (80,000 \times 0.60) = 207,000$; P2 = $263,500 + (80,000 \times 0.40) = 295,500$.