This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
PARETO's LAW - LEAN WAREHOUSE MANAGEMENT CALCULATOR
Enter values
Number of SKUs
¬
Enter your data here
Total Number of Pallets
¬
Enter your data here
Inventory turns/year
¬
Enter your data here
Number of Shifts
¬
Enter your data here
Pick faces per SKU
¬
Enter 4 or 5 for optimal space utilization
Breakdown of SKUs
Breakdown of Pallets
10% of SKUs
®
50% of Pallets
10% of SKUs
®
30% of Pallets
30% of SKUs
®
15% of Pallets
50% of SKUs
®
5% of Pallets
Pallets/ SKU
Optimal Storage Depth
Top 10%
pallets per SKU
Top 10%
Pallets deep
Next 10%
pallets per SKU
Next 10%
Pallets deep
Next 30%
pallets per SKU
Next 30%
Pallets deep
Bottom 50%
pallets per SKU
Bottom 50%
Pallets deep
Average Pallet Moves
4
Top 10%
Utilized
Hour
Next 10%
Utilized
Day
Next 30%
Utilized
Week
Bottom 50%
Month
Pareto's Law Analysis explained in plain English
Analysis explained another way, but this time with greater precision
For better warehouse space utilization consider storing these fast moving SKUs
this number of pallets deep
Store the next fast moving SKUs
this number of pallets deep
For your 3rd fastest SKUs
this number of pallets deep
is ideal
For your bottom SKUs
this number of pallets deep
is ideal
For your slowest moving SKUs, if the quantity is less than a full pallet, shelving or pick media is recommended.
Bonus Analysis:
Price of Equipment versus Price of Labor Analysis
Lift Truck (MHE) Type
Pallets Moved/hr
Budgetary Price each $
# Lift Trucks Needed
Budget for MHE
Electric Sitdown Forklift
Reach Truck
Non-guided VNA
Wire-guided Turret Truck
Lift Truck Type
Operator Hourly $
Labor Price / Year
MHE Cost / Year
Labor & MHE / year
Electric Sitdown Forklift
Reach Truck
Non-guided VNA
Wire-guided Turret Truck
This online calculator was created by Lean Inc.
Print All Information
Please host the converted page in server to use Print All.
Update
Reset
Print All