Items / SWT-0009
Dimmer Switch Nova SWT-0009 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)239MAIN 167, EAST 72
Value (FIFO)2,101.57avg 8.79
ClassBX / FCV 0.18
Turnover12.1xlast issue 3 days ago
Days of cover57lead 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 | 128.67 / 30.4375 | 4.227 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 22.72 / 5.517 | 4.118 |
| 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 * 4.118^2 + 4.227^2 * 1.5^2) | 20.9 |
| Reorder point | d * LT + safety stock | 4.227 * 7.0 + 20.9 | 50.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 50.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1543/yr, S = 45.00, h = 20%, price = 8.01 | 1440.0 |
| Inventory position | on hand + on order | 239 + 0 | 239 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 8.71 | 282 | 13,931 | yes |
| 720 | 8.36 | 720 | 13,600 | yes |
| 1,440 | 8.01 | 1,440 | 13,566 | yes (chosen if cheapest) |
MOQ 360, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 11, 2026 | 239 / 360 | 8.79 | 2,101.57 |
Movement ledger 121 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-665 | MAIN | 46 | 8.79 | -404.49 | 239 | 2,101.57 | Sept. 11, 2026: 46 @ 8.79 |
| Oct. 8, 2026 | issue | SO-261008-988 | MAIN | 9 | 8.79 | -79.14 | 285 | 2,506.06 | Sept. 11, 2026: 9 @ 8.79 |
| Oct. 7, 2026 | issue | SO-261007-969 | MAIN | 3 | 8.79 | -26.38 | 294 | 2,585.20 | Sept. 11, 2026: 3 @ 8.79 |
| Oct. 3, 2026 | issue | SO-261003-316 | MAIN | 65 | 8.78 | -570.96 | 297 | 2,611.58 | Sept. 9, 2026: 2 @ 8.49; Sept. 11, 2026: 63 @ 8.79 |
| Oct. 2, 2026 | issue | SO-261002-910 | MAIN | 9 | 8.49 | -76.44 | 362 | 3,182.54 | Sept. 9, 2026: 9 @ 8.49 |
| Sept. 22, 2026 | issue | SO-260922-658 | EAST | 10 | 8.48 | -84.81 | 371 | 3,258.98 | July 10, 2026: 2 @ 8.43; Sept. 9, 2026: 8 @ 8.49 |
| Sept. 16, 2026 | issue | SO-260916-208 | MAIN | 20 | 8.47 | -169.37 | 381 | 3,343.78 | July 10, 2026: 12 @ 8.49; July 10, 2026: 8 @ 8.43 |
| Sept. 15, 2026 | issue | SO-260915-766 | MAIN | 20 | 8.49 | -169.86 | 401 | 3,513.15 | July 10, 2026: 20 @ 8.49 |
| Sept. 11, 2026 | transfer | TRF | MAIN → EAST | 82 | warehouse transfer, no cost effect | ||||
| Sept. 11, 2026 | receipt | PO-001789 | MAIN | 360 | 8.79 | 3,165.55 | 421 | 3,683.02 | |
| Sept. 9, 2026 | return | RMA | MAIN | 19 | 8.49 | 161.37 | 61 | 517.46 | |
| Sept. 1, 2026 | issue | SO-260901-438 | MAIN | 106 | 8.49 | -900.27 | 42 | 356.09 | July 10, 2026: 106 @ 8.49 |
| Aug. 28, 2026 | issue | SO-260828-965 | MAIN | 3 | 8.49 | -25.48 | 148 | 1,256.36 | July 10, 2026: 3 @ 8.49 |
| Aug. 22, 2026 | issue | SO-260822-955 | MAIN | 38 | 8.49 | -322.74 | 151 | 1,281.84 | July 10, 2026: 38 @ 8.49 |
| Aug. 21, 2026 | issue | SO-260821-869 | MAIN | 68 | 8.49 | -577.53 | 189 | 1,604.58 | July 10, 2026: 68 @ 8.49 |
| Aug. 18, 2026 | issue | SO-260818-702 | MAIN | 2 | 8.49 | -16.99 | 257 | 2,182.11 | July 10, 2026: 2 @ 8.49 |
| Aug. 3, 2026 | issue | SO-260803-995 | MAIN | 3 | 8.49 | -25.48 | 259 | 2,199.10 | July 10, 2026: 3 @ 8.49 |
| Aug. 1, 2026 | issue | SO-260801-743 | MAIN | 8 | 8.49 | -67.94 | 262 | 2,224.58 | July 10, 2026: 8 @ 8.49 |
| July 29, 2026 | issue | SO-260729-945 | MAIN | 7 | 8.49 | -59.45 | 270 | 2,292.52 | July 10, 2026: 7 @ 8.49 |
| July 29, 2026 | issue | SO-260729-945 | EAST | 29 | 8.49 | -246.30 | 277 | 2,351.97 | July 10, 2026: 29 @ 8.49 |
| July 24, 2026 | issue | SO-260724-324 | EAST | 16 | 8.49 | -135.89 | 306 | 2,598.27 | July 10, 2026: 16 @ 8.49 |
| July 21, 2026 | issue | SO-260721-527 | MAIN | 5 | 8.49 | -42.47 | 322 | 2,734.16 | July 10, 2026: 5 @ 8.49 |
| July 15, 2026 | issue | SO-260715-401 | MAIN | 61 | 8.47 | -516.90 | 327 | 2,776.63 | May 1, 2026: 12 @ 8.43; May 7, 2026: 6 @ 8.42; July 10, 2026: 43 @ 8.49 |
| July 13, 2026 | issue | SO-260713-696 | MAIN | 34 | 8.43 | -286.67 | 388 | 3,293.53 | May 1, 2026: 34 @ 8.43 |
| July 10, 2026 | return | RMA | MAIN | 10 | 8.43 | 84.32 | 422 | 3,580.20 | |
| July 10, 2026 | receipt | PO-001639 | MAIN | 360 | 8.49 | 3,057.52 | 412 | 3,495.88 | |
| July 3, 2026 | issue | SO-260703-881 | MAIN | 31 | 8.43 | -261.38 | 52 | 438.37 | May 1, 2026: 31 @ 8.43 |
| June 30, 2026 | issue | SO-260630-785 | MAIN | 20 | 8.43 | -168.63 | 83 | 699.74 | May 1, 2026: 20 @ 8.43 |
| June 2, 2026 | issue | SO-260602-786 | MAIN | 138 | 8.43 | -1,163.55 | 103 | 868.37 | May 1, 2026: 138 @ 8.43 |
| May 29, 2026 | issue | SO-260529-746 | MAIN | 103 | 8.43 | -868.44 | 241 | 2,031.92 | May 1, 2026: 103 @ 8.43 |
| May 21, 2026 | issue | SO-260521-272 | EAST | 35 | 8.43 | -294.95 | 344 | 2,900.36 | Jan. 12, 2026: 7 @ 8.42; April 21, 2026: 6 @ 8.42; May 1, 2026: 22 @ 8.43 |
| May 7, 2026 | return | RMA | MAIN | 6 | 8.42 | 50.52 | 379 | 3,195.31 | |
| May 1, 2026 | transfer | TRF | MAIN → EAST | 80 | warehouse transfer, no cost effect | ||||
| May 1, 2026 | receipt | PO-001456 | MAIN | 360 | 8.43 | 3,035.34 | 373 | 3,144.79 | |
| April 29, 2026 | issue | SO-260429-687 | MAIN | 8 | 8.42 | -67.36 | 13 | 109.45 | Jan. 12, 2026: 8 @ 8.42 |
| April 27, 2026 | issue | SO-260427-720 | MAIN | 13 | 8.42 | -109.45 | 21 | 176.81 | Jan. 12, 2026: 13 @ 8.42 |
| April 24, 2026 | issue | SO-260424-646 | MAIN | 42 | 8.42 | -353.61 | 34 | 286.26 | Jan. 12, 2026: 42 @ 8.42 |
| April 22, 2026 | issue | SO-260422-123 | MAIN | 25 | 8.42 | -210.48 | 76 | 639.87 | Jan. 12, 2026: 25 @ 8.42 |
| April 21, 2026 | return | RMA | MAIN | 6 | 8.42 | 50.52 | 101 | 850.36 | |
| April 21, 2026 | issue | SO-260421-533 | MAIN | 23 | 8.42 | -193.65 | 95 | 799.84 | Jan. 12, 2026: 23 @ 8.42 |
| April 2, 2026 | issue | SO-260402-113 | MAIN | 12 | 8.42 | -101.03 | 118 | 993.49 | Jan. 12, 2026: 12 @ 8.42 |
| March 16, 2026 | issue | SO-260316-468 | MAIN | 20 | 8.42 | -168.39 | 130 | 1,094.52 | Jan. 12, 2026: 20 @ 8.42 |
| March 1, 2026 | issue | SO-260301-898 | MAIN | 103 | 8.42 | -867.20 | 150 | 1,262.91 | Jan. 12, 2026: 103 @ 8.42 |
| Feb. 18, 2026 | issue | SO-260218-386 | MAIN | 83 | 8.42 | -698.81 | 253 | 2,130.11 | Jan. 12, 2026: 83 @ 8.42 |
| Feb. 11, 2026 | issue | SO-260211-334 | MAIN | 22 | 8.42 | -185.23 | 336 | 2,828.92 | Jan. 12, 2026: 22 @ 8.42 |
| Feb. 10, 2026 | issue | SO-260210-328 | MAIN | 6 | 8.27 | -49.64 | 358 | 3,014.15 | Oct. 17, 2025: 4 @ 8.20; Jan. 12, 2026: 2 @ 8.42 |
| Feb. 1, 2026 | issue | SO-260201-471 | MAIN | 5 | 8.20 | -41.00 | 364 | 3,063.78 | Oct. 17, 2025: 5 @ 8.20 |
| Jan. 29, 2026 | issue | SO-260129-633 | MAIN | 1 | 8.20 | -8.20 | 369 | 3,104.78 | Oct. 17, 2025: 1 @ 8.20 |
| Jan. 28, 2026 | issue | SO-260128-459 | MAIN | 1 | 8.20 | -8.20 | 370 | 3,112.98 | Oct. 17, 2025: 1 @ 8.20 |
| Jan. 22, 2026 | issue | SO-260122-541 | MAIN | 23 | 8.20 | -188.59 | 371 | 3,121.18 | Oct. 17, 2025: 23 @ 8.20 |
| Jan. 12, 2026 | receipt | PO-001139 | MAIN | 360 | 8.42 | 3,030.98 | 394 | 3,309.76 | |
| Jan. 10, 2026 | issue | SO-260110-930 | MAIN | 2 | 8.20 | -16.40 | 34 | 278.78 | Oct. 17, 2025: 2 @ 8.20 |
| Jan. 7, 2026 | issue | SO-260107-268 | MAIN | 13 | 8.20 | -106.59 | 36 | 295.18 | Oct. 17, 2025: 13 @ 8.20 |
| Jan. 6, 2026 | issue | SO-260106-822 | MAIN | 34 | 8.20 | -278.78 | 49 | 401.77 | Oct. 17, 2025: 34 @ 8.20 |
| Jan. 1, 2026 | issue | SO-260101-721 | MAIN | 22 | 8.20 | -180.39 | 83 | 680.55 | Oct. 17, 2025: 22 @ 8.20 |
| Dec. 16, 2025 | issue | SO-251216-804 | MAIN | 57 | 8.20 | -467.37 | 105 | 860.94 | Oct. 17, 2025: 57 @ 8.20 |
| Dec. 9, 2025 | issue | SO-251209-732 | MAIN | 32 | 8.20 | -262.38 | 162 | 1,328.30 | Oct. 17, 2025: 32 @ 8.20 |
| Dec. 9, 2025 | issue | SO-251209-732 | EAST | 52 | 8.20 | -426.37 | 194 | 1,590.68 | Oct. 17, 2025: 52 @ 8.20 |
| Dec. 3, 2025 | issue | SO-251203-950 | MAIN | 15 | 8.20 | -122.99 | 246 | 2,017.05 | Oct. 17, 2025: 15 @ 8.20 |
| Nov. 27, 2025 | issue | SO-251127-699 | MAIN | 3 | 8.20 | -24.60 | 261 | 2,140.04 | Oct. 17, 2025: 3 @ 8.20 |