Sparely
DU

LAMP,LED,12W,220VAC,FLOOD

Material 4200004809 · LAMP · Plant 1000

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

Recommendation

  • 1.Forecast 0.5 EA/year: 0.5 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.On hand 2 + on order 0 is at or below the reorder point: order 1 now.
  • 5.Installed on 5 FuncLoc(s), 3 of them criticality A/B.
Proposed purchase requisition
1 EA
Rp 403,312 · order by 01 Oct 2026
Expected arrival ≈ 41 days
Price estimatedLead time estimated
On hand / on order
2 / 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: 9% 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 247 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 Single issue · 1 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 195.1M/yr in expected downtime and emergency buys. A stockout here stops production with probability 1.07% for ~19 days.

Installed on 5 functional locations

3 with criticality A/B · 6 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-1366A-CSS
CONTROL SWITCH STATION FOR PP-1366A-M
A100.19
PX_PP-1657A-CSS
CONTROL SWITCH STATION FOR PP-1657A-M
B200.19
PX_PP-601-CSS
CONTROL SWITCH STATION FOR PP-601-M
B100.19
PX_PP-1448B-CSS
CONTROL SWITCH STATION FOR PP-1448B-M
C110.19
PX_PP-217-CSS
CONTROL SWITCH STATION FOR PP-217-M
C100.19

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
05 May 2025MediumPX_PP-1448B-CSSLeak from packing

Recent goods issues

Posting dateQtyOrderOrder type
27 Jan 20261201000017477Corrective