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