Spreadsheet: 101354d1299511196-excel-2007-pivot-table-formatting-total-supplier-analysis-09
Sheet: T&O Wholesaler

Created
Helena Chemical Company- All Business Units
Top 25 Suppliers-Wholesale Only
T&O Subcategory Only (Includes Turf and Ornamental)
2008 - 2009 - With Inventory Coverage Effect (in 000's)
 |  | Sales Volume $ |  | GP $ [NAME] |  | Rebate Volume $ |  | GP A/Rebate |  | GP% B4 Rebate |  | GP% A/Rebate |  | Volume Rank |  | GP Rank |  | GP% Rank
Program Year | Supplier | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009
Oct 1- Sept 30 | SYNGENTA | 6816739.66 | 5039562.5 | -390887.91 | 38774.56 | 506709.53 | 396600.86 | 115821.62 | 435375.42 | -0.05734235565628158 | 0.007694032964170996 | 0.01699076476099426 | 0.08639151116788411 | 1 | 1 | 9 | 2 | 24 | 22
Oct 1- Sept 30 | BAYER | 4489706.6 | 2823340.57 | -14919.35 | 51757.2 | 329021.31 | 360754.7 | 314101.96 | 412511.9 | -0.003323012243160834 | 0.0183319010642772 | 0.06996046467713504 | 0.146107736481823 | 2 | 2 | 2 | 3 | 23 | 12
Sept 1 - Aug 31 | DOW | 2647242.4 | 2664131.14 | -38398.56 | -63118.94 | 360560.53 | 509373.66 | 322161.97 | 446254.72 | -0.01450511672070529 | -0.02369212950981084 | 0.1216971932755383 | 0.1675047873206422 | 3 | 3 | 1 | 1 | 19 | 9
Nov 1 - Oct 31 | PBI GORDON CORP | 1689710.19 | 1783389.19 | 124654.25 | 84597.28 | 90707.21 | 116991.57 | 215361.46 | 201588.85 | 0.07377256214570145 | 0.04743624132879262 | 0.12745467315907 | 0.1130369361496466 | 4 | 4 | 5 | 5 | 18 | 18
Dec 1 - Nov 30 | VALENT | 843914.73 | 1112458.86 | 49720.41 | 51828.39 | 85802.22 | 101052.39 | 135522.63 | 152880.78 | 0.05891639075905217 | 0.04658903970615146 | 0.1605880608340608 | 0.1374260078255838 | 8 | 5 | 8 | 7 | 11 | 14
Sept 1 - Aug 31 | MONSANTO | 1396973.21 | 947504.36 | -27093.9 | 14198.72 | 327700.12 | 214365.94 | 300606.22 | 228564.66 | -0.01939471695380615 | 0.01498538750787384 | 0.215183954744558 | 0.2412280825810659 | 5 | 6 | 3 | 4 | 5 | 4
Aug 1 - July 31 | NUFARM | 961657.2 | 911912.38 | -8788.13 | -7255.86 | 161855.66 | 112569.29 | 153067.53 | 105313.43 | -0.00913852670161467 | -0.00795675128349502 | 0.1591705755439672 | 0.1154863474931659 | 7 | 7 | 7 | 9 | 12 | 17
Oct 1- Sept 30 | BASF | 1172267.93 | 876813.04 | 2164.59 | 37344.36 | 173408.62 | 141023.03 | 175573.21 | 178367.39 | 0.001846497668839239 | 0.042591018035042 | 0.1497722538566759 | 0.2034269358037832 | 6 | 8 | 6 | 6 | 14 | 7
Calendar | CHEMTURA | 598813.6 | 733805.17 | 32289.87 | 52456.91 | 10350.11 | 11650.63 | 42639.98 | 64107.54 | 0.05392307389144135 | 0.07148615483316914 | 0.07120743416649189 | 0.08736316207747623 | 11 | 9 | 14 | 12 | 22 | 21
Calendar | FMC | 601891.7 | 608619.29 | 20599.4 | 27034.55 | 62066.44 | 116383.71 | 82665.84 | 143418.26 | 0.03422442941147054 | 0.04441947608988864 | 0.1373433792158955 | 0.2356452750618535 | 10 | 10 | 11 | 8 | 16 | 6
Calendar | SETRE CHEMICAL | 690294.4 | 420316.4 | 33192.52 | -9988.15 | 201214.05 | 93377.67 | 234406.57 | 83389.52 | 0.04808458535952196 | -0.02376340775663286 | 0.3395747814265913 | 0.1983970171042576 | 9 | 11 | 4 | 10 | 1 | 8
Oct 1- Sept 30 | CLEARY | 419033.6 | 384666.32 | 25272.21 | 25324.57 | 72559.61 | 25597.68 | 97831.82 | 50922.25 | 0.0603107006216208 | 0.06583516331765152 | 0.2334701083636253 | 0.1323803186096459 | 12 | 12 | 10 | 13 | 4 | 15
Nov 1 - Oct 31 | GOWAN | 367473.02 | 317415.51 | 11330.66 | 20207.85 | 46604.43 | 25841.07 | 57935.09 | 46048.92 | 0.03083399156759862 | 0.06366371321930676 | 0.1576580778637844 | 0.1450745743331824 | 13 | 13 | 12 | 14 | 13 | 13
Nov 1 - Oct 31 | UPI | 199036.45 | 289440.84 | 14355.5 | 14001.03 | 17617.11 | 10460.15 | 31972.61 | 24461.18 | 0.07212498012298751 | 0.04837268299801783 | 0.1606369587078146 | 0.08451184704964233 | 17 | 14 | 16 | 18 | 10 | 23
Oct 1- Sept 30 | SEPRO | 253994.32 | 202956.25 | 12918.39 | 22333.73 | 13780.64 | 10914.22 | 26699.03 | 33247.95 | 0.05086094051237051 | 0.1100420903519847 | 0.1051166419784505 | 0.1638183105964955 | 14 | 15 | 18 | 15 | 21 | 10
Nov 1 - Oct 31 | DUPONT | 170392.68 | 195352.5 | 8516.36 | 6478.05 | 45888.88 | 11242.14 | 54405.24 | 17720.19 | 0.04998078555956747 | 0.033160824663109 | 0.319293293585147 | 0.0907087956386532 | 18 | 16 | 13 | 21 | 2 | 20
Nov 1 - Oct 31 | OHP | 230207.1 | 144416.27 | 21626.14 | 12933.11 | 8863.9 | 8271.3 | 30490.04 | 21204.41 | 0.0939421069115592 | 0.08955438331152024 | 0.1324461322000929 | 0.1468284009827979 | 15 | 17 | 17 | 20 | 17 | 11
Calendar | AMVAC | 211608.41 | 139940.82 | 15045.73 | 17161.8 | 21447.72 | 15987.77 | 36493.45 | 33149.57 | 0.07110175819571632 | 0.1226361257565877 | 0.1724574651829764 | 0.2368827765908475 | 16 | 18 | 15 | 16 | 7 | 5
Calendar | ARYSTA | 66221.25 | 119925.36 | -1051.37 | 2260.89 | 21415.26 | 64915.07 | 20363.89 | 67175.96 | -0.01587662570549483 | 0.01885247624022142 | 0.3075129207014365 | 0.5601480787716627 | 22 | 19 | 19 | 11 | 3 | 1
Calendar | SIPCAM | 83261.13 | 112486.66 | 11310.77 | 16348.84 | 5134.43 | 13213.19 | 16445.2 | 29562.03 | 0.1358469432254883 | 0.1453402563468415 | 0.197513533626075 | 0.2628047628047628 | 19 | 20 | 21 | 17 | 6 | 3
Calendar | SCOTTS | 82061.51 | 90554.57 | 3997.84 | 6570.68 | 7353.11 | 530.63 | 11350.95 | 7101.31 | 0.04871760219864343 | 0.07256044614865931 | 0.1383224607980039 | 0.07842022771462555 | 20 | 21 | 22 | 23 | 15 | 24
Calendar | TIDE INT'L | 0 | 63769 | 0 | 24198.07 | 0 | 9.15 | 0 | 24207.22 |  | 0.3794644733334379 |  | 0.3796079599805549 | 90 | 22 | 89 | 19 | - | 2
Calendar | WELLMARK | 63972.21 | 63344.42 | 4961.25 | 7845.2 | 1885.7 | 441.42 | 6846.95 | 8286.62 | 0.07755320630630082 | 0.1238498986966808 | 0.1070300682124316 | 0.1308184683039169 | 23 | 23 | 25 | 22 | 20 | 16
Calendar | CERTIS | 67356.5 | 54215 | 9557.52 | 4845.95 | 1556.13 | 192.19 | 11113.65 | 5038.14 | 0.1418945461833676 | 0.089383934335516 | 0.164997438999948 | 0.0929288942174675 | 21 | 24 | 23 | 25 | 9 | 19
Calendar | LUXEMBOURG PAMOL | 10689.8 | 50147.03 | 1797.14 | 1873.55 | 0 | 1016.5 | 1797.14 | 2890.05 | 0.1681172706692361 | 0.03736113584393732 | 0.1681172706692361 | 0.05763152872662649 | 39 | 25 | 35 | 31 | 8 | 25
Top 25 Total |  |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | - | -
* Excludes Miscellaneous Vendor