Sparely
DU

SCREW,TAPPING,M4X10MM,SS304

Material 4100098191 · SCREW · Plant 1000

AReduceExcess
Material
4100098191
Category
SCREW
Base unit
EA
MRP type
Stock Item
Criticality
A (2 of 3 FuncLocs A/B)
Supplier
RAJAWALI INSTRUMEN INTERNASIONAL PT
Lead time
23 d · P80 25 d
Unit price
Rp 1,454

Recommendation

  • 1.Forecast 1,850 EA/year: 1,850 unplanned (recency-weighted compound poisson (own history)).
  • 2.Lead time ~23 days; expected demand during lead time 116.
  • 3.A 99.9% service level gives the lowest holding + downtime-risk cost: reorder at 716, order up to 2,566.
  • 4.Stock 95,432 exceeds the level to keep (2,566) by 92,866.
  • 5.Installed on 3 FuncLoc(s), 2 of them criticality A/B.
Last turnaround used 650Single sourceAbnormal consumption
On hand / on order
95,432 / 0
no open PO
Today Min / Max
936 / 2,568
static parameters in BoM
Rec. Min (reorder point)
716
safety stock 600
Rec. Max
2,566
order qty 1,850
Service level
99.9%
stockout risk now 0%
Unit price
Rp 1,454
PO history
ML early warning: 16% probability this part is needed in the next 90 days (below the 30% warning threshold). Inputs: 1 issue days in the last 180 days, last issue 130 days ago, 16 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 2 PRs in 180 days.

Consumption history and 12-month forecast

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

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

Installed on 3 functional locations

2 with criticality A/B · 8,037 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_BF-112
CRACKING FURNACE BF-112
A5,0377327.01
PX_BF-109
CRACKING FURNACE BF-109
A1,5002911.58
PX_JBX-473C
JUNCTION BOX (EXP)
C1,50000.01

Lead time and procurement

Lead time 23 ± 17 days (PO history, 12 PO lines) · on-time 39%

PR dateTypeQtyUnit priceDeliveryLead time
12 Jul 2026PR06
Regular replenishment
3,331Rp 1,42728 Jul 202616 d
17 Apr 2026PR06
Regular replenishment
3,952Rp 1,47002 May 202615 d
29 Mar 2026PR01
Import / long-lead
2,538Rp 1,52524 Apr 202626 d
09 Mar 2026PR03
Regular replenishment
3,676Rp 1,42020 Mar 202611 d
26 Feb 2026PR06
Regular replenishment
1,257Rp 1,45015 Mar 202617 d
14 Dec 2025PR06
Regular replenishment
3,972Rp 1,45826 Dec 202512 d
30 Sept 2025PR04
Regular (other)
3,363Rp 1,48715 Oct 202515 d
04 Sept 2025PR03
Regular replenishment
2,772Rp 1,44421 Nov 202578 d
21 Aug 2025PR04
Regular (other)
1,335Rp 1,44313 Sept 202523 d
18 Jun 2025PR03
Regular replenishment
2,774Rp 1,40403 Jul 202515 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 2026LowPX_BF-112Painting BF-112
27 Sept 2026MediumPX_BF-112Repair insulation BF-112
20 Sept 2026MediumPX_BF-109Thermograph wall BF-109
17 Sept 2026MediumPX_BF-112Cleaning burner BF-112
13 Sept 2026MediumPX_BF-109Install scaffolding at BF-109
04 Sept 2026HighPX_BF-112Install scaffolding at BF-112
03 Sept 2026LowPX_BF-109Install scaffolding at BF-109
02 Sept 2026LowPX_BF-109Install cover plate for MCP cracking
01 Sept 2026MediumPX_BF-112Replace burner tip BF-112

Recent goods issues

Posting dateQtyOrderOrder type
24 May 2026100201000012062Corrective
27 Mar 202620201000032373Corrective
24 Feb 2026200204000028926Preventive
16 Feb 2026200201000036997Corrective
11 Jan 2026200201000025650Corrective
07 Jan 202650201000005981Corrective
30 Dec 202550201000013760Corrective
29 Dec 202550201000035558Corrective
19 Dec 20255,000209000020420Other maintenance
06 Dec 2025200201000025177Corrective
30 Nov 202550203000014368Turnaround
07 Nov 2025100203000029164Turnaround
07 Nov 2025500203000039046Turnaround
19 Oct 2025500201000039363Corrective
18 Oct 202550201000008221Corrective
Sparely