Items / CAB-0033
FR Wire 1.0 sqmm Nova CAB-0033 · Cables & Wires · Conduit & Cable Co
On hand (COIL)16MAIN 16
Value (FIFO)793.67avg 49.60
ClassCX / FCV 0.12
Turnover8.7xlast issue 9 days ago
Days of cover27lead 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 | 17.83 / 30.4375 | 0.586 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 2.11 / 5.517 | 0.383 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.900) | 1.282 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.282 * sqrt(14.0 * 0.383^2 + 0.586^2 * 3.1^2) | 3.0 |
| Reorder point | d * LT + safety stock | 0.586 * 14.0 + 3.0 | 11.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 11.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 214/yr, S = 45.00, h = 20%, price = 44.95 | 160.0 |
| Inventory position | on hand + on order | 16 + 0 | 16 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 48.86 | 44 | 10,883 | yes |
| 80 | 46.91 | 80 | 10,526 | yes |
| 160 | 44.95 | 160 | 10,392 | yes (chosen if cheapest) |
MOQ 40, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 12, 2026 | 16 / 40 | 49.60 | 793.67 |
Movement ledger 114 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 7, 2026 | issue | SO-261007-606 | MAIN | 7 | 49.60 | -347.23 | 16 | 793.67 | Sept. 12, 2026: 7 @ 49.60 |
| Oct. 3, 2026 | issue | SO-261003-671 | MAIN | 15 | 49.60 | -744.06 | 23 | 1,140.90 | Sept. 12, 2026: 15 @ 49.60 |
| Sept. 20, 2026 | issue | SO-260920-485 | MAIN | 2 | 49.60 | -99.21 | 38 | 1,884.96 | Sept. 12, 2026: 2 @ 49.60 |
| Sept. 12, 2026 | receipt | PO-001792 | MAIN | 40 | 49.60 | 1,984.17 | 40 | 1,984.17 | |
| Sept. 10, 2026 | issue | SO-260910-914 | MAIN | 8 | 47.83 | -382.60 | 0 | 0.00 | June 22, 2026: 5 @ 47.89; June 23, 2026: 3 @ 47.72 |
| Sept. 8, 2026 | issue | SO-260908-257 | MAIN | 2 | 47.89 | -95.78 | 8 | 382.60 | June 22, 2026: 2 @ 47.89 |
| Sept. 1, 2026 | issue | SO-260901-157 | MAIN | 3 | 47.89 | -143.67 | 10 | 478.38 | June 22, 2026: 3 @ 47.89 |
| Aug. 28, 2026 | issue | SO-260828-562 | MAIN | 7 | 47.89 | -335.22 | 13 | 622.05 | June 22, 2026: 7 @ 47.89 |
| Aug. 27, 2026 | issue | SO-260827-803 | MAIN | 2 | 47.89 | -95.78 | 20 | 957.27 | June 22, 2026: 2 @ 47.89 |
| Aug. 18, 2026 | issue | SO-260818-633 | MAIN | 5 | 47.89 | -239.45 | 22 | 1,053.05 | June 22, 2026: 5 @ 47.89 |
| Aug. 9, 2026 | issue | SO-260809-614 | MAIN | 1 | 47.89 | -47.89 | 27 | 1,292.50 | June 22, 2026: 1 @ 47.89 |
| Aug. 2, 2026 | issue | SO-260802-734 | MAIN | 3 | 47.89 | -143.67 | 28 | 1,340.39 | June 22, 2026: 3 @ 47.89 |
| July 30, 2026 | issue | SO-260730-895 | MAIN | 4 | 47.89 | -191.56 | 31 | 1,484.05 | June 22, 2026: 4 @ 47.89 |
| July 26, 2026 | issue | SO-260726-555 | MAIN | 1 | 47.89 | -47.89 | 35 | 1,675.61 | June 22, 2026: 1 @ 47.89 |
| July 20, 2026 | issue | SO-260720-366 | MAIN | 3 | 47.89 | -143.67 | 36 | 1,723.50 | June 22, 2026: 3 @ 47.89 |
| July 8, 2026 | issue | SO-260708-650 | MAIN | 1 | 47.89 | -47.89 | 39 | 1,867.17 | June 22, 2026: 1 @ 47.89 |
| July 7, 2026 | issue | SO-260707-503 | MAIN | 2 | 47.89 | -95.78 | 40 | 1,915.06 | June 22, 2026: 2 @ 47.89 |
| July 2, 2026 | issue | SO-260702-788 | MAIN | 6 | 47.75 | -286.49 | 42 | 2,010.83 | April 24, 2026: 5 @ 47.72; June 22, 2026: 1 @ 47.89 |
| June 23, 2026 | return | RMA | MAIN | 3 | 47.72 | 143.16 | 48 | 2,297.32 | |
| June 22, 2026 | receipt | PO-001593 | MAIN | 40 | 47.89 | 1,915.56 | 45 | 2,154.16 | |
| June 19, 2026 | issue | SO-260619-652 | MAIN | 6 | 47.72 | -286.32 | 5 | 238.60 | April 24, 2026: 6 @ 47.72 |
| June 7, 2026 | issue | SO-260607-878 | MAIN | 6 | 47.72 | -286.32 | 11 | 524.92 | April 24, 2026: 6 @ 47.72 |
| June 6, 2026 | issue | SO-260606-284 | MAIN | 3 | 47.72 | -143.16 | 17 | 811.23 | April 24, 2026: 3 @ 47.72 |
| June 2, 2026 | issue | SO-260602-689 | MAIN | 8 | 47.72 | -381.76 | 20 | 954.39 | April 24, 2026: 8 @ 47.72 |
| May 22, 2026 | issue | SO-260522-473 | MAIN | 6 | 47.72 | -286.32 | 28 | 1,336.15 | April 24, 2026: 6 @ 47.72 |
| May 21, 2026 | issue | SO-260521-607 | MAIN | 4 | 47.72 | -190.88 | 34 | 1,622.47 | April 24, 2026: 4 @ 47.72 |
| May 21, 2026 | issue | SO-260521-607 | EAST | 4 | 48.30 | -193.22 | 38 | 1,813.35 | Feb. 26, 2026: 2 @ 48.89; April 24, 2026: 2 @ 47.72 |
| May 12, 2026 | issue | SO-260512-246 | EAST | 5 | 48.89 | -244.44 | 42 | 2,006.57 | Feb. 26, 2026: 5 @ 48.89 |
| April 24, 2026 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| April 24, 2026 | receipt | PO-001433 | MAIN | 40 | 47.72 | 1,908.79 | 47 | 2,251.01 | |
| April 22, 2026 | issue | SO-260422-984 | MAIN | 1 | 48.89 | -48.89 | 7 | 342.22 | Feb. 26, 2026: 1 @ 48.89 |
| April 18, 2026 | issue | SO-260418-417 | MAIN | 4 | 48.89 | -195.56 | 8 | 391.11 | Feb. 26, 2026: 4 @ 48.89 |
| April 10, 2026 | issue | SO-260410-579 | MAIN | 2 | 48.89 | -97.78 | 12 | 586.67 | Feb. 26, 2026: 2 @ 48.89 |
| April 7, 2026 | issue | SO-260407-909 | MAIN | 1 | 48.89 | -48.89 | 14 | 684.44 | Feb. 26, 2026: 1 @ 48.89 |
| April 6, 2026 | issue | SO-260406-503 | MAIN | 8 | 48.89 | -391.11 | 15 | 733.33 | Feb. 26, 2026: 8 @ 48.89 |
| April 5, 2026 | issue | SO-260405-413 | MAIN | 2 | 48.89 | -97.78 | 23 | 1,124.44 | Feb. 26, 2026: 2 @ 48.89 |
| March 16, 2026 | issue | SO-260316-367 | MAIN | 2 | 48.89 | -97.78 | 25 | 1,222.22 | Feb. 26, 2026: 2 @ 48.89 |
| March 8, 2026 | issue | SO-260308-429 | EAST | 13 | 48.89 | -635.55 | 27 | 1,320.00 | Feb. 26, 2026: 13 @ 48.89 |
| Feb. 26, 2026 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| Feb. 26, 2026 | receipt | PO-001259 | MAIN | 40 | 48.89 | 1,955.55 | 40 | 1,955.55 | |
| Feb. 14, 2026 | issue | SO-260214-822 | EAST | 1 | 48.00 | -48.00 | 0 | 0.00 | Dec. 18, 2025: 1 @ 48.00 |
| Feb. 14, 2026 | issue | SO-260214-822 | MAIN | 17 | 48.00 | -816.02 | 1 | 48.00 | Dec. 18, 2025: 17 @ 48.00 |
| Jan. 19, 2026 | issue | SO-260119-737 | MAIN | 16 | 48.00 | -768.02 | 18 | 864.03 | Dec. 18, 2025: 16 @ 48.00 |
| Jan. 9, 2026 | issue | SO-260109-864 | MAIN | 2 | 48.00 | -96.00 | 34 | 1,632.05 | Dec. 18, 2025: 2 @ 48.00 |
| Jan. 5, 2026 | issue | SO-260105-455 | EAST | 3 | 48.00 | -144.00 | 36 | 1,728.05 | Dec. 18, 2025: 3 @ 48.00 |
| Dec. 26, 2025 | issue | SO-251226-216 | EAST | 4 | 47.97 | -191.87 | 39 | 1,872.05 | Nov. 29, 2025: 3 @ 47.96; Dec. 18, 2025: 1 @ 48.00 |
| Dec. 18, 2025 | issue | SO-251218-324 | EAST | 1 | 47.96 | -47.96 | 43 | 2,063.93 | Nov. 29, 2025: 1 @ 47.96 |
| Dec. 18, 2025 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| Dec. 18, 2025 | receipt | PO-001062 | MAIN | 40 | 48.00 | 1,920.06 | 44 | 2,111.88 | |
| Dec. 15, 2025 | issue | SO-251215-309 | MAIN | 2 | 47.96 | -95.91 | 4 | 191.83 | Sept. 29, 2025: 1 @ 47.96; Nov. 29, 2025: 1 @ 47.96 |
| Dec. 10, 2025 | issue | SO-251210-770 | MAIN | 6 | 47.96 | -287.74 | 6 | 287.74 | Sept. 29, 2025: 6 @ 47.96 |
| Dec. 8, 2025 | issue | SO-251208-261 | MAIN | 7 | 47.96 | -335.70 | 12 | 575.49 | Sept. 29, 2025: 7 @ 47.96 |
| Nov. 29, 2025 | return | RMA | MAIN | 5 | 47.96 | 239.79 | 19 | 911.18 | |
| Nov. 21, 2025 | issue | SO-251121-861 | MAIN | 8 | 47.96 | -383.66 | 14 | 671.40 | Sept. 29, 2025: 8 @ 47.96 |
| Nov. 17, 2025 | issue | SO-251117-891 | MAIN | 1 | 47.96 | -47.96 | 22 | 1,055.06 | Sept. 29, 2025: 1 @ 47.96 |
| Nov. 11, 2025 | issue | SO-251111-558 | MAIN | 10 | 47.96 | -479.57 | 23 | 1,103.01 | Sept. 29, 2025: 10 @ 47.96 |
| Oct. 29, 2025 | issue | SO-251029-454 | MAIN | 1 | 47.96 | -47.96 | 33 | 1,582.58 | Sept. 29, 2025: 1 @ 47.96 |
| Oct. 23, 2025 | issue | SO-251023-680 | MAIN | 2 | 47.96 | -95.91 | 34 | 1,630.54 | Sept. 29, 2025: 2 @ 47.96 |
| Oct. 12, 2025 | issue | SO-251012-137 | MAIN | 1 | 47.96 | -47.96 | 36 | 1,726.46 | Sept. 29, 2025: 1 @ 47.96 |
| Oct. 7, 2025 | issue | SO-251007-963 | MAIN | 14 | 47.17 | -660.39 | 37 | 1,774.41 | Aug. 15, 2025: 11 @ 46.96; Sept. 29, 2025: 3 @ 47.96 |
| Oct. 3, 2025 | issue | SO-251003-150 | MAIN | 1 | 46.96 | -46.96 | 51 | 2,434.80 | Aug. 15, 2025: 1 @ 46.96 |
| Sept. 30, 2025 | issue | SO-250930-649 | MAIN | 1 | 46.96 | -46.96 | 52 | 2,481.75 | Aug. 15, 2025: 1 @ 46.96 |
| Sept. 29, 2025 | receipt | PO-000884 | MAIN | 40 | 47.96 | 1,918.28 | 53 | 2,528.71 | |
| Sept. 16, 2025 | issue | SO-250916-762 | MAIN | 13 | 46.96 | -610.43 | 13 | 610.43 | Aug. 15, 2025: 13 @ 46.96 |
| Sept. 8, 2025 | issue | SO-250908-600 | MAIN | 10 | 46.96 | -469.56 | 26 | 1,220.85 | Aug. 15, 2025: 10 @ 46.96 |
| Aug. 29, 2025 | issue | SO-250829-569 | MAIN | 3 | 46.96 | -140.87 | 36 | 1,690.41 | Aug. 15, 2025: 3 @ 46.96 |
| Aug. 20, 2025 | issue | SO-250820-897 | MAIN | 1 | 46.96 | -46.96 | 39 | 1,831.28 | Aug. 15, 2025: 1 @ 46.96 |
| Aug. 15, 2025 | receipt | PO-000777 | MAIN | 40 | 46.96 | 1,878.24 | 40 | 1,878.24 | |
| Aug. 1, 2025 | issue | SO-250801-397 | MAIN | 1 | 46.60 | -46.60 | 0 | 0.00 | June 17, 2025: 1 @ 46.60 |
| July 30, 2025 | issue | SO-250730-746 | MAIN | 13 | 46.60 | -605.79 | 1 | 46.60 | June 17, 2025: 13 @ 46.60 |
| July 29, 2025 | issue | SO-250729-455 | MAIN | 1 | 46.60 | -46.60 | 14 | 652.39 | June 17, 2025: 1 @ 46.60 |
| July 20, 2025 | issue | SO-250720-895 | MAIN | 2 | 46.60 | -93.20 | 15 | 698.98 | June 17, 2025: 2 @ 46.60 |
| July 14, 2025 | issue | SO-250714-825 | MAIN | 3 | 46.60 | -139.80 | 17 | 792.18 | June 17, 2025: 3 @ 46.60 |
| July 12, 2025 | issue | SO-250712-616 | MAIN | 7 | 46.60 | -326.19 | 20 | 931.98 | June 17, 2025: 7 @ 46.60 |
| June 25, 2025 | issue | SO-250625-293 | MAIN | 19 | 46.20 | -877.80 | 27 | 1,258.17 | April 14, 2025: 6 @ 45.33; June 17, 2025: 13 @ 46.60 |
| June 17, 2025 | receipt | PO-000644 | MAIN | 40 | 46.60 | 1,863.96 | 46 | 2,135.97 | |
| June 6, 2025 | issue | SO-250606-165 | MAIN | 9 | 45.33 | -408.01 | 6 | 272.01 | April 14, 2025: 9 @ 45.33 |
| June 1, 2025 | issue | SO-250601-270 | MAIN | 1 | 45.33 | -45.33 | 15 | 680.02 | April 14, 2025: 1 @ 45.33 |
| May 28, 2025 | issue | SO-250528-786 | MAIN | 1 | 45.33 | -45.33 | 16 | 725.36 | April 14, 2025: 1 @ 45.33 |
| May 19, 2025 | issue | SO-250519-875 | MAIN | 2 | 45.33 | -90.67 | 17 | 770.69 | April 14, 2025: 2 @ 45.33 |
| May 15, 2025 | issue | SO-250515-120 | MAIN | 4 | 45.33 | -181.34 | 19 | 861.36 | April 14, 2025: 4 @ 45.33 |
| May 3, 2025 | issue | SO-250503-332 | MAIN | 3 | 45.33 | -136.00 | 23 | 1,042.70 | April 14, 2025: 3 @ 45.33 |
| May 1, 2025 | issue | SO-250501-632 | MAIN | 5 | 45.33 | -226.67 | 26 | 1,178.70 | April 14, 2025: 5 @ 45.33 |
| April 26, 2025 | issue | SO-250426-620 | MAIN | 2 | 45.33 | -90.67 | 31 | 1,405.38 | April 14, 2025: 2 @ 45.33 |
| April 25, 2025 | issue | SO-250425-850 | MAIN | 9 | 45.43 | -408.89 | 33 | 1,496.05 | April 5, 2025: 2 @ 45.77; April 14, 2025: 7 @ 45.33 |
| April 23, 2025 | issue | SO-250423-255 | MAIN | 2 | 45.77 | -91.54 | 42 | 1,904.93 | April 5, 2025: 2 @ 45.77 |
| April 18, 2025 | issue | SO-250418-336 | MAIN | 1 | 45.77 | -45.77 | 44 | 1,996.48 | April 5, 2025: 1 @ 45.77 |
| April 14, 2025 | receipt | PO-000445 | MAIN | 40 | 45.33 | 1,813.39 | 45 | 2,042.25 | |
| April 13, 2025 | issue | SO-250413-380 | MAIN | 5 | 45.77 | -228.86 | 5 | 228.86 | April 5, 2025: 5 @ 45.77 |
| April 5, 2025 | return | RMA | MAIN | 10 | 45.77 | 457.71 | 10 | 457.71 | |
| March 31, 2025 | issue | SO-250331-967 | MAIN | 21 | 45.77 | -961.19 | 0 | 0.00 | Feb. 2, 2025: 21 @ 45.77 |
| March 19, 2025 | issue | SO-250319-267 | MAIN | 1 | 45.77 | -45.77 | 21 | 961.19 | Feb. 2, 2025: 1 @ 45.77 |
| March 4, 2025 | issue | SO-250304-923 | MAIN | 3 | 45.77 | -137.31 | 22 | 1,006.96 | Feb. 2, 2025: 3 @ 45.77 |
| Feb. 28, 2025 | issue | SO-250228-899 | MAIN | 5 | 45.77 | -228.86 | 25 | 1,144.28 | Feb. 2, 2025: 5 @ 45.77 |
| Feb. 14, 2025 | issue | SO-250214-751 | MAIN | 3 | 45.77 | -137.31 | 30 | 1,373.13 | Feb. 2, 2025: 3 @ 45.77 |
| Feb. 11, 2025 | issue | SO-250211-904 | MAIN | 2 | 45.77 | -91.54 | 33 | 1,510.44 | Feb. 2, 2025: 2 @ 45.77 |
| Feb. 6, 2025 | issue | SO-250206-698 | MAIN | 9 | 46.06 | -414.52 | 35 | 1,601.98 | Dec. 5, 2024: 4 @ 46.42; Feb. 2, 2025: 5 @ 45.77 |
| Feb. 5, 2025 | issue | SO-250205-580 | MAIN | 4 | 44.50 | -177.98 | 44 | 2,016.51 | Nov. 23, 2024: 3 @ 43.85; Dec. 5, 2024: 1 @ 46.42 |
| Feb. 4, 2025 | issue | SO-250204-662 | MAIN | 1 | 43.85 | -43.85 | 48 | 2,194.49 | Nov. 23, 2024: 1 @ 43.85 |
| Feb. 2, 2025 | receipt | PO-000236 | MAIN | 40 | 45.77 | 1,830.84 | 49 | 2,238.34 | |
| Jan. 21, 2025 | issue | SO-250121-865 | MAIN | 4 | 43.85 | -175.42 | 9 | 407.50 | Nov. 23, 2024: 4 @ 43.85 |
| Jan. 15, 2025 | issue | SO-250115-995 | MAIN | 16 | 43.85 | -701.67 | 13 | 582.92 | Nov. 23, 2024: 16 @ 43.85 |
| Dec. 19, 2024 | issue | SO-241219-610 | MAIN | 9 | 43.85 | -394.69 | 29 | 1,284.60 | Nov. 23, 2024: 9 @ 43.85 |
| Dec. 12, 2024 | issue | SO-241212-374 | MAIN | 7 | 43.85 | -306.98 | 38 | 1,679.29 | Nov. 23, 2024: 7 @ 43.85 |
| Dec. 5, 2024 | return | RMA | MAIN | 5 | 46.42 | 232.08 | 45 | 1,986.27 | |
| Nov. 23, 2024 | receipt | PO-000056 | MAIN | 40 | 43.85 | 1,754.18 | 40 | 1,754.18 | |
| Nov. 21, 2024 | issue | SO-241121-277 | MAIN | 1 | 46.42 | -46.42 | 0 | 0.00 | Oct. 1, 2024: 1 @ 46.42 |
| Nov. 15, 2024 | issue | SO-241115-187 | MAIN | 10 | 46.42 | -464.17 | 1 | 46.42 | Oct. 1, 2024: 10 @ 46.42 |
| Nov. 14, 2024 | issue | SO-241114-361 | MAIN | 1 | 46.42 | -46.42 | 11 | 510.59 | Oct. 1, 2024: 1 @ 46.42 |
| Nov. 5, 2024 | issue | SO-241105-922 | MAIN | 6 | 46.42 | -278.50 | 12 | 557.00 | Oct. 1, 2024: 6 @ 46.42 |
| Oct. 31, 2024 | issue | SO-241031-933 | MAIN | 2 | 46.42 | -92.83 | 18 | 835.51 | Oct. 1, 2024: 2 @ 46.42 |
| Oct. 26, 2024 | issue | SO-241026-243 | MAIN | 17 | 46.42 | -789.09 | 20 | 928.34 | Oct. 1, 2024: 17 @ 46.42 |
| Oct. 24, 2024 | issue | SO-241024-843 | MAIN | 3 | 46.42 | -139.25 | 37 | 1,717.43 | Oct. 1, 2024: 3 @ 46.42 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 40 | 46.42 | 1,856.68 | 40 | 1,856.68 | |