Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Step: 3

blur-text-image

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

Linear Algebra A Modern Introduction

Authors: David Poole

4th edition

1285463242, 978-1285982830, 1285982835, 978-1285463247

More Books

Students also viewed these Mathematics questions