Assignment Print View 1. A out of 3.00 points Analytics Exercise 15-1 (Algo Grainger: Reengineering the China/U.S. Supply Chain W. W. Gairo Inc. is a leading supplier of maintenance, repair and operating (MRO) products to buses and instructions in the United Canada, and Mexico, with an expanding presence in Japan, India China and Parama. The company works with more than 8.000 persons an extensive website www granger.com where Grainger offers nearly 15 milion products. The products range from industrial Adhesives used muntacturing, to land tod janitorial plus lohngement and power tool. When something is readed by one of its nomen en needed quickly to quick service and producibiro way drivers le Granger's success Your assignment involves tyng U.S. distribution in Granger'a wply chain Granger works with over 250 support the China and Taiwan region. These suppliers produce products to Granger's specification and ship to the United States using on right from our major por Through custom, the 20- and 40 foot containers are thipped by no toringer's con dibution certer In Kaly Karoo. The contains are unloaded and quality is checked in Ka Cly. From the indivitems are sent to regional Worches in nine U.S.focations, a Canada she and Mexico Grainger: U.S. Distribution In the United approximately 40 percent of the containers enter in Seat Weston, and prot at the Los Angeles, Calomport conter. Variable for proting at the port are per cubic meter (COM) bohol and St. The role for in the corner to as Clys 0.0016 COM In Kansas City the containers wounloaded and processed through a witty check. This couts per Cord Avery percentage of the material is actually sent back to the supplier, but enors notly and package found that ants tems are stored in the Kores Cly distribution center, which werven vine warehouses in the United States. home went to warthosh Carada and Merce, but for the purposes of this study we focus on the United. The new each place or their canal contains all me to be uplashed City ich chcem on the order consolidate teontopolis on foot into each w Truck 0021 COM pore. The demand forecast for the spel om China Town for next year in elke meters and product we given in the owing to DE MANGE ) DISTANCE AVERWOE Cleveland Nuk 2010 2.000 2. achie Chego Merch Long NO 1070 WAREHOUSE Kansas Chy 20040 17.10 MESTRON SEATTLE 1.000 3.110 MILES FROM KANSAS CITY MILES FROM LOS ANGELES 0 1.100 2,200 7.100 1100 2.130 010 1.10 670 2,410 100 420 410 1470 1,500 . 1160 22 TO 16.100 17.10 22.780 Green 2030 1,000 2000 2.290 2,120 1090 Dallas Ah ah percentage of durant from whether southeast of Kane Chy the insured concerne COM DO 18 per of the total voto shed to Kansas City and then we had to the Los Mosh The double transportation could porno temned if a wonnier word in Los Ange Them belo malena at a fewport by radio a Los Angeles tonele, which was located at the current location of the Lone who it is maled that the Los Angeles you to upgraded at a one-of 1,500,000 and the operated for $360,000 year in the new The variable cou for doing this would be 18.00 per COM processed, which include the cost to move the containers from the Los Angeport to Altet the materiais procused in connesthe announceded to replenish the Les gewo (24,180 CM peryone www They expect fra very intie would need to be heltok i Los Angeles warehouse her the new was wing for about x months Grange management that may be poste to make the son but they are not sure wyse any money and what would be good to change The data is me have been developed for the and do not rews on ate. The data, though, Orofanaclul problem that are and time companies to attend the supply Ielative to the .. vrhutoruitwork can contrasemne 40 percent of the wees Beste and copercent in Los Angel dhe port process for federe caning at both of 800 COM A everything rared to the Kansas y distribution center by where is noded and quality checked Armatat al volume the referred by neisting warehouses in the United (Do not round Intermediate calculation and round your new to near whole number) http:/exto mhaduction.com podo-c15SingaPrintviewingleton - 1 Aposto13252715104547050 wid1325271634 20 1 Assignment Print View K.C Distribution Center Only Port to DC Costs Volume Port Distance K.C. Unload and Pet Rail Costs CBM Processing to K.C. Q.C 190,070 $ 8.00 $ 0.0018$ 6.00 Total Costs Basic data Seattle port % LA port % KC Distribution Center Only DC to Warehouse Costs Warehouse Truck Freight Costs Kansas City Cleveland Newark Jacksonville Chicago Greenville Memphis Dallas Los Angeles Total Total cost of current system 1_12_3200CS-2002 References Worksheet Difficulty: 3 Hard Analytics Exercise 15-1 Learning Objective: 15-03 (Algo) Analyze logistics-driven location decisions