02 Supplier Category IBM IT BT Telecoms Vodafone Telecoms EDF Energy Utility Air France Travel Travel Lodge Travel Telecoms Thames Water Utility Microsoft IT IBM IT BT Telecoms Vodafone Telecoms EDF Energy Utility Air France Travel Travel Lodge Travel 02 Telecoms Thames Water Utility Microsoft IT IBM IT BT Telecoms Vodafone Telecoms EDF Energy Utility Air France Travel Travel Lodge Travel Telecoms Thames Water Utility Microsoft IT IBM 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 02 Question 1 (Point 5): 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. (5 points) Question 2 (Point 5): Let's take a look at the data structure. Using 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? (5 points)