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

<table> <tr> <th rowspan="2">Position</th> <th colspan="2">CPI Adjustment*</th> <th colspan="5">Trend* Yrs to Catch Up</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>PW Director</td> <td>$85,928.00</td> <td>$93,620.33</td> <td>$101,478.51</td> <td>$109,509.18</td> <td>$117,719.24</td> <td>$126,115.86</td> </tr> <tr> <td></td> <td>Target $103,658.04</td> <td>$107,804.36</td> <td>$112,116.54</td> <td>$116,601.20</td> <td>$121,265.25</td> <td>$126,115.86</td> </tr> <tr> <td></td> <td>Disparity $17,730.04</td> <td>$14,184.03</td> <td>$10,638.03</td> <td>$7,092.02</td> <td>$3,546.01</td> <td>$0.00</td> </tr> <tr> <td></td> <td>Raise $7,692.33</td> <td>$7,858.18</td> <td>$8,030.67</td> <td>$8,210.06</td> <td>$8,396.62</td> <td></td> </tr> <tr> <td>Building Official</td> <td>$80,082.00</td> <td>$84,022.60</td> <td>$88,096.26</td> <td>$92,308.28</td> <td>$96,664.20</td> <td>$101,169.78</td> </tr> <tr> <td></td> <td>Target $83,154.19</td> <td>$86,480.35</td> <td>$89,939.57</td> <td>$93,537.15</td> <td>$97,278.64</td> <td>$101,169.78</td> </tr> <tr> <td></td> <td>Disparity $3,072.19</td> <td>$2,457.75</td> <td>$1,843.31</td> <td>$1,228.87</td> <td>$614.44</td> <td>$0.00</td> </tr> <tr> <td></td> <td>Raise $3,940.60</td> <td>$4,073.65</td> <td>$4,212.02</td> <td>$4,355.92</td> <td>$4,505.58</td> <td></td> </tr> <tr> <td>City Clerk</td> <td>$76,650.00</td> <td>$79,283.61</td> <td>$82,036.97</td> <td>$84,914.89</td> <td>$87,922.33</td> <td>$91,064.48</td> </tr> <tr> <td></td> <td>Target $74,848.37</td> <td>$77,842.30</td> <td>$80,955.99</td> <td>$84,194.23</td> <td>$87,562.00</td> <td>$91,064.48</td> </tr> <tr> <td></td> <td>Disparity -$1,801.64</td> <td>-$1,441.31</td> <td>-$1,080.98</td> <td>-$720.65</td> <td>-$360.33</td> <td>$0.00</td> </tr> <tr> <td></td> <td>Raise $2,633.61</td> <td>$2,753.36</td> <td>$2,877.91</td> <td>$3,007.44</td> <td>$3,142.15</td> <td></td> </tr> <tr> <td>Bldg Inspector II/Plans Exam.</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> </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> </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> </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> </tr> <tr> <td>Construction Inspector I</td> <td>$50,000.00</td> <td>$55,954.43</td> <td>$62,015.23</td> <td>$68,186.64</td> <td>$74,473.09</td> <td>$80,879.19</td> </tr> <tr> <td></td> <td>Target $66,476.80</td> <td>$69,135.87</td> <td>$71,901.31</td> <td>$74,777.36</td> <td>$77,768.45</td> <td>$80,879.19</td> </tr> <tr> <td></td> <td>Disparity $16,476.80</td> <td>$13,181.44</td> <td>$9,886.08</td> <td>$6,590.72</td> <td>$3,295.36</td> <td>$0.00</td> </tr> <tr> <td></td> <td>Raise $5,954.43</td> <td>$6,060.79</td> <td>$6,171.41</td> <td>$6,286.45</td> <td>$6,406.10</td> <td></td> </tr> <tr> <td>Deputy City Clerk</td> <td>$54,267.00</td> <td>$57,168.24</td> <td>$60,161.18</td> <td>$63,249.48</td> <td>$66,436.96</td> <td>$69,727.59</td> </tr> <tr> <td></td> <td>Target $57,311.00</td> <td>$59,603.44</td> <td>$61,987.58</td> <td>$64,467.08</td> <td>$67,045.76</td> <td>$69,727.59</td> </tr> <tr> <td></td> <td>Disparity $3,044.00</td> <td>$2,435.20</td> <td>$1,826.40</td> <td>$1,217.60</td> <td>$608.80</td> <td>$0.00</td> </tr> <tr> <td></td> <td>Raise $2,901.24</td> <td>$2,992.94</td> <td>$3,088.30</td> <td>$3,187.48</td> <td>$3,290.63</td> <td></td> </tr> <tr> <td>Utility Clerk II Target</td> <td>$52,815.34</td> <td>$54,927.95</td> <td>$57,125.07</td> <td>$59,410.07</td> <td>$61,786.47</td> <td>$64,257.93</td> </tr> <tr> <td>Utility Clerk I</td> <td>$42,556.00</td> <td>$46,445.64</td> <td>$50,417.95</td> <td>$54,476.24</td> <td>$58,623.95</td> <td>$62,864.65</td> </tr> <tr> <td></td> <td>Target $51,670.16</td> <td>$53,736.97</td> <td>$55,886.45</td> <td>$58,121.90</td> <td>$60,446.78</td> <td>$62,864.65</td> </tr> <tr> <td></td> <td>Disparity $9,114.16</td> <td>$7,291.33</td> <td>$5,468.50</td> <td>$3,645.66</td> <td>$1,822.83</td> <td>$0.00</td> </tr> <tr> <td></td> <td>Raise $3,889.64</td> <td>$3,972.31</td> <td>$4,058.29</td> <td>$4,147.71</td> <td>$4,240.70</td> <td></td> </tr> <tr> <td>PW Worker II</td> <td>$56,430.00</td> <td>$59,239.50</td> <td>$62,142.98</td> <td>$65,144.18</td> <td>$68,247.02</td> <td>$71,455.56</td> </tr> <tr> <td></td> <td>Target $58,731.26</td> <td>$61,080.51</td> <td>$63,523.74</td> <td>$66,064.68</td> <td>$68,707.27</td> <td>$71,455.56</td> </tr> <tr> <td></td> <td>Disparity $2,301.26</td> <td>$1,841.01</td> <td>$1,380.76</td> <td>$920.51</td> <td>$460.25</td> <td>$0.00</td> </tr> <tr> <td></td> <td>Raise $2,809.50</td> <td>$2,903.47</td> <td>$3,001.20</td> <td>$3,102.84</td> <td>$3,208.54</td> <td></td> </tr> <tr> <td>PW Worker I</td> <td>$47,590.00</td> <td>$51,531.61</td> <td>$54,544.82</td> <td>$57,645.74</td> <td>$60,837.86</td> <td>$64,124.85</td> </tr> <tr> <td></td> <td>Target $52,705.95</td> <td>$54,814.19</td> <td>$57,006.76</td> <td>$59,287.03</td> <td>$61,658.51</td> <td>$64,124.85</td> </tr> <tr> <td></td> <td>Disparity $4,103.22</td> <td>$3,282.58</td> <td>$2,461.93</td> <td>$1,641.29</td> <td>$820.64</td> <td>$0.00</td> </tr> <tr> <td></td> <td>Raise $3,941.61</td> <td>$3,013.21</td> <td>$3,100.91</td> <td>$3,192.13</td> <td>$3,286.98</td> <td></td> </tr> </table>