Details

This case study involves the Grainger Inc. company on page $449-451$ in the textbook. This exercise involves analyzing$/$calculating the cost of changin supply chain. Your job is to calculate the total costs of the old system and the total costs of the new system. After calculating these costs, you should be

To solve this problem you have to assume that you are working for the company, and your boss$/$supervisor is asking you to look at the current system a MBA level course, l expect everyone to be able to do this.

I expect everyone of you to do this case on your own without any help from me or the instructional coach $($Dr$.$ katie Lopez$).$ You're welcome to use the class. And, if you can figure out the answers, you are welcome to help others too. But, please try to answer the questions in away that it will help them $t$

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 an Hints:

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.

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)$

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