Consider the transportation model given in the Excel file Williamson. It is a model that is very

Question:

Consider the transportation model given in the Excel file Williamson. It is a model that is very similar to the Foster Generators model. Williamson produces a single product and has plants in Atlanta, Lexington, Chicago, and Salt Lake City and warehouses in Portland, St. Paul, Las Vegas, Tuscon, and Cleveland. Each plant has a capacity and each warehouse has a demand. Williamson would like to find a low-cost shipping plan. Mr. Williamson has reviewed the results and notices right away that the total cost is way out of line. Use the Formula Auditing Tools under the Formulas tab in Excel to find any errors in this model. Correct the errors. There are two errors in this model. Be sure to check every formula.


Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Quantitative Methods for Business

ISBN: 978-0324651751

11th Edition

Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam

Question Posted: