HomeMy WebLinkAbout11-12-FY 2nd QuarterRESOLUTION NO. R-12-15
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, an analysis of the revenues and expenditures for the three (3) months ended March 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
Gillmor
Coy and, upon being put to a vote, the vote
aye
aye
aye
aye
absent
The Mayor thereupon declared this Resolution duly passed and adopted this 23`d day of May 2012.
ATTEST:
,
Sa y A. io, MMC
City Cl rk
CITY OF SE f1ST N, FLORIDA
i
a
By: __ _
M or Jim H` 1
Approved as to form and content for
reliance the City of Sebastian only:
r�1%���
R bert A. Ginsburg,
City Attorney
.
FUND TITLE
CENERAL
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 FORFEITURE
Revenues
Expenditures
DST DEBT SERVICE F'UND
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 2nd QUARTER BUDGET AFTER
ADJUSTMENTS ADJUSTMENTS ADJUSTMENTS
$ 9,925,315 $ - $ 9,925,315
9,925,315 - 9,925,315
648,5] ] - 648,51 I
648,511 - 648,511
2,907,103 (127,432) 2,779,671
2,907,103 (127,432) 2,779,671
286,616 - 286,616
286,616 - 286,616
13,800 - 13,800
13,800 - 13,800
448,886 (111) 448,775
448,886 (111) 448,775
938,623 151,076 1,089,699
938,623 151,076 1,089,699
10,125 - 10,125
10,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 I 0,475 447,124
436,649 10,475 447,124
413,059 - 413,059
413,059 - 413,059
$ 18,796,896 $ 34,008 $ 18,830,904
Description
GENERAL FUND SUMMARY
TAXES
LICENSES 8� PERMITS
INTERGOVERNMENTALREVENUES
CHARGES FOR SERVICES
FINES AND FORFEITS
MISCELLANEOUS REVENUES
TRANSFER FROM OTHER FUNDS
TOTALREVENUES
BEGINNING CASH RESERVES
TOTAL SOURCES
CITY COUNCIL
CITY MANAGER
CITY CLERK
LEGAL
ADMINISTRATIVE SERVICES
POLICE DEPARTMENT
PUBLIC WORKS
GROWTH MANAGEMENT
NON-DEPARTMENTAL
TOTAL EXPENDITURES
ENDING CASH RESERVES
TOTAL USES
CITY OF SEBASTIAN, FLORIDA
COMPARISON OF ACTUAL TO BUDGET
END OF 2ND QUARTER
FISCAL YEARS 2010, 2011 AND 2012
FY2010 FY2011 FY 2012
2nd Qtr YTD BUDGET %a 2nd Qtr YTD BUDGET % 2nd Qtr YTD BUDGET %a
4,824,326 7,531,430 64.1% 4,201,952 7,179,708 58.5%
16,813 51,400 32.7% 12,425 44,650 27.8%
813,304 1,723,105 47.2% 770,955 1,836,540 42.0%
151,601 289,147 52.4% 134,576 286,550 47.0%
34,484 55,000 62.7% 37,323 65,500 57.0%
106, 343 423,190 25.1 % 109, 813 338,124 32.5%
382,444 848,909 45.1% 368,363 753,759 48.9%
6,329,315 10,922,181 57.9% 5,635,407 10,504,831 53.6%
5,534,856 6,131,749 90.3% 4,962,399 5,068,245 97.9%
11,864,171 17,053,930 69.6% 10,597,806 15,573,076 68.1%
22,277 52,117 42.7%
116,187 254,480 45.7%
154,065 296,444 52.0%
50,925 125,340 40.6%
361,062 759,571 47.5%
2,214,526 4,675,788 47.4%
1,670,847 3,694,008 45.2%
175,469 437,156 40.1 %
491,362 627,277 78.3%
5,256,720 10,922,181 48.1 %
6,803,879 6,131,749 111.0%
11,864,171 17,053,930 69.6%
21,584 49,708 43.4%
104,272 234,642 44.4%
128,773 272,792 47.2%
48,917 125,785 38.9%
360,555 727,470 49.6%
2,209,726 4,807,989 46.0%
1,451,630 3,385,604 42.9%
165,923 348,734 47.6%
381,681 552,107 69.1 %
4, 873, 061 10, 504, 831 46.4%
5,724,745 5,068,245 113.0%
10,597,806 15,573,076 68.1%
3,888,945 6,684,535 58.2%
13,226 36,150 36.6%
800,481 1,880,400 42.6%
145,027 284,603 51.0%
31,378 74,000 42.4%
90,058 276,498 32.6%
345, 569 689,129 50.1 %
5,314,684 9,925,315 53.5%
4,733,552 4,711,377 100.5%
10,048,236 14,636,692 68.7%
22,836 50,283 45.4%
108,977 234,046 46.6%
165,432 304,390 54.3%
48,855 107,710 45.4%
344,339 637,994 54.0%
2,174,171 4,429,395 49.1 %
1,504,454 3,215,690 46.8%
116, 978 248,150 47.1 %
446,648 697,657 64.0%
4,932,690 9,925,315 49.7%
5,115,546 4,711,377 108.6%
10,048,236 14,636,692 68.7%
Property tax collections during the second quarter are lower than last year, as a result of 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 of
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.
Spending by all the Departments are all within the 50°/a of budget (one-half of the fiscal year) except the City Clerk, Administrative Services and Non-
Departmental. City Clerk is higner due to election costs and annual equipment maintenance contract payments. Administrative Services is slightly
higher because of the payment for the annual audit. The Non-departmental category is over 50% of budget because the City's total annual
contribution to the CRA Fund was made in the first quarter.
LOCAL OPTION GAS TAX FUND
TOTAL REVENUES 2,715,729 3,167,006 85.8% 236,584 623,521 37.9% 239,715 598,253 40.1%
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 2,798,583 3,319,565 84.3% 1,629,239 2,025,064 80.5% 298,277 648,511 46.0%
DEBT SERVICE 1,180,439 1,180,439 100.0% 132,207 264,463 50.0% 132,783 265,792 50.0%
OTHER EXPENDITURES 188,118 324,100 5$•�°�a 155,415 250,000 62•2% 148,595 257,719 57.7%
TRANSFERS TO OTHER FUNDS 1,250,461 �•�°�a 949.586 1,461,429 65.0% 62,500 125,000 50.0%
TOTAL EXPENDITURES 1,368,557 2,755,000 49.7% 1,237,208 1,975,892 62.6% 343,878 648,511 53.0%
ENDING CASH RESERVES 1,430,026 564,565 253.3% 392,031 49,172 797.3% (45 601) - 0.0%
TOTAL USES 2,798,583 3,319,565 84.3% 1,629,239 2,025,064 80.5% 298,277 648,511 46.0%
Refinancing the Paving Loan provided funds for additional paving work and lowered the annual debt service requirement. 2011 actual beginning
cash reserves included the amount of loan proceeds that had not been expended by the end of last fiscal year. 2nd Quarter Year-to-Date Revenue
reflects just five monthly payments, due to accruals.
DISCRETIONARY SALES TAX FUND
TOTAL REVENUES 982,322 2,510,445 39.1% 979,159 2,349,593 41.7% 1,015,170 2,380,150 42.7%
BEGINNING CASH RESERVES 1,404,945 1,904,156 73.8% 1,329,570 1,292,080 102.9% 1,623,442 1,292,080 125.6%
TOTAL SOURCES 2,387,267 4,414,601 54.1% 2,308,729 3,641,673 63.4% 2,638,612 3,672,230 71.9°/a
TRANSFERS TO OTHER FUNDS 1,120,494 3,673,830 30.5% 909,191 2,728,324 33.3% 1,418,280 2,779,671 51.0%
TOTAL EXPENDITURES 1,120,494 3,673,830 30.5% 909,191 2,728,324 33.3% 1,418,280 2,779,671 51.0%
ENDING CASH RESERVES 1,266,773 740,771 171.0% 1,399,538 913,349 153.2% 1,220,332 892,559 136.7%
TOTAL USES 2,387,267 4,414,601 54.1% 2,308,729 3,641,673 63.4% 2,638,612 3,672,230 71.9%
2nd quarter revenue reflects just five months payments, because the October payment for September collections was accounted for in 2011. 2011
Projects, including Power Line Road and Excavation Equipment, that were carried forward to 2012 are the reasons Beginning Cash Reserves were
higher than estimated.
CITY OF SEBASTIAN, FLORIDA
COMPARISON OF ACTUAL TO BUDGET
END OF 2ND QUARTER
FISCAL YEARS 2010, 2011 AND 2012
FY2010 FY2011
Description n tr o n tr o
RIVERFRONT REDEVELOPMENT FUND
TOTAL REVENUES 431,689 440,535 98.0% 299,070 300,382 99.6%
BEGINNING CASH RESERVES 984,638 638,242 154.3% 682,591 676,714 100.9%
TOTAL SOURCES 1,416,327 1,078,777 131.3% 981,661 977,096 100.5%
OPERATING EXPENDITURES 57,068 168,100 33.9% 107,778 120,727 89.3%
TRANSFERS TO OTHER FUNDS 38,301 60,000 63.8% 197,235 382,494 51.6%
TOTAL EXPENDITURES 4. 0 5, . o
ENDING CASH RESERVES 1,320,958 850,677 155.3% 676,648 473,875 142.8%
TOTAL USES 1,416,327 1,078,777 131.3% 981,661 977,096 100.5%
Funds paid by the City and County are included in the second quarter year-to-date revenues.
FY 2012
0 0
256,232 263,716 97.2%
455,810 498,934 91.4%
712,042 762,650 93.4%
82,253 126,616 65.0%
32,841 160,000 20.5%
5, 4 4 . o
596,948 476,034 125.4%
712,042 762,650 93.4%
PARKING IN-LIEU-OF FUND
TOTAL REVENUES - - 0.0% - - 0.0% 6,909 13,800 50.1%
BEGINNING CASH RESERVES - - 0.0% - - 0.0% 12,632 - 0.0%
TOTAL SOURCES - - . o - - . o . o
EXPENDITURES - - 0.0% - - 0.0% - - 0.0%
ENDING CASH RESERVES - - 0.0% - - 0.0% 19,541 13,800 141.6%
TOTAL USES - - . o - - . o . o
This Fund records collections of the parking in-lieu-of fee and any subsequent spending of those monies.
RECREATION IMPACT FEE FUND
TOTAL REVENUES 20,673 56,247 36.8% 13,722 30,791 44.6% 27,392 28,500 96.1%
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,116,158 940,711 118.7% 1,120,032 1,029,617 108.8% 875,579 465,231 188.2%
TRANSFERS TO OTHER FUNDS 16,586 251,246 6.6% 57,254 620,519 9.2% 89,755 448,775 20.0%
TOTAL EXPENDITURES 16,586 251,246 6.6% 57,254 620,519 9.2% 89,755 448,775 20.0%
ENDING CASH RESERVES 1,099,572 689,465 159.5% 1,062,778 409,098 259.8% 785,824 16,456 4775.3%
TOTAL USES 1,116,158 940,711 118.7% 1,120,032 1,029,617 108.8% 875,579 465,231 188.2%
Several projects were underway and needed to be carried forward to 2012, resulting in Beginnning Cash Reserves being higher than estimated.
STORMWATER UTILTY FUND
TOTAL REVENUES 713,877 877,344 81.4% 693,837 843,200 82.3% 683,597 818,450 83.5%
BEGINNING CASH RESERVES 795,650 651,397 122.1% 588,841 601,040 98.0% 450,156 316,537 142.2%
TOTAL SOURCES 1,509,527 1,528,741 98.7% 1,282,678 1,444,240 88.8% 1,133,753 1,134,987 99.9%
OTHER EXPENDITURES - 100 0.0% - 100 0.0% - 100 0.0%
TRANSFERS TO OTHER FUNDS 535,754 1,020,454 52.5% 469,439 1,138,877 41.2% 620,338 1,089,599 56.9%
TOTAL EXPENDITURES 535,754 1,020,554 52.5% 469,439 1,138,977 41.2% 620,338 1,089,699 56.9%
ENDING CASH RESERVES 973,773 508,187 191.6% 813,239 305,263 266.4% 513,415 45,288 1133.7%
TOTAL USES 1,509,527 1,528,741 98.7% 1,282,678 1,444,240 88.8% 1,133,753 1,134,987 99.9%
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 6,099 10,200 59.8% 881 10,250 8.6% 85 10,125 0.8%
BEGINNING CASH RESERVES 54,018 20,970 257.6% 73,160 52,609 139.1% 66,585 80,062 83.2%
TOTAL SOURCES 60,117 31,170 192.9% 74,041 62,859 117.8% 66,670 90,187 73.9%
EXPENDITURES 4,079 - 0.0% 1,260 - 0.0% - - 0.0%
ENDING CASH RESERVES 56,038 31,170 179.8% 72,781 62,859 115.8% 66,670 90,187 73.9%
TOTAL USES 60,117 31,170 192.9% 74,041 62,859 117.8% 66,670 90,187 73.9%
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 FUND� 517,932 1,035,869 50.0% 498,778 997,557 50.0% 498,696 999,933 49.9%
MISC. REVENUES 1,287 1,000 128.7% 2,166 22,854 9.5% 5,759 22,400 25.7%
TOTAL REVENUES 519,219 1,036,869 50.1% 500,944 1,020,411 49.1% 504,455 1,022,333 49.3%
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%
TOTALSOURCES 1,928,712 1,251,227 154.1% 2,055,598 2,561,988 80.2% 2,061,032 2,564,742 80.4%
OPERATING EXPENDITURES 675 300 225.0% 675 300 225.0% 300 300 100.0%
DEBTSERVICE 889,947 1,036,569 85.9% 897,841 1,019,279 88.1% 915,138 1,022,033 89.5%
TOTAL EXPENDITURES 890,622 1,036,869 85.9% 898,516 1,019,579 88.1% 915,438 1,022,333 89.5%
ENDING CASH RESERVES 1,038,090 214,358 484.3% 1,157,082 1,542,409 75.0% 1,145,594 1,542,409 74.3%
TOTAL USES 1,928,712 1,251,227 154.1% 2,055,598 2,561,988 80.2% 2,061,032 2,564,742 80.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
Description
CITY OF SEBASTIAN, FLORIDA
COMPARISON OF ACTUAL TO BUDGET
END OF 2ND QUARTER
FISCAL YEARS 2010, 2011 AND 2012
FY2010 FY2011 FY 2012
n tr a n tr o o a
STORMWATER UTILITY BOND FUND
TRANSFER FROM OTHER FUND�
MISC. REVENUES
TOTALREVENUES
BEGINNING CASH RESERVES
TOTAL SOURCES
DEBT SERVICE
TOTAL EXPENDITURES
ENDING CASH RESERVES
TOTAL USES
219,120 438,240 50.0%
310 120 258.3%
219,430 438,360 50.1%
144,635 20,686 699.2%
364,065 459,046 79.3%
89,118 438,360 20.3%
89,118 438,360 20.3%
274,948 20,686 1329.1%
364,065 459,046 79.3%
219,439 438,877 50.0%
110 1,122 9.8%
219,549 439,999 49.9%
182, 951 182, 932 100.0%
402,500 622,931 64.6%
84,893 439,911 19.3%
84,893 439,911 19.3%
317, 607 183, 020 173. 5%
402,500 622,931 64.6%
Debt service to date includes the payments of principal and interest on the bonds.
GOLF COURSE FUND
CHARGES FOR SERVICE
MISC. REVENUES
TOTALREVENUES
BEGINNING CASH RESERVES
TOTAL SOURCES
PERSONAL SERVICES
OPERATING EXPENSES
CAPITAL OUTLAY
DEBT SERVICE
TOTAL EXPENDITURES
ENDING CASH RESERVES
TOTAL USES
841,700 1,483,200 56.7% 860,328 1,261,474 68.2%
20,586 112,713 18.3% 16,614 36,410 45.6%
862,286 1,595,913 54.0% 876,942 1,297,884 67.6%
(67,076) 764,318 -8.8% (335,947) (367,001) 91.5%
795,210 2,360,231 33.7% 540,995 930,883 58.1%
155,059 350,023 44.3%
464,645 922,790 50.4%
- 10,000 0.0°/a
7,375 313,100 2.4%
627,079 1,595,913 39.3%
168,131 764,318 22.0%
795,210 2,360,231 33.7%
151,134 340, 270 44.4%
463,846 956,539 48.5%
- - 0.0%
- 1,075 0.0%
614,980 1,297,884 47.4%
(73,985) (367,001) 20.2%
540,995 930,883 58.1%
219,261 439,023 49.9%
92 1,100 8.4%
219,353 440,123 49.8%
183, 020 183, 020 100.0%
402,373 623,143 64.6%
79,999 440,123 18.2%
79,999 440,123 18.2%
322, 374 183, 020 176.1 %
402,373 623,143 64.6%
903,172 1,270,793 71.1 %
26,777 34,960 76.6%
929,949 1,305,753 71.2%
(216,241) (249,485) 86.7%
713,708 1,056,268 67.6%
137,034 278,843 49.1%
501,407 999,410 50.2%
- 27,500 0.0%
- - 0.0%
638,441 1,305,753 48.9%
75,267 (249,485) -30.2%
713,708 1,056,268 67.6%
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 at the end 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. Revenues appear strong compared to prior years and expenses are just less than 50%.
AIRPORT FUND
LEASE REVENUES 186,945 371,219 50.4% 189,131 345,855 54.7% 203,876 409,116 49.8%
MISC. REVENUES 31,148 17,000 183.2% 6,296 49,215 12.8% 8,152 38,008 21.4%
TOTAL REVENUES 218,093 388,219 56.2% 195,427 395,070 49.5% 212,028 447,124 47.4%
BEGINNING CASH RESERVES (51,665) 65,784 -78.5% (57,243) (96,942) 59.0% (66,889) (57,243) 116.9%
TOTAL SOURCES 166,428 454,003 36.7% 138,184 298,128 46.4% 145,139 389,881 37.2%
PERSONAL SERVICES 109,895 231,369 47.5% 104,233 230,275 45.3% 115,616 236,970 48.8%
OPERATING EXPENSES 94,768 148,300 63.9% 88,370 156,245 56.6% 103,355 192,904 53.6%
CAPITAL OUTLAY 8,105 - 0.0% - - 0.0% 3,500 - 0.0%
DEBT SERVICE 8,550 8,550 100.0% 8,550 8,550 100.0% - 17,250 0.0%
TOTAL EXPENDITURES 221,318 388,219 57.0% 201,153 395,070 50.9% 222,471 447,124 49.8%
ENDING CASH RESERVES (54,890) 65,784 -83.4% (62,969) (96,942) 65.0% (77,332) (57,243) 135.1%
TOTAL USES 166,428 454,003 36.7% 138,184 298,128 46.4% 145,139 389,881 37.2%
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
TOTALREVENUES
BEGINNING CASH RESERVES
TOTAL SOURCES
PERSONAL SERVICES
OPERATING EXPENSES
TOTAL EXPENDITURES
ENDING CASH RESERVES
TOTAL USES
217,011 372,250 58.3%
651,126 779,429 83.5%
868,137 1,151,679 75.4%
180,462 379,674 47.5%
60,209 109,660 54.9%
240,671 489,334 49.2%
627,466 662,345 94.7%
868,137 1,151,679 75.4°/a
233,531 355,650 65.7%
554,519 504,899 109.8%
788,050 860,549 91.6%
178,298 367,626 48.5%
55,942 98,114 57.0%
234,240 465,740 50.3%
553,810 394,809 140.3%
788,050 860,549 91.6%
241, 629 389,150 62.1 %
460,448 431,386 106.7%
702,077 820,536 85.6%
152,891 322,000 47.5%
44,999 91,059 49.4%
197,890 413,059 47.9%
504,187 407,477 123.7%
702,077 820,536 85.6%
Ending Cash Reserves have steadily declined due to the economic slump. However, Beginning Cash Reserves for 2012 were slightly higher than
anticipated.
Description
CITY OF SEBASTIAN, FLORIDA
COMPARISON OF ACTUAL TO BUDGET
END OF 2ND QUARTER
FISCAL YEARS 2010, 20l 1 AND 2012
FY2010 FY2011 FY 2012
2nd Qtr YTD BUDGET % 2nd Qtr YT� BUDGET % % 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
Capital Outlay
Totals
POLICE DEPARTMENT
Personnel
Operating
Capital Outlay
Totals
PUBLIC WORKS
Personnel
Operating
Capital Outlay
Totals
GROWTH MANAGEMENT
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
11,390 22,742 50.1% 11,382 22,761 50.0% 11,381 22,747 50.0%
10,887 29,375 37.1% 10,202 26,947 37.9% 11,455 27,536 41.6%
22,277 52,117 42.7% 21,584 49,708 43.4% 22,836 50,283 45.4%
113,547 250,455 45.3% 103,280 229,734 45.0% 107,654 230,746 46.7%
2,640 4,025 65.6% 992 4,908 20.2% 1,323 3,300 40.1%
116,187 254,480 45.7% 104,272 234,642 44.4% 108,977 234,046 46.6%
109,870 240,794 45.6% 108,074 243,373 44.4% 119,331 249,468 47.8%
44,195 55,650 79.4% 20,699 29,419 70.4% 46,101 54,922 83.9%
154,065 296,444 52.0% 128,773 272,792 47.2% 165,432 304,390 54.3%
0 0 0.0% 0 0 0.0% 0 0 0.0%
50,925 125,340 40.6% 48,917 125,785 38.9% 48,855 107,710 45.4%
50,925 125,340 40.6% 48,917 125,785 38.9% 48,855 107,710 45.4%
275,633 615,794 44.8% 270,896 601,230 45.1% 249,532 516,060 48.4%
84,129 112,454 74.8% 89,659 121,240 74.0% 90,629 109,805 82.5%
1,300 31,323 4.2% 0 5,000 0.0% 4,178 12,129 34.4%
361,062 759,571 47.5% 360,555 727,470 49.6% 344,339 637,994 54.0%
1,987,317 4,250,025 46.8% 1,956,680 4,381,821 44.7% 1,950,505 3,996,037 48.8%
196,428 398,892 49.2% 222,009 389,533 57.0% 220,289 433,358 50.8%
30,781 26,871 114.6% 31,037 36,635 84.7% 3,377 0 0.0%
2,214,526 4,675,788 47.4% 2,209,726 4,807,989 46.0% 2,174,171 4,429,395 49.1%
1,185,833 2,563,799 46.3% 1,015,071 2,348,344 43.2% 1,046,438 2,160,971 48.4%
468,967 1,116,609 42.0% 435,129 1,024,460 42.5% 437,531 1,033,519 42.3%
16,047 13,600 118.0% 1,430 12,800 11.2% 20,485 21,200 96.6%
1,670,847 3,694,008 45.2% 1,451,630 3,385,604 42.9% 1,504,454 3,215,690 46.8%
168,591 372,436 45.3% 142,349 312,127 45.6% 107,568 227,698 47.2%
6,878 64,720 10.6% 23,574 36,607 64.4% 9,410 20,452 46.0%
175,469 437,156 40.1% 165,923 348,734 47.6% 116,978 248,150 47.1%
11,095 15,000 74.0% 8,154 15,000 54.4% 80,717 139,436 57.9%
480,267 612,277 78.4% 373,527 537,107 69.5% 365,931 497,221 73.6%
0 0 0.0% 0 0 0.0% 0 61,000 0.0%
491,362 627,277 78.3% 381,681 552,107 69.1% 446,648 697,657 64.0%
3,863,276 8,331,045 46.4%
1,148,888 2,519,342 45.6%
48,128 71, 794 67.0%
0 0 0.0%
5,060,292 10,922,181 46.3%
6,803,879 6,131,749 111.0%
11,864,171 17,053,930 69.6%
4
3,615,886 8,154,390 44.3%
1,224,708 2,296,006 53.3%
32,467 54,435 59.6%
0 0 0.0%
4, 873, 061 10, 504, 831 46.4%
5,724,745 5,068,245 113.0%
10,597,806 15,573,076 68.1 %
3,673,126 7,543,163 48.7%
1,231,524 2,287,823 53.8%
28,040 33, 329 84.1 %
0 61,000 0.0%
4,932,690 9,925,315 49.7%
5,115,546 4,711,377 108.6%
10,048,236 14,636,692 68.7%
GENERAL CAPITAL PROJECTS
FUND 310
Project
Number DescriQion
C 1108 Excavation Equipment (CLOSED)
C 1109 Telephone System
A1210 Garage Equipment
AI211 Repaint City Hall/PD
A1212 Police Vehicle Replacement
CAPITAL IMPROVEMENT PROJECTS
FUND 320
Project
Number Description
C0721
C0921
C1122
C1123
C1124
C1125
C1126
C1129
A1221
A1222
A1223
A 1224
A1225
A1226
A1227
CAPITAL PROJECT STATUS REPORT
3/31/2012
Hardee Park Lnprovement (Zone A)
Schumann Park Improvements
Riverview Park Pavilion (Schumann Park)
Bark Park Amenties
Lift Station - Riverview Park
Riverview Park Irrigation Fountains
Presidental Streets
Easy St Park Improvements
Mooring Fields
Blueway Signage
Bleacher Shields
Creative Playground
Handicapp Pier
Riverview Park Electrical (Closed)
Four Chaplains Memorial Sidewalk/Landscape
TRANSPORTATION CAPITAL PROJECTS
FUND 330
Project
Number Description
C0735 Powerline Road
C0834 512 Corridor (DST - FDOT Grant)-CLOSED
C 1131 US 1 Improvements - CLOSED
C 1132 Gateway Enhancement
P0001 Road Paving
A1231 Cav Corp Enhancements
STORMWATER IMPROVEMENT FUND
FUND 363
Project
Number Description
Percent
Project Expenditures Funds Expended/
Budaet To Date Encumbrances Remainine Encumbered
166,053.62 166,053.62 - - 100.00%
63,644.00 16,584.37 47,862.57 (802.94) 101.26%
23,000.00 4,347.00 13,297.00 5,356.00 76.71%
33,000.00 - - 33,000.00 0.00%
182,871.00 167,982.25 - 14,888.75 91.86%
468,568.62 354,967.24 61,159.57 52,441.81 75.76%
Percent
Project Expenditures Funds Expended/
BudQet To Date Encumbrances RemaininQ Encumbered
50,000.00 47,432.01 - 2,567.99 94.86%
246,460.00 149,614.61 23,514.12 73,331.27 70.25%
30,680.00 28,720.71 - 1,959.29 93.61%
75,000.00 1,450.00 - �3,550.00 1.93%
99,683.00 62,862.49 - 36,820.51 63.06%
25,000.00 8,261.52 - 16,738.48 33.05%
473,500.00 33,179.44 - 440,320.56 7.01%
63,000.00 51,058.42 3,308.50 8,633.08 86.30%
15,000.00 - - 15,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%
15,000.00 - - 15,000.00 0.00%
7,389.16 7,389.16 - - 100.00%
20,000.00 - 2,018.87 17,981.13 10.09%
1,225,712.16 389,968.36 28,841.49 806,90231 31.82%
Percent
Project Expenditures Funds Expended/
Bud¢et To Date Encumbrances RemaininQ Encumbered
1,198,338.00 1,074,39830 1,425.00 122,514.70 89.78%
303,862.44 303,862.44 - - 100.00%
309,120.84 309,120.84 - 0.00 100.00%
25,000.00 - - 25,000.00 0.00%
39,554.57 13,749.50 - 25,805.07 34.76%
75,000.00 2,246.96 67,893.06 4,859.98 93.52%
1,950,875.85 1,703,378.04 69,3]8.06 178,179.75 87.31%
Percent
Project Expenditures Funds Expended/
Budeet To Date Encumbrances Remainine Encumbered
C4606 Collier Creek Improvements (DEP GRANT $500,000) 4,925,102. ll 4,917,877.11 9,225.00 (2,000.00) 100.04%
P0003 1/4 Round Swale Rehab (DST) 2,647,720.00 2,505,927.10 22,365.20 119,427J0 95.49%
C1601 Stormwater Master Plan 50,000.00 27,500.00 - 22,500.00 55.00%
A1261 BBSC Baseball Field Drainage 50,000.00 - - 50,000.00 0.00%
15,124,126.32 7,672,82211 221,520.39 189,930.19 97.11%
AIRPORT PROJECTS
FUND 455
Percent
Project Project Expenditures Funds Expended/
Number Description Budeet To Date Encumbrances Remainine Encumbered
C0951 Construct Hangars (1,160,000 grant) 1,450,000.00 1,313,083.81 7,802.82 129,11337 9110%
C1152 Install Securiry Cameras 43,000.00 - - 43,000.00 0.00%
1,450,000.00 1,313,083.81 7,802.82 129,113.37 0.00%