How will the composition of the dream team be changed

Assignment Help Management Information Sys

Reference no: EM13759091

The National Basketball Dream Team

Assignment:

a) The spreadsheet DREAM-TEAM.XLS contains all of the data about the statistics of players. Using this spreadsheet, construct and solve a discrete optimization model that can be used to select the national men's basketball dream team.

b) How will the composition of the dream team be changed if the following constraints are changed as follows:

- the average number of rebounds among the 12 selected players needs to be at least 8 rebounds per game,

- the average number of assists per game among the 12 selected players must be at least 7 assists per game, and

- the average number of points per game among the 12 selected players must be at least 20 points per game.

c) Rudy is thinking of also selecting two more players as alternates in case any of the 12 selected players is injured prior to the start of the world championship games in Barcelona. Propose a method for selecting the two alternates.

Attachment:- dream team.xls

Reference no: EM13759091

Questions Cloud

Descriptive statistics project project : Descriptive Statistics Project Project #1This project gives you the chance to use all of the statistical techniques and concepts that are covered in the initial chapters of the text.Problem: Think of a question that can be answered by analyzing data.

Health disparities and the social determinants : Health disparities and the social determinants of health can be influenced by many factors, some obvious and some you may never have considered until now.

Application for a small catering business : For this assignment, you are required to design and develop a console (text-based) application for a small catering business. This application will simulate booking appointments, tracking catering jobs and processing payments.

Descriptive statistics project : Descriptive Statistics Project Descriptive Statistics Project Project #1 This project gives you the chance to use all of the statistical techniques and concepts that are covered in the initial chapters of the text.Data Collection: This is an open e..

How will the composition of the dream team be changed : How will the composition of the dream team be changed if the following constraints are changed as follows: the average number of rebounds among the 12 selected players needs to be at least 8 rebounds per game

Mass merchandisers regional warehouses : Describe the logistics steps that large mass merchandiser global supply chains use to ensure timely availability of inventory for routine and sales merchandise needs. This discussion must begin with the transportation from the foreign factory to i..

How did the new women reject convention : How did the New Women of this period reject convention? Find a piece not addressed in the book from this period (and not yet addressed by another student) to support this idea.

Create a time-phased assembly chart : What adjustments are needed in inventory levels, lead times, and batch sizes to fill an additional customer order for five custom cars in five days - Create a time-phased assembly chart

Acquisition of a foreign corporation : Find a current article not more than two years old, discussing the acquisition of a foreign corporation by a U.S parent. Discuss how the transaction was structured, including: the parties involved, the country that the foreign corporation is locat..

User Account

All Pages