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
| FuncLoc | Crit. | Installed | Notifications | Failures / yr |
|---|---|---|---|---|
| PX_BF-112 CRACKING FURNACE BF-112 | A | 5,037 | 73 | 27.01 |
| PX_BF-109 CRACKING FURNACE BF-109 | A | 1,500 | 29 | 11.58 |
| PX_JBX-473C JUNCTION BOX (EXP) | C | 1,500 | 0 | 0.01 |
Lead time and procurement
Lead time 23 ± 17 days (PO history, 12 PO lines) · on-time 39%
| PR date | Type | Qty | Unit price | Delivery | Lead time |
|---|---|---|---|---|---|
| 12 Jul 2026 | PR06 Regular replenishment | 3,331 | Rp 1,427 | 28 Jul 2026 | 16 d |
| 17 Apr 2026 | PR06 Regular replenishment | 3,952 | Rp 1,470 | 02 May 2026 | 15 d |
| 29 Mar 2026 | PR01 Import / long-lead | 2,538 | Rp 1,525 | 24 Apr 2026 | 26 d |
| 09 Mar 2026 | PR03 Regular replenishment | 3,676 | Rp 1,420 | 20 Mar 2026 | 11 d |
| 26 Feb 2026 | PR06 Regular replenishment | 1,257 | Rp 1,450 | 15 Mar 2026 | 17 d |
| 14 Dec 2025 | PR06 Regular replenishment | 3,972 | Rp 1,458 | 26 Dec 2025 | 12 d |
| 30 Sept 2025 | PR04 Regular (other) | 3,363 | Rp 1,487 | 15 Oct 2025 | 15 d |
| 04 Sept 2025 | PR03 Regular replenishment | 2,772 | Rp 1,444 | 21 Nov 2025 | 78 d |
| 21 Aug 2025 | PR04 Regular (other) | 1,335 | Rp 1,443 | 13 Sept 2025 | 23 d |
| 18 Jun 2025 | PR03 Regular replenishment | 2,774 | Rp 1,404 | 03 Jul 2025 | 15 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
| Date | Priority | FuncLoc | Description |
|---|---|---|---|
| 30 Sept 2026 | Medium | PX_BF-112 | Install cover plate BF-112 |
| 29 Sept 2026 | Low | PX_BF-112 | Painting BF-112 |
| 27 Sept 2026 | Medium | PX_BF-112 | Repair insulation BF-112 |
| 20 Sept 2026 | Medium | PX_BF-109 | Thermograph wall BF-109 |
| 17 Sept 2026 | Medium | PX_BF-112 | Cleaning burner BF-112 |
| 13 Sept 2026 | Medium | PX_BF-109 | Install scaffolding at BF-109 |
| 04 Sept 2026 | High | PX_BF-112 | Install scaffolding at BF-112 |
| 03 Sept 2026 | Low | PX_BF-109 | Install scaffolding at BF-109 |
| 02 Sept 2026 | Low | PX_BF-109 | Install cover plate for MCP cracking |
| 01 Sept 2026 | Medium | PX_BF-112 | Replace burner tip BF-112 |
Recent goods issues
| Posting date | Qty | Order | Order type |
|---|---|---|---|
| 24 May 2026 | 100 | 201000012062 | Corrective |
| 27 Mar 2026 | 20 | 201000032373 | Corrective |
| 24 Feb 2026 | 200 | 204000028926 | Preventive |
| 16 Feb 2026 | 200 | 201000036997 | Corrective |
| 11 Jan 2026 | 200 | 201000025650 | Corrective |
| 07 Jan 2026 | 50 | 201000005981 | Corrective |
| 30 Dec 2025 | 50 | 201000013760 | Corrective |
| 29 Dec 2025 | 50 | 201000035558 | Corrective |
| 19 Dec 2025 | 5,000 | 209000020420 | Other maintenance |
| 06 Dec 2025 | 200 | 201000025177 | Corrective |
| 30 Nov 2025 | 50 | 203000014368 | Turnaround |
| 07 Nov 2025 | 100 | 203000029164 | Turnaround |
| 07 Nov 2025 | 500 | 203000039046 | Turnaround |
| 19 Oct 2025 | 500 | 201000039363 | Corrective |
| 18 Oct 2025 | 50 | 201000008221 | Corrective |