Items / IND-0011
Timer Relay Prime IND-0011 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)7MAIN 7
Value (FIFO)5,368.25avg 766.89
ClassBY / SCV 0.96
Turnover4.8xlast issue 78 days ago
Days of cover71lead time 7d
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 | 3.00 / 30.4375 | 0.099 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 2.89 / 5.517 | 0.523 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(7.0 * 0.523^2 + 0.099^2 * 1.5^2) | 2.3 |
| Reorder point | d * LT + safety stock | 0.099 * 7.0 + 2.3 | 3.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 3.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 36/yr, S = 45.00, h = 20%, price = 786.56 | 4.5 |
| Inventory position | on hand + on order | 7 + 0 | 7 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 786.56 | 5 | 29,010 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 5, 2026 | 7 / 7 | 766.89 | 5,368.25 |
Movement ledger 21 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Aug. 5, 2026 | receipt | PO-001698 | MAIN | 7 | 766.89 | 5,368.25 | 7 | 5,368.25 | |
| July 30, 2026 | issue | SO-260730-123 | MAIN | 7 | 793.70 | -5,555.89 | 0 | 0.00 | May 23, 2026: 7 @ 793.70 |
| May 23, 2026 | receipt | PO-001518 | MAIN | 7 | 793.70 | 5,555.89 | 7 | 5,555.89 | |
| May 18, 2026 | issue | SO-260518-492 | MAIN | 7 | 774.58 | -5,422.07 | 0 | 0.00 | April 21, 2026: 7 @ 774.58 |
| April 21, 2026 | receipt | PO-001428 | MAIN | 7 | 774.58 | 5,422.07 | 7 | 5,422.07 | |
| April 15, 2026 | issue | SO-260415-960 | MAIN | 5 | 770.25 | -3,851.24 | 0 | 0.00 | Feb. 19, 2026: 5 @ 770.25 |
| March 1, 2026 | issue | SO-260301-817 | MAIN | 4 | 756.19 | -3,024.78 | 5 | 3,851.24 | Dec. 17, 2025: 2 @ 742.14; Feb. 19, 2026: 2 @ 770.25 |
| Feb. 19, 2026 | receipt | PO-001244 | MAIN | 7 | 770.25 | 5,391.74 | 9 | 6,876.02 | |
| Feb. 11, 2026 | issue | SO-260211-453 | MAIN | 7 | 745.78 | -5,220.46 | 2 | 1,484.28 | Sept. 23, 2025: 2 @ 754.88; Dec. 17, 2025: 5 @ 742.14 |
| Dec. 17, 2025 | receipt | PO-001059 | MAIN | 7 | 742.14 | 5,194.99 | 9 | 6,704.74 | |
| Dec. 9, 2025 | issue | SO-251209-367 | MAIN | 2 | 754.88 | -1,509.75 | 2 | 1,509.75 | Sept. 23, 2025: 2 @ 754.88 |
| Nov. 26, 2025 | issue | SO-251126-106 | MAIN | 4 | 755.14 | -3,020.56 | 4 | 3,019.50 | March 31, 2025: 1 @ 755.93; Sept. 23, 2025: 3 @ 754.88 |
| Sept. 23, 2025 | receipt | PO-000868 | MAIN | 7 | 754.88 | 5,284.12 | 8 | 6,040.06 | |
| Sept. 18, 2025 | issue | SO-250918-905 | MAIN | 8 | 745.46 | -5,963.71 | 1 | 755.93 | Jan. 27, 2025: 2 @ 714.05; March 31, 2025: 6 @ 755.93 |
| March 31, 2025 | receipt | PO-000398 | MAIN | 7 | 755.93 | 5,291.54 | 9 | 6,719.64 | |
| March 26, 2025 | issue | SO-250326-357 | MAIN | 5 | 714.05 | -3,570.25 | 2 | 1,428.10 | Jan. 27, 2025: 5 @ 714.05 |
| Jan. 27, 2025 | receipt | PO-000225 | MAIN | 7 | 714.05 | 4,998.36 | 7 | 4,998.36 | |
| Jan. 19, 2025 | issue | SO-250119-596 | MAIN | 7 | 725.27 | -5,076.87 | 0 | 0.00 | Nov. 16, 2024: 7 @ 725.27 |
| Nov. 16, 2024 | receipt | PO-000036 | MAIN | 7 | 725.27 | 5,076.87 | 7 | 5,076.87 | |
| Nov. 10, 2024 | issue | SO-241110-528 | MAIN | 4 | 747.23 | -2,988.93 | 0 | 0.00 | Oct. 1, 2024: 4 @ 747.23 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 4 | 747.23 | 2,988.93 | 4 | 2,988.93 |