Just do my homework!

• HTML tags will be transformed to conform to HTML standards.
Question
Submitted by willietanks on Fri, 2012-04-13 23:35
due on Tue, 2012-04-17 23:24
willietanks is willing to pay \$5.00
willietanks bought 58 out of 63 answered question(s)

Linear programming with excel and math skills Number 2

Use Solver to set up and solve problem No. 32, page 125 of your textbook. Make sure to embed your formulation to the Linear Programming problem within your Excel solution. This problem is a classic transportation problem application where locations 1 and 2 serve as the “supply nodes”, and locations 3, 4, 5 and 6 serve as the “demand nodes”. In addition to the typical supply and demand constraints that you need to include, make sure to also account for the constraints which will ensure that locations 3, 4, 5, and 6 each receive at least 5 cars.

Attachments:
Submitted by zext on Sat, 2012-04-14 02:21
teacher rated 73 times
4.90411
purchased one time
price: \$5.00

5

check attached file.

body preview (0 words)

........

file1.docx preview (244 words)

Use xxxxxx xx set up xxx solve xxx problem xxxxxx Make xxxx xx embed xxxx xxxxxxxxxxx xx xxx xxxxxx Programming xxxxxxx within your xxxxx solution. xxxx xxxxxxx is x xxxxxxx transportation problem application where xxxxxxxxx 1 xxx x serve xx the “supply xxxxx”, and locations 3, 4, 5 xxx x serve xx xxx “xxxxxx nodes”x xx addition xx the xxxxxxx supply and xxxxxx xxxxxxxxxxx that xxx xxxx xx xxxxxxxx make xxxx to also account xxx the xxxxxxxxxxx which will xxxxxx that locations 3, 4, 5, and x xxxx xxxxxxx xx xxxxx x cars.

Problem:

xxx Rent-A-Dent car rental xxxxxxx xxxxxx its xxxxxxxxx to xxxx up x rental car at one xxxxxxxx and return it to xxx of its xxxxxxxxxx Currently, xxx locations (1 and xx xxxx 16 xxx 18 surplus xxxxx respectively, and xxxx locations x xxxxxx and xx xxxx xxxx xx xxxxx The xxxxx of xxxxxxx the surplus xxxx from locations x and 2 xx the xxxxx xxxxxxxxx are summarized in xxx xxxxxxxxx table.

xxx
 Costs xx Transporting Cars Between xxxxxxxxx Location x Location

- - - more text follows - - -

file2.xls preview (56 words)

xxxx

xxxxxxxxxxxxxxxxx
 xxxxxxxxxxx xxxxxxxxxxxxxx xxxxx xx per xxxx Cars x x 5 x xxxxxxxxx 1 x xxxxx x 17.00 * 23.00 x 30.00 16 x x xxxxx x 18.00 * xxxxx x xxxxx xx Cars xxxxxx 10 10 xx x
Vancouver
xxx Deer
xxxxxxxxxx
xxxxxx
Edmonton
xxxxxxx

completed

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xxxxxxxxxxx Transportation xxxxx (\$ xxx xxxx 3 4 5 x 1 * 54.00 * xxxxx * 23.00 x xxxxx x * xxxxx * xxxxx * xxxxx * xxxxx Cars xxxxxxxxxxx xx Location: xxxx Cars 3 4 5 x Used xxxxxxxxx 1 x 10 1 5 xx xx x x x x x xx 18 Actual 9 10 xx x xxxx x 5 5 x xxxx xx xx 10 10 xxxxx Transportation Cost: * 730.00
xxxxxxxxx
Red xxxx
xxxxxxxxxx
Jasper
Vancouver
xxx Deer
xxxxxxxxxx
xxxxxx
xxxxxxxx
xxxxxxx
xxxxxxxx
Calgary

xxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 Problem xxxx xxxxxxx Solution xx xx 16 15 xx xx 18 xx xx 10 10 x
x
x
x
x
4
3
\$54
xxx
xxx
xxx
xxx
\$19
\$30
\$31
x
x
6
5
4
3
9
xx
1
9
x

Submitted by Kumail Raza on Sat, 2012-04-14 17:01
teacher rated 24 times
4.375
purchased 3 times
price: \$7.00

5

Solution to your question is attached

body preview (11 words)

Feel free to xxxxxxx xx any query. Best Regards Kumail xxxx

file1.xls preview (56 words)

data

xxxxxxxxxxxxxxxx
 xxxxxxxxxxx Transportation Costs (\$ xxx car) Cars x x x 6 Available x * 54.00 * xxxxx * 23.00 * 30.00 xx 2 x xxxxx * xxxxx x xxxxx x xxxxx 18 xxxx Needed 10 10 10 xx
xxxxxxxxx
Red Deer
Drumheller
xxxxxx
Edmonton
xxxxxxx

xxxxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 Rent-A-Dent xxxxxxxxxxxxxx Costs xx per car) 3 4 5 6 1 * xxxxx x 17.00 * 23.00 x xxxxx 2 x xxxxx * 18.00 x 19.00 * 31.00 xxxx xxxxxxxxxxx xx xxxxxxxxx Cars xxxx x x 5 x Used Available x 0 10 1 x 16 xx x 9 x x x xx xx Assigned x xx xx x xxxxxxx 5 x x x xxxxxx 10 xx 10 10 Total xxxxxxxxxxxxxx Cost: * 730.00
Vancouver
xxx xxxx
Drumheller
xxxxxx
xxxxxxxxx
Red xxxx
xxxxxxxxxx
Jasper
xxxxxxxx
xxxxxxx
Edmonton
xxxxxxx

xxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 Problem xxxx Optimal xxxxxxxx 10 8 xx 15 xx xx xx 10 xx 10 x x
x
x
6
5
x
3
xxx
xxx
xxx
xxx
\$23
xxx
xxx
xxx
1
x
6
x
4
x
x
xx
x
x
x