Fabric Reconciliation by Excel Inventory Tracker Systems

Fabric Left Over

Fabric reconciliation by excel inventory tracker systems is common tools in RMG sectors. When any organization reduce cost and increase profit by controlling fabric wastage. So, they have to introduce fabric reconciliation by excel inventory tracker system.

Most of organization fall in difficulties by reducing fabric wastage. Here CAD consumption is most important tools to minimize fabric wastage. The below table is appropriate example to “Fabric reconciliation by excel inventory tracker systems”.

Store Department
Job/Style/Order No.BuyerOrder QtyFabric receivedCAD ratioFabric Issued (CAD)Fabric issued (ACT)Fabric Issue for SampleFabric Leftover As per CADFabric Leftover ActualDlv. For Excess & Wastage In %Left Over In %CAD Ratio Variance In %Left Over %Sample %Total Left Over %
8LS066RADHAMONI         4,664               8,939           22.45               8,726               8,902               37           –                    –  2%0.00%1.98%0.00%0.41%0.00%
7284S.OLIVER           357                  832           26.66                 793                 832                –             –                    –  5%0.00%4.67%0.00%0.00%0.00%
4643S.OLIVER       10,402             17,983           19.60             16,990             17,786              136           61                  615%0.34%4.48%0.34%0.76%3.39%
C20CS331CONNOR       12,603             23,471           21.11             22,171             22,901               56         514                5263%2.19%3.19%2.24%0.24%28.70%
FRAME SHIRT (183532-8617)H&M         1,425               2,195           17.68               2,100               2,182                 5             8                  133%0.36%3.78%0.59%0.23%0.45%
8FS044RADHAMONI         7,644             12,621           19.11             12,173             12,621                –             –                    –  4%0.00%3.55%0.00%0.00%0.00%
8CU026RADHAMONI         4,664               8,115           20.61               8,011               8,012               26           77                  770%0.95%0.01%0.95%0.32%4.30%
MENS JACKET(SUB-CONTRACT)SOFT SHELL         3,920               3,918           10.93               3,570               3,769              247          (98)                  –  3%-2.49%5.27%0.00%6.29%-5.44%
MOCK SHIRT(245898/247218)(SUB-CONTRACT)NEXT       16,975               5,120            2.71               3,834               3,851               40      1,229             1,2694%24.00%0.45%24.79%0.78%68.61%
Total        62,654             83,194             161             78,367             80,856              547      1,791             1,9463.18%2.15%3.08%2.34%0.66%100.00%
Fabric Reconciliation Table
Fabric Left Over & Wastage Reduce

Zero Waste communities push for ever-higher resource recovery rates through a strong emphasis on source-separated recycling and composting, waste reduction and reuse programs.

One comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.