Items / TLS-0010
Insulated Screwdriver Set Plus TLS-0010 · Tools & Testers · ToolMasters Industrial
On hand (EA)7MAIN 7
Value (FIFO)236.63avg 33.80
ClassCY / SCV 0.81
Turnover3.1xlast issue 70 days ago
Days of cover122lead 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 | 1.75 / 30.4375 | 0.057 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 1.42 / 5.517 | 0.258 |
| 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.258^2 + 0.057^2 * 1.2^2) | 0.7 |
| Reorder point | d * LT + safety stock | 0.057 * 5.0 + 0.7 | 1.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 1.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 21/yr, S = 45.00, h = 20%, price = 34.29 | 16.6 |
| Inventory position | on hand + on order | 7 + 0 | 7 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 34.29 | 17 | 833 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 12, 2026 | 7 / 7 | 33.80 | 236.63 |
Movement ledger 25 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Aug. 12, 2026 | receipt | PO-001714 | MAIN | 7 | 33.80 | 236.63 | 7 | 236.63 | |
| Aug. 7, 2026 | issue | SO-260807-970 | MAIN | 2 | 32.96 | -65.92 | 0 | 0.00 | June 1, 2026: 2 @ 32.96 |
| July 5, 2026 | issue | SO-260705-536 | MAIN | 2 | 32.96 | -65.92 | 2 | 65.92 | June 1, 2026: 2 @ 32.96 |
| June 15, 2026 | issue | SO-260615-952 | MAIN | 3 | 32.96 | -98.88 | 4 | 131.84 | June 1, 2026: 3 @ 32.96 |
| June 1, 2026 | receipt | PO-001540 | MAIN | 7 | 32.96 | 230.71 | 7 | 230.71 | |
| May 27, 2026 | issue | SO-260527-485 | MAIN | 4 | 33.63 | -134.53 | 0 | 0.00 | Feb. 19, 2026: 4 @ 33.63 |
| March 21, 2026 | issue | SO-260321-548 | MAIN | 3 | 33.63 | -100.89 | 4 | 134.53 | Feb. 19, 2026: 3 @ 33.63 |
| Feb. 19, 2026 | receipt | PO-001243 | MAIN | 7 | 33.63 | 235.42 | 7 | 235.42 | |
| Feb. 16, 2026 | issue | SO-260216-837 | MAIN | 3 | 32.18 | -96.53 | 0 | 0.00 | Sept. 17, 2025: 3 @ 32.18 |
| Nov. 28, 2025 | issue | SO-251128-270 | MAIN | 3 | 32.18 | -96.53 | 3 | 96.53 | Sept. 17, 2025: 3 @ 32.18 |
| Oct. 1, 2025 | issue | SO-251001-109 | MAIN | 1 | 32.18 | -32.18 | 6 | 193.07 | Sept. 17, 2025: 1 @ 32.18 |
| Sept. 17, 2025 | receipt | PO-000852 | MAIN | 7 | 32.18 | 225.25 | 7 | 225.25 | |
| Sept. 13, 2025 | issue | SO-250913-582 | MAIN | 5 | 31.42 | -157.10 | 0 | 0.00 | April 25, 2025: 5 @ 31.42 |
| July 2, 2025 | issue | SO-250702-130 | MAIN | 1 | 31.42 | -31.42 | 5 | 157.10 | April 25, 2025: 1 @ 31.42 |
| June 4, 2025 | issue | SO-250604-290 | MAIN | 2 | 31.38 | -62.76 | 6 | 188.52 | Feb. 21, 2025: 1 @ 31.34; April 25, 2025: 1 @ 31.42 |
| April 25, 2025 | receipt | PO-000482 | MAIN | 7 | 31.42 | 219.94 | 8 | 251.28 | |
| April 20, 2025 | issue | SO-250420-122 | MAIN | 3 | 31.34 | -94.02 | 1 | 31.34 | Feb. 21, 2025: 3 @ 31.34 |
| March 17, 2025 | issue | SO-250317-603 | MAIN | 3 | 31.34 | -94.02 | 4 | 125.36 | Feb. 21, 2025: 3 @ 31.34 |
| Feb. 21, 2025 | receipt | PO-000290 | MAIN | 7 | 31.34 | 219.37 | 7 | 219.37 | |
| Feb. 15, 2025 | issue | SO-250215-982 | MAIN | 2 | 31.01 | -62.02 | 0 | 0.00 | Nov. 3, 2024: 2 @ 31.01 |
| Jan. 30, 2025 | issue | SO-250130-109 | MAIN | 3 | 31.01 | -93.03 | 2 | 62.02 | Nov. 3, 2024: 3 @ 31.01 |
| Dec. 18, 2024 | issue | SO-241218-263 | MAIN | 3 | 31.53 | -94.60 | 5 | 155.05 | Oct. 1, 2024: 1 @ 32.58; Nov. 3, 2024: 2 @ 31.01 |
| Nov. 3, 2024 | receipt | PO-000022 | MAIN | 7 | 31.01 | 217.07 | 8 | 249.65 | |
| Oct. 29, 2024 | issue | SO-241029-377 | MAIN | 3 | 32.58 | -97.73 | 1 | 32.58 | Oct. 1, 2024: 3 @ 32.58 |
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 4 | 32.58 | 130.30 | 4 | 130.30 |