Excel Expert
ahabuloshi
e01ch01_grader_a1_Athletics_Albalushi.xlsxSheet1
| All Sports Athletics | |||||||||||
| Men's Clothing | Price per Unit | Quantity in Stock | Total Cost of Inventory | Price per Unit | Quantity in Stock | Total Cost of Inventory | Price per Unit | Quantity in Stock | Total Cost of Inventory | ||
| T-shirts (s) | 15.99 | 26 | $ 415.74 | Athletic shorts (s) | 16.99 | 27 | $ 458.73 | Calf-high socks | 8.99 | 25 | $ 224.75 |
| T-shirts (m) | 15.99 | 20 | $ 319.80 | Athletic shorts (m) | 16.99 | 22 | $ 373.78 | Ankle socks | 8.99 | 24 | $ 215.76 |
| T-shirts (l) | 15.99 | 25 | $ 399.75 | Athletic shorts (l) | 16.99 | 19 | $ 322.81 | Compression socks | 15.99 | 10 | $ 159.90 |
| T-shirts (xl) | 15.99 | 12 | $ 191.88 | Athletic shorts (xl) | 16.99 | 24 | $ 407.76 | ||||
| Women's Clothing | Price per Unit | Quantity in Stock | Total Cost of Inventory | Price per Unit | Quantity in Stock | Total Cost of Inventory | Price per Unit | Quantity in Stock | Total Cost of Inventory | ||
| T-shirts (xs) | 14.99 | 18 | $ 269.82 | Athletic shorts (xs) | 16.99 | 16 | $ 271.84 | Calf-high socks | 8.99 | 29 | $ 260.71 |
| T-shirts (s) | 14.99 | 20 | $ 299.80 | Athletic shorts (s) | 16.99 | 22 | $ 373.78 | Ankle socks | 8.99 | 18 | $ 161.82 |
| T-shirts (m) | 14.99 | 25 | $ 374.75 | Athletic shorts (m) | 16.99 | 25 | $ 424.75 | Compression socks | 15.99 | 5 | $ 79.95 |
| T-shirts (l) | 14.99 | 10 | $ 149.90 | Athletic shorts (l) | 16.99 | 20 | $ 339.80 | ||||
| T-shirts (xl) | 14.99 | 25 | $ 374.75 | Athletic shorts (xl) | 16.99 | 27 | $ 458.73 | ||||
| Other Items | Price per Unit | Quantity in Stock | Total Cost of Inventory | ||||||||
| Basketballs | 25.99 | 10 | $ 259.90 | ||||||||
| Soccer balls | 22.99 | 14 | |||||||||
| Volleyballs | 17.99 | 17 | |||||||||
| Tennis balls | 13.99 | 15 | |||||||||
| Footballs | 19.99 | 18 | |||||||||
| Racquetballs | 12.99 | 12 | |||||||||
| Miscellaneous Items | Price per Unit | Quantity in Stock | Total Cost of Inventory | ||||||||
| Water bottles | 4.5 | 55 | $ 247.50 | ||||||||
| Headbands | 4.5 | 38 | |||||||||
| Gym bags | 19 | 32 |
Sheet2
| All Sports Athletics | |||
| Back Order Tracking | |||
| Inventory Item Back-ordered | Quantity Ordered | Date Ordered | Date to be Received |
| Baseball bats | 15 | ||
| Mouth guards | 25 | ||
| Soccer nets | 15 | ||
Documentation
| All Sports Athletics | |||
| Create Date | By Whom | Description | Workbook Name |
| 12/18/18 | Darin Learn | Inventory workbook | e01ch01Athletics_solution.xlsx |
| Mod. Date | By Whom | Mod. Description | Last Version Backup Name : VERSION BACKUP NAME : Before modifying any worksheet, save the original workbook with the following name format: Original name_yyyymmdd |
| Create Date | Sheet Name | Creator | Purpose |
| 12/18/18 | Sheet1 | Darin Learn | List and prices of inventory items |
| 12/18/18 | Sheet2 | Darin Learn | Items on back order; date of expected delivery |
