Covering Rule
CoveringRule
Returns quantity of required covering products
Notification level: Not applicable
| Key | Value |
|---|---|
| ID | CoveringRule |
| Translation key | Not applicable |
Behavior
This apply rule calculates the quantities of decorations e.g. paint, wallpapaer and tiles etc., applied on the walls/floors depending on the coverage and tolerencePercentage of the parameters that are present in the product info or in the overloads.
Example to calculate quantity of product, including tolerance:
quantity = (total area of applied covering/ coverage per pack) * (1 + tolerancePercentage/100)
For a tile product applied on a floor, that has coverage of 1.48m² per pack and tolerancePercentage 15% defined in the overloads -
Total floor area = 10m²
Product coverage per pack = 1.48m²
quantity (Packs needed) = 6.76 (total floor area 10m² / product coverage per pack 1.48m²), rounded up to 7 packs
With a tolerance applied of 15% to the calculation (packs needed 6.76 + tolerance applied 15%) = 7.74 packs, rounded up to 8 packs
Total cost = €189,44 (rounded up amount of pack needed 8 * pack price €23,68)
Trigger Conditions
This rule is triggered on BOM computation.
Overload Parameter
The overload is formatted as a JSON object, in which each property is a rule that defines the mapping between the parameters.
For each element in the JSON object, it contains the name of the rule and the name of parameters; these parameters are made of an array of the possible values.
Overload contains mapping of product external IDs to tolerancePercentage.
| Key name | Type | Default value | Description |
|---|---|---|---|
closedTags | array of closed tags | – | Mandatory. defines the list of closed tag IDs of products for which the tolerancePercentage is defined. |
tolerancePercentage | integer | – | Mandatory. defines the additional amount of product required. |
For example:
[
{
"closedTags": [
355,
361
],
"tolerancePercentage": 25
},
{
"closedTags": [
356,
357
],
"tolerancePercentage": 10
}
]
Example
The examples below show calculations of quantities for applied covering material using covering rule.
1. Price defined per pack -
For a tile product applied on a floor, that has coverage of 3m² per pack and tolerancePercentage 15% defined in the overloads.
Total floor area = 16m²
Product coverage per pack = 3m²
quantity (packs needed) = 5.33 (total floor area 16m² / product coverage per pack 3m²), rounded up to 6 packs
With a tolerance applied of 15% to the calculation (packs needed 5.33 + tolerance applied 15%) = 6.13 packs, rounded up to 7 packs
quantity(added under packs in BOM) = 7
Total cost = €165,76 (rounded up amount of pack needed 7 * pack price €23,68)
2. Price defined per Item -
For a paint product applied on a wall, that has coverage of 5m² per can and tolerancePercentage 5% defined in the overloads
Total wall area = 10m²
Product coverage per can = 5m²
quantity (cans needed) = 2 (total wall area 10m² / product coverage per can 5m²), rounded up to 2 cans
With a tolerance applied of 5% to the calculation (cans needed 2 + tolerance applied 5%) = 2.1 cans, rounded up to 3 cans
quantity(added as under quantities in BOM) = 7
Total cost = €90,00 (rounded up amount of cans needed 3 * pack price €30,00)
3. Price defined per squaremeter -
For a tile product applied on a floor, that has coverage of 1.5m² per tile and tolerancePercentage 10% defined in the overloads
Total floor area = 16m²
Product coverage per item = 1.5m²
quantity (tiles needed) = 10.67 (total floor area 16m² / product coverage per tile 1.5m²), rounded up to 11 tiles
With a tolerance applied of 10% to the calculation (tiles needed 10.67 + tolerance applied 10%) = 11.73 packs, rounded up to 12 tiles
Total cost = €180,00 (rounded up amount of tiles needed 12 * tile price €15,00)
4. Price defined per squarefeet -
For a tile product applied on a floor, that has coverage of 2 ft² per tile and tolerancePercentage 15% defined in the overloads
Total wall area = 173 ft²
Product coverage per pack = 2 ft²
quantity (Tiles needed) = 86.5 (total floor area 173 ft² / product coverage per tile 2ft²), rounded up to 87 tiles
With a tolerance applied of 15% to the calculation (tiles needed 86.5 + tolerance applied 15%) = 99.47, rounded up to 100 tiles
Total cost = €800,00 (rounded up amount of pack needed 100 * tile price €8,00)