Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 4) ) FIFA World Cup 2022 is starting on November 20' in Qatar. Before the start of the World Cup, you want to create

image text in transcribed
Question 4) ) 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 definitionl) team to participate in a fantasy World Cup competition. In the data that is shared with you (in Fantasy Soccer.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 (bi nary 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). 4 - 4- 2 FORMAHON 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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Management A Systems Approach to Planning Scheduling and Controlling

Authors: Harold Kerzner

10th Edition

978-047027870, 978-0-470-5038, 470278706, 978-0470278703

More Books

Students also viewed these General Management questions