1. Consider the following transportation problem. XYZ Company has capacities of 600 in its Corning plant and 200 in it plant in Geneva. However, its demands come from Fairport, Mendon, and Penfield at the following demand levels 300, 200, and 300 respectively.
The transportation costs per unit are as follows:









a) Develop a linear programming formulation of this transportation problem.
b) Use Excel Solver to solve this problem and find the optimal solution.
2. Consider the following linear program
Max 3×1 + 2×2
1×1 + 1×2 < 10
3×1 + 1×2 < 24
1×1 + 2×2< 16
And x1, x2 > 0.
a) Use Excel Solver to find the optimal solution to this problem. State the optimal values of x1, x2, and Z.
b) Assume that the objective function coefficient for x1 changes from 3 to 5. Does the optimal solution change? 
c) Assume that the objective function coefficient for x1 remains 3, but the objective function coefficient for x2 changes from 2 to 4. Does the optimal solution change?
d) What are the shadow prices for these constraints?
e) What conclusions can you draw about changes to the right hand side of constraint 2?
f) Identify the binding and non-binding constraints in this problem and explain.

find the cost of your paper

CE402 Unit 2 DBP

  In this Discussion, you will examine the impact of underlying beliefs on teaching and learning in early childhood that has evolved over time. Time has brought significant changes to….


  1 postsRe: Topic 5 DQ 2 This catastrophic earthquake took place on January 12, 2010, in the country of Haiti. With a magnitude of 7.0. on the Richter scale,….


Thoughts  While investigating advanced nursing degrees so as to begin work as a nurse practitioner (NP), potential students will find both DNP and Ph.D. programs. In the most general terms,….