Items / SWT-0011
Bell Push Lite SWT-0011 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)64MAIN 64
Value (FIFO)2,864.83avg 44.76
ClassBX / FCV 0.12
Turnover6.7xlast issue 5 days ago
Days of cover62lead 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 | 31.67 / 30.4375 | 1.040 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 3.86 / 5.517 | 0.699 |
| 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 * 0.699^2 + 1.040^2 * 1.5^2) | 4.0 |
| Reorder point | d * LT + safety stock | 1.040 * 7.0 + 4.0 | 11.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 11.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 380/yr, S = 45.00, h = 20%, price = 44.32 | 200.0 |
| Inventory position | on hand + on order | 64 + 0 | 64 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 46.17 | 61 | 18,094 | yes |
| 200 | 44.32 | 200 | 17,803 | yes (chosen if cheapest) |
| 400 | 42.48 | 400 | 17,872 | yes |
MOQ 100, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 16, 2026 | 64 / 100 | 44.76 | 2,864.83 |
Movement ledger 139 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 11, 2026 | issue | SO-261011-119 | MAIN | 2 | 44.76 | -89.53 | 64 | 2,864.83 | Sept. 16, 2026: 2 @ 44.76 |
| Oct. 11, 2026 | issue | SO-261011-119 | EAST | 25 | 44.76 | -1,119.07 | 66 | 2,954.35 | Sept. 16, 2026: 25 @ 44.76 |
| Oct. 8, 2026 | issue | SO-261008-242 | MAIN | 6 | 44.76 | -268.58 | 91 | 4,073.42 | Sept. 16, 2026: 6 @ 44.76 |
| Sept. 29, 2026 | issue | SO-260929-288 | MAIN | 2 | 44.76 | -89.53 | 97 | 4,342.00 | Sept. 16, 2026: 2 @ 44.76 |
| Sept. 23, 2026 | issue | SO-260923-698 | MAIN | 1 | 44.76 | -44.76 | 99 | 4,431.53 | Sept. 16, 2026: 1 @ 44.76 |
| Sept. 16, 2026 | transfer | TRF | MAIN → EAST | 25 | warehouse transfer, no cost effect | ||||
| Sept. 16, 2026 | receipt | PO-001803 | MAIN | 100 | 44.76 | 4,476.29 | 100 | 4,476.29 | |
| Sept. 12, 2026 | issue | SO-260912-123 | MAIN | 15 | 44.39 | -665.88 | 0 | 0.00 | June 8, 2026: 15 @ 44.39 |
| Sept. 10, 2026 | issue | SO-260910-767 | MAIN | 6 | 44.39 | -266.35 | 15 | 665.88 | June 8, 2026: 6 @ 44.39 |
| Sept. 9, 2026 | issue | SO-260909-418 | MAIN | 5 | 44.39 | -221.96 | 21 | 932.23 | June 8, 2026: 5 @ 44.39 |
| Sept. 5, 2026 | issue | SO-260905-557 | MAIN | 5 | 44.39 | -221.96 | 26 | 1,154.19 | June 8, 2026: 5 @ 44.39 |
| Sept. 4, 2026 | issue | SO-260904-527 | MAIN | 1 | 44.39 | -44.39 | 31 | 1,376.16 | June 8, 2026: 1 @ 44.39 |
| Aug. 14, 2026 | issue | SO-260814-819 | MAIN | 2 | 44.39 | -88.78 | 32 | 1,420.55 | June 8, 2026: 2 @ 44.39 |
| Aug. 10, 2026 | issue | SO-260810-710 | MAIN | 4 | 44.39 | -177.57 | 34 | 1,509.33 | June 8, 2026: 4 @ 44.39 |
| Aug. 5, 2026 | issue | SO-260805-628 | MAIN | 6 | 44.39 | -266.35 | 38 | 1,686.90 | June 8, 2026: 6 @ 44.39 |
| Aug. 2, 2026 | issue | SO-260802-695 | MAIN | 15 | 44.39 | -665.88 | 44 | 1,953.25 | June 8, 2026: 15 @ 44.39 |
| July 14, 2026 | issue | SO-260714-249 | MAIN | 26 | 44.39 | -1,154.19 | 59 | 2,619.13 | June 8, 2026: 26 @ 44.39 |
| June 21, 2026 | issue | SO-260621-756 | MAIN | 5 | 44.39 | -221.96 | 85 | 3,773.33 | June 8, 2026: 5 @ 44.39 |
| June 21, 2026 | issue | SO-260621-756 | EAST | 1 | 44.39 | -44.39 | 90 | 3,995.29 | June 8, 2026: 1 @ 44.39 |
| June 17, 2026 | issue | SO-260617-450 | MAIN | 1 | 44.39 | -44.39 | 91 | 4,039.68 | June 8, 2026: 1 @ 44.39 |
| June 16, 2026 | issue | SO-260616-244 | MAIN | 7 | 44.39 | -310.74 | 92 | 4,084.07 | June 8, 2026: 7 @ 44.39 |
| June 14, 2026 | issue | SO-260614-112 | MAIN | 2 | 44.16 | -88.33 | 99 | 4,394.82 | March 13, 2026: 1 @ 43.93; June 8, 2026: 1 @ 44.39 |
| June 8, 2026 | receipt | PO-001560 | MAIN | 100 | 44.39 | 4,439.21 | 101 | 4,483.14 | |
| June 5, 2026 | issue | SO-260605-291 | EAST | 3 | 43.93 | -131.80 | 1 | 43.93 | March 13, 2026: 3 @ 43.93 |
| June 3, 2026 | issue | SO-260603-226 | EAST | 5 | 43.93 | -219.67 | 4 | 175.73 | March 13, 2026: 5 @ 43.93 |
| June 2, 2026 | issue | SO-260602-468 | EAST | 6 | 43.93 | -263.60 | 9 | 395.40 | March 13, 2026: 6 @ 43.93 |
| June 2, 2026 | issue | SO-260602-468 | MAIN | 1 | 43.93 | -43.93 | 15 | 659.00 | March 13, 2026: 1 @ 43.93 |
| May 14, 2026 | issue | SO-260514-286 | MAIN | 5 | 43.93 | -219.67 | 16 | 702.93 | March 13, 2026: 5 @ 43.93 |
| May 12, 2026 | issue | SO-260512-155 | MAIN | 12 | 43.93 | -527.20 | 21 | 922.60 | March 13, 2026: 12 @ 43.93 |
| May 5, 2026 | issue | SO-260505-353 | MAIN | 12 | 43.93 | -527.20 | 33 | 1,449.80 | March 13, 2026: 12 @ 43.93 |
| May 1, 2026 | issue | SO-260501-644 | EAST | 4 | 43.93 | -175.73 | 45 | 1,976.99 | March 13, 2026: 4 @ 43.93 |
| April 30, 2026 | issue | SO-260430-316 | MAIN | 5 | 43.93 | -219.67 | 49 | 2,152.73 | March 13, 2026: 5 @ 43.93 |
| April 9, 2026 | issue | SO-260409-139 | MAIN | 8 | 43.93 | -351.47 | 54 | 2,372.39 | March 13, 2026: 8 @ 43.93 |
| April 5, 2026 | issue | SO-260405-680 | EAST | 3 | 43.93 | -131.80 | 62 | 2,723.86 | March 13, 2026: 3 @ 43.93 |
| April 2, 2026 | issue | SO-260402-859 | MAIN | 15 | 43.93 | -659.00 | 65 | 2,855.66 | March 13, 2026: 15 @ 43.93 |
| March 26, 2026 | issue | SO-260326-409 | MAIN | 8 | 43.93 | -351.47 | 80 | 3,514.66 | March 13, 2026: 8 @ 43.93 |
| March 25, 2026 | issue | SO-260325-667 | EAST | 13 | 43.97 | -571.62 | 88 | 3,866.12 | Dec. 9, 2025: 1 @ 44.42; March 13, 2026: 12 @ 43.93 |
| March 13, 2026 | transfer | TRF | MAIN → EAST | 35 | warehouse transfer, no cost effect | ||||
| March 13, 2026 | receipt | PO-001314 | MAIN | 100 | 43.93 | 4,393.32 | 101 | 4,437.74 | |
| March 12, 2026 | issue | SO-260312-455 | MAIN | 7 | 44.42 | -310.94 | 1 | 44.42 | Dec. 9, 2025: 7 @ 44.42 |
| March 7, 2026 | issue | SO-260307-145 | MAIN | 5 | 44.42 | -222.10 | 8 | 355.36 | Dec. 9, 2025: 5 @ 44.42 |
| March 4, 2026 | issue | SO-260304-871 | MAIN | 3 | 44.42 | -133.26 | 13 | 577.46 | Dec. 9, 2025: 3 @ 44.42 |
| Feb. 26, 2026 | issue | SO-260226-936 | MAIN | 5 | 44.42 | -222.10 | 16 | 710.72 | Dec. 9, 2025: 5 @ 44.42 |
| Feb. 25, 2026 | issue | SO-260225-986 | MAIN | 21 | 44.42 | -932.82 | 21 | 932.82 | Dec. 9, 2025: 21 @ 44.42 |
| Jan. 16, 2026 | issue | SO-260116-225 | MAIN | 7 | 44.42 | -310.94 | 42 | 1,865.64 | Dec. 9, 2025: 7 @ 44.42 |
| Jan. 10, 2026 | issue | SO-260110-412 | MAIN | 6 | 44.42 | -266.52 | 49 | 2,176.58 | Dec. 9, 2025: 6 @ 44.42 |
| Jan. 9, 2026 | issue | SO-260109-753 | MAIN | 11 | 44.42 | -488.62 | 55 | 2,443.09 | Dec. 9, 2025: 11 @ 44.42 |
| Jan. 8, 2026 | issue | SO-260108-743 | MAIN | 11 | 44.42 | -488.62 | 66 | 2,931.71 | Dec. 9, 2025: 11 @ 44.42 |
| Dec. 31, 2025 | issue | SO-251231-131 | MAIN | 19 | 44.42 | -843.98 | 77 | 3,420.33 | Dec. 9, 2025: 19 @ 44.42 |
| Dec. 29, 2025 | issue | SO-251229-436 | MAIN | 6 | 43.91 | -263.45 | 96 | 4,264.31 | Sept. 6, 2025: 1 @ 42.88; Oct. 30, 2025: 1 @ 42.88; Dec. 9, 2025: 4 @ 44.42 |
| Dec. 11, 2025 | issue | SO-251211-257 | MAIN | 8 | 42.88 | -343.06 | 102 | 4,527.76 | Sept. 6, 2025: 8 @ 42.88 |
| Dec. 9, 2025 | receipt | PO-001041 | MAIN | 100 | 44.42 | 4,441.99 | 110 | 4,870.82 | |
| Nov. 30, 2025 | issue | SO-251130-863 | MAIN | 6 | 42.88 | -257.30 | 10 | 428.83 | Sept. 6, 2025: 6 @ 42.88 |
| Nov. 29, 2025 | issue | SO-251129-138 | MAIN | 16 | 42.88 | -686.13 | 16 | 686.13 | Sept. 6, 2025: 16 @ 42.88 |
| Nov. 28, 2025 | issue | SO-251128-824 | MAIN | 1 | 42.88 | -42.88 | 32 | 1,372.26 | Sept. 6, 2025: 1 @ 42.88 |
| Nov. 22, 2025 | issue | SO-251122-206 | MAIN | 10 | 42.88 | -428.83 | 33 | 1,415.14 | Sept. 6, 2025: 10 @ 42.88 |
| Nov. 14, 2025 | issue | SO-251114-680 | MAIN | 5 | 42.88 | -214.42 | 43 | 1,843.97 | Sept. 6, 2025: 5 @ 42.88 |
| Oct. 30, 2025 | return | RMA | MAIN | 1 | 42.88 | 42.88 | 48 | 2,058.38 | |
| Oct. 26, 2025 | issue | SO-251026-974 | MAIN | 2 | 42.88 | -85.77 | 47 | 2,015.50 | Sept. 6, 2025: 2 @ 42.88 |
| Oct. 25, 2025 | issue | SO-251025-940 | MAIN | 6 | 42.88 | -257.30 | 49 | 2,101.27 | Sept. 6, 2025: 6 @ 42.88 |