Fabric Reconciliation by Excel Inventory Tracker Systems
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. | Buyer | Order Qty | Fabric received | CAD ratio | Fabric Issued (CAD) | Fabric issued (ACT) | Fabric Issue for Sample | Fabric Leftover As per CAD | Fabric Leftover Actual | Dlv. For Excess & Wastage In % | Left Over In % | CAD Ratio Variance In % | Left Over % | Sample % | Total Left Over % |
| 8LS066 | RADHAMONI | 4,664 | 8,939 | 22.45 | 8,726 | 8,902 | 37 | – | – | 2% | 0.00% | 1.98% | 0.00% | 0.41% | 0.00% |
| 7284 | S.OLIVER | 357 | 832 | 26.66 | 793 | 832 | – | – | – | 5% | 0.00% | 4.67% | 0.00% | 0.00% | 0.00% |
| 4643 | S.OLIVER | 10,402 | 17,983 | 19.60 | 16,990 | 17,786 | 136 | 61 | 61 | 5% | 0.34% | 4.48% | 0.34% | 0.76% | 3.39% |
| C20CS331 | CONNOR | 12,603 | 23,471 | 21.11 | 22,171 | 22,901 | 56 | 514 | 526 | 3% | 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 | 13 | 3% | 0.36% | 3.78% | 0.59% | 0.23% | 0.45% |
| 8FS044 | RADHAMONI | 7,644 | 12,621 | 19.11 | 12,173 | 12,621 | – | – | – | 4% | 0.00% | 3.55% | 0.00% | 0.00% | 0.00% |
| 8CU026 | RADHAMONI | 4,664 | 8,115 | 20.61 | 8,011 | 8,012 | 26 | 77 | 77 | 0% | 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,269 | 4% | 24.00% | 0.45% | 24.79% | 0.78% | 68.61% |
| Total | 62,654 | 83,194 | 161 | 78,367 | 80,856 | 547 | 1,791 | 1,946 | 3.18% | 2.15% | 3.08% | 2.34% | 0.66% | 100.00% |
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.