stocksense

Items / CAB-0004

FR Wire 2.5 sqmm Prime CAB-0004 · Cables & Wires · Conduit & Cable Co

On hand (COIL)130MAIN 95, EAST 35
Value (FIFO)12,377.16avg 95.21
ClassAX / FCV 0.29
Turnover7.6xlast issue 9 days ago
Days of cover70lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00040.023.146.269.392.4Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 83.0Nov 24: 47.0Dec 24: 64.0Jan 25: 80.0Feb 25: 43.0Mar 25: 60.0Apr 25: 31.0May 25: 58.0Jun 25: 48.0Jul 25: 64.0Aug 25: 65.0Sep 25: 53.0Oct 25: 84.0Nov 25: 35.0Dec 25: 51.0Jan 26: 38.0Feb 26: 83.0Mar 26: 53.0Apr 26: 68.0May 26: 61.0Jun 26: 42.0Jul 26: 44.0Aug 26: 74.0Sep 26: 43.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.437556.33 / 30.43751.851
Daily demand sdmonthly sd / sqrt(30.4375)16.61 / 5.5173.012
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 * 3.012^2 + 1.851^2 * 3.1^2)26.0
Reorder pointd * LT + safety stock1.851 * 14.0 + 26.052.0
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days52.0
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 676/yr, S = 45.00, h = 20%, price = 94.3356.8
Inventory positionon hand + on order130 + 0130

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

From qtyUnit costOrder qtyAnnual costFeasible
094.335764,794yes (chosen if cheapest)

MOQ 130, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 13, 2026130 / 13095.2112,377.16

Movement ledger 119 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 13, 2026transferTRFMAIN → EAST 35 warehouse transfer, no cost effect
Oct. 13, 2026receiptPO-001875MAIN 130 95.2112,377.1613012,377.16
Oct. 7, 2026issueSO-261007-125MAIN 16 93.74-1,499.8400.00 Aug. 23, 2026: 16 @ 93.74
Oct. 3, 2026issueSO-261003-308MAIN 27 93.74-2,530.98161,499.84 Aug. 23, 2026: 27 @ 93.74
Oct. 2, 2026issueSO-261002-206MAIN 14 93.74-1,312.36434,030.82 Aug. 23, 2026: 14 @ 93.74
Sept. 29, 2026adjustmentCycle countMAIN -1 93.74-93.74575,343.19 Aug. 23, 2026: 1 @ 93.74
Sept. 24, 2026issueSO-260924-167MAIN 17 93.74-1,593.58585,436.93 Aug. 23, 2026: 17 @ 93.74
Sept. 19, 2026issueSO-260919-877MAIN 1 93.74-93.74757,030.51 Aug. 23, 2026: 1 @ 93.74
Sept. 13, 2026issueSO-260913-355MAIN 4 93.74-374.96767,124.25 Aug. 23, 2026: 4 @ 93.74
Sept. 6, 2026issueSO-260906-661MAIN 21 93.74-1,968.54807,499.21 Aug. 23, 2026: 21 @ 93.74
Aug. 30, 2026issueSO-260830-698MAIN 18 93.74-1,687.321019,467.75 Aug. 23, 2026: 18 @ 93.74
Aug. 25, 2026issueSO-260825-880MAIN 12 93.75-1,125.0311911,155.07 July 27, 2026: 1 @ 93.89; Aug. 23, 2026: 11 @ 93.74
Aug. 23, 2026issueSO-260823-129MAIN 6 93.89-563.3613112,280.11 July 17, 2026: 6 @ 93.89
Aug. 23, 2026receiptPO-001738MAIN 130 93.7412,186.2113712,843.46
Aug. 21, 2026issueSO-260821-501MAIN 15 93.89-1,408.397657.25 May 26, 2026: 13 @ 93.89; July 17, 2026: 2 @ 93.89
Aug. 4, 2026issueSO-260804-208MAIN 23 93.89-2,159.54222,065.64 May 26, 2026: 23 @ 93.89
July 31, 2026issueSO-260731-522MAIN 19 93.89-1,783.97454,225.18 May 26, 2026: 19 @ 93.89
July 27, 2026returnRMAMAIN 1 93.8993.89646,009.15
July 19, 2026issueSO-260719-886MAIN 17 93.89-1,596.18635,915.25 May 26, 2026: 17 @ 93.89
July 17, 2026returnRMAMAIN 8 93.89751.14807,511.43
July 14, 2026issueSO-260714-403MAIN 1 93.89-93.89726,760.29 May 26, 2026: 1 @ 93.89
July 4, 2026issueSO-260704-238MAIN 16 93.89-1,502.29736,854.18 May 26, 2026: 16 @ 93.89
June 20, 2026issueSO-260620-296MAIN 14 93.89-1,314.50898,356.47 May 26, 2026: 14 @ 93.89
June 20, 2026issueSO-260620-296EAST 4 93.89-375.571039,670.97 May 26, 2026: 4 @ 93.89
June 2, 2026issueSO-260602-430MAIN 24 93.88-2,253.0110710,046.54 April 3, 2026: 1 @ 93.47; May 26, 2026: 23 @ 93.89
May 28, 2026issueSO-260528-644MAIN 3 93.47-280.4213112,299.55 April 3, 2026: 3 @ 93.47
May 26, 2026receiptPO-001522MAIN 130 93.8912,206.0813412,579.97
May 24, 2026issueSO-260524-955EAST 6 93.47-560.844373.89 April 3, 2026: 6 @ 93.47
May 21, 2026issueSO-260521-552EAST 7 93.47-654.3110934.74 April 3, 2026: 7 @ 93.47
May 19, 2026issueSO-260519-257EAST 11 93.47-1,028.21171,589.05 April 3, 2026: 11 @ 93.47
May 19, 2026issueSO-260519-257MAIN 15 93.47-1,402.10282,617.26 April 3, 2026: 15 @ 93.47
May 11, 2026issueSO-260511-835MAIN 8 93.47-747.79434,019.36 April 3, 2026: 8 @ 93.47
May 4, 2026issueSO-260504-461EAST 6 93.47-560.84514,767.15 April 3, 2026: 6 @ 93.47
May 1, 2026issueSO-260501-546MAIN 5 93.47-467.37575,327.99 April 3, 2026: 5 @ 93.47
April 29, 2026issueSO-260429-143MAIN 8 93.47-747.79625,795.36 April 3, 2026: 8 @ 93.47
April 26, 2026issueSO-260426-722MAIN 35 93.47-3,271.57706,543.14 April 3, 2026: 35 @ 93.47
April 18, 2026issueSO-260418-126MAIN 11 93.47-1,028.211059,814.72 April 3, 2026: 11 @ 93.47
April 8, 2026issueSO-260408-459MAIN 14 93.47-1,308.6311610,842.93 April 3, 2026: 14 @ 93.47
April 3, 2026transferTRFMAIN → EAST 34 warehouse transfer, no cost effect
April 3, 2026receiptPO-001379MAIN 130 93.4712,151.5613012,151.56
March 29, 2026issueSO-260329-158MAIN 24 91.47-2,195.3500.00 Feb. 5, 2026: 24 @ 91.47
March 28, 2026issueSO-260328-168MAIN 11 91.47-1,006.20242,195.35 Feb. 5, 2026: 11 @ 91.47
March 25, 2026issueSO-260325-749MAIN 14 91.47-1,280.62353,201.56 Feb. 5, 2026: 14 @ 91.47
March 2, 2026issueSO-260302-192MAIN 4 91.47-365.89494,482.18 Feb. 5, 2026: 4 @ 91.47
Feb. 28, 2026issueSO-260228-741MAIN 56 91.47-5,122.49534,848.07 Feb. 5, 2026: 56 @ 91.47
Feb. 27, 2026issueSO-260227-476MAIN 6 91.47-548.841099,970.57 Feb. 5, 2026: 6 @ 91.47
Feb. 19, 2026issueSO-260219-644MAIN 15 91.47-1,372.1011510,519.41 Feb. 5, 2026: 15 @ 91.47
Feb. 5, 2026receiptPO-001197MAIN 130 91.4711,891.5013011,891.50
Feb. 4, 2026issueSO-260204-912EAST 3 90.45-271.3400.00 Jan. 8, 2026: 3 @ 90.45
Feb. 4, 2026issueSO-260204-912MAIN 3 90.45-271.343271.34 Nov. 11, 2025: 3 @ 90.45
Jan. 30, 2026issueSO-260130-588MAIN 1 90.45-90.456542.69 Nov. 11, 2025: 1 @ 90.45
Jan. 28, 2026issueSO-260128-419MAIN 33 90.45-2,984.797633.14 Nov. 11, 2025: 33 @ 90.45
Jan. 22, 2026issueSO-260122-277EAST 7 90.45-633.14403,617.93 Nov. 11, 2025: 7 @ 90.45
Jan. 8, 2026returnRMAMAIN 3 90.45271.34474,251.07
Dec. 28, 2025issueSO-251228-476MAIN 12 90.45-1,085.38443,979.72 Nov. 11, 2025: 12 @ 90.45
Dec. 22, 2025issueSO-251222-982MAIN 7 90.45-633.14565,065.10 Nov. 11, 2025: 7 @ 90.45
Dec. 17, 2025issueSO-251217-166EAST 27 90.45-2,442.10635,698.24 Nov. 11, 2025: 27 @ 90.45
Dec. 8, 2025issueSO-251208-394MAIN 5 90.45-452.24908,140.34 Nov. 11, 2025: 5 @ 90.45
Nov. 29, 2025issueSO-251129-224MAIN 1 90.45-90.45958,592.58 Nov. 11, 2025: 1 @ 90.45
Nov. 17, 2025issueSO-251117-876EAST 7 90.45-633.14968,683.03 Nov. 11, 2025: 7 @ 90.45
Nov. 14, 2025issueSO-251114-614MAIN 27 90.45-2,442.101039,316.16 Nov. 11, 2025: 27 @ 90.45
Nov. 11, 2025transferTRFMAIN → EAST 44 warehouse transfer, no cost effect
Nov. 11, 2025receiptPO-000992MAIN 130 90.4511,758.2713011,758.27
Oct. 31, 2025issueSO-251031-690MAIN 49 91.52-4,484.7100.00 Sept. 10, 2025: 49 @ 91.52
Oct. 29, 2025issueSO-251029-161MAIN 5 91.52-457.62494,484.71 Sept. 10, 2025: 5 @ 91.52
Oct. 10, 2025issueSO-251010-782MAIN 3 91.52-274.57544,942.33 Sept. 10, 2025: 3 @ 91.52
Oct. 8, 2025issueSO-251008-837MAIN 27 91.52-2,471.16575,216.90 Sept. 10, 2025: 27 @ 91.52
Sept. 27, 2025issueSO-250927-208MAIN 20 91.52-1,830.49847,688.07 Sept. 10, 2025: 20 @ 91.52
Sept. 13, 2025issueSO-250913-834MAIN 20 91.52-1,830.491049,518.56 Sept. 10, 2025: 20 @ 91.52
Sept. 12, 2025issueSO-250912-820MAIN 5 91.52-457.6212411,349.05 Sept. 10, 2025: 5 @ 91.52
Sept. 11, 2025issueSO-250911-538MAIN 1 91.52-91.5212911,806.67 Sept. 10, 2025: 1 @ 91.52
Sept. 10, 2025receiptPO-000826MAIN 130 91.5211,898.2013011,898.20
Sept. 6, 2025issueSO-250906-740MAIN 7 88.38-618.6400.00 June 18, 2025: 7 @ 88.38
Aug. 31, 2025issueSO-250831-317MAIN 25 88.38-2,209.427618.64 June 18, 2025: 25 @ 88.38
Aug. 27, 2025issueSO-250827-117MAIN 21 88.38-1,855.91322,828.05 June 18, 2025: 21 @ 88.38
Aug. 26, 2025issueSO-250826-203MAIN 7 88.38-618.64534,683.96 June 18, 2025: 7 @ 88.38
Aug. 13, 2025issueSO-250813-739MAIN 12 88.38-1,060.52605,302.60 June 18, 2025: 12 @ 88.38
July 31, 2025issueSO-250731-379MAIN 8 88.38-707.01726,363.12 June 18, 2025: 8 @ 88.38
July 29, 2025issueSO-250729-136MAIN 38 88.38-3,358.31807,070.13 June 18, 2025: 38 @ 88.38
July 26, 2025issueSO-250726-485MAIN 5 88.38-441.8811810,428.44 June 18, 2025: 5 @ 88.38
July 25, 2025issueSO-250725-387MAIN 2 88.38-176.7512310,870.32 June 18, 2025: 2 @ 88.38
July 18, 2025issueSO-250718-521MAIN 10 87.91-879.0812511,047.08 March 20, 2025: 5 @ 87.44; June 18, 2025: 5 @ 88.38
July 6, 2025issueSO-250706-143MAIN 1 87.44-87.4413511,926.15 March 20, 2025: 1 @ 87.44
June 18, 2025issueSO-250618-352MAIN 4 87.44-349.7513612,013.59 March 20, 2025: 4 @ 87.44
June 18, 2025receiptPO-000646MAIN 130 88.3811,488.9614012,363.34
June 15, 2025issueSO-250615-241MAIN 10 87.44-874.3810874.38 March 20, 2025: 10 @ 87.44
June 9, 2025issueSO-250609-727MAIN 1 87.44-87.44201,748.77 March 20, 2025: 1 @ 87.44
June 7, 2025issueSO-250607-104MAIN 1 87.44-87.44211,836.21 March 20, 2025: 1 @ 87.44
June 6, 2025issueSO-250606-578MAIN 17 87.44-1,486.45221,923.64 March 20, 2025: 17 @ 87.44
June 4, 2025issueSO-250604-466MAIN 15 87.44-1,311.58393,410.10 March 20, 2025: 15 @ 87.44
May 30, 2025issueSO-250530-894MAIN 5 87.44-437.19544,721.67 March 20, 2025: 5 @ 87.44
May 12, 2025issueSO-250512-532MAIN 32 87.44-2,798.03595,158.87 March 20, 2025: 32 @ 87.44
May 10, 2025issueSO-250510-576MAIN 21 87.44-1,836.21917,956.89 March 20, 2025: 21 @ 87.44
April 24, 2025issueSO-250424-591MAIN 18 87.44-1,573.891129,793.10 March 20, 2025: 18 @ 87.44
April 9, 2025issueSO-250409-160MAIN 2 88.45-176.9013011,366.99 Jan. 26, 2025: 2 @ 88.45
April 3, 2025issueSO-250403-694MAIN 11 88.45-972.9613211,543.89 Jan. 26, 2025: 11 @ 88.45
March 20, 2025receiptPO-000356MAIN 130 87.4411,366.9914312,516.85
March 12, 2025issueSO-250312-608MAIN 10 88.45-884.51131,149.86 Jan. 26, 2025: 10 @ 88.45
March 6, 2025issueSO-250306-884MAIN 50 88.45-4,422.54232,034.37 Jan. 26, 2025: 50 @ 88.45
Feb. 27, 2025issueSO-250227-581MAIN 10 88.45-884.51736,456.92 Jan. 26, 2025: 10 @ 88.45
Feb. 14, 2025issueSO-250214-600MAIN 12 88.45-1,061.41837,341.42 Jan. 26, 2025: 12 @ 88.45
Feb. 7, 2025issueSO-250207-711MAIN 2 88.45-176.90958,402.84 Jan. 26, 2025: 2 @ 88.45
Feb. 5, 2025issueSO-250205-383MAIN 19 88.45-1,680.57978,579.74 Jan. 26, 2025: 19 @ 88.45
Jan. 31, 2025issueSO-250131-715MAIN 14 88.45-1,238.3111610,260.30 Jan. 26, 2025: 14 @ 88.45
Jan. 26, 2025receiptPO-000218MAIN 130 88.4511,498.6213011,498.62
Jan. 19, 2025issueSO-250119-843MAIN 1 85.34-85.3400.00 Dec. 1, 2024: 1 @ 85.34
Jan. 17, 2025issueSO-250117-720MAIN 14 85.34-1,194.79185.34 Dec. 1, 2024: 14 @ 85.34
Jan. 11, 2025issueSO-250111-953MAIN 4 85.34-341.37151,280.13 Dec. 1, 2024: 4 @ 85.34
Jan. 9, 2025issueSO-250109-778MAIN 30 85.34-2,560.26191,621.50 Dec. 1, 2024: 30 @ 85.34
Jan. 6, 2025issueSO-250106-267MAIN 17 85.34-1,450.81494,181.75 Dec. 1, 2024: 17 @ 85.34
Dec. 30, 2024issueSO-241230-519MAIN 24 85.34-2,048.21665,632.57 Dec. 1, 2024: 24 @ 85.34
Dec. 14, 2024issueSO-241214-928MAIN 22 85.34-1,877.52907,680.77 Dec. 1, 2024: 22 @ 85.34
Dec. 9, 2024issueSO-241209-400MAIN 16 85.34-1,365.471129,558.29 Dec. 1, 2024: 16 @ 85.34
Dec. 5, 2024issueSO-241205-559MAIN 2 85.34-170.6812810,923.76 Dec. 1, 2024: 2 @ 85.34
Dec. 1, 2024receiptPO-000070MAIN 130 85.3411,094.4513011,094.45
Nov. 12, 2024issueSO-241112-703MAIN 47 89.61-4,211.8300.00 Oct. 1, 2024: 47 @ 89.61
Oct. 30, 2024issueSO-241030-452MAIN 26 89.61-2,329.95474,211.83 Oct. 1, 2024: 26 @ 89.61
Oct. 19, 2024issueSO-241019-798MAIN 57 89.61-5,107.97736,541.79 Oct. 1, 2024: 57 @ 89.61
Oct. 1, 2024receiptPO-000002MAIN 130 89.6111,649.7613011,649.76