Write the answers obtained by this analysis below. 1. With a 7% raise, what is t

Question

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 Lawson’s 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

Explanation / Answer

Employee Name Current hourly Pay Rate Current Weekly Pay Rate Proposed hourly Pay Rate Proposed Weekly Pay Rate Baker 12 480 12.6 504 Caldwell 18 720 18.9 756 Davis 14.75 590 15.4875 619.5 Franks 21 840 22.05 882 Grayson 17 680 17.85 714 Harris 24 960 25.2 1008 Jackson 19 760 19.95 798 Johnson 14 560 14.7 588 Lawson 13.5 540 14.175 567 Michaels 17 680 17.85 714 Patterson 20 800 21 840 Steiner 27 1080 28.35 1134 Total 8690 9124.5 1 With a 7% raise, what is the total weekly cost of the raise? 608.3 2 With a 7% raise, what would the annual cost be?          483,512 =9298.3*52 3 What is the annual cost at 5% if we lower the hours per week input to 30? a b=a*30 c=a*105% d=c*30 Employee Name Current hourly Pay Rate Current Weekly Pay Rate Proposed hourly Pay Rate Proposed Weekly Pay Rate Baker               12.00       360.00         12.60       378.00 Caldwell               18.00       540.00         18.90       567.00 Davis               14.75       442.50         15.49       464.63 Franks               21.00       630.00         22.05       661.50 Grayson               17.00       510.00         17.85       535.50 Harris               24.00       720.00         25.20       756.00 Jackson               19.00       570.00         19.95       598.50 Johnson               14.00       420.00         14.70       441.00 Lawson               13.50       405.00         14.18       425.25 Michaels               17.00       510.00         17.85       535.50 Patterson               20.00       600.00         21.00       630.00 Steiner               27.00       810.00         28.35       850.50 Total 6517.5 6843.375 Annual cost would be    355,855.50 =6843.375*52 4.    Compromise with the employees and offer an 5% raise, but cut the per-week hours to 36. a b=a*36 c=a*105% d=c*36 Employee Name Current hourly Pay Rate Current Weekly Pay Rate Proposed hourly Pay Rate Proposed Weekly Pay Rate Baker               12.00       432.00         12.60       453.60 Caldwell               18.00       648.00         18.90       680.40 Davis               14.75       531.00         15.49       557.55 Franks               21.00       756.00         22.05       793.80 Grayson               17.00       612.00         17.85       642.60 Harris               24.00       864.00         25.20       907.20 Jackson               19.00       684.00         19.95       718.20 Johnson               14.00       504.00         14.70       529.20 Lawson               13.50       486.00         14.18       510.30 Michaels               17.00       612.00         17.85       642.60 Patterson               20.00       720.00         21.00       756.00 Steiner               27.00       972.00         28.35    1,020.60 Total 7821 8212.05 a.    What is the weekly cost to the company?___ 8212.05 b. What is the annual cost?__ 427026.6 =8212.05*52 c. What is Frank Lawson’s proposed weekly pay under this scenario? ____________ 8212.05

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.