LAMP,LED,18W,24VDC,FLOOD
Material 4200004694 · LAMP · Plant 1000
BReorderCriticalBelow reorder point
- Material
- 4200004694
- Category
- LAMP
- Base unit
- EA
- MRP type
- Stock Item
- Criticality
- B (2 of 5 FuncLocs A/B)
- Supplier
- MITRA PERKASA PRATAMA PT
- Lead time
- 24 d · P80 28 d
- Unit price
- Rp 116,166
Recommendation
- 1.Forecast 55 EA/year: 55 unplanned (recency-weighted compound poisson (own history)).
- 2.Lead time ~24 days; expected demand during lead time 3.6.
- 3.A 100.0% service level gives the lowest holding + downtime-risk cost: reorder at 13, order up to 69.
- 4.On hand 2 + on order 0 is at or below the reorder point: order 67 now.
- 5.Installed on 5 FuncLoc(s), 2 of them criticality A/B.
- 6.ML early warning: 100% probability of demand in the next 90 days.
Proposed purchase requisition
67 EA
Rp 7.8M · order by 01 Oct 2026
Expected arrival ≈ 24 days
ML early warningLast turnaround used 8Single sourceAbnormal consumption
On hand / on order
2 / 0
no open PO
Today Min / Max
7 / 22
static parameters in BoM
Rec. Min (reorder point)
13
safety stock 10
Rec. Max
69
order qty 56
Service level
100.0%
stockout risk now 72%
Unit price
Rp 116,166
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 1 days ago, 0 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 7 PRs in 180 days.
Consumption history and 12-month forecast
Units per month. Turnaround issues (13 units) excluded from the baseline.
Demand pattern Smooth · 60 issue days · 3 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 4.0B/yr in expected downtime and emergency buys. A stockout here stops production with probability 0.53% for ~19 days.
Installed on 5 functional locations
2 with criticality A/B · 10 units installed
| FuncLoc | Crit. | Installed | Notifications | Failures / yr |
|---|---|---|---|---|
| PX_PP-1798C-CSS CONTROL SWITCH STATION FOR PP-1798C-M | B | 1 | 0 | 0.19 |
| PY_3368-2281B-F29 MARSHALLING TERMINAL | B | 1 | 0 | 0.01 |
| PX_PP-1177-CSS CONTROL SWITCH STATION FOR PP-1177-M | C | 3 | 0 | 0.19 |
| PX_PP-1785A-CSS CONTROL SWITCH STATION FOR PP-1785A-M | C | 4 | 0 | 0.19 |
| PX_PP-217-CSS CONTROL SWITCH STATION FOR PP-217-M | C | 1 | 0 | 0.19 |
Lead time and procurement
Lead time 24 ± 10 days (PO history, 28 PO lines) · on-time 46%
| PR date | Type | Qty | Unit price | Delivery | Lead time |
|---|---|---|---|---|---|
| 28 Aug 2026 | PR06 Regular replenishment | 13 | Rp 117,818 | 19 Sept 2026 | 22 d |
| 25 Aug 2026 | PR03 Regular replenishment | 37 | Rp 118,712 | 10 Sept 2026 | 16 d |
| 11 Aug 2026 | PR03 Regular replenishment | 48 | Rp 116,497 | 23 Aug 2026 | 12 d |
| 11 Aug 2026 | PR03 Regular replenishment | 20 | Rp 118,355 | 26 Aug 2026 | 15 d |
| 03 Aug 2026 | PR03 Regular replenishment | 26 | Rp 113,828 | 24 Aug 2026 | 21 d |
| 21 Jul 2026 | PR03 Regular replenishment | 14 | Rp 117,460 | 05 Aug 2026 | 15 d |
| 10 Jul 2026 | PR03 Regular replenishment | 42 | Rp 109,815 | 27 Jul 2026 | 17 d |
| 21 Mar 2026 | PR04 Regular (other) | 15 | Rp 112,109 | 16 Apr 2026 | 26 d |
| 09 Mar 2026 | PR03 Regular replenishment | 13 | Rp 115,425 | 28 Mar 2026 | 19 d |
| 18 Feb 2026 | PR03 Regular replenishment | 43 | Rp 117,768 | 24 Mar 2026 | 34 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 |
|---|---|---|---|
| 30 Sept 2026 | 3 | 201000024007 | Corrective |
| 30 Sept 2026 | 1 | 201000026532 | Corrective |
| 26 Sept 2026 | 1 | 201000013974 | Corrective |
| 27 Aug 2026 | 1 | 201000001746 | Corrective |
| 27 Jul 2026 | 1 | 201000017737 | Corrective |
| 26 Jul 2026 | 1 | 201000024842 | Corrective |
| 24 Jul 2026 | 3 | 201000024842 | Corrective |
| 23 Jul 2026 | 2 | 201000004861 | Corrective |
| 06 Jul 2026 | 3 | 201000020872 | Corrective |
| 21 Jun 2026 | 1 | 209000016742 | Other maintenance |
| 11 Jun 2026 | 2 | 201000016926 | Corrective |
| 08 Jun 2026 | 1 | 201000010036 | Corrective |
| 05 Jun 2026 | 3 | 201000005500 | Corrective |
| 03 Jun 2026 | 1 | 201000022908 | Corrective |
| 12 May 2026 | 1 | 201000027569 | Corrective |