Items / SWT-0024
Dimmer Switch Flex SWT-0024 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)73MAIN 55, EAST 18
Value (FIFO)468.35avg 6.42
ClassCX / FCV 0.16
Turnover5.3xlast issue 6 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 | 33.25 / 30.4375 | 1.092 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 5.31 / 5.517 | 0.962 |
| 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 * 0.962^2 + 1.092^2 * 1.5^2) | 3.9 |
| Reorder point | d * LT + safety stock | 1.092 * 7.0 + 3.9 | 11.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 11.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 399/yr, S = 45.00, h = 20%, price = 6.38 | 167.7 |
| Inventory position | on hand + on order | 73 + 0 | 73 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 6.38 | 168 | 2,758 | yes (chosen if cheapest) |
MOQ 100, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 14, 2026 | 73 / 100 | 6.42 | 468.35 |
Movement ledger 116 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-483 | MAIN | 17 | 6.42 | -109.07 | 73 | 468.35 | Sept. 14, 2026: 17 @ 6.42 |
| Oct. 8, 2026 | issue | SO-261008-644 | EAST | 10 | 6.42 | -64.16 | 90 | 577.41 | Sept. 14, 2026: 10 @ 6.42 |
| Sept. 14, 2026 | transfer | TRF | MAIN → EAST | 28 | warehouse transfer, no cost effect | ||||
| Sept. 14, 2026 | receipt | PO-001801 | MAIN | 100 | 6.42 | 641.57 | 100 | 641.57 | |
| Sept. 7, 2026 | issue | SO-260907-635 | MAIN | 22 | 6.25 | -137.44 | 0 | 0.00 | June 12, 2026: 12 @ 6.25; July 20, 2026: 10 @ 6.25 |
| Sept. 1, 2026 | issue | SO-260901-850 | MAIN | 11 | 6.25 | -68.72 | 22 | 137.44 | June 12, 2026: 11 @ 6.25 |
| Aug. 24, 2026 | issue | SO-260824-650 | MAIN | 13 | 6.25 | -81.21 | 33 | 206.16 | June 12, 2026: 13 @ 6.25 |
| Aug. 16, 2026 | issue | SO-260816-829 | MAIN | 1 | 6.25 | -6.25 | 46 | 287.37 | June 12, 2026: 1 @ 6.25 |
| Aug. 12, 2026 | issue | SO-260812-544 | MAIN | 4 | 6.25 | -24.99 | 47 | 293.62 | June 12, 2026: 4 @ 6.25 |
| Aug. 10, 2026 | issue | SO-260810-468 | MAIN | 7 | 6.25 | -43.73 | 51 | 318.61 | June 12, 2026: 7 @ 6.25 |
| Aug. 5, 2026 | issue | SO-260805-730 | MAIN | 8 | 6.25 | -49.98 | 58 | 362.34 | June 12, 2026: 8 @ 6.25 |
| July 29, 2026 | issue | SO-260729-733 | MAIN | 4 | 6.25 | -24.99 | 66 | 412.32 | June 12, 2026: 4 @ 6.25 |
| July 24, 2026 | issue | SO-260724-824 | MAIN | 7 | 6.25 | -43.73 | 70 | 437.30 | June 12, 2026: 7 @ 6.25 |
| July 20, 2026 | return | RMA | MAIN | 10 | 6.25 | 62.47 | 77 | 481.03 | |
| July 10, 2026 | issue | SO-260710-590 | MAIN | 21 | 6.25 | -131.19 | 67 | 418.56 | June 12, 2026: 21 @ 6.25 |
| July 8, 2026 | issue | SO-260708-465 | MAIN | 18 | 6.21 | -111.69 | 88 | 549.75 | March 22, 2026: 6 @ 6.12; June 12, 2026: 12 @ 6.25 |
| June 12, 2026 | receipt | PO-001568 | MAIN | 100 | 6.25 | 624.72 | 106 | 661.45 | |
| June 8, 2026 | issue | SO-260608-940 | MAIN | 13 | 6.12 | -79.58 | 6 | 36.73 | March 22, 2026: 13 @ 6.12 |
| June 2, 2026 | issue | SO-260602-662 | MAIN | 2 | 6.12 | -12.24 | 19 | 116.30 | March 22, 2026: 2 @ 6.12 |
| June 1, 2026 | issue | SO-260601-976 | MAIN | 10 | 6.12 | -61.21 | 21 | 128.55 | March 22, 2026: 10 @ 6.12 |
| May 9, 2026 | issue | SO-260509-852 | MAIN | 6 | 6.12 | -36.73 | 31 | 189.76 | March 22, 2026: 6 @ 6.12 |
| May 4, 2026 | issue | SO-260504-969 | MAIN | 18 | 6.12 | -110.18 | 37 | 226.49 | March 22, 2026: 18 @ 6.12 |
| May 2, 2026 | issue | SO-260502-916 | MAIN | 21 | 6.12 | -128.55 | 55 | 336.67 | March 22, 2026: 21 @ 6.12 |
| April 22, 2026 | issue | SO-260422-231 | MAIN | 14 | 6.12 | -85.70 | 76 | 465.22 | March 22, 2026: 14 @ 6.12 |
| April 20, 2026 | issue | SO-260420-963 | MAIN | 11 | 6.13 | -67.42 | 90 | 550.92 | Jan. 9, 2026: 1 @ 6.20; March 22, 2026: 10 @ 6.12 |
| April 8, 2026 | issue | SO-260408-575 | MAIN | 6 | 6.20 | -37.22 | 101 | 618.33 | Jan. 9, 2026: 6 @ 6.20 |
| April 1, 2026 | issue | SO-260401-859 | MAIN | 5 | 6.20 | -31.01 | 107 | 655.55 | Jan. 9, 2026: 5 @ 6.20 |
| March 22, 2026 | receipt | PO-001343 | MAIN | 100 | 6.12 | 612.13 | 112 | 686.56 | |
| March 13, 2026 | issue | SO-260313-159 | MAIN | 18 | 6.20 | -111.65 | 12 | 74.43 | Jan. 9, 2026: 18 @ 6.20 |
| March 8, 2026 | issue | SO-260308-442 | MAIN | 17 | 6.20 | -105.45 | 30 | 186.08 | Jan. 9, 2026: 17 @ 6.20 |
| Feb. 15, 2026 | issue | SO-260215-523 | MAIN | 6 | 6.20 | -37.22 | 47 | 291.53 | Jan. 9, 2026: 6 @ 6.20 |
| Feb. 13, 2026 | issue | SO-260213-158 | MAIN | 21 | 6.20 | -130.26 | 53 | 328.74 | Jan. 9, 2026: 21 @ 6.20 |
| Feb. 12, 2026 | issue | SO-260212-732 | MAIN | 1 | 6.20 | -6.20 | 74 | 459.00 | Jan. 9, 2026: 1 @ 6.20 |
| Feb. 4, 2026 | issue | SO-260204-844 | MAIN | 1 | 6.20 | -6.20 | 75 | 465.20 | Jan. 9, 2026: 1 @ 6.20 |
| Jan. 26, 2026 | issue | SO-260126-368 | MAIN | 18 | 6.20 | -111.65 | 76 | 471.41 | Jan. 9, 2026: 18 @ 6.20 |
| Jan. 23, 2026 | issue | SO-260123-711 | MAIN | 2 | 6.20 | -12.41 | 94 | 583.05 | Jan. 9, 2026: 2 @ 6.20 |
| Jan. 14, 2026 | issue | SO-260114-391 | MAIN | 12 | 6.11 | -73.32 | 96 | 595.46 | Sept. 24, 2025: 8 @ 6.06; Jan. 9, 2026: 4 @ 6.20 |
| Jan. 9, 2026 | receipt | PO-001131 | MAIN | 100 | 6.20 | 620.27 | 108 | 668.78 | |
| Jan. 4, 2026 | issue | SO-260104-282 | MAIN | 2 | 6.06 | -12.13 | 8 | 48.51 | Sept. 24, 2025: 2 @ 6.06 |
| Dec. 31, 2025 | issue | SO-251231-629 | MAIN | 6 | 6.06 | -36.38 | 10 | 60.64 | Sept. 24, 2025: 6 @ 6.06 |
| Dec. 15, 2025 | issue | SO-251215-694 | MAIN | 3 | 6.06 | -18.19 | 16 | 97.02 | Sept. 24, 2025: 3 @ 6.06 |
| Dec. 11, 2025 | issue | SO-251211-255 | MAIN | 2 | 6.06 | -12.13 | 19 | 115.22 | Sept. 24, 2025: 2 @ 6.06 |
| Dec. 10, 2025 | issue | SO-251210-917 | MAIN | 1 | 6.06 | -6.06 | 21 | 127.34 | Sept. 24, 2025: 1 @ 6.06 |
| Dec. 5, 2025 | issue | SO-251205-623 | MAIN | 15 | 6.06 | -90.96 | 22 | 133.41 | Sept. 24, 2025: 15 @ 6.06 |
| Nov. 26, 2025 | issue | SO-251126-277 | MAIN | 14 | 6.06 | -84.90 | 37 | 224.37 | Sept. 24, 2025: 14 @ 6.06 |
| Nov. 20, 2025 | issue | SO-251120-288 | MAIN | 2 | 6.06 | -12.13 | 51 | 309.26 | Sept. 24, 2025: 2 @ 6.06 |
| Nov. 18, 2025 | issue | SO-251118-313 | MAIN | 1 | 6.06 | -6.06 | 53 | 321.39 | Sept. 24, 2025: 1 @ 6.06 |
| Nov. 16, 2025 | issue | SO-251116-666 | MAIN | 7 | 6.06 | -42.45 | 54 | 327.46 | Sept. 24, 2025: 7 @ 6.06 |
| Nov. 8, 2025 | issue | SO-251108-752 | MAIN | 3 | 6.06 | -18.19 | 61 | 369.90 | Sept. 24, 2025: 3 @ 6.06 |
| Nov. 6, 2025 | issue | SO-251106-711 | MAIN | 2 | 6.06 | -12.13 | 64 | 388.10 | Sept. 24, 2025: 2 @ 6.06 |
| Oct. 27, 2025 | issue | SO-251027-794 | MAIN | 2 | 6.06 | -12.13 | 66 | 400.22 | Sept. 24, 2025: 2 @ 6.06 |
| Oct. 23, 2025 | issue | SO-251023-147 | MAIN | 6 | 6.06 | -36.38 | 68 | 412.35 | Sept. 24, 2025: 6 @ 6.06 |
| Oct. 21, 2025 | issue | SO-251021-943 | MAIN | 8 | 6.06 | -48.51 | 74 | 448.74 | Sept. 24, 2025: 8 @ 6.06 |
| Oct. 17, 2025 | issue | SO-251017-341 | MAIN | 3 | 6.06 | -18.19 | 82 | 497.25 | Sept. 24, 2025: 3 @ 6.06 |
| Oct. 8, 2025 | issue | SO-251008-677 | MAIN | 4 | 6.06 | -24.26 | 85 | 515.44 | Sept. 24, 2025: 4 @ 6.06 |
| Oct. 6, 2025 | issue | SO-251006-190 | MAIN | 5 | 6.06 | -30.32 | 89 | 539.70 | Sept. 24, 2025: 5 @ 6.06 |
| Oct. 2, 2025 | issue | SO-251002-587 | MAIN | 5 | 6.06 | -30.32 | 94 | 570.02 | Sept. 24, 2025: 5 @ 6.06 |
| Sept. 29, 2025 | issue | SO-250929-355 | MAIN | 1 | 6.06 | -6.06 | 99 | 600.34 | Sept. 24, 2025: 1 @ 6.06 |
| Sept. 24, 2025 | receipt | PO-000869 | MAIN | 100 | 6.06 | 606.40 | 100 | 606.40 | |
| Sept. 18, 2025 | issue | SO-250918-346 | EAST | 28 | 6.09 | -170.65 | 0 | 0.00 | June 11, 2025: 23 @ 6.09; June 29, 2025: 5 @ 6.09 |