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 (Constraint #3) 2X-Y0 (Constraint #4)
Min 5X + 6Y s.t. X+5Y 20 (Constraint #1) 2X + 3Y 30 (Constraint #2) 3X + Y 21 (Constraint #3) 2X-Y0 (Constraint #4) X 0, Y 0 (Non-Negativity constraints) Microsoft Excel: Sensitivity Report Variable Cells Final Reduced Objective Allowable Allowable Cell Name $B$14 Values X Value 3.75 Cost Coefficient Increase Decrease 0 5 1E+30 $C$14 Values Y 7.5 0 6 [a] [b] Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$19 Constraint #1 Amont used 20 21.25 1E+30 $B$20 Constraint #2 Amont used [c] 30 3.6 15.4545 $B$21 Constraint #3 Amont used 21 1E+30 225 $B$22 Constraint #4 Amont used 0 2.5714 10 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