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
| 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 |
| Sept. 8, 2025 | issue | SO-250908-668 | MAIN | 19 | 8.35 | -158.68 | 161 | 1,344.62 | June 12, 2025: 19 @ 8.35 |
| Sept. 2, 2025 | issue | SO-250902-574 | MAIN | 1 | 8.35 | -8.35 | 180 | 1,503.31 | June 12, 2025: 1 @ 8.35 |
| Aug. 30, 2025 | issue | SO-250830-992 | MAIN | 7 | 8.35 | -58.46 | 181 | 1,511.66 | June 12, 2025: 7 @ 8.35 |
| Aug. 28, 2025 | issue | SO-250828-467 | MAIN | 19 | 8.35 | -158.68 | 188 | 1,570.12 | June 12, 2025: 19 @ 8.35 |
| Aug. 25, 2025 | issue | SO-250825-750 | MAIN | 6 | 8.35 | -50.11 | 207 | 1,728.80 | June 12, 2025: 6 @ 8.35 |
| Aug. 21, 2025 | issue | SO-250821-995 | MAIN | 14 | 8.35 | -116.92 | 213 | 1,778.91 | June 12, 2025: 14 @ 8.35 |
| Aug. 20, 2025 | return | RMA | MAIN | 22 | 8.35 | 183.74 | 227 | 1,895.84 | |
| Aug. 8, 2025 | issue | SO-250808-425 | MAIN | 27 | 8.35 | -225.50 | 205 | 1,712.10 | June 12, 2025: 27 @ 8.35 |
| Aug. 5, 2025 | issue | SO-250805-496 | MAIN | 45 | 8.35 | -375.83 | 232 | 1,937.59 | June 12, 2025: 45 @ 8.35 |
| Aug. 3, 2025 | issue | SO-250803-617 | MAIN | 11 | 8.35 | -91.87 | 277 | 2,313.42 | June 12, 2025: 11 @ 8.35 |
| July 24, 2025 | issue | SO-250724-454 | MAIN | 31 | 8.35 | -258.90 | 288 | 2,405.29 | June 12, 2025: 31 @ 8.35 |
| July 19, 2025 | issue | SO-250719-792 | MAIN | 44 | 8.35 | -367.47 | 319 | 2,664.19 | June 12, 2025: 44 @ 8.35 |
| June 13, 2025 | issue | SO-250613-339 | MAIN | 54 | 8.19 | -442.23 | 363 | 3,031.67 | March 25, 2025: 36 @ 8.12; May 11, 2025: 1 @ 8.12; June 12, 2025: 17 @ 8.35 |
| June 12, 2025 | receipt | PO-000630 | MAIN | 380 | 8.35 | 3,173.65 | 417 | 3,473.90 | |
| June 3, 2025 | issue | SO-250603-658 | MAIN | 24 | 8.12 | -194.76 | 37 | 300.26 | March 25, 2025: 24 @ 8.12 |
| June 3, 2025 | issue | SO-250603-658 | EAST | 93 | 8.12 | -754.70 | 61 | 495.02 | March 25, 2025: 93 @ 8.12 |
| May 13, 2025 | issue | SO-250513-977 | MAIN | 57 | 8.12 | -462.56 | 154 | 1,249.71 | March 25, 2025: 57 @ 8.12 |
| May 11, 2025 | return | RMA | MAIN | 1 | 8.12 | 8.12 | 211 | 1,712.26 | |
| May 6, 2025 | issue | SO-250506-819 | EAST | 26 | 8.12 | -210.99 | 210 | 1,704.15 | March 25, 2025: 26 @ 8.12 |
| May 1, 2025 | issue | SO-250501-496 | MAIN | 55 | 8.12 | -446.32 | 236 | 1,915.14 | March 25, 2025: 55 @ 8.12 |
| April 30, 2025 | issue | SO-250430-612 | MAIN | 2 | 8.12 | -16.23 | 291 | 2,361.46 | March 25, 2025: 2 @ 8.12 |
| April 19, 2025 | issue | SO-250419-566 | MAIN | 13 | 8.12 | -105.50 | 293 | 2,377.70 | March 25, 2025: 13 @ 8.12 |
| April 13, 2025 | issue | SO-250413-100 | MAIN | 74 | 8.12 | -600.51 | 306 | 2,483.19 | March 25, 2025: 74 @ 8.12 |
| March 25, 2025 | transfer | TRF | MAIN → EAST | 119 | warehouse transfer, no cost effect | ||||
| March 25, 2025 | receipt | PO-000379 | MAIN | 380 | 8.12 | 3,083.70 | 380 | 3,083.70 | |
| March 18, 2025 | issue | SO-250318-469 | MAIN | 60 | 8.33 | -499.79 | 0 | 0.00 | Dec. 20, 2024: 60 @ 8.33 |
| March 12, 2025 | issue | SO-250312-971 | MAIN | 27 | 8.33 | -224.91 | 60 | 499.79 | Dec. 20, 2024: 27 @ 8.33 |
| March 2, 2025 | issue | SO-250302-734 | MAIN | 18 | 8.33 | -149.94 | 87 | 724.70 | Dec. 20, 2024: 18 @ 8.33 |
| Feb. 12, 2025 | issue | SO-250212-338 | MAIN | 71 | 8.33 | -591.42 | 105 | 874.64 | Dec. 20, 2024: 71 @ 8.33 |
| Feb. 7, 2025 | issue | SO-250207-780 | MAIN | 89 | 8.33 | -741.36 | 176 | 1,466.06 | Dec. 20, 2024: 89 @ 8.33 |
| Jan. 26, 2025 | issue | SO-250126-818 | MAIN | 63 | 8.33 | -524.78 | 265 | 2,207.42 | Dec. 20, 2024: 63 @ 8.33 |
| Jan. 21, 2025 | issue | SO-250121-233 | MAIN | 9 | 8.33 | -74.97 | 328 | 2,732.21 | Dec. 20, 2024: 9 @ 8.33 |
| Jan. 16, 2025 | issue | SO-250116-737 | MAIN | 37 | 8.33 | -308.21 | 337 | 2,807.18 | Dec. 20, 2024: 37 @ 8.33 |
| Jan. 15, 2025 | issue | SO-250115-883 | MAIN | 1 | 8.33 | -8.33 | 374 | 3,115.38 | Dec. 20, 2024: 1 @ 8.33 |
| Jan. 3, 2025 | issue | SO-250103-939 | MAIN | 15 | 8.36 | -125.34 | 375 | 3,123.71 | Oct. 1, 2024: 10 @ 8.37; Dec. 20, 2024: 5 @ 8.33 |
| Dec. 21, 2024 | issue | SO-241221-383 | MAIN | 32 | 8.37 | -267.82 | 390 | 3,249.06 | Oct. 1, 2024: 32 @ 8.37 |
| Dec. 20, 2024 | receipt | PO-000121 | MAIN | 380 | 8.33 | 3,165.36 | 422 | 3,516.88 | |
| Dec. 10, 2024 | issue | SO-241210-954 | MAIN | 43 | 8.37 | -359.89 | 42 | 351.52 | Oct. 1, 2024: 43 @ 8.37 |
| Dec. 2, 2024 | issue | SO-241202-103 | MAIN | 61 | 8.37 | -510.54 | 85 | 711.41 | Oct. 1, 2024: 61 @ 8.37 |
| Nov. 17, 2024 | issue | SO-241117-495 | MAIN | 65 | 8.37 | -544.02 | 146 | 1,221.95 | Oct. 1, 2024: 65 @ 8.37 |
| Nov. 13, 2024 | issue | SO-241113-502 | MAIN | 33 | 8.37 | -276.19 | 211 | 1,765.96 | Oct. 1, 2024: 33 @ 8.37 |
| Nov. 9, 2024 | issue | SO-241109-181 | MAIN | 14 | 8.37 | -117.17 | 244 | 2,042.16 | Oct. 1, 2024: 14 @ 8.37 |
| Nov. 8, 2024 | issue | SO-241108-931 | MAIN | 9 | 8.37 | -75.33 | 258 | 2,159.33 | Oct. 1, 2024: 9 @ 8.37 |
| Nov. 8, 2024 | issue | SO-241108-931 | EAST | 5 | 8.37 | -41.85 | 267 | 2,234.66 | Oct. 1, 2024: 5 @ 8.37 |
| Oct. 31, 2024 | issue | SO-241031-397 | MAIN | 29 | 8.37 | -242.72 | 272 | 2,276.50 | Oct. 1, 2024: 29 @ 8.37 |
| Oct. 29, 2024 | issue | SO-241029-706 | EAST | 15 | 8.37 | -125.54 | 301 | 2,519.22 | Oct. 1, 2024: 15 @ 8.37 |
| Oct. 28, 2024 | issue | SO-241028-696 | MAIN | 4 | 8.37 | -33.48 | 316 | 2,644.76 | Oct. 1, 2024: 4 @ 8.37 |
| Oct. 24, 2024 | issue | SO-241024-479 | EAST | 30 | 8.37 | -251.08 | 320 | 2,678.24 | Oct. 1, 2024: 30 @ 8.37 |
| Oct. 16, 2024 | issue | SO-241016-992 | EAST | 1 | 8.37 | -8.37 | 350 | 2,929.32 | Oct. 1, 2024: 1 @ 8.37 |
| Oct. 11, 2024 | issue | SO-241011-743 | EAST | 23 | 8.37 | -192.50 | 351 | 2,937.69 | Oct. 1, 2024: 23 @ 8.37 |
| Oct. 5, 2024 | issue | SO-241005-123 | EAST | 6 | 8.37 | -50.22 | 374 | 3,130.19 | Oct. 1, 2024: 6 @ 8.37 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 80 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 380 | 8.37 | 3,180.41 | 380 | 3,180.41 | |