stocksense

Items / CAB-0009

FR Wire 4 sqmm Classic CAB-0009 · Cables & Wires · Conduit & Cable Co

On hand (COIL)94MAIN 94
Value (FIFO)32,792.84avg 348.86
ClassAX / FCV 0.28
Turnover10.3xlast issue 4 days ago
Days of cover55lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00090.022.845.768.591.3Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 42.0Nov 24: 39.0Dec 24: 41.0Jan 25: 36.0Feb 25: 29.0Mar 25: 45.0Apr 25: 39.0May 25: 75.0Jun 25: 58.0Jul 25: 41.0Aug 25: 60.0Sep 25: 48.0Oct 25: 39.0Nov 25: 43.0Dec 25: 41.0Jan 26: 61.0Feb 26: 72.0Mar 26: 55.0Apr 26: 35.0May 26: 58.0Jun 26: 42.0Jul 26: 55.0Aug 26: 83.0Sep 26: 35.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.437551.58 / 30.43751.695
Daily demand sdmonthly sd / sqrt(30.4375)14.56 / 5.5172.639
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 * 2.639^2 + 1.695^2 * 3.1^2)23.0
Reorder pointd * LT + safety stock1.695 * 14.0 + 23.046.8
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days46.8
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 619/yr, S = 45.00, h = 20%, price = 357.8127.9
Inventory positionon hand + on order94 + 094

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

From qtyUnit costOrder qtyAnnual costFeasible
0357.8128223,329yes (chosen if cheapest)

MOQ 100, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 8, 202694 / 100348.8632,792.84

Movement ledger 128 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 12, 2026issueSO-261012-924MAIN 1 348.86-348.869432,792.84 Oct. 8, 2026: 1 @ 348.86
Oct. 11, 2026issueSO-261011-646MAIN 12 350.07-4,200.889533,141.70 Aug. 23, 2026: 7 @ 350.94; Oct. 8, 2026: 5 @ 348.86
Oct. 10, 2026issueSO-261010-264MAIN 17 350.94-5,965.9710737,342.58 Aug. 23, 2026: 17 @ 350.94
Oct. 8, 2026receiptPO-001859MAIN 100 348.8634,886.0012443,308.54
Oct. 1, 2026issueSO-261001-551MAIN 3 350.94-1,052.82248,422.54 Aug. 23, 2026: 3 @ 350.94
Sept. 27, 2026issueSO-260927-506MAIN 11 350.94-3,860.33279,475.36 Aug. 23, 2026: 11 @ 350.94
Sept. 26, 2026issueSO-260926-152MAIN 6 350.94-2,105.643813,335.69 Aug. 23, 2026: 6 @ 350.94
Sept. 21, 2026issueSO-260921-643MAIN 4 350.94-1,403.764415,441.33 Aug. 23, 2026: 4 @ 350.94
Sept. 19, 2026issueSO-260919-242MAIN 4 350.94-1,403.764816,845.09 Aug. 23, 2026: 4 @ 350.94
Sept. 17, 2026issueSO-260917-565MAIN 5 350.94-1,754.705218,248.84 Aug. 23, 2026: 5 @ 350.94
Sept. 16, 2026issueSO-260916-923MAIN 2 350.94-701.885720,003.54 Aug. 23, 2026: 2 @ 350.94
Sept. 6, 2026issueSO-260906-994MAIN 3 350.94-1,052.825920,705.42 Aug. 23, 2026: 3 @ 350.94
Aug. 30, 2026issueSO-260830-945MAIN 3 350.94-1,052.826221,758.24 Aug. 23, 2026: 3 @ 350.94
Aug. 28, 2026issueSO-260828-438MAIN 21 350.94-7,369.736522,811.05 Aug. 23, 2026: 21 @ 350.94
Aug. 27, 2026issueSO-260827-143MAIN 8 350.94-2,807.518630,180.78 Aug. 23, 2026: 8 @ 350.94
Aug. 24, 2026issueSO-260824-837MAIN 25 359.86-8,996.609432,988.29 June 17, 2026: 19 @ 362.68; Aug. 23, 2026: 6 @ 350.94
Aug. 23, 2026receiptPO-001739MAIN 100 350.9435,093.9311941,984.89
Aug. 20, 2026issueSO-260820-308MAIN 9 362.68-3,264.14196,890.96 June 17, 2026: 9 @ 362.68
Aug. 11, 2026issueSO-260811-905MAIN 15 362.68-5,440.232810,155.10 June 17, 2026: 15 @ 362.68
Aug. 10, 2026issueSO-260810-251MAIN 2 362.68-725.364315,595.34 June 17, 2026: 2 @ 362.68
July 31, 2026issueSO-260731-797MAIN 3 362.68-1,088.054516,320.70 June 17, 2026: 3 @ 362.68
July 29, 2026issueSO-260729-602MAIN 12 362.68-4,352.194817,408.75 June 17, 2026: 12 @ 362.68
July 17, 2026issueSO-260717-986MAIN 11 362.68-3,989.516021,760.94 June 17, 2026: 11 @ 362.68
July 10, 2026issueSO-260710-893MAIN 3 362.68-1,088.057125,750.44 June 17, 2026: 3 @ 362.68
July 7, 2026issueSO-260707-539MAIN 1 362.68-362.687426,838.49 June 17, 2026: 1 @ 362.68
July 4, 2026issueSO-260704-265MAIN 25 362.68-9,067.067527,201.17 June 17, 2026: 25 @ 362.68
June 17, 2026receiptPO-001583MAIN 100 362.6836,268.2310036,268.23
June 14, 2026issueSO-260614-197EAST 29 358.01-10,382.2900.00 April 13, 2026: 29 @ 358.01
June 6, 2026issueSO-260606-692EAST 6 358.01-2,148.062910,382.29 April 13, 2026: 6 @ 358.01
June 6, 2026issueSO-260606-692MAIN 7 358.01-2,506.073512,530.35 April 13, 2026: 7 @ 358.01
May 29, 2026issueSO-260529-897MAIN 21 358.01-7,518.214215,036.42 April 13, 2026: 21 @ 358.01
May 28, 2026issueSO-260528-107MAIN 37 358.01-13,246.376322,554.62 April 13, 2026: 37 @ 358.01
April 13, 2026transferTRFMAIN → EAST 35 warehouse transfer, no cost effect
April 13, 2026receiptPO-001405MAIN 100 358.0135,800.9910035,800.99
April 8, 2026issueSO-260408-912MAIN 17 356.56-6,061.5100.00 Feb. 10, 2026: 17 @ 356.56
April 3, 2026issueSO-260403-692MAIN 18 356.56-6,418.07176,061.51 Feb. 10, 2026: 18 @ 356.56
March 28, 2026issueSO-260328-795MAIN 2 356.56-713.123512,479.59 Feb. 10, 2026: 2 @ 356.56
March 21, 2026issueSO-260321-391MAIN 1 356.56-356.563713,192.71 Feb. 10, 2026: 1 @ 356.56
March 17, 2026issueSO-260317-181MAIN 10 356.56-3,565.603813,549.26 Feb. 10, 2026: 10 @ 356.56
March 13, 2026issueSO-260313-344MAIN 7 356.56-2,495.924817,114.86 Feb. 10, 2026: 7 @ 356.56
March 7, 2026issueSO-260307-252MAIN 30 356.56-10,696.795519,610.78 Feb. 10, 2026: 30 @ 356.56
March 6, 2026issueSO-260306-430MAIN 5 356.56-1,782.808530,307.57 Feb. 10, 2026: 5 @ 356.56
Feb. 25, 2026issueSO-260225-699MAIN 17 354.53-6,027.059032,090.36 Jan. 6, 2026: 7 @ 351.64; Feb. 10, 2026: 10 @ 356.56
Feb. 10, 2026receiptPO-001213MAIN 100 356.5635,655.9610738,117.41
Feb. 8, 2026issueSO-260208-148MAIN 3 351.64-1,054.9172,461.45 Jan. 6, 2026: 3 @ 351.64
Feb. 5, 2026issueSO-260205-509MAIN 13 351.64-4,571.27103,516.36 Jan. 6, 2026: 13 @ 351.64
Feb. 1, 2026issueSO-260201-624MAIN 39 351.64-13,713.82238,087.64 Jan. 6, 2026: 39 @ 351.64
Jan. 20, 2026issueSO-260120-602MAIN 40 351.38-14,055.346221,801.46 Oct. 24, 2025: 2 @ 346.58; Jan. 6, 2026: 38 @ 351.64
Jan. 18, 2026issueSO-260118-579MAIN 21 346.58-7,278.1410235,856.80 Oct. 24, 2025: 21 @ 346.58
Jan. 6, 2026receiptPO-001125MAIN 100 351.6435,163.6412343,134.94
Dec. 26, 2025issueSO-251226-400MAIN 8 346.58-2,772.62237,971.30 Oct. 24, 2025: 8 @ 346.58
Dec. 25, 2025issueSO-251225-762MAIN 24 346.58-8,317.873110,743.92 Oct. 24, 2025: 24 @ 346.58
Dec. 20, 2025issueSO-251220-657MAIN 1 346.58-346.585519,061.80 Oct. 24, 2025: 1 @ 346.58
Dec. 5, 2025issueSO-251205-632MAIN 3 346.58-1,039.735619,408.37 Oct. 24, 2025: 3 @ 346.58
Dec. 4, 2025issueSO-251204-698MAIN 5 346.58-1,732.895920,448.11 Oct. 24, 2025: 5 @ 346.58
Nov. 30, 2025issueSO-251130-194MAIN 5 346.58-1,732.896422,181.00 Oct. 24, 2025: 5 @ 346.58
Nov. 25, 2025issueSO-251125-580MAIN 5 346.58-1,732.896923,913.89 Oct. 24, 2025: 5 @ 346.58
Nov. 19, 2025issueSO-251119-300MAIN 14 346.58-4,852.097425,646.78 Oct. 24, 2025: 14 @ 346.58
Nov. 13, 2025issueSO-251113-722MAIN 7 346.58-2,426.058830,498.87 Oct. 24, 2025: 7 @ 346.58
Nov. 11, 2025issueSO-251111-102MAIN 11 345.73-3,803.079532,924.92 Aug. 24, 2025: 6 @ 345.03; Oct. 24, 2025: 5 @ 346.58
Nov. 2, 2025issueSO-251102-161MAIN 1 345.03-345.0310636,727.99 Aug. 24, 2025: 1 @ 345.03
Oct. 27, 2025issueSO-251027-409MAIN 2 345.03-690.0610737,073.02 Aug. 24, 2025: 2 @ 345.03
Oct. 27, 2025issueSO-251027-409EAST 23 345.03-7,935.6810937,763.08 Aug. 24, 2025: 23 @ 345.03
Oct. 24, 2025transferTRFMAIN → EAST 23 warehouse transfer, no cost effect
Oct. 24, 2025receiptPO-000945MAIN 100 346.5834,657.8113245,698.75
Oct. 5, 2025issueSO-251005-251MAIN 14 345.03-4,830.413211,040.94 Aug. 24, 2025: 14 @ 345.03
Sept. 30, 2025issueSO-250930-221MAIN 25 345.03-8,625.744615,871.36 Aug. 24, 2025: 25 @ 345.03
Sept. 29, 2025issueSO-250929-520MAIN 1 345.03-345.037124,497.09 Aug. 24, 2025: 1 @ 345.03
Sept. 10, 2025issueSO-250910-779MAIN 4 345.03-1,380.127224,842.12 Aug. 24, 2025: 4 @ 345.03
Sept. 4, 2025issueSO-250904-843MAIN 4 345.03-1,380.127626,222.24 Aug. 24, 2025: 4 @ 345.03
Sept. 3, 2025issueSO-250903-988MAIN 14 345.03-4,830.418027,602.36 Aug. 24, 2025: 14 @ 345.03
Aug. 27, 2025issueSO-250827-786MAIN 5 345.03-1,725.159432,432.77 Aug. 24, 2025: 5 @ 345.03
Aug. 26, 2025issueSO-250826-708MAIN 1 345.03-345.039934,157.92 Aug. 24, 2025: 1 @ 345.03
Aug. 24, 2025receiptPO-000792MAIN 100 345.0334,502.9510034,502.95
Aug. 23, 2025issueSO-250823-311MAIN 5 336.60-1,683.0100.00 June 21, 2025: 5 @ 336.60
Aug. 22, 2025issueSO-250822-641MAIN 22 336.60-7,405.2651,683.01 June 21, 2025: 22 @ 336.60
Aug. 8, 2025issueSO-250808-357MAIN 3 336.60-1,009.81279,088.28 June 21, 2025: 3 @ 336.60
Aug. 5, 2025issueSO-250805-664MAIN 18 336.60-6,058.853010,098.09 June 21, 2025: 18 @ 336.60
Aug. 1, 2025issueSO-250801-553MAIN 6 336.60-2,019.624816,156.94 June 21, 2025: 6 @ 336.60
July 26, 2025issueSO-250726-378MAIN 7 336.60-2,356.225418,176.56 June 21, 2025: 7 @ 336.60
July 17, 2025issueSO-250717-143MAIN 9 336.60-3,029.436120,532.78 June 21, 2025: 9 @ 336.60
July 6, 2025issueSO-250706-200MAIN 14 336.60-4,712.447023,562.20 June 21, 2025: 14 @ 336.60
July 5, 2025issueSO-250705-562MAIN 11 336.60-3,702.638428,274.64 June 21, 2025: 11 @ 336.60
June 30, 2025issueSO-250630-851MAIN 2 336.60-673.219531,977.28 June 21, 2025: 2 @ 336.60
June 29, 2025issueSO-250629-602MAIN 17 328.97-5,592.509732,650.48 May 7, 2025: 14 @ 327.33; June 21, 2025: 3 @ 336.60
June 21, 2025receiptPO-000655MAIN 100 336.6033,660.2911438,242.98
June 18, 2025issueSO-250618-191MAIN 9 327.33-2,946.01144,582.69 May 7, 2025: 9 @ 327.33
June 7, 2025issueSO-250607-123MAIN 30 327.33-9,820.05237,528.70 May 7, 2025: 30 @ 327.33
May 21, 2025issueSO-250521-734MAIN 26 327.33-8,510.715317,348.75 May 7, 2025: 26 @ 327.33
May 9, 2025issueSO-250509-890MAIN 26 328.39-8,538.187925,859.46 March 3, 2025: 5 @ 332.83; May 7, 2025: 21 @ 327.33
May 7, 2025issueSO-250507-205MAIN 1 332.83-332.8310534,397.64 March 3, 2025: 1 @ 332.83
May 7, 2025receiptPO-000517MAIN 100 327.3332,733.4910634,730.47
May 2, 2025issueSO-250502-162MAIN 22 338.34-7,443.3961,996.98 March 1, 2025: 19 @ 339.21; March 3, 2025: 3 @ 332.83
April 28, 2025issueSO-250428-279MAIN 9 339.21-3,052.85289,440.37 March 1, 2025: 9 @ 339.21
April 16, 2025issueSO-250416-775MAIN 4 339.21-1,356.823712,493.21 March 1, 2025: 4 @ 339.21
April 10, 2025issueSO-250410-786MAIN 22 339.21-7,462.524113,850.04 March 1, 2025: 22 @ 339.21
April 5, 2025issueSO-250405-128MAIN 4 339.21-1,356.826321,312.56 March 1, 2025: 4 @ 339.21
March 30, 2025issueSO-250330-513MAIN 10 339.21-3,392.056722,669.38 March 1, 2025: 10 @ 339.21
March 27, 2025issueSO-250327-667MAIN 16 339.21-5,427.297726,061.43 March 1, 2025: 16 @ 339.21
March 21, 2025issueSO-250321-686MAIN 2 339.21-678.419331,488.72 March 1, 2025: 2 @ 339.21
March 19, 2025issueSO-250319-499MAIN 6 339.21-2,035.239532,167.13 March 1, 2025: 6 @ 339.21
March 17, 2025issueSO-250317-440MAIN 10 337.93-3,379.3010134,202.36 Dec. 1, 2024: 2 @ 332.83; March 1, 2025: 8 @ 339.21
March 7, 2025issueSO-250307-765MAIN 3 332.83-998.4911137,581.66 Dec. 1, 2024: 3 @ 332.83
March 6, 2025issueSO-250306-759MAIN 7 332.83-2,329.8111438,580.15 Dec. 1, 2024: 7 @ 332.83
March 3, 2025returnRMAMAIN 9 332.832,995.4612140,909.96
March 1, 2025receiptPO-000304MAIN 100 339.2133,920.5411237,914.49
Feb. 15, 2025issueSO-250215-533MAIN 7 332.83-2,329.81123,993.95 Dec. 1, 2024: 7 @ 332.83
Feb. 14, 2025issueSO-250214-243MAIN 19 332.83-6,323.76196,323.76 Dec. 1, 2024: 19 @ 332.83
Feb. 12, 2025issueSO-250212-266MAIN 3 332.83-998.493812,647.51 Dec. 1, 2024: 3 @ 332.83
Jan. 27, 2025issueSO-250127-480MAIN 1 332.83-332.834113,646.00 Dec. 1, 2024: 1 @ 332.83
Jan. 10, 2025issueSO-250110-904MAIN 35 332.83-11,649.034213,978.83 Dec. 1, 2024: 35 @ 332.83
Dec. 21, 2024issueSO-241221-155MAIN 37 335.51-12,413.957725,627.86 Oct. 27, 2024: 14 @ 339.92; Dec. 1, 2024: 23 @ 332.83
Dec. 10, 2024adjustmentCycle countMAIN -1 339.92-339.9211438,041.80 Oct. 27, 2024: 1 @ 339.92
Dec. 2, 2024issueSO-241202-287MAIN 4 339.92-1,359.6811538,381.72 Oct. 8, 2024: 2 @ 339.92; Oct. 27, 2024: 2 @ 339.92
Dec. 1, 2024receiptPO-000071MAIN 100 332.8333,282.9311939,741.40
Nov. 28, 2024issueSO-241128-137MAIN 10 339.92-3,399.20196,458.47 Oct. 1, 2024: 10 @ 339.92
Nov. 23, 2024issueSO-241123-621MAIN 7 339.92-2,379.44299,857.67 Oct. 1, 2024: 7 @ 339.92
Nov. 21, 2024issueSO-241121-541MAIN 2 339.92-679.843612,237.10 Oct. 1, 2024: 2 @ 339.92
Nov. 20, 2024issueSO-241120-291MAIN 8 339.92-2,719.363812,916.94 Oct. 1, 2024: 8 @ 339.92
Nov. 14, 2024issueSO-241114-625MAIN 12 339.92-4,079.034615,636.30 Oct. 1, 2024: 12 @ 339.92
Oct. 27, 2024returnRMAMAIN 17 339.925,778.635819,715.33
Oct. 20, 2024issueSO-241020-534MAIN 35 339.92-11,897.184113,936.70 Oct. 1, 2024: 35 @ 339.92
Oct. 14, 2024issueSO-241014-644MAIN 13 339.92-4,418.957625,833.88 Oct. 1, 2024: 13 @ 339.92
Oct. 10, 2024issueSO-241010-845MAIN 3 339.92-1,019.768930,252.84 Oct. 1, 2024: 3 @ 339.92
Oct. 8, 2024returnRMAMAIN 2 339.92679.849231,272.59
Oct. 8, 2024issueSO-241008-322MAIN 5 339.92-1,699.609030,592.76 Oct. 1, 2024: 5 @ 339.92
Oct. 2, 2024issueSO-241002-908MAIN 5 339.92-1,699.609532,292.35 Oct. 1, 2024: 5 @ 339.92
Oct. 1, 2024receiptPO-000002MAIN 100 339.9233,991.9510033,991.95