Town of Yountville
Staff Report
6550 Yount Street
Yountville, CA 94599
Agenda Item #: {{section.number}}A
Yountville Town Council Staff Report
DATE: January 16, 2024
TO: Mayor and Town Council
FROM: Celia King, Administrative Services Director
PREPARED BY: Kyle Batista, Financial Analyst
RECOMMENDATION:
Receive and File November 2023 Monthly Financial Report
DISCUSSION/BACKGROUND
The monthly financial reports are presented to provide a summary overview of revenues and expenses of the Town’s major funds: General Fund, Capital Projects Fund, Water and Wastewater Enterprise Funds.
See below for the November 2023 financial report.
November 2023 – 41.7% of the Fiscal Year
TOT collections included in the November 2023 monthly financial report are applicable to July through October 2023 TOT, covering 33.3% of the fiscal year.
Sales tax receipts lag 2½ - 3 months behind the actual collection period. Reported sales tax amounts are applicable to July and September sales tax revenues, or 25% of the fiscal year.
Larger allocations of property taxes are generally not received until November or December, after the first installment has been collected by Napa County.
Interest Income for the first quarter of Fiscal Year 2023/24 was higher than expected as reflected in the General Fund Investment Earnings amount and the Water and Wastewater Funds Interest Income accounts.
General Fund department expenditures are on track with budget expectations. Any departments that appear to be higher than the percent of budget to date are because of payments that are due at the beginning of the fiscal year, such as a portion of the Chamber of Commerce contract, premiums for Liability and Worker’s Compensation Insurance, and expenditures related to the Parks & Recreation Summer Camp Program. These expenditure accounts are leveling out as expected.
Water and Wastewater Enterprise Funds revenues and expenditures are on track with expected amounts.
The expected $2,000,000 Federal Grant revenue budgeted in Fund 63 Wastewater Capital Joint Treatment Capital Fund is applicable to the USDA low interest loan that the Town is pursuing for the Joint Treatment Plant Modifications project. The expected $1,000,000 Miscellaneous Revenue budgeted in the same fund is applicable to the $1,000,000 Emergency Recycled Water Transmission Main Repair Project that the Town is anticipating to be covered by Town property damage insurance.
ENVIRONMENTAL REVIEW
Exempt per California Environmental Act (CEQA) Guideline, Section 15061(b)(3)
FISCAL IMPACT
Is there a Fiscal Impact? Yes
Is it Currently Budgeted? Yes
Where is it Budgeted? Various Departments
Is it Mandatory or Discretionary? Discretionary
Is there a Staff Resource Impact? Nominal
STRATEGIC PLAN GOAL
Is item Identified in Strategic Plan? Yes
If yes, Identify Strategic Goal and Objective. Responsible Fiscal Policy: The Town maintains its fiscal health through policies designed to maximize economic opportunities, manage expenses, and ensure prudent reserves.
Briefly Explain Relationship to Strategic Plan Goal and Objective. Monthly budget and actual revenue and expense reports provide timely information and financial transparency. Timely financial information can help control costs by guiding policy and spending decisions.
TOWN OF YOUNTVILLE
MONTHLY FINANCIAL REPORT
November 30, 2023
General Fund Revenues
The following is a summary of General Fund revenue by major category as of November 30, 2023.
November is 41.7% of the Fiscal Year:
Revenues: Budget* Actual Variance % of Budget Note
Property Taxes 2,431,280 44,061 (2,387,219) 1.8% Note 1 Sales Taxes 1,695,000 460,743 (1,234,257) 27.2% Note 2
Other Taxes 164,000 17,989 (146,011) 11.0%
Transient Occupancy Tax 7,775,000 3,849,148 (3,925,852) 49.5% Note 3 Investment Earnings 45,000 42,155 (2,845) 93.7%
Licenses & Permits 155,250 77,659 (77,591) 50.0%
Fines & Forfeitures 4,000 6,485 2,485 162.1%
Rents & Concessions 350,197 194,998 (155,199) 55.7%
Intergovernmental 205,000 111,760 (93,240) 54.5%
Parks & Recreation Fees 322,550 133,924 (188,626) 41.5% Charges for Services 184,600 55,343 (129,257) 30.0%
Impact Fees - - - 0.0%
Miscellaneous 123,445 65,156 (58,289) 52.8%
Other Sources - - - 0.0%
Total 13,455,322 5,059,420 (8,395,902) 37.6%
Transfers: Budget Actual Variance % of Budget Note
Tourist Imp. Dist. (Fund 22) 12,958 6,527 (6,431) 50.4% Total 12,958 6,527 (6,431) 50.4%
Note 1: Property taxes are generally not received until December, after the first installment has been collected by Napa County.
Note 2: Sales tax receipts lag 2½ - 3months behind the actual collection period.
Note 3: TOT is due one month after the collection period and received within 30 days after the collection period.
TOWN OF YOUNTVILLE
MONTHLY FINANCIAL REPORT
November 30, 2023
General Fund Expenditures
The following is a summary of General Fund Expenditures by major category as of November 30, 2023:
November is 41.7% of the Fiscal Year:
Expenditures Budget* Actual Variance % of Budget
Town Council/Mayor 1001 226,858 47,863 (178,994) 21.1%
Non-Departmental 1010 209,200 61,619 (147,581) 29.5%
Town Manager 1101 632,326 239,950 (392,376) 37.9%
Information Technology 1011 - - - 0.0% Note 1
Community Promotion 1015 473,775 194,208 (279,567) 41.0% Finance 1102 815,265 290,492 (524,772) 35.6%
Risk Management 1103 71,150 17,806 (53,344) 25.0%
Town Attorney 1105 226,000 83,970 (142,030) 37.2%
Town Clerk 1110 607,923 193,771 (414,153) 31.9%
Planning & Building 2115 1,305,804 488,379 (817,425) 37.4% Law Enforcement Services 3200 1,271,620 635,556 (636,064) 50.0% Fire & Emergency Services 3201 1,148,000 - (1,148,000) 0.0% Note 2 PW Admin. & Engineering 4301 887,084 330,915 (556,168) 37.3% PW Street Maintenance 4305 459,551 150,003 (309,547) 32.6% PW Park Maintenance 4320 730,015 289,314 (440,701) 39.6% PW Government Bldgs. 4325 607,829 282,689 (325,140) 46.5% Parks & Rec Admin & Services 5405 555,975 219,422 (336,553) 39.5% Parks & Rec Camp Programs 5406 215,453 124,132 (91,321) 57.6% Community Center 5408 361,101 131,308 (229,793) 36.4%
Parks & Rec Leisure Prog. 5410 345,546 129,117 (216,429) 37.4% Parks & Rec Sports Prog. 5412 59,901 27,917 (31,984) 46.6% Parks & Rec Community Events 5413 206,964 99,713 (107,251) 48.2% Yountville Arts 5415 114,574 27,595 (86,979) 24.1%
Total Expenditures 11,531,913 4,065,740 (7,466,172) 35.3% Transfers Out:
Capital Projects Fund 7950 550,000 550,000 - 100.0%
Facility Replacement Fund 7981 350,000 350,000 - 100.0% Fleet/Equip Replacement Fund 7982 200,000 200,000 - 100.0% Housing Opportunity Fund 7970 73,700 - 73,700 0.0%
Water Subsidy 7961 6,000 - 6,000 0.0%
Wastewater Subsidy 7962 6,000 - 6,000 0.0%
2017 Lease Rev. Debt Service 7954 545,000 545,000 - 100.0% 2020 Lease Fin. Debt Service 7955 20,000 20,000 - 100.0% Total Transfers Out: 1,750,700 1,665,000 85,700 95.1%
Note 1: Allocations of information technology are made to each department so no expenses are shown for program.
Note 2: Payments for Fire & Emergency Services are typically made bi-annually, in January and June. * Budget includes amounts for prior year purchase order rollover and reflects all Fiscal Year 2023/2024 budget adjustments
TOWN OF YOUNTVILLE
MONTHLY FINANCIAL REPORT
November 30, 2023
CAPITAL PROJECTS
Expenditures Budget * Actual Variance % of Budget
Shade Structure for Community Center/Hall CF-0022 150,000 - (150,000) 0.0% Enclose BBQ Area for Storage** CF-0024 - - - 0.0%
Exterior Painting of Town Hall CF-0032 55,000 - (55,000) 0.0% Community Center/Hall HVAC Analysis CF-0033 100,000 - (100,000) 0.0% Replace Community Center/Hall & Post Office Gutters CF-0035 50,000 - (50,000) 0.0% Emergency Geothermal HVAC Repair & Replacement CF-0036 19,753 - (19,753) 0.0% Roof Repair Community Park Restroom CF-0037 55,000 - (55,000) 0.0% Sheriff Office Interior Maintenance & Repairs CF-0038 50,000 - (50,000) 0.0% Town Hall Landscaping and Access CF-0043 75,000 - (75,000) 0.0% Bus Shelter Repair CF-0044 45,000 - (45,000) 0.0%
GIS Mapping Improvements CP-0007 160,000 5,929 (154,071) 3.7% ADA Accessibility Improvements: Forrester Park/Three Weirs Park CP-0018 121,720 5,493 (116,227) 4.5% Community Center Restrooms Concrete Counter Replacement CP-0023 30,000 - (30,000) 0.0% Installation of EV Charging Stations and Fleet CP-0028 200,000 52,960 (147,040) 26.5% LATA Broadband Development Feasibility Study CP-0029 102,600 2,037 (100,563) 2.0% ADA Accessibility Improvements Program CP-2024 122,000 1,383 (120,617) 1.1% Hydroflush Weirsfrom Finnell to Beard Ditch DF-0018 100,000 - (100,000) 0.0% Repair Fence at Pump Station DF-0019 55,000 - (55,000) 0.0% Town Wide Drainage and Erosion Program DF-2024 20,500 - (20,500) 0.0% Paving Projects- Plan, Specs, and Engineering GT-3024 136,828 25,314 (111,514) 18.5% Annual Street Maintenance & Paving Program MT-3024 534,990 226,530 (308,460) 42.3% Replace 2003 Chevrolet 2500HD PK-0028 60,000 - (60,000) 0.0% Replace 2013 Chevrolet 2500HD PK-0029 60,000 - (60,000) 0.0% Pump House Rebuild Van De Leur PK-0030 100,000 - (100,000) 0.0% Vineyard Park Enhancement Project PK-0032 450,000 - (450,000) 0.0% Shade Structure at North Park PK-0033 150,000 - (150,000) 0.0% Replace Tot Lot Play Surface PK-0035 10,000 - (10,000) 0.0% Replace Play Surface at Yountville Community Park PK-0037 120,000 - (120,000) 0.0% Waxie Compacting Trash Receptacles PK-0038 108,580 108,234 (346) 99.7% Curb, Gutter, and Sidewalk Replacement SB-6024 79,600 29,490 (50,110) 37.0% Surveys and Monuments ST-0004 18,500 7,655 (10,845) 41.4% Replacement Muni Ops Truck ST-0025 70,000 600 (69,400) 0.9% Washington Street Parking Lot Beautification ST-0027 300,000 - (300,000) 0.0% Utility Undergrounding Engineering & Design ST-0029 200,000 - (200,000) 0.0% Traffic Calming Program ST-4024 18,500 - (18,500) 0.0%
Total 3,928,570 465,625 (3,462,946) 11.9%
Expenditures- Water & Wastewater Budget * Actual Variance % of Budget Upgrade Well SCADA System WA-0018 110,543 19,830 (90,714) 17.9% Water System Inter Tie Projects WA-0020 65,000 - (65,000) 0.0% Clay Valve Rebuild at Finnell Rd & Yount / Finnell Rd & Yville XRd WA-0022 8,000 - (8,000) 0.0% Water Meter Replacement Program WA-2024 30,500 - (30,500) 0.0% Hydrant Repair Replacement WA-5024 35,000 - (35,000) 0.0% WWRF Office Modernization WW-0011 2,008,902 13,526 (1,995,376) 0.7% Rebuild Sludge Heater & Add Sludge Mixing System WW-0019 250,000 - (250,000) 0.0% Design & Construct HeadworksImprovements WW-0027 40,000 - (40,000) 0.0% Safety Net and Safety Hinged Doors at Hand Well Access WW-0032 10,000 4,212 (5,788) 42.1% Pump Station Assessment and Capacity Evaluation WW-0033 40,000 - (40,000) 0.0% WWRF Component Assessment & Repair Plan WW-0034 500,000 - (500,000) 0.0% Headworks Grit Screw Chamber Improvement WW-0037 25,000 - (25,000) 0.0% Pond Site Fencing, Grading & Drainage Improvements WW-0038 50,000 - (50,000) 0.0% Compliance Analyzersfor SCADA System WW-0039 20,000 9,900 (10,100) 49.5% Consultant to Assess Cost, Years, & Design for WWRF Projects WW-0040 150,000 - (150,000) 0.0% New Vactor Truck WW-0041 400,000 - (400,000) 0.0%
Recycled Water Transmission Main Repair WW-0042 944,892 9,222 (935,670) 1.0% Flare System Installation WW-0043 100,000 - (100,000) 0.0% Asset Management System WW-0044 45,000 - (45,000) 0.0%
Inflow & Infiltration Reduction Program WW-2024 436,266 - (436,266) 0.0% Sewer Main Replacement and Repair Program WW-3024 93,000 - (93,000) 0.0% Plant Equipment Replacement Program WW-4024 138,029 65,208 (72,821) 47.2% Town Pump Station Equipment Replacement Program WW-5024 18,385 3,885 (14,500) 21.1% SCADA Controls WW-6024 15,000 - (15,000) 0.0%
Total 5,533,517 125,781 (5,407,736) 2.3%
* Budget includes amountsfor prior year purchase order rollover and reflects all Fiscal Year 2023/2024 budget adjustments. ** $45,000 budget for CF-0024 Enclose BBQ Area for Storage project wastransferred to new CF-0044 Bus Shelter Repair project.
TOWN OF YOUNTVILLE
MONTHLY FINANCIAL REPORT
November 30, 2023
WATER CAPITAL IMPROVEMENT FUND (60) Budget Actual Variance % of Budget Revenues - System Replacement Fees 147,600 59,424 (88,176) 40.3% Impact Fees - - - 0.0%
Interest Income 4,500 3,916 (584) 87.0%
Transfers from General Fund (01) - - - 0.0%
Transfers from Wtr Op Fund (61) - - - 0.0%
Total Revenues 152,100 63,341 (88,760) 41.6%
Capital Improvement (60-4500) 344,043 19,830 (324,214) 5.8% Total Expenses 344,043 19,830 (324,214) 5.8%
Net Operating Income/(Loss) (191,943) 43,511 235,454
WATER OPERATING ENTERPRISE FUND (61) Budget Actual Variance % of Budget Revenues - Utilities 1,667,000 799,098 (867,903) 47.9%
Interest Income 3,500 3,765 265 107.6%
Transfer-Water Subsidy (01) 6,000 - (6,000) 0.0%
Total Revenues 1,676,500 802,862 (873,638) 47.9%
O & M Expenses (61-4505) 774,932 266,195 (508,737) 34.4% Water Purchases (61-4507) 1,063,296 427,458 (635,838) 40.2% Total Expenses 1,838,228 693,653 (1,144,575) 37.7%
Net Operating Income/(Loss) (161,728) 109,209 270,937
WASTEWATER OPERATING ENTERPRISE FUND (62) Budget Actual Variance % of Budget Revenues - Utilities 2,531,000 1,218,149 (1,312,851) 48.1% Interest Income 7,500 5,986 (1,514) 79.8%
Transfer-Wastewater Subsidy (01) 6,000 - (6,000) 0.0%
Total Revenues 2,544,500 1,224,135 (1,320,366) 48.1%
-
WW Collection (62-4510) 512,580 177,949 (334,631) 34.7% WW Treatment (62-4515) 1,702,024 598,792 (1,103,232) 35.2% Transfer to Capital (63/64) 500,000 - (500,000) 0.0%
Total Expenses 2,714,604 776,741 (1,937,863) 28.6%
Net Operating Income/(Loss) (170,104) 447,393 617,497
JOINT TREATMENT CAPITAL FUND (63) Budget Actual Variance % of Budget Federal Grant 2,000,000 - (2,000,000) 0.0%
Miscellaneous Revenue 1,000,000 250,000 (750,000) 25.0% System Replacement Fees 240,000 98,923 (141,077) 41.2%
Revenues Capital Recovery Vets 50,000 50,000 - 100.0%
Interest Income 25,000 31,454 6,454 125.8%
Transfer from Wastewater Operating (62) 50,000 (50,000) 0.0% Total Revenues 3,365,000 430,378 (2,934,622) 12.8%
WW Joint Treatment Plant (63-4518) 4,716,484 262,516 (4,453,968) 5.6% Total Expenses 4,716,484 262,516 (4,453,968) 5.6%
Net Operating Income/(Loss) (1,351,484) 167,861 1,519,346 WASTEWATER UTILITY CAPITAL FUND (64) Budget Actual Variance % of Budget Transfer from WW Operating (62) 450,000 - (450,000) 0.0% Impact Fees - - - 0.0%
Interest Income 6,000 4,269 (1,731) 71.2%
Total Revenues 456,000 4,269 (451,731) 0.9%
-
WW Capital Improvement (64-4519) 1,069,651 8,096 (1,061,554) 0.8% Transfer to Debt Service (55) 30,043 30,043 - 100.0%
Total Expenses 1,099,694 38,139 (1,061,554) 3.5%
Net Operating Income/(Loss) (643,694) (33,870) 609,824