Pickface Maintenance Calculation

FUNCTIONALITY OVERVIEW

This program has been developed as a basic pick face allocation control screen. A system administrator or warehouse manager can use this program to manage the detail of the pick faces in a pick face warehouse. The program takes a defined period of detailed sales data (off the SYSPRO sales order detail tables) to determine the demand per stock code. 

Max Holding - The software then asks the user to define a number of days of stock holding to set as the maximum level in each pick face. This takes the average sales volume of each product per week and then weights it heavily in favor of the peak weeks to attempt to cover the highest peak sales weeks. this is important because the max should not be set to the highest sales week as this may be a complete once off sale. However the max should be a weighed value to cover most peak weeks. 

Reorder (% of Max) - This is a percentage value of the max value to be set as the reorder point for this product  

Min (% of Max) - This is a percentage value of the max value to be set as the minimum stock level for this product.  

The program is then run and the grid is populated with the resulting data. The data is then color coded to better identify what the administrator needs to take action on.

The following colors are shown in the software:

1. Tan Background

- These fields are all calculated values based on the date ranges set by the user. 

1. Black Text  

 - Lines in black text show that this product has not action required

1. Blue Text 

 - Blue lines indicate that the new min and max and reorder values do not match with the current settings in the Pick Face setup. The user will click the 'Update Bin' button to force an update to these fields in DATASCOPE WMS Pick Face setup. 

1. Green Text

-  Green lines show stock codes that have been sold from this warehouse but have no pick face at all. The user should list these green list and allocate these products a pick face within the Maintain Pick Faces program.

1. Red Text  

 - Red lines show that the max level we have set is to large for the bin. The software does this by taking the max value x the product volume in SYSPRO and then compares this to the Bin location volume as set in the Bin Maintenance program in DATASCOPE WMS. 

1. Purple Text 

 - Purple lines show that the max currently set against the pick face setup is less that at least one of the peak weeks. In other words in at least on week the max you have set would not cover that weeks demand. The week data can be seen in the screen by right clicking the line and viewing 'Weekly Demand' option. Ideally your max should be able to cover most of the peak weeks. In these cases you user will need to make a call if the max should to increased. This is done by right clicking the line and updating the max to the new manually entered value. This process also adjusts the reorder and min levels according to the values set at the top of the screen. 

STANDARD PROCESS

• Select the warehouse that needs to be analyzed 

• Enter the from Ship Date and to Ship Dates to identify the data set that this program should use to calculate pick face max, reorder and min levels. 

• Enter the number of days of stock to set for the maximum level

• Enter the % of Max to set as the reorder level

• Enter the % of Max to set as the Minimum level

SPECIAL FEATURES

• This function allows for an automatic update of the pick face max, reorder and minimum stock levels help in the Pick Face data in DATASCOPE WMS

• Often area codes are assigned according to product pick volume. The grid shows the current assigned Area and Zone for each pick face. By sorting this field the user can quickly see if we have fast moving products in a slow moving area. 

• In a future version the software will include a column showing the hit rate of this product. This is the weighted number (outlier average) of time this product has been picked in a week.  

TECHNICAL

• Relevant Settings

 None

SYSPRO Requirements & Business objects used

• None

DATASCOPE Table updates

• tblPickFaceDetails