Okaloosa County BOCC — August 11, 2015 — Agenda Packet — reading text

1 75,000 cabling for Niceville Building 40,000 1 1 40,000 Packet Pg. 97  STATEMENT OF COMMISSIONS AND EXPENDITURES OKALOOSA EXHIBIT B ACTUAL ACTUAL ESTIMATED TOTAL ESTIMATED DESCRIPTION 10/01/13 - 09/30/14 10/01/14 - 06/30/15 07/01/15 - 09/30/15 2014 - 2015 2015 - 2016 (1) (2) (3) (3a) (3b) (4) Commissions: State Motor Vehicles 902,291 627,318 293,585 920,903 925,000 Environmental Protection Game and Fish 21,663 12,893 9,376 22,269 22,500 Sales Tax 10,891 7,331 3,570 10,901 11,500 Drivers License 397,469 247,569 138,375 385,944 410,000 County 3,120,646 3,195,304 15,345 3,210,649 3,331,064 Districts 364,039 390,162 390,162 405,000 Tax Sale 271,746 295,741 295,741 325,000 Advertisements 16,141 23,751 770 24,521 25,000 Business Tax Receipts 94,911 29,144 65,124 94,268 100,000 Tourist Tax 442,267 175,590 287,664 463,254 475,000 Other - List Interest (Earned) 62,383 64,912 8,099 73,011 25,000 Miscellaneous Income 14,251 10,549 4,104 14,653 15,000 Branch Fees 159,517 111,558 50,684 162,242 165,000 Tax Related Fees 108,616 73,276 23,900 97,176 100,000 Birth Certificate Fees 14,413 8,313 5,500 13,813 15,000 Concealed Weapons 1,188 23,430 8,500 31,930 35,000 Rents & Royalties 23,547 16,500 40,047 150,000 Total Commissions $6,002,432 $5,320,388 $931,096 $6,251,484 $6,535,064 Less Total Expenditures/Budget $6,138,244 $6,138,244 $6,477,341 Balance $6,002,432 ($817,856) $931,096 $113,240 $57,723 Col. (3) + (3A) Packet Pg. 98  JUSTIFICATION SHEET OKALOOSA OBJECT CODE AMOUNT OF INCREASE NUMBER NAME SCHEDULE (DECREASE) JUSTIFICATION Salary set by FS 145.11. No increase because no estimate was 11 Official 1A provided at time of budget submittal. Adjustments will be made by DOR upon receipt of final factors. $1,000 across the board COLA for 78 employees ($78,000). 12 Employees (Regular) 1A 149,799.00 Funding (9 months) for previous vacant position #9 ($23,933). 2 new positions requested with funding for 9 months ($47,866). Temp services will be used to perform functions at a reduced costs. 2 part time agents, 50 hours payperiod at $15.187 per 13 Employees (Temporary) 1A 2,366.00 hour, performing clerical duties. 1 part time agent, 40 hours per payperiod at $12.00 per hour, performing clerical duties. *Pay periods are biweekly. Certification Pay for Course Completion / 56 employees @ $1,250, 4 employees @ $938, and 5 employees @ $625 total 15 Special Pay 1A (623.00) $76,877, not including the Tax Collector (see attached certification worksheet). Annual leave payout for employees' separation ($10,000). 2152 FICA Regular 1A 12,346.00 7.65% of total salaries plus special pay ($3,586,941) 2251 Retirement - Official 1A (1,252.00) 42.27% of official salary ($129,152) 7.26% of total employee salary ($3,318,946), plus Temporary pay ($51,966), plus special pay ($86,877), less SMSC employee's 2252 Retirement - Employee 1A 7,515.00 salary pos. #2,3,4,7,60 ($459,580) & DROP employee salary pos. #5 ($71,575), less certification pay for SMSC and DROP ($7,500). ($2,919,134) 21.43% of total SMSC salary pos. #2,3,4,7,60 ($459,580), plus 2253 Retirement - SMS/SES 1A 2,408.00 certification pay ($6,250). ($465,830) 12.88% of total DROP salary pos. #5 ($71,575), plus certification 2254 Retirement - Drop 1A 560.00 pay ($1,250). ($72,825) Packet Pg. 99  Health - 3% increase in premium amount, 79 employees for 12 months ($683,025), 3 employees for 8 months ($17,292), $700,317; Dental - 5% increase in premium amount, 79 employees for 12 months ($20,742), 3 employees for 8 months 23 Life & Health Insurance 1A 20,418.00 ($525), $21,267; Life/LTD - 0% change in premium amount, 79 employees for 12 months ($9,233), 3 employees for 8 months ($234), $9,467. *Amounts are per year. Also included is $8,800 for employee assistance program, identity theft protection, and drug tests. 24 Worker's Compensation 1A 241.00 Amount quoted by BoCC estimate of expected claims for unemployment based on actual 25 Unemployment Comp. 1A FY15 expenses and projected FY16 expenses. internet/cable services, Symantec AV, SKYPE, Webex, 3151 Electronic Data Processing II (3,000.00) Exchange 2013, bankruptcy software license, Accruint software license Bankruptcy, Personnel Issues, TPP tax warrants, Contract 3154 Prof. Services - Legal II 7,340.00 reviews, TDT, Clerk of Court case warrants, and legal retainer fees 3159 Prof. Services - Other II (16,000.00) auditing services to include expenses associated with IT 32 Accounting & Auditing II (1,500.00) penetration audit in-county and out of county travel to include all mileage, per diem, lodging, and misc travel expenses. Also includes travel 40 Travel II (1,883.00) for Field Enforcement Agents and Administrative personnel. See attached travel worksheet. 41 Communications II (1,308.00) phone/wireless service. Postage for DMV renewals, BTR, TDT mailouts, metered mail, 4251 Postage II 3,546.00 certified mail, and priority letters. See attached postage worksheet. electric, natural gas, and water/sewer for Niceville and Destin 43 Utilities II 27,120.00 office locations. (Oct -Dec Niceville has 2 locations) New Niceville location is larger 4451 R/L Office Equipment II 2,480.00 postage machine, letter opener, and copy machines rent (October - December) for Niceville office. Based on CPI 4453 R/L Office Space II (12,300.00) data, minimum 3%. Includes property taxes. property/liability insurance quoted by BCC plus additional for 45 Insurance & Surety II 2,905.00 new Niceville building, association insurance for Destin