Write the answers obtained by this analysis below.

1. With a 7% raise, what is the total weekly cost of the raise? _____________

2. With a 7% raise, what would the annual cost be? ______________

3. What is the annual cost at 5% if we lower the hours per week input to 30? _________

4. Compromise with the employees and offer an 5% raise, but cut the per-week hours to 36.

a. What is the weekly cost to the company?_______________

b. What is the annual cost?__________________

c. What is Frank Lawsons proposed weekly pay under this scenario? ____________

LIGHTENING NEDIA PRODUCTION Payroll Analysis Report 5 6 EM?LOYEE 7 NAME CUIRRENT CUURRENT PROPOSED PROPOSED HOURLY WEEKLY HOURLY WEEKLY PAY RATE PAY PAY RATE PAY 9 Baker, Susan 10 Caldwell, Michael 11 Davis, George 12 Franks, Mark 13 Grayson, Kelly 14 Harris, Victor 15 Jackson, Danielle 16 Johnson, Carl 17 Lawson, Frank 18 Michaels, William 19 Patterson, George 20 Steiner, Roberta 21 $12.00 $18.00 $14.75 $21.00 $17.00 $24.00 $19.00 $14.00 $13.50 $17.00 $20.00 $480.00 $720.00 $590.00 $840.00 $680.00 $960.00 $760.00 $560.00 $540.00 $680.00 $800.00 $27.001,080.00 $28.35 $12.60 $18.90 $15.49 $22.05 $17.85 $25.20 $19.95 $14.70 $14.18 $17.85 $21.00 $504.00 $756.00 $619.50 $882.00 714.00 $1,008.00 $798.00 $588.00 $567.00 714.00 $840.00 $1,134.00 HOURS Per Week: % OF PAY RATE INCREASE: 5% TOTAL COST OF RAISE: $434.50 YEARLY COST OF RAISE: $22,594.00 TOTAL: $8,690.00 $9,124.50