Items / SWT-0008
Socket 5-pin Pro SWT-0008 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)21MAIN 20, EAST 1
Value (FIFO)433.83avg 20.66
ClassBX / FCV 0.24
Turnover8.6xlast issue 1 days ago
Days of cover8lead time 7d
Reorder suggested: 220 units (position at or below reorder point: order EOQ), stockout risk medium.
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 | 84.42 / 30.4375 | 2.773 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 20.50 / 5.517 | 3.716 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(7.0 * 3.716^2 + 2.773^2 * 1.5^2) | 17.6 |
| Reorder point | d * LT + safety stock | 2.773 * 7.0 + 17.6 | 36.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 36.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1012/yr, S = 45.00, h = 20%, price = 21.47 | 145.7 |
| Inventory position | on hand + on order | 21 + 0 | 21 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 21.47 | 146 | 22,360 | yes (chosen if cheapest) |
MOQ 220, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 8, 2026 | 21 / 220 | 20.66 | 433.83 |
Movement ledger 129 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 | issue | SO-261015-684 | EAST | 75 | 20.66 | -1,549.41 | 21 | 433.83 | Aug. 8, 2026: 75 @ 20.66 |
| Oct. 9, 2026 | issue | SO-261009-878 | MAIN | 2 | 20.66 | -41.32 | 96 | 1,983.24 | Aug. 8, 2026: 2 @ 20.66 |
| Oct. 2, 2026 | issue | SO-261002-586 | MAIN | 6 | 20.66 | -123.95 | 98 | 2,024.56 | Aug. 8, 2026: 6 @ 20.66 |
| Sept. 21, 2026 | issue | SO-260921-984 | MAIN | 18 | 20.66 | -371.86 | 104 | 2,148.52 | Aug. 8, 2026: 18 @ 20.66 |
| Sept. 20, 2026 | issue | SO-260920-918 | MAIN | 3 | 20.66 | -61.98 | 122 | 2,520.37 | Aug. 8, 2026: 3 @ 20.66 |
| Sept. 19, 2026 | issue | SO-260919-713 | MAIN | 4 | 20.66 | -82.64 | 125 | 2,582.35 | Aug. 8, 2026: 4 @ 20.66 |
| Sept. 6, 2026 | issue | SO-260906-881 | MAIN | 57 | 20.66 | -1,177.55 | 129 | 2,664.99 | Aug. 8, 2026: 57 @ 20.66 |
| Sept. 1, 2026 | issue | SO-260901-582 | MAIN | 11 | 20.66 | -227.25 | 186 | 3,842.54 | Aug. 8, 2026: 11 @ 20.66 |
| Aug. 27, 2026 | issue | SO-260827-856 | MAIN | 55 | 21.15 | -1,163.05 | 197 | 4,069.78 | May 29, 2026: 32 @ 21.50; Aug. 8, 2026: 23 @ 20.66 |
| Aug. 8, 2026 | transfer | TRF | MAIN → EAST | 44 | warehouse transfer, no cost effect | ||||
| Aug. 8, 2026 | receipt | PO-001705 | MAIN | 220 | 20.66 | 4,544.94 | 252 | 5,232.83 | |
| Aug. 2, 2026 | issue | SO-260802-565 | EAST | 23 | 21.50 | -494.43 | 32 | 687.90 | May 29, 2026: 23 @ 21.50 |
| July 29, 2026 | issue | SO-260729-437 | EAST | 13 | 21.50 | -279.46 | 55 | 1,182.32 | May 29, 2026: 13 @ 21.50 |
| July 29, 2026 | issue | SO-260729-437 | MAIN | 9 | 21.50 | -193.47 | 68 | 1,461.78 | May 29, 2026: 9 @ 21.50 |
| July 27, 2026 | issue | SO-260727-694 | MAIN | 39 | 21.50 | -838.38 | 77 | 1,655.25 | May 29, 2026: 39 @ 21.50 |
| July 21, 2026 | issue | SO-260721-203 | MAIN | 3 | 21.50 | -64.49 | 116 | 2,493.63 | May 29, 2026: 3 @ 21.50 |
| July 18, 2026 | issue | SO-260718-840 | EAST | 7 | 21.50 | -150.48 | 119 | 2,558.12 | May 29, 2026: 7 @ 21.50 |
| July 8, 2026 | issue | SO-260708-609 | MAIN | 34 | 21.50 | -730.89 | 126 | 2,708.60 | May 29, 2026: 34 @ 21.50 |
| July 5, 2026 | issue | SO-260705-324 | MAIN | 7 | 21.50 | -150.48 | 160 | 3,439.49 | May 29, 2026: 7 @ 21.50 |
| June 25, 2026 | issue | SO-260625-735 | MAIN | 7 | 21.50 | -150.48 | 167 | 3,589.97 | May 29, 2026: 7 @ 21.50 |
| June 17, 2026 | issue | SO-260617-124 | EAST | 1 | 21.50 | -21.50 | 174 | 3,740.44 | May 29, 2026: 1 @ 21.50 |
| June 8, 2026 | issue | SO-260608-784 | MAIN | 1 | 21.50 | -21.50 | 175 | 3,761.94 | May 29, 2026: 1 @ 21.50 |
| June 4, 2026 | issue | SO-260604-391 | MAIN | 46 | 21.46 | -986.96 | 176 | 3,783.44 | Feb. 28, 2026: 2 @ 20.55; May 29, 2026: 44 @ 21.50 |
| June 2, 2026 | issue | SO-260602-182 | MAIN | 15 | 20.55 | -308.25 | 222 | 4,770.40 | Feb. 28, 2026: 15 @ 20.55 |
| May 29, 2026 | transfer | TRF | MAIN → EAST | 71 | warehouse transfer, no cost effect | ||||
| May 29, 2026 | receipt | PO-001531 | MAIN | 220 | 21.50 | 4,729.30 | 237 | 5,078.64 | |
| May 27, 2026 | issue | SO-260527-157 | MAIN | 9 | 20.55 | -184.95 | 17 | 349.35 | Feb. 28, 2026: 9 @ 20.55 |
| May 22, 2026 | issue | SO-260522-178 | MAIN | 16 | 20.55 | -328.80 | 26 | 534.29 | Feb. 28, 2026: 16 @ 20.55 |
| May 18, 2026 | issue | SO-260518-991 | MAIN | 79 | 20.55 | -1,623.43 | 42 | 863.09 | Feb. 28, 2026: 79 @ 20.55 |
| April 29, 2026 | issue | SO-260429-803 | MAIN | 3 | 20.55 | -61.65 | 121 | 2,486.53 | Feb. 28, 2026: 3 @ 20.55 |
| April 26, 2026 | issue | SO-260426-170 | EAST | 6 | 20.55 | -123.30 | 124 | 2,548.18 | Feb. 28, 2026: 6 @ 20.55 |
| April 25, 2026 | issue | SO-260425-716 | EAST | 19 | 20.55 | -390.45 | 130 | 2,671.47 | Feb. 28, 2026: 19 @ 20.55 |
| April 24, 2026 | issue | SO-260424-466 | MAIN | 19 | 20.55 | -390.45 | 149 | 3,061.92 | Feb. 28, 2026: 19 @ 20.55 |
| April 6, 2026 | issue | SO-260406-964 | EAST | 4 | 20.55 | -82.20 | 168 | 3,452.37 | Feb. 28, 2026: 4 @ 20.55 |
| April 4, 2026 | issue | SO-260404-412 | MAIN | 21 | 20.55 | -431.55 | 172 | 3,534.57 | Feb. 28, 2026: 21 @ 20.55 |
| March 25, 2026 | issue | SO-260325-117 | MAIN | 1 | 20.55 | -20.55 | 193 | 3,966.11 | Feb. 28, 2026: 1 @ 20.55 |
| March 22, 2026 | issue | SO-260322-530 | MAIN | 14 | 20.55 | -287.70 | 194 | 3,986.66 | Feb. 28, 2026: 14 @ 20.55 |
| March 20, 2026 | issue | SO-260320-510 | MAIN | 13 | 20.56 | -267.28 | 208 | 4,274.36 | Dec. 29, 2025: 1 @ 20.68; Feb. 28, 2026: 12 @ 20.55 |
| March 19, 2026 | issue | SO-260319-809 | MAIN | 4 | 20.68 | -82.71 | 221 | 4,541.63 | Dec. 29, 2025: 4 @ 20.68 |
| March 11, 2026 | issue | SO-260311-991 | EAST | 10 | 20.68 | -206.78 | 225 | 4,624.35 | Dec. 29, 2025: 10 @ 20.68 |
| March 4, 2026 | issue | SO-260304-257 | EAST | 12 | 20.68 | -248.14 | 235 | 4,831.13 | Dec. 29, 2025: 12 @ 20.68 |
| Feb. 28, 2026 | transfer | TRF | MAIN → EAST | 56 | warehouse transfer, no cost effect | ||||
| Feb. 28, 2026 | receipt | PO-001269 | MAIN | 220 | 20.55 | 4,520.96 | 247 | 5,079.28 | |
| Feb. 20, 2026 | issue | SO-260220-651 | MAIN | 74 | 20.68 | -1,530.21 | 27 | 558.32 | Dec. 29, 2025: 74 @ 20.68 |
| Feb. 9, 2026 | issue | SO-260209-241 | MAIN | 51 | 20.68 | -1,054.60 | 101 | 2,088.53 | Dec. 29, 2025: 51 @ 20.68 |
| Jan. 26, 2026 | issue | SO-260126-572 | MAIN | 10 | 20.68 | -206.78 | 152 | 3,143.13 | Dec. 29, 2025: 10 @ 20.68 |
| Jan. 18, 2026 | issue | SO-260118-996 | MAIN | 65 | 20.72 | -1,346.83 | 162 | 3,349.92 | Sept. 30, 2025: 3 @ 21.07; Nov. 22, 2025: 4 @ 21.07; Dec. 29, 2025: 58 @ 20.68 |
| Dec. 29, 2025 | receipt | PO-001101 | MAIN | 220 | 20.68 | 4,549.27 | 227 | 4,696.75 | |
| Dec. 26, 2025 | issue | SO-251226-963 | MAIN | 11 | 21.07 | -231.75 | 7 | 147.48 | Sept. 30, 2025: 11 @ 21.07 |
| Dec. 22, 2025 | issue | SO-251222-262 | MAIN | 6 | 21.07 | -126.41 | 18 | 379.23 | Sept. 30, 2025: 6 @ 21.07 |
| Dec. 21, 2025 | issue | SO-251221-984 | MAIN | 16 | 21.07 | -337.10 | 24 | 505.64 | Sept. 30, 2025: 16 @ 21.07 |
| Dec. 16, 2025 | issue | SO-251216-892 | MAIN | 6 | 21.07 | -126.41 | 40 | 842.74 | Sept. 30, 2025: 6 @ 21.07 |
| Dec. 11, 2025 | issue | SO-251211-367 | MAIN | 5 | 21.07 | -105.34 | 46 | 969.15 | Sept. 30, 2025: 5 @ 21.07 |
| Dec. 4, 2025 | issue | SO-251204-237 | MAIN | 13 | 21.07 | -273.89 | 51 | 1,074.49 | Sept. 30, 2025: 13 @ 21.07 |
| Nov. 22, 2025 | return | RMA | MAIN | 4 | 21.07 | 84.27 | 64 | 1,348.38 | |
| Nov. 18, 2025 | issue | SO-251118-389 | MAIN | 21 | 21.07 | -442.44 | 60 | 1,264.11 | Sept. 30, 2025: 21 @ 21.07 |
| Nov. 14, 2025 | issue | SO-251114-330 | MAIN | 8 | 21.07 | -168.55 | 81 | 1,706.55 | Sept. 30, 2025: 8 @ 21.07 |
| Nov. 9, 2025 | issue | SO-251109-178 | MAIN | 4 | 21.07 | -84.27 | 89 | 1,875.10 | Sept. 30, 2025: 4 @ 21.07 |
| Nov. 3, 2025 | issue | SO-251103-640 | MAIN | 30 | 21.07 | -632.06 | 93 | 1,959.37 | Sept. 30, 2025: 30 @ 21.07 |
| Nov. 3, 2025 | issue | SO-251103-640 | EAST | 28 | 21.07 | -589.92 | 123 | 2,591.43 | Sept. 30, 2025: 28 @ 21.07 |