Following the Polya method, Your Task is to: 1) Determine what this problem is asking for. Explain the problem in your own words and detail the specific things asked for in this problem. 2) Determine what data you would need to complete the problem successfully. 3) Devise your plan for solving the problem. No Excel-specific information should be included. I do not want to see Excel tools or functions listed. Think about this abstractly instead. Combine your answers for all three problems into a single Word document and submit it here before the deadline. Concessions/Ticket Prices You have taken a job as an analyst for Auburn University's ticket department. The marketing team is concerned that soaring concession prices will affect this year's football ticket sales. The manager believes that the rising prices in hotdogs and alcoholic drinks each year is slowly negatively impacting the number of fans going to the football games. You have been asked to provide data and visuals showing the relationship between the rising prices of concessions and the tumout of fans per game over the last 5 years, Create a chart that shows the gross margins that Auburn receives cach game and determine whether the concession price increases are influencing ticket sales. Hint: It may be wise to also include winning / losing seasons due to less fans in the stadium per game. Extra info: Auburn Board provides ticket prices, season stats, and all revenue brought in each game Auburn home football games can have roughly 50.000 fans max. Hot dogs are $15 and Alcoholic drinks are $20 In 2020, COVID - 19 resulted in a dramatic decrease in fans in the 2020 season. Following the Polya method, Your Task: 1) Determine what this problem is asking for. Explain the problem in your own words and detail the specific things asked for in this problem 2)Determine what data you would need to complete the problem successfully 3) Devise your plan for solving the problem. No Excel-specific information should be included. I do not want to see Excel tools or functions listed. Think about this abstractly instead