Loading...
HomeMy WebLinkAbout08222011 Spc Agenda4o.►— NOW OF FEU CAN MAND SEBASTIAN CITY COUNCIL FY2011/12 BUDGET WORKSHOP SPECIAL MEETING MONDAY, AUGUST 22,2011 — 5:30 PM AGENDA CITY COUNCIL CHAMBERS 1225 MAIN STREET, SEBASTIAN, FLORIDA 1. CALL TO ORDER 2. PLEDGE OF ALLEGIANCE 3. ROLL CALL 4. BUDGET COMMITTEE RECOMMENDATION — Mr. Ed Herlihy 5. FY2011/2012 RECOMMENDED BUDGET A. Budget Presentation/Overview — City Manager B. Department Questions (See Recommended Annual Budget Document) 1) City Council (Page 49) 2) City Manager (Page 53) 3) City Clerk (Page 57) 4) City Attorney (Page 61) 5) Administrative Services (Page 65) 6) Management Information Services (Page 71) 7) Planning and Zoning (Page 75) 8) Police Department (Page 79) A) Administration B) Operations C) Detective Division D) Dispatch Unit E) Code Enforcement Division 9) Public Works (Page 99) A) Roads and Maintenance B) Stormwater Utility C) Garage D) Facilities Maintenance E) Parks and Recreation F) Cemetery 10) Non - Departmental (Page 124) 1 l) Special Revenue Funds (Page 127) and Schedule Eight (Page 206) Note: Updated Schedules are provided in the agenda packets 12) Golf Course (Page 151) 13) Airport (Page 163) 14) Building (Page 169) 6. PUBLIC COMMENTS 7. CITY COUNCIL COMMENTS/DIRECTION 8. ADJOURNMENT ANY PERSON WHO DECIDES TO APPEAL ANY DECISION MADE WITH RESPECT TO ANY MATTER CONSIDERED SUBSEQUENT TO THIS WORKSHOP WILL NEED A RECORD OF THE PROCEEDINGS AND MAY NEED TO ENSURE THAT A VERBATIM RECORD OF THE PROCEEDINGS IS MADE, WHICH RECORD INCLUDES THE TESTIMONY AND EVIDENCE UPON WHICH THE APPEAL IS TO BE HEARD (256.0105 F.S.) IN COMPLIANCE WITH THE AMERICANS WITH DISABILITIES ACT (ADA), ANYONE WHO NEEDS A SPECIAL ACCOMMODATION FOR THIS MEETING SHOULD CONTACT THE CITY'S ADA COORDINATOR AT 589 -5330 AT LEAST 48 HOURS IN ADVANCE OF THIS MEETING. 1 of 17 CITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGETi TABLE G -2 General Fund Revenues Detail GENERAL FUND REVENUE DETAIL Code: 001501 2of17 41 Amended FY 11/12 Account FY 07/08 FY 08109 FY 09/10 FY 10 /11 FY 10 /11 Adopted Number Description Actual Actual Actual Budget Proiected Budget TAXES 311000 Current Ad Valorem Taxes 4,634,338 4,225,106 3,716,797 3,097,353 3,097,353 2,757,335 311001 Delinquent Ad Valorem Taxes 2,906 41,236 15,305 15,000 15,000 15,000 311002 Penalty on Delinquent Taxes 8,419 10,458 2,296 10,000 10,000 10,000 TOTAL AD VALOREM TAXES 4,645,663 4,276,800 3,734,398 3,122,353 3,122,353 2,782,335 FRANCHISE FEES 313100 Electric Franchise Fees 1,140,994 1,260,484 1,159,433 1,385,000 1,200,000 1,285,200 313700 Solid Waste Franchise Fees 58,768 66,769 69,259 65,085 67,000 67,000 TOTAL FRANCHISE FEES 1,199,762 1,327,253 1,228,692 1,450,085 1,267,000 1,352,200 UTILITY SERVICE TAXES 314100 Electric Utility Service Tax 1,130,033 1,174,792 1,305,187 1,462,000 1,300,000 1,413,000 314300 Water Utility Service Tax 217,920 219,953 222,524 220,570 226,000 232,000 314800 Propane Utility Service Tax 30,408 29,606 22,098 29,000 25,000 25,000 314950 CST Revenue Sharing 872,420 917,107 887,241 895,700 880,000 880,000 TOTAL UTILITY SERVICE TAXES 2,250,781 2,341,458 2,437,050 2,607,270 2,431,000 2,550,000 TOTAL TAXES & FRANCHISE FEES 8,096,206 7,945,511 7,400,140 7,179,708 69820,353 6,684,535 LICENSES AND PERMITS 321000 Business Taxes 107,083 0 0 0 0 0 322060 Driveway Permit Fees 7,600 5,925 10,405 7,500 7,500 7,500 322075 Reinspection Fees 70 0 0 0 0 0 322700 Accessory Structure 100 100 300 0 700 250 322900 Other Permits & Fees 1,877 2,256 2,191 1,750 2,000 2,000 329100 Zoning Fees 18,017 7,800 7,381 12,000 7,500 7,500 329200 Site Plan Review Fees 16,450 7,300 7,445 12,000 7,500 7,500 329300 Plat Review Fees 2,950 750 1,200 5,000 5,000 5,000 329400 Plan Checking Fees 5,200 3,400 2,600 5,000 5,000 5,000 329500 Alarm Permits 1,500 1,320 1,460 1,200 1,200 1,200 329600 De- Watering Permits 100 300 200 200 200 200 TOTAL LICENSES AND PERMITS 160,947 29,151 339182 44,650 36,600 36,150 2of17 41 ICITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGETI General Fund Revenues Detail - Continued 3of17 42 FY 10/11 FY 11/12 Account FY 07/08 FY 08/09 FY 09/10 Adopted FY 10 /11 Adopted Number Description Actual Actual Actual Bud a Proiected Bud et INTERGOVERNMENTAL REVENUE: FEDERAL GRANTS 331200 Fed Grant- Public Safety 19,458 41,743 31,218 40,000 40,000 40,000 331204 Fed - LLEBG 0 0 5,834 5,000 5,000 5,000 331901 FEMA - Federal Grant 9,946 0 0 0 0 0 331902 FHWA Grant 0 0 0 0 0 0 TOTAL FEDERAL GRANTS 29,404 41,743 37,052 45,000 45,000 45,000 STATE SHARED REVENUES 335120 Municipal Revenue Sharing 424,592 373,205 376,297 345,000 375,000 375,000 335122 8th Cent Motor Fuel Tax 159,488 149,968 154,094 142,000 155,000 155,000 335140 Mobile Home Licenses 9,844 9,621 9,545 11,000 9,700 9,700 335150 Alcohol Beverage Licenses 10,275 10,700 10,850 10,700 10,700 10,700 335180 Local Half -Cent Sales Tax 1,385,407 1.277,853 1,274,429 1,282,840 1,282,840 1,285,000 335200 Police Pension State Shared Revenue 122,800 137,782 134,852 0 0 0 TOTAL STATE SHARED REVENUES 2,112,406 1,959,129 1,960,067 1,791,540 1,833,240 1,835,400 TOTAL INTER -GOV'T REVENUE 2,141,810 2,000,872 1,997,119 1,836,540 1,878,240 1,880,400 CHARGES FOR SERVICES 341910 Sales -Maps & Publications 157 25 0 50 0 0 341920 Cert. Copying, Record Search 2,467 2,171 1,318 1,800 1,500 1,500 341930 Election Fees 549 488 305 0 0 0 342100 PD Overtime Service Fees 13,184 5,025 26,230 14,000 12,000 12,000 342200 PD Fingerprinting 1,367 1,643 1,190 1,200 1,400 1,200 343805 Cemetery Fees 12,791 11,549 9,129 10,000 10,000 10,000 347550 Skate Facility Fees 8,637 6,358 3,885 6,500 7,000 6,500 347555 Tennis Facility Fees 22,407 18,910 20,130 21,000 21,000 21,000 347556 County Impact Fees Admin. Fees 11.890 2,325 2,211 5,000 5,000 5,000 347557 Community Center Rec Revenues 40,444 38,947 35,820 40,000 40,000 40,000 349140 RRD- Management Fees 12,826 13,202 13,202 13,202 13,202 13,202 349410 Golf Course - Management Fees 50,036 49,509 54,460 59,906 59,906 65,897 349450 Airport- Management Fees 50,036 52,592 36,656 42,980 42,980 44,203 349455 Maintenance Service Fees -AP 2,695 1,329 1,540 1,800 1,800 1,800 349480 Building Dept Administrative Fees 83,394 84,089 75,680 68,112 68,112 61,301 349485 Maintenance Services Fees -Bldg Dept. 1,031 719 774 1,000 1,000 1,000 349950 Special Events Pers Svc Fees 5,212 0 0 0 0 0 TOTAL CHGS FOR SERVICE 1 319,1231 288,881 1 282,530 1 286,550 1 284,900 1 284,603 3of17 42 (CITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGETI General Fund Revenues Detail - Continued 4of17 43 FY 10/11 FY 11/12 Account FY 07/08 FV 08/09 FV 09/10 Adopted FY 10 /11 Adopted Num er Description Actual Actual Actual Budget Projected Budget FINES AND FORFEITS 351100 Court Fines 21,395 18,507 14,585 12,500 15,000 15,000 351115 Police Education -$2.00 Funds 2,707 2,394 1,532 1,500 1,500 1,500 351120 Drivers Education 4,334 2,771 1,790 2,500 2,500 2,500 351140 Parking Fines 1,990 700 1,150 1,000 2,500 2,000 354100 Code Enforcement Fines 12,602 34,402 49,878 45,000 50,000 50,000 359000 OtherFines/Forfeits 3,104 637 2,480 3,000 3,000 3,000 TOTAL FINES AND FORFEITS 46,132 59,411 71,415 65,500 74,500 74,000 MISCELLANEOUS REVENUE: INTEREST EARNINGS 361100 Interest Income 151,388 183,892 138,121 86,000 86,000 86,000 361105 State Board Interest Earnings 47,670 6,030 4,069 2,500 5,000 5,000 361121 Special Assessment- Interest 0 3,357 0 0 0 0 361150 Other Interest 3,324 847 172 1,000 1,000 1,000 TOTAL INTEREST EARNINGS 202,382 194,126 142,362 89,500 92,000 92,000 RENT AND ROYALTIES 362100 Rents and Royalties 3,768 3,843 5,370 4,400 5,000 5,000 362150 Nontaxable Rent 95,516 72,960 74,808 76,400 76,400 76,400 363150 Special Assessment - Riverfront 0 3,849 0 0 0 0 TOTAL RENT AND ROYALTIES 99,284 80,652 80,178 80,800 81,400 81,400 SALE OF FIXED ASSETS 364100 Sale of Fixed Assets 4,994 3,925 15,765 16,000 17,000 17,000 365000 Sale of Surplus Material /Scrap 9,174 5,084 11,349 6,500 5,000 5,000 TOTAL SALES OF FIXED ASSETS 14,168 9,009 27,114 22,500 22,000 22,000 CONTRIBUTIONS /DONATIONS 366000 Contributions & Donations 200 14,649 250 41,038 32,000 10,000 366100 Donatons - Car Seat Program 222 (642) 0 0 0 0 366150 75th Annuversary Revenues 350 250 450 350 600 350 366200 Contribution/Greer Trust 20.400 6,740 6,000 6,000 6,000 6,000 366604 Donations - Public Safety Employees 1,657 1,785 2,213 2,000 2,400 2,000 366605 Donations - General Empl Fund 2,583 3,030 1,929 3,000 3,000 3,000 366805 4th of July Donations 8,470 2,650 2,600 2,500 5,300 2,600 TOTAL CONTRIBUTIONS/DONATIONS 33,882 28,462 13,442 54,888 49,300 23,950 OTHER MISCELLANEOUS REVENUES 367000 Gain/Loss on Sale of Investments 0 (9.218) (14.839) 0 0 0 369100 Motor Fuel Tax Rebate 12,286 12,466 11,387 12,000 12,000 12.000 369200 Insurance Proceeds 10,940 3,785 968 3,000 3,000 3,000 369400 Reimbursements 19,422 57,078 19,834 63,421 25,000 25,000 369900 Other Miscellaneous Revenues 4,713 9,956 5,127 10,000 5,000 5,000 369955 Vend Mach Sales -Gen Empl Fund 1,453 1.323 777 1,500 1,000 1,000 369995 Cash Over /Short 14 15 (5) 15 0 0 369999 Prior Year Recoveries (8.194) 0 550 500 0 0 TOTAL OTHER MISCELLANEOUS REV. 40,644 76,405 23,799 90,436 46,000 46,000 TOTAL MISCELLANEOUS REVENUE 390,360 388,654 286,895 338,124 290,700 265,350 TOTAL REVENUES 11,154,578 10,712,480 10,071,281 9,751,072 9,385,293 9,225,038 4of17 43 (CITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGETI General Fund Revenues Detail - Continued 5of17 44 FY 10 /11 FY 11/12 Account FY 07/08 FY 08/09 FY 09/10 Adopted FY 10 /11 Adopted Number Description Actual Actual Actual Budget Proiected Bud et INTERFUND TRANSFERS 381120 Transfer from 120 LOGT 0 215,784 175,000 175,000 175,000 125,000 381140 Transfer from 140 CRA 0 60,000 60,000 60,000 60,000 60,000 381163 Transfer from 163 STORMWATER 500,000 512,500 500,000 500,000 500,000 500,000 381601 Transfer from 601 CEMETERY TRUS'l 36,538 33,254 29,888 1,727 1,727 2,000 TOTAL INTERFUND TRANSFERS 536,538 821,538 764,888 736,727 736,727 687,000 TOTAL REVENUES AND TRANSFERS 11,691,116 11,534,018 10,836,169 10,454,340 10,122,020 9,912,038 OTHER FINANCING SOURCES 389991 Decrease in Fund Balance 85,079 482,962 0 17,032 0 9,426 TOTAL OTHER SOURCES 85,079 482,962 0 17,032 0 9,426 TOTAL REV. AND OTHER SOURCES 11,776,195 12,016,980 10,836,169 10,504,831 10,122,020 9,921,464 5of17 44 CITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGE Table G -3 lists General Fund expenditures by department/division. Table G -4 lists individual department/division details broken down by salaries & benefits, operating expenses and capital outlay. TABLE G -3 SUMMARY OF GENERAL FUND EXPENDITURES BY DEPARTMENT/DIVISION Total General Fund Expenditures Total Revenues and Transfers Change in Fund Balance S 11,776,197 S 12,025,198 S 10,991,875 S 10,504,831 S 10,306,831 $ 9,921,464 (583,367) 11,691,116 11,534,018 10,836,169 10,504,831 10,122,020 9,912,038 (209,982) S (85,081) S (491,180) S (155,706) S 45 (0) S (184,811) $ (9,426) (9,425) 6of17 Change Amended FY 11/12 From Org FY 07/08 FY 08/09 FY 09/10 FY 10/11 FY 10/11 Adopted FY 10/11 Code Description Actual Actual Actual Budget Projected Budget Budget 010001 City Council S 50,101 S 51,313 S 48,016 S 49,708 S 50,303 S 50,283 575 010005 City Manager 259,187 270,318 249,377 234,642 233,060 234,046 (596) 010009 City Clerk 272,331 290,270 292,969 272,792 272,237 304,390 31,598 010010 City Attorney 215,665 184,450 104,585 125,785 102,332 107,710 (18,075) 010020 Administrative Services 660,776 556,216 489,026 478,562 476,195 477,869 (693) 010021 Management Information Svs. 222,868 262,444 265,376 248,908 272,126 157,996 (90,912) 010041 Police Administration 978,191 1,095,779 781,955 663,341 635,571 648,177 (15,164) 010043 Police Operations 2,414,034 2,606,975 2,534,599 2,398,150 2,459,210 2,217,640 (180,510) 010047 Police Detre Wive Division _730 732 -- 661,582 1,042,894 11111, 791 x,045,493- 97j,419 �I3g3S8) 010049 Police Dispatch Unit 472,647 495,769 475,756 480,087 482,861 492,655 12,568 010045 Code Enforcement Division 155,213 139,478 132,959 164,614 159,614 160,484 (4,130) 010052 Roads and Maintenance 1,193,224 1,241,246 914,388 867,504 813,688 758,719 (108,785) 010053 Stormwater Utility 1,275,691 1,268,576 1,055,577 1,092,457 1,061,282 976,100 (116,357) 010054 Fleet Management 158,370 218,740 210,676 140,219 141,665 197,728 57,509 010056 Facilities Maintenance 264,322 275,126 235,324 252,565 220,576 234,608 (17,957) 010057 Parks and Recreation 1,100,415 1,148,407 983,198 927,627 920,481 886,287 (41,340) 010059 Cemetery 198,134 167,293 142,586 105,232 104,016 160,526 55,294 010080 Planning and Zoning 382,516 380,503 410,049 348,734 344,206 248,150 (100,584) 010099 Non - Departmental 771,776 710,713 622,565 552,107 511,915 636,657 84,550 Total General Fund Expenditures Total Revenues and Transfers Change in Fund Balance S 11,776,197 S 12,025,198 S 10,991,875 S 10,504,831 S 10,306,831 $ 9,921,464 (583,367) 11,691,116 11,534,018 10,836,169 10,504,831 10,122,020 9,912,038 (209,982) S (85,081) S (491,180) S (155,706) S 45 (0) S (184,811) $ (9,426) (9,425) 6of17 (CITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGETI TABLE G -4 General Fund Expenditure by Department/Division 2008 2009 2010 2011 2011 2012 De artment Actual Actual Actual Budget Projected Budget CITY COUNCIL PERSONAL SERVICES $ 22,779 $ 22,753 $ 22,413 $ 22,761 $ 22,747 $ 22,747 OPERATING EXPENDITURES 27,322 28,560 24,819 26,947 27,556 27,536 CAPITAL OUTLAY - - 784 - - - TOTAL S 50,101 $ 51,313 $ 48,016 S 49,7081S 50,303 $ 50,283 CITY MANAGER PERSONAL SERVICES $ 254,023 $ 260,836 $ 243,716 $ 229,734 $ 229,626 $ 230,746 OPERATING EXPENDITURES 5,164 9,482 5,661 4,908 3,434 3,300 CAPITAL OUTLAY - - - - - - TOTAL $ 259,187 S 270,3181S 249,3771$ 234,6421S 233,0601$ 234,046 CITY CLERK PERSONAL SERVICES $ 242,901 1 $ 250,5201 $ 240,520 1 $ 243,373 1 S 243,150 1 $ 249,468 OPERATING EXPENDITURES 29,430 1 39,750 1 52,449 1 29,419 1 29,087 54,922 CAPITAL OUTLAY - - - - - IS TOTAL $ 272,331 1 $ 290,270 1 $ 292,969 1 S 272,792 1 S 272,237 1 $ 304,390 CITY ATTORNEY PERSONAL SERVICES $ 209,562 $ 78,310 $ - $ - $ - $ OPERATING EXPENDITURES 6,103 1 106,140 104,585 125,785 102,332 107,710 CAPITAL OUTLAY - - - - - IS TOTAL S 215,665 S 184,4501S 104,3851S 125,7851S 102,332 107,710 ADMINISTRATIVE SERVICES PERSONAL SERVICES $ 577,960 $ 475,013 $ 401,669 $ 397,517 $ 397,321 $ 399,060 OPERATING EXPENDITURES 82,816 81,202 87,357 81,045 78,874 78,809 1 CAPITAL OUTLAY - - - - - - TOTAL $ 660,776 $ 556,2161$ 4899026 S 478,5621S 476,195 $ 477,869 MANAGEMENT INFORMATION SERVICES PERSONAL SERVICES 198,088 $ 209,848 IS 203,325 1 $ 203,713 $ 229,342 1 $ 117,000 OPERATING EXPENDITURES 15,450 48,139 44,834 40,195 37,784 30,996 CAPITAL OUTLAY 9,329 4,457 17,2171 5,0001 5,000 1 10,000 TOTAL is 222,867 $ 262,444 S 265,376 1 $ 248,908 1 $ 272,126 IS 157,996 PLANNING AND ZONING PERSONAL SERVICES $ 344,247 $ 364,709 $ 368,224 $ 312,127 $ 308,953 $ 227,698 OPERATING EXPENDITURES 35,844 15,794 41,825 36,607 35,253 20,452 CAPITAL OUTLAY - 71,727 2,531 33,294 31,925 - TOTAL S 380,091 S 380,503 $ 410,0491S 348,734 S 344,206 S 248,150 POLICE DEPARTMENT - ADMINISTRATION PERSONAL SERVICES $ 864,466 $ 965,085 $ 671,784 $ 545,161 $ 518,730 $ 536,269 OPERATING EXPENDITURES 96,942 130,694 107,640 118,180 116,841 111,908 CAPITAL OUTLAY 16,783 71,727 2,531 33,294 31,925 - TOTAL S 978,191 $ 1,095,779 $ 781,955 $ 663,341 $ 635,571 $ 648,177 POLICE DEPARTMENT - OPERATIONS PERSONAL SERVICES $ 2,133,640 $ 2,379,437 $ 2,319,598 $ 2,212,532 $ 2,228,470 $ 2,014,805 OPERATING EXPENDITURES 244,162 155,811 183,270 152,324 198,815 202,835 CAPITAL OUTLAY E 36,232 71,727 31,731 33,294 31,925 - TOTAL $ 2,414,034 S 2,606,975 S 2,534,599 $ 2,398,150 S 2,459,210 S 2,217,640 7of17 46 ICITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGETI TABLE G4 General Fund Expenditure by Department/Division - Continued 2008 2009 2010 2011 2011 2012 De artment Actual Actual Actual Budget Projected Budget POLICE DEPARTMENT - DETECTIVE PERSONAL SERVICES $ 613,450 $ 572,907 $ 954,641 S 1,007,012 $ 953,221 $ 880,337 OPERATING EXPENDITURES 115,587 I 85,903 86,483 91,444 89,119 91,102 CAPITAL OUTLAY 1,700 2,772 1,770 3,341 3,153 - TOTAL $ 730,737 $ 661,582 S 1,042,894 $ 1,101,797 S 1,045,493 S 971,439 POLICE DEPARTMENT - DISPATCH PERSONAL SERVICES $ 456,751 1 $ 485,844 1 $ 473,307 1 $ 473,697 1 $ 476,953 I $ 485,710 OPERATING EXPENDITURES 14,7561 3,615 2,449 6,390 1 5,9081 6,945 CAPITAL OUTLAY 1.1401 6,310 32,281 - - - TOTAL $ 472,647 1.$ 495,7691 $ 475,756 15 480,087 1 S 482,861 1 S 492,655 CODE ENFORCEMENT PERSONAL SERVICES $ 115,045 S 119,031 $ 111,852 $ 143,419 $ 139,886 $ 139,916 OPERATING EXPENDITURES 22,740 20,447 21,107 21,195 19,728 20,568 CAPITAL OUTLAY 17,427 - 32,281 - - - TOTAL $ 155,212 S 139,478 S 132,959 $ 164,614 S 159,614 S 160,484 PUBLIC WORKS - ROADS AND MAINTENANCE PERSONAL SERVICES $ 986,384 $ 1,070,698 $ 758,644 1 $ 742,664 1 $ 697,934 1 S 639,416 OPERATING EXPENDITURES 194,555 165,296 123,463 124,8401 114,0891 119,303 CAPITAL OUTLAY 12,285 5,252 32,281 - 1,665 11,000 TOTAL $ 1,193,224 S 1,241,246 S 914,388 I S 867,504 1 S 813.6881 S 758,719 PUBLIC WORKS - STORMWATER UTILITY PERSONAL SERVICES S 540,745 S 525,786 $ 596,385 S 596,056 $ 564,387 $ 461,269 OPERATING EXPENDITURES 679,136 739,766 459,192 496,401 496,895 514,831 CAPITAL OUTLAY 55,810 3,024 - - - 11,000 TOTAL S 1,275,691 S 1,268,576 S 1,055,577 S 1,092,457 S 1,061,282 S 976,100 PUBLIC WORKS - FLEET MANAGEMENT PERSONAL SERVICES $ 127,864 $ 174,408 $ 163,773 $ 120,048 $ 117,475 $ 173,027 OPERATING EXPENDITURES 30,506 41,387 34,903 20,171 24,190 24,701 CAPITAL OUTLAY is 2,945 12,000 12,800 - 11,000 TOTAL 158,370 S 218,740 S 210,676 $ 140,219 S 141,665 $ 197,728 PUBLIC WORKS - PARKS & REC PERSONAL SERVICES S 811,308 $ 879,834 $ 747,688 $ 689,547 S 685,151 $ 648,356 OPERATING EXPENDITURES 268,072 1 268,573 230,091 225,280 223,891 226,931 IS CAPITAL OUTLAY 21,036 - 5,419 12,800 11,439 11,000 TOTAL S 1,100,416 S 1,148,407 S 983,198 $ 927,627 S 920,481 886,287 PUBLIC WORKS - CEMETERY PERSONAL SERVICES $ 125,618 $ 138,155 $ 122,32-2-1 $ 87.1571 S 86,456 $ 125,721 OPERATING EXPENDITURES 23,006 22,131 20,264 1 18,075 17,560 25,805 CAPITAL OUTLAY 49,509 7,007 - 9,000 TOTAL $ 198,133 $ 167,293 S 142,5861 S 105,232 1 S 104,016 S 160,526 8of17 47 CITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGET TABLE G -4 General Fund Expenditure by Department/Division - Continued 2008 2009 2010 2011 2011 2012 IDepartment Actual Budget I Act I Bud I Projected I Budget PUBLIC WORKS - FACILITIES MAINTENANCE PERSONAL SERVICES $ 102,071 $ 1 17,684 S 115,020 $ 112,872 $ 112,215 $ 113,182 OPERATING EXPENDITURES 162,251 157,442 120,304 139,693 108,361 121,426 CAPITAL OUTLAY - is 103,494 103,733 - 53,182 - TOTAL 264,322 S 275,126 $ 235,324 $ 252565 S 220,576 S 234,608 NON - DEPARTMENTAL PERSONAL SERVICES $ 1,268 $ 22,687 $ 20,040 $ 15,000 $ 22,000 $ 139,436 OPERATING EXPENDITURES 770,508 688,026 602,525 537,107 489,915 497,221 INTERFUND TRANSFERS OUT 221,251 103,494 103,733 - 53,182 30,000 CONTINGENCY - TOTAL $ 771,776 S 710,713 $ 622,565 S 552,107 S 511,915 S 636,657 TOTALS PERSONAL SERVICES $ 8,728,170 $ 9,113,545 $ 8,534,921 $ 8,154,390 $ 8,034,017 $ 7,604,163 OPERATING EXPENDITURES 2,824,350 2,808,158 2,353,221 2,29606 2,219,632 2,287,301 CAPITAL OUTLAY 221,251 103,494 103,733 54,435 53,182 30,000 GRANTS AND AIDS INTERFUND TRANSFERS OUT CONTINGENCY - - TOTAL GENERAL FUND S 11,773,770 1 S 12,025,198 $ 10,991,875 1 S 10,504,831 $ 10,306,831 $ 9,921,464 9of17 48 (CITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGETI SCHEDULE EIGHT LOCAL OPTION GAS TAX FUND PROJECTED BALANCES FISCAL YEARS 2012 -2017 10 of 17 204 FY 09 -10 FY 10.11 FY 1142 FY 12 -13 FY 13 -14 FY 14-15 FY 15-16 FY 16.17 Local Option Gas Taxes $ 595,746 $ 585,900 $ 585,900 $ 597,618 $ 609,570 $ 621,762 $ 634,197 $ 646,881 FDOT Lighting Agreement 18,559 9,353 9,353 9,353 9,353 9,353 9,353 9,353 Paving Loan Proceeds 2,462,000 0 0 0 0 0 0 0 Investment Income 4,287 3,000 3,000 2,934 2,871 3,173 3.849 3,907 Local Option Gas Tax Fund Revenues $ 3,080,592 $ 598,253 $ 598,253 $ 609,905 $ 621,794 $ 634,287 S 647,399 $ 660,141 TOTAL Debt Payment 1,256,960 Operating Costs (Street Lights,etc.) 202,193 R/R Crossing Maintenance 41,231 Transfer to General Fund 175,000 Go-Line Grant Match 50,000 Financing Costs 31,100 Street Repaving (Paving Loan) 14.032 1,161,836 Street Repaving 0 81,219 TOTAL 1,770, 516 Debt Payment 264,463 Operating Costs (Street Lights,etc.) 203,000 R/R Crossing Maintenance 4,719 Transfer to General Fund 175,000 Go-Line Grant Match 50,000 TOTAL 1,940,237 Debt Payment 265,792 Operating Costs (Street Lights,etc.) 203,000 R/R Crossing Maintenance 4,719 Transfer to General Fund 125,000 Go-Line Grant Match 50,000 TOTAL 648,511 Debt Payment 264,335 Operating Costs (Street Lights,etc.) 203,000 R/R Crossing Maintenance 4,719 Transfer to General Fund 150,000 TOTAL 622,054 Debt Payment 264,855 Operating Costs (Street Lights) 203,000 R/R Crossing Maintenance 4,719 Transfer to General Fund 125,000 TOTAL 597,574 Debt Payment 265,049 Operating Costs (Street Lights) 203,000 R/R Crossing Maintenance 4,719 Transfer to General Fund 100,000 TOTAL 572,768 Debt Payment 265,073 Operating Costs (Street Lights) 203,000 R/R Crossing Maintenance 4,719 Transfer to General Fund 75,000 Street Repaving 100,000 TOTAL 647,792 Debt Payment 264,461 Operating Costs (Street Lights) 200,000 R/R Crossing Maintenance 4,719 Transfer to General Fund 50,000 Street Repaving 150,000 TOTAL 689,180 BEGINNING FUND BALANCE $ 82,579 $ 1,392,655 $ 50,671 $ 413 $ (11,737) $ 12,483 $ 74,003 $ 73,610 BUDGET REQUIREMENT - 15% OF EXPENSES 70,264 64,200 49,200 52,950 49,200 45,450 41,700 37,500 UNRESTRICTED RESERVE BALANCE $ 12,315 $ 1,328,455 $ 1,471 $ (52,537) S (60,937) $ (32,967) $ 32,303 $ 36,110 TOTAL REVENUES 3,080,592 598,253 598,253 609,905 621,794 634,287 647,399 660,141 TOTAL EXPENDITURES +DEBT +TRANSFERS 1,770,516 1,940,237 648,511 622,054 597,574 572,768 647,792 669,180 ENDING FUND BALANCE $ 1,322,391 $ (13,529) $ (48,787) $ (64,687) $ (36,717) $ 28,553 S 31,910 $ 27,071 10 of 17 204 CITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGE 11 of 17 205 SCHEDULE EIGHT DISCRETIONARY SALES TAX FUND (DST) PROJECTED BALANCES FISCAL YEARS 2012 -2017 FY 09 -10 FY 10 -11 FY 11 -12 FY 12 -13 FY 13 -14 FY 14-15 FY 15 -16 FY 16 -17 DST Revenue $ 2,328,150 $ 2,356,000 $ 2,356,000 $ 2,414,900 $ 2,475,273 $ 2,537,154 $ 2,600,583 $ 2,665,598 Principal from $285,000 Airport Advance 0 0 0 0 600 624 624 624 Interesl from $285,000 Airport Advance 8,550 8,550 8,550 8,550 11,400 11,376 11,376 11,376 Principal from $290,000 Airport Advance 0 0 0 0 0 0 0 900 Investment Income 16.915 15,600 15,600 24,354 25,924 28,432 28,571 29,660 DST PROJECT REVENUE $ 2,353,615 $ 2,380,150 $ 2,380,150 $ 2,447,804 $ 2,513,197 $ 2,577,586 $ 2.641,154 $ 2,706,158 Return on Blossom Ditch (581.095) Potomac Road Crossing 34,510 18,091 City Hall Debt (Retires 2018) 1,162,586 Police Cars 181,838 29,610 114 Round Swale Improvement 1,135,358 TOTAL FY 10 S 1,933,197 City Hall Debt (Retires 2018) 984,268 Police Cars 276,500 Powerline Road 217,408 MIS Equipment for Broadcasting 75,000 Phone System 60,000 512 Corridor 9,195 Stormwater Master Plan 50,000 114 Round Swale Improvement 493,580 Airport Advance for Grant Matching 290,000 TOTAL FY 11 $ 2,503,652 City Hall Debt (Retires 2018) 997,391 Police Cars 185,000 Building Painting - 75,000 Fleet Maintenance Equipment 23,000 US #1 Improvements 300,000 Enhancements to Presidential Streets 310.000 114 Round Swale Improvement 500,000 TOTAL FY 12 $ 2,390,391 City Hall Debt (Retires 2018) 994,621 Police Cars 250,000 Pipe Sliplining (Martin) 80,000 Parking Improvements Share 500,000 114 Round Swale Improvement 500,000 TOTAL FY 13 $ 2.324,621 City Hell Debt (Retires 2018) 995,116 Police Cars/Boat 300,000 512 Median Landscaping 500,000 114 Round Swale Improvement 500,000 TOTAL FY 14 $ 2,295,116 City Hall Debt (Retires 2018) 995,944 Police Cars 300,000 Barber Street Field Lights 300,000 Barber Street Bridge Repairs 500,000 114 Round Swale Improvement 500,000 TOTAL FY 15 $ 2.595.944 City Hall Debt (Retires 2018) 1,013,962 Police Cars 300.000 Road Crossings/Sideyard Pipes 250.1100 Stormwater Pond Installation 500,000 1/4 Round Swale Improvement 500,000 TOTAL FY 16 $ 2,563.962 City Hall Debt (Retires 2018) 1,011,560 Police Cars 300.000 Road Crossings/Sideyard Pipes 250.000 Schumann 8 Barber Intersection 1,500,000 1/4 Round Swale Improvement 500,000 TOTAL FY 17 $ 3,561,560 BEGINNING FUND BALANCE $ 958,676 $ 1,379,094 $ 1,255,592 $ 1,245,351 $ 1,368,535 $ 1,586,615 $ 1,568.258 S 1,645,449 BUDGET RESERVE -10% OF EXPENSES 193,320 250,365 239,039 232,462 229,512 259,594 256,396 356,156 RESERVE FOR ADVANCE TO AIRPORT 285,000 285,000 575,000 575,000 575,000 574,400 573,776 573,152 UNRESTRICTED RESERVE BALANCE $ 480,356 $ 043.729 $ 441,553 $ 437,889 $ 564.023 $ 752,621 $ 738,086 $ 716,141 TOTAL REVENUES 2,353,615 2,380,150 2,380,150 2,447,804 2,513.197 2,577,566 2.641,154 2,708,158 TOTAL EXPENDITURES +DEBT +TRANSFERS 1,933,197 2,503,652 2,390,391 2,324,621 2,295,116 2,595,944 2,563,962 3,561,560 ENDING FUND BALANCE $ 900,774 $ 720,227 $ 431,312 $ 561,073 $ 782,104 $ 734,263 $ 815.277 S (137,261) 11 of 17 205 ICITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGETI SCHEDULE EIGHT RECREATION IMPACT FEE FUNDS PROJECTED BALANCES FISCAL YEARS 2012 -2017 FY 09 -10 FY 10 -11 FY 11 -12 FY 12 -13 FY 13 -14 FY 14-15 FY 15 -16 FY 18 -17 Recreation Impact Fees $ 26,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $20,000 $ 20,000 Investment Income 12,256 8,500 8,500 8,707 5,068 2.820 2,005 2,665 PROJECTED REVENUE $ 38.256 $ 28,500 $ 28,500 $ 28.707 $ 25,068 $ 22,820 $22,005 $ 22,665 Schumann Park 12,350 61,807 Barber Street Fence 1,705 Barber Street Special Needs (25,000) Skate Park Office 16.288 32,594 Splash Park Canopy - 20,802 Hardee Park 35,705 Bark Park 1,569 Engler Park 5,405 Main Street (39) Airport Park 7,021 TOTAL FY 10 19,299 Barber Street Field Expansion 173,660 Easy Street Path Lights 63.000 Riverview Park Pavillion 50,000 Riverview Park Irrigation and Fountains 25,000 Bark Park Amenities 75,000 Riverview Park Street Parking 100,000 Powerline Road 61,000 Periwinkle Park (489) TOTAL FY 11 698,079 Mooting Fields 15,000 Blueway /Signage Improvements 25,000 Barber Street Baseball Field Drainage 50,000 Barber Street Bleacher Shields 50,000 Creative Playground Improvements 30,000 Handicap Pier - Yacht Club 15,000 TOTAL FY 12 185,000 Barber Street Mufti -use Field Lights 150,000 TOTAL FY 13 150,000 Barber Street Equipment Building 100,000 TOTAL FY 14 100,000 Azine Terrace Park 50,000 TOTAL FY 15 50,000 TOTAL FY 16 p TOTAL FY 17 0 BEGINNING FUND BALANCE $ 1,087,353 $ 1.106,310 $ 436,731 $ 280,231 $ 158,938 $ 84,006 $ 56,826 $ 78,831 TOTAL REVENUES 38,256 28,500 28,500 28,707 25,068 22,820 22,005 22,665 EXPENDITURES +DEBT +TRANSFERS 19.299 698,079 185,000 150,000 100,000 50,000 0 0 ENDING FUND BALANCE $ 1.108,310 $ 436,731 $ 280,231 $ 158,938 $ 84,006 $ 56,826 $ 78,831 $ 101,496 FY 09 -10 FY 10 -11 FY 11 -12 FY 12.13 FY 13.14 FY 14 -15 FY 15 -16 FY 16 -17 BEGINNING FUND BALANCE: Zone A 206,698 203,222 44,629 5,247 (26,090) (45,922) (41,463) (36,926) Zone B 53,948 60,323 24,636 24,266 24,520 25,302 (22,849) (22,655) Zone C 96,081 96,804 (12,306) (13,396) (14,312) (14.768) (14.264) (13,767) Zone D 730,626 745,962 379,772 264,114 174,820 119,394 135,402 152,179 All Zones 1,087,353 1,106,310 436,731 280,231 158,938 84.006 56,826 78,831 Recreation Impact Fees Zone A 7,800 81000 6.000 6,000 6,000 6,000 6,000 6,000 Zone B 1,300 1,000 1,000 1,000 1,000 1,000 1,000 1,000 Zone C 1,300 1,000 1,000 1,000 1,000 1,000 1,000 1,000 Zone D _ 15,600 12,000 12,000 12,000 12.000 12,000 12,000 12,000 AN Zones 26,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 Investment Income Zone A 2,470 1,561 869 163 (832) (1,542) (1,463) (1,248) Zone B 549 463 479 754 782 849 (606) (766) Zone C 1,072 744 (240) (416) (456) (496) (503) (465) Zone D 8,165 5,731 7,391 8,206 5,575 4,008 4,777 5,145 AN Zones 12,256 8,500 8.500 8,707 5,068 2,820 2,005 2,665 Transfers: Zone A 13,746 166,154 48,250 37,500 25,000 - Zone B (4,526) 37,150 1,850 1,500 1,000 50,000 Zone C 1,649 110,854 1,850 1,500 1,000 Zone D 8,430 383,921 135,050 109,500 73,000 All Zones 19,298 698,079 185,000 150,000 100,000 50,000 - - Ending Balances: Zone A 203,222 44.629 5,247 (26,090) (45,922) (41,463) (36.926) (32,174) Zone B 60,323 24,638 24,266 24,520 25.302 (22.849) (22,655) (22.421) Zone C 96,804 (12,306) (13.396) (14.312) (14,768) (14,264) (13,767) (13,233) Zone D 745,962 379,772 264,114 174,820 119,394 135,402 152.179 169,324 AN Zones 1,106,310 436,731 280.231 158,938 84,006 56,826 78,831 101,496 12 of 17 206 (CITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGETI Operating Expenditures Kioski FacadelSign Improvement Program Bill Boards or Uniform Signage Special Events Design of Gateway Concept CRA Master Plan Design of CavCorp Flag Pole Yacht Club Finger Piers Transfer to General Fund for Quality Maintenance Match on Waterfront Grant Renovations on Waterfront Properties TOTAL RIVERFRONT CRA FY10 Operating Expenditures Facade/Sign Improvement Program Special Events Transfer to General Fund for Quality Maintenance Big Boards Parking Study Design of Enhancements to Presidential Streets Waterfront Renovations TOTAL RIVERFRONTCRA FY11 Operating Expenditures Far,ade/Sign Improvement Program Special Events Gateway Enhancements Parking Improvement Engineering Transfer to General Fund for Quality Maintenance TOTAL RIVERFRONT CRA FYI Operating Expenditures Facade /Sign Improvement Program Special Events Transfer to General Fund for Quality Maintenance Parking Improvements Share TOTAL RIVERFRONT CRA FY13 Operating Expenditures Facade /Sign improvement Program Special Events Transfer to General Fund for Quality Maintenance TOTAL RIVERFRONT CRA FY14 Operating Expenditures Facade/Sign Improvement Program Special Events Transfer to General Fund for Quality Maintenance TOTAL RIVERFRONT CRA FY15 Operating Expenditures Facade /Sign Improvement Program Special Events Transfer to General Fund for Quality Maintenance TOTAL RIVERFRONT CRA FY16 Operating Expenditures Facade /Sign Improvement Program Special Events Transfer to General Fund for Quality Maintenance TOTAL RIVERFRONT CRA FY17 BEGINNING FUND BALANCE ANNUALREVENUES ANNUAL EXPENDITURES ENDING FUND BALANCE 40,586 4,024 15,370 15,600 34,395 2,000 6,433 11,716 2,377 7,452 60,000 535,119 3,541 738,613 52,954 30,000 36,468 60,000 15,000 27,405 13,500 250,000 485,327 53,954 20,000 36,468 25,000 75,000 60,000 270,422 SCHEDULE EIGHT 53,954 RIVERFRONT CRA FUND 20,000 PROJECTED BALANCES 36,468 FISCAL YEARS 2012 -2017 60,000 FY 09.10 FY 10.11 FY 11 -12 FY 12 -13 FY 13-14 FY 1415 FY 15 -16 FY 16 -17 Tax Increment from City $ 223,426 $ 153,900 $ 137,279 $ 130,415 $ 130,415 $ 134,327 $ 138,357 $ 142,508 Tax Increment from County 206,304 143,720 128,198 121,788 121,788 125,442 129,205 133,081 Rents 3,781 - - - _ - - _ Investment Income 3,055 4,650 4,650 3,937 3,740 3,740 3,852 3,968 SW PROJECTED REVENUE 436,566 302,270 270,127 256,140 255,943 263,509 271,414 279,557 Operating Expenditures Kioski FacadelSign Improvement Program Bill Boards or Uniform Signage Special Events Design of Gateway Concept CRA Master Plan Design of CavCorp Flag Pole Yacht Club Finger Piers Transfer to General Fund for Quality Maintenance Match on Waterfront Grant Renovations on Waterfront Properties TOTAL RIVERFRONT CRA FY10 Operating Expenditures Facade/Sign Improvement Program Special Events Transfer to General Fund for Quality Maintenance Big Boards Parking Study Design of Enhancements to Presidential Streets Waterfront Renovations TOTAL RIVERFRONTCRA FY11 Operating Expenditures Far,ade/Sign Improvement Program Special Events Gateway Enhancements Parking Improvement Engineering Transfer to General Fund for Quality Maintenance TOTAL RIVERFRONT CRA FYI Operating Expenditures Facade /Sign Improvement Program Special Events Transfer to General Fund for Quality Maintenance Parking Improvements Share TOTAL RIVERFRONT CRA FY13 Operating Expenditures Facade /Sign improvement Program Special Events Transfer to General Fund for Quality Maintenance TOTAL RIVERFRONT CRA FY14 Operating Expenditures Facade/Sign Improvement Program Special Events Transfer to General Fund for Quality Maintenance TOTAL RIVERFRONT CRA FY15 Operating Expenditures Facade /Sign Improvement Program Special Events Transfer to General Fund for Quality Maintenance TOTAL RIVERFRONT CRA FY16 Operating Expenditures Facade /Sign Improvement Program Special Events Transfer to General Fund for Quality Maintenance TOTAL RIVERFRONT CRA FY17 BEGINNING FUND BALANCE ANNUALREVENUES ANNUAL EXPENDITURES ENDING FUND BALANCE 40,586 4,024 15,370 15,600 34,395 2,000 6,433 11,716 2,377 7,452 60,000 535,119 3,541 738,613 52,954 30,000 36,468 60,000 15,000 27,405 13,500 250,000 485,327 53,954 20,000 36,468 25,000 75,000 60,000 270,422 207 13 of 17 53,954 20,000 36,468 60,000 250,000 420,422 53,954 30,000 36,468 60,000 180,422 53,954 30,000 36,468 60,000 180,422 53,954 30,000 36,468 60,000 180,422 53,954 30,000 36,468 60,000 160,422 $ 984,638 $ 682,591 $ 499,534 $ 499,239 $ 334,957 $ 410,478 $ 493,565 $ 564,558 436,566 302,270 270,127 256,140 255,943 263,509 271,414 279,557 738,613 485,327 270,422 420,422 180,422 180,422 180,422 160,422 $ 682,591 $ 499,534 $ 499,239 $ 334,957 $ 410,478 $ 493,565 5 584,558 $ 683,693 207 13 of 17 [CITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGETI SCHEDULE EIGHT STORMWATER UTILITY FUND PROJECTED BALANCES FISCAL YEARS 2012 -2017 Profesional Services 100 Series 2003 Issue (Retires 2022) 438.377 Transfer to General Fund for Swale Maintenance 416,000 TOTAL STORMWATER FYI 854,477 Profesional Services FY 09 -10 FY 10 -11 FY 11 -12 FY 12 -13 FY 13 -14 FY 14 -15 FY 15 -16 FY 16 -17 Stormwater Fees $ 819,859 $ 815,000 $ 815,000 $ 839,450 $ 864,634 S 890,573 $ 917,290 $ 944,808 Investment Income 38,806 3,450 3,450 3,028 2,708 2,574 2,724 3,119 SW PROJECTED REVENUE 858,665 818,450 818,450 842,478 867,342 893,146 920,014 947,927 Profesional Services 97 835,080 BEGINNING FUND BALANCE $ 787.481 $ 588,841 $ 316,537 Series 2003 Issue (Retires 2022) 476,221 81,060 $ 98,241 $ 163,777 BUDGET RESERVE - 15% OF EXPENSES 158,596 163,613 Transfer for Collier Creek and George Street 80,987 136,011 131,395 128,172 125.262 UNRESTRICTED RESERVE BALANCE 628,885 Transfer to General Fund for Swale Maintenance 500,000 58,607 (15,552) (50,335) (29.931) 38,515 ANNUAL REVENUES TOTAL STORMWATER FYI 1,057,305 818,450 842,478 867,342 893,146 920,014 947,927 Profesional Services 1,057,305 100 938,623 918,384 906,740 875,966 864,477 Series 2003 Issue (Retires 2022) ENDING FUND BALANCE 438.857 $ 152,924 S 55,571 $ (17,299) S (54,951) $ (33,154) $ Transfer to General Fund for Swale Maintenance 151,363 500,000 Excavation Equipment+ 113,797 Backhoe 20,000 Dump Bed 18,000 TOTAL STORMWATER FY11 1,090,754 Profesional Services 100 Series 2003 Issue (Retires 2022) 438,523 Transfer to General Fund for Swale Maintenance 500,000 TOTAL STORMWATER FY12 938,623 Profesional Services 100 Series 2003 Issue (Retires 2022) 439,284 Transfer to General Fund for Swale Maintenance 479,000 TOTAL STORMWATER FYI 918,384 Profesional Services 100 NPDES 5 Year Permit 7,988 Series 2003 Issue (Retires 2022) 440,652 Transfer to General Fund for Swale Maintenance 458,000 TOTAL STORMWATER FY14 906,740 Profesional Services 100 Series 2003 Issue (Retires 2022) 438,866 Transfer to General Fund for Swale Maintenance 437,000 TOTAL STORMWATER FYI 875,966 Profesional Services 100 Series 2003 Issue (Retires 2022) 438.377 Transfer to General Fund for Swale Maintenance 416,000 TOTAL STORMWATER FYI 854,477 Profesional Services 100 Series 2003 Issue (Retires 2022) 439,980 Transfer to General Fund for Swale Maintenance 395,000 TOTAL STORMWATER FY17 835,080 BEGINNING FUND BALANCE $ 787.481 $ 588,841 $ 316,537 S 196,364 $ 120,459 $ 81,060 $ 98,241 $ 163,777 BUDGET RESERVE - 15% OF EXPENSES 158,596 163,613 140,793 137,758 136,011 131,395 128,172 125.262 UNRESTRICTED RESERVE BALANCE 628,885 425,228 175,744 58,607 (15,552) (50,335) (29.931) 38,515 ANNUAL REVENUES 858,665 818,450 818,450 842,478 867,342 893,146 920,014 947,927 ANNUAL EXPENDITURES 1,057,305 1,090,754 938,623 918,384 906,740 875,966 864,477 835,080 ENDING FUND BALANCE S 430,245 $ 152,924 S 55,571 $ (17,299) S (54,951) $ (33,154) $ 35,606 $ 151,363 14 of 17 208 ITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGE SCHEDULE EIGHT GOLF COURSE FUND PROJECTED BALANCES FISCAL YEARS 2012 -2017 15 of 17 209 FY 09 -10 FY 10 -11 FY 11 -12 FY 12 -13 FY 13 -14 FY 14 -15 FY 15 -16 FY 16 -17 Charges for Services $ 1,297,783 $ 1,269,334 1,271,293 1,271,293 1,271,293 1,271,293 1,271,293 1,271,293 Rents 29,744 30,000 30,000 30,000 30,000 30,000 30,000 30,000 Other Revenue 9,107 3,214 4,360 4,360 4,360 4,360 4,360 4,360 Note Proceeds - - - - - - - 2,500,000 Investment Income 4,921 80 100 237 309 452 655 2,420 PROJECTED REVENUE $ 1,341,555 $ 1,302,628 $ 1,305,753 $ 1,305,890 $ 1,305,962 $ 1,306,105 $ 1,306,308 $ 3,808,073 Operating Costs 1,266,226 Debt Service 321,700 Capital 22,500 TOTAL FY 10 1,610,426 Operating Costs 1,215,467 Capital 4,699 TOTAL FY 11 1,220,166 Operating Costs 1,224,953 Capital 27,500 TOTAL FY 12 1,252,453 Operating Costs 1,224,953 Capital 52,200 TOTAL FY 13 1,277,153 Operating Costs 1,224,953 Capital 24,000 TOTAL FY 14 1,248,953 Operating Costs 1,224,953 Capital 0 TOTAL FY 15 1,224,953 Operating Costs 1,224,953 Debt Service 0 Clubhouse and Improvements 0 TOTAL FY 16 1,224,953 Operating Costs 1,224,953 Debt Service 0 Clubhouse and Improvements 2,500,000 Capital 0 TOTAL FY 17 3,724,953 BEGINNING FUND BALANCE $ (98,395) $ (367,266) $ (284,804) $ (231,504) $ (202,767) $ (145,758) $ (64,606) $ 16,749 TOTAL REVENUES 1,341,555 1,302,628 1,305,753 1,305,890 1,305,962 1,306,105 1,306,308 3,808,073 EXPENDITURES +DEBT +TRFS 1,610,426 1,220,166 1,252,453 1,277,153 1,248,953 1,224,953 1,224,953 3,724,953 ENDING FUND BALANCE $ (367,266) $ (284,804) $ (231,504) $ (202,767) $ (145,758) $ (64,606) $ 16,749 $ 99,869 15 of 17 209 (CITY OF SEBASTIAN, FLORIDA, 2011/2012 ANNUAL BUDGETI SCHEDULE EIGHT AIRPORT FUND PROJECTED BALANCES FISCAL YEARS 2012 -2017 FY 09 -10 FY 10.11 FY 11 -12 FY 12 -13 FY 13 -14 FY 14-15 FY 15-16 FY 16 -17 Net Fuel Sales $ 19,113 $ 20,290 $ 25,600 $ 26,240 $ 26,896 $ 26,896 3 27,568 $ 27,568 Non - taxable Rents 391 391 391 391 391 391 391 391 Golf Course Rents 135,000 135,000 135,000 135,000 135,000 135,000 135,000 135,000 Taxable Rents 168,710 170,787 19500 200,080 205,082 205,082 210,209 210,209 Other Revenue 75,912 69,470 68,000 68,000 68,000 68,000 68,000 68,000 DST Grant Matching Advances - 290,000 - - - - - Investment Income (165) 20 50 71 79 87 96 106 PROJECTED REVENUE $ 398,961 $ 685,958 $ 424,241 $ 429,782 $ 435,448 $ 435,456 $ 441,264 $ 441,275 Operating Costs 386,783 Repayment of DST Fund Advance 8,550 Capital 5,160 Transfer to Construction Fund (1,519) TOTAL FY 10 398,974 Operating Costs 392,536 Repayment of DST Fund Advance 8,550 Transfer to Construction Fund 290,000 TOTAL FY 11 691,086 Operating Costs 399,578 Repayment of DST Fund Advance 17,250 Transfer to Construction Fund 22,500 TOTAL FY 12 439,328 Operating Costs 399,578 Repayment of DST Fund Advance 17,250 Transfer to Construction Fund TOTAL FY 13 416,828 Operating Costs 399,578 Repayment of DST Fund Advance 20,700 Transfer to Construction Fund TOTAL FY 14 420,278 Operating Costs 399,578 Repayment of DST Fund Advance 20,700 Transfer to Construction Fund TOTAL FY 15 420,278 Operating Costs 399,578 Repayment of DST Fund Advance 20,700 Transfer to Construction Fund - TOTAL FY 16 420,278 Operating Costs 399,578 Repayment of DST Fund Advance 24,500 Transfer to Construction Fund TOTAL FY 17 424,078 BEGINNING FUND BALANCE $ (51,652) $ (51,665) $ (56,793) $ (71,880) $ (58,926) $ (43,755) $ (28,577) $ (7,591) TOTAL REVENUES 398,961 685,958 424,241 429,782 435,448 435,456 441,264 441,275 EXPENDITURES +DEBT +TRANSFERS 398,974 691,086 439,328 416,828 420,278 420,278 420,278 424,078 ENDING FUND BALANCE $ (51,665) $ (56,793) $ (71,880) $ (58,926) $ (43,755) $ (28,577) $ (7,591) $ 9,606 16 of 17 210 CITY OF SEBASTIAN, FLORIDA 2011/2012 ANNUAL BUDGET SCHEDULE EIGHT BUILDING FUND PROJECTED BALANCES FISCAL YEARS 2012 -2017 17 of 17 211 FY 09 -10 FY 10 -11 FY 11 -12 FY 12 -13 FY 13-14 FY 14 -15 FY 15 -16 FY 16.17 Operating Revenue $ 355,901 $ 371,700 $ 389,150 $ 396,933 $ 404,872 $ 404,872 $ 412,969 $ 412,969 Other Revenue 363 800 800 800 800 800 800 800 Investment Income 10,738 2,400 2,200 1,274 1,253 1,241 1,236 1,240 PROJECTED REVENUE $ 367,002 $ 374,900 $ 392,150 $ 399,007 $ 406,925 $ 406,912 $ 415,005 $ 415,009 Operating Costs 484,695 TOTAL FY 10 484,695 Operating Costs 459,954 TOTAL FY 11 459,954 Operating Costs 413,059 TOTAL FY 12 413,059 Operating Costs 413,059 TOTAL FY 13 413,059 Operating Costs 413,059 TOTAL FY 14 413,059 Operating Costs 413,059 TOTAL FY 15 413,059 Operating Costs 413,059 TOTAL FY 16 413,059 Operating Costs 413,059 TOTAL FY 17 413,059 BEGINNING FUND BALANCE $ 636,483 $ 518,790 $ 433,736 $ 412,827 $ 398,775 $ 392,641 $ 386,495 $ 388,441 TOTAL REVENUES 367,002 374,900 392,150 399,007 406,925 406,912 415,005 415,009 EXPENDITURES +DEBT +TRANSFERS 484,695 459,954 413,059 413,059 413,059 413,059 413,059 413,059 ENDING FUND BALANCE $ 518,790 $ 433,736 $ 412,827 $ 398,775 $ 392,641 $ 386,495 $ 388,441 $ 390,391 17 of 17 211