The system maintains a tally of how many parts have been perpetually checked in each stock-check classification. With the information in each classification record and the system parameters, the system is able to provide an accurate model of the volumes to be included in each daily stock check list.
To display the perpetual model:
Warning: Before selecting this option, you must check the fields Days per year and Start of year in the SC system parameters and run the option Rebuild stock count.
From the Master Menu, select the Stock checking option and the Company you require.
You are prompted for the stock location.
Select the Stock Location.
The STOCK CHECKING menu is displayed.
Select Perpetual options.
The SC PERPETUAL OPTIONS menu is displayed.
Select the Display perpetual model option.
The Display Perpetual Model form is displayed.
Select the Output type and click OK.
The report is compiled, and output in the selected format.
This form is displayed when the Display perpetual model option is selected from the SC PERPETUAL OPTIONS menu.
Output type: Select an output type for the report from one of the following:
Print: Prints the report to the currently selected printer
Display: Displays the report
HTML: Outputs the report to file in Hyper-Text Markup Language (HTML) format, to be viewed via the default browser
Note: The default setting for Output type is Display.
PUSH BUTTONS:
OK: Outputs the report in the selected format
Cancel: Returns you to the SC PERPETUAL OPTIONS menu
Help: Displays help on the current program in your default browser
If the results are not satisfactory, there are various techniques of adjustment:
Alter the count frequency of one or more classes
Re-classify the parts in your stock file
Count weekly by reducing the system parameter Days per Year by a factor of 5
The perpetual model is displayed when the OK button is clicked on the Display Perpetual Model form. Following is an example of a perpetual model:
Classification Code A Fast moving
500 lines in stock
Count Frequency 10 times/year
1500 items counted this year to date
Classification Code B Average moving
2500 lines in stock
Count Frequency 4 times/year
3000 items counted this year to date
Classification Code C Slow moving
300 lines in stock
Count Frequency once per year
150 item counted this year to date
The number of checks to be made in each category is:
Classification Code A: 500 x 10 = 5,000
Classification Code B: 2500 x 4 = 10,000
Classification Code C: 300 x 1 = 300
There are approximately 240 check days in a year. If a stock-check year started 01/06/99 and today is 01/10/99 then there are only 160 counting days remaining in the year.
In the example above, the perpetual model results thus:
Classification Code A (5,000 - 1,500) / 160 = 22 per day (rounded up)
Classification Code B (10,000 - 3,000) / 160 = 44 per day (rounded up)
Classification Code C (300 - 150) / 160 = 1 per day (rounded up)
Note: If a Perpetual Inventory is generated but not counted, the tally of counts-to-date in each classification record remains static. Therefore the system demands that more parts are counted per day to achieve the yearly target.
Classification code C is a good example of a reducing count. On day one it demands 2 parts to be counted (300/240) rounded up. As time goes on it reduces to 1 per day (as shown above in the example). It eventually oscillates between 0 and 1 per day in order to achieve 300 parts counted per year.
When the Rebuild stock count option is run, it may often alter the number of parts held in each class, therefore it alters the result of the model.
The stock file actually holds a number of invisible fields which are adjusted when perpetual stock check is updated:
Quantity of variances picked up year to date PPIQVAR
Value of variances picked up year to date PPIVVAR
Date last perpetual stock check PPIDATE
