compressed wage adjustment
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLM
1
2
$31.43
Contractual Wage (Book Rate)
3
0.8571429
Compression Factor
4
$26.94
Compressed Wage
5
1.5OT rate
6
7
$32.72
New wage needed to zero out shift differential ($1.00/hour) and Sunday premium
8
4.12%General Wage Increase (GWI) needed for differential and Sunday premium pay elimination (note that this changes based on the contractual wage)
9
10
$204.00
Money lost by eliminating shift differential (the same for all)
11
$32.04
New wage needed to zero out shift differential ($204/336 hours + $31.43 )
12
1.93%
GWI (constant at about $0.61 cents for all wages - the percentage changes with the contractual wage)
13
14
$32.14
New wage needed for the elimination of Sunday premium
15
2.27%
GWI (this is constant for all wages)
16
17
Scratchpad
18
32.72386492
19
204
20
$32.72
This is the new calculated wage for $31.43 plus 2.27% plus the addition of $0.58 for loss of differential
21
32.72431947
22
0.58
Change this cents figure to alter the value of the shift differential equation.
Loading...