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

Created
Helena Chemical Company- All Business Units
Top 25 Families-Retail and Wholesale
T&O Subcategory Only (Includes Turf and Ornamental)
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
MONSANTO | Roundup | 4477465.31 | 4401798.76 | 8846.67 | -42310.06 | 1242310.54 | 1211377.48 | 1251157.21 | 1169067.42 | 0.001975821003066577 | -0.00961199325704749 | 0.2794342609881661 | 0.265588565888914 | 1 | 1 | 1 | 1 | 3 | 2
PBI GORDON CORP | Trimec | 2333032.97 | 2865029.33 | 177430.93 | 155002.43 | 191285.43 | 290414.55 | 368716.36 | 445416.98 | 0.07605161705022967 | 0.05410151595201994 | 0.1580416413918059 | 0.1554668133188012 | 6 | 2 | 8 | 5 | 14 | 16
BAYER | Chipco | 3118655.67 | 2718171.63 | 56411.62 | 74806.86 | 455058.17 | 426692.11 | 511469.79 | 501498.97 | 0.01808844129303958 | 0.02752102154785568 | 0.1640032899175432 | 0.184498640359954 | 3 | 3 | 3 | 2 | 11 | 12
SYNGENTA | Heritage | 3130604.21 | 2307057.6 | -70147.09 | 6905.59 | 422981.41 | 440821.81 | 352834.32 | 447727.4 | -0.02240688547467327 | 0.002993245595601948 | 0.1127048634487079 | 0.1940685832898147 | 2 | 4 | 10 | 4 | 17 | 11
VALENT | [NAME] | 1943229.45 | 2222842.97 | 35508 | 124643.15 | 274442.7 | 129729.8 | 309950.7 | 254372.95 | 0.01827267490208117 | 0.05607375405380075 | 0.1595028832030103 | 0.1144358613870057 | 10 | 5 | 11 | 17 | 13 | 20
DOW | Gallery | 2040846.02 | 2077468.18 | -92732.72 | -95834.35 | 305708.91 | 449034.62 | 212976.19 | 353200.27 | -0.04543837168077972 | -0.04613035757784748 | 0.1043568147292171 | 0.1700147676870796 | 8 | 6 | 19 | 8 | 19 | 15
SYNGENTA | Daconil | 2842776.06 | 1983981.26 | -156706.64 | 29869.71 | 354737.98 | 324196.42 | 198031.34 | 354066.13 | -0.05512451093316158 | 0.01505543958615819 | 0.06966125217756336 | 0.178462436686524 | 4 | 7 | 20 | 7 | 25 | 14
SYNGENTA | Barricade | 2583706.61 | 1973573.01 | -6737.7 | 36552.31 | 452085.2 | 327347.63 | 445347.5 | 363899.94 | -0.002607765128564656 | 0.01852088056271098 | 0.1723676745170382 | 0.1843863582224404 | 5 | 8 | 6 | 6 | 10 | 13
DOW | Dimension | 1712116.28 | 1910228.23 | -631.58 | 750.87 | 462792.79 | 495650.73 | 462161.21 | 496401.6 | -0.0003688884962883479 | 0.0003930786846344533 | 0.2699356436234576 | 0.2598650738189541 | 11 | 9 | 4 | 3 | 4 | 3
BASF | Pendulum | 1567675.13 | 1793429.38 | 26858.56 | 1773.56 | 256616.04 | 186029.01 | 283474.6 | 187802.57 | 0.01713273336166276 | 0.0009889210134385107 | 0.1808248370949152 | 0.1047170142824358 | 14 | 10 | 14 | 28 | 9 | 22
SYNGENTA | Primo | 2125790.5 | 1691104.12 | -108401.33 | -6697.44 | 304918.11 | 254654 | 196516.78 | 247956.56 | -0.05099342103561005 | -0.003960394821816175 | 0.09244409550235548 | 0.1466240647559891 | 7 | 11 | 21 | 18 | 21 | 17
DOW | Snapshot | 1547658.08 | 1470757.34 | 5138.94 | 27963.49 | 237858.06 | 304308.9 | 242997 | 332272.39 | 0.003320462101034616 | 0.01901298687382379 | 0.1570094862296716 | 0.2259192464747448 | 15 | 12 | 15 | 10 | 15 | 7
FMC | Talstar | 1615558.31 | 1411284.76 | 16612.92 | -58341.07 | 346316.14 | 399261 | 362929.06 | 340919.93 | 0.01028308288049349 | -0.04133897825127793 | 0.224646215338399 | 0.2415670739617425 | 13 | 13 | 9 | 9 | 7 | 5
BAYER | Topchoice | 1680458.89 | 1390571.55 | -16530.42 | 31680.56 | 184845.25 | 245804.08 | 168314.83 | 277484.64 | -0.009836848790749055 | 0.02278240195551247 | 0.1001600402137776 | 0.1995471861911744 | 12 | 14 | 29 | 12 | 20 | 10
PBI GORDON CORP | Speed Zone | 1211899.68 | 1288120.85 | 93112.84 | 64296.61 | 36248.2 | 46162.61 | 129361.04 | 110459.22 | 0.07683213514834826 | 0.04991504485002319 | 0.1067423666619006 | 0.08575221804693248 | 20 | 15 | 36 | 52 | 18 | 24
MONSANTO | Ranger | 1426250.57 | 1264350.19 | 219815.04 | 133740.11 | 356960.36 | 133705.84 | 576775.4 | 267445.95 | 0.1541209129893634 | 0.1057777434272383 | 0.4043997682679278 | 0.2115283820220726 | 17 | 16 | 2 | 15 | 1 | 8
SYNGENTA | Subdue | 1499419.64 | 1246628.61 | -7447.14 | 25034.86 | 142869.76 | 107948.09 | 135422.62 | 132982.95 | -0.004966681642238594 | 0.02008205154219908 | 0.0903166907964471 | 0.1066740719194628 | 16 | 17 | 35 | 41 | 22 | 21
BAYER | Merit | 1972882.64 | 1101551.98 | 26745.22 | 31351.06 | 424301.02 | 237700.3 | 451046.24 | 269051.36 | 0.01355641712169965 | 0.02846080854032871 | 0.2286229453567497 | 0.244247538822453 | 9 | 18 | 5 | 14 | 5 | 4
SYNGENTA | Medallion | 970936.75 | 1036029.3 | -16236 | 1016.9 | 93139.27 | 92423.45 | 76903.27 | 93440.35 | -0.01672199553678445 | 0.0009815359469080652 | 0.07920523144272787 | 0.09019083726686108 | 26 | 19 | 63 | 61 | 24 | 23
BAYER | Revolver | 888314.47 | 1022049.82 | 52359.98 | 49318.21 | 68808.76 | 156307.74 | 121168.74 | 205625.95 | 0.0589430677629286 | 0.04825421328287108 | 0.1364029790035954 | 0.2011897521786169 | 32 | 20 | 40 | 23 | 16 | 9
NUFARM | T-Methyl | 915841.92 | 988292.77 | 64948.6 | 71023.25 | 82465.38 | 213567.63 | 147413.98 | 284590.88 | 0.0709168237243388 | 0.0718645852281202 | 0.1609600704890206 | 0.2879621187555587 | 30 | 21 | 31 | 11 | 12 | 1
VALENT | SureGuard | 955580.1 | 928598.2 | 50001.78 | 59335.02 | 130656.65 | 75213.97 | 180658.43 | 134548.99 | 0.05232610013540466 | 0.06389741009620738 | 0.1890562915657201 | 0.1448947348810282 | 27 | 22 | 26 | 39 | 8 | 18
CLEARY | Cleary | 1309885.48 | 916224.77 | 113657.2 | 90537.42 | 184460.91 | 23502.75 | 298118.11 | 114040.17 | 0.08676880668987948 | 0.09881573055485064 | 0.2275909723039299 | 0.124467460097155 | 18 | 23 | 13 | 49 | 6 | 19
CHEMTURA | Floramite | 862321.07 | 905933.07 | 44247.6 | 57653.65 | 28978.71 | 12411.84 | 73226.31 | 70065.49 | 0.05131221019567572 | 0.06364007663391734 | 0.08491768616995524 | 0.07734069140449858 | 34 | 24 | 70 | 74 | 23 | 25
SETRE CHEMICAL | XL 2G | 1250539 | 894250.7 | 71237.59 | -2232.42 | 345694.54 | 206124.41 | 416932.13 | 203891.99 | 0.05696550847274655 | -0.00249641403691381 | 0.333401941083005 | 0.2280031651079502 | 19 | 25 | 7 | 24 | 2 | 6
Top 25 Total |  |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | - | -