Question: 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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!