OIL,LUBRICANT,ISO VG 150,SYNTHETIC,20L
Material 4100106999 · OIL · Plant 1000
AReduceExcess
- Material
- 4100106999
- Category
- OIL
- Base unit
- L
- MRP type
- Stock Item
- Criticality
- A (17 of 20 FuncLocs A/B)
- Supplier
- BERKAH LOGAM GLOBAL PT
- Lead time
- 26 d · P80 31 d
- Unit price
- Rp 237,734
Recommendation
- 1.Forecast 436 L/year: 435 unplanned (recency-weighted compound poisson (own history)) + 1.4 from the maintenance plan.
- 2.Lead time ~26 days; expected demand during lead time 31.
- 3.A 100.0% service level gives the lowest holding + downtime-risk cost: reorder at 105, order up to 271.
- 4.Stock 538 exceeds the level to keep (271) by 267.
- 5.Installed on 20 FuncLoc(s), 17 of them criticality A/B.
- 6.ML early warning: 100% probability of demand in the next 90 days.
ML early warningLast turnaround used 241Single sourceAbnormal consumptionOpen POSame description as 1 other material number
On hand / on order
538 / 1,322
next delivery 02 Nov 2026
Today Min / Max
533 / 795
static parameters in BoM
Rec. Min (reorder point)
105
safety stock 74
Rec. Max
271
order qty 166
Service level
100.0%
stockout risk now 0%
Unit price
Rp 237,734
PO history
ML early warning: 100% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 20 issue days in the last 180 days, last issue 25 days ago, 27 failure notifications on its equipment in 90 days, 1 planned jobs in 90 days, 6 PRs in 180 days.
Consumption history and 12-month forecast
Units per month. Turnaround issues (247 units) excluded from the baseline.
Demand pattern Erratic · 52 issue days · 12 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 10.5B/yr in expected downtime and emergency buys. A stockout here stops production with probability 1.07% for ~13 days.
Installed on 20 functional locations
17 with criticality A/B · 20 units installed
| FuncLoc | Crit. | Installed | Notifications | Failures / yr |
|---|---|---|---|---|
| PX_PP-1729A COOLING WATER PUMP | A | 1 | 21 | 7.90 |
| PX_KC-316D METHANOL FAN | A | 1 | 5 | 1.43 |
| PX_KC-479C DILUTION STEAM COMPRESSOR | A | 1 | 5 | 2.71 |
| PX_PP-1530 PROPYLENE PUMP | A | 1 | 4 | 1.47 |
| PX_KC-671D FEED BLOWER | A | 1 | 3 | 1.00 |
| PX_KC-391D QUENCH WATER COMPRESSOR | A | 1 | 2 | 1.43 |
| PX_KC-464A CONDENSATE BLOWER | A | 1 | 2 | 1.43 |
| PY_PP-1862B FLUSHING OIL PUMP | A | 1 | 2 | 0.62 |
| PX_PP-1575A METHANE PUMP | A | 1 | 1 | 0.19 |
| PX_KC-178A QUENCH OIL FAN | A | 1 | 0 | 0.57 |
| PX_KC-621 SEAL OIL FAN | A | 1 | 0 | 0.57 |
| PX_KC-669 DEMIN WATER BLOWER | A | 1 | 0 | 0.57 |
Lead time and procurement
Lead time 26 ± 11 days (PO history, 11 PO lines) · on-time 36%
| PR date | Type | Qty | Unit price | Delivery | Lead time |
|---|---|---|---|---|---|
| 21 Sept 2026 | PR03 Regular replenishment | 1,322 | Rp 237,734 | 02 Nov 2026 open | 42 d |
| 10 Sept 2026 | PR06 Regular replenishment | 662 | Rp 243,869 | 25 Sept 2026 | 15 d |
| 24 Aug 2026 | PR03 Regular replenishment | 1,279 | Rp 238,026 | 21 Sept 2026 | 28 d |
| 19 Jul 2026 | PR03 Regular replenishment | 1,238 | Rp 228,453 | 19 Aug 2026 | 31 d |
| 13 Jul 2026 | PR03 Regular replenishment | 1,180 | Rp 232,012 | 25 Aug 2026 | 43 d |
| 20 Apr 2026 | PR06 Regular replenishment | 746 | Rp 226,126 | 20 May 2026 | 30 d |
| 01 Feb 2026 | PR03 Regular replenishment | 624 | Rp 243,940 | 16 Feb 2026 | 15 d |
| 12 Jan 2026 | PR06 Regular replenishment | 940 | Rp 238,700 | 10 Feb 2026 | 29 d |
| 28 Nov 2025 | PR03 Regular replenishment | 783 | Rp 245,283 | 29 Dec 2025 | 31 d |
| 26 Sept 2025 | PR03 Regular replenishment | 757 | Rp 229,923 | 15 Oct 2025 | 19 d |
Planned maintenance demand (next 12 months)
| Due | FuncLoc | Job | Qty |
|---|---|---|---|
| 01 Dec 2026 | PX_PP-1748 | Lube oil change | 0.72 |
| 02 Jun 2027 | PX_PP-1748 | Lube oil change | 0.72 |
Recent notifications on its equipment
| Date | Priority | FuncLoc | Description |
|---|---|---|---|
| 27 Sept 2026 | Medium | PX_PP-1729A | Install scaffolding at PP-1729A |
| 26 Sept 2026 | Emergency | PX_KC-773A | Inspect coupling KC-773A |
| 21 Sept 2026 | Medium | PX_KC-843 | Painting KC-843 |
| 20 Sept 2026 | Low | PX_PP-1729A | [MSI-B-26-TCT-349] Permanent repair |
| 19 Sept 2026 | Medium | PX_PP-1070B | Leak from packing |
| 16 Sept 2026 | Low | PX_KC-843 | Inspect coupling KC-843 |
| 15 Sept 2026 | Low | PX_KC-773A | Install scaffolding at KC-773A |
| 10 Sept 2026 | Medium | PX_KC-479C | KC-479C bearing temp high |
| 03 Sept 2026 | Medium | PX_PP-1070B | Repair insulation PP-1070B |
| 29 Aug 2026 | Medium | PX_KC-843 | Replace lamp as per PM finding |
Recent goods issues
| Posting date | Qty | Order | Order type |
|---|---|---|---|
| 06 Sept 2026 | 4 | 201000022798 | Corrective |
| 12 Aug 2026 | 5 | 201000006138 | Corrective |
| 31 Jul 2026 | 200 | 201000030384 | Corrective |
| 26 Jul 2026 | 1 | 201000017449 | Corrective |
| 20 Jul 2026 | 20 | 201000017965 | Corrective |
| 13 Jul 2026 | 1 | 209000016630 | Other maintenance |
| 12 Jul 2026 | 200 | 201000010524 | Corrective |
| 06 Jul 2026 | 4 | 209000029244 | Other maintenance |
| 05 Jul 2026 | 200 | 201000038942 | Corrective |
| 30 Jun 2026 | 200 | 201000006875 | Corrective |
| 22 Jun 2026 | 20 | 209000014083 | Other maintenance |
| 19 Jun 2026 | 4 | 201000039950 | Corrective |
| 10 Jun 2026 | 20 | 201000020583 | Corrective |
| 10 Jun 2026 | 1 | 209000008419 | Other maintenance |
| 04 Jun 2026 | 5 | 201000037613 | Corrective |