stocksense

Items / CAB-0001

FR Wire 1.5 sqmm Plus CAB-0001 · Cables & Wires · Conduit & Cable Co

On hand (COIL)53MAIN 35, EAST 18
Value (FIFO)20,380.41avg 384.54
ClassAX / FCV 0.23
Turnover8.1xlast issue 0 days ago
Days of cover39lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00010.017.635.252.870.4Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 35.0Nov 24: 64.0Dec 24: 52.0Jan 25: 59.0Feb 25: 58.0Mar 25: 45.0Apr 25: 35.0May 25: 52.0Jun 25: 43.0Jul 25: 48.0Aug 25: 46.0Sep 25: 61.0Oct 25: 31.0Nov 25: 36.0Dec 25: 35.0Jan 26: 57.0Feb 26: 41.0Mar 26: 40.0Apr 26: 54.0May 26: 61.0Jun 26: 36.0Jul 26: 45.0Aug 26: 34.0Sep 26: 32.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.437541.83 / 30.43751.374
Daily demand sdmonthly sd / sqrt(30.4375)9.79 / 5.5171.774
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.774^2 + 1.374^2 * 3.1^2)16.2
Reorder pointd * LT + safety stock1.374 * 14.0 + 16.235.5
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days35.5
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 502/yr, S = 45.00, h = 20%, price = 397.6423.8
Inventory positionon hand + on order53 + 053

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

From qtyUnit costOrder qtyAnnual costFeasible
0397.6424201,374yes (chosen if cheapest)

MOQ 100, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 17, 202649 / 100384.5418,842.26
Oct. 14, 20264 / 4384.541,538.14

Movement ledger 137 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-292EAST 5 384.54-1,922.685320,380.41 Sept. 17, 2026: 5 @ 384.54
Oct. 15, 2026issueSO-261015-858MAIN 9 384.54-3,460.825822,303.09 Sept. 17, 2026: 9 @ 384.54
Oct. 14, 2026returnRMAMAIN 4 384.541,538.146725,763.91
Oct. 9, 2026issueSO-261009-400MAIN 9 384.54-3,460.826324,225.77 Sept. 17, 2026: 9 @ 384.54
Oct. 8, 2026issueSO-261008-462MAIN 2 384.54-769.077227,686.59 Sept. 17, 2026: 2 @ 384.54
Oct. 4, 2026issueSO-261004-541MAIN 12 384.54-4,614.437428,455.66 Sept. 17, 2026: 12 @ 384.54
Oct. 3, 2026issueSO-261003-170MAIN 7 384.54-2,691.758633,070.10 Sept. 17, 2026: 7 @ 384.54
Oct. 2, 2026issueSO-261002-652MAIN 7 384.54-2,691.759335,761.85 Sept. 17, 2026: 7 @ 384.54
Sept. 17, 2026transferTRFMAIN → EAST 23 warehouse transfer, no cost effect
Sept. 17, 2026receiptPO-001806MAIN 100 384.5438,453.6010038,453.60
Sept. 12, 2026issueSO-260912-691MAIN 4 383.75-1,534.9800.00 Aug. 4, 2026: 4 @ 383.75
Sept. 10, 2026issueSO-260910-687MAIN 21 383.76-8,058.9641,534.98 July 3, 2026: 19 @ 383.75; July 14, 2026: 1 @ 384.04; Aug. 4, 2026: 1 @ 383.75
Sept. 9, 2026issueSO-260909-742MAIN 3 383.75-1,151.24259,593.94 July 3, 2026: 3 @ 383.75
Sept. 6, 2026issueSO-260906-719MAIN 4 383.75-1,534.982810,745.18 July 3, 2026: 4 @ 383.75
Aug. 30, 2026issueSO-260830-960MAIN 22 383.75-8,442.413212,280.16 July 3, 2026: 22 @ 383.75
Aug. 27, 2026issueSO-260827-214MAIN 4 383.75-1,534.985420,722.57 July 3, 2026: 4 @ 383.75
Aug. 25, 2026issueSO-260825-262MAIN 2 383.75-767.495822,257.55 July 3, 2026: 2 @ 383.75
Aug. 9, 2026issueSO-260809-403MAIN 10 383.75-3,837.466023,025.04 July 3, 2026: 10 @ 383.75
Aug. 4, 2026returnRMAMAIN 5 383.751,918.737026,862.50
Aug. 3, 2026issueSO-260803-853MAIN 1 383.75-383.756524,943.77 July 3, 2026: 1 @ 383.75
July 29, 2026issueSO-260729-155MAIN 3 383.75-1,151.246625,327.52 July 3, 2026: 3 @ 383.75
July 25, 2026issueSO-260725-852MAIN 10 383.75-3,837.466926,478.76 July 3, 2026: 10 @ 383.75
July 21, 2026issueSO-260721-189MAIN 17 383.75-6,523.687930,316.21 July 3, 2026: 17 @ 383.75
July 14, 2026returnRMAMAIN 1 384.04384.049636,839.89
July 8, 2026issueSO-260708-983MAIN 6 384.04-2,304.259536,455.85 April 28, 2026: 1 @ 385.52; July 3, 2026: 5 @ 383.75
July 3, 2026issueSO-260703-883MAIN 10 385.52-3,855.1910138,760.10 April 28, 2026: 10 @ 385.52
July 3, 2026receiptPO-001621MAIN 100 383.7538,374.5811142,615.29
June 30, 2026issueSO-260630-267MAIN 12 385.52-4,626.22114,240.71 April 28, 2026: 12 @ 385.52
June 26, 2026issueSO-260626-423MAIN 3 385.52-1,156.56238,866.93 April 28, 2026: 3 @ 385.52
June 24, 2026issueSO-260624-927MAIN 2 385.52-771.042610,023.49 April 28, 2026: 2 @ 385.52
June 19, 2026issueSO-260619-809MAIN 6 385.52-2,313.112810,794.52 April 28, 2026: 6 @ 385.52
June 16, 2026issueSO-260616-760MAIN 3 385.52-1,156.563413,107.64 April 28, 2026: 3 @ 385.52
June 12, 2026issueSO-260612-313MAIN 10 385.52-3,855.193714,264.19 April 28, 2026: 10 @ 385.52
May 14, 2026issueSO-260514-882MAIN 46 385.52-17,733.864718,119.38 April 28, 2026: 46 @ 385.52
May 8, 2026issueSO-260508-720MAIN 7 385.52-2,698.639335,853.24 April 28, 2026: 7 @ 385.52
May 4, 2026issueSO-260504-179MAIN 8 393.18-3,145.4610038,551.87 Feb. 26, 2026: 6 @ 393.18; March 6, 2026: 1 @ 393.18; April 10, 2026: 1 @ 393.18
April 30, 2026issueSO-260430-396MAIN 11 393.18-4,325.0110841,697.33 Feb. 26, 2026: 11 @ 393.18
April 28, 2026receiptPO-001445MAIN 100 385.5238,551.8711946,022.34
April 14, 2026issueSO-260414-175MAIN 9 393.18-3,538.64197,470.47 Feb. 26, 2026: 9 @ 393.18
April 13, 2026issueSO-260413-704MAIN 28 393.18-11,009.122811,009.12 Feb. 26, 2026: 28 @ 393.18
April 11, 2026issueSO-260411-300MAIN 1 393.18-393.185622,018.23 Feb. 26, 2026: 1 @ 393.18
April 10, 2026returnRMAMAIN 1 393.18393.185722,411.41
April 9, 2026issueSO-260409-915MAIN 6 393.18-2,359.105622,018.23 Feb. 26, 2026: 6 @ 393.18
March 31, 2026issueSO-260331-803MAIN 3 393.18-1,179.556224,377.33 Feb. 26, 2026: 3 @ 393.18
March 27, 2026issueSO-260327-523MAIN 1 393.18-393.186525,556.88 Feb. 26, 2026: 1 @ 393.18
March 19, 2026issueSO-260319-399MAIN 1 393.18-393.186625,950.06 Feb. 26, 2026: 1 @ 393.18
March 17, 2026issueSO-260317-732MAIN 17 393.18-6,684.116726,343.24 Feb. 26, 2026: 17 @ 393.18
March 16, 2026issueSO-260316-266MAIN 3 393.18-1,179.558433,027.35 Feb. 26, 2026: 3 @ 393.18
March 16, 2026issueSO-260316-266EAST 10 393.18-3,931.838734,206.89 Feb. 26, 2026: 10 @ 393.18
March 6, 2026returnRMAMAIN 1 393.18393.189738,138.72
March 3, 2026issueSO-260303-468EAST 4 393.18-1,572.739637,745.54 Feb. 26, 2026: 4 @ 393.18
March 1, 2026issueSO-260301-236MAIN 2 383.18-766.3510039,318.27 Dec. 30, 2025: 2 @ 383.18
Feb. 27, 2026issueSO-260227-254MAIN 1 383.18-383.1810240,084.62 Dec. 30, 2025: 1 @ 383.18
Feb. 26, 2026issueSO-260226-296MAIN 11 383.18-4,214.9310340,467.80 Dec. 30, 2025: 11 @ 383.18
Feb. 26, 2026receiptPO-001258MAIN 100 393.1839,318.2711444,682.72
Feb. 24, 2026issueSO-260224-540EAST 11 383.18-4,214.93145,364.45 Dec. 30, 2025: 11 @ 383.18
Feb. 21, 2026issueSO-260221-763EAST 1 383.18-383.18259,579.38 Dec. 30, 2025: 1 @ 383.18
Feb. 21, 2026issueSO-260221-763MAIN 5 383.18-1,915.88269,962.56 Dec. 30, 2025: 5 @ 383.18
Feb. 16, 2026issueSO-260216-975EAST 8 383.18-3,065.403111,878.43 Dec. 30, 2025: 8 @ 383.18
Feb. 14, 2026issueSO-260214-467MAIN 1 383.18-383.183914,943.83 Dec. 30, 2025: 1 @ 383.18
Feb. 6, 2026issueSO-260206-734MAIN 3 383.18-1,149.534015,327.01 Dec. 30, 2025: 3 @ 383.18
Jan. 24, 2026issueSO-260124-350MAIN 44 383.18-16,859.714316,476.53 Dec. 30, 2025: 44 @ 383.18
Jan. 2, 2026issueSO-260102-389MAIN 13 383.18-4,981.288733,336.24 Dec. 30, 2025: 13 @ 383.18
Dec. 30, 2025transferTRFMAIN → EAST 34 warehouse transfer, no cost effect
Dec. 30, 2025receiptPO-001104MAIN 100 383.1838,317.5210038,317.52
Dec. 27, 2025issueSO-251227-887EAST 16 379.81-6,076.9300.00 Oct. 6, 2025: 16 @ 379.81
Dec. 23, 2025issueSO-251223-854EAST 2 379.81-759.62166,076.93 Oct. 6, 2025: 2 @ 379.81
Dec. 14, 2025issueSO-251214-894EAST 5 379.81-1,899.04186,836.54 Oct. 6, 2025: 5 @ 379.81
Dec. 14, 2025issueSO-251214-894MAIN 6 379.81-2,278.85238,735.58 Oct. 6, 2025: 6 @ 379.81
Dec. 13, 2025issueSO-251213-945EAST 6 379.81-2,278.852911,014.43 Oct. 6, 2025: 6 @ 379.81
Nov. 28, 2025issueSO-251128-692EAST 3 379.81-1,139.423513,293.28 Oct. 6, 2025: 3 @ 379.81
Nov. 26, 2025issueSO-251126-363MAIN 2 379.81-759.623814,432.70 Oct. 6, 2025: 2 @ 379.81
Nov. 25, 2025issueSO-251125-465MAIN 23 379.81-8,735.584015,192.32 Oct. 6, 2025: 23 @ 379.81
Nov. 10, 2025issueSO-251110-497MAIN 7 379.81-2,658.666323,927.90 Oct. 6, 2025: 7 @ 379.81
Nov. 3, 2025issueSO-251103-710MAIN 1 379.81-379.817026,586.55 Oct. 6, 2025: 1 @ 379.81
Oct. 28, 2025issueSO-251028-397MAIN 15 379.81-5,697.127126,966.36 Oct. 6, 2025: 15 @ 379.81
Oct. 16, 2025issueSO-251016-497MAIN 14 379.81-5,317.318632,663.48 Oct. 6, 2025: 14 @ 379.81
Oct. 6, 2025transferTRFMAIN → EAST 32 warehouse transfer, no cost effect
Oct. 6, 2025receiptPO-000902MAIN 100 379.8137,980.7910037,980.79
Oct. 5, 2025issueSO-251005-414EAST 2 375.50-750.9900.00 July 27, 2025: 2 @ 375.50
Sept. 29, 2025issueSO-250929-625EAST 7 375.50-2,628.472750.99 July 27, 2025: 7 @ 375.50
Sept. 29, 2025issueSO-250929-625MAIN 14 375.50-5,256.9393,379.46 July 27, 2025: 14 @ 375.50
Sept. 27, 2025issueSO-250927-150MAIN 16 375.50-6,007.92238,636.39 July 27, 2025: 16 @ 375.50
Sept. 21, 2025issueSO-250921-255MAIN 5 375.50-1,877.483914,644.31 July 27, 2025: 5 @ 375.50
Sept. 17, 2025issueSO-250917-153EAST 19 375.50-7,134.414416,521.78 July 27, 2025: 19 @ 375.50
Aug. 30, 2025issueSO-250830-285MAIN 19 375.50-7,134.416323,656.19 July 27, 2025: 19 @ 375.50
Aug. 22, 2025issueSO-250822-436EAST 1 375.50-375.508230,790.60 July 27, 2025: 1 @ 375.50
Aug. 21, 2025issueSO-250821-538EAST 1 375.50-375.508331,166.09 July 27, 2025: 1 @ 375.50
Aug. 20, 2025issueSO-250820-860MAIN 6 375.50-2,252.978431,541.59 July 27, 2025: 6 @ 375.50
Aug. 13, 2025issueSO-250813-573MAIN 3 375.50-1,126.499033,794.56 July 27, 2025: 3 @ 375.50
Aug. 10, 2025issueSO-250810-935MAIN 11 376.41-4,140.509334,921.04 May 26, 2025: 4 @ 378.01; July 27, 2025: 7 @ 375.50
Aug. 2, 2025issueSO-250802-966EAST 5 378.01-1,890.0410439,061.54 May 26, 2025: 5 @ 378.01
July 27, 2025transferTRFMAIN → EAST 35 warehouse transfer, no cost effect
July 27, 2025receiptPO-000737MAIN 100 375.5037,549.5110940,951.59
July 11, 2025issueSO-250711-827MAIN 6 378.01-2,268.0593,402.08 May 26, 2025: 6 @ 378.01
July 10, 2025issueSO-250710-253MAIN 42 378.01-15,876.37155,670.13 May 26, 2025: 42 @ 378.01
June 22, 2025issueSO-250622-539MAIN 15 378.01-5,670.135721,546.50 May 26, 2025: 15 @ 378.01
June 15, 2025issueSO-250615-235MAIN 27 378.01-10,206.237227,216.63 May 26, 2025: 27 @ 378.01
June 9, 2025issueSO-250609-485MAIN 1 378.01-378.019937,422.86 May 26, 2025: 1 @ 378.01
May 26, 2025receiptPO-000577MAIN 100 378.0137,800.8710037,800.87
May 21, 2025issueSO-250521-963EAST 2 377.74-755.4800.00 March 4, 2025: 2 @ 377.74
May 21, 2025issueSO-250521-963MAIN 23 377.74-8,687.972755.48 March 4, 2025: 23 @ 377.74
May 12, 2025issueSO-250512-530EAST 27 377.74-10,198.93259,443.45 March 4, 2025: 27 @ 377.74
April 22, 2025issueSO-250422-664MAIN 9 377.74-3,399.645219,642.38 March 4, 2025: 9 @ 377.74
April 17, 2025issueSO-250417-708EAST 4 377.74-1,510.956123,042.02 March 4, 2025: 4 @ 377.74
April 14, 2025issueSO-250414-982MAIN 15 377.74-5,666.076524,552.97 March 4, 2025: 15 @ 377.74
April 4, 2025issueSO-250404-747MAIN 7 377.74-2,644.178030,219.04 March 4, 2025: 7 @ 377.74
March 31, 2025issueSO-250331-222MAIN 10 377.74-3,777.388732,863.21 March 4, 2025: 10 @ 377.74
March 10, 2025issueSO-250310-358MAIN 7 373.41-2,613.849736,640.59 Jan. 18, 2025: 4 @ 370.16; March 4, 2025: 3 @ 377.74
March 5, 2025issueSO-250305-708MAIN 26 370.16-9,624.0610439,254.42 Jan. 18, 2025: 26 @ 370.16
March 4, 2025transferTRFMAIN → EAST 33 warehouse transfer, no cost effect
March 4, 2025receiptPO-000311MAIN 100 377.7437,773.8013048,878.48
March 1, 2025issueSO-250301-309MAIN 1 370.16-370.163011,104.68 Jan. 18, 2025: 1 @ 370.16
March 1, 2025issueSO-250301-309EAST 1 370.16-370.163111,474.84 Jan. 18, 2025: 1 @ 370.16
Feb. 17, 2025issueSO-250217-896MAIN 17 370.16-6,292.653211,844.99 Jan. 18, 2025: 17 @ 370.16
Feb. 15, 2025issueSO-250215-572MAIN 13 370.16-4,812.034918,137.64 Jan. 18, 2025: 13 @ 370.16
Feb. 11, 2025issueSO-250211-245MAIN 16 370.16-5,922.506222,949.67 Jan. 18, 2025: 16 @ 370.16
Feb. 7, 2025issueSO-250207-633MAIN 11 370.16-4,071.727828,872.17 Jan. 18, 2025: 11 @ 370.16
Feb. 5, 2025issueSO-250205-617EAST 1 370.16-370.168932,943.88 Jan. 18, 2025: 1 @ 370.16
Jan. 27, 2025issueSO-250127-385EAST 20 368.51-7,370.209033,314.04 Dec. 8, 2024: 10 @ 366.86; Jan. 18, 2025: 10 @ 370.16
Jan. 23, 2025issueSO-250123-112MAIN 10 366.86-3,668.6411040,684.24 Dec. 8, 2024: 10 @ 366.86
Jan. 18, 2025transferTRFMAIN → EAST 22 warehouse transfer, no cost effect
Jan. 18, 2025receiptPO-000194MAIN 100 370.1637,015.6012044,352.87
Jan. 11, 2025issueSO-250111-415MAIN 8 366.86-2,934.91207,337.27 Dec. 8, 2024: 8 @ 366.86
Jan. 6, 2025issueSO-250106-469MAIN 20 366.86-7,337.272810,272.18 Dec. 8, 2024: 20 @ 366.86
Jan. 2, 2025issueSO-250102-932MAIN 1 366.86-366.864817,609.46 Dec. 8, 2024: 1 @ 366.86
Dec. 31, 2024issueSO-241231-211MAIN 10 366.86-3,668.644917,976.32 Dec. 8, 2024: 10 @ 366.86
Dec. 11, 2024issueSO-241211-169MAIN 42 367.12-15,419.175921,644.96 Oct. 1, 2024: 1 @ 377.76; Dec. 8, 2024: 41 @ 366.86
Dec. 8, 2024receiptPO-000084MAIN 100 366.8636,686.3710137,064.13
Nov. 30, 2024issueSO-241130-715MAIN 1 377.76-377.761377.76 Oct. 1, 2024: 1 @ 377.76
Nov. 26, 2024issueSO-241126-971MAIN 22 377.76-8,310.682755.52 Oct. 1, 2024: 22 @ 377.76
Nov. 24, 2024issueSO-241124-495MAIN 40 377.76-15,110.32249,066.19 Oct. 1, 2024: 40 @ 377.76
Nov. 8, 2024issueSO-241108-274MAIN 1 377.76-377.766424,176.51 Oct. 1, 2024: 1 @ 377.76
Oct. 22, 2024issueSO-241022-515MAIN 15 377.76-5,666.376524,554.27 Oct. 1, 2024: 15 @ 377.76
Oct. 14, 2024issueSO-241014-281MAIN 4 377.76-1,511.038030,220.64 Oct. 1, 2024: 4 @ 377.76
Oct. 2, 2024issueSO-241002-905MAIN 16 377.76-6,044.138431,731.67 Oct. 1, 2024: 16 @ 377.76
Oct. 1, 2024receiptPO-000002MAIN 100 377.7637,775.8010037,775.80