Sparely
DU

OIL,LUBRICANT,ISO VG 68,SYNTHETIC,1L

Material 4100106994 · OIL · Plant 1000

AReduceExcess
Material
4100106994
Category
OIL
Base unit
L
MRP type
Stock Item
Criticality
A (8 of 15 FuncLocs A/B)
Supplier
GEMILANG TEKNIK LESTARI PT
Lead time
26 d · P80 32 d
Unit price
Rp 139,464

Recommendation

  • 1.Forecast 532 L/year: 527 unplanned (recency-weighted compound poisson (own history)) + 4.3 from the maintenance plan.
  • 2.Lead time ~26 days; expected demand during lead time 37.
  • 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 147, order up to 387.
  • 4.Stock 684 exceeds the level to keep (439) by 245; the level includes the 439 used in the last turnaround.
  • 5.Installed on 15 FuncLoc(s), 8 of them criticality A/B.
  • 6.ML early warning: 100% probability of demand in the next 90 days.
ML early warningLast turnaround used 439Single sourceAbnormal consumptionOpen PO
On hand / on order
684 / 1,592
next delivery 02 Oct 2026
Today Min / Max
517 / 847
static parameters in BoM
Rec. Min (reorder point)
147
safety stock 110
Rec. Max
387
order qty 240
Service level
99.9%
stockout risk now 0%
Unit price
Rp 139,464
PO history
ML early warning: 100% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 23 issue days in the last 180 days, last issue 7 days ago, 12 failure notifications on its equipment in 90 days, 2 planned jobs in 90 days, 15 PRs in 180 days.

Consumption history and 12-month forecast

Units per month. Turnaround issues (498 units) excluded from the baseline.

Demand pattern Erratic · 76 issue days · 18 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 13.5B/yr in expected downtime and emergency buys. A stockout here stops production with probability 1.07% for ~13 days.

Installed on 15 functional locations

8 with criticality A/B · 15 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_KC-752A
CONDENSATE BLOWER
A141.85
PX_KC-155D
CAUSTIC BLOWER
A100.57
PX_KC-250D
PROPYLENE FAN
A100.57
PX_PP-410
SLOP OIL PUMP
B183.19
PX_PP-866A
METHANE PUMP
B141.90
PX_PP-1025B
CAUSTIC PUMP
B131.05
PX_PP-805B
CAUSTIC PUMP
B131.47
PX_PP-1628A
ETHYLENE PUMP
B100.19
PX_PP-720
ETHYLENE PUMP
C110.62
PX_KC-843
FUEL OIL COMPRESSOR
S1218.28
PX_KC-422A
C4 PRODUCT BLOWER
S162.71
PX_KC-150A
HYDROGEN FAN
S121.00

Lead time and procurement

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

PR dateTypeQtyUnit priceDeliveryLead time
10 Sept 2026PR03
Regular replenishment
1,592Rp 141,40602 Oct 2026
open
22 d
31 Aug 2026PR06
Regular replenishment
850Rp 144,91418 Sept 202618 d
05 Aug 2026PR03
Regular replenishment
2,072Rp 143,82712 Sept 202638 d
30 Jul 2026PR05
Project / turnaround
1,867Rp 136,95001 Sept 202633 d
18 Jul 2026PR03
Regular replenishment
1,768Rp 142,60212 Aug 202625 d
16 Jun 2026PR03
Regular replenishment
1,807Rp 136,12603 Jul 202617 d
12 Jun 2026PR06
Regular replenishment
2,016Rp 135,12122 Jun 202610 d
07 Jun 2026PR01
Import / long-lead
1,815Rp 136,36726 Aug 202680 d
12 May 2026PR06
Regular replenishment
1,164Rp 141,71120 May 20268 d
07 May 2026PR05
Project / turnaround
1,775Rp 140,44703 Jun 202627 d

Planned maintenance demand (next 12 months)

DueFuncLocJobQty
01 Nov 2026PX_PP-720Lube oil change0.72
01 Dec 2026PX_PP-1025BLube oil change0.72
03 Mar 2027PX_PP-720Lube oil change0.72
02 Apr 2027PX_PP-1025BLube oil change0.72
03 Jul 2027PX_PP-720Lube oil change0.72
02 Aug 2027PX_PP-1025BLube oil change0.72

Recent notifications on its equipment

DatePriorityFuncLocDescription
24 Sept 2026EmergencyPX_PP-410Install cover plate for MCP cracking
21 Sept 2026MediumPX_KC-843Painting KC-843
16 Sept 2026LowPX_KC-843Inspect coupling KC-843
02 Sept 2026MediumPX_PP-1768CReplace lamp as per PM finding
29 Aug 2026MediumPX_KC-843Replace lamp as per PM finding
26 Aug 2026MediumPX_KC-843[MSI-B-26-RLH-211] Permanent repair
14 Aug 2026MediumPX_KC-843KC-843 lube oil filter DP high
06 Aug 2026MediumPX_KC-843Replace lamp as per PM finding
02 Aug 2026EmergencyPX_KC-843[MSI-B-26-KRX-321] Permanent repair
20 Jul 2026MediumPX_PP-805BOverhaul PP-805B

Recent goods issues

Posting dateQtyOrderOrder type
30 Sept 20264203000029840Turnaround
24 Sept 20264209000029477Other maintenance
19 Sept 20261201000003432Corrective
17 Sept 202620201000022353Corrective
02 Sept 20261204000034612Preventive
30 Aug 20265203000017844Turnaround
26 Aug 20261201000033360Corrective
22 Aug 2026200201000023798Corrective
04 Aug 202620204000027988Preventive
29 Jul 202620203000004330Turnaround
25 Jul 20264201000037006Corrective
05 Jul 2026200201000029242Corrective
22 Jun 20261209000014083Other maintenance
19 Jun 20261209000014083Other maintenance
18 Jun 2026200201000011352Corrective
Sparely