stocksense

Items / CON-0005

Bend 20mm Pro CON-0005 · Conduit & Fittings · Conduit & Cable Co

On hand (EA)151EAST 151
Value (FIFO)867.36avg 5.74
ClassCX / FCV 0.23
Turnover4.5xlast issue 4 days ago
Days of cover36lead time 14d

Demand and forecast

Monthly demand and forecast for CON-00050.059.7119179239Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 119.0Nov 24: 217.0Dec 24: 190.0Jan 25: 144.0Feb 25: 76.0Mar 25: 168.0Apr 25: 135.0May 25: 151.0Jun 25: 115.0Jul 25: 182.0Aug 25: 119.0Sep 25: 106.0Oct 25: 149.0Nov 25: 108.0Dec 25: 133.0Jan 26: 105.0Feb 26: 97.0Mar 26: 135.0Apr 26: 145.0May 26: 101.0Jun 26: 96.0Jul 26: 117.0Aug 26: 162.0Sep 26: 201.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.4375129.08 / 30.43754.241
Daily demand sdmonthly sd / sqrt(30.4375)30.33 / 5.5175.498
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 * 5.498^2 + 4.241^2 * 3.1^2)31.3
Reorder pointd * LT + safety stock4.241 * 14.0 + 31.390.9
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days90.9
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1548/yr, S = 45.00, h = 20%, price = 5.69349.9
Inventory positionon hand + on order151 + 0151

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

From qtyUnit costOrder qtyAnnual costFeasible
05.693509,206yes (chosen if cheapest)

MOQ 600, pack size 20, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 8, 2026151 / 6005.74867.36

Movement ledger 136 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 12, 2026issueSO-261012-109EAST 42 5.74-241.25151867.36 Aug. 8, 2026: 42 @ 5.74
Oct. 12, 2026issueSO-261012-109MAIN 20 5.74-114.881931,108.61 Aug. 8, 2026: 20 @ 5.74
Oct. 11, 2026issueSO-261011-543MAIN 58 5.74-333.162131,223.49 Aug. 8, 2026: 58 @ 5.74
Oct. 1, 2026issueSO-261001-674MAIN 58 5.74-333.162711,556.65 Aug. 8, 2026: 58 @ 5.74
Sept. 26, 2026issueSO-260926-109MAIN 35 5.74-201.043291,889.81 Aug. 8, 2026: 35 @ 5.74
Sept. 10, 2026issueSO-260910-295MAIN 166 5.74-953.523642,090.85 Aug. 8, 2026: 166 @ 5.74
Aug. 25, 2026issueSO-260825-326MAIN 157 5.67-890.835303,044.37 April 4, 2026: 11 @ 5.62; May 23, 2026: 76 @ 5.62; Aug. 8, 2026: 70 @ 5.74
Aug. 22, 2026issueSO-260822-205MAIN 5 5.62-28.096873,935.20 April 4, 2026: 5 @ 5.62
Aug. 8, 2026transferTRFMAIN → EAST 176 warehouse transfer, no cost effect
Aug. 8, 2026receiptPO-001704MAIN 600 5.743,446.466923,963.29
July 24, 2026issueSO-260724-962MAIN 48 5.62-269.6592516.83 March 8, 2026: 44 @ 5.62; April 4, 2026: 4 @ 5.62
July 23, 2026issueSO-260723-205EAST 10 5.62-56.18140786.48 March 8, 2026: 10 @ 5.62
July 17, 2026issueSO-260717-483MAIN 24 5.62-134.82150842.66 March 8, 2026: 24 @ 5.62
July 14, 2026issueSO-260714-381MAIN 25 5.62-140.44174977.48 March 8, 2026: 25 @ 5.62
July 11, 2026issueSO-260711-746MAIN 9 5.62-50.561991,117.92 March 8, 2026: 9 @ 5.62
July 3, 2026issueSO-260703-839EAST 1 5.62-5.622081,168.48 March 8, 2026: 1 @ 5.62
June 30, 2026issueSO-260630-575MAIN 29 5.62-162.912091,174.10 March 8, 2026: 29 @ 5.62
June 27, 2026issueSO-260627-645EAST 15 5.62-84.272381,337.01 March 8, 2026: 15 @ 5.62
June 25, 2026issueSO-260625-929EAST 14 5.62-78.652531,421.28 March 8, 2026: 14 @ 5.62
June 22, 2026issueSO-260622-606MAIN 5 5.62-28.092671,499.93 March 8, 2026: 5 @ 5.62
June 18, 2026issueSO-260618-255MAIN 27 5.62-151.682721,528.01 March 8, 2026: 27 @ 5.62
June 7, 2026issueSO-260607-667MAIN 6 5.62-33.712991,679.69 March 8, 2026: 6 @ 5.62
May 27, 2026issueSO-260527-255MAIN 25 5.62-140.443051,713.40 March 8, 2026: 25 @ 5.62
May 23, 2026returnRMAMAIN 76 5.62426.953301,853.84
May 3, 2026issueSO-260503-232MAIN 152 5.62-853.892541,426.90 March 8, 2026: 152 @ 5.62
April 20, 2026issueSO-260420-113MAIN 24 5.62-134.824062,280.79 March 8, 2026: 24 @ 5.62
April 19, 2026issueSO-260419-310MAIN 76 5.62-426.954302,415.61 March 8, 2026: 76 @ 5.62
April 16, 2026issueSO-260416-359EAST 22 5.62-123.595062,842.56 March 8, 2026: 22 @ 5.62
April 6, 2026issueSO-260406-958MAIN 16 5.62-89.885282,966.15 March 8, 2026: 16 @ 5.62
April 4, 2026returnRMAMAIN 20 5.62112.355443,056.03
April 3, 2026issueSO-260403-845MAIN 12 5.62-67.415242,943.67 March 8, 2026: 12 @ 5.62
April 2, 2026issueSO-260402-171EAST 15 5.62-84.275363,011.09 March 8, 2026: 15 @ 5.62
March 30, 2026issueSO-260330-625EAST 41 5.62-230.335513,095.35 March 8, 2026: 41 @ 5.62
March 24, 2026issueSO-260324-793MAIN 26 5.40-140.345923,325.68 Sept. 17, 2025: 16 @ 5.30; Jan. 25, 2026: 2 @ 5.32; March 8, 2026: 8 @ 5.62
March 23, 2026issueSO-260323-734EAST 38 5.32-202.016183,466.02 Sept. 14, 2025: 34 @ 5.32; Sept. 17, 2025: 4 @ 5.30
March 14, 2026issueSO-260314-410MAIN 11 5.32-58.506563,668.03 Sept. 14, 2025: 11 @ 5.32
March 8, 2026transferTRFMAIN → EAST 173 warehouse transfer, no cost effect
March 8, 2026receiptPO-001294MAIN 600 5.623,370.626673,726.53
March 7, 2026issueSO-260307-501MAIN 5 5.32-26.5967355.91 Sept. 14, 2025: 5 @ 5.32
March 1, 2026issueSO-260301-180MAIN 14 5.32-74.4572382.50 Sept. 14, 2025: 14 @ 5.32
Feb. 26, 2026issueSO-260226-552MAIN 11 5.32-58.5086456.95 Sept. 14, 2025: 11 @ 5.32
Feb. 19, 2026issueSO-260219-838MAIN 18 5.32-95.7397515.45 Sept. 14, 2025: 18 @ 5.32
Feb. 12, 2026issueSO-260212-170MAIN 58 5.32-308.45115611.18 Sept. 14, 2025: 58 @ 5.32
Feb. 5, 2026issueSO-260205-812MAIN 10 5.32-53.18173919.63 Sept. 14, 2025: 10 @ 5.32
Jan. 25, 2026returnRMAMAIN 2 5.3210.64183972.81
Jan. 20, 2026issueSO-260120-475MAIN 28 5.32-148.91181962.17 Sept. 14, 2025: 28 @ 5.32
Jan. 17, 2026issueSO-260117-323MAIN 4 5.32-21.272091,111.08 Sept. 14, 2025: 4 @ 5.32
Jan. 16, 2026issueSO-260116-389MAIN 14 5.32-74.452131,132.35 Sept. 14, 2025: 14 @ 5.32
Jan. 12, 2026issueSO-260112-652MAIN 4 5.32-21.272271,206.80 Sept. 14, 2025: 4 @ 5.32
Jan. 11, 2026issueSO-260111-518MAIN 52 5.32-276.542311,228.08 Sept. 14, 2025: 52 @ 5.32
Jan. 8, 2026issueSO-260108-495MAIN 5 5.32-26.592831,504.62 Sept. 14, 2025: 5 @ 5.32
Dec. 30, 2025issueSO-251230-697MAIN 26 5.32-138.272881,531.21 Sept. 14, 2025: 26 @ 5.32
Dec. 17, 2025issueSO-251217-116MAIN 5 5.32-26.593141,669.48 Sept. 14, 2025: 5 @ 5.32
Dec. 13, 2025issueSO-251213-153MAIN 14 5.32-74.453191,696.07 Sept. 14, 2025: 14 @ 5.32
Dec. 8, 2025issueSO-251208-844MAIN 30 5.32-159.543331,770.52 Sept. 14, 2025: 30 @ 5.32
Dec. 5, 2025issueSO-251205-809MAIN 58 5.32-308.453631,930.06 Sept. 14, 2025: 58 @ 5.32
Nov. 27, 2025issueSO-251127-737MAIN 20 5.32-106.364212,238.51 Sept. 14, 2025: 20 @ 5.32
Nov. 27, 2025issueSO-251127-737EAST 6 5.32-31.914412,344.88 Sept. 14, 2025: 6 @ 5.32
Nov. 22, 2025issueSO-251122-374MAIN 27 5.32-143.594472,376.78 Sept. 14, 2025: 27 @ 5.32
Nov. 19, 2025issueSO-251119-369MAIN 2 5.32-10.644742,520.37 Sept. 14, 2025: 2 @ 5.32
Nov. 2, 2025issueSO-251102-688MAIN 53 5.32-281.864762,531.01 Sept. 14, 2025: 53 @ 5.32
Oct. 25, 2025issueSO-251025-596MAIN 61 5.32-324.405292,812.87 Sept. 14, 2025: 61 @ 5.32
Oct. 21, 2025issueSO-251021-749EAST 29 5.32-154.225903,137.27 Sept. 14, 2025: 29 @ 5.32
Oct. 17, 2025issueSO-251017-891EAST 59 5.30-312.596193,291.50 May 30, 2025: 58 @ 5.30; Sept. 14, 2025: 1 @ 5.32
Sept. 28, 2025issueSO-250928-603MAIN 12 5.30-63.576783,604.09 May 30, 2025: 12 @ 5.30
Sept. 19, 2025issueSO-250919-718MAIN 24 5.30-127.156903,667.66 May 30, 2025: 24 @ 5.30
Sept. 17, 2025returnRMAMAIN 20 5.30105.967143,794.81
Sept. 14, 2025receiptPO-000843MAIN 600 5.323,190.866943,688.85
Sept. 1, 2025issueSO-250901-957EAST 40 5.30-211.9194497.99 May 30, 2025: 40 @ 5.30
Sept. 1, 2025issueSO-250901-957MAIN 50 5.30-264.89134709.91 May 30, 2025: 50 @ 5.30
Aug. 29, 2025issueSO-250829-368MAIN 11 5.30-58.28184974.80 May 30, 2025: 11 @ 5.30
Aug. 26, 2025issueSO-250826-293MAIN 18 5.30-95.361951,033.07 May 30, 2025: 18 @ 5.30
Aug. 22, 2025issueSO-250822-552MAIN 1 5.30-5.302131,128.43 May 30, 2025: 1 @ 5.30
Aug. 17, 2025issueSO-250817-448MAIN 22 5.30-116.552141,133.73 May 30, 2025: 22 @ 5.30
Aug. 16, 2025issueSO-250816-426MAIN 22 5.30-116.552361,250.28 May 30, 2025: 22 @ 5.30
Aug. 14, 2025issueSO-250814-738EAST 34 5.30-180.132581,366.83 May 30, 2025: 34 @ 5.30
Aug. 4, 2025issueSO-250804-111MAIN 11 5.30-58.282921,546.96 May 30, 2025: 11 @ 5.30
July 31, 2025issueSO-250731-909MAIN 56 5.30-296.683031,605.23 May 30, 2025: 56 @ 5.30
July 30, 2025issueSO-250730-151EAST 10 5.30-52.983591,901.91 May 30, 2025: 10 @ 5.30
July 22, 2025issueSO-250722-582MAIN 1 5.30-5.303691,954.89 May 30, 2025: 1 @ 5.30
July 19, 2025issueSO-250719-613MAIN 32 5.30-169.533701,960.19 May 30, 2025: 32 @ 5.30
July 18, 2025issueSO-250718-363MAIN 55 5.30-291.384022,129.72 May 30, 2025: 55 @ 5.30
July 5, 2025issueSO-250705-503EAST 16 5.30-84.764572,421.09 May 30, 2025: 16 @ 5.30
July 3, 2025issueSO-250703-874MAIN 12 5.30-63.574732,505.86 May 30, 2025: 12 @ 5.30
June 18, 2025issueSO-250618-334MAIN 38 5.30-201.324852,569.43 May 30, 2025: 38 @ 5.30
June 15, 2025issueSO-250615-983MAIN 50 5.30-264.895232,770.75 May 30, 2025: 50 @ 5.30
June 12, 2025issueSO-250612-352MAIN 27 5.30-143.045733,035.64 May 30, 2025: 27 @ 5.30
May 30, 2025transferTRFMAIN → EAST 194 warehouse transfer, no cost effect
May 30, 2025receiptPO-000590MAIN 600 5.303,178.686003,178.68
May 28, 2025issueSO-250528-747MAIN 49 5.28-258.9300.00 Feb. 16, 2025: 39 @ 5.28; Feb. 20, 2025: 10 @ 5.28
May 27, 2025issueSO-250527-230MAIN 4 5.28-21.1449258.93 Jan. 21, 2025: 3 @ 5.28; Feb. 16, 2025: 1 @ 5.28
May 19, 2025issueSO-250519-394MAIN 15 5.28-79.2653280.07 Jan. 8, 2025: 15 @ 5.28
May 16, 2025issueSO-250516-575EAST 53 5.28-280.0768359.33 Jan. 8, 2025: 53 @ 5.28
May 8, 2025issueSO-250508-493MAIN 19 5.28-100.40121639.40 Jan. 8, 2025: 19 @ 5.28
May 7, 2025issueSO-250507-112EAST 11 5.28-58.13140739.80 Jan. 8, 2025: 11 @ 5.28
April 30, 2025issueSO-250430-385MAIN 3 5.28-15.85151797.93 Jan. 8, 2025: 3 @ 5.28
April 19, 2025issueSO-250419-175EAST 58 5.28-306.49154813.78 Jan. 8, 2025: 58 @ 5.28
April 13, 2025issueSO-250413-253MAIN 31 5.28-163.812121,120.27 Jan. 8, 2025: 31 @ 5.28
April 12, 2025issueSO-250412-883EAST 43 5.28-227.222431,284.08 Jan. 8, 2025: 43 @ 5.28
March 26, 2025issueSO-250326-264MAIN 42 5.28-221.942861,511.31 Jan. 8, 2025: 42 @ 5.28
March 22, 2025issueSO-250322-705MAIN 5 5.28-26.423281,733.25 Jan. 8, 2025: 5 @ 5.28
March 21, 2025issueSO-250321-739MAIN 15 5.28-79.263331,759.67 Jan. 8, 2025: 15 @ 5.28
March 13, 2025issueSO-250313-968MAIN 73 5.28-385.753481,838.94 Jan. 8, 2025: 73 @ 5.28
March 5, 2025issueSO-250305-796MAIN 14 5.28-73.984212,224.69 Jan. 8, 2025: 14 @ 5.28
March 2, 2025issueSO-250302-743MAIN 19 5.28-100.404352,298.67 Jan. 8, 2025: 19 @ 5.28
Feb. 20, 2025returnRMAMAIN 10 5.2852.844542,399.07
Feb. 16, 2025returnRMAMAIN 40 5.28211.374442,346.23
Feb. 13, 2025issueSO-250213-821MAIN 81 5.28-428.034042,134.86 Jan. 8, 2025: 81 @ 5.28
Feb. 11, 2025issueSO-250211-785EAST 11 5.28-58.134852,562.89 Jan. 8, 2025: 11 @ 5.28
Feb. 9, 2025issueSO-250209-594MAIN 8 5.28-42.274962,621.01 Jan. 8, 2025: 8 @ 5.28
Feb. 6, 2025issueSO-250206-887MAIN 20 5.28-105.695042,663.29 Jan. 8, 2025: 20 @ 5.28
Feb. 5, 2025issueSO-250205-333EAST 6 5.28-31.715242,768.97 Jan. 8, 2025: 6 @ 5.28
Jan. 29, 2025issueSO-250129-898MAIN 10 5.28-52.845302,800.68 Jan. 8, 2025: 10 @ 5.28
Jan. 21, 2025returnRMAMAIN 3 5.2815.855402,853.52
Jan. 19, 2025issueSO-250119-149MAIN 22 5.28-116.255372,837.67 Jan. 8, 2025: 22 @ 5.28
Jan. 16, 2025issueSO-250116-344MAIN 6 5.28-31.715592,953.92 Jan. 8, 2025: 6 @ 5.28
Jan. 14, 2025issueSO-250114-452MAIN 20 5.28-105.695652,985.63 Jan. 8, 2025: 20 @ 5.28
Jan. 12, 2025issueSO-250112-157EAST 11 5.28-58.135853,091.32 Jan. 8, 2025: 11 @ 5.28
Jan. 10, 2025issueSO-250110-937MAIN 69 5.40-372.495963,149.44 Oct. 1, 2024: 65 @ 5.41; Jan. 8, 2025: 4 @ 5.28
Jan. 8, 2025issueSO-250108-554MAIN 9 5.41-48.656653,521.94 Oct. 1, 2024: 9 @ 5.41
Jan. 8, 2025transferTRFMAIN → EAST 193 warehouse transfer, no cost effect
Jan. 8, 2025receiptPO-000171MAIN 600 5.283,170.586743,570.59
Dec. 31, 2024issueSO-241231-811MAIN 5 5.41-27.0374400.01 Oct. 1, 2024: 5 @ 5.41
Dec. 23, 2024issueSO-241223-722MAIN 27 5.41-145.9579427.03 Oct. 1, 2024: 27 @ 5.41
Dec. 18, 2024issueSO-241218-329MAIN 45 5.41-243.25106572.98 Oct. 1, 2024: 45 @ 5.41
Dec. 9, 2024issueSO-241209-494MAIN 10 5.41-54.06151816.23 Oct. 1, 2024: 10 @ 5.41
Dec. 5, 2024issueSO-241205-965MAIN 103 5.41-556.77161870.29 Oct. 1, 2024: 103 @ 5.41
Nov. 20, 2024issueSO-241120-762MAIN 9 5.41-48.652641,427.05 Oct. 1, 2024: 9 @ 5.41
Nov. 15, 2024issueSO-241115-182MAIN 102 5.41-551.362731,475.70 Oct. 1, 2024: 102 @ 5.41
Nov. 7, 2024issueSO-241107-487MAIN 64 5.41-345.953752,027.06 Oct. 1, 2024: 64 @ 5.41
Nov. 4, 2024issueSO-241104-957MAIN 42 5.41-227.034392,373.01 Oct. 1, 2024: 42 @ 5.41
Oct. 31, 2024issueSO-241031-724MAIN 25 5.41-135.144812,600.05 Oct. 1, 2024: 25 @ 5.41
Oct. 12, 2024issueSO-241012-684MAIN 48 5.41-259.465062,735.18 Oct. 1, 2024: 48 @ 5.41
Oct. 11, 2024issueSO-241011-566MAIN 5 5.41-27.035542,994.65 Oct. 1, 2024: 5 @ 5.41
Oct. 5, 2024issueSO-241005-306MAIN 41 5.41-221.635593,021.67 Oct. 1, 2024: 41 @ 5.41
Oct. 1, 2024receiptPO-000002MAIN 600 5.413,243.306003,243.30