I-2 - Resolution 2024-034 - Updated Compensation Study 2024

<table> <tr> <th rowspan="2">FT EE Position</th> <th colspan="6">CPI Adjustment*</th> <th rowspan="2">Trend* Yrs to Catch Up</th> <th rowspan="2">104% 5</th> </tr> <tr> <th>Current</th> <th>7/1/2024</th> <th>7/1/2025</th> <th>7/1/2026</th> <th>7/1/2027</th> <th>7/1/2028</th> </tr> <tr> <td>Office Assistant</td> <td>$40,165.00</td> <td>$43,583.25</td> <td>$47,077.84</td> <td>$50,651.83</td> <td>$54,308.39</td> <td>$58,050.83</td> <td></td> </tr> <tr> <td></td> <td>Target $47,713.55</td> <td>$49,622.09</td> <td>$51,606.97</td> <td>$53,671.25</td> <td>$55,818.10</td> <td>$58,050.83</td> <td></td> </tr> <tr> <td></td> <td>Disparity $7,548.55</td> <td>$6,038.84</td> <td>$4,529.13</td> <td>$3,019.42</td> <td>$1,509.71</td> <td>$0.00</td> <td></td> </tr> <tr> <td></td> <td>Raise $3,418.25</td> <td>$3,494.59</td> <td>$3,573.99</td> <td>$3,656.56</td> <td>$3,742.43</td> <td></td> <td></td> </tr> <tr> <td>Park & Recreation Director</td> <td>$75,782.00</td> <td>$80,799.84</td> <td>$85,952.18</td> <td>$91,244.39</td> <td>$96,682.08</td> <td>$102,271.05</td> <td></td> </tr> <tr> <td></td> <td>Target $84,059.35</td> <td>$87,421.72</td> <td>$90,918.59</td> <td>$94,555.33</td> <td>$98,337.55</td> <td>$102,271.05</td> <td></td> </tr> <tr> <td></td> <td>Disparity $8,277.35</td> <td>$6,621.88</td> <td>$4,966.41</td> <td>$3,310.94</td> <td>$1,655.47</td> <td>$0.00</td> <td></td> </tr> <tr> <td></td> <td>Raise $5,017.84</td> <td>$5,152.34</td> <td>$5,292.21</td> <td>$5,437.68</td> <td>$5,588.97</td> <td></td> <td></td> </tr> <tr> <td>Water/Wastewater Supt</td> <td>$90,872.00</td> <td>$98,517.65</td> <td>$106,335.43</td> <td>$114,332.24</td> <td>$122,515.22</td> <td>$130,891.83</td> <td></td> </tr> <tr> <td></td> <td>Target $107,583.54</td> <td>$111,886.88</td> <td>$116,362.36</td> <td>$121,016.85</td> <td>$125,857.53</td> <td>$130,891.83</td> <td></td> </tr> <tr> <td></td> <td>Disparity $16,711.54</td> <td>$13,369.23</td> <td>$10,026.92</td> <td>$6,684.62</td> <td>$3,342.31</td> <td>$0.00</td> <td></td> </tr> <tr> <td></td> <td>Raise $7,645.65</td> <td>$7,817.78</td> <td>$7,996.80</td> <td>$8,182.98</td> <td>$8,376.61</td> <td></td> <td></td> </tr> <tr> <td>Fire Marshal</td> <td>$73,500.00</td> <td>$77,328.77</td> <td>$81,281.07</td> <td>$85,361.84</td> <td>$89,576.21</td> <td>$93,929.53</td> <td></td> </tr> <tr> <td></td> <td>Target $77,203.23</td> <td>$80,291.35</td> <td>$83,503.01</td> <td>$86,843.13</td> <td>$90,316.85</td> <td>$93,929.53</td> <td></td> </tr> <tr> <td></td> <td>Disparity $3,703.23</td> <td>$2,962.58</td> <td>$2,221.94</td> <td>$1,481.29</td> <td>$740.65</td> <td>$0.00</td> <td></td> </tr> <tr> <td></td> <td>Raise $3,828.77</td> <td>$3,952.30</td> <td>$4,080.77</td> <td>$4,214.37</td> <td>$4,353.32</td> <td></td> <td></td> </tr> <tr> <td>Asst. CA Target</td> <td>$94,906.47</td> <td>$98,702.73</td> <td>$102,650.84</td> <td>$106,756.87</td> <td>$111,027.15</td> <td>$115,468.23</td> <td></td> </tr> <tr> <td></td> <td>Base Salary Adjustments $85,155.11</td> <td>$82,257.64</td> <td>$84,510.46</td> <td>$86,853.40</td> <td>$89,290.06</td> <td></td> <td></td> </tr> <tr> <td></td> <td>IPERS Impact $8,038.64</td> <td>$7,765.12</td> <td>$7,977.79</td> <td>$8,198.96</td> <td>$8,428.98</td> <td></td> <td></td> </tr> <tr> <td></td> <td>FICA Impact $6,514.37</td> <td>$6,292.71</td> <td>$6,465.05</td> <td>$6,644.29</td> <td>$6,830.69</td> <td></td> <td></td> </tr> <tr> <td>Total Budgetary Impact</td> <td>$99,708.11</td> <td>$96,315.47</td> <td>$98,953.30</td> <td>$101,696.65</td> <td>$104,549.73</td> <td>$501,223.26</td> <td></td> </tr> <tr> <td>$1,219,112.00</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>If 4% Increase Only</td> <td>$48,764.48</td> <td>$50,715.06</td> <td>$52,743.66</td> <td>$54,853.41</td> <td>$57,047.54</td> <td></td> <td></td> </tr> <tr> <td>IPERS Impact</td> <td>$4,603.37</td> <td>$4,787.50</td> <td>$4,979.00</td> <td>$5,178.16</td> <td>$5,385.29</td> <td></td> <td></td> </tr> <tr> <td>FICA Impact</td> <td>$3,730.48</td> <td>$3,879.70</td> <td>$4,034.89</td> <td>$4,196.29</td> <td>$4,364.14</td> <td></td> <td></td> </tr> <tr> <td>4% Increase Only Impact</td> <td>$57,098.33</td> <td>$59,382.26</td> <td>$61,757.55</td> <td>$64,227.86</td> <td>$66,796.97</td> <td></td> <td></td> </tr> <tr> <td>Net Impact of Plan</td> <td>$42,609.78</td> <td>$36,933.21</td> <td>$37,195.75</td> <td>$37,468.79</td> <td>$37,752.76</td> <td>$191,960.29</td> <td></td> </tr> </table> First Year- 4% Factor; future years use November versus previous November to adjust scales: https://www.bls.gov/regions/mountain-plains/news-release/ConsumerPriceIndex_Midwest.htm