Items / SWT-0033
Socket 5-pin Nova SWT-0033 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)330MAIN 330
Value (FIFO)8,750.28avg 26.52
ClassAX / FCV 0.21
Turnover5.5xlast issue 5 days ago
Days of cover52lead 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 | 192.50 / 30.4375 | 6.324 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 40.67 / 5.517 | 7.372 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(7.0 * 7.372^2 + 6.324^2 * 1.5^2) | 44.7 |
| Reorder point | d * LT + safety stock | 6.324 * 7.0 + 44.7 | 88.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 88.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2308/yr, S = 45.00, h = 20%, price = 26.67 | 197.4 |
| Inventory position | on hand + on order | 330 + 0 | 330 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 26.67 | 197 | 62,618 | yes (chosen if cheapest) |
MOQ 560, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 28, 2026 | 330 / 560 | 26.52 | 8,750.28 |
Movement ledger 120 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 11, 2026 | issue | SO-261011-441 | MAIN | 152 | 26.52 | -4,030.43 | 330 | 8,750.28 | Sept. 28, 2026: 152 @ 26.52 |
| Oct. 9, 2026 | issue | SO-261009-566 | MAIN | 73 | 26.52 | -1,935.67 | 482 | 12,780.71 | Sept. 28, 2026: 73 @ 26.52 |
| Oct. 7, 2026 | issue | SO-261007-257 | MAIN | 5 | 26.52 | -132.58 | 555 | 14,716.38 | Sept. 28, 2026: 5 @ 26.52 |
| Sept. 28, 2026 | receipt | PO-001838 | MAIN | 560 | 26.52 | 14,848.96 | 560 | 14,848.96 | |
| Sept. 23, 2026 | issue | SO-260923-184 | MAIN | 45 | 25.59 | -1,151.41 | 0 | 0.00 | June 19, 2026: 45 @ 25.59 |
| Sept. 22, 2026 | issue | SO-260922-874 | MAIN | 27 | 25.59 | -690.84 | 45 | 1,151.41 | June 19, 2026: 27 @ 25.59 |
| Sept. 19, 2026 | issue | SO-260919-433 | MAIN | 25 | 25.59 | -639.67 | 72 | 1,842.25 | June 19, 2026: 25 @ 25.59 |
| Sept. 10, 2026 | issue | SO-260910-285 | MAIN | 46 | 25.59 | -1,176.99 | 97 | 2,481.92 | June 19, 2026: 46 @ 25.59 |
| Aug. 30, 2026 | issue | SO-260830-542 | MAIN | 10 | 25.59 | -255.87 | 143 | 3,658.91 | June 19, 2026: 10 @ 25.59 |
| Aug. 21, 2026 | issue | SO-260821-905 | MAIN | 65 | 25.59 | -1,663.14 | 153 | 3,914.78 | June 19, 2026: 65 @ 25.59 |
| Aug. 12, 2026 | issue | SO-260812-748 | MAIN | 107 | 25.59 | -2,737.79 | 218 | 5,577.92 | June 19, 2026: 107 @ 25.59 |
| Aug. 10, 2026 | issue | SO-260810-760 | MAIN | 3 | 25.59 | -76.76 | 325 | 8,315.71 | June 19, 2026: 3 @ 25.59 |
| Aug. 4, 2026 | issue | SO-260804-260 | MAIN | 11 | 25.59 | -281.45 | 328 | 8,392.47 | June 19, 2026: 11 @ 25.59 |
| July 24, 2026 | issue | SO-260724-936 | MAIN | 43 | 25.59 | -1,100.23 | 339 | 8,673.93 | June 19, 2026: 43 @ 25.59 |
| July 15, 2026 | issue | SO-260715-501 | MAIN | 86 | 25.59 | -2,200.46 | 382 | 9,774.16 | June 19, 2026: 86 @ 25.59 |
| July 8, 2026 | issue | SO-260708-993 | MAIN | 51 | 25.59 | -1,304.93 | 468 | 11,974.62 | June 19, 2026: 51 @ 25.59 |
| July 7, 2026 | issue | SO-260707-268 | MAIN | 16 | 25.59 | -409.39 | 519 | 13,279.55 | June 19, 2026: 16 @ 25.59 |
| July 4, 2026 | issue | SO-260704-698 | MAIN | 32 | 25.63 | -820.24 | 535 | 13,688.94 | June 13, 2026: 7 @ 25.80; June 19, 2026: 25 @ 25.59 |
| June 23, 2026 | issue | SO-260623-686 | MAIN | 99 | 25.80 | -2,553.72 | 567 | 14,509.17 | March 8, 2026: 77 @ 25.80; June 13, 2026: 22 @ 25.80 |
| June 19, 2026 | receipt | PO-001587 | MAIN | 560 | 25.59 | 14,328.61 | 666 | 17,062.90 | |
| June 13, 2026 | return | RMA | MAIN | 29 | 25.80 | 748.06 | 106 | 2,734.29 | |
| June 12, 2026 | issue | SO-260612-519 | MAIN | 74 | 25.80 | -1,908.84 | 77 | 1,986.23 | March 8, 2026: 74 @ 25.80 |
| June 3, 2026 | issue | SO-260603-708 | MAIN | 20 | 25.80 | -515.90 | 151 | 3,895.08 | March 8, 2026: 20 @ 25.80 |
| May 28, 2026 | issue | SO-260528-716 | MAIN | 58 | 25.80 | -1,496.12 | 171 | 4,410.98 | March 8, 2026: 58 @ 25.80 |
| May 24, 2026 | issue | SO-260524-147 | MAIN | 60 | 25.80 | -1,547.71 | 229 | 5,907.10 | March 8, 2026: 60 @ 25.80 |
| May 21, 2026 | issue | SO-260521-444 | MAIN | 39 | 25.80 | -1,006.01 | 289 | 7,454.81 | March 8, 2026: 39 @ 25.80 |
| May 16, 2026 | issue | SO-260516-512 | MAIN | 75 | 25.80 | -1,934.64 | 328 | 8,460.83 | March 8, 2026: 75 @ 25.80 |
| May 10, 2026 | issue | SO-260510-841 | MAIN | 9 | 25.80 | -232.16 | 403 | 10,395.47 | March 8, 2026: 9 @ 25.80 |
| April 22, 2026 | issue | SO-260422-171 | MAIN | 34 | 25.80 | -877.04 | 412 | 10,627.62 | March 8, 2026: 34 @ 25.80 |
| April 12, 2026 | issue | SO-260412-936 | MAIN | 45 | 25.80 | -1,160.78 | 446 | 11,504.66 | March 8, 2026: 45 @ 25.80 |
| April 10, 2026 | issue | SO-260410-524 | MAIN | 14 | 25.80 | -361.13 | 491 | 12,665.44 | March 8, 2026: 14 @ 25.80 |
| April 7, 2026 | issue | SO-260407-746 | MAIN | 31 | 25.80 | -799.65 | 505 | 13,026.58 | March 8, 2026: 31 @ 25.80 |
| March 22, 2026 | issue | SO-260322-526 | MAIN | 65 | 26.08 | -1,695.01 | 536 | 13,826.23 | Dec. 25, 2025: 41 @ 26.24; March 8, 2026: 24 @ 25.80 |
| March 8, 2026 | receipt | PO-001296 | MAIN | 560 | 25.80 | 14,445.31 | 601 | 15,521.24 | |
| March 4, 2026 | issue | SO-260304-177 | MAIN | 77 | 26.24 | -2,020.64 | 41 | 1,075.93 | Dec. 25, 2025: 77 @ 26.24 |
| Feb. 21, 2026 | issue | SO-260221-329 | MAIN | 15 | 26.24 | -393.63 | 118 | 3,096.57 | Dec. 25, 2025: 15 @ 26.24 |
| Feb. 11, 2026 | issue | SO-260211-930 | MAIN | 1 | 26.24 | -26.24 | 133 | 3,490.20 | Dec. 25, 2025: 1 @ 26.24 |
| Feb. 10, 2026 | issue | SO-260210-672 | MAIN | 45 | 26.24 | -1,180.89 | 134 | 3,516.44 | Dec. 25, 2025: 45 @ 26.24 |
| Feb. 7, 2026 | issue | SO-260207-550 | MAIN | 76 | 26.24 | -1,994.40 | 179 | 4,697.34 | Dec. 25, 2025: 76 @ 26.24 |
| Feb. 1, 2026 | issue | SO-260201-707 | MAIN | 105 | 26.24 | -2,755.42 | 255 | 6,691.74 | Dec. 25, 2025: 105 @ 26.24 |
| Jan. 19, 2026 | issue | SO-260119-626 | MAIN | 79 | 26.24 | -2,073.13 | 360 | 9,447.16 | Dec. 25, 2025: 79 @ 26.24 |
| Jan. 18, 2026 | issue | SO-260118-316 | MAIN | 121 | 26.24 | -3,175.29 | 439 | 11,520.28 | Dec. 25, 2025: 121 @ 26.24 |
| Dec. 25, 2025 | receipt | PO-001089 | MAIN | 560 | 26.24 | 14,695.58 | 560 | 14,695.58 | |
| Dec. 20, 2025 | issue | SO-251220-990 | MAIN | 28 | 25.44 | -712.22 | 0 | 0.00 | Oct. 7, 2025: 28 @ 25.44 |
| Dec. 19, 2025 | issue | SO-251219-261 | MAIN | 209 | 25.44 | -5,316.19 | 28 | 712.22 | Oct. 7, 2025: 209 @ 25.44 |
| Nov. 30, 2025 | issue | SO-251130-385 | MAIN | 37 | 25.44 | -941.14 | 237 | 6,028.40 | Oct. 7, 2025: 37 @ 25.44 |
| Nov. 26, 2025 | issue | SO-251126-397 | MAIN | 34 | 25.44 | -864.83 | 274 | 6,969.55 | Oct. 7, 2025: 34 @ 25.44 |
| Nov. 25, 2025 | issue | SO-251125-971 | MAIN | 44 | 25.44 | -1,119.20 | 308 | 7,834.38 | Oct. 7, 2025: 44 @ 25.44 |
| Nov. 24, 2025 | issue | SO-251124-561 | MAIN | 21 | 25.44 | -534.16 | 352 | 8,953.58 | Oct. 7, 2025: 21 @ 25.44 |
| Nov. 19, 2025 | issue | SO-251119-679 | MAIN | 2 | 25.44 | -50.87 | 373 | 9,487.74 | Oct. 7, 2025: 2 @ 25.44 |
| Nov. 12, 2025 | issue | SO-251112-147 | MAIN | 12 | 25.44 | -305.24 | 375 | 9,538.61 | Oct. 7, 2025: 12 @ 25.44 |
| Nov. 2, 2025 | issue | SO-251102-554 | MAIN | 22 | 25.44 | -559.60 | 387 | 9,843.85 | Oct. 7, 2025: 22 @ 25.44 |
| Oct. 30, 2025 | issue | SO-251030-464 | MAIN | 48 | 25.44 | -1,220.94 | 409 | 10,403.45 | Oct. 7, 2025: 48 @ 25.44 |
| Oct. 30, 2025 | issue | SO-251030-464 | EAST | 46 | 25.44 | -1,170.07 | 457 | 11,624.39 | Oct. 7, 2025: 46 @ 25.44 |
| Oct. 28, 2025 | issue | SO-251028-547 | MAIN | 7 | 25.44 | -178.05 | 503 | 12,794.46 | Oct. 7, 2025: 7 @ 25.44 |
| Oct. 22, 2025 | issue | SO-251022-873 | MAIN | 10 | 25.44 | -254.36 | 510 | 12,972.51 | Oct. 7, 2025: 10 @ 25.44 |
| Oct. 21, 2025 | issue | SO-251021-411 | MAIN | 63 | 25.17 | -1,585.63 | 520 | 13,226.88 | June 30, 2025: 23 @ 24.70; Oct. 7, 2025: 40 @ 25.44 |
| Oct. 20, 2025 | issue | SO-251020-561 | MAIN | 11 | 24.70 | -271.74 | 583 | 14,812.51 | June 30, 2025: 11 @ 24.70 |
| Oct. 11, 2025 | issue | SO-251011-120 | MAIN | 12 | 24.70 | -296.44 | 594 | 15,084.24 | June 30, 2025: 12 @ 24.70 |
| Oct. 9, 2025 | issue | SO-251009-539 | EAST | 24 | 24.70 | -592.88 | 606 | 15,380.68 | June 30, 2025: 24 @ 24.70 |