Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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...

1 answer below »
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
Answered Same Day Mar 29, 2023

Solution

Banasree answered on Mar 30 2023
30 Votes
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    18
    Corn    582    825    1,407    B    5
    Ca
ot    517    500    1,017    A    8
    Sugarcane    503    300    803    C    5
    Cotton    468    300    768    C    5
    Strawbe
y    965    250    1,215    C    5
    Tomato    2705    300    3,005    B    20
    Pine Tree    3349    250    3,599    B    14
    Potato    11395    400    11,795    A    59
    Cacao    10219    350    10,569    A    60
    Ru
er Tree    12652    400    13,052    B    65
    Silk    23349    400    23,749    A    119
    Pepper    1764    250    2,014    C    12
                        396    total...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here