Exp22_Excel_Ch04_ML1 - EBL Sporting Goods 1.1

profileSolutions Aplus
Stanley_EXP22_Excel_Ch04_ML1_Inventory.xlsx
Home>Computer Science homework help>Exp22_Excel_Ch04_ML1 - EBL Sporting Goods 1.1

Inventory

Inventory ID Warehouse Supplier ID Department Amount on Hand Unit Price Inventory Value
11178 Memphis 24-3810 Athletic Apparel 193 $ 9.00
11292 San Diego 43-5660 Outdoor Gear 210 $ 42.00
11320 San Diego 40-1780 Fitness 245 $ 16.00
11482 Dallas 62-2793 Toys 54 $ 26.00
11590 Dallas 62-9040 Athletic Apparel 14 $ 37.00
18621 Denver 67-1881 Fitness 135 $ 6.00
11590 Dallas 62-9040 Athletic Apparel 126 $ 37.00
11685 Dallas 57-4516 Footwear 239 $ 16.00
15639 Denver 12-6662 Athletic Apparel 70 $ 8.00
11724 Memphis 76-9160 Athletic Apparel 79 $ 55.00
16828 Denver 99-6880 Athletic Apparel 264 $ 10.00
11867 San Diego 55-2458 Footwear 4 $ 31.00
12015 Dallas 63-6657 Training 65 $ 3.00
19801 Denver 32-3003 Toys 172 $ 10.00
18790 Denver 51-8095 Toys 225 $ 11.00
19074 Denver 83-1147 Fitness 188 $ 12.00
12136 Memphis 77-9113 Athletic Apparel 86 $ 40.00
15320 Denver 43-2702 Toys 124 $ 14.00
16432 Denver 41-2655 Footwear 295 $ 15.00
12258 Memphis 11-4558 Training 79 $ 21.00
12672 Memphis 15-8803 Training 96 $ 22.00
12806 San Diego 58-4302 Toys 25 $ 28.00
12832 San Diego 13-9209 Fitness 66 $ 16.00
12832 San Diego 13-9209 Outdoor Gear 54 $ 16.00
19007 Denver 7-5363 Athletic Apparel 118 $ 16.00
12843 Dallas 2-9636 Footwear 63 $ 47.00
16342 Denver 9-6725 Fitness 275 $ 19.00
12948 Memphis 34-7020 Outdoor Gear 49 $ 49.00
19473 Denver 96-1948 Outdoor Gear 16 $ 20.00
13075 San Diego 53-8846 Outdoor Gear 181 $ 8.00
13404 Memphis 81-7230 Outdoor Gear 115 $ 6.00
13404 Memphis 81-7230 Outdoor Gear 115 $ 6.00
13440 Dallas 4-7732 Toys 232 $ 5.00
13505 Memphis 53-4573 Athletic Apparel 163 $ 3.00
13705 Memphis 21-6324 Toys 106 $ 39.00
13822 Dallas 43-5490 Toys 13 $ 51.00
14016 San Diego 23-6766 Toys 117 $ 22.00
17146 Denver 84-9406 Training 286 $ 23.00
14184 San Diego 72-7913 Fitness 53 $ 50.00
18797 Denver 32-6808 Footwear 289 $ 24.00
18797 Denver 32-6808 Fitness 183 $ 24.00
14448 Dallas 53-8404 Fitness 203 $ 23.00
14636 San Diego 74-3227 Fitness 25 $ 44.00
15531 Dallas 66-6754 Athletic Apparel 167 $ 26.00
11711 Denver 24-3362 Fitness 251 $ 28.00
15687 San Diego 7-6023 Outdoor Gear 57 $ 42.00
11485 Denver 31-6267 Toys 23 $ 29.00
17007 Denver 43-6210 Training 273 $ 29.00
15472 Denver 54-7909 Toys 141 $ 30.00
15930 Memphis 6-7306 Toys 243 $ 50.00
16146 Dallas 66-6102 Outdoor Gear 219 $ 41.00
19487 Denver 92-8378 Toys 232 $ 32.00
14261 Denver 80-8283 Outdoor Gear 68 $ 33.00
16437 Memphis 89-3177 Outdoor Gear 83 $ 18.00
18638 Denver 2-1553 Training 50 $ 33.00
16745 Denver 57-2430 Fitness 219 $ 36.00
16849 Memphis 80-7774 Outdoor Gear 235 $ 7.00
16946 Memphis 97-7267 Training 189 $ 31.00
17020 Dallas 89-8450 Footwear 54 $ 22.00
17513 San Diego 66-4757 Outdoor Gear 110 $ 24.00
17973 Memphis 32-1822 Athletic Apparel 64 $ 10.00
18113 Dallas 95-8142 Toys 125 $ 10.00
18254 Dallas 33-9096 Footwear 20 $ 44.00
18455 Memphis 90-8867 Toys 204 $ 38.00
18554 Memphis 43-1802 Training 88 $ 33.00
16840 Denver 42-9356 Footwear 42 $ 43.00
18698 San Diego 43-2218 Outdoor Gear 252 $ 40.00
17308 Denver 43-3691 Training 110 $ 44.00
18781 Dallas 2-2476 Toys 170 $ 16.00
18861 Memphis 83-4623 Footwear 130 $ 22.00
19160 Memphis 81-2610 Fitness 28 $ 20.00
13136 Denver 63-2238 Footwear 36 $ 48.00
15651 Denver 15-6231 Footwear 165 $ 48.00
19483 San Diego 15-5897 Toys 94 $ 5.00
19744 Dallas 10-5462 Fitness 202 $ 22.00
19754 Dallas 23-1749 Athletic Apparel 150 $ 24.00
19784 Dallas 69-3905 Toys 279 $ 45.00
19838 Dallas 26-5867 Training 20 $ 53.00
19859 Dallas 84-3864 Training 92 $ 13.00