Question: The sheet and your EXCEL spreadsheet (with all your work). Max 4X1 + 6X2 (2/8)X: + (1/16)X2 s 20 (61 constraint) 1X1 (11/12) X: s
The sheet and your EXCEL spreadsheet (with all your work). Max 4X1 + 6X2 (2/8)X: + (1/16)X2 s 20 (61 constraint) 1X1 (11/12) X: s 110 (W2 constraint) (1/12)X = (1/5)X: $20 (#3 constraint) Xi and X: 20 1. A) Please use graphical method to find the FEASIBLE REGION. Please LABEL the 3 constraints in your graph and indicate all the points you used. B). Please draw an objective function line (must write the equations here) in the graph of A) Mark the optimal solution as a star. C). Please list the system of two equations (crossing at the optimal solution point) D). Please get the optimal solution of C): How much is X1 and X27 You need to indicate the maximized output of the objective function. 2. Please answer the following questions (please have your answers in this sheet) based on the sensitivity analysis sheet from Solver. A). What is the optimal solution? Must indicate the cells on the Spreadsheet where you find the answer B). How much are the ranges of optimality for the coefficients of X1 and X2? (Must indicate the Cells you referred to on the spreadsheet). C). how much is the dual value for each constraint? (Must indicate the Cells you referred to on the spreadsheet). D). Which constraints are binding? Why? (must indicate what cells on the spreadsheet you used) E). Will the optimal solution change if the coefficient of X1 in the objective function was changed to 97 Why? F). Will the optimal solution change if the coefficient of 2 in the objective function was changed to 4.5? Why? G). If the RHS of #3 constraint changed to 21. how much will the objective function output be increased? Which cell you referred to on the spreadsheet? H). If the RHS of #1 constraint changed to 21, how much will the objective function output be increased? Which cell you referred to on the spreadsheet
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
