Question: I want to know How to use Excel solve problem by the simplex model. Step by step Please. This is the example. (a) Let Xij

I want to know How to use Excel solve problem by the simplex model. Step by step Please.

This is the example.I want to know How to use Excel solve problem by

(a) Let Xij be the amount of space leased for j = 1, ..., 6 i months in month i = 1, ...,5. minimize C = 650(211 + X21 +231 +241 + X51) + 1000(x12 + X22 +232 + x 42) + 1350(x13 + x23 + x33) + 1600(X14 + X24) + 1900x15 subject to X 11 + X 12 + X 13 + X14 + X15 > 30,000 X 12 + X 13 + X 14 + x15 + X21 + X22 + X23 + X24 > 20,000 X 13 + X 14 + X 15 + X22 + X23 + x24 + X31 + X32 + x33 > 40,000 X 14 + X15 + X 23 + x24 + X32 + x33 + x41 + x42 > 10,000 X 15 + X24 + X33 + x 42 + X51 > 50,000 Xij > 0, j= 1, ..., 6 i and i = 1, ...,5 (b) 1-1 1-2 1-3 1-4 1-5 2-1 2-2 2-3 2-4 3-1 3-2 3-3 Unit Cost $650 $1,000 $1,350 $1,600 $1,900 $650 $1,000 $1,350 $1,600 $650 $1,000 $1,350 4-1 4-2 5-1 $650 $1,000 $650 Month Contribution Toward Required Amount 1 1 1 1 1 1 1 1 2 3 4 1 1 1 1 1 1 1 1 Totals $30,000 >= $30,000 $40,000 > $30,000 >= $50,000 >= Resource Available $30,000 $20,000 $40,000 $10,000 $50,000 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 5 1 1 1 1 Total Cost $76,500,000 Space Leased (sf) 0 0 0 0 30000 0 0 0 0 10000 0 0 0 0 20000

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!