stocksense

Items / CAB-0008

FR Wire 1.5 sqmm Nova CAB-0008 · Cables & Wires · Conduit & Cable Co

On hand (COIL)95MAIN 95
Value (FIFO)6,045.13avg 63.63
ClassAX / FCV 0.21
Turnover10.3xlast issue 2 days ago
Days of cover49lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00080.028.657.285.8114Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 74.0Nov 24: 75.0Dec 24: 104.0Jan 25: 79.0Feb 25: 87.0Mar 25: 48.0Apr 25: 53.0May 25: 66.0Jun 25: 49.0Jul 25: 49.0Aug 25: 54.0Sep 25: 75.0Oct 25: 54.0Nov 25: 64.0Dec 25: 36.0Jan 26: 60.0Feb 26: 76.0Mar 26: 56.0Apr 26: 59.0May 26: 67.0Jun 26: 78.0Jul 26: 37.0Aug 26: 62.0Sep 26: 60.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.08 / 30.43751.941
Daily demand sdmonthly sd / sqrt(30.4375)12.24 / 5.5172.218
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.218^2 + 1.941^2 * 3.1^2)21.1
Reorder pointd * LT + safety stock1.941 * 14.0 + 21.148.3
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days48.3
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 709/yr, S = 45.00, h = 20%, price = 58.17520.0
Inventory positionon hand + on order95 + 095

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

From qtyUnit costOrder qtyAnnual costFeasible
063.237145,697yes
26060.7026044,708yes
52058.1752044,302yes (chosen if cheapest)

MOQ 130, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 28, 202695 / 13063.636,045.13

Movement ledger 132 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-769MAIN 5 63.63-318.16956,045.13 Sept. 28, 2026: 5 @ 63.63
Oct. 11, 2026issueSO-261011-326MAIN 26 63.63-1,654.461006,363.29 Sept. 28, 2026: 26 @ 63.63
Oct. 5, 2026issueSO-261005-390MAIN 35 63.62-2,226.551268,017.75 July 26, 2026: 16 @ 64.13; July 29, 2026: 15 @ 63.07; Sept. 28, 2026: 4 @ 63.63
Oct. 1, 2026issueSO-261001-299MAIN 5 64.13-320.6316110,244.30 July 26, 2026: 5 @ 64.13
Sept. 28, 2026receiptPO-001835MAIN 130 63.638,272.2816610,564.93
Sept. 27, 2026issueSO-260927-502MAIN 7 64.13-448.88362,292.65 July 26, 2026: 7 @ 64.13
Sept. 15, 2026issueSO-260915-781MAIN 36 64.13-2,308.54432,741.53 July 26, 2026: 36 @ 64.13
Sept. 13, 2026issueSO-260913-660MAIN 2 64.13-128.25795,050.07 July 26, 2026: 2 @ 64.13
Sept. 2, 2026issueSO-260902-599MAIN 15 64.13-961.89815,178.32 July 26, 2026: 15 @ 64.13
Aug. 29, 2026issueSO-260829-928MAIN 1 64.13-64.13966,140.21 July 26, 2026: 1 @ 64.13
Aug. 29, 2026issueSO-260829-928EAST 26 64.13-1,667.28976,204.34 July 26, 2026: 26 @ 64.13
Aug. 22, 2026issueSO-260822-504MAIN 10 64.13-641.261237,871.61 July 26, 2026: 10 @ 64.13
Aug. 11, 2026issueSO-260811-861MAIN 25 63.58-1,589.381338,512.87 May 20, 2026: 13 @ 63.07; July 26, 2026: 12 @ 64.13
July 31, 2026issueSO-260731-589MAIN 9 63.07-567.6015810,102.25 May 20, 2026: 9 @ 63.07
July 30, 2026issueSO-260730-191MAIN 8 63.07-504.5416710,669.86 May 20, 2026: 8 @ 63.07
July 29, 2026returnRMAMAIN 15 63.07946.0017511,174.39
July 26, 2026transferTRFMAIN → EAST 26 warehouse transfer, no cost effect
July 26, 2026receiptPO-001673MAIN 130 64.138,336.3816010,228.39
July 25, 2026issueSO-260725-145MAIN 1 63.07-63.07301,892.01 May 20, 2026: 1 @ 63.07
July 14, 2026issueSO-260714-304MAIN 30 63.07-1,892.01311,955.07 May 20, 2026: 30 @ 63.07
July 10, 2026issueSO-260710-865MAIN 4 63.07-252.27613,847.08 May 20, 2026: 4 @ 63.07
June 30, 2026issueSO-260630-138MAIN 24 63.07-1,513.61654,099.35 May 20, 2026: 24 @ 63.07
June 25, 2026issueSO-260625-388MAIN 8 63.07-504.54895,612.95 May 20, 2026: 8 @ 63.07
June 16, 2026issueSO-260616-209MAIN 3 63.07-189.20976,117.49 May 20, 2026: 3 @ 63.07
June 12, 2026issueSO-260612-304MAIN 8 63.07-504.541006,306.69 May 20, 2026: 8 @ 63.07
June 12, 2026issueSO-260612-304EAST 30 62.56-1,876.931086,811.23 March 17, 2026: 8 @ 61.18; May 20, 2026: 22 @ 63.07
June 10, 2026issueSO-260610-224EAST 3 61.18-183.551388,688.16 March 17, 2026: 3 @ 61.18
June 7, 2026issueSO-260607-770EAST 2 61.18-122.371418,871.71 March 17, 2026: 2 @ 61.18
May 31, 2026issueSO-260531-438MAIN 2 61.18-122.371438,994.07 March 17, 2026: 2 @ 61.18
May 20, 2026issueSO-260520-597MAIN 25 61.18-1,529.571459,116.44 March 17, 2026: 25 @ 61.18
May 20, 2026transferTRFMAIN → EAST 35 warehouse transfer, no cost effect
May 20, 2026receiptPO-001509MAIN 130 63.078,198.7017010,646.01
May 19, 2026issueSO-260519-738MAIN 1 61.18-61.18402,447.31 March 17, 2026: 1 @ 61.18
May 6, 2026issueSO-260506-798MAIN 27 61.18-1,651.94412,508.49 March 17, 2026: 27 @ 61.18
May 3, 2026issueSO-260503-737MAIN 12 61.18-734.19684,160.43 March 17, 2026: 12 @ 61.18
April 28, 2026issueSO-260428-886MAIN 14 61.18-856.56804,894.62 March 17, 2026: 14 @ 61.18
April 12, 2026issueSO-260412-543MAIN 6 61.18-367.10945,751.18 March 17, 2026: 6 @ 61.18
April 10, 2026issueSO-260410-487MAIN 17 61.18-1,040.111006,118.28 March 17, 2026: 17 @ 61.18
April 7, 2026issueSO-260407-429EAST 12 61.18-734.191177,158.39 March 17, 2026: 12 @ 61.18
April 4, 2026issueSO-260404-971MAIN 10 62.85-628.451297,892.58 Feb. 11, 2026: 9 @ 63.03; March 17, 2026: 1 @ 61.18
March 26, 2026issueSO-260326-732EAST 12 63.03-756.361398,521.04 Feb. 11, 2026: 12 @ 63.03
March 23, 2026issueSO-260323-699MAIN 3 63.03-189.091519,277.40 Feb. 11, 2026: 3 @ 63.03
March 17, 2026receiptPO-001325MAIN 130 61.187,953.761549,466.49
March 12, 2026issueSO-260312-894EAST 9 63.03-567.27241,512.72 Feb. 11, 2026: 9 @ 63.03
March 6, 2026issueSO-260306-626EAST 9 63.03-567.27332,080.00 Feb. 11, 2026: 9 @ 63.03
March 6, 2026issueSO-260306-626MAIN 10 63.03-630.30422,647.27 Feb. 11, 2026: 10 @ 63.03
March 4, 2026issueSO-260304-830MAIN 4 63.03-252.12523,277.57 Feb. 11, 2026: 4 @ 63.03
March 1, 2026issueSO-260301-617MAIN 9 63.03-567.27563,529.69 Feb. 11, 2026: 9 @ 63.03
Feb. 15, 2026issueSO-260215-816MAIN 45 63.03-2,836.36654,096.96 Feb. 11, 2026: 45 @ 63.03
Feb. 12, 2026issueSO-260212-867MAIN 14 63.03-882.421106,933.32 Feb. 11, 2026: 14 @ 63.03
Feb. 11, 2026issueSO-260211-897MAIN 17 61.90-1,052.321247,815.74 Nov. 7, 2025: 6 @ 61.29; Dec. 25, 2025: 5 @ 61.29; Feb. 11, 2026: 6 @ 63.03
Feb. 11, 2026transferTRFMAIN → EAST 42 warehouse transfer, no cost effect
Feb. 11, 2026receiptPO-001216MAIN 130 63.038,193.931418,868.07
Jan. 30, 2026issueSO-260130-867MAIN 57 61.29-3,493.2811674.14 Nov. 7, 2025: 57 @ 61.29
Jan. 5, 2026issueSO-260105-927MAIN 3 61.29-183.86684,167.42 Nov. 7, 2025: 3 @ 61.29
Dec. 25, 2025returnRMAMAIN 5 61.29306.43714,351.28
Dec. 21, 2025issueSO-251221-459MAIN 11 61.29-674.14664,044.85 Nov. 7, 2025: 11 @ 61.29
Dec. 8, 2025issueSO-251208-233MAIN 30 61.29-1,838.57774,718.99 Nov. 7, 2025: 30 @ 61.29
Nov. 19, 2025issueSO-251119-144MAIN 12 61.29-735.431076,557.56 Nov. 7, 2025: 12 @ 61.29
Nov. 17, 2025issueSO-251117-883MAIN 40 60.45-2,417.991197,292.99 Sept. 5, 2025: 29 @ 60.13; Nov. 7, 2025: 11 @ 61.29
Nov. 8, 2025issueSO-251108-699MAIN 8 60.13-481.061599,710.98 Sept. 5, 2025: 8 @ 60.13
Nov. 7, 2025receiptPO-000983MAIN 130 61.297,967.1316710,192.04
Nov. 3, 2025issueSO-251103-971MAIN 4 60.13-240.53372,224.91 Sept. 5, 2025: 4 @ 60.13
Oct. 24, 2025issueSO-251024-627MAIN 6 60.13-360.80412,465.44 Sept. 5, 2025: 6 @ 60.13
Oct. 21, 2025issueSO-251021-128MAIN 3 60.13-180.40472,826.24 Sept. 5, 2025: 3 @ 60.13
Oct. 20, 2025issueSO-251020-854MAIN 2 60.13-120.27503,006.64 Sept. 5, 2025: 2 @ 60.13
Oct. 15, 2025issueSO-251015-638MAIN 34 60.13-2,044.52523,126.91 Sept. 5, 2025: 34 @ 60.13
Oct. 11, 2025issueSO-251011-879MAIN 8 60.13-481.06865,171.42 Sept. 5, 2025: 8 @ 60.13
Oct. 4, 2025issueSO-251004-905MAIN 1 60.13-60.13945,652.48 Sept. 5, 2025: 1 @ 60.13
Sept. 20, 2025issueSO-250920-260MAIN 23 60.13-1,383.05955,712.62 Sept. 5, 2025: 23 @ 60.13
Sept. 15, 2025issueSO-250915-576MAIN 17 60.27-1,024.521187,095.67 June 27, 2025: 5 @ 60.59; Sept. 5, 2025: 12 @ 60.13
Sept. 7, 2025adjustmentCycle countMAIN -2 60.59-121.171358,120.19 June 27, 2025: 2 @ 60.59
Sept. 5, 2025issueSO-250905-649MAIN 18 60.59-1,090.551378,241.37 June 27, 2025: 18 @ 60.59
Sept. 5, 2025receiptPO-000817MAIN 130 60.137,817.261559,331.91
Sept. 1, 2025issueSO-250901-944MAIN 17 60.59-1,029.96251,514.65 June 27, 2025: 17 @ 60.59
Aug. 24, 2025issueSO-250824-616MAIN 13 60.59-787.62422,544.61 June 27, 2025: 13 @ 60.59
Aug. 11, 2025issueSO-250811-740MAIN 17 60.59-1,029.96553,332.22 June 27, 2025: 17 @ 60.59
Aug. 6, 2025issueSO-250806-994MAIN 3 60.59-181.76724,362.18 June 27, 2025: 3 @ 60.59
Aug. 3, 2025issueSO-250803-945MAIN 16 60.59-969.37754,543.94 June 27, 2025: 16 @ 60.59
Aug. 1, 2025issueSO-250801-181MAIN 5 60.59-302.93915,513.32 June 27, 2025: 5 @ 60.59
July 31, 2025issueSO-250731-584MAIN 8 60.59-484.69965,816.25 June 27, 2025: 8 @ 60.59
July 27, 2025issueSO-250727-916MAIN 9 60.59-545.271046,300.93 June 27, 2025: 9 @ 60.59
July 25, 2025issueSO-250725-224MAIN 5 60.59-302.931136,846.21 June 27, 2025: 5 @ 60.59
July 22, 2025issueSO-250722-827MAIN 1 60.59-60.591187,149.14 June 27, 2025: 1 @ 60.59
July 18, 2025issueSO-250718-546MAIN 3 60.59-181.761197,209.72 June 27, 2025: 3 @ 60.59
July 10, 2025issueSO-250710-540MAIN 21 59.43-1,248.021227,391.48 June 23, 2025: 13 @ 58.72; June 27, 2025: 8 @ 60.59
July 7, 2025issueSO-250707-214MAIN 2 58.72-117.441438,639.50 June 23, 2025: 2 @ 58.72
June 27, 2025receiptPO-000669MAIN 130 60.597,876.171458,756.93
June 23, 2025returnRMAMAIN 15 58.72880.7715880.77
June 11, 2025issueSO-250611-263MAIN 34 58.72-1,996.4000.00 May 1, 2025: 34 @ 58.72
June 8, 2025issueSO-250608-526MAIN 30 58.72-1,761.53341,996.40 May 1, 2025: 30 @ 58.72
May 21, 2025issueSO-250521-270MAIN 24 58.72-1,409.22643,757.93 May 1, 2025: 24 @ 58.72
May 20, 2025issueSO-250520-148MAIN 24 58.72-1,409.22885,167.16 May 1, 2025: 24 @ 58.72
May 11, 2025issueSO-250511-309MAIN 1 58.72-58.721126,576.38 May 1, 2025: 1 @ 58.72
May 9, 2025issueSO-250509-762MAIN 4 58.72-234.871136,635.10 May 1, 2025: 4 @ 58.72
May 2, 2025issueSO-250502-250MAIN 1 58.72-58.721176,869.97 May 1, 2025: 1 @ 58.72
May 1, 2025issueSO-250501-796MAIN 12 58.72-704.611186,928.69 May 1, 2025: 12 @ 58.72
May 1, 2025receiptPO-000496MAIN 130 58.727,633.301307,633.30
April 17, 2025issueSO-250417-305MAIN 20 60.11-1,202.2800.00 Feb. 22, 2025: 16 @ 60.11; March 9, 2025: 4 @ 60.11
April 13, 2025issueSO-250413-680MAIN 27 60.11-1,623.08201,202.28 Feb. 22, 2025: 27 @ 60.11
April 8, 2025issueSO-250408-213MAIN 6 60.11-360.68472,825.36 Feb. 22, 2025: 6 @ 60.11
March 29, 2025issueSO-250329-816MAIN 3 60.11-180.34533,186.04 Feb. 22, 2025: 3 @ 60.11
March 22, 2025issueSO-250322-836MAIN 12 60.11-721.37563,366.38 Feb. 22, 2025: 12 @ 60.11
March 9, 2025returnRMAMAIN 4 60.11240.46684,087.75
March 3, 2025issueSO-250303-224MAIN 9 60.11-541.03643,847.30 Feb. 22, 2025: 9 @ 60.11
March 3, 2025issueSO-250303-224EAST 28 60.11-1,683.19734,388.32 Feb. 22, 2025: 28 @ 60.11
Feb. 27, 2025issueSO-250227-550MAIN 12 60.11-721.371016,071.51 Feb. 22, 2025: 12 @ 60.11
Feb. 26, 2025issueSO-250226-100MAIN 9 60.11-541.031136,792.88 Feb. 22, 2025: 9 @ 60.11
Feb. 22, 2025issueSO-250222-357EAST 8 60.11-480.911227,333.91 Feb. 22, 2025: 8 @ 60.11
Feb. 22, 2025transferTRFMAIN → EAST 36 warehouse transfer, no cost effect
Feb. 22, 2025receiptPO-000292MAIN 130 60.117,814.821307,814.82
Feb. 5, 2025issueSO-250205-992MAIN 58 59.61-3,457.3100.00 Jan. 3, 2025: 58 @ 59.61
Jan. 28, 2025issueSO-250128-853MAIN 12 59.61-715.31583,457.31 Jan. 3, 2025: 12 @ 59.61
Jan. 8, 2025issueSO-250108-695MAIN 67 59.39-3,978.91704,172.62 Nov. 22, 2024: 7 @ 57.48; Jan. 3, 2025: 60 @ 59.61
Jan. 3, 2025receiptPO-000157MAIN 130 59.617,749.141378,151.52
Dec. 26, 2024issueSO-241226-424MAIN 1 57.48-57.487402.38 Nov. 22, 2024: 1 @ 57.48
Dec. 22, 2024issueSO-241222-617MAIN 82 57.48-4,713.618459.86 Nov. 22, 2024: 82 @ 57.48
Dec. 17, 2024issueSO-241217-173MAIN 2 57.48-114.97905,173.47 Nov. 22, 2024: 2 @ 57.48
Dec. 4, 2024issueSO-241204-518MAIN 3 57.48-172.45925,288.44 Nov. 22, 2024: 3 @ 57.48
Dec. 3, 2024issueSO-241203-781MAIN 16 57.48-919.73955,460.88 Nov. 22, 2024: 16 @ 57.48
Nov. 28, 2024issueSO-241128-941MAIN 3 57.48-172.451116,380.61 Nov. 22, 2024: 3 @ 57.48
Nov. 27, 2024issueSO-241127-744MAIN 40 59.03-2,361.371146,553.06 Oct. 1, 2024: 24 @ 60.07; Nov. 22, 2024: 16 @ 57.48
Nov. 22, 2024receiptPO-000050MAIN 130 57.487,472.791548,914.43
Nov. 21, 2024issueSO-241121-761MAIN 16 60.07-961.10241,441.64 Oct. 1, 2024: 16 @ 60.07
Nov. 18, 2024issueSO-241118-538MAIN 3 60.07-180.21402,402.74 Oct. 1, 2024: 3 @ 60.07
Nov. 5, 2024issueSO-241105-738MAIN 7 60.07-420.48432,582.95 Oct. 1, 2024: 7 @ 60.07
Nov. 4, 2024issueSO-241104-716MAIN 6 60.07-360.41503,003.42 Oct. 1, 2024: 6 @ 60.07
Oct. 29, 2024issueSO-241029-938MAIN 33 60.07-1,982.26563,363.84 Oct. 1, 2024: 33 @ 60.07
Oct. 24, 2024issueSO-241024-219MAIN 27 60.07-1,621.85895,346.10 Oct. 1, 2024: 27 @ 60.07
Oct. 21, 2024issueSO-241021-496MAIN 5 60.07-300.341166,967.95 Oct. 1, 2024: 5 @ 60.07
Oct. 16, 2024issueSO-241016-572MAIN 9 60.07-540.621217,268.29 Oct. 1, 2024: 9 @ 60.07
Oct. 1, 2024receiptPO-000002MAIN 130 60.077,808.901307,808.90