Items / CSM-0001
Silicone Sealant Nova CSM-0001 · Consumables · ToolMasters Industrial
On hand (TUBE)6MAIN 5, EAST 1
Value (FIFO)179.98avg 30.00
ClassCZ / SCV 1.23
Turnover1.8xlast issue 23 days ago
Days of cover146lead 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.25 / 30.4375 | 0.041 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 1.53 / 5.517 | 0.278 |
| 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.278^2 + 0.041^2 * 1.2^2) | 0.8 |
| Reorder point | d * LT + safety stock | 0.041 * 5.0 + 0.8 | 1.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 1.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 15/yr, S = 45.00, h = 20%, price = 31.16 | 14.7 |
| Inventory position | on hand + on order | 6 + 0 | 6 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 31.16 | 15 | 559 | yes (chosen if cheapest) |
MOQ 11, pack size 12, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| April 28, 2026 | 6 / 12 | 30.00 | 179.98 | Jan. 23, 2027 |
Movement ledger 17 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Sept. 23, 2026 | issue | SO-260923-494 | EAST | 2 | 30.00 | -59.99 | 6 | 179.98 | April 28, 2026: 2 @ 30.00 |
| June 23, 2026 | issue | SO-260623-916 | MAIN | 5 | 29.88 | -149.39 | 8 | 239.98 | July 27, 2025: 1 @ 29.40; April 28, 2026: 4 @ 30.00 |
| April 28, 2026 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| April 28, 2026 | receipt | PO-001447 | MAIN | 12 | 30.00 | 359.97 | 13 | 389.36 | |
| April 23, 2026 | issue | SO-260423-659 | MAIN | 2 | 29.40 | -58.79 | 1 | 29.40 | July 27, 2025: 2 @ 29.40 |
| March 3, 2026 | issue | SO-260303-728 | MAIN | 2 | 29.40 | -58.79 | 3 | 88.19 | July 27, 2025: 2 @ 29.40 |
| Jan. 12, 2026 | issue | SO-260112-840 | MAIN | 1 | 29.40 | -29.40 | 5 | 146.98 | July 27, 2025: 1 @ 29.40 |
| Nov. 3, 2025 | issue | SO-251103-730 | MAIN | 3 | 29.40 | -88.19 | 6 | 176.38 | July 27, 2025: 3 @ 29.40 |
| Oct. 21, 2025 | adjustment | Cycle count | MAIN | -2 | 29.40 | -58.79 | 9 | 264.57 | July 27, 2025: 2 @ 29.40 |
| Sept. 12, 2025 | issue | SO-250912-614 | MAIN | 1 | 29.40 | -29.40 | 11 | 323.37 | July 27, 2025: 1 @ 29.40 |
| Sept. 12, 2025 | issue | SO-250912-614 | EAST | 1 | 29.60 | -29.60 | 12 | 352.76 | Oct. 1, 2024: 1 @ 29.60 |
| July 27, 2025 | receipt | PO-000739 | MAIN | 12 | 29.40 | 352.76 | 13 | 382.37 | |
| July 21, 2025 | issue | SO-250721-968 | MAIN | 3 | 29.60 | -88.81 | 1 | 29.60 | Oct. 1, 2024: 3 @ 29.60 |
| Jan. 1, 2025 | issue | SO-250101-726 | EAST | 2 | 29.60 | -59.20 | 4 | 118.41 | Oct. 1, 2024: 2 @ 29.60 |
| Dec. 28, 2024 | issue | SO-241228-878 | MAIN | 5 | 29.60 | -148.01 | 6 | 177.61 | Oct. 1, 2024: 5 @ 29.60 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 11 | 29.60 | 325.62 | 11 | 325.62 | |