Spreadsheet: 742129d1627550639-my-index-match-is-broken-planning-file
Sheet: Top Line Forecast

 | December | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December
Flea | 122900.2244 | 122067 | 124177 | 126472 | 129867.8991735252 | 127670 | 129455.3795845602 | 132991 | 137576 | 142016 | 145465 | 149335 | 150687 | 158629 | 165931 | 173442 | 182017 | 192186 | 206282 | 226530 | 248199 | 264126 | 278116 | 288415 | 294822
Order 1 |  |  |  |  |  |  | 9016 | 11995 | 12735 | 12104 | 10880 | 10990 | 8455
Order 2 |  |  |  |  |  |  | 6937 | 7329 | 9921 | 10740 | 10306 | 9331 | 9447
Order 3 |  |  |  |  |  |  | 9099 | 6250 | 6658 | 9099 | 9896 | 9530 | 8638
Order 4 |  |  |  |  |  |  | 8441 | 8187 | 5669 | 6097 | 8372 | 9138 | 8811
Order 5 |  |  |  |  |  |  | 7442 | 7763 | 7576 | 5288 | 5709 | 7861 | 8588
Order 6 |  |  |  |  |  |  | 8112 | 6963 | 7300 | 7168 | 5017 | 5429 | 7481
Order 7 |  |  |  |  |  |  | 8731 | 7649 | 6595 | 6952 | 6843 | 4799 | 5196
Order 8 |  |  |  |  |  |  | 7750 | 8356 | 7345 | 6358 | 6715 | 6619 | 4645
Order 9 |  |  |  |  |  |  | 6874 | 7398 | 8005 | 7066 | 6129 | 6482 | 6394
Order 10 |  |  |  |  |  |  | 7267 | 6537 | 7063 | 7677 | 6792 | 5901 | 6245
Order 11 |  |  |  |  |  |  | 6789 | 6841 | 6183 | 6716 | 7320 | 6488 | 5641
Order 12 |  |  |  |  |  |  | 5372 | 6429 | 6506 | 5909 | 6434 | 7024 | 6230
ITCH-FLEA-001 | RP2170 | [NAME] 50/60mg | Cat Flea | 0.447
ITCH-FLEA-002 | RP2171 | [NAME] 67/60.30mg | Small Dog Flea | 0.1324
ITCH-FLEA-003 | RP2172 | [NAME] 134/120.60mg | Medium Dog Flea | 0.0992
ITCH-FLEA-004 | RP2173 | [NAME] 268/241.60mg | Large Dog Flea | 0.074
ITCH-FLEA-005 | RP2174 | [NAME] 402/361.80mg | X Large Dog Flea | 0.0127
ITCH-WORM-001 | CP3926 | ItchWormForCats | Cat Wormer | 0.1071
ITCH-WORM-002 | CP3925 | ItchWormForDogs | Dog Wormer | 0.0593
ITCH-WORM-003 | CP3924 | ItchWormForDogsXL | XL Dog Wormer | 0.0197
ITCH-TREAT-001 | ITCH Branded Skin & Coat Cat |  |  | 0.005
ITCH-TREAT-002 | ITCH Branded Skin & Coat Dog |  |  | 0.007
ITCH-TREAT-003 | ITCH Branded Dental Dog |  |  | 0.004
ITCH-TREAT-004 | ITCH Branded Dental Cat |  |  | 0.0038
ITCH-TREAT-005 | ITCH Branded Fish |  |  | 0.0006
ITCH-TREAT-006 | ITCH Branded Calm Cat |  |  | 0.02
ITCH-TREAT-007 | ITCH Branded Calm Dog |  |  | 0.022
ITCH-TREAT-008 | ITCH Branded Poultry |  |  | 0.0008
ITCH-TREAT-009 | ITCH Branded Digestion dog |  |  | 0.0006
ITCH-TREAT-010 | ITCH Branded Digestion cat |  |  | 0.0004
ITCH-SUP-001 | ITCH JOINT
ITCH-SUP-002 | ITCH JOINT
ITCH-SUP-003 | ITCH DENTAL
ITCH-SUP-004 | ITCH EAR
ITCH-TSUP-005 | ITCH CALM
Wormer | January | February | March | April | May | June | July | August | September | October | November | December
Total (new + retained dogs and cats) | 8608.878307461708 | 7009.92618484821 | 6776.758440651227 | 12165.15848481939 | 26155 | 26857.56220769999 | 24902.48585838135 | 25000.10991028884 | 26796.15490683259 | 27245.83200652232 | 28467.48373179364 | 29765.1807429148
ITCH EAR VIALS |  |  |  |  |  |  | 0.00026 | 0.001 | 0.001 | 0.002 | 0.002 | 0.003 | 0.004
 |  |  |  |  |  |  |  |  | 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 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
ITCH-FOOD-01 | Chicken with [NAME], Puppy 2kg |  |  |  |  |  |  |  | 0.6921599834084395 | 2.051492201457903 | 6.262400727351081 | 6.711984861542248 | 7.281229043111662 | 8.24145215760868 | 8.94577716777166 | 9.741793918978377 | 10.6521874769094 | 11.72344538372779 | 13.09533305808736 | 14.94044610843393 | 16.96111797611098 | 18.64905422093693 | 20.24074398627559 | 21.59204488660656 | 22.65409455129092 | 23.91012559429976 | 25.16088309398507 | 26.44924070820469 | 27.85110287155495 | 29.41897594808993 | 31.4008684844545 | 34.02933685399544 | 36.82515882153925 | 39.03800668178604 | 41.05164353465123 | 42.67548302887218 | 43.87545353755574
ITCH-FOOD-02 | Chicken with [NAME], Puppy 6kg |  |  |  |  |  |  |  | 3.525588205461756 | 10.44948694294679 | 31.89818347125627 | 34.18818659027765 | 37.08769049208669 | 41.97868588077094 | 45.56623790366365 | 49.62083125877867 | 54.25801466595058 | 59.71457721192179 | 66.70242846001443 | 76.10070192854405 | 86.39320232521425 | 94.99087953709973 | 103.0983153871159 | 109.981305780141 | 115.3909651958548 | 121.7886887526539 | 128.1595509730739 | 134.7219332517229 | 141.8624626484857 | 149.8485857396712 | 159.9435596159295 | 173.3319341308059 | 187.5727414435957 | 198.8441100629568 | 209.1007768866951 | 217.3719706939368 | 223.4841441418783
ITCH-FOOD-03 | Chicken with [NAME], Puppy 12kg |  |  |  |  |  |  |  | 21.67839485303309 | 64.25257028313243 | 196.1378856762482 | 210.2188244971565 | 228.0475063505705 | 258.1216168482184 | 280.1810193580131 | 305.1121998017472 | 333.6256526068344 | 367.1773638442909 | 410.1447751533415 | 467.933567069522 | 531.2208469845037 | 584.0868740291361 | 633.9384690991469 | 676.2611043060824 | 709.5244141426075 | 748.8632051023633 | 788.0368291105726 | 828.3880856732962 | 872.2942955598929 | 921.3999538575473 | 983.4726682436336 | 1065.796085574151 | 1153.361004095933 | 1222.667220597924 | 1285.734164416419 | 1336.592686401933 | 1374.175665948277
ITCH-FOOD-04 | Chicken with [NAME], Small Dog under 10kg 2kg |  |  |  |  |  |  |  | 4.742241594409894 | 14.05552456305518 | 42.90600138982979 | 45.98626698225716 | 49.88636739245572 | 56.4652076933035 | 61.29079634223164 | 66.74459869704356 | 72.98203845258013 | 80.32161878925044 | 89.72092378831904 | 102.3624691874825 | 116.206832353877 | 127.7715018823121 | 138.6767515233208 | 147.9350089922904 | 155.21150028899 | 163.8170290667375 | 172.3864268674014 | 181.2134368261982 | 190.8181080294252 | 201.5601808110469 | 215.1388525731971 | 233.1474522183927 | 252.302652667517 | 267.4636839558152 | 281.2598476587073 | 292.3853668691931 | 300.6068043905044
ITCH-FOOD-05 | Chicken with [NAME], Small Dog under 10kg 6kg |  |  |  |  |  |  |  | 24.37464790959718 | 72.24399170489677 | 220.532559606113 | 236.3648169444924 | 256.4109433212518 | 290.225525053161 | 315.0285684942256 | 343.0605676070026 | 375.1203846516985 | 412.8450941480316 | 461.1565825836441 | 526.1328626831275 | 597.2915059102559 | 656.7327516449172 | 712.7846450531284 | 760.3711632787176 | 797.7716014140024 | 842.0031593929884 | 886.0490077602838 | 931.4189568775541 | 980.7860070805785 | 1035.999187737579 | 1105.792203697068 | 1198.354606298819 | 1296.810422454525 | 1374.736608255407 | 1445.647511056639 | 1502.831568040728 | 1545.088935343342
ITCH-FOOD-06 | Chicken with [NAME], Dog over 10kg 6kg |  |  |  |  |  |  |  | 26.82531380135504 | 79.50751760329219 | 242.7052541144904 | 260.1293118018472 | 282.1909076268462 | 319.4052612201501 | 346.7020421214745 | 377.5524230364527 | 412.8355851082781 | 454.3531969341968 | 507.521999302233 | 579.0310980091356 | 657.3441444714317 | 722.7617076497667 | 784.4491476247804 | 836.8200901241266 | 877.980827830297 | 926.6594970406102 | 975.1337850993264 | 1025.065301104655 | 1079.395793100067 | 1140.160194809098 | 1216.970311664944 | 1318.839085532307 | 1427.193806131386 | 1512.954814667977 | 1590.995212487691 | 1653.928645566278 | 1700.4346358278
ITCH-FOOD-07 | Chicken with [NAME], Dog over 10kg 12kg |  |  |  |  |  |  |  | 50.42482015126637 | 149.4540681055197 | 456.2246271979262 | 488.9774584116238 | 530.447690967461 | 600.4012840878962 | 651.7123434048715 | 709.7032739399414 | 776.0267143669423 | 854.0693469689248 | 954.0132774265444 | 1088.43233653528 | 1235.641100339548 | 1358.609609950609 | 1474.566429295439 | 1573.01058455257 | 1650.382383872294 | 1741.885997150028 | 1833.005425441598 | 1926.864074518112 | 2028.991688304316 | 2143.21342865251 | 2287.59706408488 | 2479.084650747606 | 2682.764180433976 | 2843.973233326038 | 2990.669486489481 | 3108.968458422819 | 3196.38798358697
ITCH-FOOD-08 | Salmon with Haddock, Puppy 2kg |  |  |  |  |  |  |  | 0.6921599834084395 | 2.051492201457903 | 6.262400727351081 | 6.711984861542248 | 7.281229043111662 | 8.24145215760868 | 8.94577716777166 | 9.741793918978377 | 10.6521874769094 | 11.72344538372779 | 13.09533305808736 | 14.94044610843393 | 16.96111797611098 | 18.64905422093693 | 20.24074398627559 | 21.59204488660656 | 22.65409455129092 | 23.91012559429976 | 25.16088309398507 | 26.44924070820469 | 27.85110287155495 | 29.41897594808993 | 31.4008684844545 | 34.02933685399544 | 36.82515882153925 | 39.03800668178604 | 41.05164353465123 | 42.67548302887218 | 43.87545353755574
ITCH-FOOD-09 | Salmon with Haddock, Puppy 6kg |  |  |  |  |  |  |  | 3.518215254479448 | 10.4276342617683 | 31.83147581016473 | 34.11668991817237 | 37.01013017927944 | 41.89089718417241 | 45.47094667311339 | 49.51706078552669 | 54.14454659786772 | 59.58969800735934 | 66.56293578339533 | 75.9415549402006 | 86.21253095668582 | 94.79222811844896 | 102.8827091445801 | 109.7513053577346 | 115.149651724 | 121.5339959240978 | 127.8915349620788 | 134.4401935384552 | 141.5657901721832 | 149.5352121370152 | 159.6090747140464 | 172.96945054522 | 187.1804765085876 | 198.4282736716438 | 208.6634910528136 | 216.9173875743396 | 223.0167788274809
ITCH-FOOD-10 | Salmon with Haddock, Puppy 12kg |  |  |  |  |  |  |  | 21.68002212831897 | 64.25739336253406 | 196.1526086451834 | 210.234604443045 | 228.0646245954224 | 258.1409925875523 | 280.2020509727367 | 305.1351028600929 | 333.6506960098587 | 367.2049257857433 | 410.1755624169173 | 467.9686922129789 | 531.2607227484384 | 584.1307181486551 | 633.9860552977806 | 676.3118674271209 | 709.5776741534014 | 748.919418055141 | 788.0959826071794 | 828.4502681119906 | 872.3597737910444 | 921.4691181745316 | 983.5464920104864 | 1065.876088897349 | 1153.447580425518 | 1222.758999355734 | 1285.830677255314 | 1336.693016904289 | 1374.27881759372
ITCH-FOOD-11 | Salmon with Haddock, Small Dog under 10kg 2kg |  |  |  |  |  |  |  | 8.177912699567669 | 24.23850631287746 | 73.99064907767935 | 79.30251322564831 | 86.02816817999502 | 97.37326323127857 | 105.6949064688306 | 115.0998932562864 | 125.8562490374258 | 138.5132269770372 | 154.7221640775009 | 176.5222880492204 | 200.3966502262434 | 220.339720590768 | 239.1456328910372 | 255.1113359924152 | 267.6595179858672 | 282.4996018738315 | 297.2773785236558 | 312.4994028351855 | 329.062490363377 | 347.5870070231902 | 371.0031890198746 | 402.0587041824674 | 435.0915123802434 | 461.2364457082438 | 485.0276887533453 | 504.2134520742117 | 518.391177307251
ITCH-FOOD-12 | Salmon with Haddock, Small Dog under 10kg 6kg |  |  |  |  |  |  |  | 23.55098948373012 | 69.80275141676204 | 213.0804108993379 | 228.3776708828583 | 247.7464065150436 | 280.4183393248451 | 304.3832481683086 | 331.4680010952629 | 362.4444655295515 | 398.8943966186115 | 445.5733624157943 | 508.3539898525631 | 577.1080684564538 | 634.5406992123483 | 688.6985092900964 | 734.6770027827929 | 770.813620159907 | 813.5505228907952 | 856.1079914354673 | 899.9448172432158 | 947.6436756836049 | 1000.991114458478 | 1068.425712529228 | 1157.860283167859 | 1252.989119469208 | 1328.282054534792 | 1396.796764258909 | 1452.048480290428 | 1492.877903412562
ITCH-FOOD-13 | Salmon with Potato, Dog over 10kg 6kg |  |  |  |  |  |  |  | 46.54911235283717 | 137.9668620921734 | 421.1586945845391 | 451.3941067380446 | 489.6768910642763 | 554.2537731608207 | 601.6210073507278 | 655.1546904223719 | 716.3804374017717 | 788.424626402407 | 880.6867551298812 | 1004.774215750364 | 1140.668350128849 | 1254.185363230233 | 1361.229612383089 | 1452.107240301198 | 1523.532157012271 | 1608.002700732173 | 1692.118588351538 | 1778.763157197629 | 1873.041128922666 | 1978.483659181668 | 2111.76980769922 | 2288.539445330005 | 2476.5639396743 | 2625.382285339308 | 2760.803301215235 | 2870.009682501887 | 2950.710045666109
ITCH-FOOD-14 | Salmon with Potato, Dog over 10kg 12kg |  |  |  |  |  |  |  | 31.50154989177421 | 93.36740852681875 | 285.0140627654896 | 305.4755129695762 | 331.3829251519552 | 375.0845506050887 | 407.1397545745745 | 443.3680283897472 | 484.8018136038094 | 533.5568488666376 | 595.99413078943 | 679.9688219081414 | 771.9335369745588 | 848.7548053302905 | 921.1957088164061 | 982.69604652873 | 1031.031996744815 | 1088.196417565734 | 1145.120829151657 | 1203.756495234128 | 1267.557974572338 | 1338.914934131341 | 1429.114726247295 | 1548.741444732671 | 1675.984751641861 | 1776.695770688647 | 1868.340308519457 | 1942.244408828084 | 1996.857405467687
ITCH-FOOD-15 | [NAME] and Salmon, [NAME] cat 2kg |  |  |  |  |  |  |  | 82.50276701914342 | 244.6678347776042 | 922.2181021852994 | 1030.837853227724 | 1153.694855584628 | 1317.460666364392 | 1420.245138463564 | 1541.661303216335 | 1682.894147660431 | 1851.107409662999 | 2065.456793800257 | 2351.883636489678 | 2671.11034494416 | 2950.544652650964 | 3241.348994696546 | 3484.27810640552 | 3676.7124230067 | 3890.970031600091 | 4105.855464953685 | 4327.224827457372 | 4565.774379913861 | 4828.995739284918 | 5152.324576284175 | 5569.593338404467 | 6013.649721302096 | 6377.83860526338 | 6715.496744478648 | 6999.09042537963 | 7222.963089898334
ITCH-FOOD-16 | Chicken with Fish & Rice, [NAME]  2kg |  |  |  |  |  |  |  | 97.49144990359142 | 289.117841971364 | 1089.761994146469 | 1218.115228830537 | 1363.29226619953 | 1556.810216135098 | 1678.268048091187 | 1821.742483812044 | 1988.633792750427 | 2187.407184215442 | 2440.698473714063 | 2779.161887657745 | 3156.384080071694 | 3486.58459085967 | 3830.220785966986 | 4117.284022510362 | 4344.678826521029 | 4597.861667161987 | 4851.786392570802 | 5113.373014383262 | 5395.2610356352 | 5706.303112135787 | 6088.372686934236 | 6581.448714422439 | 7106.179001318017 | 7536.531868488133 | 7935.534020212412 | 8270.649557950896 | 8535.19426895004