Warehouse Bin Location Utilization

This dataset provides detailed records of item placements and bin occupancy across warehouse locations, enabling granular analysis of space utilization and slotting efficiency. Key features include time-stamped item movements, bin capacity and status tracking, and support for multi-warehouse operations. The data is ideal for optimizing warehouse layouts, improving storage strategies, and supporting predictive analytics for space planning.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Warehouse slotting optimization and space planning

Sample rows

preview · 8 of 200 rows · all 15 columns
record_idstringbin_statusstringbin_occupancyfloatbin_zonestringwarehouse_idstringbin_idstringbin_typestringitem_idstringitem_descriptionstringitem_categorystringplacement_datetimedatetimeremoval_datetimedatetimequantityintegerbin_capacityintegerlast_updateddatetime
RCD0001occupied60A1WH01BIN-1001palletITM-2001Corrugated cardboard boxesPacking material2024-01-04T09:15:00Zblank601002024-01-04T09:16:00Z
RCD0002empty26.67D1WH02BIN-2001rackITM-3002All-weather car tires setAutomobile2024-02-10T11:32:00Z2024-03-15T15:45:00Z8302024-03-15T15:50:00Z
RCD0003occupied70F9WH05BIN-1503palletITM-4003Canned tomato soupCanned Goods2024-01-12T08:00:00Zblank42602024-01-12T08:01:00Z
RCD0004occupied60Y7WH07BIN-1750floorITM-2404Sterile latex glovesMedical2024-05-14T13:30:00Zblank60010002024-05-14T13:32:00Z
RCD0005occupied10.71D2WH02BIN-2102rackITM-3005Brake pads setAutomobile2024-02-18T10:25:00Zblank3282024-02-18T10:26:00Z
RCD0006reserved100Z9WH03BIN-3002otherITM-4901Antique globeCollectibles2024-03-07T16:47:00Zblank112024-03-07T17:00:00Z
RCD0007empty1.33C4WH08BIN-8001rackITM-8802Smart home routerElectronics2024-04-18T11:10:00Z2024-05-01T09:00:00Z21502024-05-01T09:05:00Z
RCD0008blocked50NEWWH09BIN-9003otherITM-9102Wind turbine prototype bladeRenewables2024-03-29T14:22:00Zblank122024-03-29T14:35:00Z

What the 200 rows show

from the 200-row sample

Empty (bin status) stands out: mean bin_occupancy is 12.7, against 60.2 for the rest.

  • 50.0median bin_occupancy
  • 5bin types
  • 9warehouses
  • 13item categories
  • 8median quantity
  • 30median bin_capacity
Mean bin_occupancy by bin_status200 rows
05010051.5occupied100 rows12.7empty47 rows81.3reserved24 rows73.1blocked29 rows
bin_occupancy200 rows, in bands of 10
02550435139212918101339050100bin_occupancy →

Median 50.0, from 0.0 to 100.0.

bin_zone199 rows with a value · 1 left blank
  1. F931
  2. T221
  3. A119
  4. Z117
  5. D216
  6. D115
  7. Z915
  8. NEW15
  9. Y713
  10. Q412
15 columns by typefrom the column list below
  • string 9
  • integer 2
  • float 1
  • datetime 3

Columns

15 columns in three groups
blueprint · 15 columns
columntypedescriptionexample
Text 9 columns
record_idstringUnique identifier for each bin utilization recorduniqueRCD0001
warehouse_idstringUnique identifier for the warehouse9 warehousesWH01
bin_idstringUnique identifier for the bin location within the warehouseBIN-1001
bin_typestringType or classification of the bin (e.g., pallet, shelf, rack)pallet · shelf · rack · floor · other · optionalpallet
bin_zonestringZone or area within the warehouse where the bin is locatedoptionalA1
item_idstringUnique identifier for the item stored in the binITM-2001
item_descriptionstringShort description of the item stored in the binoptionalCanned tomato soup
item_categorystringCategory or classification of the itemoptionalPacking material
bin_statusstringCurrent status of the bin (e.g., occupied, empty, reserved, blocked)occupied · empty · reserved · blockedoccupied
Numbers 3 columns
quantityintegerNumber of units of the item stored in the bin1 or more60
bin_capacityintegerMaximum number of units the bin can hold1 or more100
bin_occupancyfloatCurrent occupancy percentage of the bin (0-100)0 to 10060
Dates and times 3 columns
placement_datetimedatetimeDate and time when the item was placed in the bin2024-01-04T09:15:00Z
removal_datetimedatetimeDate and time when the item was removed from the bin (null if still present)optional2024-03-15T15:45:00Z
last_updateddatetimeTimestamp of the last update to this record2024-01-04T09:16:00Z

Use it for

  • median bin occ…50.0200 rowsmean bin occupancy by…51.5occu…12.7empty81.3rese…73.1bloc…

    A logistics dashboard

    Bin_occupancy by bin_status and a breakdown of bin_zone. Excel, Power BI or Tableau.

  • Why do the 47 empty rows have a mean bin_occupancy of 12.7?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable records with warehouse_id, bin_id and bin_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 15 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows15 columns
Yours1,000 rows15 columns

blueprint · warehouse-bin-location-utilization

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 15 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Bin ID, item category, and timestamp required
  • Track occupancy and utilization rate
  • No SKU or employee identifiers
  • Flag over-capacity events
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
warehouse-bin-location-utilization

More in Logistics

Browse all
Also in LogisticsWarehouse Inventory Movement LogCold Chain Logistics Temperature LogsDelivery Route Optimization DatasetAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.