Items / CAB-0035
FR Wire 2.5 sqmm Eco CAB-0035 · Cables & Wires · Conduit & Cable Co
On hand (COIL)37MAIN 37
Value (FIFO)10,644.75avg 287.70
ClassAX / FCV 0.16
Turnover8.0xlast issue 2 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 | 42.17 / 30.4375 | 1.385 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.54 / 5.517 | 1.186 |
| 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.186^2 + 1.385^2 * 3.1^2) | 12.7 |
| Reorder point | d * LT + safety stock | 1.385 * 14.0 + 12.7 | 32.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 32.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 506/yr, S = 45.00, h = 20%, price = 268.11 | 360.0 |
| Inventory position | on hand + on order | 37 + 0 | 37 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 291.42 | 28 | 148,986 | yes |
| 180 | 279.76 | 180 | 146,625 | yes |
| 360 | 268.11 | 360 | 145,284 | yes (chosen if cheapest) |
MOQ 90, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 28, 2026 | 37 / 90 | 287.70 | 10,644.75 |
Movement ledger 115 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | issue | SO-261014-866 | MAIN | 10 | 287.70 | -2,876.96 | 37 | 10,644.75 | Aug. 28, 2026: 10 @ 287.70 |
| Oct. 13, 2026 | issue | SO-261013-649 | MAIN | 1 | 287.70 | -287.70 | 47 | 13,521.71 | Aug. 28, 2026: 1 @ 287.70 |
| Oct. 10, 2026 | issue | SO-261010-643 | MAIN | 2 | 287.70 | -575.39 | 48 | 13,809.41 | Aug. 28, 2026: 2 @ 287.70 |
| Oct. 8, 2026 | issue | SO-261008-204 | MAIN | 7 | 287.70 | -2,013.87 | 50 | 14,384.80 | Aug. 28, 2026: 7 @ 287.70 |
| Oct. 4, 2026 | issue | SO-261004-739 | MAIN | 2 | 287.70 | -575.39 | 57 | 16,398.67 | Aug. 28, 2026: 2 @ 287.70 |
| Oct. 2, 2026 | issue | SO-261002-806 | MAIN | 13 | 287.70 | -3,740.05 | 59 | 16,974.06 | Aug. 28, 2026: 13 @ 287.70 |
| Sept. 22, 2026 | issue | SO-260922-694 | MAIN | 2 | 287.70 | -575.39 | 72 | 20,714.11 | Aug. 28, 2026: 2 @ 287.70 |
| Sept. 21, 2026 | issue | SO-260921-772 | MAIN | 2 | 287.70 | -575.39 | 74 | 21,289.50 | Aug. 28, 2026: 2 @ 287.70 |
| Sept. 21, 2026 | issue | SO-260921-772 | EAST | 6 | 287.70 | -1,726.18 | 76 | 21,864.90 | Aug. 28, 2026: 6 @ 287.70 |
| Sept. 19, 2026 | issue | SO-260919-605 | MAIN | 20 | 286.54 | -5,730.74 | 82 | 23,591.07 | July 17, 2026: 9 @ 285.76; Aug. 20, 2026: 3 @ 285.76; Aug. 28, 2026: 8 @ 287.70 |
| Sept. 8, 2026 | issue | SO-260908-318 | MAIN | 4 | 285.76 | -1,143.06 | 102 | 29,321.81 | July 17, 2026: 4 @ 285.76 |
| Aug. 29, 2026 | issue | SO-260829-863 | EAST | 4 | 285.76 | -1,143.06 | 106 | 30,464.87 | July 17, 2026: 4 @ 285.76 |
| Aug. 28, 2026 | receipt | PO-001753 | MAIN | 90 | 287.70 | 25,892.64 | 110 | 31,607.93 | |
| Aug. 22, 2026 | issue | SO-260822-795 | EAST | 1 | 285.76 | -285.76 | 20 | 5,715.29 | July 17, 2026: 1 @ 285.76 |
| Aug. 20, 2026 | return | RMA | MAIN | 3 | 285.76 | 857.29 | 21 | 6,001.05 | |
| Aug. 19, 2026 | issue | SO-260819-160 | EAST | 12 | 285.76 | -3,429.17 | 18 | 5,143.76 | July 17, 2026: 12 @ 285.76 |
| Aug. 17, 2026 | issue | SO-260817-931 | MAIN | 7 | 285.76 | -2,000.35 | 30 | 8,572.93 | July 17, 2026: 7 @ 285.76 |
| Aug. 12, 2026 | issue | SO-260812-564 | MAIN | 22 | 285.76 | -6,286.81 | 37 | 10,573.28 | July 17, 2026: 22 @ 285.76 |
| July 26, 2026 | issue | SO-260726-172 | MAIN | 22 | 285.76 | -6,286.81 | 59 | 16,860.09 | July 17, 2026: 22 @ 285.76 |
| July 24, 2026 | issue | SO-260724-836 | MAIN | 6 | 285.76 | -1,714.59 | 81 | 23,146.91 | July 17, 2026: 6 @ 285.76 |
| July 19, 2026 | issue | SO-260719-258 | MAIN | 17 | 290.01 | -4,930.20 | 87 | 24,861.49 | April 28, 2026: 14 @ 290.92; July 17, 2026: 3 @ 285.76 |
| July 17, 2026 | transfer | TRF | MAIN → EAST | 23 | warehouse transfer, no cost effect | ||||
| July 17, 2026 | receipt | PO-001651 | MAIN | 90 | 285.76 | 25,718.79 | 104 | 29,791.69 | |
| June 29, 2026 | issue | SO-260629-320 | MAIN | 38 | 290.92 | -11,055.02 | 14 | 4,072.90 | April 28, 2026: 38 @ 290.92 |
| June 27, 2026 | issue | SO-260627-911 | MAIN | 1 | 290.92 | -290.92 | 52 | 15,127.93 | April 28, 2026: 1 @ 290.92 |
| June 23, 2026 | issue | SO-260623-582 | MAIN | 6 | 290.92 | -1,745.53 | 53 | 15,418.85 | April 28, 2026: 6 @ 290.92 |
| May 23, 2026 | issue | SO-260523-796 | MAIN | 29 | 290.92 | -8,436.73 | 59 | 17,164.38 | April 28, 2026: 29 @ 290.92 |
| May 16, 2026 | issue | SO-260516-300 | MAIN | 10 | 289.46 | -2,894.60 | 88 | 25,601.11 | March 5, 2026: 8 @ 289.09; April 28, 2026: 2 @ 290.92 |
| April 28, 2026 | issue | SO-260428-989 | MAIN | 5 | 289.09 | -1,445.47 | 98 | 28,495.71 | March 5, 2026: 5 @ 289.09 |
| April 28, 2026 | receipt | PO-001446 | MAIN | 90 | 290.92 | 26,182.95 | 103 | 29,941.18 | |
| April 18, 2026 | issue | SO-260418-534 | MAIN | 16 | 289.09 | -4,625.51 | 13 | 3,758.23 | March 5, 2026: 16 @ 289.09 |
| April 12, 2026 | issue | SO-260412-924 | MAIN | 7 | 289.09 | -2,023.66 | 29 | 8,383.73 | March 5, 2026: 7 @ 289.09 |
| April 5, 2026 | issue | SO-260405-854 | MAIN | 11 | 289.09 | -3,180.04 | 36 | 10,407.39 | March 5, 2026: 11 @ 289.09 |
| April 4, 2026 | issue | SO-260404-584 | MAIN | 6 | 289.09 | -1,734.57 | 47 | 13,587.43 | March 5, 2026: 6 @ 289.09 |
| March 25, 2026 | issue | SO-260325-417 | MAIN | 4 | 289.09 | -1,156.38 | 53 | 15,322.00 | March 5, 2026: 4 @ 289.09 |
| March 17, 2026 | issue | SO-260317-258 | MAIN | 13 | 289.09 | -3,758.23 | 57 | 16,478.38 | March 5, 2026: 13 @ 289.09 |
| March 7, 2026 | issue | SO-260307-195 | MAIN | 35 | 288.88 | -10,110.68 | 70 | 20,236.60 | Dec. 21, 2025: 15 @ 288.59; March 5, 2026: 20 @ 289.09 |
| March 5, 2026 | issue | SO-260305-735 | MAIN | 6 | 288.59 | -1,731.52 | 105 | 30,347.28 | Dec. 21, 2025: 6 @ 288.59 |
| March 5, 2026 | receipt | PO-001286 | MAIN | 90 | 289.09 | 26,018.49 | 111 | 32,078.80 | |
| Feb. 25, 2026 | issue | SO-260225-580 | MAIN | 6 | 288.59 | -1,731.52 | 21 | 6,060.31 | Dec. 21, 2025: 6 @ 288.59 |
| Feb. 21, 2026 | issue | SO-260221-701 | MAIN | 11 | 288.59 | -3,174.45 | 27 | 7,791.83 | Dec. 21, 2025: 11 @ 288.59 |
| Feb. 13, 2026 | issue | SO-260213-814 | MAIN | 10 | 288.59 | -2,885.86 | 38 | 10,966.28 | Dec. 21, 2025: 10 @ 288.59 |
| Feb. 11, 2026 | issue | SO-260211-558 | MAIN | 4 | 288.59 | -1,154.35 | 48 | 13,852.15 | Dec. 21, 2025: 4 @ 288.59 |
| Jan. 25, 2026 | issue | SO-260125-638 | MAIN | 27 | 288.59 | -7,791.83 | 52 | 15,006.49 | Dec. 21, 2025: 27 @ 288.59 |
| Jan. 4, 2026 | issue | SO-260104-406 | MAIN | 11 | 288.59 | -3,174.45 | 79 | 22,798.33 | Dec. 21, 2025: 11 @ 288.59 |
| Dec. 21, 2025 | receipt | PO-001071 | MAIN | 90 | 288.59 | 25,972.78 | 90 | 25,972.78 | |
| Dec. 6, 2025 | issue | SO-251206-977 | MAIN | 11 | 278.35 | -3,061.81 | 0 | 0.00 | Oct. 16, 2025: 11 @ 278.35 |
| Dec. 6, 2025 | issue | SO-251206-977 | EAST | 31 | 278.35 | -8,628.73 | 11 | 3,061.81 | Oct. 16, 2025: 31 @ 278.35 |
| Nov. 30, 2025 | issue | SO-251130-937 | MAIN | 2 | 278.35 | -556.69 | 42 | 11,690.54 | Oct. 16, 2025: 2 @ 278.35 |
| Nov. 21, 2025 | issue | SO-251121-674 | MAIN | 44 | 278.35 | -12,247.23 | 44 | 12,247.23 | Oct. 16, 2025: 44 @ 278.35 |
| Oct. 21, 2025 | issue | SO-251021-987 | EAST | 8 | 272.08 | -2,176.63 | 88 | 24,494.47 | Aug. 15, 2025: 6 @ 269.99; Oct. 16, 2025: 2 @ 278.35 |
| Oct. 16, 2025 | issue | SO-251016-443 | MAIN | 10 | 269.99 | -2,699.89 | 96 | 26,671.09 | Aug. 15, 2025: 10 @ 269.99 |
| Oct. 16, 2025 | transfer | TRF | MAIN → EAST | 28 | warehouse transfer, no cost effect | ||||
| Oct. 16, 2025 | receipt | PO-000923 | MAIN | 90 | 278.35 | 25,051.16 | 106 | 29,370.98 | |
| Oct. 12, 2025 | issue | SO-251012-194 | EAST | 1 | 269.99 | -269.99 | 16 | 4,319.82 | Aug. 15, 2025: 1 @ 269.99 |
| Oct. 1, 2025 | issue | SO-251001-653 | MAIN | 21 | 269.99 | -5,669.76 | 17 | 4,589.81 | Aug. 15, 2025: 21 @ 269.99 |
| Sept. 30, 2025 | issue | SO-250930-942 | EAST | 5 | 269.99 | -1,349.94 | 38 | 10,259.57 | Aug. 15, 2025: 5 @ 269.99 |
| Sept. 26, 2025 | issue | SO-250926-178 | MAIN | 15 | 269.99 | -4,049.83 | 43 | 11,609.52 | Aug. 15, 2025: 15 @ 269.99 |
| Sept. 22, 2025 | issue | SO-250922-751 | MAIN | 4 | 269.99 | -1,079.96 | 58 | 15,659.35 | Aug. 15, 2025: 4 @ 269.99 |
| Sept. 11, 2025 | issue | SO-250911-970 | EAST | 5 | 269.99 | -1,349.94 | 62 | 16,739.31 | Aug. 15, 2025: 5 @ 269.99 |
| Sept. 1, 2025 | issue | SO-250901-943 | MAIN | 15 | 269.99 | -4,049.83 | 67 | 18,089.25 | Aug. 15, 2025: 15 @ 269.99 |
| Aug. 29, 2025 | issue | SO-250829-670 | MAIN | 14 | 273.49 | -3,828.82 | 82 | 22,139.08 | June 8, 2025: 6 @ 278.15; Aug. 15, 2025: 8 @ 269.99 |
| Aug. 23, 2025 | issue | SO-250823-204 | EAST | 7 | 278.15 | -1,947.06 | 96 | 25,967.90 | June 8, 2025: 7 @ 278.15 |
| Aug. 21, 2025 | issue | SO-250821-700 | MAIN | 3 | 278.15 | -834.45 | 103 | 27,914.96 | June 8, 2025: 3 @ 278.15 |
| Aug. 18, 2025 | issue | SO-250818-623 | MAIN | 1 | 278.15 | -278.15 | 106 | 28,749.41 | June 8, 2025: 1 @ 278.15 |
| Aug. 15, 2025 | transfer | TRF | MAIN → EAST | 29 | warehouse transfer, no cost effect | ||||
| Aug. 15, 2025 | receipt | PO-000778 | MAIN | 90 | 269.99 | 24,298.99 | 107 | 29,027.56 | |
| Aug. 5, 2025 | issue | SO-250805-491 | MAIN | 5 | 278.15 | -1,390.76 | 17 | 4,728.57 | June 8, 2025: 5 @ 278.15 |
| Aug. 4, 2025 | issue | SO-250804-469 | MAIN | 3 | 278.15 | -834.45 | 22 | 6,119.32 | June 8, 2025: 3 @ 278.15 |
| July 31, 2025 | issue | SO-250731-887 | MAIN | 9 | 278.15 | -2,503.36 | 25 | 6,953.78 | June 8, 2025: 9 @ 278.15 |
| July 29, 2025 | issue | SO-250729-656 | MAIN | 14 | 278.15 | -3,894.11 | 34 | 9,457.13 | June 8, 2025: 14 @ 278.15 |
| July 19, 2025 | issue | SO-250719-767 | MAIN | 22 | 278.15 | -6,119.32 | 48 | 13,351.25 | June 8, 2025: 22 @ 278.15 |
| July 11, 2025 | issue | SO-250711-525 | MAIN | 7 | 278.15 | -1,947.06 | 70 | 19,470.57 | June 8, 2025: 7 @ 278.15 |
| June 28, 2025 | issue | SO-250628-995 | MAIN | 9 | 278.15 | -2,503.36 | 77 | 21,417.63 | June 8, 2025: 9 @ 278.15 |
| June 23, 2025 | issue | SO-250623-771 | MAIN | 4 | 278.15 | -1,112.60 | 86 | 23,920.99 | June 8, 2025: 4 @ 278.15 |
| June 8, 2025 | receipt | PO-000614 | MAIN | 90 | 278.15 | 25,033.59 | 90 | 25,033.59 | |
| June 2, 2025 | issue | SO-250602-803 | MAIN | 19 | 279.90 | -5,318.12 | 0 | 0.00 | March 23, 2025: 19 @ 279.90 |
| May 22, 2025 | issue | SO-250522-371 | MAIN | 5 | 279.90 | -1,399.51 | 19 | 5,318.12 | March 23, 2025: 5 @ 279.90 |
| May 20, 2025 | issue | SO-250520-955 | MAIN | 14 | 279.90 | -3,918.62 | 24 | 6,717.63 | March 23, 2025: 14 @ 279.90 |
| May 19, 2025 | issue | SO-250519-372 | MAIN | 17 | 279.90 | -4,758.32 | 38 | 10,636.25 | March 23, 2025: 17 @ 279.90 |
| May 17, 2025 | issue | SO-250517-343 | MAIN | 7 | 279.90 | -1,959.31 | 55 | 15,394.57 | March 23, 2025: 7 @ 279.90 |
| May 6, 2025 | issue | SO-250506-636 | MAIN | 2 | 279.90 | -559.80 | 62 | 17,353.87 | March 23, 2025: 2 @ 279.90 |
| May 5, 2025 | issue | SO-250505-946 | MAIN | 6 | 279.90 | -1,679.41 | 64 | 17,913.68 | March 23, 2025: 6 @ 279.90 |
| April 23, 2025 | issue | SO-250423-460 | MAIN | 10 | 279.90 | -2,799.01 | 70 | 19,593.08 | March 23, 2025: 10 @ 279.90 |
| April 15, 2025 | issue | SO-250415-462 | MAIN | 27 | 272.48 | -7,356.86 | 80 | 22,392.10 | Feb. 2, 2025: 13 @ 268.11; Feb. 8, 2025: 3 @ 268.11; Feb. 19, 2025: 1 @ 268.11; March 23, 2025: 10 @ 279.90 |
| April 12, 2025 | issue | SO-250412-997 | MAIN | 3 | 268.11 | -804.33 | 107 | 29,748.95 | Feb. 2, 2025: 3 @ 268.11 |
| March 23, 2025 | receipt | PO-000367 | MAIN | 90 | 279.90 | 25,191.11 | 110 | 30,553.28 | |
| March 20, 2025 | issue | SO-250320-151 | MAIN | 3 | 268.11 | -804.33 | 20 | 5,362.17 | Feb. 2, 2025: 3 @ 268.11 |
| March 12, 2025 | issue | SO-250312-856 | MAIN | 39 | 268.11 | -10,456.23 | 23 | 6,166.50 | Feb. 2, 2025: 39 @ 268.11 |
| March 11, 2025 | issue | SO-250311-670 | MAIN | 6 | 268.11 | -1,608.65 | 62 | 16,622.73 | Feb. 2, 2025: 6 @ 268.11 |
| Feb. 19, 2025 | return | RMA | MAIN | 1 | 268.11 | 268.11 | 68 | 18,231.38 | |
| Feb. 15, 2025 | issue | SO-250215-966 | MAIN | 1 | 268.11 | -268.11 | 67 | 17,963.27 | Feb. 2, 2025: 1 @ 268.11 |
| Feb. 9, 2025 | issue | SO-250209-244 | MAIN | 15 | 268.11 | -4,021.63 | 68 | 18,231.38 | Feb. 2, 2025: 15 @ 268.11 |
| Feb. 8, 2025 | return | RMA | MAIN | 3 | 268.11 | 804.33 | 83 | 22,253.01 | |
| Feb. 4, 2025 | issue | SO-250204-481 | MAIN | 10 | 268.11 | -2,681.08 | 80 | 21,448.68 | Feb. 2, 2025: 10 @ 268.11 |
| Feb. 2, 2025 | receipt | PO-000234 | MAIN | 90 | 268.11 | 24,129.76 | 90 | 24,129.76 | |
| Jan. 22, 2025 | issue | SO-250122-352 | MAIN | 8 | 261.83 | -2,094.64 | 0 | 0.00 | Nov. 30, 2024: 8 @ 261.83 |
| Jan. 21, 2025 | issue | SO-250121-406 | MAIN | 22 | 261.83 | -5,760.26 | 8 | 2,094.64 | Nov. 30, 2024: 22 @ 261.83 |
| Jan. 19, 2025 | issue | SO-250119-811 | MAIN | 6 | 261.83 | -1,570.98 | 30 | 7,854.90 | Nov. 30, 2024: 6 @ 261.83 |
| Jan. 4, 2025 | issue | SO-250104-839 | MAIN | 15 | 261.83 | -3,927.45 | 36 | 9,425.88 | Nov. 30, 2024: 15 @ 261.83 |
| Dec. 27, 2024 | issue | SO-241227-565 | MAIN | 7 | 261.83 | -1,832.81 | 51 | 13,353.33 | Nov. 30, 2024: 7 @ 261.83 |
| Dec. 19, 2024 | issue | SO-241219-953 | MAIN | 8 | 261.83 | -2,094.64 | 58 | 15,186.14 | Nov. 30, 2024: 8 @ 261.83 |
| Dec. 8, 2024 | issue | SO-241208-114 | MAIN | 1 | 261.83 | -261.83 | 66 | 17,280.78 | Nov. 30, 2024: 1 @ 261.83 |
| Dec. 4, 2024 | adjustment | Cycle count | MAIN | -2 | 261.83 | -523.66 | 67 | 17,542.61 | Nov. 30, 2024: 2 @ 261.83 |
| Dec. 1, 2024 | issue | SO-241201-626 | MAIN | 21 | 261.83 | -5,498.43 | 69 | 18,066.27 | Nov. 30, 2024: 21 @ 261.83 |
| Nov. 30, 2024 | receipt | PO-000066 | MAIN | 90 | 261.83 | 23,564.70 | 90 | 23,564.70 | |
| Nov. 25, 2024 | issue | SO-241125-711 | MAIN | 29 | 276.85 | -8,028.62 | 0 | 0.00 | Oct. 1, 2024: 29 @ 276.85 |
| Nov. 12, 2024 | issue | SO-241112-515 | MAIN | 12 | 276.85 | -3,322.19 | 29 | 8,028.62 | Oct. 1, 2024: 12 @ 276.85 |
| Oct. 24, 2024 | issue | SO-241024-304 | MAIN | 1 | 276.85 | -276.85 | 41 | 11,350.81 | Oct. 1, 2024: 1 @ 276.85 |
| Oct. 15, 2024 | issue | SO-241015-153 | MAIN | 21 | 276.85 | -5,813.83 | 42 | 11,627.66 | Oct. 1, 2024: 21 @ 276.85 |
| Oct. 14, 2024 | issue | SO-241014-355 | MAIN | 6 | 276.85 | -1,661.09 | 63 | 17,441.49 | Oct. 1, 2024: 6 @ 276.85 |
| Oct. 11, 2024 | issue | SO-241011-920 | MAIN | 9 | 276.85 | -2,491.64 | 69 | 19,102.58 | Oct. 1, 2024: 9 @ 276.85 |
| Oct. 7, 2024 | issue | SO-241007-220 | MAIN | 11 | 276.85 | -3,045.34 | 78 | 21,594.22 | Oct. 1, 2024: 11 @ 276.85 |
| Oct. 5, 2024 | issue | SO-241005-520 | MAIN | 1 | 276.85 | -276.85 | 89 | 24,639.56 | Oct. 1, 2024: 1 @ 276.85 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 90 | 276.85 | 24,916.41 | 90 | 24,916.41 | |