Question: I want to fill a backpack with items that will give me maximum benefit on a hiking trip. The weight in pounds and benefit for
I want to fill a backpack with items that will give me maximum benefit on a hiking trip. The weight in pounds and benefit for each item are given in the file named Problem8data.xlsx. The backpack can hold at most 26 pounds. At least one drink (water or Gatorade) and at least one protein (cheese or beef jerky) must be packed. How can I obtain the maximum benefit from items in my backpack?
| Item Number | Item | Benefit | Weight (in pounds) | |||
| 1 | Flashlight | 8 | 2 | |||
| 2 | Cereal | 5 | 5 | |||
| 3 | Cake | 8 | 3 | |||
| 4 | Water | 4 | 4 | |||
| 5 | Gatorade | 5 | 6 | |||
| 6 | Bug Spray | 8 | 3 | |||
| 7 | Umbrella | 5 | 4 | |||
| 8 | Knife | 9 | 3 | |||
| 9 | Cheese | 3 | 4 | |||
| 10 | Beef Jerky | 4 | 5 | |||
Step by Step Solution
3.42 Rating (146 Votes )
There are 3 Steps involved in it
Steps to be followed as follows Decision variables Selection as a new column next to weight which will become changing cells As a particular item is s... View full answer
Get step-by-step solutions from verified subject matter experts
