DATAFile: Williamson Consider the transportation model in the file Williamson, which is very similar to the Foster Generators model discussed in this chapter. Williamson produces a single product and has plants in Atlanta, Lexington, Chicago, and Salt Lake City and warehouses in Portland, St. Paul, Las Vegas, Tucson, 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 tool under the Formulas tab in Excel to find any errors in this model. Correct the errors. (Hint: The model contains two errors. Be sure to check every formula.) After correcting all errors what is the resulting shipping cost (in dollars) calculated by the model. (Round your answer to the nearst dollar.) $ Need Help? Read It A B D E F G I 1 Williamson Manufacturing 2 Transportation Model 3 Data Shipping Cost Per Unit 000 von A 7 8 Atlanta 9 Lexington 10 Chicago 11 Salt Lake City 12 Demand Portland $2.17 $1.97 $1.71 $0.63 5,000 St. Paul $0.92 $0.61 $0.37 $0.99 15,600 Las Vegas $1.75 $1.68 $1.53 $0.35 5,000 Tucson $1.50 $1.53 $1.41 $0.58 3,750 Cleveland $0.56 $0.22 $0.34 $1.57 4,570 Supply 10,000 10,000 15,000 8,000 13 14 Model 15 16 17 Shipping Cost $45,732,968 18 19 Units Shipped 20 21 Portland St. Paul Las Vegas 0 0 0 Tucson 3,750 0 0 22 Atlanta 23 Lexington 24 Chicago 25 Salt Lake City 26 Units Received 0 Cleveland Units Shipped 0 3,750 4,570 7,170 0 15,000 0 8,000 4,570 0 2,000 3,000 5,000 0 2,600 13,000 0 15,600 0 5,000 5,000 3,750 27