A football team is deciding which of the following players of team roster should
ID: 3576298 • Letter: A
Question
A football team is deciding which of the following players of team roster should be signed for contract extension: X1, X2, X3, X4, X5, X6, X7, X8, X9, X10, X11, X12, X13, X14, X15.
The cost of signing each player and the value each player will add to the team are shown below. Barcelona wants to sign at most 13 players who will add the most value to the team concerning the $30 million budget limit.
Player
Cost of signing player ($ millions)
Value added to the team
X1
3.2
90
X2
0.5
61
X3
2.6
70
X4
0.9
63
X5
0.6
62
X6
2.3
68
X7
1.1
61
X8
3.3
88
X9
2.3
87
X10
3.1
86
X11
1.9
75
X12
2.9
85
X13
2.9
91
X14
1.1
66
X15
2.8
89
a.Formulate an IP that could be used to determine which players should be signed
b.Solve the IP model using Lindo software. Provide results. Comment on results.
Player
Cost of signing player ($ millions)
Value added to the team
X1
3.2
90
X2
0.5
61
X3
2.6
70
X4
0.9
63
X5
0.6
62
X6
2.3
68
X7
1.1
61
X8
3.3
88
X9
2.3
87
X10
3.1
86
X11
1.9
75
X12
2.9
85
X13
2.9
91
X14
1.1
66
X15
2.8
89
A football team is deciding which of the following players of team roster should be signed for contract extension: X1, X2, X3, X4, X5, X6, X7, X8, X9, X10, X11, X12, X13, X14, X15. The cost of signing each player and the value each player will add to the team are shown below. Barcelona wants to sign at most 13 players who will add the most value to the team concering the $30 million budget limit. Formulate an IP that could be used to determine which players should be signed Solve the IP using Lindo software. Provide results. Comment on results.Explanation / Answer
yes
a.Formulate an IP that could be used to determine which players should be signed
b.Solve the IP model using Lindo software. Provide results. Comment on results.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.