The URL can be used to link to this page

Home My WebLink About05-15-2023 BAC AgendaWOOF BA I iv HOME OF PELICAN ISLAND SEBASTIAN BUDGET REVIEW ADVISORY COMMITTEE AGENDA 6:00 P.M. MONDAY — MAY 15, 2023 CITY HALL 1225 MAIN STREET a. Call to Order b. Pledge of Allegiance c. Roll Call d. Vote to Excused or Unexcused Absent Members e. Approval of Minutes: Meeting of March 13, 2023 f. Review of Second Quarter Financial Report g. General Discussion by Members h. Next Scheduled Meeting Date (Monday, July 17, 2023) i. Adjourn Agenda Attachments: Minutes for Meeting of March 13, 2023 Second Quarter Financial Report — FY 2023 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 TESTIMONYAND EVIDENSE UPON WHICH THE APPEAL IS TO BE HEARS. (F. S.286.0105) IN COMPLIANCE WITH THE AMERICAN WITH DISABILITIES ACT (ADA), ANYONE WHO NEEDS A SPECIAL ACCOMODATION FOR THIS MEETING SHOULD CONTACT THE CITY'S ADA COORDINATOR AT 589-5330 AT LEAST 48 HOURS INADVANCE OF THIS MEETING. ZOOM INFORMATION Please click the link below to join the webinar: 7ttas:Hus02web.zoom.us/i/82641410365 Or One tap mobile: +13052241968„82641410365# US or+13017158592„82641410365# US (Washington DC) Or Telephone: Dial (for higher quality, dial a number based on your current location): +1 305 224 1968 US or +1 301 715 8592 US (Washington DC) or +1 309 205 3325 US or +1 564 217 2000 US or +1 312 626 6799 US Chicago) or +1 646 931 3860 US or +1 929 436 2866 US (New York) or +1 360 209 5623 US or +1 386 347 5053 US or +1 507 473 4847 US or +1 669 444 9171 US or +1 669 900 6833 US (San Jose) or +1 689 278 1000 US or +1 719 359 4580 US or +1 253 205 0468 US or +1 253 215 8782 US (Tacoma) or +1 346 248 7799 US (Houston) Webinar ID: 826 4141 0365 International numbers available: ittus:HusO2web.zoom.us/u/kdGom5OO CITIZENS BUDGET REVIEW ADVISORY COMMITTEE MINUTES OF REGULAR MEETING MARCH 13, 2023 I. Chairman Napier called the Citizens Budget Review Advisory Committee meeting to order at 6:00 p.m. II. Pledge of Alleniance was recited by all. III. Roll Call Present Mr. Middleton Ms. Cerda Ms. Reed (a) Mr. Hall Mr. McGinn Mr. Napier Mr. Newhart Not Present Mr. Hoffman -- Excused Also Present Mr. Ken Killgore, Administrative Services Director/CFO Barbara Brooke -Reese, MIS Manager Janet Graham, Technical Writer IV. Vote to Excuse or Unexcuse Absent Members It was the consensus that Mr. Hoffman be excused from this meeting, and Ms. Reed would be voting in his place. V. Approval of Minutes: Meeting of February 13. 2023 Everyone having had a chance to review the Minutes from February 13, 2023, Mr. Napier called for a motion. A motion to approve the Minutes as presented from February 13, 2023 was made by Ms. Cerda, seconded by Ms. Reed, and approved unanimously via voice vote. VI. Review of First Quarter Financial Report Mr. Killgore reviewed the first quarter financial report (SEE ATTACHED). He stated that the first quarter looks good. He stated that the report would be presented to City Council at next week's Council meeting. He explained the budget changes, the most of which had to do with projects at the end of last year that were unexpended, so those balances were brought forward. There were some purchase orders that were issued before year end, and those are being re -budgeted in order to have them fall into this fiscal year. CITIZENS BUDGET REVIEW ADVISORY COMMITTEE PAGE 2 MINUTES OF MARCH 13, 2023 Several adjustments were made for grant programs where the amounts were adjusted or a new grant was awarded. He explained the fund summaries and pointed out the departments that were over budget and why that was so. He explained the report on the American Rescue Act Plan Fund and also a forecast of the General Fund balance showing the amount of transfers that were made for the unfinished projects. There was an adjustment to pay for the cost of taking out the fuel tanks that were found on the Harbor Lights property. None of the R&R account funds were used during the first quarter. Other funds were summarized, and the majority of them were slightly more than were projected. He asked for questions/comments from the Committee members. Mr. McGinn addressed the funds that are held in the Seacoast National Bank. He asked how those funds are insured. Mr. Napier stated the banks are qualified public depositories, and the state collateralizes them as long as the governmental unit has their funds in that bank. So they are totally collateralized. Mr. Killgore stated that the City files a report every year with the state. The state issues those banks that are qualified to hold the money. Mr. Napier opined that those funds are very safe. VII. General Discussion by Members It was the opinion of the majority of the Committee members that they are satisfied with this budget report. Mr. McGinn asked regarding the debt service under the golf course report, it shows that, even though there was debt service in the previous years, there is none listed either in the budget or in the first quarter actual. He asked if that means there is not any. Mr. Killgore said that is probably because it is rolling up into other accounts. Mr. Hall said that he did not see a listing of expenditures for the quarter. He would like to see a more itemized listing. Mr. Killgore said, if Mr. Hall would get together with him, he would address that. Vill. Next Scheduled Meeting Date (Monday, May 15, 2023) IX. Adiourn There being no further business, Chairman Napier adjourned the meeting at 6:28 p.m. Chairman Larry Napier Jg Date: C90F HOME OF PELICAN ISLAND CITY COUNCIL AGENDA TRANSMITTAL FORM COUNCIL MEETING DATE: May 24, 2023 AGENDA ITEM TITLE: Resolution Accepting the 2nd Quarter Financial Report and Recognizing Necessary Amendments and Adjustments to the FY 2022-2023 Annual Budget. RECOMMENDATION: Move to approve Resolution R-23-09. 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 City Council was previously given during the quarter for adjustments to budgets for ordering Golf Carts, hiring a consultant for the City Attorney recruitment, pay changes for exempt employees, remodeling in the Building Department, an increase to the project to replace the patterned pavement, approving the collective bargaining agreement for Police Officers and the increased expenses to replace golf cart batteries. Formal reporting to the City Council is needed on the use of the General Fund R&R Account during the quarter but there were none in this quarter. In accordance with the authority given by the Annual Budget Resolution, the City Manager approved other budget transfers between accounts within Departments and authorized adjustments that were necessary to implement programs, projects and expenditures that were previously authorized by the City Council. Adjustments may include budget changes within his $15,000 spending authority, budget adjustments between budget accounts within the same departments, as well as adjustments to closeout completed or cancelled projects. Thus, the City Manager's did approve several adjustments this quarter. Additional details on the above adjustments are listed in Exhibit "A" that is an attachment to the Resolution. If A�-,enda Item Reouires Exnenditure 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-23-09 and Attachment "A" 2 2nd 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-23-09 A RESOLUTION OF THE CITY OF SEBASTIAN, INDIAN RIVER COUNTY, FLORIDA RECOGNIZING CERTAIN ADJUSTMENTS TO THE BUDGET FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2022 AND ENDING SEPTEMBER 30, 2023 AS PROVIDED FOR IN EDIT "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, 2023 was made to determine whether there were budget adjustments requiring formal approval by the City Council; and WHEREAS, it was determined that the City Council and City Manager previously approved all the necessary amendments and adjustments and these should just be reported 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, 2022 and ending September 30, 2023 has been amended and adjusted as necessary within the quarter ending March 31, 2023; 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 and, upon being put to a vote, the vote was as follows: Mayor Fred Jones Vice -Mayor Christopher Nunn Councilmember Ed Dodd Councilmember Bob McPartlan Councilmember Kelly Dixon The Mayor thereupon declared this Resolution duly passed and adopted this 24`h day of May 2023. ATTEST: CITY OF SEBASTIAN, FLORIDA By: Mayor Fred Jones Approved as to form and legality for the reliance by the City of Sebastian only: Jeanette Williams, MMC City Clerk City Attorney EXHIBIT "A" OF RESOLUTION R-23-09 SUMMARY OF BUDGET CHANGES FOR THE QUARTER ENDED March 31, 2023 ADJUSTMENTS PREVIOUSLY APPROVED BY CITY COUNCIL: Budget Before Budget Budget After Change Adjustment Change Reason for Purchase of New Golf Carts _ _-_- $0 _ $528,640 _ $528,640 01/11/23 Approved order of Carts with Appropriated_from Golf Course Reserves _________ ($5,000) ______($528,640)_____ ($533,640) expected delivery in January 2024__________ 9ther QQntractual Services Ei 2._?t__Ik��_from General Reserv_es............. 30,��QQ ($2��9g -------- $�4115q ($34,5b0______($3�7,67 $�512 � 02/08/23 Approved hiring consultant for C ity Attorney recruitment process. Fund Salaries & Benefits $2,334,995 $87,621 $2,422,616 _Various _ pro ted from_Gene _- _ Appropriated from Stormwater R sery - - A es ($666,40�� 518 _ ($(70,621�2-�$669,3_59) 2'8 41 026) 01/25/23 Approved pay rate changes for A ro riated from Golf Course Reserves pp p - _ _ ($83-3 640 :_j $4,072) -_ ($537,712Z Exempt Employees, with exception for Charter Officers. Appropriated from Airport Reserves _($70,319)__ _ ($2,275� _ ($72,594). Approprfated_from pyildlnq Fund Reserves - -- Buildings $9 106,$74 _._ $186,874 03/08/23 Approved contract for remodeling Appropriated_from Building Funa Reserves________ ($7,812)_______(_1. 6,_ 74)______($194,686) of the Building Department front counter_ Contractual Services _ nts. _ ._ __- $446,400 _ _ $33,705 _-_ $480,105 -.-- .- ._ 03/22/23 Approved cost estimate increase Appropriation from DST Reserves ($2,012,551) ($33,705) ($2,046,256) for US1 Patterned Paveway Replacement_ Police DeparMe,nt Salaries & Benefits $3,277 5f $152,349 $3 429,856 01/11/23 Approved Collective Bargaining ppropriated_ from General Reserves ($397,2 S ($152,340) 549,366) Agreement for Non-exempt Police Officers. olf Cart Battery Replacements rA _ $10,000 $16,316 $26,316 03/22/23 Approved increased expenses to pQropriation from Golf Course Reserves ($537,712) ($16,316) _ ($554,028) replace golf cart batteries: None to reEort. ADJUSTMENTS BEING SUBMITTED FOR CITY COUNCIL APPROVAL: Budget Before Budget Budget After nt Change Adjustment Change Reason for ADJUSTMENTS PREVIOUSLY AUTHORIZED BY THE CITY MANAGER: Budget Before Budget Budget After Project/Account Change Adjustment Change Reason for Adjustment Repairs to Equipment _ _ _ $15_,389 $23,342 _ _ $38,731 Adjustment to repair Golf Course equipment Insurance Proceeds $0 ($23,342) damaged by lightning on 7/17/2022__ ------------------------------------------------------- 10 Year Water Suppl�Plan - SO $12,000 $12,000 __ __- Adjustment to use American Recovery Plan _ Interest Income $0 12,000 ($ ) ($12,000) interest earnings for Water Supply Plan_ _ AP- propriated from DST Reserves _ _ _ _ ($2,057,046) $43,195 ($2,013,851) ----- Payment was expensed in previous year MIS Server/Host Update Project ------------------- $43,195 ($43,195) - - $0 and will - paid against the liability account. - --------- propriateq from DST Reserves ($2,013,851) $1,300 i$2,012,551'i Adjustment to close remaining unexpended Apprognated from Rec. Impact Reserves (l99,798) $15,283 ($184,515) balance of Park Signage Project, Park S!gnpgeProject------------------------------ _235,351......... ($16,583)........ A _ro riated from Rec. Im act Reserves„ __pp _P 1?. $184,515 �. $11Y041_ ($173,474) Adjustment to close remaining unexpended Park Improvements Project -- -------- $11,041 ($11,041) $0 balance of Park Improvements_ Project_ pro,riated from CRA Reserves ($109 630) $22,678 {$86 952} Adjustment to close remaining unexpended Signage Project $109 037 ($22,678) $86.359 balance of CfZ4 Signage Protect_ - Artificial Reef Grants _ $0 _$2,500 $2 500 Create a Project for Grants using American I nterest Income ($12,000) ($2,500� ($14,500f Recovery Plan interest earnings -------------- ------------------------------- - ,Lyerview Park Improvements Uohatioh trom Brew Fest 1, $ p _ - $2 , 00 3 $4ii Adds donation to balance set aside for to be determined later. - - - - - - _______________($1,85%__________($2,�a)_________($4,3�0 H_uman Resources Total Budget -_ Administrative Services Accounts $0 $231,814 $231,814 _; --- -------------------------------------------- Breaks out accounts to separate Human $761,131 $217,564 $543,567 Non -Departmental Accounts $1,064,329 ($14,250)____ $1,050,079---------------------------- Resources as a separate Division. A_.,_ f ._J/' ,I from 0-e.0era_ I Reserves !$3 7,6 9' &,3�� $13?Z14 34) ($326,405) Adjustment to close remaining . ,. .'ed Vehicles & Equipment (f $26,027 balance of Community Development SUV. CITY OF SEBASTIAN QUARTERLY FINANCIAL REPORT SECOND QUARTER ENDING MARCH 31, 2023 SUMMARY GENERAL FUND RECEIVED 60.7% OF BUDGETED REVENUE AND EXPENDITURES WERE 49.1 % OF BUDGETED AMOUNTS IN THE SECOND QUARTER. REVENUE WAS HIGH DUE TO PAYMENTS FOR AD VALOREM TAXES. GENERAL FUND SUMMARY Budget YTD % Beginning Balance $ $ 8,195,001 Ad Valorem Taxes 5,146,342 4,796,478 93.2% Franchise Fees 1,667,286 675,276 43.1% UBIityTaxes 3,210,987 1,356,552 42.2% Intergovernmental 3,811,968 1,503,045 39.4% Charges for Service 745,870 384,290 51.5% Licenses and Other 467,200 372,841 79.8% Transfers From Other Funds 35,000 - 0.0% Total Revenues $ 14,984,653 $ 9,088,482 60.7% From Fund Balance 549,366 0.0% Total Sources 5 15,534,019 S 9,088,482 58.5% City Council $ 62,725 $ 24,145 38.5% City Manager 309,381 152,702 49.4% City Clerk 223,024 122,042 54.7% City Attorney 271,445 118,426 43.6% Admin Services 623,297 320,151 51.4% MIS Division 727,871 330,601 45.4% Human Resources 231,814 97,213 41.9% Police Department 7,293,656 3,800,219 52.1% Roads and Garage 1,440,693 640,740 44.5% Public Facilities 796,660 349,104 43.8% Leisure Services 1,407,371 599,299 42.6% Cemetery 164,323 79,549 Community Dev. 716,458 229,086 32.0% Non -Departmental 1,265,301 767,932 60.7% Total Expenditures $ 15,534,019 $ 7,631,209 49.1% Unappropriated nla Total Uses $ 15,534,019 $ 7,631,209 49.1% Ending Unappropriated Fund Balance $ 9,652,274 WE PREVIOUSLY RECEIVED ALL OF THE AMERICAN RESCUE PLAN ACT FUNDING AND THE CITY COUNCIL AGREED TO APPLY THOSE FUNDS TO THE ITEMS LISTED. General Fund Revenue ■Adjusted Budget EYearloDate 5,000 4,000 3,000 2,000 1,000 Is*es e��\ es5a�d .. F\o �a � Jed n� Graff VGe��@�et5 General Fund Expenditures ri Adjusted Budget C7 Yearto Date $6,500 -�5,500 C 1;4,sa° 0 A3,s00 $2,500 $1,so° S(s00) ad' e c o`er e;,t & ��5�`a�tc CPA 010 Ga011t' �5 a� 0 0 �aa e�'pW� �I � P P• cv FUND BALANCE USES FOR GENERAL FUND ARE SHOWN BELOW. EXPECTED CHANGES TO YEAR END ANTICIPATE THE ADJUSTMENTS RESULTING FROM PAY RAISES. GENERAL FUND BALANCE FORECAST AMERICAN RESCUE PLAN ACT FUND Fund Balance R&R Account Budget YM % Beginning Reserves 10/01/22 $ 7,920,001 S 275,000 Beginning Fund Balance $ $ 2,869,473 Year to Date Revenue 9,088,482 Fund Balance/R&R Changes to Date: ARPA Grant nla Purchases Not Received (60,264) Interest 14,500 30,127 nla Unfinished 2022 Projects (215,065) Total Revenues $ 14,500 $ 30,127 nla Harbor Lights Fuel Tanks (17,850) From Fund Balance 2,696,156 0.0% City Attorney Recruitment (34,500) Total Sources $ 2,710,656 $ 2,899,600 JC7. n. Exempt Pay Increases (70,621) Police Pay Increases (152,340) Gardenia Ditch $ 746,156 $ 6,043 0.8% Year to Date Uses $ (550,540) 5 Expenditures (7,080,569) Schumann Drive 750,000 0.0%Other 0.0 Current Reserves 5 9,377,274 5 275,000 Concha Dam 700,000 0.0% Expected Changes to Year End: Roadwork 500,000 0.0% Additional Revenues 5,896,171 - Water Supply Work Plan 12,000 3,600 30.0% Additional Expenditures (7,755,739) - Artificial Reef Grants 2,500 0.0% Ending Reserves $ 7,517,706 $ 275,000 Total Uses $ 2,710,656 $ 9,643 0.4% Adjust R&R to $275,000 - - Ending Fund Balance $ $ 2,889 957 Adjusted Reserves 5 7,517,706 $ 275,000 Expected Change to Year End: Assigned Funds * (666,992) Net Unassigned Reserves 5 6,850,714 $ 275,000 Additional Revenues 30,000 Total Ending Reserves $ 7,125,714 Additional Expenditures 2,701,013 Projected in 2023 Budget (with pay raises) $ 7,088,173 9130123 Ending Available Funds $ 218,944 * Assigned Funds include Inventories, Prepaids and the Golf Course Loan. CITY OF SEBASTIAN QUARTERLY FINANCIAL REPORT SECOND QUARTER ENDING MARCH 31, 2023 SUMMARY BEGINNING FUND BALANCE FOR THE STORMWATER FUND GOLF COURSE REVENUES CONTINUE TO BE FAVORABLE WAS HIGHER THAN EXPECTED BECAUSE $200,000 WAS NOT FROM HIGH LEVELS OF PLAY. THE LIGHTNING DAMAGE TRANSFERRED TO THE CAPITAL PROJECTS FUND BEFORE EXPENSE WAS REIMBURSED FROM INSURANCE. YEAR ENE. MOST OF THE EXPECTED COLLECTIONS OF - STORMWA` 1FR FEES HAVE BEEN RECEIVED. GOLF FUND SUMMARY Budget YTD % b 1 UKMYYAI tK FUND SUMMARY Budget YTD Beginning Fund Balance $ • $ 1,957,126 Stolmwater Fees 1,952,055 1,806,747 Interest and Other 7,566 29,115 Total Revenues $ 1,959,621 $ 1,835,862 From Fund Balance 669,359 Total Sources $ 2,628,980 $ Operating Expenditures $ 2,226,488 $ Capital Outlay 41,300 Transfer to Capital Projects 361,192 Total Uses $ 2,628,980 $ Ending Fund Balance $ • $ Expected Change to Year End: Additional Revenues Additional Expenditures Additional Capital Outlay Transfers to Capital Projects 9130123 Ending Available Funds Projected in 2023 Budget 3,792,988 887,359 35,406 142,874 1,065,639 2,727,349 123,759 (1,339,129) (5,894) (218,318) 1,287,767 1,179,343 92.6% 384.8% 93.7% 0.0% 144.3% 39.9% 85.7% 39.6% 40.5% REVENUE FROM AIRORT RENTS IS 52.4% COLLECTED. BEGINNING AND ENDING RESOURCES EXCLUDE THE PRINCIPAL DUE ON THE DST LOAN OF $502,746. AIRPORT FUND SUMMARY Budget YTD % Beginning Resources S - $ 456,624 Rents 577,861 302,936 52.4% Investment Income 725 4,643 640.4% Miscellaneous 85,690 43,545 50.8% Total Revenues 664,276 351,124 52.9% From Fund Balance 72,594 - nla Total Sources $ 736,870 $ 807,748 Operating Expenses $ 520,933 $ 280,607 53.9°% DST Fund Loans 36,500 0.0% Capital Outlay 9,500 0.0% Transfers for Projects 76,707 51,957 67.7% Total Uses $ 643,640 $ 332,564 51.7% Total Ending Resources 93,230 $ 475,184 Expected Change to Year End: Additional Revenues 313,152 Addditional Uses (311,076) 9130123 Ending Resources $ 477,260 Projected in 2023 Budget $ 549,854 Beginning Resources $ - $ (212,729) Charges for Service 1,631,611 1,172,328 71.9% Rent 30,000 15,451 51.5% Insurance Proceeds 23,342 48,342 207.1% I Miscellaneous 10,760 11,366 105.6% Total Revenues 1,695,713 1,247,487 73.6% Pro Shop Sales 110,000 74,287 67.5°% Pro Shop Purchases (65,000) (55,252) 85.0% Sales vs. Cost of Sales 44000 19,035 42.3% From Reserves - Batteries 16,316 nla From Reserves - Carts 528,640 nla From Reserves . Pay Changes 4,072 nla From Reserves for Ditches 5,000 nla Total Sources $ 2,294,741 $ 1,266,522 55.2°% Operating Expenses $ 1,498,906 $ 749.862 50.0% Equipment 28,986 nla Lightning Damage - 21,097 n!a Range Netting 77,000 nla Carl Purchase 528,640 nla Total Operating Expense 2,133,532 770,959 K., ;'a General Fund Payment 35,000 nla Building Fund Payment 36,209 18,105 50.0% Total Uses $ 2,204,741 $ 789,064 35.8% Total Ending Resources $ 11,000 $ 114,721 Expected Change to Year End: Additional Sources 1,028,219 Additional Uses (1,415,677) 9130123 Ending Resources $ (122,729) Projected in 2023 Budget $ (302,729) BUILDING RESOURCES EXCLUDE THE REBATE PAYABLE MANDATED BY THE STATE AND $1,112,843 ADVANCE TO THE GOLF COURSE. 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 Total Uses Total Ending Resources Expected Change to Year End: Additional Revenues Additional Uses 9/30123 Ending Resources Projected in 2023 Budget BUILDING FUND SUMMARY Budget YTD $ $ 1,781,659 1,229,500 458,078 33,500 9,069 5,500 2,925 7,289 21,890 36,209 18,105 1,311,998 510,067 194,686 - 1,506,684 510,067 $ 1,279,933 $ 475,516 186,874 $ 1,466,807 $ 475,516 39,877 $ 1,816,210 801,931 (991,291) $ 1,626,850 $ 1,621,536 37.3% 27.1 % 532% 300.3% 50.0% 38.9% n1a 33.9% 372% We 32.4% CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 03/31/23 201912020 202012021 2021/2022 202212023 2022/2023 202212023 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET GENERALFUND TAXES -5,303,645 -6,022,157 -6,121,289 -6,828,306 -9,924,615 68.80% LICENSES & PERMITS -109,768 -107,947 -114,966 -108,966 -163,700 66.56% INTERGVT'L REVENUE -1,237,232 -1,238,720 -1,549,626 -1,503,045 -3,811,968 39.43% CHARGES FOR SERVICE -295,108 -376,017 -406,558 -384,290 -745,870 51.52% FINES AND FORFEITS -37,112 -19,028 -62,843 -42,941 -50,500 85.03% MISC. REVENUE -231,931 -80,357 -143,748 -220,934 -253,000 87,33% TRANSFERS IN -12,500 -75,000 0 0 -35,000 0.00% FROM FUND BALANCES 0 0 0 0 -549,366 0.00% GENERAL FUND REVENUE -7,227,295 -7,919,225 -8,399,030 -9,088,482 -15,534,019 58.51% CITY COUNCIL 24,004 23,499 24,980 24,145 62,725 38.49% CITY MANAGER 127,779 132,156 152,312 152,702 309,381 49.36% CITY CLERK 125,325 100,629 159,920 122,042 223,024 54.72% CITY ATTORNEY 94,607 88,179 94,604 118,426 271,445 43.63% ADMINISTRATIVE SERVICES 356,680 338,310 393,874 320,151 623,297 51.36% M.I.S. DIVISION 267,227 271,864 308,244 330,601 727,871 45.42% HUMAN RESOURCES 0 0 0 97,213 231,814 41.94% POLICE ADMINISTRATION 590,289 450,813 486,894 459,244 875,080 52.48% POLICE PATROL 1,898,147 1,956,988 2,173,231 2,275,238 4,123,169 55.18% CODE ENFORCEMENT DIVISION 89,775 88,225 104,627 70,796 202,567 34.95% POLICE INVESTIGATIONS 590,942 593,063 675,986 677,329 1,342,060 50.47% POLICE COMMUNICATIONS 292,670 259,753 337,859 317,612 750,780 42.30% ROADS AND DRAINAGE 493,277 445,165 512,025 518,166 1,157,409 44.77% CENTRAL GARAGE 95,827 98,721 114,802 122,574 283,284 43.27% FACILITIES MAINTENANCE 260,104 277,316 319,417 349,104 796,660 43.82% LEISURE SERVICES 508,705 460,025 571,272 599,299 1,407,371 42.58% CEMETERY 85,807 115,772 71,069 79,549 164,323 48.41% COMMUNITY DEVELOPMENT 262,963 234,387 241,802 229,086 716,458 31.97% NON -DEPARTMENTAL 641,599 682,272 962,541 767,932 1,265,301 60.69% GENERAL FUND EXPENDITURES 6,805,725 6,617,136 7,705,460 7,631,209 15,534,019 49.13% 10 CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 03/31/23 2019/2020 2020/2021 202112022 202212023 202212023 202212023 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET AMERICAN RESCUE PLAN ACT INTERGVTL REVENUE 0 1,666,064 0 0 0 0.00% MISC. REVENUE 0 0 1,977 30,127 14,500 207.77% TRANSFERS IN 0 0 0 0 0 0.00% FROM FUND BALANCE 0 0 0 0 2,696,156 0.00% ARPA FUND REVENUE 0 1,666,064 1,977 30,127 2,710,656 1.11% PERSONAL SERVICES 0 0 0 0 0 0.00% OPERATING EXPENSES 0 0 0 0 14,500 0.00% TRANSFERS OUT 0 0 481,012 1,190 2,696,156 0.04% TO FUND BALANCE 0 0 0 0 0 0.00% ARPA FUND EXPENDITURES 0 0 481,012 1,190 2,710,656 0.04% LOCAL OPTION GAS TAX TAXES -306,905 -299,794 -309,916 -306,314 -777,637 39.39% INTERGVT'L REVENUE 0 0 0 0 -14,964 0.00% MISC. REVENUE -1,849 -296 -484 -8,121 -2,479 327.59% FROM FUND BALANCES 0 0 0 0 -356,494 0.00% LOGT FUND REVENUE -308,754 -300,090 -310,400 -314,435 -1,151,574 27.30% OPERATING EXPENSES 0 87,572 0 2,700 10,800 25.00% CAPITAL OUTLAY 105,554 34,372 4,870 0 0 0.00% DEBT SERVICE 121,993 121,781 121,473 122,174 122,174 100.00% TRANSFERS OUT 606,893 478,175 12,724 1,800 1,018,600 0.18% TO FUND BALANCES 0 0 0 0 0 0.00% LOCAL OPTION GAS TAX 834,441 721,901 139,066 126,674 1,151,574 11.00% DISCRETIONARY SALES TAX TAXES -1,477,979 -1,532,253 -1,817,434 -1,879,323 -5,160,637 36.42% MISC. REVENUE -38,046 -6,917 -5,022 -27,433 -98,209 27.93% FROM FUND BALANCES 0 0 0 0 -2,046,256 0.00% DST FUND REVENUE -1,516,025 -1,539,170 -1,822,456 -1,906,756 -7,305,102 26.10% OPERATING EXPENSES 4,080 0 0 0 0 0.00% CAPITAL OUTLAY 0 0 7,151 0 0 0.00% TRANSFERS OUT 864,600 1,157,871 4,516,085 925,754 6,441,728 14.37% TO FUND BALANCES 0 0 0 0 863,374 0.00% DISCRETIONARY SALES TAX 868,680 1,157,871 4,523,236 925,754 7,305,102 12.67% RIVERFRONT REDEVELOPMENT FUND MISC. REVENUE -22,222.65 -18,731.55 -18,935.52 -26,767.61 -43,719.00 61.23% TRANSFERS IN -403,239.68 -457,671.66 -385,664.86 -391,770.36 -380,580.00 102.94% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -86,952.00 0.00% RRD REVENUE -425,462.33 -476,403.21 -404,600.38 -418,537.97 -511,251.00 81.87% OPERATING EXPENSES 175,690.04 133,184.39 167,467.70 151,865.24 260,918.00 58.20% GRANTS AND AIDS 15,000.00 0.00 0.00 0.00 31,951.00 0.00% TRANSFERS OUT 0.00 74,932.07 29,305.83 3,500.00 70,001.00 5.00% TO FUND BALANCES 0.00 0.00 0.00 0.00 148,381.00 0.00% RRD EXPENDITURES 190,690.04 208,116.46 196,773.53 155,365.24 511,251.00 30.39% PARKING IN LIEU OF FUND MISC. REVENUE -2,012.33 -3,072.19 -15,019.42 -4,099.40 -539.00 760.56% PARKING IN LIEU OF REVENUE -2,012.33 -3,072.19 -15,019.42 -4,099.40 -539.00 760.56% TO FUND BALANCES 0.00 0.00 0.00 0.00 539.00 0.00% PARKING IN LIEU OF EXPENDITURES 0.00 0.00 0.00 0.00 539.00 0.00% 10 CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 03/31/23 2019/2020 2020/2021 202112022 2022/2023 2022/2023 202212023 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET RECREATION IMPACT FEE FUND MISC. REVENUE -76,260.34 -86,530.86 -85,236.32 -56,290.96 -163,389.00 34.45% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -173,474.00 0.00% RECREATION IMPACT FEE REVENUE -76,260.34 -86,530.86 -85,236.32 -56,290.96 -336,863.00 16.71% TRANSFERS OUT 309,483.40 73,010.48 17,639.86 0.00 228,474.00 0.00% TO FUND BALANCE 0.00 0.00 0.00 0.00 108,389.00 0.00% RECREATION IMPACT FEE 309,483.40 73,010.48 17,639.86 0.00 336,863.00 0.00% STORMWATER UTILITY FUND MISC. REVENUE -1,807,588.96 -1,817,171.36 -1,831,542.99 -1,835,862.92 -1,959,621.00 93.68% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -669,359.00 0.00% STORMWATER FUND REVENUE -1,807,588.96 -1,817,171.36 -1,831,542.99 -1,835,862.92 -2,628,980.00 69.83% PERSONAL SERVICES 315,556.06 326,030.42 364,125.13 378,413.90 916,106.00 41.31% OPERATING EXPENSES 218,528.63 354,713.66 331,291.09 508,945.05 1,310,382.00 38.84% CAPITAL OUTLAY 0.00 68,096.48 129,600.95 35,406.00 41,300.00 85.73% TRANSFERS OUT 4,540.00 1,325.00 57,125.00 142,873.62 361,192.00 39.56% STORMWATER FUND EXPENDITURES 538,624.59 750,165.56 882,142.17 1,065,638.57 2,628,980.00 40.53% LAW ENFORCEMENT FORFEITURE FUND FINES AND FORFEITS -83.33 -15,000.00 0.00 0.00 -1,000.00 0.00% MISC. REVENUE -283.67 -29.97 -28.44 -554.89 -160.00 346.81% FORFEITURE REVENUE -367.00 -15,029.97 -28.44 -554.89 -1,160.00 47.84% OPERATING EXPENSES 0.00 1,500.00 1,056.74 0.00 0.00 0.00% CAPITAL OUTLAY 0.00 15,000.00 0.00 0.00 0.00 0.00% GRANTS AND AIDS 1,000.00 0.00 0.00 1,500.00 0.00 0.00% TO FUND BALANCES 0.00 0.00 0.00 0.00 1,160.00 0.00% FORFEITURE FUND EXPENDITURES 1,000.00 16,500.00 1,056.74 1,500.00 1,160.00 129.31%' STORMWATER DEBT SERVICE FUND MISC. REVENUE -1,981.47 -333.01 -356.04 0.00 0.00 0.00% TRANSFERS IN -200,677.50 -200,480.52 -116,701.50 0.00 0.00 0.00% FROM FUND BALANCES 0.00 0.00 0.00 0.00 0.00 0.00% STORMWATER DEBT SERVICE REVENUE -202,658.97 -200,813.53 -117,057.54 0.00 0.00 0.00% DEBT SERVICE 10,068.60 6,764.30 3,416.75 0.00 0.00 0.00% TO FUND BALANCES 0.00 0.00 0.00 0.00 0.00 0.00% STORMWATER DEBT EXPENDITURES 10,068.60 6,764.30 3,416.75 0.00 0.00 0.00% If CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 03/31/23 201912020 2020/2021 202112022 202212023 2022/2023 2022/2023 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET GOLF COURSE FUND CHARGES FOR SERVICE -935,142.42 -892,424.57 -1,146,615.29 -1,246,615.28 -1,741,611.00 71.58% MISC. REVENUE -20,823.52 -20,190.62 -20,674.53 -75,158.91 -64,102.00 117.25% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -554,028.00 0.00% GOLF COURSE FUND REVENUE -955,965.94 -912,615.19 -1,167,289.82 -1,321,774.19 -2,359,741.00 56.01 % ADMINISTRATION 353,219.62 356,339.10 404,447.95 393,074.34 1,415,172.00 27.78% MAINTENANCE 288,538.03 284,893.81 295,253.12 341,482.66 765,569.00 44.61% GOLF COURSE CARTS 82,793.15 82,056.67 105,400.21 90,012.77 179,000.00 50.29% GOLF COURSE FUND EXPENSES 724,550.80 723,289.58 805,101.28 824,569.77 2,359,741.00 34.94% AIRPORT FUND CHARGES FOR SERVICE 0.00 0.00 0.00 0.00 0.00 0.00% MISC. REVENUE -281,452.69 -291,290.38 -318,741.61 -351,123.86 -664,276.00 52.86% TRANSFERS IN -4,691.00 0.00 0.00 0.00 0.00 0.00% FROM FUND BALANCES 0.00 0.00 0.00 0.00 -72,594.00 0.00% AIRPORT FUND REVENUE -286,143.69 -291,290.38 -318,741.61 -351,123.86 -736,870.00 47.65% PERSONAL SERVICES 33,059.95 33,524.89 49,511.88 92,915.88 188,735.00 49.23% OPERATING EXPENSES 148,529.69 158,042.15 191,161.79 187,690.92 332,198.00 56.50% CAPITAL OUTLAY 5,125.33 4,255.00 1,920.00 0.00 9,500.00 0.00% DEBT SERVICE 0.00 0.00 0.00 0.00 36,500.00 0.00% TRANSFERS OUT 12,499.98 75,000.00 0.00 51,957.34 76,707.00 67.73% TO FUND BALANCES 0.00 0.00 0.00 0.00 93,230.00 0.00% AIRPORT FUND EXPENSES 199,214.95 270,822.04 242,593.67 332,564.14 736,870.00 45.13% BUILDING FUND LICENSES & PERMITS -439,001.85 -554,460.66 -592,736.72 -458,077.85 -1,229,500.00 37.26% CHARGES FOR SERVICE -8,139.10 -12,956.10 -16,908.70 -9,068.70 -33,500.00 27.07% FINES AND FORFEITS -3,098.00 -2,700.00 -2,136.11 -2,925.00 -5,500.00 53.18% MISC. REVENUE -7,063.06 -9,722.59 -3,696.44 -21,890.80 -7,289.00 300.33% TRANSFERS IN -19,183.98 -19,183.02 -18,042.48 -18,104.52 -36,209.00 50.00% FROM FUND BALANCE 0.00 0.00 0.00 0.00 -194,686.00 0.00% BUILDING FUND REVENUES -476,485.99 -599,022.37 -633,520.45 -510,066.87 -1,506,684.00 33.85% PERSONAL SERVICES 282,283.14 284,569.75 365,167.16 366,529.61 941,787.00 38.92% OPERATING EXPENSES 71,019.81 77,117.42 117,895.94 108,986.18 338,146.00 32.23% CAPITAL OUTLAY 0.00 22,957.00 0.00 0.00 186,874.00 0.00% TO FUND BALANCES 0.00 0.00 0.00 0.00 39,877.00 0.00% BUILDING FUND EXPENSES 353,302.95 384,644.17 483,063.10 475,515.79 1,506,684.00 31.56% /X CITY OF SEBASTIAN GENERAL FUND DEPARTMENTS QUARTER ENDING 03/31/23 2019/2020 2020/2021 2021/2022 2022/2023 202212023 2022/2023 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET CITY COUNCIL PERSONAL SERVICES 11,374 11,377 11,372 11,371 22,725 50.04% OPERATING EXPENSES 12,630 12,122 13,608 12,774 40,000 31.94% TOTAL 24,004 23,499 24,980 24,145 62,725 38.49% CITY MANAGER PERSONAL SERVICES 120,674 126,852 145,326 147,375 289,586 50.89% OPERATING EXPENSES 7,104 5,305 6,987 5,327 19,795 26.91% CAPITAL OUTLAY 0 0 0 0 0 0.00% TOTAL 127,779 132,156 152,312 152,702 309,381 49.36% CITY CLERK PERSONAL SERVICES 80,544 84,425 94,640 91,563 182,129 50.27% OPERATING EXPENSES 44,782 16,204 65,280 30,479 40,895 74.53% TOTAL 125,325 100,629 159,920 122,042 223,024 54.72% CITY ATTORNEY PERSONAL SERVICES 13,339 75,393 89,811 99,071 188,555 52.54% OPERATING EXPENSES 81,268 12,786 4,793 19,354 82,890 23.35% TOTAL 94,607 88,179 94,604 118,426 271,445 43.63% ADMINISTRATIVE SERVICES PERSONAL SERVICES 258,748 240,689 295,494 230,683 504,435 45.73% OPERATING EXPENSES 97,932 97,621 98,380 89,467 118,862 75.27% TOTAL 356,680 338,310 393,874 320,151 623,297 51.36% M.I.S. DIVISION PERSONAL SERVICES 162,827 158,408 189,726 196,496 447,581 43.90% OPERATING EXPENSES 103,488 113,455 118,518 134,105 280,290 47.85% CAPITAL OUTLAY 912 0 0 0 0 0.00% TOTAL 267,227 271,864 308,244 330,601 727,871 45.42% HUMAN RESOURCES PERSONAL SERVICES 0 0 0 79,638 174,271 45.70% OPERATING EXPENSES 0 0 0 17,576 57,543 30.54% CAPITAL OUTLAY 0 0 0 0 0 0.00% TOTAL 0 0 0 97,213 231,814 41.94% POLICE ADMINISTRATION PERSONAL SERVICES 483,011 370,312 423,818 401,399 761,310 52.72% OPERATING EXPENSES 87,584 80,501 59,326 57,845 113,770 50.84% CAPITAL OUTLAY 19,694 0 3,750 0 0 0.00% TOTAL 590,289 450,813 486,894 459,244 875,080 52.48% POLICE PATROL PERSONAL SERVICES 1,743,402 1,817,646 2,009,431 2,057,375 3,674,360 55.99% OPERATING EXPENSES 122,187 126,960 146,434 183,368 371,259 49.39% CAPITAL OUTLAY 32,558 12,383 17,365 34,495 77,550 44.48% TOTAL 1,898,147 1,956,988 2,173,231 2,275,238 4,123,169 55.18% CODE ENFORCEMENT DIVISION PERSONAL SERVICES 81,275 81,047 96,416 63,837 181,777 35.12% OPERATING EXPENSES 8,500 7,178 8,211 6,959 20,790 33.47% TOTAL 89,775 88,225 104,627 70,796 202,567 34.95% POLICE INVESTIGATIONS PERSONAL SERVICES 497,194 510,995 607,021 602,913 1,170,620 51.50% OPERATING EXPENSES 66,639 72,568 68,965 74,415 158,440 46.97% CAPITAL OUTLAY 27,109 9,500 0 0 13,000 0.00% TOTAL 590,943 593,063 675,986 677,329 1,342,060 50.47% POLICE COMMUNICATIONS PERSONAL SERVICES 286,426 255,469 332,529 314,045 733,785 42.80% OPERATING EXPENSES 6,244 4,283 5,329 3,567 16,995 20.99% TOTAL 292,670 259,753 337,859 317,612 750,780 42.30% CITY OF SEBASTIAN GENERAL FUND DEPARTMENTS QUARTER ENDING 03/31/23 2019/2020 2020/2021 2021/2022 2022/2023 2022/2023 2022/2023 2nd QTR 2nd QTR 2nd QTR 2nd QTR ANNUAL PERCENT ACTUALS ACTUALS ACTUALS ACTUALS BUDGET OF BUDGET ROADS AND DRAINAGE PERSONAL SERVICES 275,401 292,176 277,095 316,883 689,530 45.96% OPERATING EXPENSES 178,685 150,087 174,431 182,869 448,955 40.73% CAPITAL OUTLAY 39,190 2,902 60,498 18,414 18,924 97.31 % TOTAL 493,277 445,165 512,025 518,166 1,157,409 44.77% CENTRAL GARAGE PERSONAL SERVICES 86,048 87,954 103,931 105,673 232,749 45.40% OPERATING EXPENSES 9,779 10,768 10,872 13,675 30,535 44.78% CAPITAL OUTLAY 0 0 0 3,226 20,000 16.13% TOTAL 95,827 98,721 114,802 122,574 283,284 43.27% FACILITIES MAINTENANCE PERSONAL SERVICES 132,957 137,884 153,863 118,299 262,645 45.04% OPERATING EXPENSES 111,774 122,811 157,216 230,805 487,015 47.39% CAPITAL OUTLAY 15,372 16,621 8,338 0 47,000 0.00% TOTAL 260,104 277,316 319,417 349,104 796,660 43.82% LEISURE SERVICES PERSONAL SERVICES 357,529 330,032 403,830 417,943 959,311 43.57% OPERATING EXPENSES 101,781 116,031 147,192 128,243 302,190 42.44% CAPITAL OUTLAY 49,395 13,963 20,250 53,113 145,870 36.41% TOTAL 508,705 460,025 571,272 599,299 1,407,371 42.58% CEMETERY PERSONAL SERVICES 74,906 103,255 59,695 64,070 124,703 51.38% OPERATING EXPENSES 10,900 12,517 11,373 15,479 39,620 39.07% TOTAL 85,807 115,772 71,069 79,549 164,323 48.41% COMMUNITY DEVELOPMENT PERSONAL SERVICES 173,435 200,967 211,290 218,746 581,168 37.64% OPERATING EXPENSES 74,878 33,419 30,512 10,340 120,290 8.60% CAPITAL OUTLAY 14,650 0 0 0 15,000 0.00% TOTAL 262,963 234,387 241,802 229,086 716,458 31.97% NON -DEPARTMENTAL PERSONAL SERVICES 125,484 129,754 150,353 139,812 305,431 45.78% OPERATING EXPENSES 511,424 546,855 517,440 577,165 746,079 77.36% TRANSFERS TO OTHER FUNDS 4,691 5,663 294,749 50,956 213,791 23.83% TOTAL 641,599 682,272 962.541 767,932 1,265,301 60.69% GENERAL FUND EXPENDITURES 6,805,725 6,617,136 7,705,460 7,631,209 15,534,019 49.13% CITY OF SEBASTIAN CAPITAL PROJECT STATUS REPORT AS OF MARCH 31, 2023 Current Prior Project Budget Share Project Year Year Expenditures Percent Funds Number Description Budget Sources tin Thousands of St Budget Expenditures Expenditares To Date Expended Encumbrances Remainine FY2019 A1952 Construct HangarD FDOT/DST/AP 1,800/450/67.2 2,317,253 131,639 2,173,212 2,304,851 99.46% 46,875 (34,473) TOTAL $ 2,559,011 $ 136,039 S 2,410,570 S 2546,609 99.52 % S 46,975 S (34,473) FY2020 A2007 CDBG Grant Program CDBG 515 515,175 36,571 261,566 298.138 57-879/6 28,167 188,870 A2030 Relocate Public Facilities Compound SJRWMD/DST 11.8/9,639 9,651,130 6,499 9,158,834 9,165.333 94.97% 484,706 1,091 A2063 Septic to Sewer Grant Program IRLC/CRA 42.8147.8 90,606 - 85,605 85.605 94.48% - 5,001 S 11,010,295 $ 46,270 S 10,256,189 $ 10,302,459 93.57% $ 512,873 $ 194,962 FY2021 A2104 Phone System DST 100 100,000 1,080 82,727 83.807 83.81 % - 16,193 A2126 Yacht Club Seawall] OF 359 358,962 1,415 350,337 351,752 97.99% - 7,210 A2150 Establish Sewer Service FDOT/SJRWMD/DST 1,327/149/430 1,906,801 58,365 1,628,044 1,686,408 88.441/. 70,162 150,231 A2161 Stormwater Master Plan DST/SW 350/350 700,D00 87,650 560,750 648,400 92.63% 51,600 - $ 3,127,172 $ 148,510 $ 2,683,266 $ 2,931,775 90.55% S 121,762 S 173,635 FY2022 A2206 CAD/RMS System Update DST 142 141,925 112,069 112,069 78.96% - 29,856 A2207 Police Vehicles & Equipment DST 300 300,213 300 14,683 14,983 4-99% 277,507 7.723 A2212 PD Vehicles OF 104 103,584 - - - 0.00% 103,334 251 A2214 PD Flooring OF 39 39,000 20,514 103 20,617 52.86% - 18,383 A2215 Leisure Services Vehicle & Mower OF 34 33,657 - - - 0.00% 33,532 125 A2220 Working Waterfront CRA 50 50,000 3,500 - 3.500 7.001A 6,500 40,000 A2221 BSSC Baseball Backstops RIF 75 75,000 - - - 0-0D1/1 - 75,000 A2222 Playground Improvements RIF 104 104,026 - 1,526 1526 1.47% 102,474 26 A2224 Riverview Park Enhancements DON 4 4,350 - - 0.001% - 4,350 A2230 Railroad Crossing Sidewalks LOGT/DST 100/90 190,000 1,800 6,400 8,200 432% 14,920 166.880 A2231 Road Improvements ARPA 500 500,000 - - - 0.001% - 500,000 A2250 Construct (4) Square Hangars FDOT/DST 1,256/314 1,570,000 101 - 101 0.01% - 1,569.899 A2252 Hangar C Office Improvements FDOT/DON 35/35 70,000 - - - 0.001% - 70,000 A2253 Airport Rescue Grant FAA 32 32,000 - 27,756 27,756 86.741% - 4,244 A2254 Rehab Runway05-23 FAA/FDOT/DST 197/10.9/13.4 221,394 82,229 4,194 86,423 39-04/ 134,970 1 A2260 Swales/Driveways/Culverts SW 245 244,695 32,212 36.039 68,251 27-89% 49,238 127.207 A2261 Concha Dam Replacement ARPA 700 700,000 - - - 0.00% - 700,000 A2262 Sliplining DST 250 250,OD0 36,980 - 36.980 14.79% 33,234 179,787 A2263 Tulip Habitat Restoration IRLC/SW 4.8/18.5 23,291 - 4,431 4,431 19.02% 666 18,194 A2264 Gardenia Ditch ARPA 750 750,000 6,043 3,944 9,887 1.32% 3.756 736,357 A2265 Schumann Drive Box Culvert ARPA 750 750,000 - - 0.00% 44,120 705,880 $ 6,524,011 S 511,543 S 254,055 $ 765,597 11.74% $ 804,250 S 4,954,163 FY2023 A2301 Citywide Computers DST 76.1 $ 76,108 $ 7,071 $ - $ 7,071 9.29% $ - $ 69,037 A2302 COSty Equipment DST 15 $ 15,000 $ 10,760 $ - S 10,760 71.73% $ 943 $ 3,298 A2303 Network Infrastructure DST 50 $ 50,077 $ 2,541 $ - $ 2,541 5.07% $ 6,192 $ 41,344 A2304 Backup System Update DST 40 $ 40,000 $ 17,466 $ - $ 17.466 43-67% $ . $ 22.534 A2305 Parks Security Cameras DST 28.7 $ 28,700 S 12,881 $ - $ 12,881 44.88% $ 7,219 $ 8,600 A2306 PD Vehicles & Equip DST 512.2 $ 512,200 $ - $ - $ - 0.00% $ 425.169 S 87,031 A2307 PD Body Worn & Vehicle Cameras DST 88.2 $ 88,183 S 39,292 $ $ 39,292 44-56% $ - $ 48,892 A2308 CAD/RMS System DST 60.8 $ 60,775 $ 14,000 $ $ 14,000 23.04% $ - $ 46,775 A2309 PD Armored Vehicle DST 310 $ 310,000 $ - $ S - 0.00% $ 309,500 $ 500 A2310 PD Generator Transfer Switch DST 200 $ 200,000 $ - $ - $ 0.001% $ - $ 200,000 A2311 Air Conditioner Replacements DST 25 $ 25,000 $ - S - $ - 0.001/ $ 9,752 $ 15,248 A2312 Hurricane lan FEMA 0 $ - $ 56,386 $ $ 56,386 0.00% $ - $ (56.386) A2313 Hurricane Nicole FEMA 0 $ - $ 1,063 $ - $ 1,063 0.00% $ 6,500 $ (7,563) A2314 Golf Carts GC 528.6 $ 528,640 $ - $ - $ - 0.00% $ 528.640 S - A2315 100th Anniversary Celebration DON/GF 2 /3 $ 5,000 S - $ $ - 0.00% $ - $ 5.000 A2316 JAG Grant JAG/GF 12 / 1 $ 13,150 S - $ $ - 0.00% $ - $ 13,150 A2320 Swing/Bench Park RIF 35 $ 35,000 $ - $ - $ - 0.00% $ - S 35,000 A2321 Park Improvements RIF 16 $ 15.974 S - $ $ - 0.00% $ - $ 15,974 A2322 Kiosk Signs CRA 15 $ 15,000 $ - $ - $ - 0.00% $ - $ 15,000 A2323 CRA Sustainable Economic Redevelopment DEO 70 $ 70,000 $ 20,000 $ - $ 20,000 28.57% $ 50.000 $ - A2324 Riverview Area Improvements DST 74 S 73,591 $ - $ - $ 0.00% $ - S 73,591 A2326 Artifical Reef Grants ARPA 3 $ 2,500 $ - $ - $ - 0.00% $ - $ 2,500 A2330 Concrete Mixer Truck DST 357 $ 357,000 $ - $ - $ - O.ODI/1 $ - $ 357,000 A2331 Bucket Truck DST 159 $ 159,000 $ - $ - $ - 0.00% $ 158,219 S 781 A2332 Brush Truck DST 122 $ 122,000 $ - $ - $ 0.001/ $ 121.543 S 457 A2333 Dump Truck DST 185 $ 185,000 $ - $ - $ 0-001/1 $ 184,500 S 500 A2314 Sidewalk (Davita Dialysis) DST 200 $ 200,000 $ - S - $ - 0.001% $ $ 200,000 A2335 Street Repaving LOOT 600 $ 600,000 $ - S - $ - 0.00% $ - $ 600,000 A2336 Street Reconstruction LOOT 250 $ 250,000 $ - $ $ - 0-001% $ - $ 250,000 A2337 Sidewalk Replacement LOOT 75 $ 75,000 $ - S - $ - 0-00% $ - $ 75,000 A2338 US I Patterned Paveway DST 480.1 $ 480,105 $ 480,105 S - $ 480,105 100.00 % $ - $ - A2350 Runway 10-28/Taxiway Bravo Markings FDOT/AP 37.819.5 $ 47,268 $ - $ - $ - 0.001% S 47,268 $ (0) A2351 Runway 05-23 Rehab FAA/FDOT/DST 1,427/79/79 $ 1,585,455 $ - S - $ - 0A01% $ - $ 1,585,455 A2360 Swales/Driveways/Culvens DST 150 $ 150,000 $ - $ - $ - 0.001% $ $ 150,001) A2361 SW Bulldozer DST 150 $ 150,000 $ - $ - $ - 0.001% $ 136,976 $ 13.024 A2362 Sliplining DST 150 $ 150,000 $ - $ - $ - 0.00% $ - $ 150,0DO A2363 Canal Restoration FEMA/DST 11,0001500 $ 11,500,000 $ - $ - $ - 0.00% $ - $ 11.500,000 A2364 Stonecrop Drainage Improvements FEMA/DST 1,118/1,824 $ 2,941,591 $ 356 $ - $ 356 0.01% $ 718,363 $ 2,222,872 S 21,117,317 $ 661,919 $ - S 661,919 3.13% $ 2,710,784 S 17,744,614 GRAND TOTAL $ 44,337,806 $ 1,%4,281 S 15,604,079 S 17,108,360 38.59% S 4,196,543 S 23,032,902 QUARTERLY INVESTMENT REPORT FOR THE QUARTER ENDED MARCH 31, 2023 At March 31, 2023, the total of the City's cash and investments were $24,846,080.73. Of this, $20,312,007.10 was held in an interest bearing checking account at Seacoast National Bank, $3,994,956.98 was invested with the State Board of Administration and $539,116.65 is deposited with Florida Trust. 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 3.60% for the Bank and 5.06% for the State Board. The average annualized return over the 3 months of this quarter from the deposit with Florida Trust was positive with a gain of $5,093.69. This is expected to continue being positive in the coming quarters. Florida Trust is pool fund that deals in government securities averaging less than 2 year maturities. SEACOAST NATIONAL BANK STATE BOARD OF ADMINISTRATION (SBA) CURRENT CURRENT CASH BALANCE ALLOCATION BALANCE PERCENT INVESTMENT ALLOCATION BALANCE PERCENT General Fund $ 7,790,942.96 38.36% General Fund $ 852,487.05 21.34% American Rescue Plan Act 2,454,461.37 12.08% American Rescue Plan Act 433,641.52 10.85% Local Option Gas Tax Fund 753,478.95 3.71% Local Option Gas Tax Fund 132,649.01 3.32% Discretionary Sales Tax Fund 2,846,407.83 14.01% Discretionary Sales Tax Fund 501,273.97 12.55% Riverfront Redevelopment Fund 762,474.47 3.75% Riverfront Redevelopment Fund 134,514.32 3.37% Parking In -Lieu -Of Fund - 0.00% Parking In -Lieu -Of Fund 92,865.49 2.32% Recreation Impact Fee Fund 318,174.58 1.57% Recreation Impact Fee Fund 55,985.66 1.40% Stormwater Utility Fund 2,313,170.58 11.39% StormwaterUtility Fund 409,045.82 10.24% Law Enforcement Forfeiture Fund 44,202.67 0.22% Law Enforcement Forfeiture Fund 7,803.6E 020 % Stormwater Series 2003 Debt Service Fund - 0.00% Stormwater Series 2003 Debt Service Fund - 0.000% Capital Projects Fund (104,171 26) -0.51% Capital Projects Fund 0.00% Capital Improvements Fund (15,650.00) -0.08% Capital Improvements Fund 0.00% Transportation Fund (0.10) 0.00% Transportation Fund _ 0.00% Stormwater Projects Fund (2,360.06) -0.01 % Stormwater Projects Fund - 0.000/ GalfCourseFund 703,512.20 3.46% Golf Course Fund 124,151.35 3.11% Airport Fund 456,63220 225°% Airport Fund 80,821.08 2.02°% Airport Projects Fund 17,180.24 0.08°% Airport Projects Fund - 0.00% Building Department Fund 1,663,892.67 8.19% Building Department Fund 294,171.96 7.36% Cemetery Trust Fund 218,907.80 1.08% Cemetery Trust Fund 873,206.07 21.86% Performance Deposits Fund 90,750.00 0.45 % Performance Deposits Fund 2,340.00 0.06% Total Bank Balance $ 20,312,007.10 100.00 % Total SBA Balance $ 3,994,956.98 100.00 Fund Making Loans GENERAL FUND: Due from Golf Course DISCRETIONARY SALES TAX: Due from Airport Fund Due from Airport Fund INTERFUND LOANS REPORT 10/01/22 Scheduled Balance at Purpose Balance Payments 09/30/2023 Remarks/Terms Cash Flow Loan $465,000 $35,000 $430,000 Pay $35K/Year or More. $285,000 Hangar A $253,171 $7,873 $267,511 Hangar B $249,575 $8,517 $245,298 5 Years @ 3%, Then 4% for 25 Years. Final in 2038 $241,058 5 Years @ 3%, Then 4%for 25 Years. Final in 2041. BUILDING FUND: Due from Golf Course $700,000 Irrigation $553,159 $31,352 $522,611 Each 5 Years to T-Bond Minus 1%. Final in 2038. I Due from Golf Course $559,684 Other Repairs $559,684 None $559,684 Pay When Possible, Maybe After $700,000 is paid. DEBT DUE TO OUTSIDE PARTIES Initial Principal Principal Balance at Final Initial Bond Debt Description Amount 9/30/2022 Interest Rate Maturity _ Rating/Insurer _ Security Pledge Paving Improvements (Final 12/01/2022) $2,296,000 $121,000 1.94% 2022 N/A Local Option Gas Tax Promissory Notes 2012 Police Camera System $353,624 $80,482 2.75% 2025 N/A N/A 60 Month Lease Purchase May 2021 1 Ib CRCF HOME OF PELICAN ISLAND To: Mayor and City Council Thru: Paul Carlisle, City Manager From: Kenneth W. Killgore, Administrative Services Director Date: February 21, 2023 Re: 2°" Quarter Accomplishments Fiscal Year 2023 The following are the 2nd Quarter Accomplishments for City Departments as assembled and edited by the Administrative Services Department for the three months ended March 31, 2023. CITY CLERK Legislative Sunt)ort Matters • City Clerk prepared agenda, attended/recorded six Regular City Council meetings, one special meeting and two workshops. • Records Specialist attended one Regular City Council meeting. • Completed follow up of approved Council matters — contracts, letters, e-mails, scanned to LF and indexed. • Ten resolutions adopted by Council. • Five proclamations prepared for presentation by Council Members. • Two documents recorded in public record at the Courthouse. • Provided monthly City calendars and revisions to Council, City staff and press. • Ten advertisements placed with TC Palm. • Sent two certified letters to County regarding annexations. • Notified relevant agencies of boundary change. • Made travel arrangements for Legislative Action Days. • City Clerk prepared agenda, attended/recorded three Regular City Council meetings and two Special Council meetings. Records Manaaement Prozram • Responded to 73 public records requests. • 114 cubic feet of paper records met retention along with duplicate and OSA records destroyed by shredding vendor. • Airport, Community Development and Parks documents, maps, surveys, were imported into Laserfiche for permanent and long term record. Election Matters • Executed 2023 election agreement with SOE. • Coordinated polling locations for 2024 Election with SOE. City Board Matters • Noticed vacancies, prepared six board appointments, notified and provided info to appointees, updated Board Handbook and distributed pages. • City Clerk prepared agenda, attended/recorded one CRA and one BOA meetings within Council Meetings. • Records Specialist published all scanned City board packets to City website and Laserfiche and provided them to the press and Council. • Coordinated board/committee meeting minutes between staff and technical writer. Cemetery Matters • Certificates of Interment Rights issued for 19 locations for a total of $47,850. • Scanned all cemetery records as sold or amended for permanent retention. Personnel/Educational Matters • Records Specialist attended three Project Management meetings. • City Clerk Administered oath to four Police Officers. • City Clerk and Records Specialist completed KnowBe4 training classes. • City Clerk and Records Specialist attended crisis counseling at the Yacht Club. • Records Specialist attended FACC Resolution and Ordinance Webinar. Communitv Matters • Responded to or forwarded CITYSEB emails to appropriate departments. • City Clerk and Records Specialist attended three Centennial Celebration meetings. • City Clerk attended Supervisor of Elections round table with Indian River County Clerks. • City Clerk attended the City Health Fair and Expo. 1-I ADMINISTRATIVE SERVICES • Provided administrative support to the Police Pension Board. • Worked with Auditors to complete the FY2022 Audit Report and Financial Statements. • Prepared various other mandated State and Federal reports on the fiscal year ending September 30, 2022. • Prepared 1" Quarter Budget Amendment and made presentation to Budget Committee and City Council. • Developed the budget calendar for events that will keep preparation of FY2024 budget on schedule. • Assisted with negotiations of Labor Agreements. • 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. • Documented bids and proposals for purchases to insure purchasing policies were followed. • Reviewed and edited contracts and other agreements. • Edited agenda items submitted for contracts and payments requiring City Council approval. POLICE DEPARTMENT Administration • Continued review of agency policies per accreditation standards. • Conducted interviews for Police Officers, Dispatchers and a new Police Chaplain. • Attended Florida Police Chief's Winter Conference. • Completed an audit on the Investigation and Evidence Safe. • Continued our quarterly auditing and inspection of the police building and equipment. • Attended 7 Council and Special Event/Workshop meetings. • Responded to 13 public records requests. • Attended Executive Round Table Meetings. • Participated in the Martin Luther King Jr. Parade. • Conducted 1 Treasure Coast Chiefs of Police and Sheriff s Association meetings. • Completed an annual Confidential Files review. • Completed a Bias Based Profiling annual review. • Completed a Use of Force annual review. • Swore in 4 new Police Officers. • Conducted 3 leadership and multiple weekly staff meetings. • Received approval of a grant for Police Equipment. • Attended the unveiling of a POW Statue Event at Riverview Park. • Attended 3 Substance Awareness Center Executive Board Meetings. • Attended multiple other civic and agency related meetings including Multi -agency assemblies and Special School Board meetings. • Attended 3 Juvenile Justice 19th Circuit Advisory Board Meetings. • Had an annual meeting with the Arden Greer Trust Board of Advisors. • Conducted a semi-annual Police Volunteer and Crossing Guard appreciation meeting. Volunteers • The Community Service Volunteers worked a total of 2,678.8 hours during this quarter. • 72 bank deposit details were completed so City Hall employees do not need to leave their assigned duties. • 40 traffic control details were assigned. These details involve directing traffic at city events, road closures, etc. • 197 house watches/close patrols were completed. • 50 vehicle transports were made consisting of taking vehicles to different locations for repairs, etc. • 1,016 business checks were made. These business checks are conducted to help patrol officers keep an eye on the business community which helps reduce crime. • 279 area checks of banks were made. Visual marked units around the banks at various times helps to deter crime. • 156 Airport checks were made. The visibility helps to deter crime. • 57 special details were assigned. • 3 miscellaneous assists for law enforcement personnel. • 97 paperwork runs, i.e.: State Attorney's Office, Sheriff's Office, etc. The Volunteers pick up and deliver packages such as City Council packages, State Attorney documents, and miscellaneous items as needed. • Assisted with traffic control on 32 traffic crash scenes. • 195 citizen contacts. • 590 miscellaneous jobs. • 11 Escorts were completed. f7 School Resource Officers Area/school checks 1U4 11b 122 342 f Life Skills classes taught 0 4 4 8 Reports 3 2 0 5 Crossing Guard contacts 8 12 7 27 Mentor lunches 12 13 15 40 Patrol Hours 72 8 48 128 Communty event hours 5 6 3 14 ICommunty event hours if Road Patrol Coverage Mentors lunches ' �l Mar Crossing Guard contacts ar Feb Reports ■ Jan Life Skills classes taught Area/school checks O 20 40 60 80 100 120 140 Road Patrol and Special Operations • Officers were dispatched to 4,953 calls for service, and self -initiated 2,331 events. • 78 adult and 4 juvenile arrests were made. • 1 Juvenile Civil Citation was issued. • Officers issued 300 citations, 13 parking citations, and 553 written warnings. • Officers completed 588 offense reports and 117 crash reports. Special Operations Citations I Warnings Incident Reports Arrests Citizen Contacts Marine & Natural Resources* 0 0 0 0 0 *The traffic officer position is temporarily vacant due to personnel shortages. "Marine & Natural Resources unit is not a full time position. K-9 Unit • K-9 Training Hours: 370 • Misdemeanor Arrests: 2 • Felony Arrests: 4 • Narcotic Searches: 13 • Activity Reports: 4 • K-9 Demonstrations: 2 • Schools Attended: 0 • Additional Training Hours: 64 • Agency Assisted: Fellsmere Police Department and Indian River County Sheriff's Office. t Detectives Subpoenas 1 5 2 8 Arrests 0 0 3 3 Warrants 2 2 2 6 j Training/Meeting Hours 8 29 16 53 Follow -Ups 18 15 15 48 Active Cases 17 10 9 36 Assigned Cases 10 11 12 33 Cleared Cases 5 4 4 13 j Inactive Cases 7 6 5 18 Supplements 14 12 11 37 j Call Outs 5 3 3 11 Background/CVSA's 6 6 4 16 j �i TJ Fct1 I roa: I`rotars Court Order Documents 4 4 Arrests 1 1 Warrants 1 1 Training/Meeting Hours 75 86 110 271 Follow -Ups 2 8 6 16 j Active Cases 8 3 8 8 Officer Intel 4 5 5 14 Crime Stoppers Intel 4 7 2 13 Other Intel Source 2 4 3 9 Cleared Cases 2 2 Inactive Cases 1 2 1 4 ' Supplements 6 7 6 19 Surveillance (hours) 60 43 35 138 Agency Assist 1 1 Surveillance (hours) Supplements — Inactive Cases Cleared Cases Other Intel Source Crime Stoppers Intel P March Officer Intel ■ February Active Cases Follow -Ups y— ■ January Training/Meeting Hours Warrants Arrests Court Order Documents 0 20 40 60 80 ARRESTS 0 0 1 1 WARRANTS 0 0 1 1 I TRAINING/MEETINGS (hours) 10 3 12 25 IFOLLOW-UPS 7 5 5 17 (ACTIVE CASES 6 5 3 14 IASSISGNED CASES 2 3 1 6 I CLEARED CASES 3 2 1 6 JINACTIVE CASES 0 0 0 0 SUPPLEMENTS 7 5 5 17 COPE QUARTERLY REPORT COMMUNITY EVENTS (man-hours) 31 44 32 107 AGENCY OUTREACH EVENTS (man-hours) 20 4 21 45 COMMUNITY MEETINGS (man-hours) 2 0 2 4 SCHOOL RELATED EVENTS (man-hours) 0 13 8 21 PUBLICTRAINING CLASSES (man-hours) 4 3 17 24 REGIONAL OUTREACH (man-hours) 0 0 0 0 ,PROBLEM ORIENTED POLICING (man-hours) 0 0 0 0 IPUBLIC SAFETY CADET ACTIVITIES (man-hours) 0 0 0 0 'TRAINING SCHOOLS (man-hours) 0 0 0 0 1IN-SERVICE TRAINING (man-hours) 0 12 18 30 SOCIAL MEDIA MANAGEMENT (man-hours) 2 6 5 13 ADMINISTRATION & RESEARCH (man-hours) 18 12 12 43 ROAD PATROL COVERAGE (man-hours) 10 6 0 16 MARINE PATROL & NATURAL RESOURCES (man-hours) 0 0 0 0 MARINE PATROL & NATURAL RESOURCES (arrests) 0 0 0 0 MARINE PATROL& NATURAL RESOURCES (citations/criminal & non) 0 0 0 0 MARINE PATROL & NATURAL RESOURCES (warnings) 0 0 0 0 ;MARINE PATROL& NATURAL RESOURCES (vessel stops) 0 0 0 0 SCHOOL RESOURCE COVERAGE (man-hours) 20 20.5 2 42.5 5 so Communications Division 1 100 ISO MARINE PATROL& NATURAL RESOURCES (vessel stops) MARINE PATROL& NATURAL RESOURCES (warnings) w MARINE PATROL& NATURAL RESOURCES (citations/criminal & non) MARINE PATROL & NATURAL RESOURCES (arrests) MARINE PATROL& NATURAL RESOURCES (man-hours) ROAD PATROL COVERAGE (man-hours) ADMINISTRATION & RESEARCH (man-hours) SOCIAL MEDIA MANAGEMENT (man-hours) IN-SERVICE TRAINING (man-hours) TRAINING SCHOOLS (man-hours) u PUBLIC SAFETY CADET ACTIVITIES (man-hours) PROBLEM ORIENTED POLICING (man-hours) it REGIONAL OUTREACH (man-hours) w PUBLIC TRAINING CLASSES (man-hours) N SCHOOL RELATED EVENTS (man-hours) COMMUNITY MEETINGS (man-hours) AGENCY OUTREACH EVENTS (man-hours) COMMUNITY EVENTS (man-hours) Disp. Calls For Service 1,621 1,701 1,834 5,156 Officer Initiated Calls 742 613 957 2,312 Code Enf. Initiated Calls 1,438 2,002 2,436 5,876 Volunteer Initiated Calls 265 230 370 865 Calls Entered Into CAD 4,154 4,694 5,676 14,524 911 Calls Received 969 939 1055 3,032 911 Calls Transferred Out 395 346 396 1,137 911 Hang-up Calls 128 127 143 398 Admin. Calls Received *** 2535-631 2530-715 2817-687 8064-2033 Admin. Calls Transferred N/A N/A N/A N/A Outgoing Admin. Calls N/A N/A N/A N/A j Training/Meeting Hours 8 8 14 30 911 phone report system is still not working correctly so we still can not run reports from here. All reports before that date are no longer available to us. *** First set of numbers is directly from the phone system the second set is from CAD which is only the calls for service. Training/Meeting Hours Outgoing Admin. Calls Admin. Calls Transferred Admin. Calls Received 911 Hang-up Calls 911Calls Transferred Out 911 Calls Received Calls Entered Into CAD Volunteer Initiated Calls Code Enf. Initiated Calls Officer Initiated Calls Disp. Calls For Service ill 0 1,000 2,000 3,000 4,000 Month 3 M Month 2 ■I Month 1 5,000 6,000 ,? X 6 Crime Scene/Evidence Items Received Evidence Processed In-house Evidence Outsourced Items Returned Items Purged Cars Impounded Video Redaction Hours Video's downloaded/sent CD's used Supplements Written Evidence Processing Hours Crime Scene Processing Hours I raining Hours Call Outs Fingerprints Fingerprints i Training Hours I 01 Evidence Processing Hours V CD's used R 73 120 90 283 2 4 7 13 19 32 8 63 18 5 12 35 3 0 O 3 O 1 1 2 118 122 252 492 294 342 507 1,143 40 33 88 161 3 1 8 12 3 10 28 41 4 10 14 28 2 2 4 8 2 1 1 4 6 3 4 13 Video Redaction Hours, i Items Purged Evidence Outsourced Items Received O 100 Mar Feb Jan 200 300 400 500 600 1 Code Enforcement Of the 5,975 code calls for the quarter the following is a breakdown of some specific calls made: • Issued 184 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. • 114 property inspections for title companies and 101 sign violations. • 447 Code Services. • 231 re -inspections, 23 violations were not complied with, 36 were posted for abatement, 0 abated by vendors. • 179 violations complied. • 3 Liens filed, 3 liens released. • 43 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 0 calls for water violation during the 2nd quarter. Alarm Assessment • $110.00 in alarm permits (new and renew). • $50.00 in false alarms fines. • 100 alarm responses by officers, 136 of these were false. • 11 New permits issued. 7 ROADS Asphalt • Put down 27 3/4 tons in various areas through- out the city • Filled potholes and various other areas with 3 pallets of cold patch aprox. 4 '/z tons Concrete • Broke out 28 ft. section of broken sidewalk next to cell tower at Friendship tennis courts. Chopped out massive root clusters and formed up. • Broke out 3Oft. of broken sidewalk next to Boys and Girls Club leading to playground. Chopped out root clusters and formed up. A Thomas poured both but we assisted putting cement down. • Dug out areas, formed around sign bases and poured 28 bags of cement for pedestrian crossing signs at Main and Easy St. • Poured 18 bags for approach to new pier that was built at the Stormwater treatment facility. • Assisted in driveway removal at various addresses on Quietscent and Quatrain for drainage improvements. Grinding • Preformed quarterly inspection on I.R.D. sidewalks and ground down all tripping hazards that were present. Ground down various trip hazards throughout the City. Mowing • Cut back various vacant lots of sight and drainage obstructions by hand while side arm tractor was down for repairs and by machine when tractor was repaired. • Mowed grounds to compound and various other City owned areas and bridge approaches. Assisted SW in mowing retention pond areas. • Cut back trees on N. Central Ave from Davis to Jackson that were blocking sidewalk. Misc. • Moved furniture around for carpet replacement upstairs at City Hall. • Transported two plotter machines from City Hall to new compound for GIS planner. • Assisted Sign shop in process of restriping medians and road edges on Laconia from 512 to Roseland road. • Assisted SW with side yard pipe install and road crossing replacement on Blossom Dr. • Filled in numerous road edges through- out the City with road base and millings. • Assisted Airport with installing orange fencing around gate 21 area for skydive event. • Assisted in Golf cart retrieval and repairs. • Cut back entire alley way of overgrown trees and bushes. • Re -graded overflow parking lot with millings for River Days Event. Facilities Maintenance • Maintain City Flags. • Maintain and monitor all lift stations. • Monthly A/C maintenance all City Buildings. • Monthly monitoring and supplies AED stations. • Daily maintenance and repairs city buildings. • Monitor Cleans Space janitorial service. • Elevator inspections (TK Elevators). • City Hall: Elevator inspections. • Quarterly fire and sprinkler test: ADS • Senior Center: Install Dakin AC unit (Arnold). • Police Department: Replace Backflow protector. • City Hall: Interior painting second floor. • Police Dept: Painting conference room B. • City wide: Backflow testing 2023 completed. • Golf Course: Replace backflow protector Airport Dr. East. • Sports Complex: Replace backflow protector (Maxwell). • City Hall: Carpet replacement second floor. • City Hall: Roof repairs (Leeward). • City Hall: Window Treatments second floor (window solutions). • Riverview/Splash Pad: Urinal replacements (Maxwell). • Friendship Tennis: Office lighting ,replace fixtures. AV Sign Shop • Signage and Installation: • Created; 85 • Signs Installed: 64 • Signs Straightened. 70 • Signs Cleaned: 39 • Trees Cut by signs: 2 • Traffic Studies: 5 • GIS Locations 8 • Decals:45 • Pavement Markings: • Stop Bars: 31 • Yellow Line Striping: 7109 LNFT. • White Line Striping: 4657 LNFT • Parking Lots: 0 • Cross Walks: 2 • Handicap stalls: 10 • ADA Mats painted: 116 • Blue Paint: IN FT.:70 • Arrows:0 • Special Projects: • Annual Sign Inspection Zone 1: 100% Completed • Install Anchor Supports on street/stop signs along Roseland & Sebastian Blvd. 100% Complete • Annual Sign Inspection Zone 2: 100% Completed • New Projects: • Install RRFBs: 50% Completed (Main/Easy)(Main/Powerline) • Stop bars and crosswalks road paint zone 1: 90% completed • Clean & paint ADA mats: 100%Completed • Road Striping Laconia St., Roseland to 512: 100% Completed • Zone 3 Sign inspection: 1% Completed • Zone 2 Stop bars and crosswalks: Material ordered • M.O.T/Special Events 5 • School Lights: 4 • Citizens Request: 4 (4 completed). • Work Orders: 60 (54 have been completed). • Created Signs Breakdown: • Street Signs: 4 • Warning:748 • Park:3 • Aviation:3 • Regulatory:16 • Construction zone warning: 2 • School:3 • Ordinance:7 Cemetery • Routine Mowing/Weed Eating and Edging. • Fixed Sprinkler Heads. • Office remodel. • Cremains:l0 • Burials:4 • Irrigation Line repair. • 2 gate valve repairs. • Fence quotes, new fence installation contract. • Rain Gauge: 5.50 9 0 Construction Specialist Golf Course • Storm repair to netting. • Repair leak at bathroom back flow City Hall. • Carpeting 2nd floor. • Repair/replace parking lot lights. Indian River Dr. • Street lighting repair. • Light pole replacement prep. • Twin pier lighting repair. • Street light conversion to LED. Stormwater Park • Pier replacement Lake #1. Parks • Barber St. sports complex power install. • Memorial fountain repair. • Yacht club bathroom repair from damage. • US 1 irrigation pump electrical repair. • Riverside Repair/Replace lights and electrical plugs. • Hardee light repair and replace. • Tennis court lights repair/replace Schumann Park. Crabby Bill's • Repair backflow leak. • Warf light replacement. Cemetery • Office lighting install. • Office electrical repairs. • Plumbing repair. PD • Flooring install , ice machine install, light repair/replacement. • Door repair. Yacht Club • Bathroom repair damage. • Replace dock ladder. US Hwy 1 • Replace electrical panel for irrigation system. Fleet Manaeement: • The Fleet Management Staff completed 185 repair work orders, 27 preventive maintenance services, 2 service calls and 1 road trip to pick up parts. • In addition to in-house work orders, 12 vehicle and equipment repairs were scheduled and completed by outside vendors. • Took delivery of the following units: • (1) GMC Sierra. • Completed the prep (Lights, Rack, Graphics, etc.) on the above vehicle. • Completed Sales on Gov. Deals: $14,910.00. • Fuel Cost as of Jan. Feb. Mar. 2023: • $2.99 per gallon of gasoline. • $3.68 per gallon of diesel fuel. • $3.31 per gallon of diesel fuel off road. 10 °2 LEISURE SERVICES Parks Division • Moved and pressure washed stage, Open and closed stage • Maintain area by removing carts • Install marquis signs by the clock tower • Remove Christmas tree at Riverview Park • Install new cranks for the nets at the pickleball courts • Spray WOW at Riverview Park, Schumann Park • Move Bleachers for upcoming event • Closed the road for upcoming event at Riverview Park • Return golf carts from event at Riverview Park • Installed tennis net at Friendship Park • Repair fence at George St. playground • Installed parking curbs at Riverview Park, City Hall • Maintain area by a living coral reef at Crabby Bills • Loaded trailer for event at Memorial Park • Re -attached windscreen at Pickle ball court • Inspected playgrounds at the park • Moved bleachers to the High School • Installed basketball net at Barber St Sports Complex • Maintain the area by opening the doors for workers at City Hall • Remove furniture at City Hall • Maintain the area by moving the medians at Barber St. • Work Events at Riverview Park • Repaired the border around playground at Friendship Park • Install sod on the medians at US 1 • Install bricks at Memorial Park • Loaded trailer for event at the baseball fields • Re -attach the canopy at Friendship park tennis court • Remove stop curbs at Riverview Park • Pick up light towers for upcoming event at Riverview Park • Blocked off the yacht club and parking area for upcoming event • Re -install parking curbs at Riverview Park • Prepare for event at PW compound • Maintain area by pressure washing the stage Recreation Division • Continued city run programs. 11 027 STORMWATER DEPARTMENT • 14 Driveway pipes for drainage. • 1 Fixed catch basin. • lside of road drainage pipe 140-18". • Cut back city property and drainage ditches. • Removed of pepper trees, dirt, re -sod city property. • Various drainage complaints. • Cleaning up quarter round on vacant lots. • Removed 755.5 cubic yards of debris. • Brought in 702 cubic yards of dirt. Citizen Rea uest Line • Jan. = 72 Approximately 24 were for Stormwater (33%) 11 Roads (13%) 14 General Questions (19%) 4 Signs (.05%) Eric 2 (.03%) 10 Code, 6 County, 1 Parks (.01%) Other 16 (22%) • Feb. = 61 Approximately 17 were for Stormwater (28%) 10 Roads (16%) 13 General Questions (21%) 2 Parks (.03%) Eric 2 (.03%) FPL (.09%) 25 Other (23%) 14 County 3 Code, 1 No Call Back, 1 Bldg. Dept. • Mar = 97 Approximately 15 were for Stormwater (15%) 13 Roads (13%) 21 General Questions (22%) 4 Signs (4%) 3 Parks (.03%) 10 FPL. (10%) 4 Eric (.04%) 21 Other (16%) 3 Code, 14 County, 4 Bldg. Dept. 6 No Call Back • Jan. 2023 — 82 Requests • 24 Stormwater - 15 Completed, 8 on -going, 1 no call back. • 11 Roads - 1 no call back, 6 complete, 1 HO to do. • 4 Signs, 3 Speed study, 1 no call back • 10 Code - NA • 6 County - NA • 2 Eric — Done • 1 Parks — 1 No call back • 14 General questions - Including some RR, FPL, AT&T, WM & 2 no call back • 2 unknown • Feb 2023 —103 Request • 17 Stormwater - 15 completed, 1 no call back, 1 ongoing project • 10 Roads- completed • General questions - 4 County, 5 code - NA, 6 FPL - All done, 13 general questions - done, 10 roads - all done- 2 parks — 1 on going, 1 cannot do, 1 building dept. done, 1 unknown • Mar. 2023 —155 Requests • 15 Stormwater - 11 all done, 1 no call back, 4 ongoing projects , 3 Code, NA, 14 County - NA, 21 General questions done, 10 FPL - 3 done, 7 NA, 3 Parks - 2 done, 1 not us, 13 roads - 6 done, 1 ongoing, 3 no call back, 1 HO to do, 1 no asphalt, 1 not us paving , 4 signs - done 1, 1 Speed study, 2 not done, 4 Eric - done, 4 building department - 4 done, 5 no call backs • Inspection Tvve Inspection # Passed Failed Conditional Re -Inspection Fee • Final Engineering 240 200 39 1 $0.00 • Drainage Pipe Elevation 108 102 06 0 $0.00 • Driveway 141 112 29 0 $0.00 • Pre -Sod 115 87 07 0 $0.00 • Erosion Control Barrier 48 41 07 0 $0.00 • Total 652 542 114 1 $0.00 12 d22 GOLF COURSE Revenue 22-23 21-22 Difference 2°d Quarter Rev. $685,919 $632,538 +$53,381 YTD Tot. Rev. $1,273,275 $1,123,734 +$149,541 2°d Quarter Rounds 19,554 19,188 +366 YTD Tot. Rds. 34,180 33,152 +1,028 2°d Q. Green Fee $296,554 $270,347 +$26,207 2°d Q. Cart Fee $295,703 $285,689 +$10,014 2°d Q. Annual Member $8,542 $4,687 +$3,855 YTD Ann. Mem. $141,780 $134,283 +$7,497 2°d Q. USGA Hdcp. $720 $858 -$138 YTD USGA Hdcp. $5,328 $4,620 +$708 2°d Q. Disct. Card $8,986 $9,205 -$219 YTD Disct. Cd. $48,244 $39,527 +$8,717 2°d Q. Driving Range $24,658 $24,638 +$20 YTD Dr. Rge. $38,432 $40,030 -$1,598 2nd Q. Club Rental $735 $1,175 -$440 2°d Q. Golf Shop Retail $36,227 $33,472 +$2,755 2°d Q. Retail COST ($20,379) ($20,449) 2°d Q. Golf Shop Profit $15,848 $13,023 +$2,825 2°d Q. Golf Shop Margin 43.75% 38.91% YTD Shop Retail $76,160 $59,980 +$16,180 2°d Q. PGA Pro Lesson $722 $1,659 -$937 YTD Lesson $722 $1,864 -$1,142 Vt Q. Restaurant Rent $7,500 $7,500 $0 YTD Rest. Rent $15,000 $15,000 $0 *2nd Q. Rain amount 3.2" 6.3" -3.1" *Data obtained from weather underground. com • Comments • New golf carts have been approved and ordered. Existing fleet of carts being repaired as needed. Expected arrival date of new carts is January 2024. • Range netting bid created and companies have submitted bids. Existing range netting has been repaired in order not create a safety hazard to customers on the first or ninth fairways. • New ice machine on order, expected arrival date is end of May 2023. Currently, manually filling existing ice dispenser. • Revenue, golf shop sales and golf rounds have exceeded expectations; like many outdoor activities, Covid has certainly brought many people back to the game of golf. • Special events for 2nd Quarter included the Solid Rocket Booster Golf League (60 players), the Barefoot Bay Travel League (bi-monthly, 48 players each time), the Friendship Christian Church (52 players). All weekly leagues had good numbers in participation and frequency. • Golf Course grounds are in very good shape, despite the volume of play. Lack of rain and golf cart compaction has been an issue; staff is doing everything possible to alleviate drought and turf stress. Many favorable comments on the condition of the golf course greens. AIRPORT • Maintenance and cleaning of the AWOS. • Remove pepper trees around perimeter of airport. • Cleaned and greased all 4 flags. • Remove dead shrubs from Hanger A. • Set-up temp parking lot at gate 21 for skydive show. • Rebuilt airport sign out front. • Prep and pass FDOT inspection of Sebastian Airport. • Cleaned and oiled all gate motors and chains. • Chaperoned surveyors on RW 5-23. • Chaperoned cleaning contractor and painters on RW10-28 for restriping. • Serviced AP 10-AP08 sign boards. 13 027 BUILDING FUND • In the second quarter of this fiscal year, a total of 32 new single-family homes were issued building permits. The number of new single family homes has decreased by 40% compared to the first quarter of this fiscal year. Other permits of significance include 0 new manufactured homes, 0 new commercial buildings, 0 commercial additions, 3 commercial alterations, 0 commercial build outs, 2 residential additions and 93 residential alterations. In all, 950 building permits were issued in the second quarter. Even though housing was down this quarter other types of permits increased and so the overall permitting remained very much the same as the first quarter. • Total number of inspections for the second quarter was 3765 for an average of 60 building inspections per working day. The number of inspections for the second quarter stayed roughly the same as the first quarter. • The number of Certificates of Occupancy issued for the second quarter included 54 new single family residences, 1 manufactured home, 0 commercial certificate of occupancy, 0 commercial temporary certificate of occupancy and 0 commercial certificates of completion. • The following lists the Business Tax Receipt activity for the second quarter: • New businesses — 26 • Renewals — 82 • Transfers - 2 • Duplicates - 3 • Home based businesses - 9 • Commercial businesses - 16 • Insurance companies - 1 • Vacation rentals - 9 • Solicitor registrations - 4 There were 83 new Contractor registrations. In addition, there have been 73 requests for permit records on properties within the city from lien/title companies. During the second quarter the overall permitting and number of inspections has remained roughly the same as the first quarter. Single family permit activity has slowed somewhat, this is due to a decrease in sales according to the home builders we have spoken with. 14 .30