PEX Manifold 8-Port
WatchPEX-MAN-8 · PVC & fittings · supplied by Meridian Pipe Works
- Price
- $148.00
- Unit cost
- $115.29
- On hand
- 1,240
- Annual volume
- 310 u
i2C StockSense™ — is this product healthy, and is cash trapped in it?
22.1%
gross margin · -0.6 pts since Feb
Verdict
Yes — holding target
Annual margin loss
—
Frozen cash
$142,960
Margin looks acceptable on paper, but almost nothing sells. $142,960 has been frozen in this SKU since the 10-port model took over demand in May.
Margin trend
Realised gross margin by month, from invoiced lines
Sell velocity & stockout forecast
- Sell velocity
- 6 units / week
- 6 units in the last 30 days
- Days of cover
- 1446
- at the current 30-day run rate
Stockout forecast
No stockout risk
Stock level over time
On-hand units by month against a reorder point of 0 units
StockSense status
Cover against reorder point, and the cash sitting in this line
On-hand value
$142,960
Cash trapped
$142,960
Reorder point
Not reordered
Status
Healthy
Advisory: Do not reorder. Clearance is the only route to the $142,960 tied up here.
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-4102 | Feb 14, 2026 | 800 | $114.20 | 640 | $73,088 |
| LOT-4390 | Apr 9, 2026 | 700 | $115.29 | 600 | $69,174 |
Oldest remaining lot is consumed first, so the next invoices still carry the older cost. The blended cost you are selling against today is $115.29 per unit.
Recommended (advisory)
Explanation and advice — nothing here changes a price or a purchase order
What is leaking: No sales movement in 91 days; superseded by 10-port model
Advisory fix: Cash is recoverable through clearance pricing; margin is not the issue here
Advisory only —i2cashflow reads your catalogue and cost lots. Price changes stay in Brightpearl, made by your team.