Sparely
DU

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

Material 4100107050 · OIL · Plant 1000

AReduceExcess
Material
4100107050
Category
OIL
Base unit
L
MRP type
Stock Item
Criticality
A (14 of 18 FuncLocs A/B)
Supplier
MITRA SARANA INTERNASIONAL PT
Lead time
28 d · P80 43 d
Unit price
Rp 52,966

Recommendation

  • 1.Forecast 241 L/year: 234 unplanned (recency-weighted compound poisson (own history)) + 7.2 from the maintenance plan.
  • 2.Lead time ~28 days; expected demand during lead time 18.
  • 3.A 100.0% service level gives the lowest holding + downtime-risk cost: reorder at 83, order up to 325.
  • 4.Stock 1,208 exceeds the level to keep (325) by 883.
  • 5.Installed on 18 FuncLoc(s), 14 of them criticality A/B.
  • 6.ML early warning: 99% probability of demand in the next 90 days.
ML early warningLast turnaround used 1Single sourceAbnormal consumptionOpen PO
On hand / on order
1,208 / 1,321
next delivery 06 Oct 2026
Today Min / Max
829 / 1,614
static parameters in BoM
Rec. Min (reorder point)
83
safety stock 65
Rec. Max
325
order qty 242
Service level
100.0%
stockout risk now 0%
Unit price
Rp 52,966
PO history
ML early warning: 99% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 7 issue days in the last 180 days, last issue 21 days ago, 15 failure notifications on its equipment in 90 days, 2 planned jobs in 90 days, 4 PRs in 180 days.

Consumption history and 12-month forecast

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

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

Installed on 18 functional locations

14 with criticality A/B · 18 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_KC-308B
REFLUX BLOWER
A162.28
PX_PP-888A
CONDENSATE PUMP
A161.90
PX_KC-479C
DILUTION STEAM COMPRESSOR
A152.71
PX_KC-279C
C3 RECYCLE COMPRESSOR
A131.43
PY_PP-1056
QUENCH WATER PUMP
A131.05
PX_KC-235D
DEMIN WATER FAN
A121.00
PX_PP-416A
SEAL OIL PUMP
A110.19
PX_PP-645C
LUBE OIL PUMP
A110.19
PX_KC-527
METHANOL BLOWER
A100.57
PX_KC-618B
WASH WATER BLOWER
A100.57
PX_KC-930C
SLOP OIL FAN
A100.57
PX_PP-1099
LUBE OIL PUMP
A100.19

Lead time and procurement

Lead time 28 ± 11 days (PO history, 11 PO lines) · on-time 34%

PR dateTypeQtyUnit priceDeliveryLead time
13 Sept 2026PR03
Regular replenishment
831Rp 55,71413 Oct 2026
open
30 d
12 Sept 2026PR06
Regular replenishment
490Rp 53,23806 Oct 2026
open
24 d
17 Jul 2026PR03
Regular replenishment
726Rp 51,76911 Aug 202625 d
24 Jun 2026PR03
Regular replenishment
307Rp 52,87807 Aug 202644 d
07 Jan 2026PR06
Regular replenishment
588Rp 54,07602 Feb 202626 d
27 Dec 2025PR06
Regular replenishment
815Rp 55,56211 Jan 202615 d
17 Dec 2025PR03
Regular replenishment
502Rp 52,85501 Jan 202615 d
06 Oct 2025PR03
Regular replenishment
767Rp 51,35718 Nov 202543 d
11 Aug 2025PR06
Regular replenishment
801Rp 52,96625 Sept 202545 d
05 Jul 2025PR03
Regular replenishment
557Rp 55,20529 Jul 202524 d

Planned maintenance demand (next 12 months)

DueFuncLocJobQty
01 Dec 2026PX_PP-888ALube oil change0.72
01 Dec 2026PY_PP-1892CLube oil change0.72
31 Dec 2026PX_PP-291DLube oil change0.72
02 Mar 2027PX_PP-888ALube oil change0.72
02 Mar 2027PY_PP-1892CLube oil change0.72
02 Jun 2027PX_PP-888ALube oil change0.72
02 Jun 2027PY_PP-1892CLube oil change0.72
02 Jul 2027PX_PP-291DLube oil change0.72
01 Sept 2027PX_PP-888ALube oil change0.72
01 Sept 2027PY_PP-1892CLube oil change0.72

Recent notifications on its equipment

DatePriorityFuncLocDescription
26 Sept 2026MediumPX_KC-365CKC-365C lube oil filter DP high
23 Sept 2026MediumPX_KC-513KC-513 high vibration
22 Sept 2026MediumPX_PP-888AOil leak at PP-888A bearing housing
10 Sept 2026MediumPX_KC-479CKC-479C bearing temp high
07 Sept 2026MediumPX_KC-513Inspect coupling KC-513
06 Sept 2026MediumPX_KC-308BInstall scaffolding at KC-308B
05 Sept 2026MediumPX_KC-279COverhaul
05 Sept 2026LowPX_KC-513Inspect coupling KC-513
30 Aug 2026MediumPX_KC-513KC-513 high vibration
18 Aug 2026LowPX_KC-479CLeak from packing

Recent goods issues

Posting dateQtyOrderOrder type
10 Sept 20265201000001823Corrective
01 Jul 20261201000011220Corrective
25 Jun 20264201000001753Corrective
05 May 202620201000029703Corrective
22 Apr 20265201000030658Corrective
22 Apr 2026200202000000221Emergency
12 Apr 202620201000035122Corrective
09 Apr 2026200201000008443Corrective
29 Mar 202620201000007321Corrective
13 Feb 20261201000019526Corrective
23 Jan 20264201000038721Corrective
17 Jan 2026200201000029530Corrective
04 Jan 20264201000034723Corrective
03 Jan 20264201000001557Corrective
02 Jan 202620201000023955Corrective