Sparely
DU

OIL,LUBRICANT,ISO VG 100,MINERAL,5L

Material 4100106982 · OIL · Plant 1000

AReduceExcess
Material
4100106982
Category
OIL
Base unit
L
MRP type
Stock Item
Criticality
A (35 of 52 FuncLocs A/B)
Supplier
RAJAWALI TEKNIK PRATAMA PT
Lead time
23 d · P80 33 d
Unit price
Rp 232,945

Recommendation

  • 1.Forecast 1,057 L/year: 1,036 unplanned (recency-weighted compound poisson (own history)) + 21 from the maintenance plan.
  • 2.Lead time ~23 days; expected demand during lead time 66.
  • 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 221, order up to 482.
  • 4.Stock 4,111 exceeds the level to keep (1,515) by 2,596; the level includes the 1,515 used in the last turnaround.
  • 5.Installed on 52 FuncLoc(s), 35 of them criticality A/B.
  • 6.ML early warning: 100% probability of demand in the next 90 days.
ML early warningLast turnaround used 1,515Single sourceAbnormal consumption
On hand / on order
4,111 / 0
no open PO
Today Min / Max
1,508 / 3,344
static parameters in BoM
Rec. Min (reorder point)
221
safety stock 155
Rec. Max
482
order qty 261
Service level
99.9%
stockout risk now 0%
Unit price
Rp 232,945
PO history
ML early warning: 100% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 42 issue days in the last 180 days, last issue 9 days ago, 37 failure notifications on its equipment in 90 days, 6 planned jobs in 90 days, 12 PRs in 180 days.

Consumption history and 12-month forecast

Units per month. Turnaround issues (1,839 units) excluded from the baseline.

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

Installed on 52 functional locations

35 with criticality A/B · 52 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PY_KC-419A
PROPYLENE FAN
A1195.71
PX_KC-536A
LUBE OIL BLOWER
A1114.42
PX_KC-713B
SPENT CAUSTIC FAN
A163.14
PX_PP-888A
CONDENSATE PUMP
A161.90
PX_KC-316D
METHANOL FAN
A151.43
PX_PP-1619A
LUBE OIL PUMP
A141.47
PX_PP-1752A
SLOP OIL PUMP
A141.90
PX_KC-396
WASH WATER BLOWER
A131.43
PX_KC-778A
CONDENSATE COMPRESSOR
A131.43
PX_PP-1011D
FUEL OIL PUMP
A131.47
PX_PP-1156A
SEAL OIL PUMP
A131.05
PX_PP-283B
BFW PUMP
A131.47

Lead time and procurement

Lead time 23 ± 12 days (PO history, 51 PO lines) · on-time 41%

PR dateTypeQtyUnit priceDeliveryLead time
28 Jul 2026PR03
Regular replenishment
3,580Rp 224,93315 Aug 202618 d
25 Jul 2026PR04
Regular (other)
2,464Rp 231,96302 Sept 202639 d
20 Jul 2026PR03
Regular replenishment
2,862Rp 232,94503 Aug 202614 d
14 Jul 2026PR03
Regular replenishment
2,481Rp 235,91016 Aug 202633 d
11 Jul 2026PR03
Regular replenishment
4,321Rp 220,31717 Aug 202637 d
01 Jul 2026PR03
Regular replenishment
4,261Rp 220,34617 Jul 202616 d
15 Jun 2026PR03
Regular replenishment
3,090Rp 235,42729 Jun 202614 d
13 Jun 2026PR03
Regular replenishment
3,980Rp 227,74518 Jul 202635 d
06 May 2026PR03
Regular replenishment
1,251Rp 220,10610 Jun 202635 d
28 Apr 2026PR03
Regular replenishment
2,141Rp 229,10613 May 202615 d

Planned maintenance demand (next 12 months)

DueFuncLocJobQty
31 Oct 2026PX_PP-1541Lube oil change0.72
30 Nov 2026PX_PP-136BLube oil change0.72
30 Nov 2026PX_PP-1619ALube oil change0.72
01 Dec 2026PX_PP-888ALube oil change0.72
01 Dec 2026PX_PP-283BLube oil change0.72
02 Dec 2026PX_PP-287DLube oil change0.72
01 Jan 2027PX_PP-1269ALube oil change0.72
14 Jan 2027PX_PP-1225BLube oil change0.72
04 Feb 2027PX_PP-1101ALube oil change0.72
01 Mar 2027PX_PP-136BLube oil change0.72
01 Mar 2027PX_PP-1619ALube oil change0.72
02 Mar 2027PX_PP-888ALube oil change0.72
02 Mar 2027PX_PP-283BLube oil change0.72
03 Mar 2027PX_PP-287DLube oil change0.72
02 May 2027PX_PP-1541Lube oil change0.72
03 May 2027PX_PP-1269ALube oil change0.72
16 May 2027PX_PP-1225BLube oil change0.72
01 Jun 2027PX_PP-136BLube oil change0.72
01 Jun 2027PX_PP-1619ALube oil change0.72
02 Jun 2027PX_PP-888ALube oil change0.72
02 Jun 2027PX_PP-283BLube oil change0.72
03 Jun 2027PX_PP-287DLube oil change0.72
06 Aug 2027PX_PP-1101ALube oil change0.72
31 Aug 2027PX_PP-136BLube oil change0.72
31 Aug 2027PX_PP-1619ALube oil change0.72
01 Sept 2027PX_PP-888ALube oil change0.72
01 Sept 2027PX_PP-283BLube oil change0.72
02 Sept 2027PX_PP-287DLube oil change0.72
02 Sept 2027PX_PP-1269ALube oil change0.72
15 Sept 2027PX_PP-1225BLube oil change0.72

Recent notifications on its equipment

DatePriorityFuncLocDescription
30 Sept 2026MediumPX_PP-287DPP-287D seal leak
29 Sept 2026MediumPX_KC-575BInstall scaffolding at KC-575B
29 Sept 2026MediumPX_PP-136BOil leak at PP-136B bearing housing
28 Sept 2026HighPY_KC-419AOverhaul
26 Sept 2026MediumPX_KC-365CKC-365C lube oil filter DP high
26 Sept 2026MediumPX_KC-396Replace lamp as per PM finding
23 Sept 2026MediumPX_KC-513KC-513 high vibration
23 Sept 2026MediumPY_KC-419AInspect coupling KC-419A
22 Sept 2026HighPX_KC-536AOverhaul
22 Sept 2026MediumPX_PP-888AOil leak at PP-888A bearing housing

Recent goods issues

Posting dateQtyOrderOrder type
22 Sept 2026200204000002989Preventive
14 Sept 202620209000036917Other maintenance
12 Sept 20264201000010974Corrective
10 Sept 20265204000032439Preventive
07 Sept 20261201000027042Corrective
06 Sept 20265201000009852Corrective
06 Sept 2026200201000009852Corrective
06 Sept 20261201000023966Corrective
06 Sept 20264203000008243Turnaround
05 Sept 20265201000009201Corrective
31 Aug 202620203000017844Turnaround
29 Aug 202620202000028980Emergency
25 Aug 202620201000024850Corrective
25 Aug 2026200201000024850Corrective
20 Aug 202620201000019311Corrective