The URL can be used to link to this page

Home My WebLink About11-12-FY 3rd QuarterRESOLUTION NO. R-12-22 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 EFFECTIVE 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, the City of Sebastian adopted Resolution No. R-12-10 on March 28, 2012 regarding revenues and expenditures for the three (3) months ended December 31, 2011; and WHEREAS, the City of Sebastian adopted Resolution No: R-12-12 on May 23, 2�12 regarding revenues and expenditures for the three (3) months ended March 31, 2011; and WHEREAS, an analysis of the revenues and expenditures for the three (3) months ended June 30, 2012 has indicated that formalizing certain adjustments are necessary; and WHEREAS, the City Council or 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 Co The motion was seconded by Councilmember Hi 11 and, upon being put to a vote, the vote was as follows: Mayor Jim Hill aye Vice-Mayor pon Wright aye Councilmember Andrea Coy aye Councilmember Richard H. Gillmor aye Councilmember Bob McPartian aye The Mayor thereupon declared this Resolution duly passed and adopted this 22"d day of August 2012. ATTEST• �. ��_:: _ f � � ��-� -_ Sally A. Maio, MC City Clerk CITY OF S A TIAN, FLORIDA By. / -- r Jim Hill Approved as to form and content for relia by the City of Sebastian only: � Robert A. Ginsburg, City Attorney E'UIYD TITLE GENERAL Revenues Expenditures LOCAL OPTION GAS TAX Revenues Expenditures DISCRETIONARY SALES TAX Revenues Expenditures RIVERFRONT CRA Revenues Expenditures PARKIIYG IN-LIEU-OF FEES Revenues Expenditures RECREAT[ON IMPACT FEE Revenues Expenditures STORMWATER UTILITY FEE Revenues Expenditures LAW ENFORCEMEIYT FORFEITURE Revenues Expenditures DST DEBT SERVICE FUND Revenues Expenditures STORMWATER DEBT SERVICE FUND Revenues Expenditures GOLF COURSE Revenues Expenses AIRPORT Revenues Expenses BUILQING Revenues Expenses TOTAL BUDGET EXHIBIT "A" FY 2012 AMENDED BUDCET BEFORE 3RD QUARTER BUDCET AFTER ADJUSTMENTS ADJUSTMENTS ADJUSTMENTS $ 9,925,315 $ 15,458 $ 9,940,773 9,925,315 15,458 9,940,773 574,026 2,370,485 2,944,511 574,026 2,370,485 2,944,511 2,779,671 255,150 3,034,821 2,779,671 255, I50 3,034,821 286,616 - 286,616 286,616 - 286,616 I 3,800 - 13,800 I 3,800 - 13,800 448,775 21,377 470,152 448,775 21,377 470,152 1,089,699 - 1,089,699 1,089,699 - 1,0$9,699 10,125 - ]0,125 10,125 - 10,125 1,022,333 - 1,022,333 1,022,333 - 1,022,333 440,123 - 440, ] 23 440,123 - 440,123 1,305,753 - 1,305,753 1,305,753 - 1,305,753 447,124 - 447,124 447, I24 - � 447,124 413,059 - 413,059 4 l 3,059 - 413,059 $ 18,756,419 $ 2,662,470 $ 21,418,889 Description GENERAL FUND SUMMARY CITY OF SEBASTIAN, FLORIDA COMPARISON OF ACTUAL TO BUDGET EIVD OF 3RD QUARTER FISCAL YEARS 2009, 20[0 AND 2011 FY2010 FY2011 FY2012 3►d Rtr YTD BUDGET °0 3rd Qtr YTD BUDGET °0 3rd Qtr YTD BUDGET °L TAXES 6,095,373 7,531,430 80.9% 5,438,164 7,179,708 75.7% LICENSES AND PERMITS 24,434 51,400 47.5% 18,013 44,650 40.3% INTERGOVERNMENTAL REVENUES 1,247,794 1,723,105 72.4% 1,217,860 1,836,540 66.3% CHARGES FOR SERVICES 227,151 289,147 78.6% 199,138 286,550 69.5% FINESANOFORFEITS 51,201 55,000 93.1% 61,821 65,500 94.4% MISCELLANEOUS REVENUES 132,705 423,190 31.4% 175,609 338,124 51.9`Yo TRANSFER FROM OTHER FUNDS 573,666 848,909 67.6% 552,545 753,759 73.3% TOTAL REVENUES 8,352,324 10,922,181 76.5% 7,663,150 10,504,831 72.9% BEGINNING CASH RESERVES 5,534,856 6,131,749 90.3% 4,962,399 5,068,245 97.9% TO7AL SOURCES 13,887,180 17,053,930 81.4% 12,625,549 15,573,076 81.1°/. CITY COUNCIL 33,259 52,117 63.8% 33,183 49,708 66.8% CITY MANAGER 183,912 254,480 72.3% 167,670 234,642 71.5% CITY CLERK 220,834 296,444 74.5% 197,320 272,792 72.3% LEGAL 71,879 125,340 57.3°!0 66,291 125,785 52.7% ADMINISTRATIVE SERVICES 363,515 492,658 73.8% 358,822 478,562 75.0% POIICE DEPARTMENT 3,458,183 4,675,788 74.0% 3,572,000 4,807,989 74.3% PUBLIG WORKS 2,574,798 3,694,008 69.7% 2,303,734 3,385,604 68.0% PLANNING DEPARTMENT 296,560 437,156 67.8% 287,688 348,734 82.5% NON-DEPARTMENTAL 576,771 627,277 91.9% 469,209 552,107 85.0% TOTAL EXPENDITURES 7,779�711 10,655�268 73.0% 7�455�917 10�255�923 72.7% ENDING CASH RESERVES 6,180,469 6,482,381 95.3% 5,242,264 5,398,198 97.1% TOTAt USES 13,887,180 17,053,930 81.4% 12,625,549 15,573,076 81.1°/. 5,000,793 6,684,535 �4.8% 18,091 36,150 50.0% 1,313,309 1,880,400 69.8% 208,889 300,061 69.6% 43,271 74,000 58.5% 173,667 276,498 62.8% 517,319 689,129 75.1% 7,275.339 9,94U,773 73.2% 4,733,552 4,711,377 100.5% 12,008,891 14,652,150 82.0% 36,154 50,283 71.9% 161,802 234,046 69.1% 225,480 304,390 74.1% 63,772 107,710 59.2°/a 477,42U 637,994 74.8°Yo 3,193,370 4,429,395 72.1% 2,248,343 3,231,134 69.6% 172,612 248,150 69.6% 531,713 697,671 76.2% 7,110,666 9,940,773 71.5°/. 4,898,225 4,711,377 104.0% 12,008,891 14,652,150 82.0% Property tax collections are lower than last year, as a result of keeping the same millage with reduced taxable values. Licenses and Permits are primarily fees charges for planning and zoning aqivities. lntergovemmental Revenues appear a little higher than last year but most of these revenues are from the State and represent only 8 months collections at this point. Charges for Services budget comparisons are on track with last year and should improve over the summer and end up close to budgeted amounts. Fines and Forfeits inc�ude collection of Code Enforcement liens, which look fine at 70% collected but we have collected only 34% of the rest, which is court and parking fines. Miscellaneous Revenues inGudes investment income, which although less than last year, looks better because we reduced the budgeL By year-end, we currently estimate using about $71,000 of cash reserves. Spending by all the Departments are at or befow 75% of budget (three-fourths of the fiscal year) except Non-Departmental bepuse of completely paying the annual amount due to the CRA Fund_ Revenues and appropriations were increased during the quarter to move an empbyee from the Airport to the Stormwater Division. LOCAL OPTION GAS TAX FUND TOTALREVENUES 2,877,973 3,167,006 90•9% 392,753 623,521 63.0% 2,682,033 2,944,511 9�•1°�u BEGINNlNG CASH RESERVES 82,854 152,559 54.3°/a 1,392,655 1.401,543 99•4�a 58.562 5U,258 176.5%_ TOTAL SOURCES 2,960,827 3,319,565 89.2% 1,785,408 2,025,064 88.2°/. 2,740,595 2,994,769 91.5°/. DEBT SERVICE 1,256.960 1.256.960 100.0% 264,463 264.463 100•0% 2,330,742 2,352,910 99•1°k OTHER EXPENDITURES 238,2Z0 324,100 73.5% 209,996 25Q,000 84.09'0 231,309 291,601 79.3°/a TRANSFERS TO OTHER FUNDS 136 217 1 585 946 8.6% 1,341.795 1.461,429 91.8% 93.750 300.000 31.3% TOTAL EXPENDI7URES 1.631,397 3,167,006 51.5 0 1,816,254 1.975,892 91.9% 2,655,801 2,994,511 90.2% ENDIWG CASH R�SERVES 1.329.430 152,559 871.4% _{30.846) 49.172 -62.7% 84.794 50258 168.7% TOTAL USES 2�960�827 3.319,565 89.2°/a 1�785�408 2�025�064 88.2% 2�740�595 2�994�769 91.5% Refinancing the Paving Loan provided $175,000 of funds for repaving worlc.Tax collec6ons represent only 8 months receipts and are about 1.5°/a lower than last year at this point. The Refinancing of the Paving Loan provided funds for additio�at paving work and lowered the annual debt service requirement by attaining a lower interest rate and extending the maturity dates. DISCRETIONARY SALES TAX FUND TOTAL REVENUES 1,609,211 2,510,445 64.1°/a 1,623,719 2,349,593 69.1% 1,690,444 2,380,150 71.0% BEGINNING CASH RESERVES 1,404,945 1,904,156 73.g�/a 1,379,094 1,292,080 106.79'0 1,623,442 1,292,080 �25,g�/, TOTAL SOURCES 3�014�156 4.414�601 68.3% 3�002�813 3�641�673 82.5% 3�313�886 3�672�230 90.2% TRANSFERS TO OTHER FUNDS 1,514,600 3,392,656 44.6% 1,626,970 2,725,120 59.7°k 1.800,218 3,034,821 59.3% TOTAL EXPENDITURES 1,514,600 3,392,656 44.6% 1,626,970 2,725,120 59.7"/, 1,800,218 3,034,821 59.3% ENDING CASH RESERVES t,499,556 1,021,945 146.7% 1,375,843 916,553 150.1% 1,513,668 637,409 237.5% TOTAL USES 3,014,156 4,414,601 68.3% 3,002,813 3,641,673 82.5°/. 3,313,886 3,672,230 90.2°/. Tax colfections are being received at a little higher than last year. Collections flow through the State, so the amounts received are for only 8 months at this point. Transfers to Other Funds were adjusted to reduce the budget for painting City Hall/Police Department by $23,300; inaease 1/4 Round expenses by $3,450; create a budget for the Davis Street Sewer project and; create a budget for the Indian River Drive parking project. Description CITY OF SEIiAST1AlY, FLORIDA COMPARISON OF ACTUAI. TO [3UDCET END OF 3RD QUARTER FISCAL YEARS 2009, 2010 AND 2011 FY2010 FY2011 FY2012 tr e r tr a r tr _ RIVERFRONT REDEVELOPMENT FUND TOTAL REVENUES 432,782 440,535 98.2% 300,087 300,382 99.9% 257,304 263,716 97.6°/a BEGINNING CASH RESERVES 984,638 644,642 152.7% 682,591 676,714 100_9% 455,810 498,934 91.4% TOTAL SOURCES 1,417,420 1,085,177 130.6% 982,678 977,096 100.6% 713,114 762,650 93.5°i6 OPERATING EXPENDITURES 100,238 145,402 68.9% 138,483 120,727 114.7% 113,508 126,616 89.6% TRANSFERS TOOTHER FUNDS 611,246 466,400 131.1% 340,872 625,905 54.5% 86,626 160 000 54.1% TOTAL EXPENDITURES . a , . o , • � ENDING CASH RESERVES 705,936 473,375 149.1% 503,323 230,464 218.4% 512,980 476,034 107.8°k TOTAL USES 1,417,420 1,085,177 130.69�0 982,678 977,096 100.69�0 713,114 762,650 93.5% Operating expenditures exceeds the FY2011 budget because payments include fa�ade/sign grants that were designated in prior year budgets. Transfers were adjusted for 513,500 for Presidential Street design $225,000 U.S,#1 improvements and 525,000 Gateway Enhancements, less a 32,595 reduction to the Parking Study. PARKING IN-LIEU-OF FUND TOTALREVENUES BEGINtVING CASH RESERVES TOTAL SOURCES EXPENDITURES ENDING CASH RESERVES TOTAL USES - - 0.0°� - - 0.0°k - - 0.0°� - - 0.0% - - 0.0% - - 0.0% - - 0.0% - - 0.0% - - 0.0°k - - 0.0% - - 0.0% - - 0.0% This fund records colleGions of the parking in-lieu-of fee and any subsequent spending of Ihose monies. RECREATION IMPACT FEE FUND TOTALREVENUES BEGINNING CASH RESERVES TOTAL SOURCES TRANSFERS TO OTHER FUNDS TOTAL EXPENDI7URES ENDING CASH RESERVES TOTAL USES 26,531 56,247 47.2% 1,033,393 884,464 116.8°h 1,059,924 940,711 112.7% 23,279 291,232 6.0% 1,036,645 649,479 159.6% 1,059,924 940,711 112.7% 27,572 30,791 89.5% 1,108,310 998,828 110.8% 1,133,882 1,029,617 110.1 % 85,123 765,949 11.1% 0 1,048,759 263,668 397.8% 1,133,882 1,029,617 110.1°k 10,332 13,800 74.9% 12,632 - 0.0% 22,964 13.800 166.4% - - 0.0% 22,964 13,800 166.4% 22,964 13,800 166.4% 52,219 28,500 183.2°� 848,187 441,652 192.0% 900,406 470,152 t91.5% 134,180 470,152 28.5% 766,226 - 0.0% 900,406 470,152 191.5% Additional appropriations were made for $25,000 Dog Park Restrooms; 5904 Lift Station Vent and reductions of E4,527 to close the Hardee Park and Pavillion projects. STORMWATER UTILIrIf FUND TOTALREVENUES BEGINNING CASH RESERVES TOTAL SOURCES OTHER EXPENDITURES TRANSFERS TO OTHER FUNDS TOTAL EXPENDITURES ENDING CASH RESERVES TOTAL USES 810,955 877,344 92.4% 1,012,003 651,397 155.4% 1.822,958 1,528.741 119.2% - 100 0.0°k 722,905 1,020,454 70.8% 1,100, U53 508,187 n/a 1,822,958 1,528,741 119.2% 796,834 843,200 94.5% 588,841 601,040 98.0% 1,385,675 t,444,240 95.9% - 100 0.0% 704,157 1,138, 877 61.8% 681,518 305,263 223.3% 1,385,675 1,444,240 95.9% 801,203 818,450 97.9% 450,156 316,537 142.2% 1,251,359 1,134,987 110.3% - 100 0.0°k 854,968 1,089,599 78.5�0 396,391 45,288 875.3% 1,251,359 1,134,987 110.3% Stormwater fee collections are only slightly ahead of last year. Fu[ure collections may decline due to propeAy owners receiving credits allowed by the Ordinance for stormwater facilities they made to their properties. LAW ENFORCEMENT FORFEITURE FUND TOTAL REVENUES 20,537 10,200 201.3% BEGINNING CASH RESERVES 51,947 20,970 247.7% TOTALSOURCES 72,484 31,170 232.5% EXPENDITURES 4.836 - 0.0% ENDINGCASHRESERVES 67,648 31,170 217.0% TOTAL USES 72,484 31,170 232.5% 993 10,250 9.7% 73,160 52,609 139.1% 74,153 62,859 118.0% 1,600 - 0.0% 72,553 62,859 115.4% 74,153 62,859 118.09�0 13,859 10,125 136.9% 66,585 80,062 83.2% 80,444 90.187 89.2°r6 - - 0.0°r6 80,444 90.187 89.2°�f, 80,444 90,187 89.2% These funds are used for the DARE Program, for vehicle towing charges pending reimbursement and to provide drug investigation monies. DISCRETIONARY SALES TAX BOND FUND TRANSFER FROM OTNER FUNDS MISC. REVENUES TOTAL REVENUES BEGINNING CASH RESERVES TOTAL SOURCES OPERATING EXPENDITURES DEBT SERVICE TOTAL EXPENDITURES ENDING CASH RESERVES TOTAL USES 776,898 1,035,869 75.09'0 6,057 1,000 605.7% 338,906 214,358 158.19�0 1.121,861 1,251,227 89.7% 675 300 225.0°/a 890,947 1,036,569 86,0% 230,239 �214,358 107.4% 1,121.861 1,251,227 89.7°�6 748,168 997,557 75.09'0 2,077 22,854 9.1% 7 , , ,4 . o 1, 554, 6 54 1, 541, 5 7 7 100. 8% 2,304,899 2,561,988 90.0% 675 300 225,0% 899,174 1,019,279 88.2% 1,405,050 1,542,409 91.1% 2,304,899 2,561,988 90.0% 748,043 999,933 74.8% 5,641 22,400 25.29'0 1,554,654 1,541,577 100. $% 2,308,338 2,563,910 90.0% 300 300 100.0% 916,471 1,022,033 89.7% 1,391,567 1,541,577 90.3% 2,308,338 2,563,910 90.0% Debt service to date includes the annual principal and one semi-annual interest payment. The 2nd interest payment will be paid in September. CITY OF SEBASTIAN, FLORtDA COMPARISON OF ACTUAL TO BUDGET END OF 3RD QUARTER F[SCAL YEARS Z009, 2010 AND 2011 FY2010 FY2011 FY2012 Description r r o r r . r tr o STORMWATER UTILITY BOND FUND TRANSFER FROM OTHER FUNDS 328,680 438,240 75.0% 329,158 438,877 75.0% MISC. REVENUES 394 120 328.3% 108 1,122 9.6% TOTAL REVENUES 329,074 438,360 75.1% 329,266 439,999 74.8% BEGINNING CASH RESERVES 85,876 20,686 415.1% 182,951 182,932 100.0% TOTAL SOURCES 414,950 459,046 90.4% 512,217 622,931 82.2% DEBT SERVICE 438,360 438,360 100.0% 440,077 439,911 100.0°/a TOTAL EXPENDITURES 438,360 438,360 100.0% 440,077 439,911 100.0% ENDING CASH RESERVES (23,410) 20,686 -113.2% 72,140 183,020 39.4% TOTAI USES 414,950 459,046 90.4% 512,217 622,931 82.2% 328,892 439,023 74.9% 92 1,100 8.4% 328,984 440,123 74.7% 18 2, 951 182, 93 2 100. 0% 511,935 623,055 82.2% 440,290 440,123 100.0% 440,290 440,123 100.0% 71,645 182,932 39.2% 511,935 623,055 82.2�0 Debt service to date includes the semi-annual principal and interest payments for November 1 st and May 1st, plus bank fees. GOLF COURSE FUND CNARGES FOR SERVICE MISC. REVENUES TOTAL REVENUES BEGINNING CASH RESERVES TOTAL SOURCES PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTlAY TRANSFERS TO OTHER FUNDS DEBT SERVICE TOTAL EXPENDITURES ENDING CASH RESERVES TOTAL USES 1,103,473 1,483,200 74.4% 1,140,619 1,261,474 90.4% 36,255 112,713 32.2% 25,266 36,410 69.4% 1,139,728 1,595,913 71.4% 1,165,885 1,297,884 89.8% (67,076) 764,318 $.8% (335,946) (367,001) 91.5% 1,072,652 2,360,231 45,4% 829,939 930,883 89.2% 244,426 350,023 69.8% 228,454 340,270 67.1% 666,785 922,790 72.3% 692,507 956,539 72.49�0 - 10,000 0.0% - - 0.0% - - 0.0°/n - - 0.0% 7.875 313,100 2.5% - 1,075 0.0% 919,086 1,595,913 57.6% 920,961 1,297,884 71.0% 153,566 764,318 20.1% (91,022) (367,001) 24.8% 1,072,652 2,360,231 45.4% 829,939 930,883 89.2% 1,164,039 1,270,793 91.6% 34,324 34,960 98.2% 1,198,363 1,305,753 91.8% (216,241) (249,485) 86.7% 982,122 1,056.268 93.0% 205,439 278,843 73.7°/a 732,603 952,518 76.9% 25,311 25,906 97.7°/a 31,350 - 0.0% - - 0.0% 994,703 1,257,267 79.1% (12,581) (200,999) 6.3% 982,122 1,056,268 93.09'0 Shortfalls in actual revenues required the use of Cash Reserves to meet total expenditures over the past couple of years.lt is normally our intent to maintain Cash Reserves and pro shop inventory exceeding liabilities but for several years, 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 Cash Reserves are now being replenished. AIRPORT FUND LEASE REVENUES 268,127 371,219 72.2% 281,898 345,855 81.5% 314,430 409,116 76.9% MISC. REVENUES 26,877 17,000 158,1% 12,760 49,215 25.9% 15,348 38,008 40.4% TOTAL REVENUES 295,004 388, 19 76.0% 294,658 395,070 74.6% 329,778 447,124 73.8% BEGINNING CASH RESERVES (51,665) 65,784 -78,5% (57,243) (96,942) 59.0% (66,889) (57,243) 116.9% TOTAL SOURCES 243,339 454,003 53,6% 237,415 298,128 79.6% 262,889 389,881 67.4% PERSONAL SERVICES 171.630 231,369 74.2% 164,743 230,275 71.5% 169,913 221,620 76.7% OPERATING EXPENSES 128,380 134,717 95.3% 131,884 156,245 84.4% 142,754 185,754 76.9°k CAPITAL OUTLAY 5,923 3,946 0.0% - - 0.0% 3,500 22,500 15.6% DEBT SERVICE - 8,550 0.0% - 8,550 0.0% - 17,250 0.0% TOTAL EXPENDITURES 305,933 378,582 80.8°0 296,627 395,070 75.1°b+ 316,167 447,124 70.7% ENOING CASH RESERVES (62,594) 75,421 -83.0% (59,212) (96,942) 211.1% (53,278) (57,243) 690.2% TOTAL USES 243,339 454,003 53.6% 23T,415 298,128 79.6% 262,889 389,881 67.4% 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 and fuel inventory 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 290,345 489,334 59.3% 314,556 465,740 67.5% BEGINNINGCASHRESERVES 651,126 779,429 83.5% 554,519 504,899 109.8% TOTAL SOURCES 941,471 1,268,763 74.2% 869,075 970,639 89.5°�6 PERSONAL SERVICES 280,097 379,674 73.8% 264,757 367,626 72.09'0 OPERATING EXPENSES 83,743 109,660 76.4% 71,204 98,114 72.6�0 TOTAL EXPENDITURES 363,840 489,334 74.4% 335,961 465.740 72.1 % ENDING CASH RESERVES 5T7,631 779,429 74.1% 533,114 504,899 105.6% TOTAL USES 941,471 1,268,763 74.2% 869,075 970,639 89.5°k 357,430 389,150 91.8% 460,448 431,386 106.7% 817,878 820,536 99.7% 22T,133 322,000 70.5°� 66,479 91,059 73.0% 293,612 413,059 71.1 % 524,266 407,477 128.7% 817.878 820,536 99.7% Ending Cash Reserves have steadily declined due to the economic slump. However, Beginning Cash Reserves for 2012 were slighdy higher than anticipated. CITY OF SEQASTIAN, FLORIDA COMPARISON OF ACTUAL TO I3UDGET END OF 3RD QUARTER FISCAL YEARS 2009, 2010 AND 201 I FY2010 FY2011 FY2012 Description 3rd Qtr YTD BUDGE7 °/. 3rd Qtr YTD BUOGET °/. BUDGET BUDGET °e GENERAL FUND DETAIL ON DEPARTMENTS CITY COUNCIL Personnei Operating Totals CITY MANAGER Personnel Operating Tota Is CITY CLERK Personnel Operating Totals LEGAL Personnel Operating Totals ADMINISTRATIVE SERVICES Personnel Operating Capital Outiay Totals POLICE DEPARTMENT Personnel Operating Capital Outlay Totals PUBLIC WORKS Personnel Operating Capital Outlay Totals PLANNING DEPARTMENT Personnel Operating Totals NON-DEPARTMENTAL Personnel Operating Transters to Other Funds Totals TOTAL EXPENDITURES Personnel Operating Capital Outlay Transfers to Other Funds Totals ENDING CASH RESERVES TOTAL USES 17,08t 22.742 75.1% 17,069 22.761 75.0% 17,067 22,747 75.0% 16,178 29,375 55.1% 16,114 26,947 59.8% 19,087 27,536 69.3% 33,259 52,117 63.8% 33,183 49,708 66.8% 36,154 50,283 71.9% 179,550 250,455 71.7% 164,627 229,734 71.7% 158,587 230,746 68.7% 4,362 4,025 108.4% 3,043 4,908 62.0% 3,215 3,300 97.4% 183,9t2 254,480 72.3°0 167,670 234,642 71.5 0 161,802 234,046 69.1% 174,208 240,794 72.3% 173,348 243,373 71.2% 177,810 249,A68 71.3% 46,626 55,650 83.8% 23,972 29,419 81.5% 47,670 54,922 86.8°h 220,834 296,444 74.5% 197,320 272,792 72.3% 225,480 304,390 74.1 /o 0 0 0.0% 0 0 0.0% 0 0 0.0% 71,879 125,340 57.3% 66,291 125,785 52.7% 63,772 107,710 59.2% 71,879 125,340 57.3% 66.291 125,785 52.7% 63,772 107,710 59.2% 290,515 408,939 71.0% 286,190 397,517 72.0% 371,765 516,060 72.0% 73,000 83,719 87.2% 72,632 81,045 89.6% 101,477 117,755 86.2% 0 Q 0.0% 0 0 0.0% 4,178 4,179 100.0% 363,515 492,658 73.8% 358,822 478,562 75.0% 477,420 637,994 74.8% 3,136,747 4,250,025 T3.8% 3,194,012 4,381,821 72.9% 2.843,593 3,996,037 71.2% 289,685 398,892 72.6% 333,910 389,533 85.7% 345,588 433,358 79.7°h 31,751 26,871 118.2% 44,078 36,635 120.3% 4,189 0 0.0% 3,458,183 4,675,788 74.0% 3,572,000 4,807,989 74.3% 3,193,370 4,429,395 72.t°h 1,872,385 2,563,799 73.0% 1,595,517 2,345,644 68.0% 1,536,404 2,176,307 70.6% 683,422 1,113,664 61.4% 705,122 1,027,160 68.6% 686,405 1,033,627 66.4% 18,991 16,545 114.8% 3,095 12,800 24.2% 25,534 21,200 120.49'0 � � , � • o � , , � • o � � � � . o 267,015 372,436 71.7% 258,337 312,127 82.8% 160,771 227,698 70.6% 29,545 64,720 45.7% 29,351 36,607 80.2% 11,841 20,452 57.9% 296,560 437,156 67.8% 287,688 348,734 82.5% 172.612 248,150 6.6% 12,167 15,000 87.1% 12.079 15,000 80.5°/ 85.286 139,450 61.2% 564,604 612,277 922% 457,130 537,107 85.1% 446,427 497,221 89.8°.6 0 0 0.0% 0 0 U.0% 0 61,000 O.0`Yo 576,771 627,277 91.9°0 469,209 552,107 $5.0% 531,713 697,671 76.2% 5,949,668 8,124,190 73.2% 5,701,179 7,947,977 71.7% 5,351,283 7,558,513 70.8% 1,706,301 2,403,943 71.0% 1,634,933 2,177,466 75.1% 1,725,482 2,295,881 75.2°/6 50,742 43,416 116.9% 47,173 49,435 95.4% 33,901 25,379 133.6% 0 0 0.0% 0 0 0.0°i6 0 61,000 0.0% 7,706,711 10,571,549 72.9% 7,383,285 10,174,878 72.6% 7,110,666 9,940,773 71.5% 6,180,469 6,482,381 95.3% 5,242,264 5,398,198 97.1% 4,898,225 4,711,377 104.0% 13,887,180 17,053,930 81.4°/, 12,625,549 15,573,076 81.1% 12,008,891 14,652,150 82.0% - CAPITAL PKOJECT STATUS REPO1tT 6l30/2012 GENERAL CAPITAL PROJECTS FUND 310 Project Number Descrintion Cl 108 Excavation Equipment (CLOSED) Cl 109 Telephone System A1210 Garage Equipment A 121 I Repaint Ciry HalllPD Al2I2 Police Vehicle Keplacement CAPITAL IMPROVEMENT PROJECTS FUND 320 . Project Num r Description C0721 Hazdee Park Improvement (Zone A) CLOSED C092t Schumann Park Improvements CI 122 Riverview Park Pavilion (Schumann ParkxCLOSED) Cf 123 Bark Park Amenties C 1124 Lift Station - Riverview Park C1125 Kiverview Park lrrigation Fountains C1126 PresidentalStreets C I 129 Easy St Park Improvements A1221 Mooring Fields A1222 Blueway 5ignage A1223 Rleacher Shietds A1224 Creative Playground A1225 Handicapp pier A1226 Riverview Park Electrical (Closed) A1227 Four Chaplains Memorial Sidewalk/Landscape A1261 BBSC Baseball Field Drainage TRANSPORTATION CAPITAL PROJECTS FUND 330 Project Number Description C0735 Powerline Road (Closed) C0834 512 Corridor (DST - FDOT Grant)-CLOSED C1131 US 1 Improvements-CLOSED C1132 Gateway Enhancement P0001 Road Paving A1231 Cav Corp Enhancements A1233 1nJian River Drive Parking A1234 Davis Street Sewer STORMWATF.R IMPROVF.MENT FUND FUND 363 Project Numbcr Dcscriotion C4606 Collier Creek Impwvements (DEP GRANT 5500,000) P0003 1/4 Round Swale Rehab (DST) - CLOSED C I601 Stormwater Master Plan AIRPORT PROJECTS FUND 455 Project Number Descriotion C0951 Conswct Hangars (CLOSEU) C I l52 Install Sceuriry Cameras A1251 5urvey, Markings, Rehab Apron F Percent Project Expenditures Funds Expended/ ��1 TQ� �ncumbranccs Rcmaining Encumbered 166,053.62 166,053.G2 - - 100.00% 63,644.00 46,192.49 19,222.77 ((,771.26) 102.78% 23,000.00 18,789.04 - 4,210.46 St.69% 9,�00.00 9,700.00 - - 100.00% 182,871.00 I69,870.20 - 13,000.80 92.89% 445,268.62 410,605.35 19,222.77 15,440.50 96.53% Peroent Project Expenditures Funds Expended/ Bud et To Date Encumbrances Remainine Encumbered 47,432.01 47,432.01 - - ]00.00% 246,460.00 167,84038 24,096.00 54,523.62 77.88°/. 28,720.71 28,720.71 - - 100.00°/. ]00,000.00 5,350.00 6,000.00 88,650.00 11.35% 100,586.50 62,862.49 - 37,724.01 62.50% 25,000.00 8,26I.52 - 16,738.48 33.05% 473,500.00 33,179.44 - 440,320.56 7.01% 63,000.00 57,886.77 - 5,113.23 91.88% I5,000.00 - - IS,000.00 0.00% 25,000.00 - - 25,000.00 0.00% 50,000.00 - - 50,000.00 0.00°/. 30,000.00 - - 30,000.00 0.00°/. I5,000.00 - - I5,000.00 0.00°/. 7,389.I6 7,389.16 - - ]00.00°/. 20,000.00 18,184.57 1,114.50 700.93 96.50°/. 50,000.00 3,08J.99 400.00 46,516.01 6.97% 1,297,088.38 440,I91.04 31,610.50 825,286.84 36.37% Percent Project Expenditures Funds Expcnded/ Hudeet To Date �ncumbrances Remainine Encumbered 1,076,74830 1,076,34830 - - 100.00°/. 303,862.44 303,862.44 - - ]00.00% 309,120.R4 309,120_84 - 0.00 ]00.00°/. 25,000.00 - - 25,000.00 0.00°/. 214,554.57 13,879.50 8,000.00 192,675.07 10.20°/s 75,000.00 27,498.15 42,641.87 4,859.98 93.52°/. 125,000.00 - - 125,000.00 0.00°/. 150,000.00 - - �50,000,00 0.00% 2,278,886.15 1,730,'709.23 50,641.87 497,535.05 78.17% Percent Project Expenditures Funds Expended! Budect To Datc Encumbranccs Rcmainine Encumbcrcd 4,925,102.11 4,918,872.11 8,230.00 (2,000.00) 100.04% 2,651,110.00 2,651,170.00 - - 100,0p^/. 50,000.00 27,500.00 - 22,500.00 55.00°ti 7,626,272.11 7,597,542.11 8,230.00 20,500.00 99.62% Percent Project Expenditurcs Funds Expended/ Bodgt �Da� Encumbrances Remainine Encumbcred 1,320,886.63 1,320,886.63 - _ Ipp,pp^yo 4�,�� - - 43,000.00 0.00% 164,400.00 - - 164,400.00 0.00% 1,528,286.63 1,320,886.63 - 207 400.00 86.43%