Question 3: The Wall Street Journal CEO Compensation Study analyzed CEO pay from many U.S. companies with a fiscal year 2008 revenue of at least $5 billion filed their proxy statements between October 2008 and March 2009. The data are in the file P02_30.xlsx. a. (I do not know how to paste the excel sheet here)

Create a pivot table and an accompanying pivot chart that shows the average of Salaries 2008 and Bonuses 2008 for each Company Type. Comment on any findings that may stand out in the chart. Hint: Refer to the lab materials and slides to learn how to properly comment on charts while applying the ONE paragraph rule. [ 5 points]

Put a new column in the Datasheet. In that column, compute the total of Salary 2008 and Bonus 2008. Then create two pivot tables and corresponding pivot charts on a single sheet. The first table should show the counts of CEOs by company Type, and the second table should simultaneously show 1.the average of Total 2008, 2.the minimum of Total 2008, 3.the maximum of Total 2008, all broken down by Company Type. Comment on any findings that may stand out on these two charts. ONE paragraph per chart. [ 6 points]

Template Example was given in word but also have to do it in Excel

PO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum , Calibri A- A Wrap Text General ND 49 Copy Fill Paste I Merge & Center $ % Delete Format Format Insert 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 x fx Company Name B D E F H 1 J L M 1 Company Name 2 3M 3 Abbott Labs 4 Advance Auto Parts 5 Advanced Micro Devices 6 Aecom Technology 7 AES 8 Affiliated Computer 9 Aflac 10 AGCO 11 Agilent Technologies 12 AIG 13 Air Products 14 Alcoa 15 Allegheny Technologies 16 Allstate 17 Alon USA Energy 18 Altria Group 19 Amazon.com 20 Ameren 21 American Electric Power 22 American Express 23 Ameriprise Financial 24 AmerisourceBergen 25 Amgen 26 AMR 27 Anadarko Petroleum 28 Anixter International 29 Aon 30 Apache 31 Apple Computer Company Type Industrials Health Care Consumer Services Technology Industrials Utilities Industrials Financials Industrials Industrials Financials Basic Materials Basic Materials Basic Materials Financials Oil & Gas Consumer Goods Consumer Services Utilities Utilities Financials Financials Consumer Services Health Care Consumer Services Oil & Gas Industrials Financials Oil & Gas Technology Executive_Name Buckley, George W. White, Miles D. Jackson, Darren R. Meyer, Derrick R. Dionisio, John M. Hanrahan, Paul Blodgett, Lynn Amos, Daniel P. Richenhagen, Martin H. Sullivan, William P. Liddy, Edward M. Jones, John P. Kleinfeld, Klaus Hassey, L. Patrick Wilson II, Thomas J. Morris, Jeff D. Szymanczyk, Michael E. Bezos, Jeffrey P. Rainwater, Gary L. Morris, Michael G. Chenault, Kenneth I. Cracchiolo, James M. Yost, R. David Sharer, Kevin W. Arpey, Gerard J. Hackett, James T. Eck, Robert J. Case, Gregory C. Farris, G. Steven Jobs, Steven P. Salary 2008 $1,720,000 $1,795,500 $800,000 $856,700 $956,500 $999,000 $750,000 $1,338,200 $1,024,800 $986,700 $0 $1,000,000 $1,400,000 $907,900 $1,040,800 $307,200 $1,200,000 $81,800 $935,000 $1,259,600 $1,250,000 $850,000 $1,182,100 $1,561,900 $666,300 $1,510,400 $549,600 $1,500,000 $1,493,800 $0 Bonus 2008 $2,644,100 $4,200,000 $1,959,900 $0 $2,000,000 $1,756,200 $725,600 $0 $1,124,400 $1,305,600 $0 $2,002,000 $1,884,000 $2,149,900 $151,700 $0 $2,800,000 $0 $771,700 $1,654,100 $0 SO $1,369,500 $3,875,000 $200 $3,416,500 $218,800 $1,772,000 $500,000 $0 Source Data + Ready + 139% PO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum , Calibri A- A Wrap Text General ND 49 Fill Paste Copy Format I Merge & Center $ - % Delete Format 0 Conditional Format Formatting as Table Insert Cell Styles Clear Sort & Filter A1 fx Company Name B D E F H 1 J M 32 Applied Materials 33 Arrow Electronics 34 Arvin Meritor 35 Ashland 36 Assurant 37 AT&T 38 Atmos Energy 39 AutoNation 40 AutoZone 41 Avery Dennison 42 Avis Budget Group 43 Avon 44 Baker Hughes 45 Ball 46 Bank of America 47 Bank of New York Mellon 48 Barnes & Noble 49 Baxter 50 BB&T 51 Becton Dickinson 52 Bed Bath & Beyond 53 Berkshire Hathaway 54 Best Buy 55 BJ Services 56 BJ's Wholesale Club 57 Black & Decker 58 Blackrock 59 Blockbuster 60 Boeing 61 BorgWarner 62 Boston Scientific Source Data Technology Industrials Consumer Goods Basic Materials Financials Telecommunications Utilities Consumer Services Consumer Services Basic Materials Consumer Services Consumer Goods Oil & Gas Industrials Financials Financials Consumer Services Health Care Financials Health Care Consumer Services Financials Consumer Services Oil & Gas Consumer Services Consumer Goods Financials Consumer Services Industrials Consumer Goods Health Care Splinter, Michael R. Mitchell, William E. McClure Jr., Charles G. O'Brien, James J. Pollock, Robert B. Stephenson, Randall L. Best, Robert W. Jackson, Mike Rhodes III, William C. Scarborough, Dean A. Nelson, Ronald L. Jung, Andrea Deaton, Chad C. Hoover, R. David Lewis, Kenneth D. Kelly, Robert P. Riggio, Stephen Parkinson Jr., Robert L. Allison IV, John A. Ludwig, Edward .. Temares, Steven H. Buffett, Warren E. Anderson, Bradbury H. Stewart, J.W. Zarkin, Herbert J. Archibald, Nolan D. Fink, Laurence D. Keyes, James W. McNerney Jr., W. James Manganello, Timothy M. Tobin, James R. $929,400 $1,100,000 $1,120,800 $1,110,900 $950,000 $1,420,800 $820,400 $1,150,000 $706,000 $945,000 $1,000,000 $1,375,000 $1,155,000 $1,100,000 $1,500,000 $993,800 $800,000 $1,339,300 $993,700 $1,059,800 $1,468,300 $100,000 $1,247,300 $1,141,700 $975,000 $1,500,000 $650,000 $975,000 $1,598,500 $445,400 $1,638,800 $0 $835,200 $0 $779,400 $220,000 $0 $1,689,400 $1,296,200 $922,800 $0 $0 $1,961,500 $2,708,900 $0 $1,526,200 $0 $0 $0 $575,000 $0 $1,875,000 $17,149,500 $402,500 $1,476,500 $0 $885,700 $500,000 $750,000 $1,915,300 $1,100,000 $989,600 + Ready 0 - + 139% PO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum Calibri A- A Wrap Text General ND 49 3 Copy Fill Paste 1 Merge & Center $ % Delete Format Format Insert 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 fx Company Name D E F H 1 j L M Health Care 63 Bristol-Myers Squibb 64 Burlington Northern 65 CH Robinson 66 Calpine 67 Cameron International 68 Campbell Soup 69 Capital One Financial 70 Carmax 71 Caterpillar 72 CB Richard Ellis Group 73 CBS 74 CC Media Holdings 75 Celanese 76 CenterPoint Energy 77 Chevron 78 Chubb 79 Cigna 80 CIT Group 81 Citigroup 82 Clorox 83 CMS Energy 84 CNA Financial 85 Coca-Cola Co. 86 Coca-Cola Enterprises 87 Colgate-Palmolive 88 Comcast 89 Commercial Metals 90 Community Health Systems 91 Computer Sciences 92 Con Edison 93 Conagra Foods Industrials Industrials Utilities Oil & Gas Consumer Goods Financials Consumer Services Industrials Financials Consumer Services Financials Basic Materials Utilities Oil & Gas Financials Health Care Financials Financials Consumer Goods Utilities Financials Consumer Goods Consumer Goods Consumer Goods Consumer Services Basic Materials Health Care Technology Utilities Consumer Goods Cornelius, James M. Rose, Matthew K. Wiehoff, John P. Fusco, Jack A. Moore, Jack B. Conant, Douglas R. Fairbank, Richard D. Folliard, Thomas). Owens, James W. White, Brett Moonves, Leslie Mays, Mark P. Weidman, David N. McClanahan, David M. O'Reilly, David J. Finnegan, John D. Hanway, H. Edward Peek, Jeffrey M. Pandit, Vikram S. Knauss, Donald R. Joos, David W. Lillienthal, Stephen W. Kent, Muhtar Brock, John F. Cook, lan M. Roberts, Brian L. McClean, Murray R. Smith, Wayne T. Laphen, Michael W. Burke, Kevin Rodkin, Gary $1,488,100 $1,183,600 $400,000 $396,200 $745,400 $1,177,500 $0 $846,200 $1,550,000 $850,000 $3,513,500 $895,000 $900,000 $1,052,500 $1,650,000 $1,275,000 $1,142,900 $800,000 $958,300 $987,500 $1,045,000 $950,000 $1,100,000 $1,144,000 $1,075,000 $2,769,400 $600,000 $1,080,000 $1,057,700 $1,102,500 $1,019,200 $4,475,000 $1,679,500 $1,314,200 $896,200 $903,000 $1,866,400 $0 $0 $1,853,200 $0 $11,000,000 $4,500,000 $755,700 $1,578,800 $4,161,000 $3,357,800 $0 $0 $0 $1,380,000 $971,900 $2,900,000 $4,500,000 $147,300 $3,162,500 $7,394,200 $1,911,200 $2,071,400 $2,142,400 $1,066,100 $1,100,000 Source Data + Ready + 139% PO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum Calibri 11 A- A Wrap Text General ND 49 Copy Fill Paste T Merge & Center $ - % Delete Format Insert Format 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 fx Company Name F H 1 J L M A 94 ConocoPhillips 95 Constellation Energy 96 Continental Airlines 97 Con-Way Inc 98 Corning 99 Costco 100 Coventry Health Care 101 Crown Holdings 102 CSX 103 Cummins 104 CVR Energy 105 CVS Caremark 106 Dana Holding 107 Danaher 108 Davita 109 Dean Foods 110 Deere 111 Dell 112 Devon Energy 113 Dillards 114 DirecTV Group 115 Discover Financial 116 Dish Network 117 Disney (Walt) 118 Dominion Resources 119 Donnelley (RR) & Sons 120 Dover 121 Dow Chemical 122 Dr Pepper Snapple Group 123 DTE Energy 124 Du Pont B Oil & Gas Utilities Consumer Services Industrials Technology Consumer Services Health Care Industrials Industrials Industrials Oil & Gas Consumer Services Consumer Goods Industrials Health Care Consumer Goods Industrials Technology Oil & Gas Consumer Services Consumer Services Financials Consumer Services Consumer Services Utilities Industrials Industrials Basic Materials Consumer Goods Utilities Basic Materials Mulva, James J. Shattuck III, Mayo A. Kellner, Lawrence W. Stotlar, Douglas W. Weeks, Wendell P. Sinegal, James D. Wolf, Dale B. Conway, John W. Ward, Michael J. Solso, Theodore M. Lipinski, John J. Ryan, Thomas M. Convis, Gary L. Culp Jr., H. Lawrence Thiry, Kent J. Engles, Gregg L. Lane, Robert W. Dell, Michael S. Nichols, J. Larry Dillard, II, William Carey, Chase Nelms, David W. Ergen, Charles W. Iger, Robert A. Farrell II, Thomas F. Quinlan, Thomas J. Livingston, Robert A. Liveris, Andrew Young, Larry D. Earley Jr., Anthony F. Holliday Jr., Charles O. D $1,500,000 $1,290,400 $296,900 $700,400 $1,030,000 $350,000 $965,000 $1,075,000 $1,058,300 $1,210,000 $700,000 $1,400,000 $850,000 $1,100,000 $1,023,100 $1,300,000 $1,435,500 $931,700 $1,400,000 $810,000 $2,291,600 $1,000,000 $600,000 $2,000,000 $1,191,700 $985,600 $767,500 $1,641,700 $867,300 $1,186,500 $1,369,500 E $1,417,500 $0 $0 $245,500 $301,600 $80,000 $0 $3,560,400 $2,032,000 $1,064,800 $1,700,000 $2,350,000 $1,515,400 $3,267,300 $2,000,000 $2,350,900 $3,588,900 $0 $3,000,600 $196,300 $3,500,000 $4,750,000 $0 $13,945,500 $2,355,000 $0 $1,000,000 $0 $1,643,200 $1,500,000 $1,732,000 Source Data + - Ready + 139% PO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum Calibri 11 A- A Wrap Text General ND 49 Copy Fill Paste T Merge & Center $ - % Delete Format Format Insert 0 .00 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 X fx Company Name B D E F H 1 J L M 125 Duke Energy 126 Eastman Chemical 127 Eastman Kodak 128 Eaton 129 Ebay 130 Ecolab 131 Edison International 132 El Paso 133 EMC 134 Emcor Group 135 Emerson Electric 136 Entergy 137 EOG Resources 138 Estee Lauder 139 Exelon 140 Expeditors International 141 Express Scripts 142 Exxon Mobil 143 Family Dollar 144 Federal-Mogul 145 Fifth Third Bancorp 146 Firstenergy 147 Fluor 148 Foot Locker 149 Ford Motor 150 Fortune Brands 151 FPL Group 152 Franklin Resources 153 Frontier Oil 154 Gamestop 155 Gannett Utilities Basic Materials Consumer Goods Industrials Consumer Services Basic Materials Utilities Oil & Gas Technology Industrials Industrials Utilities Oil & Gas Consumer Goods Utilities Industrials Health Care Oil & Gas Consumer Services Consumer Goods Financials Utilities Industrials Consumer Services Consumer Goods Industrials Utilities Financials Oil & Gas Consumer Services Consumer Services Rogers, James E. Ferguson, J. Brian Perez, Antonio M. Cutler, Alexander M. Donahoe, John J.5 Baker Jr., Douglas M. Craver Jr., Theodore F. Foshee, Douglas L. Tucci, Joseph M. MacInnis, Frank T. Farr, David N. Leonard, J. Wanye Papa, Mark G. Lauder, William P. Rowe, John W. Rose, Peter J. Paz, George Tillerson, Rex W. Levine, Howard R. Maria Alapont, Jose Kabat, Kevin T. Alexander, Anthony J. Boeckmann, Alan L. Serra, Matthew D. Mulally, Alan Carbonari, Bruce A. Hay, III, Lewis Johnson, Gregory E. Gibbs, James R. DeMatteo, Daniel A. Dubow, Craig A. $0 $1,131,200 $1,096,200 $1,132,500 $879,800 $1,000,000 $892,500 $1,037,500 $1,000,000 $950,000 $1,200,000 $1,273,500 $940,000 $1,500,000 $1,474,400 $110,000 $941,800 $1,870,000 $878,500 $1,500,000 $900,000 $1,329,400 $1,232,300 $1,500,000 $2,000,000 $1,100,000 $1,255,800 $780,100 $975,000 $1,035,400 $1,166,700 $0 $925,000 $0 $320,000 $500,000 $1,397,000 $1,050,000 $1,186,400 $1,388,600 $2,585,000 $3,000,000 $2,169,700 $2,000,000 $3,074,500 $1,835,200 $5,815,800 $2,450,500 $4,000,000 $533,200 $3,075,000 $0 $2,305,400 $3,073,200 $1,728,300 So $0 $2,400,000 $4,500,000 $780,000 $2,400,000 $875,000 Source Data + Ready - + 139% PO2_30 (1) Q Search Sheet Home Page Layout Formulas Data Review View + Share Insert Cut Copy AutoSum , Calibri A4 A Wrap Text General ND 49 Fill Paste I Merge & Center $ % Delete Format Insert 0 Format Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 fx Company Name B E F G H 1 j L M 156 Gap 157 General Cable 158 General Dynamics 159 General Electric 160 General Mills 161 Genuine Parts 162 Genworth Financial 163 Gilead Sciences 164 Goldman Sachs Group 165 Goodrich 166 Goodyear 167 Google 168 Grainger (W.W.) 169 Great Atlantic & Pacific Tea 170 Group 1 Automotive 171 Halliburton 172 Harley-Davidson 173 Hartford Financial Services 174 Health Net 175 Heinz (HJ) 176 Hershey 177 Hertz Global Holdings 178 Hess 179 Hewlett-Packard 180 Holly Corp 181 Home Depot 182 Honeywell International 183 Hormel Foods 184 Horton (D.R.) 185 Host Hotels & Resorts 186 Humana 107 ID Source Data Consumer Services Industrials Industrials Industrials Consumer Goods Consumer Goods Financials Health Care Financials Industrials Consumer Goods Technology Industrials Consumer Services Consumer Services Oil & Gas Consumer Goods Financials Health Care Consumer Goods Consumer Goods Consumer Services Oil & Gas Technology Oil & Gas Consumer Services Industrials Consumer Goods Consumer Goods Financials Health Care Technolo Murphy, Glenn K. Kenny, Gregory B. Chabraja, Nicholas D. Immelt, Jeffery R. Powell, Kendall J. Gallagher, Thomas C. Fraizer, Michael D. Martin, John C. Blankfein, Lloyd C. Larsen, Marshall Keegan, Robert J. Schmidt, Eric Ryan, James T. Claus, Eric Hesterberg, Earl J. Lesar, David J. Ziemer, James L. Ayer, Ramani Gellert, Jay M. Johnson, William R. West, David J. Frissora, Mark P. Hess, John B. Hurd, Mark V. Clifton, Matthew P. Blake, Francis S. Cote, David M. Ettinger, Jeffrey M. Tomnitz, Donald J. Walter, W. Edward McCallister, Michael B. D $1,500,000 $823,300 $1,375,000 $3,300,000 $959,600 $875,000 $1,121,400 $1,146,300 $600,000 $1,100,000 $1,216,700 $0 $787,500 $800,000 $1,000,000 $1,300,000 $980,700 $1,150,000 $1,204,600 $1,245,200 $1,000,000 $1,094,700 $1,500,000 $1,450,000 $849,800 $1,013,500 $1,826,000 $912,100 $300,000 $750,000 $1,017,300 01 Onn non $3,016,400 $844,000 $4,500,000 $0 $2,638,800 $866,700 $0 $1,651,700 $0 $2,173,600 $0 $0 $631,100 $432,000 $200,000 $3,120,000 $450,300 $0 $0 $3,650,000 $1,128,400 $600,900 $3,500,000 $10,243,700 $608,000 $0 $3,500,000 $1,343,700 $1,848,500 $467,600 $0 cc con onn + - Ready + 139% PO2_30 (1) Q Search Sheet Home Page Layout Formulas Data Review View + Share Insert Cut Copy AutoSum , Calibri A- A Wrap Text General ND 49 Fill Paste I Merge & Center $ - % Delete Format Format Insert 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 X fx Company Name B D E F H 1 J M 187 IBM 188 Illinois Tool Works 189 Ingram Micro 190 Integrys Energy Group 191 Intel 192 International Assets Holding 193 International Paper 194 Interpublic Group of Companies 195 ITT 196 Jabil Circuit 197 Jacobs Engineering 198 JCPenney 199 Johnson & Johnson 200 Johnson Controls 201 JPMorgan Chase 202 KBR 203 Kellogg 204 Kelly Services 205 KeyCorp 206 Kimberly-Clark 207 Kohl's 208 Kraft Foods 209 Kroger 210 L-3 Communications 211 Lear 212 Liberty Global 213 Liberty Media 214 Lilly (Eli) 215 Lincoln National 216 Lockheed Martin 217 Loews Technology Industrials Technology Utilities Technology Financials Basic Materials Consumer Services Industrials Industrials Industrials Consumer Services Health Care Consumer Goods Financials Industrials Consumer Goods Industrials Financials Consumer Goods Consumer Services Consumer Goods Consumer Services Industrials Consumer Goods Consumer Services Consumer Services Health Care Financials Industrials Financials Palmisano, Samuel J. Speer, David B. Spierkel, Gregory M.E. Weyers, Larry L. Otellini, Paul S. O'Connor, Sean M. V Faraci, John Roth, Michael I. Loranger, Steven R. Main, Timothy L. Martin, Craig L. Ullman III, Myron E. Weldon, William C. Roell, Stephen A. Dimon, James Utt, William P. Mackay, David Camden, Carl T. Meyer III, Henry L. Falk, Thomas J. Mansell, Kevin Rosenfeld, Irene Dillon, David B. Strianese, Michael T. Rossiter, Robert E. Fries, Michael T. Maffei, Gregory B. Lechleiter, John C. Glass, Dennis R. Stevens, Robert J. Tisch, James S. $1,800,000 $1,099,600 $850,000 $1,050,000 $1,000,000 $175,000 $1,261,400 $1,332,500 $1,119,600 $1,000,000 $1,084,600 $1,500,000 $1,792,000 $1,325,000 $1,000,000 $900,000 $1,136,500 $917,500 $1,019,500 $1,225,000 $1,067,500 $1,452,200 $1,204,800 $1,145,400 $1,237,000 $957,000 $1,000,000 $1,339,100 $1,000,000 $1,774,000 $1,100,000 $5,500,000 $1,586,200 $0 $684,100 $3,873,300 $750,000 $1,575,000 $2,500,000 $2,534,000 $155,900 $1,301,700 $1,406,300 $3,700,000 $3,492,600 $0 $1,100,000 $2,601,300 $0 $O $943,200 $0 $4,070,000 $1,574,200 $2,750,000 $0 $1,600,000 $5,464,000 $2,709,100 $800,000 $4,250,000 $2,500,000 Source Data + Ready - + 139% PO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum Calibri A- A Wrap Text General ND 49 Copy Fill Paste I Merge & Center $ - % Delete Format Format Insert 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 fx Company Name A B D E F H 1 j L M Consumer Services Basic Materials Consumer Services Industrials Oil & Gas Consumer Services Financials Industrials Consumer Goods Consumer Services Consumer Services Industrials Industrials Health Care Health Care 218 Lowe's 219 Lubrizol 220 Macy's 221 Manpower 222 Marathon Oil 223 Marriott International 224 Marsh & McLennan 225 Masco 226 Mattel 227 McDonald's 228 McGraw-Hill 229 MDU Resources 230 MeadWestvaco 231 Medco Health Solutions 232 Merck 233 MetLife 234 MGM Mirage 235 Micron Technology 236 Mohawk Industries 237 Monsanto 238 Morgan Stanley 239 Motorola 240 Motorola 241 Murphy Oil 242 National Oilwell Varco 243 Navistar International 244 NCR 245 Newell Rubbermaid 246 Newmont Mining 247 News Corp. 248 Nisource Financials Consumer Services Technology Consumer Goods Basic Materials Financials Technology Technology Oil & Gas Oil & Gas Industrials Technology Consumer Goods Basic Materials Consumer Services Utilities Niblock, Robert A. Hambrick, James L. Lundgren, Terry J. Joerres, Jeffrey A. Cazalot Jr., Clarence P. Marriott, Jr., J. Willard Duperreault, Brian Wadhams, Timothy Eckert, Robert A. Skinner, James A. McGraw III, Harold Hildestad, Terry D. Luke Jr., John A. Snow Jr., David B. Clark, Richard T. Henrikson, C. Robert Murren, James J. Appleton, Steven R. Lorberbaum, Jeffrey S. Grant, Hugh Mack, John J. Brown, Gregory Q. Jha, Dr. Sanjay K. Deming, Claiborne P. Miller Jr., Merrill A. Ustian, Daniel C. Nuti, William Ketchum, Mark D. O'Brien, Richard T. Murdoch, K. Rupert Skaggs, Jr., Robert C. $1,100,000 $933,500 $1,500,000 $1,000,000 $1,381,300 $1,253,700 $927,100 $934,600 $1,250,000 $1,337,500 $1,350,000 $700,000 $1,055,900 $1,281,500 $1,783,300 $1,000,000 $1,500,000 $950,000 $980,000 $1,286,000 $800,000 $1,200,000 $484,600 $1,241,700 $950,000 $1,170,800 $1,000,000 $1,291,700 $1,000,000 $8,100,000 $791,700 $1,500,800 $800,000 $900,000 $300,000 $1,700,000 $904,700 $3,000,000 $0 $0 $4,600,000 $0 $310,800 $0 $3,000,000 $2,244,500 $3,250,000 $0 $0 $300,000 $3,326,800 $0 $0 $0 $2,000,000 $1,826,000 $2,589,500 $1,375,000 SO $1,894,400 $5,435,000 $0 Source Data + Ready + 139% PO2_30 (1) Q Search Sheet Home Page Layout Formulas Data Review View + Share Insert Cut 3 Copy AutoSum Calibri A- A Wrap Text General ND 49 Fill Paste 1 Merge & Center $ % Delete Format Insert Format .00 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 fx Company Name B D E F H 1 j L M 249 Nordstrom 250 Norfolk Southern 251 Northeast Utilities 252 Northern Trust 253 Northrop Grumman 254 Nucor 255 Occidental 256 Office Depot 257 Office Max 258 Omnicare 259 Omnicom 260 Oneok 261 Oshkosh 262 Owens & Minor 263 Owens-Illinois 264 Paccar 265 Pantry 266 Penske Automotive 267 Pepco Holdings 268 Pepsi Bottling Group 269 PepsiCo 270 Pfizer 271 PG 272 Philip Morris 273 Pitney Bowes 274 PNC Financial 275 PPG Industries 276 PPL 277 Praxair 278 Precision Castparts 279 Principal Financial Consumer Services Industrials Utilities Financials Industrials Basic Materials Oil & Gas Consumer Services Consumer Services Consumer Services Consumer Services Utilities Industrials Health Care Industrials Industrials Consumer Services Consumer Services Utilities Consumer Goods Consumer Goods Health Care Utilities Consumer Goods Technology Financials Basic Materials Utilities Basic Materials Industrials Financials Nordstrom, Blake W. Moorman IV, Charles W. Shivery, Charles W. Waddell, Frederick H. Sugar, Ronald D. Di Micco, Daniel R. Irani, Ray R. Odland, Steve Duncan, Sam K. Gemunder, Joel F. Wren, John D. Gibson, John W. Bohn, Robert G. Smith, Craig R. Stroucken, Albert P.L. Pigott, Mark C. Sodini, Peter J. Penske, Roger S. Wraase, Dennis R. Foss, Eric J. Nooyi, Indra K. Kindler, Jeffrey B. Darbee, Peter A. Camilleri, Louis C. Martin, Murray D. Rohr, James E. Bunch, Charles E. Miller, James H. Angel, Stephen F. Donegan, Mark Zimpleman, Larry D. $696,100 $950,000 $1,067,400 $856,300 $1,525,000 $800,000 $1,300,000 $1,000,000 $1,022,600 $1,816,700 $1,000,000 $825,000 $1,150,000 $788,100 $1,011,500 $1,348,800 $800,000 $1,000,000 $1,076,000 $984,600 $1,300,000 $1,575,000 $1,090,800 $1,567,300 $941,700 $1,000,000 $1,041,700 $1,141,100 $1,026,300 $1,275,000 $737,500 $0 $1,759,400 $1,519,100 $0 $2,775,500 $2,160,000 $3,630,000 $0 $0 $5,125,000 $1,750,000 $853,000 $178,000 $1,080,000 $559,900 $0 $352,600 $0 $968,400 $840,000 $2,600,000 $5,250,000 $1,285,000 $9,450,000 $1,378,000 $3,000,000 $1,750,000 $0 $2,500,000 $1,689,400 $0 Source Data + Ready + 139% XPO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum Calibri 11 A- A Wrap Text Custom ND 49 Fill Paste Copy Format I Merge & Center $ - % Delete Format 0 Conditional Format Formatting as Table Insert Cell Styles Clear Sort & Filter A1 fx Company Name D E F H 1 J L M 280 Progress Energy 281 Progressive 282 Prologis 283 Prudential Financial 284 PSEG 285 Publix Super Markets 286 Pulte Homes 287 Qualcomm 288 Quest Diagnostics 289 Qwest 290 Raytheon 291 Regions Financial 292 Reliance Steel & Aluminum 293 Reynolds American 294 Rite Aid 295 Rockwell Automation 296 Ross Stores 297 RRI Energy 298 Ryder System 299 Safeway 300 SAIC 301 Sanmina-SCI 302 Scana 303 Schering-Plough 304 Schwab (Charles) 305 Sears 306 Sempra Energy 307 Shaw Group 308 Sherwin-Williams 309 SLM Corp 310 Smith International Utilities Financials Financials Financials Utilities Consumer Services Consumer Goods Technology Health Care Telecommunications Industrials Financials Basic Materials Consumer Goods Consumer Services Industrials Consumer Services Utilities Industrials Consumer Services Technology Industrials Utilities Health Care Financials Consumer Services Utilities Industrials Industrials Financials Oil & Gas Johnson, William D. Renwick, Glenn M. Rakowich, Walter C. Strangfeld, John R. Izzo, Ralph Crenshaw, William E. Dugas, Jr., Richard J. Jacobs, Paul E. Mohapatra, Surya N. Mueller, Edward A. Swanson, William H. Ritter, C. Dowd Hannah, David H. Ivey, Susan M. Sammons, Mary F. Nosbusch, Keith D. Balmuth, Michael Jacobs, Mark M. Swienton, Gregory T. Burd, Steven A. Dahlberg, Kenneth C. Sola, Jure Timmerman, William B. Hassan, Fred Bettinger II, Walter W. Johnson, W. Bruce Felsinger, Donald E. Bernhard Jr., James M. Connor, Christopher M. Lord, Albert L. Rock, Doug $950,000 $778,800 $630,000 $970,800 $944,300 $754,000 $1,000,000 $1,112,200 $1,143,900 $1,200,000 $1,328,600 $995,000 $700,000 $1,252,800 $1,000,000 $1,030,800 $998,500 $895,000 $895,000 $1,467,400 $1,000,000 $800,000 $1,095,000 $1,720,300 $793,800 $896,500 $1,144,000 $1,735,400 $1,214,600 $1,478,800 $1,347,100 $929,000 $0 $420,000 $3,300,000 $1,000,000 $21,200 $902,100 $2,909,000 $1,915,700 $2,250,000 $3,050,000 $0 $1,883,000 $1,730,000 $0 $561,600 $1,721,400 $600 $567,600 $399,900 $1,469,600 $440,000 $653,900 $3,387,200 $1,938,000 $0 $2,530,000 $264,000 $0 $0 $1,341,600 Source Data + Ready - + 139% XPO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum Calibri A- A Wrap Text Custom ND 49 3 Copy Fill Paste 1 Merge & Center $ - % Delete Format Insert Format 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 X fx Company Name A B D E F G H 1 J K L M 311 Smithfield Foods 312 Sonic Automotive 313 Southern 314 Southwest Airlines 315 Spectra Energy 316 Sprint Nextel 317 SPX 318 Staples 319 Starbucks 320 Starwood Hotels & Resorts 321 State Street 322 Stryker 323 Sunoco 324 Suntrust 325 Supervalu 326 Symantec 327 Synnex Consumer Goods Consumer Services Utilities Consumer Services Utilities Telecommunications Industrials Consumer Services Consumer Services Consumer Services Financials Health Care Oil & Gas Financials Consumer Services Technology Technology Consumer Services Technology Health Care Consumer Goods Industrials Oil & Gas Technology Industrials Health Care Consumer Services Consumer Services Industrials Consumer Services Consumer Services Pope, C. Larry Smith, O. Bruton Ratcliffe, David M. Kelly, Gary C. Fowler, Fred. Hesse, Daniel R. Kearney, Christopher J. Sargent, Ronald I. Schultz, Howard Van Paasschen, Frits Logue, Ronald E. MacMillan, Stephen P. Elsenhans, Lynn L. Wells III, James M. Noodle, Jeffrey Thompson, John W. Murai, Kevin 5 Schnieders, Richard J. Dutkowsky, Robert Fetter, Trevor Sherrill, Gregg M. DeFeo, Ronald M. Smith, Bruce A. Templeton, Richard K. Campbell, Lewis B. Dekkers, Marijn E. Bewkes, Jeffrey L. Britt, Glenn A. Griffith, James W. Meyrowitz, Carol O'Brien, Thomas M. $1,100,000 $1,100,000 $1,118,100 $441,100 $1,010,000 $1,200,000 $1,050,000 $1,112,000 $1,190,000 $1,000,000 $1,000,000 $1,200,000 $515,100 $1,077,300 $1,163,800 $800,000 $261,500 $1,146,500 $948,500 $1,081,000 $950,000 $1,150,000 $1,298,600 $960,800 $1,100,000 $1,163,800 $1,750,000 $1,000,000 $1,018,800 $1,503,400 $300,000 $0 $330,000 $1,682,900 $462,000 $1,184,100 $2,651,400 $2,730,000 $0 $0 $1,820,000 $0 $617,300 $794,000 $0 $0 $1,530,000 $900,000 $4,764,900 $727,300 $1,351,300 $0 328 Sysco $O 329 TECH DATA 330 Tenet Healthcare 331 Tenneco 332 Terex 333 Tesoro 334 Texas Instruments 335 Textron 336 Thermo Fisher Scientific 337 Time Warner 338 Time Warner Cable 339 Timken 340 Tjx Companies 341 TravelCenters of America $0 $1,564,900 $618,000 $1,865,600 $7,600,000 $4,975,000 $1,049,100 $1,095,800 $1,000,000 Source Data + - Ready + 139% XPO2_30 (1) Q- Search Sheet Home Page Layout Formulas Data Review View + Share Insert Cut Copy AutoSum Calibri 11 A- A Wrap Text Custom OM 49 Fill Paste T Merge & Center $ % Delete Format Format Insert 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 X fx Company Name B D E F G H J K L M A 342 Travelers 343 TRW Automotive Holdings 344 Tyson Foods 345 U.S. Bancorp 346 U.S. Steel 347 UAL 348 UGI 349 Union Pacific 350 UNISYS 351 United Technologies 352 UnitedHealth 353 Universal Health 354 Unum Group 355 UPS 356 URS 357 US Airways 358 Valero Energy 359 Verizon 360 VF 361 Viacom 362 Virgin Media 363 Visa 364 Visteon 365 Walgreen 366 Wal-Mart 367 Waste Management 368 Wellcare Health Plans 369 Wells Fargo 370 WESCO 371 Western Refining 372 Western Union Financials Consumer Goods Consumer Goods Financials Utilities Consumer Services Basic Materials Industrials Technology Industrials Health Care Health Care Financials Industrials Industrials Consumer Services Oil & Gas Telecommunications Consumer Goods Consumer Services Telecommunications Financials Consumer Goods Consumer Services Consumer Services Industrials Health Care Financials Industrials Oil & Gas Industrials noi Metal. Fishman, Jay S. Plant, John C. Bond, Richard L. Davis, Richard K. Surma, John P. Tilton, Glenn Greenberg, Lon R. Young, James R. Coleman, J. Edward Chenevert, Louis Hemsley, Stephen J. Miller, Alan B. Watjen, Thomas R. Davis, D. Scott Koffel, Martin M. Parker, W. Douglas Klesse, William R. Seidenberg, Ivan G. Wiseman, Eric C. Dauman, Philippe P. Berkett, Neil A. Saunders, Joseph W. Stebbins, Donald J. Rein, Jeffrey A. Scott, Jr., H. Lee Steiner, David P. Schiesser, Heath G. Stumpf, John G. Haley, Roy W. Foster, Paul L. Gold, Christina A. C.... nec $1,000,000 $1,673,300 $1,251,200 $900,000 $1,218,300 $850,000 $1,026,300 $1,141,700 $233,000 $1,319,000 $1,300,000 $1,350,100 $1,094,900 $960,000 $1,019,200 $550,000 $1,500,000 $2,100,000 $950,000 $2,500,000 $957,400 $950,000 $1,076,200 $1,200,000 $1,456,000 $1,066,000 $365,300 $878,900 $854,200 $726,800 $966,700 $5,000,000 $2,520,000 $0 $0 $3,250,000 $695,600 $964,700 $3,000,000 $303,800 $3,000,000 $1,218,800 $3,375,100 $2,268,800 $312,800 $2,500,000 $550,000 $705,500 $3,740,600 $760,000 $7,885,000 $1,077,900 $4,512,500 $207,000 $603,900 $5,824,000 $1,050,900 SO $0 $775,000 $592,400 $1,105,700 Ann Source Data + Ready + 140% XPO2_30 (1) Q Search Sheet Review View + Share AutoSum , Wrap Text Custom ND Home Insert Page Layout Formulas Data X Cut Calibri 11 A- A 3 Copy Paste BI U A Format A1 4 x vfx Company Name 49 H H Fill Merge & Center $ $ - % %) .00 0 Insert Delete Format .00 Conditional Format Cell Formatting as Table Styles Clear Sort & Filter A E F G H 1 J J K L M STE TTGICTTOOTT B TUUJIUN Basic Materials Consumer Goods Consumer Services Utilities Industrials Utilities Technology Oil & Gas Technology Consumer Services VOTU, CIPLITTU .. Fulton, Daniel S. Fettig, Jeff M. Mackey, John P. Malcolm, Steven J. Stebbins, Paul H. Kelly, Richard C. Mulcahy, Anne Hutton, Keith A. Yang, Jerry Novak, David C. D yooroo $792,400 $1,262,500 $0 $1,094,200 $575,000 $1,175,000 $1,320,000 $941,700 $0 $1,393,800 $0 $420,000 $0 $2,000,000 $3,543,800 $0 $990,000 $5,250,000 $0 $4,057,200 373 Weyerhaeuser 374 Whirlpool 375 Whole Foods Market 376 Williams 377 World Fuel Services 378 Xcel Energy 379 XEROX 380 XTO Energy 381 YAHOO 382 Yum Brands 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 Source Data + Ready + 140% DO 5 BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Q Search in Document Home Insert Design Layout References Mailings Review View 9+ Share Times New Ro... 10 - A A A EEEE AH T AaBbCcDdEe AaBbCcDdE AaBbCcDdEe Normal Body Text List Paragraph code No Spacing AaBbCebdec AaBbCcDd AaBbccdde AaBb Paste BIU abe X2 X2 A Table Paragr... Heading 1 1 Heading 2 Title Styles Pane a) The average of Salary 2008 and average of Bonus 2008, broken down by company type Excel output (Pivot table, average value=Salary 2008, Bonus 2008 row=companytype) Row Labels Basic Materials Consumer Goods Consumer Services Financials Health Care Industrials Oil & Gas Technology Telecommunications Sum of Salary 2008 21873800 53667100 91884400 45210000 34638600 76892700 31278100 22117800 6878200 35190300 419631000 Sum of Bonus 2008 30276100 74540700 132143300 71926700 57559000 105850100 50003700 37247200 9719900 41685600 610952300 Utilitie. Plot Area Grand Total Pivot chart (Graph) 140000000 120000000 100000000 80000000 . 60000000 Sum of Salary 2008 40000000 Sum of Bonus 2008 20000000 0 Page 7 of 10 1473 Words IX English Focus + 126% DO 5 BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Q Search in Document Home Insert Design Layout References Mailings Review View 9+ Share Times New Ro... 10 - A A A AU T AaBbCcDdEe AaBbCcDdE AaBbCeDdEe AaBbCcDdEe AaBbCebdec AaBbCcDd AaBbccdde AaBb Paste BIU abe X2 X2 A Normal Body Text List Paragraph No Spacing Table Paragr... Heading 1 1 Heading 2 Title Styles Pane 140000000 120000000 100000000 80000000 60000000 Sum of Salary 2008 40000000 Sum of Bonus 2008 20000000 0 Basic Materials Consumer Goods Financials Health Care Consumer Services Industrials Oil & Gas Utilities Technology Telecommunications Page 6 of 9 BUSAN 200 Assignment 1 MDEV464 The graph shows that technology field earns the Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. Page 7 of 10 1473 Words IX English O Focus + 126% DO 5 BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Q Search in Document Home Insert Design Layout References Mailings Review View 9+ Share Times New Ro... 10 - A A A AU T AaBbCcDdEe AaBbCcDdE AaBbCeDdEe AaBbCcDdEe AaBbCebdec AaBbCcDd AaBbccdde AaBb Paste BIU abe X2 X2 A Normal Body Text List Paragraph No Spacing Table Paragr... Heading 1 1 Heading 2 Title Styles Pane 140000000 120000000 100000000 80000000 60000000 Sum of Salary 2008 40000000 Sum of Bonus 2008 20000000 0 Basic Materials Consumer Goods Financials Health Care Consumer Services Industrials Oil & Gas Utilities Technology Telecommunications Page 6 of 9 BUSAN 200 Assignment 1 MDEV464 The graph shows that technology field earns the Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. Page 7 of 10 1473 Words IX English O Focus + 126% DO 5 BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Q Search in Document Home Insert Design Layout References Mailings Review View 9+ Share Times New Ro... 10 - A A A AU T AaBbCcDdEe AaBbCcDdE AaBbCeDdEe AaBbCcDdEe AaBbCebdec AaBbCcDd AaBbccdde AaBb Paste BIU abe X2 X2 A Normal Body Text List Paragraph No Spacing Table Paragr... Heading 1 1 Heading 2 Title Styles Pane 140000000 120000000 100000000 80000000 60000000 Sum of Salary 2008 40000000 Sum of Bonus 2008 20000000 0 Basic Materials Consumer Goods Financials Health Care Consumer Services Industrials Oil & Gas Utilities Technology Telecommunications Page 6 of 9 BUSAN 200 Assignment 1 MDEV464 The graph shows that technology field earns the Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. Page 7 of 10 1473 Words IX English O Focus + 126% DO 5 BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Qu Search in Document Home Insert Design Layout References Mailings Review View 9+ Share Times New Ro... 10 - A A A A EE A AaBbcDdEe AaBbCcDdEe AaBbCcDdE AaBbCcDdEe Normal Body Text List Paragraph AaBbCebdec AaBbCcDd AaBbceDde AaBb Paste BIU abe X2 X2 A = No Spacing Table Paragr... Heading 1 1 Heading 2 Title Styles Pane The graph shows that companies in Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desk publishing software like Aldus PageMaker including versions of Lorem Ipsum Excel output (Pivot table, value = executive name, row=company type) Sum of Salary Sum of Bonus Row Labels 2008 2008 Basic Materials 21873800 30276100 Consumer Goods 53667100 74540700 Consumer Services 91884400 132143300 Financials 45210000 71926700 Health Care 34638600 57559000 Industrials 76892700 105850100 Oil & Gas 31278100 50003700 Technology 22117800 37247200 Telecommunications 6878200 9719900 Utilities 35190300 41685600 Grand Total 419631000 610952300 Pivot graph 140000000 120000000 100000000 80000000 60000000 Sum of Salary 2008 40000000 Sum of Bonus 2008 20000000 0 ou Page 9 of 10 1473 Words IX English E 18 O Focus + 126% DO 5 BUSAN_200_2021_S1_Assignment 1 (1) [Compatibility Mode] Q Search in Document Home Insert Design Layout References Mailings Review View 9+ Share Times New Ro... 10 - A A A E 3 AH T AaBbcDdEe AaBbCcDdEe AaBbCcDdE AaBbCcDdEe Normal Body Text List Paragraph AaBbCebdec AaBbCcDd AaBbccdde AaBb Paste BIU abe X2 X2 A No Spacing Table Paragr... Heading 1 1 Heading 2 Title Styles Pane Pivot graph 140000000 120000000 100000000 80000000 60000000 Sum of Salary 2008 40000000 Sum of Bonus 2008 20000000 0 Basic Materials Consumer Goods Utilities Financials Health Care Consumer Services Industrials Oil & Gas Technology Telecommunications Page 8 of 9 BUSAN 200 Assignment 1 MDEV464 The graph shows that the average of total in Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum Page 9 of 10 1473 Words IX English O Focus + 126% PO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum , Calibri A- A Wrap Text General ND 49 Copy Fill Paste I Merge & Center $ % Delete Format Format Insert 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 x fx Company Name B D E F H 1 J L M 1 Company Name 2 3M 3 Abbott Labs 4 Advance Auto Parts 5 Advanced Micro Devices 6 Aecom Technology 7 AES 8 Affiliated Computer 9 Aflac 10 AGCO 11 Agilent Technologies 12 AIG 13 Air Products 14 Alcoa 15 Allegheny Technologies 16 Allstate 17 Alon USA Energy 18 Altria Group 19 Amazon.com 20 Ameren 21 American Electric Power 22 American Express 23 Ameriprise Financial 24 AmerisourceBergen 25 Amgen 26 AMR 27 Anadarko Petroleum 28 Anixter International 29 Aon 30 Apache 31 Apple Computer Company Type Industrials Health Care Consumer Services Technology Industrials Utilities Industrials Financials Industrials Industrials Financials Basic Materials Basic Materials Basic Materials Financials Oil & Gas Consumer Goods Consumer Services Utilities Utilities Financials Financials Consumer Services Health Care Consumer Services Oil & Gas Industrials Financials Oil & Gas Technology Executive_Name Buckley, George W. White, Miles D. Jackson, Darren R. Meyer, Derrick R. Dionisio, John M. Hanrahan, Paul Blodgett, Lynn Amos, Daniel P. Richenhagen, Martin H. Sullivan, William P. Liddy, Edward M. Jones, John P. Kleinfeld, Klaus Hassey, L. Patrick Wilson II, Thomas J. Morris, Jeff D. Szymanczyk, Michael E. Bezos, Jeffrey P. Rainwater, Gary L. Morris, Michael G. Chenault, Kenneth I. Cracchiolo, James M. Yost, R. David Sharer, Kevin W. Arpey, Gerard J. Hackett, James T. Eck, Robert J. Case, Gregory C. Farris, G. Steven Jobs, Steven P. Salary 2008 $1,720,000 $1,795,500 $800,000 $856,700 $956,500 $999,000 $750,000 $1,338,200 $1,024,800 $986,700 $0 $1,000,000 $1,400,000 $907,900 $1,040,800 $307,200 $1,200,000 $81,800 $935,000 $1,259,600 $1,250,000 $850,000 $1,182,100 $1,561,900 $666,300 $1,510,400 $549,600 $1,500,000 $1,493,800 $0 Bonus 2008 $2,644,100 $4,200,000 $1,959,900 $0 $2,000,000 $1,756,200 $725,600 $0 $1,124,400 $1,305,600 $0 $2,002,000 $1,884,000 $2,149,900 $151,700 $0 $2,800,000 $0 $771,700 $1,654,100 $0 SO $1,369,500 $3,875,000 $200 $3,416,500 $218,800 $1,772,000 $500,000 $0 Source Data + Ready + 139% PO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum , Calibri A- A Wrap Text General ND 49 Fill Paste Copy Format I Merge & Center $ - % Delete Format 0 Conditional Format Formatting as Table Insert Cell Styles Clear Sort & Filter A1 fx Company Name B D E F H 1 J M 32 Applied Materials 33 Arrow Electronics 34 Arvin Meritor 35 Ashland 36 Assurant 37 AT&T 38 Atmos Energy 39 AutoNation 40 AutoZone 41 Avery Dennison 42 Avis Budget Group 43 Avon 44 Baker Hughes 45 Ball 46 Bank of America 47 Bank of New York Mellon 48 Barnes & Noble 49 Baxter 50 BB&T 51 Becton Dickinson 52 Bed Bath & Beyond 53 Berkshire Hathaway 54 Best Buy 55 BJ Services 56 BJ's Wholesale Club 57 Black & Decker 58 Blackrock 59 Blockbuster 60 Boeing 61 BorgWarner 62 Boston Scientific Source Data Technology Industrials Consumer Goods Basic Materials Financials Telecommunications Utilities Consumer Services Consumer Services Basic Materials Consumer Services Consumer Goods Oil & Gas Industrials Financials Financials Consumer Services Health Care Financials Health Care Consumer Services Financials Consumer Services Oil & Gas Consumer Services Consumer Goods Financials Consumer Services Industrials Consumer Goods Health Care Splinter, Michael R. Mitchell, William E. McClure Jr., Charles G. O'Brien, James J. Pollock, Robert B. Stephenson, Randall L. Best, Robert W. Jackson, Mike Rhodes III, William C. Scarborough, Dean A. Nelson, Ronald L. Jung, Andrea Deaton, Chad C. Hoover, R. David Lewis, Kenneth D. Kelly, Robert P. Riggio, Stephen Parkinson Jr., Robert L. Allison IV, John A. Ludwig, Edward .. Temares, Steven H. Buffett, Warren E. Anderson, Bradbury H. Stewart, J.W. Zarkin, Herbert J. Archibald, Nolan D. Fink, Laurence D. Keyes, James W. McNerney Jr., W. James Manganello, Timothy M. Tobin, James R. $929,400 $1,100,000 $1,120,800 $1,110,900 $950,000 $1,420,800 $820,400 $1,150,000 $706,000 $945,000 $1,000,000 $1,375,000 $1,155,000 $1,100,000 $1,500,000 $993,800 $800,000 $1,339,300 $993,700 $1,059,800 $1,468,300 $100,000 $1,247,300 $1,141,700 $975,000 $1,500,000 $650,000 $975,000 $1,598,500 $445,400 $1,638,800 $0 $835,200 $0 $779,400 $220,000 $0 $1,689,400 $1,296,200 $922,800 $0 $0 $1,961,500 $2,708,900 $0 $1,526,200 $0 $0 $0 $575,000 $0 $1,875,000 $17,149,500 $402,500 $1,476,500 $0 $885,700 $500,000 $750,000 $1,915,300 $1,100,000 $989,600 + Ready 0 - + 139% PO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum Calibri A- A Wrap Text General ND 49 3 Copy Fill Paste 1 Merge & Center $ % Delete Format Format Insert 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 fx Company Name D E F H 1 j L M Health Care 63 Bristol-Myers Squibb 64 Burlington Northern 65 CH Robinson 66 Calpine 67 Cameron International 68 Campbell Soup 69 Capital One Financial 70 Carmax 71 Caterpillar 72 CB Richard Ellis Group 73 CBS 74 CC Media Holdings 75 Celanese 76 CenterPoint Energy 77 Chevron 78 Chubb 79 Cigna 80 CIT Group 81 Citigroup 82 Clorox 83 CMS Energy 84 CNA Financial 85 Coca-Cola Co. 86 Coca-Cola Enterprises 87 Colgate-Palmolive 88 Comcast 89 Commercial Metals 90 Community Health Systems 91 Computer Sciences 92 Con Edison 93 Conagra Foods Industrials Industrials Utilities Oil & Gas Consumer Goods Financials Consumer Services Industrials Financials Consumer Services Financials Basic Materials Utilities Oil & Gas Financials Health Care Financials Financials Consumer Goods Utilities Financials Consumer Goods Consumer Goods Consumer Goods Consumer Services Basic Materials Health Care Technology Utilities Consumer Goods Cornelius, James M. Rose, Matthew K. Wiehoff, John P. Fusco, Jack A. Moore, Jack B. Conant, Douglas R. Fairbank, Richard D. Folliard, Thomas). Owens, James W. White, Brett Moonves, Leslie Mays, Mark P. Weidman, David N. McClanahan, David M. O'Reilly, David J. Finnegan, John D. Hanway, H. Edward Peek, Jeffrey M. Pandit, Vikram S. Knauss, Donald R. Joos, David W. Lillienthal, Stephen W. Kent, Muhtar Brock, John F. Cook, lan M. Roberts, Brian L. McClean, Murray R. Smith, Wayne T. Laphen, Michael W. Burke, Kevin Rodkin, Gary $1,488,100 $1,183,600 $400,000 $396,200 $745,400 $1,177,500 $0 $846,200 $1,550,000 $850,000 $3,513,500 $895,000 $900,000 $1,052,500 $1,650,000 $1,275,000 $1,142,900 $800,000 $958,300 $987,500 $1,045,000 $950,000 $1,100,000 $1,144,000 $1,075,000 $2,769,400 $600,000 $1,080,000 $1,057,700 $1,102,500 $1,019,200 $4,475,000 $1,679,500 $1,314,200 $896,200 $903,000 $1,866,400 $0 $0 $1,853,200 $0 $11,000,000 $4,500,000 $755,700 $1,578,800 $4,161,000 $3,357,800 $0 $0 $0 $1,380,000 $971,900 $2,900,000 $4,500,000 $147,300 $3,162,500 $7,394,200 $1,911,200 $2,071,400 $2,142,400 $1,066,100 $1,100,000 Source Data + Ready + 139% PO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum Calibri 11 A- A Wrap Text General ND 49 Copy Fill Paste T Merge & Center $ - % Delete Format Insert Format 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 fx Company Name F H 1 J L M A 94 ConocoPhillips 95 Constellation Energy 96 Continental Airlines 97 Con-Way Inc 98 Corning 99 Costco 100 Coventry Health Care 101 Crown Holdings 102 CSX 103 Cummins 104 CVR Energy 105 CVS Caremark 106 Dana Holding 107 Danaher 108 Davita 109 Dean Foods 110 Deere 111 Dell 112 Devon Energy 113 Dillards 114 DirecTV Group 115 Discover Financial 116 Dish Network 117 Disney (Walt) 118 Dominion Resources 119 Donnelley (RR) & Sons 120 Dover 121 Dow Chemical 122 Dr Pepper Snapple Group 123 DTE Energy 124 Du Pont B Oil & Gas Utilities Consumer Services Industrials Technology Consumer Services Health Care Industrials Industrials Industrials Oil & Gas Consumer Services Consumer Goods Industrials Health Care Consumer Goods Industrials Technology Oil & Gas Consumer Services Consumer Services Financials Consumer Services Consumer Services Utilities Industrials Industrials Basic Materials Consumer Goods Utilities Basic Materials Mulva, James J. Shattuck III, Mayo A. Kellner, Lawrence W. Stotlar, Douglas W. Weeks, Wendell P. Sinegal, James D. Wolf, Dale B. Conway, John W. Ward, Michael J. Solso, Theodore M. Lipinski, John J. Ryan, Thomas M. Convis, Gary L. Culp Jr., H. Lawrence Thiry, Kent J. Engles, Gregg L. Lane, Robert W. Dell, Michael S. Nichols, J. Larry Dillard, II, William Carey, Chase Nelms, David W. Ergen, Charles W. Iger, Robert A. Farrell II, Thomas F. Quinlan, Thomas J. Livingston, Robert A. Liveris, Andrew Young, Larry D. Earley Jr., Anthony F. Holliday Jr., Charles O. D $1,500,000 $1,290,400 $296,900 $700,400 $1,030,000 $350,000 $965,000 $1,075,000 $1,058,300 $1,210,000 $700,000 $1,400,000 $850,000 $1,100,000 $1,023,100 $1,300,000 $1,435,500 $931,700 $1,400,000 $810,000 $2,291,600 $1,000,000 $600,000 $2,000,000 $1,191,700 $985,600 $767,500 $1,641,700 $867,300 $1,186,500 $1,369,500 E $1,417,500 $0 $0 $245,500 $301,600 $80,000 $0 $3,560,400 $2,032,000 $1,064,800 $1,700,000 $2,350,000 $1,515,400 $3,267,300 $2,000,000 $2,350,900 $3,588,900 $0 $3,000,600 $196,300 $3,500,000 $4,750,000 $0 $13,945,500 $2,355,000 $0 $1,000,000 $0 $1,643,200 $1,500,000 $1,732,000 Source Data + - Ready + 139% PO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum Calibri 11 A- A Wrap Text General ND 49 Copy Fill Paste T Merge & Center $ - % Delete Format Format Insert 0 .00 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 X fx Company Name B D E F H 1 J L M 125 Duke Energy 126 Eastman Chemical 127 Eastman Kodak 128 Eaton 129 Ebay 130 Ecolab 131 Edison International 132 El Paso 133 EMC 134 Emcor Group 135 Emerson Electric 136 Entergy 137 EOG Resources 138 Estee Lauder 139 Exelon 140 Expeditors International 141 Express Scripts 142 Exxon Mobil 143 Family Dollar 144 Federal-Mogul 145 Fifth Third Bancorp 146 Firstenergy 147 Fluor 148 Foot Locker 149 Ford Motor 150 Fortune Brands 151 FPL Group 152 Franklin Resources 153 Frontier Oil 154 Gamestop 155 Gannett Utilities Basic Materials Consumer Goods Industrials Consumer Services Basic Materials Utilities Oil & Gas Technology Industrials Industrials Utilities Oil & Gas Consumer Goods Utilities Industrials Health Care Oil & Gas Consumer Services Consumer Goods Financials Utilities Industrials Consumer Services Consumer Goods Industrials Utilities Financials Oil & Gas Consumer Services Consumer Services Rogers, James E. Ferguson, J. Brian Perez, Antonio M. Cutler, Alexander M. Donahoe, John J.5 Baker Jr., Douglas M. Craver Jr., Theodore F. Foshee, Douglas L. Tucci, Joseph M. MacInnis, Frank T. Farr, David N. Leonard, J. Wanye Papa, Mark G. Lauder, William P. Rowe, John W. Rose, Peter J. Paz, George Tillerson, Rex W. Levine, Howard R. Maria Alapont, Jose Kabat, Kevin T. Alexander, Anthony J. Boeckmann, Alan L. Serra, Matthew D. Mulally, Alan Carbonari, Bruce A. Hay, III, Lewis Johnson, Gregory E. Gibbs, James R. DeMatteo, Daniel A. Dubow, Craig A. $0 $1,131,200 $1,096,200 $1,132,500 $879,800 $1,000,000 $892,500 $1,037,500 $1,000,000 $950,000 $1,200,000 $1,273,500 $940,000 $1,500,000 $1,474,400 $110,000 $941,800 $1,870,000 $878,500 $1,500,000 $900,000 $1,329,400 $1,232,300 $1,500,000 $2,000,000 $1,100,000 $1,255,800 $780,100 $975,000 $1,035,400 $1,166,700 $0 $925,000 $0 $320,000 $500,000 $1,397,000 $1,050,000 $1,186,400 $1,388,600 $2,585,000 $3,000,000 $2,169,700 $2,000,000 $3,074,500 $1,835,200 $5,815,800 $2,450,500 $4,000,000 $533,200 $3,075,000 $0 $2,305,400 $3,073,200 $1,728,300 So $0 $2,400,000 $4,500,000 $780,000 $2,400,000 $875,000 Source Data + Ready - + 139% PO2_30 (1) Q Search Sheet Home Page Layout Formulas Data Review View + Share Insert Cut Copy AutoSum , Calibri A4 A Wrap Text General ND 49 Fill Paste I Merge & Center $ % Delete Format Insert 0 Format Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 fx Company Name B E F G H 1 j L M 156 Gap 157 General Cable 158 General Dynamics 159 General Electric 160 General Mills 161 Genuine Parts 162 Genworth Financial 163 Gilead Sciences 164 Goldman Sachs Group 165 Goodrich 166 Goodyear 167 Google 168 Grainger (W.W.) 169 Great Atlantic & Pacific Tea 170 Group 1 Automotive 171 Halliburton 172 Harley-Davidson 173 Hartford Financial Services 174 Health Net 175 Heinz (HJ) 176 Hershey 177 Hertz Global Holdings 178 Hess 179 Hewlett-Packard 180 Holly Corp 181 Home Depot 182 Honeywell International 183 Hormel Foods 184 Horton (D.R.) 185 Host Hotels & Resorts 186 Humana 107 ID Source Data Consumer Services Industrials Industrials Industrials Consumer Goods Consumer Goods Financials Health Care Financials Industrials Consumer Goods Technology Industrials Consumer Services Consumer Services Oil & Gas Consumer Goods Financials Health Care Consumer Goods Consumer Goods Consumer Services Oil & Gas Technology Oil & Gas Consumer Services Industrials Consumer Goods Consumer Goods Financials Health Care Technolo Murphy, Glenn K. Kenny, Gregory B. Chabraja, Nicholas D. Immelt, Jeffery R. Powell, Kendall J. Gallagher, Thomas C. Fraizer, Michael D. Martin, John C. Blankfein, Lloyd C. Larsen, Marshall Keegan, Robert J. Schmidt, Eric Ryan, James T. Claus, Eric Hesterberg, Earl J. Lesar, David J. Ziemer, James L. Ayer, Ramani Gellert, Jay M. Johnson, William R. West, David J. Frissora, Mark P. Hess, John B. Hurd, Mark V. Clifton, Matthew P. Blake, Francis S. Cote, David M. Ettinger, Jeffrey M. Tomnitz, Donald J. Walter, W. Edward McCallister, Michael B. D $1,500,000 $823,300 $1,375,000 $3,300,000 $959,600 $875,000 $1,121,400 $1,146,300 $600,000 $1,100,000 $1,216,700 $0 $787,500 $800,000 $1,000,000 $1,300,000 $980,700 $1,150,000 $1,204,600 $1,245,200 $1,000,000 $1,094,700 $1,500,000 $1,450,000 $849,800 $1,013,500 $1,826,000 $912,100 $300,000 $750,000 $1,017,300 01 Onn non $3,016,400 $844,000 $4,500,000 $0 $2,638,800 $866,700 $0 $1,651,700 $0 $2,173,600 $0 $0 $631,100 $432,000 $200,000 $3,120,000 $450,300 $0 $0 $3,650,000 $1,128,400 $600,900 $3,500,000 $10,243,700 $608,000 $0 $3,500,000 $1,343,700 $1,848,500 $467,600 $0 cc con onn + - Ready + 139% PO2_30 (1) Q Search Sheet Home Page Layout Formulas Data Review View + Share Insert Cut Copy AutoSum , Calibri A- A Wrap Text General ND 49 Fill Paste I Merge & Center $ - % Delete Format Format Insert 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 X fx Company Name B D E F H 1 J M 187 IBM 188 Illinois Tool Works 189 Ingram Micro 190 Integrys Energy Group 191 Intel 192 International Assets Holding 193 International Paper 194 Interpublic Group of Companies 195 ITT 196 Jabil Circuit 197 Jacobs Engineering 198 JCPenney 199 Johnson & Johnson 200 Johnson Controls 201 JPMorgan Chase 202 KBR 203 Kellogg 204 Kelly Services 205 KeyCorp 206 Kimberly-Clark 207 Kohl's 208 Kraft Foods 209 Kroger 210 L-3 Communications 211 Lear 212 Liberty Global 213 Liberty Media 214 Lilly (Eli) 215 Lincoln National 216 Lockheed Martin 217 Loews Technology Industrials Technology Utilities Technology Financials Basic Materials Consumer Services Industrials Industrials Industrials Consumer Services Health Care Consumer Goods Financials Industrials Consumer Goods Industrials Financials Consumer Goods Consumer Services Consumer Goods Consumer Services Industrials Consumer Goods Consumer Services Consumer Services Health Care Financials Industrials Financials Palmisano, Samuel J. Speer, David B. Spierkel, Gregory M.E. Weyers, Larry L. Otellini, Paul S. O'Connor, Sean M. V Faraci, John Roth, Michael I. Loranger, Steven R. Main, Timothy L. Martin, Craig L. Ullman III, Myron E. Weldon, William C. Roell, Stephen A. Dimon, James Utt, William P. Mackay, David Camden, Carl T. Meyer III, Henry L. Falk, Thomas J. Mansell, Kevin Rosenfeld, Irene Dillon, David B. Strianese, Michael T. Rossiter, Robert E. Fries, Michael T. Maffei, Gregory B. Lechleiter, John C. Glass, Dennis R. Stevens, Robert J. Tisch, James S. $1,800,000 $1,099,600 $850,000 $1,050,000 $1,000,000 $175,000 $1,261,400 $1,332,500 $1,119,600 $1,000,000 $1,084,600 $1,500,000 $1,792,000 $1,325,000 $1,000,000 $900,000 $1,136,500 $917,500 $1,019,500 $1,225,000 $1,067,500 $1,452,200 $1,204,800 $1,145,400 $1,237,000 $957,000 $1,000,000 $1,339,100 $1,000,000 $1,774,000 $1,100,000 $5,500,000 $1,586,200 $0 $684,100 $3,873,300 $750,000 $1,575,000 $2,500,000 $2,534,000 $155,900 $1,301,700 $1,406,300 $3,700,000 $3,492,600 $0 $1,100,000 $2,601,300 $0 $O $943,200 $0 $4,070,000 $1,574,200 $2,750,000 $0 $1,600,000 $5,464,000 $2,709,100 $800,000 $4,250,000 $2,500,000 Source Data + Ready - + 139% PO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum Calibri A- A Wrap Text General ND 49 Copy Fill Paste I Merge & Center $ - % Delete Format Format Insert 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 fx Company Name A B D E F H 1 j L M Consumer Services Basic Materials Consumer Services Industrials Oil & Gas Consumer Services Financials Industrials Consumer Goods Consumer Services Consumer Services Industrials Industrials Health Care Health Care 218 Lowe's 219 Lubrizol 220 Macy's 221 Manpower 222 Marathon Oil 223 Marriott International 224 Marsh & McLennan 225 Masco 226 Mattel 227 McDonald's 228 McGraw-Hill 229 MDU Resources 230 MeadWestvaco 231 Medco Health Solutions 232 Merck 233 MetLife 234 MGM Mirage 235 Micron Technology 236 Mohawk Industries 237 Monsanto 238 Morgan Stanley 239 Motorola 240 Motorola 241 Murphy Oil 242 National Oilwell Varco 243 Navistar International 244 NCR 245 Newell Rubbermaid 246 Newmont Mining 247 News Corp. 248 Nisource Financials Consumer Services Technology Consumer Goods Basic Materials Financials Technology Technology Oil & Gas Oil & Gas Industrials Technology Consumer Goods Basic Materials Consumer Services Utilities Niblock, Robert A. Hambrick, James L. Lundgren, Terry J. Joerres, Jeffrey A. Cazalot Jr., Clarence P. Marriott, Jr., J. Willard Duperreault, Brian Wadhams, Timothy Eckert, Robert A. Skinner, James A. McGraw III, Harold Hildestad, Terry D. Luke Jr., John A. Snow Jr., David B. Clark, Richard T. Henrikson, C. Robert Murren, James J. Appleton, Steven R. Lorberbaum, Jeffrey S. Grant, Hugh Mack, John J. Brown, Gregory Q. Jha, Dr. Sanjay K. Deming, Claiborne P. Miller Jr., Merrill A. Ustian, Daniel C. Nuti, William Ketchum, Mark D. O'Brien, Richard T. Murdoch, K. Rupert Skaggs, Jr., Robert C. $1,100,000 $933,500 $1,500,000 $1,000,000 $1,381,300 $1,253,700 $927,100 $934,600 $1,250,000 $1,337,500 $1,350,000 $700,000 $1,055,900 $1,281,500 $1,783,300 $1,000,000 $1,500,000 $950,000 $980,000 $1,286,000 $800,000 $1,200,000 $484,600 $1,241,700 $950,000 $1,170,800 $1,000,000 $1,291,700 $1,000,000 $8,100,000 $791,700 $1,500,800 $800,000 $900,000 $300,000 $1,700,000 $904,700 $3,000,000 $0 $0 $4,600,000 $0 $310,800 $0 $3,000,000 $2,244,500 $3,250,000 $0 $0 $300,000 $3,326,800 $0 $0 $0 $2,000,000 $1,826,000 $2,589,500 $1,375,000 SO $1,894,400 $5,435,000 $0 Source Data + Ready + 139% PO2_30 (1) Q Search Sheet Home Page Layout Formulas Data Review View + Share Insert Cut 3 Copy AutoSum Calibri A- A Wrap Text General ND 49 Fill Paste 1 Merge & Center $ % Delete Format Insert Format .00 0 Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 fx Company Name B D E F H 1 j L M 249 Nordstrom 250 Norfolk Southern 251 Northeast Utilities 252 Northern Trust 253 Northrop Grumman 254 Nucor 255 Occidental 256 Office Depot 257 Office Max 258 Omnicare 259 Omnicom 260 Oneok 261 Oshkosh 262 Owens & Minor 263 Owens-Illinois 264 Paccar 265 Pantry 266 Penske Automotive 267 Pepco Holdings 268 Pepsi Bottling Group 269 PepsiCo 270 Pfizer 271 PG 272 Philip Morris 273 Pitney Bowes 274 PNC Financial 275 PPG Industries 276 PPL 277 Praxair 278 Precision Castparts 279 Principal Financial Consumer Services Industrials Utilities Financials Industrials Basic Materials Oil & Gas Consumer Services Consumer Services Consumer Services Consumer Services Utilities Industrials Health Care Industrials Industrials Consumer Services Consumer Services Utilities Consumer Goods Consumer Goods Health Care Utilities Consumer Goods Technology Financials Basic Materials Utilities Basic Materials Industrials Financials Nordstrom, Blake W. Moorman IV, Charles W. Shivery, Charles W. Waddell, Frederick H. Sugar, Ronald D. Di Micco, Daniel R. Irani, Ray R. Odland, Steve Duncan, Sam K. Gemunder, Joel F. Wren, John D. Gibson, John W. Bohn, Robert G. Smith, Craig R. Stroucken, Albert P.L. Pigott, Mark C. Sodini, Peter J. Penske, Roger S. Wraase, Dennis R. Foss, Eric J. Nooyi, Indra K. Kindler, Jeffrey B. Darbee, Peter A. Camilleri, Louis C. Martin, Murray D. Rohr, James E. Bunch, Charles E. Miller, James H. Angel, Stephen F. Donegan, Mark Zimpleman, Larry D. $696,100 $950,000 $1,067,400 $856,300 $1,525,000 $800,000 $1,300,000 $1,000,000 $1,022,600 $1,816,700 $1,000,000 $825,000 $1,150,000 $788,100 $1,011,500 $1,348,800 $800,000 $1,000,000 $1,076,000 $984,600 $1,300,000 $1,575,000 $1,090,800 $1,567,300 $941,700 $1,000,000 $1,041,700 $1,141,100 $1,026,300 $1,275,000 $737,500 $0 $1,759,400 $1,519,100 $0 $2,775,500 $2,160,000 $3,630,000 $0 $0 $5,125,000 $1,750,000 $853,000 $178,000 $1,080,000 $559,900 $0 $352,600 $0 $968,400 $840,000 $2,600,000 $5,250,000 $1,285,000 $9,450,000 $1,378,000 $3,000,000 $1,750,000 $0 $2,500,000 $1,689,400 $0 Source Data + Ready + 139% XPO2_30 (1) Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut AutoSum Calibri 11 A- A Wrap Text Custom ND 49 Fill Paste Copy Format I Merge & Center $ - % Delete Format 0 Conditional Format Formatting as Table Insert Cell Styles Clear Sort & Filter A1 fx Company Name D E F H 1 J L M 280 Progress Energy 281 Progressive 282 Prologis 283 Prudential Financial 284 PSEG 285 Publix Super Markets 286 Pulte Homes 287 Qualcomm 288 Quest Diagnostics 289 Qwest 290 Raytheon 291 Regions Financial 292 Reliance Steel & Aluminum 293 Reynolds American 294 Rite Aid 295 Rockwell Automation 296 Ross Stores 297 RRI Energy 298 Ryder System 299 Safeway 300 SAIC 301 Sanmina-SCI 302 Scana 303 Schering-Plough 304 Schwab (Charles) 305 Sears 306 Sempra Energy 307 Shaw Group 308 Sherwin-Williams 309 SLM Corp 310 Smith International Utilities Financials Financials Financials Utilities Consumer Services Consumer