This Assignment will involve the creation of a simplewage and salary program. Use This assignment should utilize Excel. You will find the grading rubric for this Assignment following the case study.

Case Study:

This organization has over 10 different positions; due to the lack of having an HR professional who understands compensation issues, it is without any salary structure for the employees.

The job titles are:

• Operator
• Mechanic
• Electrician
• Supervisor
• Administrative Assistant
• Sales Professional
• Sales Manager
• HRM Manager
• Operations Manager
• President

Identify theranking orderof these jobs in the business based on least to most value to the organization.

This is accomplished by the following:

1.You will need to do some research at salary.com and benchmark these positions using regional data or national data and rank the salaries of the employees.

2.You can use an objective point system to assign points using compensable factors for the jobs as well.

3.Next, you will tally the points for each position and assign these jobs to specific pay grades.