Items / SWT-0012
Bell Push Pro SWT-0012 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)174MAIN 174
Value (FIFO)4,951.71avg 28.46
ClassBX / FCV 0.21
Turnover4.9xlast issue 1 days ago
Days of cover67lead 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 | 78.58 / 30.4375 | 2.582 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 16.41 / 5.517 | 2.974 |
| 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 * 2.974^2 + 2.582^2 * 1.5^2) | 14.5 |
| Reorder point | d * LT + safety stock | 2.582 * 7.0 + 14.5 | 32.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 32.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 942/yr, S = 45.00, h = 20%, price = 28.95 | 121.0 |
| Inventory position | on hand + on order | 174 + 0 | 174 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 28.95 | 121 | 27,982 | yes (chosen if cheapest) |
MOQ 240, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 3, 2026 | 174 / 240 | 28.46 | 4,951.71 |
Movement ledger 127 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-855 | MAIN | 25 | 28.46 | -711.45 | 174 | 4,951.71 | Oct. 3, 2026: 25 @ 28.46 |
| Oct. 14, 2026 | issue | SO-261014-241 | MAIN | 9 | 28.46 | -256.12 | 199 | 5,663.16 | Oct. 3, 2026: 9 @ 28.46 |
| Oct. 13, 2026 | issue | SO-261013-358 | MAIN | 9 | 28.46 | -256.12 | 208 | 5,919.28 | Oct. 3, 2026: 9 @ 28.46 |
| Oct. 12, 2026 | issue | SO-261012-808 | MAIN | 3 | 28.46 | -85.37 | 217 | 6,175.41 | Oct. 3, 2026: 3 @ 28.46 |
| Oct. 9, 2026 | issue | SO-261009-245 | MAIN | 36 | 28.44 | -1,023.67 | 220 | 6,260.78 | June 16, 2026: 16 @ 28.41; Oct. 3, 2026: 20 @ 28.46 |
| Oct. 4, 2026 | issue | SO-261004-700 | MAIN | 4 | 28.41 | -113.63 | 256 | 7,284.46 | June 16, 2026: 4 @ 28.41 |
| Oct. 3, 2026 | receipt | PO-001848 | MAIN | 240 | 28.46 | 6,829.94 | 260 | 7,398.08 | |
| Sept. 25, 2026 | issue | SO-260925-930 | MAIN | 44 | 28.41 | -1,249.91 | 20 | 568.14 | June 16, 2026: 44 @ 28.41 |
| Sept. 21, 2026 | issue | SO-260921-775 | MAIN | 7 | 28.41 | -198.85 | 64 | 1,818.05 | June 16, 2026: 7 @ 28.41 |
| Sept. 18, 2026 | issue | SO-260918-488 | MAIN | 18 | 28.41 | -511.33 | 71 | 2,016.90 | June 16, 2026: 18 @ 28.41 |
| Sept. 16, 2026 | issue | SO-260916-467 | MAIN | 16 | 28.41 | -454.51 | 89 | 2,528.22 | June 16, 2026: 16 @ 28.41 |
| Sept. 11, 2026 | issue | SO-260911-884 | MAIN | 2 | 28.41 | -56.81 | 105 | 2,982.74 | June 16, 2026: 2 @ 28.41 |
| Aug. 28, 2026 | issue | SO-260828-838 | MAIN | 14 | 28.41 | -397.70 | 107 | 3,039.55 | June 16, 2026: 14 @ 28.41 |
| Aug. 22, 2026 | issue | SO-260822-108 | MAIN | 9 | 28.41 | -255.66 | 121 | 3,437.25 | June 16, 2026: 9 @ 28.41 |
| Aug. 6, 2026 | issue | SO-260806-543 | MAIN | 6 | 28.41 | -170.44 | 130 | 3,692.91 | June 16, 2026: 6 @ 28.41 |
| Aug. 4, 2026 | issue | SO-260804-863 | MAIN | 13 | 28.41 | -369.29 | 136 | 3,863.35 | June 16, 2026: 13 @ 28.41 |
| Aug. 2, 2026 | issue | SO-260802-178 | MAIN | 20 | 28.41 | -568.14 | 149 | 4,232.64 | June 16, 2026: 20 @ 28.41 |
| July 31, 2026 | issue | SO-260731-305 | MAIN | 1 | 28.41 | -28.41 | 169 | 4,800.78 | June 16, 2026: 1 @ 28.41 |
| July 28, 2026 | issue | SO-260728-352 | MAIN | 7 | 28.41 | -198.85 | 170 | 4,829.19 | June 16, 2026: 7 @ 28.41 |
| July 22, 2026 | issue | SO-260722-398 | MAIN | 2 | 28.41 | -56.81 | 177 | 5,028.04 | June 16, 2026: 2 @ 28.41 |
| July 10, 2026 | issue | SO-260710-669 | MAIN | 5 | 28.41 | -142.04 | 179 | 5,084.85 | June 16, 2026: 5 @ 28.41 |
| July 10, 2026 | issue | SO-260710-669 | EAST | 18 | 28.41 | -511.33 | 184 | 5,226.89 | June 16, 2026: 18 @ 28.41 |
| July 1, 2026 | issue | SO-260701-406 | EAST | 23 | 28.41 | -653.36 | 202 | 5,738.21 | June 16, 2026: 23 @ 28.41 |
| June 20, 2026 | issue | SO-260620-615 | MAIN | 20 | 28.20 | -564.07 | 225 | 6,391.58 | March 25, 2026: 5 @ 27.59; June 16, 2026: 15 @ 28.41 |
| June 19, 2026 | issue | SO-260619-212 | MAIN | 11 | 27.59 | -303.52 | 245 | 6,955.64 | March 25, 2026: 11 @ 27.59 |
| June 18, 2026 | issue | SO-260618-690 | EAST | 10 | 27.59 | -275.93 | 256 | 7,259.16 | March 25, 2026: 10 @ 27.59 |
| June 16, 2026 | transfer | TRF | MAIN → EAST | 51 | warehouse transfer, no cost effect | ||||
| June 16, 2026 | receipt | PO-001580 | MAIN | 240 | 28.41 | 6,817.68 | 266 | 7,535.09 | |
| June 10, 2026 | issue | SO-260610-792 | MAIN | 43 | 27.59 | -1,186.49 | 26 | 717.41 | March 25, 2026: 43 @ 27.59 |
| June 8, 2026 | issue | SO-260608-643 | MAIN | 7 | 27.59 | -193.15 | 69 | 1,903.90 | March 25, 2026: 7 @ 27.59 |
| May 31, 2026 | issue | SO-260531-322 | MAIN | 6 | 27.59 | -165.56 | 76 | 2,097.05 | March 25, 2026: 6 @ 27.59 |
| May 15, 2026 | issue | SO-260515-889 | MAIN | 38 | 27.59 | -1,048.52 | 82 | 2,262.60 | March 25, 2026: 38 @ 27.59 |
| May 15, 2026 | issue | SO-260515-889 | EAST | 32 | 27.59 | -882.97 | 120 | 3,311.12 | March 25, 2026: 32 @ 27.59 |
| May 8, 2026 | issue | SO-260508-805 | MAIN | 1 | 27.59 | -27.59 | 152 | 4,194.09 | March 25, 2026: 1 @ 27.59 |
| April 28, 2026 | issue | SO-260428-114 | MAIN | 30 | 27.59 | -827.78 | 153 | 4,221.68 | March 25, 2026: 30 @ 27.59 |
| April 25, 2026 | issue | SO-260425-463 | MAIN | 4 | 27.59 | -110.37 | 183 | 5,049.46 | March 25, 2026: 4 @ 27.59 |
| April 20, 2026 | issue | SO-260420-784 | MAIN | 5 | 27.59 | -137.96 | 187 | 5,159.83 | March 25, 2026: 5 @ 27.59 |
| April 18, 2026 | issue | SO-260418-993 | EAST | 19 | 27.59 | -524.26 | 192 | 5,297.80 | March 25, 2026: 19 @ 27.59 |
| March 29, 2026 | issue | SO-260329-109 | MAIN | 63 | 27.53 | -1,734.55 | 211 | 5,822.06 | Dec. 24, 2025: 30 @ 27.48; Feb. 8, 2026: 4 @ 27.48; March 25, 2026: 29 @ 27.59 |
| March 25, 2026 | transfer | TRF | MAIN → EAST | 51 | warehouse transfer, no cost effect | ||||
| March 25, 2026 | receipt | PO-001353 | MAIN | 240 | 27.59 | 6,622.25 | 274 | 7,556.61 | |
| March 23, 2026 | issue | SO-260323-571 | MAIN | 1 | 27.48 | -27.48 | 34 | 934.36 | Dec. 24, 2025: 1 @ 27.48 |
| March 19, 2026 | issue | SO-260319-374 | MAIN | 12 | 27.48 | -329.77 | 35 | 961.84 | Dec. 24, 2025: 12 @ 27.48 |
| March 1, 2026 | issue | SO-260301-493 | MAIN | 23 | 27.48 | -632.07 | 47 | 1,291.62 | Dec. 24, 2025: 23 @ 27.48 |
| Feb. 12, 2026 | issue | SO-260212-279 | MAIN | 61 | 27.48 | -1,676.35 | 70 | 1,923.68 | Dec. 24, 2025: 61 @ 27.48 |
| Feb. 10, 2026 | issue | SO-260210-531 | MAIN | 6 | 27.48 | -164.89 | 131 | 3,600.04 | Dec. 24, 2025: 6 @ 27.48 |
| Feb. 8, 2026 | return | RMA | MAIN | 4 | 27.48 | 109.92 | 137 | 3,764.92 | |
| Feb. 7, 2026 | issue | SO-260207-965 | MAIN | 32 | 27.48 | -879.40 | 133 | 3,655.00 | Dec. 24, 2025: 32 @ 27.48 |
| Feb. 1, 2026 | issue | SO-260201-648 | MAIN | 8 | 27.48 | -219.85 | 165 | 4,534.40 | Dec. 24, 2025: 8 @ 27.48 |
| Jan. 22, 2026 | issue | SO-260122-458 | MAIN | 36 | 27.48 | -989.32 | 173 | 4,754.25 | Dec. 24, 2025: 36 @ 27.48 |
| Jan. 19, 2026 | issue | SO-260119-161 | MAIN | 2 | 27.48 | -54.96 | 209 | 5,743.57 | Dec. 24, 2025: 2 @ 27.48 |
| Jan. 17, 2026 | issue | SO-260117-422 | MAIN | 10 | 27.48 | -274.81 | 211 | 5,798.53 | Dec. 24, 2025: 10 @ 27.48 |
| Jan. 10, 2026 | issue | SO-260110-913 | MAIN | 7 | 27.48 | -192.37 | 221 | 6,073.35 | Dec. 24, 2025: 7 @ 27.48 |
| Jan. 10, 2026 | issue | SO-260110-913 | EAST | 16 | 27.68 | -442.96 | 228 | 6,265.71 | Oct. 1, 2025: 4 @ 28.30; Dec. 24, 2025: 12 @ 27.48 |
| Jan. 4, 2026 | issue | SO-260104-757 | MAIN | 5 | 28.30 | -141.48 | 244 | 6,708.67 | Oct. 1, 2025: 5 @ 28.30 |
| Dec. 30, 2025 | issue | SO-251230-576 | MAIN | 7 | 28.30 | -198.07 | 249 | 6,850.15 | Oct. 1, 2025: 7 @ 28.30 |
| Dec. 24, 2025 | receipt | PO-001083 | MAIN | 240 | 27.48 | 6,595.49 | 256 | 7,048.22 | |
| Dec. 18, 2025 | issue | SO-251218-584 | EAST | 38 | 28.30 | -1,075.24 | 16 | 452.73 | Oct. 1, 2025: 38 @ 28.30 |
| Dec. 11, 2025 | issue | SO-251211-224 | EAST | 15 | 28.30 | -424.44 | 54 | 1,527.98 | Oct. 1, 2025: 15 @ 28.30 |
| Nov. 18, 2025 | issue | SO-251118-370 | EAST | 12 | 28.30 | -339.55 | 69 | 1,952.42 | Oct. 1, 2025: 12 @ 28.30 |