subject
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

ansver
Answers: 1

Another question on Business

question
Business, 21.06.2019 21:00
During the first month of operations, martinson services, inc., completed the following transactions: jan 2 martinson services received $65,000 cash and issued common stock to the stockholders. 3 purchased supplies, $1,000, and equipment, $12,000, on account. 4 performed services for a customer and received cash, $5,500. 7 paid cash to acquire land, $39,000. 11 performed services for a customer and billed the customer, $4,100. martinson expects to collect within one month 16 paid for the equipment purchased january 3 on account. 17 paid for newspaper advertising, $600. 18 received partial payment from customer on account, $2,000. 22 paid the water and electricity bills, $430. 29 received $2,600 cash for servicing the heating unit of a customer. 31 paid employee salary, $2,900. 31 declared and paid dividends of $1,800. requirements 1. record each transaction in the journal. key each transaction by date. explanations are not required. 2. post the transactions to the t-accounts, using transaction dates as posting references. label the ending balance of each account bal, as shown in the chapter. 3. prepare the trial balance of martinson services, inc., at january 31 of the current year. 4. mark martinson, the manager, asks you how much in total resources the business has to work with, how much it owes, and whether january was profitable (and by how much)?
Answers: 1
question
Business, 22.06.2019 15:00
Oerstman, inc. uses a standard costing system and develops its overhead rates from the current annual budget.the budget is based on an expected annual output of 120,000 units requiring 480,000 direct labor hours.(practical capacity is 500,000 hours)annual budgeted overhead costs total $772,800, of which $556,800 is fixed overhead.a total of 119,300 units, using 478,000 direct labor hours, were produced during the year.actual variable overhead costs for the year were $260,400 and actual fixed overhead costs were $555,450.required: 1. compute the fixed overhead spending variance and indicate if favorable or unfavorable.2. compute the fixed overhead volume variance and indicate if favorable or unfavorable.
Answers: 3
question
Business, 22.06.2019 19:40
On april 1, santa fe, inc. paid griffith publishing company $2,448 for 36-month subscriptions to several different magazines. santa fe debited the prepayment to a prepaid subscriptions account, and the subscriptions started immediately. what amount should appear in the prepaid subscription account for santa fe, inc. after adjustments on december 31 of the first year assuming the company is using a calendar-year reporting period and no previous adjustment has been made?
Answers: 1
question
Business, 22.06.2019 21:00
After hearing a knock at your front door, you are surprised to see the prize patrol from a large, well-known magazine subscription company. it has arrived with the good news that you are the big winner, having won $21 million. you have three options.(a) receive $1.05 million per year for the next 20 years.(b) have $8.25 million today.(c) have $2.25 million today and receive $750,000 for each of the next 20 years.your financial adviser tells you that it is reasonable to expect to earn 13 percent on investments.
Answers: 3
You know the right answer?
Consider the transportation model in the Chapter 7 webfile Williamson, which is very similar to the...
Questions
question
Mathematics, 30.09.2019 01:30
question
Geography, 30.09.2019 01:30
question
History, 30.09.2019 01:30
question
Social Studies, 30.09.2019 01:30
question
Mathematics, 30.09.2019 01:30
question
Mathematics, 30.09.2019 01:30
Questions on the website: 13722363