Brass Ball Valve 1"
LeakingBRS-BV-100 · Valves & actuators · supplied by Orchid Valve Import
- Price
- $68.00
- Unit cost
- $53.31
- On hand
- 640
- Annual volume
- 9,800 u
i2C StockSense™ — is this product healthy, and is cash trapped in it?
21.6%
gross margin · -4.1 pts since Feb
Verdict
Yes, but leaking
Annual margin loss
$18,600
Frozen cash
None
Margin erosion here comes from freight, not unit price. Stock is also thin: at 188 units a week the current 640 on hand runs out in roughly 24 days, ahead of the next inbound lot.
Margin trend
Realised gross margin by month, from invoiced lines
Sell velocity & stockout forecast
- Sell velocity
- 188 units / week
- 188 units in the last 30 days
- Days of cover
- 24
- at the current 30-day run rate
Stockout forecast
Projected stockout Sep 8, 2026
Stock level over time
On-hand units by month against a reorder point of 1,100 units
StockSense status
Cover against reorder point, and the cash sitting in this line
On-hand value
$34,118
Cash trapped
None
Reorder point
1,100 u
Status
Reorder now
Advisory: Orchid's lead time is 34 days. A lot placed this week arrives after the gap; splitting an air freight partial would cover it.
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-3901 | Apr 2, 2026 | 1,200 | $48.90 | 0 | $0 |
| LOT-4055 | May 27, 2026 | 1,200 | $51.20 | 0 | $0 |
| LOT-4210 | Jul 14, 2026 | 1,000 | $53.31 | 640 | $34,118 |
Oldest remaining lot is consumed first, so the next invoices still carry the older cost. The blended cost you are selling against today is $53.31 per unit.
Recommended (advisory)
Explanation and advice — nothing here changes a price or a purchase order
What is leaking: Import freight up 18% per lot, absorbed into landed cost
Advisory fix: Consolidating to monthly container shipments recovers an estimated 2.4 points
Advisory only —i2cashflow reads your catalogue and cost lots. Price changes stay in Brightpearl, made by your team.