The URL can be used to link to this page

Home My WebLink About03-04-2024 BAC AgendaancF ST- % ��= -- :A HOME OF PELICAN ISLAND SEBASTIAN BUDGET REVIEW ADVISORY COMMITTEE AGENDA 6:00 P.M. MONDAY — MARCH 4, 2024 CITY HALL 1225 MAIN STREET a. Call to Order b. Pledge of Allegiance c. Roll Call d. Approval of Minutes: Meeting of February 12, 2024 e. Review of FY2023 4th Quarter Budget Report f. Committee Training - Jennnifer D. Cockcroft, Esq., BCS, City Attorney g. Next Meeting Date — Monday, May 13, 2024 h. Adjourn Agenda Attachments: • Minutes for Meeting of February 12, 2024 • FY2023 4th Quarter Budget Report 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.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 IN ADVANCE OF THIS MEETING. ZOOM INFORMATION Please click the link below to join the webinar: hftps:Hus02web.zoom.us/i/83733547557 Or One tap mobile: +13052241968„83733547557# US or +16469313860„83733547557# US Or Telephone: Dial(for higher quality, dial a number based on your current location): +1 305 224 1968 US or +1 646 931 3860 US or +1 929 436 2866 US (New York) or +1 301 715 8592 US (Washington DC) or +1 309 205 3325 US or +1 253 205 0468 US +1 312 626 6799 US (Chicago) or +1 253 215 8782 US (Tacoma) or +1 360 209 5623 US or +1 346 248 7799 US (Houston) or +1 386 347 5053 US or +1 507 473 4847 US or +1 564 217 2000 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 Webinar ID: 837 3354 7557 International numbers available: httDs://us02web.zoom.us/u/kmoaeZ5TC CITIZENS BUDGET REVIEW ADVISORY COMMITTEE MINUTES OF REGULAR MEETING FEBRUARY 12, 2024 Chairman Napier called the Citizens Budget Review Advisory Committee meeting to order at 6:00 p.m. II. The Pledge of Allegiance was recited by all. Ill. Roll Call Present Mr. Hoffman Mr. Napier Ms. Cerda Mr. McGinn Mr. Middleton Also Present Mr. Newhart Ms. Reed Mr. Hall Mr. Ken Killgore, Director of Finance Ms. Barbarba Brooke -Reese, MIS Manager Mr. Joseph Perez, AV Technical Assistant Ms. Watson, Director of Human Resources Ms. Walker, Recording Secretary IV. Introduction of Members (Name and Appointee). • Harry Hall • Bruce Hoffman • Terry McGinn • Bill Middleton • Larry Napier • Amber Cerda • Dave Newhart • Grace Reed (alt) V. Selection of Chairperson Mayor Jones Council Member Dixon Council Member McPartlan Vice -Mayor Nunn Council Member Dodd At -Large Member by Vote of Council At -Large Member by Vote of Council Alternate Member by Vote of Council Mr. Hoffman made a motion to nominate Mr. Napier for Chairman. Mr. Hall seconded the motion. There being no further nominations for Chairman. Mr. Napier called for a voice vote. CITIZENS BUDGET REVIEW ADVISORY COMMITTEE MINUTES OF FEBRUARY 12, 2023 Roll Call Mr. Middleton — Yes Mr. Hoffman —Yes Mr. Napier — Yes Mr. Hall -- Yes Ms. Cerda -- Yes Mr. McGinn -- Yes Ms. Reed (a) — N/A Vote was 7-0 in favor of Mr. Napier serving as Chairman. VI. Selection of a Vice -Chairperson PAGE 2 Mr. McGinn made a motion to nominate Amber Cerda for Vice -Chairperson. Mr. Hall seconded the motion. The motion was approved unanimously via voice vote. VII. Approval of Minutes: Meeting of July 17, 2023 Everyone having had a chance to review the minutes from July 17, 2023, called for a motion. A motion to approve the minutes as presented from July 17,2023 was made by Mr. Hoffman, seconded by Ms. Cerda, and approved unanimously via voice vote. Vill. Review Budget Calendar FY 2024-2025 Mr. Napier said he reviewed the calendar and stated there were four meetings scheduled. Everyone had a chance to review the budget calendar and there were no issues. IX. Comments by Finance Director Killgore Mr. Killgore announced formally that he will be retiring and his last fulltime day will be the February 29, 2024. He stated that he would be discussing possibilities with the City Manager on his participation in City Finance matters along with the budget committee until there is a replacement for his position. He stated there was no Quarterly Report to discuss at this meeting, however, there would be one presented in March. Everyone on the Advisory Committee took the time to share his or her appreciation for the knowledge Mr. Killgore conveyed on the committee and wished him a well on his retirement. X. Next Scheduled Meeting Date (Monday, March 4, 2024) Mr. Napier confirmed the scheduled meeting on Monday, March 4, 2024 and that there would be no new items. XI. Adiourn There being no further business, Chairman Napier adjourned the meeting at 6:24 p.m. By: Date: Larry Napier, Chairman Cepp ��anaF JEMS` HOME OF PELICAN ISLAND CITY COUNCIL AGENDA TRANSMITTAL FORM COUNCIL MEETING DATE: March 20, 2024 AGENDA ITEM TITLE: Resolution Accepting the 4 h Quarter Financial Report and Recognizing Necessary Amendments and Adjustments to the FY 2022-2023 Annual Budget. RECOMMENDATION: Move to Approve Resolution R-24-11. 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 the Short-term Disability Insurance, City Manager termination pay, Interim City Attorney cost, Senior Center roofing, Strategic Planning services and back pay for the City Clerk. City Council also approved the use of the General Fund R&R for repairs to City Hall air conditioners and replacement of a Parks vehicle. There are four small adjustments done during the quarter that used the General Fund R&R Account, which should be reported to City Council in accordance with our policy on R&R adjustments. These include using the R&R Account for replacing the air conditioners for the Police Volunteer office and Air Center, repairing a door lock at the Yacht Club, repairing an air conditioner at City Hall and repairing the backstop fencing at Friendship Park. 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. In line with this, the City Manager approved adjustments that closed out a number of completed projects or adjusted accounts for other reasons. Additional details on the above adjustments are listed in Exhibit "A" as an attachment to the Resolution. If Agenda Item Requires Ext)enditure 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-24-11 and Attachment "A" 2. 4th Quarter Financial Report, with Capital Project Status, Investments/Loans and Accomplishments Finance Department Review: City Attorney Review: Procurement Division Review, if applicable: City Manager Authorization: Date: RESOLUTION NO. R-24-11 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 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 September 30, 2023 was made and it was determined there were four budget adjustment to the General Fund R&R Account that are required to be formally reported to 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 are being 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 above recitals are hereby recognized as true correct and incorporated herein. Section 2. 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 September 30, 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 3. All Resolutions or parts of Resolutions in conflict herewith are hereby repealed. Section 4. 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 5. 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 Kelly Dixon 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 20`h day of March 2024, CITY OF SEBASTIAN, FLORIDA By: Mayor Fred Jones ATTEST: Approved as to form and legality for the reliance by the City of Sebastian only: Jeanette Williams, MMC Jennifer Cockcroft, Esq. City Clerk City Attorney .LxmiflIT "A" OF RESOLUTION R-24-11 SUMMARY OF BUDGET CHANGES FOR THE QUARTER ENDED September 30, 2023 ADJUSTMENTS PREVIOUSLY APPROVED BY CITY COUNCIL: Budget Before Budget Budget After nt Change Adiustment Chanqe Reason for Adjustment R&M Buildings - Facilities Maintenance $130,418 $23,651 $154,069 07/12/23 Utilized R&R Account for ppropriated from R&R Account _ _ _ -_ -f $237,399E -_ _ f $23,651) ($213,748 Repairs to City Hall Air Conditioners. YeJliclei pnd Equipment - Parks $101,jj7Q Q5 1 5,1:1 - ��. 07/12/23 Used R&R Account to Ii u,tuat, A�propnated from R&R Account _ _ Y _f $213,748 L$-,5) __�$2 _483� budget to replace 2004 Parks vehicle. Vehicles and Equipment - Airport $9,500 $18,932 $28,432 07/12/23 Used Auction Proceeds from Sale of Fixed Assets _ _$0 _____ _($18 932) _ __ J$18,932) Grader to buy two_mowers. Infr ructpre Fa%%rant $1,505 455 $1,�22,190 $3 407 94� Used DST Reserves to match 0AA -•---- FDQT Qfant --- ($1,426,609) �$79,273) ($1,639,972L ($91,109)___ ($3,b66,WPI) ($170,382) and FAA and FDOT Grants for Rehabilitation of Runway 05-23 project. A ro _dated from DST Reserves p�_p ___ _ I$ ,986,771 _�$91,109�-_f$3,077,880� Consultants $0 $120,000 $120,000 07/26/23 Sets up Resilient Florida Grant -........ _ .. FD $0 S$120,000�_ for update to Coastal Resiliency Plan. _ _ streets/Roads rainag! _ _ _ �pO,QOQ 0, 0 .......... - �S$120,000 $Q,5,88Q _5,880 -- -L $1.2Q�5,&$A $44,126 ---- - - 07/26/23 Makes ARPA 1-Unds Roadwork b deferrin Drive draina e. Y 9- Various Group Insurance Accounts $2,210,521 $8,066 $2,226,587 _Schumann -- - -- Appropriated from General Reserves ($602 775) ($6,620) ($609,395) Appropriated from Stormwater Reserves ($669 359) ($522) ($669,881) 05/24/2023 Additional funding needed for Appropriated from Golf Course Reserves _ , _ ($599028) ($173) 5 ($ 99,201) Short-term Disability Insurance. Appropriated, from Airport Fund Reserves ($76,38- ($113) Approp(ated_from Building Fund Reserves ($194,686) f $638) f $195,324) Wages qpo (3enefil Appropriates lrrom eneral Reserves P,3,14� ($ii6 ,17ii� $31 7Q0 ti$� i�) $269,932 ($698,966) Unused Leave paid at termination based on to formerManager's Contract_ Other Contractual S Appropriated 65,200 ($698 966) $ ($108,,230 110 ) $209 430 076) ($807,._._ _City 03/08/23 Funding needed for cost of the Various Other City Attome Accounts ---------------------------------------------- 1$88 388 ---- '------ .... 36 -- - ($- ,120)- _ $152,,26- Interim City Attorney. Buildings $ - �,781 $, 6,781 08/23/23 Established Senior Center Roof Appropriated_from General Reserves ------------ ($609,395� ----_ ($ E;,781 $b60,176 Re lacement ro'ect. Professional Services $0 $75,000 $75,000 09/18/23 Reestablished FY2023 Budget Appropriated from General Reserves ($807,076) ($75,000) ($882,076) for Strategic Planning Services Building Improvements -Airport $0 $400,000 $400,000 09/27/23 Adjustments to reflect funding FDQT Qrppt Contributions - - -- - -- - - - - - - d - -- - - -- - - -_ 2Q,000) 60,000 _______$80,000 - --� - -)- ($320,000) ( ) sources for Amendment to Lease with Profli ht Management on Hangar D -g - -- --------------- Wages and Benefits $166,126 „„ $3,409 . I...- . $169,535 ------------ 05/24/2023 Adjustment for City Clerk Appropriated from General Reserves i --- -- - - - - 599,366 �$ -L-- _ 9 �$602,775 --- back a approved b Ci Council. p Y-pP Y .� _ ADJUSTMENTS BEING SUBMITTED FOR CITY COUNCIL APPROVAL: Budget Before Budget Budget After Pro1ect/Account Chan_9e Adjustrrignt Change Reason for Adjustment Vehicles and E q! ment App[9p.gated_from R&R_Account $46,14 (010,483) $142 ($1 �26 W,174 f$1J6.457)__Volunteer& Used R&R Account to replace PD Art- Centerairconditioners. ----------------- Buildings pp p erom R&R Account ......... 54 069 6 457 ($1 ) ..... $1 574 f$1 574 $155 643 f $194 883 Used R&R Account to repair door lock at the Yacht Club. - - R&M Buildings .$ _________ ; 5_5,0i 4� --) 1 $ 3 995 ---- -) 169,636 - -- -- -- - - - - Used R&R Account to repair Unit 2 air App,uN,1ai�dfrom_ R&RA_cco_unt ($188,883 ($13,995)_____( 174,088) at City Hall_ R&M Fencin g $7, 000 $6,800 $13 00 ,8 _conditioner Used R&R Account to repair the backstop SAppropriated from R&R Account ------------------ ($194,883) - f $6,800) ($188,883) fencing at Friendship Park. Page 1 of 2 EXHIBIT "A" OF RESOLUTION R-24-11 SUMMARY OF BUDGET CHANGES FOR THE QUAto,.L.K ENDED September 30, 2023 ADJUSTMENTS PREVIOUSLY AUTHORIZED BY THE CITY MANAGER: Budget Before Budget Budget After Project/Account Change Adjustment Change Appropriated from DST Reserves ($3,494,254) $357,000 ($3,137,254) Vehicles and Equipment $357,000 ($357,000) $0 t Appropriaed from General Reserves ($882,076) $7,z10 ($874,86 R&M Irrigation Systems �48g $1,415 $1,904 _nfrastructure $358,473 ($8,624)-------- $349,848 ;appropriated from DST Reserves ($3,137,254) ...... $150,109 ($2,987,145) Infrastructure -0- $1,906,801........ ($150,109) $1,756,692 rb - F Grant ($37,8 J 4) _ $3,0 ($VM Appropriated from Airport Reserves ($7� 198) $818 _�$76,3801 Infrastructure $4 _,268 ... ($4,089)--------- $43,179 FDOT Grant ($35,000) $35,000 $0 Contributions &Donations 00 - $35,000 $0. Buildin s _______ ___ $70 000 _________ 70,00 ApproRriated from D$T_ Re§erves ($2,987,145) $374 ,77 ($2,9861) Computer Supplies $7,500 ($3,016) $4,484 Vehicles and Egwpment------------------------------------- ---------------- L--------------- $2,642--------- $10,142 Appropriation from DST Reserves ($3,077,880) $13,024 ($3,064,856) Project A2361 Stormwater Bulldozer $150,000 ($13,024) $136,976 - - A�propri�iion from I Kegerves Appropriation from DST Reserves ---- - -- -; --- $8Z74♦$66) (3,a84 E8f --- �4,�49 s�, 4, 68 ------------ ($870,026l ($2,989,888) Various Completed Projects - $1,967,236 ........ ------------ --- - ($79,808).... ($1,887,428) Appro nation from LOGT Reserves p ($356 494) $72,142 ($284,352) Sidewalks $75,000 t$72,142) $2,858 - Interest on ARPA Funds ($11,500) $2 QO 60 ($9,0001 Departmental Supplies______________________________$2 - _______ ($2, _______________$0 Appropriation from D8T Reserves ... 1$3,029,792� $200 ($3,029,592) Infrastructure $979,007 ($200)_______ 5978,807 100 Anniversary�S Q 6Q) 1149 $66,100 abDonA& -------- ($11,1QO) 130Contributions ($,10) Page 2 of 2 Reason for Close Concrete Mixer Truck and returns funds to DST Reserves. Closes Yacht Club Seawall and returns funds to General Reserves. -------------------------------------------- Defers Airport West Side Sewer work and returns funds to DST Reserves. 'dioses Runway 10-28 and Taxiway Bravo Markings project and returns funds to Airport Reserves_ Delays in negotiating with the selected contractor resulted in changes to plans. ---- ---- --- -- ------ ------ -- --- ---- ----- - -- -- Closes MIS COSty Equipment project and returns funds to DST Reserves. Adjustment to close Project A2361. Adjustment to close out remaining unexpended balances of completed projects at -year-end - Close out remaining unexpended balance of Sidewalk Replacement Project. Adjustment to close out u. .,,ANo, id,-,d balance of Artificial Reef Grant Close Project for Runway 05/23 Design of Rehabilitation. Recored adcri{(onwf o_ WIribuiions toward Centennial Celebration. CITY OF SEBASTIAN QUARTERLY FINANCIAL REPORT FOURTH QUARTER ENDING SEPTEMBER 30, 2023 SUMMARY GENERAL FUND RECEIVED 106.8% OF BUDGETED REVENUE AND EXPENDITURES WERE 92.6% OF BUDGETED AMOUNTS FOR THE YEAR. REVENUE WAS $1 MILLION OVER BUDGET. ($500K ELECTRIC FRANCHISE & UTILITY TAX, $110K CODE FINES, $150K INTEREST, $72K FEMA & $87K DEFERRED RENT.) GENERAL FUND SUMMARY Budget YTD % Beginning Balance $ - $ 8,195,001 Ad Valorem Taxes 5,146,342 5,102,270 99.1% Franchise Fees 1,567,286 1,775,486 113.3% UtilityTaxes 3,210,987 3,523,528 109.7% Intergovemmental 4,084,464 4,235,991 103.7% Charges for Service 745,870 763,311 102.3% Licenses and Other 502,200 889,264 177.1% Total Revenues $ 15,257,149 $ 16A9,850 106.8% From Fund Balance 970,933 - 0.0% Total Sources $ 16,228,082 $ 16,289,850 100.4% CityCouncil $ 62,725 $ 55,940 89.2% City Manager 342,355 337,591 98.6% City Clerk 226,599 226,019 99.7% CityAriomey 379,606 373,973 98.5% Admin Services 623,711 594,889 95.4% MIS Division 728,199 635,465 87.3% Human Resources 231,971 224,878 96.9°% Police Department 7,584,805 7,179,229 94.7% Roads and Garage 1,441,290 1,313,818 91.2% Public Facilities 863,688 790,792 91.6% Parks 1,386,316 1,217,694 87.8% Cemetery 164,404 161,719 98.4% Comm unity Development 701,873 504,123 71.8% Nan-Deparlm ental 1,435,071 1,353,201 94.3% Total Expenditures $ 16,172,613 $ 14,969,331 92.6% Unappropriated 55,469 - nla Total Uses $ 16, 28,082 $ 14,969,331 922% Ending Unappropriated Fund Balance I $ 9515,520 WE PREVIOUSLY RECEIVED ALL OF THE AMERICAN RESCUE PLAN ACT FUNDING AND THE CITY COUNCIL AGREED TO APPLY THOSE FUNDS TO THE ITEMS LISTED, AMERICAN RESCUE PLAN ACT FUND Budget YTD % Beginning Fund Balance c 5 2,869,473 ARPAGrant - n/a Interest 12,000 63,398 528.3% Total Revenues $ 12,000 $ 63,398 528.3%. From Fund Balance 2,696,156 - 0.0% Total Sources S 2,708,156 $ 2,932,871 108.3% Gardenia Ditch $ 746,156 $ 6,043 0.8% Schumann Drive 750,000 7,596 1.0% Concha Dam 700.000 0.0% Roadwork 500,000 0.0% Water Supply Work Plan 12,000 12,000 100.0% Total Uses $ 2,708,156 $ 25,639 0.9% Ending Fund Balance $ $ 2,907,232 Expected Change to Year End: Additional Revenues Additional E)Jenditures 9130123 Ending Available Funds $ 2,907,232 General Fund Revenue ■Adjusted Budget EYearto Date s,00a a 4,000 01 C 3,000 iE 2,000 t,OOD is odUkw �o General Fund Expenditures Mn J-a a„dg� ivearm Dare S e.sw 5$.- 0�0r G�wP�daS N.c O`��F'`�sce�""' G'!N p,0.Y pd`IPdR.M �7A5 O a60 Qvd�o �DEp'a FUND BALANCE USES FOR GENERAL FUND ARE SHOWN BELOW. RESERVES ARE MORE THAN PROJECTED. (REVENUE $1 MILLION HIGHER BUT THE EXPENDITURE DIFFERENCE WAS PARTIALLY DUE TO BUDGET INCREASES FROM RESERVES.) GENERAL FUND BALANCE FORECAST Fund Balance R&RAccount Beginning Reserves 10101122 $ 7,920,U01 $ 275,000 Year to Date Revenue 16,289,850 Fund BalancelR&R Changes to Date: Purchases Not Received (60,264) Unfinished 2022 Projects (215,065) Harbor Lights Fuel Tanks (17,850) CityAtiomey Recruitment (34,500) Exempt Pay Increases (70,621) Police Pay Increases (152,340) Increase to Centenial Funding (50,000) Closed A2216 Police Vehicles 1,274 Short-term Disability Insurance (6,620) City Manager Leave Payouts (32,790) Payments to Interim CityAttorne (108,110) Senior Center Roof Replaceme (56,781) Strategic Planning Services (75,000) City Clerk Back Pay (3,409) Closed Yacht Club Project 7,210 Closed Other Completed Projec 4,840 Replaced City Hall Refrigerator (1,148) Repairs to City Hall Balconies (36,453) Repairs to City Hall Air Conditioners (23,651) Replacement of Parks Vehicle (3,265) Replaced Volunteer & Art Center A/Cs (14,026) Repaired Door Lock at Yacht Club (1,574) Repaired City Hall Air Conditioner (13,995) Repaired Friendship Park Fencing (6,800) Year to Date Uses $ (870,025) $ (100,912) Other Expenditures (13,998,393) Ending Reserves $ 9,341,432 $ 174,088 Adjust R&R to $275,000 (100,912) 100,912 Adjusted Reserves $ 9,240,521.1 $ 275,000 Assigned Funds (666,992) - Employee Final Payouts (390,000) Net Unassigned Reserves $ 0,183,528 $ 275,000 Total Ending Reserves $ 8,458,528 Projected in 2023 Budget (with pay raises) $ 7,088,173 Assigned Funds include Inventories, Prepaids and the Golf Course Loan. CITY OF SEBASTIAN QUARTERLY FINANCIAL REPORT FOURTH QUARTER ENDING SEPTEMBER 30, 2023 SUMMARY COLLECTIONS OF STORMWATER FEES WERE CLOSE TO GOLF COURSE REVENUES CONTIN BUDGET AND INTEREST HIGHER. SPENDING WAS LOWER SOME RANGE NETTING COST END THAN ANTICIPATED. $163,622 WAS RECEIVED FROM THE STORMWATER FUND SUMMARY Budget 1?D % Beginning Fund Balance $ • $ 1,957,126 Storm water Fees 1,952,055 1,949,304 99.9% Interest and Other 7,566 54,803 724.3% Total Revenues $ 1,959,621 $ 2,004,107 102.3% From Fund Balance 669,881 0.0% Total Sources $ 2,629,502 $ 3,961,233 150.6°% Operating Expenditures $ 2,211,917 $ 1,831,829 82.8% Capital Outlay 56,393 43,836 77.7% Transfer to Capital Projects 361,192 185,198 51.3°% Total Uses $ 2,629,502 $ 2,060,863 78A% Ending Fund Balance $ $ 1,900,370 Projected in 2023 Budget $ 1,179,343 REVENUE FROM AIRORT RENTS IS 81.3% COLLECTED. BEGINNING AND ENDING RESOURCES EXCLUDE THE PRINCIPAL DUE ON THE DST LOAN OF $502,746, AIRPORT FUND SUMMARY Budget YTD %Rent Beginning Resources $ $ 503,120 577,861 659,488 114.1 % FEIvWState Reimbursements 32,230 nla Investment Income 725 11,963 1650.1°% Mscellaneous 104,622 107,959 103.2°% Total Revenues 715,438 779,410 108.9% From Fund Balance 76,493 nla Total Sources $ 791,931 $ 1,282,530 Operating Expenses $ 521,046 $ 508,416 97.6°% DST Fund Loans 36,500 20,110 55.1%. Range Netting 36,834 36,834 100.0%i Capital Outlay 41,615 41,443 99.6% Transfers for Projects 75,889 72,524 95.6% Total Uses $ 711,884 $ 679,327 95.4°% Total Ending Resources 80,047 $ 603,203 Projected in 2023 Budget $ 583,167 UED TO BE FAVORABLE. ED UP BEING INSURED. SALE OF OLD CARTS. GOLF FUND SUMMARY Budget YTD % Beginning Resources $ $ 245,915 Charges for SerNce 1,631,611 1,744,269 106.9% Rent 30,000 34,527 115.1% Insurance Proceeds 23,342 48,342 207.1% FEMNState Reimbursements 77,472 - 0.0% Miscellaneous 10,760 188,038 1747.6% Total Revenues 1,773,185 2,015,176 113.6% Pro Shop Sales 110,000 123,899 112.6% Pro Shop Purchases (65,000) (93,932) 144.5% Sales vs. Cost ofSales 45,000 29,967 66.6% From Reserves -Cart Repairs 61,316 nla From Reserves - Carts 528,640 nla From Reserves -Pay Changes 4,245 nla From Reserves for Ditches 5,000 nla Total Sources $ 2,417,386 $ 2,045,143 84.6% Operating Expenses $ 1,609,079 $ 1,567,306 97.4% Equipment 7,889 7,889 100.0% Lightning Damage 21,097 21,097 100.0% Range Netting 88,826 88,826 100.0% Cart Purchase 528,640 528,640 100.0% Total Operating Expense 2,255,531 2,213,758 98.1 % General Fund Payment 35,000 35,000 nla Building Fund Payment 36,209 36,209 100.0% Total Uses $ 2,326,740 $ 2,284,967 98.2% Total Ending Resources $ 90,646 $ 6,091 Projected in 2023 Budget $ (302,729) BUILDING FUND RESOURCES EXCLUDE THE LOANS AND ADVANCES OF $1,112,843 ADVANCE: TO THE GOLF COURSE. BUILDING FUND SUMMARY Budget YTD % Beginning Resources $ $ 1,654,006 Licenses and Permits 1,229,500 876,023 71.3% Charges forSerNce 33,500 16,376 48.9% Fines and Forfeits 5,500 4,325 78.6% Miscellaneous 7,289 44,173 606.0% Golf Fund Loan Payments 36,209 36,209 100.0% Total Revenues 1,311,998 977,106 74.5% From Fund Balance 195,324 n/a Total Sources 1,507,322 977,106 64.8% Operating Expenses $ 1,273,182 $ 988,466 77.6% Capital Outlay 194,263 194,262 100.0% Total Uses $ 1A67,445 $ 1,182,728 80.6% Total Ending Resources 39,877 $ 1,448,384 Projected in 2023 Budget $ 1,493,883 GENERALFUND TAXES LICENSES & PERMITS INTERGVT'L REVENUE CHARGES FOR SERVICE FINES AND FORFEITS MISC. REVENUE TRANSFERS IN FROM FUND BALANCES GENERAL FUND REVENUE CITY COUNCIL CITY MANAGER CITY CLERK LEGAL ADMINISTRATIVE SERVICES M.I.S. DIVISION HUMAN RESOURCES POLICE ADMINISTRATION POLICE PATROL CODE ENFORCEMENT DIVISION POLICE INVESTIGATIONS POLICE COMMUNICATIONS ROADS AND DRAINAGE CENTRALGARAGE FACILITIES MAINTENANCE PARKS/RECREATION CEMETERY COMMUNITY DEVELOPMENT NON -DEPARTMENTAL GENERAL FUND EXPENDITURES CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 09/30/23 2019/2020 2020/2021 2021/2022 4th QTR 4th QTR 4th QTR ACTUALS ACTUALS ACTUALS -8,124,514 -8,948,425 -9,414,216 -150,240 -195,919 -189,643 -3,013,721 -3,523,087 -4,373,792 -663,702 -763,143 -778,572 -53,164 -38,277 -82,430 -386,061 -241,170 -459,589 0 0 -48,094 0 0 0 -12,391,402 -13,710,021 -15,346,336 46,702 55,883 57,224 269,335 285,943 339,347 264,887 205,204 261,773 167,044 195,696 205,481 674,673 656,306 747,045 511,750 513,329 549,680 0 0 0 1,263,875 1,020,630 1,087,665 3,308,391 3,461,189 3,687,563 184,219 187,626 180,269 1,076,622 1,107,742 1,174,005 582,845 577,505 605,842 963,173 927,720 969,560 202,251 211,926 229,392 568,181 598,970 566,354 1,110,021 1,035,794 1,106,152 177,736 179,000 143,561 539,290 477,728 480,818 976,464 1,025,035 1,341,840 12,897,460 12,723,227 13,733,572 2022/2023 4th QTR ACTUALS -10,401,284 -163,719 -4,235,991 -763,311 -170,718 -554,828 0 0 -16,289,850 55,940 337,591 226,019 373,973 594,889 635,465 224,878 1,112,264 4,037,999 144,720 1,203,089 681,157 1,052,165 261,653 790,792 1,217,694 161,719 504,123 1,353,201 14,969,331 2022/2023 Annual BUDGET -9,924,615 -163,700 -4,084,464 -745,870 -50,500 -253,000 -35,000 -970,933 -16,228,082 62,725 342,355 226,599 379,606 623,711 728,199 231,971 1,164,215 4,124,025 202,679 1,342,736 751,150 1,157,837 283,453 863,688 1,386,316 164,404 701,873 1,490,540 16,228,082 2022/2023 Percent of Budget 104.80% 100.01% 103.71% 102.34% 338.05% 219.30% 0.00% 0.00% 100.38% 89.18% 98.61% 99.74% 98.52% 95.38% 87.27% 96.94% 95.54% 97.91% 71.40% 89.60% 90.68% 90.87% 92.31% 91.56% 87.84% 98.37% 71.83% 90.79% 92.24% AMERICAN RESCUE PLAN ACT INTERGVT'L REVENUE MISC. REVENUE FROM FUND BALANCE ARPA FUND REVENUE OPERATING EXPENSES TRANSFERS OUT TO FUND BALANCE ARPA FUND EXPENDITURES LOCAL OPTION GAS TAX TAXES INTERGVT'L REVENUE MISC. REVENUE FROM FUND BALANCES LOGT FUND REVENUE OPERATING EXPENSES CAPITAL OUTLAY DEBT SERVICE TRANSFERS OUT TO FUND BALANCES LOGT EXPENDITURES DISCRETIONARY SALES TAX TAXES MISC. REVENUE FROM FUND BALANCES DST FUND REVENUE OPERATING EXPENSES CAPITAL OUTLAY TRANSFERS OUT TO FUND BALANCES DST FUND EXPENDITURES RIVERFRONT REDEVELOPMENT FUND MISC. REVENUE TRANSFERS IN FROM FUND BALANCES RRD REVENUE OPERATING EXPENSES GRANTS AND AIDS TRANSFERS OUT TO FUND BALANCES RRD EXPENDITURES PARKING IN LIEU OF FUND MISC. REVENUE PARKING IN LIEU OF REVENUE TO FUND BALANCES PARKING IN LIEU OF EXPENDITURES 2019/2020 4th QTR ACTUALS CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 09/30/23 2020/2021 2021/2022 2022/2023 4th QTR ACTUALS 2022/2023 Annual BUDGET -686,491-741,313-801,509-751,077-777,637 -13,694-14,105-14,528-14,963-14,964 -1,991 -503 -5,106-20,309 -2,479 0 0 0 0-284,352 -702,175-755,920-821,142-786,349-1,079,432 5,400 101,964 33,900 11,301 10,800 105,554 34,372 4,870 0 0 243,886 243,398 242,801 122,174 122,174 498,043 525,946 19,124 4,658 946,458 0 0 0 0 0 852,884 905,680 300,694 139,132 1,079,432 -3,469,568-4,037,460-5,001,740-4,791,513-5,160,637 -68,126-35,198-39,348-93,413-98,209 0 0 0 0-3,029,592 -3,537,694-4,072,658-5,041,088-4,884,926-8,288,438 15,487 0 0 0 0 0 17,849 7,151 0 0 2,321,748 4,735,153 7,973,347 2,668,317 7,425,064 0 0 0 0 863,374 2,337,235 4,753,002 7,980,498 2,668,317 8,288,438 -41,082-37,467-42,517-54,691-43,719 -403,240-457,672-385,665-469,960-380,580 0 0 0 0-86,952 -444,322-495,139-428,182-524,651-511,251 286,894 252,927 283,921 249,701 260,918 15,000 5,323 8,049 0 31,951 37,872 174,305 49,572 13,550 70,001 0 0 0 0 148,381 339,766 432,555 341,542 263,251 511,251 -3,687-11,899-17,570 -8,633 -539 -3,697-11,899-17,570 -8,633 -539 0 0 0 0 539 0 0 0 0 539 2022/2023 Percent of Budget 0.00% 528.32% 0.00% 2.34% 100.00% 0.51 % 0.00% 0.95% 96.58% 100.00% 819.23% 0.00% 72.85% 104.64% 0.00% 100.00% 0.49% 0.00% 12.80% 92.85% 95.12% 0.00% 58.94% 0.00% 0.00% 35.94% 0.00% 32.19% 125.10% 123.49% 0.00% 102.62% 95.70% 0.00% 19.36% 0.00% 51.49% 1601.58% 1601.58% 0.00% 0.00% 2022/2023 Percent of Budget 0.00% 528.32% 0.00% 2.34% 100.00% 0.51 % 0.00% 0.95% 96.58% 100.00% 819.23% 0.00% 72.85% 104.64% 0.00% 100.00% 0.49% 0.00% 12.80% 92.85% 95.12% 0.00% 58.94% 0.00% 0.00% 35.94% 0.00% 32.19% 125.10% 123.49% 0.00% 102.62% 95.70% 0.00% 19.36% 0.00% 51.49% 1601.58% 1601.58% 0.00% 0.00% CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 09/30/23 2019/2020 2020/2021 2021/2022 2022/2023 2022/2023 2022/2023 4th QTR 4th QTR 4th QTR 4th QTR Annual Percent ACTUALS ACTUALS ACTUALS ACTUALS BUDGET of Budget RECREATION IMPACT FEE FUND MISC. REVENUE -147,023 -214,779 -182,042 -107,651 -163,389 65.89% FROM FUND BALANCES 0 0 0 0 -173,474 0.00% REC. IMPACT FEE REVENUE -147,023 -214,779 -182,042 -107,651 -336,863 31.96% . TRANSFERS OUT 480,160 121,037 121,276 36,839 228,474 16.12% TO FUND BALANCE 0 0 0 0 108,389 0.00% REC. IMPACT FEE EXPENDITURES 480,160 121,037 121,276 36,839 336,863 10.94% STORMWATER UTILITY FUND MISC. REVENUE -1,969,428 -1,958,662 -1,973,693 -2,004,107 -1,959,621 102.27% TRANSFERS IN 0 0 -200,000 0 0 0.00% FROM FUND BALANCES 0 0 0 0 -669,881 0.00% STORMWATER REVENUE -1,969,428 -1,958,662 -2,173,693 -2,004,107 -2,629,502 76.22% PERSONAL SERVICES 654,105 685,797 679,375 770,017 916,628 84.01% OPERATING EXPENSES 613,330 790,024 817,843 1,061,812 1,295,289 81.97% CAPITAL OUTLAY 186,937 123,824 139,071 43,836 56,393 77.73% TRANSFERS OUT 29,019 16,503 311,661 185,198 361,192 51.27% STORMWATER EXPENDITURES 2,483,392 1,616,148 1,947,951 2,060,864 2,629,502 78.37% LAW ENFORCE FORFEITURE FUND INTERGOVERNMENTAL REVENUE 0 0 0 0 0 0,00% FINES AND FORFEITS -133 -15,050 -21,315 -50 -1,000 5.00% MISC. REVENUE -1,665 -11550 -11914 -1,157 -160 722.99% FORFEITURES FUND REVENUES -1,798 -16,600 -23,229 -1,207 -1,160 104.03% OPERATING EXPENSES 5,072 1,500 3,061 0 0 0.00% CAPITAL OUTLAY 0 15,000 0 0 0 0.00% GRANTS AND AIDS 1,000 0 0 1,500 0 0.00% TO FUND BALANCES 0 0 0 0 1,160 0.00% FORFEITURE FUND EXPENDITURES 6,072 16,500 31061 1,500 1,160 129.31% STORMWATER DEBT SERVICE FUND MISC. REVENUE -2,165 -454 -397 0 0 0.00% TRANSFERS IN -401,355 -400,961 -220,605 0 0 0.00% FROM FUND BALANCES 0 0 0 0 0 0.00% STORMWATER DEBT REVENUE -403,520 -401,415 -221,002 0 0 0.00% DEBT SERVICE 402,137 400,529 401,834 0 0 0.00% STORMWATER DEBT EXPENDITURES 402,137 400,529 401,834 0 0 0.00% GOLF COURSE FUND INTERGOVERNMENTAL REVENUE CHARGES FOR SERVICE MISC. REVENUE FROM FUND BALANCES GOLF COURSE FUND REVENUE PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TRANSFERS OUT TO FUND BALANCES ADMINISTRATION OPERATING EXPENSES CAPITAL OUTLAY MAINTENANCE PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY DEBT SERVICE GOLF COURSE CARTS GOLF COURSE FUND EXPENSE AIRPORT INTERGOVERNMENTAL REVENUE CHARGES FOR SERVICE MISC. REVENUE TRANSFERS IN FROM FUND BALANCE AIRPORT REVENUE PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY DEBT SERVICE TRANSFERS OUT TO FUND BALANCES AIRPORT EXPENSE BUILDING FUND LICENSES & PERMITS CHARGES FOR SERVICE FINES AND FORFEITS MISC. REVENUE TRANSFERSIN FROM FUND BALANCE BUILDING REVENUES PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TO FUND BALANCES BUILDING EXPENSE CITY OF SEBASTIAN FUND SUMMARIES QUARTER ENDING 09/30/23 2019/2020 2020/2021 2021/2022 2022/2023 4th QTR 4th QTR 4th QTR 4th QTR ACTUALS ACTUALS ACTUALS ACTUALS 0 -1,485,563 -41,768 0 -2,527,331 280,310 372,536 0 38,367 0 691,213 579,658 0 579,658 99,041 1,108 3,716 56,390 160,255 1,431,126 -30,000 0 -558,675 -4,691 0 -593,366 70,760 256,032 50,070 21,477 0 0 399,338 0 -1,456,436 -42,596 0 -1,499,032 297,091 379,894 0 38,366 0 715,351 582,490 0 582,490 107,828 2,587 0 56,390 166,805 1,464,646 0 0 -579,785 0 0 -579,785 62,692 277,935 9,205 21116 150:000 0 520,947 0 -1,765,135 -50,838 0 -1,815,973 263,952 377,915 0 36,085 0 677,952 596,146 8,505 604,651 145,790 12,542 0 51,691 210,023 1,492,627 0 0 -615,918 -3,643 0 -619,561 133,225 295,521 29,043 20,740 4,800 0 483,330 0 -1,868,168 -270,906 0 -2,139,075 271,843 401,651 28,986 36,209 0 738,689 678,613 0 678,613 160,421 54,778 528,640 0 743,839 2,161,141 0 0 -779,410 0 0 -779,420 195,250 313,166 78,276 20,110 72,524 0 679,327 2022/2023 Annual BUDGET -77,472 -1,741,611 -64,102 -599,201 -2,482,386 287,750 408,805 28,986 71,209 90,000 886,750 688,569 154,472 843,041 162,550 61,405 528,640 0 752,595 2,482,386 -32,230 0 -683,208 0 -76,493 -791,931 193,036 314,827 78,449 36,500 75,889 93,230 791,931 -911,334 -1,328,862 -1,217,579 -876,023 -1,229,500 -18,094 -33,415 -30,273 -16,376 -33,500 -6,298 -51200 -6,836 -4,325 -5,500 -9,553 -13,210 -19,060 -44,172 -7,289 -38,367 -38,366 -36,085 -36,209 -36,209 0 0 0 0 -195,324 -983,646 -1,419,053 -1,309,834 -977,106 -1,507,322 607,069 631,113 715,665 813,071 942,425 135,889 160,093 238,328 175,395 330,757 3,952 22,957 0 194,262 194,263 0 0 200 0 39,877 746,911 814,164 954,193 1,182,728 1,507,322 2022/2023 Percent of Budget 0.00% 107.27% 422.62% 0.00% 86.17% 94.47% 98.25% 100.00% 50.85% 0.00% 83.30% 98.55% 0.00% 80.50% 98.69% 89.21% 100.00% 0.00% 98.84% 87.06% 0.00% 0.00% 114.08% 0.00% 0.00% 98.42% 101.15% 99.47% 99.78% 55.10% 95.57% 0.00% 85.78% 71.25% 48.88% 78.64% 606.01% 100.00% 0.00% 64.82% 86.27% 53.03% 100.00% 0.00% 78.47% CITY OF SEBASTIAN GENERAL FUND DEPARTMENTS QUARTER ENDING 09/30/23 2019/2020 2020/2021 2021/2022 2022/2023 2022/2023 2022/2023 4th Qtr 4th Qtr 4th Qtr 4th Qtr Annual Percent ACTUALS ACTUALS ACTUALS ACTUALS BUDGET of Budget CITY COUNCIL PERSONAL SERVICES 22,728 22,732 22,726 22,725 22,725 100.00% OPERATING EXPENSES 23,973 33,151 34,498 33,216 40,000 83.04% TOTALS 46,702 55,883 57,224 55,940 62,725 89.28% CITY MANAGER PERSONAL SERVICES 258,605 273,298 290,514 325,138 324,894 100.08% OPERATING EXPENSES 10,730 12,645 13,696 12,452 17,461 71.32% CAPITAL OUTLAY 0 0 35,137 0 0 0.00% TOTALS 269,335 285,943 339,347 337,591 342,355 98.61% CITY CLERK PERSONAL SERVICES 171,932 180,890 186,822 187,035 186,809 100.12% OPERATING EXPENSES 92,955 24,314 74,951 38,984 39,790 97.97% CAPITAL OUTLAY 0 0 0 0 0 0.00% TOTALS 264,887 205,204 262,773 226,019 226,599 99.74% LEGAL PERSONAL SERVICES 92,686 162,196 179,916 150,339 150,606 99.82% OPERATING EXPENSES 74,359 33,499 25,565 223,635 229,000 97.66% TOTALS 167,044 195,696 205,481 373,973 379,606 98.52% ADMINISTRATIVE SERVICES PERSONAL SERVICES 539,816 514,984 590,894 479,222 504,849 94.92% OPERATING EXPENSES 134,857 141,322 156,151 115,667 118,862 97.31% TOTALS 674,673 656,306 747,045 594,889 623,711 119.77% M.I.S. DIVISION PERSONAL SERVICES 345,874 347,018 377,886 408,928 447,909 91.30% OPERATING EXPENSES 163,865 166,312 171,793 226,537 280,290 80.82% CAPITAL OUTLAY 2,011 0 0 0 0 0.00% TOTALS 511,750 513,329 549,680 635,465 728,199 87.27% HUMAN RESOURCES PERSONAL SERVICES 0 0 0 177,752 174,428 101.91% OPERATING EXPENSES 0 0 0 47,126 57,543 81.90% CAPITAL OUTLAY 0 0 0 0 0 0.00% TOTALS 0 0 0 224,878 231,971 96.94% POLICE ADMINISTRATION PERSONAL SERVICES 1,064,435 895,521 977,461 993,831 1,034,347 96.08% OPERATING EXPENSES 160,747 125,109 101,079 118,433 129,868 91.19% CAPITAL OUTLAY 38,694 0 9,125 0 0 0.00% TOTALS 1,263,875 1,020,630 1,087,665 1,112,264 1,164,215 95.54% POLICE PATROL PERSONAL SERVICES 3,029,232 3,153,248 3,335,083 3,585,495 3,645,924 98.34% OPERATING EXPENSES 245,672 275,264 319,925 403,572 407,007 99.16% CAPITAL OUTLAY 33,487 32,677 32,555 48,932 71,094 68.83% TOTALS 3,308,391 3,461,189 3,687,563 4,037,999 4,124,025 97.91% CODE ENFORCEMENT DIVISION PERSONAL SERVICES 169,750 170,981 162,658 130,035 181,889 71.49% OPERATING EXPENSES 14,469 16,645 17,611 14,685 20,790 70.63% TOTALS 184,219 187,626 180,269 144,720 202,679 71.40% POLICE INVESTIGATIONS PERSONAL SERVICES 878,785 954,685 1,030,390 1,051,290 1,171,296 89.75% OPERATING EXPENSES 123,458 143,558 140,023 142,899 159,758 89.45% CAPITAL OUTLAY 74,379 9,500 3,593 8,900 11,682 76.19% TOTALS 1,076,622 1,107,742 1,174,005 1,203,089 1,342,736 89.60% POLICE COMMUNICATIONS PERSONAL SERVICES 573,959 566,550 596,697 672,750 734,155 91.64% OPERATING EXPENSES 8,886 10,955 9,145 8,407 16,995 49.47% TOTALS 582,845 577,505 605,842 681,157 751,150 80.66% ROADS AND DRAINAGE PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTALS CENTRAL GARAGE PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTALS FACILITIES MAINTENANCE PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTALS PARKS/RECREATION PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTALS CEMETERY PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTALS COMMUNITY DEVELOPMENT PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTALS NON -DEPARTMENTAL PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TRANSFERS OUT TO FUND BALANCE TOTALS CITY OF SEBASTIAN GENERAL FUND DEPARTMENTS QUARTER ENDING 09/30/23 2019/2020 2020/2021 2021/2022 2022/2023 2022/2023 2022/2023 4th Qtr 4th Qtr 4th Qtr 4th Qtr Annual Percent ACTUALS ACTUALS ACTUALS ACTUALS BUDGET of Budget 588,186 555,076 562,998 631,473 689,958 91.52% 335,797 328,867 346,064 398,078 445,046 89.45% 39,190 43,777 60,498 22,615 22,833 99.04% 963,173 927,720 969,560 1,052,165 1,157,837 90.87% 180,924 189,783 203,840 213,524 232,918 91.67% 18,950 22,143 25,553 40,530 41,894 96.75% 2,376 0 0 7,598 8,641 87.93% 202,251 211,926 229,392 261,653 283,453 92.31% 279,726 290,017 271,376 256,702 262,826 97.67% 234,361 234,368 286,640 472,190 538,688 87.66% 54,094 74,585 8,338 61,901 62,174 99.56% 568,181 598,970 566,354 790,792 863,688 91.56% 736,297 732,945 782,422 811,579 959,751 84.56% 218,871 253,790 287,401 285,631 304,913 93.68% 154,854 49,059 36,329 120,484 121,652 99.04% 1,110,021 2,035,794 1,106,152 1,217,694 1,386,316 87.84% 151,633 149,171 113,984 128,280 128,128 100.12% 26,103 29,829 28,771 31,166 33,976 91.73% 0 0 806 2,273 2,300 98.83% 177,736 179,000 143,561 161,719 164,404 98.37% 392,517 416,308 409,741 472,682 581,583 81.28% 132,124 61,420 71,077 31,441 120,290 26.14% 14,650 0 0 0 0 0.00% 539,290 477,728 480,818 504,223 701,873 71.83% 264,098 275,349 707,675 703,732 0 0 4,691 45,954 0 0 976,464 1,025,035 312,815 326,833 714,666 745,558 0 0 314,359 280,811 0 0 1,341,840 1,353,201 TOTAL GENERAL FUND 12,887,460 12,723,227 13,733,572 14,969,331 326,832 100.00% 745,678 99.98% 0 0.00% 418,030 67.17% 0 0.00% 1,490,540 90.79% 16,228,082 92.24% CITY OF SEBASTIAN CAPITAL PROJECT STATUS REPORT AS OF SEPT 30, 2023 Current Prior Project Budget Shure Project Year Year Expenditures Percent Funds Amber Descrgltion Bud¢et Sources (in Thous ands of 51 Bud>;et ExpentGhlres Expenditures To Date Expended Eocttmbrances Rem�amm FY2019 A1925 :Park Signage(Complete) DSTUF 72/169.7 24758 4,400 237,358= 241,758 100.00% A1952 Construct Hangar D FDOT/DST/AP 1,8001450167.2 2,317,253 170,490 2,173,212 2,343,702 101,14% 42,139 (68,588)' TOTAL S 2,559,011 $ 174,990 $ 2,41M70 $ 2,585,460 101,03% $ 42,139 (4588) FV2020 A2007 CDBG Grant Program CDBG 515 515,175; 107,632 261,566' 369,198 71.66% 12,000 133,977 A2029 'CRA Siphage&Landscape(Comlhlde) CRA 90 90,322 90,322 90,322 100.00% A2030 'Relocate Public Facilities Compound (Complete) S3RWMDIDST 11.0,632 9,643,463 141,912 . 9,501,530 9,643,462 100.00% 1 A2050 Construct TauLane(Complete) FAA 663 663,062 3200 659,861': 663,061 100.00% I A2063 Septic to Sewer Grant Program(Complete) IRLGCRA . 42.8147.8 90,606' 5,000 85,605 90,605 100,00% I _... TOTAL . ........... ......... $ 11,002,629 S 257,764 $ 10998,886 $ 10,856,649. 98.67% S 12,000: 133,979 FY2021 -. A2104 Phone System(Complete) ._ D ST 83.1 _ 83,807. 1,080. 82,721. 83,807 100.00% - A2123 'Tree Protection Plan (Complete) DST 61 61,409 - 61,409 61,409 100.00% A2126 Yacht Club Seawall (Complete) GF 352 351,752 1,415 350,337 351,752 100.00% A2150 Fstablish Sewer Service (Complete) FDOTISIRWMDIDST 1,327/149/280 1,756,692 128,648 1,628,044; 1,756,692 100.00% A2161 Stormwate•MasterPlan DST/SW 350I350 M0,000I 87,650 560,750 648,400 92.63% 51,600 TOTAL S 2,953,660', $ 218,793 $ 2,683,266 S 2,902,059 . 9815% S 51,600 M022 A2201 Citywide Computers (Complete) DST 24 24,038 24,038 24,038 100.00% A2204 Networklnrastructurc(Complete) .... DST 10 9,923 9,923 9,923 100.00% A2206 CAD/RMS System Update (Complete) DST 126 126,069 14,000 112,069' 126,069 100.00% A2207 PoliceVehicles&Equipment(Complete) DST 293 293,268 278,585 14,683 293,268 100.00% A2209 PD COPE Trailer (Complete) DST 33 32,786 i 32,695 91' 32,786 100.00% A2212 :PDVehules(Complde) OF 99. 98,744 99,744- 98,744 100.00% A2214 'PDFloaong(Complue) GF 23 22,902 22,799 103 22,902 100.00w A2215 Leisure Services Vehicle&Mowcr(Complete) GF 34 33,6521 33,651 33,651 100.00%° 1 A2216 Community Development SUV(Complete) GF 25 25,027 25,027 25,027 100.001/o A2217 'Wheeled End Loader (Complete) DST 203 203,306 203,306 203,306 . 100.00% A2220 !WorkingWaterfiont CRA 50 50,000 .... 8,550 8,550 17.10% 41,450 A2221 BSSC Baseball Backstops R1F 75 75,000 0.00% 75,000 A2222 ;Pla uodl p rovements Ygm mP RIF 104 104,026 34,715 1,526 3 24l 6 34.84% 67,759 26 A2223 Park Improvernasts (Complete) RIF 9 8,959 8,959 ' 8,959 100.D0% A2224 'Riverview Park Enhancements DON 4 4,350 Q00% 4,350 A2230 'Railroad Crossing Sidewalks LOGT/DST _. 1000 190,000 1,800 6,400 8,200 4.32% 14,920, 166,880 A2231 Raadlhrhprovenhehts ARPA 1,206 1,205,880 0.00% 1,205,880 A2250 Construct (4) Square Hangars FDOT/DST 1,256/314 1,570,000 0.00% I,570,000 A2252 - HangarCOflicelaprovements(CanceOed) FDOT/DON 0 0.00%° _. A2253 _Airport Rescue Grant (Completel FAA 32 32,000 t 4,244 27,756 32,000 100.00% A2254 'Rehab Runway 05-23(Complete) FAAIFDOTIDST 193.4/10.7/13.2 217,394 213,199 4,194 217,393 100.00% 1 A2260 ...... ._.. _...... SwaleslDrivewayslCulverts _ ___ SW 245 244,6951 70,494 _....,.-..,. 36,039 ........ 106,533 43.54% 13,855 _.._, ....... 124,307 A2261 Concha Dam Replacement ep ARPA 700 700,000 0.00% 700,000 A2%2 Sliplmiog(Complete) DST 70 70,214' 70,214 70,214' 100.00% I A2263 . ,]Tulip Habitat Restoration IRLCISW 4,81185 .. 23,291 .,.....,.. 4,688 4,431 9,119. 39.15%p 2,842. 11,330 A2264 'Gardenia Ditch ARPA 750 750,000', 6,043 3,844' 9,887 1.32% 3,756 736,357 A2265 Schumann Drive BoxCulvat ARPA 44 44,120' 7,596 7,596 17.22°(° 36,524 A2267 'MmiEuavator(Complete) SW 67 66,837 66,837 66,937 100.00% TOTAL S 6,226,481 S 1,197,186 $ 254,055 S 1,451,240 2331% $ 139,656 4,635,585 Page 1 of 2 CITY OF SEBASTIAN CAPITAL PROJECT STATUS REPORT AS OF SEPT 30,2023 I ....... .... ........... . I...".. 1 -1 . ....... Current Prior Project Budget Share Project Year Year Expenditures Percent Funds Number Descri 'on Budget Sources 'Jkt Thousands of $1 Bridget Expenditures: Expenditures To Date Encumbrances Remaining A2300 Saver/Host Update (Complete) DST 0 0,00% A2301 CitywideComputers DST 76.1 76,108 39,161 39,161 51.45%. 36,947 A2302 COStv Eq� pmcnt (Complete) DST 14.6 14,626 14,625 14,625 160.00% I A2303 Network Infrastructure . ....... .......... DST . . .. ..... . - 50 . ........... 50,077 21,293 21,293 42.52% A,784 A2304 Backup System Update DST 40 . .... .. 40,000i 31,121 31,121 77.09 . .... . 8,879 A2305 ;Parks Security Cameras (Complete) DST 26 26,037 26,036 26,036 100.00% A2306 'PD Vehicles & Equip DST 5121 512,200 0.00%I 428,958 83,242 A*7 PD Body Wom & Vehicle Cameras (Complete) DST 78.6 78,583 78,SS3 78,583 100.00% A2308 CADIRMSSystcm DST 60.8 60,775 14,000 14,000 23.04%: 46,775 A2309 PD Armored Vehicle (Complete) DST 310 310,000 309,619 309,619 99.89%, 381 A2310 PD Generator Transfer Switch DST 200 200,000 296 2% 0.15%: 164,250 35,454 A2311 Air Conditioner Replacements (Complete) DST 27.9 27,940 27,940 27,940 100.00% A2312 Hurricane Ian FEMA 0 56,386 56,386: 0.00%, (56,386) A2313 Hurricane Nicole FEMA 0 24,086 24,086 0.00% (24,66) A2315 INhAmiyersary Celebration DON)GP 13.1150 66,M 12,945 12,945 19.58% 31,950 2 Q05 A23 16 JAG Grant (Complete) IAGIGF 1211 13,150 13,150 13,150 100.00% A2317 PW Shade Structure DST 2.5 2,493 2,493 2,4931 100.00% A2318 Senior Center Roof GF 56.8 56,781 .. ..... ....... . 99 99 0.17%. 56,781 (99); A2319 'Yacht Club Improvements GF 20 20,000 13,553 13,553 67.77%: 6,447 A2320 SwingBench Park RIF 35 35,000 0.00%. 35,W6 A2321 :Park Improvements RIF 16 15,974 2,123 2,123 13.29% 13,851 A2322 Kiosk Signs CRA 15 15,000 0.00%: 15,000 A2323 CRA Sustainable Economic Redevelopment (Complete) DEO 70 70,000 70,000 70,000, 100.00% A2324 Riverview Area Improvements DST 74 73,591 15,595 15,595 21.19% 54,005 3,991 A2325 Coastal Resilience Plan Update DEP 120 120,000 16,283 16,283 13.57% 103,718 - A2327 Natural lmdscapingLID DUMD GF 15 15,000 0.00%: 15,000 A2328'Strategic Plan GF 75 75,00 0.001/0 75,000 A2329 Senior Center Flooring GF 11.5 11,560 0.9/0 - 11,560 A2331 Bucket Truck ....... .. .... ... - . ............ --- ----- ----- DST . ........... ............. . ... . . .. 159 ... 159,000 1 0.00% 158,219 781 A2332 I :Brush Track . DST ......... . .. - ... . .... .... ................... 122 122,000 0.00% 121,543 457 A2333 ..... ... . ......... Dump Truck ...... .... . ....... DST 185 185,000 . . 0.00'/o: . . .. ....... . . ... 184,500 5W A2334 Sidewalk (Davita Dialysis) DST 200 200,OW 0.001/0 200,000 A2335 Stred Rep aving WGT 600 6W,000 0.00%. 600,000 A2336 Street Reconstruction LOGT 250 M,000 0.00% 250,000 A2337 :Sidewalk Replacement (Complete) LOCT 2,9 2,858 2,858 2,858 99.W A2338 USI Patterned Paveway (Complete) DST 480.1 480,105 480,105 480,105 100.00% A23.39 :PW Tochnolog DST 7.7 7,667 0.00%, 7,667 A2350 'Runway Wffaxiway Bravo Markings (Complete) FDOTAP 34.518,6 43,179 43,179 43,179 100.0M 0 A2351 Runway 05-23 Rehab FAA/FDOTA)ST 3,067/170.4/170.4 3,407,645 31,122 31,122 0.91%, 3,376,484 39 A2352 Coronavirus Response Grant FAA 13 13,000 5,430 5,430 41.77W 7,570 A2353 Hang D OfficeImprovements FDOT/DON 320/90 400,000 0.00%: 400,000 A2360 ........ ... . . Swalcs/Drivcways� verts . ..... . ......... . DST 150 150,000 ......... . 0.00%: 150,OM A2361 ....... . . .. ...... ... ...... ..... SW Bulldozer (Complete) DST 137 136,976 136,976 136,976. 1002% A2362 Sliplining DST 329,8 329,786 49,061 49,061 14.88% 280,725 A2363 Canal Restoration FEMA/DST 11,000500 11,500,000 - - O.W/0 11,500,000 A2364 Slonocrop Drainage Improvements FEMAIDST 1,11811,824 2,941,591 160,894 160,894 5.47'/D:: 2,780,698 TOTAL 22y14,802 S 1,699,011 S S 1,699,011 7.41% S 7,461,105 13,754,686 GRAND TOTAL S 45,65602 S 3,547,645 S 15,94b,775 S 19,494,420 42.70%, $ 7,706,499 18,455,60 Page 2 of 2 QUARTERLY INVESTMENT REPORT FOR THE QUARTER ENDED SEPTEMBER 30, 2023 At September 30, 2023, the total of the City's cash and investments were $23,479,782.13. Of this, $18,832,313.28 was held in an interest bearing checking account at Seacoast National Bank, $4,101,628.52 was invested with the State Board of Administration and $545,840.33 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.92% for the Bank and 5.57% 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,906.69 or about 4.35%. 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 CURRENT CASH BALANCE ALLOCATION BALANCE General Fund $ 6,446,991.35 American Rescue Plan Act 2,464,920.93 Local Option Gas Tax Fund 1,079,255.29 Discretionary Sales Tax Fund 3,593,799.03 Riverfront Redevelopment Fund 756,211.17 Parking In -Lieu -Of Fund Recreation Impact Fee Fund Stormwater Utility Fund Law Enforcement Forfeiture Fund Stormwater Series 2003 Debt Service Fund Capital Projects Fund Capital Improvements Fund Transportation Fund Stormwater Projects Fund Golf Course Fund Airport Fund Airport Projects Fund Building Department Fund Cemetery Trust Fund Performance Deposits Fund Total Bank Balance Fund Making Loans GENERAL FUND: Due from Golf Course DISCRETIONARY SALES TAX: Due from Airport Fund Due from Airport Fund BUILDING FUND: Due from Golf Course Due from Golf Course 330,356.13 1,613,111.92 44,742.26 (147,336.23) 54,255.35 (0.10) (155,529.68) 37,002.06 474,512.08 89,192.30 1,483,208.19 576,871.24 90,750.00 18,832,313.28 STATE BOARD OF ADMINISTRATION (SBA) CURRENT PERCENT INVESTMENT ALLOCATION BALANCE 3423% General Fund $ 1,223,218.77 13.09% American Rescue Plan Act 436,616.88 5.73% Local Option Gas Tax Fund 190,781.28 19.08% Discretionary Sales Tax Fund 633,952.88 4.02% Riverfront Redevelopment Fund 133,544.22 0.00% Parking In -Lieu -Of Fund 97,432.74 1.75% Recreation Impact Fee Fund 59,165.13 8.57% Stormwater Utility Fund 283,575.77 0.24% Law Enforcement Forfeiture Fund 7,910.90 0.00% Stormwater Series 2003 Debt Service Fund -0.78% Capital Projects Fund 0.29% Capital Improvements Fund 0,00% Transportation Fund -0.83% Stormwater Projects Fund 0.20% Golf Course Fund 111,134.75 2.52% Airport Fund 83,632.76 0.47% Airport Projects Fund 7.88% Building Department Fund 261,602.66 3.06% Cemetery Trust Fund 577M 9.78 0.48% Performance Deposits Fund 2,340.00 100.00% Total SBA Balance $ 4,101,628.52 PERCENT 29.82% 10.64% 4.65 % 15.46% 126% 2.38% 1.42% 6.91 % 0.19% 0.00% 0.00% 0.00% 0.00% 0.00% 2.71 % 2.04% 0.00% 6.38% 14.09% 0.06% 100.00% INTERFUND LOANS REPORT 10/01/22 Scheduled i 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 $245,298 5 Years @ 3%, Then 4% for 25 Years. Final in 2038 $267,511 Hangar B $249,575 $8,517 $241,058 5 Years @ 3%, Then 4% for 25 Years. Final in 2041. $700,000 Irrigation $553,159 $31,352 $522,611 Each 5 Years to T-Bond Minus 1%. Final in 2038. $559,684 Other Repairs $559,684 None $559,684 pay When Possible, Maybe After $700,000 is paid. anoF SEMS.T1AN HOME OF PELICAN ISLAND To: Mayor and City Council Thru: Paul Carlisle, City Manager From: Kenneth W. Killgore, Finance Director Date: February 29, 2024 Re: Fiscal Year 2023 4`h Quarter Accomplishments The following are the 4`s Quarter Accomplishments for City Departments as assembled and edited by the Finance Department for the three months ended September 30, 2023. CITY CLERK Legislative Sunaort Matters • City Clerk prepared agenda, attended/recorded six Regular City Council meetings, one special meeting • Completed follow up of approved Council matters — contracts, letters, e-mails, scanned to LF and indexed • Nine resolutions adopted by Council • Three ordinances adopted by Council • Five proclamations prepared for presentation by Mayor • Provided monthly City calendars and revisions to Council, City staff and press • Prepared travel arrangements and reimbursement for five FLC Annual conference attendees Records Management Program • Responded to 67 public records requests • 144 cubic feet of paper records met retention, along with duplicate and OSA records destroyed by shredding vendor • Continued scanning and organizing records into Laserfiche for permanent or long term record storage • Purchased plastic storage bins to store information in the vault for permanent storage • Continued to re -organize permanent file boxes and update the list of location in Laserfiche and vault Election Matters • Qualified six candidates for 2023 Election • Prepared 2023 election ballot • Processed relevant campaign treasurer's reports • Notified candidates of logic & accuracy testing of the voting equipment Cite Board Matters • City Clerk attended four Centennial Celebration Task Force meetings • Records Specialist prepared agenda, attended and recorded three Centennial Celebration Task Force meetings • Noticed vacancies, prepared one board appointment, updated board handbook and distributed pages • Records Specialist published all scanned City board agenda packets to City website, Facebook, Laserfiche and also provided to press and Council • Published one newspaper notice of FY22/23 CRA meetings • One CRA resolution adopted • Coordinated board/committee meeting minutes between staff and technical writer • City Clerk recorded and transcribed one NRB meeting and one P & Z meeting • Records Specialist recorded and transcribed one magistrate hearing and one budget advisory meeting CemeterN Matters • Certificates of Interment Rights issued for 22 locations for a total of $64,650.00 • Scanned all cemetery records as sold or amended for permanent retention • Records Specialist updated the Rules and Regulations to comply with 0-22-01 regulation changes & adjusted the Rate Sheet to comply with R-22-19 rate increase Personnel/Educational Matters • Records Specialist attended three project management meetings • City Clerk attended one FLC University webinar • City Clerk swore in one police officer • Records Specialist attended two events committee meeting Community Matters 0 Responded to or forwarded CITYSEB emails to appropriate departments. ADMINISTRATIVE SERVICES • Provided administrative support to the Police Pension Board. • Met with Department Heads and worked on drafts of the FY2024 Budget and Capital Program. • Prepared 3`a Quarter Budget Amendment and made presentation to Budget Committee and City Council. • 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. • 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 approved agenda items for contracts and other payments requiring City Council approval. POLICE DEPARTMENT Administration • Continued review of agency policies per accreditation standards. • Conducted interviews for Police Officers and Dispatchers. • Swore in 1 new Officer. • 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 16 public records requests. • Attended Executive Round Table Meetings. • Completed 3 year Re -accreditation assessment. • Attended 2 Treasure Coast Chiefs of Police and Sheriff's Association meeting. • Participated in July 4th parade and celebration at Riverview Park. • Conducted 3 leadership and multiple weekly staff meetings. • Lieutenant Savvidis attended the 2023 FBINAA Conference. • Hired new Crime Scene/Evidence Technician. • Attended the Florida Police Chief s Association Summer Conference. • Retired Sergeant Steve Marcinik. • Attended a ceremony with CFA to accept our 8t' Accreditation Award. • Attended School District Safety and Security Closed Session Meeting. • Attended multiple other civic and agency related meetings including Multi -agency assemblies. • Attended 3 Juvenile Justice 19`h Circuit Advisory Board Meetings. • Attended 9/11 Ceremony. • Recognized our 2022 Officer and Civilian of the year recipients at a Council Meeting. • Attended yearly firearms qualifications. • Submitted a grant request to the State of Florida for JAGC2022. Volunteers • The Community Service Volunteers worked a total of 2,448.95 hours during this quarter. • 74 bank deposit details were completed so City Hall employees do not need to leave their assigned duties. • 70 traffic control details were assigned. These details involve directing traffic at city events, road closures, etc. • 2,165 house watches/close patrols were completed. • 35 vehicle transports were made consisting of taking vehicles to different locations for repairs, etc. • 1,033 business checks were made. These business checks are conducted to help patrol officers keep an eye on the business community which helps reduce crime. • 219 area checks of banks were made. Visual marked units around the banks at various times helps to deter crime. • 70 Airport checks were made. The visibility helps to deter crime. • 43 special details were assigned. • 19 miscellaneous assists for law enforcement personnel. • 91 paperwork runs, i.e.: State Attorney's Office, Sheriff s Office, etc. The Volunteers pick up and deliver packages such as council packages, State Attorney documents and miscellaneous items as needed. • Assisted with traffic control on 8 traffic crash scenes. • 369 citizen contacts. • 507 miscellaneous jobs. • 41 Escorts were completed. School Resource Officers Area/school checks 9 47 I 53 109 Life Skills classes taught 0 0 I 0 0 Reports 4 1 1 6 Crossing Guard contacts 0 I 1 3 4 Mentor lunches 0 I 16 I 13 I 29 Patrol Hours 276 I 157 I 0 I 433 Communty event hours I 0 I 8 I 0 I 8 Communty event hours ■ Road Patrol Coverage Mentors lunches Sept Crossing Guard contacts ■ Aug Reports ■ July Life Skills classes taught Area/school checks ir■ O 50 100 150 200 250 300 Road Patrol and Saecial Oaerations • Officers were dispatched to 5,221 calls for service, and self -initiated 3,143 events. • 103 adult and 7 juvenile arrests were made. • 1 Juvenile Civil Citation was issued. • Officers issued 339 citations, 3 parking citations, and 748 written warnings. • Officers completed 544 offense reports and 70 crash reports. Suecial Ot)erations Citations Warnings Incident Reports Arrests Marine & Natural Resources* 10 0 0 0 *The Marine/Natural Resources unit is not a full-time position. K-9 Unit *3 of 4 positions occupied. • K-9 Training Hours: 360 • Misdemeanor Arrests: 1 • Felony Arrests: 4 • Narcotic Searches: 8 • Activity Reports: 11 • K-9 Demonstrations: 2 • Schools Attended: 0 • Additional Training Hours: 130 • Agency Assisted: Fellsmere PD, Brevard County SO, and Indian River County SO 3 Detectives 4th Quarter Subpoenas Arrests Warrants Training/Meeting Hours Follow -Ups Active Cases Assigned Cases Cleared Cases Inactive Cases Supplements Call Outs Background/CVSA's 3 4 4 11 0 1 1 2 1 0 2 3 22.5 38.5 24.5 85.5 13 15 22 50 13 11 18 42 11 9 6 26 3 6 4 13 2 1 2 5 12 13 9 34 4 4 2 10 3 6 6 15 Call Outs V_ Supplements MjbE Inactive Cases Cleared Cases Assigned Cases 46&6 Active Cases Follow -Ups _"=— gEnSpr— Training/Meeting Hours Warrants Arrests Subpoenas SIU 4th Quarter Court Order Documents Arrests Warrants Training/Meeting Hours Follow -Ups Active Cases Officer Intel Crime Stoppers Intel Other Intel Source Cleared Cases Inactive Cases Supplements Surveillance (hours) Agency Assist ■ Series4 Series3 ■ Series2 n Series 1 50 100 0 0 0 0 0 1 0 1 0 1 0 1 102 84 104 290 1 2 0 3 2 2 2 1 5 5 6 16 4 1 0 5 3 2 4 9 0 1 3 4 0 0 0 0 6 6 2 14 69 86 66 221 2 1 0 3 4 Surveillance (hours) Supplements tm Inactive Cases Cleared Cases Other Intel Source IL Crime Stoppers Intel Sep. Officer Intel M w Aug. Active Cases r Follow -Ups r - Jul. Training/Meeting Hours Warrants Arrests Court Order Documents 0 20 40 60 80 100 120 COPE QUARTERLY REPORT ARRESTS 1 3 2 6 WARRANTS 1 3 2 6 TRAINING/MEETINGS (hours) 6 6 8 20 FOLLOW-UPS 3 5 3 11 ACTIVE CASES 7 5 4 16 ASSISGNED CASES 5 3 5 13 CLEARED CASES 1 3 1 5 INACTIVE CASES 1 0 0 I 1 SUPPLEMENTS 10 5 5 I 20 SURVEILLANCE (HOURS) 18 10 8 I 36 COMMUNITY EVENTS (man-hours) 8 22 32 62 AGENCY OUTREACH EVENTS (man-hours) 0 30 0 30 COMMUNITY MEETINGS (man-hours) 4 2 2 8 SCHOOL RELATED EVENTS (man-hours) 0 0 2 2 PUBLIC TRAINING CLASSES (man-hours) 0 0 0 0 REGIONAL OUTREACH (man-hours) 0 0 0 0 PROBLEM ORIENTED POLICING (man-hours) 0 0 6 6 PUBLIC SAFETY CADET ACTIVITIES (man-hours) 8 8 8 24 TRAINING SCHOOLS (man-hours) 0 I 0 4 I 4 IN-SERVICE TRAINING (man-hours) 0 I 0 42 I 42 SOCIAL MEDIA MANAGEMENT (man-hours) 4 I 3 4 11 ADMINISTRATION & RESEARCH (man-hours) I 29 I 20 19 68 ROAD PATROL COVERAGE (man-hours) I 0 jl 0 I 0 I 0 MARINE PATROL & NATURAL RESOURCES (man-hours) 24 I 0 I 0 I 24 MARINE PATROL & NATURAL RESOURCES (arrests) 0 I 0 0 I 0 MARINE PATROL & NATURAL RESOURCES 0 I 0 0 0 (citations/criminal & non) MARINE PATROL & NATURAL RESOURCES (warnings) 5 I 0 I 0 5 MARINE PATROL & NATURAL RESOURCES (vessel stops) 15 0 0 15 SCHOOL RESOURCE COVERAGE (man-hours) I 0 208 244 452 G Communications Division Disp. Calls For Service 1,595 1,475 1,329 4,399 Officer Initiated Calls 1,023 1,024 974 3,021 Code Enf. Initiated Calls 246 733 1,327 2,306 Volunteer Initiated Calls 760 913 718 2,391 Calls Entered Into CAD 2,049 2,683 3,053 12,293 911 Calls Received 853 743 674 2,308 911 Calls Transferred Out 354 346 319 1,009 911 Hang-up Calls 87 66 58 211 Admin. Calls Received 2,191 2,371 2,220 6,963 Admin. Calls Transferred N/A N/A N/A N/A Outgoing Admin. Calls N/A N/A I N/A N/A Training/Meeting Hours 14 8 44 66 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. Training/Meeting Hours Outgoing Admin. Calls Admin. Calls Transferred Admin. Calls Received 911 Hang-up Calls 911 Calls Transferred Out Month 3 911 Calls Received r Month 2 Calls Entered Into CAD ■ Month 1 Volunteer Initiated Calls Code Enf. Initiated Calls 7 Officer Initiated Calls Disp. Calls For Service 0 1,000 2,000 3,000 4,000 Crime Scene/Evidence Items Received 176 96 79 351 Evidence Processed In-house 9 3 12 24 Evidence Outsourced 15 14 4 33 Items Returned 25 29 15 69 Items Purged 10 2 1 13 Cars Impounded 0 0 0 0 Video Redaction Hours 40 0 44 88 Videos downloaded/sent 260 348 311 919 CD's used 32 34 42 108 Supplements Written 2 1 1 4 Evidence Processing Hours 5 10 11 I 26 Crime Scene Processing Hours 8 12 4 24 Training Hours 40 4 0 44 Call Outs 2 2 1 5 Fingerprints 5 8 9 22 State Attorney Requests 91 94 79 264 6 Fingerprints r i Training Hours Evidence Processing Hours CD's used Video Redaction Hours Items Purged Evidence Outsourced Items Received 0 50 100 150 200 250 300 350 400 Code Enforcement R. Iachini on aanroved leave Juh 1st throutrh Aueust 21st. Sept n Aug ■ July Of the 2,328 code calls for the quarter the following is a breakdown of some specific calls made: • Issued 172 written warnings. This ranges 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. • 120 property inspections for title companies and 41 sign violations. • 198 Code Services. • 199 re -inspections, 20 violations were not complied with, 61 were posted for abatement, and 6 abated by vendors. • 133 violations complied. • 1 Lien filed, 1 lien released. • 67 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 violations during the 4ts quarter. Alarm Assessment • $260.00 in alarm permits (new and renew) • $100.00 in false alarms fines • 145 alarm responses by officers, 145 of these were false. • 25 New permits issued. 7 ROADS Asphalt • Put down 20 tons of asphalt throughout the City including Schumann bike path repairs and various road crossings and Spring Valley area manhole covers • Repaired various pot holes and road edges with 1 and 1 %z pallets of bagged cold patch. Concrete • Removed 31 ft. of damaged sidewalk on Fleming St. for A. Thomas to form and pour. Brought in dirt and backfilled sidewalk area to grade inside forms and compacted • Assisted A. Thomas with head wall finishing due to short staff on his part. Grinding • Preformed quarterly inspection on I.R.D. and throughout the city and ground down any and all tripping hazards. Right of Way Mowing • Maintained mowing and landscaping at compound facility. • Maintained all bridge approaches and city owned areas including old sign shop and retention area on Louisiana Ave., Concha dam area and Oceola dead end circle. • Assisted with mowing new compound several times R.O.W. Maintenance • Cut back overgrowth and sight obstructions on vacant lots with side arm mower and /or by hand throughout the city. Misc. • Cut and chipped overgrown trees from back area of Friendship park ball field for parks with skid steer and by hand. • Assisted with removing fallen tree in drainage ditch on Powerline Road. • Cut and chipped overgrown encroaching on residents property from city owned lot on Hinchman., • Assisted with Empress Road crossing and boat ramp. • Trimmed hedge row along stretch of Powerline Rd. • Repaired sunken area under Hardee bridge wiih concrete patch. • Repaired guard rail end on Barber and Concha. • Assisted with re -striping Barber St. sports complex parking lot and City Hall parking lot. • Re -graded overflow parking lot and S.W.T.F. parking lot with millings. • Started ongoing curb and gutter cleaning in Schumann/Spring Valley areas ahead of road paving project. • Leveled raised pavers at Main St./IRD flag pole area. • Assisted S.W. with driveway removal on Sea Side Terrace. Facilities Maintenance • Maintain City Flags • Maintain and monitor all lift stations • Monthly AC maintenance all city buildings • Monthly monitoring and supplies AED stations • Daily maintenance and repairs city buildings • Monitor C1eanSpace Janitorial • Fire Extinguisher Testing (Protegis Fire and Safety) • Creative Playground: Lift Station pump replacement (Meeks Plumbing) • Riverview Park: Restroom plumbing repairs (Maxwell Plumbing) • City Hall: Balcony repairs (Building Time Construction) • Backflow Training: Devroy Sharpe Dave Hamp (FWPCOA) • Yacht Club: Interior painting and lighting (in house) Flooring (CJ Epoxy) • Community Center: Replace interior light fixtures • Police Department: Hot water tank replacement (Maxwell Plumbing) • Art/Quilt Club: Replace AC unit #1 (Arnold AC) • Quarterly Fire/Sprinkler Testing (Vector Security) • Police Department Volunteer Office: Replace AC unit ACH 1 (Arnold AC) Sian Shop • Signage and Installation: • Created; 72 • Signs Installed: 21 • Signs Straightened: 71 • Signs Cleaned: 6 • Trees cut by signs: 5 • Traffic Studies: 16 • GIS Locations: 2 • Decals:15 • Pavement Markings: • Stop Bars: 61 • Yellow Line Striping: 2478LNFT • White Line Striping: 13,167 LNFT • Parking Lots: 2 • Cross Walks: 10 • Handicap stalls: 14 • ADA Mats painted: 0 • Blue Paint: 800 LNFT • Arrows:7 • Special Projects: • Annual sign inspection zone: 80% completed • Road Markings Powerline Rd.: Material ordered • Re -stripe City Hall parking lot: 90% completed • Re -stripe baseball complex parking lot: 100% complete • Roseland Rd. Airport/Pubic works sign: 100% complete • New Projects: • Install RRFBs: 100% completed (Barber/George St.) • Stop Bars and crosswalks road paint zone2: 100% completed • School Zone road markings Barber/Schumann: 0% completed • Zone 3 stop bars and crosswalks: 10% completed • Contract road marking Barber and Fleming: 100 % complete • M.O.T/Special Events 3 • School Lights: 6 • Citizens Request: 3 (3 completed). • Work Orders: 52 (47 completed). • Created Signs Breakdown: • Street Signs: 2 • Regulatory:8 • Warning:46 • Wildlife:2 • Park:3 • Aviation:9 • Construction Zone Warning: 1 CemeterN • Routine Mowing/Weed Eating and Edging • Added 3 sprinklers to unit 1, 2, 4 • Fixed to broken faucets • Repaired 2 3 in. main line break • Replaced ICD 100 Decoder at zone 1,5,34 • Mower 309 to John Deere for repair • Well pump repair • Repaired cracked gate valves zone 15 & 16 • Cremains:5 • Burials:9 • Disinterred:I • Rain Guage: 27.9 0 Construction Specialist • Airport • Build new access road at building D • Repair,/Replace lights • Remove 2 gates • Install fire extinguisher boxes • Indian River Dr. • Repair/Replace lights • Trim Trees • Replace fountain filter • Twin Piers • Built picnic table • Repair/replace lights • Secure south pier damage • Install cameras • Hardee Park • Repair/Replace lights • Yacht Club • Dock Repair • LED light upgrade • Interior Renovation • Community Center • Install French drain system • Old School House • Repair flooring at back entrance • City Hall • Install door closer • Remove palm tree • Training • Backflow inspector CPR and MOT • Golf Course • Roof Repair and Ice machine repairs Fleet Management: • The Fleet Management Staff completed 174 repair work orders, 94 preventive maintenance services 3 service calls and 2 road trips to pick up parts. • In addition to in-house vehicle/equipment work orders, 10 vehicle and equipment repairs were scheduled and completed by outside vendors. • Took delivery of the following units: • Unmarked F150 Responder (PD) • 1500 Dodge Ram (Parks) • Armored Vehicle (PD) • Kubota Zero Turn AP/PW • Completed the prep (Lights, Rack, Graphics, etc.) on the above vehicle. • Completed Sales on Gov. Deals $152,256.99 • Fuel Cost as of the July Aug. Sept. 2023 • $2.94 per gallon of gasoline 2.8% • $3.81per gallon of diesel fuel 15.75% • $3.44 per gallon of dyed diesel 17.50% 10 LEISURE SERVICES Parks Division • Drop off carts • Prepared for park events and worked events • Move golf carts to the compound • Prepare stage and clean up after event at Riverview Park • Re -attach wind screen at the pickerball courts • Prepare conference room for event at compound • Moved the stage to the airport • Deliver golf cart to the Tennis court at Friendship Park • Remove broken handrail from the stairs at the community center • Delivered mower to the cemetery • Trim hedges and installed bricks at the Memorial Park • Repaired fence at Easy St. Park ,George St. Park and Garden Club Park • Loaded up trailer for events • Haul clay to the Barber St. Sports Complex • Install a net and windscreen at the pickleball courts • Haul mulch to the airport • Weed eating the vacant lot at the Main St. docks • Add mulch to the sign at 512 • Repair fence at Bryant Court Park • Move chairs back to Yacht Club • Put dirt around the catch basin at the Community Center • Move the medians at Barber St. • Do maintenance on the golf carts • Spray WOW at the signs around 512 • Haul a golf cart to the airport • Put up a banner at the Main St. docks • Weed eating at the Airport Recreation Division • Continued city run programs. STORMWATER DEPARTMENT • Ditch Maintenance • Lay Sod • Filling in low areas at the Airport piping side • Moved equipment, excavator hose, finished chainsaws for storm prep , traveled to Palm Bay for hydraulic hose, • Catch Basin Repair • Re -grade Embankment • Ditch Maintenance • Lay sod • Road Crossing cleaning • Pipe/road crossing installation and replacement • Armadillo Work • Pour headwalls • Swale Inspections • Retention Area Maintenance • Twin Ditch Maintenance 11 Citizen Request Line • July =122 Approximately 57 were for Stormwater (.48%) 146 Roads (.15%) 25 General Questions (.20%) 2 signs(1%) FPL 08(.067%) Eric 5 (.4%) Other 18(.15%) includes 8 code,7 county, 1 RR, 1 Bldg. Dept. 7, 4 FPL (.03%) 1 not sure • Aug =111 Approximately 65 were Stormwater (59%) 10 roads (.09%) 22 General questions (20%) 8 parks (.07%) Eric 9 (.08%) WM 20 (18%) signs 5 (.04%) Other 11(.09%) includes 8 county and 3 code. • Sept= 127 Approximately 63 were Stormwater (.50%) 11 roads (.08%) 10 General questions (.08%) 3 Signs(.03%)3 Parks (.02%) 3 FPL (.02%) 4 Eric (.03%) WM 12 (.09%) Other 18(14%) includes 3 code, 12 county, 3 bldg. dept.April- 71 Approximately 20 were for Stormwater (28%) 11 Roads,( 15%) 14 general questions (19%), 16 other (22%), 2 signs (02%), Eric (04%) 3 parks (04%) FPL (07%) Includes 2 code, 6 county, 3 not sure (no call back) • July 2023-122 Requests • 57 Stormwater-22 not done, HO to do • 14 Roads — 7 done, 1 HO to do, 2 no asphalt, 1 ongoing project • 4 FPL -1 not done • 8 code- 4 not don, did not get notice • 5 Eric all done • 25 General Questions- all answered • 9 WM- all answered • 1 building Dept. -1 done • 1 Signs — All done (speed study) • 7 County- 1 not done • 8 Parks -all done • 1 no call back — did not call back or did not have enough information • 8 code- not sure if code got to them • 1 Railroad — not sure • Aug. — 142 Request • 65 Stormwater —many ongoing projects • 10- Roads — 9 done • 3 Code — They don't always get back to me • 9 Eric — all done • All general questions — all done • 8 Parks- All done • 20 WM — all done • 8 County — They don't always get back to me • 5 Signs — done • September —155 Request • 63 Stormwater — A few ongoing projects • 3 Parks — All done • 12 WM — all answered • 11 Roads • 3 code — They don't always get back with me • 3 Building Dept. — all done • 12 County — They don't always get back to me • 3 Signs - done • Inspection Tvve Inspection # Passed Failed Conditional Re -Inspection Fee • Final Engineering 181 132 49 0 $0.00 • Drainage Pipe Elevation 67 63 04 0 $0.00 • Driveway 101 72 29 0 $0.00 • Pre -Sod 64 45 19 0 $ 0.00 • Erosion Control Barrier 53 38 15 0 $0.00 • Total 466 350 116 0 0.00 12 GOLF COURSE • Revenue 22-23 21-22 Difference +/- 4th Quarter Rev. $272,503 $253,481 +$19,022 YTD Tot. Rev. $1,920,714 $1,824,317 +$96,397 4th Quarter Rounds 11,550 11,607 -57 YTD Tot. Rds. 59,778 59,829 -51 4th Quarter Green Fee $81,110 $73,983 +$7,127 YTD Green Fee $676,525 $627,256 +$49,269 4th Quarter Cart Fee $155,008 $133,325 +$21,683 YTD Cart Fee $818,564 $781,565 +$36,999 4th Q. Annual Member $0 $0 $0 YTD Ann. Mem. $143,038 $113,116 +$29,922 4th Q. USGA Hdcp. $72 $0 +$72 YTD USGA Hdcp. $5,568 $4,806 +$762 4th Q. Disct. Card $0 $0 $0 YTD Disct. Cd. $48,636 $44,457 +$4,179 4th Q. Driving Range $7,786 $10,774 -$2,988 YTD Dr. Rge. $58,891 $65,878 -$6,987 4th Q. Club Rental $900 $1,001 -$101 YTD Club Rental $3,086 $3,689 -$603 4th Q. Golf Shop Retail $21,698 $24,031 -$2,333 YTD Shop Retail $126,438 $114,015 +$12,423 4th Q. Retail COST ($10,448) ($13,683) -3,235 YTD Retail COST ($67,367) ($70,602) -3,235 4th Q. Golf Shop Profit $11,250 $10,348 +$908 YTD Golf Shop Profit $59,071 $43,413 +$15,658 YTD Golf Shop Margin 45.64% 38.08% +7.56% 4th Q. Restaurant Rent $7,500 $7500 $0 YTD Rest. Rent $30,000 $30,000 $0 *4th Q. Rain amount 25.88" 22.07" +3.81" AIRPORT • Mowing, weed whacking, edging, enforce airport security, Runway light maintenance, spraying, equipment maintenance and runway/taxi area inspection • Chaperoned sub- contractors around airport for camera repairs • Cleaned and greased all 4 flags • Trimmed all shrubs around hangar A,B,C and main building • Chaperoned contractors on runway 5-23 • Serviced AP10-AP08 sign boards • Serviced cleaned gates and key pads • Blow debris off runways and taxis ways BUILDING FUND • In the 4th quarter of this fiscal year, 41 new single-family homes were issued building permits. The number of new single family homes decreased as compared to 3rd quarter high of 61; however the volume of new single family homes is average for this fiscal year. Other permits of significance include 0 new manufactured homes, 0 new commercial buildings, 0 commercial additions, 4 commercial alterations, 0 commercial build outs, 0 residential additions and 112 residential alterations. In all, 908 building permits were issued in the 4th quarter. Over all permitting is average for this fiscal year. • Total number of inspections for the 4th quarter was 3632 for an average of 66 building inspections per working day. The number of inspections for the 4th quarter stayed roughly the same as the 2nd and 3rd quarters. • The number of Certificates of Occupancy issued for the 4th quarter included 39 new single family residences, 0 manufactured homes, 1 commercial certificate of occupancy, 0 commercial temporary certificate of occupancy and 3 commercial certificates of completion. • The following lists the Business Tax Receipt activity for the 4th quarter: new businesses-39, renewals-441, transfers-3, duplicates-0, home based businesses-14, commercial businesses-25, insurance companies-69, vacation rentals-29 and solicitor registrations-0. There were 116 new Contractor registrations. In addition, there have been 81 requests for permit records on properties within the city from lien/title companies. • During the 4th quarter, overall permitting and number of inspections at the average range for the fiscal year. The building front counter renovation which included providing accessible counter space, front counter ballistic glass with communication devices, remodeling of file storage and office spaces and carpet throughout was completed on time and on budget. It is also important to note our part time Fire Inspector Sandy Seeley has completed annual fire inspections on all high priority properties such as restaurants, assembly occupancies such as churches and properties containing fire safety systems such as sprinklers and fire alarms. This was a big undertaking and had not been completed in years prior by Indian River County. No major violations were found and most of the violations found have already been corrected. 13