The input and output quantities of the BOM can be entered as a fixed value, or calculated using a formula. Formula definition can be made for all line types of the BOM. In material class (general) and material class (with table) type output lines, the quantities of the child materials within the material class are specified on the quantity formula field located in the detail lines.
The quantity formula field of the output lines is used to specify the quantity of material to be produced, while the quantity formula field of the input lines is used to specify the necessary quantity of material for the production.
If the material to be produced or used in production has a fixed quantity, the value is directly entered into the quantity formula field. If the quantity will be calculated by applying a formula, the formula is defined using standard and user defined fields along with functions. Material quantities are automatically calculated by the LOGO application according to the formula.
The quantity formula is defined using parameters along with arithmetical and logical operators. The formula to be used in quantity calculations is recorded on the window accessed by clicking on "..." icon on the quantity formula field, or by pressing the F10 button. In addition to existing system parameters, specific constants defined by the company can also be used for formula generation.
The quantity calculated using the information entered in the formula window is transferred into the quantity column of the bill of materials line, and cannot be changed. When incorrect parameters are used in formula definition, the bill of materials line is displayed in red.
When a new line is added to the BOM, the P1 value is displayed as default in the formula. This does not apply to lines with Material Class type. A warning message is displayed if parametric expressions such as P1, P2 ...Pn are used in the quantity formula field of the Co Product lines.
The formula window consists of two panes. The upper pane contains the field where the formula will be entered, and the lower pane contains the following fields to be used in the formula:
- Standard Fields
- User Defined Fields
- Functions
The Standard Fields contain the parameters related to the material. These parameters are divided in two groups as parameters related to the product, and the parameters related to the selected material.
The material to be used to calculate the parameters related to the selected material is specified in the Material Code to Be Used in Formula field of the related BOM line. Each parameter is defined as Main Unit and Unit Used. The Standard Fields are:
P1 | Quantity (Product, Main Unit) |
P2 | Width (Product, Main Unit) |
P3 | Length (Product, Main Unit) |
P4 | Height (Product, Main Unit) |
P5 | Area (Product, Main Unit) |
P6 | Volume (Product, Main Unit) |
P7 | Weight (Product, Main Unit) |
P8 | Gross Volume (Product, Main Unit) |
P9 | Gross Weight (Product, Main Unit) |
P11 | Quantity (Product, Line Unit) |
P12 | Width (Product, Line Unit) |
P13 | Length (Product, Line Unit) |
P14 | Height (Product, Line Unit) |
P15 | Area (Product, Line Unit) |
P16 | Volume (Product, Line Unit) |
P17 | Weight (Product, Line Unit) |
P18 | Gross Volume (Product, Line Unit) |
P19 | Gross Weight (Product, Line Unit) |
P21 | Quantity (Material in Formula, Main Unit) |
P22 | Width (Material in Formula, Main Unit) |
P23 | Length (Material in Formula, Main Unit) |
P24 | Height (Material in Formula, Main Unit) |
P25 | Area (Material in Formula, Main Unit) |
P26 | Volume (Material in Formula, Main Unit) |
P27 | Weight (Material in Formula, Main Unit) |
P28 | Gross Volume (Material in Formula, Main Unit) |
P29 | Gross Weight (Material in Formula, Main Unit) |
P31 | Quantity (Material in Formula, Line Unit) |
P32 | Width (Material in Formula, Line Unit) |
P33 | Length (Material in Formula, Line Unit) |
P34 | Height (Material in Formula, Line Unit) |
P35 | Area (Material in Formula, Line Unit) |
P36 | Volume (Material in Formula, Line Unit) |
P37 | Weight (Material in Formula, Line Unit) |
P38 | Gross Volume (Material in Formula, Line Unit) |
P39 | Gross Weight (Material in Formula, Line Unit) |
P51 | Total (Quantity*Width) (Material in Formula, Line Unit) |
P52 | Total (Quantity*Length) (Material in Formula, Line Unit) |
P53 | Total (Quantity*Height) (Material in Formula, Line Unit) |
P54 | Total (Quantity*Area) (Material in Formula, Line Unit) |
P55 | Total (Quantity*Volume) (Material in Formula, Line Unit) |
P56 | Total (Quantity*Weight) (Material in Formula, Line Unit) |
P61 | Quantity (Configurable Main Products, Main Unit) |
P62 | Width (Configurable Main Products, Main Unit) |
P63 | Length (Configurable Main Products, Main Unit) |
P64 | Height (Configurable Main Products, Main Unit) |
P65 | Area (Configurable Main Products, Main Unit) |
P66 | Volume (Configurable Main Products, Main Unit) |
P67 | Weight (Configurable Main Products, Main Unit) |
P68 | Gross Volume (Configurable Main Products, Main Unit) |
P69 | Gross Weight (Configurable Main Products, Main Unit) |
P71 | Quantity (Configurable Main Products, Line Unit) |
P72 | Width (Configurable Main Products, Line Unit) |
P73 | Length (Configurable Main Products, Line Unit) |
P74 | Height (Configurable Main Products, Line Unit) |
P75 | Area (Configurable Main Products, Line Unit) |
P76 | Volume (Configurable Main Products, Line Unit) |
P77 | Weight (Configurable Main Products, Line Unit) |
P78 | Gross Volume (Configurable Main Products, Line Unit) |
P79 | Gross Weight (Configurable Main Products, Line Unit) |
User Defined Fields can be used along with the standard fields defined in the LOGO application for formulas generated when the input and output line quantities are calculated. User defined fields are recorded using the BOM Constants menu option located in the right mouse button menu of the bill of materials window.
Defined BOM constants are located in the User Defined Fields section of the Formula window.
The Functions section contains the arithmetical and logical operators available for the formula. The functions are:
MIN(,) | (Takes the minimal parameter/constant into the parenthesis.) |
MAX(,) | (Takes the biggest parameter/constant into the parenthesis.) |
MOD(,) | (Divides the higher valued parameter/constant into the lower valued one and takes the remainder.) |
DIV(,) | (Divides the first parameter/constant to the second.) |
ABS() | (Takes the absolute value of the parameter/constant.) |
VAL() | (Converts the character array within the parenthesis into a numeric value.) |
ROUND() | (Rounds the parameter/constant upwards if its decimal point is bigger than 0,5 and downwards if not.) |
TRUNC() | (Eliminates the decimal characters if the parameter/constant within parenthesis is decimal.) |
FLOOR() | (Rounds the decimal parameter/constant downwards.) |
CEIL () | (Rounds the decimal parameter/constant upwards.) |
FRAC() | (Takes the decimal value of the parameter/constant.) |
IF(,,) | (Specifies values by defining conditions. "If (p1>1000, 10,5)" definition uses 10 if p1 is bigger than 1000, or 5 if otherwise.) |