Items / SWT-0015
Socket 5-pin Flex SWT-0015 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)289MAIN 289
Value (FIFO)1,530.63avg 5.30
ClassCX / FCV 0.22
Turnover5.4xlast issue 4 days ago
Days of cover75lead 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 | 117.50 / 30.4375 | 3.860 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 25.82 / 5.517 | 4.681 |
| 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 * 4.681^2 + 3.860^2 * 1.5^2) | 17.6 |
| Reorder point | d * LT + safety stock | 3.860 * 7.0 + 17.6 | 44.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 44.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1409/yr, S = 45.00, h = 20%, price = 5.10 | 760.0 |
| Inventory position | on hand + on order | 289 + 0 | 289 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 5.31 | 346 | 7,849 | yes |
| 760 | 5.10 | 760 | 7,654 | yes (chosen if cheapest) |
| 1,520 | 4.89 | 1,520 | 7,668 | yes |
MOQ 380, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 10, 2026 | 289 / 380 | 5.30 | 1,530.63 |
Movement ledger 130 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-431 | MAIN | 129 | 5.26 | -678.97 | 289 | 1,530.63 | July 19, 2026: 24 @ 5.18; July 27, 2026: 1 @ 5.17; Sept. 5, 2026: 13 @ 5.18; Oct. 10, 2026: 91 @ 5.30 |
| Oct. 10, 2026 | receipt | PO-001865 | MAIN | 380 | 5.30 | 2,012.59 | 418 | 2,209.60 | |
| Oct. 7, 2026 | issue | SO-261007-441 | MAIN | 14 | 5.18 | -72.59 | 38 | 197.01 | July 19, 2026: 14 @ 5.18 |
| Sept. 30, 2026 | issue | SO-260930-235 | MAIN | 22 | 5.18 | -114.07 | 52 | 269.60 | July 19, 2026: 22 @ 5.18 |
| Sept. 5, 2026 | return | RMA | MAIN | 13 | 5.18 | 67.40 | 74 | 383.67 | |
| Sept. 4, 2026 | issue | SO-260904-849 | MAIN | 78 | 5.18 | -404.42 | 61 | 316.26 | July 19, 2026: 78 @ 5.18 |
| Sept. 2, 2026 | issue | SO-260902-848 | MAIN | 12 | 5.18 | -62.22 | 139 | 720.69 | July 19, 2026: 12 @ 5.18 |
| Aug. 31, 2026 | issue | SO-260831-800 | MAIN | 10 | 5.18 | -51.85 | 151 | 782.90 | July 19, 2026: 10 @ 5.18 |
| Aug. 27, 2026 | issue | SO-260827-444 | MAIN | 27 | 5.18 | -139.99 | 161 | 834.75 | July 19, 2026: 27 @ 5.18 |
| Aug. 25, 2026 | issue | SO-260825-204 | MAIN | 10 | 5.18 | -51.85 | 188 | 974.75 | July 19, 2026: 10 @ 5.18 |
| Aug. 23, 2026 | issue | SO-260823-581 | MAIN | 31 | 5.18 | -160.73 | 198 | 1,026.59 | July 19, 2026: 31 @ 5.18 |
| Aug. 20, 2026 | issue | SO-260820-799 | MAIN | 15 | 5.18 | -77.77 | 229 | 1,187.33 | July 19, 2026: 15 @ 5.18 |
| Aug. 19, 2026 | issue | SO-260819-988 | MAIN | 28 | 5.18 | -145.18 | 244 | 1,265.10 | July 19, 2026: 28 @ 5.18 |
| Aug. 12, 2026 | issue | SO-260812-100 | MAIN | 14 | 5.18 | -72.59 | 272 | 1,410.28 | July 19, 2026: 14 @ 5.18 |
| July 31, 2026 | issue | SO-260731-290 | MAIN | 47 | 5.18 | -243.69 | 286 | 1,482.87 | July 19, 2026: 47 @ 5.18 |
| July 27, 2026 | return | RMA | MAIN | 1 | 5.17 | 5.17 | 333 | 1,726.56 | |
| July 26, 2026 | issue | SO-260726-692 | MAIN | 80 | 5.17 | -413.56 | 332 | 1,721.39 | April 5, 2026: 32 @ 5.15; July 19, 2026: 48 @ 5.18 |
| July 23, 2026 | issue | SO-260723-235 | MAIN | 24 | 5.15 | -123.51 | 412 | 2,134.94 | April 5, 2026: 24 @ 5.15 |
| July 19, 2026 | receipt | PO-001656 | MAIN | 380 | 5.18 | 1,970.26 | 436 | 2,258.45 | |
| July 15, 2026 | issue | SO-260715-117 | MAIN | 2 | 5.15 | -10.29 | 56 | 288.19 | April 5, 2026: 2 @ 5.15 |
| July 11, 2026 | issue | SO-260711-152 | MAIN | 14 | 5.15 | -72.05 | 58 | 298.49 | April 5, 2026: 14 @ 5.15 |
| July 11, 2026 | issue | SO-260711-152 | EAST | 11 | 5.15 | -56.61 | 72 | 370.53 | April 5, 2026: 11 @ 5.15 |
| June 27, 2026 | issue | SO-260627-959 | MAIN | 32 | 5.15 | -164.68 | 83 | 427.14 | April 5, 2026: 32 @ 5.15 |
| June 25, 2026 | issue | SO-260625-483 | MAIN | 56 | 5.15 | -288.19 | 115 | 591.82 | April 5, 2026: 56 @ 5.15 |
| June 5, 2026 | issue | SO-260605-337 | MAIN | 13 | 5.15 | -66.90 | 171 | 880.02 | April 5, 2026: 13 @ 5.15 |
| May 23, 2026 | issue | SO-260523-688 | MAIN | 25 | 5.15 | -128.66 | 184 | 946.92 | April 5, 2026: 25 @ 5.15 |
| May 22, 2026 | issue | SO-260522-794 | EAST | 18 | 5.15 | -92.63 | 209 | 1,075.58 | April 5, 2026: 18 @ 5.15 |
| May 19, 2026 | issue | SO-260519-793 | EAST | 51 | 5.15 | -262.46 | 227 | 1,168.21 | April 5, 2026: 51 @ 5.15 |
| May 5, 2026 | issue | SO-260505-243 | MAIN | 37 | 5.15 | -190.41 | 278 | 1,430.67 | April 5, 2026: 37 @ 5.15 |
| April 19, 2026 | issue | SO-260419-172 | EAST | 38 | 5.15 | -195.56 | 315 | 1,621.08 | April 5, 2026: 38 @ 5.15 |
| April 11, 2026 | issue | SO-260411-226 | MAIN | 1 | 5.15 | -5.15 | 353 | 1,816.64 | April 5, 2026: 1 @ 5.15 |
| April 10, 2026 | issue | SO-260410-628 | MAIN | 54 | 5.15 | -278.02 | 354 | 1,821.79 | Jan. 4, 2026: 28 @ 5.15; April 5, 2026: 26 @ 5.15 |
| April 5, 2026 | transfer | TRF | MAIN → EAST | 118 | warehouse transfer, no cost effect | ||||
| April 5, 2026 | receipt | PO-001387 | MAIN | 380 | 5.15 | 1,955.59 | 408 | 2,099.81 | |
| March 30, 2026 | issue | SO-260330-875 | MAIN | 30 | 5.15 | -154.52 | 28 | 144.22 | Jan. 4, 2026: 30 @ 5.15 |
| March 29, 2026 | issue | SO-260329-626 | MAIN | 50 | 5.15 | -257.54 | 58 | 298.74 | Jan. 4, 2026: 50 @ 5.15 |
| March 29, 2026 | issue | SO-260329-626 | EAST | 10 | 5.15 | -51.51 | 108 | 556.28 | Jan. 4, 2026: 10 @ 5.15 |
| March 26, 2026 | issue | SO-260326-547 | EAST | 3 | 5.15 | -15.45 | 118 | 607.78 | Jan. 4, 2026: 3 @ 5.15 |
| March 16, 2026 | issue | SO-260316-668 | EAST | 3 | 5.15 | -15.45 | 121 | 623.23 | Jan. 4, 2026: 3 @ 5.15 |
| March 8, 2026 | issue | SO-260308-390 | EAST | 5 | 5.15 | -25.75 | 124 | 638.69 | Jan. 4, 2026: 5 @ 5.15 |
| March 7, 2026 | issue | SO-260307-123 | EAST | 30 | 5.15 | -154.52 | 129 | 664.44 | Jan. 4, 2026: 30 @ 5.15 |
| March 4, 2026 | issue | SO-260304-601 | MAIN | 4 | 5.15 | -20.60 | 159 | 818.96 | Jan. 4, 2026: 4 @ 5.15 |
| Feb. 28, 2026 | issue | SO-260228-389 | EAST | 24 | 5.15 | -123.62 | 163 | 839.56 | Jan. 4, 2026: 24 @ 5.15 |
| Feb. 21, 2026 | issue | SO-260221-753 | MAIN | 9 | 5.15 | -46.36 | 187 | 963.18 | Jan. 4, 2026: 9 @ 5.15 |
| Feb. 15, 2026 | issue | SO-260215-723 | MAIN | 13 | 5.15 | -66.96 | 196 | 1,009.54 | Jan. 4, 2026: 13 @ 5.15 |
| Feb. 14, 2026 | issue | SO-260214-601 | MAIN | 44 | 5.15 | -226.63 | 209 | 1,076.50 | Jan. 4, 2026: 44 @ 5.15 |
| Feb. 1, 2026 | issue | SO-260201-611 | EAST | 49 | 5.15 | -252.38 | 253 | 1,303.13 | Jan. 4, 2026: 49 @ 5.15 |
| Jan. 28, 2026 | issue | SO-260128-699 | MAIN | 48 | 5.15 | -247.23 | 302 | 1,555.51 | Jan. 4, 2026: 48 @ 5.15 |
| Jan. 26, 2026 | issue | SO-260126-984 | MAIN | 1 | 5.15 | -5.15 | 350 | 1,802.74 | Jan. 4, 2026: 1 @ 5.15 |
| Jan. 9, 2026 | issue | SO-260109-287 | EAST | 3 | 5.15 | -15.45 | 351 | 1,807.90 | Jan. 4, 2026: 3 @ 5.15 |
| Jan. 6, 2026 | issue | SO-260106-630 | EAST | 4 | 5.15 | -20.60 | 354 | 1,823.35 | Jan. 4, 2026: 4 @ 5.15 |
| Jan. 4, 2026 | issue | SO-260104-578 | MAIN | 22 | 5.15 | -113.32 | 358 | 1,843.95 | Jan. 4, 2026: 22 @ 5.15 |
| Jan. 4, 2026 | transfer | TRF | MAIN → EAST | 131 | warehouse transfer, no cost effect | ||||
| Jan. 4, 2026 | receipt | PO-001120 | MAIN | 380 | 5.15 | 1,957.27 | 380 | 1,957.27 | |
| Dec. 31, 2025 | issue | SO-251231-113 | MAIN | 56 | 5.02 | -280.92 | 0 | 0.00 | Sept. 16, 2025: 56 @ 5.02 |
| Dec. 31, 2025 | issue | SO-251231-113 | EAST | 40 | 5.02 | -200.66 | 56 | 280.92 | Sept. 16, 2025: 40 @ 5.02 |
| Dec. 17, 2025 | issue | SO-251217-750 | EAST | 20 | 5.02 | -100.33 | 96 | 481.58 | Sept. 16, 2025: 20 @ 5.02 |
| Nov. 30, 2025 | issue | SO-251130-289 | EAST | 16 | 5.02 | -80.26 | 116 | 581.91 | Sept. 16, 2025: 16 @ 5.02 |
| Nov. 29, 2025 | issue | SO-251129-404 | MAIN | 4 | 5.02 | -20.07 | 132 | 662.18 | Sept. 16, 2025: 4 @ 5.02 |
| Nov. 21, 2025 | issue | SO-251121-130 | EAST | 9 | 5.02 | -45.15 | 136 | 682.24 | Sept. 16, 2025: 9 @ 5.02 |