stocksense

Items / CON-0027

Bend 20mm Prime CON-0027 · Conduit & Fittings · Conduit & Cable Co

On hand (EA)72MAIN 63, EAST 9
Value (FIFO)3,463.94avg 48.11
ClassAX / FCV 0.21
Turnover11.5xlast issue 8 days ago
Days of cover28lead time 14d

Demand and forecast

Monthly demand and forecast for CON-00270.030.360.590.8121Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 72.0Nov 24: 79.0Dec 24: 81.0Jan 25: 82.0Feb 25: 36.0Mar 25: 67.0Apr 25: 78.0May 25: 68.0Jun 25: 71.0Jul 25: 75.0Aug 25: 61.0Sep 25: 87.0Oct 25: 63.0Nov 25: 60.0Dec 25: 63.0Jan 26: 76.0Feb 26: 110.0Mar 26: 85.0Apr 26: 89.0May 26: 84.0Jun 26: 51.0Jul 26: 72.0Aug 26: 72.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.437576.92 / 30.43752.527
Daily demand sdmonthly sd / sqrt(30.4375)16.32 / 5.5172.958
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.958^2 + 2.527^2 * 3.1^2)27.9
Reorder pointd * LT + safety stock2.527 * 14.0 + 27.963.4
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days63.4
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 922/yr, S = 45.00, h = 20%, price = 49.6591.4
Inventory positionon hand + on order72 + 072

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

From qtyUnit costOrder qtyAnnual costFeasible
049.659146,704yes (chosen if cheapest)
64047.6664047,079yes
1,28045.681,28048,011yes

MOQ 320, pack size 20, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
July 17, 202657 / 32048.112,742.29
Aug. 9, 20263 / 348.11144.33
Aug. 19, 202612 / 1248.11577.32

Movement ledger 117 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 8, 2026issueSO-261008-264MAIN 54 48.11-2,597.96723,463.94 July 17, 2026: 54 @ 48.11
Oct. 3, 2026issueSO-261003-804MAIN 14 48.11-673.541266,061.90 July 17, 2026: 14 @ 48.11
Sept. 28, 2026issueSO-260928-864MAIN 28 48.11-1,347.091406,735.44 July 17, 2026: 28 @ 48.11
Sept. 21, 2026issueSO-260921-564MAIN 55 48.11-2,646.071688,082.53 July 17, 2026: 55 @ 48.11
Sept. 10, 2026issueSO-260910-813MAIN 15 48.11-721.6522310,728.60 July 17, 2026: 15 @ 48.11
Aug. 19, 2026returnRMAMAIN 12 48.11577.3223811,450.25
Aug. 9, 2026returnRMAMAIN 3 48.11144.3322610,872.93
Aug. 7, 2026issueSO-260807-154MAIN 2 48.11-96.2222310,728.60 July 17, 2026: 2 @ 48.11
Aug. 3, 2026issueSO-260803-891MAIN 24 48.11-1,154.6522510,824.82 July 17, 2026: 24 @ 48.11
Aug. 2, 2026issueSO-260802-305MAIN 61 48.11-2,934.7324911,979.46 July 17, 2026: 61 @ 48.11
July 29, 2026issueSO-260729-365MAIN 5 48.11-240.5531014,914.19 July 17, 2026: 5 @ 48.11
July 28, 2026issueSO-260728-311MAIN 22 49.40-1,086.9031515,154.74 March 10, 2026: 13 @ 49.79; May 24, 2026: 4 @ 49.79; July 17, 2026: 5 @ 48.11
July 23, 2026issueSO-260723-743MAIN 6 49.79-298.7133716,241.65 March 10, 2026: 6 @ 49.79
July 18, 2026issueSO-260718-772EAST 13 49.79-647.2134316,540.36 March 10, 2026: 13 @ 49.79
July 17, 2026receiptPO-001652MAIN 320 48.1115,395.3035617,187.57
July 10, 2026issueSO-260710-702EAST 11 49.79-547.64361,792.27 March 10, 2026: 11 @ 49.79
July 8, 2026issueSO-260708-393MAIN 5 49.79-248.93472,339.91 March 10, 2026: 5 @ 49.79
July 1, 2026issueSO-260701-749EAST 10 49.79-497.85522,588.84 March 10, 2026: 10 @ 49.79
June 21, 2026issueSO-260621-814EAST 16 49.79-796.56623,086.69 March 10, 2026: 16 @ 49.79
June 17, 2026issueSO-260617-584MAIN 35 49.79-1,742.49783,883.25 March 10, 2026: 35 @ 49.79
May 31, 2026issueSO-260531-237EAST 5 49.79-248.931135,625.74 March 10, 2026: 5 @ 49.79
May 24, 2026returnRMAMAIN 4 49.79199.141185,874.67
May 22, 2026issueSO-260522-510MAIN 24 49.79-1,194.851145,675.52 March 10, 2026: 24 @ 49.79
May 21, 2026issueSO-260521-788MAIN 2 49.79-99.571386,870.37 March 10, 2026: 2 @ 49.79
May 7, 2026issueSO-260507-479EAST 9 49.79-448.071406,969.94 March 10, 2026: 9 @ 49.79
May 3, 2026issueSO-260503-346MAIN 48 49.79-2,389.691497,418.01 March 10, 2026: 48 @ 49.79
April 27, 2026issueSO-260427-676MAIN 21 49.79-1,045.491979,807.70 March 10, 2026: 21 @ 49.79
April 26, 2026issueSO-260426-510MAIN 16 49.79-796.5621810,853.20 March 10, 2026: 16 @ 49.79
April 24, 2026issueSO-260424-718MAIN 10 49.79-497.8523411,649.76 March 10, 2026: 10 @ 49.79
April 13, 2026issueSO-260413-858MAIN 16 49.79-796.5624412,147.61 March 10, 2026: 16 @ 49.79
April 8, 2026issueSO-260408-791EAST 26 49.79-1,294.4226012,944.18 March 10, 2026: 26 @ 49.79
March 31, 2026issueSO-260331-633EAST 5 49.79-248.9328614,238.60 March 10, 2026: 5 @ 49.79
March 30, 2026issueSO-260330-355MAIN 19 49.79-945.9229114,487.52 March 10, 2026: 19 @ 49.79
March 27, 2026issueSO-260327-961MAIN 19 48.24-916.5431015,433.44 Nov. 1, 2025: 9 @ 46.52; March 10, 2026: 10 @ 49.79
March 25, 2026issueSO-260325-621MAIN 6 46.52-279.1332916,349.99 Nov. 1, 2025: 6 @ 46.52
March 22, 2026issueSO-260322-498MAIN 29 46.52-1,349.1133516,629.11 Nov. 1, 2025: 29 @ 46.52
March 10, 2026transferTRFMAIN → EAST 104 warehouse transfer, no cost effect
March 10, 2026receiptPO-001303MAIN 320 49.7915,931.3036417,978.23
March 8, 2026issueSO-260308-670MAIN 7 46.52-325.65442,046.93 Nov. 1, 2025: 7 @ 46.52
Feb. 19, 2026issueSO-260219-428MAIN 45 46.52-2,093.45512,372.58 Nov. 1, 2025: 45 @ 46.52
Feb. 14, 2026issueSO-260214-577MAIN 30 46.52-1,395.64964,466.04 Nov. 1, 2025: 30 @ 46.52
Feb. 10, 2026issueSO-260210-328MAIN 27 46.52-1,256.071265,861.67 Nov. 1, 2025: 27 @ 46.52
Feb. 2, 2026issueSO-260202-533MAIN 8 46.52-372.171537,117.74 Nov. 1, 2025: 8 @ 46.52
Jan. 25, 2026issueSO-260125-470MAIN 19 46.52-883.901617,489.91 Nov. 1, 2025: 19 @ 46.52
Jan. 11, 2026issueSO-260111-376MAIN 53 46.52-2,465.621808,373.82 Nov. 1, 2025: 53 @ 46.52
Jan. 7, 2026issueSO-260107-172MAIN 4 46.52-186.0823310,839.44 Nov. 1, 2025: 4 @ 46.52
Dec. 21, 2025issueSO-251221-144MAIN 19 46.52-883.9023711,025.52 Nov. 1, 2025: 19 @ 46.52
Dec. 16, 2025issueSO-251216-296MAIN 21 46.52-976.9525611,909.43 Nov. 1, 2025: 21 @ 46.52
Dec. 15, 2025issueSO-251215-934MAIN 7 46.52-325.6527712,886.37 Nov. 1, 2025: 7 @ 46.52
Dec. 12, 2025issueSO-251212-369MAIN 4 46.52-186.0828413,212.02 Nov. 1, 2025: 4 @ 46.52
Dec. 10, 2025issueSO-251210-249MAIN 4 46.52-186.0828813,398.11 Nov. 1, 2025: 4 @ 46.52
Dec. 3, 2025issueSO-251203-798MAIN 5 46.52-232.6129213,584.19 Nov. 1, 2025: 5 @ 46.52
Dec. 1, 2025issueSO-251201-134MAIN 3 46.52-139.5629713,816.80 Nov. 1, 2025: 3 @ 46.52
Nov. 27, 2025issueSO-251127-387MAIN 9 46.52-418.6930013,956.36 Nov. 1, 2025: 9 @ 46.52
Nov. 17, 2025issueSO-251117-100MAIN 12 46.66-559.9830914,375.05 July 4, 2025: 1 @ 48.24; Nov. 1, 2025: 11 @ 46.52
Nov. 10, 2025issueSO-251110-995MAIN 39 48.24-1,881.4432114,935.03 June 27, 2025: 26 @ 48.24; July 4, 2025: 13 @ 48.24
Nov. 1, 2025receiptPO-000971MAIN 320 46.5214,886.7836016,816.46
Oct. 19, 2025issueSO-251019-530MAIN 57 48.24-2,749.79401,929.68 June 27, 2025: 57 @ 48.24
Oct. 17, 2025issueSO-251017-533MAIN 6 48.24-289.45974,679.47 June 27, 2025: 6 @ 48.24
Sept. 27, 2025issueSO-250927-264MAIN 35 48.24-1,688.471034,968.93 June 27, 2025: 35 @ 48.24
Sept. 23, 2025issueSO-250923-961MAIN 2 48.24-96.481386,657.40 June 27, 2025: 2 @ 48.24
Sept. 20, 2025issueSO-250920-543MAIN 3 48.24-144.731406,753.88 June 27, 2025: 3 @ 48.24
Sept. 17, 2025issueSO-250917-979MAIN 29 48.24-1,399.021436,898.61 June 27, 2025: 29 @ 48.24
Sept. 8, 2025issueSO-250908-903MAIN 7 48.24-337.691728,297.62 June 27, 2025: 7 @ 48.24
Sept. 4, 2025issueSO-250904-776MAIN 11 48.24-530.661798,635.32 June 27, 2025: 11 @ 48.24
Aug. 31, 2025issueSO-250831-601MAIN 31 48.24-1,495.501909,165.98 June 27, 2025: 31 @ 48.24
Aug. 25, 2025issueSO-250825-213MAIN 17 48.24-820.1122110,661.48 June 27, 2025: 17 @ 48.24
Aug. 13, 2025issueSO-250813-715MAIN 1 48.24-48.2423811,481.60 June 27, 2025: 1 @ 48.24
Aug. 5, 2025issueSO-250805-787MAIN 7 48.24-337.6923911,529.84 June 27, 2025: 7 @ 48.24
Aug. 3, 2025issueSO-250803-398MAIN 4 48.24-192.9724611,867.53 June 27, 2025: 4 @ 48.24
Aug. 1, 2025issueSO-250801-554MAIN 1 48.24-48.2425012,060.50 June 27, 2025: 1 @ 48.24
July 29, 2025issueSO-250729-740MAIN 14 48.24-675.3925112,108.74 June 27, 2025: 14 @ 48.24
July 15, 2025issueSO-250715-936MAIN 25 48.24-1,206.0526512,784.13 June 27, 2025: 25 @ 48.24
July 10, 2025issueSO-250710-607MAIN 1 48.24-48.2429013,990.18 June 27, 2025: 1 @ 48.24
July 8, 2025issueSO-250708-680MAIN 40 48.24-1,929.6829114,038.42 June 27, 2025: 40 @ 48.24
July 4, 2025returnRMAMAIN 14 48.24675.3933115,968.10
July 2, 2025issueSO-250702-222MAIN 3 48.24-144.7331715,292.71 June 27, 2025: 3 @ 48.24
July 2, 2025issueSO-250702-222EAST 6 46.66-279.9332015,437.44 April 29, 2025: 6 @ 46.66
June 27, 2025receiptPO-000670MAIN 320 48.2415,437.4432615,717.37
June 26, 2025issueSO-250626-684EAST 13 46.66-606.526279.93 April 29, 2025: 13 @ 46.66
June 17, 2025issueSO-250617-417EAST 29 46.66-1,353.0119886.46 Feb. 10, 2025: 27 @ 46.66; April 29, 2025: 2 @ 46.66
June 14, 2025issueSO-250614-743EAST 14 46.66-653.18482,239.47 Feb. 10, 2025: 14 @ 46.66
June 12, 2025issueSO-250612-502EAST 8 46.66-373.24622,892.65 Feb. 10, 2025: 8 @ 46.66
June 3, 2025issueSO-250603-697EAST 4 46.66-186.62703,265.89 Feb. 10, 2025: 4 @ 46.66
June 3, 2025issueSO-250603-697MAIN 3 46.66-139.97743,452.51 Feb. 10, 2025: 3 @ 46.66
May 13, 2025issueSO-250513-382MAIN 9 46.66-419.90773,592.48 Feb. 10, 2025: 9 @ 46.66
May 6, 2025issueSO-250506-884MAIN 21 46.66-979.77864,012.38 Feb. 10, 2025: 21 @ 46.66
May 4, 2025issueSO-250504-216MAIN 38 46.66-1,772.911074,992.15 Feb. 10, 2025: 38 @ 46.66
April 29, 2025returnRMAMAIN 21 46.66979.771456,765.06
April 24, 2025issueSO-250424-867EAST 10 46.66-466.561245,785.29 Feb. 10, 2025: 10 @ 46.66
April 20, 2025issueSO-250420-242EAST 1 46.66-46.661346,251.85 Feb. 10, 2025: 1 @ 46.66
April 17, 2025issueSO-250417-654MAIN 36 46.66-1,679.601356,298.51 Feb. 10, 2025: 36 @ 46.66
April 16, 2025issueSO-250416-916MAIN 9 46.66-419.901717,978.11 Feb. 10, 2025: 9 @ 46.66
April 12, 2025issueSO-250412-793MAIN 43 46.66-2,006.191808,398.01 Feb. 10, 2025: 43 @ 46.66
March 19, 2025issueSO-250319-732MAIN 31 46.66-1,446.3222310,404.20 Feb. 10, 2025: 31 @ 46.66
March 9, 2025issueSO-250309-333EAST 27 46.66-1,259.7025411,850.52 Feb. 10, 2025: 27 @ 46.66
March 7, 2025issueSO-250307-670MAIN 8 46.66-373.2428113,110.22 Feb. 10, 2025: 8 @ 46.66
March 2, 2025issueSO-250302-365MAIN 1 46.66-46.6628913,483.47 Feb. 10, 2025: 1 @ 46.66
Feb. 23, 2025issueSO-250223-104MAIN 10 46.66-466.5629013,530.12 Feb. 10, 2025: 10 @ 46.66
Feb. 21, 2025issueSO-250221-580MAIN 5 46.66-233.2830013,996.68 Feb. 10, 2025: 5 @ 46.66
Feb. 13, 2025issueSO-250213-539MAIN 15 46.66-699.8330514,229.96 Feb. 10, 2025: 15 @ 46.66
Feb. 10, 2025transferTRFMAIN → EAST 112 warehouse transfer, no cost effect
Feb. 10, 2025receiptPO-000253MAIN 320 46.6614,929.7932014,929.79
Feb. 6, 2025issueSO-250206-769MAIN 6 47.17-283.0000.00 Oct. 1, 2024: 6 @ 47.17
Jan. 31, 2025issueSO-250131-743MAIN 1 47.17-47.176283.00 Oct. 1, 2024: 1 @ 47.17
Jan. 28, 2025issueSO-250128-182MAIN 54 47.17-2,547.047330.17 Oct. 1, 2024: 54 @ 47.17
Jan. 21, 2025issueSO-250121-846MAIN 1 47.17-47.17612,877.22 Oct. 1, 2024: 1 @ 47.17
Jan. 20, 2025issueSO-250120-668MAIN 26 47.17-1,226.36622,924.38 Oct. 1, 2024: 26 @ 47.17
Dec. 28, 2024issueSO-241228-964MAIN 13 47.17-613.18884,150.74 Oct. 1, 2024: 13 @ 47.17
Dec. 21, 2024issueSO-241221-420MAIN 25 47.17-1,179.191014,763.92 Oct. 1, 2024: 25 @ 47.17
Dec. 16, 2024issueSO-241216-172MAIN 43 47.17-2,028.201265,943.10 Oct. 1, 2024: 43 @ 47.17
Nov. 25, 2024issueSO-241125-959MAIN 66 47.17-3,113.061697,971.31 Oct. 1, 2024: 66 @ 47.17
Nov. 19, 2024issueSO-241119-851MAIN 13 47.17-613.1823511,084.36 Oct. 1, 2024: 13 @ 47.17
Oct. 23, 2024issueSO-241023-139MAIN 47 47.17-2,216.8724811,697.54 Oct. 1, 2024: 47 @ 47.17
Oct. 21, 2024issueSO-241021-423MAIN 7 47.17-330.1729513,914.41 Oct. 1, 2024: 7 @ 47.17
Oct. 1, 2024issueSO-241001-973MAIN 18 47.17-849.0230214,244.58 Oct. 1, 2024: 18 @ 47.17
Oct. 1, 2024receiptPO-000002MAIN 320 47.1715,093.6032015,093.60