Sparely
DU

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

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-1070B-CSS
CONTROL SWITCH STATION FOR PP-1070B-M
A100.19
PX_PP-1764-CSS
CONTROL SWITCH STATION FOR PP-1764-M
A200.19
PX_PP-1657A-CSS
CONTROL SWITCH STATION FOR PP-1657A-M
B100.19
PX_PP-1862-CSS
CONTROL SWITCH STATION FOR PP-1862-M
B100.19
PY_2273-1644A-F19-B
FLUSHING OIL LINE
B100.01
PX_PP-703B-CSS
CONTROL SWITCH STATION FOR PP-703B-M
C141.47
PX_PP-795D-CSS
CONTROL SWITCH STATION FOR PP-795D-M
C100.19
PX_PP-883B-CSS
CONTROL SWITCH STATION FOR PP-883B-M
C100.19
PY_3711-9592B-F15-B
BFW LINE
C200.01

Lead time and procurement

Lead time 50 ± 33 days (PO history, 16 PO lines) · on-time 50%

PR dateTypeQtyUnit priceDeliveryLead time
11 Aug 2026PR06
Regular replenishment
22Rp 493,04430 Aug 202619 d
05 Aug 2026PR06
Regular replenishment
18Rp 492,80931 Aug 202626 d
11 Jul 2026PR03
Regular replenishment
26Rp 490,03506 Sept 202657 d
14 Jun 2026PR06
Regular replenishment
26Rp 531,51401 Aug 202648 d
01 Jun 2026PR03
Regular replenishment
21Rp 492,32709 Jul 202638 d
11 Mar 2026PR06
Regular replenishment
18Rp 512,91004 Apr 202624 d
10 Feb 2026PR06
Regular replenishment
8Rp 502,48603 Apr 202652 d
22 Dec 2025PR06
Regular replenishment
10Rp 498,35825 Jan 202634 d
30 Nov 2025PR03
Regular replenishment
11Rp 502,14310 Feb 202672 d
07 Oct 2025PR06
Regular replenishment
28Rp 521,52331 Oct 202524 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
29 Aug 2026MediumPX_PP-703B-CSSInstall scaffolding at PP-703B-CSS
28 Jul 2026LowPX_PP-703B-CSSReplace lamp as per PM finding
28 Oct 2025LowPX_PP-703B-CSSReplace lamp as per PM finding
08 Jun 2025MediumPX_PP-703B-CSSLeak from packing

Recent goods issues

Posting dateQtyOrderOrder type
28 Sept 20261201000028780Corrective
19 Sept 20261201000033682Corrective
18 Sept 20261201000003432Corrective
01 Sept 20262201000023287Corrective
21 Jul 20261201000011349Corrective
10 Jul 20261201000002156Corrective
10 Jul 20261209000029244Other maintenance
27 Jun 20261209000028044Other maintenance
14 Jun 20261201000035403Corrective
18 Apr 20261201000006270Corrective
28 Feb 20261201000006302Corrective
20 Feb 20261201000028494Corrective
17 Feb 20261201000026224Corrective
17 Feb 20261205000022444Other maintenance
11 Feb 20261203000018609Turnaround