WS - C - Law Enforcement Assessment - Final Exhibits

POLK COUNTY SHERIFF'S OFFICE City of Bondurant Contract Law Enforcement FY 20/21 through FY 29/30 Law Enforcement Services Annual Compensation per Position <table> <tr> <th></th> <th>Year 6<br>FY 25/26</th> <th>Year 7<br>FY 26/27</th> <th>Year 8<br>FY 27/28</th> <th>Year 9<br>FY 28/29</th> <th>Year 10<br>FY 29/30</th> </tr> <tr> <td>Base Salary¹</td> <td>$ 86,410</td> <td>$ 88,570</td> <td>$ 90,784</td> <td>$ 93,054</td> <td>$ 95,380</td> </tr> <tr> <td>Benefits/Annual^2,3</td> <td>$ 43,311</td> <td>$ 45,391</td> <td>$ 47,583</td> <td>$ 49,882</td> <td>$ 52,327</td> </tr> <tr> <th>Annual Compensation Per Position</th> <th>$ 129,721</th> <th>$ 133,961</th> <th>$ 138,367</th> <th>$ 142,946</th> <th>$ 147,707</th> </tr> </table> Support Supplies & Services Estimate <table> <tr> <th></th> <th>Vehicle Maint./Operations</th> <th>Misc. supplies</th> <th>Support Supplies & Services</th> </tr> <tr> <td>Vehicle Maint./Operations</td> <td>$ 4,711</td> <td>$ 7,107</td> <td>$ 11,818</td> </tr> <tr> <td>Misc. supplies</td> <td>$ 4,852</td> <td>$ 7,320</td> <td>$ 12,172</td> </tr> <tr> <td>Support Supplies & Services</td> <td>$ 4,997</td> <td>$ 7,540</td> <td>$ 12,537</td> </tr> <tr> <th></th> <th></th> <th></th> <th></th> </tr> <tr> <td></td> <td>$ 5,147</td> <td>$ 7,766</td> <td>$ 12,913</td> </tr> <tr> <td></td> <td>$ 5,302</td> <td>$ 7,999</td> <td>$ 13,301</td> </tr> </table> Vehicle & Equipment Depreciation Estimate <table> <tr> <th></th> <th>Ballistic Vest</th> <th>Hand Held Radio (10 year depreciation/replacement)</th> <th>Vehicle&Equipment Depreciation (See Vehicle Info. Tab)</th> <th>Vehicle & Equip. Depreciation</th> </tr> <tr> <td>Ballistic Vest</td> <td>$ 200</td> <td>$ 450</td> <td>$ 14,646</td> <td>$ 15,296</td> </tr> <tr> <td>Hand Held Radio (10 year depreciation/replacement)</td> <td>$ 200</td> <td>$ 450</td> <td>$ 14,646</td> <td>$ 15,296</td> </tr> <tr> <td>Vehicle&Equipment Depreciation (See Vehicle Info. Tab)</td> <td>$ 200</td> <td>$ 450</td> <td>$ 14,646</td> <td>$ 15,296</td> </tr> <tr> <th></th> <th></th> <th></th> <th></th> <th></th> </tr> <tr> <td></td> <td>$ 200</td> <td>$ 450</td> <td>$ 14,646</td> <td>$ 15,296</td> </tr> <tr> <td></td> <td>$ 200</td> <td>$ 450</td> <td>$ 14,646</td> <td>$ 15,296</td> </tr> </table> Estimated Expense Per Position <table> <tr> <th></th> <th>Year 6<br>FY 25/26</th> <th>Year 7<br>FY 26/27</th> <th>Year 8<br>FY 27/28</th> <th>Year 9<br>FY 28/29</th> <th>Year 10<br>FY 29/30</th> </tr> <tr> <td>Personnel Costs</td> <td>$ 156,835</td> <td>$ 161,429</td> <td>$ 166,200</td> <td>$ 171,155</td> <td>$ 176,304</td> </tr> <tr> <td>Base Coverage Hours (1*24*365)</td> <td>8,760</td> <td>8,750</td> <td>8,760</td> <td>8,760</td> <td>8,760</td> </tr> <tr> <td>Additional Shifts Per Week (*=40 Hrs., .5=20 Hrs.)</td> <td>2.0</td> <td>2.0</td> <td>2.0</td> <td>2.0</td> <td>2.0</td> </tr> <tr> <td>Additional Shift Hours</td> <td>4,160</td> <td>4,160</td> <td>4,160</td> <td>4,160</td> <td>4,160</td> </tr> <tr> <td>Total Coverage Hours</td> <td>12,920</td> <td>12,920</td> <td>12,920</td> <td>12,920</td> <td>12,920</td> </tr> <tr> <td>Net Available Work Hours</td> <td>1,708</td> <td>1,708</td> <td>1,708</td> <td>1,708</td> <td>1,708</td> </tr> <tr> <td>FTE's Required (rounded)</td> <td>7.6</td> <td>7.6</td> <td>7.6</td> <td>7.6</td> <td>7.6</td> </tr> <tr> <td>Expense Per Position</td> <td>$ 156,835</td> <td>$ 161,429</td> <td>$ 166,200</td> <td>$ 171,155</td> <td>$ 176,304</td> </tr> <tr> <td>FTE's Required</td> <td>7.6</td> <td>7.6</td> <td>7.6</td> <td>7.6</td> <td>7.6</td> </tr> <tr> <th>Personnel Costs</th> <th>$ 1,185,669</th> <th>$ 1,220,404</th> <th>$ 1,256,474</th> <th>$ 1,293,934</th> <th>$ 1,332,856</th> </tr> </table> Additional Law Enforcement Personnel Costs <table> <tr> <th></th> <th>Shift Differential- Base Hours</th> <th>Shift Differential- Additional Shift Hours</th> <th>Holiday Pay- Base Hours</th> <th>Holiday Pay- Additional Shift</th> <th>Additional Personnel Costs</th> </tr> <tr> <td>Shift Differential- Base Hours</td> <td>$ 1,898</td> <td>$ 1,456</td> <td>$ 25,600</td> <td>$ 17,067</td> <td>$ 46,021</td> </tr> <tr> <td>Shift Differential- Additional Shift Hours</td> <td>$ 1,898</td> <td>$ 1,456</td> <td>$ 26,240</td> <td>$ 17,494</td> <td>$ 47,088</td> </tr> <tr> <td>Holiday Pay- Base Hours</td> <td>$ 1,898</td> <td>$ 1,456</td> <td>$ 26,596</td> <td>$ 17,931</td> <td>$ 48,181</td> </tr> <tr> <td>Holiday Pay- Additional Shift</td> <td>$ 1,898</td> <td>$ 1,456</td> <td>$ 27,589</td> <td>$ 18,379</td> <td>$ 49,302</td> </tr> <tr> <th>Additional Personnel Costs</th> <th></th> <th></th> <th></th> <th></th> <th>$ 50,451</th> </tr> </table> Animal Control Services <table> <tr> <th></th> <th>Annual Service Fee (Per Capita & Average Activity)⁴</th> <th>Grand Total Annual Expense</th> </tr> <tr> <td></td> <td>$ 8,221</td> <td>$ 1,239,911</td> </tr> <tr> <td></td> <td>$ 8,385</td> <td>$ 1,275,877</td> </tr> <tr> <td></td> <td>$ 8,553</td> <td>$ 1,313,208</td> </tr> <tr> <td></td> <td>$ 8,724</td> <td>$ 1,351,960</td> </tr> <tr> <td></td> <td>$ 8,899</td> <td>$ 1,392,206</td> </tr> </table> <table> <tr> <th></th> <th>% of Total Expense</th> <th>Monthly Contract Amount</th> <th>Proposed Contract Amount</th> <th>$ Increase</th> <th>% Increase</th> </tr> <tr> <td></td> <td>83.50%</td> <td>$ 86,277.17</td> <td>$ 1,035,326</td> <td>$ 48,228</td> <td>4.89%</td> </tr> <tr> <td></td> <td>85.10%</td> <td>$ 90,481.00</td> <td>$ 1,085,772</td> <td>$ 50,446</td> <td>4.87%</td> </tr> <tr> <td></td> <td>86.70%</td> <td>$ 94,879.25</td> <td>$ 1,138,551</td> <td>$ 52,779</td> <td>4.86%</td> </tr> <tr> <td></td> <td>88.30%</td> <td>$ 99,481.75</td> <td>$ 1,193,781</td> <td>$ 55,230</td> <td>4.85%</td> </tr> <tr> <td></td> <td>89.60%</td> <td>$ 104,259.42</td> <td>$ 1,251,593</td> <td>$ 57,812</td> <td>4.84%</td> </tr> </table> 1) Salary- Calculated using 2.5% increase annually. 2) Insurance- Calculated using 6.0% increase annually. 3) IPERS- Calculated using FY 19/20 Deputy rate of 9.51% 4) Animal Control Service Fee- Calculated using 2.0% increase annually.