Items / SWT-0018
Switch Plate 4M Plus SWT-0018 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)95MAIN 95
Value (FIFO)1,176.20avg 12.38
ClassAX / FCV 0.24
Turnover16.5xlast issue 1 days ago
Days of cover12lead time 7d
Reorder suggested: 690 units (position at or below reorder point: order EOQ), stockout risk low.
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 | 233.08 / 30.4375 | 7.658 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 55.59 / 5.517 | 10.076 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(7.0 * 10.076^2 + 7.658^2 * 1.5^2) | 59.8 |
| Reorder point | d * LT + safety stock | 7.658 * 7.0 + 59.8 | 113.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 113.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2795/yr, S = 45.00, h = 20%, price = 12.17 | 321.5 |
| Inventory position | on hand + on order | 95 + 0 | 95 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 12.17 | 321 | 34,799 | yes (chosen if cheapest) |
MOQ 690, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 9, 2026 | 71 / 690 | 12.38 | 879.05 | |
| Sept. 11, 2026 | 24 / 24 | 12.38 | 297.14 |
Movement ledger 133 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-895 | MAIN | 78 | 12.38 | -965.72 | 95 | 1,176.20 | July 9, 2026: 78 @ 12.38 |
| Oct. 14, 2026 | issue | SO-261014-337 | MAIN | 4 | 12.38 | -49.52 | 173 | 2,141.91 | July 9, 2026: 4 @ 12.38 |
| Oct. 13, 2026 | issue | SO-261013-186 | MAIN | 13 | 12.38 | -160.95 | 177 | 2,191.44 | July 9, 2026: 13 @ 12.38 |
| Oct. 10, 2026 | issue | SO-261010-928 | MAIN | 6 | 12.38 | -74.29 | 190 | 2,352.39 | July 9, 2026: 6 @ 12.38 |
| Oct. 5, 2026 | issue | SO-261005-402 | MAIN | 46 | 12.38 | -569.53 | 196 | 2,426.68 | July 9, 2026: 46 @ 12.38 |
| Sept. 23, 2026 | issue | SO-260923-179 | MAIN | 157 | 12.38 | -1,943.82 | 242 | 2,996.20 | July 9, 2026: 157 @ 12.38 |
| Sept. 15, 2026 | issue | SO-260915-557 | MAIN | 14 | 12.38 | -173.33 | 399 | 4,940.02 | July 9, 2026: 14 @ 12.38 |
| Sept. 11, 2026 | return | RMA | MAIN | 24 | 12.38 | 297.14 | 413 | 5,113.35 | |
| Sept. 2, 2026 | issue | SO-260902-571 | MAIN | 8 | 12.38 | -99.05 | 389 | 4,816.21 | July 9, 2026: 8 @ 12.38 |
| Sept. 1, 2026 | issue | SO-260901-421 | MAIN | 48 | 12.38 | -594.29 | 397 | 4,915.26 | July 9, 2026: 48 @ 12.38 |
| Aug. 31, 2026 | issue | SO-260831-495 | MAIN | 131 | 12.38 | -1,621.91 | 445 | 5,509.54 | July 9, 2026: 131 @ 12.38 |
| Aug. 23, 2026 | issue | SO-260823-226 | MAIN | 85 | 12.38 | -1,052.38 | 576 | 7,131.46 | July 9, 2026: 85 @ 12.38 |
| Aug. 23, 2026 | issue | SO-260823-226 | EAST | 1 | 12.38 | -12.38 | 661 | 8,183.84 | July 9, 2026: 1 @ 12.38 |
| Aug. 8, 2026 | issue | SO-260808-204 | MAIN | 22 | 12.38 | -272.38 | 662 | 8,196.22 | July 9, 2026: 22 @ 12.38 |
| July 29, 2026 | issue | SO-260729-186 | MAIN | 16 | 12.22 | -195.50 | 684 | 8,468.60 | April 28, 2026: 10 @ 12.12; July 9, 2026: 6 @ 12.38 |
| July 24, 2026 | issue | SO-260724-695 | MAIN | 18 | 12.12 | -218.18 | 700 | 8,664.10 | April 28, 2026: 18 @ 12.12 |
| July 20, 2026 | issue | SO-260720-762 | MAIN | 3 | 12.12 | -36.36 | 718 | 8,882.28 | April 28, 2026: 3 @ 12.12 |
| July 13, 2026 | issue | SO-260713-279 | EAST | 23 | 12.12 | -278.78 | 721 | 8,918.64 | April 28, 2026: 23 @ 12.12 |
| July 9, 2026 | receipt | PO-001637 | MAIN | 690 | 12.38 | 8,542.89 | 744 | 9,197.42 | |
| July 4, 2026 | issue | SO-260704-229 | MAIN | 122 | 12.12 | -1,478.76 | 54 | 654.53 | April 28, 2026: 122 @ 12.12 |
| July 1, 2026 | issue | SO-260701-966 | MAIN | 147 | 12.12 | -1,781.79 | 176 | 2,133.30 | April 28, 2026: 147 @ 12.12 |
| June 16, 2026 | issue | SO-260616-149 | MAIN | 41 | 12.12 | -496.96 | 323 | 3,915.08 | April 28, 2026: 41 @ 12.12 |
| June 6, 2026 | issue | SO-260606-488 | MAIN | 114 | 12.12 | -1,381.79 | 364 | 4,412.04 | April 28, 2026: 114 @ 12.12 |
| June 5, 2026 | issue | SO-260605-634 | EAST | 32 | 12.12 | -387.87 | 478 | 5,793.84 | April 28, 2026: 32 @ 12.12 |
| May 18, 2026 | issue | SO-260518-404 | EAST | 105 | 12.12 | -1,272.70 | 510 | 6,181.71 | April 28, 2026: 105 @ 12.12 |
| May 16, 2026 | issue | SO-260516-471 | MAIN | 62 | 12.12 | -751.50 | 615 | 7,454.42 | April 28, 2026: 62 @ 12.12 |
| May 2, 2026 | issue | SO-260502-319 | MAIN | 42 | 12.01 | -504.29 | 677 | 8,205.92 | Feb. 2, 2026: 23 @ 12.03; March 23, 2026: 6 @ 11.67; April 28, 2026: 13 @ 12.12 |
| April 28, 2026 | transfer | TRF | MAIN → EAST | 161 | warehouse transfer, no cost effect | ||||
| April 28, 2026 | receipt | PO-001449 | MAIN | 690 | 12.12 | 8,363.49 | 719 | 8,710.21 | |
| April 20, 2026 | issue | SO-260420-708 | MAIN | 261 | 11.68 | -3,048.49 | 29 | 346.72 | Feb. 1, 2026: 252 @ 11.67; Feb. 2, 2026: 9 @ 12.03 |
| April 19, 2026 | issue | SO-260419-811 | MAIN | 31 | 11.67 | -361.69 | 290 | 3,395.21 | Feb. 1, 2026: 31 @ 11.67 |
| March 29, 2026 | issue | SO-260329-197 | MAIN | 128 | 11.67 | -1,493.44 | 321 | 3,756.90 | Feb. 1, 2026: 128 @ 11.67 |
| March 27, 2026 | issue | SO-260327-834 | MAIN | 7 | 11.67 | -81.67 | 449 | 5,250.34 | Feb. 1, 2026: 7 @ 11.67 |
| March 23, 2026 | return | RMA | MAIN | 6 | 11.67 | 70.00 | 456 | 5,332.01 | |
| March 19, 2026 | issue | SO-260319-650 | MAIN | 21 | 11.67 | -245.02 | 450 | 5,262.01 | Feb. 1, 2026: 21 @ 11.67 |
| March 14, 2026 | issue | SO-260314-835 | MAIN | 1 | 11.67 | -11.67 | 471 | 5,507.02 | Feb. 1, 2026: 1 @ 11.67 |
| March 8, 2026 | issue | SO-260308-765 | MAIN | 12 | 11.67 | -140.01 | 472 | 5,518.69 | Feb. 1, 2026: 12 @ 11.67 |
| Feb. 26, 2026 | issue | SO-260226-909 | MAIN | 113 | 11.67 | -1,318.43 | 484 | 5,658.70 | Feb. 1, 2026: 113 @ 11.67 |
| Feb. 22, 2026 | issue | SO-260222-596 | MAIN | 35 | 11.67 | -408.36 | 597 | 6,977.13 | Feb. 1, 2026: 35 @ 11.67 |
| Feb. 16, 2026 | issue | SO-260216-854 | MAIN | 57 | 11.67 | -665.05 | 632 | 7,385.49 | Feb. 1, 2026: 57 @ 11.67 |
| Feb. 9, 2026 | issue | SO-260209-334 | MAIN | 33 | 11.67 | -385.03 | 689 | 8,050.54 | Feb. 1, 2026: 33 @ 11.67 |
| Feb. 2, 2026 | return | RMA | MAIN | 32 | 12.03 | 384.99 | 722 | 8,435.57 | |
| Feb. 1, 2026 | receipt | PO-001191 | MAIN | 690 | 11.67 | 8,050.58 | 690 | 8,050.58 | |
| Jan. 28, 2026 | issue | SO-260128-688 | EAST | 7 | 12.03 | -84.22 | 0 | 0.00 | Oct. 27, 2025: 4 @ 12.03; Nov. 14, 2025: 3 @ 12.03 |
| Jan. 27, 2026 | issue | SO-260127-981 | EAST | 62 | 12.03 | -745.92 | 7 | 84.22 | Oct. 27, 2025: 62 @ 12.03 |
| Jan. 27, 2026 | issue | SO-260127-981 | MAIN | 64 | 12.03 | -769.98 | 69 | 830.14 | Oct. 27, 2025: 64 @ 12.03 |
| Jan. 22, 2026 | issue | SO-260122-730 | EAST | 39 | 12.03 | -469.21 | 133 | 1,600.12 | Oct. 27, 2025: 39 @ 12.03 |
| Dec. 31, 2025 | issue | SO-251231-242 | MAIN | 6 | 12.03 | -72.19 | 172 | 2,069.33 | Oct. 27, 2025: 6 @ 12.03 |
| Dec. 24, 2025 | issue | SO-251224-284 | MAIN | 80 | 12.03 | -962.48 | 178 | 2,141.52 | Oct. 27, 2025: 80 @ 12.03 |
| Dec. 21, 2025 | issue | SO-251221-203 | MAIN | 15 | 12.03 | -180.46 | 258 | 3,104.00 | Oct. 27, 2025: 15 @ 12.03 |
| Dec. 9, 2025 | issue | SO-251209-807 | MAIN | 43 | 12.03 | -517.33 | 273 | 3,284.46 | Oct. 27, 2025: 43 @ 12.03 |
| Dec. 8, 2025 | issue | SO-251208-917 | EAST | 19 | 12.03 | -228.59 | 316 | 3,801.80 | Oct. 27, 2025: 19 @ 12.03 |
| Dec. 5, 2025 | issue | SO-251205-356 | MAIN | 37 | 12.03 | -445.15 | 335 | 4,030.38 | Oct. 27, 2025: 37 @ 12.03 |
| Nov. 20, 2025 | issue | SO-251120-283 | MAIN | 74 | 12.03 | -890.29 | 372 | 4,475.53 | Oct. 27, 2025: 74 @ 12.03 |
| Nov. 14, 2025 | return | RMA | MAIN | 3 | 12.03 | 36.09 | 446 | 5,365.83 | |
| Nov. 13, 2025 | issue | SO-251113-686 | MAIN | 175 | 12.03 | -2,105.42 | 443 | 5,329.73 | Oct. 27, 2025: 175 @ 12.03 |
| Nov. 9, 2025 | issue | SO-251109-493 | EAST | 16 | 12.03 | -192.50 | 618 | 7,435.16 | Oct. 27, 2025: 16 @ 12.03 |
| Nov. 2, 2025 | issue | SO-251102-269 | MAIN | 7 | 12.03 | -84.22 | 634 | 7,627.65 | Oct. 27, 2025: 7 @ 12.03 |
| Oct. 30, 2025 | issue | SO-251030-683 | MAIN | 49 | 12.03 | -589.52 | 641 | 7,711.87 | Oct. 27, 2025: 49 @ 12.03 |
| Oct. 29, 2025 | issue | SO-251029-894 | MAIN | 66 | 11.47 | -757.31 | 690 | 8,301.39 | July 31, 2025: 66 @ 11.47 |