Costing > Performance analysis > Print cost comparison 

This function is used to compare two costs according to several criteria.
For instance: comparison between a revised standard cost for a given year and another revised standard cost for any basic product, or for products in a selection.

    Prerequisite

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    General principle

    First cost - Second cost

    These two fields are used to enter the information relating to the two costs to be compared.

    Start/End ranges

    This block is used to enter the start and end selection criteria.

    Variances

    The criteria selected in this field are used to filter the submitted products based on variances (in percentage or amount) between the two costs. For instance, it is possible to only display on the report material variances larger than or equal to 5%
    If these fields are left blank, the system will not filter the results and it will display all the information found.

    Display

    The selected criteria in this field are used to specify whether the cost sub-groups should be displayed or not.

    Entry screen

    Fields

    The following fields are present on this tab :

    First cost

    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.

    • Cost type (field CSTTYP1)

    Cost type to choose from "Standard", "Revised", "Budget", "Simulated".


    • Validity start date (field DAT1)

    This field is used to enter the validity start date.

    Second cost

    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.

    • 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.


    • Validity start date (field DAT2)

    This field is used to enter the validity start date.

    Start - end range

    The product categories are used to classify and filter the products according to their use. This step makes it possible to refine the selection prior to carrying out the adjustment process. This code is used in the Product record to enable selections.

     

    Enter the selection start product number. The product ranges limit the report to these products only.

    Enter the ending product number for the selection. Product ranges are used to restrict the report to these products only.

    Filter for results within a range of valuation methods. For a single valuation methods, enter the same valuation method code in the From valuation method and To valuation method fields. You can leave the From valuation method field blank to search all valuation methods.

    End range of the valuation methods that must be applied to the products to be selected for the report.

    Filter for results within a range of buyers. For a single buyer, enter the same code in the Start/from buyer and To/end buyer fields.

    These fields are not available for entry when the Accounting date check box is selected, and the Costing mode is set to Primary issue method or Secondary issue method.

    Enter the ending buyer to select entries to be processed.

    This option is not available when the Accounting date check box is selected and the Costing mode is Primary issue method or Secondary issue method.

    Code of the product statistical group, comprised of three alphanumerical characters, to be entered for the chosen group. It is associated with a meaningful label.

     

    Grid Variances

    • Description (field LINE)

     

    • Filter (field SELFLG)

     

    • Percentage (field VARPER)

     

    • Amount (field VARAMT)

     

    Display

    • Material (field MATFLG)

    When these boxes are ticked, they are used to view the variances on material, machine, workforce, sub-contracting and overheads.

    • Machine (field MACFLG)

     

    • Labor (field LABFLG)

     

    • Subcontract (field SCOFLG)

     

    • Overhead (field OVEFLG)

    When these boxes are ticked, they are used to view the variances on material, machine, workforce, sub-contracting and overheads.

    • Detail (field DETFLG)

    When checked, this box activates the display of the cost sub-categories (material, machine, ...).

    Close

     

    Specific Buttons

    The following fields are included on the window opened through this button :

    • Memo code (field CODE)

    You use a memo code to save the criteria applied to an entry screen. Use this field to find out if a memo code has already been saved for the current screen values.

    Use the following buttons to manage memos:

    Recall: Recall a previously defined and saved memo.

    Memo: Save the current values of the screen in a memo file with a code to be specified.

    Del. Memo: Delete a previously saved memo.

    If a memo named STD (standard) is associated with the screen, it is loaded when opening the function.

    Close

    This button is used to save a memo from the screen.

    Tables used

    SEEREFERTTO Refer to documentation Implementation