Purchase Solution

Integer linear programming model

Not what you're looking for?

Ask Custom Question

The Tennessee Pterodactyls (I would like a detailed analysis of the problem--broken down to simplistic understanding--and how the solution was derived in similar simple to understand terms.)

The Tennesse Pterodactyls is a new professional basketball franchise in Nashville. The team's general manager, Jerry East, and coach, Phil Riley, are trying to develop a roster of players. They drafted seven players from a pool to which the other teams in the league each contributed two players. However, the general manager and coach perceive these acquisitions to be no more than role players.

They believe that the nucleus of their new team must come from the free agents who are currently available on the market. The team is well under the salary cap, and the owner has made $50 million per year available to them to sign players. The coach and general manager have put together the attached list of free agents, with important statistics for each, including their rumored asking price in terms of annual salary (See attachment)

Jerry and Phil want to sign five free agents. They would like the group they sign to average at least 80 points per game (16 points per player), pull down an average of 40 rebounds per game (8 per player), dish out an average of 25 assists, and have averaged 190 minutes (38 minutes per player) per game in the past. Furthermore, they do not want to sign more than two front court and three back court players. Their immediate objective is to identify the players who as a group would meet their objectives at the minimum cost.

A. Formulate an integer linear programming model to help the general manager and coach determine which players they should sign and solve it by using the computer.

B. Is the money provided by the owner sufficient to sign the group of players identified in (A)? If not, reformulate the model so that the available funds are a constraint and the objective is to maximize the average points of the group.

Purchase this Solution

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Introduction to Finance

This quiz test introductory finance topics.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.