使用 10 項庫存資料練習依 Quantity in Stock 由小到大,以及依 Product Category A-Z + Reorder Level 由小到大排序。
庫存管理人員要快速查看低庫存商品,並依產品類別整理後再比較補貨水位。
| Product | Product Category | Quantity in Stock | Reorder Level | Unit Cost |
|---|---|---|---|---|
| Wireless Mouse | Accessories | 85 | 20 | 12 |
| Laptop Stand | Accessories | 34 | 15 | 28 |
| Monitor 24 | Display | 18 | 10 | 145 |
| Keyboard | Accessories | 60 | 25 | 18 |
| USB-C Hub | Accessories | 42 | 12 | 35 |
| Webcam | Camera | 23 | 8 | 52 |
| Printer | Office Equipment | 11 | 5 | 185 |
| SSD 1TB | Storage | 27 | 10 | 88 |
| External HDD | Storage | 19 | 15 | 72 |
| Desk Lamp | Office Equipment | 39 | 18 | 22 |
依 Quantity in Stock 由小到大前五項:
| 名次 | Product | Quantity in Stock | Reorder Level | 差額:Stock - Reorder |
|---|---|---|---|---|
| 1 | Printer | 11 | 5 | 6 |
| 2 | Monitor 24 | 18 | 10 | 8 |
| 3 | External HDD | 19 | 15 | 4 |
| 4 | Webcam | 23 | 8 | 15 |
| 5 | SSD 1TB | 27 | 10 | 17 |
雖然 Printer 的現有庫存最低,但 External HDD 距離其 Reorder Level 只有 4 單位,是這五項中最接近補貨水位者。