stocksense

Items / CAB-0034

FR Wire 2.5 sqmm Classic CAB-0034 · Cables & Wires · Conduit & Cable Co

On hand (COIL)15MAIN 15
Value (FIFO)1,069.60avg 71.31
ClassBX / FCV 0.26
Turnover26.1xlast issue 0 days ago
Days of cover20lead time 14d

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

Demand and forecast

Monthly demand and forecast for CAB-00340.09.919.829.739.6Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 27.0Nov 24: 25.0Dec 24: 18.0Jan 25: 20.0Feb 25: 23.0Mar 25: 18.0Apr 25: 20.0May 25: 24.0Jun 25: 33.0Jul 25: 24.0Aug 25: 20.0Sep 25: 25.0Oct 25: 28.0Nov 25: 36.0Dec 25: 26.0Jan 26: 26.0Feb 26: 23.0Mar 26: 16.0Apr 26: 19.0May 26: 29.0Jun 26: 17.0Jul 26: 19.0Aug 26: 20.0Sep 26: 15.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.437522.83 / 30.43750.750
Daily demand sdmonthly sd / sqrt(30.4375)6.04 / 5.5171.095
Service level / zz = Phi^-1(service level)Phi^-1(0.950)1.645
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.645 * sqrt(14.0 * 1.095^2 + 0.750^2 * 3.1^2)7.8
Reorder pointd * LT + safety stock0.750 * 14.0 + 7.818.3
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days18.3
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 274/yr, S = 45.00, h = 20%, price = 70.4941.8
Inventory positionon hand + on order15 + 015

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

From qtyUnit costOrder qtyAnnual costFeasible
070.494219,890yes (chosen if cheapest)

MOQ 50, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 7, 202615 / 5071.311,069.60

Movement ledger 131 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-994MAIN 2 71.31-142.61151,069.60 Sept. 7, 2026: 2 @ 71.31
Oct. 13, 2026issueSO-261013-197MAIN 11 71.31-784.38171,212.22 Sept. 7, 2026: 11 @ 71.31
Oct. 8, 2026issueSO-261008-800MAIN 7 71.31-499.15281,996.59 Sept. 7, 2026: 7 @ 71.31
Oct. 3, 2026issueSO-261003-384MAIN 12 71.31-855.68352,495.74 Sept. 7, 2026: 12 @ 71.31
Oct. 2, 2026issueSO-261002-994MAIN 2 71.31-142.61473,351.42 Sept. 7, 2026: 2 @ 71.31
Sept. 12, 2026issueSO-260912-341MAIN 1 71.31-71.31493,494.04 Sept. 7, 2026: 1 @ 71.31
Sept. 10, 2026issueSO-260910-737MAIN 8 71.65-573.17503,565.34 July 10, 2026: 8 @ 71.65
Sept. 7, 2026receiptPO-001777MAIN 50 71.313,565.34584,138.52
Sept. 6, 2026issueSO-260906-925MAIN 1 71.65-71.658573.17 July 10, 2026: 1 @ 71.65
Sept. 4, 2026issueSO-260904-873MAIN 4 71.65-286.599644.82 July 10, 2026: 4 @ 71.65
Sept. 1, 2026issueSO-260901-774MAIN 1 71.65-71.6513931.41 July 10, 2026: 1 @ 71.65
Aug. 26, 2026issueSO-260826-750MAIN 6 71.65-429.88141,003.05 July 10, 2026: 6 @ 71.65
Aug. 23, 2026issueSO-260823-681MAIN 1 71.65-71.65201,432.93 July 10, 2026: 1 @ 71.65
Aug. 22, 2026issueSO-260822-675MAIN 1 71.65-71.65211,504.58 July 10, 2026: 1 @ 71.65
Aug. 19, 2026issueSO-260819-516MAIN 1 71.65-71.65221,576.23 July 10, 2026: 1 @ 71.65
Aug. 17, 2026issueSO-260817-959MAIN 1 71.65-71.65231,647.87 July 10, 2026: 1 @ 71.65
Aug. 16, 2026issueSO-260816-821MAIN 9 71.65-644.82241,719.52 July 10, 2026: 9 @ 71.65
Aug. 12, 2026issueSO-260812-592MAIN 1 71.65-71.65332,364.34 July 10, 2026: 1 @ 71.65
July 28, 2026issueSO-260728-683MAIN 1 71.65-71.65342,435.98 July 10, 2026: 1 @ 71.65
July 25, 2026issueSO-260725-526MAIN 1 71.65-71.65352,507.63 July 10, 2026: 1 @ 71.65
July 20, 2026issueSO-260720-981MAIN 4 71.65-286.59362,579.28 July 10, 2026: 4 @ 71.65
July 15, 2026issueSO-260715-597MAIN 10 71.65-716.47402,865.86 July 10, 2026: 10 @ 71.65
July 10, 2026receiptPO-001638MAIN 50 71.653,582.33503,582.33
July 9, 2026issueSO-260709-163MAIN 3 69.46-208.3900.00 April 21, 2026: 3 @ 69.46
June 25, 2026issueSO-260625-387MAIN 5 69.46-347.323208.39 April 21, 2026: 5 @ 69.46
June 24, 2026issueSO-260624-957MAIN 12 69.46-833.588555.72 April 21, 2026: 12 @ 69.46
May 30, 2026issueSO-260530-951MAIN 11 69.46-764.11201,389.29 April 21, 2026: 11 @ 69.46
May 29, 2026issueSO-260529-510MAIN 7 69.46-486.25312,153.41 April 21, 2026: 7 @ 69.46
May 22, 2026issueSO-260522-894MAIN 11 69.46-764.11382,639.66 April 21, 2026: 11 @ 69.46
April 27, 2026issueSO-260427-284MAIN 1 69.46-69.46493,403.77 April 21, 2026: 1 @ 69.46
April 21, 2026receiptPO-001426MAIN 50 69.463,473.24503,473.24
April 10, 2026issueSO-260410-460MAIN 4 67.09-268.3700.00 Jan. 27, 2026: 4 @ 67.09
April 6, 2026issueSO-260406-736MAIN 14 67.09-939.294268.37 Jan. 27, 2026: 14 @ 67.09
March 29, 2026issueSO-260329-326MAIN 10 67.09-670.92181,207.66 Jan. 27, 2026: 10 @ 67.09
March 7, 2026issueSO-260307-995MAIN 6 67.09-402.55281,878.59 Jan. 27, 2026: 6 @ 67.09
Feb. 27, 2026issueSO-260227-156MAIN 1 67.09-67.09342,281.14 Jan. 27, 2026: 1 @ 67.09
Feb. 23, 2026issueSO-260223-973MAIN 1 67.09-67.09352,348.23 Jan. 27, 2026: 1 @ 67.09
Feb. 6, 2026issueSO-260206-704MAIN 15 67.10-1,006.45362,415.33 Dec. 8, 2025: 1 @ 67.16; Jan. 27, 2026: 14 @ 67.09
Feb. 2, 2026issueSO-260202-485MAIN 6 67.16-402.96513,421.78 Dec. 8, 2025: 6 @ 67.16
Jan. 27, 2026receiptPO-001179MAIN 50 67.093,354.62573,824.74
Jan. 18, 2026issueSO-260118-672MAIN 2 67.16-134.327470.12 Dec. 8, 2025: 2 @ 67.16
Jan. 11, 2026issueSO-260111-132MAIN 22 67.16-1,477.549604.45 Dec. 8, 2025: 22 @ 67.16
Jan. 5, 2026issueSO-260105-260MAIN 2 67.16-134.32312,081.98 Dec. 8, 2025: 2 @ 67.16
Dec. 25, 2025issueSO-251225-553MAIN 10 67.16-671.61332,216.30 Dec. 8, 2025: 10 @ 67.16
Dec. 25, 2025issueSO-251225-553EAST 12 66.93-803.12432,887.91 Oct. 23, 2025: 5 @ 66.60; Dec. 8, 2025: 7 @ 67.16
Dec. 8, 2025transferTRFMAIN → EAST 12 warehouse transfer, no cost effect
Dec. 8, 2025receiptPO-001038MAIN 50 67.163,358.04553,691.03
Dec. 7, 2025issueSO-251207-255MAIN 4 66.60-266.395332.99 Oct. 23, 2025: 4 @ 66.60
Nov. 30, 2025issueSO-251130-581MAIN 2 66.60-133.209599.38 Oct. 23, 2025: 2 @ 66.60
Nov. 28, 2025issueSO-251128-518MAIN 3 66.60-199.7911732.58 Oct. 23, 2025: 3 @ 66.60
Nov. 21, 2025issueSO-251121-674MAIN 14 66.60-932.3814932.38 Oct. 23, 2025: 14 @ 66.60
Nov. 15, 2025issueSO-251115-524MAIN 13 66.60-865.78281,864.75 Oct. 23, 2025: 13 @ 66.60
Nov. 13, 2025issueSO-251113-889MAIN 4 66.60-266.39412,730.53 Oct. 23, 2025: 4 @ 66.60
Oct. 28, 2025issueSO-251028-607MAIN 11 67.39-741.33452,996.92 Aug. 20, 2025: 5 @ 68.06; Oct. 21, 2025: 1 @ 68.06; Oct. 23, 2025: 5 @ 66.60
Oct. 23, 2025receiptPO-000943MAIN 50 66.603,329.92563,738.25
Oct. 22, 2025issueSO-251022-509MAIN 2 68.06-136.116408.34 Aug. 20, 2025: 2 @ 68.06
Oct. 21, 2025returnRMAMAIN 1 68.0668.068544.45
Oct. 14, 2025issueSO-251014-843MAIN 13 68.06-884.737476.39 Aug. 20, 2025: 13 @ 68.06
Oct. 11, 2025issueSO-251011-260MAIN 2 68.06-136.11201,361.12 Aug. 20, 2025: 2 @ 68.06
Oct. 4, 2025issueSO-251004-518MAIN 1 68.06-68.06221,497.23 Aug. 20, 2025: 1 @ 68.06
Sept. 29, 2025issueSO-250929-751MAIN 10 68.06-680.56231,565.29 Aug. 20, 2025: 10 @ 68.06
Sept. 16, 2025issueSO-250916-273MAIN 11 68.06-748.62332,245.85 Aug. 20, 2025: 11 @ 68.06
Sept. 3, 2025issueSO-250903-579MAIN 3 68.06-204.17442,994.47 Aug. 20, 2025: 3 @ 68.06
Sept. 2, 2025issueSO-250902-805MAIN 1 68.06-68.06473,198.64 Aug. 20, 2025: 1 @ 68.06
Aug. 23, 2025issueSO-250823-576MAIN 11 67.30-740.30483,266.69 June 26, 2025: 5 @ 67.13; July 4, 2025: 4 @ 67.13; Aug. 20, 2025: 2 @ 68.06
Aug. 20, 2025receiptPO-000784MAIN 50 68.063,402.80594,007.00
Aug. 16, 2025issueSO-250816-296MAIN 2 67.13-134.269604.19 June 26, 2025: 2 @ 67.13
Aug. 11, 2025issueSO-250811-431MAIN 1 67.13-67.1311738.46 June 26, 2025: 1 @ 67.13
Aug. 8, 2025issueSO-250808-522MAIN 5 67.13-335.6612805.59 June 26, 2025: 5 @ 67.13
Aug. 5, 2025issueSO-250805-595MAIN 1 67.13-67.13171,141.25 June 26, 2025: 1 @ 67.13
July 30, 2025issueSO-250730-841MAIN 1 67.13-67.13181,208.38 June 26, 2025: 1 @ 67.13
July 22, 2025issueSO-250722-972MAIN 5 67.13-335.66191,275.51 June 26, 2025: 5 @ 67.13
July 12, 2025issueSO-250712-559MAIN 22 67.13-1,476.91241,611.18 June 26, 2025: 22 @ 67.13
July 4, 2025returnRMAMAIN 4 67.13268.53463,088.09
June 28, 2025issueSO-250628-731MAIN 8 67.13-537.06422,819.56 June 26, 2025: 8 @ 67.13
June 26, 2025issueSO-250626-148MAIN 5 66.34-331.72503,356.62 April 17, 2025: 5 @ 66.34
June 26, 2025issueSO-250626-148EAST 1 66.34-66.34553,688.34 April 17, 2025: 1 @ 66.34
June 26, 2025receiptPO-000667MAIN 50 67.133,356.62563,754.68
June 19, 2025issueSO-250619-290EAST 1 66.34-66.346398.07 April 17, 2025: 1 @ 66.34
June 16, 2025issueSO-250616-255MAIN 10 66.34-663.447464.41 April 17, 2025: 10 @ 66.34
June 12, 2025issueSO-250612-374MAIN 1 66.34-66.34171,127.86 April 17, 2025: 1 @ 66.34
June 9, 2025issueSO-250609-263MAIN 1 66.34-66.34181,194.20 April 17, 2025: 1 @ 66.34
June 7, 2025issueSO-250607-636EAST 6 66.34-398.07191,260.55 April 17, 2025: 6 @ 66.34
May 21, 2025issueSO-250521-445EAST 7 66.34-464.41251,658.61 April 17, 2025: 7 @ 66.34
May 14, 2025issueSO-250514-477EAST 1 66.34-66.34322,123.02 April 17, 2025: 1 @ 66.34
May 8, 2025issueSO-250508-599MAIN 1 66.34-66.34332,189.37 April 17, 2025: 1 @ 66.34
May 1, 2025issueSO-250501-755MAIN 15 66.34-995.17342,255.71 April 17, 2025: 15 @ 66.34
April 25, 2025issueSO-250425-181MAIN 1 66.34-66.34493,250.88 April 17, 2025: 1 @ 66.34
April 17, 2025transferTRFMAIN → EAST 16 warehouse transfer, no cost effect
April 17, 2025receiptPO-000457MAIN 50 66.343,317.22503,317.22
April 5, 2025issueSO-250405-235MAIN 19 65.01-1,235.1500.00 Feb. 14, 2025: 19 @ 65.01
March 26, 2025issueSO-250326-186MAIN 2 65.01-130.02191,235.15 Feb. 14, 2025: 2 @ 65.01
March 20, 2025issueSO-250320-875MAIN 6 65.01-390.05211,365.16 Feb. 14, 2025: 6 @ 65.01
March 17, 2025issueSO-250317-867MAIN 6 65.01-390.05271,755.21 Feb. 14, 2025: 6 @ 65.01
March 14, 2025issueSO-250314-321MAIN 3 65.01-195.02332,145.25 Feb. 14, 2025: 3 @ 65.01
March 6, 2025issueSO-250306-468MAIN 1 65.01-65.01362,340.28 Feb. 14, 2025: 1 @ 65.01
Feb. 28, 2025issueSO-250228-112MAIN 5 65.01-325.04372,405.28 Feb. 14, 2025: 5 @ 65.01
Feb. 27, 2025issueSO-250227-161MAIN 3 65.01-195.02422,730.32 Feb. 14, 2025: 3 @ 65.01
Feb. 23, 2025issueSO-250223-740MAIN 1 65.01-65.01452,925.35 Feb. 14, 2025: 1 @ 65.01
Feb. 15, 2025issueSO-250215-202MAIN 3 65.01-195.02462,990.35 Feb. 14, 2025: 3 @ 65.01
Feb. 14, 2025issueSO-250214-616MAIN 1 65.01-65.01493,185.38 Feb. 14, 2025: 1 @ 65.01
Feb. 14, 2025receiptPO-000266MAIN 50 65.013,250.38503,250.38
Feb. 7, 2025issueSO-250207-815MAIN 10 65.16-651.6300.00 Nov. 23, 2024: 9 @ 65.16; Dec. 9, 2024: 1 @ 65.16
Jan. 29, 2025issueSO-250129-920MAIN 7 65.16-456.1410651.63 Nov. 23, 2024: 7 @ 65.16
Jan. 17, 2025issueSO-250117-384MAIN 2 65.16-130.33171,107.76 Nov. 23, 2024: 2 @ 65.16
Jan. 14, 2025issueSO-250114-674MAIN 4 65.16-260.65191,238.09 Nov. 23, 2024: 4 @ 65.16
Jan. 13, 2025issueSO-250113-593MAIN 2 65.16-130.33231,498.74 Nov. 23, 2024: 2 @ 65.16
Jan. 13, 2025issueSO-250113-593EAST 4 65.16-260.65251,629.06 Nov. 23, 2024: 4 @ 65.16
Jan. 2, 2025issueSO-250102-230MAIN 1 65.16-65.16291,889.72 Nov. 23, 2024: 1 @ 65.16
Dec. 24, 2024issueSO-241224-163MAIN 1 65.16-65.16301,954.88 Nov. 23, 2024: 1 @ 65.16
Dec. 23, 2024issueSO-241223-592MAIN 3 65.16-195.49312,020.04 Nov. 23, 2024: 3 @ 65.16
Dec. 20, 2024issueSO-241220-166EAST 3 65.16-195.49342,215.53 Nov. 23, 2024: 3 @ 65.16
Dec. 17, 2024issueSO-241217-590MAIN 5 65.16-325.81372,411.02 Nov. 23, 2024: 5 @ 65.16
Dec. 15, 2024issueSO-241215-938EAST 6 65.16-390.98422,736.83 Nov. 23, 2024: 6 @ 65.16
Dec. 9, 2024returnRMAMAIN 1 65.1665.16483,127.80
Dec. 3, 2024issueSO-241203-114EAST 1 65.16-65.16473,062.64 Nov. 23, 2024: 1 @ 65.16
Nov. 30, 2024issueSO-241130-957MAIN 2 65.16-130.33483,127.80 Nov. 23, 2024: 2 @ 65.16
Nov. 23, 2024transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
Nov. 23, 2024receiptPO-000054MAIN 50 65.163,258.13503,258.13
Nov. 20, 2024issueSO-241120-532EAST 2 66.97-133.9300.00 Oct. 1, 2024: 2 @ 66.97
Nov. 12, 2024issueSO-241112-359EAST 3 66.97-200.902133.93 Oct. 1, 2024: 3 @ 66.97
Nov. 12, 2024issueSO-241112-359MAIN 7 66.97-468.765334.83 Oct. 1, 2024: 7 @ 66.97
Nov. 10, 2024issueSO-241110-423MAIN 4 66.97-267.8612803.59 Oct. 1, 2024: 4 @ 66.97
Nov. 8, 2024issueSO-241108-732MAIN 1 66.97-66.97161,071.45 Oct. 1, 2024: 1 @ 66.97
Nov. 5, 2024issueSO-241105-217MAIN 1 66.97-66.97171,138.41 Oct. 1, 2024: 1 @ 66.97
Nov. 4, 2024issueSO-241104-111MAIN 5 66.97-334.83181,205.38 Oct. 1, 2024: 5 @ 66.97
Oct. 23, 2024issueSO-241023-351MAIN 7 66.97-468.76231,540.21 Oct. 1, 2024: 7 @ 66.97
Oct. 16, 2024issueSO-241016-115MAIN 10 66.97-669.66302,008.96 Oct. 1, 2024: 10 @ 66.97
Oct. 7, 2024issueSO-241007-688EAST 10 66.97-669.66402,678.62 Oct. 1, 2024: 10 @ 66.97
Oct. 1, 2024transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000002MAIN 50 66.973,348.28503,348.28