Answered step by step
Verified Expert Solution
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
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
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