Sparely
DU

TEE,1-1/2IN,SCH40,A234WPB,SW

Material 4100031148 · TEE · Plant 1000

BReorderNormalBelow reorder point
Material
4100031148
Category
TEE
Base unit
EA
MRP type
Stock Item
Criticality
B (5 of 14 FuncLocs A/B)
Supplier
PRIMA UTAMA PRATAMA PT
Lead time
20 d · P80 21 d
Unit price
Rp 922,183

Recommendation

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

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

Installed on 14 functional locations

5 with criticality A/B · 21 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_10-DS-4865-A11A-H
PIPE-10 FROM VD-1974D TO KC-293B
B220.44
PX_1-1/2-FG-14023-A22A
PIPE-1-1/2 FROM HE-418 TO VD-1291
B100.01
PX_1-1/2-HS-3852-A11A-T
PIPE-1-1/2 FROM PP-606D TO PP-1770
B100.01
PX_3-BF-24629-B21A
PIPE-3 FROM PP-535A TO CL-899
B100.01
PX_4-P-19213-A21A
PIPE-4 FROM HE-1901D TO PP-1752A
B100.01
PX_3/4-LS-9033-A51A-C
PIPE-3/4 FROM VD-826 TO PP-1909A
C120.44
PX_1-1/2-CW-16705-A51A-C
PIPE-1-1/2 FROM PP-200A TO PP-940C
C110.01
PX_1-FG-4299-B23A-C
PIPE-1 FROM KC-369B TO HE-888D
C100.01
PX_1-P-12689-B22A
PIPE-1 FROM PP-315A TO VD-664B
C100.01
PX_16-BF-25372-A22A-H
PIPE->16 FROM PP-1665 TO PP-1982A
C100.01
PX_3-FG-15752-A21A-T
PIPE-3 FROM KC-511C TO VD-422
C400.01
PX_4-CW-17491-C11A-T
PIPE-4 FROM HE-1334B TO CL-672
C100.01

Lead time and procurement

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

PR dateTypeQtyUnit priceDeliveryLead time
03 Sept 2026PR06
Regular replenishment
158Rp 933,76612 Sept 20269 d
03 Aug 2026PR03
Regular replenishment
179Rp 925,65318 Aug 202615 d
20 Jul 2026PR03
Regular replenishment
149Rp 895,97026 Jul 20266 d
17 Jul 2026PR03
Regular replenishment
53Rp 935,75416 Aug 202630 d
27 Jun 2026PR03
Regular replenishment
79Rp 911,92020 Jul 202623 d
26 Jun 2026PR03
Regular replenishment
71Rp 884,80816 Jul 202620 d
05 Jun 2026PR04
Regular (other)
191Rp 956,09626 Jun 202621 d
15 Apr 2026PR01
Import / long-lead
106Rp 912,91802 May 202617 d
23 Mar 2026PR03
Regular replenishment
52Rp 931,32509 Apr 202617 d
20 Mar 2026PR03
Regular replenishment
205Rp 926,19909 Apr 202620 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
19 Jul 2026MediumPX_10-DS-4865-A11A-HThickness measurement 10-DS-4865-A11A-H
26 Sept 2025LowPX_3/4-LS-9033-A51A-CReplace pipe 3/4-LS-9033-A51A-C
01 Jun 2025LowPX_1-1/2-CW-16705-A51A-CPainting 1-1/2-CW-16705-A51A-C
21 May 2025MediumPX_3/4-LS-9033-A51A-CLeak at 3/4-LS-9033-A51A-C
07 May 2025MediumPX_10-DS-4865-A11A-HThickness measurement 10-DS-4865-A11A-H

Recent goods issues

Posting dateQtyOrderOrder type
30 Sept 20261201000012309Corrective
24 Sept 20262201000006497Corrective
26 Aug 20263201000038696Corrective
02 Aug 20264201000008499Corrective
27 Jul 202610201000009720Corrective
10 Jul 202614209000029244Other maintenance
06 Jul 20266201000002411Corrective
05 Jul 20264201000025376Corrective
24 Jun 20263201000034485Corrective
19 Jun 20265201000024332Corrective
05 Jun 20261201000010759Corrective
31 May 20266201000003413Corrective
27 May 20263201000002230Corrective
26 May 20262201000010306Corrective
12 May 20261201000024375Corrective