PIPE,1IN,SCH80,P11,SMLS,6M LG
Material 4100027715 · PIPE · Plant 1000
AReduceExcess
- Material
- 4100027715
- Category
- PIPE
- Base unit
- LG
- MRP type
- Stock Item
- Criticality
- A (38 of 78 FuncLocs A/B)
- Supplier
- RAJAWALI INSTRUMEN INTERNASIONAL PT
- Lead time
- 23 d · P80 29 d
- Unit price
- Rp 842,294
Recommendation
- 1.Forecast 495 LG/year: 495 unplanned (recency-weighted compound poisson (own history)).
- 2.Lead time ~23 days; expected demand during lead time 31.
- 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 109, order up to 203.
- 4.Stock 262 exceeds the level to keep (219) by 43; the level includes the 219 used in the last turnaround.
- 5.Installed on 78 FuncLoc(s), 38 of them criticality A/B.
- 6.ML early warning: 100% probability of demand in the next 90 days.
ML early warningLast turnaround used 219Single sourceAbnormal consumptionOpen PO
On hand / on order
262 / 163
next delivery 03 Oct 2026
Today Min / Max
113 / 330
static parameters in BoM
Rec. Min (reorder point)
109
safety stock 79
Rec. Max
203
order qty 94
Service level
99.9%
stockout risk now 0%
Unit price
Rp 842,294
PO history
ML early warning: 100% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 44 issue days in the last 180 days, last issue 4 days ago, 118 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 11 PRs in 180 days.
Consumption history and 12-month forecast
Units per month. Turnaround issues (258 units) excluded from the baseline.
Demand pattern Smooth · 168 issue days · 11 abnormal issue(s) capped · method: Recency-weighted compound Poisson (own history).
Cost of each service level
Annual holding vs downtime-risk cost for this part
Not stocking at all would cost Rp 30.7B/yr in expected downtime and emergency buys. A stockout here stops production with probability 1.07% for ~13 days.
Installed on 78 functional locations
38 with criticality A/B · 424 units installed
| FuncLoc | Crit. | Installed | Notifications | Failures / yr |
|---|---|---|---|---|
| PX_BF-105 CRACKING FURNACE BF-105 | A | 3 | 114 | 42.86 |
| PX_BF-106 CRACKING FURNACE BF-106 | A | 12 | 82 | 30.86 |
| PX_BF-112 CRACKING FURNACE BF-112 | A | 12 | 73 | 27.01 |
| PX_BF-102 CRACKING FURNACE BF-102 | A | 3 | 71 | 28.72 |
| PX_BF-103 CRACKING FURNACE BF-103 | A | 3 | 38 | 14.58 |
| PX_BF-109 CRACKING FURNACE BF-109 | A | 6 | 29 | 11.58 |
| PX_BF-104 CRACKING FURNACE BF-104 | A | 3 | 28 | 11.58 |
| PX_BF-107 CRACKING FURNACE BF-107 | A | 3 | 23 | 9.01 |
| PX_HE-278D COOLING WATER TLE | A | 12 | 9 | 3.65 |
| PX_HE-126D DILUTION STEAM PREHEATER | A | 3 | 5 | 1.08 |
| PX_HE-532B PROPYLENE COOLER | A | 12 | 4 | 1.50 |
| PX_HE-432D INHIBITOR COOLER | A | 2 | 2 | 0.65 |
Lead time and procurement
Lead time 23 ± 15 days (PO history, 50 PO lines) · on-time 39%
| PR date | Type | Qty | Unit price | Delivery | Lead time |
|---|---|---|---|---|---|
| 14 Sept 2026 | PR03 Regular replenishment | 163 | Rp 834,332 | 03 Oct 2026 open | 19 d |
| 03 Sept 2026 | PR03 Regular replenishment | 469 | Rp 865,275 | 22 Sept 2026 | 19 d |
| 19 Aug 2026 | PR03 Regular replenishment | 169 | Rp 841,704 | 25 Aug 2026 | 6 d |
| 14 Aug 2026 | PR03 Regular replenishment | 404 | Rp 810,912 | 26 Aug 2026 | 12 d |
| 20 Jun 2026 | PR05 Project / turnaround | 216 | Rp 809,193 | 07 Aug 2026 | 48 d |
| 21 May 2026 | PR03 Regular replenishment | 329 | Rp 867,571 | 11 Jun 2026 | 21 d |
| 29 Apr 2026 | PR03 Regular replenishment | 388 | Rp 814,758 | 23 May 2026 | 24 d |
| 22 Apr 2026 | PR06 Regular replenishment | 314 | Rp 832,078 | 28 Apr 2026 | 6 d |
| 20 Apr 2026 | PR03 Regular replenishment | 328 | Rp 851,687 | 29 Apr 2026 | 9 d |
| 17 Apr 2026 | PR03 Regular replenishment | 340 | Rp 877,276 | 16 May 2026 | 29 d |
Planned maintenance demand (next 12 months)
No part-consuming maintenance job uses this part in the next 12 months.
Recent notifications on its equipment
| Date | Priority | FuncLoc | Description |
|---|---|---|---|
| 30 Sept 2026 | Low | PX_BF-103 | Leak from packing |
| 30 Sept 2026 | Medium | PX_BF-112 | Install cover plate BF-112 |
| 29 Sept 2026 | High | PX_BF-105 | Repair refractory crack BF-105 |
| 29 Sept 2026 | Medium | PX_BF-106 | Decoking follow up BF-106 |
| 29 Sept 2026 | Medium | PX_BF-106 | Decoking follow up BF-106 |
| 29 Sept 2026 | Low | PX_BF-112 | Painting BF-112 |
| 28 Sept 2026 | Low | PX_BF-106 | Peep door broken BF-106 |
| 27 Sept 2026 | Medium | PX_BF-112 | Repair insulation BF-112 |
| 27 Sept 2026 | Medium | PX_HE-532B | Replace lamp as per PM finding |
| 25 Sept 2026 | Medium | PX_BF-108 | Repair refractory crack BF-108 |
Recent goods issues
| Posting date | Qty | Order | Order type |
|---|---|---|---|
| 29 Sept 2026 | 3 | 203000034378 | Turnaround |
| 27 Sept 2026 | 1 | 201000028432 | Corrective |
| 25 Sept 2026 | 4 | 201000015740 | Corrective |
| 25 Sept 2026 | 6 | 209000029477 | Other maintenance |
| 22 Sept 2026 | 4 | 201000037585 | Corrective |
| 18 Sept 2026 | 4 | 201000030125 | Corrective |
| 13 Sept 2026 | 2 | 201000010235 | Corrective |
| 13 Sept 2026 | 3 | 201000017566 | Corrective |
| 13 Sept 2026 | 1 | 201000034185 | Corrective |
| 11 Sept 2026 | 2 | 204000013108 | Preventive |
| 10 Sept 2026 | 5 | 204000013108 | Preventive |
| 06 Sept 2026 | 2 | 201000009852 | Corrective |
| 05 Sept 2026 | 4 | 201000021947 | Corrective |
| 04 Sept 2026 | 2 | 206000018039 | Other maintenance |
| 04 Sept 2026 | 1 | 206000018039 | Other maintenance |