Spreadsheet: 145154d1331323932-excel-2007-sumif-index-match-formula-bop-inventory-composition
Sheet: MF Dump

SSN code BOP- MEN'S FASHION 2/28/12 6:02:01 PM
 |  |  |  | 25811 | 15707 | 10112 | 1610 | 391 | 1219 | 506 | 73163 | 61576 | 11587 | 18809 | 15079 | 3729
 |  |  |  | 32113 | 32097 | 18 | 2188 | 4 | 2184 | 1703 | 121433 | 121421 | 12 | 28245 | 28181 | 63
 |  |  |  | 31519 | 31519 | 0 | 1622 | 0 | 1622 | 4637 | 78761 | 78761 | 0 | 18126 | 18126 | 0
 |  |  |  | 24 | 0 | 24 | 6 | 6 | 0 | 0 | 49 | 0 | 49 | 60 | 0 | 60
 | SPRING 2011 & PRIOR |  |  | 406 | 7 | 399 | 37 | 37 | 0 | 1 | 413 | 0 | 413 | 901 | 0 | 901
 | SPRING 2011 & PRIOR |  |  | 335 | 29 | 312 | 15 | 15 | 0 | 11 | 164 | 0 | 164 | 240 | 0 | 240
 | SPRING 2011 & PRIOR |  |  | 370 | -5 | 382 | 23 | 23 | 0 | 1 | 271 | 0 | 271 | 359 | 0 | 359
 |  |  |  | 247 | 3 | 245 | 28 | 26 | 2 | 5 | 192 | 20 | 172 | 330 | 22 | 309
 |  |  |  | 468 | 5 | 469 | 57 | 56 | 1 | 6 | 505 | 15 | 490 | 707 | 5 | 701
 |  |  |  | 375 | 0 | 376 | 43 | 42 | 1 | 10 | 404 | 4 | 400 | 467 | 8 | 459
 |  |  |  | 2588 | 29 | 2585 | 366 | 363 | 3 | 88 | 4883 | 146 | 4738 | 4834 | 46 | 4788
 |  |  |  | 3407 | 125 | 3287 | 388 | 386 | 2 | 34 | 7122 | 79 | 7042 | 6483 | 42 | 6441
 |  |  |  | 5638 | 155 | 5493 | 841 | 835 | 6 | 89 | 12232 | 295 | 11937 | 12442 | 165 | 12277
 | REPLENISHMENT |  |  | -3 | -3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 12573 | 67 | 12546 | 2146 | 2141 | 5 | 60 | 35730 | 99 | 35631 | 37225 | 35 | 37190
 |  |  |  | 10887 | 225 | 10698 | 1670 | 1662 | 8 | 106 | 29521 | 763 | 28757 | 22660 | 218 | 22442
 |  |  |  | 9196 | 2 | 9197 | 1109 | 1102 | 7 | 185 | 28805 | 194 | 28612 | 17193 | 48 | 17145
 | REPLENISHMENT |  |  | 37813 | 36794 | 1027 | 1949 | 111 | 1838 | 3639 | 81290 | 80342 | 948 | 22099 | 20091 | 2008
 | REPLENISHMENT |  |  | 5114 | 0 | 5117 | 617 | 564 | 53 | 28 | 6434 | 552 | 5882 | 5458 | 265 | 5193
 | SPRING 2011 & PRIOR |  |  | 109 | 2 | 107 | 3 | 3 | 0 | 0 | 29 | 0 | 29 | 18 | 0 | 18
 | SPRING 2011 & PRIOR |  |  | 230 | 2 | 228 | 2 | 2 | 0 | 0 | 24 | 0 | 24 | 24 | 0 | 24
 | SPRING 2011 & PRIOR |  |  | 213 | 0 | 213 | 3 | 3 | 0 | 0 | 30 | 0 | 30 | 46 | 0 | 46
 | SPRING 2011 & PRIOR |  |  | 324 | 2 | 322 | 5 | 5 | 0 | 0 | 47 | 0 | 47 | 76 | 0 | 76
 | SPRING 2011 & PRIOR |  |  | 296 | 16 | 286 | 5 | 3 | 2 | 0 | 72 | 35 | 37 | 94 | 37 | 57
 | SPRING 2011 & PRIOR |  |  | 174 | 0 | 175 | 5 | 5 | 0 | 0 | 74 | 0 | 74 | 77 | 0 | 77
 | SPRING 2011 & PRIOR |  |  | 451 | 38 | 427 | 19 | 16 | 3 | 0 | 236 | 46 | 190 | 218 | 45 | 173
 | SPRING 2011 & PRIOR |  |  | 323 | 65 | 276 | 9 | 8 | 1 | 0 | 129 | 20 | 109 | 130 | 18 | 113
 | SPRING 2011 & PRIOR |  |  | 477 | 62 | 429 | 18 | 14 | 4 | 0 | 304 | 70 | 234 | 320 | 85 | 235
 | REPLENISHMENT |  |  | 1695 | 1213 | 483 | 75 | 50 | 25 | 3 | 3235 | 1957 | 1277 | 1665 | 569 | 1097
 | SPRING 2011 & PRIOR |  |  | 252 | 2 | 254 | 13 | 13 | 0 | 0 | 157 | 0 | 157 | 202 | 0 | 202
 | SPRING 2011 & PRIOR |  |  | 572 | 20 | 605 | 35 | 35 | 0 | 1 | 332 | 0 | 332 | 831 | 0 | 831
 | SPRING 2011 & PRIOR |  |  | 138 | 1 | 156 | 5 | 5 | 0 | 0 | -2 | 0 | -2 | 82 | 0 | 82
 | SPRING 2011 & PRIOR |  |  | 23 | 0 | 23 | 1 | 1 | 0 | 0 | 10 | 0 | 10 | 18 | 0 | 18
 | SPRING 2011 & PRIOR |  |  | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 38 | 0 | 38 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 129 | 0 | 129 | 6 | 6 | 0 | 0 | 89 | 0 | 89 | 126 | 0 | 126
 | SPRING 2011 & PRIOR |  |  | 64 | 0 | 64 | 1 | 1 | 0 | 0 | 20 | 0 | 20 | 15 | 0 | 15
 | SPRING 2011 & PRIOR |  |  | 139 | 0 | 139 | 1 | 1 | 0 | 0 | 20 | 0 | 20 | 15 | 0 | 15
 | SPRING 2011 & PRIOR |  |  | 66 | 0 | 66 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 135 | 0 | 135 | 5 | 5 | 0 | 0 | 100 | 0 | 100 | 96 | 0 | 96
 | SPRING 2011 & PRIOR |  |  | 34 | 1 | 33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 16 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | -2 | -2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | -29 | -29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPRING 2011 & PRIOR |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 184782 | 118169 | 66905 | 14926 | 7940 | 6986 | 11113 | 486277 | 346395 | 139882 | 200694 | 83084 | 117610