Items / SWT-0038
Switch Plate 4M Eco SWT-0038 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)358MAIN 358
Value (FIFO)4,109.41avg 11.48
ClassBX / FCV 0.23
Turnover5.0xlast issue 3 days ago
Days of cover67lead 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 | 162.33 / 30.4375 | 5.333 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 36.89 / 5.517 | 6.687 |
| 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 * 6.687^2 + 5.333^2 * 1.5^2) | 32.0 |
| Reorder point | d * LT + safety stock | 5.333 * 7.0 + 32.0 | 69.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 69.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1947/yr, S = 45.00, h = 20%, price = 11.31 | 278.3 |
| Inventory position | on hand + on order | 358 + 0 | 358 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 11.31 | 278 | 22,646 | yes (chosen if cheapest) |
MOQ 480, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 22, 2026 | 358 / 480 | 11.48 | 4,109.41 |
Movement ledger 128 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 13, 2026 | issue | SO-261013-409 | MAIN | 33 | 11.48 | -378.80 | 358 | 4,109.41 | Sept. 22, 2026: 33 @ 11.48 |
| Oct. 5, 2026 | issue | SO-261005-781 | MAIN | 51 | 11.48 | -585.42 | 391 | 4,488.21 | Sept. 22, 2026: 51 @ 11.48 |
| Oct. 1, 2026 | issue | SO-261001-796 | MAIN | 65 | 11.38 | -739.71 | 442 | 5,073.63 | June 16, 2026: 24 @ 11.24; July 29, 2026: 3 @ 11.24; Sept. 22, 2026: 38 @ 11.48 |
| Sept. 26, 2026 | issue | SO-260926-987 | MAIN | 12 | 11.24 | -134.90 | 507 | 5,813.34 | June 16, 2026: 12 @ 11.24 |
| Sept. 22, 2026 | receipt | PO-001820 | MAIN | 480 | 11.48 | 5,509.82 | 519 | 5,948.24 | |
| Sept. 16, 2026 | issue | SO-260916-260 | MAIN | 95 | 11.24 | -1,067.94 | 39 | 438.42 | June 16, 2026: 95 @ 11.24 |
| Sept. 14, 2026 | issue | SO-260914-340 | MAIN | 2 | 11.24 | -22.48 | 134 | 1,506.36 | June 16, 2026: 2 @ 11.24 |
| Aug. 30, 2026 | issue | SO-260830-214 | MAIN | 30 | 11.24 | -337.24 | 136 | 1,528.84 | June 16, 2026: 30 @ 11.24 |
| Aug. 20, 2026 | issue | SO-260820-431 | MAIN | 33 | 11.24 | -370.97 | 166 | 1,866.09 | June 16, 2026: 33 @ 11.24 |
| Aug. 20, 2026 | issue | SO-260820-431 | EAST | 22 | 11.24 | -247.31 | 199 | 2,237.06 | June 16, 2026: 22 @ 11.24 |
| Aug. 12, 2026 | issue | SO-260812-636 | MAIN | 110 | 11.24 | -1,236.56 | 221 | 2,484.37 | June 16, 2026: 110 @ 11.24 |
| Aug. 6, 2026 | issue | SO-260806-980 | MAIN | 10 | 11.24 | -112.42 | 331 | 3,720.94 | June 16, 2026: 10 @ 11.24 |
| July 29, 2026 | return | RMA | MAIN | 3 | 11.24 | 33.72 | 341 | 3,833.35 | |
| July 28, 2026 | issue | SO-260728-847 | MAIN | 114 | 11.24 | -1,281.53 | 338 | 3,799.63 | June 16, 2026: 114 @ 11.24 |
| July 13, 2026 | issue | SO-260713-608 | MAIN | 7 | 11.24 | -78.69 | 452 | 5,081.16 | June 16, 2026: 7 @ 11.24 |
| July 11, 2026 | issue | SO-260711-648 | EAST | 7 | 11.24 | -78.69 | 459 | 5,159.85 | June 16, 2026: 7 @ 11.24 |
| July 10, 2026 | issue | SO-260710-834 | MAIN | 1 | 11.24 | -11.24 | 466 | 5,238.54 | June 16, 2026: 1 @ 11.24 |
| July 1, 2026 | issue | SO-260701-949 | MAIN | 6 | 11.24 | -67.45 | 467 | 5,249.78 | June 16, 2026: 6 @ 11.24 |
| June 17, 2026 | issue | SO-260617-824 | MAIN | 36 | 10.89 | -391.95 | 473 | 5,317.23 | March 26, 2026: 29 @ 10.80; June 16, 2026: 7 @ 11.24 |
| June 16, 2026 | receipt | PO-001581 | MAIN | 480 | 11.24 | 5,395.92 | 509 | 5,709.18 | |
| June 11, 2026 | issue | SO-260611-441 | EAST | 5 | 10.80 | -54.01 | 29 | 313.26 | March 26, 2026: 5 @ 10.80 |
| June 11, 2026 | issue | SO-260611-441 | MAIN | 96 | 10.80 | -1,037.00 | 34 | 367.27 | March 26, 2026: 96 @ 10.80 |
| June 10, 2026 | issue | SO-260610-103 | MAIN | 19 | 10.80 | -205.24 | 130 | 1,404.27 | March 26, 2026: 19 @ 10.80 |
| May 24, 2026 | issue | SO-260524-887 | MAIN | 46 | 10.80 | -496.90 | 149 | 1,609.51 | March 26, 2026: 46 @ 10.80 |
| May 22, 2026 | issue | SO-260522-610 | MAIN | 49 | 10.80 | -529.30 | 195 | 2,106.41 | March 26, 2026: 49 @ 10.80 |
| May 18, 2026 | issue | SO-260518-807 | MAIN | 22 | 10.80 | -237.65 | 244 | 2,635.71 | March 26, 2026: 22 @ 10.80 |
| May 15, 2026 | issue | SO-260515-382 | EAST | 41 | 10.80 | -442.89 | 266 | 2,873.36 | March 26, 2026: 41 @ 10.80 |
| April 26, 2026 | issue | SO-260426-886 | MAIN | 38 | 10.80 | -410.48 | 307 | 3,316.24 | March 26, 2026: 38 @ 10.80 |
| April 24, 2026 | issue | SO-260424-602 | EAST | 10 | 10.80 | -108.02 | 345 | 3,726.72 | March 26, 2026: 10 @ 10.80 |
| April 22, 2026 | issue | SO-260422-439 | EAST | 22 | 10.80 | -237.65 | 355 | 3,834.75 | March 26, 2026: 22 @ 10.80 |
| April 14, 2026 | issue | SO-260414-493 | MAIN | 36 | 10.80 | -388.88 | 377 | 4,072.39 | March 26, 2026: 36 @ 10.80 |
| April 10, 2026 | issue | SO-260410-788 | MAIN | 24 | 10.80 | -259.25 | 413 | 4,461.27 | March 26, 2026: 24 @ 10.80 |
| April 9, 2026 | issue | SO-260409-185 | MAIN | 6 | 10.80 | -64.81 | 437 | 4,720.52 | March 26, 2026: 6 @ 10.80 |
| April 5, 2026 | issue | SO-260405-294 | EAST | 12 | 10.80 | -129.63 | 443 | 4,785.33 | March 26, 2026: 12 @ 10.80 |
| March 30, 2026 | issue | SO-260330-363 | MAIN | 95 | 10.80 | -1,025.89 | 455 | 4,914.96 | Dec. 28, 2025: 70 @ 10.80; March 26, 2026: 25 @ 10.80 |
| March 26, 2026 | transfer | TRF | MAIN → EAST | 119 | warehouse transfer, no cost effect | ||||
| March 26, 2026 | receipt | PO-001358 | MAIN | 480 | 10.80 | 5,185.01 | 550 | 5,940.85 | |
| March 20, 2026 | issue | SO-260320-282 | MAIN | 93 | 10.80 | -1,004.19 | 70 | 755.84 | Dec. 28, 2025: 93 @ 10.80 |
| March 11, 2026 | issue | SO-260311-423 | MAIN | 10 | 10.80 | -107.98 | 163 | 1,760.03 | Dec. 28, 2025: 10 @ 10.80 |
| March 2, 2026 | issue | SO-260302-368 | MAIN | 57 | 10.80 | -615.47 | 173 | 1,868.00 | Dec. 28, 2025: 57 @ 10.80 |
| Feb. 28, 2026 | issue | SO-260228-105 | MAIN | 48 | 10.80 | -518.29 | 230 | 2,483.47 | Dec. 28, 2025: 48 @ 10.80 |
| Feb. 27, 2026 | issue | SO-260227-636 | MAIN | 3 | 10.80 | -32.39 | 278 | 3,001.76 | Dec. 28, 2025: 3 @ 10.80 |
| Feb. 24, 2026 | issue | SO-260224-578 | MAIN | 26 | 10.80 | -280.74 | 281 | 3,034.15 | Dec. 28, 2025: 26 @ 10.80 |
| Feb. 16, 2026 | issue | SO-260216-461 | MAIN | 1 | 10.80 | -10.80 | 307 | 3,314.89 | Dec. 28, 2025: 1 @ 10.80 |
| Feb. 13, 2026 | issue | SO-260213-374 | MAIN | 1 | 10.80 | -10.80 | 308 | 3,325.69 | Dec. 28, 2025: 1 @ 10.80 |
| Feb. 11, 2026 | issue | SO-260211-322 | MAIN | 27 | 10.80 | -291.54 | 309 | 3,336.49 | Dec. 28, 2025: 27 @ 10.80 |
| Feb. 8, 2026 | issue | SO-260208-495 | MAIN | 33 | 10.80 | -356.32 | 336 | 3,628.03 | Dec. 28, 2025: 33 @ 10.80 |
| Jan. 30, 2026 | issue | SO-260130-644 | MAIN | 6 | 10.80 | -64.79 | 369 | 3,984.35 | Dec. 28, 2025: 6 @ 10.80 |
| Jan. 27, 2026 | issue | SO-260127-906 | MAIN | 4 | 10.80 | -43.19 | 375 | 4,049.14 | Dec. 28, 2025: 4 @ 10.80 |
| Jan. 24, 2026 | issue | SO-260124-220 | MAIN | 65 | 10.80 | -701.85 | 379 | 4,092.33 | Dec. 28, 2025: 65 @ 10.80 |
| Jan. 14, 2026 | issue | SO-260114-755 | MAIN | 59 | 10.93 | -644.97 | 444 | 4,794.18 | Sept. 22, 2025: 23 @ 11.14; Dec. 28, 2025: 36 @ 10.80 |
| Dec. 31, 2025 | issue | SO-251231-565 | MAIN | 32 | 11.14 | -356.53 | 503 | 5,439.15 | Sept. 22, 2025: 32 @ 11.14 |
| Dec. 29, 2025 | issue | SO-251229-830 | MAIN | 14 | 11.14 | -155.98 | 535 | 5,795.68 | Sept. 22, 2025: 14 @ 11.14 |
| Dec. 28, 2025 | receipt | PO-001098 | MAIN | 480 | 10.80 | 5,182.90 | 549 | 5,951.67 | |
| Dec. 20, 2025 | issue | SO-251220-206 | MAIN | 96 | 11.14 | -1,069.59 | 69 | 768.77 | Sept. 22, 2025: 96 @ 11.14 |
| Dec. 11, 2025 | issue | SO-251211-115 | MAIN | 30 | 11.14 | -334.25 | 165 | 1,838.36 | Sept. 22, 2025: 30 @ 11.14 |
| Nov. 23, 2025 | issue | SO-251123-334 | MAIN | 13 | 11.14 | -144.84 | 195 | 2,172.61 | Sept. 22, 2025: 13 @ 11.14 |
| Nov. 21, 2025 | issue | SO-251121-786 | MAIN | 8 | 11.14 | -89.13 | 208 | 2,317.45 | Sept. 22, 2025: 8 @ 11.14 |
| Nov. 19, 2025 | issue | SO-251119-143 | MAIN | 33 | 11.14 | -367.67 | 216 | 2,406.59 | Sept. 22, 2025: 33 @ 11.14 |
| Nov. 16, 2025 | issue | SO-251116-314 | MAIN | 13 | 11.14 | -144.84 | 249 | 2,774.26 | Sept. 22, 2025: 13 @ 11.14 |