Loading...
14-15-FY 2nd QuarterRESOLUTION NO. R-15-15 A RESOLUTION OF THE CITY OF SEBASTIAN, INDIAN RIVER COUNTY, FLORIDA AMENDING THE BUDGET FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2014 AND ENDING SEPTEMBER 30, 2015 AS PROVIDED FOR IN EXHIBIT "A"; PROVIDING FOR CONFLICTS; AND PROVIDING FOR AN EFFECTIVE DATE. WHEREAS, the City of Sebastian adopted Resolution No. R-14-23 on September 24, 2014 approving the City's 2014-15 budget, also referred to as the Annual Budget Resolution; and WHEREAS, the City of Sebastian adopted Resolution No. R-15-05 on March 11, 2015 amending the City's 2014-2015 budget; and WHEREAS, an analysis of the revenues and expenditures for the three (3) months that ended March 31, 2015 indicated that additional adjustments need approval by the City Council; and WHEREAS, the City Council and City Manager have previously approved any other necessary 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, 2014 and ending September 30, 2015 be amended as necessary, a summary of such amendments being attached hereto and more particularly identified as Exhibit "A", the revised appropriations, if any, are set out therein and 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 Hill The motion was seconded by Councilmember McPartlan was as follows: Mayor Richard Gilhnor Vice -Mayor Jerome Adams Councilmember Andrea Coy Councilmember Jim Hill Councilmember Bob McPartlan aye and, upon being put to a vote, the vote The Mayor thereupon declared this Resolution duly passed and adopted this 24h day of June 2015. CITY �10D)ASEBR By: yor Richard Gillmor ATTES Approved as to form and content for rel�iqye by the City o�an only: Sally A. Maio C Robert A. Ginsburg, City Clerk City Attorney EXHIBIT "A" of RESOLUTION R-15-15 SUMMARY OF BUDGET CHANGES FOR THE QUARTER ENDED MARCH 31, 2015 Amounts Changes Authorized by City Manager: Adjustment to reclassify computer supplies budgeted incorrectly as capital items. $ 1,904 Adjustment to use Riverview Park Sidewalk Project funds as 50-50% match on FDOT Highway Beautification Grant. Riverview Park Sidewalk Project will be re -budgeted next fiscal year. $ 100,000 Adjustment to allocate funds received as a donation from the Arden Greer Trust Fund. $ 20,000 Adjustment to reestablish budget for a compact excavator ($28,056) using the Equipment R&R Reserve approved by City Council on 9/10/2014 and to adjust between several accounts within $ 41.306 the Stormwater Division Budget. Adjustment between City Manager accounts to properly allocate expenses. $ 105 Adjustment to close unexpended funds on the project for a Boat Lift at Mulligans. $ 976 Adjustment between Facilities Maintenance accounts to properly allocate additional electrical charges for installing an air conditioner in the Broadcast Room. $ 700 Adjustment to properly allocate annual subscription costs of a recruiting service. $ 900 Adjustment to allocate reimbursements revenues for site plan review to the expense account $ 11,567 they were paid from. Adjustment to close unexpended funds on the project for a diesel fuel tank. $ 2,187 Adjustment between Public Works accounts for budget overages in various accounts. $ 2,769 Adjustment between CRA accounts to purchase new ice maker for Crabby Bills. $ 11,266 Adjustment from Police Department Salaries to add a part-time Logistics Specialist. $ 8,785 Adjustment closing unexpended funds on Riverview Park Irrigation/Park Fountains projects. $ 1,293 Adjustments between Police Department accounts to cover budget overages. $ 4,336 Adjustments between Parks Division accounts to purchase soccer goal post and a new well at $ 2,984 the Community Center. Adjustments between Police Department accounts for cost of rifle trauma plates for tac vest $ 4,650 and defensive tactics training suits. Adjustment between Parks Division accounts to replace fence at Easy Street Park Playground. $ 850 Adjustment between Public Works accounts to buy shed for the Public Works Compound. $ 4,340 Adjustment to use unexpended street sweeping funds to cover cost of paving road crossings. $ 7,000 Adjustment closing unexpended funds for quarter round projects and free up funds for a $ 293,487 concerted ditch cleaning program. Adjustment closing unexpended funds for street paving projects. $ 229 Adjustment between Police Department accounts to cover budget overages. $ 700 Adjustment between Cemetery Division accounts to cover budget overages. $ 500 Adjustment between Presidential Streets and Coolidge Projects. $ 20,634 Adjustment for repairs to Police cruiser from recovered insurance proceeds. $ 2,480 Adjustment between Police Department accounts to purchase tactical vests. $ 11,804 Adjustment between CRA accounts to purchase new walk-in cooler for Crabby Bills. $ 15,000 Adjustment to auction proceeds for costs of selling Airport fund surplus equipment. $ 1,545 Adjustment to Police overtime expense account for amounts recovered from MACE. $ 5,026 Chanaes AoDroved by City Council: Approved the purchase of the "Clear Village" software for permitting, licensing and complaints $ 61,762 using $19,800 from General Fund Reserves and $41,962 from Building Fund Reserves January 28, 2015. Approved more funds on Fisherman's Landing Marina Construction Project February 11, 2015. $ 4,916 Approved replacement of Public Works Pickup from vehicle auction proceeds March 11, 2015. $ 29,382 Approved Coastal Zone Management Grant for Working Waterfront Museum March 11, 2015. $ 10,000 Approved FDLE JAG Grant for micro robot for video reconnaissance March 25, 2015. $ 3,400 Approved additional audit fee for GASB requirements on Pension Funds January 14, 2015. $ 2,000 Approved use of Tulip Street project budget for additional funds needed for Fleming Street $ 127,023 March 25, 2015. Additional Changes Submitted for City Council Approval: Use of Equipment & Facilities R&R Reserve for ditch work on Barber, Caravan & Crowberry. $ 9,598 Use of Equipment & Facilities R&R Reserve for pipe repair on Coolidge/Indian River Drive. $ 14,980 Use of Equipment & Facilities R&R Reserve for sidewalk repairs at Barber Street Bridge. $ 1,926 Use of Equipment & Facilities R&R Reserve for repairs to Garage roof. $ 8,651 CITY OF SEBASTIAN QUARTERLY FINANCIAL REPORT EXECUTIVE SUMMARY OVERVIEW THE SECOND QUARTER FOR GENERAL FUND APPEARS GOOD, WITH 56.7% OF BUDGETED REVENUES RECEIVED AND DEPARTMENTS SPENDING 49.4% OF AMOUNTS ALLOCATED. AS EXPECTED AT THIS TIME OF YEAR, RESERVES ARE STILL ON THE HIGH SIDE. GOLF COURSE OPERATING REVENUES EXCEEDED EXPENSES AND ARE SLIGHTLY HIGHER THAN LAST YEAR, SOMEWHAT IMPROVING ON THE AMOUNT OF RESERVES. REVENUES AT THE AIRPORT WERE GREATER THAN EXPENSES FOR THE QUARTER AND INCREASED THE AMOUNT OF AIRPORT RESERVES. BUILDING FUND REVENUES ARE SLIGHTLY HIGHER THAN LAST YEAR, WHILE EXPENSES WERE UP DUE TO PAY INCREASES. GENERAL FUND The graph below and left compares General Fund Revenues, Expenditures and Total Cash Reserves at the end of the current quarter to the end of the prior fiscal year. Calculated Reserves balances increased, as a result of revenues exceeding expenditures. The graph below and right compares the 2nd quarter of this year to the 2"d quarter of the prior 2 years. Revenues and amounts Expended are a bit higher than prior years' 2"d quarters. 12,000,000 10,000,000 8,000,000 0,000,000 4,000,000 2,000,000 0 Revenues Ex ended Reserves 9/30!2014 10,556,091 10,292,217 5,733,332 3/3112015 6,325,161 5,515,145 6,542,147 7,000,000 90.0% 80.0% 70.0% 6,000,000 60.0% 50.0% 5,000,000 30.0°% 20.0% 4,000,000 10.0°% 0.0% 3,000,000 G`e oc� 1 dell\ys\o���ar�y"�tsetne�t ec�ax 0i UM0 Gl d"do,�xo5 S�vo"o�" nOePe Qo Gio' �o 2,000,000 1,000,000 0 ' Revenues Expended rReserves ■313112013 5,637,918 4,837,152 5,911,966 5,019,473 13313112015 6,325,161 5,515,745 809,416 The graph below and left shows collections through the 2"d quarter of the three main sources of General Fund Revenue and of those three as a total. Those three sources and property taxes are 69% of budgeted revenue. About $38,700 more was received from those three sources for the 2nd quarter of this year, as compared to the 2nd quarter of last year. The graph below and right shows the percentage of budgeted expenditures by department at the end of the quarter. In total, departments expended 49.4% of amounts budgeted. SPECIAL REVENUE FUNDS AND CAPITAL PROJECTS 100.0% 90.0% 80.0% 70.0% 60.0% 50.0% 40.0% 30.0°% 20.0% 10.0°% 0.0% �oo�aoa9ac G`e oc� 1 dell\ys\o���ar�y"�tsetne�t ec�ax 0i UM0 Gl d"do,�xo5 S�vo"o�" nOePe Qo Gio' �o Special Revenue Funds provide most of the monies needed for capital projects. The graph below and left shows collections the current year compared to last year and shows the current annual budget and collections for Local Option Gas Taxes (LOGT), Discretionary Sales Tax (DST) and Stormwater Fees. The graph below and right shows totals budgeted for capital projects, as compared to amounts spent through the end of the year. It reflects large unexpended amounts for the Fish House, Tulip Drive, plus the Airport's Main Street Access Road and Hanger projects. Page 1 of 2 6,000,000 5,000,-00 4,rNY "M111 3 600.00 2,000,LD0 1 rol Mil kdv, .xa-t ti��6 041 taw GEyp ��,A �qt. a S Yaf Q3ax 9 CITY OF SEBASTIAN QUARTERLY FINANCIAL REPORT EXECUTIVE SUMMARY (CONTINUED) DEBT SERVICE FUNDS AND LONG-TERM DEBT The City's long-term debt includes the Discretionary Sales Tax Bank Note ($2,225,000 outstanding, maturing 4/01/17) and the Stormwater Revenue Bank Note ($2,982,000 outstanding, maturing 5/01/22). The City refunded the previously issued bonds with Bank Notes on December 18, 2013. The City also has a Bank Note for Street Repaving ($1,793,000 outstanding, maturing 12/01/22) and a Bank Loan for Golf Carts ($229,018 outstanding, maturing 10/31/17). The City is in compliance with 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 2"d quarter this year to the end of the prior fiscal year. The graph below and right compares Revenues and Expenses at the end of the 2"d quarter this year to the end of the 2"d quarter the prior two years, plus the positive or negative impact to Reserves. 1,700 00a 1,500,006 1,300,000 1,100 OOG 96o,o6n i (06111111 /l 51X1(1611 306,000 100060 (166,666) (300,000) - 42P.VP.nIIP.S F% P.ndP.n RP.SP.NP.S 9f3rU'LU14 1275,923 1,542,745 (237,309) 3!31/2015 897209 669,509 (120,751) AIRPORT The graph below and left compares Airport Revenues, Expenses and Reserves at the end of the 2"d quarter this year to the end of the prior fiscal year. The graph below and right compares Revenues and Expenses for the 2"d quarter this year to the 2"d quarter of the prior two years, plus the positive or negative impact to Reserves. 800,000 700,000 200,000 1,400,000 500,000 1,200,006 100,000 300,000 250,000 1,000,000 100;000 0 66n nna (100,000) Revenues Expanded +l -Reserves 600,000 - 9/30/2014 775,677 1 M80,254 (47,513) 400,000 3/31/2015 214„130 182,546 (15,888) 200,000 200,750 26,273 a 214,130 182,546 31,584 Expended +l -Reserves Revenues Ex ended �1-Reserves 163,632 03(31/2013 918,651 685.763 232881 ■313112015 332,242 ■3(3112014 1,301,193 797,098 504,095 ■3(31/2015 897209 669,509 227,700 AIRPORT The graph below and left compares Airport Revenues, Expenses and Reserves at the end of the 2"d quarter this year to the end of the prior fiscal year. The graph below and right compares Revenues and Expenses for the 2"d quarter this year to the 2"d quarter of the prior two years, plus the positive or negative impact to Reserves. 800,000 700,000 200,000 600,000 500,000 400,000 100,000 300,000 250,000 200;000 100;000 0 0 (100,000) Revenues Expanded +l -Reserves (200,000) Revenues Expended Reserves 9/30/2014 775,677 1 M80,254 (47,513) 206,589 11,204 3/31/2015 214„130 182,546 (15,888) 227,023 200,750 26,273 BUILDING 250,000 200,000 350,000 150,000 300,000 100,000 250,000 50,000 200,000 0 150,000 Revenues Expanded +l -Reserves 100,000 0313112013 217,793 206,589 11,204 50,000 0313112014 227,023 200,750 26,273 0313112015 214,130 182,546 31,584 Expended +l -Reserves The graph below and left compares Building Department Revenues, Expenses and Reserves at the end of the 2"d quarter this year to the end of the prior fiscal year. The graph below and right compares Revenues and Expenses for the 2"d quarter of the current year to the 2"d quarter of the prior two years, plus the positive or negative impact to Reserves. 1,000,000 800,000 600,000 400,000 200,000 0 (200,000) Revenues Expended Reserves 9/30/2014 702,195 530,534 948,958 13131120151 332,242 1 355,116 926,085 Page 2 of 2 400.000 350,000 300,000 250,000 200,000 150,000 100,000 + 50,000 0 (50,000) Revenues Expended +l -Reserves In 313112013 359,893 196,261 163,632 ■313112014 328,424 242,744 85,680 ■313112015 332,242 355,116 (22,874) CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 03/31/15 CITY COUNCIL 2011/2012 201212013 2013/2014 2014/2015 2014/2015 2014/2015 CITY MANAGER 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT CITY CLERK ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET GENERALFUND 48,855.07 40,179.82 54,717.79 53,639.48 1021202.00 52.48% TAXES -3,888,945.20 -4,112,452.41 -4,230,041.08 -4,557,232.56 -7,169,750.00 63.56% LICENSES & PERMITS -13,225.50 -18,730.50 -99,569.06 -115,870.97 -143,800.00 80.58% INTERGVT'L REVENUE -800,481.37 -840,493.20 -888,206.53 -945,796.04 -2,244,109.00 42.15% CHARGES FOR SERVICE -145,026.53 -180,827.90 -193,952.12 -166,638.76 -330,955.00 50.35% FINES AND FORFEITS -31,377.83 -31,447.53 -32,879.77 -34,269.75 -67,100.00 51.07% MISC. REVENUE -90,058.36 -173,966.09 -154,762.77 -147,706.01 -263,104.00 56.14% TRANSFERS IN -345,569.06 -280,000.02 -312,555.00 -357,647.04 -718,306.00 49.79% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -228,780.00 0.00% GENERAL FUND REVENUE -5.314.683.85 -5.637.917.65 -51911.966.33 -6,325,161.13 -11,1651904.00 56.65%_ CITY COUNCIL 22,836.08 24,174.72 22,349.90 22,377.66 53,222.00 42.05% CITY MANAGER 108,976.30 109,898.72 144,283.07 121,455.37 258,726.00 46.94% CITY CLERK 165,432.29 161,816.08 145,375.43 170,360.27 349,168.00 48.79% LEGAL 48,855.07 40,179.82 54,717.79 53,639.48 1021202.00 52.48% FINANCE/ACCOUNTING 257,340.53 261,465.75 271,974.27 248,995.46 553,751.00 44.97% M.I.S. DIVISION 86,999.52 77,794.63 76,649.00 77,991.83 207,999.00 37.50% POLICE ADMINISTRATION 322,448.58 286,099.16 308,909.18 385,285.85 761,727.00 50.58% POLICE PATROL 1,171,372.16 1,198,599.32 1,189,763.52 1,272,457.84 2,378,307.00 53.50% CODE ENFORCEMENT DIVISIO 80,506.90 79,858.65 83,457.76 80,891.38 177,991.00 45.45% POLICE INVESTIGATIONS 349,293.48 307,843.77 362,167.27 394,585.89 722,301.00 54.63% POLICE COMMUNICATIONS 250,547.47 222,329.03 245,460.37 242,193.30 548,591.00 44.15% ROADS AND DRAINAGE 344,117.27 377,768.89 386,275.14 343,250.65 878,766.00 39.06% STORMWATER UTILITY DIVIS 443,248.68 361,840.57 425,043.09 591,735.78 1,204,290.00 49.14% CENTRAL GARAGE 93,756.52 100,385.11 95,442.78 99,272.27 216,664.00 45.82% FACILITIES MAINTENANCE 118,683.74 132,336.25 93,823.66 129,831.22 316,980.00 40.96% PARKS/RECREATION 441,568.59 440,535.92 454,691.66 476,997.77 954,097.00 49.99% CEMETERY 63,078.05 59,738.88 90,655.16 88,908.78 192,515.00 46.1`8% GROWTH MANAGEMENT 116,977.74 116,264.04 93,729.32 114,595.49 234,133.00 48.94% NON -DEPARTMENTAL 446,647.65 478,222.47 474,704.81 600,918.26 1,054,474.00 56.99% GENERAL FUND EXPENDITURES 4,932,686.62 4,837,151.78 5,019,473.18 5,515,744.55 11,165,904.00 49.40% LOCAL OPTION GAS TAX TAXES -239,701.95 -234,203.77 -230,211.92 -261,912.52 -553,152.00 47.35% INTERGVT'L REVENUE 0.00 0.00 0.00 0.00 -10,050.00 0.00% MISC. REVENUE -13.32 -85.02 -2,912.61 -140.28 -106.00 132.34% FROM FUND BALANCES 0.00 0.00 0.00 -45,385.80 -207,000.00 21.93% LOGT FUND REVENUE -239,715.27 -234,288.79 -233,124.53 -307,438.60 -770,308.00 39.91% OPERATING EXPENSES 98,595.10 95,818.50 77,427.92 101,802.81 320,103.00 31.80% DEBT SERVICE 132,782.83 122,240.69 121,360.30 121,391.20 242,783.00 50.00% GRANTS AND AIDS 50,000.00 0.00 0.00 136,742.10 157,000.00 87:10% TRANSFERS OUT 62,500.02 200,015.71 0.00 0.00 50,422.00 0.00% LOCAL OPTION GAS TAX 343,877.95 418,074.90 198,788.22 359,936.11 770,308.00 46.73% DISCRETIONARY SALES TAX TAXES -1,012,948.89 -1,067,514.98 -1,105,651.39 -1,180,341.11 -2,766,832.00 42.66% MISC. REVENUE -2,221.31 -2,254.63 -2,861.44 -2,960.16 -26,095.00 11.34% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -495,944.00 0.00% DST FUND REVENUE -1,015,170.20 -1,069,769.61 -1,108,512.83 -1,183,301.27 -3,288,871.00 35.98% TRANSFERS OUT 1,418,279.80 924,505.95 940,984.37 1,399,399.66 3,288;871.00 42.55% TO FUND BALANCES 0.00 0.00 0.00 0.00 0.00 0.00% DISCRETIONARY SALES TAX 1.418.279.80 924,505.95 940,984.37 1,399,399.66 3,288,871.00 42.55% RIVERFRONT REDEVELOPMENT FUND MISC. REVENUE -1,163.06 -300.90 -8,569.60 -18,710.00 -36,718.00 50.96% TRANSFERS IN -255,068.85 -266,323.21 -272,060.44 -296,420.01 -287,844.00 102.98% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -106,073.00 0.00% RRD REVENUE -256,231.91 -266,624.11 -280,630.04 -315,130.01 -430,635.00 73.18% OPERATING EXPENSES 65,324.55 65,596.39 63,787.45 86,061.04 113,229.00 76.01% CAPITAL OUTLAY 0.00 0.00 0.00 11,765.86 26,266.00 44.80% GRANTS AND AIDS 17,000.00 0.00 0.00 15,500.00 146,140.00 10.61% TRANSFERS OUT 32,840.96 33,353.60 30,000.00 30,150.00 145,000.00 20.79% RRD EXPENDITURES 115,165.51 98,949.99 93,787.45 143,476.90 430,635.00 21.78% CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 03/31/15 RECREATION IMPACT FEE FUND MISC. REVENUE 2011/2012 2012/2013 201312014 2014/2015 2014/2015 20/412015 FROM FUND BALANCES 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT RECREATION IMPACT FEE REVENUE ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET PARKING IN LIEU OF FUND 0.00 0.00 550.00 3,280.00 8,200.00 40.00% MISC. REVENUE -6,909.22 -6,924.58 -10,056.94 -11,044.10 -13,905.00 79.43% PARKING IN LIEU OF REVENUE -6,909.22 -6,924.58 -10,056.94 -11,044.10 -13,905.00 79.43% CAPITAL OUTLAY 0.00 0.00 0.00 2,800.00 0.00 0.00% TO FUND BALANCES 0.00 0.00 0.00 0.00 13,861.00 0.00% PARKING IN LIEU OF EXPENDITURES 0.00 0.00 0.00 2,800.00 13,861.00 20.20% RECREATION IMPACT FEE FUND MISC. REVENUE -27,391.89 -70,735.43 -78,943.27 -60,024.46 -250,273.00 23.98% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -6,907.00 0.00% RECREATION IMPACT FEE REVENUE -27,391.89 -70,735.43 -78,943.27 -60,024.46 -257,180.00 23.34% OPERATING EXPENSES 0.00 0.00 550.00 3,280.00 8,200.00 40.00% CAPITAL OUTLAY 0.00 5,522.91 0.00 0.00 0.00 0.00% TRANSFERS OUT 89,754.50 100,591.06 72,271.26 5,361.37 173,707.00 3.09% TO FUND BALANCE 0.00 0.00 0.00 0.00 75,273.00 0.00% RECREATION IMPACT FEE 89,754.50 106,11.3.97 72,821.26 8,641.37 257,180.00 3.36% STORMWATER UTILITY FUND 0.00 0.00 -500.00 -700.00 -1,000.00 70.00% MISC. REVENUE -683,596.88 -882,740.63 -876,813.04 -878,041.83 -1,002,705.00 87.57% TRANSFERS IN 0.00 0.00 0.00 0.00 -100,000.00 0.00% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -41,531.00 0.00% STORMWATER FUND REVENUE -683,596.88 -882,740.63 -876,813.04 -878,041.83 -1,144,236.00 76.74% OPERATING EXPENSES 0.00 24,443.07 24,794.39 8,074.22 40,100.00 20.14% TRANSFERS OUT 620,337.61 469,704.00 502,861.02 451,068.00 1,104,136.00 40.85% STORMWATER FUNE EXPENDITURES 620,337.61 494,147.07 527,655.41 459,142.22 1,144,236.00 40.13% LAW ENFORCEMENT FORFEITURE FUND FINES AND FORFEITS 0.00 0.00 -500.00 -700.00 -1,000.00 70.00% MISC. REVENUE -84.66 -84.66 -194.73 -38.58 -150.00 25.72% FROM FUND BALANCES 0.00 0.00 0.00 0.00 0.00 0.00% FORFEITURE REVENUE -84.66 -84.66 -694.73 -738.58 -1,150.00 64.22% OPERATING EXPENSES 0.00 0.00 592.56 1,256.94 0.00 0.00% CAPITAL OUTLAY 0.00 0.00 11,000.00 3,000.00 0.00 0.00% TO FUND BALANCES 0.00 0.00 0.00 0.00 1,150.00 0.00% FORFEITURE EXPENDITURES 0.00 0.00 11,592.56 4,256.94 1,150.00 370.17% DST DEBT SERVICE FUND MISC. REVENUE -5,758.57 -2,541.25 -39,837.70 -308.44 -2,086.00 14.79% TRANSFERS IN -498,695.52 -497,310.48 -506,246.52 -512,943.48 -1,025,887.00 50.00% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -1,334.00 0.00% DST DEBT SERVICE REVENUE -504,454.09 -499,851.73 -546,084.22 -513,251.92 -1,029,307.00 49.86% OPERATING EXPENSES 300.00 675.00 0.00 0.00 0.00 0.00% DEBT SERVICE 915,138.13 925,595.63 2,013,840.20 1,029,307.00 1,029,306.50 100.00% TO FUND BALANCES 0.00 0.00 0.00 0.00 0.00 0.00% DST DEBT SERVICE EXPENDITURES 915,438.13 926,270.63 2,013,840.20 1,029,307.00 1,029,306.50 100.00% STORMWATER DEBT SERVICE FUND MISC. REVENUE -91.54 -373.10 -39,112.79 -404.40 -165.00 245.09% TRANSFERS IN -219,261.48 -219,703.98 -220,860.00 -201,067.98 -402,136.00 50.00% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -1,287.00 0.00% STORMWATER DEBT SERVICE REVENUE -219,353.02 -220,077.08 -259,972.79 -201,472.38 -403,588.00 49.92% DEBT SERVICE 79,998.75 74,398.75 329,625.35 25,794.30 403,588.00 6.39% STORMWATER DEBT EXPENDITURES 79,998.75 74,398.75 329,625.35 25,794.30 403,588.00 6.39% CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 03/31/15 AIRPORT FUND 201112012 2012/2013 2013/2014 2014/2015 2014/2015 201412015 CHARGES FOR SERVICE 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT MISC. REVENUE ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET GOLF COURSE FUND -212,028.25 -217,792.96 -227,023.28 -214,130.11 -440,185.00 48.65% CHARGES FOR SERVICE -903,171.97 -839,781.15 -807,784.61 -873,414.51 1,277,200.00 -68.3901,u- 68.39%MISC. MISC.REVENUE -26,776.89 -78,869.43 -493,408.44 -23,794.61 40,720.00 -58.43% TRANSFER IN 0.00 0.00 0.00 0.00 15,000.00 0.00% GOLF COURSE FUND REVENUE -929,948.86 -918,650.58 -1,301,193.05 -897,209.12 1,3329920.00 -67.31% ADMINISTRATION 292,595.19 323,041.84 445,591.76 313,928.92 587,303.00 53.45% MAINTENANCE 272,403.13 285,984.79 289,452.73 282,578.33 608,401.00 46.45% GOLF COURSE CARTS 73,443.47 76,736.67 62,053.42 73,001.84 137,216.00 53.20% GOLF COURSE FUND EXPENSES 638,441.79 685,763.30 797,097.91 669,509.09 1,332,920.00 50.230/6 AIRPORT FUND -233,913.26 -350,863.06 -311,976.57 -319,570.14 -603,400.00 52.96% CHARGES FOR SERVICE -8,152.30 -3,391.01 -5,035.65 4,672.07 -15,000.00 -31.15% MISC. REVENUE -203,875.95 -214,401.95 -221,987.63 -218,802.18 -425,185.00 51.46% AIRPORT FUND REVENUE -212,028.25 -217,792.96 -227,023.28 -214,130.11 -440,185.00 48.65% ADMINISTRATION 218,971.69 205,846.56 188,112.07 177,846.07 420,185.00 42.33% ECONOMIC DEVELOPMENT 0.00 742.46 12,637.80 4,699.70 20,000.00 23.50% AIRPORT FUND EXPENSES 218,971.69 206,589.02 200,749.87 182,545.77 440,185.00 41.47% BUILDING FUND LICENSES & PERMITS -233,913.26 -350,863.06 -311,976.57 -319,570.14 -603,400.00 52.96% CHARGES FOR SERVICE -2,909.23 -5,964.30 -5,975.45 -5,807.94 -12,750.00 45.55% FINES AND FORFEITS -2,893.00 -1,870.68 -8,372.00 -4,282.86 -12,000.00 35.69% MISC. REVENUE -1,913.84 -1,194.49 -2,100.21 -2,581.26 -2,500.00 103.25% FROM FUND BALANCE 0.00 0.00 0.00 0.00 -41,962.00 0.00% BUILDING FUND REVENUES -241,629.33 -359,892.53 -328,424.23 -332,242.20 -672,612.00 49.40% PERSONAL SERVICES 152,891.27 155,263.84 167,917.83 240,401.36 412,966.00 58.21% OPERATING EXPENSES 44,999.81 40,996.84 42,271.37 44,059.13 93,890.00 46.93% CAPITAL OUTLAY 0.00 0.00 0.00 0.00 18,500.00 0.00% TRANSFERS OUT 0.00 0.00 32,554.98 70,656.00 147,256.00 47.98% TO FUND BALANCES 0.00 0.00 0.00 0.00 0.00 0.00% BUILDING FUND EXPENSES 197,891.08 196,260.68 242,744.18 355,116.49 672,612.00 52.80% CITY OF SEBASTIAN GENERAL FUND DEPARTMENTS QUARTER ENDING 03/31/14 201112012 2012/2013 2013/2014 2014/2015 201312014 2013/2014 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT ACTUALS ACTUALS ACTUALS ACTUALS BUDGET DF BUDGET CITY COUNCIL PERSONAL SERVICES 11,381.01 11,369.75 11,368.86 11,387.59 22,767.00 50.02% OPERATING EXPENSES 11,455.07 12,804.97 10,981.04 10,990.07 30,455.00 36.09% TOTAL 22,836.08 24,174.72 22,349.90 22,377.66 53,222.00 42.05% CITY MANAGER PERSONAL SERVICES 107,653.61 107,743.97 140,078.91 118,149.16 252,108.00 46.86% OPERATING EXPENSES 1,322.69 2,154.75 2,126.21 3,306.21 6,618.00 49.96% CAPITAL OUTLAY 0.00 0.00 2,077.95 0.00 0.00 0.00% TOTAL 108,976.30 109,898.72 144,283.07 121,455.37 258,726.00 46.94% CITY CLERK PERSONAL SERVICES 119,331,31 132,181.93 95,786.84 135,360.13 300,445.00 45.05% OPERATING EXPENSES 46,100.98 29,634.15 46,618.63 29,904.14 43,627.00 68.55% CAPITAL OUTLAY 0.00 0.00 2,969.96 5,096.00 5,096.00 100.00% TOTAL 165,432.29 161,816.08 145,375.43 170,360.27 349,168.00 48.79% LEGAL OPERATING EXPENSES 48,855.07 40,179.82 54,717.79 53,639.48 102,202.00 52.48% TOTAL 48,855.07 40,179.82 54,717.79 53,639.48 102,202.00 52.48% FINANCE/ACCOUNTING PERSONAL SERVICES 192,820.37 195,757.29 198,251.34 200,829.02 454,152.00 44.22% OPERATING EXPENSES 64,520.16 65,708.46 72,203.06 48,166.44 99,599.00 48.36% CAPITAL OUTLAY 0.00 0.00 1,519.87 0.00 0.00 0.00% TOTAL 257,340.53 261,465.75 271,974.27 248,995.46 553,751.00 44.97% M.I.S. DIVISION PERSONAL SERVICES 56,711.99 54,802.50 69,957.34 55,644.98 140,334.00 39.65% OPERATING EXPENSES 26,109.28 22,992.13 6,691.66 22,346.85 32,665.00 68.41% CAPITAL OUTLAY 4,178.25 0.00 0.00 0.00 35,000.00 0.00% TOTAL 86,999.52 77,794.63 76,649.00 77,991.83 207,999.00 37.50% POLICE ADMINISTRATION PERSONAL SERVICES 268,064.72 228,370.49 243,470.48 319,948.76 636,714.00 50.25% OPERATING EXPENSES 54,383.86 57,728.67 52,938.70 64,337.09 125,013.00 51.46% CAPITAL OUTLAY 0.00 0.00 12,500.00 1,000.00 0.00 0.00% TOTAL 322,448.58 286,099.16 308,909.18 385,285.85 761,727.00 50.58% POLICE PATROL PERSONAL SERVICES 1,066,988.63 1,084,028.33 1,080,450.64 1,1.66,749.14 2,132,059.00 54.72% OPERATING EXPENSES 1041-383.53 110,923.99 109,312.88 103,619.70 212,844.00 48.68% CAPITAL OUTLAY 0.00 3,647.00 0.00 2,089.00 33,404.00 6.25% TOTAL 1,171,372.16 1,198,599.32 1,189,763.52 1,272,457.84 2,378,307.00 53.50% CODE ENFORCEMENT DIVISION PERSONAL SERVICES 69,949.60 67,532.01 71,487.94 73,357.41 154,406.00 47.51% OPERATING EXPENSES 10,557.30 12,326.64 11,969.82 7,533.97 23,585.00 31.94% TOTAL 80,506.90 79,858.65 83,457.76 80,891.38 177,991.00 45.45% POLICE INVESTIGATIONS PERSONAL SERVICES 299,098.87 260,649.65 304,846.14 342,459.22 613,540.00 55.82% OPERATING EXPENSES 48,813.66 47,194.12 57,321.13 52,126.67 108,761.00 47.93% CAPITAL OUTLAY 1,380.95 0.00 0.00 0.00 0.00 0.00% TOTAL 349,293.48 307,843.77 362,167.27 394,585.89 722,301.00 54.63% CITY OF SEBASTIAN GENERAL FUND DEPARTMENTS QUARTER ENDING 03/31/14 201112012 2012/2013 201312014 2014/2015 2013/2014 201312014 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET POLICE COMMUNICATIONS PERSONAL SERVICES 246,402.01 220,518.43 241,183.27 238,205.70 536,329.00 44.41% OPERATING EXPENSES 2,149.82 1,810.60 4,277.10 3,987.60 12,262.00 32.52% CAPITAL OUTLAY 1,995.64 0.00 0.00 0.00 0.00 0.00% TOTAL 250,547.47 222,329.03 245,460.37 242,193.30 548,591.00 44.15% ROADS AND DRAINAGE PERSONAL SERVICES 304,269.09 301,576.38 293,687.05 277,188.42 612,011.00 45.29% OPERATING EXPENSES 39,848.18 37,613.26 62,151.49 66,062.23 131,915.00 50.08% CAPITAL OUTLAY 0.00 38,579.25 30,436.60 0.00 134,840.00 0.00% TOTAL 344,117.27 377,768.89 386,275.14 343,250.65 878,766.00 39.06% STORMWATER UTILITY DIVISION PERSONAL SERVICES 224,378.67 243,808.25 202,064.11 258,663.97 563,066.00 45.94% OPERATING EXPENSES 218,870.01 118,032.32 222,978.98 305,015.91 611,268.00 49.90% CAPITAL OUTLAY 0.00 0.00 0.00 28,055.90 29,956.00 03.66% TOTAL 443,248.68 361,840.57 425,043.09 591,735.78 1,204,290.00 49.14% CENTRAL GARAGE PERSONAL SERVICES 83,871.84 88,295.68 83,450.08 88,657,99 190;299.00 46.59% OPERATING EXPENSES 8,878.93 8,160.43 11,992.70 7,828.28 23,365.00 33.50% CAPITAL OUTLAY 1,005.75 3,929.00 0.00 2,786.00 3,000.00 92.87% TOTAL 93,756.52 100,385.11 95,442.78 99,272.27 216,664.00 45.82% FACILITIES MAINTENANCE PERSONAL SERVICES 74,766.70 68,472.49 58,716.33 76,783.23 169,729.00 45.24% OPERATING EXPENSES 43,917.04 51,376.76 33,676.31 46,775.02 140,978.00 33.18% CAPITAL OUTLAY 0.00 12,487.00 1,431.02 6,272.97 6,273.00 100.00% TOTAL 118,683.74 132,336.25 93,823.66 129,831.22 316,980.00 40.96% PARKS/RECREATION PERSONAL SERVICES 315,961.91 310,808.26 315,881.86 332,913.99 703,930.00 47.29% OPERATING EXPENSES 114,927.55 110,537.34 122,697.01 130,895.50 210,351.00 62.23% CAPITAL OUTLAY 10,679.13 19,190.32 16,112.79 13,188.28 39,816.00 33.12% TOTAL 441,568.59 440,535.92 454,691.66 476,997.77 954,097.00 49.99% CEMETERY PERSONAL SERVICES 43,188.71 42,474.10 71,444.49 75,647:35 155,468.00 48.66% OPERATING EXPENSES 11,089.35 17,264.78 19,210.67 13,261.43 37,047.00 35.80% CAPITAL OUTLAY 8,799.99 0.00 0.00 0.00 0.00 0.00% TOTAL 63,078.05 59,738.88 90,655.16 88,908.78 19.2,515.00 46.18% GROWTH MANAGEMENT PERSONAL SERVICES 107,567.60 107,390.63 81,434.32 95,788.66 206,118.00 46.47% OPERATING EXPENSES 9,410.14 8,873.41 12,295.00 18,806.83 28,015.00 67.13% TOTAL 116,977.74 116,264.04 93,729.32 114,595.49 234,133.00 48.94% NON -DEPARTMENTAL PERSONAL SERVICES 80,716.94 60,571.27 47,582.16 67,827.59 123,890.00 54.75% OPERATING EXPENSES 365,930.71 416,933.23 427,122.65 448,365.04 571,643.00 78.43% TRANSFERS TO OTHER FUNDS 0.00 717.97 0.00 84,725.63 358,941.00 23.60% TOTAL 446,647.65 478,222.47 474,704.81 6_00,918.26 1,054,474.00 56.99% GENERAL FUND EXPENDITURES 4,932,686.62 4,837,151.78 5,019,473.18 5,515,744.55 11,165,904.00 49.40%Q CITY OF SEBASTIAN FLORIDA CAPITAL PROJECT STATUS REPORT FUND 310 GENERAL CAPITAL PROJECTS Project Project Expenditures Percent Funds Numbe Description Budge To Date Expended Encumbrances Remaining A 141 I Computer Overhaul 300,000.00 225,070.07 75.02% - 74,929.93 A1412 Diesel Fuel Tank (Closed) 32,812.62 32,812.62 100.00% - 0.00 A1513 Police Vehicle Replacement 368,000.00 10,630.22 2.89% 264,238.46 93,13 t.32 A1514 Roof Repairs 75,000.00 - 0.00% - 75,000.00 A1515 Diesel Fuel Tank Software 25,000.00 - 0.00%0 - 25,000.00 A1516 Stormwater Equipment 102,000.00 - 0.00% 101,709.00 291.00 A1517 Vac Truck 361,500.00 - 0.00% 361,502.60 (2.60) A1518 Clear Village Software 61,762.00 25,209.00 40.82% 35,803.00 750.00 1.326,074.62 293,721.91 22.15% 763,253.06 269,099.65 FUND 320 CAPITAL IMPROVEMENT PROJECTS Project Project Expenditures Percent Funds 'umber Description Budget To Date Expended Encumbrances Remaining C l 125 Riverview Park Irrigation Fountains (Closed) 23,707.18 23,707.18 100.00% - - A1320 Fish House Improvements 512,766.00 81,323.50 15.86% 8,723.61 422,718.89 A1422 Tennis Wall 32,000.00 19,620.00 61.31% - 12,380.00 A1424 Disc Golf Q Stonmwatcr Park 18,000.00 - 0.00% - 18,000.00 A1521 Community Center Parking 52,000.00 840.00 1.62% - 51,160.00 A1522 Fisherman's Landing Shoreline 22,000.00 500.00 2.27% - 21,500.00 A1523 Skate Park Rebuild 125,000.00 289.20 0.23% - 124,710.80 A1524 Yacht Club Pier Decking 60,000.00 - 0.00% - 60,000.00 A1525 Boat Lift (Closed) 7,975.82 7,975.82 100.00% - - A1526 Veteran's Memorial 11,000.00 5,827.00 52.97% - 5,173.00 864,449.00 140,082.70 16.20% 8,723.61 7.15,642.69 FUND 330 TRANSPORTATION CAPITAL PROJECTS Project Project Expenditures Percent Funds Number Description Bud et To Date Expended Encumbrances Remaining C1132 Gateway Enhancement 25,000.00 5,321.49 21.29% 17,550.00 2,128.51 A1231 Presidential Streets 971,021.40 932,365.33 96.02% 3,000.00 35,656.07 A1433 Street Repaving 104,116.80 104, l 16.80 100.00% - - A 1434 Tulip Drive 423,977.00 20,000.00 4.72% - 403,977.00 A1531 Police Station Parking 52,000.00 - 0.00% - 52,000.00 A1532 Cav Corp Parking 2,000.00 2,350.00 117.50% - (350.00) A1533 Pedestrian Bridges (Closed) 32,139.83 32,139.83 100.00% - - A1534 Fleming Street Paving 327,023.00 272.30 0.08% - 326,750.70 A1535 Coolidge Street Paving (Closed) 480,670.60 480,670.60 100.00% - - A1536 Street Paving 157,000.00 52,821.90 33.64% - 104,178.10 A1537 Riverview Park Sidewalks 35,000.00 - 0.00% - 35,000.00 A1538 Highway Beautification 100,000.00 9,082.00 9.08% 4,893.00 86,025.00 2,709,948.63 1,639,140.25 60.49% 25,443.00 1,045,365.38 FUND 363 STORMWATER IMPROVEMENT FUND Project Project Expenditures Percent Funds Number Description Budge c To Date Expended Encumbrances Remaining A1461 Quarter Round (Closed) 495,003.01 495,003.01 100.00% - - A1561 Quarter Round (Closed) 211,509.80 211,509.80 100.00% - - A1562 Indian River Lagoon 100,000.00 - 0.00% - 100,000.00 806,512.81 706,5 t2.81 2.00 - 100,000.00 FUND 455 AIRPORT PROJECTS Project Project Expenditures Percent Funds Number Description Budget To Date Expended Encumbrances Remaining A1351 Main Street Access Road 1,641,163.00 207,896.03 12.67% 739,263.35 694,00162 A1451 AP Hangar 1,525,000.00 110,376.47 7.24% 134,492.34 1,280,131.19 3,166,163.00 318272.50 0.20 873,755.69 1,974,134.81 QUARTERLY INVESTMENT REPORT FOR THE QUARTER ENDED MARCH 31, 2015 As of March 31, 2015, the total of the City's cash and investments were $12,883,761.74. Of this, $9,287,710.58 was held in an interest bearing checking account at Seacoast National Bank and $3,596,051.16 was invested with the State Board of Administration. The City did not purchase any new securities during the quarter and does not currently hold any investments in government securities. At this time, the obtainable yields for maturities less than three years are still less than the yield received on our checking account, which is .30% over the rate for 13 week Treasury Bills. The State Board rate has been in a range of about .16%. SEACOAST NATIONAL BANK Per Audited Financial Statements STATE BOARD OF ADMINISTRATION (SBA) Initial Assignment of FY2012-13 Surplus Changes to Assigned Reserves CURRENT 09/30/14 Surplus for FY2013-14 CURRENT 09/30/14 CASH BALANCEALLOCATION BALANC P INVE TMt•NTAT. OCATION liALAL! PERC General Fund S 4,614,953.19 49.69% General Fund $ 1,574,614.67 43.79% Local Option Gas Tax Fund 104,210.76 1.12% local Option Gas Tax Fund -0.000 0.0 Discretionary Sales Tax Fund 1,386,373.41 14.93% Discretionary Sales Tax Fund 841.490.69 23.40°/- Riverfront Redevelopment Fund 455,420.38 4.90% Riverfront Redevelopment Fund 96.138.19 2.67% Parking In-Lieu-orFund _ 0,00% Parking In-Licu-Of Fund 37,573.03 1.041/9 Recreation Impact Fee Fund 630,323.50 6.79% Recreation; Impact Fee Fund 16,551.08 0.4611/a Stormwater Utility Fund 463,677.80 4.991/9 StormwaterUtility Fund - 0.00% Law Enforcement Forfeiture Fund 2,172.38 0.020A Law Enforcement Forfeiture Fund 40,682.82 1.13% Discretionary Sales Tax, Debt Service Fund 708.97 0.01% Discretionary Sales Tax, Debt Service Fund - 0.00°/ Stormwater Series 2003 Debt Service Fund 343,745.48 3.700A Stomrwater Series 2003 Debt Service Fund - 0.00% Capital Projects Fund 0.000/4 Capital Projects Fund - 0.001/0 Capital Improvements Fund (29alls.08) -0.32%, Capital Improvements Fund - 0.001yo Transportation Fund (161,933.44) -1.74% Transportation Fund 0.00°x6 Stonnwater Projects Fund - 0.000/0 StomrwaterProjects Fund ON% Golf Course Fund 94,340.50 1.02% cotfCourseFund - 0.00`/0 Golf Course Projects Fund -0.00% Goircourse Projects Fund 138,729.77 3.866/o Airport Fund 69,276.35 0.75% AirportFund - 0.000/0 Airport Projects Fund 25,040.00 0.27% Airport Projects Fund - 0.00% Building Department Fund 657,762.59 7.08% Building Department Fund 373,681.22 10.39% Cemetery Trust Fund 618,996.79 6.66% Cemetery Trust Fund 256589.69 7.14% Performance Deposits Fund 11,930.00 0.13% Performance Deposits Fund 220,000.00 6.12% Total Bank Balance S 9,287,71058 100.00% Total SBA Balance S 3,596,051.16 100.00% REPORT ON GENERAL FUND CASH RESERVES FOR THE QUARTER ENDED MARCH 31, 2015 General Fund Cash Reserves are maintained to minimize the impact of unforeseen or emergency events, such as natural disasters, significant revenue shortfalls or unanticipated expenditures on the City's operations. City policies require reserves greater than or equal to thirty percent of the annual General Fund total expenditures budget, less debt service, interfund transfers and capital expenditures. However, should there be an event that caused City-wide damages of 30%, it is preferable to maintain a reserve balance of about $5 million dollars. A portion of this balance has been set aside from surpluses added since FY20.12-13 for funding unanticipated repairs and replacements. Unasslaned Reserves 09/30/13 Per Audited Financial Statements $5,065,242 Initial Assignment of FY2012-13 Surplus Changes to Assigned Reserves 19,789 09/30/14 Surplus for FY2013-14 263,874 09/30/14 Per Audited Financial Statements $5,348,905 -28,056 Less Equipment and Facilities 09/18/14 Replace Police Authentication System Repair and Replacement Reserve 264,058 09/30/14 Balance $5,084,847 Pending Seawall Engineering Assessment -50,000 $5,034,847 Equipment and Facilities Repair and Replacement Reserve Balances 09/30/13 Initial Assignment of FY2012-13 Surplus $467,286 $467,286 06/30/14 Replace 3 Mowers & Dump Truck -96,915 370,371 09/10/14 Replace Excavator -28,056 341,315 09/18/14 Replace Police Authentication System -4,343 337,972 09/30/14 Assignment of FY2013-14 Surplus +263,874 601,846 10/06/14 Repairs for Sinkhole at Rolling Hill Ditch -18,554 583,292 10/10/14 Repairs to Pedestrian Bridge -30,215 553,077 11/07/14 Ditch Work — Barber, Caravan & Crowberry -9,598 543,479 12/10/14 Replace Bucket Truck -94,641 448,838 Pending Share of Building Department Software -19,800 429,038 Pending Pipe Repair — Cooiidge/indian River Drive -14,980 414,058