PLEASE ANSWER WITH STEPS ON HOW TO SOLVE IN EXCEL, THANKS!

Player Name Position Price $($Fantasy $$)$ Predicted Performance

Manuel Neuer Goalkeeper $5095$

Mendy Goalkeeper $4087$

Abedzadeh Goalkeeper $1075$

Unai Simon Goalkeeper $2587$

Hugo Loris Goalkeeper $3570$

Thiago Silva Defender $2082$

Maguire Defender $3075$

John Stones Defender $4092$

Van Dijk Defender $6095$

Cancelo Defender $5089$

Pepe Defender $2580$

Martinez Defender $5085$

Varane Defender $3090$

Tony Cross Midfielder $3592$

Modric Midfielder $3590$

Gavi Midfielder $4582$

Pedri Midfielder $5085$

Rice Midfielder $5588$

Fernandez Midfielder $5590$

Casemiro Midfielder $4088$

Debruyne Midfielder $7095$

Rodri Midfielder $6090$

Neymar Striker $7092$

Messi Striker $4090$

Ronaldo Striker $3582$

Mbappe Striker $9090$

Lewandowski Striker $6579$

Muller Striker $3084$

Polisic Striker $3085$

Taremi Striker $2582$

You do not need to present a mathematical formulation for this problem, but you MUST solve it with

Excel using the Excel Solver.

a$)$ What is the total predicted performance of your selected squad?

Answer: maximum predicted performance:

b$)$ Which defenders are selected in your team?

Answer: selected defenders:

${?}^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$).$