Sparely
DU

SCREW,TAPPING,M3X16MM,SS304

Material 4100098169 · SCREW · Plant 1000

AReduceExcess
Material
4100098169
Category
SCREW
Base unit
EA
MRP type
Stock Item
Criticality
A (6 of 11 FuncLocs A/B)
Supplier
RAJAWALI INSTRUMEN INTERNASIONAL PT
Lead time
25 d · P80 32 d
Unit price
Rp 311

Recommendation

  • 1.Forecast 3,233 EA/year: 3,233 unplanned (recency-weighted compound poisson (own history)).
  • 2.Lead time ~25 days; expected demand during lead time 225.
  • 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 819, order up to 4,053.
  • 4.Stock 4,748 exceeds the level to keep (4,053) by 695.
  • 5.Installed on 11 FuncLoc(s), 6 of them criticality A/B.
  • 6.ML early warning: 99% probability of demand in the next 90 days.
ML early warningLast turnaround used 870Single sourceAbnormal consumptionSame description as 2 other material numbers
On hand / on order
4,748 / 0
no open PO
Today Min / Max
1,610 / 3,344
static parameters in BoM
Rec. Min (reorder point)
819
safety stock 595
Rec. Max
4,053
order qty 3,234
Service level
99.9%
stockout risk now 0%
Unit price
Rp 311
PO history
ML early warning: 99% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 8 issue days in the last 180 days, last issue 18 days ago, 73 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 (1,010 units) excluded from the baseline.

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

Installed on 11 functional locations

6 with criticality A/B · 21,661 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_BF-106
CRACKING FURNACE BF-106
A1,5008230.86
PX_BF-112
CRACKING FURNACE BF-112
A1,5007327.01
PX_BF-102
CRACKING FURNACE BF-102
A507128.72
PX_BF-109
CRACKING FURNACE BF-109
A5,0372911.58
PX_BF-107
CRACKING FURNACE BF-107
A50239.01
PX_BF-111
CRACKING FURNACE BF-111
A1,500239.01
PX_JBX-279
JUNCTION BOX
C5010.01
PX_JBX-1190A
JUNCTION BOX
C5,03700.01
PX_JBX-1364
JUNCTION BOX (EXP)
C40000.01
PX_JBX-938A
JUNCTION BOX
C1,50000.01
PX_BF-110
CRACKING FURNACE BF-110
S5,0374114.58

Lead time and procurement

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

PR dateTypeQtyUnit priceDeliveryLead time
21 Aug 2026PR03
Regular replenishment
6,979Rp 30613 Sept 202623 d
18 Aug 2026PR06
Regular replenishment
4,302Rp 31328 Aug 202610 d
28 Jun 2026PR03
Regular replenishment
4,614Rp 30631 Jul 202633 d
30 Dec 2025PR06
Regular replenishment
3,176Rp 30922 Jan 202623 d
08 Dec 2025PR03
Regular replenishment
2,620Rp 31928 Dec 202520 d
11 Nov 2025PR03
Regular replenishment
7,649Rp 30212 Dec 202531 d
17 Sept 2025PR04
Regular (other)
8,553Rp 30826 Oct 202539 d
10 Sept 2025PR03
Regular replenishment
7,143Rp 31808 Oct 202528 d
22 Aug 2025PR06
Regular replenishment
2,803Rp 31323 Sept 202532 d
05 Aug 2025PR03
Regular replenishment
5,359Rp 30917 Sept 202543 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 2026MediumPX_BF-112Install cover plate BF-112
29 Sept 2026MediumPX_BF-106Decoking follow up BF-106
29 Sept 2026MediumPX_BF-106Decoking follow up BF-106
29 Sept 2026LowPX_BF-112Painting BF-112
28 Sept 2026LowPX_BF-106Peep door broken BF-106
27 Sept 2026MediumPX_BF-112Repair insulation BF-112
24 Sept 2026LowPX_BF-107Install scaffolding at BF-107
23 Sept 2026LowPX_BF-102Replace burner tip BF-102
22 Sept 2026MediumPX_BF-111Install cover plate BF-111
21 Sept 2026MediumPX_BF-110Replace burner tip BF-110

Recent goods issues

Posting dateQtyOrderOrder type
13 Sept 202650204000000772Preventive
23 Aug 202620201000010546Corrective
21 Aug 2026200201000000652Corrective
11 Aug 20265,000204000010836Preventive
10 Jul 202650201000002156Corrective
01 Jul 20261,000201000017983Corrective
22 Jun 2026200209000014083Other maintenance
18 Apr 2026100201000006270Corrective
14 Mar 202650204000017829Preventive
09 Mar 2026100201000024115Corrective
15 Feb 202620201000004102Corrective
15 Feb 2026100201000034114Corrective
29 Jan 202650201000038273Corrective
19 Jan 202650201000022831Corrective
13 Jan 202650201000005022Corrective