Which stock is tying up cash?
$128,000 of stock had not sold in nine months, and half was bought to reach a supplier discount.
What went in
- Files
- 4
- Rows
- 94,154
- Period
- Aug 1, 2025 – Jul 31, 2026
- Verification
- 26 checks passed
Source files
- order_lines.csv86,412 rows
- stock_on_hand.xlsx1,284 rows
- purchase_orders.csv2,140 rows
- returns.csv4,318 rows
What came back
- $412,000
- 31.0%
- 214
The finished project
order_lines.csv
86,412 rowsCheckedYour best-selling product loses $2.15 a unit, and it paid for the stock you cannot sell.
The linen shirt is the top seller by volume and reports a 59% gross margin. After discounts, marketplace and payment fees, free shipping and a 26% return rate, it contributes −$2.15 per unit ordered — $8,988 over the year. Meanwhile $128,000 of stock, 31% of the total value, has not sold in nine months, and eight of the products that do sell were out of stock for 4.7% of the year.
$412,000Stock value+11.2%
31.0%Not sold in 9 months+4.3pp
214SKUs below zero
Where the linen shirt's margin goes
A 59% gross margin ends at −$8,988
- 01The best seller contributes −$2.15 per unit ordered.
- 02$128,000 of stock has not sold in nine months, and half of it was bought to hit a discount.
- 03Eight products that do sell were unavailable for 4.7% of the year.
Filed under
Closest to this one
Have something like this?
Drop it in and see what comes back. You only pay once you like it.
No account needed to start. You only pay when you like what you see.