Learn Industrial Engineering the practical way
Free articles, Excel templates and calculators on IE, Excel and the garments industry - written from real factory experience.
Store & InventoryReceiving and inspecting fabric and trims: 4-point system and trim checks
How to receive and inspect fabric rolls with the 4-point system, calculate points per 100 square yards, check trims against the trim card, and handle rejects.
Excel date, time and text formulas for planners
TODAY, NOW, DAY, MONTH, YEAR, WEEKDAY, date differences, TEXT for time formats, CEILING for rounding to cartons or bundles, and LEN, SUBSTITUTE, FIND, LEFT and RIGHT for cleaning text.
Store & InventoryStore and warehouse in a garment factory: what it does and why it matters
Fabric store, trims (accessories) store, finished goods warehouse and machine-parts store - the material flow, the documents at each step, and the store KPIs.
Excel logic and summaries: IF, SUMIF, COUNTIF, FREQUENCY and Pivot tables
Decide with IF, add and count with conditions using SUMIF and COUNTIF, group values with FREQUENCY, summarise thousands of rows with a Pivot table - and combine IF, CONCATENATE and SUMIF for a running balance.
MerchandisingT&A calendar and critical path: planning an order backwards from ship date
How to build a Time and Action calendar from the ex-factory date, find the critical path, and use the T&A every day to warn early and recover delays.
Excel lookup formulas: VLOOKUP, HLOOKUP, INDEX, MATCH and CHOOSE
Find any value in a table: when to use VLOOKUP or HLOOKUP, why INDEX + MATCH is more flexible, and how CHOOSE switches between ranges - with simple examples you can copy.
MerchandisingGarment sample stages: proto, fit, size set, PP, TOP and shipment samples
Why each sample is made, what material it uses, who approves it, and how to manage sample comments so bulk production starts right.
Built-in quality, TQM and the cost of quality
Why quality must be built at every step instead of inspected at the end, the 7 principles of Total Quality Management, and the four costs of quality every factory pays.
MerchandisingFabric consumption calculation for knit and woven garments
The body-measurement formula for knit T-shirts in kg per dozen, the marker method for wovens in yards, wastage allowances and a booking checklist.
Calculators for everyday IE work
Target, efficiency, line balancing, man machine ratio, machine requirement and time study.
Templates & guides
Excel, PDF and Word files, ready to use. Files marked 🔒 are for members.
Get one practical IE tip every week
Join IE and production professionals learning with in2eff.