Sparely
DU

LAMP,LED,9W,220VAC,FLOOD

Material 4200004733 · LAMP · Plant 1000

BMonitorHealthy
Material
4200004733
Category
LAMP
Base unit
EA
MRP type
Stock Item
Criticality
B (1 of 3 FuncLocs A/B)
Supplier
BINTANG SUPLINDO GLOBAL PT
Lead time
59 d · P80 79 d
Unit price
Rp 171,621

Recommendation

  • 1.Forecast 36 EA/year: 36 unplanned (recency-weighted compound poisson (own history)).
  • 2.Lead time ~59 days; expected demand during lead time 5.8.
  • 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 19, order up to 55.
  • 4.Installed on 3 FuncLoc(s), 1 of them criticality A/B.
  • 5.ML early warning: 100% probability of demand in the next 90 days.
ML early warningLast turnaround used 3Single sourceOpen PO
On hand / on order
10 / 22
next delivery 03 Oct 2026
Today Min / Max
9 / 20
static parameters in BoM
Rec. Min (reorder point)
19
safety stock 14
Rec. Max
55
order qty 36
Service level
99.9%
stockout risk now 0%
Unit price
Rp 171,621
PO history
ML early warning: 100% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 15 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, 4 PRs in 180 days.

Consumption history and 12-month forecast

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

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

Installed on 3 functional locations

1 with criticality A/B · 5 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_PP-103-CSS
CONTROL SWITCH STATION FOR PP-103-M
B100.19
PY_4038-3317-F13
FUEL OIL LINE
C100.01
PY_9952-5894-F26-A
CHARGE GAS LINE
C300.01

Lead time and procurement

Lead time 59 ± 29 days (PO history, 14 PO lines) · on-time 29%

PR dateTypeQtyUnit priceDeliveryLead time
29 Aug 2026PR03
Regular replenishment
22Rp 170,46503 Oct 2026
open
35 d
22 Jul 2026PR03
Regular replenishment
21Rp 167,28307 Sept 202647 d
08 Jun 2026PR03
Regular replenishment
23Rp 180,55703 Aug 202656 d
13 May 2026PR04
Regular (other)
13Rp 170,96204 Jul 202652 d
15 Mar 2026PR06
Regular replenishment
25Rp 179,85028 Apr 202644 d
07 Mar 2026PR03
Regular replenishment
14Rp 168,74204 Aug 2026150 d
23 Feb 2026PR03
Regular replenishment
20Rp 179,21730 Apr 202666 d
03 Feb 2026PR03
Regular replenishment
24Rp 181,36922 Apr 202678 d
22 Dec 2025PR06
Regular replenishment
20Rp 178,61401 Feb 202641 d
06 Nov 2025PR06
Regular replenishment
13Rp 172,03326 Jan 202681 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 20261201000012524Corrective
16 Sept 20261209000036917Other maintenance
08 Sept 20261201000021806Corrective
03 Sept 20262201000014482Corrective
28 Aug 20261201000038773Corrective
25 Aug 20262201000039454Corrective
24 Aug 20262201000000994Corrective
14 Aug 20261201000036163Corrective
05 Aug 20262201000010969Corrective
22 Jul 20261201000005856Corrective
21 Jul 20261201000021863Corrective
09 Jul 20261201000026179Corrective
23 Jun 20261209000014083Other maintenance
04 Jun 20261201000011358Corrective
06 May 20261201000019152Corrective
Sparely