Redwood: Optimize Pick Locations with Reslotting Workbench

We’re introducing a new Reslotting Workbench which allows you to realign inventory pick locations based on current Item velocity (ABC rankings). It identifies mismatches between item velocity and location rankings and generates replenishment tasks to re-slot the material. This helps to maintain optimal pick paths, reduce manual effort, and improve picking efficiency.

NEW RESLOTTING WORKBENCH UI

The intuitive Reslotting Workbench (UI) is designed to help warehouses optimize inventory placement based on product velocity, seasonality, and demand patterns. This new UI will help improve operational efficiency by reducing picker travel times and congestion with smarter inventory placement.

You can view important location and item details and Key Performance Indicators (KPIs) all in one Workbench style display:

Reslotting UI with Location Ranking and Location Capacity Display

Reslotting UI with Location Ranking and Location Capacity Display

On the left side, the UI includes a user-friendly data grid where you can Search, filter, and sort by critical fields such as Location, Ranking, Item, Facility, Inventory Cost, and more.

NOTE: For the Workbench Graphs, we will only allow up to 6 rankings to be displayed on the graph.

VIEWING THE GRAPHS

When you are viewing the Workbench Graph KPIs / Location Capacity by Ranking, you can toggle between 3 metrics.

  • You can view Active Locations metrics by: Volume, Weight, Units   
  • You can view Reserve Locations metrics by:  Volume, Weight, LPNs

NOTE:  The colors for the bars on the charts will always display in the same order. (i.e. green, orange, teal.) The colors are not based on their Ranking.

INITIATE RESLOT MOVEMENT ACTION BUTTON

The Initiate Reslot Movement action button will create a request in order to send the selected records to a drop location. This button is permission-based.

GENERATE NEW REPORT

You can click Generate New Report to run a new report with all of the Reslotting details from the Workbench UI for further analysis. You will see a buffering icon while the new report is being generated. You can click the CSV Export button to download to CSV format.

NOTE:  Only users with supervisor-level permissions can invoke it.

LOCATION RANKING FIELD ADDED TO LOCATION UI/PATCH API AND INPUT INTERFACE  

We’ve added a new report GET API that will generate the Reslotting Workbench metrics in a stacked bar chart format. This will display Location data such as volume, weight, and LPNs.

CONFIGURATION FOR VELOCITY CODE AND LOCATION RANKING 

To configure an item’s Velocity Code Ranking, use the Item-Facility Velocity Code field in the Item Facility UI. This value can be set Manually, via Init Stage API, or Input Interface upload.

Velocity Code Field

Velocity Code Field

To configure an item's Location Ranking, use the newly introduced Location Ranking field on the Locations UI. This value can be set Manually, via Init Stage API, or Input Interface upload.

Location Ranking Field

Location Ranking Field

NOTE: For the Location Ranking and Item Velocity Code Ranking to work, they both MUST match in naming convention. 

FOR EXAMPLE:

  • Item Velocity Codes: A, B, C, D and Location Rankings: A, B, C ,D or
  • Item Velocities: Hot, Fast, Medium, Slow and  Location Rankings: Hot, Fast, Medium, Slow.

LOCATION CAPACITY METRICS GET API

We've added a new Location Capacity Metrics GET API which will generate and display in a stacked bar chart the following:

  • How much capacity is available per location ranking and per filter (max weight, volume or lpns (reserve only)).
    • x axis = location ranking, y axis = % of capacity filled by mismatches

API URL

GET... /lgfapi/report/reslotting_location_capacity_metrics?metric={metric}

SAMPLE RESPONSE

[
  {
    "rank": "A",
    "total_item_metric": 100.0,
    "max_metric_by_ranking": 150.0
  }
]

CREATE INVENTORY ACCURACY METRICS GET API  

We’ve added a new reporting GET API that will generate the following Reslotting Workbench accuracy metrics in a stacked bar chart:

  • The percentage of Items in locations where item_velocity_code = location_ranking
  • How many items are in each location rank, how many are correctly vs incorrectly slotted
    • The fields used are: SKU, item_velocity_code, location, location_ranking
      • x axis = item count, y axis = location rank

API URL

GET... /lgfapi/report/reslotting_inventory_accuracy_metrics

SAMPLE RESPONSE

[

  {

    "rank": "A",

    "accurate_qty": 50.0,

    "total_qty": 100.0

  }

]

Steps to Enable

To access the Reslotting Workbench:

  1. From the User drop-down, select -> Try the new Redwood Experience.
  2. After the Redwood screen opens, click the Home with Ask Oracle button in the bottom right. 
  3. Select the Putaway and Slotting tile, then Reslotting.

VELOCITY CODE AND LOCATION RANKING

  1. To configure an item’s Velocity Code Ranking, use the Item-Facility Velocity Code field in the Item Facility UI. This value can be set Manually, via Init Stage API, or Input Interface upload.
  2. To configure an item's Location Ranking, use the newly introduced Location Ranking field on the Locations UI. This value can be set Manually, via Init Stage API, or Input Interface upload.