Sparely
DU

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

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-1798C-CSS
CONTROL SWITCH STATION FOR PP-1798C-M
B100.19
PY_3368-2281B-F29
MARSHALLING TERMINAL
B100.01
PX_PP-1177-CSS
CONTROL SWITCH STATION FOR PP-1177-M
C300.19
PX_PP-1785A-CSS
CONTROL SWITCH STATION FOR PP-1785A-M
C400.19
PX_PP-217-CSS
CONTROL SWITCH STATION FOR PP-217-M
C100.19

Lead time and procurement

Lead time 24 ± 10 days (PO history, 28 PO lines) · on-time 46%

PR dateTypeQtyUnit priceDeliveryLead time
28 Aug 2026PR06
Regular replenishment
13Rp 117,81819 Sept 202622 d
25 Aug 2026PR03
Regular replenishment
37Rp 118,71210 Sept 202616 d
11 Aug 2026PR03
Regular replenishment
48Rp 116,49723 Aug 202612 d
11 Aug 2026PR03
Regular replenishment
20Rp 118,35526 Aug 202615 d
03 Aug 2026PR03
Regular replenishment
26Rp 113,82824 Aug 202621 d
21 Jul 2026PR03
Regular replenishment
14Rp 117,46005 Aug 202615 d
10 Jul 2026PR03
Regular replenishment
42Rp 109,81527 Jul 202617 d
21 Mar 2026PR04
Regular (other)
15Rp 112,10916 Apr 202626 d
09 Mar 2026PR03
Regular replenishment
13Rp 115,42528 Mar 202619 d
18 Feb 2026PR03
Regular replenishment
43Rp 117,76824 Mar 202634 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 dateQtyOrderOrder type
30 Sept 20263201000024007Corrective
30 Sept 20261201000026532Corrective
26 Sept 20261201000013974Corrective
27 Aug 20261201000001746Corrective
27 Jul 20261201000017737Corrective
26 Jul 20261201000024842Corrective
24 Jul 20263201000024842Corrective
23 Jul 20262201000004861Corrective
06 Jul 20263201000020872Corrective
21 Jun 20261209000016742Other maintenance
11 Jun 20262201000016926Corrective
08 Jun 20261201000010036Corrective
05 Jun 20263201000005500Corrective
03 Jun 20261201000022908Corrective
12 May 20261201000027569Corrective