Please show steps and formulas for charts 1 Supplier 2 IBM 3 BT 4 Vodafone 5 EDF Energy 6 Air France 7 Travel Lodge 8 02 9 Thames Water 10 Microsoft 11 IBM 12 BT 13 Vodafone 14 EDF Enerty 15 Air France 16 Travel Lodge 17 02 18 Thames Water 19 Microsoft 20 IBM 21 BT 22 Vodafone 23 EDF Energy 24 Air France 25 Travel Lodge 26 O2 27 Thames Water 28 Microsoft 29 IBM 30 B Category IT Telecoms Telecoms Utility Travel Travel Telecoms Utility IT IT Telecoms Telecoms Utility Travel Travel Telecoms Utility IT IT Telecoms Telecoms Utility Travel Travel Telecoms Utility IT IT Annual Spend 150,000 750,000 2,200 75,000 22.000 8.900 5,500 62,500 400,000 2,200 60,000 58,600 396,600 90,058 72,100 4,500 129,600 8,300 86,900 62,200 966,300 586,300 3,300 87,000 52,300 96,300 125,500 400,000 Question 1: How many categories are there in this company? Which category shows the highest spending? Create the Spend by Category Chart using Excel to answer. Chart should be provided here. Question 2: Look at the data structure. In Excel, generate a subtotal table that shows the number of suppliers for each category. Take a screen shot of the summary table. Do you think "number of suppliers information generated is correct? Question 3: Create a chart that shows the number of suppliers by category using SAP PA. (Chart needed) Question 4: Generate a chart that shows the average spend per supplier by category using SAP PA. (Chart needed) Question 5: Look over all the charts you've created. If you were to pick two categories to create a better sourcing strategy, which ones would you pick