identify the ranking order of these jobs in the business based on least to most value to the organization

Case Study on Creating a Wage and Salary Pay Grade System

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 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

HR 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:

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.

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

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

GB520 Unit 6 Assignment Rubric
Course: GB520 Strategic Human Resource Management
Criterion 1
(40%)
Research
support for a
salary pay
grade system
Level III Max
Points
30 points
Level II Max
Points
25.5 points
Level I Max
Points
21 points
Not Present
0 points
Meets all
criteria:
Meets two
criteria:
Meets one
criterion:
Does not meet
any criteria.
● Salary.com
site utilized
for
assignment
components
as
appropriate
● Salary.com
site utilized for
assignment
components
as
appropriate
● Salary.com
site utilized for
assignment
components
as
appropriate
● Evidence of
researching
both regional
and national
data
information
● Evidence of
researching
both regional
and national
data
information
● Research
data properly
integrated into
final pay grade
system
recommendati
on.
● Research
data properly
integrated into
final pay grade
system
recommendati
on.
● Evidence of
researching
both regional
and national
data
information
● Research
data properly
integrated
into final pay
grade system
recommendati
on.
Criterion Score
/ 30
Criterion 2
(40%)
Establishmen
t of rank
order
compensatio
n system
Level III Max
Points
30 points
Level II Max
Points
25.5 points
Level I Max
Points
21 points
Not Present
0 points
Meets all
criteria:
Meets two
criteria:
Meets one
criterion:
Does not meet
any criteria.
●
Compensation
factor
alignment with
the objective
points system
is evident.
● Compensati
on factor
alignment with
the objective
points system
is evident.
Compensation
factor
alignment with
the objective
points system
is evident.
● Job
evaluation
point system
developed and
defended
● Job
evaluation
point system
developed and
defended
● Pay grade
● Pay grade
structure
offered and
advocated with
proper
reference/met
hod support.
structure
offered and
advocated with
proper
reference/met
hod support.
Level II Max
Points
6.375 points
Level I Max
Points
5.25 points
● Job
evaluation
point system
developed and
Criterion Score
/ 30
defended
● Pay grade
structure
offered and
advocated with
proper
reference/met
hod support.
Criterion 3
(10%)
Level III Max
Points
7.5 points
Not Present
0 points
Criterion Score
Criterion 3
(10%)
APA Style
Level III Max
Points
7.5 points
Level II Max
Points
6.375 points
Level I Max
Points
5.25 points
Not Present
0 points
Meets all
criteria:
Meets two
criteria:
Meets one
criterion:
Does not meet
any criteria.
● Applies APA
style to in-text
citations with
minor errors
● Applies APA
style to intext
citations with
minor errors
● Applies APA
style to intext
citations with
minor errors
● Applies APA
style to
references,
with
minor to no
errors
● Resources
are from
reliable and/or
● Applies APA
style to
references,
with minor to
no errors
Level III Max
Points
7.5 points
/ 7.5
● Applies APA
style to
references,
with minor to
no errors
● Resources
are from
reliable and/or
scholarly
sources.
scholarly
sources.
Criterion 4
(10%)
Criterion Score
● Resources
are from
reliable and/or
scholarly
sources.
Level II Max
Points
6.375 points
Level I Max
Points
5.25 points
Not Present
0 points
Criterion Score
Criterion 4
(10%)
Writing
Conventions
Level III Max
Points
7.5 points
Level II Max
Points
6.375 points
Level I Max
Points
5.25 points
Not Present
0 points
Meets all
criteria:
Meets three
criteria:
Meets one or
two criteria:
Does not meet
any criteria.
● Writing is
focused,
concise and
● Writing is
focused,
concise and
● Writing is
focused,
concise and
organized
organized
organized
● Articulates
at a college
level
● Articulates
at a college
level
● Articulates
at a college
level
● Few or no
grammar
or punctuation
errors
● Few or no
grammar or
punctuation
errors
● Few or no
grammar or
punctuation
errors
● Uses nonoffensive,
inclusive, and
respectful
language
● Uses nonoffensive,
inclusive, and
respectful
language
● Uses nonoffensive,
inclusive, and
respectful
language
Total
Criterion Score
/ 7.5
/ 75
Overall Score
Level III
Level II
Level I
Not Present
63.751 points minimum
52.501 points minimum
0.001 points minimum
0 points minimum