# Warehouse Slotting Worksheet

> Source: https://netray.co/tools/warehouse-slotting-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable slotting worksheet that sizes forward pick slots from pick velocity, unit cube and days of supply so fast movers sit where picking is cheapest.

## Category

supply-chain

## Industry

Warehousing

## Audience

- Warehouse manager
- Industrial engineer
- Logistics analyst

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### SKU

**Key:** sku

**Type:** text

#### Assigned zone

**Key:** zone

**Type:** select

**Options:**

- Golden zone
- Forward pick
- Carton flow
- Bulk reserve
- Floor level

#### Picks per day

**Key:** picks

**Type:** number

#### Avg units per pick

**Key:** qty

**Type:** number

#### Cube per unit

**Key:** cube

**Type:** number

**Unit:** cu ft

#### Days of supply in slot

**Key:** days

**Type:** number

#### Units per day

**Key:** units_day

**Type:** number

**Expr:** picks * qty

**Format:** integer

#### Cube per day

**Key:** cube_day

**Type:** number

**Expr:** picks * qty * cube

**Format:** decimal

#### Slot cube needed

**Key:** slot_cube

**Type:** number

**Expr:** picks * qty * cube * days

**Format:** decimal

**Help:** Add 10 to 20 percent fill allowance when choosing a slot.

**Rows:**

**Sku:** FST-1001

**Zone:** Golden zone

**Picks:** 180

**Qty:** 2

**Cube:** 0.05

**Days:** 2

**Sku:** BRG-2205

**Zone:** Forward pick

**Picks:** 95

**Qty:** 4

**Cube:** 0.12

**Days:** 3

**Sku:** HSG-3310

**Zone:** Carton flow

**Picks:** 40

**Qty:** 1

**Cube:** 0.8

**Days:** 4

**Sku:** CBL-4420

**Zone:** Forward pick

**Picks:** 22

**Qty:** 3

**Cube:** 0.4

**Days:** 5

**Sku:** PNL-5530

**Zone:** Bulk reserve

**Picks:** 4

**Qty:** 1

**Cube:** 6.5

**Days:** 10

**Sku:** MTR-6640

**Zone:** Floor level

**Picks:** 3

**Qty:** 1

**Cube:** 9

**Days:** 14

**Totals:**

#### Total picks per day

**Key:** picks

**Agg:** sum

**Format:** integer

#### Total cube per day

**Key:** cube_day

**Agg:** sum

**Format:** decimal

#### Total slot cube needed

**Key:** slot_cube

**Agg:** sum

**Format:** decimal

**Summary:**

#### Average picks per SKU

**Key:** avg_picks

**Expr:** sum_picks / count

**Format:** decimal

#### Average cube moved per pick

**Key:** cube_pick

**Expr:** sum_cube_day / sum_picks

**Format:** decimal

**Notes:** Rank rows by picks per day, then assign the highest-velocity items to the most ergonomic, closest locations. Re-run slotting at least quarterly or after a major product mix change.

## Content

**Intro:** Slotting decides where each item lives, and it quietly drives pick rate, travel and replenishment workload. This worksheet sizes the slot each SKU needs from its velocity, cube and days of supply so you can compare against the location sizes you actually have.

**Sections:**

#### How to use it

**Body:** List your SKUs with the average picks per day, average units per pick, cube per unit and the days of supply you want to hold in the pick face. The sheet computes units per day, cube per day and the cube the slot must hold. Then sort or review by picks per day, and assign the busiest items to the golden zone, usually waist to shoulder height near the pack or dock end, and slower items to higher or deeper locations.

**Bullets:**

- Use at least 8 to 12 weeks of pick history
- Treat seasonal items separately
- Use net cube including packaging
- Keep heavy and fragile rules in mind

#### The slotting logic

**Body:** Velocity slotting ranks items by pick frequency so the items with the most touches have the shortest walks. Cube-per-order index and pick-density approaches refine this by also considering size. Days of supply controls replenishment: a slot holding two days of demand is replenished often but keeps the pick face compact, while ten days reduces replenishment but uses more premium space. Slot cube needed equals daily cube times days of supply, plus an allowance because slots are never filled perfectly.

#### Reading the result

**Body:** Compare slot cube needed with the available cube of the candidate location, such as a carton flow lane, shelf bay or pallet face. Items whose need exceeds the slot will starve the picker; items far below it waste space. Total slot cube against your forward pick capacity shows how much of your demand can really sit in the fast area. If most picks come from a few SKUs, protect those locations and consider replenishment triggers by min and max quantity.

#### Common mistakes

**Body:** Slotting once and never revisiting is the usual issue; assortments and seasons change. Another is optimising for picking alone and forgetting replenishment, which can double-handle fast items. Co-pick affinity also matters: parts ordered together should often be near each other. In SAP EWM, Oracle WMS, Infor and Epicor warehouses, storage type and bin definitions limit what you can assign, so check configuration capacity before moving stock. Move in waves, off peak, with counts to confirm.

**Cta:** If velocity data already exists in your ERP transaction history, Netray can help turn it into a repeatable slotting recommendation your team reviews before any move.

**Faq:**

#### What is warehouse slotting?

**Answer:** Slotting is the process of assigning each product to a storage location based on velocity, size, weight and handling rules, so the most frequently picked items are the easiest to reach and replenishment stays efficient.

#### What is the golden zone?

**Answer:** The golden zone is the set of pick locations between roughly knee and shoulder height that are easiest and fastest to reach, usually close to the pack or dock area. Fast movers belong here.

#### How often should I re-slot?

**Answer:** Review quarterly for most operations and more often with strong seasonality or frequent new products. Smaller adjustments can be made weekly based on velocity changes, but each move has a labor cost.

#### How much days of supply should a pick face hold?

**Answer:** Enough to avoid replenishment during a pick wave, usually one to five days for fast movers, balanced against slot size. Slow movers can hold more because they take little space per pick.

## Search terms

warehouse slotting worksheet, slotting template excel, warehouse slotting optimization, pick face sizing, forward pick slot sizing, velocity slotting, golden zone slotting, pick location assignment template

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json