The URL can be used to link to this page

Home My WebLink AboutR-24-11 4th Qtr Budget AmendmentRESOLUTION 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 Nunn The motion was seconded by Councilmember Dixon vote was as follows: Mayor Ed Dodd aye Vice -Mayor Kelly Dixon ave Councilmember Bob McPartlan aye Councilmember Fred Jones aye Councilmember Christopher Nunn ave and, upon being put to a vote, the The Mayor thereupon declared this Resolution duly passed and adopted this 20" day of March 2024. ATTEST: Wl rl.-&1Vt1A J#nette Williams, MMC City Clerk CITY OF SEBASTIAN, FLORIDA By: p F 1 [.�P�% Mayor Ed Dodd Approved as to form and legality for the reliance by the City of Sebastian only: er Cockcroft, Esq Cify Attorney EXHIBIT "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 Project/Account Change Adjustment Change Reason for Adjustment 2&M Buildings -_Facilities Maintenance _ $130,418 $23,651 $154,069 07/12/23 Utilized R&R Account for \ppropriated from R&R Account ($237,399) ($23,651) ($213,748) Repairs to City Hall Air Conditioners. �ehicles and Fjju%Tent-Parks $101,870 $3,265 $1051135 07/12/23 Used R&R Account to increase ppropriated (from R&R Account _ ($213,748) ($3,265) ($210,483) budget to replace 2004 Parks vehicle. /ehicles and Equipment - Airport $9,500 $18,932 $28,432 07/12/23 Used Auction Proceeds from Sale of Fixed Assets $0 ($18,932) ($18,932) Grader to buy two mowers. nfrasfructure :AA Grant :DOT $1 ``585 455 ($1,426 091 $1,822190 ($1 639 �72 $3 407 645 ($3 �166 �81) 07/12/23 Used DST Reserves to match FAA and FOOT Grants for Rehabilitation Grant $79�1�91 �d9�109; �$i70��2) Runway 05-23 %ppropriated from DST Reserves 1$2,986,771 $91,109) ($3,077,880) of project. :onsultants $0 $120,000 $120,000 07/26/23 Sets up Resilient Florida Grant =DEP Grant $0 ($120,000) ($120,000) for update to Coastal Resiliency Plan. _ _ iRreets/Roads $500,000 $705 880 $1 05/880 07/26/23 Makes ARPA Funds Roadwork )rrZage ---------------------------- $750,000 44,120 by deferincLSchumann Drive drainage. /arious Group Insurance Accounts $2,210,521 $8,066 $2,226,587 4ppropriated from General Reserves ($602 775) ($6,620) ($609,395) \ppropriated from Stormwater Reserves (S669 359) ($522) ($669,881) 05/24/2023 Additional funding needed for kippropriated from Golf Course Reserves ($599,028) ($173) ($599,201) Short-term Disability Insurance. kppropriated from Airport Fund Reserves ($76,380)_ ($113) ($76,493) appropriated from Building Fund Reserves_ ($194,686)_ _ __ ___ ($638) _ _ ($195,324) _ Napes and Benefits 142 $32 790 $269 932 Unused Leave paid at termination based 4ppropriated from General Reserves _ _ Je37 _ 66 )_76) _ ($32,790)______($698 966) on to former City Manager's Contract. ----- )ther Contractual Service $65,200 $144 230 $209,431) 23 Funding needed for cost of the i ro rioted from General Reserves ($698,966) ($108,110) ($807,076) Interim City Attorney. /adousOtherCityAttorneyAccounts............. $188,388......... ($36,120)....... $152,_268 __________________________________________ 3uilding� $0 $56 781 $56 781 08/23/23 Established Senior Center Roof 4ppropnated_from General Reserves ($56,�1�1) ($666,�76) Replacement roject. 'rofessional Services $0 $75,000 $75,000 09/18/23 Reestablished FY2023 Budget appropriated from General Reserves___ ____ __ _{$807,076)_________{$75,000) ($882,076) forStretegic Ptannins Services. 3ui#i Irr��rovements - Airport Gran $0 $400 000 d00) $400 QQ00 G00) 09/27/23 Adjustments to reflect funding for Amendment Lease D $0 ($320 ($320 sources to with :ontributions $0 ($80b0)------ (-$-8-0--�-b--0}- fli h-t-M- a- na-e-men[ on Han9 ar D. Nagesand Ben_e_fits _ $166,126_ $3,409 $169,535 -P-r-o- - 05/24/2023 Adjustment for City Clerk appropriated from General Reserves ($599,366) ($3,409) ($602,775) back payapRroved by City Council. ADJUSTMENTS BEING SUBMITTED FOR CITY COUNCIL APPROVAL Budget Before Budget Budget After Project/Account Chanyyp Adjustment Chan Reason for Adjustment Vehicles and Equfppnent $48.148 $14 026 $ 174 Used R&R Account to replace PD AppropriatedfromR&RAccount ------------------ ($210,483) ......... ($14,526)__ __457)__Volunteer& ArtCenterairconditioners. R&M Buildings $154,069 $1,574 $155,643 Used R&R Account to repair door lock at Appropriated_ from R&RAccount____ ____________($196,457) - ($1,574)__ __($194,8832__theYach------ - ------------------------------- R&M Buildings $155,643 $131995 $169 636 Used R&R Account to repair Unit 2 air Appropriated from R&R Account - - - - - ($188,883) ($13,995) ($174_l188) conditioner at City Hall. ---------- R&M Fencing $7,000 $6,800 $13,800 Used R&R Account to repair the backstop Appropriated from R&R Account __ ($194:883) ($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 QUARTER ENDED September 30, 2023 ADJUSTMENTS PREVIOUSLY AUTHORIZED BY THE CITY MANAGER: Budget Before Budget Budget After Vehicles and E ui_ment____ q P $357000 __-___$357,000 °....- _____________$0 funds to DST Reserves. QQpDJopJiated from General Reserves J$8¢2 Q76)) �489 $7\?10 $11415 f$8741866 Closes Yacht Club Seawall and returns R) Irrigation Systems In rastructure $358,473 ($8,624) $1♦90� $349,848 finds to General Reserves. - propnated from DST_Reserves — ($3 137,254) -'----- $150,109 9- 7,`I . - ($2,987,145 --- --------- ------------------ Defers Airport West Side Sewer work and Infrastructure ($150,109)...... $1,756,692 retumsfundstoDSTReserves. ___ __________________________________$1,906,801__ FDOT Grant ...... ($37 814 $3 71 ( 34 543) Closes Runway 10-28 and Taxiway Bravo AggQfOppgated from Airport Reserves ($77 198 $ 18 i$ 6,380) Markings project and returns funds to Infrastructure___________________ _________ $4726�_ _ _ ($4089 $43179 Airport Reserves. ---......................... ____ FDOT Grant Contributions & Donations ($35,000) ($35,000) $35,000 $35,000 $0 $0 Delays in el negotiating with the selected Buildings $70,000 - �$70,000) $0 contractor resulted in changes plans. ....... ------- �pprop(jat frpj� DST Reserves ($2,987,145) $374 ($2,986 771) Closes MIS COSty Equipment project anc orrlputa y e ies $7 500 ($3,016) $4,48d returns funds to DST Reserves. Vehicles and Equipment $7,5--0------------ $2,64---------- $10,142 ____--__-__-_--_-_ ----------------------------- Appropriation from DST Reserves _ ($3,077.880) $13,024 ($3,064,856) Adjustment to close Project A2361. ProectA2361StormwaterBulldozer $150000___ $13,024 $136,976 p/Oppo Pp ��((°°rrGeneral Reserves ront �T Reserves ;ai (($874/866) ($3,064,856� $4 $40 $74?J608 (($�70,026 $2,989,888 Adjustment to close out remaining unexpended balances of completed _ous__omp ea_Projects____________________$1,967,23__________($79,808)____1$1,887,428_ Projects at year -end_____ ------------------ Appropriation from LOGT Reserves ($356,494) $72,142 ($284,352 Close out remaining unexpended balance Sidewalks $75,000 $2,858 of Sidewalk Replacement Project. --------------------------------- ------------ Interest on ARPA Funds ($11 5-00) __($72,142) $2 500 ($9 000) ...... Adjustment to close out unexpended Departmental Supplies _ 0,500 ____($2 500) $ balance of Artificial Reef Grant. ---------- --------------' Appropriation from DST Reserves ($3,029,792) $200 ($3,029,592) Close Project for Runway 05/23 Design o1 Infrastructure $979,007___________($200) $978,807 Rhabi elitation. __ 100�h Anniversary` Expense $55,000 $11,100 $66,100 Records additional contributions toward Contributions and Donations - -- $2,000) ($11,100 - )-------� $13,100 - - — Centennial Celebration. - - - - - - --------------------------- Page 2 of 2 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.) l0:(:1Ai. -. it Ja,. i I,A"°1 Budget YTD % Beginning Balance $ $ 8,195,001 Ad Valorem Taxes 5,146,342 5,102,270 99.1% Franchise Fees 1,567286 1,775.486 113.3% U61ityTaxes 3210,987 3,523.528 109.7% Intergovernmental 4,084,464 4235,991 103.7% Charges for SeNce 745,870 763,311 102.3% Ucenses and Other 502,200 889,264 177.1% Total Revenues $ 15, 57,149 $ 16, 89,850 106.8% From Fund Balance 970.933 - 0.0% Total Sources $ 16,2211,0112 $ 16, 89,850 100A% CityCoundl $ 62,725 $ 55,940 892°% CityManager 342,355 337,591 98.6% CityClerk 226,599 226,019 99.7% CityNtomey 379.606 373,973 98.5°% AdminSeNces 623.711 594,889 95.4% MISDidsion 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,441290 1,313,818 912°% Public Facilites 863,688 790,792 91.6% Parks 1,386,316 1, 17,694 87.8% Cemetery 164,404 161,719 98.A% CommunityDelelopmenl 701,873 504,123 71.8% Non -Departmental 1,435,071 1,353,201 94.3% Total Expenditures $ 16,172,613 $ 14,969,331 92.6% Unappropriated 55,469 Na Total Uses $ 16, 28,082 $ 14,969,331 922% Ending UnappropriatedFund Balance $ 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. AMEPICAN RES�yp' PLAN AC I d F Nei lY I22A69,4733 Beginning Rind Balance $ - $ ARPAGrant - - nla 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 $ 2,708,156 $ 2,932,871 108.3 % Gardenia Ditch $ 746.156 $ 6,043 0.8% Schumann Drive 44,120 7,596 17.2% Concha Dam 700,000 - 0.0% Roadwork 1,205,880 - 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 pendilures - MOM Ending Available Rinds It 2,907,232 General Fund Revenue .odic:rm e,devr ■rc.,mo.r. s,000 .moo c.00° �00dp, a*aee -(I'ee ws' ec6' 1 .. pL f-0 \0 3os°'- ii G '�cesed tole I ' General Fund Expenditures „m m .new®��_ �eb� G�gG��p`+`y��M��a�„O�s A��poleala•-Q �eo�oA�•�,4• pA H.4.`e�pu Pde^ P� �aMY NS 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.) Fund Balance R&R Account Beginning Reserves 10/01/22 $ 7,92U,001 $ 275,000 Year to Date Revenue 16.289,850 Fund BalancerR&R Changes to Date: Purchases Not Received (60.264) Unfinished 2022 Projects (215.065) Harbor Lights Fuel Tanks (17.850) CityMomey Recruitment (34,500) Exempt Paylncreases (70,621) Police Pay Increases (152,340) Increase to Centenial Funding (50,000) Closed A2216 Police Vehicles 1,274 Short -tens Disability Insurance (6,620) CityManager Leave Payouts (32,790) Payments to Interim CltyAttorne (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 CityHall A1r Conditioners (23,651) Replacementof Parks Vehicle (3,265) Replaced Volunteer & M Center A/Cs (14,026) Repaired Door Lock at Yacht Club (1,574) Repaired CityHall 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,43.2 $ 174,088 Adjust R&R to $275,000 (100,912) 100.912 Adjusted Reserves $ 9,240,520 Is 275,000 Assigned Funds (666,992) - Employee Final Payouts (390,000) Net Unassigned Reserves $ 8,133,520 $ 275,000 Total Ending Reserves S 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 BUDGET AND INTEREST HIGHER. SPENDING WAS LOWER THAN ANTICIPATED. STORMWATER FUND SUMMARY Budget YTD % Beginning Fund Balance $ • $ 1,957,126 StormwaterFees 1,952,055 1,949,304 99.9% InterestandMer 7,566 54,803 724.3°% Total Revenues $ 1,959,621 $ 2,004,107 1023% From Fund Balance 669,881 0.0% Total Sources $ 2,629$2 $ 3,961,P33 150.6% Operating Bpenditures $ 2211,917 $ 1,831,829 82,8% Capital Way 56,393 43,836 77.7% Transferto Capital Projects 361,192 185,198 51.3% Total Uses S 2,629$2 S 2,060,863 78A% Ending Fund Balance $ $ 1,900,370 Projected in2023Budget S 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 M % Beginning Resources $ $ Rents 577,861 FEWSteteReimbursements 32,230 Imestmentlncome 725 Nscellaneous 104,622 Total Revenues 715A38 From Fund Balance 76,493 Total Sources S 791,931 S Operating EVenses DST Fund Loans Range Nemng Capital Outlay Transfers for Projects otal Uses at Ending Resources Projected in 2023 Budget $ 521,046 $ 36.500 36,834 41,615 75,889 711,884 $ 80,047 $ $ 503,120 659,488 114.1% Na 11,963 1650.1% 107,959 1032% 779A10 108.9% rda 1,282,530 508,06 20,110 36,834 41,443 72,524 679,327 603,203 583,167 97.6% 55.1% 100.0% 99.6% 95.6% 95.4% GOLF COURSE REVENUES CONTINUED TO BE FAVORABLE SOME RANGE NETTING COST ENDED UP BEING INSURED $163,622 WAS RECEIVED FROM THE SALE OF OLD CARTS. I GOLF FUND SUMMARY -7= Budget YID % Beginning Resources s $ 245,915 Charges for Service 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) 1445% Sales ss.Cost ofSales 45,000 29,967 66.6% From Reserves -Cad Repairs 61,316 - nra From Reserves -Carts 528,640 - nfa FromReserves -Pay Changes 4245 - nla From Reserves for Ditches 5,000 Na Total Sources $ 2A17,386 $ 2,045,143 94.6% Operating Expenses $ 1,609,079 $ 1,567,306 97A% Equipment 7.889 7,889 100.0% Lighlning Damage 21,097 21,097 100.0% Range Netting 88.826 88,826 100.0% Can Purchase 528.640 528,640 100.0% Total Operating Expense 2255531 2213,758 98.1% General Fund Payment 35,000 35.000 nla Building Fund Payment 36,P09 36209 100.0% Total Uses $ 2,326,740 $ 2, 84,967 982% Total Ending Resources $ 90,646 $ 6,091 Projected in 2023 Budget s (302,729) BUILDING FUND RESOURCES EXCLUDE THE LOANS AND ADVANCES OF $1,112,043 ADVANCE TO THE GOLF COURSE. BUILDING FUND SUMMARY Budget YID % Beginning Resources $ $ 1,664,006 Licenses and Permits 1,P29,500 876,023 71.3% ChargesforSerece 33.500 16,376 48.9% Fines and Forfeits 5,500 4,325 78.6% Miscellaneous 7289 44,173 606.0% Golf Fund Loan Payments 36209 36209 100.0% Total Revenues 1,311,998 977,106 74.5% From Fund Balance 195,324 - nla Total Sources 197A22 977,106 64.8% Operating Expenses $ 1,273.182 $ 988,466 77.6% Capital Outlay 194263 194,262 100.0% Total Uses $ lABTA46 $ 1,182,728 80.6% Total Encino Resources 39,877 $ 1A48AB4 Projected in 2023 Budget $ 1 A93,863 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 GENERAL FUND TAXES -8,124,514 -8,948,425 -9,414,216 -10,401,284 -9,924,615 104.80% LICENSES & PERMITS -150,240 -195,919 -189,643 -163,719 -163,700 100.01% INTERGVT'L REVENUE -3,013,721 -3,523,087 -4,373,792 -4,235,991 -4,084,464 103.71% CHARGES FOR SERVICE -663,702 -763,143 -778,572 -763,311 -745,870 102.34% FINES AND FORFEITS -53,164 -38,277 -82,430 -170,718 -50,500 338.05% MISC. REVENUE -386,061 -241,170 -459,589 -554,828 -253,000 219.30% TRANSFERS IN 0 0 -48,094 0 -35,000 0.00% FROM FUND BALANCES 0 0 0 0 -970,933 0.00% GENERAL FUND REVENUE -12,391,402 -13,720,021 -15,346,336 -16,289,850 -16,228,082 100.38% CITY COUNCIL 46,702 55,883 57,224 55,940 62,725 89.18% CITY MANAGER 269,335 285,943 339,347 337,591 342,355 98.61% CITY CLERK 264,887 205,204 261,773 226,019 226,599 99,74% LEGAL 167,044 195,696 205,481 373,973 379,606 98.52% ADMINISTRATIVE SERVICES 674,673 656,306 747,045 594,889 623,711 95.38% M.I.S. DIVISION 511,750 513,329 549,680 635,465 728,199 87.27% HUMAN RESOURCES 0 0 0 224,878 231,971 96.94% POLICE ADMINISTRATION 1,263,875 1,020,630 1,087,665 1,112,264 1,164,215 95.54% POLICE PATROL 3,308,391 3,461,189 3,687,563 4,037,999 4,124,025 97.91% CODE ENFORCEMENT DIVISION 194,219 187,626 180,269 144,720 202,679 71.40% POLICE INVESTIGATIONS 1,076,622 1,107,742 1,174,005 1,203,089 1,342,736 89.60% POLICE COMMUNICATIONS 582,845 577,505 605,842 681,157 751,150 90.68% ROADS AND DRAINAGE 963,173 927,720 969,560 1,052,165 1,157,837 90.87% CENTRALGARAGE 202,251 211,926 229,392 261,653 283,453 92.31% FACILITIES MAINTENANCE 568,181 598,970 566,354 790,792 863,688 91.56% PARKS/RECREATION 1,110,021 1,035,794 1,106,152 1,217,694 1,386,316 87.84% CEMETERY 177,736 179,0D0 143,561 161,719 164,404 98.37% COMMUNITY DEVELOPMENT 539,290 477,728 480,818 504,123 701,873 71.83% NON -DEPARTMENTAL 976,464 1,025,035 1,341,840 1,353,201 1,490,540 90.79% GENERAL FUND EXPENDITURES 12,987,460 12,723,227 13,733,572 14,969,331 16,228,082 92.24% 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 AMERICAN RESCUE PLAN ACT INTERGVT'L REVENUE 0 -1,666,064 -1,666,063 0 0 0.00% MISC. REVENUE 0 -1,631 -20,587 -63,398 -12,000 528.32% FROM FUND BALANCE 0 0 0 0 -2,696,156 0.00% ARPA FUND REVENUE 0 -1,667,695 -1,686,650 -63,398 -2,708,156 2.34% OPERATING EXPENSES 0 0 481,011 12,000 12,000 300.00% TRANSFERS OUT 0 0 3,844 13,634 2,696,156 0.51% TO FUND BALANCE 0.00% ARPA FUND EXPENDITURES 0 0 484,855 25,634 2,708,156 0.95% LOCAL OPTION GAS TAX TAXES -686,491 -741,313 -801,509 -751,077 -777,637 96.58% INTERGVT'L REVENUE -13,694 -14,105 -14,528 -14,963 -14,964 100.00% MISC. REVENUE -11991 -503 -5,106 -20,309 -2,479 819.23% FROM FUND BALANCES 0 0 0 0 -284,352 0.00% LOGT FUND REVENUE -702,175 -755,920 -821,142 -786,349 -2,079,432 72.85% OPERATING EXPENSES 5,400 101,964 33,900 11,301 10,800 104.64% CAPITAL OUTLAY 105,554 34,372 4,870 0 0 0.00% DEBTSERVICE 243,886 243,398 242,801 122,174 122,174 100.00% TRANSFERS OUT 498,043 525,946 19,124 4,658 946,458 0.49% TO FUND BALANCES 0 0 0 0 0 0.00% LOST EXPENDITURES 852,894 905,680 300,694 138,132 1,079,432 12.80% DISCRETIONARY SALES TAX TAXES -3,469,568 -4,037,460 -5,001,740 -4,791,513 -5,160,637 92.85% MISC. REVENUE -68,126 -35,198 -39,348 -93,413 -98,209 95.12% FROM FUND BALANCES 0 0 0 0 -3,029,592 0.00% DST FUND REVENUE -3,537,694 4,072,658 -5,041,088 -4,884,926 -8,288,438 58.94% OPERATING EXPENSES 15,487 0 0 0 0 0.00% CAPITALOUTLAY 0 17,849 7,151 0 0 0.00% TRANSFERS OUT 2,321,748 4,735,153 7,973,347 2,668,317 7,425,064 35.94% TO FUND BALANCES 0 0 0 0 863,374 0.00% DST FUND EXPENDITURES 2,337,235 4,753,002 7,980,498 2,668,317 8,288,438 32.19% RIVERFRONT REDEVELOPMENT FUND MISC. REVENUE -41,082 -37,467 -42,517 -54,691 -43,719 125.10% TRANSFERS IN -403,240 -457,672 -385,665 -469,960 -380,580 123.49% FROM FUND BALANCES 0 0 0 0 -86,952 0.00% RRD REVENUE 444,322 -495,139 -428,182 -524,651 -511,251 102.62% OPERATING EXPENSES 286,894 252,927 283,921 249,701 260,918 95.70% GRANTS ANDAIDS 15,000 5,323 8,049 0 31,951 0.00% TRANSFERS OUT 37,872 174,305 49,572 13,550 70,D01 19.36% TO FUND BALANCES 0 0 0 0 148,381 0.00% RRD EXPENDITURES 339,766 432,555 341,542 263,252 511,751 51.49% PARKING IN LIEU OF FUND MISC. REVENUE -3,687 -11,899 -17,570 -8,633 -539 1601.58% PARKING IN UEU OF REVENUE -3,687 -11,899 -17,570 -8,633 -539 1601.59% TO FUND BALANCES 0 0 0 0 539 0.00% PARKING IN LIEU OF EXPENDITURES 0 0 0 0 539 0.00% MISC. REVENUE FROM FUND BALANCES REC. IMPACT FEE REVENUE TRANSFERS OUT TO FUND BALANCE REC. IMPACT FEE EXPENDITURES STORMWATER UTILITY FUND MISC. REVENUE TRANSFERS IN FROM FUND BALANCES STORMWATER REVENUE PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TRANSFERS OUT STORMWATER EXPENDITURES LAW ENFORCE FORFEITURE FUND INTERGOVERNMENTAL REVENUE FINES AND FORFEITS MISC. REVENUE FORFEITURES FUND REVENUES OPERATING EXPENSES CAPITAL OUTLAY GRANTS AND AIDS TO FUND BALANCES FORFEITURE FUND EXPENDITURES STORMWATER DEBT SERVICE FUND MISC. REVENUE TRANSFERSIN FROM FUND BALANCES STORMWATER DEBT REVENUE DEBT SERVICE STORMWATER DEBT EXPENDITURES 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 -147,023 -214,779 -182,042 -107,651 -163,389 65.89% 0 0 0 0 -173,474 0.00% -147,023 -214,779 -182,042 -107,651 -336,863 31.96% 480,160 121,037 121,276 36,839 228,474 16.12% 0 0 0 0 108,389 0.00% 480,160 121,037 121,276 36,839 336,863 10.94% -1,969,428 -1,958,662 -1,973,693 -2,004,107 -1,959,621 102.27% 0 0 -200,000 0 0 0.00% 0 0 0 0 -669,881 0.00% -1,969,429 -1,958,662 -2,173,693 -2,004,107 -2,629,502 76.22% 654,105 685,797 679,375 770,017 916,628 84.01% 613,330 790,024 817,843 1,061,812 1,295,289 81.97% 186,937 123,824 139,071 43,836 56,393 77.73% 29,019 16,503 311,661 185,198 361,192 51.27% 1,483,392 1,616,148 1,947,951 2,060,864 2,629,502 78.37% 0 0 0 0 0 0.00% -133 -15,050 -21,315 -50 -1,000 5.00% -1,665 -1,550 -1,914 -1,157 -160 722.99% -1,798 -16,600 -23,229 -1,207 -1,160 1D4.03% 5,072 1,500 3,061 0 0 0.00% 0 15,000 0 0 0 0.00% 1,000 0 0 1,500 0 0.00% 0 0 0 0 1,160 0.00% 6,072 16,500 3,061 2,500 1,160 129.31% -2,165 -454 -397 0 0 0.00% -401,355 -400,961 -220,605 0 0 0.00% 0 0 0 0 0 0.00% -403,520 401,415 -221,002 0 0 0.00% 402,137 400,529 401,834 0 0 0.00% 402,137 400,529 401,834 0 0 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 GOLF COURSE FUND INTERGOVERNMENTAL REVENUE 0 0 0 0 -77,472 0.00% CHARGES FOR SERVICE -1,485,563 -1,456,436 -1,765,135 -1,868,168 -1,741,611 107.27% MISC. REVENUE -41,768 -42,596 -50,838 -270,906 .64,102 422.62% FROM FUND BALANCES 0 0 0 0 -599,201 0.00% GOLF COURSE FUND REVENUE -1,527,331 -2,499,032 -1,815,973 -2,139,075 -2,482,386 86.17% PERSONAL SERVICES 280,310 297,091 263,952 271,843 287,750 94.47% OPERATING EXPENSES 372,536 379,894 377,915 401,651 408,805 98.25% CAPITAL OUTLAY 0 0 0 28,986 28,986 100.00% TRANSFERS OUT 38,367 38,366 36,085 36,209 71,209 50.85% TO FUND BALANCES 0 0 0 0 90,000 0.00% ADMINISTRATION 691,213 715,351 677,952 738,689 886,750 83.30% OPERATING EXPENSES 579,658 582,490 596,146 678,613 688,569 98.55% CAPITALOUTLAY 0 0 8,505 0 154,472 0.00% MAINTENANCE 579,658 582,490 604,651 678,613 943,041 80.50% PERSONAL SERVICES 99,041 107,828 145,790 160,421 162,550 98.69% OPERATING EXPENSES 1,108 2,587 12,542 54,778 61,405 89.21% CAPITAL OUTLAY 3,716 0 0 528,640 528,640 100.00% DEBT SERVICE 56,390 56,390 51,691 0 0 0.00% GOLF COURSE CARTS 160,255 166,805 210,023 743,839 752,595 98.84% GOLF COURSE FUND EXPENSE 1,431,126 1,464,646 1,492,627 2,161,141 2,482,386 87.06% AIRPORT INTERGOVERNMENTAL REVENUE -30,000 0 0 0 -32,230 0.00% CHARGES FOR SERVICE 0 0 0 0 0 0.00% MISC. REVENUE -558,675 -579,785 -615,918 -779,410 -683,208 114.08% TRANSFERS IN -4,691 0 -31643 0 0 0.00% FROM FUND BALANCE 0 0 0 0 -76,493 0.00% AIRPORT REVENUE -593,366 -579,785 -619,561 -779,410 -791,931 98.42% PERSONAL SERVICES 70,760 62,692 133,225 195,250 193,036 101.15% OPERATING EXPENSES 256,032 277,935 295,521 313,166 314,827 99.47% CAPITAL OUTLAY 50,070 9,205 29,043 78,276 78,449 99.78% DEBTSERVICE 21,477 21,116 20,740 20,110 36,500 55.10% TRANSFERS OUT 0 150,000 4,800 72,524 75,889 95.57% TO FUND BALANCES 0 0 0 0 93,230 0.D0% AIRPORT EXPENSE 398,338 520,947 483,330 679,327 791,931 85.78% BUILDING FUND LICENSES & PERMITS -911,334 -1,328,862 -1,217,579 -876,023 -1,229,500 71.25% CHARGES FOR SERVICE -18,094 -33,415 -30,273 -16,376 -33,500 48.88% FINES AND FORFEITS -6,298 -5,200 -6,836 -4,325 -5,500 78.64% MISC. REVENUE -9,553 -13,210 -19,060 .44,172 -7,289 606.01% TRANSFERS IN -38,367 -38,366 -36,085 -36,209 -36,209 300.00% FROM FUND BALANCE 0 0 0 0 -195,324 0.00% BUILDING REVENUES -983,646 -1,419,053 -1,309,834 -977,106 -1,507,322 64.82% PERSONAL SERVICES 607,069 631,113 715,665 813,071 942,425 86.27% OPERATING EXPENSES 135,889 160,093 238,328 175395 330,757 53.03% CAPITAL OUTLAY 3,952 22,957 0 194,262 194,263 100.00% TO FUND BALANCES 0 0 200 0 39,877 0.00% BUILDING EXPENSE 746,911 814,164 954,193 1,182,728 1,507,322 78.47% CITY COUNCIL PERSONAL SERVICES OPERATING EXPENSES TOTALS CITY MANAGER PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTALS CITY CLERK PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTALS LEGAL PERSONAL SERVICES OPERATING EXPENSES TOTALS ADMINISTRATIVE SERVICES PERSONAL SERVICES OPERATING EXPENSES TOTALS M.I.S. DIVISION PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTALS HUMAN RESOURCES PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTALS POLICE ADMINISTRATION PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTALS POLICE PATROL PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTALS CODE ENFORCEMENT DIVISION PERSONAL SERVICES OPERATING EXPENSES TOTALS POLICE INVESTIGATIONS PERSONAL SERVICES OPERATING EXPENSES CAPITAL OUTLAY TOTALS POLICE COMMUNICATIONS PERSONAL SERVICES OPERATING EXPENSES 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 22,728 22,732 22,726 22,725 22,725 100.00% 23,973 33,151 34,498 33,216 40,000 83.04% 46,702 SS,883 57,224 55,940 62,725 89.18% 258,605 273,298 290,514 325,138 324,894 100.08% 10,730 12,645 13,696 12,452 17,461 71.32% 0 0 35,137 0 0 0.00% 269,335 285,943 339,347 337,591 342,3S5 98.61% 171,932 180,890 186,822 187,035 186,809 100.12% 92,955 24,314 74,951 38,984 39,790 97.97% 0 0 0 0 0 0.00% 264,887 205,204 261,773 226,019 226,599 99.74% 92,686 162,196 179,916 150,339 150,606 99.82% 74,359 33,499 25,565 223,635 229,000 97.66% 167,044 195,696 205,481 373,973 379,605 98.52% 539,816 514,984 590,894 479,222 504,849 94.92% 134,857 141,322 156,151 115,667 118,862 97.31% 674,673 656,306 747,045 594,989 623,711 119.77% 345,874 347,018 377,886 408,928 447,909 91.30% 163,865 166,312 171,793 226,537 280,290 80.82% 2,011 0 0 0 0 0.00% 511,750 513,329 549,680 635,465 728,199 87.27% 0 0 0 177,752 174,428 101.91% 0 O 0 47,126 57,543 81.90% 0 0 0 0 0 0.00% 0 0 0 224,878 231,971 96.94% 1,064,435 895,521 977,461 993,831 1,034,347 96.08% 160,747 125,109 101,079 118,433 129,868 91.19% 38,694 0 9,125 0 0 0.00% 1,263,875 1,020,630 1,087,665 1,122,264 1,164,215 95.54% 3,029,232 3,153,248 3,335,083 3,585,495 3,645,924 98.34% 245,672 275,264 319,925 403,572 407,007 99.16% 33,487 32,677 32,555 48,932 71,094 68.83% 3,308,391 3,461,189 3,687,563 4,037,999 4,124,025 97.91% 169,750 170,981 162,658 130,035 181,889 71.49% 14,469 16,645 17,611 14,685 20,790 70.63% 184,219 187,626 180,269 144,720 202,679 71.40% 878,785 954,685 1,030,390 1,051,290 1,171,296 89.75% 123,458 143,558 140,023 142,899 159,758 89.45% 74,379 9,500 3,593 81900 11,682 76.19% 1,076,622 1,107,742 1,174,005 1,203,089 1,342,736 89.60% 573,959 566,5SO 596,697 672,750 734,155 91.64% 8,886 10,955 9,145 8,407 16,995 49.47% 582,945 577,505 605,842 681,157 751,150 80.66% 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 ROADS AND DRAINAGE PERSONAL SERVICES 588,186 555,076 562,998 631,473 689,958 91.52% OPERATING EXPENSES 335,797 328,867 346,064 398,078 445,046 89.45% CAPITALOUTLAY 39,190 43,777 60,498 22,615 22,833 99.04% TOTALS 963,173 927,720 969,560 1,052,165 1,157,837 90.87% CENTRALGARAGE PERSONAL SERVICES 180,924 189,793 203,840 213,524 232,918 91.67% OPERATING EXPENSES 18,950 22,143 25,553 40,530 41,894 96.75% CAPITALOUTLAY 2,376 0 0 7,598 8,641 87.93% TOTALS 202,251 211,926 229,392 261,653 283,453 92.31% FACILITIES MAINTENANCE PERSONAL SERVICES 279,726 290,017 271,376 256,702 262,826 97.67% OPERATING EXPENSES 234,361 234,368 286,640 472,190 538,688 87.66% CAPITAL OUTLAY 54,094 74,585 8,338 61,901 62,174 99.56% TOTALS 568,181 598,970 566,354 790,792 963,698 91.56% PARKS/RECREATION PERSONAL SERVICES 736,297 732,945 782,422 811,579 959,751 84.56% OPERATING EXPENSES 218,871 253,790 287,401 285,631 304,913 93,68% CAPITAL OUTLAY 154,854 49,059 36,329 120,484 121,652 99.04% TOTALS 1,110,022 1,035,794 1,106,152 1,217,694 1,386,316 87.84% CEMETERY PERSONAL SERVICES 151,633 149,171 113,984 128,280 128,128 100.12% OPERATING EXPENSES 26,103 29,829 28,771 31,166 33,976 91.73% CAPITAL OUTLAY 0 0 806 2,273 2,300 98.83% TOTALS 177,736 179,000 143,561 162,719 164,404 98.37% COMMUNITY DEVELOPMENT PERSONAL SERVICES 392,517 416,308 409,741 472,682 581,583 81.28% OPERATING EXPENSES 132,124 61,420 71,077 31,441 120,290 26.14% CAPITALOUTLAY 14,650 0 0 0 0 0.00% TOTALS 539,290 477,728 480,818 504,123 701,873 71.83% NON -DEPARTMENTAL PERSONAL SERVICES 264,098 275,349 312,815 326,833 326,832 100.00% OPERATING EXPENSES 707,675 703,732 714,666 745,558 745,678 99.98% CAPITAL OUTLAY 0 0 0 0 0 0.00% TRANSFERS OUT 4,691 45,954 314,359 280,811 418,030 67.17% TO FUND BALANCE 0 0 0 0 0 0.00% TOTALS 976,464 1,025,035 1,341,840 1,353,201 1,490,540 90.79% TOTAL GENERAL FUND 12,887,460 12,723,227 13,733,572 14,969,331 16,228,082 92.24% Project NumherDescription M019 A1925 Pink SiM(Complee) AI952 Construct Hangs D TOTAL FV2020 A2007 CDOG Grant Pwpemn A2029 CRA Spate & larJxWe(Conq)kte) A2030 How Public Fadllim Compound (Complete) A2050 Cmatmd Tad lac(Compkic) A2063 Septieto Smer Grant Pmgmn(Cooplde) TOTAL FV2021 A2104 PhoneSystm(Complde) A2123 TrceProtaton Plan(CoiryMe) A2126 Yaht Club Seanall(Cooglife) A2150 rstalTuh Sewer Saice(CaWMe) A2161 Samwaer MasterPln TOTAL FV2022 A2201 CdywikCmryutas(CampWe) AZ04 Network lnhaaudm(CompMe) A2206 CADIRMS System Dpdae(Compilde) A2207 Police Vehidm& EquWmmt(CmVktc) A2209 PD COPE Trader(Complete) A2212 PD Vdaim(Conip1de) A2214 PD Fbnug(Couplde) A2215 LdsumSrvim Vehicle& Mower(Cmiplde) A2216 Commmdv Dwelopw oSOV(Complde) A2217 d Fin 19hedd Loader(Cornpldel AM W'orkmeWaa(ront A2221 BSSC Bae6dl Backstops AM Play®omdloprovemmm AM Pak lnipmvamts(CotpIde) AZ224 Rwariw, Pak EnhnmomB .A2230 Railroad Croxing5idewa&s A2231 Road lmpmvmmis A2150 Covirm(4)SquseHaign A2252 Hngur C Office lrryrovemdOs(Cm0e4) A2253 Aupon RameGmn(Complde) A784 Raab Runway 621(Complde) A2260 SwalmDrimays,Cuhms A2261 Comdw Dmllplaom A22Q Sipbng(Conglde) A2261 Tulip Ha6Ra Ratoiaim A2264 Gardenia Dish AM Shumm Drive BoxCuHn A2267 Mud Errnacm(Conpldel TOTAL CITY OF SEBASTIAN CAPITAL PROJECT STATUS REPORT AS OF SEPT 30, 2023 Current Prior Budget Share Project Year Year Expenditures Percent Funds Budget Sources (in ThousaadsotS) Budget Expenditures Expenditures To Date ExpendedEoeombrances Remaining DSTMF 721169.7 241,759 4,400 237,358 241,759 100.00'% - - FDOTNST7AP 1,0450167.2 2,317,253 170,490 2,173,212 2,343,702 101.14% 42139 (68,588) S 2559,011 $ 174P $ t,410510 S 25K,160 101.03% S 42,139 (imm) CDBG 515 515,175 107,632 26IN 369,198 71.66Y. 12,000 133,977 CRA 90 90322 - 9Oj22 90,322 100M.. - - SIRWMDIDST II.80,632 9,643,461 141,932 9501,530 9,643,462 100.00'% - 1 FAA 663 663,062 3,200 659,861 663,061 100.00% - 1 IRLUU 418147.8 90,606 5,000 851605 90,605 100.00% - 1 $ 11,00t,628 S 257,764 S 111^986 S 14854649 9R67% S 12,000 137,979 DST 83.7 83,807 1,080 82727 83,807 100.0r. - DST 61 61,409 61,409 61,409 IWAO% - GF 352 351,752 1,415 350,337 351,752 100.00% - FDOTSIR101DIDST U27114WBO 1,756,69E IX648 1,62&044 1,756,69E I0D.00% - DSTSW 350750 700,000 87,650 5W750 648,400 92.63% 51,6W - S ;953,660 $ 214793 S 2IiW66 S 2,902,059 90% $ 51,600 - DST 24 24,039 - 24,038 24,038 10DOD''A - DST 10 919D 91923 9,rm 10um% - DST 126 126,069 14,000 lIZ069 12Q059 100.00% - DST 293 293,P68 278585 14,693 293,268 100.W% - DST 33 9786 32,693 91 32,186 100.00% - OF 99 %744 98,744 - 9&744 100.00% I OF 23 21,90E 22,T99 103 27,W2 100% GF .34 33,652 33,651 - 33,651 IW.W% - I OF 25 23,027 25,027 - 25,027 I00.00% - - DST 203 2033W m0 06 - 203,306 100.00% - - CRA 50 50100 UK - U50 17.10% - 41,450 RIF 75 75,000 - - - O.W% - 75,000 RIF 104 101,026 34,715 1526 A241 34.84% 67,759 26 RIF 9 8,959 - 8,959 8,959 100,00% - - DON 4 4550 - - - 0.00% 4,350 LOGTIDST 10R90 IW,WD I,8W 6,400 8,200 432% 14,920 16090 ARPA 1, 06 Ij05,880 - - - 02% 1205,01) FDOTIDST IZO14 1,570,000 - - - O.W% - 1,57kmD FDOTIDON 0 - - - On% - - FAA 32 34ow 4,144 27,756 3ZODD [ROD% - - FAAIFDOT1W 193,4110.71131 217,194 213,1W 4,194 217,393 IW,W% - I SW - 245 244,695 70,444 A039 IK533 4334% 13,855 124,307 ARPA 100 7W,000 - - - 0.00Y. - 74000 DST 70 70214 70114 - 7U14 100,00% - I IRLGSW 0185 23191 4,60 4,431 9,119 3915% 2842 11,330 ARPA 750 750,000 6,043 3,944 9,881 132% 3,756 736,357 ARPA 44 44,120 75% - 7,596 17.22% 36,524 SW' 67 66,837 K837 - 6(x837 I00.00% - S 6,326A81 S 1,197,186 S 254,055 S 1,451,240 2331% S 139,6% 4,635,SB5 Page 1 of 2 Project Number Description FV2023 A2300 Sdvadlod Update(Complde) A2301 CnywWcComputm AZ302 CO&v Fglpmml (Conglde) A2303 Ndwak Infrastructure AZ304 Backup S stw Updae A2305 Pais Sawby Caaaas(Caoglde) AZ306 PDVchides&Equgr A2307 PDBody W'om&VddeCemma(Cmrylde) A2308 CAIYRMSSyslem A2309 PDAmoredVchkk(Complde) A2310 PDGmerar Transfa SwAch A2311 Air Cod kbra Replmcss(Coup lde) A2312 Nummarre In A2313 Humcne Nicole A2315 IN Atmiwmay Cdebratun A2316 JAG Gran(Cmryide) A2317 Pal &a&Sinaw A2318 %orCmtaRmf A2319 Yacht Club lopmvanmis A2320 Sw6IBMPA A2321 Pak lmpmwmmis A2322 Rusk Sgys A2323 CRA SustamabkEcanomk Redndopmmt(Campkte) A2324 Rvwiew Arm lmpwwcmmis A2325 Coastal Resilience Plm Update 027 Natural lardscVi IyLlDDam A2328 9aatcpc Mm A2329 Smicr(mterFkotmg A2331 Buekd Truck A2332 Brush Truck A2333 Drug Truck _..... .. A2334 5dmalk(DadaDialysis) A2335 &red Repaving A2336 &red Rawstrudion A2337 UmalkRepl=cul(Cornplde) A2338 USI Pdtand I' veway (Complde) A2339 PWTahnokgy A2350 RunwayIMamwayBwoMacking(Conpkic) A2351 Runway 05-23 Rdu6 A2332 Corauvbus ResporwGrml A2353 NmgrDORceln Iso mts A2360 Sw l0mmaww'C7alVals A2161 SWBulldna(Complae) A2362 416l; A2363 Can!Wordim A2364 &onmrap Drakagelmpmvmwns TOTAL GRAND TOTAI, CRY OF SEBASTIAN CAPITAL PROJECT STATUS REPORT AS OF SEPT 30, 2023 Budget Share Project Budget Sources (in Thousands 0 Budget DST 0 DST 76.1 DST 14.6 DST 50 DST 40 DST 26 DST 5122 DST 78.6 DST 60S DST 310 DST 200 DST 27.9 FERIA .. U. FEMA 0 DONfjF 13.1150 JAGM,F 1211 DST 25 GF 563 GF 20 PIT 35 RIF 16 CRA 15 DEO 70 DST 74 DEP 120 OF IS GF 75 GF 113 DST 159 DST IL DST 185 DST 200 LOGT 600 LOGE 250 LOGT 29 DST 480.1 DST 7.7 FDOTIAP 3452.6 FAATDOTIDST 3,0671170.41110.4 FAA 13 FDOTDON 3269 DST 150 DST 137 DST 329.8 FEMAIDSr I1.00500 FEMAIDST 1,31,824 76,109 14,626 50,077 40,000 26037 512,200 7083 K775 310,o00 20&0D 27,940 Current Prior Year Year Expenditures Expenditures 66,100 13,150 2,493 *781 20,010 35,000 15,974 15,ODO 1000 73,591 120,000 15,000 75,000 11560 159,000 122,000 185,0D 20DI000 60QOD0 M,ODD 2,958 480,105 7,667 43,179 3,407,645 13,000 400,00 150,000 136,976 329,186 I15(q,000 2,941,591 $ 22y14,802 S $ 45,656582 $ Page 2 of 2 39,161 14,625 21,291 31,121 26036 7&583 14,ODO 309,619 2% 27,940 56386 24,086 14945 13,150 4493 99 13,553 t,123 Tile 15,595 16,283 2,858 480,10E 43,179 31,122 5,430 136976 49,061 Expenditures Percent Funds To Date Expended Encumbrances Remaining 39.161 14,625 21293 31,121 26,036 78583 14,ODO 309,619 2% 27,940 56,386 24,086 12,945 13,150 4493 99 13553 L123 70,000 15595 16283 2,858 480,105 43,179 31,122 5,430 136976 49,061 10689t - 160,894 1,699,OII S - S 1,699,011 3547,645 S 15,946,775 S 19,494,420 (IM 51 AS% Io0.00% 42.52% 77.0. law/. O.M. 10600'/, 23.04'% 99.98'b 0.15'% RIM (IM 000% 100.00'/e 100.9U/, 0.1w, 67.177, 0.00% 13A,, UK. 100.(D% 21.19Y, 13.57% 0.00'/1 0.00'/, 00P/, ar/. a011% nor. (I00°/, 0.(D% ON/. 99.99% 100.00% 0.00'/, 100.00% 0.91% 41.7P/, 600°/, 0.00,11. law/, 14. M uw/. 5.4P/a 7./1% S 42.70% S 36947 - I 2&784 8.879 I 42&958 83242 164,250 31,930 56,781 46,775 381 35,454 (56586) (24,086) 21,205 (99) 6447 35,OW 13,851 15,0D 54,005 3,991 103,718 15,000 75,ODD - II,S60 IS&2I9 781 12l543 457 184,m0 50) 2%010 600,000 250,00 7,667 0 3576484 39 7570 400,000 150,03D 280,725 11,300,000 2,78&698 7,461,105 7,106499 13,754,696 1&455,663 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 Geneml Food $ 6,446,99135 American Rescue Plan Act 2,464,920.93 Local Option Gas Tax Food 1,079,25528 Discretionary Sales Tax Fund 3593,799.03 River6ont Redevelopment Fund 756-111.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 Stonnwatu Projects Fund Golfcoursc road Airport Food Airpon Projects Food Building Department Fund CemeleN Trust Fund Performance Deposits Food 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 S Purpose 330,356.13 1,613,111.92 44,742.26 (147,336.23) 5425535 (0.10) (155529.68) 37,002.06 474,512.09 89,192.30 1,483208.19 376,87124 90,750.00 18,832,313.28 PERCENT 3423% 13.09 % 5.73 % 19.08% 4.02% 0.00% 1.75% 8.57% 0.24% 0.00% .0.78% 029% 0.00% -0.83% 020% 2.52% 0.47% 7.88% 3.06% 0.48% R00 % STATE BOARD OF ADMINISTRATION ISBA) CURRENT INVESTMENT ALLOCATION BALANCE General Fund S 1223,218.77 American Rescue Plan Act 436,616.88 Local Option Gas Tax Fund 190,78128 Discretionary Sales Tax Fund 633,952.88 Riverfmnl Redevelopment Fund 133,54412 Parking In -Lieu Of Fund 97,432.74 Recreation Impact Fee Fund 59I65.13 Slormwater Utility Fund 283,575.77 Law Enforcement Forfeiture Food 7,910.90 Slormwater Stares 2003 Debt Service Fund Capital Projects Fund Capital Improvements Fund Transportation Fund Stormwater Projects Food Golf Course Fund Airport Fund Airport Projects Fund Building Department Fund Cemetery Trust Fund Performance Deposits Fund Total SBA Balance INTERFUND LOANS REPORT 111.134.75 83,632.76 261,602.66 577.719.78 2,340.00 5 4.101.628.52 10/01/22 Scheduled Balance at Balance Payments 09/30/2023 Remarks/Terms Cash Flow Loan $465,000 $35,000 $295,000 Hangar A $253,171 $7,873 $267,511 Hangar 8 $249,575 $8,517 $700,000 Irrigation $553,159 $31,352 $559,694 Other Repairs $559,684 None $430,000 Pay$35K/Year or More. PERCENI' 29.82oo 10 64% 4.65% I5.46^, '-6', 2.38' J_ 691" 0.19% 0.00% 0.00% 0.00% 0.00% 0.00"% 2,71 % 2.04% 0M-6 6,38% 14.09% n nev.. $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. $522,611 Each 5 Years to T-Bond Minus 1%. Final in 2038. $559,684 Pay When Possible, Maybe After $700,000 is paid. To: Mayor and City Council Thru: Brian Benton, City Manager From: Kenneth W. Killgore, Finance Director Date: February 29, 2024 Re: Fiscal Year 2023 4" Quarter Accomplishments The following are the 4" Quarter Accomplishments for City Departments as assembled and edited by the Finance Department for the three months ended September 30, 2023. CITY CLERK Legislative Smwort Matters • City Clerk prepared agenda, attended/recorded six Regular City Council meetings, one special meeting • Completed follow up of approved Council matters — contracts, letter;, 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 Citv 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 Cemetery 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 Communitv 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 P 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 Sheriffs Association meeting. • Participated in July 4" 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 8d' 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 0 4 0 0 276 0 47 0 1 1 16 157 8 53 0 1 3 13 0 0 109 0 6 4 29 433 8 Life Skills classes taught Reports Crossing Guard contacts Mentor lunches Patrol Hours Communty event hours Communty event hours ■ Road Patrol Coverage Mentors lunches � Sept Crossing Guard contacts ■ Aug Reports ■ July Life Skills classes taught Area/school checks PW 0 50 100 150 200 250 300 Road Patrol and Soecial Operations • 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. Special Operations Citations Warnings Incident Reports Arrests Marine & Natural Resources* 0 0 0 0 *The Marine/Natural Resources unit is not a 11-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 July August September Totals 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 r Supplements Inactive Cases Cleared Cases ■ Series4 Assigned Cases 11116 Active Cases MEW— ■ Series3 Follow -Ups NlMMpr-- Training/Meeting Hours Warrants Arrests Subpoenas x 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 ■ Series2 ■ Series 50 100 July August Septembe.Totals 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 Inactive Cases Cleared Cases Other Intel Source Crime Stoppers Intel Officer Intel Active Cases Follow -Ups Training/Meeting Hours Warrants Arrests Court Order Documents C t I I O 20 40 60 80 100 COPE QUARTERLY REPORT ARRESTS WARRANTS i kNfMr46)(0El!FeINGS (hours) FOLLOW-UPS ACTIVE CASES pS$ISr�EQ CASES CLEARED CASES IIVAL"I'ftit' GAStS SUPPLEMENTS SURVc nZL i4Z6 (HOURS) 6 3 7 5 1 1 10 18 COMMUNITY EVENTS (man-hours) AGENCY OUTREACH EVENTS (man-hours) COMMUNITY MEETINGS (man-hours) SCHOOL RELATED EVENTS (man-hours) PUBLIC TRAINING CLASSES Iman-hours) REGIONAL OUTREACH (man-hours) PROBLEM ORIENTED POLICING (man-hours) PUBLIC SAFETY CADET ACTIVITIES (man-hours) TRAINING SCHOOLS (man-hours) IN-SERVICE TRAINING (man-hours) SOCIAL MEDIA MANAGEMENT (man-hours) ADMINISTRATION & RESEARCH (man-hours) ROAD PATROL COVERAGE (man-hours) MARINE PATROL & NATURAL RESOURCES (man-hours) MARINE PATROL & NATURAL RESOURCES (arrests) MARINE PATROL & NATURAL RESOURCES (citations/criminal & non) MARINE PATROL & NATURAL RESOURCES (warnings) MARINE PATROL & NATURAL RESOURCES (vessel stops) SCHOOL RESOURCE COVERAGE (man-hours) m Sep. M Aug. I• Jul. 0rza 3 2 6 3 2 6 6 8 20 5 3 11 5 4 16 3 5 13 3 1 5 0 0 1 5 5 20 10 8 36 August September TotalsJuly 8 22 32 62 0 30 0 30 4 2 2 8 0 0 2 2 0 0 0 0 0 0 0 0 0 0 6 6 8 8 8 24 0 0 4 4 0 0 42 42 4 3 4 11 29 20 19 68 0 0 0 0 24 0 0 24 0 0 0 0 0 0 0 0 1 5 0 0 5 15 0 0 15 0 208 244 452 5 Communications Division I Code Enf. Initiated Calls Calls Entered Into CAD I 911 Calls Received 911 Calls Transferred Out 911 Hang-up Calls Admin. Calls Received I Trainine/Meetine Hours 1,595 1,475 1,329 4,399 1,023 1,024 974 3,021 246 733 1,327 2,306 760 913 718 2,391 2,049 2,683 3,053 12,293 853 743 674 2,308 354 346 319 1,009 87 66 58 211 2,191 2,371 2,220 6,963 N/A N/A N/A N/A N/A N/A N/A N/A 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 911 Calls Received Calls Entered Into CAD Volunteer Initiated Calls Code Enf. Initiated Calls Officer Initiated Calls Disp. Calls For Service Crime Scene/Evidence 00=6 Items Received Evidence Processed In-house Evidence Outsourced Items Returned Items Purged Cars Impounded Video Redaction Hours Videos downloaded/sent CD's used Supplements Written Evidence Processing Hours Crime Scene Processing Hours Training Hours Call Outs Fingerprints State Attorney Requests ■ Month 3 ■ Month 2 ■ Month 1 3,000 4,000 August SeptemberJuly 176 96 79 351 9 3 12 24 15 14 4 33 25 29 15 69 10 2 1 13 0 0 0 0 40 0 44 88 260 348 311 919 32 34 42 108 2 1 1 4 5 10 11 26 8 12 4 24 40 4 0 44 2 2 1 5 5 8 9 22 91 94 79 264 g Fingerprints I Training Hours Evidence Processing Hours CD's used Video Redaction Hours Items Purged Evidence Outsourced Items Received ■ 3 50 100 150 200 250 300 350 400 Code Enforcement It lachini on anoroved leave Julv 1" throuah Auaust 210. ■ Sept ■ 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 4" 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. 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 %: 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 with 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 CleanSpace 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) Sign Shoo • 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 Cemetery • Routine Mowing/Weed Eating and Edging • Added 3 sprinklers to unit I, 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 U Construction Suecialist • 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 Manaeement: • 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.8lper gallon of diesel fuel 15.75% • $3.44 per gallon of dyed diesel 17.50% 10 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 Milt 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 AP 10-AP08 sign boards • Serviced cleaned gates and key pads • Blow debris off runways and taxis ways BUELDING JUND • In the 4 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 3d 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 4 ° quarter. Over all permitting is average for this fiscal year. • Total number of inspections for the 4" quarter was 3632 for an average of 66 building inspections per working day. The number of inspections for the 4" quarter stayed roughly the same as the 2nd and 3r° quarters. • The number of Certificates of Occupancy issued for the 4 ° 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 4" quarter: new businesses-39, renewals441, 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 4" 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 Citizen Reauest 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 l l(.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. A 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 Tvoe 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 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 II SEBASTIAN Emrau CITY COUNCIL AGENDA TRANSMITTAL FORM COUNCIL MEETING DATE: March 20, 2024 AGENDA ITEM TITLE: Resolution Accepting the 4"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 Expenditure 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 Exhibit "A" 2. 4 h Quarter Financial Report, with Capital Project Status, Investments/Loans and Accomplishments Finance Department Review: City Attorney Review: , (' Procurement Division Revs /, if applicable: City Manager Authorization: r Date: --JI i o ly