stocksense

Items / CAB-0040

Cat6 Cable Eco CAB-0040 · Cables & Wires · Conduit & Cable Co

On hand (COIL)60MAIN 60
Value (FIFO)4,524.39avg 75.41
ClassAX / FCV 0.19
Turnover27.7xlast issue 4 days ago
Days of cover19lead time 14d

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

Demand and forecast

Monthly demand and forecast for CAB-00400.036.072.1108144Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 91.0Nov 24: 89.0Dec 24: 93.0Jan 25: 116.0Feb 25: 93.0Mar 25: 83.0Apr 25: 101.0May 25: 131.0Jun 25: 77.0Jul 25: 93.0Aug 25: 86.0Sep 25: 66.0Oct 25: 82.0Nov 25: 99.0Dec 25: 98.0Jan 26: 102.0Feb 26: 83.0Mar 26: 79.0Apr 26: 114.0May 26: 128.0Jun 26: 57.0Jul 26: 92.0Aug 26: 108.0Sep 26: 98.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.437595.00 / 30.43753.121
Daily demand sdmonthly sd / sqrt(30.4375)17.62 / 5.5173.193
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 * 3.193^2 + 3.121^2 * 3.1^2)31.6
Reorder pointd * LT + safety stock3.121 * 14.0 + 31.675.4
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days75.4
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1139/yr, S = 45.00, h = 20%, price = 75.2982.5
Inventory positionon hand + on order60 + 060

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

From qtyUnit costOrder qtyAnnual costFeasible
075.298387,014yes (chosen if cheapest)

MOQ 200, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 12, 202660 / 20075.414,524.39

Movement ledger 136 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 12, 2026issueSO-261012-270MAIN 12 75.41-904.88604,524.39 Sept. 12, 2026: 12 @ 75.41
Oct. 11, 2026issueSO-261011-452MAIN 48 75.41-3,619.51725,429.27 Sept. 12, 2026: 48 @ 75.41
Oct. 5, 2026issueSO-261005-312MAIN 11 75.41-829.471209,048.78 Sept. 12, 2026: 11 @ 75.41
Oct. 3, 2026issueSO-261003-753MAIN 8 75.41-603.251319,878.25 Sept. 12, 2026: 8 @ 75.41
Sept. 30, 2026issueSO-260930-266MAIN 9 75.41-678.6613910,481.50 Sept. 12, 2026: 9 @ 75.41
Sept. 27, 2026issueSO-260927-188MAIN 16 75.41-1,206.5014811,160.16 Sept. 12, 2026: 16 @ 75.41
Sept. 21, 2026issueSO-260921-877MAIN 73 74.81-5,461.0316412,366.67 June 15, 2026: 36 @ 74.25; July 2, 2026: 1 @ 73.56; Sept. 12, 2026: 36 @ 75.41
Sept. 12, 2026receiptPO-001793MAIN 200 75.4115,081.3023717,827.70
Aug. 29, 2026issueSO-260829-546MAIN 39 74.25-2,895.57372,746.40 June 15, 2026: 39 @ 74.25
Aug. 27, 2026issueSO-260827-509MAIN 17 74.25-1,262.17765,641.97 June 15, 2026: 17 @ 74.25
Aug. 15, 2026issueSO-260815-654MAIN 23 74.25-1,707.64936,904.14 June 15, 2026: 23 @ 74.25
Aug. 14, 2026issueSO-260814-332MAIN 29 74.25-2,153.121168,611.78 June 15, 2026: 29 @ 74.25
July 26, 2026issueSO-260726-493MAIN 18 74.25-1,336.4214510,764.90 June 15, 2026: 18 @ 74.25
July 12, 2026issueSO-260712-879MAIN 10 74.25-742.4516312,101.32 June 15, 2026: 10 @ 74.25
July 8, 2026issueSO-260708-248MAIN 51 73.94-3,770.8217312,843.77 April 19, 2026: 4 @ 73.56; June 10, 2026: 19 @ 73.56; June 15, 2026: 28 @ 74.25
July 7, 2026issueSO-260707-217MAIN 14 73.56-1,029.8822416,614.59 April 19, 2026: 14 @ 73.56
July 2, 2026returnRMAMAIN 1 73.5673.5623817,644.47
June 21, 2026issueSO-260621-159MAIN 3 73.56-220.6923717,570.91 April 19, 2026: 3 @ 73.56
June 19, 2026issueSO-260619-562MAIN 5 73.56-367.8224017,791.60 April 19, 2026: 5 @ 73.56
June 15, 2026receiptPO-001574MAIN 200 74.2514,849.0824518,159.42
June 14, 2026issueSO-260614-311MAIN 3 73.56-220.69453,310.34 April 19, 2026: 3 @ 73.56
June 10, 2026returnRMAMAIN 19 73.561,397.70483,531.02
June 10, 2026issueSO-260610-330MAIN 22 73.56-1,618.39292,133.33 April 19, 2026: 22 @ 73.56
June 9, 2026issueSO-260609-367MAIN 1 73.56-73.56513,751.71 April 19, 2026: 1 @ 73.56
June 2, 2026issueSO-260602-487MAIN 20 73.56-1,471.26523,825.28 April 19, 2026: 20 @ 73.56
June 1, 2026issueSO-260601-909MAIN 22 73.56-1,618.39725,296.54 April 19, 2026: 22 @ 73.56
May 25, 2026issueSO-260525-964MAIN 38 73.56-2,795.39946,914.92 April 19, 2026: 38 @ 73.56
May 11, 2026issueSO-260511-374MAIN 73 73.48-5,363.811329,710.32 Feb. 27, 2026: 5 @ 72.30; April 19, 2026: 68 @ 73.56
May 9, 2026issueSO-260509-925MAIN 1 72.30-72.3020515,074.12 Feb. 27, 2026: 1 @ 72.30
May 4, 2026issueSO-260504-180MAIN 16 72.30-1,156.8720615,146.43 Feb. 27, 2026: 16 @ 72.30
April 19, 2026receiptPO-001422MAIN 200 73.5614,712.6022216,303.29
April 9, 2026issueSO-260409-480MAIN 2 72.30-144.61221,590.69 Feb. 27, 2026: 2 @ 72.30
April 3, 2026issueSO-260403-534MAIN 112 72.30-8,098.08241,735.30 Feb. 27, 2026: 112 @ 72.30
March 30, 2026issueSO-260330-210MAIN 23 72.30-1,663.001369,833.38 Feb. 27, 2026: 23 @ 72.30
March 29, 2026issueSO-260329-967MAIN 10 72.30-723.0415911,496.38 Feb. 27, 2026: 10 @ 72.30
March 29, 2026issueSO-260329-967EAST 14 72.30-1,012.2616912,219.43 Feb. 27, 2026: 14 @ 72.30
March 24, 2026issueSO-260324-346EAST 1 72.30-72.3018313,231.69 Feb. 27, 2026: 1 @ 72.30
March 23, 2026issueSO-260323-165MAIN 13 72.30-939.9618413,303.99 Feb. 27, 2026: 13 @ 72.30
March 9, 2026issueSO-260309-193MAIN 7 72.13-504.9419714,243.95 Jan. 3, 2026: 4 @ 72.01; Feb. 27, 2026: 3 @ 72.30
March 8, 2026issueSO-260308-839MAIN 1 72.01-72.0120414,748.89 Jan. 3, 2026: 1 @ 72.01
March 6, 2026issueSO-260306-836MAIN 10 72.01-720.0720514,820.89 Jan. 3, 2026: 10 @ 72.01
Feb. 27, 2026receiptPO-001265MAIN 200 72.3014,460.8621515,540.96
Feb. 24, 2026issueSO-260224-391EAST 17 72.01-1,224.12151,080.10 Jan. 3, 2026: 17 @ 72.01
Feb. 15, 2026issueSO-260215-286EAST 12 72.01-864.08322,304.22 Jan. 3, 2026: 12 @ 72.01
Feb. 15, 2026issueSO-260215-286MAIN 48 72.01-3,456.33443,168.30 Jan. 3, 2026: 48 @ 72.01
Feb. 11, 2026issueSO-260211-611MAIN 6 72.01-432.04926,624.63 Jan. 3, 2026: 6 @ 72.01
Jan. 27, 2026issueSO-260127-559MAIN 9 72.01-648.06987,056.68 Jan. 3, 2026: 9 @ 72.01
Jan. 26, 2026issueSO-260126-249MAIN 1 72.01-72.011077,704.74 Jan. 3, 2026: 1 @ 72.01
Jan. 21, 2026issueSO-260121-702MAIN 11 72.01-792.081087,776.75 Jan. 3, 2026: 11 @ 72.01
Jan. 14, 2026issueSO-260114-486EAST 24 72.01-1,728.171198,568.82 Jan. 3, 2026: 24 @ 72.01
Jan. 12, 2026issueSO-260112-375MAIN 41 72.01-2,952.2814310,296.99 Jan. 3, 2026: 41 @ 72.01
Jan. 5, 2026issueSO-260105-389MAIN 16 72.01-1,152.1118413,249.27 Jan. 3, 2026: 16 @ 72.01
Jan. 3, 2026transferTRFMAIN → EAST 68 warehouse transfer, no cost effect
Jan. 3, 2026receiptPO-001115MAIN 200 72.0114,401.3820014,401.38
Dec. 21, 2025issueSO-251221-241EAST 9 71.42-642.8200.00 Oct. 25, 2025: 9 @ 71.42
Dec. 21, 2025issueSO-251221-241MAIN 63 71.42-4,499.769642.82 Oct. 25, 2025: 63 @ 71.42
Dec. 20, 2025issueSO-251220-879MAIN 13 71.42-928.52725,142.58 Oct. 25, 2025: 13 @ 71.42
Dec. 5, 2025issueSO-251205-142MAIN 13 71.42-928.52856,071.10 Oct. 25, 2025: 13 @ 71.42
Nov. 30, 2025issueSO-251130-936MAIN 26 71.42-1,857.04986,999.62 Oct. 25, 2025: 26 @ 71.42
Nov. 26, 2025issueSO-251126-624EAST 7 71.42-499.971248,856.66 Oct. 25, 2025: 7 @ 71.42
Nov. 25, 2025issueSO-251125-750EAST 9 71.42-642.821319,356.64 Oct. 25, 2025: 9 @ 71.42
Nov. 22, 2025issueSO-251122-457MAIN 5 71.42-357.121409,999.46 Oct. 25, 2025: 5 @ 71.42
Nov. 13, 2025issueSO-251113-112EAST 14 71.42-999.9514510,356.58 Oct. 25, 2025: 14 @ 71.42
Nov. 12, 2025issueSO-251112-762MAIN 8 71.42-571.4015911,356.53 Oct. 25, 2025: 8 @ 71.42
Nov. 11, 2025issueSO-251111-536MAIN 30 71.42-2,142.7416711,927.92 Oct. 25, 2025: 30 @ 71.42
Oct. 28, 2025issueSO-251028-542EAST 15 71.35-1,070.2419714,070.67 July 25, 2025: 1 @ 71.33; Oct. 17, 2025: 11 @ 71.33; Oct. 25, 2025: 3 @ 71.42
Oct. 25, 2025transferTRFMAIN → EAST 54 warehouse transfer, no cost effect
Oct. 25, 2025receiptPO-000951MAIN 200 71.4214,284.9421215,140.90
Oct. 21, 2025issueSO-251021-366MAIN 24 71.33-1,711.9212855.96 July 25, 2025: 24 @ 71.33
Oct. 17, 2025returnRMAMAIN 11 71.33784.63362,567.88
Oct. 14, 2025issueSO-251014-714MAIN 22 71.33-1,569.26251,783.25 July 25, 2025: 22 @ 71.33
Oct. 12, 2025issueSO-251012-175MAIN 4 71.33-285.32473,352.51 July 25, 2025: 4 @ 71.33
Oct. 1, 2025issueSO-251001-876MAIN 28 71.33-1,997.24513,637.84 July 25, 2025: 28 @ 71.33
Sept. 28, 2025issueSO-250928-252MAIN 21 71.33-1,497.93795,635.08 July 25, 2025: 21 @ 71.33
Sept. 24, 2025issueSO-250924-119MAIN 5 71.33-356.651007,133.01 July 25, 2025: 5 @ 71.33
Sept. 22, 2025issueSO-250922-370MAIN 33 71.33-2,353.891057,489.66 July 25, 2025: 33 @ 71.33
Sept. 9, 2025issueSO-250909-352MAIN 7 71.33-499.311389,843.55 July 25, 2025: 7 @ 71.33
Aug. 14, 2025issueSO-250814-297MAIN 44 71.33-3,138.5214510,342.86 July 25, 2025: 44 @ 71.33
Aug. 3, 2025issueSO-250803-115MAIN 42 70.78-2,972.6518913,481.39 May 21, 2025: 27 @ 70.58; June 19, 2025: 4 @ 70.58; July 25, 2025: 11 @ 71.33
July 25, 2025receiptPO-000731MAIN 200 71.3314,266.0223116,454.04
July 18, 2025issueSO-250718-996MAIN 4 70.58-282.32312,188.02 May 21, 2025: 4 @ 70.58
July 15, 2025issueSO-250715-129MAIN 37 70.58-2,611.50352,470.34 May 21, 2025: 37 @ 70.58
July 11, 2025issueSO-250711-248MAIN 2 70.58-141.16725,081.85 May 21, 2025: 2 @ 70.58
July 10, 2025issueSO-250710-470MAIN 8 70.58-564.65745,223.01 May 21, 2025: 8 @ 70.58
July 7, 2025issueSO-250707-208MAIN 42 70.58-2,964.41825,787.66 May 21, 2025: 42 @ 70.58
June 29, 2025issueSO-250629-320MAIN 2 70.58-141.161248,752.07 May 21, 2025: 2 @ 70.58
June 20, 2025issueSO-250620-532MAIN 29 70.58-2,046.851268,893.23 May 21, 2025: 29 @ 70.58
June 19, 2025returnRMAMAIN 4 70.58282.3215510,940.09
June 15, 2025issueSO-250615-244MAIN 19 70.58-1,341.0415110,657.76 May 21, 2025: 19 @ 70.58
June 14, 2025issueSO-250614-566MAIN 2 70.58-141.1617011,998.80 May 21, 2025: 2 @ 70.58
June 13, 2025issueSO-250613-737MAIN 9 70.58-635.2317212,139.97 May 21, 2025: 9 @ 70.58
June 1, 2025issueSO-250601-460MAIN 20 70.64-1,412.7118112,775.20 March 20, 2025: 1 @ 71.66; May 21, 2025: 19 @ 70.58
May 29, 2025issueSO-250529-418MAIN 32 71.66-2,293.2420114,187.90 March 20, 2025: 32 @ 71.66
May 22, 2025issueSO-250522-990MAIN 17 71.66-1,218.2823316,481.14 March 20, 2025: 17 @ 71.66
May 21, 2025receiptPO-000554MAIN 200 70.5814,116.2425017,699.42
May 17, 2025issueSO-250517-998MAIN 1 71.66-71.66503,583.18 March 20, 2025: 1 @ 71.66
May 8, 2025issueSO-250508-978MAIN 81 71.66-5,804.75513,654.84 March 20, 2025: 81 @ 71.66
April 19, 2025issueSO-250419-244MAIN 2 71.66-143.331329,459.60 March 20, 2025: 2 @ 71.66
April 13, 2025issueSO-250413-818MAIN 37 71.66-2,651.551349,602.92 March 20, 2025: 37 @ 71.66
April 9, 2025issueSO-250409-789MAIN 41 71.79-2,943.2117112,254.48 Jan. 29, 2025: 5 @ 72.08; Feb. 25, 2025: 7 @ 72.08; March 20, 2025: 29 @ 71.66
April 4, 2025issueSO-250404-548MAIN 21 72.08-1,513.6921215,197.69 Jan. 29, 2025: 21 @ 72.08
March 30, 2025issueSO-250330-563MAIN 4 72.08-288.3223316,711.38 Jan. 29, 2025: 4 @ 72.08
March 20, 2025receiptPO-000357MAIN 200 71.6614,332.7223716,999.70
March 9, 2025issueSO-250309-112MAIN 23 72.08-1,657.85372,666.98 Jan. 29, 2025: 23 @ 72.08
March 8, 2025issueSO-250308-174MAIN 42 72.08-3,027.39604,324.84 Jan. 29, 2025: 42 @ 72.08
March 1, 2025issueSO-250301-782MAIN 14 72.08-1,009.131027,352.22 Jan. 29, 2025: 14 @ 72.08
Feb. 27, 2025issueSO-250227-528MAIN 8 72.08-576.641168,361.35 Jan. 29, 2025: 8 @ 72.08
Feb. 25, 2025returnRMAMAIN 7 72.08504.561248,937.99
Feb. 18, 2025issueSO-250218-258MAIN 11 72.08-792.891178,433.43 Jan. 29, 2025: 11 @ 72.08
Feb. 12, 2025issueSO-250212-536MAIN 17 72.08-1,225.371289,226.32 Jan. 29, 2025: 17 @ 72.08
Feb. 10, 2025issueSO-250210-608MAIN 30 72.08-2,162.4214510,451.69 Jan. 29, 2025: 30 @ 72.08
Feb. 9, 2025issueSO-250209-305MAIN 19 72.08-1,369.5317512,614.10 Jan. 29, 2025: 19 @ 72.08
Feb. 7, 2025adjustmentCycle countMAIN -2 72.08-144.1619413,983.64 Jan. 29, 2025: 2 @ 72.08
Feb. 6, 2025issueSO-250206-624MAIN 15 71.35-1,070.2919614,127.80 Nov. 19, 2024: 10 @ 71.09; Dec. 21, 2024: 1 @ 71.09; Jan. 29, 2025: 4 @ 72.08
Jan. 31, 2025issueSO-250131-214MAIN 6 71.09-426.5321115,198.08 Nov. 19, 2024: 6 @ 71.09
Jan. 29, 2025receiptPO-000226MAIN 200 72.0814,416.1221715,624.61
Jan. 14, 2025issueSO-250114-151MAIN 55 71.09-3,909.82171,208.49 Nov. 19, 2024: 55 @ 71.09
Jan. 12, 2025issueSO-250112-694MAIN 2 71.09-142.18725,118.31 Nov. 19, 2024: 2 @ 71.09
Jan. 8, 2025issueSO-250108-173MAIN 22 71.09-1,563.93745,260.49 Nov. 19, 2024: 22 @ 71.09
Jan. 6, 2025issueSO-250106-698MAIN 1 71.09-71.09966,824.42 Nov. 19, 2024: 1 @ 71.09
Jan. 5, 2025issueSO-250105-784MAIN 29 71.09-2,061.54976,895.51 Nov. 19, 2024: 29 @ 71.09
Jan. 4, 2025issueSO-250104-566MAIN 1 71.09-71.091268,957.05 Nov. 19, 2024: 1 @ 71.09
Dec. 31, 2024issueSO-241231-536MAIN 31 71.09-2,203.721279,028.14 Nov. 19, 2024: 31 @ 71.09
Dec. 30, 2024issueSO-241230-422MAIN 5 71.09-355.4415811,231.86 Nov. 19, 2024: 5 @ 71.09
Dec. 21, 2024returnRMAMAIN 1 71.0971.0916311,587.30
Dec. 21, 2024issueSO-241221-953MAIN 1 71.09-71.0916211,516.21 Nov. 19, 2024: 1 @ 71.09
Dec. 17, 2024issueSO-241217-247MAIN 56 71.24-3,989.2316311,587.30 Oct. 1, 2024: 19 @ 71.53; Nov. 19, 2024: 37 @ 71.09
Dec. 6, 2024issueSO-241206-708MAIN 1 71.53-71.5321915,576.52 Oct. 1, 2024: 1 @ 71.53
Nov. 30, 2024issueSO-241130-636MAIN 16 71.53-1,144.4122015,648.05 Oct. 1, 2024: 16 @ 71.53
Nov. 19, 2024receiptPO-000042MAIN 200 71.0914,217.5423616,792.46
Nov. 11, 2024issueSO-241111-180MAIN 41 71.53-2,932.55362,574.92 Oct. 1, 2024: 41 @ 71.53
Nov. 2, 2024issueSO-241102-611MAIN 32 71.53-2,288.82775,507.46 Oct. 1, 2024: 32 @ 71.53
Oct. 26, 2024issueSO-241026-545MAIN 22 71.53-1,573.561097,796.28 Oct. 1, 2024: 22 @ 71.53
Oct. 10, 2024issueSO-241010-103MAIN 61 71.53-4,363.061319,369.84 Oct. 1, 2024: 61 @ 71.53
Oct. 1, 2024issueSO-241001-412MAIN 8 71.53-572.2019213,732.90 Oct. 1, 2024: 8 @ 71.53
Oct. 1, 2024receiptPO-000002MAIN 200 71.5314,305.1020014,305.10