PVC Pipe 2" Schedule 40
LeakingPVC-200-S40 · PVC & fittings · supplied by Meridian Pipe Works
- Price
- $42.50
- Unit cost
- $34.68
- On hand
- 4,820
- Annual volume
- 21,400 u
i2C StockSense™ — is this product healthy, and is cash trapped in it?
18.4%
gross margin · -7.2 pts since Feb
Verdict
Yes, but leaking
Annual margin loss
$31,200
Frozen cash
None
This is your highest-volume SKU and your largest margin leak. It still makes money — 18.4% gross — but that is 7.2 points below where it sat in February, entirely because Meridian's lot cost climbed while the list price never moved.
Margin trend
Realised gross margin by month, from invoiced lines
Sell velocity & stockout forecast
- Sell velocity
- 412 units / week
- 412 units in the last 30 days
- Days of cover
- 82
- at the current 30-day run rate
Stockout forecast
Cover through Sep 22, 2026
Stock level over time
On-hand units by month against a reorder point of 3,200 units
StockSense status
Cover against reorder point, and the cash sitting in this line
On-hand value
$167,158
Cash trapped
None
Reorder point
3,200 u
Status
Healthy
Advisory: Stock does not need it before October — delaying two weeks clears the Sep 4 low point.
Advisory only —StockSense explains cover and trapped cash. It never raises or edits a purchase order.
COGS — FIFO cost lots
Read from Brightpearl goods-in receipts. Shown to explain the cost, never to change it.
| Lot | Received | Qty received | Unit cost | Remaining | Remaining value |
|---|---|---|---|---|---|
| LOT-4417 | Mar 4, 2026 | 6,000 | $30.42 | 0 | $0 |
| LOT-4588 | Apr 28, 2026 | 6,000 | $32.10 | 0 | $0 |
| LOT-4712 | Jun 9, 2026 | 6,000 | $33.75 | 1,120 | $37,800 |
| LOT-4880 | Jul 21, 2026 | 5,000 | $34.68 | 3,700 | $128,316 |
Oldest remaining lot is consumed first, so the next invoices still carry the older cost. The blended cost you are selling against today is $34.68 per unit.
Recommended (advisory)
Explanation and advice — nothing here changes a price or a purchase order
What is leaking: COGS rose 14% while list price held flat since February
Advisory fix: A 6% list increase restores the 25.6% target margin and stays under the regional benchmark
Advisory only —i2cashflow reads your catalogue and cost lots. Price changes stay in Brightpearl, made by your team.