Question 2

A knapsack is being loaded for a camping trip. This knapsack has a maximum weight carrying limit and a maximum load size limit. The camper can choose from 4 different food items to put into the knapsack. The selected items must maximize the overall number of calories. And must meet constraints of at least a minimum number of grams of protein while not exceeding the maximum load size and weight carrying capacity of the knapsack.

The knapsacks load cannot exceed a weight of 10 kilograms or a volume of 0.125m. The load of food items must contain at least 200 grams of protein.

The load may contain any number of each of the following items: Candy Bar, Sandwich, Can of Juice and Apple. Specific information about each food items are as follows:

Object	Calories per Object	Protein (grams per object)	Weight per object	Volume per object
Candy Bar	90	5	0.25	0.0005
Sandwich	130	40	0.35	0.002
Juice Can	100	15	0.35	0.00075
Apple	40	3	0.3	0.0009

Create an excel spreadsheet (name it question 2) and use Solver to model the situation and find the optimal solution.