Sparely
DU

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

FuncLocCrit.InstalledNotificationsFailures / yr
PX_BF-102
CRACKING FURNACE BF-102
A127128.72
PX_BF-107
CRACKING FURNACE BF-107
A6239.01
PX_HE-974
SLOP OIL CONDENSER
A100.22
PX_HE-995C
FEED TLE
B600.22
PY_HE-965B
RECYCLE ETHANE TLE
B100.22
PX_3/4-LS-10065-A22A-H
PIPE-3/4 FROM HE-1547 TO VD-999
C1200.01
PX_8-QO-5655-A21A
PIPE-8 FROM VD-1822 TO HE-1305B
C1200.01
PX_HE-1554A
SPENT CAUSTIC COOLER
C1200.22
PY_HE-1593C
LEAN AMINE REBOILER
C100.22
UT_HE-536
FLUSHING OIL CONDENSER
C600.22

Lead time and procurement

Lead time 28 ± 19 days (PO history, 12 PO lines) · on-time 42%

PR dateTypeQtyUnit priceDeliveryLead time
25 Aug 2026PR06
Regular replenishment
30Rp 5.3M06 Sept 202612 d
14 Jul 2026PR01
Import / long-lead
38Rp 5.3M23 Aug 202640 d
05 Jul 2026PR03
Regular replenishment
49Rp 5.3M13 Jul 20268 d
27 Jun 2026PR06
Regular replenishment
44Rp 5.0M21 Jul 202624 d
28 May 2026PR03
Regular replenishment
26Rp 5.1M12 Jun 202615 d
25 Apr 2026PR06
Regular replenishment
21Rp 5.2M15 May 202620 d
17 Apr 2026PR06
Regular replenishment
47Rp 5.3M13 May 202626 d
16 Jan 2026PR05
Project / turnaround
14Rp 5.0M15 Feb 202630 d
30 Dec 2025PR04
Regular (other)
36Rp 5.1M21 Jan 202622 d
06 Oct 2025PR03
Regular replenishment
35Rp 5.2M14 Nov 202539 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

DatePriorityFuncLocDescription
24 Sept 2026LowPX_BF-107Install scaffolding at BF-107
23 Sept 2026LowPX_BF-102Replace burner tip BF-102
08 Sept 2026MediumPX_BF-107Replace lamp as per PM finding
07 Sept 2026LowPX_BF-102Thermograph wall BF-102
06 Sept 2026MediumPX_BF-102Decoking follow up BF-102
03 Sept 2026MediumPX_BF-102Replace lamp as per PM finding
30 Aug 2026HighPX_BF-102Painting BF-102
27 Aug 2026MediumPX_BF-102Decoking follow up BF-102
15 Aug 2026MediumPX_BF-107Hot spot at convection BF-107
14 Aug 2026EmergencyPX_BF-102Thermograph wall BF-102

Recent goods issues

Posting dateQtyOrderOrder type
22 Sept 20263201000022167Corrective
25 Jul 20262201000034014Corrective
23 Jul 20261201000001320Corrective
11 Jun 20261201000037853Corrective
19 May 20262201000006755Corrective
19 May 20265201000027299Corrective
12 Feb 20262201000012252Corrective
14 Jan 20262201000036735Corrective
06 Jan 20266201000015180Corrective
29 Dec 20256203000036002Turnaround
15 Dec 20251201000009616Corrective
10 Dec 20251201000033790Corrective
07 Dec 20254201000002161Corrective
05 Dec 20253201000018149Corrective
03 Dec 20251201000032207Corrective