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
Jp Rhodes started a bowling club called " bowl them over". The following transactions took place 4 March 2012. 1. Bowling LTD transferred R20 000 bank account of the club as an in

Accounting for Job Order Costing 1.  Direct Labor  Dr W.I.P. Control Account Cr Cash Account 2.  Accrued Direct Wages Dr W.I.P. Control Account Cr Wages

You are required to conduct a detailed analysis of all the prime cost and overhead variances. You must create a fictitious company (and a fictitious cost object) which has at least

The following information is provided to you concerning Lydia Ltd as at 30 June 2012.  Assume a company tax rate of 30%. (i) The balance of rent received in advance in the balan

1) Jodie received a $2000 college entrance scholarship. Nine month later Brian was awarded a $2100 academic proficiency scholarship for his outstanding grades in the first year of

Piece Rate System - Labour Remuneration However an employee is paid a fixed amount for all units produced irrespective of time in use; the wages payable are computed like fo

The next year's budget for Benny, Inc., is given below: Product 1-2 Sales $945,000-688500 Variable costs 459,900-297,000 Fixed costs 300,000-3

Budgetary Planning and Control Budgeting refers to the process of quantifying the plans of an organization such as to enable it get its objectives in the defined duration.  Th

how marginal cost of a product is determined?

Assumptions of CVP This chapter has given information on how to apply CVP for the business analysis. Most of this analysis is keyed to the model of how profitability is impacte