Items / SWT-0028
Switch Plate 4M Nova SWT-0028 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)158MAIN 158
Value (FIFO)1,173.23avg 7.43
ClassBX / FCV 0.22
Turnover16.4xlast issue 6 days ago
Days of cover29lead 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 | 164.50 / 30.4375 | 5.405 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 36.49 / 5.517 | 6.614 |
| 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.614^2 + 5.405^2 * 1.5^2) | 31.8 |
| Reorder point | d * LT + safety stock | 5.405 * 7.0 + 31.8 | 69.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 69.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1973/yr, S = 45.00, h = 20%, price = 7.55 | 342.9 |
| Inventory position | on hand + on order | 158 + 0 | 158 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 7.55 | 343 | 15,411 | yes (chosen if cheapest) |
MOQ 520, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 1, 2026 | 158 / 520 | 7.43 | 1,173.23 |
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. 10, 2026 | issue | SO-261010-612 | MAIN | 177 | 7.43 | -1,314.31 | 158 | 1,173.23 | Sept. 1, 2026: 177 @ 7.43 |
| Oct. 8, 2026 | issue | SO-261008-759 | MAIN | 2 | 7.43 | -14.85 | 335 | 2,487.54 | Sept. 1, 2026: 2 @ 7.43 |
| Sept. 13, 2026 | issue | SO-260913-652 | MAIN | 12 | 7.43 | -89.11 | 337 | 2,502.39 | Sept. 1, 2026: 12 @ 7.43 |
| Sept. 7, 2026 | issue | SO-260907-852 | MAIN | 23 | 7.43 | -170.79 | 349 | 2,591.50 | Sept. 1, 2026: 23 @ 7.43 |
| Sept. 3, 2026 | issue | SO-260903-649 | MAIN | 41 | 7.43 | -304.45 | 372 | 2,762.29 | Sept. 1, 2026: 41 @ 7.43 |
| Sept. 2, 2026 | issue | SO-260902-999 | MAIN | 181 | 7.48 | -1,353.15 | 413 | 3,066.73 | June 4, 2026: 74 @ 7.55; Sept. 1, 2026: 107 @ 7.43 |
| Sept. 1, 2026 | issue | SO-260901-653 | MAIN | 2 | 7.55 | -15.10 | 594 | 4,419.89 | June 4, 2026: 2 @ 7.55 |
| Sept. 1, 2026 | receipt | PO-001766 | MAIN | 520 | 7.43 | 3,861.26 | 596 | 4,434.98 | |
| Aug. 23, 2026 | issue | SO-260823-898 | MAIN | 30 | 7.55 | -226.47 | 76 | 573.72 | June 4, 2026: 30 @ 7.55 |
| Aug. 21, 2026 | issue | SO-260821-722 | MAIN | 178 | 7.55 | -1,343.72 | 106 | 800.19 | June 4, 2026: 178 @ 7.55 |
| July 31, 2026 | issue | SO-260731-897 | MAIN | 24 | 7.55 | -181.18 | 284 | 2,143.92 | June 4, 2026: 24 @ 7.55 |
| July 30, 2026 | issue | SO-260730-275 | MAIN | 10 | 7.55 | -75.49 | 308 | 2,325.09 | June 4, 2026: 10 @ 7.55 |
| July 29, 2026 | issue | SO-260729-974 | MAIN | 24 | 7.55 | -181.18 | 318 | 2,400.58 | June 4, 2026: 24 @ 7.55 |
| July 27, 2026 | issue | SO-260727-997 | MAIN | 33 | 7.55 | -249.12 | 342 | 2,581.76 | June 4, 2026: 33 @ 7.55 |
| July 19, 2026 | issue | SO-260719-805 | MAIN | 17 | 7.55 | -128.33 | 375 | 2,830.88 | June 4, 2026: 17 @ 7.55 |
| July 18, 2026 | issue | SO-260718-871 | MAIN | 32 | 7.55 | -241.57 | 392 | 2,959.21 | June 4, 2026: 32 @ 7.55 |
| July 9, 2026 | issue | SO-260709-388 | MAIN | 15 | 7.55 | -113.24 | 424 | 3,200.78 | June 4, 2026: 15 @ 7.55 |
| June 17, 2026 | issue | SO-260617-147 | MAIN | 62 | 7.55 | -468.04 | 439 | 3,314.01 | June 4, 2026: 62 @ 7.55 |
| June 6, 2026 | issue | SO-260606-988 | MAIN | 99 | 7.25 | -717.61 | 501 | 3,782.05 | Feb. 9, 2026: 43 @ 7.18; May 15, 2026: 37 @ 7.18; June 4, 2026: 19 @ 7.55 |
| June 4, 2026 | receipt | PO-001548 | MAIN | 520 | 7.55 | 3,925.48 | 600 | 4,499.66 | |
| May 30, 2026 | issue | SO-260530-832 | MAIN | 51 | 7.18 | -366.04 | 80 | 574.18 | Feb. 9, 2026: 51 @ 7.18 |
| May 22, 2026 | issue | SO-260522-765 | MAIN | 5 | 7.18 | -35.89 | 131 | 940.21 | Feb. 9, 2026: 5 @ 7.18 |
| May 15, 2026 | return | RMA | MAIN | 37 | 7.18 | 265.56 | 136 | 976.10 | |
| May 14, 2026 | issue | SO-260514-323 | MAIN | 5 | 7.18 | -35.89 | 99 | 710.54 | Feb. 9, 2026: 5 @ 7.18 |
| May 9, 2026 | issue | SO-260509-123 | MAIN | 75 | 7.18 | -538.29 | 104 | 746.43 | Feb. 9, 2026: 75 @ 7.18 |
| May 9, 2026 | issue | SO-260509-123 | EAST | 5 | 7.18 | -35.89 | 179 | 1,284.72 | Feb. 9, 2026: 5 @ 7.18 |
| May 3, 2026 | issue | SO-260503-137 | MAIN | 3 | 7.18 | -21.53 | 184 | 1,320.60 | Feb. 9, 2026: 3 @ 7.18 |
| April 21, 2026 | issue | SO-260421-258 | MAIN | 131 | 7.18 | -940.21 | 187 | 1,342.14 | Feb. 9, 2026: 131 @ 7.18 |
| April 13, 2026 | issue | SO-260413-241 | MAIN | 9 | 7.18 | -64.59 | 318 | 2,282.35 | Feb. 9, 2026: 9 @ 7.18 |
| April 8, 2026 | issue | SO-260408-576 | MAIN | 11 | 7.18 | -78.95 | 327 | 2,346.94 | Feb. 9, 2026: 11 @ 7.18 |
| March 25, 2026 | issue | SO-260325-702 | MAIN | 1 | 7.18 | -7.18 | 338 | 2,425.89 | Feb. 9, 2026: 1 @ 7.18 |
| March 21, 2026 | issue | SO-260321-899 | EAST | 50 | 7.18 | -358.86 | 339 | 2,433.07 | Feb. 9, 2026: 50 @ 7.18 |
| March 11, 2026 | issue | SO-260311-696 | MAIN | 23 | 7.18 | -165.08 | 389 | 2,791.93 | Feb. 9, 2026: 23 @ 7.18 |
| March 10, 2026 | issue | SO-260310-266 | EAST | 25 | 7.18 | -179.43 | 412 | 2,957.01 | Feb. 9, 2026: 25 @ 7.18 |
| March 7, 2026 | issue | SO-260307-484 | EAST | 39 | 7.18 | -279.91 | 437 | 3,136.44 | Feb. 9, 2026: 39 @ 7.18 |
| Feb. 28, 2026 | issue | SO-260228-222 | MAIN | 41 | 7.18 | -294.27 | 476 | 3,416.35 | Feb. 9, 2026: 41 @ 7.18 |
| Feb. 12, 2026 | issue | SO-260212-611 | EAST | 3 | 7.18 | -21.53 | 517 | 3,710.61 | Feb. 9, 2026: 3 @ 7.18 |
| Feb. 9, 2026 | transfer | TRF | MAIN → EAST | 122 | warehouse transfer, no cost effect | ||||
| Feb. 9, 2026 | receipt | PO-001210 | MAIN | 520 | 7.18 | 3,732.14 | 520 | 3,732.14 | |
| Feb. 4, 2026 | issue | SO-260204-887 | MAIN | 95 | 7.04 | -668.44 | 0 | 0.00 | Oct. 27, 2025: 95 @ 7.04 |
| Jan. 29, 2026 | issue | SO-260129-626 | MAIN | 25 | 7.04 | -175.90 | 95 | 668.44 | Oct. 27, 2025: 25 @ 7.04 |
| Jan. 23, 2026 | issue | SO-260123-284 | MAIN | 29 | 7.04 | -204.05 | 120 | 844.34 | Oct. 27, 2025: 29 @ 7.04 |
| Jan. 4, 2026 | issue | SO-260104-125 | MAIN | 98 | 7.04 | -689.55 | 149 | 1,048.39 | Oct. 27, 2025: 98 @ 7.04 |
| Dec. 26, 2025 | issue | SO-251226-324 | MAIN | 91 | 7.04 | -640.29 | 247 | 1,737.94 | Oct. 27, 2025: 91 @ 7.04 |
| Dec. 22, 2025 | issue | SO-251222-421 | MAIN | 41 | 7.04 | -288.48 | 338 | 2,378.24 | Oct. 27, 2025: 41 @ 7.04 |
| Dec. 11, 2025 | issue | SO-251211-640 | MAIN | 33 | 7.04 | -232.19 | 379 | 2,666.72 | Oct. 27, 2025: 33 @ 7.04 |
| Nov. 29, 2025 | issue | SO-251129-147 | MAIN | 146 | 7.02 | -1,024.94 | 412 | 2,898.91 | July 25, 2025: 38 @ 6.97; Oct. 27, 2025: 108 @ 7.04 |
| Nov. 2, 2025 | issue | SO-251102-361 | MAIN | 25 | 6.97 | -174.36 | 558 | 3,923.86 | July 25, 2025: 25 @ 6.97 |
| Oct. 27, 2025 | issue | SO-251027-293 | MAIN | 14 | 6.97 | -97.64 | 583 | 4,098.22 | July 25, 2025: 14 @ 6.97 |
| Oct. 27, 2025 | receipt | PO-000956 | MAIN | 520 | 7.04 | 3,658.82 | 597 | 4,195.86 | |
| Oct. 19, 2025 | issue | SO-251019-517 | MAIN | 15 | 6.97 | -104.62 | 77 | 537.04 | July 25, 2025: 15 @ 6.97 |
| Oct. 11, 2025 | issue | SO-251011-439 | MAIN | 139 | 6.97 | -969.46 | 92 | 641.65 | July 25, 2025: 139 @ 6.97 |
| Sept. 27, 2025 | issue | SO-250927-259 | MAIN | 4 | 6.97 | -27.90 | 231 | 1,611.11 | July 25, 2025: 4 @ 6.97 |
| Sept. 14, 2025 | issue | SO-250914-698 | MAIN | 31 | 6.97 | -216.21 | 235 | 1,639.01 | July 25, 2025: 31 @ 6.97 |
| Sept. 9, 2025 | issue | SO-250909-158 | MAIN | 119 | 6.97 | -829.97 | 266 | 1,855.22 | July 25, 2025: 119 @ 6.97 |
| Sept. 4, 2025 | issue | SO-250904-519 | MAIN | 22 | 6.97 | -153.44 | 385 | 2,685.18 | July 25, 2025: 22 @ 6.97 |
| Aug. 15, 2025 | issue | SO-250815-733 | MAIN | 31 | 6.97 | -216.21 | 407 | 2,838.62 | July 25, 2025: 31 @ 6.97 |
| Aug. 6, 2025 | issue | SO-250806-602 | MAIN | 99 | 7.01 | -694.27 | 438 | 3,054.83 | April 22, 2025: 17 @ 7.20; July 25, 2025: 82 @ 6.97 |
| July 29, 2025 | issue | SO-250729-763 | MAIN | 19 | 7.20 | -136.75 | 537 | 3,749.10 | April 22, 2025: 19 @ 7.20 |
| July 25, 2025 | receipt | PO-000732 | MAIN | 520 | 6.97 | 3,626.74 | 556 | 3,885.85 | |