SCLT 4312 HW 3 Space Calculations Objective: CREATE AN EXCEL WORKSHEET TO CALCULATE STORAGE SPACE - Calculate the space required to store palletized...

SCLT 4312 HW 3

Space Calculations

Objective:

CREATE AN EXCEL WORKSHEET TO CALCULATE STORAGE SPACE - Calculate the space required to store palletized goods in a very simple arrangement.

Assignment

Assume that a predictable quantity of goods moves through a warehouse each month. The goods arrive loose and must be placed on pallets. They are then stored in a straight line. The goods are picked directly from the pallets.

1. Calculate the footprint you will need to store the goods end to end in the warehouse. Give your answer as the width of the line (in feet and inches) by the length of the line (in feet and inches). Assume one straight line for storage with no spaces between the pallets.
2. Give an answer for the length of the row of pallets if they are lined up using the 40" side as the width
3. Then calculate the length of the row of pallets assuming they are lined up using the 48" side as the width

Details

Items moved per month:

• 5,000 cases of canned goods 10 in X 13 in X 8 in

Weight of each case - 10 lbs

• 1,000 cases of jeans 40 in X 24 in X 18 in

Weight of each case - 7 lbs

• 500 cases of artwork 18 in X 22 in X 5 in

Weight of each case - 100 lbs

Height limit for pallets = 52 in.

Load limit for pallets = 3,300 lbs

Pallets are 48" by 40" by 6" tall