Items / SWT-0014
Switch Plate 4M Classic SWT-0014 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)29MAIN 7, EAST 22
Value (FIFO)1,150.62avg 39.68
ClassAX / FCV 0.23
Turnover79.0xlast issue 0 days ago
Days of cover10lead time 7d
Reorder suggested: 290 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 | 91.67 / 30.4375 | 3.012 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 21.08 / 5.517 | 3.820 |
| 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 * 3.820^2 + 3.012^2 * 1.5^2) | 22.8 |
| Reorder point | d * LT + safety stock | 3.012 * 7.0 + 22.8 | 43.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 43.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1099/yr, S = 45.00, h = 20%, price = 40.25 | 110.9 |
| Inventory position | on hand + on order | 29 + 0 | 29 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 40.25 | 111 | 45,137 | yes (chosen if cheapest) |
MOQ 290, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 18, 2026 | 29 / 290 | 39.68 | 1,150.62 |
Movement ledger 131 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-230 | EAST | 10 | 39.68 | -396.76 | 29 | 1,150.62 | Aug. 18, 2026: 10 @ 39.68 |
| Oct. 14, 2026 | issue | SO-261014-410 | MAIN | 35 | 39.68 | -1,388.68 | 39 | 1,547.38 | Aug. 18, 2026: 35 @ 39.68 |
| Oct. 12, 2026 | issue | SO-261012-951 | MAIN | 38 | 39.68 | -1,507.71 | 74 | 2,936.06 | Aug. 18, 2026: 38 @ 39.68 |
| Oct. 11, 2026 | issue | SO-261011-557 | MAIN | 4 | 39.68 | -158.71 | 112 | 4,443.77 | Aug. 18, 2026: 4 @ 39.68 |
| Oct. 1, 2026 | issue | SO-261001-340 | MAIN | 6 | 39.68 | -238.06 | 116 | 4,602.47 | Aug. 18, 2026: 6 @ 39.68 |
| Sept. 27, 2026 | issue | SO-260927-849 | MAIN | 40 | 39.68 | -1,587.06 | 122 | 4,840.53 | Aug. 18, 2026: 40 @ 39.68 |
| Sept. 26, 2026 | issue | SO-260926-859 | MAIN | 18 | 39.68 | -714.18 | 162 | 6,427.59 | Aug. 18, 2026: 18 @ 39.68 |
| Sept. 19, 2026 | issue | SO-260919-893 | EAST | 6 | 39.68 | -238.06 | 180 | 7,141.77 | Aug. 18, 2026: 6 @ 39.68 |
| Sept. 16, 2026 | issue | SO-260916-348 | EAST | 50 | 39.68 | -1,983.82 | 186 | 7,379.83 | Aug. 18, 2026: 50 @ 39.68 |
| Sept. 13, 2026 | issue | SO-260913-743 | MAIN | 2 | 39.68 | -79.35 | 236 | 9,363.65 | Aug. 18, 2026: 2 @ 39.68 |
| Sept. 6, 2026 | issue | SO-260906-405 | MAIN | 2 | 39.68 | -79.35 | 238 | 9,443.01 | Aug. 18, 2026: 2 @ 39.68 |
| Aug. 19, 2026 | issue | SO-260819-316 | MAIN | 52 | 39.70 | -2,064.64 | 240 | 9,522.36 | May 7, 2026: 2 @ 40.41; Aug. 18, 2026: 50 @ 39.68 |
| Aug. 18, 2026 | transfer | TRF | MAIN → EAST | 88 | warehouse transfer, no cost effect | ||||
| Aug. 18, 2026 | receipt | PO-001727 | MAIN | 290 | 39.68 | 11,506.18 | 292 | 11,587.00 | |
| Aug. 12, 2026 | issue | SO-260812-552 | MAIN | 60 | 40.41 | -2,424.31 | 2 | 80.81 | May 7, 2026: 60 @ 40.41 |
| July 19, 2026 | issue | SO-260719-822 | MAIN | 39 | 40.41 | -1,575.80 | 62 | 2,505.12 | May 7, 2026: 39 @ 40.41 |
| July 18, 2026 | issue | SO-260718-284 | MAIN | 3 | 40.41 | -121.22 | 101 | 4,080.93 | May 7, 2026: 3 @ 40.41 |
| July 12, 2026 | issue | SO-260712-802 | MAIN | 15 | 40.41 | -606.08 | 104 | 4,202.14 | May 7, 2026: 15 @ 40.41 |
| July 10, 2026 | issue | SO-260710-618 | MAIN | 5 | 40.41 | -202.03 | 119 | 4,808.22 | May 7, 2026: 5 @ 40.41 |
| July 1, 2026 | issue | SO-260701-405 | MAIN | 49 | 40.41 | -1,979.85 | 124 | 5,010.24 | May 7, 2026: 49 @ 40.41 |
| June 30, 2026 | issue | SO-260630-969 | MAIN | 50 | 40.41 | -2,020.26 | 173 | 6,990.10 | May 7, 2026: 50 @ 40.41 |
| June 16, 2026 | issue | SO-260616-414 | MAIN | 29 | 40.41 | -1,171.75 | 223 | 9,010.36 | May 7, 2026: 29 @ 40.41 |
| May 24, 2026 | issue | SO-260524-339 | MAIN | 20 | 40.41 | -808.10 | 252 | 10,182.11 | May 7, 2026: 20 @ 40.41 |
| May 23, 2026 | issue | SO-260523-716 | MAIN | 47 | 39.33 | -1,848.42 | 272 | 10,990.21 | Feb. 9, 2026: 29 @ 38.66; May 7, 2026: 18 @ 40.41 |
| May 7, 2026 | receipt | PO-001473 | MAIN | 290 | 40.41 | 11,717.51 | 319 | 12,838.63 | |
| May 1, 2026 | issue | SO-260501-466 | MAIN | 35 | 38.66 | -1,353.08 | 29 | 1,121.12 | Feb. 9, 2026: 35 @ 38.66 |
| April 19, 2026 | issue | SO-260419-632 | MAIN | 8 | 38.66 | -309.28 | 64 | 2,474.20 | Feb. 9, 2026: 8 @ 38.66 |
| April 8, 2026 | issue | SO-260408-703 | MAIN | 15 | 38.66 | -579.89 | 72 | 2,783.48 | Feb. 9, 2026: 15 @ 38.66 |
| April 5, 2026 | issue | SO-260405-514 | MAIN | 12 | 38.66 | -463.91 | 87 | 3,363.37 | Feb. 9, 2026: 12 @ 38.66 |
| April 5, 2026 | issue | SO-260405-514 | EAST | 12 | 38.66 | -463.91 | 99 | 3,827.28 | Feb. 9, 2026: 12 @ 38.66 |
| April 2, 2026 | issue | SO-260402-845 | MAIN | 27 | 38.66 | -1,043.80 | 111 | 4,291.19 | Feb. 9, 2026: 27 @ 38.66 |
| March 29, 2026 | issue | SO-260329-338 | MAIN | 6 | 38.66 | -231.96 | 138 | 5,335.00 | Feb. 9, 2026: 6 @ 38.66 |
| March 19, 2026 | issue | SO-260319-285 | EAST | 24 | 38.66 | -927.83 | 144 | 5,566.95 | Feb. 9, 2026: 24 @ 38.66 |
| March 15, 2026 | issue | SO-260315-306 | MAIN | 12 | 38.66 | -463.91 | 168 | 6,494.78 | Feb. 9, 2026: 12 @ 38.66 |
| March 10, 2026 | issue | SO-260310-321 | MAIN | 17 | 38.66 | -657.21 | 180 | 6,958.69 | Feb. 9, 2026: 17 @ 38.66 |
| March 8, 2026 | issue | SO-260308-834 | MAIN | 6 | 38.66 | -231.96 | 197 | 7,615.90 | Feb. 9, 2026: 6 @ 38.66 |
| March 2, 2026 | issue | SO-260302-128 | MAIN | 3 | 38.66 | -115.98 | 203 | 7,847.86 | Feb. 9, 2026: 3 @ 38.66 |
| Feb. 27, 2026 | issue | SO-260227-664 | MAIN | 32 | 38.66 | -1,237.10 | 206 | 7,963.84 | Feb. 9, 2026: 32 @ 38.66 |
| Feb. 25, 2026 | issue | SO-260225-236 | EAST | 17 | 38.66 | -657.21 | 238 | 9,200.94 | Feb. 9, 2026: 17 @ 38.66 |
| Feb. 16, 2026 | issue | SO-260216-769 | EAST | 8 | 38.66 | -309.28 | 255 | 9,858.15 | Feb. 9, 2026: 8 @ 38.66 |
| Feb. 10, 2026 | issue | SO-260210-312 | MAIN | 68 | 38.53 | -2,619.76 | 263 | 10,167.42 | Oct. 17, 2025: 15 @ 38.44; Nov. 22, 2025: 26 @ 38.44; Feb. 9, 2026: 27 @ 38.66 |
| Feb. 9, 2026 | transfer | TRF | MAIN → EAST | 61 | warehouse transfer, no cost effect | ||||
| Feb. 9, 2026 | receipt | PO-001209 | MAIN | 290 | 38.66 | 11,211.23 | 331 | 12,787.18 | |
| Jan. 31, 2026 | issue | SO-260131-218 | MAIN | 17 | 38.44 | -653.44 | 41 | 1,575.95 | Oct. 17, 2025: 17 @ 38.44 |
| Jan. 25, 2026 | issue | SO-260125-734 | MAIN | 16 | 38.44 | -615.01 | 58 | 2,229.40 | Oct. 17, 2025: 16 @ 38.44 |
| Jan. 17, 2026 | issue | SO-260117-585 | MAIN | 13 | 38.44 | -499.69 | 74 | 2,844.40 | Oct. 17, 2025: 13 @ 38.44 |
| Jan. 14, 2026 | issue | SO-260114-795 | MAIN | 19 | 38.44 | -730.32 | 87 | 3,344.10 | Oct. 17, 2025: 19 @ 38.44 |
| Jan. 10, 2026 | issue | SO-260110-894 | MAIN | 1 | 38.44 | -38.44 | 106 | 4,074.42 | Oct. 17, 2025: 1 @ 38.44 |
| Jan. 6, 2026 | issue | SO-260106-658 | MAIN | 10 | 38.44 | -384.38 | 107 | 4,112.86 | Oct. 17, 2025: 10 @ 38.44 |
| Dec. 27, 2025 | issue | SO-251227-121 | MAIN | 19 | 38.44 | -730.32 | 117 | 4,497.23 | Oct. 17, 2025: 19 @ 38.44 |
| Dec. 26, 2025 | issue | SO-251226-255 | MAIN | 24 | 38.44 | -922.51 | 136 | 5,227.55 | Oct. 17, 2025: 24 @ 38.44 |
| Dec. 22, 2025 | issue | SO-251222-886 | MAIN | 23 | 38.44 | -884.07 | 160 | 6,150.06 | Oct. 17, 2025: 23 @ 38.44 |
| Dec. 4, 2025 | issue | SO-251204-913 | MAIN | 18 | 38.44 | -691.88 | 183 | 7,034.14 | Oct. 17, 2025: 18 @ 38.44 |
| Dec. 1, 2025 | issue | SO-251201-490 | MAIN | 17 | 38.44 | -653.44 | 201 | 7,726.02 | Oct. 17, 2025: 17 @ 38.44 |
| Nov. 22, 2025 | return | RMA | MAIN | 26 | 38.44 | 999.39 | 218 | 8,379.46 | |
| Nov. 19, 2025 | issue | SO-251119-267 | MAIN | 18 | 38.44 | -691.88 | 192 | 7,380.08 | Oct. 17, 2025: 18 @ 38.44 |
| Nov. 18, 2025 | issue | SO-251118-233 | MAIN | 4 | 38.44 | -153.75 | 210 | 8,071.96 | Oct. 17, 2025: 4 @ 38.44 |
| Nov. 16, 2025 | issue | SO-251116-414 | MAIN | 23 | 38.44 | -884.07 | 214 | 8,225.71 | Oct. 17, 2025: 23 @ 38.44 |
| Nov. 5, 2025 | issue | SO-251105-261 | MAIN | 53 | 38.44 | -2,037.21 | 237 | 9,109.78 | Oct. 17, 2025: 53 @ 38.44 |
| Oct. 17, 2025 | receipt | PO-000928 | MAIN | 290 | 38.44 | 11,146.99 | 290 | 11,146.99 | |