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

Created
Helena Chemical Company- All Business Units
Top Groups by Manufacturer-Retail and Wholesale
All AgChem (AgChem, T&O, VM)
2008 - 2009 - With Inventory Coverage Effect (in 000's)
 |  | Sales Volume $ |  | GP $ [NAME] |  | Rebate Volume $ |  | GP A/Rebate |  | GP% B4 Rebate |  | GP% A/Rebate
Group | Supplier | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009
Glyphosate |  | 422947670.9899998 | 381541362.36 | -44764551.91 | -84429762.36 | 151550542.9299999 | 149146849.23 | 106785991.0200001 | 64717086.87000003 | -0.1058394571726071 | -0.2212860011762948 | 0.2524803855050068 | 0.1696201074234698
 | MONSANTO | 226253981.78 | 163807086.04 | -29888637.47000001 | -16531068.9 | 100328256.9299999 | 36061920.32999997 | 70439619.46000008 | 19530851.43 | -0.1321021501361354 | -0.1009179108159172 | 0.311329855527107 | 0.1192308092534579
 | SYNGENTA | 66412092.84999999 | 83671936.43999998 | -6944901.209999997 | -8493440.280000001 | 19217183.47 | 22146655.87 | 12272282.25999999 | 13653215.59 | -0.1045728407578711 | -0.1015088289021557 | 0.1847898738520178 | 0.1631755660368939
 | CHEMINOVA | 15204368.09 | 30511302.71999999 | -621310.34 | -23204801.22999999 | 2644223.17 | 39192128.99000001 | 2022912.83 | 15987327.76000001 | -0.04086393701614205 | -0.7605313166385838 | 0.1330481357742504 | 0.5239805034453806
 | DOW | 27857758.7 | 27430082.16 | -380545.58 | -822832.06 | 3815751.69 | 4560440.02 | 3435206.11 | 3737607.96 | -0.01366030857320909 | -0.02999743329970397 | 0.1233123650396182 | 0.136259451874715
 | ALBAUGH | 52618565.65000003 | 24954601.38 | -3705801.25 | -16698023.59 | 13834947.28 | 22565340.73000001 | 10129146.03 | 5867317.140000005 | -0.0704276371699235 | -0.6691360577445539 | 0.1925013710441192 | 0.2351196499056242
 | NUFARM | 17925148.75 | 24117019.3 | -2347421.77 | -5185041.74 | 6409765.200000001 | 8242724.269999999 | 4062343.43 | 3057682.53 | -0.130956892059264 | -0.2149951316745017 | 0.2266281572698246 | 0.1267852586575655
 | MEY CORP | 13913511.52 | 22950293.53 | -955295.78 | -12366606.16 | 4852866.43 | 14664236.19 | 3897570.65 | 2297630.03 | -0.06865957444508589 | -0.5388430498213326 | 0.2801284668070624 | 0.100113317809927
 | HELM AGRO | 827580.65 | 2407021.01 | -56924.78 | -1118934.56 | 390685.83 | 1608141.4 | 333761.05 | 489206.84 | -0.06878457102640087 | -0.4648628139726955 | 0.4032973100567299 | 0.2032416160754658
 | RESOURCE SEEDS | 973049.25 | 752939.68 | 76555.4 | 55336.59 | 0 | 398.9 | 76555.4 | 55735.49 | 0.07867577103625535 | 0.07349405466318364 | 0.07867577103625535 | 0.07402384477864149
 | BASF | 419545.71 | 333497.8 | 15984.33 | 10470.9 | 21347.67 | 68959.86 | 37332 | 79430.76 | 0.03809913823216068 | 0.03139720861726823 | 0.08898196098823179 | 0.2381747645711606
 | HELENA | 72198 | 247807.68 | 5074.75 | -116816.22 | 0 | 381.29 | 5074.75 | -116434.93 | 0.07028934319510236 | -0.471398707255562 | 0.07028934319510236 | -0.4698600543776528
 | SEPRO | 139834.7 | 164446.2 | 23207.4 | 13876 | 7320 | 0 | 30527.4 | 13876 | 0.1659630978576848 | 0.08438018026564312 | 0.218310619610154 | 0.08438018026564312
 | MANA | 237226.28 | 119788.91 | -2115.18 | 11781.54 | 25594.92 | 35408.21 | 23479.74 | 47189.75 | -0.008916297132004094 | 0.09835251026159265 | 0.09897613367287975 | 0.3939408915232637
 | CPS | 0 | 54907.21 | 0 | 10853.39 | 0 | 0 | 0 | 10853.39 |  | 0.1976678472645031 |  | 0.1976678472645031
 | APPLIED BIO | 11619.82 | 12992.74 | 2680.34 | 3886.53 | 0 | 13.18 | 2680.34 | 3899.71 | 0.2306696661394066 | 0.2991308992560461 | 0.2306696661394066 | 0.3001453119203493
 | PBI GORDON CORP | 7092.46 | 4680.65 | 1759.7 | 1107.29 | 192.49 | 99.99 | 1952.19 | 1207.28 | 0.2481085547186731 | 0.2365675707433797 | 0.2752486443349699 | 0.257929988356318
 | FARMSAVER | 18285.52 | 675 | 9765.52 | 435 | 1271.18 | 0 | 11036.7 | 435 | 0.5340575493614621 | 0.6444444444444445 | 0.6035759442444077 | 0.6444444444444445
 | CONTROL SOLUTIONS | 937.14 | 279.91 | 237.47 | 54.14 | 0 | 0 | 237.47 | 54.14 | 0.253398638410483 | 0.1934193133507199 | 0.253398638410483 | 0.1934193133507199
 | ADVANCE AGRI SOLUTIONS COOP | 54874.12 | 0 | 3136.54 | 0 | 1136.67 | 0 | 4273.21 | 0 | 0.05715882095239067 |  | 0.07787295723375609
Metolachlor |  | 72786696.75999999 | 73106600.20000002 | -3405320.34 | -4176281.09 | 11870957.36 | 14821549.45 | 8465637.020000005 | 10645268.36 | -0.04678492762528275 | -0.05712591036342571 | 0.116307476459796 | 0.1456129587599124
 | SYNGENTA | 66309898.63999998 | 69012367.80000003 | -3428533.06 | -4132265.93 | 11421917.3 | 14139680.08 | 7993384.240000004 | 10007414.15 | -0.05170469462807794 | -0.0598771794350751 | 0.1205458672678195 | 0.1450089957643794
 | DUPONT | 6188054.960000001 | 3763753.41 | 11438.76 | -71261.69 | 409111.21 | 642429.09 | 420549.97 | 571167.4 | 0.001848522689914828 | -0.01893367663531389 | 0.06796157641107958 | 0.151754734644
 | MANA | 109664.1 | 211477.78 | 5246.95 | 10743.26 | 17847 | 37010.28 | 23093.95 | 47753.54 | 0.04784564866715725 | 0.05080089265170081 | 0.2105880593557965 | 0.2258087823694764
 | DREXEL | 72065.63 | 60069.25 | 8961.01 | 8666.59 | 2656.25 | 2430 | 11617.26 | 11096.59 | 0.1243451281838513 | 0.1442766473694944 | 0.1612038915083376 | 0.1847299575073769
 | SIPCAM | 21921.45 | 20897 | -619.68 | 6711 | 0 | 0 | -619.68 | 6711 | -0.02826820306138508 | 0.3211465760635498 | -0.02826820306138508 | 0.3211465760635498
 | CENTRA SOTA COOP | 0 | 18801.86 | 0 | 2700.34 | 0 | 0 | 0 | 2700.34 |  | 0.143620897081459 |  | 0.143620897081459
 | S AND D APPLICATION | 6049.6 | 13579.8 | 260.8 | -1359.8 | 0 | 0 | 260.8 | -1359.8 | 0.04311028828352288 | -0.1001340225923799 | 0.04311028828352288 | -0.1001340225923799
 | MONSANTO | 79042.38 | 5015 | -2075.12 | -310 | 19425.6 | 0 | 17350.48 | -310 | -0.02625325806232049 | -0.06181455633100698 | 0.2195085724898466 | -0.06181455633100698
 | [NAME] | 0 | 638.3 | 0 | 95.14 | 0 | 0 | 0 | 95.14 |  | 0.1490521698261006 |  | 0.1490521698261006
[NAME] |  | 51316764.32999998 | 41014793.69000002 | -1243002.04 | -1636670.51 | 12462761.55 | 13574692.11 | 11219759.51 | 11938021.6 | -0.02422214370350191 | -0.03990439455505643 | 0.2186373138775798 | 0.2910662355205424
 | SYNGENTA | 50788045.16999999 | 40920893.70000002 | -1289838.8 | -1650414.82 | 12462444.38 | 13574305.79 | 11172605.58 | 11923890.97 | -0.02539650415137254 | -0.04033183713189526 | 0.2199849500527647 | 0.2913888210119907
 | KEDON | 280054.1 | 93642.99 | 21687.42 | 18609.3 | 0 | 0 | 21687.42 | 18609.3 | 0.077440108893246 | 0.1987260338440709 | 0.077440108893246 | 0.1987260338440709
 | BAYER | 2758.65 | 257 | -3.98 | -4864.99 | 317.17 | 386.32 | 313.19 | -4478.67 | -0.001442734670944121 | -18.92992217898833 | 0.1135301687419571 | -17.42673151750973
 | TOP HAT AERIAL APPLICATORS INC | 245906.41 | 0 | 25153.32 | 0 | 0 | 0 | 25153.32 | 0 | 0.1022881835410472 |  | 0.1022881835410472
Acetochlor_Atrazine |  | 27596765.13000001 | 24593176.66 | -556604.22 | -157393.06 | 5265836.14 | 4765937.16 | 4709231.92 | 4608544.1 | -0.02016918350313909 | -0.006399867010917492 | 0.1706443453722288 | 0.1873911680346544
 | MONSANTO | 23841869.61000001 | 21079575.43 | -398510.51 | -75793.57 | 4593068.83 | 3897941.63 | 4194558.32 | 3822148.06 | -0.01671473405897885 | -0.003595592816928004 | 0.1759324410632912 | 0.181319973577855
 | DOW | 3229188.05 | 3053187.27 | -10802.64 | 77771.07 | 521504.21 | 622068.05 | 510701.57 | 699839.12 | -0.003345311524982263 | 0.02547209297122478 | 0.1581516969877304 | 0.2292159170439617
 | BAYER | 247814.73 | 273614.35 | -151980.31 | -160509.49 | 138317.94 | 236151.38 | -13662.37 | 75641.89 | -0.6132819869101406 | -0.5866267248044557 | -0.0551313878718993 | 0.2764543964890731
 | DUPONT | 277892.74 | 181491.71 | 4689.24 | 1973.53 | 12945.16 | 9776.1 | 17634.4 | 11749.63 | 0.01687428034284019 | 0.0108739401926402 | 0.0634575771932725 | 0.06473921040250268
 | HELENA | 0 | 5307.9 | 0 | -834.6 | 0 | 0 | 0 | -834.6 |  | -0.1572373254959589 |  | -0.1572373254959589
Pyraclostrobin |  | 52566792.38 | 22809209.1 | -159880.21 | 820439.26 | 12048471.12 | 3869188.03 | 11888590.90999999 | 4689627.29 | -0.003041467868996872 | 0.03596964964471305 | 0.226161619755274 | 0.2056023630385324
 | BASF | 51819484.30999999 | 22410273.97 | -239880.71 | 749937.5 | 12048471.12 | 3869188.03 | 11808590.40999999 | 4619125.53 | -0.004629160501964083 | 0.03346400409936622 | 0.2278793501563504 | 0.206116423930537
 | SNYDER TRADING CORPORATION | 747308.07 | 234597.53 | 80000.5 | 55852.16 | 0 | 0 | 80000.5 | 55852.16 | 0.1070515671000315 | 0.238076504897558 | 0.1070515671000315 | 0.238076504897558
 | [NAME] | 0 | 164337.6 | 0 | 14649.6 | 0 | 0 | 0 | 14649.6 |  | 0.0891433244735228 |  | 0.0891433244735228
[NAME] |  | 16417818.25 | 20272788.72 | -330263.01 | -495455.5 | 2350749.23 | 3170096.77 | 2020486.22 | 2674641.27 | -0.02011613266580047 | -0.02443943489191553 | 0.1230666699578064 | 0.1319325775521623
 | VALENT | 16410495.76 | 20272636.24 | -331925.14 | -495503.18 | 2350749.23 | 3170096.77 | 2018824.09 | 2674593.59 | -0.02022639320922015 | -0.02444197065117366 | 0.1230202986871861 | 0.1319312179401094
 | HELENA | 7322.49 | 152.48 | 1662.13 | 47.68 | 0 | 0 | 1662.13 | 47.68 | 0.2269897261723813 | 0.3126967471143757 | 0.2269897261723813 | 0.3126967471143757