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 22:35
due on Tue, 2012-04-17 22:24
answered 2 time(s)
willietanks is willing to pay $5.00
willietanks bought 58 out of 62 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 01:21
teacher rated 73 times
4.90411
purchased one time
price: $5.00

Answer rating (rated one time)

5

check attached file.

body preview (1 words)

xxxxxxxx

file1.docx preview (268 words)

xxx xxxxxx to xxx up and xxxxx the problem xxxxxx Make sure to embed your xxxxxxxxxxx xx the xxxxxx xxxxxxxxxxx xxxxxxx within your Excel solution. xxxx xxxxxxx xx x xxxxxxx xxxxxxxxxxxxxx xxxxxxx xxxxxxxxxxx where xxxxxxxxx x xxx 2 xxxxx xx xxx “supply nodes”, and locations xx xx 5 xxx x xxxxx xx the “demand nodes”x In addition xx the typical supply and demand xxxxxxxxxxx xxxx you xxxx xx xxxxxxxx xxxx sure xx xxxx xxxxxxx for xxx xxxxxxxxxxx xxxxx xxxx ensure xxxx locations xx xx 5, xxx 6 each receive at xxxxx 5 xxxxx

Problem:

The xxxxxxxxxxx car rental xxxxxxx xxxxxx its xxxxxxxxx xx pick up a xxxxxx xxx xx xxx location and xxxxxx it to any xx its xxxxxxxxxx xxxxxxxxxx xxx locations (1 and 2) have xx and xx surplus cars, xxxxxxxxxxxxx and four xxxxxxxxx ( 3,4,5, xxx 6) xxxx

- - - more text follows - - -


file2.xls preview (116 words)

data

xxxxxxxxxxx
xxxxxxxxxxx
Transportation Costs ($ per car) Cars
3 xx6xxxxxxxxx
x * 54.00 x xxxxx * xxxxx x 30.00 16
x x xxxxxx xxxxx x xxxxx* xxxxx xx
xxxx Neededxx xx 10 1
xxxxxxxxx
xxx Deer
Drumheller
Jasper
xxxxxxxx
Calgary

xxxxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Rent-A-Dent
Transportation xxxxx ($ per xxxx
x4 x6
1 * xxxxx * xxxxx* 23.00x 30.00
xx 24.00 x xxxxx * xxxxxx 31.00
xxxx Transported to Location: xxxx xxxx
xxx xxxxxAvailable
xx xxx 516 16
2 x x 90 xx18
Actual x 10xx5
Min.5 5x x
xxxxxx10xxxx
Total Transportation Cost: * 730.00
Vancouver
xxx Deer
xxxxxxxxxx
Jasper
Vancouver
Red xxxx
xxxxxxxxxx
Jasper
Edmonton
Calgary
xxxxxxxx
Calgary

xxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxx
Problem xxxx Optimal xxxxxxxx
1010
16 15
xx10
1810 xxxx
xx x
x
x
6
5
4
3
$54
xxx
$17
xxx
xxx
$19
$30
$31
x
x
x
5
4
3
9
10
x
9
5


Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Answer
Submitted by Kumail Raza on Sat, 2012-04-14 16: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)

xxxx xxxx to contact xx any query. Best xxxxxxx xxxxxx Raza

file1.xls preview (116 words)

xxxx

xxxxxxxxxxxxxxxxx
Rent-A-Dent
Transportation xxxxx ($ xxx car)xxxx
3 x 56xxxxxxxxx
x * 54.00* 17.00x xxxxx * 30.00 xx
2 x xxxxx* 18.00 x 19.00 x 31.0018
xxxx Needed xx10 1010
Vancouver
xxx xxxx
Drumheller
Jasper
xxxxxxxx
xxxxxxx

completed

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Rent-A-Dent
xxxxxxxxxxxxxx xxxxx ($ xxx car)
x 4x 6
x x 54.00* 17.00x 23.00x 30.00
x * xxxxx x 18.00* 19.00* xxxxx
Cars xxxxxxxxxxx to Location: CarsCars
xxx 6 xxxxxxxxxxxxx
1 x 10 1 5 xx16
xx xx01818
xxxxxxxxxxx 10 x
Minimum5xx x
xxxxxx xx 1010 xx
Total Transportation Cost: * 730.00
Vancouver
Red xxxx
xxxxxxxxxx
xxxxxx
Vancouver
Red xxxx
Drumheller
Jasper
xxxxxxxx
xxxxxxx
xxxxxxxx
xxxxxxx

network

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Problem DataOptimal xxxxxxxx
xxx
xx 15
xx 10
1810 xx xx
4 6
1
2
6
x
x
3
$54
xxx
$17
xxx
xxx
$19
$30
$31
1
2
x
5
4
x
x
xx
9
5
1


Buy this answer

Try it before you buy it
Check plagiarism for $2.00