Loading...
HomeMy WebLinkAbout11-12-FY 1st QuarterRESOLUTION NO. R-12-10 A RESOLUTION OF THE CITY OF SEBASTIAN, INDIAN RIVER COUNTY, FLORIDA ADOPTING AN AMENDED BUDGET FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2011 AND ENDING SEPTEMBER 30, 2012 AS PROVIDED FOR IN EXHIBIT "A"; PROVIDING FOR CONFLICTS; AND PROVIDING FOR AN EFFECTNE DATE. WHEREAS, the City of Sebastian adopted Resolution No. R-11-22 on September 28, 2011 approving the City's 2011-12 budget, also referred to as the Annual Budget Resolution; and WHEREAS, an analysis of the revenues and expenditures for the three (3) months ended December 31, 2012 has indicated that adjustments are necessary; and WHEREAS, the City Council and City Manager have previous approved these adjustments in accordance with the Annual Budget Resolution; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SEBASTIAN, INDIAN RIVER COUNTY, FLORIDA, THAT: Section 1. The budget of the City of Sebastian, Indian River County, Florida for the Fiscal Year beginning October 1, 2011 and ending September 30, 2012 be amended, a copy of which is attached hereto and more particularly identified as Exhibit "A", the revised appropriations set out therein are hereby made to maintain and carry on the government of the City of Sebastian, Indian River County, Florida. Section 2. All resolutions or parts of resolutions in conflict herewith are hereby repealed. Section 3. This Resolution shall become effective immediately upon its adoption. It was moved for adoption by Councilmember The motion was seconded by Councilmember was as follows: Mayor Jim Hill Vice-Mayor pon Wright Councilmember Andrea Coy Councilmember Richard H. Gillmor Councilmember Bob McPartian Co Wright aye aye aye ave and, upon being put to a vote, the vote The Mayor thereupon declared this Resolution duly passed and adopted this 28`h day of March 2012. ATTEST: , Sally A. Ma' , MMC City Clerk CITY OF SE$jASTIA�1, FLORIDA : im Hill Apprdved as to form and content for reliance the City of Sebastian only: � �%�� �_--_ -�. Robert A. Ginsburg, City Attorney FUND TITLE GENERAL Revenues Expenditures LOCAL OPTION GAS TAX Revenues Expenditures DISCRETIONARY SALES TAX Revenues Expenditures RIVERFRONT CRA Revenues Expenditures PARKING IN-LIEU-0F FEES Revenues Expenditures RECREATTON IMPACT FEE Revenues Expenditures STORMWATER UTILITY FEE Revenues Expenditures LAW ENFORCEMENT FORFEIT[JRE Revenues Expenditures DST DEBT SERVICE FUND Revenues Expenditures STORMWATER DEBT SERVICE FUND Revenues Expenditures GOLF COURSE Revenues Expenses AIRPORT Revenues Expenses BUILDING Revenues Expenses TOTAL BUDGET EXHIBIT "A" FY 2012 AMENDED BUDGET BEFORE 1ST QUARTER BUDGET AFTER ADJUSTMENTS ADJUSTMENTS ADJUSTMENTS $ 9,921,464 $ 3,851 $ 9,925,315 9,921,464 3,851 9,925,315 648,511 - 648,511 648,511 - 648,511 2,390,391 516,712 2,907,103 2,390,391 516,712 2,907,103 286,022 594 286,616 286,022 594 286,616 - 13,800 13,800 - 13,800 13,800 185,000 263,886 448,886 185,000 263,886 448,886 93 8,623 - 93 8,623 93 8,623 - 93 8,623 10,125 - 10,125 ] 0,125 - 10,125 1,022,333 - 1,022,333 1,022,333 - 1,022,333 440,123 - 440,123 440,123 - 440,123 1,305,753 - 1,305,753 1,305,753 - 1,305,753 436,649 - 436,649 436,649 - 436,649 413,059 - 413,059 413,059 - 413,059 $ 17,998,053 $ 798,843 $ 18,796,896 CITY OF SE[3ASTIAN, FLORIDA COMPARiSON OF ACTUAL TO BUDGET END OF 1ST QUARTER FISCAL YEARS 2010, 2011 AND 2012 FY201Q FY2011 FY 2012 Descriation 1st Qtr YTD BUDGET %, 1st Qtr YTD BUDGET % 1st Qtr YTD BUDGET % GENERAL FUND SUMMARY TAXES 3,432.196 7,531,430 45.6% 3,120,719 7,179,708 43.5°� 2,835,607 6,684,535 42.4°k LICENSES & PERMITS 9,758 51,440 19.0% 3,841 44,650 8.6% 7,615 36,150 21,1% INTERGOVERNMENTAL REVENUES 283,430 1,723,105 16.4% 285,828 1,836,540 15.6% 295,506 1,880,400 15.7% CHARGES FOR SERVICES 62,189 289,147 21.5% 66,987 286,550 23.4% 65,562 284,603 23.0% FINES AND FORFEITS 16,871 55,000 30.7% 18,683 65,500 28.5% 12,509 74,000 16.9% MISCELLANEOUS REVENUES 78,853 423,190 18.6% 49,252 305,585 16.1% 28,128 276,498 10.2% TRANSFER FROM OTHER FUNDS 191,222 848,909 22.5% 184,182 753,759 24.4% 171,750 689,129 24.3% TOTAL REVENUES 4,074,519 10,922,181 37.3% 3,729,492 10,472,292 35.6% 3,416,677 9,925,315 34.4°(0 BEGINNING CASH RESERVES 5,166,999 5,255,327 98.3% 4,962,399 5,068,245 97.9% 4,733,552 4,711,377 100.5% TOTAL SOURCES 9,241,518 16�17T�508 57.1% 8�691,891 15,540,537 55.9% 8�150�229 14�636�692 55.7% CITY COUNCIL 10,708 52,117 20.5% 10,950 49,708 22.0% 11,009 50,283 21.9% CITY NtANAGER 58,549 254,480 23.0% 50,784 234,642 21.6% 50,719 234,046 21.7% CITY CLERK 96,273 296,444 32.5% 71,662 272,792 26.3% 96,436 304,390 31.7% LEGAL 16,642 125,340 13.3% 16,017 125,785 12.7% 17,744 107.710 16.5% ADMINISTRATIVE SERVICES 717,659 492,658 23.9% 115,061 478,562 24.0% 112,017 477,869 23.4% MANAGEMENT INFO SERVICES 52,161 266,913 19.5% 57,149 248,908 23.0% 30,245 160,125 18.9% POLICE DEPARTMENT 1,079,782 4,675,788 23.1% 1,062,526 4,790,650 22.2% 993,685 4,429,395 22.4% PUBLIC WORKS 788,993 3,694,008 21.4% 648,853 3,385,604 19.2% 717,364 3,215,690 22.3% GROWTH MANAGEMENT 85,260 437,156 19.5% 77,280 348,734 22.2% 51,731 248,150 20.8% NON-DEPARTMENTAL 343,563 627,277 54.8% 272,246 536,907 50.7% 272,950 697,657 39.1% TOTAL EXPENDI7URES 2�649,590 10�922�181 24.3% 2,382�528 10�472�292 22.8% 2�353�900 9�925�315 23.7% ENDING CASH RESERVES 6,591,928 5,255,327 125.4% 6,309,363 5,068,245 124.5% 5,796,329 4,711,377 123.0% TOTAL USES 9,241,518 16,177,508 57.1% 8,691,891 15,540,537 55.9% 8,150,229 14,636,692 55.7% Tax collections during the first quarter this year are lower than last year, as a resuft oi keeping the same millage with reduced taxable values. Licenses and permits include driveway and alarm permits and fees for zoning, site plan and plat changes. Fines and Forfeits include collection o( Code Enforcement liens. Miscellaneous Revenues includes investment income. Total Sources includes the amount of actual and estimated cash reserves. For the 2012 Annual Budget, we do not anticipate using any cash reserves. It is also noted that actual Beginning Cash Reserves as of October 1, 2011 were $4,733,552, which was $22,175 more than the $4,711,377 we had estimated when we adopted the 2012 Annual Budget. We are pleased that our estimate was so ciose. Spending by all the DepaAments are all within the 25% of budget (one-fourth of the fiscal year) except City Clerk, which is because of the payment to Indian River County for the costs o( the election and Non-Departmental, which is due to the City's contribution to the CRA Fund being made in the first qua�ter. LOCAL OPTION GAS TAX FUND TOTAL REVENUES 98,521 818,000 12.0% 97,240 623,521 15.6% 92,712 598,253 15.5% BEGINNING CASH RESERVES 82,854 152,559 54.3% 1,392.655 1,401,543 99•4% 58,562 50,258 116.5% TOTAL SOURCES 181�375 970�559 18.7% 1�489,895 2�025,064 73.6% 151�274 648�511 23.3% DEBT SERVICE - 300,000 0.0% 132,207 264,463 50•0% 132,783 265,792 50.0% OTHER EXPENDITURES 52,866 293,000 18.0% 48,578 250,000 19.4% 51,548 257,719 20.0% TRA(VSFERS TO OTHER FUNDS 0.0% 697,040 1,461,429 47.7% 31,250 125,000 25.0% TOTAL EXPENDITURES 52,866 593,000 8.9% 877,825 1,975,892 44•4% 215,581 648,511 33.2% ENDING CASH RESERVES 128,509 377.559 34.0% 612,070 49,172 n/a (64,3o7) n/a TOTAL USES 181,375 970,559 18-7% 1,489,895 2,025,064 73.6% 151,274 648,511 23.3% 1st quarter revenue reflects just two months payments. Beginning Cash Reserves as of October 1, 2011 were $58,562, which was $7,891 more than the $50,671 we had estimated when we adopted the 2012 Annual Budget. DISCRETIONARY SALES TAX FUND TOTALREVENUES 331,194 2,510,445 13.2% 330,734 2,349,593 14.1% 331,630 2,907,103 11.4% BEGINNING CASH RESERVES 683,036 1,904,156 35.9% 1,379,095 1,292,080 106.7% 1,623,442 1,255,592 129.3% TOTAL SOURCES 1,014,230 4,414,601 23.0% 1,709,829 3,641,673 47.0% 1,955,072 4,162,695 47.0% TRANSFERS TO OTHER FUNOS 579,711 3,673,830 15.8% 464,275 2,718,788 17.1% 518,876 2,907,103 17.8% TOTAL EXPENDITURES 579,711 3,673,830 15.8% 464,275 2,718,788 17.1% 518,876 2,907,103 17.8% ENDING CASH RESERVES 434,519 740,771 58.7% 1,245,554 922,885 135.0% 1,436,196 1,255,592 114.4% TOTAL USES 1,014,230 4,414,601 23.0% 1,709,829 3,641,673 47,0'/0 1,955,072 4,162,695 47.0% 1st quarter revenue reflects just two months payments, because the October payment for September collections was accounted for in 2010. 2011 Projects, including Powerline Road and Excavation Equipment, that we were carried forward to 2012 are the reason Beginning Cash Reserves were higher than estimated. Description CITY OF SEBASTIAN, FLORIDA COMPARISOIY OF ACTUAL TO BUDCET END OF iST QUARTER FISCAL YEARS 2010, 201 I AND 2012 FY2010 FY2011 FY 2012 1 st Qtr YTD BUDGET % 7st Qtr YTD BUDGET % 1st Qtr YTD BUDGET % RIVERFRONT CRA FUND TOTAL REVENUES 430,387 440,535 97.7% 298,917 300,382 99.5% BEGINNING CASH RESERVES 984,638 638,242 154.3% 682,591 676,714 100.9% TOTAL SOURCES 1,415,025 1,078,777 131.2% 981,508 977,096 100.5% Year Revised % Year Revised % TOTAL EXPENDITURES 21,731 654,369 3.3% 70,549 179,655 39.3% TRANSFERS TO OTHER FUNDS 15,000 60,000 25.0% 26,800 382,494 7.0% ENDING CASH RESERVES 1,378,294 364,408 378.2% 884,159 414,947 213.1% TOTAL USES 1,415,025 1,078,777 131.2% 981,508 977,096 100.5% The City and County both pay the CRA tax increment before December 31st of each year. PARKlNG IN-LIEU-OF FUND 256,170 263,716 97.1% 455,810 498,934 91.4% 711,980 762,650 93.4°k Quarter Revised % 43,707 126,616 34.5% 15,000 160,000 9.4°h 653,273 476,034 137.2% 711,980 762,650 93.4% TOTAL REVENUES - - 0.0% - - 0.0% 3,452 13,800 25.0% BEGINNING CASH RESERVES - - 0.0% - - 0.0% 12,632 - 0.0% TOTAL SOURCES - - 0.0% - - 0.0% 16,084 13,800 116.6% EXPENDITURES - - 0.0% - - 0.0°k - - 0.0% ENDING CASH RESERVES - - 0.0% - - 0.0% 16,084 13,800 116.6% TOTAL USES - - 0.0% - - 0.0% 16,084 13,800 116.6% This Fund will record collections of the new parking in-lieu-of fee and any subsequent spending of those monies. RECREATiON IMPACT FEE FUND TOTAL REVENUES 5,878 56,247 10.5% 4,057 30,791 13.2% 16,670 28,500 58.5% BEGINNING CASH RESERVES 1,095,485 884,464 123.9% 1,106,310 998,826 110.8% 848,187 436,731 194.2% TOTAL SOURCES 1,101,363 940,711 117.1% 1,110,367 1,029.617 107.8% 864,857 465,231 185.9% TRANSFERS TO OTHER FUNDS 1,556 251,246 0.6% 13,536 620,579 2.2% 28,282 448,886 6.3% TOTAL EXPENDITURES 1,556 251,246 0.6% 13,536 620,519 2.2% 28,282 448,886 6.3% ENDING CASH RESERVES 1,099,808 689,465 159.5% 1,096,831 409,098 268.1% 836,575 16,345 5118.2% TOTAL USES 1,101,363 940,711 117.1% 1,110,367 1,029,617 107.8% 864,857 465,231 185.9% Several projects were underway and needed to be carried forward to 2012, resulting in Beginning Cash Reserves being higher than estimated. STORMWATER UTILTY FUND TOTAL REVENUES 590,195 877,344 67.3% 608,723 843,200 72.2% 610,712 818,450 74.6% BEGINNING CASH RESERVES 795,650 651,397 122.1% 588,841 601,040 98.0% 450,156 316,537 142.2% TOTAL SOURCES 1,385,845 1,528,741 90.7% 1,197,564 1,444,240 82.9% 1,060,868 1,134,987 93.5% OTHER EXPENDITURES - 100 0.0% - 100 0.0% - 100 0.0% TRANSFERS TO OTHER FUNDS 234,561 1,020,454 23.0% 234,719 1,138,877 20.6% 385,707 938,523 41.1% TOTAL EXPENDfTURES 234,561 1,020,554 23.0% 234,719 1,138,977 20.6% 385,707 938,623 41.1% ENDING CASH RESERVES 1,151,284 508,187 226.5% 962,845 305,263 315.4% 675,161 196,364 343.8% TOTAL USES 1,385,845 1,528,741 90.7% 1,197,564 1,444,240 82.9% 1,060,868 1,134,987 93.5% The excavation equipment budgeted in 2011 was not paid for until 2012, resulting in Beginning Cash Reserves being higher than estimated. LAW ENFORCEMENT FORFEITURE FUND TOTAL REVENUES 732 10,200 7.2% 840 10,250 8.2% - 10,125 0.0% BEGINNING CASH RESERVES 54,018 20,970 257.6% 73,160 52,609 139_1% 66,585 80,062 83.2% TOTAL SOURCES 54,750 31,170 175.6% 74,000 62,659 117.7°!0 66,585 90,187 73.8% EXPENDITURES 3,179 - 0.0% 614 - 0.0% - - 0.0% ENDING CASH RESERVES 51,571 31,170 165.5% 73,386 62,859 116.7% 66,585 90,187 73.8% TOTAL USES 54,750 31,170 175.6% 74,000 62,859 117.7% 66,585 90,187 73.8% These funds are used for the DARE Program, for vehicle towing charges pending reimbursement and to provide drug investigation monies. DISCRETIONARY SAIES TAX BOND FUND TRANSFER FROM OTHER FUNDS 258,966 1,035,869 25.0% 249,389 997,557 25.0% 249,348 999,933 24.9% MISC. REVENUES 199 1,000 19.9% 460 22,854 2.0% 294 22,400 1.3% TOTAL REVENUES 259,165 1,036,869 25.0% 249,849 1,020,411 24.5% 249,642 1,022,333 24.4% BEGINNING CASH RESERVES 1,409,493 214,358 657.5% 1,554,654 1,541,577 100.8% 1,556.577 1,542,409 100.9% TOTAL SOURCES 1,668,658 1,251,227 133.4% 1,804,503 2,561,988 70.4% 1,806,219 2,564,742 70.4% OPERATING EXPENDITURES 375 300 125.0% - 300 0.0% - 300 0.0% DEBT SERVICE - 1,036,569 0.0% - 1,019,279 0.0% 375 1,022,033 0.0% TOTAL EXPENDITURES' 375 1,036,869 0.0% - 1,019,579 0.0% 375 1,022,333 0.0% ENDING CASH RESERVES 1,668,283 214,358 778.3% 1,804,503 1,542,409 117.0% 1,805,844 1,542,409 117.1% TOTAL USES 1,668,658 1,251,227 133.4% 1,804,503 2,561,988 70.4% 1,806,219 2,564,742 70.4% At the end of 2009, with the rating downgrade of the insurer of our bond reserve, additional funds had to be transferred to the Bond Fund Cash Reserves. Thus, the YTD Actual Beginning and Ending Cash Reserves in 2010 were much higher than originally budgeted. CITY OF SEBASTIAN, FLORIDA COMPARISON OFACTUALTO [3UDGET END OF 1ST QUARTER FISCAL YEARS 2010, 2011 AND 2012 FY2010 FY2011 FY 2012 Description 1st Qtr YTD BUDGET % 1st Qtr YTD BUDGET % 1st Qtr YTD BUDGET % STORMWATER UTILITY BOND FUND TRANSFER FROM OTHER FUNDS 109,560 438,240 25.0% 109,719 438,877 25.0% MISC. REVENUES 5 120 3.8% 42 1,122 3.7% TOTAL REVENUES 109,565 438,360 25.0% 109,761 439,999 24.9% BEGINNING CASH RESERVES 144,&35 20,686 699.2% 182,951 182,932 100.0% TOTAL SOURCES 254,200 459,046 55.4% 292,712 622,931 47.0% DEBT SERVICE 89,118 438,360 20.3% 84,893 439,911 19.3% TOTAL EXPENDITURES 89,118 438,360 20.3% 84,893 439.911 19.3% ENDING CASH RESERVES 165,082 20,686 798.0% 207,819 183,020 113.5% TOTAL USES 254,200 459,046 55.4% 292,712 622,931 47.0% Principal and interest paymenls are being made as scheduled. GOLF COURSE FUND 109,631 439,023 25.0% 66 1,100 6.0% 109,697 440,123 24.9% 183,020 183,020 100.0% 292,717 623,143. 47.0% 79,999 440,123 18.2% 79,999 440,123 18.2% 212, 718 183.020 116.2°/a 292,717 623,143 47.0% CHARGES FOR SERVICE 374,168 1,483,200 25.2% 351,816 1,261,474 27.9% 348,486 1,270,793 27.4°�i MISC. REVENUES 8,617 112,713 7.6% 7,326 36,410 20.1°�6 8,181 34,960 23.4% TOTAL REVENUES 382,785 1,595,913 24.0°/a 359,142 1,297,884 27.7% 356,667 1,305,753 27.3% BEGINNING CASH RESERVES (67,076) 764,318 -8.8% (335,947) (367,001) 91.5% �216,241) (249,485) 86.7% TOTAL SOURCES 315,709 2,360,231 13.4% 23,195 930,883 2.5% 140,426 1,056,268 13.3% PERSONAL SERVICES 75,433 350,023 21.6% 74,845 340,270 22.0% 59,781 278,843 21.4% OPERATING EXPENSES 208,902 922,79d 22.6% 223,896 921,634 24.3% 243,839 999,410 24.4% CAPITAL OUTLAY - 10,000 0.0% - - 0.0% 25,311 27,500 92.0% DEBT SERVICE 1,075 313,100 0.3% - 1,075 0.0% - - 0.0% TOTAL EXPENDITURES 285,410 1,595,913 17.9% 298,741 1,262,979 23.7% 328,931 1,305,753 25.2% ENDING CASH RESERVES 30,299 764,318 4.0% __ (275,546) (332,096) 83.0% (188,505) (249,485) 75.6% TOTAL USES 315,709 2,360,231 13.4% 23,195 930,883 2.5% 140,426 1,056,268 13.3% Shortfalls in adual revenues required the use of Cash Reserves to meet total expenditures over the past few years. It is normally our intent to maintain Cash Reserves exceeding liabilities but at the beginning of 2012, we would not have enough cash on hand to pay off accrued compensated absenses and refund prepaid memberships and customer credits. 2010 was the last year of debt service on the Bonds and we are hopeful that we can begin to correct this. AIRPORT FUND LEASE REVENUES 67,732 371,219 18.2% 90,788 345,855 26.3% 88,544 398,641 22.2% MISC. REVENUES 4,081 17,000 24.0% 2,906 2Q,000 14.5% 3,417 25,600 13.3% TOTAL REVENUES 71,813 388,219 18.5% 93,694 365,855 25.6% 91,961 424,241 21.7% BEGINNING CASH RESERVES (51,665) 65,784 -78.5% (57,243) (96,942) 59.0% (66,889) (57,243) 116.9% TOTALSOURCES 20,148 454,003 4.4% 36,451 268,913 13.6% 25,072 366,998 6.8% PERSONAL SERVICES 55,405 231,369 23.9% 51,689 234,275 22.4% 52,243 236,970 22.0% OPERATING EXPENSES 72,539 148,300 48.9% 49,186 156,245 31.5% 60,179 182,429 33.0% TRANSFER TO PROJECTS 4,795 8,550 56.1% - - 0.0% - - 0.0% DEBT SERVICE - - 0.0% - 8,550 0.0% - 17,250 0.0% TOTAL EXPENDITURES 132,739 388,219 34.2% 100,875 395,070 25.5% 112,422 436,649 25.7% ENDING CASH RESERVES (112,591) 65,784 -171.2°� (64,424) (126,157) 51.1°� (87,350) (69,651) 125.4°� TOTAL USES 20,148 454,003 4.4% 36,451 268,913 13.6% 25,072 366,998 6.8% Cash Reserves have been used to meet total expenditures and required grant matching funds over the past several years. It is normally our intent to maintain Cash Reserves exceeding liabilities but at the end of each year, we have not had enough cash on hand to pay off accrued compensated absenses and other liabilities. BUILDING FUND TOTAL REVENUES 140,153 489,334 28.6% 143,252 355,650 40.3% 160,711 389,150 41.3% BEGINNING CASH RESERVES 651,126 779,429 83.5% 554,519 504,899 109.8% 460,448 431,386 106.7% TOTAL SOURCES 791,279 1,268,763 62.4% 697,771 860,549 81.1% 621,159 820,536 75.7% PERSONAL SERVICES 87,482 379,674 23.0% 81,922 367,626 22.3% 69,491 322,000 21.6% OPERATING EXPENSES 23,734 109,660 21.6°�Si 22,895 98,114 23.3% 21,292 91,059 23.4% TOTAL EXPENDITURES 111,215 489,334 22.7% 104,817 465,740 22.5% 90,783 413,059 22.0°ib ENDING CASH RESERVES 680,064 779,429 87.3% 592,954 394,809 150.2% 530,376 407,477 130.2% TOTAL USES 791,279 1,268,763 62.4% 697,771 860,549 81.1% 621,159 820,536 75.7% Ending Cash Reserves have steadily declined due to the economic slump. However, Beginning Cash Reserves for 2012 were slightly higher than anticipated. CITY OF SEF3ASTIAN, FLORIDA COMPARISON OF ACTUAL TO BUDCET END OF 1ST QUARTER FISCAL YEARS 2010, 2011 AND 2012 FY2010 FY2011 FY 2012 Description 1st Qtr YTD BUDGET % 1st Qtr YTD BUDGET % 1st Qtr YTD BUDGET % GENERAL FUND DETAIL ON DEPARTMENTS GTY COUNCIL Personnel Operating Totals CITY MANAGER Personnel Operating Totais CITY CLERK Personnel Operating Totafs LEGAL Personnel Operating Totals ADMINISTRATIVE SERVICES Personnel Operating Totals MANAGEMENT INFO SERVICES Personnel Operating Capital Outlay Totals POLICE DEPARTMENT Personnel Operating Capital Outlay Totals PUBLIC WORKS Personnel Operating Capital Outlay Tota Is PLANNING & ZONING Personnel Operating Totals NON-DEPARTMENTAL Personnel Operating Transfers to Other Funds Totals TOTAL EXPENDITURES Personnel Operating Capital Outlay Transfers to Other Funds Fotals ENDING CASH RESERVES TOTAL USES 5,700 22,742 25.1% 5,695 22,761 25.0% 5,695 22,747 25.0% 5,009 29,375 17.1% 5,255 26,947 19.5% 5,314 27,536 19.3% 10,708 52,117 20.5% 10,950 49,708 22.0% 11,009 50,283 21.9% 55,473 250,455 22.1% 50,361 229,734 21.9% 49,912 230,746 21.6% 3,075 4,025 76.4% 423 4,908 8.6% 807 3,300 24.5% 58,549 254,480 23.0% 50,784 234,642 21.6% 50,719 234,046 21.7% 54,070 240,794 22.5% 52,695 243,373 21.7% 53,605 249,468 21.5% 42,203 55,650 75.8% 18,967 29,419 64.5% 42,831 54,922 78.0% 96,273 296,444 32.5% 71,662 272,792 26.3% 96,436 304,390 31.7% 0 0 0.0% 0 0 0.0% 0 0 0.0% 16,642 125,340 13.3% 16,017 125,785 12.7% 17,744 107,710 16.5% 16,642 125,340 13.3% 16,017 125,785 12.7% 17,744 107,710 16.5% 90,660 408,939 22.2% 87,979 397,517 22.1% 86,908 399,060 21.8% 26,999 83,719 32.2% 27,082 81,045 33.4% 25,109 78,809 31.9% 117,659 492,658 23.9% 115,061 478,562 24.0% 112,017 477,869 23.4% 45,660 206,855 22.1% 44,401 203,713 21.8% 25,095 117,000 21.4% 5,201 28,735 18.1% 12,748 40,195 31.7% 5,150 30,996 16.6% 1,301 31,323 4.2% 0 5,000 0.0% 0 12,129 0.0% 52,161 266,913 19.5% 57,149 248,908 23.0% 30,245 160,125 18.9% 980,123 4,250,025 23.1% 959,611 4,397,021 21.8% 886,955 3,996,037 22.2% 99,659 398,892 25.0% 101,996 392,709 26.0% 106,730 433,358 24.6% 0 26,871 0.0% 919 920 99.9% 0 0 0.0% 1,079,782 4,675,788 23.1% 1,062,526 4,790,650 22.2% 993,685 4,429,395 22.4% 596,141 2,563,799 23.3% 498,497 2,348,344 21.2% 502,032 2,160,971 23.2% 180,852 1,118,209 16.2% 148,926 1,024,460 14.5% 195,853 1,034,719 18.9% 12,000 12,000 100.0% 1,430 12,800 11.2% 19,479 20,000 97.4% 788,993 3,694,008 21.4% 648,853 3,385,604 19.2% 717,364 3,215,690 22.3% 83,028 372,436 22.3% 69,957 312,127 22.4% 48,482 227,698 21.3% 2,233 64,720 3.4% 7,323 36,607 20.0% 3,249 20,452 15.9% 85,260 437,156 19.5% 77,280 348,734 22.2% 51,731 248,150 20.8% 0 15,000 0.0% 0 15,000 0.0% 17,014 139,436 12.2% 343,563 612,277 56.1% 272,246 521,907 52.2% 255,936 497,221 51.5% 0 0 0.0% 0 0 0.0% 0 61,000 0.0% 343,563 627,277 54.8% 272,246 536,907 50.7% 272,950 697,657 39.1% 1,910,855 8,331,045 22.9% 1,769,196 8,169,590 21.7% 1,675,698 7,543,163 22.2% 725,435 2,520,942 28.89'0 610,983 2,283,982 26.8% 658,723 2,289,023 28.8% 13,301 70,194 18.9% 2,349 18,720 12.5% 19,479 32,129 60.6% 0 0 0.0% 0 0 0.0% 0 61,000 0.0% 2,649,590 10,922,181 24.3% 2,382,528 10,472,292 22.8% 2,353,900 9,925,315 23.7% 6,591,928 5,255,327 125.4% 6,309,363 5,068,245124.5% 5,796,329 4,711,377 123.0% 9,241,518 16,177,508 57.1°/a 8,691,891 15,540,537 55.9% 8,150,229 14,636,692 55.7% - GENERAL CAPITAL PRWECTS FUND 31Q Project Number C1108 C1109 A1210 A1211 A1212 Description CAPITAL PROJECT STATUS REPORT 12131/2011 Percent Project Expenditures Funds Expended/ Budqet To Date Encumbrances Remaininq Encumbered Excavation Equipment 166,053.62 166,053.62 - - 100.00% Telephone Syslem 60,000.00 212.74 - 59,787.26 0.35% Garage Equipment 23,000.00 3,927.00 - 19,073.00 17.07% Repaint City Hall/PD 75,000.00 0.00 - 75,000.00 0.00% Police Vehicle Replacement 182,871.00 105,677.30 47,173.00 30,020.70 83.58% 506,924.62 275,870.66 47,173.00 183,880.96 63.73% CAPITAL IMPROVEMENT PROJECTS FUND 320 Project Number C0721 C0921 C1122 C1123 C1125 C1126 C1129 A1221 A1222 A1223 A1224 A1225 A1226 Descriqtion Hardee Park Improvement (Zone A) Schumann Park Improvements Riverview Park Pavilion (Schumann Park) Bark Park Amenties Riverview Park Irrigation Fountains Presidental Streets Easy St Park Improvements Mooring Fields Blueway Signage Bleacher Shields Creative Playground Handicapp Pier Riverview Park Electrical TRANSPORTATION CAPITAL PROJECTS FUND 330 Project Number C0735 C0834 C1131 C1132 P0001 A1231 Descri�tion Powerline Road 512 Corridor (DST - FDOT Grant) US 1 Improvements Gateway Enhancement Road Paving Cav Corp Enhancements STORMWATERIMPROVEMENTFUND FUND 363 Project Number Description Percent Project Expenditures Funds Expended/ Budqet To Date Encumbrances Remaininq Encumbered 50,000.00 47,432.01 - 2,567.99 94.86% 204,460.00 149,464.61 13,241.00 41,754.39 79.58% 30,680.00 26,980.48 1,701.07 1,998.45 93.49% 75,000.00 1,450.00 - 73,550.00 1.93% 25,000.00 8,261.52 - 16,738.48 33.05% 473,500.00 12,906.00 20,094.00 440,500.00 6.97% 63,000.00 1,136.26 33,600.00 28,263.74 55.14% 15,000.00 0.00 - 15,000.00 0.00% 25,000.00 0.00 - 25,000.00 0.00% 50,000.00 0.00 - 50,000.00 0.00% 30,000.00 0.00 - 30,000.00 0.00% 15,000.00 0.00 - 15,000.00 0.00% 7,500.00 0.00 7,266.04 233.96 96.88% 1,064,140.00 247,630.88 75,902.11 740,607.01 30.40% Percent Project Expenditures Funds Expendedl Budqet To Date Encumbrances Remaininp Encumbered 1,222,250.00 870,104.13 319,294.39 32,851.48 97.31% 288,723.00 276,348.38 31,192.95 (18.818.33) 106.52% 300,000.00 13,577.29 280,572.97 5,849.74 98.05% 25,000.00 0.00 - 25,000.00 0.00% 39,554.57 13,749.50 - 25,805.07 34.76% 75,000.00 0.00 - 75,000.00 0.00% 1,950,527.57 1,173,779.30 631,060.31 145,687.96 92.53% Percent Project Expenditures Funds Expended/ Budqet To Date Encumbrances Remaininq Encumbered C4606 Collier Creek Improvements (DEP GRANT $500,00 4,925,102.11 4,917,877.11 9,225.00 (2,000.00) 100.04% P0003 1/4 Round Swale Rehab (DST) 2,647,720.00 2,317,508.60 13,335.40 316,876.00 88.03% C1601 Stormwater Master Plan 50,000.00 27,500.00 - 22,500.00 55.00% A1261 BBSC Drainage 50,000.00 0.00 - 50,000.00 0.00% 7,672,822.11 7,262,885.71 22,560.40 387,376.00 94.95% AtRPORT PROJECTS FUND 455 Percent Project Project Expenditures Funds Expended/ Number Description Budqet To Date Encumbrances Remaininq Encumbered C0951 Construct Hangars (1,160,000 grant) 1,450,000.00 1,300,715.87 7,316.03 141,968.10 90.21% C1152 Install Security Cameras 43,000.00 0.00 - 43,000.00 0.00% 1,493,000.00 1,300,715.87 7,316.03 184,968.10 87.61%