Question

14. Assume United Way LA has several employees that share duties among departments. The Program department and the Fundraising department share these employees. The following data apply to the coming budget year:

Budgeted costs for the shared employees:

Salaries (total) $60,000

Total hours 4,000 hours total

Variable costs 35% of Salaries expense

Budgeted hour usage for each department per year:

Fundraising Department 1,800 hours

Program Department 2,200 hours

Actual usage for the year by Fundraising was 2,500 hours and by the Program Services Department was 1,500 hours.

What amount of shared salary costs should be allocated to Program Services? YOU ANSWER SHOULD NOT HAVE A DOLLAR SIGN NOR COMMAS. DO NOT USE CENTS, ROUND TO THE NEAREST WHOLE DOLLAR.

Answer 1

Total salaries = $60,000

Out of the above, 35% is variable. Hence, variable amount = 0.35*60,000 = $21,000. Hence, variable cost per hour = 21,000/4000 = $5.25/hour

Thus, the fixed component of salaries = $39000 [60,000 - 21,000]

The fixed cost of $39,000 will be allocated based on the budgeted hours. The program department is budgeted to use 2,200 hours out of a total 4000 hours. Hence, amount of fixed cost allocated to program department = [39000 * (2200/4000)] = $21,450

The variable cost will be allocated to program department based on the actual number of hours used by the program department i.e. 1,500 hours. Hence, amount of variable cost allocated to program department = 5.25*1500 = $7,875

Total cost allocated to program department = 21450+7875 = $29,325

If you find the above answer useful, request you to please take a moment to up-vote the same. It will help me to serve you better in future.