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

Created
Helena Chemical Company- All Business Units
Top 25 Suppliers-Retail and Wholesale
[NAME] Only
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 | 343294595.32 | 360499980.73 | -18069603.21 | -22906385.89 | 76500863.71 | 84920726.82 | 58431260.5 | 62014340.93 | -0.05263585112126956 | -0.06354060225916063 | 0.1702073417308934 | 0.1720231463103634 | 1 | 1 | 2 | 1 | 14 | 15
Sept 1 - Aug 31 | MONSANTO | 252228645.88 | 181595236.98 | -30242559.57 | -16173756.97 | 104346882.25 | 40240048.68 | 74104322.68 | 24066291.71 | -0.1199013675250359 | -0.08906487438203733 | 0.2937982021092711 | 0.1325271086964167 | 2 | 2 | 1 | 3 | 2 | 21
Sept 1 - Aug 31 | DOW | 120543103.81 | 115377115.22 | -423565.04 | 571168.72 | 17578069.05 | 20738944.64 | 17154504.01 | 21310113.36 | -0.003513805656337032 | 0.004950450693024356 | 0.1423101236636392 | 0.1846996548610708 | 4 | 3 | 5 | 5 | 20 | 13
Nov 1 - Oct 31 | BAYER | 104460691.74 | 111678828.77 | -4503115.43 | -8095490.74 | 26623528.89 | 30271704.29 | 22120413.46 | 22176213.55 | -0.04310822908590477 | -0.07248903690306852 | 0.2117582517551879 | 0.1985713298952249 | 5 | 4 | 4 | 4 | 11 | 9
Oct 1- Sept 30 | BASF | 132615438.44 | 108986707.93 | -3504687.96 | -2186547.21 | 35328453.6 | 26858052.4 | 31823765.64 | 24671505.19 | -0.02642745068920197 | -0.02006251268186186 | 0.239970293160085 | 0.2263716893425758 | 3 | 5 | 3 | 2 | 8 | 6
Oct 1- Sept 30 | DUPONT | 93712503.04 | 86188632.29 | -590474.93 | -1065181.1 | 15768916.08 | 17333595.61 | 15178441.15 | 16268414.51 | -0.006300919416782232 | -0.01235871914542015 | 0.1619681542762898 | 0.1887535986794808 | 6 | 6 | 6 | 7 | 18 | 11
Nov 1 - Oct 31 | FMC | 45979154.03 | 48929708.77 | -921024.69 | -1809849.31 | 12587507.11 | 13143073.05 | 11666482.42 | 11333223.74 | -0.0200313535433701 | -0.03698876113298395 | 0.2537341685840495 | 0.2316225464016797 | 8 | 7 | 8 | 9 | 6 | 5
Oct 1- Sept 30 | ALBAUGH | 67487203.68 | 38420190.83 | -5708213.11 | -20039091.89 | 20678054.46 | 28285179.45 | 14969841.35 | 8246087.56 | -0.08458215481954608 | -0.5215771045664013 | 0.2218174784805367 | 0.2146290109928639 | 7 | 8 | 7 | 10 | 10 | 7
Oct 1- Sept 30 | VALENT | 32007981.63 | 37731661.45 | -371818.95 | -484547.66 | 5773177.7 | 7175148.98 | 5401358.75 | 6690601.32 | -0.01161644474487909 | -0.0128419380800948 | 0.1687503702182049 | 0.1773206125276522 | 10 | 9 | 12 | 12 | 16 | 14
Nov 1 - Oct 31 | CHEMINOVA | 20327071.24 | 35396685.16 | -610352.34 | -23492423.81 | 3835105.44 | 40567454.25 | 3224753.1 | 17075030.44 | -0.03002657553533521 | -0.6636899388688408 | 0.1586432724087802 | 0.4823906634990677 | 15 | 10 | 15 | 6 | 19 | 2
Aug 1 - July 31 | NUFARM | 30345926.96 | 35368916.13 | -3831567.79 | -7099159.42 | 11019808.2 | 12373882.78 | 7188240.41 | 5274723.36 | -0.1262630004695695 | -0.2007174716326259 | 0.2368766134405802 | 0.1491344360288713 | 11 | 11 | 10 | 13 | 9 | 18
Sept 1 - Aug 31 | ARYSTA | 33200841.07 | 33020626.45 | -7707133.43 | -6160289.31 | 13321226.92 | 18660536.48 | 5614093.49 | 12500247.17 | -0.2321366923732574 | -0.1865588261727239 | 0.1690949177511303 | 0.3785587529336531 | 9 | 12 | 11 | 8 | 15 | 3
Nov 1 - Oct 31 | UPI | 26299873.28 | 29586370.19 | -1885434.99 | -1767462.36 | 9472703.15 | 8756206.02 | 7587268.16 | 6988743.66 | -0.0716898887658823 | -0.05973907406179183 | 0.2884906736706527 | 0.2362149738247428 | 12 | 13 | 9 | 11 | 3 | 4
Calendar | MEY CORP | 13913511.52 | 22844929.43 | -955295.78 | -12359690.26 | 4852866.43 | 14605926.49 | 3897570.65 | 2246236.23 | -0.06865957444508589 | -0.5410255390751715 | 0.2801284668070624 | 0.09832537399087951 | 17 | 14 | 13 | 18 | 4 | 23
Sept 1 - Aug 31 | GOWAN | 21725170.74 | 22451378.97 | 546902.42 | 961003.25 | 1945403.79 | 1545297.76 | 2492306.21 | 2506301.01 | 0.0251736764946594 | 0.04280375166639486 | 0.1147197524855908 | 0.1116323862934643 | 13 | 15 | 18 | 16 | 23 | 22
Nov 1 - Oct 31 | AMVAC | 20764018.57 | 19808410.22 | 41000.82 | -619538.95 | 2666994.41 | 2478237.15 | 2707995.23 | 1858698.2 | 0.001974609098993885 | -0.03127656097178706 | 0.1304176848460601 | 0.09383378975680362 | 14 | 16 | 16 | 20 | 21 | 24
Calendar | DREXEL | 14149840.62 | 13966812.5 | 358235.3 | -168106.21 | 1376929.4 | 2200218.99 | 1735164.7 | 2032112.78 | 0.025317267495837 | -0.0120361184772832 | 0.1226278617970751 | 0.1454958158849773 | 16 | 17 | 20 | 19 | 22 | 19
Calendar | MANA | 13089350.32 | 11929120.91 | -286264.47 | -481580.58 | 3523685.35 | 2939702.01 | 3237420.88 | 2458121.43 | -0.02187002891675986 | -0.04037016504680561 | 0.2473324344488932 | 0.2060605679618348 | 18 | 18 | 14 | 17 | 7 | 8
Oct 1- Sept 30 | CHEMTURA | 8188823.72 | 8665430.2 | 214730.1 | -4757.07 | 1147099.18 | 1324145.67 | 1361829.28 | 1319388.6 | 0.02622233758379158 | -0.0005489710135799144 | 0.1663034065166077 | 0.152258868809537 | 19 | 19 | 21 | 22 | 17 | 16
Calendar | RICECO | 5293622.73 | 7305072.62 | 99372.97 | 366477.01 | 926844.6 | 1008376.57 | 1026217.57 | 1374853.58 | 0.01877220479593943 | 0.05016746979306552 | 0.1938592193554375 | 0.1882053268349302 | 21 | 20 | 22 | 21 | 13 | 12
Calendar | HELENA | 7146093.77 | 6451750.33 | 1173143.27 | 844808.07 | 1500148.94 | 2971892.19 | 2673292.21 | 3816700.26 | 0.164165669771221 | 0.1309424616249835 | 0.3740913981877403 | 0.5915759390521859 | 20 | 21 | 17 | 14 | 1 | 1
Calendar | AMTIDE | 525851.94 | 4081661.73 | -158609.68 | -1315890.79 | 264975.81 | 1927732.48 | 106366.13 | 611841.69 | -0.3016242176457503 | -0.322390946885253 | 0.2022739138320951 | 0.1499001461838436 | 48 | 22 | 44 | 26 | 12 | 17
Calendar | SIPCAM | 2209972.37 | 3298701.1 | 129496.36 | -71996.94 | 70849.43 | 550521.51 | 200345.79 | 478524.57 | 0.0585963705962532 | -0.02182584533045446 | 0.09065533701672478 | 0.1450645437381398 | 26 | 23 | 34 | 28 | 24 | 20
Calendar | HELM AGRO | 1526417.36 | 3294782.34 | -19947.3 | -992962.97 | 429985.83 | 1639437.39 | 410038.53 | 646474.42 | -0.01306805106042557 | -0.3013743754617794 | 0.2686280572699986 | 0.1962115712930524 | 32 | 24 | 29 | 24 | 5 | 10
Calendar | ALLIGARE | 3513451.66 | 3183969.42 | 242616.65 | 202614.82 | 0 | 0 | 242616.65 | 202614.82 | 0.06905364680611543 | 0.0636359189655785 | 0.06905364680611543 | 0.0636359189655785 | 22 | 25 | 33 | 38 | 25 | 25
Top 25 Total |  |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | - | -
* Excludes Miscellaneous Vendor