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

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

Block number 1

Product (field ITMREF)

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

Storage site (field STOFCY1)

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.

 
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

Storage site (field STOFCY2)

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.

 
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

field CUR

Graph

Null value (field AFFZER)

Tab Cost Comparisons

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

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)

Tab Material / Subcontracted

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

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

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

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)

Tab Overhead Cost

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

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)

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