Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered 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

Intermediate Accounting

Authors: Kin Lo, George Fisher

3rd Edition Vol. 1

133865940, 133865943, 978-7300071374

Students also viewed these Accounting questions

Question

Describe the Gestalt approach to the mind brain problem.

Answered: 1 week ago

Question

List all distinct subsets of the set {{}, , {}, {{}}, {}, }.

Answered: 1 week ago