Sparely
DU

LAMP,LED,9W,220VAC,T8

Material 4200004754 · LAMP · Plant 1000

BLong-leadMonitorHealthy
Material
4200004754
Category
LAMP
Base unit
EA
MRP type
Non Stock
Criticality
B (1 of 5 FuncLocs A/B)
Supplier
PRIMA LOGAM SENTOSA PT
Lead time
52 d · P80 94 d
Unit price
Rp 497,624

Recommendation

  • 1.Forecast 21 EA/year: 21 unplanned (recency-weighted compound poisson (own history)).
  • 2.Lead time ~52 days; expected demand during lead time 3.0.
  • 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 11, order up to 32.
  • 4.Long lead time: 80% of deliveries took up to 94 days and the fastest seen in its category 19 days, from a single supplier. Emergency buying cannot prevent downtime: plan ahead or hold as a capital spare.
  • 5.Installed on 5 FuncLoc(s), 1 of them criticality A/B.
  • 6.ML early warning: 98% probability of demand in the next 90 days.
Long-leadML early warningConvert to Stock ItemLast turnaround used 7Single sourceOpen POSame description as 1 other material number
On hand / on order
3 / 18
next delivery 08 Oct 2026
Today Min / Max
0 / 0
static parameters in BoM
Rec. Min (reorder point)
11
safety stock 8
Rec. Max
32
order qty 21
Service level
99.9%
stockout risk now 0%
Unit price
Rp 497,624
PO history
ML early warning: 98% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 8 issue days in the last 180 days, last issue 14 days ago, 0 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 2 PRs in 180 days.

Consumption history and 12-month forecast

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

Demand pattern Erratic · 26 issue days · 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.6B/yr in expected downtime and emergency buys. A stockout here stops production with probability 0.53% for ~19 days.

Installed on 5 functional locations

1 with criticality A/B · 5 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-1678A-CSS
CONTROL SWITCH STATION FOR PP-1678A-M
B100.19
PX_PP-1740B-CSS
CONTROL SWITCH STATION FOR PP-1740B-M
C100.19
PX_PP-844B-CSS
CONTROL SWITCH STATION FOR PP-844B-M
C100.19
PX_PP-960-CSS
CONTROL SWITCH STATION FOR PP-960-M
C100.19
PX_PP-978-CSS
CONTROL SWITCH STATION FOR PP-978-M
C100.19

Lead time and procurement

Lead time 52 ± 31 days (PO history, 7 PO lines) · on-time 44%

PR dateTypeQtyUnit priceDeliveryLead time
26 Aug 2026PR06
Regular replenishment
18Rp 497,62408 Oct 2026
open
43 d
18 May 2026PR06
Regular replenishment
16Rp 488,34201 Jun 202614 d
24 Jan 2026PR03
Regular replenishment
19Rp 487,81625 Mar 202660 d
21 Nov 2025PR04
Regular (other)
8Rp 522,88605 Mar 2026104 d
26 Sept 2025PR03
Regular replenishment
16Rp 499,65925 Oct 202529 d
05 Jul 2025PR06
Regular replenishment
9Rp 511,12816 Oct 2025103 d
19 May 2025PR06
Regular replenishment
16Rp 487,11206 Jul 202548 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

No notifications on the equipment this part is installed on.

Recent goods issues

Posting dateQtyOrderOrder type
17 Sept 20261201000025977Corrective
20 Aug 20262201000003452Corrective
07 Jun 20261201000004959Corrective
14 May 20261201000028083Corrective
04 May 20261201000011099Corrective
20 Apr 20262201000013636Corrective
12 Apr 20261201000013543Corrective
06 Apr 20261204000028340Preventive
24 Mar 20261201000014641Corrective
11 Mar 20261201000025906Corrective
12 Feb 20261201000032040Corrective
13 Jan 20261201000029999Corrective
21 Dec 20251201000009100Corrective
16 Dec 20251201000023833Corrective
12 Dec 20251201000001111Corrective