Question

OPRE 3310: Homswork Assignment 3 Due on March 3- 2020 3. points) Suppose you plan to go out for a picnic during spring break. You plan to bring sandwiches, fruits, and drinks. But you only have one pic ches, Truits, and drinks. But you only have one picnic basket that can only hold a certain capacity. Each of the items has a value and a size, and you cannot hold di your items in the basket. The picnic basket can hold a total size of 17. Given that the size and the value of items are as follows how many of each item should you bring to maximize the total value? Size Value Sandwich 6 9 Fruit I 3 I 4 Drink and the value of Sket. The picnic hachis a value and a size a) List the decision variables. (1 point) b) Write out the objective function. (1 point) c) Write out the constraints. (1 point) d) Write the linear program. (2 points) e) Type the LP into the Excel and solve it using Excel Solver. Write down the optimal amounts of sandwiches, fruits and drinks that you should take to picnic. (2 points) Page 4 of 4

Answer 1

Answer a= Decision variable

Let X= Number of sandwich

Y=Number of Fruit

Z=Number of Drink

Answer b= The objective function is to maximize the total value of all the items

Max W= 9X+4Y+6Z

Answer d= Constraints =

6X+3Y+4Z$\leqslant$17

Where X,Y,Z$\geqslant$0

Answer d=

Linear program=

Let X= Number of sandwich

Y=Number of Fruit

Z=Number of Drink

Objective function Max W= 9X+4Y+6Z

Subject to

6X+3Y+4Z$\leqslant$17

Where X,Y,Z$\geqslant$0

P.S. AS PER HOMEWORKLIB POLICY ONLY FRST 4 PARTS ARE TO BE ANSWERED IF A QUESTION HAS MORE THAN 4 PARTS