You can add several equations to the same element. This is useful if the calculation to be performed differs depending on the type of item. For example, the calculation of the material cost may differ between sub-assemblies and end items.
Note: The Item wc price type and Item cost type pc fields in the MFG control file define what type of cost values should be retrieved when an equation is used in a calculation.
- Select the Work with cost models menu item.
- On the initial panel, select the applicable cost model and click Elements.
- You access Work with cost models, Elements. Select the element to which you want to add equations and click Equation.
- You access Work with cost models, Equations. Click Add to add a new equation to the element.
- You access Cost model maintenance, Equation. Complete the following fields:
- Sequence
- Enter a sequence number indicating the order in which the equations are handled during the calculation.
- Description
- Enter a description of the equation.
- Type of cost
- Enter a code indicating when the calculation is to be performed.
- Permitted values:
- Item type
- Enter a code indicating the item type for which the equation should be performed. (Note: Item type is only permitted in combination with Type of cost set to 1 (material reporting) or 4 (product reporting). Permitted values are:
- Oper cost type
- Enter a code indicating the operation type for which the calculation is to be performed. (Note: This field is only permitted when used in combination with Type of cost set to 2 (operation reporting). Permitted values are:
- Calculate once
- Indicate if the equation should be performed once. If you set this field to YES, the equation is performed when the manufacturing order is changed to started.
- Equation
- Enter the formula to be used in the calculation. The formula can contain any or all of the following:
- Active system defined variables. See Variables for a description of all available variables.
- Numeric constants (0-9). A decimal sign (,) may be used.
- Arithmetic operators: +,-,*,/
- References to element lines. You can retrieve calculated totals from previous (lower) element lines by referring to the total type with the element line number. Valid total types are: T (total this level), L (total lower levels) and X (total includes both this level and lower levels). For example, the equation that is used to summarise line 10 to 30 can be entered in the following way:
X010 + X020 + X030 - SEARCH(“User defined table”). This system defined search function searches and returns a value from a user defined table. The table defines the search argument (keys) and the search method to be used. This function is only valid if DC1 Product Configurator is installed and activated, and if the Cost/Contribution field is set to 2 (User-defined) or 3 (User-defined) for the element line.
- You return to the initial Cost model maintenance, Equation panel. On this panel you have several options. You can:
- Select the equation and click Extended criteria to define details indicating if the equation should be calculated during the Product costing, Manufacturing order creation or Reporting of manufacturing order.
- Repeat steps 4-5 to add more equations to the cost model element or exit the routine.
| Code | Description |
|---|---|
| 1 | Material reporting – the calculation for the material cost will be performed when reporting on material. |
| 2 | Operation reporting |
| 3 | Tools |
| 4 | Product reporting |
| 5 | Other cost |
| Code | Description |
|---|---|
| 1 | End item |
| 2 | Sub-assembly |
| 3 | Material |
| 4 | Purchased |
| Code | Description |
|---|---|
| 1 | Internal cost reporting |
| 2 | Sub-contract cost |
Tip: In the equation field you can add together all the element lines, i.e. all costs on this level and the lower levels, within the cost model by adding X next to the element line number.
Click OK.
When the applicable equations have been added, the cost model is ready to be used in cost calculations for items. See About cost calculation in DC1 Manufacturing.