OIL,LUBRICANT,ISO VG 32,MINERAL,1L
Material 4100107132 · OIL · Plant 1000
AReduceExcess
- Material
- 4100107132
- Category
- OIL
- Base unit
- L
- MRP type
- Stock Item
- Criticality
- A (7 of 12 FuncLocs A/B)
- Supplier
- GEMILANG ELEKTRIK SENTOSA PT
- Lead time
- 36 d · P80 52 d
- Unit price
- Rp 85,591
Recommendation
- 1.Forecast 197 L/year: 196 unplanned (recency-weighted compound poisson (own history)) + 1.4 from the maintenance plan.
- 2.Lead time ~36 days; expected demand during lead time 19.
- 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 80, order up to 266.
- 4.Stock 730 exceeds the level to keep (266) by 464.
- 5.Installed on 12 FuncLoc(s), 7 of them criticality A/B.
- 6.ML early warning: 99% probability of demand in the next 90 days.
ML early warningLast turnaround used 21Single sourceAbnormal consumptionOpen POSame description as 1 other material number
On hand / on order
730 / 531
next delivery 02 Oct 2026
Today Min / Max
147 / 378
static parameters in BoM
Rec. Min (reorder point)
80
safety stock 61
Rec. Max
266
order qty 186
Service level
99.9%
stockout risk now 0%
Unit price
Rp 85,591
PO history
ML early warning: 99% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 6 issue days in the last 180 days, last issue 1 days ago, 9 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 3 PRs in 180 days.
Consumption history and 12-month forecast
Units per month. Turnaround issues (21 units) excluded from the baseline.
Demand pattern Lumpy · 27 issue days · 10 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 4.1B/yr in expected downtime and emergency buys. A stockout here stops production with probability 1.07% for ~13 days.
Installed on 12 functional locations
7 with criticality A/B · 12 units installed
| FuncLoc | Crit. | Installed | Notifications | Failures / yr |
|---|---|---|---|---|
| PX_PP-790A CHARGE GAS PUMP | A | 1 | 7 | 2.76 |
| PX_KC-752A CONDENSATE BLOWER | A | 1 | 4 | 1.85 |
| PX_PP-1801A DEMIN WATER PUMP | A | 1 | 1 | 0.19 |
| PX_KC-155D CAUSTIC BLOWER | A | 1 | 0 | 0.57 |
| PX_PP-474A LUBE OIL PUMP | B | 1 | 2 | 0.62 |
| PX_PP-1678A METHANE PUMP | B | 1 | 1 | 0.19 |
| PX_PP-1733A RICH AMINE PUMP | B | 1 | 0 | 0.19 |
| PY_PP-315A HYDROGEN PUMP | C | 1 | 5 | 1.90 |
| PX_PP-367A REFLUX PUMP | C | 1 | 0 | 0.19 |
| PX_KC-538 REFLUX BLOWER | S | 1 | 12 | 4.85 |
| PX_KC-422A C4 PRODUCT BLOWER | S | 1 | 6 | 2.71 |
| PX_KC-210D ETHYLENE BLOWER | S | 1 | 0 | 0.57 |
Lead time and procurement
Lead time 36 ± 22 days (PO history, 11 PO lines) · on-time 36%
| PR date | Type | Qty | Unit price | Delivery | Lead time |
|---|---|---|---|---|---|
| 21 Aug 2026 | PR06 Regular replenishment | 531 | Rp 84,786 | 02 Oct 2026 open | 42 d |
| 28 Apr 2026 | PR03 Regular replenishment | 567 | Rp 87,610 | 16 May 2026 | 18 d |
| 16 Apr 2026 | PR03 Regular replenishment | 622 | Rp 82,842 | 22 May 2026 | 36 d |
| 13 Nov 2025 | PR03 Regular replenishment | 404 | Rp 86,514 | 09 Dec 2025 | 26 d |
| 29 Oct 2025 | PR06 Regular replenishment | 448 | Rp 86,535 | 03 Feb 2026 | 97 d |
| 29 Sept 2025 | PR04 Regular (other) | 382 | Rp 82,951 | 28 Oct 2025 | 29 d |
| 13 Aug 2025 | PR06 Regular replenishment | 550 | Rp 82,572 | 26 Aug 2025 | 13 d |
| 05 Aug 2025 | PR03 Regular replenishment | 758 | Rp 85,591 | 05 Sept 2025 | 31 d |
| 25 Jul 2025 | PR03 Regular replenishment | 983 | Rp 83,951 | 19 Aug 2025 | 25 d |
| 10 Jul 2025 | PR04 Regular (other) | 443 | Rp 87,060 | 08 Sept 2025 | 60 d |
Planned maintenance demand (next 12 months)
| Due | FuncLoc | Job | Qty |
|---|---|---|---|
| 02 Feb 2027 | PX_PP-367A | Lube oil change | 0.72 |
| 04 Aug 2027 | PX_PP-367A | Lube oil change | 0.72 |
Recent notifications on its equipment
| Date | Priority | FuncLoc | Description |
|---|---|---|---|
| 24 Sept 2026 | Emergency | PX_KC-538 | KC-538 high vibration |
| 23 Sept 2026 | Medium | PX_PP-790A | PP-790A abnormal noise |
| 16 Sept 2026 | Emergency | PX_KC-538 | Leak from packing |
| 01 Sept 2026 | Medium | PX_KC-538 | KC-538 lube oil filter DP high |
| 01 Sept 2026 | Medium | PX_KC-538 | KC-538 high vibration |
| 03 Aug 2026 | Medium | PY_PP-315A | [MSI-B-26-CTF-281] Permanent repair |
| 27 Jul 2026 | Medium | PX_PP-790A | Oil leak at PP-790A bearing housing |
| 23 Jul 2026 | High | PX_PP-790A | PP-790A seal leak |
| 08 Jul 2026 | Medium | PX_KC-422A | KC-422A high vibration |
| 11 Jun 2026 | Medium | PX_KC-538 | Leak from packing |
Recent goods issues
| Posting date | Qty | Order | Order type |
|---|---|---|---|
| 30 Sept 2026 | 200 | 201000000813 | Corrective |
| 26 Jul 2026 | 1 | 201000027799 | Corrective |
| 31 May 2026 | 5 | 201000020779 | Corrective |
| 30 May 2026 | 1 | 201000020779 | Corrective |
| 21 May 2026 | 4 | 201000012434 | Corrective |
| 20 Apr 2026 | 200 | 201000011242 | Corrective |
| 26 Jan 2026 | 200 | 201000001593 | Corrective |
| 23 Jan 2026 | 200 | 201000002546 | Corrective |
| 15 Jan 2026 | 200 | 201000029326 | Corrective |
| 26 Dec 2025 | 1 | 201000005910 | Corrective |
| 23 Dec 2025 | 5 | 201000008440 | Corrective |
| 23 Dec 2025 | 20 | 203000001878 | Turnaround |
| 15 Dec 2025 | 5 | 201000020418 | Corrective |
| 13 Dec 2025 | 5 | 201000012757 | Corrective |
| 04 Dec 2025 | 4 | 201000021141 | Corrective |