Sparely
DU

LAMP,LED,18W,24VDC,T8

Material 4200005194 · LAMP · Plant 1000

AMonitorSlow-moving
Material
4200005194
Category
LAMP
Base unit
EA
MRP type
Stock Item
Criticality
A (1 of 2 FuncLocs A/B)
Supplier
No PO history
Lead time
41 d · P80 60 d
Unit price
Rp 403,312 (est.)

Recommendation

  • 1.Forecast 0.6 EA/year: 0.6 unplanned (credibility blend: own history + installed-base prior).
  • 2.Lead time ~41 days; expected demand during lead time 0.1.
  • 3.A 100.0% service level gives the lowest holding + downtime-risk cost: reorder at 2, order up to 3.
  • 4.Installed on 2 FuncLoc(s), 1 of them criticality A/B.
Price estimatedLead time estimatedSame description as 1 other material number
On hand / on order
3 / 0
no open PO
Today Min / Max
1 / 2
static parameters in BoM
Rec. Min (reorder point)
2
safety stock 2
Rec. Max
3
order qty 1
Service level
100.0%
stockout risk now 0%
Unit price
Rp 403,312
Category + unit estimate
ML early warning: 3% 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 342 days ago, 0 failure notifications on its equipment in 90 days, 0 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 Intermittent · 2 issue days · method: Credibility blend: own history + installed-base prior.

Cost of each service level

Annual holding vs downtime-risk cost for this part

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

Installed on 2 functional locations

1 with criticality A/B · 2 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-1752A-CSS
CONTROL SWITCH STATION FOR PP-1752A-M
A100.19
PX_PP-577-CSS
CONTROL SWITCH STATION FOR PP-577-M
C110.62

Lead time and procurement

Lead time 41 ± 24 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)

No part-consuming maintenance job uses this part in the next 12 months.

Recent notifications on its equipment

DatePriorityFuncLocDescription
02 Jul 2025MediumPX_PP-577-CSSInstall cover plate for MCP cracking

Recent goods issues

Posting dateQtyOrderOrder type
24 Oct 20251201000034680Corrective
31 Aug 20251201000013573Corrective