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:

Create an excel spreadsheet and use Solver to model the situation and find the optimal solution.

ObjectCandyBarSandwichJuiceCanAppleCaloriesperObject9013010040Protein(gramsperobject)540153Weightperobject0.250.350.350.3Volumeperobject0.00050.0020.000750.0009