PA8. LO 9.4 The following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): Europe, Middle East, Africa Bottle Investments Asia North America Latin America 2017 Pacific (in millions) Outside sales $4,767 409 $10,524 $ 8,651 1,986 $10,637 $3,956 $7,332 81 73 Intersegment sales Total sales 42 $10,605 $4,029 $5,176 $7,374 Europe, Middle East, Africa Asia. Pacific Bottle North America 6,437 Latin 2016 Investments America (in millions) $19,751 $4,788 $3,746 $7,014 Outside sales 134 506 3,773 $10,210 73 Intersegment sales Total sales 264 $19,885 $5,294 $3,819 $7,278 For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales. Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data