Budgeted cost calculation

• Storage site (field STOFCY)

Use this field to define the storage site (warehouse).

The site defined on the user record is displayed by default but can be amended.

A storage site has the check box Stock (Details tab) selected.

• field TOUS

Use this radio button to select records to be updated.

• Unique. To update one specific record.
• All. To update all records.
• Selection. To select records using a calculation formula or filters.
  
  

• Product (field ITMREF)

Use this field to specify the product code to be updated.

• Formula (field FILART)

Enter, select or build an Sage X3 filter calculation expression using the formula editor.

 An error message is displayed if you refer to tables which are not generally used by the configurator, or to unknown variables.

 This field is only available if the Selection radio button is selected.

• Major version (field ECCVALMAJ)

Use this field to indicate which major version of this product applies. Major versions might be used where there have been increased or significant changes to the original or previous version, that is the 'form, fit or function' has changed.

Type in, or select a version code from the list of version codes displayed. This field is not available for entry if the product code defined in the Product field is not version managed.

• Minor version (field ECCVALMIN)

Use this field to indicate which minor version of this product applies. Minor versions might be used where there have been minor features or changes in functionality, or significant fixes applied to a specific major version.

Type in, or select a version code from the list of version codes displayed. This field is not available for entry if the product code defined in the Product field is not version managed.

• Calculation quantity (field CLCQTY)

Use this field to define the quantity to be included in the calculations. This field is only available if a product code has been defined. The default quantity is the Economic order quantity (field EOQ (REOMINQTY)) defined on the product-site record or the Technical lot (field MFGLOTQTY) defined on the product-site record, or 1.

• field STU2

This field displays the unit in which the product is stored. It provides the key to prices, costs, volumes etc.

• Fiscal year (field FIYNUM)

Enter the number of the required fiscal year. A blocking message is displayed if a fiscal year not closed has been entered.

• Start (field ITCSTRDAT)

The Fiscal year Start and Fiscal year End fields automatically indicate the start and end dates of the fiscal year. You cannot modify these dates.

• Date calculated (field ITCDAT)

Cost calculation date. The default calculation date is today's date but can be changed. The defined date is written to the applicable Products-costs record.

 Only those components in a bill of materials (BOM) valid on this date are included in the calculations.

 This date must fall between the start and end dates of the defined Fiscal year (fields Start (field ITCSTRDAT) and End (field ITCENDDAT)).

• BOM type (field BOMALTTYP)

Select Manufacturing if you manufacture this bill of materials (BOM); if it is procured from a subcontractor, select Subcontracting.

• Routing code (field 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 (for use in a manufacturing environment, for costing or for capacity planning). Use this field to define the route for the calculation of the components, machines, resources, workforce and subcontractors.

From this routing code, the program searches for the first valid alternative bill of materials (BOM) for the defined site. If you leave this field blank, only a material calculation can be made (valuation and calculation of material overheads).

• BOM code (field BOMALT)

Multiple bills of materials (BOMs) can be defined for a single product. Each BOM code can be assigned specific management features. For manufactured or subcontracted products this includes restriction of the BOM to a specific site and to specific areas of functionality (for costing or for capacity planning).

• Calculate all BOM levels (field DESCEND)

The Calculate all BOM levels check box is only active for a single product calculation.

• If this check box is selected, the cost calculation process descends through the bill of materials (BOM) to the lowest level, or up to a parent product whose 'Standard cost update' in their product-site record is entered. The cost calculation thus starts from the lower components. The standard cost of each component at each level will be calculated and stored, and the report will then be detailed.
   
• If this check box is clear (not selected), the calculation is performed at the first level, from the standard costs of the components of the calculated products. This also applies if the calculation is launched for multiple products.

 By definition, a material does not have to be a component. The Material cost selection field is used to determine how its cost is calculated when defined as 'Calculated' and not 'Entered'.

• Fixed costs distribution (field FXDCSTDSP)

Use this field to define how the fixed overhead costs (material loss, setup rate, operation loss rate, fixed rate) are to be distributed.

• Prorata. The fixed costs will be multiplied by the Calculated product quantity/Economic lot quantity combination.
• Total. The total fixed cost will be posted.
  
  

• Material cost (field SLTMATCST)

Use this field to define the type of cost to be used to value materials. 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, if required. The possible values are:

• 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 of the type priority supplier/product.

 The selection of the cost type only applies to the cost calculation of a material (component without a valid 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 is set to 'Yes'.

• Dimension rate (field VLTCCERAT)

Use this field to define the dimension rate to be 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, if required.

• Overhead column (field SLTOVECOL)

Use this field to define 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, if required.

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

• field FIL6

• Update (field MAJ)

Use this field to control any postings to the products-costs records.

• No. The products-costs records are not updated.
• Deferred. The update can be deferred and posted using the Calculated cost update function.
• Immediate. The products-costs records are updated immediately upon completion of the calculation run.
  
  

• Replace previous cost (field RPLPRVCST)

When a standard cost is updated immediately, a new sequence is created. Click this check box to replace the cost created previously with the same validity period (start and end date).