RecordWell Data

Finance Committee Meeting — Agenda Packet

City of Lynchburg · Lynchburg City County · Finance Committee · meeting of Feb 27, 2024 · Agenda packets

Open the original document More from City of Lynchburg

Text

Extracted automatically from the original. Tables and formatting may not survive; the original document is authoritative.

FINANCE COMMITTEE City Council Committee Tuesday, February 27, 2024 | 3:00 PM 2nd Floor Training Room- City Hall 900 Church Street Lynchburg, VA 24504 AGENDA I. Welcome Vice Mayor Chris Faraldi, Chair II. General Business II.1. Virginia Department of Forestry, 1983-2023 Urban and Community Forestry, Non- Matching Grants Program III. Quarterly Reports III.2. Quarterly Reports A) Greater Lynchburg Transit Company (GLTC) B) Regional Airport Fund C) Lynchburg Regional Juvenile Detention Center D) Children's Services Act Fund E) Water Operating Fund F) Sewer Operating Fund G) Stormwater Operating Fund H) General Fund IV. Other Information IV.3. FY 2024 General Fund Reserve for Contingencies IV.4. Monthly Revenue Collections Update IV.5. Presentation of the FY 2025 - 2029 Capital Improvement Program - City and Schools V. Roll Call VI. Next Regular Meeting VI.6. The next Finance Committee meeting is Tuesday, March 26, 2024 at 3:00 p.m. Page 1 of 73 Finance Committee Agenda Item II.1. Action AGENDA ITEM SUMMARY MEETING DATE PRESENTED BY February 27, 2024 Gaynelle Hart, Director of Public Works AGENDA ITEM # II.1 Virginia Department of Forestry, 1983-2023 Urban and Community Forestry, Non- Matching Grants Program RECOMMENDATION Adopt a resolution to amend the FY 2024 City/Federal/State Aid Fund budget and appropriate $189,985 with resources from the Virginia Department of Forestry, Urban and Community Forestry, Non-Matching Grants Program. This allocation, awarded to the City of Lynchburg, Department of Public Works, is for tree maintenance and planting. SUMMARY The City of Lynchburg, Department of Public Works, has been granted $189,985 from the Virginia Department of Forestry, Urban and Community Forestry, Non-Matching Grants Program. This funding is earmarked for the acquisition of vendor services, following Virginia procurement procedures. The selected vendor will be responsible for the pruning/maintenance of 650 existing trees and the planting of an additional 250 trees in downtown neighborhoods. Pruning for Long-Term Success: • Address the critical age and size of existing trees. • Undertake pruning activities of 650 trees to enhance the likelihood of long-term success and resilience, combating the heat island effect in neighborhoods. Strategic Tree Planting: • Plant 250 trees, giving priority to large species where possible, as a key component of the initiative to enhance the urban canopy. The designated planting sites have been pinpointed within the Public Works Department tree inventory, concentrating on blocks lacking street trees or displaying noticeable gaps in the current tree plantings. • Ongoing support from Lynchburg Tree Stewards spanning a decade guarantees the sustained well-being of these trees, as well as dedicated care and maintenance from the Department of Public Works. PRIOR ACTION(S) Page 2 of 73 Finance Committee, February 27, 2024 FISCAL IMPACT None, no local match is required. CONTACT(S) Gaynelle Hart, Director of Public Works Amy Lowe, Public Works Finance Manager ATTACHMENT(S) 1. RESOLUTION -VDOF Urban and Community Forestry Grant - Public Works REVIEWED BY Date: Gaynelle Hart, Director of Public Works Date: Gregory Patrick, Deputy City Manager Date: Alicia Finney, Clerk of Council Page 3 of 73 RESOLUTION: BE IT RESOLVED that the FY 2024 City/Federal/State Aid Fund budget is amended and $189,985 is appropriated with resources from the Virginia Department of Forestry, Urban and Community Forestry, Non-Matching Grants Program, for tree maintenance and planting. Introduced: Adopted: Certified: Clerk of Council Page 4 of 73 Finance Committee Agenda Item III.2. Information Only AGENDA ITEM SUMMARY MEETING DATE PRESENTED BY February 27, 2024 AGENDA ITEM # III.2 Quarterly Reports RECOMMENDATION Review highlights of the attached quarterly financial reports for the quarter ending December 31, 2023: FUND Presenter: A) Greater Lynchburg Transit Company (GLTC) Joshua Moore, GLTC General Manager B) Regional Airport Fund Andrew LaGala, Airport Director C) Lynchburg Regional Juvenile Detention Center Preston Sellers, Director of Human Services D) Children's Services Act Fund (CSA) Preston Sellers, Director of Human Services E) Water Operating Fund Tim Mitchell, Director of Water Resources F) Sewer Operating Fund Tim Mitchell, Director of Water Resources G) Stormwater Operating Fund Tim Mitchell, Director of Water Resources H) General Fund Donna Witt, Chief Financial Officer SUMMARY In compliance with the Finance Committee guidelines, quarterly financial reports are provided for General, Water, Sewer, Stormwater, Airport, Lynchburg Regional Juvenile Detention Center, Children’s Services Act (CSA) Funds, and Greater Lynchburg Transit Company (GLTC). PRIOR ACTION(S) FISCAL IMPACT None CONTACT(S) Donna Witt, Chief Financial Officer ATTACHMENT(S) 1. Quarterly Reports - Quarter Ending December 31, 2023 REVIEWED BY Page 5 of 73 Page 6 of 73 GREATER LYNCHBURG TRANSIT COMPANY We're Here To Get You There! Finance Committee Lynchburg City Council January 15th, 2024 Re: GLTC Quarterly Financial Report – 1st Quarter 2024 REVENUE GLTC has experienced higher than anticipated revenues in Fixed Route fares with a 14% positive variance over the anticipated totals for the quarter. Paratransit fare revenues are down 31% this quarter, which is balanced with lower paratransit expenses this quarter as well. Non-operating revenues are down 100% this quarter, which reflects lower insurance claims and advertising revenue is up 66%. City, County, State, and Federal operating assistance revenues have been disbursed to GLTC on-time. There is a decrease of 39% in State and 2% in Federal funds as GLTC has not accrued for the TRIP grant or begun drawing on our microtransit grant. EXPENSES Fixed Route Fixed Route expenses are 5% under budget for the quarter. Overtime for this quarter decreased significantly at 37% below budget with the addition of new operators. Other Salaries and Wages show an increase as this reflects performance increases for non-CBA staff. Demand Response (PTS) Demand Response expenses are 18% below budgeted numbers this quarter primarily due to positional vacancies creating savings in operator labor and fringe benefits of 20% and 34% respectively. Overtime is under budget by 34% due to this operational vacancy. Several of our new hires have not taken GLTC insurance which is contributing to our decreased overhead. Salaries and wages for the remaining staff in this department are up 4% for the quarter. Maintenance Maintenance wages and salaries are at 11% below budgeted as we have one employee out for long-term medical. Inspection and Servicer Overtime is 58% below budget as staff has been careful with overtime usage. Benefits for both groups are down 18% for the quarter due to several positions being part-time, or employees not taking benefits through us. Fuel and lubricants are currently at 28% under budget for the quarter. Page 7 of 73 GREATER LYNCHBURG TRANSIT COMPANY We're Here To Get You There! Tires are currently 23% above budget due to the constriction of the tire supply chain and general inability to consistently get recapped tires. Other materials and supplies are currently 29% below budget for this quarter as GLTC has experienced easing in the pricing of parts and scarcity, but shipping costs have remained high. Administration Administration is currently 23% below budget. Services were 2% over budget, with IT being 15% over budget. IT for all departments except Maintenance and Admin was underbudget significantly due to the changes in contracts as new capital technology was deployed. Casualty and Liability insurance is 2% under budget for this quarter. Utilities are also under budget by 19% this quarter although that is expected to change with the rate increases for both AEP and water, sewer, and stormwater. SUMMARY For the quarter, total expenses were under budget by 15% ($63,676). Price volatility in parts and fuels remain GLTC’s largest concerns in the new fiscal year and staff is continuing to meet the Board of Director’s Fiscal Sustainability KPIs. Respectfully, Joshua A. Moore General Manager Page 8 of 73 CENTRAL VIRGINIA TRANSIT MANAGEMENT CO INC. QUARTERLY INCOME STATEMENT AS OF SEPTEMBER 30, 2023 QTR TO DATE FY2024 FY2024 FY2024 FY2024 % QTD QTD % YTD YTD o f ACTUAL BUDGET VAR ACTUAL BUDGET Budget REVENUE FRT Passenger Revenue 115,276$ 100,728$ 14% 115,276$ 100,728$ 114% DRT Passenger Revenue 5,594 8,069 -31% 5,594 8,069 69% Contracts (CVCC Access) 12,759 12,759 0% 12,759 12,759 100% Non-Operating Revenue 30 35,124 -100% 30 35,124 0% Advertising Revenue 14,487 8,750 66% 14,487 8,750 166% City Operating Assistance 431,116 431,116 0% 431,116 431,116 100% County Operating Assistance 20,423 20,423 0% 20,423 20,423 100% State Operating Assistance 447,562 729,821 -39% 447,562 729,821 61% Federal Operating Assistance 1,171,190 1,192,318 -2% 1,171,190 1,192,318 98% TOTAL REVENUE 2,218,436$ 2,539,106$ -13% 2,218,436$ 2,539,106 $ 87% EXPENSES FIXED ROUTE Operator Labor 449,086 $ 458,748 $ -2% 449,086 $ 458,748 $ 98% Operator-Overtime 37,586 59,637 -37% 37,586 59,637 63% Other Salaries & Wages 127,025 112,674 13% 127,025 112,674 113% Supervisors-Overtime 3,599 5,614 -36% 3,599 5,614 64% Fringe Benefits 285,548 301,682 -5% 285,548 301,682 95% Information Technology 10,738 25,000 -57% 10,738 25,000 43% TOTAL FIXED ROUTE 913,581$ 963,355 $ -5% 913,581$ 963,355 $ 95% DEMAND RESPONSE Operator Labor 71,843 $ 89,757$ -20% 71,843$ 89,757$ 80% Operator-Overtime-PTS 1,767 2,693 -34% 1,767 2,693 66% Other Salaries & Wages 28,796 27,668 4% 28,796 27,668 104% Fringe Benefits 47,371 58,174 -19% 47,371 58,174 81% Information Technology 2,336 8,238 -72% 2,336 8,238 28% TOTAL DEMAND RESPONSE 152,114$ 186,530 $ -18% 152,114$ 186,530 $ 82% MAINTENANCE Other Salaries & Wages 196,992$ 221,550 $ -11% 196,992 $ 221,550 $ 89% Inspection&Maint,Srvc-Overtim e 5,835 13,882 -58% 5,835 13,882 42% Fringe Benefits 93,823 114,022 -18% 93,823 114,022 82% Fuel & Lubricants 198,696 274,221 -28% 198,696 274,221 72% Tires & Tubes 30,753 25,000 23% 30,753 25,000 123% Information Technology 2,919 2,250 30% 2,919 2,250 130% Other Materials & Supplies 65,652 92,500 -29% 68,570 94,750 72% TOTAL MAINTENANCE 594,669$ 743,425 $ -20% 594,669$ 743,425 $ 80% ADMINISTRATION Other Salaries & Wages 128,726$ 153,706 $ -16% 128,726 $ 153,706 $ 84% Fringe Benefits 59,546 74,441 -20% 59,546 74,441 80% Services 132,092 129,860 2% 132,092 129,860 102% Utilities 51,334 63,059 -19% 51,334 63,059 81% Casualty & Liability Expenses 65,397 66,524 -2% 65,397 66,524 98% Information Technology 16,697 14,525 15% 16,697 14,525 115% Other Materials & Supplies 14,099 32,919 -57% 14,099 32,919 43% Miscellaneous 26,505 110,763 -76% 26,505 110,763 24% TOTAL ADMINISTRATION 494,396$ 645,796 $ -23% 494,396$ 645,796 $ 77% TOTAL EXPENSES 2,154,760$ 2,539,106 $ -15% 2,154,760 $ 2,539,106 $ 85% NET INCOME/(LOSS) 63,676$ - $ 100% 63,676$ - $ 100% Page 9 of 73 GREATER LYNCHBURG TRANSIT COMPANY We're Here To Get You There! Finance Committee Lynchburg City Council February 14th, 2024 Re: GLTC Quarterly Financial Report – 2nd Quarter 2024 REVENUE GLTC has experienced higher than anticipated revenues in Fixed Route fares with a 27% positive variance over the anticipated totals for the quarter. Paratransit fare revenues are up 43% this quarter, non- operating revenues are up 19% this quarter, and advertising revenue is up 194% for this quarter. City, County, State, and Federal operating assistance revenues have been disbursed to GLTC on-time. There is a decrease of 27% in State and 2% in Federal funds due to not receiving the 2 nd Quarter TRIP grant and not drawing on our microtransit grant. EXPENSES Fixed Route Total Fixed Route expenses are 5% under budget for the quarter. Overtime for this remains 38% below budget. Other Salaries and Wages show an increase as as all positions are fully staffed. Fringes and Supervisor overtime are down for the quarter 3% and 31% respectively. Demand Response (PTS) Total Demand Response expenses are 10% below budgeted numbers this as PTS usage as increased this quarter. Overtime and fringe benefits remain 41% and 11% underbudget respectively. Salaries and wages for the remaining staff in this department are down 5% for the quarter. IT for Demand Response remains completely underbudget as the software vendor has not completed several required tasks for their quarterly payment. Maintenance Maintenance wages and salaries are at 6% below budgeted. Inspection and Servicer Overtime is 40% below budget as there is additional utilization due to several employee illnesses. Benefits for both groups are down 10% for the quarter due to several positions being part-time, or employees not taking benefits through us. Fuel and lubricant are currently 33% under budget for the quarter. We are currently watching the volatility in the fuel markets as prices are expected to continue to increase for the next several months. Tires were 28% under for the quarter as we did not have as many tires damaged by debris this quarter as usual. Other materials and supplies are currently 82% above budget for this quarter as GLTC completed Page 10 of 73 GREATER LYNCHBURG TRANSIT COMPANY We're Here To Get You There! several repair and upgrade campaigns and had to complete minor emergency repairs on the heating system components. Administration Administration is currently 24% below budget. Services were 11% over budget with increased marketing costs for some programs (offset by the higher non-operating revenue), with IT being 24% over budget with increased fees for firewalls and some hosted services adding the additional costs. Casualty and Liability insurance are 20% under budget for this quarter. Utilities are under budget by 39% this quarter partially due to milder weather for most of the month, although electricity usage was higher at the end of the quarter due to the need to filter the air more due to the wildfire smoke. Miscellaneous expenditures are lower this quarter at 80% below budget. SUMMARY For the quarter, total expenses were under budget by 11% ($106,685). For the year, GLTC currently is under budget by 13% ($170,542). Fuel prices are expected to continue to rise for the immediate future in projections set by the Department of Energy Information and GLTC staff are keeping an eye on our main volatility drivers (fuel, tires, and parts) to ensure that we are staying in-line with our projected cash flow and funding. Respectfully, Joshua A. Moore General Manager Page 11 of 73 CENTRAL VIRGINIA TRANSIT MANAGEMENT CO INC. QUARTERLY INCOME STATEMENT AS OF DECEMBER 31, 2023 QTR TO DATE FY2024 FY2024 FY2024 FY2024 % QTD QTD % YTD YTD o f ACTUAL BUDGET VAR ACTUAL BUDGET Budget REVENUE FRT Passenger Revenue 127,430 $ 100,728 $ 27% 242,706 $ 201,455 $ 120% DRT Passenger Revenue 11,520 8,069 43% 17,114 16,137 106% Contracts (CVCC Access) 12,759 12,759 0% 25,518 25,518 100% Non-Operating Revenue 41,669 35,124 19% 41,699 70,248 59% Advertising Revenue 25,701 8,750 194% 40,188 17,500 230% City Operating Assistance 431,116 431,116 0% 862,232 862,232 100% County Operating Assistance 20,423 20,423 0% 40,845 40,845 100% State Operating Assistance 531,130 729,821 -27% 978,692 1,459,643 67% Federal Operating Assistance 1,171,190 1,192,318 -2% 2,342,380 2,384,635 98% TOTAL REVENUE 2,372,938 $ 2,539,106 $ -7% 4,591,374$ 5,078,212 $ 90% EXPENSES FIXED ROUTE Operator Labor 439,684 $ 458,748 $ -4% 888,770 $ 917,496 $ 97% Operator-Overtime 36,806 59,637 -38% 74,392 119,275 62% Other Salaries & Wages 136,222 112,674 21% 263,248 225,348 117% Supervisors-Overtime 3,861 5,614 -31% 7,459 11,227 66% Fringe Benefits 292,861 301,682 -3% 578,409 603,364 96% Information Technology 9,638 25,000 -61% 20,375 50,000 41% TOTAL FIXED ROUTE 919,071$ 963,355 $ -5% 1,832,652$ 1,926,711 $ 95% DEMAND RESPONSE Operator Labor 81,016 $ 89,757 $ -10% 152,859 $ 179,514 $ 85% Operator-Overtime-PTS 1,585 2,693 -41% 3,353 5,385 62% Other Salaries & Wages 26,319 27,668 -5% 55,115 55,336 100% Fringe Benefits 51,694 58,174 -11% 99,065 116,349 85% Information Technology - 8,238 -100% 2,336 16,475 14% TOTAL DEMAND RESPONSE 160,614$ 186,530 $ -14% 312,728$ 373,059 $ 84% MAINTENANCE Other Salaries & Wages 208,854$ 221,550 $ -6% 405,846 $ 443,101 $ 92% Inspection&Maint,Srvc-Overtime 8,301 13,882 -40% 14,136 27,763 51% Fringe Benefits 103,054 114,022 -10% 196,878 228,044 86% Fuel & Lubricants 184,466 274,221 -33% 383,162 548,443 70% Tires & Tubes 17,983 25,000 -28% 48,735 50,000 97% Information Technology 2,919 2,250 30% 5,838 4,500 130% Other Materials & Supplies 167,979 92,500 82% 239,468 189,500 126% TOTAL MAINTENANCE 693,555$ 743,425 $ -7% 1,288,225$ 1,486,850 $ 87% ADMINISTRATION Other Salaries & Wages 129,511$ 153,706 $ -16% 258,237 $ 307,411 $ 84% Fringe Benefits 61,510 74,441 -17% 121,055 148,883 81% Services 143,635 129,860 11% 275,727 259,720 106% Utilities 38,224 63,059 -39% 89,558 126,118 71% Casualty & Liability Expenses 53,402 66,524 -20% 118,799 133,049 89% Information Technology 18,053 14,525 24% 34,750 29,050 120% Other Materials & Supplies 26,482 32,919 -20% 40,581 65,838 62% Miscellaneous 22,015 110,763 -80% 48,519 221,525 22% TOTAL ADMINISTRATION 492,831$ 645,796 $ -24% 987,227$ 1,291,593$ 76% TOTAL EXPENSES 2,266,073$ 2,539,106 $ -11% 4,420,832 $ 5,078,213 $ 87% NET INCOME/(LOSS) 106,865$ - $ 100% 170,542$ - $ 100% Page 12 of 73 Page 13 of 73 Page 14 of 73 LYNCHBURG REGIONAL AIRPORT OPERATING FUND FINANCIAL SUMMARY December 31, 2023 FY 2024 $ Variance FY 2023 FY 2023 FY 2023 * FY 2024 FY 2024 FY 2024 * FY 2024 FY 2024 Projected vs. Amended Actual % of * Amended Actual % of * Amended Projected Amended Budget (thru 12/31/22) Budget * Budget (thru 12/31/23) Budget * Budget Total Budget * * BEGINNING NET ASSETS 258,848$ 34,198,656$ * 250,000$ 40,245,824$ (1) * 250,000$ 40,245,824$ (1) Less: Invested in Capital Assets, net of related debt (33,156,798) * (37,940,664)$ * (37,940,664)$ * * BEGINNING UNRESTRICTED NET ASSETS 258,848$ 1,041,856$ * 250,000$ 2,305,158$ * 250,000$ 2,305,158$ -$ * * USE OF ENCUMBRANCES CARRIEDFORWARD 215,397$ 141,142$ 141,142$ 141,142$ TRANSFER OF RESERVES TO CAPITAL FUND * * REVENUES * * Airfield 100,000 55,745 56% * 100,000 57,948 58% * 100,000 100,000 0 Terminal 1,461,383 825,833 57% * 1,535,843 916,421 60% * 1,535,843 1,610,843 75,000 General Aviation 719,650 410,462 57% * 857,000 466,033 54% * 857,000 862,000 5,000 Other Leased Property 408,050 219,115 54% * 414,050 208,496 50% * 414,050 421,050 7,000 State Airport Aid 335,000 0 0% * 150,000 0 0% * 150,000 165,000 15,000 Federal Security Aid 87,000 29,520 34% * 87,000 29,480 34% * 87,000 87,000 0 Federal CARES/CRRSA/ARPA Grants 2,400,000 1,474,922 61% * 1,515,947 1,515,947 100% * 1,515,947 1,515,947 0 Interest & Other 135,000 84,075 62% * 101,000 135,648 134% * 101,000 181,000 80,000 * * TOTAL REVENUES 5,646,083$ 3,099,673$ * 4,760,840$ 3,329,974$ * 4,760,840$ 4,942,840$ 182,000$ * * EXPENSES * * Airfield Operations 321,025 144,119 45% * 328,498 219,613 67% * 328,498 328,498 0 Terminal Operations 663,875 257,583 39% * 647,639 228,503 35% * 647,639 647,639 0 General Aviation 163,119 66,410 41% * 162,266 62,344 38% * 162,266 162,266 0 Administration 991,418 545,299 55% * 1,006,332 607,455 60% * 1,006,332 1,036,332 (30,000) Public Safety (Fire & LEO) 469,889 260,148 55% * 444,082 264,398 60% * 444,082 484,082 (40,000) Snow Removal 24,030 13,725 57% * 24,030 8,755 36% * 24,030 24,030 0 Debt Service 112,363 5,266 5% * 179,033 7,933 4% * 179,033 179,033 0 Small Projects & Equip. (CARES/CRRSA/ARPA Supported) 1,787,087 596,897 33% * 837,457 546,005 65% * 837,457 837,457 0 Transfers to Other Airport Funds 1,000,000 0 0% * 1,000,000 0 0% * 1,000,000 1,000,000 0 Other Airport Expenses 62,188 24,139 39% * 62,188 21,216 34% * 62,188 62,188 0 Year-end GASB68 & GASB75 Retiree Accrual Adjustments 45,000 0 45,000 0 45,000 45,000 0 * * TOTAL EXPENSES 5,639,994$ 1,913,585$ * 4,736,525$ 1,966,223$ * 4,736,525$ 4,806,525$ (70,000)$ * * ENDING UNRESTRICTED NET ASSETS 480,335$ 2,227,943$ * 415,457$ 3,668,910$ * 415,457$ 2,582,615$ (2) FOOTNOTES: 1) Beginning Net Assets agrees with the Comprehensive Annual Financial Report (CAFR) with the following adjustment: 53,593,733$ (13,347,909)$ Total Revenues 5,083,982$ 40,245,824$ Total Expenses 4,806,525$ FY2024 Surplus 277,457$ 2) FY 2024 Ending Unrestricted Net Assets is comprised of the following: 130,359$ ($88,131.96 beginning + $42,226.90 year end addition to reserve) 141,142$ (encumbrances carried forward to FY2024) (830,555)$ (net liability as of the end of FY2023) (659,769)$ (net liability as of the end of FY2023) 1,742$ (net receivables as of 6/30/23) 3,799,696$ 2,582,615$ GASB87 Net Lease Receivables FY2024 Projected TotalsTotal Net Assets per CAFR 6/30/23 Less: Net Assets in Capital & PFC Funds Undesignated Retained Earnings Total Beginning Net Assets Des. for Maintenance (Rental Car Facility) Reserve for Encumbrances at Year-end GASB68 Pension-related Accrual GASB75 Other OPEB Obligations 2/20/2024 Page 15 of 73 February 27, 2024 Finance Committee City Council City of Lynchburg Lynchburg, Virginia RE: December 31, 2023, Quarterly Financial Report - Lynchburg Regional Juvenile Detention Center Lynchburg Regional Juvenile Detention Center The attached Lynchburg Regional Juvenile Detention Center (Detention Center) financial report summarizes the financial activities through December 31, 2023, for FY 2024. The financial spreadsheet provid es comparative year-to-date data for the same period of FY 2023. REVENUES Charges for Services Revenue in this category for the second quarter of FY 2024 is $1,108,191 or 53.0% of the budget. Department of Juvenile Justice Block Grant This revenue category represents allocations from the Virginia Department of Juvenile Justice (DJJ) for operational expenses of the Detention Center. Revenues received from the DJJ through the second quarter of FY 2024 are $553,514 or 53.0% of the budget. United States Department of Agriculture (USDA) This revenue category consists of reimbursements for meals served to juveniles at the Detention Center. Year- to-date revenues from USDA for FY 2024 are $28,716 or 71.8% of the budget. Miscellaneous and State Ward Per Diem Revenue in this category for the second quarter of FY 2024 is $6,050. EXPENDITURES Overall expenditures for the second quarter of FY 2024 were $1,614,489 or 50.6% of the budget. Page 16 of 73 Finance Committee January 23,2024 Page 2 Juvenile Population The average number of juveniles being served per day through the second quarter of FY 2024 is 21 as compared to 11 in FY 2023. The percentage of Lynchburg City’s juveniles through the second quarter is 67% of the total juvenile population. SUMMARY The Lynchburg Regional Detention Center is recognized for providing educational services, mental health services, physical health services, and partnerships with local area businesses. The total revenue through the second quarter is $1,696,471 and the total expenditures are $1,614,489. Respectfully submitted, Preston Sellers Director, Department of Human Services c: Wynter Benda, City Manager Gregory Patrick, Deputy City Manager Kent White, Assistant City Manager Donna Witt, Director, Financial Services Sherry McIntyre, Accountant, Juvenile Services Page 17 of 73 FY 2023 FY 2023 FY 2023 FY 2024 FY 2024 FY 2024 FY 2024 FY 2024 FY 2024 Amended Actual % of Amended Actual % of Amended Actual Actual to Budget 2nd QTR YTD Budget Budget 2nd QTR YTD Budget Budget 2nd QTR YTD Amended Beginning Funds at July 1 321,805 222,460 Revenues: Charges for Services 1,596,689 625,720 39.2% 2,090,687 1,108,191 53.0% 2,090,687 1,108,191 982,496 Intergovernmental- Department of Juvenile Justice Block Grant 1,017,086 532,338 52.3% 1,044,329 553,514 53.0% 1,044,329 553,514 490,815 Intergovernmental- USDA 40,000 22,918 57.3% 40,000 28,716 71.8% 40,000 28,716 11,284 Community Placement Program (CPP) 850,000 0 0.0% 0 0 0.0% 0 0 0 Miscellaneous and State Ward Per Diem 1,400 3,150 0.0% 1,400 6,050 432.1% 1,400 6,050 (4,650) Total Revenues 3,505,175 1,184,126 33.8% 3,176,416 1,696,471 53.4% 3,176,416 1,696,471 1,479,945 Expenditures: Salaries 1,835,184 690,351 37.6% 1,696,960 880,342 51.9% 1,696,960 880,342 816,618 Employee Benefits 834,407 276,735 33.2% 748,739 321,038 42.9% 748,739 321,038 427,701 Contractual Services 52,374 20,293 38.7% 70,194 27,849 39.7% 70,194 27,849 42,345 Fleet Services 14,868 4,825 32.5% 8,280 6,943 83.9% 8,280 6,943 1,337 Supplies and Materials 201,900 51,693 25.6% 159,700 106,063 66.4% 159,700 106,063 53,637 Utilities 80,750 30,787 38.1% 67,687 34,773 51.4% 67,687 34,773 32,914 Training and Conferences 23,739 661 2.8% 6,050 349 5.8% 6,050 349 5,701 Telephone Services 6,540 3,381 51.7% 7,000 3,378 48.3% 7,000 3,378 3,622 Cable/Satellite TV Service 1,825 891 48.8% 1,200 492 41.0% 1,200 492 708 Postage and Mailing 850 45 5.3% 850 66 7.8% 850 66 784 Indirect Costs 272,270 136,135 50.0% 281,188 140,594 50.0% 281,188 140,594 140,594 Self Insurance 24,310 24,310 100.0% 32,185 32,185 100.0% 32,185 32,185 0 Dues and Memberships 500 0 0.0% 1,000 0 0.0% 1,000 0 1,000 Misc. Other Charges 26,367 199 0.8% 6,000 334 5.6% 6,000 334 5,666 Rentals and Leases 4,309 1,637 38.0% 3,410 486 14.3% 3,410 486 2,924 Specific Use Equipment 0 0 0.0% 0 14,586 100.0% 0 14,586 (14,586) Health and Dental Benefits for Retirees 63,168 30,000 47.5% 63,168 31,584 50.0% 63,168 31,584 31,584 Unemployment Compensation 1,000 0 0.0% 1,000 0 0.0% 1,000 0 1,000 Workers Comp Indemnity Pymt 10,000 0 0.0% 10,000 0 0.0% 10,000 0 10,000 Professional Services 5,276 4,728 89.6% 13,061 4,778 36.6% 13,061 4,778 8,283 Serial Bond Principal 7,000 7,000 100.0% 7,175 7,175 100.0% 7,175 7,175 0 Serial Bond Interest 3,124 1,649 52.8% 2,770 1,474 53.2% 2,770 1,474 1,296 TrTo Int Ser Fleet Fund 35,410 0 0.0% 0 0 0.0% 0 0 0 Total Expenditures 3,505,171 1,285,320 36.7% 3,187,617 1,614,489 50.6% 3,187,617 1,614,489 1,573,128 TOTAL FUND BALANCE 220,611 304,442 Lynchburg Regional Juvenile Detention Center Special Revenue Fund Financial Summary Second Quarter: As of December 31, 2023 Page 18 of 73 February 27, 2024 Finance Committee City Council City of Lynchburg Lynchburg, Virginia Re: Children’s Services Act (CSA) Fund Financial Report for the period ending December 31, 2023. The attached CSA Fund Financial Summary outlines the financial activity through December 31, 2023. Under the State guidelines, CSA prior year obligations are paid through September 30th of each year. However, the annual budget is prepared on a fiscal year basis (July-June). Because of the State guidelines, expenditures for this fund are unique due to the overlap of grants each fiscal year. REVENUES • Public Assistance – Welfare and Administration The Public Assistance revenue source is the reimbursement received from the State for local expenses incurred under CSA for providing services to at -risk youth and their families. The current rate of reimbursement for community-based services is 86.32%, residential services is 65.8%, and for all other services, 72.64%. o State of Virginia reimbursements for the Ch ildren’s Services grant through the 2nd quarter are $2,394,665 or 50.5% of the adopted FY24 budget. • CSA Contribution – General Fund and Schools o Required local match for all State funds received through the 2nd quarter of FY24; $98,270 or 50% from the City of Lynchburg Schools and $1,294,794 or 55.4% from the City of Lynchburg General Fund have been received. • Miscellaneous Revenue/Budget Designations o Miscellaneous Revenue is comprised of CSA parental co -payments, child support and recoupments from social security payments. Revenue received through the 2nd quarter of FY24 was $11,265 or 23.2% of the adopted FY24 budget. Page 19 of 73 Finance Committee February 27, 2024 Page 2 EXPENSES • Administrative expenses o CSA administrative expenses comprised of salaries and supplies. Expenditures through the 2nd quarter of FY24 were $35,212 or 45.0% of the adopted FY24 budget. • Sum-Sufficient– Foster Care o Foster care expenses comprise residential facilities, day care, maintenance and enhanced payments to foster parents and foster care prevention services. Expenditures through the 2nd quarter of FY24 were $1,544,198 or 46.1% of the adopted FY24 budget. • Sum-Sufficient– Special Education o Special education expen ditures comprised of Special Education to students for the City of Lynchburg Schools. Expenditures can increase and decrease due to enrollments in private day placement schools. Expenditures through the 2nd quarter of FY24 were $1,566,627 or 53.9% of the adopted FY24 budget. • Non-Sum Sufficient Services (Non-Mandated) o Non-Sum Sufficient expenditures are comprised of counseling, mentoring, crisis intervention, and foster care prevention services. E xpenditures through the 2nd quarter of FY 2024 were $8,215 or 2.2% of the adopted FY24 budget. Non-Sum Sufficient services are provided almost exclusively to youth involved in the c ourt system. The Court Services are accessing alternate funding for court-involved youth to decrease expenditures in this category. • Community Base (Sum/Non-Sum Sufficient) Services o Community services may include assessment, crisis stabilization, therapy, or intervention services provided in the child’s home. Community Based Services through the 2nd quarter of FY 2024 total $283,130, or 46.7% of the adopted FY24 budget. Page 20 of 73 Finance Committee February 27, 2024 Page 3 SUMMARY While the number of children currently in foster care fluctuates during the year, more children fall into the “Sum-Sufficient” mandated classification and access CSA funds due to the severity of their needs. Other factors impacting the budget can be an increase of children receiving more intensive services for extended periods, increased vendor rates, parental agreements, and an increase in special educational services. Respectfully submitted, Preston Sellers Director of Human Services c: Wynter Benda, City Manager Gregory Patrick, Deputy City Manager Kent White, Assistant City Manager Donna Witt, Director of Financial Services Rhonda Allbeck, Assistant Director of Financial Services Kathy Collins, Financial Professional IV Page 21 of 73 FY 2023 FY 2023 FY 2023 FY 2024 FY 2024 FY 2024 Amended Actual 2 QTR % of Amended Actual 2 QTR % of Budget YTD Budget Budget YTD Budget Beginning Fund Balance 362,856 0 84,739 Revenues: Public Assistance - Welfare and Administration 4,638,778 2,159,135 46.5% 4,738,816 2,394,665 50.5% Transfer from Lynchburg City Schools 196,541 98,270 50.0% 196,541 98,270 50.0% Transfer from General Fund 2,039,543 1,019,772 50.0% 2,336,588 1,294,794 55.4% Miscellaneous/Special Welfare 48,700 12,249 25.2% 48,650 11,265 23.2% Budget Designations 0 0 0 0 0.0% Total Revenues 6,923,562 3,289,426 47.5% 7,320,595 3,798,994 51.9% Expenses: Administrative Expenses 71,917 33,231 46.2% 78,323 35,212 45.0% Sum-Sufficient - Foster Care 2,932,330 1,512,953 51.6% 3,351,750 1,544,198 46.1% Sum-Sufficient - Special Education 2,821,658 1,414,206 50.1% 2,908,865 1,566,627 53.9% Non-Sum Sufficient Services 375,907 9,285 2.5% 375,907 8,215 2.2% Sum-Sufficient and Non-Sum Sufficient Services 721,750 188,468 26.1% 605,750 283,130 46.7% Miscellaneous/Budget Designations/Transfer to GF 0 0 0 0 Total Expenditures 6,923,562 3,158,143 45.6% 7,320,595 3,437,382 47.0% ENDING FUND BALANCE 0 494,139 0 446,351 Children's Services Act Special Revenue Fund Financial Summary December 31, 2023 Page 22 of 73 February 27, 2024 Finance Committee City Council City of Lynchburg Lynchburg, Virginia Re: December 31, 2023 Quarterly Financial Report – Water Operating Fund The attached Water Operating Fund Financial Summary summarizes the financial activity for this f und through December 31, 2023. This quarterly report provides comparative financial information for the same period of the prior fiscal year . Projected v ariances between the FY 2024 Adopted Budget and the Department’s year-end projections are described below. REVENUES Following the completion of the second quarter, overall revenues for FY 2024 are projected to be $245,400 (1.4%) more than budget. Explanations of this variance follow: • Charges for Services: Revenue in this category is projected to be $230,300 (1.6%) more than budget. This is primarily due to more than expected revenues from water connections, availability fees, water cost plus, and non- contract water sales combined for $219,300. • Water Contracts: Revenue in this category reflects billing activity to the counties of Amherst, Bedford, and Campbell, and to the industries of CertainTeed and Frito-Lay. Revenue is projected to be $139,900 (5.8%) less than budget. This is primarily due to Cer tainTeed’s, Frito -Lay’s and Campbell County’s decreased water purchases. • Interest and Other: Interest and Other is projected to be $155,000 (42.8%) more than budget. This is mostly due to higher than anticipated interest rates on investments. EXPENSES Overall expenses for FY 2024 are projected to be $356,500 (1.8%) over budget. Explanations of this variance follow: Page 23 of 73 Finance Committee February 27, 2024 Page 2 • Departmental Operation and Maintenance: Departmental Operation and Maintenance expenses are projected to be $656,600 (5.2%) over budget. This category includes the Water Treatment Plant, Meter Operations, Water Line Maintenance and Administration. (Water Treatment - $349,200 over budget, Meter Operations - $29,100 savings, Water Line Maintenance – $337,500 over budget, Administration - $1,000 savings). This variance is broken down as follows:  Personnel Services and Benefits $34,000  Chemicals (142,000)  Utilities (150,500)  Supplies and Materials (130,900)  Contractual Services (115,750)  All Other (151,450) Total ($656,600) The savings in Personnel Services and Benefits is mostly related to past and current unfilled positions. Chemicals and Utilities are over budget due to recent dry weather period beginning in last summer to December. The average annual water pumped from James River over the previous nine years was 3.9%. The first six months of this fiscal year the average monthly use from James River was 30.4%. Supplies and Materials increase is primarily due to a n increase in parts costs and parts use d for repairs of the water distribution system. Contractual Services budget overrun is due to high cost to repair a water main break in a vault on the north side of James River and legal services needed to secure water rights to the James River. All Othe r increase is mostly associated with the water main break on Commerce Street resulting in damages to Bluffwalk’s sidewalk and landscape. • Non-Departmental Operation and Maintenance: Non-Departmental Operation and Maintenance expenses are projected to be at budget. • Capital Outlay: Purchases in this category are projected to be $52 ,100 (35.7%) under budget. This is associated with the following items: 1) Obtaining a replacement copier and printer using a five -year lease approach rather than straight purchase. 2) A dditional vehicle that was scheduled to arrive in FY 2024 will not arrive until FY 2025. • Transfers to Capital: Transfers to Capital are projected to be at budget. Page 24 of 73 Finance Committee February 27, 2024 Page 3 • Debt Service: Expenditures in debt service a re projected to be $248,000 (6.1%) under budget. This is mostly due to lesser use of line of credit proceeds planned for several large projects that had beginning construction dates deferred resulting in $201,000 savings. Many of these large projects were impacted by additional time required for resolution to easement issues. One project was bid with costs that significantly exceeded cost estimate and thus required a rebid. Another project was delayed due to a of hold up of rail road permits. Additional savings of $62,000 in the first year’s payment of principal and interests costs of the 2023 General Obligation Bonds Issuance was incurred due to less than expected borrowings. SUMMARY The second quarter report reflects a stable FY 2024 financial posit ion for this fund. Under the Council adopted financial policies two important financial ratios are included, debt coverage ratio and fund balance ratio. The projected debt coverage ratio for the fiscal year i s projected to be 1.19, which is below Council’s financial policy minimum target of 1.20. The projected fund balance ratio for the fiscal year i s 31% compared to the target range of 25% - 40%. Due to the projected fund balance ratio of 31%, and projected debt service coverage ratio to recover to a minimum of 1.20 in FY 2025 budget year the Water Fund is deemed to be stable. Respectfully submitted, Timothy A. Mitchell, P.E. Director of Water Resources cc: Wynter Benda, City Manager Greg Patrick, Deputy City Manager Donna Witt, Chief Financial Officer Page 25 of 73 WATER OPERATING FUND FINANCIAL SUMMARY Quarter Ending December 31, 2023 FY 2024 FY 2023 FY 2023 FY 2023 FY 2024 FY 2024 FY 2024 FY 2024 FY 2024 $ Variance Adopted Actual % of Adopted Actual % of Adopted Projection Adopted Budget Budget Q2 YTD Budget Budget Q2 YTD Budget Budget vs. Projected REVENUES: Charges for Services $13,979,043 $6,494,245 46% $14,860,284 $7,074,625 48% $14,860,284 $15,090,584 $230,300 Water Contracts 2,192,970 1,045,947 48% 2,428,678 1,074,351 44% 2,428,678 2,288,778 (139,900) Interest and Other 25,500 163,526 641% 362,500 306,230 84% 362,500 517,500 155,000 $16,197,513 $7,703,718 $17,651,462 $8,455,206 $17,651,462 $17,896,862 $245,400 EXPENSES Departmental O&M $11,897,363 $5,504,426 46% $12,536,401 $6,465,761 52% $12,536,401 $13,193,001 ($656,600) Non-Departmental O&M 249,636 99,123 40% 306,714 100,670 33% 306,714 306,714 - Capital Outlay/Purchases 47,000 - 0% 146,000 30,886 21% 146,000 93,900 52,100 Transfers to Capital 2,000,000 1,000,000 50% 2,400,000 1,200,000 50% 2,400,000 2,400,000 - Debt Service 3,404,650 1,799,406 53% 4,037,167 1,897,177 47% 4,037,167 3,789,167 248,000 $17,598,649 $8,402,955 $19,426,282 $9,694,494 $19,426,282 $19,782,782 ($356,500) Adjustment for Expenses from Capital Projects: $0 $0 $0 KEY RATIOS: Unrestricted cash target range as a % of operating expenses & debt service: 25% - 40% Unrestricted cash as a % of operating expenses & debt service: 31% Financial Policy targeted debt coverage ratio minimum: 1.20 Ending debt coverage ratio: 1.19 (a) Note (a) Calculation of debt coverage includes $125,000 of capitalizable costs for internal labor charges applicable to time spent on capital project activities. Page 26 of 73 February 27, 2024 Finance Committee City Council City of Lynchburg Lynchburg, Virginia Re: December 31, 2023 Quarterly Financial Report – Sewer Operating Fund The attached Sew er Operating Fund Financial Summary summarizes the financial activity for this fund through December 31, 2023. This quarterly report provides comparative financial information for the same period of the prior fiscal year . Projected v ariances between the FY 202 4 Adopted Budget and the Department’s year-end projections are described below. REVENUES Following the completion of the second quarter, overall revenues for FY 202 4 are projected to be $1,164,400 (3.8%) greater than budget. Explanations of this variance follow: • Charges for Services: Revenue in this category is projected to be $356,000 (1.4%) over budget mostly attributable to the following: 1) Inside City Sewer Sales increase of $188,000 related to domestic, commercial and industrial, customers. 2) Industrial Surcharges increase of $38,000. 3) Connection and Availability Fees increase of $115,000. • Sewer Contracts: Revenue in this category reflects billing activity in the counties of Amherst, Bedford, and Campbell and the industries of CertainTeed and Frito-Lay. Revenue is projected to be $332,900 (6.9%) over budget. Due to significant cost increases at Water Resources Recovery Facility (WRRF), counties of Amherst, Bedford and Campbell all recently consented to increase their monthly sewer operating billings to cover their shared allocations of plant operating cost. These billing increases are projected to be $253,000 more than budget. County reimbursements of WRRF FY 2023 completed projects are expected to be $123,900 over budget. This is directly related to two counties elected to reimburse the City 100% of their share of FY 2023 completed projects with PayGo rather than financing these projects under the terms of the City’s latest bond issuance. These increases in revenue are offset by a projected decrease in CertainTeed’s sewer sales of $144,000. Page 27 of 73 Finance Committee February 27, 2024 Page 2 • Interest and Other: Revenue in this category is projected to be $475,500 (88.6%) greater than budget. This is primarily due to higher than anticipated interest rates on investments. EXPENSES Overall expenses for FY 20 24 are projected to be $274,400 (.9%) less than budget. Explanations of this variance follow: • Departmental Operation and Maintenance: Departmental Operation and Maintenance expenses are projected to be $127,400 (.7%) less than budget. This category includes the Water Resources Recovery Facility (WRRF) and Sewer Line Maintenance. The WRRF is projected to have $203,400 savings and Sewer Line Maintenance is projected to be $76,000 over budget. These variances are broken down as follows:  Personnel Services and Benefits $ (45,000)  Utilities 50,000  Chemicals 45,000  Supplies and Materials 104,300  Contractual Services 53,700  All Other (80,600) Total $127,400 Personnel and Benefits is projected to be over budget as a result of required overtime of utility line technicians responding to emergency sewer line repairs. Utility and Chemical budgets were based on two previous years trend of significant chemical increases and last year’s electrical rate increase of over 30%. Chemical pricing has stabilized as of the last contract renewal and recent electricity rate increase was approximately 1%. The savings in Supplies and Materials is primarily associated with decrease purchases for replacement tools and a n upcoming regulatory requirement to begin testing for PFAS chemicals that was budgeted for FY 2024. We are now certain testing will begin after this fiscal year. Savings in Contractual Services is mostly related to a digester study budgeted in the Sewer Operating Fund. Due to projects that will be resulting from this study, funding for this study will be funded in the Sewer Capital Fund . Increase in All Other is associated from accelerating the schedule to update OSHA’s requirement of proper lockout/tagout practices and procedures that safeguards works from hazardous electrical energy releases. • Non-Departmental Operation and Maintenance: Non-Departmental Operation and Maintenance expenses are projected to be at budget. • Capital Outlay: Page 28 of 73 Finance Committee February 27, 2024 Page 3 Purchases in Capital Outlay are projected to be $80,000 (10.7%) under budget. Due to significantly increased costs to purchase a track -hoe, decision was made to continue renting a track -hoe on an as needed basis. • Transfers to Capital: Transfers to Capital are projected to be at budget. • Debt Service: Expenditures in debt service are projected to be $67,000 (0.7%) below budget due to less than expected first year’s payment of principal and interest costs of FY 2023 General Obligation Bond Issuance and slightly less than expected use of line of credit proceeds to fund sewer projects. SUMMARY This second quarter report reflects a stable FY 202 4 financial position for this fund. Under the Council adopted financial policies, two important financial ratios, debt coverage ratio and fund balance ratio are projected to be within policy targets. The projected debt coverage ratio for the fiscal year is 1.46 compared to a target range of 1.20 to 1.50. The projected fund balance ratio for the fiscal year is 33% compared to a target range 25% - 40%. Respectfully submitted, Timothy A. Mitchell, P.E. Director of Water Resources cc: Wynter Benda, City Manager Greg Patrick, Deputy City Manager Donna Witt, Chief Financial Officer Page 29 of 73 SEWER OPERATING FUND FINANCIAL SUMMARY Quarter Ending December 31, 2023 FY 2024 FY 2023 FY 2023 FY 2023 FY 2024 FY 2024 FY 2024 FY 2024 FY 2024 $ Variance Adopted Actual % of Adopted Actual % of Adopted Projection Adopted Budget Budget Q2 YTD Budget Budget Q2 YTD Budget Budget vs. Projected REVENUES: Charges for Services $23,046,719 $10,288,150 45% $25,011,633 11,376,193 45% $25,011,633 $25,367,633 $356,000 Sewer Contracts 4,470,778 2,054,221 46% 4,834,550 1,996,102 41% 4,834,550 5,167,450 332,900 Interest and Other 30,870 295,330 957% 537,000 711,080 132% 537,000 1,012,500 475,500 $27,548,367 $12,637,701 $30,383,183 $14,083,375 $30,383,183 $31,547,583 $1,164,400 EXPENSES: Departmental O&M $14,716,969 $6,849,623 47% $17,999,795 $8,265,673 46% $17,999,795 $17,872,395 $127,400 Non-Departmental O&M 264,907 99,600 38% 334,202 103,652 31% 334,202 334,202 - Capital Outlay/Purchases 715,000 380,715 53% 745,000 96,596 13% 745,000 665,000 80,000 Transfers to Capital 3,300,000 1,651,750 50% 3,600,000 1,800,000 50% 3,600,000 3,600,000 - Debt service 8,820,175 4,676,037 53% 9,348,718 4,774,757 51% 9,348,718 9,281,718 67,000 $27,817,051 $13,657,725 $32,027,715 $15,040,678 $32,027,715 $31,753,315 $274,400 Adjustment for Expenses from Capital Projects $0 $0 $0 KEY RATIOS: Unrestricted cash target range as a % of operating expenses & debt service: 25% - 40% Unrestricted cash as a % of operating expenses & debt service: 33% Financial Policy targeted debt coverage ratio minimum: 1.20 Ending debt coverage ratio: 1.46 (a) Note (a) Calculation of debt coverage includes estimated $164,000 of capitalizable costs for internal labor charges applicable to time spent on capital project activities. Sewer Operating 2/20/2024 Page 30 of 73 February 27, 2024 Finance Committee City Council City of Lynchburg Lynchburg, Virginia Re: December 31, 2024 Quarterly Financial Report – Stormwater Operating Fund The attached Stormwater Operating Fund Financial Summary summarizes the financial activity for this fund through December 31, 2023. This quarterly report provides comparative financial information for the same period of the prior fiscal year. Projected v ariances between the FY 2024 Budget and the Department’s year-end projections are described below. REVENUES Following the completion of the second quarter, the overall revenues for FY 2024 are projected to exceed budget by $32,000 (.8%). Explanations of this variance follow: • Charges for Services: Revenue in this category reflects billing activity for all known impervious areas, Virginia Stormwater Management Program (VSMP) permits and delinquent charges on past due accounts. Charges for Services are projected to be under budget by $8,000 (0.2%). This is mostly associated from a refund for overbilling an institutional customer since 2015. • Interest and Other: Interest and Other is projected to exceed budget by $40,000 (64.5%). This is primarily due to higher than expected interest revenue on investments. • Transfers from Other Funds: Transfers from General Fund are projected to be at budget. EXPENSES Overall expenses for FY 2024 are projected to be $190,300 (4.2%) below budget. Explanations of this variance follow: Page 31 of 73 Finance Committee February 27, 2024 Page 2 • Departmental Operation and Maintenance: Departmental Operation and Maintenance is projected to be $39,300 (1.1%) below budget. This variance is broken down as follows:  Internal Services ($8,000)  Contractual Services 77,450  Supplies and Materials 21,600  Public Works and Community Development (44,000)  All Other ($7,750) Total $39,300 Internal Services is expected to be greater than budget due to higher than expected vehicle repairs. Savings in Contractual Services is related to the following: 1) Several planned outfall repairs have been determined that outfall replacements are needed and will be funded in Stormwater Capital Fund. 2) Savings in Engineering Costs related to municipal separate storm sewer system (MS4) permit. Supplies and Materials are less than budget due to savings in lab supplies and ground maintenance supplies. Public Works and Community Development costs is expected to be greater than budget due to greater volume of leaf collection and increased costs of temporary staffing. Non-Departmental Operation and Maintenance: Non-Departmental Operation and Maintenance expenses are projected to be at budget. • Capital Outlay: Capital Outlay is projected to be at budget. • Transfers to Capital: Transfers to Capital are projected to be at budget. • Debt Service: Debt Service expenditures are projected to be $ 151,000 (29.2%) under budget. This is mostly attributable to lesser use of line of credit proceeds. Lesser use of line of credit proceeds are the result from the delay of College Park Stormwater Rehabilitation Project and several other projects needing easement issues to be resolved. SUMMARY The second quarter report reflects a stable FY 2024 financial position for this fund. Under the Council adopted financial policies, two important financial ratios, debt coverage ratio and fund balance ratio are projected to be above policy targets. The projected debt coverage ratio for the fiscal year is 2.10, which is above Council’s financial policy minimum target of 1.20. The projected fund balance ratio for the fiscal year is 31% compared to the target range of 15%- 20%. Page 32 of 73 Finance Committee February 27, 2024 Page 3 Respectfully submitted, Timothy A. Mitchell, P.E. Director of Water Resources cc: Wynter Benda, City Manager Greg Patrick, Deputy City Manager Donna Witt, Chief Financial Officer Page 33 of 73 STORMWATER OPERATING FUND FINANCIAL SUMMARY Quarter Ending December 31, 2023 FY 2024 FY 2023 FY 2023 FY 2023 FY 2024 FY 2024 FY 2024 FY 2024 FY 2024 $ Variance Adopted Actual % of Adopted Actual % of Adopted Projection Adopted Budget Budget Q2 YTD Budget Budget Q2 YTD Budget Budget vs. Projected REVENUES: Charges for Services $3,554,750 $1,548,651 44% $3,841,830 $1,640,360 43% $3,841,830 $3,833,830 ($8,000) Interest and Other 8,000 63,854 798% 62,000 61,104 99% 62,000 102,000 40,000 Transfers from Other Funds 275,000 137,500 50% 275,000 137,500 50% 275,000 275,000 - $3,837,750 1,750,004 $4,178,830 $1,838,964 $4,178,830 $4,210,830 $32,000 EXPENSES: Departmental O&M $3,623,518 $1,641,329 45% $3,511,231 $1,750,410 50% $3,511,231 $3,471,931 $39,300 Non-Departmental O&M 26,210 37,707 144% 28,776 12,740 44% 28,776 28,776 - Capital Outlay/Purchases - 8,750 - - - - - Transfers to Capital 270,000 135,000 50% 500,000 250,000 50% 500,000 500,000 - Debt Service 187,854 26,481 14% 517,718 193,029 37% 517,718 366,718 151,000 $4,107,582 $1,849,267 $4,557,725 $2,206,179 $4,557,725 $4,367,425 $190,300 Adjustment for Expenses from Capital Projects $0 $0 $0 KEY RATIOS: Unrestricted cash target range as a % of operating expenses & debt service 15% - 20% Projected unrestricted cash as a % of operating expenses at year end 31% Financial Policy targeted debt coverage ratio minimum: 1.20 Ending debt coverage ratio: 2.10 (a) Note (a) Calculation of debt coverage includes $60,000 of estimated capitalizable costs for internal labor charges applicable to time spent on capital project activities. Page 34 of 73 February 27, 2024 Finance Committee City Council City of Lynchburg Lynchburg, Virginia Re: December 31, 2023 Quarterly Report - General Fund Please find attached the Financial Summary for the City’s General Fund (Fund) for the period ending December 31, 2023. This quarterly report provides comparative information for the same period of the prior fiscal year and an annualized projection through the end of the current fiscal year. NON-DEDICATED REVENUES • Real Estate Taxes: Real Estate taxes are due in four quarterly installments on November 15, January 15, March 15, and May 15. As of the date of this report, only the first installment for FY 2024 has been billed, and revenue (less tax relief) of $28,186,052 has been collected. The amount collected includes payments made for the entire year. Economic Development tax incentive payments totaling $ 172,427 have been paid during the fiscal year. • Personal Property Taxes: Personal Property tax revenue collected through the second quarter of FY 2024 is $11,760,120, which is 53.0% of the fiscal year budget . This amount is $232,745 more than the amount collected through the second quarter of FY 2023. Personal property taxes are payable in two equal installments on June 5 and December 5. Additional billings for personal property acquisitions are due March 5 and September 5. Economic Development tax incentive payments totaling $ 31,109 have been paid during the fiscal year. In 1998, the Virginia General Assembly enacted t he Personal Property Tax Relief Act (PPTRA) to reimburse citizens for a portion of the local personal property tax . In the 2004 Virginia General Assembly, the State capped the amount reimbursed to localities at $950 million for tax years 2006 and after. This action resulted in Lynchburg’s share being set at $5,543,584. During the second quarter of FY 2024 the State reimbursed the City 75% as scheduled, bringing the year to date total to $4,434,867. Future payments will be received in February 2024 (15%), and May 2024 (5%). • Consumer Utility Tax - Electric: Consumer Utility Tax – Electric revenue of $ 1,435,115 has been received through collections for 5 months, which is 41.0% of the fiscal year budget . Staff is monitoring this revenue and providing the Finance Committee with monthly updates. Page 35 of 73 Finance Committee Lynchburg City Council February 27, 2024 Page 2 • Communication Sales and Use Taxes: Communication Sales and Use tax revenue of $741,346 has been received, which is 37.1% of the fiscal year budget. • Local Sales Tax: Sales tax revenue of $7,145,247 has been received through collections for 4 months, which is 30.9% of the fiscal year budget. Economic Development tax incentives totaling $123,279 have been paid. • Business License Business License revenue collected through the second quarter of FY 2024 is $307,283. Since this tax is due May 1, the collection percentage is currently only a small part of the annual budget. The majority of the tax will be collected from March to May. Economic Development tax incentive payments totaling $33,394 have been paid during the fiscal year. • Meals Tax Meals tax revenue of $8,394,314 has been received through collections for 5 months, which is 41.4% of the fiscal year budget. Economic Development tax incentives totaling $385,472 have been paid. • Lodging Tax Lodging tax revenue of $1,704,785 has been received through collections for 5 months, which is 45.2% of the fiscal year budget. Economic Development tax incentives totaling $390,065 have been paid. • Permit, Fees, and Licenses: Permit, Fees, and Licenses revenue of $ 668,241 has been received, which is 61.4% of the fiscal year budget. • Fines and Forfeitures: Fines and Forfeitures revenue of $133,957 has been received, which is 48.3% of the fiscal year budget. The timing of receiving court fines and parking fines varies greatly throughout the year, and s taff will continue to keep a close watch on this revenue to see if an adjustment in projected revenue is necessary. Page 36 of 73 Finance Committee Lynchburg City Council February 27, 2024 Page 3 • Interest on Investments: Investment income of $3,651,166 has been received, which is 155.9% of the fiscal year budget. • Charges for Services Charges for Services revenue of $5,792,562 has been received, which is 55.2% of the fiscal year budget. DEDICATED REVENUES Intergovernmental Revenues (consisting of Constitutional Officers, Health and Human Services, and State & Federal subsidies) of $21,423,297 have been received, which is 51.8% of the fiscal year budget. The timing of submitting and receiving reimbursements for constitutional offices impacts these revenues. EXPENDITURES • Operating Expenditures: Expenditures of $102,773,757 have been spent through the second quarter of FY 2024, which is 49.9% of the fiscal year budget. • Debt Service Debt Service expenditures are following the FY 2024 debt schedule. Page 37 of 73 SUMMARY This report represents six months of fiscal activity. As the year progresses, revised estimates for revenues and expenditures will be presented to reflect the impact of changes. Respectfully submitted, Donna S. Witt Chief Financial Officer cc: Wynter C. Benda, City Manager Greg Patrick, Deputy City Manager Rhonda Allbeck, Assistant Director of Financial Services Page 38 of 73 Fiscal Year Fiscal Calendar 2024 Fiscal Quarter of Year (Multiple Items) Fiscal Month of Year (Multiple Items) Fund 1001 General Fund Account Type Revenue Process Status Posted Revenues Adopted Budget Budget Amendment Amended Budget Actual Amount 12.31.23 Remaining Budget w/o Encumbrances Percentage of Amended Budget Actual Amount 12.31.22 100 Taxes 02110.0100 - Current Real Property Tax 66,581,098 - 66,581,098 30,159,185 36,421,913 45.3% 32,116,462 02110.0105 - Tax Relief For Elderly (610,000) - (610,000) (608,225) (1,775) 99.7% (584,786) 02110.0110 - Tax Relief-Rehabilitation Real Property (1,166,030) - (1,166,030) (1,364,908) 198,878 117.1% (1,578,730) 02110.0200 - Delinquent Real Property Tax 700,000 - 700,000 537,257 162,743 76.8% 565,433 02110.0900 - Real Estate Tax- Economic Development Incentive (185,183) - (185,183) (172,427) (12,756) 93.1% (35,821) 02120.0100 - Current PSC Tax 2,700,000 - 2,700,000 2,252,410 447,590 83.4% 2,769,467 02130.0101 - Current Personal Property Tax PCI 22,175,000 - 22,175,000 11,760,120 10,414,880 53.0% 11,527,375 02130.0201 - Delinquent Personal Property Tax PCI 1,500,000 - 1,500,000 274,646 1,225,354 18.3% 193,326 02130.0205 - Recovery-C/O Personal Property Tax - - - 81 (81) 0.0% - 02130.0900 - Personal Property Tax- Economic Development Incentive (21,079) - (21,079) (31,109) 10,030 147.6% (31,184) 02170.0100 - Penalty-PSC Tax - - - 11,816 (11,816) 0.0% 6,855 02170.0105 - Penalty-Delinquent Tax 700,000 - 700,000 352,207 347,793 50.3% 371,058 02170.0205 - Interest-Delinquent Tax 300,000 - 300,000 146,633 153,367 48.9% 183,762 02510.0000 - Local Sales And Use Tax 23,100,000 - 23,100,000 7,145,247 15,954,753 30.9% 7,225,075 02510.0900 - Local Sales & Use Tax- Economic Development Incentive (98,583) - (98,583) (123,279) 24,696 125.1% (117,975) 02515.0100 - Consumer Utility Tax-Electric 3,500,000 - 3,500,000 1,435,115 2,064,885 41.0% 1,478,663 02515.0105 - Consumer Utility Tax-Gas 613,488 - 613,488 156,796 456,692 25.6% 157,929 02515.0120 - Right of Way Fees 225,000 - 225,000 84,128 140,872 37.4% 125,330 02515.0900 - Pen & Int - Consumer Utility Tax, None - - - 1 (1) 0.0% 1 02517.0000 - Communication Sales & Use Tax 2,000,000 - 2,000,000 741,346 1,258,654 37.1% 793,105 02520.0000 - Business License Tax 9,850,000 - 9,850,000 307,283 9,542,717 3.1% 148,044 02520.0010 - Consumption Tax-Electric 307,877 - 307,877 97,525 210,352 31.7% 120,889 02520.0015 - Consumption Tax-Gas 26,698 - 26,698 6,023 20,675 22.6% 8,058 02520.0030 - Pen & Int-Business License 96,072 - 96,072 62,505 33,567 65.1% 61,268 02520.0900 - Business License Tax- Economic Development Incentive (30,176) - (30,176) (33,394) 3,218 110.7% (33,404) 02530.0001 - Motor Vehicle Licenses PCI - - - 154,620 (154,620) 0.0% 175,882 02530.0201 - Delinquent Motor Vehicle License 190,000 - 190,000 22,165 167,835 11.7% 25,282 02535.0000 - Bank Stock Tax 750,000 - 750,000 (266) 750,266 0.0% - 02540.0100 - Recordation Tax-City 675,000 - 675,000 210,513 464,487 31.2% 394,776 02540.0200 - Probate Tax 19,098 - 19,098 16,638 2,460 87.1% 13,974 02545.0000 - Tobacco Tax 800,000 - 800,000 339,520 460,480 42.4% 372,877 02550.0000 - Amusement Tax 900,000 - 900,000 363,888 536,112 40.4% 339,911 02550.0005 - Pen & Int - Amusement Tax - - - 1,561 (1,561) 0.0% 4,607 02555.0000 - Lodging Tax 3,775,000 - 3,775,000 1,704,785 2,070,215 45.2% 1,531,563 02555.0005 - Pen & Int - Lodging Tax - - - 1,410 (1,410) 0.0% 1,240 02555.0900 - Lodging Tax- Economic Development Incentive (342,931) - (342,931) (390,065) 47,134 113.7% (398,618) 02560.0000 - Meals Tax 20,265,000 - 20,265,000 8,394,314 11,870,686 41.4% 7,904,285 02560.0005 - Pen & Int - Meals Tax 49,793 - 49,793 46,948 2,845 94.3% 25,982 02560.0900 - Meals Tax- Economic Development Incentive (314,850) - (314,850) (385,472) 70,622 122.4% (345,420) 100 Taxes Total 159,030,292 - 159,030,292 63,677,538 95,352,754 40.0% 65,516,540 110 Permits, Fees, & Licenses 03005.0000 - Animal Licenses 4,000 - 4,000 1,362 2,638 34.1% 2,742 03010.0200 - Permit Parking Fees 200,000 - 200,000 120,046 79,954 60.0% 109,703 03010.0205 - Permit Parking Fees- Lease Agreement, None 50,000 - 50,000 2,000 48,000 4.0% 26,135 03010.0400 - Land Disturbing Fees 20,000 - 20,000 13,278 6,723 66.4% 8,337 03010.0600 - Transfer Fees 2,000 - 2,000 1,143 857 57.2% 1,281 03010.0700 - Zoning Appeal Fees-Inspc 1,000 - 1,000 - 1,000 0.0% 475 03010.0702 - Zoning Certification Letter 3,500 - 3,500 3,200 300 91.4% 1,500 03010.0705 - Legal Notice Advertising 10,000 - 10,000 4,625 5,375 46.2% 5,546 03010.0710 - Site Plan Reviews 15,000 - 15,000 7,191 7,809 47.9% 8,320 03010.0715 - Conditional Use Permits 3,000 - 3,000 2,843 157 94.8% 1,251 03010.0720 - Re-zoning Fees 8,000 - 8,000 1,967 6,033 24.6% 5,034 03010.0800 - Subdivision Plat Review 14,000 - 14,000 4,245 9,755 30.3% 8,518 03010.0900 - Building Insp Permit Fee 490,000 - 490,000 330,090 159,910 67.4% 223,874 03010.0901 - Elevator Inspect Admin Fee 20,000 - 20,000 8,530 11,470 42.7% 8,741 03010.0902 - Elevator Inspect Admin Fee Pen & Int - - - 112 (112) 0.0% 178 03010.0920 - Sign Inspect Permit Fee 6,000 - 6,000 1,750 4,250 29.2% 3,225 03010.0925 - Demolition Fees 5,000 - 5,000 1,150 3,850 23.0% 4,145 03010.0927 - Building Plan Review 35,000 - 35,000 23,164 11,836 66.2% 18,547 03010.0928 - Vacant Building Registration Fee 30,000 - 30,000 31,184 (1,184) 103.9% 27,659 03010.0929 - Pen & Int-Vacant Building Registration Fee - - - 4,100 (4,100) 0.0% 2,396 03010.0930 - Certificate of Occupancy for Existing Building - - - 975 (975) 0.0% 1,350 03010.0931 - Temporary Certificate of Occupancy, None - - - 5,550 (5,550) 0.0% 5,850 03010.0932 - Working Without a Building Permit - - - 300 (300) 0.0% - 03010.0933 - Short Term Rental Fee, None 15,000 - 15,000 8,850 6,150 59.0% 10,050 03010.0934 - Vacant Property Registration- Civil Penalties, None 18,000 - 18,000 10,648 7,352 59.2% 25,351 03010.0935 - Short Term Rental Program- Civil Penalty, None 3,000 - 3,000 1,000 2,000 33.3% 5,000 03010.0936 - Non-Compliance Penalty, None - - - 1,000 (1,000) 0.0% - 03010.0937 - Derelict- Civil Penalties, None 5,000 - 5,000 - 5,000 0.0% - 03010.1000 - False Alarm Service Assessment 110,000 - 110,000 12,862 97,138 11.7% 23,780 03010.1005 - False Alarm Permit Fee, None - - - 53,166 (53,166) 0.0% - 03010.1100 - Concealed Weapon Permit - - - - - 0.0% 15,727 03010.2005 - Taxicab Application Fees 3,000 - 3,000 750 2,250 25.0% 350 03010.2010 - Precious Metal Premits 1,600 - 1,600 - 1,600 0.0% 400 03010.2011 - Rental Reinspect/FollowUp - - - 1,450 (1,450) 0.0% 450 03010.2012 - Rental Intial Inspection - - - 1,050 (1,050) 0.0% 900 03010.2013 - Annual/Periodic Inspect Fee 15,000 - 15,000 900 14,100 6.0% 700 03010.2014 - Rental Intial Inspect-No Show - - - 850 (850) 0.0% 800 03010.2015 - Rental Inspect- Pre Court - - - 350 (350) 0.0% - 03010.2016 - Rental Inspect-Annual No Show - - - 400 (400) 0.0% - 03010.2020 - Mobile Vendor License Fee 900 - 900 40 860 4.4% 760 03010.2027 - Right of Way Permit Fees, None - - - - - 0.0% - 03010.2028 - Dumpster Permit Fee , None - - - 800 (800) 0.0% 50 03010.2029 - Dumpster Permit Fee- 30 Day Extension, None - - - 250 (250) 0.0% - 03010.2030 - Small Cell Facility (SCF)- Permit Fee, None - - - 50 (50) 0.0% - 03010.2050 - Misc Permit Fee & License - - - 5,022 (5,022) 0.0% 4,241 Page 39 of 73 Revenues Adopted Budget Budget Amendment Amended Budget Actual Amount 12.31.23 Remaining Budget w/o Encumbrances Percentage of Amended Budget Actual Amount 12.31.22 110 Permits, Fees, & Licenses Total 1,088,000 - 1,088,000 668,241 419,759 61.4% 563,365 120 Fines & Forfeitures 03510.0100 - Court Fines And Forfeitures, None 175,000 - 175,000 81,093 93,907 46.3% 26,090 03510.0105 - Criminal Court Fees 2,500 - 2,500 889 1,611 35.5% 946 03510.0200 - Parking Fines 100,000 - 100,000 51,975 48,025 52.0% 53,354 120 Fines & Forfeitures Total 277,500 - 277,500 133,957 143,543 48.3% 80,390 130 Use of Money & Property 04010.0100 - Interest on Investment 1,200,000 - 1,200,000 1,393,895 (193,895) 116.2% 526,158 04010.0101 - Interest-City Capital 700,000 - 700,000 1,035,004 (335,004) 147.9% 104,200 04010.0123 - Interest-Health Ins Resrv - - - 35,085 (35,085) 0.0% 38,819 04010.0124 - Interest-OPEB - - - 13,160 (13,160) 0.0% 13,160 04010.0131 - Interest Income- ARPA Funds Invested at LGIP, None - - - - - 0.0% 447,140 04010.0132 - Interest Income - Nonjudicial Excess Funds, None - - - 1,718 (1,718) 0.0% - 04010.0156 - Interst-MktValueGain/Loss - - - 975,732 (975,732) 0.0% (7,950) 04010.0157 - Interest-SNAP Income - - - - - 0.0% 7,997 04010.0200 - Lease Interest Income, None - - - - - 0.0% (8,562) 04020.0105 - Gen Govt Property Rental 133,893 - 133,893 67,352 66,541 50.3% 63,081 04020.0115 - Public Safety Prop Rent 36,250 - 36,250 - 36,250 0.0% - 04020.0125 - Human Services Prop Rent 100,000 - 100,000 50,000 50,000 50.0% 50,000 04020.0135 - Downtown Parking Deck Lease, None 15,000 - 15,000 2,500 12,500 16.7% 6,900 04020.0200 - Culture & Rec. Prop Rent 15,070 - 15,070 7,535 7,535 50.0% 7,535 04020.0201 - Prop Rental-Stadium 20,000 - 20,000 13,135 6,865 65.7% 8,614 04020.0202 - Prop Rental-Market/Park. 120,000 - 120,000 54,767 65,233 45.6% 52,758 04020.0205 - Market Rent- Pen & Int 1,600 - 1,600 1,132 468 70.8% 517 04020.0207 - Rental of Museum Facilities, None 500 - 500 150 350 30.0% - 130 Use of Money & Property Total 2,342,313 - 2,342,313 3,651,166 (1,308,853) 155.9% 1,310,366 140 Charges for Services 04510.0900 - Collection & Tax Lien Fees 35,000 - 35,000 32,517 2,483 92.9% 38,511 04510.0901 - DMV Admin Fee 280,000 - 280,000 179,083 100,917 64.0% 159,817 04510.0915 - Processng Fee - Payroll deduction 4,000 - 4,000 2,945 1,055 73.6% 2,515 04510.0916 - Indirect Cost&Svc DetHome 281,188 - 281,188 140,594 140,594 50.0% 136,135 04510.0918 - Indirect Cost&Srvc Water 1,205,540 - 1,205,540 602,770 602,770 50.0% 565,402 04510.0919 - Indirect Cost&Srvc Sewer 295,346 - 295,346 139,456 155,890 47.2% 139,337 04510.0920 - Indirect Cost&Srvc WWTP 579,179 - 579,179 297,807 281,372 51.4% 297,554 04510.0921 - Indirect Cost&Srvc Airprt 181,137 - 181,137 90,569 90,569 50.0% 92,052 04510.0922 - Indirect Cost&Svc Strmwtr 343,855 - 343,855 171,928 171,927 50.0% 152,069 04515.0101 - Document Reprod Costs 7,000 - 7,000 4,813 2,187 68.8% 3,837 04515.0200 - Court Room Sheriff Fee, None 66,000 - 66,000 53,007 12,993 80.3% 33,087 04515.0300 - Fees For Court Officers 7,244 - 7,244 7,244 (0) 100.0% 7,244 04515.0301 - Legal Service Charges 40,000 - 40,000 - 40,000 0.0% - 04515.0303 - Probation Supervisor Fee 8,000 - 8,000 5,339 2,661 66.7% 6,926 04515.0304 - Jail Fee, None 1,500 - 1,500 1,214 286 80.9% 1,082 04515.0305 - E-Summons Fee, None 14,000 - 14,000 11,891 2,109 84.9% 7,632 04515.0400 - Commonwealth Atty.Fees 5,000 - 5,000 2,483 2,517 49.7% 2,694 04515.0401 - CA Coll Fees- Gen Dist Ct 55,000 - 55,000 25,143 29,857 45.7% 12,272 04515.0402 - CA Coll Fees- J&D Court 1,050 - 1,050 1,656 (606) 157.7% 2,274 04515.0403 - CA Coll Fees- Circuit Crt 62,600 - 62,600 19,357 43,243 30.9% 26,911 04515.0404 - CA Coll Fees- FOIA Requests, None 2,500 - 2,500 - 2,500 0.0% - 04520.0300 - Fire Prevention Fees 2,000 - 2,000 1,450 550 72.5% 1,450 04520.0301 - Ambulance Service Fees 3,300,130 - 3,300,130 1,364,163 1,935,967 41.3% 1,511,218 04520.0304 - Delinq Ambulance>120 Days 200,000 - 200,000 83,904 116,096 42.0% 61,665 04520.0305 - LFD Off Duty, None - - - 75,705 (75,705) 0.0% 56,417 04520.0306 - LFD Off Duty - Penalty and Interest, None - - - 261 (261) 0.0% 3,709 04520.0307 - Lynchburg Fire Dept Charges, None - - - - - 0.0% 1,038 04520.0308 - Lynchburg Fire Dept Charges- Pen and Int, None - - - - - 0.0% 25 04520.0901 - PIER Contract Payments 26,500 - 26,500 23,000 3,500 86.8% 26,500 04520.0903 - Police-Schools Resource Officer (SRO) Prog 140,000 - 140,000 109,383 30,617 78.1% 63,672 04520.0904 - Local Reimb-COL Confined Space 50,000 - 50,000 25,000 25,000 50.0% 25,000 04520.0905 - Police Report Sales 2,200 - 2,200 1,020 1,180 46.4% 1,458 04520.0906 - Range Use Fee 13,800 - 13,800 13,600 200 98.6% 13,600 04520.0908 - DUI Fees, None - - - 949 (949) 0.0% 2,552 04520.0909 - LPD Off Duty 1,100,000 - 1,100,000 535,513 564,487 48.7% 388,338 04525.0106 - Downtown Parking Fees 35,000 - 35,000 17,516 17,484 50.0% 16,066 04525.0107 - PW Admin Stormwater Charges 165,199 - 165,199 130,595 34,604 79.1% 112,781 04525.0108 - PW Eng Stormwater Charges 12,334 - 12,334 12,007 327 97.4% 11,795 04525.0109 - PW-Leaf Collection Stormwater Charges, None 189,494 - 189,494 152,823 36,671 80.6% 131,157 04525.0218 - Trash Bag Srvc-Waste Zero - - - 44,943 (44,943) 0.0% 46,956 04525.0219 - Landlord Set Out Program , None 6,000 - 6,000 3,163 2,837 52.7% 7,116 04525.0220 - Refuse Disposal Fee, None - - - 412,718 (412,718) 0.0% 1,188,889 04525.0221 - Penalty- Refuse Disposal Fee, None - - - 2,511 (2,511) 0.0% 10,905 04525.0300 - Bldg Maint Charge-Other 10,142 - 10,142 5,071 5,071 50.0% 5,071 04530.0409 - Human Services Court Order Fees - - - 116 (116) 0.0% 1,642 04530.0410 - Lynchburg Youth Group Home Charges 625,000 - 625,000 336,175 288,825 53.8% 297,400 04535.0100 - Swimming Pool Fees 30,000 - 30,000 23,303 6,697 77.7% 16,066 04535.0150 - Recreation Program Fees 461,000 - 461,000 270,476 190,524 58.7% 271,840 04535.0151 - Recreation Program- Scholarship Fees , None - - - 2,794 (2,794) 0.0% 265 04535.0200 - Point of Honor Admission Fees - - - - - 0.0% - 04535.0300 - Library Fines & Fees 10,000 - 10,000 13,840 (3,840) 138.4% 13,413 04535.0301 - Law Library Fees 30,000 - 30,000 14,675 15,325 48.9% 14,380 04535.0303 - Lost/Damaged Library Prop 3,000 - 3,000 1,593 1,407 53.1% 2,242 04535.0304 - Delinq Library Fines & Fees - - - - - 0.0% 10 04535.0305 - Delinq Library Lost/Damaged 5,000 - 5,000 125 4,875 2.5% 2,109 04535.0306 - Delinq Library Pen & Int 1,000 - 1,000 85 915 8.5% 1,248 04540.0103 - Charges For Demolition - - - 4,905 (4,905) 0.0% - 04540.0105 - Comm Develop Stormwater Charges 584,360 - 584,360 292,180 292,180 50.0% 291,466 04540.0108 - Neighborhood Services - Derelict Residential DERR, None - - - 500 (500) 0.0% - 04599.0002 - Secure Vacant Stru Reimb - - - 1,583 (1,583) 0.0% 540 04599.0004 - Neighborhood Services, None 25,000 - 25,000 22,714 2,286 90.9% 16,290 04599.0009 - Penalty and Interest- Neighborhood Services Receivables, None - - - 2,389 (2,389) 0.0% 480 140 Charges for Services Total 10,502,298 - 10,502,298 5,792,562 4,709,736 55.2% 6,304,118 150 Miscellaneous Revenue 05030.0105 - Suspense Revenue/Exp Ref - - - - - 0.0% - 05050.0105 - Pmt In Lieu Tax-WestCntbr 54,438 - 54,438 - 54,438 0.0% - 05050.0110 - Pymt In Lieu of Tax-LRHA 25,000 - 25,000 - 25,000 0.0% - Page 40 of 73 Revenues Adopted Budget Budget Amendment Amended Budget Actual Amount 12.31.23 Remaining Budget w/o Encumbrances Percentage of Amended Budget Actual Amount 12.31.22 05050.0228 - Recreation Program - Donations, None - - - 9,950 (9,950) 0.0% 495 05050.0230 - Friends of Lynchburg Library 18,529 - 18,529 6,348 12,181 34.3% 3,174 05050.0232 - Digg's Trust Rec-Pt Honor 37,000 - 37,000 - 37,000 0.0% 18,500 05050.0400 - Sale-Salvage/Surplus Prop - - - 3,105 (3,105) 0.0% 295 05050.0415 - Proceeds frm PropRoom.com - - - 495 (495) 0.0% 271 05050.2001 - Cash Overage And Shortage - - - (1,197) 1,197 0.0% (2,397) 05050.2011 - Reimb.POH Carriage House 27,000 - 27,000 35,108 (8,108) 130.0% 16,203 05050.2013 - Photo Reprod And Royalty 100 - 100 - 100 0.0% - 05050.2016 - Dedicated Misc Rev HumSvc - - - - - 0.0% - 05050.2025 - Credit Card Rebate 100,000 - 100,000 - 100,000 0.0% - 05050.2028 - WardsCrossingWestSvcFee 143,277 - 143,277 - 143,277 0.0% - 05050.2034 - P&R Spec Event Sponsorship, None 10,000 - 10,000 3,950 6,050 39.5% 9,200 05050.2049 - Residential Trash Violation, None 12,000 - 12,000 10,919 1,081 91.0% 13,141 05050.2055 - Hillcats - Donation Youth Athletic Programs 10,000 - 10,000 10,000 - 100.0% 10,000 05050.2056 - Commission on City Vending Machine Sales - - - 2,620 (2,620) 0.0% 2,095 05050.2059 - Court Restitution, None - - - 531 (531) 0.0% 4,451 05050.2060 - Community Market Retail Sales, None - - - - - 0.0% - 05050.2065 - FOIA Requests, None - - - 46 (46) 0.0% - 05050.2066 - P&R Special Events- GF Support Revenue, None 10,000 - 10,000 - 10,000 0.0% 25,000 05050.2070 - Rehab-Renovation Program Fees, None - - - 12,875 (12,875) 0.0% - 05050.2090 - Miscellaneous Revenue 50,000 - 50,000 63,992 (13,992) 128.0% 224,884 150 Miscellaneous Revenue Total 497,344 - 497,344 158,743 338,601 31.9% 325,312 300 State Non-Categorical Aid 06100.0300 - Rolling Stock Taxes 88,000 - 88,000 95,630 (7,630) 108.7% 88,731 06100.0400 - Mobile Home Titling Taxes 1,000 - 1,000 10,787 (9,787) 1078.7% 1,467 06100.0600 - Deeds Of Conveyance 175,000 - 175,000 73,017 101,983 41.7% 134,217 06100.0900 - Auto Rental Tax-DMV 375,000 - 375,000 289,446 85,554 77.2% 290,268 06100.0905 - Peer to Peer Vehicle Sharing Tax, None 2,500 - 2,500 3,210 (710) 128.4% 3,054 06100.1108 - Personal Prop Tax Relief 5,543,584 - 5,543,584 4,434,867 1,108,717 80.0% 4,434,867 300 State Non-Categorical Aid Total 6,185,084 - 6,185,084 4,906,957 1,278,127 79.3% 4,952,605 310 State Shared Exp (Cat.) 06510.0200 - Commissioner of Revenue 211,517 8,146 219,663 92,268 127,395 42.0% 80,198 06510.0300 - Treasurer 125,536 5,788 131,324 53,691 77,633 40.9% 50,602 06510.1000 - Registrar/Electoral Board 106,350 - 106,350 - 106,350 0.0% - 06515.0100 - Clerk of Cir Crt-Fringes 714,612 45,865 760,477 283,879 476,598 37.3% 279,844 06515.0200 - Sheriff 1,250,032 65,066 1,315,098 535,758 779,340 40.7% 502,593 06515.0400 - Commonwealth Attorney 1,173,058 59,726 1,232,784 493,966 738,818 40.1% 467,017 310 State Shared Exp (Cat.) Total 3,581,105 184,591 3,765,696 1,459,563 2,306,134 38.8% 1,380,254 320 State Categorical Aid 06820.0200 - Juvenile Correct-Block Gt - - - - - 0.0% 123,858 06820.0201 - Wireless E911 400,000 - 400,000 176,162 223,838 44.0% 190,211 06820.0203 - HB 599 Law Enforc.Asst 3,250,000 - 3,250,000 1,884,596 1,365,404 58.0% 1,791,808 06825.0100 - Street And Highway Maint. 9,542,434 - 9,542,434 4,771,217 4,771,217 50.0% 4,771,217 06830.0413 - SS State Adm Sub 0901 1,994,278 6,804 2,001,082 1,122,035 879,047 56.1% 967,898 06830.0414 - SS State Prog Sub 0902 4,909,131 - 4,909,131 1,566,738 3,342,393 31.9% 1,494,236 06835.0102 - SNAP Program Reimb 30,000 - 30,000 18,671 11,329 62.2% 19,365 06835.0300 - Finan Asst-Public Library 204,716 - 204,716 114,196 90,520 55.8% 102,225 320 State Categorical Aid Total 20,330,559 6,804 20,337,363 9,653,615 10,683,748 47.5% 9,460,818 330 State Aid in Suspense 05030.0100 - Suspense Rev-Va EDI Pmts - - - 1,319,718 (1,319,718) 0.0% - 330 State Aid in Suspense Total - - - 1,319,718 (1,319,718) 0.0% - 500 Fed Direct Non-Categorical Aid 07530.0010 - American Rescue Plan Act (ARPA) Funding, None - - - - - 0.0% 13,767,907 500 Fed Direct Non-Categorical Aid Total - - - - - 0.0% 13,767,907 520 Fed Cat Aid- Pass Thru 07830.0420 - Fed Pass Thru:Cost AIIDMG 573,000 - 573,000 - 573,000 0.0% - 07830.0421 - SS Fed Adm Sub 0901 6,354,883 9,396 6,364,279 2,560,928 3,803,351 40.2% 2,238,213 07830.0422 - SS Fed Prog Sub 0902 3,870,010 112,056 3,982,066 1,482,854 2,499,212 37.2% 1,387,165 07830.0428 - Finance-Social Srvc-Fed - - - - - 0.0% 1,003 07830.0430 - USDA Funding - Group Home, None 18,000 - 18,000 14,283 3,717 79.3% 13,144 07875.0003 - Human Service Lease 62,874 - 62,874 5,240 57,634 8.3% 26,198 07875.0021 - FINI Double-Dollars 30,000 - 30,000 20,140 9,860 67.1% 19,231 520 Fed Cat Aid- Pass Thru Total 10,908,767 121,452 11,030,219 4,083,444 6,946,775 37.0% 3,684,954 700 Proceed From Indebtedness 08550.0000 - Proceeds - Line of Credit - 153,950 153,950 153,950 - 100.0% - 700 Proceed From Indebtedness Total - 153,950 153,950 153,950 - 100.0% - 710 Operating Transfers In 09301.0003 - TrfFrmCtyCp-Capital Proj - - - - - 0.0% - 710 Operating Transfers In Total - - - - - 0.0% - Grand Total 214,743,262 466,797 215,210,059 95,659,453 119,550,605 44.4% 107,346,629 Page 41 of 73 Fiscal Year Fiscal Calendar 2024 Fiscal Quarter of Year (Multiple Items) Fund 1001 General Fund Account Type Expenses Process Status Posted Expenditures Adopted Budget Budget Amendment Amended Budget Actual Amount 12.31.23 Remaining Budget w/ Encumbrances Percentage Used w/ Encumbrances Actual Amount 12.31.22 2022 Communications/Public Engagement 0021 Communications/Public Engagement 971,746 354,496 1,326,242 576,078 537,481 59.5% 288,569 0022 Customer Service Center - - - - - 0.0% 96,804 0029 Local Government Channel - - - - - 0.0% 78,299 2022 Communications/Public Engagement Total 971,746 354,496 1,326,242 576,078 537,481 59.5% 463,672 2023 Council / Manager 0010 City Council and Clerk 267,801 15,620 283,421 107,090 176,331 37.8% - 0028 City Manager Offices 1,267,638 104,243 1,371,881 583,845 758,705 44.7% 647,656 2023 Council / Manager Total 1,535,439 119,863 1,655,302 690,935 935,036 43.5% 647,656 2030 City Attorney 0050 City Attorney 1,088,555 60,672 1,149,227 486,302 662,448 42.4% 446,133 0051 Risk Management 1,328,236 - 1,328,236 1,328,236 - 100.0% 1,318,278 2030 City Attorney Total 2,416,791 60,672 2,477,463 1,814,538 662,448 73.3% 1,764,411 2035 State Treasurer 0060 State Treasurer 194,612 8,639 203,251 95,417 107,834 46.9% 91,004 2035 State Treasurer Total 194,612 8,639 203,251 95,417 107,834 46.9% 91,004 2040 Commissioner Of Revenue 0070 Com Rev-State/Loc Budget 940,480 44,027 984,507 425,302 549,293 44.2% 391,321 2040 Commissioner Of Revenue Total 940,480 44,027 984,507 425,302 549,293 44.2% 391,321 2045 City Assessor 0080 City Assessor 754,777 26,282 781,059 370,775 408,911 47.6% 294,510 2045 City Assessor Total 754,777 26,282 781,059 370,775 408,911 47.6% 294,510 2050 Finance 0090 Office of Management & Budget 933,887 73,321 1,007,208 512,863 479,797 52.4% 415,215 0093 Billings And Collections 1,825,332 214,900 2,040,232 807,508 1,017,278 50.1% 711,713 0094 Procurement 535,010 23,475 558,485 259,872 296,524 46.9% 244,420 0095 Accounting 1,122,070 205,896 1,327,966 555,248 622,892 53.1% 546,769 2050 Finance Total 4,416,299 517,592 4,933,891 2,135,491 2,416,491 51.0% 1,918,117 2055 Human Resources 0110 Human Resources 1,172,393 47,696 1,220,089 508,532 707,364 42.0% 437,910 0111 Occupational Health Svs 216,440 - 216,440 119,099 97,341 55.0% 41,142 2055 Human Resources Total 1,388,833 47,696 1,436,529 627,631 804,705 44.0% 479,052 2057 Information Technology 0115 Application Services 1,519,595 50,005 1,569,600 599,843 969,757 38.2% 620,636 0116 Network Services 2,024,341 71,856 2,096,197 965,830 1,130,367 46.1% 918,518 0117 I T Administration 741,705 27,546 769,251 303,254 454,479 40.9% 220,846 0125 GIS 395,654 15,012 410,666 210,512 200,154 51.3% 211,529 2057 Information Technology Total 4,681,295 164,419 4,845,714 2,079,438 2,754,758 43.2% 1,971,529 2065 Registrar 0150 Registrar 311,531 14,635 326,166 207,513 116,890 64.2% 148,133 0151 Electoral Board 136,127 611 136,738 85,747 50,991 62.7% 170,911 2065 Registrar Total 447,658 15,246 462,904 293,261 167,880 63.7% 319,044 2090 Education 0200 Lcl Sch Oper Contribution 39,360,355 - 39,360,355 19,250,000 20,110,355 48.9% 21,675,000 2090 Education Total 39,360,355 - 39,360,355 19,250,000 20,110,355 48.9% 21,675,000 2105 Circuit Court-Judge 0300 Circuit Court-Judge 175,161 4,453 179,614 86,959 90,183 49.8% 79,098 2105 Circuit Court-Judge Total 175,161 4,453 179,614 86,959 90,183 49.8% 79,098 2110 General District Court 0310 General District Court 61,273 1,451 62,724 20,974 38,795 38.1% 10,543 2110 General District Court Total 61,273 1,451 62,724 20,974 38,795 38.1% 10,543 2115 Juvenile & Dr Dist Court 0320 Juvenile & Dr Dist Court 28,400 4,403 32,803 14,235 15,258 53.5% 16,569 2115 Juvenile & Dr Dist Court Total 28,400 4,403 32,803 14,235 15,258 53.5% 16,569 2120 24th Court Service Unit 0330 24th Court Service Unit 1,960 20 1,980 52 1,908 3.7% 467 2120 24th Court Service Unit Total 1,960 20 1,980 52 1,908 3.7% 467 2125 Commonwealth's Attorney 0340 Commonwealth Attorney 2,056,844 85,608 2,142,452 974,278 1,166,525 45.6% 853,665 0343 Com Aty Fines & Fees Coll 69,327 2,818 72,145 34,169 37,096 48.6% 35,396 2125 Commonwealth's Attorney Total 2,126,171 88,426 2,214,597 1,008,447 1,203,621 45.7% 889,061 2130 Magistrate's Office 0350 Magistrate's Office 8,166 35 8,201 480 7,711 6.0% 655 2130 Magistrate's Office Total 8,166 35 8,201 480 7,711 6.0% 655 2135 Circuit Court-Clerk 0360 Circuit Court-Clerk 1,156,500 45,865 1,202,365 550,867 651,498 45.8% 504,171 Page 42 of 73 Expenditures Adopted Budget Budget Amendment Amended Budget Actual Amount 12.31.23 Remaining Budget w/ Encumbrances Percentage Used w/ Encumbrances Actual Amount 12.31.22 2135 Circuit Court-Clerk Total 1,156,500 45,865 1,202,365 550,867 651,498 45.8% 504,171 2200 City Sheriff 0400 City Sheriff And Jail 2,870,450 121,385 2,991,835 1,336,817 1,655,018 44.7% 1,229,864 2200 City Sheriff Total 2,870,450 121,385 2,991,835 1,336,817 1,655,018 44.7% 1,229,864 2240 Police 0420 Police Operations 25,186,708 1,527,944 26,714,652 11,287,198 15,042,563 43.7% 10,780,744 0421 Animal Warden 401,013 13,129 414,142 172,790 241,352 41.7% 176,361 0429 Range Operations 13,800 6,964 20,764 2,796 17,082 17.7% 6,889 0430 Police Off Duty Employmnt 1,030,440 2,169 1,032,609 494,096 538,513 47.8% 458,742 2240 Police Total 26,631,961 1,550,206 28,182,167 11,956,880 15,839,511 43.8% 11,422,736 2245 Emergency Services 0422 Emergency Communications 3,778,330 508,443 4,286,773 1,692,509 2,514,482 41.3% 1,555,268 2245 Emergency Services Total 3,778,330 508,443 4,286,773 1,692,509 2,514,482 41.3% 1,555,268 2270 Fire 0444 Fire Operations And Ems 23,025,065 1,437,933 24,462,998 11,225,966 12,975,617 47.0% 10,253,996 0446 TRT- PIER Program 76,500 - 76,500 19,616 56,334 26.4% 42,611 0447 Fire Training Division - - - 90,900 (90,900) 0.0% - 2270 Fire Total 23,101,565 1,437,933 24,539,498 11,336,481 12,941,051 47.3% 10,296,607 2400 Public Works 0600 Public Works Administrat. 1,214,903 45,345 1,260,248 537,736 683,306 45.8% 567,066 0605 Engineering 4,793,742 197,370 4,991,112 2,231,276 2,646,295 47.0% 2,110,606 0632 Street Maintenance,II 4,355,086 973,723 5,328,809 1,839,779 2,824,395 47.0% 1,642,058 0635 Snow Removal 462,852 109,548 572,400 36,183 416,669 27.2% 207,778 0640 Refuse Collection 5,185,417 1,082,190 6,267,607 2,247,230 2,680,547 57.2% 2,624,630 0645 Parks/Grounds Maintenance 4,865,657 832,753 5,698,410 2,570,595 2,855,817 49.9% 2,193,394 0649 Baseball Stadium Maint 140,032 5,991 146,023 88,914 35,663 75.6% 60,815 0650 Building Maintenance 4,482,931 222,965 4,705,896 2,026,190 2,483,660 47.2% 1,937,260 0660 Human Services Maint. 45,174 4,761 49,935 27,594 4,720 90.5% 22,122 2400 Public Works Total 25,545,794 3,474,646 29,020,440 11,605,497 14,631,071 49.6% 11,365,729 2555 Health 0800 Health Operations 700,000 - 700,000 350,000 - 100.0% 392,500 2555 Health Total 700,000 - 700,000 350,000 - 100.0% 392,500 2561 Juvenile Services 0905 Juvenile Detention Home 863,000 - 863,000 787,614 75,386 91.3% 250,781 0906 Juvenile Services 2,166,101 157,999 2,324,100 1,049,335 1,262,639 45.7% 1,027,185 0915 Csa Service Providers - - - - - 0.0% 1,019,772 2561 Juvenile Services Total 3,029,101 157,999 3,187,100 1,836,949 1,338,025 58.0% 2,297,737 2562 Social Services 0901 Social Services Admin. 10,942,307 593,109 11,535,416 5,227,049 6,290,827 45.5% 5,071,464 0902 Public Assistance 8,924,638 - 8,924,638 3,688,861 5,235,777 41.3% 3,579,484 0915 Csa Service Providers 2,083,588 253,000 2,336,588 1,815,691 520,897 77.7% - 2562 Social Services Total 21,950,533 846,109 22,796,642 10,731,601 12,047,501 47.2% 8,650,948 2563 Recreation Services 0116 Network Services 22,385 1,890 24,275 10,751 13,524 44.3% 13,855 1002 Parks/Rec/Market 462,779 19,001 481,780 219,146 253,881 47.3% 218,665 1010 Recreation, General Admin 759,432 102,501 861,933 336,217 489,674 43.2% 362,873 1011 Recreation Services 168,840 - 168,840 19,254 149,586 11.4% 79,551 1013 Recreation, Athletic 182,369 7,935 190,304 45,436 144,868 23.9% 88,095 1015 Recreation, Park Services 887,142 65,422 952,564 432,521 505,692 46.9% 406,173 1022 Recreation, Aquatics 148,945 28,996 177,941 87,112 82,188 53.8% 86,545 1023 Recreation, Naturalist 206,337 8,788 215,125 98,839 116,286 45.9% 94,025 1027 Recreation Programs 589,134 - 589,134 338,500 237,834 59.6% 309,975 1028 City-wide Centers 325,719 10,062 335,781 142,533 193,248 42.4% 127,035 1029 Neighborhood Centers 883,547 39,613 923,160 390,639 532,521 42.3% 382,523 2563 Recreation Services Total 4,636,629 284,208 4,920,837 2,120,947 2,719,302 44.7% 2,169,316 2610 Libraries 1100 Public Library 1,864,926 144,642 2,009,568 902,373 1,068,689 46.8% 803,734 1120 Law Library 10,000 - 10,000 4,522 5,478 45.2% 5,648 2610 Libraries Total 1,874,926 144,642 2,019,568 906,895 1,074,167 46.8% 809,382 2611 Museum System 1150 Museum 489,269 37,419 526,688 243,313 278,233 47.2% 171,025 2611 Museum System Total 489,269 37,419 526,688 243,313 278,233 47.2% 171,025 2715 Community Development 1200 Director-Comm Plan/Dev 380,301 17,192 397,493 162,368 230,464 42.0% 174,124 1201 Planning 467,344 210,739 678,083 249,182 259,233 61.8% 255,152 1202 Inspections 1,315,042 107,824 1,422,866 567,911 800,807 43.7% 505,462 1205 Zoning 416,823 18,853 435,676 174,929 260,747 40.2% 185,450 2715 Community Development Total 2,579,510 354,608 2,934,118 1,154,390 1,551,251 47.1% 1,120,188 2720 Office Of Economic Devel 1300 Economic Development 1,926,556 102,620 2,029,176 1,111,371 865,356 57.4% 1,167,148 2720 Office Of Economic Devel Total 1,926,556 102,620 2,029,176 1,111,371 865,356 57.4% 1,167,148 5000 Nondept Employee Benefits Page 43 of 73 Expenditures Adopted Budget Budget Amendment Amended Budget Actual Amount 12.31.23 Remaining Budget w/ Encumbrances Percentage Used w/ Encumbrances Actual Amount 12.31.22 1430 Non-allocated Emp Benefit 4,410,887 - 4,410,887 1,403,839 3,007,048 31.8% 1,695,107 5000 Nondept Employee Benefits Total 4,410,887 - 4,410,887 1,403,839 3,007,048 31.8% 1,695,107 5050 Non-Departmental 1506 Water Oper Fund Payments 901,524 - 901,524 450,762 450,762 50.0% 436,922 1508 Stormwater Fee-City Bldgs 101,000 - 101,000 41,607 59,393 41.2% 38,728 1509 Stormwater Fee-School Bld 79,000 - 79,000 32,666 46,334 41.3% 30,406 1512 College Lake Dam Repairs - 108,995 108,995 1,978 (1,978) 101.8% 989 1515 Alternative to CARES Funding - 19,153 19,153 2,155 - 100.0% 199,703 1517 Real Estate Credit - - - (33) 33 0.0% 1,234,514 1566 Managed Vacancy Program (2,000,000) - (2,000,000) - (2,000,000) 0.0% - 1567 Years of Service Awards 15,000 - 15,000 7,355 7,645 49.0% 7,500 1568 Retirement Recognition 5,000 - 5,000 6,090 (1,090) 121.8% 910 1569 Take Your Kids to Work Dy 1,000 - 1,000 - 1,000 0.0% - 1570 Emp Appreciation Luncheon 10,000 - 10,000 2,619 7,381 26.2% 877 1573 Payment-Fleet Capital Chg 2,509,861 - 2,509,861 1,600,083 909,778 63.8% 1,439,252 1574 Health Management Program 15,000 - 15,000 (13,899) 28,899 -92.7% 7,344 1575 Employee Committee Funds 8,000 960 8,960 457 7,543 15.8% 1,060 1576 Line of Duty Act 400,000 - 400,000 202,712 197,288 50.7% 189,528 1578 Poverty Intiative - - - - - 0.0% 2,932 1579 Recruitment 50,000 - 50,000 14,582 35,418 29.2% 24,734 1580 International Festival 7,500 2,980 10,480 (2) 10,482 0.0% 320 1581 Workplace Safety & Wellness 60,000 - 60,000 41,916 18,084 69.9% 22,189 1637 City Cemetery Master Plan 166,858 - 166,858 110,126 - 100.0% 110,126 5050 Non-Departmental Total 2,329,743 132,088 2,461,831 2,501,172 (223,026) 109.1% 3,748,032 5060 Support Local/State Organ 1702 V.P.I. Extension Service 41,748 - 41,748 10,468 (8) 100.0% 11,622 1705 Lynchburg Humane Society 520,000 - 520,000 520,000 - 100.0% 355,440 1707 Cent Va Alli for Comm Liv 15,000 - 15,000 15,000 - 100.0% 15,000 1708 Horizon Behavioral Health 649,880 - 649,880 324,940 - 100.0% 288,256 1709 Cvcc Board & Related Oper 1,931 - 1,931 1,931 - 100.0% 1,956 1711 Cent Va Planning Dist Com 51,635 - 51,635 51,635 - 100.0% 49,979 1715 Greater Lynch. Transit Co 1,974,463 - 1,974,463 1,543,347 431,116 78.2% 633,226 1721 Blue Ridge Regional Jail 5,011,046 - 5,011,046 1,758,300 747,223 85.1% 3,474,099 1724 Legal Aid Society 13,160 - 13,160 13,160 - 100.0% 13,160 1739 Contrib- Amazement Square 460 - 460 - 460 0.0% - 1743 Central Va Reg Radio Brd 717,336 - 717,336 385,766 331,570 53.8% 392,481 1750 Downtown Lynchburg Association - - - - - 0.0% 25,000 5060 Support Local/State Organ Total 8,996,659 - 8,996,659 4,624,547 1,510,361 83.2% 5,260,219 7450 Debt Service 5990 Principal Bonds/BANS/LOC 10,999,205 - 10,999,205 4,832,429 6,166,776 43.9% 4,421,284 5994 Interest Bonds/BANS/LOC 7,471,256 - 7,471,256 3,479,679 3,991,577 46.6% 3,065,628 5996 Debt Issuance Costs - 156,520 156,520 153,197 3,323 97.9% 628 5997 Debt - Misc. Charges 2,200 - 2,200 - 2,200 0.0% 988 7450 Debt Service Total 18,472,661 156,520 18,629,181 8,465,305 10,163,876 45.4% 7,488,527 7570 Other Financing Uses 9710 Operating Transfers Out 15,042,804 676,510 15,719,314 7,819,667 7,899,647 49.7% 21,463,625 7570 Other Financing Uses Total 15,042,804 676,510 15,719,314 7,819,667 7,899,647 49.7% 21,463,625 Grand Total 229,033,294 11,488,920 240,522,214 111,239,062 121,277,042 49.6% 123,819,840 Page 44 of 73 Finance Committee Agenda Item IV.3. Information Only AGENDA ITEM SUMMARY MEETING DATE PRESENTED BY February 27, 2024 Donna Witt, Chief Financial Officer AGENDA ITEM # IV.3 FY 2024 General Fund Reserve for Contingencies RECOMMENDATION Receive an update on the FY 2024 General Fund Reserve for Contingencies. SUMMARY The General Fund Reserve for Contingencies is a reserve in the General Fund Operating Budget designed to provide a source of funding for items not included in the current fiscal year budget. Requests for use of this reserve is recommended by the Finance Committee, with final approval by City Council. The FY 2024 Reserve for Contingencies was adopted at $1,200,000, including $50,000 for City Manager's Discretionary expenditures. Updates are presented at the monthly Finance Committee meeting. PRIOR ACTION(S) May 23, 2023: City Council, Adoption of the FY 2024 Operating and Capital Budgets FISCAL IMPACT As noted in Attachment A. CONTACT(S) Donna Witt, Chief Financial Officer ATTACHMENT(S) 1. General Fund Reserve for Contingencies - Finance Committee - February 2024 REVIEWED BY Date: Donna Witt, Chief Financial Officer Page 45 of 73 ATTACHMENT A City Manager's Reserve for Discretionary Contingencies Funding BEGINNING BALANCE, JULY 1, 2023 $1,150,000 $50,000 Carryforward to FY 2024 Reserve for Contingencies - FY 2024 Adopted Budget 0 0 BALANCE $1,150,000 $50,000 APPROPRIATIONS (Second Reading) Lynchburg City Schools - City Council Appropriated $15,000 for Schools Operating Budget - Instruction (2/13/2024) ($15,000) TOTAL APPROPRIATIONS ($15,000) $0 REMAINING BALANCE $1,135,000 $50,000 ITEMS INTRODUCED TOTAL INTRODUCED ITEMS $0 $0 REMAINING BALANCE $1,135,000 $50,000 PENDING ITEMS General Registrar - City Council Appropriated Up to $100,000 for Staffing and Other Expenses (9/12/2023) ($100,000) TOTAL PENDING ITEMS ($100,000) $0 ENDING BALANCE, JUNE 30, 2024 $1,035,000 $50,000 FY 2024 GENERAL FUND RESERVE FOR CONTINGENCIES February 2024 Page 46 of 73 Finance Committee Agenda Item IV.4. Information Only AGENDA ITEM SUMMARY MEETING DATE PRESENTED BY February 27, 2024 Donna Witt, Chief Financial Officer AGENDA ITEM # IV.4 Monthly Revenue Collections Update RECOMMENDATION Review collections received from five of the City's revenue sources during Fiscal Year 2024. This report reflects revenues collected through December 2023. SUMMARY A comparison of collections received by month is provided for the following revenues: 1. Sales and Use Tax 2. Consumer Utility Tax - Electric 3. Meals Tax 4. Lodging Tax 5. Amusement Tax PRIOR ACTION(S) May 23, 2023: City Council, Adoption of the FY 2024 Operating and Capital Budgets FISCAL IMPACT As noted on report. CONTACT(S) Donna Witt, Chief Financial Officer ATTACHMENT(S) 1. Monthly Tax Revenues Comparison FY 2024- Finance Committee - February 2024 REVIEWED BY Date: Donna Witt, Chief Financial Officer Page 47 of 73 Comparison of Collections Budget to Actual Fiscal Year 2024 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted FY 2024 Actual FY 2024 Actual FY 2024 to Adopted FY 2024 Actual FY 2024 to Actual FY 2023 JULY $1,503,837 $1,595,392 $1,752,856 $1,537,816 $1,756,307 $218,491 $3,451 AUGUST 1,396,989 1,567,107 1,734,950 1,510,552 1,735,715 225,163 $765 SEPTEMBER 1,531,422 1,702,723 1,910,727 1,641,274 1,873,719 232,445 ($37,008) OCTOBER 1,498,945 1,727,124 1,826,541 1,664,794 1,779,505 114,711 ($47,036) NOVEMBER 1,516,545 1,705,132 1,755,273 1,643,596 1,849,100 205,504 $93,827 DECEMBER 1,908,243 2,128,639 2,339,927 2,051,819 2,244,272 192,453 ($95,655) TOTAL $9,355,981 $10,426,117 $11,320,274 $10,049,851 $11,238,618 $1,188,767 ($81,656) CONSUMER UTILITY TAX - ELECTRIC JULY $329,721 $320,905 $323,534 $304,202 $305,391 $1,189 ($18,143) AUGUST 331,969 340,374 326,175 322,660 315,489 (7,171) ($10,686) SEPTEMBER 313,877 321,494 316,174 304,762 313,758 8,996 ($2,416) OCTOBER 260,312 285,740 264,598 270,869 259,987 (10,882) ($4,611) NOVEMBER 248,561 265,895 248,183 252,057 240,492 (11,565) ($7,691) DECEMBER 309,832 331,167 339,268 313,932 336,512 22,580 ($2,756) TOTAL $1,794,272 $1,865,575 $1,817,932 $1,768,482 $1,771,629 $3,147 ($46,303) SALES & USE TAX ADOPTED FY 2024 BUDGET - $23,100,000 ADOPTED FY 2024 BUDGET - $3,500,000 Prepared for Finance Committee: February 2024 Page 48 of 73 Actual Collected FY 2021 2 Actual Collected FY 2022 2 Actual Collected FY 2023 2 Adopted FY 2024 Actual Assessed FY 2024 Actual Assessed FY 2024 to Adopted FY 2024 Actual Collected FY 2024 2 Actual Collected FY 2024 to Adopted FY 2024 Actual Collected FY 2024 to Collected FY 2023 MEALS TAX JULY 1 $1,090,332 $1,381,484 $1,450,812 $1,527,821 $1,585,769 $57,948 $1,445,285 ($82,536) ($5,527) AUGUST 1,186,360 1,506,141 1,608,171 1,615,040 1,724,625 109,585 1,701,730 86,690 93,559 SEPTEMBER 1,203,439 1,457,339 1,636,715 1,674,556 1,703,056 28,500 1,815,498 140,942 178,783 OCTOBER 1,283,797 1,537,383 1,677,356 1,763,468 1,768,908 5,440 1,759,675 (3,793) 82,319 NOVEMBER 1,109,005 1,452,953 1,531,231 1,603,331 1,674,352 71,021 1,672,277 68,946 141,046 DECEMBER 1,124,410 1,560,912 1,727,245 1,704,604 1,768,801 64,197 1,730,918 26,314 3,673 TOTAL $6,997,343 $8,896,212 $9,631,530 $9,888,820 $10,225,511 $336,691 $10,125,383 $236,563 $493,853 LODGING TAX JULY 1 $155,637 $242,273 $268,473 $298,039 $307,142 $9,103 $287,424 ($10,615) $18,951 AUGUST 213,511 333,446 335,707 416,611 365,472 (51,139) 367,347 (49,264) 31,640 SEPTEMBER 257,411 263,845 301,809 324,922 341,748 16,826 341,274 16,352 39,465 OCTOBER 226,390 317,407 384,448 409,407 406,663 (2,744) 411,122 1,715 26,674 NOVEMBER 160,421 194,097 241,126 273,178 317,120 43,942 297,618 24,440 56,492 DECEMBER 112,888 193,575 251,366 220,465 219,276 (1,189) 229,855 9,390 (21,511) TOTAL $1,126,258 $1,544,643 $1,782,929 $1,942,622 $1,957,421 $14,799 $1,934,640 ($7,982) $151,711 AMUSEMENT TAX JULY 1 $13,970 $59,351 $46,938 $95,133 $89,628 ($5,505) $88,097 ($7,036) $41,159 AUGUST 19,248 55,160 97,916 60,078 63,590 3,512 62,359 2,281 (35,557) SEPTEMBER 19,538 45,639 60,593 66,819 64,099 (2,720) 62,730 (4,089) 2,137 OCTOBER 18,752 55,688 70,383 74,624 81,316 6,692 93,525 18,901 23,142 NOVEMBER 17,830 54,292 64,081 66,127 63,027 (3,100) 57,177 (8,950) (6,904) DECEMBER 15,570 91,535 84,585 89,871 101,542 11,671 102,333 12,462 17,748 TOTAL $104,908 $361,665 $424,496 $452,652 $463,202 $10,550 $466,221 $13,569 $41,725 ADOPTED FY 2024 BUDGET - $20,265,000 1 Due to year end accounting activities, a portion of revenues associated with May and June were posted in June and July. 2 "Actual Collected" includes all revenue received per month regardless of whether the payment is current or delinquent. ADOPTED FY 2024 BUDGET - $3,775,000 ADOPTED FY 2024 BUDGET - $900,000 Page 49 of 73 Finance Committee Agenda Item IV.5. Information Only AGENDA ITEM SUMMARY MEETING DATE PRESENTED BY February 27, 2024 Donna Witt, Chief Financial Officer AGENDA ITEM # IV.5 Presentation of the FY 2025 - 2029 Capital Improvement Program - City and Schools RECOMMENDATION Hear a presentation regarding the FY 2025 - 2029 Capital Improvement Program - City and Schools SUMMARY As part of the FY 2025 budget, the FY 2025 - 2029 Capital Improvement Program will be presented to highlight City and Schools capital projects that are funded by the general fund. PRIOR ACTION(S) FISCAL IMPACT Fiscal Impact will depend on adoption of the program CONTACT(S) Donna Witt, Chief Financial Officer ATTACHMENT(S) 1. FY 2025-2029 Capital Improvement Program 022724 Presentation 2. FY 2025-2029 Capital Improvement Program 022724 Appendix REVIEWED BY Date: Donna Witt, Chief Financial Officer Date: Gregory Patrick, Deputy City Manager Date: Alicia Finney, Clerk of Council Page 50 of 73 FY 2025 – 2029 CAPITAL IMPROVEMENT PROGRAM CITY AND SCHOOLS February 27, 2024 Page 51 of 73 CITY ASSETS • Approximately 200 structures, including: • Over 1 million square feet of space (not including schools) • Public Safety Buildings and Structures • Community Centers • Courts • Libraries • Public Works Complex • Human Services Buildings • Municipal Building • 16 primary and secondary schools • 817 lane miles • 78 bridges/major culverts • 953 acres of parks and more than 23 miles of trails Page 52 of 73 WHERE WE WERE • Limited newly designed buildings; repurposed existing space • In general, submitted projects from departments were included in the Proposed Capital Improvement Program (CIP) • Funding was available when needed • Debt Service grew year-over-year; organic revenue growth covered the increased cost • This process worked for 20+ years Page 53 of 73 WHERE WE ARE NOW • Aging infrastructure • Project funding is no longer guaranteed • Submitted Projects were eliminated or delayed due to: • Inflationary Costs of Construction • Rising Interest Rates • Limited Capacity to Grow Debt Service • Inflation for constructing non-residential buildings • 2011-2020: 3.7% • 2022: 12% • Producer price index by commodity for construction materials increased 57% over 10 years (January 2014 – December 2023), U.S. Labor of Statistics Page 54 of 73 WHERE WE ARE NOW (CONTINUED) Submitted Proposed Bond Funding Buildings 64,663,000 37,583,000 20,568,000 Transportation 167,672,339 149,411,464 79,681,875 Economic Development 51,441,000 40,791,000 27,461,000 Parks and Recreation 20,756,000 8,106,000 2,150,000 Miscellaneous 7,745,000 6,525,000 1,500,000 Reserves 1,450,000 1,750,000 0 Schools 118,769,032 9,952,000 7,090,000 $432,496,371 $254,118,464 $138,450,875 Page 55 of 73 PLAN OF FINANCE • Over the past several years, the City has followed “Just-In-Time” funding for its capital needs. • The “Just-In-Time” financing includes a two- to three-year line of credit strategy followed by permanent financing. • Given the success of this funding strategy the City’s financial advisors, Davenport & Company, have recommended the City continue to utilize the financing strategy. • The City anticipates entering into a new line of credit in the spring of 2026 as a part of the next phase of its Capital Improvement Program. Page 56 of 73 CIP PLAN COMPARISON Line of Credit/Bonds FY 2025 FY 2026 FY 2027 FY 2028 Total FY 2024 - 2028 Adopted $47,817,250 $27,675,141 $29,837,000 $24,807,750 $130,137,141 FY 2025 - 2029 Propos ed $33,871,433 $31,444,191 $29,140,300 $17,025,750 $111,481,674 Page 57 of 73 QUESTIONS? Page 58 of 73 FY 2025 – 2029 CAPITAL IMPROVEMENT PROGRAM CITY AND SCHOOLS February 27, 2024 APPENDIX Page 59 of 73 FY 2025 – 2029 CIP – FUNDED PROJECTS BUILDINGS 2 Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost CIP Page Circuit and General District Court Improvements 0 750,000 8,000,000 0 0 0 8,750,000 22 Major Building Repairs and Improvements/Multiple Projects 0 0 4,125,000 4,785,000 2,910,000 4,705,000 16,525,000 23 Parking Lot Repairs and Improvements/Multiple Projects 0 0 485,000 425,000 425,000 425,000 1,760,000 28 Roof Replacement/Multiple Projects 0 470,000 1,060,000 1,785,000 638,000 1,595,000 5,548,000 31 Transfer Station for Refuse 1,900,000 5,000,000 0 0 0 0 5,000,000 33 TOTAL $1,900,000 $6,220,000 $13,670,000 $6,995,000 $3,973,000 $6,725,000 $37,583,000 Page 60 of 73 FY 2025 – 2029 CIP – REMOVED PROJECTS BUILDINGS Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost Public Library Renovation/Reimagination 1,092,710 9,000,000 1,000,000 0 0 0 10,000,000 Public Safety Firing Range - Building 0 150,000 1,950,000 0 0 0 2,100,000 Public Safety Indoor Firing Range 0 200,000 11,000,000 0 0 0 11,200,000 TOTAL $1,092,710 $9,350,000 $13,950,000 $0 $0 $0 $23,300,000 3 Page 61 of 73 FY 2025 – 2029 CIP – FUNDED PROJECTS TRANSPORTATION 4 Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost CIP Page Public Transit Improvements and Bus Replacements 9,606,000 478,000 3,841,050 1,062,950 530,000 3,900,000 9,812,000 36 Bedford Avenue Bridge 14,724,894 0 7,160,915 0 0 0 7,160,915 38 Breezewood Drive Widening 5,280,000 4,473,825 0 1,708,456 0 0 6,182,281 39 Bridge Maintenance 0 1,088,325 625,000 676,000 729,000 765,450 3,883,775 40 Culvert Replacement Program 0 750,000 81,250 845,000 87,750 929,500 2,693,500 41 Forest Brook Road, Phase I 0 0 0 0 0 1,417,500 1,417,500 43 General Street Improvements 0 425,000 1,100,000 1,170,000 1,215,000 1,275,750 5,185,750 44 Hollins Mill Rd Bridge Replacement w/Bikeway Improvemnts 0 8,268,000 0 8,116,410 0 3,466,652 19,851,062 45 John Lynch Bridge Repairs 6,072,567 3,077,433 0 0 0 0 3,077,433 46 Lakeside Drive Arch Bridge Rehabilitation 750,000 93,750 937,500 0 0 0 1,031,250 47 Lakeside Drive Improvements 1,972,000 2,084,849 0 629,168 0 0 2,714,017 48 Leesville Road Pedestrian Improvements 0 0 0 0 0 1,000,000 1,000,000 49 Liberty Mountain Drive Realignment 0 0 0 0 0 810,000 810,000 50 Link Road/Boonsboro Road Intersection Improvements 1,576,000 1,457,794 0 547,898 0 0 2,005,692 51 Lynchburg Center for Industry - Phase II 0 262,007 1,048,030 0 0 0 1,310,037 53 McConville Road Realignment to Lakeside Drive 0 0 0 0 780,000 3,780,000 4,560,000 55 Page 62 of 73 FY 2025 – 2029 CIP – FUNDED PROJECTS TRANSPORTATION (CONTINUED) 5 Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost CIP Page Nationwide Drive Roundabout 0 0 0 0 0 992,250 992,250 56 Public Works Infrastructure Improvements 0 342,000 353,000 375,000 400,000 420,000 1,890,000 57 Retaining Wall Replacement/Repair Program 0 0 500,000 62,500 500,000 62,500 1,125,000 58 Route 501/221 One-Way Pairs 38,335,619 10,087,500 8,219,052 13,136,325 0 0 31,442,877 59 Storm Drainage System Repairs/Replacements 0 142,000 149,000 162,500 177,000 186,000 816,500 60 Street Overlay Program 0 2,659,250 2,769,600 3,000,000 3,280,000 3,444,000 15,152,850 61 Timberlake Road Bridge, West Bound Lanes 0 0 0 0 1,102,500 9,646,875 10,749,375 62 Traffic Signal Repair and Replacement 0 0 500,000 512,500 515,000 547,500 2,075,000 63 Vassar Street at Langhorne Road Intersection Improvements 50,000 0 0 0 9,783,867 0 9,783,867 64 Wards Ferry Road/Atlanta Avenue Turn Lanes 1,340,000 1,597,015 0 779,018 0 0 2,376,033 66 Wards Ferry Road/Simons Run Pedestrian Accommodations 0 0 0 0 0 312,500 312,500 67 TOTAL $79,707,080 $37,286,748 $27,284,397 $32,783,725 $19,100,117 $32,956,477 $149,411,464 Page 63 of 73 FY 2025 – 2029 CIP – REMOVED PROJECTS TRANSPORTATION Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost Campbell Avenue Intersection and Signal Reconstruction 3,125,000 0 0 0 0 0 0 College Lake Overlook 0 0 0 250,000 1,250,000 0 1,500,000 D Street and Rivermont Avenue Intersection Improvements 945,000 8,775,000 0 0 0 0 8,775,000 Timberlake Road Bridge, East Bound Lanes 0 0 0 0 0 1,000,000 1,000,000 Timberlake Road Improvements 0 0 0 0 0 472,500 472,500 TOTAL $4,070,000 $8,775,000 $0 $250,000 $1,250,000 $1,472,500 $11,747,500 6 Page 64 of 73 FY 2025 – 2029 CIP – FUNDED PROJECTS ECONOMIC DEVELOPMENT 7 Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost CIP Page Airport Commerce Park 0 500,000 500,000 5,000,000 5,560,000 0 11,560,000 70 Future Streetscape Improvements Downtown 0 875,000 6,250,000 936,000 7,000,000 1,000,000 16,061,000 71 Ivy Creek Innovation Park - Sites A and B Development 0 2,400,000 350,000 4,400,000 4,770,000 0 11,920,000 72 Street & Utility Extensions to Promote Economic Developmnt 0 250,000 250,000 250,000 250,000 250,000 1,250,000 73 TOTAL $0 $4,025,000 $7,350,000 $10,586,000 $17,580,000 $1,250,000 $40,791,000 Page 65 of 73 FY 2025 – 2029 CIP – REMOVED PROJECTS ECONOMIC DEVELOPMENT Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost Downtown Development $0 $150,000 $2,500,000 $1,800,000 $1,200,000 $5,000,000 $10,650,000 8 Page 66 of 73 FY 2025 – 2029 CIP – FUNDED PROJECTS PARKS AND RECREATION 9 Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost CIP Page Athletic Field Maintenance 0 0 250,000 375,000 300,000 350,000 1,275,000 76 City Stadium - Visitors' Side Improvements 0 0 75,000 500,000 0 0 575,000 78 General Park Maintenance 0 0 160,000 225,000 235,000 230,000 850,000 79 General Park Security Improvements 200,000 0 100,000 100,000 100,000 100,000 400,000 81 Heritage Park Improvements 525,000 0 500,000 250,000 0 0 750,000 82 Jackson Heights Art Studio Renovation 0 0 0 0 75,000 75,000 83 Jefferson Park: Phase 2 0 0 0 0 150,000 500,000 650,000 84 Parks and Trails Paving and Lighting 0 0 370,000 365,000 350,000 396,000 1,481,000 85 Peaks View Park Athletic Field Lighting 0 0 0 75,000 750,000 750,000 1,575,000 88 Templeton Senior Center Renovations 0 0 75,000 0 400,000 0 475,000 89 TOTAL $725,000 $0 $1,530,000 $1,890,000 $2,285,000 $2,401,000 $8,106,000 Page 67 of 73 FY 2025 – 2029 CIP – REMOVED PROJECTS PARKS AND RECREATION Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost Allen-Morrison Site Assessment/Design 0 0 250,000 0 0 0 250,000 Fireman Fountain Restoration 25,000 250,000 0 0 0 0 250,000 Community Park Investment Fund 0 50,000 50,000 50,000 50,000 50,000 250,000 New Dog Park 210,658 75,000 600,000 0 0 0 675,000 Miller Park Pool Assessment/Replacement 50,000 0 250,000 8,000,000 0 0 8,250,000 Parks Tree Replacement Program 0 50,000 55,000 55,000 55,000 55,000 270,000 Riverside Park Master Plan Implementation 0 0 0 0 75,000 500,000 575,000 Sustainable Infrastructure Program 0 75,000 75,000 100,000 100,000 100,000 450,000 TOTAL $285,658 $500,000 $1,280,000 $8,205,000 $280,000 $705,000 $10,970,000 10 Page 68 of 73 FY 2025 – 2029 CIP – FUNDED PROJECTS MISCELLANEOUS 11 Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost CIP page Diamond Hill Neighborhood Improvements 0 500,000 500,000 500,000 500,000 500,000 2,500,000 94 Memorial Avenue Fuel Site Reconstruction 0 250,000 1,500,000 0 0 0 1,750,000 95 Petroleum Storage 0 0 50,000 0 0 0 50,000 96 Pleasant Valley, Phase 1 - Greenway Design 0 0 0 200,000 1,145,000 0 1,345,000 97 Radio Replacement 2,048,740 0 220,000 220,000 220,000 220,000 880,000 98 TOTAL $2,048,740 $750,000 $2,270,000 $920,000 $1,865,000 $720,000 $6,525,000 Five Year Proposed Appropriations to be Financed by the City (General Fund and Schools) Page 69 of 73 FY 2025 – 2029 CIP – REMOVED PROJECTS MISCELLANEOUS Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost Computer Aided Dispatch Replacement $5,000,000 $500,000 $500,000 $0 $0 $0 $1,000,000 12 Page 70 of 73 FY 2025 – 2029 CIP – FUNDED PROJECTS RESERVES 13 Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost CIP Page Capital Maintenance Reserve 0 300,000 0 0 0 0 300,000 100 Lynchburg City Stadium Capital Maintenance Reserve 800,000 100,000 100,000 0 0 0 200,000 101 Snow, Street, and Bridge Reserve 0 250,000 250,000 250,000 250,000 250,000 1,250,000 102 TOTAL $800,000 $650,000 $350,000 $250,000 $250,000 $250,000 $1,750,000 Page 71 of 73 FY 2025 – 2029 CIP – FUNDED PROJECTS SCHOOLS 14 Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost CIP Page Civic Auditorium Reserve 0 0 150,000 150,000 150,000 150,000 600,000 106 Dunbar Middle Chiller and Cooling Tower Replacement 0 0 450,000 0 500,000 0 950,000 107 E.C. Glass Cooling Tower Replacement 1,000,000 1,000,000 0 0 0 0 1,000,000 108 Elementary Playground Modernization 0 0 100,000 100,000 100,000 100,000 400,000 109 Paving and Fencing Improvements 0 0 216,000 224,000 232,000 240,000 912,000 110 School Building Roof Replacements 0 690,000 810,000 575,000 1,415,000 1,750,000 5,240,000 111 Sheffield Elementary Chiller Replacement 0 850,000 0 0 0 0 850,000 113 TOTAL $1,000,000 $2,540,000 $1,726,000 $1,049,000 $2,397,000 $2,240,000 $9,952,000 Page 72 of 73 FY 2025 – 2029 CIP – REMOVED PROJECTS SCHOOLS Project Title Appropriations Through 06/30/2024 Budget FY 2025 Planned FY 2026 Planned FY 2027 Planned FY 2028 Planned FY 2029 Five-Year Estimated Net Cost W. M. Bass Elementary Expansion 0 15,000,000 0 0 0 0 15,000,000 Perrymont Elementary Renovation 0 0 0 21,196,032 0 0 21,196,032 Linkhorne Elementary Renovation and Gymnasium Addition 0 0 0 0 0 24,354,000 24,354,000 School Safety and Maintenance Projects 0 5,170,000 2,750,000 4,125,000 12,760,000 5,225,000 30,030,000 School Security Improvements 2,575,000 1,500,000 1,500,000 0 0 0 3,000,000 Interior and Exterior Painting and Plaster Repair 0 350,000 375,000 400,000 100,000 500,000 1,725,000 Athletics Turf, Track, and Tennis Improvements 0 1,655,000 815,000 900,000 650,000 0 4,020,000 School Gymnasium Additions 0 2,200,000 2,310,000 0 0 0 4,510,000 Middle School Athletic Field Lighting 0 400,000 416,000 433,000 0 0 1,249,000 Dunbar Middle Campus Master Plan 0 125,000 0 0 0 0 125,000 Reserves for Facilities Maintenance Needs 0 250,000 250,000 250,000 250,000 250,000 1,250,000 Electrical and Mechanical Reserve 0 250,000 250,000 250,000 250,000 250,000 1,250,000 TOTAL $2,575,000 $26,900,000 $8,666,000 $27,554,032 $14,010,000 $30,579,000 $107,709,032 15 Page 73 of 73

Source: City of Lynchburg website. First collected Nov 10, 2026.