Loading...
HomeMy WebLinkAboutItem 07 - FY19-20 BudgetMEMOTO: HONORABLE MAYOR AND MEMBERS OF THE CITY COUNCIL FROM: BRUNO RUMBELOW, CITY MANAGER MEETING DATE: SEPTEMBER 3, 2019 SUBJECT: PUBLIC HEARING ON THE FY 2019-2020 OPERATING BUDGET RECOMMENDATION: City Council to conduct a public hearing on the proposed Fiscal Year 2019-2020 annual operating budget. FUNDING SOURCE: BACKGROUND: Pursuant to Section 907 of the City of Grapevine Charter, a public hearing on the annual budget shall be held to allow all interested persons to be heard for or against any item or the amount of any item therein contained. The public hearing shall commence on September 3, 2019 and final action on the budget shall be taken at the Regular City Council meeting on September 17, 2019. A copy of the proposed FY 2019-2020 budget summary is attached hereto. The budget contains fund expenditures in the following amounts: General Fund 71,054,689 Utility Enterprise Fund 23,948,788 Convention &Visitors Bureau Fund 22,556,423 Crime Control & Prevention District Fund 18,428,614 Debt Service Fund 15,705,883 B Transit Fund 11,106,218 Convention &Visitors Bureau Incentives Fund 4,996,210 Economic Development Fund 4,527,073 Capital/Street Maintenance Fund 3,279,000 Golf Enterprise Fund 3,198,262 Lake Parks Special Revenue Fund 2,921,340 Stormwater Drainage Fund 1,403,131 The FY 2019-2020 Proposed Budget is available online, in the City Secretary's Office at City Hall and at the Grapevine Public Library. GJ/gwl FY 2019-20 PROPOSED OPERATING BUDGET STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE GENERAL FUND 2016-17 2017-18 2018-4 9 2018-19 2019-20 Actual Actual Budget Estimate Proposed BEGINNING FUND BALANCE: 12,753407 111452,240 12,8511591 121851,591 13,9621429 OPERATING REVENUE: Ad Valorem Taxes 916551982 111332,790 11,1651766 111743,533 13104301 Sales Taxes 271153,906 28,2861627 28189000 29,1781900 291616,580 Mixed Beverage Taxes 11733,258 1,792,674 1180000 1,7851000 2105700 Franchise Fees 61602,482 6,8931151 61983,718 6,9331718 61906,950 Licenses & Permits 1191M70 1,631,113 11926,304 1,922,451 11924,422 Charges for Services 111414,297 12,5351663 81974,699 9,2151081 91134,928 Intergovernmental 249,243 3211081 43200 4311825 69707 Fines and Forfeitures 11789,779 1,5821456 11800,452 1,759,147 11728,702 Miscellaneous 31167,512 3,486,795 1,242,400 1,239,915 1,409,000 Total Operating Revenue 63,6761628 671862,350 63,2161029 64,20%570 66,5181270 TRANSFERS IN: Admin. Fee - Utility Fund 1,826,307 1,919,146 10500 1,865,000 10500 Admin. Fee - CVB Fund 1,428,542 15347,770 1,428,000 1,428,000 1,455,526 Admin. Fee - Golf Fund 1081147 107,254 1081000 10800 1081000 Administrative Fee - SDUS Fund 1121127 109,407 1121000 11200 1121000 Administrative Fee - Lake Parks Fund 1441381 16308 6891893 689,893 6891893 Administrative Fee - 4B Fund 3061433 326,478 30600 30600 30600 Transfers In -Housing Authority 1,1091382 109,035 - - - Total Transfers In 5,0351320 43082,178 4,5081893 41508,893 4,5361419 TOTAL REVENUE AND TRANSFERS 68,7111948 7159441529 67,7241922 68,7181463 71,054,689 OPERATING EXPENDITURES: Personnel 29,9751449 321096,812 33,5341842 331467,772 34,4665915 Supplies 3,5651109 3,325,347 3,3111114 31304,492 3,3501597 Maintenance 9891561 11086,978 1,2511755 112491251 1,452,632 Services 11,642,216 11,535,895 11,598,115 11,574,919 12,2711761 Debt Service 1781694 138,071 - - - Capital Outlay 1481958 109,711 921000 911816 1051000 Insurance 14,126,946 12,125,821 8001466 81842,745 8,8911956 Total Operating Expenditures 60,626,933 601418,635 58,6481292 581530,995 6015381861 TRANSFERS OUT: To Permanent Capital Maintenance 1,595,000 1,59500 115101000 1,51000 1,6391500 To Permanent Street Maintenance 116841000 10400 1 ,5 101000 1151000 1,6391500 To Capital Equipment Acquisition Fund 9821000 - - - 8301004 To Community Quality of Life Fund 30000 310001000 3100000 3100000 3001000 To Crime Control & Prevention District Fund 2001000 2123500 3,0565630 31056,630 3,4061824 Total Transfers Out 7,461 NO 8151400 9,0765630 91076,630 10,5155828 TOTAL EXPENDITURES AND TRANSFERS 681087,933 681932,635 67,7241922 6707,625 71,054,689 SURPLUS (DEFICIT) 624,015 3,011,894 - 1,110,838 - ENDING FUND BALANCE: 11,452,240 121851,591 12,8511591 13,962,429 131962,429 FUND BALANCE REQUIREMENT: 10,7321428 l0,491,765 1019031178 101874,726 11,3721574 * Fund balance requirement is 20% of total budgeted expenditures (72 days of operation). The FY 2019-20 projected Ending Fund Balance represents 24% of total budgeted expenditures (88 days of operation). FY 2019-20 PROPOSED OPERATING BUDGET STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE UTILITY ENTERPRISE FUND 2016-17 2017-18 2018-19 2018-19 2019-20 Actual Actual Budget Estimate Proposed BEGINNING UNRESTRICTED FUND BALANCE: 14,4621392 17,2301681 161629M44 16,6291044 171241,876 OPERATING REVENUE: Water Sales 1417101779 1615771391 1516501000 15,6181700 15170000 Wastewater Sales 8105404 8,3711685 80000 7,9841000 8100000 Tap & Inspection Fees 16408 1431010 9000 891820 7700 Reconnects & Transfers 202,962 2011264 21500 2141570 2031000 Interest Income 1751278 302,191 1201000 119,760 3005000 Miscellaneous Income 9455807 25260,356 2051000 204,590 2001500 Total Operating Revenue 24,2541317 27185507 24,2805000 243231,440 24,4805500 TRANSFERS IN/CONTRIBUTIONS: 522,974 6,506 - - - TOTAL REVENUE AND TRANSFERS 24,7771291 273862,404 24,2805000 241231,440 24,4801500 OPERATING EXPENDITURES: Personnel 3041394 31334,960 3013043 3167301 3,8471850 Supplies 6681017 684,185 8971085 895,291 8901960 Maintenance 9541294 11016,243 1,4361900 11434,026 1,512,100 Services 12,9121247 141008,447 13,1171126 131090,892 13,3001200 Debt Service 1251356 2691747 1,564,244 11561,116 1,1301569 Insurance - - 9161393 9141560 9521109 Capital Outlay 27,287 344,983 228,500 2281043 4501000 Total Expenditures 17,771,595 1%658,566 21,841,291 21179708 2203,788 TRANSFERS OUT: 31826,307 810031880 1,821 NO 11821NO 1,86500 TOTAL EXPENDITURES AND TRANSFERS 211597,901 271662,446 2302,291 23161808 23,9481788 SURPLUS / (DEFICIT) 3,1791390 199,958 6171709 612,832 531,712 ENDING UNRESTRICTED FUND BALANCE: 17,23001 16162%044 17,2461753 17,2411876 17,7731588 FUND BALANCE REQUIREMENT: 21843,455 3,1451371 3,4941607 3A71617 3,5331406 * Fund balance requirement is 16% of total net budgeted expenditures or 60 days of operation. The FY 2019-20 projected Ending Working Capital Balance represents 294 days of operation. FY 2019-20 PROPOSED OPERATING BUDGET STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE CONVENTION AND VISITORS BUREAU FUND 2016-17 2017-18 2018-19 2018-19 2019-20 Actual Actual Budget Estimate Proposed BEGINNING FUND BALANCE: 10621169 12,7711586 31567,652 31567,652 4,0551748 OPERATING REVENUE: Occupancy Taxes 13,848,845 14,5771354 141313,754 14,7431167 14,782,796 Facility Rental Income 740,218 8741336 73000 7281540 8151000 Interest Income 107,933 261,730 1500 141970 1811550 Sales & Merchandise 693,286 7471459 67000 6681660 74800 Train Operations 21193,028 2,4021155 1190000 1,896,200 25100,000 Festivals & New Vintage 31784,733 3,4341008 3170000 3021600 3550000 Visitor Shuttle System 114,565 1031346 13500 1341730 9000 Miscellaneous Income 455,823 3685345 38202 3815927 356,173 Total Operating Revenue 215938,430 22,7681732 215846,446 22,2601793 221574,319 TRANSFERS IN: Transfer from 4B Economic Devi. Fund 330,613 3481816 4441610 4441610 464,486 Transfer from General Fund - - - - - Total Transfers In 330,613 3481816 444,610 4441610 464,486 TOTAL REVENUE & TRANSFERS 221269,044 23,117,548 221291,056 2217051403 23,038,805 OPERATING EXPENDITURES: Personnel 516751502 6,0191864 616431975 616301687 71009,317 Supplies 673,654 6771451 8591050 8571332 869,550 Maintenance 313,358 5821576 858,500 8561783 590,500 Services 4,858,162 4,9451945 41683,192 4,6731826 41692,725 Insurance - - 11305,169 1,3021559 15308,164 Festival & Train Operations 41951,624 4,9071482 51332,476 5,3211811 55522,261 Capital Outlay 102,718 5151805 1300 121974 31,000 Total Operating Expenditures 165575,018 17,6495123 191695,362 1 %655,971 205023,517 TRANSFERS OUT: Transfer to General Fund - Admin Fee 11428,542 1,347,770 11455,526 11455,526 11455,526 Transfer to GTRP Fund 2500 251000 2500 2500 2500 Trans. to Debt Service Fund 15081,066 1,1955210 15055,810 11055,810 1,008,380 Transfer to Historic Preservation Fund 45000 1455318 - - - Transfer to Capital Projects Fund - 12001000 - - - Transfer to Heritage Fund - 251000 2500 251000 4400 Total Transfers Out 2198408 14,7381298 21561,336 2,5611336 21532,906 TOTAL EXPENDITURES & TRANSFERS 191559,626 32,3871421 22125608 22,2171307 221556,423 SURPLUS /(DEFICIT) 21709,417 (9,269,873) 34,358 488,096 482,382 ENDING FUND BALANCE: 12,771,586 3,5671652 31602,010 41055,748 41538,130 FUND BALANCE REQUIREMENT: 2172400 219011226 31237,594 31231,1 19 31291,537 * Fund balance requirement is 16.4% of total budgeted expenditures (60 days of operation). The FY 2019-20 projected Ending Fund Balance represents 83 days of operation. FY 2019-20 PROPOSED OPERATING BUDGET STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE CRIME CONTROL & PREVENTION DISTRICT 2016-17 2017-18 2018-19 2018-19 2019-20 Actual Actual Budget Estimate Proposed BEGINNING FUND BALANCE: 1,4381034 (343,841) (759,398) (759,398) (586,058} OPERATING REVENUE: Sales Tax (1/2 cent) 131229,439 13,670499 14144500 14,5891450 1408,290 Commercial Vehicle Enforcement 121,186 1061396 15000 1491700 10700 Interest Income 18,550 641703 3000 295940 10000 Miscellaneous 23,167 285316 6,500 61487 6,500 Total Operating Revenue 131392,342 13,8695915 141631,500 14,7755577 151021,790 TRANSFERS IN: Transfer from General Fund 20000 2,2351000 35056,630 3,0501517 35406,824 Total Transfers In 20000 2,2351000 31056,630 3,0503517 31406,824 TOTAL REVENUE AND TRANSFERS 135592,342 161104,915 173688,130 17,8265094 185428,614 OPERATING EXPENDITURES: Personnel 111396,293 12,3921580 123615,162 12,5891932 13137%045 Supplies 557,482 5181211 560,479 5591358 566,339 Maintenance 88,341 2003695 18000 1791640 154,300 Insurance - - 31050,918 3,0441816 31068,318 Services 31248,466 31408,987 11281,571 1,279,008 11260,612 Capital Outlay 21,633 - - - - Total Operating Expenditures 151312,215 16,5201473 17081130 17,652,754 181428,614 TRANSFERS OUT: Transfer out to Fund 325 6200 - - - - Total Transfers Out 6200 - - - - TOTAL EXPENDITURES AND TRANSFERS 151374,215 16,5205473 171688,130 1716521754 181428,614 SURPLUS / (DEFICIT) (11781,873) (415,558) - 1731340 - ENDING FUND BALANCE: (343,841) (759,398) (759,398) (586,058) (586,058} 36 FY 2019-20 PROPOSED OPERATING BUDGET STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE DEBT SERVICE FUND 2016-17 2017-18 2018-19 2018-19 2019-20 Actual Actual Budget Actual Proposed BEGINNING FUND BALANCE: 1317601380 10,922,692 8,918,782 8,918,782 8,420,174 OPERATING REVENUE: Property Taxes Current 10,695,120 11,132,714 12021510 1202,510 131001,947 Property Taxes Delinquent 77,252 176492 701000 7000 701000 Interest Income 1451814 195,190 1501000 15000 1501000 Total Operating Revenue 10,918,185 11,504,395 13,082,510 13,082,510 13,221,947 TRANSFERS IN: Transfer from CVB Fund 1,081,066 11195,210 1,057,691 1,057,691 985,670 Transfer from Economic Development Fund 1,593,409 1,592,714 1,396,444 1,396,444 11401,394 Transfer from Capital Projects Fund - 309,175 - - - Bond Proceeds/Refunding/Premiums 11412,775 - - - - Total Transfers In 4,087,250 3,097,099 21)4544)135 2,454,135 2,387,064 TOTAL REVENUE AND TRANSFERS 15,0051435 14,601,494 15,5361645 15,536,645 151609,011 OPERATING EXPENDITURES: G. O. Bond Interest Payments 3,359,025 3,098,371 2,837,771 2,883,483 3,732,976 G. O. Bond Principal Payments 8,315,000 6,940,000 6,885,000 6,885,000 7,740,000 C. O. Interest Payments 1,664,721 2,142,557 2,529,417 2,529,417 1,627,791 C. O Principle Payments 2,396,864 2,678,694 3,115,590 3,1 t5,590 1,992,553 Tax and Note Interest Payments 89,456 43,119 21,763 21,763 7,563 Tax and Note Principal Payments 587,819 717,599 590,000 590,000 605,000 Fiscal Agent and Bond Fees 15430,237 15,064 10,000 10,000 - Total Operating Expenditures 17,843,122 15,635,404 15,989,541 16,035,253 15,705,883 TRANSFERS OUT: - 970,000 - - - TOTAL EXPENDITURES AND TRANSFERS 17,8431122 1605404 1519891541 16,035,253 1517051883 SURPLUS (DEFICIT) OF REVENUE WER (UNDER) EXPENDITURES: (2,837,688) (2,003,910) (452,896) (498,608) (96,872 ENDING FUND BALANCE: 10,922,692 8,918,782 8,465,886 8,420,174 8,323,302 FUND BALANCE REQUIREMENT: 3,519,739 3,084,244 3,154,101 3,163,118 3,098,147 Fund balance requirement is 20% of total budgeted expenditures (72 days of operation). The FY 2018-2019 projected Ending Fund Balance represents 53% of total budgeted expenditures (193 days of operation). 121 FY 2019-20 PROPOSED OPERATING BUDGET STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE 4B TRANSIT FUND 2016-17 2017-18 2018-19 2018-19 2019-20 Actual Actual Budget Estimate Proposed BEGINNING FUND BALANCE: 465,201 357 81784 8,784 347,463 OPERATING REVENUE: Sales Tax 91408,363 9,8151379 101833,750 M9421088 111106,218 Interest Income M404 81427 101000 91980 1000 Total Operating Revenue 9,4181767 918231806 1043,750 1019521068 11,116,218 TRANSFERS IN: TOTAL REVENUE AND TRANSFERS 9,4181767 9X31806 1018431750 1019521068 111 116,218 OPERATING EXPENDITURES: Contractual Services - Trinity Metro 9X71750 914661562 M389,140 1011681779 10411732 Total Operating Expenditures 9X71750 %466,562 M38%140 101168,779 10411732 TRANSFERS OUT: Transfer to Visitor Shuttle Fund 330,613 348,816 4441610 4441610 464,486 Transfer to Economic Development Fund 4751249 - - - - Total Transfers Out 8051862 348,816 4441610 444,610 464486 TOTAL EXPENDITURES AND TRANSFERS 9031612 91815X9 M8331750 101613,389 I L106,218 SURPLUS 1(DEFICIT) (464,844) 8,427 10,000 338,679 10,000 ENDING FUND BALANCE: 357 V84 18,784 3471463 357,463 80 FY 2019-20 PROPOSED OPERATING BUDGET STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE CONVENTION & VISITORS BUREAU INCENTIVES FUND 2016-17 2017-18 2018-19 2018-19 2019-20 Actual Actual Budget Estimate Proposed BEGINNING FUND BALANCE: 8,972,384 l 01774,995 13,131,802 13,131,802 13, l 3 l ,8U2 OPERATING REVENUE: Occupancy Taxes - Gaylord 1,785,994 1,962,405 2,018,454 21)0149417 29106,352 Occupancy Taxes - Great Wolf 480,018 499,584 472,578 4719633 - Occupancy Taxes - All (1%) 2051808 2,836,114 2,720,549 217159108 2,814,858 Interest Income 981M6 186,823 751N0 74,850 751X0 Miscellaneous (5,640) (5,750) - - - Total Operating Revenue 5,0451026 5,479,177 5,286,581 5,27608 4,996,210 TRANSFERS IN: - - - - - TOTAL REVENUE AND TRANSFERS 5,045,026 5,479,177 5,286,581 51276,008 4,996,21 U OPERATING EXPENDITURES: Personnel 4,388 - - - - Supplies 99,075 100,263 1001N0 99,800 1001X0 Services 3,138,951 31X2,107 5,186,581 53769208 406,210 Total Operating Expenditures 3,242,414 3322,370 5,286,581 5,27608 4,996,210 TRANSFERS OUT: - - - - - TOTAL EXPENDITURES AND TRANSFERS 3,242,414 31122,370 5,2861581 51276,008 4,996,210 SURPLUS / (DEFICIT) 1,802,611 2,35607 - - - ENDING FUND BALANCE: 10,774,995 1333102 13,1311802 133319802 139131,802 RESERVES: Reserved for Incentive Packages 4,7001000 4,70000 4,7001000 41700,000 497001X0 Total Reserves 4,7001X0 4,70000 4,7001000 41700,000 497001X0 UNRESERVED FUND BALANCE 6,0741995 8,431,802 8431102 81431,802 8,431,802 26 FY 2019-20 PROPOSED OPERATING BUDGET STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE ECONOMIC DEVELOPMENT FUND (122, 124) 2016-17 2017-18 2018-19 2018-19 2019-20 Actual Actual Budget Estimate Proposed BEGINNING FUND BALANCE: 32,283,858 17,500,235 5,216,533 6,098,006 69137,937 OPERATING REVENUE: Sales Tax 4,062,180 4,256,509 39611,250 31M79363 494021X3 Interest Income 227,799 179,326 1501N0 1499700 1251X0 Miscellaneous 275 - - - - Total Operating Revenue 4,290,254 4,435,834 39761,250 3,797,063 495271X3 TRANSFERS IN: 6,537,428 31086,455 - - - SALE OF CAPITAL ASSETS 2,72703 - - - - BOND - 16,930,000 - - - TOTAL REVENUE AND TRANSFERS 13,555,485 24,452,290 3,761,250 3,797,063 495271X3 OPERATING EXPENDITURES: Personnel Services 458,904 487,265 504,552 5039543 523,466 Supplies 7304 6,678 6,300 69287 6,300 Services 1,394,510 1,098,204 1,489,871 1,48601 2,231,816 Insurance - - 58103 57,967 58,097 Total Operating Expenditures CAPITAL OUTLAY TRANSFERS OUT Debt Service 1,860,519 4,716,788 21,76101 - 1,592,147 - 17,050,292 17,21202 2,058106 - 1,702,444 - 2,05408 - 117021)444 - 29819,679 - 19707,394 - TOTAL EXPENDITURES AND TRANSFERS 28,339,108 35,854,521 3,761,250 3,7579132 49527,073 SURPLUS 1(DEFICIT) (14,783,623) (11,402,231) - 39,930 - ENDING FUND BALANCE AVAILABLE: 17,500,235 61M8X6 5,216,533 6,137,937 69137,937 85 FY 2019-20 PROPOSED OPERATING BUDGET STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE FUND 174 - CAPITAL/STREET MAINTENANCE PROGRAM 2016-17 2017-18 2018-19 2018-19 2019-20 Actual Actual B udget Estimate Proposed BEGINNING FUND BALANCE: 116131115 836,679 1,1021856 1,102,856 11032,672 OPERATING REVENUE: Interest Income 25,378 30,226 24,000 2400 241000 Miscellaneous 1741037 67,128 - 33,258 - Total Operating Revenue 199,415 97,354 24,000 57,258 241)000 TRANSFERS IN: 3,279,000 3,114,775 2,645,000 3,145,000 3,279,000 TOTAL REVENUE AND TRANSFERS 34781415 3,212,129 2,669,000 3,202,258 31303,000 OPERATING EXPENDITURES: Facilities Maintenance 552,828 555,239 426,000 425,148 392,000 Parks Maintenance 1,821,675 699,695 1,097,000 1,094,806 15162,000 Street Maintenance and Overlay 15405,307 11229,493 15255,000 112521490 15225,000 Traffic Signal, Striping and Signing Maint. 475,042 461,522 501,000 499,998 500,000 Total Operating Expenditures 45254,852 2,945,949 3,279,000 3,272,442 3,279,000 TOTAL EXPENDITURES AND TRANSFERS 4,2541852 2,945,949 3,279,000 3,272442 3,279,000 URPLUS (DEFICIT) OF REVENUE IVER (UNDER) EXPENDITURES: (776,438) 266,179 (610,000) (70,184) 241)00( ENDING FUND BALANCE: 836,679 11102,856 492,856 1,032,672 1,056,672 125 FY 2019-20 APPROVED OPERATING BUDGET STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE GOLF FUND 2016-17 2017-18 2018-19 2018-19 2019-20 Actual Actual Budget Estimate Proposed BEGINNING WORKING CAPITAL: (1,365,536) (1,086,616) (856,471) (856,471) (856,471) OPERATING REVENUES: Cart and Club Rentals 687,793 657,058 686,000 684,628 664,000 Tournament Fees 2,108 2,250 300 2,994 4,000 Driving Range 213,011 1981286 21500 214,570 193,654 Golf Pro Shop Sales 217,417 2471M2 225,000 224,550 24500 Golf Course Green Fees 1. ,441,966 1,430,023 L47500 1,472,050 1,4259000 Annual Green Fee Memberships 274,307 273357 28000 279,440 3269000 Restaurant % of Sales 29,740 35109 3500 34,930 379000 Lesson Income 39,097 27,366 4000 39,920 3500 Interest Income 1,531 2,712 1,400 1,397 300 Golf Sub -Lease 243,981 244,961 24000 239,520 24200 Miscellaneous Income 24,852 14,957 2200 21,956 239608 Total Operating Revenue 337504 3,133,750 3,222,400 3,215,955 33989262 TRANSFERS IN/CONTRIBUTIONS: - - - - - TOTAL REVENUES AND TRANSFERS 31175,804 3,133,750 3,2225400 3,215,955 31198,262 OPERATING EXPENDITURES: Personnel 1,404,999 1,357,988 1,443,651 1,440,764 1,490,231 Supplies 343,333 3921X3 355,798 355106 38500 Maintenance 106,825 103,276 91,500 91,317 92,400 Services 71807 8301567 359,291 358,572 422,045 Insurance - - 454,290 453,381 457,986 Capital Outlay 22604 87,051 408,370 407,553 24200 Total Operating Expenditures 2100,427 2,770,955 3,112,900 3,106,674 3,090,262 TRANSFERS OUT: Transfer to General Fund - Admin Fee 108,147 107,254 109,500 109,281 10800 Total Transfers Out 108,147 107,254 109,500 109,281 10800 TOTAL EXPENDITURES AND TRANSFERS 2,908,574 2,878,209 3,222,400 3,215,955 3,198,262 SURPLUS / (DEFICIT) 267,230 255,542 - - - Fund balance requirement is 25% of total net budgeted expenses or 90 days of operation. City Council has suspended the fund balance requirement for the Lake Enterprise Fund for FY 2019-20. 25 FY 2019-20 PROPOSED OPERATING BUDGET STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE LAKE PARKS SPECIAL REVENUE FUND 2016-17 2017-18 2018-19 2018-19 2019-20 Actual Actual Budget Estimate Proposed BEGINNING FUND BALANCE: (2,466,053) (2,359,485) (2,290,551) (2,290,551) (2,220,584) OPERATING REVENUE: Boat Ramp Fees 108,223 97,783 98100 979804 92100 Pavilion Fees 61,715 67,153 761N0 759848 561X0 Camping Fees 1,779,067 1,947,840 291401N0 2,24500 292401X0 Entrance Fees 159,893 2341)154 1301N0 129,740 1551X0 Recreation Fees 111,501 1199387 3321N0 2119976 3351X0 Merchandise and Other Sales 82,253 759474 971N0 969806 91,000 Total Operating Revenue 2,3021fi52 2,5419791 29873,000 2,857,174 29969,800 TRANSFERS IN: TOTAL REVENUE AND TRANSFERS 2,3021fi52 2,5419791 298731X0 2,857,174 2,969,800 OPERATING EXPENDITURES: Personnel 230,489 2869052 397,274 3969479 440,402 Supplies 166,547 2069257 202,850 2029444 184,250 Maintenance 2671fi25 2619516 193,250 1929864 301,750 Services 1,348,040 1,489,297 19080109 1,0789727 19062,416 Insurance - - 85,976 859804 861fi29 Capital Outlay 39,008 15,629 1031X0 1399880 1561X0 Finance Charges - - 2,500 29495 - Total Operating Expenditures 2,051,709 2,258,752 2,065,739 2,0989694 29231,447 TRANSFERS OUT: Transfer to General Fund - Admin Fee 144,381 1639088 689,893 6889513 689,893 Total Transfers Out 144,381 1639088 689,893 6889513 689,893 TOTAL EXPENDITURES AND TRANSFERS 2,196,090 2,421 MO 29755,632 21787,207 29921,340 SURPLUS / (DEFICIT) 106,561 119,952 117,368 69,967 481460 ENDING FUND BALANCE: (2,359,485) (2,290,551) (29173,183) (2,220,584) (29172,124} * A Fund Balance Requirement has not been established for the Lake Parks Special Revenue Fund. 52 FY 2019-20 PROPOSED OPERATING BUDGET STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE STORMWATER DRAINAGE UTILITY FUND 2016-17 2017-18 2018-19 2018-19 2019-20 Actual Actual Budget Estimate Proposed BEGINNING FUND BALANCE: 1,261,208 1,552,470 1,552,470 1,860,975 19885,397 OPERATING REVENUE: Drainage Utility Fees 1,422,563 1,435,920 1,431,500 1,4289637 1,440,000 Interest Income 9,301 21,420 9,500 99481 22,500 Interest Income - 2000 C.O. 3,386 5,899 31N0 29994 7,500 Miscellaneous (569) (567) - - - Total Operating Revenue 1,434,681 1,462,672 1,4441000 174419112 194701N0 TRANSFERS IN: TOTAL REVENUE AND TRANSFERS 1,434,681 1,462,672 1,444,000 174419112 1,470,000 OPERATING EXPENDITURES: Personnel 492,963 533,061 549,651 548,552 559,846 Supplies 151M8 19,676 29,700 29,641 29,700 Maintenance 89,951 115,988 1251N0 124,750 1251X0 Services 257,579 313324 2341fi55 234,186 204,525 Insurance - - 162106 1617682 162100 Capital Outlay 30,151 62,911 210,000 209,580 2101N0 Total Operating Expenditures 8861292 1,044,760 1,311,012 1,308,390 14)291,131 TRANSFERS OUT: Transfer to General Fund - Admin Fee 112,127 109,407 1081300 108,300 1121000 Transfer to Equipment Acquisition Fund 1451X0 - - - - Total Transfers Out 257,127 109,407 1081300 108,300 1121000 TOTAL EXPENDITURES AND TRANSFERS 1,143,420 1,154,167 1,419,312 11416,690 19403,131 SURPLUS / (DEFICIT) 291,262 308,505 2408 24,422 66,869 ENDING FUND BALANCE: 1,552,470 11860,975 1,577,158 1105,397 1,952,266 FUND BALANCE REQUIREMENT: 187,521 189,283 2321767 232,337 230,113 Fund balance requirement is 16.4% of total budgeted expenditures (60 days of operation). The FY 2019-20 projected Ending Fund Balance represents 439 days of operation. 30