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 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 | |||
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted: