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

Alamo Power

Allocation of IDC cost based on the number of employees:

City A = $195,349

City B = $104,651

Step-by-step 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