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 NumberItemBenefitWeight (in pounds)
1Flashlight82
2Cereal55
3Cake83
4Water44
5Gatorade56
6Bug Spray83
7Umbrella54
8Knife93
9Cheese34
10Beef Jerky45

Step by Step Solution

3.42 Rating (146 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Microsoft Excel Data Analysis 7th Questions!