Items / SWT-0021
Dimmer Switch Plus SWT-0021 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)74MAIN 74
Value (FIFO)937.05avg 12.66
ClassCX / FCV 0.19
Turnover10.0xlast issue 7 days ago
Days of cover52lead 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 | 43.08 / 30.4375 | 1.415 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 8.13 / 5.517 | 1.473 |
| 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 * 1.473^2 + 1.415^2 * 1.5^2) | 5.7 |
| Reorder point | d * LT + safety stock | 1.415 * 7.0 + 5.7 | 15.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 15.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 517/yr, S = 45.00, h = 20%, price = 12.82 | 134.7 |
| Inventory position | on hand + on order | 74 + 0 | 74 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 12.82 | 135 | 6,969 | yes (chosen if cheapest) |
MOQ 150, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 16, 2026 | 74 / 150 | 12.66 | 937.05 |
Movement ledger 134 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 9, 2026 | issue | SO-261009-836 | MAIN | 35 | 12.66 | -443.20 | 74 | 937.05 | Sept. 16, 2026: 35 @ 12.66 |
| Oct. 8, 2026 | issue | SO-261008-902 | MAIN | 18 | 12.66 | -227.93 | 109 | 1,380.25 | Sept. 16, 2026: 18 @ 12.66 |
| Sept. 28, 2026 | issue | SO-260928-394 | MAIN | 21 | 12.66 | -265.92 | 127 | 1,608.18 | Sept. 16, 2026: 21 @ 12.66 |
| Sept. 27, 2026 | issue | SO-260927-447 | MAIN | 1 | 12.66 | -12.66 | 148 | 1,874.09 | Sept. 16, 2026: 1 @ 12.66 |
| Sept. 27, 2026 | issue | SO-260927-447 | EAST | 1 | 12.66 | -12.66 | 149 | 1,886.76 | Sept. 16, 2026: 1 @ 12.66 |
| Sept. 26, 2026 | issue | SO-260926-153 | MAIN | 1 | 12.98 | -12.98 | 150 | 1,899.42 | Aug. 12, 2026: 1 @ 12.98 |
| Sept. 19, 2026 | issue | SO-260919-451 | EAST | 12 | 12.98 | -155.76 | 151 | 1,912.40 | June 6, 2026: 11 @ 12.98; Aug. 12, 2026: 1 @ 12.98 |
| Sept. 16, 2026 | receipt | PO-001804 | MAIN | 150 | 12.66 | 1,899.42 | 163 | 2,068.16 | |
| Sept. 9, 2026 | issue | SO-260909-714 | EAST | 15 | 12.98 | -194.70 | 13 | 168.74 | June 6, 2026: 15 @ 12.98 |
| Sept. 4, 2026 | issue | SO-260904-451 | EAST | 1 | 12.98 | -12.98 | 28 | 363.44 | June 6, 2026: 1 @ 12.98 |
| Sept. 4, 2026 | issue | SO-260904-451 | MAIN | 1 | 12.98 | -12.98 | 29 | 376.42 | June 6, 2026: 1 @ 12.98 |
| Aug. 25, 2026 | issue | SO-260825-930 | MAIN | 1 | 12.98 | -12.98 | 30 | 389.40 | June 6, 2026: 1 @ 12.98 |
| Aug. 15, 2026 | issue | SO-260815-389 | MAIN | 6 | 12.98 | -77.88 | 31 | 402.38 | June 6, 2026: 6 @ 12.98 |
| Aug. 14, 2026 | issue | SO-260814-527 | MAIN | 18 | 12.98 | -233.64 | 37 | 480.26 | June 6, 2026: 18 @ 12.98 |
| Aug. 12, 2026 | return | RMA | MAIN | 2 | 12.98 | 25.96 | 55 | 713.90 | |
| Aug. 10, 2026 | issue | SO-260810-670 | MAIN | 2 | 12.98 | -25.96 | 53 | 687.94 | June 6, 2026: 2 @ 12.98 |
| Aug. 7, 2026 | issue | SO-260807-908 | MAIN | 20 | 12.98 | -259.60 | 55 | 713.90 | June 6, 2026: 20 @ 12.98 |
| Aug. 4, 2026 | issue | SO-260804-246 | MAIN | 4 | 12.98 | -51.92 | 75 | 973.50 | June 6, 2026: 4 @ 12.98 |
| July 16, 2026 | issue | SO-260716-693 | MAIN | 15 | 12.98 | -194.70 | 79 | 1,025.42 | June 6, 2026: 15 @ 12.98 |
| July 9, 2026 | issue | SO-260709-901 | MAIN | 13 | 12.98 | -168.74 | 94 | 1,220.12 | June 6, 2026: 13 @ 12.98 |
| June 30, 2026 | issue | SO-260630-831 | MAIN | 22 | 12.98 | -285.56 | 107 | 1,388.86 | June 6, 2026: 22 @ 12.98 |
| June 25, 2026 | issue | SO-260625-353 | MAIN | 1 | 12.98 | -12.98 | 129 | 1,674.42 | June 6, 2026: 1 @ 12.98 |
| June 24, 2026 | issue | SO-260624-819 | EAST | 6 | 12.98 | -77.88 | 130 | 1,687.40 | June 6, 2026: 6 @ 12.98 |
| June 21, 2026 | issue | SO-260621-160 | MAIN | 1 | 12.98 | -12.98 | 136 | 1,765.28 | June 6, 2026: 1 @ 12.98 |
| June 19, 2026 | issue | SO-260619-241 | MAIN | 3 | 12.98 | -38.94 | 137 | 1,778.26 | June 6, 2026: 3 @ 12.98 |
| June 17, 2026 | issue | SO-260617-426 | MAIN | 11 | 12.91 | -142.02 | 140 | 1,817.20 | Feb. 17, 2026: 1 @ 12.22; June 6, 2026: 10 @ 12.98 |
| June 6, 2026 | transfer | TRF | MAIN → EAST | 34 | warehouse transfer, no cost effect | ||||
| June 6, 2026 | receipt | PO-001551 | MAIN | 150 | 12.98 | 1,947.00 | 151 | 1,959.22 | |
| June 1, 2026 | issue | SO-260601-750 | EAST | 6 | 12.22 | -73.31 | 1 | 12.22 | Feb. 17, 2026: 6 @ 12.22 |
| May 30, 2026 | issue | SO-260530-749 | EAST | 7 | 12.22 | -85.53 | 7 | 85.53 | Feb. 17, 2026: 7 @ 12.22 |
| May 30, 2026 | issue | SO-260530-749 | MAIN | 10 | 12.22 | -122.18 | 14 | 171.05 | Feb. 17, 2026: 10 @ 12.22 |
| May 20, 2026 | issue | SO-260520-280 | MAIN | 12 | 12.22 | -146.62 | 24 | 293.24 | Feb. 17, 2026: 12 @ 12.22 |
| May 10, 2026 | issue | SO-260510-407 | EAST | 13 | 12.22 | -158.84 | 36 | 439.86 | Feb. 17, 2026: 13 @ 12.22 |
| May 8, 2026 | issue | SO-260508-204 | MAIN | 9 | 12.22 | -109.96 | 49 | 598.69 | Feb. 17, 2026: 9 @ 12.22 |
| April 18, 2026 | issue | SO-260418-164 | EAST | 1 | 12.22 | -12.22 | 58 | 708.66 | Feb. 17, 2026: 1 @ 12.22 |
| April 14, 2026 | issue | SO-260414-727 | MAIN | 1 | 12.22 | -12.22 | 59 | 720.87 | Feb. 17, 2026: 1 @ 12.22 |
| April 8, 2026 | issue | SO-260408-757 | MAIN | 49 | 12.22 | -598.69 | 60 | 733.09 | Feb. 17, 2026: 49 @ 12.22 |
| March 29, 2026 | issue | SO-260329-688 | EAST | 5 | 12.22 | -61.09 | 109 | 1,331.78 | Feb. 17, 2026: 5 @ 12.22 |
| March 20, 2026 | issue | SO-260320-640 | MAIN | 1 | 12.22 | -12.22 | 114 | 1,392.87 | Feb. 17, 2026: 1 @ 12.22 |
| March 17, 2026 | issue | SO-260317-944 | MAIN | 9 | 12.22 | -109.96 | 115 | 1,405.09 | Feb. 17, 2026: 9 @ 12.22 |
| March 9, 2026 | issue | SO-260309-818 | MAIN | 14 | 12.22 | -171.05 | 124 | 1,515.06 | Feb. 17, 2026: 14 @ 12.22 |
| March 5, 2026 | issue | SO-260305-965 | EAST | 9 | 12.22 | -109.96 | 138 | 1,686.11 | Feb. 17, 2026: 9 @ 12.22 |
| Feb. 27, 2026 | issue | SO-260227-670 | EAST | 1 | 12.22 | -12.22 | 147 | 1,796.08 | Feb. 17, 2026: 1 @ 12.22 |
| Feb. 23, 2026 | issue | SO-260223-827 | MAIN | 8 | 12.14 | -97.13 | 148 | 1,808.29 | Nov. 3, 2025: 2 @ 12.12; Feb. 2, 2026: 4 @ 12.12; Feb. 17, 2026: 2 @ 12.22 |
| Feb. 20, 2026 | issue | SO-260220-653 | EAST | 1 | 12.12 | -12.12 | 156 | 1,905.43 | Nov. 3, 2025: 1 @ 12.12 |
| Feb. 19, 2026 | issue | SO-260219-958 | EAST | 4 | 12.12 | -48.46 | 157 | 1,917.54 | Nov. 3, 2025: 4 @ 12.12 |
| Feb. 17, 2026 | transfer | TRF | MAIN → EAST | 48 | warehouse transfer, no cost effect | ||||
| Feb. 17, 2026 | receipt | PO-001233 | MAIN | 150 | 12.22 | 1,832.73 | 161 | 1,966.01 | |
| Feb. 12, 2026 | issue | SO-260212-686 | MAIN | 14 | 12.12 | -169.62 | 11 | 133.28 | Nov. 3, 2025: 14 @ 12.12 |
| Feb. 12, 2026 | issue | SO-260212-686 | EAST | 5 | 12.12 | -60.58 | 25 | 302.90 | Nov. 3, 2025: 5 @ 12.12 |
| Feb. 6, 2026 | issue | SO-260206-138 | MAIN | 6 | 12.12 | -72.70 | 30 | 363.48 | Nov. 3, 2025: 6 @ 12.12 |
| Feb. 3, 2026 | issue | SO-260203-737 | MAIN | 1 | 12.12 | -12.12 | 36 | 436.18 | Nov. 3, 2025: 1 @ 12.12 |
| Feb. 2, 2026 | return | RMA | MAIN | 4 | 12.12 | 48.46 | 37 | 448.29 | |
| Jan. 29, 2026 | issue | SO-260129-379 | MAIN | 3 | 12.12 | -36.35 | 33 | 399.83 | Nov. 3, 2025: 3 @ 12.12 |
| Jan. 22, 2026 | issue | SO-260122-507 | MAIN | 2 | 12.12 | -24.23 | 36 | 436.18 | Nov. 3, 2025: 2 @ 12.12 |
| Jan. 21, 2026 | issue | SO-260121-973 | MAIN | 6 | 12.12 | -72.70 | 38 | 460.41 | Nov. 3, 2025: 6 @ 12.12 |
| Jan. 20, 2026 | issue | SO-260120-639 | EAST | 1 | 12.12 | -12.12 | 44 | 533.10 | Nov. 3, 2025: 1 @ 12.12 |
| Jan. 16, 2026 | issue | SO-260116-993 | MAIN | 9 | 12.12 | -109.04 | 45 | 545.22 | Nov. 3, 2025: 9 @ 12.12 |
| Jan. 13, 2026 | issue | SO-260113-186 | EAST | 11 | 12.12 | -133.28 | 54 | 654.26 | Nov. 3, 2025: 11 @ 12.12 |
| Jan. 6, 2026 | issue | SO-260106-232 | MAIN | 1 | 12.12 | -12.12 | 65 | 787.54 | Nov. 3, 2025: 1 @ 12.12 |