a01E_Inventory.xlsx
Sheet1
| Item ID |
Item |
Category |
Campus |
Storage Location |
Price |
Quantity in Stock |
| T-2 |
T-shirt, M |
Clothing |
Southeast |
SE100B |
18.5 |
100 |
| T-3 |
T-shirt, L |
Clothing |
Southeast |
SE100B |
19.5 |
100 |
| T-4 |
T-shirt, XL |
Clothing |
Southeast |
SE100B |
20.5 |
100 |
| T-5 |
T-shirt, XXL |
Clothing |
Southeast |
SE100B |
21.5 |
50 |
| S-1 |
Notebook with logo |
School Supplies |
Southeast |
SE100C |
4.75 |
250 |
| S-2 |
Pen with logo |
School Supplies |
Southeast |
SE100C |
2.25 |
500 |
| S-3 |
Pencil with logo |
School Supplies |
Southeast |
SE100C |
0.75 |
1000 |
| H-1 |
Ball cap with logo |
Clothing |
Southeast |
SE100B |
22.99 |
50 |
| H-2 |
Visor with logo |
Clothing |
Southeast |
SE100B |
11.25 |
50 |
| B-1 |
Baseball with logo |
Sports |
Southeast |
SE100D |
7.5 |
50 |
| B-2 |
Soccer ball with logo |
Sports |
Southeast |
SE100D |
15.99 |
10 |
| WB-1 |
Water bottle with logo |
Miscellaneous |
Southeast |
SE100E |
3.49 |
230 |
| P-1 |
Pennant, small |
Sports |
Southeast |
SE100D |
6 |
100 |
| P-2 |
Pennant, large |
Sports |
Southeast |
SE100D |
12 |
50 |