Calculate the total transportation cost, Cost Accounting

Assignment Help:

The sunshine tomato soup shippers produce tomato soup at three west coast canneries in Bakersfield, phoenix, and Eugene. The soup is shipped to four regional warehouses. Due to high demand, the company is considering opening a fourth cannery. The company is considering opening up the fourth cannery either at san diego, san jose, los angeles, or Stockton. The following table shows the cost of shipping a case from each cannery [existing and proposed] to each regional warehouse. The company wishes to ship all of its cannery capacity to the regional warehouses so that monthly transportation cost is minimized.

 

Source                         seattle,             los angeles,      Denver,           Dallas,             Maxium

                                    Washington     California        Colorado         Texas               monthly

                                                                                                                                    Cannery capacity

Phoenix, Arizon             $2.80                  $0.60             $1.20               $1.50              70,000

Eugene, Oregon            $0.50                   $1.20             $2.20                $2.90              80,000

Bakersfield, California    $1.80                   $04.0              $1.80               $2.20              90,000

Los angeles, California   $1.70                  $0.75              $1.75               $2.50              110,000

San diego, California      $1.80                   $0.60             $1.60               $2.60              110,000

San jose, California       $1.40                   $0.70             $2.00               $2.40              110,000

Stockton, California       $1.60                    $0.80            $1.80               $2.50               110,000

Monthly warehouse   

       Demand                 80,000                  90,000            70,000             100,000

 

  •  What is the total transportation cost if each of the four sites should be selected?
  •  White site should be selected to locate the next cannery? Why?
  •  State the shipment schedule associated with the selected site.
  •  For the optimum solution determined, perform Sensitivity Analysis and interpret the results.

Related Discussions:- Calculate the total transportation cost

What is the gain or loss on the sale, a machine is purchased on july 1 2009...

a machine is purchased on july 1 2009 for $181,500. It has an expected useful life of 11 years and no salvage value. After five years, the machine is sold for $98,000 cash. What is

Illustration of overhead variance analysis, Illustration of Overhead Varian...

Illustration of Overhead Variance Analysis Again for intentions of our demonstrations in overhead variance analysis, we will suppose the given basic data for company in the pr

Inventory valuation, How the FIFO, LIFO and AW problems can be solved?

How the FIFO, LIFO and AW problems can be solved?

Profit and loss statement, If a company trades in a building towards a new ...

If a company trades in a building towards a new building and does not recognize a gain or loss (because of code section 1031), will this transaction affect the cash flows statement

Contract account, i want to understand everything about contract account

i want to understand everything about contract account

Disadvantages of standard costing, Disadvantages of Standard Costing ...

Disadvantages of Standard Costing 1. The system of standard costing is very expensive to install : A lot of money is spent in studying output requirements in terms of materia

What is the amount of overhead applied, Morrow Company applies overhead bas...

Morrow Company applies overhead based on direct labor hours. At the beginning of the year, Morrow estimates overhead to be $620,000, machine hours to be 180,000, and direct labor h

Valuation of inventory or closing and issues stocks, Valuation of Inventory...

Valuation of Inventory or Closing and Issues Stocks Valuation of inventory aims on attaching a monetary value in the issued or stores for production. It is useful in producing

CONCEPT AND OBJECTIVES, what are the concept and objectives of cost account...

what are the concept and objectives of cost accounting?

What is bad debt expense, What is bad debt expense, using the aging method ...

What is bad debt expense, using the aging method (also called the "percentage of receivables" method), given the following set of facts?   A firm has $80 of gross accounts recei

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd