stocksense

Items / CAB-0032

Coaxial Cable Pro CAB-0032 · Cables & Wires · Conduit & Cable Co

On hand (COIL)2MAIN 2
Value (FIFO)533.02avg 266.51
ClassAX / FCV 0.30
Turnover11.7xlast issue 7 days ago
Days of cover2lead time 14d

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

Demand and forecast

Monthly demand and forecast for CAB-00320.014.028.142.156.1Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 41.0Nov 24: 35.0Dec 24: 21.0Jan 25: 25.0Feb 25: 31.0Mar 25: 27.0Apr 25: 31.0May 25: 23.0Jun 25: 28.0Jul 25: 32.0Aug 25: 22.0Sep 25: 24.0Oct 25: 21.0Nov 25: 29.0Dec 25: 26.0Jan 26: 25.0Feb 26: 24.0Mar 26: 18.0Apr 26: 30.0May 26: 31.0Jun 26: 23.0Jul 26: 36.0Aug 26: 51.0Sep 26: 39.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.437529.42 / 30.43750.966
Daily demand sdmonthly sd / sqrt(30.4375)8.69 / 5.5171.576
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.576^2 + 0.966^2 * 3.1^2)13.6
Reorder pointd * LT + safety stock0.966 * 14.0 + 13.627.2
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days27.2
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 353/yr, S = 45.00, h = 20%, price = 266.6124.4
Inventory positionon hand + on order2 + 02

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

From qtyUnit costOrder qtyAnnual costFeasible
0266.612495,350yes (chosen if cheapest)

MOQ 60, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 23, 20261 / 60266.51266.51
Sept. 14, 20261 / 1266.51266.51

Movement ledger 131 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 9, 2026issueSO-261009-501MAIN 8 266.51-2,132.072533.02 Aug. 23, 2026: 8 @ 266.51
Oct. 4, 2026issueSO-261004-180MAIN 6 266.51-1,599.06102,665.09 Aug. 23, 2026: 6 @ 266.51
Oct. 4, 2026issueSO-261004-180EAST 1 266.51-266.51164,264.15 Aug. 23, 2026: 1 @ 266.51
Oct. 3, 2026issueSO-261003-855EAST 5 266.51-1,332.55174,530.66 Aug. 23, 2026: 5 @ 266.51
Oct. 1, 2026issueSO-261001-751EAST 5 266.51-1,332.55225,863.20 Aug. 23, 2026: 5 @ 266.51
Sept. 30, 2026issueSO-260930-996MAIN 12 266.51-3,198.11277,195.75 Aug. 23, 2026: 12 @ 266.51
Sept. 23, 2026issueSO-260923-851MAIN 14 266.51-3,731.133910,393.86 Aug. 23, 2026: 14 @ 266.51
Sept. 14, 2026returnRMAMAIN 1 266.51266.515314,124.99
Sept. 11, 2026issueSO-260911-684EAST 2 266.51-533.025213,858.48 Aug. 23, 2026: 2 @ 266.51
Sept. 2, 2026issueSO-260902-951MAIN 12 263.56-3,162.725414,391.50 July 28, 2026: 6 @ 260.61; Aug. 23, 2026: 6 @ 266.51
Aug. 30, 2026issueSO-260830-901MAIN 7 260.61-1,824.286617,554.22 July 28, 2026: 7 @ 260.61
Aug. 23, 2026transferTRFMAIN → EAST 13 warehouse transfer, no cost effect
Aug. 23, 2026receiptPO-001740MAIN 60 266.5115,990.557319,378.50
Aug. 13, 2026issueSO-260813-245MAIN 15 260.61-3,909.17133,387.95 July 28, 2026: 15 @ 260.61
Aug. 13, 2026issueSO-260813-245EAST 14 260.61-3,648.56287,297.12 July 28, 2026: 14 @ 260.61
Aug. 7, 2026issueSO-260807-797MAIN 15 260.61-3,909.174210,945.68 July 28, 2026: 15 @ 260.61
July 31, 2026issueSO-260731-777MAIN 1 260.61-260.615714,854.85 July 28, 2026: 1 @ 260.61
July 29, 2026issueSO-260729-546MAIN 7 260.82-1,825.715815,115.46 May 16, 2026: 5 @ 260.90; July 28, 2026: 2 @ 260.61
July 28, 2026transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
July 28, 2026receiptPO-001681MAIN 60 260.6115,636.686516,941.18
July 27, 2026issueSO-260727-637MAIN 3 260.90-782.6951,304.49 May 16, 2026: 3 @ 260.90
July 17, 2026issueSO-260717-298MAIN 4 260.90-1,043.5982,087.19 May 16, 2026: 4 @ 260.90
July 14, 2026issueSO-260714-308MAIN 18 260.90-4,696.17123,130.78 May 16, 2026: 18 @ 260.90
July 9, 2026issueSO-260709-948MAIN 2 260.90-521.80307,826.95 May 16, 2026: 2 @ 260.90
July 4, 2026issueSO-260704-181MAIN 1 260.90-260.90328,348.74 May 16, 2026: 1 @ 260.90
June 30, 2026issueSO-260630-298MAIN 3 260.90-782.69338,609.64 May 16, 2026: 3 @ 260.90
June 22, 2026issueSO-260622-107MAIN 2 260.90-521.80369,392.34 May 16, 2026: 2 @ 260.90
June 16, 2026issueSO-260616-713MAIN 3 260.90-782.69389,914.13 May 16, 2026: 3 @ 260.90
June 13, 2026issueSO-260613-206MAIN 3 260.90-782.694110,696.83 May 16, 2026: 3 @ 260.90
June 12, 2026issueSO-260612-748MAIN 5 260.90-1,304.494411,479.52 May 16, 2026: 5 @ 260.90
June 9, 2026issueSO-260609-149MAIN 3 260.90-782.694912,784.01 May 16, 2026: 3 @ 260.90
June 6, 2026issueSO-260606-748MAIN 4 260.90-1,043.595213,566.71 May 16, 2026: 4 @ 260.90
May 16, 2026issueSO-260516-551MAIN 6 258.20-1,549.195614,610.30 March 14, 2026: 2 @ 252.80; May 16, 2026: 4 @ 260.90
May 16, 2026receiptPO-001497MAIN 60 260.9015,653.896216,159.49
May 13, 2026issueSO-260513-560MAIN 1 252.80-252.802505.60 March 14, 2026: 1 @ 252.80
May 7, 2026issueSO-260507-432MAIN 17 252.80-4,297.573758.40 March 14, 2026: 17 @ 252.80
May 2, 2026issueSO-260502-195MAIN 7 252.80-1,769.59205,055.97 March 14, 2026: 7 @ 252.80
April 29, 2026issueSO-260429-784MAIN 3 252.80-758.40276,825.56 March 14, 2026: 3 @ 252.80
April 27, 2026issueSO-260427-843MAIN 3 252.80-758.40307,583.95 March 14, 2026: 3 @ 252.80
April 19, 2026issueSO-260419-167MAIN 3 252.80-758.40338,342.35 March 14, 2026: 3 @ 252.80
April 15, 2026issueSO-260415-388MAIN 1 252.80-252.80369,100.74 March 14, 2026: 1 @ 252.80
April 10, 2026issueSO-260410-447MAIN 12 252.80-3,033.58379,353.54 March 14, 2026: 12 @ 252.80
April 1, 2026issueSO-260401-468MAIN 8 252.80-2,022.394912,387.12 March 14, 2026: 8 @ 252.80
March 29, 2026issueSO-260329-257MAIN 13 262.00-3,405.985714,409.51 Dec. 19, 2025: 10 @ 264.76; March 14, 2026: 3 @ 252.80
March 14, 2026receiptPO-001317MAIN 60 252.8015,167.907017,815.49
March 1, 2026issueSO-260301-913MAIN 5 264.76-1,323.79102,647.59 Dec. 19, 2025: 5 @ 264.76
Feb. 28, 2026issueSO-260228-450MAIN 7 264.76-1,853.31153,971.38 Dec. 19, 2025: 7 @ 264.76
Feb. 1, 2026issueSO-260201-800MAIN 17 264.76-4,500.90225,824.69 Dec. 19, 2025: 17 @ 264.76
Jan. 29, 2026issueSO-260129-858MAIN 2 264.76-529.523910,325.59 Dec. 19, 2025: 2 @ 264.76
Jan. 19, 2026issueSO-260119-517MAIN 5 264.76-1,323.794110,855.11 Dec. 19, 2025: 5 @ 264.76
Jan. 14, 2026issueSO-260114-196MAIN 3 264.76-794.284612,178.90 Dec. 19, 2025: 3 @ 264.76
Jan. 13, 2026issueSO-260113-587MAIN 4 264.76-1,059.044912,973.18 Dec. 19, 2025: 4 @ 264.76
Jan. 11, 2026issueSO-260111-807MAIN 1 264.76-264.765314,032.22 Dec. 19, 2025: 1 @ 264.76
Jan. 8, 2026issueSO-260108-514MAIN 1 264.76-264.765414,296.98 Dec. 19, 2025: 1 @ 264.76
Jan. 1, 2026issueSO-260101-970MAIN 5 264.76-1,323.795514,561.73 Dec. 19, 2025: 5 @ 264.76
Jan. 1, 2026issueSO-260101-970EAST 4 256.28-1,025.116015,885.53 Oct. 15, 2025: 4 @ 256.28
Dec. 29, 2025issueSO-251229-429EAST 7 256.28-1,793.946416,910.64 Oct. 15, 2025: 7 @ 256.28
Dec. 19, 2025receiptPO-001065MAIN 60 264.7615,885.537118,704.57
Dec. 11, 2025issueSO-251211-792EAST 1 256.28-256.28112,819.05 Oct. 15, 2025: 1 @ 256.28
Dec. 7, 2025issueSO-251207-244EAST 5 256.28-1,281.38123,075.32 Oct. 15, 2025: 5 @ 256.28
Dec. 7, 2025issueSO-251207-244MAIN 8 256.28-2,050.22174,356.71 Oct. 15, 2025: 8 @ 256.28
Dec. 6, 2025issueSO-251206-534MAIN 2 256.28-512.55256,406.92 Oct. 15, 2025: 2 @ 256.28
Dec. 1, 2025issueSO-251201-277MAIN 3 256.28-768.83276,919.48 Oct. 15, 2025: 3 @ 256.28
Nov. 28, 2025issueSO-251128-421MAIN 2 256.28-512.55307,688.31 Oct. 15, 2025: 2 @ 256.28
Nov. 27, 2025issueSO-251127-836EAST 2 256.28-512.55328,200.86 Oct. 15, 2025: 2 @ 256.28
Nov. 24, 2025issueSO-251124-350MAIN 4 256.28-1,025.11348,713.41 Oct. 15, 2025: 4 @ 256.28
Nov. 14, 2025issueSO-251114-421MAIN 8 256.28-2,050.22389,738.52 Oct. 15, 2025: 8 @ 256.28
Nov. 2, 2025issueSO-251102-713MAIN 13 256.28-3,331.604611,788.74 Oct. 15, 2025: 13 @ 256.28
Oct. 20, 2025issueSO-251020-766MAIN 1 256.28-256.285915,120.34 Oct. 15, 2025: 1 @ 256.28
Oct. 15, 2025transferTRFMAIN → EAST 19 warehouse transfer, no cost effect
Oct. 15, 2025receiptPO-000920MAIN 60 256.2815,376.616015,376.61
Oct. 14, 2025issueSO-251014-728MAIN 7 248.33-1,738.3400.00 Aug. 4, 2025: 7 @ 248.33
Oct. 10, 2025issueSO-251010-489MAIN 1 248.33-248.3371,738.34 Aug. 4, 2025: 1 @ 248.33
Oct. 7, 2025issueSO-251007-671MAIN 12 248.33-2,980.0281,986.68 Aug. 4, 2025: 12 @ 248.33
Sept. 29, 2025issueSO-250929-856MAIN 16 248.33-3,973.36204,966.70 Aug. 4, 2025: 16 @ 248.33
Sept. 16, 2025issueSO-250916-414MAIN 8 248.33-1,986.68368,940.05 Aug. 4, 2025: 8 @ 248.33
Aug. 28, 2025issueSO-250828-859EAST 6 248.33-1,490.014410,926.73 Aug. 4, 2025: 6 @ 248.33
Aug. 19, 2025issueSO-250819-786MAIN 7 248.33-1,738.345012,416.74 Aug. 4, 2025: 7 @ 248.33
Aug. 14, 2025issueSO-250814-611MAIN 3 248.33-745.005714,155.08 Aug. 4, 2025: 3 @ 248.33
Aug. 11, 2025issueSO-250811-956MAIN 2 246.24-492.486014,900.09 May 14, 2025: 2 @ 246.24
Aug. 9, 2025issueSO-250809-755MAIN 4 246.24-984.966215,392.57 May 14, 2025: 4 @ 246.24
Aug. 4, 2025receiptPO-000757MAIN 60 248.3314,900.096616,377.53
July 27, 2025issueSO-250727-736EAST 1 246.24-246.2461,477.44 May 14, 2025: 1 @ 246.24
July 18, 2025issueSO-250718-686EAST 11 246.24-2,708.6471,723.68 May 14, 2025: 11 @ 246.24
July 18, 2025issueSO-250718-686MAIN 7 246.24-1,723.68184,432.33 May 14, 2025: 7 @ 246.24
July 14, 2025issueSO-250714-329MAIN 13 246.24-3,201.13256,156.01 May 14, 2025: 13 @ 246.24
June 30, 2025issueSO-250630-423MAIN 5 246.24-1,231.20389,357.14 May 14, 2025: 5 @ 246.24
June 24, 2025issueSO-250624-347MAIN 2 246.24-492.484310,588.34 May 14, 2025: 2 @ 246.24
June 22, 2025issueSO-250622-778EAST 2 246.24-492.484511,080.82 May 14, 2025: 2 @ 246.24
June 12, 2025issueSO-250612-345EAST 1 246.24-246.244711,573.30 May 14, 2025: 1 @ 246.24
June 11, 2025issueSO-250611-883MAIN 1 246.24-246.244811,819.54 May 14, 2025: 1 @ 246.24
June 8, 2025issueSO-250608-102MAIN 5 246.24-1,231.204912,065.78 May 14, 2025: 5 @ 246.24
June 2, 2025issueSO-250602-112MAIN 12 249.83-2,997.985413,296.98 March 30, 2025: 6 @ 253.42; May 14, 2025: 6 @ 246.24
May 14, 2025transferTRFMAIN → EAST 21 warehouse transfer, no cost effect
May 14, 2025receiptPO-000535MAIN 60 246.2414,774.426616,294.96
May 12, 2025issueSO-250512-207MAIN 14 253.42-3,547.9261,520.54 March 30, 2025: 14 @ 253.42
May 3, 2025issueSO-250503-636MAIN 9 253.42-2,280.81205,068.46 March 30, 2025: 9 @ 253.42
April 24, 2025issueSO-250424-616MAIN 3 253.42-760.27297,349.27 March 30, 2025: 3 @ 253.42
April 17, 2025issueSO-250417-861MAIN 12 253.42-3,041.08328,109.54 March 30, 2025: 12 @ 253.42
April 10, 2025issueSO-250410-198MAIN 9 253.42-2,280.814411,150.61 March 30, 2025: 9 @ 253.42
April 9, 2025issueSO-250409-779MAIN 2 253.42-506.855313,431.42 March 30, 2025: 2 @ 253.42
April 8, 2025issueSO-250408-881MAIN 1 253.42-253.425513,938.26 March 30, 2025: 1 @ 253.42
April 5, 2025issueSO-250405-960MAIN 4 253.42-1,013.695614,191.69 March 30, 2025: 4 @ 253.42
March 30, 2025receiptPO-000392MAIN 60 253.4215,205.386015,205.38
March 26, 2025issueSO-250326-581EAST 1 247.02-247.0200.00 Jan. 22, 2025: 1 @ 247.02
March 20, 2025issueSO-250320-840EAST 6 247.02-1,482.091247.02 Jan. 22, 2025: 6 @ 247.02
March 20, 2025issueSO-250320-840MAIN 3 247.02-741.0571,729.11 Jan. 22, 2025: 3 @ 247.02
March 19, 2025issueSO-250319-987MAIN 8 247.02-1,976.13102,470.16 Jan. 22, 2025: 8 @ 247.02
March 13, 2025issueSO-250313-853EAST 6 247.02-1,482.09184,446.28 Jan. 22, 2025: 6 @ 247.02
March 2, 2025issueSO-250302-698MAIN 3 247.02-741.05245,928.38 Jan. 22, 2025: 3 @ 247.02
Feb. 18, 2025issueSO-250218-700MAIN 8 247.02-1,976.13276,669.42 Jan. 22, 2025: 8 @ 247.02
Feb. 14, 2025issueSO-250214-139MAIN 23 247.02-5,681.36358,645.55 Jan. 22, 2025: 23 @ 247.02
Jan. 28, 2025issueSO-250128-457MAIN 2 247.02-494.035814,326.91 Jan. 22, 2025: 2 @ 247.02
Jan. 22, 2025transferTRFMAIN → EAST 13 warehouse transfer, no cost effect
Jan. 22, 2025receiptPO-000207MAIN 60 247.0214,820.946014,820.94
Jan. 9, 2025issueSO-250109-437MAIN 16 239.64-3,834.2700.00 Nov. 6, 2024: 16 @ 239.64
Jan. 8, 2025issueSO-250108-363MAIN 7 239.64-1,677.49163,834.27 Nov. 6, 2024: 7 @ 239.64
Dec. 17, 2024issueSO-241217-937MAIN 21 239.64-5,032.48235,511.76 Nov. 6, 2024: 21 @ 239.64
Nov. 30, 2024issueSO-241130-694MAIN 1 239.64-239.644410,544.23 Nov. 6, 2024: 1 @ 239.64
Nov. 25, 2024issueSO-241125-664MAIN 4 239.64-958.574510,783.88 Nov. 6, 2024: 4 @ 239.64
Nov. 18, 2024issueSO-241118-998MAIN 5 239.64-1,198.214911,742.44 Nov. 6, 2024: 5 @ 239.64
Nov. 9, 2024issueSO-241109-209MAIN 11 245.84-2,704.255412,940.65 Oct. 1, 2024: 5 @ 253.28; Nov. 6, 2024: 6 @ 239.64
Nov. 8, 2024issueSO-241108-171MAIN 1 253.28-253.286515,644.90 Oct. 1, 2024: 1 @ 253.28
Nov. 6, 2024issueSO-241106-640MAIN 7 253.28-1,772.966615,898.18 Oct. 1, 2024: 7 @ 253.28
Nov. 6, 2024receiptPO-000026MAIN 60 239.6414,378.507317,671.14
Nov. 5, 2024issueSO-241105-750MAIN 6 253.28-1,519.68133,292.63 Oct. 1, 2024: 6 @ 253.28
Oct. 31, 2024issueSO-241031-169MAIN 1 253.28-253.28194,812.31 Oct. 1, 2024: 1 @ 253.28
Oct. 27, 2024issueSO-241027-977MAIN 11 253.28-2,786.07205,065.59 Oct. 1, 2024: 11 @ 253.28
Oct. 20, 2024issueSO-241020-194MAIN 11 253.28-2,786.07317,851.66 Oct. 1, 2024: 11 @ 253.28
Oct. 1, 2024issueSO-241001-146MAIN 18 253.28-4,559.034210,637.74 Oct. 1, 2024: 18 @ 253.28
Oct. 1, 2024receiptPO-000002MAIN 60 253.2815,196.776015,196.77