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.
3 transactions reclassified out of this account ($20,749 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.
- Dec 10, 2025 · Water Services Inc · $12,380 · capital_equipment_rebuildNew 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.
- Apr 7, 2026 · Bullseye Industrial Sales LLC · $1,168 · capital_equipment_replacementBullseye Industrial Sales, $1,168, no memo — an unlabeled industrial-equipment purchase well above the routine parts/tools/consumables level for R&M. Reclassified to the Repair Reserve as capital-class alongside the April grinder; revisit if an invoice/memo later shows it was consumable.
- Apr 27, 2026 · D&S Pump and Supply Co Inc · $7,201 · capital_equipment_replacement3HP 200V 3PH grinder pump — a durable plant asset replacement, not routine maintenance. At $7,201 it's the largest R&M invoice of the year and capital-class; belongs in a Repair Reserve, not the operating R&M run-rate.
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)
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Jul 1, 2025 | Ferguson Waterworks | Invoice 5775 | — | second 115V auto sewer pump | $505 |
| Jul 2, 2025 | Benson Steel Fabricators | Invoice 36971 | — | 2 pipes and 2 angles for sewer tools less credit for earlier purchase | $277 |
| Jul 10, 2025 | Williams Lumber | 6/30/25 Statement | — | (empty) | $149 |
| Jul 31, 2025 | Williams Lumber | 7/31/25 Statement | — | (empty) | $49 |
2025-08 6 events · $4,701(5.6× budget)
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Aug 1, 2025 | Plimpton & Hills | 15179569 | — | 18" & 24" AL pipe wre | $174 |
| Aug 3, 2025 | Keith Bleakley | — | — | 5,000 gallon storage tank | $1,800 |
| Aug 12, 2025 | FH Stickles & Son Inc | Invoice 42649 | — | 4000# (67 Blend), microfibers, fuel | $309 |
| Aug 26, 2025 | Ferguson Waterworks #1672 | 9023 | — | 115V 1HP Sewer Pump w/VLFS; 115v 1/2hp ci auto sew pump | $1,234 |
| Aug 31, 2025 | D&S Pump and Supply Co Inc | 38907 | — | 1/2/HP Zoeller pump | $482 |
| Aug 31, 2025 | Williams Lumber | 8/31/25 Statement | — | 8/31/25 Statement | $703 |
2025-09 1 event · $106
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Sep 30, 2025 | Williams Lumber | 9/30/25 Statement | — | 9/30/25 Statement | $106 |
2025-10 5 events · $2,545(3.1× budget)
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Oct 16, 2025 | Keith Bleakley | 6 | — | 8,000 gallon storage tank | $2,200 |
| Oct 20, 2025 | GMES Red Hook | S5551785.001 | — | long-nose multipurpose tool; awg vinyl; butt splices 50/box | $139 |
| Oct 21, 2025 | GMES Red Hook | S5554003.001 | — | three - GEI THQB1120 20A 1P 120/240V 10KA BOLT-ON BREAKER (10/BX) | $65 |
| Oct 28, 2025 | Plimpton & Hills | 15183922 | — | 2 mission jim caps | $50 |
| Oct 31, 2025 | Carquest Auto Parts Stores | 10/31/25 Statement | — | sewer repair parts | $90 |
2025-11 10 events · $5,160(6.2× budget)
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Nov 5, 2025 | Amazon | — | — | (empty) | $18 |
| Nov 7, 2025 | Harbor Freight Tools USA Inc | 90c93a82 | — | 10/29/25 - 1/2 HP cast iron sewage pump & parts | $315 |
| Nov 7, 2025 | Harbor Freight Tools USA Inc | 90c93a82 | — | 10/30/25 - 1/2 HP cast iron sewage pump & parts | $275 |
| Nov 13, 2025 | Williams Lumber | 10/31/25 Statement | — | 10/31/25 Statement | $1,776 |
| Nov 17, 2025 | Dongo Water & Wastewater Equipment Sales LLC | 1148 | — | C146501014-- ANTHRACITE #2, 1.7-2.0mm, 52# BAG,UC<1.7., 30 Bags Ordered | $1,863 |
| Nov 18, 2025 | Amazon | — | — | (empty) | $166 |
| Nov 18, 2025 | Amazon | — | — | (empty) | $75 |
| Nov 22, 2025 | Callanan Industries Inc | 1233648 | — | driveway mix subbase | $57 |
| Nov 30, 2025 | Carquest Auto Parts Stores | 11/30/25 Statement | — | 6 belts for sewer repair | $131 |
| Nov 30, 2025 | Williams Lumber | Nov 2025 Statement | — | Nov 2025 Statement | $485 |
2025-12 4 events · $14,682(17.6× budget)
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Dec 8, 2025 | USABlueBook Inc | 903664 | — | nine 62x610 EPDM diffusers | $504 |
| Dec 10, 2025 | Allstate Power Systems, LLC | 603935 | — | yearly preventative maintenance contract for two WWTP generators | $1,747 |
| Dec 10, 2025 | Water Services Inc | Invoice $138 | — | Quote 03282025 New side UV units rebuild - completed 12/10/25 | $12,380 reclassified out |
| Dec 31, 2025 | Carquest Auto Parts Stores | December 2025 Stmt | — | nitrile gloves & med raven | $51 |
2026-01 2 events · $846(1.0× budget)
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Jan 2, 2026 | Williams Lumber | — | — | 12/31/25 Statement | $35 |
| Jan 31, 2026 | Williams Lumber | 1/31/26 Statement | — | 1/31/26 Statement | $811 |
2026-02 5 events · $2,215(2.7× budget)
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Feb 2, 2026 | Harbor Freight Tools USA Inc | 3e7dc4ac | — | various sewer repair parts + 2 year ITC Membership | $264 |
| Feb 3, 2026 | Electric Ace Operations LLC | 202421954 | — | deposit for Generator Preventative Maintenance - Multiple Units | $709 |
| Feb 5, 2026 | Plimpton & Hills | 15188648 | — | parts for sewer repair | $5 |
| Feb 9, 2026 | Harbor Freight Tools USA Inc | 354558ff | — | two 3/4 HP CAST IRON SEWAGE PUMPS | $416 |
| Feb 26, 2026 | Williams Lumber | 2/26/26 Statement | — | 2/26/26 Statement | $821 |
2026-03 7 events · $953(1.1× budget)
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Mar 3, 2026 | VEVOR | — | — | (empty) | $72 |
| Mar 16, 2026 | Grainger | 9842750268 | — | fuse, 500VAC cyc 15A | $33 |
| Mar 23, 2026 | Harbor Freight Tools USA Inc | 131b580c | — | extension cord & 1/2 HP cast iron sewage pump | $137 |
| Mar 23, 2026 | Harbor Freight Tools USA Inc | ece5252c | — | 3/4 HP cast iron sewage pump | $260 |
| Mar 23, 2026 | Harbor Freight Tools USA Inc | ece5252c | — | 1/2 HP cast iron sewage pump | $120 |
| Mar 23, 2026 | Harbor Freight Tools USA Inc | ece5252c | — | 1/2 HP cast iron sewage pump | $120 |
| Mar 27, 2026 | Dongo Water & Wastewater Equipment Sales LLC | 1177 | — | supplies for cleaning UVs on 1A | $210 |
2026-04 14 events · $12,885(15.5× budget)
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Apr 1, 2026 | Williams Lumber | 3/31/26 Statement | — | 3/31/26 Statement | $967 |
| Apr 6, 2026 | eBay | — | — | (empty) | $95 |
| Apr 7, 2026 | Bullseye Industrial Sales LLC | — | — | (empty) | $1,168 reclassified out |
| Apr 8, 2026 | Amazon Capital Services | 1661-QKKD-6YK4 | — | AC Contactor 3P LC1D25 LC1D25G7 LC1-D25G7 25A 120V AC coil | $53 |
| Apr 13, 2026 | Harbor Freight Tools USA Inc | 7a1475bf | — | sewer repair tools; 2 hoses - intake and discharge; 3IN fulltrash gas engine pump | $1,171 |
| Apr 26, 2026 | Amazon Capital Services | 1HTQ-FHNV-4LHK | — | repair parts for sewer tank | $141 |
| Apr 27, 2026 | Amazon Capital Services | 11JF-V3FT-WLPV | — | 25 pc hex head/allen wrench/screwdriver bits set | $14 |
| Apr 27, 2026 | D&S Pump and Supply Co Inc | 30226 | — | 3HP 200V 3PH Grinder | $7,201 reclassified out |
| Apr 27, 2026 | M&T Bank Credit Card | 4/27/26 Statement | — | 4/27/26 Statement | $1,263 |
| Apr 29, 2026 | Dongo Water & Wastewater Equipment Sales LLC | 1185 | — | oil for servicing blowers at WWTP | $168 |
| Apr 29, 2026 | Amazon Capital Services | 163W-J3TX-9KJM | — | 2 male to male hex nipple pipe fittings | $74 |
| Apr 29, 2026 | Harbor Freight Tools USA Inc | f51478a | — | 1/2 HP cast iron sewage pump & 2 outdoor hoses | $171 |
| Apr 30, 2026 | Williams Lumber | 4/30/26 Statement | — | 4/30/26 Statement | $364 |
| Apr 30, 2026 | Carquest Auto Parts Stores | 4/30/26 Statement | — | gear oil & paddle switch | $36 |
2026-05 1 event · $109
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| May 31, 2026 | Williams Lumber | 5/31/26 Statement | — | 5/31/26 Statement | $109 |
Vendors by spend
| Vendor | Bills | $ total | First → Last |
|---|---|---|---|
| Water Services Inc | 1 | $12,380 | 2025-12-10 → 2025-12-10 |
| D&S Pump and Supply Co Inc | 2 | $7,683 | 2025-08-31 → 2026-04-27 |
| Williams Lumber | 12 | $6,373 | 2025-07-10 → 2026-05-31 |
| Keith Bleakley | 2 | $4,000 | 2025-08-03 → 2025-10-16 |
| Harbor Freight Tools USA Inc | 10 | $3,248 | 2025-11-07 → 2026-04-29 |
| Dongo Water & Wastewater Equipment Sales LLC | 3 | $2,241 | 2025-11-17 → 2026-04-29 |
| Allstate Power Systems, LLC | 1 | $1,747 | 2025-12-10 → 2025-12-10 |
| M&T Bank Credit Card | 1 | $1,263 | 2026-04-27 → 2026-04-27 |
| Ferguson Waterworks #1672 | 1 | $1,234 | 2025-08-26 → 2025-08-26 |
| Bullseye Industrial Sales LLC | 1 | $1,168 | 2026-04-07 → 2026-04-07 |
| Electric Ace Operations LLC | 1 | $709 | 2026-02-03 → 2026-02-03 |
| Ferguson Waterworks | 1 | $505 | 2025-07-01 → 2025-07-01 |
| USABlueBook Inc | 1 | $504 | 2025-12-08 → 2025-12-08 |
| FH Stickles & Son Inc | 1 | $309 | 2025-08-12 → 2025-08-12 |
| Carquest Auto Parts Stores | 4 | $307 | 2025-10-31 → 2026-04-30 |
| Amazon Capital Services | 4 | $282 | 2026-04-08 → 2026-04-29 |
| Benson Steel Fabricators | 1 | $277 | 2025-07-02 → 2025-07-02 |
| Amazon | 3 | $259 | 2025-11-05 → 2025-11-18 |
| Plimpton & Hills | 3 | $230 | 2025-08-01 → 2026-02-05 |
| GMES Red Hook | 2 | $204 | 2025-10-20 → 2025-10-21 |
| eBay | 1 | $95 | 2026-04-06 → 2026-04-06 |
| VEVOR | 1 | $72 | 2026-03-03 → 2026-03-03 |
| Callanan Industries Inc | 1 | $57 | 2025-11-22 → 2025-11-22 |
| Grainger | 1 | $33 | 2026-03-16 → 2026-03-16 |