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 <table> <tr> <th rowspan="2">Law Enforcement Services Annual Compensation per Position</th> <th colspan="5">Year 1<br>FY 20/21</th> <th colspan="5">Year 2<br>FY 21/22</th> <th colspan="5">Year 3<br>FY 22/23</th> <th colspan="5">Year 4<br>FY 23/24</th> <th colspan="5">Year 5<br>FY 24/25</th> </tr> <tr> <th>Base Salary¹</th> <th>76,374</th> <th>78,283</th> <th>80,240</th> <th>82,246</th> <th>84,302</th> <th>Benefits/Annual²</th> <th>34,390</th> <th>35,995</th> <th>37,684</th> <th>39,464</th> <th>41,337</th> <th>Annual Compensation Per Position</th> <th>110,764</th> <th>114,278</th> <th>117,924</th> <th>121,710</th> <th>125,639</th> </tr> </table> <table> <tr> <th rowspan="2">Support Supplies & Services Estimate</th> <th colspan="5"></th> <th colspan="5"></th> <th colspan="5"></th> <th colspan="5"></th> </tr> <tr> <th>Vehicle Maint./Operations</th> <th>4,063</th> <th>4,185</th> <th>4,311</th> <th>4,440</th> <th>4,573</th> <th>Misc. supplies</th> <th>6,131</th> <th>6,314</th> <th>6,504</th> <th>6,699</th> <th>6,900</th> <th>Support Supplies & Services</th> <th>10,184</th> <th>10,500</th> <th>10,815</th> <th>11,139</th> <th>11,473</th> </tr> </table> <table> <tr> <th rowspan="2">Vehicle & Equipment Depreciation Estimate</th> <th colspan="5"></th> <th colspan="5"></th> <th colspan="5"></th> <th colspan="5"></th> </tr> <tr> <th>Ballistic Vest</th> <th>200</th> <th>200</th> <th>200</th> <th>200</th> <th>200</th> <th>Hand Held Radio (10 year depreciation/replacement)</th> <th>450</th> <th>450</th> <th>450</th> <th>450</th> <th>450</th> <th>Vehicle&Equipment Depreciation (See Vehicle Info. Tab)</th> <th>14,846</th> <th>14,846</th> <th>14,846</th> <th>14,846</th> <th>14,846</th> <th>Vehicle & Equip. Depreciation</th> <th>15,296</th> <th>15,296</th> <th>15,296</th> <th>15,296</th> <th>15,296</th> </tr> </table> <table> <tr> <th colspan="5">Estimated Expense Per Position</th> <th colspan="5">136,254</th> <th colspan="5">140,074</th> <th colspan="5">144,035</th> <th colspan="5">148,145</th> <th colspan="5">152,408</th> </tr> </table> <table> <tr> <th colspan="5">Personnel Costs</th> <th colspan="5"></th> <th colspan="5"></th> <th colspan="5"></th> <th colspan="5"></th> <th colspan="5"></th> </tr> <tr> <th>Base Coverage Hours (1*24*365)</th> <td colspan="4">8,760</td> <th colspan="5"></th> <th colspan="4">8,760</th> <th colspan="5"></th> <th colspan="4">8,760</th> <th colspan="5"></th> <th colspan="4">8,760</th> </tr> <tr> <th>Additional Shifts Per Week (1=40 Hrs., .5=20 Hrs.)</th> <td colspan="4">0.80</td> <th colspan="5"></th> <th colspan="4">0.80</th> <th colspan="5"></th> <th colspan="4">0.80</th> <th colspan="5"></th> <th colspan="4">2.0</th> </tr> <tr> <th>Additional Shift Hours</th> <td colspan="4">1,664</td> <th colspan="5"></th> <th colspan="4">1,664</th> <th colspan="5"></th> <th colspan="4">1,664</th> <th colspan="5"></th> <th colspan="4">4,160</th> </tr> <tr> <th>Total Coverage Hours</th> <td colspan="4">10,424</td> <th colspan="5"></th> <th colspan="4">10,424</th> <th colspan="5"></th> <th colspan="4">10,424</th> <th colspan="5"></th> <th colspan="4">12,920</th> </tr> <tr> <th>Net Available Work Hours</th> <td colspan="4">1,708</td> <th colspan="5"></th> <th colspan="4">1,708</th> <th colspan="5"></th> <th colspan="4">1,708</th> <th colspan="5"></th> <th colspan="4">1,708</th> </tr> <tr> <th>FTE's Required (rounded)</th> <td colspan="4">6.1</td> <th colspan="5"></th> <th colspan="4">6.1</th> <th colspan="5"></th> <th colspan="4">6.1</th> <th colspan="5"></th> <th colspan="4">7.6</th> </tr> <tr> <th>Expense Per Position</th> <td colspan="4">136,254</td> <th colspan="5"></th> <th colspan="4">140,074</th> <th colspan="5"></th> <th colspan="4">144,035</th> <th colspan="5"></th> <th colspan="4">148,145</th> <th colspan="5">152,408</th> </tr> <tr> <th>FTE's Required</th> <td colspan="4">6.1</td> <th colspan="5"></th> <th colspan="4">6.1</th> <th colspan="5"></th> <th colspan="4">6.1</th> <th colspan="5"></th> <th colspan="4">7.6</th> <th colspan="5">7.6</th> </tr> <tr> <th>Personnel Costs</th> <td colspan="4">831,149</td> <th colspan="5"></th> <th colspan="4">854,450</th> <th colspan="5"></th> <th colspan="4">875,612</th> <th colspan="5"></th> <th colspan="4">1,119,977</th> <th colspan="5">1,152,207</th> </tr> </table> <table> <tr> <th colspan="5">Additional Law Enforcement Personnel Costs</th> <th colspan="5"></th> <th colspan="5"></th> <th colspan="5"></th> <th colspan="5"></th> <th colspan="5"></th> </tr> <tr> <th>Shift Differential- Base Hours</th> <td colspan="4">1,598</td> <th colspan="5"></th> <th colspan="4">1,598</th> <th colspan="5"></th> <th colspan="4">1,598</th> <th colspan="5"></th> <th colspan="4">1,598</th> </tr> <tr> <th>Shift Differential- Additional Shift Hours</th> <td colspan="4">582</td> <th colspan="5"></th> <th colspan="4">582</th> <th colspan="5"></th> <th colspan="4">582</th> <th colspan="5"></th> <th colspan="4">1,456</th> <th colspan="5">1,456</th> </tr> <tr> <th>Holiday Pay- Base Hours</th> <td colspan="4">22,627</td> <th colspan="5"></th> <th colspan="4">23,193</th> <th colspan="5"></th> <th colspan="4">23,772</th> <th colspan="5"></th> <th colspan="4">24,367</th> <th colspan="5">24,976</th> </tr> <tr> <th>Holiday Pay- Additional Shift</th> <td colspan="4">6,034</td> <th colspan="5"></th> <th colspan="4">6,185</th> <th colspan="5"></th> <th colspan="4">6,339</th> <th colspan="5"></th> <th colspan="4">16,244</th> <th colspan="5">16,651</th> </tr> <tr> <th>Additional Personnel Costs</th> <td colspan="4">31,141</td> <th colspan="5"></th> <th colspan="4">31,856</th> <th colspan="5"></th> <th colspan="4">32,591</th> <th colspan="5"></th> <th colspan="4">43,965</th> <th colspan="5">44,991</th> </tr> </table> <table> <tr> <th colspan="5">Animal Control Services Annual Service Fee (Per Capita & Average Activity)⁴</th> <th colspan="5">$ 7,446</th> <th colspan="5">$ 7,595</th> <th colspan="5">$ 7,747</th> <th colspan="5">$ 7,902</th> <th colspan="5">$ 8,080</th> </tr> <tr> <th colspan="5">Grand Total Annual Expense</th> <th colspan="5">869,736</th> <th colspan="5">893,603</th> <th colspan="5">919,950</th> <th colspan="5">1,171,844</th> <th colspan="5">1,205,248</th> </tr> <tr> <th>% of Total Expense</th> <td colspan="4">75.50%</td> <th colspan="5"></th> <th colspan="4">77.10%</th> <th colspan="5"></th> <th colspan="4">78.70%</th> <th colspan="5"></th> <th colspan="4">80.30%</th> <th colspan="5">81.90%</th> </tr> <tr> <th>Monthly Contract Amount</th> <td colspan="4">54,720.92</td> <th colspan="5"></th> <th colspan="4">67,433.25</th> <th colspan="5"></th> <th colspan="4">60,267.83</th> <th colspan="5"></th> <th colspan="4">78,415.92</th> <th colspan="5">82,258.17</th> </tr> <tr> <th>Proposed Contract Amount</th> <td colspan="4">655,851</td> <th colspan="5"></th> <th colspan="4">689,199</th> <th colspan="5"></th> <th colspan="4">723,214</th> <th colspan="5"></th> <th colspan="4">940,991</th> <th colspan="5">987,098</th> </tr> <tr> <th>$ Increase</th> <td colspan="4"></td> <th colspan="5"></th> <th colspan="4">32,548</th> <th colspan="5"></th> <th colspan="4">34,015</th> <th colspan="5"></th> <th colspan="4">217,777</th> <th colspan="5">46,107</th> </tr> <tr> <th>% Increase</th> <td colspan="4"></td> <th colspan="5"></th> <th colspan="4">4.66%</th> <th colspan="5"></th> <th colspan="4">4.94%</th> <th colspan="5"></th> <th colspan="4">30.11%</th> <th colspan="5">4.90%</th> </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.