Consider the following Linear Programming problem. Read the 3 parts displayed below.

Max Z =1.3x1+2.95x2+2.4x3

Subject to

5x1+8x2+5x3<=220

3x1+8x2+7x3<=230

2x1+ x2+2x3<=400

x1,x2,x3 are non-negative.

Part 1: ALL-INTEGER

Enter the model in Excel, set ALL your variables as integer, make sure "Simplex Method" is chosen as your "Solving Method" in the Solver window, and that the "Ignore Integer Constraints" box in the Solver's "options" menu is unchecked. Solve the model using Solver. No sensitivity, limits, etc. reports is needed for this assignment. Upload your Excel file in the space provided for Question 1.

Part 2: MIXED-INTEGER

Next, remove the integrality constraint from x2 and x3, i.e., only x1 needs to be set as "int" in the Solver window. Solve your Mixed-Integer model, and answer questions 5-7.

Note: No need to include/upload your modified Excel file here.

Part 3: NON-INTEGER (LP RELAXATION)

Finally, remove the integrality constraint from all variables. Solve the modified model, and answer questions 8-10.

Note: No need to include/upload your modified Excel file here.