Calculate the total cost for transporting the goods

Assignment Help Operation Management

Reference no: EM133488074

You should use MS excel to calculate all the costs involved. Please copy all your excel work to a MS Word document. I need to see the individual cost and the total costs for the old system and the new system.

Hints:

Question 1) You need to calculate the following costs first:

Port processing fee for both ports, LA and Seattle.
The transportation/rail costs from these two ports to Kansas City.
Unloading and quality check costs at Kansas City.

Question 2) Calculate the total cost for transporting the goods (by trucks) from Kansas City distribution center to all nine cities.

Total costs for current system will be the total of (1) and (2)

Question 3) Calculate the total cost for the new system

Port processing fee for both ports, LA and Seattle

Transportation/rail cost from Seattle port to LA

Unloading and quality check cost at LA.

LA Distribution Operating costs

Transportation costs by rail for 82% of the goods to Kansas City

Question 4) Calculate the total cost for transporting the goods (by trucks) from Kansas City to the other cities.

Total costs for the new system will be the total of (3) and (4).

Reference no: EM133488074

Questions Cloud

How do you think bmw integrates its various unique brands : MGT 321- How do you think BMW integrates its various unique brands into a global effort that works for them across the world's many global markets?

How geographically dispersed teams collaborate effectively : How do geographically dispersed teams collaborate effectively? Find at least three tools on the market that teams can use to collaborate on a geographically.

Describe one social service program that can be used : Describe one social service program that can be used with individuals experiencing age-related changes in physiology in late adulthood.

Identify three requirements of documentation : Identify three requirements of documentation. Explain how documentation requirements fulfill the legal obligations of the social worker.

Calculate the total cost for transporting the goods : Calculate the total cost for transporting the goods (by trucks) from Kansas City distribution center to all nine cities. Total costs for current system will be

What diagnostic exams do you want to order : What diagnostic exams do you want to order? Name 3 differential diagnoses based on this patient presenting symptoms?

Why do you think native communities succeeded in the case : Why do you think Native communities succeeded in this case but not the June 2023 Supreme Court decision in the Navajo Nation water case we touched on last class

Why are many strategic alliances temporary : ???Do you believe that penetration pricing or skim pricing will be better at raising a company's unit's operating profit in the long run? Why are many strategic

What was an important decision you made that had significant : Could you live without technology? Internet? Why or why not? What was an important decision you made that had significant effects on your life?

User Account

All Pages