For a warehouse area of approx. 1,800 EURO_pallets of capacity compare, Warehouse renting cost ● for the following 4 scenarios, 1. Conventional racking with counterbalance forklift (see details on slide

4) 2. Conventional racking with reach truck (see details on slide 4) 3. Conventional racking with very narrow aisle truck (see details on slide 4) 4. Drive-in racking with counterbalance forklift (see details on slide 5) and propose and explain the solution that minimizes annual overall cost and explain the results. ● Amortization of the investment in storage solutions Renting cost of material handling equipment Personnel cost height? Support data 1: conventional racking model Bay Overcapacity of forklifts and personnel can be used in other warehousing operations The design on each scenario must be a multiple of the 'standard bay' Round the number of aisles in scenarios 2 and 3 to the closest whole number (+ or -)* The conventional rack has 12 bays of depth. The drive-in depth is to be calculated Amortization period 10 years Lateral view Aisle width Front view Aisle depth x12 Bays Standard bay Front view 2,8 m/3 pallets Bay Length Lateral view 1,25 m 1 pallet Bay depth 1,6 m Support data 2: drive-in racking model Bay height? Lift heigh Turning radius = aisle width Support data 4: other data Scenario Storage Solution Handling Equipment Forklift productivity (Pallets/hour) Forklift utilization (Hours/year) Aisle depth? 4,95 m / 6 pallets Bay depth Support data 3: lift height and aisle width 77 Front view Activity [Store+Retrieve] (Pallets/year) Warehouse Renting cost (Euro/m2_year) Forklift renting cost (Euro_unit/year) Personnel cost (Euro/person_year) Investment in racking (Euro/pallet) Aisle width Product type Hand Pallet Trucks Electric Pallet Trucks Hand Pallet Stackers Electric Pallet Stackers Order Pickers Reach Trucks Tri-Lateral Stackers Counterbalanced Forklifts (Indoors) Counterbalanced Forklifts (Outdoors) Tow Tractors Note: Tri-lateral stackers = Standard bay 20 1.760 79.200 Lateral view 4,95 m / 6 pallets Bay depth 60 7.200 28.600 30 Lift Height -/0,7 m 13.0 m 18.0 m 7.5 m 9.5 m Scenario Scenario Scenario Conventional Conventional Conventional Very narrow aisle trucks 2.5 m 6.0 m 1.5 m 12.5 m >2.3 m >2.8 m >1.8 m >3.6 m >5.0 m >1.4 m Front view 1.760 79.200 60 18.000 31.460 30 1,6 m 1,45 m 1 pallet Bay length Turning Radius >1.3 m >1.8 m - 2.2 m >1.9 m >1.5 m2.1 m Counterbalanced Reach Truck VNA Truck Counterbalanced 23 30 1.760 79.200 60 9.000 30.030 30 Scenario Drive_in 18 1.760 79.200 60 7.200 28.600 45/n With this given data need to calculate size,estimate of the warehouse in Excel