Facility Layout - Distribution Center Optimization Analysis | Môn Econometrics with Financial Application - Trường Đại học Quốc tế, Đại học Quốc gia Thành phố Hồ Chí Minh

lOMoAR cPSD| 58583460
International University - VNUHCM
School of Industrial Engineering & Management 1. Question 1
The Burger Doodle restaurant chain uses a distribution center to prepare the food
ingredients it provides its individual restaurants. The company is attempting to determine
the location for a new distribution center that will service five restaurants. The grid-map
coordinates of the five restaurants and the annual number of 40-foot trailer trucks
transported to each restaurant are as follows: Coordinates (Miles) Annual Truck Restaurant Shipments x y 1 100 300 35 2 210 180 24 3 250 400 15 4 300 150 19 5 400 200 38
a) Determine the least-cost location using the center-of gravity method (10pts)
b) Plot the five restaurants and the proposed new distribution center on a grid map. (10pts)
c) The Burger Doodle is considering three potential sites, with the following grid-map
coordinates, for its new distribution center: A(350, 300), B(150, 250), and C(250,
300). Determine the best location using the load-distance formula, and plot this
location on a grid map with the five restaurants. How does this location compare
with the location determined in a)? (15pts) Q1. a) x = 253.36 y = 238.70 b) lOMoAR cPSD| 58583460 c) Site A:
Site B: d1 = 70.71, d2 = 92.20, d3 = 180.28, d4 = 180.28, d5 = 254.95
Site C: d1 = 150.00, d2 = 126.49, d3 = 100.00, d4 = 158.11, d5 = 180.28
LD (A) = 35(250) + 24(184.39) + 15(141.4) + 19(158.11) + 38(111.80) = 549.4
LD (B) = 35(70.71) + 24(92.20) + 15(180.28) + 19(180.28) + 38(254.95) = 20, 505.1
LD (C) = 35(150) + 24(126.49) + 15(100.00) + 19(158.11) + 38(180.28) = 19,640.5
Site C has the lowest load-distance value and would minimize transportation costs. lOMoAR cPSD| 58583460
Site C is a little more centrally located as the site determined in a); it is closer to site 3, which has the lowest annual truck shipments. 2. Question 2 (20pts)
Suppose 12 products are received by a warehouse according to the schedule in the
following table. Find the storage requirements for: a) Dedicated storage (10pts) b) Randomized storage (05pts)
c) Comment on the two appoaches of a) and b) with your results (05pts) Product Period 1 2 3 4 5 6 7 8 9 10 11 12 1 20 15 60 27 17 31 26 22 25 35 38 45 2 28 10 12 36 19 11 28 18 3 38 25 46 3 25 38 37 25 18 23 40 29 49 14 5 32 4 33 32 2 50 7 50 39 19 44 21 26 41 5 31 37 38 16 45 29 41 9 45 25 11 25 6 11 22 9 27 15 42 18 20 50 25 49 27 7 20 16 37 39 4 31 6 16 3 44 2 30 8 34 20 28 16 75 32 49 44 2 21 23 20 9 41 20 6 6 4 16 17 27 12 8 32 31 lOMoAR cPSD| 58583460 10 85 15 36 17 41 40 20 23 23 26 14 24 11 18 32 5 16 24 28 38 70 27 30 50 13 12 38 1 34 2 37 36 3 32 17 45 22 34 13 29 1 19 13 16 7 33 12 41 22 1 31 14 44 35 34 26 10 40 4 2 4 34 10 45 15 23 21 23 3 29 28 13 25 2 29 4 24 16 35 3 36 30 8 25 42 3 24 41 22 75 17 39 17 12 8 33 6 70 25 28 29 30 3 18 34 50 44 19 46 34 46 9 19 18 30 16 19 16 28 13 22 37 43 17 20 1 44 2 12 20 30 18 21 28 35 46 20 5 17 29 15 29 Q2 Period 1 2 3 4 5 6 7 8 9 10 11 365 12 1 20 60 15 27 17 31 26 22 25 35 38 45 361 2 28 10 12 36 19 11 28 18 3 38 25 46 274 3 25 38 37 25 18 23 40 29 49 14 5 50 7 50 32 335 4 33 32 2 39 19 44 21 26 41 364
5 31 37 38 16 45 29 41 9 45 25 11 25 352 6 11 22 9 27 15 42 18 20 25 49 27 315 7 20 16 37 39 4 31 6 50 16 3 44 2 30 248 8 34 20 28 75 16 32 49 44 2 21 23 20 364 9 41 20 6 6 4
16 17 27 12 8 32 31 220 10 15 36 17 41 40 20 23 23 26 14 24 364 11 18 32 5
85 16 24 28 38 27 13 351 12 38 1 34 2 37 36 3 32 17
34 301 13 29 1 19 13 16 7 33 12 41 22 1 31 225 70 30 50 14 44 35 34 26 10 40 4 2 4 34 45 22 10 45 288 15
23 21 23 3 29 28 13 25 2 29 4 24 224 16 35 3 36 30 8 25 42 3 24 41 22 344
17 39 17 12 8 33 6 25 28 29 30 3 300 18 34 44
19 46 34 46 9 19 18 30 16 75 19 16 28 13 22 37
43 17 20 1 44 2 12 255 70 20 50 30 18 21 28 35 46 20 5 365 17 29 15 29 293 Max 85 50 60 50 75 730 50 70 70 50 45 50 75 a)
With dedicated storage, the required space, as given in the Table, equals the sum of maximum inventory
level for each product, or 730 pallet positions b)
With randomized storage, the required amount of space equals the maximum aggregate inventory level , or 365 pallet positions lOMoAR cPSD| 58583460 3. Question 3 (30 pts)
The existing warehouse will be used for the storage of six product families. The
warehouse consist of storage bays of size 10'x10'. Dock 1 has been designated as the
receiving dock, while dock 2 is used as the shipping dock. The area requirement and
monthly load rate for each product family are shown in the following table: Product family Area (SQF) Load rate 1 600 600 2 800 400 3 500 800 4 700 400 5 1,000 400 6 400 900
a) Formulate problem using the the warehouse layout model (05 pts)
b) Determine the layout that will minimize the total expected travel distance (25 pts) Q3 (row 234) Product Area Load family (SQF) # of Bays Rate Tj/Sj Rank (j) (ft2) (Sj) (Tj) 1 6 600 100 3 600 2 800 8 400 50 5 3 500 5 800 160 2 4 7 400 57.14 4 700 5 1,000 10 400 40 6 lOMoAR cPSD| 58583460 6 400 4 900 225 1 k =1 to 40 4. Question 4 (20 pts)
Four manufacturing cells (equal dimension, said 100 feet width) are served by an
automatic guided vehicle (AGV) on a linear bidirectional track, as shown below. The
product routing information and required production rates are given in the table below.
Using an improvement-based procedure, determine a single-row cell arrangement. lOMoAR cPSD| 58583460
Assume that the pickup/delivery stations are located along the AGV track at the midpoint of the cell edge. Product Processing sequence
Weekly production (Unit) A A B D C D 1500 B B A D C A 1000 C B D A 300 D A B C A 400
Đề trong sheet project