stocksense

Items / CAB-0037

Coaxial Cable Prime CAB-0037 · Cables & Wires · Conduit & Cable Co

On hand (COIL)13MAIN 13
Value (FIFO)2,220.90avg 170.84
ClassAX / FCV 0.22
Turnover13.7xlast issue 2 days ago
Days of cover15lead time 14d

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

Demand and forecast

Monthly demand and forecast for CAB-00370.09.619.228.938.5Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 24.0Nov 24: 21.0Dec 24: 29.0Jan 25: 21.0Feb 25: 25.0Mar 25: 25.0Apr 25: 26.0May 25: 20.0Jun 25: 23.0Jul 25: 33.0Aug 25: 30.0Sep 25: 29.0Oct 25: 28.0Nov 25: 35.0Dec 25: 22.0Jan 26: 27.0Feb 26: 18.0Mar 26: 26.0Apr 26: 18.0May 26: 24.0Jun 26: 29.0Jul 26: 35.0Aug 26: 29.0Sep 26: 18.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.437525.75 / 30.43750.846
Daily demand sdmonthly sd / sqrt(30.4375)5.75 / 5.5171.042
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.042^2 + 0.846^2 * 3.1^2)9.7
Reorder pointd * LT + safety stock0.846 * 14.0 + 9.721.5
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days21.5
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 309/yr, S = 45.00, h = 20%, price = 170.4628.6
Inventory positionon hand + on order13 + 013

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

From qtyUnit costOrder qtyAnnual costFeasible
0170.462953,609yes (chosen if cheapest)

MOQ 60, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 2, 202613 / 60170.842,220.90

Movement ledger 140 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-867MAIN 1 170.84-170.84132,220.90 Sept. 2, 2026: 1 @ 170.84
Oct. 13, 2026issueSO-261013-164MAIN 13 170.84-2,220.90142,391.73 Sept. 2, 2026: 13 @ 170.84
Oct. 13, 2026issueSO-261013-164EAST 11 170.84-1,879.22274,612.63 Sept. 2, 2026: 11 @ 170.84
Oct. 12, 2026issueSO-261012-354EAST 2 170.84-341.68386,491.85 Sept. 2, 2026: 2 @ 170.84
Oct. 6, 2026issueSO-261006-874MAIN 3 170.84-512.51406,833.52 Sept. 2, 2026: 3 @ 170.84
Oct. 4, 2026issueSO-261004-794MAIN 2 170.84-341.68437,346.04 Sept. 2, 2026: 2 @ 170.84
Sept. 30, 2026issueSO-260930-914EAST 3 170.84-512.51457,687.71 Sept. 2, 2026: 3 @ 170.84
Sept. 22, 2026issueSO-260922-859MAIN 1 170.84-170.84488,200.23 Sept. 2, 2026: 1 @ 170.84
Sept. 20, 2026issueSO-260920-355MAIN 13 170.51-2,216.58498,371.07 July 8, 2026: 2 @ 168.68; Sept. 2, 2026: 11 @ 170.84
Sept. 19, 2026issueSO-260919-268MAIN 1 168.68-168.686210,587.65 July 8, 2026: 1 @ 168.68
Sept. 2, 2026transferTRFMAIN → EAST 16 warehouse transfer, no cost effect
Sept. 2, 2026receiptPO-001769MAIN 60 170.8410,250.296310,756.33
Aug. 23, 2026issueSO-260823-592MAIN 8 168.68-1,349.463506.05 July 8, 2026: 8 @ 168.68
Aug. 22, 2026issueSO-260822-170MAIN 17 168.68-2,867.59111,855.50 July 8, 2026: 17 @ 168.68
Aug. 18, 2026issueSO-260818-979MAIN 3 168.68-506.05284,723.09 July 8, 2026: 3 @ 168.68
Aug. 14, 2026issueSO-260814-788MAIN 1 168.68-168.68315,229.14 July 8, 2026: 1 @ 168.68
July 28, 2026issueSO-260728-790MAIN 10 168.68-1,686.82325,397.82 July 8, 2026: 10 @ 168.68
July 27, 2026issueSO-260727-435MAIN 4 168.68-674.73427,084.64 July 8, 2026: 4 @ 168.68
July 21, 2026issueSO-260721-614MAIN 15 168.41-2,526.10467,759.37 April 13, 2026: 1 @ 164.55; July 8, 2026: 14 @ 168.68
July 17, 2026issueSO-260717-268MAIN 6 163.55-981.306110,285.46 April 8, 2026: 6 @ 163.55
July 8, 2026receiptPO-001633MAIN 60 168.6810,120.916711,266.76
June 22, 2026issueSO-260622-121MAIN 16 163.55-2,616.8071,145.85 April 8, 2026: 16 @ 163.55
June 1, 2026issueSO-260601-901MAIN 13 163.55-2,126.15233,762.65 April 8, 2026: 13 @ 163.55
May 19, 2026issueSO-260519-672MAIN 10 163.55-1,635.50365,888.80 April 8, 2026: 10 @ 163.55
May 15, 2026issueSO-260515-423MAIN 1 163.55-163.55467,524.30 April 8, 2026: 1 @ 163.55
May 14, 2026issueSO-260514-861MAIN 1 163.55-163.55477,687.85 April 8, 2026: 1 @ 163.55
May 13, 2026issueSO-260513-362MAIN 3 163.55-490.65487,851.40 April 8, 2026: 3 @ 163.55
May 6, 2026issueSO-260506-216MAIN 4 163.55-654.20518,342.05 April 8, 2026: 4 @ 163.55
May 2, 2026issueSO-260502-549MAIN 5 163.55-817.75558,996.25 April 8, 2026: 5 @ 163.55
April 13, 2026returnRMAMAIN 1 164.55164.55609,814.00
April 11, 2026issueSO-260411-975MAIN 8 164.55-1,316.39599,649.45 Feb. 8, 2026: 7 @ 164.69; April 8, 2026: 1 @ 163.55
April 11, 2026issueSO-260411-975EAST 8 164.69-1,317.536710,965.84 Feb. 8, 2026: 8 @ 164.69
April 10, 2026issueSO-260410-689MAIN 3 164.69-494.077512,283.37 Feb. 8, 2026: 3 @ 164.69
April 8, 2026receiptPO-001391MAIN 60 163.559,813.007812,777.44
March 26, 2026issueSO-260326-942MAIN 2 164.69-329.38182,964.44 Feb. 8, 2026: 2 @ 164.69
March 23, 2026issueSO-260323-305MAIN 14 164.69-2,305.68203,293.82 Feb. 8, 2026: 14 @ 164.69
March 21, 2026issueSO-260321-745EAST 4 164.69-658.76345,599.50 Feb. 8, 2026: 4 @ 164.69
March 15, 2026issueSO-260315-691MAIN 4 164.69-658.76386,258.27 Feb. 8, 2026: 4 @ 164.69
March 12, 2026issueSO-260312-316EAST 1 164.69-164.69426,917.03 Feb. 8, 2026: 1 @ 164.69
March 3, 2026issueSO-260303-499EAST 1 164.69-164.69437,081.72 Feb. 8, 2026: 1 @ 164.69
Feb. 23, 2026issueSO-260223-260MAIN 1 164.69-164.69447,246.41 Feb. 8, 2026: 1 @ 164.69
Feb. 22, 2026issueSO-260222-198MAIN 4 164.69-658.76457,411.10 Feb. 8, 2026: 4 @ 164.69
Feb. 19, 2026issueSO-260219-385MAIN 4 164.69-658.76498,069.87 Feb. 8, 2026: 4 @ 164.69
Feb. 13, 2026issueSO-260213-591MAIN 3 164.69-494.07538,728.63 Feb. 8, 2026: 3 @ 164.69
Feb. 9, 2026issueSO-260209-216MAIN 4 164.69-658.76569,222.71 Feb. 8, 2026: 4 @ 164.69
Feb. 8, 2026transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
Feb. 8, 2026receiptPO-001208MAIN 60 164.699,881.47609,881.47
Feb. 7, 2026issueSO-260207-515EAST 2 160.08-320.1600.00 Nov. 26, 2025: 2 @ 160.08
Jan. 28, 2026issueSO-260128-990EAST 2 160.08-320.162320.16 Nov. 26, 2025: 2 @ 160.08
Jan. 26, 2026issueSO-260126-945EAST 2 160.08-320.164640.33 Nov. 26, 2025: 2 @ 160.08
Jan. 25, 2026issueSO-260125-763EAST 7 160.08-1,120.576960.49 Nov. 26, 2025: 7 @ 160.08
Jan. 25, 2026issueSO-260125-763MAIN 7 160.08-1,120.57132,081.07 Nov. 26, 2025: 7 @ 160.08
Jan. 4, 2026issueSO-260104-979MAIN 9 160.08-1,440.74203,201.64 Nov. 26, 2025: 9 @ 160.08
Dec. 27, 2025issueSO-251227-964MAIN 21 160.08-3,361.72294,642.38 Nov. 26, 2025: 21 @ 160.08
Dec. 22, 2025issueSO-251222-771MAIN 1 160.08-160.08508,004.10 Nov. 26, 2025: 1 @ 160.08
Nov. 26, 2025issueSO-251126-820MAIN 19 159.07-3,022.35518,164.18 Sept. 11, 2025: 10 @ 158.16; Nov. 26, 2025: 9 @ 160.08
Nov. 26, 2025transferTRFMAIN → EAST 13 warehouse transfer, no cost effect
Nov. 26, 2025receiptPO-001019MAIN 60 160.089,604.927011,186.53
Nov. 23, 2025issueSO-251123-507MAIN 4 158.16-632.65101,581.61 Sept. 11, 2025: 4 @ 158.16
Nov. 11, 2025issueSO-251111-304MAIN 3 158.16-474.48142,214.26 Sept. 11, 2025: 3 @ 158.16
Nov. 9, 2025issueSO-251109-567MAIN 4 158.16-632.65172,688.74 Sept. 11, 2025: 4 @ 158.16
Nov. 8, 2025issueSO-251108-853MAIN 5 158.16-790.81213,321.39 Sept. 11, 2025: 5 @ 158.16
Oct. 25, 2025issueSO-251025-319MAIN 2 158.16-316.32264,112.19 Sept. 11, 2025: 2 @ 158.16
Oct. 23, 2025issueSO-251023-686MAIN 3 158.16-474.48284,428.52 Sept. 11, 2025: 3 @ 158.16
Oct. 17, 2025issueSO-251017-768EAST 4 158.16-632.65314,903.00 Sept. 11, 2025: 4 @ 158.16
Oct. 9, 2025issueSO-251009-422MAIN 4 158.16-632.65355,535.65 Sept. 11, 2025: 4 @ 158.16
Oct. 2, 2025issueSO-251002-650MAIN 8 158.16-1,265.29396,168.29 Sept. 11, 2025: 8 @ 158.16
Oct. 1, 2025issueSO-251001-712MAIN 7 158.16-1,107.13477,433.58 Sept. 11, 2025: 7 @ 158.16
Sept. 27, 2025issueSO-250927-857MAIN 6 158.16-948.97548,540.71 Sept. 11, 2025: 6 @ 158.16
Sept. 20, 2025issueSO-250920-382MAIN 4 160.72-642.89609,489.68 July 18, 2025: 4 @ 160.72
Sept. 11, 2025receiptPO-000831MAIN 60 158.169,489.686410,132.56
Sept. 3, 2025issueSO-250903-698EAST 13 160.72-2,089.384642.89 July 18, 2025: 13 @ 160.72
Sept. 2, 2025issueSO-250902-808EAST 2 160.72-321.44172,732.26 July 18, 2025: 2 @ 160.72
Sept. 2, 2025issueSO-250902-808MAIN 4 160.72-642.89193,053.70 July 18, 2025: 4 @ 160.72
Aug. 23, 2025issueSO-250823-973MAIN 5 160.72-803.61233,696.59 July 18, 2025: 5 @ 160.72
Aug. 14, 2025issueSO-250814-297MAIN 23 160.72-3,696.59284,500.20 July 18, 2025: 23 @ 160.72
Aug. 13, 2025issueSO-250813-794MAIN 1 160.72-160.72518,196.79 July 18, 2025: 1 @ 160.72
Aug. 9, 2025issueSO-250809-957EAST 1 160.72-160.72528,357.51 July 18, 2025: 1 @ 160.72
July 30, 2025issueSO-250730-660MAIN 4 160.72-642.89538,518.23 July 18, 2025: 4 @ 160.72
July 27, 2025issueSO-250727-750MAIN 4 161.71-646.83579,161.11 May 6, 2025: 1 @ 164.66; July 18, 2025: 3 @ 160.72
July 18, 2025issueSO-250718-256MAIN 9 164.66-1,481.97619,807.94 May 6, 2025: 9 @ 164.66
July 18, 2025transferTRFMAIN → EAST 20 warehouse transfer, no cost effect
July 18, 2025receiptPO-000722MAIN 60 160.729,643.287011,289.91
July 13, 2025issueSO-250713-952MAIN 1 164.66-164.66101,646.63 May 6, 2025: 1 @ 164.66
July 12, 2025issueSO-250712-190MAIN 2 164.66-329.33111,811.30 May 6, 2025: 2 @ 164.66
July 10, 2025issueSO-250710-130MAIN 1 164.66-164.66132,140.62 May 6, 2025: 1 @ 164.66
July 1, 2025issueSO-250701-293MAIN 12 164.66-1,975.96142,305.29 May 6, 2025: 12 @ 164.66
June 26, 2025issueSO-250626-725MAIN 8 164.66-1,317.31264,281.25 May 6, 2025: 8 @ 164.66
June 18, 2025issueSO-250618-165MAIN 1 164.66-164.66345,598.56 May 6, 2025: 1 @ 164.66
June 16, 2025issueSO-250616-194MAIN 1 164.66-164.66355,763.22 May 6, 2025: 1 @ 164.66
June 12, 2025issueSO-250612-475MAIN 2 164.66-329.33365,927.88 May 6, 2025: 2 @ 164.66
June 9, 2025issueSO-250609-174MAIN 6 164.66-987.98386,257.21 May 6, 2025: 6 @ 164.66
June 9, 2025issueSO-250609-174EAST 3 164.66-493.99447,245.19 May 6, 2025: 3 @ 164.66
June 4, 2025issueSO-250604-263MAIN 2 164.66-329.33477,739.18 May 6, 2025: 2 @ 164.66
May 30, 2025issueSO-250530-523MAIN 1 164.66-164.66498,068.51 May 6, 2025: 1 @ 164.66
May 28, 2025issueSO-250528-840MAIN 1 164.66-164.66508,233.17 May 6, 2025: 1 @ 164.66
May 22, 2025issueSO-250522-630MAIN 2 164.66-329.33518,397.83 May 6, 2025: 2 @ 164.66
May 16, 2025issueSO-250516-724MAIN 3 164.66-493.99538,727.16 May 6, 2025: 3 @ 164.66
May 9, 2025issueSO-250509-596MAIN 7 163.19-1,142.36569,221.15 Feb. 18, 2025: 3 @ 161.24; May 6, 2025: 4 @ 164.66
May 6, 2025receiptPO-000515MAIN 60 164.669,879.806310,363.51
May 4, 2025issueSO-250504-345EAST 6 161.24-967.423483.71 Feb. 18, 2025: 6 @ 161.24
April 22, 2025issueSO-250422-535EAST 9 161.24-1,451.1291,451.12 Feb. 18, 2025: 9 @ 161.24
April 21, 2025issueSO-250421-913MAIN 2 161.24-322.47182,902.25 Feb. 18, 2025: 2 @ 161.24
April 18, 2025issueSO-250418-442EAST 1 161.24-161.24203,224.72 Feb. 18, 2025: 1 @ 161.24
April 16, 2025issueSO-250416-897MAIN 2 161.24-322.47213,385.96 Feb. 18, 2025: 2 @ 161.24
April 13, 2025issueSO-250413-514MAIN 9 161.24-1,451.12233,708.43 Feb. 18, 2025: 9 @ 161.24
April 5, 2025issueSO-250405-258MAIN 3 161.24-483.71325,159.55 Feb. 18, 2025: 3 @ 161.24
March 29, 2025issueSO-250329-514MAIN 2 161.24-322.47355,643.26 Feb. 18, 2025: 2 @ 161.24
March 28, 2025issueSO-250328-332MAIN 3 161.24-483.71375,965.73 Feb. 18, 2025: 3 @ 161.24
March 24, 2025issueSO-250324-799MAIN 10 161.24-1,612.36406,449.44 Feb. 18, 2025: 10 @ 161.24
March 22, 2025issueSO-250322-102EAST 1 161.24-161.24508,061.80 Feb. 18, 2025: 1 @ 161.24
March 20, 2025issueSO-250320-306MAIN 6 161.24-967.42518,223.04 Feb. 18, 2025: 6 @ 161.24
March 18, 2025issueSO-250318-831MAIN 3 161.24-483.71579,190.45 Feb. 18, 2025: 3 @ 161.24
Feb. 28, 2025issueSO-250228-709MAIN 1 161.94-161.94609,674.16 Dec. 11, 2024: 1 @ 161.94
Feb. 20, 2025issueSO-250220-631MAIN 1 153.41-153.41619,836.10 Nov. 28, 2024: 1 @ 153.41
Feb. 18, 2025transferTRFMAIN → EAST 18 warehouse transfer, no cost effect
Feb. 18, 2025receiptPO-000274MAIN 60 161.249,674.16629,989.50
Feb. 14, 2025issueSO-250214-777EAST 8 153.41-1,227.262315.34 Nov. 28, 2024: 8 @ 153.41
Feb. 5, 2025issueSO-250205-618EAST 9 153.41-1,380.67101,542.60 Nov. 28, 2024: 9 @ 153.41
Feb. 5, 2025issueSO-250205-618MAIN 6 153.41-920.44192,923.27 Nov. 28, 2024: 6 @ 153.41
Jan. 29, 2025issueSO-250129-509MAIN 9 153.41-1,380.67253,843.71 Nov. 28, 2024: 9 @ 153.41
Jan. 9, 2025issueSO-250109-287MAIN 12 153.41-1,840.89345,224.38 Nov. 28, 2024: 12 @ 153.41
Dec. 30, 2024issueSO-241230-886MAIN 1 153.41-153.41467,065.27 Nov. 28, 2024: 1 @ 153.41
Dec. 29, 2024issueSO-241229-355EAST 10 153.41-1,534.07477,218.68 Nov. 28, 2024: 10 @ 153.41
Dec. 26, 2024issueSO-241226-310MAIN 11 158.84-1,747.19578,752.75 Oct. 1, 2024: 7 @ 161.94; Nov. 28, 2024: 4 @ 153.41
Dec. 25, 2024issueSO-241225-260MAIN 1 161.94-161.946810,499.94 Oct. 1, 2024: 1 @ 161.94
Dec. 23, 2024issueSO-241223-881MAIN 1 161.94-161.946910,661.88 Oct. 1, 2024: 1 @ 161.94
Dec. 11, 2024returnRMAMAIN 1 161.94161.947010,823.81
Dec. 7, 2024issueSO-241207-186MAIN 5 161.94-809.686910,661.88 Oct. 1, 2024: 5 @ 161.94
Dec. 2, 2024issueSO-241202-833EAST 1 161.94-161.947411,471.56 Oct. 1, 2024: 1 @ 161.94
Nov. 28, 2024transferTRFMAIN → EAST 20 warehouse transfer, no cost effect
Nov. 28, 2024receiptPO-000064MAIN 60 153.419,204.447511,633.50
Nov. 13, 2024issueSO-241113-768MAIN 12 161.94-1,943.24152,429.06 Oct. 1, 2024: 12 @ 161.94
Nov. 7, 2024issueSO-241107-640MAIN 9 161.94-1,457.43274,372.30 Oct. 1, 2024: 9 @ 161.94
Oct. 23, 2024issueSO-241023-510MAIN 10 161.94-1,619.37365,829.73 Oct. 1, 2024: 10 @ 161.94
Oct. 17, 2024issueSO-241017-512EAST 4 161.94-647.75467,449.10 Oct. 1, 2024: 4 @ 161.94
Oct. 8, 2024issueSO-241008-396MAIN 1 161.94-161.94508,096.85 Oct. 1, 2024: 1 @ 161.94
Oct. 6, 2024issueSO-241006-123MAIN 9 161.94-1,457.43518,258.79 Oct. 1, 2024: 9 @ 161.94
Oct. 1, 2024transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000002MAIN 60 161.949,716.22609,716.22