# i need some one to give me this answer in some deatil in 10-15 minutes For the Linear Program formulation given below formulates the problem in excel to minimize total cost. Maximize Z = 7 x1 + 1

i need some one to give me this answer in some deatil in 10-15 minutes For the Linear Program formulation given below formulates the problem in excel to minimize total cost. Maximize Z = 7 x1 + 1

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

i need some one to give me this answer in some deatil in 10-15 minutes

For the Linear Program formulation given below formulates the problem in excel to minimize total cost.

Maximize     Z = 7 x1 + 14 x2 + 6 x3 + 10 x4 – 3 x5

Subject to:

x5 ≥ 4000   constraint 1

3 x2 + 2 x4 + x5 ≤ 6000    constraint 2

x1 + x2 = 3 x5    constraint 3

x3 + x4 = 4 x5    constraint 4

x1, x2, x3, x4, x5 ≥ 0

Solve the problem using excel and report the optimal solution (i.e. decision variables and objective function)