Red Hook WatchIndependent Community Resource

← Sewer events

Repairs & Maintenance (ES8120.42)

Episodic spend on hardware, parts, and contractor labor for plant + collection-system repairs. Vendors include Williams Lumber, Harbor Freight, Plimpton & Hills, Carquest, Water Services Inc, etc. Spend is highly lumpy — December 2025 alone consumed ~150% of the entire FY 25-26 budget.

Transactions
37
FY 25-26 to date
Total $ billed
$31,234
vs annual budget $10,000 (312%)
Distinct vendors
18
top: Water Services Inc

1 transaction reclassified out of this account ($12,380 total)

These transactions hit this account in QB but don't belong analytically — typically capital-class items that should be funded from a Repair Reserve, or operational- event spend that fits a different category. They're dropped from this account's cumulative + rate; the target account picks them up.

Repair Reserve ($12,380)
  • Dec 10, 2025 · Water Services Inc · $12,380 · capital_equipment_rebuild
    New side UV units rebuild — completed 12/10/25 against quote dated 03/28/25. The 9-month quote-to-completion span and $12,380 single-invoice scale make this a capital-class equipment refurbishment that doesn't recur annually. Karen's 26-27 budget already includes ~$2,000/yr for routine UV-bulb replacement (in supplies); this rebuild is additional capital-class work that should be funded from a Repair Reserve, not the operating R&M line.

Burn-up + burn-rate vs FY budget

Cumulative $ billed (top) with a fitted regression extrapolated to projected exhaustion. Burn-rate (bottom) shows per-interval rates with area proportional to spend in each interval — a 90-day EWMA trend on top.

Cumulative $ billed (by invoice date)

Monthly-equivalent cost rate ($/mo)

2025-07 4 events · $980(1.2× budget)

LLM 4/4 verified

Four invoices dated in July 2025 [tc_20d5c3a9d8] totaling $979.83 within the month. Extended 14-day window adds three more invoices (Aug 1–12) for a total of $3,262.47 [tc_210c973737]. July had no mayor's report coverage [tc_36a20ffb75], but DEC compliance events (consent orders on 7/2 and 7/25, inspection on 7/15) [tc_864389ffc8] suggest regulatory pressure. Two invoices are clearly planned/capital (pump, storage tank); two are routine consumables with sparse memos.

  • No mayor's report for July 2025 [tc_36a20ffb75] — no budget-holder narrative context.
  • DEC consent orders (7/2, 7/25) and inspection (7/15) [tc_864389ffc8] suggest regulatory drivers for repairs.
  • Extended window includes capital-class invoice (5,000-gallon storage tank, $1,800 on 8/3) [tc_210c973737] that may belong to capital budget, not repairs/maintenance.
  • Williams Lumber invoices lack memos; dates are statement dates (6/30, 7/31), not transaction dates.
DateVendorInvoiceLLM classificationMemo$ amount
Jul 1, 2025Ferguson WaterworksInvoice 5775
planned_repair
Ferguson Waterworks invoice for 'second 115V auto sewer pump' [tc_20d5c3a9d8]. Memo explicitly describes a pump acquisition; 'second' suggests replacement or redundancy planning. Dated 2025-07-01, early in month, so attributed to July. No explicit event date in memo, but the purchase itself is the event.
evidence: tc_20d5c3a9d8
second 115V auto sewer pump$505
Jul 2, 2025Benson Steel FabricatorsInvoice 36971
planned_repair
Benson Steel Fabricators invoice for '2 pipes and 2 angles for sewer tools less credit for earlier purchase' [tc_20d5c3a9d8]. Memo indicates fabrication of sewer-system components (pipes, angles); the credit reference suggests this is part of a known project or replacement. Dated 2025-07-02, early July. No explicit event date; inferred as July based on invoice date in second half of month rule (early July → current month).
evidence: tc_20d5c3a9d8
2 pipes and 2 angles for sewer tools less credit for earlier purchase$277
Jul 10, 2025Williams Lumber6/30/25 Statement
routine 2025-06
Williams Lumber statement dated 2025-07-10 with no memo [tc_20d5c3a9d8]. Statement covers period ending 6/30/25, so the underlying purchases occurred in June. Invoice date is 7/10 (early July), but the statement date (6/30) is explicit; attributed to June. Amount $149.07 is typical consumables/hardware. Classified as routine due to lack of specific failure context and hardware-store vendor.
evidence: tc_20d5c3a9d8
(empty)$149
Jul 31, 2025Williams Lumber7/31/25 Statement
routine
Williams Lumber statement dated 2025-07-31 with no memo [tc_20d5c3a9d8]. Statement date (7/31) is explicit; attributed to July. Amount $48.86 is small consumables. Classified as routine due to lack of specific failure context and hardware-store vendor.
evidence: tc_20d5c3a9d8
(empty)$49

2025-08 6 events · $4,701(5.6× budget)

LLM 6/6 verified

Six repairs/maintenance invoices totaling $4,700.75 [tc_701dee5dce] in August 2025. Mix of routine consumables, planned equipment replacements (storage tank, pumps), and hardware supplies. One invoice carries a stale event date (January 2025) suggesting possible carryover. Mayor's report [tc_831b75475c] focuses on sewer expansion projects and SKWC testing; no emergency repairs mentioned. A DEC noncompliance report dated 2025-08-01 [tc_ea4b4cade1] provides regulatory context but does not directly explain these invoices.

  • One invoice (D&S Pump, 2025-08-31) has a stale memo event date (2025-01-02), suggesting possible misclassification or carryover from prior period.
  • Two pump invoices (Ferguson Waterworks, D&S Pump) total $1,715.54, indicating equipment replacement activity.
  • Storage tank invoice ($1,800) is near capital threshold; classified as planned_repair based on memo description but warrants review.
  • DEC noncompliance report dated 2025-08-01 may correlate with August maintenance activity, though no explicit causal link in mayor's report.
DateVendorInvoiceLLM classificationMemo$ amount
Aug 1, 2025Plimpton & Hills15179569
routine
Plimpton & Hills invoice for aluminum pipe wrenches ($173.89) [tc_701dee5dce]. Small-dollar hardware consumable with no failure context. Dated early August; no memo event date provided, so attributed to current month.
evidence: tc_701dee5dce
18" & 24" AL pipe wre$174
Aug 3, 2025Keith Bleakley5,000 gallon storage tank$1,800
Aug 12, 2025FH Stickles & Son IncInvoice 42649
routine
FH Stickles & Son Inc invoice for blend material, microfibers, and fuel ($308.75) [tc_701dee5dce]. Consumable supplies for plant operations with no failure or emergency context. Dated mid-August; no memo event date, attributed to current month.
evidence: tc_701dee5dce
4000# (67 Blend), microfibers, fuel$309
Aug 26, 2025Ferguson Waterworks #16729023
planned_repair
Ferguson Waterworks invoice for 115V 1HP sewer pump and 115V 1/2HP auto sewage pump ($1,233.54) [tc_701dee5dce]. Memo names specific pump models, indicating planned equipment replacement rather than emergency response. Dated late August; no event date in memo, attributed to current month.
evidence: tc_701dee5dce
115V 1HP Sewer Pump w/VLFS; 115v 1/2hp ci auto sew pump$1,234
Aug 31, 2025D&S Pump and Supply Co Inc38907
planned_repair 2025-01, 2025-08
D&S Pump and Supply Co Inc invoice for 1/2 HP Zoeller pump ($482) [tc_701dee5dce]. Memo contains a stale event date (2025-01-02) flagged as carryover [tc_701dee5dce], suggesting this invoice may belong to January 2025 rather than August. Classified as planned_repair based on equipment name. Attribution is ambiguous: memo date points to January, invoice date to August. Recommend review for proper period assignment.
evidence: tc_701dee5dce
1/2/HP Zoeller pump$482
Aug 31, 2025Williams Lumber8/31/25 Statement
routine
Williams Lumber statement for 8/31/25 ($702.57) [tc_701dee5dce]. Memo event date matches invoice date (2025-08-31) [tc_701dee5dce], indicating current-month consumables/supplies. Hardware store purchases typically routine maintenance items. Attributed to August with high confidence.
evidence: tc_701dee5dce
8/31/25 Statement$703

2025-09 1 event · $106

LLM 1/1 verified

One small repairs & maintenance invoice for $105.79 [tc_4e8c1a94e7] from Williams Lumber dated 2025-09-30 [tc_5dff07e952]. The memo states the event date as 2025-09-30, indicating a routine consumables purchase with no failure or emergency context. Mayor's report [tc_ab8ac3c298] discusses WWTP discharge violations and sewer expansion grant opportunities but does not reference specific maintenance events.

  • Single small invoice; no emergency or capital repairs in September
  • Mayor's report mentions WWTP discharge violations but no specific maintenance trigger for this invoice
  • No DEC compliance events in September [tc_6cbc8987ab]
DateVendorInvoiceLLM classificationMemo$ amount
Sep 30, 2025Williams Lumber9/30/25 Statement
routine
Williams Lumber statement for $105.79 [tc_5dff07e952] with memo event date of 2025-09-30 [tc_5dff07e952]. Small dollar amount and vendor (hardware store) with no failure or emergency language in memo indicates routine consumables or common parts purchase. Explicit memo date provides high confidence attribution to September 2025.
evidence: tc_5dff07e952, tc_4e8c1a94e7
9/30/25 Statement$106

2025-10 5 events · $2,545(3.1× budget)

LLM 5/5 verified

Five invoices dated in October 2025 [tc_2166daf86c] totaling $2,544.53 within the month. Extended 14-day window adds four more invoices (Nov 5–13) for a total of $4,928.09 [tc_1e70bd0315]. Mayor's October report contains no sewer-related commentary [tc_7fb9723e71], and no DEC compliance events occurred in October [tc_77ee8f91a5]. The month is dominated by a $2,200 storage-tank purchase (capital-class) and routine consumables; two sewage-pump invoices in early November carry October event dates in their memos.

  • Storage tank purchase ($2,200) exceeds routine maintenance threshold and may belong to capital budget.
  • Two Harbor Freight sewage-pump invoices (Nov 5–7) reference October event dates (10/29–10/30) but carry stale parsed dates (2025-01-02); memo dates are reliable.
  • Mayor's report silent on October sewer events; no regulatory triggers identified.
  • Repairs & Maintenance account significantly over budget YTD; October spend alone is ~2.7× monthly budget.
DateVendorInvoiceLLM classificationMemo$ amount
Oct 16, 2025Keith Bleakley6
capital
Keith Bleakley invoice for 8,000 gallon storage tank [tc_2166daf86c] at $2,200 is a major equipment purchase exceeding the $2,000 capital threshold. No memo event date, but invoice is dated mid-month (2025-10-16), so event is attributed to October. This asset arguably belongs to a capital budget rather than ongoing repairs/maintenance.
evidence: tc_2166daf86c
8,000 gallon storage tank$2,200
Oct 20, 2025GMES Red HookS5551785.001
routine
GMES Red Hook invoice [tc_2166daf86c] for long-nose multipurpose tool, AWG vinyl, and butt splices ($138.89) is a small-dollar consumable purchase with no failure context. Dated 2025-10-20, mid-month, attributed to October.
evidence: tc_2166daf86c
long-nose multipurpose tool; awg vinyl; butt splices 50/box$139
Oct 21, 2025GMES Red HookS5554003.001
routine
GMES Red Hook invoice [tc_2166daf86c] for three GEI circuit breakers (20A 1P 120/240V, 10KA bolt-on, 10/box) at $64.81 is a small-dollar electrical parts purchase with no specific failure context. Dated 2025-10-21, mid-month, attributed to October.
evidence: tc_2166daf86c
three - GEI THQB1120 20A 1P 120/240V 10KA BOLT-ON BREAKER (10/BX)$65
Oct 28, 2025Plimpton & Hills15183922
routine
Plimpton & Hills invoice [tc_2166daf86c] for 2 mission jim caps at $50.46 is a small-dollar consumable with no failure context. Dated 2025-10-28, late month, attributed to October.
evidence: tc_2166daf86c
2 mission jim caps$50
Oct 31, 2025Carquest Auto Parts Stores10/31/25 Statement
routine
Carquest Auto Parts Stores statement [tc_2166daf86c] for 'sewer repair parts' at $90.37 is a small-dollar consumable purchase. Memo is generic ('sewer repair parts') but vendor and amount suggest routine parts restocking. Dated 2025-10-31, end of month, attributed to October.
evidence: tc_2166daf86c
sewer repair parts$90

2025-11 10 events · $5,160(6.2× budget)

LLM 13/13 verified

November 2025 repairs/maintenance spending totaled $19,791.71 across 13 invoices (10 dated in-month, 3 in early December within the 14-day billing window). The portfolio is dominated by two large capital-class purchases: a $12,380 UV unit rebuild and $1,863 in anthracite media, alongside routine consumables and parts. A November DEC notice of violation provides regulatory context for elevated maintenance activity.

  • Two invoices (Harbor Freight, 2025-11-07) reference October dates (10/29–10/30) but were billed in November; attributed to 2025-10.
  • Williams Lumber statement (2025-11-13) explicitly dated 10/31/25; attributed to 2025-10.
  • Large capital purchase (Water Services UV rebuild, $12,380) dated 2025-12-10 but included in 14-day window; attributed to 2025-12.
  • DEC notice of violation issued 2025-11-01 may have triggered or accelerated maintenance activity.
  • Mayor's report for November mentions septic replacement funding but no WWTP-specific sewer maintenance context.
DateVendorInvoiceLLM classificationMemo$ amount
Nov 5, 2025Amazon(empty)$18
Nov 7, 2025Harbor Freight Tools USA Inc90c93a82
planned_repair 2025-10
Memo explicitly states '10/30/25 - 1/2 HP cast iron sewage pump & parts'; event occurred in October, billed in November per standard lag [tc_ae127ae363].
evidence: tc_ae127ae363
10/30/25 - 1/2 HP cast iron sewage pump & parts$275
Nov 7, 2025Harbor Freight Tools USA Inc90c93a82
planned_repair 2025-10
Memo explicitly states '10/30/25 - 1/2 HP cast iron sewage pump & parts'; event occurred in October, billed in November per standard lag [tc_ae127ae363].
evidence: tc_ae127ae363
10/29/25 - 1/2 HP cast iron sewage pump & parts$315
Nov 13, 2025Williams Lumber10/31/25 Statement
routine 2025-10
Carquest Auto Parts Stores statement [tc_2166daf86c] for 'sewer repair parts' at $90.37 is a small-dollar consumable purchase. Memo is generic ('sewer repair parts') but vendor and amount suggest routine parts restocking. Dated 2025-10-31, end of month, attributed to October.
evidence: tc_2166daf86c
10/31/25 Statement$1,776
Nov 17, 2025Dongo Water & Wastewater Equipment Sales LLC1148
capital
Anthracite media (30 bags, 52# each) for water treatment; $1,863 is a substantial single purchase for filter media replacement, typically a capital or major maintenance item. No explicit event date in memo; invoice dated mid-November, attributed to current month [tc_ae127ae363].
evidence: tc_ae127ae363
C146501014-- ANTHRACITE #2, 1.7-2.0mm, 52# BAG,UC<1.7., 30 Bags Ordered$1,863
Nov 18, 2025Amazon(empty)$75
Nov 18, 2025Amazon(empty)$166
Nov 22, 2025Callanan Industries Inc1233648
routine
Driveway mix subbase; small consumable material purchase, likely for collection-system or facility access road maintenance. No specific failure context. Dated late November, attributed to current month [tc_ae127ae363].
evidence: tc_ae127ae363
driveway mix subbase$57
Nov 30, 2025Carquest Auto Parts Stores11/30/25 Statement
routine
Memo states '6 belts for sewer repair'; belts are consumable parts for pump or motor maintenance. Small dollar amount and routine parts supplier context. Dated end of November, attributed to current month [tc_ae127ae363].
evidence: tc_ae127ae363
6 belts for sewer repair$131
Nov 30, 2025Williams LumberNov 2025 Statement
unknown
Williams Lumber statement for November with no itemized memo; moderate dollar amount ($484.63) suggests materials or supplies, but specific repair type is not disclosed. Dated end of November, attributed to current month [tc_ae127ae363].
evidence: tc_ae127ae363
Nov 2025 Statement$485

2025-12 4 events · $14,682(17.6× budget)

LLM 5/5 verified

Four invoices dated in December 2025 (total $14,682.21 in-month [tc_4ad834c516]) plus one carryover from Williams Lumber dated 2026-01-02 but memo-dated 2025-12-31 (total $14,717.32 in 14-day window [tc_53d7bb09f2]). Mix of routine consumables, planned preventative maintenance, and a major capital-grade UV rebuild. Mayor's report contains no sewer-specific commentary [tc_112430524f]; a DEC inspection occurred 2025-12-16 [tc_30314012a3], providing regulatory context for the UV rebuild.

  • DEC inspection on 2025-12-16 may have triggered or accelerated the UV rebuild invoice (12/10 completion date predates inspection, but quote date 03282025 suggests long lead-time planning)
  • UV rebuild invoice ($12,380) is capital-grade and exceeds routine maintenance budget by 12× the monthly allocation
  • Mayor's report silent on December sewer operations despite significant capital work
DateVendorInvoiceLLM classificationMemo$ amount
Dec 8, 2025USABlueBook Inc903664
planned_repair
Nine 62×610 EPDM diffusers; replacement diffusers for aeration basin, a planned maintenance item. Dated 2025-12-08, within 14-day billing window but event belongs to December [tc_6952e022c8].
evidence: tc_6952e022c8
nine 62x610 EPDM diffusers$504
Dec 10, 2025Allstate Power Systems, LLC603935
planned_repair
Memo states 'yearly preventative maintenance contract for two WWTP generators'; scheduled annual service. Dated 2025-12-10, within 14-day window but event belongs to December [tc_6952e022c8].
evidence: tc_6952e022c8
yearly preventative maintenance contract for two WWTP generators$1,747
Dec 10, 2025Water Services IncInvoice $138
capital
Memo states 'Quote 03282025 New side UV units rebuild - completed 12/10/25'; $12,380 is a major capital-class equipment rebuild (UV disinfection units). Explicit completion date 2025-12-10 in memo. Exceeds $2,000 threshold and should arguably be capitalized rather than expensed to repairs/maintenance [tc_6952e022c8].
evidence: tc_6952e022c8
Quote 03282025 New side UV units rebuild - completed 12/10/25$12,380
reclassified out
Dec 31, 2025Carquest Auto Parts StoresDecember 2025 Stmt
routine
Carquest statement for nitrile gloves and 'med raven' (likely 'med raven' = medium raven or similar consumable). Small-dollar ($50.51 [tc_4ad834c516]) consumable supplies with no failure context. Invoice dated 2025-12-31; attributed to December.
evidence: tc_4ad834c516
nitrile gloves & med raven$51

2026-01 2 events · $846(1.0× budget)

LLM 2/2 verified

Two invoices dated in January 2026 [tc_fd25ecaf8e]: a small Williams Lumber statement from 12/31/25 ($35.11) and a larger January statement ($810.94). The 14-day billing window captures four additional February-dated invoices totaling $1,394.11. Mayor's report for January contains no sewer-specific commentary [tc_26f51c9e35]. A DEC inspection occurred on 2025-12-16 [tc_344e4073c1], potentially triggering follow-up repairs.

  • Mayor's report for 2026-01 contains zero sewer excerpts; no regulatory or operational context available from budget-holder perspective.
  • DEC inspection on 2025-12-16 may have triggered repairs visible in January invoices.
  • Williams Lumber statements are monthly summaries; individual line items not itemized in QB memo.
DateVendorInvoiceLLM classificationMemo$ amount
Jan 2, 2026Williams Lumber12/31/25 Statement$35
Jan 31, 2026Williams Lumber1/31/26 Statement
routine
Williams Lumber monthly statement dated 1/31/26 [tc_fd25ecaf8e]. Memo explicitly states event date as 2026-01-31. Amount of $810.94 is moderate for a month-long accumulation of hardware-store purchases. Without itemization, classified as routine consumables/parts rather than a specific repair project.
evidence: tc_fd25ecaf8e
1/31/26 Statement$811

2026-02 5 events · $2,215(2.7× budget)

LLM 5/5 verified

Five repairs/maintenance invoices totaling $2,214.71 [tc_1519bca683] in February 2026. Two invoices (Harbor Freight sewage pumps and Williams Lumber) show explicit event dates in their memos; the others are routine consumables or preventative maintenance. A NYSDEC NOV was issued on 2026-02-26 [tc_e128deb865], but no mayor's report mentions sewer emergencies in February [tc_05e3e60a73].

  • NYSDEC NOV issued 2026-02-26 [tc_e128deb865] — check if any invoices relate to compliance response
  • One invoice (Harbor Freight sewage pumps, 2026-02-09) has memo event date of 2026-03-04, suggesting the purchase was for a March event or the memo date is forward-looking
  • Mayor's report [tc_05e3e60a73] mentions fiber installation at sewer plant deferred until ground thaw, but no emergency repairs mentioned
DateVendorInvoiceLLM classificationMemo$ amount
Feb 2, 2026Harbor Freight Tools USA Inc3e7dc4ac
routine
Harbor Freight invoice [tc_1519bca683] for 'various sewer repair parts + 2 year ITC Membership' ($263.74). No specific failure or event date in memo. Small dollar amount and generic description suggest routine consumables. Dated early February, attributed to current month.
evidence: tc_1519bca683
various sewer repair parts + 2 year ITC Membership$264
Feb 3, 2026Electric Ace202421954
planned_repair
Electric Ace invoice [tc_1519bca683] for 'deposit for Generator Preventative Maintenance - Multiple Units' ($709). Memo explicitly states 'Preventative Maintenance,' indicating a scheduled service rather than emergency response. Dated early February.
evidence: tc_1519bca683
deposit for Generator Preventative Maintenance - Multiple Units$709
Feb 5, 2026Plimpton & Hills15188648
routine
Plimpton & Hills invoice [tc_1519bca683] for 'parts for sewer repair' ($5.39). Minimal dollar amount and generic description with no failure context. Routine consumable parts purchase.
evidence: tc_1519bca683
parts for sewer repair$5
Feb 9, 2026Harbor Freight Tools USA Inc354558ff
planned_repair 2026-03
Harbor Freight invoice [tc_1519bca683] for 'two 3/4 HP CAST IRON SEWAGE PUMPS' ($415.98). Memo contains explicit event date of 2026-03-04 [tc_1519bca683], indicating the pumps were purchased in February for a March installation or replacement event. This is a planned equipment replacement, not an emergency. Attributed to March based on memo event date.
evidence: tc_1519bca683
two 3/4 HP CAST IRON SEWAGE PUMPS$416
Feb 26, 2026Williams Lumber2/26/26 Statement
unknown
Williams Lumber statement [tc_1519bca683] dated 2026-02-26 with memo '2/26/26 Statement' ($820.60). Memo event date matches invoice date [tc_1519bca683], but the statement itself provides no itemization or description of what was purchased. Issued same day as NYSDEC NOV [tc_e128deb865], but no evidence links this purchase to compliance response. Cannot classify without item detail.
evidence: tc_1519bca683, tc_e128deb865
2/26/26 Statement$821

Vendors by spend

VendorBills$ totalFirst → Last
Water Services Inc1$12,3802025-12-102025-12-10
Williams Lumber9$4,9332025-07-102026-02-26
Keith Bleakley2$4,0002025-08-032025-10-16
Dongo Water & Wastewater Equipment Sales LLC1$1,8632025-11-172025-11-17
Allstate Power Systems, LLC1$1,7472025-12-102025-12-10
Harbor Freight Tools USA Inc4$1,2702025-11-072026-02-09
Ferguson Waterworks #16721$1,2342025-08-262025-08-26
Electric Ace1$7092026-02-032026-02-03
Ferguson Waterworks1$5052025-07-012025-07-01
USABlueBook Inc1$5042025-12-082025-12-08
D&S Pump and Supply Co Inc1$4822025-08-312025-08-31
FH Stickles & Son Inc1$3092025-08-122025-08-12
Benson Steel Fabricators1$2772025-07-022025-07-02
Carquest Auto Parts Stores3$2722025-10-312025-12-31
Amazon3$2592025-11-052025-11-18
Plimpton & Hills3$2302025-08-012026-02-05
GMES Red Hook2$2042025-10-202025-10-21
Callanan Industries Inc1$572025-11-222025-11-22