Inventory control for your warehouse
| No. | Type | Product | Qty | Area |
|---|---|---|---|---|
| E-1042 | Inbound | THW wire #12 | +200 | Warehouse 1 |
| S-2210 | Outbound | LED bulb 9W | -24 | Sales |
| S-2209 | Outbound | 1/4" screws | -2 | Shop |
| SKU | Product | Category | Location | Stock | Status |
|---|---|---|---|---|---|
| EL-0091 | THW wire #12 | Electrical | Rack A-3 | 240 | OK |
| EL-0104 | LED bulb 9W | Electrical | Rack A-7 | 6 | Critical |
| FE-0210 | 1/4" screws (box) | Hardware | Rack B-1 | 18 | Reorder |
| PL-0033 | Teflon tape | Plumbing | Rack C-2 | 22 | Reorder |
| HE-0501 | 1/2 HP drill | Tools | Rack D-4 | 9 | OK |
| PL-0048 | PVC elbow 3/4" | Plumbing | Rack C-5 | 310 | OK |
| Product | Stock | Minimum | Suggested | Supplier |
|---|---|---|---|---|
| LED bulb 9W | 6 | 30 | 48 | Sun Distributing |
| 1/4" screws | 18 | 20 | 40 | Midwest Steel |
| Teflon tape | 22 | 25 | 30 | Plastics USA |
| Supplier | Products | Credit days | Rating |
|---|---|---|---|
| Sun Distributing | 128 | 15 | β β β β β |
| Midwest Steel | 64 | 30 | β β β β β |
| Plastics USA | 41 | 45 | β β β ββ |