Answer needed for: C, D and E ONLY

Q1. Suppose you plan to go out for a picnic. You plan to bring sandwiches, fruits, and drinks. But you only have one picnic basket that can only hold a certain capacity, so you cannot hold all your items in the basket. Suppose that the picnic basket can hold a total size of 17. Given that the size and the value of the items are as in the table below, how many of each item should you bring in the basket to maximize the total value? Size Value Sandwich 6 9 Fruit 4 Drink 4 6 a) List and explain carefully what the decision variables are. (3 points) Let X: number of Sandwhich Y: Number of Fruit Z: Number of Drink b) Write out the objective function. (2 points) Max W:9x+4y+62 c) Write out the constraints. (3 points) d) Write the linear program. (2 points) e) Bonus: Solve the Linear Programming problem using Excel and report the optimal solution. Please also upload your excel file if you are answering this part. (2 points)