Items / SWT-0022
Bell Push Max SWT-0022 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)14MAIN 14
Value (FIFO)119.94avg 8.57
ClassBX / FCV 0.23
Turnover7.4xlast issue 5 days ago
Days of cover4lead time 7d
Reorder suggested: 760 units (position at or below reorder point: order EOQ), stockout risk high.
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 | 116.08 / 30.4375 | 3.814 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 26.88 / 5.517 | 4.872 |
| 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.872^2 + 3.814^2 * 1.5^2) | 23.3 |
| Reorder point | d * LT + safety stock | 3.814 * 7.0 + 23.3 | 49.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 49.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1392/yr, S = 45.00, h = 20%, price = 8.46 | 760.0 |
| Inventory position | on hand + on order | 14 + 0 | 14 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 8.81 | 267 | 12,734 | yes |
| 760 | 8.46 | 760 | 12,499 | yes (chosen if cheapest) |
| 1,520 | 8.11 | 1,520 | 12,556 | yes |
MOQ 380, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 25, 2026 | 6 / 380 | 8.57 | 51.40 | |
| Oct. 14, 2026 | 8 / 8 | 8.57 | 68.54 |
Movement ledger 113 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | return | RMA | MAIN | 8 | 8.57 | 68.54 | 14 | 119.94 | |
| Oct. 11, 2026 | issue | SO-261011-298 | MAIN | 72 | 8.57 | -616.85 | 6 | 51.40 | July 25, 2026: 72 @ 8.57 |
| Oct. 10, 2026 | issue | SO-261010-736 | MAIN | 16 | 8.57 | -137.08 | 78 | 668.26 | July 25, 2026: 16 @ 8.57 |
| Oct. 8, 2026 | issue | SO-261008-431 | MAIN | 38 | 8.57 | -325.56 | 94 | 805.34 | July 25, 2026: 38 @ 8.57 |
| Oct. 2, 2026 | issue | SO-261002-481 | MAIN | 48 | 8.57 | -411.24 | 132 | 1,130.90 | July 25, 2026: 48 @ 8.57 |
| Sept. 20, 2026 | issue | SO-260920-233 | MAIN | 29 | 8.57 | -248.45 | 180 | 1,542.13 | July 25, 2026: 29 @ 8.57 |
| Sept. 9, 2026 | issue | SO-260909-335 | MAIN | 13 | 8.57 | -111.38 | 209 | 1,790.59 | July 25, 2026: 13 @ 8.57 |
| Sept. 5, 2026 | issue | SO-260905-700 | MAIN | 9 | 8.57 | -77.11 | 222 | 1,901.96 | July 25, 2026: 9 @ 8.57 |
| Sept. 4, 2026 | issue | SO-260904-226 | MAIN | 7 | 8.57 | -59.97 | 231 | 1,979.07 | July 25, 2026: 7 @ 8.57 |
| Sept. 2, 2026 | issue | SO-260902-459 | MAIN | 25 | 8.57 | -214.18 | 238 | 2,039.04 | July 25, 2026: 25 @ 8.57 |
| Sept. 1, 2026 | issue | SO-260901-661 | MAIN | 22 | 8.57 | -188.48 | 263 | 2,253.23 | July 25, 2026: 22 @ 8.57 |
| Aug. 16, 2026 | issue | SO-260816-582 | MAIN | 4 | 8.57 | -34.27 | 285 | 2,441.71 | July 25, 2026: 4 @ 8.57 |
| Aug. 15, 2026 | issue | SO-260815-584 | MAIN | 26 | 8.57 | -222.75 | 289 | 2,475.98 | July 25, 2026: 26 @ 8.57 |
| Aug. 8, 2026 | issue | SO-260808-260 | MAIN | 22 | 8.57 | -188.48 | 315 | 2,698.73 | July 25, 2026: 22 @ 8.57 |
| Aug. 7, 2026 | issue | SO-260807-197 | MAIN | 10 | 8.57 | -85.67 | 337 | 2,887.21 | July 25, 2026: 10 @ 8.57 |
| Aug. 3, 2026 | issue | SO-260803-276 | MAIN | 36 | 8.57 | -308.41 | 347 | 2,972.89 | April 12, 2026: 3 @ 8.56; July 25, 2026: 33 @ 8.57 |
| July 25, 2026 | receipt | PO-001672 | MAIN | 380 | 8.57 | 3,255.61 | 383 | 3,281.30 | |
| July 18, 2026 | issue | SO-260718-415 | MAIN | 123 | 8.56 | -1,053.00 | 3 | 25.68 | April 12, 2026: 123 @ 8.56 |
| July 11, 2026 | issue | SO-260711-327 | MAIN | 33 | 8.56 | -282.51 | 126 | 1,078.69 | April 12, 2026: 33 @ 8.56 |
| June 29, 2026 | issue | SO-260629-347 | MAIN | 53 | 8.56 | -453.73 | 159 | 1,361.20 | April 12, 2026: 53 @ 8.56 |
| June 28, 2026 | issue | SO-260628-369 | MAIN | 69 | 8.56 | -590.71 | 212 | 1,814.93 | April 12, 2026: 69 @ 8.56 |
| June 20, 2026 | issue | SO-260620-767 | MAIN | 16 | 8.56 | -136.98 | 281 | 2,405.64 | April 12, 2026: 16 @ 8.56 |
| May 28, 2026 | issue | SO-260528-731 | MAIN | 16 | 8.56 | -136.98 | 297 | 2,542.62 | April 12, 2026: 16 @ 8.56 |
| May 11, 2026 | issue | SO-260511-100 | MAIN | 51 | 8.56 | -436.61 | 313 | 2,679.59 | April 12, 2026: 51 @ 8.56 |
| May 7, 2026 | issue | SO-260507-896 | MAIN | 16 | 8.56 | -136.98 | 364 | 3,116.20 | April 12, 2026: 16 @ 8.56 |
| April 12, 2026 | receipt | PO-001403 | MAIN | 380 | 8.56 | 3,253.18 | 380 | 3,253.18 | |
| April 7, 2026 | issue | SO-260407-105 | MAIN | 57 | 8.65 | -492.87 | 0 | 0.00 | Jan. 20, 2026: 57 @ 8.65 |
| April 6, 2026 | issue | SO-260406-399 | MAIN | 15 | 8.65 | -129.70 | 57 | 492.87 | Jan. 20, 2026: 15 @ 8.65 |
| March 26, 2026 | issue | SO-260326-188 | MAIN | 71 | 8.65 | -613.92 | 72 | 622.57 | Jan. 20, 2026: 71 @ 8.65 |
| March 21, 2026 | issue | SO-260321-135 | MAIN | 13 | 8.65 | -112.41 | 143 | 1,236.49 | Jan. 20, 2026: 13 @ 8.65 |
| March 16, 2026 | issue | SO-260316-487 | MAIN | 31 | 8.65 | -268.05 | 156 | 1,348.90 | Jan. 20, 2026: 31 @ 8.65 |
| March 15, 2026 | issue | SO-260315-829 | MAIN | 1 | 8.65 | -8.65 | 187 | 1,616.95 | Jan. 20, 2026: 1 @ 8.65 |
| March 13, 2026 | issue | SO-260313-956 | MAIN | 43 | 8.65 | -371.81 | 188 | 1,625.60 | Jan. 20, 2026: 43 @ 8.65 |
| Feb. 25, 2026 | issue | SO-260225-891 | MAIN | 61 | 8.65 | -527.45 | 231 | 1,997.41 | Jan. 20, 2026: 61 @ 8.65 |
| Feb. 17, 2026 | issue | SO-260217-300 | MAIN | 10 | 8.65 | -86.47 | 292 | 2,524.87 | Jan. 20, 2026: 10 @ 8.65 |
| Feb. 14, 2026 | issue | SO-260214-630 | MAIN | 22 | 8.65 | -190.23 | 302 | 2,611.33 | Jan. 20, 2026: 22 @ 8.65 |
| Feb. 13, 2026 | issue | SO-260213-209 | MAIN | 2 | 8.65 | -17.29 | 324 | 2,801.56 | Jan. 20, 2026: 2 @ 8.65 |
| Feb. 9, 2026 | issue | SO-260209-270 | MAIN | 4 | 8.65 | -34.59 | 326 | 2,818.86 | Jan. 20, 2026: 4 @ 8.65 |
| Feb. 8, 2026 | issue | SO-260208-228 | MAIN | 17 | 8.65 | -147.00 | 330 | 2,853.44 | Jan. 20, 2026: 17 @ 8.65 |
| Jan. 31, 2026 | issue | SO-260131-533 | MAIN | 33 | 8.65 | -285.34 | 347 | 3,000.44 | Jan. 20, 2026: 33 @ 8.65 |
| Jan. 20, 2026 | receipt | PO-001163 | MAIN | 380 | 8.65 | 3,285.78 | 380 | 3,285.78 | |
| Jan. 10, 2026 | issue | SO-260110-357 | MAIN | 62 | 8.45 | -524.02 | 0 | 0.00 | Oct. 7, 2025: 62 @ 8.45 |
| Dec. 29, 2025 | issue | SO-251229-129 | MAIN | 14 | 8.45 | -118.33 | 62 | 524.02 | Oct. 7, 2025: 14 @ 8.45 |
| Dec. 23, 2025 | issue | SO-251223-843 | MAIN | 113 | 8.45 | -955.06 | 76 | 642.34 | Oct. 7, 2025: 113 @ 8.45 |
| Dec. 14, 2025 | issue | SO-251214-723 | MAIN | 5 | 8.45 | -42.26 | 189 | 1,597.41 | Oct. 7, 2025: 5 @ 8.45 |
| Dec. 12, 2025 | issue | SO-251212-634 | MAIN | 4 | 8.45 | -33.81 | 194 | 1,639.67 | Oct. 7, 2025: 4 @ 8.45 |
| Dec. 7, 2025 | issue | SO-251207-256 | MAIN | 6 | 8.45 | -50.71 | 198 | 1,673.48 | Oct. 7, 2025: 6 @ 8.45 |
| Nov. 28, 2025 | issue | SO-251128-857 | MAIN | 33 | 8.45 | -278.91 | 204 | 1,724.19 | Oct. 7, 2025: 33 @ 8.45 |
| Nov. 27, 2025 | issue | SO-251127-900 | MAIN | 25 | 8.45 | -211.30 | 237 | 2,003.10 | Oct. 7, 2025: 25 @ 8.45 |
| Nov. 26, 2025 | issue | SO-251126-510 | MAIN | 13 | 8.45 | -109.87 | 262 | 2,214.40 | Oct. 7, 2025: 13 @ 8.45 |
| Nov. 24, 2025 | issue | SO-251124-294 | MAIN | 8 | 8.45 | -67.62 | 275 | 2,324.27 | Oct. 7, 2025: 8 @ 8.45 |
| Nov. 22, 2025 | issue | SO-251122-215 | MAIN | 4 | 8.45 | -33.81 | 283 | 2,391.89 | Oct. 7, 2025: 4 @ 8.45 |
| Nov. 21, 2025 | issue | SO-251121-949 | MAIN | 1 | 8.45 | -8.45 | 287 | 2,425.70 | Oct. 7, 2025: 1 @ 8.45 |
| Nov. 14, 2025 | issue | SO-251114-481 | MAIN | 22 | 8.45 | -185.94 | 288 | 2,434.15 | Oct. 7, 2025: 22 @ 8.45 |
| Oct. 23, 2025 | issue | SO-251023-476 | MAIN | 94 | 8.43 | -792.07 | 310 | 2,620.09 | June 12, 2025: 2 @ 8.35; Aug. 20, 2025: 22 @ 8.35; Oct. 7, 2025: 70 @ 8.45 |
| Oct. 9, 2025 | issue | SO-251009-140 | MAIN | 29 | 8.35 | -242.20 | 404 | 3,412.16 | June 12, 2025: 29 @ 8.35 |
| Oct. 7, 2025 | receipt | PO-000906 | MAIN | 380 | 8.45 | 3,211.72 | 433 | 3,654.36 | |
| Sept. 30, 2025 | issue | SO-250930-145 | MAIN | 7 | 8.35 | -58.46 | 53 | 442.64 | June 12, 2025: 7 @ 8.35 |
| Sept. 26, 2025 | issue | SO-250926-125 | MAIN | 98 | 8.35 | -818.47 | 60 | 501.10 | June 12, 2025: 98 @ 8.35 |
| Sept. 12, 2025 | issue | SO-250912-487 | MAIN | 3 | 8.35 | -25.06 | 158 | 1,319.57 | June 12, 2025: 3 @ 8.35 |