Sparely
DU

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

Material 4100107061 · OIL · Plant 1000

AReorderCriticalStockout
Material
4100107061
Category
OIL
Base unit
L
MRP type
Stock Item
Criticality
A (11 of 11 FuncLocs A/B)
Supplier
GEMILANG SUPLINDO SENTOSA PT
Lead time
19 d · P80 20 d
Unit price
Rp 139,166

Recommendation

  • 1.Forecast 134 L/year: 129 unplanned (recency-weighted compound poisson (own history)) + 5.0 from the maintenance plan.
  • 2.Lead time ~19 days; expected demand during lead time 6.6.
  • 3.A 100.0% service level gives the lowest holding + downtime-risk cost: reorder at 39, order up to 160.
  • 4.On hand 0 + on order 0 is at or below the reorder point: order 160 now.
  • 5.Installed on 11 FuncLoc(s), 11 of them criticality A/B.
  • 6.ML early warning: 98% probability of demand in the next 90 days.
Proposed purchase requisition
160 L
Rp 22.3M · order by 01 Oct 2026
Expected arrival ≈ 19 days
ML early warningLast turnaround used 4Single sourceAbnormal consumption
On hand / on order
0 / 0
no open PO
Today Min / Max
119 / 312
static parameters in BoM
Rec. Min (reorder point)
39
safety stock 33
Rec. Max
160
order qty 121
Service level
100.0%
stockout risk now 57%
Unit price
Rp 139,166
PO history
ML early warning: 98% 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 6 days ago, 6 failure notifications on its equipment in 90 days, 2 planned jobs in 90 days, 1 PRs in 180 days.

Consumption history and 12-month forecast

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

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

Installed on 11 functional locations

11 with criticality A/B · 11 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_KC-854C
FEED FAN
A172.28
PX_PP-1701B
QUENCH OIL PUMP
A131.05
PX_KC-235D
DEMIN WATER FAN
A121.00
PX_KC-435A
FUEL OIL AIR COMPRESSOR
A121.00
PX_PP-1170
RECYCLE ETHANE PUMP
A120.62
PX_PP-956A
CAUSTIC PUMP
A100.19
PX_PP-1070B
FUEL OIL PUMP
B182.76
PX_PP-1905A
FLUSHING OIL PUMP
B141.47
PX_PP-389
FLUSHING OIL PUMP
B120.62
PX_PP-1282
BOTTOM PUMP
B110.19
PX_PP-123
LEAN AMINE PUMP
B100.19

Lead time and procurement

Lead time 19 ± 7 days (PO history, 11 PO lines) · on-time 39%

PR dateTypeQtyUnit priceDeliveryLead time
26 Jul 2026PR03
Regular replenishment
398Rp 134,34510 Aug 202615 d
30 Mar 2026PR03
Regular replenishment
264Rp 139,16619 Apr 202620 d
07 Mar 2026PR06
Regular replenishment
269Rp 140,33318 Mar 202611 d
06 Mar 2026PR03
Regular replenishment
355Rp 135,68022 Mar 202616 d
27 Feb 2026PR03
Regular replenishment
366Rp 135,25222 Mar 202623 d
25 Feb 2026PR06
Regular replenishment
292Rp 140,88310 Mar 202613 d
07 Jan 2026PR03
Regular replenishment
308Rp 137,98501 Feb 202625 d
12 Sept 2025PR03
Regular replenishment
336Rp 141,62226 Sept 202514 d
25 Jul 2025PR06
Regular replenishment
269Rp 143,21806 Aug 202512 d
08 Jun 2025PR03
Regular replenishment
301Rp 133,43027 Jun 202519 d

Planned maintenance demand (next 12 months)

DueFuncLocJobQty
01 Dec 2026PX_PP-1282Lube oil change0.72
01 Dec 2026PX_PP-1170Lube oil change0.72
02 Mar 2027PX_PP-1282Lube oil change0.72
02 Apr 2027PX_PP-1170Lube oil change0.72
02 Jun 2027PX_PP-1282Lube oil change0.72
02 Aug 2027PX_PP-1170Lube oil change0.72
01 Sept 2027PX_PP-1282Lube oil change0.72

Recent notifications on its equipment

DatePriorityFuncLocDescription
22 Sept 2026MediumPX_KC-854COverhaul
19 Sept 2026MediumPX_PP-1070BLeak from packing
03 Sept 2026MediumPX_PP-1070BRepair insulation PP-1070B
30 Aug 2026LowPX_PP-1170PP-1170 seal leak
06 Aug 2026MediumPX_PP-1905APP-1905A abnormal noise
29 Jul 2026MediumPX_KC-854CInstall scaffolding at KC-854C
17 Jul 2026LowPX_KC-854CPainting KC-854C
15 Jul 2026MediumPX_PP-1701BInstall cover plate for MCP cracking
08 Jun 2026MediumPX_PP-1070BOverhaul PP-1070B
04 Jun 2026MediumPX_PP-1070BReplace bearing PP-1070B

Recent goods issues

Posting dateQtyOrderOrder type
25 Sept 202620209000029477Other maintenance
22 Sept 2026200201000004407Corrective
12 Sept 20264203000027454Turnaround
28 Aug 202620201000023879Corrective
27 Jul 202620201000030925Corrective
08 Jul 20265209000012005Other maintenance
17 Jun 20264209000016742Other maintenance
04 Mar 202620201000026477Corrective
11 Jan 20261201000037096Corrective
03 Jan 2026200201000038837Corrective
26 Dec 202520201000017349Corrective
21 Dec 20254201000001122Corrective
19 Dec 20251201000031381Corrective
09 Dec 20254201000017463Corrective
08 Dec 202520201000025971Corrective
Sparely