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
| 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 |
| Aug. 22, 2025 | issue | SO-250822-278 | EAST | 6 | 6.09 | -36.57 | 28 | 170.65 | June 11, 2025: 6 @ 6.09 |
| Aug. 22, 2025 | issue | SO-250822-278 | MAIN | 35 | 6.09 | -213.31 | 34 | 207.21 | June 11, 2025: 35 @ 6.09 |
| July 21, 2025 | issue | SO-250721-566 | MAIN | 5 | 6.09 | -30.47 | 69 | 420.52 | June 11, 2025: 5 @ 6.09 |
| July 18, 2025 | issue | SO-250718-973 | MAIN | 7 | 6.09 | -42.66 | 74 | 450.99 | June 11, 2025: 7 @ 6.09 |
| July 15, 2025 | issue | SO-250715-336 | MAIN | 1 | 6.09 | -6.09 | 81 | 493.65 | June 11, 2025: 1 @ 6.09 |
| July 11, 2025 | issue | SO-250711-617 | EAST | 2 | 6.09 | -12.19 | 82 | 499.75 | June 11, 2025: 2 @ 6.09 |
| July 7, 2025 | issue | SO-250707-369 | MAIN | 17 | 6.09 | -103.61 | 84 | 511.94 | June 11, 2025: 17 @ 6.09 |
| June 29, 2025 | return | RMA | MAIN | 5 | 6.09 | 30.47 | 101 | 615.54 | |
| June 28, 2025 | issue | SO-250628-671 | MAIN | 1 | 6.09 | -6.09 | 96 | 585.07 | June 11, 2025: 1 @ 6.09 |
| June 26, 2025 | issue | SO-250626-252 | MAIN | 3 | 6.09 | -18.28 | 97 | 591.17 | June 11, 2025: 3 @ 6.09 |
| June 25, 2025 | issue | SO-250625-806 | EAST | 2 | 6.03 | -12.07 | 100 | 609.45 | March 15, 2025: 1 @ 6.03; April 1, 2025: 1 @ 6.03 |
| June 20, 2025 | issue | SO-250620-637 | MAIN | 10 | 6.03 | -60.34 | 102 | 621.52 | March 15, 2025: 10 @ 6.03 |
| June 12, 2025 | issue | SO-250612-386 | EAST | 2 | 6.03 | -12.07 | 112 | 681.86 | March 15, 2025: 2 @ 6.03 |
| June 11, 2025 | transfer | TRF | MAIN → EAST | 33 | warehouse transfer, no cost effect | ||||
| June 11, 2025 | receipt | PO-000624 | MAIN | 100 | 6.09 | 609.45 | 114 | 693.93 | |
| June 4, 2025 | issue | SO-250604-966 | MAIN | 4 | 6.03 | -24.14 | 14 | 84.48 | March 15, 2025: 4 @ 6.03 |
| June 2, 2025 | issue | SO-250602-859 | MAIN | 3 | 6.03 | -18.10 | 18 | 108.61 | March 15, 2025: 3 @ 6.03 |
| May 28, 2025 | issue | SO-250528-213 | MAIN | 3 | 6.03 | -18.10 | 21 | 126.72 | March 15, 2025: 3 @ 6.03 |
| May 27, 2025 | issue | SO-250527-180 | MAIN | 12 | 6.03 | -72.41 | 24 | 144.82 | March 15, 2025: 12 @ 6.03 |
| May 10, 2025 | issue | SO-250510-876 | MAIN | 3 | 6.03 | -18.10 | 36 | 217.23 | March 15, 2025: 3 @ 6.03 |
| May 8, 2025 | issue | SO-250508-635 | EAST | 4 | 6.03 | -24.14 | 39 | 235.33 | March 15, 2025: 4 @ 6.03 |
| May 4, 2025 | issue | SO-250504-628 | EAST | 8 | 6.03 | -48.27 | 43 | 259.47 | March 15, 2025: 8 @ 6.03 |
| April 21, 2025 | issue | SO-250421-984 | MAIN | 27 | 6.03 | -162.92 | 51 | 307.74 | March 15, 2025: 27 @ 6.03 |
| April 3, 2025 | issue | SO-250403-766 | MAIN | 14 | 6.03 | -84.48 | 78 | 470.66 | March 15, 2025: 14 @ 6.03 |
| April 1, 2025 | return | RMA | MAIN | 1 | 6.03 | 6.03 | 92 | 555.14 | |
| March 28, 2025 | issue | SO-250328-209 | MAIN | 1 | 6.03 | -6.03 | 91 | 549.10 | March 15, 2025: 1 @ 6.03 |
| March 15, 2025 | issue | SO-250315-135 | EAST | 8 | 6.03 | -48.27 | 92 | 555.14 | March 15, 2025: 8 @ 6.03 |
| March 15, 2025 | transfer | TRF | MAIN → EAST | 27 | warehouse transfer, no cost effect | ||||
| March 15, 2025 | receipt | PO-000345 | MAIN | 100 | 6.03 | 603.41 | 100 | 603.41 | |
| March 13, 2025 | issue | SO-250313-566 | MAIN | 10 | 6.04 | -60.38 | 0 | 0.00 | Dec. 23, 2024: 7 @ 6.04; Feb. 27, 2025: 3 @ 6.04 |
| March 10, 2025 | issue | SO-250310-220 | MAIN | 16 | 6.04 | -96.61 | 10 | 60.38 | Dec. 23, 2024: 16 @ 6.04 |
| Feb. 27, 2025 | return | RMA | MAIN | 3 | 6.04 | 18.11 | 26 | 156.99 | |
| Feb. 25, 2025 | issue | SO-250225-653 | MAIN | 2 | 6.04 | -12.08 | 23 | 138.87 | Dec. 23, 2024: 2 @ 6.04 |
| Feb. 23, 2025 | issue | SO-250223-380 | MAIN | 1 | 6.04 | -6.04 | 25 | 150.95 | Dec. 23, 2024: 1 @ 6.04 |
| Feb. 22, 2025 | issue | SO-250222-762 | MAIN | 16 | 6.04 | -96.61 | 26 | 156.99 | Dec. 23, 2024: 16 @ 6.04 |
| Feb. 15, 2025 | issue | SO-250215-458 | MAIN | 6 | 6.04 | -36.23 | 42 | 253.60 | Dec. 23, 2024: 6 @ 6.04 |
| Feb. 5, 2025 | issue | SO-250205-347 | MAIN | 1 | 6.04 | -6.04 | 48 | 289.82 | Dec. 23, 2024: 1 @ 6.04 |
| Feb. 3, 2025 | issue | SO-250203-374 | MAIN | 16 | 6.04 | -96.61 | 49 | 295.86 | Dec. 23, 2024: 16 @ 6.04 |
| Jan. 30, 2025 | issue | SO-250130-141 | MAIN | 3 | 6.04 | -18.11 | 65 | 392.47 | Dec. 23, 2024: 3 @ 6.04 |
| Jan. 14, 2025 | issue | SO-250114-526 | MAIN | 9 | 6.04 | -54.34 | 68 | 410.58 | Dec. 23, 2024: 9 @ 6.04 |
| Jan. 8, 2025 | issue | SO-250108-864 | MAIN | 8 | 6.04 | -48.30 | 77 | 464.93 | Dec. 23, 2024: 8 @ 6.04 |
| Jan. 2, 2025 | issue | SO-250102-178 | MAIN | 11 | 6.04 | -66.42 | 85 | 513.23 | Dec. 23, 2024: 11 @ 6.04 |
| Jan. 1, 2025 | issue | SO-250101-228 | MAIN | 3 | 6.04 | -18.11 | 96 | 579.65 | Dec. 23, 2024: 3 @ 6.04 |
| Dec. 26, 2024 | issue | SO-241226-267 | MAIN | 8 | 6.06 | -48.46 | 99 | 597.76 | Oct. 1, 2024: 7 @ 6.06; Dec. 23, 2024: 1 @ 6.04 |
| Dec. 23, 2024 | receipt | PO-000128 | MAIN | 100 | 6.04 | 603.80 | 107 | 646.23 | |
| Dec. 15, 2024 | issue | SO-241215-274 | MAIN | 15 | 6.06 | -90.92 | 7 | 42.43 | Oct. 1, 2024: 15 @ 6.06 |
| Dec. 1, 2024 | issue | SO-241201-802 | MAIN | 4 | 6.06 | -24.24 | 22 | 133.34 | Oct. 1, 2024: 4 @ 6.06 |
| Nov. 29, 2024 | issue | SO-241129-280 | MAIN | 11 | 6.06 | -66.67 | 26 | 157.59 | Oct. 1, 2024: 11 @ 6.06 |
| Nov. 26, 2024 | issue | SO-241126-333 | MAIN | 23 | 6.06 | -139.40 | 37 | 224.26 | Oct. 1, 2024: 23 @ 6.06 |
| Nov. 23, 2024 | issue | SO-241123-682 | MAIN | 4 | 6.06 | -24.24 | 60 | 363.66 | Oct. 1, 2024: 4 @ 6.06 |
| Nov. 13, 2024 | issue | SO-241113-721 | MAIN | 1 | 6.06 | -6.06 | 64 | 387.90 | Oct. 1, 2024: 1 @ 6.06 |
| Nov. 8, 2024 | issue | SO-241108-744 | MAIN | 1 | 6.06 | -6.06 | 65 | 393.96 | Oct. 1, 2024: 1 @ 6.06 |
| Nov. 3, 2024 | issue | SO-241103-868 | MAIN | 3 | 6.06 | -18.18 | 66 | 400.03 | Oct. 1, 2024: 3 @ 6.06 |
| Oct. 30, 2024 | issue | SO-241030-992 | MAIN | 9 | 6.06 | -54.55 | 69 | 418.21 | Oct. 1, 2024: 9 @ 6.06 |
| Oct. 27, 2024 | issue | SO-241027-794 | MAIN | 22 | 6.06 | -133.34 | 78 | 472.76 | Oct. 1, 2024: 22 @ 6.06 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 100 | 6.06 | 606.10 | 100 | 606.10 | |