Items / SWT-0007
Socket 5-pin Classic SWT-0007 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)250MAIN 250
Value (FIFO)7,668.02avg 30.67
ClassAX / FCV 0.26
Turnover5.4xlast issue 3 days ago
Days of cover78lead 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 | 97.42 / 30.4375 | 3.201 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 25.00 / 5.517 | 4.531 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(7.0 * 4.531^2 + 3.201^2 * 1.5^2) | 26.6 |
| Reorder point | d * LT + safety stock | 3.201 * 7.0 + 26.6 | 48.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 48.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1168/yr, S = 45.00, h = 20%, price = 28.60 | 1000.0 |
| Inventory position | on hand + on order | 250 + 0 | 250 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 31.09 | 130 | 37,128 | yes |
| 500 | 29.85 | 500 | 36,464 | yes |
| 1,000 | 28.60 | 1,000 | 36,327 | yes (chosen if cheapest) |
MOQ 250, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 15, 2026 | 250 / 250 | 30.67 | 7,668.02 |
Movement ledger 116 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | receipt | PO-001882 | MAIN | 250 | 30.67 | 7,668.02 | 250 | 7,668.02 | |
| Oct. 13, 2026 | issue | SO-261013-855 | MAIN | 7 | 31.17 | -218.17 | 0 | 0.00 | Aug. 6, 2026: 7 @ 31.17 |
| Oct. 9, 2026 | issue | SO-261009-512 | MAIN | 38 | 31.17 | -1,184.35 | 7 | 218.17 | Aug. 6, 2026: 38 @ 31.17 |
| Oct. 5, 2026 | issue | SO-261005-403 | MAIN | 11 | 31.17 | -342.84 | 45 | 1,402.52 | Aug. 6, 2026: 11 @ 31.17 |
| Oct. 2, 2026 | issue | SO-261002-844 | MAIN | 9 | 31.17 | -280.50 | 56 | 1,745.35 | Aug. 6, 2026: 9 @ 31.17 |
| Sept. 28, 2026 | issue | SO-260928-510 | MAIN | 85 | 31.17 | -2,649.20 | 65 | 2,025.86 | Aug. 6, 2026: 85 @ 31.17 |
| Sept. 25, 2026 | issue | SO-260925-271 | MAIN | 10 | 31.17 | -311.67 | 150 | 4,675.05 | Aug. 6, 2026: 10 @ 31.17 |
| Sept. 21, 2026 | issue | SO-260921-690 | MAIN | 6 | 31.17 | -187.00 | 160 | 4,986.72 | Aug. 6, 2026: 6 @ 31.17 |
| Sept. 19, 2026 | issue | SO-260919-451 | MAIN | 33 | 31.17 | -1,028.51 | 166 | 5,173.72 | Aug. 6, 2026: 33 @ 31.17 |
| Aug. 29, 2026 | issue | SO-260829-693 | MAIN | 3 | 31.17 | -93.50 | 199 | 6,202.23 | Aug. 6, 2026: 3 @ 31.17 |
| Aug. 23, 2026 | issue | SO-260823-399 | MAIN | 8 | 31.17 | -249.34 | 202 | 6,295.73 | Aug. 6, 2026: 8 @ 31.17 |
| Aug. 22, 2026 | issue | SO-260822-489 | MAIN | 5 | 31.17 | -155.84 | 210 | 6,545.07 | Aug. 6, 2026: 5 @ 31.17 |
| Aug. 8, 2026 | issue | SO-260808-445 | MAIN | 35 | 31.17 | -1,090.84 | 215 | 6,700.90 | Aug. 6, 2026: 35 @ 31.17 |
| Aug. 6, 2026 | receipt | PO-001700 | MAIN | 250 | 31.17 | 7,791.75 | 250 | 7,791.75 | |
| July 29, 2026 | issue | SO-260729-223 | MAIN | 42 | 31.23 | -1,311.60 | 0 | 0.00 | April 29, 2026: 42 @ 31.23 |
| July 28, 2026 | issue | SO-260728-633 | MAIN | 46 | 31.23 | -1,436.51 | 42 | 1,311.60 | April 29, 2026: 46 @ 31.23 |
| July 25, 2026 | issue | SO-260725-808 | MAIN | 7 | 31.23 | -218.60 | 88 | 2,748.11 | April 29, 2026: 7 @ 31.23 |
| July 14, 2026 | issue | SO-260714-537 | MAIN | 25 | 31.23 | -780.71 | 95 | 2,966.71 | April 29, 2026: 25 @ 31.23 |
| June 25, 2026 | issue | SO-260625-593 | MAIN | 15 | 31.23 | -468.43 | 120 | 3,747.42 | April 29, 2026: 15 @ 31.23 |
| June 15, 2026 | issue | SO-260615-342 | MAIN | 4 | 31.23 | -124.91 | 135 | 4,215.85 | April 29, 2026: 4 @ 31.23 |
| June 14, 2026 | issue | SO-260614-428 | MAIN | 14 | 31.23 | -437.20 | 139 | 4,340.76 | April 29, 2026: 14 @ 31.23 |
| June 14, 2026 | issue | SO-260614-428 | EAST | 17 | 31.23 | -530.88 | 153 | 4,777.96 | April 29, 2026: 17 @ 31.23 |
| June 8, 2026 | issue | SO-260608-814 | MAIN | 11 | 31.23 | -343.51 | 170 | 5,308.84 | April 29, 2026: 11 @ 31.23 |
| June 7, 2026 | issue | SO-260607-791 | MAIN | 5 | 31.23 | -156.14 | 181 | 5,652.36 | April 29, 2026: 5 @ 31.23 |
| June 3, 2026 | issue | SO-260603-642 | MAIN | 8 | 31.23 | -249.83 | 186 | 5,808.50 | April 29, 2026: 8 @ 31.23 |
| May 20, 2026 | issue | SO-260520-692 | MAIN | 3 | 31.23 | -93.69 | 194 | 6,058.33 | April 29, 2026: 3 @ 31.23 |
| May 19, 2026 | issue | SO-260519-911 | MAIN | 13 | 31.23 | -405.97 | 197 | 6,152.01 | April 29, 2026: 13 @ 31.23 |
| May 11, 2026 | issue | SO-260511-793 | EAST | 63 | 31.07 | -1,957.29 | 210 | 6,557.98 | Jan. 30, 2026: 23 @ 30.79; April 29, 2026: 40 @ 31.23 |
| April 29, 2026 | transfer | TRF | MAIN → EAST | 80 | warehouse transfer, no cost effect | ||||
| April 29, 2026 | receipt | PO-001451 | MAIN | 250 | 31.23 | 7,807.12 | 273 | 8,515.27 | |
| April 22, 2026 | issue | SO-260422-485 | MAIN | 23 | 30.79 | -708.15 | 23 | 708.15 | Jan. 30, 2026: 23 @ 30.79 |
| April 19, 2026 | issue | SO-260419-506 | MAIN | 50 | 30.79 | -1,539.45 | 46 | 1,416.29 | Jan. 30, 2026: 50 @ 30.79 |
| April 12, 2026 | issue | SO-260412-274 | MAIN | 3 | 30.79 | -92.37 | 96 | 2,955.74 | Jan. 30, 2026: 3 @ 30.79 |
| April 12, 2026 | issue | SO-260412-274 | EAST | 16 | 30.79 | -492.62 | 99 | 3,048.11 | Jan. 30, 2026: 16 @ 30.79 |
| March 29, 2026 | issue | SO-260329-540 | MAIN | 3 | 30.79 | -92.37 | 115 | 3,540.74 | Jan. 30, 2026: 3 @ 30.79 |
| March 24, 2026 | issue | SO-260324-441 | EAST | 7 | 30.79 | -215.52 | 118 | 3,633.10 | Jan. 30, 2026: 7 @ 30.79 |
| March 23, 2026 | issue | SO-260323-850 | MAIN | 12 | 30.79 | -369.47 | 125 | 3,848.62 | Jan. 30, 2026: 12 @ 30.79 |
| March 16, 2026 | issue | SO-260316-990 | MAIN | 6 | 30.79 | -184.73 | 137 | 4,218.09 | Jan. 30, 2026: 6 @ 30.79 |
| March 5, 2026 | issue | SO-260305-241 | MAIN | 44 | 30.79 | -1,354.72 | 143 | 4,402.83 | Jan. 30, 2026: 44 @ 30.79 |
| Feb. 20, 2026 | issue | SO-260220-901 | EAST | 68 | 30.68 | -2,085.97 | 187 | 5,757.54 | Nov. 29, 2025: 5 @ 29.25; Jan. 30, 2026: 63 @ 30.79 |
| Feb. 19, 2026 | issue | SO-260219-134 | MAIN | 7 | 29.25 | -204.76 | 255 | 7,843.51 | Nov. 29, 2025: 7 @ 29.25 |
| Feb. 9, 2026 | issue | SO-260209-991 | MAIN | 9 | 29.25 | -263.27 | 262 | 8,048.27 | Nov. 29, 2025: 9 @ 29.25 |
| Jan. 30, 2026 | transfer | TRF | MAIN → EAST | 86 | warehouse transfer, no cost effect | ||||
| Jan. 30, 2026 | receipt | PO-001187 | MAIN | 250 | 30.79 | 7,697.25 | 271 | 8,311.54 | |
| Jan. 29, 2026 | issue | SO-260129-435 | MAIN | 9 | 29.25 | -263.27 | 21 | 614.29 | Nov. 29, 2025: 9 @ 29.25 |
| Jan. 24, 2026 | issue | SO-260124-566 | MAIN | 57 | 29.25 | -1,667.36 | 30 | 877.56 | Nov. 29, 2025: 57 @ 29.25 |
| Jan. 19, 2026 | issue | SO-260119-852 | MAIN | 16 | 29.25 | -468.03 | 87 | 2,544.92 | Nov. 29, 2025: 16 @ 29.25 |
| Jan. 17, 2026 | issue | SO-260117-475 | MAIN | 4 | 29.25 | -117.01 | 103 | 3,012.95 | Nov. 29, 2025: 4 @ 29.25 |
| Jan. 7, 2026 | issue | SO-260107-974 | MAIN | 38 | 29.25 | -1,111.57 | 107 | 3,129.95 | Nov. 29, 2025: 38 @ 29.25 |
| Jan. 2, 2026 | issue | SO-260102-949 | MAIN | 7 | 29.25 | -204.76 | 145 | 4,241.53 | Nov. 29, 2025: 7 @ 29.25 |
| Dec. 30, 2025 | issue | SO-251230-245 | MAIN | 12 | 29.25 | -351.02 | 152 | 4,446.29 | Nov. 29, 2025: 12 @ 29.25 |
| Dec. 29, 2025 | issue | SO-251229-240 | EAST | 67 | 29.25 | -1,959.88 | 164 | 4,797.31 | Nov. 29, 2025: 67 @ 29.25 |
| Dec. 25, 2025 | issue | SO-251225-751 | EAST | 1 | 29.25 | -29.25 | 231 | 6,757.19 | Nov. 29, 2025: 1 @ 29.25 |
| Dec. 18, 2025 | issue | SO-251218-365 | MAIN | 7 | 29.25 | -204.76 | 232 | 6,786.44 | Nov. 29, 2025: 7 @ 29.25 |
| Dec. 15, 2025 | issue | SO-251215-652 | MAIN | 12 | 29.25 | -351.02 | 239 | 6,991.20 | Sept. 10, 2025: 1 @ 29.25; Nov. 29, 2025: 11 @ 29.25 |
| Dec. 6, 2025 | issue | SO-251206-475 | MAIN | 5 | 29.25 | -146.26 | 251 | 7,342.23 | Sept. 10, 2025: 5 @ 29.25 |
| Nov. 29, 2025 | transfer | TRF | MAIN → EAST | 67 | warehouse transfer, no cost effect | ||||
| Nov. 29, 2025 | receipt | PO-001024 | MAIN | 250 | 29.25 | 7,312.98 | 256 | 7,488.49 | |
| Nov. 22, 2025 | issue | SO-251122-462 | EAST | 36 | 29.25 | -1,053.06 | 6 | 175.51 | Sept. 10, 2025: 36 @ 29.25 |
| Nov. 4, 2025 | issue | SO-251104-473 | EAST | 35 | 29.25 | -1,023.81 | 42 | 1,228.57 | Sept. 10, 2025: 35 @ 29.25 |