Question: 1. [25 Pt.] Consider the Answer and Sensitivity Reports at the end of the questionnaire to answer the following questions: a. (4 points) Write the

1. [25 Pt.] Consider the Answer and Sensitivity Reports at the end of the questionnaire to answer the following questions:

a. (4 points) Write the objective function.

b. (3 point) What is the objective function value at optimal point?

c. (3 points) Identify the sensitivity ranges for the objective function coefficients (1, 2)

d. (4 points) What are the constraint quantity values?

e. (3 points) Identify the sensitivity ranges for the constraint quantity values.

f. (4 points) Are there any unused resources? If so, which ones and what are the amount of unused resources?

g. (4 points) If I increase the quantity of third resource by 10 units, what would my new objective value be?

1. [25 Pt.] Consider the Answer and SensitivityANSWER REPORT SENSITIVITY REPORT Note: 1E+30 =

ANSWER REPORT Objective Cell (Max) Cell Name $B$4 Z Original Value 0 Final Value 21 Name Final Value Variable Cells Cell $B$2 $B$3 Original Value 0 x1 5 3 Integer Contin Contin x2 0 Name Slack Cell Value 22 0 Constraints Cell $D$8 $D$9 $D$10 $D$11 R1 usage R2 usage R3 usage R4 usage 7 14 Formula $D$8

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!