Agriculture Case Study
Part 2
Determine the required space
1. On the “Reorder” worksheet, calculate how many pallets of each item will be needed. (Maximum divided by the Quantity/Pallet.) The “total pallets” amount will define how many spots will be required in your racking.
Create a warehouse layout
1. Define the areas that will be used for Receiving incoming freight and Staging outbound freight by selecting the cells on the “Layout” worksheet and changing their fill colour. Label each area.
2. Design your rack plan on the “Layout” worksheet (Use borders and fill colour) taking the following into consideration:
a. You can only stack 4 high
. The squares on your floor plan are 48 x 48
c. You need to have rack spots for all of the “total pallets”
d. Your aisles need to be wide enough to facilitate the use of forklifts to stock pallets and pick orders. Decide which type of forklift you will use.
i. Counter balance forklifts need two squares but can be utilized to load and unload trucks as well as stock racking.
ii. Na
ow Aisle forklifts need one square but cannot be used to load and unload trucks so you will require more equipment.
e. Define areas on your “Layout” to store forklift fuel or to park electric forklifts to recharge.
Conclusions
Write a summary on the “Summary” worksheet explaining the following:
· Was there enough space to store all of the pallets?
· Could you rea
ange your warehouse if you needed to store 25% more pallets?
· Do you have any suggestions for how you could reduce travel time to make order picking more efficient?
· Do you have any other suggestions about how this warehouse space can be utilized more efficiently without increasing pick/pack times?
Items
Item Length Width Height Weight Quantity/pallet
Wheat 48 48 48 1000 lbs 100
Corn 48 48 48 1200 lbs 275
Ca
ot 48 48 48 1000 lbs 125
Sugarcane 48 48 36 1500 lbs 150
Cotton 48 48 36 1000 lbs 150
Strawbe
y 48 48 36 1000 lbs 250
Tomato 48 48 36 2000 lbs 150
Pine Tree 48 48 48 1000 lbs 250
Potato 48 48 48 1000 lbs 200
Cacao 48 48 48 1000 lbs 175
Ru
er Tree 48 48 48 1200 lbs 200
Silk 36 36 36 1000 lbs 200
Pepper 36 36 36 1000 lbs 175
Reordering
Item ROL Reorder Quantity Maximum A, B, or C Pallets
Wheat 285 1500 1,785 B
Corn 582 825 1,407 B
Ca
ot 517 500 1,017 A
Sugarcane 503 300 803 C
Cotton 468 300 768 C
Strawbe
y 965 250 1,215 C
Tomato 2705 300 3,005 B
Pine Tree 3349 250 3,599 B
Potato 11395 400 11,795 A
Cacao 10219 350 10,569 A
Ru
er Tree 12652 400 13,052 B
Silk 23349 400 23,749 A
Pepper 1764 250 2,014 C
- 0 total pallets
Layout
Outbound freight Incoming freight
Summary