Items / CON-0012
PVC Conduit 20mm Pro CON-0012 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)39MAIN 39
Value (FIFO)1,254.23avg 32.16
ClassBX / FCV 0.24
Turnover13.8xlast issue 10 days ago
Days of cover24lead 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 | 49.67 / 30.4375 | 1.632 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 12.02 / 5.517 | 2.178 |
| 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 * 2.178^2 + 1.632^2 * 3.1^2) | 15.8 |
| Reorder point | d * LT + safety stock | 1.632 * 14.0 + 15.8 | 38.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 38.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 596/yr, S = 45.00, h = 20%, price = 32.08 | 91.4 |
| Inventory position | on hand + on order | 39 + 0 | 39 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 32.08 | 91 | 19,693 | yes (chosen if cheapest) |
MOQ 200, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 3, 2026 | 39 / 200 | 32.16 | 1,254.23 |
Movement ledger 121 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 6, 2026 | issue | SO-261006-729 | MAIN | 6 | 32.16 | -192.96 | 39 | 1,254.23 | July 3, 2026: 6 @ 32.16 |
| Oct. 5, 2026 | issue | SO-261005-203 | MAIN | 2 | 32.16 | -64.32 | 45 | 1,447.19 | July 3, 2026: 2 @ 32.16 |
| Oct. 4, 2026 | issue | SO-261004-173 | MAIN | 41 | 32.16 | -1,318.55 | 47 | 1,511.51 | July 3, 2026: 41 @ 32.16 |
| Sept. 23, 2026 | issue | SO-260923-142 | MAIN | 6 | 32.16 | -192.96 | 88 | 2,830.06 | July 3, 2026: 6 @ 32.16 |
| Sept. 9, 2026 | issue | SO-260909-662 | MAIN | 30 | 32.16 | -964.79 | 94 | 3,023.02 | July 3, 2026: 30 @ 32.16 |
| Sept. 2, 2026 | issue | SO-260902-326 | MAIN | 3 | 32.16 | -96.48 | 124 | 3,987.82 | July 3, 2026: 3 @ 32.16 |
| Aug. 15, 2026 | issue | SO-260815-365 | MAIN | 40 | 32.16 | -1,286.39 | 127 | 4,084.29 | July 3, 2026: 40 @ 32.16 |
| Aug. 14, 2026 | issue | SO-260814-499 | MAIN | 8 | 32.16 | -257.28 | 167 | 5,370.69 | July 3, 2026: 8 @ 32.16 |
| July 30, 2026 | issue | SO-260730-334 | MAIN | 5 | 32.16 | -160.80 | 175 | 5,627.96 | July 3, 2026: 5 @ 32.16 |
| July 24, 2026 | issue | SO-260724-626 | MAIN | 1 | 32.16 | -32.16 | 180 | 5,788.76 | July 3, 2026: 1 @ 32.16 |
| July 22, 2026 | issue | SO-260722-111 | MAIN | 5 | 32.16 | -160.80 | 181 | 5,820.92 | July 3, 2026: 5 @ 32.16 |
| July 20, 2026 | issue | SO-260720-179 | MAIN | 7 | 32.16 | -225.12 | 186 | 5,981.72 | July 3, 2026: 7 @ 32.16 |
| July 13, 2026 | issue | SO-260713-922 | MAIN | 10 | 31.64 | -316.44 | 193 | 6,206.84 | March 31, 2026: 3 @ 30.44; July 3, 2026: 7 @ 32.16 |
| July 8, 2026 | issue | SO-260708-895 | MAIN | 4 | 30.44 | -121.77 | 203 | 6,523.28 | March 31, 2026: 4 @ 30.44 |
| July 3, 2026 | receipt | PO-001622 | MAIN | 200 | 32.16 | 6,431.96 | 207 | 6,645.05 | |
| July 2, 2026 | issue | SO-260702-773 | MAIN | 2 | 30.44 | -60.88 | 7 | 213.09 | March 31, 2026: 2 @ 30.44 |
| June 27, 2026 | adjustment | Cycle count | MAIN | -1 | 30.44 | -30.44 | 9 | 273.97 | March 31, 2026: 1 @ 30.44 |
| June 24, 2026 | issue | SO-260624-347 | MAIN | 6 | 30.44 | -182.65 | 10 | 304.41 | March 31, 2026: 6 @ 30.44 |
| June 22, 2026 | issue | SO-260622-974 | MAIN | 37 | 30.44 | -1,126.33 | 16 | 487.06 | March 31, 2026: 37 @ 30.44 |
| June 18, 2026 | issue | SO-260618-251 | MAIN | 4 | 30.44 | -121.77 | 53 | 1,613.39 | March 31, 2026: 4 @ 30.44 |
| May 19, 2026 | issue | SO-260519-911 | MAIN | 1 | 30.44 | -30.44 | 57 | 1,735.15 | March 31, 2026: 1 @ 30.44 |
| May 11, 2026 | issue | SO-260511-109 | MAIN | 3 | 30.44 | -91.32 | 58 | 1,765.60 | March 31, 2026: 3 @ 30.44 |
| May 6, 2026 | issue | SO-260506-711 | MAIN | 46 | 30.44 | -1,400.30 | 61 | 1,856.92 | March 31, 2026: 46 @ 30.44 |
| May 3, 2026 | issue | SO-260503-620 | MAIN | 20 | 30.44 | -608.83 | 107 | 3,257.22 | March 31, 2026: 20 @ 30.44 |
| April 11, 2026 | issue | SO-260411-448 | MAIN | 20 | 30.44 | -608.83 | 127 | 3,866.05 | March 31, 2026: 20 @ 30.44 |
| April 7, 2026 | issue | SO-260407-620 | MAIN | 54 | 30.44 | -1,643.60 | 147 | 4,474.87 | Nov. 11, 2025: 1 @ 30.22; March 31, 2026: 53 @ 30.44 |
| March 31, 2026 | receipt | PO-001368 | MAIN | 200 | 30.44 | 6,088.26 | 201 | 6,118.48 | |
| March 29, 2026 | issue | SO-260329-688 | MAIN | 6 | 30.22 | -181.30 | 1 | 30.22 | Nov. 11, 2025: 6 @ 30.22 |
| March 29, 2026 | issue | SO-260329-688 | EAST | 18 | 30.22 | -543.89 | 7 | 211.51 | Nov. 11, 2025: 18 @ 30.22 |
| March 19, 2026 | issue | SO-260319-443 | MAIN | 1 | 30.22 | -30.22 | 25 | 755.40 | Nov. 11, 2025: 1 @ 30.22 |
| March 18, 2026 | issue | SO-260318-589 | MAIN | 6 | 30.22 | -181.30 | 26 | 785.61 | Nov. 11, 2025: 6 @ 30.22 |
| March 14, 2026 | issue | SO-260314-842 | EAST | 11 | 30.22 | -332.37 | 32 | 966.91 | Nov. 11, 2025: 11 @ 30.22 |
| March 2, 2026 | issue | SO-260302-310 | EAST | 1 | 30.22 | -30.22 | 43 | 1,299.28 | Nov. 11, 2025: 1 @ 30.22 |
| Feb. 26, 2026 | issue | SO-260226-884 | MAIN | 1 | 30.22 | -30.22 | 44 | 1,329.50 | Nov. 11, 2025: 1 @ 30.22 |
| Feb. 14, 2026 | issue | SO-260214-543 | MAIN | 37 | 30.22 | -1,117.99 | 45 | 1,359.72 | Nov. 11, 2025: 37 @ 30.22 |
| Jan. 23, 2026 | issue | SO-260123-485 | MAIN | 30 | 30.22 | -906.48 | 82 | 2,477.70 | Nov. 11, 2025: 30 @ 30.22 |
| Jan. 4, 2026 | issue | SO-260104-112 | EAST | 13 | 30.22 | -392.81 | 112 | 3,384.18 | Nov. 11, 2025: 13 @ 30.22 |
| Dec. 31, 2025 | issue | SO-251231-471 | MAIN | 13 | 30.22 | -392.81 | 125 | 3,776.99 | Nov. 11, 2025: 13 @ 30.22 |
| Dec. 29, 2025 | issue | SO-251229-360 | MAIN | 5 | 30.22 | -151.08 | 138 | 4,169.79 | Nov. 11, 2025: 5 @ 30.22 |
| Dec. 24, 2025 | issue | SO-251224-417 | MAIN | 20 | 30.22 | -604.32 | 143 | 4,320.87 | Nov. 11, 2025: 20 @ 30.22 |
| Dec. 8, 2025 | issue | SO-251208-188 | EAST | 17 | 30.22 | -513.67 | 163 | 4,925.19 | Nov. 11, 2025: 17 @ 30.22 |
| Dec. 4, 2025 | issue | SO-251204-243 | MAIN | 6 | 30.22 | -181.30 | 180 | 5,438.86 | Nov. 11, 2025: 6 @ 30.22 |
| Nov. 21, 2025 | issue | SO-251121-156 | MAIN | 15 | 30.25 | -453.73 | 186 | 5,620.16 | Sept. 5, 2025: 1 @ 30.71; Nov. 11, 2025: 14 @ 30.22 |
| Nov. 11, 2025 | transfer | TRF | MAIN → EAST | 59 | warehouse transfer, no cost effect | ||||
| Nov. 11, 2025 | receipt | PO-000993 | MAIN | 200 | 30.22 | 6,043.18 | 201 | 6,073.89 | |
| Nov. 5, 2025 | issue | SO-251105-603 | EAST | 6 | 30.71 | -184.26 | 1 | 30.71 | July 10, 2025: 6 @ 30.71 |
| Nov. 4, 2025 | issue | SO-251104-337 | EAST | 7 | 30.71 | -214.97 | 7 | 214.97 | July 10, 2025: 7 @ 30.71 |
| Nov. 4, 2025 | issue | SO-251104-337 | MAIN | 20 | 30.71 | -614.21 | 14 | 429.95 | July 10, 2025: 20 @ 30.71 |
| Oct. 27, 2025 | issue | SO-251027-512 | MAIN | 5 | 30.71 | -153.55 | 34 | 1,044.15 | July 10, 2025: 5 @ 30.71 |
| Oct. 18, 2025 | issue | SO-251018-542 | EAST | 11 | 30.71 | -337.81 | 39 | 1,197.71 | July 10, 2025: 11 @ 30.71 |
| Oct. 16, 2025 | issue | SO-251016-953 | MAIN | 16 | 30.71 | -491.37 | 50 | 1,535.52 | July 10, 2025: 16 @ 30.71 |
| Oct. 10, 2025 | issue | SO-251010-672 | EAST | 1 | 30.71 | -30.71 | 66 | 2,026.89 | July 10, 2025: 1 @ 30.71 |
| Oct. 9, 2025 | issue | SO-251009-461 | MAIN | 18 | 30.71 | -552.79 | 67 | 2,057.60 | July 10, 2025: 18 @ 30.71 |
| Sept. 24, 2025 | issue | SO-250924-200 | MAIN | 2 | 30.71 | -61.42 | 85 | 2,610.38 | July 10, 2025: 2 @ 30.71 |
| Sept. 16, 2025 | issue | SO-250916-971 | EAST | 1 | 30.71 | -30.71 | 87 | 2,671.80 | July 10, 2025: 1 @ 30.71 |
| Sept. 14, 2025 | issue | SO-250914-815 | MAIN | 9 | 30.71 | -276.39 | 88 | 2,702.52 | July 10, 2025: 9 @ 30.71 |
| Sept. 13, 2025 | issue | SO-250913-928 | MAIN | 28 | 30.71 | -859.89 | 97 | 2,978.91 | July 10, 2025: 28 @ 30.71 |
| Sept. 7, 2025 | issue | SO-250907-548 | MAIN | 1 | 30.71 | -30.71 | 125 | 3,838.80 | July 10, 2025: 1 @ 30.71 |
| Sept. 5, 2025 | return | RMA | MAIN | 1 | 30.71 | 30.71 | 126 | 3,869.51 | |
| Sept. 3, 2025 | issue | SO-250903-473 | MAIN | 11 | 30.71 | -337.81 | 125 | 3,838.80 | July 10, 2025: 11 @ 30.71 |