stocksense

Items / CAB-0027

FR Wire 4 sqmm Max CAB-0027 · Cables & Wires · Conduit & Cable Co

On hand (COIL)11MAIN 11
Value (FIFO)514.25avg 46.75
ClassAX / FCV 0.18
Turnover10.1xlast issue 4 days ago
Days of cover6lead time 14d

Reorder suggested: 120 units (position at or below reorder point: order EOQ), stockout risk high.

Demand and forecast

Monthly demand and forecast for CAB-00270.021.242.463.584.7Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 66.0Nov 24: 77.0Dec 24: 72.0Jan 25: 32.0Feb 25: 44.0Mar 25: 42.0Apr 25: 60.0May 25: 76.0Jun 25: 38.0Jul 25: 77.0Aug 25: 50.0Sep 25: 43.0Oct 25: 69.0Nov 25: 54.0Dec 25: 43.0Jan 26: 56.0Feb 26: 61.0Mar 26: 53.0Apr 26: 66.0May 26: 76.0Jun 26: 52.0Jul 26: 75.0Aug 26: 59.0Sep 26: 44.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.437559.00 / 30.43751.938
Daily demand sdmonthly sd / sqrt(30.4375)10.40 / 5.5171.885
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.885^2 + 1.938^2 * 3.1^2)19.1
Reorder pointd * LT + safety stock1.938 * 14.0 + 19.146.3
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days46.3
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 708/yr, S = 45.00, h = 20%, price = 48.4581.1
Inventory positionon hand + on order11 + 011

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

From qtyUnit costOrder qtyAnnual costFeasible
048.458135,065yes (chosen if cheapest)

MOQ 120, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 15, 20262 / 446.7593.50
Aug. 21, 20269 / 946.75420.75

Movement ledger 131 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 12, 2026issueSO-261012-269MAIN 19 46.75-888.2511514.25 Aug. 11, 2026: 17 @ 46.75; Aug. 15, 2026: 2 @ 46.75
Oct. 10, 2026issueSO-261010-133MAIN 21 46.75-981.75301,402.51 Aug. 11, 2026: 21 @ 46.75
Oct. 1, 2026issueSO-261001-986MAIN 4 46.75-187.00512,384.26 Aug. 11, 2026: 4 @ 46.75
Sept. 19, 2026issueSO-260919-967MAIN 6 46.75-280.50552,571.26 Aug. 11, 2026: 6 @ 46.75
Sept. 12, 2026issueSO-260912-819MAIN 3 46.75-140.25612,851.76 Aug. 11, 2026: 3 @ 46.75
Sept. 10, 2026issueSO-260910-451MAIN 21 46.75-981.75642,992.01 Aug. 11, 2026: 21 @ 46.75
Sept. 4, 2026issueSO-260904-927MAIN 14 46.75-654.50853,973.77 Aug. 11, 2026: 14 @ 46.75
Aug. 29, 2026issueSO-260829-345MAIN 1 46.75-46.75994,628.27 Aug. 11, 2026: 1 @ 46.75
Aug. 29, 2026issueSO-260829-345EAST 4 46.75-187.001004,675.02 Aug. 11, 2026: 4 @ 46.75
Aug. 21, 2026returnRMAMAIN 9 46.75420.751044,862.02
Aug. 15, 2026returnRMAMAIN 4 46.75187.00954,441.27
Aug. 12, 2026issueSO-260812-250EAST 29 46.75-1,355.76914,254.27 Aug. 11, 2026: 29 @ 46.75
Aug. 11, 2026transferTRFMAIN → EAST 33 warehouse transfer, no cost effect
Aug. 11, 2026receiptPO-001712MAIN 120 46.755,610.021205,610.02
Aug. 5, 2026issueSO-260805-468EAST 2 48.17-96.3300.00 June 22, 2026: 2 @ 48.17
Aug. 3, 2026issueSO-260803-329EAST 19 48.17-915.17296.33 June 22, 2026: 19 @ 48.17
Aug. 3, 2026issueSO-260803-329MAIN 8 48.17-385.34211,011.51 June 22, 2026: 8 @ 48.17
Aug. 2, 2026issueSO-260802-843EAST 9 48.17-433.50291,396.84 June 22, 2026: 9 @ 48.17
July 31, 2026issueSO-260731-256MAIN 6 48.17-289.00381,830.35 June 22, 2026: 6 @ 48.17
July 25, 2026issueSO-260725-656MAIN 34 48.17-1,637.68442,119.35 June 22, 2026: 34 @ 48.17
July 12, 2026issueSO-260712-416MAIN 35 48.17-1,685.84783,757.03 June 22, 2026: 35 @ 48.17
June 26, 2026issueSO-260626-647MAIN 7 48.17-337.171135,442.87 June 22, 2026: 7 @ 48.17
June 22, 2026transferTRFMAIN → EAST 30 warehouse transfer, no cost effect
June 22, 2026receiptPO-001593MAIN 120 48.175,780.041205,780.04
June 19, 2026issueSO-260619-173MAIN 7 46.71-326.9800.00 April 21, 2026: 7 @ 46.71
June 14, 2026issueSO-260614-848MAIN 3 46.71-140.137326.98 April 21, 2026: 3 @ 46.71
June 10, 2026issueSO-260610-657MAIN 29 46.71-1,354.6210467.11 April 21, 2026: 29 @ 46.71
June 7, 2026issueSO-260607-951MAIN 3 46.71-140.13391,821.73 April 21, 2026: 3 @ 46.71
June 4, 2026issueSO-260604-449MAIN 3 46.71-140.13421,961.86 April 21, 2026: 3 @ 46.71
May 24, 2026issueSO-260524-381MAIN 17 46.71-794.09452,102.00 April 21, 2026: 17 @ 46.71
May 24, 2026issueSO-260524-381EAST 18 46.71-840.80622,896.08 April 21, 2026: 18 @ 46.71
May 21, 2026issueSO-260521-190MAIN 6 46.71-280.27803,736.88 April 21, 2026: 6 @ 46.71
May 19, 2026issueSO-260519-463MAIN 12 46.71-560.53864,017.15 April 21, 2026: 12 @ 46.71
May 2, 2026issueSO-260502-310MAIN 23 46.75-1,075.26984,577.68 March 4, 2026: 1 @ 47.62; April 21, 2026: 22 @ 46.71
April 24, 2026issueSO-260424-296MAIN 13 47.62-619.081215,652.94 March 4, 2026: 13 @ 47.62
April 23, 2026issueSO-260423-811MAIN 2 47.62-95.241346,272.02 March 4, 2026: 2 @ 47.62
April 22, 2026issueSO-260422-933MAIN 2 47.62-95.241366,367.27 March 4, 2026: 2 @ 47.62
April 21, 2026receiptPO-001425MAIN 120 46.715,605.321386,462.51
April 19, 2026issueSO-260419-982EAST 19 47.62-904.8118857.19 March 4, 2026: 19 @ 47.62
April 7, 2026issueSO-260407-896MAIN 30 47.62-1,428.65371,762.00 March 4, 2026: 30 @ 47.62
March 25, 2026issueSO-260325-747MAIN 11 47.62-523.84673,190.65 March 4, 2026: 11 @ 47.62
March 23, 2026issueSO-260323-978MAIN 2 47.62-95.24783,714.49 March 4, 2026: 2 @ 47.62
March 17, 2026issueSO-260317-188MAIN 8 47.62-380.97803,809.74 March 4, 2026: 8 @ 47.62
March 13, 2026issueSO-260313-229MAIN 13 47.62-619.08884,190.71 March 4, 2026: 13 @ 47.62
March 11, 2026issueSO-260311-829MAIN 7 47.62-333.351014,809.79 March 4, 2026: 7 @ 47.62
March 9, 2026issueSO-260309-602MAIN 12 47.62-571.461085,143.14 March 4, 2026: 12 @ 47.62
March 4, 2026transferTRFMAIN → EAST 37 warehouse transfer, no cost effect
March 4, 2026receiptPO-001282MAIN 120 47.625,714.601205,714.60
Feb. 20, 2026issueSO-260220-249MAIN 55 47.94-2,636.8300.00 Dec. 11, 2025: 55 @ 47.94
Feb. 19, 2026issueSO-260219-418MAIN 6 47.94-287.65552,636.83 Dec. 11, 2025: 6 @ 47.94
Jan. 23, 2026issueSO-260123-621MAIN 22 47.94-1,054.73612,924.48 Dec. 11, 2025: 22 @ 47.94
Jan. 17, 2026issueSO-260117-495MAIN 34 47.94-1,630.04833,979.21 Dec. 11, 2025: 34 @ 47.94
Dec. 29, 2025issueSO-251229-860MAIN 2 47.94-95.881175,609.25 Dec. 11, 2025: 2 @ 47.94
Dec. 13, 2025issueSO-251213-973MAIN 1 47.94-47.941195,705.13 Dec. 11, 2025: 1 @ 47.94
Dec. 11, 2025receiptPO-001044MAIN 120 47.945,753.081205,753.08
Dec. 5, 2025issueSO-251205-185MAIN 6 46.00-275.9800.00 Nov. 12, 2025: 6 @ 46.00
Dec. 3, 2025issueSO-251203-296MAIN 33 46.00-1,517.896275.98 Oct. 15, 2025: 23 @ 46.00; Nov. 12, 2025: 10 @ 46.00
Dec. 2, 2025issueSO-251202-886MAIN 1 46.00-46.00391,793.87 Oct. 15, 2025: 1 @ 46.00
Nov. 26, 2025issueSO-251126-963MAIN 28 46.00-1,287.90401,839.86 Oct. 15, 2025: 28 @ 46.00
Nov. 12, 2025returnRMAMAIN 16 46.00735.95683,127.77
Nov. 4, 2025issueSO-251104-781MAIN 42 46.00-1,931.86522,391.82 Oct. 15, 2025: 42 @ 46.00
Oct. 29, 2025issueSO-251029-747MAIN 10 46.00-459.97944,323.68 Oct. 15, 2025: 10 @ 46.00
Oct. 26, 2025issueSO-251026-550MAIN 1 46.00-46.001044,783.65 Oct. 15, 2025: 1 @ 46.00
Oct. 25, 2025issueSO-251025-676MAIN 33 45.43-1,499.261054,829.64 July 26, 2025: 18 @ 44.96; Oct. 15, 2025: 15 @ 46.00
Oct. 22, 2025issueSO-251022-871MAIN 6 44.96-269.771386,328.91 July 26, 2025: 6 @ 44.96
Oct. 15, 2025receiptPO-000919MAIN 120 46.005,519.591446,598.68
Oct. 8, 2025issueSO-251008-543MAIN 16 44.96-719.39241,079.09 July 26, 2025: 16 @ 44.96
Oct. 5, 2025issueSO-251005-698MAIN 3 44.96-134.89401,798.48 July 26, 2025: 3 @ 44.96
Sept. 28, 2025issueSO-250928-223MAIN 4 44.96-179.85431,933.36 July 26, 2025: 4 @ 44.96
Sept. 28, 2025issueSO-250928-223EAST 16 44.96-719.39472,113.21 July 26, 2025: 16 @ 44.96
Sept. 21, 2025issueSO-250921-679MAIN 8 44.96-359.70632,832.60 July 26, 2025: 8 @ 44.96
Sept. 17, 2025issueSO-250917-201MAIN 1 44.96-44.96713,192.29 July 26, 2025: 1 @ 44.96
Sept. 16, 2025issueSO-250916-259EAST 11 44.96-494.58723,237.26 July 26, 2025: 11 @ 44.96
Sept. 8, 2025issueSO-250908-197EAST 2 44.96-89.92833,731.84 July 26, 2025: 2 @ 44.96
Sept. 6, 2025issueSO-250906-742MAIN 1 44.96-44.96853,821.76 July 26, 2025: 1 @ 44.96
Aug. 16, 2025issueSO-250816-954MAIN 41 45.14-1,850.62863,866.72 June 14, 2025: 7 @ 45.99; July 26, 2025: 34 @ 44.96
Aug. 12, 2025issueSO-250812-479MAIN 9 45.99-413.891275,717.34 June 14, 2025: 9 @ 45.99
July 26, 2025transferTRFMAIN → EAST 29 warehouse transfer, no cost effect
July 26, 2025receiptPO-000734MAIN 120 44.965,395.431366,131.23
July 15, 2025issueSO-250715-442MAIN 18 45.99-827.7816735.80 June 14, 2025: 18 @ 45.99
July 11, 2025issueSO-250711-523MAIN 37 45.99-1,701.54341,563.58 June 14, 2025: 37 @ 45.99
July 3, 2025issueSO-250703-810MAIN 22 45.99-1,011.73713,265.13 June 14, 2025: 22 @ 45.99
June 29, 2025issueSO-250629-659MAIN 4 45.99-183.95934,276.86 June 14, 2025: 4 @ 45.99
June 26, 2025issueSO-250626-842MAIN 9 45.99-413.89974,460.81 June 14, 2025: 9 @ 45.99
June 24, 2025issueSO-250624-506MAIN 2 45.99-91.981064,874.70 June 14, 2025: 2 @ 45.99
June 22, 2025issueSO-250622-967MAIN 12 45.99-551.851084,966.67 June 14, 2025: 12 @ 45.99
June 14, 2025receiptPO-000633MAIN 120 45.995,518.521205,518.52
June 7, 2025issueSO-250607-874MAIN 11 46.24-508.6700.00 March 31, 2025: 9 @ 46.24; April 23, 2025: 1 @ 46.24; May 22, 2025: 1 @ 46.24
May 31, 2025issueSO-250531-638MAIN 33 46.24-1,526.0211508.67 March 31, 2025: 33 @ 46.24
May 27, 2025issueSO-250527-918MAIN 12 46.24-554.92442,034.69 March 31, 2025: 12 @ 46.24
May 22, 2025returnRMAMAIN 1 46.2446.24562,589.61
May 19, 2025issueSO-250519-150MAIN 3 46.24-138.73552,543.36 March 31, 2025: 3 @ 46.24
May 17, 2025issueSO-250517-181MAIN 15 46.24-693.64582,682.09 March 31, 2025: 15 @ 46.24
May 10, 2025issueSO-250510-114MAIN 1 46.24-46.24733,375.74 March 31, 2025: 1 @ 46.24
May 8, 2025issueSO-250508-989MAIN 13 46.24-601.16743,421.98 March 31, 2025: 13 @ 46.24
April 23, 2025returnRMAMAIN 1 46.2446.24874,023.14
April 22, 2025issueSO-250422-724MAIN 4 46.24-184.97863,976.90 March 31, 2025: 4 @ 46.24
April 20, 2025issueSO-250420-444MAIN 3 46.24-138.73904,161.87 March 31, 2025: 3 @ 46.24
April 13, 2025issueSO-250413-709MAIN 41 45.84-1,879.28934,300.60 Jan. 15, 2025: 11 @ 45.05; March 21, 2025: 3 @ 45.05; March 31, 2025: 27 @ 46.24
April 10, 2025issueSO-250410-695MAIN 11 45.05-495.561346,179.87 Jan. 15, 2025: 11 @ 45.05
April 5, 2025issueSO-250405-633MAIN 2 45.05-90.101456,675.44 Jan. 15, 2025: 2 @ 45.05
March 31, 2025issueSO-250331-774MAIN 2 45.05-90.101476,765.54 Jan. 15, 2025: 2 @ 45.05
March 31, 2025receiptPO-000395MAIN 120 46.245,549.161496,855.64
March 22, 2025issueSO-250322-577MAIN 6 45.05-270.31291,306.48 Jan. 15, 2025: 6 @ 45.05
March 21, 2025returnRMAMAIN 3 45.05135.15351,576.78
March 19, 2025issueSO-250319-694MAIN 16 45.05-720.82321,441.63 Jan. 15, 2025: 16 @ 45.05
March 16, 2025issueSO-250316-679MAIN 6 45.05-270.31482,162.45 Jan. 15, 2025: 6 @ 45.05
March 9, 2025issueSO-250309-615MAIN 7 45.05-315.36542,432.75 Jan. 15, 2025: 7 @ 45.05
March 1, 2025issueSO-250301-601MAIN 8 45.05-360.41612,748.11 Jan. 15, 2025: 8 @ 45.05
Feb. 26, 2025issueSO-250226-517MAIN 4 45.05-180.20693,108.52 Jan. 15, 2025: 4 @ 45.05
Feb. 11, 2025issueSO-250211-389MAIN 4 45.05-180.20733,288.72 Jan. 15, 2025: 4 @ 45.05
Feb. 10, 2025issueSO-250210-263MAIN 11 45.05-495.56773,468.93 Jan. 15, 2025: 11 @ 45.05
Feb. 9, 2025issueSO-250209-462MAIN 25 45.05-1,126.28883,964.49 Jan. 15, 2025: 25 @ 45.05
Jan. 23, 2025issueSO-250123-200MAIN 2 45.05-90.101135,090.76 Jan. 15, 2025: 2 @ 45.05
Jan. 19, 2025issueSO-250119-801MAIN 5 45.05-225.261155,180.86 Jan. 15, 2025: 5 @ 45.05
Jan. 15, 2025receiptPO-000187MAIN 120 45.055,406.121205,406.12
Jan. 5, 2025issueSO-250105-187MAIN 25 43.33-1,083.2700.00 Nov. 12, 2024: 25 @ 43.33
Dec. 31, 2024issueSO-241231-987MAIN 23 43.33-996.61251,083.27 Nov. 12, 2024: 23 @ 43.33
Dec. 30, 2024issueSO-241230-177MAIN 19 43.33-823.29482,079.88 Nov. 12, 2024: 19 @ 43.33
Dec. 27, 2024issueSO-241227-963MAIN 16 43.33-693.29672,903.16 Nov. 12, 2024: 16 @ 43.33
Dec. 14, 2024issueSO-241214-786MAIN 2 43.33-86.66833,596.46 Nov. 12, 2024: 2 @ 43.33
Dec. 13, 2024issueSO-241213-669MAIN 8 43.33-346.65853,683.12 Nov. 12, 2024: 8 @ 43.33
Dec. 9, 2024issueSO-241209-934MAIN 3 43.33-129.99934,029.76 Nov. 12, 2024: 3 @ 43.33
Dec. 1, 2024issueSO-241201-360MAIN 1 43.33-43.33964,159.76 Nov. 12, 2024: 1 @ 43.33
Nov. 14, 2024issueSO-241114-928MAIN 6 43.33-259.98974,203.09 Nov. 12, 2024: 6 @ 43.33
Nov. 13, 2024issueSO-241113-971MAIN 17 43.33-736.621034,463.07 Nov. 12, 2024: 17 @ 43.33
Nov. 12, 2024receiptPO-000031MAIN 120 43.335,199.701205,199.70
Nov. 1, 2024issueSO-241101-138MAIN 54 46.03-2,485.4800.00 Oct. 1, 2024: 54 @ 46.03
Oct. 18, 2024issueSO-241018-430MAIN 14 46.03-644.38542,485.48 Oct. 1, 2024: 14 @ 46.03
Oct. 6, 2024issueSO-241006-296MAIN 52 46.03-2,393.43683,129.87 Oct. 1, 2024: 52 @ 46.03
Oct. 1, 2024receiptPO-000002MAIN 120 46.035,523.301205,523.30