Basis of Loom Loading Value Finalization
Sales
USD per
Budget Per day USD Per Day m Jul Aug Sep Oct
meter
Internal
SJ $0.4630 $ 74,542 160,944 $ 0.4486 $0.4396 $0.4661 $ 0.4521
SW $0.1390 $ 93,542 673,138 $ 0.1100 $0.1132 $0.1395 $ 0.1304
SK $0.0670 $ 16,621 247,969 $ 0.0666 $0.0699 $0.0719 $ 0.0703
Total $ 0.17 $184,705.00 1,082,051
Loom Loading Per Day Month Vise
200,000 184,212 169,422 35.0%
174,670 184,068 172,970
180,000 168,160 160,884
30.0%
160,000 144,291
135,827 130,476
140,000 25.0%
120,000 20.0%
100,000
80,000 15.0%
60,000 10.0%
40,000
5.0%
20,000
- 0.0%
Jan Feb Mar Apr May Jun Jul Aug Sep Oct
SJ SK SW All + SF Loom All Loom All Target GAP Loading Gap %
Average Gap % Month vise
25.00%
19.46% 19.15%
20.00%
13.84%
15.00%
10.00%
6.83%
5.72% 5.20%
4.79%
5.00%
1.10% 1.82% 1.76%
0.00%
1 2 3 4 5 6 7 8 9 10
Average
Machine Opening – July
Machine Opening – Aug
W1 W2 W3
W1 W2 W3 W3
W1 W2
W1 W2 W3
Outsourced % out of Total Sales
Outsourced %
6,000,000
5,542,618 98%
5,352,981 5,356,415
5,047,991 5,231,039
4,758,767 4,896,302 88%
5,000,000
4,475,151
28% 78%
30% 29%
3,841,409 35% 27%
4,000,000 28%
30% 68%
26%
28% 58%
3,000,000
48%
2,000,000 3,977,301 38%
3,638,231 3,757,400 3,779,274 3,596,429
3,339,473 3,394,784 3,296,354
2,769,438 28%
1,000,000
18%
- 8%
Jan Feb Mar Apr May Jun Jul Aug Sep
Inhouse Value Outsourced Value Total Value Precentage
Highest China Outsourced SJ Qualities
Item Jan Feb Mar APR MAY JUN Jul Aug Sep Grand Total
SJ104039-032.0 223,193 231,886 145,543 86,374 133,142 115,630 66,947 27,280 34,104 1,064,099
SJ105699-044.0 51,292 19,836 223,353 283,027 129,071 174,432 153,205 1,034,216
SJ103880-032.0 275,665 144,896 101,571 53,040 92,642 60,823 74,843 60,687 33,240 897,407
SJ105430-038.0 1,765 23,723 184,614 107,242 107,362 196,133 181,094 9,461 811,393
SJ106182-032.0 67,232 193,116 147,974 53,478 215,107 676,908
SJ104886-035.0 154,273 97,556 390 24,901 94,767 23,401 48,028 6,784 62,786 512,885
Other 766,164 933,657 1,242,798 703,208 877,204 1,052,897 914,144 675,041 791,969 7,957,082
Total 1,419,294 1,409,760 1,565,317 1,071,971 1,595,581 1,836,255 1,577,141 1,178,797 1,299,873 12,953,989
Required Machines
inhouse Vs Outsourced - Jaquard
90
160.0%
80
140.0% 70
39 60
37 38 38
120.0%
28
No of Machines
26 27
24
Precentage
50
18 Req Machine For Outsourced
Utilized Machines
100.0%
40
Total Machines
30
80.0%
40 40 40 40 40 40 40 40 40 20
60.0%
10
40.0% 0
Jan Feb Mar Apr May June July Aug Sep
Revenue Drop - Jaquard
Selling Average
Quality Price Selling Price
SJ103880-032.0 $ 0.48 $ 0.65
SJ104039-032.0 $ 0.54 $ 0.65
SJ104886-035.0 $ 0.30 $ 0.65
SJ105430-038.0 $ 0.24 $ 0.65
SJ105699-044.0 $ 0.75 $ 0.65
SJ106182-032.0 $ 0.51 $ 0.65
Jaquard Loading Vs Outsource
200,000 184,212 184,068 5%
174,670 172,970
180,000 4% 2% 169,422 168,160 4%
3% 4%
160,000
3% 3%
144,291 4%
135,827
140,000 130,476 1%
3% 3%
Loss
3%
120,000
3%
Value if not
USD
100,000
177,141 180,948 outsourced
2%
80,000 169,949 163,722 166,827 163,653
143,431 2%
131,832 126,481
60,000
1%
40,000
20,000 1%
- 0%
Jan Feb Mar Apr May June Jul Aug Sep
SJ105430-038.0 Vs Jaquard Loading
200,000 120%
184,212 184,068
180,000 174,670 172,970
169,422 168,160
100%
160,000
144,291
135,827
140,000 130,476
80%
120,000
USD
100,000 60%
184,212 183,080
174,590 167,863
80,000 160,192 163,280
143,861
40%
60,000 126,912 122,245
40,000
20%
20,000
- 0%
Jan Feb Mar Apr May June Jul Aug Sep
Month
Out Sourced Value Loss Avilable Capacity
Greige Stock Status
250
30.0
28.4 17.5
200 14.0 29.5 25.4 10.6
30.4 32.2 23.5 11.3
26.8 25.6 11.2
26.7 10.6 24.5 7.2 9.4
8.3 19.1 30.6 10.4
18.0 31.9
150 79.5 19.0 13.3
97.8
Stock MT
56.6 18.3 98.0
83.5 83.4 57.1 90.8 91.2
75.1 79.5
72.3 66.1
100 51.9
110.7 116.1
50 103.9 93.3
92.0 87.6 84.7 87.5 86.3 86.2 86.8
73.7 79.3 79.5
0
29th Jun 7th Jul 14th Jul 21st Jul 38th Jul 6th Aug 13th Aug 20th Aug 27th Aug 03rd Sept 13th Sep 22nd Sep 29th Sep 8th Oct
Greige Produced for Color Orders (MT) Produced for Overdue Bookings (MT) Produced for Future Bookings (MT) Greige Produced Without Orders (MT)
Highest provision : 10 Qualities
Provision for
Total Provision for Provision for Provision for
Quality future End Customer Sales Comment
Provision color orders Overdue bookings without order
bookings
SW101426-017.0#0 46,093 10,455 36,335 - - VS Rapid Rolling Commitment
SJ104886-035.0#2 45,038 44,760 - - 278 PVH NIKE
SW051849-007.5#0 33,868 17,798 16,095 - - VSS Rapid Rolling Commitment
SJ104893-030.0#1 22,995 4,202 - 11,151 7,642 PUMA Cutomer Liable / Awaiting Update
SK104715-060.0#0 21,482 - 2,388 19,081 13 NIKE
SW102428-010.0#0 20,321 20,389 - - - GAP
SJ101818-022.0#0 19,298 16,387 3 2,949 - LBI Rolling Commitment
SW090104-025.0#0 18,270 - 18,185 - 84 VSS Rapid Rolling Commitment
SJ104073-030.0#6 13,668 4,424 - 7,268 1,976 PUMA Customer Liable/Awaiting Update
SW100028-012.0#0 11,050 9,422 1,628 - 0 LBI
Total 436,961 195,420 147,838 53,739 39,964
Highest Stock : 10 Qualities
Greige Produced for Greige produced for Greige Qty poduced Greige produced End
Quality Sub Total kg Sales Comment Days : PO date
Color Orders(kg) overdue bookings (kg) for future bookings (kg) without order (kg) Customer
SJ105430-038.0#0 43,422 261 43,161 - - VSS 60days:18/Oct/21 ,32days:18/Oct/21
SJ104886-035.0#2 12,611 12,611 - - - PVH NIKE
SW050580-007.0#0 9,688 104 9,584 - - VS PINK Rapid Rolling Commitment 74days:16/Oct/21 ,44days:16/Oct/21
SJ103880-032.0#0 5,172 13 5,159 - - VSS Rapid Rolling Commitment 250days:30/Nov/21 ,194days:02/Nov/21
SJ106436-040.0#0 4,642 822 3,489 - 331 SUPER DRY 36days:29/Oct/21 ,50days:29/Oct/21
SW101426-017.0#0 4,357 683 3,674 - - VS Rapid Rolling Commitment 120days:29/Oct/21 ,43days:29/Oct/21
SW051849-007.5#0 4,137 2,076 2,060 - - VSS Rapid Rolling Commitment
SW090104-025.0#0 3,864 - 3,864 - - VSS Rapid Rolling Commitment
SK104715-060.0#0 3,213 - 353 2,860 - NIKE 22days:26/Nov/21 ,28days:25/Nov/21
SJ106371-040.0#1 2,935 318 2,617 - - SUPER DRY 57days:29/Oct/21 ,71days:29/Oct/21
CALVIN
SJ053683-038.0#43 2,853 1,235 - - 1,618 KLEIN
Customer Liable / Awaiting
SJ104893-030.0#1 2,731 499 - 1,324 908 PUMA Update 0days:22/Oct/21
Total 86,789 98,055 11,206 10,649
Without Order top 10 Qualities
Greige produced without Over 90 Greige produced Over 120 Greige produced without
Quality End Customer
order (kg) without order (kg) order (kg)
SJ053683-038.0#43 1,618 0 - CALVIN KLEIN
SJ104893-030.0#1 908 908 908 PUMA
SJ053684-038.0#43 446 0 - CALVIN KLEIN
SJ106436-040.0#0 331 - - SUPER DRY
SW052292-030.0#0 311 - - GAP
SK100287-045.0#0 306 - - Nike
SJ104073-030.0#6 271 271 271 PUMA
SW034003-016.0#0 206 206 206 LBI
SW054711-050.0#1 136 101 - Nike
SJ106352-050.0#6 130 - - NIKE
Total 10,649 4,659 2,985
Overdue Bookings Top 10
Greige produced for overdue Over 90 Greige produced for Over 120 Greige produced
Quality End Customer Sales Comment Days : PO date
bookings (kg) overdue bookings (kg) for overdue bookings (kg)
SJ105430-038.0#0 43,161 - - VSS 60days:18/Oct/21 ,32days:18/Oct/21
SW050580-007.0#0 9,584 - - VS PINK Rapid Rolling Commitment 74days:16/Oct/21 ,44days:16/Oct/21
SJ103880-032.0#0 5,159 35 19 VSS Rapid Rolling Commitment 250days:30/Nov/21 ,194days:02/Nov/21
SW090104-025.0#0 3,864 3,482 323 VSS Rapid Rolling Commitment
SW101426-017.0#0 3,674 2,373 2,373 VS Rapid Rolling Commitment 120days:29/Oct/21 ,43days:29/Oct/21
SJ106436-040.0#0 3,489 - - SUPER DRY 36days:29/Oct/21 ,50days:29/Oct/21
SJ106371-040.0#1 2,617 - - SUPER DRY 57days:29/Oct/21 ,71days:29/Oct/21
SJ104039-032.0#0 2,544 - - VSS Rapid Rolling Commitment
SW051849-007.5#0 2,060 2,060 - VSS Rapid Rolling Commitment
SJ101980-032.0#2 1,265 - - VSS 28days:28/Oct/21 ,56days:28/Oct/21
Total 98,055 17,607 8,225