Spreadsheet: 742129d1627550639-my-index-match-is-broken-planning-file
Sheet: Madison Plan

Item Code | Product Name | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00
ITCH-FLEA-001-BA1-BA8 | ITCH FLEA FOR CATS (KIT) | 314184.9376516357 |  |  | 224461 |  |  |  |  |  |  |  | 270333 | 42185
 | Opening Stock
 | Sales |  |  |  | 40687 | 44633 | 50419 | 54327
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  | 24256 | 88570 | 115104 |  | 287529 |  |  |  | 45000 | 33900 | 49200 | 55200 |  | 44700 | 48450 | 51900
 | [NAME]
ITCH-FLEA-002-BA1-BA8 | ITCH FLEA FOR DOGS SMALL (KIT) | 107442.0506909967 |  |  | 80797 |  |  |  |  |  |  |  | 58518 | 8923
 | Opening Stock
 | Sales |  |  |  | 11811 | 13062 | 15055 | 16033
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 39944 | 7056 |  | 75646 |  |  |  | 17450 | 19050 | 18450 | 20700 |  | 16800 | 18150 | 19919
 | [NAME]
ITCH-FLEA-003-BA1-BA8 | ITCH FLEA FOR DOGS MEDIUM (KIT) | 85108.74464605626 |  |  | 66520 |  |  |  |  |  |  |  | 52257 | 5412
 | Opening Stock
 | Sales |  |  |  | 8353 | 9431 | 11199 | 12025
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 34178 |  |  | 58160 |  |  |  | 12950 | 18000 | 14850 | 16500 |  | 13350 | 14550 | 15600
 | [NAME]
ITCH-FLEA-004-BA1-BA8 | ITCH FLEA FOR DOGS LARGE (KIT) | 60060.26511235098 |  |  | 48832 |  |  |  |  |  |  |  | 45300 | 9528
 | Opening Stock
 | Sales |  |  |  | 6334 | 7182 | 8522 | 9151
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 32935 |  |  | 42485 |  |  |  | 9450 | 8250 | 11100 | 12450 |  | 10050 | 10950 | 11700
 | [NAME]
ITCH-FLEA-005-BA1-BA8 | ITCH FLEA FOR DOGS XLARGE (KIT) | 30201.6530224702 |  |  | 24699 |  |  |  |  |  |  |  | 14223 | 1115
 | Opening Stock
 | Sales |  |  |  | 1011 | 1086 | 1328 | 1476
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  |  |  |  |  |  |  |  | 1350 | 600 | 1200 | 1500 |  | 1050 | 1200 | 1350
 | [NAME]
ITCH-WORM-ITCH-FLEA-001 | ITCH FLEA & WORM FOR CATS (KIT) | 60387.02049310711 |  |  | 31505 |  |  |  |  |  |  |  | 77252 | 2353
 | Opening Stock
 | Sales |  | 6859 | 6367 | 10366 | 11057 | 10873 | 13435 | 13936
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  | 22000 |  |  | 24700 | 26000 | 56000 |  |  | 5850 | 9150 | 7050 | 7950 |  | 6300 | 6900 | 7500
 | [NAME]
ITCH-WORM-ITCH-FLEA-002 | ITCH FLEA & WORM FOR CATS ENV (KIT) | 59565.49392143867 |  |  | 46562 |  |  |  |  |  |  |  | 53082 | 12962
 | Opening Stock
 | Sales |  | 3224 | 2948 | 6030 | 5601 | 5810 | 7612
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  |  |  |  | 20000 |  | 30000 |  | 10900 | 10800 | 14100 | 15750 |  | 12750 | 13800 | 14850
 | [NAME]
ITCH-WORM-ITCH-FLEA-003 | ITCH FLEA & WORM DOG SMALL (KIT) | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 4440
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427
 | [NAME]
ITCH-WORM-ITCH-FLEA-004 | ITCH FLEA & WORM DOG SMALL ENV (KIT) | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 9720
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  | 3500 | 4200 | 6900 | 7950 |  | 6450 | 6900 | 7350
 | [NAME]
ITCH-WORM-ITCH-FLEA-005 | ITCH FLEA & WORM DOG MEDIUM (KIT) | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 4879
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  | 2900 | 5250 | 5250 | 6000 |  | 4800 | 5100 | 5550
 | [NAME]
ITCH-WORM-ITCH-FLEA-006 | ITCH FLEA & WORM DOG LARGE (KIT) | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 4288
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  | 1400 | 3000 | 3600 | 3900 |  | 3150 | 3450 | 3750
 | [NAME]
ITCH-WORM-ITCH-FLEA-007 | ITCH FLEA & WORM DOG LARGE ENV (KIT) | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 680
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  |  | 750 | 450 | 600 |  | 450 | 600 | 450
 | [NAME]
ITCH-WORM-ITCH-FLEA-008 | ITCH FLEA & WORM DOG XLARGE (KIT) | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 849
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  | 150 | 300 | 600 | 600 |  | 450 | 600 | 450
 | [NAME]
ITCH-WORM-ITCH-FLEA-009 | ITCH FLEA & WORM DOG XLARGE ENV (KIT) | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 0
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427
 | [NAME]
ITCH-FLEA-DOUBLE-001 | ITCH FLEA FOR CAT & CAT (KIT) | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 8995
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  | 16200 | 31050 | 22800 | 25650 |  | 20850 | 22350 | 24150
 | [NAME]
ITCH-FLEA-DOUBLE-002 | [NAME] for Dogs Small & Itch Flea for Dogs Small | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 4727
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  | 1500 | 2550 | 3450 | 3900 |  | 3300 | 3450 | 3600
 | [NAME]
ITCH-FLEA-DOUBLE-003 | [NAME] Dogs Medium & Itch Flea for Dogs Medium | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 2617
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  |  | 1800 | 1800 | 1950 |  | 1500 | 1800 | 1800
 | [NAME]
ITCH-FLEA-DOUBLE-004 | [NAME] Cats  & Itch Flea for Dogs Small | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 6645
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  | 450 | 6000 | 5250 | 5850 |  | 4800 | 5250 | 5550
 | [NAME]
ITCH-FLEA-DOUBLE-005 | [NAME] Cats  & Itch Flea for Dogs Medium | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 6171
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  | 1400 | 2850 | 4200 | 4800 |  | 3750 | 4200 | 4500
 | [NAME]
ITCH-FLEA-DOUBLE-006 | [NAME] Cats  & Itch Flea for Dogs Large | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 4894
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  | 2000 | 1800 | 3600 | 3900 |  | 3150 | 3450 | 3750
 | [NAME]
ITCH-FLEA-DOUBLE-007 | [NAME] Cats  & Itch Flea for Dogs X Large | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 388
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  |  | 150 | 150 | 150 |  | 150 | 150 | 300
 | [NAME]
ITCH-FLEA-DOUBLE-008 | [NAME] for Dogs Small & Itch Flea for Dogs Medium | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 3700
 | Opening Stock
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Target (1.1 Month Stock)
 | Inbound |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  | 450 | 1500 | 2400 | 2550 |  | 1950 | 2250 | 2550
 | [NAME]