Items / SWT-0034
Switch Plate 4M Elite SWT-0034 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)85MAIN 85
Value (FIFO)670.87avg 7.89
ClassCX / FCV 0.13
Turnover7.4xlast issue 4 days ago
Days of cover29lead 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 | 89.58 / 30.4375 | 2.943 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 11.96 / 5.517 | 2.168 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.900) | 1.282 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.282 * sqrt(7.0 * 2.168^2 + 2.943^2 * 1.5^2) | 9.4 |
| Reorder point | d * LT + safety stock | 2.943 * 7.0 + 9.4 | 29.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 29.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1074/yr, S = 45.00, h = 20%, price = 7.30 | 960.0 |
| Inventory position | on hand + on order | 85 + 0 | 85 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 7.93 | 247 | 8,911 | yes |
| 480 | 7.61 | 480 | 8,644 | yes |
| 960 | 7.30 | 960 | 8,588 | yes (chosen if cheapest) |
MOQ 240, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 14, 2026 | 85 / 240 | 7.89 | 670.87 |
Movement ledger 126 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-864 | MAIN | 1 | 7.89 | -7.89 | 85 | 670.87 | Aug. 14, 2026: 1 @ 7.89 |
| Oct. 5, 2026 | issue | SO-261005-554 | MAIN | 9 | 7.89 | -71.03 | 86 | 678.76 | Aug. 14, 2026: 9 @ 7.89 |
| Oct. 4, 2026 | issue | SO-261004-104 | MAIN | 30 | 7.89 | -236.78 | 95 | 749.80 | Aug. 14, 2026: 30 @ 7.89 |
| Oct. 3, 2026 | issue | SO-261003-991 | MAIN | 29 | 7.89 | -228.89 | 125 | 986.58 | Aug. 14, 2026: 29 @ 7.89 |
| Oct. 1, 2026 | issue | SO-261001-695 | MAIN | 3 | 7.89 | -23.68 | 154 | 1,215.46 | Aug. 14, 2026: 3 @ 7.89 |
| Sept. 13, 2026 | issue | SO-260913-840 | MAIN | 21 | 7.89 | -165.74 | 157 | 1,239.14 | Aug. 14, 2026: 21 @ 7.89 |
| Sept. 4, 2026 | issue | SO-260904-958 | MAIN | 4 | 7.89 | -31.57 | 178 | 1,404.88 | Aug. 14, 2026: 4 @ 7.89 |
| Sept. 4, 2026 | issue | SO-260904-958 | EAST | 67 | 7.86 | -526.49 | 182 | 1,436.45 | June 7, 2026: 9 @ 7.64; Aug. 14, 2026: 58 @ 7.89 |
| Aug. 14, 2026 | transfer | TRF | MAIN → EAST | 67 | warehouse transfer, no cost effect | ||||
| Aug. 14, 2026 | receipt | PO-001720 | MAIN | 240 | 7.89 | 1,894.22 | 249 | 1,962.94 | |
| Aug. 8, 2026 | issue | SO-260808-440 | MAIN | 21 | 7.64 | -160.34 | 9 | 68.72 | June 7, 2026: 21 @ 7.64 |
| Aug. 4, 2026 | issue | SO-260804-279 | MAIN | 78 | 7.64 | -595.55 | 30 | 229.06 | June 7, 2026: 78 @ 7.64 |
| July 31, 2026 | issue | SO-260731-721 | MAIN | 31 | 7.64 | -236.69 | 108 | 824.61 | June 7, 2026: 31 @ 7.64 |
| July 23, 2026 | issue | SO-260723-636 | MAIN | 18 | 7.64 | -137.44 | 139 | 1,061.31 | June 7, 2026: 18 @ 7.64 |
| July 21, 2026 | issue | SO-260721-960 | MAIN | 24 | 7.64 | -183.25 | 157 | 1,198.74 | June 7, 2026: 24 @ 7.64 |
| July 12, 2026 | issue | SO-260712-329 | MAIN | 1 | 7.64 | -7.64 | 181 | 1,381.99 | June 7, 2026: 1 @ 7.64 |
| July 8, 2026 | issue | SO-260708-214 | MAIN | 15 | 7.64 | -114.53 | 182 | 1,389.62 | June 7, 2026: 15 @ 7.64 |
| June 14, 2026 | issue | SO-260614-161 | MAIN | 43 | 7.64 | -328.32 | 197 | 1,504.15 | June 7, 2026: 43 @ 7.64 |
| June 7, 2026 | receipt | PO-001555 | MAIN | 240 | 7.64 | 1,832.47 | 240 | 1,832.47 | |
| June 5, 2026 | issue | SO-260605-354 | MAIN | 28 | 7.88 | -220.69 | 0 | 0.00 | March 16, 2026: 28 @ 7.88 |
| June 2, 2026 | issue | SO-260602-173 | MAIN | 15 | 7.88 | -118.23 | 28 | 220.69 | March 16, 2026: 15 @ 7.88 |
| May 21, 2026 | issue | SO-260521-735 | MAIN | 13 | 7.88 | -102.46 | 43 | 338.92 | March 16, 2026: 13 @ 7.88 |
| May 20, 2026 | issue | SO-260520-725 | MAIN | 13 | 7.88 | -102.46 | 56 | 441.38 | March 16, 2026: 13 @ 7.88 |
| May 15, 2026 | issue | SO-260515-225 | MAIN | 13 | 7.88 | -102.46 | 69 | 543.84 | March 16, 2026: 13 @ 7.88 |
| May 12, 2026 | issue | SO-260512-942 | MAIN | 8 | 7.88 | -63.05 | 82 | 646.31 | March 16, 2026: 8 @ 7.88 |
| May 11, 2026 | issue | SO-260511-208 | MAIN | 27 | 7.88 | -212.81 | 90 | 709.36 | March 16, 2026: 27 @ 7.88 |
| April 28, 2026 | issue | SO-260428-138 | MAIN | 8 | 7.88 | -63.05 | 117 | 922.17 | March 16, 2026: 8 @ 7.88 |
| April 27, 2026 | issue | SO-260427-523 | MAIN | 1 | 7.88 | -7.88 | 125 | 985.22 | March 16, 2026: 1 @ 7.88 |
| April 24, 2026 | issue | SO-260424-353 | MAIN | 1 | 7.88 | -7.88 | 126 | 993.11 | March 16, 2026: 1 @ 7.88 |
| April 18, 2026 | issue | SO-260418-141 | MAIN | 18 | 7.88 | -141.87 | 127 | 1,000.99 | March 16, 2026: 18 @ 7.88 |
| April 15, 2026 | issue | SO-260415-920 | MAIN | 4 | 7.88 | -31.53 | 145 | 1,142.86 | March 16, 2026: 4 @ 7.88 |
| April 14, 2026 | issue | SO-260414-494 | MAIN | 12 | 7.88 | -94.58 | 149 | 1,174.39 | March 16, 2026: 12 @ 7.88 |
| April 2, 2026 | issue | SO-260402-426 | MAIN | 27 | 7.88 | -212.81 | 161 | 1,268.97 | March 16, 2026: 27 @ 7.88 |
| March 25, 2026 | issue | SO-260325-194 | MAIN | 14 | 7.88 | -110.35 | 188 | 1,481.78 | March 16, 2026: 14 @ 7.88 |
| March 25, 2026 | issue | SO-260325-194 | EAST | 69 | 7.78 | -536.89 | 202 | 1,592.12 | Jan. 2, 2026: 31 @ 7.66; March 16, 2026: 38 @ 7.88 |
| March 16, 2026 | transfer | TRF | MAIN → EAST | 69 | warehouse transfer, no cost effect | ||||
| March 16, 2026 | receipt | PO-001324 | MAIN | 240 | 7.88 | 1,891.63 | 271 | 2,129.02 | |
| March 9, 2026 | issue | SO-260309-247 | MAIN | 7 | 7.66 | -53.60 | 31 | 237.39 | Jan. 2, 2026: 7 @ 7.66 |
| March 7, 2026 | issue | SO-260307-340 | MAIN | 3 | 7.66 | -22.97 | 38 | 290.99 | Jan. 2, 2026: 3 @ 7.66 |
| March 3, 2026 | issue | SO-260303-937 | MAIN | 7 | 7.66 | -53.60 | 41 | 313.96 | Jan. 2, 2026: 7 @ 7.66 |
| Feb. 25, 2026 | issue | SO-260225-391 | MAIN | 18 | 7.66 | -137.84 | 48 | 367.56 | Jan. 2, 2026: 18 @ 7.66 |
| Feb. 20, 2026 | issue | SO-260220-540 | MAIN | 33 | 7.66 | -252.70 | 66 | 505.40 | Jan. 2, 2026: 33 @ 7.66 |
| Feb. 16, 2026 | issue | SO-260216-138 | MAIN | 17 | 7.66 | -130.18 | 99 | 758.10 | Jan. 2, 2026: 17 @ 7.66 |
| Feb. 10, 2026 | issue | SO-260210-303 | MAIN | 15 | 7.66 | -114.86 | 116 | 888.28 | Jan. 2, 2026: 15 @ 7.66 |
| Jan. 18, 2026 | issue | SO-260118-923 | MAIN | 3 | 7.66 | -22.97 | 131 | 1,003.15 | Jan. 2, 2026: 3 @ 7.66 |
| Jan. 11, 2026 | issue | SO-260111-615 | MAIN | 25 | 7.66 | -191.44 | 134 | 1,026.12 | Jan. 2, 2026: 25 @ 7.66 |
| Jan. 4, 2026 | issue | SO-260104-285 | MAIN | 12 | 7.66 | -91.89 | 159 | 1,217.56 | Jan. 2, 2026: 12 @ 7.66 |
| Jan. 3, 2026 | issue | SO-260103-734 | MAIN | 78 | 7.64 | -595.61 | 171 | 1,309.45 | Sept. 28, 2025: 3 @ 7.47; Oct. 11, 2025: 6 @ 7.47; Jan. 2, 2026: 69 @ 7.66 |
| Jan. 2, 2026 | receipt | PO-001114 | MAIN | 240 | 7.66 | 1,837.82 | 249 | 1,905.06 | |
| Dec. 25, 2025 | issue | SO-251225-574 | MAIN | 35 | 7.47 | -261.47 | 9 | 67.24 | Sept. 28, 2025: 35 @ 7.47 |
| Dec. 24, 2025 | issue | SO-251224-920 | MAIN | 3 | 7.47 | -22.41 | 44 | 328.71 | Sept. 28, 2025: 3 @ 7.47 |
| Dec. 17, 2025 | issue | SO-251217-201 | MAIN | 9 | 7.47 | -67.24 | 47 | 351.13 | Sept. 28, 2025: 9 @ 7.47 |
| Dec. 7, 2025 | issue | SO-251207-768 | MAIN | 30 | 7.47 | -224.12 | 56 | 418.36 | Sept. 28, 2025: 30 @ 7.47 |
| Dec. 5, 2025 | issue | SO-251205-104 | MAIN | 6 | 7.47 | -44.82 | 86 | 642.48 | Sept. 28, 2025: 6 @ 7.47 |
| Nov. 23, 2025 | issue | SO-251123-641 | MAIN | 47 | 7.47 | -351.12 | 92 | 687.31 | Sept. 28, 2025: 47 @ 7.47 |
| Nov. 12, 2025 | issue | SO-251112-152 | MAIN | 46 | 7.47 | -343.65 | 139 | 1,038.43 | Sept. 28, 2025: 46 @ 7.47 |
| Oct. 26, 2025 | issue | SO-251026-275 | MAIN | 20 | 7.47 | -149.41 | 185 | 1,382.08 | Sept. 28, 2025: 20 @ 7.47 |
| Oct. 21, 2025 | issue | SO-251021-564 | MAIN | 1 | 7.47 | -7.47 | 205 | 1,531.50 | Sept. 28, 2025: 1 @ 7.47 |
| Oct. 18, 2025 | issue | SO-251018-923 | MAIN | 22 | 7.47 | -164.36 | 206 | 1,538.97 | Sept. 28, 2025: 22 @ 7.47 |
| Oct. 16, 2025 | issue | SO-251016-492 | MAIN | 44 | 7.47 | -328.73 | 228 | 1,703.32 | July 6, 2025: 25 @ 7.47; Sept. 11, 2025: 1 @ 7.47; Sept. 28, 2025: 18 @ 7.47 |