Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question: Please note that this problem has ten parts (a' to j'). . You may need to scroll the screen down, navigate left and right

image text in transcribed
Question: Please note that this problem has ten parts (a' to "j'). . You may need to scroll the screen down, navigate left and right to see the whole problem. Clearly label your parts when answering. You are allowed a Maximum of 3 Files for this problem. Must use a pen to answer. Must Show all calculations/steps where required. Failure to do so will result in a score of "0" even final answer is correct. FOUR PLACES AFTER THE DECIMAL POINT (except when all succeeding digits are zeros). Consider the following LP: Min 5X + 7Y S.t. X + 5Y > 28 (Constraint # 1) ?X + ?Y = 26 (Constraint # 2) X + 2Y = 17 (Constraint # 3) 2X - Y21 (Constraint # 4) X20, Y 20 (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 [a] 5 1E+30 3.6 $C$14 Values Y 5 7 [b] [c] Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$19 Constraint #1 Amont used 28 [d] 28 6.875 27.5 $B$20 Constraint #2 Amont used 21 0 26 1E+30 $B$21 Constraint #3 Amont used [e] 17 1E+30 4 $B$22 Constraint #4 Amont used 1 [f] 1 7.8571 6.6 Computer output generated by Excel software is given above with some cell/parts left blank (labeled as [a], [b], [c], [d], [e] and [f]). (9) What is the objective function value? (h) Which constraint/s is/are binding? (0) Suppose the coefficient of variable X is decreased to $1.5. Is the above solution still optimal? If it is, then state the revised value of the objective function. If it is not, then give reasoning? () If the right-hand side of constraint #1 increased by 7. Is the above solution still optimal? If it is, then state the revised value of the objective function. If it is not, then give reasoning

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

Essentials of Management

Authors: Andrew J. DuBrin

9th Edition

538478233, 2900538478235, 978-0538478236

More Books

Students also viewed these General Management questions