PIPE,12IN,STD,CS,SMLS,6M LG
Material 4100027945 · PIPE · Plant 1000
AReorderCriticalBelow reorder point
- Material
- 4100027945
- Category
- PIPE
- Base unit
- LG
- MRP type
- Stock Item
- Criticality
- A (5 of 7 FuncLocs A/B)
- Supplier
- CAHAYA INDUSTRI SENTOSA PT
- Lead time
- 57 d · P80 89 d
- Unit price
- Rp 478,114
Recommendation
- 1.Forecast 28 LG/year: 28 unplanned (recency-weighted compound poisson (own history)).
- 2.Lead time ~57 days; expected demand during lead time 4.4.
- 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 17, order up to 45.
- 4.On hand 4 + on order 13 is at or below the reorder point: order 28 now.
- 5.Installed on 7 FuncLoc(s), 5 of them criticality A/B.
- 6.ML early warning: 83% probability of demand in the next 90 days.
Proposed purchase requisition
28 LG
Rp 13.4M · order by 01 Oct 2026
Expected arrival ≈ 57 days
ML early warningLast turnaround used 27Single sourceAbnormal consumptionOpen PO
On hand / on order
4 / 13
next delivery 12 Oct 2026
Today Min / Max
3 / 8
static parameters in BoM
Rec. Min (reorder point)
17
safety stock 13
Rec. Max
45
order qty 28
Service level
99.9%
stockout risk now 0%
Unit price
Rp 478,114
PO history
ML early warning: 83% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 3 issue days in the last 180 days, last issue 37 days ago, 23 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 3 PRs in 180 days.
Consumption history and 12-month forecast
Units per month. Turnaround issues (27 units) excluded from the baseline.
Demand pattern Lumpy · 15 issue days · 2 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 2.8B/yr in expected downtime and emergency buys. A stockout here stops production with probability 1.07% for ~13 days.
Installed on 7 functional locations
5 with criticality A/B · 25 units installed
| FuncLoc | Crit. | Installed | Notifications | Failures / yr |
|---|---|---|---|---|
| PX_BF-103 CRACKING FURNACE BF-103 | A | 1 | 38 | 14.58 |
| PX_BF-107 CRACKING FURNACE BF-107 | A | 12 | 23 | 9.01 |
| PX_BF-111 CRACKING FURNACE BF-111 | A | 2 | 23 | 9.01 |
| PX_HE-1034A SLOP OIL REBOILER | A | 1 | 2 | 0.65 |
| PX_HE-1919A QUENCH WATER CONDENSER | B | 2 | 0 | 0.22 |
| PX_3/4-CW-7128-C11A-H PIPE-3/4 FROM PP-818 TO PP-1404A | C | 6 | 0 | 0.01 |
| PY_HE-1775A QUENCH OIL PREHEATER | C | 1 | 0 | 0.22 |
Lead time and procurement
Lead time 57 ± 37 days (PO history, 14 PO lines) · on-time 42%
| PR date | Type | Qty | Unit price | Delivery | Lead time |
|---|---|---|---|---|---|
| 26 Aug 2026 | PR03 Regular replenishment | 13 | Rp 497,809 | 12 Oct 2026 open | 47 d |
| 21 Jul 2026 | PR03 Regular replenishment | 29 | Rp 480,053 | 13 Sept 2026 | 54 d |
| 11 Apr 2026 | PR06 Regular replenishment | 14 | Rp 468,888 | 18 May 2026 | 37 d |
| 31 Mar 2026 | PR01 Import / long-lead | 29 | Rp 477,936 | 08 Sept 2026 | 161 d |
| 02 Mar 2026 | PR03 Regular replenishment | 37 | Rp 468,693 | 16 Apr 2026 | 45 d |
| 25 Feb 2026 | PR03 Regular replenishment | 39 | Rp 491,571 | 20 Mar 2026 | 23 d |
| 27 Dec 2025 | PR03 Regular replenishment | 13 | Rp 464,296 | 19 Jan 2026 | 23 d |
| 11 Nov 2025 | PR03 Regular replenishment | 20 | Rp 462,814 | 30 Jan 2026 | 80 d |
| 08 Nov 2025 | PR03 Regular replenishment | 16 | Rp 467,803 | 01 Jan 2026 | 54 d |
| 15 Sept 2025 | PR03 Regular replenishment | 32 | Rp 483,836 | 26 Dec 2025 | 102 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 |
| 24 Sept 2026 | Low | PX_BF-107 | Install scaffolding at BF-107 |
| 22 Sept 2026 | Medium | PX_BF-111 | Install cover plate BF-111 |
| 20 Sept 2026 | Medium | PX_BF-103 | Leak from packing |
| 19 Sept 2026 | Low | PX_BF-103 | Leak from packing |
| 15 Sept 2026 | Medium | PX_BF-103 | Replace lamp as per PM finding |
| 11 Sept 2026 | Medium | PX_BF-103 | Decoking follow up BF-103 |
| 10 Sept 2026 | Medium | PX_BF-111 | Peep door broken BF-111 |
| 08 Sept 2026 | Medium | PX_BF-107 | Replace lamp as per PM finding |
| 26 Aug 2026 | Medium | PX_BF-103 | Replace lamp as per PM finding |
Recent goods issues
| Posting date | Qty | Order | Order type |
|---|---|---|---|
| 25 Aug 2026 | 1 | 201000037723 | Corrective |
| 22 Jul 2026 | 1 | 201000031020 | Corrective |
| 19 Apr 2026 | 1 | 201000029249 | Corrective |
| 23 Feb 2026 | 2 | 201000005996 | Corrective |
| 20 Jan 2026 | 9 | 203000022287 | Turnaround |
| 12 Jan 2026 | 1 | 201000032767 | Corrective |
| 19 Dec 2025 | 10 | 201000030487 | Corrective |
| 10 Dec 2025 | 5 | 201000001970 | Corrective |
| 05 Dec 2025 | 5 | 201000002266 | Corrective |
| 05 Dec 2025 | 1 | 201000036590 | Corrective |
| 04 Dec 2025 | 2 | 201000008508 | Corrective |
| 03 Dec 2025 | 1 | 201000027307 | Corrective |
| 17 Nov 2025 | 3 | 201000004355 | Corrective |
| 14 Nov 2025 | 3 | 203000030725 | Turnaround |
| 10 Nov 2025 | 15 | 203000039046 | Turnaround |