Please formulate a model first and solve it using Excel Solver (with detailed steps and show inputs in Solver please). Thanks!

Problem 2 (35 points) You are the manager of a soccer team and you need to decide which players to trade for the next season. The following is your current roster except for the goalkeeper. The list below lists the players' skills and current market value. Defense Skills 9 7 Passing Skills 5 6 Shooting Skills 2 3 6 7 6 7 4 1 Player Defender A Defender B Defender C Defender D Midfielder E Midfielder F Midfielder G Midfielder H Striker Striker J 8 4 9 8 Market Value 1 million 0.5 million 0.6 million 1 million 3 million 1 million 1.8 million 1.2 million 8 million 1.5 million 6 2 5 5 6 7 6 10 7 7 7 5 2 8 The following players from other teams are available in the open market. Defense Skills 8 Passing Skills 8 8 Shooting Skills 7 5 8 Player Defender K Defender L Midfielder M Midfielder N Striker o Market Value 4 million 3 million 2.5 million 3 million 1.5 million 5 6 6 7 7 5 6 4 8 You want to improve your team, but you don't have any extra money to use in recruiting new players. You can, however, sell the rights to some of your players in order to raise money to purchase the rights to other players. You want to have the same number of players in each section (4 defenders, 4 midfielders and 2 strikers) after your trades. Assume that if you don't touch a given section of the team (defense, midfield or attack), then that section will perform 5% better (in all skills) than predicted by the stats because the players will already be familiar with each other's playing style. Are there any trades that you could make that, without adding any new money, would create a team better in defense, passing and shooting than the current roster? Assume that all players' skills count (for example, the average shooting skills of the team is the average of all players, not just the strikers' shooting skills). Do not pick a trade that would improve the team on one skill, while hurting it on others. When you consider whether the new roster is better in a given skill, don't forget to take into account the 5% familiarity bonus. Problem 2 (35 points) You are the manager of a soccer team and you need to decide which players to trade for the next season. The following is your current roster except for the goalkeeper. The list below lists the players' skills and current market value. Defense Skills 9 7 Passing Skills 5 6 Shooting Skills 2 3 6 7 6 7 4 1 Player Defender A Defender B Defender C Defender D Midfielder E Midfielder F Midfielder G Midfielder H Striker Striker J 8 4 9 8 Market Value 1 million 0.5 million 0.6 million 1 million 3 million 1 million 1.8 million 1.2 million 8 million 1.5 million 6 2 5 5 6 7 6 10 7 7 7 5 2 8 The following players from other teams are available in the open market. Defense Skills 8 Passing Skills 8 8 Shooting Skills 7 5 8 Player Defender K Defender L Midfielder M Midfielder N Striker o Market Value 4 million 3 million 2.5 million 3 million 1.5 million 5 6 6 7 7 5 6 4 8 You want to improve your team, but you don't have any extra money to use in recruiting new players. You can, however, sell the rights to some of your players in order to raise money to purchase the rights to other players. You want to have the same number of players in each section (4 defenders, 4 midfielders and 2 strikers) after your trades. Assume that if you don't touch a given section of the team (defense, midfield or attack), then that section will perform 5% better (in all skills) than predicted by the stats because the players will already be familiar with each other's playing style. Are there any trades that you could make that, without adding any new money, would create a team better in defense, passing and shooting than the current roster? Assume that all players' skills count (for example, the average shooting skills of the team is the average of all players, not just the strikers' shooting skills). Do not pick a trade that would improve the team on one skill, while hurting it on others. When you consider whether the new roster is better in a given skill, don't forget to take into account the 5% familiarity bonus