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
actual forecast 90% prediction interval
No forecast run yet for this item. Run forecasts. Policy numbers use trailing 12-month demand.
Policy numbers explained
| Metric | Formula | Substituted | Result |
|---|---|---|---|
| Daily demand d | monthly mean / 30.4375 | 76.92 / 30.4375 | 2.527 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 16.32 / 5.517 | 2.958 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * 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 point | d * LT + safety stock | 2.527 * 14.0 + 27.9 | 63.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 63.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 922/yr, S = 45.00, h = 20%, price = 49.65 | 91.4 |
| Inventory position | on hand + on order | 72 + 0 | 72 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 49.65 | 91 | 46,704 | yes (chosen if cheapest) |
| 640 | 47.66 | 640 | 47,079 | yes |
| 1,280 | 45.68 | 1,280 | 48,011 | yes |
MOQ 320, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 17, 2026 | 57 / 320 | 48.11 | 2,742.29 | |
| Aug. 9, 2026 | 3 / 3 | 48.11 | 144.33 | |
| Aug. 19, 2026 | 12 / 12 | 48.11 | 577.32 |
Movement ledger 117 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 8, 2026 | issue | SO-261008-264 | MAIN | 54 | 48.11 | -2,597.96 | 72 | 3,463.94 | July 17, 2026: 54 @ 48.11 |
| Oct. 3, 2026 | issue | SO-261003-804 | MAIN | 14 | 48.11 | -673.54 | 126 | 6,061.90 | July 17, 2026: 14 @ 48.11 |
| Sept. 28, 2026 | issue | SO-260928-864 | MAIN | 28 | 48.11 | -1,347.09 | 140 | 6,735.44 | July 17, 2026: 28 @ 48.11 |
| Sept. 21, 2026 | issue | SO-260921-564 | MAIN | 55 | 48.11 | -2,646.07 | 168 | 8,082.53 | July 17, 2026: 55 @ 48.11 |
| Sept. 10, 2026 | issue | SO-260910-813 | MAIN | 15 | 48.11 | -721.65 | 223 | 10,728.60 | July 17, 2026: 15 @ 48.11 |
| Aug. 19, 2026 | return | RMA | MAIN | 12 | 48.11 | 577.32 | 238 | 11,450.25 | |
| Aug. 9, 2026 | return | RMA | MAIN | 3 | 48.11 | 144.33 | 226 | 10,872.93 | |
| Aug. 7, 2026 | issue | SO-260807-154 | MAIN | 2 | 48.11 | -96.22 | 223 | 10,728.60 | July 17, 2026: 2 @ 48.11 |
| Aug. 3, 2026 | issue | SO-260803-891 | MAIN | 24 | 48.11 | -1,154.65 | 225 | 10,824.82 | July 17, 2026: 24 @ 48.11 |
| Aug. 2, 2026 | issue | SO-260802-305 | MAIN | 61 | 48.11 | -2,934.73 | 249 | 11,979.46 | July 17, 2026: 61 @ 48.11 |
| July 29, 2026 | issue | SO-260729-365 | MAIN | 5 | 48.11 | -240.55 | 310 | 14,914.19 | July 17, 2026: 5 @ 48.11 |
| July 28, 2026 | issue | SO-260728-311 | MAIN | 22 | 49.40 | -1,086.90 | 315 | 15,154.74 | March 10, 2026: 13 @ 49.79; May 24, 2026: 4 @ 49.79; July 17, 2026: 5 @ 48.11 |
| July 23, 2026 | issue | SO-260723-743 | MAIN | 6 | 49.79 | -298.71 | 337 | 16,241.65 | March 10, 2026: 6 @ 49.79 |
| July 18, 2026 | issue | SO-260718-772 | EAST | 13 | 49.79 | -647.21 | 343 | 16,540.36 | March 10, 2026: 13 @ 49.79 |
| July 17, 2026 | receipt | PO-001652 | MAIN | 320 | 48.11 | 15,395.30 | 356 | 17,187.57 | |
| July 10, 2026 | issue | SO-260710-702 | EAST | 11 | 49.79 | -547.64 | 36 | 1,792.27 | March 10, 2026: 11 @ 49.79 |
| July 8, 2026 | issue | SO-260708-393 | MAIN | 5 | 49.79 | -248.93 | 47 | 2,339.91 | March 10, 2026: 5 @ 49.79 |
| July 1, 2026 | issue | SO-260701-749 | EAST | 10 | 49.79 | -497.85 | 52 | 2,588.84 | March 10, 2026: 10 @ 49.79 |
| June 21, 2026 | issue | SO-260621-814 | EAST | 16 | 49.79 | -796.56 | 62 | 3,086.69 | March 10, 2026: 16 @ 49.79 |
| June 17, 2026 | issue | SO-260617-584 | MAIN | 35 | 49.79 | -1,742.49 | 78 | 3,883.25 | March 10, 2026: 35 @ 49.79 |
| May 31, 2026 | issue | SO-260531-237 | EAST | 5 | 49.79 | -248.93 | 113 | 5,625.74 | March 10, 2026: 5 @ 49.79 |
| May 24, 2026 | return | RMA | MAIN | 4 | 49.79 | 199.14 | 118 | 5,874.67 | |
| May 22, 2026 | issue | SO-260522-510 | MAIN | 24 | 49.79 | -1,194.85 | 114 | 5,675.52 | March 10, 2026: 24 @ 49.79 |
| May 21, 2026 | issue | SO-260521-788 | MAIN | 2 | 49.79 | -99.57 | 138 | 6,870.37 | March 10, 2026: 2 @ 49.79 |
| May 7, 2026 | issue | SO-260507-479 | EAST | 9 | 49.79 | -448.07 | 140 | 6,969.94 | March 10, 2026: 9 @ 49.79 |
| May 3, 2026 | issue | SO-260503-346 | MAIN | 48 | 49.79 | -2,389.69 | 149 | 7,418.01 | March 10, 2026: 48 @ 49.79 |
| April 27, 2026 | issue | SO-260427-676 | MAIN | 21 | 49.79 | -1,045.49 | 197 | 9,807.70 | March 10, 2026: 21 @ 49.79 |
| April 26, 2026 | issue | SO-260426-510 | MAIN | 16 | 49.79 | -796.56 | 218 | 10,853.20 | March 10, 2026: 16 @ 49.79 |
| April 24, 2026 | issue | SO-260424-718 | MAIN | 10 | 49.79 | -497.85 | 234 | 11,649.76 | March 10, 2026: 10 @ 49.79 |
| April 13, 2026 | issue | SO-260413-858 | MAIN | 16 | 49.79 | -796.56 | 244 | 12,147.61 | March 10, 2026: 16 @ 49.79 |
| April 8, 2026 | issue | SO-260408-791 | EAST | 26 | 49.79 | -1,294.42 | 260 | 12,944.18 | March 10, 2026: 26 @ 49.79 |
| March 31, 2026 | issue | SO-260331-633 | EAST | 5 | 49.79 | -248.93 | 286 | 14,238.60 | March 10, 2026: 5 @ 49.79 |
| March 30, 2026 | issue | SO-260330-355 | MAIN | 19 | 49.79 | -945.92 | 291 | 14,487.52 | March 10, 2026: 19 @ 49.79 |
| March 27, 2026 | issue | SO-260327-961 | MAIN | 19 | 48.24 | -916.54 | 310 | 15,433.44 | Nov. 1, 2025: 9 @ 46.52; March 10, 2026: 10 @ 49.79 |
| March 25, 2026 | issue | SO-260325-621 | MAIN | 6 | 46.52 | -279.13 | 329 | 16,349.99 | Nov. 1, 2025: 6 @ 46.52 |
| March 22, 2026 | issue | SO-260322-498 | MAIN | 29 | 46.52 | -1,349.11 | 335 | 16,629.11 | Nov. 1, 2025: 29 @ 46.52 |
| March 10, 2026 | transfer | TRF | MAIN → EAST | 104 | warehouse transfer, no cost effect | ||||
| March 10, 2026 | receipt | PO-001303 | MAIN | 320 | 49.79 | 15,931.30 | 364 | 17,978.23 | |
| March 8, 2026 | issue | SO-260308-670 | MAIN | 7 | 46.52 | -325.65 | 44 | 2,046.93 | Nov. 1, 2025: 7 @ 46.52 |
| Feb. 19, 2026 | issue | SO-260219-428 | MAIN | 45 | 46.52 | -2,093.45 | 51 | 2,372.58 | Nov. 1, 2025: 45 @ 46.52 |
| Feb. 14, 2026 | issue | SO-260214-577 | MAIN | 30 | 46.52 | -1,395.64 | 96 | 4,466.04 | Nov. 1, 2025: 30 @ 46.52 |
| Feb. 10, 2026 | issue | SO-260210-328 | MAIN | 27 | 46.52 | -1,256.07 | 126 | 5,861.67 | Nov. 1, 2025: 27 @ 46.52 |
| Feb. 2, 2026 | issue | SO-260202-533 | MAIN | 8 | 46.52 | -372.17 | 153 | 7,117.74 | Nov. 1, 2025: 8 @ 46.52 |
| Jan. 25, 2026 | issue | SO-260125-470 | MAIN | 19 | 46.52 | -883.90 | 161 | 7,489.91 | Nov. 1, 2025: 19 @ 46.52 |
| Jan. 11, 2026 | issue | SO-260111-376 | MAIN | 53 | 46.52 | -2,465.62 | 180 | 8,373.82 | Nov. 1, 2025: 53 @ 46.52 |
| Jan. 7, 2026 | issue | SO-260107-172 | MAIN | 4 | 46.52 | -186.08 | 233 | 10,839.44 | Nov. 1, 2025: 4 @ 46.52 |
| Dec. 21, 2025 | issue | SO-251221-144 | MAIN | 19 | 46.52 | -883.90 | 237 | 11,025.52 | Nov. 1, 2025: 19 @ 46.52 |
| Dec. 16, 2025 | issue | SO-251216-296 | MAIN | 21 | 46.52 | -976.95 | 256 | 11,909.43 | Nov. 1, 2025: 21 @ 46.52 |
| Dec. 15, 2025 | issue | SO-251215-934 | MAIN | 7 | 46.52 | -325.65 | 277 | 12,886.37 | Nov. 1, 2025: 7 @ 46.52 |
| Dec. 12, 2025 | issue | SO-251212-369 | MAIN | 4 | 46.52 | -186.08 | 284 | 13,212.02 | Nov. 1, 2025: 4 @ 46.52 |
| Dec. 10, 2025 | issue | SO-251210-249 | MAIN | 4 | 46.52 | -186.08 | 288 | 13,398.11 | Nov. 1, 2025: 4 @ 46.52 |
| Dec. 3, 2025 | issue | SO-251203-798 | MAIN | 5 | 46.52 | -232.61 | 292 | 13,584.19 | Nov. 1, 2025: 5 @ 46.52 |
| Dec. 1, 2025 | issue | SO-251201-134 | MAIN | 3 | 46.52 | -139.56 | 297 | 13,816.80 | Nov. 1, 2025: 3 @ 46.52 |
| Nov. 27, 2025 | issue | SO-251127-387 | MAIN | 9 | 46.52 | -418.69 | 300 | 13,956.36 | Nov. 1, 2025: 9 @ 46.52 |
| Nov. 17, 2025 | issue | SO-251117-100 | MAIN | 12 | 46.66 | -559.98 | 309 | 14,375.05 | July 4, 2025: 1 @ 48.24; Nov. 1, 2025: 11 @ 46.52 |
| Nov. 10, 2025 | issue | SO-251110-995 | MAIN | 39 | 48.24 | -1,881.44 | 321 | 14,935.03 | June 27, 2025: 26 @ 48.24; July 4, 2025: 13 @ 48.24 |
| Nov. 1, 2025 | receipt | PO-000971 | MAIN | 320 | 46.52 | 14,886.78 | 360 | 16,816.46 | |
| Oct. 19, 2025 | issue | SO-251019-530 | MAIN | 57 | 48.24 | -2,749.79 | 40 | 1,929.68 | June 27, 2025: 57 @ 48.24 |
| Oct. 17, 2025 | issue | SO-251017-533 | MAIN | 6 | 48.24 | -289.45 | 97 | 4,679.47 | June 27, 2025: 6 @ 48.24 |
| Sept. 27, 2025 | issue | SO-250927-264 | MAIN | 35 | 48.24 | -1,688.47 | 103 | 4,968.93 | June 27, 2025: 35 @ 48.24 |