stocksense

Items / CAB-0003

Coaxial Cable Classic CAB-0003 · Cables & Wires · Conduit & Cable Co

On hand (COIL)19MAIN 19
Value (FIFO)1,106.89avg 58.26
ClassAX / FCV 0.26
Turnover9.7xlast issue 3 days ago
Days of cover12lead time 14d

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

Demand and forecast

Monthly demand and forecast for CAB-00030.022.344.666.889.1Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 57.0Nov 24: 43.0Dec 24: 50.0Jan 25: 51.0Feb 25: 49.0Mar 25: 45.0Apr 25: 41.0May 25: 29.0Jun 25: 52.0Jul 25: 46.0Aug 25: 35.0Sep 25: 45.0Oct 25: 51.0Nov 25: 47.0Dec 25: 40.0Jan 26: 81.0Feb 26: 56.0Mar 26: 62.0Apr 26: 53.0May 26: 27.0Jun 26: 46.0Jul 26: 49.0Aug 26: 39.0Sep 26: 41.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.437549.33 / 30.43751.621
Daily demand sdmonthly sd / sqrt(30.4375)12.92 / 5.5172.342
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 * 2.342^2 + 1.621^2 * 3.1^2)20.8
Reorder pointd * LT + safety stock1.621 * 14.0 + 20.843.5
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days43.5
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 592/yr, S = 45.00, h = 20%, price = 59.2467.0
Inventory positionon hand + on order19 + 019

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

From qtyUnit costOrder qtyAnnual costFeasible
059.246735,840yes (chosen if cheapest)

MOQ 100, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 30, 202618 / 10058.261,048.63
Sept. 27, 20261 / 158.2658.26

Movement ledger 131 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 13, 2026issueSO-261013-746MAIN 6 58.26-349.54191,106.89 Aug. 30, 2026: 6 @ 58.26
Oct. 12, 2026issueSO-261012-888MAIN 25 58.26-1,456.43251,456.43 Aug. 30, 2026: 25 @ 58.26
Oct. 8, 2026issueSO-261008-595MAIN 7 58.26-407.80502,912.86 Aug. 30, 2026: 7 @ 58.26
Oct. 5, 2026issueSO-261005-270MAIN 3 58.26-174.77573,320.66 Aug. 30, 2026: 3 @ 58.26
Oct. 4, 2026issueSO-261004-640MAIN 1 58.26-58.26603,495.43 Aug. 30, 2026: 1 @ 58.26
Sept. 27, 2026returnRMAMAIN 1 58.2658.26613,553.69
Sept. 21, 2026issueSO-260921-915MAIN 1 58.26-58.26603,495.43 Aug. 30, 2026: 1 @ 58.26
Sept. 19, 2026issueSO-260919-954MAIN 7 58.26-407.80613,553.69 Aug. 30, 2026: 7 @ 58.26
Sept. 19, 2026issueSO-260919-954EAST 5 58.26-291.29683,961.49 Aug. 30, 2026: 5 @ 58.26
Sept. 17, 2026issueSO-260917-653MAIN 8 58.26-466.06734,252.78 Aug. 30, 2026: 8 @ 58.26
Sept. 11, 2026issueSO-260911-152MAIN 4 58.26-233.03814,718.83 Aug. 30, 2026: 4 @ 58.26
Sept. 3, 2026issueSO-260903-781EAST 13 58.26-757.34854,951.86 Aug. 30, 2026: 13 @ 58.26
Sept. 1, 2026issueSO-260901-353EAST 4 57.67-230.70985,709.21 Aug. 3, 2026: 2 @ 57.09; Aug. 30, 2026: 2 @ 58.26
Aug. 30, 2026transferTRFMAIN → EAST 22 warehouse transfer, no cost effect
Aug. 30, 2026receiptPO-001761MAIN 100 58.265,825.721025,939.90
Aug. 14, 2026issueSO-260814-646MAIN 37 57.09-2,112.412114.18 June 16, 2026: 35 @ 57.09; Aug. 3, 2026: 2 @ 57.09
Aug. 11, 2026adjustmentCycle countMAIN -2 57.09-114.18392,226.60 June 16, 2026: 2 @ 57.09
Aug. 5, 2026issueSO-260805-421MAIN 6 57.09-342.55412,340.78 June 16, 2026: 6 @ 57.09
Aug. 3, 2026returnRMAMAIN 4 57.09228.37472,683.33
July 19, 2026issueSO-260719-757MAIN 8 57.09-456.74432,454.96 June 16, 2026: 8 @ 57.09
July 8, 2026issueSO-260708-326MAIN 22 57.09-1,256.03512,911.70 June 16, 2026: 22 @ 57.09
July 3, 2026issueSO-260703-766MAIN 19 57.09-1,084.75734,167.73 June 16, 2026: 19 @ 57.09
June 28, 2026issueSO-260628-357MAIN 6 57.09-342.55925,252.48 June 16, 2026: 6 @ 57.09
June 20, 2026issueSO-260620-743MAIN 1 57.09-57.09985,595.04 June 16, 2026: 1 @ 57.09
June 19, 2026issueSO-260619-552MAIN 1 57.09-57.09995,652.13 June 16, 2026: 1 @ 57.09
June 16, 2026receiptPO-001576MAIN 100 57.095,709.221005,709.22
June 15, 2026issueSO-260615-647MAIN 1 58.36-58.3600.00 March 28, 2026: 1 @ 58.36
June 3, 2026issueSO-260603-551MAIN 17 58.36-992.15158.36 March 28, 2026: 17 @ 58.36
June 2, 2026issueSO-260602-433MAIN 8 58.36-466.89181,050.51 March 28, 2026: 8 @ 58.36
June 1, 2026issueSO-260601-283MAIN 9 58.36-525.25261,517.40 March 28, 2026: 9 @ 58.36
June 1, 2026issueSO-260601-283EAST 3 58.36-175.08352,042.66 March 28, 2026: 3 @ 58.36
May 30, 2026issueSO-260530-820MAIN 3 58.36-175.08382,217.74 March 28, 2026: 3 @ 58.36
May 24, 2026issueSO-260524-972EAST 3 58.36-175.08412,392.83 March 28, 2026: 3 @ 58.36
May 20, 2026issueSO-260520-197MAIN 5 58.36-291.81442,567.91 March 28, 2026: 5 @ 58.36
May 16, 2026issueSO-260516-823MAIN 2 58.36-116.72492,859.72 March 28, 2026: 2 @ 58.36
May 9, 2026issueSO-260509-659MAIN 14 58.36-817.06512,976.44 March 28, 2026: 14 @ 58.36
April 29, 2026issueSO-260429-768MAIN 12 58.36-700.34653,793.50 March 28, 2026: 12 @ 58.36
April 24, 2026issueSO-260424-949MAIN 27 58.44-1,577.81774,493.84 Feb. 20, 2026: 4 @ 58.87; March 28, 2026: 23 @ 58.36
April 23, 2026issueSO-260423-874MAIN 2 58.87-117.741046,071.65 Feb. 20, 2026: 2 @ 58.87
April 10, 2026issueSO-260410-387MAIN 9 58.87-529.851066,189.39 Feb. 20, 2026: 9 @ 58.87
April 2, 2026issueSO-260402-986MAIN 3 58.87-176.621156,719.24 Feb. 20, 2026: 3 @ 58.87
March 28, 2026receiptPO-001362MAIN 100 58.365,836.161186,895.86
March 25, 2026issueSO-260325-806MAIN 14 58.87-824.21181,059.70 Feb. 20, 2026: 14 @ 58.87
March 23, 2026issueSO-260323-363MAIN 4 58.87-235.49321,883.91 Feb. 20, 2026: 4 @ 58.87
March 19, 2026issueSO-260319-122EAST 14 58.87-824.21362,119.40 Feb. 20, 2026: 14 @ 58.87
March 5, 2026issueSO-260305-700MAIN 30 58.87-1,766.17502,943.62 Feb. 20, 2026: 30 @ 58.87
Feb. 21, 2026issueSO-260221-890MAIN 1 58.87-58.87804,709.78 Feb. 20, 2026: 1 @ 58.87
Feb. 20, 2026issueSO-260220-972MAIN 19 58.87-1,118.57814,768.66 Feb. 20, 2026: 19 @ 58.87
Feb. 20, 2026transferTRFMAIN → EAST 20 warehouse transfer, no cost effect
Feb. 20, 2026receiptPO-001245MAIN 100 58.875,887.231005,887.23
Feb. 5, 2026issueSO-260205-193MAIN 36 56.64-2,038.9200.00 Dec. 27, 2025: 36 @ 56.64
Jan. 28, 2026issueSO-260128-888MAIN 4 56.64-226.55362,038.92 Dec. 27, 2025: 4 @ 56.64
Jan. 13, 2026issueSO-260113-283MAIN 19 56.64-1,076.10402,265.47 Dec. 27, 2025: 19 @ 56.64
Jan. 4, 2026issueSO-260104-725MAIN 28 56.64-1,585.83593,341.57 Dec. 27, 2025: 28 @ 56.64
Jan. 4, 2026issueSO-260104-725EAST 30 56.35-1,690.42874,927.39 Oct. 16, 2025: 17 @ 56.13; Dec. 27, 2025: 13 @ 56.64
Dec. 29, 2025issueSO-251229-125MAIN 7 56.13-392.881176,617.82 Oct. 16, 2025: 7 @ 56.13
Dec. 27, 2025transferTRFMAIN → EAST 30 warehouse transfer, no cost effect
Dec. 27, 2025receiptPO-001094MAIN 100 56.645,663.671247,010.70
Dec. 22, 2025issueSO-251222-709MAIN 3 56.13-168.38241,347.03 Oct. 16, 2025: 3 @ 56.13
Dec. 12, 2025issueSO-251212-374MAIN 2 56.13-112.25271,515.41 Oct. 16, 2025: 2 @ 56.13
Dec. 11, 2025issueSO-251211-592MAIN 18 56.13-1,010.27291,627.66 Oct. 16, 2025: 18 @ 56.13
Dec. 6, 2025issueSO-251206-538MAIN 3 56.13-168.38472,637.93 Oct. 16, 2025: 3 @ 56.13
Dec. 3, 2025issueSO-251203-961MAIN 7 56.13-392.88502,806.31 Oct. 16, 2025: 7 @ 56.13
Nov. 24, 2025issueSO-251124-770MAIN 3 56.13-168.38573,199.19 Oct. 16, 2025: 3 @ 56.13
Nov. 18, 2025issueSO-251118-594MAIN 39 56.13-2,188.92603,367.57 Oct. 16, 2025: 39 @ 56.13
Nov. 16, 2025issueSO-251116-381MAIN 5 57.01-285.03995,556.49 Aug. 27, 2025: 4 @ 57.23; Oct. 16, 2025: 1 @ 56.13
Oct. 16, 2025receiptPO-000923MAIN 100 56.135,612.621045,841.53
Oct. 6, 2025issueSO-251006-945MAIN 1 57.23-57.234228.91 Aug. 27, 2025: 1 @ 57.23
Oct. 1, 2025issueSO-251001-970MAIN 50 57.23-2,861.335286.13 Aug. 27, 2025: 50 @ 57.23
Sept. 29, 2025issueSO-250929-408MAIN 11 57.23-629.49553,147.46 Aug. 27, 2025: 11 @ 57.23
Sept. 16, 2025issueSO-250916-582MAIN 20 57.23-1,144.53663,776.96 Aug. 27, 2025: 20 @ 57.23
Sept. 10, 2025issueSO-250910-827MAIN 11 57.23-629.49864,921.49 Aug. 27, 2025: 11 @ 57.23
Sept. 7, 2025issueSO-250907-149MAIN 3 57.23-171.68975,550.98 Aug. 27, 2025: 3 @ 57.23
Aug. 27, 2025receiptPO-000797MAIN 100 57.235,722.661005,722.66
Aug. 19, 2025issueSO-250819-222MAIN 10 56.20-561.9500.00 June 12, 2025: 10 @ 56.20
Aug. 10, 2025issueSO-250810-138MAIN 25 56.20-1,404.8810561.95 June 12, 2025: 25 @ 56.20
July 30, 2025issueSO-250730-750MAIN 2 56.20-112.39351,966.84 June 12, 2025: 2 @ 56.20
July 27, 2025issueSO-250727-188MAIN 19 56.20-1,067.71372,079.23 June 12, 2025: 19 @ 56.20
July 22, 2025issueSO-250722-751MAIN 9 56.20-505.76563,146.94 June 12, 2025: 9 @ 56.20
July 16, 2025issueSO-250716-521MAIN 2 56.20-112.39653,652.70 June 12, 2025: 2 @ 56.20
July 9, 2025issueSO-250709-577MAIN 4 56.20-224.78673,765.09 June 12, 2025: 4 @ 56.20
July 7, 2025issueSO-250707-454MAIN 2 56.20-112.39713,989.87 June 12, 2025: 2 @ 56.20
July 3, 2025issueSO-250703-823MAIN 8 56.20-449.56734,102.26 June 12, 2025: 8 @ 56.20
June 13, 2025issueSO-250613-543MAIN 21 56.22-1,180.61814,551.83 March 25, 2025: 2 @ 56.45; June 12, 2025: 19 @ 56.20
June 12, 2025issueSO-250612-265MAIN 31 56.45-1,749.871025,732.44 March 25, 2025: 31 @ 56.45
June 12, 2025receiptPO-000626MAIN 100 56.205,619.541337,482.31
May 30, 2025issueSO-250530-513MAIN 10 56.45-564.48331,862.77 March 25, 2025: 10 @ 56.45
May 29, 2025issueSO-250529-392MAIN 15 56.45-846.71432,427.24 March 25, 2025: 15 @ 56.45
May 22, 2025issueSO-250522-404MAIN 3 56.45-169.34583,273.96 March 25, 2025: 3 @ 56.45
May 15, 2025issueSO-250515-120MAIN 1 56.45-56.45613,443.30 March 25, 2025: 1 @ 56.45
May 8, 2025adjustmentCycle countMAIN -2 56.45-112.90623,499.74 March 25, 2025: 2 @ 56.45
April 30, 2025issueSO-250430-880MAIN 3 56.45-169.34643,612.64 March 25, 2025: 3 @ 56.45
April 27, 2025issueSO-250427-282MAIN 5 56.45-282.24673,781.98 March 25, 2025: 5 @ 56.45
April 27, 2025issueSO-250427-282EAST 1 56.45-56.45724,064.22 March 25, 2025: 1 @ 56.45
April 21, 2025issueSO-250421-427MAIN 6 56.45-338.68734,120.67 March 25, 2025: 6 @ 56.45
April 11, 2025issueSO-250411-352MAIN 6 56.45-338.68794,459.35 March 25, 2025: 6 @ 56.45
April 1, 2025issueSO-250401-813EAST 20 56.32-1,126.50854,798.04 Jan. 19, 2025: 5 @ 55.96; March 25, 2025: 15 @ 56.45
March 29, 2025issueSO-250329-424MAIN 1 55.96-55.961055,924.54 Jan. 19, 2025: 1 @ 55.96
March 28, 2025issueSO-250328-530MAIN 23 55.96-1,287.021065,980.49 Jan. 19, 2025: 23 @ 55.96
March 25, 2025receiptPO-000376MAIN 100 56.455,644.751297,267.51
March 17, 2025issueSO-250317-860MAIN 1 55.96-55.96291,622.76 Jan. 19, 2025: 1 @ 55.96
March 16, 2025issueSO-250316-842EAST 12 55.96-671.49301,678.72 Jan. 19, 2025: 12 @ 55.96
March 9, 2025issueSO-250309-482MAIN 6 55.96-335.74422,350.21 Jan. 19, 2025: 6 @ 55.96
March 4, 2025issueSO-250304-367MAIN 2 55.96-111.91482,685.96 Jan. 19, 2025: 2 @ 55.96
Feb. 20, 2025issueSO-250220-177MAIN 1 55.96-55.96502,797.87 Jan. 19, 2025: 1 @ 55.96
Feb. 4, 2025issueSO-250204-394MAIN 48 55.96-2,685.96512,853.83 Jan. 19, 2025: 48 @ 55.96
Jan. 26, 2025issueSO-250126-254MAIN 5 56.16-280.78995,539.78 Dec. 2, 2024: 4 @ 56.20; Jan. 19, 2025: 1 @ 55.96
Jan. 19, 2025issueSO-250119-120EAST 15 56.20-843.071045,820.56 Dec. 2, 2024: 15 @ 56.20
Jan. 19, 2025transferTRFMAIN → EAST 29 warehouse transfer, no cost effect
Jan. 19, 2025receiptPO-000197MAIN 100 55.965,595.741196,663.63
Jan. 14, 2025issueSO-250114-949EAST 1 56.20-56.20191,067.89 Dec. 2, 2024: 1 @ 56.20
Jan. 10, 2025issueSO-250110-276EAST 9 56.20-505.84201,124.09 Dec. 2, 2024: 9 @ 56.20
Jan. 3, 2025issueSO-250103-395EAST 4 56.20-224.82291,629.93 Dec. 2, 2024: 4 @ 56.20
Jan. 3, 2025issueSO-250103-395MAIN 17 56.20-955.48331,854.75 Dec. 2, 2024: 17 @ 56.20
Dec. 21, 2024issueSO-241221-475MAIN 30 56.20-1,686.14502,810.22 Dec. 2, 2024: 30 @ 56.20
Dec. 13, 2024issueSO-241213-784MAIN 7 56.20-393.43804,496.36 Dec. 2, 2024: 7 @ 56.20
Dec. 12, 2024issueSO-241212-326MAIN 4 56.20-224.82874,889.79 Dec. 2, 2024: 4 @ 56.20
Dec. 2, 2024issueSO-241202-887MAIN 9 56.20-505.84915,114.61 Dec. 2, 2024: 9 @ 56.20
Dec. 2, 2024transferTRFMAIN → EAST 33 warehouse transfer, no cost effect
Dec. 2, 2024receiptPO-000074MAIN 100 56.205,620.451005,620.45
Nov. 21, 2024issueSO-241121-745EAST 5 56.28-281.3900.00 Oct. 1, 2024: 5 @ 56.28
Nov. 18, 2024issueSO-241118-110EAST 5 56.28-281.395281.39 Oct. 1, 2024: 5 @ 56.28
Nov. 18, 2024issueSO-241118-110MAIN 22 56.28-1,238.1210562.78 Oct. 1, 2024: 22 @ 56.28
Nov. 16, 2024issueSO-241116-969EAST 4 56.28-225.11321,800.90 Oct. 1, 2024: 4 @ 56.28
Nov. 9, 2024issueSO-241109-329MAIN 6 56.28-337.67362,026.01 Oct. 1, 2024: 6 @ 56.28
Nov. 2, 2024issueSO-241102-349MAIN 1 56.28-56.28422,363.68 Oct. 1, 2024: 1 @ 56.28
Oct. 21, 2024issueSO-241021-444EAST 20 56.28-1,125.56432,419.95 Oct. 1, 2024: 20 @ 56.28
Oct. 14, 2024issueSO-241014-368MAIN 28 56.28-1,575.78633,545.51 Oct. 1, 2024: 28 @ 56.28
Oct. 9, 2024issueSO-241009-936MAIN 9 56.28-506.50915,121.30 Oct. 1, 2024: 9 @ 56.28
Oct. 1, 2024transferTRFMAIN → EAST 34 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000002MAIN 100 56.285,627.801005,627.80