Spreadsheet: 742129d1627550639-my-index-match-is-broken-planning-file
Sheet: Chanelle Planning Horizon

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 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
ITCH-FLEA-001 | [NAME] 50/60mg (Cat) (MOQ 10k Unit) | 314184.9376516357 |  |  | 224461 |  |  |  |  |  |  |  | 270333
 | Opening Stock |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 364365
 | Sales |  |  |  | 40687 | 44633 | 50419 | 54327
 | Weeks Cover (Start Month)
 | Weeks Cover (End Month without [NAME])
 | Target (1.5 Month Stock)
 | Inbound (Targetted Month End) |  |  |  |  |  | 24256 | 88570 | 115104 |  | 287529 |  |  |  | 281970 | 39730 |  |  |  | 107337 | 186583 |  |  | 160000 |  | 200000 |  | 250000
 | [NAME]
ITCH-FLEA-002 | [NAME] 67/60.30mg (S.Dog) (MOQ 10k Unit) | 107442.0506909967 |  |  | 80797 |  |  |  |  |  |  |  | 58518
 | Opening Stock |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64959
 | Sales |  |  |  | 11811 | 13062 | 15055 | 16033
 | Weeks Cover
 | Weeks Cover (End Month without [NAME])
 | Target (1.5 Month Stock)
 | Inbound (Targetted Month End) |  |  |  |  |  |  | 39944 | 7056 |  | 75646 |  |  |  | 68597 |  |  | 45000 |  | 84836 |  |  |  | 50000 |  | 40000
 | [NAME]
ITCH-FLEA-003 | [NAME] 134/120.60mg (M.Dog) (MOQ 10k Unit) | 85108.74464605626 |  |  | 66520 |  |  |  |  |  |  |  | 52257
 | Opening Stock |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81621
 | Sales |  |  |  | 8353 | 9431 | 11199 | 12025
 | Weeks Cover
 | Weeks Cover (End Month without [NAME])
 | Target (1.5 Month Stock)
 | Inbound (Targetted Month End) |  |  |  |  |  |  | 34178 |  |  | 58160 |  |  |  | 82864 |  |  |  |  | 19318 | 31470 |  | 25000 |  | 40000
 | [NAME]
ITCH-FLEA-004 | [NAME] 268/241.60mg (L.Dog) (MOQ 10k Unit) | 60060.26511235098 |  |  | 48832 |  |  |  |  |  |  |  | 45300
 | Opening Stock |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69129
 | Sales |  |  |  | 6334 | 7182 | 8522 | 9151
 | Weeks Cover
 | Weeks Cover (End Month without [NAME])
 | Target (1.5 Month Stock)
 | Inbound (Targetted Month End) |  |  |  |  |  |  | 32935 |  |  | 42485 |  |  |  | 15586 | 52102 |  |  |  | 18808 |  | 30000 |  |  | 30000
 | [NAME]
ITCH-FLEA-005 | [NAME] 402/361.80mg (XL.Dog) (MOQ 5k Unit) | 30201.6530224702 |  |  | 24699 |  |  |  |  |  |  |  | 14223
 | Opening Stock |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14383
 | Sales |  |  |  | 1011 | 1086 | 1328 | 1476
 | Weeks Cover
 | Weeks Cover (End Month without [NAME])
 | Target (1.5 Month Stock)
 | Inbound (Targetted Month End) |  |  |  |  |  |  |  |  |  |  |  |  |  | 8900 |  |  | 10000 |  |  |  |  |  | 5650 |  | 5000
 | [NAME]
ITCH-WORM-001 | ItchWormForCats (MOQ 20k Unit) | 60387.02049310711 |  |  | 31505 |  |  |  |  |  |  |  | 77252 | 66237 | 57372
 | Opening Stock |  |  |  |  |  |  |  |  |  |  |  |  |  | 66237 | 57372 | 45224
 | Sales |  | 6859 | 6367 | 10366 | 11057 | 10873 | 13435 | 13936
 | Weeks Cover
 | Weeks Cover (End Month without [NAME])
 | Target (1.5 Month Stock)
 | Inbound (Targetted Month End) |  |  |  |  |  | 22000 |  |  | 24700 | 26000 | 56000 |  |  |  |  | 59010 |  |  |  | 30000 |  |  | 30000 |  | 30000
 | [NAME]
ITCH-WORM-002 | ItchWormForDogs (MOQ 20k Unit) | 59565.49392143867 |  |  | 46562 |  |  |  |  |  |  |  | 53082
 | Opening Stock |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39081
 | Sales |  | 3224 | 2948 | 6030 | 5601 | 5810 | 7612
 | Weeks Cover
 | Weeks Cover (End Month without [NAME])
 | Target (1.5 Month Stock)
 | Inbound (Targetted Month End) |  |  |  |  |  |  |  |  |  | 20000 |  | 30000 |  |  | 5600 | 25000 |  |  |  | 20000 |  | 30000
 | [NAME]
ITCH-WORM-003 | ItchWormForDogsXL (MOQ 10k Unit) | 10690.85307396607 |  |  | 7908 |  |  |  |  |  |  |  | 5783 | 5783
 | Opening Stock |  |  |  |  |  |  |  |  |  |  |  |  |  | 4876 |  | 9708
 | Sales |  | 1025 | 977 | 1873 | 1947 | 2017 | 2596
 | Weeks Cover
 | Weeks Cover (End Month without [NAME])
 | Target (1.5 Month Stock)
 | Inbound (Targetted Month End) |  |  |  |  |  |  | 5000 |  | 5000 |  | 9427 |  |  |  | 10000 |  |  | 10000 |  | 10000 |  |  |  |  | 10000
 | [NAME]
 | Global Stock Turn (Weeks)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4