LAMP,LED,50W,220VAC,FLOOD
Material 4200004685 · LAMP · Plant 1000
AMonitorHealthy
- Material
- 4200004685
- Category
- LAMP
- Base unit
- EA
- MRP type
- Non Stock
- Criticality
- A (4 of 8 FuncLocs A/B)
- Supplier
- GEMILANG REFRAKTORI PRATAMA PT
- Lead time
- 52 d · P80 67 d
- Unit price
- Rp 830,539
Recommendation
- 1.Forecast 62 EA/year: 62 unplanned (recency-weighted compound poisson (own history)).
- 2.Lead time ~52 days; expected demand during lead time 8.8.
- 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 29, order up to 63.
- 4.Installed on 8 FuncLoc(s), 4 of them criticality A/B.
- 5.ML early warning: 100% probability of demand in the next 90 days.
ML early warningConvert to Stock ItemLast turnaround used 8Single sourceAbnormal consumptionOpen POSame description as 1 other material number
On hand / on order
4 / 212
next delivery 02 Oct 2026
Today Min / Max
0 / 0
static parameters in BoM
Rec. Min (reorder point)
29
safety stock 21
Rec. Max
63
order qty 34
Service level
99.9%
stockout risk now 0%
Unit price
Rp 830,539
PO history
ML early warning: 100% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 16 issue days in the last 180 days, last issue 4 days ago, 0 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 14 PRs in 180 days.
Consumption history and 12-month forecast
Units per month. Turnaround issues (8 units) excluded from the baseline.
Demand pattern Erratic · 75 issue days · 2 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 19.0B/yr in expected downtime and emergency buys. A stockout here stops production with probability 1.07% for ~19 days.
Installed on 8 functional locations
4 with criticality A/B · 15 units installed
| FuncLoc | Crit. | Installed | Notifications | Failures / yr |
|---|---|---|---|---|
| PX_PP-1905A-CSS CONTROL SWITCH STATION FOR PP-1905A-M | A | 4 | 0 | 0.19 |
| PX_PP-473B-CSS CONTROL SWITCH STATION FOR PP-473B-M | A | 2 | 0 | 0.19 |
| PY_7538-1860-F14-A FIELD DEVICE | B | 1 | 0 | 0.01 |
| PY_PP-1862B-CSS CONTROL SWITCH STATION FOR PP-1862B-M | B | 1 | 0 | 0.19 |
| PX_PP-1701B-CSS CONTROL SWITCH STATION FOR PP-1701B-M | C | 1 | 1 | 0.19 |
| PX_PP-535A-CSS CONTROL SWITCH STATION FOR PP-535A-M | C | 1 | 0 | 0.19 |
| PX_PP-960-CSS CONTROL SWITCH STATION FOR PP-960-M | C | 1 | 0 | 0.19 |
| PY_PP-490-CSS CONTROL SWITCH STATION FOR PP-490-M | C | 4 | 0 | 0.19 |
Lead time and procurement
Lead time 52 ± 30 days (PO history, 28 PO lines) · on-time 36%
| PR date | Type | Qty | Unit price | Delivery | Lead time |
|---|---|---|---|---|---|
| 13 Sept 2026 | PR10 Other | 17 | Rp 831,699 | 30 Nov 2026 open | 78 d |
| 01 Sept 2026 | PR03 Regular replenishment | 30 | Rp 811,628 | 26 Sept 2026 | 25 d |
| 31 Aug 2026 | PR06 Regular replenishment | 54 | Rp 831,471 | 16 Oct 2026 open | 46 d |
| 28 Aug 2026 | PR06 Regular replenishment | 43 | Rp 802,370 | 09 Oct 2026 open | 42 d |
| 13 Aug 2026 | PR06 Regular replenishment | 29 | Rp 822,998 | 19 Sept 2026 | 37 d |
| 12 Aug 2026 | PR03 Regular replenishment | 24 | Rp 830,845 | 20 Sept 2026 | 39 d |
| 09 Aug 2026 | PR04 Regular (other) | 49 | Rp 815,289 | 06 Oct 2026 open | 58 d |
| 05 Aug 2026 | PR05 Project / turnaround | 16 | Rp 836,756 | 30 Nov 2026 open | 117 d |
| 01 Aug 2026 | PR06 Regular replenishment | 53 | Rp 844,464 | 17 Sept 2026 | 47 d |
| 14 Jun 2026 | PR05 Project / turnaround | 33 | Rp 793,097 | 02 Oct 2026 open | 110 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
| Date | Priority | FuncLoc | Description |
|---|---|---|---|
| 14 May 2025 | Medium | PX_PP-1701B-CSS | Install scaffolding at PP-1701B-CSS |
Recent goods issues
| Posting date | Qty | Order | Order type |
|---|---|---|---|
| 27 Sept 2026 | 1 | 209000029477 | Other maintenance |
| 20 Sept 2026 | 1 | 201000023715 | Corrective |
| 04 Sept 2026 | 1 | 201000031484 | Corrective |
| 03 Sept 2026 | 1 | 204000017348 | Preventive |
| 19 Aug 2026 | 1 | 201000000652 | Corrective |
| 02 Aug 2026 | 1 | 201000026506 | Corrective |
| 24 Jul 2026 | 1 | 201000031151 | Corrective |
| 22 Jul 2026 | 1 | 201000023160 | Corrective |
| 17 Jun 2026 | 1 | 201000011352 | Corrective |
| 12 Jun 2026 | 1 | 201000016515 | Corrective |
| 08 Jun 2026 | 2 | 201000024387 | Corrective |
| 28 May 2026 | 1 | 201000023249 | Corrective |
| 20 May 2026 | 1 | 201000002055 | Corrective |
| 19 Apr 2026 | 1 | 204000022204 | Preventive |
| 14 Apr 2026 | 1 | 201000025715 | Corrective |