Items / SWT-0030
Bell Push Flex SWT-0030 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)159MAIN 159
Value (FIFO)2,112.00avg 13.28
ClassBX / FCV 0.26
Turnover6.2xlast issue 1 days ago
Days of cover50lead 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 | 96.67 / 30.4375 | 3.176 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 24.95 / 5.517 | 4.522 |
| 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 * 4.522^2 + 3.176^2 * 1.5^2) | 21.2 |
| Reorder point | d * LT + safety stock | 3.176 * 7.0 + 21.2 | 43.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 43.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1159/yr, S = 45.00, h = 20%, price = 12.98 | 580.0 |
| Inventory position | on hand + on order | 159 + 0 | 159 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 13.52 | 196 | 16,204 | yes |
| 580 | 12.98 | 580 | 15,888 | yes (chosen if cheapest) |
| 1,160 | 12.44 | 1,160 | 15,906 | yes |
MOQ 290, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 9, 2026 | 159 / 290 | 13.28 | 2,112.00 |
Movement ledger 122 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-241 | MAIN | 10 | 13.28 | -132.83 | 159 | 2,112.00 | Sept. 9, 2026: 10 @ 13.28 |
| Oct. 11, 2026 | issue | SO-261011-888 | MAIN | 100 | 13.28 | -1,328.30 | 169 | 2,244.83 | Sept. 9, 2026: 100 @ 13.28 |
| Oct. 3, 2026 | issue | SO-261003-101 | MAIN | 1 | 13.28 | -13.28 | 269 | 3,573.13 | Sept. 9, 2026: 1 @ 13.28 |
| Sept. 15, 2026 | issue | SO-260915-515 | MAIN | 4 | 13.28 | -53.13 | 270 | 3,586.41 | Sept. 9, 2026: 4 @ 13.28 |
| Sept. 12, 2026 | issue | SO-260912-400 | MAIN | 16 | 13.28 | -212.53 | 274 | 3,639.54 | Sept. 9, 2026: 16 @ 13.28 |
| Sept. 9, 2026 | receipt | PO-001786 | MAIN | 290 | 13.28 | 3,852.07 | 290 | 3,852.07 | |
| Sept. 4, 2026 | issue | SO-260904-972 | MAIN | 104 | 13.19 | -1,371.68 | 0 | 0.00 | June 21, 2026: 104 @ 13.19 |
| Aug. 30, 2026 | issue | SO-260830-319 | MAIN | 18 | 13.19 | -237.41 | 104 | 1,371.68 | June 21, 2026: 18 @ 13.19 |
| Aug. 25, 2026 | issue | SO-260825-525 | MAIN | 57 | 13.19 | -751.78 | 122 | 1,609.08 | June 21, 2026: 57 @ 13.19 |
| July 24, 2026 | issue | SO-260724-777 | MAIN | 32 | 13.19 | -422.05 | 179 | 2,360.87 | June 21, 2026: 32 @ 13.19 |
| July 23, 2026 | issue | SO-260723-834 | MAIN | 40 | 13.19 | -527.57 | 211 | 2,782.92 | June 21, 2026: 40 @ 13.19 |
| July 19, 2026 | issue | SO-260719-407 | MAIN | 22 | 13.19 | -290.16 | 251 | 3,310.49 | June 21, 2026: 22 @ 13.19 |
| July 11, 2026 | issue | SO-260711-597 | MAIN | 15 | 13.19 | -197.84 | 273 | 3,600.65 | June 21, 2026: 15 @ 13.19 |
| June 29, 2026 | issue | SO-260629-465 | MAIN | 2 | 13.19 | -26.38 | 288 | 3,798.49 | June 21, 2026: 2 @ 13.19 |
| June 21, 2026 | receipt | PO-001592 | MAIN | 290 | 13.19 | 3,824.87 | 290 | 3,824.87 | |
| June 17, 2026 | issue | SO-260617-525 | MAIN | 14 | 13.47 | -188.54 | 0 | 0.00 | March 25, 2026: 14 @ 13.47 |
| June 16, 2026 | issue | SO-260616-695 | MAIN | 12 | 13.47 | -161.61 | 14 | 188.54 | March 25, 2026: 12 @ 13.47 |
| June 13, 2026 | issue | SO-260613-724 | MAIN | 37 | 13.47 | -498.29 | 26 | 350.15 | March 25, 2026: 37 @ 13.47 |
| May 28, 2026 | issue | SO-260528-729 | MAIN | 13 | 13.47 | -175.07 | 63 | 848.44 | March 25, 2026: 13 @ 13.47 |
| May 20, 2026 | issue | SO-260520-415 | MAIN | 4 | 13.47 | -53.87 | 76 | 1,023.51 | March 25, 2026: 4 @ 13.47 |
| May 16, 2026 | issue | SO-260516-313 | MAIN | 6 | 13.47 | -80.80 | 80 | 1,077.38 | March 25, 2026: 6 @ 13.47 |
| May 9, 2026 | issue | SO-260509-317 | MAIN | 3 | 13.47 | -40.40 | 86 | 1,158.19 | March 25, 2026: 3 @ 13.47 |
| May 2, 2026 | issue | SO-260502-453 | MAIN | 83 | 13.47 | -1,117.79 | 89 | 1,198.59 | March 25, 2026: 83 @ 13.47 |
| April 25, 2026 | issue | SO-260425-885 | MAIN | 4 | 13.47 | -53.87 | 172 | 2,316.38 | March 25, 2026: 4 @ 13.47 |
| April 22, 2026 | issue | SO-260422-698 | MAIN | 47 | 13.47 | -632.96 | 176 | 2,370.24 | March 25, 2026: 47 @ 13.47 |
| April 8, 2026 | issue | SO-260408-294 | MAIN | 37 | 13.47 | -498.29 | 223 | 3,003.21 | March 25, 2026: 37 @ 13.47 |
| April 6, 2026 | issue | SO-260406-601 | MAIN | 1 | 13.47 | -13.47 | 260 | 3,501.50 | March 25, 2026: 1 @ 13.47 |
| March 29, 2026 | issue | SO-260329-459 | MAIN | 12 | 13.47 | -161.61 | 261 | 3,514.97 | March 25, 2026: 12 @ 13.47 |
| March 28, 2026 | issue | SO-260328-621 | MAIN | 21 | 13.39 | -281.18 | 273 | 3,676.57 | Dec. 17, 2025: 4 @ 13.06; March 25, 2026: 17 @ 13.47 |
| March 25, 2026 | receipt | PO-001354 | MAIN | 290 | 13.47 | 3,905.52 | 294 | 3,957.75 | |
| March 21, 2026 | issue | SO-260321-469 | MAIN | 64 | 13.06 | -835.73 | 4 | 52.23 | Dec. 17, 2025: 64 @ 13.06 |
| March 3, 2026 | issue | SO-260303-799 | MAIN | 47 | 13.06 | -613.74 | 68 | 887.96 | Dec. 17, 2025: 47 @ 13.06 |
| Feb. 28, 2026 | issue | SO-260228-332 | MAIN | 75 | 13.06 | -979.37 | 115 | 1,501.70 | Dec. 17, 2025: 75 @ 13.06 |
| Feb. 27, 2026 | issue | SO-260227-449 | MAIN | 31 | 13.06 | -404.81 | 190 | 2,481.08 | Dec. 17, 2025: 31 @ 13.06 |
| Jan. 30, 2026 | issue | SO-260130-601 | MAIN | 3 | 13.06 | -39.17 | 221 | 2,885.88 | Dec. 17, 2025: 3 @ 13.06 |
| Jan. 25, 2026 | issue | SO-260125-807 | MAIN | 1 | 13.06 | -13.06 | 224 | 2,925.06 | Dec. 17, 2025: 1 @ 13.06 |
| Jan. 9, 2026 | issue | SO-260109-138 | MAIN | 38 | 13.06 | -496.22 | 225 | 2,938.12 | Dec. 17, 2025: 38 @ 13.06 |
| Jan. 3, 2026 | issue | SO-260103-304 | MAIN | 12 | 13.06 | -156.70 | 263 | 3,434.33 | Dec. 17, 2025: 12 @ 13.06 |
| Jan. 2, 2026 | issue | SO-260102-886 | MAIN | 1 | 13.06 | -13.06 | 275 | 3,591.03 | Dec. 17, 2025: 1 @ 13.06 |
| Dec. 22, 2025 | issue | SO-251222-459 | MAIN | 10 | 13.06 | -130.58 | 276 | 3,604.09 | Dec. 17, 2025: 10 @ 13.06 |
| Dec. 17, 2025 | issue | SO-251217-663 | MAIN | 4 | 13.06 | -52.23 | 286 | 3,734.67 | Dec. 17, 2025: 4 @ 13.06 |
| Dec. 17, 2025 | receipt | PO-001059 | MAIN | 290 | 13.06 | 3,786.91 | 290 | 3,786.91 | |
| Dec. 16, 2025 | issue | SO-251216-529 | MAIN | 10 | 13.17 | -131.72 | 0 | 0.00 | Sept. 10, 2025: 10 @ 13.17 |
| Dec. 11, 2025 | issue | SO-251211-226 | MAIN | 5 | 13.17 | -65.86 | 10 | 131.72 | Sept. 10, 2025: 5 @ 13.17 |
| Dec. 9, 2025 | issue | SO-251209-609 | MAIN | 33 | 13.17 | -434.68 | 15 | 197.58 | Sept. 10, 2025: 33 @ 13.17 |
| Dec. 6, 2025 | issue | SO-251206-548 | MAIN | 14 | 13.17 | -184.41 | 48 | 632.26 | Sept. 10, 2025: 14 @ 13.17 |
| Nov. 29, 2025 | issue | SO-251129-789 | MAIN | 2 | 13.17 | -26.34 | 62 | 816.66 | Sept. 10, 2025: 2 @ 13.17 |
| Nov. 28, 2025 | issue | SO-251128-823 | MAIN | 23 | 13.17 | -302.96 | 64 | 843.01 | Sept. 10, 2025: 23 @ 13.17 |
| Nov. 16, 2025 | issue | SO-251116-427 | MAIN | 12 | 13.17 | -158.06 | 87 | 1,145.96 | Sept. 10, 2025: 12 @ 13.17 |
| Nov. 12, 2025 | issue | SO-251112-630 | MAIN | 29 | 13.17 | -381.99 | 99 | 1,304.03 | Sept. 10, 2025: 29 @ 13.17 |
| Nov. 11, 2025 | issue | SO-251111-144 | MAIN | 11 | 13.17 | -144.89 | 128 | 1,686.02 | Sept. 10, 2025: 11 @ 13.17 |
| Nov. 4, 2025 | issue | SO-251104-754 | MAIN | 39 | 13.17 | -513.71 | 139 | 1,830.91 | Sept. 10, 2025: 39 @ 13.17 |
| Oct. 26, 2025 | issue | SO-251026-337 | MAIN | 11 | 13.17 | -144.89 | 178 | 2,344.62 | Sept. 10, 2025: 11 @ 13.17 |
| Oct. 19, 2025 | issue | SO-251019-399 | MAIN | 28 | 13.17 | -368.82 | 189 | 2,489.51 | Sept. 10, 2025: 28 @ 13.17 |
| Oct. 19, 2025 | issue | SO-251019-399 | EAST | 21 | 13.17 | -276.61 | 217 | 2,858.32 | Sept. 10, 2025: 21 @ 13.17 |
| Oct. 15, 2025 | issue | SO-251015-500 | EAST | 5 | 13.17 | -65.86 | 238 | 3,134.94 | Sept. 10, 2025: 5 @ 13.17 |
| Oct. 5, 2025 | issue | SO-251005-337 | MAIN | 16 | 13.17 | -210.75 | 243 | 3,200.80 | Sept. 10, 2025: 16 @ 13.17 |
| Oct. 3, 2025 | issue | SO-251003-344 | MAIN | 11 | 13.17 | -144.89 | 259 | 3,411.55 | Sept. 10, 2025: 11 @ 13.17 |
| Sept. 17, 2025 | issue | SO-250917-354 | MAIN | 34 | 13.05 | -443.77 | 270 | 3,556.44 | June 27, 2025: 14 @ 12.88; Sept. 10, 2025: 20 @ 13.17 |
| Sept. 16, 2025 | issue | SO-250916-800 | EAST | 8 | 12.88 | -103.05 | 304 | 4,000.21 | June 27, 2025: 8 @ 12.88 |