Items / CAB-0011
FR Wire 1.0 sqmm Pro CAB-0011 · Cables & Wires · Conduit & Cable Co
On hand (COIL)178MAIN 118, EAST 60
Value (FIFO)16,751.44avg 94.11
ClassAX / FCV 0.30
Turnover8.8xlast issue 0 days ago
Days of cover63lead 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.92 / 30.4375 | 2.823 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 25.44 / 5.517 | 4.612 |
| 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 * 4.612^2 + 2.823^2 * 3.1^2) | 39.8 |
| Reorder point | d * LT + safety stock | 2.823 * 14.0 + 39.8 | 79.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 79.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1030/yr, S = 45.00, h = 20%, price = 89.43 | 760.0 |
| Inventory position | on hand + on order | 178 + 0 | 178 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 97.21 | 69 | 101,498 | yes |
| 380 | 93.32 | 380 | 99,817 | yes |
| 760 | 89.43 | 760 | 99,000 | yes (chosen if cheapest) |
MOQ 190, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 10, 2026 | 178 / 190 | 94.11 | 16,751.44 |
Movement ledger 129 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-307 | MAIN | 11 | 94.11 | -1,035.20 | 178 | 16,751.44 | Oct. 10, 2026: 11 @ 94.11 |
| Oct. 10, 2026 | issue | SO-261010-282 | EAST | 1 | 94.11 | -94.11 | 189 | 17,786.64 | Oct. 10, 2026: 1 @ 94.11 |
| Oct. 10, 2026 | transfer | TRF | MAIN → EAST | 61 | warehouse transfer, no cost effect | ||||
| Oct. 10, 2026 | receipt | PO-001864 | MAIN | 190 | 94.11 | 17,880.75 | 190 | 17,880.75 | |
| Oct. 6, 2026 | issue | SO-261006-942 | MAIN | 13 | 97.20 | -1,263.55 | 0 | 0.00 | July 22, 2026: 13 @ 97.20 |
| Oct. 4, 2026 | issue | SO-261004-422 | MAIN | 4 | 97.20 | -388.79 | 13 | 1,263.55 | July 22, 2026: 4 @ 97.20 |
| Oct. 3, 2026 | issue | SO-261003-541 | MAIN | 19 | 97.20 | -1,846.73 | 17 | 1,652.34 | July 22, 2026: 19 @ 97.20 |
| Sept. 28, 2026 | issue | SO-260928-341 | MAIN | 52 | 97.20 | -5,054.22 | 36 | 3,499.07 | July 22, 2026: 52 @ 97.20 |
| Sept. 19, 2026 | issue | SO-260919-252 | MAIN | 6 | 97.20 | -583.18 | 88 | 8,553.29 | July 22, 2026: 6 @ 97.20 |
| Sept. 14, 2026 | issue | SO-260914-121 | MAIN | 9 | 97.20 | -874.77 | 94 | 9,136.47 | July 22, 2026: 9 @ 97.20 |
| Aug. 30, 2026 | issue | SO-260830-419 | MAIN | 58 | 97.20 | -5,637.40 | 103 | 10,011.24 | July 22, 2026: 58 @ 97.20 |
| Aug. 28, 2026 | issue | SO-260828-400 | MAIN | 6 | 97.20 | -583.18 | 161 | 15,648.64 | July 22, 2026: 6 @ 97.20 |
| Aug. 15, 2026 | issue | SO-260815-154 | MAIN | 22 | 97.20 | -2,138.32 | 167 | 16,231.82 | July 22, 2026: 22 @ 97.20 |
| Aug. 5, 2026 | issue | SO-260805-223 | MAIN | 1 | 97.20 | -97.20 | 189 | 18,370.14 | July 22, 2026: 1 @ 97.20 |
| July 22, 2026 | receipt | PO-001660 | MAIN | 190 | 97.20 | 18,467.34 | 190 | 18,467.34 | |
| July 19, 2026 | issue | SO-260719-223 | MAIN | 5 | 95.90 | -479.52 | 0 | 0.00 | June 29, 2026: 5 @ 95.90 |
| July 18, 2026 | issue | SO-260718-773 | MAIN | 1 | 95.90 | -95.90 | 5 | 479.52 | May 13, 2026: 1 @ 95.90 |
| July 17, 2026 | issue | SO-260717-808 | MAIN | 18 | 95.90 | -1,726.28 | 6 | 575.43 | May 13, 2026: 18 @ 95.90 |
| July 13, 2026 | issue | SO-260713-973 | MAIN | 30 | 95.90 | -2,877.13 | 24 | 2,301.71 | May 13, 2026: 30 @ 95.90 |
| July 4, 2026 | issue | SO-260704-567 | MAIN | 20 | 95.90 | -1,918.09 | 54 | 5,178.84 | May 13, 2026: 20 @ 95.90 |
| July 3, 2026 | issue | SO-260703-692 | MAIN | 12 | 95.90 | -1,150.85 | 74 | 7,096.93 | May 13, 2026: 12 @ 95.90 |
| June 30, 2026 | issue | SO-260630-996 | MAIN | 8 | 95.90 | -767.24 | 86 | 8,247.78 | May 13, 2026: 8 @ 95.90 |
| June 29, 2026 | return | RMA | MAIN | 5 | 95.90 | 479.52 | 94 | 9,015.01 | |
| June 26, 2026 | issue | SO-260626-916 | MAIN | 11 | 95.90 | -1,054.95 | 89 | 8,535.49 | May 13, 2026: 11 @ 95.90 |
| June 22, 2026 | issue | SO-260622-281 | MAIN | 8 | 95.90 | -767.24 | 100 | 9,590.44 | May 13, 2026: 8 @ 95.90 |
| June 18, 2026 | issue | SO-260618-464 | MAIN | 15 | 95.90 | -1,438.57 | 108 | 10,357.68 | May 13, 2026: 15 @ 95.90 |
| June 5, 2026 | issue | SO-260605-168 | MAIN | 13 | 95.90 | -1,246.76 | 123 | 11,796.24 | May 13, 2026: 13 @ 95.90 |
| May 22, 2026 | issue | SO-260522-563 | MAIN | 21 | 95.90 | -2,013.99 | 136 | 13,043.00 | May 13, 2026: 21 @ 95.90 |
| May 21, 2026 | issue | SO-260521-513 | MAIN | 33 | 95.90 | -3,164.85 | 157 | 15,056.99 | May 13, 2026: 33 @ 95.90 |
| May 13, 2026 | receipt | PO-001488 | MAIN | 190 | 95.90 | 18,221.84 | 190 | 18,221.84 | |
| May 2, 2026 | issue | SO-260502-649 | MAIN | 6 | 95.13 | -570.80 | 0 | 0.00 | March 29, 2026: 6 @ 95.13 |
| April 30, 2026 | issue | SO-260430-735 | MAIN | 83 | 95.13 | -7,895.90 | 6 | 570.80 | Feb. 14, 2026: 76 @ 95.13; Feb. 24, 2026: 1 @ 94.92; March 29, 2026: 6 @ 95.13 |
| April 3, 2026 | issue | SO-260403-622 | MAIN | 26 | 95.13 | -2,473.48 | 89 | 8,466.70 | Feb. 14, 2026: 26 @ 95.13 |
| March 29, 2026 | return | RMA | MAIN | 12 | 95.13 | 1,141.61 | 115 | 10,940.18 | |
| March 19, 2026 | issue | SO-260319-940 | MAIN | 25 | 95.13 | -2,378.35 | 103 | 9,798.57 | Feb. 14, 2026: 25 @ 95.13 |
| March 19, 2026 | issue | SO-260319-940 | EAST | 6 | 95.13 | -570.80 | 128 | 12,176.92 | Feb. 14, 2026: 6 @ 95.13 |
| March 14, 2026 | issue | SO-260314-593 | EAST | 3 | 95.13 | -285.40 | 134 | 12,747.73 | Feb. 14, 2026: 3 @ 95.13 |
| March 11, 2026 | issue | SO-260311-730 | MAIN | 12 | 95.13 | -1,141.61 | 137 | 13,033.13 | Feb. 14, 2026: 12 @ 95.13 |
| March 10, 2026 | issue | SO-260310-176 | MAIN | 33 | 95.13 | -3,139.42 | 149 | 14,174.73 | Feb. 14, 2026: 33 @ 95.13 |
| March 8, 2026 | issue | SO-260308-475 | MAIN | 2 | 95.13 | -190.27 | 182 | 17,314.15 | Feb. 14, 2026: 2 @ 95.13 |
| Feb. 24, 2026 | return | RMA | MAIN | 1 | 94.92 | 94.92 | 184 | 17,504.42 | |
| Feb. 24, 2026 | issue | SO-260224-631 | MAIN | 16 | 94.92 | -1,518.67 | 183 | 17,409.50 | Dec. 26, 2025: 9 @ 94.75; Feb. 14, 2026: 7 @ 95.13 |
| Feb. 14, 2026 | receipt | PO-001229 | MAIN | 190 | 95.13 | 18,075.44 | 199 | 18,928.18 | |
| Feb. 10, 2026 | issue | SO-260210-445 | EAST | 31 | 94.75 | -2,937.20 | 9 | 852.74 | Dec. 26, 2025: 31 @ 94.75 |
| Feb. 10, 2026 | issue | SO-260210-445 | MAIN | 17 | 94.75 | -1,610.72 | 40 | 3,789.94 | Dec. 26, 2025: 17 @ 94.75 |
| Feb. 8, 2026 | issue | SO-260208-890 | MAIN | 2 | 94.75 | -189.50 | 57 | 5,400.66 | Dec. 26, 2025: 2 @ 94.75 |
| Feb. 1, 2026 | issue | SO-260201-310 | MAIN | 11 | 94.75 | -1,042.23 | 59 | 5,590.16 | Dec. 26, 2025: 11 @ 94.75 |
| Jan. 18, 2026 | issue | SO-260118-881 | MAIN | 68 | 94.75 | -6,442.89 | 70 | 6,632.39 | Dec. 26, 2025: 68 @ 94.75 |
| Jan. 17, 2026 | issue | SO-260117-584 | MAIN | 1 | 94.75 | -94.75 | 138 | 13,075.28 | Dec. 26, 2025: 1 @ 94.75 |
| Jan. 6, 2026 | issue | SO-260106-335 | MAIN | 1 | 94.75 | -94.75 | 139 | 13,170.03 | Dec. 26, 2025: 1 @ 94.75 |
| Jan. 1, 2026 | issue | SO-260101-812 | MAIN | 74 | 94.89 | -7,022.05 | 140 | 13,264.78 | Oct. 23, 2025: 24 @ 95.19; Dec. 26, 2025: 50 @ 94.75 |
| Dec. 26, 2025 | transfer | TRF | MAIN → EAST | 40 | warehouse transfer, no cost effect | ||||
| Dec. 26, 2025 | receipt | PO-001090 | MAIN | 190 | 94.75 | 18,002.20 | 214 | 20,286.83 | |
| Dec. 21, 2025 | issue | SO-251221-201 | MAIN | 12 | 95.19 | -1,142.32 | 24 | 2,284.63 | Oct. 23, 2025: 12 @ 95.19 |
| Dec. 12, 2025 | issue | SO-251212-204 | MAIN | 59 | 95.19 | -5,616.39 | 36 | 3,426.95 | Oct. 23, 2025: 59 @ 95.19 |
| Dec. 3, 2025 | issue | SO-251203-671 | MAIN | 30 | 95.19 | -2,855.79 | 95 | 9,043.34 | Oct. 23, 2025: 30 @ 95.19 |
| Dec. 1, 2025 | issue | SO-251201-607 | MAIN | 18 | 95.19 | -1,713.47 | 125 | 11,899.12 | Oct. 23, 2025: 18 @ 95.19 |
| Nov. 28, 2025 | issue | SO-251128-499 | MAIN | 10 | 95.19 | -951.93 | 143 | 13,612.60 | Oct. 23, 2025: 10 @ 95.19 |
| Nov. 20, 2025 | issue | SO-251120-741 | MAIN | 15 | 95.19 | -1,427.90 | 153 | 14,564.53 | Oct. 23, 2025: 15 @ 95.19 |
| Nov. 18, 2025 | issue | SO-251118-600 | MAIN | 4 | 95.19 | -380.77 | 168 | 15,992.42 | Oct. 23, 2025: 4 @ 95.19 |