PIPE,1/4IN,SCH80,P11,SMLS,6M LG
Material 4100027903 · PIPE · Plant 1000
AReduceExcess
- Material
- 4100027903
- Category
- PIPE
- Base unit
- LG
- MRP type
- Stock Item
- Criticality
- A (5 of 10 FuncLocs A/B)
- Supplier
- CAHAYA INDUSTRI SENTOSA PT
- Lead time
- 28 d · P80 37 d
- Unit price
- Rp 5.2M
Recommendation
- 1.Forecast 46 LG/year: 46 unplanned (recency-weighted compound poisson (own history)).
- 2.Lead time ~28 days; expected demand during lead time 3.5.
- 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 15, order up to 27.
- 4.Stock 122 exceeds the level to keep (27) by 95.
- 5.Installed on 10 FuncLoc(s), 5 of them criticality A/B.
- 6.ML early warning: 98% probability of demand in the next 90 days.
ML early warningLast turnaround used 12Single sourceAbnormal consumption
On hand / on order
122 / 0
no open PO
Today Min / Max
45 / 136
static parameters in BoM
Rec. Min (reorder point)
15
safety stock 12
Rec. Max
27
order qty 12
Service level
99.9%
stockout risk now 0%
Unit price
Rp 5.2M
PO history
ML early warning: 98% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 5 issue days in the last 180 days, last issue 9 days ago, 22 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 7 PRs in 180 days.
Consumption history and 12-month forecast
Units per month. Turnaround issues (15 units) excluded from the baseline.
Demand pattern Lumpy · 26 issue days · 1 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 4.3B/yr in expected downtime and emergency buys. A stockout here stops production with probability 1.07% for ~13 days.
Installed on 10 functional locations
5 with criticality A/B · 69 units installed
| FuncLoc | Crit. | Installed | Notifications | Failures / yr |
|---|---|---|---|---|
| PX_BF-102 CRACKING FURNACE BF-102 | A | 12 | 71 | 28.72 |
| PX_BF-107 CRACKING FURNACE BF-107 | A | 6 | 23 | 9.01 |
| PX_HE-974 SLOP OIL CONDENSER | A | 1 | 0 | 0.22 |
| PX_HE-995C FEED TLE | B | 6 | 0 | 0.22 |
| PY_HE-965B RECYCLE ETHANE TLE | B | 1 | 0 | 0.22 |
| PX_3/4-LS-10065-A22A-H PIPE-3/4 FROM HE-1547 TO VD-999 | C | 12 | 0 | 0.01 |
| PX_8-QO-5655-A21A PIPE-8 FROM VD-1822 TO HE-1305B | C | 12 | 0 | 0.01 |
| PX_HE-1554A SPENT CAUSTIC COOLER | C | 12 | 0 | 0.22 |
| PY_HE-1593C LEAN AMINE REBOILER | C | 1 | 0 | 0.22 |
| UT_HE-536 FLUSHING OIL CONDENSER | C | 6 | 0 | 0.22 |
Lead time and procurement
Lead time 28 ± 19 days (PO history, 12 PO lines) · on-time 42%
| PR date | Type | Qty | Unit price | Delivery | Lead time |
|---|---|---|---|---|---|
| 25 Aug 2026 | PR06 Regular replenishment | 30 | Rp 5.3M | 06 Sept 2026 | 12 d |
| 14 Jul 2026 | PR01 Import / long-lead | 38 | Rp 5.3M | 23 Aug 2026 | 40 d |
| 05 Jul 2026 | PR03 Regular replenishment | 49 | Rp 5.3M | 13 Jul 2026 | 8 d |
| 27 Jun 2026 | PR06 Regular replenishment | 44 | Rp 5.0M | 21 Jul 2026 | 24 d |
| 28 May 2026 | PR03 Regular replenishment | 26 | Rp 5.1M | 12 Jun 2026 | 15 d |
| 25 Apr 2026 | PR06 Regular replenishment | 21 | Rp 5.2M | 15 May 2026 | 20 d |
| 17 Apr 2026 | PR06 Regular replenishment | 47 | Rp 5.3M | 13 May 2026 | 26 d |
| 16 Jan 2026 | PR05 Project / turnaround | 14 | Rp 5.0M | 15 Feb 2026 | 30 d |
| 30 Dec 2025 | PR04 Regular (other) | 36 | Rp 5.1M | 21 Jan 2026 | 22 d |
| 06 Oct 2025 | PR03 Regular replenishment | 35 | Rp 5.2M | 14 Nov 2025 | 39 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 |
|---|---|---|---|
| 24 Sept 2026 | Low | PX_BF-107 | Install scaffolding at BF-107 |
| 23 Sept 2026 | Low | PX_BF-102 | Replace burner tip BF-102 |
| 08 Sept 2026 | Medium | PX_BF-107 | Replace lamp as per PM finding |
| 07 Sept 2026 | Low | PX_BF-102 | Thermograph wall BF-102 |
| 06 Sept 2026 | Medium | PX_BF-102 | Decoking follow up BF-102 |
| 03 Sept 2026 | Medium | PX_BF-102 | Replace lamp as per PM finding |
| 30 Aug 2026 | High | PX_BF-102 | Painting BF-102 |
| 27 Aug 2026 | Medium | PX_BF-102 | Decoking follow up BF-102 |
| 15 Aug 2026 | Medium | PX_BF-107 | Hot spot at convection BF-107 |
| 14 Aug 2026 | Emergency | PX_BF-102 | Thermograph wall BF-102 |
Recent goods issues
| Posting date | Qty | Order | Order type |
|---|---|---|---|
| 22 Sept 2026 | 3 | 201000022167 | Corrective |
| 25 Jul 2026 | 2 | 201000034014 | Corrective |
| 23 Jul 2026 | 1 | 201000001320 | Corrective |
| 11 Jun 2026 | 1 | 201000037853 | Corrective |
| 19 May 2026 | 2 | 201000006755 | Corrective |
| 19 May 2026 | 5 | 201000027299 | Corrective |
| 12 Feb 2026 | 2 | 201000012252 | Corrective |
| 14 Jan 2026 | 2 | 201000036735 | Corrective |
| 06 Jan 2026 | 6 | 201000015180 | Corrective |
| 29 Dec 2025 | 6 | 203000036002 | Turnaround |
| 15 Dec 2025 | 1 | 201000009616 | Corrective |
| 10 Dec 2025 | 1 | 201000033790 | Corrective |
| 07 Dec 2025 | 4 | 201000002161 | Corrective |
| 05 Dec 2025 | 3 | 201000018149 | Corrective |
| 03 Dec 2025 | 1 | 201000032207 | Corrective |