Items / CAB-0010
FR Wire 1.0 sqmm Lite CAB-0010 · Cables & Wires · Conduit & Cable Co
On hand (COIL)14MAIN 7, EAST 7
Value (FIFO)3,636.84avg 259.77
ClassAX / FCV 0.30
Turnover11.1xlast issue 1 days ago
Days of cover20lead time 14d
Reorder suggested: 50 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 | 21.17 / 30.4375 | 0.695 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.28 / 5.517 | 1.139 |
| 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 * 1.139^2 + 0.695^2 * 3.1^2) | 9.8 |
| Reorder point | d * LT + safety stock | 0.695 * 14.0 + 9.8 | 19.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 19.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 254/yr, S = 45.00, h = 20%, price = 260.32 | 20.9 |
| Inventory position | on hand + on order | 14 + 0 | 14 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 260.32 | 21 | 67,167 | yes (chosen if cheapest) |
MOQ 50, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 2, 2026 | 14 / 50 | 259.77 | 3,636.84 |
Movement ledger 125 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-121 | EAST | 5 | 259.77 | -1,298.87 | 14 | 3,636.84 | Sept. 2, 2026: 5 @ 259.77 |
| Oct. 11, 2026 | issue | SO-261011-808 | MAIN | 12 | 259.77 | -3,117.29 | 19 | 4,935.71 | Sept. 2, 2026: 12 @ 259.77 |
| Oct. 4, 2026 | issue | SO-261004-270 | MAIN | 1 | 259.77 | -259.77 | 31 | 8,052.99 | Sept. 2, 2026: 1 @ 259.77 |
| Sept. 27, 2026 | issue | SO-260927-408 | MAIN | 8 | 259.77 | -2,078.19 | 32 | 8,312.77 | Sept. 2, 2026: 8 @ 259.77 |
| Sept. 12, 2026 | issue | SO-260912-816 | MAIN | 17 | 260.48 | -4,428.11 | 40 | 10,390.96 | June 16, 2026: 6 @ 263.47; June 16, 2026: 1 @ 249.56; Sept. 2, 2026: 10 @ 259.77 |
| Sept. 2, 2026 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||
| Sept. 2, 2026 | receipt | PO-001768 | MAIN | 50 | 259.77 | 12,988.70 | 57 | 14,819.07 | |
| Aug. 30, 2026 | issue | SO-260830-515 | MAIN | 1 | 263.47 | -263.47 | 7 | 1,830.37 | June 16, 2026: 1 @ 263.47 |
| Aug. 19, 2026 | issue | SO-260819-629 | MAIN | 2 | 263.47 | -526.94 | 8 | 2,093.83 | June 16, 2026: 2 @ 263.47 |
| Aug. 18, 2026 | issue | SO-260818-939 | MAIN | 7 | 263.47 | -1,844.27 | 10 | 2,620.77 | June 16, 2026: 7 @ 263.47 |
| Aug. 18, 2026 | issue | SO-260818-939 | EAST | 13 | 263.47 | -3,425.08 | 17 | 4,465.04 | June 16, 2026: 13 @ 263.47 |
| Aug. 12, 2026 | issue | SO-260812-365 | MAIN | 1 | 263.47 | -263.47 | 30 | 7,890.12 | June 16, 2026: 1 @ 263.47 |
| July 31, 2026 | issue | SO-260731-519 | MAIN | 3 | 263.47 | -790.40 | 31 | 8,153.59 | June 16, 2026: 3 @ 263.47 |
| July 30, 2026 | issue | SO-260730-261 | MAIN | 1 | 263.47 | -263.47 | 34 | 8,943.99 | June 16, 2026: 1 @ 263.47 |
| July 29, 2026 | issue | SO-260729-428 | MAIN | 2 | 263.47 | -526.94 | 35 | 9,207.46 | June 16, 2026: 2 @ 263.47 |
| July 25, 2026 | issue | SO-260725-895 | MAIN | 2 | 263.47 | -526.94 | 37 | 9,734.39 | June 16, 2026: 2 @ 263.47 |
| July 18, 2026 | issue | SO-260718-205 | MAIN | 1 | 263.47 | -263.47 | 39 | 10,261.33 | June 16, 2026: 1 @ 263.47 |
| July 14, 2026 | issue | SO-260714-422 | MAIN | 7 | 263.47 | -1,844.27 | 40 | 10,524.80 | June 16, 2026: 7 @ 263.47 |
| July 13, 2026 | issue | SO-260713-757 | MAIN | 3 | 263.47 | -790.40 | 47 | 12,369.07 | June 16, 2026: 3 @ 263.47 |
| June 30, 2026 | issue | SO-260630-964 | MAIN | 3 | 255.03 | -765.08 | 50 | 13,159.47 | March 22, 2026: 1 @ 249.56; March 30, 2026: 1 @ 252.06; June 16, 2026: 1 @ 263.47 |
| June 26, 2026 | issue | SO-260626-532 | MAIN | 2 | 249.56 | -499.12 | 53 | 13,924.56 | March 22, 2026: 2 @ 249.56 |
| June 25, 2026 | issue | SO-260625-862 | MAIN | 1 | 249.56 | -249.56 | 55 | 14,423.68 | March 22, 2026: 1 @ 249.56 |
| June 16, 2026 | return | RMA | MAIN | 1 | 249.56 | 249.56 | 56 | 14,673.24 | |
| June 16, 2026 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| June 16, 2026 | receipt | PO-001576 | MAIN | 50 | 263.47 | 13,173.38 | 55 | 14,423.68 | |
| June 10, 2026 | issue | SO-260610-214 | MAIN | 1 | 249.56 | -249.56 | 5 | 1,250.30 | March 22, 2026: 1 @ 249.56 |
| June 7, 2026 | issue | SO-260607-212 | MAIN | 3 | 249.56 | -748.68 | 6 | 1,499.86 | March 22, 2026: 3 @ 249.56 |
| June 7, 2026 | issue | SO-260607-212 | EAST | 6 | 249.56 | -1,497.36 | 9 | 2,248.54 | March 22, 2026: 6 @ 249.56 |
| June 1, 2026 | issue | SO-260601-717 | MAIN | 2 | 249.56 | -499.12 | 15 | 3,745.90 | March 22, 2026: 2 @ 249.56 |
| May 30, 2026 | issue | SO-260530-206 | MAIN | 1 | 249.56 | -249.56 | 17 | 4,245.02 | March 22, 2026: 1 @ 249.56 |
| May 26, 2026 | issue | SO-260526-670 | MAIN | 4 | 249.56 | -998.24 | 18 | 4,494.58 | March 22, 2026: 4 @ 249.56 |
| May 21, 2026 | issue | SO-260521-501 | MAIN | 2 | 249.56 | -499.12 | 22 | 5,492.82 | March 22, 2026: 2 @ 249.56 |
| May 18, 2026 | issue | SO-260518-714 | MAIN | 5 | 249.56 | -1,247.80 | 24 | 5,991.95 | March 22, 2026: 5 @ 249.56 |
| May 4, 2026 | issue | SO-260504-704 | EAST | 4 | 249.56 | -998.24 | 29 | 7,239.75 | March 22, 2026: 4 @ 249.56 |
| April 21, 2026 | issue | SO-260421-560 | MAIN | 2 | 249.56 | -499.12 | 33 | 8,237.99 | March 22, 2026: 2 @ 249.56 |
| April 19, 2026 | issue | SO-260419-877 | MAIN | 22 | 250.24 | -5,505.30 | 35 | 8,737.11 | Dec. 31, 2025: 6 @ 252.06; March 22, 2026: 16 @ 249.56 |
| March 30, 2026 | return | RMA | MAIN | 1 | 252.06 | 252.06 | 57 | 14,242.41 | |
| March 28, 2026 | issue | SO-260328-869 | MAIN | 1 | 252.06 | -252.06 | 56 | 13,990.36 | Dec. 31, 2025: 1 @ 252.06 |
| March 22, 2026 | issue | SO-260322-679 | EAST | 2 | 252.06 | -504.11 | 57 | 14,242.41 | Dec. 31, 2025: 2 @ 252.06 |
| March 22, 2026 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||
| March 22, 2026 | receipt | PO-001341 | MAIN | 50 | 249.56 | 12,478.02 | 59 | 14,746.53 | |
| March 10, 2026 | issue | SO-260310-148 | MAIN | 4 | 252.06 | -1,008.23 | 9 | 2,268.51 | Dec. 31, 2025: 4 @ 252.06 |
| March 9, 2026 | issue | SO-260309-697 | MAIN | 3 | 252.06 | -756.17 | 13 | 3,276.73 | Dec. 31, 2025: 3 @ 252.06 |
| March 6, 2026 | issue | SO-260306-460 | MAIN | 9 | 252.06 | -2,268.51 | 16 | 4,032.90 | Dec. 31, 2025: 9 @ 252.06 |
| Feb. 25, 2026 | issue | SO-260225-277 | MAIN | 2 | 252.06 | -504.11 | 25 | 6,301.41 | Dec. 31, 2025: 2 @ 252.06 |
| Feb. 24, 2026 | issue | SO-260224-231 | MAIN | 2 | 252.06 | -504.11 | 27 | 6,805.52 | Dec. 31, 2025: 2 @ 252.06 |
| Feb. 19, 2026 | issue | SO-260219-477 | MAIN | 18 | 252.06 | -4,537.01 | 29 | 7,309.63 | Dec. 31, 2025: 18 @ 252.06 |
| Feb. 13, 2026 | issue | SO-260213-471 | MAIN | 3 | 252.06 | -756.17 | 47 | 11,846.65 | Dec. 31, 2025: 3 @ 252.06 |
| Jan. 29, 2026 | issue | SO-260129-276 | MAIN | 1 | 252.60 | -252.60 | 50 | 12,602.82 | Nov. 2, 2025: 1 @ 252.60 |
| Jan. 27, 2026 | issue | SO-260127-979 | MAIN | 4 | 252.60 | -1,010.39 | 51 | 12,855.41 | Nov. 2, 2025: 4 @ 252.60 |
| Jan. 19, 2026 | issue | SO-260119-883 | MAIN | 1 | 252.60 | -252.60 | 55 | 13,865.80 | Nov. 2, 2025: 1 @ 252.60 |
| Jan. 15, 2026 | issue | SO-260115-884 | MAIN | 2 | 252.60 | -505.19 | 56 | 14,118.40 | Nov. 2, 2025: 2 @ 252.60 |
| Jan. 8, 2026 | issue | SO-260108-992 | MAIN | 1 | 252.60 | -252.60 | 58 | 14,623.59 | Nov. 2, 2025: 1 @ 252.60 |
| Jan. 5, 2026 | issue | SO-260105-613 | EAST | 3 | 252.60 | -757.79 | 59 | 14,876.19 | Nov. 2, 2025: 3 @ 252.60 |
| Dec. 31, 2025 | receipt | PO-001106 | MAIN | 50 | 252.06 | 12,602.82 | 62 | 15,633.98 | |
| Dec. 29, 2025 | issue | SO-251229-995 | MAIN | 2 | 252.60 | -505.19 | 12 | 3,031.17 | Nov. 2, 2025: 2 @ 252.60 |
| Dec. 19, 2025 | issue | SO-251219-212 | MAIN | 9 | 252.60 | -2,273.38 | 14 | 3,536.36 | Nov. 2, 2025: 9 @ 252.60 |
| Dec. 18, 2025 | issue | SO-251218-266 | MAIN | 6 | 252.60 | -1,515.58 | 23 | 5,809.74 | Nov. 2, 2025: 6 @ 252.60 |
| Dec. 16, 2025 | issue | SO-251216-941 | MAIN | 12 | 252.60 | -3,031.17 | 29 | 7,325.32 | Nov. 2, 2025: 12 @ 252.60 |
| Nov. 27, 2025 | issue | SO-251127-882 | MAIN | 1 | 252.60 | -252.60 | 41 | 10,356.49 | Nov. 2, 2025: 1 @ 252.60 |