The Coca-Cola Company is organized geographically and defines reportable operating segme...

The Coca-Cola Company is organized geographically and defines reportable operating segments as regions of the world. The following information was extracted from Note 19 Operating Segments in the Coca-Cola Company 2011 Annual Report:

Required

1. Use an electronic spreadsheet to calculate the following measures for each of Coca-Cola’s operating segments (excluding Bottling Investments and Corporate):

Percentage of total net revenues, 2010 and 2011.

Percentage change in total net revenues, 2009 to 2010 and 2010 to 2011.

Operating income as a percentage of total net revenues (profit margin), 2010 and 2011.

2. Determine whether you believe Coca-Cola should attempt to expand its operations in a particular region of the world to increase operating revenues and operating income.

3. List any additional information you would like to have to conduct your analysis.