Sparely
DU

PIPE,1-1/2IN,SCH80,P11,SMLS,6M LG

Material 4100027918 · PIPE · Plant 1000

AReorderNormalBelow reorder point
Material
4100027918
Category
PIPE
Base unit
LG
MRP type
Stock Item
Criticality
A (3 of 4 FuncLocs A/B)
Supplier
PRIMA LOGAM NUSANTARA PT
Lead time
23 d · P80 26 d
Unit price
Rp 2.7M

Recommendation

  • 1.Forecast 40 LG/year: 40 unplanned (recency-weighted compound poisson (own history)).
  • 2.Lead time ~23 days; expected demand during lead time 2.5.
  • 3.A 99.8% service level gives the lowest holding + downtime-risk cost: reorder at 12, order up to 27.
  • 4.On hand 12 + on order 0 is at or below the reorder point: order 15 now.
  • 5.Installed on 4 FuncLoc(s), 3 of them criticality A/B.
  • 6.ML early warning: 88% probability of demand in the next 90 days.
Proposed purchase requisition
15 LG
Rp 40.5M · order by 01 Oct 2026
Expected arrival ≈ 23 days
ML early warningLast turnaround used 36Single sourceAbnormal consumption
On hand / on order
12 / 0
no open PO
Today Min / Max
10 / 17
static parameters in BoM
Rec. Min (reorder point)
12
safety stock 10
Rec. Max
27
order qty 15
Service level
99.8%
stockout risk now 0%
Unit price
Rp 2.7M
PO history
ML early warning: 88% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 6 issue days in the last 180 days, last issue 14 days ago, 21 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 (36 units) excluded from the baseline.

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

Installed on 4 functional locations

3 with criticality A/B · 21 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_BF-105
CRACKING FURNACE BF-105
A1211442.86
PX_HE-605
WASH WATER EXCHANGER
A600.22
PX_HE-1121A
FEED COOLER
B100.22
PX_4-LS-22894-A21A-HS
PIPE-4 FROM PP-978 TO PP-1407B
C200.01

Lead time and procurement

Lead time 23 ± 11 days (PO history, 7 PO lines) · on-time 34%

PR dateTypeQtyUnit priceDeliveryLead time
24 Jun 2026PR03
Regular replenishment
30Rp 2.6M20 Jul 202626 d
05 Jun 2026PR03
Regular replenishment
13Rp 2.7M18 Jun 202613 d
26 Mar 2026PR04
Regular (other)
32Rp 2.7M27 Apr 202632 d
17 Jan 2026PR03
Regular replenishment
28Rp 2.8M12 Feb 202626 d
25 Sept 2025PR03
Regular replenishment
13Rp 2.7M14 Oct 202519 d
11 Jun 2025PR03
Regular replenishment
13Rp 2.7M28 Jun 202517 d
12 May 2025PR03
Regular replenishment
40Rp 2.7M21 May 20259 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
29 Sept 2026HighPX_BF-105Repair refractory crack BF-105
20 Sept 2026MediumPX_BF-105Replace lamp as per PM finding
20 Sept 2026MediumPX_BF-105Install scaffolding at BF-105
14 Sept 2026LowPX_BF-105Install cover plate BF-105
13 Sept 2026MediumPX_BF-105Thermograph wall BF-105
06 Sept 2026MediumPX_BF-105Repair insulation BF-105
01 Sept 2026LowPX_BF-105Peep door broken BF-105
30 Aug 2026MediumPX_BF-105Painting BF-105
29 Aug 2026MediumPX_BF-105Leak from packing
27 Aug 2026MediumPX_BF-105Thermograph wall BF-105

Recent goods issues

Posting dateQtyOrderOrder type
17 Sept 20262201000015263Corrective
13 Aug 202610201000031702Corrective
10 Aug 20261201000013923Corrective
22 Jul 20265201000024568Corrective
10 Jul 20261201000002156Corrective
09 Jun 20263201000002348Corrective
15 Feb 20261204000026249Preventive
06 Jan 20263201000004451Corrective
06 Jan 20261201000021527Corrective
05 Jan 20262201000004451Corrective
31 Dec 20252201000025718Corrective
04 Dec 202512203000037280Turnaround
09 Nov 20259203000004034Turnaround
07 Nov 20259203000039046Turnaround
05 Nov 20256203000039255Turnaround