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

Created
Helena Chemical Company- All Business Units
Top 25 Families-Retail and Wholesale
Vegetation Management Subcategory  Only (Includes Aquatics, Forestry, and Industrial)
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
Supplier | Families | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009 | 2008 | 2009
VALENT | Payload | 4430077.81 | 5198472.02 | 177642.59 | 205386.35 | 0 | 933.48 | 177642.59 | 206319.83 | 0.04009920313340953 | 0.03950898441115396 | 0.04009920313340953 | 0.03968855256048873 | 1 | 1 | 19 | 15 | 21 | 23
MONSANTO | Roundup | 1950303.05 | 3596709.27 | -332162.56 | -590623.5 | 928121.62 | 989968.88 | 595959.06 | 399345.38 | -0.1703133059244306 | -0.1642121883262475 | 0.3055725416621791 | 0.1110307645188125 | 9 | 2 | 4 | 4 | 5 | 14
SYNGENTA | Reward | 4247053.83 | 3361791.61 | 13064.76 | 16676.89 | 675536.42 | 415882.04 | 688601.18 | 432558.93 | 0.003076193644571724 | 0.004960714980188793 | 0.1621362025449063 | 0.1286691681641742 | 2 | 3 | 3 | 3 | 14 | 13
DOW | Garlon | 3842042.27 | 2808781.15 | -355592.13 | -219113.31 | 1257132.35 | 1052314.58 | 901540.22 | 833201.27 | -0.09255289375043757 | -0.07801010413360258 | 0.234651301741144 | 0.2966415770769467 | 3 | 4 | 1 | 1 | 8 | 4
SEPRO | Sonar | 3528877.41 | 2001685.04 | 16920.49 | 13045.58 | 289206.36 | 158537.98 | 306126.85 | 171583.56 | 0.004794864778258194 | 0.006517299045208431 | 0.08674907468661541 | 0.0857195595566823 | 4 | 5 | 9 | 19 | 17 | 21
BAY CHEMICAL | Copper Sulfate | 2480199.45 | 1984940.41 | 164800.48 | 171970.87 | 0 | 110.2 | 164800.48 | 172081.07 | 0.06644646260202985 | 0.08663779987228937 | 0.06644646260202985 | 0.08669331791174528 | 6 | 6 | 22 | 18 | 19 | 20
UPI | Aquathol | 1996077.91 | 1729242.46 | -3319.36 | 15870.1 | 78582.43 | 165341.13 | 75263.07 | 181211.23 | -0.001662941102334027 | 0.009177486886367572 | 0.03770547713741294 | 0.104792262618858 | 8 | 7 | 33 | 17 | 22 | 15
NUFARM | [NAME] | 1134173.23 | 1388956.25 | 238765.82 | 232545.93 | 36284.75 | 63480.5 | 275050.57 | 296026.43 | 0.2105197104678621 | 0.1674249494899497 | 0.2425119573665127 | 0.2131286928583964 | 16 | 8 | 10 | 10 | 7 | 8
DOW | Vista | 509664.35 | 1386274.69 | -50546.84 | -43490.16 | 137275.62 | 166382.74 | 86728.78 | 122892.58 | -0.0991767228765363 | -0.03137196423892007 | 0.1701684255530135 | 0.08864951577526096 | 31 | 9 | 30 | 25 | 13 | 19
DOW | Accord | 614508.23 | 1379352.93 | -96505.45 | -505060.33 | 314729.27 | 1080288.71 | 218223.82 | 575228.38 | -0.1570450081685643 | -0.3661574344138306 | 0.3551194424198355 | 0.4170277000825308 | 28 | 10 | 13 | 2 | 3 | 1
ALBAUGH | Aqua Star | 2373851.31 | 1376365.97 | 176706.59 | 338323.69 | 84617.13 | 18893.73 | 261323.72 | 357217.42 | 0.07443877771771644 | 0.2458093976269989 | 0.1100842832485578 | 0.2595366550656582 | 7 | 11 | 11 | 8 | 15 | 5
DOW | Element | 1187025.36 | 1368628.43 | 132648.95 | 104654.82 | 78335.95 | 210784.06 | 210984.9 | 315438.88 | 0.1117490446876384 | 0.07646693412616017 | 0.1777425378679357 | 0.2304780998886601 | 14 | 12 | 14 | 9 | 11 | 7
ALLIGARE | Picloram | 1157024.5 | 1355103.71 | 32854.42 | 41434.71 | 0 | 0 | 32854.42 | 41434.71 | 0.02839561305745902 | 0.03057678146272657 | 0.02839561305745902 | 0.03057678146272657 | 15 | 13 | 48 | 47 | 24 | 25
BASF | Arsenal | 1746287.81 | 1313934.49 | -628985.94 | -198461.77 | 1095855.17 | 331633.67 | 466869.23 | 133171.9 | -0.3601845791960261 | -0.1510438849961234 | 0.2673495327210696 | 0.1013535309511511 | 10 | 14 | 5 | 22 | 6 | 16
DUPONT | Krovar | 1349541 | 1278442.34 | -81854.1 | -111416.74 | 803422.96 | 360260.21 | 721568.86 | 248843.47 | -0.06065328878485352 | -0.08715038333289243 | 0.5346772421141707 | 0.1946458297055462 | 13 | 15 | 2 | 12 | 1 | 10
BASF | Habitat | 1027999.38 | 1222058.71 | 5056.88 | -129362.12 | 214996.39 | 385171.13 | 220053.27 | 255809.01 | 0.004919146935672277 | -0.1058558962359509 | 0.2140597302694871 | 0.2093262851504082 | 19 | 16 | 12 | 11 | 9 | 9
UPI | Hydrothol | 876516.91 | 1178153.52 | 5516.48 | -440.51 | 55079.96 | 117523.46 | 60596.44 | 117082.95 | 0.006293637848926382 | -0.0003738986409852597 | 0.06913322413825422 | 0.09937834756882957 | 23 | 17 | 37 | 27 | 18 | 18
ALLIGARE | Bromacil | 58240 | 1145534.4 | 2025.1 | 43215.71 | 0 | 0 | 2025.1 | 43215.71 | 0.03477163461538461 | 0.03772537079637242 | 0.03477163461538461 | 0.03772537079637242 | 88 | 18 | 113 | 44 | 23 | 24
APPLIED BIO | Cutrine | 1047689.96 | 1085551.21 | 174227.61 | 189172.59 | 5211.01 | 13499.37 | 179438.62 | 202671.96 | 0.1662969166947061 | 0.174264086537198 | 0.1712707259311715 | 0.1866995846285317 | 18 | 19 | 18 | 16 | 12 | 11
DOW | Rodeo | 958009.06 | 1033569.94 | 26405.09 | -15580.71 | 376704.03 | 383840.11 | 403109.12 | 368259.4 | 0.02756246376208592 | -0.01507465474469971 | 0.4207779830391165 | 0.3562984813586975 | 21 | 20 | 7 | 6 | 2 | 3
LUXEMBOURG PAMOL | Target MSMA | 926012.35 | 1021042.05 | 85338.03 | 103267.31 | 2781.42 | 0 | 88119.45 | 103267.31 | 0.09215647069933787 | 0.1011391352589249 | 0.09516012394435128 | 0.1011391352589249 | 22 | 21 | 29 | 28 | 16 | 17
ALBAUGH | Gly Star | 49312.68 | 1020545.96 | -16849.04 | -41417.85 | 10882.76 | 430302.16 | -5966.28 | 388884.31 | -0.3416776374757973 | -0.04058401250248445 | -0.1209887598889373 | 0.3810551658055655 | 92 | 22 | 251 | 5 | 25 | 2
BASF | Sahara | 1085491.06 | 978167.98 | 53631.03 | 41551.42 | 309395.54 | 104790.71 | 363026.57 | 146342.13 | 0.0494071595578134 | 0.04247881841317275 | 0.3344353384172505 | 0.1496083832145068 | 17 | 23 | 8 | 21 | 4 | 12
NUFARM | Aquaneat | 963394.48 | 937865.08 | 103131.06 | 46133.29 | 88340.18 | 29973.09 | 191471.24 | 76106.38 | 0.1070496687919574 | 0.0491896872842307 | 0.1987464574220936 | 0.08114853791123133 | 20 | 24 | 16 | 34 | 10 | 22
MONSANTO | Aquamaster | 374431.8 | 906750.1 | -67096.94 | -76027.18 | 85885.38 | 303810.77 | 18788.44 | 227783.59 | -0.1791966921612961 | -0.08384579169056612 | 0.05017853718621122 | 0.2512087839857972 | 42 | 25 | 59 | 14 | 20 | 6
Top 25 Total |  |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | - | -