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

Other questions on the subject: Business

Business, 22.06.2019 05:00, mjam85877

What is free trade? a. trade that is not subject to taxes or fees b. trade that governments do not interfere with c. trade with a high level of government regulation d. trade between states in the u. s. b

Answers: 1

continue

Business, 22.06.2019 11:30, zahradawkins2007

Marta communications, inc. has provided incomplete financial statements for the month ended march 31. the controller has asked you to calculate the missing amounts in the incomplete financial statements. use the information included in the excel simulation and the excel functions described below to complete the task

Answers: 1

continue

Business, 22.06.2019 19:50, annabanana1298

Juan's investment portfolio was valued at $125,640 at the beginning of the year. during the year, juan received $603 in interest income and $298 in dividend income. juan also sold shares of stock and realized $1,459 in capital gains. juan's portfolio is valued at $142,608 at the end of the year. all income and realized gains were reinvested. no funds were contributed or withdrawn during the year. what is the amount of income juan must declare this year for income tax purposes?

Answers: 1

continue

Business, 22.06.2019 20:10, Zayybabii

With signals from no-claim bonuses and deductibles, a. the marginal cost curve for careful drivers lies to the left of the marginal cost curve for aggressive drivers b. auto insurance companies insure more aggressive drivers than careful drivers because aggressive drivers have a greater need for the insurance c. the market for car insurance has a separating equilibrium, and the market is efficient d. most drivers pay higher premiums than if the market had no signals

Answers: 1

continue

Do you know the correct answer?

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