Town of Yountville
Staff Report
6550 Yount Street
Yountville, CA 94599
Agenda Item #: {{section.number}}B
Yountville Town Council Staff Report
DATE: January 16, 2024
TO: Mayor and Town Council
FROM: Celia King, Finance Director
PREPARED BY: Kyle Batista, Financial Analyst
RECOMMENDATION
Receive and File December 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 December 2023 financial report.
December 2023 – 50.0% of the Fiscal Year
TOT collections included in the December 2023 monthly financial report are applicable to July through November 2023 TOT, covering 41.7% 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 October sales tax revenues, or 33.3% of the fiscal year.
The Town received its first large allocation of property taxes of $1,056,657 from the County of Napa at the beginning of January. This amount will be reflected in next month’s January financial report and will bring property tax collected to 49.3% of its budgeted amount.
Town staff performed an extensive mid-year review of General Fund expenditure and revenue budgets throughout December. As expected, most department’s individual line items are on track. There are a few line items that would benefit from budget adjustments due to either unexpected activity that occurred in the first half of the fiscal year or expected additional activity that will occur in the second half of the fiscal year.
These requested budget adjustments are discussed in the agenda item Considering Approval of Mid-Year Budget Adjustments for Fiscal Year 2023/2024 in today’s meeting.
Water and Wastewater Enterprise Funds revenues and expenditures are on track with expected amounts.
In December, Town staff processed the transfers from Fund 62 Wastewater Operating Enterprise Fund (a total of $500,000) to Fund 63 Joint Treatment Capital Fund ($50,000) and Fund 64 Wastewater Utility Capital Fund ($450,000).
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
December 31, 2023
General Fund Revenues
The following is a summary of General Fund revenue by major category as of December 31, 2023.
December is 50.0% of the Fiscal Year:
Revenues: Budget* Actual Variance % of Budget Note
Property Taxes 2,431,280 143,358 (2,287,922) 5.9% Note 1 Sales Taxes 1,695,000 568,148 (1,126,852) 33.5% Note 2
Other Taxes 164,000 21,784 (142,216) 13.3%
Transient Occupancy Tax 7,775,000 4,328,239 (3,446,761) 55.7% Note 3 Investment Earnings 45,000 43,240 (1,760) 96.1%
Licenses & Permits 155,250 85,906 (69,344) 55.3%
Fines & Forfeitures 4,000 10,198 6,198 255.0%
Rents & Concessions 350,197 229,026 (121,171) 65.4%
Intergovernmental 205,000 127,046 (77,954) 62.0%
Parks & Recreation Fees 322,550 162,566 (159,984) 50.4% Charges for Services 184,600 95,869 (88,731) 51.9%
Impact Fees - - - 0.0%
Miscellaneous 123,445 71,483 (51,962) 57.9%
Other Sources - - - 0.0%
Total 13,455,322 5,886,864 (7,568,458) 43.8%
Transfers: Budget Actual Variance % of Budget Note
Tourist Imp. Dist. (Fund 22) 12,958 7,718 (5,240) 59.6% Total 12,958 7,718 (5,240) 59.6%
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
December 31, 2023
General Fund Expenditures
The following is a summary of General Fund Expenditures by major category as of December 31, 2023:
December is 50.0% of the Fiscal Year:
Expenditures Budget* Actual Variance % of Budget Note
Town Council/Mayor 1001 226,858 57,990 (168,868) 25.6%
Non-Departmental 1010 209,200 63,721 (145,479) 30.5%
Town Manager 1101 632,326 275,363 (356,964) 43.5%
Information Technology 1011 - - - 0.0% Note 1
Community Promotion 1015 473,775 358,673 (115,102) 75.7% Finance 1102 815,265 329,672 (485,593) 40.4%
Risk Management 1103 71,150 18,859 (52,291) 26.5%
Town Attorney 1105 226,000 135,973 (90,028) 60.2%
Town Clerk 1110 607,923 233,885 (374,038) 38.5%
Planning & Building 2115 1,305,804 561,293 (744,511) 43.0% 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 381,771 (505,313) 43.0% PW Street Maintenance 4305 459,551 179,611 (279,940) 39.1% PW Park Maintenance 4320 730,015 338,534 (391,481) 46.4% PW Government Bldgs. 4325 607,829 318,950 (288,879) 52.5% Parks & Rec Admin & Services 5405 555,975 262,961 (293,014) 47.3% Parks & Rec Camp Programs 5406 215,453 138,750 (76,703) 64.4% Community Center 5408 361,101 154,011 (207,090) 42.7%
Parks & Rec Leisure Prog. 5410 345,546 156,582 (188,964) 45.3% Parks & Rec Sports Prog. 5412 59,901 31,909 (27,992) 53.3% Parks & Rec Community Events 5413 206,964 111,620 (95,345) 53.9% Yountville Arts 5415 114,574 32,894 (81,680) 28.7%
Total Expenditures 11,531,913 4,778,576 (6,753,337) 41.4% 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
December 31, 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 2,782 (72,218) 3.7% 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 119,733 (80,267) 59.9% LATA Broadband Development Feasibility Study CP-0029 102,600 2,037 (100,563) 2.0% ADA Accessibility Improvements Program CP-2024 122,000 9,423 (112,577) 7.7% 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 238,453 (296,537) 44.6% 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 79,600 - 100.0% Surveys and Monuments ST-0004 18,500 16,126 (2,374) 87.2% 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 613,724 (3,314,846) 15.6%
Expenditures- Water & Wastewater Budget * Actual Variance % of Budget Upgrade Well SCADA System WA-0018 110,543 32,729 (77,814) 29.6% 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,772 (1,995,131) 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 52,974 (891,919) 5.6% 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 65,184 (371,082) 14.9% 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 247,862 (5,285,655) 4.5%
* 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
December 31, 2023
WATER CAPITAL IMPROVEMENT FUND (60) Budget Actual Variance % of Budget Revenues - System Replacement Fees 147,600 71,311 (76,289) 48.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 75,227 (76,873) 49.5%
Capital Improvement (60-4500) 344,043 77,705 (266,338) 22.6% Total Expenses 344,043 77,705 (266,338) 22.6%
Net Operating Income/(Loss) (191,943) (2,477) 189,466
WATER OPERATING ENTERPRISE FUND (61) Budget Actual Variance % of Budget Revenues - Utilities 1,667,000 927,724 (739,276) 55.7%
Interest Income 3,500 3,765 265 107.6%
Transfer-Water Subsidy (01) 6,000 - (6,000) 0.0%
Total Revenues 1,676,500 931,489 (745,011) 55.6%
O & M Expenses (61-4505) 774,932 308,233 (466,699) 39.8% Water Purchases (61-4507) 1,063,296 456,315 (606,981) 42.9% Total Expenses 1,838,228 764,548 (1,073,680) 41.6%
Net Operating Income/(Loss) (161,728) 166,940 328,669
WASTEWATER OPERATING ENTERPRISE FUND (62) Budget Actual Variance % of Budget Revenues - Utilities 2,531,000 1,385,989 (1,145,011) 54.8% 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,391,974 (1,152,526) 54.7%
-
WW Collection (62-4510) 512,580 204,303 (308,277) 39.9% WW Treatment (62-4515) 1,702,024 709,234 (992,790) 41.7% Transfer to Capital (63/64) 500,000 500,000 - 100.0%
Total Expenses 2,714,604 1,413,537 (1,301,067) 52.1%
Net Operating Income/(Loss) (170,104) (21,563) 148,542
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 117,672 (122,328) 49.0% 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 - 100.0% Total Revenues 3,365,000 499,126 (2,865,874) 14.8%
WW Joint Treatment Plant (63-4518) 4,716,484 420,576 (4,295,909) 8.9% Total Expenses 4,716,484 420,576 (4,295,909) 8.9%
Net Operating Income/(Loss) (1,351,484) 78,551 1,430,035 WASTEWATER UTILITY CAPITAL FUND (64) Budget Actual Variance % of Budget Transfer from WW Operating (62) 450,000 450,000 - 100.0% Impact Fees - - - 0.0%
Interest Income 6,000 4,269 (1,731) 71.2%
Total Revenues 456,000 454,269 (1,731) 99.6%
-
WW Capital Improvement (64-4519) 1,069,651 109,098 (960,552) 10.2% Transfer to Debt Service (55) 30,043 30,043 - 100.0%
Total Expenses 1,099,694 139,141 (960,552) 12.7%
Net Operating Income/(Loss) (643,694) 315,128 958,822