Question: Can someone show me how to do this problem with excel using solver: solver: QUESTION 6 Solve the following LP in the excel HW file

Can someone show me how to do this problem with excel using solver: Can someone show me how to do this problem withsolver:

QUESTION 6 Solve the following LP in the excel HW file using Solver. Answer the questions below. Points will be taken off for wrong answers. All variables are assumed to be non- negative. Minimize 8A -3B + 7C + 6D + 3E Constraint 1 Constraint 2 Constraint 3 Constraint 4 2A 1A 2A 1A + 1B + OC -2 D + 6E s + OB -40 + 2D + 8E s + 5B + 20 + 1D + 3E + 6B + OC + 1D -2 E 33 25 30 16 All of the 33 units are used for constraint 1 The minimum cost is 2.913 Constraint 2 has a positive slack Constraint 1 is non-binding The value of Variable B is 3.788 Variable A has a positive value The shadow price for Constraint 2 should be non-zero Variable E is equal to 4.431 The minimum cost is 2.096 The problem doesn't have a feasible solution The value of Variable D is 0

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!