stocksense

Items / CAB-0011

FR Wire 1.0 sqmm Pro CAB-0011 · Cables & Wires · Conduit & Cable Co

On hand (COIL)178MAIN 118, EAST 60
Value (FIFO)16,751.44avg 94.11
ClassAX / FCV 0.30
Turnover8.8xlast issue 0 days ago
Days of cover63lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00110.039.679.2119158Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 102.0Nov 24: 86.0Dec 24: 123.0Jan 25: 103.0Feb 25: 88.0Mar 25: 87.0Apr 25: 93.0May 25: 76.0Jun 25: 31.0Jul 25: 95.0Aug 25: 61.0Sep 25: 76.0Oct 25: 86.0Nov 25: 78.0Dec 25: 119.0Jan 26: 144.0Feb 26: 76.0Mar 26: 69.0Apr 26: 109.0May 26: 60.0Jun 26: 50.0Jul 26: 86.0Aug 26: 87.0Sep 26: 67.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.437585.92 / 30.43752.823
Daily demand sdmonthly sd / sqrt(30.4375)25.44 / 5.5174.612
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 * 4.612^2 + 2.823^2 * 3.1^2)39.8
Reorder pointd * LT + safety stock2.823 * 14.0 + 39.879.4
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days79.4
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1030/yr, S = 45.00, h = 20%, price = 89.43760.0
Inventory positionon hand + on order178 + 0178

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

From qtyUnit costOrder qtyAnnual costFeasible
097.2169101,498yes
38093.3238099,817yes
76089.4376099,000yes (chosen if cheapest)

MOQ 190, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 10, 2026178 / 19094.1116,751.44

Movement ledger 129 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-307MAIN 11 94.11-1,035.2017816,751.44 Oct. 10, 2026: 11 @ 94.11
Oct. 10, 2026issueSO-261010-282EAST 1 94.11-94.1118917,786.64 Oct. 10, 2026: 1 @ 94.11
Oct. 10, 2026transferTRFMAIN → EAST 61 warehouse transfer, no cost effect
Oct. 10, 2026receiptPO-001864MAIN 190 94.1117,880.7519017,880.75
Oct. 6, 2026issueSO-261006-942MAIN 13 97.20-1,263.5500.00 July 22, 2026: 13 @ 97.20
Oct. 4, 2026issueSO-261004-422MAIN 4 97.20-388.79131,263.55 July 22, 2026: 4 @ 97.20
Oct. 3, 2026issueSO-261003-541MAIN 19 97.20-1,846.73171,652.34 July 22, 2026: 19 @ 97.20
Sept. 28, 2026issueSO-260928-341MAIN 52 97.20-5,054.22363,499.07 July 22, 2026: 52 @ 97.20
Sept. 19, 2026issueSO-260919-252MAIN 6 97.20-583.18888,553.29 July 22, 2026: 6 @ 97.20
Sept. 14, 2026issueSO-260914-121MAIN 9 97.20-874.77949,136.47 July 22, 2026: 9 @ 97.20
Aug. 30, 2026issueSO-260830-419MAIN 58 97.20-5,637.4010310,011.24 July 22, 2026: 58 @ 97.20
Aug. 28, 2026issueSO-260828-400MAIN 6 97.20-583.1816115,648.64 July 22, 2026: 6 @ 97.20
Aug. 15, 2026issueSO-260815-154MAIN 22 97.20-2,138.3216716,231.82 July 22, 2026: 22 @ 97.20
Aug. 5, 2026issueSO-260805-223MAIN 1 97.20-97.2018918,370.14 July 22, 2026: 1 @ 97.20
July 22, 2026receiptPO-001660MAIN 190 97.2018,467.3419018,467.34
July 19, 2026issueSO-260719-223MAIN 5 95.90-479.5200.00 June 29, 2026: 5 @ 95.90
July 18, 2026issueSO-260718-773MAIN 1 95.90-95.905479.52 May 13, 2026: 1 @ 95.90
July 17, 2026issueSO-260717-808MAIN 18 95.90-1,726.286575.43 May 13, 2026: 18 @ 95.90
July 13, 2026issueSO-260713-973MAIN 30 95.90-2,877.13242,301.71 May 13, 2026: 30 @ 95.90
July 4, 2026issueSO-260704-567MAIN 20 95.90-1,918.09545,178.84 May 13, 2026: 20 @ 95.90
July 3, 2026issueSO-260703-692MAIN 12 95.90-1,150.85747,096.93 May 13, 2026: 12 @ 95.90
June 30, 2026issueSO-260630-996MAIN 8 95.90-767.24868,247.78 May 13, 2026: 8 @ 95.90
June 29, 2026returnRMAMAIN 5 95.90479.52949,015.01
June 26, 2026issueSO-260626-916MAIN 11 95.90-1,054.95898,535.49 May 13, 2026: 11 @ 95.90
June 22, 2026issueSO-260622-281MAIN 8 95.90-767.241009,590.44 May 13, 2026: 8 @ 95.90
June 18, 2026issueSO-260618-464MAIN 15 95.90-1,438.5710810,357.68 May 13, 2026: 15 @ 95.90
June 5, 2026issueSO-260605-168MAIN 13 95.90-1,246.7612311,796.24 May 13, 2026: 13 @ 95.90
May 22, 2026issueSO-260522-563MAIN 21 95.90-2,013.9913613,043.00 May 13, 2026: 21 @ 95.90
May 21, 2026issueSO-260521-513MAIN 33 95.90-3,164.8515715,056.99 May 13, 2026: 33 @ 95.90
May 13, 2026receiptPO-001488MAIN 190 95.9018,221.8419018,221.84
May 2, 2026issueSO-260502-649MAIN 6 95.13-570.8000.00 March 29, 2026: 6 @ 95.13
April 30, 2026issueSO-260430-735MAIN 83 95.13-7,895.906570.80 Feb. 14, 2026: 76 @ 95.13; Feb. 24, 2026: 1 @ 94.92; March 29, 2026: 6 @ 95.13
April 3, 2026issueSO-260403-622MAIN 26 95.13-2,473.48898,466.70 Feb. 14, 2026: 26 @ 95.13
March 29, 2026returnRMAMAIN 12 95.131,141.6111510,940.18
March 19, 2026issueSO-260319-940MAIN 25 95.13-2,378.351039,798.57 Feb. 14, 2026: 25 @ 95.13
March 19, 2026issueSO-260319-940EAST 6 95.13-570.8012812,176.92 Feb. 14, 2026: 6 @ 95.13
March 14, 2026issueSO-260314-593EAST 3 95.13-285.4013412,747.73 Feb. 14, 2026: 3 @ 95.13
March 11, 2026issueSO-260311-730MAIN 12 95.13-1,141.6113713,033.13 Feb. 14, 2026: 12 @ 95.13
March 10, 2026issueSO-260310-176MAIN 33 95.13-3,139.4214914,174.73 Feb. 14, 2026: 33 @ 95.13
March 8, 2026issueSO-260308-475MAIN 2 95.13-190.2718217,314.15 Feb. 14, 2026: 2 @ 95.13
Feb. 24, 2026returnRMAMAIN 1 94.9294.9218417,504.42
Feb. 24, 2026issueSO-260224-631MAIN 16 94.92-1,518.6718317,409.50 Dec. 26, 2025: 9 @ 94.75; Feb. 14, 2026: 7 @ 95.13
Feb. 14, 2026receiptPO-001229MAIN 190 95.1318,075.4419918,928.18
Feb. 10, 2026issueSO-260210-445EAST 31 94.75-2,937.209852.74 Dec. 26, 2025: 31 @ 94.75
Feb. 10, 2026issueSO-260210-445MAIN 17 94.75-1,610.72403,789.94 Dec. 26, 2025: 17 @ 94.75
Feb. 8, 2026issueSO-260208-890MAIN 2 94.75-189.50575,400.66 Dec. 26, 2025: 2 @ 94.75
Feb. 1, 2026issueSO-260201-310MAIN 11 94.75-1,042.23595,590.16 Dec. 26, 2025: 11 @ 94.75
Jan. 18, 2026issueSO-260118-881MAIN 68 94.75-6,442.89706,632.39 Dec. 26, 2025: 68 @ 94.75
Jan. 17, 2026issueSO-260117-584MAIN 1 94.75-94.7513813,075.28 Dec. 26, 2025: 1 @ 94.75
Jan. 6, 2026issueSO-260106-335MAIN 1 94.75-94.7513913,170.03 Dec. 26, 2025: 1 @ 94.75
Jan. 1, 2026issueSO-260101-812MAIN 74 94.89-7,022.0514013,264.78 Oct. 23, 2025: 24 @ 95.19; Dec. 26, 2025: 50 @ 94.75
Dec. 26, 2025transferTRFMAIN → EAST 40 warehouse transfer, no cost effect
Dec. 26, 2025receiptPO-001090MAIN 190 94.7518,002.2021420,286.83
Dec. 21, 2025issueSO-251221-201MAIN 12 95.19-1,142.32242,284.63 Oct. 23, 2025: 12 @ 95.19
Dec. 12, 2025issueSO-251212-204MAIN 59 95.19-5,616.39363,426.95 Oct. 23, 2025: 59 @ 95.19
Dec. 3, 2025issueSO-251203-671MAIN 30 95.19-2,855.79959,043.34 Oct. 23, 2025: 30 @ 95.19
Dec. 1, 2025issueSO-251201-607MAIN 18 95.19-1,713.4712511,899.12 Oct. 23, 2025: 18 @ 95.19
Nov. 28, 2025issueSO-251128-499MAIN 10 95.19-951.9314313,612.60 Oct. 23, 2025: 10 @ 95.19
Nov. 20, 2025issueSO-251120-741MAIN 15 95.19-1,427.9015314,564.53 Oct. 23, 2025: 15 @ 95.19
Nov. 18, 2025issueSO-251118-600MAIN 4 95.19-380.7716815,992.42 Oct. 23, 2025: 4 @ 95.19
Nov. 7, 2025issueSO-251107-312MAIN 10 95.19-951.9317216,373.20 Oct. 23, 2025: 10 @ 95.19
Nov. 3, 2025issueSO-251103-857MAIN 39 91.09-3,552.4818217,325.13 Aug. 11, 2025: 31 @ 90.03; Oct. 23, 2025: 8 @ 95.19
Oct. 23, 2025receiptPO-000942MAIN 190 95.1918,086.6722120,877.61
Oct. 19, 2025issueSO-251019-591MAIN 34 90.03-3,061.03312,790.94 Aug. 11, 2025: 34 @ 90.03
Oct. 6, 2025issueSO-251006-687MAIN 52 90.03-4,681.57655,851.96 Aug. 11, 2025: 52 @ 90.03
Sept. 27, 2025issueSO-250927-193MAIN 30 90.03-2,700.9111710,533.53 Aug. 11, 2025: 30 @ 90.03
Sept. 13, 2025issueSO-250913-195MAIN 7 90.03-630.2114713,234.44 Aug. 11, 2025: 7 @ 90.03
Sept. 13, 2025issueSO-250913-195EAST 39 90.15-3,515.7815413,864.65 June 7, 2025: 3 @ 91.56; Aug. 11, 2025: 36 @ 90.03
Aug. 31, 2025issueSO-250831-168MAIN 1 91.56-91.5619317,380.43 June 7, 2025: 1 @ 91.56
Aug. 28, 2025issueSO-250828-965MAIN 1 91.56-91.5619417,472.00 June 7, 2025: 1 @ 91.56
Aug. 23, 2025issueSO-250823-913MAIN 2 91.56-183.1319517,563.56 June 7, 2025: 2 @ 91.56
Aug. 18, 2025issueSO-250818-642EAST 1 91.56-91.5619717,746.69 June 7, 2025: 1 @ 91.56
Aug. 11, 2025transferTRFMAIN → EAST 40 warehouse transfer, no cost effect
Aug. 11, 2025receiptPO-000770MAIN 190 90.0317,105.7419817,838.25
Aug. 5, 2025issueSO-250805-714MAIN 11 91.56-1,007.218732.52 June 7, 2025: 11 @ 91.56
Aug. 4, 2025issueSO-250804-156MAIN 16 91.56-1,465.03191,739.72 June 7, 2025: 16 @ 91.56
Aug. 2, 2025issueSO-250802-329MAIN 29 91.56-2,655.37353,204.75 June 7, 2025: 29 @ 91.56
July 31, 2025issueSO-250731-282MAIN 2 91.56-183.13645,860.12 June 7, 2025: 2 @ 91.56
July 27, 2025issueSO-250727-206MAIN 50 91.56-4,578.22666,043.25 June 7, 2025: 50 @ 91.56
July 13, 2025issueSO-250713-912MAIN 5 91.56-457.8211610,621.47 June 7, 2025: 5 @ 91.56
July 10, 2025issueSO-250710-322MAIN 2 91.56-183.1312111,079.29 June 7, 2025: 2 @ 91.56
July 4, 2025issueSO-250704-290MAIN 15 91.56-1,373.4712311,262.42 June 7, 2025: 15 @ 91.56
July 2, 2025issueSO-250702-447MAIN 21 91.56-1,922.8513812,635.89 June 7, 2025: 21 @ 91.56
June 29, 2025issueSO-250629-520MAIN 16 91.56-1,465.0315914,558.74 June 7, 2025: 16 @ 91.56
June 26, 2025issueSO-250626-773MAIN 8 91.56-732.5217516,023.77 June 7, 2025: 8 @ 91.56
June 25, 2025issueSO-250625-791MAIN 7 91.56-640.9518316,756.29 June 7, 2025: 7 @ 91.56
June 7, 2025receiptPO-000610MAIN 190 91.5617,397.2419017,397.24
May 26, 2025issueSO-250526-995EAST 23 88.61-2,037.9600.00 March 18, 2025: 23 @ 88.61
May 25, 2025issueSO-250525-565EAST 21 88.61-1,860.74232,037.96 March 18, 2025: 21 @ 88.61
May 25, 2025issueSO-250525-565MAIN 32 88.61-2,835.42443,898.70 March 18, 2025: 32 @ 88.61
April 11, 2025issueSO-250411-754MAIN 18 88.61-1,594.92766,734.12 March 18, 2025: 18 @ 88.61
April 8, 2025issueSO-250408-895MAIN 75 88.61-6,645.52948,329.05 March 18, 2025: 75 @ 88.61
March 30, 2025issueSO-250330-367MAIN 33 89.40-2,950.3416914,974.57 Jan. 17, 2025: 12 @ 90.80; March 18, 2025: 21 @ 88.61
March 29, 2025issueSO-250329-418MAIN 12 90.80-1,089.5920217,924.90 Jan. 17, 2025: 12 @ 90.80
March 26, 2025issueSO-250326-523EAST 13 90.80-1,180.3921419,014.50 Jan. 17, 2025: 13 @ 90.80
March 18, 2025transferTRFMAIN → EAST 57 warehouse transfer, no cost effect
March 18, 2025receiptPO-000352MAIN 190 88.6116,835.3122720,194.89
March 12, 2025issueSO-250312-841MAIN 6 90.80-544.80373,359.58 Jan. 17, 2025: 6 @ 90.80
March 5, 2025issueSO-250305-531MAIN 23 90.80-2,088.39433,904.37 Jan. 17, 2025: 23 @ 90.80
Feb. 22, 2025issueSO-250222-551MAIN 9 90.80-817.19665,992.76 Jan. 17, 2025: 9 @ 90.80
Feb. 16, 2025issueSO-250216-533MAIN 2 90.80-181.60756,809.96 Jan. 17, 2025: 2 @ 90.80
Feb. 10, 2025issueSO-250210-296MAIN 33 90.80-2,996.38776,991.55 Jan. 17, 2025: 33 @ 90.80
Feb. 8, 2025issueSO-250208-747MAIN 21 90.80-1,906.791109,987.93 Jan. 17, 2025: 21 @ 90.80
Feb. 3, 2025issueSO-250203-959MAIN 1 90.80-90.8013111,894.72 Jan. 17, 2025: 1 @ 90.80
Feb. 2, 2025issueSO-250202-725MAIN 22 90.80-1,997.5913211,985.52 Jan. 17, 2025: 22 @ 90.80
Jan. 28, 2025issueSO-250128-827MAIN 16 90.80-1,452.7915413,983.11 Jan. 17, 2025: 16 @ 90.80
Jan. 25, 2025issueSO-250125-894MAIN 3 90.80-272.4017015,435.90 Jan. 17, 2025: 3 @ 90.80
Jan. 24, 2025issueSO-250124-228MAIN 4 90.80-363.2017315,708.30 Jan. 17, 2025: 4 @ 90.80
Jan. 17, 2025issueSO-250117-549MAIN 37 90.02-3,330.8917716,071.49 Nov. 24, 2024: 19 @ 89.60; Jan. 6, 2025: 5 @ 89.60; Jan. 17, 2025: 13 @ 90.80
Jan. 17, 2025receiptPO-000189MAIN 190 90.8017,251.8921419,402.38
Jan. 11, 2025issueSO-250111-244MAIN 30 89.60-2,688.12242,150.50 Nov. 24, 2024: 30 @ 89.60
Jan. 6, 2025returnRMAMAIN 5 89.60448.02544,838.62
Jan. 4, 2025issueSO-250104-302MAIN 18 89.60-1,612.87494,390.60 Nov. 24, 2024: 18 @ 89.60
Dec. 31, 2024issueSO-241231-116MAIN 1 89.60-89.60676,003.47 Nov. 24, 2024: 1 @ 89.60
Dec. 30, 2024issueSO-241230-266MAIN 7 89.60-627.23686,093.08 Nov. 24, 2024: 7 @ 89.60
Dec. 28, 2024adjustmentCycle countMAIN -2 89.60-179.21756,720.31 Nov. 24, 2024: 2 @ 89.60
Dec. 25, 2024issueSO-241225-720MAIN 11 89.60-985.65776,899.52 Nov. 24, 2024: 11 @ 89.60
Dec. 21, 2024issueSO-241221-517MAIN 34 89.60-3,046.54887,885.16 Nov. 24, 2024: 34 @ 89.60
Dec. 9, 2024issueSO-241209-857MAIN 34 89.60-3,046.5412210,931.70 Nov. 24, 2024: 34 @ 89.60
Dec. 4, 2024issueSO-241204-700MAIN 36 89.76-3,231.2415613,978.24 Nov. 19, 2024: 2 @ 92.35; Nov. 24, 2024: 34 @ 89.60
Nov. 28, 2024issueSO-241128-219MAIN 5 92.35-461.7519217,209.48 Nov. 19, 2024: 5 @ 92.35
Nov. 24, 2024receiptPO-000059MAIN 190 89.6017,024.7819717,671.23
Nov. 19, 2024returnRMAMAIN 7 92.35646.457646.45
Nov. 6, 2024issueSO-241106-694MAIN 14 92.35-1,292.8900.00 Oct. 1, 2024: 14 @ 92.35
Nov. 4, 2024issueSO-241104-150MAIN 74 92.35-6,833.86141,292.89 Oct. 1, 2024: 74 @ 92.35
Oct. 15, 2024issueSO-241015-924MAIN 11 92.35-1,015.84888,126.76 Oct. 1, 2024: 11 @ 92.35
Oct. 11, 2024issueSO-241011-489MAIN 2 92.35-184.70999,142.60 Oct. 1, 2024: 2 @ 92.35
Oct. 1, 2024issueSO-241001-904MAIN 89 92.35-8,219.111019,327.30 Oct. 1, 2024: 89 @ 92.35
Oct. 1, 2024receiptPO-000002MAIN 190 92.3517,546.4019017,546.40