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
| 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 |
| Aug. 26, 2025 | issue | SO-250826-833 | EAST | 8 | 30.71 | -245.68 | 136 | 4,176.61 | July 10, 2025: 8 @ 30.71 |
| Aug. 24, 2025 | issue | SO-250824-305 | MAIN | 1 | 30.71 | -30.71 | 144 | 4,422.30 | July 10, 2025: 1 @ 30.71 |
| Aug. 22, 2025 | issue | SO-250822-908 | MAIN | 1 | 30.71 | -30.71 | 145 | 4,453.01 | July 10, 2025: 1 @ 30.71 |
| Aug. 9, 2025 | issue | SO-250809-382 | MAIN | 8 | 30.71 | -245.68 | 146 | 4,483.72 | July 10, 2025: 8 @ 30.71 |
| Aug. 3, 2025 | issue | SO-250803-868 | MAIN | 6 | 30.71 | -184.26 | 154 | 4,729.40 | July 10, 2025: 6 @ 30.71 |
| Aug. 2, 2025 | issue | SO-250802-962 | EAST | 21 | 30.71 | -644.92 | 160 | 4,913.66 | July 10, 2025: 21 @ 30.71 |
| July 23, 2025 | issue | SO-250723-376 | MAIN | 12 | 30.71 | -368.52 | 181 | 5,558.58 | July 10, 2025: 12 @ 30.71 |
| July 16, 2025 | issue | SO-250716-744 | MAIN | 13 | 30.19 | -392.47 | 193 | 5,927.11 | May 31, 2025: 2 @ 29.58; June 17, 2025: 4 @ 29.58; July 10, 2025: 7 @ 30.71 |
| July 10, 2025 | issue | SO-250710-145 | MAIN | 6 | 29.58 | -177.50 | 206 | 6,319.58 | April 16, 2025: 6 @ 29.58 |
| July 10, 2025 | transfer | TRF | MAIN → EAST | 56 | warehouse transfer, no cost effect | ||||
| July 10, 2025 | receipt | PO-000696 | MAIN | 200 | 30.71 | 6,142.08 | 212 | 6,497.07 | |
| July 3, 2025 | issue | SO-250703-874 | MAIN | 1 | 29.58 | -29.58 | 12 | 354.99 | April 16, 2025: 1 @ 29.58 |
| July 2, 2025 | issue | SO-250702-180 | MAIN | 22 | 29.58 | -650.82 | 13 | 384.58 | Feb. 9, 2025: 14 @ 29.58; April 16, 2025: 8 @ 29.58 |
| June 28, 2025 | issue | SO-250628-437 | MAIN | 1 | 29.58 | -29.58 | 35 | 1,035.39 | Feb. 9, 2025: 1 @ 29.58 |
| June 20, 2025 | issue | SO-250620-627 | MAIN | 4 | 29.58 | -118.33 | 36 | 1,064.98 | Feb. 9, 2025: 4 @ 29.58 |
| June 17, 2025 | return | RMA | MAIN | 4 | 29.58 | 118.33 | 40 | 1,183.31 | |
| June 13, 2025 | issue | SO-250613-874 | MAIN | 18 | 29.58 | -532.49 | 36 | 1,064.98 | Feb. 9, 2025: 18 @ 29.58 |
| June 12, 2025 | issue | SO-250612-632 | MAIN | 18 | 29.58 | -532.49 | 54 | 1,597.47 | Feb. 9, 2025: 18 @ 29.58 |
| June 1, 2025 | issue | SO-250601-515 | MAIN | 8 | 29.58 | -236.66 | 72 | 2,129.95 | Feb. 9, 2025: 8 @ 29.58 |
| May 31, 2025 | return | RMA | MAIN | 2 | 29.58 | 59.17 | 80 | 2,366.62 | |
| May 15, 2025 | issue | SO-250515-853 | MAIN | 1 | 29.58 | -29.58 | 78 | 2,307.45 | Feb. 9, 2025: 1 @ 29.58 |
| May 13, 2025 | issue | SO-250513-500 | MAIN | 5 | 29.58 | -147.91 | 79 | 2,337.03 | Feb. 9, 2025: 5 @ 29.58 |
| May 11, 2025 | issue | SO-250511-288 | MAIN | 23 | 29.58 | -680.40 | 84 | 2,484.95 | Feb. 9, 2025: 23 @ 29.58 |
| May 8, 2025 | issue | SO-250508-517 | MAIN | 31 | 29.58 | -917.06 | 107 | 3,165.35 | Feb. 9, 2025: 31 @ 29.58 |
| May 4, 2025 | issue | SO-250504-202 | MAIN | 2 | 29.58 | -59.17 | 138 | 4,082.41 | Feb. 9, 2025: 2 @ 29.58 |
| April 16, 2025 | return | RMA | MAIN | 15 | 29.58 | 443.74 | 140 | 4,141.58 | |
| April 13, 2025 | issue | SO-250413-537 | MAIN | 1 | 29.58 | -29.58 | 125 | 3,697.84 | Feb. 9, 2025: 1 @ 29.58 |
| April 10, 2025 | issue | SO-250410-663 | MAIN | 6 | 29.58 | -177.50 | 126 | 3,727.42 | Feb. 9, 2025: 6 @ 29.58 |
| April 7, 2025 | issue | SO-250407-441 | MAIN | 31 | 29.58 | -917.06 | 132 | 3,904.92 | Feb. 9, 2025: 31 @ 29.58 |
| March 27, 2025 | issue | SO-250327-662 | MAIN | 2 | 29.58 | -59.17 | 163 | 4,821.98 | Feb. 9, 2025: 2 @ 29.58 |
| March 23, 2025 | issue | SO-250323-695 | MAIN | 8 | 29.58 | -236.66 | 165 | 4,881.15 | Feb. 9, 2025: 8 @ 29.58 |
| March 11, 2025 | issue | SO-250311-308 | MAIN | 8 | 29.58 | -236.66 | 173 | 5,117.81 | Feb. 9, 2025: 8 @ 29.58 |
| March 10, 2025 | issue | SO-250310-382 | MAIN | 6 | 29.58 | -177.50 | 181 | 5,354.47 | Feb. 9, 2025: 6 @ 29.58 |
| March 8, 2025 | issue | SO-250308-873 | MAIN | 10 | 29.58 | -295.83 | 187 | 5,531.96 | Feb. 9, 2025: 10 @ 29.58 |
| March 1, 2025 | issue | SO-250301-281 | MAIN | 3 | 29.58 | -88.75 | 197 | 5,827.79 | Feb. 9, 2025: 3 @ 29.58 |
| Feb. 9, 2025 | receipt | PO-000251 | MAIN | 200 | 29.58 | 5,916.54 | 200 | 5,916.54 | |
| Feb. 1, 2025 | issue | SO-250201-280 | MAIN | 6 | 30.48 | -182.86 | 0 | 0.00 | Oct. 1, 2024: 6 @ 30.48 |
| Jan. 23, 2025 | issue | SO-250123-676 | MAIN | 15 | 30.48 | -457.14 | 6 | 182.86 | Oct. 1, 2024: 15 @ 30.48 |
| Jan. 22, 2025 | issue | SO-250122-446 | MAIN | 10 | 30.48 | -304.76 | 21 | 640.00 | Oct. 1, 2024: 10 @ 30.48 |
| Jan. 21, 2025 | issue | SO-250121-764 | MAIN | 14 | 30.48 | -426.66 | 31 | 944.76 | Oct. 1, 2024: 14 @ 30.48 |
| Jan. 14, 2025 | issue | SO-250114-528 | MAIN | 5 | 30.48 | -152.38 | 45 | 1,371.42 | Oct. 1, 2024: 5 @ 30.48 |
| Jan. 8, 2025 | issue | SO-250108-230 | MAIN | 4 | 30.48 | -121.90 | 50 | 1,523.80 | Oct. 1, 2024: 4 @ 30.48 |
| Dec. 26, 2024 | issue | SO-241226-209 | MAIN | 7 | 30.48 | -213.33 | 54 | 1,645.70 | Oct. 1, 2024: 7 @ 30.48 |
| Dec. 23, 2024 | issue | SO-241223-630 | MAIN | 12 | 30.48 | -365.71 | 61 | 1,859.04 | Oct. 1, 2024: 12 @ 30.48 |
| Dec. 22, 2024 | issue | SO-241222-264 | MAIN | 15 | 30.48 | -457.14 | 73 | 2,224.75 | Oct. 1, 2024: 15 @ 30.48 |
| Dec. 11, 2024 | issue | SO-241211-553 | MAIN | 2 | 30.48 | -60.95 | 88 | 2,681.89 | Oct. 1, 2024: 2 @ 30.48 |
| Dec. 7, 2024 | issue | SO-241207-805 | MAIN | 7 | 30.48 | -213.33 | 90 | 2,742.84 | Oct. 1, 2024: 7 @ 30.48 |
| Nov. 27, 2024 | issue | SO-241127-205 | MAIN | 3 | 30.48 | -91.43 | 97 | 2,956.17 | Oct. 1, 2024: 3 @ 30.48 |
| Nov. 24, 2024 | issue | SO-241124-283 | MAIN | 16 | 30.48 | -487.62 | 100 | 3,047.60 | Oct. 1, 2024: 16 @ 30.48 |
| Nov. 21, 2024 | issue | SO-241121-184 | MAIN | 16 | 30.48 | -487.62 | 116 | 3,535.22 | Oct. 1, 2024: 16 @ 30.48 |
| Nov. 20, 2024 | issue | SO-241120-278 | MAIN | 8 | 30.48 | -243.81 | 132 | 4,022.83 | Oct. 1, 2024: 8 @ 30.48 |
| Nov. 19, 2024 | issue | SO-241119-229 | MAIN | 1 | 30.48 | -30.48 | 140 | 4,266.64 | Oct. 1, 2024: 1 @ 30.48 |
| Nov. 10, 2024 | issue | SO-241110-773 | MAIN | 8 | 30.48 | -243.81 | 141 | 4,297.12 | Oct. 1, 2024: 8 @ 30.48 |
| Nov. 5, 2024 | issue | SO-241105-739 | MAIN | 1 | 30.48 | -30.48 | 149 | 4,540.92 | Oct. 1, 2024: 1 @ 30.48 |
| Oct. 21, 2024 | issue | SO-241021-697 | MAIN | 15 | 30.48 | -457.14 | 150 | 4,571.40 | Oct. 1, 2024: 15 @ 30.48 |
| Oct. 20, 2024 | issue | SO-241020-763 | MAIN | 4 | 30.48 | -121.90 | 165 | 5,028.54 | Oct. 1, 2024: 4 @ 30.48 |
| Oct. 18, 2024 | issue | SO-241018-834 | MAIN | 12 | 30.48 | -365.71 | 169 | 5,150.44 | Oct. 1, 2024: 12 @ 30.48 |
| Oct. 11, 2024 | issue | SO-241011-138 | MAIN | 2 | 30.48 | -60.95 | 181 | 5,516.16 | Oct. 1, 2024: 2 @ 30.48 |
| Oct. 4, 2024 | issue | SO-241004-228 | MAIN | 4 | 30.48 | -121.90 | 183 | 5,577.11 | Oct. 1, 2024: 4 @ 30.48 |
| Oct. 3, 2024 | issue | SO-241003-539 | MAIN | 13 | 30.48 | -396.19 | 187 | 5,699.01 | Oct. 1, 2024: 13 @ 30.48 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 200 | 30.48 | 6,095.20 | 200 | 6,095.20 | |