Exercise 7-28 (Algo) Departmental Cost Allocation. Determine total costs of adverti...

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

Answer

Advertising: $92,560; Sales: $126,440

Work

Actuarial: $86,000. Premium: $21,000 + $68,800 = $89,800. Advertising: $66,000 + $8,600 + ($89,800 0.2) = $92,560. Sales: $46,000 + $8,600 + ($89,800 0.8) = $126,440.

Step-by-step solution

Step 1: Identify the order of allocation. The Actuarial department serves 80% of Premium Rating, while Premium Rating serves 25% of Actuarial. Since Actuarial provides more service to Premium Rating than vice versa, allocate Actuarial first.
Step 2: Allocate Actuarial costs ($86,000). Distribute to Premium Rating (80%), Advertising (10%), and Sales (10%).
- Premium Rating: $86,000 \times 0.80 = $68,800
- Advertising: $86,000 \times 0.10 = $8,600
- Sales: $86,000 \times 0.10 = $8,600
Step 3: Calculate the new total for Premium Rating. Original cost ($21,000) + Allocated from Actuarial ($68,800) = $89,800.
Step 4: Allocate Premium Rating costs ($89,800). Distribute to Advertising (15%) and Sales (60%). Note: The remaining 25% is ignored as it was already allocated to Actuarial.
- Advertising: $89,800 \times (0.15 / (0.15 + 0.60)) = $89,800 \times 0.20 = $17,960
- Sales: $89,800 \times (0.60 / (0.15 + 0.60)) = $89,800 \times 0.80 = $71,840
Step 5: Sum the total costs for Advertising and Sales.
- Advertising: $66,000 (original) + $8,600 (from Actuarial) + $17,960 (from Premium) = $92,560
- Sales: $46,000 (original) + $8,600 (from Actuarial) + $71,840 (from Premium) = $126,440