Question: Question 2 (40pts) Figure 1 provides the Excel Sensitivity output for the following LP model. Max Z= 10x, + 8x subject to: 3, +2x 0

Question 2 (40pts) Figure 1 provides the Excel Sensitivity output for the following LP model. Max Z= 10x, + 8x subject to: 3, +2x 0 Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$13 Solution x1 6 0 1 01E+30 6 $C$13 Solution X2 0 -12 8 121E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price RH. Side Increase Decrease $D$6 C1 Totals 18 0 24 1E4306 $D$7 C2 Totals 12 124 12 $D$8 C3 Totals -12 0 Figure. 1 a) (10 pts) Determine the objective function value when we increased the unit of resource of 1 from 24 to 30. Can you find the new optimal solution XI and X2? Explain. b) (10 pts) Determine the objective function value if the profit of X2 is increased from 8 to 16? Does the solution change? Explain. c) (10 pts) Determine the objective function value if the profit of xl is decreased from 10 to 3? What can you say about the solution? Explain. d) (10 pts) Determine the objective function value when we increased the unit of resource of 2 from 6 to 12. What can you say about the solution? Explain

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 2 (40pts) Figure 1 provides the Excel Sensitivity output for the following LP model. Max Z= 10x, +8X, subject to: 3, +2x =24 2x, + 4x,

a) (20 pts) Write the optimal solution and objective function value. b) (20 pts) Determine the objective function value when we increased the unit of resource of 3 from 24 to 28. Can you find the new...

Figure 1 provides the Excel Sensitivity output for the following LP model 10x + 8x2 Max Z- subject to 3, +2x2 524 2x + 4x2 S12 -2x + 2x3 56 XI, X20 Variable Cells Cell Name $B$13 Solution xl $C$13...

Figure 1 provides the Excel Sensitivity output for the following LP model. 10x1 + 8x2 Max Z= subject to: 31 +2x2 0 Variable Cells Cell Name $B$13 Solution x1 $C$13 Solution x2 Final Reduced Objective...

Use the following sensitivity report to answer this problem. This report presents the result of a linear program to determine the optimal product mix between four possible products x G = 1,2,3,4)....

1. (3 points) What most motivates a business to be concerned with cent of the resources? Resources are limited and valuable B. Efficient resource use increases business costs C. Efficient resources...

Igor Yeltsin operated a farm under the former Russian collective farm system. The collective farm-raised hogs for distribution by the central government as its main activity. Previously, Igor was...

Harry Hoke is the owner of a bicycle shop, Hoke's Spokes. Although most of Harry's bicycle sales are based on customer orders, he stocks a limited supply of bikes for walk-in customers. He buys and...

Problem 5. In a manufacturing company, the manager is trying to determine a weekly production plan There are four products (say, A, B, C, and D). The following LP model is considered to find the...

A salad dressing supplier to Ottawa area restaurants has been using Linear Programming (LP) for years to determine how much dressing they should produce for every season. In particular, they...

Multiple Choice Questions 1. The moving average inventory cost flow method is applicable to which of the following inventory systems? Periodic Perpetual a. Yes..... Yes b. Yes..... No c. No..... No...

Solutions Ip Tandem: A student who was asked to solve two systems. Noticed that they differed only in their right-hand sides She formed the matrix And obtained its RREF using Gauss-Jordan...

Haas contributes six percent of her monthly earnings to her 4 0 1 k plan at work. The plan allows her to invest in several different types of mutual and her employer matches up to 3 percent of her...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...