released

Covering Rule

Apply Rule

CoveringRule

Returns quantity of required covering products

Notification level: Not applicable

KeyValue
IDCoveringRule
Translation keyNot 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 nameTypeDefault valueDescription
closedTagsarray of closed tags–Mandatory.
defines the list of closed tag IDs of products for which the tolerancePercentage is defined.
tolerancePercentageinteger–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 sqaurefeet -
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 = 2ft²
quantity (Packs 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 6.76 * 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€)

 

 

 

← PreviousNext →