Costing > Performance analysis > Cost comparison 

This function is used to compare two projected costs or two cost prices for a given product, whether they were calculated on the same site or two different sites.

This function is used to calculate the variances in percentage or in quantity, with a comparison by unit or in the total amount. It displays the variances by cost categories (Material, Machine, Overheads) on various tabs.

    Prerequisite

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Header

    Presentation

    Selection criteria

    Product

    The product on which the costs will be compared must be indicated.

    Variance type

    The variance type which will be displayed in the last column of the screens must be indicated.

    Percentage: The comparison column indicates a percentage. The first cost entered is used as reference cost.

    Unit Display

    It is possible to either compare the costs by unit (box checked), or compare costs according to the data of each cost calculation (calculation quantity).

    Comparison criteria

    This paragraph is used to indicates the cost comparison basis. The first cost type entered is used as reference cost in the comparison.

    For each cost to compare, it is necessary to indicate:

    Site

    Site from which the cost is taken.

    Cost type

    The cost type to compare must be indicated.

    Calculation date

    The calculation date can be entered for all types of costs.

    Work order no.

    This number can be entered in the case of a search for a cost with the type PCP or projected cost.

    The contextual menu is used to search the required order number.

    Level 

    The comparison can be single-level or multi-level. In single-level comparison, the various cost types of the semi-finished are totally integrated in the material part. In multi-level comparison, they are split between the material part, the machine part, ...

    Close

     

    Fields

    The following fields are present on this tab :

    Block number 1

    This field specifies the reference of the product to to process.

    • Variance type (field DEVTYP)

    The calculated variance can be displayed in quantity or in percentage.


    • Unit display (field UNTFLG)

    When this box is checked, all displayed sub-totals represent unit values.
    When not, the sub-totals represent the global values for the calculation quantity.


    Cost 1

    Use this field to define the storage and/or production site.

    The site defined on the user record is displayed by default but can be amended.

     A storage site has the Stock check box in the Details section selected.

    • Cost type (field CSTTYP1)

    Cost type to choose from 'Standard', 'Revised', 'Budget', 'Simulated'.
    For an updated or simulated cost, the date must be entered or the Calculation date field selected.


    • field VCRTYP1

     

    • Date calculated (field ITCDAT1)

    Cost calculation date. This date is stored in Product-cost. It is initialized to the current date and it is not necessarily included in the calculation year (for instance, calculation of the 2000 buget performed in December 1999).
    From this field, it is possible to make a selection on the costs or the cost price (depending on the type entered)


    • Sequence no. (field ITCSEQ1)

     

    • Validity start date (field ITCSTRDAT1)

     

    • Validity end date (field ITCENDDAT1)

     

    • Order no. (field VCRNUM1)

    Work order/sub-contract order numbers used to select a cost price.
    This number is followed by the line number of the release product.
    The line number corresponds to the range of the released product in a multiple works order/sub-contract order, in case of a multiple release.
    First range: 1000, second range: 2000, etc.

    Cost 2

    Use this field to define the storage and/or production site.

    The site defined on the user record is displayed by default but can be amended.

     A storage site has the Stock check box in the Details section selected.

    • Cost type (field CSTTYP2)

    Cost type to choose from 'Standard', 'Revised', 'Budget', 'Simulated'.
    For an updated or simulated cost, the date must be entered or the Calculation date field selected.


    • field VCRTYP2

     

    • Date calculated (field ITCDAT2)

    Cost calculation date. This date is stored in Product-cost. It is initialized to the current date and it is not necessarily included in the calculation year (for instance, calculation of the 2000 buget performed in December 1999).
    From this field, it is possible to make a selection on the costs or the cost price (depending on the type entered)


    • Sequence no. (field ITCSEQ2)

     

    • Validity start date (field ITCSTRDAT2)

     

    • Validity end date (field ITCENDDAT2)

     

    • Order no. (field VCRNUM2)

    Work order/sub-contract order numbers used to select a cost price.
    This number is followed by the line number of the release product.
    The line number corresponds to the range of the released product in a multiple works order/sub-contract order, in case of a multiple release.
    First range: 1000, second range: 2000, etc.

    Level

    • field NIV

    Selection of the display methods for the costs.

    The choice is only possible to compare the standard costs.

    When "Single level" is ticked, the global costs for the components are included in the material.

    When "Multi-level" is ticked, the costs are distributed according to their real nature.

    Currency

     

    Graph

    • Null value (field AFFZER)

     

    Close

     

    Tab Cost Comparisons

    Presentation

    This tab is used to display the total of the costs by category (Material, Labor Cost, Subcontracted, Overheads, Main total, Calculation Quantity).

    Close

     

    Fields

    The following fields are present on this tab :

    Table number 1

    • Description (field LINE)

     

    • Cost 1 (field COST1)

     

    • Cost 2 (field COST2)

     

    • Variance (field VARCST)

     

    Table number 2

    • field NBLIG1

     

    • Description (field LBL)

     

    • Cost 1 (field CST1)

     

    • Cost 2 (field CST2)

     

    Close

     

    Tab Material / Subcontracted

    Presentation

    This tab is used to display the cost comparisons by sub-category of the categories material and subcontracted.

     

    Fields

    The following fields are present on this tab :

    Table number 1

    • Cost group (field FAMMAT)

     

    • Cost 1 (field MATCST1)

     

    • Cost 2 (field MATCST2)

     

    • Variance (field DEVMAT)

     

    Table number 2

    • field NBLIG2

     

    • Description (field LBL)

     

    • Cost 1 (field CST1)

     

    • Cost 2 (field CST2)

     

    Subcontract

    • Cost 1 (field SCOTOT1)

     

    • Cost 2 (field SCOTOT2)

     

    • Variance (field DEVSCO)

     

     

    Tab Machine/labor

    Presentation

    This tab is used to display the cost comparisons by sub-category of the categories machine and labor.

    Close

     

    Fields

    The following fields are present on this tab :

    Grid Machine

    • Cost group (field FAMMAC)

     

    • Cost 1 (field MACCST1)

     

    • Cost 2 (field MACCST2)

     

    • Variance (field DEVMAC)

     

    Table number 2

    • Description (field LBL)

     

    • Cost 1 (field CST1)

     

    • Cost 2 (field CST2)

     

    Grid Labor

    • Cost group (field FAMLAB)

     

    • Cost 1 (field LABCST1)

     

    • Cost 2 (field LABCST2)

     

    • Variance (field DEVLAB)

     

    Close

     

    Tab Overhead Cost

    Presentation

    This tab is used to display the comparisons by cost group from overheads.

    Close

     

    Fields

    The following fields are present on this tab :

    Table number 1

    • Description (field LINE)

     

    • Cost 1 (field COST1)

     

    • Cost 2 (field COST2)

     

    • Variance (field VARCST)

     

    Table number 2

    • Description (field LBL)

     

    • Cost 1 (field CST1)

     

    • Cost 2 (field CST2)

     

    Close

     

    Reports

    By default, the following reports are associated with this function :

     ITCMATCH : Cost comparison

    This can be changed using a different setup.

    Error messages

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

    Product ... The record does not exist

    This message appears after the entry of the product reference if the corresponding record has not been found. You can check this by using the selection window.

    Site... The record does not exist

    This message appears after the site entry if the corresponding record is not found. You can check this by using the selection window.

    Both sites must have the same currency!

    This message is displayed after entering the second site if its currency is not the same as the currency of the first site.

    Record does not exist

    This message is displayed after entering the calculation date (for projected costs) or after entering the order number (for PCP) when no record corresponds to the criteria entered. You can check this by using the selection window.

    Tables used

    SEEREFERTTO Refer to documentation Implementation