RecordWell Data

Finance Committee Meeting - February 28, 2023 — Agenda Packet

City of Lynchburg · Lynchburg City County · Finance Committee · meeting of Feb 28, 2023 · 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.

Page 1 of 2 FINANCE COMMITTEE AGENDA Tuesday, February 28, 2023 3:00 p.m. – 2nd Floor Training Room GENERAL BUSINESS 3:00 p.m. 1. Approval of the Draft Finance Committee Meeting Notes from January 24, 2023. Contact: Donna Witt, Chief Financial Officer 455-3968 3:03 p.m. 2. Report on the General Fund Reserve for Contingencies. Contact: Donna Witt, Chief Financial Officer 455-3968 3:05 p.m. 3. Consider a request to adopt a resolution to amend the FY 2023 City/Federal/State Aid Fund budget and appropriate $34,950 with resources from a grant from the Library of Virginia to preserve Deed Book 38 M-M, 1886; Deed Book 39 N-N, 1886-1887; Deed Book 43 R-R, 1889-1890; Marriage Licenses 1859-1860; Marriage Licenses 1861-1863; Will Book F, 1872-1877. Contact: K. Todd Swisher, Circuit Court Clerk 455-2611 3:10 p.m. 4. Consider a request to adopt a resolution to amend the FY 2023 City/Federal/State Aid Fund budget and appropriate $913,700 with resources of $830,636 from the Department of Homeland Security (DHS) and FEMA and $83,064 from the FY 2023 General Fund Reserve for Contingencies budget to purchase Self-Contained Breathing Apparatus (SCBA) and related equipment for the Fire Department. Contact: Gregory Wormser, Fire Chief 455-6340 3:15 p.m. 5. Consider a request to adopt a resolution to amend the FY 2023 City/Federal/State Aid Fund budget and appropriate $54,163 with resources of $27,081 from the Virginia Office of Emergency Medical Services Grant Program through the Rescue Squad Assistance Fund (RSAF) and $27,082 from the FY 2023 General Fund Reserve for Contingencies budget to purchase one (1) Lifepak 15 monitor/defibrillator and one (1) Lucas 3 chest compression system for the Fire Department. Contact: Gregory Wormser, Fire Chief 455-6340 3:20 p.m. 6. Review highlights of attached quarterly financial reports for the Greater Lynchburg Transit Company (GLTC) as well as the Regional Airport, Lynchburg Regional Juvenile Detention Center, Children’s Services Act, Water Operating, Sewer Operating, Stormwater Operating, and General Funds for the quarter ending December 31, 2022. Page 2 of 2 Fund Preparer GLTC Joshua Moore, General Manager, GLTC Regional Airport Fund Andrew LaGala, Airport Director Lynchburg Regional Juvenile Detention Center Preston Sellers, Director of Human Services Children’s Services Act Fund (CSA) Preston Sellers, Director of Human Services Water Operating Fund Tim Mitchell, Director of Water Resources Sewer Operating Fund Tim Mitchell, Director of Water Resources Stormwater Operating Fund Tim Mitchell, Director of Water Resources General Fund: Quarter ending December 31, 2022 Quarter ending September 30, 2022 Donna Witt, Chief Financial Officer 3:45 p.m. 7. Investment Summary. Contact: Donna Witt, Chief Financial Officer 455-3968 3:50 p.m. 8. Review collections received from five of the City’s revenue sources. Contact: Donna Witt, Chief Financial Officer 455-3968 3:55 p.m. 9. Roll Call The next Finance Committee meeting is Tuesday, March 28, 2023 at 3:00 p.m. Page 1 of 4 FINANCE COMMITTEE NOTES -- DRAFT Tuesday, January 24, 2023 GENERAL BUSINESS Meeting commenced at 3:00 p.m. in 2nd Floor Training Room – City Hall. ATTENDEES Committee Members: Vice Mayor Chris Faraldi, Chair; Council Member MaryJane Dolan; Council Member Larry Taylor; Mayor Stephanie Reed, Ex-Officio. Others: Wynter C. Benda, City Manager; Greg Patrick, Deputy City Manager; John H. Hughes, IV, Assistant City Manager; Donna Witt, Chief Financial Officer; Rhonda Allbeck, Assistant Director of Financial Services; Starlette Early, Budget Analyst. 1. Real Estate Rate Reduction Discussion. Chief Financial Officer Donna Witt presented this item. Chair Faraldi moved for a recommendation by Finance Committee to direct City staff to provide creative, effective, and legal options for the associated increase for real estate. This motion was seconded by Council Member Taylor. The item was approved, by a 3-0 vote, to move forward for full Council consideration at the January 24, 2022 meeting. 2. Receive information related to the Concealed Weapon Permit and related fee. Chief Financial Officer Donna Witt presented this item. Chair Faraldi moved for adoption of draft Ordinance #1 for this item, seconded by Council Member Taylor. This ordinance would remove the full local portion of the fee from the Concealed Handgun permit fee, leaving the required $15 fee for the Clerk and State Police. The item was approved, by a 2-1 vote, to move forward for full Council consideration at the January 24, 2022 meeting. 3. Approve the guidelines for the operation of the City Council’s Finance Committee. Chief Financial Officer Donna Witt presented this item. The Committee agreed to holding Finance Committee meetings at 3:00 p.m. on the fourth Tuesday of the month. The item was approved, by a 3-0 vote, to move forward for full Council consideration at the January 24, 2022 meeting. FINANCE COMMITTEE AGENDA ITEM #: 1 Page 2 of 4 4. Consider a request to adopt a resolution to review, amend, and reaffirm the City Council's Financial Management Policies as revised by the City's financial advisors, Davenport & Company, LLC. Chief Financial Officer Donna Witt presented this item. Recommended revisions to the Investment Policy were explained in detail and are related to additional investment tools now sanctioned by State Code, including specific rated Corporate Bond investments, Pre- refunded Obligations of the Commonwealth of Virginia, and the portfolio of the Virginia Local Government Investment Pool. The item was approved, by a 3-0 vote, to move forward for full Council consideration at the January 24, 2022 meeting. 5. Consider a request to adopt a resolution to amend the FY 2023 City/Federal/State Aid Fund budget and appropriate $85,000 with resources from the Virginia Department of Emergency Management, 2022 State Homeland Security Program Grant to purchase a Drone Mobile Command Response Vehicle for the Lynchburg Police Department. Deputy Chief of Police Ken Edwards presented this item, noting no local match funds are required. The item was approved, by a 3-0 vote, to move forward for full Council consideration at the January 24, 2022 meeting. 6. Consider a request to adopt a resolution to amend the FY 2023 City/Federal/State Aid Fund budget and appropriate $387,250 with resources from the 2023 Department of Criminal Justice Services, American Rescue Plan Act, Funding Program to purchase Law Enforcement Equipment & Technology for the Lynchburg Police Department. Deputy Chief of Police Ken Edwards presented this item, noting no local match funds are required. The item was approved, by a 3-0 vote, to move forward for full Council consideration at the January 24, 2022 meeting. 7. Review highlights of attached quarterly financial reports for the Greater Lynchburg Transit Company (GLTC) as well as the Regional Airport, Lynchburg Regional Juvenile Detention Center, Children’s Services Act, Water Operating, Sewer Operating, Stormwater Operating, and General Funds for the quarter ending September 30, 2022. GLTC: Joshua Moore, General Manager, reported GLTC experienced first quarter deficits primarily due to much higher than anticipated costs for diesel fuel, a one-time retention bonus for employees, and increased costs for parts. Also contributing to the deficit is the inability to draw down standard State and Federal 5307 funds until all ARPA funds have been utilized. There is approximately $300,000 in these funds including a grant from the State that will be available once the ARPA funds have been expended. FINANCE COMMITTEE AGENDA ITEM #: 1 Page 3 of 4 Airport: Andrew LaGala, Airport Director, reported the Airport enterprise fund has remained healthy and balanced while continuing to recover and stabilize from the recent effects of the pandemic. Overall for the quarter, direct operating revenues (total revenues less CARES funds) is up by 26.2% compared to last year, primarily attributed to increased terminal revenues from the parking lot and rental cars. Parking is now at about 80 – 85% of 2019 levels, and rental car is back to 95 - 100% of where we were in 2019. Total operating revenues for the year is projected to be $171,000 more than budget. Expenses at this early stage are currently in-line with budget and are expected to finish the year at or near budgeted levels. Total COVID-related grants (CARES/CRRSA/ARPA) have $2.4 million remaining to be drawn and are earmarked for adding to the operating fund and upcoming pay-as-you-go revenue building capital projects. Bottom line is the Airport is projecting an operating surplus for FY 2023 of approximately $350,000. Lynchburg Regional Juvenile Detention Center: Preston Sellers, Director of Human Services, reported first quarter revenues at $657,052 are nearly the same amount as last year’s first quarter revenues. These revenues are from charges for services (per-diem), the Juvenile Justice Block Grant, and United States Department of Agriculture (USDA) grant. Mr. Sellers noted a State Ward per diem revenue of $300 on the spreadsheet, but not in the narrative. Total expenditures were $622,470 and are also within budget. There were no significant changes between FY 2022 and FY 2023 first quarter. Children’s Services Act (CSA): Preston Sellers reported total first quarter revenues of $834,667, including Public Assistance, City Schools and General Fund CSA contributions, and Miscellaneous Revenues Special Welfare. Expenditures include administrative, foster care, and special education, both mandated (Sum-Sufficient) services, and other non-mandated (Non-Sum Sufficient) services of $501,113. No significant changes in expenditures; however, Mr. Sellers noted they are still in the process of collecting funds from schools for special education as they started back in September. Water: Tim Mitchell, Director of Water Resources, reported overall Water Fund revenues were approximately $326,000 more than budget, with the majority of the increase in higher than projected interest earnings ($251,000). He noted water use is trending down in both industrial and residential accounts from last year to the current year, a metric that is carefully tracked. Expenses were approximately $42,000 below budget with primary variances in personnel savings due to vacancies, offset by significant increases in chemical costs and utility costs that incorporated higher electricity rates. Overall the fund is in good condition and meeting all Council’s fiscal policies. Chair Faraldi requested additional information on the interest earnings, and Mrs. Witt indicated this was across all funds. Chair Faraldi requested a break-down on this information. Sewer: Tim Mitchell reported the Sewer Fund revenues are expected to be approximately $364,000 above budget primarily due to increased interest earnings ($427,000) and sewer contract variances. Sewer Fund expenditures are expected to be approximately $1.167 million above budget due to significant increases in chemical costs and utilities. Chemical costs are above budget by $345,000 and utilities are above budget by $240,000. Staff is FINANCE COMMITTEE AGENDA ITEM #: 1 Page 4 of 4 working with AEP to determine if there is anything that can help reduce power usage costs. Mr. Mitchell reported the fund is meeting all of Council’s fiscal policies, as well as the fiscal responsibilities related to the Combined Sewer Overflow (CSO) consent order. Stormwater: Tim Mitchell reported the Stormwater Fund revenues are expected to exceed budget by $97,500 with interest earnings accounting for $81,000 of this amount. Expenditures are expected to be $50,200 below budget with variances related to vacancies and reduced costs other areas noted on report. He reported the Stormwater Fund is meeting Council’s financial policy ratios. General Fund: Due to time constraints, the General Fund report was deferred to the next Finance Committee meeting. 8. Roll Call. There were no roll call items. Meeting adjourned at 3:49 p.m. FINANCE COMMITTEE AGENDA ITEM #: 1 AGENDA ITEM #: 2 City Manager's Reserve for Discretionary Contingencies Funding BEGINNING BALANCE, JULY 1, 2022 $1,150,000 $50,000 Carryforward to FY 2023 Reserve for Contingencies - FY 2023 Adopted Budget 0 0 BALANCE $1,150,000 $50,000 APPROPRIATIONS (Second Reading) TOTAL APPROPRIATIONS $0 $0 REMAINING BALANCE $1,150,000 $50,000 ITEMS INTRODUCED Fire Department - Department of Homeland Security and FEMA Grant - Local Match ($83,064) Fire Department - Rescue Squad Assistance Fund (RSAF) Emergency Medical Services Grant - Local Match ($27,082) TOTAL INTRODUCED ITEMS ($110,146) $0 REMAINING BALANCE $1,039,854 $50,000 PENDING ITEMS TOTAL PENDING ITEMS $0 $0 ENDING BALANCE, JUNE 30, 2023 $1,039,854 $50,000 FY 2023 GENERAL FUND RESERVE FOR CONTINGENCIES February 2023 FINANCE COMMITTEE AGENDA ITEM #: 3 FINANCE COMMITTEE AGENDA ITEM #: 3 FINANCE COMMITTEE AGENDA ITEM #: 3 FINANCE COMMITTEE AGENDA ITEM #: 3 FINANCE COMMITTEE AGENDA ITEM #: 3 City Council Agenda Item VI.12. Action AGENDA ITEM SUMMARY MEETING DATE PRESENTED BY February 28, 2023 Gregory Wormser, Fire Chief AGENDA ITEM # VI.12 2021 Assistance to Firefighters grant to purchase Self-Contained Breathing Apparatus (SCBA) airpacks for Fire Department - Appropriation of $913,700 RECOMMENDATION Adopt a resolution to amend the FY 2023 City/Federal/State Aid Fund budget and appropriate $913,700 with resources of $830,636 from the Department of Homeland Security (DHS) and FEMA and $83,064 from the FY 2023 General Fund Reserve for Contingencies budget to purchase Self- Contained Breathing Apparatus (SCBA) and related equipment for the Fire Department. SUMMARY The Department of Homeland Security (DHS) and FEMA awards grant funding to focus on enhancing the safety of the public and firefighters with respect to fire and fire-related hazards. The Assistance to Firefighters Grant accomplishes this by providing financial assistance directly to eligible fire departments for critical training and equipment. The funds will be used for the purchase of ninety-eight (98) SCBA, ninety-eight (98) air bottles, fifteen (15) RIT Packs, brackets, (184) facepieces, a FIT Tester for flow testing SCBA, an air compressor/cascade with fill station, and a breathing air compressor to effectively respond to and mitigate fire related hazards. The SCBA we currently use are coming to the end of its useful life and some of the component parts are no longer available. In addition, the breathing air compressor to be replaced will meet the end of its useful life in Calendar Year 2023 as it is the oldest of the three (3) compressors in operation in the department. This grant requires a local match. The Fire Department has been awarded grant funds under a 90/10 match. With a total cost of $913,700, the FEMAGO grant software program auto-calculated local match for this grant is $83,064. The local match will be requested from the FY 2023 General Fund Reserve for Contingencies budget. PRIOR ACTION(S) January 25, 2022: Finance Committee (application approval) February 28, 2023: Finance Committee (consider request to appropriate funds) FISCAL IMPACT $83,064 in matching funds are requested from the FY 2023 General Fund Reserve for Contingencies budget. Future funds will be needed for periodic maintenance of the equipment. CONTACT(S) FINANCE COMMITTEE AGENDA ITEM #: 4 Gregory Wormser, Fire Chief Annette Pettyjohn, Administrative Manager ATTACHMENT(S) 1. Resolution - Assistance to Firefighters Grant Program $913,700 rev REVIEWED BY Date: Gregory Wormser, Fire Chief Date: Mercedes Braun, Executive Assistant to the City Manager Date: Wynter C. Benda, City Manager Date: Alicia Finney, Clerk of Council FINANCE COMMITTEE AGENDA ITEM #: 4 RESOLUTION: BE IT RESOLVED that the FY 2023 City/Federal/State Aid Fund budget is amended and $913,700 is appropriated with resources of $830,636 from the Department of Homeland Security (DHS) and FEMA and $83,064 from the FY 2023 General Fund Reserve for Contingencies budget to purchase Self-Contained Breathing Apparatus (SCBA) and related equipment for the Fire Department. Introduced: Adopted: Certified: _________________________________ Clerk of Council FINANCE COMMITTEE AGENDA ITEM #: 4 City Council Agenda Item VI.11. Action AGENDA ITEM SUMMARY MEETING DATE PRESENTED BY February 28, 2023 Gregory Wormser, Fire Chief AGENDA ITEM # VI.11 Consideration of introducing Resolution #R-23-___ amending the FY 2023 City/Federal/State Aid Fund budget and appropriating $54,163 from the Virginia Office of Emergency Medical Services Grant Program through the Resuce Squad Assistance Fund (RASF) to purchase one (1) Lifepak 15 monitor/defibrillator and one (1) Lucas 3 chest compression system for the Fire Department. RECOMMENDATION Adopt a resolution to amend the FY 2023 City/Federal/State Aid Fund budget and appropriate $54,163 with resources of $27,081 from the Virginia Office of Emergency Medical Services Grant Program through the Rescue Squad Assistance Fund (RSAF) and $27,082 from the FY 2023 General Fund Reserve for Contingencies budget to purchase one (1) Lifepak 15 monitor/defibrillator and one (1) Lucas 3 chest compression system for the Fire Department. SUMMARY The Virginia Office of Emergency Medical Services (EMS) awards grant funding to EMS agencies for the purpose of obtaining and maintaining emergency vehicles and equipment; providing EMS management, leadership, and advanced life support training, and achieving other goals that support the enhancement of community EMS services. The Fire Department has been awarded RSAF grant funds to replace one (1) Lifepak 15 cardiac monitor/defibrillator and one (1) Lucas 3 chest compression device. The current service call volume requires LFD to reinstate a fifth reserve medic unit. The Lifepak 15 monitor/defibrillator and Lucas 3 chest compression systems are required for the fifth medic unit. The grant requires a local match. The Fire Department has been awarded grant funds under a 50/50 match. With a total cost of $54,163, the maximum required local match is $27,082. The local match is being requested from the FY 2023 General Fund Reserve for Contingencies budget. PRIOR ACTION(S) September 27, 2022: Finance Committee (application approval) February 28, 2023: Finance Committee (consider request to appropriate funds) FISCAL IMPACT $27,082 in matching funds are requested from the FY 2023 General Fund Reserve for Contingencies budget. Future funds will be needed for periodic maintenance of the equipment. CONTACT(S) Gregory Wormser, Fire Chief FINANCE COMMITTEE AGENDA ITEM #: 5 Marques Bush, Deputy Fire Chief Annette Pettyjohn, Administrative Manager ATTACHMENT(S) 1. Resolution - Rescue Squad Assistance Fund Grant Program $54,163 rev REVIEWED BY Date: February 07, 2023 Gregory Wormser, Fire Chief Date: February 07, 2023 Mercedes Braun, Executive Assistant to the City Manager Date: Wynter C. Benda, City Manager Date: Alicia Finney, Clerk of Council FINANCE COMMITTEE AGENDA ITEM #: 5 RESOLUTION: BE IT RESOLVED that the FY 2023 City/Federal/State Aid Fund budget is amended and $54,163 is appropriated with resources of $27,081 from the Virginia Office of Emergency Medical Services Grant Program through the Rescue Squad Assistance Fund (RSAF) and $27,082 from the FY 2023 General Fund Reserve for Contingencies to purchase one (1) Lifepak 15 monitor/defibrillator and one (1) Lucas 3 chest compression system for the Fire Department. Introduced: Adopted: Certified: _________________________________ Clerk of Council FINANCE COMMITTEE AGENDA ITEM #: 5 GREATER LYNCHBURG TRANSIT COMPANY We're Here To Get You There! Finance Committee Lynchburg City Council F ebruary 15th, 2023 R e: GLTC Quarterly Financial Report – 2nd Quarter 2023 REVENUE G LTC has experienced higher than anticipated revenues in Fixed Route fares with a 20% positive variance over the anticipated totals for the quarter. Paratransit fare revenues are up 21% this quarter, non- operating revenues are up 85% this quarter, and advertising revenue is down 40% for this quarter due to multiple advertisers cutting back due to the current economic conditions. City, County, State, and Federal operating assistance revenues have been disbursed to GLTC on-time. There is a decrease of 18% in State and 9% in Federal funds due to the GLTC utilizing the remaining ARPA funds at its disposal before allocating the standard State and Federal 5307 Operating funds as these funds cannot be comingled. These funds are available, but current projections do not have GLTC finishing ARPA funds until mid-February. GLTC also was reimbursed $99,371 in February 2023 for the 2nd Quarter expenses for the TRIP grant, which does not show in this quarter’s report. EXPENSES Fixed Route Total Fixed Route expenses are 1% under budget for the quarter. Overtime for this quarter had decreased significantly at 25% below budget with the addition of new operators. Other Salaries and Wages show an increase as this the changes in employee pay which occurred in September of 2022. Fringes and Supervisor over time are down for the quarter 34% and 9% respectively. Demand Response (PTS) Total Demand Response expenses are 21% below budgeted numbers this quarter primarily due to positional vacancies creating savings in operator labor and fringe benefits of 15% and 29% respectively. Overtime is over budget by 11% due to this operational vacancy. Salaries and wages for the remaining staff in this department are down 26% for the quarter, with fringes 29% below due to increased part time staff. Maintenance Maintenance wages and salaries are at 4% below budgeted. Inspection and Servicer Overtime is 67% below budget as workload on staff eased as job openings have been filled. Benefits for both groups are down 18% for the quarter due to several positions being part-time, or employees not taking benefits FINANCE COMMITTEE AGENDA ITEM #: 6 GREATER LYNCHBURG TRANSIT COMPANY We're Here To Get You There! through us. Fuel and lubricant have eased and are 6% over budget for the quarter, but still 11% over for the year. Diesel prices spiked considerably in October and early November but have now eased from their high points, but volatility in pricing remains a concern. Tires were 17% under for the quarter but are still at 69% over for the year due to inflationary prices in the first quarter. Other materials and supplies are currently 34% below budget for this quarter as GLTC has experienced easing in the pricing of parts and scarcity, but shipping costs have remained high. GLTC had delayed several planned programs until fuel pricing stabilized and will begin work on them in the 3 rd and 4th quarters. We are planning a preventative campaign on our paratransit vehicles to replace parts and perform minor overhauls while sufficient parts quantities are available to ensure that these vehicles will be operational and require less non-routine maintenance in the future as they are experiencing severe disruptions in the production cycles of these vehicles with substantially longer lead times than normal. Overall, Maintenance was down 10% this quarter mainly due conservation of tires, materials, and overtime, but these were balanced by higher prices for fuel for most of the quarter. Administration Administration is currently 19% below budget. Services were 3% over budget, with IT being 38% over budget with increased fees for some services adding the additional costs. Due to safe driving habits and reduced accident experience rates, Casualty and Liability insurance is 42% under budget for this quarter. Utilities are over budget by 9% this quarter coinciding with the rate increases for both AEP and Columbia Gas. Miscellaneous expenditures are lower this quarter as several of the programs will not be active until the 3 rd and 4th quarters of FY 2023. SUMMARY For the quarter, total expenses were under budget by 10% ($22,234). For the year, GLTC currently is over budget by 8% ($54,187) This does not include the $313,654 in 5307 funds which were budgeted and allocated but have not been drawn down or the $99,371 for the TRIP grant which was paid in February 2023. 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 FINANCE COMMITTEE AGENDA ITEM #: 6 CENTRAL VIRGINIA TRANSIT MANAGEMENT CO INC. QUARTERLY INCOME STATEMENT AS OF DECEMBER 31, 2022 QTR TO DATE FY2023 FY2023 FY2023 FY2023 % QTD QTD % YTD YTD o f ACTUAL BUDGET VAR ACTUAL BUDGET Budget REVENUE FRT Passenger Revenue 113,449$ 94,248 $ 20% 228,349 $ 188,496 $ 121% DRT Passenger Revenue 10,629 8,766 21% 17,419 17,532 99% Contracts (CVCC Access) 11,814 11,814 0% 23,628 23,628 100% Non-Operating Revenue 3,000 1,625 85% 6,884 3,250 212% Advertising Revenue 8,228 13,750 -40% 17,721 27,500 64% City Operating Assistance 316,613 316,614 0% 633,226 633,227 100% County Operating Assistance 19,450 19,450 0% 38,900 38,900 100% State Operating Assistance 502,452 610,032 -18% 1,004,904 1,220,064 82% Federal Operating Assistance 1,128,972 1,244,701 -9% 2,257,944 2,489,403 91% TOTAL REVENUE 2,114,606$ 2,321,000$ -9% 4,228,975$ 4,642,000$ 91% EXPENSES FIXED ROUTE Operator Labor 416,013 $ 416,257 $ 0% 842,974 $ 832,515 $ 101% Operator-Overtime 39,789 53,074 -25% 78,517 106,149 74% Other Salaries & Wages 125,998 96,338 31% 257,360 192,677 134% Supervisors-Overtime 3,265 4,956 -34% 5,720 9,912 58% Fringe Benefits 253,928 278,486 -9% 521,865 556,972 94% TOTAL FIXED ROUTE 838,993$ 849,112 $ -1% 1,706,434$ 1,698,223$ 100% DEMAND RESPONSE Operator Labor 75,197 $ 88,852 $ -15% 140,754 $ 177,703 $ 79% Operator-Overtime-PTS 2,939 2,655 11% 5,662 5,311 107% Other Salaries & Wages 20,489 27,560 -26% 37,230 55,120 68% Fringe Benefits 42,907 60,246 -29% 80,906 120,492 67% TOTAL DEMAND RESPONSE 141,533$ 179,313 $ -21% 264,553$ 358,62 6$ 74% MAINTENANCE Other Salaries & Wages 189,119$ 197,050 $ -4% 382,758 $ 394,100 $ 97% Inspection&Maint,Srvc-Overtim e 4,478 13,775 -67% 8,337 27,550 30% Fringe Benefits 84,030 102,729 -18% 172,298 205,458 84% Fuel & Lubricants 236,226 222,568 6% 493,918 445,135 111% Tires & Tubes 27,982 33,625 -17% 46,529 67,250 69% Other Materials & Supplies 76,457 115,422 -34% 174,418 230,845 76% TOTAL MAINTENANCE 618,291$ 685,169 $ -10% 1,278,258$ 1,370,338$ 93% ADMINISTRATION Other Salaries & Wages 126,918$ 175,278 $ -28% 252,477 $ 350,555 $ 72% Fringe Benefits 55,113 68,449 -19% 111,229 136,897 81% Services 142,279 138,293 3% 305,353 276,585 110% Utilities 51,581 47,219 9% 94,599 94,437 100% Casualty & Liability Expenses 41,698 71,821 -42% 108,597 143,641 76% Information Technology 57,277 41,382 38% 116,272 82,765 140% Other Materials & Supplies 10,029 16,519 -39% 17,795 33,038 54% Miscellaneous 8,661 48,448 -82% 27,595 96,896 28% TOTAL ADMINISTRATION 493,555$ 607,407$ -19% 1,033,917$ 1,214,814$ 85% TOTAL EXPENSES 2,092,372$ 2,321,000 $ -10 % 4,283,162$ 4,642,000 $ 92% NET INCOME/(LOSS) 22,234$ - $ 100% (54,187)$ - $ 100% FINANCE COMMITTEE AGENDA ITEM #: 6 -�!--u,n_ 0'�-,�-,�-"�-�"-=-�,-"�-,�--:--dio_n_a_l_A_ir __ p_o _rt _________ '4t_ Finance Committee City Council City of Lynchburg Lynchburg, Virginia February 15, 2023 350 Terminal Drive • Suite 100 Lynchburg, Virginia 24502 P 434-455-6090 • F 434-239-9027 www.lynchburgva.gov/airport Re: December 31, 2022 - Quarterly Financial Summary - Lynchburg Regional Airport REGIONAL AIRPORT FUND The attached Lynchburg Regional Airport Operating Fund Financial Summary reflects the financial activity through the FY2023 second quarter ending December 31, 2022. Operating revenues are continuing their slow but steady increase to pre-COVID levels even as American Airlines contends with equipment challenges/staffing shortages. With the aid of our federal COVID-19 CARES/CRRSA/ ARP A grants, the Airport is projecting a FY2023 surplus of $417,025 which is $186,690 more than our Adopted Budget. REVENUE HIGHLIGHTS • Terminal Revenue: Revenue is projected to be $133,000 more than budget due to projected increases in both rental car and parking lot concessions revenue. • General Aviation Revenue: Revenue is projected to be $25,000 more than budget due to increases in aircraft fuel sales and aircraft parking fees. • Federal CARES/CRRSA/ARPA Grants Revenue: Revenue is projected to be $1,168,572 less than budget due to projecting less CARES/CRRSA/ ARP A eligible expenses than authorized. • Interest & Other Revenue: Revenue is projected to be $80,000 more than budget due to increased interest earnings on invested retained earnings. --------------- Check�Lynchburg First-------------- FINANCE COMMITTEE AGENDA ITEM #: 6 FINANCE COMMITTEE AGENDA ITEM #: 6 LYNCHBURG REGIONAL AIRPORT OPERATING FUND FINANCIAL SUMMARY December 31, 2022 FY 2023 $ Variance FY 2022 FY 2022 FY 2022 * FY 2023 FY 2023 FY 2023 * FY 2023 FY 2023 Projected vs. Amended Actual % of * Amended Actual % of * Amended Projected Amended Budget (thru 12/31/21) Budget * Budget (thru 12/31/22 Budget * Budget Total Budget * * BEGINNING NET ASSETS 250,000$ 34,950,037$ * 250,000$ 34,198,656$ (1) * 250,000$ 34,198,656$ (1) Less: Invested in Capital Assets, net of related debt (34,982,320) * (33,156,798) * (33,156,798)$ * * BEGINNING UNRESTRICTED NET ASSETS 250,000$ (32,284)$ * 250,000$ 1,041,856$ * 250,000$ 1,041,856$ -$ * * USE OF ENCUMBRANCES CARRIEDFORWARD 490,663$ 215,397$ 215,397$ TRANSFER OF RESERVES TO CAPITAL FUND * * REVENUES * * Airfield 95,000 46,362 49% * 100,000 55,745 56% * 100,000 100,000 0 Terminal 1,284,583 686,002 53% * 1,253,383 825,833 66% * 1,253,383 1,386,383 133,000 General Aviation 594,000 327,702 55% * 689,650 410,462 60% * 689,650 714,650 25,000 Other Leased Property 402,050 194,448 48% * 408,050 219,115 54% * 408,050 408,050 0 State Airport Aid 535,000 321,188 60% * 135,000 0 0% * 135,000 135,000 0 Federal Security Aid 87,000 22,080 25% * 87,000 29,520 34% * 87,000 87,000 0 Federal CARES/CRRSA/ARPA Grants 4,429,578 1,162,663 26% * 3,568,572 1,474,922 41% * 3,568,572 2,400,000 (1,168,572) Interest & Other 55,000 37,236 68% * 55,000 84,739 154% * 55,000 135,000 80,000 * * TOTAL REVENUES 7,482,211$ 2,797,681$ * 6,296,655$ 3,100,336$ * 6,296,655$ 5,366,083$ (930,572)$ * * EXPENSES * * Airfield Operations 304,719 115,384 38% * 311,025 144,119 46% * 311,025 311,025 0 Terminal Operations 664,597 293,854 44% * 628,875 257,583 41% * 628,875 628,875 0 General Aviation 145,815 44,439 30% * 148,119 66,410 45% * 148,119 148,119 0 Administration 935,744 470,454 50% * 971,418 545,299 56% * 971,418 971,418 0 Safety (ARFF & LEO) 439,510 231,708 53% * 454,889 260,148 57% * 454,889 454,889 0 Snow Removal 24,030 1,360 6% * 24,030 13,725 57% * 24,030 24,030 0 Debt Service 103,312 6,169 6% * 103,515 5,266 5% * 103,515 103,515 0 Small Projects & Equip. (CARES/CRRSA/ARPA Supported) 4,089,809 688,853 17% * 2,532,659 596,897 24% * 2,532,659 1,200,000 1,332,659 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 43,532 24,286 56% * 62,188 24,139 39% * 62,188 62,188 0 Year-end GASB68 & GASB75 Retiree Accrual Adjustments 15,000 0 45,000 0 45,000 45,000 0 * * TOTAL EXPENSES 7,766,068$ 1,876,506$ * 6,281,717$ 1,913,586$ * 6,281,717$ 4,949,058$ 1,332,659$ * * ENDING UNRESTRICTED NET ASSETS 456,806$ 888,890$ * 480,335$ 2,228,606$ * 480,335$ 1,458,880$ (2) FOOTNOTES: 1) Beginning Net Assets agrees with the Comprehensive Annual Financial Report (CAFR) with the following adjustment: 50,599,946$ (16,401,290)$ Total Revenues 5,366,083$ 34,198,656$ Total Expenses 4,949,058$ FY2023 Surplus 417,025$ 2) FY 2023 Ending Unrestricted Net Assets is comprised of the following: 88,132$ ($88,131.96 beginning + or - year end adjustment to/ from reserve) (encumbrances carried forward to FY2024) (1,040,174)$ (net liability as of the end of FY2022) (762,952)$ (net liability as of the end of FY2022) 1,026$ (net receivables as of the end of FY2022) 3,172,848$ 1,458,880$ 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 GASB87 Net Lease Receivables FY2023 Projected TotalsTotal Net Assets per CAFR 6/30/22 Less: Net Assets in Capital & PFC Funds 2/20/2023 FINANCE COMMITTEE AGENDA ITEM #: 6 February 28, 2023 Finance Committee City Council City of Lynchburg Lynchburg, Virginia RE: December 31, 2022, 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 , 2022, for FY 2023. The financial spreadsheet provides comparative year-to-date data for the same period of FY 2022. REVENUES Charges for Services Revenue in this category for the second quarter of FY 2023 is $625,720 or 39.2% of the budget. Department of Juvenile Justice Block Grant This revenue category represents allocations from the Virginia Department of Juvenile J ustice (DJJ) for operational expenses of the Detention Center. Revenues received from the DJJ through the second quarter of FY 2023 are $532,338 or 52.3% of the budget. United States Department of Agriculture (USDA) This revenue category consists of reim bursements for meals served to juveniles at the Detention Center. Year-to-date revenues from USDA for FY 2023 are $22,918 or 57.3% of the budget. EXPENDITURES Overall expenditures for the second quarter of FY 2023 were $1,285,320 or 36.6% of the budget. Juvenile Population The average number of juveniles being served per day through the second quarter of FY 2023 is 11.16 as compared to 17.56 in FY 2022. The percentage of Lynchburg City’s juveniles through the second quarter is 45% of the total juvenile population. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee February 28, 2023 Page 2 SUMMARY The Lynchbu rg Regional Detention Center i s recognized by the juvenile judicial system for providing educational services, mental health services, physical health services, and partn erships with local area businesses. The total revenue through the second quarter is $1,184,126 and the total expenditures are $1,285,320. Respectfully submitted, Preston Sellers Director, Department of Human Services c: W ynter Benda, City Manager Gregory Patrick, Deputy City Manager John Hughes, IV, Assistant City Manager Donna Witt, Director, Financial Services Sherry McIntyre, Accountant, Juvenile Services FINANCE COMMITTEE AGENDA ITEM #: 6 FY 2022 FY 2022 FY 2022 FY 2023 FY 2023 FY 2023 FY 2023 FY 2023 FY 2023 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 201,324 321,805 * 321,805 Revenues: Charges for Services 1,175,420 562,790 47.9% 1,596,689 625,720 39.2% 1,596,689 625,720 970,969 Intergovernmental- Department of Juvenile Justice Block Grant 1,017,086 508,544 50.0% 1,017,086 532,338 52.3% 1,017,086 532,338 484,748 Intergovernmental- USDA 48,000 16,900 35.2% 40,000 22,918 57.3% 40,000 22,918 17,082 Community Placement Program (CPP) 892,600 821,275 92.0% 850,000 0 0.0% 850,000 0 850,000 Miscellaneous and State Ward Per Diem 0 1,450 0.0% 1,400 3,150 225.0% 1,400 3,150 (1,750) Budget Designations 99,489 0 0.0% 0 0 0.0% 0 0 0 Total Revenues 3,232,595 1,910,959 59.1% 3,505,175 1,184,126 33.8% 3,505,175 1,184,126 2,321,049 Expenditures: Salaries 1,606,101 799,193 49.8% 1,835,184 690,351 37.6% 1,835,184 690,351 1,144,833 Employee Benefits 742,529 301,854 40.7% 834,407 276,735 33.2% 834,407 276,735 557,672 Contractual Services 45,098 30,439 67.5% 55,831 20,293 36.3% 55,831 20,293 35,538 Fleet Services 16,958 5,532 32.6% 14,868 4,825 32.5% 14,868 4,825 10,043 Supplies and Materials 216,902 86,540 39.9% 201,900 51,693 25.6% 201,900 51,693 150,207 Utilities 80,750 26,908 33.3% 80,750 30,787 38.1% 80,750 30,787 49,963 Training and Conferences 42,550 1,510 3.5% 23,739 661 2.8% 23,739 661 23,078 Telephone Services 4,993 3,148 63.0% 6,540 3,381 51.7% 6,540 3,381 3,159 Cable/Satellite TV Service 1,460 717 0.0% 1,825 891 48.8% 1,825 891 934 Postage and Mailing 850 70 8.2% 850 45 5.3% 850 45 805 Indirect Costs 274,936 137,468 50.0% 272,270 136,135 50.0% 272,270 136,135 136,135 Self Insurance 20,230 10,115 50.0% 24,310 24,310 100.0% 24,310 24,310 0 Dues and Memberships 500 50 10.0% 500 0 0.0% 500 0 500 Misc. Other Charges 49,464 5,149 0.0% 26,367 199 0.8% 26,367 199 26,168 Rentals and Leases 4,473 1,552 34.7% 4,309 1,637 38.0% 4,309 1,637 2,672 Health and Dental Benefits for Retirees 63,168 28,416 45.0% 63,168 30,000 47.5% 63,168 30,000 33,168 Unemployment Compensation 1,000 80 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,160 4,722 91.5% 13,020 4,728 36.3% 13,020 4,728 8,292 Serial Bond Principal 6,650 6,650 100.0% 7,000 7,000 100.0% 7,000 7,000 0 Serial Bond Interest 3,465 1,816 52.4% 3,124 1,649 52.8% 3,124 1,649 1,475 Bud Alc Salary Plan Adj 37,045 0 0.0% 0 0 0.0% 0 0 0 TrTo Int Ser Fleet Fund 0 0 0.0% 35,410 0 0.0% 35,410 0 0 Total Expenditures 3,234,282 1,451,929 44.9% 3,516,372 1,285,320 36.6% 3,516,372 1,285,320 2,195,642 TOTAL FUND BALANCE 660,354 220,611 220,611 * The July 1 beginning funds for FY 2023 include $230,665 that is related to the Community Placement Program. Lynchburg Regional Juvenile Detention Center Special Revenue Fund Financial Summary Second Quarter: As of December 31, 2022 FINANCE COMMITTEE AGENDA ITEM #: 6 February 28, 2023 Finance Committee City Council City of Lynchburg Lynchburg, Virginia Re: Children’s Services Act (CSA) Fund Financial Report for the period ending December 31, 2022. The attached CSA Fund Financial Summary outlines the financial activity through December 31, 2022. 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%. Administrative funds to assist in administering the grant, ($ 35,322) for FY 2023 are provided by the State of Virginia. The State of Virginia r eimbursements for the Children’s Services grant expenditures incurred through the second quarter of 2023 are $2,159,135 or 46.5% of the budget. • CSA Contribution – General Fund and Schools These revenue sources are comprised of the required local match for all State funds received for the Children Services Act. Through the second quarter of FY 2023, local matching funds for programs in the amount of $98,270 or 50% of the budget from the Schools and $1,019,772 or 50% of the budget from the General Fund have been received. • Miscellaneous Revenue/Budget Designations Miscellaneous Special Welfare revenues in the amount of $12,249 or 25.2% of the budget w ere collected through the second quarter of FY 2023. These revenues are mainly comprised of recoupments from children’s social security payments for expenditures incurred on their behalf, and registered billings for CSA parental co-payments. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee February 28, 2023 Page 2 EXPENSES • Administrative expenses CSA Administrative funds are used for salaries, supplies, and materials. Budgeted funds for FY 2023 are $71,917. Actual YTD administrative expenditures through the second quarter of FY 2023 a re $33,231 or 46.2% of the budget. • Sum-Sufficient– Foster Care Foster care expenses include funds for residential facilities, day care, maintenance payments to foster parents, enhanced maintenance payments to foster parents and foster care prevention services. Year-to- date foster care expenditures through the second quarter of FY 2023 totaled $1,512,953 or 51.6% of the total budget. Expenditures in this category can rise due to an increase in the number of children placed in foster care, and less children being eligible for federal funding. • Sum-Sufficient– Special Education Special Education expenses include services for Special Education students from the Lynchburg City Schools. Expenditures through the second quarter of FY 2023 total $1,414,206 or 50.1% of the total budget. Expenditures for this budget line will increase or decrease due to enrollments at private day placements such as Rivermont School, Bridges and New Vistas School, in addition to students attending for longer periods of time. • Non-Sum Sufficient Services (Non-Mandated) Non-Sum Sufficient expenditures are for services such as counseling, mentoring, crisis intervention, and foster care prevention services. Non-Sum Sufficient expenditures through the second quarter of FY 2023 total $9,285, or 2.5 % of the total budget . Non-Sum Sufficient services are provided almost exclusively to youth involved in the c ourt system. Decreases compared to budget for this category are attributed to the Court Services Unit accessing alternate funding for court-involved youth. • Community Base (Sum/Non-Sum Sufficient) Services This category includes services to children while they are living at home, in the home of an extended family, in a regular foster family home, or in an independent living arrangement. Community services may include assessment, crisis stab ilization, therapy, or intervention services provided in the child’s home. Community Based Services through the second quarter of FY 2023 total $188,468, or 26.1% of the total budget. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee February 28, 2023 Page 3 SUMMARY While the number of children currently in foster care fluctuates during the year , more children are now classified as “Sum-Sufficient” mandated and can access CSA funds due to the severity of their needs. Other factors can be an increased number of children receiving more intensive services for longer periods of time, increased vendor rates , parental agreements, and an increase in special educational services impact this budget. Respectfully submitted, Preston Sellers Director of Human Services c: Wynter Benda, City Manager Gregory Patrick, Deputy City Manager John Hughes, Assistant City Manager Donna Witt, Director of Financial Services Rhonda Allbeck, Assistant Director of Financial Services Kathy Collins, Financial Professional IV FINANCE COMMITTEE AGENDA ITEM #: 6 FY 2022 FY 2022 FY 2022 FY 2023 FY 2023 FY 2023 Amended Actual 2nd QTR % of Amended Actual 2nd QTR % of Budget YTD Budget Budget YTD Budget Beginning Fund Balance 281,810 0 362,856 Revenues: Public Assistance - Welfare and Administration 4,638,176 1,716,478 37.0% 4,638,778 2,159,135 * 46.5% Transfer from Lynchburg City Schools 196,541 98,271 50.0% 196,541 98,270 50.0% Transfer from General Fund 2,037,813 1,019,038 50.0% 2,039,543 1,019,772 50.0% Miscellaneous/Special Welfare 48,600 20,170 41.5% 48,700 12,249 25.2% Budget Designations 0 0 0 0.0% Total Revenues 6,921,130 2,853,957 41.2% 6,923,562 3,289,426 47.5% Expenses: Administrative Expenses 70,060 29,998 42.8% 71,917 33,231 46.2% Sum-Sufficient - Foster Care 2,944,500 1,394,245 47.4% 2,932,330 1,512,953 51.6% Sum-Sufficient - Special Education 2,738,790 811,366 29.6% 2,821,658 1,414,206 50.1% Non-Sum Sufficient Services 375,907 17,934 4.8% 375,907 9,285 2.5% Sum-Sufficient and Non-Sum Sufficient Services 791,873 267,796 33.8% 721,750 188,468 26.1% Miscellaneous/Budget Designations/Transfer to GF 0 0 0 0 Total Expenditures 6,921,130 2,521,339 36.4% 6,923,562 3,158,143 45.6% ENDING FUND BALANCE 0 614,428 0 494,139 Children's Services Act Special Revenue Fund Financial Summary December 31, 2022 * Will be received on 2/28/23 for December'22 expenses $665,473. FINANCE COMMITTEE AGENDA ITEM #: 6 February 28, 2023 Finance Committee City Council City of Lynchburg Lynchburg, Virginia Re: December 31, 2022 Quarterly Financial Report – Sewer Operating Fund The attached Sewer Operating Fund Financial Summary summarizes the financial activity for this fund through December 31, 2022. This quarterly report provides comparative financial information for the same period of the prior fiscal year . Projected variances between the FY 202 3 Adopted B udget and the Department’s year-end projections are described below. REVENUES Following the completion of the second quarter, overall revenues for FY 2023 are projected to be $577,900 (2.1%) greater than budget. Explanations of this variance follow: • Charges for Services: Revenue in this category is projected to be $89,000 (0.4%) under budget mostly due to the following: 1) Inside City Sewer Sales de crease of $60,000 is attributable to domestic, commercial and industrial, and institutional customer types. 2) Industrial Surcharges decrease of $60 ,000. These decreases in revenue were partially offset by $33,000 of increased connection charges and availability fees. • Sewer Contracts: Revenue in this category reflects billing activity in the counties of Amherst, Bedford, and Campbell and the industries of WestRock and Frito- Lay. Revenue is projected to be $225,900 (5.1% ) over budget. Projected sewer sales and industrial surcharges from WestRock and Frito-Lay are $350,000 higher than budget. This is offset by $124,100 lesser than expected county sales for sewer treatment services and capital reimbursements. Decreases in county sales for sewer treatment is primarily associated with a closing of one large industrial business in Bedford County. Less than anticipated county capital reimbursements are correlated with deferred completion of Water Resources Recovery Facility projects and deferred delivery of several large equipment purchases that were impacted by supply chain issues. • Interest and Other: Revenue is this category is projected to be $441,000 (1,428.6%) greater than budget primarily due to higher than anticipated interest rates on investments. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee February 28, 2023 Page 2 EXPENSES Overall expenses for FY 2023 are projected to be $1,201,500 (4.3%) greater than budget. Explanations of this variance follow: • Departmental Operation and Maintenance: Departmental Operation and Maintenance expenses are projected to be $1, 131,000 (7.7%) more t han budget. This category includes the Water Resources Recovery Facility (WRRF) and Sewer Line Maintenance. The WRRF is projected to be $1,212,000 over budget and Sewer Line Maintenance is projected to be $81,000 under budget. These variances are broken down as follows:  Personnel Services and Benefits $ 38,500  Chemicals (302,000)  Utilities (295,900)  Supplies and Materials (203,900)  Contractual Services (200,100)  Rentals and Leases (137,000)  All Other (30,600) Total ($ 1,131,000) The increased cost in Chemicals is associated with new contract pricing that became effective January 1, 2023. Cost increases for primary chemicals used range from 10% to 119%. The increased cost in Utilities is mostly due to an unexpected large increase in electricity rates. American Electric Power’s fuel factor rate increased 51% starting October 19, 2022. The increase in Supplies and Materials is mostly related to an increase in WRRF replacement equipment parts . Contractual Services increase primarily consists of the following combination: 1) Refuse Hauling of $115,000 to cover WRRF driver vacancies. 2) Increased WRRF building and grounds maintenance costs of $105,000 mostly associated with aging buildings and fencing with in creased costs of labor and materials. 3) Higher than expected WRRF Plant and Equipment Repair Services of $100,000. These overages were partially offset by savings in Sewer Line Maintenance Sewer/Storm maintenance and repair services of $140,000 mostly due to deferral of the James River Interceptor sonar evaluation until Fall, 2023. The increase in Rentals and Leases is primarily related to outsourcing sludge trailer logistics due to WRRF driver vacancies and rental of HVAC units at the WRRF. • Non-Departmental Operation and Maintenance: Non-Departmental Operation and Maintenance expenses are projected to be at budget. • Capital Outlay: Purchases in Capital Outlay are projected to be $9,500 (1.3%) under budget. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee February 28, 2023 Page 3 • Transfers to Capital: Transfers to Capital are projected to be at budget. • Debt Service: Expenditures in debt service are projected to be $80,000 (0.9 %) above budget due to higher than budgeted interest rates used to calculate interest payments for proceeds from current line of credit. SUMMARY This second quarter report reflects a stable FY 202 3 financial position for this fund. Under the Council adopted financial policies, two important financial ratios, debt coverage and fund balance are projected to be within policy targets. The projected debt coverage ratio for the fiscal year is 1.37 compared to a target range of 1.20 to 1.50. The projected fund balance ratio for the fiscal year is 36% 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 FINANCE COMMITTEE AGENDA ITEM #: 6 SEWER OPERATING FUND FINANCIAL SUMMARY Quarter Ending December 31, 2022 FY 2023 FY 2022 FY 2022 FY 2022 FY 2023 FY 2023 FY 2023 FY 2023 FY 2023 $ 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 $19,440,774 $9,593,646 49% $23,046,719 $10,288,150 45% $23,046,719 $22,957,719 ($89,000) Sewer Contracts 4,017,566 2,879,833 72% 4,470,778 2,054,221 46% 4,470,778 4,696,678 225,900 Interest and Other 51,500 18,531 36% 30,870 295,330 957% 30,870 471,870 441,000 $23,509,840 $12,492,009 $27,548,367 $12,637,701 $27,548,367 $28,126,267 $577,900 EXPENSES: Departmental O&M $12,624,579 $6,075,536 48% $14,716,969 $6,849,623 47% $14,716,969 $15,847,969 ($1,131,000) Non-Departmental O&M 272,852 95,099 35% 264,907 99,600 38% 264,907 264,907 - Capital Outlay/Purchases 795,000 115,084 14% 715,000 380,715 53% 715,000 705,500 9,500 Transfers to Capital 2,000,000 1,000,000 50% 3,300,000 1,651,750 50% 3,300,000 3,300,000 - Debt service 8,905,557 4,542,836 51% 8,820,175 4,676,037 53% 8,820,175 8,900,175 (80,000) $24,597,988 $11,828,554 $27,817,051 $13,657,725 $27,817,051 $29,018,551 ($1,201,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: 36% Financial Policy targeted debt coverage ratio minimum: 1.20 Ending debt coverage ratio: 1.37 (a) Note (a) Calculation of debt coverage includes $150,000 of capitalizable costs for internal labor charges applicable to time spent on capital project activities. Sewer Operating 2/20/2023 FINANCE COMMITTEE AGENDA ITEM #: 6 February 28, 2023 Finance Committee City Council City of Lynchburg Lynchburg, Virginia Re: December 31, 2022 Quarterly Financial Report – Stormwater Operating Fund The attached Stormwater Operating Fund Financial Summary summarizes the financial activity for this fund through December 31, 2022. This quarterly report provides comparative financial information for the same period of the prior fiscal year. Projected variances between the FY 2023 Budget and the Department’s year-end projections are described below. REVENUES Following the completion of the second quarter, the overall revenues for FY 2023 are projected to exceed budget by $107,500 (2.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 exceed budget by $16,500 (0.5%). This is mostly associated with new impervious areas from construction within the City. • Interest and Other: Interest and Other is proj ected to exceed budget by $91,000 (1,137.5%). This is primarily due to combination of higher than expected interest rates on investments and a National Oceanic Atmospheric Administration (NOAA) grant that was originally set to expire in fiscal year 2021 was extended to August 31, 2022. The extension was given because of the impacts of COVID-19. These grant proceeds did not require a local match and were used for reimbursement of expenses directly associated with elementary student environmental education and engagement. These grant eligible expenses are discussed in the Non-Departmental Operation and Maintenance category. • Transfers from Other Funds: Transfers from General Fund are projected to be at budget. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee February 28, 2023 Page 2 EXPENSES Overall expenses for FY 2023 are projected to be $87,750 (2.1%) under budget. Explanations of this variance follow: • Departmental Operation and Maintenance: Departmental Operation and Maintenance is projected to be $108,600 (3.0%) below budget. This variance is broken down as follows:  Personnel Services and Benefits $54,300  Supplies and Materials 82,900  Public Works and Community Development (35,000)  All Other $6,400 Total $108,600 Personnel Services and Benefits savings is attributable to past and current unfilled positions . Supplies and Materials savings were primarily the result of less materials used in stormwater repairs. Public Works reimbursable leaf collection costs were greater than budget due to unbudgeted wage adjustments to bring several City job classifications closer to fair market value and decreas e wage compression within each job classification. These unbudgeted wage adjustments are being absorbed within the fund to meet overall budgeted expenditures for FY 2023. • Non-Departmental Operation and Maintenance: Non-Departmental Operation and Maintenance expenses are projected to exceed budget by $25,100 (95.8%). This is related to unanticipated extension of the NOAA Grant for reimbursable elementary student educational and engagement expenses. Other details of the N OAA Grant are discussed in the revenue category of Interest and Other. • Capital Outlay: Capital Outlay is projected to be at $8,750 over budget due to a paver cleaning machine that was budgeted and ordered in the previous fiscal year but did not arrive until September, 2022. • Transfers to Capital: Transfers to Capital are projected to be at budget. • Debt Service: Debt Service expenditures are projected to be $13,000 (6.9%) under budget due to a restructure of annual loan payments to Virginia Resource Authority (VRA) decreasing by $6,300 a year. This is related to unused loan proceeds for a recently completed Stormwater Project. In addition, $6,700 in lesser interest is projected to be paid on current line of credit for projects that were scheduled to be completed in FY 2022 were completed in FY 2023. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee February 28, 2023 Page 3 SUMMARY The second quarter report reflects a stable FY 2023 financial position for this fund. Under the Council adopted financial policies, two important financial ratios, debt coverage and fund balance are projected to be above policy targets. The projected debt coverage ratio for the fiscal year is 2.35, 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%. 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 FINANCE COMMITTEE AGENDA ITEM #: 6 STORMWATER OPERATING FUND FINANCIAL SUMMARY Quarter Ending December 31, 2022 FY 2023 FY 2022 FY 2022 FY 2022 FY 2023 FY 2023 FY 2023 FY 2023 FY 2023 $ 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,366,400 $1,539,605 46% $3,554,750 $1,548,651 44% $3,554,750 $3,571,250 $16,500 Interest and Other 6,000 16,211 270% 8,000 63,854 798% 8,000 99,000 91,000 Transfers from Other Funds 275,000 137,500 50% 275,000 137,500 50% 275,000 275,000 - $3,647,400 1,693,316 $3,837,750 $1,750,004 $3,837,750 $3,945,250 $107,500 EXPENSES: Departmental O&M $3,361,256 $1,592,702 47% $3,623,518 $1,641,329 45% $3,623,518 $3,514,918 $108,600 Non-Departmental O&M 31,176 16,199 52% 26,210 37,707 144% 26,210 51,310 (25,100) Capital Outlay/Purchases 10,000 - 0% 0 8,750.00 0% 0 8,750 (8,750) Transfers to Capital 450,000 225,000 50% 270,000 135,000 50% 270,000 270,000 - Debt Service 185,655 75,736 41% 187,854 26,481 14% 187,854 174,854 13,000 $4,038,087 $1,909,637 $4,107,582 $1,849,267 $4,107,582 $4,019,832 $87,750 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.35 (a) Note (a) Calculation of debt coverage includes $32,000 of capitalizable costs for internal labor charges applicable to time spent on capital project activities. Stormwater Operating 2/20/2023 FINANCE COMMITTEE AGENDA ITEM #: 6 February 28, 2023 Finance Committee City Council City of Lynchburg Lynchburg, Virginia Re: December 31, 2022 Quarterly Financial Report – Water Operating Fund The attached Water Operating Fund Financial Summary summarizes the financial activity for this fund through December 31, 2022. This quarterly report provides comparative financial information for the same period of the prior fiscal year . Projected variances between the FY 2023 Adopted B udget and the Department’s year-end projections are described below. REVENUES Following the completion of the second quarter, overall revenues for FY 2023 are projected to be $366,100 (2.3%) more than budget. Explanations of this variance follow: • Charges for Services: Revenue in this category is projected to be $9,500 (.1%) more than budget. This primarily due to water connections, availability charges and hydrant rentals are $61,500 more than expected partially offset by lower than expected water cost plus services of $36,000 and decreased noncontract water sales of $25,000. • Water Contracts: Revenue in this category reflects billing activity to the counties of Amherst, Bedford, and Campbell, and to the industries of WestRock and Frito-Lay. Revenue is projected to be $85,600 (3.9%) more than budget. This is primarily due to WestRock and Frito- Lay water purchases are $80,000 more than estimated. • Interest and Other: Interest and Other i s projected to be $271,000 (1,063% ) more than budget mostly due to higher than anticipated interest rates on investments. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee February 28, 2023 Page 2 EXPENSES Overall expenses for FY 20 23 are projected to be $47,600 (0.3% ) below budget. Explanations of this variance follow: • Departmental Operation and Maintenance: Departmental Operation and Maintenance expenses are projected to be $102,600 (0.9%) less than budget. This category includes the Water Treatment Plant, Meter Operations, Water Line Maintenance and Administration. (Water Treatment - $94,100 over budget, Meter Operations - $3,500 over budget, Water Line Mai ntenance - $153,600 savings, Administration - $46,600 savings). This variance is broken down as follows:  Personnel Services and Benefits $ 134,500  Supplies and Materials 80,800  Chemicals  Utilities (67,000) (20,000)  All Other (25,700) Total $102,600 Personnel Services and Benefits savings is attributable to past and current unfilled positions. Supplies and Materials savings is primarily due to a decrease in parts used for water system and meter repairs. Chemicals is over budget primarily due to higher than expected contract pricing that became effective January 1, 2023. Utilities is over budget due to increased electricity rates starting October 19, 2022. All Other is over budget largely due to increased costs for fuel and vehicle repairs. • 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 $5,000 (10.6%) over budget . This is associated with purchasing an emergency duress system that will be purchased this fiscal year which was previously budgeted for last fiscal year. • Transfers to Capital: Transfers to Capital are projected to be at budget. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee February 28, 2023 Page 3 • Debt Service: Expenditures in debt service a re project ed to be $50,000 (1.5 %) above budget due to higher than budgeted interest rates used to calculate interest payments for proceeds from the current line of credit. SUMMARY The second quarter report reflects a stable FY 202 3 financial position for this fund. Under the Council adopted financial policies, two important financial ratios, debt coverage and fund balance are projected to be above policy targets. The projected debt coverage ratio fo r the fiscal year is 1.34, which is above Council’s financial policy minimum target of 1.20 . The projected fund balance ratio for the fiscal year is 42% compared to the target range of 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 FINANCE COMMITTEE AGENDA ITEM #: 6 WATER OPERATING FUND FINANCIAL SUMMARY Quarter Ending December 31, 2022 FY 2023 FY 2022 FY 2022 FY 2022 FY 2023 FY 2023 FY 2023 FY 2023 FY 2023 $ 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,102,086 $6,450,616 49% $13,979,043 $6,494,245 46% $13,979,043 $13,988,543 $9,500 Water Contracts 2,108,956 1,098,136 52% 2,192,970 1,045,947 48% 2,192,970 2,278,570 85,600 Interest and Other 45,500 19,419 43% 25,500 163,526 641% 25,500 296,500 271,000 $15,256,542 $7,568,171 $16,197,513 $7,703,718 $16,197,513 $16,563,613 $366,100 EXPENSES Departmental O&M $10,857,787 $4,722,865 43% $11,897,363 $5,504,426 46% $11,897,363 $11,794,763 $102,600 Non-Departmental O&M 265,564 81,773 31% 249,636 99,123 40% 249,636 249,636 - Capital Outlay/Purchases 107,000 - 0% 47,000 - 0% 47,000 52,000 (5,000) Transfers to Capital 1,800,000 900,000 50% 2,000,000 1,000,000 50% 2,000,000 2,000,000 - Debt Service 3,506,937 1,761,702 50% 3,404,650 1,799,406 53% 3,404,650 3,454,650 (50,000) $16,537,288 $7,466,340 $17,598,649 $8,402,955 $17,598,649 $17,551,049 $47,600 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: 42% Financial Policy targeted debt coverage ratio minimum: 1.20 Ending debt coverage ratio: 1.34 (a) Note (a) Calculation of debt coverage includes $105,000 of capitalizable costs for internal labor charges applicable to time spent on capital project activities. Water Operating 2/20/2023 FINANCE COMMITTEE AGENDA ITEM #: 6 February 28, 2023 Finance Committee City Council City of Lynchburg Lynchburg, Virginia Re: December 31, 2022 Quarterly Report - General Fund Please find attached the Financial Summary for the City’s General Fund (Fund) for the period ending December 31, 2022. 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 2023 has been billed, and revenue (less tax relief) of $29,952,946 has been collected. The amount collected includes payments made for the entire year. Economic Development tax incentive payments totaling $35,821 have been paid during the fiscal year. • Personal Property Taxes: Personal Property tax revenue collected through the second quarter of FY 2023 is $11,527,375, which is 55.9% of the fiscal year budget . This amount is $561,808 more than the amount collected through the second quarter of FY 2022. 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,184 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 2023 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 2023 (15%), and May 2023 (5%). • Consumer Utility Tax - Electric: Consumer Utility Tax – Electric revenue of $ 1,478,663 has been received through collections for 5 months, which is 42.2% of the fiscal year budget . Staff is monitoring this revenue and providing the Finance Committee with monthly updates. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee Lynchburg City Council February 28, 2023 Page 2 • Communication Sales and Use Taxes: Communication Sales and Use tax revenue of $793,105 has been received, which is 37.8% of the fiscal year budget. • Local Sales Tax: Sales tax revenue of $7,225,075 has been received through collections for 4 months, which is 36.1% of the fiscal year budget. Economic Development tax incentives totaling $117,975 have been paid. • Business License Business License revenue collected through the second quarter of FY 2023 is $148,044. 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,404 have been paid during the fiscal year. • Meals Tax Meals tax revenue of $7,904,285 has been received through collections for 5 months, which is 44.7% of the fiscal year budget. Economic Development tax incentives totaling $345,420 have been paid. • Lodging Tax Lodging tax revenue of $1,531,563 has been received through collections for 5 months, which is 51.1% of the fiscal year budget. Economic Development tax incentives totaling $398,618 have been paid. • Permit, Fees, and Licenses: Permit, Fees, and Licenses revenue of $ 563,365 has been received, which is 48.2% of the fiscal year budget. • Fines and Forfeitures: Fines and Forfeitures revenue of $80,390 has been received, which is 32.2 % 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. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee Lynchburg City Council February 28, 2023 Page 3 • Interest on Investments: Investment income of $1,318,928 has been received, which is 341.9% of the fiscal year budget. This increase is because i nvestment interest income and ARPA interest income were not budgeted for FY 2023 due to the prior year rates being so low, and the uncertainty of any income for the current fiscal year. • Charges for Services Charges for Services revenue of $6,304,118 has been received, which is 51.7% of the fiscal year budget. DEDICATED REVENUES Intergovernmental Revenues (consisting of Constitutional Officers, Health and Human Services, and State & Federal subsidies) of $19,478,631 have been received, which is 48.5% of the fiscal year budget. The timing of submitting and receiving reimbursements for constitutional offices impacts these revenues. EXPENDITURES • Operating Expenditures: Expenditures of $116,331,313 have been spent through the second quarter of FY 2023, which is 51.2% of the fiscal year budget. • Debt Service Debt Service expenditures are following the FY 2023 debt schedule. FINANCE COMMITTEE AGENDA ITEM #: 6 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 FINANCE COMMITTEE AGENDA ITEM #: 6 Fiscal Year Fiscal Calendar 2023 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/22 Remaining Budget w/o Encumbrances Percentage of Amended Budget Actual Amount 12/31/21 100 Taxes 02110.0100 - Current Real Property Tax 67,547,945 - 67,547,945 32,116,462 35,431,483 47.5% 35,302,450 02110.0105 - Tax Relief For Elderly (610,000) - (610,000) (584,786) (25,214) 95.9% (547,632) 02110.0110 - Tax Relief-Rehabilitation Real Property (1,452,715) - (1,452,715) (1,578,730) 126,015 108.7% (1,395,879) 02110.0200 - Delinquent Real Property Tax 700,000 - 700,000 565,433 134,567 80.8% 406,439 02110.0900 - Real Estate Tax- Economic Development Incentive (35,821) - (35,821) (35,821) 0 100.0% (33,460) 02120.0100 - Current PSC Tax 2,652,682 - 2,652,682 2,769,467 (116,785) 104.4% 2,652,682 02130.0101 - Current Personal Property Tax PCI 20,612,500 - 20,612,500 11,527,375 9,085,125 55.9% 10,965,567 02130.0201 - Delinquent Personal Property Tax PCI 1,300,000 - 1,300,000 193,326 1,106,674 14.9% 180,532 02130.0205 - Recovery-C/O Personal Property Tax - - - - - 0.0% 2,775 02130.0900 - Personal Property Tax- Economic Development Incentive (20,917) - (20,917) (31,184) 10,267 149.1% (19,917) 02170.0100 - Penalty-PSC Tax - - - 6,855 (6,855) 0.0% 3,858 02170.0105 - Penalty-Delinquent Tax 700,000 - 700,000 371,058 328,942 53.0% 303,716 02170.0200 - Interest-PSC Tax - - - - - 0.0% 342 02170.0205 - Interest-Delinquent Tax 300,000 - 300,000 183,762 116,238 61.3% 131,940 02510.0000 - Local Sales And Use Tax 20,000,000 - 20,000,000 7,225,075 12,774,925 36.1% 6,592,346 02510.0900 - Local Sales & Use Tax- Economic Development Incentive (87,592) - (87,592) (117,975) 30,383 134.7% (61,957) 02515.0100 - Consumer Utility Tax-Electric 3,500,000 - 3,500,000 1,478,663 2,021,337 42.2% 1,534,407 02515.0105 - Consumer Utility Tax-Gas 647,354 - 647,354 157,929 489,425 24.4% 152,502 02515.0120 - Right of Way Fees 225,000 - 225,000 125,330 99,670 55.7% 178,709 02515.0900 - Pen & Int - Consumer Utility Tax, None - - - 1 (1) 0.0% - 02517.0000 - Communication Sales & Use Tax 2,100,000 - 2,100,000 793,105 1,306,895 37.8% 826,728 02520.0000 - Business License Tax 9,016,000 - 9,016,000 148,044 8,867,956 1.6% 57,906 02520.0010 - Consumption Tax-Electric 320,779 - 320,779 120,889 199,890 37.7% 125,813 02520.0015 - Consumption Tax-Gas 30,819 - 30,819 8,058 22,761 26.1% 5,826 02520.0030 - Pen & Int-Business License 96,072 - 96,072 61,268 34,804 63.8% 22,128 02520.0900 - Business License Tax- Economic Development Incentive (26,726) - (26,726) (33,404) 6,678 125.0% (19,054) 02530.0001 - Motor Vehicle Licenses PCI 1,550,000 - 1,550,000 175,882 1,374,118 11.3% 185,080 02530.0201 - Delinquent Motor Vehicle License 190,000 - 190,000 25,282 164,718 13.3% 23,574 02535.0000 - Bank Stock Tax 750,000 - 750,000 - 750,000 0.0% 23,173 02540.0100 - Recordation Tax-City 675,000 - 675,000 394,776 280,224 58.5% 365,755 02540.0200 - Probate Tax 21,027 - 21,027 13,974 7,053 66.5% 6,754 02545.0000 - Tobacco Tax 800,000 - 800,000 372,877 427,123 46.6% 418,170 02550.0000 - Amusement Tax 720,000 - 720,000 339,911 380,089 47.2% 270,130 02550.0005 - Pen & Int - Amusement Tax - - - 4,607 (4,607) 0.0% 338 02555.0000 - Lodging Tax 3,000,000 - 3,000,000 1,531,563 1,468,437 51.1% 1,351,068 02555.0005 - Pen & Int - Lodging Tax - - - 1,240 (1,240) 0.0% 493 02555.0900 - Lodging Tax- Economic Development Incentive (314,148) - (314,148) (398,618) 84,470 126.9% (240,469) 02560.0000 - Meals Tax 17,700,000 - 17,700,000 7,904,285 9,795,715 44.7% 7,335,302 02560.0005 - Pen & Int - Meals Tax 49,793 - 49,793 25,982 23,811 52.2% 32,544 02560.0900 - Meals Tax- Economic Development Incentive (260,765) - (260,765) (345,420) 84,655 132.5% (169,995) 100 Taxes Total 152,396,287 - 152,396,287 65,516,540 86,879,747 43.0% 66,970,683 110 Permits, Fees, & Licenses 03005.0000 - Animal Licenses 7,000 - 7,000 2,742 4,258 39.2% 3,566 03010.0200 - Permit Parking Fees 200,000 - 200,000 109,703 90,297 54.9% 96,134 03010.0205 - Permit Parking Fees- Lease Agreement, None 90,000 - 90,000 26,135 63,865 29.0% 32,864 03010.0400 - Land Disturbing Fees 20,000 - 20,000 8,337 11,664 41.7% 8,862 03010.0600 - Transfer Fees 2,000 - 2,000 1,281 719 64.1% 1,406 03010.0700 - Zoning Appeal Fees-Inspc 1,000 - 1,000 475 525 47.5% 275 03010.0702 - Zoning Certification Letter 3,500 - 3,500 1,500 2,000 42.9% 2,600 03010.0705 - Legal Notice Advertising 10,000 - 10,000 5,546 4,454 55.5% 4,251 03010.0710 - Site Plan Reviews 15,000 - 15,000 8,320 6,680 55.5% 7,014 03010.0715 - Conditional Use Permits 4,000 - 4,000 1,251 2,749 31.3% 1,208 03010.0720 - Re-zoning Fees 8,700 - 8,700 5,034 3,666 57.9% 2,466 03010.0800 - Subdivision Plat Review 10,000 - 10,000 8,518 1,482 85.2% 3,780 03010.0900 - Building Insp Permit Fee 500,000 - 500,000 223,874 276,126 44.8% 318,493 03010.0901 - Elevator Inspect Admin Fee 21,000 - 21,000 8,741 12,259 41.6% 9,014 03010.0902 - Elevator Inspect Admin Fee Pen & Int - - - 178 (178) 0.0% 251 03010.0920 - Sign Inspect Permit Fee 6,000 - 6,000 3,225 2,775 53.8% 2,375 03010.0925 - Demolition Fees 5,000 - 5,000 4,145 855 82.9% 2,121 03010.0927 - Building Plan Review 44,000 - 44,000 18,547 25,453 42.2% 25,629 03010.0928 - Vacant Building Registration Fee 30,000 - 30,000 27,659 2,341 92.2% 18,176 03010.0929 - Pen & Int-Vacant Building Registration Fee - - - 2,396 (2,396) 0.0% 1,168 03010.0930 - Certificate of Occupancy for Existing Building - - - 1,350 (1,350) 0.0% 1,950 03010.0931 - Temporary Certificate of Occupancy, None - - - 5,850 (5,850) 0.0% 5,100 03010.0932 - Working Without a Building Permit - - - - - 0.0% 500 03010.0933 - Short Term Rental Fee, None 5,000 - 5,000 10,050 (5,050) 201.0% 17,964 03010.0934 - Vacant Property Registration- Civil Penalties, None 20,000 - 20,000 25,351 (5,351) 126.8% 6,834 03010.0935 - Short Term Rental Program- Civil Penalty, None - - - 5,000 (5,000) 0.0% - 03010.1000 - False Alarm Service Assessment 110,000 - 110,000 23,780 86,220 21.6% 23,194 03010.1100 - Concealed Weapon Permit 30,000 - 30,000 15,727 14,273 52.4% 13,699 03010.2005 - Taxicab Application Fees 3,000 - 3,000 350 2,650 11.7% 750 03010.2010 - Precious Metal Premits 1,600 - 1,600 400 1,200 25.0% - 03010.2011 - Rental Reinspect/FollowUp - - - 450 (450) 0.0% 50 03010.2012 - Rental Intial Inspection - - - 900 (900) 0.0% 350 03010.2013 - Annual/Periodic Inspect Fee 22,000 - 22,000 700 21,300 3.2% 1,000 03010.2014 - Rental Intial Inspect-No Show - - - 800 (800) 0.0% - 03010.2020 - Mobile Vendor License Fee - - - 760 (760) 0.0% - 03010.2027 - Right of Way Permit Fees, None - - - - - 0.0% - 03010.2028 - Dumpster Permit Fee , None - - - 50 (50) 0.0% 230 03010.2029 - Dumpster Permit Fee- 30 Day Extension, None - - - - - 0.0% 200 03010.2050 - Misc Permit Fee & License - - - 4,241 (4,241) 0.0% 5,097 110 Permits, Fees, & Licenses Total 1,168,800 - 1,168,800 563,365 605,435 48.2% 618,570 120 Fines & Forfeitures 03510.0100 - Court Fines And Forfeitures, None 187,500 - 187,500 26,090 161,410 13.9% 79,202 03510.0105 - Criminal Court Fees 2,500 - 2,500 946 1,554 37.8% 953 03510.0200 - Parking Fines 60,000 - 60,000 53,354 6,646 88.9% 25,325 FINANCE COMMITTEE AGENDA ITEM #: 6 Revenues Adopted Budget Budget Amendment Amended Budget Actual Amount 12/31/22 Remaining Budget w/o Encumbrances Percentage of Amended Budget Actual Amount 12/31/21 120 Fines & Forfeitures Total 250,000 - 250,000 80,390 169,610 32.2% 105,480 130 Use of Money & Property 04010.0100 - Interest on Investment - - - 526,158 (526,158) 0.0% 125,683 04010.0101 - Interest-City Capital - - - 104,200 (104,200) 0.0% 54,445 04010.0123 - Interest-Health Ins Resrv - - - 38,819 (38,819) 0.0% 25,975 04010.0124 - Interest-OPEB - - - 13,160 (13,160) 0.0% 2,414 04010.0131 - Interest Income- ARPA Funds Invested at LGIP, None - - - 447,140 (447,140) 0.0% - 04010.0156 - Interst-MktValueGain/Loss - - - (7,950) 7,950 0.0% (318,867) 04010.0157 - Interest-SNAP Income - - - 7,997 (7,997) 0.0% 3,952 04020.0105 - Gen Govt Property Rental 75,000 - 75,000 63,081 11,919 84.1% 35,644 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 41,400 - 41,400 6,900 34,500 16.7% 41,400 04020.0200 - Culture & Rec. Prop Rent 15,070 - 15,070 7,535 7,535 50.0% 7,535 04020.0201 - Prop Rental-Stadium 16,000 - 16,000 8,614 7,386 53.8% 8,060 04020.0202 - Prop Rental-Market/Park. 100,000 - 100,000 52,758 47,242 52.8% 57,828 04020.0205 - Market Rent- Pen & Int 1,500 - 1,500 517 983 34.5% 758 04020.0207 - Rental of Museum Facilities, None 500 - 500 - 500 0.0% - 130 Use of Money & Property Total 385,720 - 385,720 1,318,928 (933,208) 341.9% 94,826 140 Charges for Services 04510.0900 - Collection & Tax Lien Fees 35,000 - 35,000 38,511 (3,511) 110.0% 17,178 04510.0901 - DMV Admin Fee 278,000 - 278,000 159,817 118,183 57.5% 145,687 04510.0915 - Processng Fee - Payroll deduction 4,500 - 4,500 2,515 1,985 55.9% 1,990 04510.0916 - Indirect Cost&Svc DetHome 272,270 - 272,270 136,135 136,135 50.0% 137,468 04510.0918 - Indirect Cost&Srvc Water 1,130,803 - 1,130,803 565,402 565,401 50.0% 518,548 04510.0919 - Indirect Cost&Srvc Sewer 278,673 - 278,673 139,337 139,337 50.0% 135,045 04510.0920 - Indirect Cost&Srvc WWTP 595,108 - 595,108 297,554 297,554 50.0% 292,780 04510.0921 - Indirect Cost&Srvc Airprt 184,104 - 184,104 92,052 92,052 50.0% 90,539 04510.0922 - Indirect Cost&Svc Strmwtr 304,138 - 304,138 152,069 152,069 50.0% 160,791 04515.0101 - Document Reprod Costs 7,000 - 7,000 3,837 3,163 54.8% 4,286 04515.0200 - Court Room Sheriff Fee, None 63,000 - 63,000 33,087 29,913 52.5% 31,518 04515.0300 - Fees For Court Officers 7,000 - 7,000 7,244 (244) 103.5% 7,244 04515.0301 - Legal Service Charges 40,000 - 40,000 - 40,000 0.0% - 04515.0303 - Probation Supervisor Fee 10,000 - 10,000 6,926 3,074 69.3% 3,266 04515.0304 - Jail Fee, None 2,000 - 2,000 1,082 918 54.1% 1,043 04515.0305 - E-Summons Fee, None 12,000 - 12,000 7,632 4,368 63.6% 7,274 04515.0400 - Commonwealth Atty.Fees 5,000 - 5,000 2,694 2,306 53.9% 3,331 04515.0401 - CA Coll Fees- Gen Dist Ct 55,000 - 55,000 12,272 42,728 22.3% 16,559 04515.0402 - CA Coll Fees- J&D Court 10,050 - 10,050 2,274 7,776 22.6% 2,591 04515.0403 - CA Coll Fees- Circuit Crt 62,600 - 62,600 26,911 35,689 43.0% 25,371 04515.0404 - CA Coll Fees- FOIA Requests, None 2,000 - 2,000 - 2,000 0.0% 2,009 04520.0300 - Fire Prevention Fees 2,000 - 2,000 1,450 550 72.5% 1,700 04520.0301 - Ambulance Service Fees 3,000,000 - 3,000,000 1,511,218 1,488,782 50.4% 1,315,518 04520.0304 - Delinq Ambulance>120 Days 175,000 - 175,000 61,665 113,335 35.2% 57,326 04520.0305 - LFD Off Duty, None - - - 56,417 (56,417) 0.0% - 04520.0306 - LFD Off Duty - Penalty and Interest, None - - - 3,709 (3,709) 0.0% - 04520.0307 - Lynchburg Fire Dept Charges, None - - - 1,038 (1,038) 0.0% - 04520.0308 - Lynchburg Fire Dept Charges- Pen and Int, None - - - 25 (25) 0.0% - 04520.0901 - PIER Contract Payments 26,500 - 26,500 26,500 - 100.0% 26,500 04520.0903 - Police-Schools Resource Officer (SRO) Prog 140,000 - 140,000 63,672 76,328 45.5% 63,615 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,458 742 66.3% 1,090 04520.0906 - Range Use Fee 13,800 - 13,800 13,600 200 98.6% 13,600 04520.0908 - DUI Fees, None - - - 2,552 (2,552) 0.0% 2,239 04520.0909 - LPD Off Duty 1,100,000 - 1,100,000 388,338 711,663 35.3% 425,091 04525.0106 - Downtown Parking Fees 30,000 - 30,000 16,066 13,934 53.6% 10,208 04525.0107 - PW Admin Stormwater Charges 119,527 - 119,527 112,781 6,746 94.4% 74,796 04525.0108 - PW Eng Stormwater Charges 11,957 - 11,957 11,795 162 98.6% 3,960 04525.0109 - PW Streets Stormwater Charges 150,090 - 150,090 131,157 18,933 87.4% 100,812 04525.0206 - Residential Disposal-Decals - - - - - 0.0% - 04525.0218 - Trash Bag Srvc-Waste Zero 65,000 - 65,000 46,956 18,044 72.2% 75,956 04525.0219 - Landlord Set Out Program , None 3,000 - 3,000 7,116 (4,116) 237.2% 2,650 04525.0220 - Refuse Disposal Fee, None 2,340,000 - 2,340,000 1,188,889 1,151,111 50.8% 1,195,856 04525.0221 - Penalty- Refuse Disposal Fee, None - - - 10,905 (10,905) 0.0% 10,837 04525.0300 - Bldg Maint Charge-Other - - - 5,071 (5,071) 0.0% 12,157 04530.0409 - Human Services Court Order Fees - - - 1,642 (1,642) 0.0% 271 04530.0410 - Lynchburg Youth Group Home Charges 450,000 - 450,000 297,400 152,600 66.1% 155,875 04530.0413 - Local Reimb- Other Localities, None - - - - - 0.0% 401 04535.0100 - Swimming Pool Fees 30,000 - 30,000 16,066 13,934 53.6% 21,790 04535.0150 - Recreation Program Fees 450,000 - 450,000 271,840 178,160 60.4% 257,410 04535.0151 - Recreation Program- Scholarship Fees , None 5,300 - 5,300 265 5,035 5.0% 3,872 04535.0200 - Point of Honor Admission Fees 2,500 - 2,500 - 2,500 0.0% - 04535.0300 - Library Fines & Fees 15,000 - 15,000 13,413 1,587 89.4% 12,648 04535.0301 - Law Library Fees 30,000 - 30,000 14,380 15,620 47.9% 11,049 04535.0303 - Lost/Damaged Library Prop 2,500 - 2,500 2,242 258 89.7% 1,602 04535.0304 - Delinq Library Fines & Fees 2,000 - 2,000 10 1,990 0.5% 829 04535.0305 - Delinq Library Lost/Damaged 5,000 - 5,000 2,109 2,891 42.2% 1,546 04535.0306 - Delinq Library Pen & Int 2,000 - 2,000 1,248 752 62.4% 1,134 04540.0105 - Comm Develop Stormwater Charges 582,931 - 582,931 291,466 291,465 50.0% 290,251 04599.0002 - Secure Vacant Stru Reimb - - - 540 (540) 0.0% 10 04599.0004 - Neighborhood Services, None 21,000 - 21,000 16,290 4,710 77.6% 11,067 04599.0009 - Penalty and Interest- Neighborhood Services Receivables, None - - - 480 (480) 0.0% 182 140 Charges for Services Total 12,185,551 - 12,185,551 6,304,118 5,881,433 51.7% 5,793,360 150 Miscellaneous Revenue 05030.0105 - Suspense Revenue/Exp Ref - - - - - 0.0% 7,861 05050.0105 - Pmt In Lieu Tax-WestCntbr 53,799 - 53,799 - 53,799 0.0% - 05050.0110 - Pymt In Lieu of Tax-LRHA 25,000 - 25,000 - 25,000 0.0% - 05050.0228 - Recreation Program- Donations, None - - - 495 (495) 0.0% 4,800 05050.0230 - Friends of Lynchburg Library 17,981 - 17,981 3,174 14,807 17.7% 3,174 05050.0232 - Digg's Trust Rec-Pt Honor 37,000 - 37,000 18,500 18,500 50.0% 18,500 05050.0400 - Sale-Salvage/Surplus Prop - - - 295 (295) 0.0% 4,822 05050.0415 - Proceeds frm PropRoom.com - - - 271 (271) 0.0% - 05050.2001 - Cash Overage And Shortage - - - (2,397) 2,397 0.0% (2,048) 05050.2011 - Reimb.POH Carriage House 27,000 - 27,000 16,203 10,797 60.0% 13,875 FINANCE COMMITTEE AGENDA ITEM #: 6 Revenues Adopted Budget Budget Amendment Amended Budget Actual Amount 12/31/22 Remaining Budget w/o Encumbrances Percentage of Amended Budget Actual Amount 12/31/21 05050.2013 - Photo Reprod And Royalty 100 - 100 - 100 0.0% 300 05050.2016 - Dedicated Misc Rev HumSvc - - - - - 0.0% 40 05050.2025 - Credit Card Rebate 95,000 - 95,000 - 95,000 0.0% - 05050.2028 - WardsCrossingWestSvcFee 143,277 - 143,277 - 143,277 0.0% - 05050.2034 - P&R Spec Event Sponsorship, None 15,000 - 15,000 9,200 5,800 61.3% 9,075 05050.2046 - Visitor Ctr Merchandise - - - - - 0.0% 125 05050.2049 - Residential Trash Violation, None 6,000 - 6,000 13,141 (7,141) 219.0% 6,044 05050.2052 - Parking Lease Agreement - - - - - 0.0% - 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,095 (2,095) 0.0% 1,646 05050.2059 - Court Restitution, None - - - 4,451 (4,451) 0.0% 868 05050.2060 - Community Market Retail Sales, None 500 - 500 - 500 0.0% 291 05050.2066 - P&R Special Events- GF Support Revenue, None - - - 25,000 (25,000) 0.0% - 05050.2090 - Miscellaneous Revenue 51,000 - 51,000 224,884 (173,884) 440.9% 24,638 150 Miscellaneous Revenue Total 481,657 - 481,657 325,312 156,345 67.5% 104,008 300 State Non-Categorical Aid 06100.0300 - Rolling Stock Taxes 88,000 - 88,000 88,731 (731) 100.8% 88,584 06100.0400 - Mobile Home Titling Taxes 1,000 - 1,000 1,467 (467) 146.7% 1,509 06100.0600 - Deeds Of Conveyance 150,000 - 150,000 134,217 15,783 89.5% 103,291 06100.0800 - Recordation Taxes-State - - - - - 0.0% - 06100.0900 - Auto Rental Tax-DMV 350,000 - 350,000 290,268 59,732 82.9% 246,368 06100.0905 - Peer to Peer Vehicle Sharing Tax, None - - - 3,054 (3,054) 0.0% 821 06100.1108 - Personal Prop Tax Relief 5,543,584 - 5,543,584 4,434,867 1,108,717 80.0% 4,434,867 06100.8001 - Games of Skill Tax, None - - - - - 0.0% 42,624 300 State Non-Categorical Aid Total 6,132,584 - 6,132,584 4,952,605 1,179,979 80.8% 4,918,063 310 State Shared Exp (Cat.) 06510.0200 - Commissioner of Revenue 201,758 7,761 209,519 80,198 129,321 38.3% 83,270 06510.0300 - Treasurer 120,023 5,513 125,536 50,602 74,934 40.3% 38,652 06510.1000 - Registrar/Electoral Board 99,914 2,053 101,967 - 101,967 0.0% - 06515.0100 - Clerk of Cir Crt-Fringes 646,468 48,144 694,612 279,844 414,768 40.3% 259,081 06515.0200 - Sheriff 1,162,719 87,313 1,250,032 502,593 747,439 40.2% 381,191 06515.0400 - Commonwealth Attorney 1,131,821 32,362 1,164,183 467,017 697,166 40.1% 363,305 310 State Shared Exp (Cat.) Total 3,362,703 183,146 3,545,849 1,380,254 2,165,595 38.9% 1,125,499 320 State Categorical Aid 06820.0200 - Juvenile Correct-Block Gt 247,716 - 247,716 123,858 123,858 50.0% 123,858 06820.0201 - Wireless E911 380,000 - 380,000 190,211 189,789 50.1% 201,839 06820.0203 - HB 599 Law Enforc.Asst 3,250,000 333,617 3,583,617 1,791,808 1,791,809 50.0% 1,629,872 06825.0100 - Street And Highway Maint. 8,842,661 693,030 9,535,691 4,771,217 4,764,474 50.0% 4,528,055 06830.0413 - SS State Adm Sub 0901 1,849,884 1,250 1,851,134 967,898 883,236 52.3% 900,094 06830.0414 - SS State Prog Sub 0902 4,912,198 - 4,912,198 1,494,236 3,417,962 30.4% 1,126,980 06835.0102 - SNAP Program Reimb 16,000 - 16,000 19,365 (3,365) 121.0% 19,124 06835.0300 - Finan Asst-Public Library 181,175 23,274 204,449 102,225 102,225 50.0% 90,088 320 State Categorical Aid Total 19,679,634 1,051,171 20,730,805 9,460,818 11,269,987 45.6% 8,619,909 330 State Aid in Suspense 05030.0100 - Suspense Rev-Va EDI Pmts - - - - - 0.0% - 330 State Aid in Suspense Total - - - - - 0.0% - 500 Fed Direct Non-Categorical Aid 07530.0010 - American Rescue Plan Act (ARPA) Funding, None 680,000 32,648,529 33,328,529 13,767,907 19,560,622 41.3% - 500 Fed Direct Non-Categorical Aid Total 680,000 32,648,529 33,328,529 13,767,907 19,560,622 41.3% - 520 Fed Cat Aid- Pass Thru 07825.0300 - B&G Chrgs Commerce St Bld - - - - - 0.0% - 07830.0420 - Fed Pass Thru:Cost AIIDMG 573,000 - 573,000 - 573,000 0.0% - 07830.0421 - SS Fed Adm Sub 0901 5,426,133 1,750 5,427,883 2,238,213 3,189,670 41.2% 1,822,012 07830.0422 - SS Fed Prog Sub 0902 3,672,129 - 3,672,129 1,387,165 2,284,964 37.8% 1,132,371 07830.0428 - Finance-Social Srvc-Fed - - - 1,003 (1,003) 0.0% - 07830.0430 - USDA Funding - Group Home, None 16,000 - 16,000 13,144 2,856 82.2% 7,698 07875.0003 - Human Service Lease 62,000 - 62,000 26,198 35,802 42.3% 34,994 07875.0021 - FINI Double-Dollars 14,000 - 14,000 19,231 (5,231) 137.4% 17,517 07875.0024 - CARES Act Funding for 2020 Presidential Election, None - - - - - 0.0% - 520 Fed Cat Aid- Pass Thru Total 9,763,262 1,750 9,765,012 3,684,954 6,080,058 37.7% 3,014,592 710 Operating Transfers In 09301.0003 - TrfFrmCtyCp-Capital Proj - 25,000 25,000 - 25,000 0.0% - 710 Operating Transfers In Total - 25,000 25,000 - 25,000 0.0% - Grand Total 206,486,198 33,909,596 240,395,794 107,355,190 133,040,604 44.7% 91,364,992 FINANCE COMMITTEE AGENDA ITEM #: 6 Fiscal Year Fiscal Calendar 2023 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/22 Remaining Budget w/ Encumbrances Percentage Used w/ Encumbrances Actual Amount 12/31/21 2022 Communications/Public Engagement 0021 Public Information 556,309 154,414 710,723 288,569 342,152 51.9% 268,735 0022 Customer Service Center 202,790 16,280 219,070 96,804 122,266 44.2% 79,569 0029 Local Government Channel 387,228 11,014 398,242 78,299 319,943 19.7% 85,340 2022 Communications/Public Engagement Total 1,146,327 181,708 1,328,035 463,672 784,362 40.9% 433,644 2023 Council / Manager 0028 Council / Manager 1,280,840 94,320 1,375,160 647,656 707,504 48.6% 534,610 0033 Parking Division - - - - - 0.0% - 2023 Council / Manager Total 1,280,840 94,320 1,375,160 647,656 707,504 48.6% 534,610 2030 City Attorney 0050 City Attorney 954,903 37,634 992,537 446,133 545,927 45.0% 363,891 0051 Risk Management 1,318,278 - 1,318,278 1,318,278 - 100.0% 758,581 2030 City Attorney Total 2,273,181 37,634 2,310,815 1,764,411 545,927 76.4% 1,122,472 2035 State Treasurer 0060 State Treasurer 186,917 7,413 194,330 91,004 103,326 46.8% 84,137 2035 State Treasurer Total 186,917 7,413 194,330 91,004 103,326 46.8% 84,137 2040 Commissioner Of Revenue 0070 Com Rev-State/Loc Budget 891,124 57,000 948,124 391,321 529,125 44.2% 384,399 2040 Commissioner Of Revenue Total 891,124 57,000 948,124 391,321 529,125 44.2% 384,399 2045 City Assessor 0080 City Assessor 799,837 23,855 823,692 294,510 525,659 36.2% 376,408 2045 City Assessor Total 799,837 23,855 823,692 294,510 525,659 36.2% 376,408 2050 Finance 0090 Office of Management & Budget 756,215 73,231 829,446 415,215 408,284 50.8% 370,935 0093 Billings And Collections 1,759,721 186,904 1,946,625 711,713 1,053,193 45.9% 679,466 0094 Procurement 505,047 29,493 534,540 244,420 286,099 46.5% 192,450 0095 Accounting 1,139,167 131,199 1,270,366 546,769 607,300 52.2% 530,338 2050 Finance Total 4,160,150 420,827 4,580,977 1,918,117 2,354,875 48.6% 1,773,189 2055 Human Resources 0110 Human Resources 1,020,159 55,179 1,075,338 437,910 636,142 40.8% 369,214 0111 Occupational Health Svs 216,440 - 216,440 41,142 175,298 19.0% 92,767 2055 Human Resources Total 1,236,599 55,179 1,291,778 479,052 811,440 37.2% 461,981 2057 Information Technology 0115 Application Services 1,382,358 58,132 1,440,490 620,636 819,854 43.1% 580,139 0116 Network Services 1,769,996 87,219 1,857,215 918,518 938,697 49.5% 822,178 0117 I T Administration 471,325 24,846 496,171 220,846 261,388 47.3% 137,433 0125 GIS 377,765 14,481 392,246 211,529 180,717 53.9% 187,298 2057 Information Technology Total 4,001,444 184,678 4,186,122 1,971,529 2,200,656 47.4% 1,727,048 2065 Registrar 0150 Registrar 322,279 15,889 338,168 148,133 190,002 43.8% 132,407 0151 Electoral Board 204,118 1,133 205,251 170,911 34,340 83.3% 74,520 2065 Registrar Total 526,397 17,022 543,419 319,044 224,342 58.7% 206,927 2090 Education 0200 Lcl Sch Oper Contribution 40,794,923 - 40,794,923 21,675,000 19,119,923 53.1% 16,450,000 2090 Education Total 40,794,923 - 40,794,923 21,675,000 19,119,923 53.1% 16,450,000 2105 Circuit Court-Judge 0300 Circuit Court-Judge 165,735 7,240 172,975 79,098 90,856 47.5% 75,110 2105 Circuit Court-Judge Total 165,735 7,240 172,975 79,098 90,856 47.5% 75,110 2110 General District Court 0310 General District Court 60,873 2,611 63,484 10,543 52,044 18.0% 23,198 2110 General District Court Total 60,873 2,611 63,484 10,543 52,044 18.0% 23,198 2115 Juvenile & Dr Dist Court 0320 Juvenile & Dr Dist Court 28,454 374 28,828 16,569 9,651 66.5% 14,229 2115 Juvenile & Dr Dist Court Total 28,454 374 28,828 16,569 9,651 66.5% 14,229 2120 24th Court Service Unit 0330 24th Court Service Unit 1,425 20 1,445 467 958 33.7% 395 2120 24th Court Service Unit Total 1,425 20 1,445 467 958 33.7% 395 2125 Commonwealth's Attorney 0340 Commonwealth Attorney 1,816,215 68,305 1,884,520 853,665 1,028,907 45.4% 807,841 0343 Com Aty Fines & Fees Coll 66,555 2,658 69,213 35,396 32,949 52.4% 31,712 2125 Commonwealth's Attorney Total 1,882,770 70,963 1,953,733 889,061 1,061,855 45.6% 839,553 2130 Magistrate's Office 0350 Magistrate's Office 6,954 47 7,001 655 6,338 9.5% 1,009 2130 Magistrate's Office Total 6,954 47 7,001 655 6,338 9.5% 1,009 2135 Circuit Court-Clerk FINANCE COMMITTEE AGENDA ITEM #: 6 Expenditures Adopted Budget Budget Amendment Amended Budget Actual Amount 12/31/22 Remaining Budget w/ Encumbrances Percentage Used w/ Encumbrances Actual Amount 12/31/21 0360 Circuit Court-Clerk 1,030,995 53,940 1,084,935 504,171 580,764 46.5% 452,236 2135 Circuit Court-Clerk Total 1,030,995 53,940 1,084,935 504,171 580,764 46.5% 452,236 2200 City Sheriff 0400 City Sheriff And Jail 2,490,159 135,983 2,626,142 1,229,864 1,396,278 46.8% 1,238,380 2200 City Sheriff Total 2,490,159 135,983 2,626,142 1,229,864 1,396,278 46.8% 1,238,380 2240 Police 0420 Police Operations 22,339,496 728,997 23,068,493 10,780,744 11,881,581 48.5% 8,491,587 0421 Animal Warden 359,276 7,325 366,601 176,361 190,240 48.1% 157,826 0429 Range Operations 13,800 9,441 23,241 6,889 15,442 33.6% 1,798 0430 Police Off Duty Employmnt 1,028,181 1,260 1,029,441 458,742 570,699 44.6% 400,513 2240 Police Total 23,740,753 747,023 24,487,776 11,422,736 12,657,962 48.3% 9,051,723 2245 Emergency Services 0422 Emergency Communications 3,510,969 142,952 3,653,921 1,555,268 2,036,329 44.3% 1,355,885 2245 Emergency Services Total 3,510,969 142,952 3,653,921 1,555,268 2,036,329 44.3% 1,355,885 2270 Fire 0444 Fire Operations And Ems 20,824,622 509,905 21,334,527 10,253,996 10,982,954 48.5% 8,415,707 0446 TRT- PIER Program 76,500 8,900 85,400 42,611 33,889 60.3% 40,021 2270 Fire Total 20,901,122 518,805 21,419,927 10,296,607 11,016,843 48.6% 8,455,729 2400 Public Works 0600 Public Works Administrat. 1,107,319 70,513 1,177,832 567,066 572,857 51.4% 487,761 0605 Engineering 4,392,418 471,856 4,864,274 2,110,606 2,390,968 50.8% 1,666,043 0632 Street Maintenance,II 4,042,584 1,539,469 5,582,053 1,642,058 3,113,222 44.2% 1,207,663 0635 Snow Removal 343,233 37,082 380,315 207,778 (44,092) 111.6% 37,690 0640 Refuse Collection 4,086,729 1,304,020 5,390,749 2,624,630 1,712,145 68.2% 1,846,419 0645 Parks/Grounds Maintenance 4,207,350 928,309 5,135,659 2,193,394 2,067,100 59.8% 1,711,035 0649 Baseball Stadium Maint 102,823 7,828 110,651 60,815 22,911 79.3% 52,506 0650 Building Maintenance 4,080,521 282,824 4,363,345 1,937,260 2,162,970 50.4% 1,589,182 0660 Human Services Maint. 59,250 4,889 64,139 22,122 22,763 64.5% 14,398 2400 Public Works Total 22,422,227 4,646,790 27,069,017 11,365,729 12,020,843 55.6% 8,612,698 2555 Health 0800 Health Operations 785,000 - 785,000 392,500 - 100.0% 392,500 2555 Health Total 785,000 - 785,000 392,500 - 100.0% 392,500 2561 Juvenile Services 0905 Juvenile Detention Home 863,000 - 863,000 250,781 612,219 29.1% 338,706 0906 Juvenile Services 1,833,220 347,861 2,181,081 1,027,185 1,140,414 47.7% 825,218 0915 Csa Service Providers 2,039,543 - 2,039,543 1,019,772 1,019,772 50.0% 1,018,857 2561 Juvenile Services Total 4,735,763 347,861 5,083,624 2,297,737 2,772,405 45.5% 2,182,781 2562 Social Services 0901 Social Services Admin. 10,147,424 554,919 10,702,343 5,071,464 5,611,115 47.6% 4,468,829 0902 Public Assistance 8,749,646 - 8,749,646 3,579,484 5,170,162 40.9% 3,760,417 2562 Social Services Total 18,897,070 554,919 19,451,989 8,650,948 10,781,276 44.6% 8,229,246 2563 Recreation Services 0116 Network Services 22,385 - 22,385 13,855 7,771 65.3% 11,463 1002 Parks/Rec/Market 427,313 21,793 449,106 218,665 223,081 50.3% 191,458 1010 Recreation, General Admin 709,819 60,533 770,352 362,873 375,353 51.3% 313,684 1011 Recreation Services 154,744 11,654 166,398 79,551 86,847 47.8% 70,713 1013 Recreation, Athletic 161,952 13,875 175,827 88,095 87,732 50.1% 71,872 1015 Recreation, Park Services 785,148 65,371 850,519 406,173 444,346 47.8% 383,969 1022 Recreation, Aquatics 141,070 16,234 157,304 86,545 70,759 55.0% 63,241 1023 Recreation, Naturalist 197,189 4,716 201,905 94,025 107,880 46.6% 107,879 1027 Recreation Programs 523,491 - 523,491 309,975 206,513 60.6% 247,115 1028 City-wide Centers 293,486 10,107 303,593 127,035 176,558 41.8% 136,101 1029 Neighborhood Centers 843,901 37,110 881,011 382,523 498,488 43.4% 354,247 2563 Recreation Services Total 4,260,498 241,393 4,501,891 2,169,316 2,285,327 49.2% 1,951,742 2610 Libraries 1100 Public Library 2,201,582 139,417 2,340,999 803,734 1,531,033 34.6% 712,302 1120 Law Library 10,000 - 10,000 5,648 4,352 56.5% 4,937 2610 Libraries Total 2,211,582 139,417 2,350,999 809,382 1,535,385 34.7% 717,239 2611 Museum System 1150 Museum 536,579 25,281 561,860 171,025 389,528 30.7% 216,558 2611 Museum System Total 536,579 25,281 561,860 171,025 389,528 30.7% 216,558 2715 Community Development 1200 Director-Comm Plan/Dev 328,882 38,299 367,181 174,124 188,608 48.6% 151,409 1201 Planning 664,762 69,105 733,867 255,152 475,565 35.2% 165,285 1202 Inspections 1,131,731 66,313 1,198,044 505,462 692,582 42.2% 435,302 1205 Zoning 397,663 14,565 412,228 185,450 226,778 45.0% 168,815 2715 Community Development Total 2,523,038 188,282 2,711,320 1,120,188 1,583,532 41.6% 920,811 2720 Office Of Economic Devel 1300 Economic Development 1,816,498 128,189 1,944,687 1,167,148 730,977 62.4% 830,209 2720 Office Of Economic Devel Total 1,816,498 128,189 1,944,687 1,167,148 730,977 62.4% 830,209 5000 Nondept Employee Benefits FINANCE COMMITTEE AGENDA ITEM #: 6 Expenditures Adopted Budget Budget Amendment Amended Budget Actual Amount 12/31/22 Remaining Budget w/ Encumbrances Percentage Used w/ Encumbrances Actual Amount 12/31/21 1430 Non-allocated Emp Benefit 4,838,021 - 4,838,021 1,695,107 3,142,914 35.0% 2,147,430 5000 Nondept Employee Benefits Total 4,838,021 - 4,838,021 1,695,107 3,142,914 35.0% 2,147,430 5050 Non-Departmental 1506 Water Oper Fund Payments 873,843 - 873,843 436,922 436,922 50.0% 443,943 1508 Stormwater Fee-City Bldgs 97,200 - 97,200 38,728 58,472 39.8% 44,417 1509 Stormwater Fee-School Bld 73,400 - 73,400 30,406 42,994 41.4% 34,999 1512 College Lake Dam Repairs - 108,995 108,995 989 (989) 100.9% 2,418 1513 Stormwater Detention Pond Repair - - - - - 0.0% - 1515 Alternative to CARES Funding - 337,353 337,353 199,703 (975) 100.3% 659,228 1516 COVID Vaccinations - - - - - 0.0% - 1517 Real Estate Credit 1,300,000 - 1,300,000 1,234,514 65,486 95.0% - 1566 Managed Vacancy Program (1,102,096) - (1,102,096) - (1,102,096) 0.0% - 1567 Years of Service Awards 15,000 - 15,000 7,500 7,500 50.0% 6,157 1568 Retirement Recognition 5,000 - 5,000 910 4,090 18.2% 2,352 1569 Take Your Kids to Work Dy 1,000 - 1,000 - 1,000 0.0% - 1570 Emp Appreciation Luncheon 3,000 7,000 10,000 877 9,123 8.8% 1,701 1573 Payment-Fleet Capital Chg 3,135,484 - 3,135,484 1,439,252 1,696,232 45.9% 1,505,694 1574 Health Management Program 15,000 2,005 17,005 7,344 9,661 43.2% (13,821) 1575 Employee Committee Funds 8,000 - 8,000 1,060 6,940 13.3% 4,406 1576 Line of Duty Act 312,000 - 312,000 189,528 122,472 60.7% 173,554 1578 Poverty Intiative - 45,369 45,369 2,932 42,437 6.5% 10,550 1579 Recruitment 50,000 1,900 51,900 24,734 27,166 47.7% 20,139 1580 International Festival 7,500 6,176 13,676 320 13,356 2.3% 392 1581 Workplace Safety & Wellness 60,000 - 60,000 22,189 37,811 37.0% 24,836 1637 City Cemetery Master Plan 166,858 - 166,858 110,126 - 100.0% 110,126 5050 Non-Departmental Total 5,021,189 508,797 5,529,986 3,748,032 1,477,604 73.3% 3,031,092 5060 Support Local/State Organ 1702 V.P.I. Extension Service 41,748 - 41,748 11,622 (12) 100.0% 9,519 1705 Lynchburg Humane Society 355,440 - 355,440 355,440 - 100.0% 405,440 1707 Cent Va Alli for Comm Liv 15,000 - 15,000 15,000 - 100.0% 15,000 1708 Horizon Behavioral Health 576,512 - 576,512 288,256 - 100.0% 287,256 1709 Cvcc Board & Related Oper 1,956 - 1,956 1,956 - 100.0% 1,955 1711 Cent Va Planning Dist Com 49,979 - 49,979 49,979 - 100.0% 47,258 1715 Greater Lynch. Transit Co 1,266,454 - 1,266,454 633,226 633,228 50.0% 633,226 1721 Blue Ridge Regional Jail 4,870,548 - 4,870,548 3,474,099 (1,038,825) 121.3% 3,482,079 1724 Legal Aid Society 13,160 - 13,160 13,160 - 100.0% 13,160 1739 Contrib- Amazement Square 369 - 369 - 369 0.0% - 1743 Central Va Reg Radio Brd 724,171 - 724,171 392,481 331,690 54.2% 400,125 1748 Elizabeth's Early Learn Center - - - - - 0.0% - 1750 Downtown Lynchburg Association 50,000 - 50,000 25,000 - 100.0% - 5060 Support Local/State Organ Total 7,965,337 - 7,965,337 5,260,219 (73,550) 100.9% 5,295,017 7450 Debt Service 5990 Principal Bonds/BANS/LOC 10,931,540 - 10,931,540 4,421,284 6,510,256 40.4% 4,720,290 5994 Interest Bonds/BANS/LOC 6,277,548 - 6,277,548 3,065,628 3,211,920 48.8% 3,243,437 5996 Debt Issuance Costs - - - 628 (628) 0.0% - 5997 Debt - Misc. Charges 3,550 - 3,550 988 2,562 27.8% 625 7450 Debt Service Total 17,212,638 - 17,212,638 7,488,527 9,724,111 43.5% 7,964,352 7570 Other Financing Uses 9710 Operating Transfers Out 13,261,286 33,349,192 46,610,478 21,463,625 25,146,853 46.0% 4,133,467 7570 Other Financing Uses Total 13,261,286 33,349,192 46,610,478 21,463,625 25,146,853 46.0% 4,133,467 Grand Total 217,604,674 42,889,717 260,494,391 123,819,840 128,334,223 50.7% 91,687,404 FINANCE COMMITTEE AGENDA ITEM #: 6 January 24, 2023 Finance Committee City Council City of Lynchburg Lynchburg, Virginia Re: September 30, 2022 Quarterly Report - General Fund Attached is the Financial Summary for the General Fund (Fund) for the fiscal period which ended September 30, 2022. 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, the first installment for FY 2023 has not been billed. Economic Development tax incentive payments totaling $35,821 have been paid. • Personal Property Taxes: Personal Property tax revenue collected is $3,001,903, which is $178,707 more than the amount collected in the first quarter of FY 2022. Economic Development tax incentives totaling $31,184 have been paid. 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. 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, which equates to $950 million for FY 2023. This action eliminates the 70% reimbursement. Lynchburg’s share is $5,543,584. During the first quarter of FY 2023, the State reimbursed the City $277,179 (5%), as scheduled. Future payments have been scheduled for November 2022 (75%), February 2023 (15%), and May 2023 (5%). • Consumer Utility Taxes - Electric: Consumer Utility Tax – Electric revenue of $649,708 has been collected, which is 18.6% of the fiscal year budget, based on collections for 2 months. Staff is monitoring this revenue and providing the Finance Committee with monthly updates. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee Lynchburg City Council January 24, 2023 Page 2 • Communication Sales and Use Taxes: Communication Sales and Use tax revenue of $202,092 has been collected, which is 9.6% of the fiscal year budget, and is slightly behind the FY 2022 first quarter collection amount by $8,229. • Local Sales Tax: Sales tax revenue of $1,752,857 has been collected, which is 8.8% of the fiscal year budget , based on collections for 1 month. Economic Development tax incentives totaling $117,975 have been paid. • Business License Business License revenue of $44,423 has been collected. The majority of the tax will be collected from March to May. Economic Development tax incentives totaling $33,404 have been paid. • Meals Tax Meals tax revenue of $3,058,984 has been collected, which is 17.3% of the fiscal year budget, based on collections for 2 months. Economic Development tax incentives totaling $345,420 have been paid. • Lodging Tax Lodging tax revenue of $604,180 has been collected, which is 20.1% of the fiscal year budget, based on collections for 2 months. Economic Development tax incentives totaling $398,618 have been paid. • Permit, Fees, and Licenses: Permit, Fees, and Licenses revenue of $317,436 has been collected, which is 27.2% of the fiscal year budget. • Fines and Forfeitures: Fines and Forfeitures revenue of $0 has been collected. The timing of receiving court fines and parking fines varies greatly throughout the year, and staff will continue to keep a close watch on this revenue to see if an adjustment in projected revenue is necessary. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee Lynchburg City Council January 24, 2023 Page 3 • Interest on Investments: Investment income of $325,798 has been earned, which is 84.5% of the fiscal year budget. • Charges for Services Charges for Services revenue of $2,853,710 has been collected, which is 23.4% of the fiscal year budget. DEDICATED REVENUES Intergovernmental Revenues (consisting of Constitutional Officers, Health and Human Services, and State & Federal subsidies) of $ 12,115,743 have been received, which is 16.5% of the fiscal year budget. T he timing of submitting and receiving reimbursements for constitutional offices impacts these revenues. EXPENDITURES • Operating Expenditures: The percentage of operating expenditures spent through the first quarter of FY 2023, 24.0%, is on target with budget projections. • Debt Service Debt Service expenditures are on pace with FY 2023 budget projections. FINANCE COMMITTEE AGENDA ITEM #: 6 Finance Committee Lynchburg City Council January 24, 2023 Page 4 SUMMARY This report represents three 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 Gregory Patrick, Deputy City Manager Rhonda Allbeck, Assistant Director of Financial Services FINANCE COMMITTEE AGENDA ITEM #: 6 Fiscal Year Fiscal Calendar 2023 Fiscal Quarter of Year Fiscal Q 1 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 9/30/22 Remaining Budget w/o Encumbrances Percentage of Amended Budget Actual Amount 9/30/21 100 Taxes 02110.0100 - Current Real Property Tax 67,547,945 - 67,547,945 5,839,690 61,708,255 8.6% 2,145,231 02110.0105 - Tax Relief For Elderly (610,000) - (610,000) (558,599) (51,401) 91.6% (512,546) 02110.0110 - Tax Relief-Rehabilitation Real Property (1,452,715) - (1,452,715) (1,578,730) 126,015 108.7% (1,395,879) 02110.0200 - Delinquent Real Property Tax 700,000 - 700,000 320,361 379,639 45.8% 230,990 02110.0900 - Real Estate Tax- Economic Development Incentive (35,821) - (35,821) (35,821) 0 100.0% (33,460) 02120.0100 - Current PSC Tax 2,652,682 - 2,652,682 - 2,652,682 0.0% - 02130.0101 - Current Personal Property Tax PCI 20,612,500 - 20,612,500 3,001,903 17,610,597 14.6% 2,823,196 02130.0201 - Delinquent Personal Property Tax PCI 1,300,000 - 1,300,000 92,404 1,207,596 7.1% 88,144 02130.0900 - Personal Property Tax- Economic Development Incentive (20,917) - (20,917) (31,184) 10,267 149.1% (19,917) 02170.0105 - Penalty-Delinquent Tax 700,000 - 700,000 196,303 503,697 28.0% 135,893 02170.0205 - Interest-Delinquent Tax 300,000 - 300,000 119,526 180,474 39.8% 72,019 02510.0000 - Local Sales And Use Tax 20,000,000 - 20,000,000 1,752,857 18,247,143 8.8% 1,595,392 02510.0900 - Local Sales & Use Tax- Economic Development Incentive (87,592) - (87,592) (117,975) 30,383 134.7% (61,957) 02515.0100 - Consumer Utility Tax-Electric 3,500,000 - 3,500,000 649,708 2,850,292 18.6% 661,278 02515.0105 - Consumer Utility Tax-Gas 647,354 - 647,354 54,628 592,726 8.4% 54,828 02515.0120 - Right of Way Fees 225,000 - 225,000 63,592 161,408 28.3% 72,425 02515.0900 - Pen & Int - Consumer Utility Tax, None - - - 1 (1) 0.0% - 02517.0000 - Communication Sales & Use Tax 2,100,000 - 2,100,000 202,092 1,897,908 9.6% 210,321 02520.0000 - Business License Tax 9,016,000 - 9,016,000 44,423 8,971,577 0.5% 28,061 02520.0010 - Consumption Tax-Electric 320,779 - 320,779 53,700 267,079 16.7% 54,908 02520.0015 - Consumption Tax-Gas 30,819 - 30,819 4,374 26,445 14.2% 2,505 02520.0030 - Pen & Int-Business License 96,072 - 96,072 44,600 51,472 46.4% 13,246 02520.0900 - Business License Tax- Economic Development Incentive (26,726) - (26,726) (33,404) 6,678 125.0% (19,054) 02530.0001 - Motor Vehicle Licenses PCI 1,550,000 - 1,550,000 75,127 1,474,873 4.8% 78,357 02530.0201 - Delinquent Motor Vehicle License 190,000 - 190,000 10,607 179,393 5.6% 9,017 02535.0000 - Bank Stock Tax 750,000 - 750,000 - 750,000 0.0% 23,173 02540.0100 - Recordation Tax-City 675,000 - 675,000 79,454 595,546 11.8% 74,493 02540.0200 - Probate Tax 21,027 - 21,027 4,461 16,566 21.2% 3,076 02545.0000 - Tobacco Tax 800,000 - 800,000 183,998 616,002 23.0% 204,048 02550.0000 - Amusement Tax 720,000 - 720,000 144,854 575,146 20.1% 114,512 02550.0005 - Pen & Int - Amusement Tax - - - 4,112 (4,112) 0.0% 338 02555.0000 - Lodging Tax 3,000,000 - 3,000,000 604,180 2,395,820 20.1% 575,719 02555.0005 - Pen & Int - Lodging Tax - - - 1,201 (1,201) 0.0% 0 02555.0900 - Lodging Tax- Economic Development Incentive (314,148) - (314,148) (398,618) 84,470 126.9% (240,469) 02560.0000 - Meals Tax 17,700,000 - 17,700,000 3,058,984 14,641,016 17.3% 2,887,627 02560.0005 - Pen & Int - Meals Tax 49,793 - 49,793 11,260 38,533 22.6% 17,091 02560.0900 - Meals Tax- Economic Development Incentive (260,765) - (260,765) (345,420) 84,655 132.5% (169,995) 100 Taxes Total 152,396,287 - 152,396,287 13,518,647 138,877,640 8.9% 9,722,608 110 Permits, Fees, & Licenses 03005.0000 - Animal Licenses 7,000 - 7,000 1,135 5,865 16.2% 1,795 03010.0200 - Permit Parking Fees 200,000 - 200,000 61,222 138,778 30.6% 56,542 03010.0205 - Permit Parking Fees- Lease Agreement, None 90,000 - 90,000 12,887 77,113 14.3% - 03010.0400 - Land Disturbing Fees 20,000 - 20,000 4,441 15,560 22.2% 6,228 03010.0600 - Transfer Fees 2,000 - 2,000 683 1,317 34.1% 737 03010.0700 - Zoning Appeal Fees-Inspc 1,000 - 1,000 - 1,000 0.0% 200 03010.0702 - Zoning Certification Letter 3,500 - 3,500 600 2,900 17.1% 1,400 03010.0705 - Legal Notice Advertising 10,000 - 10,000 3,224 6,776 32.2% 1,355 03010.0710 - Site Plan Reviews 15,000 - 15,000 3,566 11,434 23.8% 3,731 03010.0715 - Conditional Use Permits 4,000 - 4,000 430 3,570 10.8% 800 03010.0720 - Re-zoning Fees 8,700 - 8,700 3,411 5,289 39.2% 31 03010.0800 - Subdivision Plat Review 10,000 - 10,000 2,520 7,480 25.2% 1,935 03010.0900 - Building Insp Permit Fee 500,000 - 500,000 129,486 370,514 25.9% 161,680 03010.0901 - Elevator Inspect Admin Fee 21,000 - 21,000 8,311 12,689 39.6% 8,250 03010.0902 - Elevator Inspect Admin Fee Pen & Int - - - 129 (129) 0.0% 110 03010.0920 - Sign Inspect Permit Fee 6,000 - 6,000 2,000 4,000 33.3% 1,225 03010.0925 - Demolition Fees 5,000 - 5,000 2,295 2,705 45.9% 650 03010.0927 - Building Plan Review 44,000 - 44,000 10,961 33,039 24.9% 14,585 03010.0928 - Vacant Building Registration Fee 30,000 - 30,000 20,209 9,791 67.4% 16,353 03010.0929 - Pen & Int-Vacant Building Registration Fee - - - 888 (888) 0.0% 893 03010.0930 - Certificate of Occupancy for Existing Building - - - 675 (675) 0.0% 1,050 03010.0931 - Temporary Certificate of Occupancy, None - - - 4,350 (4,350) 0.0% 2,850 03010.0932 - Working Without a Building Permit - - - - - 0.0% 300 03010.0933 - Short Term Rental Fee, None 5,000 - 5,000 7,650 (2,650) 153.0% 15,564 03010.0934 - Vacant Property Registration- Civil Penalties, None 20,000 - 20,000 9,154 10,846 45.8% 3,899 03010.1000 - False Alarm Service Assessment 110,000 - 110,000 15,883 94,117 14.4% 5,626 03010.1100 - Concealed Weapon Permit 30,000 - 30,000 8,146 21,854 27.2% 7,215 03010.2005 - Taxicab Application Fees 3,000 - 3,000 50 2,950 1.7% 550 03010.2010 - Precious Metal Premits 1,600 - 1,600 - 1,600 0.0% - 03010.2011 - Rental Reinspect/FollowUp - - - 200 (200) 0.0% - 03010.2012 - Rental Intial Inspection - - - 400 (400) 0.0% 100 03010.2013 - Annual/Periodic Inspect Fee 22,000 - 22,000 150 21,850 0.7% 200 03010.2014 - Rental Intial Inspect-No Show - - - 200 (200) 0.0% - 03010.2020 - Mobile Vendor License Fee - - - 40 (40) 0.0% - 03010.2028 - Dumpster Permit Fee , None - - - 50 (50) 0.0% 100 03010.2029 - Dumpster Permit Fee- 30 Day Extension, None - - - - - 0.0% 200 03010.2050 - Misc Permit Fee & License - - - 2,090 (2,090) 0.0% 3,080 110 Permits, Fees, & Licenses Total 1,168,800 - 1,168,800 317,436 851,364 27.2% 319,234 120 Fines & Forfeitures 03510.0100 - Court Fines And Forfeitures, None 187,500 - 187,500 (12,775) 200,275 -6.8% 16,756 03510.0105 - Criminal Court Fees 2,500 - 2,500 270 2,230 10.8% 239 03510.0200 - Parking Fines 60,000 - 60,000 12,485 47,515 20.8% 8,292 120 Fines & Forfeitures Total 250,000 - 250,000 (19) 250,019 0.0% 25,287 130 Use of Money & Property 04010.0100 - Interest on Investment - - - 226,196 (226,196) 0.0% 47,191 04010.0101 - Interest-City Capital - - - 16,605 (16,605) 0.0% 53,907 04010.0123 - Interest-Health Ins Resrv - - - 18,400 (18,400) 0.0% 12,969 FINANCE COMMITTEE AGENDA ITEM #: 6 Revenues Adopted Budget Budget Amendment Amended Budget Actual Amount 9/30/22 Remaining Budget w/o Encumbrances Percentage of Amended Budget Actual Amount 9/30/21 04010.0124 - Interest-OPEB - - - 6,598 (6,598) 0.0% 1,207 04010.0131 - Interest Income- ARPA Funds Invested at LGIP, None - - - 180,631 (180,631) 0.0% - 04010.0156 - Interst-MktValueGain/Loss - - - (222,096) 222,096 0.0% (89,027) 04010.0157 - Interest-SNAP Income - - - 7,997 (7,997) 0.0% 2,342 04020.0105 - Gen Govt Property Rental 75,000 - 75,000 25,967 49,033 34.6% 17,240 04020.0115 - Public Safety Prop Rent 36,250 - 36,250 - 36,250 0.0% - 04020.0125 - Human Services Prop Rent 100,000 - 100,000 25,000 75,000 25.0% 25,000 04020.0135 - Downtown Parking Deck Lease, None 41,400 - 41,400 6,900 34,500 16.7% 27,600 04020.0200 - Culture & Rec. Prop Rent 15,070 - 15,070 3,768 11,303 25.0% 3,768 04020.0201 - Prop Rental-Stadium 16,000 - 16,000 3,750 12,250 23.4% 2,850 04020.0202 - Prop Rental-Market/Park. 100,000 - 100,000 25,804 74,196 25.8% 30,597 04020.0205 - Market Rent- Pen & Int 1,500 - 1,500 279 1,221 18.6% 229 04020.0207 - Rental of Museum Facilities, None 500 - 500 - 500 0.0% - 130 Use of Money & Property Total 385,720 - 385,720 325,798 59,922 84.5% 135,871 140 Charges for Services 04510.0900 - Collection & Tax Lien Fees 35,000 - 35,000 12,472 22,528 35.6% 12,607 04510.0901 - DMV Admin Fee 278,000 - 278,000 101,938 176,062 36.7% 90,093 04510.0915 - Processng Fee - Payroll deduction 4,500 - 4,500 1,110 3,390 24.7% 1,025 04510.0916 - Indirect Cost&Svc DetHome 272,270 - 272,270 68,068 204,203 25.0% 68,734 04510.0918 - Indirect Cost&Srvc Water 1,130,803 - 1,130,803 282,701 848,102 25.0% 259,275 04510.0919 - Indirect Cost&Srvc Sewer 278,673 - 278,673 69,668 209,005 25.0% 67,523 04510.0920 - Indirect Cost&Srvc WWTP 595,108 - 595,108 148,777 446,331 25.0% 146,391 04510.0921 - Indirect Cost&Srvc Airprt 184,104 - 184,104 46,026 138,078 25.0% 45,269 04510.0922 - Indirect Cost&Svc Strmwtr 304,138 - 304,138 76,035 228,103 25.0% 80,396 04515.0101 - Document Reprod Costs 7,000 - 7,000 1,504 5,496 21.5% 1,756 04515.0200 - Court Room Sheriff Fee, None 63,000 - 63,000 16,927 46,073 26.9% 16,367 04515.0300 - Fees For Court Officers 7,000 - 7,000 7,244 (244) 103.5% 7,244 04515.0301 - Legal Service Charges 40,000 - 40,000 - 40,000 0.0% - 04515.0303 - Probation Supervisor Fee 10,000 - 10,000 1,542 8,458 15.4% 1,551 04515.0304 - Jail Fee, None 2,000 - 2,000 544 1,456 27.2% 481 04515.0305 - E-Summons Fee, None 12,000 - 12,000 3,832 8,168 31.9% 3,742 04515.0400 - Commonwealth Atty.Fees 5,000 - 5,000 1,667 3,333 33.3% 1,381 04515.0401 - CA Coll Fees- Gen Dist Ct 55,000 - 55,000 4,739 50,261 8.6% 5,131 04515.0402 - CA Coll Fees- J&D Court 10,050 - 10,050 678 9,372 6.7% 883 04515.0403 - CA Coll Fees- Circuit Crt 62,600 - 62,600 16,162 46,438 25.8% 8,271 04515.0404 - CA Coll Fees- FOIA Requests, None 2,000 - 2,000 - 2,000 0.0% 819 04520.0300 - Fire Prevention Fees 2,000 - 2,000 1,050 950 52.5% 1,250 04520.0301 - Ambulance Service Fees 3,000,000 - 3,000,000 602,850 2,397,150 20.1% 555,127 04520.0304 - Delinq Ambulance>120 Days 175,000 - 175,000 23,826 151,174 13.6% 35,749 04520.0305 - LFD Off Duty, None - - - 33,415 (33,415) 0.0% - 04520.0306 - LFD Off Duty - Penalty and Interest, None - - - 3,170 (3,170) 0.0% - 04520.0307 - Lynchburg Fire Dept Charges, None - - - 807 (807) 0.0% - 04520.0901 - PIER Contract Payments 26,500 - 26,500 22,000 4,500 83.0% 26,500 04520.0903 - Police-Schools Resource Officer (SRO) Prog 140,000 - 140,000 - 140,000 0.0% - 04520.0904 - Local Reimb-COL Confined Space 50,000 - 50,000 12,500 37,500 25.0% 12,500 04520.0905 - Police Report Sales 2,200 - 2,200 710 1,490 32.3% 520 04520.0906 - Range Use Fee 13,800 - 13,800 12,800 1,000 92.8% 12,800 04520.0908 - DUI Fees, None - - - 1,317 (1,317) 0.0% 700 04520.0909 - LPD Off Duty 1,100,000 - 1,100,000 177,089 922,911 16.1% 189,137 04525.0106 - Downtown Parking Fees 30,000 - 30,000 5,504 24,496 18.3% 3,938 04525.0107 - PW Admin Stormwater Charges 119,527 - 119,527 9,063 110,464 7.6% 3,816 04525.0108 - PW Eng Stormwater Charges 11,957 - 11,957 5,715 6,242 47.8% 2,228 04525.0109 - PW Streets Stormwater Charges 150,090 - 150,090 394 149,696 0.3% 463 04525.0218 - Trash Bag Srvc-Waste Zero 65,000 - 65,000 18,052 46,948 27.8% 46,732 04525.0219 - Landlord Set Out Program , None 3,000 - 3,000 3,478 (478) 115.9% 500 04525.0220 - Refuse Disposal Fee, None 2,340,000 - 2,340,000 597,039 1,742,961 25.5% 607,904 04525.0221 - Penalty- Refuse Disposal Fee, None - - - 5,277 (5,277) 0.0% 5,294 04525.0300 - Bldg Maint Charge-Other - - - 2,536 (2,536) 0.0% 2,536 04530.0409 - Human Services Court Order Fees - - - 142 (142) 0.0% 271 04530.0410 - Lynchburg Youth Group Home Charges 450,000 - 450,000 85,900 364,100 19.1% 49,650 04530.0413 - Local Reimb- Other Localities, None - - - - - 0.0% 401 04535.0100 - Swimming Pool Fees 30,000 - 30,000 16,066 13,934 53.6% 20,539 04535.0150 - Recreation Program Fees 450,000 - 450,000 129,703 320,297 28.8% 124,236 04535.0151 - Recreation Program- Scholarship Fees , None 5,300 - 5,300 - 5,300 0.0% - 04535.0200 - Point of Honor Admission Fees 2,500 - 2,500 - 2,500 0.0% - 04535.0300 - Library Fines & Fees 15,000 - 15,000 7,531 7,469 50.2% 6,529 04535.0301 - Law Library Fees 30,000 - 30,000 7,683 22,317 25.6% 5,740 04535.0303 - Lost/Damaged Library Prop 2,500 - 2,500 1,181 1,319 47.2% 997 04535.0304 - Delinq Library Fines & Fees 2,000 - 2,000 10 1,990 0.5% 630 04535.0305 - Delinq Library Lost/Damaged 5,000 - 5,000 444 4,556 8.9% 1,328 04535.0306 - Delinq Library Pen & Int 2,000 - 2,000 308 1,692 15.4% 918 04540.0105 - Comm Develop Stormwater Charges 582,931 - 582,931 194,310 388,621 33.3% 145,128 04599.0004 - Neighborhood Services, None 21,000 - 21,000 10,020 10,980 47.7% 6,950 04599.0009 - Penalty and Interest- Neighborhood Services Receivables, None - - - 187 (187) 0.0% 80 140 Charges for Services Total 12,185,551 - 12,185,551 2,853,710 9,331,841 23.4% 2,690,027 150 Miscellaneous Revenue 05030.0105 - Suspense Revenue/Exp Ref - - - 441 (441) 0.0% 1,885 05050.0105 - Pmt In Lieu Tax-WestCntbr 53,799 - 53,799 - 53,799 0.0% - 05050.0110 - Pymt In Lieu of Tax-LRHA 25,000 - 25,000 - 25,000 0.0% - 05050.0228 - Recreation Program- Donations, None - - - - - 0.0% 4,000 05050.0230 - Friends of Lynchburg Library 17,981 - 17,981 - 17,981 0.0% 3,174 05050.0232 - Digg's Trust Rec-Pt Honor 37,000 - 37,000 9,250 27,750 25.0% 9,250 05050.0400 - Sale-Salvage/Surplus Prop - - - 290 (290) 0.0% 3,512 05050.2001 - Cash Overage And Shortage - - - 47 (47) 0.0% (500) 05050.2011 - Reimb.POH Carriage House 27,000 - 27,000 8,102 18,898 30.0% 6,938 05050.2013 - Photo Reprod And Royalty 100 - 100 - 100 0.0% - 05050.2016 - Dedicated Misc Rev HumSvc - - - - - 0.0% 0 05050.2025 - Credit Card Rebate 95,000 - 95,000 - 95,000 0.0% - 05050.2028 - WardsCrossingWestSvcFee 143,277 - 143,277 - 143,277 0.0% - 05050.2034 - P&R Spec Event Sponsorship, None 15,000 - 15,000 1,000 14,000 6.7% 2,200 05050.2046 - Visitor Ctr Merchandise - - - - - 0.0% 125 05050.2049 - Residential Trash Violation, None 6,000 - 6,000 5,172 828 86.2% 2,674 05050.2052 - Parking Lease Agreement - - - - - 0.0% 16,662 05050.2055 - Hillcats - Donation Youth Athletic Programs 10,000 - 10,000 10,000 - 100.0% 10,000 FINANCE COMMITTEE AGENDA ITEM #: 6 Revenues Adopted Budget Budget Amendment Amended Budget Actual Amount 9/30/22 Remaining Budget w/o Encumbrances Percentage of Amended Budget Actual Amount 9/30/21 05050.2056 - Commission on City Vending Machine Sales - - - 718 (718) 0.0% 1,005 05050.2059 - Court Restitution, None - - - 708 (708) 0.0% - 05050.2060 - Community Market Retail Sales, None 500 - 500 - 500 0.0% 238 05050.2090 - Miscellaneous Revenue 51,000 - 51,000 6,662 44,338 13.1% 8,162 150 Miscellaneous Revenue Total 481,657 - 481,657 42,389 439,268 8.8% 69,324 300 State Non-Categorical Aid 06100.0300 - Rolling Stock Taxes 88,000 - 88,000 88,731 (731) 100.8% 88,584 06100.0400 - Mobile Home Titling Taxes 1,000 - 1,000 1,467 (467) 146.7% 765 06100.0600 - Deeds Of Conveyance 150,000 - 150,000 21,756 128,244 14.5% 18,460 06100.0800 - Recordation Taxes-State - - - - - 0.0% - 06100.0900 - Auto Rental Tax-DMV 350,000 - 350,000 137,811 212,189 39.4% 126,972 06100.0905 - Peer to Peer Vehicle Sharing Tax, None - - - 2,113 (2,113) 0.0% 317 06100.1108 - Personal Prop Tax Relief 5,543,584 - 5,543,584 277,179 5,266,405 5.0% 277,179 06100.8001 - Games of Skill Tax, None - - - - - 0.0% 42,624 300 State Non-Categorical Aid Total 6,132,584 - 6,132,584 529,057 5,603,527 8.6% 554,902 310 State Shared Exp (Cat.) 06510.0200 - Commissioner of Revenue 201,758 7,761 209,519 30,699 178,820 14.7% 32,489 06510.0300 - Treasurer 120,023 5,513 125,536 19,114 106,422 15.2% 18,659 06510.1000 - Registrar/Electoral Board 99,914 2,053 101,967 - 101,967 0.0% - 06515.0100 - Clerk of Cir Crt-Fringes 646,468 48,144 694,612 100,365 594,247 14.4% 95,088 06515.0200 - Sheriff 1,162,719 87,313 1,250,032 193,312 1,056,720 15.5% 187,648 06515.0400 - Commonwealth Attorney 1,131,821 32,362 1,164,183 161,817 1,002,366 13.9% 177,306 310 State Shared Exp (Cat.) Total 3,362,703 183,146 3,545,849 505,307 3,040,542 14.3% 511,191 320 State Categorical Aid 06820.0200 - Juvenile Correct-Block Gt 247,716 - 247,716 61,929 185,787 25.0% 61,929 06820.0201 - Wireless E911 380,000 - 380,000 82,530 297,470 21.7% 74,851 06820.0203 - HB 599 Law Enforc.Asst 3,250,000 333,617 3,583,617 895,904 2,687,713 25.0% 814,936 06825.0100 - Street And Highway Maint. 8,842,661 693,030 9,535,691 2,385,609 7,150,082 25.0% 2,264,027 06830.0413 - SS State Adm Sub 0901 1,849,884 1,250 1,851,134 367,800 1,483,334 19.9% 477,675 06830.0414 - SS State Prog Sub 0902 4,912,198 - 4,912,198 371,051 4,541,147 7.6% 412,851 06835.0102 - SNAP Program Reimb 16,000 - 16,000 5,014 10,986 31.3% 11,161 06835.0300 - Finan Asst-Public Library 181,175 23,274 204,449 51,112 153,337 25.0% 45,044 320 State Categorical Aid Total 19,679,634 1,051,171 20,730,805 4,220,949 16,509,856 20.4% 4,162,475 330 State Aid in Suspense 05030.0100 - Suspense Rev-Va EDI Pmts - - - - - 0.0% - 330 State Aid in Suspense Total - - - - - 0.0% - 500 Fed Direct Non-Categorical Aid 07530.0010 - American Rescue Plan Act (ARPA) Funding, None 680,000 32,648,529 33,328,529 5,659,226 27,669,303 17.0% - 500 Fed Direct Non-Categorical Aid Total 680,000 32,648,529 33,328,529 5,659,226 27,669,303 17.0% - 520 Fed Cat Aid- Pass Thru 07825.0300 - B&G Chrgs Commerce St Bld - - - - - 0.0% - 07830.0420 - Fed Pass Thru:Cost AIIDMG 573,000 - 573,000 - 573,000 0.0% - 07830.0421 - SS Fed Adm Sub 0901 5,426,133 1,750 5,427,883 822,168 4,605,715 15.1% 980,947 07830.0422 - SS Fed Prog Sub 0902 3,672,129 - 3,672,129 350,429 3,321,700 9.5% 409,352 07830.0430 - USDA Funding - Group Home, None 16,000 - 16,000 7,614 8,386 47.6% 3,345 07875.0003 - Human Service Lease 62,000 - 62,000 10,479 51,521 16.9% 24,515 07875.0021 - FINI Double-Dollars 14,000 - 14,000 10,514 3,486 75.1% 8,500 520 Fed Cat Aid- Pass Thru Total 9,763,262 1,750 9,765,012 1,201,204 8,563,808 12.3% 1,426,660 710 Operating Transfers In 09301.0003 - TrfFrmCtyCp-Capital Proj - 25,000 25,000 - 25,000 0.0% - 710 Operating Transfers In Total - 25,000 25,000 - 25,000 0.0% - Grand Total 206,486,198 33,909,596 240,395,794 29,173,703 211,222,091 12.1% 19,617,578 FINANCE COMMITTEE AGENDA ITEM #: 6 Fiscal Year Fiscal Calendar 2023 Fiscal Quarter of Year Fiscal Q 1 Fund 1001 General Fund Account Type Expenses Process Status Posted Expenditures Adopted Budget Budget Amendment Amended Budget Actual Amount 9/30/22 Remaining Budget w/ Encumbrances Percentage Used w/ Encumbrances Actual Amount 9/30/21 2022 Communications/Public Engagement 0021 Public Information 556,309 154,414 710,723 155,953 474,769 33.2% 153,503 0022 Customer Service Center 202,790 16,280 219,070 45,423 173,647 20.7% 32,379 0029 Local Government Channel 387,228 11,014 398,242 38,591 359,651 9.7% 34,600 2022 Communications/Public Engagement Total 1,146,327 181,708 1,328,035 239,967 1,008,066 24.1% 220,483 2023 Council / Manager 0028 Council / Manager 1,280,840 94,320 1,375,160 287,664 1,067,496 22.4% 245,223 0033 Parking Division - - - - - 0.0% (120) 2023 Council / Manager Total 1,280,840 94,320 1,375,160 287,664 1,067,496 22.4% 245,103 2030 City Attorney 0050 City Attorney 954,903 37,634 992,537 192,629 799,431 19.5% 161,786 0051 Risk Management 1,318,278 - 1,318,278 1,318,278 - 100.0% 758,581 2030 City Attorney Total 2,273,181 37,634 2,310,815 1,510,907 799,431 65.4% 920,367 2035 State Treasurer 0060 State Treasurer 186,917 7,413 194,330 40,712 153,618 21.0% 36,850 2035 State Treasurer Total 186,917 7,413 194,330 40,712 153,618 21.0% 36,850 2040 Commissioner Of Revenue 0070 Com Rev-State/Loc Budget 891,124 57,000 948,124 173,118 762,107 19.6% 171,087 2040 Commissioner Of Revenue Total 891,124 57,000 948,124 173,118 762,107 19.6% 171,087 2045 City Assessor 0080 City Assessor 799,837 23,855 823,692 133,512 686,147 16.7% 174,941 2045 City Assessor Total 799,837 23,855 823,692 133,512 686,147 16.7% 174,941 2050 Finance 0090 Office of Management & Budget 756,215 73,231 829,446 165,346 611,115 26.3% 143,848 0093 Billings And Collections 1,759,721 186,904 1,946,625 342,823 1,363,071 30.0% 284,630 0094 Procurement 505,047 29,493 534,540 101,471 429,175 19.7% 83,060 0095 Accounting 1,139,167 131,199 1,270,366 207,634 875,172 31.1% 193,271 2050 Finance Total 4,160,150 420,827 4,580,977 817,272 3,278,533 28.4% 704,809 2055 Human Resources 0110 Human Resources 1,020,159 55,179 1,075,338 220,208 853,302 20.6% 144,175 0111 Occupational Health Svs 216,440 - 216,440 360 216,080 0.2% 29,428 2055 Human Resources Total 1,236,599 55,179 1,291,778 220,568 1,069,382 17.2% 173,603 2057 Information Technology 0115 Application Services 1,382,358 58,132 1,440,490 301,350 1,139,140 20.9% 281,270 0116 Network Services 1,769,996 87,219 1,857,215 445,311 1,396,014 24.8% 408,982 0117 I T Administration 471,325 24,846 496,171 97,946 379,099 23.6% 67,446 0125 GIS 377,765 14,481 392,246 102,764 289,482 26.2% 95,119 2057 Information Technology Total 4,001,444 184,678 4,186,122 947,370 3,203,736 23.5% 852,817 2065 Registrar 0150 Registrar 322,279 15,889 338,168 63,484 274,018 19.0% 58,243 0151 Electoral Board 204,118 1,133 205,251 76,427 128,824 37.2% 13,561 2065 Registrar Total 526,397 17,022 543,419 139,911 402,842 25.9% 71,804 2090 Education 0200 Lcl Sch Oper Contribution 40,794,923 - 40,794,923 10,500,000 30,294,923 25.7% 7,200,000 2090 Education Total 40,794,923 - 40,794,923 10,500,000 30,294,923 25.7% 7,200,000 2105 Circuit Court-Judge 0300 Circuit Court-Judge 165,735 7,240 172,975 34,973 137,727 20.4% 30,939 2105 Circuit Court-Judge Total 165,735 7,240 172,975 34,973 137,727 20.4% 30,939 2110 General District Court 0310 General District Court 60,873 2,611 63,484 5,607 55,951 11.9% 9,680 2110 General District Court Total 60,873 2,611 63,484 5,607 55,951 11.9% 9,680 2115 Juvenile & Dr Dist Court 0320 Juvenile & Dr Dist Court 28,454 374 28,828 2,894 23,017 20.2% 9,808 2115 Juvenile & Dr Dist Court Total 28,454 374 28,828 2,894 23,017 20.2% 9,808 2120 24th Court Service Unit 0330 24th Court Service Unit 1,425 20 1,445 428 997 31.0% 313 2120 24th Court Service Unit Total 1,425 20 1,445 428 997 31.0% 313 2125 Commonwealth's Attorney 0340 Commonwealth Attorney 1,816,215 68,305 1,884,520 392,763 1,489,115 21.0% 353,660 0343 Com Aty Fines & Fees Coll 66,555 2,658 69,213 15,086 53,017 23.4% 14,342 2125 Commonwealth's Attorney Total 1,882,770 70,963 1,953,733 407,849 1,542,132 21.1% 368,002 2130 Magistrate's Office 0350 Magistrate's Office 6,954 47 7,001 275 6,697 4.3% 544 2130 Magistrate's Office Total 6,954 47 7,001 275 6,697 4.3% 544 2135 Circuit Court-Clerk FINANCE COMMITTEE AGENDA ITEM #: 6 Expenditures Adopted Budget Budget Amendment Amended Budget Actual Amount 9/30/22 Remaining Budget w/ Encumbrances Percentage Used w/ Encumbrances Actual Amount 9/30/21 0360 Circuit Court-Clerk 1,030,995 53,940 1,084,935 214,284 870,651 19.8% 198,834 2135 Circuit Court-Clerk Total 1,030,995 53,940 1,084,935 214,284 870,651 19.8% 198,834 2200 City Sheriff 0400 City Sheriff And Jail 2,490,159 138,958 2,629,117 563,629 2,065,488 21.4% 569,729 2200 City Sheriff Total 2,490,159 138,958 2,629,117 563,629 2,065,488 21.4% 569,729 2240 Police 0420 Police Operations 22,339,496 760,581 23,100,077 5,085,152 17,573,685 23.9% 4,207,606 0421 Animal Warden 359,276 7,325 366,601 81,270 285,331 22.2% 70,820 0429 Range Operations 13,800 9,441 23,241 1,078 20,863 10.2% 833 0430 Police Off Duty Employmnt 1,028,181 1,260 1,029,441 172,195 857,246 16.7% 157,789 2240 Police Total 23,740,753 778,607 24,519,360 5,339,696 18,737,124 23.6% 4,437,048 2245 Emergency Services 0422 Emergency Communications 3,510,969 142,952 3,653,921 766,036 2,859,048 21.8% 657,334 2245 Emergency Services Total 3,510,969 142,952 3,653,921 766,036 2,859,048 21.8% 657,334 2270 Fire 0444 Fire Operations And Ems 20,824,622 509,905 21,334,527 4,569,594 16,743,006 21.5% 3,749,821 0446 TRT- PIER Program 76,500 8,900 85,400 14,911 61,589 27.9% 24,337 2270 Fire Total 20,901,122 518,805 21,419,927 4,584,506 16,804,594 21.5% 3,774,158 2400 Public Works 0600 Public Works Administrat. 1,107,319 70,513 1,177,832 241,470 934,577 20.7% 200,779 0605 Engineering 4,392,418 471,856 4,864,274 925,296 3,641,669 25.1% 694,861 0632 Street Maintenance,II 4,042,584 1,539,469 5,582,053 831,685 3,781,677 32.3% 460,392 0635 Snow Removal 343,233 37,082 380,315 85,258 (17,056) 104.5% 13,162 0640 Refuse Collection 4,086,729 1,304,020 5,390,749 1,276,622 2,354,590 56.3% 895,366 0645 Parks/Grounds Maintenance 4,207,350 928,309 5,135,659 1,011,651 3,282,190 36.1% 795,265 0649 Baseball Stadium Maint 102,823 7,828 110,651 38,164 45,084 59.3% 22,098 0650 Building Maintenance 4,080,521 282,824 4,363,345 884,878 3,177,715 27.2% 705,857 0660 Human Services Maint. 59,250 4,889 64,139 12,257 30,582 52.3% 8,890 2400 Public Works Total 22,422,227 4,646,790 27,069,017 5,307,280 17,231,027 36.3% 3,796,670 2555 Health 0800 Health Operations 785,000 - 785,000 196,250 - 100.0% 196,250 2555 Health Total 785,000 - 785,000 196,250 - 100.0% 196,250 2561 Juvenile Services 0905 Juvenile Detention Home 863,000 - 863,000 86,828 776,172 10.1% 160,972 0906 Juvenile Services 1,833,220 347,861 2,181,081 456,106 1,710,253 21.6% 361,668 0915 Csa Service Providers 2,039,543 - 2,039,543 509,886 1,529,657 25.0% 509,428 2561 Juvenile Services Total 4,735,763 347,861 5,083,624 1,052,820 4,016,083 21.0% 1,032,069 2562 Social Services 0901 Social Services Admin. 10,147,424 554,919 10,702,343 2,269,016 8,397,255 21.5% 1,965,247 0902 Public Assistance 8,749,646 - 8,749,646 1,477,454 7,272,192 16.9% 1,583,900 2562 Social Services Total 18,897,070 554,919 19,451,989 3,746,470 15,669,447 19.4% 3,549,147 2563 Recreation Services 0116 Network Services 22,385 - 22,385 11,120 10,506 53.1% 8,871 1002 Parks/Rec/Market 427,313 21,793 449,106 99,228 341,230 24.0% 87,125 1010 Recreation, General Admin 709,819 60,533 770,352 149,047 592,174 23.1% 147,968 1011 Recreation Services 154,744 11,654 166,398 35,257 131,141 21.2% 30,722 1013 Recreation, Athletic 161,952 13,875 175,827 39,350 136,477 22.4% 30,358 1015 Recreation, Park Services 785,148 65,371 850,519 190,033 660,486 22.3% 162,827 1022 Recreation, Aquatics 141,070 16,234 157,304 82,471 74,833 52.4% 58,811 1023 Recreation, Naturalist 197,189 4,716 201,905 38,422 163,483 19.0% 40,926 1027 Recreation Programs 523,491 - 523,491 134,658 363,859 30.5% 98,904 1028 City-wide Centers 293,486 10,107 303,593 66,938 236,655 22.0% 59,885 1029 Neighborhood Centers 843,901 37,110 881,011 176,735 704,276 20.1% 161,147 2563 Recreation Services Total 4,260,498 241,393 4,501,891 1,023,259 3,415,119 24.1% 887,544 2610 Libraries 1100 Public Library 2,201,582 139,417 2,340,999 376,397 1,958,644 16.3% 319,464 1120 Law Library 10,000 - 10,000 2,946 7,054 29.5% 1,590 2610 Libraries Total 2,211,582 139,417 2,350,999 379,343 1,965,699 16.4% 321,054 2611 Museum System 1150 Museum 536,579 25,281 561,860 79,565 480,703 14.4% 101,408 2611 Museum System Total 536,579 25,281 561,860 79,565 480,703 14.4% 101,408 2715 Community Development 1200 Director-Comm Plan/Dev 328,882 38,299 367,181 75,217 286,195 22.1% 66,320 1201 Planning 664,762 69,105 733,867 106,232 592,845 19.2% 69,456 1202 Inspections 1,131,731 66,313 1,198,044 234,309 963,735 19.6% 194,861 1205 Zoning 397,663 14,565 412,228 79,682 332,546 19.3% 68,966 2715 Community Development Total 2,523,038 188,282 2,711,320 495,441 2,175,320 19.8% 399,603 2720 Office Of Economic Devel 1300 Economic Development 1,816,498 128,189 1,944,687 464,345 1,405,776 27.7% 364,211 2720 Office Of Economic Devel Total 1,816,498 128,189 1,944,687 464,345 1,405,776 27.7% 364,211 5000 Nondept Employee Benefits FINANCE COMMITTEE AGENDA ITEM #: 6 Expenditures Adopted Budget Budget Amendment Amended Budget Actual Amount 9/30/22 Remaining Budget w/ Encumbrances Percentage Used w/ Encumbrances Actual Amount 9/30/21 1430 Non-allocated Emp Benefit 4,838,021 - 4,838,021 725,374 4,112,647 15.0% 753,368 5000 Nondept Employee Benefits Total 4,838,021 - 4,838,021 725,374 4,112,647 15.0% 753,368 5050 Non-Departmental 1506 Water Oper Fund Payments 873,843 - 873,843 291,281 582,562 33.3% 221,972 1508 Stormwater Fee-City Bldgs 97,200 - 97,200 15,491 81,709 15.9% 22,128 1509 Stormwater Fee-School Bld 73,400 - 73,400 12,162 61,238 16.6% 17,500 1512 College Lake Dam Repairs - 108,995 108,995 542 (542) 100.5% 391 1513 Stormwater Detention Pond Repair - - - - - 0.0% - 1515 Alternative to CARES Funding - 337,353 337,353 199,703 (975) 100.3% 365,001 1516 COVID Vaccinations - - - - - 0.0% - 1517 Real Estate Credit 1,300,000 - 1,300,000 1,190,579 109,421 91.6% - 1566 Managed Vacancy Program (1,102,096) - (1,102,096) - (1,102,096) 0.0% - 1567 Years of Service Awards 15,000 - 15,000 4,202 10,798 28.0% 3,496 1568 Retirement Recognition 5,000 - 5,000 881 4,119 17.6% - 1569 Take Your Kids to Work Dy 1,000 - 1,000 - 1,000 0.0% - 1570 Emp Appreciation Luncheon 3,000 7,000 10,000 - 10,000 0.0% - 1573 Payment-Fleet Capital Chg 3,135,484 - 3,135,484 716,501 2,418,983 22.9% 809,725 1574 Health Management Program 15,000 2,005 17,005 6,909 10,096 40.6% (18,321) 1575 Employee Committee Funds 8,000 - 8,000 - 8,000 0.0% - 1576 Line of Duty Act 312,000 - 312,000 96,420 215,580 30.9% 99,638 1578 Poverty Intiative - 45,369 45,369 1,781 43,588 3.9% - 1579 Recruitment 50,000 1,900 51,900 6,841 45,059 13.2% 11,587 1580 International Festival 7,500 6,176 13,676 320 13,356 2.3% 150 1581 Workplace Safety & Wellness 60,000 - 60,000 3,117 56,883 5.2% 3,544 1637 City Cemetery Master Plan 166,858 - 166,858 110,126 - 100.0% 110,126 5050 Non-Departmental Total 5,021,189 508,797 5,529,986 2,656,857 2,568,778 53.5% 1,646,935 5060 Support Local/State Organ 1702 V.P.I. Extension Service 41,748 - 41,748 2,005 (5) 100.0% 15 1705 Lynchburg Humane Society 355,440 - 355,440 355,440 - 100.0% 405,440 1707 Cent Va Alli for Comm Liv 15,000 - 15,000 15,000 - 100.0% 15,000 1708 Horizon Behavioral Health 576,512 - 576,512 144,128 - 100.0% 143,628 1709 Cvcc Board & Related Oper 1,956 - 1,956 1,956 - 100.0% 1,955 1711 Cent Va Planning Dist Com 49,979 - 49,979 49,979 - 100.0% 47,258 1715 Greater Lynch. Transit Co 1,266,454 - 1,266,454 633,226 633,228 50.0% 316,613 1721 Blue Ridge Regional Jail 4,870,548 - 4,870,548 2,256,462 (1,038,825) 121.3% 2,096,096 1724 Legal Aid Society 13,160 - 13,160 13,160 - 100.0% 13,160 1739 Contrib- Amazement Square 369 - 369 - 369 0.0% - 1743 Central Va Reg Radio Brd 724,171 - 724,171 392,481 331,690 54.2% 400,125 1748 Elizabeth's Early Learn Center - - - - - 0.0% - 1750 Downtown Lynchburg Association 50,000 - 50,000 12,500 - 100.0% - 5060 Support Local/State Organ Total 7,965,337 - 7,965,337 3,876,337 (73,543) 100.9% 3,439,289 7450 Debt Service 5990 Principal Bonds/BANS/LOC 10,931,540 - 10,931,540 2,675,865 8,255,675 24.5% 2,986,672 5994 Interest Bonds/BANS/LOC 6,277,548 - 6,277,548 1,195,151 5,082,397 19.0% 1,251,840 5997 Debt - Misc. Charges 3,550 - 3,550 - 3,550 0.0% - 7450 Debt Service Total 17,212,638 - 17,212,638 3,871,016 13,341,622 22.5% 4,238,512 7570 Other Financing Uses 9710 Operating Transfers Out 13,261,286 33,314,633 46,575,919 455,162 46,120,758 1.0% 195,268 7570 Other Financing Uses Total 13,261,286 33,314,633 46,575,919 455,162 46,120,758 1.0% 195,268 Grand Total 217,604,674 42,889,717 260,494,391 51,260,697 198,259,144 23.9% 41,749,580 FINANCE COMMITTEE AGENDA ITEM #: 6 Investment Summary Quarterly Investment Review - 12/31/2022 City of Lynchburg Total Investments This Quarter 174,665,861 Last Quarter 159,471,506 One Year Ago 148,451,053 Weighted Average Yield Portfolio 2.89% Weighted Average Maturity (days) Excluding Liquidity (days) 273 Including Liquidity (days) 119 For the quarter ended December 31, 2022, the City purchased 11 new securities which had a par value of $19.15 million and a weighted average yield of 4.50%. Additionally, $9.6 million of the portfolio's securities matured during the quarter. By the quarter ended March 31, 2023, an additional $22.84 million of securities will have matured. The weighted average yield increased over the previous quarter from 2.22% to 2.89%. The average maturity of the portfolio (excluding liquidity) decreased by 132 days. 0.00% 0.50% 1.00% 1.50% 2.00% 2.50% 3.00% 3.50% 4.00% 4.50% 5.00% Oct-18 Dec-18 Feb-19 Apr-19 Jun-19 Aug-19 Oct-19 Dec-19 Feb-20 Apr-20 Jun-20 Aug-20 Oct-20 Dec-20 Feb-21 Apr-21 Jun-21 Aug-21 Oct-21 Dec-21 Feb-22 Apr-22 Jun-22 Aug-22 Oct-22 Dec-22 Portfolio Yield 6-Month T-Bill LGIP Current Holdings Portfolio Statistics Comments Liquidity LGIP 53% Liquidity Money Market 3% Agencies FHLB 15% Agencies FNMA 4% Agencies FFCB 2% Agencies FHLM 1% Treasuries TR 9% Municipals MUNI 8% Commercial Paper CP 5% Portfolio Yield - As of December 31, 2022 Prepared by: Davenport & Company LLC 12/31/2022 20 FINANCE COMMITTEE AGENDA ITEM #: 7 CURRENT ASSET ALLOCATION WILMINGTON TRUST & LGIP INVESTMENTS BY SECURITY TYPE AND BANK AS OF DECEMBER 31, 2022 Amount Investment Target Type Invested Percentages Investment % LGIP Funds Wilmington Money Mrkt $5,717,838.08 3% 1. General 24,393,035.39 Certificate of Deposits 0.00 0% 6.50% Gen Revenue Replacement 28,162,220.63 FFCB 3,000,000.00 2% 10% City Capital Projects 4,805,058.33 FHLB 25,610,000.00 15% 20% Technology 539,506.67 FHLMC 1,125,000.00 1% 10% School Capital Projects 1,782,371.20 FNMA 7,200,000.00 4% 10% Regional Airport 3,862,583.54 Subtotal Agencies $36,935,000.00 Airport Projects Grant 6,317,624.53 Self Insurance 858,238.96 Treasuries 15,850,000.00 9% 10% Internal Services 6,807,818.63 Commercial Paper 9,125,000.00 5% 6.50% Special Welfare 124,575.30 Bonds 13,845,000.00 8% 6.50% 2. Water Operating 1,629,633.70 INVESTED WILMINGTON TRUST $75,755,000.00 Water Capital 3,178,487.03 3. Sewer Operating 3,458,687.19 INVESTED LGIP $93,193,023.12 53% 20% Sewer Capital 3,829,974.22 100% 100% 4. Stormwater Operating 909,672.01 TOTAL INVESTED $174,665,861.20 Stormwater Capital Projects 1,187,000.00 (Includes Money Mkt & LGIP Funds) 5. PFC Fund 32,630.21 6. Airport State Entitlements 1,313,905.58 BANK DISTRIBUTION TOTAL LGIP $93,193,023.12 Baird & Company 8,100,000.00 11% Raymond James 38,720,000.00 51% Truist Securities 13,475,000.00 18% Wells Fargo Securities 15,460,000.00 20% INVESTED WILMINGTON TRUST $75,755,000.00 100% Wilmington (Money Market) $5,717,838.08 TOTAL INVESTED WILMINGTON $81,472,838.08 FINANCE COMMITTEE AGENDA ITEM #: 7 Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual General Fund $60,000 $178,267 $100,000 $308,785 $125,000 $675,049 $584,616 $661,746 $572,499 $252,421 $52,038 $286,676 General Fund ‐ City Capital Projects 30,000           69,734           50,000           142,605         60,000           294,688         187,434         258,592         150,000         124,934         13,833           97,789           General Fund ‐ OPEB Reserve 4,000             6,330             4,000             28,753           5,000             24,215           70,576           88,701           20,000           5,353             ‐                   5,339             General Fund ‐ Health Insurance Reserve 10,000           17,498           15,000           2,172             15,000           17,918           18,069           25,979           17,000           20,896           ‐                   12,654           School Capital Projects ‐                   46,167           ‐                   15,261           15,261           31,810           31,810           46,693           ‐                   30,725           30,725           2,919             Water Fund 17,632           87,079           31,250           180,973         40,000           278,432         200,000         283,511         151,100         65,421           28,000           43,934           Sewer fund 11,000           94,543           26,000           186,826         50,000           355,614         170,000         303,752         32,000           48,216           11,370           206,738         Stormwater Fund ‐                   9,477             700                  31,120           8,500             51,662           14,500           36,700           28,400           5,138             5,500             5,043             Total  $132,632 $509,095 $226,950 $896,495 $318,761 $1,729,388 $1,277,005 $1,705,674 $970,999 $553,104 $141,466 $661,092 Interest Income Analysis FY 2017 to FY 2022 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FINANCE COMMITTEE AGENDA ITEM #: 7 FINANCE COMMITTEE Agenda Item Summary MEETING DATE: February 28, 2023 AGENDA ITEM #: 8 CONSENT: REGULAR: X WORK SESSION: CLOSED SESSION: ACTION: INFORMATION: X (Confidential) ITEM TITLE: Revenue Update RECOMMENDATION: Review the collections received from five of the City’s revenue sources. SUMMARY: Five of the City’s major revenue sources are taxes collected on a monthly basis: Local Sales and Use Tax, Consumer Utility Tax – Electric, Meals Tax, Lodging Tax, and Amusement Tax. Since the last Finance Committee meeting, revenue information through December 2022 has been posted for these five revenue streams. PRIOR ACTION(S): This information is provided monthly to the Finance Committee. FISCAL IMPACT: None CONTACT(S): Donna Witt, Chief Financial Officer, 455-3968 ATTACHMENT(S): Comparison of Collections Budget to Actual FY 2023 REVIEWED BY: Comparison of Collections Budget to Actual Fiscal Year 2023 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted FY 2023 Actual FY 2023 Actual FY 2023 to Adopted FY 2023 Actual FY 2023 to Actual FY 2022 JULY $1,306,001 $1,503,837 $1,595,392 $1,537,816 $1,752,857 $215,041 $157,465 AUGUST 1,400,949 1,396,989 1,567,107 1,510,552 1,734,950 224,398 167,843 SEPTEMBER 1,423,548 1,531,422 1,702,723 1,641,274 1,910,727 269,453 208,004 OCTOBER 1,418,032 1,498,945 1,727,124 1,664,794 1,826,541 161,747 99,417 NOVEMBER 1,413,245 1,516,545 1,705,132 1,643,596 1,755,273 111,677 50,141 DECEMBER 1,706,366 1,908,243 2,128,639 2,051,819 2,339,927 288,108 211,288 JANUARY 1,277,127 1,321,858 1,623,094 1,564,518 0 (1,564,518) (1,623,094) FEBRUARY 1,233,105 1,283,097 1,496,509 1,442,502 0 (1,442,502) (1,496,509) MARCH 1,295,372 1,808,603 1,942,133 1,872,044 0 (1,872,044) (1,942,133) APRIL 1,266,401 1,666,552 1,828,313 1,762,331 0 (1,762,331) (1,828,313) MAY 1,327,343 1,640,802 1,715,663 1,653,746 0 (1,653,746) (1,715,663) JUNE 1,485,941 1,541,453 1,716,972 1,655,008 0 (1,655,008) (1,716,972) TOTAL $16,553,430 $18,618,346 $20,748,801 $20,000,000 $11,320,275 ($8,679,725) ($9,428,526) CONSUMER UTILITY TAX - ELECTRIC JULY $323,666 $329,721 $320,905 $304,203 $323,533 $19,330 $2,628 AUGUST 335,376 331,969 340,374 322,659 326,174 3,515 (14,200) SEPTEMBER 322,201 313,877 321,494 304,762 316,174 11,412 (5,320) OCTOBER 294,402 260,312 285,740 270,869 264,598 (6,271) (21,142) NOVEMBER 269,899 248,561 265,895 252,057 248,183 (3,874) (17,712) DECEMBER 329,023 309,832 331,167 313,932 339,268 25,336 8,101 JANUARY 335,735 362,641 336,155 318,660 0 (318,660) (336,155) FEBRUARY 308,797 354,521 361,163 342,367 0 (342,367) (361,163) MARCH 299,490 317,734 296,578 281,143 0 (281,143) (296,578) APRIL 252,299 274,591 270,831 256,736 0 (256,736) (270,831) MAY 242,573 263,295 269,733 255,695 0 (255,695) (269,733) JUNE 277,880 283,774 292,120 276,917 0 (276,917) (292,120) TOTAL $3,591,341 $3,650,828 $3,692,155 $3,500,000 $1,817,930 ($1,682,070) ($1,874,225) ADOPTED FY 2023 BUDGET - $20,000,000 ADOPTED FY 2023 BUDGET - $3,500,000 SALES & USE TAX Prepared for Finance Committee Meeting: February 2023 Actual Collected FY 2020 2 Actual Collected FY 2021 2 Actual Collected FY 2022 2 Adopted FY 2023 Actual Assessed FY 2023 Actual Assessed FY 2023 to Adopted FY 2023 Actual Collected FY 2023 2 Actual Collected FY 2023 to Adopted FY 2023 Actual Collected FY 2023 to Collected FY 2022 MEALS TAX JULY 1 $1,167,412 $1,090,332 $1,381,484 $1,385,259 $1,506,198 $120,939 $1,450,812 $65,553 $69,328 AUGUST 1,327,301 1,186,360 1,506,141 1,458,658 1,592,183 133,525 1,608,171 149,513 102,030 SEPTEMBER 1,348,242 1,203,439 1,457,339 1,446,836 1,650,857 204,021 1,636,715 189,879 179,376 OCTOBER 1,327,690 1,283,797 1,537,383 1,540,363 1,738,510 198,147 1,677,356 136,993 139,973 NOVEMBER 1,270,798 1,109,005 1,452,953 1,429,830 1,580,640 150,810 1,531,231 101,401 78,278 DECEMBER 1,303,873 1,124,410 1,560,912 1,504,916 1,680,479 175,563 1,727,245 222,329 166,333 JANUARY 1,229,966 1,044,041 1,277,126 1,255,364 (1,255,364) 0 (1,255,364) (1,277,126) FEBRUARY 1,097,969 1,242,188 1,494,478 1,448,035 (1,448,035) 0 (1,448,035) (1,494,478) MARCH 935,569 1,527,017 1,608,939 1,593,780 (1,593,780) 0 (1,593,780) (1,608,939) APRIL 802,509 1,386,990 1,603,883 1,606,915 (1,606,915) 0 (1,606,915) (1,603,883) MAY 1 883,043 1,527,359 1,664,649 1,587,822 (1,587,822) 0 (1,587,822) (1,664,649) JUNE 1 1,013,966 1,339,741 1,461,572 1,442,222 (1,442,222) 0 (1,442,222) (1,461,572) TOTAL $13,708,338 $15,064,679 $18,006,859 $17,700,000 $9,748,867 ($7,951,133) $9,631,530 ($8,068,470) ($8,375,329) LODGING TAX JULY 1 $235,865 $155,637 $242,273 $236,852 $268,176 $31,324 $268,473 $31,621 $26,200 AUGUST 359,491 213,511 333,446 331,082 335,636 4,554 335,707 4,625 2,261 SEPTEMBER 257,054 257,411 263,845 258,216 300,271 42,055 301,809 43,593 37,964 OCTOBER 295,030 226,390 317,407 325,356 386,807 61,451 384,448 59,092 67,041 NOVEMBER 221,028 160,421 194,097 217,095 266,770 49,675 241,126 24,031 47,029 DECEMBER 144,469 112,888 193,575 175,204 216,620 41,416 251,366 76,162 57,791 JANUARY 203,671 108,941 173,332 179,315 0 (179,315) 0 (179,315) (173,332) FEBRUARY 174,980 199,008 276,290 241,772 0 (241,772) 0 (241,772) (276,290) MARCH 170,886 190,764 233,321 232,455 0 (232,455) 0 (232,455) (233,321) APRIL 60,603 222,417 242,337 248,479 0 (248,479) 0 (248,479) (242,337) MAY 1 97,386 260,290 370,919 307,526 0 (307,526) 0 (307,526) (370,919) JUNE 1 125,893 223,035 255,990 246,648 0 (246,648) 0 (246,648) (255,990) TOTAL $2,346,356 $2,330,713 $3,096,832 $3,000,000 $1,774,280 ($1,225,720) $1,782,929 ($1,217,071) ($1,313,903) AMUSEMENT TAX JULY 1 $90,398 $13,970 $59,351 $56,206 $91,435 $35,229 $46,938 ($9,268) ($12,413) AUGUST 56,722 19,248 55,160 51,155 57,744 6,589 97,916 46,761 42,756 SEPTEMBER 62,500 19,538 45,639 43,208 64,223 21,015 60,593 17,385 14,954 OCTOBER 69,849 18,752 55,688 53,412 71,724 18,312 70,382 16,970 14,694 NOVEMBER 78,870 17,830 54,292 50,813 63,558 12,745 64,081 13,268 9,789 DECEMBER 87,576 15,570 91,535 86,936 86,379 (557) 84,585 (2,351) (6,950) JANUARY 76,124 19,575 46,525 44,043 0 (44,043) 0 (44,043) (46,525) FEBRUARY 61,618 27,526 59,372 56,178 0 (56,178) 0 (56,178) (59,372) MARCH 32,690 32,509 74,242 71,501 0 (71,501) 0 (71,501) (74,242) APRIL 1,332 38,973 72,760 72,064 0 (72,064) 0 (72,064) (72,760) MAY 1 979 34,658 70,409 65,790 0 (65,790) 0 (65,790) (70,409) JUNE 1 5,772 44,000 71,626 68,695 0 (68,695) 0 (68,695) (71,626) TOTAL $624,430 $302,149 $756,599 $720,000 $435,063 ($284,937) $424,495 ($295,505) ($332,104) ADOPTED FY 2023 BUDGET - $17,700,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 2023 BUDGET - $3,000,000 ADOPTED FY 2023 BUDGET - $720,000

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