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
The following details were extracted from the standard cost card of a component:       Raw Materials              2.82 Kgs @ Rs.4.80 Kg.     Direct Labour            Type I   6

Determine the Incremental Cost A company currently makes a component that has the given unit cost structure Direct Material Shs. 100

Cost Classification Bases Costs can be classified on either more or one of the given bases as: a) Are the costs dependent on the level of output as like variable or are the

Process Costing Procedure 1. The production factory is divided into a number of methods. 2. An account is maintained and opened for every process. 3. Every process accou

What are the journal entries to recognize each of the below events. a.   The firm records bad debt expense of 5% of credit sales, which were $300.  The firm uses the Percentage

This question tested their knowledge of intended reporting but more importantly requisite them to apply their knowledge and consider the impact from the investors' perspective.

You are assisting the accountant on the preparation of the final accounts of a business with a year-end of 31 December. A trial balance has been drawn up and a suspense account ope

Support Department Cost Allocations. Riverside Furniture Company manufactures unfinished furniture for sale to retailers. Riverside has two support departments, Maintenance and Hu

A. Material Sampling -Analyzing Direct Material Costs You are reviewing a cost proposal, which includes an $800,200 direct material estimate. After Initial examination of the pro

Calculate the range of monthly financing rates for which the schedule of monthly cash flows is profitable: Month Cash Flow, $ -------------------- 0 -10,100 1 +23,000 2 -13,