stocksense

Items / CON-0019

Cable Tie 200mm Elite CON-0019 · Conduit & Fittings · Conduit & Cable Co

On hand (EA)187MAIN 187
Value (FIFO)2,596.85avg 13.89
ClassCX / FCV 0.25
Turnover2.9xlast issue 5 days ago
Days of cover136lead time 14d

Demand and forecast

Monthly demand and forecast for CON-00190.017.134.151.268.2Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 37.0Nov 24: 44.0Dec 24: 38.0Jan 25: 53.0Feb 25: 35.0Mar 25: 48.0Apr 25: 56.0May 25: 32.0Jun 25: 34.0Jul 25: 43.0Aug 25: 37.0Sep 25: 51.0Oct 25: 49.0Nov 25: 36.0Dec 25: 29.0Jan 26: 31.0Feb 26: 50.0Mar 26: 51.0Apr 26: 46.0May 26: 51.0Jun 26: 30.0Jul 26: 34.0Aug 26: 62.0Sep 26: 34.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.437541.92 / 30.43751.377
Daily demand sdmonthly sd / sqrt(30.4375)10.36 / 5.5171.879
Service level / zz = Phi^-1(service level)Phi^-1(0.900)1.282
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.282 * sqrt(14.0 * 1.879^2 + 1.377^2 * 3.1^2)10.6
Reorder pointd * LT + safety stock1.377 * 14.0 + 10.629.9
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days29.9
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 503/yr, S = 45.00, h = 20%, price = 13.71128.4
Inventory positionon hand + on order187 + 0187

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

From qtyUnit costOrder qtyAnnual costFeasible
013.711287,244yes (chosen if cheapest)

MOQ 180, pack size 20, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
June 19, 20267 / 18013.2392.58
Oct. 15, 2026180 / 18013.912,504.27

Movement ledger 131 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026receiptPO-001881MAIN 180 13.912,504.271872,596.85
Oct. 11, 2026issueSO-261011-159MAIN 3 13.23-39.68792.58 June 19, 2026: 3 @ 13.23
Oct. 3, 2026issueSO-261003-498MAIN 4 13.23-52.9010132.25 June 19, 2026: 4 @ 13.23
Oct. 3, 2026issueSO-261003-498EAST 14 13.23-185.1514185.15 June 19, 2026: 14 @ 13.23
Oct. 2, 2026issueSO-261002-184EAST 37 13.23-489.3428370.31 June 19, 2026: 37 @ 13.23
Oct. 1, 2026issueSO-261001-702MAIN 3 13.23-39.6865859.64 June 19, 2026: 3 @ 13.23
Sept. 21, 2026issueSO-260921-790MAIN 14 13.23-185.1568899.32 June 19, 2026: 14 @ 13.23
Sept. 19, 2026issueSO-260919-495MAIN 20 13.23-264.51821,084.47 June 19, 2026: 20 @ 13.23
Aug. 30, 2026issueSO-260830-868MAIN 37 13.23-489.341021,348.98 June 19, 2026: 37 @ 13.23
Aug. 25, 2026issueSO-260825-142EAST 1 13.23-13.231391,838.32 June 19, 2026: 1 @ 13.23
Aug. 16, 2026issueSO-260816-483MAIN 24 13.23-317.411401,851.54 June 19, 2026: 24 @ 13.23
July 30, 2026issueSO-260730-758MAIN 2 13.23-26.451642,168.95 June 19, 2026: 2 @ 13.23
July 22, 2026issueSO-260722-307EAST 1 13.23-13.231662,195.40 June 19, 2026: 1 @ 13.23
July 18, 2026issueSO-260718-190MAIN 19 13.35-253.561672,208.63 March 5, 2026: 6 @ 13.61; June 19, 2026: 13 @ 13.23
July 14, 2026issueSO-260714-753MAIN 1 13.61-13.611862,462.19 March 5, 2026: 1 @ 13.61
July 11, 2026issueSO-260711-766MAIN 10 13.61-136.061872,475.79 March 5, 2026: 10 @ 13.61
July 5, 2026issueSO-260705-670EAST 1 13.61-13.611972,611.85 March 5, 2026: 1 @ 13.61
June 19, 2026transferTRFMAIN → EAST 54 warehouse transfer, no cost effect
June 19, 2026receiptPO-001586MAIN 180 13.232,380.551982,625.45
June 15, 2026issueSO-260615-758MAIN 9 13.61-122.4518244.90 March 5, 2026: 9 @ 13.61
June 4, 2026issueSO-260604-861MAIN 21 13.61-285.7227367.35 March 5, 2026: 21 @ 13.61
May 28, 2026issueSO-260528-146MAIN 2 13.61-27.2148653.06 March 5, 2026: 2 @ 13.61
May 24, 2026issueSO-260524-813MAIN 17 13.61-231.2950680.28 March 5, 2026: 17 @ 13.61
May 21, 2026issueSO-260521-282MAIN 1 13.61-13.6167911.57 March 5, 2026: 1 @ 13.61
May 13, 2026issueSO-260513-133MAIN 17 13.61-231.2968925.17 March 5, 2026: 17 @ 13.61
May 2, 2026issueSO-260502-674MAIN 14 13.61-190.48851,156.47 March 5, 2026: 14 @ 13.61
April 14, 2026issueSO-260414-771MAIN 1 13.61-13.61991,346.94 March 5, 2026: 1 @ 13.61
April 13, 2026issueSO-260413-616MAIN 19 13.61-258.501001,360.55 March 5, 2026: 19 @ 13.61
April 9, 2026issueSO-260409-103MAIN 13 13.61-176.871191,619.05 March 5, 2026: 13 @ 13.61
April 7, 2026issueSO-260407-276MAIN 5 13.61-68.031321,795.93 March 5, 2026: 5 @ 13.61
April 4, 2026issueSO-260404-210MAIN 8 13.61-108.841371,863.95 March 5, 2026: 8 @ 13.61
March 26, 2026issueSO-260326-293MAIN 9 13.61-122.451451,972.80 March 5, 2026: 9 @ 13.61
March 23, 2026issueSO-260323-222MAIN 16 13.61-217.691542,095.25 March 5, 2026: 16 @ 13.61
March 20, 2026issueSO-260320-652MAIN 3 13.61-40.821702,312.94 March 5, 2026: 3 @ 13.61
March 18, 2026issueSO-260318-149MAIN 2 13.61-27.211732,353.75 March 5, 2026: 2 @ 13.61
March 16, 2026adjustmentCycle countMAIN -1 13.61-13.611752,380.96 March 5, 2026: 1 @ 13.61
March 13, 2026issueSO-260313-145MAIN 12 13.24-158.901762,394.57 Oct. 16, 2025: 8 @ 13.06; March 5, 2026: 4 @ 13.61
March 9, 2026issueSO-260309-722MAIN 3 13.06-39.181882,553.47 Oct. 16, 2025: 3 @ 13.06
March 5, 2026receiptPO-001287MAIN 180 13.612,448.991912,592.64
March 2, 2026issueSO-260302-626MAIN 6 13.06-78.3611143.65 Oct. 16, 2025: 6 @ 13.06
Feb. 27, 2026issueSO-260227-358MAIN 5 13.06-65.3017222.01 Oct. 16, 2025: 5 @ 13.06
Feb. 20, 2026issueSO-260220-385MAIN 3 13.06-39.1822287.31 Oct. 16, 2025: 3 @ 13.06
Feb. 19, 2026issueSO-260219-410MAIN 1 13.06-13.0625326.48 Oct. 16, 2025: 1 @ 13.06
Feb. 12, 2026issueSO-260212-274MAIN 11 13.06-143.6526339.54 Oct. 16, 2025: 11 @ 13.06
Feb. 8, 2026issueSO-260208-665MAIN 24 13.06-313.4337483.20 Oct. 16, 2025: 24 @ 13.06
Feb. 6, 2026issueSO-260206-878MAIN 6 13.06-78.3661796.62 Oct. 16, 2025: 6 @ 13.06
Jan. 31, 2026issueSO-260131-652MAIN 6 13.06-78.3667874.98 Oct. 16, 2025: 6 @ 13.06
Jan. 30, 2026issueSO-260130-194MAIN 2 13.06-26.1273953.34 Oct. 16, 2025: 2 @ 13.06
Jan. 29, 2026issueSO-260129-283MAIN 2 13.06-26.1275979.46 Oct. 16, 2025: 2 @ 13.06
Jan. 18, 2026issueSO-260118-386MAIN 5 13.06-65.30771,005.57 Oct. 16, 2025: 5 @ 13.06
Jan. 13, 2026issueSO-260113-274MAIN 4 13.06-52.24821,070.87 Oct. 16, 2025: 4 @ 13.06
Jan. 11, 2026issueSO-260111-390MAIN 10 13.06-130.59861,123.11 Oct. 16, 2025: 10 @ 13.06
Jan. 5, 2026issueSO-260105-970MAIN 2 13.06-26.12961,253.70 Oct. 16, 2025: 2 @ 13.06
Dec. 31, 2025issueSO-251231-547MAIN 6 13.06-78.36981,279.82 Oct. 16, 2025: 6 @ 13.06
Dec. 31, 2025issueSO-251231-547EAST 3 13.06-39.181041,358.18 Oct. 16, 2025: 3 @ 13.06
Dec. 26, 2025issueSO-251226-153MAIN 12 13.06-156.711071,397.36 Oct. 16, 2025: 12 @ 13.06
Dec. 4, 2025issueSO-251204-287MAIN 8 13.06-104.481191,554.07 Oct. 16, 2025: 8 @ 13.06
Nov. 29, 2025issueSO-251129-830MAIN 6 13.06-78.361271,658.54 Oct. 16, 2025: 6 @ 13.06
Nov. 9, 2025issueSO-251109-592MAIN 19 13.06-248.131331,736.90 Oct. 16, 2025: 19 @ 13.06
Nov. 4, 2025issueSO-251104-985MAIN 11 13.06-143.651521,985.03 Oct. 16, 2025: 11 @ 13.06
Oct. 24, 2025issueSO-251024-238MAIN 15 13.06-195.891632,128.68 Oct. 16, 2025: 15 @ 13.06
Oct. 17, 2025issueSO-251017-307MAIN 5 13.12-65.621782,324.57 May 22, 2025: 2 @ 13.17; Aug. 5, 2025: 1 @ 13.17; Oct. 16, 2025: 2 @ 13.06
Oct. 16, 2025receiptPO-000924MAIN 180 13.062,350.691832,390.20
Oct. 11, 2025issueSO-251011-314EAST 13 13.17-171.19339.50 May 22, 2025: 13 @ 13.17
Oct. 11, 2025issueSO-251011-314MAIN 4 13.17-52.6716210.69 May 22, 2025: 4 @ 13.17
Oct. 7, 2025issueSO-251007-674MAIN 12 13.17-158.0220263.37 May 22, 2025: 12 @ 13.17
Sept. 26, 2025issueSO-250926-656MAIN 3 13.17-39.5032421.39 May 22, 2025: 3 @ 13.17
Sept. 22, 2025issueSO-250922-469MAIN 11 13.17-144.8535460.89 May 22, 2025: 11 @ 13.17
Sept. 17, 2025issueSO-250917-953MAIN 13 13.17-171.1946605.74 May 22, 2025: 13 @ 13.17
Sept. 16, 2025issueSO-250916-875MAIN 9 13.17-118.5159776.93 May 22, 2025: 9 @ 13.17
Sept. 3, 2025issueSO-250903-809MAIN 15 13.17-197.5268895.44 May 22, 2025: 15 @ 13.17
Aug. 28, 2025issueSO-250828-418EAST 12 13.17-158.02831,092.97 May 22, 2025: 12 @ 13.17
Aug. 23, 2025issueSO-250823-706MAIN 9 13.17-118.51951,250.99 May 22, 2025: 9 @ 13.17
Aug. 14, 2025issueSO-250814-446EAST 6 13.17-79.011041,369.50 May 22, 2025: 6 @ 13.17
Aug. 6, 2025issueSO-250806-603EAST 3 13.17-39.501101,448.51 May 22, 2025: 3 @ 13.17
Aug. 5, 2025returnRMAMAIN 1 13.1713.171131,488.02
Aug. 2, 2025issueSO-250802-374MAIN 6 13.17-79.011121,474.85 May 22, 2025: 6 @ 13.17
Aug. 1, 2025issueSO-250801-616MAIN 2 13.17-26.341181,553.86 May 22, 2025: 2 @ 13.17
July 17, 2025issueSO-250717-990MAIN 11 13.17-144.851201,580.20 May 22, 2025: 11 @ 13.17
July 16, 2025issueSO-250716-940MAIN 2 13.17-26.341311,725.05 May 22, 2025: 2 @ 13.17
July 6, 2025issueSO-250706-517MAIN 5 13.17-65.841331,751.38 May 22, 2025: 5 @ 13.17
July 2, 2025issueSO-250702-636MAIN 12 13.17-158.021381,817.23 May 22, 2025: 12 @ 13.17
July 1, 2025issueSO-250701-270EAST 13 13.17-171.191501,975.24 May 22, 2025: 13 @ 13.17
June 29, 2025issueSO-250629-695MAIN 2 13.17-26.341632,146.43 May 22, 2025: 2 @ 13.17
June 17, 2025issueSO-250617-759EAST 4 13.17-52.671652,172.77 May 22, 2025: 4 @ 13.17
June 16, 2025issueSO-250616-257MAIN 3 13.17-39.501692,225.44 May 22, 2025: 3 @ 13.17
June 15, 2025issueSO-250615-623MAIN 9 13.14-118.301722,264.95 Jan. 25, 2025: 1 @ 12.95; May 22, 2025: 8 @ 13.17
June 8, 2025issueSO-250608-139MAIN 9 12.95-116.541812,383.24 Jan. 25, 2025: 9 @ 12.95
June 4, 2025issueSO-250604-828EAST 7 12.95-90.641902,499.78 Jan. 25, 2025: 7 @ 12.95
May 22, 2025issueSO-250522-617MAIN 8 12.95-103.591972,590.42 Jan. 25, 2025: 8 @ 12.95
May 22, 2025transferTRFMAIN → EAST 61 warehouse transfer, no cost effect
May 22, 2025receiptPO-000561MAIN 180 13.172,370.292052,694.01
May 3, 2025issueSO-250503-937MAIN 24 12.95-310.7725323.72 Jan. 25, 2025: 24 @ 12.95
April 25, 2025issueSO-250425-567MAIN 25 12.95-323.7249634.49 Jan. 25, 2025: 25 @ 12.95
April 16, 2025issueSO-250416-978MAIN 5 12.95-64.7474958.20 Jan. 25, 2025: 5 @ 12.95
April 11, 2025issueSO-250411-717MAIN 26 12.95-336.67791,022.95 Jan. 25, 2025: 26 @ 12.95
March 31, 2025issueSO-250331-186MAIN 1 12.95-12.951051,359.61 Jan. 25, 2025: 1 @ 12.95
March 27, 2025issueSO-250327-274MAIN 5 12.95-64.741061,372.56 Jan. 25, 2025: 5 @ 12.95
March 14, 2025issueSO-250314-819MAIN 14 12.95-181.281111,437.31 Jan. 25, 2025: 14 @ 12.95
March 8, 2025issueSO-250308-961MAIN 12 12.95-155.381251,618.59 Jan. 25, 2025: 12 @ 12.95
March 6, 2025issueSO-250306-130MAIN 16 12.95-207.181371,773.97 Jan. 25, 2025: 16 @ 12.95
Feb. 23, 2025issueSO-250223-658MAIN 8 12.95-103.591531,981.15 Jan. 25, 2025: 8 @ 12.95
Feb. 13, 2025issueSO-250213-169MAIN 17 12.95-220.131612,084.74 Jan. 25, 2025: 17 @ 12.95
Feb. 5, 2025issueSO-250205-613MAIN 10 13.01-130.091782,304.87 Oct. 1, 2024: 7 @ 13.02; Nov. 30, 2024: 1 @ 13.02; Jan. 25, 2025: 2 @ 12.95
Jan. 25, 2025receiptPO-000216MAIN 180 12.952,330.771882,434.96
Jan. 23, 2025issueSO-250123-792MAIN 3 13.02-39.078104.20 Oct. 1, 2024: 3 @ 13.02
Jan. 21, 2025issueSO-250121-316MAIN 2 13.02-26.0511143.27 Oct. 1, 2024: 2 @ 13.02
Jan. 14, 2025issueSO-250114-248MAIN 28 13.02-364.6913169.32 Oct. 1, 2024: 28 @ 13.02
Jan. 12, 2025issueSO-250112-721MAIN 14 13.02-182.3441534.00 Oct. 1, 2024: 14 @ 13.02
Jan. 12, 2025issueSO-250112-721EAST 5 13.02-65.1255716.35 Oct. 1, 2024: 5 @ 13.02
Jan. 1, 2025issueSO-250101-310MAIN 1 13.02-13.0260781.47 Oct. 1, 2024: 1 @ 13.02
Dec. 25, 2024issueSO-241225-239MAIN 7 13.02-91.1761794.49 Oct. 1, 2024: 7 @ 13.02
Dec. 19, 2024issueSO-241219-503EAST 24 13.02-312.5968885.67 Oct. 1, 2024: 24 @ 13.02
Dec. 15, 2024issueSO-241215-692MAIN 6 13.02-78.15921,198.25 Oct. 1, 2024: 6 @ 13.02
Dec. 14, 2024issueSO-241214-726EAST 1 13.02-13.02981,276.40 Oct. 1, 2024: 1 @ 13.02
Nov. 30, 2024returnRMAMAIN 1 13.0213.02991,289.43
Nov. 25, 2024issueSO-241125-201MAIN 3 13.02-39.07981,276.40 Oct. 1, 2024: 3 @ 13.02
Nov. 22, 2024issueSO-241122-510MAIN 2 13.02-26.051011,315.47 Oct. 1, 2024: 2 @ 13.02
Nov. 20, 2024issueSO-241120-130MAIN 9 13.02-117.221031,341.52 Oct. 1, 2024: 9 @ 13.02
Nov. 18, 2024issueSO-241118-859MAIN 12 13.02-156.291121,458.74 Oct. 1, 2024: 12 @ 13.02
Nov. 12, 2024issueSO-241112-453MAIN 3 13.02-39.071241,615.04 Oct. 1, 2024: 3 @ 13.02
Nov. 3, 2024issueSO-241103-170MAIN 1 13.02-13.021271,654.11 Oct. 1, 2024: 1 @ 13.02
Nov. 2, 2024issueSO-241102-556EAST 15 13.02-195.371281,667.14 Oct. 1, 2024: 15 @ 13.02
Oct. 22, 2024issueSO-241022-895MAIN 18 13.02-234.441431,862.50 Oct. 1, 2024: 18 @ 13.02
Oct. 21, 2024issueSO-241021-541MAIN 1 13.02-13.021612,096.94 Oct. 1, 2024: 1 @ 13.02
Oct. 20, 2024issueSO-241020-599MAIN 10 13.02-130.241622,109.97 Oct. 1, 2024: 10 @ 13.02
Oct. 19, 2024issueSO-241019-424EAST 5 13.02-65.121722,240.21 Oct. 1, 2024: 5 @ 13.02
Oct. 14, 2024issueSO-241014-665EAST 2 13.02-26.051772,305.34 Oct. 1, 2024: 2 @ 13.02
Oct. 9, 2024issueSO-241009-625EAST 1 13.02-13.021792,331.39 Oct. 1, 2024: 1 @ 13.02
Oct. 1, 2024transferTRFMAIN → EAST 53 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000002MAIN 180 13.022,344.411802,344.41