5 4 With this information develop a warehouse racks layout with 3 entrance doors and 4 exit doors. 5 Determine the costs for the racks, equipment office, and materials inventory base on ABC analysis. 6 Demand: Product Volume ABC Items Rotations 7 W 5,000 lots A 20% 8 8 Z 55,000 lots B 30% 5 9 Y 45,000 lots 50% 3 10 4,900 lots 11 Productos (Uso en Ib/lot) 12 Material Lbs/pallet Z W Costo/lb Flamable 13 Raw Mat A 200 2 $25.22 Y 14 Raw Mat B 300 3 $30.50 15 Raw Matc 250 5 7 5 $18.90 16 Raw Mat D 300 12 8 $40.20 Y 17 Raw Mate 400 7 9 $12.00 18 Raw Mat F 200 21 50 25 32 19 Raw Mat G $4.60 500 3 20 Raw Mat H $10.00 Y 450 4 8 21 Raw Mat! $15.70 300 7 2 22 Raw Mat J $23.00 300 23 Pack Mat 1 $13.80 3 4 24 Pack Mat 2 $13.50 250 Y 9 25 Pack Mat 5 $2.57 300 Y 24 20 18 26 Pack Mat 4 27 $5.00 200 Y 27 Pack Mat 10 $8.00 Y 200 10 28 Pack Mate 500 $30.00 Y 4 29 Pack Mat 7 5 200 $12.00 Y + 2 30 Pack Mate 7 $8.00 400 Y 7 31 Pack Mat 300 $6.00 Y 32 Supply ! 21 100 $7.00 1 Y 33 Supply ! 2 500 $12.00 7 34 Supply in B 300 $7.00 3 35 Supply TV 4 $14.00 Y 36 Supply 4 300 $21.00 37 2 $11.00 38 39 Cost distribution per item $30 per floor sqft 42 2 Deep Convencional 527 per floor sqft 43 Deep Convencional $20 per floor sqft 4410 Foi ule For 300 NAO 4 7 500 NON NA ON 40 Drive In 4 high 41 Drive In 3 high 46 Csing printer syster 47 P Sprinter wytem Of Spain 45 PP sy Room $12 por floor san $30,000 ca $25,000 3 $50 per ceiling sqft $45 per rack levels 15 x 20 520,000 10 $10,000 $2.000 Sheet Shooth Shoot 5 4 With this information develop a warehouse racks layout with 3 entrance doors and 4 exit doors. 5 Determine the costs for the racks, equipment office, and materials inventory base on ABC analysis. 6 Demand: Product Volume ABC Items Rotations 7 W 5,000 lots A 20% 8 8 Z 55,000 lots B 30% 5 9 Y 45,000 lots 50% 3 10 4,900 lots 11 Productos (Uso en Ib/lot) 12 Material Lbs/pallet Z W Costo/lb Flamable 13 Raw Mat A 200 2 $25.22 Y 14 Raw Mat B 300 3 $30.50 15 Raw Matc 250 5 7 5 $18.90 16 Raw Mat D 300 12 8 $40.20 Y 17 Raw Mate 400 7 9 $12.00 18 Raw Mat F 200 21 50 25 32 19 Raw Mat G $4.60 500 3 20 Raw Mat H $10.00 Y 450 4 8 21 Raw Mat! $15.70 300 7 2 22 Raw Mat J $23.00 300 23 Pack Mat 1 $13.80 3 4 24 Pack Mat 2 $13.50 250 Y 9 25 Pack Mat 5 $2.57 300 Y 24 20 18 26 Pack Mat 4 27 $5.00 200 Y 27 Pack Mat 10 $8.00 Y 200 10 28 Pack Mate 500 $30.00 Y 4 29 Pack Mat 7 5 200 $12.00 Y + 2 30 Pack Mate 7 $8.00 400 Y 7 31 Pack Mat 300 $6.00 Y 32 Supply ! 21 100 $7.00 1 Y 33 Supply ! 2 500 $12.00 7 34 Supply in B 300 $7.00 3 35 Supply TV 4 $14.00 Y 36 Supply 4 300 $21.00 37 2 $11.00 38 39 Cost distribution per item $30 per floor sqft 42 2 Deep Convencional 527 per floor sqft 43 Deep Convencional $20 per floor sqft 4410 Foi ule For 300 NAO 4 7 500 NON NA ON 40 Drive In 4 high 41 Drive In 3 high 46 Csing printer syster 47 P Sprinter wytem Of Spain 45 PP sy Room $12 por floor san $30,000 ca $25,000 3 $50 per ceiling sqft $45 per rack levels 15 x 20 520,000 10 $10,000 $2.000 Sheet Shooth Shoot