Spreadsheet: 101354d1299511196-excel-2007-pivot-table-formatting-total-supplier-analysis-09
Sheet: Seed Class Supplier

Created
Helena Chemical Company- All Business Units
Top Seed Classes By [NAME] and Wholesale
Seed Only (Tech Excluded)
2008 - 2009 - With Inventory Coverage Effect (in 000's)
 |  | Sales Volume $ |  | GP $ [NAME] |  | Rebate Volume $ |  | GP A/Rebate |  | GP% B4 Rebate |  | GP% A/Rebate
Class | Supplier | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009
Soybean |  | 96439690.03999992 | 123995793.6600001 | 10484810.33 | 4569083.54 | 16342205.04999999 | 24030774.35000001 | 26827015.37999998 | 28599857.88999999 | 0.1087188306562496 | 0.0368486978883216 | 0.2781740108131102 | 0.2306518394359538
 | MONSANTO | 35232714.14999993 | 57720501.78000008 | 3458325.39 | 1634393.32 | 8430924.239999996 | 12933642.00000001 | 11889249.62999999 | 14568035.31999999 | 0.09815665563761307 | 0.02831564642714716 | 0.3374491553328149 | 0.25238927020291
 | SYNGENTA | 21684562.33999998 | 23750959.83000001 | 2050647.08 | -366217.22 | 4937619.7 | 6050699.709999994 | 6988266.779999999 | 5684482.490000008 | 0.09456714172263068 | -0.01541904927721819 | 0.3222692102532886 | 0.2393369586192427
 | PIONEER | 8249137.38 | 17428692.20999999 | 1693137.7 | 1522298.87 | 1286142.29 | 2896641.7 | 2979279.99 | 4418940.57 | 0.2052502730897663 | 0.08734441182721425 | 0.3611626104352744 | 0.2535440133290414
 | HORNBECK | 9554254.679999998 | 6378228.15 | 1038096.03 | 396384.6 | 601230.69 | 770936 | 1639326.72 | 1167320.6 | 0.108652748410931 | 0.06214650694174368 | 0.1715808061335874 | 0.1830164385072992
 | ERWIN KEITH | 6274646.56 | 5334717.47 | 939382.66 | 347106.16 | 567377.64 | 555999.38 | 1506760.3 | 903105.54 | 0.1497108484147034 | 0.06506551883055954 | 0.2401346889568869 | 0.1692883540841011
 | CULLUM SEED | 1722586.29 | 2898708.79 | 101027.17 | 150037.31 | 266208.36 | 377756.12 | 367235.53 | 527793.43 | 0.0586485394586532 | 0.05176004934252122 | 0.2131884667443858 | 0.1820788041285099
 | TERRAL SEED | 880197.06 | 2320791.83 | 126385.32 | 285687.69 | 59324.76 | 114547.53 | 185710.08 | 400235.22 | 0.1435875280019681 | 0.1230992311792135 | 0.2109869351301855 | 0.1724563206515596
 | HELENA | 656224.28 | 2285084.93 | 15062.76 | 19432.88 | 0 | 0 | 15062.76 | 19432.88 | 0.02295367675210067 | 0.008504226580322332 | 0.02295367675210067 | 0.008504226580322332
 | SCHILLINGER SEED | 4541544.2 | 783945.66 | 376348.75 | 134635.16 | 10873 | 1816 | 387221.75 | 136451.16 | 0.08286801436392495 | 0.1717404239472414 | 0.08526213396756108 | 0.1740569110364103
 | DELTA GROW SEED | 619473.49 | 765491.8 | 122120.1 | 143050.3 | 5105 | 2150 | 127225.1 | 145200.3 | 0.1971353124408923 | 0.1868737196139789 | 0.2053761816345039 | 0.1896823715159326
 | U S SEEDS | 0 | 654594.58 | 0 | 70205.98 | 0 | 0 | 0 | 70205.98 |  | 0.1072510866191407 |  | 0.1072510866191407
 | CACHE RIVER VALLEY | 1407966.01 | 597830.39 | 76354.11 | 8131.61 | 66433.34 | 111660.27 | 142787.45 | 119791.88 | 0.05423008045485416 | 0.01360186791440964 | 0.1014139893902694 | 0.2003777024450028
Corn |  | 88070175.88999997 | 111364100.34 | -73866.92000000084 | -2378625.54 | 19741737.37000003 | 25048855.52999999 | 19667870.45000001 | 22670229.99000001 | -0.0008387279717967264 | -0.02135899749324909 | 0.2233204402199139 | 0.203568564023654
 | MONSANTO | 50182737.26999996 | 65412490.40000001 | -1302125.02 | -3591325.14 | 12492986.27000003 | 16512756.57999999 | 11190861.25000001 | 12921431.44000001 | -0.02594766827871766 | -0.05490274285597294 | 0.2230022087035513 | 0.1975376776053768
 | PIONEER | 17293024.26000001 | 22299178.64999999 | 1036524.38 | 729118.7999999995 | 3245512.49 | 3080191.4 | 4282036.87 | 3809310.2 | 0.05993887271629837 | 0.03269711460874815 | 0.247616426463048 | 0.1708273770881693
 | SYNGENTA | 11763704.29 | 13869291.15000001 | -718764.2900000007 | 35283.44000000021 | 3212818.02 | 4054467.02 | 2494053.73 | 4089750.46 | -0.06110016643405449 | 0.002543997354904486 | 0.2120126168183372 | 0.2948781171127121
 | MYCOGEN SEEDS | 1095739.98 | 2945365.96 | 34980.78 | 32087.56 | 216204.32 | 611533.73 | 251185.1 | 643621.29 | 0.03192434394882626 | 0.01089425233935956 | 0.2292378708313627 | 0.2185199729815575
 | TERRAL SEED | 2096592.57 | 2008733.7 | 350618.49 | 242935.94 | 124816.24 | 70882.27 | 475434.73 | 313818.21 | 0.1672325348362749 | 0.1209398438429146 | 0.2267654368344919 | 0.1562268856245106
 | CHANNEL | 2204237.68 | 1697503.12 | 286016.25 | 60831.43 | 91265.46 | 316291.61 | 377281.71 | 377123.04 | 0.12975744521344 | 0.03583582809556191 | 0.1711619910244889 | 0.2221633854787849
 | DAHLMAN FARMS | 745019.78 | 702817.85 | 194844.22 | 160336.92 | 0 | 46832 | 194844.22 | 207168.92 | 0.2615289220911692 | 0.228134387878737 | 0.2615289220911692 | 0.2947690073608689
 | [NAME] | 685564.36 | 629740.04 | 143487.35 | 102061.91 | 5696.49 | 15622.89 | 149183.84 | 117684.8 | 0.209298146712294 | 0.1620699074494295 | 0.2176073446991907 | 0.1868783823877548
 | GREAT LAKES HYBRID | 380160.95 | 526763.27 | -71119.05 | -104759.04 | 92794.01 | 175001.59 | 21674.96 | 70242.55 | -0.1870761581377572 | -0.198873091512246 | 0.05701521947480401 | 0.1333474712464292
 | AGRELIANT GENETICS | 730050.79 | 524512.59 | -124391.87 | -37580.24 | 181007.18 | 88276.26 | 56615.31 | 50696.02 | -0.1703879671166441 | -0.07164792745966304 | 0.0775498236225455 | 0.09665358080346555
Cotton |  | 51459074.64999998 | 52090597.14000002 | -316216.2500000005 | -1071555.61 | 7965274.420000002 | 9799445.019999996 | 7649058.169999998 | 8727889.409999993 | -0.00614500459152738 | -0.02057099877584549 | 0.1486435234606381 | 0.1675521090023731
 | MONSANTO | 24969369.34999997 | 23692610.47000002 | -709179.68 | -1300682.63 | 4264395.58 | 4435346.269999995 | 3555215.9 | 3134663.64 | -0.02840198605176229 | -0.05489824059898112 | 0.1423830874607171 | 0.1323055407494739
 | BAYER | 21636262.95000001 | 21363948.5 | 337926.28 | 246152.64 | 2926794.59 | 4017671.49 | 3264720.87 | 4263824.129999993 | 0.01561851419447643 | 0.01152187012620817 | 0.1508911625609542 | 0.1995803411527599
 | DOW | 2812054.69 | 4771877.33 | 4956.42 | -98139.96 | 590017.44 | 1166469.9 | 594973.86 | 1068329.94 | 0.001762561737375031 | -0.02056632080271854 | 0.2115797612741308 | 0.2238804282087446
 | AMERICOT | 1530356.73 | 1504421.1 | 34345.54 | 42417.27 | 139288.06 | 120188.97 | 173633.6 | 162606.24 | 0.02244283265902323 | 0.02819507782761091 | 0.1134595591970246 | 0.108085588536348
 | [NAME] DELINTING | 438595.43 | 604172.74 | 11911.18 | 26002.08 | 41862.84 | 57659.92 | 53774.02 | 83662 | 0.02715755611042277 | 0.04303749288655426 | 0.1226050622552087 | 0.1384736424884049
[NAME] |  | 13631181.81 | 24199981.01 | 743466.47 | 1387146.08 | 494494.55 | 1383875.3 | 1237961.02 | 2771021.38 | 0.05454160030750851 | 0.05732013093013581 | 0.09081831914910095 | 0.1145051055558659
 | RICETEC | 6989497.030000001 | 12258481.8 | 126565.81 | 83086.43 | 446409.85 | 1315721.28 | 572975.66 | 1398807.71 | 0.01810799968248931 | 0.006777872770508986 | 0.08197666549405484 | 0.1141093760892968
 | BASF | 2856087.92 | 8108785.539999999 | 227610.97 | 891368.81 | 31617.71 | 60720.27 | 259228.68 | 952089.08 | 0.07969326448465913 | 0.1099263022314437 | 0.09076355044420341 | 0.1174145098921928
 | ERWIN KEITH | 1291582.21 | 1454815.39 | 127577.51 | 175303.69 | 2071.22 | 0 | 129648.73 | 175303.69 | 0.09877614371910556 | 0.1204989246092592 | 0.1003797737350378 | 0.1204989246092592
 | [NAME] | 0 | 801230.54 | 0 | 96416.6 | 0 | -986.32 | 0 | 95430.28 |  | 0.1203356527073968 |  | 0.1191046462108147
Wheat |  | 11151161.67 | 6539754.52 | 1758102.47 | 873027.73 | 149589.2 | 32918.8 | 1907691.67 | 905946.53 | 0.1576609255634618 | 0.1334954893689191 | 0.1710755996957938 | 0.1385291339651079
 | SYNGENTA | 3903595.09 | 1539609.93 | 583491.91 | 287462.09 | 61584.15 | 208 | 645076.06 | 287670.09 | 0.1494755210382233 | 0.1867109872433727 | 0.1652517858864301 | 0.1868460863980008
 | PIONEER | 772953.13 | 766622.68 | 106377.92 | 72022.57 | 24375.64 | 10695.65 | 130753.56 | 82718.22 | 0.1376253175920253 | 0.09394787276577835 | 0.1691610460261672 | 0.1078995210525209
 | [NAME] | 278080.43 | 692172.28 | 55766.5 | 100774.15 | 0 | 94.15 | 55766.5 | 100868.3 | 0.2005409010623294 | 0.14559113809065 | 0.2005409010623294 | 0.1457271591402071
 | TERRAL SEED | 783825.31 | 504052.16 | 141801.21 | 68192.74 | 736.6 | 954.22 | 142537.81 | 69146.96 | 0.18090920029107 | 0.1352890542121672 | 0.1818489505014835 | 0.1371821519423704
[NAME] |  | 7310610.079999998 | 5394525.61 | 1041559.65 | 648918.54 | 56826.11 | 97824.85 | 1098385.76 | 746743.39 | 0.1424723297511717 | 0.1202920491835425 | 0.1502454306795692 | 0.1384261460573545
 | ABI | 3018868.96 | 2012933.6 | 481283.87 | 332734.97 | 59791.85 | 15905 | 541075.72 | 348639.97 | 0.1594252272546471 | 0.16529853245035 | 0.1792312707736741 | 0.1731999356560991
 | SEED SERVICES | 1316597.09 | 1635768.54 | 277540.53 | 138148.85 | -59757.52 | 0 | 217783.01 | 138148.85 | 0.2108014153365628 | 0.08445501097606391 | 0.1654135586764816 | 0.08445501097606391