| Thunder City Bookstore |
| Manager: Roger Harding |
| Inventory Item | Price per Unit | Quantity in Stock |
| Clothing |
| Gym shorts (s) | $15.99 | 5 |
| Gym shorts (m) | $15.99 | 20 |
| Gym shorts (l) | $15.99 | 25 |
| Gym shorts (xl) | $15.99 | 12 |
| Sweatpants (s) | $24.99 | 20 |
| Sweatpants (m) | $24.99 | 25 |
| Sweatpants (l) | $24.99 | 10 |
| Sweatpants (xl) | $24.99 | 15 |
| T-shirts (s) | $12.99 | 30 |
| T-shirts (m) | $12.99 | 45 |
| T-shirts (l) | $12.99 | 30 |
| T-shirts (xl) | $12.99 | 28 |
| Sweatshirts (s) | $39.99 | 20 |
| Sweatshirts (m) | $39.99 | 15 |
| Sweatshirts (l) | $39.99 | 25 |
| Sweatshirts (xl) | $39.99 | 3 |
| Class Supplies |
| Pen (pack of 10) | $2.50 | 100 |
| Pencil (pack of 10) | $5.49 | 75 |
| Notebook | $0.79 | 250 |
| Review cards
(individually laminated 5x7 cards with a summary of course content) | $2.00 | 200 |
| Calendars | $4.99 | 50 |
| Mouse pads | $3.99 | 5 |
| Miscellaneous |
| Coffee mug | $4.50 | 100 |
| Digital frame (3x5) | $24.99 | 25 |
| Digital frame (5x7) | $34.99 | 35 |
| Key chains | $2.50 | 150 |
| Water bottles | $3.00 | 200 |
| Inventory Overview |
| Number of tems in inventory |
| Average price of an item in inventory |
| Highest price of an item in inventory |
| Lowest price of an item in inventory |
ahabuloshi
Albalushi_e01ch02_grader_a1_TCBInventory.xlsx
