HomeMy WebLinkAbout11-12-FY 4th QuarterRESOLUTION NO. R-12-39
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, 2012 regarding revenues
and expenditures for the three (3) months ended March 31, 2012; and
WHEREAS, the City of Sebastian adopted Resolution No. R-12-22 on August 22, 2012 regarding
revenues and expenditures for the three (3) months ended July 31, 2012; and
WHEREAS, an analysis of the revenues and expenditures for the three (3) months ended September 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 Coy
The motion was seconded by Councilmember Wright and, upon being put to a vote, the vote
was as follows:
Mayor Bob McPartlan
Vice-Mayor pon Wright
Councilmember Andrea Coy
Councilmember Jim Hill
Councilmember Jerome Adams
aye
aye
aye
aye
ave
The Mayor thereupon declared this Resolution duly passed and adopted this 12`h day of December 2012.
ATTEST:
� �
.
Sally A. Ma' , MMC
City Clerk
CITY OF BASTIA�OR A
By: �i-' G�''�
Mayor Bob McPartlan
Approved as to form and content for
relianc by 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-OF FEES
Revenues
Expenditures
RECREATION IMPACT FEE
Revenues
Expenditures
STORMWATER UTILITY FEE
Revenues
Expenditures
LAW ENFORCEMENT FORFE[TURE
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 3RD QUARTER BUDGET AFTER
ADJ[JSTMENTS ADJUSTMENTS ADJUSTMENTS
$ 9,940,773 $ 139,263 $ 10,080,036
9,940,773 139,263 10,080,036
2,944,511 - 2,944,511
2,944,511 - 2,944,511
3,034,821 (38,014) 2,996,807
3,034,821 (38,014) 2,996,807
286,616 - 286,616
286,616 - 286,616
13,800 - 13,800
13,800 - 13,800
470,152 (26,189) 443,963
470,152 (26,189) 443,963
1,089,699 - 1,089,699
1,089,699 - 1,089,699
10,125 - 10,125
10,125 - ] 0,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
447,124 4,125 451,249
447,124 4,125 451,249
413,059 - 413,059
413,059 - 413,059
$ 21,418,889 $ 79,185 $ 21,498,074
Description
GENERAL FUND SUMMARY
TAXES
LICENSES & PERMITS
INTERGOVERNMENTALREVENUES
CHARGES FOR SERVICES
FINES AND FORFEITS
MISCELLANEOUS REVENUES
TRANSFER FROM OTHER FUNDS
TOTAL REVENUES
BEGINNING CASH RESERVES
TOTAL SOURCES
CITY OF SEBASTIAN, FLORIDA
COMPARISON OF ACTUAL TO BUDGET
END OF 4TH QUARTER
FISCAL YEARS 2010, 2011 AND 2012
FY2010 FY2011 FY2012
4thQtr YTD BUDGET % 4thQtr YTD BUDGET % 4thQtr YTD BUDGET %
7,400,141 7,531,430 98.3%
33,182 51,400 64.6%
1,997,119 1,857, 957 107.5%
282,530 289,147 97.7%
71,415 55,000 129.8%
286,894 423,190 67.8°/a
764,888 764,888 100.0%
10,836,169 10,973,012 98.8°/a
4,472,233 5,255,327 85.1%
15,308,402 16,228,339 94.3%
6,733,190 7,179,708 93.8%
23,645 44,650 53.0%
2,002,032 1,970,017 101.6%
260,838 286,550 91.0%
80,653 65,500 123.1%
242,822 338,124 71.8%
736,727 736,727 100.0%
10,079,907 10,621,276 94.9%
5,228,495 5,535,011 94.5%
15,308,402 16,156,287 94.8%
6,320,547 6,684,535 94.6°/a
22,430 36,150 62.0°/a
2,078,686 2,019,663 102.9%
290,951 300,061 97.0°/a
52,307 74,000 70.7°/a
227,378 276,498 82.2%
692,716 689,129 100.5%
9,685,015 10,080,036 96.1%
4,733,552 5,068,245 93.4%
14,418, 567 15,148, 281 95.2 %
CITY COUNCI� 48,017 52,117 92.1% 47,060 52,117 90.3°/a 49,225 50,283 97.9%
CITY MANAGER 249,378 254,480 98.0% 232,469 233,196 99.7% 223,900 234,046 95.7%
CITY CLERK 292,968 296,444 98.8% 272,886 272,792 100.0% 301,395 304,390 99.0%
LEGAL 104,586 125,340 83.4% 98,712 125,785 78.5% 94,718 107,710 87.9%
ADMINISTRATIVE SERVICES 489,025 492,658 99.3% 481,051 478,562 100.5% 478,043 477,869 100.0%
MANAGEMENT INFO SERVICES 265,375 266,913 99.4% 274,797 248,908 110.4% 161,526 160,125 100.9%
POLICE DEPARTMENT 4,968,164 4,959,722 100.2°/a 5,073,186 4,941,466 102.7% 4,515,749 4,568,658 98.8%
PUB�IC WORKS 3,541,756 3,694,008 95.9°/a 3,201,255 3,385,604 94.6% 3,112,210 3,231,134 96.3%
GROWTH MANAGEMENT 410,050 437,156 93.8% 349,388 348,734 100.2% 237,575 248,150 95.7%
NON-DEPARTMENTAL 622,565 627,277 99.2% 544,046 552,107 98.5% 607,545 697,671 90.8%
TOTAL EXPENDITURES 10,991,884 11,206,115 98.1% 10,574,850 10,639,271 99.4% 9,781,886 10,080,036 97.0%
ENDING CASH RESERVES 5,228,495 5,022,224 104.1% 4,733,552 5,517,016 85.8% 4,636,681 5,068,245 91.5%
TOTAL USES 15,308,402 16,228,339 94.3% 15,308,402 16,156,287 94.8% 14,418,567 15,148,281 95.2%
Property tax collections are lower than last year due to the decline in taxable values and lower receipts from Franchise Fees and Utility Taxes.
Licenses 8� Permits were less than anticipated. Intergovernmental Revenues were increased for the State's Police Pension contribution and are just
slightly above the same amounts as last year. Charges for Services are lower than budgeted but greater than last year. Fines and Forfeits include
collection of Code Enforcement liens, which were less than prior years. Miscellaneous Revenues continues to fall lower than budget because of
declining investment returns but should improve with the change to Seacoast National Bank. Total Sources includes the amount of actual and
estimated cash reserves. In 2012, we used $96,871 of cash reserves based on unaudited figures, essentially because total revenues were not as high
as planned. $71,875 of this was expected, when we made our projections for the 2013 budget. It is also noted that the Ending Cash Reserves of
$4,636,681 were just $24,996 less than the $4,661,677 we projected would be available, when we did our projections for the 2013 budget.
Total spending by all Departments, was 97.3°/a under budget. The slight overage in MIS was due to expensing the $1,085 trade-in value for the old
firewall product to reflect the total price of the new firewall and the charge to expense is offset by that revenue.
LOCAL OPTION GAS TAX FUND
TOTAL REVENUES 3,080,591 3,167,006 97.3% 576,906 623,521 92•5% 2,861,116 2,944,511 97.2%
BEGINNING CASH RESERVES 82,579 152,559 54.1% 1,392,655 1,477,988 94.2°/a 58,562 50,258 116.5°/a
TOTAL SOURCES 3,163,170 3,319,565 95.3% 1,969,561 2,101,509 93.7% 2,919,678 2,994,769 97.5°/a
DEBT SERVICE 1,256,960 1,256,960 100.0% 264,463 264,463 100.0% 2,330,742 2,352,910 99.1%
OTHER EXPENDITURES 324,523 324,100 100.1°/a 259,591 250,000 103.8% 274,405 291,601 94.1%
TRANSFERS TO OTHER FUNDS 189,032 1,585,946 1,386,945 1,461,429 94.9% 124,258 300,000 41.4%
TOTAL EXPENDITURES 1,770,515 3,167,006 55.9°/a 1,910,999 1,975,892 96.7% 2,729,405 2,944,511 92•7%
ENDING CASH RESERVES 1,392,655 152,559 912.9% 58,562 125,617 46.6% 190,273 50,258 378.6%
TOTAL USES 3,163,170 3,319,565 95.3% 1,969,561 2,101,509 93.7% 2,919,678 2,994,769 97.5%
Tax collections were 1.3% less than last year. Refinancing the Paving Loan provided funds for paving and also lowered the annual debt service
requirement by extending the maturity dates. Most of the Ending Cash Reserves are the funds provided by the Loan which are already committed to
that paving project.
DISCRETIONARY SALES TAX FUND
TOTAL REVENUES 2,913,062 2,510,445 116.0% 2,364,053 2,349,593 100.6% 2,491,406 2,380,150 104.7°/a
BEGINNING CASH RESERVES 958,676 1,904,156 50.3% 1,379,095 1,379,095 100.0% 1,623,442 1,292,080 125.6°/a
TOTAL SOURCES 3,871,738 4,414,601 87.7% 3,743,148 3,728,688 100.4% 4,114,848 3,672,230 112.1°/a
TRANSFERS TO OTHER FUNDS 2,492,643 3,405,210 73.2% 2,119,706 2,164,057 98.0% 2,099,275 2,996,807 70.1%
TOTAL EXPENDITURES 2,492,643 3,405,210 73.2°/a 2,119,706 2,164,057 98.0% 2,099,275 2,996,807 70.1%
ENDING CASH RESERVES 1,379,095 1,009,391 136.6°/a 1,623,442 1,564,631 103.8% 2,015,573 675,423 298•4%
TOTAL USES 3,871,738 4,414,601 87.7% 3,743,148 3,728,688 100.4% 4,114,848 3,672,230 112.1%
Tax collections in 2012 were higher than the prior year. Transfers to Other Funds were adjusted during the quarter as a result of several projects being
closed. This $38,014 adjustment included police vehicles, 4 Chaplains memorial, garage equipment, stormwater plan and City-wide telephone system.
CITY OF SEBASTIAN, FLORIDA
COMPARISON OF ACTUAL TO BUDGET
END OF 4TH QUARTER
FISCAL YEARS 20I0, 2011 AND 2012
FY2010 FY2011 FY2012
Description 4thQtr YTD BUDGET % 4thQtr YTD BUDGET o 4thQtr YTD BUD ET %
RIVERFRONT REDEVELOPMENT FUND
TOTAL REVENUES 2,993,550 440,535 679.5% 319,036 300,382 106.2% 268,509 263,716 101.8%
BEGINNING CASH RESERVES 984,638 795,308 123.8% 682,591 676,714 100.9% 455,810 434,338 104.9%
TOTAL SOURCES 3,978,188 1,235,843 321.9% 1,001,627 977,096 102.5% 724,319 698,054 103.8%
OPERATING EXPENDITURES 129,352 152,118 85.0% 188,918 120,727 156.5% 140,967 126,022 111.9%
CAPITAL OUTLAYS 3,096,416 540,520 572.9% - - 0.0% - - 0.0%
TRANSFERS TO OTHER FUNDS 69,829 69,830 100.0°/a 356,899 382,494 93.3% 104,458 160,594 65.0°/a
TOTAL EXPENDITURES 3,295,597 762,468 432.2 0 545,817 503,221 108.5% 245,425 286,616 85.6°0
ENDING CASH RESERVES 682,591 106,249 642.4% 455,810 473,875 96.2% 478,894 411,438 116.4%
TOTAL USES 3,978,188 868,717 457.9% 1,001,627 977,096 102.5% 724,319 698,054 103.8°/a
Operating expenditures exceeded the FY2012 budget because payments include fa�ade/sign grants that were authorized in prior year budgets. There
were no changes during the quarter to amounts budgeted for Transfers.
PARKING IN-LIEU-OF FUND
TOTAL REVENUES - - 0.0% 12,632 - 0.0°/a 13,833 13,800 100.2%
BEGINNING CASH RESERVES - - 0.0°/a - - 0.0°/a 12,632 - 0.0°/a
TOTAL SOURCES - - o - o 0
EXPENDITURES - - 0.0% - - 0.0% - - 0.0%
ENDING CASH RESERVES - - 0.0% 12,632 - 0.0% 26,465 13,800 191.8%
TOTAL USES - - o - o 0
This fund records collections of the parking in-lieu-of fee and any subsequent spending of those monies.
RECREATION IMPACT FEE FUND
TOTAL REVENUES 38,256 56,247 68.0% 49,473 30,791 160.7% 62,889 28,500 220.7°/a
BEGINNING CASH RESERVES 1,087,353 884,464 122.9°/a 1,106,310 998,826 110.8% 848,187 441,652 192.0%
TOTAL SOURCES 1,125,609 940,711 119.7% 1,155,783 1,029,617 112.3% 911,076 470,152 193.8°/u
CAPITAL OUTLAYS - - 0.0% 5,118 - 0.0% - - 0.0%
TRANSFERS TO OTHER FUNDS 19,299 291,232 6.6% 302,478 765,949 39.5% 217,854 443,962 49.1%
TOTAL EXPENDITURES 19,299 291,232 6.6% 307,596 765,949 40.2% 217,854 443,962 49.1%
ENDING CASH RESERVES 1,106,310 649,479 170.3% 848,187 263,668 321.7% 693,222 26,190 2646.9%
TOTAL USES 1,125,609 940,711 119.7% 1,155,783 1,029,617 112.3% 911,076 470,152 193.8%
Transfers to Other Funds were reduced during the quarter, due to adjustments to close out the Easy Street Park Improvements, Mooring Fields and
Baseball Field Drainage projects.
STORMWATER UTILITY FUND
TOTAL REVENUES 858,665 897,200 95.7°/a 816,415 843,200 96.8% 813,004 818,450 99.3%
BEGINNING CASH RESERVES 787,481 651,397 120.9% 588,841 336,270 175.1% 450,156 336,270 133.9%
TOTAL SOURCES 1,646,146 1,548,597 106.3% 1,405,256 1,179,470 119.1% 1,263,160 1,154,720 109.4%
OTHER EXPENDITURES 97 3,500 2.8% 104 100 104.0% 8,348 100 8348.0%
TRANSFERS TO OTHER FUNDS 1,057,208 1,019,228 103.7% 954,996 1,104,931 86.4% 1,087,257 1,089,599 99.8%
TOTAL EXPENDITURES 1,057,305 1,022,728 103.4% 955,100 1,105,031 86.4% 1,095,605 1,089,699 100.5%
ENDING CASH RESERVES 588,841 525,869 112.0% 450,156 74,439 604.7% 167,555 65,021 257.7%
TOTAL USES 1,646,146 1,548,597 106.3% 1,405,256 1,179,470 119.1% 1,263,160 1,154,720 109.4%
Stormwater fee collections and investment income were lower than last year. Some of the decline was due to property owners receiving credits
allowed by the Ordinance for stormwater facilities they made to their properties.
LAW ENFORCEMENT FORFEITURE FUND
TOTAL REVENUES 25,575 10,200 250.7% 906 10,200 8.9% 14,559 10,125 143.8%
BEGINNING CASH RESERVES 53,600 20,970 255.6% 73,160 20,970 348.9% 66,585 52,609 126.6%
TOTAL SOURCES 79,175 31,170 254.0% 74,066 31,170 237.6% 81,144 62,734 129.3%
EXPENDITURES 6,015 - 0.0% 1,600 - 0.0% 12,239 - 0.0%
CAPITAL OUTLAYS - - 0.0% 5,881 - 0.0% - - 0.0%
ENDING CASH RESERVES 73,160 31,170 234.7% 66,585 31,170 213.6% 68,905 62,734 109.8%
TOTAL USES 79,175 31,170 254.0% 74,066 31,170 237.6% 81,144 62,734 129.3%
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 OTHER FUNDS 1,162,586 1,035,869 112.2% 997,557 997,557 100.0% 1,016,206 999,933 101.6%
MISC. REVENUES 7,038 1,000 703.8% 5,747 22,854 25.1% 4,994 22,400 22.3%
TOTAL REVENUES 1,169,624 1,036,869 112.8% 1,003,304 1,020,411 98.3% 1,021,200 1,022,333 99.9%
BEGINNING CASH RESERVES 1,409,493 338,906 415.9% 1,554,654 1,541,577 100.8% 1,538,346 1,542,409 99.7%
TOTAL SOURCES 2,579,117 1,375,775 187.5°/a 2,557,958 2,561,988 99.8°/a 2,559,546 2,564,742 99.8°/a
OPERATING EXPENDITURES 675 300 225.0% 675 300 225.0% 300 300 100.0%
DEBT SERVICE 1,023,788 1,036,569 98.8% 1,018,937 1,019,279 100.0% 1,022,067 1,022,033 100.0%
TOTAL EXPENDITURES 1,024,463 1,036,869 98.8% 1,019,612 1,019,579 100.0% 1,022,367 1,022,333 100.0%
ENDING CASH RESERVES 1,554,654 338,906 458.7% 1,538,346 1,542,409 99.7% 1,537,179 1,542,409 99.7%
TOTAL USES 2,579,117 1,375,775 187.5% 2,557,958 2,561,988 99.8% 2,559,546 2,564,742 99.8%
Principal and interest payments were made as scheduled. Ending cash reserves are at required amounts.
�
CITY OF SEBASTIAN, FLORIDA
COMPARISON OF ACTUAL TO BUDGET
END OF 4TH QUARTER
FISCAL YEARS 2010, 2011 AND 2012
FY2010 FY2011 FY2012
Description 4thQtr YTD BUD ET % 4thQtr YTD BUDGET % 4thQtr YTD BUDGET °o
STORMWATER UTILITY BOND FUND
TRANSFERFROM OTHERFUNDS
MISC. REVENUES
TOTALREVENUES
BEGINNING CASH RESERVES
TOTAL SOURCES
DEBT SERVICE
TOTAL EXPENDITURES
ENDING CASH RESERVES
TOTAL USES
476, 221 438, 240 108.7 %
455 120 379.2%
476,676 438,360 108.7%
144,635 85,876 168.4%
621,311 524,236 118.5%
438,360 438,360 100.0%
438,360 438,360 100.0%
182,951 85,876 213.0%
621,311 524,236 118.5%
440,018 438,877 100.3% 439,674 439,023 100.1°/a
128 1,122 11.4% 174 1,100 15.8%
440,146 439,999 100.0% 439,848 440,123 99.9%
182,951 182,932 100.0% 183,020 183,020 100.0%
623,097 622,931 100.0°/a 622,868 623,143 100.0%
440,077 439,911 100.0% 440,290 440,123 100.0%
440,077 439,911 100.0% 440,290 440,123 100.0%
183,020 183,020 100.0% 182,578 183,020 99.8%
623,097 622,931 100.0% 622,868 623,143 100.0%
Principal and interest payments were made as scheduled. Ending cash reserves are at required amounts.
GOLF COURSE FUND
CHARGES FOR SERVICE 1,263,860 1,483,200 85.2% 1,298,370 1,261,474 102.9% 1,310,964 1,270,793 103.2%
MISC. REVENUES 43,772 45,198 96.8% 33,226 36,410 91.3% 43,078 34,960 123.2%
TOTAL REVENUES 1,307,632 1,528,398 85.6% 1,331,596 1,297,884 102.6% 1,354,042 1,305,753 103.7°/a
BEGINNING CASH RESERVES (102,364) (299,486) 34.2°/a (330,836) (249,485) 132.6% (216,241) (153,532) 140.8%
TOTAL SOURCES 1,205,268 1,228,912 98.1% 1,000,760 1,048,399 95.5% 1,137,801 1,152,221 98.7%
PERSONAL SERVICES 333,105 345,523 96.4% 297,407 340,270 87.4% 284,128 278,843 101.9%
OPERATING EXPENSES 901,300 913,790 98.6% 914,895 956,539 95.6% 976,975 1,001,004 97.6°/a
CAPITAL OUTLAY - 23,500 0.0% 4,699 - 0.0% 25,311 25,906 97.7%
TRANSFER TO PROJECTS FUND - - 0.0% - - 0.0% 39,002 - 0.0%
EXPENSE FROM PROJECT FUND - - 0.0% - - 0.0% (12,513) - 0.0%
DEBT SERVICE 301,699 313,100 96.4% - 1,075 0.0% - - 0.0°/a
TOTAL EXPENDITURES 1,536,104 1,595,913 96.3% 1,217,001 1,297,884 93.8% 1,312,903 1,305,753 100.5%
ENDING CASH RESERVES (330,836) (367,001) 90.1% (216,241) (249,485) 86.7% (148,613) (153,532) 96.8%
TOTAL USES 1,205,268 1,228,912 98.1% 1,000,760 1,048,399 95.5% 1,164,290 1,152,221 101.0%
Total Revenue for FY2011 was above the amount estimated and above the prior year. Transfers to the Project Fund, less amounts expensed to it,
resulted is Expenditures exceeding budget. At the end of FY2010, $200,000 was loaned from General Fund to meet cash flow needs. At the end of
FY2011, $100,000 was needed and at the end of FY2012 $65,000 was needed. The negative Cash Reserves is mostly due to $57,722 of prepaid
memberships and $65,524 of accrued leave and benefits.
AIRPORT FUND
LEASE REVENUES 379,847 371,219 102.3% 372,837 345,855 107.8% 422,506 413,241 102.2%
MISC. REVENUES 19,113 17,000 112.4% 4,164 20,000 20.8% 17,205 25,600 67.2%
TOTAL REVENUES 398,960 388,219 n/a 377,001 365,855 103.0% 439,711 438,841 100.2%
BEGINNING CASH RESERVES (28,370) 65,784 -43.1% (38,903) (14,679) 265.0% (66,889) (57,243) 116.9%
TOTAL SOURCES 370,590 454,003 81.6% 338,098 351,176 96.3% 372,822 381,598 97.7%
PERSONAL SERVICES 233,677 231,369 101.0% 229,397 230,275 99.6% 208,175 221,620 93.9%
OPERATING EXPENSES 158,265 86,962 182.0% 167,040 156,245 106.9% 255,529 249,540 102.4%
CAPITAL OUTLAY 9,001 61,338 14.7% - - 0.0% - 22,500 0.0%
DEBT SERVICE 8,550 8,550 100.0% 8,550 8,550 100.0% 8,550 17,250 49.6%
TOTAL EXPENDITURES 409,493 388,219 105.5% 404,987 395,070 102.5% 472,254 510,910 92.4%
ENDING CASH RESERVES (38,903) 65,784 -59.1% (66,889) (43,894) 152.4% (99,432) (129,312) 76.9%
TOTAL USES 370,590 454,003 81.6% 338,098 351,176 96.3% 372,822 381,598 97.7%
Total Revenue for FY2012 was above the amount estimated due to new tenants. At the end of FY2012, $40,550 was loaned from General Fund to
meet cash flow needs. The negative Cash Reserves is mostly due to $6,825 of prepaid rent and $63,757 of accrued leave and benefits. An addition
was made to the budget for $4,125 in equipment sales that was applied to equipment repairs.
BUILDING FUND
TOTAL REVENUES 370,287 489,334 75.7% 404,822 465,740 86.9% 426,219 465,740 91.5%
BEGINNING CASH RESERVES 634,962 1,035,000 61.3% 520,554 779,429 66.8°/a 460,448 628,794 73.2%
TOTAL SOURCES 1,005,249 1,524,334 65.9% 925,376 1,245,169 74.3% 886,667 1,094,534 81.0%
PERSONAL SERVICES 375,458 379,674 98.9% 366,911 367,626 99.8% 311,877 367,626 84.8%
OPERATING EXPENSES 109,237 109,660 99.6% 98,017 98,114 99.9% 87,619 98,114 89.3%
TOTAL EXPENDITURES 484,695 489,334 99.1% 464,928 465,740 99.8% 399,496 465,740 85.8%
ENDING CASH RESERVES 520,554 1,035,000 50.3% 460,448 779,429 59.1°/a 487,171 628,794 77.5%
TOTAL USES 1,005,249 1,524,334 65.9% 925,376 1,245,169 74.3°/a 886,667 1,094,534 81.0%
Revenue for 2012 exceeded the prior year and Expenditures have been reduced. Cash Reserves are sufficient to cover $94,916 of accrued leave and
benefits and $68,010 of deferred revenue, while leaving an available balance of $324,245.
C[TY OF SEBASTIAN, FLORIDA
COMPARISON OF ACTUAL TO BUDGET
END OF 4TH QUARTER
FISCAL YEARS 2010, 2011 AND 2012
FY2010 FY2011 FY2012
Description 4thQtr YTD BUDGET % 4thQtr YTD BUDGET % 4thQtr YTD BUDGET %
GENERAL FUND DETAIL ON DEPARTMENTS
CITY COUNCIL
Personnel
Operating
Totals
CITY MANAGER
Personnel
Operating
Totals
CITY CLERK
Personnel
Operating
Totals
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
Totals
DEVELOPMENT SERVICES
Personnel
Operating
Totals
NON-DEPARTMENTAL
Personnel
Operating
Transfers to Other Funds
Totals
TOTAL EXPENDITURES
Personnel
Operating
Capital Outlay
Transfers to Other Funds
Totals
ENDING CASH RESERVES
TOTAL USES
22,413 22,742 98.6% 22,747 22,742 100.0% 22,746 22,747 100.0%
25,604 29,375 87.2% 24,313 29,375 82.8% 26,479 27,536 96.2°/a
48,017 52,117 92.1% 47,060 52,117 90.3% 49,225 50,283 97.9%
243,715 250,455 97.3% 229,007 229,734 99.7% 220,244 230,746 95.4%
5,663 4,025 140.7% 3,462 3,462 100.0% 3,656 3,300 110.8%
249,378 254,480 98.0% 232,469 233,196 99.7% 223,900 234,046 95.7%
240,519 240,794 99.9% 242,478 243,373 99.6% 247,927 249,468 99.4%
52,449 55,650 94.2% 30,408 29,419 103.4% 53,468 54,922 97.4°/a
292,968 296,444 98.8% 272,886 272,792 100.0% 301,395 304,390 99.0%
0 0 0.0% 0 0 0.0% 0 0 0.0%
104,586 125,340 83.4% 98,712 125,785 78.5% 94,718 107,710 87.9%
104,586 125,340 83.4% 98,712 125,785 78.5% 94,718 107,710 87.9%
401,668 408,939 98.2°/a 398,534 397,517 100.3% 399,962 401,420 99.6%
87,357 83,719 104.3% 82,517 81,045 101.8% 78,081 76,449 102.1%
489,025 492,658 99.3% 481,051 478,562 100.5% 478,043 477,869 100.0%
203,325 206,855 98.3% 231,290 203,713 113.5% 117,621 117,000 100.5%
44,833 42,840 104.7% 43,142 45,195 95.5% 38,642 38,946 99.2%
17,217 17,218 100.0% 365 0 0.0% 5,263 4,179 125.9°/a
265,375 266,913 99.4% 274,797 248,908 110.4% 161,526 160,125 100.9%
4,531,184 4,384,877 103.3% 4,577,428 4,515,298 101.4% 4,060,040 4,135,300 98.2%
400,948 546,204 73.4% 451,680 389,533 116.0°/a 451,520 433,358 104.2%
36,032 28,641 125.8% 44,078 36,635 120.3% 4,189 0 0.0%
4,968,164 4,959,722 100.2% 5,073,186 4,941,466 102.7% 4,515,749 4,568,658 98.8%
2,503,831 2,557,799 97.9% 2,199,973 2,345,644 93.8% 2,132,928 2,176,307 98.0%
986,653 1,118,664 88.2% 988,178 1,027,160 96.2% 953,748 1,033,627 92.3%
51,272 17,545 292.2% 13,104 12,800 102.4% 25,534 21,200 120.4%
3,541,756 3,694,008 95.9% 3,201,255 3,385,604 94.6% 3,112,210 3,231,134 96.3%
368,225 372,436 98.9°/a 311,678 312,127 99.9% 223,308 227,698 98.1°/a
41,825 64,720 64.6% 37,710 36,607 103.0% 14,267 20,452 69.8%
410,050 437,156 93.8% 349,388 348,734 100.2% 237,575 248,150 95.7%
20,040 15,000 133.6% 31,163 15,000 207.8% 105,610 110,969 95.2%
602,525 612,277 98.4% 512,883 537,107 95.5% 501,935 558,221 89.9%
0 0 0.0% 0 0 0.0% 0 0 0.0%
622,565 627,277 99.2% 544,046 552,107 98.5% 607,545 669,190 90.8%
8,534,920 8,459,897 100.9% 8,244,298 8,285,148 99.5% 7,530,386 7,671,655 98.2%
2,352,443 2,682,814 87.7% 2,273,005 2,304,688 98.6% 2,216,514 2,383,002 93.0%
104,521 63,404 164.8% 57,547 49,435 116.4% 34,986 25,379 137.9%
0 0 0.0% 0 0 0.0% 0 0 0.0%
10,991,884 11,206,115 98.1% 10,574,850 10,639,271 99.4% 9,781,886 10,080,036 97.0%
4,316,518 5,022,224 85.9% 4,733,552 5,517,016 85.8% 4,636,681 5,068,245 91.5%
15,308,402 16,228,339 94.3% 15,308,402 16,156,287 94.8% 14,418,567 15,148,281 95.2%
GENERAL CAPITAL PROJECTS
FUND 310
Project
Number Description
Cl 108 Excavation Equipment (CLOSED)
C1109 Telephone System (closed)
A1210 Garage Equipment (closed)
A1211 Repaint City Hall/PD (closed)
A 1212 Police Vehicle Replacement (closed)
CAPITAL IMPROVEMENT PROJECTS
FUND 320
Project
Number Description
C0721
C0921
Cll 22
C1123
C ll 24
Cll 25
C1126
C ll 29
A1221
A 1222
A 1223
A 1224
A 1225
A 1226
A 1227
A1261
CAPITAL PROJECT STATUS REPORT
9/30/2012
Hardee Park lmprovement (Zone A) CLOSED
Schumann Park lmprovements
Riverview Park Pavilion (Schumano Park)(CLOSED)
Bark Park Amenties
Lift Station - Riverview Park
Riverview Park Irrigation Fountains
Presidental Streets
Easy St Park lmprovements (CLOSED)
Mooring Fields (CLOSED)
Blueway Signage
Bleacher Shields
Creative Playground
Handicapp Pier
Riverview Park Electrical (Closed)
Four Chaplains Memorial SidewalWLandscape (closed)
BBSC Baseball Field Drainage (CLOSED)
TRANSPORTATION CAPITAL PROJECTS
FUND 330
Project
Number Description
C0735
C0834
C1131
Cll32
P0001
A1231
A1233
A 1234
Powerline Road (Closed)
512 Corridor (DST - FDOT Grant)-CLOSED
US 1 lmprovements - CLOSED
Gateway Enhancement
Road Paving
Cav Corp Enhancements
lndian River Drive Parking
Davis Street Sewer
STORMWATER IMPROVEMENT FUND
FUND 363
Project
Number Description
Percent
Project Expenditures Funds Expended/
BudQet To Date Encumbrances RemaininQ Encumbered
166,053.62 166,053.62 - - 100.00%
65,835.69 65,835.69 - - 100.00°/a
19,865.01 19,865.01 - 0.00 100.00%
9,700.00 9,700.00 - - 100.00%
169,870.20 169,870.20 - - 100.00%
431,324.52 431,324.52 - 0.00 100.00%
Percent
Project Expenditures Funds Expended/
BudQet To Date Encumbrances Remainin� Encumbered
47,432.01 47,432.01 - - 100.00°/a
246,460.00 208,796.68 2,148.00 35,515.32 84.72%
28,720.71 28,720.71 - - 100.00%
100,000.00 11,478.50 - 88,521.50 11.48%
100,586.50 62,862.49 - 37,724.01 62.50%
25,000.00 8,261.52 - 16,738.48 33.05%
473,500.00 33,179.44 - 440,320.56 7.01%
57,886.77 57,886.77 - - 100.00%
- - - - 0.00%
25,000.00 - - 25,000.00 0.00%
50,000.00 86.49 - 49,913.51 0.17%
30,000.00 - 17,375.00 12,625.00 0.00%
I5,000.00 - - 15,000.00 0.00%
7,38916 7,389.16 - - 100.00%
32,428.56 32,428.56 - - 100.00°/a
43,92331 43,92331 - - 100.00%
1,825,772.66 1,283,327.02 740,889.37 721,366.37 70.29%
Percent
Project Expenditures Funds Expended/
Budget To Date Encumbrances RemaininQ Encumbered
1,076,348.30 1,076,348.30 - - 100.00%
303,862.44 303,862.44 - - 100.00°/a
309,120.84 309,120.84 - 0.00 100.00%
25,000.00 - - 25,000.00 0.00%
214,554.57 22,199.74 - 192,354.83 10.35%
75,000.00 43,863.84 26,27618 4,859.98 58.49%
125,000.00 5,593.75 - ll9,406.25 4.48%
150,000.00 - 5,000.00 145,000.00 0.00%
2,278,886.15 1,760,988.91 31,276.18 486,621.06 77.27%
Percent
Project Expenditures Funds Expended/
BudQet To Date Encumbrances Remainine Encumbered
C4606 Collier Creek lmprovements (DEP GRANT $500,000) CLOSED 4,920,862.11 4,920,86211 - (0.00) 100.00%
P0003 1/4 Round Swale Rehab (DST) - CLOSED 2,651,170.28 2,651,170.28 - - ]00.00%
C1601 Stormwater Master Plan CLOSED 27,500.00 27,500.00 - - 100.00%
15,199,064.78 7,599,532.39 3.00 3.00 100.00%
AIRPORT PROJECTS
FUND 455
Project
Number Description
C0951 Construct Hangars (1,160,000 grant) CLOSED
C1152 Install Security Carueras
Percent
Project Expenditures Funds Expended/
Budget To Date Encumbrances Remainin� Encumbered
1,317,196.63 1,317,196.63 - - 100.00°/a
43,000.00 216.49 - 42,783.51 0.50%
1,317,196.63 1,317,196.63 - - 0.00%