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 with AI-Powered 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

Edexcel AS And A Level Mathematics Pure Mathematics Year 1/AS

Authors: Greg Attwood

1st Edition

129218339X, 978-1292183398

More Books

Students also viewed these Mathematics questions

Question

Have you presented all the relevant facts?

Answered: 1 week ago