Question 13 30 pts Oh-oh...Management Wants a Network Management likes the combination receiving/distribution warehouse concept but would like to consider what would happen if they expanded this concept and had 4 regional receiving/distribution warehouses; one each in the: 1. Northeastern region of the U.S. 2. Southwestern region of the U.S. 3. Southeastern region of the U.S. 4. Northwestern regional of the U.S. Using the square root rule, how many units of inventory would have to be stored in our warehouse network each year if we expanded to a regional concept? Yis as a Location Chicago, IL Customer Chippawa Falls, WI Customer Edgewater, FL Customer Houghton, MI Customer Ironwood, MI Customer Jaab Lake, Ontario Customer Jacksonville, FL Customer Jessup, MD Customer London, Ontario Customer Marquette, WI Customer Moosonee, Ontario Customer New York, NY Customer Phillipsburg, NJ Customer Portland.MA Customer Saginaw, MI Customer Sarnia, Ontario Customer Thunder Bay, Ontaric Customer Traverse City, MI Customer Brooklyn, NY Supplier Chippawa Falls, WI Supplier Eureka, CA Supplier Helena, MT Supplier Lexington, KY Supplier Moorehead, MN Supplier New York, NY Supplier San Francisco, CA Supplier San Jose, CA Supplier Sault St Marie, MI Supplier Seattle, WA Supplier St. Cloud, MN Supplier St. Louis, MO Supplier Traverse City, MI Supplier Longitu de 87.86 W 91.39 W 80.90 W 89.00 W 89.74 W 82.97 W 81.66 W 76.77 W 81.50 W 89.14 W 80.83 W 74.00 W 75.11 W 70.25 W 83.95 W 82.50 W 89.50 W 85.60 W 73.58 W 91.39 W 124.00 W 112.02 W 84.30 W 96.76 W 74.00 W 122.30 W 122.00 W 84.37 W 122.40 W 94.13 W 90.00 W 85.60 W Latitud e 42.32 N 44.93 N 29.00 N 47.50 N 47.50 N 51.08 N 30.33 N 39.15 N 42.00 N 43.74 N 53.80 N 40.48 N 40.44 N 43.52 N 43.42 N 42.93 N 48.00 N 44.75 N 40.22 N 44.93 N 40.45 N 46.60 N 38.00 N 46.86 N 40.48 N 37.55 N 37.00 N 46.48 N 47.32 N 45.55 N 38.42 N 44.75 N Annual Annual Units Sales Tradin Bought/S TO: 3 7,000 $805,000 3 100 $16,500 7 425,200 $12,760,000 8 360 $52,200 5 200 $32,000 11 103,680 $7,776,000 9 87,000 $7,395,000 8 160,560 $9,633,600 9 1,292,000 $6,460,000 9 340 $51,000 6 546,740 $8,201,100 4 1,000 $135,000 8 2,200 $275,000 9 200,320 $8,012,800 6 1,600 $208,000 8 47,000 $4,230,000 7 300 $46,500 2 400 $56,000 6 144,000 $3,420,000 2 120,000 $3,000,000 9 2,160,000 $13,500,000 3 512,000 $8,960,000 7 100,000 $2,625,000 4 780,000 $9,750,000 5 80,000 $2,200,000 7 3,600,000 $6,750,000 2 1,520,000 $13,300,000 5 584,000 $9.490,000 1 360,000 $7.200,000 2 720,000 $9,900,000 1 24,000 $720,000 2 800,000 $9,000,000 Annual Veight Shipped 35,000 500 2,126,000 1,800 1,000 518,400 435,000 802,800 6,460,000 1,700 2,733,700 5,000 11,000 1,001,600 8,000 235,000 1,500 2,000 180,000 150,000 2,700,000 640,000 125,000 975,000 100,000 4,500,000 1,900,000 730,000 450,000 900,000 30,000 1,000,000 Average Transit Time 5.7 5.5 4.3 4.1 4.6 5.9 4.8 5.8 5.9 5.0 4.0 4.4 4.9 4.3 4.9 4.7 4.7 5.6 5.6 4.8 4.6 4.8 5.6 4.1 5.8 4.0 4.7 5.5 4.2 4.9 5.6 4.0 Variation in Transit Time - 1.9 1.3 1.4 1.6 1.2 1.8 1.1 1.7 1.1 1.5 1.2 1.3 2.0 1.5 1.1 1.6 1.3 1.6 1.5 1.4 1.9 1.8 1.4 13 1.7 1.9 1.2 1.6 1.9 1.3 1.4 1.9 Question 13 30 pts Oh-oh...Management Wants a Network Management likes the combination receiving/distribution warehouse concept but would like to consider what would happen if they expanded this concept and had 4 regional receiving/distribution warehouses; one each in the: 1. Northeastern region of the U.S. 2. Southwestern region of the U.S. 3. Southeastern region of the U.S. 4. Northwestern regional of the U.S. Using the square root rule, how many units of inventory would have to be stored in our warehouse network each year if we expanded to a regional concept? Yis as a Location Chicago, IL Customer Chippawa Falls, WI Customer Edgewater, FL Customer Houghton, MI Customer Ironwood, MI Customer Jaab Lake, Ontario Customer Jacksonville, FL Customer Jessup, MD Customer London, Ontario Customer Marquette, WI Customer Moosonee, Ontario Customer New York, NY Customer Phillipsburg, NJ Customer Portland.MA Customer Saginaw, MI Customer Sarnia, Ontario Customer Thunder Bay, Ontaric Customer Traverse City, MI Customer Brooklyn, NY Supplier Chippawa Falls, WI Supplier Eureka, CA Supplier Helena, MT Supplier Lexington, KY Supplier Moorehead, MN Supplier New York, NY Supplier San Francisco, CA Supplier San Jose, CA Supplier Sault St Marie, MI Supplier Seattle, WA Supplier St. Cloud, MN Supplier St. Louis, MO Supplier Traverse City, MI Supplier Longitu de 87.86 W 91.39 W 80.90 W 89.00 W 89.74 W 82.97 W 81.66 W 76.77 W 81.50 W 89.14 W 80.83 W 74.00 W 75.11 W 70.25 W 83.95 W 82.50 W 89.50 W 85.60 W 73.58 W 91.39 W 124.00 W 112.02 W 84.30 W 96.76 W 74.00 W 122.30 W 122.00 W 84.37 W 122.40 W 94.13 W 90.00 W 85.60 W Latitud e 42.32 N 44.93 N 29.00 N 47.50 N 47.50 N 51.08 N 30.33 N 39.15 N 42.00 N 43.74 N 53.80 N 40.48 N 40.44 N 43.52 N 43.42 N 42.93 N 48.00 N 44.75 N 40.22 N 44.93 N 40.45 N 46.60 N 38.00 N 46.86 N 40.48 N 37.55 N 37.00 N 46.48 N 47.32 N 45.55 N 38.42 N 44.75 N Annual Annual Units Sales Tradin Bought/S TO: 3 7,000 $805,000 3 100 $16,500 7 425,200 $12,760,000 8 360 $52,200 5 200 $32,000 11 103,680 $7,776,000 9 87,000 $7,395,000 8 160,560 $9,633,600 9 1,292,000 $6,460,000 9 340 $51,000 6 546,740 $8,201,100 4 1,000 $135,000 8 2,200 $275,000 9 200,320 $8,012,800 6 1,600 $208,000 8 47,000 $4,230,000 7 300 $46,500 2 400 $56,000 6 144,000 $3,420,000 2 120,000 $3,000,000 9 2,160,000 $13,500,000 3 512,000 $8,960,000 7 100,000 $2,625,000 4 780,000 $9,750,000 5 80,000 $2,200,000 7 3,600,000 $6,750,000 2 1,520,000 $13,300,000 5 584,000 $9.490,000 1 360,000 $7.200,000 2 720,000 $9,900,000 1 24,000 $720,000 2 800,000 $9,000,000 Annual Veight Shipped 35,000 500 2,126,000 1,800 1,000 518,400 435,000 802,800 6,460,000 1,700 2,733,700 5,000 11,000 1,001,600 8,000 235,000 1,500 2,000 180,000 150,000 2,700,000 640,000 125,000 975,000 100,000 4,500,000 1,900,000 730,000 450,000 900,000 30,000 1,000,000 Average Transit Time 5.7 5.5 4.3 4.1 4.6 5.9 4.8 5.8 5.9 5.0 4.0 4.4 4.9 4.3 4.9 4.7 4.7 5.6 5.6 4.8 4.6 4.8 5.6 4.1 5.8 4.0 4.7 5.5 4.2 4.9 5.6 4.0 Variation in Transit Time - 1.9 1.3 1.4 1.6 1.2 1.8 1.1 1.7 1.1 1.5 1.2 1.3 2.0 1.5 1.1 1.6 1.3 1.6 1.5 1.4 1.9 1.8 1.4 13 1.7 1.9 1.2 1.6 1.9 1.3 1.4 1.9