| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Employee ID | Title | Team | Level | Pre-GWWC experience (years adjusted by relevance) | Explanation | Start date | Competitive skill bonus | FTE | City | 2024 Entity | Base salary @ 1 FTE (GBP) | Experience bonus @ 1 FTE (GBP) | Competitive skills bonus @ 1 FTE (GBP) | Bonus-adjusted salary @ 1 FTE (GBP) | CoL-adjusted salary @ 1 FTE (GBP) | Cost to employ @ 1FTE (GBP) | Cost to employ @ 1FTE (USD) | Local currency | Calculated salary @ FTE (Local currency) | Current salary @ FTE (Local currency) | Notes | |
2 | 1 | US Country Manager or Director of Development | 5B | 0 | 2023-02-01 | 1.00 | Springfield, MA (US) | £65,473 | £575 | £0 | £66,049 | £62,482 | £78,103 | $99,271 | USD | 79,400 | |||||||
3 | 2 | US Country Manager or Director of Development | 5H | 10 | 2023-02-01 | 1.00 | Brooklyn, NY (US) | £72,021 | £5,575 | £0 | £77,596 | £98,683 | £123,353 | $156,786 | USD | 125,400 | |||||||
4 | 3 | UK Country Manager or Director of Development | 5B | 0 | 2023-02-01 | 1.00 | Bristol (GB) | £65,473 | £575 | £0 | £66,049 | £64,507 | £80,633 | $102,488 | GBP | 64,500 | |||||||
5 | 4 | UK Country Manager or Director of Development | 5H | 10 | 2023-02-01 | 1.00 | London (GB) | £72,021 | £5,575 | £0 | £77,596 | £91,719 | £114,648 | $145,721 | GBP | 91,700 | |||||||
6 | 5 | CA Country Manager or Director of Development | 5B | 0 | 2023-02-01 | 1.00 | Montreal (CA) | £65,473 | £575 | £0 | £66,049 | £60,645 | £75,806 | $96,352 | CAD | 104,300 | |||||||
7 | 6 | CA Country Manager or Director of Development | 5H | 10 | 2023-02-01 | 1.00 | Vancouver (CA) | £72,021 | £5,575 | £0 | £77,596 | £79,090 | £98,862 | $125,657 | CAD | 136,100 | |||||||
8 | 7 | | | #N/A | £0 | £0 | #N/A | £0 | $0 | | 0 | ||||||||||||
9 | 8 | | | #N/A | £0 | £0 | #N/A | £0 | $0 | | 0 | ||||||||||||
10 | 9 | | | #N/A | £0 | £0 | #N/A | £0 | $0 | | 0 | ||||||||||||
11 | 10 | | | #N/A | £0 | £0 | #N/A | £0 | $0 | | 0 |