Items / CAB-0038
FR Wire 1.0 sqmm Plus CAB-0038 · Cables & Wires · Conduit & Cable Co
On hand (COIL)20MAIN 20
Value (FIFO)1,953.65avg 97.68
ClassBX / FCV 0.25
Turnover10.0xlast issue 1 days ago
Days of cover38lead 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 | 15.92 / 30.4375 | 0.523 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 3.97 / 5.517 | 0.719 |
| 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 * 0.719^2 + 0.523^2 * 3.1^2) | 5.2 |
| Reorder point | d * LT + safety stock | 0.523 * 14.0 + 5.2 | 12.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 12.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 191/yr, S = 45.00, h = 20%, price = 101.30 | 29.1 |
| Inventory position | on hand + on order | 20 + 0 | 20 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 101.30 | 29 | 19,925 | yes (chosen if cheapest) |
MOQ 40, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 7, 2026 | 19 / 40 | 97.68 | 1,855.97 | |
| Sept. 25, 2026 | 1 / 1 | 97.68 | 97.68 |
Movement ledger 121 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-239 | MAIN | 14 | 97.68 | -1,367.56 | 20 | 1,953.65 | Sept. 7, 2026: 14 @ 97.68 |
| Oct. 6, 2026 | issue | SO-261006-896 | MAIN | 1 | 97.68 | -97.68 | 34 | 3,321.21 | Sept. 7, 2026: 1 @ 97.68 |
| Sept. 25, 2026 | return | RMA | MAIN | 1 | 97.68 | 97.68 | 35 | 3,418.89 | |
| Sept. 25, 2026 | issue | SO-260925-354 | MAIN | 1 | 97.68 | -97.68 | 34 | 3,321.21 | Sept. 7, 2026: 1 @ 97.68 |
| Sept. 18, 2026 | issue | SO-260918-360 | MAIN | 1 | 97.68 | -97.68 | 35 | 3,418.89 | Sept. 7, 2026: 1 @ 97.68 |
| Sept. 14, 2026 | issue | SO-260914-675 | MAIN | 1 | 97.68 | -97.68 | 36 | 3,516.57 | Sept. 7, 2026: 1 @ 97.68 |
| Sept. 13, 2026 | issue | SO-260913-496 | MAIN | 2 | 97.68 | -195.37 | 37 | 3,614.26 | Sept. 7, 2026: 2 @ 97.68 |
| Sept. 8, 2026 | issue | SO-260908-637 | MAIN | 2 | 98.43 | -196.86 | 39 | 3,809.62 | June 16, 2026: 1 @ 99.18; Sept. 7, 2026: 1 @ 97.68 |
| Sept. 7, 2026 | issue | SO-260907-100 | MAIN | 1 | 99.18 | -99.18 | 41 | 4,006.49 | June 16, 2026: 1 @ 99.18 |
| Sept. 7, 2026 | receipt | PO-001778 | MAIN | 40 | 97.68 | 3,907.30 | 42 | 4,105.67 | |
| Sept. 2, 2026 | issue | SO-260902-527 | MAIN | 5 | 99.18 | -495.91 | 2 | 198.36 | June 16, 2026: 5 @ 99.18 |
| Aug. 18, 2026 | issue | SO-260818-969 | MAIN | 9 | 99.18 | -892.64 | 7 | 694.27 | June 16, 2026: 9 @ 99.18 |
| Aug. 16, 2026 | issue | SO-260816-134 | MAIN | 6 | 99.18 | -595.09 | 16 | 1,586.91 | June 16, 2026: 6 @ 99.18 |
| Aug. 14, 2026 | issue | SO-260814-658 | MAIN | 1 | 99.18 | -99.18 | 22 | 2,182.01 | June 16, 2026: 1 @ 99.18 |
| Aug. 11, 2026 | issue | SO-260811-833 | MAIN | 1 | 99.18 | -99.18 | 23 | 2,281.19 | June 16, 2026: 1 @ 99.18 |
| Aug. 10, 2026 | issue | SO-260810-363 | MAIN | 2 | 99.18 | -198.36 | 24 | 2,380.37 | June 16, 2026: 2 @ 99.18 |
| July 19, 2026 | issue | SO-260719-973 | MAIN | 3 | 99.18 | -297.55 | 26 | 2,578.73 | June 16, 2026: 3 @ 99.18 |
| July 15, 2026 | issue | SO-260715-266 | MAIN | 1 | 99.18 | -99.18 | 29 | 2,876.28 | June 16, 2026: 1 @ 99.18 |
| July 5, 2026 | issue | SO-260705-667 | MAIN | 1 | 99.18 | -99.18 | 30 | 2,975.46 | June 16, 2026: 1 @ 99.18 |
| July 4, 2026 | issue | SO-260704-429 | MAIN | 6 | 99.18 | -595.09 | 31 | 3,074.65 | June 16, 2026: 6 @ 99.18 |
| July 3, 2026 | issue | SO-260703-870 | MAIN | 5 | 100.17 | -500.86 | 37 | 3,669.74 | June 8, 2026: 2 @ 101.66; June 16, 2026: 3 @ 99.18 |
| July 1, 2026 | issue | SO-260701-226 | MAIN | 4 | 101.66 | -406.62 | 42 | 4,170.60 | April 18, 2026: 3 @ 101.66; May 13, 2026: 1 @ 101.66 |
| June 19, 2026 | issue | SO-260619-488 | MAIN | 1 | 101.66 | -101.66 | 46 | 4,577.22 | April 18, 2026: 1 @ 101.66 |
| June 18, 2026 | issue | SO-260618-266 | MAIN | 1 | 101.66 | -101.66 | 47 | 4,678.88 | April 18, 2026: 1 @ 101.66 |
| June 16, 2026 | receipt | PO-001578 | MAIN | 40 | 99.18 | 3,967.28 | 48 | 4,780.53 | |
| June 11, 2026 | issue | SO-260611-874 | MAIN | 5 | 101.66 | -508.28 | 8 | 813.25 | April 18, 2026: 5 @ 101.66 |
| June 8, 2026 | return | RMA | MAIN | 2 | 101.66 | 203.31 | 13 | 1,321.53 | |
| June 4, 2026 | issue | SO-260604-644 | MAIN | 4 | 101.66 | -406.62 | 11 | 1,118.22 | April 18, 2026: 4 @ 101.66 |
| June 3, 2026 | issue | SO-260603-995 | MAIN | 12 | 101.66 | -1,219.87 | 15 | 1,524.84 | April 18, 2026: 12 @ 101.66 |
| May 31, 2026 | issue | SO-260531-782 | MAIN | 1 | 101.66 | -101.66 | 27 | 2,744.72 | April 18, 2026: 1 @ 101.66 |
| May 21, 2026 | issue | SO-260521-527 | MAIN | 1 | 101.66 | -101.66 | 28 | 2,846.37 | April 18, 2026: 1 @ 101.66 |
| May 20, 2026 | issue | SO-260520-569 | MAIN | 2 | 101.66 | -203.31 | 29 | 2,948.03 | April 18, 2026: 2 @ 101.66 |
| May 15, 2026 | issue | SO-260515-501 | MAIN | 1 | 101.66 | -101.66 | 31 | 3,151.34 | April 18, 2026: 1 @ 101.66 |
| May 13, 2026 | return | RMA | MAIN | 1 | 101.66 | 101.66 | 32 | 3,253.00 | |
| May 11, 2026 | issue | SO-260511-712 | MAIN | 5 | 101.66 | -508.28 | 31 | 3,151.34 | April 18, 2026: 5 @ 101.66 |
| May 6, 2026 | issue | SO-260506-934 | MAIN | 1 | 101.66 | -101.66 | 36 | 3,659.62 | April 18, 2026: 1 @ 101.66 |
| May 1, 2026 | issue | SO-260501-825 | MAIN | 3 | 101.66 | -304.97 | 37 | 3,761.28 | April 18, 2026: 3 @ 101.66 |
| April 18, 2026 | receipt | PO-001417 | MAIN | 40 | 101.66 | 4,066.25 | 40 | 4,066.25 | |
| April 3, 2026 | issue | SO-260403-140 | MAIN | 6 | 99.66 | -597.95 | 0 | 0.00 | Jan. 17, 2026: 6 @ 99.66 |
| March 31, 2026 | issue | SO-260331-214 | MAIN | 7 | 99.66 | -697.61 | 6 | 597.95 | Jan. 17, 2026: 7 @ 99.66 |
| March 30, 2026 | issue | SO-260330-664 | MAIN | 1 | 99.66 | -99.66 | 13 | 1,295.55 | Jan. 17, 2026: 1 @ 99.66 |
| March 9, 2026 | issue | SO-260309-467 | MAIN | 3 | 99.66 | -298.97 | 14 | 1,395.21 | Jan. 17, 2026: 3 @ 99.66 |
| March 8, 2026 | issue | SO-260308-965 | MAIN | 5 | 99.66 | -498.29 | 17 | 1,694.18 | Jan. 17, 2026: 5 @ 99.66 |
| Feb. 7, 2026 | issue | SO-260207-201 | MAIN | 4 | 99.66 | -398.63 | 22 | 2,192.47 | Jan. 17, 2026: 4 @ 99.66 |
| Feb. 7, 2026 | issue | SO-260207-201 | EAST | 8 | 99.66 | -797.26 | 26 | 2,591.11 | Jan. 17, 2026: 8 @ 99.66 |
| Feb. 5, 2026 | issue | SO-260205-457 | MAIN | 5 | 99.66 | -498.29 | 34 | 3,388.37 | Jan. 17, 2026: 5 @ 99.66 |
| Jan. 26, 2026 | issue | SO-260126-239 | MAIN | 4 | 96.99 | -387.97 | 39 | 3,886.66 | Nov. 13, 2025: 3 @ 96.10; Jan. 17, 2026: 1 @ 99.66 |
| Jan. 21, 2026 | issue | SO-260121-640 | MAIN | 4 | 96.10 | -384.42 | 43 | 4,274.63 | Nov. 13, 2025: 4 @ 96.10 |
| Jan. 20, 2026 | issue | SO-260120-294 | EAST | 2 | 96.10 | -192.21 | 47 | 4,659.04 | Nov. 13, 2025: 2 @ 96.10 |
| Jan. 17, 2026 | transfer | TRF | MAIN → EAST | 10 | warehouse transfer, no cost effect | ||||
| Jan. 17, 2026 | receipt | PO-001152 | MAIN | 40 | 99.66 | 3,986.32 | 49 | 4,851.25 | |
| Jan. 14, 2026 | issue | SO-260114-188 | MAIN | 1 | 96.10 | -96.10 | 9 | 864.93 | Nov. 13, 2025: 1 @ 96.10 |
| Jan. 11, 2026 | issue | SO-260111-735 | MAIN | 1 | 96.10 | -96.10 | 10 | 961.04 | Nov. 13, 2025: 1 @ 96.10 |
| Jan. 7, 2026 | issue | SO-260107-671 | MAIN | 5 | 96.10 | -480.52 | 11 | 1,057.14 | Nov. 13, 2025: 5 @ 96.10 |
| Dec. 10, 2025 | issue | SO-251210-318 | MAIN | 11 | 96.10 | -1,057.14 | 16 | 1,537.66 | Nov. 13, 2025: 11 @ 96.10 |
| Dec. 7, 2025 | issue | SO-251207-796 | MAIN | 3 | 96.10 | -288.31 | 27 | 2,594.80 | Nov. 13, 2025: 3 @ 96.10 |
| Nov. 23, 2025 | issue | SO-251123-773 | MAIN | 9 | 96.10 | -864.93 | 30 | 2,883.11 | Nov. 13, 2025: 9 @ 96.10 |
| Nov. 15, 2025 | issue | SO-251115-479 | MAIN | 1 | 96.10 | -96.10 | 39 | 3,748.05 | Nov. 13, 2025: 1 @ 96.10 |
| Nov. 15, 2025 | issue | SO-251115-479 | EAST | 8 | 95.52 | -764.14 | 40 | 3,844.15 | Aug. 12, 2025: 8 @ 95.52 |
| Nov. 13, 2025 | receipt | PO-000998 | MAIN | 40 | 96.10 | 3,844.15 | 48 | 4,608.29 | |
| Oct. 27, 2025 | issue | SO-251027-761 | MAIN | 6 | 95.52 | -573.10 | 8 | 764.14 | Aug. 12, 2025: 6 @ 95.52 |
| Oct. 21, 2025 | issue | SO-251021-844 | MAIN | 8 | 95.52 | -764.14 | 14 | 1,337.24 | Aug. 12, 2025: 8 @ 95.52 |
| Oct. 9, 2025 | issue | SO-251009-380 | MAIN | 4 | 95.52 | -382.07 | 22 | 2,101.38 | Aug. 12, 2025: 4 @ 95.52 |
| Sept. 18, 2025 | issue | SO-250918-913 | EAST | 3 | 95.52 | -286.55 | 26 | 2,483.45 | Aug. 12, 2025: 3 @ 95.52 |
| Sept. 15, 2025 | issue | SO-250915-232 | MAIN | 1 | 95.52 | -95.52 | 29 | 2,770.00 | Aug. 12, 2025: 1 @ 95.52 |
| Sept. 12, 2025 | issue | SO-250912-195 | MAIN | 8 | 95.52 | -764.14 | 30 | 2,865.52 | Aug. 12, 2025: 8 @ 95.52 |
| Sept. 8, 2025 | issue | SO-250908-360 | MAIN | 1 | 95.52 | -95.52 | 38 | 3,629.65 | Aug. 12, 2025: 1 @ 95.52 |
| Sept. 2, 2025 | issue | SO-250902-146 | MAIN | 1 | 95.52 | -95.52 | 39 | 3,725.17 | Aug. 12, 2025: 1 @ 95.52 |
| Aug. 12, 2025 | transfer | TRF | MAIN → EAST | 11 | warehouse transfer, no cost effect | ||||
| Aug. 12, 2025 | receipt | PO-000774 | MAIN | 40 | 95.52 | 3,820.69 | 40 | 3,820.69 | |
| Aug. 2, 2025 | issue | SO-250802-903 | MAIN | 2 | 94.36 | -188.72 | 0 | 0.00 | April 24, 2025: 2 @ 94.36 |
| July 30, 2025 | issue | SO-250730-546 | MAIN | 3 | 94.36 | -283.08 | 2 | 188.72 | April 24, 2025: 3 @ 94.36 |
| July 27, 2025 | issue | SO-250727-968 | MAIN | 6 | 94.36 | -566.15 | 5 | 471.79 | April 24, 2025: 6 @ 94.36 |
| July 24, 2025 | issue | SO-250724-550 | MAIN | 3 | 94.36 | -283.08 | 11 | 1,037.95 | April 24, 2025: 3 @ 94.36 |
| July 13, 2025 | issue | SO-250713-114 | MAIN | 5 | 94.36 | -471.79 | 14 | 1,321.02 | April 24, 2025: 5 @ 94.36 |
| July 5, 2025 | issue | SO-250705-594 | MAIN | 2 | 94.36 | -188.72 | 19 | 1,792.82 | April 24, 2025: 2 @ 94.36 |
| June 26, 2025 | issue | SO-250626-931 | MAIN | 4 | 94.36 | -377.44 | 21 | 1,981.54 | April 24, 2025: 4 @ 94.36 |
| June 24, 2025 | issue | SO-250624-111 | MAIN | 2 | 94.36 | -188.72 | 25 | 2,358.97 | April 24, 2025: 2 @ 94.36 |
| June 22, 2025 | issue | SO-250622-602 | MAIN | 4 | 94.36 | -377.44 | 27 | 2,547.69 | April 24, 2025: 4 @ 94.36 |
| June 15, 2025 | issue | SO-250615-678 | MAIN | 1 | 94.36 | -94.36 | 31 | 2,925.13 | April 24, 2025: 1 @ 94.36 |
| June 15, 2025 | issue | SO-250615-678 | EAST | 3 | 94.36 | -283.08 | 32 | 3,019.48 | April 24, 2025: 3 @ 94.36 |
| June 10, 2025 | issue | SO-250610-517 | MAIN | 1 | 94.36 | -94.36 | 35 | 3,302.56 | April 24, 2025: 1 @ 94.36 |
| June 7, 2025 | issue | SO-250607-575 | MAIN | 3 | 94.36 | -283.08 | 36 | 3,396.92 | April 24, 2025: 3 @ 94.36 |
| June 3, 2025 | issue | SO-250603-166 | MAIN | 1 | 94.36 | -94.36 | 39 | 3,680.00 | April 24, 2025: 1 @ 94.36 |
| May 4, 2025 | issue | SO-250504-659 | MAIN | 5 | 93.89 | -469.46 | 40 | 3,774.36 | Jan. 21, 2025: 5 @ 93.89 |
| May 2, 2025 | issue | SO-250502-746 | EAST | 6 | 93.89 | -563.35 | 45 | 4,243.82 | Jan. 21, 2025: 6 @ 93.89 |
| April 24, 2025 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| April 24, 2025 | receipt | PO-000478 | MAIN | 40 | 94.36 | 3,774.36 | 51 | 4,807.17 | |
| April 10, 2025 | issue | SO-250410-926 | MAIN | 5 | 93.89 | -469.46 | 11 | 1,032.82 | Jan. 21, 2025: 5 @ 93.89 |
| April 8, 2025 | issue | SO-250408-341 | MAIN | 6 | 93.89 | -563.35 | 16 | 1,502.28 | Jan. 21, 2025: 6 @ 93.89 |
| March 31, 2025 | issue | SO-250331-371 | MAIN | 1 | 93.89 | -93.89 | 22 | 2,065.63 | Jan. 21, 2025: 1 @ 93.89 |
| March 21, 2025 | issue | SO-250321-734 | MAIN | 1 | 93.89 | -93.89 | 23 | 2,159.53 | Jan. 21, 2025: 1 @ 93.89 |
| March 18, 2025 | issue | SO-250318-349 | MAIN | 4 | 93.89 | -375.57 | 24 | 2,253.42 | Jan. 21, 2025: 4 @ 93.89 |
| March 9, 2025 | issue | SO-250309-622 | MAIN | 3 | 93.89 | -281.68 | 28 | 2,628.99 | Jan. 21, 2025: 3 @ 93.89 |
| March 7, 2025 | issue | SO-250307-473 | MAIN | 1 | 93.89 | -93.89 | 31 | 2,910.66 | Jan. 21, 2025: 1 @ 93.89 |
| March 3, 2025 | issue | SO-250303-640 | MAIN | 2 | 93.89 | -187.78 | 32 | 3,004.56 | Jan. 21, 2025: 2 @ 93.89 |
| Feb. 20, 2025 | issue | SO-250220-505 | MAIN | 4 | 93.89 | -375.57 | 34 | 3,192.34 | Jan. 21, 2025: 4 @ 93.89 |
| Feb. 16, 2025 | issue | SO-250216-311 | MAIN | 1 | 93.89 | -93.89 | 38 | 3,567.91 | Jan. 21, 2025: 1 @ 93.89 |
| Feb. 6, 2025 | issue | SO-250206-938 | MAIN | 1 | 93.89 | -93.89 | 39 | 3,661.80 | Jan. 21, 2025: 1 @ 93.89 |
| Feb. 3, 2025 | issue | SO-250203-681 | MAIN | 5 | 93.75 | -468.77 | 40 | 3,755.70 | Dec. 1, 2024: 5 @ 93.75 |
| Feb. 1, 2025 | issue | SO-250201-937 | MAIN | 1 | 93.75 | -93.75 | 45 | 4,224.47 | Dec. 1, 2024: 1 @ 93.75 |
| Jan. 21, 2025 | receipt | PO-000204 | MAIN | 40 | 93.89 | 3,755.70 | 46 | 4,318.22 | |
| Jan. 11, 2025 | issue | SO-250111-902 | MAIN | 7 | 93.75 | -656.28 | 6 | 562.52 | Dec. 1, 2024: 7 @ 93.75 |
| Jan. 7, 2025 | issue | SO-250107-266 | MAIN | 3 | 93.75 | -281.26 | 13 | 1,218.80 | Dec. 1, 2024: 3 @ 93.75 |
| Jan. 1, 2025 | issue | SO-250101-975 | MAIN | 8 | 93.75 | -750.03 | 16 | 1,500.06 | Dec. 1, 2024: 8 @ 93.75 |
| Dec. 26, 2024 | issue | SO-241226-220 | MAIN | 1 | 93.75 | -93.75 | 24 | 2,250.09 | Dec. 1, 2024: 1 @ 93.75 |
| Dec. 17, 2024 | issue | SO-241217-301 | MAIN | 3 | 93.75 | -281.26 | 25 | 2,343.85 | Dec. 1, 2024: 3 @ 93.75 |
| Dec. 13, 2024 | issue | SO-241213-124 | MAIN | 3 | 93.75 | -281.26 | 28 | 2,625.11 | Dec. 1, 2024: 3 @ 93.75 |
| Dec. 11, 2024 | issue | SO-241211-680 | MAIN | 8 | 93.75 | -750.03 | 31 | 2,906.37 | Dec. 1, 2024: 8 @ 93.75 |
| Dec. 3, 2024 | issue | SO-241203-697 | MAIN | 1 | 93.75 | -93.75 | 39 | 3,656.40 | Dec. 1, 2024: 1 @ 93.75 |
| Dec. 1, 2024 | receipt | PO-000072 | MAIN | 40 | 93.75 | 3,750.16 | 40 | 3,750.16 | |
| Nov. 28, 2024 | issue | SO-241128-121 | MAIN | 7 | 96.24 | -673.64 | 0 | 0.00 | Oct. 1, 2024: 7 @ 96.24 |
| Nov. 23, 2024 | issue | SO-241123-781 | MAIN | 1 | 96.24 | -96.24 | 7 | 673.64 | Oct. 1, 2024: 1 @ 96.24 |
| Nov. 18, 2024 | issue | SO-241118-750 | MAIN | 1 | 96.24 | -96.24 | 8 | 769.88 | Oct. 1, 2024: 1 @ 96.24 |
| Nov. 17, 2024 | issue | SO-241117-935 | MAIN | 4 | 96.24 | -384.94 | 9 | 866.12 | Oct. 1, 2024: 4 @ 96.24 |
| Nov. 14, 2024 | issue | SO-241114-393 | MAIN | 2 | 96.24 | -192.47 | 13 | 1,251.06 | Oct. 1, 2024: 2 @ 96.24 |
| Nov. 7, 2024 | issue | SO-241107-254 | MAIN | 2 | 96.24 | -192.47 | 15 | 1,443.52 | Oct. 1, 2024: 2 @ 96.24 |
| Nov. 1, 2024 | issue | SO-241101-623 | MAIN | 2 | 96.24 | -192.47 | 17 | 1,636.00 | Oct. 1, 2024: 2 @ 96.24 |
| Oct. 29, 2024 | issue | SO-241029-494 | MAIN | 19 | 96.24 | -1,828.46 | 19 | 1,828.46 | Oct. 1, 2024: 19 @ 96.24 |
| Oct. 28, 2024 | issue | SO-241028-912 | MAIN | 2 | 96.24 | -192.47 | 38 | 3,656.93 | Oct. 1, 2024: 2 @ 96.24 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 40 | 96.24 | 3,849.40 | 40 | 3,849.40 | |