Material Readiness
Raw material / BOP / packaging stock — recomputed from Report-2/3/4 tabs
Weekly snapshot — Report-2/3/4 are updated once per week, not daily.
Figures are recomputed from raw cells; the sheet-supplied "Stock Days" is used
only as a cross-check (PIPE only).
88
Total items
6
Reorder now
3
Categories
Cover ≤ Lead time (reorder)
Cover ≤ 1.5× Lead time (watch)
Adequate cover
Raw Material
42 items
| Item | Ideal Stock |
Min Batch |
Lead Time (d) |
Closing Stock |
Cover (days) |
|---|---|---|---|---|---|
|
PLR41
TIO2 CP-8-20IF (R104)
PIPE
|
1,495 | 500 | 5 | 2,000 | 8.3 |
|
PLR55
PVC RESIN MOLDING GRADE K-57
PIPE
|
10,900 | 15,000 | 4 | 60,050 | 28.0 |
|
PLR57
TIN STABLIZER 502
PIPE
|
— | — | — | 1,284 | 34.2 |
|
PLR33
IMPACT MODIFIER B564
PIPE
|
1,523 | 500 | 3 | 1,107 | 37.0 ⊛ |
|
PLR45
PVC RESIN PIPE GRADE K67
PIPE
|
54,525 | 20,000 | 5 | 286,025 | 37.5 |
|
PLR56
UPVC-MTM
PIPE
|
— | 220 | 2 | 621 | 38.1 ⊛ |
|
PLR49
Ca zn SMS 3210
PIPE
|
— | 500 | 5 | 4,296 | 40.4 ⊛ |
|
PLR62
PA-912
PIPE
|
— | — | — | 1,488 | 42.2 ⊛ |
|
PLR36
WAX AC 617 AC 617
PIPE
|
225 | 200 | 3 | 355 | 55.3 ⊛ |
|
PLR51
UPVC PE-WAX/EL-WAX
PIPE
|
323 | 300 | 5 | 3,019 | 58.4 ⊛ |
|
PLR54
Purosol SF
PIPE
|
— | — | — | 666 | 60.1 ⊛ |
|
PLR20
GRANUALS-CG122
PIPE
|
— | 24,000 | 60 | 41,650 | 68.3 ⊛ |
|
PLR48
Carbon Black 1830 SUD
PIPE
|
— | — | — | 254 | 77.1 ⊛ |
|
PLR47
CPE
PIPE
|
1,014 | 500 | 5 | 1,676 | 79.1 ⊛ |
|
PLR32
RESION J-700
PIPE
|
22,500 | 36,000 | 40 | 164,318 | 79.9 ⊛ |
|
PLR37
WAX AC 629 AC629
PIPE
|
158 | 200 | 3 | 215 | 173.4 ⊛ |
|
PLR35
PROCESSING AID PA101
PIPE
|
331 | 300 | 3 | 0 | — |
|
PLR38
WAX AC 316 AC316
PIPE
|
— | — | — | 0 | — |
|
PLR40
ANTI OXIDANT 1076 R-1076
PIPE
|
223 | 300 | 5 | 0 | — |
|
PLR42
YELLOW COLOUR 165 N
PIPE
|
— | — | — | 30 | — |
|
PLR43
DSM1 MOSTAB-RG27
PIPE
|
335 | 1,000 | 10 | 0 | — |
|
PLR44
RED COLOUR
PIPE
|
— | — | — | 0 | — |
|
PLR123
UPVC CACO3
PIPE
|
— | 20,000 | 5 | 0 | — |
|
PLR58
IMPACT MODIFIER IM 812
PIPE
|
— | — | — | 0 | — |
|
PLR60
UPVC CS
PIPE
|
— | — | — | 297 | — |
|
PLR61
UV UN-3077
PIPE
|
— | — | — | 0 | — |
|
PLR63
EPOXY
PIPE
|
— | — | — | 0 | — |
|
PLR72
FINALUXG 158
PIPE
|
— | — | — | 0 | — |
|
PLR73
Stabilizer Hybrid 1048XLX
PIPE
|
— | — | — | 0 | — |
|
PLR74
Flow AID
PIPE
|
— | — | — | 0 | — |
|
PLR75
Lithomer-TOX
PIPE
|
— | — | — | 0 | — |
|
PLR76
PVC STABILIZER 1001
PIPE
|
— | — | — | 0 | — |
|
PLR77
PVC STABILIZER CALAID +
PIPE
|
— | — | — | 0 | — |
|
PLS71
GRANUALS-CG122
PIPE
|
— | — | — | 0 | — |
|
PLS72
GRANUALS-CPVC GRAY 112
PIPE
|
— | — | — | 0 | — |
|
PLS73
ABS(N) B 5123
PIPE
|
— | — | — | 0 | — |
|
PLS74
ABS TRANSPRINT GRANULS
PIPE
|
— | — | — | 0 | — |
|
PLS75
PPCP
PIPE
|
— | — | — | 0 | — |
|
PLS76
BLUE MASTER BATCH 2379
PIPE
|
— | — | — | 0 | — |
|
PLS77
CREAM MASTER BATCH 18156
PIPE
|
— | — | — | 0 | — |
|
PLS83
Master Batch PP Ivory- 3088
PIPE
|
— | — | — | 0 | — |
|
PLS84
Master Batch Black- 2599
PIPE
|
— | — | — | 0 | — |
⊛ = sheet pre-computed "Stock Days" value available for cross-check.
Dashboard always uses the recomputed figure (closing ÷ daily consumption).
BOP — Bought-Out Parts
31 items
| Item | Ideal Stock |
Min Batch |
Lead Time (d) |
Closing Stock |
Cover (days) |
|---|---|---|---|---|---|
|
PLB196
PLB196-UPVC 1" UNION O RING 46.8X40X4.5
RING
|
6,000 | 1,000 | 8 | 4,672 | 11.7 ⊛ |
|
PLB2
PLB2-UPVC BALL VALVE 25MM
BALL VALVE
|
3,800 | 3,000 | 8 | 2,000 | 15.8 |
|
PLB12
PLB12-1/2" MABT BRASS
BRASS
|
7,136 | 5,000 | 5 | 8,016 | 16.8 ⊛ |
|
PLB23
PLB23-1/2" BRASS RING
BRASS
|
94,500 | 30,000 | 5 | 157,992 | 25.1 ⊛ |
|
PLB13
PLB13-3/4" MABT BRASS
BRASS
|
3,600 | 1,000 | 5 | 6,080 | 25.3 ⊛ |
|
PLB14
PLB14-1" MABT BRASS
BRASS
|
720 | 500 | 6 | 2,000 | 41.7 |
|
PLB24
PLB24-3/4" BRASS RING
BRASS
|
1,620 | 500 | 5 | 7,280 | 67.4 ⊛ |
|
PLB29
PLB29-1/2" UPVC MALE ADAPTER BRASS THREA
BRASS
|
3,120 | 1,000 | 6 | 15,040 | 72.3 ⊛ |
|
PLB3
PLB3-UPVC BALL VALVE 32MM
BALL VALVE
|
4,315 | 3,000 | 8 | 10,897 | 75.8 ⊛ |
|
PLB210
PLB210-SWR O-RING 75 MM - YELLOW
RING
|
28,800 | 20,000 | 6 | 200,035 | 104.2 ⊛ |
|
PLB194
PLB194-UPVC 1/2" UNION O RING 27.3X20.5X
RING
|
1,500 | 2,000 | 8 | 13,700 | 137.0 ⊛ |
|
PLB7
PLB7-UPVC BALL VALVE THREED 32MM
BALL VALVE
|
225 | 3,000 | 8 | 1,095 | 146.0 ⊛ |
|
PLB212
PLB212-SWR O-RING 110 MM - YELLOW
RING
|
14,000 | 20,000 | 6 | 153,560 | 164.5 ⊛ |
|
PLB182
PLB182-Q/T 22X1.5 CSC FITTING BIG
FITTING
|
600 | 1,000 | 20 | 3,800 | 190.0 ⊛ |
|
S5
CPVC SOLVENT -237ML-TIN (PR)
SOLVENT
|
960 | 480 | 15 | 6,745 | 210.8 ⊛ |
|
PLB4
PLB4-UPVC BALL VALVE 40MM
BALL VALVE
|
— | 500 | 8 | 1,812 | — |
|
PLB18
PLB18-3/4" FABT BRASS
BRASS
|
— | 500 | 6 | 0 | — |
|
PLB31
PLB31-1" UPVC MALE ADAPTER BRASS THREADS
BRASS
|
— | 500 | 8 | 6,240 | — |
|
PLB19
PLB19-1" FABT BRASS
BRASS
|
— | 800 | 8 | 0 | — |
|
PLB16
PLB16-1-1/2" MABT BRASS
BRASS
|
— | 200 | 8 | 300 | — |
|
PC 22
CPVCPIPE CLMP H.S W/T PDR COATING 3/4"
CLAMP
|
— | 1,000 | 10 | 0 | — |
|
PC 23
CPVCPIPE CLMP H.S W/T PDR COATING 1"
CLAMP
|
— | 2,000 | 10 | 0 | — |
|
PC 25
CPVCPIPE CLMP H.S W/T PDR COATING1 1/2"
CLAMP
|
— | 300 | 15 | 0 | — |
|
PC 24
CPVCPIPE CLMP H.S W/T PDR COATING 1 1/4"
CLAMP
|
— | 300 | 15 | 0 | — |
|
UC3
1" Pipe CLAMP(HEAVY SADDLE WITH PC)25MM
CLAMP
|
— | 300 | 15 | 0 | — |
|
S4
CPVC SOLVENT -118ML-TIN (PR)
SOLVENT
|
— | 1,440 | 8 | 4,320 | — |
|
S3
59 Ml CPvc Solvent Cement
SOLVENT
|
— | 576 | 15 | 0 | — |
|
S14
118 Ml Upvc Solvent Cement
SOLVENT
|
— | 1,440 | 15 | 0 | — |
|
S15
237 Ml Upvc Solvent Cement
SOLVENT
|
— | 480 | 15 | 0 | — |
|
S13
59ML Upvc Solvent Cement
SOLVENT
|
— | 576 | 15 | 11,160 | — |
|
S14
UPVC SOLVENT ( MD) CLEAR-118ML-TIN
SOLVENT
|
— | 1,440 | 15 | 0 | — |
⊛ = sheet pre-computed "Stock Days" value available for cross-check.
Dashboard always uses the recomputed figure (closing ÷ daily consumption).
Packaging
15 items
| Item | Ideal Stock |
Min Batch |
Lead Time (d) |
Closing Stock |
Cover (days) |
Suggested Purchase |
|---|---|---|---|---|---|---|
|
PLB102
PLB102-HDPE BAG PIPE SCH-40 3M
BAG
|
1,800 | 500 | 2 | 0 | 0.0 ⊛ | 1,800 |
|
PLB88
PLB88-HDPE BAG CLASS I SDR 11 3M
BAG
|
30 | 500 | 2 | 0 | 0.0 ⊛ | 500 |
|
PLB125
Packing Box Master 23.5x16.5x15.5
MASTER BOX
|
2,448 | 500 | 3 | 0 | 0.0 ⊛ | 2,448 |
|
PLB126
PLB108-UPVC MASTER BOX 15"X12"X10"
MASTER BOX
|
522 | 300 | 3 | 0 | 0.0 ⊛ | 522 |
|
PLB123
PLB97-CPVC MASTER BOX 18X15.8X12"
MASTER BOX
|
247 | 300 | 5 | 0 | 0.0 ⊛ | 300 |
|
PLB122
PLB96-CPVC MASTER BOX 15X12X10"
MASTER BOX
|
420 | 300 | 5 | 0 | 0.0 ⊛ | 420 |
|
PLB89
PLB89-HDPE BAG CLASS-II SDR-13.5 3M
BAG
|
— | 500 | 2 | 0 | — | — |
|
PLB103
PLB103-HDPE BAG PIPE SCH-80 3M
BAG
|
— | 300 | 2 | 0 | — | — |
|
PLB101
PLB101-HDPE BAG PIPE SCH-40 6M
BAG
|
— | 500 | 2 | 0 | — | — |
|
PLB135
PLB117-UPVC INNER BOX 100X55X95
INNER BOX
|
— | 2,000 | 8 | 0 | — | — |
|
PLB118
PLB118-UPVC INNER BOX 100X65X100
INNER BOX
|
— | 1,000 | 8 | 0 | — | — |
|
PLB116
PLB116-UPVC INNER BOX 90X45X80
INNER BOX
|
— | 1,000 | 8 | 0 | — | — |
|
PLB98
PLB98-CPVC MASTER BOX 12.5X12.5X6"
MASTER BOX
|
— | 300 | 5 | 0 | — | — |
|
PLB109
PLB109-UPVC MASTER BOX 18"X15.8"X12"
MASTER BOX
|
— | 300 | 5 | 0 | — | — |
|
PLB110
PLB110-UPVC MASTER BOX 12.5"X12.5"X6"
MASTER BOX
|
— | 300 | 5 | 0 | — | — |
⊛ = sheet pre-computed "Stock Days" value available for cross-check.
Dashboard always uses the recomputed figure (closing ÷ daily consumption).
How figures are computed
- Days of Cover
- = Closing Stock ÷ (Avg Consumption Last Month ÷ 30). Recomputed from raw cells — stored "Stock Days" (PIPE only) is a cross-check, not the headline.
- Reorder flag
- = Cover ≤ Lead time in days. Stock-out likely before replenishment arrives.
- Suggested Purchase
- = max(Ideal Stock − Closing Stock, Min Batch) when reorder flag is set.
- Ideal Stock (BOP/Report-3, PIPE)
- Derived from Buffer Stock (days) × daily consumption when no unit qty is given.