Items / SWT-0019
Modular Switch 6A Elite SWT-0019 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)167MAIN 167
Value (FIFO)1,488.27avg 8.91
ClassCX / FCV 0.16
Turnover6.7xlast issue 0 days ago
Days of cover51lead 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 | 99.00 / 30.4375 | 3.253 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 15.44 / 5.517 | 2.799 |
| 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 * 2.799^2 + 3.253^2 * 1.5^2) | 11.5 |
| Reorder point | d * LT + safety stock | 3.253 * 7.0 + 11.5 | 34.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 34.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1187/yr, S = 45.00, h = 20%, price = 8.80 | 600.0 |
| Inventory position | on hand + on order | 167 + 0 | 167 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 9.17 | 241 | 11,329 | yes |
| 600 | 8.80 | 600 | 11,068 | yes (chosen if cheapest) |
| 1,200 | 8.44 | 1,200 | 11,072 | yes |
MOQ 300, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 12, 2026 | 126 / 300 | 8.91 | 1,122.89 | |
| Oct. 14, 2026 | 41 / 41 | 8.91 | 365.38 |
Movement ledger 108 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-441 | MAIN | 93 | 8.91 | -828.80 | 167 | 1,488.27 | Sept. 12, 2026: 93 @ 8.91 |
| Oct. 14, 2026 | return | RMA | MAIN | 41 | 8.91 | 365.38 | 260 | 2,317.07 | |
| Oct. 7, 2026 | issue | SO-261007-346 | MAIN | 12 | 8.91 | -106.94 | 219 | 1,951.68 | Sept. 12, 2026: 12 @ 8.91 |
| Sept. 30, 2026 | issue | SO-260930-428 | MAIN | 83 | 8.89 | -737.91 | 231 | 2,058.63 | May 28, 2026: 14 @ 8.79; Sept. 12, 2026: 69 @ 8.91 |
| Sept. 12, 2026 | receipt | PO-001794 | MAIN | 300 | 8.91 | 2,673.54 | 314 | 2,796.53 | |
| Sept. 3, 2026 | issue | SO-260903-189 | MAIN | 29 | 8.79 | -254.77 | 14 | 122.99 | May 28, 2026: 29 @ 8.79 |
| Sept. 2, 2026 | issue | SO-260902-723 | MAIN | 5 | 8.79 | -43.93 | 43 | 377.76 | May 28, 2026: 5 @ 8.79 |
| Aug. 30, 2026 | adjustment | Cycle count | MAIN | -2 | 8.79 | -17.57 | 48 | 421.69 | May 28, 2026: 2 @ 8.79 |
| Aug. 22, 2026 | issue | SO-260822-228 | MAIN | 68 | 8.79 | -597.39 | 50 | 439.26 | May 28, 2026: 68 @ 8.79 |
| Aug. 14, 2026 | issue | SO-260814-602 | MAIN | 9 | 8.79 | -79.07 | 118 | 1,036.65 | May 28, 2026: 9 @ 8.79 |
| Aug. 11, 2026 | issue | SO-260811-969 | MAIN | 42 | 8.79 | -368.98 | 127 | 1,115.72 | May 28, 2026: 42 @ 8.79 |
| July 13, 2026 | issue | SO-260713-671 | MAIN | 51 | 8.79 | -448.05 | 169 | 1,484.70 | May 28, 2026: 51 @ 8.79 |
| July 9, 2026 | issue | SO-260709-920 | MAIN | 25 | 8.79 | -219.63 | 220 | 1,932.74 | May 28, 2026: 25 @ 8.79 |
| June 26, 2026 | issue | SO-260626-446 | MAIN | 4 | 8.79 | -35.14 | 245 | 2,152.37 | May 28, 2026: 4 @ 8.79 |
| June 18, 2026 | issue | SO-260618-446 | MAIN | 70 | 8.82 | -617.09 | 249 | 2,187.51 | March 14, 2026: 19 @ 8.90; May 28, 2026: 51 @ 8.79 |
| June 5, 2026 | issue | SO-260605-518 | MAIN | 14 | 8.90 | -124.56 | 319 | 2,804.60 | March 14, 2026: 14 @ 8.90 |
| June 4, 2026 | issue | SO-260604-536 | MAIN | 5 | 8.90 | -44.48 | 333 | 2,929.16 | March 14, 2026: 5 @ 8.90 |
| May 28, 2026 | receipt | PO-001528 | MAIN | 300 | 8.79 | 2,635.56 | 338 | 2,973.64 | |
| May 26, 2026 | issue | SO-260526-752 | MAIN | 4 | 8.90 | -35.59 | 38 | 338.08 | March 14, 2026: 4 @ 8.90 |
| May 20, 2026 | issue | SO-260520-433 | MAIN | 81 | 8.90 | -720.65 | 42 | 373.67 | March 14, 2026: 81 @ 8.90 |
| April 28, 2026 | issue | SO-260428-102 | MAIN | 31 | 8.90 | -275.80 | 123 | 1,094.32 | March 14, 2026: 31 @ 8.90 |
| April 23, 2026 | issue | SO-260423-978 | MAIN | 50 | 8.90 | -444.84 | 154 | 1,370.12 | March 14, 2026: 50 @ 8.90 |
| April 18, 2026 | issue | SO-260418-525 | MAIN | 1 | 8.90 | -8.90 | 204 | 1,814.97 | March 14, 2026: 1 @ 8.90 |
| April 15, 2026 | issue | SO-260415-776 | MAIN | 13 | 8.90 | -115.66 | 205 | 1,823.86 | March 14, 2026: 13 @ 8.90 |
| April 11, 2026 | issue | SO-260411-457 | MAIN | 17 | 8.90 | -151.25 | 218 | 1,939.52 | March 14, 2026: 17 @ 8.90 |
| April 5, 2026 | issue | SO-260405-725 | MAIN | 12 | 8.90 | -106.76 | 235 | 2,090.77 | March 14, 2026: 12 @ 8.90 |
| March 31, 2026 | issue | SO-260331-794 | MAIN | 3 | 8.90 | -26.69 | 247 | 2,197.53 | March 14, 2026: 3 @ 8.90 |
| March 26, 2026 | issue | SO-260326-668 | MAIN | 27 | 8.90 | -240.22 | 250 | 2,224.22 | March 14, 2026: 27 @ 8.90 |
| March 20, 2026 | issue | SO-260320-305 | MAIN | 10 | 8.90 | -88.97 | 277 | 2,464.44 | March 14, 2026: 10 @ 8.90 |
| March 16, 2026 | issue | SO-260316-795 | MAIN | 13 | 8.90 | -115.66 | 287 | 2,553.41 | March 14, 2026: 13 @ 8.90 |
| March 14, 2026 | receipt | PO-001318 | MAIN | 300 | 8.90 | 2,669.07 | 300 | 2,669.07 | |
| March 6, 2026 | issue | SO-260306-154 | MAIN | 57 | 8.89 | -506.49 | 0 | 0.00 | Dec. 5, 2025: 57 @ 8.89 |
| Feb. 25, 2026 | issue | SO-260225-211 | MAIN | 11 | 8.89 | -97.74 | 57 | 506.49 | Dec. 5, 2025: 11 @ 8.89 |
| Feb. 22, 2026 | issue | SO-260222-988 | MAIN | 46 | 8.89 | -408.75 | 68 | 604.23 | Dec. 5, 2025: 46 @ 8.89 |
| Feb. 17, 2026 | issue | SO-260217-184 | MAIN | 17 | 8.89 | -151.06 | 114 | 1,012.98 | Dec. 5, 2025: 17 @ 8.89 |
| Feb. 2, 2026 | issue | SO-260202-358 | MAIN | 8 | 8.89 | -71.09 | 131 | 1,164.04 | Dec. 5, 2025: 8 @ 8.89 |
| Jan. 23, 2026 | issue | SO-260123-420 | MAIN | 10 | 8.89 | -88.86 | 139 | 1,235.13 | Dec. 5, 2025: 10 @ 8.89 |
| Jan. 22, 2026 | issue | SO-260122-354 | MAIN | 31 | 8.89 | -275.46 | 149 | 1,323.98 | Dec. 5, 2025: 31 @ 8.89 |
| Jan. 13, 2026 | issue | SO-260113-451 | MAIN | 14 | 8.89 | -124.40 | 180 | 1,599.44 | Dec. 5, 2025: 14 @ 8.89 |
| Jan. 8, 2026 | issue | SO-260108-450 | MAIN | 21 | 8.89 | -186.60 | 194 | 1,723.85 | Dec. 5, 2025: 21 @ 8.89 |
| Jan. 7, 2026 | issue | SO-260107-851 | MAIN | 10 | 8.89 | -88.86 | 215 | 1,910.45 | Dec. 5, 2025: 10 @ 8.89 |
| Dec. 22, 2025 | issue | SO-251222-513 | MAIN | 54 | 8.89 | -479.83 | 225 | 1,999.30 | Dec. 5, 2025: 54 @ 8.89 |
| Dec. 20, 2025 | issue | SO-251220-333 | MAIN | 4 | 8.89 | -35.54 | 279 | 2,479.14 | Dec. 5, 2025: 4 @ 8.89 |
| Dec. 17, 2025 | issue | SO-251217-125 | MAIN | 24 | 8.79 | -211.01 | 283 | 2,514.68 | Aug. 17, 2025: 7 @ 8.57; Dec. 5, 2025: 17 @ 8.89 |
| Dec. 15, 2025 | issue | SO-251215-621 | MAIN | 14 | 8.57 | -119.91 | 307 | 2,725.70 | Aug. 17, 2025: 14 @ 8.57 |
| Dec. 5, 2025 | receipt | PO-001036 | MAIN | 300 | 8.89 | 2,665.74 | 321 | 2,845.61 | |
| Nov. 27, 2025 | issue | SO-251127-444 | MAIN | 78 | 8.57 | -668.08 | 21 | 179.87 | Aug. 17, 2025: 78 @ 8.57 |
| Nov. 7, 2025 | issue | SO-251107-942 | MAIN | 31 | 8.57 | -265.52 | 99 | 847.94 | Aug. 17, 2025: 31 @ 8.57 |
| Oct. 20, 2025 | issue | SO-251020-646 | MAIN | 37 | 8.57 | -316.91 | 130 | 1,113.46 | Aug. 17, 2025: 37 @ 8.57 |
| Oct. 19, 2025 | issue | SO-251019-781 | MAIN | 22 | 8.57 | -188.43 | 167 | 1,430.37 | Aug. 17, 2025: 22 @ 8.57 |
| Oct. 17, 2025 | issue | SO-251017-682 | MAIN | 32 | 8.57 | -274.08 | 189 | 1,618.80 | Aug. 17, 2025: 32 @ 8.57 |
| Sept. 15, 2025 | issue | SO-250915-276 | MAIN | 2 | 8.57 | -17.13 | 221 | 1,892.89 | Aug. 17, 2025: 2 @ 8.57 |
| Sept. 14, 2025 | issue | SO-250914-770 | MAIN | 16 | 8.57 | -137.04 | 223 | 1,910.02 | Aug. 17, 2025: 16 @ 8.57 |
| Sept. 9, 2025 | issue | SO-250909-554 | MAIN | 53 | 8.57 | -453.95 | 239 | 2,047.06 | Aug. 17, 2025: 53 @ 8.57 |
| Sept. 6, 2025 | issue | SO-250906-603 | MAIN | 6 | 8.57 | -51.39 | 292 | 2,501.01 | Aug. 17, 2025: 6 @ 8.57 |
| Aug. 27, 2025 | issue | SO-250827-306 | MAIN | 5 | 8.60 | -42.98 | 298 | 2,552.40 | May 18, 2025: 3 @ 8.62; Aug. 17, 2025: 2 @ 8.57 |
| Aug. 18, 2025 | issue | SO-250818-984 | MAIN | 7 | 8.62 | -60.32 | 303 | 2,595.38 | May 18, 2025: 7 @ 8.62 |
| Aug. 17, 2025 | receipt | PO-000782 | MAIN | 300 | 8.57 | 2,569.53 | 310 | 2,655.70 | |
| Aug. 16, 2025 | issue | SO-250816-855 | MAIN | 9 | 8.62 | -77.55 | 10 | 86.17 | May 18, 2025: 9 @ 8.62 |
| Aug. 14, 2025 | issue | SO-250814-955 | MAIN | 2 | 8.62 | -17.23 | 19 | 163.73 | May 18, 2025: 2 @ 8.62 |