Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
17-18 First Public Hearing
To: From: RE: Date: lade City of Okeechobee Mayor & City Council Marcos Montes De Oca, City Administrator India Riedel, Finance Director 2018 FY Budget Hearing September 5, 2017 nay t lsinh afed 2/ sp, 5 207 / l ding The use of 96% taxable values and the millage rate of 7.9932 will generate $160, 984 more revenue than last year's budget of $1,914,819. With other amended revenue categories, the total increase excluding reserves is 5.37% as compared to the increase in expenditures in the amount of 3.13 %. • General Fund Revenues increased by 5.37% • General Fund Expenditures, increased by 3.13% Items included in budget ➢ Millage rate of 7.9932 implemented within General Fund (same rate continued from 2016 -17) ➢ Continued the Step Plan for full and part time employees ➢ COLA provided to Employees at2% ➢ Amended Health Insurance Benefit ➢ Added Medical Clinic for employees ➢ Added CRA Study ➢ Added $2,500 for Raulerson /Chandler Log Cabin Project ➢ Continued specific support for o Shared Services Council o Okeechobee Chamber of Commerce (Economic Development) Specific Projects ➢ Continued Replacement of Trees in Flagler Parks ➢ Centennial Park — Irrigation, landscaping, equipment, etc. ➢ Replacement plants for medians ➢ SE 3rd Avenue /SE 6th Street SCOP Project ➢ FDEP — TMDL Grants /project for Taylor Creek ➢ Stormwater Drainage Project — SFWM Grant ➢ SE 8th Avenue Project — Appropriation Grant ➢ Asphalt overlay /replacement project ➢ Continued sidewalk extension projects Page 1 of 2 Other significant budgeted capital items ➢ Replacement Police Vehicles ➢ Add 1/2 ton Fire Chief Truck and replacement of Code Enforcement Vehicle ➢ Add zero turn mowers (for finished mowing) ➢ Replacement roof for the Police Station ➢ HID Security Lock System at Police Station ➢ Video Recording System ➢ Additional handheld emergency radios ➢ Bunker Gear rotation and replacement w/bottles Operating and personnel costs are continually reviewed to provide good service at the least cost. The City continues to effectively manage the dollars available to provide basic services and to improve those services. Page 2 of 2 City of Okeechobee PROPOSED 2017/2018 BUDGET GENERAL FUND RECAPITULATION - REVENUE AND EXPENSES EXHIBIT #5 Disci- lbuftd a! Sep 5 2.617 Mahn9 2015/2016 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED EOY BUDGET AMENDED ESTIMATES PROPOSED F/Y Beginning Fund Balance $ 3,744,185 $ 3,971,869 $ 3,791,160 $ 3,791,160 $ 3,791,160 Roll forward from previous year $ 180,709 $ 272,137 $ 398,002 $ 3,971,869 $ 4,063,297 $ 4,189,162 REVENUE: 96% AD VALOREM 7.9932 $ 1,878,527 $ 1,887,967 $ 1,914,819 $ 1,950,336 $ 2,075,803 OTHER FEES $ 767,468 $ 795,516 $ 682,600 $ 700,641 $ 679,000 INTERGOVERNMENTAL $ 1,482,471 $ 1,523,132 $ 1,431,235 $ 1,545,410 $ 1,540,385 CHARGES FOR SERVICES $ 1,034,192 $ 1,039,506 $ 968,645 $ 995,933 $ 973,750 FINES, FORFEITURES & PET $ 21,158 $ 30,331 $ 14,770 $ 18,463 $ 14,450 USES OF MONEY & PROPEF $ - $ 236 $ 1,000 $ 500 $ 1,000 OTHER REVENUES $ 72,321 $ 84,002 $ 37,946 $ 38,146 $ 37,946 $ 2,195,372 $ 5,256,137 $ 5,360,690 $ 5,051,015 $ 5,249,429 $ 5,322,334 TRANSFERS - IN Public Facilities Fund (Transfe $ 350,000 $ 350,000 $ 350,000 $ 350,000 $ 350,000 CDBG $ - $ - $ - $ - $ - Capital Proj /Improvement Fun $ 103,392 $ 215,638 $ 796,722 $ 751,034 $ 535,453 FINANCIAL SERVICES $ - $ - $ 279,391 $ 279,391 $ 287,630 TOTAL REVENUES $ 5,709,529 $ 5,710,690 $ 6,378,446 $ 6,622,600 $ 6,605,789 EXPENDITURES LEGISLATIVE $ 147,284 $ 141,471 $ 182,699 $ 154,199 $ 192,796 EXECUTIVE $ 189,283 $ 182,639 $ 195,341 $ 195,341 $ 204,524 CITY CLERK $ 218,270 $ 215,638 $ 216,170 $ 208,019 $ 208,758 FINANCIAL SERVICES $ 284,738 $ 276,716 $ 279,391 $ 279,391 $ 287,630 LEGAL COUNCIL $ 61,411 $ 50,612 $ 75,710 $ 75,710 $ 115,760 GENERAL SERVICES $ 386,799 $ 336,696 $ 375,544 $ 356,152 $ 396,520 LAW ENFORCEMENT $ 2,007,697 $ 1,986,689 $ 2,262,583 $ 2,195,372 $ 2,286,473 FIRE PROTECTION $ 1,400,851 $ 1,387,588 $ 1,587,869 $ 1,558,962 $ 1,668,634 ROAD & STREET FACILITI] $ 1,076,816 $ 1,064,873 $ 1,230,079 $ 1,201,452 $ 1,244,675 TOTAL GEN. OPER. EXPENDITURES $ 5,773,149 $ 5,642,922 $ 6,405,386 $ 6,224,598 $ 6,605,770 FISCAL YEAR ENDING FUND BALANCE $ 3,680,565 $ 4,039,637 $ 3,764,220 $ 4,189,162 $ 3,791,179 5.37% - 28.70% 3.13% 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 1 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET GENERAL FUND RECAPITULATION - REVENUE AND EXPENSES 2015/2016 2015/2016 2016/2017 2017/2018 2017/2018 EOY BUDGET Estimates AMENDED ESTIMATES PROPOSED FUND BALANCE $ 3,744,185 $ 3,744,185 $ 3,791,160 $ 3,791,160 $ 3,791,160 Roll Forward from previous year $ 180,709 $ 272,137 $ 398,002 $ 3,971,869 $ 4,063,297 $ 4,189,162 REVENUES TAXES: 311 -1000 96% AD VALOREM @ 7.9932 $ 1,878,527 TOTAL $ 1,878,527 $ 1,887,967 $ 1,887,967 $ 1,914,819 $1,950,336 $2,075,803 $ 1,914,819 $ 1,950,336 $ 2,075,803 OTHER FEES: 312 -5100 312 -5200 314 -1000 314 -4000 314 -8000 316 -0000 319 -0000 Fire Insurance Premium $ 49,888 $ 79,888 $ 50,100 $ 46,500 $ 45,800 Casualty Insurance Prem Tax (Police) $ 76,960 $ 73,960 $ 67,000 $ 64,300 $ 62,000 Utility Tax- Electric $ 499,868 $ 502,380 $ 450,000 $ 464,000 $ 450,000 Utility Tax/Natural Gas $ 20,338 $ 20,338 $ 17,500 $ 22,170 $ 19,700 Utility Tax/Propane $ 34,418 $ 34,561 $ 30,200 $ 30,000 $ 29,000 Prof & Business Tax Receipt $ 77,815 $ 76,208 $ 66,800 $ 73,000 $ 71,500 Public Service Fee $ 8,181 $ 8,181 $ 1,000 $ 671 $ 1,000 TOTAL $ 767,468 $ 795,516 $ 682,600 $ 700,641 $ 679,000 INTERGOVERNMENTAL REVENUES: 335 -1210 335 -1400 335 -1500 335 -1800 312 -6000 315.0000 335 -2300 338 -2000 SRS Cigarette Tax $ 209,082 $ 210,133 $ 197,479 $ 196,500 $ 198,151 Mobile Home Licenses $ 23,090 $ 23,206 $ 19,500 $ 19,500 $ 19,500 Alcoholic Beverage Licenses $ 5,824 $ 6,180 $ 5,200 $ 5,200 $ 5,200 1/2 Cent Sales Tax $ 340,496 $ 342,208 $ 322,800 $ 355,410 $ 355,413 1 Cent Sales Surtax $ 658,272 $ 693,866 $ 656,154 $ 725,600 $ 734,121 Communications Service Tax $ 235,840 $ 237,028 $ 223,913 $ 237,200 $ 222,000 Firefighters Supplement $ 1,200 $ 1,800 $ 1,200 $ 1,200 $ 1,200 County Business Licenses $ 8,667 $ 8,711 $ 4,989 $ 4,800 $ 4,800 TOTAL $ 1,482,471 $ 1,523,132 $ 1,431,235 $ 1,545,410 $ 1,540,385 CHARGES FOR CURRENT SERVICES 322 -0000 322 -1000 323 -1000 323 -4000 323 -7000 329 -0000 341 -2000 341 -3000 341 -4000 343 -4010 Building & Inspections Fees $ 98,661 $ 99,157 $ 79,000 $ 79,000 $ 80,000 Exception & Zoning Fees $ 12,600 $ 12,665 $ 500 $ 5,580 $ 500 Franchise - Electric $ 402,763 $ 404,787 $ 401,000 $ 401,200 $ 400,000 Franchise - Natural Gas $ 8,075 $ 8,217 $ 7,095 $ 12,400 $ 10,200 Franchise -Solid Waste $ 118,430 $ 119,031 $ 103,700 $ 110,453 $ 105,700 Plan Review Fees $ 8,340 $ 8,385 $ 1,500 $ 1,500 $ 1,500 Alley /Street Closing Fees $ - $ - Map Sales $ - $ - $ 25 $ - $ 25 Photocopies $ - - $ - $ 25 $ - $ 25 Solid Waste Collection Fees -Resd. $ 385,323 $ 387,264 $ 375,800 $ 385,800 $ 375,800 TOTAL $ 1,034,192 $ 1,039,506 $ 968,645 $ 995,933 $ 973,750 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 2 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET GENERAL FUND :ECAPITULATION - REVENUE AND EXPENSE 2015/2016 AMENDED 2015/2016 2016/2017 2016/2017 2017/2018 EOY BUDGET AMENDED ESTIMATES PROPOSED FINES, FORFEITURES & PENALTIES: 351 -1000 351 -2000 351 -3000 351 -4000 351 -5000 354 -1000 Court Fines $ 12,573 $ 13,642 $ 8,425 $ 9,100 $ 8,425 Radio Comm. Fee $ 5,300 $ 5,337 $ 4,020 $ 3,700 $ 3,700 Law Enforcement Education $ 1,500 $ 1,809 $ 1,250 $ 1,250 $ 1,250 Investigation Cost Reimbursement $ 1,635 $ 1,647 $ 925 $ 1,513 $ 925 Unclaimed Evidence $ - $ - $ - $ - $ - Ordinance Violation Fines $ 150 $ 7,896 $ 150 $ 2,900 $ 150 TOTAL $ 21,158 $ 30,331 $ 14,770 $ 18,463 $ 14,450 USES OF MONEY & PROPERTY: 361 -1000 361.3000 364 -1000 Interest Earnings $ - $ 236 $ 1,000 $ 500 $ 1,000 Investment Earnings $ - $ - $ - $ - $ - Surplus City Property $ - $ - $ - $ - $ - TOTAL $ - $ 236 $ 1,000 $ 500 $ 1,000 OTHER REVENUES: 334 -2000 343 -9000 343 -9100 343 -9200 366 -1000 369 -1000 369 -4000 369 -5000 383 -0000 Public Safety Grant $ 1,791 $ 1,791 $ - $ - $ - Special Purpose Grant $ - $ - $ - $ - $ - DOT Hwy Maint.Landscape /Mowing $ 8,632 $ 8,632 $ 8,532 $ 8,532 $ 8,532 DOT Master Traffic Signals Maint. $ 16,264 $ 16,264 $ 15,064 $ 15,064 $ 15,064 DOT Maint. Lights & Lights Contract $ 30,053 $ 30,053 $ - $ - $ - Other Revenues $ 2,497 $ 5,997 $ 10,000 $ 10,000 $ 10,000 Miscellaneous $ 5,825 $ 14,006 $ 2,000 $ 2,000 $ 2,000 Code Enforcement Fine $ 4,199 $ 4,199 $ 500 $ 700 $ 500 Police Accident Reports $ 3,060 $ 3,060 $ 1,850 $ 1,850 $ 1,850 Capital Lease Proceeds $ - $ - $ - $ - $ - TOTAL $ 72,321 $ 84,002 $ 37,946 $ 38,146 $ 37,946 OTHER REVENUES AND TRANSFER IN 381 -1000 Impact Fee Transfer in $ - $ - $ - $ - $ - Capital Project Improvements (Transfer -In) $ 103,392 $ 382,371 $ 796,722 $ 751,034 $ 535,453 CDBG Fund (Transfer -In) Public Facilities Improvement (Transfer -In) $ 350,000 $ 350,000 $ 350,000 $ 350,000 $ 350,000 TOTAL $ 453,392 $ 732,371 $ 1,146,722 $ 1,101,034 $ 885,453 TOTAL REVENUE & OTHER FUNDING SOURCES I $ 5,709,529 I $ 6,093,061 $ 6,378,446 1 $ 6,622,600 1 $ 6,605,789 OPERATING TRANSFERS - OUT Due From CDBG Capital Project Building & Improvements Capital Project Vehicles TRANSFERS OUT 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 3 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET General Fund - 001 DEPARTMENT: LEGISLATIVE (0511) 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 4 of 27 2015/2016 AMENDED 2015/2016 2016/2017 2016/2017 2017/2018 EOY BUDGET AMENDED ESTIMATES PROPOSED 1100 EXECUTIVE SALARIES $ 46,100 $ 46,100 $ 46,100 $ 46,100 $ 46,100 1510 LONGEVITY /SERVICE INCENTIVE $ - $ - $ - $ - $ 1,000 2100 FICA $ 3,255 $ 3,015 $ 3,756 $ 3,756 $ 3,756 2200 RETIREMENT $ 3,650 $ 3,625 $ 3,510 $ 3,510 $ 3,510 2300 LIFE AND HEALTH INSURANCE $ 17,784 $ 17,252 $ 40,057 $ 40,057 $ 42,500 2400 WORKERS COMPENSATION $ 225 $ 208 $ 227 $ 227 $ 240 TOTAL PERSONNEL COSTS: $ 71,014 $ 70,200 $ 93,650 $ 93,650 $ 97,106 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 4 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET General Fund - 001 DEPARTMENT: LEGISLATIVE (0511) OPERATIONS & SUPPLIES 2015/2016 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED EOY BUDGET AMENDED ESTIMATES PROPOSED 3400 OTHER CONTRACT SERVICES $ 18,000 $ 18,000 $ 58,000 $ 29,500 $ 61,500 4000 TRAVEL AND PER DIEM $ 2,000 $ 1,240 $ 2,000 $ 2,000 $ 2,500 4100 COMM. & FREIGHT $ 3,200 $ 1,195 $ 3,200 $ 3,200 $ 3,200 4500 INSURANCE $ 3,030 $ 2,856 $ 3,209 $ 3,209 $ 3,350 4609 REPAIR & MAINTENANCE $ 400 $ 480 $ - 4901 EDUCATION $ 1,500 $ 695 $ 1,500 $ 1,500 $ 1,500 4909 MISCELLANEOUS $ 1,000 $ 724 $ 1,000 $ 1,000 $ 1,000 5400 BOOKS, PUBLICATIONS, ETC $ 1,200 $ 1,029 $ 1,200 $ 1,200 $ 1,200 8100 SHARED SERVICES $ 8,940 $ 8,937 $ 8,940 $ 8,940 $ 8,940 8200 AID TO PRIVATE ORGANIZATIONS $ - $ - $ - $ - $ 2,500 8201 INTERLOCAL PART. w/IRSC $ - $ - $ - $ - $ - 8202 LOCAL COMMUNITY REQUEST $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 574 -8300 TOURISM /ECO. DEV /CENTENNIAL $ 27,000 $ 26,115 $ - $ - $ - TOTAL SUPPLIES AND OTHER SERVICES $ 76,270 $ 71,271 $ 89,049 $ 60,549 $ 95,690 'GRAND TOTAL FOR DEPARTMENT I $ 147,284' $ 141,471 $ 182,699 $ 154,199 $ 192,796 PROPOSED CHANGES 2300 Change in Health Benefits 4100 Reallocation of Communication Services based on # of numbers per Dept. 00 Projected Property and Casualty cost for 2018 3400 CAS Legislative Services, $18,000; Balance of Annexation Study Est Cost, $28,500; CRA Study, $15,000 8200 Okeechobee Historical Society Contribution -Log Cabin Proj (Raulerson/Chandler Settlers) 8202 Economic Development (Chamber) 2017 09 05 Budget hearing Workbook.xisx9 /5/20179:02 AM 5 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET General Fund - 001 DEPARTMENT: EXECUTIVE (0512) PERSONNEL COST: 2015/2016 AMENDED 2015/2016 2016/2017 2016/2017 2017/2018 EOY BUDGET AMENDED ESTIMATES PROPOSED 11100 (EXECUTIVE SALARIES $ 80.525 $ 80.534 $ 82,849 $ 82,849 $ 87,822 1200 REGULAR SALARIES $ 42,179 $ 42,767 $ 43,653 $ 43,653 $ 44,995 1510 LONGEVITY /SERVICE INCENTIVE $ - $ - $ - $ - $ - 2100 FICA $ 9,504 $ 9,558 $ 9,864 $ 9,864 $ 10,305 2200 RETIREMENT $ 15,905 $ 15,495 $ 12,700 $ 12,700 $ 12,900 2300 LIFE AND HEALTH INSURANCE $ 17,654 $ 15,805 $ 18,780 $ 18,780 $ 19,900 2400 WORKERS COMPENSATION $ 652 $ 581 $ 722 $ 722 $ 795 TOTAL PERSONNEL COSTS: $ 166,419 $ 164,740 $ 168,568 $ 168,568 $ 176,717 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 6 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET General Fund - 001 DEPARTMENT: EXECUTIVE (0512) SUPPLIES & OTHER SERVICES 2015/2016 AMENDED 2015/2016 2016/2017 2016/2017 2017/2018 EOY BUDGET AMENDED ESTIMATES PROPOSED 4000 TRAVEL AND PER DIEM $ 3,250 $ 2,397 $ 4,000 $ 4,000 $ 4,200 4100 COMM. & FREIGHT $ 4,005 $ 3,335 $ 4,005 $ 4,005 $ 3,707 4400 RENTALS & LEASES $ 2,104 $ 1,850 $ 3,900 $ 3,900 $ 4,100 4500 INSURANCE $ 3,460 $ 3,263 $ 3,668 $ 3,668 $ 3,850 14600 R &M : /EHICLES $ 1,000 1 $ 645 $' 1,550 `� 1,550 $ 1,550 4609 R &M EQUIPMENT $ 1,405 $ 1,023 $ 1,400 $ 1,400 $ 1,400 4901 EDUCATION $ 600 $ 1,001 $ 1,750 $ 1,750 $ 1,750 4909 MISCELLANEOUS $ 500 $ 245 $ 500 $ 500 $ 500 5100 OFFICE SUPPLIES $ 800 $ 650 $ 800 $ 800 $ 800 5200 OPERATING SUPPLY $ 1,200 $ 560 $ 1,200 $ 1,200 $ 1,200 5201 FUEL AND OIL $ 2,340 $ 1,890 $ 3,000 $ 3,000 $ 3,000 5400 BOOKS, PUBLICATIONS, ETC $ 2,200 $ 1,040 $ 1,000 $ 1,000 $ 1,750 6400 EQUIPMENT ($750 OR MORE) $ - $ - $ - $ - $ - TOTAL SUPPLIES AND OTHER SERVICES $ 22,864 $ 17,899 $ 26,773 $ 26,773 $ 27,807 GRAND TOTAL FOR DEPARTMENT $ 189,283 I $ 182,639 I $ 195,341 I $ 195,341 I $ 204,524 PROPOSED CHANGES 2300 Change in Health Benefits 4100 Reallocation of Communication Services based on # of numbers per Dept. 500 Projected Property and Casualty cost for 2018 5400 Add'I Dues and subscriptions 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 7 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET General Fund - 001 DEPARTMENT: CLERK OFFICE (2512 PERSONNEL COST: 2015/2016 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED EOY BUDGET AMENDED ESTIMATES PROPOSED 1100 EXECUTIVE SALARIES $ 80,534 $ 61,918 $ 62,676 $ 62,676 $ 64,570 1200 REGULAR SALARIES $ 42,767 $ 42.387 $ 32.946 1 $ 32.946 ! $ 33,900 1300 OTHER SALARIES $ - $ 24,812 $ 15,100 $ 15,100 $ 15,327 1510 LONGEVITY /SERVICE INCENTIVE $ - $ - $ - $ - $ - 2100 FICA $ 9,558 $ 9,809 $ 8,952 $ 8,952 $ 9,105 2200 RETIREMENT $ 15,495 $ 11,168 $ 9,600 $ 9,600 $ 9,744 2300 LIFE AND HEALTH INSURANCE $ 15,805 $ 15,691 $ 18,582 $ 18,582 $ 19,830 2400 WORKERS COMPENSATION $ 581 $ 215 $ 613 $ 613 $ 685 TOTAL PERSONNEL COSTS: $ 164,740 $ 166,000 $ 148,469 $ 148,469 $ 153,161 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 8 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET General Fund - 001 DEPARTMENT: CLERK OFFICE (2512) SUPPLIES & OTHER SERVICES 2015/2016 2015/2016 2016/2017 2016/2017 2016/2017 AMENDED EOY BUDGET AMENDED ESTIMATES PROPOSED 3103 MUNICIPAL CODE $ 4,500 $ 4,500 $ 4,500 $ 4,500 $ 4,500 3400 (OTHER CONTRACTUAL SERVICES $ 9,000 $ 8,800 $ 9,000 8 9,000. 8 8,800 4000 TRAVEL AND PER DIEM $ 3,000 $ 1,091 $ 3,000 $ 1,200 $ 3,000 4100 COMM. & FREIGHT $ 2,300 $ 2,216 $ 2,300 $ 2,300 $ 2,417 4500 INSURANCE $ 5,190 $ 4,890 $ 5,501 $ 5,250 $ 5,250 4609 R &M EQUIPMENT $ 7,100 $ 6,720 $ 7,100 $ 7,000 $ 7,530 4900 ADVERTISING /OTHER CHARGES $ 15,000 $ 15,705 $ 25,000 $ 21,000 $ 16,550 4901 EDUCATION $ 1,100 $ 376 $ 1,100 $ 600 $ 1,350 4909 MISCELLANEOUS /ELECTION $ 2,340 $ 1,511 $ 6,000 $ 4,500 $ 2,000 5100 OFFICE SUPPLIES $ 2,000 $ 1,840 $ 2,000 $ 2,000 $ 2,000 5400 BOOKS, PUBLICATIONS, ETC $ 2,000 $ 1,989 $ 2,200 $ 2,200 $ 2,200 6400 EQUIPMENT ($750 OR MORE) $ - $ - $ - $ - $ - TOTAL SUPPLIES AND OTHER SERVICES $ 53,530 $ 49,638 $ 67,701 5 59,550 $ 55,597 GRAND TOTAL FOR DEPARTMENT I $ 218,270 I $ 215,638 $ 216,170 $ 208,019 $ 208,758 PROPOSED CHANGES 2300 Change in Health Benefits 4100 Reallocation of Communication Services based on # of numbers per Dept. 00 Projected Property and Casualty cost for 2018 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 9 of 27 75,710 $ 115,760I General Fund - 001 City of Okeechobee PROPOSED 2017/2018 BUDGET DEPARTMENT: LEGAL SERVICES (0514) SUPPLIES & OTHER SERVICES 2015/2016 AMENDED 2015/2016 2016/2017 2016/2017 2017/2018 EOY BUDGET AMENDED ESTIMATES PROPOSED 1510 LONGEVITY F 750 2300 HEALTH INSURANCE $ 7,796 $ 7,796 $ 10,050 $ 10,050 $ 9,350 3100 PROFESSIONAL SERVICES $ 40,786 $ 40,786 $ 51,000 $ 51,000 $ 51,000 3300 LEGAL COST $ 10,160 $ 160 $ 10,500 $ 10,500 $ 50,500 4000 TRAVEL AND PER DIEM $ 738 $ 475 $ 800 $ 800 $ 800 4100 COMM. AND FREIGHT SERVICES $ 534 $ 533 $ 1,010 $ 1,010 $ 1,010 4609 R &M EQUIPMENT $ 332 $ 332 $ 800 $ 800 $ 800 4901 EDUCATION $ 530 $ 530 $ 750 $ 750 $ 750 5100 OFFICE SUPPLIES $ 35 $ - $ 300 $ 300 $ 300 5400 MEMBERSHIP & SUBSCRIPTIONS $ 500 $ - $ 500 $ 500 $ 500 TOTAL SUPPLIES AND OTHER SERVICES $ 61,411 $ 50,612 $ 75,710 $ 75,710 5 115,760 GRAND TOTAL FOR DEPARTMENT $ 61,411 I $ PROPOSED CHANGES 2300 Change in Health Benefits 3300 Booked legal cost 50,612 5 75,710 I $ 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 10 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET General Fund - 001 DEPARTMENT: FINANCE DEPARTMENT (0513) PERSONNEL COST: 2015/2016 AMENDED 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED ESTIMATES PROPOSED 1100 EXECUTIVE SALARIES $ 58,985 $ 59,205 $ 59,120 $ 59,120 $ 61,200 1200 (REGULAR SALARIES $ 68,890 $ 68,181 $ 71,289 c 71,289 $ 73,925 1201 OTHER SALARY $ - $ - $ - 1510 LONGEVITY /SERVICE INCENTIVE $ - $ - 2100 FICA $ 9,294 $ 8,893 $ 10,200 $ 10,200 $ 10,505 2200 RETIREMENT $ 15,542 $ 15,541 $ 13,200 $ 13,200 $ 13,398 2300 LIFE AND HEALTH INSURANCE $ 25,249 $ 25,249 $ 29,629 $ 29,629 $ 31,475 2400 WORKERS COMPENSATION $ 643 $ 642 $ 745 $ 745 $ 820 2500 UNEMPLOYMENT TAXES $ - $ - $ - $ - $ - TOTAL PERSONNEL COSTS: $ 178,603 $ 177,711 $ 184,183 $ 184,183 $ 191,323 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 11 of 27 City of Okeechobee `' PROPOSED 2017/2018 BUDGET General Fund - 001 ARTMENT: FINANCE DEPART SUPPLIES & OTHER SERVICES 2015/2016 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED EOY BUDGET AMENDED ESTIMATES PROPOSED 3200 ACCOUNTING & AUDIT $ 30,739 $ 28,739 $ 37,800 $ 37,800 $ 37,800 3400 OTHER CONTRACTUAL SERVICES $ 40,332 $ 40,332 $ 14,500 $ 14,500 $ 15,000 4000 TRAVEL AND PER DIEM $ 560 $ 260 $ 1,750 $ 1,750 $ 1,750 4100 COMM. & FREIGHT $ 2,257 $ 2,157 $ 2,800 $ 2,800 $ 2,917 4500 INSURANCE $ 5,704 $ 5,704 $ 6,418 $ 6,418 $ 6,600 4609 R &M EQUIPMENT $ 10,486 1 $ 8,786 $ 14,250 $ 14,250 $ i4,250 4901 EDUCATION $ - $ - $ 850 $ 850 $ 850 4909 MISCELLANEOUS $ 30 $ - $ 100 $ 100 $ 100 5100 OFFICE SUPPLIES $ 1,958 $ 958 $ 1,200 $ 1,200 $ 1,200 5200 OPERATING SUPPLY $ 13,991 $ 11,991 $ 15,350 $ 15,350 $ 15,650 5400 BOOKS, PUBLICATIONS, ETC $ 78 $ 78 $ 190 $ 190 $ 190 6400 EQUIPMENT ($750 OR MORE) $ - $ - $ - $ - $ - TOTAL SUPPLIES AND OTHER SERVICES $ 106,135 $ 99,005 $ 95,208 $ 95,208 $ 96,307 TOTAL COST: $ 284,738I PROPOSED CHANGES 2300 Change in Health Benefits $ 276,716 1 $ 279,391 I $ 279,391 I $ 287,630 4100 Reallocation of Communication Services based on # of numbers per Dept. 2400 & 4500 Projected Property and Casualty cost for 2018 3400 Website /and Continuing maintenance/Media Contractual Services 5200 Adding Office 365 annual software (1) Word, Excel, Email, PPT, etc 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 12 of 27 General Fund - 001 City of Okeechobee PROPOSED 2017/2018 BUDGET DEPARTMENT: GENERAL SERVICES (0519) PERSONNEL COST: 2015/2016 AMENDED 2015/2016 2016/2017 2016/2017 2017/2018 EOY BUDGET AMENDED ESTIMATES PROPOSED 1200 REGULAR SALARIES $ 66,934 $ 66,507 $ 68,958 $ 68,958 $ 71,310 1300 OTHER SALARY $ - $ 501 $ 2,315 $ 2,315 $ - 1400 OVERTIME $ - $ - $ - $ - $ - 1510 LONGEVITY /SERVICE INCENTIVE $ - $ - $ - $ - $ - 2100 FICA $ 5,225 $ 5,170 $ 5,577 $ 5,577 $ 5,710 2200 RETIREMENT $ 8,675 $ 8,354 $ 6,900 $ 6,900 $ 7,004 2300 LIFE AND HEALTH INSURANCE $ 16,650 $ 16,451 $ 18,420 $ 18,420 $ 20,556 2400 WORKERS COMPENSATION $ 520 $ 465 $ 590 $ 590 $ 649 TOTAL PERSONNEL COSTS: $ 98,004 $ 97,448 $ 102,760 $ 102,760 $ 105,229 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 13 of 27 $ 336,696 City of Okeechobee PROPOSED 2017/2018 BUDGET General Fund - 001 DEPARTMENT: GENERAL SERVICES (0519) SUPPLIES & OTHER SERVICES 2015/2016 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED EOY BUDGET AMENDED ESTIMATES PROPOSED 3100 PROFESSIONAL SERVICES $ 125,250 $ 114,100 $ 125,250 $ 119,500 $ 124,050 3400 OTHER CONTRACTUAL SERVICES $ 93,896 $ 72,898 $ 80,110 $ 80,000 $ 80,110 4000 TRAVEL AND PER DIEM $ 4,960 $ 1,960 $ 4,960 $ 2,000 $ 4,960 4100 COMM. & FREIGHT $ 2,360 $ 2,207 $ 2,544 $ 2,300 $ 5,374 4300 UTILITIES $ 10,685 $ 8307 $ 9;600 $ 8.600 $ 9,000 4400 RENTALS AND LEASES $ 3,787 $ 3,687 $ 3,687 $ 3,692 $ 3,687 4500 INSURANCE $ 17,176 $ 16,077 $ 18,108 $ 16,900 $ 18,900 4600 R &M VEHICLES $ 1,000 $ 500 $ 1,000 $ 500 $ 500 4609 R &M EQUIPMENT $ 17,456 $ 11,813 $ 16,000 $ 12,500 $ 35,910 4901 EDUCATION $ 300 $ 198 $ 700 $ 100 $ 700 4909 MISCELLANEOUS $ 300 $ - $ 500 $ 500 $ 500 5100 OFFICE SUPPLIES $ 2,900 $ 1,653 $ 2,900 $ 1,800 $ 2,900 5200 OPERATING SUPPLY $ 1,900 $ 1,518 $ 1,900 $ 1,800 $ 1,500 5201 FUEL AND OIL $ 325 $ - $ 325 $ - $ - 5204 POSTAGE & SUPPLIES $ 6,300 $ 4,330 $ 5,000 $ 3,000 $ 3,000 5400 BOOKS, PUBLICATIONS, ETC $ 200 $ - $ 200 $ 200 $ 200 6400 EQUIPMENT ($750 OR MORE) $ - $ - TOTAL SUPPLIES AND OTHER SERVICES $ 288,795 $ 239,248 $ 272,784 $ 253,392 $ 291,291 GRAND TOTAL FOR DEPARTMENT $ 386,799I $ 375,544 I $ 356,152 I $ 396,520 PROPOSED CHANGES 2300 Change in Health Benefits 4100 Reallocation of Communication Services based on # of numbers per Dept. 00 Projected Property and Casualty cost for 2018 3100 Adj. based on revisit of FLUM & Zoning Maps, add? building Official meetings etc 4609 Adding outside Pressure washing, rep stucco, painting (CH, FD, RB), refurb landscaping CH, AED Cabinet, $400, Replace Chamber carpet & baseboards 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 14 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET General Fund - 001 PARTMENT: POLICE DEPARTMENT (0521) PERSONNEL COST: 2015/2016 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED EOY BUDGET AMENDED ESTIMATES PROPOSED 1100 EXECUTIVE SALARIES $ 105,545 $ 103,253 $ 59,600 $ 59,600 $ 72,557 1200 REGULAR SALARIES $ 930,047 $ 925,047 $ 990,400 $ 990,400 $ 1,025,077 1201 HOLIDAY PAY $ - $ - $ - $ - $ - 1202 OFFICERS HOLIDAY PAY $ 20,563 $ 20,563 $ 27,146 $ 27,146 $ 27,533 .300 OTHER SALARY $ 30,548 $ 30,548 $ 26,500 1 $ 26,500 $ 26,998 1400 OVERTIME $ 10,414 $ 10,414 $ 15,000 $ 15,000 $ 7,500 1403 OFFICERS OVERTIME PAY $ 68,113 $ 68,113 $ 89,500 $ 89,500 $ 69,500 1501 AUXILIARY PAY $ 1,200 $ 1,200 $ 1,200 $ 1,200 $ 1,200 1510 LONGEVITY /SERVICE INCENTIVE $ - $ - $ - $ - $ - 1520 OFFICERS LONGEVITY /SERVICE $ 2,000 $ 2,000 $ 500 $ 500 $ - 1540 CAREER EDUCATION $ 13,047 $ 13,047 $ 14,250 $ 14,250 $ 14,250 2100 FICA $ 88,106 $ 87,105 $ 95,815 $ 95,815 $ 98,705 2200 RETIREMENT $ 233,020 $ 230,020 $ 308,400 $ 271,000 $ 279,494 2300 LIFE AND HEALTH INSURANCE $ 220,256 $ 217,256 $ 261,678 $ 261,678 $ 279,980 2400 WORKERS COMPENSATION $ 36,741 $ 36,741 $ 44,215 $ 44,215 $ 48,820 2500 UNEMPLOYMENT COMP. $ - $ - $ 3,200 $ 3,200 $ - TOTAL PERSONNEL COSTS: $ 1,759,600 5 1,745,307 $ 1,937,404 $ 1,900,004 $ 1,951,614 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 15 of 27 $ 1,986,689 City of Okeechobee ral Fund - 001 PROPOSED 2017/2018 BUDGET DEPARTMENT: POLICE DEPARTMENT SUPPLIES & OTHER SERVICES 2015/2016 2015/2016 2016/2017 2016/2017 2016/2017 AMENDED EOY BUDGET AMENDED ESTIMATES PROPOSED 3100 PROFESSIONAL SERVICES $ 19,515 $ 18,515 $ 20,608 $ 21,500 $ 23,826 3400 OTHER CONTRACTURAL SERVICES $ 24,122 $ 21,121 $ 30,728 $ 30,728 $ 30,708 4000 TRAVEL AND PER DIEM $ 3,808 $ 3,808 $ 5,000 $ 6,800 $ 5,000 4100 COMM. & FREIGHT $ 28,780 $ 27,780 $ 34,050 $ 34,000 $ 32,640 4300 UTILITIES $ 14,395 $ 14,394 $ 16,275 $ 14,700 $ 16,275 4400 RENTALS AND LEASES $ 3,690 $ 3,690 $ 5,420 $ 4,000 $ 5,420 4500 INSURANCE $ 44,210 $ 44,210 $ 49,708 $ 46,000 $ 51,500 4600 R &M VEHICLES $ 8,288 $ 8,647 $ 10,000 $ 10,000 $ 15,000 4609 R &M EQUIPMENT $ 15,516 $ 15,945 $ 23,550 $ 23,550 $ 23,550 4700 PRINTING $ 510 $ 217 $ 2,000 $ 800 $ 2,000 14901 EDUCATION- RESTRICTED $ 435 $ 435 $ 4.500 $ 4,500 I $ 4,500 4902 EDUCATION - NON - RESTRICTED $ 800 $ 800 $ 4,500 $ 5,500 $ 4,500 5100 OFFICE SUPPLIES $ 2,015 $ 1,815 $ 5,000 $ 2,300 $ 5,000 5101 DETECTIVE SUPPLIES $ 3,065 $ 3,064 $ 3,000 $ 3,000 $ 3,000 5102 INVESTIGATION FEES $ 326 $ 325 $ 1,800 $ 500 $ 1,800 5200 OPERATING SUPPLY $ 9,208 $ 7,208 $ 17,100 $ 13,000 $ 17,100 5201 FUEL AND OIL $ 40,405 $ 40,404 $ 66,140 $ 45,000 $ 66,140 5202 OPERATING SUPPLIES (TIRES) $ 8,476 $ 8,476 $ 8,000 $ 8,500 $ 8,800 5203 UNIFORMS/PATCHES $ 14,399 $ 14,399 $ 15,300 $ 16,500 $ 15,600 5400 BOOKS, PUBLICATIONS, ETC $ 2,221 $ 2,220 $ 2,500 $ 2,500 $ 2,500 6400 EQUIPMENT ($750 OR MORE) $ 3,913 $ 1,993 $ - $ 1,990 $ - 8300 PUBLIC SERVICE GRANT $ - $ 1,916 $ - $ - $ - 8301 FDOT - Traffic Safety Grant $ - $ - $ - $ - $ - TOTAL SUPPLIES AND OTHER SERVICES $ 248,097 $ 241,382 $ 325,179 $ 295,368 $ 334,859 GRAND TOTAL FOR DEPARTMENT I $ 2,007,697 I $ 2,262,583 I $ 2,195,372 I $ 2,286,473 PROPOSED CHANGES 2300 Change in Health Benefits 4100 Reallocation of Communication Services based on # of numbers per Dept. 2400 & 4500 Projected Property and Casualty cost for 2018 1200 Adding Supplements for 3 Officers -Field Training & Intoxilizer 3100 Multiple yrs without increase (Crime lab) 4100 Added $2,000 for Cellular service for Veh computers 5202 Increase in cost for tire replacement 5203 Increase in cost for uniforms 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 16 of 27 General Fund - 001 City of Okeechobee PROPOSED 2017/2018 BUDGET DEPARTMENT: FIRE DEPARTMENT (0522) PERSONNEL COST: 2015/2016 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED EOY BUDGET AMENDED ESTIMATES PROPOSED 1 100 EXECUTIVE SALARIES $ 70,862 $ 70,862 $ 71,646 $ 71,646 $ 74,169 1200 REGULAR SALARIES $ 634,096 $ 634,096 $ 682,520 $ 682,520 $ 710,232 1201 HOLIDAY PAY $ 20,003 $ 19,003 $ 25,015 $ 25,015 $ 25,390 1300 OTHER SALARY $ 26,530 $ 26,530 $ 28,649 $ 28,649 $ 29,278 1400 OVERTIME $ 24,857 $ 24,856 $ 36.910 $ 36.910 $ 38,800 ,1401 OVERTIME PAY /ANNUAL & SICK $ 61,877 $ 61,876 $ 60,060 $ 60,060 $ 61,500 1402 DISPATCHER OVERTIME $ 4,869 $ 4,869 $ 5,850 $ 5,850 $ 4,750 1501 VOLUNTEER PAY $ 12,845 $ 12,842 $ 12,000 $ 12,000 $ 14,000 1510 LONGEVITY /SERVICE INCENTIVE $ - $ - $ 500 $ 500 $ - 1540 CAREER EDUCATION $ 1,200 $ 1,200 $ 1,200 $ 900 $ 1,200 2100 FICA $ 64,042 $ 63,042 $ 71,800 $ 71,800 $ 74,259 2200 RETIREMENT $ 162,012 $ 158,015 $ 192,040 $ 192,040 $ 190,256 2300 LIFE AND HEALTH INSURANCE $ 111,431 $ 111,431 $ 144,117 $ 144,117 $ 141,050 2400 WORKERS COMPENSATION $ 33,897 $ 33,899 $ 40,690 $ 40,690 $ 43,600 2500 UNEMPLOYMENT COMPENSATION $ - $ - $ - $ - $ - TOTAL PERSONNEL COSTS: 51,228,521 51,222,521 $1,372,997 $1,372,697 51,408,484 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 17 of 27 $ 1,387,588 City of Okeechobee *ilv PROPOSED 2017/2018 BUDGET DEPARTMENT: FIRE DEPARTMENT (0522) SUPPLIES & OTHER SERVICES 2015/2016 2015 /2016 2016/2017 2016/2017 2017/2018 AMENDED EON BUDGET AMENDED ESTIMATES PROPOSED 3100 PROFESSIONAL SERVICES (MD) $ 7,200 $ 7,200 $ 7,800 $ 7,200 $ 8,400 3102 PROF SERV (PHYS FOR SCBA) $ 1,400 $ 1,400 $ 3,800 $ 3,800 $ 3,800 3103 WELLNESS PROGRAM (Gym) $ 2,400 $ 2,400 $ 3,600 $ 3,000 $ 3,600 3400 OTHER CONTRACTUAL SERVICES $ - $ - $ 2,450 $ 2,450 $ 2,450 4000 TRAVEL AND PER DIEM $ 3,218 $ 3,218 $ 3,000 $ 3,000 $ 3,200 4100 COMM. & FREIGHT $ 12,977 $ 12,976 $ 16,403 $ 14,900 $ 23,030 4300 UTILITIES $ 10,515 $ 10,515 $ 14,000 $ 11,500 $ 13,000 4400 RENTALS AND LEASES $ 1,962 $ 1,662 $ 2,400 $ 1,870 $ 2,400 4500 INSURANCE $ 27,084 $ 27,084 $ 30,409 $ 28,500 $ 31,500 4600 R &M VEHICLES $ 30,943 $ 29,943 5 37,000 $ 37,000 $ 72,629 4609 R &M BUILDING & EQUIPMENT $ 27,948 $ 26,943 $ 29,075 $ 29,075 $ 29,075 4700 PRINTING $ - $ - $ 600 $ 150 $ 600 4901 EDUCATION $ 4,950 $ 3,720 $ 11,000 $ 2,500 $ 11,000 4902 PUBLIC EDUCATION & FIRE PREV. $ 1,197 $ 1,197 $ 1,500 $ 1,500 $ 1,500 4903 CODE ENFORCEMENT $ 6,568 $ 5,568 $ 9,000 $ 8,000 $ 9,000 4905 TRAINING & MATERIALS $ 3,821 $ - $ 3,500 $ 1,000 $ 3,500 4909 MISCELLANEOUS $ 358 $ 358 $ 400 $ 400 $ 400 5100 OFFICE SUPPLIES $ 2,173 $ 2,173 $ 2,420 $ 2,420 $ 2,541 5200 OPERATING SUPPLY $ 10,101 $ 10,101 $ 11,825 $ 11,000 $ 11,825 5201 FUEL AND OIL $ 5,983 $ 5,083 $ 9,190 $ 6,100 $ 9,700 5202 OPERATING SUPPLIES (TIRES) $ 4,325 $ 3,951 $ 3,500 $ 2,500 $ 5,000 5203 UNIFORMS /PATCHES $ 4,535 $ 4,434 $ 8,000 $ 5,400 $ 8,000 5400 BOOKS, PUBLICATIONS, ETC $ - $ 2,672 $ 4,000 $ 3,000 $ 4,000 6400 EQUIPMENT ($750 OR MORE) $ 2,672 $ 2,469 $ - $ - $ - TOTAL SUPPLIES AND OTHER SERVICES: $ 172,330 $ 165,067 $ 214,872 $ 186,265 $ 260,150 GRAND TOTAL FOR DEPARTMENT 1 $ 1,400,851 1 1 $ 1,587,869 I $ 1,558,962 1 $ 1,668,634 PROPOSED CHANGES 2300 Change in Health Benefits 4100 Reallocation of Communication Services based on # of numbers per Dept. 2400 & 4500 Projected Property and Casualty cost for 2018 1200 Adding a Fire Captain position on the Step Plan w/base at $44,857 1501 Add'I use of Volunteers to assist with events and coverage of station 1540 2 FF personnel qualify for pass through state dollars for education 4100 Add Cell reimb for Captain; FD increased by 5 %; and balance of increase due to new Communication System 4600 Prior experience indciates higher usage & need; and Rebuild of Ladder truck engine @ $35,000 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 18 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET General Fund - 001 DEPARTMENT: PUBLIC WORKS (0541) PERSONNEL COST: 2015/2016 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED BOY BUDGET AMENDED ESTIMATES PROPOSED 1100 EXECUTIVE SALARIES $ 140,319 $ 140319 $ 143,470 $ 143,470 $ 169,495 1200 REGULAR SALARIES $ 260,800 $ 259,519 $ 310,300 $ 310,300 $ 279,958 1300 OTHER SALARIES $ 7,223 $ 4,223 $ 33,685 $ 33,685 $ 36,000 1400 OVERTIME $ 3,233 $ 3,233 $ 3,500 $ 3,500 $ 3,553 1510 LONGEVITY /SERVICE INCENTIVE $ - $ - $ - $ - $ - 2100 FICA $ 29,737 $ 28,736 $ 39, 123 $ 39,123 $ 40,090 2200 RETIREMENT $ 37,909 $ 33,090 $ 43,500 $ 43,500 $ 37,867 2300 LIFE AND HEALTH INSURANCE $ 75,017 $ 75,017 $ 89,066 $ 89,066 $ 98,900 2400 WORKERS COMPENSATION $ 26,905 $ 26,904 $ 32,240 $ 32,240 $ 33,852 2500 UNEMPLOYMENT COST $ 428 $ 428 $ 300 $ 300 $ 500 TOTAL PERSONNEL COSTS: $ 581,571 $ 571,469 $ 695,184 $ 695,184 5 700,215 2017 09 05 Budget hearing Workbook.xlsx9 /5/2017 19 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET General Fund - 001 DEPARTMENT: PUBLIC WORKS (0541 PROPOSED CHANGES 2300 Change in Health Benefits 4100 Reallocation of Communtication Services based on # of numbers per Dept. 2400 & 4500 3100 4000 4400 4609 4901 Projected Property and Casualty cost for 2018 50 hrs @ $50.00 Consultant fees, $2,500 Travel for cont'd & cross training of employees, Traffic Signals,Pesticide Spaying, MOT Printer Copier Lease for PW Office (reduction in cost overall expected), $1,500 Paint PW Bldgs, minor roof repairs, $2250; Privacy Windscreen Fence,$5,000; Barn Bathroom/Break room upgrades Registration and Certificate fees for cont'd & cross training of employees, Traffic Signals,Pesticide Spaying, MOT 2017 09 05 Budget hearing Workbook.xlsx9 /5/2017 20 of 27 2015/2016 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED EOY BUDGET AMENDED ESTIMATES PROPOSED 3100 PROFESSIONAL SERVICES $ - $ - $ 5,000 $ - $ 5,000 3400 OTHER CONTRACTUAL SERVICES $ - $ - $ 2,800 $ - $ - 3401 GARBAGE COLLECTION FEE $ 366,019 $ 366,019 $ 367,257 $ 370,228 $ 370,228 4000 TRAVEL AND PER DIEM $ 1,535 $ 1,265 $ 2,500 $ 1,500 $ 3,500 4100 COMM. & FREIGHT $ 5,440 $ 5,440 $ 6,500 $ 6,000 $ 7,032 4300 UTILITIES $ 14,516 $ 14,516 $ 18,500 $ 14,900 $ 18,500 4400 RENTALS & LEASES $ 923 $ 823 $ 750 $ 500 $ 2,250 4500 INSURANCE $ 32.32! $ 32.321 $ 35.788 $ 30.900 $ 32.400 4600 R &M VEHICLES $ 6,725 $ 6,751 $ 8,000 $ 8,500 $ 8,500 4605 R &M PARKS $ - $ - $ 7,500 $ 6,200 $ 7,500 4609 R &M BUILDING & EQUIPMENT $ 21,621 $ 21,621 $ 22,500 $ 16,500 $ 31,750 4901 EDUCATION $ 1,602 $ 1,501 $ 4,000 $ 4,800 $ 5,000 4909 MISCELLANEOUS $ 402 $ 402 $ 500 $ 500 $ 500 5100 OFFICE SUPPLIES $ 866 $ 866 $ 750 $ 1,240 $ 1,000 5200 OPERATING SUPPLY $ 6,461 $ 6,526 $ 6,500 $ 6,700 $ 7,000 5201 FUEL AND OIL $ 16,187 $ 15,186 $ 27,050 $ 22,600 $ 27,000 5202 OPERATING SUPPLIES (TIRES) $ 5,396 $ 5,396 $ 3,500 $ 2,700 $ 3,500 5203 UNIFORMS $ 7,341 $ 7,561 $ 6,750 $ 6,400 $ 6,750 5204 DUMPING FEES $ 434 $ 455 $ 750 $ - $ 750 5205 MOSQUITO CONTROL $ 6,956 $ 6,755 $ 7,500 $ 6,000 $ 6,000 5400 BOOKS, PUBLICATIONS, ETC $ 500 $ - $ 500 $ 100 $ 300 6300 IMPROVEMENTS $ - $ - $ - $ - $ - 6400 EQUIPMENT ($750 OR MORE) $ - $ - $ - $ - TOTAL SUPPLIES AND OTHER SERVICES: $ 495,245 $ 493,404 $ 534,895 $ 506,268 $ 544,460 GRAND TOTAL FOR DEPARTMENT $ 1,076,816 $ 1,064,873 $ 1,230,079 $ 1,201,452 $ 1,244,675 PROPOSED CHANGES 2300 Change in Health Benefits 4100 Reallocation of Communtication Services based on # of numbers per Dept. 2400 & 4500 3100 4000 4400 4609 4901 Projected Property and Casualty cost for 2018 50 hrs @ $50.00 Consultant fees, $2,500 Travel for cont'd & cross training of employees, Traffic Signals,Pesticide Spaying, MOT Printer Copier Lease for PW Office (reduction in cost overall expected), $1,500 Paint PW Bldgs, minor roof repairs, $2250; Privacy Windscreen Fence,$5,000; Barn Bathroom/Break room upgrades Registration and Certificate fees for cont'd & cross training of employees, Traffic Signals,Pesticide Spaying, MOT 2017 09 05 Budget hearing Workbook.xlsx9 /5/2017 20 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET Public Facility Fund -301 Public Facility Fund (Transportation) 2015/2016 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED EOY BUDGET AMENDED ESTIMATES PROPOSED F/Y BEGINNING FUND BALANCE $ 415,658 $ 658,676 $ 658,676 $ 638,971 $ 620,571 RE VENUES 301 - 313.4100 LOCAL OPTION GAS TAX $ 366,195 $ 330,400 $ 330,400 $ 350,500 $ 331,500 301 - 313.4200 LOCAL ALTER, FUEL USER FEE $ 228,780 $ 207,500 $ 207,500 $ 220,500 $ 208,000 301- 335.1220 SRS EIGHT CENT MOTOR FUEL $ 65,370 $ 67,500 $ 67,500 $ 66,500 $ 66,500 301 - 312.3000 NINTH CENT FUEL TAX $ 65,997 $ 57,000 $ 57,000 $ 60,500 $ 58,000 301 - 335.4100 MOTOR FUEL TAX REBATE $ 3,032 $ 2,500 $ 2,500 $ 2,500 $ 2,500 301- 361.1000 SCOP Funding $ - $ - $ - $ 57,750 $ 177,537 301- 361.1000 INTEREST EARNINGS $ 230 $ 350 $ 350 $ 350 $ 300 301- 369.1000 MISCELLANEOUS $ 7,244 $ - $ - $ - $ - TOTAL REVENUES 736,848 665,250 665,250 758,600 844,337 EXPENDITURES 301 - 549.3100 PUBLIC FAC. - PROFESSIONAL SER. $ 25,000 $ - $ 25,000 $ 5,000 $ 25,000 301 -549 -3400 PUBLIC FAC. CONTRACTUAL SERVICE $ 77,700 $ 50,091 $ 51,000 $ 47,000 $ 51,000 301 -549 -4300 PUBLIC FAC. UTILITIES $ 87,300 $ 79,514 $ 77,300 $ 30,000 $ 30,000 301 -549 -4609 REPAIR & MAINTENANCE $ 17,500 $ 12,171 $ 18,500 $ 12,000 $ 18,500 301 -549 -4909 MISC -PARK HOLIDAY LIGHTS $ 2,000 $ 2,726 $ 5,000 $ 4,500 $ 10,000 301 -549 -5300 PUBLIC FAC. ROAD & MATERIALS $ 70,000 $ 89,533 $ 65,000 $ 48,500 $ 65,000 301 -549 -6300 PUBLIC FAC. IMPROVEMENTS $ 335,000 $ 335,000 $ 275,000 $ 275,000 $ 205,000 301 -549 -6301 SCOP IMPROVEMENTS $ 57,750 $ 57,750 $ - $ - $ 177,537 301 - 549.6302 PUBLIC FAC. BEAUTIFICATION $ 5,000 $ 5,000 $ - $ 1,500 $ 7,500 301 - 549.6400 PUBLIC FAC. MACHINERY & EQUIP $ 75,000 $ 75,000 $ 174,000 $ 3,500 $ 188,000 TOTAL EXPENSES $ 752,250 $ 706,785 $ 690,800 $ 427,000 $ 777,537 Transfer to General Fund I $ 350,000 I $ 350,000 I $ 350,000 I $ 350,000 I $ 350,000 F/Y ENDING FUND BALANCE I $ 50,256 1 $ 267,141 1 $ 283,126 1 $ 620,571 .1 $ 337,371 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 21 of 27 City of Okeechobee Now PROPOSED 2017/2018 BUDGET 3100 Engineering/ Prot Service: $ 25,000 3400 Grounds Maint. Street Sweeping $ 51,000 4609 Repl small ROW equipment, Chain Saws, pole saws, etc as needed $ 1,500 4909 1 replacement light display $ 8,000 5300 Sign Repair /replacement $ 15,000 Traffic Signal Equipment Upgrades $ 10,000 ROW Drainage $ 10,000 R &M Roads and Culverts $ 10,000 Storm Water Infiltration Repair $ 10,000 Storm Water Ditch Maint Adjustments $ 10,000 6300 Asphalt Program $ 120,000 Sidewalk Program $ 85,000 ' SE 3rd Ave, Park St to SE 4th Ave and 6301 SE 6th St, US 441 to SE 6th Ave $ 177,537 6302 6 Replacement tables, Vet Park and Park 3 $ 6,000 6400 Altoz 66" Rough Cut Mower Deck $ 18,500 6400 Rough cut Altoz all terrain deck $ 3,500 6400 Zero turn mower $ 14,000 6400 Plate Compactor $ 2,000 6400 Sweeper 150,000 2017 09 05 Budget hearing Workbook.xisx9 /5/20179:02 AM 22 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET AL PROJECTS IMPROVEMENTS 2015/2016 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED EOY BUDGET AMENDED ESTIMATES PROPOSED WY BEGINNING FUND BALANCE $ 5,957,923 $ 5,957,923 5 5,729,685 $ 6,150,300 $ 4,136,380 REVENUES 304 - 383.0000 304 - 364.1000 304 - 361.1000 304 - 369.1000 EXPENDITURES $ - $ - $ - $ - $ - DISPOSITION OF FIXED ASSETS $ 246,000 $ 246,000 $ 237,600 $ 237,600 $ 225,000 INTEREST EARNINGS $ 4,000 $ 3,267 $ 5,200 $ 5,200 $ 2,500 MISCELLANEOUS $ 500 $ - $ 500 $ 500 $ 500 TOTAL REVENUES $ 250,500 $ 249,267 $ 243,300 $ 243,300 $ 228,000 EXPENDITURES 1304- 549 -3100 Professional Services $ 40.800 $ 9.453 i 5 25,000 5 25,000 25,000 304 -529 -4600 REPAIR & MAINTENANCE $ 30,562 $ 100 $ 25,000 $ 25,000 $ 25,000 304 -513 -3100 Professional Services $ 22,000 $ - $ 9,500 $ 9,500 $ 9,500 304 -512 -6400 ADMINISTRATION CAPITAL $ 50,000 $ 30,050 $ 6,900 $ 6,900 $ 4,230 304 -513 -6400 FINANCE CAPITAL $ 1,500 $ - $ 2,500 $ 2,500 $ 3,200 304 -519 -6400 GENERAL SERVICES CAPITAL $ 114,500 $ 96,216 $ 66,000 $ 66,000 $ 35,000 304 -521 -6400 LAW ENFORCEMENT CAPITAL $ 419,372 $ 408,526 $ 369,365 $ 369,365 $ 420,205 304 -522 -6400 FIRE PROTECTION CAPITAL $ 50,200 $ 50,200 $ 53,000 $ 53,000 $ 100,800 304 -522 -6401 FIRE PROTECTION CAPITAL $ 3,500 $ - $ 491,000 $ 491,000 $ - 304- 536.6400 SEWER/WASTEWATER $ - $ - $ - $ 12,500 304 -541 -6400 PUBLIC WORKS CAPITAL $ 100,000 $ 3,290 $ 6,900 $ 6,901 $ 19,250 304 -549 -6401 PARKS CAPITAL IMPROVEMENT $ 100,000 $ - $ 50,000 $ 50,000 $ 78,000 304 -549 -6402 MEDIAN REPLACEMENT & ROW $ 50,000 $ - $ 85,000 $ 85,000 $ 30,000 304 - 584.6400 FUTURE CAPITAL PROJECTS $ - $ - $ - $ - $ - 304- 2512 -6400 CLERK CAPITAL $ - $ - $ - $ - $ 18,300 304 - 584.7100 PRINCIPAL $ - $ - $ - $ - $ - 304- 584.7200 INTEREST $ - $ - $ - $ - TOTAL EXPENDITURES $ 982,434 $ 597,835 $ 1,190,165 $ 1,190,166 $ 780,985 $ - TRANSFER OUT TO Other Funds $ 382,162 $ 382,162 $ 316,020 $ 316,020 $ 53,060 TRANSFER OUT TO GENERAL FUND $ 899,441 $ 121,771 $ 796,722 $ 751,034 $ 535,453 TOTAL TRANSFER OUT $ 1,281,603 $ 503,933 $ 1,112,742 $ 1,067,054 $ 588,513 ASSIGNED FUND BALANCE TOTALASSIGNED FUND BALANCE $ - $ - $ - $ - $ - (F/Y ENDING FUND BALANCE $ 4,926,820 $ 5,105,422 $ 3,670,078 $ 4,136,380 $ 2,994,882 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 23 of 27 Acct # 512 -6400 512 -6400 513 -6400 513 -6400 519 -6400 519 -6400 521 -6400 521 -6400 522 -6400 522 -6400 541 -6400 541 -6400 541 -6401 541 -6401 541 -6402 541 -6402 536 -6400 536 -6400 .._. ... .....- ... 2512 -6400 2512 -6400 City of Okeechobee PROPOSED 2017/2018 BUDGET Capital Projects Improvements Specific Projected cost/estimates Dept Description Total Admin Finance Finance General Services General Services Police Police Fire Fire Public Works Public Works Parks Parks Median Rep Med Replacement Sewer /Wastewater Sewer/ Wastewater Clerk Clerk Adim - Carpet, Lateral file cabinet.Admin & Chambers LED fixtures Admin Subtotal Account Clerk desk, lateral file and bookcase Replacement plan for Computers Fin Subtotal New Front Doors @ City Hall New Rear doors @ CH (kit, att off, south& north) GS Subtotal Equipment for new cars including striping, etc. 12 Replacement Police vehicles (Admin vet incl.) 1 - Radar 4 Computers and related equipment (replacements) 6 - Tasers HID Security Lock System New Roof PD Subtotal 2 - Portable Radios SCBA Bottle Replacements (continued reoccurring) SCBA Harnesses (6) Fire Chief Ford F150 P/U w /equipment (lights, etc) Code Enf Veh 2009 Replacement (High Maint) Latitude 'rugged version" Laptop Kitchen table & chairs for upstairs Utility Trailer for Event Veh (golf cart) AED Unit (replacement for Eng 6) Suction device Trk 8, Add for Eng 9 6 - Sets of Bunker Gear 1 - Operations Supervisor Computer Gas Pump Replacement Barn A/C upgrade /replacement Backup Generator Enclosure 6 - Replacement Trees in Flagler Parks Centennial Park - Exercise Equip Centennial Park -BBQ Grills (12) Centennial Park - Irrigation Centennial Park - Landscaping Parks Subtotal Median Replacement & Right of Way Chamber Lift Station and hookup fees Replacement Scanner for Laser Fiche Video recording system Fire Subtotal PW Subtotal Med Repl Subtotal Sewer /Wastewater Clerk Subtotal $4,230.00 $4,230.00 $2,000.00 $1,200.00 $3,200.00 $20,000.00 $15,000.00 $35,000.00 $44,000.00 $276,000.00 $2.200.00 $5,000.00 $8,005.00 $15,000.00 $70,000.00 $420,205.00 $8,000.00 $5,000.00 $8,000.00 $33,000.00 $18,500.00 $2,800.00 $2,500.00 $1,000.00 $4,000.00 $18,000.00 $100,800.00 $750.00 - - - -- - - - -- $10,000.00 $6,000.00 $2,500.00 $19,250.00 $14,000.00 $10,000.00 $4,000.00 $20,000.00 $30,000.00 $78,000.00 $30,000.00 $30,000.00 $12,500.00 $12,500.00 $1,300.00 $17,000.00 $18,300.00 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 24 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET Other Grants RECAPITULATION - REVENUE & EXPENSES 2015/2016 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED EOY BUDGET AMENDED ESTIMATES PROPOSED F/Y BEGINNING FUND BALANCE $ 39,642 $ 39,642 $ 312,162 REVENUES 302 - 331.3903 302 - 331 -3904 302 - 331.3905 302 - 361.1000 302 - 381.0000 302 - 381.0000 TMDL Grant $ - $ - $ 183,630 $ 142,500 $ 41,130 Stormwater Drainage Grant $ - $ - $ 175,000 $ - $ 175,000 Section 319 Grant $ - $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - $ - TRANSFER IN - CAPITAL ASSIGNED FUNDS $ - $ - $ 300,000 $ 300,000 $ - TRANSFER IN - CAPITAL FUND RESERVES $ 64,391 $ 65,162 $ 16,020 $ 16,020 $ 42,610 TOTAL REVENUES $ 64,391 $ 65,162 $ 674,650 $ 458,520 $ 258,740 EXPENDITURES 302 - 2552.3100 302 - 2552.3200 302 - 2552.4609 302 - 2552.4609 302 - 2552.4909 302 - 2000 -4909 302 - 2752.3100 302 - 2752.3200 302 - 2752.4909 302 - 2752.4609 302 - 2752.6300 302 - 2752 -6400 PROFESSIONAL SERVICES $ - $ - $ - $ - $ - ADMINISTRATIVE SERVICES $ - $ - $ - $ - $ - TEMPORARY RELOCATION $ - $ - $ - $ - $ - HOUSING REHAB DEMO/REPL/RELOC $ - $ - $ - $ - $ - MISCELLANEOUS $ - $ - $ - $ - $ - MISCELLANEOUS - BANKING EXP PROFESSIONAL SERVICES $ 38,520 $ 38,520 $ 23,100 $ 14,000 $ 17,682 ADMINISTRATIVE SERVICES $ - $ 5,000 $ 1,000 $ - MISCELLANEOUS $ - $ 1,000 $ 1,000 $ 1,000 STREET IMPROVEMENTS /ADDITIONS $ - $ - $ - $ - INFRASTRUCTURE IMPROVEMENTS $ 175,000 $ 10,338 $ 175,000 Park and Canal Improvements $ 735,000 $ 510,192 $ 159,662 $ 377,220 TOTAL EXPENSES $ 773,520 $ 38,520 $ 714,292 $ 186,000 $ 570,902 F/Y ENDING FUND BALANCE $ 26,642 I $ $ 312,162 I $ DUE TO GENERAL FUND Grant related project Taylor Creek Park TMDL Grant $183,630; Matching, $183,630 (FEDP NS018) SFWM #4600003556 Stormwater Drainage cont. Project, $175,000 Professional Services - Grant application services - $ 150,000 $ 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 25 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET Appropriations Grant RECAPITULATION - REVENUE & EXPENSES IF/Y BEGINNING FUND BALANCE 2015/2016 AMENDED 2015/2016 2016/2017 2016/2017 2017/2018 EOY BUDGET AMENDED ESTIMATES PROPOSED $ REVENUES 307 - 334.3900 307 - 361.1000 307- 381.0000 EXPENDITURES 307 - 559.3100 307 - 559.3102 307 - 559.4909 307 - 559.6300 Appropriation Funds $ 300,000 $ 300,000 $ - $ - $ 209,000 Interest Earnings $ - $ - $ - $ - $ - TRANSFER IN - CAPITAL FUND RESERVES $ 17,000 $ 17,000 $ - $ - $ 10,450 TOTAL REVENUES $ 317,000 $ 317,000 $ - $ - $ 219,450 EXPENDITURES 307 - 559.3100 307 - 559.3102 307 - 559.4909 307 - 559.6300 IF/Y ENDING FUND BALANCE $ 7,500 I $ 334 -3900 SE 8TH Avenue Project 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 26 of 27 PROFESSIONAL SERVICES- Engineering Services $ - $ - $ - $ - $ - PROFESSIONAL SERVICES -Grant Admin $ 9,000 $ 16,500 $ - $ - $ 9,450 ADMINISTRATIVE SERVICES $ 500 $ 500 $ - $ - $ 1,000 STREET IMPROVEMENTS /ADDITIONS $ 300,000 $ 300,000 $ - $ - $ 209,000 TOTAL EXPENSES $ 309,500 $ 317,000 $ - $ - $ 219,450 IF/Y ENDING FUND BALANCE $ 7,500 I $ 334 -3900 SE 8TH Avenue Project 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 26 of 27 City of Okeechobee PROPOSED 2017/2018 BUDGET LAW ENFORCEMENT SPECIAL FUND RECAPITULATION - REVENUE & EXPENSES 2015/2016 2015/2016 2016/2017 2016/2017 2017/2018 AMENDED EOY EST AMENDED ESTIMATES PROPOSED F/Y BEGINNING FUND BALANCE $ 2,995 5,111 4,361 $ 4,361 $ 4,311 REVENUES 601- 351.1000 601- 351.2000 601- 354.1000 601 - 361.1000 601- 369 -1000 EXPENDITURES 601 - 529.4909 601 - 549.6300 601 - 549.6400 LAW ENF. SPECIAL MISC. I $ 1,458 $ 200 $ 250 $ 750 $ 250 LAW ENF. SPECIAL IMPRO CONFISCATED PROPERTY - $ - $ - $ - $ - LAW ENF. SPECIAL MACH & EQUIP FINES LOCAL ORD. VIOL. $ 4,100 $ 850 $ 500 $ 900 $ 500 INTEREST EARNINGS 1,900 1,750 950 1,750 MISCELLANEOUS $ 300 TOTAL REVENUE $ 4,100 S 1,150 S 500 $ 900 5 500 EXPENDITURES 601 - 529.4909 601 - 549.6300 601 - 549.6400 LAW ENF. SPECIAL MISC. I $ 1,458 $ 200 $ 250 $ 750 $ 250 LAW ENF. SPECIAL IMPRO $ - $ - $ - $ - $ - LAW ENF. SPECIAL MACH & EQUIP $ 1,700 $ 1,500 $ 200 $ 1,500 TOTAL EXPENDITURES 1,458 1,900 1,750 950 1,750 F/Y ENDING BALANCES 5,637 $ 4,361 $ 4,311 $ 3,061 2017 09 05 Budget hearing Workbook.xlsx9 /5/20179:02 AM 27 of 27