Suppose that a warehouse contains eight storage bays (four in each side). Product enters the rear of the warehouse through a rail dock. Product is picked from the storage locations by an out-and-back selection method and shipped from a truck dock at the front of the building. Each bay can hold up to (please use the following excel formula to calculate bay capacity in sq. ft.) with product stacked 10 ft. high. Ten products are maintained in the warehouse. The following data have been collected: Bay capacity = “=ROUNDUP(RANDBETWEEN(2400;2700);-1)” Product Storage Space Required (sq.ft.) Individual Product Size (cu.ft.) Average Number of Daily Orders in Which Item Appears A 500 1.5 56 B 3,000 10.6 103 C 1,500 4.3 27 D 1,700 5.5 15 E 5,500 2.7 84 F 1,100 15.0 55 G 700 9.0 26 H 2,800 6.7 45 I 1,300 3.3 94 J 900 4.7 35 Lay out the warehouse using the cube-per-order index method.