wage program excel

When you have no idea what to do with your written assignments, use a reliable paper writing service. Now you don’t need to worry about the deadlines, grades, or absence of ideas. Place an order on our site to get original papers for a low price.


Order a Similar Paper Order a Different Paper

This Assignment will involve the creation of a simple wage and salary program. You will complete this Assignment utilizing 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

Your task is to identify the ranking order of 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.

Now you have created an example of how a compensation professional creates pay grades for internal consistency and external competitiveness.

Here is the Assignment grading rubric.

Assignment submission: Before you submit your Assignment, you should save your work on your computer in a location that you will remember in Excel format. Save the document using the naming convention: Username_Unit3_Assignment.xlxs. Submit your file by selecting the Unit 3: Assignment Dropbox.

Writerbay.net

Get help with your complex tasks from our writing experts. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper