AGENDA    OF HOPEL  CITY OF HOPEWELL Hopewell, Virginia 23860 AGENDA (804)541-2408 www.hopewelvagoy into@hopewelvagoy clyeleik@hopewelvagor SPECIAL MEETING  CITY COUNCIL John B.Partin, Jr., Mayor,) Ward! #3 Jasmine E. Gore, Vicel Mayor, Ward #4 Rita. Joyner, Councilor, Ward #1 Michael B. Harris, Councilor, Ward #2 Janicel B.I Denton, Councilor, Wardi #5 Brenda S.I Pelham, Councilor, Ward# #6 Dominic! R. Holloway, Sr,Councilor, Ward#7 Dr. Concetta Manker, City Manager Beverly Burton, Interim City Attorney Brittani Williams, City Clerk  ALTM oV  Closed Meeting- 6:00 PM Open Meeting: 7:00PM  October 15, 2024 6:00 p.m.  Call to order, roll call, and welcome to visitors  SPECIALMEETING CLOSED MEETING  SUGGESTED MOTION: Move to go into closed meeting pursuant to Va. Code Section $2.2-3711 (A) (I) to discuss and consider personnel matters, including board and commission appointments; the assignment and performance of specific appointee and employees of City Council, and to the extent such discussion will  be aided thereby  RECONVENE OPENMEETING  CERTIFICATION PURSUANT TO VIRGINIA CODE $2.2-3712 (D): Were only public business matters (I) lawfully exempted from Permetingreguirements and (2)i identifiedin  the closed-meeting motion discussed in closed meeting?  Regular Business  R-1-1 Finance Committee Report - CFO - Stacy Jordan, Finance Director  Adjournment    CLOSED MEETING    RECONVENE OPEN MEETING    REGULAR BUSINESS    R-1    Finance Committee  Meeting  CITY MANAGER: DR. CONCETTA MANKER PRESENTED BY: STACEY JORDAN, CFO  CITYOF HOPEWELL FINANCE COMMITTEE    AGENDA  "Minutes from last meeting "FY25 Budget to Actuals-19TQTR Citywide General Fund Enterprise Schools Departmental "FY25 Change in Fund Balance "1SQTR Overtime report by Department "1StQTR Collection report - Data Integrators  "Accounts Payable/Debt Service "HRW True-up Analysis "Marina  "FY24 Surplus of funds and allocation "Reports from COR and Treasurer "October committee items  CITYOF HOPEWELL FINANCE COMMITTEE    Citywide FY25 Budget to Actuals S-1STQTR  FY25 Citywide Revenues and Expenditures- Budget vs Actuals  City-wide for 1St QTR are trending 0.59% lower in revenues for FY25 VS FY24.  250,000,000 200,000,000 150,000,000 100,000,000 50,000,000  Expenses for 1st QTR are trending 0.74% lower for FY25  VS FY24.  Over all we are trending 8.79% or $19M less then where we should bei for 1st QTR, the City should be at  25% or $56.5M.  FY24REVISED FY24Actuals FY25 REVISED FY25 Actuals FY25 FY25YTD  BUDGET  BUDGET Revenue Expenditures  Adjustments Actuals Projected  CITY OF HOPEWELL FINANCE COMMITTEE    Citywide FY25 Budget to Actuals - 15TQTR  CmY-WIDE Dudget Rec'd BUDGET 0.094 5,100,000  REVENUES FY24 REVISED FY24A Actuals FY24 %of FY25 REVISED FY25 Actuals FY25 Actuals FY25) YTD FY25 %Rec'd  BUDGET  Adjustments Projected Projected 746,835 185,717 232,309 80,901 2,115,222 215,804 153,214 132,831 221,392 317,901 15,155,654 1,771,408 727,176 5,268,773  Comments  REALE ESTATE TAXES PUBLIC SERVICE CORP TAX 4,100,000 MACH& TOOL TAX PPTRA: STATE REIMBURSEMENT DTHER TAXES CHARGES FOR SERVICES PENALTIESSI INTEREST FINES &F FORFEITURES GRANTS STATE REVENUES FEDERAL REVENUES MISCELLANEOUS ENLIEU OF TAXES PEBT SERVICE TRANSFERSI IN TOTAL REVENUES SALARIES & WAGES HEALTHE BENEFITS EMPLOYEE BENEFITS RETIREMENT OTHER PERSONNEL WORKERS COMPENSATION SERVICES SUPPLIES DUTSIDE AGENCIES NON-DEPARTMENTAL OTHER ÇAPITAL DEET SUPPORT OF SCHOOLS TRANSFERSOUT TOTAL NELINCOME  20,979,167 491,084 2.394 21,928,970 746,835 8,783,500 62,869 0.794 9,586,049 232,309 1,618,030 80,901 5.09 1,618,030 80,901 10,110,000 2,188,778 21.6% 10,840,000 2,115,222 40,058,208 6,991,686 17.59 48,869,033 6,209,535 2,500,000 8,709,535 488,500 158,847 32.59 555,000 153,214 860,500 326,955 38.098 1,235,500 221,392 139,500 21,000 15.19 93,560 317,901 54,722,975 11,156,219 20.494 61,828,523 15,155,654 20,809,536 7,799,481 37.5% 15,755,067 1,771,408 13,470,176 280,323 2.1% 5,169,644 727,176 1,591,511 397,878 25.094 1,591,511 370,044 27,834 397,878 1,120,526 280,131 25.0%6 947,617 157,936 78,968 236,904 29,933,944 5,174,336 17.3% 32,992,615 5,268,773 215,048,473 36,132,655 16.80% 226,198,769 34,063,651 2,606,802 36,670,454 FY24 REVISED FV24A Actuals Fv24%of REVISED FY25 FY25 Actuals FY25 Actuals FV25YTD FY25 %Rec'd 29,613,596 5,814,868 19.6% 30,585,483 6,078,529 4,961,744 1,107,195 22.3% 5,292,748 1,196,436 365,097 76,032 20.796 428,665 57,941 4,184,354 876,108 20.999 4,288,833 940,602 2,391,390 479,025 20.094 2,461,404 505,224 509,172 111,863 22.0%4 513,671 109,352 34,930,395 7,199,741 20.69 37,619,588 5,559,795 5,823,349 1,238,743 21.394 5,567,748 1,211,440 1,283,888 315,207 24.696 1,277,908 314,375 69,256,600 18,307,705 26.494 72,150,332 68,927 18,380,157 18,449,083 21,686,523 1,112,208 5.19 11,244,117 308,515 265,563 575,078 7,428,083 3,305,487 44.5% 7,418,450 3,335,663 13,580,000 3,395,000 25.09 13,865,900 3,427,500 15,344,944 1,527,086 10.0% 18,117,715 1,589,023 227,102,770 47,938,614 21.17% 226,198,783 27,437,930 18,646,720 66,084,650 (12,054.297) (31405.960) 4.314 (14)  3.49 Increase duetos pasto duec collections 0.0945 Duein Maya 2.699 Due February and) June 2.494 in. Duel June 5.094 Consistent 19.594 Decrease duet to othert taxest toi include 40.796 Decreased due to Interest! 17.8% Adjustment duet tol latel HRW Income 26.194 Slight decreasefor collections billing ($2.5M). 28.294 17.99 Varlable Variable Revenues Revenues slight slight decrease decrease 339.894 Increased 24.596 Schoolsf funding duetosWG Grantr received 11.2% Decreasec duet to ARPAIn FY24 14.1% to 25.0% duet $452.5k HWRI Misc. Credits 25.0945 Consistent Decreasein HRW 16.0% Slighti Increasef for Debt transfert obligation tof funds 16.219) Projected 19.9% 22.696 13.5% 21.9% 20.694 17.8% 21.3%4 14.8% 21.89 24.694 25695183EMSaolsane OperationalDapenses 5.1%pending FY24 Reclasst totalings266,563fork 45.096 24.7% 8.894 20.4% 4.16%  PERSONAL PROPERTY TAX 5,636,800 271,243 4.8% 7,056,000 186,717 USEOF MONEY& PROPERTY 340,000 315,436 92.8% 530,200 215,804 PERMITS, FEES ANDL LICENSES 285,600 135,486 47.499 470,450 132,831  (BL, VL, Communication,' Recordation, Food, Lodging, Meals, et)  BUDGET  Dudget Reca BUDGET  Adjustments Projected 6,078,529 1,196,436 57,941 940,602 505,224 2,733,609 109,352 5,559,795 1,211,440 314,375 3,335,663 3,427,500 1,589,023 (16.032.917) (9414.196)  PROFESSIONAL: SERVICES 15,740,635 3,072,346 19.5%4 15,366,221 2,733,609  CITY OF HOPEWELL FINANCE COMMITTEE    General Fund FY25 Budget to Actuals - 1ST QTR  FY25 General Fund Revenue and Expenditures  General fund for 15t QTR is trending 1.61% or $400K lower in Expenses for FY25 are trending 1.6% or $320K higher than Same concept applies for General fund the City should be at roughly 25% or $17M revenues received. The key due dates for the City are Dec, Feb and. June.  Revenues for FY25 VS FY24  80,000,000 70,000,000 60,000,000 50,000,000 40,000,000 30,000,000 20,000,000 10,000,000  FY24  FY24F REVISED FY24Actuals FY25 REVISED FY25 Actuals FY25YTDAct  BUDGET  BUDGET Revenue Expenditures  Projecte  CITY OF HOPEWELL FINANCE COMMITTEE    General Fund FY25 Budget to Actuals- - 1ST QTR  GENERAL FUND F24%ofBudget Rec'd FY25REVISED! BUDGET FY25A Actuals 2.3%4 21,928,970 0.094 5,100,000 4.894 7,056,000 0.794 9,586,049 5.094 1,618,030 18.094 7,240,000 44.798 90,000 48.5% 847,000 31.994 581,000 47.494 470,450 37.2%4 1,235,500 21.49 9,196,100 115.9% 350,000 31.894 1,201,453 25.094 1,257,500 25.0% 1,009,000 11.30% 68,767,052 19.794 20,844,331 22.794 3,755,712 21.994 306,449 20.794 2,942,005 20.1%4 1,684,767 33.4% 4,898,051 22.49 430,846 23.9% 5,765,220 24.594 4,924,213 3,0% 20,408 57.9% 561,394 37.394 226,975 25.094 13,865,900 25.0% 8,540,791 23.2% 68,767,062 -11.94% (10)  FY25Y YTDActuals Projected 746,835 186,717 232,309 80,901 1,097,199 37,321 466,714 151,448 132,831 218,784 2,483,103 43,958 216,130 314,375 252,250 6,660,875 Fr25YTDActuals Projected 4,160,355 865,677 43,456 639,886 345,904 1,580,235 92,572 832,972 1,211,440 26,998 30,560 3,427,500 1,589,023 14,846,579 ($,185,704)  FY25%Rec'd Projected 3.4% 0.0% 2.6% 2.4% 5.094 15.29 41.5% 55.194 26.1% 28.294 17.794 27.0% 12.6% 18.094 25.0% 25.0% 9.699 FY25%Rec'd Projected 20.0% 23.0% 14.2% 21.7% 20.5% 32.3% 21.5% 14.494 24.69 0.094 4.8% 13.5% 24.7% 18.6% 21.69 -11.909  REVENUES REAL ESTATE TAXES PUBLIC SERVICE CORP TAX PERSONALI PROPERTYT TAX MACH&T TOOL TAX PPTRASTATE! REIMBURSEMENT OTHERT TAXES USE OFI MONEY & PROPERTY CHARGES FORS SERVICES PENALTIES & INTEREST PERMITS, FEES ANDLICENSES FINES & FORFEITURES GRANTS STATE REVENUES FEDERAL REVENUES MISCELLANEOUS REVENUE INL LIEU OF1 TAXES TRANSFERSIN TOTAL REVENUES EXPENDITURES SALARIES& WAGES HEALTHE BENEFITS EMPLOYEE BENEFITS RETIREMENT OTHER PERSONNEL PROFESSIONAL SERVICES WORKERS COMPENSATION SERVICE & SUPPLIES DUTSIDE AGENCIES NON-DEPARTMENTAL OTHER CAPITAL SUPPORT OF SCHOOLS TRANSFERS OUT TOTAL EXPENDITURES NETI INCOME  FY24REVISEDI BUDGET FY24Actuals 20,979,167 4,100,000 5,636,800 8,783,500 1,618,030 6,560,000 65,000 677,500 487,500 285,600 860,500 8,194,190 1,251,000 748,506 1,257,500 1,009,000 62,513,793 20,248,699 3,554,597 251,749 2,885,871 1,628,553 3,554,297 429,097 4,822,911 5,041,189 27,890 72,098 308,502 13,580,000 6,108,345 62,513,798 (5)  491,084 271,243 62,869 80,901 1,182,397 29,076 328,788 155,371 135,486 319,862 1,749,742 1,449,834 238,074 314,375 252,250 7,061,352 3,983,610 806,982 55,030 598,201 327,745 1,188,269 96,164 1,153,057 1,237,256 832 41,709 115,177 3,395,000 1,527,086 14,526,120 (7,464,767)  746,835 186,717 232,309 80,901 1,097,199 37,321 466,714 151,448 132,831 218,784 2,483,103 43,958 216,130 314,375 252,250 6,660,875 4,160,355 865,677 43,456 639,886 345,904 1,580,235 92,572 832,972 1,211,440 26,998 30,560 3,427,500 1,589,023 14,846,579 (8,185,704)  PI23REVSEDBUDGET FY24Actuals FY23%Used F24REVSEDBUDGET FY25Actuals  CITY OF HOPEWELL FINANCE COMMITTEE    Enterprise Fund FY25 Budget to Actuals - 1ST QTR  Regional Water, Sewer, Solid Waste, andStorm Water  FY25 Enterprise Funds Revenue and Expenditures  Enterprise fund for 1st QTR is trending 1.97% or $2.4M higher in Revenues for FY25 VS FY24. Expense for FY25 are trending 6.3% or $1.8M less the Same concept applies for Enterprise fund the City should be at roughly 25% or $13.3M revenues received.  60,000,000 50,000,000 40,000,000 30,000,000 20,000,000 10,000,000  expense in FY24.  FY24REVISED FY24.Actuals FY25REVISED FY25 Actuals FY25YTD  BUDGET  BUDGET Revenue Expenditures  Actuals- Projected  CITY OF HOPEWELL FINANCE COMMITTEE    Enterprise Fund FY25 Budget to Actual - 1ST QTR  ENTERPRISE FUNDS  FY25YTD Actuals FY25% 100,715 100,715 33.6% 18.5% $2.5MLate. 504,112 504,112 101.7% $452.5k HWR Misc. Credits 254,771 254,771 55,669 83,503 25.0% $27.8K Late August 157,936 236,904 25.0% $78.9K Late August Billing  FYZ4REVISED 235,000 34,182,403 15,000 334,011 1,120,526 9,236,599 45,123,539 FY24REVISED 4,491,662 640,213 75,920 624,982 354,748 8,962,314 50,674 11,332,597 6,000 1,257,500 61,400 5,440,284 2,588,642 9,236,599 45,123,535 8,501,300 4 (3,734,150) -3.84%  FV25 REVISED 83.9% 300,000 19.3% 495,564 25.0% 334,011 25.0% 947,617 0.0% 8,672,924 FV25 REVISED 19.1% 4,731,824 20.1% 713,300 17.5% 82,731 19.6% 642,777 20.0% 364,449 21.7% 53,697 12.6% 5,000 25.0% 1,257,500 16.4% 61,400 2.0% 9,382,755 25.0% 2,583,988 0.0% 9,576,924  REVENUES USE OF MONEY: & PROPERTY CHARGES FOR: SERVICES MISCELLANEOUS GRANTS INI LIEUOF TAXES DEBT: SERVICE TRANSFERSIN TOTAL REVENUES EXPENDITURES SALARIES & WAGES HEALTH BENEFITS EMPLOYEE BENEFITS RETIREMENT OTHER PERSONNEL PROFESSIONAL: SERVICES WORKERS COMPENSATION SERVICE &: SUPPLIES OUTSIDE. AGENCIES NON-DEPARIMENTAL OTHER CAPITAL DEBT TRANSFERS OUT TOTAL EXPENDITURES NET! INCOME  BUDGET FY24 Actuals FY249Rec'd BUDGET FY25 Actuals Projected Rec'd  Comments August Billing Billing  197,167 5,948,676 2,902 254,771 -- 83,503 280,131  17.4% 42,367,151 5,333,948 7,833,948  REVENUE  0.0%  6,767,150 15.00% 53,117,267 6,407,150 9,013,952 16.97%  FY25VTD Actuals FY25% 936,993 19.8% 149,730 21.0% 7,096 8.6% 142,410 22.2% 77,746 21.3% 12,026 22.4% 22.7% 0.0% 314,375 25.0% 14,262 23.2% 189,890 2.0% 644,623 24.9% 0.0% 12.5%  BUDGET FY24 Actuals FY24%F Rec'd BUDGET FY25 Actuals Projected Rec'd  856,532 128,646 13,315 122,493 71,117 1,812,010 10,979 4,406,284 758 314,375 10,054 106,859 647,878  936,993 149,730 7,096 142,410 77,746 12,026 314,375 14,262 189,890 644,623  20.2% 10,070,864 1,079,343 1,079,343 10.7% 38.9% 13,590,060 3,082,405 3,082,405  18.8% 53,117,269 6,650,899 6,650,899  (2) (243,749) 2,363,053 4.45%  CITY OF HOPEWELL FINANCE COMMITTEE    Schools FY25 Budget to Actual - 1ST QTR  Schools is trending 2.74% or $1.3M less in revenues for FY25 VS  FY25 Schools Revenue and Expenditures  FY24  80,000,000 70,000,000 60,000,000 50,000,000 40,000,000 30,000,000 20,000,000 10,000,000  Expenses are trending 0.87% or $148K more in FY25 VS FY24 Same concept applies for Schools the Schools should be at 25%  or $18M revenues received.  FY24REVISED FY24.Actuals FY25REVISED FY25 Actuals FY25YTD  BUDGET  BUDGET Revenue mExpenditures  Actuals Projected  CITY OF HOPEWELL FINANCE COMMITTEE    Schools FY25 Budget to Actuals - 1ST QTR  SCHOOLS  FY25YTD Actuals FY25% 334,220  FY24REVISED 5,023,384 39,351,282 13,980,744 13,580,000 FY24REVISED 3,072,226 47,180  FY24% FY25REVISED 659,699 13.1% 5,515,232 334,220  REVENUES CHARGESI FORSERVICES STATE REVENUES FEDERAL REVENUES TRANSFERS IN TOTAL REVENUES  BUDGET FY24Actuals Rec'd BUDGET FY25Actuals Projected Rec'd  Comments  6.1%  8,682,514 22.1% 46,085,993 10,196,829 10,196,829 22.1% 4,258,909 30.5% 9,643,588 1,727,450 1,727,450 17.9% 3,395,000 25.0% 13,865,900 3,427,500 3,427,500 24.7%  71,935,410 16,996,122 23.63% 75,110,713 15,686,000 15,686,000 20.88% BUDGET FY24Actuals Rec'd BUDGET FY25Actuals Projected Rec'd  FY25YTD Actuals FY25%  FY24% FY25REVISED 0.0% 3,716,420 0.0% 47,180  EXPENDITURES SERVICE&SUPPUES OTHER CAPITAL TOTAL EXPENDITURES NET INCOME  0.0% 0.0%  68,816,004 18,232,513 26.5% 71,347,113 71,935,410 18,232,513 25.3% 75,110,713  18,380,157 25.8% Q1 Operational Expenditures  18,380,157 24.47% 15,686,000 (2,694,157) -3.59%  (1,236,391) -1.72%  CITY OF HOPEWELL FINANCE COMMITTEE  10    FY25 Department Budget to Actual - 1StQTR  DEPARTMENT ACCOUNTING ASSESSOR CIRCUIT COURT CITY ATTORNEY CITY CLERK CITY MANAGER COMMISSION OFF REVENUE COMMONWEALTH, ATTORNEY COUNCIL COURT SERVICES CSA ECONOMIC DEVELOPMENT FIRE/EMS GENERAL COURT GOVERNMENT AFFAIRS HEALTHY FAMILIES HRW HUMAN RESOURCES INFORMATION TECHNOLOGY LAW LIBRARY MARINA PLANNING POLICE PUBLICWORKS RECREATION REFUSE SEWER SHERIFF SOCIAL SERVICES STORMWATER TREASURER MCTIM WITNESS MICCCA VOTER REGISTRAR TOTALS  FY25 ADOPTED YTD BUDGET BUDGET %OF BUDGET YTD ONT TREND  BUDGET  AMOUNT- REMAINING  COMMENTS  S 2,089,595 S 387,800 > 1,842,209 S 503,455 $ 58,958 S 419,409 S 752,163 $ 146,924 S 605,239 $ 413,930 s 61,990 S 342,564 s 179,066 s 38,038 S 140,731 $ 1,110,931 s 476,953 S 628,956 S 732,599 $ 137,233 $ 594,664 $ 1,065,315 s 239,900 S 825,042 S 254,861 S 27,018 S 226,430 S 7,000 $ 540 S 6,446 S 3,888,429 $ 245,517 S 1,556,884 s 803,765 s 123,321 S 640,376 $ 6,701,199 s 1,290,918 $ 5,803,810 S 147,472 S 21,548 S 126,438 $ 152,746 $ 21,594 S 131,094 S 482,908 S 123,306 $ 359,415 S 29,482,650 s 4,247,748 $ 16,020,669 s 765,866 $ 156,620 $ 556,571 $ 1,916,236 s 582,075 $ 1,228,720 $ 11,550 $ 1,895 S 9,655 $ 100,200 $ 70,648 s 11,559 S 1,437,546 $ 369,824 s 1,089,739 S 10,713,977 $ 2,399,527 S 8,131,550 S 11,320,960 S 1,656,257 $ 9,291,710 S 3,688,654 s 418,895 $ 695,652 S 7,336,553 s 1,384,001 $ 5,074,592 $ 2,262,891 $ 432,935 $ 1,779,835 S 7,195,330 $ 1,521,922 $ 5,670,504 S 914,000 $ 189,225 $ 1,159,184 $ 725,642 $ 132,633 S 591,156 $ 165,057 s 37,655 S 139,826 $ 177,663 $ 21,847 s 154,216 423,466 S 81,828 S 297,083 100,265,326 $17,601,639 $68,019,096  19% TRUE 12% TRUE 20% TRUE 15% TRUE 21% TRUE 43% FALSE 19% TRUE 23% TRUE 11% TRUE 8% TRUE 6% TRUE 15% TRUE 19% TRUE 15% TRUE 14% TRUE 26% FALSE 14% TRUE 20% TRUE 30% FALSE 16% TRUE 71% FALSE 26% FALSE 22% TRUE 15% TRUE 21% TRUE 11% TRUE 19% TRUE 19% TRUE 21% TRUE 21% TRUE 18% TRUE 23% TRUE 12% TRUE 19% TRUE 18% TRUE  RBGC Consultants  Dues &s Subscriptions, Benefits Prepaid: andy Yearly contracts Repairs & Utilities Code- Uniforms, Vechicle leases, Service Contracts  S 2,341,650  494,544 $ 1,867,166  CITY OF HOPEWELL FINANCE COMMITTEE  11    FY25 Change in Fund Balance  CITYOFH HOPEWELL, VIRGINIA FORF PERIODE ENDING: 09.30.2024 FUND FUND DESCRIPTION 003 PERPETUAL CARE FUND 011 GENERAL FUND 012 SOCIAL SERVICES 030 REFUSE 032 HRWTF 035 RECREATION 038 MARINA 040 SEWER OPERATIONS 041 SEWER MAINTENANCE 042 SEWER IMPROVEMENT 043 SEWER BOND 044 SEWER SYSTEME RATE FUND 048 STORM WATER1 049 STORM WATER2 52 GRANTS 053 ANTI-LITTER 070 DEBTS SERVICES 071 CAPITAL PROJECTS ANDO DEBT 073 SPECIAL WELFARE 074 POLICE SEIZURE ASSETS 075 ECONOMIC DEVELOPMENT 076 SELF INSURANCE 090 HEALTHY FAMILIES TOTAL NOTES: 1.Preliminary Fund Balance numberst taken from FY24 ending  OF REVENUES, EXPENDITURES AND CHANGE INFUNDE BALANCE  0=p positive R/E FUND BALANCE END (8,565.42) (57,159.17) 19,667.60 396,261.08  REVENUES DUDGET CURRENT VTD REMAINING (60,000.00) (12,891.57)  EXPENSES  BUDGET CURRENTYTD REMAINING PRELIMINARY DEG CHANGE  (47,108.43) 60,000.00 S 4,326.15  55,673.85 (48,593.75)  (69,767,052.00)  (6,650,874.68) $ (62,106,177.32) 68,767,062.00 $14,846,578.70 53,920,483.30 $/11,102,210.90) $,185,704.02 (2,916,506.88) (3,688, 654.00) (226,973.83) $ (3,461,680.17) 3,688,655.00 418,895.11 3,269,759.89 1,136,180.01 191,921.28 1,328,101.29 $ (29,482,650.00) $ (4,568,001.93) S_(24.914,648.07) 29,482,650.00 4,247,747.87 25,234,902.13 5,645,747.60 (320,254.06) 5,325,493.54 (2,243,363.00). (569,117.89) (1,674,245.11) 2,243,365.00 424,821.47 1,818,543.53 (363,198.26) (144,296.42) (507,494.68) (7,336,553.00) (52,505.75) (7,284,047.25) 7,336,553.00 1,384,000.90 5,952,552.10 6,772,380.79 1,331,495.15 $,103,875.94  > (7,195,3 330.00) (1,502,254.66) (5,693,075.34) 7,195,329.00 S 1,521,922.26 5,673,406.74 376,593.48  015 COMPREHENSIVE SERVICESACT (3,888,430.00) (1,406,704.87) (2,481,725.13) 3,888,430.00 5 245,516.85 3,642,913.15 748,874.58 (1,161,188.02) (412,313.44)  (100, 200.00) (58,224.98) (1,635,371.00) (10,000.00) (906,171.00) (2,053.00) (156,606.00)  (41,975.02) 100,200.00 70,648.32  29,551.68  30.35  12,423.34 12,453.69  (8,672,925.00) (1,160,204.80) (7,512,720.20) S 8,672,924.00  8,672,924.00 (6,307,932.28) (1,160,204.80) (7,468,137.08)  (10,895.03) (23,335.86) (158.20)  10,895.03 23,335.86 (9,841.80) 10,000.00 (2,482.00) (903,689.00) 906,172.00 (2,053.00) 19,502.77  (57,708.06) (10,895.03) (68,603.09) (123,604.08) (23,335.86) (146,939.94) 30,468.52 (178,849.02) (148,380.50) 403.50 2,841.80 (2,482.00) 1,405.78 2,275.00 (6,415.77) (41,368.12) 2,388.82 3 (39,041.34) (5,000.00) (11,000.00) (62,814.81)  (1,636,371.00) $ 1,636,371.00 $ 411,029.70 1,225,341.30 $ 1,592,942.14 411,029.70 2,003,971.84  2,290,114.00) (365,074.35) (1,925,039.65) 2,290,116.00 S 186,225.33 2,103,890.67  3,000.00 2,053.00 2,275.00  7,000.00 906,172.00 (185,565.78) (222.00)  3,245.30 (188,047.78) 3,681.78  (4,834,462.00) (1,289,013.30) (3.545,448.70) 4,834,462.00 2,691,039.78 5 2,143,422.22 610,986.97 1,402,026.48 $ 2,013,013.45 (8,182,377.00) (48,088.34) (8,134,288.66) 8,182,378.00 580,525.15 $ 7,601,852.85 1,371,981.13 532,436.81 S 1,904,417.94  (19,502.77)  13,087.00 (13,087.00) (34,952.35) 20,000.00  (2,611.18) (153,994.82) 156,606.00 5,000.00 151,606.00 (41,430.16)  (20,000.00) (5,000.00) (15,000.00) 20,000.00  (6,000.00)  (600,000.00) (150,000.00) (450,000.00) 600,000.00 150,000.00 450,000.00 (62,814.81) S $ (1,014,745.00) (243,735.77) (771,009.23) 1,014,744.00 231,290.37 783,453.63 347,880.87 (12,445.40) 335,435.47 (151,088,055.00) (16,377,651.76 (132,710,404.29) 151,086,070.00 $27,A37,929.96 123,650,140.04 301,866.29 9,060,278.20 9,362,144.49  CITY OF HOPEWELL FINANCE COMMITTEE  12    FY25 Overtime by Department - 1StQTR  DEPARTMENT Finance Fire HRW information' Technology Police Public Works Recreation Sewer Operations Sheriff Social Services Stormwater Treasurer Voter Registration Grand Total  FY25 BUDGET VTD ACTUALS REMAINING BALANCE %OFBUDGET ONTREND  COMMENTS VACANCIES VACANCIES VACANCIES  S 4,000.00 $  $  4,000.00 239,515.89 14,137.02 93,362.60 8,203.91 36,025.17 42,231.11 10,432.14 (1,197.18) (938.67) 5,000.00 898,638.37  0% 34% 31% 6% 48% 22% 3% 34% 25% 51% NULL 147% 0% 36%  TRUE FALSE FALSE TRUE FALSE TRUE TRUE FALSE TRUE FALSE FALSE FALSE TRUE  $ 385,000.00 $1 131,683.03 $ 253,316.97 $ 348,000.00 $ 108,484.11 $ $ 15,000.00 $ 862.98 $ $ 377,500.00 $ 1 182,950.59 $ 194,549.41 $ 119,400.00 $ 26,037.40 $ $ 8,500.00 $ 296.09 $ $ 55,000.00 $ 18,974.83 $ $ 56,000.00 $ 13,768.89 $ $ 21,240.00 $ 10,807.86 $ $ 2,000.00 $ 2,938.67 $ $ 5,000.00 S $1,396,640.00 $ 498,001.63 $  VACANCIES VACANCIES NOB BUDGET ESTABLISHED BRM: and other responsibilities  $ 1,197.18 $  $  CITY OF HOPEWELL FINANCE COMMITTEE  13    FY25 Data Integrators Collections - 1ST QTR  Uslltly Water/Sewer Collection! nate: July Account Designation Billed Collected Percentage Storm Water $ 64,933.70 $ 70,445.12 108% SolidV Waste $ 270,661.43 $ 241,208.98 89% Waste Water s 244,392.18 246,301.58 101% Total MTD $ 579,987.31 557,955.68 96% Utility Water/Sewer Collection Rate: August Account Designation Billed Collected Percentage Storm Water $ 66,697.54 $ 55,250.01 83% Solld Waste $ 274,666.31 S 224,317.21 82% Waste Water $ 256,101.96 204,410.72 80% Total MTD $ 597,465.81 S 483,977.94 81% Utillty Water/Sewer Collection! Rate: September Account Designation Billed Collected Percentage 64,033.05 $ 66,648.99 104% Solld Waste $ 269,745.04 $ 245,109.06 91% Waste Water $ 247,347.86 $ 219,700.28 89% Total MTD $ 581,125.95 S 531,458.33 91% Percentages In excess of 100: are duet toA Accounts billed In previous months butp paidi inc current month*.  UNillty Water/Spwer Collection Rate oTR-wlr-sgphemker Account Designation Billed Collected Percentage Storm Water $ 131,631.24 $ 125,695.13 95% Solid Waste $ 545,327.74 465,526.19 85% Waste Water $ 500,494.14 450,712.30 90% Total YTD $1,177,453.12 $ 1,041,933.62 88%  Storm Water  CITY OF HOPEWELL FINANCE COMMITTEE  14    FY25 Accounts Payable/Debt Service -1ST QTR  Accounts Payable 1st QTR Invoices Received  #ofi invoices processed $amount processed  2884 $13,561,543  Debt Service Payments 1St QTR  Description Bond Admin Fees INTEREST PAYMENT- INTEREST $ PRINCIPAL PAYMENT- DEBT $ Totals  FV25 Budget $ $  VTD Actuals Remaining Budget %of Budget VTD  14,250 $ 2,345,434 $ 776,143 $ 5,058,766 $ 2,557,870 $ 7,418,450 $ 3,335,663 $  1,650 $  12,600 1,556,824 2,500,896 4,070,320  11.58 33.09 50.56 44.96  CITY OF HOPEWELL FINANCE COMMITTEE  15    HRW True-up Analysis  HWR Cumulative ICredis)AmountDue Rolling Total Hopewell AdvanSix Ashland WestRock VAW Co Total  FY18 $42,175 $8,600 $933,574 ($9,726)  FY19  FY20  FY21  FY22  FY23  FY24  ($1,046,883) $1,617,746) ($3,821,798) ($4,524,136) 13025624151904229) ($1,342,786) ($2,216,687) ($3,431,733) ($3,788,989) 126549351161244950) $448,567 ($212,266) ($1,429,317) ($1,708,569) ($848,671) ($415,202) ($640,964) ($1,068,722) ($1,727,729) $1,715,024) ($1,110,133) ($435,035)  $1,467,777 ($956,666) ($1,411,837) ($2,950,599) ($2,195,201) $1,833,845 $5,439,864 $2,442,401 ($3,538,733) S6,527,258 ($13,361,177) 16159191911654055405519151740448  The above references the amount in credits 0 and amounts due + from the industry from FY18 through FY24. These figures are preliminary figures based on information  accessible by the Finance Department.  CITY OFH HOPEWELLF FINANCE COMMITTEE  16    Marina Revenue for Marina Vs expenses (before repairs)  Revenue for Marina vs expenses (afterr repairs)  Available Safe Slips tof Rent: Ldock- (closed uns safe) MI Dock- Lease spots MI Dock- Vistor Spots NI Dock- Lease Spots Ramp Fees ce Building Rental Marina Store Rental Food Truck Spot Rental Total Estimated Revenues Operating Expenses: EQUIPMENT REPAIRS SERVICE CONTRACTS VEHICLE MAINTENANCE ADVERTISING ELECTRICAL: SERVICES WATERA ANDS SEWER POSTAGE TELEPHONE/FAXMIDEO OTHER PROPERTY INSURANCE OFFICESUPPLIES LAUNDRY/IANTORIAL SUPPLIES FEPAIR/MAINTENANCE: SUPPLIES (Year1 only big spend tor make safe) VEHICLE AND EQUIPMENY GAS UNIFORMS/APPAREL EMP/INMATES EDUCATION/RECREATIONSUPPUES ADD-BUILDING CONTINGENCY Total Estimated Expenses:  Available Safe Slips toF Rent:  Available Annual $$ Totals$  Available Annualss Totals$ 16 $3,900.00 $62,400.00 8 $3,900.00 $31,200.00 6 $1,950.00 $11,700.00 14 $3,900.00 $54,600.00 2 $10,000.00 $20,000.00 1 $5,400.00 $5,400.00 1 $19,000.00 $19,000.00 1 $1,200.00 $1,200.00 $205,500.00 2,000.00 10,000.00 0.00 1,500.00 5,000.00 3,000.00 0.00 0.00 3,250.00 0.00 0.00 25,000.00 0.00 0.00 2,250.00 45,000.00 5,200.00 102,200.00 103,300.00 17  0 $3,900.00 $0.00 Ldock- (closed uns safe) 8 $3,900.00 $31,200.00 MD Dock- Lease spots 6 $1,950.00 $11,700.00 MD Dock- Vistor Spots 14 $3,900.00 $54,600.00 NDock- Lease Spots 2 $10,000.00 $20,000.00 Ramp Fees 1 $5,400.00 $5,400.00 ce Building Rental $0.00 $0.00 Marina Store Rental 1 $1,200.00 $1,200.00 Food Truck Spot Rental $124,100.00 Total Estimated Revenues Operating Expenses: 2,000.00 EQUIPMENT REPAIRS 10,000.00 SERVICE CONTRACTS 0.00 MVEHICLE MAINTENANCE 1,500.00 ADVERTISING 4,000.00 ELECTRICALS SERVICES 2,000.00 WATER AND: SEWER 0.00 POSTAGE 0.00 TELEPHONE/FAXMIDEO 3,250.00 OTHER PROPERTY INSURANCE 0.00 OFFICE SUPPLIES 0.00 AUNOV/ANTORALSUPUS 70,000.00 REPAIR/MAINTENANCES SUPPLIES (reduced after FY25) 0.00 VEHICLE ANDI EQUIPMENYGAS 0.00 UNIFORMS/APPAREL EMP/INMATES 2,250.00 EDUCATON/RECREATON: SUPPLIES 0.00 Add onp part time on sites staff 5,200.00 CONTINGENCY 100,200.00 Total Estimated Expenses: 23,900.00  The Marina is part of the City's General Fund and is not considered an Enterprise fund. Therefore, this would not be a loan but a transfer to the  1  Marina (Fund 038).  IfCouncil approves to allocate FY24 surplus funds to provide the needed repairs to the Marina the information noted to the left would be the estimated revenue over expense information for The $500K transfers to the Marina would be recouped by the City in 5 years.  FY25.  Net  Net  CITY OF HOPEWELL FINANCE COMMITTEE    FY24 Surplus Funds Allocation  Staff was asked their recommendation on half of the FY24 Surplus and how it should be allocated in the established reserve funds adopted in the City's Financial policies. Our recommendation is as follows: Capital Reserve - $1.5M (Due to outstanding unfunded Capital, additional years $500K to $1M)  Unassigned d-$1.54M  Assigned-$ $1.5M (Marina and Schools ERP) Budget Stabilization - $500K Replenishment offund Balance- $500K  CITY OF HOPEWELL FINANCE COMMITTEE  18    November Items  1. Sewer Rate Study = Presented at the September 27th Council Meeting; update to be presented  at October 22nd Council Meeting 2. Update of FY20-FY24 ACFRS  CITY OF HOPEWELL FINANCE COMMITTEE  19    ADJOURNMENT