Sparely
DU

OIL,LUBRICANT,ISO VG 150,SYNTHETIC,20L

Material 4100106999 · OIL · Plant 1000

AReduceExcess
Material
4100106999
Category
OIL
Base unit
L
MRP type
Stock Item
Criticality
A (17 of 20 FuncLocs A/B)
Supplier
BERKAH LOGAM GLOBAL PT
Lead time
26 d · P80 31 d
Unit price
Rp 237,734

Recommendation

  • 1.Forecast 436 L/year: 435 unplanned (recency-weighted compound poisson (own history)) + 1.4 from the maintenance plan.
  • 2.Lead time ~26 days; expected demand during lead time 31.
  • 3.A 100.0% service level gives the lowest holding + downtime-risk cost: reorder at 105, order up to 271.
  • 4.Stock 538 exceeds the level to keep (271) by 267.
  • 5.Installed on 20 FuncLoc(s), 17 of them criticality A/B.
  • 6.ML early warning: 100% probability of demand in the next 90 days.
ML early warningLast turnaround used 241Single sourceAbnormal consumptionOpen POSame description as 1 other material number
On hand / on order
538 / 1,322
next delivery 02 Nov 2026
Today Min / Max
533 / 795
static parameters in BoM
Rec. Min (reorder point)
105
safety stock 74
Rec. Max
271
order qty 166
Service level
100.0%
stockout risk now 0%
Unit price
Rp 237,734
PO history
ML early warning: 100% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 20 issue days in the last 180 days, last issue 25 days ago, 27 failure notifications on its equipment in 90 days, 1 planned jobs in 90 days, 6 PRs in 180 days.

Consumption history and 12-month forecast

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

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

Installed on 20 functional locations

17 with criticality A/B · 20 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-1729A
COOLING WATER PUMP
A1217.90
PX_KC-316D
METHANOL FAN
A151.43
PX_KC-479C
DILUTION STEAM COMPRESSOR
A152.71
PX_PP-1530
PROPYLENE PUMP
A141.47
PX_KC-671D
FEED BLOWER
A131.00
PX_KC-391D
QUENCH WATER COMPRESSOR
A121.43
PX_KC-464A
CONDENSATE BLOWER
A121.43
PY_PP-1862B
FLUSHING OIL PUMP
A120.62
PX_PP-1575A
METHANE PUMP
A110.19
PX_KC-178A
QUENCH OIL FAN
A100.57
PX_KC-621
SEAL OIL FAN
A100.57
PX_KC-669
DEMIN WATER BLOWER
A100.57

Lead time and procurement

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

PR dateTypeQtyUnit priceDeliveryLead time
21 Sept 2026PR03
Regular replenishment
1,322Rp 237,73402 Nov 2026
open
42 d
10 Sept 2026PR06
Regular replenishment
662Rp 243,86925 Sept 202615 d
24 Aug 2026PR03
Regular replenishment
1,279Rp 238,02621 Sept 202628 d
19 Jul 2026PR03
Regular replenishment
1,238Rp 228,45319 Aug 202631 d
13 Jul 2026PR03
Regular replenishment
1,180Rp 232,01225 Aug 202643 d
20 Apr 2026PR06
Regular replenishment
746Rp 226,12620 May 202630 d
01 Feb 2026PR03
Regular replenishment
624Rp 243,94016 Feb 202615 d
12 Jan 2026PR06
Regular replenishment
940Rp 238,70010 Feb 202629 d
28 Nov 2025PR03
Regular replenishment
783Rp 245,28329 Dec 202531 d
26 Sept 2025PR03
Regular replenishment
757Rp 229,92315 Oct 202519 d

Planned maintenance demand (next 12 months)

DueFuncLocJobQty
01 Dec 2026PX_PP-1748Lube oil change0.72
02 Jun 2027PX_PP-1748Lube oil change0.72

Recent notifications on its equipment

DatePriorityFuncLocDescription
27 Sept 2026MediumPX_PP-1729AInstall scaffolding at PP-1729A
26 Sept 2026EmergencyPX_KC-773AInspect coupling KC-773A
21 Sept 2026MediumPX_KC-843Painting KC-843
20 Sept 2026LowPX_PP-1729A[MSI-B-26-TCT-349] Permanent repair
19 Sept 2026MediumPX_PP-1070BLeak from packing
16 Sept 2026LowPX_KC-843Inspect coupling KC-843
15 Sept 2026LowPX_KC-773AInstall scaffolding at KC-773A
10 Sept 2026MediumPX_KC-479CKC-479C bearing temp high
03 Sept 2026MediumPX_PP-1070BRepair insulation PP-1070B
29 Aug 2026MediumPX_KC-843Replace lamp as per PM finding

Recent goods issues

Posting dateQtyOrderOrder type
06 Sept 20264201000022798Corrective
12 Aug 20265201000006138Corrective
31 Jul 2026200201000030384Corrective
26 Jul 20261201000017449Corrective
20 Jul 202620201000017965Corrective
13 Jul 20261209000016630Other maintenance
12 Jul 2026200201000010524Corrective
06 Jul 20264209000029244Other maintenance
05 Jul 2026200201000038942Corrective
30 Jun 2026200201000006875Corrective
22 Jun 202620209000014083Other maintenance
19 Jun 20264201000039950Corrective
10 Jun 202620201000020583Corrective
10 Jun 20261209000008419Other maintenance
04 Jun 20265201000037613Corrective