Explore BrainMass
Share

Explore BrainMass

    Optimization in a Players Selection

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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
    https://brainmass.com/business/operations-research/optimization-players-selection-596678

    Attachments

    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 ...

    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.

    $2.19