Categories
Calculation

How to do 3 Ply Job Calculation using 2 different Methods

Categories
Calculation Excel Sheet

How to Calculate 4 Ply Job using Excel Sheet Video

Step by Step Video Guide to Calculate 4 Ply Job in Flexible Packaging using Excel Sheet.

Download the Excel Sheet and follow the Video.

Categories
Calculation Costing Excel Sheet

Cylinder Size Calculation

Categories
Calculation

Roll OD to kg

Convert Roll OD to kg
Formula = pi x h x (R² – r²) x film density / 1000000
pi = 3.14
h = film / web / roll width
R² = square of Roll OD Radius (R = OD/2)
r² = square of Roll ID Radius (r = ID/2)
film density = BoPP 0.91, Pet 1.4, Foil 2.7

Categories
Calculation Excel Sheet

How to calculate NCO & OH required in kg?

It’s a Very simple and basic Calculation.

NCO : OH
100 : 55

NCO = FINAL QUANTITY X NCO RATIO ÷ ( NCO RATIO + OH RATIO)

100 X 100 ÷ (100+55) = 64.52 kg

OH = QUANTITY X OH RATIO ÷ (NCO RATIO + OH RATIO)

100 X 55 ÷ (100+55) = 35.48 kg

Categories
Calculation Costing Excel Sheet

Raw Material Calculation for Film, Ink & Adhesive

Raw Material Calculation & Costing is one of the main requirements for any Flexible Packaging job. Be it as simple as Mono Layer (BoPP) or 2 ply job of (Bopp + BoPP).

Without doing Raw Material Calculation and Costing one can never get the idea of final Laminate Cost Price for the company.

Same Excel sheet one can use to Calculate various structure of final Laminates.
for eg:.
– BoPP 20 Micron + BoPP 20 Micron
– Polyester Film 12 Micron + LDPE 40 Micron
– Polyester Film 12 Micron + Aluminum Foil 7 Micron + LDPE 40 Micron

List is endless.