Items / SWT-0010
Socket 5-pin Plus SWT-0010 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)541MAIN 541
Value (FIFO)2,585.38avg 4.78
ClassCX / FCV 0.24
Turnover4.6xlast issue 4 days ago
Days of cover85lead 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 | 194.08 / 30.4375 | 6.376 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 46.05 / 5.517 | 8.348 |
| 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 * 8.348^2 + 6.376^2 * 1.5^2) | 30.9 |
| Reorder point | d * LT + safety stock | 6.376 * 7.0 + 30.9 | 75.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 75.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2327/yr, S = 45.00, h = 20%, price = 4.80 | 467.1 |
| Inventory position | on hand + on order | 541 + 0 | 541 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 4.80 | 467 | 11,620 | yes (chosen if cheapest) |
MOQ 600, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 3, 2026 | 541 / 600 | 4.78 | 2,585.38 |
Movement ledger 110 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-701 | MAIN | 66 | 4.78 | -315.36 | 541 | 2,585.38 | June 23, 2026: 7 @ 4.77; Oct. 3, 2026: 59 @ 4.78 |
| Oct. 4, 2026 | issue | SO-261004-193 | MAIN | 64 | 4.77 | -305.41 | 607 | 2,900.74 | June 23, 2026: 64 @ 4.77 |
| Oct. 3, 2026 | receipt | PO-001848 | MAIN | 600 | 4.78 | 2,867.34 | 671 | 3,206.16 | |
| Sept. 29, 2026 | issue | SO-260929-720 | MAIN | 16 | 4.77 | -76.35 | 71 | 338.82 | June 23, 2026: 16 @ 4.77 |
| Sept. 25, 2026 | issue | SO-260925-147 | MAIN | 12 | 4.77 | -57.27 | 87 | 415.17 | June 23, 2026: 12 @ 4.77 |
| Sept. 22, 2026 | issue | SO-260922-232 | MAIN | 65 | 4.77 | -310.19 | 99 | 472.44 | June 23, 2026: 65 @ 4.77 |
| Sept. 20, 2026 | issue | SO-260920-120 | MAIN | 103 | 4.77 | -491.53 | 164 | 782.62 | June 23, 2026: 103 @ 4.77 |
| Sept. 16, 2026 | issue | SO-260916-738 | MAIN | 20 | 4.77 | -95.44 | 267 | 1,274.15 | June 23, 2026: 20 @ 4.77 |
| Sept. 12, 2026 | issue | SO-260912-595 | MAIN | 3 | 4.77 | -14.32 | 287 | 1,369.59 | June 23, 2026: 3 @ 4.77 |
| Sept. 3, 2026 | issue | SO-260903-988 | MAIN | 3 | 4.77 | -14.32 | 290 | 1,383.91 | June 23, 2026: 3 @ 4.77 |
| Aug. 29, 2026 | issue | SO-260829-293 | MAIN | 89 | 4.77 | -424.72 | 293 | 1,398.23 | June 23, 2026: 89 @ 4.77 |
| Aug. 9, 2026 | issue | SO-260809-623 | MAIN | 40 | 4.77 | -190.88 | 382 | 1,822.94 | June 23, 2026: 40 @ 4.77 |
| Aug. 9, 2026 | issue | SO-260809-623 | EAST | 25 | 4.77 | -119.30 | 422 | 2,013.83 | June 23, 2026: 25 @ 4.77 |
| Aug. 5, 2026 | issue | SO-260805-756 | MAIN | 17 | 4.77 | -81.13 | 447 | 2,133.13 | June 23, 2026: 17 @ 4.77 |
| Aug. 1, 2026 | issue | SO-260801-585 | MAIN | 1 | 4.77 | -4.77 | 464 | 2,214.25 | June 23, 2026: 1 @ 4.77 |
| July 29, 2026 | issue | SO-260729-711 | EAST | 36 | 4.77 | -171.80 | 465 | 2,219.03 | June 23, 2026: 36 @ 4.77 |
| July 28, 2026 | issue | SO-260728-885 | EAST | 75 | 4.77 | -357.91 | 501 | 2,390.82 | June 23, 2026: 75 @ 4.77 |
| July 27, 2026 | issue | SO-260727-332 | MAIN | 38 | 4.79 | -182.12 | 576 | 2,748.73 | April 25, 2026: 14 @ 4.83; June 23, 2026: 24 @ 4.77 |
| July 23, 2026 | issue | SO-260723-461 | MAIN | 12 | 4.83 | -57.93 | 614 | 2,930.85 | April 25, 2026: 12 @ 4.83 |
| July 12, 2026 | issue | SO-260712-696 | EAST | 18 | 4.83 | -86.90 | 626 | 2,988.78 | April 25, 2026: 18 @ 4.83 |
| June 25, 2026 | issue | SO-260625-665 | MAIN | 7 | 4.83 | -33.79 | 644 | 3,075.68 | April 25, 2026: 7 @ 4.83 |
| June 23, 2026 | transfer | TRF | MAIN → EAST | 154 | warehouse transfer, no cost effect | ||||
| June 23, 2026 | receipt | PO-001598 | MAIN | 600 | 4.77 | 2,863.26 | 651 | 3,109.47 | |
| June 22, 2026 | issue | SO-260622-198 | MAIN | 8 | 4.83 | -38.62 | 51 | 246.21 | April 25, 2026: 8 @ 4.83 |
| June 17, 2026 | issue | SO-260617-526 | MAIN | 42 | 4.83 | -202.76 | 59 | 284.83 | April 25, 2026: 42 @ 4.83 |
| June 17, 2026 | issue | SO-260617-526 | EAST | 50 | 4.83 | -241.38 | 101 | 487.60 | April 25, 2026: 50 @ 4.83 |
| June 12, 2026 | issue | SO-260612-809 | MAIN | 51 | 4.83 | -246.21 | 151 | 728.98 | April 25, 2026: 51 @ 4.83 |
| June 6, 2026 | issue | SO-260606-769 | MAIN | 24 | 4.83 | -115.86 | 202 | 975.20 | April 25, 2026: 24 @ 4.83 |
| June 2, 2026 | issue | SO-260602-796 | MAIN | 18 | 4.83 | -86.90 | 226 | 1,091.06 | April 25, 2026: 18 @ 4.83 |
| May 27, 2026 | issue | SO-260527-867 | MAIN | 113 | 4.83 | -545.53 | 244 | 1,177.96 | April 25, 2026: 113 @ 4.83 |
| May 12, 2026 | issue | SO-260512-947 | MAIN | 16 | 4.83 | -77.24 | 357 | 1,723.49 | April 25, 2026: 16 @ 4.83 |
| May 9, 2026 | issue | SO-260509-878 | EAST | 77 | 4.83 | -371.73 | 373 | 1,800.73 | April 25, 2026: 77 @ 4.83 |
| April 27, 2026 | issue | SO-260427-346 | MAIN | 204 | 4.80 | -978.40 | 450 | 2,172.46 | Dec. 13, 2025: 54 @ 4.71; April 25, 2026: 150 @ 4.83 |
| April 25, 2026 | transfer | TRF | MAIN → EAST | 127 | warehouse transfer, no cost effect | ||||
| April 25, 2026 | receipt | PO-001438 | MAIN | 600 | 4.83 | 2,896.62 | 654 | 3,150.87 | |
| April 19, 2026 | issue | SO-260419-238 | MAIN | 58 | 4.71 | -273.08 | 54 | 254.25 | Dec. 13, 2025: 58 @ 4.71 |
| March 22, 2026 | issue | SO-260322-636 | MAIN | 207 | 4.71 | -974.62 | 112 | 527.33 | Dec. 13, 2025: 207 @ 4.71 |
| March 18, 2026 | issue | SO-260318-429 | MAIN | 45 | 4.71 | -211.87 | 319 | 1,501.95 | Dec. 13, 2025: 45 @ 4.71 |
| Feb. 28, 2026 | issue | SO-260228-943 | MAIN | 50 | 4.71 | -235.42 | 364 | 1,713.82 | Dec. 13, 2025: 50 @ 4.71 |
| Feb. 14, 2026 | issue | SO-260214-595 | MAIN | 49 | 4.71 | -230.71 | 414 | 1,949.24 | Dec. 13, 2025: 49 @ 4.71 |
| Feb. 7, 2026 | issue | SO-260207-636 | MAIN | 9 | 4.71 | -42.37 | 463 | 2,179.94 | Dec. 13, 2025: 9 @ 4.71 |
| Feb. 3, 2026 | issue | SO-260203-577 | MAIN | 21 | 4.71 | -98.87 | 472 | 2,222.32 | Dec. 13, 2025: 21 @ 4.71 |
| Jan. 22, 2026 | issue | SO-260122-195 | MAIN | 13 | 4.71 | -61.21 | 493 | 2,321.19 | Dec. 13, 2025: 13 @ 4.71 |
| Jan. 8, 2026 | issue | SO-260108-547 | MAIN | 15 | 4.71 | -70.62 | 506 | 2,382.40 | Dec. 13, 2025: 15 @ 4.71 |
| Jan. 3, 2026 | issue | SO-260103-543 | MAIN | 88 | 4.70 | -413.84 | 521 | 2,453.02 | Sept. 27, 2025: 9 @ 4.65; Dec. 13, 2025: 79 @ 4.71 |
| Jan. 2, 2026 | issue | SO-260102-441 | MAIN | 60 | 4.65 | -279.25 | 609 | 2,866.87 | Sept. 27, 2025: 60 @ 4.65 |
| Dec. 16, 2025 | issue | SO-251216-178 | MAIN | 18 | 4.65 | -83.78 | 669 | 3,146.12 | Sept. 27, 2025: 18 @ 4.65 |
| Dec. 14, 2025 | issue | SO-251214-526 | MAIN | 4 | 4.65 | -18.62 | 687 | 3,229.90 | Sept. 27, 2025: 4 @ 4.65 |
| Dec. 13, 2025 | receipt | PO-001049 | MAIN | 600 | 4.71 | 2,824.98 | 691 | 3,248.51 | |
| Dec. 6, 2025 | issue | SO-251206-307 | MAIN | 43 | 4.65 | -200.13 | 91 | 423.53 | Sept. 27, 2025: 43 @ 4.65 |
| Dec. 2, 2025 | issue | SO-251202-798 | MAIN | 33 | 4.65 | -153.59 | 134 | 623.66 | Sept. 27, 2025: 33 @ 4.65 |
| Nov. 28, 2025 | issue | SO-251128-840 | MAIN | 30 | 4.65 | -139.63 | 167 | 777.25 | Sept. 27, 2025: 30 @ 4.65 |
| Nov. 28, 2025 | issue | SO-251128-840 | EAST | 11 | 4.65 | -51.20 | 197 | 916.88 | Sept. 27, 2025: 11 @ 4.65 |
| Nov. 22, 2025 | issue | SO-251122-798 | MAIN | 2 | 4.65 | -9.31 | 208 | 968.07 | Sept. 27, 2025: 2 @ 4.65 |
| Nov. 18, 2025 | issue | SO-251118-823 | EAST | 196 | 4.65 | -912.22 | 210 | 977.38 | Sept. 27, 2025: 196 @ 4.65 |
| Oct. 23, 2025 | issue | SO-251023-441 | MAIN | 79 | 4.65 | -367.68 | 406 | 1,889.61 | Sept. 27, 2025: 79 @ 4.65 |
| Oct. 3, 2025 | issue | SO-251003-943 | MAIN | 115 | 4.65 | -535.23 | 485 | 2,257.29 | Sept. 27, 2025: 115 @ 4.65 |
| Sept. 27, 2025 | transfer | TRF | MAIN → EAST | 207 | warehouse transfer, no cost effect | ||||
| Sept. 27, 2025 | receipt | PO-000879 | MAIN | 600 | 4.65 | 2,792.52 | 600 | 2,792.52 | |
| Sept. 26, 2025 | issue | SO-250926-976 | MAIN | 64 | 4.41 | -282.13 | 0 | 0.00 | June 20, 2025: 29 @ 4.41; July 14, 2025: 35 @ 4.41 |