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.
Answer rating (rated one time)
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.
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.
Costs xx Transporting Cars Between xxxxxxxxx
- - - more text follows - - -
file2.xls preview (56 words)
|xxxxxxxxxxxxxx xxxxx xx per xxxxxxxx||Cars|
|1x||x xxxxxx||x 17.00x||* 23.00x||x 30.00||16|
|x||x xxxxx||x 18.00||* xxxxxx||x xxxxxx||xx|
|Transportation xxxxx ($ xxx xxxx|
|1||* 54.00||* xxxxxx||* 23.00x||x xxxxx|
|xx||* xxxxxx||* xxxxx||* xxxxxx||* xxxxx|
|Cars xxxxxxxxxxx xx Location:xxxx||xxxxx||Cars|
|xxxxx Transportation Cost:x||* 730.00|
|Problem xxxxxxxxxx||xxxxxxx Solution|
Try it before you buy it