LAMP,LED,12W,24VDC,T8
Material 4200004714 · LAMP · Plant 1000
AReorderNormalBelow reorder point
- Material
- 4200004714
- Category
- LAMP
- Base unit
- EA
- MRP type
- Stock Item
- Criticality
- A (5 of 9 FuncLocs A/B)
- Supplier
- BERKAH SUPLINDO GLOBAL PT
- Lead time
- 50 d · P80 57 d
- Unit price
- Rp 504,618
Recommendation
- 1.Forecast 33 EA/year: 33 unplanned (recency-weighted compound poisson (own history)).
- 2.Lead time ~50 days; expected demand during lead time 4.4.
- 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 17, order up to 49.
- 4.On hand 7 + on order 0 is at or below the reorder point: order 42 now.
- 5.Installed on 9 FuncLoc(s), 5 of them criticality A/B.
- 6.ML early warning: 99% probability of demand in the next 90 days.
Proposed purchase requisition
42 EA
Rp 21.2M · order by 01 Oct 2026
Expected arrival ≈ 50 days
ML early warningLast turnaround used 5Single sourceAbnormal consumption
On hand / on order
7 / 0
no open PO
Today Min / Max
4 / 6
static parameters in BoM
Rec. Min (reorder point)
17
safety stock 13
Rec. Max
49
order qty 32
Service level
99.9%
stockout risk now 26%
Unit price
Rp 504,618
PO history
ML early warning: 99% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 9 issue days in the last 180 days, last issue 3 days ago, 1 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 5 PRs in 180 days.
Consumption history and 12-month forecast
Units per month. Turnaround issues (6 units) excluded from the baseline.
Demand pattern Smooth · 38 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 9.5B/yr in expected downtime and emergency buys. A stockout here stops production with probability 1.07% for ~19 days.
Installed on 9 functional locations
5 with criticality A/B · 11 units installed
| FuncLoc | Crit. | Installed | Notifications | Failures / yr |
|---|---|---|---|---|
| PX_PP-1070B-CSS CONTROL SWITCH STATION FOR PP-1070B-M | A | 1 | 0 | 0.19 |
| PX_PP-1764-CSS CONTROL SWITCH STATION FOR PP-1764-M | A | 2 | 0 | 0.19 |
| PX_PP-1657A-CSS CONTROL SWITCH STATION FOR PP-1657A-M | B | 1 | 0 | 0.19 |
| PX_PP-1862-CSS CONTROL SWITCH STATION FOR PP-1862-M | B | 1 | 0 | 0.19 |
| PY_2273-1644A-F19-B FLUSHING OIL LINE | B | 1 | 0 | 0.01 |
| PX_PP-703B-CSS CONTROL SWITCH STATION FOR PP-703B-M | C | 1 | 4 | 1.47 |
| PX_PP-795D-CSS CONTROL SWITCH STATION FOR PP-795D-M | C | 1 | 0 | 0.19 |
| PX_PP-883B-CSS CONTROL SWITCH STATION FOR PP-883B-M | C | 1 | 0 | 0.19 |
| PY_3711-9592B-F15-B BFW LINE | C | 2 | 0 | 0.01 |
Lead time and procurement
Lead time 50 ± 33 days (PO history, 16 PO lines) · on-time 50%
| PR date | Type | Qty | Unit price | Delivery | Lead time |
|---|---|---|---|---|---|
| 11 Aug 2026 | PR06 Regular replenishment | 22 | Rp 493,044 | 30 Aug 2026 | 19 d |
| 05 Aug 2026 | PR06 Regular replenishment | 18 | Rp 492,809 | 31 Aug 2026 | 26 d |
| 11 Jul 2026 | PR03 Regular replenishment | 26 | Rp 490,035 | 06 Sept 2026 | 57 d |
| 14 Jun 2026 | PR06 Regular replenishment | 26 | Rp 531,514 | 01 Aug 2026 | 48 d |
| 01 Jun 2026 | PR03 Regular replenishment | 21 | Rp 492,327 | 09 Jul 2026 | 38 d |
| 11 Mar 2026 | PR06 Regular replenishment | 18 | Rp 512,910 | 04 Apr 2026 | 24 d |
| 10 Feb 2026 | PR06 Regular replenishment | 8 | Rp 502,486 | 03 Apr 2026 | 52 d |
| 22 Dec 2025 | PR06 Regular replenishment | 10 | Rp 498,358 | 25 Jan 2026 | 34 d |
| 30 Nov 2025 | PR03 Regular replenishment | 11 | Rp 502,143 | 10 Feb 2026 | 72 d |
| 07 Oct 2025 | PR06 Regular replenishment | 28 | Rp 521,523 | 31 Oct 2025 | 24 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 |
|---|---|---|---|
| 29 Aug 2026 | Medium | PX_PP-703B-CSS | Install scaffolding at PP-703B-CSS |
| 28 Jul 2026 | Low | PX_PP-703B-CSS | Replace lamp as per PM finding |
| 28 Oct 2025 | Low | PX_PP-703B-CSS | Replace lamp as per PM finding |
| 08 Jun 2025 | Medium | PX_PP-703B-CSS | Leak from packing |
Recent goods issues
| Posting date | Qty | Order | Order type |
|---|---|---|---|
| 28 Sept 2026 | 1 | 201000028780 | Corrective |
| 19 Sept 2026 | 1 | 201000033682 | Corrective |
| 18 Sept 2026 | 1 | 201000003432 | Corrective |
| 01 Sept 2026 | 2 | 201000023287 | Corrective |
| 21 Jul 2026 | 1 | 201000011349 | Corrective |
| 10 Jul 2026 | 1 | 201000002156 | Corrective |
| 10 Jul 2026 | 1 | 209000029244 | Other maintenance |
| 27 Jun 2026 | 1 | 209000028044 | Other maintenance |
| 14 Jun 2026 | 1 | 201000035403 | Corrective |
| 18 Apr 2026 | 1 | 201000006270 | Corrective |
| 28 Feb 2026 | 1 | 201000006302 | Corrective |
| 20 Feb 2026 | 1 | 201000028494 | Corrective |
| 17 Feb 2026 | 1 | 201000026224 | Corrective |
| 17 Feb 2026 | 1 | 205000022444 | Other maintenance |
| 11 Feb 2026 | 1 | 203000018609 | Turnaround |