WS - C - Law Enforcement Assessment - Final Exhibits

POLK COUNTY SHERIFF'S OFFICE City of Grimes Contract Law Enforcement FY 2021 through FY 29/30 <table> <tr> <th rowspan="2">Law Enforcement Services Annual Compensation per Position</th> <th colspan="5">Year 8 FY 28/29</th> <th colspan="5">Year 7 FY 28/27</th> <th colspan="5">Year 6 FY 27/28</th> <th colspan="5">Year 9 FY 29/29</th> <th colspan="5">Year 10 FY 29/30</th> </tr> <tr> <th>Base Salary¹</th> <th>Benefits/Annual²</th> <th>Annual Compensation Per Position</th> <th>Base Salary</th> <th>Benefits/Annual</th> <th>Annual Compensation Per Position</th> <th>Base Salary</th> <th>Benefits/Annual</th> <th>Annual Compensation Per Position</th> <th>Base Salary</th> <th>Benefits/Annual</th> <th>Annual Compensation Per Position</th> <th>Base Salary</th> <th>Benefits/Annual</th> <th>Annual Compensation Per Position</th> <th>Base Salary</th> <th>Benefits/Annual</th> <th>Annual Compensation Per Position</th> <th>Base Salary</th> <th>Benefits/Annual</th> <th>Annual Compensation Per Position</th> </tr> <tr> <td></td> <td>$64,410</td> <td>$43,311</td> <td>$107,721</td> <td>$60,570</td> <td>$45,391</td> <td>$105,961</td> <td>$90,784</td> <td>$47,583</td> <td>$138,367</td> <td>$93,054</td> <td>$49,922</td> <td>$142,976</td> <td>$95,360</td> <td>$52,327</td> <td>$147,687</td> </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>$2,320</td> <td>$12,172</td> </tr> <tr> <td>Support Supplies & Services</td> <td>$4,987</td> <td>$7,540</td> <td>$12,537</td> </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,909</td> <td>$13,301</td> </tr> </table> Vehicle & Equipment Depreciation Estimate <table> <tr> <th></th> <th>Ballistic Vest</th> <th>Hand Held Radio (1st year depreciation)</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 (1st year depreciation)</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> <td>Vehicle & Equip. Depreciation</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 8 FY 28/29</th> <th>Year 7 FY 28/27</th> <th>Year 6 FY 27/28</th> <th>Year 9 FY 29/29</th> <th>Year 10 FY 29/30</th> </tr> <tr> <td>Personnel Costs</td> <td>$156,835</td> <td>$161,429</td> <td>$168,209</td> <td>$171,156</td> <td>$175,304</td> </tr> <tr> <td>Base Coverage Hours (2*24*365)</td> <td>17,520</td> <td>17,520</td> <td>17,520</td> <td>17,520</td> <td>17,520</td> </tr> <tr> <td>Additional Shifts Per Week (1=40 Hrs., 5=20 Hrs.)</td> <td>-</td> <td>-</td> <td>-</td> <td>-</td> <td>-</td> </tr> <tr> <td>Additional Shift Hours</td> <td>-</td> <td>-</td> <td>-</td> <td>-</td> <td>-</td> </tr> <tr> <td>Total Coverage Hours</td> <td>17,520</td> <td>17,520</td> <td>17,520</td> <td>17,520</td> <td>17,520</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>10.3</td> <td>10.3</td> <td>10.3</td> <td>10.3</td> <td>10.3</td> </tr> <tr> <td>Expense Per Position</td> <td>$156,835</td> <td>$161,429</td> <td>$168,209</td> <td>$171,156</td> <td>$175,304</td> </tr> <tr> <td>FTE's Required</td> <td>10.3</td> <td>10.3</td> <td>10.3</td> <td>10.3</td> <td>10.3</td> </tr> <tr> <td>Personnel Costs</td> <td>$1,609,122</td> <td>$1,655,282</td> <td>$1,705,214</td> <td>$1,765,084</td> <td>$1,808,876</td> </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>$3,796</td> <td>$3,796</td> <td>$3,796</td> <td>$3,796</td> <td>$3,796</td> </tr> <tr> <td>Shift Differential- Additional Shift Hours</td> <td>$-</td> <td>$-</td> <td>$-</td> <td>$-</td> <td>$-</td> </tr> <tr> <td>Holiday Pay- Base Hours</td> <td>$51,200</td> <td>$52,480</td> <td>$53,702</td> <td>$55,138</td> <td>$56,516</td> </tr> <tr> <td>Holiday Pay- Additional Shift</td> <td>$-</td> <td>$-</td> <td>$-</td> <td>$-</td> <td>$-</td> </tr> <tr> <td>Additional Personnel Costs</td> <td>$54,998</td> <td>$56,276</td> <td>$57,598</td> <td>$58,834</td> <td>$60,312</td> </tr> </table> Animal Control Services <table> <tr> <th></th> <th>Annual Service Fee (Per Capita & Average Activity)⁴</th> </tr> <tr> <td></td> <td>$16,063</td> <td>$16,404</td> <td>$16,732</td> <td>$17,087</td> <td>$17,408</td> </tr> </table> Grand Total Annual Expense <table> <tr> <th></th> <th>Year 8 FY 28/29</th> <th>Year 7 FY 28/27</th> <th>Year 6 FY 27/28</th> <th>Year 9 FY 29/29</th> <th>Year 10 FY 29/30</th> </tr> <tr> <td>Grand Total Annual Expense</td> <td>$1,680,261</td> <td>$1,728,942</td> <td>$1,775,534</td> <td>$1,832,056</td> <td>$1,886,898</td> </tr> </table> <table> <tr> <th>% of Total Expense</th> <th>55.00%</th> <th>96.00%</th> <th>97.00%</th> <th>98.00%</th> <th>99.00%</th> </tr> <tr> <th>Monthly Contract Amount</th> <td>$133,015.92</td> <td>$138,315.42</td> <td>$143,845.67</td> <td>$149,617.83</td> <td>$155,644.17</td> </tr> <tr> <th>Proposed Contract Amount</th> <td>$1,598,191</td> <td>$1,658,786</td> <td>$1,728,148</td> <td>$1,795,414</td> <td>$1,867,736</td> </tr> <tr> <th>$ Increase</th> <td>$60,969</td> <td>$65,494</td> <td>$66,383</td> <td>$69,266</td> <td>$72,316</td> </tr> <tr> <th>% increase</th> <td>3.97%</td> <td>3.98%</td> <td>4.00%</td> <td>4.01%</td> <td>4.03%</td> </tr> </table> 1) Salary- Calculated using 2.5% increase annually. 2) Insurance- Calculated using 6.0% increase annually. 3) IFPERS- Calculated using FY 19/20 Deputy ratio of 0.51% 4) Animal Control Service Fee- Calculated using 2.0% increase annually.