LAMP,LED,36W,220VAC,FLOOD
Material 4200004765 · LAMP · Plant 1000
BReduceExcess
- Material
- 4200004765
- Category
- LAMP
- Base unit
- EA
- MRP type
- Stock Item
- Criticality
- B (1 of 1 FuncLocs A/B)
- Supplier
- MITRA PERKASA PRATAMA PT
- Lead time
- 47 d · P80 61 d
- Unit price
- Rp 867,905
Recommendation
- 1.Forecast 20 EA/year: 20 unplanned (recency-weighted compound poisson (own history)).
- 2.Lead time ~47 days; expected demand during lead time 2.6.
- 3.A 99.8% service level gives the lowest holding + downtime-risk cost: reorder at 9, order up to 28.
- 4.Stock 33 exceeds the level to keep (28) by 5.
- 5.Installed on 1 FuncLoc(s), 1 of them criticality A/B.
- 6.ML early warning: 97% probability of demand in the next 90 days.
ML early warningLast turnaround used 1Single sourceAbnormal consumptionOpen PO
On hand / on order
33 / 7
next delivery 08 Nov 2026
Today Min / Max
10 / 28
static parameters in BoM
Rec. Min (reorder point)
9
safety stock 7
Rec. Max
28
order qty 19
Service level
99.8%
stockout risk now 0%
Unit price
Rp 867,905
PO history
ML early warning: 97% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 6 issue days in the last 180 days, last issue 28 days ago, 0 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 3 PRs in 180 days.
Consumption history and 12-month forecast
Units per month. Turnaround issues (2 units) excluded from the baseline.
Demand pattern Lumpy · 23 issue days · 1 abnormal issue(s) capped · 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.4B/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
| FuncLoc | Crit. | Installed | Notifications | Failures / yr |
|---|---|---|---|---|
| PX_PP-1837A-CSS CONTROL SWITCH STATION FOR PP-1837A-M | B | 1 | 0 | 0.19 |
Lead time and procurement
Lead time 47 ± 18 days (PO history, 12 PO lines) · on-time 46%
| PR date | Type | Qty | Unit price | Delivery | Lead time |
|---|---|---|---|---|---|
| 16 Aug 2026 | PR03 Regular replenishment | 7 | Rp 858,019 | 08 Nov 2026 open | 84 d |
| 14 Jul 2026 | PR03 Regular replenishment | 9 | Rp 871,975 | 12 Aug 2026 | 29 d |
| 14 Jun 2026 | PR03 Regular replenishment | 10 | Rp 858,972 | 16 Jul 2026 | 32 d |
| 22 Feb 2026 | PR03 Regular replenishment | 16 | Rp 873,902 | 02 Apr 2026 | 39 d |
| 07 Feb 2026 | PR03 Regular replenishment | 13 | Rp 886,261 | 09 Mar 2026 | 30 d |
| 21 Nov 2025 | PR06 Regular replenishment | 14 | Rp 880,500 | 07 Jan 2026 | 47 d |
| 29 Oct 2025 | PR03 Regular replenishment | 10 | Rp 903,748 | 05 Jan 2026 | 68 d |
| 18 Oct 2025 | PR03 Regular replenishment | 9 | Rp 889,143 | 24 Nov 2025 | 37 d |
| 03 Sept 2025 | PR05 Project / turnaround | 4 | Rp 862,688 | 16 Oct 2025 | 43 d |
| 25 Aug 2025 | PR01 Import / long-lead | 5 | Rp 854,945 | 26 Oct 2025 | 62 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 |
|---|---|---|---|
| 03 Sept 2026 | 1 | 204000008731 | Preventive |
| 19 Jun 2026 | 1 | 209000016742 | Other maintenance |
| 18 May 2026 | 1 | 209000009186 | Other maintenance |
| 07 May 2026 | 1 | 201000016546 | Corrective |
| 24 Apr 2026 | 2 | 201000002634 | Corrective |
| 05 Apr 2026 | 3 | 201000010228 | Corrective |
| 03 Mar 2026 | 2 | 201000011654 | Corrective |
| 18 Feb 2026 | 2 | 201000029237 | Corrective |
| 09 Feb 2026 | 1 | 203000032991 | Turnaround |
| 27 Jan 2026 | 2 | 201000020819 | Corrective |
| 25 Jan 2026 | 1 | 201000010544 | Corrective |
| 18 Jan 2026 | 1 | 201000009933 | Corrective |
| 15 Jan 2026 | 4 | 201000015012 | Corrective |
| 06 Jan 2026 | 2 | 201000030617 | Corrective |
| 05 Jan 2026 | 1 | 201000011361 | Corrective |