| SKU | Item Description | Location | System Qty | Physical Count | Variance | Cost Price | Retail Price | Total Value | Stock Balance | Fixed Stock | Used by Salon | Sold to Customer | Online Purchased | Transfer From | Transfer To | Qty in Transit | Status | Reorder? | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A-25 | Widget - Red | W1-A4-B2 | 105 | 100 | -5 | $10.00 | $24.99 | $1,000.00 | 95 | 50 | 15 | 80 | 10 | - | - | - | Active | No | High profit margin item. |
| B-77 | Gizmo - Blue | W1-B1-S3 | 50 | 50 | 0 | $25.50 | $49.99 | $1,275.00 | 42 | 30 | 5 | 40 | 5 | Main DC | Outlet East | 25 | Active | Yes | 25 units in transit. |
| C-33 | Cable (5ft) | W2-C7-B1 | 1000 | 1050 | +50 | $2.00 | $9.99 | $2,100.00 | 1210 | 100 | 0 | 900 | 150 | - | - | - | Active | No | High-volume, low-margin. |
| D-90 | Old Model V2 | W2-D2-S1 | 15 | 15 | 0 | $75.00 | $129.99 | $1,125.00 | 15 | 0 | 0 | 5 | 0 | Outlet West | Main DC | 10 | Discontinued | No | Clearance price: $79.99 |
$5,500.00
+45 units (+$90)
1
96.2%