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

Created
Helena Chemical Company- All Business Units
Top 25 Suppliers-Wholesale Only
[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 | 192577309.15 | 199119226.21 | -1685860.43 | -1311976.13 | 22191673.88 | 23686863.06 | 20505813.45 | 22374886.93 | -0.008754200780149388 | -0.006588897290191011 | 0.1064809428509974 | 0.1123692942960839 | 1 | 1 | 2 | 1 | 22 | 19
Sept 1 - Aug 31 | MONSANTO | 146416230.14 | 118674087.24 | -6473352.52 | -3038906.9 | 32789836.57 | 12431166.92 | 26316484.05 | 9392260.02 | -0.04421198738562195 | -0.02560716472041854 | 0.1797374787264824 | 0.07914330953315533 | 2 | 2 | 1 | 2 | 8 | 22
Sept 1 - Aug 31 | DOW | 67769980.5 | 65255962.54 | -33786.88 | 896190.22 | 7708881.35 | 7910755.1 | 7675094.47 | 8806945.32 | -0.0004985523051758882 | 0.01373346105270705 | 0.1132521274666738 | 0.1349600094336453 | 4 | 3 | 4 | 3 | 18 | 16
Oct 1- Sept 30 | BASF | 67997690.9 | 50226328.65 | 972057.78 | 1968275.08 | 8455006.44 | 5342119.32 | 9427064.22 | 7310394.4 | 0.01429545278867697 | 0.03918811374241267 | 0.1386380051326125 | 0.1455490496018964 | 3 | 4 | 3 | 5 | 15 | 13
Nov 1 - Oct 31 | BAYER | 38614955.94 | 41752631.31 | 632487.41 | 605541.34 | 3700633.6 | 4559053.61 | 4333121.01 | 5164594.95 | 0.01637933786543122 | 0.01450307012997692 | 0.112213542771687 | 0.1236950771235117 | 6 | 5 | 7 | 6 | 20 | 18
Oct 1- Sept 30 | DUPONT | 40758779.86 | 33343566.57 | 613733.34 | 669292.46 | 4256766.59 | 4193797.59 | 4870499.93 | 4863090.05 | 0.01505769657747552 | 0.02007261156645967 | 0.1194957245219165 | 0.1458479266094899 | 5 | 6 | 6 | 7 | 16 | 12
Nov 1 - Oct 31 | FMC | 20601164.23 | 22022810.34 | 325437.89 | 425756.6 | 2984499.29 | 2984611.93 | 3309937.18 | 3410368.53 | 0.01579706303812132 | 0.01933252811185042 | 0.1606674818493984 | 0.1548561912557432 | 8 | 7 | 8 | 8 | 10 | 10
Oct 1- Sept 30 | ALBAUGH | 33147309.89 | 15742766.92 | -4248719.22 | -11126867.65 | 9605856.25 | 12815280.84 | 5357137.03 | 1688413.19 | -0.1281768938142932 | -0.7067923768765294 | 0.1616160420793653 | 0.1072500913327376 | 7 | 8 | 5 | 12 | 9 | 20
Oct 1- Sept 30 | VALENT | 10430500.89 | 13027123.99 | 97128.11 | 482404.23 | 1139626.7 | 1339115.51 | 1236754.81 | 1821519.74 | 0.009311931519330898 | 0.03703075447583883 | 0.1185709893554307 | 0.1398251633590232 | 11 | 9 | 13 | 11 | 17 | 14
Aug 1 - July 31 | NUFARM | 13512275.03 | 12416398.24 | -2054874.19 | -2669520.62 | 5206394.46 | 5071722.64 | 3151520.27 | 2402202.02 | -0.1520746273619921 | -0.2149995971778689 | 0.2332338753468964 | 0.1934701169829746 | 9 | 10 | 9 | 9 | 5 | 7
Sept 1 - Aug 31 | ARYSTA | 11535143.57 | 11201660.16 | -2798893.45 | -2749360.67 | 5039645.58 | 4791920.96 | 2240752.13 | 2042560.29 | -0.2426405387167626 | -0.2454422496959593 | 0.1942543771910764 | 0.1823444258105399 | 10 | 11 | 10 | 10 | 6 | 8
Sept 1 - Aug 31 | GOWAN | 9374536.67 | 9292604.11 | -313993.9 | 36643.66 | 977347.34 | 592439.79 | 663353.44 | 629083.45 | -0.03349433801937435 | 0.003943314442995248 | 0.07076119741713058 | 0.06769721840652049 | 12 | 12 | 16 | 16 | 25 | 24
Nov 1 - Oct 31 | CHEMINOVA | 4892061.14 | 8451768.6 | -194773.87 | -9723769.51 | 901564.61 | 17881041.74 | 706790.74 | 8157272.23 | -0.03981427550187977 | -1.150501151912749 | 0.1444770864004369 | 0.9651556515638633 | 15 | 13 | 15 | 4 | 12 | 1
Nov 1 - Oct 31 | AMVAC | 5709110.35 | 6242856.9 | 175605.84 | 235329.03 | 454864.37 | 544680.55 | 630470.21 | 780009.58 | 0.03075887997155284 | 0.03769572709571478 | 0.1104323040454105 | 0.1249443311763241 | 14 | 14 | 17 | 13 | 21 | 17
Calendar | MEY CORP | 8336469 | 4007983.01 | -537727.39 | -3425898.96 | 2619016.42 | 2765320.92 | 2081289.03 | -660578.04 | -0.06450301560528804 | -0.8547688329646886 | 0.2496607412562801 | -0.1648155788963786 | 13 | 15 | 11 | 196 | 3 | 25
Nov 1 - Oct 31 | UPI | 4878575.57 | 3837137.63 | -276719.82 | -333792.84 | 1936510.76 | 982194.03 | 1659790.94 | 648401.19 | -0.05672143764701384 | -0.086990061912374 | 0.3402204016694159 | 0.1689804360757318 | 16 | 16 | 12 | 15 | 2 | 9
Calendar | DREXEL | 4619045.32 | 3383900.87 | 29466.1 | -639.18 | 360401.89 | 461149.57 | 389867.99 | 460510.39 | 0.006379261938049137 | -0.000188888511973461 | 0.08440445221697888 | 0.1360886171585753 | 17 | 17 | 18 | 17 | 24 | 15
Calendar | MANA | 4525492.84 | 3025287.29 | -284651.84 | -279717.75 | 1140008.69 | 1038391.45 | 855356.85 | 758673.7 | -0.06289963326955568 | -0.09245989659382069 | 0.1890085522707401 | 0.250777406333532 | 18 | 18 | 14 | 14 | 7 | 3
Oct 1- Sept 30 | CHEMTURA | 2471531.97 | 2391806.63 | 1124.82 | -58799.71 | 278668.02 | 310084.49 | 279792.84 | 251284.78 | 0.0004551104390529085 | -0.02458380592414363 | 0.1132062394483208 | 0.1050606586871113 | 19 | 19 | 20 | 19 | 19 | 21
Calendar | HELENA | 2293418.11 | 2002592.82 | 315576.01 | 152605.37 | 9388.49 | 3823.32 | 324964.5 | 156428.69 | 0.1376007316869055 | 0.07620389351041416 | 0.1416943986720328 | 0.07811307842400034 | 20 | 20 | 19 | 22 | 13 | 23
Calendar | RICECO | 1727415.5 | 1439627.5 | -59100.89 | 86708.17 | 299378.47 | 214248.68 | 240277.58 | 300956.85 | -0.03421347672288456 | 0.06022958716751382 | 0.1390965752015077 | 0.2090518901590863 | 21 | 21 | 22 | 18 | 14 | 6
Calendar | AMTIDE | 189476.24 | 879001.91 | -73359.76 | -285392.64 | 101739.99 | 416329.02 | 28380.23 | 130936.38 | -0.3871712886006182 | -0.3246780658303689 | 0.1497825268223604 | 0.1489602906551136 | 37 | 22 | 37 | 24 | 11 | 11
Calendar | GHARDA CHEMICALS | 596253.29 | 798032.89 | 82446.48 | -54609.35 | 124174.96 | 272099.18 | 206621.44 | 217489.83 | 0.1382742558955104 | -0.06842994904633568 | 0.3465329977466455 | 0.2725324140462431 | 27 | 23 | 23 | 20 | 1 | 2
Calendar | SIPCAM | 653207.16 | 793700.71 | 29572.99 | 12133.76 | 39891.95 | 156379.97 | 69464.94 | 168513.73 | 0.0452735239460633 | 0.0152875760940166 | 0.1063444252509418 | 0.2123139463992668 | 25 | 24 | 28 | 21 | 23 | 4
Calendar | EMD CROP BIOSCIENCE | 822360.57 | 634570.11 | 145298.57 | 119143.82 | 55229.02 | 15164.15 | 200527.59 | 134307.97 | 0.1766847479080861 | 0.1877551717650237 | 0.2438438773882362 | 0.211651900843549 | 22 | 25 | 24 | 23 | 4 | 5
Top 25 Total |  |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | - | -
* Excludes Miscellaneous Vendor