Galvanised Strut Channel 12ft
LeakingGLV-STR-12 · Steel & structural · supplied by Cascade Metals & Alloy
- Price
- $31.00
- Unit cost
- $26.29
- On hand
- 9,800
- Annual volume
- 5,100 u
i2C StockSense™ — is this product healthy, and is cash trapped in it?
15.2%
gross margin · -9.4 pts since Feb
Verdict
Yes, but leaking
Annual margin loss
$24,800
Frozen cash
$186,400
The worst combination on the catalogue: thin margin and far too much stock. $186,400 of cash is sitting in strut channel that turns less than once every two years.
Margin trend
Realised gross margin by month, from invoiced lines
Sell velocity & stockout forecast
- Sell velocity
- 96 units / week
- 96 units in the last 30 days
- Days of cover
- 714
- at the current 30-day run rate
Stockout forecast
Cover through Jun 2028 at current velocity
Stock level over time
On-hand units by month against a reorder point of 1,200 units
StockSense status
Cover against reorder point, and the cash sitting in this line
On-hand value
$257,642
Cash trapped
$186,400
Reorder point
1,200 u
Status
Healthy
Advisory: Hold all further lots. $186,400 of cash is already committed 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-2755 | Jan 19, 2026 | 4,000 | $23.40 | 2,100 | $49,140 |
| LOT-2910 | Mar 30, 2026 | 4,000 | $25.10 | 3,700 | $92,870 |
| LOT-3080 | Jun 4, 2026 | 4,000 | $26.29 | 4,000 | $105,160 |
Oldest remaining lot is consumed first, so the next invoices still carry the older cost. The blended cost you are selling against today is $26.29 per unit.
Recommended (advisory)
Explanation and advice — nothing here changes a price or a purchase order
What is leaking: Steel surcharge absorbed while three competitors raised list prices
Advisory fix: Price is 9% below the regional benchmark; a correction is available without volume risk
Advisory only —i2cashflow reads your catalogue and cost lots. Price changes stay in Brightpearl, made by your team.