Complexe Formula with Explanations
Â
Â
((( ( (([CODE - FINISH SIDE CHOICES] = "B1P - NONE" ? (((([PRODUCT DEPTH] * 2)[PRODUCT HEIGHT])/144) + (([PRODUCT WIDTH] * [PRODUCT DEPTH])/144) + (([PRODUCT WIDTH] * [PRODUCT HEIGHT])/144)) * [SQUARE FEET COST - CABINET MATERIAL SELECTION] SINON ([CODE - FINISH SIDE CHOICES] = "B1P - RIGHT" OU [CODE - FINISH SIDE CHOICES] = "B1P - LEFT" ? ((((([PRODUCT DEPTH] * [PRODUCT HEIGHT])/144) + (([PRODUCT WIDTH] * [PRODUCT DEPTH])/144) + (([PRODUCT WIDTH] * [PRODUCT HEIGHT])/144)) * [SQUARE FEET COST - CABINET MATERIAL SELECTION]) + (([PRODUCT DEPTH] * [PRODUCT HEIGHT])/144) * [SQUARE FEET COST - EXTERIOR MATERIAL]) SINON ([CODE - FINISH SIDE CHOICES] = "B1P - BOTH" ? (([PRODUCT DEPTH] * [PRODUCT HEIGHT])/144) + (([PRODUCT WIDTH] * [PRODUCT DEPTH])/144) * [SQUARE FEET COST - CABINET MATERIAL SELECTION] + (((([PRODUCT DEPTH] * 2)[PRODUCT HEIGHT])/144) * [SQUARE FEET COST - EXTERIOR MATERIAL]) SINON 0 ) ) ) +
((([PRODUCT WIDTH] * [PRODUCT DEPTH]) /144) * [SQUARE FEET COST - CABINET MATERIAL SELECTION] ) +
([CODE - CABINET MATERIAL] = "STANDARD" ? ([CODE - FINISH SIDE CHOICES] = "B1P - RIGHT" OU [CODE - FINISH SIDE CHOICES] = "B1P - LEFT" ? ( ( ([PRODUCT DEPTH] * [PRODUCT HEIGHT]) / 144 ) * ([FIXED COST - CABINET FINISHING GROUP] + [SQUARE FEET COST - CABINET FINISHING GROUP])) SINON ([CODE - FINISH SIDE CHOICES] = "B1P - BOTH" ? ( ( ([PRODUCT DEPTH] * [PRODUCT HEIGHT]) / 144 ) * ( [FIXED COST - CABINET FINISHING GROUP] + [SQUARE FEET COST - CABINET FINISHING GROUP]))*2 SINON 0) ) SINON 0 )
+
( [FIXED PRICE - ROLL OUT QUANTITY] * ( [FIXED COST - DRAWERBOX] + [FIXED COST - DRAWER SLIDES] + [SQUARE FEET PRICE - ROLL OUT QUANTITY] ) ) +
( 5.80 + ([FIXED COST - HINGE] 2 ) ) +
(([FIXED COST - PULL MODEL] + [VALEUR - UPGRADE PULL COST]) * 1) +
(( ([PRODUCT WIDTH] * ([PRODUCT HEIGHT] )) / 144 ) * ( [CODE - DOOR CONSTRUCTION] = "TFLS DOORS" ? [SQUARE FEET COST - DOOR GROUP] SINON ( [CODE - DOOR CONSTRUCTION] = "WOOD DOORS" ? ( [TABLECROSS - WOOD DOORS PRICE] + [SQUARE FEET COST - GLASS TYPE] ) SINON ( [CODE - DOOR CONSTRUCTION] = "1 PIECE MDF DOORS" ? ( [SQUARE FEET COST - DOOR STYLE] + [SQUARE FEET COST - GLASS TYPE] ) SINON ( [CODE - DOOR CONSTRUCTION] = "WOOD SLAB DOORS" ? [SQUARE FEET COST - SLAB DOOR STYLES] SINON ( [CODE - DOOR CONSTRUCTION] = "THERMOFOIL DOORS" ? [TABLECROSS - DIGIGA GROUP PRICE] SINON 0 )))))
+
( [CODE - DOOR CONSTRUCTION] = "WOOD DOORS" ? ( [FIXED COST - LUCVAA DOORS MODEL] * [FIXED PRICE - LUCVAA DOORS MODEL] ) SINON ( [CODE - DOOR CONSTRUCTION] = "1 PIECE MDF DOORS" ? ([FIXED COST - DOOR STYLE] * [FIXED PRICE - DOOR STYLE]) SINON 0))
+
( [CODE - DOOR CONSTRUCTION] <> "TFLS DOORS" AND [CODE - DOOR CONSTRUCTION] <> "THERMOFOIL DOORS" ? ( ( ([PRODUCT WIDTH] * ([PRODUCT HEIGHT] )) / 144 ) * ( [FIXED COST - DOOR FINISHING GROUP] + [SQUARE FEET COST - DOOR FINISHING GROUP] )*2 ) SINON 0 ) ) )
+
(( [FIXED COST - DELIVERY AND INSTALLATION] * [FIXED PRICE - CABINET TYPE] ) + ( [LINEAR COST - DELIVERY AND INSTALLATION] * [FIXED PRICE - CABINET TYPE] ) ) )
*
( 1 + ([FIXED PRICE - CLASSIFICATION] / 100)) )
*
( 1 + ([SQUARE FEET PRICE - CLASSIFICATION] / 100)) )
This part is used to calculate all the material cost that is used to build the cabinet.
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
This part is used to calulate the finishing cost on the cabinet finish sides.
Â
Â
Â
Â
Â
This part is used to add the rollout cost when necessary if the ROLL OUT QUANTITY is not 0
Â
Here we calculate the Hinges cost for the Cabinet
Here we calculate the Pull Model cost + the Upgraded Pull Cost. if the Pull cost is Upgraded the Pull Model cost will return 0 and the Upgraded Pull Cost will have the manual entered value in it.
This part calculate the doors cost for the cabinet. It use the face area of the cabinet multiplied by the SQFT COST of the selected door from the recipe.
Â
Â
Â
Â
Â
Â
Â
In this part we calculate the Mullion options if applied to a glass door.
Â
Â
Â
Here we calculate the finishing cost for the Doors
Â
Â
Â
This part is used to calculate the installation cost per cabinet if installed
Now its the Markup Section:
The FIXED PRICE CLASSIFICATION is used to add a markup for the production cost.
The SQUARE FEET PRICE - CLASSIFICATION is used has a final markup that is your profit.
Â