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
| 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 |
| Sept. 25, 2025 | issue | SO-250925-538 | MAIN | 6 | 4.41 | -26.45 | 64 | 282.13 | June 20, 2025: 6 @ 4.41 |
| Sept. 22, 2025 | issue | SO-250922-369 | MAIN | 44 | 4.41 | -193.97 | 70 | 308.58 | June 20, 2025: 44 @ 4.41 |
| Sept. 4, 2025 | issue | SO-250904-390 | MAIN | 26 | 4.41 | -114.62 | 114 | 502.55 | June 20, 2025: 26 @ 4.41 |
| Aug. 28, 2025 | issue | SO-250828-542 | MAIN | 39 | 4.41 | -171.92 | 140 | 617.16 | June 20, 2025: 39 @ 4.41 |
| Aug. 26, 2025 | issue | SO-250826-497 | MAIN | 5 | 4.41 | -22.04 | 179 | 789.09 | June 20, 2025: 5 @ 4.41 |
| Aug. 23, 2025 | issue | SO-250823-326 | MAIN | 128 | 4.41 | -564.26 | 184 | 811.13 | June 20, 2025: 128 @ 4.41 |
| Aug. 13, 2025 | issue | SO-250813-633 | MAIN | 12 | 4.41 | -52.90 | 312 | 1,375.39 | June 20, 2025: 12 @ 4.41 |
| Aug. 12, 2025 | issue | SO-250812-483 | MAIN | 22 | 4.41 | -96.98 | 324 | 1,428.29 | June 20, 2025: 22 @ 4.41 |
| Aug. 7, 2025 | issue | SO-250807-157 | MAIN | 29 | 4.41 | -127.84 | 346 | 1,525.27 | June 20, 2025: 29 @ 4.41 |
| July 29, 2025 | adjustment | Cycle count | MAIN | -2 | 4.41 | -8.82 | 375 | 1,653.11 | June 20, 2025: 2 @ 4.41 |
| July 22, 2025 | issue | SO-250722-394 | MAIN | 108 | 4.41 | -476.10 | 377 | 1,661.93 | June 20, 2025: 108 @ 4.41 |
| July 14, 2025 | return | RMA | MAIN | 35 | 4.41 | 154.29 | 485 | 2,138.03 | |
| July 9, 2025 | issue | SO-250709-852 | MAIN | 132 | 4.41 | -581.90 | 450 | 1,983.74 | June 20, 2025: 132 @ 4.41 |
| June 25, 2025 | issue | SO-250625-180 | MAIN | 70 | 4.50 | -315.18 | 582 | 2,565.63 | March 14, 2025: 52 @ 4.54; June 20, 2025: 18 @ 4.41 |
| June 20, 2025 | receipt | PO-000653 | MAIN | 600 | 4.41 | 2,644.98 | 652 | 2,880.82 | |
| June 14, 2025 | issue | SO-250614-425 | MAIN | 109 | 4.54 | -494.35 | 52 | 235.84 | March 14, 2025: 109 @ 4.54 |
| May 30, 2025 | issue | SO-250530-128 | MAIN | 78 | 4.54 | -353.75 | 161 | 730.18 | March 14, 2025: 78 @ 4.54 |
| May 24, 2025 | issue | SO-250524-240 | MAIN | 124 | 4.54 | -562.38 | 239 | 1,083.94 | March 14, 2025: 124 @ 4.54 |
| May 22, 2025 | issue | SO-250522-633 | MAIN | 39 | 4.54 | -176.88 | 363 | 1,646.31 | March 14, 2025: 39 @ 4.54 |
| April 25, 2025 | issue | SO-250425-899 | MAIN | 21 | 4.54 | -95.24 | 402 | 1,823.19 | March 14, 2025: 21 @ 4.54 |
| April 24, 2025 | issue | SO-250424-753 | MAIN | 51 | 4.54 | -231.30 | 423 | 1,918.43 | March 14, 2025: 51 @ 4.54 |
| April 13, 2025 | issue | SO-250413-221 | MAIN | 77 | 4.54 | -349.22 | 474 | 2,149.73 | March 14, 2025: 77 @ 4.54 |
| April 10, 2025 | issue | SO-250410-827 | MAIN | 8 | 4.54 | -36.28 | 551 | 2,498.95 | March 14, 2025: 8 @ 4.54 |
| April 2, 2025 | issue | SO-250402-354 | MAIN | 43 | 4.53 | -194.69 | 559 | 2,535.23 | Dec. 25, 2024: 2 @ 4.37; March 14, 2025: 41 @ 4.54 |
| March 31, 2025 | issue | SO-250331-190 | MAIN | 23 | 4.37 | -100.52 | 602 | 2,729.92 | Dec. 25, 2024: 23 @ 4.37 |
| March 14, 2025 | receipt | PO-000341 | MAIN | 600 | 4.54 | 2,721.18 | 625 | 2,830.44 | |
| March 12, 2025 | issue | SO-250312-210 | MAIN | 63 | 4.37 | -275.35 | 25 | 109.26 | Dec. 25, 2024: 63 @ 4.37 |
| March 9, 2025 | issue | SO-250309-887 | MAIN | 47 | 4.37 | -205.42 | 88 | 384.61 | Dec. 25, 2024: 47 @ 4.37 |
| March 7, 2025 | issue | SO-250307-696 | MAIN | 7 | 4.37 | -30.59 | 135 | 590.03 | Dec. 25, 2024: 7 @ 4.37 |
| March 1, 2025 | issue | SO-250301-549 | MAIN | 29 | 4.37 | -126.75 | 142 | 620.63 | Dec. 25, 2024: 29 @ 4.37 |
| Feb. 22, 2025 | issue | SO-250222-964 | MAIN | 57 | 4.37 | -249.12 | 171 | 747.37 | Dec. 25, 2024: 57 @ 4.37 |
| Feb. 2, 2025 | issue | SO-250202-578 | MAIN | 129 | 4.37 | -563.81 | 228 | 996.50 | Dec. 25, 2024: 129 @ 4.37 |
| Jan. 31, 2025 | issue | SO-250131-177 | MAIN | 38 | 4.37 | -166.08 | 357 | 1,560.30 | Dec. 25, 2024: 38 @ 4.37 |
| Jan. 30, 2025 | issue | SO-250130-243 | MAIN | 35 | 4.37 | -152.97 | 395 | 1,726.39 | Dec. 25, 2024: 35 @ 4.37 |
| Jan. 27, 2025 | issue | SO-250127-985 | MAIN | 6 | 4.37 | -26.22 | 430 | 1,879.36 | Dec. 25, 2024: 6 @ 4.37 |
| Jan. 21, 2025 | issue | SO-250121-376 | MAIN | 57 | 4.37 | -249.12 | 436 | 1,905.58 | Dec. 25, 2024: 57 @ 4.37 |
| Jan. 16, 2025 | issue | SO-250116-124 | MAIN | 54 | 4.37 | -236.01 | 493 | 2,154.71 | Dec. 25, 2024: 54 @ 4.37 |
| Jan. 1, 2025 | issue | SO-250101-142 | MAIN | 40 | 4.37 | -174.82 | 547 | 2,390.72 | Dec. 25, 2024: 40 @ 4.37 |
| Dec. 29, 2024 | issue | SO-241229-900 | MAIN | 13 | 4.37 | -56.82 | 587 | 2,565.54 | Dec. 25, 2024: 13 @ 4.37 |
| Dec. 25, 2024 | receipt | PO-000132 | MAIN | 600 | 4.37 | 2,622.36 | 600 | 2,622.36 | |
| Dec. 21, 2024 | issue | SO-241221-530 | MAIN | 67 | 4.56 | -305.52 | 0 | 0.00 | Oct. 1, 2024: 67 @ 4.56 |
| Dec. 16, 2024 | issue | SO-241216-914 | MAIN | 67 | 4.56 | -305.52 | 67 | 305.52 | Oct. 1, 2024: 67 @ 4.56 |
| Nov. 23, 2024 | issue | SO-241123-696 | MAIN | 67 | 4.56 | -305.52 | 134 | 611.04 | Oct. 1, 2024: 67 @ 4.56 |
| Nov. 18, 2024 | issue | SO-241118-347 | MAIN | 16 | 4.56 | -72.96 | 201 | 916.56 | Oct. 1, 2024: 16 @ 4.56 |
| Nov. 15, 2024 | issue | SO-241115-750 | MAIN | 24 | 4.56 | -109.44 | 217 | 989.52 | Oct. 1, 2024: 24 @ 4.56 |
| Nov. 6, 2024 | issue | SO-241106-313 | MAIN | 72 | 4.56 | -328.32 | 241 | 1,098.96 | Oct. 1, 2024: 72 @ 4.56 |
| Nov. 3, 2024 | issue | SO-241103-702 | MAIN | 61 | 4.56 | -278.16 | 313 | 1,427.28 | Oct. 1, 2024: 61 @ 4.56 |
| Oct. 27, 2024 | issue | SO-241027-556 | MAIN | 128 | 4.56 | -583.68 | 374 | 1,705.44 | Oct. 1, 2024: 128 @ 4.56 |
| Oct. 24, 2024 | issue | SO-241024-962 | MAIN | 98 | 4.56 | -446.88 | 502 | 2,289.12 | Oct. 1, 2024: 98 @ 4.56 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 600 | 4.56 | 2,736.00 | 600 | 2,736.00 | |