Sparely
DU

ANTIRUST,SPRAY TYPE,500ML/CAN,TYPE-A

Material 4100101639 · ANTIRUST · Plant 1000

CReduceExcess
Material
4100101639
Category
ANTIRUST
Base unit
CAN
MRP type
Stock Item
Criticality
C (0 of 3 FuncLocs A/B)
Supplier
CAHAYA INDUSTRI SENTOSA PT
Lead time
15 d · P80 21 d
Unit price
Rp 47,326

Recommendation

  • 1.Forecast 129 CAN/year: 129 unplanned (recency-weighted compound poisson (own history)).
  • 2.Lead time ~15 days; expected demand during lead time 5.3.
  • 3.A 99.3% service level gives the lowest holding + downtime-risk cost: reorder at 16, order up to 146.
  • 4.Stock 190 exceeds the level to keep (146) by 44.
  • 5.ML early warning: 100% probability of demand in the next 90 days.
ML early warningLast turnaround used 32Single sourceAbnormal consumptionSame description as 4 other material numbers
On hand / on order
190 / 0
no open PO
Today Min / Max
45 / 76
static parameters in BoM
Rec. Min (reorder point)
16
safety stock 11
Rec. Max
146
order qty 130
Service level
99.3%
stockout risk now 0%
Unit price
Rp 47,326
PO history
ML early warning: 100% probability this part is needed in the next 90 days (above the 30% warning threshold). Inputs: 13 issue days in the last 180 days, last issue 10 days ago, 0 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 (100 units) excluded from the baseline.

Demand pattern Erratic · 71 issue days · 11 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 208.1M/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_12-P-14843-A11A-C
PIPE-12 FROM HE-786 TO PP-128A
C100.01
PX_2-MS-15278-C11A
PIPE-2 FROM PP-1460A TO PP-1575A
C100.01
PX_3-IA-19886-A22A-HS
PIPE-3 FROM PP-1864A TO VD-1291
C100.01

Lead time and procurement

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

PR dateTypeQtyUnit priceDeliveryLead time
31 Aug 2026PR03
Regular replenishment
72Rp 45,71809 Sept 20269 d
25 Aug 2026PR03
Regular replenishment
49Rp 48,60210 Sept 202616 d
05 Aug 2026PR03
Regular replenishment
162Rp 45,61619 Aug 202614 d
15 Jun 2026PR03
Regular replenishment
106Rp 47,32621 Jun 20266 d
01 Jun 2026PR04
Regular (other)
152Rp 47,95307 Jul 202636 d
16 May 2026PR03
Regular replenishment
105Rp 48,16406 Jun 202621 d
12 May 2026PR03
Regular replenishment
48Rp 46,77323 May 202611 d
13 Apr 2026PR06
Regular replenishment
124Rp 46,27326 Apr 202613 d
09 Mar 2026PR03
Regular replenishment
82Rp 45,60830 Mar 202621 d
02 Feb 2026PR06
Regular replenishment
111Rp 47,94410 Feb 20268 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
21 Sept 20262201000036455Corrective
27 Aug 20262201000024605Corrective
27 Aug 20261201000033086Corrective
28 Jul 20261201000009431Corrective
25 Jul 20263204000026843Preventive
24 Jul 202616203000004330Turnaround
23 Jul 20261201000026095Corrective
16 Jul 20261201000039977Corrective
21 Jun 20264209000027470Other maintenance
13 Jun 20264201000023717Corrective
06 Jun 202611201000000723Corrective
18 May 20261201000006651Corrective
09 May 20261201000002247Corrective
23 Apr 20261201000018980Corrective
10 Apr 20263201000007384Corrective
Sparely