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 (Constraint #3) 2X-Y0 (Constraint #4)

image text in transcribed

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

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

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