Sparely
DU

LAMP,LED,18W,220VAC,E27

Material 4200004671 · LAMP · Plant 1000

AMonitorHealthy
Material
4200004671
Category
LAMP
Base unit
EA
MRP type
Stock Item
Criticality
A (8 of 20 FuncLocs A/B)
Supplier
KARYA INSTRUMEN SENTOSA PT
Lead time
48 d · P80 58 d
Unit price
Rp 403,312

Recommendation

  • 1.Forecast 127 EA/year: 127 unplanned (recency-weighted compound poisson (own history)).
  • 2.Lead time ~48 days; expected demand during lead time 17.
  • 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 50, order up to 119.
  • 4.Installed on 20 FuncLoc(s), 8 of them criticality A/B.
  • 5.ML early warning: 100% probability of demand in the next 90 days.
ML early warningLast turnaround used 22Single sourceAbnormal consumptionOpen PO
On hand / on order
27 / 549
next delivery 03 Oct 2026
Today Min / Max
19 / 57
static parameters in BoM
Rec. Min (reorder point)
50
safety stock 34
Rec. Max
119
order qty 69
Service level
99.9%
stockout risk now 0%
Unit price
Rp 403,312
PO history
ML early warning: 100% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 31 issue days in the last 180 days, last issue 8 days ago, 0 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 22 PRs in 180 days.

Consumption history and 12-month forecast

Units per month. Turnaround issues (32 units) excluded from the baseline.

Demand pattern Smooth · 140 issue days · 8 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 34.5B/yr in expected downtime and emergency buys. A stockout here stops production with probability 1.07% for ~19 days.

Installed on 20 functional locations

8 with criticality A/B · 24 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-1892B-CSS
CONTROL SWITCH STATION FOR PP-1892B-M
A110.19
PX_PP-1070B-CSS
CONTROL SWITCH STATION FOR PP-1070B-M
A100.19
PX_PP-1905A-CSS
CONTROL SWITCH STATION FOR PP-1905A-M
A100.19
PY_PP-1682-CSS
CONTROL SWITCH STATION FOR PP-1682-M
A400.19
PY_PP-899A-CSS
CONTROL SWITCH STATION FOR PP-899A-M
B120.62
PX_PP-1678A-CSS
CONTROL SWITCH STATION FOR PP-1678A-M
B100.19
PX_PP-1837A-CSS
CONTROL SWITCH STATION FOR PP-1837A-M
B100.19
PY_PP-1862B-CSS
CONTROL SWITCH STATION FOR PP-1862B-M
B100.19
PX_PP-1012C-CSS
CONTROL SWITCH STATION FOR PP-1012C-M
C100.19
PX_PP-1139-CSS
CONTROL SWITCH STATION FOR PP-1139-M
C100.19
PX_PP-217-CSS
CONTROL SWITCH STATION FOR PP-217-M
C100.19
PX_PP-246C-CSS
CONTROL SWITCH STATION FOR PP-246C-M
C100.19

Lead time and procurement

Lead time 48 ± 26 days (PO history, 55 PO lines) · on-time 43%

PR dateTypeQtyUnit priceDeliveryLead time
22 Sept 2026PR03
Regular replenishment
122Rp 412,12427 Oct 2026
open
35 d
20 Sept 2026PR03
Regular replenishment
58Rp 406,41827 Oct 2026
open
37 d
11 Sept 2026PR06
Regular replenishment
122Rp 411,72503 Oct 2026
open
22 d
02 Sept 2026PR03
Regular replenishment
77Rp 424,79507 Oct 2026
open
35 d
01 Sept 2026PR03
Regular replenishment
115Rp 406,50121 Nov 2026
open
81 d
30 Aug 2026PR03
Regular replenishment
51Rp 399,02415 Sept 202616 d
27 Aug 2026PR03
Regular replenishment
55Rp 391,47008 Oct 2026
open
42 d
15 Aug 2026PR03
Regular replenishment
52Rp 398,77529 Sept 202645 d
22 Jul 2026PR03
Regular replenishment
123Rp 390,77624 Aug 202633 d
20 Jul 2026PR06
Regular replenishment
51Rp 394,88421 Aug 202632 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
17 Apr 2026HighPY_PP-899A-CSSPP-899A-CSS lamp indicator broken
19 May 2025LowPY_PP-899A-CSS[MSI-B-25-KAJ-316/M] Replace line
14 May 2025MediumPX_PP-1892B-CSSLeak from packing

Recent goods issues

Posting dateQtyOrderOrder type
23 Sept 20261209000029477Other maintenance
22 Sept 20261201000039118Corrective
14 Sept 20261201000018595Corrective
05 Sept 20261201000030840Corrective
19 Aug 20262205000024375Other maintenance
01 Aug 20261201000008499Corrective
31 Jul 20262201000001731Corrective
30 Jul 20261201000000379Corrective
26 Jul 20261201000025485Corrective
25 Jul 20262203000004330Turnaround
08 Jul 20261204000027608Preventive
07 Jul 20261201000039886Corrective
05 Jul 20261201000027956Corrective
21 Jun 20261204000024639Preventive
19 Jun 20261201000007604Corrective