Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access with AI-Powered 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