AGENDA oF HMOPEL CITY OF HOPEWELL Hopewell, Virginia 23860 AGENDA (804)541-2408 www.hopewelvagoy into@hopewelvagoy yoletx@hopewelvagor SPECIAL MEETING CITY COUNCIL John B.Partin,Jr., Mayor, Ward# #3 Jasmine E.Gore, Vice Mayor, Ward #4 Rita. Joyner, Councilor, Ward #1 Michael B. Harris, Councilor, Ward? #2 Janice B.I Denton, Councilor, Ward# #5 Brenda S.Pelham, Councilor, Ward# #6 Dominic R.I Holloway, Sr.,Councilor, Ward#7 Dr. Concetta Manker, City Manager Beverly Burton, Interim City Attorney Brittani Williams, City Clerk ALTH of Open Meeting- 6:001 PM November 19, 2024 6:00 p.m. Call to order, roll call, and welcome to visitors SPECIALI MEETING Regular Business R-1-1 Finance Committee Report- CFO- Stacy Jordan, Finance Director R-2-7 Treasurer's Report - Shannon Foskey, City Treasurer Adjournment CFO REPORT City of Hopewell Bank andl Investment! Balances FY2025 CashAccounts Account CityAP-2 ZBA Cityl Industrials Safety0 Council CityN Master City Payroll- -ZBA CityP Police SCU CityP Police Trusta andA Agency Citys Sheriff Citys Sheriff GeneralFund2 2497- -CLOSED Datal Integrators EMSR Recovery RecCredito Card SBCafeP Prepay SBPayroll- -ZBA SBTreasurers- ZBA SpecialWelfare Beacon Theatre 2012LLC BEACONT THEATRE 2012LLC TotalCash Investment Account Account LGIP- GpiaiProjetFundil- LGIP- CapP ProjectsF FundB Bondl Issue- LGIP- Sewer SysR Rate Stabilization- LGIP- Sewer SystemR Revenue- LGIP- -Fund 425 Sewers Systi Improve- LGIP- HRWTFI Improvement Fund- LGIP- HRWTF OperatingF Fund- LGIP- Sewers SceF Fund- LGIP- GeneralFund- LGIPF Portfolio- LGIP- Perpetual CareF Fund- Regions- 2008A A&BP PayingA Agency- Schwab- -Caprin! Investment- SNAP- 2009AI Int- SNAP- 2009AF Princ- TRUIST- SunTrust- Escrow Acct- Agmt- TRUIST -SunTrust- USB Bank Sewers SysB Bond Fund- USB Bankz 2010F Reserve- USB Bank 2011- Debts ScF Reverse Fund USB Bank 2011B- US Bank- 2012interest- USE Bank- 2012F Principal- USB Bank- 2012F Reserve- USB Bank- 2014 Interest- UsBank- 2014F Principal- USB Bank- 2014R Reserve- USB Bank- -20151 Interest- USE Bank- 2015F Principal- UsBank- -2015D- Totall Investments TotalCasha andl Investments Citys Sheriff GeneralFund 2497 Accountc closed1 10/03/2023 USBank2 2011- Debts SCR ReverseF Fund1 156229000 *Addedtolist USE Bank- 20121 Interest- 164074000 *Closed. Transfert toa anothert trust2 212503000as as12/31/21 USBank- 2012F Principal- 164074001 *Accounto closed01/11/2022 USBank- 2012R Reserve- 164074002 Accounto closedo on 1/11/2022 Lastu Update:NH 20241106 6/30/2024 28,123.77 1,940.45$ 138,966.52_ 25.00 166,074.97_$ 10,773.00 398.00_$ 72,337.13_$ 108,490.93 6/30/2024 787,742.70 292,774.41 2,535,018.41 1,337,341.03 1,183,546.49 706,146.06 255,729.79 2,214,450.89 297,067.11 1,041,948.43 2.00$ 5,735,787.02 2,936,781.96 722,209.70 1,869,269.95_ 272,668.76_S 1,361,815.00 554,874.94_ 47,108.52 111,416.42_ 353,482.26 10,428.03 453,388.46 144,336.86$ 7/31/2024 29,323.77_ 1,940.45_ 139,881.42_$ 25.00 317,542.70_ 6,428.00_$ 55.00$ 62,577.73 88,048.18$ 7/31/2024 791,363.35 294,120.07 2,546,670.05 1,343,487.85 1,188,986.40 709,391.73 256,905.18 2,224,629.12 298,432.54 1,046,737.51 2.00$ 5,763,427.08 2,948,788.82 724,724.59 873,241.28_ 272,668.76_ 1,361,815.00 557,238.61 62,141.61_$ 123,661.04 354,988.03_ 13,721.45 503,200.23_ 144,920.35 8/31/2024 29,623.77$ 1,940.45 152,414.59 100.00 69,616.17 394,229.49 7,452.00$ 450.00_$ 75,116.31_ 43,648.18_ 8/31/2024 794,994.15 295,469.52 2,558,354.27S 1,349,651.81 1,194,441.52 712,646.45_ 258,083.86 2,234,835.81 299,801.73 1,051,540.00 2.00$ 5,805,091.20 2,961,239.78 727,333.11 1,023,295.95 272,668.76_ 1,361,815.00 559,698.93 77,237.76 135,968.59_ 356,555.37 17,028.70 553,268.03_ 145,525.52 9/30/2024 29,623.77_ 1,940.45 152,391.27 25.00 779,362.25_ 77,972.92 6,812.19 341.00_$ 70,642.69 39,280.18$ 9/30/2024 798,439.95 296,750.19 2,569,443.05 1,355,501.68 1,199,618.66 715,735.33 259,202.48 2,244,522.38 301,101.17 1,056,097.76 2.00 5,846,036.30 2,973,720.60 729,951.01 1,171,623.06 272,668.76 1,361,815.00 562,164.21 92,393.45_ 148,324.05 358,125.87 20,349.00 603,530.73 146,131.83$ 10/31/2023 30,423.77 9,304,551.60 (0.00) 1,940.45 151,537.66 25.00 1,045,492.57 155,267.72 11,156.60 464.00 78,254.33 39,280.18 10/31/2023 801,843.83 298,015.27 2,580,397.00 1,361,280.42 1,204,732.83 718,786.61 260,307.48 2,254,091.18 302,384.83 1,060,600.11 2.00 5,827,244.57 2,985,740.40 732,421.16 1,319,789.81 272,668.76 1,361,815.00 564,483.65 16,889.61 16,074.82 359,603.47 2,223.91 65,800.71 146,701.11 31,847,104.105 22,005,003.125 17,543,098.00 13,593,306.31 $ $ 32,374,233.87 $ 22,650,825.37 $ 18,317,688.96 $ 14,751,698.03 $ 10,818,393.88 $ 25,225,335.20 $ 24,405,262.65 $ 24,746,547.82 $ 25,083,248.52 $ 24,513,898.54 $ 57,599,569.07 $ 47,056,088.02 $ 43,064,236.78 $ 39,834,946.55 $ 35,332,292.42 FY25B Bank8 &I InvestmentE Balances 1of1 Finance Committee Meeting CITY MANAGER: DR. CONCETTA MANKER PRESENTED BY: STACEY JORDAN, CFO CITY OF HOPEWELLE FINANCE COMMITTEE AGENDA "Minutes from last meeting "FY25 Budget to Actuals - October Citywide General Fund Enterprise Schools Departmental "Breakdown of Mis Revenues, Other taxes and Other Expenses "October Collection report-D Data Integrators "Accounts Payable/Debt Service "P-Card Policy Revisions "Reports from COR and Treasurer "December committee items CITY OF HOPEWELL FINANCE COMMITTEE Citywide FY25 Budget to Actuals - OCTOBER FY25 Citywide Revenues and Expenditures- Budget VS Actuals 250,000,000 200,000,000 150,000,000 100,000,000 50,000,000 City-wide revenues for October are trending 0.97% or $4.3M higher in for FY25 VS FY24. Expenses are trending 1.58% higher or $2.5M for FY25 Vs FY24. FY24 REVISED FY24Actuals FY25 REVISED FY25A Actuals FY25A Adjustments FY25) YTDA Act BUDGET BUDGET =Revenue Expenditures Projecte CITY OF HOPEWELLFINANCE COMMITTEE 3 Citywide FY25 Budget to Actuals - OCTOBER CITY-WIDE BudgetRec'd BUDGET 3.1% 21,928,970 0.0% 5,100,000 6.3% 7,056,000 0.7% 9,586,049 5.0% 1,618,030 28.4% 10,840,000 124.4% 530,200 23.5% 48,653,969 40.8% 586,000 68.6% 470,450 51.4% 1,235,500 34.6% 412,964 28.6% 61,969,103 19,871,848 46.1% 15,836,761 2.7% 5,276,005 46.5% 1,591,511 33.3% 947,617 34.6% 32,992,615 11,707,846 BudgetRec'd BUDGET 26.9% 30,412,311 29.6% 5,292,748 26.7% 437,443 28.0% 4,288,833 27.3% 2,461,404 27.2% 15,870,358 29.6% 513,671 27.6% 37,379,828 27.5% 5,567,748 49.0% 1,265,231 34.1% 72,389,640 7.8% 11,350,479 48.2% 7,418,450 50.0% 13,865,900 19.9% 18,117,715 REVENUES REAL ESTATETAXES PUBLIC SERVICE CORP TAX PERSONAL PROPERTY TAX MACH &1 TOOLTAX PPTRA STATE REIMBURSEMENT OTHER TAXES USE OF MONEY & PROPERTY CHARGES FOR SERVICES PENALTIES&I INTEREST PERMITS, FEES AND! LICENSES FINES & FORFEITURES GRANTS STATE REVENUES FEDERAL REVENUES MISCELLANEOUS REVENUE IN LIEU OF TAXES DEBT SERVICE TRANSFERS IN TOTAL REVENUES SALARIES & WAGES HEALTH BENEFITS EMPLOYEE BENEFITS RETIREMENT OTHER PERSONNEL PROFESSIONAL: SERVICES WORKERS COMPENSATION SERVICE & SUPPLIES OUTSIDE AGENCIES NON-DEPARTMENTAL OTHER CAPITAL DEBT SUPPORT OF SCHOOLS TRANSFERS OUT TOTAL EXPENDITURES NET) INCOME FY24 REVISED FY24 Actuals FY24 % of FY25REVISED FY25 Actuals FY25 FY25YTD Actuals FY25 % Rec'd BUDGET 20,979,167 660,174 4,100,000 5,636,800 356,782 8,783,500 62,869 1,618,030 80,901 10,110,000 2,875,833 340,000 423,026 40,064,435 9,408,724 488,500 199,411 285,600 195,974 860,500 442,486 141,500 49,000 54,722,975 15,675,434 20,809,536 9,583,574 16,481,067 444,268 1,591,511 740,087 1,120,526 373,509 29,933,944 10,348,673 BUDGET 29,268,158 7,876,323 4,961,744 1,470,005 374,046 99,837 4,184,354 1,172,581 2,391,182 651,747 15,776,573 4,287,189 509,172 150,931 38,242,570 10,556,513 5,823,349 1,599,021 1,283,888 629,582 69,256,600 23,648,019 21,697,338 1,682,563 7,428,083 3,577,413 13,580,000 6,790,000 15,344,944 3,054,173 (12,054,410) (15,325,172) -5.41% Adjustments Projected Projected Comments 955,861 955,861 263,203 263,203 273,948 273,948 80,901 80,901 2,929,311 2,929,311 334,634 334,634 9,491,038 2,500,000 11,991,038 191,742 191,742 196,191 196,191 291,049 291,049 318,901 318,901 19,871,848 4,747,333 4,747,333 947,690 947,690 712,253 27,834 740,087 236,904 78,968 315,872 11,707,846 Adjustments Projected Projected 9,425,111 1,596,849 87,790 1,269,451 782,036 3,919,782 169,804 8,607,901 1,744,222 628,750 631,004 3,605,663 6,932,950 4,270,396 4.4% Increase duet to past due colections 0.0% 3.7% Sight decrease due to colections 2.9% Increase duet to past due colections 5.0% Consistent 27.0% 63.1% Decrease due to Interest income 24.6% 32.7% 41.7% 23.6% Varable Revenue sight decrease 77.2% Increase duet to SW Grant received 32.1% School5 & Social Services 30.0% Decrease duet to ARPA hFY24 18.0% Increase duet to $452.5k HWR Misc. Credts 46.5% Consistent 33.3% 35.5% Sight Increase for transfer to funds 31.0% 2.5% Annuals Salary Increase 30.2% 20.1% 29.6% 31.8% 24.7% 33.1% 23.0% 31.3% 49.7% 36.1% Schoos Q1 Operational! Expenses 5.6% 48.6% 50.0% 23.6% 30.8% 218,067,591 51,920,724 23.81% 226,631,744 53,550,655 2,606,802 56,157,457 24.78% EXPENDITURES FY24REVISED FY24. Actuals FY24%of. FY25 REVISED FY25 Actuals FY25 FY25YTD Actuals FY25 % Rec'd 9,425,111 1,596,849 87,790 1,269,451 782,036 3,919,782 169,804 8,607,901 1,744,222 628,750 8,747,677 17,401,612 26,149,289.88 631,004 3,605,663 6,932,950 4,270,396 230,122,001 67,245,897 29.22% 226,631,759 52,419,386 17,401,612 69,820,998 (15) 1,131,269 (14,794,810) (13,663,541) 6.03%] CITY OF HOPEWELL! FINANCE COMMITTEE General Fund FY25 Budget to Actuals - OCTOBER FY25 General Fund Revenue and Expenditures 80,000,000 70,000,000 60,000,000 50,000,000 40,000,000 30,000,000 20,000,000 10,000,000 General fund for October is trending 2.33% or $603K lower Expenses for FY25 are trending 0.5% or $2.8M higher than The key due dates for the City are Dec, Feb and June. in Revenues for FY25 VS FY24 FY24 FY24REVISED FY24/ Actuals FY25 REVISED FY25 Actuals FY25YTDA BUDGET BUDGET Revenue mExpenditures Projecte CITY OFH HOPEWELLE FINANCE COMMITTEE 5 General Fund FY25 Budget to Actuals - OCTOBER GENERAL FUND FY24%of 3.194 21,928,970 0.094 5,100,000 6.39 7,056,000 0.794 9,586,049 5.094 1,618,030 25.094 7,240,000 59.794 90,000 54.994 849,534 40.294 581,000 68.694 470,450 50.694 1,235,500 100.0% 319,404 29.194 9,196,100 121.194 350,000 51.294 1,307,814 50.094 1,257,500 50.094 1,009,000 15.13%4 69,195,351 27.194 20,671,159 29.99 3,755,712 27.394 308,840 27.8% 2,942,005 27.494 1,684,767 50.094 5,451,888 30.294 430,846 27.894 5,761,779 31.794 4,924,213 3.094 7,731 59.394 561,394 73.494 288,337 50.094 13,865,900 50.0%4 8,540,791 36.5% 69,195,362 FY25YTDA Actuals FY25%Rec'd Projected Projected 955,861 263,203 273,948 80,901 1,493,528 46,448 648,203 189,128 196,191 288,442 2,822,768 43,958 420,842 628,750 504,500 8,856,671 FY25YTDA Actuals FY25%Rec'd Projected Projected 6,473,891 1,151,931 59,730 863,991 537,916 1,889,377 143,270 1,404,998 1,743,992 49,450 49,154 6,932,950 4,270,396 25,571,044 REVENUES REAL ESTATE1 TAXES PUBLICSERVICE CORPTAX PERSONALF PROPERTYTAX MACH&1 TOOL TAX PPTRASTATE REIMBURSEMENT OTHERT TAXES USE OFN MONEY&F PROPERTY CHARGES FOR SERVICES PENALTIES&I INTEREST PERMITS, FEESANDL LICENSES FINES& FORFEITURES GRANTS STATE REVENUES FEDERALI REVENUES MISCELLANEOUS: REVENUE NUEUOF1 TAXES TRANSFERSIN TOTAL REVENUES EXPENDITURES SALARIES&V WAGES HEALTHBENEFITS EMPLOYEE BENEFITS RETIREMENT OTHER PERSONNEL PROFESSIONALS SERVICES MORAERSCOMPENSATION: SERVICE&S SUPPLIES OUTSIDEA AGENCIES NON-DEPARTMENTAL OTHER CAPITAL SUPPORT OFS SCHOOLS TRANSFERSOUT TOTAL EXPENDITURES NETINCOME 24REVSEDBUDGET FY24Actuals BudgetRec'd PSREVISEDBUDGET FY25A Actuals COMMENTS 20,979,167 655,579 4,100,000 5,636,800 356,782 8,783,500 62,869 1,618,030 80,901 6,560,000 1,638,638 65,000 38,807 683,728 375,490 487,500 195,803 285,600 195,974 860,500 435,393 2,000 2,000 8,194,190 2,385,645 1,251,000 1,514,396 757,385 387,951 1,257,500 628,750 1,009,000 504,500 62,530,900 9,459,479 19,913,261 5,398,095 3,554,597 1,064,478 255,498 69,822 2,885,871 801,469 1,628,553 446,697 3,568,285 1,784,089 429,097 129,727 5,207,695 1,448,328 5,039,189 1,596,927 27,890 832 72,098 42,789 260,526 191,344 13,580,000 6,790,000 6,108,345 3,054,173 62,530,905 22,818,770 (5) (13,359,291) 955,861 263,203 273,948 80,901 1,493,528 46,448 648,203 189,128 196,191 288,442 2,822,768 43,958 420,842 628,750 504,500 8,856,671 6,473,891 1,151,931 59,730 863,991 537,916 1,889,377 143,270 1,404,998 1,743,992 49,450 49,154 6,932,950 4,270,396 25,571,044 4.494 0.094 3.794 2.994 5.094 20.694 51.694 76.394 32.694 41.794 23.394 0.094 30.794 12.694Decrease duet to ARPAinF FY24 32.294 50.094 50.094 12.809 31.3942.5%A Annual Salary! Increase 30.794 19.394 29.494 31.994 34.794 33.394 24.494 35.49 0.094 8.894 17.094 50.094 50.09increase int transfert to otherf funds 37.0% -24.1699 P23REVSEDBUDGET FY24Actuals FY23%Used 24REVSEDBUDGET FY25Actuals -21.3694 (11) (16,714,373) (16,714,373) CITY OF HOPEWELLFINANCE COMMITTEE Enterprise Fund FY25 Budget to Actuals -OCTOBER Regional Water, Sewer, Solid Waste, ands Storm Water FY25 Enterprise Funds Revenue and Expenditures 60,000,000 50,000,000 40,000,000 30,000,000 20,000,000 10,000,000 Enterprise fund for October is trending 4.8% or $3.4M higher in Revenues for FY25 VS FY24. Expense for FY25 are trending 7.22% or $2.2M less the Revenues show reflection of on-time billing VS last year and expenses decreases stems from the reduction of emergency repairs compared to last year. expense in FY24. FY24REVISED FY24Actuals FY25 REVISED FY25 Actuals FY25YTDActuals- BUDGET BUDGET Revenue Expenditures Projected CITYOF HOPEWELLI FINANCE COMMITTEE Enterprise Fund FY25 Budget to Actual - OCTOBER ENTERPRISE FUNDS FY25YTD Actuals FY25% FY24REVISED 235,000 33,182,403 3,015,000 334,011 1,120,526 9,236,599 FY24REVISED 4,491,662 1,153,954 640,213 75,920 624,982 354,748 8,962,314 2,385,620 50,674 14,332,597 6,000 1,257,500 61,400 4,440,284 2,588,642 9,236,599 47,123,535 12,614,960 4 (3,797,614) -8.06% FY25REVISED REVENUES USE OF MONEY& PROPERTY CHARGES FOR: SERVICES MISCELLANEOUS REVENUE GRANTS IN LIEU OF TAXES DEBT SERVICE TRANSFERS IN TOTAL REVENUES EXPENDITURES SALARIES & WAGES HEALTHE BENEFITS EMPLOYEE BENEFITS RETIREMENT OTHER PERSONNEL PROFESSIONAL SERVICES WORKERS COMPENSATION SERVICE &: SUPPLIES OUTSIDE AGENCIES NON-DEPARTMENTAL OTHER CAPITAL DEBT TRANSFERS OUT TOTALI EXPENDITURES NET INCOME BUDGET FY24Actuals FY249Rec'd BUDGET FY25Actuals Projected Rec'd Comments 264,171 112.4% 300,000 184,629 184,629 61.5% 7,809,703 3,855 254,771 111,337 373,509 23.5% 42,367,151 8,336,255 10,836,255 25.6% On-time billing 33.3% 947,617 236,904 315,872 33.3% 0.1% 495,564 507,212 33.3% 334,011 0.0% 8,672,924 FY25R REVISED 25.7% 4,731,824 1,437,702 1,437,702 30.4% 27.3% 713,300 200,994 200,994 28.2% 25.9% 82,751 26.2% 642,777 27.0% 364,449 26.6% 10,020,864 1,923,108 1,923,108 19.2% 29.2% 53,697 22.8% 5,000 50.0% 1,257,500 628,750 628,750 50.0% 16.5% 61,400 5.8% 9,427,755 423,783 33.3% 2,583,988 859,892 0.0% 9,576,924 507,212 102.4% DEQ Pilot program 254,771 254,771 83,503 111,337 33.3% 0.0% 47,123,539 8,817,346 18.71% 53,117,267 9,603,274 12,210,076 22.99% BUDGET FY24Actuals FY249Rec'd BUDGET FY25 Actuals Projected Rec'd FY25YTD Actuals FY25% 174,918 19,654 163,769 95,905 14,809 6,846,593 1,366 628,750 10,154 257,021 862,447 13,275 191,632 118,555 18,832 17,899 13,275 16.0% 191,632 29.8% 118,555 32.5% 18,832 35.1% 0.0% 17,899 29.2% 423,783 4.5% 859,892 33.3% 0.0% 47.8% 13,595,040 4,552,542 4,552,542 33.5% Decrease ine emergency repairs 26.8% 53,117,269 10,386,963 10,386,963 19.6% (2) (783,689) 1,823,113 3.43% CITY OF HOPEWELL FINANCE COMMITTEE Schools FY25 Budget to Actual - OCTOBER FY25 Schools Revenue and Expenditures 80,000,000 70,000,000 60,000,000 50,000,000 40,000,000 30,000,000 20,000,000 10,000,000 Schools for October is trending 0.91% or $435K less in revenues for FY25 VS FY24 Expenses are trending 2.05% or $2.6M more in FY25 VS FY24 FY24REVISED FY24 Actuals FY25F REVISED FY25A Actuals FY25YTDActuals- BUDGET BUDGET Revenue Expenditures Projected CIYOFHOPEWELLFMANCE COMMITTEE Schools FY25 Budget to Actuals- OCTOBER SCHOOLS FY24 REVISED BUDGET 5,023,384 39,351,282 13,980,744 13,580,000 71,935,410 FY24 REVISED BUDGET 3,072,226 68,816,004 47,180 71,935,410 FY25 REVISED 23.0% 5,296,434 29.4% 46,226,573 40.9% 9,725,282 50.0% 13,865,900 35.08% 75,114,189 FY25) YTD Actuals - Projected 412,206 13,618,261 4,703,375 6,932,950 25,666,792 FY25 YTD Actuals Projected 26,149,290 26,149,290 (482,498) REVENUES CHARGES FORSERVICES STATE REVENUES FEDERAL REVENUES TRANSFERS IN TOTAL REVENUES FY24 Actuals FY24%Rec'd BUDGET FY25 Actuals 412,206 13,618,261 4,703,375 6,932,950 25,666,792 FY25%Rec'd 7.8% 29.5% 48.4% 50.0% 34.17% 1,154,534 11,565,793 5,721,513 6,790,000 25,231,840 FY25 REVISED 0.0% 3,480,588 34.2% 71,586,421 0.0% 47,180 32.8% 75,114,189 2.31% EXPENDITURES SERVICE&S SUPPLIES OTHER CAPITAL TOTAL EXPENDITURES NET INCOME FY24 Actuals FY24%Rec'd BUDGET FY25 Actuals 8,641,022 8,641,022 17,025,771 FY25 %F Rec'd 0.0% 36.5% 0.0% 34.81% -0.64% 23,567,587 23,567,587 1,664,253 CITYOF HOPEWELLFINANCE COMMITTEE 10 FY25 Department Budget to Actual- OCTOBER FY25 APODTEDI BUDGET YTDE BUDGET AMOUNT- BUDGET REMAINING %OFE BUDGETYTD ONT TREND $ 2,090,370.37 $ 391,154.86 $ 1,839,724.77 $ 502,680.02 $ 69,196.99 $ 419,406.80 $ 752,163.31 $ 150,816.29 $ 605,238.97 $ 413,930.42 $ 62,112.13 $ 342,442.36 179,065.96 $ 38,188.25 $ 140,581.18 S 1,110,931.19 $ 481,697.54 $ 626,661.58 732,598.72 $ 139,125.86 $ 592,770.35 $ 1,065,315.43 $ 240,153.14 $ 825,042.38 254,860.70 $ 29,725.80 $ 223,732.70 7,000.00 $ 813.39 3,888,429.42 $ 219,482.47 $ 1,582,987.70 822,043.05 $ 125,907.84 $ 640,038.91 7,298,531.22 $ 1,315,769.99 $ 5,845,398.97 147,472.18 $ 22,983.84 $ 126,437.81 152,746.04 $ 22,236.90 $ 130,451.18 482,907.62 $ 125,216.30 $ 357,504.97 29,482,650.00 $ 5,139,632.36 $ 16,004,616.38 816,865.85 $ 158,374.25 $ 606,649.75 1,916,235.53 $ 606,748.24 $ 1,225,511.01 11,550.00 $ 1,894.65 $ $ 100,200.00 $ 72,106.73 $ 10,124.90 $ 1,517,112.57 $ 372,997.09 $ 1,087,912.18 $ 10,948,736.22 $ 2,475,750.29 $ 8,128,272.60 12,997,076.96 $ 1,733,999.81 2,551,847.12 $ 516,394.00 $ 1,859,115.59 3,688,654.13 $ 526,131.99 $ 695,652.39 7,336,553.00 $ 1,939,243.19 $ 4,730,193.26 7,195,329.50 $ 1,529,240.03 $ 5,663,247.12 1,396,114.20 $ 190,246.89 $ 1,159,184.18 $ 725,641.59 $ 133,145.45 $ 590,710.84 $ 177,481.00 $ 37,655.41 $ 139,825.59 $ 177,662.84 $ 22,076.84 $ 154,216.40 423,465.86 $ 83,140.95 $103,627,113.41 $ 19,420,210.97 $ 67,711,554.01 DEPARTMENT ACCOUNTING ASSESSOR CIRCUIT COURT CITYA ATTORNEY CITY CLERK CITY MANAGER COMMISSION OF 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 PUBLIC WORKS RECREATION REFUSE SEWER SHERIFF SOCIAL SERVICES STORMWATER TREASURER MICTIM WITNESS MJCCCA MOTER REGISTRAR Grand Total COMMENTS 19% TRUE 14% TRUE 20% TRUE 15% TRUE 21% TRUE 43% FALSE 19% TRUE 23% TRUE 12% TRUE 12% TRUE 6% TRUE 15% TRUE 18% TRUE 16% TRUE 15% TRUE 26% TRUE 17% TRUE 19% TRUE 32% TRUE 16% TRUE 72% FALSE 25% TRUE 23% TRUE 13% TRUE 20% TRUE 14% TRUE 26% TRUE 20% TRUE 21% TRUE 14% TRUE 18% TRUE 21% TRUE 12% TRUE 20% TRUE 19% TRUE RBG Consultants 6,259.41 Repairs & Utilities 9,286,608.54 2,262,891.39 446,851.21 $ 1,769,250.81 295,782.43 CITY OF HOPEWELL FINANCE COMMITTEE 11 Breakdown of Miscellaneous Revenue, Other Taxes and Other Expenses Miscellaneous Revenue Capital Debt General- Circuit Court General- City Manager General- Local Revenues General Mis (Employee Reimbursement) General Mis (Insurance, Claims, FEMA) General Mis (Schools repayment) General Mis (Tax exemption) General Mis (Vendor repayments) General Police General -Sheriff General Transfer to Sewer Healthy Families HRW Recreation Sewer Surplus Other Taxes (Revenue) BUSINESSLICENSE CIGARETTE TAX COMMUNICATONSTAX CONSUMPTION TAX-ELECTRIC CONSUMPIONTAXGAS FOOD1 TAXES LOCALS SALESTAX MOBILE HOMESTITLING TAX MOTOR VENROLINGSIOCKTAA RAIL ROAD ROLLING: STOCKTAX RECORDATION TAXES ROOMTAXES TAX ON DEEDS/GRANTORSTAXK UTILITYT TAX-ELECTRIC UTILITYTAX-GAS UTILITYTAX-WATER VEHICLE LICENSE Other Expenses CONTINEGENCY DCSDAUGSEAPNOTURS DUES/ASSOCIATION: MEMBERSHIPS OTHER PAYMENT PAYMENTTOSTATE SPECIAL WELFAREI EXPENSE CITY OF HOPEWELL FINANCE COMMITTEE 12 FY25 Data Integrators Collections - OCTOBER Utility Water/Sewer Collection Rate. July Billed 64,933.70 270,619.68 240,485.11 576,038.49 Utility Water/Sewer Collection Rate August Billed 66,697.54 274,283.81 251,090.34 592,071.69 Utility Water/Sewer Collection Rate September Billed 64,033.05 269,741.55 241,087.51 5 574,862.11 Utility Water/Sewer Collection Rate October Billed 65,635.64 277,233.87 242,349.45 585,218.96 Account Designation Storm Water Solid Waste WasteV Water Total MTD Account Designation StormV Water Solid Waste Waste) Water Total MTD Account Designation StormV Water Solidy Waste WasteV Water Total MTD Account Designation Storm Water Solid Waste Waste Water Total YTD Collected 70,445.12 241,208.98 246,301.58 557,955.68 Collected 55,250.01 224,317.21 204,410.72 483,977.94 Collected 66,648.99 245,109.06 219,700.28 531,458.33 Collected 67,194.35 266,311.97 229,692.59 563,198.91 Percentage 108% 89% 102% 97% Percentage 83% 82% 81% 82% Percentage 104% 91% 91% 92% Percentage 102% 96% 95% 96% Percentagesinc excess of 100are duet toA Accounts billedi inp previous months butp paidi in currentr month* CITY OFH HOPEWELLFINANCE COMMITTEE 13 FY25 Accounts Payable/Debt Service - OCTOBER Accounts Payable October Invoices Received #ofi invoices received Samount processed 1741 5,677,553 $ Debt Service Payments October Vendor USE BANK- USB1824 Total Amount $215,269 $215,269 CIYOFHOPAMELFMANCE COMMITTEE 14 P-Card Policy Revisions The following revisions and forms have been created to ensure oversight on the use ofa City P-Card. The p-card policy has been updated and all Directors have been notified that cards are to be safeguarded on City premises in a lockbox or monitored by the Department Administrative Professional, Department Director, or Trusted Department Designee. When al P-Card is required for City-specific purchase or travel, the user is required to sign in and sign out the P-Card from the Employee responsible using Employees are not allowed under any circumstances to have a P-Card in your possession unless it has been documented on the P-Card Sign In/Sign Out Log or unless you have been approved using P-Card Exception Form which will be maintained on file with Improprieties have been noted within the policy for further direction to users, to include safeguards as listed above as well as infractions the P-Card Sign In/Sign Out] Log. Procurement. and consequences when violation oft the policy has occurred. There are serious risks of Implementing Departmental Card: Increases the City's Risk for Fraud and all the potential liability that comes along with it. Negates the accountability and responsibility ofl Individuals when using City Funds. Alleviates certain security measures and verification required by merchants and retailers when using the card. Potential ofpurchase delays by merchants and retailers not being able to properly identify authorized persons eligible for card use because of"blanket" Departmental Card. GINYOFHOPEWELLFMANCE COMMITTEE 15 December Items 1. Sewer Rate Study / Will be presented November 19th (1st read) and December 10th (2nd Read) 2. Presentation of FY20 ACFR 3. Update of FY20-FY24 ACFRS GIMYOFHOPEWELFNANCE 16 TREASURER REPORT oF HOPEL City of Hopewell Real Estate Collection Report Personal Property Collection Report Billy Year2 2022-2024 EALTH oF Charge Year 2022 MT-1ST MT-2ND PP PS RE RE-1ST RE-2ND RE-COL GrandTotal WEEK ENDING: 11.14.2024 99.99% 99.99% 87.43% 100.00% 46.47% 99.28% 98.92% 0.00% 97.00% 11.14.2024 99.99% 99.99% 75.78% 100.00% 90.16% 98.74% 98.02% 95.73% 11.14.2024 99.53% 34.35% 0.98% 0.00% 30.34% 97.05% 20.56% 45.93% Row Labels Sum of ADJBILLED Sum of NET PMT/CREDIT Sum of ENDI RECEIVABLE Percent Collected 4,612,874.13 4,610,576.55 6,769,019.60 4,147,824.23 175,759.83 8,043,666.70 8,016,472.50 209.95 36,376,403.49 4,612,643.18 4,610,318.69 5,918,416.55 4,147,824.23 81,679.22 7,985,558.24 7,930,102.53 35,286,542.64 230.95 257.86 850,603.05 94,080.61 58,108.46 86,369.97 209.95 1,089,860.85 Charge) Year 2023 MT-1ST MT-2ND PP PS RE RE-1ST RE-2ND Grand1 Total WEEK ENDING: Rowl Labels Sum of ADJE BILLED Sum of NET PMT/CREDIT Sum of ENDI RECEIVABLE Percent Collected 5,076,596.85 5,076,536.24 6,004,799.29 5,249,779.17 292,012.54 10,552,293.13 10,517,299.58 42,769,316.80 5,076,338.96 5,076,278.35 4,550,480.78 5,249,779.17 263,290.41 10,419,134.95 10,309,576.96 40,944,879.58 257.89 257.89 1,454,318.51 28,722.13 133,158.18 207,722.62 1,824,437.22 Chargey Year 2024 MT-1ST MT-2ND PP PS RE RE-1ST RE-2ND Grand Total WEEKI ENDING: Row Labels Sum of ADJBILLED Sum of NET PMT/CREDIT Sum of ENDI RECEIVABLE Percent Collected 5,182,337.78 5,170,119.90 5,840,527.23 5,229,554.50 35,603.78 11,032,366.83 10,982,557.04 43,473,067.06 5,157,833.71 1,776,163.91 56,946.06 10,801.48 10,706,900.40 2,258,012.82 19,966,658.38 24,504.07 3,393,955.99 5,783,581.17 5,229,554.50 24,802.30 325,466.43 8,724,544.22 23,506,408.68 2022-2024 Tax Summary Report' WE 11.14.24 Prepared by Neika Hart11/14/2024 1of1 City of Hopewell Meal Tax Collection Report Bill Year 2022-2024 EALTH oF Charge) Year Row Labels BUSINESS & OTHERS SVC $ LODGIN MEALT TAX Grand1 Total Charge Year Row Labels BUSINESS & OTHERSVC $ LODGIN MEALTAX Bank Franchise Grand Total Charge Year Row! Labels BUSINESS & OTHERSVC $ LODGIN MEALT TAX Grand1 Total 2022 $ $ $ 2023 $ $ $ $ 2024 $ $ $ WEEK ENDING: 5,728.30 7,977.35 13,705.65 WEEKE ENDING: (12,430.93) 37,984.06 25,553.13 WEEKE ENDING: 48,537.15 54,446.00 95,570.31 198,553.46 11.14.2024 99.31% 100.00% 99.38% 99.46% 11.14.2024 102.32% 100.00% 98.32% 0.53% 0.53% 11.14.2024 95.67% 94.92% 95.61% 95.52% Sum of PRIMARY BILLED Sum of NETPMT/CREDIT SumofENDRECEVABIE Percent Collected 2,239,812.08 $ 964,079.50 $ 2,580,472.18 $ 5,784,363.76 $ 2,224,259.70 $ 964,079.50 $ 2,564,520.40 $ 5,752,859.60 $ SumofPRIMARYB BILLED SumofNETPMI/CREDIT SUmOFENDRECEVABIE Percent Collected 2,376,828.44 $ 1,030,843.60 $ 2,796,264.58 $ 10,954,446.00 $ 17,158,382.62 $ 2,431,926.53 $ 1,030,843.60 $ 2,749,421.57 $ 57,815.00 $ 6,270,006.70 $ Sum of PRIMARYI BILLED Sum of NETP PMT/CREDIT Sum OfENDRECEIVABLE Percent Collected 2,588,269.99 $ 947,109.77 $ 2,123,180.16 $ 5,658,559.92 $ 2,476,177.83 $ 898,976.04 $ 2,029,975.54 $ 5,405,129.41 $ 22-247 TAX COLLECTION: SUMMARY Prepared by! Neika! Hart 11/14/2024 10F1 ADJOURNMENT