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
| 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 | |
| July 20, 2025 | issue | SO-250720-543 | MAIN | 86 | 7.20 | -618.98 | 36 | 259.11 | April 22, 2025: 86 @ 7.20 |
| July 19, 2025 | issue | SO-250719-652 | MAIN | 8 | 7.20 | -57.58 | 122 | 878.10 | April 22, 2025: 8 @ 7.20 |
| July 18, 2025 | issue | SO-250718-590 | MAIN | 5 | 7.20 | -35.99 | 130 | 935.68 | April 22, 2025: 5 @ 7.20 |
| July 13, 2025 | issue | SO-250713-618 | MAIN | 26 | 7.20 | -187.14 | 135 | 971.66 | April 22, 2025: 26 @ 7.20 |
| July 5, 2025 | issue | SO-250705-430 | MAIN | 32 | 7.20 | -230.32 | 161 | 1,158.80 | April 22, 2025: 32 @ 7.20 |
| June 30, 2025 | issue | SO-250630-663 | MAIN | 81 | 7.20 | -583.00 | 193 | 1,389.12 | April 22, 2025: 81 @ 7.20 |
| June 3, 2025 | issue | SO-250603-610 | MAIN | 59 | 7.20 | -424.65 | 274 | 1,972.12 | April 22, 2025: 59 @ 7.20 |
| May 30, 2025 | issue | SO-250530-593 | MAIN | 1 | 7.20 | -7.20 | 333 | 2,396.77 | April 22, 2025: 1 @ 7.20 |
| May 29, 2025 | issue | SO-250529-196 | MAIN | 7 | 7.20 | -50.38 | 334 | 2,403.96 | April 22, 2025: 7 @ 7.20 |
| May 17, 2025 | issue | SO-250517-276 | MAIN | 107 | 7.20 | -770.13 | 341 | 2,454.35 | April 22, 2025: 107 @ 7.20 |
| May 16, 2025 | issue | SO-250516-362 | MAIN | 19 | 7.20 | -136.75 | 448 | 3,224.48 | April 22, 2025: 19 @ 7.20 |
| May 13, 2025 | issue | SO-250513-909 | MAIN | 51 | 7.20 | -367.07 | 467 | 3,361.23 | April 22, 2025: 51 @ 7.20 |
| April 23, 2025 | issue | SO-250423-923 | MAIN | 2 | 7.20 | -14.40 | 518 | 3,728.30 | April 22, 2025: 2 @ 7.20 |
| April 23, 2025 | issue | SO-250423-923 | EAST | 3 | 6.97 | -20.90 | 520 | 3,742.70 | Jan. 12, 2025: 3 @ 6.97 |
| April 22, 2025 | receipt | PO-000474 | MAIN | 520 | 7.20 | 3,742.70 | 523 | 3,763.60 | |
| April 17, 2025 | issue | SO-250417-597 | EAST | 46 | 6.97 | -320.44 | 3 | 20.90 | Jan. 12, 2025: 46 @ 6.97 |
| April 14, 2025 | issue | SO-250414-103 | EAST | 48 | 6.97 | -334.37 | 49 | 341.34 | Jan. 12, 2025: 48 @ 6.97 |
| April 14, 2025 | issue | SO-250414-103 | MAIN | 77 | 6.97 | -536.39 | 97 | 675.71 | Jan. 12, 2025: 77 @ 6.97 |
| March 30, 2025 | issue | SO-250330-881 | MAIN | 2 | 6.97 | -13.93 | 174 | 1,212.10 | Jan. 12, 2025: 2 @ 6.97 |
| March 28, 2025 | issue | SO-250328-558 | EAST | 2 | 6.97 | -13.93 | 176 | 1,226.03 | Jan. 12, 2025: 2 @ 6.97 |
| March 15, 2025 | issue | SO-250315-560 | MAIN | 22 | 6.97 | -153.25 | 178 | 1,239.97 | Jan. 12, 2025: 22 @ 6.97 |
| March 10, 2025 | issue | SO-250310-863 | EAST | 15 | 6.97 | -104.49 | 200 | 1,393.22 | Jan. 12, 2025: 15 @ 6.97 |
| March 8, 2025 | issue | SO-250308-568 | MAIN | 43 | 6.97 | -299.54 | 215 | 1,497.71 | Jan. 12, 2025: 43 @ 6.97 |
| March 3, 2025 | issue | SO-250303-100 | MAIN | 84 | 6.97 | -585.15 | 258 | 1,797.25 | Jan. 12, 2025: 84 @ 6.97 |
| March 2, 2025 | issue | SO-250302-574 | MAIN | 2 | 6.97 | -13.93 | 342 | 2,382.41 | Jan. 12, 2025: 2 @ 6.97 |
| Feb. 22, 2025 | issue | SO-250222-309 | MAIN | 59 | 6.97 | -411.00 | 344 | 2,396.34 | Jan. 12, 2025: 59 @ 6.97 |
| Feb. 13, 2025 | issue | SO-250213-752 | EAST | 40 | 6.97 | -278.64 | 403 | 2,807.34 | Jan. 12, 2025: 40 @ 6.97 |
| Feb. 6, 2025 | issue | SO-250206-630 | MAIN | 28 | 6.97 | -195.05 | 443 | 3,085.98 | Jan. 12, 2025: 28 @ 6.97 |
| Feb. 4, 2025 | issue | SO-250204-282 | MAIN | 88 | 7.06 | -621.07 | 471 | 3,281.03 | Nov. 15, 2024: 39 @ 7.17; Jan. 12, 2025: 49 @ 6.97 |
| Jan. 20, 2025 | issue | SO-250120-423 | MAIN | 20 | 7.17 | -143.45 | 559 | 3,902.10 | Oct. 1, 2024: 14 @ 7.17; Nov. 15, 2024: 6 @ 7.17 |
| Jan. 14, 2025 | issue | SO-250114-865 | MAIN | 17 | 7.17 | -121.93 | 579 | 4,045.55 | Oct. 1, 2024: 17 @ 7.17 |
| Jan. 12, 2025 | transfer | TRF | MAIN → EAST | 137 | warehouse transfer, no cost effect | ||||
| Jan. 12, 2025 | receipt | PO-000181 | MAIN | 520 | 6.97 | 3,622.37 | 596 | 4,167.48 | |
| Jan. 4, 2025 | issue | SO-250104-212 | MAIN | 57 | 7.17 | -408.83 | 76 | 545.11 | Oct. 1, 2024: 57 @ 7.17 |
| Jan. 1, 2025 | issue | SO-250101-119 | EAST | 23 | 7.17 | -164.97 | 133 | 953.94 | Oct. 1, 2024: 23 @ 7.17 |
| Dec. 29, 2024 | issue | SO-241229-873 | MAIN | 61 | 7.17 | -437.52 | 156 | 1,118.91 | Oct. 1, 2024: 61 @ 7.17 |
| Dec. 18, 2024 | issue | SO-241218-500 | EAST | 5 | 7.17 | -35.86 | 217 | 1,556.43 | Oct. 1, 2024: 5 @ 7.17 |
| Dec. 10, 2024 | issue | SO-241210-310 | EAST | 39 | 7.17 | -279.73 | 222 | 1,592.30 | Oct. 1, 2024: 39 @ 7.17 |
| Dec. 9, 2024 | issue | SO-241209-107 | MAIN | 4 | 7.17 | -28.69 | 261 | 1,872.02 | Oct. 1, 2024: 4 @ 7.17 |
| Dec. 6, 2024 | issue | SO-241206-690 | MAIN | 41 | 7.17 | -294.07 | 265 | 1,900.71 | Oct. 1, 2024: 41 @ 7.17 |
| Nov. 17, 2024 | issue | SO-241117-447 | EAST | 49 | 7.17 | -351.45 | 306 | 2,194.78 | Oct. 1, 2024: 49 @ 7.17 |
| Nov. 16, 2024 | issue | SO-241116-521 | MAIN | 59 | 7.17 | -423.18 | 355 | 2,546.24 | Oct. 1, 2024: 59 @ 7.17 |
| Nov. 15, 2024 | return | RMA | MAIN | 45 | 7.17 | 322.76 | 414 | 2,969.42 | |
| Nov. 9, 2024 | issue | SO-241109-677 | MAIN | 8 | 7.17 | -57.38 | 369 | 2,646.65 | Oct. 1, 2024: 8 @ 7.17 |
| Nov. 7, 2024 | issue | SO-241107-790 | MAIN | 1 | 7.17 | -7.17 | 377 | 2,704.03 | Oct. 1, 2024: 1 @ 7.17 |
| Oct. 30, 2024 | issue | SO-241030-731 | MAIN | 11 | 7.17 | -78.90 | 378 | 2,711.20 | Oct. 1, 2024: 11 @ 7.17 |
| Oct. 29, 2024 | issue | SO-241029-942 | MAIN | 13 | 7.17 | -93.24 | 389 | 2,790.10 | Oct. 1, 2024: 13 @ 7.17 |
| Oct. 28, 2024 | issue | SO-241028-616 | MAIN | 91 | 7.17 | -652.70 | 402 | 2,883.34 | Oct. 1, 2024: 91 @ 7.17 |
| Oct. 21, 2024 | issue | SO-241021-904 | EAST | 26 | 7.17 | -186.48 | 493 | 3,536.04 | Oct. 1, 2024: 26 @ 7.17 |
| Oct. 2, 2024 | issue | SO-241002-280 | MAIN | 1 | 7.17 | -7.17 | 519 | 3,722.53 | Oct. 1, 2024: 1 @ 7.17 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 159 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 520 | 7.17 | 3,729.70 | 520 | 3,729.70 | |