Solution 1 2 A 5 10 B 4 70 C 4 50 supply 20000 10000 A B C demand 1 2 30 2500 2 2 70 2500 3 1 50 2000 4 1 30 2000 Product 1 5 1 10 2000 6 1 20 2000 7 0 30
Solution A B C supply A B C
Solution A B C supply A
B C supply A B C demand Product
Solution A B C supply
A B C demand Product
Solution A B C
Solution A
1 (Solution) 1 2 A 5.10 B 4.70 C 4.50 supply 20000 10000 A B C demand 1 2.30 2500 2 2.70 2500 3 1.50 2000 4 1.30 2000 Product 1 5 1.10 2000 6 1.20 2000 7 0.30...

Category: General
Words: 1050
Amount: $12
Writer:

Paper instructions

Please use Excel solver to min Z= $5.20X1A+4.20X1B+4.30X1C+3.10X2A+5.70X2B+2.50X2C+2.10XA1+2.50XA2+1.70XA3+1.40XA4+1.30XA5+1.00XA6+0.70XA7+1.90XA8+1.80XA9+0.80XA10+0.90XA11+1.40XA12+1.60XA13+..............1.50XC20 (use the excel attachment to finish the objective function)S.T. X1A+X1B+X1C=20,000X2A+X2B+X2C=10,000XA1+XB1+XC1=2500XA2+XB2+XC2=2500XA3+XB3+XC3=2000....XA20+XB20+XC20=500X1A+X2A-XA1-XA2-XA3-XA4-XA5-XA6-XA7-XA8-XA9-XA10-XA11-XA12-XA13-XA14-XA15-XA16-XA17-XA18-XA19-XA20=0X1B+X2B-XB1-XB2-XB3-XB4-XB5-XB6-XB7-XB8-XB9-XB10-XB11-XB12-XB13-XB14-XB15-XB16-XB16-XB17-XB18-XB19-XB20=0X1C+X2C-XC1-XC2-XC3-XC4-XC5-XC6-XC7-XC8-XC9-XC10-XC11-XC12-XC13-XC14-XC15-XC16-XC17-XC18-XC19-XC20=0 (Use the excel attachment to finish the contraints)Don't forget the nonnegativity constraints!A B C supply 1 5.20 4.10 4.30 20000 2 3.10 5.70 2.50 10000 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 A 2.10 2.50 1.70 1.40 1.30 1.00 0.70 1.90 1.80 0.80 0.90 1.40 1.60 2.60 2.30 3.10 2.10 3.90 4.10 2.70 B 2.00 1.30 0.70 0.90 0.80 1.40 1.90 2.80 3.70 3.50 2.70 2.10 1.60 0.60 0.70 2.00 2.50 2.10 1.20 1.40 C 1.30 1.70 1.50 1.30 1.10 1.20 1.30 1.60 1.90 1.80 1.30 0.90 1.90 1.50 2.10 2.30 1.70 1.80 1.70 1.50 demand 2500 2500 2000 2000 2000 2000 2000 2000 1500 1500 1500 1000 1000 1000 1000 1000 1000 1000 1000 500 Product 1

Answer

Get Essay Answer
1,200,000+ Questions
Satisfaction guaranteed
(Solution) 1 2 A 5.10 B 4.70 C 4.50 supply 20000 10000 A B C demand 1 2.30 2500 2 2.70 2500 3 1.50 2000 4 1.30 2000 Product 1 5 1.10 2000 6 1.20 2000 7 0.30...
(Solution) 1 2 A 5.10 B 4.70 C 4.50 supply 20000 10000 A B C demand 1 2.30 2500 2 2.70 2500 3 1.50 2000 4 1.30 2000 Product 1 5 1.10 2000 6 1.20 2000 7 0.30...
(Solution) 1 2 A 5.10 B 4.70 C 4.50 supply 20000 10000 A B C demand 1 2.30 2500 2 2.70 2500 3 1.50 2000 4 1.30 2000 Product 1 5 1.10 2000 6 1.20 2000 7 0.30...
(Solution) 1 2 A 5.10 B 4.70 C 4.50 supply 20000 10000 A B C demand 1 2.30 2500 2 2.70 2500 3 1.50 2000 4 1.30 2000 Product 1 5 1.10 2000 6 1.20 2000 7 0.30...