Items / TLS-0011
Voltage Tester Nova TLS-0011 · Tools & Testers · ToolMasters Industrial
On hand (EA)26MAIN 26
Value (FIFO)1,751.01avg 67.35
ClassCY / FCV 0.89
Turnover3.3xlast issue 31 days ago
Days of cover148lead 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.33 / 30.4375 | 0.175 |
| 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.175^2 * 1.2^2) | 2.5 |
| Reorder point | d * LT + safety stock | 0.175 * 5.0 + 2.5 | 3.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 3.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 64/yr, S = 45.00, h = 20%, price = 68.61 | 20.5 |
| Inventory position | on hand + on order | 26 + 0 | 26 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 68.61 | 20 | 4,669 | yes (chosen if cheapest) |
MOQ 2, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| April 1, 2026 | 4 / 22 | 68.89 | 275.54 | |
| Sept. 21, 2026 | 22 / 22 | 67.07 | 1,475.47 |
Movement ledger 28 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Sept. 21, 2026 | receipt | PO-001817 | MAIN | 22 | 67.07 | 1,475.47 | 26 | 1,751.01 | |
| Sept. 15, 2026 | issue | SO-260915-398 | MAIN | 7 | 68.89 | -482.20 | 4 | 275.54 | April 1, 2026: 7 @ 68.89 |
| June 17, 2026 | issue | SO-260617-620 | MAIN | 10 | 68.89 | -688.85 | 11 | 757.74 | April 1, 2026: 10 @ 68.89 |
| April 5, 2026 | issue | SO-260405-910 | MAIN | 7 | 65.21 | -456.46 | 21 | 1,446.59 | Nov. 13, 2025: 6 @ 64.60; April 1, 2026: 1 @ 68.89 |
| April 1, 2026 | receipt | PO-001374 | MAIN | 22 | 68.89 | 1,515.47 | 28 | 1,903.05 | |
| March 26, 2026 | issue | SO-260326-355 | MAIN | 7 | 64.60 | -452.17 | 6 | 387.57 | Nov. 13, 2025: 7 @ 64.60 |
| Jan. 25, 2026 | issue | SO-260125-154 | MAIN | 10 | 64.52 | -645.21 | 13 | 839.75 | Sept. 8, 2025: 1 @ 63.85; Nov. 13, 2025: 9 @ 64.60 |
| Nov. 13, 2025 | receipt | PO-000999 | MAIN | 22 | 64.60 | 1,421.11 | 23 | 1,484.95 | |
| Nov. 9, 2025 | issue | SO-251109-798 | MAIN | 11 | 63.85 | -702.32 | 1 | 63.85 | Sept. 8, 2025: 11 @ 63.85 |
| Oct. 16, 2025 | issue | SO-251016-175 | MAIN | 12 | 63.89 | -766.70 | 12 | 766.17 | July 7, 2025: 2 @ 64.11; Sept. 8, 2025: 10 @ 63.85 |
| Sept. 8, 2025 | receipt | PO-000822 | MAIN | 22 | 63.85 | 1,404.64 | 24 | 1,532.87 | |
| Sept. 3, 2025 | issue | SO-250903-739 | MAIN | 15 | 64.11 | -961.72 | 2 | 128.23 | July 7, 2025: 15 @ 64.11 |
| Aug. 26, 2025 | issue | SO-250826-999 | MAIN | 8 | 64.54 | -516.29 | 17 | 1,089.95 | May 11, 2025: 3 @ 65.24; July 7, 2025: 5 @ 64.11 |
| July 7, 2025 | receipt | PO-000692 | MAIN | 22 | 64.11 | 1,410.53 | 25 | 1,606.24 | |
| July 3, 2025 | issue | SO-250703-440 | MAIN | 7 | 65.24 | -456.67 | 3 | 195.71 | May 11, 2025: 7 @ 65.24 |
| June 11, 2025 | issue | SO-250611-176 | MAIN | 12 | 65.24 | -782.85 | 10 | 652.38 | May 11, 2025: 12 @ 65.24 |
| May 11, 2025 | receipt | PO-000529 | MAIN | 22 | 65.24 | 1,435.23 | 22 | 1,435.23 | |
| May 6, 2025 | issue | SO-250506-696 | MAIN | 17 | 64.92 | -1,103.62 | 0 | 0.00 | April 2, 2025: 17 @ 64.92 |
| April 3, 2025 | issue | SO-250403-730 | MAIN | 11 | 64.66 | -711.26 | 17 | 1,103.62 | Dec. 27, 2024: 6 @ 64.44; April 2, 2025: 5 @ 64.92 |
| April 2, 2025 | receipt | PO-000402 | MAIN | 22 | 64.92 | 1,428.22 | 28 | 1,814.89 | |
| March 27, 2025 | issue | SO-250327-396 | MAIN | 5 | 64.44 | -322.22 | 6 | 386.67 | Dec. 27, 2024: 5 @ 64.44 |
| March 27, 2025 | issue | SO-250327-396 | EAST | 2 | 64.44 | -128.89 | 11 | 708.90 | Dec. 27, 2024: 2 @ 64.44 |
| Jan. 4, 2025 | issue | SO-250104-303 | MAIN | 11 | 64.58 | -710.36 | 13 | 837.78 | Oct. 1, 2024: 2 @ 65.18; Dec. 27, 2024: 9 @ 64.44 |
| Dec. 27, 2024 | receipt | PO-000142 | MAIN | 22 | 64.44 | 1,417.79 | 24 | 1,548.15 | |
| Dec. 21, 2024 | issue | SO-241221-664 | EAST | 1 | 65.18 | -65.18 | 2 | 130.36 | Oct. 1, 2024: 1 @ 65.18 |
| Dec. 21, 2024 | issue | SO-241221-664 | MAIN | 8 | 65.18 | -521.44 | 3 | 195.54 | Oct. 1, 2024: 8 @ 65.18 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 11 | 65.18 | 716.97 | 11 | 716.97 | |