Need help on MG375DLBU1A2020 Production & Operations Mgmt week 7 home work

1)

Evaluate the current China/Taiwan logistics costs. Assume a current total volume of 190,000 CBM and the 89% is shipped direct from the supplier plants in containers. Use the data from the case and assume that the supplier loaded containers are 85% full. Assume that consolidation centers are run at each of the four port locations. The consolidation centers only use 40’ containers and fill them to 96% capacity. Assume that it costs $480 to ship a 20’container and $600 to ship a 40’ container. What is the total cost to get the containers to the United States? Do not include United States port costs in this part of the analysis.

2)

Evaluate an alternative that involves consolidating all 20’ volume and using only a single consolidation center in Shanghai/Ningbo. Assume that all the existing 20’ volume and the existing consolidation center volume were sent to this single consolidation by suppliers. This new consolidation center volume would be packed into 40’ containers filled to 96% and shipped to the United States. The existing 40’ volume would still be shipped direct from the suppliers at 85% capacity utilization.

3)

What should be done based on your analytics analysis? What have you not considered that may make your analysis invalid or that may strategically limit success? What do you think Grainger management should do?

4) A manufacturer has decided to locate a new factory in northwestern United States to serve growing demand in that market. It has narrowed the potential sites down to two finalists, City A and City B. It has developed a list of important factors to consider in selection a site, and rated each as shown in the following table

Item Description A B

Utility Rates 100 115

Availability of skilled labor 78 75

Tax rates 40 35

Transportation 46 38

Proximity to suppliers 35 34

Quality of life 19 16

Total 318 313

Base on the data, which city appears to be better choice?