Sparely
DU

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

FuncLocCrit.InstalledNotificationsFailures / yr
PX_BF-105
CRACKING FURNACE BF-105
A311442.86
PX_BF-106
CRACKING FURNACE BF-106
A128230.86
PX_BF-112
CRACKING FURNACE BF-112
A127327.01
PX_BF-102
CRACKING FURNACE BF-102
A37128.72
PX_BF-103
CRACKING FURNACE BF-103
A33814.58
PX_BF-109
CRACKING FURNACE BF-109
A62911.58
PX_BF-104
CRACKING FURNACE BF-104
A32811.58
PX_BF-107
CRACKING FURNACE BF-107
A3239.01
PX_HE-278D
COOLING WATER TLE
A1293.65
PX_HE-126D
DILUTION STEAM PREHEATER
A351.08
PX_HE-532B
PROPYLENE COOLER
A1241.50
PX_HE-432D
INHIBITOR COOLER
A220.65

Lead time and procurement

Lead time 23 ± 15 days (PO history, 50 PO lines) · on-time 39%

PR dateTypeQtyUnit priceDeliveryLead time
14 Sept 2026PR03
Regular replenishment
163Rp 834,33203 Oct 2026
open
19 d
03 Sept 2026PR03
Regular replenishment
469Rp 865,27522 Sept 202619 d
19 Aug 2026PR03
Regular replenishment
169Rp 841,70425 Aug 20266 d
14 Aug 2026PR03
Regular replenishment
404Rp 810,91226 Aug 202612 d
20 Jun 2026PR05
Project / turnaround
216Rp 809,19307 Aug 202648 d
21 May 2026PR03
Regular replenishment
329Rp 867,57111 Jun 202621 d
29 Apr 2026PR03
Regular replenishment
388Rp 814,75823 May 202624 d
22 Apr 2026PR06
Regular replenishment
314Rp 832,07828 Apr 20266 d
20 Apr 2026PR03
Regular replenishment
328Rp 851,68729 Apr 20269 d
17 Apr 2026PR03
Regular replenishment
340Rp 877,27616 May 202629 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
30 Sept 2026LowPX_BF-103Leak from packing
30 Sept 2026MediumPX_BF-112Install cover plate BF-112
29 Sept 2026HighPX_BF-105Repair refractory crack BF-105
29 Sept 2026MediumPX_BF-106Decoking follow up BF-106
29 Sept 2026MediumPX_BF-106Decoking follow up BF-106
29 Sept 2026LowPX_BF-112Painting BF-112
28 Sept 2026LowPX_BF-106Peep door broken BF-106
27 Sept 2026MediumPX_BF-112Repair insulation BF-112
27 Sept 2026MediumPX_HE-532BReplace lamp as per PM finding
25 Sept 2026MediumPX_BF-108Repair refractory crack BF-108

Recent goods issues

Posting dateQtyOrderOrder type
29 Sept 20263203000034378Turnaround
27 Sept 20261201000028432Corrective
25 Sept 20264201000015740Corrective
25 Sept 20266209000029477Other maintenance
22 Sept 20264201000037585Corrective
18 Sept 20264201000030125Corrective
13 Sept 20262201000010235Corrective
13 Sept 20263201000017566Corrective
13 Sept 20261201000034185Corrective
11 Sept 20262204000013108Preventive
10 Sept 20265204000013108Preventive
06 Sept 20262201000009852Corrective
05 Sept 20264201000021947Corrective
04 Sept 20262206000018039Other maintenance
04 Sept 20261206000018039Other maintenance