pa 8. lo 9.4the following revenue data were taken from the december 31, 2017, coca-cola annual report (10-k):chart showing 2017 (in millions) for europe, middle east, africa; latin america; north america; asia pacific; and bottle investments; respectively: outside sales, $7,332, $3,956, $8,651, $4,767, $10,524; intersegment sales, $42, $73, $1,986, $409, $81; total sales, $7,374, $4,029, $10,637, $5,176, $10,605. chart showing 2016 (in millions) for europe, middle east, africa; latin america; north america; asia pacific; and bottle investments, respectively: outside sales, $7,014 , $3,746, $6,437, $4,788, $19,751; intersegment sales, $264, $73, $3,773, $506, $134; total sales, $7,278, $3,819, $10,210, $5,294, $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?