Loading...
HomeMy WebLinkAbout05-17-2021 BAC AgendaOYU SEPAST HOME OF PELICAN ISLAND SEBASTIAN BUDGET REVIEW ADVISORY COMMITTEE AGENDA 6:00 P.M. MONDAY — MAY 17, 2021 CITY HALL 1225 MAIN STREET a. Call to Order b. Pledge of Allegiance c. Roll Call d. Approval of Minutes: Meeting of February 8, 2021 e. Review of Second Quarterly Report — FY 2020-2021 f. Reports from Chief Financial Officer: • Received GFOA Budget Award on Budget Document — 17t" Consecutive Year • Preliminary Taxable Values due before June 1st. ( Final before July 1st.) • Budget Presentation/Proposed Millage on July 28t". (Documents by June 23`d.) g. General Discussion by Members h. Public Comments i. Next Meeting Date — Monday, July 12, 2021 j. Adjourn Agenda Attachments: • Minutes for Meeting of February 8, 2021 • Second Quarterly Report — FY 2020-2021 ANY PERSON WHO DECIDES TO APPEAL ANY DECISION MADE WITH RESPECT TO ANY MATTER CONSIDERED AT THIS MEETING WILL NEED A RECORD OF THE PROCEEDINGS AND MAY NEED TO ENSURE THAT A VERBATIM RECORD OF THE PROCEEDINGS IS MADE, WHICH RECORD INCLUDES THE TESTIMONY AND EVIDENSE UPON WHICH THE APPEAL IS TO BE HEARS. (F.S.286.0905) IN COMPLIANCE WITH THE AMERICAN WITH DISABILITIES ACT (ADA), ANYONE WHO NEEDS A SPECIAL ACCOMODATION FOR THIS MEETING SHOULD CONTACT THE C1TYS ADA COORDINATOR AT 589-5330 AT LEAST 48 HOURS IN ADVANCE OF THIS MEETING. ZOOM INFORMATION Please click the link below to join the webinar: ittps:HusO2web.zoom.us/i/8440241595; Or One tap mobile: US:+13126266799„84402415955# or+19294362866„84402415955# Or Telephone: Dial(for higher quality, dial a number based on your current location): US: +1 312 626 6799 or +1 929 436 2866 or +1 301 715 8592 or +1 346 248 7799 or +1 669 900 6833 or +1 253 215 8782 Webinar ID: 844 0241 5955 International numbers available: https:Hus02web.zoom.us/u/kcmninAQnV I DRAFT CITIZENS BUDGET REVIEW ADVISORY COMMITTEE MINUTES OF REGULAR MEETING FEBRUARY 8, 2021 Chairman Napier called the Citizens Budget Review Advisory Committee meeting to order at 6:00 p.m. II. Pledge of Allegiance was recited by all. III. Roll Call Present: Mr. Napier Mr. Hoffman Mr. Hall Mr. Herlihy Mr. Wilson Absent: Mr. Sullivan (a) -- Unexcused absence Ms. Cerda (at -large member) Mr. McGinn (at -large member) Mr. Newhart (a) Also Present: Paul Carlisle, City Manager Ken Killgore, Administrative Services Director/CFO Barbara Brooke -Reese, MIS Manager Janet Graham, Technical Writer (via Zoom) IV. Selection of Chairperson Mr. Hoffman nominated Mr. Napier as Chairperson. There being no further nominations, Mr. Napier was approved as Chairperson by unanimous voice vote. V. Selection of Vice-Chainmerson Mr. Hoffman nominated Mr. Herlihy as Vice -Chairperson. Mr. Napier seconded the nomination. Mr. Herlihy was approved as Vice -Chairperson by unanimous voice vote. VI. Avvroval of Minutes: Meeting of Auoust 31, 2020 Mr. Napier asked if all Committee members had reviewed the Minutes of August 31, 2020. All indicated they had. He called for a motion. A motion to accept the Minutes as presented was made by Mr. Herlihy, seconded by Ms. Cerda, and approved unanimously via voice vote. VII. Review of Fourth Quarterly Report -- FY 2019-2020 Mr. Killgore explained to the new Committee members the procedure he follows when CITIZENS BUDGET REVIEW ADVISORY COMMITTEE PAGE 2 MINUTES OF FEBRUARY 8, 2020 MEETING preparing these reports and presenting them to City Council. He gave a PowerPoint presentation and explained the various reports (SEE ATTACHED). He explained the Agenda Transmittal Form, which also included Resolution No. R-21-02. The Summary of Budget Changes covered all the adjustments that have been made to the budget during the three months from July to September 2020. They are broken down into categories, and it showed the ones that were previously approved by City Council during their normal business meetings and the ones that are being submitted for approval after the fact. General Fund Revenues were then reviewed. The year ended with an annual amount of revenues that were collected at 94.4%. That is lower than the City's normal collection rate due to some unexpected events that happened during the year such as the state revenue sharing due to the COVID pandemic. Expenditures were 95.2%, just slightly lower than normal relating to departmental expenses. The end result was, and what we have now as a draft of the City's audited financial statements, $5,703,000.00 in reserves. Those are the amounts that are not committed at that point in the year. He next explained what has happened to the reserves since the beginning of the year. We started off with a fund balance of $5.9 million plus the $275,000.00 R&R account. An ending amount of reserves totals $5,419,259.00. After deducting the assigned funds of $283,742.00, there is a total of $5,144,259.00 in unassigned reserves plus the $275,000.00 in the R&R account for a total of $5,419,259.00, which is higher than what was projected. Regarding the status of the hurricane reimbursements, the City still has due from Hurricane Matthew $143,000.00. From time to time Mr. Killgore will get correspondence requesting additional information, but there has not been any movement on this. The Stormwater Fund, the Golf Fund, the Airport Fund, and the Building Fund were all reviewed. The Fund Summaries and the General Fund Department reports were covered. He then reviewed the Capital Project Status Report as of September 30, 2020. There are several projects that are still underway. The Quarterly Investment Report sets forth where the City's money is, the local bank account, the State Board of Administration investment funds, and another investment fund that is approved for cities to invest in called Florida Trust. There is a summary of some interFund loans that are being carried and what terms there are and how much has been instructed to be outstanding at the end of the fiscal year. The balance of the report is information that each department submits to his office to compile a summary of their activities during the quarter. Mr. Killgore then called for any questions/comments from the Board members. Mr. Hall asked, taking into the account the first quarter of this fiscal year, what is the current general fund balance. Mr. Killgore explained that at the end of the last fiscal n JK CITIZENS BUDGET REVIEW ADVISORY COMMITTEE PAGE 3 MINUTES OF FEBRUARY 8, 2020 MEETING year, September 30th, it is about $5.4 million. He does not have the first quarter report for this year yet. Mr. Herlihy asked Mr. Killgore if there is any prospect at all on the FEMA recovery of $143,000.00. Mr. Killgore stated he last heard from FEMA approximately three weeks ago. He got a report that their project manager for our account has left, and they will be looking at it. He sent a message back to them explaining that we have been waiting a long time for this, so anything they can do, to please help us. They have five years to come back to the City and question what was submitted. He is hoping that at some point someone will review it and say that this thing has been outstanding long enough, and they will finally send the money. He further explained that this figure is not recorded as a receivable. It is not like we have this amount as part of our fund balance. When those monies do come in, it would be additional revenue. Mr. Herlihy stated that when he reviewed each individual department, he saw that the overall percentage was 5% below budget. He was absolutely amazed. iven all the problems that everyone has had this year, that is a fantastic job on everyone's part as far as staff, management, and everyone by coming in under 5% below budget. Mr. Hoffman addressed the hurricane reimbursements. He asked the status on the funds. Did we have to send the money back yet, or is it still sitting in the unallocated reserves -- the overpayment that they sent us? Mr. Killgore stated that is correct. There is about $140,000,00 that the City hopes they will reimburse us for, but there are two separate issues. Mr. Hoffman asked regarding the General Fund Balance Forecast it shows $12,470,844.00. He asked how that is tied back to the expenditures year-to-date number, $12,887,000.00. Mr. Killgore stated it would be the $177,000.00 that was spent on R&R and the $283,000.00. Mr. Hoffman said he would doublecheck that. He further stated he would second Mr. Herlihy's comments that the City did a really good job of trying to control expenses. Mr. Napier stated he thought it was a very good report. He asked Mr. Killgore if he would send an email to the manager at FEMA and tell them that, since they overpaid that $90,000.00, credit it against the $143,000.00, and send us the $50.000.00. Mr. Killgore stated that he gets a notice that there is a new manager before anything gets done. Hearing no further comments/questions from Board members, Mr. Napier moved to the next item on the agenda. VII I. Review Budget Calendar and Discuss Next Meeting Date (Mav 17. 2021 ) Mr. Napier asked if anyone had an issue with the proposed calendar. Mr. Killgore commented that his intent when he put the budget calendar together, that tonight we would be reviewing both the fourth quarter of 2020 and the quarter through December 31, 2020. Time restraints did not allow him to get to that report. He proposed preparing the report at this point and hopefully getting it to the Budget Committee via email, and they CITIZENS BUDGET REVIEW ADVISORY COMMITTEE PAGE 4 MINUTES OF FEBRUARY 8, 2020 MEETING could then respond to him individually before he takes it to City Council, which he thinks he is scheduled for the meeting on the 24th to present the first quarter to them. Otherwise, there would need to be a special meeting, and he is not sure when he could get a special meeting in, as this room is pretty much occupied for the remainder of the month and early March. Mr. Napier said he would hate to wait till that May 17th meeting to review the first quarter because, by then the second quarter is going to be past due. He asked if there could be a special meeting scheduled for some time in March. Mr. Killgore stated he would try to do that. That would delay him presenting the report to Council on the 24th, but he will see if that can be accomplished. Mr. Napier asked if Mr. Killgore could email the Committee members a copy of the agenda packet that goes to Council. Then they could look at it at the May meeting. Mr. Killgore stated he would be happy to do that. It was the consensus of the Committee that the calendar should be left as it is. IX. General Discussion by Members Mr. Hoffman asked what the status is on the state's revenue sharing. Mr. Killgore stated that, although he has not done the first quarter report and does not have the document to show right now, he has been looking at the revenue collections. There was the drop in the state's revenue sharing at the end of last year where they cut us back severely. They went from approximately $60,000.00 a month to something like $20,000.00 a month. That only lasted for a couple of months, and then they started reinstating, particularly the October/November/December collections are much improved. They still are not at the levels we had. The state revenue sharing is from a trust fund that the state establishes and puts a portion of the state's sales tax monies in that fund to pass on to the municipalities. Of course, the business tax and sales tax receipts have had a negative impact on that fund. It looks like it is recovering, but not to the levels yet that we have been accustomed to in prior years. He stated that the City is about where it should be to meet budget because the figures in the budget were reduced. Mr. McGinn stated that he feels privileged to be on this Committee. Mr. Carlisle stated he appreciates everything this Committee does in its oversight of the budget. He also thanked Mr. Killgore and his staff for keeping the budget in order. X. Public Comment -- None XI. Adiourn There being no further business, Mr. Napier adjourned the meeting at 6:32 p.m. By: Date: Chairman Larry Napier j9 anaF HOME OF PELICAN ISLAND CITY COUNCIL AGENDA TRANSMITTAL FORM COUNCIL MEETING DATE: May 26, 2021 AGENDA ITEM TITLE: Resolution Accepting the 2nd Quarter Financial Report and Recognizing Necessary Amendments and Adjustments to the FY 2020-2021 Annual Budget. RECOMMENDATION: Move to approve Resolution R-21-07. BACKGROUND: Pursuant to City financial policies, budget reviews and any necessary adjustments are presented to the City Council quarterly. A capital project status report, investment report and accomplishments are also included. Formal approval by the City Council was already given for adjustments using the amounts required to cover repair of the roadway damaged due to failing culverts, matching funds for the Square Hangar Engineering, additional 1% raises and purchase of City Gateway Signs. Other items that were previously approved by the City Council in the 2"d Quarter included increased funding for the Public Works Compound and increased funding for the Taxiway. Adjustments being submitted for City Council approval include several expenditures authorized by the City Manager using the General Fund R&R Account. No further adjustments during the quarter require City Council approval. In accordance with the authority given by the Annual Budget Resolution, the City Manager can approve other budget transfers between accounts within Departments and to make adjustments necessary to implement programs, projects and expenditures that have been authorized by the City Council. Thus, the City Manager's adjustments included budget changes within his $15,000 spending authority, adjustments between budget accounts within the same departments, as well as adjustments allocating additional funding sources. The above adjustments are listed in Exhibit "A" that is an attachment to the Resolution. If Agenda Item Requires Exaenditure of Funds: Budgeted Amount: As per Exhibit "A" of the Resolution Total Cost: N/A Funds to Be Utilized for Appropriation: N/A Attachments: 1. Resolution R-21-07 and Attachment "A" 2 2"d Quarter Financial Report, including Capital Project Status, Investments/Loans and Accomplishments Administrative Services Department Review: City Attorney Review: Procurement Division Review, if applicable: City Manager Authorization: Date: RESOLUTION NO. R-21-07 A RESOLUTION OF THE CITY OF SEBASTIAN, INDIAN RIVER COUNTY, FLORIDA APPROVING AN AMENDMENT AND RECOGNIZING CERTAIN ADJUSTMENTS TO THE BUDGET FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2020 AND ENDING SEPTEMBER 30, 2021 AS PROVIDED FOR IN EXHIBIT "A"; PROVIDING FOR CONFLICTS; PROVIDING FOR SCRIVENER'S ERRORS; AND PROVIDING FOR AN EFFECTIVE DATE. WHEREAS, an analysis of the revenues and expenditures for the three (3) months that ended on March 31, 2021 indicated that there were budget adjustments requiring formal approval by the City Council and that previously approved amendments and adjustments by the City Manager should be recognized; and WHEREAS, the City Council and City Manager have previously approved any other necessary amendments and 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, 2020 and ending September 30, 2021 has been amended and adjusted as necessary within the quarter ending March 31, 2021; a summary of such amendments and adjustments being attached hereto and more particularly identified as Exhibit "A"; the revised appropriations, if any, are set out therein and are recognized as having been 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. Sections of this resolution may be renumbered or re -lettered and corrections of typographical errors which do not affect the intent may be authorized by the City Manager, or the City Manager's designee, without need of further action of the City Council by filing a corrected copy of same with the City Clerk. Section 4. This Resolution shall become effective immediately upon its adoption. It was moved for adoption by Councilmember The motion was seconded by Councilmember vote was as follows: Mayor Ed Dodd Vice -Mayor Jim Hill Councilmember Bob McPartlan Councilmember Fred Jones Councilmember Christopher Nunn and, upon being put to a vote, the The Mayor thereupon declared this Resolution duly passed and adopted this 26 h day of May 2021. ATTEST: Jeanette Williams, MMC City Clerk CITY OF SEBASTIAN, FLORIDA Mayor Ed Dodd Approved as to form and legality for the reliance by the City of Sebastian only: Manny Anon City Attorney EXHIBIT "A" OF RESOLUTION R-21-07 SUMMARY OF BUDGET CHANGES FOR THE QUARTER ENDED MARCH 31, 2021 ADJUSTMENTS PREVIOUSLY APPROVED BY CITY COUNCIL: y Budget Before Budget Budget After Project/Account Change _ Adjustment Change Reason for Adjustment Culvert Repair $29,000 $21,329 $50,329 01/13/21 Approved using Stormwater Fund Appropriated from Stormwater Reserve. ($255,507) ($21,329) ($276,836 ) eserves to repair roadway damaged due to failingculverts. Infrastructure 0 $277,516 $277,516 08/26/20 Approved using DST Reserves for FDOT Grant 0 ($222,013) ($222,013) Grant matching needed for Square Hangar Appropriated from DST Reserves ------------------------------------------------ (6,137,346) -------------------- ($55,503) ------------- ($6,192,849) ------------------------------------------------------------- Engineering and Development Project. Various Salary and Benefit Accounts $10_,032,641 $59,669 $10,09_ Appropriated from General Reserves _ ($174,775) ($46,492) _2,310 ($221,267) 10/14/20 Authorized by approvals of PEA Appropriated from Stormwater Reserves ($9,526) ($3,642) ($13,168) and PBA Labor Agreements provision for Appropriated from Golf Reserves ($7,194) ($2,382) ($91576) additional 1% raises if City Manager Appropriated from Airport Reserves ($1,288) ($402) ($1,690) believed City could do it. Appropriated from Building Reserves ($11,282) ($3,751) ($15,033) ----------------------------------------------- Improvements Other Than Buildings $132,010 $44,000 $176,010 02/24/21 Approved using DST Reserves to APeropriated_frgg DST Fund Reserves_____ ($6,192,849)_______ ($44,000) �$6,236,849) purchase six City Gateway Signs. ------- --------------------------------------- Buildings 088 $5,,899 550 $4,,417 $9,639,316 Ap proved using DST Reserves to increase Appropriated from DST Fund Reserves --------------------------------------------------------------- ($6,236,849 ) 0 ----------- {$1 266) ------ ---------------------- current year funding for construction of the Public Works Compound. Infrastructure $569,264 $731, 14 FAA Grant-� ($519,338) _$161,762 ($138,604) ($�6��/,942� 03/10/21 Approved increase in project costs FDOT Grant_ _ - ($241963) �$11,589) �$36,552) of Taxiway and using DST Reserves for additional matching requirements. Appropriated from DST Fund Reserve ($24,963) ($11,5-891 ($3_6.552) ADJUSTMENTS BEING SUBMITTED FOR CITY COUNCIL APPROVAL: Budget Before Budget Budget After Project/Account Change Adjustment Change Reason for Adjustment Vehicles and Equipment Used General Fund R&R Reserve to Appropriated from General Reserves --------------------------------------- ------------- _$71,464 ($57,964) - --- --------- _$6,221 ($6,221) - -- ------------ _$77,685_ ($64,185) - replace air conditioner in the Police R&M Buildings $y5,¢�71 $-1 2-24- '�4� $- 86--,851-- Used General Fund R&R Reserve to propriated_from General Reserves i$ 4,185) ($1, ($A5,409) replace lock at Hardee Park Restroom_ W orking Waterfront Improvements $508,135 $14 837 $522 972 Used General Fund R&R Reserve to do Appropriated from General Reserves ($65,409) ($14,837) ($80,246) emer encK_re ap irs to the seawall. IR&M Buildings $86,851 $5 000 $91 851_ Used General Fund R&R Reserve to Appropnated from General Reserves IR&M ($80.246�......... ($5 000)_____ ($85 246) replace the Community Center roof. Irrigation $5,500 $2,730 ' $8,230 Used General Fund R&R Reserve to cover Appropriated from General Reserves ($85,246) ($2,730) ($87,976) unexpected irrigation repairs in Parks. ADJUSTMENTS PREVIOUSLY AUTHORIZED BY THE CITY MANAGER: Budget Before Budget Budget After and COVID-19 Related Purchases oyee Sick or COVID-19 Work I Business Grants �- anae_- Adiustment Change $40,000 $314,382 $354,382 $80,000 $45,668 $125,668 $357,500 $180,000 $537,500 Rental and _Mortgage Assistance Grants $446,822 (390,050) $56,772 CARES Act Proceeds __________________________($924,322)______($150,000)_ � ($1,074,322) Vehicles & Equipment 0 $15,000 $15,000 Confiscated Property --------------------------------------------------- ($1,000) ($15,000) ($16,000) Vehicles &Equipment . _ ------------------- $242,050 --------------- $12,150 --------- $254,200 Contract Mowing Services $378,222 ($12,150) $366,072 Reason for Adjustment Adjustment for additional amount eligible for reimbursement from the CARES Act. Actual to date is: $282,262 in Purchases, $125,668 for Work, $533,500 in Business Grants and $56,772 for Rental and _Mortgage Grants ---------------------------- Adjusts Law Enforcement Forfeiture Fund for award via court proceedings of a confiscated 2015 Kia Sedan. ---------------------------------------------- Adjustment to cover the cost of a trailer needed for the Stormwater crews. CITY OF SEBASTIAN QUARTERLY FINANCIAL REPORT SECOND QUARTER ENDING MARCH 31, 2021 SUMMARY THE SECOND QUARTER FOR GENERAL FUND ENDED WITH 59.7% OF THE TOTAL BUDGETED REVENUES RECEIVED DUE General Fund Revenue PRIMARILY FROM PAYMENTS OF AD VALOREM TAXES. DEPARTMENTS SPENT 503% OF THE BUDGETED AMOUNTS. 5,000 OAdrieted Budget Wearto Os@ MIS WAS OVER 50% OF BUDGET DUE TO MAKING THE ANNUAL PAYMENTS OF SOFTWARE LICENSES; POLICE DUE 4,000 TO ANNUAL MAINTENANCE CONTRACTS RENEWALS AND THE 3,000 PENSION CONTRIBUTION; AND NON -DEPARTMENTAL DUE TO O 2,000 INSURANCE PREMIUMS AND THE CRA PAYMENT. 1,000 I GENERAL FUND SUMMARY � Budget YTD % o�J9\d� F v�� Coe Beginning Balance $ $ 5,703,001 Ad Valorem Taxes 4,563,724 4,254,890 93.2% Franchise Fees 1,462,101 555,726 38.0% Utility Taxes 3,122,777 1,211,541 38.8% Hurricane Recoveries 143,666 0.0% General Fund Expenditures Intergovernmental 2,341,085 1,238,720 52.9% Charges for Service 744,033 376,017 50.5% OAejusted Budget MY,-, Oate Licenses and Other 578,700 206,095 35.6% 6,500 Transfers From Other Funds 185,000 75,000 40.5% 4 5,500 Total Revenues $ 13,141,086 $ 7,917,989 60.3% 1 4,500 From Fund Balance 127,266 0.0% 7 3500 iE 2,500 Total Sources S 13,268,352 S 7,917,989 59.r/o 2,500 City Council 59,737 23,499 39.3% 500 wmrzmr.mwAb City Manager 292,499 132,156 45.2% 1500i �k _ Hc�' 0i A O`e City Clerk 217,040 100,629 0 46.4/0 Gic{ G�N� !°" v'E_ eSFJ �a Gm 0ke Od? � City Attorney 201,426 88,179 43.8% a��e Admin Services 707,722 338,310 47.8% MIS Division 516,961 271,864 52.6% Police Department 6,402,230 3,348,841 52.3% Roads and Drainage 1,040,937 445,165 42.8% Public Facilities 1,095,203 491,809 44.9% ADDITIONAL EXPENDITURES REFLECT THE UNANTICIPATED Leisure Services 1,122,549 460,025 41.0% EXPENDITURE NEXT QUARTER OF $358,786 TO REPAIR THE Community Dev. 517,184 234,387 45.3% YACHT CLUB SEAWALL. Non -Departmental 989,850 682,272 68.9% Total Expenditures $ 13,163,338 $ 6,617,136 50.3% GENERAL FUND BALANCE FORECAST Unappropriated 105,014 - n/a Total Uses $ 13,268,352 $ 6,617,136 49.90/6 Beginning Reserves 10/01/20 S Fund Balance R&R Account 5,428,001 5 275,000 Ending Unappropriated Fund Balance $ 7,003,854 Year to Date Revenue 7,917,989 Fund Balance/R&R Changes to Date: Unfinished 2020 Projects (39,379) THE 4ii4s,ouu ON HURRICANE MATTHEW STILL REMAINS Replaced Air Conditioner (57,964) UNPAID AND WAITING ON A DETERMINATION FROM FEMA. Adjusted for 2% Raises (123,846) Adjusted for Holiday Bonuses (11,550) $2,250 Hurricane R Reimbursements Adjusted for 1% Raises Server Room Air Conditioner (46,492) (6,221) $ine $2,00o More Due Hardee Park Restroom Lock (1,224) $1,750 Working Waterfront Seawall (14,837) Community Center Roof (5,000) $1500 Eligible Received Park Irrigation Repairs 2,730 Year to Date Uses $ (221,267) $ (82,516) $1,2so Other Expenditures (6,313,353) $1,000 1 Current Reserves 5 6,811,370 S 192,484 Expected Changes to Year End: $750 11 Additional Revenues 5,423,097 $500 Additional Expenditures (7,010,002) - 1 Ending Reserves $ 5,224,465 5 192,484 $250 , Contingency Balance $ 105,014 $_ Adjust R&R to $275,000 (82,516) 82,516 Matthew Irma Dorian Totals Adjusted Reserves S 5,246,963 5 275,000 Eligible $1581745 $547,325 $34,104 $2,163,174 Assigned Funds (748,742) - Received{ $1,438,079 rza $547,325 $34,104 $2,019,508 Net Unassigned Reserves $ 4,498,221 $ 275,000 Total Unassigned Reserves $ 4,773,221 Projected in 2021 Budget $ 5,141,412 CITY OF SEBASTIAN QUARTERLY FINANCIAL REPORT SECOND QUARTER ENDING MARCH 31, 2021 SUMMARY MOST OF THE STORMWATER FEES ARE COLLECTED DURING GOLF COURSE BALANCES EXCLUDE THE LOANS FROM THE THE FIRST QUARTER ALONG WITH PAYMENT OF PROPERTY GENERAL FUND AND BUILDING FUND WHICH WERE TAXES. COMMMITTED FOR IRRIGATION/CLUBHOUSE WORK. ENDING RESOURCES ARE PROJECTED TO BE BETTER THAN WHEN STORMWATER FUND SUMMARY WE PREPARED THE 2021 BUDGET PROJECTIONS. Budget YTD % GOLF FUND SUMMARY Beginning Fund Balance $ $ 1,375,749 Budget YTD % Stormwater Fees Interest Total Revenues From Fund Balance Total Sources Operating Expenditures Capital Outlay II Contingency r Transfer to Capital Projects r Total Uses Ending fund Balance Expected Change to Year End: Additional Revenues Additional Expenditures Additional Capital Outlay Transfers to Capital Projects 9130121 Net Available Funds Projected in 2021 Budget 2,039,714 44,844 2,084,558 $ 280,478 2,365,036 $ 1,533,653 254,200 31,202 545,981 2,365,036 $ 1,813,872 2,775 1,816,647 3,192,396 680,744 68,096 1,325 750,165 2,442,231 267,911 (852,909) (186,104) (544,656 1,126,473 804,968 88.9% 6.2% 87.1% 0.0% 135.0% 44.4% 26.8%i 0.0% 11 0.2% 31.7% AIRPORT REVENUES ARE HIGHER THAN 25% OF BUDGET AND EXPENSES ARE 47.9%. THE DST LOAN IS PAID IN ONE PAYMENT IN THE LAST QUARTER. BEGINNING AND ENDING RESOURCES HAS BEEN ADJUSTED TO EXCLUDE THE $527,891 LONG-TERM LIABILITY FOR THE DST LOAN. AIRPORT FUND SUMMARY Budget Beginning Resources Rents Investment Income Miscellaneous Total Revenues From Fund Balance Total Sources Operating Expenses General Fund Advance DST Fund Loans Capital Outlay Total Uses ITotal Ending Resources Expected Change to Year End: Additional Revenues Addditional Uses 9130121 Ending Resources Projected in 2021 Budget $ $ 479,191 1,065 83,314 563,570 1,288 564,858 $ 380,103 150,000 30,500 4,255 564,858 $ YTD 338,559 269,804 370 21,022 291,196 629,755 191,567 75,000 4,255 270,822 358,933 272,374 (294,036' 337,271 (38,046) 56.3% 34.7% 25.2% 51.7% 0.0% 50.4% 50.0% 0.0% 100.0% 47.9% Beginning Resources Charges for Service Rent Miscellaneous Total Revenues From Fund Balance Pro Shop Sales Pro Shop Purchases Sales vs. Cost of Sales Total Sources Operating Expenses Cart Loan Payments Total Operating Expense General Fund Payment Building Fund Payment Total Uses Total Ending Resources Expected Change to Year End: Additional Sources Additional Uses 9130121 Ending Resources Projected in 2021 Budget 1,387,989 30,000 8,460 1,426,449 7,194 108,172 (70,000) 38,172 1,464,621 $ 1,310,518 $ 56,391 1,366,909 35,000 38,366 1,440,275 $ 24,346 $ $ $ (640,608) 877,355 15,000 5,137 897,492 50,495 (35,426) 15,069 912,561 671,213 32,894 704,107 19,183 723,290 (451,337) 552,060 (716,985) (616,262) (672,196) 63.2% 50.0% 60.7% 62.9% Na 46.7% 50.6% 39.5% 62.3% 51.2% 1 58.3% 51.5% Na 50.0% 50.2% BUILDING FUND ENDING RESOURCES REMAIN AT GOOD LEVELS. THIS EXCLUDES THE STATE MANDATED REBATE PAYABLE AND THE $1,175,140 LONG-TERM ADVANCE DUE FROM THE GOLF COURSE. BUILDING FUND SUMMARY Budget YTD % Beginning Resources Licenses and Permits Charges for Service Fines and Forfeits Miscellaneous Golf Fund Loan Payments Total Revenues From Fund Balance Total Sources Operating Expenses Capital Outlay Contingency Total Uses Total Ending Resources Expected Change to Year End: Additional Revenues Additional Uses 9/30121 Ending Resources Projected in 2021 Budget S . g 840,800 15,300 6.350 18,922 38,366 919,738 34,110 953,848 894,431 46,828 12,589 953,848 $ $ 821,128 554,371 12,956 2.700 9,586 19,183 598.796 598,796 361,687 22,957 384,644 1,035,280 320,942 (569,204) 787,018 754,730 65.9% 34.7% 42.5% 50.7% 50.0% 65.1 % 0.0% 62.8% 40.4% 49.0% n/a 40.3% I CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 03/31/21 201712018 2018/2019 201912020 2020/20201 2020/2021 2020/2021 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET GENERAL FUND TAXES -5,211,563.21 -5,268,302.59 -5,303,644.79 -6,022,156.84 -92148,602.00 65.83% LICENSES & PERMITS -124,179.46 -108,685.36 -109,767.50 -107,946.80 -149,200.00 72.35% INTERGVT'L REVENUE -1,501,709.95 -1,603,158.38 -1,237,231.94 -1,238,720.42 -2,484,751.00 49.85% CHARGES FOR SERVICE -202,582.12 -304,731.29 -295,108.07 -376,017.11 -744,033.00 50.54% FINES AND FORFEITS -25,846.80 -19,096.37 -37,112.49 -19,027.76 -50,900.00 37.38% MISC. REVENUE -151,624.07 -214,810.50 -231,930.64 -79,120.40 -378,600.00 20.90% TRANSFERS IN -362,499.96 -19,999.98 -12,499.98 -75,000.00 -185,000.00 40.54% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -127,266.00 0.00% GENERAL FUND REVENUE -7,580,005.57 -7,538,784.47 -7,227,295.41 -7,917,989.33 -13,268,352.00 59.68% CITY COUNCIL 24,160.05 21,659.04 24,003.75 23,498.67 59,737.00 39.34% CITY MANAGER 127,809.13 135,780.94 127,778.64 132,156.34 292,499.00 45.18% CITY CLERK 117,633.57 91,957.50 125,325.29 100,629.07 217,040.00 46.36% CITY ATTORNEY 47,796.77 53,049.18 94,606.79 88,179.30 201,426.00 43.78% ADMINISTRATIVE SERVICES 327,605.34 347,666.70 356,680.12 338,309.77 707,722.00 47.80% M.I.S. DIVISION 212,854.48 220,172.46 267,227.25 271,863.95 516,961.00 52.59% AUDIO VISUAL -1,747.74 0.00 0.00 0.00 0.00 n/a POLICE ADMINISTRATION 392,459.15 463,006.09 590,288.66 450,812.86 876,121.00 51.46% POLICE PATROL 1,219,237.28 1,909,615.48 1,898,146.99 1,956,988.27 3,555,815.00 55.04% CODE ENFORCEMENT DIVISION 84,809.22 86,392.63 89,775.00 88,224.73 197,439.00 44.68% POLICE INVESTIGATIONS 368,119.98 413,854.32 590,942.41 593,062.76 1,110,496.00 53.41% POLICE COMMUNICATIONS 292,015.72 285,093.21 292,670.38 259,752.72 662,359.00 39.22% ENGINEERING -18,841.15 0.00 0.00 0.00 0.00 n/a ROADS AND DRAINAGE 452,071.00 426,486.84 493,276.75 445,165.01 1,040,937.00 42.77% STORMWATER UTILITY DIVISION 479,511.99 0.00 0.00 0.00 0.00 n/a CENTRAL GARAGE 102,926.68 124,363.35 95,826.89 98,721.39 214,824.00 45.95% FACILITIES MAINTENANCE 188,356.84 184,335.06 260,103.62 277,315.79 648,857.00 42.74% LEISURE SERVICES 428,493.41 532,479.17 508,704.66 460,025.03 1,122,549.00 40.98% CEMETERY 92,777.87 85,938.30 85,806.63 115,771.67 231,522.00 50.00% COMMUNITY DEVELOPMENT 170,796.85 165,213.37 262,962.58 234,386.50 517,184.00 45.32% NON -DEPARTMENTAL 676,708.91 673,443.32 641,598.84 682,271.72 1,094,864.00 62.32% GENERAL FUND EXPENDITURES 5,785,555.35 6,220,506.96 6,805,725.25 6,617,135.55 13,268,352.00 49.87% LOCAL OPTION GAS TAX TAXES -302,575.50 -294,020.08 -306,904.50 -299,793.58 -710,000.00 42.22% INTERGVT'LREVENUE 0.00 0.00 0.00 0.00 -14,105.00 0.00% MISC. REVENUE -2,162.37 -4,015.59 -1,849.05 -303.21 -13,808.00 2.20% TRANSFERS IN 0.00 0.00 0.00 0.00 0.00 n/a FROM FUND BALANCES 0.00 0.00 0.00 0.00 -314,918.00 0.00% LOGT FUND REVENUE -304,737.87 -298,035.67 -308,753.55 -300,096.79 -1,052,831.00 28.50% OPERATING EXPENSES 5,566.62 23,014.10 0.00 87,572.10 92,973.00 94.19% CAPITAL OUTLAY 22,839.30 0.00 105,554.31 34,372.00 169,937.00 20.23% DEBT SERVICE 121,251.10 120,126.80 121,992.80 121,781.20 243,340.00 50.05% TRANSFERS OUT 14,399.31 409,683.00 606,893.40 478,175.24 546,581.00 87.48% TO FUND BALANCES 0.00 0.00 0.00 0.00 0.00 n/a LOCAL OPTION GAS TAX 164,056.33 552,823.90 834,440.51 721,900.54 1,052,831.00 68.57% DISCRETIONARY SALES TAX TAXES -1,386,528.78 -1,438,621.77 -1,477,978.52 -1,532,253.04 -3,581,025.00 42.79% MISC. REVENUE -13,428.47 -41,334.57 -38,046.10 -5,678.42 -89,178.00 6.37% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -10,798,855.00 0.00% DST FUND REVENUE -1,399,957.25 -1,479,956.34 -1,516,024.62 -1,537,931.46 -14,469,058.00 10.63616 OPERATING EXPENSES 0.00 1,500.00 4,080.00 0.00 0.00 n/a TRANSFERS OUT 1,224,106.51 658,589.23 864,599.79 1,157,870.90 13,734,474.00 8.43% TO FUND BALANCES 0.00 0.00 0.00 0.00 734,584.00 0.00% DISCRETIONARY SALES TAX 1,224,106.51 660,089.23 868,679.79 1,157,870.90 14,469,058.00 8.00% CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 03/31/21 2017/2018 2018/2019 2019/2020 2020/20201 2020/2021 202012021 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET RIVERFRONT REDEVELOPMENT FUND MISC. REVENUE -23,352.16 -28,560.44 -22,222.65 -18,587.97 -46,331.00 40.12% TRANSFERS IN -366,531.86 -404,673.34 -403,239.68 -457,671.66 -443,884.00 103.11% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -210,248.00 0.00% RRD REVENUE -389,884.02 -433,233.78 -425,462.33 -476,259.63 -700,463.00 67.99% OPERATING EXPENSES 109,575.08 207,798.65 175,690.04 133,184.39 263,294.00 50.58% CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 n/a GRANTS AND AIDS 15,000.00 0.00 15,000.00 0.00 40,000.00 0.00% TRANSFERS OUT 250,000.00 30,000.00 0.00 74,932.07 252,171.00 29.71% TO FUND BALANCES 0.00 0.00 0.00 0.00 144,998.00 0.00% RRD EXPENDITURES 374,575.08 237,798.65 190,690.04 208,116.46 700,463.00 29.71% PARKING IN LIEU OF FUND MISC. REVENUE -7,233.40 -700.42 -2,012.33 -3,065.01 -4,376.00 70.04% FROM FUND BALANCE 0.00 0.00 0.00 0.00 0.00 n/a PARKING IN LIEU OF REVENUE -7,233.40 -700.42 -2,012.33 -3,065.01 -4,376.00 70.04% CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 n/a TRANSFERS OUT 0.00 0.00 0.00 0.00 0.00 n/a TO FUND BALANCES 0.00 0.00 0.00 0,00 4,376.00 0.00% PARKING IN LIEU OF EXPENDITURES 0.00 0.00 0.00 0.00 4,376.00 0.00% RECREATION IMPACT FEE FUND MISC. REVENUE -62,643.65 -57,009.25 -76,260.34 -86,554.19 -155,000.00 55.84% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -135,317.00 0.00% RECREATION IMPACT FEE REVENUE -62,643.65 -57,009.25 -76,260.34 -86,554.19 -290,317.00 29.81 % OPERATING EXPENSES 0.00 0.00 0.00 0.00 0.00 n/a CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 n/a TRANSFERS OUT 382,950.10 158,025.18 309,483.40 73,010.48 255,317.00 28.60% TO FUND BALANCE 0.00 0.00 0.00 0.00 35,000.00 0.00% RECREATION IMPACT FEE 382,950.10 158,025.18 309,483.40 73,010.48 290,317.00 25.15% STORMWATER UTILITY FUND MISC. REVENUE -911,405.81 -1,829,562.51 -1,807,588.96 -1,816,646.51 -2,084,558.00 87.15% TRANSFERS IN 0.00 0.00 0.00 0.00 0.00 n/a FROM FUND BALANCES 0.00 0.00 0.00 0.00 -280,478.00 0.00% STORMWATER FUND REVENUE -911,405.81 -1,829,562.51 -1,807,588.96 -1,816,646.51 -2,365,036.00 76.81% PERSONAL SERVICES 0.00 395,308.96 315,556.06 326,030.42 708,142.00 46.04% OPERATING EXPENSES 73,258.65 237,405.30 218,528.53 354,713.66 825,511.00 42.97% CAPITAL OUTLAY 0.00 18,198.16 0.00 68,096.48 254,200.00 26.79% TRANSFERS OUT 349,999.98 14,168.50 4,540.00 1,325.00 545,981.00 0.24% TO FUND BALANCES 0.00 0.00 0.00 0.00 31,202.00 0.00% STORMWATER FUND EXPENDITURES 423,258.63 665,080.92 538,624.59 750,165.56 2,365,036.00 31.72% LAW ENFORCEMENT FORFEITURE FUND FINES AND FORFEITS -100.00 -150.00 -83.33 -15,000.00 -16.000.00 93.75% MISC. REVENUE -368.44 -541.74 -283.67 -26.44 -250.00 10.58% FROM FUND BALANCES 0.00 0.00 0.00 0.00 0.00 n/a FORFEITURE REVENUE -468.44 -691.74 -367.00 -15,026.44 -16,250.00 92.47% OPERATING EXPENSES 3,970.99 2,566.04 0.00 1,500.00 0.00 100.00% CAPITAL OUTLAY 0.00 0.00 0.00 15,000.00 15,000.00 100.00% GRANTS AND AIDS 1,500.00 2,500.00 1,000.00 0.00 0.00 100.00% TO FUND BALANCES 0.00 0.00 0.00 0.00 1,250.00 0.00% FORFEITURE FUND EXPENDITURES 5,470.99 5,066.04 1,000.00 16,500.00 16,250.00 101.54% STORMWATER DEBT SERVICE FUND MISC. REVENUE -2,208.48 -3,533.77 -1,981.47 -253.80 -1,000.00 25.38% TRANSFERS IN -201,895.98 -201,457.02 -200,677.50 -200,480.52 -400,961.00 50.00% FROM FUND BALANCES 0.00 0.00 0.00 0.00 0.00 n/a STORMWATER DEBT SERVICE REVENUE -204,104.46 -204,990.79 -202,658.97 -200,734.32 -401,961.00 49.94% DEBT SERVICE 16,538.80 13,329.65 10,068.60 6,764.30 400,529.00 1.69% TO FUND BALANCES 0.00 0.00 0.00 0.00 1,432.00 0.00% STORMWATER DEBT EXPENDITURES 16,538.80 13,329.65 10,068.60 6,764.30 401,961.00 1.68% CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 03/31/21 2017/2018 201812019 2019/2020 2020120201 2020/2021 2020/2021 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET GOLF COURSE FUND INTERGOVERMENTAL REVENUE -50,000.00 0.00 0.00 0.00 0.00 n/a CHARGES FOR SERVICE -808,287.63 -937,526.73 -935,142.42 -892,424.57 -1,464,621.00 60.93% MISC. REVENUE -53,841.34 -19,655.33 -20,823.52 -20,136.86 -38,460.00 52.36% TRANSFERS IN -11,320.00 0.00 0.00 0.00 0.00 n/a FROM FUND BALANCES 0.00 0.00 0.00 0.00 -9,576.00 0.00% GOLF COURSE FUND REVENUE -923,448.97 -957,182.06 -955,965.94 -912,561.43 -1,512,657.00 60.33% ADMINISTRATION 612,548.24 370,278.53 353,219.62 356,339.10 756,020,00 47.13% MAINTENANCE 282,849.53 284,299.83 288,538.03 284,893.81 602,483.00 47.29% GOLF COURSE CARTS 101,051.52 84,218.95 82,793.15 82,056.67 154,154.00 53.23% GOLF COURSE FUND EXPENSES 996,449.29 738,797.31 724,550.80 723,289.58 1,512,657.00 47.82% AIRPORT FUND CHARGES FOR SERVICE -10,121.85 -12,277.83 0.00 0.00 0.00 n/a MISC. REVENUE -257,712.63 -318,171.89 -281,452.69 -291,195.87 -563,570.00 51.67% TRANSFERS IN 0.00 0.00 -4,691.00 0.00 0.00 n/a FROM FUND BALANCES 0.00 0.00 0.00 0.00 -1,690.00 0.00% AIRPORT FUND REVENUE -267,834.48 -330,449.72 -286,143.69 -291,195.87 -565,260.00 51.52% PERSONAL SERVICES 77,947.21 66,170.97 33,059.95 33,524.89 71,578.00 46.84% OPERATING EXPENSES 117,417.80 163.170.47 148.529.69 158,042.15 308,927.00 51.16% CAPITAL OUTLAY 0.00 18,628.82 5,125.33 0.00 4,255.00 0.00% DEBT SERVICE 0.00 0.00 0.00 0.00 30,500.00 0.00% TRANSFERS OUT 12,499.98 19,999.98 12,499.98 75,000.00 150,000.00 50.00% TO FUND BALANCES 0.00 0.00 0.00 0.00 0.00 n/a AIRPORT FUND EXPENSES 207,864.99 267,970.24 199,214.95 266,567.04 565,260.00 47.16% BUILDING FUND LICENSES & PERMITS -419,589.85 -386,430.08 -439,001.85 -554,370.66 -840,800.00 65.93% CHARGES FOR SERVICE -6,478.83 -5,661.90 -8,139.10 -12,956.10 -15,300.00 84.68% FINES AND FORFEITS -3,111.00 -4,255.00 -3,098.00 -2,700.00 -6,350.00 42.52% MISC. REVENUE -4,650.38 -8,061.54 -7,063.06 -9,586.19 -18,922.00 50.66% TRANSFERS IN 0.00 -19,183.98 -19,183.98 -19,183.02 -38,366.00 50.00% FROM FUND BALANCE 0.00 0.00 0.00 0.00 -37,861.00 0.00% BUILDING FUND REVENUES -433,830.06 -423,592.50 -476,485.99 -598,795.97 -957,599.00 62.53% PERSONAL SERVICES 239,626.83 267,170.03 282,283.14 284,569.75 745,793.00 38.16% OPERATING EXPENSES 42,641.16 46,477.24 71,019.81 77,117.42 152,260.00 50.65% CAPITAL OUTLAY 0.00 0.00 0.00 234.51 46,957.00 0.50% TRANSFERS OUT 0.00 0.00 0.00 0.00 12,589.00 0.00% TO FUND BALANCES 0.00 0.00 0.00 0.00 0.00 n/a BUILDING FUND EXPENSES 282,267.99 313,647.27 353,302.95 361,921.68 957,599.00 37.790% CITY OF SEBASTIAN GENERAL FUND DEPARTMENTS QUARTER ENDING 03/31/21 CITY COUNCIL PERSONAL SERVICES OPERATING EXPENSES TOTAL CITY MANAGER PERSONAL SERVICES OPERATING EXPENSES TOTAL CITY CLERK PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTAL CITY ATTORNEY PERSONAL SERVICES OPERATING EXPENSES TOTAL ADMINISTRATIVE SERVICES PERSONAL SERVICES OPERATING EXPENSES TOTAL M.I.S. DIVISION PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTAL AUDIO VISUAL DIVISION PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTAL POLICE ADMINISTRATION PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTAL POLICE PATROL PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTAL CODE ENFORCEMENT DIVISION PERSONAL SERVICES OPERATING EXPENSES TOTAL POLICE INVESTIGATIONS PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTAL 2017/2018 2018/2019 2019/2020 202012021 2nd QTR 2nd QTR 2nd QTR 2nd QTR ACTUALS ACTUALS ACTUALS ACTUALS 11,373.06 11,379.73 11,373.77 11,376.58 12,786.99 10,279.31 12,629.98 12,122.09 24,160.05 21,659.04 24,003.75 23,498.67 124,569.14 130,687.25 120, 674.26 126,851.75 3,239.99 5,093.69 7,104.38 5,304.59 127, 809.13 135, 780.94 127, 778.64 132,156.34 2020/2021 202012021 ANNUAL PERCENT BUDGET OF BUDGET 22,732.00 50.05% 37,005,00 32.76% 59,737.00 39.34% 275,407.00 46.06% 17,092.00 31.04% 292,499.00 45.18% 74,633.17 77,990.37 80,543.55 84,425.18 184,750.00 45.70% 43,000.40 13,967.13 44,781.74 16,203.89 29,980.00 54.05% 0.00 0.00 0.00 0.00 2,310.00 0.00% 117,633.57 91,957.50 125,325.29 100,629.07 217,040.00 46.36% 0.00 0.00 13,339.02 75,393.26 164,039.00 45.96% 47,796.77 53,049.18 81,267.77 12,786.04 37,387.00 34.20% 47,796.77 53,049.18 94,606.79 88,179.30 201,426.00 43.78% 243,205.62 261,776.03 258,747.97 240,689.21 562,649.00 42.78% 84,399.72 85,890.67 97,932.15 97,620.56 145,073.00 67.29% 327,605.34 347,666.70 356,680.12 338,309.77 707,722.00 47.80% 120,924.30 139,875.56 162,827.07 158,408.48 358,104.00 44.24% 91,930.18 80,296.90 103,488.07 113,455.47 158,857.00 71.42% 0.00 0.00 912.11 0.00 0.00 n/a 212,854.48 220,172.46 267,227.25 271,863.95 516,961.00 52.59% -678.08 0.00 0.00 0.00 0.00 n/a -1,069.66 0.00 0.00 0.00 0.00 n/a 0.00 0.00 0.00 0.00 0.00 n/a -1,747.74 0.00 0.00 0.00 0.00 n/a 315,270.66 382,256.03 483,011.15 370,311.96 740,467.00 50.01 % 77,188.49 80,750.06 87,583.51 80,500.90 135,654.00 59.34% 0.00 0.00 19,694.00 0.00 0.00 n/a 392,459.15 463,006.09 590,288.66 450,812.86 876,121.00 51.46% 1,089,906.35 1,742,333.62 1,743,401.76 1,817,645.56 3,206,256.00 56.69% 116,968.94 159,282.87 122,187.36 126,959.97 328,641.00 38.63% 12,361.99 7,998.99 32,557.87 12,382.74 20,918.00 59.20% 1,219,237.28 1,909,615.48 1,898,146.99 1,956,988.27 3,555,815.00 55.04% 76,015.76 78,884.61 81,275.22 81,047.16 176,731.00 45.86% 8,793.46 7,508.02 8,499.78 7,177.57 20,708.00 34.66% 84,809.22 86,392.63 89,775.00 88,224.73 197,439.00 44.68% 317,560.77 347,441.16 497,194.28 510,994.62 952,417.00 53.65% 50,559.21 56,418.16 66,638.95 72,568.14 147,479.00 49.21 % 0.00 9,995.00 27,109.28 9,500.00 10,600.00 89.62% 368,119.98 413,854.32 590,942.51 593,062.76 1,110,496.00 53.41% CITY OF SEBASTIAN GENERAL FUND DEPARTMENTS QUARTER ENDING 03/31/21 201712018 2018/2019 201912020 201912020 2019/2020 2019/2020 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET POLICE COMMUNICATIONS PERSONAL SERVICES 287,088.21 280,732.55 286,426.03 255,469.30 648,523.00 39.39% OPERATING EXPENSES 4,927.51 4,360.66 6,244.35 4,283.42 13,836.00 30.96% TOTAL 292,015.72 285,093.21 292,670.38 259,752.72 662,359.00 39.22% ENGINEERING PERSONAL SERVICES -2,422.90 0.00 0.00 0.00 0.00 n/a OPERATING EXPENSES -16,418.25 0.00 0.00 0.00 0.00 n/a CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 n/a TOTAL -18,841.15 0.00 0.00 0.00 0.00 n/a ROADS AND DRAINAGE PERSONAL SERVICES 254,577.14 231,545.76 275,401.18 292,176.01 623,386.00 46.87% OPERATING EXPENSES 189,949.86 173,992.23 178,685.32 150,087.01 371,218.00 40.43% CAPITAL OUTLAY 7,544.00 20,948.85 39,190.25 2,901.99 46,333.00 6.26% TOTAL 452,071.00 426,486.84 493,276.75 445,165.01 1,040,937.00 42.77% STORMWATER UTILITY DIVISION PERSONAL SERVICES 270,606.69 0.00 0.00 0.00 0.00 n/a OPERATING EXPENSES 207,918.30 0.00 0.00 0.00 0.00 n/a CAPITAL OUTLAY 987.00 0.00 0.00 0.00 0.00 n/a TOTAL 479,511.99 0.00 0.00 0.00 0.00 n/a CENTRAL GARAGE PERSONAL SERVICES 88,458.36 101,391.03 86,048.11 87,953.59 189,384.00 46.44% OPERATING EXPENSES 14,468.32 13,377.31 9,778.78 10,767.80 22,940.00 46.94% CAPITAL OUTLAY 0.00 9,595.01 0.00 0.00 2,500.00 n/a TOTAL 102,926.68 124,363.35 95,826.89 98,721.39 214,824.00 45.95% FACILITIES MAINTENANCE PERSONAL SERVICES 51,279.45 78,723.27 132,957.41 137,884.19 290,597.00 47.45% OPERATING EXPENSES 87,093.89 100,906.79 111,774.21 122,810.60 280,575.00 43.77% CAPITAL OUTLAY 49,983.50 4,705.00 15,372.00 16,621.00 77,685.00 21.40% TOTAL 188,356.84 184,335.06 260,103.62 277,315.79 648,857.00 42.74% LEISURE SERVICES PERSONAL SERVICES 240,364.41 343,436.38 357,528.81 330,031.59 802,159.00 41.14% OPERATING EXPENSES 186,779.00 110,972.89 101,781.25 116,030.68 264,467.00 43.87% CAPITAL OUTLAY 1,350.00 78,069.90 49,394.60 13,962.76 55,923.00 24.97% TOTAL 428,493.41 532,479.17 508,704.66 460,025.03 1,122,549.00 40.98% CEMETERY PERSONAL SERVICES 72,003.82 70,083.19 74,906.17 103,254.60 176,307.00 58.57% OPERATING EXPENSES 12,283.09 15,855.11 10,900.46 12,517.07 35,215.00 35.54% CAPITAL OUTLAY 8,490.96 0.00 0.00 0.00 20,000.00 0.00% TOTAL 92,777.87 85,938.30 85,806.63 115,771.67 231,522.00 50.00% COMMUNITY DEVELOPMENT PERSONAL SERVICES 158,066.02 153,534.82 173,435.31 200,967.26 434,559.00 46.25% OPERATING EXPENSES 12,730.83 11,678.55 74,877.77 33,419.24 71,314.00 46.86% CAPITAL OUTLAY 0.00 0.00 14,649.50 0.00 11,311.00 0.00% TOTAL 170,796.85 165,213.37 262,962.58 234,386.50 517,184.00 45.32% NON -DEPARTMENTAL PERSONAL SERVICES 143,192.45 155,141.20 125,484.28 129,753.74 232,289.00 55.86% OPERATING EXPENSES 464,279.02 497,845.12 511,423.56 546,854.98 737,061.00 74.19% CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 n/a TRANSFERS TO OTHER FUNDS 69,237.44 20,457.00 4,691.00 5,663.00 20,500.00 27.62% TO FUND BALANCES 0.00 0.00 0.00 0.00 105,014.00 0.00% TOTAL 676,708.91 673,443.32 641,598.84 682,271.72 1,094,864.00 62.32% GENERAL FUND EXPENDITURES 5,785,555.35 6,220,506.96 6,805,725.35 6,617,135.55 13,268,352.00 49.87% 0 CITY OF SEBASTIAN CAPITAL PROJECT STATUS REPORT AS OF MARCH 31, 2021 Current Prior Project Budget Share Project Year Year Expenditures Percent Funds Number Description Budeet Sources 1 in Thousands of $s Budge t Expenditures Expenditures To Date Expended Encumbrances Remainine FY2018 A1823 Cemetery Improvements CTF 150 150,000 51,519 17,909 69,428 46.29% 76,214 4,358 A1824 Working Waterfront Phase DST 26 25,700 4,710 20,300 25,010 97.32% 690 - A1860 Stonecrop Drainage DST 11 11,229 11,229 11,229 100.00% - TOTAL $ 186,929 $ 56,229 S 49,438 $ 105,667 56.53 % S 76,904 S 4,358 FY2019 A1920 Working Waterfront Phase 3 FIND/DON/GF/DST/CRA/PILO 170/30/15/273/45/13 545,793 411,838 20,990 432,828 79.30% 108,693 4,272 A1921 Pickleball DST/RIF 197/423 619,762 359 604,751 605,110 97.64% - 14,652 A1925 Park Signage DST/RIF 441155 199,000 53,165 53270 106,435 53.48% 92,565 - A1960 Stonecrop Drainage DST 12 12,000 - 12,000 12,000 100.00% - - A1952 Construct Hangar FDOT/DST 1,8001450 2,250,000 58,222 234,096 292,317 12.99% 318,361 1,639,321 TOTAL $ 3,626,555 S 523,584 $ 925,107 S 1,448,690 40 % $ 519,619 S 1,658,245 FY2020 A2004 PD Vehicles & Equipment (Complete) DST 339 339,226 - 339,226 339,226 100.00% - A2006 Evidence Compound Paving & Carport DST 40 40,000 10,046 129 10,175 25.44% 22,367 7,458 A2007 CDBG Grant Program CDBG 250.7 250,769 4,898 13,720 18,618 7.42% 30,822 201,329 A2008 COVID-19 Expenses Grant 1074 1,074,322 488,251 506,692 994,943 92.61 % 37,118 42,261 A2009 CDBG CARES Act Grant Program CDBG 74.8 74,778 - 1,246 1,246 1.67% - 73,532 A2021 BSSC Baseball Dugouts RIF 80 80,000 16,174 20,085 36,259 45.32% - 43,741 A2024 Park Improvements (Complete) RIF(DON 12.6/2.5 15,111 3,672 11,439 15,111 100.00% - - A2025 Community Center Office DST 40 40,000 - - - 0.00% - 40,000 A2026 Renovate Golf Tees DST 50 50,000 951 30,603 31,554 63.11% 18,446 A2028 Riverview Park Sidewalks (Complete) LOOT / CPA 46.5132 78,623 70,832 7,790 78,622 100.00% - 1 A2029 CPA Signage & landscape CRA 113 113,000 40,680 13,448 54,128 47.90% 45,872 13,000 A2030 Relocate Public Facilities Compound DST 9639.3 9,639,316 239,961 244,859 484,820 5.03 % 712,280 8,442,216 A2050 Construct Taxi Lane FAA/FDOT/DST 658/36.5/36.5 731,046 19,618 40,404 60,022 8.21 % 9,861 661,164 A2060 Roadway Swale Work SW 60 60,000 - 25,865 25,865 43.11% 34,135 - A2061 Canal Improvements SW 1000 1,000,000 - - - 0.00% - 1,000,000 A2062 Stonecrop Drainage FEMA/DST 645/215 860,000 5,300 12,616 17,916 2.08% - 842,084 A2063 Septic to Sewer Grant Program IRLC/CRA 1001100 200,000 4,378 48,947 53,225 26.61 % - 146,775 $ 14,646,191 S 904,760 $ 1,316,970 $ 2,221,730 15.17% $ 892,455 $ 11,532,006 FY2021 A2100 Server/Host Update (Complete) DST 432 43,195 43,195 - 43,195 100.00% - - A2101 Citywide Computers DST 35 35,000 10,625 - 10,625 30.36% - 24,375 A2102 Audio/Visual Equipment DST 75 75,000 66,609 - 66,609 88.81% 8,287 104 A2103 COSty Equipment DST 10 10,000 581 - 581 5.81 % 6,815 2,604 A2104 Phone System DST 100 100,000 - - 0.00% - 100,000 A2105 Network Infrastructure DST 39 39,000 33,728 - 33,728 86.48% - 5,272 A2106 Police Vehicles & Equipment DST 350 349,982 - - - 0.001/. 318,348 31,634 A2120 BSSC Lightning System (Complete) OF/DST 5.7124 29,663 29,663 - 29,663 100.00% - - A2121 Harrison Street Park Plaza DST 270 270,000 - - - 0.00% 270,000 A2122 N. Central Ave Event Plaza DST 40 40,000 - - - 0.00"/ - 40,000 A2123 Tree Protection Plan DST 135 135,000 - - - 0.00% - 135,000 A2124 Playground improvements RIF 70 70,000 - - - 0.00% - 70,000 A2125 Park Improvements RIF 20 10,000 - - - 0.00% 20,000 A2130 Street Repaving LOGT 3382 338,227 325,681 - 325,681 96.29% 11,136 1,410 A2131 Sidewalk Replacement LOGT 55.8 55,860 - - 0.00% - 55,860 A2132 Street Reconstruction (Complete) LOGT/DST 105.91500 605,913 605,912 - 605,912 100.00% - I A2133 Truckw/Crane DST 65 65,000 - - 0.00% 61,098 3,902 A2160 Roadway Swales/Driveways SW 100 100,000 - - - 0.00% - 100,000 A2161 Stormwater Master Plan SW 100 200,000 - - - 0.00% - 200,000 A2162 Sliplining DST 100 100,000 - - - OAo% 96,720 3,280 A2150 Establish Sewer Service FDOT/DST 800/200 1,000,000 - - - 0.00% - 1.000,000 A2151 Square Hangar Engineering FDOT/DST 222/55.5 277,516 16,266 - 16,266 5.86% 33,776 227,474 3,959,356 1,132,261 - 1,132,261 28.60 % 536,181 2,290,915 GRAND TOTAL $ 22,419,031 S 2,616,834 $ 2,291,514 $ 4,908,348 21.89 % $ 2,025,159 $ 15,485,524 QUARTERLY INVESTMENT REPORT FOR THE QUARTER ENDED MARCH 31, 2021 At March 31, 2021, the total of the City's cash and investments were $20,671,022.61. Of this, $16,234,303.46 was held in an interest bearing checking account at Seacoast National Bank, $3,889,860.08 was invested with the State Board of Administration and $546,859.07 is deposited with Florida Trust, which invest in short-term bonds. The City did not purchase any new securities during the quarter and does not hold any direct investments in government securities. Returns at the end of the quarter were .25% for the Bank and .15% for the State Board. The average annualized return over the 3 months of this quarter from the deposit with Florida Trust was 3.30%. The Bank returns and State Board continue to drop primarily due to reactions of the bond market and Federal Reserve. SEACOAST NATIONAL BANK STATE BOARD OF ADMINISTRATION (SBA) CURRENT CURRENT CASH BALANCE ALLOCATION BALANCE PERCENT INVESTMENT ALLOCATION BALANCE PERCENT General Fund $ 5,464,749.85 36.05% General Fund $ 602376.85 15.48% Local Option Gas Tax Fund (33,401.10) -0.22% Local Option Gas Tax Fund - 0.00% Discretionary Sales Tax Fund 5,311,905.07 35.04% Discretionary Sales Tax Fund 1,325,351.97 34.06% Riverfront Redevelopment Fund 598,210.10 3.95% Riverfront Redevelopment Fund 149,541.46 3.84°% Parking In -Lieu -Of Fund - 0.00% Parking In -Lieu -Of Fund 63,748.53 1.64% Recreation Impact Fee Fund 142,049.69 0.94% Recreation Impact Fee Fund 35,538.28 0.91 % Stormwater Utility Fund 1,970,001.82 12.99% Stormwater Utility Fund 492,384.31 12.65% Law Enforcement Forfeiture Fund 0.00% Law Enforcement Forfeiture Fund 31,308.41 0.80% Stormwater Series 2003 Debt Service Fund 110,607.41 0.73 % Stormwater Series 2003 Debt Service Fund - 0.00% Capital Projects Fund (169,763.55) -1.12% Capital Projects Fund 0.00% Capital Improvements Fund (271,073.65) -1.79% Capital Improvements Fund 0.00% Transportation Fund (0.10) 0.00% Transportation Fund 0.00% Stormwater Projects Fund 245,572.10 1.62% Stormwater Projects Fund 0.00% Golf Course Fund 253,743.86 1.67% Golf Course Fund 0.00% Airport Fund 367,051.16 2.42% Airport Fund 0.00% Airport Projects Fund 79,084.53 0.52% Airport Projects Fund - 0.000% Building Department Fund 943,493.93 6.22% Building Department Fund 235,330.68 6.05% Cemetery Trust Fund 147,424.66 0.97% Cemetery Trust Fund 863,543.18 22.19% Performance Deposits Fund 750.00 0.00% Performance Deposits Fund 92,340.00 2.37% Total Bank Balance S 15,160,405.78 100.00 % Total SBA Balance S 3,891,463.67 100.00% Fund Making Loans GENERALFUND: Due from Golf Course Due from Airport Fund DISCRETIONARY SALES TAX: Due from Airport Fund Due from Airport Fund Purpose Cash Flow Loan Grant Match Loan $285,000 Hangar A $267,511 Hangar B INTERFUND LOANS REPORT 10/01/20 Scheduled Balance at Balance Payments 03/30/2021 Remarks/Terms $500,000 None $500,000 Pay $35K/Year or More Starting FY 20/21. $150,000 None $75,000 Pay $150K in FY 20/21. $269,245 $18,000 $259,869 $12,500 BUILDING FUND: Due from Golf Course $700,000 Irrigation $615,456 $30,547 Due from Golf Course $559,684 Other Repairs $559,684 None $261,966 5 Years @ 3%, Then 4%for 25 Years. $257,764 5 Years @ 3%, Then 4%for 25 Years. $596,273 20 Years, Each 5 Years Adjust to T-Bond Minus 1%. $559,684 Pay When Possible, Maybe After $700,000 is paid. 0"0' HOME OF PELICAN ISLAND To: Mayor and City Council Thru: Paul Carlisle, City Manager From: Kenneth W. Killgore, Administrative Services Director Date: May 26, 2021 Re: 20' Quarter Accomplishments Fiscal Year 2021 The following are the 2na Quarter Accomplishments for City Departments as assembled and edited by the Administrative Services Department for the three months ended March 31, 2021. CITY CLERK Legislative Sunvort Matters • City Clerk prepared agenda, attended/recorded six Regular City Council meetings. • Completed follow up of approved Council matters — contracts, letters, e-mails, scanned to LF and indexed. • Six resolutions adopted by Council. • One ordinance adopted by Council. • Two ordinances passed on first reading. • Six proclamations prepared for presentation by Council Members. • Provided monthly City calendars and revisions to Council, city staff and press. • Four advertisements placed with TCPahn. • Coordinated attendance of clergy for Council meeting invocations. Records Management Proeram • Responded to 56 public records requests. • 63 cubic feet of paper records met retention along with duplicate and OSA records destroyed by shredding vendor. • Documents, maps, & surveys of stormwater, streets and personnel files were imported into Laserfiche for permanent and long term record. • Transferred and documented three bid records for storage. Election Matters • Assisted SOE with 2021 polling location changes. Ci1v Board Matters • Noticed vacancies, prepared five board appointments, notified and provided info to appointees, updated Board Handbook. • City Clerk prepared agenda, attended/recorded three CRA and one and one CRA Workshop. • City Clerk prepared agenda, attended/recorded four Charter Review Committee meetings. • Records Specialist was the facilitator at four Charter Review Committee meetings. • Records Specialist published all scanned City board packets to City website and Laserfiche and provided to press and Council. • Coordinated board/committee meeting minutes between staff and technical writer. Cemetery Matters • Certificates of Interment Rights issued for 21 locations for a total of $31,300. • Scanned all cemetery records as sold or amended for permanent retention. Personnel/Educational Matters • Records Specialist attended two Project Management meetings. • Administered oath to two Police Officers. • City Clerk attended Leadership Training on March 15, 2021. • Coordinated carpet replacement with Facilities Maintenance, MIS Division. • Packed offices for furniture removal to replace carpet. Communitv Matters Responded to or forwarded CITYSEB emails to appropriate departments. Coordinated use of Chambers for FDOT public workshop. Coordinated use of Chambers for IRC North County Septic to Sewer public workshop. ADMINISTRATIVE SERVICES • Provided administrative support to the Police Pension Board. • Worked with Auditors to complete the FY2020 audit and prepare the financial statements. • Submitted the FY2020 Comprehensive Annual Financial Report to the Government Finance Officers Awards Program. • Prepared various other mandated State and Federal reports on the fiscal year ending September 30, 2020. • Assisted with negotiations of wage opener in accordance with the PEA and PBA Labor Agreements. • Developed the budget calendar for events that will keep preparation of the FU2022 budget on schedule. • Prepared 1 st Quarter Budget Amendment and made presentation to Budget Committee and City Council. • Finalized payments from CARES ACT on the Rental and Mortgage Assistance Grant Program. • Processed additional $2,000 payments for CARES ACT Small Business Grant Program. • Handled normal processing of payroll, accounts payable and cashiering. Monitored and approved payments on major contracts. • Maintained listing of current capital projects and held frequent meetings with project managers to monitor progress. • Coordinated the quarterly employee investment meetings with the ICMA representative. • Monitored and completed required grant paperwork on Airport and other grants. • Recruited, interviewed and hired replacements for vacant positions. • Documented bids and proposals for purchases to insure purchasing policies were followed. • Reviewed and approved agenda items for contracts and other payments requiring City Council approval. POLICE DEPARTMENT Administration • Continued review of agency policies per accreditation standards. • Participated in Tim Tebow's Night to Shine with Special Needs individuals. • Conducted interviews for 911 dispatcher positions. • Attended 5 ZOOM Meetings (Crime Lab, SAC, And Executive Roundtable). • Continued our quarterly auditing and inspection of the police building and equipment. • Command Staff members attended 6 Council meetings. • Responded to 2 public records request. • Participated in CAD/RMS software & BWC/Video Camera demonstrations. • Swore in 2 new officers. • Attended leadership training at Florida Police Chiefs Conference. • Participated in 2 strategic planning meetings. • Completed 3 leadership meetings and several (weekly) staff meetings. • Compiled and submitted 2021 CIP. • Held 4 hour leadership training in Council Chambers for City leadership. Volunteers • The Community Service Volunteers worked a total of 614.50 hours during this quarter. • 65 bank deposit details were made. This service is done for City Hall so employees do not have to leave their assigned duties. • 0 traffic control details were assigned. These consist of directing traffic at city events, road closures, etc. • 146 house watches/close patrols were completed. • 35 vehicle transports were made consisting of taking the vehicles to different locations for repairs, etc. • 192 business checks were made. These business checks are conducted to help patrol officers keep an eye on the business community which helps reduce crime. • 65 area checks of banks were made. Visual marked units around the banks at various times helps to deter crime. • 20 Airport checks were made. The visibility helps to deter crime. • 20 special details were assigned. • 14 miscellaneous assists for law enforcement personnel. • 41 paper runs, i.e.: State Attorney's Office, Sheriff's Office, etc. The volunteers pick up and deliver packages such as council packages, State Attorney paperwork, and miscellaneous items as needed. • Assisted with traffic control on 2 traffic crash scene. • 14 citizen contacts. • 146 miscellaneous jobs. 0 8 Escorts were completed. School Resource Officers January lstthru March 31, 2021 Area/school checks 119 118 120 357 Life Skills classes taught 0 3 5 8 Reports 1 1 4 6 (Crossing Guard contacts 10 28 18 56 f Mentors lunches 12 13 12 39 Patrol hours 8 8 32 48 ICommunty event hours 2 13 14 29 Communty event hours P Patrol hours Mentors lunches Crossing Guard contacts Reports Life Skills classes taught Area/school checks 0 20 40 60 80 100 120 140 March 1B Feb. 9 Jan. Road Patrol and Special Operations • Officers were dispatched to 5749 calls for service, and self -initiated 3452 events. • 79 adult and 6 juvenile arrests were made. • 0 Juvenile Civil Citations were issued. • Officers issued 221 citations, 2 parking citations, and 399 written warnings. • Officers completed 485 offense reports and 90 crash reports. Special Operations Citations Warnings Incident Reports Arrests Traffic Officer 59 123 20 3 Marine* 1 3 0 0 K-9 Unit • K-9 Training Hours: 210 • Misdemeanor Arrests: 2 • Felony Arrests: 10 • Narcotic Searches: 16 • Activity Reports: 4 • K-9 Demonstrations: 1 • Schools Attended: 0 • Additional Training Hours: 400 hour K9 Patrol School. • Agency Assisted: Indian River and Brevard County. 3 Detectives January 1st thru March 31, 2021 Arrests 2 1 3 6 Warrants 2 0 7 9 Training/Meeting Hours 6 70 47.75 123.75 Follow -Ups EMMR 14 22 38 74 Active Cases 15 26 25 66 Assigned Cases 14 18 17 49 Cleared Cases 4 8 9 21 Inactive Cases 4 6 13 23 Supplements 15 27 33 75 Call Outs 4 0 3 7 Background/Rpo 3 2 1 6 Call Outs r I Supplements i0mr Inactive Cases Cleared Cases Assigned Cases ®° Series4 Active Cases mIgn j I 0 Series3 Follow -Ups ll�� Series2 Training/Meeting Hours a Seriesl Warrants Arrests b Subpoenas 0 50 100 150 4 COPE QUARTERLY REPORT ACTIVITY HOURS COMMUNITY EVENTS 19 AGENCY OUTREACH 10 EVENTS COMMUNITY MEETINGS 27 SCHOOL -RELATED EVENTS � 2 PUBLIC TRAINING CLASSES 0 REGIONAL OUTREACH j 0 SRO Coverage EXPLORER POST ACTIVITIES TRAINING AND SCHOOLS IN-SERVICE INSTRUCTION SOCIAL MEDIA MANAGEMENT ADMINISTRATION & RESEARCH ROAD PATROL COVERAGE Communications Division 16 0 7 0 Community Events: Jr. Bluewater Open - 3 COVI D Test Site - 5 Triathalon - 6 Light Up Night - 9 Honor Special Needs Student - 3 Christmas Parade - 9 Lip Sync Battle -10 Bell Ringing - 3 Public Training Classes: RAD Women - 0 Active Shooter - 0 SAFE Women - 0 Refuse to be a victim - 0 Agency Outreach: 24 Movie Night -10 Community Night Out-0 6 Turkey Drive - 0 Toy Drive - 0 0 Shop w/ a Cop - 0 Community Meetings: j Training and Schools: Exchange Club -6 In Service - 6 Tobacco Free - 6 Below 100 - 0 Veteran's Councl Humvee -1 SAFIR 2aor�r 14 Admin & Research: School Rltated Events: Pension Board - 0 SCO, I. Special Events - 0 5r. bastia� `� Awards - 0 COPE Meeting - 6 "I Banquet-0 gional Outreach: Lip Sync Video - 0 irrit S OPL)us -{i rrh Run 0 Social Media Management: SRO: -16 {Facebook, Twitter, Road Coverage -0 Instagram} - 24 Honor Guard - 0 In -Service Inst Explorer Post 1 Vehicle Ops 0 Activities: 0 I Disp. Calls For Service 1,437 1,369 1,555 4,359 Officer Initiated Calls 1,230 1,373 965 3,568 Code Enf. Initiated Calls 1,292 1,810 2,094 5,196 Volunteer Initiated Calls 117 103 160 380 Calls Entered Into CAD 4,116 4,709 4,834 13,659 911 Calls Received 765 726 849 2,340 911 Calls Transferred Out 319 284 356 959 911 Hang-up Calls 100 94 110 291 Admin. Calls Received 616 585 678 1,879 Admin. Calls Transferred N/A N/A N/A N/A Outgoing Admin. Calls NA NA NA NA Training/Meeting Hours 18 18 18 54 911 NETWORK DOWN UNABLE TO PULL NUMBERS DIRECTLY FRC M THE PHONE SYSTEM. THE TOTAL CALLS ARE COMING FROM CAD WHICH DOES NOT INCLUDE THE IN HOUSE CALLS OR OUTGOING Training/Meeting Hours Outgoing Admin. Calls Admin. Calls Transferred Admin. Calls Received 911 Hang-up Calls 911 Calls Transferred Out 911 Calls Received Calls Entered Into CAD Volunteer Initiated Calls Code Enf. Initiated Calls Officer Initiated Calls Disp. Calls For Service 0 1,000 2,000 3,000 4,000 5,000 6,000 Month 3 ■ Month 2 r- Month 1 5 Crime Scene/Evidence Items Received 95 70 ' 102 267 Evidence Processed In-house 5 12 38 55 Evidence Outsourced 5 12 11 28 Items Returned 14 24 23 61 Items Purged 47 142 108 297 Cars Impounded 0 0 0 0 Video Redaction Hours 66 60 42 168 Videos Burned 82 78 64 224 Supplements Written 12 4 6 22 Evidence Processing Hours 22 85 77 184 Crime Scene Processing Hours 3 7 24 34 Training Hours 3 0 0 3 Call Outs 1 2 4 7 Cal I Outs 'Training Hours Crime Scene Processing Hours Evidence Processing Hours - F Supplements Written Videos Burned Video Redaction Hours Cars Impounded Items Purged -- Items Returned Evidence Outsourced Evidence Processed In-house or i Items Received IIr 0 20 40 60 80 100 120 140 160 Mar ■ Feb R Jan Code Enforcement Of the 5,213 code calls for the quarter the following is a breakdown of some specific calls made: • Issued 345 written warnings. This range from grass and weeds too high, trailers parked in front of the property line, trash and debris, yard sale permits, overgrowth of adjoining lot, no permit for a fence install, etc. • 154 property inspections for title companies and 67 sign violations. • 631 Code Services. • 522 re -inspections, 57 violations were not complied with, 78 were posted for abatement, 14 abated by vendors. • 378 violations complied. • 1 Liens filed, 8 liens released. • 66 violation letters sent for various reasons such as grass and weeds too tall, trash and debris, overgrown lots, etc. in an attempt to gain compliance. • There were no calls for water violation during the second quarter. Alarm Assessment • $310.00 in alarm permits (new and renew) • $100.00 in false alarms fines • 110 alarm responses by officers, 51 of these were false. • 1 New permits issued. 6 ROADS Asphalt • Put down 47 tons of asphalt throughout the city at various potholes , road crossing etc. Concrete • Removal of old concrete at twin pier due to sinking causing trip hazard, regarded dirt, forming and re -pouring. • Poured head walls at Evernia and Tarpon road crossings for SW. • Poured 10 yards of concrete at ball fields for phase 2 of dug out replacement. Right of Wav Mowing • Mowed right of ways throughout the city removing sight obstructions and clearing way for drainage on vacant lots. Miscellaneous • Assisted in demolition of old dug out for phase 2. • Assisted in setting up new poles for dug outs and formed pads for concrete. • Assisted SW in clearing the Wimbrow dam of vegetation and removal of center island. • Trimmed hedges on Powerline Road and weed eated curbing. • Weed eated curb and gutter on Main St in front of City Hall. • Assisted sign shop with restriping Main St. and in taping off runway at the Airport for painting. • Regraded millings in Easy St. parking lot and also overflow parking on river. • Took loads of scrap metal from compound to Mr. Scrap. • Assisted SW with the road crossing replacements at Arcardia and also Crowberry. Road Crossing at Evernia as well. • Removed fallen tree limb from Laconia and Gladiola blocking stop sign. • Hauled in multiple loads dirt and sand to Cemetery for center of new circular road addition. Sien Shop • Signage and Installation: • Created: 1,061 • Signs Installed: 210 • Signs straightened 8 • Decals: 9 • Traffic Studies: 6 • GIS Locations: 210 • Pavement Markings • Stop Bars 3 • Yellow Line Striping 2,549 Ln. ft. • White Line Striping 2,759 Ln. ft. • Parking Lots 0 • Cross Walks 0 • Handicap stalls: 0 • ADA Mats painted 0 • Blue paint 0 • Special Projects: • Street/Stop sign install zone 3: Completed. • Street/Stop sign install zone 4: 5% Completed. • School Radar signs and beacons: 7 of 8 installed (one damaged in shipping). • New Projects: • Main St. Painting Powerline to Airport Dr. Powerline to Easy St.: Completed. • Airport Runway 23 touch up painting: Completed. • Traffic Island Laconia and Roseland : In Progress. • Create Logo's for Sebastian Police Department : In design stage. • M.O.T • Special Events 7 • School Light Issues: 12 • Citizen Request: 16 (14 closed, 2 speed studies in progress) • Work Orders: 29 (28 have been completed, 1 in progress) 7 • Created Signs Breakdown • Street signs : 980 • Regulatory: 65 • Warning: 2 • Guide: 2 • Wayfinding: 0 • Wildlife: 2 • Park: 5 • Aviation: 3 • Miscellaneous: 3 Facilities Maintenance • Maintain City Flags. • Maintain and monitor all lift stations. • Monthly A/C maintenance all City Buildings. • Assist with Splash pad operations. • Daily Monitoring of City Marquees. • Monthly monitoring and supplies AED Stations. • Daily Maintenance and repairs City Buildings. • Monitor Nash Janitorial. • City Backflows: 2021 Backflow re -certifications. • Boat Launch Restrooms: Repaint exterior. • Airport Maintenance Shed: Install new metal roof. • City Buildings: Air Guard protection. • Police Department: Install Daikin Mini Split AC unit PD Server Room. • Police Department: Install 2 Water/ Ice Stations. • Harrison St. Restrooms: Resurface Floors. • City Hall: Replace AC RTU #2. • Maintain City Flags. Cemetery • Began roadway improvements in newly expanded Cemetery area. • Routine Mowing, weed eating and edging. • Burials 10. • Cremains 8. • Quarterly Rain Gauge 8.5 Jan - Mar. • Tim Rose paving of unit 5. • Tim Rose final grade on unit 5. • Irrigation and landscaping of unit 5. Construction Specialist • Police Dept. • Install Ice machine kitchen/dispatch. • Repair lot lighting east gate. • Cemetery • Replace irrigation pump motor. • Airport • Repair hangar A lighting. • Install lighting antenna. • Repair sign Englar Dr. • Stormwater • Replace flow valve deck decking. • Rebuild sign Englar Dr. • Golf Course • Repair water main break. • Parks • Repair work Twin Pier decking. • Repair docks Yacht Club. • Shrimp Festival prep Electrical Tree trimming. • Ball Park install 2 new dug outs. • MISC: Meetings and estimates for coming projects. 8 Fleet Management: • The Fleet Management Staff completed 301 repair work orders, 44 preventive maintenance services, 15 service calls and 0 road trips to pick up parts. • In addition to in-house vehicle/equipment work orders, 7 vehicle and equipment repairs were scheduled and completed by outside vendors • Took delivery of the following units: • Side by side Utility Cart. • Completed the prep (lights, rack, graphics, etc.) on the following units: • Same as above. • Completed the sale of equipment: $18,369 in sales for 4 pieces of equipment. • Fuel Cost as of April 2021 is as follows: • $2.23 per gallon of gasoline 165% increase over the past 90 days. • $2.34 per gallon of diesel fuel 85% increase over the past 90 days. LEISURE SERVICES Parks Division • Repair Irrigation lines and fittings for Schumann medians, US 1, Riverview Park, dog park. • Install wind screens at the pickleball courts. • Add dirt to dog parks. • Hauled mulch to the airport for storage. • Prepare for Riverview events. • Add mulch around sign at pickleball courts, Barber St. sports complex, Mains St. docks, sign at yacht club, Riverview Park, sign at Filbc Park, Friendship Park. • Repair fencing around A/C at Barber St. sports complex. • Maintain the area by cutting debris at Bryant Court park. • Install sod at Yacht Club, dog park. • Install an assemble benches at the Barber St. sports complex. • Dig a trench line for the security cameras at Barber St. sports complex. • Install basketball net at Schumann Park. • Repair fence at Kildare park, Riverview, splash pad, Bryant Ct. • Pressure wash sidewalk at Friendship Park, Creative Park. • Install fence around the dumpsters at Barber St. complex. • Install cameras at the skate park at Barber St. sports complex. • Remove old signs. • Install picnic tables at Perwinkle Park, Barber St. sports complex, Schumann Park. • Install bricks at Memorial Park. • Install gates for the dugout on the baseball fields at the Barber St. sports complex. • Install new pump & remove the old ones for the tennis ct. at Friendship Park. • Repaired border around playground at Friendship Park. • Install rocks around clock tower and twin piers at Riverview Park. • Continue maintenance on the baseball and football fields. This would involve mowing, edging weed eating, dragging the fields, insectici< and fertilizing the grass. Recreation Division • Continued city run programs. STORMWATER DEPARTMENT • Road Crossing Pipes: • 40' of 18" HDPE • 40' of 18" HDPE • 80' of 30" HDPE • Removed 6,604 of debris from ditches. • Catch Basin repair: • Jordan & Foster • Crystal Mist • Ocean Cove • George Street • Replaced catch Basin Grates. • 529Inspections: • 431 Passed 81%. • 98 Failed 19%. Citizen Request Line 2021: • January 2021 = 46. Approximately 30 were Stormwater (56%), 14 Roads,( 30%), 3 general questions (061/o), 15 other (32%). • February 2021 = 78. Approximately 13 were Stormwater (16%), 15 Roads (19%), 6 general questions (07%), 16 other (20%). • March 2021 = 73. Approximately 30 were Stormwater (41%), 13 Roads (17%), 8 general questions (10%), 13 other (17%). Citizen Request Line 2020: • January 2020 - 66 Requests: • 30 Stormwater, 1 Outstanding. • 15 Other, 0 Outstanding. • 14 Roads, 0 Outstanding. • 3 Parks, 0 Outstanding. • February 2020 - 69 Request: • 13Stormwater, 0 Outstanding. • 16 Other, 0 Outstanding. • 15 Roads, 0 Outstanding. • 4 Parks, 0 Outstanding. • March 2020 - 60 Requests: • 30 Stormwater, 0 Outstanding. • 13 Other, 0 Outstanding. • 13 Roads, 0 Outstanding. • 1 Parks, 0 Outstanding. GOLF COURSE Revenue 20-21 19-20 Difference+/- 2nd Quarter Rev. $503,824 $566,067-$62,243 YTD Tot. Rev. $910,766 $952,470-$41,704 2nd Quarter Rounds 16,398 17,169 -771 YTD Tot. Rds. 27,160 26,978 +182 2nd Q. Green Fee $201,537 $224,297-$22,760 2nd Q. Cart Fee $231,948 $260,786-$28,838 2nd Q. Annual Member $3,048 $7,662-$4,614 YTD Ann. Mem. $113,268 $99,808 +$13,460 2nd Q. USGA Hdcp. $550 $704 -$154 YTD USGA Hdcp. $4,598 $5,192 -$594 2nd Q. Disct. Card $6,870 $6,917 -$47 YTD Disct. Cd. $30,048 $31,777-$1,729 2nd Q. Driving Range $20,843 $19,872 +$971 YTD Dr. Rge. $29,779 $28,641 +$1,138 2nd Q. Club Rental $480 $805 -$325 2nd Q. Club Storage $0 $28 -$28 YTD CR & CS $4,198 $4,644 -$446 2nd Q. Golf Shop Retail $30,360 $37,856-$7,496 YTD Shop Retail $50,496 $59,882-$9,386 2nd Q. PGA Pro Lesson $1,090 $1,410 -$320 YTD Lesson $1,850 $2,090 -$240 1st Q. Restaurant Rent $7,501 $7,501 $0 YTD Rest. Rent $15,001 $15,001 $0 *2nd Q. Rain amount 2.94" 2.38" +.56" *Data obtained from weather underground.com • Comments: Fairly consistent revenue and round numbers with last fiscal year. March 2021 was a fantastic month which helped pull up most of the 2nd quarter numbers. During January and February, rounds had to be limited due to the golf cart battery issue, which is now resolved. Small decrease in golf shop sales mainly due to numerous club orders being indicated to be on "backorder" for extended period of times. Driving range had a fantastic quarter, bringing -in almost $21,000 in revenue. • Charity, Corporate and special Golf Tournaments for the 2nd quarter included The New Year's Day Scramble Tournament, The Solid Rocket Booster Golf League, The Palm Bay Golf Association, The Sebastian Men's Golf Association President's Cup, The Par 5 Club and The Barefoot Bay Traveling Golf League. • In conjunction with the Indian River Golf Foundation, offered weekly junior golf clinics on Tuesdays and Fridays. Also offered a total of 6 Demo Days programs, which attracts many new, as well as longtime golfers to the golf course. • Replaced all batteries (480 in total) on Club Car golf carts. • All daily leagues, including Wojo's Monday League, Men's and Women's Golf Associations, Sebastian Business League and several other smaller leagues continue to thrive, support and offer consistent return play from many patrons. • Received several compliments on the condition of the golf course with specific emphasis on the condition of the greens and all turf in general. 10 AIRPORT • Painted runway threshold markings on runways 05-23. • Successfully completed annual FDOT airport license inspections. • Routine Maintenance. • Routine RWY light repairs. • Assisted golf course with battery installations. • Pressure washed terminal entrance. • Replaced shade hangar tie down ropes. • Conducted t-hangar inspection. • Installed mini -pc in terminal lobby for virtower. • Replaced primary windsock. • Pressure washed vault building. • Repaired gate 7. BUILDING DEPARTMENT • In the second quarter of this fiscal year, a total of 65 new single-family homes were issued building permits. New single family residence permits have increase dramatically this quarter with a 42% increase. Other permits of significance include 3 new manufactured homes, 0 new commercial buildings, 0 commercial additions, 2 commercial alterations, 0 commercial build outs, 4 residential additions and 126 residential alterations. In all, 1068 building permits were issued in the second quarter. Overall permitting in the second quarter has increased by 18%. • Total number of inspections for the second quarter was 3424 for an average of 57 building inspections per working day. The number of inspections for the second quarter has increased by 19% or additional 11 per inspections per day. • The number of Certificates of Occupancy issued for the second quarter included 49 new single family residences, 0 manufactured homes, 3 commercial certificate of occupancy, 0 commercial temporary certificates of occupancy and 1 commercial certificate of completion. • The following lists the Business Tax Receipt activity for the second quarter: new businesses -27, renewals -47, transfers -5, duplicates 2, home based businesses -27, commercial businesses -42, insurance companies - 1 and solicitor registrations -50. There were 68 new Contractor registrations. In addition, there have been 62 requests for permit records on properties within the city from lien/title companies. • During the second quarter of this fiscal year the volume of construction activity has increased significantly, very similar to the level we saw in the second quarter of the last fiscal year. The building department continues to look for better ways to interact with our customers. Much of the permit information is being conveyed successfully through a -mails and the building permit system, keeping the in -person traffic at a minimum. Hiring qualified inspectors on a full time basis has proven to be very difficult. There are no applicants for the open inspector position but we have been successful at bringing on two part time as needed retirees that bring a wealth of knowledge and experience and are willing to work in this fashion. One is a fire inspector and plans examiner and the other is an electrical inspector and plans examiner. 11