| D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | FY2017-18 | FY2018-19 | FY2019-20 | FY2020-21 | FY2021-22 | FY2022-23 | FY2023-24 | FY2024-25 | |||||||||||||||
2 | City Compensation Expenses (Adopted Budget) | ||||||||||||||||||||||
3 | Sum of Amount | Column Labels | |||||||||||||||||||||
4 | Row Labels | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | ||||||||||||||
5 | Fringe Benefits | $117,077,477 | $120,230,325 | $143,617,860 | $138,292,817 | $124,904,658 | $164,951,152 | $192,667,396 | $203,069,499 | ||||||||||||||
6 | Retirement | $124,044,548 | $148,480,676 | $173,146,525 | $190,529,736 | $191,739,268 | $233,700,465 | $246,415,935 | $258,486,426 | ||||||||||||||
7 | Salaries | $420,044,156 | $447,480,751 | $534,045,395 | $479,958,992 | $491,649,456 | $547,392,129 | $567,990,360 | $598,558,687 | ||||||||||||||
8 | Grand Total | $661,166,181 | $716,191,752 | $850,809,780 | $808,781,545 | $808,293,382 | $946,043,746 | $1,007,073,691 | $1,060,114,612 | ||||||||||||||
9 | 2025 data from 2024 adopted budget | ||||||||||||||||||||||
10 | New info not provided in 2025 mid-year proposed | ||||||||||||||||||||||
11 | |||||||||||||||||||||||
12 | Inflation | 4.5% | 2.5% | 2.0% | 4.2% | 4.9% | 2.6% | 3.8% | |||||||||||||||
13 | Cumulatve Inflation vs. Jan 2018 | 4.5% | 7.1% | 9.3% | 13.8% | 19.4% | 22.5% | 27.2% | |||||||||||||||
14 | |||||||||||||||||||||||
15 | ------------------- ALL FUNDS CITY COMPENSATION ------------------- | ||||||||||||||||||||||
16 | All Funds City Comp | ||||||||||||||||||||||
17 | Annual Change vs. Prior Year | 8.3% | 18.8% | -4.9% | -0.1% | 17.0% | 6.5% | 5.3% | |||||||||||||||
18 | Cumulative Change vs. 2018 (%) | 8.3% | 28.7% | 22.3% | 22.3% | 43.1% | 52.3% | 60.3% | |||||||||||||||
19 | Cumulative Change vs. 2018 ($) | $55,025,571 | $189,643,599 | $147,615,364 | $147,127,201 | $284,877,565 | $345,907,510 | $398,948,431 | |||||||||||||||
20 | |||||||||||||||||||||||
21 | Comparison — All Funds City Comp If Adjusted to Keep Pace with Inflation | ||||||||||||||||||||||
22 | All Funds City Comp @ Adjusted for Inflation | $690,918,659 | $708,191,626 | $722,355,458 | $752,694,387 | $789,576,412 | $810,105,399 | $840,889,404 | |||||||||||||||
23 | Cumulative Change vs. 2018 ($) | $29,752,478 | $47,025,445 | $61,189,277 | $91,528,206 | $128,410,231 | $148,939,218 | $179,723,223 | |||||||||||||||
24 | Excess All Funds City Comp Over Inflation-Adjustment | $25,273,093 | $142,618,154 | $86,426,087 | $55,598,995 | $156,467,334 | $196,968,292 | $219,225,208 | |||||||||||||||
25 | |||||||||||||||||||||||
26 | Real Dollar Annual Change | 3.7% | 15.9% | -6.8% | -4.1% | 11.6% | 3.8% | 1.4% | |||||||||||||||
27 | Real Dollar Cumulative Change vs. 2018 | 3.7% | 20.1% | 12.0% | 7.4% | 19.8% | 24.3% | 26.1% | |||||||||||||||
28 | |||||||||||||||||||||||
29 | All Funds Personnel (Budgeted) | ||||||||||||||||||||||
30 | All Funds Personnel | 4271 | 4446 | 4526 | 4491 | 4526 | 4811 | 4745 | 4759 | ||||||||||||||
31 | Annual Change vs. Prior Year | 4.1% | 1.8% | -0.8% | 0.8% | 6.3% | -1.4% | 0.3% | |||||||||||||||
32 | Cumulative Change vs. 2019 | 4.1% | 6.0% | 5.1% | 5.9% | 12.6% | 11.1% | 11.4% | |||||||||||||||
33 | |||||||||||||||||||||||
34 | Annual All Funds Comp Expense Cumulative Change by Type (Abs $) | ||||||||||||||||||||||
35 | Fringe Benefits | 2.7% | 22.7% | 18.1% | 6.7% | 40.9% | 64.6% | 73.4% | |||||||||||||||
36 | Retirement | 19.7% | 39.6% | 53.6% | 54.6% | 88.4% | 98.7% | 108.4% | |||||||||||||||
37 | Salaries | 6.5% | 27.1% | 14.3% | 17.0% | 30.3% | 35.2% | 42.5% | |||||||||||||||
38 | |||||||||||||||||||||||
39 | All Funds Adopted Budget | $1,890,706,327 | $1,876,544,921 | $2,116,532,573 | $2,270,581,855 | $2,136,939,860 | $2,146,660,364 | ||||||||||||||||
40 | Personnel Portion of All Funds Budget | 45% | 43% | 38% | 42% | 47% | 49% | ||||||||||||||||
41 | |||||||||||||||||||||||
42 | |||||||||||||||||||||||
43 | |||||||||||||||||||||||
44 | ------------------- PER EMPLOYEE COMPENSATION ------------------- | ||||||||||||||||||||||
45 | Avg Comp / FTE | ||||||||||||||||||||||
46 | Avg Comp / FTE (Budgeted) | $154,789 | $161,080 | $187,995 | $180,077 | $178,608 | $196,639 | $212,251 | $222,773 | ||||||||||||||
47 | |||||||||||||||||||||||
48 | Avg Comp / FTE — Change | ||||||||||||||||||||||
49 | Annual Change | 4.1% | 16.7% | -4.2% | -0.8% | 10.1% | 7.9% | 5.0% | |||||||||||||||
50 | Cumulative Change vs 2018 | 4.1% | 21.5% | 16.3% | 15.4% | 27.0% | 37.1% | 43.9% | |||||||||||||||
51 | |||||||||||||||||||||||
52 | Real Dollar Annuual Change | -0.4% | 13.9% | -6.1% | -4.8% | 5.0% | 5.2% | 1.1% | |||||||||||||||
53 | Real Dollar Cumulative Change vs 2018 | -0.4% | 13.4% | 6.5% | 1.4% | 6.4% | 11.9% | 13.2% | |||||||||||||||
54 | |||||||||||||||||||||||
55 | Avg Comp / FTE by Type | ||||||||||||||||||||||
56 | Fringe Benefits | $27,410 | $27,041 | $31,734 | $30,791 | $27,600 | $34,286 | $40,607 | $42,673 | ||||||||||||||
57 | Retirement | $29,041 | $33,395 | $38,258 | $42,422 | $42,368 | $48,576 | $51,935 | $54,318 | ||||||||||||||
58 | Salaries | $98,339 | $100,644 | $118,003 | $106,864 | $108,639 | $113,778 | $119,710 | $125,781 | ||||||||||||||
59 | |||||||||||||||||||||||
60 | Avg Comp / FTE — Cumulative Change by Type | ||||||||||||||||||||||
61 | Fringe Benefits | -1.3% | 15.8% | 12.3% | 0.7% | 25.1% | 48.1% | 55.7% | |||||||||||||||
62 | Retirement | 15.0% | 31.7% | 46.1% | 45.9% | 67.3% | 78.8% | 87.0% | |||||||||||||||
63 | Salaries | 2.3% | 20.0% | 8.7% | 10.5% | 15.7% | 21.7% | 27.9% | |||||||||||||||
64 | Ret. & Benefits Combined | 7.1% | 24.0% | 29.7% | 23.9% | 46.8% | 63.9% | 71.8% | |||||||||||||||
65 | |||||||||||||||||||||||
66 | Avg Comp / FTE — Real Dollar Cumulative Change by Type | ||||||||||||||||||||||
67 | Fringe Benefits | -5.6% | 8.1% | 2.8% | -11.5% | 4.7% | 20.9% | 22.4% | |||||||||||||||
68 | Retirement | 10.0% | 23.0% | 33.7% | 28.2% | 40.1% | 46.0% | 47.1% | |||||||||||||||
69 | Salaries | -2.1% | 12.0% | -0.5% | -3.0% | -3.1% | -0.6% | 0.6% | |||||||||||||||
70 | Ret. & Benefits Combined | 2.5% | 15.8% | 18.7% | 8.9% | 22.9% | 33.8% | 35.1% | |||||||||||||||
71 | |||||||||||||||||||||||
72 | ------------------- RETIREMENT & BENEFIT PORTIONS ------------------- | ||||||||||||||||||||||
73 | Avg Comp / FTE — Portion of Full Comp by Type | ||||||||||||||||||||||
74 | Fringe Benefits | 17.7% | 16.8% | 16.9% | 17.1% | 15.5% | 17.4% | 19.1% | 19.2% | ||||||||||||||
75 | Retirement | 18.8% | 20.7% | 20.4% | 23.6% | 23.7% | 24.7% | 24.5% | 24.4% | ||||||||||||||
76 | Salaries | 63.5% | 62.5% | 62.8% | 59.3% | 60.8% | 57.9% | 56.4% | 56.5% | ||||||||||||||
77 | Ret. & Benefits Combined | 36.5% | 37.5% | 37.2% | 40.7% | 39.2% | 42.1% | 43.6% | 43.5% | ||||||||||||||
78 | |||||||||||||||||||||||
79 | |||||||||||||||||||||||
80 | |||||||||||||||||||||||
81 | Data Sources: | Comp | https://oaklandca.opengov.com/data/#/72789/query=18AD7CD5855B27AE723304818CA6796F&embed=n | ||||||||||||||||||||
82 | FTEs | https://oaklandca.opengov.com/data/#/72785/query=D4787D93D67FB4BF884880399A88198F&embed=n | |||||||||||||||||||||
83 | |||||||||||||||||||||||
84 | |||||||||||||||||||||||
85 | |||||||||||||||||||||||
86 | |||||||||||||||||||||||
87 | |||||||||||||||||||||||
88 | |||||||||||||||||||||||
89 | |||||||||||||||||||||||
90 | |||||||||||||||||||||||
91 | |||||||||||||||||||||||
92 | |||||||||||||||||||||||
93 | |||||||||||||||||||||||
94 | |||||||||||||||||||||||
95 | |||||||||||||||||||||||
96 | |||||||||||||||||||||||
97 | |||||||||||||||||||||||
98 | |||||||||||||||||||||||
99 | |||||||||||||||||||||||
100 |