stocksense

Items / CON-0008

Clamp 25mm Lite CON-0008 · Conduit & Fittings · Conduit & Cable Co

On hand (EA)100MAIN 100
Value (FIFO)5,759.74avg 57.60
ClassBX / FCV 0.26
Turnover7.8xlast issue 1 days ago
Days of cover81lead time 14d

Demand and forecast

Monthly demand and forecast for CON-00080.014.929.744.659.4Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 33.0Nov 24: 54.0Dec 24: 45.0Jan 25: 42.0Feb 25: 34.0Mar 25: 34.0Apr 25: 53.0May 25: 53.0Jun 25: 33.0Jul 25: 37.0Aug 25: 33.0Sep 25: 41.0Oct 25: 46.0Nov 25: 38.0Dec 25: 23.0Jan 26: 34.0Feb 26: 38.0Mar 26: 38.0Apr 26: 50.0May 26: 54.0Jun 26: 22.0Jul 26: 41.0Aug 26: 25.0Sep 26: 40.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.437537.42 / 30.43751.229
Daily demand sdmonthly sd / sqrt(30.4375)9.74 / 5.5171.766
Service level / zz = Phi^-1(service level)Phi^-1(0.950)1.645
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.645 * sqrt(14.0 * 1.766^2 + 1.229^2 * 3.1^2)12.6
Reorder pointd * LT + safety stock1.229 * 14.0 + 12.629.8
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days29.8
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 449/yr, S = 45.00, h = 20%, price = 59.6558.2
Inventory positionon hand + on order100 + 0100

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

From qtyUnit costOrder qtyAnnual costFeasible
059.655827,459yes (chosen if cheapest)

MOQ 180, pack size 20, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
July 27, 202690 / 18057.605,183.77
Aug. 20, 202610 / 1057.60575.97

Movement ledger 120 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-889MAIN 1 57.60-57.601005,759.74 July 27, 2026: 1 @ 57.60
Oct. 12, 2026issueSO-261012-650MAIN 4 57.60-230.391015,817.34 July 27, 2026: 4 @ 57.60
Oct. 11, 2026issueSO-261011-708MAIN 4 57.60-230.391056,047.73 July 27, 2026: 4 @ 57.60
Oct. 7, 2026issueSO-261007-232MAIN 4 57.60-230.391096,278.12 July 27, 2026: 4 @ 57.60
Oct. 5, 2026issueSO-261005-844MAIN 24 57.60-1,382.341136,508.51 July 27, 2026: 24 @ 57.60
Oct. 3, 2026issueSO-261003-617MAIN 1 57.60-57.601377,890.84 July 27, 2026: 1 @ 57.60
Oct. 2, 2026issueSO-261002-319MAIN 1 57.60-57.601387,948.44 July 27, 2026: 1 @ 57.60
Sept. 21, 2026issueSO-260921-601MAIN 9 57.60-518.381398,006.04 July 27, 2026: 9 @ 57.60
Sept. 19, 2026issueSO-260919-468MAIN 1 57.60-57.601488,524.42 July 27, 2026: 1 @ 57.60
Sept. 9, 2026issueSO-260909-701MAIN 29 57.60-1,670.321498,582.01 July 27, 2026: 29 @ 57.60
Sept. 2, 2026issueSO-260902-897MAIN 1 57.60-57.6017810,252.34 July 27, 2026: 1 @ 57.60
Aug. 20, 2026returnRMAMAIN 10 57.60575.9717910,309.93
Aug. 12, 2026issueSO-260812-541MAIN 2 57.60-115.191699,733.96 July 27, 2026: 2 @ 57.60
Aug. 11, 2026issueSO-260811-171MAIN 4 57.60-230.391719,849.16 July 27, 2026: 4 @ 57.60
Aug. 9, 2026issueSO-260809-492MAIN 1 57.60-57.6017510,079.54 July 27, 2026: 1 @ 57.60
Aug. 3, 2026issueSO-260803-370MAIN 20 56.96-1,139.2117610,137.14 April 3, 2026: 16 @ 56.80; July 27, 2026: 4 @ 57.60
Aug. 2, 2026issueSO-260802-308MAIN 8 56.80-454.4119611,276.35 April 3, 2026: 8 @ 56.80
July 27, 2026receiptPO-001678MAIN 180 57.6010,367.5320411,730.77
July 18, 2026issueSO-260718-217MAIN 3 56.80-170.40241,363.23 April 3, 2026: 3 @ 56.80
July 9, 2026issueSO-260709-994MAIN 2 56.80-113.60271,533.64 April 3, 2026: 2 @ 56.80
July 8, 2026issueSO-260708-220MAIN 14 56.80-795.22291,647.24 April 3, 2026: 14 @ 56.80
July 5, 2026issueSO-260705-561MAIN 1 56.80-56.80432,442.46 April 3, 2026: 1 @ 56.80
July 2, 2026issueSO-260702-458MAIN 21 56.80-1,192.83442,499.26 April 3, 2026: 21 @ 56.80
June 27, 2026issueSO-260627-674MAIN 2 56.80-113.60653,692.09 April 3, 2026: 2 @ 56.80
June 6, 2026issueSO-260606-162MAIN 3 56.80-170.40673,805.69 April 3, 2026: 3 @ 56.80
June 5, 2026issueSO-260605-360MAIN 16 56.80-908.82703,976.10 April 3, 2026: 16 @ 56.80
June 2, 2026issueSO-260602-199MAIN 1 56.80-56.80864,884.92 April 3, 2026: 1 @ 56.80
May 31, 2026issueSO-260531-144MAIN 4 56.80-227.21874,941.72 April 3, 2026: 4 @ 56.80
May 10, 2026issueSO-260510-440MAIN 49 56.80-2,783.27915,168.93 April 3, 2026: 49 @ 56.80
May 7, 2026issueSO-260507-894MAIN 1 56.80-56.801407,952.20 April 3, 2026: 1 @ 56.80
April 14, 2026issueSO-260414-584MAIN 3 56.80-170.401418,009.00 April 3, 2026: 3 @ 56.80
April 9, 2026issueSO-260409-548MAIN 31 56.80-1,760.841448,179.40 April 3, 2026: 31 @ 56.80
April 8, 2026issueSO-260408-674MAIN 5 56.80-284.011759,940.24 April 3, 2026: 5 @ 56.80
April 3, 2026receiptPO-001380MAIN 180 56.8010,224.2518010,224.25
April 2, 2026issueSO-260402-748MAIN 11 55.85-614.3900.00 Oct. 21, 2025: 1 @ 55.85; Dec. 3, 2025: 10 @ 55.85
March 29, 2026issueSO-260329-803MAIN 1 55.85-55.8511614.39 Oct. 21, 2025: 1 @ 55.85
March 28, 2026issueSO-260328-761MAIN 9 55.85-502.6812670.24 Oct. 21, 2025: 9 @ 55.85
March 27, 2026issueSO-260327-608MAIN 6 55.85-335.12211,172.92 Oct. 21, 2025: 6 @ 55.85
March 21, 2026issueSO-260321-717MAIN 7 55.85-390.97271,508.04 Oct. 21, 2025: 7 @ 55.85
March 16, 2026issueSO-260316-209MAIN 6 55.85-335.12341,899.01 Oct. 21, 2025: 6 @ 55.85
March 7, 2026issueSO-260307-846MAIN 9 55.85-502.68402,234.13 Oct. 21, 2025: 9 @ 55.85
Feb. 21, 2026issueSO-260221-564MAIN 20 55.85-1,117.07492,736.81 Oct. 21, 2025: 20 @ 55.85
Feb. 19, 2026issueSO-260219-809MAIN 1 55.85-55.85693,853.88 Oct. 21, 2025: 1 @ 55.85
Feb. 15, 2026issueSO-260215-246MAIN 14 55.85-781.95703,909.73 Oct. 21, 2025: 14 @ 55.85
Feb. 9, 2026issueSO-260209-256MAIN 1 55.85-55.85844,691.68 Oct. 21, 2025: 1 @ 55.85
Feb. 3, 2026issueSO-260203-538MAIN 2 55.85-111.71854,747.53 Oct. 21, 2025: 2 @ 55.85
Jan. 31, 2026issueSO-260131-439MAIN 2 55.85-111.71874,859.24 Oct. 21, 2025: 2 @ 55.85
Jan. 31, 2026issueSO-260131-439EAST 6 55.85-335.12894,970.94 Oct. 21, 2025: 6 @ 55.85
Jan. 28, 2026issueSO-260128-354MAIN 26 55.85-1,452.19955,306.06 Oct. 21, 2025: 26 @ 55.85
Dec. 21, 2025issueSO-251221-597MAIN 1 55.85-55.851216,758.25 Oct. 21, 2025: 1 @ 55.85
Dec. 11, 2025issueSO-251211-198MAIN 3 55.85-167.561226,814.10 Oct. 21, 2025: 3 @ 55.85
Dec. 10, 2025issueSO-251210-644MAIN 12 55.85-670.241256,981.66 Oct. 21, 2025: 12 @ 55.85
Dec. 9, 2025issueSO-251209-821MAIN 4 55.85-223.411377,651.90 Oct. 21, 2025: 4 @ 55.85
Dec. 5, 2025issueSO-251205-434MAIN 11 55.85-614.391417,875.32 Oct. 21, 2025: 11 @ 55.85
Dec. 4, 2025issueSO-251204-792MAIN 2 55.85-111.711528,489.70 Oct. 21, 2025: 2 @ 55.85
Dec. 3, 2025returnRMAMAIN 10 55.85558.531548,601.41
Nov. 28, 2025issueSO-251128-307MAIN 7 55.85-390.971448,042.88 Oct. 21, 2025: 7 @ 55.85
Nov. 25, 2025issueSO-251125-978EAST 20 55.85-1,117.071518,433.85 Oct. 21, 2025: 20 @ 55.85
Nov. 24, 2025issueSO-251124-348MAIN 11 55.98-615.771719,550.91 June 12, 2025: 2 @ 56.55; Oct. 21, 2025: 9 @ 55.85
Oct. 22, 2025issueSO-251022-324EAST 21 55.63-1,168.2318210,166.69 June 7, 2025: 13 @ 55.07; June 12, 2025: 8 @ 56.55
Oct. 21, 2025transferTRFMAIN → EAST 47 warehouse transfer, no cost effect
Oct. 21, 2025receiptPO-000937MAIN 180 55.8510,053.5920311,334.91
Oct. 10, 2025issueSO-251010-739MAIN 25 55.07-1,376.65231,281.32 June 7, 2025: 25 @ 55.07
Sept. 26, 2025issueSO-250926-559MAIN 13 55.07-715.86482,657.97 June 7, 2025: 13 @ 55.07
Sept. 24, 2025issueSO-250924-215MAIN 7 55.07-385.46613,373.83 June 7, 2025: 7 @ 55.07
Sept. 23, 2025issueSO-250923-264MAIN 6 55.07-330.40683,759.29 June 7, 2025: 6 @ 55.07
Sept. 9, 2025issueSO-250909-696MAIN 8 55.07-440.53744,089.68 June 7, 2025: 8 @ 55.07
Sept. 2, 2025issueSO-250902-904MAIN 7 55.07-385.46824,530.21 June 7, 2025: 7 @ 55.07
Aug. 21, 2025issueSO-250821-261MAIN 11 55.07-605.73894,915.67 June 7, 2025: 11 @ 55.07
Aug. 14, 2025issueSO-250814-297MAIN 22 55.07-1,211.451005,521.40 June 7, 2025: 22 @ 55.07
July 31, 2025issueSO-250731-134MAIN 22 55.07-1,211.451226,732.85 June 7, 2025: 22 @ 55.07
July 21, 2025issueSO-250721-663MAIN 4 55.07-220.261447,944.30 June 7, 2025: 4 @ 55.07
July 18, 2025issueSO-250718-536MAIN 2 55.07-110.131488,164.57 June 7, 2025: 2 @ 55.07
July 17, 2025issueSO-250717-929MAIN 4 55.07-220.261508,274.70 June 7, 2025: 4 @ 55.07
July 15, 2025issueSO-250715-869MAIN 5 55.07-275.331548,494.96 June 7, 2025: 5 @ 55.07
June 29, 2025issueSO-250629-132MAIN 14 55.07-770.921598,770.29 June 7, 2025: 14 @ 55.07
June 25, 2025issueSO-250625-955MAIN 3 55.07-165.201739,541.22 June 7, 2025: 3 @ 55.07
June 19, 2025issueSO-250619-843MAIN 23 55.65-1,279.841769,706.42 Jan. 29, 2025: 1 @ 56.55; May 16, 2025: 8 @ 56.55; June 7, 2025: 14 @ 55.07
June 15, 2025issueSO-250615-132MAIN 1 56.55-56.5519910,986.25 Jan. 29, 2025: 1 @ 56.55
June 12, 2025returnRMAMAIN 10 56.55565.4620011,042.80
June 7, 2025receiptPO-000611MAIN 180 55.079,911.8819010,477.34
June 3, 2025issueSO-250603-752MAIN 2 56.55-113.0910565.46 Jan. 29, 2025: 2 @ 56.55
May 30, 2025issueSO-250530-379MAIN 1 56.55-56.5512678.55 Jan. 29, 2025: 1 @ 56.55
May 28, 2025issueSO-250528-944MAIN 9 56.55-508.9113735.10 Jan. 29, 2025: 9 @ 56.55
May 26, 2025issueSO-250526-955MAIN 21 56.55-1,187.47221,244.01 Jan. 29, 2025: 21 @ 56.55
May 16, 2025returnRMAMAIN 8 56.55452.37432,431.48
May 15, 2025issueSO-250515-894MAIN 2 56.55-113.09351,979.11 Jan. 29, 2025: 2 @ 56.55
May 10, 2025issueSO-250510-737MAIN 17 56.55-961.28372,092.20 Jan. 29, 2025: 17 @ 56.55
May 7, 2025issueSO-250507-507MAIN 11 56.55-622.01543,053.48 Jan. 29, 2025: 11 @ 56.55
April 18, 2025issueSO-250418-770MAIN 10 56.55-565.46653,675.49 Jan. 29, 2025: 10 @ 56.55
April 15, 2025issueSO-250415-627MAIN 6 56.55-339.28754,240.95 Jan. 29, 2025: 6 @ 56.55
April 13, 2025issueSO-250413-598MAIN 11 56.55-622.01814,580.23 Jan. 29, 2025: 11 @ 56.55
April 11, 2025issueSO-250411-526MAIN 1 56.55-56.55925,202.23 Jan. 29, 2025: 1 @ 56.55
April 10, 2025issueSO-250410-300MAIN 6 56.55-339.28935,258.78 Jan. 29, 2025: 6 @ 56.55
April 2, 2025issueSO-250402-281MAIN 19 56.55-1,074.37995,598.05 Jan. 29, 2025: 19 @ 56.55
March 28, 2025issueSO-250328-656MAIN 9 56.55-508.911186,672.43 Jan. 29, 2025: 9 @ 56.55
March 6, 2025issueSO-250306-277MAIN 15 56.55-848.191277,181.34 Jan. 29, 2025: 15 @ 56.55
March 4, 2025issueSO-250304-269MAIN 4 56.55-226.181428,029.53 Jan. 29, 2025: 4 @ 56.55
March 2, 2025issueSO-250302-432MAIN 6 56.55-339.281468,255.72 Jan. 29, 2025: 6 @ 56.55
Feb. 11, 2025issueSO-250211-862MAIN 25 56.55-1,413.651528,594.99 Jan. 29, 2025: 25 @ 56.55
Feb. 1, 2025issueSO-250201-239MAIN 9 56.63-509.6417710,008.64 Oct. 1, 2024: 6 @ 56.67; Jan. 29, 2025: 3 @ 56.55
Jan. 29, 2025receiptPO-000227MAIN 180 56.5510,178.2818610,518.28
Jan. 21, 2025issueSO-250121-119MAIN 3 56.67-170.006340.00 Oct. 1, 2024: 3 @ 56.67
Jan. 15, 2025issueSO-250115-417MAIN 29 56.67-1,643.369510.01 Oct. 1, 2024: 29 @ 56.67
Jan. 9, 2025issueSO-250109-455MAIN 10 56.67-566.68382,153.36 Oct. 1, 2024: 10 @ 56.67
Dec. 28, 2024issueSO-241228-477MAIN 14 56.67-793.34482,720.04 Oct. 1, 2024: 14 @ 56.67
Dec. 23, 2024issueSO-241223-533MAIN 8 56.67-453.34623,513.38 Oct. 1, 2024: 8 @ 56.67
Dec. 2, 2024issueSO-241202-789MAIN 23 56.67-1,303.35703,966.72 Oct. 1, 2024: 23 @ 56.67
Nov. 22, 2024issueSO-241122-337MAIN 9 56.67-510.01935,270.08 Oct. 1, 2024: 9 @ 56.67
Nov. 17, 2024issueSO-241117-717MAIN 1 56.67-56.671025,780.08 Oct. 1, 2024: 1 @ 56.67
Nov. 14, 2024issueSO-241114-619MAIN 9 56.67-510.011035,836.75 Oct. 1, 2024: 9 @ 56.67
Nov. 13, 2024issueSO-241113-624MAIN 13 56.67-736.681126,346.76 Oct. 1, 2024: 13 @ 56.67
Nov. 7, 2024issueSO-241107-352MAIN 15 56.67-850.011257,083.44 Oct. 1, 2024: 15 @ 56.67
Nov. 3, 2024issueSO-241103-933MAIN 3 56.67-170.001407,933.45 Oct. 1, 2024: 3 @ 56.67
Nov. 2, 2024issueSO-241102-271MAIN 4 56.67-226.671438,103.45 Oct. 1, 2024: 4 @ 56.67
Oct. 26, 2024issueSO-241026-349MAIN 8 56.67-453.341478,330.12 Oct. 1, 2024: 8 @ 56.67
Oct. 25, 2024issueSO-241025-387MAIN 3 56.67-170.001558,783.46 Oct. 1, 2024: 3 @ 56.67
Oct. 5, 2024issueSO-241005-669MAIN 19 56.67-1,076.681588,953.46 Oct. 1, 2024: 19 @ 56.67
Oct. 3, 2024issueSO-241003-236MAIN 3 56.67-170.0017710,030.15 Oct. 1, 2024: 3 @ 56.67
Oct. 1, 2024receiptPO-000002MAIN 180 56.6710,200.1518010,200.15