From the set of seven players, Coach Night has to select five-players start lineup. While selecting the lineup, objective is the maximize defensive ability and meet the lineup composition and playing abilities constraints. At least four members must be able to play guard (G), at least two members must be able to play forward (F), and at least one member must be able to play center (C). The average ball-handling, shooting, and rebounding level of the starting lineup must each be at least 1.8 and either player 2 or 3 must start. Further details of the context is given in the attachment.© BrainMass Inc. brainmass.com October 10, 2019, 7:49 am ad1c9bdddf
This solution provides a spreadsheet modelling application in the field of sports. The objective is to select start team that meets various constraints and maximizes defensive ability of the team. A detailed step by step guidance is provided in the file.
Step 1: Summarize the problem and define purpose
From the set of seven players, Coach Night has to select five-players start lineup. While selecting the lineup, objective is the maximize defensive ability and meet lineup composition and playing abilities constraints.
Step 2: Define decision variables
Selecting a player as a part of starting lineup and the ...
This response is an application of optimization in a players selection problem. The solution demonstrates the use of linear programming and spreadsheet modelling in a different context.