Items / TLS-0007
Wire Stripper Flex TLS-0007 · Tools & Testers · ToolMasters Industrial
On hand (EA)28MAIN 28
Value (FIFO)3,809.11avg 136.04
ClassCY / FCV 0.85
Turnover3.2xlast issue 7 days ago
Days of cover126lead time 5d
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 | 6.75 / 30.4375 | 0.222 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 5.73 / 5.517 | 1.039 |
| 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(5.0 * 1.039^2 + 0.222^2 * 1.2^2) | 3.0 |
| Reorder point | d * LT + safety stock | 0.222 * 5.0 + 3.0 | 4.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 4.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 81/yr, S = 45.00, h = 20%, price = 134.94 | 16.4 |
| Inventory position | on hand + on order | 28 + 0 | 28 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 134.94 | 16 | 11,366 | yes (chosen if cheapest) |
MOQ 2, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 1, 2026 | 6 / 22 | 131.63 | 789.81 | |
| Oct. 12, 2026 | 22 / 22 | 137.24 | 3,019.30 |
Movement ledger 36 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | receipt | PO-001874 | MAIN | 22 | 137.24 | 3,019.30 | 28 | 3,809.11 | |
| Oct. 9, 2026 | issue | SO-261009-594 | MAIN | 8 | 131.63 | -1,053.08 | 6 | 789.81 | Sept. 1, 2026: 8 @ 131.63 |
| Sept. 6, 2026 | issue | SO-260906-765 | MAIN | 9 | 131.60 | -1,184.37 | 14 | 1,842.89 | June 23, 2026: 1 @ 131.29; Sept. 1, 2026: 8 @ 131.63 |
| Sept. 1, 2026 | receipt | PO-001765 | MAIN | 22 | 131.63 | 2,895.97 | 23 | 3,027.26 | |
| Aug. 27, 2026 | issue | SO-260827-608 | MAIN | 9 | 131.29 | -1,181.65 | 1 | 131.29 | June 23, 2026: 9 @ 131.29 |
| July 5, 2026 | issue | SO-260705-520 | MAIN | 6 | 131.29 | -787.77 | 10 | 1,312.94 | June 23, 2026: 6 @ 131.29 |
| July 5, 2026 | issue | SO-260705-520 | EAST | 6 | 131.29 | -787.77 | 16 | 2,100.71 | June 23, 2026: 6 @ 131.29 |
| June 23, 2026 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| June 23, 2026 | receipt | PO-001597 | MAIN | 22 | 131.29 | 2,888.47 | 22 | 2,888.47 | |
| June 20, 2026 | issue | SO-260620-712 | EAST | 1 | 134.25 | -134.25 | 0 | 0.00 | Dec. 23, 2025: 1 @ 134.25 |
| June 20, 2026 | issue | SO-260620-712 | MAIN | 8 | 134.25 | -1,074.00 | 1 | 134.25 | Dec. 23, 2025: 8 @ 134.25 |
| May 10, 2026 | issue | SO-260510-721 | MAIN | 6 | 134.25 | -805.50 | 9 | 1,208.25 | Dec. 23, 2025: 6 @ 134.25 |
| March 23, 2026 | issue | SO-260323-820 | EAST | 11 | 133.59 | -1,469.45 | 15 | 2,013.75 | Oct. 13, 2025: 4 @ 132.42; Dec. 23, 2025: 7 @ 134.25 |
| Dec. 23, 2025 | transfer | TRF | MAIN → EAST | 8 | warehouse transfer, no cost effect | ||||
| Dec. 23, 2025 | receipt | PO-001077 | MAIN | 22 | 134.25 | 2,953.50 | 26 | 3,483.20 | |
| Dec. 19, 2025 | issue | SO-251219-581 | EAST | 1 | 132.42 | -132.42 | 4 | 529.70 | Oct. 13, 2025: 1 @ 132.42 |
| Dec. 19, 2025 | issue | SO-251219-581 | MAIN | 18 | 132.14 | -2,378.48 | 5 | 662.12 | May 7, 2025: 1 @ 127.26; Oct. 13, 2025: 17 @ 132.42 |
| Oct. 13, 2025 | transfer | TRF | MAIN → EAST | 5 | warehouse transfer, no cost effect | ||||
| Oct. 13, 2025 | receipt | PO-000917 | MAIN | 22 | 132.42 | 2,913.34 | 23 | 3,040.60 | |
| Oct. 9, 2025 | issue | SO-251009-211 | MAIN | 6 | 127.26 | -763.58 | 1 | 127.26 | May 7, 2025: 6 @ 127.26 |
| Sept. 27, 2025 | issue | SO-250927-168 | MAIN | 9 | 127.26 | -1,145.37 | 7 | 890.84 | May 7, 2025: 9 @ 127.26 |
| Sept. 27, 2025 | issue | SO-250927-168 | EAST | 6 | 127.26 | -763.58 | 16 | 2,036.22 | May 7, 2025: 6 @ 127.26 |
| May 7, 2025 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| May 7, 2025 | receipt | PO-000519 | MAIN | 22 | 127.26 | 2,799.80 | 22 | 2,799.80 | |
| April 30, 2025 | issue | SO-250430-775 | MAIN | 12 | 126.89 | -1,522.73 | 0 | 0.00 | Feb. 8, 2025: 12 @ 126.89 |
| March 15, 2025 | issue | SO-250315-475 | MAIN | 10 | 126.89 | -1,268.94 | 12 | 1,522.73 | Feb. 8, 2025: 10 @ 126.89 |
| Feb. 12, 2025 | adjustment | Cycle count | MAIN | -1 | 121.81 | -121.81 | 22 | 2,791.68 | Dec. 5, 2024: 1 @ 121.81 |
| Feb. 8, 2025 | receipt | PO-000247 | MAIN | 22 | 126.89 | 2,791.68 | 23 | 2,913.48 | |
| Feb. 3, 2025 | issue | SO-250203-642 | MAIN | 7 | 121.81 | -852.64 | 1 | 121.81 | Dec. 5, 2024: 7 @ 121.81 |
| Jan. 30, 2025 | issue | SO-250130-177 | MAIN | 12 | 121.81 | -1,461.66 | 8 | 974.44 | Dec. 5, 2024: 12 @ 121.81 |
| Dec. 16, 2024 | adjustment | Cycle count | MAIN | -2 | 121.81 | -243.61 | 20 | 2,436.11 | Dec. 5, 2024: 2 @ 121.81 |
| Dec. 5, 2024 | receipt | PO-000080 | MAIN | 22 | 121.81 | 2,679.72 | 22 | 2,679.72 | |
| Dec. 1, 2024 | issue | SO-241201-598 | MAIN | 8 | 128.19 | -1,025.54 | 0 | 0.00 | Oct. 1, 2024: 8 @ 128.19 |
| Dec. 1, 2024 | issue | SO-241201-598 | EAST | 3 | 128.19 | -384.58 | 8 | 1,025.54 | Oct. 1, 2024: 3 @ 128.19 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 11 | 128.19 | 1,410.12 | 11 | 1,410.12 | |