This routine identifies those items that are slow movers, and allows you to manually override the item control values (forecast, EOQ, ROP, SST) for these items. This identification is done on the item/warehouse level. The values are updated in the Item/Warehouse file.
The reason for identifying slow movers is that it is difficult to calculate the purchase control values for these items using common methods. But, by identifying slow movers and manually setting their purchase control values, you can override the values calculated by the system. In doing so, you create more realistic purchase control values for slow movers.
Note: This routine also allows you to interactively work with the calculated values before the actual update in the Item/Warehouse file is done. This is described in Work with a slow moving stock analysis.
- Select the Print slow moving stock analysis/updates menu item.
- On the Slow moving stock list printout/update panel, use the selection fields to narrow down the number of selected items and click OK.
- You access the next panel where you define what items are slow moving, and establish the manual override values to be used when these items are updated.
- Last movement date
- Enter a date indicating the last movement date for the items to be selected. This date is compared to Date of issue in the Item/Warehouse file. All items that have not been moved since the entered date will be included in the analysis.
- No of movements YTD
- Enter the number of movements for the items to be selected. For example, if you enter 5, the system will select those items that have moved five times or less so far this year. The comparison value is retrieved from No of issues YTD in the Item/Warehouse file.
- Year forecast
- Enter a forecast to select items that have a certain year forecast. For example, if you enter 50, then the system selects the items that have a year forecast of fifty or less. Note: The value the system uses for comparison is always the system calculated value. It is never the manually entered year forecast. The comparison value is retrieved from the Item/Warehouse file.
- Null qty periods
- Enter a number to select items for which there has been no demand for a certain number of historical forecast periods. For example, if you enter 4, then the system looks at demand for the present forecast period and the last four historical forecast periods. If there was no demand for a specific item/warehouse combination in these forecast periods, the item will be selected as a slow mover. The demand value is retrieved from the Forecast file.
- Manual frcst
- Enter the manual override year forecast value.
- Manual EOQ
- Enter the manual override EOQ value.
- Manual ROP
- Enter the manual override ROP value.
- Manual SST
- Enter the manual override SST value.
- End date
- Enter an end date for each manually entered override value. If you enter the code 999999, the override remains in effect until you remove this code.
- Update code
- Enter an update code for each manually entered override value defining what fields will be updated in the Item file. Valid codes are:
- Update in work file
- Leave the defaulted NO.
Update criteria
Select one of the following methods for the analysis of slow moving items:
New override values
Enter the new manual override values to be used in the update of the item/warehouse combinations that have been identified as slow movers. The override values are valid until the date that is defined in End date. For each value, you also have to state an update code indicating what should be updated in the Item/Warehouse file.
| Code | Description |
|---|---|
| 1 | Manual year forecast, Manual EOQ, Manual ROP, Manual SST and End override date will be updated in the Item/Warehouse file for all selected slow moving items. |
| 2 | End override date will be updated in the Item/Warehouse file for all selected slow moving items. |
Click OK. The system immediately updates the Item/Warehouse file and prints a report. If you have updated the manual override values, then the old values and the new values are printed for each item/warehouse record in the selection. Exit the routine.