Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ACCESS 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

ACCESS 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 m3. 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.

a. Find the optimum solutions of 4 food items to satisfy the requirements stated above. Present the result clearly. b. 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. i. 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. ii. Create the Summary Report to show the results of the 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).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pro Database Migration To Azure Data Modernization For The Enterprise

Authors: Kevin Kline, Denis McDowell, Dustin Dorsey, Matt Gordon

1st Edition

1484282299, 978-1484282298

More Books

Students also viewed these Databases questions

Question

7.2 Explain the selection process.

Answered: 1 week ago

Question

What are the attributes of a technical decision?

Answered: 1 week ago

Question

How do the two components of this theory work together?

Answered: 1 week ago