Sparely
DU

OIL,LUBRICANT,ISO VG 100,SYNTHETIC,209L

Material 4100107186 · OIL · Plant 1000

AReduceExcess
Material
4100107186
Category
OIL
Base unit
L
MRP type
Stock Item
Criticality
A (3 of 3 FuncLocs A/B)
Supplier
No PO history
Lead time
24 d · P80 36 d
Unit price
Rp 157,448 (est.)

Recommendation

  • 1.Forecast 62 L/year: 58 unplanned (recency-weighted compound poisson (own history)) + 4.3 from the maintenance plan.
  • 2.Lead time ~24 days; expected demand during lead time 3.8.
  • 3.A 100.0% service level gives the lowest holding + downtime-risk cost: reorder at 36, order up to 99.
  • 4.Stock 307 exceeds the level to keep (99) by 208.
  • 5.Installed on 3 FuncLoc(s), 3 of them criticality A/B.
  • 6.ML early warning: 61% probability of demand in the next 90 days.
ML early warningLast turnaround used 4Abnormal consumptionPrice estimatedLead time estimated
On hand / on order
307 / 0
no open PO
Today Min / Max
81 / 246
static parameters in BoM
Rec. Min (reorder point)
36
safety stock 33
Rec. Max
99
order qty 63
Service level
100.0%
stockout risk now 0%
Unit price
Rp 157,448
Category + unit estimate
ML early warning: 61% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 3 issue days in the last 180 days, last issue 118 days ago, 2 failure notifications on its equipment in 90 days, 2 planned jobs in 90 days, 0 PRs in 180 days.

Consumption history and 12-month forecast

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

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

Installed on 3 functional locations

3 with criticality A/B · 3 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-888A
CONDENSATE PUMP
A161.90
PX_PP-1882C
RECYCLE ETHANE PUMP
A120.62
PX_PP-166A
SPENT CAUSTIC PUMP
A110.19

Lead time and procurement

Lead time 24 ± 13 days (Category estimate, 0 PO lines) · on-time –

No purchase history: price and lead time are estimated from parts of the same category.

Planned maintenance demand (next 12 months)

DueFuncLocJobQty
01 Dec 2026PX_PP-888ALube oil change0.72
01 Dec 2026PX_PP-1882CLube oil change0.72
02 Mar 2027PX_PP-888ALube oil change0.72
02 Jun 2027PX_PP-888ALube oil change0.72
02 Jun 2027PX_PP-1882CLube oil change0.72
01 Sept 2027PX_PP-888ALube oil change0.72

Recent notifications on its equipment

DatePriorityFuncLocDescription
22 Sept 2026MediumPX_PP-888AOil leak at PP-888A bearing housing
16 Aug 2026HighPX_PP-888APP-888A abnormal noise
26 May 2026MediumPX_PP-888APP-888A abnormal noise
25 Apr 2026LowPX_PP-888AInstall scaffolding at PP-888A
09 Dec 2025MediumPX_PP-1882C[MSI-B-25-LFS-262/M] Replace line
02 Dec 2025MediumPX_PP-888APP-888A discharge pressure low
20 May 2025MediumPX_PP-166AOil leak at PP-166A bearing housing
16 May 2025LowPX_PP-1882COverhaul PP-1882C
02 May 2025LowPX_PP-888AReplace bearing PP-888A

Recent goods issues

Posting dateQtyOrderOrder type
05 Jun 202620201000010759Corrective
30 May 20265201000020115Corrective
23 Apr 20261201000002634Corrective
01 Feb 20265201000017810Corrective
02 Jan 2026200201000024626Corrective
07 Dec 20254201000015109Corrective
27 Nov 20254203000032713Turnaround
12 Sept 2025200201000023534Corrective
26 Aug 20255203000006603Turnaround
09 Aug 202520201000032179Corrective
20 Jul 20251201000019985Corrective
25 Jun 202520203000034428Turnaround