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
| 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 |
| Nov. 4, 2025 | issue | SO-251104-473 | MAIN | 39 | 29.25 | -1,140.82 | 77 | 2,252.38 | Sept. 10, 2025: 39 @ 29.25 |
| Oct. 23, 2025 | issue | SO-251023-929 | EAST | 4 | 29.25 | -117.01 | 116 | 3,393.20 | Sept. 10, 2025: 4 @ 29.25 |
| Oct. 22, 2025 | issue | SO-251022-743 | MAIN | 27 | 29.25 | -789.80 | 120 | 3,510.20 | Sept. 10, 2025: 27 @ 29.25 |
| Oct. 17, 2025 | issue | SO-251017-439 | MAIN | 50 | 29.25 | -1,462.58 | 147 | 4,300.00 | Sept. 10, 2025: 50 @ 29.25 |
| Oct. 11, 2025 | issue | SO-251011-610 | MAIN | 26 | 29.25 | -760.54 | 197 | 5,762.58 | Sept. 10, 2025: 26 @ 29.25 |
| Oct. 8, 2025 | issue | SO-251008-215 | MAIN | 8 | 29.25 | -234.01 | 223 | 6,523.13 | Sept. 10, 2025: 8 @ 29.25 |
| Oct. 2, 2025 | issue | SO-251002-309 | EAST | 3 | 29.25 | -87.76 | 231 | 6,757.14 | Sept. 10, 2025: 3 @ 29.25 |
| Sept. 23, 2025 | issue | SO-250923-259 | MAIN | 16 | 29.25 | -468.03 | 234 | 6,844.90 | Sept. 10, 2025: 16 @ 29.25 |
| Sept. 10, 2025 | transfer | TRF | MAIN → EAST | 84 | warehouse transfer, no cost effect | ||||
| Sept. 10, 2025 | receipt | PO-000828 | MAIN | 250 | 29.25 | 7,312.92 | 250 | 7,312.92 | |
| Sept. 8, 2025 | issue | SO-250908-213 | MAIN | 17 | 29.42 | -500.18 | 0 | 0.00 | June 24, 2025: 17 @ 29.42 |
| Sept. 2, 2025 | issue | SO-250902-103 | MAIN | 27 | 29.42 | -794.40 | 17 | 500.18 | June 24, 2025: 27 @ 29.42 |
| Aug. 30, 2025 | issue | SO-250830-461 | MAIN | 20 | 29.42 | -588.44 | 44 | 1,294.57 | June 24, 2025: 20 @ 29.42 |
| Aug. 13, 2025 | issue | SO-250813-409 | MAIN | 52 | 29.42 | -1,529.95 | 64 | 1,883.01 | June 24, 2025: 52 @ 29.42 |
| July 28, 2025 | issue | SO-250728-104 | MAIN | 19 | 29.42 | -559.02 | 116 | 3,412.96 | June 24, 2025: 19 @ 29.42 |
| July 6, 2025 | issue | SO-250706-529 | MAIN | 54 | 29.42 | -1,588.79 | 135 | 3,971.98 | June 24, 2025: 54 @ 29.42 |
| July 2, 2025 | issue | SO-250702-572 | MAIN | 75 | 29.44 | -2,208.25 | 189 | 5,560.78 | April 8, 2025: 14 @ 29.54; June 24, 2025: 61 @ 29.42 |
| June 28, 2025 | issue | SO-250628-305 | MAIN | 15 | 29.75 | -446.18 | 264 | 7,769.02 | March 29, 2025: 11 @ 29.82; April 8, 2025: 4 @ 29.54 |
| June 24, 2025 | receipt | PO-000662 | MAIN | 250 | 29.42 | 7,355.52 | 279 | 8,215.20 | |
| June 20, 2025 | issue | SO-250620-351 | MAIN | 7 | 29.82 | -208.75 | 29 | 859.68 | March 29, 2025: 7 @ 29.82 |
| June 19, 2025 | issue | SO-250619-688 | MAIN | 29 | 29.82 | -864.83 | 36 | 1,068.43 | March 29, 2025: 29 @ 29.82 |
| June 6, 2025 | issue | SO-250606-276 | MAIN | 18 | 29.82 | -536.79 | 65 | 1,933.26 | March 29, 2025: 18 @ 29.82 |
| June 4, 2025 | issue | SO-250604-388 | MAIN | 5 | 29.82 | -149.11 | 83 | 2,470.05 | March 29, 2025: 5 @ 29.82 |
| May 25, 2025 | issue | SO-250525-434 | MAIN | 17 | 29.82 | -506.97 | 88 | 2,619.16 | March 29, 2025: 17 @ 29.82 |
| May 22, 2025 | issue | SO-250522-401 | MAIN | 64 | 29.82 | -1,908.59 | 105 | 3,126.13 | March 29, 2025: 64 @ 29.82 |
| May 7, 2025 | issue | SO-250507-228 | MAIN | 18 | 29.82 | -536.79 | 169 | 5,034.72 | March 29, 2025: 18 @ 29.82 |
| April 25, 2025 | issue | SO-250425-491 | MAIN | 15 | 29.82 | -447.33 | 187 | 5,571.51 | March 29, 2025: 15 @ 29.82 |
| April 12, 2025 | issue | SO-250412-143 | MAIN | 37 | 29.82 | -1,103.40 | 202 | 6,018.83 | March 29, 2025: 37 @ 29.82 |
| April 10, 2025 | issue | SO-250410-579 | MAIN | 29 | 29.82 | -864.83 | 239 | 7,122.23 | March 29, 2025: 29 @ 29.82 |
| April 8, 2025 | return | RMA | MAIN | 18 | 29.54 | 531.64 | 268 | 7,987.06 | |
| April 2, 2025 | issue | SO-250402-990 | MAIN | 3 | 29.54 | -88.61 | 250 | 7,455.42 | Jan. 11, 2025: 3 @ 29.54 |
| March 29, 2025 | receipt | PO-000391 | MAIN | 250 | 29.82 | 7,455.42 | 253 | 7,544.03 | |
| March 25, 2025 | issue | SO-250325-110 | MAIN | 16 | 29.34 | -469.38 | 3 | 88.61 | Dec. 30, 2024: 13 @ 29.29; Jan. 11, 2025: 3 @ 29.54 |
| March 21, 2025 | issue | SO-250321-303 | MAIN | 36 | 29.29 | -1,054.44 | 19 | 557.98 | Dec. 30, 2024: 36 @ 29.29 |
| March 7, 2025 | issue | SO-250307-832 | MAIN | 25 | 29.29 | -732.25 | 55 | 1,612.42 | Dec. 30, 2024: 25 @ 29.29 |
| Feb. 24, 2025 | issue | SO-250224-669 | MAIN | 71 | 29.29 | -2,079.59 | 80 | 2,344.67 | Dec. 30, 2024: 71 @ 29.29 |
| Feb. 9, 2025 | issue | SO-250209-994 | MAIN | 1 | 29.29 | -29.29 | 151 | 4,424.26 | Dec. 30, 2024: 1 @ 29.29 |
| Jan. 22, 2025 | issue | SO-250122-198 | MAIN | 8 | 29.29 | -234.32 | 152 | 4,453.55 | Dec. 30, 2024: 8 @ 29.29 |
| Jan. 20, 2025 | issue | SO-250120-782 | MAIN | 66 | 29.29 | -1,933.14 | 160 | 4,687.87 | Dec. 30, 2024: 66 @ 29.29 |
| Jan. 12, 2025 | issue | SO-250112-305 | MAIN | 30 | 29.29 | -878.70 | 226 | 6,621.01 | Dec. 30, 2024: 30 @ 29.29 |
| Jan. 11, 2025 | return | RMA | MAIN | 6 | 29.54 | 177.21 | 256 | 7,499.71 | |
| Dec. 30, 2024 | receipt | PO-000151 | MAIN | 250 | 29.29 | 7,322.50 | 250 | 7,322.50 | |
| Dec. 28, 2024 | issue | SO-241228-214 | MAIN | 12 | 29.54 | -354.43 | 0 | 0.00 | Oct. 1, 2024: 12 @ 29.54 |
| Dec. 28, 2024 | issue | SO-241228-214 | EAST | 2 | 29.54 | -59.07 | 12 | 354.43 | Oct. 1, 2024: 2 @ 29.54 |
| Dec. 23, 2024 | issue | SO-241223-902 | EAST | 27 | 29.54 | -797.46 | 14 | 413.50 | Oct. 1, 2024: 27 @ 29.54 |
| Dec. 5, 2024 | issue | SO-241205-369 | EAST | 45 | 29.54 | -1,329.10 | 41 | 1,210.96 | Oct. 1, 2024: 45 @ 29.54 |
| Dec. 2, 2024 | issue | SO-241202-826 | EAST | 5 | 29.54 | -147.68 | 86 | 2,540.05 | Oct. 1, 2024: 5 @ 29.54 |
| Nov. 22, 2024 | issue | SO-241122-602 | MAIN | 39 | 29.54 | -1,151.88 | 91 | 2,687.73 | Oct. 1, 2024: 39 @ 29.54 |
| Nov. 14, 2024 | issue | SO-241114-852 | MAIN | 49 | 29.54 | -1,447.24 | 130 | 3,839.62 | Oct. 1, 2024: 49 @ 29.54 |
| Oct. 31, 2024 | issue | SO-241031-556 | MAIN | 52 | 29.54 | -1,535.85 | 179 | 5,286.85 | Oct. 1, 2024: 52 @ 29.54 |
| Oct. 13, 2024 | issue | SO-241013-626 | MAIN | 2 | 29.54 | -59.07 | 231 | 6,822.70 | Oct. 1, 2024: 2 @ 29.54 |
| Oct. 9, 2024 | issue | SO-241009-353 | MAIN | 1 | 29.54 | -29.54 | 233 | 6,881.77 | Oct. 1, 2024: 1 @ 29.54 |
| Oct. 7, 2024 | issue | SO-241007-798 | MAIN | 14 | 29.54 | -413.50 | 234 | 6,911.31 | Oct. 1, 2024: 14 @ 29.54 |
| Oct. 5, 2024 | issue | SO-241005-386 | MAIN | 2 | 29.54 | -59.07 | 248 | 7,324.80 | Oct. 1, 2024: 2 @ 29.54 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 79 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 250 | 29.54 | 7,383.88 | 250 | 7,383.88 | |