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 06:30

Select all that apply. what do opponents of minimum wage believe are the results of minimum wage? increases personal income results in job shortages causes unemployment raises prices of goods

Answers: 1

Answer

Business, 22.06.2019 10:50

Bill dukes has $100,000 invested in a 2-stock portfolio. $62,500 is invested in stock x and the remainder is invested in stock y. x's beta is 1.50 and y's beta is 0.70. what is the portfolio's beta? do not round your intermediate calculations. round the final answer to 2 decimal places.

Answers: 2

Answer

Business, 22.06.2019 12:00

Which of the following is one of the advantages primarily associated with a performance appraisal? (a) it protects employees against discrimination on the basis of race. (b) it motivates employees to work on their shortcomings. (c) it encourages employees to play the role of the whistle-blower. (d) it accurately measures the resources of the firm.

Answers: 2

Answer

Business, 22.06.2019 13:10

Trey morgan is an employee who is paid monthly. for the month of january of the current year, he earned a total of $4,538. the fica tax for social security is 6.2% of the first $118,500 earned each calendar year, and the fica tax rate for medicare is 1.45% of all earnings for both the employee and the employer. the amount of federal income tax withheld from his earnings was $680.70. his net pay for the month is .

Answers: 1

Answer

You know the right answer?

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

Questions