Items / SWT-0032
Modular Switch 16A Prime SWT-0032 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)105MAIN 105
Value (FIFO)4,089.68avg 38.95
ClassAX / FCV 0.23
Turnover5.2xlast issue 0 days ago
Days of cover48lead 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 | 66.42 / 30.4375 | 2.182 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 15.20 / 5.517 | 2.754 |
| 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 * 2.754^2 + 2.182^2 * 1.5^2) | 16.5 |
| Reorder point | d * LT + safety stock | 2.182 * 7.0 + 16.5 | 31.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 31.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 796/yr, S = 45.00, h = 20%, price = 38.50 | 96.5 |
| Inventory position | on hand + on order | 105 + 0 | 105 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 38.50 | 96 | 31,406 | yes (chosen if cheapest) |
MOQ 240, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 22, 2026 | 105 / 240 | 38.95 | 4,089.68 |
Movement ledger 130 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-610 | MAIN | 17 | 38.95 | -662.14 | 105 | 4,089.68 | Aug. 22, 2026: 17 @ 38.95 |
| Oct. 12, 2026 | issue | SO-261012-175 | MAIN | 49 | 38.95 | -1,908.52 | 122 | 4,751.81 | Aug. 22, 2026: 49 @ 38.95 |
| Oct. 4, 2026 | issue | SO-261004-395 | MAIN | 20 | 38.95 | -778.99 | 171 | 6,660.33 | Aug. 22, 2026: 20 @ 38.95 |
| Sept. 30, 2026 | issue | SO-260930-951 | MAIN | 61 | 38.66 | -2,358.45 | 191 | 7,439.32 | June 23, 2026: 12 @ 37.49; Aug. 22, 2026: 49 @ 38.95 |
| Sept. 29, 2026 | issue | SO-260929-370 | MAIN | 3 | 37.49 | -112.48 | 252 | 9,797.77 | June 23, 2026: 3 @ 37.49 |
| Sept. 14, 2026 | issue | SO-260914-160 | MAIN | 6 | 37.49 | -224.97 | 255 | 9,910.25 | June 23, 2026: 6 @ 37.49 |
| Sept. 2, 2026 | issue | SO-260902-156 | MAIN | 11 | 37.49 | -412.44 | 261 | 10,135.22 | May 20, 2026: 2 @ 37.49; June 23, 2026: 9 @ 37.49 |
| Aug. 22, 2026 | receipt | PO-001734 | MAIN | 240 | 38.95 | 9,347.83 | 272 | 10,547.66 | |
| Aug. 16, 2026 | issue | SO-260816-309 | MAIN | 25 | 37.49 | -937.37 | 32 | 1,199.83 | May 20, 2026: 25 @ 37.49 |
| Aug. 13, 2026 | issue | SO-260813-794 | MAIN | 12 | 37.49 | -449.94 | 57 | 2,137.20 | May 20, 2026: 12 @ 37.49 |
| Aug. 12, 2026 | issue | SO-260812-952 | MAIN | 5 | 37.49 | -187.47 | 69 | 2,587.13 | May 20, 2026: 5 @ 37.49 |
| Aug. 6, 2026 | issue | SO-260806-108 | MAIN | 18 | 37.49 | -674.90 | 74 | 2,774.61 | May 20, 2026: 18 @ 37.49 |
| Aug. 3, 2026 | issue | SO-260803-731 | MAIN | 25 | 37.49 | -937.37 | 92 | 3,449.51 | May 20, 2026: 25 @ 37.49 |
| July 29, 2026 | issue | SO-260729-321 | MAIN | 62 | 37.49 | -2,324.67 | 117 | 4,386.88 | May 20, 2026: 62 @ 37.49 |
| July 17, 2026 | issue | SO-260717-625 | MAIN | 1 | 37.49 | -37.49 | 179 | 6,711.55 | May 20, 2026: 1 @ 37.49 |
| July 13, 2026 | issue | SO-260713-500 | MAIN | 26 | 37.49 | -974.86 | 180 | 6,749.05 | May 20, 2026: 26 @ 37.49 |
| June 30, 2026 | issue | SO-260630-621 | MAIN | 8 | 37.49 | -299.96 | 206 | 7,723.91 | May 20, 2026: 8 @ 37.49 |
| June 23, 2026 | return | RMA | MAIN | 30 | 37.49 | 1,124.84 | 214 | 8,023.87 | |
| June 21, 2026 | adjustment | Cycle count | MAIN | -1 | 37.49 | -37.49 | 184 | 6,899.02 | May 20, 2026: 1 @ 37.49 |
| June 13, 2026 | issue | SO-260613-429 | MAIN | 61 | 37.44 | -2,283.58 | 185 | 6,936.52 | Feb. 2, 2026: 3 @ 36.89; Feb. 22, 2026: 3 @ 36.89; May 20, 2026: 55 @ 37.49 |
| May 20, 2026 | receipt | PO-001512 | MAIN | 240 | 37.49 | 8,998.73 | 246 | 9,220.10 | |
| May 14, 2026 | issue | SO-260514-880 | MAIN | 24 | 36.89 | -885.48 | 6 | 221.37 | Feb. 2, 2026: 24 @ 36.89 |
| May 9, 2026 | issue | SO-260509-684 | MAIN | 22 | 36.89 | -811.69 | 30 | 1,106.84 | Feb. 2, 2026: 22 @ 36.89 |
| April 30, 2026 | issue | SO-260430-514 | MAIN | 2 | 36.89 | -73.79 | 52 | 1,918.53 | Feb. 2, 2026: 2 @ 36.89 |
| April 29, 2026 | issue | SO-260429-615 | MAIN | 1 | 36.89 | -36.89 | 54 | 1,992.32 | Feb. 2, 2026: 1 @ 36.89 |
| April 16, 2026 | issue | SO-260416-597 | MAIN | 37 | 36.89 | -1,365.11 | 55 | 2,029.21 | Feb. 2, 2026: 37 @ 36.89 |
| April 2, 2026 | issue | SO-260402-641 | MAIN | 23 | 36.89 | -848.58 | 92 | 3,394.32 | Feb. 2, 2026: 23 @ 36.89 |
| April 1, 2026 | issue | SO-260401-915 | MAIN | 6 | 36.89 | -221.37 | 115 | 4,242.90 | Feb. 2, 2026: 6 @ 36.89 |
| March 28, 2026 | issue | SO-260328-640 | MAIN | 22 | 36.89 | -811.69 | 121 | 4,464.27 | Feb. 2, 2026: 22 @ 36.89 |
| March 7, 2026 | issue | SO-260307-775 | MAIN | 1 | 36.89 | -36.89 | 143 | 5,275.96 | Feb. 2, 2026: 1 @ 36.89 |
| March 3, 2026 | issue | SO-260303-162 | MAIN | 40 | 36.89 | -1,475.79 | 144 | 5,312.85 | Feb. 2, 2026: 40 @ 36.89 |
| Feb. 26, 2026 | issue | SO-260226-898 | MAIN | 11 | 36.89 | -405.84 | 184 | 6,788.64 | Feb. 2, 2026: 11 @ 36.89 |
| Feb. 24, 2026 | issue | SO-260224-850 | MAIN | 25 | 36.89 | -922.37 | 195 | 7,194.49 | Feb. 2, 2026: 25 @ 36.89 |
| Feb. 22, 2026 | return | RMA | MAIN | 3 | 36.89 | 110.68 | 220 | 8,116.86 | |
| Feb. 20, 2026 | issue | SO-260220-171 | MAIN | 1 | 36.89 | -36.89 | 217 | 8,006.17 | Feb. 2, 2026: 1 @ 36.89 |
| Feb. 11, 2026 | issue | SO-260211-786 | MAIN | 14 | 36.89 | -516.53 | 218 | 8,043.07 | Feb. 2, 2026: 14 @ 36.89 |
| Feb. 10, 2026 | issue | SO-260210-228 | MAIN | 7 | 36.89 | -258.26 | 232 | 8,559.59 | Feb. 2, 2026: 7 @ 36.89 |
| Feb. 10, 2026 | issue | SO-260210-228 | EAST | 4 | 36.07 | -144.29 | 239 | 8,817.86 | Oct. 2, 2025: 2 @ 35.80; Dec. 15, 2025: 1 @ 35.80; Feb. 2, 2026: 1 @ 36.89 |
| Feb. 8, 2026 | issue | SO-260208-751 | MAIN | 1 | 35.80 | -35.80 | 243 | 8,962.14 | Oct. 2, 2025: 1 @ 35.80 |
| Feb. 2, 2026 | receipt | PO-001194 | MAIN | 240 | 36.89 | 8,854.75 | 244 | 8,997.94 | |
| Feb. 1, 2026 | issue | SO-260201-675 | EAST | 11 | 35.80 | -393.76 | 4 | 143.19 | Oct. 2, 2025: 11 @ 35.80 |
| Jan. 24, 2026 | issue | SO-260124-204 | EAST | 43 | 35.80 | -1,539.26 | 15 | 536.95 | Oct. 2, 2025: 43 @ 35.80 |
| Jan. 24, 2026 | issue | SO-260124-204 | MAIN | 9 | 35.80 | -322.17 | 58 | 2,076.21 | Oct. 2, 2025: 9 @ 35.80 |
| Jan. 21, 2026 | issue | SO-260121-819 | MAIN | 7 | 35.80 | -250.58 | 67 | 2,398.39 | Oct. 2, 2025: 7 @ 35.80 |
| Jan. 11, 2026 | issue | SO-260111-972 | MAIN | 16 | 35.80 | -572.75 | 74 | 2,648.96 | Oct. 2, 2025: 16 @ 35.80 |
| Dec. 28, 2025 | issue | SO-251228-824 | MAIN | 17 | 35.80 | -608.55 | 90 | 3,221.71 | Oct. 2, 2025: 17 @ 35.80 |
| Dec. 15, 2025 | return | RMA | MAIN | 1 | 35.80 | 35.80 | 107 | 3,830.26 | |
| Dec. 12, 2025 | issue | SO-251212-885 | MAIN | 8 | 35.80 | -286.37 | 106 | 3,794.46 | Oct. 2, 2025: 8 @ 35.80 |
| Dec. 10, 2025 | issue | SO-251210-325 | MAIN | 9 | 35.80 | -322.17 | 114 | 4,080.84 | Oct. 2, 2025: 9 @ 35.80 |
| Dec. 6, 2025 | issue | SO-251206-521 | MAIN | 28 | 35.80 | -1,002.31 | 123 | 4,403.01 | Oct. 2, 2025: 28 @ 35.80 |
| Dec. 4, 2025 | issue | SO-251204-805 | MAIN | 7 | 35.80 | -250.58 | 151 | 5,405.32 | Oct. 2, 2025: 7 @ 35.80 |
| Nov. 28, 2025 | issue | SO-251128-406 | EAST | 1 | 35.80 | -35.80 | 158 | 5,655.89 | Oct. 2, 2025: 1 @ 35.80 |
| Nov. 12, 2025 | issue | SO-251112-811 | MAIN | 20 | 35.80 | -715.94 | 159 | 5,691.69 | Oct. 2, 2025: 20 @ 35.80 |
| Nov. 1, 2025 | issue | SO-251101-516 | EAST | 44 | 35.80 | -1,575.06 | 179 | 6,407.63 | Oct. 2, 2025: 44 @ 35.80 |
| Oct. 30, 2025 | issue | SO-251030-908 | MAIN | 1 | 35.80 | -35.80 | 223 | 7,982.69 | Oct. 2, 2025: 1 @ 35.80 |
| Oct. 26, 2025 | issue | SO-251026-876 | MAIN | 1 | 35.80 | -35.80 | 224 | 8,018.48 | Oct. 2, 2025: 1 @ 35.80 |
| Oct. 20, 2025 | issue | SO-251020-705 | MAIN | 12 | 35.80 | -429.56 | 225 | 8,054.28 | Oct. 2, 2025: 12 @ 35.80 |
| Oct. 15, 2025 | issue | SO-251015-593 | MAIN | 8 | 35.62 | -284.92 | 237 | 8,483.84 | July 18, 2025: 5 @ 35.51; Oct. 2, 2025: 3 @ 35.80 |
| Oct. 9, 2025 | issue | SO-251009-839 | MAIN | 24 | 35.51 | -852.15 | 245 | 8,768.76 | July 18, 2025: 24 @ 35.51 |
| Oct. 2, 2025 | transfer | TRF | MAIN → EAST | 74 | warehouse transfer, no cost effect | ||||