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
Prepare a spreadsheet of an overhead budget for the company in Problem 5 on page 216 of the textbook. You have been running a construction company out of your home with your spouse

Amy earns $35,000 working part time. Consequently, she is not eligible to participate in her employer's retirement plan or health insurance program. Amy's expenses are summarized a

Apportionment of Overheads Apportionment of overheads occurs whereas the net value of an overhead item is shared among more or two cost centers that employ the overheads. Th

Atlanta Company stock is expected to follow an exponential growth rate. The relationship between the current stock price P0, future price PT after time T, and the continuously comp

Erlander Company uses a job order cost accounting system. On November 1 2013, $15,000 of direct materials and $3,500 of indirect materials were requisitioned for production. Prepar

Cost Book-Keeping In cost account accounts, extensive employ is made of control accounts that are based in the similar principles as those utilized in financial accounts.  Two

Constant Gross Margin Rate This method assumes that every product contributes an equal percentage of gross profit for every shilling of sales. It works back from gross margin

Time Rate System - Labour Remuneration It may be a high day rate or a flat time rate. Under flat time rate, all worker is paid for the time spend without considering the vol

under which type of asset the investment comes

Example of Job Order Costing The given transactions were made by a company in the month of December. Direct Materials a) 8,000/- was bought on credit, out of these