SECTION 3.5.A7 - SETUP MAX/MIN REORDER POINTS
USAGE: This is a special program, only available for some installations, which is used to automate the allocation of maximum and minimum stock levels.
DISCUSSION: The standard way of entering max/min stock levels is to either enter the data one stock code at a time or to use the ASCII import routine. For some sites, it is useful to automate this process. In this case, HiFinance can compute the limits based on sales figures for a range of dates. The program allows you to enter the number of weeks (or days) if stock you wish to maintain as a minimum and maximum level. The program then computes the figures and automatically inserts them in the stock record. Normally, this procedure is repeated stock group by stock group, as different group often require different lead times.
Please note that, depending on your installation, the lead time can be in either weeks or days (although the discussion below will only show one option).
When you start the program, the screen looks as follows:
The fields available are:
TEST SALES FROM DATE This is the lower and upper limits of the date range to be scanned. HiFinance will scan for sales within these date (inclusive). This allows you to, say, enter a range for the same time last year, or to avoid a special high or low period. You cannot enter a date range greater than 400 days.
MINIMUM LEAD TIME REQUIRED The average sales (per week) will be computed from the above and multiplied by the number of weeks required, and this number will be inserted into the RE-ORDER POINT field.
MAXIMUM LEAD TIME REQUIRED The average sales (per week) will be computed from the above and multiplied by the number of weeks required, and this number will be inserted into the MAX-STOCK POINT field.
The MAXIMUM LEAD TIME must be greater than the MINIMUM LEAD TIME.
Having entered the above fields, the screen will next if you wish to include all Inventory fields in the scan. If you answer N, you will be aske the following:
CODE RANGE Here you may enter a range of Inventory codes for the program to scan. The default values will include all Inventory codes.
GROUP RANGE Here you may enter a range of Inventory Group codes for the program to scan. The default values will include all Inventory Group codes.
Having answered all the above questions, HiFinance will require you to enter the response YES, before proceeding. Once started, the process will continue updating all the Inventory in the ranges you have specified. You will then be returned to the MAIN MENU.