 # Question & Answer: Consider the Linear Programming formulation and its associated MS Excel solution below. Carefully examine the…

Consider the Linear Programming formulation and its associated MS Excel solution below. Carefully examine the MS Excel output above. Don't use plagiarized sources. Get Your Custom Essay on
Question & Answer: Consider the Linear Programming formulation and its associated MS Excel solution below. Carefully examine the…
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS \$13/PAGE

The dual price associated with constraint two is 0.67. If the right hand side of constraint two is increased by 5 units (i.e., 5×1 + 4×2 >=40 becomes 5×1 + 4×2 >=45) what impact does this have on the optimal objective function value of z = 82.67? Specifically, show any calculations to get a revised z-value.

Similarly, suppose that the right hand side of constraint two is decreased by three (3) units. What impact does the aforementioned change have on the objective function value of z = 82.67? Specifically show any calculations to get a revised z-value.