Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In cells G6:G13, add a 1iqutCIICIKUP function that returns the sterling raise percentage based on the ranges in the Standard Raise table in cells A16:B19

image text in transcribed
In cells G6:G13, add a 1iqutCIICIKUP function that returns the sterling raise percentage based on the ranges in the Standard Raise table in cells A16:B19 and the number of years employed in column E. Next, you need to begin determining the employee's final raise. Add the following. In cells H6:H13, add an IF function that will award anyone with a Raise Recommend of High an extra bonus listed in cell F2. All other employees get zero bonus. In cells I6:I13, add an [F flmction that will give anyone with a Raise Recommend of Low a deduction listed in cell F3. All other employees get zero deduction. Cur the Payroll worksheet, in cells 16:11.3, add a calculation that returns the nal raise amount with the valuenot just formattedrounded to the hundreds position (2). For example, a final raise of $1,625 rounded to the hundreds returns a value of $1,606. The nal raise amount is the salary multiplied by the Standard Raise 91': and then adding any bonus and subtracting any deduction. On the Payroll worksheet, in cells K6:K13, add a calculation that returns the Final '56 Increase. The final increase is determined by dividing the RaiseAmt by the Salary. In cells L6:L13, add a calculation that returns the New Salary by adding the Salary and Raise Amt. You now need to add a few summary measures for upper management. Add the following on the Payroll worksheet. In cell J 1, add a function that calculates the total Net Payroll increase based on the Raise Amt in cells 16:113. In cell J2, add a function that calculates the Average Raise 96 based on the Final 96 increase in cells K6:K13. On the Payroll worksheet, based on the data in cells A5:A13 and K5:K13, add a 3D Clustered Column. Under chart styles, set the chart to Style 3. Change the vertical axis to start at a lower bound of [1.61 for 1%. Then, change the title to read Final % Increase Comparison. Move and resize the chart so the upperleft comer is in cell F14 and the lowerright corner is in cdl L22. Set the rrart title to 11 3 font. If necessgy, set the vertical and horizontal axis labels to 9 pt font. Click Save, close Excel, and then submit the le as directed by your instructor

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Payroll Accounting 2020

Authors: Jeanette Landin

6th Edition

1260247961, 9781260247961

More Books

Students also viewed these Accounting questions

Question

1. Can they separate relevant from irrelevant information?

Answered: 1 week ago