Question 4) I FIFA World Cup 2022 is starting on November 20\" in Qatar. Before the start of the World Cup, you want to create a Soccer Fantasy (see the footnote for a general definition1) team to participate in a fantasy World Cup competition. In the data that is shared with you (in Fantasy Socoer.xlsx), a set of available players is given to you. Each player has a position, a price, and a predicted performance. You have 400 fantasy dollars available. Your goal (objective) is to select a squad of players that maximizes the total predicted performance of your team. Your decision variables are whether you select or not select each player for your team [similar to the knapsack problem]. Use mathematical modeling and the Excel solver to pick your team such that the following constraints are satisfied: 1} You pick a player at most once (binary decision variables). 2} You pick exactly 11 players. 3} You pick exactly 1 goalkeeper. 4} You pick exactly 4 defenders. 5) You pick exactly 4 midelders. 6} You pick exactly 2 strikers. 7) You cannot spend more than your available budget {400 fantasy S). I! - II- 2 FORMM'ION You do not need to present a mathematical formulation for this problem, but you MUST solve it with Excel using the Excel Solver. (Hint: Isn't this problem similar to the knapsack problem we learned in the class, but with some additional constraints?) a) What is the total predicted performance of your selected squad? Answer: maximum predicted performance: b) Which strikers are selected in your team? Answer: selected Strikers; 1 Fantasy Soccer is a game that casts you in the role of a Fantasy manager. You are given the task to pick a squad of real-life players who score points for your team based on their performances in their own matches (Google Search). Player Name Position Price (Fantasy $) Predicted Performance Manuel Neuer Goalkeeper 50 95 Mendy Goalkeeper 40 87 Abedzadeh Goalkeeper 10 75 Unai Simon Goalkeeper 25 87 Hugo Loris Goalkeeper 35 70 Thiago Silva Defender 20 82 Maguire Defender 30 75 John Stones Defender 40 92 Van Dijk Defender 60 95 Cancelo Defender 50 89 Pepe Defender 25 80 Martinez Defender 50 85 Varane Defender 30 90 Tony Cross Midfielder 35 92 Modric Midfielder 35 90 Gavi Midfielder 45 82 Pedri Midfielder 50 85 Rice Midfielder 55 88 Fernandez Midfielder 55 90 Casemiro Midfielder 40 88 Debruyne Midfielder 70 95 Rodri Midfielder 60 90 Neymar Striker 70 92 Messi Striker 40 90 Ronaldo Striker 35 82 Mbappe Striker 90 90 Lewandowski Striker 65 79 Muller Striker 30 84 Polisic Striker 30 85 Taremi Striker 25 82