NASA must determine how many of three types of objects to bring on board the space shuttle. The weight and benefit of each of the items are given in the file P06_42.xlsx. If the space shuttle can carry up to 2,000 pounds of items 1 through 3, how many of each item should be taken on the space shuttle, assuming that at least one of each is necessary? Number of each item to be included   Item 1 Item 2 Item 3 Number included             NASA data             Data on items       Item 1 Item 2 Item 3 Benefit 20 15 12 Weight 500 400 300

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter6: Optimization Models With Integer Variables
Section: Chapter Questions
Problem 42P
icon
Related questions
Question

NASA must determine how many of three types of objects to bring on board the space shuttle. The weight and benefit of each of the items are given in the file P06_42.xlsx. If the space shuttle can carry up to 2,000 pounds of items 1 through 3, how many of each item should be taken on the space shuttle, assuming that at least one of each is necessary?

Number of each item to be included
  Item 1 Item 2 Item 3
Number included          

 

NASA data    
       
Data on items    
  Item 1 Item 2 Item 3
Benefit 20 15 12
Weight 500 400 300
       
       
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,