Sparely
DU

LAMP,LED,36W,24VDC,E27

Material 4200005196 · LAMP · Plant 1000

BReorderNormalSlow-moving
Material
4200005196
Category
LAMP
Base unit
EA
MRP type
Stock Item
Criticality
B (1 of 1 FuncLocs A/B)
Supplier
SURYA LOGAM LESTARI PT
Lead time
38 d · P80 50 d
Unit price
Rp 169,856

Recommendation

  • 1.Forecast 1.2 EA/year: 1.2 unplanned (credibility blend: own history + installed-base prior).
  • 2.Lead time ~38 days; expected demand during lead time 0.1.
  • 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 3, order up to 6.
  • 4.On hand 2 + on order 0 is at or below the reorder point: order 4 now.
  • 5.Installed on 1 FuncLoc(s), 1 of them criticality A/B.
Proposed purchase requisition
4 EA
Rp 679,424 · order by 01 Oct 2026
Expected arrival ≈ 38 days
Single source
On hand / on order
2 / 0
no open PO
Today Min / Max
1 / 3
static parameters in BoM
Rec. Min (reorder point)
3
safety stock 3
Rec. Max
6
order qty 3
Service level
99.9%
stockout risk now 4%
Unit price
Rp 169,856
PO history
ML early warning: 6% 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 466 days ago, 0 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 1 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 40.0M/yr in expected downtime and emergency buys. A stockout here stops production with probability 0.53% for ~19 days.

Installed on 1 functional locations

1 with criticality A/B · 1 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PY_PP-315A-CSS
CONTROL SWITCH STATION FOR PP-315A-M
B131.05

Lead time and procurement

Lead time 38 ± 27 days (PO history, 3 PO lines) · on-time 20%

PR dateTypeQtyUnit priceDeliveryLead time
03 Jun 2026PR05
Project / turnaround
2Rp 169,85612 Aug 202670 d
26 Dec 2025PR03
Regular replenishment
1Rp 172,64910 Jan 202615 d
27 Nov 2025PR03
Regular replenishment
2Rp 167,98017 Dec 202520 d

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
22 Mar 2026MediumPY_PP-315A-CSSInstall cover plate for MCP cracking
10 Jan 2026HighPY_PP-315A-CSSPainting PP-315A-CSS
20 Jun 2025HighPY_PP-315A-CSSReplace lamp as per PM finding

Recent goods issues

Posting dateQtyOrderOrder type
22 Jun 20253201000000529Corrective