stocksense

Items / CAB-0016

FR Wire 4 sqmm Prime CAB-0016 · Cables & Wires · Conduit & Cable Co

On hand (COIL)15MAIN 15
Value (FIFO)4,313.77avg 287.58
ClassAX / FCV 0.23
Turnover16.1xlast issue 1 days ago
Days of cover23lead time 14d

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

Demand and forecast

Monthly demand and forecast for CAB-00160.09.118.227.236.3Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 33.0Nov 24: 18.0Dec 24: 29.0Jan 25: 20.0Feb 25: 11.0Mar 25: 25.0Apr 25: 19.0May 25: 23.0Jun 25: 23.0Jul 25: 18.0Aug 25: 24.0Sep 25: 28.0Oct 25: 29.0Nov 25: 13.0Dec 25: 25.0Jan 26: 16.0Feb 26: 21.0Mar 26: 25.0Apr 26: 16.0May 26: 23.0Jun 26: 17.0Jul 26: 20.0Aug 26: 15.0Sep 26: 20.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.437520.00 / 30.43750.657
Daily demand sdmonthly sd / sqrt(30.4375)4.62 / 5.5170.837
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 * 0.837^2 + 0.657^2 * 3.1^2)7.7
Reorder pointd * LT + safety stock0.657 * 14.0 + 7.716.9
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days16.9
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 240/yr, S = 45.00, h = 20%, price = 265.31200.0
Inventory positionon hand + on order15 + 015

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

From qtyUnit costOrder qtyAnnual costFeasible
0288.381970,280yes
100276.8410069,274yes
200265.3120068,991yes (chosen if cheapest)

MOQ 50, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 27, 202615 / 50287.584,313.77

Movement ledger 126 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-402MAIN 3 287.58-862.75154,313.77 Aug. 27, 2026: 3 @ 287.58
Oct. 10, 2026issueSO-261010-685MAIN 9 287.58-2,588.26185,176.52 Aug. 27, 2026: 9 @ 287.58
Oct. 7, 2026issueSO-261007-547MAIN 12 287.58-3,451.01277,764.78 Aug. 27, 2026: 12 @ 287.58
Sept. 29, 2026issueSO-260929-100MAIN 1 287.58-287.583911,215.79 Aug. 27, 2026: 1 @ 287.58
Sept. 24, 2026issueSO-260924-769MAIN 1 287.58-287.584011,503.38 Aug. 27, 2026: 1 @ 287.58
Sept. 15, 2026issueSO-260915-612MAIN 8 287.58-2,300.684111,790.96 Aug. 27, 2026: 8 @ 287.58
Sept. 8, 2026issueSO-260908-204MAIN 1 287.58-287.584914,091.64 Aug. 27, 2026: 1 @ 287.58
Sept. 6, 2026issueSO-260906-819MAIN 2 285.71-571.425014,379.22 June 16, 2026: 2 @ 285.71
Sept. 1, 2026issueSO-260901-580MAIN 7 285.71-1,999.975214,950.64 June 16, 2026: 7 @ 285.71
Aug. 27, 2026receiptPO-001751MAIN 50 287.5814,379.225916,950.62
Aug. 20, 2026issueSO-260820-245MAIN 2 285.71-571.4292,571.40 June 16, 2026: 2 @ 285.71
Aug. 16, 2026issueSO-260816-879MAIN 1 285.71-285.71113,142.82 June 16, 2026: 1 @ 285.71
Aug. 15, 2026issueSO-260815-821MAIN 6 285.71-1,714.26123,428.53 June 16, 2026: 6 @ 285.71
Aug. 14, 2026issueSO-260814-663MAIN 1 285.71-285.71185,142.79 June 16, 2026: 1 @ 285.71
Aug. 9, 2026issueSO-260809-159MAIN 2 285.71-571.42195,428.50 June 16, 2026: 2 @ 285.71
Aug. 6, 2026issueSO-260806-166MAIN 2 285.71-571.42215,999.92 June 16, 2026: 2 @ 285.71
Aug. 3, 2026issueSO-260803-641MAIN 1 285.71-285.71236,571.35 June 16, 2026: 1 @ 285.71
July 31, 2026issueSO-260731-744MAIN 2 285.71-571.42246,857.06 June 16, 2026: 2 @ 285.71
July 24, 2026issueSO-260724-642MAIN 6 285.71-1,714.26267,428.48 June 16, 2026: 6 @ 285.71
July 19, 2026issueSO-260719-104MAIN 1 285.71-285.71329,142.74 June 16, 2026: 1 @ 285.71
July 9, 2026issueSO-260709-389MAIN 1 285.71-285.71339,428.45 June 16, 2026: 1 @ 285.71
July 7, 2026issueSO-260707-338MAIN 7 285.71-1,999.97349,714.16 June 16, 2026: 7 @ 285.71
July 4, 2026issueSO-260704-756MAIN 3 285.71-857.134111,714.14 June 16, 2026: 3 @ 285.71
June 30, 2026issueSO-260630-107MAIN 5 285.71-1,428.554412,571.27 June 16, 2026: 5 @ 285.71
June 27, 2026issueSO-260627-209MAIN 1 285.71-285.714913,999.82 June 16, 2026: 1 @ 285.71
June 16, 2026receiptPO-001577MAIN 50 285.7114,285.545014,285.54
June 15, 2026issueSO-260615-762EAST 2 280.48-560.9500.00 April 5, 2026: 2 @ 280.48
June 15, 2026issueSO-260615-762MAIN 1 280.48-280.482560.95 April 5, 2026: 1 @ 280.48
June 9, 2026issueSO-260609-908MAIN 6 280.48-1,682.863841.43 April 5, 2026: 6 @ 280.48
June 5, 2026issueSO-260605-403EAST 2 280.48-560.9592,524.29 April 5, 2026: 2 @ 280.48
May 31, 2026issueSO-260531-859MAIN 8 280.48-2,243.81113,085.24 April 5, 2026: 8 @ 280.48
May 10, 2026issueSO-260510-527EAST 9 280.48-2,524.29195,329.05 April 5, 2026: 9 @ 280.48
May 5, 2026issueSO-260505-241MAIN 6 280.48-1,682.86287,853.33 April 5, 2026: 6 @ 280.48
April 29, 2026issueSO-260429-585MAIN 4 280.48-1,121.90349,536.19 April 5, 2026: 4 @ 280.48
April 28, 2026issueSO-260428-947MAIN 3 280.48-841.433810,658.10 April 5, 2026: 3 @ 280.48
April 19, 2026issueSO-260419-470MAIN 1 280.48-280.484111,499.52 April 5, 2026: 1 @ 280.48
April 9, 2026issueSO-260409-935MAIN 4 280.48-1,121.904211,780.00 April 5, 2026: 4 @ 280.48
April 6, 2026issueSO-260406-982EAST 4 280.48-1,121.904612,901.91 April 5, 2026: 4 @ 280.48
April 5, 2026transferTRFMAIN → EAST 17 warehouse transfer, no cost effect
April 5, 2026receiptPO-001386MAIN 50 280.4814,023.815014,023.81
March 28, 2026issueSO-260328-134MAIN 1 275.24-275.2400.00 Dec. 25, 2025: 1 @ 275.24
March 27, 2026issueSO-260327-203MAIN 6 275.24-1,651.461275.24 Dec. 25, 2025: 6 @ 275.24
March 24, 2026issueSO-260324-477MAIN 6 275.24-1,651.4671,926.71 Dec. 25, 2025: 6 @ 275.24
March 21, 2026issueSO-260321-738MAIN 1 275.24-275.24133,578.17 Dec. 25, 2025: 1 @ 275.24
March 19, 2026issueSO-260319-639MAIN 10 275.24-2,752.44143,853.41 Dec. 25, 2025: 10 @ 275.24
March 14, 2026issueSO-260314-334MAIN 1 275.24-275.24246,605.85 Dec. 25, 2025: 1 @ 275.24
Feb. 26, 2026issueSO-260226-912MAIN 1 275.24-275.24256,881.10 Dec. 25, 2025: 1 @ 275.24
Feb. 23, 2026issueSO-260223-335MAIN 2 275.24-550.49267,156.34 Dec. 25, 2025: 2 @ 275.24
Feb. 13, 2026issueSO-260213-188MAIN 7 275.24-1,926.71287,706.83 Dec. 25, 2025: 7 @ 275.24
Feb. 11, 2026issueSO-260211-772MAIN 4 275.24-1,100.98359,633.53 Dec. 25, 2025: 4 @ 275.24
Feb. 9, 2026issueSO-260209-111MAIN 6 275.24-1,651.463910,734.51 Dec. 25, 2025: 6 @ 275.24
Feb. 6, 2026issueSO-260206-190MAIN 1 275.24-275.244512,385.97 Dec. 25, 2025: 1 @ 275.24
Jan. 23, 2026issueSO-260123-385MAIN 13 271.54-3,529.984612,661.21 Nov. 1, 2025: 8 @ 269.89; Nov. 29, 2025: 1 @ 269.89; Dec. 25, 2025: 4 @ 275.24
Jan. 6, 2026issueSO-260106-936MAIN 3 269.89-809.675916,191.19 Nov. 1, 2025: 3 @ 269.89
Dec. 25, 2025receiptPO-001085MAIN 50 275.2413,762.196217,000.86
Dec. 13, 2025issueSO-251213-709MAIN 23 269.89-6,207.45123,238.67 Nov. 1, 2025: 23 @ 269.89
Dec. 10, 2025issueSO-251210-955MAIN 2 269.89-539.78359,446.12 Nov. 1, 2025: 2 @ 269.89
Nov. 29, 2025returnRMAMAIN 1 269.89269.89379,985.90
Nov. 23, 2025issueSO-251123-424MAIN 6 269.89-1,619.34369,716.01 Nov. 1, 2025: 6 @ 269.89
Nov. 22, 2025issueSO-251122-410MAIN 4 269.89-1,079.564211,335.35 Nov. 1, 2025: 4 @ 269.89
Nov. 20, 2025issueSO-251120-958MAIN 2 269.89-539.784612,414.90 Nov. 1, 2025: 2 @ 269.89
Nov. 19, 2025issueSO-251119-825MAIN 1 269.89-269.894812,954.68 Nov. 1, 2025: 1 @ 269.89
Nov. 1, 2025issueSO-251101-598MAIN 1 269.89-269.894913,224.57 Nov. 1, 2025: 1 @ 269.89
Nov. 1, 2025receiptPO-000971MAIN 50 269.8913,494.465013,494.46
Oct. 19, 2025issueSO-251019-880MAIN 16 277.33-4,437.3300.00 Aug. 22, 2025: 16 @ 277.33
Oct. 5, 2025issueSO-251005-218MAIN 7 277.33-1,941.33164,437.33 Aug. 22, 2025: 7 @ 277.33
Oct. 2, 2025issueSO-251002-781MAIN 6 277.33-1,664.00236,378.66 Aug. 22, 2025: 6 @ 277.33
Sept. 29, 2025issueSO-250929-681MAIN 1 277.33-277.33298,042.66 Aug. 22, 2025: 1 @ 277.33
Sept. 26, 2025issueSO-250926-648MAIN 13 277.33-3,605.33308,319.99 Aug. 22, 2025: 13 @ 277.33
Sept. 20, 2025issueSO-250920-301MAIN 2 277.33-554.674311,925.32 Aug. 22, 2025: 2 @ 277.33
Sept. 13, 2025issueSO-250913-820MAIN 2 277.33-554.674512,479.98 Aug. 22, 2025: 2 @ 277.33
Sept. 10, 2025issueSO-250910-270MAIN 10 277.79-2,777.864713,034.65 June 12, 2025: 6 @ 277.98; July 22, 2025: 1 @ 277.98; Aug. 22, 2025: 3 @ 277.33
Aug. 22, 2025receiptPO-000786MAIN 50 277.3313,866.655715,812.51
Aug. 20, 2025issueSO-250820-968MAIN 2 277.98-555.9671,945.86 June 12, 2025: 2 @ 277.98
Aug. 9, 2025issueSO-250809-730MAIN 6 277.98-1,667.8892,501.82 June 12, 2025: 6 @ 277.98
Aug. 8, 2025issueSO-250808-652MAIN 11 277.98-3,057.78154,169.70 June 12, 2025: 11 @ 277.98
Aug. 3, 2025issueSO-250803-244MAIN 4 277.98-1,111.92267,227.48 June 12, 2025: 4 @ 277.98
Aug. 1, 2025issueSO-250801-568MAIN 1 277.98-277.98308,339.40 June 12, 2025: 1 @ 277.98
July 29, 2025issueSO-250729-826MAIN 17 277.98-4,725.66318,617.38 June 12, 2025: 17 @ 277.98
July 28, 2025issueSO-250728-540MAIN 1 277.98-277.984813,343.04 June 12, 2025: 1 @ 277.98
July 22, 2025returnRMAMAIN 1 277.98277.984913,621.02
July 7, 2025issueSO-250707-875MAIN 1 277.98-277.984813,343.04 June 12, 2025: 1 @ 277.98
June 26, 2025issueSO-250626-162MAIN 1 277.98-277.984913,621.02 June 12, 2025: 1 @ 277.98
June 12, 2025receiptPO-000627MAIN 50 277.9813,899.005013,899.00
June 10, 2025issueSO-250610-680MAIN 14 267.29-3,742.0800.00 April 9, 2025: 14 @ 267.29
June 1, 2025issueSO-250601-631MAIN 8 267.29-2,138.33143,742.08 April 9, 2025: 8 @ 267.29
May 31, 2025issueSO-250531-478MAIN 10 267.29-2,672.91225,880.41 April 9, 2025: 10 @ 267.29
May 26, 2025issueSO-250526-976MAIN 3 267.29-801.87328,553.32 April 9, 2025: 3 @ 267.29
May 21, 2025issueSO-250521-511MAIN 1 267.29-267.29359,355.20 April 9, 2025: 1 @ 267.29
May 15, 2025issueSO-250515-573MAIN 5 267.29-1,336.46369,622.49 April 9, 2025: 5 @ 267.29
May 13, 2025issueSO-250513-836MAIN 1 267.29-267.294110,958.94 April 9, 2025: 1 @ 267.29
May 7, 2025issueSO-250507-956MAIN 1 267.29-267.294211,226.23 April 9, 2025: 1 @ 267.29
May 1, 2025issueSO-250501-757MAIN 2 267.29-534.584311,493.53 April 9, 2025: 2 @ 267.29
April 29, 2025issueSO-250429-196MAIN 10 266.89-2,668.894512,028.11 Feb. 5, 2025: 5 @ 266.49; April 9, 2025: 5 @ 267.29
April 9, 2025receiptPO-000428MAIN 50 267.2913,364.565514,697.00
April 8, 2025issueSO-250408-212MAIN 9 266.49-2,398.3751,332.43 Feb. 5, 2025: 9 @ 266.49
March 23, 2025issueSO-250323-339MAIN 6 266.49-1,598.92143,730.80 Feb. 5, 2025: 6 @ 266.49
March 22, 2025issueSO-250322-193MAIN 4 266.49-1,065.94205,329.72 Feb. 5, 2025: 4 @ 266.49
March 14, 2025issueSO-250314-195MAIN 4 266.49-1,065.94246,395.66 Feb. 5, 2025: 4 @ 266.49
March 3, 2025issueSO-250303-381MAIN 10 266.49-2,664.86287,461.61 Feb. 5, 2025: 10 @ 266.49
March 1, 2025issueSO-250301-697MAIN 1 266.49-266.493810,126.47 Feb. 5, 2025: 1 @ 266.49
Feb. 27, 2025issueSO-250227-255MAIN 5 266.49-1,332.433910,392.95 Feb. 5, 2025: 5 @ 266.49
Feb. 25, 2025issueSO-250225-567MAIN 4 266.49-1,065.944411,725.38 Feb. 5, 2025: 4 @ 266.49
Feb. 24, 2025issueSO-250224-837MAIN 1 266.49-266.494812,791.33 Feb. 5, 2025: 1 @ 266.49
Feb. 22, 2025issueSO-250222-660MAIN 1 266.49-266.494913,057.81 Feb. 5, 2025: 1 @ 266.49
Feb. 5, 2025receiptPO-000240MAIN 50 266.4913,324.305013,324.30
Jan. 26, 2025issueSO-250126-863MAIN 1 266.33-266.3300.00 Nov. 15, 2024: 1 @ 266.33
Jan. 25, 2025issueSO-250125-961MAIN 5 266.33-1,331.671266.33 Nov. 15, 2024: 5 @ 266.33
Jan. 23, 2025issueSO-250123-216MAIN 3 266.33-799.0061,598.01 Nov. 15, 2024: 3 @ 266.33
Jan. 18, 2025issueSO-250118-215MAIN 4 266.33-1,065.3492,397.01 Nov. 15, 2024: 4 @ 266.33
Jan. 17, 2025issueSO-250117-538MAIN 5 266.33-1,331.67133,462.34 Nov. 15, 2024: 5 @ 266.33
Jan. 12, 2025issueSO-250112-953MAIN 2 266.33-532.67184,794.02 Nov. 15, 2024: 2 @ 266.33
Dec. 18, 2024issueSO-241218-113MAIN 1 266.33-266.33205,326.68 Nov. 15, 2024: 1 @ 266.33
Dec. 10, 2024issueSO-241210-303MAIN 10 266.33-2,663.34215,593.02 Nov. 15, 2024: 10 @ 266.33
Dec. 8, 2024issueSO-241208-176MAIN 4 266.33-1,065.34318,256.36 Nov. 15, 2024: 4 @ 266.33
Dec. 4, 2024issueSO-241204-563MAIN 14 266.33-3,728.68359,321.70 Nov. 15, 2024: 14 @ 266.33
Nov. 26, 2024issueSO-241126-303MAIN 1 266.33-266.334913,050.38 Nov. 15, 2024: 1 @ 266.33
Nov. 15, 2024receiptPO-000035MAIN 50 266.3313,316.715013,316.71
Nov. 13, 2024issueSO-241113-167MAIN 13 273.96-3,561.4900.00 Oct. 1, 2024: 13 @ 273.96
Nov. 7, 2024issueSO-241107-159MAIN 4 273.96-1,095.84133,561.49 Oct. 1, 2024: 4 @ 273.96
Oct. 31, 2024issueSO-241031-692MAIN 1 273.96-273.96174,657.34 Oct. 1, 2024: 1 @ 273.96
Oct. 29, 2024issueSO-241029-287MAIN 12 273.96-3,287.53184,931.30 Oct. 1, 2024: 12 @ 273.96
Oct. 18, 2024issueSO-241018-858MAIN 15 273.96-4,109.42308,218.83 Oct. 1, 2024: 15 @ 273.96
Oct. 17, 2024issueSO-241017-771MAIN 4 273.96-1,095.844512,328.24 Oct. 1, 2024: 4 @ 273.96
Oct. 2, 2024issueSO-241002-353MAIN 1 273.96-273.964913,424.09 Oct. 1, 2024: 1 @ 273.96
Oct. 1, 2024receiptPO-000002MAIN 50 273.9613,698.055013,698.05