Items / TLS-0008
Voltage Tester Elite TLS-0008 · Tools & Testers · ToolMasters Industrial
On hand (EA)18MAIN 18
Value (FIFO)526.78avg 29.27
ClassCY / FCV 0.86
Turnover4.4xlast issue 43 days ago
Days of cover100lead 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 | 5.50 / 30.4375 | 0.181 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 4.75 / 5.517 | 0.861 |
| 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.861^2 + 0.181^2 * 1.2^2) | 2.5 |
| Reorder point | d * LT + safety stock | 0.181 * 5.0 + 2.5 | 3.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 3.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 66/yr, S = 45.00, h = 20%, price = 29.69 | 31.6 |
| Inventory position | on hand + on order | 18 + 0 | 18 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 29.69 | 32 | 2,146 | yes (chosen if cheapest) |
MOQ 2, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 9, 2026 | 18 / 18 | 29.27 | 526.78 |
Movement ledger 24 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Sept. 9, 2026 | receipt | PO-001784 | MAIN | 18 | 29.27 | 526.78 | 18 | 526.78 | |
| Sept. 3, 2026 | issue | SO-260903-528 | EAST | 2 | 29.18 | -58.36 | 0 | 0.00 | July 19, 2026: 2 @ 29.18 |
| Sept. 3, 2026 | issue | SO-260903-528 | MAIN | 7 | 29.18 | -204.26 | 2 | 58.36 | July 19, 2026: 7 @ 29.18 |
| Aug. 27, 2026 | issue | SO-260827-922 | MAIN | 12 | 29.24 | -350.85 | 9 | 262.62 | April 25, 2026: 3 @ 29.41; July 19, 2026: 9 @ 29.18 |
| July 19, 2026 | receipt | PO-001655 | MAIN | 18 | 29.18 | 525.24 | 21 | 613.47 | |
| July 16, 2026 | issue | SO-260716-401 | MAIN | 8 | 29.41 | -235.28 | 3 | 88.23 | April 25, 2026: 8 @ 29.41 |
| June 30, 2026 | issue | SO-260630-967 | MAIN | 9 | 29.10 | -261.91 | 11 | 323.51 | Dec. 9, 2025: 2 @ 28.02; April 25, 2026: 7 @ 29.41 |
| April 25, 2026 | receipt | PO-001437 | MAIN | 18 | 29.41 | 529.38 | 20 | 585.42 | |
| April 21, 2026 | issue | SO-260421-163 | EAST | 4 | 28.02 | -112.08 | 2 | 56.04 | Dec. 9, 2025: 4 @ 28.02 |
| April 21, 2026 | issue | SO-260421-163 | MAIN | 4 | 28.02 | -112.08 | 6 | 168.12 | Dec. 9, 2025: 4 @ 28.02 |
| Jan. 9, 2026 | issue | SO-260109-253 | MAIN | 10 | 27.96 | -279.61 | 10 | 280.20 | May 7, 2025: 2 @ 27.72; Dec. 9, 2025: 8 @ 28.02 |
| Dec. 9, 2025 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| Dec. 9, 2025 | receipt | PO-001040 | MAIN | 18 | 28.02 | 504.36 | 20 | 559.81 | |
| Dec. 4, 2025 | issue | SO-251204-183 | MAIN | 10 | 27.72 | -277.23 | 2 | 55.45 | May 7, 2025: 10 @ 27.72 |
| Sept. 30, 2025 | issue | SO-250930-336 | MAIN | 11 | 27.83 | -306.17 | 12 | 332.68 | Feb. 25, 2025: 5 @ 27.97; May 7, 2025: 6 @ 27.72 |
| May 7, 2025 | receipt | PO-000520 | MAIN | 18 | 27.72 | 499.02 | 23 | 638.85 | |
| May 2, 2025 | issue | SO-250502-223 | MAIN | 11 | 27.97 | -307.62 | 5 | 139.83 | Feb. 25, 2025: 11 @ 27.97 |
| April 5, 2025 | issue | SO-250405-833 | MAIN | 7 | 27.61 | -193.27 | 16 | 447.44 | Oct. 28, 2024: 5 @ 27.47; Feb. 25, 2025: 2 @ 27.97 |
| Feb. 25, 2025 | receipt | PO-000299 | MAIN | 18 | 27.97 | 503.37 | 23 | 640.71 | |
| Feb. 19, 2025 | issue | SO-250219-555 | MAIN | 8 | 27.47 | -219.74 | 5 | 137.34 | Oct. 28, 2024: 8 @ 27.47 |
| Nov. 10, 2024 | issue | SO-241110-605 | MAIN | 6 | 27.59 | -165.54 | 13 | 357.07 | Oct. 1, 2024: 1 @ 28.21; Oct. 28, 2024: 5 @ 27.47 |
| Oct. 28, 2024 | receipt | PO-000015 | MAIN | 18 | 27.47 | 494.41 | 19 | 522.62 | |
| Oct. 23, 2024 | issue | SO-241023-445 | MAIN | 8 | 28.21 | -225.64 | 1 | 28.21 | Oct. 1, 2024: 8 @ 28.21 |
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 9 | 28.21 | 253.85 | 9 | 253.85 | |