Question: Excel's Solver has been used in the spreadsheet below to solve a linear programming problem with a maximization objective function. The two tables below show

Excel's Solver has been used in the spreadsheet below to solve a linear programming problem with a maximization objective function. The two tables below show the input section and the sensitivity analysis, respectively. Direction: For numerical answers, round non - integer values to 2decimal places. Keep integer values as integers. What is the optimal value for 1?Answer: 1=What is the optimal value for 2?Answer: 2=Would you pay $ 1.30each for up to 50more units of resource 2?Answer: Enter Y'es or No .Is the current solution still optimal even when the objective function coefficient of product 2is decreased to 2?Answer: Enter Y'es or No .Does the second constraint have a slack or a surplus? What is its current value? Answers: If 30units of resource 1were available, would the profit increase by $ 5.4?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!