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

xxxxxxxxxxxxxxxxxxxxxx | |||||

Transportation Costs ($ per car) | Cars | ||||

3 | x | x | 6 | xxxxxxxxx | |

x | * 54.00 | x xxxxx | * xxxxx | x 30.00 | 16 |

x | x xxxxx | x xxxxx | x xxxxx | * xxxxx | xx |

xxxx Needed | xx | xx | 10 | 1 |

# xxxxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxRent-A-Dent | ||||||

Transportation xxxxx ($ per xxxx | ||||||

x | 4 | x | 6 | |||

1 | * xxxxx | * xxxxx | * 23.00 | x 30.00 | ||

x | x 24.00 | x xxxxx | * xxxxx | x 31.00 | ||

xxxx Transported to Location: | xxxx | xxxx | ||||

x | x | x | x | xxxx | Available | |

x | x | xx | x | 5 | 16 | 16 |

2 | x | x | 9 | 0 | xx | 18 |

Actual | x | 10 | xx | 5 | ||

Min. | 5 | 5 | x | x | ||

xxxx | xx | 10 | xx | xx | ||

Total Transportation Cost: | * 730.00 |

# xxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxProblem xxxx | Optimal xxxxxxxx | ||

10 | 10 | ||

16 | 15 | ||

xx | 10 | ||

18 | 10 | xx | xx |

xx | x |

Try it before you buy it |

Answer rating (rated one time)

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

xxxxxxxxxxxxxxxxxRent-A-Dent | |||||

Transportation xxxxx ($ xxx car) | xxxx | ||||

3 | x | 5 | 6 | xxxxxxxxx | |

x | * 54.00 | * 17.00 | x xxxxx | * 30.00 | xx |

2 | x xxxxx | * 18.00 | x 19.00 | x 31.00 | 18 |

xxxx Needed | xx | 10 | 10 | 10 |

# completed

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxRent-A-Dent | ||||||

xxxxxxxxxxxxxx xxxxx ($ xxx car) | ||||||

x | 4 | x | 6 | |||

x | x 54.00 | * 17.00 | x 23.00 | x 30.00 | ||

x | * xxxxx | x 18.00 | * 19.00 | * xxxxx | ||

Cars xxxxxxxxxxx to Location: | Cars | Cars | ||||

x | x | x | 6 | xxxx | xxxxxxxxx | |

1 | x | 10 | 1 | 5 | xx | 16 |

x | x | x | x | 0 | 18 | 18 |

xxxxxxxx | x | xx | 10 | x | ||

Minimum | 5 | x | x | x | ||

xxxxxx | xx | 10 | 10 | xx | ||

Total Transportation Cost: | * 730.00 |

# network

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxProblem Data | Optimal xxxxxxxx | ||

xx | x | ||

xx | 15 | ||

xx | 10 | ||

18 | 10 | xx | xx |

4 | 6 |

Buy this answer | Try it before you buy it |