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, latest 60 shown - show all
| 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 |