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

Created
Helena Chemical Company- All Business Units
Seed Class-Retail 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 |  | Volume Rank |  | GP Rank |  | GP% Rank
Class | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009
Soybean | 96439690.04 | 123995793.66 | 10484810.33 | 4569083.54 | 16342205.05 | 24030774.35 | 26827015.38 | 28599857.89 | 0.10871883065625 | 0.03684869788832158 | 0.2781740108131106 | 0.230651839435954 | 1 | 1 | 1 | 1 | 2 | 3
Corn | 88070175.89 | 111364100.34 | -73866.92 | -2378625.54 | 19741737.37 | 25048855.53 | 19667870.45 | 22670229.99 | -0.000838727971796719 | -0.02135899749324909 | 0.2233204402199133 | 0.2035685640236547 | 2 | 2 | 2 | 2 | 6 | 5
Cotton | 51459074.65 | 52090597.14 | -316216.25 | -1071555.61 | 7965274.42 | 9799445.02 | 7649058.17 | 8727889.41 | -0.006145004591527376 | -0.02057099877584548 | 0.1486435234606381 | 0.1675521090023734 | 3 | 3 | 3 | 3 | 18 | 13
[NAME] | 13631181.81 | 24199981.01 | 743466.47 | 1387146.08 | 494494.55 | 1383875.3 | 1237961.02 | 2771021.38 | 0.05454160030750847 | 0.0573201309301358 | 0.09081831914910098 | 0.1145051055558659 | 4 | 4 | 5 | 4 | 23 | 21
Wheat | 11151161.67 | 6539754.52 | 1758102.47 | 873027.73 | 149589.2 | 32918.8 | 1907691.67 | 905946.53 | 0.157660925563462 | 0.133495489368919 | 0.1710755996957938 | 0.1385291339651079 | 5 | 5 | 4 | 5 | 13 | 18
[NAME] | 7310610.08 | 5394525.61 | 1041559.65 | 648918.54 | 56826.11 | 97824.85 | 1098385.76 | 746743.39 | 0.1424723297511717 | 0.1202920491835426 | 0.1502454306795692 | 0.1384261460573546 | 6 | 6 | 7 | 6 | 17 | 19
Grain Sorghum | 5448290.22 | 4301802.72 | 479071.25 | 266476.94 | 665310.03 | 437799.37 | 1144381.28 | 704276.31 | 0.08793056732576188 | 0.06194541157387153 | 0.2100441117837515 | 0.1637165523015895 | 7 | 7 | 6 | 7 | 8 | 15
Other Grasses | 2835661.35 | 2249323.52 | 448207.68 | 372664.53 | 6510.5 | 5022.82 | 454718.18 | 377687.35 | 0.1580610745355753 | 0.1656784925273889 | 0.160357011601544 | 0.1679115283514218 | 8 | 8 | 8 | 8 | 14 | 12
Ryegrass | 2377970.09 | 1988896.81 | 229876.7 | 189964.21 | 166.84 | -117 | 230043.54 | 189847.21 | 0.09666929830896234 | 0.09551235088963715 | 0.09673945898957881 | 0.09545352430828223 | 9 | 9 | 11 | 12 | 21 | 23
Sorghum Sudan | 1201291.41 | 1813564.07 | 263173.51 | 300658.44 | 15659.78 | 12510.37 | 278833.29 | 313168.81 | 0.219075494762757 | 0.165783191767799 | 0.2321112826404045 | 0.1726814151098615 | 10 | 10 | 10 | 9 | 5 | 10
Oat | 1127874.35 | 1077115.86 | 274445.43 | 245022.99 | 20972.33 | 4103.1 | 295417.76 | 249126.09 | 0.2433297911243393 | 0.2274806259003558 | 0.2619243535416866 | 0.2312899654081781 | 12 | 11 | 9 | 10 | 3 | 2
Pepper | 643070.12 | 904778.08 | 61426.45 | 117314.19 | -2420 | 0 | 59006.45 | 117314.19 | 0.09552060978980022 | 0.1296607340443084 | 0.0917574120843929 | 0.1296607340443084 | 15 | 12 | 18 | 15 | 22 | 20
Fescue | 1197372.98 | 819657.64 | 131443.3 | 127632.12 | 3842.61 | 1888.59 | 135285.91 | 129520.71 | 0.1097764040073795 | 0.1557139392978756 | 0.1129856045356895 | 0.1580180598328834 | 11 | 13 | 13 | 14 | 20 | 16
Forage | 821661.58 | 709690.75 | 182308.33 | 146821.33 | 461.53 | 4104.84 | 182769.86 | 150926.17 | 0.2218776372627767 | 0.2068807152974729 | 0.2224393405372562 | 0.2126646993778628 | 13 | 14 | 12 | 13 | 7 | 4
Peanut | 680513.36 | 516488.09 | 30766.56 | 38490.97 | 540.66 | 2277 | 31307.22 | 40767.97 | 0.04521080967462564 | 0.07452440965289248 | 0.04600529811787971 | 0.07893303018855671 | 14 | 15 | 22 | 21 | 25 | 24
Sunflower | 231784.7 | 389643.1 | 19502.01 | 44796.84 | 16589.54 | 22781.13 | 36091.55 | 67577.97 | 0.084138469881748 | 0.1149689035940839 | 0.1557115288455191 | 0.1734355619283391 | 20 | 16 | 20 | 17 | 16 | 9
Canola | 255061.43 | 377500.29 | 20588.2 | 65374.47 | 10599.58 | 9022.24 | 31187.78 | 74396.71 | 0.08071859394813242 | 0.173177270936666 | 0.1222755631849159 | 0.1970772260863694 | 19 | 17 | 23 | 16 | 19 | 6
Triticale | 470797.2 | 317012.76 | 81465.73 | 34647.36 | 756 | 344 | 82221.73 | 34991.36 | 0.1730378387976819 | 0.109293266302593 | 0.1746436257479866 | 0.1103783961251276 | 17 | 18 | 16 | 22 | 11 | 22
Barley | 475162.31 | 253472.67 | 92523.2 | 44944.82 | 53.49 | 0 | 92576.69 | 44944.82 | 0.1947191476529357 | 0.1773162368944944 | 0.1948317197127861 | 0.1773162368944944 | 16 | 19 | 15 | 19 | 9 | 8
[NAME] | 255489.62 | 243361.34 | 62436.63 | 41697.33 | -87.7 | 0 | 62348.93 | 41697.33 | 0.2443803000685507 | 0.1713391699766282 | 0.2440370375908031 | 0.1713391699766282 | 18 | 20 | 17 | 20 | 4 | 11
Tobacco | 205385.89 | 240603.87 | 12613.6 | 13082.61 | 0 | 2646.46 | 12613.6 | 15729.07 | 0.06141415069944678 | 0.0543740630605817 | 0.06141415069944678 | 0.06537330426148175 | 22 | 21 | 29 | 28 | 24 | 25
Clover | 206662.45 | 192642.99 | 30905.6 | 34583.16 | 1445.94 | 11.22 | 32351.54 | 34594.38 | 0.1495462770329104 | 0.1795194312546748 | 0.1565429036576311 | 0.179577673706165 | 21 | 22 | 21 | 23 | 15 | 7
Millet | 164945.09 | 184558.4 | 28484.77 | 28956.25 | 107.03 | 0 | 28591.8 | 28956.25 | 0.1726924396476427 | 0.156894782356154 | 0.1733413222545757 | 0.156894782356154 | 23 | 23 | 24 | 24 | 12 | 17
Lettuce | 143024.7 | 182355.36 | 38644.34 | 56314.24 | 2493.3 | 10940 | 41137.64 | 67254.24 | 0.2701934700789443 | 0.3088159295125737 | 0.287626123319958 | 0.3688086821248359 | 26 | 24 | 19 | 18 | 1 | 1
Grass Pasture | 120985.58 | 175776.09 | 18933.36 | 28653.17 | 3062.8 | 271.48 | 21996.16 | 28924.65 | 0.1564926993778928 | 0.1630094855335558 | 0.1818081129999129 | 0.1645539504263634 | 28 | 25 | 28 | 25 | 10 | 14
Top 25 Total |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | - | -