ABC Class Calculation
This function is used to calculate and update the A/B/C/D classes of the products for a given site.
This allocation is dependent on an ABC type formula and the percentage assigned to classes A and B.
Prerequisite
Refer to documentation Implementation
Screen management
This function is composed of a single screen used to select the site, the formula to be applied and the distribution in % of the ABC classes.
Entry screen
Calculation mode and interpretation
The formula used gives a result by product (value without unit), each product is sorted out depending on this value.
The system then determines the classification with respect to the total of the formula result.
The percentage of classes is used to determine the distribution of the products in each class.
A product whose calculation result is null is construed as a product of class D.
For instance
Distribution of classes A,B,C
-
A: 70 %
-
B: 25 %
-
A: 5 %
The formula used is as follows: (Number of issues in the year * value of the product)
Product |
No. of issues |
Value |
Result |
A1 |
256 |
5 |
1280 |
A2 |
354 |
2,5 |
885 |
A3 |
125 |
45 |
5625 |
A4 |
2550 |
0,65 |
1657,5 |
A5 |
1255 |
2,5 |
3137,5 |
A6 |
985 |
12 |
11820 |
A7 |
1250 |
3,5 |
4375 |
A8 |
0 |
4,5 |
0 |
A9 |
1550 |
2,5 |
3875 |
A10 |
150 |
45 |
6750 |
Sorting and classification of the products
Product |
No. of issues |
Value |
Result |
Total |
Total % |
Class |
A6 |
985 |
12 |
11820 |
11820 |
30,00 |
A |
A10 |
150 |
45 |
6750 |
18570 |
47,13 |
A |
A3 |
125 |
45 |
5625 |
24195 |
61,40 |
A |
A7 |
1250 |
3,5 |
4375 |
28570 |
72,50 |
A |
A9 |
1550 |
2,5 |
3875 |
32445 |
82,34 |
B |
A5 |
1255 |
2,5 |
3137,5 |
35582,5 |
90,30 |
B |
A4 |
2550 |
0,65 |
1657,5 |
37240 |
94,51 |
B |
A1 |
256 |
5 |
1280 |
38520 |
97,75 |
B |
A2 |
354 |
2,5 |
885 |
39405 |
100,00 |
C |
A8 |
0 |
4,5 |
0 |
39405 |
100,00 |
D |
Block number 1
| Stock site (field STOFCY) |
|
Enter or select the storage site where the selected product is active. The Selection icon (magnifying glass) only suggests products that are referenced in the products-sites table. |
Block number 2
| Processing selection (field CLCCOD) |
|
Choice of process: Without update: simple calculation with the possibility to update later. With update: the calculated class replaces the previous ABC class of the product-site entry. Update only: the values calculated during the previous "without update" process replaces the previous values for the whole site. |
Block number 3
| Formula code (field FORCOD) |
|
Code used to identify the calculation formula. A calculation formula is a short code calling on an expression to evaluate a result used in various functions of the product. |
| Description (field FORDES) |
Formula
| field FORFOR |
Percentage classes
| Bracket 'A' (field AAABKT) |
|
To give as a percentage for classes “A”, “B” and “C” the proportion of the class with regard to the total calculation. Class “D” is calculated by difference to 100% |
| Bracket 'B' (field BBBBKT) |
| Bracket 'C' (field CCCBKT) |
| Bracket 'D' (field DDDBKT) |
| Total (field TOTPRC) |
Number and %
| Bracket 'A' (field AAABKTNBR) |
| field AAABKTPRC |
| Bracket 'B' (field BBBBKTNBR) |
| field BBBBKTPRC |
| Bracket 'C' (field CCCBKTNBR) |
| field CCCBKTPRC |
| Bracket 'D' (field DDDBKTNBR) |
| field DDDBKTPRC |
| Total (field ITMPRONBR) |
| field ITMPROPRC |
Batch task
This function can be run in batch mode. The standard task FUNSTKA is provided for that purpose.
Specific Buttons
|
Memo |
This button is used to allocate a memo code. |
|
Recall |
This button is used to recall a Memo code. |
|
Delete Memo |
This button is used to delete a memo code. |