Prepare 3 pie charts (one each for segment revenue, profits and assets), showing the average percentage (over the 10 years) that each segment contributes to total company revenue, profits and the allocation of assets. The pie chart should be properly labeled and the use of colors to indicate the segments is encouraged. The formulas for calculation of the contribution by each segment to segment revenue, profits and assets should be in the spreadsheet.