What are we aiming for?
What is our end result in compensation? What do these lines represent? $ mid or
CTL
Points Lines represent competition , also indicated other strong compeitiors in the market competition is who is steeling your good works
Adjusting Survey Data- Weighted Averages | Check excel doc.! | | | | | | | | | | | | | | | | | | | | Admin Support 1 | | | | | | | | | | | | | | | | | | | | | | | | | | Policy Ranges | Salary $ | | | | | | | | | | | | | | | | | | | Company | # obns | min | mid/ctl | max | avg salary | | | | | | | | | | | | | | | | | | | Royal | 28 | 26,550 | 29,500 | 32450 | 27,200 | 26550 | 29500 | 32450 | | | | Sick Kids | 16 | 26370 | 29,300 | 29,300 | 28,400 | 29500 | | 29500 | | | | Hydro | 14 | 28800 | 32,000 | 36,800 | 30,250 | 0.9 | 1 | 1.1 | | 10 down and 10 up = 20% | De Havilland | 5 | 32490 | 34,200 | 34,200 | 35,300 | 1.111111 | | 1.15 | -25% | | | | | | | | | | | | 5% | | | | | | | | | | | | | | | | | | | | | | | | | | | 1. examine the ranges. Implications? | Salaries are entry level and project employees will get promited | | | | | | 2. Look at Dehavilland- what is happening in salary versus ranges? | breaking the rules with the average salary buying the talent amove | 3. Calculate the width of each company's ranges | | | | | | | | | 4. If we had 20 Admin Support 1 positions, which companies would you include in the analysis? | | | 5. Calculate : | | | | | | | | | | | | | have to tell me the terminology | | | | | | | | | | | *pure policy avg3e | | | | | | | | | | | | | | | | | | | | | | | *weighted policy avg | | | | | | | | | | | ranges | Observations | mutiply across | | | | | | | | | | 29,500 |