EXCEL PROBLEM:

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 items selected must maximize the overall number calories and provide a minimum number of grams of protein while not exceeding the maximum load size and weight carry capacity of the knapsack.

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

The load may contain any number of each of the following 4 food items:

1. Candy Bar
2. Sandwich
3. Can of Juice
4. Apple

Specific information about each food items are as follows:

Object	Candy bar	Sandwich	Juice Can	Apple
Calories per Object	90	130	100	40
Protein (grams) per Object	5	40	15	3
Weight (kgs) per Object	0.25	0.35	0.35	0.3
Volumes (m3) per Object	0.0005	0.002	0.00075	0.0009

Note: The number of each food item must be an integer.

1. Find the optimum solutions of 4 food items to satisfy the requirements stated above. Present the result clearly.

Continue to use EXCEL to solve:

2. According to the calculations, in order to keep the maximum weight not over 10 kg but also maximize the calories, Juicy Can and Apple are ignored. Nevertheless, for diversity purpose, the camper wants to bring Juicy Can and Apple along with other food items.

1. By Scenario Manager, create 3 possible solutions which allow bringing all food items while still keeping the maximum weight of knapsacks load not over 10 kg. Give the appropriate names to these 3 solutions. Include the result in part a) as an additional solution besides the required ones.

2. Create the Summary Report to show the results of maximum weight of 4 cases obtained in part i) for comparison. The results should be displayed with appropriate format (i.e. names for each food items).