Optional Special User Functions: Product Costing Calculator

Part number

Parts Master. Part number unique identifier. {PTMFILE.PTMPTNO char 18 Idx}

Stock Unit of Measure

Parts Master. Standard stock unit of measure. {PTMFILE.PTMSTUM char 6}

Description

Parts Master. Part description. {PTMFILE.PTMDESC char 30}

Standard sales UoM

Parts Master. Sales unit of measure. {PTMFILE.PTMSAUM char 6}

Standard sales UoM multiplier

Parts Master. Sales order Unit of Measure Multiplier. {PTMFILE.PTMMULTI number 4dp}

Currency code

Currency Rates. Currency symbol code. {CURFILE.CURCODE char 3 Idx}

Currency

Currency Rates. Currency name. {CURFILE.CURNAME char 20}

Exchange rate

Currency Rates. Exchange rate (default currency = this currency * rate). {CURFILE.CUREXCH number float}

Alternative sales UoM

Enter an alternative sales unit of measure.

Alternative sales UoM multiplier

Enter a multiplier for the alternative sales unit of measure.

Standard sales price for the alternative sales UoM

The standard sales price calculated for the alternative sales unit of measure and in the currency.

Control: Cost on last

Check this option for the values (Cost/Sales UoM) to be based on Last part cost rather than New cost. This switches the Cost/Sales UoM from New to Last cost.

Control: Blow through multi-level

Check this option to blow down to purchased materials multi-level. It therefore ignores all sub-assembly production costs (labour, overheads, etc.).

Control: Apply purchase part quantity costs

Check this option to apply quantity cost breaks when available, otherwise last cost. If there is no purchase part row for the Preferred Supplier of the part, the part current costs are used. If there are multiple purchase part rows the record with the best performance ratings will be used. If those are equal the lowest last cost will be used.

Control: For quantity

A quantity of production that will be factored into the quantity pricing calculation. This is only used if the Apply purchase part quantity cost option is checked.

List of components

List of components used in the assembly listed above.

New cost of selected

Enter an alternative new cost for the currently selected line.

New quantity of selected

Enter an alternative quantity required for the currently selected line.

Total of components

The calculated total cost per sales UoM in currency of the components.

Additional items list

List of Additional Items used.

Code

Additional item code. Must be predefined as a Standard Sales Text.

The code should be related to a Standrad Sales Text, the text of which should be formatted in a particular way, for example “Blending fee per 25 Ltr*46.768*1”. The standard text has three elements separated by the * character, so in the example here has a cost of 16.768 and the default quantity is 1.000.

Description

Description of the additional item (from standard sales text of that code).

Cost

Enter a cost for the currently selected line additional item.

Quantity

Enter a quantity required for the currently selected line additional item.

Total

The calculated total cost per sales UoM in currency of the additional items.

Total cost/Sales UoM

The calculated total cost per sales UoM in currency for everything.

Add O’h

Adds a item to the list with part number OVERHEAD in a quantity of total BoM quantity of parts with index code 1 = RI. The cost by default is 0.1875 in local currency.

Add Additional

Adds a line to the additional items list.

Remove Additional

Removes the selected line from the additional items list.

Print

To print the results. Right-click for destination choice.