Sparely
DU

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

FuncLocCrit.InstalledNotificationsFailures / yr
PX_BF-103
CRACKING FURNACE BF-103
A13814.58
PX_BF-107
CRACKING FURNACE BF-107
A12239.01
PX_BF-111
CRACKING FURNACE BF-111
A2239.01
PX_HE-1034A
SLOP OIL REBOILER
A120.65
PX_HE-1919A
QUENCH WATER CONDENSER
B200.22
PX_3/4-CW-7128-C11A-H
PIPE-3/4 FROM PP-818 TO PP-1404A
C600.01
PY_HE-1775A
QUENCH OIL PREHEATER
C100.22

Lead time and procurement

Lead time 57 ± 37 days (PO history, 14 PO lines) · on-time 42%

PR dateTypeQtyUnit priceDeliveryLead time
26 Aug 2026PR03
Regular replenishment
13Rp 497,80912 Oct 2026
open
47 d
21 Jul 2026PR03
Regular replenishment
29Rp 480,05313 Sept 202654 d
11 Apr 2026PR06
Regular replenishment
14Rp 468,88818 May 202637 d
31 Mar 2026PR01
Import / long-lead
29Rp 477,93608 Sept 2026161 d
02 Mar 2026PR03
Regular replenishment
37Rp 468,69316 Apr 202645 d
25 Feb 2026PR03
Regular replenishment
39Rp 491,57120 Mar 202623 d
27 Dec 2025PR03
Regular replenishment
13Rp 464,29619 Jan 202623 d
11 Nov 2025PR03
Regular replenishment
20Rp 462,81430 Jan 202680 d
08 Nov 2025PR03
Regular replenishment
16Rp 467,80301 Jan 202654 d
15 Sept 2025PR03
Regular replenishment
32Rp 483,83626 Dec 2025102 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
24 Sept 2026LowPX_BF-107Install scaffolding at BF-107
22 Sept 2026MediumPX_BF-111Install cover plate BF-111
20 Sept 2026MediumPX_BF-103Leak from packing
19 Sept 2026LowPX_BF-103Leak from packing
15 Sept 2026MediumPX_BF-103Replace lamp as per PM finding
11 Sept 2026MediumPX_BF-103Decoking follow up BF-103
10 Sept 2026MediumPX_BF-111Peep door broken BF-111
08 Sept 2026MediumPX_BF-107Replace lamp as per PM finding
26 Aug 2026MediumPX_BF-103Replace lamp as per PM finding

Recent goods issues

Posting dateQtyOrderOrder type
25 Aug 20261201000037723Corrective
22 Jul 20261201000031020Corrective
19 Apr 20261201000029249Corrective
23 Feb 20262201000005996Corrective
20 Jan 20269203000022287Turnaround
12 Jan 20261201000032767Corrective
19 Dec 202510201000030487Corrective
10 Dec 20255201000001970Corrective
05 Dec 20255201000002266Corrective
05 Dec 20251201000036590Corrective
04 Dec 20252201000008508Corrective
03 Dec 20251201000027307Corrective
17 Nov 20253201000004355Corrective
14 Nov 20253203000030725Turnaround
10 Nov 202515203000039046Turnaround