project_1_parts_inventory.xlsx
Parts Inventory
| Part ID | Part | Room | Cabinet Location | Vendor ID | Price | Quantity in Stock |
| T-01 | Tower Case | SE110 | Cabinet B, Shelf 1 | V-010 | 79.99 | 3 |
| P-02 | CPU | SE110 | Drawer C | V-010 | 199.99 | 2 |
| P-03 | CPU Cooler Bracket | SE110 | Drawer C | V-010 | 22.99 | 7 |
| V-02 | Video Card | SE110 | Drawer B | V-015 | 144.99 | 3 |
| M-01 | Mouse, Wired | SE110 | Drawer D | V-003 | 49 | 20 |
| D-01 | Hard Drive | SE110 | Drawer E | V-012 | 169.99 | 5 |
| R-01 | RAM, 8GB | SE110 | Drawer F | V-013 | 125 | 4 |
| B-01 | Motherboard | SE110 | Cabinet A, Shelf 1 | V-009 | 209.99 | 3 |
| C-01 | Cables, Power Supply | SE110 | Drawer G | V-008 | 3.99 | 10 |
| C-02 | Cables, Hard Drive | SE110 | Drawer G | V-008 | 4.99 | 10 |
liuyao1008
