Items / CSM-0007
Solder Paste Eco CSM-0007 · Consumables · ToolMasters Industrial
On hand (TUBE)10MAIN 7, EAST 3
Value (FIFO)111.32avg 11.13
ClassCY / SCV 0.89
Turnover2.6xlast issue 78 days ago
Days of cover215lead 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.42 / 30.4375 | 0.047 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 1.26 / 5.517 | 0.228 |
| 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.228^2 + 0.047^2 * 1.2^2) | 0.7 |
| Reorder point | d * LT + safety stock | 0.047 * 5.0 + 0.7 | 0.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 17/yr, S = 45.00, h = 20%, price = 11.56 | 25.7 |
| Inventory position | on hand + on order | 10 + 0 | 10 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 11.56 | 26 | 256 | yes (chosen if cheapest) |
MOQ 15, pack size 12, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 29, 2025 | 10 / 24 | 11.13 | 111.32 | July 26, 2026 |
Movement ledger 14 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| July 30, 2026 | issue | SO-260730-365 | MAIN | 3 | 11.13 | -33.40 | 10 | 111.32 | Oct. 29, 2025: 3 @ 11.13 |
| June 8, 2026 | issue | SO-260608-645 | MAIN | 2 | 11.13 | -22.26 | 13 | 144.72 | Oct. 29, 2025: 2 @ 11.13 |
| April 4, 2026 | issue | SO-260404-541 | EAST | 3 | 11.13 | -33.40 | 15 | 166.98 | Oct. 29, 2025: 3 @ 11.13 |
| Feb. 17, 2026 | issue | SO-260217-950 | MAIN | 2 | 11.13 | -22.26 | 18 | 200.38 | Oct. 29, 2025: 2 @ 11.13 |
| Jan. 6, 2026 | issue | SO-260106-303 | MAIN | 2 | 11.13 | -22.26 | 20 | 222.64 | Oct. 29, 2025: 2 @ 11.13 |
| Nov. 26, 2025 | issue | SO-251126-880 | MAIN | 3 | 11.08 | -33.25 | 22 | 244.90 | Oct. 1, 2024: 1 @ 10.98; Oct. 29, 2025: 2 @ 11.13 |
| Oct. 29, 2025 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| Oct. 29, 2025 | receipt | PO-000962 | MAIN | 24 | 11.13 | 267.17 | 25 | 278.15 | |
| Oct. 24, 2025 | issue | SO-251024-425 | MAIN | 2 | 10.98 | -21.96 | 1 | 10.98 | Oct. 1, 2024: 2 @ 10.98 |
| April 12, 2025 | issue | SO-250412-484 | EAST | 3 | 10.98 | -32.95 | 3 | 32.95 | Oct. 1, 2024: 3 @ 10.98 |
| Jan. 20, 2025 | issue | SO-250120-257 | MAIN | 4 | 10.98 | -43.93 | 6 | 65.89 | Oct. 1, 2024: 4 @ 10.98 |
| Dec. 7, 2024 | issue | SO-241207-474 | MAIN | 5 | 10.98 | -54.91 | 10 | 109.82 | Oct. 1, 2024: 5 @ 10.98 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 15 | 10.98 | 164.73 | 15 | 164.73 | |