Question 110: Consider the following data related to different products that will be stored in a warehouse Product Man in number of Unit Loads Standard Deviation in of Unit Leads 1 2 4 164 156 262 189 282 63 254 146 69 76 5 6 7 8 9 10 Throughput per period Storage Space per Unit Load L-WH m.) 175 10101 135 1911 197 1'11 461 1911 411 10191 225 1'11 280 10101 256 1'11 415 1'101 462 10101 16 11 29 30 11 25 11 28 29 23 a) [2] Group the above products into three classes. Assume that the class cutoff percentages from high to low classes are 40, 30 and 30 percent respectively. Also, assume that the service level is 95%. b) (3] Calculate the capacities of each class, and the total capacity of the warehouse using the information from Part (a). Assume a class-based storage is used for the warehouse, and service level for each class is 95% c) [2] Calculate the optimal floor area needed for the first class from Part (b). Assume stacking type storage is used, and the maximum stacking in vertical direction is 3 unit loads .c. 23 in the 2 dimensional stacking model). Use the continuous approximation model and round up the values to the nearest integers. Assume that the aisle width is 2 mts. d) (3) Assume that the warehouse is divided into bays as shown in the following layout. If the probability of using depots DID2, and D3 are 40%, 30% and 30% respectively, assign the above classes to the storage buys. Assume the first class requires 70 mr of bay area, the second and third classes require 106 and 448 m respectively. Assume that cach bay is of size 126 m highlighted in yellow color), and all the aisle width are 2 m (shown as white grid).