Calculate the total transportation cost, Cost Accounting

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.
Posted Date: 2/25/2013 6:06:36 AM | Location : United States







Related Discussions:- Calculate the total transportation cost, Assignment Help, Ask Question on Calculate the total transportation cost, Get Answer, Expert's Help, Calculate the total transportation cost Discussions

Write discussion on Calculate the total transportation cost
Your posts are moderated
Related Questions
Allocation of Overhead Costs Allocation of overheads is the term utilized where the overhead cost item can be charged to a exact cost center without the requirement for any es

Pauline's Pastry Shop decides to remodel its offices this year. As part of the remodeling, Pauline's trades furniture with a cost of $12,000 that had been expensed in the year of p

A company manufactures two products, Product A manufactured in Process Y and Product B manufactured in Process Z. The following information is available for a period:

Methods Required To Allocate Joint Costs 1) Physical/Unit Measure 2) Constant gross margin rate 3) Net realizable value.

These are losses on account of uncollectable debts. While the amount due from debtors is irrecoverable, it is termed as bad debts. Bad debts, being loss are closed through transfer

This is difficult to perceive cash maintained in the vault as an investment. Fairly, you would be thinking that if we invest cash, then how can cash itself be an investment? Howeve

explain one operation: unit or output cost

Explanations on the correct fixation of selling price

The data set for the assignment is about breast cancer.  Some of these data have been changed for the purposes of this assignment so the results from the analysis of this file may

Glaser Health Products of Ranier Falls, Georgia, is organized functionally into three divisions: Operations, Sales, and Administrative. Purchasing, receiving, materials and product