Production cost inquiry

Use this inquiry to obtain the breakdown by cost type of the production cost price for a work order and released product.

The production cost price for the work order needs to have been updated before you can use this inquiry.

Prerequisites

Refer to the documentation on Implementation.

Screen management

For each cost group, the inquiry displays the production cost price for the work order and the calculation parameters used.

It also displays a graph representing the cost price breakdown by cost type.

Home section

Product (ITMREF)
The product reference.
Stock site (STOFCY)

The storage site (warehouse).

The site defined on the user record is displayed by default. You can change it.

In the Sites function (GESFCY), a storage site has the Stock checkbox in the Details section selected.
Year (YEA)
The calculation year.
Currency (CUR)
The currency in which the costs and prices are expressed.
Work order (VCRNUM)
The number of the source document or order.
Line no. (VCRLIN)
The number corresponds to the range of the released product line on the source order with multiple released products. The first range = 1000, the second range = 2000, and so on.
Major version (ECCVALMAJ)
The version of the product. Major versions might be used where there have been increased or significant changes to the original or previous version. The "form, fit, or function" has changed.
Minor version (ECCVALMIN)
The minor version of the product. Minor versions might be used where there have been minor features or changes in functionality, or significant fixes applied to a specific major version.
Order status (MFGSTA)
The order status.
Project (PJT)

Links production of the product with a specific project.

The value can be one of the following:

  • A project code
  • A project code and a project budget code
  • A project code and a project task code, that's a material task code, a labor task code (sales only), or a combined (mixed) labor and material task code

If the value of this field includes a character such as an exclamation mark "!", this field links to the structure of the project. The character is the separator between a project code and the structure, either the project budget structure or the project operational (task) structure. For example, if a material task code is "USA-P3" and a project code is "USA12345678", this field displays a link to the project operational structure as "USA12345678!USA-P3."

To provide a quick and easy visual reference, the link to the project or project structure is distinguishable by the number of separator characters used. If there's no separator, the link is made to the project. A single separator character such as an exclamation mark after the project code, the first code indicates that the link type is a task. The link is to the project operational structure. 2 separators placed after the project code mean that the link corresponds to a budget code. The link is to the project budget structure.
Product category (TCLCOD)
The product categories are used to classify and filter the products according to their use.
Product status (ITMSTA)

The product status determines how its availability has evolved. The different statuses are: Active, In development, On shortage, Not renewed, Obsolete, and Not usable.

During product creation, the default status depends on the creation method defined for the assigned product category:

  • If the product category Creation method is set to Direct, the product status will be Active.
  • If the product category Creation method is set to With validation, the default product status will be In development.
Cost group (BRDCOD)

The cost group set on the product.

Cost calculations are used to break down material costs. It defines where (subtotal) the material cost for the product category needs to be posted.

The MAT—Number of material groups activity code defines how many family cost groups are available.
Date calculated (MFCDAT)
The cost calculation run date.
Overhead (OVECOD)

Overhead codes are used as follows:

  • To value selected stock movement types.
    The column that defines the formula or fixed rate to be used for the calculation is defined by the OVECOLSTK—Stock overhead column parameter (STO chapter, VAL group).
  • To determine the cost price or the production cost price calculation.
    Selected functions use the overhead code for the following:
    • To value work center overheads associated with the valuation dimension.
    • To value overheads for materials or semi-finished products.

The overheads column that contains the formula or fixed rate to be used in the cost price calculation functions is defined by parameters. For standard cost calculations the OVECOLSTD—Standard calc overhead column parameter (GPA chapter, COS group) applies.

You can modify the column to be applied before running the calculation.
Ratio (%) (CPLRIO)

The ratio of how much more or how much less the actual cost is compared to the expected cost.

If Actual = 20 and Expected = 20
Ratio = 0%

If Actual = 31 and Expected = 24
Ratio = 29.17%
(31 - 24) / 24 * 100)
Calculation quantity (QTYSTU)
The shipped quantity expressed in the stock unit.
Planned quantity (EXTQTY)
The planned quantity. The quantity is expressed in the stock unit.
Actual quantity (CPLQTY)
The actual completed quantity, in total. This includes the rejected quantity. The quantity is expressed in the operation unit.

Tabs Level cost and Multilevel

These sections contain costs for the product-site combination and a graphical representation of those costs.

Production cost

Material (MATTOT)
The stock value for the product.
Component (MATLEV0)
The stock value for the components directly associated with the top level of the bill of materials (BOM).
Machine (MACTOT)
The machine cost for the product-site combination.
Labor (LABTOT)
The labor cost for the product-site combination.
Subcontract (SCOTOT)
The subcontract service cost for the product-site combination. The price used to value the service is specified by the VLTSCEOEXT—Service value price/planned PC parameter (ACH chapter, COS group).
Overhead (OVETOT)
The overhead costs for the product-site combination.
Total without overhead (CSTTOT)
The total cost for the product, excluding the overhead costs total from the Overhead (OVETOT) field.
Total cost / Total with overhead (TOTWITOVE)
The total cost for the product, including the overhead costs total from the Overhead (OVETOT) field.
Detail (MFCDET)
Select the Magnifying glass icon to view a breakdown of the costs.

Graph: Production cost

Select the checkbox to display the costs for the product-site combination in a graphical format.

Family detail (DETFLG)
Displays the cost of each cost group for the product-site combination.
Material (MATFLG)
Displays the stock value for the components directly associated with the top level of the bill of materials (BOM).
Machine (MACFLG)
Displays the machine cost for the product-site combination.
Labor (LABFLG)
Displays the labor cost for the product-site combination.
Subcontract (SCOFLG)
Displays the subcontract service cost for the product-site combination. The price used to value the service is specified by the VLTSCEOEXT—Service value price/planned PC parameter (ACH chapter, COS group).
Overhead (OVEFLG)
Displays the overhead costs for the product-site combination.
Total (TOTFLG)
Displays the total cost for the product, including the overhead costs.

Tab Parameters

This section displays the value of the parameters used in the production cost price calculations.

Calculation setup

BOM code (BOMALT)
Multiple bills of material (BOMs) can be defined for a single product. Each BOM code can be assigned specific management features. For manufactured or subcontracted products, a BOM can be restricted to a site and to specific areas of functionality, such as for costing, or for capacity planning.
Routing code (ROUALT)
Multiple routings can be defined for a single product. Each routing code can be assigned specific management features. These include restriction of the routing to a specific site and to specific areas of functionality such as for use in a manufacturing environment, for costing, or for capacity planning. This field defines the route for the calculation of the components, machines, resources, workforce, and subcontractors.
Material (SLTMATCST)

The type of cost used to value the materials:

Standard cost
Revised standard cost
Budget cost
Simulated cost
Last cost. This value corresponds to the cost of the last recorded movement.
Average cost
Last purchase price. This value corresponds to the last receipt price or last invoice.
List price. The material is valued from a price list with a supplier/product priority type.

The default cost type is defined in the CLCxxxMAT—Mat cost selection xxx calc parameter (TC chapter, COS group), where xxx corresponds to the type of cost calculation being performed: Budget, Standard, Revised standard, Simulation. You can change the default cost type.

The cost type only applies to the cost calculation of a component without a BOM for the alternative. The cost of a product with a BOM is calculated based on the cost of its components. The cost of materials from a subcontractor always comes from a price list. If the price list is not found, the standard cost can be used if the PURPRICE—Standard cost default price list parameter (ACH chapter, PRI group) is set to Yes.
Semifinished (SLTSEMCST)

The type of cost used to value the subassemblies:

Standard cost
Revised standard cost
Budget cost
Simulated cost
Last cost. This value corresponds to the cost of the last recorded movement.
Average cost
Last purchase price. This value corresponds to the last receipt price or last invoice.
List price. The material is valued from a price list with a supplier/product priority type.
Dimension rate (VLTCCERAT)

The dimension rate used to value time.

The default cost type is defined in the CLCxxxRAT—Dimension rate selection xxx calc parameter (GPA chapter, COS group), where xxx corresponds to the type of cost calculation being performed: Budget, Standard, Revised standard, Simulation. You can change the default dimension rate.
Overhead column (SLTOVECOL)

Defines how overheads are valued. The default column is defined in the OVECOLxxx—xxx calc overhead column parameter (GPA chapter, COS group), where xxx corresponds to the type of cost calculation being performed: Budget, Standard, Revised standard, Simulation. You can change the default column.

The value of an overhead is calculated by applying the fixed rate or the formula in the chosen calculation column.

Reports

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

This can be changed using a different setup.

Specific actions

History Select the History action to view the history of the Production Cost Prices (PCP) for the product-site combination.

Error messages

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

Record does not exist

This message appears after entering the work order number if no production cost record corresponds with the 4 identifying elements already entered.

Tables used

Refer to the documentation on Implementation.