Inventory - On Hand
Current inventory levels, reorder alerts, and dead stock analysis
Total Inventory Value
$1,284,600
Total SKUs
4,820
Below Reorder Point
47 items
↓ Needs attention
Dead Stock (>180d)
128 items ($48.2K)
↓ Review needed
Inventory Detail
| Practice | Code | Brand | Model | Category | Qty | Unit Cost | Total Value | Last Sold | Sell Rate | Reorder Pt | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| AEC | FRM-OAK-0012 | Oakley | Holbrook | Frames | 6 | $89.00 | $534 | 01/28/26 | 3.2/wk | 12 | Below Reorder |
| VEO | FRM-RAB-0034 | Ray-Ban | Wayfarer | Frames | 24 | $72.00 | $1,728 | 01/30/26 | 2.1/wk | 8 | OK |
| ECH | FRM-GUC-0087 | Gucci | GG0010S | Frames | 3 | $145.00 | $435 | 10/15/25 | 0.2/mo | 2 | Dead Stock |
| SVEP | LNS-ESS-0102 | Essilor | Varilux X | Lenses | 180 | $42.00 | $7,560 | 01/30/26 | 48/mo | 40 | OK |
| LAEC | FRM-PRA-0019 | Prada | PR 17WV | Frames | 4 | $168.00 | $672 | 01/25/26 | 1.8/wk | 8 | Below Reorder |
| AEC | FRM-NKE-0045 | Nike | 7091 | Frames | 18 | $58.00 | $1,044 | 01/29/26 | 4.1/wk | 15 | OK |
| VEO | LNS-ZEI-0088 | Zeiss | SmartLife | Lenses | 92 | $56.00 | $5,152 | 01/30/26 | 32/mo | 30 | OK |
| EKO | FRM-VER-0023 | Versace | VE3186 | Frames | 2 | $195.00 | $390 | 08/20/25 | 0.1/mo | 2 | Dead Stock |
| SVEP | FRM-TIF-0071 | Tiffany | TF2109HB | Frames | 8 | $210.00 | $1,680 | 01/22/26 | 0.8/wk | 4 | OK |
| LAEC | ACC-CAS-0015 | Generic | Hard Case | Accessories | 420 | $3.50 | $1,470 | 01/30/26 | 60/wk | 200 | OK |
| AEC | FRM-COA-0033 | Coach | HC6065 | Frames | 5 | $112.00 | $560 | 01/15/26 | 1.2/wk | 6 | Below Reorder |
| ECH | FRM-MAU-0056 | Maui Jim | Peahi | Sunglasses | 11 | $134.00 | $1,474 | 01/18/26 | 0.5/wk | 4 | OK |
| VEO | CL-ALC-0012 | Alcon | Dailies Total1 | Contact Lenses | 340 | $18.00 | $6,120 | 01/30/26 | 85/mo | 100 | OK |
| SVEP | FRM-TFO-0041 | Tom Ford | FT5401 | Frames | 1 | $248.00 | $248 | 07/12/25 | 0.1/mo | 2 | Dead Stock |
| EKO | LNS-HOY-0099 | Hoya | iD MyStyle | Lenses | 65 | $48.00 | $3,120 | 01/28/26 | 22/mo | 20 | OK |
| LAEC | FRM-BUR-0028 | Burberry | BE2283 | Frames | 3 | $178.00 | $534 | 12/02/25 | 0.3/wk | 4 | Below Reorder |
| AEC | ACC-CLN-0008 | Generic | Lens Wipes 100pk | Accessories | 180 | $4.25 | $765 | 01/30/26 | 40/wk | 80 | OK |
| VEO | FRM-CHN-0062 | Chanel | CH3392 | Frames | 7 | $280.00 | $1,960 | 01/20/26 | 0.6/wk | 3 | OK |
| ECH | FRM-RXS-0039 | Ray-Ban | Aviator | Sunglasses | 9 | $92.00 | $828 | 01/12/26 | 0.8/wk | 4 | OK |
| SVEP | VIT-OCP-0003 | Ocusoft | Retaine MGD | Vitamins | 48 | $22.00 | $1,056 | 01/25/26 | 12/mo | 15 | OK |