Items / TLS-0005
Voltage Tester Elite TLS-0005 · Tools & Testers · ToolMasters Industrial
On hand (EA)9MAIN 9
Value (FIFO)321.03avg 35.67
ClassCY / FCV 0.97
Turnover7.4xlast issue 12 days ago
Days of cover103lead 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.67 / 30.4375 | 0.088 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 2.59 / 5.517 | 0.470 |
| 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.470^2 + 0.088^2 * 1.2^2) | 1.3 |
| Reorder point | d * LT + safety stock | 0.088 * 5.0 + 1.3 | 1.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 1.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 32/yr, S = 45.00, h = 20%, price = 34.99 | 20.3 |
| Inventory position | on hand + on order | 9 + 0 | 9 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 34.99 | 20 | 1,261 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 23, 2026 | 1 / 8 | 34.80 | 34.80 | |
| Oct. 12, 2026 | 8 / 8 | 35.78 | 286.23 |
Movement ledger 24 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | receipt | PO-001873 | MAIN | 8 | 35.78 | 286.23 | 9 | 321.03 | |
| Oct. 4, 2026 | issue | SO-261004-698 | MAIN | 3 | 34.80 | -104.40 | 1 | 34.80 | Aug. 23, 2026: 3 @ 34.80 |
| Sept. 30, 2026 | issue | SO-260930-610 | MAIN | 6 | 34.51 | -207.03 | 4 | 139.19 | April 18, 2026: 2 @ 33.92; Aug. 23, 2026: 4 @ 34.80 |
| Aug. 23, 2026 | receipt | PO-001741 | MAIN | 8 | 34.80 | 278.39 | 10 | 346.22 | |
| Aug. 17, 2026 | issue | SO-260817-570 | MAIN | 4 | 33.92 | -135.67 | 2 | 67.84 | April 18, 2026: 4 @ 33.92 |
| June 25, 2026 | issue | SO-260625-270 | MAIN | 3 | 33.92 | -101.76 | 6 | 203.51 | Nov. 9, 2025: 1 @ 33.92; April 18, 2026: 2 @ 33.92 |
| April 18, 2026 | receipt | PO-001419 | MAIN | 8 | 33.92 | 271.35 | 9 | 305.27 | |
| April 11, 2026 | issue | SO-260411-763 | MAIN | 4 | 33.92 | -135.69 | 1 | 33.92 | Nov. 9, 2025: 4 @ 33.92 |
| Dec. 3, 2025 | issue | SO-251203-795 | MAIN | 3 | 33.92 | -101.77 | 5 | 169.61 | Nov. 9, 2025: 3 @ 33.92 |
| Nov. 9, 2025 | receipt | PO-000987 | MAIN | 8 | 33.92 | 271.38 | 8 | 271.38 | |
| Nov. 4, 2025 | issue | SO-251104-754 | MAIN | 8 | 33.31 | -266.47 | 0 | 0.00 | Oct. 22, 2025: 8 @ 33.31 |
| Oct. 22, 2025 | receipt | PO-000940 | MAIN | 8 | 33.31 | 266.47 | 8 | 266.47 | |
| Oct. 16, 2025 | issue | SO-251016-878 | MAIN | 4 | 33.05 | -132.21 | 0 | 0.00 | June 19, 2025: 4 @ 33.05 |
| Sept. 24, 2025 | issue | SO-250924-947 | MAIN | 3 | 33.05 | -99.16 | 4 | 132.21 | June 19, 2025: 3 @ 33.05 |
| Aug. 20, 2025 | issue | SO-250820-831 | MAIN | 3 | 32.82 | -98.46 | 7 | 231.37 | May 21, 2025: 2 @ 32.70; June 19, 2025: 1 @ 33.05 |
| June 19, 2025 | receipt | PO-000649 | MAIN | 8 | 33.05 | 264.42 | 10 | 329.83 | |
| June 14, 2025 | issue | SO-250614-714 | MAIN | 6 | 32.70 | -196.23 | 2 | 65.41 | May 21, 2025: 6 @ 32.70 |
| May 21, 2025 | receipt | PO-000558 | MAIN | 8 | 32.70 | 261.64 | 8 | 261.64 | |
| May 16, 2025 | issue | SO-250516-808 | MAIN | 3 | 31.78 | -95.33 | 0 | 0.00 | Feb. 12, 2025: 3 @ 31.78 |
| April 12, 2025 | issue | SO-250412-624 | MAIN | 3 | 31.78 | -95.33 | 3 | 95.33 | Feb. 12, 2025: 3 @ 31.78 |
| March 23, 2025 | issue | SO-250323-504 | MAIN | 2 | 31.78 | -63.55 | 6 | 190.66 | Feb. 12, 2025: 2 @ 31.78 |
| Feb. 12, 2025 | receipt | PO-000263 | MAIN | 8 | 31.78 | 254.22 | 8 | 254.22 | |
| Feb. 7, 2025 | issue | SO-250207-414 | MAIN | 4 | 33.24 | -132.96 | 0 | 0.00 | Oct. 1, 2024: 4 @ 33.24 |
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 4 | 33.24 | 132.96 | 4 | 132.96 |