Spreadsheet: 166720d1341753419-formula-which-shows-whether-a-pallet-will-be-consumed-by-forecast-asda-own-label
Sheet: Sheet1

Customer | Brand | SKU | Description | Location | Sage Shelf Life | Qty | Status | BBE | Days Left till out of date | Shelf Life Required (Days) | [NAME] we cant send it in to customer | Avg Weekly Fcst (Next 13W Fcst) | Date Issue? | Consumed by Fcst? | Estimated Shortage (Pallets) | Est Over Stocked by (Pallets) | Could last (Periods)
AS | OWN | ASCC220122 | Asda CsCs Spicy Veg (6332414) | 1F047L | 360 | 37 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 347.538462 |  | YES | 311
AS | OWN | ASCC220122 | Asda CsCs Spicy Veg (6332414) | 1M010G | 360 | 1783 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 347.538462 |  | NO |  | 1435 | 4
AS | OWN | ASCC230122 | Asda CsCs Cori&Lemon(6332400) 110g | 1E034M | 360 | 119 | OK | 2012-08-31 00:00:00 | 54 | 180 |  | 342.307692 | Below Customer Rules
AS | OWN | ASCC230122 | Asda CsCs Cori&Lemon(6332400) 110g | 2A005A | 360 | 1340 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 342.307692 |  | NO |  | 997 | 2
AS | OWN | ASCC250122 | Asda CsCs Med Tom(6332407) 110g | 1E037K | 360 | 202 | OK | 2012-12-30 00:00:00 | 175 | 180 |  | 365.923077 | Below Customer Rules
AS | OWN | ASCC250122 | Asda CsCs Med Tom(6332407) 110g | 1C045K | 360 | 144 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 365.923077 |  | YES | 222
AS | OWN | ASCC250122 | Asda CsCs Med Tom(6332407) 110g | 1C002F | 360 | 1869 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 365.923077 |  | NO |  | 1503 | 4
AS | OWN | ASDK010050 | ASDA MEAL KIT PAELLA 270G | 1K042C | 456 | 1192 | OK | 2013-05-20 00:00:00 | 316 | 180 | 136 | 115.384615 |  | NO |  | 1076 | 9
AS | OWN | ASDK070050 | ASDA MEAL KIT TIKKA MASALA CURRY 420G | 2B017F | 365 | 2685 | OK | 2013-05-29 00:00:00 | 325 | 180 | 145 | 480 |  | NO |  | 2205 | 4
AS | OWN | ASDK070050 | ASDA MEAL KIT TIKKA MASALA CURRY 420G | 2C051J | 365 | 285 | OK | 2013-06-29 00:00:00 | 356 | 180 | 176 | 480 |  | YES | 195
AS | OWN | ASDK080050 | ASDA MEAL [NAME] CURRY 430G | 1F028G | 365 | 618 | OK | 2013-05-29 00:00:00 | 325 | 180 | 145 | 330.769231 |  | NO |  | 287 | 0
AS | OWN | ASEX690102 | Asda Mighty Soup Tomato & Veg (6335725) | 1F027M | 540 | 24 | OK | 2013-03-30 00:00:00 | 265 | 180 | 85 | 364.923077 |  | YES | 341
AS | OWN | ASEX720102 | Asda Mighty Soup Minestrone (6335732) | 1C038E | 540 | 304 | OK | 2013-03-30 00:00:00 | 265 | 180 | 85 | 401 |  | YES | 97
AS | OWN | ASEX730102 | Asda [NAME] (6335697) | 1C032F | 540 | 209 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 469.615385 |  | YES | 261
AS | OWN | ASGC310110 | Asda Giant Cous Cous Moroccan (xxxxxxxx) | 1K007E | 360 | 714 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 253.461538 |  | NO |  | 460 | 1
AS | OWN | ASGC310110 | Asda Giant Cous Cous Moroccan (xxxxxxxx) | 1J014J | 360 | 2756 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 253.461538 |  | NO |  | 2502 | 9
AS | OWN | ASGC830110 | Asda Giant Cous Cous Med Veg (xxxxxxxx) | 2F019F | 360 | 2217 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 339.384615 |  | NO |  | 1877 | 5
AS | OWN | ASHB050050 | Asda Cheesecake Brownie 300g (xxxxxxx) | 1F043K | 360 | 10 | OK | 2012-07-31 00:00:00 | 23 | 180 |  | 149.538462 | Below Customer Rules
AS | OWN | ASHB050050 | Asda Cheesecake Brownie 300g (xxxxxxx) | 1F024B | 360 | 680 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 149.538462 |  | NO |  | 530 | 3
AS | OWN | ASHB060050 | Asda Banana&BranMuffin280g(xxxxxxx) | 1C049J | 360 | 28 | OK | 2012-07-30 00:00:00 | 22 | 180 |  | 85.615385 | Below Customer Rules
AS | OWN | ASHB060050 | Asda Banana&BranMuffin280g(xxxxxxx) | 1J048K | 360 | 147 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 85.615385 |  | NO |  | 61 | 0
AS | OWN | ASHB060050 | Asda Banana&BranMuffin280g(xxxxxxx) | 1J026J | 360 | 121 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 85.615385 |  | NO |  | 35 | 0
AS | OWN | ASHB060050 | Asda Banana&BranMuffin280g(xxxxxxx) | 1K049D | 360 | 147 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 85.615385 |  | NO |  | 61 | 0
AS | OWN | ASHB070050 | Asda [NAME] 275g (xxxxxxx) | 1T001C | 360 | 1393 | OK | 2012-07-01 00:00:00 | -7 | 180 |  | 55.692308 | Out of Date
AS | OWN | ASHB070050 | Asda [NAME] 275g (xxxxxxx) | 1S018A | 360 | 39 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 55.692308 |  | YES | 17
AS | OWN | ASHB070050 | Asda [NAME] 275g (xxxxxxx) | 1W011E | 360 | 671 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 55.692308 |  | NO |  | 615 | 11
AS | OWN | ASHB100050 | Asda Pizza Mix 290g | 1F037B | 274 | 94 | OK | 2012-04-30 00:00:00 | -69 | 180 |  | 1280.153846 | Out of Date
AS | OWN | ASHB100050 | Asda Pizza Mix 290g | 1P011J | 360 | 170 | OK | 2013-01-31 00:00:00 | 207 | 180 | 27 | 1280.153846 |  | YES | 1111
AS | OWN | ASHB100050 | Asda Pizza Mix 290g | 1S006B | 360 | 174 | OK | 2013-02-28 00:00:00 | 235 | 180 | 55 | 1280.153846 |  | YES | 1107
AS | OWN | ASHB100050 | Asda Pizza Mix 290g | 1X048E | 360 | 2602 | OK | 2013-03-30 00:00:00 | 265 | 180 | 85 | 1280.153846 |  | NO |  | 1321 | 1
AS | OWN | ASHB100050 | Asda Pizza Mix 290g | 1K044E | 360 | 588 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 1280.153846 |  | YES | 693
AS | OWN | ASHB160050 | Asda Jam Roly Poly 320g | 1P001G | 365 | 50 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 307.846154 |  | YES | 258
AS | OWN | ASHB160050 | Asda Jam Roly Poly 320g | 1F039R | 365 | 11 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 307.846154 |  | YES | 297
AS | OWN | ASHB380050 | Asda Fully Loaded Brownie 285g (xxxxxxx) | 1C042A | 360 | 16 | OK | 2013-01-31 00:00:00 | 207 | 180 | 27 | 416.230769 |  | YES | 401
AS | OWN | ASHB380050 | Asda Fully Loaded Brownie 285g (xxxxxxx) | 2C002B | 360 | 146 | OK | 2013-03-31 00:00:00 | 266 | 180 | 86 | 416.230769 |  | YES | 271
AS | OWN | ASHB380050 | Asda Fully Loaded Brownie 285g (xxxxxxx) | 2H005B | 360 | 519 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 416.230769 |  | NO |  | 102 | 0
AS | OWN | ASHB380050 | Asda Fully Loaded Brownie 285g (xxxxxxx) | 2A043F | 360 | 2018 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 416.230769 |  | NO |  | 1601 | 3
AS | OWN | ASHB381050 | Asda Family Size Brownie 570g (xxxxxxx) | 1X010F | 360 | 129 | OK | 2012-11-30 00:00:00 | 145 | 180 |  | 197.692308 | Below Customer Rules
AS | OWN | ASHB381050 | Asda Family Size Brownie 570g (xxxxxxx) | 1K041M | 360 | 99 | OK | 2013-02-28 00:00:00 | 235 | 180 | 55 | 197.692308 |  | YES | 99
AS | OWN | ASHB381050 | Asda Family Size Brownie 570g (xxxxxxx) | 1L036L | 360 | 441 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 197.692308 |  | NO |  | 243 | 1
AS | OWN | ASHB440050 | Asda Fully Loaded Cookie275g (xxxxxxx) | 1E046H | 360 | 126 | OK | 2013-01-31 00:00:00 | 207 | 180 | 27 | 254.538462 |  | YES | 129
AS | OWN | ASHB440050 | Asda Fully Loaded Cookie275g (xxxxxxx) | 1K014E | 360 | 147 | OK | 2013-02-28 00:00:00 | 235 | 180 | 55 | 254.538462 |  | YES | 108
AS | OWN | ASHB440050 | Asda Fully Loaded Cookie275g (xxxxxxx) | 1G004A | 360 | 1890 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 254.538462 |  | NO |  | 1635 | 6
AS | OWN | ASHB470050 | Asda Shortcrust Pastry 450g | 1E050K | 360 | 344 | OK | 2012-12-30 00:00:00 | 175 | 180 |  | 2126.923077 | Below Customer Rules
AS | OWN | ASHB470050 | Asda Shortcrust Pastry 450g | 2F049B | 274 | 676 | OK | 2013-02-28 00:00:00 | 235 | 180 | 55 | 2126.923077 |  | YES | 1451
AS | OWN | ASHB470050 | Asda Shortcrust Pastry 450g | 2F036M | 360 | 4542 | OK | 2013-03-30 00:00:00 | 265 | 180 | 85 | 2126.923077 |  | NO |  | 2415 | 1
AS | OWN | ASHB510130 | Asda Batter Mix 256g | 2G013C | 360 | 178 | OK | 2013-01-31 00:00:00 | 207 | 180 | 27 | 450 |  | YES | 272
AS | OWN | ASHB510130 | Asda Batter Mix 256g | 1N042D | 360 | 110 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 450 |  | YES | 340
AS | OWN | ASHB510130 | Asda Batter Mix 256g | 1M003A | 360 | 3645 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 450 |  | NO |  | 3195 | 7
AS | OWN | ASHS120050 | Asda Kids Pizza Mix 300g | 1S025L | 365 | 2404 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 692.307692 |  | NO |  | 1711 | 2
AS | OWN | ASHS120050 | Asda Kids Pizza Mix 300g | 1T017C | 365 | 2233 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 692.307692 |  | NO |  | 1540 | 2
AS | OWN | ASJE010240 | ASDA [NAME] 11.5g 5843592 | 1F037L | 360 | 134 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 397.769231 |  | YES | 264
AS | OWN | ASJE010240 | ASDA [NAME] 11.5g 5843592 | 1G014D | 360 | 1364 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 397.769231 |  | NO |  | 966 | 2
AS | OWN | ASJE020240 | ASDA Orange Jelly 11.5g 5843585 | 1S032E | 2160 | 83 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 344.846154 |  | YES | 262
AS | OWN | ASJE040240 | ASDA [NAME] 11.5g 5843599 | 1R003A | 360 | 1738 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 562.384615 |  | NO |  | 1175 | 2
AS | OWN | ASMF010080 | ASDA MEAT FREE SAUSAGE MIX 150g (6362010 | 1H042H | 360 | 38 | OK | 2012-11-30 00:00:00 | 145 | 180 |  | 180.846154 | Below Customer Rules
AS | OWN | ASMF010080 | ASDA MEAT FREE SAUSAGE MIX 150g (6362010 | 2G042K | 360 | 191 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 180.846154 |  | NO |  | 10 | 0
AS | OWN | [NAME] | ASDA MF LINC SAUSAGE MIX 150g (6362017) | 1F026E | 1080 | 228 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 150.846154 |  | NO |  | 77 | 0
AS | OWN | ASMF030080 | ASDA MEAT FREE BURGERMIX 175G (6362024) | 1C021A | 360 | 56 | OK | 2013-03-30 00:00:00 | 265 | 180 | 85 | 265.769231 |  | YES | 210
AS | OWN | ASMF030080 | ASDA MEAT FREE BURGERMIX 175G (6362024) | 1K019A | 360 | 23 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 265.769231 |  | YES | 243
AS | OWN | ASMF030080 | ASDA MEAT FREE BURGERMIX 175G (6362024) | 1F029B | 720 | 36 | OK | 2013-06-28 00:00:00 | 355 | 180 | 175 | 265.769231 |  | YES | 230
AS | OWN | ASMF080080 | ASDA MEAT FREE FALAFEL MIX120g (6362031) | 1C035H | 360 | 66 | OK | 2012-08-30 00:00:00 | 53 | 180 |  | 284.846154 | Below Customer Rules
AS | OWN | ASMF080080 | ASDA MEAT FREE FALAFEL MIX120g (6362031) | 1S004F | 360 | 723 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 284.846154 |  | NO |  | 438 | 1
AS | OWN | ASMF140080 | ASDA ONION BHAJI MIX 135G | 2E018C | 274 | 1081 | OK | 2013-02-28 00:00:00 | 235 | 180 | 55 | 300 |  | NO |  | 781 | 2
AS | OWN | ASMF140080 | ASDA ONION BHAJI MIX 135G | 1X032G | 274 | 2475 | OK | 2013-03-31 00:00:00 | 266 | 180 | 86 | 300 |  | NO |  | 2175 | 7
AS | OWN | ASMF140080 | ASDA ONION BHAJI MIX 135G | 1Y026K | 274 | 228 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 300 |  | YES | 72
AS | OWN | ASOA014040 | Asda Plain Porridge 4x50g (9219259) | 1L042H | 274 | 60 | OK | 2013-06-29 00:00:00 | 356 | 180 | 176 | 98.769231 |  | YES | 39
AS | OWN | ASOA024040 | Asda G Syrup Porridge [NAME]) | 1L040J | 274 | 60 | OK | 2012-03-29 00:00:00 | -101 | 180 |  | 126.692308 | Out of Date
AS | OWN | ASOA024040 | Asda G Syrup Porridge [NAME]) | 1V050E | 274 | 540 | OK | 2013-03-30 00:00:00 | 265 | 180 | 85 | 126.692308 |  | NO |  | 413 | 3
AS | OWN | ASOA994040 | Asda PorrMixed Pl/GS/Str/Blue4(9219266) | 2B031D | 274 | 3867 | OK | 2013-03-29 00:00:00 | 264 | 180 | 84 | 87.153846 |  | NO |  | 3779 | 43
AS | OWN | ASOA994040 | Asda PorrMixed Pl/GS/Str/Blue4(9219266) | 2E031J | 274 | 60 | OK | 2013-05-29 00:00:00 | 325 | 180 | 145 | 87.153846 |  | YES | 28
AS | OWN | ASPA330080 | Asda Pasta Tomato & Herb (6362836) | 1C030E | 540 | 160 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 576.076923 |  | YES | 417
AS | OWN | [NAME] | Asda Pasta Macaroni Cheese (6362843) | 1T009E | 540 | 192 | OK | 2012-12-31 00:00:00 | 176 | 180 |  | 480.461538 | Below Customer Rules
AS | OWN | [NAME] | Asda Pasta Cheese & Ham (6362850) | 1S029F | 540 | 106 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 672.307692 |  | YES | 567
AS | OWN | ASPA460080 | Asda Pasta Cheese/Broccoli (6362822) | 1B039B | 540 | 70 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 746.692308 |  | YES | 677
AS | OWN | [NAME] | Asda Pasta Chick & Garlic (6362829) | 1F011L | 540 | 81 | OK | 2013-03-30 00:00:00 | 265 | 180 | 85 | 618.076923 |  | YES | 538
AS | OWN | ASPA510080 | Asda Pasta GFY Arrabiata (6362815) | 1X048D | 540 | 174 | OK | 2013-01-31 00:00:00 | 207 | 180 | 27 | 318.615385 |  | YES | 145
AS | OWN | ASPN480080 | Asda Noodle Pot Chicken / Mush (6361765) | 1K017H | 360 | 74 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 2580.769231 |  | YES | 2507
AS | OWN | ASPN480080 | Asda Noodle Pot Chicken / Mush (6361765) | 2C035D | 360 | 182 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 2580.769231 |  | YES | 2399
AS | OWN | ASPN480080 | Asda Noodle Pot Chicken / Mush (6361765) | 1E034B | 360 | 7077 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 2580.769231 |  | NO |  | 4496 | 1
AS | OWN | ASPN580080 | Asda Noodle Pot Beef & Tomato (6361779) | 1X015A | 360 | 190 | OK | 2013-01-31 00:00:00 | 207 | 180 | 27 | 1707 |  | YES | 1517
AS | OWN | ASPN580080 | Asda Noodle Pot Beef & Tomato (6361779) | 1Y016H | 360 | 20 | OK | 2013-03-31 00:00:00 | 266 | 180 | 86 | 1707 |  | YES | 1687
AS | OWN | ASPN580080 | Asda Noodle Pot Beef & Tomato (6361779) | 2E022L | 360 | 94 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 1707 |  | YES | 1613
AS | OWN | ASPN580080 | Asda Noodle Pot Beef & Tomato (6361779) | 1F045S | 360 | 66 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 1707 |  | YES | 1641
AS | OWN | ASPN580080 | Asda Noodle Pot Beef & Tomato (6361779) | 1L035L | 360 | 1626 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 1707 |  | YES | 81
AS | OWN | ASPN700080 | Asda Noodle Pot Curry Flavour (6361772) | 1L051H | 360 | 143 | OK | 2013-03-31 00:00:00 | 266 | 180 | 86 | 1798.692308 |  | YES | 1656
AS | OWN | ASPN700080 | Asda Noodle Pot Curry Flavour (6361772) | 1X037M | 360 | 4003 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 1798.692308 |  | NO |  | 2204 | 1
AS | OWN | ASPO670091 | Asda Minute Mash Bubble & Sqk (6349879) | 1C025A | 540 | 134 | OK | 2013-03-30 00:00:00 | 265 | 180 | 85 | 268.846154 |  | YES | 135
AS | OWN | ASPO790060 | Asda Plain Mash 180g (xxxxxxx) | 1R032B | 540 | 432 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 149 |  | NO |  | 283 | 1
AS | OWN | ASPU090040 | Asda Plain Cous Cous 500g (6363116) | 1M002K | 720 | 278 | OK | 2013-03-31 00:00:00 | 266 | 180 | 86 | 2068.692308 |  | YES | 1791
AS | OWN | ASPU090040 | Asda Plain Cous Cous 500g (6363116) | 1T040G | 360 | 8 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 2068.692308 |  | YES | 2061
AS | OWN | ASPU090040 | Asda Plain Cous Cous 500g (6363116) | 1W020H | 360 | 549 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 2068.692308 |  | YES | 1520
AS | OWN | ASPU090040 | Asda Plain Cous Cous 500g (6363116) | 1K017K | 360 | 4879 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 2068.692308 |  | NO |  | 2810 | 1
AS | OWN | ASPU091040 | Asda Plain Cous Cous 1kg (6363123) | 1M043A | 360 | 55 | OK | 2012-05-01 00:00:00 | -68 | 180 |  | 1410.461538 | Out of Date
AS | OWN | ASPU091040 | Asda Plain Cous Cous 1kg (6363123) | 1H034J | 360 | 112 | OK | 2013-02-28 00:00:00 | 235 | 180 | 55 | 1410.461538 |  | YES | 1299
AS | OWN | ASPU091040 | Asda Plain Cous Cous 1kg (6363123) | 1H027G | 360 | 98 | OK | 2013-03-30 00:00:00 | 265 | 180 | 85 | 1410.461538 |  | YES | 1313
AS | OWN | ASPU091040 | Asda Plain Cous Cous 1kg (6363123) | 2K030K | 360 | 169 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 1410.461538 |  | YES | 1242
AS | OWN | ASPU091040 | Asda Plain Cous Cous 1kg (6363123) | 1L014F | 360 | 1716 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 1410.461538 |  | NO |  | 305 | 0
AS | OWN | ASRI010111 | Asda Rice Golden 120g(6364096) 11s | 1F029C | 540 | 10 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 734.307692 |  | YES | 725
AS | OWN | ASRI040110 | Asda [NAME] () 11s | 1W041C | 540 | 218 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 634.769231 |  | YES | 417
AS | OWN | [NAME] | Asda Rice Mushroom () 11s | 1S037F | 540 | 1304 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 493.769231 |  | NO |  | 810 | 1
AS | OWN | ASRI090110 | Asda Rice Curry () 11s | 1V021F | 540 | 128 | OK | 2013-01-31 00:00:00 | 207 | 180 | 27 | 347.076923 |  | YES | 220
AS | OWN | ASRI090110 | Asda Rice Curry () 11s | 1W047E | 540 | 160 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 347.076923 |  | YES | 188
AS | OWN | ASRI110100 | Asda Rice Pilau 150g (5706422) | 1N040C | 365 | 1593 | OK | 2013-06-28 00:00:00 | 355 | 180 | 175 | 334.615385 |  | NO |  | 1258 | 3
AS | OWN | ASRI120110 | Asda Rice S & Sour ()11s | 1B038A | 540 | 10 | OK | 2012-08-30 00:00:00 | 53 | 180 |  | 316.615385 | Below Customer Rules
AS | OWN | ASRI120110 | Asda Rice S & Sour ()11s | 1C039N | 540 | 42 | OK | 2012-12-30 00:00:00 | 175 | 180 |  | 316.615385 | Below Customer Rules
AS | OWN | ASRI120110 | Asda Rice S & Sour ()11s | 1C039P | 540 | 168 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 316.615385 |  | YES | 149
AS | OWN | ASRI140100 | Asda Rice Bengali 5 Spice 150g (5706429) | D201 | 365 | 1734 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 334.615385 |  | NO |  | 1399 | 4
AS | OWN | ASRI180100 | [NAME]g (5706436) | 1S052E | 365 | 1500 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 334.615385 |  | NO |  | 1165 | 3
AS | OWN | ASSL600092 | Asda GFY Cup Golden Vegetable (6336880) | 1C039H | 540 | 129 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 386.461538 |  | YES | 258
AS | OWN | ASSL620092 | Asda GFY Farm House Vegetable (6336887) | 1H026E | 540 | 139 | OK | 2013-03-08 00:00:00 | 243 | 180 | 63 | 448.769231 |  | YES | 310
AS | OWN | ASSL620092 | Asda GFY Farm House Vegetable (6336887) | 2B042C | 540 | 207 | OK | 2013-04-13 00:00:00 | 279 | 180 | 99 | 448.769231 |  | YES | 242
AS | OWN | ASSL620092 | Asda GFY Farm House Vegetable (6336887) | 1K051B | 540 | 157 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 448.769231 |  | YES | 292
AS | OWN | ASSL640090 | Asda GFY Chicken Noodle Cup Sp (6356963) | 2D038D | 540 | 16 | OK | 2012-05-31 00:00:00 | -38 | 180 |  | 200.307692 | Out of Date
AS | OWN | ASSL700092 | Asda GFY Cup Tomato & Basil (6336747) | 1T016C | 540 | 186 | OK | 2013-04-07 00:00:00 | 273 | 180 | 93 | 144.307692 |  | NO |  | 41 | 0
AS | OWN | ASSL700092 | Asda GFY Cup Tomato & Basil (6336747) | 1X031D | 540 | 114 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 144.307692 |  | YES | 31
AS | OWN | [NAME] | Asda GFY Cup Leek & Potato  (6336901) | 1C034J | 540 | 259 | OK | 2013-03-30 00:00:00 | 265 | 180 | 85 | 249.307692 |  | NO |  | 9 | 0
AS | OWN | ASSL860090 | Asda GFY Cup Roast Chicken (6336894) | 1H047A | 540 | 225 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 252.384615 |  | YES | 28
AS | OWN | ASSM400061 | ASDA SNACK ROAST ONION MASH (       ) | 1M027A | 540 | 188 | OK | 2013-02-28 00:00:00 | 235 | 180 | 55 | 1145 |  | YES | 957
AS | OWN | ASSM400061 | ASDA SNACK ROAST ONION MASH (       ) | 1Y022D | 540 | 97 | OK | 2013-03-31 00:00:00 | 266 | 180 | 86 | 1145 |  | YES | 1048
AS | OWN | ASSM400061 | ASDA SNACK ROAST ONION MASH (       ) | 2A039E | 540 | 212 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 1145 |  | YES | 933
AS | OWN | ASSM400061 | ASDA SNACK ROAST ONION MASH (       ) | 2F045M | 540 | 2238 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 1145 |  | NO |  | 1093 | 0
AS | OWN | ASSM460061 | ASDA SNACK CHEESE & BROC MASH (6361905) | 1R046E | 540 | 5438 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 823.307692 |  | NO |  | 4614 | 5
AS | OWN | [NAME] | ASDA SNACK CARROT & SWEDE MASH (6361912) | 1B020N | 540 | 165 | OK | 2012-10-30 00:00:00 | 114 | 180 |  | 271.923077 | Below Customer Rules
AS | OWN | [NAME] | ASDA SNACK CARROT & SWEDE MASH (6361912) | 1T036C | 540 | 213 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 271.923077 |  | YES | 59
AS | OWN | [NAME] | ASDA SNACK CARROT & SWEDE MASH (6361912) | 2G010J | 540 | 1980 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 271.923077 |  | NO |  | 1708 | 6
AS | OWN | ASSO010080 | Asda MF Savoury Mince Soya (       ) 8s | 1E029E | 360 | 190 | OK | 2013-01-30 00:00:00 | 206 | 180 | 26 | 254.769231 |  | YES | 65
AS | OWN | ASSO010080 | Asda MF Savoury Mince Soya (       ) 8s | 1P051A | 360 | 41 | OK | 2013-03-31 00:00:00 | 266 | 180 | 86 | 254.769231 |  | YES | 214
AS | OWN | ASSO010080 | Asda MF Savoury Mince Soya (       ) 8s | 1T016G | 360 | 26 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 254.769231 |  | YES | 229
AS | OWN | ASSO010080 | Asda MF Savoury Mince Soya (       ) 8s | 2G042A | 360 | 102 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 254.769231 |  | YES | 153
AS | OWN | [NAME] | Asda MF Bolognese Soya () 8s | 1W040F | 360 | 109 | OK | 2013-02-28 00:00:00 | 235 | 180 | 55 | 286.769231 |  | YES | 178
AS | OWN | [NAME] | Asda MF Bolognese Soya () 8s | 1C012J | 360 | 504 | OK | 2013-03-31 00:00:00 | 266 | 180 | 86 | 286.769231 |  | NO |  | 217 | 0
AS | OWN | [NAME] | Asda MF Bolognese Soya () 8s | 2K003B | 360 | 1253 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 286.769231 |  | NO |  | 966 | 3
AS | OWN | ASSO370080 | Asda MF Mexican [NAME] 8s (       ) | 2E016K | 360 | 636 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 243.846154 |  | NO |  | 392 | 1
AS | OWN | ASSP300061 | ASDA SNACK TOMATO & HERB (       ) | 1V012A | 360 | 153 | OK | 2013-03-31 00:00:00 | 266 | 180 | 86 | 1639.692308 |  | YES | 1487
AS | OWN | ASSP300061 | ASDA SNACK TOMATO & HERB (       ) | 1P017A | 360 | 137 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 1639.692308 |  | YES | 1503
AS | OWN | ASSP300061 | ASDA SNACK TOMATO & HERB (       ) | 1S039H | 360 | 133 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 1639.692308 |  | YES | 1507
AS | OWN | ASSP300061 | ASDA SNACK TOMATO & HERB (       ) | 1L047L | 360 | 4909 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 1639.692308 |  | NO |  | 3269 | 1
AS | OWN | ASSP480061 | ASDA SNACK CHICKEN & MUSHROOM (       ) | 1C048J | 360 | 1 | OK | 2012-12-30 00:00:00 | 175 | 180 |  | 1476.769231 | Below Customer Rules
AS | OWN | ASSP480061 | ASDA SNACK CHICKEN & MUSHROOM (       ) | 1F041N | 360 | 21 | OK | 2013-01-31 00:00:00 | 207 | 180 | 27 | 1476.769231 |  | YES | 1456
AS | OWN | ASSP480061 | ASDA SNACK CHICKEN & MUSHROOM (       ) | 2C003G | 360 | 30 | OK | 2013-03-31 00:00:00 | 266 | 180 | 86 | 1476.769231 |  | YES | 1447
AS | OWN | ASSP480061 | ASDA SNACK CHICKEN & MUSHROOM (       ) | 2C008B | 360 | 132 | OK | 2013-04-01 00:00:00 | 267 | 180 | 87 | 1476.769231 |  | YES | 1345
AS | OWN | ASSP480061 | ASDA SNACK CHICKEN & MUSHROOM (       ) | 1E047L | 360 | 5476 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 1476.769231 |  | NO |  | 3999 | 2
AS | OWN | ASSP480061 | ASDA SNACK CHICKEN & MUSHROOM (       ) | 2E013K | 360 | 123 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 1476.769231 |  | YES | 1354
AS | OWN | ASSP520061 | ASDA GFY SNACK CHICKEN NOODLE (       ) | 1L023A | 360 | 301 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 1084.692308 |  | YES | 784
AS | OWN | ASSP520061 | ASDA GFY SNACK CHICKEN NOODLE (       ) | 1S040D | 360 | 5353 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 1084.692308 |  | NO |  | 4268 | 3
AS | OWN | ASSP530061 | ASDA GFY SNACK CHOW MEIN (6361898) | 1R029E | 360 | 210 | OK | 2012-08-29 00:00:00 | 52 | 180 |  | 1099.230769 | Below Customer Rules
AS | OWN | ASSP530061 | ASDA GFY SNACK CHOW MEIN (6361898) | 2E034E | 360 | 86 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 1099.230769 |  | YES | 1014
AS | OWN | ASSP530061 | ASDA GFY SNACK CHOW MEIN (6361898) | 1T052C | 360 | 285 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 1099.230769 |  | YES | 815
AS | OWN | ASSP530061 | ASDA GFY SNACK CHOW MEIN (6361898) | 1H046A | 360 | 4188 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 1099.230769 |  | NO |  | 3088 | 2
AS | OWN | ASSP680061 | ASDA GFY SNACK MOROCCAN (6361884) | 1C033P | 360 | 24 | OK | 2013-02-28 00:00:00 | 235 | 180 | 55 | 319.769231 |  | YES | 296
AS | OWN | ASSP680061 | ASDA GFY SNACK MOROCCAN (6361884) | 1N023D | 360 | 2013 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 319.769231 |  | NO |  | 1693 | 5
AS | OWN | [NAME] | ASDA GFY SNACK R VEG (6361891) | 1Y048B | 360 | 3322 | OK | 2013-05-30 00:00:00 | 326 | 180 | 146 | 302 |  | NO |  | 3020 | 10
AS | OWN | ASSS770160 | Asda [NAME] *PMP*(6359350) | 1G035B | 540 | 231 | OK | 2013-03-31 00:00:00 | 266 | 180 | 86 | 313.615385 |  | YES | 83
AS | OWN | ASSS770160 | Asda [NAME] *PMP*(6359350) | 2A031C | 540 | 170 | OK | 2013-04-29 00:00:00 | 295 | 180 | 115 | 313.615385 |  | YES | 144
AS | OWN | ASSS770160 | Asda [NAME] *PMP*(6359350) | 1G026L | 540 | 93 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 313.615385 |  | YES | 221
AS | OWN | ASTC680092 | ASDA T&C TOMATO CUP SOUP 96G (6356697) | 1Y004L | 540 | 111 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 350.538462 |  | YES | 240
AS | OWN | ASTC840092 | ASDA T&C PEA & HAM CUP SOUP (6356690) | 1W007C | 540 | 573 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 0 |  | NO |  | 573 | Redundant Stock?
AS | OWN | ASTC880092 | ASDA T&C VEG CHOWDER CUP SOUP (6356956) | 1F031H | 540 | 48 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 0 |  | NO |  | 48 | Redundant Stock?
AS | OWN | SPCS600095 | Smart Price Veg Cup Soup 9 s (6336789) | 1E007M | 540 | 193 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 896.461538 |  | YES | 704
AS | OWN | SPHB510241 | Asda Smart Price [NAME] 128g | 1V032G | 360 | 92 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 1331 |  | YES | 1239
AS | OWN | SPHB510241 | Asda Smart Price [NAME] 128g | 1T023J | 360 | 4507 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 1331 |  | NO |  | 3176 | 2
AS | OWN | SPPA310082 | Smart Price Tom & Onion (6364173) 8s | 2C036G | 540 | 117 | OK | 2013-04-30 00:00:00 | 296 | 180 | 116 | 1826.230769 |  | YES | 1710
AS | OWN | SPPA460082 | Smart Price Cheese & Broc(6364180) 8s | 1E024D | 540 | 83 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 3050.692308 |  | YES | 2968
AS | OWN | SPPN480081 | S.Price [NAME] (6361786 | 1P004A | 360 | 230 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 6450.769231 |  | YES | 6221
AS | OWN | SPPN480081 | S.Price [NAME] (6361786 | D302 | 360 | 6161 | OK | 2013-06-30 00:00:00 | 357 | 180 | 177 | 6450.769231 |  | YES | 290
AS | OWN | SPPN700081 | S.Price [NAME] (6361793) | D302 | 360 | 20 | OK | 2013-05-31 00:00:00 | 327 | 180 | 147 | 4531.230769 |  | YES | 4512