# 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.

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.

xxxCosts xx Transporting Cars Between xxxxxxxxx | ||

Location x | Location |

- - - more text follows - - -

file2.xls preview (56 words)

# xxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxx | |||||

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 |

# completed

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | ||||||

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 |

# xxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxProblem xxxx | xxxxxxx Solution | ||

xx | xx | ||

16 | 15 | ||

xx | xx | ||

18 | xx | xx | 10 |

10 | x |

Try it before you buy it |

Answer rating (rated one time)

## 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

xxxxxxxxxxxxxxxxxxxxxxxxxxx | |||||

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

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxRent-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 |

# xxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxProblem xxxx | Optimal xxxxxxxx | ||

10 | 8 | ||

xx | 15 | ||

xx | xx | ||

xx | 10 | xx | 10 |

x | x |

Buy this answer | Try it before you buy it |