Show me how to post my homework

Just do my homework!

  • HTML tags will be transformed to conform to HTML standards.
  • Add rel="nofollow" to external links
Question
Submitted by willietanks on Fri, 2012-04-13 23:35
due on Tue, 2012-04-17 23:24
answered 2 time(s)
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: 
Answer
Submitted by zext on Sat, 2012-04-14 02:21
teacher rated 73 times
4.90411
purchased one time
price: $5.00

Answer rating (rated one time)

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 xxxxCars
x x 5x xxxxxxxxx
1x xxxxxx 17.00* 23.00x 30.00 16
x x xxxxx x 18.00 * xxxxxx xxxxxxx
Cars xxxxxx10 10 xx x
Vancouver
xxx Deer
xxxxxxxxxx
xxxxxx
Edmonton
xxxxxxx

completed

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxx
Transportation xxxxx ($ xxx xxxx
345 x
1 * 54.00 * xxxxx* 23.00x xxxxx
x* xxxxx* xxxxx * xxxxx* xxxxx
Cars xxxxxxxxxxx xx Location:xxxxCars
345x Used xxxxxxxxx
1 x101 5xxxx
x xxx x xx18
Actual 9 10xx x
xxxx x 5 5x
xxxxxx xx1010
xxxxx Transportation Cost:* 730.00
xxxxxxxxx
Red xxxx
xxxxxxxxxx
Jasper
Vancouver
xxx Deer
xxxxxxxxxx
xxxxxx
xxxxxxxx
xxxxxxx
xxxxxxxx
Calgary

xxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Problem xxxxxxxxxxx Solution
xx xx
16 15
xxxx
18 xxxx 10
10x
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


Buy this answer

Try it before you buy it
Check plagiarism for $2.00

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

Answer rating (rated one time)

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 xxxxxx xxxxx18
xxxx Needed101010 xx
xxxxxxxxx
Red Deer
Drumheller
xxxxxx
Edmonton
xxxxxxx

xxxxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Rent-A-Dent
xxxxxxxxxxxxxx Costs xx per car)
3 4 5 6
1 * xxxxxx 17.00* 23.00x xxxxx
2 x xxxxx* 18.00x 19.00 * 31.00
xxxx xxxxxxxxxxx xx xxxxxxxxx Carsxxxx
xx5xUsedAvailable
x 0 101x 16 xx
x9 x xx xxxx
Assigned xxx xx x
xxxxxxx 5 xx x
xxxxxx10xx10 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
108
xx 15
xxxx
xx 10xx 10
xx
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


Buy this answer

Try it before you buy it
Check plagiarism for $2.00