PLEASE SHOW IN EXCEL AND ANSWER BOTH QUESTIONS

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 picnic basket that can only hold a certain capacity. Each of the items has a value and a size, and you cannot hold all your items in the basket. The picnic basket can hold a total size of 17 . The size and the value of items are as follows. Formulate a linear program to find out how many of each item should you bring to maximize the total value. In your submission, (i) list and explain carefully what the decision variables are, (ii) Write out the objective function. (iii) Write out the constraints. Attach File QUESTION 8 Solve your LP in the previous question using excel solver. What is the optimal number from each item to bring? 2 sandwhiches, 1 fruit, 31 sandwhich, 1 fruit, 22 sandwhiches, 2 fruits, 11 sandwhich, 2 fruits, 2 drinks drinks drinks drinks