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

Created
Helena Chemical Company- All Business Units
Top 25 Suppliers-Wholesale and Retail
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 | 23489302.28 | 19373752.83 | -686393.22 | 254124.72 | 3284778.41 | 2663314.24 | 2598385.19 | 2917438.96 | -0.02922152441217594 | 0.01311695892013711 | 0.1106199391972744 | 0.1505871880166854 | 1 | 1 | 2 | 1 | 22 | 16
Oct 1- Sept 30 | BAYER | 16542862.93 | 13084449.7 | 441124.23 | 637014.1 | 2366215.85 | 2016986.26 | 2807340.08 | 2654000.36 | 0.0266655313452446 | 0.04868482164748587 | 0.1697009817393198 | 0.2028362232154097 | 2 | 2 | 1 | 2 | 13 | 11
Sept 1 - Aug 31 | DOW | 9727706.4 | 9206390.5 | -83129.57 | -16115.48 | 1722293.37 | 2036805.22 | 1639163.8 | 2020689.74 | -0.008545649568535499 | -0.001750466700277378 | 0.1685046538822348 | 0.2194877286597826 | 3 | 3 | 4 | 3 | 15 | 10
Nov 1 - Oct 31 | PBI GORDON CORP | 5132329.86 | 6142324.16 | 441669.89 | 532935.68 | 281559 | 387959.58 | 723228.89 | 920895.26 | 0.08605641142481048 | 0.08676449925430182 | 0.1409162913780448 | 0.149926190154054 | 6 | 4 | 9 | 7 | 19 | 18
Sept 1 - Aug 31 | MONSANTO | 6098747.36 | 5988236.47 | 237205.62 | 114134.6 | 1631767.65 | 1423820.48 | 1868973.27 | 1537955.08 | 0.03889415415955187 | 0.0190598017582963 | 0.3064519908232434 | 0.2568293833593382 | 4 | 5 | 3 | 4 | 3 | 5
Aug 1 - July 31 | NUFARM | 4689237.86 | 5492962.5 | 55091.95 | 345897.9 | 1049268.34 | 994477.11 | 1104360.29 | 1340375.01 | 0.01174859361900656 | 0.06297110165962357 | 0.2355095482403189 | 0.2440167778316346 | 9 | 6 | 6 | 5 | 7 | 6
Dec 1 - Nov 30 | VALENT | 4970462.85 | 5333197.16 | 220436.35 | 361676.59 | 618276.57 | 514039.03 | 838712.92 | 875715.62 | 0.04434926014988725 | 0.06781609213937255 | 0.1687394001948933 | 0.1642008712087441 | 7 | 7 | 8 | 8 | 14 | 14
Oct 1- Sept 30 | BASF | 5710105.51 | 5087162.49 | 123503.48 | 83479.13 | 1130412.94 | 785125.14 | 1253916.42 | 868604.27 | 0.02162893133650695 | 0.01640976284207505 | 0.2195960158361417 | 0.1707443534008287 | 5 | 8 | 5 | 9 | 11 | 13
Calendar | FMC | 4698247.52 | 4463322.12 | 289380.47 | 166484.63 | 667859.69 | 873175.29 | 957240.16 | 1039659.92 | 0.06159327893392896 | 0.03730060827426903 | 0.2037440888171852 | 0.2329340997687167 | 8 | 9 | 7 | 6 | 12 | 7
Calendar | CHEMTURA | 3217217.96 | 3124334.76 | 120958.9 | 187417.4 | 126344.35 | 79506.24 | 247303.25 | 266923.64 | 0.03759735942789527 | 0.05998633769961322 | 0.07686866512457241 | 0.08543375166366617 | 10 | 10 | 16 | 15 | 25 | 24
Nov 1 - Oct 31 | UPI | 1354472.54 | 2002483.99 | 192100.91 | 237520.67 | 123640.68 | 161933 | 315741.59 | 399453.67 | 0.1418270982444576 | 0.1186130182244303 | 0.2331103663423106 | 0.1994790829763388 | 15 | 11 | 13 | 12 | 8 | 12
Nov 1 - Oct 31 | OHP | 2322792.15 | 1996076.67 | 128754.95 | 127771.28 | 97654.73 | 74451.56 | 226409.68 | 202222.84 | 0.05543111121673112 | 0.06401120854741517 | 0.09747306921112163 | 0.1013101565883238 | 12 | 12 | 17 | 18 | 24 | 21
Nov 1 - Oct 31 | GOWAN | 2265097.59 | 1899539.56 | 116915.32 | 125765.97 | 243093.41 | 120776.13 | 360008.73 | 246542.1 | 0.05161601889303145 | 0.0662086605872004 | 0.158937403663919 | 0.1297904530085175 | 13 | 13 | 12 | 16 | 18 | 20
Oct 1- Sept 30 | CLEARY | 2388752.27 | 1860984.62 | 203678.34 | 187581.53 | 367277.03 | 91574.64 | 570955.37 | 279156.17 | 0.08526557674396265 | 0.1007969265216174 | 0.2390182427749195 | 0.1500045551155603 | 11 | 14 | 10 | 14 | 6 | 17
Oct 1- Sept 30 | SEPRO | 1467070.45 | 1573340.28 | 92186.52 | 392092.34 | 66343.16 | 76059.43 | 158529.68 | 468151.77 | 0.06283714595982763 | 0.249210132724753 | 0.1080586688935082 | 0.297552777330534 | 14 | 15 | 20 | 11 | 23 | 2
Calendar | ARYSTA | 792310.54 | 1218981.15 | 44354.28 | 118424.18 | 260878.08 | 429571.79 | 305232.36 | 547995.97 | 0.05598092889184586 | 0.09715013230516321 | 0.3852433415816985 | 0.4495524561639038 | 19 | 16 | 14 | 10 | 1 | 1
Calendar | SIPCAM | 562406.94 | 1183412.41 | 96945.5 | 190416.76 | 28717.97 | 145202.78 | 125663.47 | 335619.54 | 0.1723760734531476 | 0.1609048193097789 | 0.2234386901413415 | 0.2836031945955341 | 22 | 17 | 22 | 13 | 10 | 4
Calendar | SETRE CHEMICAL | 1250539 | 894250.7 | 71237.59 | -2232.42 | 345694.54 | 206124.41 | 416932.13 | 203891.99 | 0.05696550847274655 | -0.00249641403691381 | 0.333401941083005 | 0.2280031651079502 | 17 | 18 | 11 | 17 | 2 | 8
Calendar | SCOTTS | 1251399.36 | 863267.7 | 76142.52 | 65807.97 | 98755 | 4322.04 | 174897.52 | 70130.01 | 0.06084589974538584 | 0.07623124321690711 | 0.1397615546167452 | 0.08123784777306042 | 16 | 19 | 19 | 24 | 20 | 25
Nov 1 - Oct 31 | DUPONT | 520952.46 | 851887.23 | 49824.82 | 63200.44 | 98718 | 60827.61 | 148542.82 | 124028.05 | 0.09564177890627486 | 0.07418873974669159 | 0.2851369969536184 | 0.1455920990856971 | 23 | 20 | 21 | 20 | 5 | 19
Calendar | AMVAC | 1146164.83 | 805214.59 | 126192.28 | 116198.65 | 140227.22 | 62498.93 | 266419.5 | 178697.58 | 0.1100995918710924 | 0.144307680763708 | 0.2324443160587993 | 0.2219254124543372 | 18 | 21 | 15 | 19 | 9 | 9
Calendar | LUXEMBOURG PAMOL | 204566.77 | 636672.3 | 34234.41 | 82530.39 | 0 | 13475.49 | 34234.41 | 96005.88 | 0.1673507872270751 | 0.1296277378488117 | 0.1673507872270751 | 0.1507932416723643 | 28 | 22 | 32 | 23 | 16 | 15
Calendar | CERTIS | 587269.4 | 395862.79 | 65543.73 | 35320.85 | 13959.42 | 1934.95 | 79503.15 | 37255.8 | 0.1116076029161403 | 0.08922498121129294 | 0.1353776478052492 | 0.09411291220374617 | 20 | 23 | 24 | 28 | 21 | 23
Calendar | INTEGRA SEED | 75100.1 | 394568.02 | 7956 | 33356.14 | 4477.12 | 4297.72 | 12433.12 | 37653.86 | 0.1059386072721607 | 0.08453837693181519 | 0.165553973962751 | 0.09543059267702435 | 45 | 24 | 42 | 27 | 17 | 22
Calendar | MITCHELL PRODUCTS | 314968.44 | 337985.85 | 92412.93 | 98951.78 | 0 | 0 | 92412.93 | 98951.78 | 0.2934037772165363 | 0.2927690020159128 | 0.2934037772165363 | 0.2927690020159128 | 24 | 25 | 23 | 22 | 4 | 3
Top 25 Total |  |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | - | -
* Excludes Miscellaneous Vendor