Formulate and solve an appropriate integer programming model
Not what you're looking for?
In preparing for a two-week camping vacation, a family must decide how many of each of six items should be loaded into their sport-utility vehicle. The weight and perceived benefit (Where a larger benefit value indicates a more useful item) of each of the items are given in the attached file. The family's vehicle can safely carry no more than 120 pounds of these items, given the amount of luggage that has already been loaded into the vehicle. In trying to decide what should be taken on the vacation, the family must ensure that at least half of the total weight of all objects taken is derived from the inclusion of items of type 1, 2, and 3. Also, the family must ensure that at most half of the total benefit of all objects taken is derived from the inclusion of items of type 4, 5, and 6.
Objective:
Formulate and solve an appropriate integer programming model to help this family decide how many units of each type of item to take to maximize the total benefit to be achieved.
Purchase this Solution
Solution Summary
The solution formulates and solves an appropriate integer programming models.
Solution Preview
Dear Student:
Please open the attached Excel file to see the solution done with Excel Solver.
The goal (Objective) is to maximize the total number of benefits: 450 points, which is calculated by Item1benefit * NumberIncluded + Item2benefit * NumberIncluded + ? + Item6benefit * NumberIncluded.
The constraints ...
Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.