USE THE FOLLOWING OUTPUTS BELOW TO ANSWER THE FOLLOWING QUESTIONS ANSWER REPORT

Question

USE THE FOLLOWING OUTPUTS BELOW TO ANSWER THE FOLLOWING QUESTIONS ANSWER REPORT M B R D Number of Units 100 350 150 0 MAX PROFIT 90 84 74 60 49500 CONSTRAINTS CONSTRAINTS 1 10 8 3 15 4250 <= 5000 CONSTRAINTS 2 8 2 2 0 1800 <= 1800 CONSTRAINTS 3 1 1 1 1 600      = 600 CONSTRAINTS 4 0 0 1 0 150 >= 150 LHS SIGN RHS SENSITIVITY REPORT QUESTION 1 What is the Optimal Solution? Give the values for all variables. QUESTION 2 Write the Objective Function Value. QUESTION 4 In the original problem if the right hand side of constraint #3 were increased to 601 , how much would it change the objective function value? QUESTION 5 In the original problem if the coefficient of R in the objective function was increased to 95 would it change the optimal solution? Give values for all variables. QUESTION 6 What is the objective function for the Optimal Solution? QUESTION 7 What Constraints have Slack or Surplus? USE THE FOLLOWING OUTPUTS BELOW TO ANSWER THE FOLLOWING QUESTIONS ANSWER REPORT M B R D Number of Units 100 350 150 0 MAX PROFIT 90 84 74 60 49500 CONSTRAINTS CONSTRAINTS 1 10 8 3 15 4250 <= 5000 CONSTRAINTS 2 8 2 2 0 1800 <= 1800 CONSTRAINTS 3 1 1 1 1 600      = 600 CONSTRAINTS 4 0 0 1 0 150 >= 150 LHS SIGN RHS SENSITIVITY REPORT

Explanation / Answer

Note: Simplex linear optimization is used in MS Excel solver add-in

Ans1: The optimal solution that maximizes the profit maintaining all the constraints:

Ans2:Objective Function Value=

Ans4: In the original problem if the right hand side of constraint #3 were increased to 601 , how much would it change the objective function value?

The new value=

Ans 5: In the original problem if the coefficient of R in the objective function was increased to 95 would it change the optimal solution? Give values for all variables.

new solution is:

Ans6: new value of objective function=

Ans7: In original solution (Ans1) only Constraint#1 has slack/surplus.

slack of (5000-4250=) 750.

M B R D Number of Units 100 350 150 0

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.