Excel chapter 4 grader project homework

Inventory 2018
Inventory ID Warehouse Supplier ID Department Amount on Hand Unit Price Inventory Value
18621 Denver 67-1881 Grooming 483 $ 6.00
15639 Denver 12-6662 Clothes 140 $ 8.00
16828 Denver 99-6880 Clothes 41 $ 10.00
19801 Denver 32-3003 Toys 651 $ 10.00
18790 Denver 51-8095 Toys 985 $ 11.00
19074 Denver 83-1147 Grooming 916 $ 12.00
15320 Denver 43-2702 Toys 918 $ 14.00
16432 Denver 41-2655 Food & Health 140 $ 15.00
19007 Denver 7-5363 Clothes 543 $ 16.00
16342 Denver 9-6725 Grooming 498 $ 19.00
19473 Denver 96-1948 Collars & Leashes 712 $ 20.00
17146 Denver 84-9406 Training 129 $ 23.00
18797 Denver 32-6808 Food & Health 437 $ 24.00
18797 Denver 32-6808 Grooming 437 $ 24.00
11711 Denver 24-3362 Grooming 329 $ 28.00
11485 Denver 31-6267 Toys 696 $ 29.00
17007 Denver 43-6210 Training 927 $ 29.00
15472 Denver 54-7909 Toys 408 $ 30.00
19487 Denver 92-8378 Toys 236 $ 32.00
14261 Denver 80-8283 Collars & Leashes 118 $ 33.00
18638 Denver 2-1553 Training 584 $ 33.00
16745 Denver 57-2430 Grooming 632 $ 36.00
16840 Denver 42-9356 Food & Health 386 $ 43.00
17308 Denver 43-3691 Training 994 $ 44.00
13136 Denver 63-2238 Food & Health 23 $ 48.00
15651 Denver 15-6231 Food & Health 680 $ 48.00
13505 Memphis 53-4573 Clothes 818 $ 3.00
13404 Memphis 81-7230 Collars & Leashes 808 $ 6.00
16849 Memphis 80-7774 Collars & Leashes 416 $ 7.00
11178 Memphis 24-3810 Clothes 654 $ 9.00
17973 Memphis 32-1822 Clothes 760 $ 10.00
16437 Memphis 89-3177 Collars & Leashes 836 $ 18.00
19160 Memphis 81-2610 Grooming 38 $ 20.00
12258 Memphis 11-4558 Training 713 $ 21.00
18861 Memphis 83-4623 Food & Health 48 $ 22.00
12672 Memphis 15-8803 Training 196 $ 22.00
16946 Memphis 97-7267 Training 748 $ 31.00
18554 Memphis 43-1802 Training 734 $ 33.00
18455 Memphis 90-8867 Toys 202 $ 38.00
13705 Memphis 21-6324 Toys 445 $ 39.00
12136 Memphis 77-9113 Clothes 46 $ 40.00
12948 Memphis 34-7020 Collars & Leashes 948 $ 49.00
15930 Memphis 6-7306 Toys 569 $ 50.00
11724 Memphis 76-9160 Clothes 485 $ 55.00
12015 Potomac 63-6657 Training 565 $ 3.00
13440 Potomac 4-7732 Toys 547 $ 5.00
18113 Potomac 95-8142 Toys 452 $ 10.00
19859 Potomac 84-3864 Training 393 $ 13.00
11685 Potomac 57-4516 Food & Health 238 $ 16.00
18781 Potomac 2-2476 Toys 632 $ 16.00
17020 Potomac 89-8450 Food & Health 999 $ 22.00
19744 Potomac 10-5462 Grooming 914 $ 22.00
14448 Potomac 53-8404 Grooming 962 $ 23.00
19754 Potomac 23-1749 Clothes 213 $ 24.00
15531 Potomac 66-6754 Clothes 709 $ 26.00
11482 Potomac 62-2793 Toys 231 $ 26.00
11590 Potomac 62-9040 Clothes 440 $ 37.00
16146 Potomac 66-6102 Collars & Leashes 380 $ 41.00
18254 Potomac 33-9096 Food & Health 721 $ 44.00
19784 Potomac 69-3905 Toys 673 $ 45.00
12843 Potomac 2-9636 Food & Health 593 $ 47.00
13822 Potomac 43-5490 Toys 565 $ 51.00
19838 Potomac 26-5867 Training 589 $ 53.00
19483 San Diego 15-5897 Toys 392 $ 5.00
13075 San Diego 53-8846 Collars & Leashes 692 $ 8.00
12832 San Diego 13-9209 Collars & Leashes 294 $ 16.00
11320 San Diego 40-1780 Grooming 470 $ 16.00
12832 San Diego 13-9209 Grooming 294 $ 16.00
14016 San Diego 23-6766 Toys 38 $ 22.00
17513 San Diego 66-4757 Collars & Leashes 147 $ 24.00
12806 San Diego 58-4302 Toys 553 $ 28.00
11867 San Diego 55-2458 Food & Health 448 $ 31.00
18698 San Diego 43-2218 Collars & Leashes 989 $ 40.00
11292 San Diego 43-5660 Collars & Leashes 82 $ 42.00
15687 San Diego 7-6023 Collars & Leashes 387 $ 42.00
14636 San Diego 74-3227 Grooming 677 $ 44.00
14184 San Diego 72-7913 Grooming 805 $ 50.00