stocksense

Items / CAB-0018

FR Wire 4 sqmm Elite CAB-0018 · Cables & Wires · Conduit & Cable Co

On hand (COIL)129MAIN 97, EAST 32
Value (FIFO)8,619.10avg 66.81
ClassAX / FCV 0.13
Turnover5.9xlast issue 0 days ago
Days of cover58lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00180.045.490.8136182Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 65.0Nov 24: 66.0Dec 24: 165.0Jan 25: 63.0Feb 25: 75.0Mar 25: 65.0Apr 25: 54.0May 25: 79.0Jun 25: 98.0Jul 25: 73.0Aug 25: 52.0Sep 25: 78.0Oct 25: 52.0Nov 25: 76.0Dec 25: 57.0Jan 26: 60.0Feb 26: 78.0Mar 26: 65.0Apr 26: 81.0May 26: 60.0Jun 26: 75.0Jul 26: 65.0Aug 26: 76.0Sep 26: 67.0

actual forecast 90% prediction interval

No forecast run yet for this item. Run forecasts. Policy numbers use trailing 12-month demand.

Policy numbers explained

MetricFormulaSubstitutedResult
Daily demand dmonthly mean / 30.437567.67 / 30.43752.223
Daily demand sdmonthly sd / sqrt(30.4375)8.98 / 5.5171.629
Service level / zz = Phi^-1(service level)Phi^-1(0.980)2.054
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)2.054 * sqrt(14.0 * 1.629^2 + 2.223^2 * 3.1^2)18.9
Reorder pointd * LT + safety stock2.223 * 14.0 + 18.950.1
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days50.1
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 811/yr, S = 45.00, h = 20%, price = 67.6573.5
Inventory positionon hand + on order129 + 0129

Price break evaluation (annual cost at each tier's EOQ)

From qtyUnit costOrder qtyAnnual costFeasible
067.657355,888yes (chosen if cheapest)

MOQ 160, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 11, 2026129 / 16066.818,619.10

Movement ledger 128 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-514MAIN 12 66.81-801.781298,619.10 Oct. 11, 2026: 12 @ 66.81
Oct. 15, 2026issueSO-261015-956EAST 19 66.81-1,269.481419,420.87 Oct. 11, 2026: 19 @ 66.81
Oct. 11, 2026transferTRFMAIN → EAST 51 warehouse transfer, no cost effect
Oct. 11, 2026receiptPO-001869MAIN 160 66.8110,690.3516010,690.35
Oct. 10, 2026issueSO-261010-819MAIN 13 66.86-869.1600.00 July 21, 2026: 13 @ 66.86
Sept. 30, 2026issueSO-260930-963MAIN 65 66.86-4,345.8213869.16 July 21, 2026: 65 @ 66.86
Sept. 18, 2026issueSO-260918-111MAIN 2 66.86-133.72785,214.98 July 21, 2026: 2 @ 66.86
Aug. 31, 2026issueSO-260831-964MAIN 1 66.86-66.86805,348.70 July 21, 2026: 1 @ 66.86
Aug. 24, 2026issueSO-260824-482MAIN 10 66.86-668.59815,415.55 July 21, 2026: 10 @ 66.86
Aug. 21, 2026issueSO-260821-505MAIN 11 66.86-735.45916,084.14 July 21, 2026: 11 @ 66.86
Aug. 15, 2026issueSO-260815-959MAIN 30 66.86-2,005.761026,819.59 July 21, 2026: 30 @ 66.86
Aug. 6, 2026issueSO-260806-576MAIN 9 66.86-601.731328,825.35 July 21, 2026: 9 @ 66.86
Aug. 4, 2026issueSO-260804-912MAIN 15 66.86-1,002.881419,427.08 July 21, 2026: 15 @ 66.86
July 26, 2026issueSO-260726-100MAIN 3 66.86-200.5815610,429.96 July 21, 2026: 3 @ 66.86
July 22, 2026issueSO-260722-733MAIN 1 66.86-66.8615910,630.53 July 21, 2026: 1 @ 66.86
July 21, 2026receiptPO-001657MAIN 160 66.8610,697.3916010,697.39
July 13, 2026issueSO-260713-188MAIN 33 65.21-2,152.0100.00 May 14, 2026: 33 @ 65.21
July 4, 2026issueSO-260704-674MAIN 28 65.21-1,825.95332,152.01 May 14, 2026: 28 @ 65.21
June 17, 2026issueSO-260617-540MAIN 9 65.21-586.91613,977.96 May 14, 2026: 9 @ 65.21
June 10, 2026issueSO-260610-315MAIN 66 65.21-4,304.02704,564.88 May 14, 2026: 66 @ 65.21
May 27, 2026issueSO-260527-845MAIN 9 65.21-586.911368,868.90 May 14, 2026: 9 @ 65.21
May 24, 2026issueSO-260524-699MAIN 11 65.21-717.341459,455.81 May 14, 2026: 11 @ 65.21
May 22, 2026issueSO-260522-302MAIN 4 65.21-260.8515610,173.15 May 14, 2026: 4 @ 65.21
May 14, 2026receiptPO-001491MAIN 160 65.2110,434.0016010,434.00
May 10, 2026issueSO-260510-805MAIN 10 64.50-645.0400.00 Feb. 27, 2026: 10 @ 64.50
May 8, 2026issueSO-260508-302MAIN 26 64.50-1,677.1110645.04 Feb. 27, 2026: 26 @ 64.50
April 30, 2026issueSO-260430-786MAIN 20 64.50-1,290.09362,322.15 Feb. 27, 2026: 20 @ 64.50
April 17, 2026issueSO-260417-659MAIN 6 64.50-387.03563,612.24 Feb. 27, 2026: 6 @ 64.50
April 14, 2026issueSO-260414-513MAIN 9 64.50-580.54623,999.27 Feb. 27, 2026: 9 @ 64.50
April 11, 2026issueSO-260411-838MAIN 2 64.50-129.01714,579.81 Feb. 27, 2026: 2 @ 64.50
April 10, 2026issueSO-260410-972MAIN 44 64.50-2,838.19734,708.81 Feb. 27, 2026: 44 @ 64.50
March 29, 2026issueSO-260329-410MAIN 8 64.50-516.031177,547.00 Feb. 27, 2026: 8 @ 64.50
March 27, 2026issueSO-260327-641MAIN 2 64.50-129.011258,063.04 Feb. 27, 2026: 2 @ 64.50
March 18, 2026issueSO-260318-551MAIN 43 64.30-2,764.991278,192.05 Dec. 25, 2025: 10 @ 63.63; Feb. 27, 2026: 33 @ 64.50
March 17, 2026issueSO-260317-826MAIN 1 63.63-63.6317010,957.03 Dec. 25, 2025: 1 @ 63.63
March 14, 2026issueSO-260314-136MAIN 1 63.63-63.6317111,020.67 Dec. 25, 2025: 1 @ 63.63
March 13, 2026issueSO-260313-551MAIN 1 63.63-63.6317211,084.30 Dec. 25, 2025: 1 @ 63.63
March 12, 2026issueSO-260312-569MAIN 9 63.63-572.7117311,147.94 Dec. 25, 2025: 9 @ 63.63
Feb. 27, 2026receiptPO-001263MAIN 160 64.5010,320.6918211,720.64
Feb. 26, 2026issueSO-260226-562MAIN 6 63.63-381.81221,399.96 Dec. 25, 2025: 6 @ 63.63
Feb. 22, 2026issueSO-260222-591MAIN 11 63.63-699.98281,781.76 Dec. 25, 2025: 11 @ 63.63
Feb. 16, 2026issueSO-260216-313MAIN 12 63.63-763.61392,481.74 Dec. 25, 2025: 12 @ 63.63
Feb. 12, 2026issueSO-260212-616MAIN 14 63.63-890.88513,245.35 Dec. 25, 2025: 14 @ 63.63
Feb. 9, 2026issueSO-260209-821MAIN 35 63.63-2,227.20654,136.24 Dec. 25, 2025: 35 @ 63.63
Jan. 28, 2026issueSO-260128-135MAIN 1 63.63-63.631006,363.44 Dec. 25, 2025: 1 @ 63.63
Jan. 23, 2026issueSO-260123-531MAIN 16 63.63-1,018.151016,427.07 Dec. 25, 2025: 16 @ 63.63
Jan. 14, 2026issueSO-260114-963MAIN 1 63.63-63.631177,445.22 Dec. 25, 2025: 1 @ 63.63
Jan. 13, 2026issueSO-260113-828MAIN 23 63.63-1,463.591187,508.86 Dec. 25, 2025: 23 @ 63.63
Jan. 7, 2026issueSO-260107-636MAIN 11 63.63-699.981418,972.45 Dec. 25, 2025: 11 @ 63.63
Jan. 5, 2026issueSO-260105-772MAIN 8 63.63-509.081529,672.43 Dec. 25, 2025: 8 @ 63.63
Dec. 25, 2025receiptPO-001086MAIN 160 63.6310,181.5016010,181.50
Dec. 17, 2025issueSO-251217-658MAIN 18 64.28-1,157.0700.00 Sept. 27, 2025: 18 @ 64.28
Dec. 10, 2025issueSO-251210-573MAIN 39 64.28-2,506.97181,157.07 Sept. 27, 2025: 39 @ 64.28
Nov. 28, 2025issueSO-251128-190MAIN 29 64.28-1,864.16573,664.04 Sept. 27, 2025: 29 @ 64.28
Nov. 9, 2025issueSO-251109-158MAIN 2 64.28-128.56865,528.20 Sept. 27, 2025: 2 @ 64.28
Nov. 5, 2025issueSO-251105-221MAIN 45 64.28-2,892.66885,656.76 Sept. 27, 2025: 45 @ 64.28
Oct. 18, 2025issueSO-251018-600MAIN 15 64.28-964.221338,549.43 Sept. 27, 2025: 15 @ 64.28
Oct. 11, 2025issueSO-251011-640MAIN 4 64.28-257.131489,513.65 Sept. 27, 2025: 4 @ 64.28
Oct. 8, 2025issueSO-251008-749MAIN 24 62.93-1,510.231529,770.77 July 18, 2025: 16 @ 62.25; Sept. 27, 2025: 8 @ 64.28
Oct. 7, 2025issueSO-251007-164MAIN 4 62.25-248.9917611,281.00 July 18, 2025: 4 @ 62.25
Oct. 3, 2025issueSO-251003-633MAIN 5 62.25-311.2418011,529.99 July 18, 2025: 5 @ 62.25
Sept. 27, 2025receiptPO-000878MAIN 160 64.2810,285.0218511,841.23
Sept. 26, 2025issueSO-250926-714MAIN 29 62.25-1,805.20251,556.21 July 18, 2025: 29 @ 62.25
Sept. 13, 2025issueSO-250913-798MAIN 20 62.25-1,244.97543,361.41 July 18, 2025: 20 @ 62.25
Sept. 10, 2025issueSO-250910-968MAIN 9 62.25-560.24744,606.38 July 18, 2025: 9 @ 62.25
Sept. 1, 2025issueSO-250901-951MAIN 20 62.25-1,244.97835,166.62 July 18, 2025: 20 @ 62.25
Aug. 29, 2025issueSO-250829-586MAIN 12 62.25-746.981036,411.59 July 18, 2025: 12 @ 62.25
Aug. 27, 2025issueSO-250827-957MAIN 4 62.25-248.991157,158.57 July 18, 2025: 4 @ 62.25
Aug. 24, 2025issueSO-250824-115MAIN 5 62.25-311.241197,407.56 July 18, 2025: 5 @ 62.25
Aug. 17, 2025issueSO-250817-294MAIN 4 62.25-248.991247,718.80 July 18, 2025: 4 @ 62.25
Aug. 15, 2025issueSO-250815-722MAIN 2 62.25-124.501287,967.80 July 18, 2025: 2 @ 62.25
Aug. 6, 2025issueSO-250806-549MAIN 25 62.25-1,556.211308,092.29 July 18, 2025: 25 @ 62.25
July 22, 2025issueSO-250722-512MAIN 9 62.41-561.731559,648.50 June 5, 2025: 4 @ 62.62; July 18, 2025: 5 @ 62.25
July 18, 2025receiptPO-000720MAIN 160 62.259,959.7416410,210.24
July 10, 2025issueSO-250710-247MAIN 31 62.15-1,926.754250.49 May 18, 2025: 28 @ 62.10; June 5, 2025: 3 @ 62.62
July 6, 2025issueSO-250706-599MAIN 7 62.10-434.72352,177.24 May 18, 2025: 7 @ 62.10
July 4, 2025issueSO-250704-987MAIN 15 62.10-931.54422,611.96 May 18, 2025: 15 @ 62.10
July 3, 2025issueSO-250703-340MAIN 11 62.10-683.13573,543.51 May 18, 2025: 11 @ 62.10
June 30, 2025issueSO-250630-252MAIN 19 62.10-1,179.96684,226.64 May 18, 2025: 19 @ 62.10
June 25, 2025issueSO-250625-134MAIN 24 62.10-1,490.47875,406.59 May 18, 2025: 24 @ 62.10
June 24, 2025issueSO-250624-952MAIN 2 62.10-124.211116,897.06 May 18, 2025: 2 @ 62.10
June 20, 2025issueSO-250620-121MAIN 32 62.10-1,987.291137,021.27 May 18, 2025: 32 @ 62.10
June 7, 2025issueSO-250607-568MAIN 2 62.10-124.211459,008.56 May 18, 2025: 2 @ 62.10
June 5, 2025returnRMAMAIN 7 62.62438.361479,132.77
June 4, 2025issueSO-250604-286MAIN 26 62.62-1,628.201408,694.41 Feb. 21, 2025: 6 @ 64.36; May 18, 2025: 20 @ 62.10
May 24, 2025issueSO-250524-358MAIN 1 64.36-64.3616610,322.60 Feb. 21, 2025: 1 @ 64.36
May 20, 2025issueSO-250520-383MAIN 3 64.36-193.0716710,386.96 Feb. 21, 2025: 3 @ 64.36
May 18, 2025receiptPO-000545MAIN 160 62.109,936.4617010,580.03
May 16, 2025issueSO-250516-477MAIN 15 64.36-965.3510643.57 Feb. 21, 2025: 15 @ 64.36
May 2, 2025issueSO-250502-341MAIN 60 64.36-3,861.41251,608.92 Feb. 21, 2025: 60 @ 64.36
April 29, 2025issueSO-250429-602MAIN 17 64.36-1,094.07855,470.33 Feb. 21, 2025: 17 @ 64.36
April 25, 2025issueSO-250425-829MAIN 5 64.36-321.781026,564.39 Feb. 21, 2025: 5 @ 64.36
April 22, 2025issueSO-250422-114MAIN 6 64.36-386.141076,886.18 Feb. 21, 2025: 6 @ 64.36
April 11, 2025issueSO-250411-243MAIN 3 64.36-193.071137,272.32 Feb. 21, 2025: 3 @ 64.36
April 7, 2025issueSO-250407-267MAIN 3 64.36-193.071167,465.39 Feb. 21, 2025: 3 @ 64.36
April 5, 2025issueSO-250405-467MAIN 20 64.36-1,287.141197,658.46 Feb. 21, 2025: 20 @ 64.36
March 22, 2025issueSO-250322-879MAIN 5 64.36-321.781398,945.60 Feb. 21, 2025: 5 @ 64.36
March 18, 2025issueSO-250318-466MAIN 8 64.36-514.851449,267.38 Feb. 21, 2025: 8 @ 64.36
March 15, 2025issueSO-250315-195MAIN 18 62.86-1,131.531529,782.23 Jan. 9, 2025: 10 @ 61.67; Feb. 21, 2025: 8 @ 64.36
March 13, 2025issueSO-250313-442MAIN 11 61.67-678.3417010,913.76 Jan. 9, 2025: 11 @ 61.67
March 12, 2025issueSO-250312-836MAIN 23 61.67-1,418.3518111,592.11 Jan. 9, 2025: 23 @ 61.67
Feb. 23, 2025issueSO-250223-800MAIN 11 61.67-678.3420413,010.46 Jan. 9, 2025: 11 @ 61.67
Feb. 21, 2025receiptPO-000286MAIN 160 64.3610,297.0921513,688.80
Feb. 8, 2025issueSO-250208-186MAIN 14 61.67-863.34553,391.71 Jan. 9, 2025: 14 @ 61.67
Feb. 7, 2025issueSO-250207-263MAIN 50 61.67-3,083.38694,255.06 Jan. 9, 2025: 50 @ 61.67
Jan. 30, 2025issueSO-250130-733MAIN 16 61.67-986.681197,338.43 Jan. 9, 2025: 16 @ 61.67
Jan. 14, 2025adjustmentCycle countMAIN -2 61.67-123.341358,325.11 Jan. 9, 2025: 2 @ 61.67
Jan. 14, 2025issueSO-250114-982MAIN 23 61.67-1,418.351378,448.45 Jan. 9, 2025: 23 @ 61.67
Jan. 9, 2025receiptPO-000174MAIN 160 61.679,866.801609,866.80
Jan. 2, 2025issueSO-250102-518MAIN 20 62.20-1,244.0400.00 Nov. 26, 2024: 20 @ 62.20
Jan. 1, 2025issueSO-250101-864MAIN 4 62.20-248.81201,244.04 Nov. 26, 2024: 4 @ 62.20
Dec. 31, 2024issueSO-241231-913MAIN 2 62.20-124.40241,492.84 Nov. 26, 2024: 2 @ 62.20
Dec. 24, 2024issueSO-241224-667MAIN 102 62.20-6,344.58261,617.25 Nov. 26, 2024: 102 @ 62.20
Dec. 14, 2024issueSO-241214-596MAIN 5 62.20-311.011287,961.83 Nov. 26, 2024: 5 @ 62.20
Dec. 14, 2024issueSO-241214-596EAST 46 63.06-2,900.531338,272.84 Oct. 1, 2024: 19 @ 64.27; Nov. 26, 2024: 27 @ 62.20
Dec. 10, 2024issueSO-241210-125MAIN 10 64.27-642.6817911,173.37 Oct. 1, 2024: 10 @ 64.27
Nov. 26, 2024issueSO-241126-669MAIN 6 64.27-385.6018911,816.05 Oct. 1, 2024: 6 @ 64.27
Nov. 26, 2024transferTRFMAIN → EAST 46 warehouse transfer, no cost effect
Nov. 26, 2024receiptPO-000061MAIN 160 62.209,952.2919512,201.65
Nov. 23, 2024issueSO-241123-278MAIN 7 64.27-449.87352,249.36 Oct. 1, 2024: 7 @ 64.27
Nov. 13, 2024issueSO-241113-353MAIN 12 64.27-771.21422,699.24 Oct. 1, 2024: 12 @ 64.27
Nov. 11, 2024issueSO-241111-353MAIN 11 64.27-706.94543,470.44 Oct. 1, 2024: 11 @ 64.27
Nov. 8, 2024issueSO-241108-608MAIN 11 64.27-706.94654,177.39 Oct. 1, 2024: 11 @ 64.27
Nov. 6, 2024issueSO-241106-863MAIN 1 64.27-64.27764,884.33 Oct. 1, 2024: 1 @ 64.27
Nov. 3, 2024issueSO-241103-236MAIN 18 64.27-1,156.82774,948.60 Oct. 1, 2024: 18 @ 64.27
Oct. 29, 2024issueSO-241029-837MAIN 63 64.27-4,048.85956,105.41 Oct. 1, 2024: 63 @ 64.27
Oct. 28, 2024issueSO-241028-959MAIN 2 64.27-128.5415810,154.26 Oct. 1, 2024: 2 @ 64.27
Oct. 1, 2024receiptPO-000002MAIN 160 64.2710,282.8016010,282.80