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.
(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