To perform a slow-moving analysis

A slow-moving analysis calculates the turnover rates, which are compared with the slow-moving percentage as specified in the Inventory Analysis Parameters (whina0100m000) session. This calculation results in a classification of items into ten categories in which the best category has the highest ratio of actual issue/inventory on hand.

When you run the Perform Slow-Moving Analysis (whina6220m000) session, LN calculates the turnover rate according to the following formula:

turnover rate = annual issue of goods / inventory on hand
Note 1

LN calculates the annual issue of goods based on the issue periods present in the Item - Issue by Period (whinr1520m000) session or the Warehouse - Item - Issue by Period (whinr1530m000) session if the total time span of the issue periods exceeds a quarter of a year. If the period type is month, at least four periods must be present. If the period type is week, at least 14 periods must be present.

If fewer periods are present, LN uses the value of the Expected Annual Issue field of the Item - Warehousing (whwmd4100s000) session.

Note 2

The results of the annual issue calculation can differ between issue period type month and issue period type week if the total time of the issue periods is less than one year, as shown in the following example:

Current date1-14-2009
Current month:1
Current week3

 

Period type = Month, total number of periods 12
Issues:
9-26-2008Period = 9 - 2008Quantity = 500
1-14-2009Period = 1 - 2009Quantity = 500

 

The current period is 1 - 2009. The number of periods between the first issue, in period 9, 2008, and the current period, 1, 2009 is 5. Therefore, the annual usage is:

(Total issue quantity/number of periods) * total number of periods per year = 
(1000/5) * 12 = 2400
Period type = Week, total number of periods 52
Issues:
9-26-2008Period = 39 - 2008Quantity = 500
1-14-2009Period = 3 - 2009Quantity = 500

 

The current period is 3 - 2009. The number of periods between the first issue, in period 39, 2008, and the current period, 3, 2009 is 17. Therefore, the annual usage is:

(Total issue quantity/number of periods) * total number of periods per year = 
(1000/17) * 52 = 3059
Example

Typical values for the To Turnover Rate (Upper Boundary) and the Slow-Moving Percentage fields are:

To Turnover Rate (Upper Boundary)Slow-Moving Percentage
0.1090
0.2580
0.5070
0.7560
1.0050
2.0040
4.0030
7.0020
10.0010
99.990

 

Percentage "0" always corresponds with the turnover rate of 99.99.

Related topics