Costing >  Performance analysis >  Cost comparison  

Display all Hide all

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 indicates the references of the product 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.

Currency

 

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.

Cost 1

This field contains the storage and/or production site. It is initialized by default with the normal storage site of the user.

  • 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

This field contains the storage and/or production site. It is initialized by default with the normal storage site of the user.

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

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 :

Block number 1

  • Material (field INTMATTOT)

 
  • Machine (field INTMACTOT)

 
  • Labor (field INTLABTOT)

 
  • Subcontracted (field INTSCOTOT)

 
  • Overhead (field INTOVETOT)

 
  • Total cost (field INTVLTTOT)

 
  • Calculation quantity (field INTCLCQTY)

 
  • Unit cost (field INTUNTCST)

 

Cost 1

  • field MATTOT1

 
  • field MACTOT1

 
  • field LABTOT1

 
  • field SCOTOT1

 
  • field OVETOT1

 
  • field VLTTOT1

 
  • field CLCQTY1

 

 
  • field UNTCST1

 

Cost 2

  • field MATTOT2

 
  • field MACTOT2

 
  • field LABTOT2

 
  • field SCOTOT2

 
  • field OVETOT2

 
  • field VLTTOT2

 
  • field CLCQTY2

 
  • field UNTCST2

 

Variance

  • field DEVIATION

 
  • field DEVIATION2

 

Grid

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

Close

 

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)

 

Block number 2

  • field INTSCO1

 
  • field INTSCO2

 
  • field INTDEV

 
  • Subcontract (field SCOTOT1)

 
  • field SCOTOT2

 
  • field DEVSCO

 

Close

 

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 3

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

Block number 1

  • Material (field INTOVEMAT)

 
  • Machine (field INTOVEMAC)

 
  • Labor (field INTOVELAB)

 
  • Subcontract (field INTOVESCO)

 
  • Total overhead (field INTOVETOT)

 

Cost 1

  • field OVEMATCST1

 
  • field OVEMACCST1

 
  • field OVELABCST1

 
  • field OVESCOCST1

 
  • field OVETOT1

 

Cost 2

  • field OVEMATCST2

 
  • field OVEMACCST2

 
  • field OVELABCST2

 
  • field OVESCOCST2

 
  • field OVETOT2

 

Variance

  • field DEVOVE

 

Grid

  • 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