stocksense

Items / CON-0009

Cable Tray 2m Nova CON-0009 · Conduit & Fittings · Conduit & Cable Co

On hand (EA)385MAIN 385
Value (FIFO)16,093.62avg 41.80
ClassAX / FCV 0.15
Turnover3.6xlast issue 1 days ago
Days of cover102lead time 14d

Demand and forecast

Monthly demand and forecast for CON-00090.051.4103154206Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 118.0Nov 24: 175.0Dec 24: 187.0Jan 25: 88.0Feb 25: 91.0Mar 25: 120.0Apr 25: 138.0May 25: 103.0Jun 25: 93.0Jul 25: 80.0Aug 25: 162.0Sep 25: 78.0Oct 25: 135.0Nov 25: 136.0Dec 25: 102.0Jan 26: 149.0Feb 26: 103.0Mar 26: 121.0Apr 26: 124.0May 26: 97.0Jun 26: 105.0Jul 26: 89.0Aug 26: 103.0Sep 26: 110.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.4375114.50 / 30.43753.762
Daily demand sdmonthly sd / sqrt(30.4375)17.54 / 5.5173.180
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.180^2 + 3.762^2 * 3.1^2)34.3
Reorder pointd * LT + safety stock3.762 * 14.0 + 34.387.1
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days87.1
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1373/yr, S = 45.00, h = 20%, price = 43.00119.9
Inventory positionon hand + on order385 + 0385

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

From qtyUnit costOrder qtyAnnual costFeasible
043.0012060,072yes (chosen if cheapest)

MOQ 480, pack size 20, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 15, 2026385 / 48041.8016,093.62

Movement ledger 121 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-393MAIN 58 41.80-2,424.4938516,093.62 Sept. 15, 2026: 58 @ 41.80
Oct. 9, 2026issueSO-261009-163MAIN 20 41.80-836.0344318,518.11 Sept. 15, 2026: 20 @ 41.80
Oct. 7, 2026issueSO-261007-956MAIN 90 41.28-3,715.2346319,354.14 June 1, 2026: 73 @ 41.16; Sept. 15, 2026: 17 @ 41.80
Sept. 15, 2026receiptPO-001802MAIN 480 41.8020,064.7755323,069.37
Sept. 13, 2026issueSO-260913-114MAIN 4 41.16-164.64733,004.60 June 1, 2026: 4 @ 41.16
Sept. 5, 2026issueSO-260905-874MAIN 7 41.16-288.11773,169.24 June 1, 2026: 7 @ 41.16
Sept. 3, 2026issueSO-260903-951MAIN 99 41.16-4,074.73843,457.35 June 1, 2026: 99 @ 41.16
Aug. 21, 2026issueSO-260821-244MAIN 11 41.16-452.751837,532.08 June 1, 2026: 11 @ 41.16
Aug. 18, 2026issueSO-260818-143MAIN 11 41.16-452.751947,984.83 June 1, 2026: 11 @ 41.16
Aug. 15, 2026issueSO-260815-898MAIN 75 41.16-3,086.922058,437.57 June 1, 2026: 75 @ 41.16
Aug. 3, 2026issueSO-260803-922MAIN 6 41.16-246.9528011,524.49 June 1, 2026: 6 @ 41.16
July 26, 2026issueSO-260726-137MAIN 54 41.16-2,222.5828611,771.45 June 1, 2026: 54 @ 41.16
July 8, 2026issueSO-260708-380MAIN 35 41.16-1,440.5634013,994.03 June 1, 2026: 35 @ 41.16
June 27, 2026issueSO-260627-954MAIN 4 41.16-164.6437515,434.59 June 1, 2026: 4 @ 41.16
June 19, 2026issueSO-260619-342MAIN 10 41.16-411.5937915,599.22 June 1, 2026: 10 @ 41.16
June 17, 2026issueSO-260617-485MAIN 70 41.16-2,881.1238916,010.81 June 1, 2026: 70 @ 41.16
June 12, 2026issueSO-260612-210MAIN 21 41.16-864.3445918,891.94 June 1, 2026: 21 @ 41.16
June 1, 2026receiptPO-001539MAIN 480 41.1619,756.2748019,756.27
May 29, 2026issueSO-260529-671EAST 23 40.51-931.8100.00 Jan. 18, 2026: 23 @ 40.51
May 26, 2026issueSO-260526-330EAST 5 40.51-202.5723931.81 Jan. 18, 2026: 5 @ 40.51
May 26, 2026issueSO-260526-330MAIN 23 40.51-931.81281,134.37 Jan. 18, 2026: 23 @ 40.51
May 25, 2026issueSO-260525-372MAIN 9 40.51-364.62512,066.18 Jan. 18, 2026: 9 @ 40.51
May 23, 2026issueSO-260523-613MAIN 15 40.51-607.70602,430.80 Jan. 18, 2026: 15 @ 40.51
May 18, 2026issueSO-260518-430EAST 11 40.51-445.65753,038.50 Jan. 18, 2026: 11 @ 40.51
May 6, 2026issueSO-260506-336EAST 11 40.51-445.65863,484.14 Jan. 18, 2026: 11 @ 40.51
April 21, 2026issueSO-260421-416MAIN 34 40.51-1,377.45973,929.79 Jan. 18, 2026: 34 @ 40.51
April 20, 2026issueSO-260420-590MAIN 26 40.51-1,053.351315,307.24 Jan. 18, 2026: 26 @ 40.51
April 16, 2026issueSO-260416-284MAIN 11 40.51-445.651576,360.59 Jan. 18, 2026: 11 @ 40.51
April 13, 2026issueSO-260413-655MAIN 2 40.51-81.031686,806.23 Jan. 18, 2026: 2 @ 40.51
April 11, 2026issueSO-260411-683MAIN 23 40.51-931.811706,887.26 Jan. 18, 2026: 23 @ 40.51
April 9, 2026issueSO-260409-344MAIN 14 40.51-567.191937,819.07 Jan. 18, 2026: 14 @ 40.51
April 4, 2026issueSO-260404-669MAIN 14 40.51-567.192078,386.25 Jan. 18, 2026: 14 @ 40.51
March 18, 2026issueSO-260318-682EAST 77 40.51-3,119.522218,953.44 Jan. 18, 2026: 77 @ 40.51
March 15, 2026issueSO-260315-995EAST 2 40.51-81.0329812,072.96 Jan. 18, 2026: 2 @ 40.51
March 4, 2026issueSO-260304-704MAIN 42 40.51-1,701.5630012,153.99 Jan. 18, 2026: 42 @ 40.51
Feb. 14, 2026issueSO-260214-584MAIN 60 40.51-2,430.8034213,855.55 Jan. 18, 2026: 60 @ 40.51
Feb. 12, 2026issueSO-260212-569EAST 19 40.51-769.7540216,286.35 Jan. 18, 2026: 19 @ 40.51
Feb. 5, 2026issueSO-260205-931MAIN 24 40.51-972.3242117,056.10 Jan. 18, 2026: 24 @ 40.51
Jan. 31, 2026issueSO-260131-719MAIN 23 40.51-931.8144518,028.42 Jan. 18, 2026: 23 @ 40.51
Jan. 29, 2026issueSO-260129-600EAST 1 40.51-40.5146818,960.22 Jan. 18, 2026: 1 @ 40.51
Jan. 27, 2026issueSO-260127-419MAIN 13 40.47-526.1646919,000.74 Sept. 13, 2025: 2 @ 40.26; Jan. 18, 2026: 11 @ 40.51
Jan. 21, 2026issueSO-260121-454MAIN 37 40.26-1,489.5348219,526.90 Sept. 13, 2025: 37 @ 40.26
Jan. 18, 2026transferTRFMAIN → EAST 149 warehouse transfer, no cost effect
Jan. 18, 2026receiptPO-001156MAIN 480 40.5119,446.3851921,016.43
Jan. 15, 2026issueSO-260115-956MAIN 10 40.26-402.58391,570.04 Sept. 13, 2025: 10 @ 40.26
Jan. 12, 2026issueSO-260112-583MAIN 65 40.26-2,616.74491,972.62 Sept. 13, 2025: 65 @ 40.26
Dec. 27, 2025issueSO-251227-980MAIN 8 40.26-322.061144,589.36 Sept. 13, 2025: 8 @ 40.26
Dec. 26, 2025issueSO-251226-958MAIN 13 40.26-523.351224,911.42 Sept. 13, 2025: 13 @ 40.26
Dec. 25, 2025issueSO-251225-748MAIN 5 40.26-201.291355,434.76 Sept. 13, 2025: 5 @ 40.26
Dec. 23, 2025issueSO-251223-361MAIN 14 40.26-563.601405,636.05 Sept. 13, 2025: 14 @ 40.26
Dec. 20, 2025issueSO-251220-207MAIN 4 40.26-161.031546,199.66 Sept. 13, 2025: 4 @ 40.26
Dec. 8, 2025issueSO-251208-751MAIN 55 40.26-2,214.161586,360.68 Sept. 13, 2025: 55 @ 40.26
Dec. 6, 2025issueSO-251206-640MAIN 3 40.26-120.772138,574.85 Sept. 13, 2025: 3 @ 40.26
Nov. 29, 2025issueSO-251129-165MAIN 17 40.26-684.382168,695.62 Sept. 13, 2025: 17 @ 40.26
Nov. 27, 2025issueSO-251127-494MAIN 33 40.26-1,328.502339,380.00 Sept. 13, 2025: 33 @ 40.26
Nov. 19, 2025issueSO-251119-406MAIN 37 40.26-1,489.5326610,708.50 Sept. 13, 2025: 37 @ 40.26
Nov. 8, 2025issueSO-251108-661MAIN 11 40.26-442.8330312,198.02 Sept. 13, 2025: 11 @ 40.26
Nov. 7, 2025issueSO-251107-676MAIN 38 40.26-1,529.7831412,640.86 Sept. 13, 2025: 38 @ 40.26
Oct. 31, 2025issueSO-251031-371MAIN 27 40.26-1,086.9535214,170.64 Sept. 13, 2025: 27 @ 40.26
Oct. 26, 2025issueSO-251026-917MAIN 12 40.26-483.0937915,257.59 Sept. 13, 2025: 12 @ 40.26
Oct. 17, 2025issueSO-251017-296MAIN 62 40.26-2,495.9639115,740.68 Sept. 13, 2025: 62 @ 40.26
Oct. 4, 2025issueSO-251004-415MAIN 17 40.26-684.3845318,236.65 Sept. 13, 2025: 17 @ 40.26
Oct. 2, 2025issueSO-251002-910MAIN 8 40.26-322.0647018,921.02 Sept. 13, 2025: 8 @ 40.26
Oct. 1, 2025issueSO-251001-316MAIN 9 40.30-362.7047819,243.08 April 24, 2025: 7 @ 40.31; Sept. 13, 2025: 2 @ 40.26
Sept. 22, 2025issueSO-250922-458MAIN 3 40.31-120.9448719,605.79 April 24, 2025: 3 @ 40.31
Sept. 22, 2025issueSO-250922-458EAST 21 40.31-846.5649019,726.72 April 24, 2025: 21 @ 40.31
Sept. 21, 2025issueSO-250921-876EAST 34 40.31-1,370.6151120,573.28 April 24, 2025: 34 @ 40.31
Sept. 13, 2025receiptPO-000840MAIN 480 40.2619,323.6054521,943.89
Sept. 5, 2025issueSO-250905-547EAST 20 40.31-806.24652,620.29 April 24, 2025: 20 @ 40.31
Aug. 29, 2025issueSO-250829-207MAIN 47 40.31-1,894.67853,426.54 April 24, 2025: 47 @ 40.31
Aug. 23, 2025issueSO-250823-521MAIN 21 40.31-846.561325,321.21 April 24, 2025: 21 @ 40.31
Aug. 21, 2025issueSO-250821-897MAIN 74 40.31-2,983.101536,167.77 April 24, 2025: 74 @ 40.31
Aug. 9, 2025issueSO-250809-245MAIN 20 40.31-806.242279,150.87 April 24, 2025: 20 @ 40.31
July 8, 2025issueSO-250708-693MAIN 16 40.31-645.002479,957.11 April 24, 2025: 16 @ 40.31
July 4, 2025issueSO-250704-486MAIN 64 40.31-2,579.9826310,602.11 April 24, 2025: 64 @ 40.31
June 28, 2025issueSO-250628-350EAST 31 40.31-1,249.6832713,182.09 April 24, 2025: 31 @ 40.31
June 26, 2025issueSO-250626-729MAIN 10 40.31-403.1235814,431.77 April 24, 2025: 10 @ 40.31
June 20, 2025issueSO-250620-928MAIN 21 40.31-846.5636814,834.89 April 24, 2025: 21 @ 40.31
June 10, 2025issueSO-250610-763MAIN 31 40.31-1,249.6838915,681.45 April 24, 2025: 31 @ 40.31
May 24, 2025issueSO-250524-883MAIN 8 40.31-322.5042016,931.12 April 24, 2025: 8 @ 40.31
May 17, 2025issueSO-250517-366MAIN 18 40.31-725.6242817,253.62 April 24, 2025: 18 @ 40.31
May 9, 2025issueSO-250509-232MAIN 23 40.31-927.1844617,979.24 April 24, 2025: 23 @ 40.31
May 8, 2025issueSO-250508-214EAST 53 39.45-2,091.0646918,906.42 Jan. 3, 2025: 42 @ 39.23; April 24, 2025: 11 @ 40.31
May 5, 2025issueSO-250505-755MAIN 1 39.23-39.2352220,997.48 Jan. 3, 2025: 1 @ 39.23
April 24, 2025issueSO-250424-822MAIN 9 39.23-353.0652321,036.71 Jan. 3, 2025: 9 @ 39.23
April 24, 2025transferTRFMAIN → EAST 159 warehouse transfer, no cost effect
April 24, 2025receiptPO-000478MAIN 480 40.3119,349.8653221,389.77
April 10, 2025issueSO-250410-284MAIN 51 39.23-2,000.69522,039.92 Jan. 3, 2025: 51 @ 39.23
April 9, 2025issueSO-250409-665MAIN 45 39.23-1,765.311034,040.61 Jan. 3, 2025: 45 @ 39.23
April 9, 2025issueSO-250409-665EAST 24 39.23-941.501485,805.92 Jan. 3, 2025: 24 @ 39.23
April 1, 2025issueSO-250401-187EAST 9 39.23-353.061726,747.42 Jan. 3, 2025: 9 @ 39.23
March 25, 2025issueSO-250325-889MAIN 10 39.23-392.291817,100.49 Jan. 3, 2025: 10 @ 39.23
March 19, 2025issueSO-250319-989MAIN 28 39.23-1,098.421917,492.78 Jan. 3, 2025: 28 @ 39.23
March 16, 2025issueSO-250316-972MAIN 14 39.23-549.212198,591.19 Jan. 3, 2025: 14 @ 39.23
March 7, 2025issueSO-250307-387EAST 1 39.23-39.232339,140.40 Jan. 3, 2025: 1 @ 39.23
March 3, 2025issueSO-250303-330MAIN 7 39.23-274.602349,179.63 Jan. 3, 2025: 7 @ 39.23
March 2, 2025issueSO-250302-304MAIN 60 39.23-2,353.752419,454.24 Jan. 3, 2025: 60 @ 39.23
Feb. 23, 2025issueSO-250223-905EAST 11 39.23-431.5230111,807.99 Jan. 3, 2025: 11 @ 39.23
Feb. 22, 2025issueSO-250222-367EAST 63 39.23-2,471.4431212,239.51 Jan. 3, 2025: 63 @ 39.23
Feb. 19, 2025issueSO-250219-176MAIN 6 39.23-235.3837514,710.95 Jan. 3, 2025: 6 @ 39.23
Feb. 14, 2025issueSO-250214-645MAIN 11 39.23-431.5238114,946.33 Jan. 3, 2025: 11 @ 39.23
Jan. 29, 2025issueSO-250129-481MAIN 36 39.23-1,412.2539215,377.85 Jan. 3, 2025: 36 @ 39.23
Jan. 28, 2025issueSO-250128-415MAIN 4 39.23-156.9242816,790.10 Jan. 3, 2025: 4 @ 39.23
Jan. 25, 2025issueSO-250125-414EAST 4 39.23-156.9243216,947.01 Jan. 3, 2025: 4 @ 39.23
Jan. 9, 2025issueSO-250109-887MAIN 44 39.23-1,726.0843617,103.93 Jan. 3, 2025: 44 @ 39.23
Jan. 3, 2025transferTRFMAIN → EAST 112 warehouse transfer, no cost effect
Jan. 3, 2025receiptPO-000159MAIN 480 39.2318,830.0248018,830.02
Dec. 25, 2024issueSO-241225-364MAIN 21 40.85-857.8500.00 Oct. 1, 2024: 21 @ 40.85
Dec. 24, 2024issueSO-241224-966MAIN 47 40.85-1,919.9521857.85 Oct. 1, 2024: 47 @ 40.85
Dec. 20, 2024issueSO-241220-571MAIN 6 40.85-245.10682,777.80 Oct. 1, 2024: 6 @ 40.85
Dec. 19, 2024issueSO-241219-816MAIN 50 40.85-2,042.50743,022.90 Oct. 1, 2024: 50 @ 40.85
Dec. 18, 2024issueSO-241218-682MAIN 38 40.85-1,552.301245,065.40 Oct. 1, 2024: 38 @ 40.85
Dec. 7, 2024issueSO-241207-858MAIN 25 40.85-1,021.251626,617.70 Oct. 1, 2024: 25 @ 40.85
Nov. 14, 2024issueSO-241114-855MAIN 22 40.85-898.701877,638.95 Oct. 1, 2024: 22 @ 40.85
Nov. 11, 2024issueSO-241111-180MAIN 153 40.85-6,250.052098,537.65 Oct. 1, 2024: 153 @ 40.85
Oct. 24, 2024issueSO-241024-677MAIN 6 40.85-245.1036214,787.70 Oct. 1, 2024: 6 @ 40.85
Oct. 23, 2024issueSO-241023-610MAIN 22 40.85-898.7036815,032.80 Oct. 1, 2024: 22 @ 40.85
Oct. 18, 2024issueSO-241018-725MAIN 23 40.85-939.5539015,931.50 Oct. 1, 2024: 23 @ 40.85
Oct. 17, 2024issueSO-241017-468MAIN 16 40.85-653.6041316,871.05 Oct. 1, 2024: 16 @ 40.85
Oct. 3, 2024issueSO-241003-568MAIN 51 40.85-2,083.3542917,524.65 Oct. 1, 2024: 51 @ 40.85
Oct. 1, 2024receiptPO-000002MAIN 480 40.8519,608.0048019,608.00