Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with this question please. EDP-PET! 6_Variable Cells 7_ Final Reduced Objective Allowable Allowable 8_ Cell Name Value Cost Coefcient Increase Decrease 9

I need help with this question please.

image text in transcribed
EDP-PET!\" 6_Variable Cells 7_ Final Reduced Objective Allowable Allowable 8_ Cell Name Value Cost Coefcient Increase Decrease 9 $C$13 Variable 1 0 -50 1300 50 1E+30 10 $D$13 Variable 2 20 0 600 150 50 1 $E$13 Variable 3 10 0 500 300 33.33333333 1; 1i Constraints 1i Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $F$10 Constraint 3 Spent 0 0 5 1E+30 5 1? $F$8 Constraint1 Spent 4000 3 4000 1000 1500 E $F$9 ConstraintZSpent 1000 5 1000 600 200 1:) What is the optimal solution? (2 marks) What is the optimal objective function value? (3 marks) What is the allowable range for the objective function coefficient of "Variable 1"? (3 marks) What is the allowable range for the Right-hand side value of "Constraint 1\"? {3 marks) Does the optimal solution change if we change the objective function coefficient of "Variable 2\" to 800? Why? (3 marks) Based on the available information, can we find out if the optimal solution changes when we change the objective function coefficients of \"Variable 2" and "Variable 3\" to 650 and 600 respectively? Why? {4 marks) Based on the available information, can we determine the optimal objective function value after the RHS of "Constraint 3\" changes to 10? Why? If yes, what is the optimal objective function value after this change? (3 marks) Based on the available information, can we determine the optimal objective function value when we change the RHS of "Constraint 1\" and "Constraint 2\" to 4300 and 900 respectively? Why? If yes, what is the optimal objective function value after this change? (4 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Making Hard Decisions with decision tools

Authors: Robert Clemen, Terence Reilly

3rd edition

538797576, 978-0538797573

More Books

Students also viewed these Mathematics questions

Question

5. How relevant is the concept of the learning organization today?

Answered: 1 week ago