Items / CSM-0005
Silicone Sealant Max CSM-0005 · Consumables · ToolMasters Industrial
On hand (TUBE)4MAIN 4
Value (FIFO)199.72avg 49.93
ClassCZ / FCV 1.20
Turnover2.8xlast issue 6 days ago
Days of cover104lead 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.17 / 30.4375 | 0.038 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 1.40 / 5.517 | 0.255 |
| 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.255^2 + 0.038^2 * 1.2^2) | 0.7 |
| Reorder point | d * LT + safety stock | 0.038 * 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 = 14/yr, S = 45.00, h = 20%, price = 49.57 | 11.3 |
| Inventory position | on hand + on order | 4 + 0 | 4 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 49.57 | 11 | 805 | yes (chosen if cheapest) |
MOQ 11, pack size 12, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| May 31, 2026 | 4 / 12 | 49.93 | 199.72 | Feb. 25, 2027 |
Movement ledger 21 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 10, 2026 | issue | SO-261010-555 | MAIN | 2 | 49.93 | -99.86 | 4 | 199.72 | May 31, 2026: 2 @ 49.93 |
| Sept. 24, 2026 | issue | SO-260924-567 | MAIN | 1 | 49.93 | -49.93 | 6 | 299.58 | May 31, 2026: 1 @ 49.93 |
| Aug. 21, 2026 | issue | SO-260821-709 | MAIN | 1 | 49.93 | -49.93 | 7 | 349.51 | May 31, 2026: 1 @ 49.93 |
| Aug. 21, 2026 | issue | SO-260821-709 | EAST | 3 | 49.93 | -149.79 | 8 | 399.44 | May 31, 2026: 3 @ 49.93 |
| June 24, 2026 | issue | SO-260624-409 | MAIN | 1 | 49.93 | -49.93 | 11 | 549.23 | May 31, 2026: 1 @ 49.93 |
| May 31, 2026 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| May 31, 2026 | receipt | PO-001537 | MAIN | 12 | 49.93 | 599.16 | 12 | 599.16 | |
| May 25, 2026 | issue | SO-260525-749 | MAIN | 1 | 46.73 | -46.73 | 0 | 0.00 | May 23, 2025: 1 @ 46.73 |
| May 25, 2026 | issue | SO-260525-749 | EAST | 2 | 46.73 | -93.47 | 1 | 46.73 | May 23, 2025: 2 @ 46.73 |
| March 18, 2026 | issue | SO-260318-263 | MAIN | 3 | 46.73 | -140.20 | 3 | 140.20 | May 23, 2025: 3 @ 46.73 |
| Oct. 5, 2025 | issue | SO-251005-368 | MAIN | 2 | 46.73 | -93.47 | 6 | 280.40 | May 23, 2025: 2 @ 46.73 |
| Sept. 28, 2025 | issue | SO-250928-965 | MAIN | 3 | 46.73 | -140.20 | 8 | 373.86 | May 23, 2025: 3 @ 46.73 |
| July 23, 2025 | issue | SO-250723-306 | EAST | 1 | 46.73 | -46.73 | 11 | 514.06 | May 23, 2025: 1 @ 46.73 |
| May 23, 2025 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| May 23, 2025 | receipt | PO-000564 | MAIN | 12 | 46.73 | 560.79 | 12 | 560.79 | |
| May 21, 2025 | issue | SO-250521-481 | MAIN | 4 | 47.09 | -188.37 | 0 | 0.00 | Oct. 1, 2024: 4 @ 47.09 |
| April 15, 2025 | issue | SO-250415-946 | MAIN | 3 | 47.09 | -141.27 | 4 | 188.37 | Oct. 1, 2024: 3 @ 47.09 |
| Feb. 20, 2025 | issue | SO-250220-402 | MAIN | 2 | 47.09 | -94.18 | 7 | 329.64 | Oct. 1, 2024: 2 @ 47.09 |
| Oct. 9, 2024 | issue | SO-241009-399 | EAST | 2 | 47.09 | -94.18 | 9 | 423.82 | Oct. 1, 2024: 2 @ 47.09 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 2 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 11 | 47.09 | 518.01 | 11 | 518.01 | |