Optimization in a Players Selection
Not what you're looking for?
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.
Purchase this Solution
Solution Summary
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.
Solution Preview
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 ...
Purchase this Solution
Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Basics of corporate finance
These questions will test you on your knowledge of finance.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.