Items / CAB-0036
FR Wire 1.0 sqmm Max CAB-0036 · Cables & Wires · Conduit & Cable Co
On hand (COIL)2MAIN 2
Value (FIFO)196.21avg 98.10
ClassBX / FCV 0.26
Turnover72.7xlast issue 2 days ago
Days of cover2lead time 14d
Reorder suggested: 60 units (position at or below reorder point: order EOQ), stockout risk high.
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 | 24.92 / 30.4375 | 0.819 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.42 / 5.517 | 1.164 |
| 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 * 1.164^2 + 0.819^2 * 3.1^2) | 8.3 |
| Reorder point | d * LT + safety stock | 0.819 * 14.0 + 8.3 | 19.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 19.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 299/yr, S = 45.00, h = 20%, price = 100.27 | 36.6 |
| Inventory position | on hand + on order | 2 + 0 | 2 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 100.27 | 37 | 30,695 | yes (chosen if cheapest) |
MOQ 60, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 26, 2026 | 2 / 6 | 98.10 | 196.21 |
Movement ledger 114 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | issue | SO-261014-571 | MAIN | 11 | 98.10 | -1,079.14 | 2 | 196.21 | Aug. 17, 2026: 7 @ 98.10; Sept. 26, 2026: 4 @ 98.10 |
| Oct. 10, 2026 | issue | SO-261010-318 | MAIN | 3 | 98.10 | -294.31 | 13 | 1,275.35 | Aug. 17, 2026: 3 @ 98.10 |
| Oct. 8, 2026 | issue | SO-261008-509 | MAIN | 7 | 98.10 | -686.73 | 16 | 1,569.66 | Aug. 17, 2026: 7 @ 98.10 |
| Oct. 6, 2026 | issue | SO-261006-786 | MAIN | 8 | 98.10 | -784.83 | 23 | 2,256.38 | Aug. 17, 2026: 8 @ 98.10 |
| Sept. 29, 2026 | issue | SO-260929-383 | MAIN | 8 | 98.10 | -784.83 | 31 | 3,041.21 | Aug. 17, 2026: 8 @ 98.10 |
| Sept. 26, 2026 | return | RMA | MAIN | 6 | 98.10 | 588.62 | 39 | 3,826.04 | |
| Sept. 22, 2026 | issue | SO-260922-647 | MAIN | 5 | 98.10 | -490.52 | 33 | 3,237.42 | Aug. 17, 2026: 5 @ 98.10 |
| Sept. 11, 2026 | issue | SO-260911-498 | MAIN | 12 | 98.10 | -1,177.24 | 38 | 3,727.94 | Aug. 17, 2026: 12 @ 98.10 |
| Aug. 31, 2026 | issue | SO-260831-405 | MAIN | 6 | 98.10 | -588.62 | 50 | 4,905.18 | Aug. 17, 2026: 6 @ 98.10 |
| Aug. 30, 2026 | issue | SO-260830-147 | MAIN | 1 | 98.10 | -98.10 | 56 | 5,493.80 | Aug. 17, 2026: 1 @ 98.10 |
| Aug. 25, 2026 | issue | SO-260825-877 | MAIN | 3 | 98.10 | -294.31 | 57 | 5,591.91 | Aug. 17, 2026: 3 @ 98.10 |
| Aug. 17, 2026 | receipt | PO-001725 | MAIN | 60 | 98.10 | 5,886.22 | 60 | 5,886.22 | |
| Aug. 13, 2026 | issue | SO-260813-615 | EAST | 5 | 97.81 | -489.04 | 0 | 0.00 | June 3, 2026: 2 @ 97.81; July 10, 2026: 3 @ 97.81 |
| Aug. 8, 2026 | issue | SO-260808-578 | EAST | 1 | 97.81 | -97.81 | 5 | 489.04 | June 3, 2026: 1 @ 97.81 |
| Aug. 6, 2026 | issue | SO-260806-213 | EAST | 7 | 97.81 | -684.65 | 6 | 586.84 | June 3, 2026: 7 @ 97.81 |
| Aug. 6, 2026 | issue | SO-260806-213 | MAIN | 14 | 97.81 | -1,369.30 | 13 | 1,271.49 | June 3, 2026: 14 @ 97.81 |
| July 25, 2026 | issue | SO-260725-139 | MAIN | 1 | 97.81 | -97.81 | 27 | 2,640.79 | June 3, 2026: 1 @ 97.81 |
| July 21, 2026 | issue | SO-260721-522 | MAIN | 20 | 97.81 | -1,956.14 | 28 | 2,738.60 | June 3, 2026: 20 @ 97.81 |
| July 10, 2026 | return | RMA | MAIN | 3 | 97.81 | 293.42 | 48 | 4,694.74 | |
| July 5, 2026 | issue | SO-260705-477 | MAIN | 1 | 97.81 | -97.81 | 45 | 4,401.32 | June 3, 2026: 1 @ 97.81 |
| July 3, 2026 | issue | SO-260703-372 | MAIN | 1 | 97.81 | -97.81 | 46 | 4,499.12 | June 3, 2026: 1 @ 97.81 |
| June 29, 2026 | issue | SO-260629-389 | MAIN | 7 | 97.81 | -684.65 | 47 | 4,596.93 | June 3, 2026: 7 @ 97.81 |
| June 14, 2026 | issue | SO-260614-871 | MAIN | 13 | 98.34 | -1,278.42 | 54 | 5,281.58 | March 25, 2026: 7 @ 98.80; June 3, 2026: 6 @ 97.81 |
| June 3, 2026 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| June 3, 2026 | receipt | PO-001544 | MAIN | 60 | 97.81 | 5,868.42 | 67 | 6,560.00 | |
| May 29, 2026 | issue | SO-260529-215 | MAIN | 1 | 98.80 | -98.80 | 7 | 691.58 | March 25, 2026: 1 @ 98.80 |
| May 26, 2026 | issue | SO-260526-938 | MAIN | 1 | 98.80 | -98.80 | 8 | 790.38 | March 25, 2026: 1 @ 98.80 |
| May 21, 2026 | issue | SO-260521-353 | MAIN | 30 | 98.80 | -2,963.92 | 9 | 889.18 | March 25, 2026: 30 @ 98.80 |
| April 29, 2026 | issue | SO-260429-586 | MAIN | 5 | 98.80 | -493.99 | 39 | 3,853.10 | March 25, 2026: 5 @ 98.80 |
| April 24, 2026 | issue | SO-260424-643 | MAIN | 10 | 98.80 | -987.97 | 44 | 4,347.09 | March 25, 2026: 10 @ 98.80 |
| April 18, 2026 | issue | SO-260418-535 | MAIN | 5 | 98.80 | -493.99 | 54 | 5,335.06 | March 25, 2026: 5 @ 98.80 |
| April 2, 2026 | issue | SO-260402-944 | MAIN | 2 | 98.23 | -196.47 | 59 | 5,829.05 | Jan. 5, 2026: 1 @ 97.67; March 25, 2026: 1 @ 98.80 |
| March 25, 2026 | receipt | PO-001351 | MAIN | 60 | 98.80 | 5,927.84 | 61 | 6,025.51 | |
| March 10, 2026 | issue | SO-260310-984 | MAIN | 25 | 97.67 | -2,441.74 | 1 | 97.67 | Jan. 5, 2026: 25 @ 97.67 |
| March 8, 2026 | issue | SO-260308-719 | MAIN | 7 | 97.67 | -683.69 | 26 | 2,539.41 | Jan. 5, 2026: 7 @ 97.67 |
| Feb. 24, 2026 | issue | SO-260224-419 | MAIN | 10 | 97.67 | -976.70 | 33 | 3,223.10 | Jan. 5, 2026: 10 @ 97.67 |
| Feb. 23, 2026 | issue | SO-260223-976 | MAIN | 2 | 97.67 | -195.34 | 43 | 4,199.80 | Jan. 5, 2026: 2 @ 97.67 |
| Feb. 18, 2026 | issue | SO-260218-523 | MAIN | 5 | 97.67 | -488.35 | 45 | 4,395.14 | Jan. 5, 2026: 5 @ 97.67 |
| Feb. 16, 2026 | issue | SO-260216-252 | MAIN | 1 | 97.67 | -97.67 | 50 | 4,883.49 | Jan. 5, 2026: 1 @ 97.67 |
| Feb. 9, 2026 | issue | SO-260209-720 | MAIN | 5 | 97.67 | -488.35 | 51 | 4,981.16 | Jan. 5, 2026: 5 @ 97.67 |
| Feb. 5, 2026 | issue | SO-260205-155 | MAIN | 1 | 97.67 | -97.67 | 56 | 5,469.51 | Jan. 5, 2026: 1 @ 97.67 |
| Jan. 20, 2026 | issue | SO-260120-984 | MAIN | 9 | 97.86 | -880.77 | 57 | 5,567.18 | Oct. 22, 2025: 6 @ 97.96; Jan. 5, 2026: 3 @ 97.67 |
| Jan. 14, 2026 | issue | SO-260114-786 | MAIN | 11 | 97.96 | -1,077.55 | 66 | 6,447.94 | Oct. 22, 2025: 11 @ 97.96 |
| Jan. 5, 2026 | receipt | PO-001122 | MAIN | 60 | 97.67 | 5,860.19 | 77 | 7,525.50 | |
| Dec. 25, 2025 | issue | SO-251225-300 | MAIN | 16 | 97.96 | -1,567.35 | 17 | 1,665.31 | Oct. 22, 2025: 16 @ 97.96 |
| Dec. 8, 2025 | issue | SO-251208-999 | MAIN | 1 | 97.96 | -97.96 | 33 | 3,232.66 | Oct. 22, 2025: 1 @ 97.96 |
| Nov. 30, 2025 | issue | SO-251130-228 | MAIN | 15 | 97.96 | -1,469.39 | 34 | 3,330.62 | Oct. 22, 2025: 15 @ 97.96 |
| Nov. 30, 2025 | issue | SO-251130-228 | EAST | 6 | 97.96 | -587.76 | 49 | 4,800.02 | Oct. 22, 2025: 6 @ 97.96 |
| Nov. 18, 2025 | issue | SO-251118-768 | EAST | 1 | 97.96 | -97.96 | 55 | 5,387.77 | Oct. 22, 2025: 1 @ 97.96 |
| Nov. 13, 2025 | issue | SO-251113-828 | MAIN | 5 | 96.94 | -484.72 | 56 | 5,485.73 | Sept. 14, 2025: 1 @ 92.88; Oct. 22, 2025: 4 @ 97.96 |
| Nov. 7, 2025 | issue | SO-251107-480 | EAST | 6 | 92.88 | -557.28 | 61 | 5,970.45 | Sept. 14, 2025: 6 @ 92.88 |
| Oct. 22, 2025 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| Oct. 22, 2025 | receipt | PO-000939 | MAIN | 60 | 97.96 | 5,877.57 | 67 | 6,527.73 | |
| Oct. 14, 2025 | issue | SO-251014-174 | MAIN | 2 | 92.88 | -185.76 | 7 | 650.16 | Aug. 6, 2025: 2 @ 92.88 |
| Oct. 10, 2025 | issue | SO-251010-659 | MAIN | 21 | 92.88 | -1,950.47 | 9 | 835.91 | Aug. 6, 2025: 21 @ 92.88 |
| Sept. 23, 2025 | issue | SO-250923-928 | MAIN | 12 | 92.88 | -1,114.55 | 30 | 2,786.38 | Aug. 6, 2025: 12 @ 92.88 |
| Sept. 14, 2025 | return | RMA | MAIN | 7 | 92.88 | 650.16 | 42 | 3,900.93 | |
| Sept. 12, 2025 | issue | SO-250912-685 | MAIN | 1 | 92.88 | -92.88 | 35 | 3,250.78 | Aug. 6, 2025: 1 @ 92.88 |
| Sept. 8, 2025 | issue | SO-250908-154 | MAIN | 2 | 92.88 | -185.76 | 36 | 3,343.65 | Aug. 6, 2025: 2 @ 92.88 |
| Sept. 2, 2025 | issue | SO-250902-916 | MAIN | 14 | 92.88 | -1,300.31 | 38 | 3,529.41 | Aug. 6, 2025: 14 @ 92.88 |
| Aug. 21, 2025 | issue | SO-250821-265 | MAIN | 3 | 92.88 | -278.64 | 52 | 4,829.72 | Aug. 6, 2025: 3 @ 92.88 |
| Aug. 18, 2025 | issue | SO-250818-134 | MAIN | 1 | 92.88 | -92.88 | 55 | 5,108.36 | Aug. 6, 2025: 1 @ 92.88 |
| Aug. 14, 2025 | issue | SO-250814-641 | MAIN | 2 | 92.88 | -185.76 | 56 | 5,201.24 | Aug. 6, 2025: 2 @ 92.88 |
| Aug. 11, 2025 | issue | SO-250811-722 | MAIN | 14 | 95.05 | -1,330.74 | 58 | 5,387.00 | June 12, 2025: 12 @ 95.42; Aug. 6, 2025: 2 @ 92.88 |
| Aug. 6, 2025 | receipt | PO-000762 | MAIN | 60 | 92.88 | 5,572.76 | 72 | 6,717.74 | |
| Aug. 3, 2025 | issue | SO-250803-267 | MAIN | 2 | 95.42 | -190.83 | 12 | 1,144.98 | June 12, 2025: 2 @ 95.42 |
| July 22, 2025 | issue | SO-250722-789 | MAIN | 6 | 95.42 | -572.49 | 14 | 1,335.81 | June 12, 2025: 6 @ 95.42 |
| July 22, 2025 | issue | SO-250722-789 | EAST | 7 | 95.42 | -667.91 | 20 | 1,908.30 | June 12, 2025: 7 @ 95.42 |
| July 17, 2025 | issue | SO-250717-261 | MAIN | 3 | 95.42 | -286.25 | 27 | 2,576.21 | June 12, 2025: 3 @ 95.42 |
| July 14, 2025 | issue | SO-250714-207 | EAST | 8 | 95.42 | -763.32 | 30 | 2,862.46 | June 12, 2025: 8 @ 95.42 |
| July 5, 2025 | issue | SO-250705-516 | MAIN | 8 | 95.42 | -763.32 | 38 | 3,625.78 | June 12, 2025: 8 @ 95.42 |
| June 28, 2025 | issue | SO-250628-386 | MAIN | 4 | 95.42 | -381.66 | 46 | 4,389.10 | June 12, 2025: 4 @ 95.42 |
| June 27, 2025 | issue | SO-250627-959 | MAIN | 1 | 95.42 | -95.42 | 50 | 4,770.76 | June 12, 2025: 1 @ 95.42 |
| June 25, 2025 | issue | SO-250625-955 | MAIN | 1 | 95.42 | -95.42 | 51 | 4,866.18 | June 12, 2025: 1 @ 95.42 |
| June 20, 2025 | issue | SO-250620-740 | MAIN | 3 | 95.42 | -286.25 | 52 | 4,961.59 | June 12, 2025: 3 @ 95.42 |
| June 15, 2025 | issue | SO-250615-896 | MAIN | 5 | 95.42 | -477.08 | 55 | 5,247.84 | June 12, 2025: 5 @ 95.42 |
| June 12, 2025 | transfer | TRF | MAIN → EAST | 15 | warehouse transfer, no cost effect | ||||
| June 12, 2025 | receipt | PO-000628 | MAIN | 60 | 95.42 | 5,724.91 | 60 | 5,724.91 | |
| June 8, 2025 | issue | SO-250608-516 | MAIN | 10 | 94.88 | -948.77 | 0 | 0.00 | April 13, 2025: 10 @ 94.88 |
| May 29, 2025 | issue | SO-250529-314 | MAIN | 31 | 94.88 | -2,941.19 | 10 | 948.77 | April 13, 2025: 31 @ 94.88 |
| April 29, 2025 | issue | SO-250429-471 | MAIN | 1 | 94.88 | -94.88 | 41 | 3,889.96 | April 13, 2025: 1 @ 94.88 |
| April 23, 2025 | issue | SO-250423-397 | MAIN | 13 | 94.88 | -1,233.40 | 42 | 3,984.83 | April 13, 2025: 13 @ 94.88 |
| April 15, 2025 | issue | SO-250415-403 | MAIN | 4 | 94.88 | -379.51 | 55 | 5,218.24 | April 13, 2025: 4 @ 94.88 |
| April 13, 2025 | issue | SO-250413-362 | MAIN | 8 | 93.19 | -745.50 | 59 | 5,597.74 | Jan. 18, 2025: 7 @ 92.95; April 13, 2025: 1 @ 94.88 |
| April 13, 2025 | receipt | PO-000441 | MAIN | 60 | 94.88 | 5,692.62 | 67 | 6,343.24 | |
| April 9, 2025 | issue | SO-250409-221 | MAIN | 1 | 92.95 | -92.95 | 7 | 650.62 | Jan. 18, 2025: 1 @ 92.95 |
| March 28, 2025 | issue | SO-250328-496 | MAIN | 6 | 92.95 | -557.68 | 8 | 743.57 | Jan. 18, 2025: 6 @ 92.95 |
| March 25, 2025 | issue | SO-250325-765 | MAIN | 6 | 92.95 | -557.68 | 14 | 1,301.24 | Jan. 18, 2025: 6 @ 92.95 |
| March 17, 2025 | issue | SO-250317-934 | MAIN | 2 | 92.95 | -185.89 | 20 | 1,858.92 | Jan. 18, 2025: 2 @ 92.95 |
| March 14, 2025 | issue | SO-250314-696 | MAIN | 9 | 92.95 | -836.51 | 22 | 2,044.81 | Jan. 18, 2025: 9 @ 92.95 |
| March 13, 2025 | issue | SO-250313-175 | MAIN | 11 | 92.95 | -1,022.41 | 31 | 2,881.33 | Jan. 18, 2025: 11 @ 92.95 |
| Feb. 25, 2025 | issue | SO-250225-988 | MAIN | 9 | 92.95 | -836.51 | 42 | 3,903.73 | Jan. 18, 2025: 9 @ 92.95 |
| Feb. 18, 2025 | issue | SO-250218-242 | MAIN | 4 | 92.95 | -371.78 | 51 | 4,740.25 | Jan. 18, 2025: 4 @ 92.95 |
| Feb. 13, 2025 | issue | SO-250213-118 | MAIN | 8 | 92.18 | -737.42 | 55 | 5,112.03 | Jan. 11, 2025: 3 @ 90.90; Jan. 18, 2025: 5 @ 92.95 |
| Feb. 9, 2025 | issue | SO-250209-121 | MAIN | 3 | 90.90 | -272.69 | 63 | 5,849.45 | Jan. 11, 2025: 3 @ 90.90 |
| Feb. 6, 2025 | issue | SO-250206-884 | MAIN | 1 | 90.90 | -90.90 | 66 | 6,122.15 | Jan. 11, 2025: 1 @ 90.90 |
| Feb. 5, 2025 | issue | SO-250205-386 | MAIN | 11 | 90.90 | -999.87 | 67 | 6,213.04 | Nov. 22, 2024: 3 @ 90.90; Jan. 11, 2025: 8 @ 90.90 |
| Jan. 22, 2025 | issue | SO-250122-797 | MAIN | 1 | 90.90 | -90.90 | 78 | 7,212.92 | Nov. 22, 2024: 1 @ 90.90 |
| Jan. 18, 2025 | receipt | PO-000196 | MAIN | 60 | 92.95 | 5,576.76 | 79 | 7,303.81 | |
| Jan. 12, 2025 | issue | SO-250112-234 | MAIN | 1 | 90.90 | -90.90 | 19 | 1,727.05 | Nov. 22, 2024: 1 @ 90.90 |
| Jan. 11, 2025 | return | RMA | MAIN | 15 | 90.90 | 1,363.46 | 20 | 1,817.95 | |
| Jan. 2, 2025 | issue | SO-250102-635 | MAIN | 30 | 90.90 | -2,726.93 | 5 | 454.49 | Nov. 22, 2024: 30 @ 90.90 |
| Dec. 28, 2024 | issue | SO-241228-637 | MAIN | 13 | 90.90 | -1,181.67 | 35 | 3,181.42 | Nov. 22, 2024: 13 @ 90.90 |
| Dec. 27, 2024 | issue | SO-241227-348 | MAIN | 9 | 90.90 | -818.08 | 48 | 4,363.08 | Nov. 22, 2024: 9 @ 90.90 |
| Dec. 6, 2024 | issue | SO-241206-500 | MAIN | 9 | 93.80 | -844.23 | 57 | 5,181.16 | Oct. 1, 2024: 6 @ 95.26; Nov. 22, 2024: 3 @ 90.90 |
| Nov. 28, 2024 | issue | SO-241128-207 | MAIN | 1 | 95.26 | -95.26 | 66 | 6,025.40 | Oct. 1, 2024: 1 @ 95.26 |
| Nov. 24, 2024 | issue | SO-241124-464 | MAIN | 3 | 95.26 | -285.77 | 67 | 6,120.65 | Oct. 1, 2024: 3 @ 95.26 |
| Nov. 22, 2024 | receipt | PO-000052 | MAIN | 60 | 90.90 | 5,453.86 | 70 | 6,406.42 | |
| Nov. 12, 2024 | issue | SO-241112-898 | MAIN | 3 | 95.26 | -285.77 | 10 | 952.56 | Oct. 1, 2024: 3 @ 95.26 |
| Nov. 11, 2024 | issue | SO-241111-120 | MAIN | 12 | 95.26 | -1,143.08 | 13 | 1,238.33 | Oct. 1, 2024: 12 @ 95.26 |
| Nov. 6, 2024 | issue | SO-241106-558 | MAIN | 3 | 95.26 | -285.77 | 25 | 2,381.41 | Oct. 1, 2024: 3 @ 95.26 |
| Oct. 25, 2024 | issue | SO-241025-263 | MAIN | 31 | 95.26 | -2,952.95 | 28 | 2,667.18 | Oct. 1, 2024: 31 @ 95.26 |
| Oct. 3, 2024 | issue | SO-241003-616 | MAIN | 1 | 95.26 | -95.26 | 59 | 5,620.13 | Oct. 1, 2024: 1 @ 95.26 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 60 | 95.26 | 5,715.39 | 60 | 5,715.39 | |