Sparely
DU

OIL,LUBRICANT,ISO VG 46,MINERAL,20L

Material 4100107205 · OIL · Plant 1000

CReduceExcess
Material
4100107205
Category
OIL
Base unit
L
MRP type
Stock Item
Criticality
C (0 of 4 FuncLocs A/B)
Supplier
DUTA ENERGI ABADI PT
Lead time
44 d · P80 46 d
Unit price
Rp 226,686

Recommendation

  • 1.Forecast 386 L/year: 386 unplanned (recency-weighted compound poisson (own history)).
  • 2.Lead time ~44 days; expected demand during lead time 46.
  • 3.A 76.3% service level gives the lowest holding + downtime-risk cost: reorder at 50, order up to 210.
  • 4.Stock 417 exceeds the level to keep (210) by 207.
  • 5.ML early warning: 89% probability of demand in the next 90 days.
ML early warningSingle sourceAbnormal consumption
On hand / on order
417 / 0
no open PO
Today Min / Max
194 / 469
static parameters in BoM
Rec. Min (reorder point)
50
safety stock 4
Rec. Max
210
order qty 160
Service level
76.3%
stockout risk now 0%
Unit price
Rp 226,686
PO history
ML early warning: 89% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 4 issue days in the last 180 days, last issue 12 days ago, 0 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 1 PRs in 180 days.

Consumption history and 12-month forecast

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

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

Installed on 4 functional locations

0 with criticality A/B · 4 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-1782A
BFW PUMP
C120.62
PY_PP-1800A
DEMIN WATER PUMP
C100.19
PX_KC-236B
DILUTION STEAM FAN
S110.57
PX_KC-293B
C4 PRODUCT COMPRESSOR
S100.57

Lead time and procurement

Lead time 44 ± 31 days (PO history, 6 PO lines) · on-time 42%

PR dateTypeQtyUnit priceDeliveryLead time
30 Jul 2026PR03
Regular replenishment
463Rp 231,13707 Sept 202639 d
30 Sept 2025PR03
Regular replenishment
154Rp 227,95709 Feb 2026132 d
24 Jun 2025PR03
Regular replenishment
325Rp 230,04209 Aug 202546 d
22 Jun 2025PR03
Regular replenishment
226Rp 225,41431 Jul 202539 d
17 Jun 2025PR03
Regular replenishment
507Rp 213,47928 Jul 202541 d
30 May 2025PR06
Regular replenishment
281Rp 215,36722 Jun 202523 d

Planned maintenance demand (next 12 months)

No part-consuming maintenance job uses this part in the next 12 months.

Recent notifications on its equipment

DatePriorityFuncLocDescription
27 Sept 2025MediumPX_PP-1782ALeak from packing
07 May 2025LowPX_PP-1782ALeak from packing
06 May 2025MediumPX_KC-236BPSM25/Install scaffolding at KC-236B

Recent goods issues

Posting dateQtyOrderOrder type
19 Sept 20264201000033682Corrective
27 Jul 20261201000005182Corrective
11 May 2026200201000031468Corrective
13 Apr 20261201000013543Corrective
07 Feb 202620201000015186Corrective
22 Jan 202620201000028010Corrective
26 Dec 20254201000002958Corrective
20 Dec 2025200201000016591Corrective
12 Dec 2025200201000008455Corrective
17 Nov 2025200201000039953Corrective
23 Aug 202520203000020904Turnaround
07 Jul 20255209000008579Other maintenance
30 Jun 20251209000008119Other maintenance
02 Jun 2025200201000035755Corrective