Copper Elbow 3/4" 90°
WatchCU-ELB-075 · PVC & fittings · supplied by Meridian Pipe Works
- Price
- $12.40
- Unit cost
- $9.31
- On hand
- 12,400
- Annual volume
- 59,200 u
i2C StockSense™ — is this product healthy, and is cash trapped in it?
24.9%
gross margin · -2.3 pts since Feb
Verdict
Yes — holding target
Annual margin loss
$12,400
Frozen cash
None
Still a healthy margin, but slipping for a structural reason: purchase lot sizes dropped below the 10,000-unit discount tier in May and have not recovered.
Margin trend
Realised gross margin by month, from invoiced lines
Sell velocity & stockout forecast
- Sell velocity
- 1,140 units / week
- 1,140 units in the last 30 days
- Days of cover
- 76
- at the current 30-day run rate
Stockout forecast
Cover through Oct 30, 2026
Stock level over time
On-hand units by month against a reorder point of 9,000 units
StockSense status
Cover against reorder point, and the cash sitting in this line
On-hand value
$115,444
Cash trapped
None
Reorder point
9,000 u
Status
Watch
Advisory: Next lot at 10,000 units restores the tier and 1.8 points of margin.
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-5120 | May 6, 2026 | 9,000 | $8.94 | 0 | $0 |
| LOT-5288 | Jun 22, 2026 | 8,000 | $9.18 | 4,400 | $40,392 |
| LOT-5401 | Aug 1, 2026 | 8,000 | $9.31 | 8,000 | $74,480 |
Oldest remaining lot is consumed first, so the next invoices still carry the older cost. The blended cost you are selling against today is $9.31 per unit.
Recommended (advisory)
Explanation and advice — nothing here changes a price or a purchase order
What is leaking: Volume discount tier lost after order sizes dropped below 10k units
Advisory fix: Restoring 10k-unit purchase lots returns the tier and 1.8 points of margin
Advisory only —i2cashflow reads your catalogue and cost lots. Price changes stay in Brightpearl, made by your team.