Question: Answer the following questions considering the sensitivity analysis report given below: 8 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost

Answer the following questions considering the sensitivity analysis report given below: 8 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $C$13 Variable 1 0 -50 1300 50 1E-30 10 $D$13 Variable 2 20 0 800 150 50 11 $E$13 Variable 3 10 0 500 300 33.33333333 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $F$10 Constraint 3 Spent 0 0 5 1E+30 5 17 SFS8 Constraint 1 Spent 4000 3 4000 1000 1500 18 SFS9 Constraint 2 Spent 1000 5 1000 600 200 a. What is the optimal solution? (2 marks) b. What is the optimal objective function value? (3 marks) c. What is the allowable range for the objective function coefficient of "Variable 2"? (3 mar BEOORD GD 3 S 4 % 5 DO & 71 3 0 3 8) 9 E T R Y U P 0 D F G . J L C V B N M

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!

Question 4. What-if analysis (25 marks) Answer the following questions considering the sensitivity analysis report given below: 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell...

Which decision variable(s) are non-basic? 9 6 Variable Cells 7 Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4x1 0 - 10.2 12 10.2. 1E+30 10 $C$4x2...

questions considering the sensitivity analysis report given below: 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $C$13 Variable...

Consider the sensitivity report below anddeterminethe objective function value? 5 6 Variable Cells 7 Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease 9...

The CitruSun Corporation ships frozen orange juice concentrate from processing plants in Eustis and Clermont to distributors in Miami, Orlando, and Tallahassee. Each plant can produce 20 tons of...

Question 2 5 pts U The LP problem whose output follows determines how many necklaces, bracelets, rings, and earrings a jewelry store should stock. The objective function measures profit: it is...

FIGURE 4:18 SENSITIVITY REPORT FOR THE QUALITY AIR CONDITIONING PROBLEM Variable Cells Model Final Reduced Objective Allowable Allowable Variable Name Value Cost Coefficient Increase Decrease E...

Stay A business student has $1500 available from a summer job and has identified three potential stocks in which to invest. To find an optimal solution to maximize, the Excel add-in Solver was used....

An airplane travels 210 km on a straight course making an angle of 22.5 degrees east of north. it changes its course by moving 110 km N before reaching its destination. Determine the resultant. 304...

Answer each of the below questions. (a) Explain the meaning of funds from operation. (b) Explain the meaning of operating cash flow. (c) Explain the meaning of free operating cash flow. (d) Explain...

cost of the three services priced separately. This is an ex price bundling. professional services pricing. price lining. two - part priving: multiple unit pricing.

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...