WWTP sludge removal events (ES8130.43)

↑Village/Finance/Sewer spending/wwtp-sludge

Per-event log from the QuickBooks WWTP Sludge Removal account. Each row is a hauler bill — the memo field is the operator's description of what got pumped and why. Volume parsing is shown next to each row so you can see when gallons came directly from the memo vs. were inferred by dividing $ by the vendor-specific rate cluster (see card below).

Transactions

34 memo + 3 rate-divided (13 QB artifacts dropped)

Total gallons

258,050

vs budgeted 104,000/year

Total $ billed

$66,907

vs annual budget $20,176

Budget rate $194/kgal is 10% below Superior's actual routine rate of $213.40/kgal.

The FY 2025-26 sewer budget for ES8130.43 is built on an assumed routine sludge-haul rate of $194/kgal — the figure cited in Trustee Uku's budget memo. The rate clustering below shows Superior Sanitation's actual routine rate across 30 ground-truth invoices is $213.40/kgal (10% higher). At the budgeted volume of 104,000 gal/year, the rate gap alone adds $2,018 to the annual cost — independent of any volume overrun. The volume side is a separate, larger issue: FY-to-date pumped volume is well above the 104,000 gal/year budget line.

2 consecutive mayor reports with no sewer content (2025-12 → 2026-01).

The mayor's monthly reports to the Board of Trustees normally describe sewer-plant activity, vendor work, and capital projects. Across 2 consecutive months covered (2025-12 through 2026-01), the mayor's report contains zero references to sewer / wwtp / sludge / Superior Sanitation / outfall / I&I — even though that window includes the largest spike in emergency sludge-removal invoices in the FY 2025-26 dataset. The reports may discuss these matters in committee or executive session, but they are not appearing in the public reports trustees rely on for budget oversight.

Reports in the silence window

2025-12 — Mayor's Report — December 2026 (dc_2372_mayor_report_january_12_2026)
2026-01 — Mayor's Report — January 2026 (dc_2466_mayor_report_february_9_2026)

DEC volume anchor unavailable.

QB is currently the only source of monthly sludge-haul volume. The DEC monthly DMR has a “Sludge removal from plant” section with fields for gallons, solid content, and volatile solids — but on every DMR spot-checked (Aug 2024, Aug 2025, Oct 2025, Nov 2025) those fields are blank, even when the disposal-site field is filled in with “Superior Sanitation.” The October 2025 DMR even shows a yellow-highlighted #REF! error in the amount cell. Without the DMR figure we cannot independently verify QB volumes; the rate-divide rows in particular are unverified. Hauler manifests from Superior Sanitation would close this gap.

Vendor rate clusters

Per-vendor $/kgal rate clusters derived from invoices where the memo states both gallons and amount and the two are mutually consistent (within 10%). Two clusters per vendor when the data supports it: a routine rate and an emergency-premium rate. Rate-divided rows in the table below use the nearest cluster for their vendor + event type rather than the global $194/kgal default.

Vendor	Routine $/kgal	Emergency $/kgal	Samples	Notes
ProSeptic LLC	$290.00	$321.67	4
Superior Sanitation Services Inc	$213.40	$323.39	30

Note on the budget rate.Trustee Uku's memo (and the FY 2025-26 budget) cites $194/ kgal as the routine sludge-haul rate. The data shows Superior Sanitation's actual routine rate is materially higher — $213/kgal — meaning the budget assumption understates the cost of even the routine baseline. ProSeptic LLC is a second hauler that has been billing this account but was not previously surfaced in our analysis.

Burn-up: cumulative against FY budget

Two cumulative panels with a fitted regression line. The slope (annualized in the legend) is the empirical burn rate — what we'd need to hold for the budget to balance is <100%. Where the regression crosses the budget reference line is the projected exhaustion date. Volume cumulates by event date (LLM-attributed for 14 of 38 rows; invoice date for the rest), cost cumulates by invoice date.

Cumulative gallons hauled (by event date)

Cumulative $ billed (by invoice date)

Burn rate over time (derivative of the burn-up)

Time-varying monthly burn rate, derived as the slope of the cumulative over a 30-day rolling window (light line) plus a 90-day exponentially-weighted moving average (dark line). The dashed reference is the monthly budget. When the dark trend line sits above the budget line, FY-end exhaustion is the trajectory; when below, the budget is on track.

Monthly-equivalent volume rate (gal/mo)

Monthly-equivalent cost rate ($/mo)

2025-06 1 event · 4,980 gal · $1,610

Date	Invoice	Memo type	LLM classification	Memo	Gallons	Volume source	$ amount
Jun 26, 2025	Invoice 75701	emergency	—	6/26 emergency septic & holding tank pump	4,980 gal	÷ vendor cluster rate	$1,610

2025-07 4 events · 32,000 gal · $7,269

Date	Invoice	Memo type	LLM classification	Memo	Gallons	Volume source	$ amount
Jul 2, 2025	Invoice 75203	emergency	—	7/2/25 emergency sewer plant pump - 4000 gallons	4,000 gal	from memo	$1,294
Jul 8, 2025	Invoice 32585	routine	—	WWTP sludge removal - 6,000 gal	6,000 gal	from memo	$1,280
Jul 9, 2025	Invoice 75718	routine	—	7/9 & 7/10/25 sewer plant pump - 16,000 gallons	16,000 gal	from memo	$3,414
Jul 28, 2025	32732	routine	—	7/25/25 sewer plant pump - 6,000 gallons	6,000 gal	from memo	$1,280

2025-08 4 events · 17,000 gal · $4,626

Date	Invoice	Memo type	LLM classification	Memo	Gallons	Volume source	$ amount
Aug 11, 2025	Invoice 32783	routine	—	8/6/25 sewer plant pump - 4,000 gallons	4,000 gal	from memo	$854
Aug 18, 2025	24040177	emergency	—	emergency pump - 5,000 gallons	5,000 gal	from memo	$1,625
Aug 20, 2025	75704	emergency	—	emergency pump sewer plant - 4,000 gallons	4,000 gal	from memo	$1,294
Aug 28, 2025	75813	unknown	—	sludge tank - 4,000 gallons	4,000 gal	from memo	$854

2025-09 3 events · 15,000 gal · $3,201

Date	Invoice	Memo type	LLM classification	Memo	Gallons	Volume source	$ amount
Sep 4, 2025	32883	unknown	—	sludge tank - 4,000 gallons carryover	4,000 gal	rate_divide_carryover	$854
Sep 19, 2025	33030	emergency	—	old sewer plant septic pump - 7,000 gallons	7,000 gal	from memo	$1,494
Sep 19, 2025	76186	emergency	—	old sewer plant septic pump - 4,000 gallons	4,000 gal	from memo	$854

2025-10 2 events · 18,000 gal · $4,399

Date	Invoice	Memo type	LLM classification	Memo	Gallons	Volume source	$ amount
Oct 15, 2025	24648011	emergency	—	10/15/25 emergency pump - 5,000 gallons	5,000 gal	from memo	$1,625
Oct 15, 2025	33079	emergency	—	10/15 & 10/16 old sewer plant septic pump - 13,000 gallons	13,000 gal	from memo	$2,774

2025-11 2 events · 25,000 gal · $6,654

Date	Invoice	Memo type	LLM classification	Memo	Gallons	Volume source	$ amount
Nov 21, 2025	33095	emergency	—	10/20/25 emergency sewer plant pump - 12,000 gallons stale date	12,000 gal	from memo	$3,880
Nov 21, 2025	33180	unknown	—	11/7/25 pump sewer plant - 13,000 gallons	13,000 gal	from memo	$2,774

2025-12 4 events · 33,000 gal · $10,005

Date	Invoice	Memo type	LLM classification	Memo	Gallons	Volume source	$ amount
Dec 4, 2025	33300	emergency	—	emergency pump sewer plant - 5,000 gallons	5,000 gal	from memo	$1,617
Dec 10, 2025	33335	unknown	—	pump sewer plant - 5,000 gallons	5,000 gal	from memo	$1,067
Dec 12, 2025	26210672	emergency	—	emergency pump - 14,000 gallons -12/12/25	14,000 gal	from memo	$4,410
Dec 12, 2025	33339	emergency	—	12/12 &12/13 emergency sewer plant pump - 9,000 gallons	9,000 gal	from memo	$2,911

2026-01 5 events · 27,500 gal · $7,878

Date	Invoice	Memo type	LLM classification	Memo	Gallons	Volume source	$ amount
Jan 3, 2026	26358856	emergency	—	emergency pump - 6,000 gallons -1/3/26	6,000 gal	from memo	$1,740
Jan 3, 2026	26358856	fee	—	truck fee for same day emergency	—	flat fee	$175
Jan 3, 2026	76725	emergency	—	emergency septic pump EQ 1A - 12.5 gallons	12,500 gal	from memo	$4,043
Jan 5, 2026	76833	unknown	—	pump sewer plant 1A 4.5 gallons	4,500 gal	from memo	$960
Jan 15, 2026	75502	unknown	—	WTTP pump 4.5 gal	4,500 gal	from memo	$960

2026-02 3 events · 26,500 gal · $7,415

Date	Invoice	Memo type	LLM classification	Memo	Gallons	Volume source	$ amount
Feb 5, 2026	77028	unknown	—	WTTP pump 4500 gallons	4,500 gal	from memo	$960
Feb 11, 2026	77050	unknown	—	(empty)	6,000 gal	÷ vendor rate (no memo)	$1,280
Feb 26, 2026	77084	emergency	—	Emergency WWTP Septic Pumps -1A & 1B 16,000 gallons @ $323.40/gallon	16,000 gal	from memo	$5,174

2026-03 2 events · 5,320 gal · $1,280

Date	Invoice	Memo type	LLM classification	Memo	Gallons	Volume source	$ amount
Mar 3, 2026	33636	emergency	—	Emergency Pump WWTP Septic Pumps -1A & 1B -16,000 gallons @ $323.40/gallon memo math fails	1,320 gal	÷ vendor rate (memo bad)	$427
Mar 18, 2026	77193	emergency	—	WWTP Septic Pumps -1A Pump 4,000 gallons - 3/16/26	4,000 gal	from memo	$854

2026-04 6 events · 43,500 gal · $10,383

Date	Invoice	Memo type	LLM classification	Memo	Gallons	Volume source	$ amount
Apr 3, 2026	33750	unknown	—	4/3 6.5 gal Pump 1A	6,500 gal	from memo	$1,387
Apr 7, 2026	33757	emergency	—	3/5 WWTP emergency pump 1B lift station 10,000 gallons stale date	10,000 gal	from memo	$3,234
Apr 7, 2026	33757	unknown	—	3/6 WWTP pump 1B lift station 10,000 gallons stale date	10,000 gal	from memo	$2,134
Apr 22, 2026	33843	unknown	—	WWTP pump 1A 5,500 gallons	5,500 gal	from memo	$1,174
Apr 22, 2026	33843	unknown	—	WWTP pump 1B sludge tank 5,500 gallons	5,500 gal	from memo	$1,174
Apr 22, 2026	33843	unknown	—	WWTP pump 1B aeration tank 6,000 gallons	6,000 gal	from memo	$1,280

2026-05 2 events · 10,250 gal · $2,187

Date	Invoice	Memo type	LLM classification	Memo	Gallons	Volume source	$ amount
May 6, 2026	33912	unknown	—	5/5 WWTP 1A sludge tank - 5,250 gal	5,250 gal	from memo	$1,120
May 20, 2026	33967	unknown	—	WWTP pump 1A 5,000 gallons	5,000 gal	from memo	$1,067

About the LLM-classification column.Each invoice is independently classified by an LLM with access to deterministic tools (sum/divide, DEC ops in window, mayor-report excerpts, compliance events). Every numeric claim in a justification cites a tool-call result_id; a validation pass rejects justifications whose citations don't exist in the trace. The “LLM N/M verified” badge shows pass count per month. Click a classification to see the justification + evidence chain. The arrow notation (e.g. → 2025-10) means the LLM attributed the haul to a different month than the invoice date — typically because the memo cites an explicit event date in the prior month.