How to Make WIP Report in Garment Production?

In the recent past, I developed one WIP report for one garment factory. The factory is making high fashion dresses for the international market. To make such kind of products factory needs to involve a lot of manpower in hand-repairing process. Inside the repair section, there are multiple sub-processes. Hand-repair, checking of the repaired pieces, alteration of the hand-repaired piece, checking of the altered-hand-repaired pieces.

In such production environment, the factory required process-wise /sub-process wise WIP report data for managing daily production and keeping the cost per garment under control.

Factory keeps a manual record for each piece- who made the hand-repair, at what time the piece was issued to repair-man and when the repair is completed by the repair-man. But from that record, they do not get WIP data at different processes at any moment. 

I need to make one WIP report for them and replace the manual data recording of each piece. While discussing with the manager of the factory, I had experienced and learned new points. I will be sharing it here in this post.

How do you prepare the production in your factory? would you like to share your method of making garment production WIP report? I can understand that you are not making the same kind of products. Still, you might be making WIP report for your product.

The fact is that you can't ignore the WIP report. Whether you want it or not, you need to make it. WIP is the work that you need to finish and WIP is money that lying on the floor. 

Production WIP 

It means the volume of work that is under process in the production processes. If it is sewing line WIP, it means the total number of semi-stitched (unfinished) garments lying in the line. Garment cuttings are loaded but not yet come out from the line. Garment pieces lied inside the line, spread over the workstations of the line.

In an earlier post, calculating WIP level in cutting, sewing and finishing section I have shown WIP calculation formula as:
Cutting WIP = Total cut qty - Total qty sent to sewing,
Sewing Line WIP = Total pieces loaded to the line - total Pieces completed
Finishing room WIP = Total received from sewing - Total pieces packed
Technically above calculation method is correct. But it that method timeline is not defined. Total pieces loaded to the line since when? Is it today or week-to-date or week-to-month loading quantity? If you consider it week-to-date total pieces loading quantity, then at the start of the weel you need to complete al garments and make zero WIP in the line. But that is not possible to clear out the line in every week or in every month.

Then how to measure the WIP in garment production processes? Read the below explanation and formula.

WIP calculation formula 

WIP of a sewing line need to be calculated using the following formula:

Sewing line WIP = (Total garments loaded today + Previous day's balance WIP - Today line output)
You need to record 3 data on the selected date -

  1. production loading quantity, 
  2. production output quantity, 
  3. previous day's WIP quantity (closing balance). 
Same way you can prepare WIP for other sections. Like cutting section WIP, Finishing section WIP.

The production recorders can easily keep previous day's WIP records in their daybook and carry it forward as the opening balance for today. This closing balance carries forward and becomes the opening balance for everyday WIP calculations. 

The physical registers are okay for recording and maintaining day to day data. But not enough for data analysis and information sharing with management. WIP report should be generated automatically and should be available for view at any moment you need it.

WIP Report 

We used the database they have from the real-time production tracking system to get WIP report in Excel Sheet. See the below example of such report.

WIP report
WIP report template

In the above WIP report, cutting section WIP and sewing section WIP are included. The WIP is showing till-date total production quantity which is optional for the WIP report.

If you have above-listed data in a SQL database, you can fetch data from the database and make production WIP report as you desired using the pivot table.

Note:  Excess WIP on the shop floor at any process is not good for many reasons. Here I have explained 7 ways to reduce WIP from the bottleneck operations.



5S,3,Activewear,1,Apparel ERP,4,apparel industry,64,apparel news,38,Apparel Production,38,Apparel Software,33,AQL Chart,1,Attachments,1,Bamboo Fabric,1,Bangladesh,4,Blogs,1,Body Scanner,1,Books,35,Business Guides,14,Buyer,4,Buying House,4,CAD/CAM,2,Calculation & Formula,1,career,38,Change Management,1,China,1,Clothing,3,Clothing Brand,6,Compliance,5,Consumption,4,Costing,21,Cutting,25,Data Analysis,2,Defects,6,Denim,11,Directory,3,Drone,1,Dyeing,2,eCommerce,2,Education,5,End use,1,Event & Fair,19,Fabric,91,Fashion,5,Fashion Business,52,Fashion Design,4,Fashion Show,2,Fiber,6,Finishing,14,Fusing,1,Garment Business,3,Garment Exporters,1,Garment Industry,4,Garmenting,2,Gartex,1,GMT,1,GSM,3,Guest Post,7,Heat sealing,1,Human Resource,8,Incentive system,1,Industrial Engineering,257,Industry 4,1,Infographic,5,Inspiration,1,Institutes,1,Interlining,2,Jeans,4,Knitting,5,KPI,10,Kurti,1,Laser Technology,2,Lean,27,Leggings,2,Line Balancing,3,Line layout,5,Living Wages,1,Machines,46,Manufacturing,57,Merchandising,121,MIS,27,MISC,27,Needle,1,News,5,NIFT,4,Operation bulletin,14,Operator,2,Operator Training,4,Performance rating,1,PLM,7,Printing & Embroidery,13,Problem Solving,2,Production Planning,28,Production System,1,Productivity,2,Project Report,1,QNA,137,Quality,76,Quality Circle,1,Quality manual,2,Quality system,16,Research project,4,Resources,46,Retailing,6,RMG,1,Salary & Wages,7,Sampling,27,Scheduling,6,Seam Sealing,1,Sewing Machine,5,Shirt Making,6,Skiiwear,1,Small-scale business,2,Smart Clothing,1,SMV,1,Sourcing,10,Spec Sheet,10,Sportswear,7,Spreading,2,Stitching,4,Store,2,Stretch fabric,1,Student corner,4,sustainable clothing,10,Sustainable Materials,1,T-shirt,5,Tailor,1,Tailoring Shop,3,Technology,94,Texprocess,1,Textile processing,14,Textile testing,24,Textiles,47,Threads,2,Towel,1,Trims & Accessories,19,videos,11,Washing,3,Waste,1,Wearable Tech,2,Work Study,48,Work wear,1,WRAP,1,Yoga wear,1,
Online Clothing Study: How to Make WIP Report in Garment Production?
How to Make WIP Report in Garment Production?
Make WIP report for garment production to improve production monitoring, cost control. Make WIP report format in Excel sheet.
Online Clothing Study
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share. STEP 2: Click the link you shared to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy