Sparely
DU

OIL,LUBRICANT,ISO VG 68,SYNTHETIC,20L

Material 4100107482 · OIL · Plant 1000

AReorderCriticalStockout
Material
4100107482
Category
OIL
Base unit
L
MRP type
Stock Item
Criticality
A (4 of 4 FuncLocs A/B)
Supplier
No PO history
Lead time
24 d · P80 36 d
Unit price
Rp 157,448 (est.)

Recommendation

  • 1.Forecast 3.8 L/year: 1.6 unplanned (installed-base failure prior (no history)) + 2.1 from the maintenance plan.
  • 2.Lead time ~24 days; expected demand during lead time 0.1.
  • 3.A 100.0% service level gives the lowest holding + downtime-risk cost: reorder at 11, order up to 22.
  • 4.On hand 0 + on order 0 is at or below the reorder point: order 22 now.
  • 5.Installed on 4 FuncLoc(s), 4 of them criticality A/B.
Proposed purchase requisition
22 L
Rp 3.5M · order by 01 Oct 2026
Expected arrival ≈ 24 days
Price estimatedLead time estimated
On hand / on order
0 / 0
no open PO
Today Min / Max
2 / 6
static parameters in BoM
Rec. Min (reorder point)
11
safety stock 11
Rec. Max
22
order qty 11
Service level
100.0%
stockout risk now 1%
Unit price
Rp 157,448
Category + unit estimate
ML early warning: 5% probability this part is needed in the next 90 days (below the 30% warning threshold). Inputs: 0 issue days in the last 180 days, last issue never, 2 failure notifications on its equipment in 90 days, 1 planned jobs in 90 days, 0 PRs in 180 days.

Consumption history and 12-month forecast

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

Demand pattern No demand · 0 issue days · method: Installed-base failure prior (no history).

Cost of each service level

Annual holding vs downtime-risk cost for this part

Not stocking at all would cost Rp 41.1M/yr in expected downtime and emergency buys. A stockout here stops production with probability 1.07% for ~13 days.

Installed on 4 functional locations

4 with criticality A/B · 4 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-412
REFLUX PUMP
A131.05
PX_KC-178A
QUENCH OIL FAN
A100.57
PX_KC-886D
BOTTOM FAN
B141.43
PX_KC-563B
GASOLINE COMPRESSOR
B100.57

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)

DueFuncLocJobQty
01 Dec 2026PX_PP-412Lube oil change0.72
02 Apr 2027PX_PP-412Lube oil change0.72
02 Aug 2027PX_PP-412Lube oil change0.72

Recent notifications on its equipment

DatePriorityFuncLocDescription
28 Sept 2026LowPX_KC-886DKC-886D high vibration
18 Sept 2026MediumPX_PP-412Oil leak at PP-412 bearing housing
10 Jul 2026MediumPX_KC-886DInstall scaffolding at KC-886D
20 Apr 2026LowPX_KC-886DReplace lamp as per PM finding
17 Apr 2026MediumPX_PP-412Replace bearing PP-412
19 May 2025MediumPX_PP-412Oil leak at PP-412 bearing housing
04 May 2025MediumPX_KC-886D[MSI-B-25-PZW-222/M] Replace line

Recent goods issues

Never issued in the 17-month history.

Sparely