Demand Planning

Stock snapshot vs requirement — recomputed from Report-1 tabs
PTMT Capacity →
CPVC Pipe & Fittings (75) UPVC Pipe & Fittings (60) Agri Pipe & Fittings (29) SWR Pipe & Fittings (35)
Items
199
Need attention
193
cover < 7 days
Net requirement
1,563,957
pcs (gap to ideal)
Snapshot date
Aug, 31
CPVC Pipe & Fittings 65 items · CPVC FITTINGS
Item Produced Required Closing Stock Ideal Qty Net Req Days Cover
3/4 CPVC 90 DEG, ELBOW (NEW)
C52
156,512 0 40,267 +156,512 0.0d
1/2 Threaded End Plug
PP1
137,248 0 36,000 +137,248 0.0d
3/4 X 1/2" CPVC BRASS FPT 90 DEG ELBOW
C521
59,346 0 18,666 +59,346 0.0d
1 CPVC COUPLING
C43
39,834 0 13,485 +39,834 0.0d
3/4 CPVC TEE
C62
39,512 0 9,924 +39,512 0.0d
1 CPVC 90 DEG, ELBOW (NEW)
C53
37,192 0 30,464 +37,192 0.0d
1 CPVC. TEE
C63
31,072 0 11,100 +31,072 0.0d
3/4 CPVC COUPLING
C42
17,156 0 9,921 +17,156 0.0d
3/4 X 1/2 CPVC RED.BRASS FPT TEE
C322
14,090 0 5,965 +14,090 0.0d
3/4 X 1/2CPVC MALE ADAPTER BRASS TH
C71
13,149 0 4,061 +13,149 0.0d
3/4 CPVC CAP
C602
13,017 0 3,326 +13,017 0.0d
3/4 X 1/2 CPVC RED.COUPLING BRASS TH
C920
12,449 0 5,186 +12,449 0.0d
1 X 1/2 CPVC RED. BRASS FPT TEE
C323
11,275 0 6,100 +11,275 0.0d
1" X 1/2" BRASS 90" ELBOW
C523
9,896 0 5,895 +9,896 0.0d
1 CPVC UNION
C33
9,238 0 2,281 +9,238 0.0d
1-1/4 CPVC 90 DEG, ELBOW (NEW)
C54
8,503 0 2,577 +8,503 0.0d
1" TANK NIPPLE (NEW)
C273N
8,019 0 3,233 +8,019 0.0d
1 CPVC CAP
C603
7,897 0 4,924 +7,897 0.0d
1 CPVC 45 DEG, ELBOW SOC (NEW)
C503
6,653 0 6,954 +6,954 0.0d
1X 3/4 CPVC RED. TEE
C232
6,734 0 3,026 +6,734 0.0d
1 X 3/4 CPVC RED. BUSHING
C832
6,403 0 4,021 +6,403 0.0d
3/4 CPVC STEP OVER BEND
C12
6,203 0 3,058 +6,203 0.0d
1 CPVC FEMALE ADAPTER PLASTIC THREAD
C93
6,123 0 1,765 +6,123 0.0d
1"x3/4" 90° ELBOW
C532
5,949 0 2,467 +5,949 0.0d
1" BALL VALVE (NEW)
C23L
5,610 0 2,593 +5,610 0.0d
1X 3/4 CPVC RED. COUPLING
C932
5,536 0 2,946 +5,536 0.0d
3/4 CPVC TRANSITION BRUSHING
C702
5,409 0 2,767 +5,409 0.0d
1-1/2 CPVC 90 DEG, ELBOW (NEW)
C55
4,856 0 1,270 +4,856 0.0d
1 CPVC MALE ADAPTER PLASTIC THREAD
C103
4,736 0 2,070 +4,736 0.0d
1 CPVC CTS BALL VALVE
C23
4,524 0 1,876 +4,524 0.0d
1"x1/2" BRASS COUPLING
C930
3,926 0 3,925 +3,926 0.0d
3/4 CPVC CTS BALL VALVE
C22
3,803 0 1,706 +3,803 0.0d
1-1/2 CPVC COUPLING
C45
3,698 0 2,134 +3,698 0.0d
3/4" BALL VALVE (NEW)
C22L
3,610 0 1,373 +3,610 0.0d
3/4 CPVC MALE ADAPTER PLASTIC THREADS
C102
3,483 0 960 +3,483 0.0d
C13
3,436 0 1,837 +3,436 0.0d
C732
3,407 0 1,975 +3,407 0.0d
3/4 CPVC 45 DEG, ELBOW SOC (NEW)
C502
3,023 0 3,302 +3,302 0.0d
1-1/2 CPVC. TEE
C65
2,327 0 1,207 +2,327 0.0d
3/4 CPVC FEMALE ADAPTER PLASTIC THREAD
C92
2,186 0 433 +2,186 0.0d
3/4" TANK NIPPLE (TH)
C272N
2,180 0 713 +2,180 0.0d
C731
2,063 0 1,375 +2,063 0.0d
3/4 CPVC MALE ADAPTER BRASS THREADS
C72
2,045 0 1,325 +2,045 0.0d
PC22
-3,545 0 1,904 +1,904 0.0d
C843
1,874 0 1,567 +1,874 0.0d
3/4 CPVC UNION
C32
1,653 0 1,800 +1,800 0.0d
1-1/4 CPVC COUPLING
C44
-306 0 1,787 +1,787 0.0d
1 CPVC MALE ADAPTER BRASS THREADS
C73
1,753 0 1,552 +1,753 0.0d
C703N
1,061 0 1,733 +1,733 0.0d
PC23
-3,670 0 1,720 +1,720 0.0d
1-1/4 CPVC. TEE
C64
77 0 1,689 +1,689 0.0d
1" TANK ADDEPTOR
C273
946 0 1,257 +1,257 0.0d
CH72
1,216 0 491 +1,216 0.0d
C56
1,177 0 667 +1,177 0.0d
C83
961 0 513 +961 0.0d
3/4 X 1/2CPVC MALE ADAPTER PLASTIC T
C101
-3,137 0 700 +700 0.0d
C853
422 0 553 +553 0.0d
C953
-762 0 518 +518 0.0d
C272
-1,290 0 453 +453 0.0d
C703
-1,320 0 433 +433 0.0d
C320
-665 0 400 +400 0.0d
BRASS ELBOW MIXER 20X15 WATER INLET DOWN
CM22
398 0 +398
C242
-2 0 339 +339 0.0d
C95
329 0 200 +329 0.0d
C90
-939 0 133 +133 0.0d
CPVC Pipe & Fittings 10 items · CPVC PIPE
Item Produced Required Closing Stock Ideal Qty Net Req Days Cover
3/4" PIPE SDR 11 (3MTR LENGTH)
PS-2
34,242 0 4,893 +34,242 0.0d
3/4" PIPE SDR 13.5 (3MTR LENGTH)
PS-12
31,045 0 3,162 +31,045 0.0d
1" PIPE SDR 11 (3MTR LENGTH)
PS-3
30,793 0 5,283 +30,793 0.0d
1" PIPE SDR 13.5 (3MTR LENGTH)
PS-13
28,556 0 3,420 +28,556 0.0d
1.1/4" PIPE SDR 11 (3MTR LENGTH)
PS-4
3,454 0 1,790 +3,454 0.0d
1.1/2" PIPE SDR 13.5 (3MTR LENGTH)
PS-15
2,559 0 845 +2,559 0.0d
1.1/4" PIPE SDR 13.5 (3MTR LENGTH)
PS-14
1,588 0 1,197 +1,588 0.0d
1-1/2" PIPE SDR 11 (3MTR LENGTH)
PS-5
644 0 849 +849 0.0d
2" PIPE SDR 11 (3MTR LENGTH)
PS-6
164 0 356 +356 0.0d
2" PIPE SDR 13.5 (3MTR LENGTH)
PS-16
347 0 297 +347 0.0d
UPVC Pipe & Fittings 50 items · UPVC FITTINGS
Item Produced Required Closing Stock Ideal Qty Net Req Days Cover
1" ELBOW (90°) 25 MM
U53
108,360 0 32,416 +108,360 0.0d
1" COUPLING 25 MM
U43
54,777 0 15,736 +54,777 0.0d
3/4" ELBOW (90°) 20 MM
U52
49,801 0 16,740 +49,801 0.0d
1/2" ELBOW (90°) 15 MM
U51
30,003 0 13,623 +30,003 0.0d
1" TEE 25 MM
U63
27,319 0 9,505 +27,319 0.0d
3/4" COUPLING 20 MM
U42
22,319 0 7,510 +22,319 0.0d
1" TANK NIPPLE (NEW.)
U273N
14,361 0 3,669 +14,361 0.0d
3/4X1/2" REDUCER BRASS ELBOW 20X15 MM
U521
14,332 0 4,855 +14,332 0.0d
1" UNION 25 MM
U33
12,535 0 3,625 +12,535 0.0d
1" 45° ELBOW
U503
10,781 0 4,083 +10,781 0.0d
1.1/4" ELBOW (90°) 32 MM
U54
10,715 0 3,472 +10,715 0.0d
1/2" COUPLING 15 MM
U41
10,648 0 6,240 +10,648 0.0d
3/4X1/2" FABT
U920
10,520 0 5,503 +10,520 0.0d
1" MALE ADAPTER (PLASTIC THREADS) 25 MM
U103
8,800 0 4,010 +8,800 0.0d
1" UPVC  BALL VALVE WITH LEVER HANDEL
U23-L
8,325 0 3,280 +8,325 0.0d
1.1/4" COUPLING 32 MM
U44
8,044 0 2,267 +8,044 0.0d
1.1/2" COUPLING 40 MM
U45
6,712 0 3,012 +6,712 0.0d
1/2" FEMALE ADAPTER (BRASS THREADS) 15MM
U81
6,570 0 2,850 +6,570 0.0d
1x3/4" RED ELBOW
U532
6,513 0 1,770 +6,513 0.0d
1/2X1/2" REDUCER BRASS ELBOW 15MM
U526
5,277 0 3,810 +5,277 0.0d
1X1/2" REDUCER TEE 25 X15MM
U231
5,046 0 1,420 +5,046 0.0d
1X1/2" REDUCER BRASS TEE 25X15 MM
U323
4,862 0 2,350 +4,862 0.0d
1.1/2" ELBOW (90°) 40 MM
U55
4,731 0 3,000 +4,731 0.0d
1/2" TEE 15 MM
U61
-14,956 0 4,630 +4,630 0.0d
3/4" MALE ADAPTER (PLASTIC THREADS) 20MM
U102
4,487 0 830 +4,487 0.0d
3/4" UNION 20 MM
U32
4,473 0 1,243 +4,473 0.0d
1/2" END CAP 15 MM
U601
4,383 0 2,000 +4,383 0.0d
3/4X1/2" REDUCER BRASS TEE 20 X15MM
U322
4,290 0 2,900 +4,290 0.0d
3/4" TEE 20 MM
U62
2,475 0 3,820 +3,820 0.0d
1.1/4X1" REDUCER BUSHING 32X25 MM
U843
3,323 0 2,533 +3,323 0.0d
1/2" UPVC  BALL VALVE WITH LEVER HANDEL
U21-L
3,282 0 2,400 +3,282 0.0d
1/2" MALE ADAPTER (PLASTIC THREADS) 15MM
U101
1,193 0 2,933 +2,933 0.0d
1" FEMALE ADAPTER (PLASTIC THREADS) 25MM
U93
2,908 0 2,300 +2,908 0.0d
3/4" FEMALE ADAPTER(PLASTIC THREADS)20MM
U92
2,861 0 1,000 +2,861 0.0d
1/2" MALE ADAPTER (BRASS THREADS) 15 MM
U71
245 0 2,750 +2,750 0.0d
1x1/2" BRASS ELBOW
U523
-216 0 2,575 +2,575 0.0d
1" END CAP 25 MM
U603
1,000 0 2,417 +2,417 0.0d
1.1/4" TEE 32 MM
U64
2,093 0 1,853 +2,093 0.0d
3/4" END CAP 20 MM
U602
-972 0 1,933 +1,933 0.0d
1X3/4" RED TEE
U232
1,917 0 1,110 +1,917 0.0d
1"x1/2" RED. BUSH
U831
1,781 0 620 +1,781 0.0d
1/2" FEMALE ADAPTER(PLASTIC THREADS)15MM
U91
917 0 1,767 +1,767 0.0d
1/2" BALL VALUE 15 MM
U21
1,630 0 733 +1,630 0.0d
3/4X1/2" REDUCER BUSHING 20X15 MM
U821
-2,450 0 1,600 +1,600 0.0d
1X3/4" RED COUPLER
U932
-3,247 0 1,517 +1,517 0.0d
1X3/4" RED BUSH
U832
1,285 0 1,242 +1,285 0.0d
3/4" UPVC  BALL VALVE WITH LEVER HANDEL
U22-L
516 0 1,228 +1,228 0.0d
1" TANK NIPPLE 25 MM
U273
522 0 985 +985 0.0d
1" BALL VALVE 25 MM
U23
485 0 741 +741 0.0d
3/4" BALL VALUE 20 MM
U22
-37 0 337 +337 0.0d
UPVC Pipe & Fittings 10 items · UPVC PIPE
Item Produced Required Closing Stock Ideal Qty Net Req Days Cover
1" Pipe SCH 40 (3 Mtr. Length)
PU-13
38,779 0 4,670 +38,779 0.0d
3/4" Pipe SCH 40 (3 Mtr. Length)
PU-12
11,525 0 1,375 +11,525 0.0d
1" Pipe SCH 40 (6 Mtr. Length)
PU-13S
5,980 0 1,852 +5,980 0.0d
1.1/4" Pipe SCH 40 (3 Mtr. Length)
PU-14
4,675 0 837 +4,675 0.0d
1.1/4" Pipe SCH 80 Threaded END (3 Mtr.)
PU-4T
3,758 0 615 +3,758 0.0d
3/4" Pipe SCH 40 (6 Mtr. Length)
PU-12S
2,788 0 1,160 +2,788 0.0d
1/2" Pipe SCH 40 (3 Mtr. Length)
PU-11
2,370 0 1,818 +2,370 0.0d
1.1/2" Pipe SCH 40 (3 Mtr. Length)
PU-15
1,059 0 804 +1,059 0.0d
1" Pipe SCH 80 Threaded END (3Mtr)
PU-3T
336 0 128 +336 0.0d
3/4" Pipe SCH 80 (6 Mtr. Length)
PU-2S
-540 0 220 +220 0.0d
Agri Pipe & Fittings 25 items · AGRI FITTINGS
Item Produced Required Closing Stock Ideal Qty Net Req Days Cover
END CAP 75 MM
A-567
1,308 0 +1,308 0.0d
COUPLING 50 MM
A-265
1,253 0 +1,253 0.0d
63MM END CAP4 KG/CM2
A-546
736 0 +736 0.0d
COUPLING 63 MM
A-266
632 0 +632
90MM ELBOW 4 KG/CM2
A-448
-393 0 570 +570 0.0d
TEE 50 MM
A-365
29 0 +29 0.0d
ELBOW 40 MM
A-464
-1,565 0 OK 0.0d
ELBOW 50 MM
A-465
-9,625 0 OK 0.0d
63MM ELBOW 4 KG/CM2
A-446
-1,307 0 OK 0.0d
110MM END CAP4 KG/CM2
A-549
-1,975 0 OK 0.0d
75MM END CAP4 KG/CM2
A-547
-1,554 0 OK 0.0d
110MM ELBOW 4 KG/CM2
A-449
-1,916 0 OK 0.0d
COUPLING 40 MM
A-264
-155 0 OK 0.0d
63MM EQUAL TEE4 KG/CM2
A-346
-306 0 OK 0.0d
TEE 40 MM
A-364
-1,465 0 OK 0.0d
110MM COUPLER4 KG/CM2
A-249
-1,256 0 OK 0.0d
REDUCER TEE 110X63 MM
A-665
-390 0 OK 0.0d
110MM EQUAL TEE4 KG/CM2
A-349
-761 0 OK 0.0d
ELBOW 63 MM
A-466
-628 0 OK 0.0d
END CAP 110 MM
A-569
-4 0 OK 0.0d
REDUCER COUPLER 75X50
A-761
-440 0 OK 0.0d
75MM COUPLER4 KG/CM2
A-247
-740 0 OK 0.0d
ELBOW 110 MM
A-469
-204 0 OK 0.0d
75MM EQUAL TEE4 KG/CM2
A-347
-179 0 OK 0.0d
75MM ELBOW 4 KG/CM2
A-447
-1,702 0 OK 0.0d
Agri Pipe & Fittings 4 items · AGRI PIPE
Item Produced Required Closing Stock Ideal Qty Net Req Days Cover
75 MM 6 KG AGRI PIPE
A-47C
408 0 9 +408 0.0d
50 MM 6 KG AGRI PIPE
A-45C
-550 0 135 +135 0.0d
40 MM 6 KG AGRI PIPE
A-44C
-483 0 114 +114 0.0d
63 MM 6 KG AGRI PIPE
A-46C
-146 0 13 +13 0.0d
SWR Pipe & Fittings 25 items · SWR FITTINGS
Item Produced Required Closing Stock Ideal Qty Net Req Days Cover
SWR FITTING PIPE CLIP (75 MM)
5762
10,397 0 4,720 +10,397 0.0d
110 MM 45 BEND
5110S
4,191 0 1,395 +4,191 0.0d
SWR FITTING P TRAP (125X110MM)
5771
3,710 0 942 +3,710 0.0d
NAHANI TRAP WITHOUT ROUND JALI(110 MM)
5163-W
2,296 0 1,234 +2,296 0.0d
75 MM 45 BEND
5710S
2,277 0 516 +2,277 0.0d
SWR FITTING VENT COWL (75 MM)
5761
1,980 0 2,095 +2,095 0.0d
NAHANI TRAP WITHOUT ROUND JALI
5763-W
591 0 1,689 +1,689 0.0d
SWR FITTING NAHANI TRAP & JALI (75 MM)
5763
1,173 0 389 +1,173 0.0d
75 MM BEND
5711S
899 0 182 +899 0.0d
110 MM BEND
5111S
769 0 437 +769 0.0d
110 MM SINGLE Y
5141S
660 0 310 +660 0.0d
SWR FITTING SINGLE Y (75 MM)
5741
-646 0 435 +435 0.0d
RUBBER LUBRICANT 100g
RL02
408 0 370 +408 0.0d
75 MM COUPLER
5721S
-344 0 308 +308 0.0d
110 MM TEE
5133S
283 0 180 +283 0.0d
110 MM COUPLER
5121S
-533 0 260 +260 0.0d
SWR FITTING ROUND JALI (110MM)
5765
-481 0 240 +240 0.0d
75 MM TEE
5733S
-138 0 225 +225 0.0d
RUBBER LUBRICANT 250g
RL03
110 0 50 +110 0.0d
SWR FITTING CLEANSING PIPE (75 MM)
5758
-600 0 90 +90 0.0d
SWR FITTING DOOR CAP (75MM)
5764
-1,880 0 70 +70 0.0d
SWR FITTING FLOOR TRAP (110X75 MM)
5791
-84 0 10 +10 0.0d
SWR FITTING DOUBLE Y (75 MM)
5744
-315 0 10 +10 0.0d
RUBBER LUBRICANT 500g
RL04
4 0 +4
SWR FITTING S TRAP (125X110 MM)
5773
-40 0 OK
SWR Pipe & Fittings 10 items · SWR PIPE
Item Produced Required Closing Stock Ideal Qty Net Req Days Cover
SWR PIPE S/S 110 MM (3 METER-A)
PW11
31,084 0 4,428 +31,084 0.0d
SWR PIPE S/S 75 MM (3 METER-A)
PW71
19,451 0 2,896 +19,451 0.0d
SWR PIPE D/S 110 MM (3 METER-A)
PW12
900 0 123 +900 0.0d
SWR PIPE D/S 75 MM (3 METER-A)
PW72
820 0 126 +820 0.0d
SWR PIPE S/S 160 MM (3 METER-A)
PW61
810 0 245 +810 0.0d
SWR PIPE D/S 110 MM (6 FEET-A)
PW18
717 0 105 +717 0.0d
SWR PIPE D/S 110 MM (4 FEET-A)
PW17
623 0 72 +623 0.0d
SWR PIPE D/S 110 MM (2 FEET-A)
PW15
134 0 88 +134 0.0d
SWR PIPE S/S 110 MM (6 METER-A)
PW13
0 OK
SWR PIPE S/S 110 MM (6 METER-B)
PW23
-10 0 OK