I want to fill a backpack with items that will give me maximum benefit on a hiking

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 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
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: