stocksense

Items / CAB-0039

FR Wire 1.5 sqmm Lite CAB-0039 · Cables & Wires · Conduit & Cable Co

On hand (COIL)43MAIN 18, EAST 25
Value (FIFO)12,166.02avg 282.93
ClassAX / FCV 0.22
Turnover12.2xlast issue 0 days ago
Days of cover29lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00390.019.038.056.975.9Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 64.0Nov 24: 46.0Dec 24: 42.0Jan 25: 42.0Feb 25: 57.0Mar 25: 69.0Apr 25: 51.0May 25: 53.0Jun 25: 44.0Jul 25: 40.0Aug 25: 46.0Sep 25: 28.0Oct 25: 37.0Nov 25: 41.0Dec 25: 45.0Jan 26: 44.0Feb 26: 42.0Mar 26: 49.0Apr 26: 38.0May 26: 67.0Jun 26: 35.0Jul 26: 48.0Aug 26: 65.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.437545.50 / 30.43751.495
Daily demand sdmonthly sd / sqrt(30.4375)10.19 / 5.5171.846
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.846^2 + 1.495^2 * 3.1^2)17.1
Reorder pointd * LT + safety stock1.495 * 14.0 + 17.138.1
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days38.1
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 546/yr, S = 45.00, h = 20%, price = 256.17440.0
Inventory positionon hand + on order43 + 043

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

From qtyUnit costOrder qtyAnnual costFeasible
0278.4530153,583yes
220267.31220151,845yes
440256.17440151,103yes (chosen if cheapest)

MOQ 110, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 25, 202643 / 110282.9312,166.02

Movement ledger 122 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-381MAIN 6 282.93-1,697.584312,166.02 Aug. 25, 2026: 6 @ 282.93
Oct. 13, 2026issueSO-261013-546MAIN 8 282.93-2,263.444913,863.60 Aug. 25, 2026: 8 @ 282.93
Oct. 9, 2026issueSO-261009-381MAIN 3 282.93-848.795716,127.04 Aug. 25, 2026: 3 @ 282.93
Oct. 8, 2026issueSO-261008-667MAIN 3 282.93-848.796016,975.84 Aug. 25, 2026: 3 @ 282.93
Oct. 5, 2026issueSO-261005-274MAIN 17 282.93-4,809.826317,824.63 Aug. 25, 2026: 17 @ 282.93
Oct. 1, 2026issueSO-261001-503MAIN 2 282.93-565.868022,634.45 Aug. 25, 2026: 2 @ 282.93
Sept. 27, 2026issueSO-260927-298MAIN 25 282.93-7,073.268223,200.31 Aug. 25, 2026: 25 @ 282.93
Sept. 23, 2026issueSO-260923-331MAIN 8 275.32-2,202.5610730,273.57 Aug. 23, 2026: 5 @ 270.75; Aug. 25, 2026: 3 @ 282.93
Sept. 12, 2026issueSO-260912-186MAIN 2 270.75-541.5111532,476.13 Aug. 23, 2026: 2 @ 270.75
Aug. 26, 2026issueSO-260826-869MAIN 6 270.75-1,624.5211733,017.64 Aug. 23, 2026: 6 @ 270.75
Aug. 25, 2026issueSO-260825-767MAIN 2 270.75-541.5112334,642.16 June 28, 2026: 2 @ 270.75
Aug. 25, 2026transferTRFMAIN → EAST 23 warehouse transfer, no cost effect
Aug. 25, 2026receiptPO-001745MAIN 110 282.9331,122.3712535,183.67
Aug. 23, 2026returnRMAMAIN 13 270.753,519.79154,061.30
Aug. 18, 2026issueSO-260818-645EAST 26 270.75-7,039.592541.51 June 28, 2026: 26 @ 270.75
Aug. 18, 2026issueSO-260818-645MAIN 1 270.75-270.75287,581.09 June 28, 2026: 1 @ 270.75
Aug. 16, 2026issueSO-260816-722MAIN 20 270.75-5,415.07297,851.85 June 28, 2026: 20 @ 270.75
Aug. 15, 2026issueSO-260815-828MAIN 22 270.75-5,956.574913,266.91 June 28, 2026: 22 @ 270.75
Aug. 9, 2026issueSO-260809-546MAIN 1 270.75-270.757119,223.48 June 28, 2026: 1 @ 270.75
July 27, 2026issueSO-260727-941MAIN 16 270.75-4,332.057219,494.24 June 28, 2026: 16 @ 270.75
July 24, 2026issueSO-260724-483MAIN 1 270.75-270.758823,826.29 June 28, 2026: 1 @ 270.75
July 21, 2026issueSO-260721-740MAIN 2 270.75-541.518924,097.04 June 28, 2026: 2 @ 270.75
July 18, 2026issueSO-260718-867EAST 6 270.75-1,624.529124,638.55 June 28, 2026: 6 @ 270.75
July 16, 2026issueSO-260716-404MAIN 9 270.75-2,436.789726,263.07 June 28, 2026: 9 @ 270.75
July 4, 2026issueSO-260704-153MAIN 4 270.75-1,083.0110628,699.85 June 28, 2026: 4 @ 270.75
July 1, 2026issueSO-260701-150MAIN 10 267.91-2,679.1011029,782.86 April 17, 2026: 7 @ 267.91; April 23, 2026: 2 @ 267.91; April 29, 2026: 1 @ 267.91
June 28, 2026transferTRFMAIN → EAST 34 warehouse transfer, no cost effect
June 28, 2026receiptPO-001607MAIN 110 270.7529,782.8612032,461.96
June 19, 2026issueSO-260619-572MAIN 18 267.91-4,822.38102,679.10 April 17, 2026: 18 @ 267.91
June 12, 2026issueSO-260612-292MAIN 5 267.91-1,339.55287,501.48 April 17, 2026: 5 @ 267.91
June 11, 2026issueSO-260611-782MAIN 5 267.91-1,339.55338,841.03 April 17, 2026: 5 @ 267.91
June 9, 2026issueSO-260609-193MAIN 6 267.91-1,607.463810,180.58 April 17, 2026: 6 @ 267.91
June 4, 2026issueSO-260604-164MAIN 1 267.91-267.914411,788.04 April 17, 2026: 1 @ 267.91
May 24, 2026issueSO-260524-132MAIN 13 267.91-3,482.834512,055.95 April 17, 2026: 13 @ 267.91
May 13, 2026issueSO-260513-800MAIN 4 267.91-1,071.645815,538.77 April 17, 2026: 4 @ 267.91
May 4, 2026issueSO-260504-654MAIN 5 267.91-1,339.556216,610.41 April 17, 2026: 5 @ 267.91
May 3, 2026issueSO-260503-981MAIN 13 267.91-3,482.836717,949.96 April 17, 2026: 13 @ 267.91
May 2, 2026issueSO-260502-939MAIN 15 267.91-4,018.658021,432.79 April 17, 2026: 15 @ 267.91
May 1, 2026issueSO-260501-593MAIN 17 267.91-4,554.479525,451.44 April 17, 2026: 17 @ 267.91
April 29, 2026returnRMAMAIN 1 267.91267.9111230,005.91
April 23, 2026returnRMAMAIN 2 267.91535.8211129,738.00
April 23, 2026issueSO-260423-190MAIN 1 267.91-267.9110929,202.18 April 17, 2026: 1 @ 267.91
April 23, 2026issueSO-260423-190EAST 2 271.04-542.0811029,470.09 Feb. 13, 2026: 2 @ 271.04
April 17, 2026receiptPO-001415MAIN 110 267.9129,470.0911230,012.17
April 15, 2026issueSO-260415-764EAST 1 271.04-271.042542.08 Feb. 13, 2026: 1 @ 271.04
April 12, 2026issueSO-260412-983EAST 4 271.04-1,084.173813.13 Feb. 13, 2026: 4 @ 271.04
April 9, 2026issueSO-260409-830EAST 22 271.04-5,962.9271,897.29 Feb. 13, 2026: 22 @ 271.04
April 9, 2026issueSO-260409-830MAIN 5 271.04-1,355.21297,860.21 Feb. 13, 2026: 5 @ 271.04
April 4, 2026issueSO-260404-447MAIN 6 271.04-1,626.25349,215.42 Feb. 13, 2026: 6 @ 271.04
March 28, 2026issueSO-260328-111MAIN 1 271.04-271.044010,841.67 Feb. 13, 2026: 1 @ 271.04
March 14, 2026issueSO-260314-439MAIN 44 271.04-11,925.844111,112.71 Feb. 13, 2026: 44 @ 271.04
March 8, 2026issueSO-260308-333MAIN 4 271.04-1,084.178523,038.55 Feb. 13, 2026: 4 @ 271.04
Feb. 27, 2026issueSO-260227-723MAIN 24 270.23-6,485.438924,122.72 Nov. 24, 2025: 3 @ 264.52; Feb. 13, 2026: 21 @ 271.04
Feb. 24, 2026issueSO-260224-129MAIN 4 264.52-1,058.0811330,608.15 Nov. 24, 2025: 4 @ 264.52
Feb. 13, 2026transferTRFMAIN → EAST 29 warehouse transfer, no cost effect
Feb. 13, 2026receiptPO-001224MAIN 110 271.0429,814.6011731,666.23
Feb. 10, 2026issueSO-260210-347MAIN 11 264.52-2,909.7171,851.63 Nov. 24, 2025: 11 @ 264.52
Feb. 4, 2026issueSO-260204-383MAIN 3 264.52-793.56184,761.34 Nov. 24, 2025: 3 @ 264.52
Jan. 26, 2026issueSO-260126-935MAIN 21 264.52-5,554.90215,554.90 Nov. 24, 2025: 21 @ 264.52
Jan. 23, 2026issueSO-260123-824MAIN 11 264.52-2,909.714211,109.79 Nov. 24, 2025: 11 @ 264.52
Jan. 22, 2026issueSO-260122-642MAIN 1 264.52-264.525314,019.50 Nov. 24, 2025: 1 @ 264.52
Jan. 16, 2026issueSO-260116-932MAIN 11 264.52-2,909.715414,284.02 Nov. 24, 2025: 11 @ 264.52
Dec. 19, 2025issueSO-251219-826MAIN 4 264.52-1,058.086517,193.73 Nov. 24, 2025: 4 @ 264.52
Dec. 7, 2025issueSO-251207-816MAIN 41 264.52-10,845.276918,251.80 Nov. 24, 2025: 41 @ 264.52
Nov. 24, 2025receiptPO-001017MAIN 110 264.5229,097.0811029,097.08
Nov. 12, 2025issueSO-251112-336MAIN 8 272.80-2,182.3800.00 Oct. 19, 2025: 8 @ 272.80
Nov. 7, 2025issueSO-251107-482MAIN 33 272.80-9,002.3182,182.38 Aug. 22, 2025: 27 @ 272.80; Sept. 26, 2025: 4 @ 272.80; Oct. 19, 2025: 2 @ 272.80
Oct. 31, 2025issueSO-251031-305MAIN 4 272.80-1,091.194111,184.69 Aug. 22, 2025: 4 @ 272.80
Oct. 24, 2025issueSO-251024-167MAIN 13 272.80-3,546.374512,275.88 Aug. 22, 2025: 13 @ 272.80
Oct. 19, 2025returnRMAMAIN 10 272.802,727.975815,822.25
Oct. 19, 2025issueSO-251019-469MAIN 2 272.80-545.594813,094.28 Aug. 22, 2025: 2 @ 272.80
Oct. 13, 2025issueSO-251013-551MAIN 5 272.80-1,363.995013,639.87 Aug. 22, 2025: 5 @ 272.80
Oct. 11, 2025issueSO-251011-711MAIN 1 272.80-272.805515,003.86 Aug. 22, 2025: 1 @ 272.80
Oct. 6, 2025issueSO-251006-677MAIN 1 272.80-272.805615,276.65 Aug. 22, 2025: 1 @ 272.80
Oct. 4, 2025issueSO-251004-921MAIN 21 272.80-5,728.755715,549.45 Aug. 22, 2025: 21 @ 272.80
Sept. 29, 2025issueSO-250929-528MAIN 21 272.80-5,728.757821,278.20 Aug. 22, 2025: 21 @ 272.80
Sept. 26, 2025returnRMAMAIN 4 272.801,091.199927,006.94
Sept. 9, 2025issueSO-250909-430MAIN 8 272.80-2,182.389525,915.75 Aug. 22, 2025: 8 @ 272.80
Sept. 1, 2025issueSO-250901-664MAIN 3 272.80-818.3910328,098.13 Aug. 22, 2025: 3 @ 272.80
Aug. 31, 2025issueSO-250831-330MAIN 4 272.80-1,091.1910628,916.52 Aug. 22, 2025: 4 @ 272.80
Aug. 22, 2025receiptPO-000787MAIN 110 272.8030,007.7111030,007.71
Aug. 4, 2025issueSO-250804-126MAIN 42 263.36-11,061.1600.00 June 8, 2025: 42 @ 263.36
July 19, 2025issueSO-250719-524MAIN 10 263.36-2,633.614211,061.16 June 8, 2025: 10 @ 263.36
July 17, 2025issueSO-250717-267MAIN 14 263.36-3,687.055213,694.77 June 8, 2025: 14 @ 263.36
July 16, 2025issueSO-250716-817MAIN 16 263.36-4,213.776617,381.82 June 8, 2025: 16 @ 263.36
June 20, 2025issueSO-250620-554MAIN 7 263.36-1,843.538221,595.59 June 8, 2025: 7 @ 263.36
June 18, 2025issueSO-250618-447MAIN 9 263.36-2,370.258923,439.12 June 8, 2025: 9 @ 263.36
June 17, 2025issueSO-250617-374MAIN 14 263.64-3,690.959825,809.37 March 23, 2025: 2 @ 265.31; June 8, 2025: 12 @ 263.36
June 13, 2025issueSO-250613-743MAIN 2 265.31-530.6211229,500.32 March 23, 2025: 2 @ 265.31
June 12, 2025issueSO-250612-161MAIN 7 265.31-1,857.1811430,030.95 March 23, 2025: 7 @ 265.31
June 8, 2025receiptPO-000615MAIN 110 263.3628,969.7012131,888.13
June 7, 2025issueSO-250607-111MAIN 1 265.31-265.31112,918.43 March 23, 2025: 1 @ 265.31
June 6, 2025issueSO-250606-225MAIN 4 265.31-1,061.25123,183.74 March 23, 2025: 4 @ 265.31
May 28, 2025issueSO-250528-374MAIN 38 265.31-10,081.85164,244.99 March 23, 2025: 38 @ 265.31
May 16, 2025issueSO-250516-906MAIN 15 265.31-3,979.685414,326.84 March 23, 2025: 15 @ 265.31
April 10, 2025issueSO-250410-230MAIN 13 265.31-3,449.056918,306.52 March 23, 2025: 13 @ 265.31
April 8, 2025issueSO-250408-757MAIN 38 264.14-10,037.338221,755.58 Feb. 2, 2025: 10 @ 260.86; March 23, 2025: 28 @ 265.31
March 23, 2025receiptPO-000368MAIN 110 265.3129,184.3112031,792.90
March 20, 2025issueSO-250320-252MAIN 13 260.86-3,391.17102,608.59 Feb. 2, 2025: 13 @ 260.86
March 13, 2025issueSO-250313-497MAIN 6 260.86-1,565.16235,999.76 Feb. 2, 2025: 6 @ 260.86
March 11, 2025issueSO-250311-765MAIN 24 260.86-6,260.62297,564.92 Feb. 2, 2025: 24 @ 260.86
March 10, 2025issueSO-250310-131MAIN 14 260.86-3,652.035313,825.54 Feb. 2, 2025: 14 @ 260.86
March 3, 2025issueSO-250303-588MAIN 12 260.86-3,130.316717,477.57 Feb. 2, 2025: 12 @ 260.86
Feb. 25, 2025issueSO-250225-878MAIN 8 260.86-2,086.877920,607.88 Feb. 2, 2025: 8 @ 260.86
Feb. 10, 2025issueSO-250210-710MAIN 30 258.45-7,753.628722,694.76 Nov. 25, 2024: 7 @ 250.55; Feb. 2, 2025: 23 @ 260.86
Feb. 10, 2025issueSO-250210-710EAST 19 250.55-4,760.4611730,448.38 Nov. 25, 2024: 19 @ 250.55
Feb. 2, 2025receiptPO-000234MAIN 110 260.8628,694.5213635,208.84
Jan. 20, 2025issueSO-250120-711MAIN 5 250.55-1,252.75266,514.32 Nov. 25, 2024: 5 @ 250.55
Jan. 19, 2025issueSO-250119-656MAIN 11 250.55-2,756.06317,767.07 Nov. 25, 2024: 11 @ 250.55
Jan. 17, 2025issueSO-250117-575MAIN 17 250.55-4,259.364210,523.13 Nov. 25, 2024: 17 @ 250.55
Jan. 9, 2025issueSO-250109-813MAIN 5 250.55-1,252.755914,782.49 Nov. 25, 2024: 5 @ 250.55
Jan. 1, 2025issueSO-250101-915EAST 4 250.55-1,002.206416,035.24 Nov. 25, 2024: 4 @ 250.55
Dec. 29, 2024issueSO-241229-529MAIN 23 250.55-5,762.676817,037.45 Nov. 25, 2024: 23 @ 250.55
Dec. 10, 2024issueSO-241210-414MAIN 12 250.55-3,006.619122,800.11 Nov. 25, 2024: 12 @ 250.55
Dec. 9, 2024issueSO-241209-295MAIN 7 250.55-1,753.8510325,806.72 Nov. 25, 2024: 7 @ 250.55
Nov. 25, 2024transferTRFMAIN → EAST 23 warehouse transfer, no cost effect
Nov. 25, 2024receiptPO-000060MAIN 110 250.5527,560.5811027,560.58
Nov. 20, 2024issueSO-241120-255MAIN 25 264.53-6,613.1900.00 Oct. 1, 2024: 25 @ 264.53
Nov. 12, 2024issueSO-241112-492MAIN 21 264.53-5,555.08256,613.19 Oct. 1, 2024: 21 @ 264.53
Oct. 30, 2024issueSO-241030-131MAIN 29 264.53-7,671.304612,168.26 Oct. 1, 2024: 29 @ 264.53
Oct. 8, 2024issueSO-241008-674MAIN 35 264.53-9,258.467519,839.56 Oct. 1, 2024: 35 @ 264.53
Oct. 1, 2024receiptPO-000002MAIN 110 264.5329,098.0211029,098.02