Please show steps in Excell

Question 4) (15 points) Before the start of a soccer tournament, you want to create a Soccer Fantasy (see the footnote for a general definition 2 ) team to participate in a fantasy soccer competition. In the data that is shared with you (in Fantasy Soccer.xisx), 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 midfielders. 6) You pick exactly 2 strikers. 7) You cannot spend more than your available budget ( 400 fantasy $ ). 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: Question 4) (15 points) Before the start of a soccer tournament, you want to create a Soccer Fantasy (see the footnote for a general definition 2 ) team to participate in a fantasy soccer competition. In the data that is shared with you (in Fantasy Soccer.xisx), 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 midfielders. 6) You pick exactly 2 strikers. 7) You cannot spend more than your available budget ( 400 fantasy $ ). 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