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
| FuncLoc | Crit. | Installed | Notifications | Failures / yr |
|---|---|---|---|---|
| PX_PP-888A CONDENSATE PUMP | A | 1 | 6 | 1.90 |
| PX_PP-1882C RECYCLE ETHANE PUMP | A | 1 | 2 | 0.62 |
| PX_PP-166A SPENT CAUSTIC PUMP | A | 1 | 1 | 0.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)
| Due | FuncLoc | Job | Qty |
|---|---|---|---|
| 01 Dec 2026 | PX_PP-888A | Lube oil change | 0.72 |
| 01 Dec 2026 | PX_PP-1882C | Lube oil change | 0.72 |
| 02 Mar 2027 | PX_PP-888A | Lube oil change | 0.72 |
| 02 Jun 2027 | PX_PP-888A | Lube oil change | 0.72 |
| 02 Jun 2027 | PX_PP-1882C | Lube oil change | 0.72 |
| 01 Sept 2027 | PX_PP-888A | Lube oil change | 0.72 |
Recent notifications on its equipment
| Date | Priority | FuncLoc | Description |
|---|---|---|---|
| 22 Sept 2026 | Medium | PX_PP-888A | Oil leak at PP-888A bearing housing |
| 16 Aug 2026 | High | PX_PP-888A | PP-888A abnormal noise |
| 26 May 2026 | Medium | PX_PP-888A | PP-888A abnormal noise |
| 25 Apr 2026 | Low | PX_PP-888A | Install scaffolding at PP-888A |
| 09 Dec 2025 | Medium | PX_PP-1882C | [MSI-B-25-LFS-262/M] Replace line |
| 02 Dec 2025 | Medium | PX_PP-888A | PP-888A discharge pressure low |
| 20 May 2025 | Medium | PX_PP-166A | Oil leak at PP-166A bearing housing |
| 16 May 2025 | Low | PX_PP-1882C | Overhaul PP-1882C |
| 02 May 2025 | Low | PX_PP-888A | Replace bearing PP-888A |
Recent goods issues
| Posting date | Qty | Order | Order type |
|---|---|---|---|
| 05 Jun 2026 | 20 | 201000010759 | Corrective |
| 30 May 2026 | 5 | 201000020115 | Corrective |
| 23 Apr 2026 | 1 | 201000002634 | Corrective |
| 01 Feb 2026 | 5 | 201000017810 | Corrective |
| 02 Jan 2026 | 200 | 201000024626 | Corrective |
| 07 Dec 2025 | 4 | 201000015109 | Corrective |
| 27 Nov 2025 | 4 | 203000032713 | Turnaround |
| 12 Sept 2025 | 200 | 201000023534 | Corrective |
| 26 Aug 2025 | 5 | 203000006603 | Turnaround |
| 09 Aug 2025 | 20 | 201000032179 | Corrective |
| 20 Jul 2025 | 1 | 201000019985 | Corrective |
| 25 Jun 2025 | 20 | 203000034428 | Turnaround |