WS - C - Law Enforcement Assessment - Final Exhibits

Exhibit A POLK COUNTY SHERIFF'S OFFICE City of Grimes Contract Law Enforcement FY 20/21 through FY 29/30 <table> <tr> <th rowspan="2">Law Enforcement Services</th> <th colspan="5">Year</th> </tr> <tr> <th>1</th> <th>2</th> <th>3</th> <th>4</th> <th>5</th> </tr> <tr> <td>Annual Compensation per Position</td> <td>$76,374</td> <td>$78,283</td> <td>$80,240</td> <td>$82,249</td> <td>$84,302</td> </tr> <tr> <td>Base Salary¹</td> <td>$76,374</td> <td>$78,283</td> <td>$80,240</td> <td>$82,249</td> <td>$84,302</td> </tr> <tr> <td>Benefits/Annual²</td> <td>$4,350</td> <td>$5,995</td> <td>$7,064</td> <td>$9,464</td> <td>$11,337</td> </tr> <tr> <td>Annual Compensation Per Position</td> <td>$110,784</td> <td>$114,278</td> <td>$117,324</td> <td>$121,710</td> <td>$125,839</td> </tr> <tr> <td>Support Supplies & Services Estimate</td> <td colspan="5"></td> </tr> <tr> <td>Vehicle Maint/Operations</td> <td>$4,053</td> <td>$4,185</td> <td>$4,311</td> <td>$4,440</td> <td>$4,673</td> </tr> <tr> <td>Other supplies</td> <td>$6,631</td> <td>$6,314</td> <td>$6,504</td> <td>$6,689</td> <td>$6,900</td> </tr> <tr> <td>Support Supplies & Services</td> <td>$10,684</td> <td>$10,500</td> <td>$10,815</td> <td>$11,129</td> <td>$11,573</td> </tr> <tr> <td>Vehicle & Equipment Depreciation Estimate</td> <td colspan="5"></td> </tr> <tr> <td>Ballistic Vest</td> <td>$200</td> <td>$200</td> <td>$200</td> <td>$200</td> <td>$200</td> </tr> <tr> <td>Hand-Held Radio (10 year depreciation)</td> <td>$450</td> <td>$450</td> <td>$450</td> <td>$450</td> <td>$450</td> </tr> <tr> <td>Vehicle&Equipment Depreciation (See Vehicle Info. Tab)</td> <td>$14,646</td> <td>$14,546</td> <td>$14,646</td> <td>$14,646</td> <td>$14,646</td> </tr> <tr> <td>Vehicle & Equip. Depreciation</td> <td>$15,296</td> <td>$15,296</td> <td>$15,296</td> <td>$15,296</td> <td>$15,296</td> </tr> <tr> <td>Estimated Expense Per Position</td> <td>$136,254</td> <td>$140,074</td> <td>$144,035</td> <td>$148,145</td> <td>$152,406</td> </tr> <tr> <td>Personnel Costs</td> <td colspan="5"></td> </tr> <tr> <td>Base Coverage Hours (2124/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>$136,254</td> <td>$140,074</td> <td>$144,035</td> <td>$148,145</td> <td>$152,406</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,397,965</td> <td>$1,437,156</td> <td>$1,477,788</td> <td>$1,519,969</td> <td>$1,563,710</td> </tr> <tr> <td>Additional Law Enforcement Personnel Costs</td> <td colspan="5"></td> </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>$45,264</td> <td>$46,386</td> <td>$47,444</td> <td>$48,734</td> <td>$49,952</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>$49,060</td> <td>$50,182</td> <td>$51,340</td> <td>$52,530</td> <td>$53,748</td> </tr> <tr> <td>Animal Control Services</td> <td colspan="5"></td> </tr> <tr> <td>Annual Service Fee (Per Capita & Average Activity)⁴</td> <td>$14,567</td> <td>$14,858</td> <td>$16,155</td> <td>$16,458</td> <td>$16,767</td> </tr> <tr> <td>Grand Total Annual Expense</td> <td>$1,461,592</td> <td>$1,592,196</td> <td>$1,614,291</td> <td>$1,587,957</td> <td>$1,633,225</td> </tr> <tr> <td>% of Total Expense</td> <td>90.00%</td> <td>91.00%</td> <td>92.00%</td> <td>93.00%</td> <td>94.00%</td> </tr> <tr> <td>Monthly Contract Amount</td> <td>$109,618.58</td> <td>$113,916.50</td> <td>$119,395.67</td> <td>$123,068.67</td> <td>$127,936.00</td> </tr> <tr> <td>Proposed Contract Amount</td> <td>$1,315,423</td> <td>$1,388,988</td> <td>$1,420,748</td> <td>$1,476,800</td> <td>$1,538,232</td> </tr> <tr> <td>$ Increase</td> <td>$51,575</td> <td>$55,750</td> <td>$56,552</td> <td>$58,432</td> <td>$58,432</td> </tr> <tr> <td>% Increase</td> <td>3.92%</td> <td>3.93%</td> <td>3.95%</td> <td>3.98%</td> <td>3.98%</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.