Please help me with the following: Note: Complete the Pay Raise Worksheet on pag
ID: 364068 • Letter: P
Question
Please help me with the following:
Note: Complete the Pay Raise Worksheet on page 343 and distribute the money. Justify your distribution using a quantitative decisions process.
((((( Pay Raise Worksheet )))))
April Knepper is the new supervisor of an assembly team. It is time for her to make pay raise allocation for her subordinates. She has been budgeted $30,000 to allocate among her seven subordinates as pay raises. There have been some ugly grivances in other work teams over past allocations, so Knepper has been advised to base that allocations on objective criteria that can be quantified, weighted, and computed in numerial terms. After she makes her allocations, Knepper must be prepared to justigy her decisions. All of the evaluative criteria available to Knepper are summarized as follows:
Supervisory Ratings
--------------------------------------------------------------------------------------------------------------------------
Employee
Absent Rate
Employee
Absent Rate
Explanation / Answer
Base on Pay Raise Worksheet Figure page 365. I will build up a positioning/rating framework for 7 representatives and salary increase assignment for $30,000.
Positioning/rating System point base on:
Employee
Seniority
Seniority Ratings
David Bruce
15 yrs.
7
Eric Cattalini
12 yrs.
6
Chua Li
7 yrs.
3
Marilee Miller
1 yr.
1
Victor Munoz
3 yrs.
2
Derek Thompson
11 yrs.
5
Sarah Vickers
8 yrs.
4
Employee
Output Rating*
Output rating compared to 100%
Output ranking
David Bruce
0.58
58
2
Eric Cattalini
0.86
86
7
Chua Li
0.8
80
6
Marilee Miller
0.5
50
1
Victor Munoz
0.62
62
3
Derek Thompson
0.64
64
4
Sarah Vickers
0.76
76
5
Employee
Absent Rate
Assuming No. of days Absent in a month according to the percentage given
Absent Rating
David Bruce
0.50%
1
7
Eric Cattalini
2
5
6
Chua Li
3.5
7
4
Marilee Miller
10
21
1
Victor Munoz
2.5
5
5
Derek Thompson
8
17
2
Sarah Vickers
7
15
3
Employee
Seniority Ratings
Output ranking
Absent Rating
Skills Rating
Initiative Rating
Attitude Rating
Total Points
Pay Raise
David Bruce
7
2
7
3
1
1
21
$5000
Eric Cattalini
6
7
6
4
3
4
30
$9000
Chua Li
3
6
4
3
4
4
24
$6000
Marilee Miller
1
1
1
1
1
1
6
$1000
Victor Munoz
2
3
5
1
2
3
16
$2000
Derek Thompson
5
4
2
4
2
2
19
$3000
Sarah Vickers
4
5
3
3
1
1
17
$4000
Explanation of interchange of the Pay Raise of David Bruce and Victor Munoz: when I compare the performance of the David Bruce and Victor Munoz because of the experience ratings Victor got less so I feel he should get the amount offered to David according to the performance as performance is the main view when productivity of the organization is concerned so I’m interchanging the amount.
Employee
Seniority Ratings
Output ranking
Absent Rating
Skills Rating
Initiative Rating
Attitude Rating
Total Points
Pay Raise
David Bruce
7
2
7
3
1
1
21
$2000
Eric Cattalini
6
7
6
4
3
4
30
$9000
Chua Li
3
6
4
3
4
4
24
$6000
Marilee Miller
1
1
1
1
1
1
6
$1000
Victor Munoz
2
3
5
1
2
3
16
$5000
Derek Thompson
5
4
2
4
2
2
19
$3000
Sarah Vickers
4
5
3
3
1
1
17
$4000
Employee
Seniority
Seniority Ratings
David Bruce
15 yrs.
7
Eric Cattalini
12 yrs.
6
Chua Li
7 yrs.
3
Marilee Miller
1 yr.
1
Victor Munoz
3 yrs.
2
Derek Thompson
11 yrs.
5
Sarah Vickers
8 yrs.
4