Sparely
DU

CABLE,INSTRUMENT,4PR X 0.75MM2,ARMOURED

Material 4200008235 · CABLE · Plant 1000

CReorderNormalBelow reorder point
Material
4200008235
Category
CABLE
Base unit
M
MRP type
Stock Item
Criticality
C (0 of 3 FuncLocs A/B)
Supplier
TIRTA SUPLINDO NUSANTARA PT
Lead time
32 d · P80 41 d
Unit price
Rp 42,461

Recommendation

  • 1.Forecast 148 M/year: 148 unplanned (recency-weighted compound poisson (own history)).
  • 2.Lead time ~32 days; expected demand during lead time 13.
  • 3.A 96.3% service level gives the lowest holding + downtime-risk cost: reorder at 44, order up to 193.
  • 4.On hand 21 + on order 0 is at or below the reorder point: order 172 now.
Proposed purchase requisition
172 M
Rp 7.3M · order by 01 Oct 2026
Expected arrival ≈ 32 days
Single sourceAbnormal consumption
On hand / on order
21 / 0
no open PO
Today Min / Max
7 / 12
static parameters in BoM
Rec. Min (reorder point)
44
safety stock 31
Rec. Max
193
order qty 149
Service level
96.3%
stockout risk now 26%
Unit price
Rp 42,461
PO history
ML early warning: 22% probability this part is needed in the next 90 days (below the 30% warning threshold). Inputs: 2 issue days in the last 180 days, last issue 4 days ago, 0 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 1 PRs in 180 days.

Consumption history and 12-month forecast

Units per month. Turnaround issues (0 units) excluded from the baseline.

Demand pattern Lumpy · 6 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 33.8M/yr in expected downtime and emergency buys. A stockout here stops production with probability 0.16% for ~21 days.

Installed on 3 functional locations

0 with criticality A/B · 6 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_JBX-222
JUNCTION BOX (EXP)
C2.500.01
PY_3971-3955A-F20
FIELD DEVICE
C100.01
PY_6868-7907B-F11-A
SPARE SLOT
C2.500.01

Lead time and procurement

Lead time 32 ± 16 days (PO history, 6 PO lines) · on-time 42%

PR dateTypeQtyUnit priceDeliveryLead time
16 Jul 2026PR06
Regular replenishment
47Rp 42,76506 Aug 202621 d
06 Feb 2026PR03
Regular replenishment
99Rp 42,15623 Feb 202617 d
01 Jan 2026PR03
Regular replenishment
127Rp 40,72714 Feb 202644 d
11 Aug 2025PR03
Regular replenishment
55Rp 43,66909 Sept 202529 d
29 Jun 2025PR06
Regular replenishment
101Rp 41,03409 Aug 202541 d
31 May 2025PR06
Regular replenishment
147Rp 43,04523 Jun 202523 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

No notifications on the equipment this part is installed on.

Recent goods issues

Posting dateQtyOrderOrder type
27 Sept 202650204000019919Preventive
20 Jul 202650201000021863Corrective
18 Dec 202550201000025606Corrective
18 Dec 2025100201000025606Corrective
17 Nov 202510201000029205Corrective
12 Aug 202520201000039661Corrective
11 Aug 202520201000039661Corrective