Sparely
DU

ANTIRUST,SPRAY TYPE,400ML/CAN,TYPE-B

Material 4100101678 · ANTIRUST · Plant 1000

CReduceExcess
Material
4100101678
Category
ANTIRUST
Base unit
CAN
MRP type
Stock Item
Criticality
C (0 of 3 FuncLocs A/B)
Supplier
CAHAYA PERKASA ABADI PT
Lead time
15 d · P80 20 d
Unit price
Rp 88,680

Recommendation

  • 1.Forecast 140 CAN/year: 140 unplanned (recency-weighted compound poisson (own history)).
  • 2.Lead time ~15 days; expected demand during lead time 5.9.
  • 3.A 98.0% service level gives the lowest holding + downtime-risk cost: reorder at 16, order up to 157.
  • 4.Stock 252 exceeds the level to keep (157) by 95.
  • 5.ML early warning: 100% probability of demand in the next 90 days.
ML early warningLast turnaround used 22Single sourceAbnormal consumptionSame description as 5 other material numbers
On hand / on order
252 / 0
no open PO
Today Min / Max
148 / 297
static parameters in BoM
Rec. Min (reorder point)
16
safety stock 11
Rec. Max
157
order qty 141
Service level
98.0%
stockout risk now 0%
Unit price
Rp 88,680
PO history
ML early warning: 100% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 15 issue days in the last 180 days, last issue 3 days ago, 0 failure notifications on its equipment in 90 days, 0 planned jobs in 90 days, 12 PRs in 180 days.

Consumption history and 12-month forecast

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

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

Installed on 3 functional locations

0 with criticality A/B · 3 units installed

FuncLocCrit.InstalledNotificationsFailures / yr
PX_3-P-25182-A51A-C
PIPE-3 FROM HE-895C TO PP-154A
C100.01
PX_3-QO-17336-A11A-H
PIPE-3 FROM PP-641A TO VD-421
C100.01
PX_4-LS-21560-A11A
PIPE-4 FROM HE-921C TO PP-1657A
C100.01

Lead time and procurement

Lead time 15 ± 7 days (PO history, 28 PO lines) · on-time 42%

PR dateTypeQtyUnit priceDeliveryLead time
07 Sept 2026PR06
Regular replenishment
71Rp 89,95821 Sept 202614 d
31 Aug 2026PR06
Regular replenishment
52Rp 88,09615 Sept 202615 d
02 Aug 2026PR03
Regular replenishment
57Rp 88,39728 Aug 202626 d
26 Jul 2026PR06
Regular replenishment
139Rp 89,71015 Aug 202620 d
10 Jul 2026PR03
Regular replenishment
126Rp 90,70003 Aug 202624 d
05 Jul 2026PR03
Regular replenishment
58Rp 87,84820 Jul 202615 d
04 Jul 2026PR05
Project / turnaround
46Rp 86,72015 Jul 202611 d
29 Jun 2026PR04
Regular (other)
106Rp 86,02314 Jul 202615 d
08 May 2026PR03
Regular replenishment
78Rp 84,54718 May 202610 d
30 Apr 2026PR03
Regular replenishment
91Rp 88,06619 May 202619 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
28 Sept 20265201000022446Corrective
11 Sept 20262201000035065Corrective
06 Sept 20261201000003235Corrective
28 Aug 20261201000007716Corrective
27 Aug 20264201000033086Corrective
26 Aug 20261201000029208Corrective
11 Aug 20265201000027417Corrective
26 Jul 20264203000004330Turnaround
09 Jul 20265201000026179Corrective
06 Jul 202614209000029244Other maintenance
04 Jul 20261201000025376Corrective
18 Jun 20262201000011352Corrective
11 Jun 20261201000006766Corrective
14 May 20264201000004147Corrective
08 May 20261201000002247Corrective
Sparely