Please show detailed work.

The following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): 2017 (in millions) Outside sales Intersegment sales Total sales Europe, Middle East, Africa $7,332 42 $7,374 Latin America $3,956 73 $4,029 North America $ 8,651 1,986 $10,637 Asia Pacific $4,767 409 $5,176 Bottle Investments $10,524 81 $10,605 2016 (in millions) Outside sales Intersegment sales Total sales Europe, Middle East, Africa $7,014 264 $7,278 Latin America $3,746 73 $3,819 North America $ 6,437 3,773 $10,210 Asia Pacific $4,788 506 $5,294 Bottle Investments $19,751 134 $19,885 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? The following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): 2017 (in millions) Outside sales Intersegment sales Total sales Europe, Middle East, Africa $7,332 42 $7,374 Latin America $3,956 73 $4,029 North America $ 8,651 1,986 $10,637 Asia Pacific $4,767 409 $5,176 Bottle Investments $10,524 81 $10,605 2016 (in millions) Outside sales Intersegment sales Total sales Europe, Middle East, Africa $7,014 264 $7,278 Latin America $3,746 73 $3,819 North America $ 6,437 3,773 $10,210 Asia Pacific $4,788 506 $5,294 Bottle Investments $19,751 134 $19,885 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