Items / CAB-0012
FR Wire 1.0 sqmm Classic CAB-0012 · Cables & Wires · Conduit & Cable Co
On hand (COIL)41MAIN 41
Value (FIFO)8,579.01avg 209.24
ClassAX / FCV 0.21
Turnover21.8xlast issue 3 days ago
Days of cover17lead time 14d
Reorder suggested: 640 units (position at or below reorder point: order EOQ), stockout risk medium.
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 | 74.92 / 30.4375 | 2.461 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 15.63 / 5.517 | 2.834 |
| 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.834^2 + 2.461^2 * 3.1^2) | 26.9 |
| Reorder point | d * LT + safety stock | 2.461 * 14.0 + 26.9 | 61.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 61.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 898/yr, S = 45.00, h = 20%, price = 196.67 | 640.0 |
| Inventory position | on hand + on order | 41 + 0 | 41 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 213.77 | 43 | 193,907 | yes |
| 320 | 205.22 | 320 | 191,059 | yes |
| 640 | 196.67 | 640 | 189,334 | yes (chosen if cheapest) |
MOQ 160, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 13, 2026 | 41 / 160 | 209.24 | 8,579.01 |
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-861 | MAIN | 40 | 209.24 | -8,369.77 | 41 | 8,579.01 | Sept. 13, 2026: 40 @ 209.24 |
| Oct. 7, 2026 | issue | SO-261007-117 | MAIN | 72 | 209.24 | -15,065.58 | 81 | 16,948.78 | Sept. 13, 2026: 72 @ 209.24 |
| Oct. 2, 2026 | issue | SO-261002-446 | MAIN | 8 | 209.15 | -1,673.19 | 153 | 32,014.36 | July 12, 2026: 1 @ 208.48; Sept. 13, 2026: 7 @ 209.24 |
| Sept. 29, 2026 | issue | SO-260929-210 | MAIN | 38 | 208.48 | -7,922.22 | 161 | 33,687.55 | July 12, 2026: 38 @ 208.48 |
| Sept. 13, 2026 | receipt | PO-001796 | MAIN | 160 | 209.24 | 33,479.07 | 199 | 41,609.78 | |
| Sept. 6, 2026 | issue | SO-260906-137 | MAIN | 15 | 208.48 | -3,127.19 | 39 | 8,130.70 | July 12, 2026: 15 @ 208.48 |
| Sept. 1, 2026 | issue | SO-260901-310 | MAIN | 22 | 208.48 | -4,586.55 | 54 | 11,257.90 | July 12, 2026: 22 @ 208.48 |
| Aug. 26, 2026 | issue | SO-260826-722 | MAIN | 24 | 208.48 | -5,003.51 | 76 | 15,844.45 | July 12, 2026: 24 @ 208.48 |
| Aug. 17, 2026 | issue | SO-260817-175 | MAIN | 42 | 208.48 | -8,756.14 | 100 | 20,847.96 | July 12, 2026: 42 @ 208.48 |
| July 15, 2026 | issue | SO-260715-821 | MAIN | 17 | 208.48 | -3,544.15 | 142 | 29,604.10 | July 12, 2026: 17 @ 208.48 |
| July 12, 2026 | issue | SO-260712-718 | MAIN | 1 | 208.48 | -208.48 | 159 | 33,148.26 | July 12, 2026: 1 @ 208.48 |
| July 12, 2026 | receipt | PO-001643 | MAIN | 160 | 208.48 | 33,356.74 | 160 | 33,356.74 | |
| July 5, 2026 | issue | SO-260705-512 | MAIN | 18 | 203.44 | -3,661.99 | 0 | 0.00 | May 1, 2026: 18 @ 203.44 |
| July 3, 2026 | issue | SO-260703-829 | MAIN | 10 | 203.44 | -2,034.44 | 18 | 3,661.99 | May 1, 2026: 10 @ 203.44 |
| June 27, 2026 | issue | SO-260627-767 | MAIN | 41 | 203.44 | -8,341.20 | 28 | 5,696.43 | May 1, 2026: 41 @ 203.44 |
| June 21, 2026 | issue | SO-260621-986 | MAIN | 34 | 203.44 | -6,917.09 | 69 | 14,037.63 | May 1, 2026: 34 @ 203.44 |
| May 18, 2026 | issue | SO-260518-839 | MAIN | 14 | 203.44 | -2,848.21 | 103 | 20,954.72 | May 1, 2026: 14 @ 203.44 |
| May 17, 2026 | issue | SO-260517-174 | MAIN | 5 | 203.44 | -1,017.22 | 117 | 23,802.94 | May 1, 2026: 5 @ 203.44 |
| May 16, 2026 | issue | SO-260516-468 | MAIN | 2 | 203.44 | -406.89 | 122 | 24,820.16 | May 1, 2026: 2 @ 203.44 |
| May 14, 2026 | issue | SO-260514-592 | MAIN | 9 | 203.44 | -1,831.00 | 124 | 25,227.04 | May 1, 2026: 9 @ 203.44 |
| May 14, 2026 | issue | SO-260514-592 | EAST | 37 | 204.68 | -7,573.28 | 133 | 27,058.04 | March 3, 2026: 8 @ 208.03; April 10, 2026: 2 @ 208.03; May 1, 2026: 27 @ 203.44 |
| May 1, 2026 | transfer | TRF | MAIN → EAST | 37 | warehouse transfer, no cost effect | ||||
| May 1, 2026 | receipt | PO-001455 | MAIN | 160 | 203.44 | 32,551.02 | 170 | 34,631.32 | |
| April 29, 2026 | issue | SO-260429-191 | MAIN | 16 | 208.03 | -3,328.47 | 10 | 2,080.29 | March 3, 2026: 16 @ 208.03 |
| April 27, 2026 | issue | SO-260427-144 | MAIN | 26 | 208.03 | -5,408.76 | 26 | 5,408.76 | March 3, 2026: 26 @ 208.03 |
| April 19, 2026 | issue | SO-260419-860 | MAIN | 17 | 208.03 | -3,536.50 | 52 | 10,817.52 | March 3, 2026: 17 @ 208.03 |
| April 10, 2026 | return | RMA | MAIN | 2 | 208.03 | 416.06 | 69 | 14,354.02 | |
| April 8, 2026 | issue | SO-260408-271 | MAIN | 19 | 208.03 | -3,952.56 | 67 | 13,937.96 | March 3, 2026: 19 @ 208.03 |
| March 29, 2026 | issue | SO-260329-850 | MAIN | 5 | 208.03 | -1,040.15 | 86 | 17,890.52 | March 3, 2026: 5 @ 208.03 |
| March 26, 2026 | issue | SO-260326-203 | MAIN | 49 | 208.03 | -10,193.44 | 91 | 18,930.67 | March 3, 2026: 49 @ 208.03 |
| March 21, 2026 | issue | SO-260321-896 | MAIN | 11 | 208.03 | -2,288.32 | 140 | 29,124.10 | March 3, 2026: 11 @ 208.03 |
| March 17, 2026 | issue | SO-260317-602 | MAIN | 9 | 208.03 | -1,872.26 | 151 | 31,412.42 | March 3, 2026: 9 @ 208.03 |
| March 3, 2026 | receipt | PO-001278 | MAIN | 160 | 208.03 | 33,284.69 | 160 | 33,284.69 | |
| March 1, 2026 | issue | SO-260301-326 | MAIN | 1 | 201.18 | -201.18 | 0 | 0.00 | Jan. 9, 2026: 1 @ 201.18 |
| Feb. 26, 2026 | issue | SO-260226-886 | MAIN | 34 | 201.18 | -6,839.96 | 1 | 201.18 | Jan. 9, 2026: 34 @ 201.18 |
| Feb. 24, 2026 | issue | SO-260224-738 | MAIN | 3 | 201.18 | -603.53 | 35 | 7,041.14 | Jan. 9, 2026: 3 @ 201.18 |
| Feb. 18, 2026 | issue | SO-260218-430 | MAIN | 35 | 201.18 | -7,041.14 | 38 | 7,644.66 | Jan. 9, 2026: 35 @ 201.18 |
| Feb. 14, 2026 | issue | SO-260214-857 | MAIN | 11 | 201.18 | -2,212.93 | 73 | 14,685.80 | Jan. 9, 2026: 11 @ 201.18 |
| Feb. 12, 2026 | issue | SO-260212-864 | MAIN | 8 | 201.18 | -1,609.40 | 84 | 16,898.73 | Jan. 9, 2026: 8 @ 201.18 |
| Feb. 10, 2026 | issue | SO-260210-128 | MAIN | 7 | 201.18 | -1,408.23 | 92 | 18,508.13 | Jan. 9, 2026: 7 @ 201.18 |
| Jan. 28, 2026 | issue | SO-260128-475 | MAIN | 39 | 201.18 | -7,845.84 | 99 | 19,916.35 | Jan. 9, 2026: 39 @ 201.18 |
| Jan. 24, 2026 | issue | SO-260124-516 | MAIN | 28 | 203.10 | -5,686.78 | 138 | 27,762.19 | Oct. 30, 2025: 6 @ 210.15; Jan. 9, 2026: 22 @ 201.18 |
| Jan. 19, 2026 | issue | SO-260119-186 | MAIN | 23 | 210.15 | -4,833.55 | 166 | 33,448.97 | Oct. 30, 2025: 23 @ 210.15 |
| Jan. 13, 2026 | issue | SO-260113-708 | MAIN | 14 | 210.15 | -2,942.16 | 189 | 38,282.52 | Oct. 30, 2025: 14 @ 210.15 |
| Jan. 9, 2026 | receipt | PO-001130 | MAIN | 160 | 201.18 | 32,188.05 | 203 | 41,224.68 | |
| Dec. 21, 2025 | issue | SO-251221-436 | MAIN | 39 | 210.15 | -8,196.01 | 43 | 9,036.63 | Oct. 30, 2025: 39 @ 210.15 |
| Dec. 18, 2025 | issue | SO-251218-247 | MAIN | 52 | 210.15 | -10,928.02 | 82 | 17,232.64 | Oct. 30, 2025: 52 @ 210.15 |
| Nov. 29, 2025 | issue | SO-251129-436 | MAIN | 6 | 210.15 | -1,260.93 | 134 | 28,160.66 | Oct. 30, 2025: 6 @ 210.15 |
| Nov. 27, 2025 | issue | SO-251127-235 | MAIN | 1 | 210.15 | -210.15 | 140 | 29,421.59 | Oct. 30, 2025: 1 @ 210.15 |
| Nov. 26, 2025 | issue | SO-251126-121 | MAIN | 7 | 210.15 | -1,471.08 | 141 | 29,631.74 | Oct. 30, 2025: 7 @ 210.15 |
| Nov. 17, 2025 | issue | SO-251117-912 | MAIN | 5 | 210.15 | -1,050.77 | 148 | 31,102.82 | Oct. 30, 2025: 5 @ 210.15 |
| Nov. 8, 2025 | issue | SO-251108-304 | MAIN | 32 | 207.90 | -6,652.65 | 153 | 32,153.59 | Aug. 24, 2025: 24 @ 207.38; Sept. 2, 2025: 1 @ 204.41; Oct. 30, 2025: 7 @ 210.15 |
| Nov. 5, 2025 | issue | SO-251105-433 | MAIN | 8 | 207.38 | -1,659.05 | 185 | 38,806.24 | Aug. 24, 2025: 8 @ 207.38 |
| Oct. 30, 2025 | issue | SO-251030-760 | MAIN | 4 | 207.38 | -829.53 | 193 | 40,465.29 | Aug. 24, 2025: 4 @ 207.38 |
| Oct. 30, 2025 | receipt | PO-000964 | MAIN | 160 | 210.15 | 33,624.67 | 197 | 41,294.82 | |
| Oct. 29, 2025 | issue | SO-251029-345 | MAIN | 11 | 207.38 | -2,281.20 | 37 | 7,670.14 | Aug. 24, 2025: 11 @ 207.38 |
| Oct. 16, 2025 | issue | SO-251016-695 | MAIN | 8 | 207.38 | -1,659.05 | 48 | 9,951.34 | Aug. 24, 2025: 8 @ 207.38 |
| Oct. 15, 2025 | issue | SO-251015-753 | MAIN | 13 | 207.38 | -2,695.96 | 56 | 11,610.39 | Aug. 24, 2025: 13 @ 207.38 |
| Oct. 10, 2025 | issue | SO-251010-574 | MAIN | 29 | 207.38 | -6,014.06 | 69 | 14,306.35 | Aug. 24, 2025: 29 @ 207.38 |
| Oct. 2, 2025 | issue | SO-251002-715 | MAIN | 2 | 207.38 | -414.76 | 98 | 20,320.41 | Aug. 24, 2025: 2 @ 207.38 |