Question: a. How many square feet does the DC need to accommodate peaks and annual growth for the next 5 years? Total SKUs Calculation Storage Calculation

a. How many square feet does the DC need to accommodate peaks and annual growth for the next 5 years?

a. How many square feet does the DC need to accommodate peaks

Total SKUs Calculation Storage Calculation Extra Space Calculation 20,000 35 Current products (non-peak) SKUS SKU Peaks - seasonal 20% Design timeline - years SKU Growth per annum SKU total - Year 1 SKU total - Year 2 5,000 6,000 5 5% 6,300 6,615 5 8 2 3.5 0.67 200 Office space square ft Shipping/Staging area depth ft Shipping/Staging area lenght ft Shipping/Staging total area square ft Receiving area depth ft Receiving area lenght ft ? ? 35 ? Pallet level high Pallet racking bay width (2 pallets) ft Pallets per racking bay Pallet racking depth ft Gap between back to back racking ft Pallet racking lenght ft Pallet racking back to back area square ft Amount of pallets per racking Amount of pallets per racking back to back Amount of pallet racking back to back required Total area required for pallet racking ? SKU total - Year 3 SKU total - Year 4 6,946 7,293 1534 250 Receiving total area square ft Other non office space square ft 20,000 SKU total - Year 5 7,658 500 Total Pallet Area(plus aisles) sq ft 227,930 55 84,578 Total Shelving Area(plus walkway) sq ft 10338 Space per SKUs Calculation Amount of aisles required Aisle width ft Aisle length ft Aisle area square ft per aisle Total aisle area square ft 55 13 2001 2600 143,352 Pallet area Pallet area - SKUs percentage Pallet area - Total SKUS Pallet spots per SKU Total pallet spots required Area per pallet (cubic ft) Total pallet area required (cubic ft) 60% 4,595 6 27,568 53.33 1,470,184 10 I 4 50 200 400 2,000 34 Shelving area Shelving area - SKUs percentage Shelving area - Total SKUs 30% 2,297 Shelving high ft Shelving depth ft Shelving length ft Shelving unit area square ft Shelving back to back area square ft Shelving area cubic ft Amount of Shelving required Amount of Shelving back to back required Total Shelving area sq ft Amount of walkway required Walkway lengh Walkway widths Walkway area square ft Total Walkway area square ft SKU average quantity holding SKU total quantity holding SKU average area (sq ft) Total Shelving area required (sq ft) 20 45,946 1.5 68,919 17 6892 17 501 4 200 3446 Bulk Area Bulk area - SKUs percentage Bulk area - Total SKUS SKU average quantity holding SKU total quantity holding SKU average area (square ft) Total Bulk area required (square ft) Access space (square ft) SKU average area (cubic ft) Total Bulk area required (cubic ft) 10% 766 4 3,063 30 91,892 183,785 240 735,138 Total Pallet Area(plus aisles) sq ft Total Shelving Area(plus walkway) sq ft Total Bulk Area sq ft 227,930 10338 183,785 Total SKUs Calculation Storage Calculation Extra Space Calculation 20,000 35 Current products (non-peak) SKUS SKU Peaks - seasonal 20% Design timeline - years SKU Growth per annum SKU total - Year 1 SKU total - Year 2 5,000 6,000 5 5% 6,300 6,615 5 8 2 3.5 0.67 200 Office space square ft Shipping/Staging area depth ft Shipping/Staging area lenght ft Shipping/Staging total area square ft Receiving area depth ft Receiving area lenght ft ? ? 35 ? Pallet level high Pallet racking bay width (2 pallets) ft Pallets per racking bay Pallet racking depth ft Gap between back to back racking ft Pallet racking lenght ft Pallet racking back to back area square ft Amount of pallets per racking Amount of pallets per racking back to back Amount of pallet racking back to back required Total area required for pallet racking ? SKU total - Year 3 SKU total - Year 4 6,946 7,293 1534 250 Receiving total area square ft Other non office space square ft 20,000 SKU total - Year 5 7,658 500 Total Pallet Area(plus aisles) sq ft 227,930 55 84,578 Total Shelving Area(plus walkway) sq ft 10338 Space per SKUs Calculation Amount of aisles required Aisle width ft Aisle length ft Aisle area square ft per aisle Total aisle area square ft 55 13 2001 2600 143,352 Pallet area Pallet area - SKUs percentage Pallet area - Total SKUS Pallet spots per SKU Total pallet spots required Area per pallet (cubic ft) Total pallet area required (cubic ft) 60% 4,595 6 27,568 53.33 1,470,184 10 I 4 50 200 400 2,000 34 Shelving area Shelving area - SKUs percentage Shelving area - Total SKUs 30% 2,297 Shelving high ft Shelving depth ft Shelving length ft Shelving unit area square ft Shelving back to back area square ft Shelving area cubic ft Amount of Shelving required Amount of Shelving back to back required Total Shelving area sq ft Amount of walkway required Walkway lengh Walkway widths Walkway area square ft Total Walkway area square ft SKU average quantity holding SKU total quantity holding SKU average area (sq ft) Total Shelving area required (sq ft) 20 45,946 1.5 68,919 17 6892 17 501 4 200 3446 Bulk Area Bulk area - SKUs percentage Bulk area - Total SKUS SKU average quantity holding SKU total quantity holding SKU average area (square ft) Total Bulk area required (square ft) Access space (square ft) SKU average area (cubic ft) Total Bulk area required (cubic ft) 10% 766 4 3,063 30 91,892 183,785 240 735,138 Total Pallet Area(plus aisles) sq ft Total Shelving Area(plus walkway) sq ft Total Bulk Area sq ft 227,930 10338 183,785

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!