Sparely
DU

LAMP,LED,36W,220VAC,FLOOD

Material 4200004765 · LAMP · Plant 1000

BReduceExcess
Material
4200004765
Category
LAMP
Base unit
EA
MRP type
Stock Item
Criticality
B (1 of 1 FuncLocs A/B)
Supplier
MITRA PERKASA PRATAMA PT
Lead time
47 d · P80 61 d
Unit price
Rp 867,905

Recommendation

  • 1.Forecast 20 EA/year: 20 unplanned (recency-weighted compound poisson (own history)).
  • 2.Lead time ~47 days; expected demand during lead time 2.6.
  • 3.A 99.8% service level gives the lowest holding + downtime-risk cost: reorder at 9, order up to 28.
  • 4.Stock 33 exceeds the level to keep (28) by 5.
  • 5.Installed on 1 FuncLoc(s), 1 of them criticality A/B.
  • 6.ML early warning: 97% probability of demand in the next 90 days.
ML early warningLast turnaround used 1Single sourceAbnormal consumptionOpen PO
On hand / on order
33 / 7
next delivery 08 Nov 2026
Today Min / Max
10 / 28
static parameters in BoM
Rec. Min (reorder point)
9
safety stock 7
Rec. Max
28
order qty 19
Service level
99.8%
stockout risk now 0%
Unit price
Rp 867,905
PO history
ML early warning: 97% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 6 issue days in the last 180 days, last issue 28 days ago, 0 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 3 PRs in 180 days.

Consumption history and 12-month forecast

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

Demand pattern Lumpy · 23 issue days · 1 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 1.4B/yr in expected downtime and emergency buys. A stockout here stops production with probability 0.53% for ~19 days.

Installed on 1 functional locations

1 with criticality A/B · 1 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-1837A-CSS
CONTROL SWITCH STATION FOR PP-1837A-M
B100.19

Lead time and procurement

Lead time 47 ± 18 days (PO history, 12 PO lines) · on-time 46%

PR dateTypeQtyUnit priceDeliveryLead time
16 Aug 2026PR03
Regular replenishment
7Rp 858,01908 Nov 2026
open
84 d
14 Jul 2026PR03
Regular replenishment
9Rp 871,97512 Aug 202629 d
14 Jun 2026PR03
Regular replenishment
10Rp 858,97216 Jul 202632 d
22 Feb 2026PR03
Regular replenishment
16Rp 873,90202 Apr 202639 d
07 Feb 2026PR03
Regular replenishment
13Rp 886,26109 Mar 202630 d
21 Nov 2025PR06
Regular replenishment
14Rp 880,50007 Jan 202647 d
29 Oct 2025PR03
Regular replenishment
10Rp 903,74805 Jan 202668 d
18 Oct 2025PR03
Regular replenishment
9Rp 889,14324 Nov 202537 d
03 Sept 2025PR05
Project / turnaround
4Rp 862,68816 Oct 202543 d
25 Aug 2025PR01
Import / long-lead
5Rp 854,94526 Oct 202562 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
03 Sept 20261204000008731Preventive
19 Jun 20261209000016742Other maintenance
18 May 20261209000009186Other maintenance
07 May 20261201000016546Corrective
24 Apr 20262201000002634Corrective
05 Apr 20263201000010228Corrective
03 Mar 20262201000011654Corrective
18 Feb 20262201000029237Corrective
09 Feb 20261203000032991Turnaround
27 Jan 20262201000020819Corrective
25 Jan 20261201000010544Corrective
18 Jan 20261201000009933Corrective
15 Jan 20264201000015012Corrective
06 Jan 20262201000030617Corrective
05 Jan 20261201000011361Corrective