Warehouse Operations: Pick Rates, Slotting, Space & Labour Planning

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn one shift's picking log into lines and units per hour, compare every picker with the engineered labour standard, pool the team's rate correctly and count who is below the performance floor.
• Convert next week's order forecast into lines, pick and pack hours, paid hours including indirect time, and the number of people per shift with ROUNDUP.
• Rank 15 SKUs by pick frequency, build the cumulative share of picks, assign A, B and C slotting classes from the thresholds and draw the Pareto chart that justifies the layout.
• Weight the walking distance per pick by pick volume before and after re-slotting, and turn the metres saved into picker hours per day and an annual labour saving.
• Measure how full the warehouse really is: position occupancy by zone and pooled, how much of each occupied position the pallet fills, the overall cube utilisation and the positions left before the practical limit.
• Turn the truck schedule into door-minutes per two-hour block, size the doors needed with ROUNDUP, find the peak and measure how busy the dock is over the day.
• Turn six months of order failures into on-time, in-full, damage-free and documentation rates, multiply them into the perfect order rate, pool the half-year and express mis-picks per 10,000 lines.
• Build activity rates from the cost pools and their drivers, assign the month's warehouse cost to a web-shop client and a retail client, and compare their cost per order and per unit with a single average rate.