Business, 03.04.2021 01:00 SKYBLUE1015

Consider the transportation model in the Chapter 7 webfile Williamson, which is very similar to the Foster Generators model (section 7.3). 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. (Hint: The model contains two errors. Be sure to check every formula). Williamson Manufacturing
Transportation Model
Data
Shipping Cost Per Unit
Portland St. Paul Las Vegas Tuscon Cleveland Supply
Atlanta $2.17 $0.92 $1.75 $1.50 $0.56 10,000
Lexington $1.97 $0.61 $1.68 $1.53 $0.22 10,000
Chicago $1.71 $0.37 $1.53 $1.41 $0.34 15,000
Salt Lake City $0.63 $0.99 $0.35 $0.58 $1.57 8,000
Demand 5,000 15,600 5,000 3,750 4,570
Model
Shipping Cost $45,732,968
Units Shipped
Portland San Jose Las Vegas Tuscon Colo. Sprngs Units Shipped
Atlanta 0 0 0 3,750 0 3,750
Cincinnati 0 2,600 0 0 4,570 7,170
Chicago 2,000 13,000 0 0 0 15,000
Salt Lake City 3,000 0 5,000 0 0 8,000
Units Received 5,000 15,600 5,000 3,750 4,570

Answers: 1

Show answers

Another question on Business

Business, 22.06.2019 05:30

Excel allows you to take a lot of data and organize it in one document. what are some of the features you can use to clarify, emphasize, and differentiate your data?

Answers: 2

Answer

Business, 22.06.2019 09:40

The wall street journal reported that walmart stores inc. is planning to lay off 2,300 employees at its sam's club warehouse unit. approximately half of the layoffs will be hourly employees (the wall street journal, january 25-26, 2014). suppose the following data represent the percentage of hourly employees laid off for 15 sam's club stores. 55 56 44 43 44 56 60 62 57 45 36 38 50 69 65 (a) compute the mean and median percentage of hourly employees being laid off at these stores. (b) compute the first and third quartiles. (c) compute the range and interquartile range. (d) compute the variance and standard deviation. (e) do the data contain any outliers? (f) based on the sample data, does it appear that walmart is meeting its goal for reducing the number of hourly employees?

Answers: 1

Answer

Business, 22.06.2019 11:00

Aprofessional does specialized work that's primarily: degree based. medical or legal. well paying. intellectual and creative

Answers: 2

Answer

Business, 22.06.2019 11:30

What would you do as ceo to support the goals of japan airlines during the challenging economics that airlines face?

Answers: 1

Answer

You know the right answer?

Consider the transportation model in the Chapter 7 webfile Williamson, which is very similar to the...