Items / SWT-0037
Modular Switch 6A Classic SWT-0037 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)202MAIN 202
Value (FIFO)1,934.49avg 9.58
ClassCX / FCV 0.16
Turnover5.2xlast issue 2 days ago
Days of cover78lead 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 | 78.75 / 30.4375 | 2.587 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 12.64 / 5.517 | 2.291 |
| 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(7.0 * 2.291^2 + 2.587^2 * 1.5^2) | 9.3 |
| Reorder point | d * LT + safety stock | 2.587 * 7.0 + 9.3 | 27.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 27.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 944/yr, S = 45.00, h = 20%, price = 9.85 | 207.7 |
| Inventory position | on hand + on order | 202 + 0 | 202 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 9.85 | 208 | 9,711 | yes (chosen if cheapest) |
MOQ 250, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 17, 2026 | 165 / 250 | 9.58 | 1,580.16 | |
| Sept. 29, 2026 | 37 / 37 | 9.58 | 354.34 |
Movement ledger 112 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | issue | SO-261014-740 | MAIN | 7 | 9.58 | -67.04 | 202 | 1,934.49 | Sept. 17, 2026: 7 @ 9.58 |
| Oct. 13, 2026 | issue | SO-261013-795 | MAIN | 21 | 9.58 | -201.11 | 209 | 2,001.53 | Sept. 17, 2026: 21 @ 9.58 |
| Oct. 9, 2026 | issue | SO-261009-504 | MAIN | 1 | 9.58 | -9.58 | 230 | 2,202.64 | Sept. 17, 2026: 1 @ 9.58 |
| Oct. 7, 2026 | issue | SO-261007-171 | MAIN | 11 | 9.58 | -105.34 | 231 | 2,212.22 | Sept. 17, 2026: 11 @ 9.58 |
| Oct. 3, 2026 | issue | SO-261003-774 | MAIN | 43 | 9.58 | -411.80 | 242 | 2,317.56 | Sept. 17, 2026: 43 @ 9.58 |
| Sept. 29, 2026 | return | RMA | MAIN | 37 | 9.58 | 354.34 | 285 | 2,729.36 | |
| Sept. 26, 2026 | issue | SO-260926-761 | MAIN | 2 | 9.58 | -19.15 | 248 | 2,375.02 | Sept. 17, 2026: 2 @ 9.58 |
| Sept. 17, 2026 | receipt | PO-001809 | MAIN | 250 | 9.58 | 2,394.18 | 250 | 2,394.18 | |
| Sept. 16, 2026 | issue | SO-260916-682 | EAST | 8 | 9.67 | -77.36 | 0 | 0.00 | July 2, 2026: 2 @ 9.67; Aug. 27, 2026: 6 @ 9.67 |
| Sept. 10, 2026 | issue | SO-260910-807 | EAST | 75 | 9.67 | -725.26 | 8 | 77.36 | July 2, 2026: 75 @ 9.67 |
| Sept. 10, 2026 | issue | SO-260910-807 | MAIN | 8 | 9.67 | -77.36 | 83 | 802.63 | July 2, 2026: 8 @ 9.67 |
| Aug. 31, 2026 | issue | SO-260831-554 | MAIN | 13 | 9.67 | -125.71 | 91 | 879.99 | July 2, 2026: 13 @ 9.67 |
| Aug. 27, 2026 | return | RMA | MAIN | 6 | 9.67 | 58.02 | 104 | 1,005.70 | |
| Aug. 22, 2026 | issue | SO-260822-873 | MAIN | 13 | 9.67 | -125.71 | 98 | 947.68 | July 2, 2026: 13 @ 9.67 |
| Aug. 21, 2026 | issue | SO-260821-587 | MAIN | 1 | 9.67 | -9.67 | 111 | 1,073.39 | July 2, 2026: 1 @ 9.67 |
| Aug. 16, 2026 | issue | SO-260816-243 | MAIN | 31 | 9.67 | -299.78 | 112 | 1,083.06 | July 2, 2026: 31 @ 9.67 |
| Aug. 11, 2026 | issue | SO-260811-496 | MAIN | 14 | 9.67 | -135.38 | 143 | 1,382.84 | July 2, 2026: 14 @ 9.67 |
| July 11, 2026 | issue | SO-260711-966 | MAIN | 11 | 9.67 | -106.37 | 157 | 1,518.22 | July 2, 2026: 11 @ 9.67 |
| July 8, 2026 | issue | SO-260708-939 | MAIN | 82 | 9.67 | -792.96 | 168 | 1,624.59 | July 2, 2026: 82 @ 9.67 |
| July 2, 2026 | transfer | TRF | MAIN → EAST | 83 | warehouse transfer, no cost effect | ||||
| July 2, 2026 | receipt | PO-001619 | MAIN | 250 | 9.67 | 2,417.55 | 250 | 2,417.55 | |
| June 29, 2026 | issue | SO-260629-302 | MAIN | 36 | 9.65 | -347.23 | 0 | 0.00 | April 4, 2026: 36 @ 9.65 |
| June 25, 2026 | issue | SO-260625-585 | MAIN | 4 | 9.65 | -38.58 | 36 | 347.23 | April 4, 2026: 4 @ 9.65 |
| June 19, 2026 | issue | SO-260619-957 | MAIN | 7 | 9.65 | -67.52 | 40 | 385.82 | April 4, 2026: 7 @ 9.65 |
| June 4, 2026 | issue | SO-260604-913 | MAIN | 23 | 9.65 | -221.84 | 47 | 453.33 | April 4, 2026: 23 @ 9.65 |
| June 3, 2026 | issue | SO-260603-270 | MAIN | 15 | 9.65 | -144.68 | 70 | 675.18 | April 4, 2026: 15 @ 9.65 |
| May 17, 2026 | issue | SO-260517-832 | MAIN | 28 | 9.65 | -270.07 | 85 | 819.86 | April 4, 2026: 28 @ 9.65 |
| May 11, 2026 | issue | SO-260511-689 | MAIN | 74 | 9.65 | -713.76 | 113 | 1,089.93 | April 4, 2026: 74 @ 9.65 |
| April 17, 2026 | issue | SO-260417-749 | MAIN | 9 | 9.65 | -86.81 | 187 | 1,803.69 | April 4, 2026: 9 @ 9.65 |
| April 7, 2026 | issue | SO-260407-660 | MAIN | 2 | 9.65 | -19.29 | 196 | 1,890.50 | April 4, 2026: 2 @ 9.65 |
| April 5, 2026 | issue | SO-260405-512 | MAIN | 52 | 9.65 | -501.56 | 198 | 1,909.79 | April 4, 2026: 52 @ 9.65 |
| April 4, 2026 | receipt | PO-001384 | MAIN | 250 | 9.65 | 2,411.35 | 250 | 2,411.35 | |
| March 26, 2026 | issue | SO-260326-277 | MAIN | 58 | 9.70 | -562.69 | 0 | 0.00 | Dec. 21, 2025: 58 @ 9.70 |
| March 15, 2026 | issue | SO-260315-528 | MAIN | 30 | 9.70 | -291.04 | 58 | 562.69 | Dec. 21, 2025: 30 @ 9.70 |
| Feb. 21, 2026 | issue | SO-260221-275 | MAIN | 1 | 9.70 | -9.70 | 88 | 853.73 | Dec. 21, 2025: 1 @ 9.70 |
| Feb. 7, 2026 | issue | SO-260207-664 | MAIN | 84 | 9.70 | -814.93 | 89 | 863.43 | Dec. 21, 2025: 84 @ 9.70 |
| Jan. 30, 2026 | issue | SO-260130-698 | MAIN | 42 | 9.70 | -407.46 | 173 | 1,678.36 | Dec. 21, 2025: 42 @ 9.70 |
| Jan. 17, 2026 | issue | SO-260117-867 | MAIN | 12 | 9.70 | -116.42 | 215 | 2,085.82 | Dec. 21, 2025: 12 @ 9.70 |
| Jan. 8, 2026 | issue | SO-260108-775 | MAIN | 23 | 9.70 | -223.13 | 227 | 2,202.24 | Dec. 21, 2025: 23 @ 9.70 |
| Dec. 21, 2025 | receipt | PO-001072 | MAIN | 250 | 9.70 | 2,425.38 | 250 | 2,425.38 | |
| Dec. 17, 2025 | issue | SO-251217-664 | EAST | 35 | 9.62 | -336.59 | 0 | 0.00 | Sept. 20, 2025: 35 @ 9.62 |
| Dec. 17, 2025 | issue | SO-251217-664 | MAIN | 5 | 9.62 | -48.08 | 35 | 336.59 | Sept. 20, 2025: 5 @ 9.62 |
| Dec. 3, 2025 | issue | SO-251203-736 | MAIN | 35 | 9.62 | -336.59 | 40 | 384.68 | Sept. 20, 2025: 35 @ 9.62 |
| Nov. 29, 2025 | issue | SO-251129-414 | MAIN | 10 | 9.62 | -96.17 | 75 | 721.27 | Sept. 20, 2025: 10 @ 9.62 |
| Nov. 19, 2025 | issue | SO-251119-825 | EAST | 16 | 9.62 | -153.87 | 85 | 817.44 | Sept. 20, 2025: 16 @ 9.62 |
| Nov. 12, 2025 | issue | SO-251112-325 | MAIN | 44 | 9.62 | -423.14 | 101 | 971.31 | Sept. 20, 2025: 44 @ 9.62 |
| Nov. 1, 2025 | issue | SO-251101-786 | MAIN | 13 | 9.62 | -125.02 | 145 | 1,394.45 | Sept. 20, 2025: 13 @ 9.62 |
| Oct. 28, 2025 | issue | SO-251028-329 | MAIN | 9 | 9.62 | -86.55 | 158 | 1,519.47 | Sept. 20, 2025: 9 @ 9.62 |
| Oct. 23, 2025 | issue | SO-251023-253 | MAIN | 30 | 9.62 | -288.51 | 167 | 1,606.02 | Sept. 20, 2025: 30 @ 9.62 |
| Oct. 9, 2025 | issue | SO-251009-401 | MAIN | 33 | 9.62 | -317.36 | 197 | 1,894.53 | Sept. 20, 2025: 33 @ 9.62 |
| Sept. 25, 2025 | issue | SO-250925-142 | MAIN | 12 | 9.62 | -115.40 | 230 | 2,211.89 | Sept. 20, 2025: 12 @ 9.62 |
| Sept. 23, 2025 | issue | SO-250923-783 | EAST | 5 | 9.62 | -48.08 | 242 | 2,327.29 | Sept. 20, 2025: 5 @ 9.62 |
| Sept. 20, 2025 | issue | SO-250920-945 | MAIN | 3 | 9.62 | -28.85 | 247 | 2,375.37 | Sept. 20, 2025: 3 @ 9.62 |
| Sept. 20, 2025 | transfer | TRF | MAIN → EAST | 56 | warehouse transfer, no cost effect | ||||
| Sept. 20, 2025 | receipt | PO-000859 | MAIN | 250 | 9.62 | 2,404.22 | 250 | 2,404.22 | |
| Sept. 16, 2025 | issue | SO-250916-799 | MAIN | 21 | 9.50 | -199.45 | 0 | 0.00 | June 15, 2025: 21 @ 9.50 |
| Sept. 11, 2025 | issue | SO-250911-528 | MAIN | 11 | 9.50 | -104.47 | 21 | 199.45 | June 15, 2025: 11 @ 9.50 |
| Sept. 10, 2025 | issue | SO-250910-230 | MAIN | 55 | 9.50 | -522.36 | 32 | 303.92 | June 15, 2025: 55 @ 9.50 |
| Sept. 8, 2025 | issue | SO-250908-725 | MAIN | 3 | 9.50 | -28.49 | 87 | 826.28 | June 15, 2025: 3 @ 9.50 |
| Aug. 24, 2025 | issue | SO-250824-125 | MAIN | 5 | 9.50 | -47.49 | 90 | 854.78 | June 15, 2025: 5 @ 9.50 |