Inventory Report
Complete inventory status showing stock levels, locations, and valuations
Filters
| Product Code | Product Name | Category | Location | Qty on Hand | Unit Cost | Total Value | Reorder Level |
|---|---|---|---|---|---|---|---|
| RET-LUM-001 | Coco Lumber 2x3x12 (Retail) | Lumber & Wood | Main Store | 300 | ₱120.00 | ₱36,000.00 | 100 |
| RET-NL-001 | Common Wire Nail 4" (Retail) | General Hardware | Main Store | 100 | ₱85.00 | ₱8,500.00 | 50 |
| RET-STL-001 | Deformed Bar 10mm (Retail) | Steel & Metals | Main Store | 200 | ₱180.00 | ₱36,000.00 | 100 |
| RET-STL-001 | Deformed Bar 10mm (Retail) | Steel & Metals | Back Warehouse | 400 | ₱180.00 | ₱72,000.00 | 150 |
| RET-STL-002 | Deformed Bar 12mm (Retail) | Steel & Metals | Main Store | 120 | ₱250.00 | ₱30,000.00 | 50 |
| RET-PNT-001 | Latex Paint White (Retail) | Paint & Finishes | Main Store | 25 | ₱550.00 | ₱13,750.00 | 10 |
| RET-CEM-001 | Portland Cement (Retail) | Cement & Concrete | Main Store | 150 | ₱280.00 | ₱42,000.00 | 50 |
| RET-CEM-001 | Portland Cement (Retail) | Cement & Concrete | Back Warehouse | 500 | ₱280.00 | ₱140,000.00 | 100 |
| RET-PVC-001 | PVC Pipe 4" (Retail) | Plumbing Supplies | Main Store | 80 | ₱280.00 | ₱22,400.00 | 30 |
| RET-ELC-001 | THHN Wire #12 (Retail) | Electrical Supplies | Main Store | 500 | ₱22.00 | ₱11,000.00 | 200 |
| Totals: | 10 | ₱411,650.00 | |||||