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
| FuncLoc | Crit. | Installed | Notifications | Failures / yr |
|---|---|---|---|---|
| PX_PP-1678A-CSS CONTROL SWITCH STATION FOR PP-1678A-M | B | 1 | 0 | 0.19 |
| PX_PP-1740B-CSS CONTROL SWITCH STATION FOR PP-1740B-M | C | 1 | 0 | 0.19 |
| PX_PP-844B-CSS CONTROL SWITCH STATION FOR PP-844B-M | C | 1 | 0 | 0.19 |
| PX_PP-960-CSS CONTROL SWITCH STATION FOR PP-960-M | C | 1 | 0 | 0.19 |
| PX_PP-978-CSS CONTROL SWITCH STATION FOR PP-978-M | C | 1 | 0 | 0.19 |
Lead time and procurement
Lead time 52 ± 31 days (PO history, 7 PO lines) · on-time 44%
| PR date | Type | Qty | Unit price | Delivery | Lead time |
|---|---|---|---|---|---|
| 26 Aug 2026 | PR06 Regular replenishment | 18 | Rp 497,624 | 08 Oct 2026 open | 43 d |
| 18 May 2026 | PR06 Regular replenishment | 16 | Rp 488,342 | 01 Jun 2026 | 14 d |
| 24 Jan 2026 | PR03 Regular replenishment | 19 | Rp 487,816 | 25 Mar 2026 | 60 d |
| 21 Nov 2025 | PR04 Regular (other) | 8 | Rp 522,886 | 05 Mar 2026 | 104 d |
| 26 Sept 2025 | PR03 Regular replenishment | 16 | Rp 499,659 | 25 Oct 2025 | 29 d |
| 05 Jul 2025 | PR06 Regular replenishment | 9 | Rp 511,128 | 16 Oct 2025 | 103 d |
| 19 May 2025 | PR06 Regular replenishment | 16 | Rp 487,112 | 06 Jul 2025 | 48 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 date | Qty | Order | Order type |
|---|---|---|---|
| 17 Sept 2026 | 1 | 201000025977 | Corrective |
| 20 Aug 2026 | 2 | 201000003452 | Corrective |
| 07 Jun 2026 | 1 | 201000004959 | Corrective |
| 14 May 2026 | 1 | 201000028083 | Corrective |
| 04 May 2026 | 1 | 201000011099 | Corrective |
| 20 Apr 2026 | 2 | 201000013636 | Corrective |
| 12 Apr 2026 | 1 | 201000013543 | Corrective |
| 06 Apr 2026 | 1 | 204000028340 | Preventive |
| 24 Mar 2026 | 1 | 201000014641 | Corrective |
| 11 Mar 2026 | 1 | 201000025906 | Corrective |
| 12 Feb 2026 | 1 | 201000032040 | Corrective |
| 13 Jan 2026 | 1 | 201000029999 | Corrective |
| 21 Dec 2025 | 1 | 201000009100 | Corrective |
| 16 Dec 2025 | 1 | 201000023833 | Corrective |
| 12 Dec 2025 | 1 | 201000001111 | Corrective |