Sparely
DU

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

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-1905A-CSS
CONTROL SWITCH STATION FOR PP-1905A-M
A400.19
PX_PP-473B-CSS
CONTROL SWITCH STATION FOR PP-473B-M
A200.19
PY_7538-1860-F14-A
FIELD DEVICE
B100.01
PY_PP-1862B-CSS
CONTROL SWITCH STATION FOR PP-1862B-M
B100.19
PX_PP-1701B-CSS
CONTROL SWITCH STATION FOR PP-1701B-M
C110.19
PX_PP-535A-CSS
CONTROL SWITCH STATION FOR PP-535A-M
C100.19
PX_PP-960-CSS
CONTROL SWITCH STATION FOR PP-960-M
C100.19
PY_PP-490-CSS
CONTROL SWITCH STATION FOR PP-490-M
C400.19

Lead time and procurement

Lead time 52 ± 30 days (PO history, 28 PO lines) · on-time 36%

PR dateTypeQtyUnit priceDeliveryLead time
13 Sept 2026PR10
Other
17Rp 831,69930 Nov 2026
open
78 d
01 Sept 2026PR03
Regular replenishment
30Rp 811,62826 Sept 202625 d
31 Aug 2026PR06
Regular replenishment
54Rp 831,47116 Oct 2026
open
46 d
28 Aug 2026PR06
Regular replenishment
43Rp 802,37009 Oct 2026
open
42 d
13 Aug 2026PR06
Regular replenishment
29Rp 822,99819 Sept 202637 d
12 Aug 2026PR03
Regular replenishment
24Rp 830,84520 Sept 202639 d
09 Aug 2026PR04
Regular (other)
49Rp 815,28906 Oct 2026
open
58 d
05 Aug 2026PR05
Project / turnaround
16Rp 836,75630 Nov 2026
open
117 d
01 Aug 2026PR06
Regular replenishment
53Rp 844,46417 Sept 202647 d
14 Jun 2026PR05
Project / turnaround
33Rp 793,09702 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

DatePriorityFuncLocDescription
14 May 2025MediumPX_PP-1701B-CSSInstall scaffolding at PP-1701B-CSS

Recent goods issues

Posting dateQtyOrderOrder type
27 Sept 20261209000029477Other maintenance
20 Sept 20261201000023715Corrective
04 Sept 20261201000031484Corrective
03 Sept 20261204000017348Preventive
19 Aug 20261201000000652Corrective
02 Aug 20261201000026506Corrective
24 Jul 20261201000031151Corrective
22 Jul 20261201000023160Corrective
17 Jun 20261201000011352Corrective
12 Jun 20261201000016515Corrective
08 Jun 20262201000024387Corrective
28 May 20261201000023249Corrective
20 May 20261201000002055Corrective
19 Apr 20261204000022204Preventive
14 Apr 20261201000025715Corrective