OM 503 Assignment 2015

| October 3, 2018

.gif”>

Determine which location, Toledo or Cincinnati, provides the
lower transportation costs. Hint: the rows 1, 2 and 3 represent the existing
manufacturing facilities, while the columns A, B and C represent the existing
demand locations. You need to create a 4th row utilizing the Toledo
location information and solve the linear programming problem to determine the
minimum total costs. Next you will resolve the problem again as a linear
programming problem utilizing the Cincinnati location information to determine
if it yields a lower cost than Toledo.

Set up this problem as a linear programming problem and find the optimal
solution using Excel’s Solver. Your spreadsheet file should have two worksheets
in it named “Toledo” and “Cincinnati”, respectively.

Get a 20 % discount on an order above $ 40
Use the following coupon code:
LOBSTER
Positive SSL