Items / SWT-0004
Socket 5-pin Lite SWT-0004 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)210MAIN 210
Value (FIFO)980.26avg 4.67
ClassCX / FCV 0.14
Turnover9.1xlast issue 3 days ago
Days of cover50lead 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 | 128.83 / 30.4375 | 4.233 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 17.80 / 5.517 | 3.227 |
| 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 * 3.227^2 + 4.233^2 * 1.5^2) | 13.8 |
| Reorder point | d * LT + safety stock | 4.233 * 7.0 + 13.8 | 43.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 43.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1545/yr, S = 45.00, h = 20%, price = 4.77 | 381.8 |
| Inventory position | on hand + on order | 210 + 0 | 210 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 4.77 | 382 | 7,734 | yes (chosen if cheapest) |
MOQ 450, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 29, 2026 | 210 / 450 | 4.67 | 980.26 |
Movement ledger 118 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 13, 2026 | issue | SO-261013-450 | MAIN | 88 | 4.67 | -410.78 | 210 | 980.26 | Sept. 29, 2026: 88 @ 4.67 |
| Oct. 2, 2026 | issue | SO-261002-785 | MAIN | 152 | 4.67 | -709.52 | 298 | 1,391.03 | Sept. 29, 2026: 152 @ 4.67 |
| Sept. 29, 2026 | receipt | PO-001839 | MAIN | 450 | 4.67 | 2,100.56 | 450 | 2,100.56 | |
| Sept. 21, 2026 | issue | SO-260921-491 | MAIN | 102 | 4.78 | -487.98 | 0 | 0.00 | May 11, 2026: 102 @ 4.78 |
| Sept. 9, 2026 | issue | SO-260909-931 | MAIN | 11 | 4.78 | -52.63 | 102 | 487.98 | May 11, 2026: 11 @ 4.78 |
| Aug. 23, 2026 | issue | SO-260823-682 | MAIN | 2 | 4.78 | -9.57 | 113 | 540.60 | May 11, 2026: 2 @ 4.78 |
| Aug. 18, 2026 | issue | SO-260818-341 | MAIN | 11 | 4.78 | -52.63 | 115 | 550.17 | May 11, 2026: 11 @ 4.78 |
| Aug. 12, 2026 | issue | SO-260812-803 | MAIN | 36 | 4.78 | -172.23 | 126 | 602.80 | May 11, 2026: 36 @ 4.78 |
| Aug. 7, 2026 | issue | SO-260807-613 | MAIN | 91 | 4.78 | -435.35 | 162 | 775.02 | May 11, 2026: 91 @ 4.78 |
| July 31, 2026 | issue | SO-260731-957 | MAIN | 23 | 4.78 | -110.03 | 253 | 1,210.38 | May 11, 2026: 23 @ 4.78 |
| July 25, 2026 | issue | SO-260725-941 | MAIN | 15 | 4.78 | -71.76 | 276 | 1,320.41 | May 11, 2026: 15 @ 4.78 |
| July 23, 2026 | issue | SO-260723-580 | MAIN | 14 | 4.78 | -66.98 | 291 | 1,392.17 | May 11, 2026: 14 @ 4.78 |
| July 21, 2026 | issue | SO-260721-372 | MAIN | 37 | 4.78 | -177.01 | 305 | 1,459.15 | May 11, 2026: 37 @ 4.78 |
| July 5, 2026 | issue | SO-260705-219 | MAIN | 30 | 4.78 | -143.52 | 342 | 1,636.16 | May 11, 2026: 30 @ 4.78 |
| July 2, 2026 | issue | SO-260702-128 | MAIN | 3 | 4.78 | -14.35 | 372 | 1,779.69 | May 11, 2026: 3 @ 4.78 |
| June 27, 2026 | issue | SO-260627-584 | MAIN | 25 | 4.78 | -119.60 | 375 | 1,794.04 | May 11, 2026: 25 @ 4.78 |
| June 21, 2026 | issue | SO-260621-585 | MAIN | 1 | 4.78 | -4.78 | 400 | 1,913.64 | May 11, 2026: 1 @ 4.78 |
| June 12, 2026 | issue | SO-260612-948 | MAIN | 75 | 4.70 | -352.14 | 401 | 1,918.42 | Feb. 13, 2026: 2 @ 4.70; Feb. 16, 2026: 24 @ 4.51; May 11, 2026: 49 @ 4.78 |
| May 26, 2026 | issue | SO-260526-408 | MAIN | 33 | 4.70 | -154.99 | 476 | 2,270.56 | Feb. 13, 2026: 33 @ 4.70 |
| May 11, 2026 | receipt | PO-001483 | MAIN | 450 | 4.78 | 2,152.84 | 509 | 2,425.56 | |
| May 9, 2026 | issue | SO-260509-839 | MAIN | 10 | 4.70 | -46.97 | 59 | 272.71 | Feb. 13, 2026: 10 @ 4.70 |
| May 3, 2026 | issue | SO-260503-313 | MAIN | 91 | 4.70 | -427.41 | 69 | 319.68 | Feb. 13, 2026: 91 @ 4.70 |
| May 3, 2026 | issue | SO-260503-313 | EAST | 11 | 4.70 | -51.66 | 160 | 747.09 | Feb. 13, 2026: 11 @ 4.70 |
| April 24, 2026 | issue | SO-260424-377 | MAIN | 57 | 4.70 | -267.72 | 171 | 798.76 | Feb. 13, 2026: 57 @ 4.70 |
| April 19, 2026 | issue | SO-260419-607 | MAIN | 35 | 4.70 | -164.39 | 228 | 1,066.47 | Feb. 13, 2026: 35 @ 4.70 |
| April 11, 2026 | issue | SO-260411-373 | MAIN | 11 | 4.70 | -51.66 | 263 | 1,230.86 | Feb. 13, 2026: 11 @ 4.70 |
| April 4, 2026 | issue | SO-260404-219 | EAST | 28 | 4.70 | -131.51 | 274 | 1,282.53 | Feb. 13, 2026: 28 @ 4.70 |
| March 19, 2026 | issue | SO-260319-546 | MAIN | 13 | 4.70 | -61.06 | 302 | 1,414.04 | Feb. 13, 2026: 13 @ 4.70 |
| March 18, 2026 | issue | SO-260318-780 | MAIN | 24 | 4.70 | -112.72 | 315 | 1,475.10 | Feb. 13, 2026: 24 @ 4.70 |
| March 17, 2026 | issue | SO-260317-713 | MAIN | 25 | 4.70 | -117.42 | 339 | 1,587.82 | Feb. 13, 2026: 25 @ 4.70 |
| March 9, 2026 | issue | SO-260309-939 | MAIN | 6 | 4.70 | -28.18 | 364 | 1,705.24 | Feb. 13, 2026: 6 @ 4.70 |
| March 3, 2026 | issue | SO-260303-369 | MAIN | 71 | 4.70 | -333.47 | 370 | 1,733.42 | Feb. 13, 2026: 71 @ 4.70 |
| Feb. 28, 2026 | issue | SO-260228-866 | MAIN | 12 | 4.70 | -56.36 | 441 | 2,066.89 | Feb. 13, 2026: 12 @ 4.70 |
| Feb. 27, 2026 | issue | SO-260227-647 | EAST | 38 | 4.61 | -175.36 | 453 | 2,123.25 | Nov. 2, 2025: 15 @ 4.51; Dec. 5, 2025: 2 @ 4.51; Feb. 13, 2026: 21 @ 4.70 |
| Feb. 21, 2026 | issue | SO-260221-430 | MAIN | 1 | 4.51 | -4.51 | 491 | 2,298.62 | Nov. 2, 2025: 1 @ 4.51 |
| Feb. 19, 2026 | issue | SO-260219-199 | EAST | 13 | 4.51 | -58.68 | 492 | 2,303.13 | Nov. 2, 2025: 13 @ 4.51 |
| Feb. 17, 2026 | issue | SO-260217-740 | MAIN | 1 | 4.51 | -4.51 | 505 | 2,361.81 | Nov. 2, 2025: 1 @ 4.51 |
| Feb. 16, 2026 | return | RMA | MAIN | 24 | 4.51 | 108.33 | 506 | 2,366.32 | |
| Feb. 13, 2026 | transfer | TRF | MAIN → EAST | 90 | warehouse transfer, no cost effect | ||||
| Feb. 13, 2026 | receipt | PO-001226 | MAIN | 450 | 4.70 | 2,113.56 | 482 | 2,258.00 | |
| Feb. 6, 2026 | issue | SO-260206-279 | MAIN | 49 | 4.51 | -221.17 | 32 | 144.44 | Nov. 2, 2025: 49 @ 4.51 |
| Feb. 3, 2026 | issue | SO-260203-412 | MAIN | 30 | 4.51 | -135.41 | 81 | 365.60 | Nov. 2, 2025: 30 @ 4.51 |
| Jan. 25, 2026 | issue | SO-260125-157 | MAIN | 16 | 4.51 | -72.22 | 111 | 501.01 | Nov. 2, 2025: 16 @ 4.51 |
| Jan. 17, 2026 | issue | SO-260117-938 | MAIN | 32 | 4.51 | -144.44 | 127 | 573.23 | Nov. 2, 2025: 32 @ 4.51 |
| Jan. 15, 2026 | issue | SO-260115-866 | MAIN | 42 | 4.51 | -189.57 | 159 | 717.66 | Nov. 2, 2025: 42 @ 4.51 |
| Jan. 2, 2026 | issue | SO-260102-408 | MAIN | 47 | 4.51 | -212.14 | 201 | 907.23 | Nov. 2, 2025: 47 @ 4.51 |
| Dec. 27, 2025 | issue | SO-251227-430 | MAIN | 3 | 4.51 | -13.54 | 248 | 1,119.37 | Nov. 2, 2025: 3 @ 4.51 |
| Dec. 25, 2025 | issue | SO-251225-934 | MAIN | 15 | 4.51 | -67.70 | 251 | 1,132.91 | Nov. 2, 2025: 15 @ 4.51 |
| Dec. 24, 2025 | issue | SO-251224-736 | MAIN | 22 | 4.51 | -99.30 | 266 | 1,200.62 | Nov. 2, 2025: 22 @ 4.51 |
| Dec. 23, 2025 | issue | SO-251223-103 | MAIN | 13 | 4.51 | -58.68 | 288 | 1,299.92 | Nov. 2, 2025: 13 @ 4.51 |
| Dec. 18, 2025 | issue | SO-251218-728 | MAIN | 7 | 4.51 | -31.60 | 301 | 1,358.59 | Nov. 2, 2025: 7 @ 4.51 |
| Dec. 16, 2025 | issue | SO-251216-927 | MAIN | 33 | 4.51 | -148.95 | 308 | 1,390.19 | Nov. 2, 2025: 33 @ 4.51 |
| Dec. 5, 2025 | return | RMA | MAIN | 2 | 4.51 | 9.03 | 341 | 1,539.14 | |
| Dec. 1, 2025 | issue | SO-251201-809 | MAIN | 5 | 4.51 | -22.57 | 339 | 1,530.11 | Nov. 2, 2025: 5 @ 4.51 |
| Nov. 10, 2025 | issue | SO-251110-520 | MAIN | 74 | 4.51 | -334.01 | 344 | 1,552.68 | Nov. 2, 2025: 74 @ 4.51 |
| Nov. 9, 2025 | issue | SO-251109-349 | MAIN | 77 | 4.47 | -344.42 | 418 | 1,886.68 | July 13, 2025: 45 @ 4.44; Nov. 2, 2025: 32 @ 4.51 |
| Nov. 8, 2025 | issue | SO-251108-923 | MAIN | 4 | 4.44 | -17.78 | 495 | 2,231.10 | July 13, 2025: 4 @ 4.44 |
| Nov. 2, 2025 | receipt | PO-000976 | MAIN | 450 | 4.51 | 2,031.12 | 499 | 2,248.88 | |
| Oct. 27, 2025 | issue | SO-251027-337 | MAIN | 85 | 4.44 | -377.75 | 49 | 217.76 | July 13, 2025: 85 @ 4.44 |
| Oct. 18, 2025 | issue | SO-251018-639 | MAIN | 62 | 4.44 | -275.53 | 134 | 595.51 | July 13, 2025: 62 @ 4.44 |
| Sept. 29, 2025 | issue | SO-250929-248 | MAIN | 47 | 4.44 | -208.87 | 196 | 871.04 | July 13, 2025: 47 @ 4.44 |
| Sept. 13, 2025 | issue | SO-250913-725 | MAIN | 70 | 4.44 | -311.09 | 243 | 1,079.92 | July 13, 2025: 70 @ 4.44 |
| Sept. 6, 2025 | issue | SO-250906-531 | MAIN | 5 | 4.44 | -22.22 | 313 | 1,391.00 | July 13, 2025: 5 @ 4.44 |
| Aug. 24, 2025 | issue | SO-250824-524 | MAIN | 31 | 4.44 | -137.77 | 318 | 1,413.22 | July 13, 2025: 31 @ 4.44 |
| Aug. 10, 2025 | issue | SO-250810-382 | MAIN | 91 | 4.44 | -404.41 | 349 | 1,550.99 | July 13, 2025: 91 @ 4.44 |
| July 24, 2025 | issue | SO-250724-958 | MAIN | 10 | 4.44 | -44.44 | 440 | 1,955.40 | July 13, 2025: 10 @ 4.44 |
| July 13, 2025 | receipt | PO-000706 | MAIN | 450 | 4.44 | 1,999.84 | 450 | 1,999.84 | |
| July 10, 2025 | issue | SO-250710-860 | MAIN | 14 | 4.57 | -64.04 | 0 | 0.00 | July 3, 2025: 14 @ 4.57 |
| July 5, 2025 | issue | SO-250705-846 | MAIN | 95 | 4.57 | -434.54 | 14 | 64.04 | April 5, 2025: 82 @ 4.57; July 3, 2025: 13 @ 4.57 |
| July 3, 2025 | return | RMA | MAIN | 27 | 4.57 | 123.50 | 109 | 498.58 | |
| June 28, 2025 | issue | SO-250628-424 | MAIN | 6 | 4.57 | -27.44 | 82 | 375.08 | April 5, 2025: 6 @ 4.57 |
| June 17, 2025 | issue | SO-250617-654 | MAIN | 12 | 4.57 | -54.89 | 88 | 402.52 | April 5, 2025: 12 @ 4.57 |
| June 13, 2025 | issue | SO-250613-279 | MAIN | 54 | 4.57 | -247.00 | 100 | 457.41 | April 5, 2025: 54 @ 4.57 |
| June 10, 2025 | issue | SO-250610-157 | MAIN | 30 | 4.57 | -137.22 | 154 | 704.41 | April 5, 2025: 30 @ 4.57 |
| June 3, 2025 | issue | SO-250603-242 | MAIN | 27 | 4.57 | -123.50 | 184 | 841.63 | April 5, 2025: 27 @ 4.57 |
| May 24, 2025 | issue | SO-250524-953 | MAIN | 150 | 4.57 | -686.12 | 211 | 965.14 | April 5, 2025: 150 @ 4.57 |
| May 18, 2025 | issue | SO-250518-725 | MAIN | 23 | 4.57 | -105.20 | 361 | 1,651.25 | April 5, 2025: 23 @ 4.57 |
| May 8, 2025 | issue | SO-250508-192 | MAIN | 30 | 4.57 | -137.22 | 384 | 1,756.45 | April 5, 2025: 30 @ 4.57 |
| April 14, 2025 | issue | SO-250414-975 | MAIN | 22 | 4.57 | -100.63 | 414 | 1,893.68 | April 5, 2025: 22 @ 4.57 |
| April 10, 2025 | issue | SO-250410-734 | MAIN | 3 | 4.57 | -13.72 | 436 | 1,994.31 | April 5, 2025: 3 @ 4.57 |
| April 9, 2025 | issue | SO-250409-971 | MAIN | 11 | 4.57 | -50.32 | 439 | 2,008.03 | April 5, 2025: 11 @ 4.57 |
| April 5, 2025 | receipt | PO-000416 | MAIN | 450 | 4.57 | 2,058.34 | 450 | 2,058.34 | |
| April 2, 2025 | issue | SO-250402-775 | MAIN | 17 | 4.30 | -73.18 | 0 | 0.00 | Dec. 26, 2024: 3 @ 4.30; Feb. 4, 2025: 14 @ 4.30 |
| March 30, 2025 | issue | SO-250330-285 | MAIN | 16 | 4.30 | -68.88 | 17 | 73.18 | Dec. 26, 2024: 16 @ 4.30 |
| March 29, 2025 | issue | SO-250329-568 | MAIN | 62 | 4.30 | -266.90 | 33 | 142.06 | Dec. 26, 2024: 62 @ 4.30 |
| March 21, 2025 | issue | SO-250321-478 | MAIN | 5 | 4.30 | -21.52 | 95 | 408.96 | Dec. 26, 2024: 5 @ 4.30 |
| March 13, 2025 | issue | SO-250313-273 | MAIN | 48 | 4.30 | -206.63 | 100 | 430.48 | Dec. 26, 2024: 48 @ 4.30 |
| March 13, 2025 | issue | SO-250313-273 | EAST | 5 | 4.30 | -21.52 | 148 | 637.11 | Dec. 26, 2024: 5 @ 4.30 |
| March 7, 2025 | issue | SO-250307-197 | MAIN | 3 | 4.30 | -12.91 | 153 | 658.63 | Dec. 26, 2024: 3 @ 4.30 |
| Feb. 28, 2025 | issue | SO-250228-339 | MAIN | 4 | 4.30 | -17.22 | 156 | 671.55 | Dec. 26, 2024: 4 @ 4.30 |
| Feb. 27, 2025 | issue | SO-250227-286 | MAIN | 35 | 4.30 | -150.67 | 160 | 688.77 | Dec. 26, 2024: 35 @ 4.30 |
| Feb. 16, 2025 | issue | SO-250216-119 | MAIN | 9 | 4.30 | -38.74 | 195 | 839.44 | Dec. 26, 2024: 9 @ 4.30 |
| Feb. 11, 2025 | issue | SO-250211-404 | EAST | 45 | 4.30 | -193.72 | 204 | 878.18 | Dec. 26, 2024: 45 @ 4.30 |
| Feb. 10, 2025 | issue | SO-250210-782 | MAIN | 98 | 4.30 | -421.87 | 249 | 1,071.90 | Dec. 26, 2024: 98 @ 4.30 |
| Feb. 4, 2025 | return | RMA | MAIN | 14 | 4.30 | 60.27 | 347 | 1,493.77 | |
| Jan. 24, 2025 | issue | SO-250124-998 | MAIN | 29 | 4.30 | -124.84 | 333 | 1,433.50 | Dec. 26, 2024: 29 @ 4.30 |
| Jan. 19, 2025 | issue | SO-250119-356 | MAIN | 11 | 4.30 | -47.35 | 362 | 1,558.34 | Dec. 26, 2024: 11 @ 4.30 |
| Jan. 16, 2025 | issue | SO-250116-417 | EAST | 91 | 4.34 | -394.91 | 373 | 1,605.69 | Dec. 23, 2024: 14 @ 4.53; Dec. 26, 2024: 77 @ 4.30 |
| Jan. 4, 2025 | issue | SO-250104-944 | MAIN | 5 | 4.53 | -22.66 | 464 | 2,000.60 | Dec. 23, 2024: 5 @ 4.53 |
| Dec. 30, 2024 | issue | SO-241230-216 | MAIN | 23 | 4.53 | -104.22 | 469 | 2,023.26 | Oct. 1, 2024: 20 @ 4.53; Dec. 23, 2024: 3 @ 4.53 |
| Dec. 28, 2024 | issue | SO-241228-603 | MAIN | 3 | 4.53 | -13.59 | 492 | 2,127.48 | Oct. 1, 2024: 3 @ 4.53 |
| Dec. 26, 2024 | transfer | TRF | MAIN → EAST | 141 | warehouse transfer, no cost effect | ||||
| Dec. 26, 2024 | receipt | PO-000139 | MAIN | 450 | 4.30 | 1,937.16 | 495 | 2,141.08 | |
| Dec. 24, 2024 | issue | SO-241224-816 | MAIN | 30 | 4.53 | -135.94 | 45 | 203.92 | Oct. 1, 2024: 30 @ 4.53 |
| Dec. 23, 2024 | return | RMA | MAIN | 22 | 4.53 | 99.69 | 75 | 339.86 | |
| Dec. 20, 2024 | issue | SO-241220-129 | MAIN | 45 | 4.53 | -203.92 | 53 | 240.17 | Oct. 1, 2024: 45 @ 4.53 |
| Dec. 16, 2024 | issue | SO-241216-931 | MAIN | 28 | 4.53 | -126.88 | 98 | 444.09 | Oct. 1, 2024: 28 @ 4.53 |
| Dec. 4, 2024 | issue | SO-241204-570 | MAIN | 60 | 4.53 | -271.89 | 126 | 570.97 | Oct. 1, 2024: 60 @ 4.53 |
| Nov. 28, 2024 | issue | SO-241128-701 | MAIN | 13 | 4.53 | -58.91 | 186 | 842.86 | Oct. 1, 2024: 13 @ 4.53 |
| Nov. 14, 2024 | issue | SO-241114-677 | MAIN | 9 | 4.53 | -40.78 | 199 | 901.77 | Oct. 1, 2024: 9 @ 4.53 |
| Nov. 12, 2024 | issue | SO-241112-272 | MAIN | 5 | 4.53 | -22.66 | 208 | 942.55 | Oct. 1, 2024: 5 @ 4.53 |
| Nov. 8, 2024 | issue | SO-241108-267 | MAIN | 22 | 4.53 | -99.69 | 213 | 965.21 | Oct. 1, 2024: 22 @ 4.53 |
| Nov. 5, 2024 | issue | SO-241105-246 | MAIN | 100 | 4.53 | -453.15 | 235 | 1,064.90 | Oct. 1, 2024: 100 @ 4.53 |
| Nov. 3, 2024 | issue | SO-241103-351 | MAIN | 1 | 4.53 | -4.53 | 335 | 1,518.05 | Oct. 1, 2024: 1 @ 4.53 |
| Oct. 31, 2024 | issue | SO-241031-873 | MAIN | 48 | 4.53 | -217.51 | 336 | 1,522.58 | Oct. 1, 2024: 48 @ 4.53 |
| Oct. 25, 2024 | issue | SO-241025-957 | MAIN | 20 | 4.53 | -90.63 | 384 | 1,740.10 | Oct. 1, 2024: 20 @ 4.53 |
| Oct. 8, 2024 | issue | SO-241008-198 | MAIN | 46 | 4.53 | -208.45 | 404 | 1,830.73 | Oct. 1, 2024: 46 @ 4.53 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 450 | 4.53 | 2,039.18 | 450 | 2,039.18 | |