Items / CSM-0003
Silicone Sealant Max CSM-0003 · Consumables · ToolMasters Industrial
On hand (TUBE)10MAIN 10
Value (FIFO)225.95avg 22.60
ClassCY / FCV 0.66
Turnover2.2xlast issue 12 days ago
Days of cover107lead 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.83 / 30.4375 | 0.093 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 1.86 / 5.517 | 0.338 |
| 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.338^2 + 0.093^2 * 1.2^2) | 1.0 |
| Reorder point | d * LT + safety stock | 0.093 * 5.0 + 1.0 | 1.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 1.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 34/yr, S = 45.00, h = 20%, price = 22.82 | 25.9 |
| 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 | 22.82 | 26 | 893 | yes (chosen if cheapest) |
MOQ 17, pack size 12, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| June 3, 2026 | 10 / 24 | 22.60 | 225.95 | Feb. 28, 2027 |
Movement ledger 18 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 4, 2026 | issue | SO-261004-436 | MAIN | 4 | 22.60 | -90.38 | 10 | 225.95 | June 3, 2026: 4 @ 22.60 |
| Sept. 22, 2026 | issue | SO-260922-885 | MAIN | 5 | 22.60 | -112.98 | 14 | 316.33 | June 3, 2026: 5 @ 22.60 |
| June 10, 2026 | issue | SO-260610-508 | MAIN | 5 | 22.60 | -112.98 | 19 | 429.30 | June 3, 2026: 5 @ 22.60 |
| June 3, 2026 | receipt | PO-001546 | MAIN | 24 | 22.60 | 542.28 | 24 | 542.28 | |
| May 28, 2026 | issue | SO-260528-383 | EAST | 4 | 22.29 | -89.14 | 0 | 0.00 | Sept. 19, 2025: 4 @ 22.29 |
| March 9, 2026 | issue | SO-260309-839 | MAIN | 4 | 22.29 | -89.14 | 4 | 89.14 | Sept. 19, 2025: 4 @ 22.29 |
| Feb. 5, 2026 | issue | SO-260205-217 | MAIN | 3 | 22.29 | -66.86 | 8 | 178.29 | Sept. 19, 2025: 3 @ 22.29 |
| Jan. 12, 2026 | issue | SO-260112-549 | MAIN | 5 | 22.29 | -111.43 | 11 | 245.15 | Sept. 19, 2025: 5 @ 22.29 |
| Dec. 16, 2025 | issue | SO-251216-519 | MAIN | 3 | 22.29 | -66.86 | 16 | 356.58 | Sept. 19, 2025: 3 @ 22.29 |
| Nov. 17, 2025 | issue | SO-251117-859 | MAIN | 3 | 22.29 | -66.86 | 19 | 423.43 | Sept. 19, 2025: 3 @ 22.29 |
| Oct. 29, 2025 | issue | SO-251029-122 | EAST | 2 | 22.29 | -44.57 | 22 | 490.29 | Sept. 19, 2025: 2 @ 22.29 |
| Sept. 19, 2025 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| Sept. 19, 2025 | receipt | PO-000858 | MAIN | 24 | 22.29 | 534.86 | 24 | 534.86 | |
| Sept. 14, 2025 | issue | SO-250914-250 | MAIN | 3 | 21.68 | -65.04 | 0 | 0.00 | Oct. 1, 2024: 3 @ 21.68 |
| July 27, 2025 | issue | SO-250727-596 | MAIN | 4 | 21.68 | -86.72 | 3 | 65.04 | Oct. 1, 2024: 4 @ 21.68 |
| May 31, 2025 | issue | SO-250531-907 | MAIN | 3 | 21.68 | -65.04 | 7 | 151.75 | Oct. 1, 2024: 3 @ 21.68 |
| Oct. 9, 2024 | issue | SO-241009-544 | MAIN | 7 | 21.68 | -151.75 | 10 | 216.79 | Oct. 1, 2024: 7 @ 21.68 |
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 17 | 21.68 | 368.54 | 17 | 368.54 | |