HomeMy WebLinkAbout12-13-FY 1st QuarterEXHIBIT "A" of RESOLUTION R-13-05
SUMMARYOFBUDGETCHANGES
FOR THE QUARTE-R ENDED DECEMBER 31,2012
Amounts
Changes Authorized by City Manager:
Established budgets in the Capital Projects Funds for new approved projects. $3,473,888
Set aside amount of prior year savings on Health Reimbursement Account. $ 28,481
Transfer classification of approved MIS item to the proper account code. $ 5,000
Transfer from City Council travel account to computer supplies for !-Pads. $ 800
Adjustment for Golf Course for equipment and P&l payments on Bank Loan. $ 78,436
Additional Changes Submitted for City Council Approval:
No changes are submitted at this time.
48 of 80
CITY OF
HOME OF PELICAN ISLAND
QUARTERLY FINANCIAL REPORT
FOR THE QUARTER ENDED
DECEMBER 31, 2012
Prepared by
Administrative Services Department
49 of 80
GENERAL FUND
CITY OF SEBASTIAN
QUARTERLY FINANCIAL REPORT
EXECUTIVE SUMMARY
The graph below and left compares General Fund Revenues, Expenditures and Total Reserves (Committed and Uncommitted Reserves) at the end of
the current quarter to the end of the prior fiscal year. Most property tax payments are received the first quarter, so the Reserves balances are at a high
point of the year. The graph below and right compares the first quarter of the current year to the first quarter of the prior two years. Revenues and
amounts Expended appear in line with prior years' first quarters and Reserves are at expected levels.
The graph below and left shows collections through the first quarter of the three main sources of General Fund Revenue and of those three as a total.
Those three sources and property taxes are 68% of all budgeted revenue. About $28,000 of additional revenue above budget is projected from those
three sources. The graph below and right shows the percentage of budgeted expenditures by the end of the first quarter. The City Clerk's office is at
25.7% of budget due to annual renewals of equipment maintenance contracts and election costs. Non-Departmental is high due to the full transfer of the
City's CRA contribution.
4,000,000
3,500,000
3,000,000
2,500,000
2,000,000
1,500,000
1,000,000
500,000
0
1st Qtr 2012 1st Qtr 2013 2013 Budget 2013 Projection
joEiectric Franchise •Electric Utility Tax •Ha~-cent Sales Tax DTotals of the Three I
SPECIAL REVENUE FUNDS AND CAPITAL PROJECTS
50.0% !
45.0%
-40.0% -I
35.0%
30.0%
25.0%
20.0% f.-' 1--,..
15.0%V 1-1--
100% f.-' f-f-
-,
5.0% f.-' f-f-
I
0.0% f-"' f-
_~,..
~;..1.1:.;;.
~-!.... ,.:
00u"<F-~1\'b~~~ C..,.~..._ ~o~"0~,.<:i..,~t~\<,'~ ~e_"'~o<:P .,~e"\<:-oa"'?J. c;~~ c;~~""' c; c;~'1 ""cil-" <;) ~"'". oe<! <?u'O''" ~~"~~ .. <;>~\'ll
'I' <?do'~ r:,<<S"-'S-~o<~'
For the most part, Special Revenue Funds provide the monies needed for capital projects. The graph below and left shows collections through the first
quarter of the current year to the first quarter of last year and shows the current annual budget and staffs projection for this year for Local Option Gas
Taxes (LOGT), Discretionary Sales Tax (DST) and Stormwater Fees. The graph below and right shows the total amounts budgeted this year for capital
projects, as compared to amounts spent through the end of the first quarter.
3,000,000
2,500,000
2,000,000
1,500,000
1,000,000
500,000
LOOT OST Stormwater Fee
jc1st Otr2012 81st Otr 2013 02013 Budget 82013 Projection I
Page I of2
50 of 80
CITY OF SEBASTIAN
QUARTERLY FINANCIAL REPORT
EXECUTIVE SUMMARY (CONTINUED)
DEBT SERVICE FUNDS AND LONG-TERM DEBT
The City's bonded debt is accounted for in the two Debt Service Funds. They are the Discretionary Sales Tax Bonds ($5,420,000 outstanding, maturing
4/01/18) and the Stormwater Revenue Bonds ($3,505,000 outstanding, maturing 5/01/22). The City also has a Bank Note for Street Repaving
($2,199,000 outstanding, maturing 12/01/22) and a Bank Note for Golf Course Equipment ($56,436 outstanding, maturing 12/06/15). The City is in
compliance with covenants and repayment requirements on all these obligations.
GOLF COURSE
The graph below and left compares Golf Course Revenues, Expenses and Reserves at the end of the current quarter to the end of the prior fiscal year.
The graph below and right compares Revenues, Expenses and Reserves for the first quarter of the current year to the first quarter of the prior two years.
We have seen a steady reduction in the negative amount of Reserves. Reserves are net of liabilities for accrued leave and advance payment of fees
(about $90,000).
AIRPORT
The graph below and left compares Airport Revenues. Expenses and Reserves at the end of the current quarter to the end of the prior fiscal year. The
graph below and right compares the first quarter of the current year to the first quarter of the prior two years. Reserves are net of liabilities for accrued
leave (about $63,000).
BUILDING
The graph below and left compares Building Department Revenues, Expenses and Reserves at the end of the current quarter to the end of the prior
fiscal year. The graph below and right compares the first quarter of the current year to the first quarter of the prior two years. First quarter Revenues are
higher than received in the first quarter for several years. Reserves are net of liabilities for accrued !~ave and advance payment of business taxes (about
$95,000).
Page 2 of2 51 of 80
CITY OF SEBASTIAN
FUND SUMMARIES
QUARTER ENDING 12/31/12
2009/2010 2010/2011 2011/2012 2012/2013 2012/2013 2012/2013
1STQTR 1STQTR 1STQTR 1STQTR ANNUAL PERCENT
ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET
GENERAL FUND
TAXES -3,432,196.27 -3,120,718.97 -2,835,606.83 -3,011,530.23 -6,466,854 46.57%
LICENSES & PERMITS -9,757.50 -3,841.00 -7,614.50 -8,042.50 -28,950 27.78%
INTERGVT'L REVENUE -283,429.80 -285,827.81 -295,506.46 -309,992.95 -1,919,700 16.15%
CHARGES FOR SERVICE -62,189.23 -66,987.16 -65,561.65 -83,885.43 -373,347 22.47%
FINES AND FORFEITS -16,871.27 -18,682.73 -12,509.54 -13,996.14 -70,500 19.85%
MISC. REVENUE -78,903.25 -49,252.24 -28,128.48 -73,301.77 -250,363 29.28%
TRANSFERS IN -191,221.98 -184,181.79 -171,750.03 -140,000.01 -565,399 24.76%
FROM FUND BALANCES 0.00 0.00 0.00 0.00 -28,481 0.00%
GENERAL FUND REVENUE -4,07 4,569.30 -3,729,491.70 -3,416,677.49 -3,640,749.03 -9,703,594 37.52%
CITY COUNCIL 10,708.40 10,950.31 11,008.48 12,336.50 51,717 23.85%
CITY MANAGER 58,548.69 50,784.15 50,718.63 49,174.15 233,387 21.07%
CITY CLERK 96,273.49 71,661.99 96,436.75 72,828.88 283,667 25.67%
LEGAL 16,641.97 16,016.56 17,743.65 17,097.48 102,360 16.70%
FINANCE/ACCOUNTING 117,659.00 115,061.00 112,016.96 111,738.56 478,561 23.35%
M.I.S. DIVISION 52,161.14 57,148.87 30,244.42 35,612.93 163,290 21.81%
POLICE DEPARTMENT 1,079,781.52 1 ,062,527.62 993,685.60 959,306.01 4,199,206 22.84%
PUBLIC WORKS 788,992.96 648,852.48 717,363.45 680,033.47 3,228,464 21.06%
GROWTH MANAGEMENT 85,260.23 77,280.49 51,731.35 51,453.82 242,980 21.18%
NON-DEPARTMENTAL 343,563.07 272,245.95 272,949.22 311,150.57 719,962 43.22%
GENERAL FUND EXPENDITURES 2,649,590.47 2,382,529.42 2,353,898.51 2,300, 732.37 9,703,594 23.71%
LOCAL OPTION GAS TAX
TAXES -98,503.81 -96,529.99 -92,673.09 -92,024.20 -560,000 16.43%
INTERGVT'L REVENUE 0.00 0.00 0.00 0.00 -9,474 0.00%
MISC. REVENUE -17.25 -710.19 -38.91 -91.76 -1,630 5.63%
LOGT FUND REVENUE -98,521.06 -97,240.18 -92,712.00 -92,115.96 -571,104 16.13%
OPERATING EXPENSES 52,866.23 48,577.63 51,548.03 48,393.25 208,000 23.27%
DEBT SERVICE 0.00 132,207.38 132,782.83 122,240.69 243,076 50.29%
TRANSFERS OUT 43,749.00 697,040.12 31,250.01 1,445.00 100,000 1.45%
TO FUND BALANCES 0.00 0.00 0.00 0.00 20,028 0.00%
LOGT FUND EXPENDITURES 96,615.23 877,825.13 215,580.87 172,078.94 571,104.00 30.13%
DISCRETIONARY SALES TAX
TAXES -326,840.88 -330,733.98 -331,630.14 -355,496.32 -2,414,900 14.72%
MISC. REVENUE -4,353.17 -439.12 -1,997.13 -1,164.56 -21,975 5.30%
TRANSFERS IN -222,000.10 0.00 0.00 0.00 0 0.00%
FROM FUND BALANCES 0.00 0.00 0.00 0.00 -308,746 0.00%
DST FUND REVENUE -553,194.15 -331,173.10 -333,627.27 -356,660.88 -2,745,621 12.99%
TRANSFERS OUT 579,710.50 464,274.59 518,876.00 468,063.67 2,745,621 17.05%
RIVERFRONT REDEVELOPMENT FUND
MISC. REVENUE -351.06 -1,296.84 -1,070.90 163.17 -3,064 -5.33%
TRANSFERS IN -430,035.67 -297,619.74 -255,068.85 -266,323.21 -264,809 100.57%
FROM FUND BALANCES 0.00 0.00 0.00 0.00 -192,167 0.00%
RRD REVENUE -430,386.73 -298,916.58 -256,139.75 -266,160.04 -460,040 57.86%
OPERATING EXPENSES 19,464.96 46,135.92 43,706.70 50,488.74 114,040 44.27%
GRANTS AND AIDS 0.00 24,413.02 0.00 0.00 36,000 0.00%
TRANSFERS OUT 17,266.27 26,800.47 15,000.00 18,353.60 310,000 5.92%
RRD EXPENDITURES 36,731.23 97,349.41 58,706.70 68,842.34 460,040 14.96%
Page 1 of 3 52 of 80
CITY OF SEBASTIAN
FUND SUMMARIES
QUARTER ENDING 12/31/12
2009/2010 2010/2011 2011/2012 2012/2013 2012/2013 2012/2013
1STQTR 1STQTR 1STQTR 1STQTR ANNUAL PERCENT
ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET
PARKING IN LIEU OF FUND
MISC. REVENUE 0.00 0.00 -3,451.95 -4,611.40 -13,850 33.30%
FROM FUND BALANCES 0.00 0.00 0.00 0.00 -26,482 0.00%
PARKING IN LIEU OF REVENUE 0.00 0.00 -3,451.95 -4,611.40 -40,332 11.43%
TO FUND BALANCES 0.00 0.00 0.00 0.00 40,332 0.00%
RECREATION IMPACT FEE FUND
MISC. REVENUE -5,878.28 -4,056.74 -16,772.60 -23,770.11 -41,535 57.23%
FROM FUND BALANCES 0.00 0.00 0.00 0.00 -288,465 0.00%
RECREATION IMPACT FEE REVENUE -5,878.28 -4,056.74 -16,772.60 -23,770.11 -330,000 7.20%
CAPITAL OUTLAY 0.00 0.00 0.00 2,517.41 0 0.00%
TRANSFERS OUT 1,555.57 13,536.13 28,281.78 98,318.00 330,000 29.79%
RECREATION IMPACT FEE EXPENSE 1,555.57 13,536.13 28,281.78 100,835.41 330,000 30.56%
STORMWATER UTILITY FUND
MISC. REVENUE -590,195.27 -608,723.14 -610,712.01 -772,446.64 -1,006,957 76.71%
FROM FUND BALANCES 0.00 0.00 0.00 0.00 -47,551 0.00%
STORMWATER FUND REVENUE -590,195.27 -608,723.14 -610,712.01 -772,446.64 -1,054,508 73.25%
OPERATING EXPENSES 0.00 0.00 0.00 5,416.70 45,100 12.01%
TRANSFERS OUT 234,561.00 234,719.28 385,706.86 234,852.00 1,009,408 23.27%
STORMWATER FUND EXPENSE 234,561.00 234,719.28 385,706.86 240,268.70 1,054,508 35.28%
LAW ENFORCE FORFEITURE FUND
FINES AND FORFEITS -627.00 -800.00 0.00 0.00 -8,000 0.00%
MISC. REVENUE -104.84 -40.40 -39.02 -45.33 -2,125 2.13%
LAW ENFORCE FORFEITURE REVENUE -731.84 -840.40 -39.02 -45.33 -10,125 0.45%
OPERATING EXPENSES 3,178.90 614.00 0.00 0.00 0 0.00%
CAPITAL OUTLAY 0.00 5,881.00 0.00 0.00 0 0.00%
TO FUND BALANCES 0.00 0.00 0.00 0.00 10,125 0.00%
LAW ENFORCE FORFEITURE EXPENSE 3,178.90 6,495.00 0.00 0.00 10,125 0.00%
DST SER 2003 DEBT SVC FUND
MISC. REVENUE -199.14 -459.87 -293.68 -1,212.41 -22,365 5.42%
TRANSFERS IN -258,966.00 -249,389.25 -249,347.76 -248,655.24 -994,621 25.00%
FROM FUND BALANCES 0.00 0.00 0.00 0.00 -1 '137 0.00%
DST SER 2003 REVENUE -259,165.14 -249,849.12 -249,641.44 -249,867.65 -1,018,123 24.54%
OPERATING EXPENSES 375.00 0.00 0.00 375.00 300 125.00%
DEBT SERVICE 0.00 0.00 375.00 0.00 1,017,823 0.00%
DST SER 2003 EXPENDITURE 375.00 0.00 375.00 375.00 1,018,123 0.04%
STORMWATER 2003 DEBT SERV FUND
MISC. REVENUE -4.50 -41.93 -66.41 -127.80 -1,056 12.10%
TRANSFERS IN -109,560.00 -109,719.27 -109,630.74 -109,851.99 -439,408 25.00%
STORMWATER DEBT FUND REVENUE -109,564.50 -109,761.20 -109,697.15 -109,979.79 -440,464 24.97%
DEBT SERVICE 89,117.50 84,892.50 79,998.75 74,398.75 439,048 16.95%
TO FUND BALANCES 0.00 0.00 0.00 0.00 1,416 0.00%
STORMWATER DEBT EXPENDITURES 89,117.50 84,892.50 79,998.75 74,398.75 440,464 16.89%
Page 2 of 3 53 of 80
CITY OF SEBASTIAN
FUND SUMMARIES
QUARTER ENDING 12/31/12
2009/2010 2010/2011 2011/2012 2012/2013 2012/2013 2012/2013
1ST QTR 1STQTR 1STQTR 1STQTR ANNUAL PERCENT
ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET
GOLF COURSE FUND
CHARGES FOR SERVICE -374,168.03 -351,816.33 -348,485.80 -349,888.38 -1,357,775 25.77%
MISC. REVENUE -8,617.00 -7,325.59 -8,180.51 -65,146.05 -91,396 71.28%
GOLF COURSE FUND REVENUE -382,785.03 -359,141.92 -356,666.31 -415,034.43 -1,456,671 28.49%
PERSONAL SERVICES 58,357.68 58,588.09 44,634.82 45,307.21 218,529 20.73%
OPERATING EXPENSES 44,665.01 74,089.48 88,024.26 82,338.97 340,652 24.17%
DEBT SERVICE 1,075.00 0.00 0.00 0.00 0 0.00%
TRANSFERS OUT 0.00 0.00 0.00 16,852.50 65,000 25.93%
TO FUND BALANCES 0.00 0.00 0.00 0.00 27,457 0.00%
ADMINISTRATION 104,097.69 132,677.57 132,659.08 144,498.68 651,638 22.17%
OPERATING EXPENSES 140,075.52 133,939.83 134,828.62 141,059.16 583,185 24.19%
CAPITAL OUTLAY -10,000.00 0.00 0.00 1,107.00 56,436 1.96%
DEBT SERVICE 0.00 0.00 0.00 514.93 15,638 3.29%
MAINTENANCE 130,075.52 133,939.83 134,828.62 142,681.09 662,759 21.53%
PERSONAL SERVICES 17,075.36 16,256.81 15,145.82 14,456.87 77,089 18.75%
OPERATING EXPENSES 24,161.06 15,865.61 20,985.74 16,555.03 65,185 25.40%
GOLF COURSE CARTS 41,236.42 32,122.42 36,131.56 31,011.90 142,274 21.80%
GOLF COURSE FUND EXPENSES 275,409.63 298,739.82 303,619.26 318,191.67 1,456,671 21.84%
AIRPORT
CHARGES FOR SERVICE -4,081.39 -2,905.99 -3,417.49 -9,842.52 -25,000 39.37%
MISC. REVENUE -67,731.68 -90,787.99 -88,544.42 -108,871.66 -413,319 26.34%
FROM FUND BALANCES 0.00 0.00 0.00 0.00 -7,309 0.00%
AIRPORT REVENUE -71,813.07 -93,693.98 -91,961.91 -118,714.18 -445,628 26.64%
ADMINISTRATION
PERSONAL SERVICES 55,404.93 51,689.35 52,242.50 42,981.39 176,456 24.36%
OPERATING EXPENSES 72,539.36 49,186.30 60,178.25 63,748.73 232,597 27.41%
CAPITAL OUTLAY 0.00 0.00 0.00 1 '168.00 0 0.00%
DEBT SERVICE 0.00 0.00 0.00 0.00 16,575 0.00%
ADMINISTRATION 127,944.29 100,875.65 112,420.75 107,898.12 425,628 25.35%
ECONOMIC DEVELOPMENT
OPERATING EXPENSES 0.00 0.00 0.00 719.48 20,000 3.60%
AIRPORT EXPENSE 127,944.29 100,875.65 112,420.75 108,617.60 445,628 24.37%
BUILDING
LICENSES & PERMITS -138,915.42 -141,808.03 -158,085.03 -179,386.88 -406,150 44.17%
CHARGES FOR SERVICE -481.20 -558.53 -1,236.30 -1,865.75 -6,300 29.62%
FINES AND FORFEITS -500.00 -500.00 -1 '143.00 -713.18 -5,500 12.97%
MISC. REVENUE -256.46 -384.90 -247.38 -396.74 -3,600 11.02%
BUILDING REVENUES -140,153.08 -143,251.46 -160,711.71 -182,362.55 -421,550 43.26%
PERSONAL SERVICES 87,481.68 81,922.09 69,491.14 70,313.01 319,884 21.98%
OPERATING EXPENSES 23,733.80 22,895.38 21,291.77 19,777.34 91 '116 21.71%
TO FUND BALANCES 0.00 0.00 0.00 0.00 10,550 0.00%
BUILDING EXPENDITURES 111,215.48 104,817.47 90,782.91 90,090.35 421,550 21.37%
Page 3 of 3
54 of 80
CITY OF SEBASTIAN
GENERAL FUND DEPARTMENTS
QUARTER ENDING 12/31/12
2009/2010 2010/2011 2011/2012 2012/2013 2012/2013 2012/2013
1STQTR 1ST QRT 1STQRT 1ST QUARTER ANNUAL PERCENT
ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET
CITY COUNCIL
PERSONAL SI;RVICES 5,699.68 5,695.20 5,694.60 5,688.87 22,745.00 25.01
OPERATING EXPENSES 5,008.72 5,255.11 5,313.88 6,647.63 28,972.00 22.95
TOTAL 10,708.40 10,950.31 11,008.48 12,336.50 51,717.00 23.85
CITY MANAGER
PERSONAL SERVICES 55,473.30 50,360.85 49,911.52 48,470.22 229,837.00 21.09
OPERATING EXPENSES 3,075.39 423.30 807.11 703.93 3,550.00 19.83
TOTAL 58,548.69 50,784.15 50,718.63 49,174.15 233,387.00 21.07
CITY CLERK
PERSONAL SERVICES 54,070.05 52,695.19 53,605.41 53,561.60 246,678.00 21.71
OPERATING EXPENSES 42,203.44 18,966.80 42,831.34 19,267.28 36,989.00 52.09
TOTAL 96,273.49 71,661.99 96,436.75 72,828.88 283,667.00 25.67
LEGAL
OPERATING EXPENSES 16,641.97 16,016.56 17,743.65 17,097.48 102,360.00 16.70
TOTAL 16,641.97 16,016.56 17,743.65 17,097.48 102,360.00 16.70
FINANCE/ACCOUNTING
PERSONAL SERVICES 90,660.40 87,979.02 86,907.88 85,814.38 397,206.00 21.60
OPERATING EXPENSES 26,998.60 27,081.98 25,109.08 25,924.18 81,355.00 31.87
TOTAL 117,659.00 115,061.00 112,016.96 111,738.56 478,561.00 23.35
M.I.S. DIVISION
PERSONAL SERVICES 45,660.08 44,400.59 25,094.88 24,521.87 117,955.00 20.79
OPERATING EXPENSES 5,200.54 12,748.28 5,149.54 11,091.06 40,335.00 27.50
CAPITAL OUTLAY 1,300.52 0.00 0.00 0.00 5,000.00
TOTAL 52,161.14 57,148.87 30,244.42 35,612.93 163,290.00 21.81
POLICE ADMINISTRATION
PERSONAL SERVICES 122,824.93 110,140.48 116,935.83 97,588.92 501,230.00 19.47
OPERATING EXPENSES 39,313.10 36,695.48 29,043.59 35,823.16 103,685.00 34.55
TOTAL 162,138.03 146,835.96 145,979.42 133,412.08 604,915.00 22.05
POLICE PATROL
PERSONAL SERVICES 501,359.37 516,346.97 485,515.29 503,183.41 2,060,690.00 24.42
OPERATING EXPENSES 33,907.11 40,970.79 47,660.37 58,989.93 193,135.00 30.54
TOTAL 535,266.48 557,317.76 533,175.66 562,173.34 2,253,825.00 24.94
CODE ENFORCEMENT DIVISION
PERSONAL SERVICES 27,164.07 30,873.50 31,716.46 30,726.43 143,719.00 21.38
OPERATING EXPENSES 5,280.53 4,754.00 4,930.70 6,324.29 20,680.00 30.58
TOTAL 32,444.60 35,627.50 36,647.16 37,050.72 164,399.00 22.54
POLICE INVESTIGATIONS
PERSONAL SERVICES 213,323.37 198,821.73 139,693.21 110,800.96 580,024.00 19.10
OPERATING EXPENSES
20,76~~: 18,946.85 24,644.17 23,518.91 98,716.00 23.82
CAPITAL OUTLAY 919.41 0.00 0.00 0.00
TOTAL 234,086.35 218,687.99 164,337.38 134,319.87 678,740.00 19.79
POLICE COMMUNICATIONS
PERSONAL SERVICES 115,451.19 103,429.45 113,094.72 91,506.29 489,592.00 18.69
OPERATING EXPENSES 394.87 628.96 451.26 843.71 7,735.00 10.91
TOTAL 115,846.06 104,058.41 113,545.98 92,350.00 497,327.00 18.57
Page 1 of2 55 of 80
CITY OF SEBASTIAN
GENERAL FUND DEPARTMENTS
QUARTER ENDING 12/31/12
2009/2010 2010/2011 2011/2012 2012/2013 2012/2013 2012/2013
1ST QTR 1ST QRT 1STQRT 1ST QUARTER ANNUAL PERCENT
ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET
ROADS AND DRAINAGE
PERSONAL SERVICES 176,124.94 143,255.59 142,056.69 139,775.09 622,687.00 22.45
OPERATING EXPENSES 23,120.59 17,175.98 17,854.75 18,399.20 108,733.00 16.92
CAPITAL OUTLAY 0.00 0.00 0.00 0.00 39,000.00
TOTAL 199,245.53 160,431.57 159,911.44 158,174.29 770,420.00 20.53
STORMWATER UTILITY DIVISION
PERSONAL SERVICES 142,444.62 136,671.65 104,840.26 112,085.71 496,889.00 22.56
OPERATING EXPENSES 64,996.92 64,851.11 102,106.45 67,661.26 405,890.00 16.67
CAPITAL OUTLAY 0.00 0.00 0.00 0.00 1,200.00
TOTAL 207,441.54 201,522.76 206,946.71 179,746.97 903,979.00 19.88
CENTRAL GARAGE
PERSONAL SERVICES 39,085.97 17,789.82 38,248.58 41,303.25 182,300.00 22.66
OPERATING EXPENSES 9,404.72 7,713.42 4,067.12 2,963.94 24,466.00 12.11
CAPITAL OUTLAY 12,000.00 0.00 0.00 0.00 0.00
TOTAL 60,490.69 25,503.24 42,315.70 44,267.19 206,766.00 21.41
FACILITIES MAINTENANCE
PERSONAL SERVICES 26,955.06 25,499.30 50,799.01 38,069.86 160,541.00 23.71
OPERATING EXPENSES 16,201.48 11,038.80 12,731.62 18,500.84 114,776.00 16.12
CAPITAL OUTLAY 0.00 0.00 0.00 0.00 40,000.00
TOTAL 43,156.54 36,538.10 63,530.63 56,570.70 315,317.00 17.94
PARKS/RECREATION
PERSONAL SERVICES 179,734.59 155,667.05 145,790.85 146,003.13 652,045.00 22.39
OPERATING EXPENSES 62,023.41 45,453.19 52,687.12 52,599.04 229,683.00 22.90
CAPITAL OUTLAY 0.00 1,429.65 10,679.13 19,190.32 33,000.00 58.15
TOTAL 241,758.00 202,549.89 209,157.10 217,792.49 914,728.00 23.81
CEMETERY
PERSONAL SERVICES 31,795.95 19,613.17 20,295.77 19,601.07 86,814.00 22.58
OPERATING EXPENSES 5,104.71 2,693.75 6,406.11 3,880.76 30,440.00 12.75
CAPITAL OUTLAY 0.00 0.00 8,799.99 0.00 0.00
TOTAL 36,900.66 22,306.92 35,501.87 23,481.83 117,254.00 20.03
GROWTH MANAGEMENT
PERSONAL SERVICES 83,027.57 69,957.35 48,482.21 48,884.27 222,280.00 21.99
OPERATING EXPENSES 2,232.66 7,323.14 3,249.14 2,569.55 20,700.00 12.41
TOTAL 85,260.23 77,280.49 51,731.35 51,453.82 242,980.00 21.18
NON-DEPARTMENTAL
PERSONAL SERVICES 0.00 0.00 17,013.69 13,195.61 210,981.00 6.25
OPERATING EXPENSES 343,563.07 272,245.95 255,935.53 297,236.99 496,093.00 59.92
GRANTS AND AIDS 0.00 0.00 0.00 717.97 0.00
TRANSFERS OUT 0.00 0.00 0.00 0.00 12,888.00
TOTAL 343,563.07 272,245.95 272,949.22 311,150.57 719,962.00 43.22
ALL DEPARTMENTS
PERSONAL SERVICES 1,910,855.14 1,769,196.91 1 ,675,696.86 1,610,780.94 7,424,213.00 21.70
OPERATING EXPENSES 725,434.81 610,983.45 658,722.53 670,043.14 2,148,293.00 31.19
CAPITAL OUTLAY 13,300.52 2,349.06 19,479.12 19,190.32 118,200.00 16.24
GRANTS AND AIDS 0.00 0.00 0.00 717.97 0.00
TRANSFERS OUT 0.00 0.00 0.00 0.00 12,888.00
TOTAL GENERAL FUND 2,649,590.47 2,382,529.42 2,353,898.51 2,300,732.37 9,703,594.00 23.71
Page 2 of2
56 of 80
CAPITAL PROJECT STATUS REPORT
12/3112012
GENERAL CAPITAL PROJECTS
FUND 310 Percent
Project Project Expenditures Funds Expended/
Number Description Budget To Date Encumbrances Remaining Encumbered
Al310 Police Vehicle Replacement 56,000.00 52,318.00 3,682.00 93.43%
Al311 Old City Hall Windows 15,000.00 15,000.00 0.00%
Al312 FDLE Firewall 5,000.00 5,000.00 0.00%
Al313 Diesel Fuel Tanks 15,000.00 15,000.00 0.00%
Al314 Stormwater Equipment 230,000.00 185,940.00 44,060.00 80.84%
321,000.00 185,940.00 52,318.00 82,742.00 74.22%
CAPITAL IMPROVEMENT PROJECTS
FUND320 Percent
Project Project Expenditures Funds Expended/
Number Description Budget To Date Encumbrances Remaining Encumbered
C0921 Schumann Park Improvements 246,460.00 226,810.82 3,525.64 16,123.54 93.46%
Cl123 Bark Park Amenties 100,000.00 11,478.50 2,500.00 86,021.50 13.98%
C1124 Lift Station-Riverview Park 100,586.50 62,862.49 37,724.01 62.50%
C1125 Riverview Park Irrigation Fountains 25,000.00 8,261.52 16,738.48 33.05%
A1222 Blueway Signage 25,000.00 25,000.00 0.00%
A1223 Bleacher Shields 50,000.00 86.49 49,913.51 0.17%
A1224 Creative Playground 130,000.00 98,318.00 31,682.00 75.63%
Al225 Handicapp Pier 15,000.00 15,000.00 0.00%
Al320 Fish House Improvements 325,000.00 325,000.00 0.00%
Al322 Schumann Park Playground 25,000.00 25,000.00 0.00%
Al323 Volley Ball Court Lighting (RVP) 20,000.00 20,000.00 0.00%
Al324 Multi-use Field Lighting (BBSC) 185,000.00 168,000.00 17,000.00 90.81%
1,247,046.50 407,817.82 174,025.64 665,203.04 46.66%
TRANSPORTATION CAPITAL PROJECTS
FUND330 Percent
Project Project Expenditures Funds Expended/
Number Description Budget To Date Encumbrances Remaining Encumbered
C1126 Presidental Streets 473,500.00 33,179.44 440,320.56 7.01%
Cll32 Gateway Enhancement 25,000.00 25,000.00 0.00%
P0001 Road Paving 327,442.57 23,928.73 213,741.55 89,772.29 72.58%
A1231 Cav Corp Enhancements 825,000.00 47,217.44 22,922.58 754,859.98 8.50%
Al233 Indian River Drive Parking 125,000.00 43,182.74 4,000.00 77,817.26 37.75%
A1234 Davis Street Sewer 150,000.00 4,500.00 500.00 145,000.00 3.33%
Al330 Barber Street Bridge Repairs 60,000.00 60,000.00 0.00%
1,985,942.57 152,008.35 241,164.13 1,592,770.09 19.80%
STORMWATER IMPROVEMENT FUND
FUND363 Percent
Project Project Expenditures Funds Expended/
Number Description Budget To Date Encumbrances Remaining Encumbered
P0004 1/4 Round Swale Rehab 500,000.00 159,305.30 32,741.20 307,953.50 38.41%
500,000.00 159,305.30 32,741.20 307,953.50 38.41%
AIRPORT PROJECTS
FUND455 Percent
Project Project Expenditures Funds Expended/
Number Description Budget To Date Encumbrances Remaining Encumbered
Cll52 Install Security Cameras 43,000.00 24,777.49 16,939.00 1,283.51 97.02%
A1251 Airport, Survey, Marking and Apron Rehab 164,400.00 26,479.50 93,596.22 44,324.28 73.04%
Al351 Main Street Access Road 1,200,000.00 1,200,000.00 0.00%
1,407,400.00 51,256.99 110,535.22 1,245,607.79 11.50%
57 of 80
QUARTERLY INVESTMENT REPORT
FOR THE QUARTER ENDED
DECEMBER 31, 2012
As of December 31,2012, the total available funds ofthe City were $13,733,489. $8,157,220 was held
ip an interest bearing checking account, $3,573,329 was invested with the State Board of
Administration and $2,002,940 in government securities. All the remaining investments in government
securities will mature during the next quarter. At the Investment Committee's last meeting on
November 28, 2012, it was decided to defer further purchases until after some resolution was seen on
the "fiscal cliff' issue. At this time, the obtainable yields for maturities less than three years are less
than the yield received on our checking account.
STATE BOARD OF ADMINISTRATION
CURRENT
INVESTMENT ALLOCATION PERCENT BALANCE
General Fund + Performance Deposits 51.56% 1,842,388.89
Discretionary Sales Tax Fund 23.94% 855,544.69
Riverfront Redevelopment Fund 2.81% 100,526.28
Parking In-Lieu-Of Fund 0.87% 31,076.50
Recreation Impact Fee Fund 0.57% 20,222.94
Law Enforcement Forfeiture Fund 1.67% 59,629.28
Golf Course Projects Fund 1.21% 43,414.56
Building Department Fund 10.23% 365,554.36
Cemetery Trust Fund 7.14% 254,971.64
Total 100% 3,573,329.14
CUSTODIAL ACCOUNT
YIELD TO DATE OF PURCHASE 12/3112012 MATURITY CUSIP
ASSET NAME MATURITY PURCHASE PRICE FAIR VALUE DATE NUMBER
U.S. Treasury Note 0.7917% 03/31111 996,836.00 1,000,860.00 02/28/13 912828QK9
FHLBNote 0.8641% 03/31/11 1,002,670.00 1,002,080.00 03/27113 313372RK2
TOTAL $
1,999,506.00 $ 2,002,940.00
FUND ALLOCATION
General $ 1,399,294.00 $ 1,401,697.18 69.98%
Discretionary Sales Tax 100,053.00 100,224.83 5.00%
Riverfront CRA 200,106.00 200,449.67 10.00%
Stormwater Revenue 100,053.00 100,224.83 5.00%
Building 200,000.00 200,343.48 10.00%
TOTAL $
1,999,506.00 $ 2,002,940.00 100.00%
58 of 80
CliYOf
~~
" c
HOME OF PWCAN ISLAND
Memorandum
To: Mayor and City Council
Thru: AI Minner, City Manager
From: Kenneth W. Killgore, Director of Finance
Date: March 8, 2013
Re: 1 sr Quarter Accomplishments Fiscal Year 2013
Enclosed please find the
1st Quarter Accomplishments for City Departments as assembled and edited by the Administrative
Services Department for the three months ended December 31, 2013.
CITY CLERK
Legislative Support Matters
• Prepared agenda packets and minutes for five Regular City Council meetings, one joint workshop with City of
Fellsmere-attended six meetings for I 0 hours.
• Six resolutions adopted, two failed.
• Three ordinances adopted.
• 14 resolutions adopted.
• One official document recorded with Clerk of Court.
• Five proclamations prepared and presented.
• Placed two legal notices in Press Journal.
• Placed two legal notices in the Press Journal.
• Provided monthly City calendars and revisions to Council, city staff and press.
• Provided monthly regional and county board meeting calendars to Council.
• Provided notice to regional boards and committees of new Council appointees.
• Coordinated attendance of clergy for Council meeting invocations.
• Distributed one City Code supplement.
• Prepared travel reimbursement for one Council Member for Advanced Institute for Elected Municipal Officials.
Records Management Program
• Responded to 50 public records request.
• 11 boxes of records that reached retention or were scanned & 15 bags of duplicate and OSA records
destroyed by Shred-It Recycling-17 trees saved.
• Scanned into Laserfiche-20 sets of minutes, 28 agenda packets, 6 Resolutions, 3 Ordinance, 7
agreements and 55 Cemetery files-60 other documents.
• 591 Building Contractor Files and Permit Folders with Plans scanned by the Building Dept.
Election Matters
• All Candidate and PAC G2, G3 and G4 reports timely submitted as well as some termination reports.
• Advertised two general election ads.
• Coordinated use of city facility and A V staff for two candidate forums.
• Clerk assisted with setup and opened/closed for SOE staff for eight day early voting in City Council Chambers.
• Swore in two newly elected Council members at 11/14112 regular meeting.
• Orientation documents prepared and conducted for one new Council member with City Manager and City Attorney.
• One plaque prepared for presentation for departing Council member.
59 of 80
City Board Matters
• Filled eight board vacancies.
• Prepared eight certificates of appreciation for outgoing board members.
• RPM attended and recorded three Natural Resources Board meetings.
• Deputy City Clerk attended and recorded Treasure Coast Council of Local Government meeting in October and
November.
• Clerk coordinated and attended Treasure Coast Council Local Government Luncheon in Ft. Pierce in November.
• Arranged four gifts for Treasure coast Council of Local Government leadership change.
• Deputy City Clerk attended and recorded three Veterans Advisory Committee meetings.
Cemetery Matters
• Certificates of Interment Rights issued for 14locations for a total of$17,200.
Community/Staff Matters
• Placed three courtesy ads in Press Journal.
• Responded toe-mails to the General City of Sebastian e-mail address and/or forwarded them to the appropriate
departments for response.
• Deputy Clerk and Records Program Manager volunteered at Sebastian Clambake.
• Clerk volunteered for Salvation Army.
• Clerk coordinated Mayor Hill's greeting of Justin Riney who visited Sebastian in 167 mile Indian River Lagoon
paddle to promote lagoon awareness.
• Clerk obtained IRC permit, Council approval and assisted with coordination of Christmas parade and prepared ads and
certificates of appreciation to sponsoring organizations and PD volunteers.
• RPM weekly update of City Hall marquee.
• Deputy Clerk swore in two police officers.
Personnel/Educational Matters
• RPM attended the Annual F ACC Fall Academy in October and obtained CMC Certification in December.
ADMINISTRATIVE SERVICES
• Prepared the 4th Quarter 2012 Budget Amendment to the City Council.
• Submitted the approved 2013 Operating Budget to the Government Finance Officers Association Awards Program.
• Assisted Auditors with interim audit work.
• Closed financial records for year-end and opened up the new budget year on the accounting software.
• Began preparation of the financial statements for the year ending September 30, 2012.
• Handled normal processing of payroll, accounts payable and cashiering.
• Hosted the Annual A wards Banquet in December.
• Coordinated the quarterly employee investment meetings with ICMA.
• Monitored and completed required grant paperwork on Airport and other grants.
• Monitored and approved payments on major contracts.
• Recruited, interviewed, and hired replacements for vacant positions.
2
60 of 80