Sparely
DU

OIL,LUBRICANT,ISO VG 32,MINERAL,1L

Material 4100107132 · OIL · Plant 1000

AReduceExcess
Material
4100107132
Category
OIL
Base unit
L
MRP type
Stock Item
Criticality
A (7 of 12 FuncLocs A/B)
Supplier
GEMILANG ELEKTRIK SENTOSA PT
Lead time
36 d · P80 52 d
Unit price
Rp 85,591

Recommendation

  • 1.Forecast 197 L/year: 196 unplanned (recency-weighted compound poisson (own history)) + 1.4 from the maintenance plan.
  • 2.Lead time ~36 days; expected demand during lead time 19.
  • 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 80, order up to 266.
  • 4.Stock 730 exceeds the level to keep (266) by 464.
  • 5.Installed on 12 FuncLoc(s), 7 of them criticality A/B.
  • 6.ML early warning: 99% probability of demand in the next 90 days.
ML early warningLast turnaround used 21Single sourceAbnormal consumptionOpen POSame description as 1 other material number
On hand / on order
730 / 531
next delivery 02 Oct 2026
Today Min / Max
147 / 378
static parameters in BoM
Rec. Min (reorder point)
80
safety stock 61
Rec. Max
266
order qty 186
Service level
99.9%
stockout risk now 0%
Unit price
Rp 85,591
PO history
ML early warning: 99% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 6 issue days in the last 180 days, last issue 1 days ago, 9 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 (21 units) excluded from the baseline.

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

Installed on 12 functional locations

7 with criticality A/B · 12 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-790A
CHARGE GAS PUMP
A172.76
PX_KC-752A
CONDENSATE BLOWER
A141.85
PX_PP-1801A
DEMIN WATER PUMP
A110.19
PX_KC-155D
CAUSTIC BLOWER
A100.57
PX_PP-474A
LUBE OIL PUMP
B120.62
PX_PP-1678A
METHANE PUMP
B110.19
PX_PP-1733A
RICH AMINE PUMP
B100.19
PY_PP-315A
HYDROGEN PUMP
C151.90
PX_PP-367A
REFLUX PUMP
C100.19
PX_KC-538
REFLUX BLOWER
S1124.85
PX_KC-422A
C4 PRODUCT BLOWER
S162.71
PX_KC-210D
ETHYLENE BLOWER
S100.57

Lead time and procurement

Lead time 36 ± 22 days (PO history, 11 PO lines) · on-time 36%

PR dateTypeQtyUnit priceDeliveryLead time
21 Aug 2026PR06
Regular replenishment
531Rp 84,78602 Oct 2026
open
42 d
28 Apr 2026PR03
Regular replenishment
567Rp 87,61016 May 202618 d
16 Apr 2026PR03
Regular replenishment
622Rp 82,84222 May 202636 d
13 Nov 2025PR03
Regular replenishment
404Rp 86,51409 Dec 202526 d
29 Oct 2025PR06
Regular replenishment
448Rp 86,53503 Feb 202697 d
29 Sept 2025PR04
Regular (other)
382Rp 82,95128 Oct 202529 d
13 Aug 2025PR06
Regular replenishment
550Rp 82,57226 Aug 202513 d
05 Aug 2025PR03
Regular replenishment
758Rp 85,59105 Sept 202531 d
25 Jul 2025PR03
Regular replenishment
983Rp 83,95119 Aug 202525 d
10 Jul 2025PR04
Regular (other)
443Rp 87,06008 Sept 202560 d

Planned maintenance demand (next 12 months)

DueFuncLocJobQty
02 Feb 2027PX_PP-367ALube oil change0.72
04 Aug 2027PX_PP-367ALube oil change0.72

Recent notifications on its equipment

DatePriorityFuncLocDescription
24 Sept 2026EmergencyPX_KC-538KC-538 high vibration
23 Sept 2026MediumPX_PP-790APP-790A abnormal noise
16 Sept 2026EmergencyPX_KC-538Leak from packing
01 Sept 2026MediumPX_KC-538KC-538 lube oil filter DP high
01 Sept 2026MediumPX_KC-538KC-538 high vibration
03 Aug 2026MediumPY_PP-315A[MSI-B-26-CTF-281] Permanent repair
27 Jul 2026MediumPX_PP-790AOil leak at PP-790A bearing housing
23 Jul 2026HighPX_PP-790APP-790A seal leak
08 Jul 2026MediumPX_KC-422AKC-422A high vibration
11 Jun 2026MediumPX_KC-538Leak from packing

Recent goods issues

Posting dateQtyOrderOrder type
30 Sept 2026200201000000813Corrective
26 Jul 20261201000027799Corrective
31 May 20265201000020779Corrective
30 May 20261201000020779Corrective
21 May 20264201000012434Corrective
20 Apr 2026200201000011242Corrective
26 Jan 2026200201000001593Corrective
23 Jan 2026200201000002546Corrective
15 Jan 2026200201000029326Corrective
26 Dec 20251201000005910Corrective
23 Dec 20255201000008440Corrective
23 Dec 202520203000001878Turnaround
15 Dec 20255201000020418Corrective
13 Dec 20255201000012757Corrective
04 Dec 20254201000021141Corrective