Sparely
DU

SCREW,TAPPING,M6X16MM,SS304

Material 4100098225 · SCREW · Plant 1000

AReorderCriticalStockout
Material
4100098225
Category
SCREW
Base unit
EA
MRP type
Stock Item
Criticality
A (3 of 5 FuncLocs A/B)
Supplier
RAJAWALI INSTRUMEN INTERNASIONAL PT
Lead time
20 d · P80 25 d
Unit price
Rp 1,780

Recommendation

  • 1.Forecast 1,382 EA/year: 1,382 unplanned (recency-weighted compound poisson (own history)).
  • 2.Lead time ~20 days; expected demand during lead time 75.
  • 3.A 100.0% service level gives the lowest holding + downtime-risk cost: reorder at 465, order up to 1,847.
  • 4.On hand 0 + on order 0 is at or below the reorder point: order 1,847 now.
  • 5.Installed on 5 FuncLoc(s), 3 of them criticality A/B.
  • 6.ML early warning: 98% probability of demand in the next 90 days.
Proposed purchase requisition
1,847 EA
Rp 3.3M · order by 01 Oct 2026
Expected arrival ≈ 20 days
ML early warningLast turnaround used 190Single sourceAbnormal consumption
On hand / on order
0 / 0
no open PO
Today Min / Max
265 / 687
static parameters in BoM
Rec. Min (reorder point)
465
safety stock 391
Rec. Max
1,847
order qty 1,382
Service level
100.0%
stockout risk now 55%
Unit price
Rp 1,780
PO history
ML early warning: 98% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 7 issue days in the last 180 days, last issue 66 days ago, 22 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 8 PRs in 180 days.

Consumption history and 12-month forecast

Units per month. Turnaround issues (1,190 units) excluded from the baseline.

Demand pattern Erratic · 24 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 3.2B/yr in expected downtime and emergency buys. A stockout here stops production with probability 1.07% for ~10 days.

Installed on 5 functional locations

3 with criticality A/B · 10,294 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_BF-103
CRACKING FURNACE BF-103
A503814.58
PX_JBX-1777A
JUNCTION BOX
A12000.01
PX_JBX-977B
JUNCTION BOX
B5,03700.01
PX_JBX-1817B
JUNCTION BOX
C5,03720.44
PX_BF-110
CRACKING FURNACE BF-110
S504114.58

Lead time and procurement

Lead time 20 ± 9 days (PO history, 20 PO lines) · on-time 39%

PR dateTypeQtyUnit priceDeliveryLead time
31 Aug 2026PR03
Regular replenishment
1,297Rp 1,72329 Sept 202629 d
19 Aug 2026PR03
Regular replenishment
821Rp 1,73802 Sept 202614 d
20 Jun 2026PR03
Regular replenishment
2,001Rp 1,82927 Jun 20267 d
06 Jun 2026PR03
Regular replenishment
1,099Rp 1,76220 Jun 202614 d
13 May 2026PR06
Regular replenishment
540Rp 1,76307 Jun 202625 d
05 May 2026PR03
Regular replenishment
656Rp 1,78428 May 202623 d
24 Apr 2026PR06
Regular replenishment
1,520Rp 1,78526 May 202632 d
09 Apr 2026PR03
Regular replenishment
766Rp 1,80802 May 202623 d
17 Mar 2026PR03
Regular replenishment
901Rp 1,78730 Mar 202613 d
23 Feb 2026PR06
Regular replenishment
863Rp 1,71906 Mar 202611 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
30 Sept 2026LowPX_BF-103Leak from packing
21 Sept 2026MediumPX_BF-110Replace burner tip BF-110
20 Sept 2026MediumPX_BF-103Leak from packing
19 Sept 2026LowPX_BF-103Leak from packing
17 Sept 2026MediumPX_BF-110Install scaffolding at BF-110
15 Sept 2026MediumPX_BF-103Replace lamp as per PM finding
15 Sept 2026MediumPX_BF-110Decoking follow up BF-110
11 Sept 2026MediumPX_BF-103Decoking follow up BF-103
11 Sept 2026MediumPX_BF-110Leak from packing
03 Sept 2026LowPX_BF-110Hot spot at convection BF-110

Recent goods issues

Posting dateQtyOrderOrder type
27 Jul 202620201000027402Corrective
27 Jul 202620201000028062Corrective
15 Jul 2026100201000016400Corrective
12 Jun 202650201000028320Corrective
06 Jun 2026100209000018653Other maintenance
18 May 202650201000039669Corrective
28 Apr 202650201000002499Corrective
22 Apr 2026200201000007143Corrective
18 Feb 2026100201000026224Corrective
12 Feb 202650201000032040Corrective
22 Jan 202620201000017359Corrective
05 Jan 202650201000011128Corrective
03 Jan 20261,000201000014604Corrective
22 Dec 2025200201000022442Corrective
17 Dec 202550203000039452Turnaround