Usingexcel solver, solve the following LP problem.

X1=pounds of banana to buy

X2= pounds of Orange to buy

X3= pounds of Cereal to buy

Min cost (Z) =430X1 + 460X2 +420X3

Subject to

1X1 + 3X2 + 1X3 10 Vitamin A

2X1 + 4X3 4Vitamin B

1X1 + 2X2 10Vitamin C

X1,X2,X30 (Non-negativity constraint)

Note that fractional values for themodelsare acceptable. Use two decimal places to provide answers to questions 4 through 8

1. Generate Input Sheet

2. Generate Answer report

3. Generate Sensitivity report

4. What is the optimal solution? What is the value of the objective function?

5. Suppose that the cost for the banana is increased by $3 per pound, and the cost for the Cereal is decreased by 5 per unit. What will be the new optimal solution?

6. What is the value of reduced cost for the Cereal? Explain it in not more than four sentences. Provide any calculation to support your point.

7. If the student is asked to take a minimum of 12 units of vitamin A and minimum 7 units of Vitamin B, what is the new cost?

8.The objective coefficient of Orange can be increased by ________and reduced to______;while,the objective coefficient of Cereal can be increased to______ and reduced by_____.