Items / SWT-0023
Socket 5-pin Classic SWT-0023 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)49MAIN 30, EAST 19
Value (FIFO)2,032.45avg 41.48
ClassBX / FCV 0.19
Turnover11.1xlast issue 6 days ago
Days of cover31lead 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 | 48.58 / 30.4375 | 1.596 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.02 / 5.517 | 1.635 |
| 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 * 1.635^2 + 1.596^2 * 1.5^2) | 8.2 |
| Reorder point | d * LT + safety stock | 1.596 * 7.0 + 8.2 | 19.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 19.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 583/yr, S = 45.00, h = 20%, price = 42.84 | 78.2 |
| Inventory position | on hand + on order | 49 + 0 | 49 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 42.84 | 78 | 25,629 | yes (chosen if cheapest) |
MOQ 150, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 29, 2026 | 45 / 150 | 41.48 | 1,866.53 | |
| Sept. 23, 2026 | 4 / 4 | 41.48 | 165.91 |
Movement ledger 126 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 10, 2026 | issue | SO-261010-484 | MAIN | 1 | 41.48 | -41.48 | 49 | 2,032.45 | Aug. 29, 2026: 1 @ 41.48 |
| Oct. 8, 2026 | issue | SO-261008-315 | MAIN | 16 | 41.48 | -663.66 | 50 | 2,073.92 | Aug. 29, 2026: 16 @ 41.48 |
| Oct. 5, 2026 | issue | SO-261005-530 | EAST | 1 | 41.48 | -41.48 | 66 | 2,737.58 | Aug. 29, 2026: 1 @ 41.48 |
| Oct. 4, 2026 | issue | SO-261004-756 | EAST | 15 | 41.48 | -622.18 | 67 | 2,779.06 | Aug. 29, 2026: 15 @ 41.48 |
| Oct. 2, 2026 | issue | SO-261002-465 | MAIN | 7 | 41.48 | -290.35 | 82 | 3,401.24 | Aug. 29, 2026: 7 @ 41.48 |
| Sept. 23, 2026 | return | RMA | MAIN | 4 | 41.48 | 165.91 | 89 | 3,691.59 | |
| Sept. 22, 2026 | issue | SO-260922-213 | MAIN | 17 | 41.48 | -705.13 | 85 | 3,525.67 | Aug. 29, 2026: 17 @ 41.48 |
| Sept. 17, 2026 | issue | SO-260917-813 | MAIN | 14 | 41.48 | -580.70 | 102 | 4,230.81 | Aug. 29, 2026: 14 @ 41.48 |
| Sept. 6, 2026 | issue | SO-260906-738 | MAIN | 9 | 41.48 | -373.31 | 116 | 4,811.51 | Aug. 29, 2026: 9 @ 41.48 |
| Sept. 3, 2026 | issue | SO-260903-425 | EAST | 5 | 41.48 | -207.39 | 125 | 5,184.81 | Aug. 29, 2026: 5 @ 41.48 |
| Sept. 1, 2026 | issue | SO-260901-921 | MAIN | 10 | 41.48 | -414.78 | 130 | 5,392.20 | Aug. 29, 2026: 10 @ 41.48 |
| Aug. 31, 2026 | issue | SO-260831-503 | EAST | 10 | 41.48 | -414.78 | 140 | 5,806.99 | Aug. 29, 2026: 10 @ 41.48 |
| Aug. 29, 2026 | transfer | TRF | MAIN → EAST | 50 | warehouse transfer, no cost effect | ||||
| Aug. 29, 2026 | receipt | PO-001759 | MAIN | 150 | 41.48 | 6,221.78 | 150 | 6,221.78 | |
| Aug. 27, 2026 | issue | SO-260827-151 | MAIN | 18 | 43.02 | -774.43 | 0 | 0.00 | May 23, 2026: 18 @ 43.02 |
| Aug. 24, 2026 | issue | SO-260824-705 | MAIN | 8 | 43.02 | -344.19 | 18 | 774.43 | May 23, 2026: 8 @ 43.02 |
| Aug. 18, 2026 | issue | SO-260818-801 | MAIN | 1 | 43.02 | -43.02 | 26 | 1,118.63 | May 23, 2026: 1 @ 43.02 |
| Aug. 5, 2026 | issue | SO-260805-725 | MAIN | 3 | 43.02 | -129.07 | 27 | 1,161.65 | May 23, 2026: 3 @ 43.02 |
| July 31, 2026 | issue | SO-260731-217 | MAIN | 19 | 43.02 | -817.46 | 30 | 1,290.72 | May 23, 2026: 19 @ 43.02 |
| July 29, 2026 | issue | SO-260729-466 | MAIN | 7 | 43.02 | -301.17 | 49 | 2,108.18 | May 23, 2026: 7 @ 43.02 |
| July 10, 2026 | issue | SO-260710-593 | MAIN | 2 | 43.02 | -86.05 | 56 | 2,409.35 | May 23, 2026: 2 @ 43.02 |
| July 5, 2026 | issue | SO-260705-775 | MAIN | 4 | 43.02 | -172.10 | 58 | 2,495.40 | May 23, 2026: 4 @ 43.02 |
| July 4, 2026 | issue | SO-260704-341 | MAIN | 8 | 43.02 | -344.19 | 62 | 2,667.49 | May 23, 2026: 8 @ 43.02 |
| July 3, 2026 | issue | SO-260703-114 | MAIN | 3 | 43.02 | -129.07 | 70 | 3,011.69 | May 23, 2026: 3 @ 43.02 |
| June 5, 2026 | issue | SO-260605-806 | MAIN | 8 | 43.02 | -344.19 | 73 | 3,140.76 | May 23, 2026: 8 @ 43.02 |
| June 4, 2026 | issue | SO-260604-328 | MAIN | 1 | 43.02 | -43.02 | 81 | 3,484.95 | May 23, 2026: 1 @ 43.02 |
| June 3, 2026 | issue | SO-260603-531 | MAIN | 52 | 43.02 | -2,237.25 | 82 | 3,527.98 | May 23, 2026: 52 @ 43.02 |
| May 30, 2026 | issue | SO-260530-956 | MAIN | 8 | 43.02 | -344.19 | 134 | 5,765.23 | May 23, 2026: 8 @ 43.02 |
| May 26, 2026 | issue | SO-260526-608 | MAIN | 8 | 43.02 | -344.19 | 142 | 6,109.42 | May 23, 2026: 8 @ 43.02 |
| May 23, 2026 | receipt | PO-001517 | MAIN | 150 | 43.02 | 6,453.62 | 150 | 6,453.62 | |
| May 19, 2026 | issue | SO-260519-270 | MAIN | 9 | 41.51 | -373.59 | 0 | 0.00 | March 5, 2026: 9 @ 41.51 |
| May 17, 2026 | issue | SO-260517-137 | MAIN | 25 | 41.51 | -1,037.75 | 9 | 373.59 | March 5, 2026: 25 @ 41.51 |
| May 11, 2026 | issue | SO-260511-340 | MAIN | 2 | 41.51 | -83.02 | 34 | 1,411.34 | March 5, 2026: 2 @ 41.51 |
| April 28, 2026 | issue | SO-260428-274 | MAIN | 1 | 41.51 | -41.51 | 36 | 1,494.36 | March 5, 2026: 1 @ 41.51 |
| April 15, 2026 | issue | SO-260415-520 | MAIN | 32 | 41.51 | -1,328.32 | 37 | 1,535.87 | March 5, 2026: 32 @ 41.51 |
| April 12, 2026 | issue | SO-260412-855 | MAIN | 19 | 41.51 | -788.69 | 69 | 2,864.19 | March 5, 2026: 19 @ 41.51 |
| April 5, 2026 | issue | SO-260405-877 | MAIN | 14 | 41.51 | -581.14 | 88 | 3,652.88 | March 5, 2026: 14 @ 41.51 |
| March 30, 2026 | issue | SO-260330-516 | MAIN | 35 | 41.51 | -1,452.85 | 102 | 4,234.02 | March 5, 2026: 35 @ 41.51 |
| March 27, 2026 | issue | SO-260327-894 | MAIN | 6 | 41.51 | -249.06 | 137 | 5,686.87 | March 5, 2026: 6 @ 41.51 |
| March 10, 2026 | issue | SO-260310-602 | MAIN | 7 | 41.51 | -290.57 | 143 | 5,935.93 | March 5, 2026: 7 @ 41.51 |
| March 5, 2026 | receipt | PO-001288 | MAIN | 150 | 41.51 | 6,226.50 | 150 | 6,226.50 | |
| Feb. 28, 2026 | issue | SO-260228-786 | EAST | 13 | 41.95 | -545.39 | 0 | 0.00 | Nov. 11, 2025: 12 @ 41.98; Nov. 11, 2025: 1 @ 41.57 |
| Feb. 28, 2026 | issue | SO-260228-786 | MAIN | 21 | 41.98 | -881.68 | 13 | 545.39 | Nov. 11, 2025: 21 @ 41.98 |
| Feb. 13, 2026 | issue | SO-260213-673 | MAIN | 12 | 41.98 | -503.82 | 34 | 1,427.07 | Nov. 11, 2025: 12 @ 41.98 |
| Jan. 27, 2026 | issue | SO-260127-669 | EAST | 4 | 41.98 | -167.94 | 46 | 1,930.89 | Nov. 11, 2025: 4 @ 41.98 |
| Jan. 23, 2026 | issue | SO-260123-180 | EAST | 10 | 41.98 | -419.85 | 50 | 2,098.83 | Nov. 11, 2025: 10 @ 41.98 |
| Jan. 22, 2026 | issue | SO-260122-190 | MAIN | 3 | 41.98 | -125.95 | 60 | 2,518.68 | Nov. 11, 2025: 3 @ 41.98 |
| Jan. 18, 2026 | issue | SO-260118-327 | MAIN | 14 | 41.98 | -587.79 | 63 | 2,644.63 | Nov. 11, 2025: 14 @ 41.98 |
| Jan. 10, 2026 | issue | SO-260110-857 | MAIN | 13 | 41.98 | -545.80 | 77 | 3,232.42 | Nov. 11, 2025: 13 @ 41.98 |
| Jan. 9, 2026 | issue | SO-260109-680 | EAST | 6 | 41.98 | -251.91 | 90 | 3,778.22 | Nov. 11, 2025: 6 @ 41.98 |
| Dec. 26, 2025 | issue | SO-251226-572 | EAST | 17 | 41.98 | -713.74 | 96 | 4,030.13 | Nov. 11, 2025: 17 @ 41.98 |
| Dec. 24, 2025 | issue | SO-251224-856 | MAIN | 7 | 41.98 | -293.89 | 113 | 4,743.87 | Nov. 11, 2025: 7 @ 41.98 |
| Dec. 22, 2025 | issue | SO-251222-221 | MAIN | 12 | 41.98 | -503.82 | 120 | 5,037.76 | Nov. 11, 2025: 12 @ 41.98 |
| Dec. 16, 2025 | issue | SO-251216-567 | MAIN | 4 | 41.98 | -167.94 | 132 | 5,541.58 | Nov. 11, 2025: 4 @ 41.98 |
| Dec. 11, 2025 | issue | SO-251211-680 | MAIN | 3 | 41.98 | -125.95 | 136 | 5,709.52 | Nov. 11, 2025: 3 @ 41.98 |
| Dec. 8, 2025 | issue | SO-251208-289 | MAIN | 4 | 41.98 | -167.94 | 139 | 5,835.48 | Nov. 11, 2025: 4 @ 41.98 |
| Dec. 4, 2025 | issue | SO-251204-358 | MAIN | 8 | 41.98 | -335.88 | 143 | 6,003.42 | Nov. 11, 2025: 8 @ 41.98 |
| Nov. 11, 2025 | return | RMA | MAIN | 1 | 41.57 | 41.57 | 151 | 6,339.29 | |
| Nov. 11, 2025 | transfer | TRF | MAIN → EAST | 50 | warehouse transfer, no cost effect | ||||
| Nov. 11, 2025 | receipt | PO-000995 | MAIN | 150 | 41.98 | 6,297.72 | 150 | 6,297.72 | |