Question

Alamo Power historically allocates IDC for its safety program to generation facilities in Cities A and B based on the number of employees. Last year, $300,000 was distributed and the employee count was 840 in city A and 450 in city B. Implementation of the ABC method took place this year to allocate IDC on the basis of number of accidents. City A reported 345 events and city B had 142 accidents reported.
Determine the allocation based on the number of employees. The allocation based on the number of employees is as follows:

City A:________
City B: _______

Answer 1

Answer:

Alamo Power

Allocation of IDC cost based on the number of employees:

City A = $195,349

City B = $104,651

Explanation:

a) Data and Calculations:

IDC cost = $300,000

                                   City A   City B    Total

Employee count          840      450      1,290

Number of accidents  345       142        487

Allocation of IDC cost based on the number of employees:

City A = 840/1,290 * $300,000 = $195,349

City B = 450/1,290 * $300,000 = $104,651

Total cost allocated =                  $300,000

Allocation of IDC cost based on the number of accidents:

City A = 345/487 * $300,000 = $212,526

City B = 142/487 * $300,000 =    $87,474