Items / CON-0007
PVC Conduit 25mm Pro CON-0007 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)290MAIN 200, EAST 90
Value (FIFO)3,627.03avg 12.51
ClassBX / FCV 0.26
Turnover5.8xlast issue 3 days ago
Days of cover104lead 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 | 85.17 / 30.4375 | 2.798 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 22.54 / 5.517 | 4.086 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(14.0 * 4.086^2 + 2.798^2 * 3.1^2) | 29.0 |
| Reorder point | d * LT + safety stock | 2.798 * 14.0 + 29.0 | 68.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 68.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1021/yr, S = 45.00, h = 20%, price = 12.55 | 191.4 |
| Inventory position | on hand + on order | 290 + 0 | 290 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 12.55 | 191 | 13,298 | yes (chosen if cheapest) |
MOQ 320, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 2, 2026 | 290 / 320 | 12.51 | 3,627.03 |
Movement ledger 123 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 13, 2026 | issue | SO-261013-802 | MAIN | 23 | 12.51 | -287.66 | 290 | 3,627.03 | Oct. 2, 2026: 23 @ 12.51 |
| Oct. 2, 2026 | issue | SO-261002-565 | MAIN | 40 | 12.33 | -493.37 | 313 | 3,914.69 | June 24, 2026: 33 @ 12.30; Oct. 2, 2026: 7 @ 12.51 |
| Oct. 2, 2026 | transfer | TRF | MAIN → EAST | 90 | warehouse transfer, no cost effect | ||||
| Oct. 2, 2026 | receipt | PO-001844 | MAIN | 320 | 12.51 | 4,002.24 | 353 | 4,408.06 | |
| Oct. 1, 2026 | issue | SO-261001-683 | MAIN | 9 | 12.30 | -110.68 | 33 | 405.82 | June 24, 2026: 9 @ 12.30 |
| Sept. 18, 2026 | issue | SO-260918-632 | MAIN | 69 | 12.30 | -848.53 | 42 | 516.50 | June 24, 2026: 69 @ 12.30 |
| Sept. 13, 2026 | issue | SO-260913-840 | MAIN | 28 | 12.30 | -344.33 | 111 | 1,365.02 | June 24, 2026: 28 @ 12.30 |
| Sept. 10, 2026 | issue | SO-260910-758 | MAIN | 32 | 12.30 | -393.52 | 139 | 1,709.35 | June 24, 2026: 32 @ 12.30 |
| Aug. 30, 2026 | issue | SO-260830-505 | MAIN | 1 | 12.30 | -12.30 | 171 | 2,102.87 | June 24, 2026: 1 @ 12.30 |
| Aug. 29, 2026 | issue | SO-260829-272 | MAIN | 14 | 12.30 | -172.16 | 172 | 2,115.17 | June 24, 2026: 14 @ 12.30 |
| Aug. 26, 2026 | issue | SO-260826-505 | MAIN | 1 | 12.30 | -12.30 | 186 | 2,287.34 | June 24, 2026: 1 @ 12.30 |
| Aug. 21, 2026 | issue | SO-260821-882 | MAIN | 1 | 12.30 | -12.30 | 187 | 2,299.63 | June 24, 2026: 1 @ 12.30 |
| Aug. 14, 2026 | issue | SO-260814-802 | MAIN | 18 | 12.30 | -221.36 | 188 | 2,311.93 | June 24, 2026: 18 @ 12.30 |
| Aug. 9, 2026 | issue | SO-260809-634 | MAIN | 6 | 12.30 | -73.78 | 206 | 2,533.28 | June 24, 2026: 6 @ 12.30 |
| Aug. 3, 2026 | issue | SO-260803-408 | MAIN | 30 | 12.30 | -368.92 | 212 | 2,607.07 | June 24, 2026: 30 @ 12.30 |
| July 29, 2026 | issue | SO-260729-514 | MAIN | 5 | 12.30 | -61.49 | 242 | 2,976.00 | June 24, 2026: 5 @ 12.30 |
| July 24, 2026 | issue | SO-260724-283 | MAIN | 16 | 12.30 | -196.76 | 247 | 3,037.48 | June 24, 2026: 16 @ 12.30 |
| July 18, 2026 | issue | SO-260718-187 | MAIN | 50 | 12.30 | -614.88 | 263 | 3,234.24 | June 24, 2026: 50 @ 12.30 |
| July 10, 2026 | issue | SO-260710-265 | MAIN | 6 | 12.30 | -73.78 | 313 | 3,849.12 | June 24, 2026: 6 @ 12.30 |
| June 29, 2026 | adjustment | Cycle count | MAIN | -1 | 12.30 | -12.30 | 319 | 3,922.90 | June 24, 2026: 1 @ 12.30 |
| June 24, 2026 | receipt | PO-001600 | MAIN | 320 | 12.30 | 3,935.20 | 320 | 3,935.20 | |
| June 21, 2026 | issue | SO-260621-313 | EAST | 8 | 11.97 | -95.73 | 0 | 0.00 | Feb. 23, 2026: 8 @ 11.97 |
| June 16, 2026 | issue | SO-260616-465 | EAST | 13 | 11.97 | -155.57 | 8 | 95.73 | Feb. 23, 2026: 13 @ 11.97 |
| June 12, 2026 | issue | SO-260612-332 | EAST | 66 | 11.97 | -789.80 | 21 | 251.30 | Feb. 23, 2026: 66 @ 11.97 |
| June 12, 2026 | issue | SO-260612-332 | MAIN | 2 | 11.97 | -23.93 | 87 | 1,041.10 | Feb. 23, 2026: 2 @ 11.97 |
| May 28, 2026 | issue | SO-260528-999 | MAIN | 12 | 11.97 | -143.60 | 89 | 1,065.04 | Feb. 23, 2026: 12 @ 11.97 |
| May 25, 2026 | issue | SO-260525-942 | MAIN | 29 | 11.97 | -347.03 | 101 | 1,208.64 | Feb. 23, 2026: 29 @ 11.97 |
| May 16, 2026 | issue | SO-260516-199 | EAST | 22 | 11.97 | -263.27 | 130 | 1,555.67 | Feb. 23, 2026: 22 @ 11.97 |
| May 7, 2026 | issue | SO-260507-624 | MAIN | 14 | 11.97 | -167.53 | 152 | 1,818.94 | Feb. 23, 2026: 14 @ 11.97 |
| May 6, 2026 | issue | SO-260506-142 | MAIN | 1 | 11.97 | -11.97 | 166 | 1,986.47 | Feb. 23, 2026: 1 @ 11.97 |
| April 28, 2026 | issue | SO-260428-278 | MAIN | 5 | 11.97 | -59.83 | 167 | 1,998.44 | Feb. 23, 2026: 5 @ 11.97 |
| April 24, 2026 | issue | SO-260424-681 | MAIN | 47 | 11.97 | -562.43 | 172 | 2,058.27 | Feb. 23, 2026: 47 @ 11.97 |
| April 8, 2026 | issue | SO-260408-928 | MAIN | 21 | 11.97 | -251.30 | 219 | 2,620.71 | Feb. 23, 2026: 21 @ 11.97 |
| April 7, 2026 | issue | SO-260407-813 | MAIN | 1 | 11.97 | -11.97 | 240 | 2,872.01 | Feb. 23, 2026: 1 @ 11.97 |
| March 20, 2026 | issue | SO-260320-177 | MAIN | 13 | 11.97 | -155.57 | 241 | 2,883.97 | Feb. 23, 2026: 13 @ 11.97 |
| March 16, 2026 | issue | SO-260316-503 | MAIN | 3 | 11.97 | -35.90 | 254 | 3,039.54 | Feb. 23, 2026: 3 @ 11.97 |
| March 14, 2026 | issue | SO-260314-931 | MAIN | 31 | 11.97 | -370.97 | 257 | 3,075.44 | Feb. 23, 2026: 31 @ 11.97 |
| March 7, 2026 | issue | SO-260307-708 | MAIN | 23 | 11.97 | -275.23 | 288 | 3,446.41 | Feb. 23, 2026: 23 @ 11.97 |
| March 4, 2026 | issue | SO-260304-230 | MAIN | 9 | 11.97 | -107.70 | 311 | 3,721.64 | Feb. 23, 2026: 9 @ 11.97 |
| Feb. 23, 2026 | transfer | TRF | MAIN → EAST | 109 | warehouse transfer, no cost effect | ||||
| Feb. 23, 2026 | receipt | PO-001253 | MAIN | 320 | 11.97 | 3,829.34 | 320 | 3,829.34 | |
| Feb. 19, 2026 | issue | SO-260219-707 | MAIN | 2 | 11.91 | -23.82 | 0 | 0.00 | Oct. 29, 2025: 2 @ 11.91 |
| Feb. 13, 2026 | issue | SO-260213-737 | MAIN | 49 | 11.91 | -583.63 | 2 | 23.82 | Oct. 29, 2025: 49 @ 11.91 |
| Feb. 4, 2026 | issue | SO-260204-179 | MAIN | 15 | 11.91 | -178.66 | 51 | 607.46 | Oct. 29, 2025: 15 @ 11.91 |
| Feb. 3, 2026 | issue | SO-260203-108 | MAIN | 17 | 11.91 | -202.49 | 66 | 786.12 | Oct. 29, 2025: 17 @ 11.91 |
| Jan. 30, 2026 | issue | SO-260130-171 | MAIN | 9 | 11.91 | -107.20 | 83 | 988.60 | Oct. 29, 2025: 9 @ 11.91 |
| Jan. 26, 2026 | issue | SO-260126-907 | MAIN | 10 | 11.91 | -119.11 | 92 | 1,095.80 | Oct. 29, 2025: 10 @ 11.91 |
| Jan. 25, 2026 | issue | SO-260125-205 | MAIN | 16 | 11.91 | -190.57 | 102 | 1,214.91 | Oct. 29, 2025: 16 @ 11.91 |
| Jan. 13, 2026 | issue | SO-260113-863 | MAIN | 2 | 11.91 | -23.82 | 118 | 1,405.49 | Oct. 29, 2025: 2 @ 11.91 |
| Jan. 7, 2026 | issue | SO-260107-743 | MAIN | 24 | 11.91 | -285.86 | 120 | 1,429.31 | Oct. 29, 2025: 24 @ 11.91 |
| Jan. 6, 2026 | issue | SO-260106-149 | MAIN | 3 | 11.91 | -35.73 | 144 | 1,715.17 | Oct. 29, 2025: 3 @ 11.91 |
| Dec. 30, 2025 | issue | SO-251230-464 | MAIN | 2 | 11.91 | -23.82 | 147 | 1,750.90 | Oct. 29, 2025: 2 @ 11.91 |
| Dec. 28, 2025 | issue | SO-251228-375 | MAIN | 1 | 11.91 | -11.91 | 149 | 1,774.72 | Oct. 29, 2025: 1 @ 11.91 |
| Dec. 27, 2025 | issue | SO-251227-382 | MAIN | 13 | 11.91 | -154.84 | 150 | 1,786.64 | Oct. 29, 2025: 13 @ 11.91 |
| Dec. 22, 2025 | issue | SO-251222-349 | MAIN | 17 | 11.91 | -202.49 | 163 | 1,941.48 | Oct. 29, 2025: 17 @ 11.91 |
| Dec. 8, 2025 | issue | SO-251208-313 | MAIN | 33 | 11.91 | -393.06 | 180 | 2,143.96 | Oct. 29, 2025: 33 @ 11.91 |
| Dec. 7, 2025 | issue | SO-251207-552 | MAIN | 7 | 11.91 | -83.38 | 213 | 2,537.02 | Oct. 29, 2025: 7 @ 11.91 |
| Dec. 2, 2025 | issue | SO-251202-755 | MAIN | 15 | 11.91 | -178.66 | 220 | 2,620.40 | Oct. 29, 2025: 15 @ 11.91 |
| Dec. 2, 2025 | issue | SO-251202-755 | EAST | 42 | 11.91 | -500.26 | 235 | 2,799.06 | Oct. 29, 2025: 42 @ 11.91 |
| Nov. 30, 2025 | issue | SO-251130-442 | MAIN | 4 | 11.91 | -47.64 | 277 | 3,299.32 | Oct. 29, 2025: 4 @ 11.91 |