The movement history of a partnumber is a month by month log of the quantities issued from stock and received into stock, and the value of the movements. This movement history is created by the Store module data maintenance option transfer transactions. If you do not run this option first, there will be no movement history in the History module.
Many of the History module reports print details for a range of items. This allows you to select which information should be printed. However, you should take care when selecting the ranges for reports, as a report with a large range could be lengthy. Note that to start from the beginning of a range the word FIRST should be entered as the ‘from’ value. To go to the end of a range enter the word LAST as the ‘to’ value.
The Reports In Detail
A movement history report lists monthly movements for a range of partnumbers, giving a statistical summary for each. This report is invaluable when preparing forecasts or determining stock reorder levels etc:
An ABC analysis report performs an ABC calculation, based on the data in the movement history file. Each partnumber in the store module is given a classification of A, B, C or Z based on its calculated usage-value for a given period:
The usage-value of an item is calculated like this:
usage-value = quantity issued during period x standard cost of item
The full ABC coding calculation is performed as follows:
The usage-value of each stock item is calculated for the period specified. This period is normally a year, but you can alter this as required. You can dictate whether Herschel should use the historic costs held in the history file, or the current standard costs held in the store module.
The partnumbers are sorted in descending usage-value sequence, and the total usage-value for all items is calculated. Starting from the top of the list, an A coding is given to those items that make up the first 80% of the total usage-value. Those items that make up the next 15% of the total usage-value are coded as B items, and those that make up the last 5% are coded C. You can change the various percentages if required, although most companies find an 80/15/5 split is satisfactory.
Those items with zero usage-value (because they have no movement history on file, or perhaps their standard cost is zero) are given an ABC coding of Z.
A report detailing the partnumber codings is produced. You can print any of the codings as required.
If required the ABC classifications held on the stock file in the store module can be updated with the newly calculated classifications.
Using ABC coding can make your materials management far more effective - if you control your A coded items closely you will be managing 80% of the stock (by value) issued in a year, even though the number of A coded items is fairly small when compared to the number of stock items on file.
A redundant stock analysis report analyses the movement history of all partnumbers for a given period, and compares the average monthly usage of each item with its stock on hand quantity. Any items with more than a given number of months stock are listed. This report can be used to identify redundant or slow moving items:
An obsolete stock analysis report identifies partnumbers in stock which are not used in any of your assemblies. This report can be used to identify redundant or slow moving items. Note this report does not use movement history to do its calculations: