Items / SWT-0017
Socket 5-pin Nova SWT-0017 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)162MAIN 162
Value (FIFO)1,902.25avg 11.74
ClassCX / FCV 0.20
Turnover5.1xlast issue 0 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 | 74.00 / 30.4375 | 2.431 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 15.02 / 5.517 | 2.723 |
| 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.723^2 + 2.431^2 * 1.5^2) | 10.4 |
| Reorder point | d * LT + safety stock | 2.431 * 7.0 + 10.4 | 27.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 27.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 887/yr, S = 45.00, h = 20%, price = 10.88 | 880.0 |
| Inventory position | on hand + on order | 162 + 0 | 162 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 11.83 | 184 | 10,933 | yes |
| 440 | 11.36 | 440 | 10,668 | yes |
| 880 | 10.88 | 880 | 10,661 | yes (chosen if cheapest) |
MOQ 220, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 7, 2026 | 162 / 220 | 11.74 | 1,902.25 |
Movement ledger 138 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-999 | MAIN | 32 | 11.74 | -375.75 | 162 | 1,902.25 | Oct. 7, 2026: 32 @ 11.74 |
| Oct. 14, 2026 | issue | SO-261014-623 | MAIN | 12 | 11.74 | -140.91 | 194 | 2,278.01 | Oct. 7, 2026: 12 @ 11.74 |
| Oct. 12, 2026 | issue | SO-261012-610 | MAIN | 14 | 11.74 | -164.39 | 206 | 2,418.91 | Oct. 7, 2026: 14 @ 11.74 |
| Oct. 7, 2026 | receipt | PO-001857 | MAIN | 220 | 11.74 | 2,583.31 | 220 | 2,583.31 | |
| Oct. 2, 2026 | issue | SO-261002-715 | MAIN | 11 | 11.93 | -131.18 | 0 | 0.00 | June 27, 2026: 2 @ 11.60; Aug. 28, 2026: 9 @ 12.00 |
| Sept. 30, 2026 | issue | SO-260930-254 | MAIN | 78 | 11.98 | -934.54 | 11 | 131.18 | June 24, 2026: 75 @ 12.00; June 27, 2026: 3 @ 11.60 |
| Sept. 26, 2026 | issue | SO-260926-982 | MAIN | 3 | 12.00 | -35.99 | 89 | 1,065.72 | June 24, 2026: 3 @ 12.00 |
| Sept. 16, 2026 | issue | SO-260916-949 | MAIN | 6 | 12.00 | -71.98 | 92 | 1,101.71 | June 24, 2026: 6 @ 12.00 |
| Aug. 29, 2026 | issue | SO-260829-734 | MAIN | 33 | 12.00 | -395.88 | 98 | 1,173.69 | June 24, 2026: 33 @ 12.00 |
| Aug. 28, 2026 | return | RMA | MAIN | 9 | 12.00 | 107.97 | 131 | 1,569.57 | |
| Aug. 26, 2026 | issue | SO-260826-675 | MAIN | 19 | 12.00 | -227.93 | 122 | 1,461.60 | June 24, 2026: 19 @ 12.00 |
| Aug. 8, 2026 | issue | SO-260808-766 | MAIN | 18 | 12.00 | -215.94 | 141 | 1,689.53 | June 24, 2026: 18 @ 12.00 |
| July 27, 2026 | issue | SO-260727-455 | MAIN | 1 | 12.00 | -12.00 | 159 | 1,905.47 | June 24, 2026: 1 @ 12.00 |
| July 25, 2026 | issue | SO-260725-991 | MAIN | 5 | 12.00 | -59.98 | 160 | 1,917.46 | June 24, 2026: 5 @ 12.00 |
| July 9, 2026 | issue | SO-260709-242 | MAIN | 2 | 12.00 | -23.99 | 165 | 1,977.45 | June 24, 2026: 2 @ 12.00 |
| July 6, 2026 | issue | SO-260706-571 | MAIN | 27 | 12.00 | -323.90 | 167 | 2,001.44 | June 24, 2026: 27 @ 12.00 |
| July 5, 2026 | issue | SO-260705-205 | MAIN | 13 | 12.00 | -155.95 | 194 | 2,325.34 | June 24, 2026: 13 @ 12.00 |
| July 5, 2026 | issue | SO-260705-205 | EAST | 2 | 12.00 | -23.99 | 207 | 2,481.29 | June 24, 2026: 2 @ 12.00 |
| July 4, 2026 | issue | SO-260704-359 | EAST | 20 | 11.92 | -238.36 | 209 | 2,505.29 | March 29, 2026: 4 @ 11.60; June 24, 2026: 16 @ 12.00 |
| June 27, 2026 | return | RMA | MAIN | 5 | 11.60 | 58.02 | 229 | 2,743.65 | |
| June 24, 2026 | issue | SO-260624-504 | MAIN | 29 | 11.60 | -336.53 | 224 | 2,685.63 | March 29, 2026: 29 @ 11.60 |
| June 24, 2026 | receipt | PO-001601 | MAIN | 220 | 12.00 | 2,639.21 | 253 | 3,022.15 | |
| June 19, 2026 | issue | SO-260619-498 | MAIN | 1 | 11.60 | -11.60 | 33 | 382.95 | March 29, 2026: 1 @ 11.60 |
| June 12, 2026 | issue | SO-260612-158 | MAIN | 10 | 11.60 | -116.04 | 34 | 394.55 | March 29, 2026: 10 @ 11.60 |
| June 10, 2026 | issue | SO-260610-958 | EAST | 19 | 11.60 | -220.48 | 44 | 510.59 | March 29, 2026: 19 @ 11.60 |
| June 4, 2026 | issue | SO-260604-798 | EAST | 8 | 11.60 | -92.84 | 63 | 731.08 | March 29, 2026: 8 @ 11.60 |
| June 3, 2026 | issue | SO-260603-537 | MAIN | 4 | 11.60 | -46.42 | 71 | 823.91 | March 29, 2026: 4 @ 11.60 |
| June 2, 2026 | issue | SO-260602-327 | MAIN | 3 | 11.60 | -34.81 | 75 | 870.33 | March 29, 2026: 3 @ 11.60 |
| May 31, 2026 | issue | SO-260531-464 | MAIN | 38 | 11.60 | -440.97 | 78 | 905.14 | March 29, 2026: 38 @ 11.60 |
| May 23, 2026 | adjustment | Cycle count | MAIN | -2 | 11.60 | -23.21 | 116 | 1,346.11 | March 29, 2026: 2 @ 11.60 |
| May 19, 2026 | issue | SO-260519-236 | MAIN | 3 | 11.60 | -34.81 | 118 | 1,369.32 | March 29, 2026: 3 @ 11.60 |
| May 4, 2026 | issue | SO-260504-388 | MAIN | 13 | 11.60 | -150.86 | 121 | 1,404.13 | March 29, 2026: 13 @ 11.60 |
| May 3, 2026 | issue | SO-260503-891 | EAST | 5 | 11.60 | -58.02 | 134 | 1,554.99 | March 29, 2026: 5 @ 11.60 |
| April 6, 2026 | issue | SO-260406-597 | MAIN | 49 | 11.60 | -568.62 | 139 | 1,613.01 | March 29, 2026: 49 @ 11.60 |
| April 5, 2026 | issue | SO-260405-415 | MAIN | 32 | 11.60 | -371.34 | 188 | 2,181.63 | March 29, 2026: 32 @ 11.60 |
| March 29, 2026 | transfer | TRF | MAIN → EAST | 54 | warehouse transfer, no cost effect | ||||
| March 29, 2026 | receipt | PO-001365 | MAIN | 220 | 11.60 | 2,552.97 | 220 | 2,552.97 | |
| March 23, 2026 | issue | SO-260323-401 | MAIN | 11 | 11.16 | -122.81 | 0 | 0.00 | Jan. 2, 2026: 11 @ 11.16 |
| March 22, 2026 | issue | SO-260322-315 | MAIN | 37 | 11.16 | -413.10 | 11 | 122.81 | Jan. 2, 2026: 37 @ 11.16 |
| March 17, 2026 | issue | SO-260317-815 | MAIN | 2 | 11.16 | -22.33 | 48 | 535.91 | Jan. 2, 2026: 2 @ 11.16 |
| Feb. 21, 2026 | issue | SO-260221-940 | MAIN | 23 | 11.16 | -256.79 | 50 | 558.24 | Jan. 2, 2026: 23 @ 11.16 |
| Feb. 20, 2026 | issue | SO-260220-298 | MAIN | 15 | 11.16 | -167.47 | 73 | 815.03 | Jan. 2, 2026: 15 @ 11.16 |
| Feb. 16, 2026 | issue | SO-260216-752 | MAIN | 30 | 11.16 | -334.94 | 88 | 982.50 | Jan. 2, 2026: 30 @ 11.16 |
| Feb. 13, 2026 | issue | SO-260213-319 | MAIN | 3 | 11.16 | -33.49 | 118 | 1,317.45 | Jan. 2, 2026: 3 @ 11.16 |
| Feb. 9, 2026 | issue | SO-260209-832 | MAIN | 16 | 11.16 | -178.64 | 121 | 1,350.94 | Jan. 2, 2026: 16 @ 11.16 |
| Feb. 7, 2026 | issue | SO-260207-483 | MAIN | 18 | 11.16 | -200.97 | 137 | 1,529.58 | Jan. 2, 2026: 18 @ 11.16 |
| Jan. 27, 2026 | issue | SO-260127-143 | MAIN | 24 | 11.16 | -267.96 | 155 | 1,730.54 | Jan. 2, 2026: 24 @ 11.16 |
| Jan. 26, 2026 | issue | SO-260126-673 | MAIN | 2 | 11.16 | -22.33 | 179 | 1,998.50 | Jan. 2, 2026: 2 @ 11.16 |
| Jan. 20, 2026 | issue | SO-260120-748 | MAIN | 5 | 11.16 | -55.82 | 181 | 2,020.83 | Jan. 2, 2026: 5 @ 11.16 |
| Jan. 18, 2026 | issue | SO-260118-285 | MAIN | 1 | 11.16 | -11.16 | 186 | 2,076.65 | Jan. 2, 2026: 1 @ 11.16 |
| Jan. 15, 2026 | issue | SO-260115-120 | MAIN | 4 | 11.16 | -44.66 | 187 | 2,087.82 | Jan. 2, 2026: 4 @ 11.16 |
| Jan. 14, 2026 | issue | SO-260114-970 | MAIN | 4 | 11.16 | -44.66 | 191 | 2,132.48 | Jan. 2, 2026: 4 @ 11.16 |
| Jan. 6, 2026 | issue | SO-260106-827 | MAIN | 25 | 11.16 | -279.12 | 195 | 2,177.14 | Jan. 2, 2026: 25 @ 11.16 |
| Jan. 2, 2026 | receipt | PO-001113 | MAIN | 220 | 11.16 | 2,456.26 | 220 | 2,456.26 | |
| Dec. 27, 2025 | issue | SO-251227-180 | MAIN | 56 | 11.25 | -629.99 | 0 | 0.00 | Oct. 1, 2025: 56 @ 11.25 |
| Dec. 26, 2025 | issue | SO-251226-306 | MAIN | 4 | 11.25 | -45.00 | 56 | 629.99 | Oct. 1, 2025: 4 @ 11.25 |
| Dec. 22, 2025 | issue | SO-251222-415 | MAIN | 4 | 11.25 | -45.00 | 60 | 674.99 | Oct. 1, 2025: 4 @ 11.25 |
| Dec. 19, 2025 | issue | SO-251219-540 | MAIN | 1 | 11.25 | -11.25 | 64 | 719.99 | Oct. 1, 2025: 1 @ 11.25 |
| Dec. 7, 2025 | issue | SO-251207-178 | MAIN | 4 | 11.25 | -45.00 | 65 | 731.24 | Oct. 1, 2025: 4 @ 11.25 |
| Dec. 6, 2025 | issue | SO-251206-648 | MAIN | 13 | 11.25 | -146.25 | 69 | 776.24 | Oct. 1, 2025: 13 @ 11.25 |