Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Min 5X + 6Y s.t. X+5Y 20 (Constraint #1) 2X + 3Y 30 (Constraint #2) 3X + Y 21 2X-Y0 (Constraint #3) X0, Y0
Min 5X + 6Y s.t. X+5Y 20 (Constraint #1) 2X + 3Y 30 (Constraint #2) 3X + Y 21 2X-Y0 (Constraint #3) X0, Y0 (Constraint #4) (Non-Negativity constraints) Microsoft Excel : Sensitivity Report Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$14 Values X 3.75 0 5 1E+30 $C$14 Values Y 7.5 0 6 [a] [b] Constraints Cell Name $B$19 Constraint #1 Amont used $B$20 Constraint #2 Amont used $B$21 Constraint #3 Amont used Final Value Shadow Price Constraint Allowable Allowable R.H. Side Increase Decrease 20 21.25 1E+30 [c] 30 3.6 15.4545 21 1E+30 2.25 0 2.5714 10 $B$22 Constraint #4 Amont used Computer output generated by Excel software is given above with some cell/parts left blank (labeled as [a], [b], and [c]). (d) What is the objective function value? (e) Suppose the coefficient of variable X is decreased to $3. Is the above solution still optimal? If it is then state the revised value of the objective function?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started