Sparely
DU

CABLE,INSTRUMENT,2PR X 1.5MM2,ARMOURED

Material 4200008302 · CABLE · Plant 1000

AReorderNormalSlow-moving
Material
4200008302
Category
CABLE
Base unit
M
MRP type
Stock Item
Criticality
A (1 of 2 FuncLocs A/B)
Supplier
No PO history
Lead time
39 d · P80 63 d
Unit price
Rp 55,622 (est.)

Recommendation

  • 1.Forecast 2.4 M/year: 2.4 unplanned (credibility blend: own history + installed-base prior).
  • 2.Lead time ~39 days; expected demand during lead time 0.3.
  • 3.A 100.0% service level gives the lowest holding + downtime-risk cost: reorder at 10, order up to 20.
  • 4.On hand 1 + on order 0 is at or below the reorder point: order 19 now.
  • 5.Installed on 2 FuncLoc(s), 1 of them criticality A/B.
  • 6.Identical part 4200008641 holds spare stock: transfer 4 M instead of buying, then buy the remaining 15.
Proposed purchase requisition
15 M
Rp 834,330 · order by 01 Oct 2026
Expected arrival ≈ 39 days
Price estimatedLead time estimatedSame description as 1 other material number
On hand / on order
1 / 0
no open PO
Today Min / Max
1 / 3
static parameters in BoM
Rec. Min (reorder point)
10
safety stock 10
Rec. Max
20
order qty 10
Service level
100.0%
stockout risk now 3%
Unit price
Rp 55,622
Category + unit estimate
ML early warning: 11% probability this part is needed in the next 90 days (below the 30% warning threshold). Inputs: 0 issue days in the last 180 days, last issue 218 days ago, 0 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 0 PRs in 180 days.

Consumption history and 12-month forecast

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

Demand pattern Single issue · 1 issue days · method: Credibility blend: own history + installed-base prior.

Cost of each service level

Annual holding vs downtime-risk cost for this part

Not stocking at all would cost Rp 108.6M/yr in expected downtime and emergency buys. A stockout here stops production with probability 1.07% for ~21 days.

Installed on 2 functional locations

1 with criticality A/B · 0.64 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_JBX-321
JUNCTION BOX
A0.3200.01
PX_JBX-1314
JUNCTION BOX
C0.3200.01

Lead time and procurement

Lead time 39 ± 25 days (Category estimate, 0 PO lines) · on-time –

No purchase history: price and lead time are estimated from parts of the same category.

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
25 Feb 202610201000013131Corrective