Excel assignment based on the data provided in the screen shots.

1. Find the Min, Max and Avg of Unit Sell Price
2. Find the Ship mode of SKU821 using Vlookup function
3. Find the Discount of OrderID 4183 using Index function
4. Find the Shipping Amount of OrderID 2361 using Index, match functions both. So that we can find the value of another OrderID.
5. Convert Ship Date into Long format(Text function

Q18 fx A B D E G H M N 0 Q R S U C Ship Date Order Quantity 9 32 3 | Max Avg Min 4 Unit Sell Price 95.99 5.98 40.98 291.73 100.98 155.06 9.11 15.04 5.28 43 32 16 43 VLOOKUP SKU338 110.99 15 8 29 4 12 49 12 INDEX 4183 INDEX-MATCH 2361) 1 Order ID Customer ID 2 947 C508 3 3237 C372 4 363 0212 5 452 2015 6 4363 0015 7 3202 2015 8 1657 0256 9 4303 C256 10 1531 c089 11 8244 0089 12 2952 0591 13 435 C591 14 1289 C036 15 49128 C036 16 1293 0036 17 2966 C023 18 1283 0453 19 4124 0042 20 1770 0735 21 4240 C735 22 373 C206 23 6092 0731 24 6034 C507 25 11148 C507 26 557 0495 27 2156 C602 28 4183 C602 29 33123 0602 30 4365 0199 31 2954 C199 32 4802 C199 33 4951 C199 34 25143 C199 35 2478 0241 36 4337 0780 37 2367 0648 38 3022 0408 Salesperson Bob John Bob Bob Bob Richard John John John John Richard John John Bob Richard Richard Bob John Bob John Bob Richard Richard Bob Bob John John John Richard Richard Richard Richard Bob John Richard Bob John Order Date Order Priority 1/1/14 Not Specified 1/1/14 High 2/1/14 Critical 2/1/14 Low 2/1/14 Low 2/1/14 Low 2/1/14 Critical 2/1/14 Critical 3/1/14 Critical 3/1/14 Critical 3/1/14 High 3/1/14 High 3/1/14 Low 3/1/14 Low 3/1/14 Low 3/1/14 High 3/1/14 High 3/1/14 Not Specified 4/1/14 Critical 4/1/14 Critical 4/1/14 High 5/1/14 High 5/1/14 High 5/1/14 High 5/1/14 Not Specified 5/1/14 Critical 5/1/14 Critical 5/1/14 Critical 5/1/14 Critical 5/1/14 Critical 5/1/14 Critical 5/1/14 Critical 5/1/14 Critical 5/1/14 Not Specified 5/1/14 Medium 5/1/14 High 6/1/14 Critical SKU SKU947 SKU937 SKU363 SKU052 SKU063 SKU902 SKU557 SKU603 SKU731 SKU1244 SKU352 SKU235 SKU989 SKU1128 SKU593 SKU766 SKU083 SKU1124 SKU370 SKU540 SKUO73 SKU1092 SKU1034 SKU1148 SKU057 SKU156 SKU183 SKU1123 SKU065 SKUO54 SKU202 SKU251 SKU1143 SKU578 SKU937 SKU567 SKUO22 29 12 4 17 42 3 Discount Shipping Amount Ship Mode Product Container 0.08 35 Express Air Large Box 0.1 4.69 Regular Air Small Box 0.06 2.99 Regular Air Small Box 0.02 48.8 Delivery Truck Jumbo Drum 0.07 45 Delivery Truck Jumbo Drum 0.05 7.07 Regular Air Small Box 0.09 2.15 Express Air Wrap Bag 0.08 1.97 Regular Air Wrap Bag 0.03 5.66 Regular Air Small Box 0.01 2.5 Regular Air Small Box 0.03 2.99 Regular Air Small Box 0.09 52.2 Delivery Truck Jumbo Box 0.08 16.71 Regular Air Small Box 0.05 24.49 Regular Air Large Box 0.04 2.27 Regular Air Wrap Bag 0.03 1.2 Regular Air Wrap Bag 0.05 21.2 Regular Air Medium Box 0.02 14.7 Delivery Truck Jumbo Drum 0.03 6.27 Regular Air Small Box 0.07 1.93 Express Air Wrap Bag 0.06 30 Delivery Truck Jumbo Drum 0.08 26.3 Delivery Truck Jumbo Drum 0.03 1.99 Regular Air Small Pack 0.01 5.99 Regular Air Small Box 0.08 43.32 Delivery Truck Jumbo Drum 0.01 11.54 Regular Air Large Box 0.02 21.21 Regular Air Large Box 0.02 17.85 Delivery Truck Jumbo Drum 0.08 0.75 Regular Air Jumbo Drum 0.06 53.03 Delivery Truck Jumbo Drum 0.07 35 Regular Air Large Box 0.08 5.68 Regular Air Jumbo Box 0.04 5.26 Regular Air Small Box 0.05 5.83 Regular Air Wrap Bag 0.09 4.69 Regular Air Small Box 0.02 5.76 Regular Air Small Box 0.04 44.55 Delivery Truck Jumbo Box Ship Date 1/3/14 1/2/14 1/4/14 1/2/14 1/4/14 1/9/14 1/4/14 1/2/14 1/5/14 1/6/14 1/4/14 1/4/14 1/5/14 1/10/14 1/7/14 1/4/14 1/4/14 1/5/14 1/5/14 1/6/14 1/5/14 1/7/14 1/6/14 1/7/14 1/6/14 1/7/14 1/6/14 1/7/14 1/6/14 1/7/14 1/5/14 1/6/14 1/5/14 1/6/14 1/6/14 1/7/14 1/7/14 5.58 212.6 43.22 574.74 10.14 4.26 20.98 213.45 3.36 3.71 350.98 120.97 28.48 205.99 243.98 194.3 209.84 145.45 1.81 20.98 279.48 4.91 125.99 7.64 5.98 30.98 880.98 6 6 11 5 21 41 33 43 29 48 49 25 24 43 23 30 Q18 A B C D E F G H I J K L M N O P Q R S T 0.02 0.07 0.05 0.01 0.01 0.03 0.03 0.06 0.01 0.09 Small Pack 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 2308 C177 112 0784 1969 0784 2368 C181 4606 C181 2194 C181 1721 0555 2778 0771 3429 0771 4627 0493 663 0493 2901 C406 11209 C602 3033 0302 2022 C302 681 C411 359 C359 3074 C359 7130 C359 34209 C084 4699 C148 1613 C673 365 C673 2361 0482 2591 C662 901 C398 4734 0584 2499 0498 3935 C794 1225 0083 4350 C188 1138 0498 4497 0498 3112 C450 4879 C450 3281 C692 4388 0489 323 0489 Richard Richard Bob Richard Richard John Bob John John Richard John Bob Richard Richard Bob Richard Richard Richard Bob Richard Bob John John Bob Richard Richard Richard Bob John Bob Bob John Richard John John Bob Bob Richard 6/1/14 Low 6/1/14 Medium 6/1/14 Medium 6/1/14 Not Specified 6/1/14 Not Specified 6/1/14 Not Specified 6/1/14 Critical 6/1/14 Not Specified 6/1/14 Not Specified 6/1/14 Low 6/1/14 Low 6/1/14 High 7/1/14 High 7/1/14 Medium 7/1/14 Medium 7/1/14 Low 7/1/14 Medium 7/1/14 Medium 7/1/14 Medium 7/1/14 Low 7/1/14 High 8/1/14 High 8/1/14 High 8/1/14 Not Specified 8/1/14 High 9/1/14 Not Specified 9/1/14 Low 9/1/14 Not Specified 9/1/14 Not Specified 9/1/14 Low 9/1/14 High 9/1/14 Not Specified 9/1/14 Not Specified 10/1/14 Critical 10/1/14 Critical 10/1/14 Critical 10/1/14 Low 10/1/14 Low SKU008 SKU412 SKU169 SKU068 SKU906 SKU1194 SKU821 SKU978 SKU629 SKU727 SKU963 SKU801 SKU1209 SKU433 SKU1022 SKU781 SKU359 SKU1074 SKU1130 SKU1209 SKU399 SKU513 SKU165 SKU261 SKU391 SKU501 SKU734 SKU799 SKU835 SKU1225 SKU750 SKU338 SKU797 SKUO12 SKU779 23 1 1 19 23 46 2 17 27 34 46 6 29 11 30 2 6 3 3 7 34 46 16 3 23 25 9 47 24 39 1 43 11 44 31 48 32 43 3 100.98 7.68 6.64 150.98 28.28 35.99 2.1 1.7 30.98 6.48 20.34 3.28 65.99 20.98 73.98 1.76 1.98 699.99 6783.02 65.99 15.99 4.13 22.72 14.56 896.99 4.13 2.6 2.78 3.29 125.99 11.66 5.38 3.28 70.98 11.55 162.93 30.42 161.55 0.05 0.03 0.07 0.09 0.03 0.01 0.05 0.07 0.07 0.05 0.08 0.07 0.03 35.84 Delivery Truck Jumbo Box 6.16 Express Air Small Box 4.95 Express Air Small Pack 30 Delivery Truck Jumbo Drum 13.99 Express Air Medium Box 1.1 Regular Air Small Box 0.7 Regular Air Wrap Bag 1.99 Regular Air 5.09 Regular Air Small Box 8.73 Regular Air Small Box 35 Regular Air Large Box 3.97 Regular Air Wrap Bag 5.99 Regular Air Small Box 8.83 Express Air Small Box 14.52 Regular Air Small Box 0.7 Regular Air Wrap Bag 4.77 Regular Air Small Box 24.49 Express Air Large Box 24.49 Regular Air Large Box 5.99 Regular Air Small Box 13.18 Regular Air Small Box 0.99 Regular Air Small Box 8.99 Regular Air Small Pack 3.5 Regular Air Small Box 19.99 Regular Air Small Box 6.89 Regular Air Small Box 2.4 Regular Air Wrap Bag 0.97 Regular Air Wrap Bag 1.35 Regular Air Wrap Bag 8.99 Regular Air Small Box 8.99 Express Air Small Pack 7.57 Regular Air Small Box 3.97 Regular Air Wrap Bag 46.74 Delivery Truck Jumbo Box 2.36 Regular Air Wrap Bag 19.99 Regular Air Small Box 8.65 Express Air Small Box 19.99 Express Air Small Box 1/6/14 1/8/14 1/8/14 1/8/14 1/8/14 1/7/14 1/7/14 1/7/14 1/8/14 1/8/14 1/10/14 1/8/14 1/8/14 1/9/14 1/10/14 1/12/14 1/8/14 1/8/14 1/8/14 1/11/14 1/8/14 1/8/14 1/8/14 1/9/14 1/10/14 1/10/14 1/14/14 1/11/14 1/11/14 1/16/14 1/11/14 1/10/14 1/9/14 1/11/14 1/12/14 1/12/14 1/14/14 1/12/14 0.07 0.03 0.02 0.1 0.09 0.07 0.04 0.02 0.01 0.05 0.05 0.05 0.09 SKU481 SKU988 SKU923 0.05 0.01 Q18 A B B C D E F . K L M N O P Q R S T 1/12/14 77 78 79 SKU122 SKU797 SKU1012 SKU1016 SKU120 SKU1125 SKU705 SKU1063 24 19 30 34 35 1/11/14 1/11/14 1/11/14 1/15/14 80 81 82 83 1/15/14 49 16 31 20 84 SKU1125 85 86 87 88 89 0.01 0.06 0.02 0.02 0.02 0.03 0.02 0.06 0.08 0.02 0.06 0.05 0.03 0.08 0.01 0.03 0.04 0.09 90 2422 C201 1997 C201 30012 C642 34016 C307 3520 0539 49125 C539 1605 0042 31063 0011 20125 C101 4409 C101 1800 C101 2937 C101 1812 C101 19116 0035 2773 C320 4573 C637 3312 C637 4022 0167 10054 C475 1245 C315 2864 C315 4445 C315 1752 0537 5031 0545 3123 C112 1338 C112 2709 C174 23115 C174 1359 0174 1458 0758 897 0758 311 0758 1496 0758 21108 C367 2796 C367 2902 0736 36122 0736 2353 0736 0.1 Richard Richard Bob John Bob Richard John John Richard Richard John Bob Bob Richard Richard John Richard Bob Richard John Bob John Richard Richard Bob John John John Bob Richard Bob Bob Richard Bob John John Richard Richard 18 29 18 19 27 45 33 40 10 12 28 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 10/1/14 Critical 10/1/14 Critical 10/1/14 Medium 10/1/14 High 10/1/14 Low 10/1/14 Low 10/1/14 Not Specified 11/1/14 High 11/1/14 Not Specified 11/1/14 Not Specified 11/1/14 Not Specified 11/1/14 Not Specified 11/1/14 Not Specified 11/1/14 Low 12/1/14 Not Specified 12/1/14 Critical 12/1/14 Critical 12/1/14 Not Specified 12/1/14 Medium 12/1/14 Low 12/1/14 Low 12/1/14 Low 13/01/2014 Critical 13/01/2014 Low 13/01/2014 Low 13/01/2014 Low 14/01/2014 Critical 14/01/2014 Critical 14/01/2014 Critical 14/01/2014 Not Specified 14/01/2014 Not Specified 14/01/2014 Not Specified 14/01/2014 Not Specified 14/01/2014 Critical 14/01/2014 Critical 14/01/2014 Medium 14/01/2014 Medium 14/01/2014 Medium SKU209 SKU300 SKU137 SKU612 SKU1116 SKU273 SKUO7 SKU812 SKU922 SKU1054 SKU045 SKU464 SKU845 SKU152 SKU631 SKU1123 SKU638 SKU309 SKU1115 SKU659 SKU258 SKU497 SKU111 SKU796 SKU1108 SKU796 SKU202 SKU1122 SKU053 8.34 3.28 5.02 33.98 29.18 297.64 6.48 39.24 297.64 12.99 14.42 4.14 11.34 399.98 59.98 350.98 1.68 27.75 40.98 350.99 8.74 1.98 2.08 5.98 145.45 48.04 7.77 306.14 18.97 208.16 90.48 9.48 4.28 115.99 4.28 19.99 264.98 320.98 0.96 Regular Air Wrap Bag 3.97 Regular Air Wrap Bag 5.14 Regular Air Small Pack 1.99 Regular Air Small Pack 8.55 Regular Air Small Box 14.7 Delivery Truck Jumbo Drum 9.17 Regular Air Small Box 1.99 Regular Air Small Pack 14.7 Delivery Truck Jumbo Drum 14.37 Regular Air Large Box 6.75 Regular Air Medium Box 6.6 Express Air Small Box 5.01 Regular Air Small Box 12.06 Delivery Truck Jumbo Box 3.99 Regular Air Small Box 30 Delivery Truck Jumbo Drum 1 Regular Air Wrap Bag 19.99 Regular Air Small Box 6.5 Regular Air Small Box 39 Delivery Truck Jumbo Drum 1.39 Regular Air Small Box 0.7 Regular Air Wrap Bag 5.33 Regular Air Small Box 5.79 Regular Air Small Box 17.85 Delivery Truck Jumbo Drum 5.09 Regular Air Small Box 9.23 Regular Air Small Box 26.53 Delivery Truck Jumbo Drum 9.54 Express Air Small Box 68.02 Delivery Truck Jumbo Drum 19.99 Regular Air Small Box 7.29 Express Air Small Pack 0.94 Regular Air Wrap Bag 56.14 Delivery Truck Jumbo Drum 0.94 Regular Air Wrap Bag 11.17 Regular Air Large Box 17.86 Delivery Truck Jumbo Drum 58.95 Delivery Truck Jumbo Drum 1/11/14 1/12/14 1/11/14 1/12/14 1/12/14 1/13/14 1/11/14 1/18/14 1/15/14 1/15/14 1/14/14 1/13/14 1/14/14 1/14/14 1/16/14 1/16/14 1/13/14 1/15/14 1/18/14 1/13/14 1/16/14 1/14/14 0.05 0.02 0.02 0.06 0.07 0.03 44 17 50 3 13 27 23 13 14 0.02 0.08 0.02 0.1 0.1 0.07 1/16/14 0.01 0.02 0.08 8 3 14 21 27 29 36 23 1/14/14 1/15/14 1/16/14 1/15/14 1/16/14 1/17/14 1/14/14 1/15/14 1/16/14 0.08 0.06 0.02 0.06 Q18 B C F G H I J N 0 P Q R S T 41 47 48 7 25 4.98 6.35 8.6 7.04 8.09 0.01 0.04 0.02 0.06 0.08 0.09 2.88 5.81 1.81 110.98 8.01 2.18 179.29 0.1 0.03 0.02 0.01 0.09 2.98 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 . 4164 C706 4796 0706 4858 C308 706 C030 2587 0366 995 C031 4679 0733 4142 0733 694 0677 3097 0677 3662 C358 227 C358 2013 0793 25225 0793 3517 0384 3765 C152 4002 C131 4688 C131 2579 0599 2424 0084 33031 C392 397 0426 2600 C426 1301 C386 1168 C386 3957 0625 1887 C599 3163 0599 4768 C266 2545 0449 20085 0449 5045 0562 1283 C449 2920 C449 1759 0449 558 C149 1821 6722 Richard John Richard Bob John John Bob Richard Bob Richard Richard Bob John Bob Richard Richard John Bob Richard Richard Bob Richard John Bob Richard John John John Bob Bob John Richard Bob John John John Richard D E 15/01/2014 Low 15/01/2014 Low 15/01/2014 Not Specified 15/01/2014 Medium 15/01/2014 High 15/01/2014 Critical 16/01/2014 Medium 16/01/2014 Medium 16/01/2014 Critical 16/01/2014 Critical 16/01/2014 Critical 16/01/2014 Critical 16/01/2014 Low 16/01/2014 Low 16/01/2014 Medium 16/01/2014 Low 17/01/2014 Critical 17/01/2014 Critical 17/01/2014 Medium 17/01/2014 Medium 17/01/2014 Medium 17/01/2014 Medium 17/01/2014 Medium 17/01/2014 Medium 17/01/2014 Medium 17/01/2014 Not Specified 17/01/2014 Medium 17/01/2014 Medium 18/01/2014 Not Specified 18/01/2014 Medium 18/01/2014 Medium 18/01/2014 High 18/01/2014 18/01/2014 Medium 18/01/2014 Medium 19/01/2014 Critical 19/01/2014 Critical SKU564 SKU596 SKU358 SKU606 SKU087 SKU795 SKU379 SKU842 SKU194 SKU597 SKU862 SKU227 SKU813 SKU1225 SKU917 SKU165 SKU502 SKU788 SKU779 SKU324 SKU1031 SKU497 SKU700 SKU301 SKU568 SKU757 SKU487 SKU1163 SKU468 SKU045 SKU1085 SKU345 SKU483 SKU620 SKU959 SKU558 SKU321 9 46 41 6 30 36 2 2 20 25 35 37 40 46 25 24 33 3 3 0.05 0.04 0.01 0.02 0.04 0.08 0.01 0.1 0.05 0.06 K L 4.75 Regular Air Small Box 1.02 Regular Air Wrap Bag 6.19 Regular Air Small Box 2.17 Regular Air Wrap Bag 7.96 Express Air Small Box 0.7 Regular Air Wrap Bag 8.49 Regular Air Small Box 0.75 Regular Air Wrap Bag 13.99 Regular Air Medium Box 2.87 Regular Air Wrap Bag 0.78 Regular Air Wrap Bag 29.21 Delivery Truck Jumbo Box 2.03 Express Air Wrap Bag 8.99 Regular Air Small Box 5.5 Regular Air Small Box 8.99 Regular Air Small Pack 19.99 Regular Air Small Box 1.57 Regular Air Wrap Bag 2.36 Regular Air Wrap Bag 91.05 Delivery Truck Jumbo Drum 1.99 Regular Air Small Pack 19.99 Regular Air Small Box 8.18 Regular Air Small Box 13.32 Regular Air Small Box 2.26 Express Air Wrap Bag 6.17 Regular Air Small Pack 1.39 Regular Air Small Box 2.5 Regular Air Small Box 1.39 Regular Air Small Box 39 Delivery Truck Jumbo Drum 9.4 Express Air Small Box 1.49 Regular Air Small Box 5.72 Regular Air Small Box 5.81 Regular Air Small Box 17.78 Regular Air Small Box 9.03 Regular Air Small Box 0.99 Regular Air Small Box 125.99 13.43 22.72 30.53 1.68 11.55 328.14 16.48 90.48 22.84 14.81 4.2 28.15 7.64 125.99 15.74 350.99 15.99 58.1 11.58 48.91 15.51 18.97 207.48 M 1/20/14 1/20/14 1/15/14 1/17/14 1/16/14 1/16/14 1/17/14 1/17/14 1/18/14 1/18/14 1/18/14 1/18/14 1/16/14 1/21/14 1/17/14 1/20/14 1/17/14 1/19/14 1/18/14 1/19/14 1/19/14 1/19/14 1/17/14 1/20/14 1/19/14 1/18/14 1/19/14 1/19/14 1/21/14 1/20/14 1/20/14 1/18/14 1/19/14 1/18/14 1/19/14 1/21/14 1/21/14 26 13 11 39 18 3 0.03 0.06 0.05 0.05 0.05 0.1 0.02 0.1 0.05 0.04 0.05 0.02 0.06 0.02 Medium 47 25 20 50 12 29 17 5 18 0.1 0.09 Q18 fx A B D E G H M N 0 Q R S U C Ship Date Order Quantity 9 32 3 | Max Avg Min 4 Unit Sell Price 95.99 5.98 40.98 291.73 100.98 155.06 9.11 15.04 5.28 43 32 16 43 VLOOKUP SKU338 110.99 15 8 29 4 12 49 12 INDEX 4183 INDEX-MATCH 2361) 1 Order ID Customer ID 2 947 C508 3 3237 C372 4 363 0212 5 452 2015 6 4363 0015 7 3202 2015 8 1657 0256 9 4303 C256 10 1531 c089 11 8244 0089 12 2952 0591 13 435 C591 14 1289 C036 15 49128 C036 16 1293 0036 17 2966 C023 18 1283 0453 19 4124 0042 20 1770 0735 21 4240 C735 22 373 C206 23 6092 0731 24 6034 C507 25 11148 C507 26 557 0495 27 2156 C602 28 4183 C602 29 33123 0602 30 4365 0199 31 2954 C199 32 4802 C199 33 4951 C199 34 25143 C199 35 2478 0241 36 4337 0780 37 2367 0648 38 3022 0408 Salesperson Bob John Bob Bob Bob Richard John John John John Richard John John Bob Richard Richard Bob John Bob John Bob Richard Richard Bob Bob John John John Richard Richard Richard Richard Bob John Richard Bob John Order Date Order Priority 1/1/14 Not Specified 1/1/14 High 2/1/14 Critical 2/1/14 Low 2/1/14 Low 2/1/14 Low 2/1/14 Critical 2/1/14 Critical 3/1/14 Critical 3/1/14 Critical 3/1/14 High 3/1/14 High 3/1/14 Low 3/1/14 Low 3/1/14 Low 3/1/14 High 3/1/14 High 3/1/14 Not Specified 4/1/14 Critical 4/1/14 Critical 4/1/14 High 5/1/14 High 5/1/14 High 5/1/14 High 5/1/14 Not Specified 5/1/14 Critical 5/1/14 Critical 5/1/14 Critical 5/1/14 Critical 5/1/14 Critical 5/1/14 Critical 5/1/14 Critical 5/1/14 Critical 5/1/14 Not Specified 5/1/14 Medium 5/1/14 High 6/1/14 Critical SKU SKU947 SKU937 SKU363 SKU052 SKU063 SKU902 SKU557 SKU603 SKU731 SKU1244 SKU352 SKU235 SKU989 SKU1128 SKU593 SKU766 SKU083 SKU1124 SKU370 SKU540 SKUO73 SKU1092 SKU1034 SKU1148 SKU057 SKU156 SKU183 SKU1123 SKU065 SKUO54 SKU202 SKU251 SKU1143 SKU578 SKU937 SKU567 SKUO22 29 12 4 17 42 3 Discount Shipping Amount Ship Mode Product Container 0.08 35 Express Air Large Box 0.1 4.69 Regular Air Small Box 0.06 2.99 Regular Air Small Box 0.02 48.8 Delivery Truck Jumbo Drum 0.07 45 Delivery Truck Jumbo Drum 0.05 7.07 Regular Air Small Box 0.09 2.15 Express Air Wrap Bag 0.08 1.97 Regular Air Wrap Bag 0.03 5.66 Regular Air Small Box 0.01 2.5 Regular Air Small Box 0.03 2.99 Regular Air Small Box 0.09 52.2 Delivery Truck Jumbo Box 0.08 16.71 Regular Air Small Box 0.05 24.49 Regular Air Large Box 0.04 2.27 Regular Air Wrap Bag 0.03 1.2 Regular Air Wrap Bag 0.05 21.2 Regular Air Medium Box 0.02 14.7 Delivery Truck Jumbo Drum 0.03 6.27 Regular Air Small Box 0.07 1.93 Express Air Wrap Bag 0.06 30 Delivery Truck Jumbo Drum 0.08 26.3 Delivery Truck Jumbo Drum 0.03 1.99 Regular Air Small Pack 0.01 5.99 Regular Air Small Box 0.08 43.32 Delivery Truck Jumbo Drum 0.01 11.54 Regular Air Large Box 0.02 21.21 Regular Air Large Box 0.02 17.85 Delivery Truck Jumbo Drum 0.08 0.75 Regular Air Jumbo Drum 0.06 53.03 Delivery Truck Jumbo Drum 0.07 35 Regular Air Large Box 0.08 5.68 Regular Air Jumbo Box 0.04 5.26 Regular Air Small Box 0.05 5.83 Regular Air Wrap Bag 0.09 4.69 Regular Air Small Box 0.02 5.76 Regular Air Small Box 0.04 44.55 Delivery Truck Jumbo Box Ship Date 1/3/14 1/2/14 1/4/14 1/2/14 1/4/14 1/9/14 1/4/14 1/2/14 1/5/14 1/6/14 1/4/14 1/4/14 1/5/14 1/10/14 1/7/14 1/4/14 1/4/14 1/5/14 1/5/14 1/6/14 1/5/14 1/7/14 1/6/14 1/7/14 1/6/14 1/7/14 1/6/14 1/7/14 1/6/14 1/7/14 1/5/14 1/6/14 1/5/14 1/6/14 1/6/14 1/7/14 1/7/14 5.58 212.6 43.22 574.74 10.14 4.26 20.98 213.45 3.36 3.71 350.98 120.97 28.48 205.99 243.98 194.3 209.84 145.45 1.81 20.98 279.48 4.91 125.99 7.64 5.98 30.98 880.98 6 6 11 5 21 41 33 43 29 48 49 25 24 43 23 30 Q18 A B C D E F G H I J K L M N O P Q R S T 0.02 0.07 0.05 0.01 0.01 0.03 0.03 0.06 0.01 0.09 Small Pack 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 2308 C177 112 0784 1969 0784 2368 C181 4606 C181 2194 C181 1721 0555 2778 0771 3429 0771 4627 0493 663 0493 2901 C406 11209 C602 3033 0302 2022 C302 681 C411 359 C359 3074 C359 7130 C359 34209 C084 4699 C148 1613 C673 365 C673 2361 0482 2591 C662 901 C398 4734 0584 2499 0498 3935 C794 1225 0083 4350 C188 1138 0498 4497 0498 3112 C450 4879 C450 3281 C692 4388 0489 323 0489 Richard Richard Bob Richard Richard John Bob John John Richard John Bob Richard Richard Bob Richard Richard Richard Bob Richard Bob John John Bob Richard Richard Richard Bob John Bob Bob John Richard John John Bob Bob Richard 6/1/14 Low 6/1/14 Medium 6/1/14 Medium 6/1/14 Not Specified 6/1/14 Not Specified 6/1/14 Not Specified 6/1/14 Critical 6/1/14 Not Specified 6/1/14 Not Specified 6/1/14 Low 6/1/14 Low 6/1/14 High 7/1/14 High 7/1/14 Medium 7/1/14 Medium 7/1/14 Low 7/1/14 Medium 7/1/14 Medium 7/1/14 Medium 7/1/14 Low 7/1/14 High 8/1/14 High 8/1/14 High 8/1/14 Not Specified 8/1/14 High 9/1/14 Not Specified 9/1/14 Low 9/1/14 Not Specified 9/1/14 Not Specified 9/1/14 Low 9/1/14 High 9/1/14 Not Specified 9/1/14 Not Specified 10/1/14 Critical 10/1/14 Critical 10/1/14 Critical 10/1/14 Low 10/1/14 Low SKU008 SKU412 SKU169 SKU068 SKU906 SKU1194 SKU821 SKU978 SKU629 SKU727 SKU963 SKU801 SKU1209 SKU433 SKU1022 SKU781 SKU359 SKU1074 SKU1130 SKU1209 SKU399 SKU513 SKU165 SKU261 SKU391 SKU501 SKU734 SKU799 SKU835 SKU1225 SKU750 SKU338 SKU797 SKUO12 SKU779 23 1 1 19 23 46 2 17 27 34 46 6 29 11 30 2 6 3 3 7 34 46 16 3 23 25 9 47 24 39 1 43 11 44 31 48 32 43 3 100.98 7.68 6.64 150.98 28.28 35.99 2.1 1.7 30.98 6.48 20.34 3.28 65.99 20.98 73.98 1.76 1.98 699.99 6783.02 65.99 15.99 4.13 22.72 14.56 896.99 4.13 2.6 2.78 3.29 125.99 11.66 5.38 3.28 70.98 11.55 162.93 30.42 161.55 0.05 0.03 0.07 0.09 0.03 0.01 0.05 0.07 0.07 0.05 0.08 0.07 0.03 35.84 Delivery Truck Jumbo Box 6.16 Express Air Small Box 4.95 Express Air Small Pack 30 Delivery Truck Jumbo Drum 13.99 Express Air Medium Box 1.1 Regular Air Small Box 0.7 Regular Air Wrap Bag 1.99 Regular Air 5.09 Regular Air Small Box 8.73 Regular Air Small Box 35 Regular Air Large Box 3.97 Regular Air Wrap Bag 5.99 Regular Air Small Box 8.83 Express Air Small Box 14.52 Regular Air Small Box 0.7 Regular Air Wrap Bag 4.77 Regular Air Small Box 24.49 Express Air Large Box 24.49 Regular Air Large Box 5.99 Regular Air Small Box 13.18 Regular Air Small Box 0.99 Regular Air Small Box 8.99 Regular Air Small Pack 3.5 Regular Air Small Box 19.99 Regular Air Small Box 6.89 Regular Air Small Box 2.4 Regular Air Wrap Bag 0.97 Regular Air Wrap Bag 1.35 Regular Air Wrap Bag 8.99 Regular Air Small Box 8.99 Express Air Small Pack 7.57 Regular Air Small Box 3.97 Regular Air Wrap Bag 46.74 Delivery Truck Jumbo Box 2.36 Regular Air Wrap Bag 19.99 Regular Air Small Box 8.65 Express Air Small Box 19.99 Express Air Small Box 1/6/14 1/8/14 1/8/14 1/8/14 1/8/14 1/7/14 1/7/14 1/7/14 1/8/14 1/8/14 1/10/14 1/8/14 1/8/14 1/9/14 1/10/14 1/12/14 1/8/14 1/8/14 1/8/14 1/11/14 1/8/14 1/8/14 1/8/14 1/9/14 1/10/14 1/10/14 1/14/14 1/11/14 1/11/14 1/16/14 1/11/14 1/10/14 1/9/14 1/11/14 1/12/14 1/12/14 1/14/14 1/12/14 0.07 0.03 0.02 0.1 0.09 0.07 0.04 0.02 0.01 0.05 0.05 0.05 0.09 SKU481 SKU988 SKU923 0.05 0.01 Q18 A B B C D E F . K L M N O P Q R S T 1/12/14 77 78 79 SKU122 SKU797 SKU1012 SKU1016 SKU120 SKU1125 SKU705 SKU1063 24 19 30 34 35 1/11/14 1/11/14 1/11/14 1/15/14 80 81 82 83 1/15/14 49 16 31 20 84 SKU1125 85 86 87 88 89 0.01 0.06 0.02 0.02 0.02 0.03 0.02 0.06 0.08 0.02 0.06 0.05 0.03 0.08 0.01 0.03 0.04 0.09 90 2422 C201 1997 C201 30012 C642 34016 C307 3520 0539 49125 C539 1605 0042 31063 0011 20125 C101 4409 C101 1800 C101 2937 C101 1812 C101 19116 0035 2773 C320 4573 C637 3312 C637 4022 0167 10054 C475 1245 C315 2864 C315 4445 C315 1752 0537 5031 0545 3123 C112 1338 C112 2709 C174 23115 C174 1359 0174 1458 0758 897 0758 311 0758 1496 0758 21108 C367 2796 C367 2902 0736 36122 0736 2353 0736 0.1 Richard Richard Bob John Bob Richard John John Richard Richard John Bob Bob Richard Richard John Richard Bob Richard John Bob John Richard Richard Bob John John John Bob Richard Bob Bob Richard Bob John John Richard Richard 18 29 18 19 27 45 33 40 10 12 28 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 10/1/14 Critical 10/1/14 Critical 10/1/14 Medium 10/1/14 High 10/1/14 Low 10/1/14 Low 10/1/14 Not Specified 11/1/14 High 11/1/14 Not Specified 11/1/14 Not Specified 11/1/14 Not Specified 11/1/14 Not Specified 11/1/14 Not Specified 11/1/14 Low 12/1/14 Not Specified 12/1/14 Critical 12/1/14 Critical 12/1/14 Not Specified 12/1/14 Medium 12/1/14 Low 12/1/14 Low 12/1/14 Low 13/01/2014 Critical 13/01/2014 Low 13/01/2014 Low 13/01/2014 Low 14/01/2014 Critical 14/01/2014 Critical 14/01/2014 Critical 14/01/2014 Not Specified 14/01/2014 Not Specified 14/01/2014 Not Specified 14/01/2014 Not Specified 14/01/2014 Critical 14/01/2014 Critical 14/01/2014 Medium 14/01/2014 Medium 14/01/2014 Medium SKU209 SKU300 SKU137 SKU612 SKU1116 SKU273 SKUO7 SKU812 SKU922 SKU1054 SKU045 SKU464 SKU845 SKU152 SKU631 SKU1123 SKU638 SKU309 SKU1115 SKU659 SKU258 SKU497 SKU111 SKU796 SKU1108 SKU796 SKU202 SKU1122 SKU053 8.34 3.28 5.02 33.98 29.18 297.64 6.48 39.24 297.64 12.99 14.42 4.14 11.34 399.98 59.98 350.98 1.68 27.75 40.98 350.99 8.74 1.98 2.08 5.98 145.45 48.04 7.77 306.14 18.97 208.16 90.48 9.48 4.28 115.99 4.28 19.99 264.98 320.98 0.96 Regular Air Wrap Bag 3.97 Regular Air Wrap Bag 5.14 Regular Air Small Pack 1.99 Regular Air Small Pack 8.55 Regular Air Small Box 14.7 Delivery Truck Jumbo Drum 9.17 Regular Air Small Box 1.99 Regular Air Small Pack 14.7 Delivery Truck Jumbo Drum 14.37 Regular Air Large Box 6.75 Regular Air Medium Box 6.6 Express Air Small Box 5.01 Regular Air Small Box 12.06 Delivery Truck Jumbo Box 3.99 Regular Air Small Box 30 Delivery Truck Jumbo Drum 1 Regular Air Wrap Bag 19.99 Regular Air Small Box 6.5 Regular Air Small Box 39 Delivery Truck Jumbo Drum 1.39 Regular Air Small Box 0.7 Regular Air Wrap Bag 5.33 Regular Air Small Box 5.79 Regular Air Small Box 17.85 Delivery Truck Jumbo Drum 5.09 Regular Air Small Box 9.23 Regular Air Small Box 26.53 Delivery Truck Jumbo Drum 9.54 Express Air Small Box 68.02 Delivery Truck Jumbo Drum 19.99 Regular Air Small Box 7.29 Express Air Small Pack 0.94 Regular Air Wrap Bag 56.14 Delivery Truck Jumbo Drum 0.94 Regular Air Wrap Bag 11.17 Regular Air Large Box 17.86 Delivery Truck Jumbo Drum 58.95 Delivery Truck Jumbo Drum 1/11/14 1/12/14 1/11/14 1/12/14 1/12/14 1/13/14 1/11/14 1/18/14 1/15/14 1/15/14 1/14/14 1/13/14 1/14/14 1/14/14 1/16/14 1/16/14 1/13/14 1/15/14 1/18/14 1/13/14 1/16/14 1/14/14 0.05 0.02 0.02 0.06 0.07 0.03 44 17 50 3 13 27 23 13 14 0.02 0.08 0.02 0.1 0.1 0.07 1/16/14 0.01 0.02 0.08 8 3 14 21 27 29 36 23 1/14/14 1/15/14 1/16/14 1/15/14 1/16/14 1/17/14 1/14/14 1/15/14 1/16/14 0.08 0.06 0.02 0.06 Q18 B C F G H I J N 0 P Q R S T 41 47 48 7 25 4.98 6.35 8.6 7.04 8.09 0.01 0.04 0.02 0.06 0.08 0.09 2.88 5.81 1.81 110.98 8.01 2.18 179.29 0.1 0.03 0.02 0.01 0.09 2.98 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 . 4164 C706 4796 0706 4858 C308 706 C030 2587 0366 995 C031 4679 0733 4142 0733 694 0677 3097 0677 3662 C358 227 C358 2013 0793 25225 0793 3517 0384 3765 C152 4002 C131 4688 C131 2579 0599 2424 0084 33031 C392 397 0426 2600 C426 1301 C386 1168 C386 3957 0625 1887 C599 3163 0599 4768 C266 2545 0449 20085 0449 5045 0562 1283 C449 2920 C449 1759 0449 558 C149 1821 6722 Richard John Richard Bob John John Bob Richard Bob Richard Richard Bob John Bob Richard Richard John Bob Richard Richard Bob Richard John Bob Richard John John John Bob Bob John Richard Bob John John John Richard D E 15/01/2014 Low 15/01/2014 Low 15/01/2014 Not Specified 15/01/2014 Medium 15/01/2014 High 15/01/2014 Critical 16/01/2014 Medium 16/01/2014 Medium 16/01/2014 Critical 16/01/2014 Critical 16/01/2014 Critical 16/01/2014 Critical 16/01/2014 Low 16/01/2014 Low 16/01/2014 Medium 16/01/2014 Low 17/01/2014 Critical 17/01/2014 Critical 17/01/2014 Medium 17/01/2014 Medium 17/01/2014 Medium 17/01/2014 Medium 17/01/2014 Medium 17/01/2014 Medium 17/01/2014 Medium 17/01/2014 Not Specified 17/01/2014 Medium 17/01/2014 Medium 18/01/2014 Not Specified 18/01/2014 Medium 18/01/2014 Medium 18/01/2014 High 18/01/2014 18/01/2014 Medium 18/01/2014 Medium 19/01/2014 Critical 19/01/2014 Critical SKU564 SKU596 SKU358 SKU606 SKU087 SKU795 SKU379 SKU842 SKU194 SKU597 SKU862 SKU227 SKU813 SKU1225 SKU917 SKU165 SKU502 SKU788 SKU779 SKU324 SKU1031 SKU497 SKU700 SKU301 SKU568 SKU757 SKU487 SKU1163 SKU468 SKU045 SKU1085 SKU345 SKU483 SKU620 SKU959 SKU558 SKU321 9 46 41 6 30 36 2 2 20 25 35 37 40 46 25 24 33 3 3 0.05 0.04 0.01 0.02 0.04 0.08 0.01 0.1 0.05 0.06 K L 4.75 Regular Air Small Box 1.02 Regular Air Wrap Bag 6.19 Regular Air Small Box 2.17 Regular Air Wrap Bag 7.96 Express Air Small Box 0.7 Regular Air Wrap Bag 8.49 Regular Air Small Box 0.75 Regular Air Wrap Bag 13.99 Regular Air Medium Box 2.87 Regular Air Wrap Bag 0.78 Regular Air Wrap Bag 29.21 Delivery Truck Jumbo Box 2.03 Express Air Wrap Bag 8.99 Regular Air Small Box 5.5 Regular Air Small Box 8.99 Regular Air Small Pack 19.99 Regular Air Small Box 1.57 Regular Air Wrap Bag 2.36 Regular Air Wrap Bag 91.05 Delivery Truck Jumbo Drum 1.99 Regular Air Small Pack 19.99 Regular Air Small Box 8.18 Regular Air Small Box 13.32 Regular Air Small Box 2.26 Express Air Wrap Bag 6.17 Regular Air Small Pack 1.39 Regular Air Small Box 2.5 Regular Air Small Box 1.39 Regular Air Small Box 39 Delivery Truck Jumbo Drum 9.4 Express Air Small Box 1.49 Regular Air Small Box 5.72 Regular Air Small Box 5.81 Regular Air Small Box 17.78 Regular Air Small Box 9.03 Regular Air Small Box 0.99 Regular Air Small Box 125.99 13.43 22.72 30.53 1.68 11.55 328.14 16.48 90.48 22.84 14.81 4.2 28.15 7.64 125.99 15.74 350.99 15.99 58.1 11.58 48.91 15.51 18.97 207.48 M 1/20/14 1/20/14 1/15/14 1/17/14 1/16/14 1/16/14 1/17/14 1/17/14 1/18/14 1/18/14 1/18/14 1/18/14 1/16/14 1/21/14 1/17/14 1/20/14 1/17/14 1/19/14 1/18/14 1/19/14 1/19/14 1/19/14 1/17/14 1/20/14 1/19/14 1/18/14 1/19/14 1/19/14 1/21/14 1/20/14 1/20/14 1/18/14 1/19/14 1/18/14 1/19/14 1/21/14 1/21/14 26 13 11 39 18 3 0.03 0.06 0.05 0.05 0.05 0.1 0.02 0.1 0.05 0.04 0.05 0.02 0.06 0.02 Medium 47 25 20 50 12 29 17 5 18 0.1 0.09