Home / Formulas / Trade & Commercial Formulas
49 Formulas

Trade & Commercial Formulas

Volume, pricing, yield and import-cost equations.

Freight Weight Checker

Freight Weight Checker
Actual weight = Volume (m3) x Density (kg/m3)
Freight Weight Checker
Volumetric weight = Volume (m3) x Dimensional factor
Freight Weight Checker
Chargeable weight = max(Actual, Volumetric)
Typical dim factors
Air ~167, Road ~333, Sea ~1000 kg/m3
Freight Weight Checker
(Air uses 1m3 = 167kg; i.e. 6000 cm3 per kg)

Sealer Cost Calculator

Sealer Cost Calculator
Total area = Surface area x Number of coats
Sealer Cost Calculator
Litres needed = (Total area / Coverage rate) x (1 + loss%)
Sealer Cost Calculator
Packs = ceil(Litres needed / Pack size)
Sealer Cost Calculator
Total cost = Packs x Price per pack
Sealer Cost Calculator
Cost per m2 = Total cost / Surface area

Import Cost Calculator

Import Cost Calculator
CIF = (FOB x qty) + Freight + Insurance
Import Cost Calculator
Basic Customs Duty (BCD) = Duty% x CIF
Import Cost Calculator
Social Welfare Surcharge = 10% x BCD
Import Cost Calculator
IGST = IGST% x (CIF + BCD + SWS)
Import Cost Calculator
Landed = CIF + BCD + SWS + IGST + Clearing

Janka Database Tool

Janka test
force to embed steel ball to half diameter
US/India unit
pounds-force (lbf)
EU/Metric unit (EN 1534)
Newtons (N)
Conversion
1 lbf = 4.44822 N
Janka Database Tool
Hardness ratio = Janka A / Janka B

Container Optimizer

20ft GP
5898 x 2352 x 2393 mm, ~28.2 t payload, 33.2 m3
40ft HC
12032 x 2352 x 2698 mm, ~26.5 t payload, 76.4 m3
Container Optimizer
Fit by volume = floor fits x fill factor (best of 6 rotations)
Container Optimizer
Fit by weight = floor(Payload / Package weight)
Container Optimizer
Actual = minimum of volume-fit and weight-fit

Pricing Converter

Pricing Converter
Price per m3 = Price per unit / Volume_factor of that unit
Pricing Converter
Target price = Price per m3 x Volume_factor of target unit
Pricing Converter
Total value = Quantity (in m3) x Price per m3
Pricing Converter
1 m3 = 35.3147 CFT, so price/m3 = price/CFT x 35.3147

NHLA Calculator

NHLA Calculator
Surface Measure (SM) = (Length_ft x Width_in) / 12, rounded
NHLA Calculator
Clear yield % = (Clear cutting area / Total face area) x 100
FAS
minimum 83.3% clear (10/12)
No. 1 Common
minimum 66.7% (8/12)
No. 2A Common
50% (6/12) | No. 3A: 33.3% (4/12)

Yield Estimator

Yield Estimator
Output volume = Input volume x Recovery rate
Yield Estimator
Waste volume = Input volume - Output volume
Yield Estimator
Waste % = (1 - Recovery rate) x 100
Yield Estimator
Effective output cost = Input cost / Recovery rate
Typical
log to green sawn ~65%, log to finished ~42%

Volume Converter

Volume Converter
1 Cubic Foot (CFT) = 0.0283168 m3
Volume Converter
1 Board Foot (BF) = 144 cubic inches = 0.00235974 m3
Volume Converter
1 Hoppus Foot = 1.273 cubic feet = 0.0279797 m3
Volume Converter
Conversion = (Amount x From_factor) / To_factor
Volume Converter
1 m3 = 35.3147 CFT = 423.78 Board Feet

Waste Margin Calculator

Waste Margin Calculator
Retention = (1-defect%) x (1-process%) x (1-cutting%)
Waste Margin Calculator
Gross before safety = Final qty / Retention
Waste Margin Calculator
To order = Gross x (1 + safety%)
Waste Margin Calculator
Total waste = To order - Final qty
Note
losses multiply - 10%+10%+10% leaves 72.9%, not 70%