please help answer table 2

Compensation Compensation of employees includes both direct compensation through wages and indirect through benefits. In this assignment you will calculate the total cost of compensation for your firm in its starting situation and also calculate the impact of changes in wages and benefits. 1. Calculate the total compensation for each employee level, then calculate the hourly wage and hourly compensation. Assume 520 hours in the quarter. Job Quarterly Benefits Total Hourly Level Wage @ 20% Hourly Wage Compensation Compensation 5 $18,000 3600 21600 34.61538 0.066 4 $14,000 2800 16800 26.92308 26 3 $12,000 2400 14400 23.07692 2 $10,000 2000 12000 19.23077 1 $8,000 1600 9600 15.38462 2. You would like to give a 5% raise to all employees. Calculate the dollar amount of the raise for each level. Then, given the number of employees at each level, calculate the total cost of the raise-this is the amount that would be charged against the budget. Finally, calculate the total payroll amount including the raise. Job Quarterly Number of 5% Raise Cost of Raise Payroll with Raise Level Wage Employees 5 $18,000 20 4 $14,000 25 3 $12,000 50 2 $10,000 60 1 $8,000 500 Totals