The following revenue data were taken from the December 31, 2017, General Electric annual report (10-K):

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?

Transcribed Image Text:

2017 (in millions) Renewable Power Energy Outside sales $34,598 $10,211 Intersegment sales Total sales 2016 (in millions) 1,392 69 $35,990 $10,280 Power Outside sales $35,465 Intersegment sales Total sales 1,330 $36,795 Renewable Energy $9,022 11 $9,033 Oil & Gas Aviation $16,584 $26,790 646 585 $17,230 $27,375 Oil & Gas $12,515 383 $12,898 Aviation $25,530 730 $26,260 Health- Transport- ation $4,168 care $19,098 18 $19,116 Health- care $18,276 15 $18,291 10 $4,178 Transport- ation $4,713 1 $4,714 Lighting $1,956 31 $1,987 Lighting $4,795 28 $4,823