Compensation Project1- Using the information from Chapters 3

Compensation Project1- Using the information from Chapters 3, 4, and 5, develop your method(s) for rewarding individual performance for the jobs in your organization.Be sure to justify why you chose the methods that you did and how you think it will help your company to achieve its strategic goals and properly motivate employees.2- Using the information from Chapter 8 and part 3 of your project, develop a pay structure(s) for your organization.Be sure to explain why you grouped certain jobs together and why you picked the pay ranges/spreads that you did. Also explain your strategy for dealing with red circle and green circle employeesjust these 2 instructionsI attached you part 3 cuz you will need it for thatIn the part 3 for i got 40 out of 100these are the notes from the doctor1. Pay Strategy is all about whether you will be leading, matching, or following/lagging the average pay of your competitors. (5/10)2-4. Where are the Excel files and equations for your pay. You did not provide an pay line formula to use to determine other salaries plus you did not use your benchmark salaries provided. the document named ‘compesation plan 12’ is the part 3i think you should have used the excel file for part 3, this one, I will attached when the question is assigned you don’t need to edit part 3, but you will use the pay line you did on part 3Btw i think you should have used the Excel for part 3,Look at the doctor’s notes about part 3