Stock > Periodic processing > 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

    SEEREFERTTO 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

    Presentation

    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

    Close

     

    Fields

    The following fields are present on this tab :

    Block number 1

    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

    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

     

    Close

     

    Batch task

    This function can be run in batch mode. The standard task FUNSTKA is provided for that purpose.

    Specific Buttons

    Validation via the is used to start the process.

    If the process is of calculation type, after said type has been validated, the frequency and the number of products found by category (A, B, C, D) is determined. Once the calculation is completed, validation via the End button provides access to the log of the detailed result. This log shows in detail the new A,B,C classification by product, by indicating by product the value found by the result.

    If the processing is of update alone type, after validating via the OK button, the data update is carried out without log.

    This button is used to allocate a memo code.

    This button is used to recall a Memo code.

    This button is used to delete a memo code.

    Error messages

    In addition to the generic error messages, the following messages can appear during the entry :

    Site name: xxx non-existent record

    This message appears when the specified site is not a declared site.

    Error when assessing the formula

    The formula used by the calculation is not compliant.

    Tables used

    SEEREFERTTO Refer to documentation Implementation