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
Cylinder Size Calculation
Categories
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
3 Ply Job Calculation (Cylinder)
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
Roll kg to Meter Square (m²)
In any Flexible Packaging job, we have to convert Running Meter or Linear Meter to Square Meter (m²). In this video you can learn and use Excel Sheet to Convert Linear Meter of Film (BoPP, Pet, LDPE etc.) to Square Meter. First we convert roll kg to meter using subjected Roll Width or Coil Size.
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.
Flexible Packaging being the fast moving Industry, require skilled manpower every single day.
While doing the production of Mono Layer job likes BoPP slitting, we have to make the Packing List either manually or using computer. Even if you are doing Manual entry of the Packing List you need to enter the data in Excel Sheet. Here you can download Excel Sheet for entering the date.
Same sheet can be used for Laminate job as well.
- BoPP + BoPP
- Pet + LDPE
- Pet + Foil + LDPE