The Pickface Maintenance Calculator is a new addition to the DATASCOPE WMS. The purpose of this screen would be to maintain optimum levels for the pickface locations.
Previously, such a crucial process was done manually by analysing the Sales History for the customers at a SKU level and averaging out the sales over a 1-2 week period. This method gave a “general feel” for the demand on a SKU but it was not very accurate from a real life picking and demand perspective. This manual method didn’t take into account that there are peak and lean periods during the year.
The pickface maintenance calculator bridges this gap making the maintenance of the pickface locations easy and accurate as it is based on actual sales order historic data. It is a powerful tool that provides the following functions to the project manager at the initial stages of the WMS project as well as for routine maintenance:
• Analysis of Sales History, based on historic Sales Order demand
• Demand at a weekly bucket level based on averages
• Outlier analysis and drill down
• Bin size, min, max suggestion and manipulation
• Directly updating of the Pickface setups from the screens.
The screen itself is fairly simple. There are parameters provided at the top for filtering the historic sales orders data. Sales orders can be filtered on warehouse and date range.
Figure 1: Report Filters
The next group of parameters are used for the actual calculations of the maximum, minimum and reorder levels of the pickface bins.
Figure 2: Required Values
The results are displayed in the grid. The calculated columns have been highlighted, to indicate that these values will be updated to the database. The user can hover over the calculated columns to see the formula that has been applied. The colour legend is located top right hand corner for reference. The description of each item is displayed by hovering over the item.
Figure 3: Colour Legend
The first time the results are displayed, the rows will be mostly in green or blue colour, which means that the lines that have no pickface setup (green) or the lines that haven’t been updated to the database (blue). All lines are selectable except the ones that have no pickface setup (green). The user can see the calculated values and actual values in the database for comparison. Clicking on “Update Bin”, accepts the calculated values of the selected lines. The screen will refresh on success, however, the colour of the lines will have now changed and should not be in blue any longer.
Figure 4: Screen before updating Bin values
The results will either be in black, green, red or purple colour. The red lines are the ones where the bin’s volume has been exceeded and the lines where maximum amount in a week exceeds the calculated value appears in purple. These highlighted lines need to be actioned (red, purple and green). If no action is required, the lines are displayed in black. The aim would be to see all lines in black which means that there are no foreseeable problems with the pickface set-up.
Figure 5: Screen after updating Bin values
The breakdown of sales order per week can be viewed by right-clicking and selecting “Weekly Demand”. This would show the order quantities for a week across the date range entered. This gives the trend of the SKU in order to make a better judgement of how the bin levels would differ during different times of the year.
Figure 6: Weekly Demand
In conclusion, the Pickface Maintenance Calculator is a robust and efficient way to manage and setup the pickface bins in the warehouse. All the pickface bins can be analysed and setup all at once. DATASCOPE WMS is committed to making warehousing simple and this is another step being taken in this direction.