Items / TLS-0004
Crimping Tool Eco TLS-0004 · Tools & Testers · ToolMasters Industrial
On hand (EA)8MAIN 8
Value (FIFO)1,743.26avg 217.91
ClassCY / FCV 0.75
Turnover3.0xlast issue 47 days ago
Days of cover108lead 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 | 2.25 / 30.4375 | 0.074 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 1.69 / 5.517 | 0.306 |
| 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 * 0.306^2 + 0.074^2 * 1.2^2) | 0.9 |
| Reorder point | d * LT + safety stock | 0.074 * 5.0 + 0.9 | 1.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 1.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 27/yr, S = 45.00, h = 20%, price = 223.27 | 7.4 |
| Inventory position | on hand + on order | 8 + 0 | 8 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 223.27 | 7 | 6,353 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 3, 2026 | 8 / 8 | 217.91 | 1,743.26 |
Movement ledger 21 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Sept. 3, 2026 | receipt | PO-001773 | MAIN | 8 | 217.91 | 1,743.26 | 8 | 1,743.26 | |
| Aug. 30, 2026 | issue | SO-260830-419 | MAIN | 3 | 219.87 | -659.62 | 0 | 0.00 | May 2, 2026: 3 @ 219.87 |
| July 31, 2026 | issue | SO-260731-751 | MAIN | 4 | 219.87 | -879.50 | 3 | 659.62 | May 2, 2026: 4 @ 219.87 |
| June 30, 2026 | issue | SO-260630-204 | MAIN | 3 | 216.45 | -649.36 | 7 | 1,539.12 | Feb. 23, 2026: 2 @ 214.74; May 2, 2026: 1 @ 219.87 |
| May 2, 2026 | receipt | PO-001457 | MAIN | 8 | 219.87 | 1,759.00 | 10 | 2,188.48 | |
| April 27, 2026 | issue | SO-260427-377 | MAIN | 4 | 214.74 | -858.96 | 2 | 429.48 | Feb. 23, 2026: 4 @ 214.74 |
| March 25, 2026 | issue | SO-260325-360 | MAIN | 4 | 211.38 | -845.52 | 6 | 1,288.44 | Oct. 6, 2025: 2 @ 208.02; Feb. 23, 2026: 2 @ 214.74 |
| Feb. 23, 2026 | receipt | PO-001254 | MAIN | 8 | 214.74 | 1,717.92 | 10 | 2,133.96 | |
| Feb. 19, 2026 | issue | SO-260219-261 | MAIN | 2 | 208.02 | -416.03 | 2 | 416.03 | Oct. 6, 2025: 2 @ 208.02 |
| Nov. 17, 2025 | issue | SO-251117-525 | MAIN | 4 | 208.02 | -832.07 | 4 | 832.07 | Oct. 6, 2025: 4 @ 208.02 |
| Oct. 6, 2025 | receipt | PO-000903 | MAIN | 8 | 208.02 | 1,664.14 | 8 | 1,664.14 | |
| Oct. 4, 2025 | issue | SO-251004-847 | MAIN | 3 | 210.02 | -630.05 | 0 | 0.00 | June 6, 2025: 3 @ 210.02 |
| Aug. 5, 2025 | issue | SO-250805-698 | MAIN | 5 | 210.02 | -1,050.08 | 3 | 630.05 | June 6, 2025: 5 @ 210.02 |
| June 6, 2025 | receipt | PO-000607 | MAIN | 8 | 210.02 | 1,680.14 | 8 | 1,680.14 | |
| May 31, 2025 | issue | SO-250531-825 | MAIN | 6 | 203.30 | -1,219.81 | 0 | 0.00 | Dec. 26, 2024: 6 @ 203.30 |
| April 27, 2025 | issue | SO-250427-432 | MAIN | 4 | 206.14 | -824.54 | 6 | 1,219.81 | Oct. 12, 2024: 2 @ 208.97; Dec. 26, 2024: 2 @ 203.30 |
| Dec. 26, 2024 | receipt | PO-000137 | MAIN | 8 | 203.30 | 1,626.41 | 10 | 2,044.35 | |
| Dec. 21, 2024 | issue | SO-241221-573 | MAIN | 6 | 208.97 | -1,253.83 | 2 | 417.94 | Oct. 12, 2024: 6 @ 208.97 |
| Oct. 12, 2024 | receipt | PO-000008 | MAIN | 8 | 208.97 | 1,671.77 | 8 | 1,671.77 | |
| Oct. 7, 2024 | issue | SO-241007-401 | MAIN | 4 | 212.11 | -848.43 | 0 | 0.00 | Oct. 1, 2024: 4 @ 212.11 |
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 4 | 212.11 | 848.43 | 4 | 848.43 |