Items / SWT-0020
Switch Plate 4M Max SWT-0020 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)251MAIN 251
Value (FIFO)2,889.41avg 11.51
ClassCZ / NCV -
Turnover0.0xlast issue 474 days ago
Days of cover-lead time 7d
NRV 8.1728 is below cost: lower-of-cost-or-NRV write-down 838.04.
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 | 0.00 / 30.4375 | 0.000 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 0.00 / 5.517 | 0.000 |
| 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 * 0.000^2 + 0.000^2 * 1.5^2) | 0.0 |
| Reorder point | d * LT + safety stock | 0.000 * 7.0 + 0.0 | 0.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 0/yr, S = 45.00, h = 20%, price = 12.45 | 1.0 |
| Inventory position | on hand + on order | 251 + 0 | 251 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 12.45 | 1 | 1 | yes (chosen if cheapest) |
MOQ 320, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| May 27, 2025 | 251 / 320 | 11.51 | 2,889.41 |
Movement ledger 45 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| June 29, 2025 | issue | SO-250629-447 | MAIN | 17 | 11.51 | -195.70 | 251 | 2,889.41 | May 27, 2025: 17 @ 11.51 |
| June 1, 2025 | issue | SO-250601-255 | MAIN | 83 | 11.54 | -957.87 | 268 | 3,085.11 | March 17, 2025: 31 @ 11.59; May 27, 2025: 52 @ 11.51 |
| May 27, 2025 | receipt | PO-000582 | MAIN | 320 | 11.51 | 3,683.71 | 351 | 4,042.98 | |
| May 19, 2025 | issue | SO-250519-646 | MAIN | 42 | 11.59 | -486.75 | 31 | 359.27 | March 17, 2025: 42 @ 11.59 |
| May 8, 2025 | issue | SO-250508-253 | MAIN | 9 | 11.59 | -104.30 | 73 | 846.02 | March 17, 2025: 9 @ 11.59 |
| May 1, 2025 | issue | SO-250501-249 | MAIN | 94 | 11.59 | -1,089.39 | 82 | 950.32 | March 17, 2025: 94 @ 11.59 |
| April 26, 2025 | issue | SO-250426-461 | MAIN | 16 | 11.59 | -185.43 | 176 | 2,039.72 | March 17, 2025: 16 @ 11.59 |
| April 15, 2025 | issue | SO-250415-200 | MAIN | 73 | 11.59 | -846.02 | 192 | 2,225.15 | March 17, 2025: 73 @ 11.59 |
| April 7, 2025 | issue | SO-250407-929 | MAIN | 20 | 11.59 | -231.79 | 265 | 3,071.16 | March 17, 2025: 20 @ 11.59 |
| March 25, 2025 | issue | SO-250325-406 | MAIN | 36 | 11.59 | -417.10 | 285 | 3,302.95 | Jan. 16, 2025: 1 @ 11.48; March 17, 2025: 35 @ 11.59 |
| March 19, 2025 | issue | SO-250319-550 | MAIN | 19 | 11.48 | -218.02 | 321 | 3,720.05 | Jan. 16, 2025: 19 @ 11.48 |
| March 17, 2025 | receipt | PO-000349 | MAIN | 320 | 11.59 | 3,708.58 | 340 | 3,938.08 | |
| March 11, 2025 | issue | SO-250311-172 | MAIN | 25 | 11.48 | -286.88 | 20 | 229.50 | Dec. 28, 2024: 22 @ 11.48; Jan. 16, 2025: 3 @ 11.48 |
| March 10, 2025 | issue | SO-250310-986 | MAIN | 5 | 11.48 | -57.38 | 45 | 516.38 | Dec. 28, 2024: 5 @ 11.48 |
| March 7, 2025 | issue | SO-250307-632 | MAIN | 16 | 11.48 | -183.60 | 50 | 573.75 | Dec. 28, 2024: 16 @ 11.48 |
| March 7, 2025 | issue | SO-250307-632 | EAST | 24 | 11.48 | -275.40 | 66 | 757.35 | Dec. 28, 2024: 24 @ 11.48 |
| Feb. 19, 2025 | issue | SO-250219-475 | MAIN | 68 | 11.48 | -780.30 | 90 | 1,032.75 | Dec. 28, 2024: 68 @ 11.48 |
| Feb. 12, 2025 | issue | SO-250212-619 | MAIN | 67 | 11.48 | -768.82 | 158 | 1,813.05 | Dec. 28, 2024: 67 @ 11.48 |
| Feb. 9, 2025 | issue | SO-250209-562 | EAST | 2 | 11.48 | -22.95 | 225 | 2,581.88 | Dec. 28, 2024: 2 @ 11.48 |
| Feb. 7, 2025 | issue | SO-250207-465 | EAST | 11 | 11.48 | -126.22 | 227 | 2,604.82 | Dec. 28, 2024: 11 @ 11.48 |
| Jan. 16, 2025 | return | RMA | MAIN | 23 | 11.48 | 263.92 | 238 | 2,731.05 | |
| Jan. 15, 2025 | issue | SO-250115-650 | MAIN | 4 | 11.48 | -45.90 | 215 | 2,467.12 | Dec. 28, 2024: 4 @ 11.48 |
| Jan. 13, 2025 | issue | SO-250113-643 | EAST | 46 | 11.48 | -527.85 | 219 | 2,513.02 | Dec. 28, 2024: 46 @ 11.48 |
| Jan. 12, 2025 | issue | SO-250112-309 | MAIN | 30 | 11.48 | -344.25 | 265 | 3,040.88 | Dec. 28, 2024: 30 @ 11.48 |
| Jan. 11, 2025 | issue | SO-250111-823 | EAST | 20 | 11.48 | -229.50 | 295 | 3,385.12 | Dec. 28, 2024: 20 @ 11.48 |
| Jan. 9, 2025 | issue | SO-250109-836 | MAIN | 17 | 11.72 | -199.30 | 315 | 3,614.62 | Oct. 1, 2024: 12 @ 11.83; Dec. 28, 2024: 5 @ 11.48 |
| Dec. 28, 2024 | transfer | TRF | MAIN → EAST | 103 | warehouse transfer, no cost effect | ||||
| Dec. 28, 2024 | receipt | PO-000143 | MAIN | 320 | 11.48 | 3,672.00 | 332 | 3,813.93 | |
| Dec. 27, 2024 | issue | SO-241227-859 | MAIN | 22 | 11.83 | -260.20 | 12 | 141.93 | Oct. 1, 2024: 22 @ 11.83 |
| Dec. 25, 2024 | issue | SO-241225-299 | MAIN | 5 | 11.83 | -59.14 | 34 | 402.14 | Oct. 1, 2024: 5 @ 11.83 |
| Dec. 23, 2024 | issue | SO-241223-386 | MAIN | 1 | 11.83 | -11.83 | 39 | 461.27 | Oct. 1, 2024: 1 @ 11.83 |
| Dec. 20, 2024 | issue | SO-241220-460 | MAIN | 62 | 11.83 | -733.30 | 40 | 473.10 | Oct. 1, 2024: 62 @ 11.83 |
| Dec. 13, 2024 | issue | SO-241213-589 | MAIN | 5 | 11.83 | -59.14 | 102 | 1,206.40 | Oct. 1, 2024: 5 @ 11.83 |
| Dec. 1, 2024 | issue | SO-241201-388 | MAIN | 4 | 11.83 | -47.31 | 107 | 1,265.54 | Oct. 1, 2024: 4 @ 11.83 |
| Nov. 25, 2024 | issue | SO-241125-125 | MAIN | 4 | 11.83 | -47.31 | 111 | 1,312.85 | Oct. 1, 2024: 4 @ 11.83 |
| Nov. 22, 2024 | issue | SO-241122-122 | MAIN | 32 | 11.83 | -378.48 | 115 | 1,360.16 | Oct. 1, 2024: 32 @ 11.83 |
| Nov. 12, 2024 | issue | SO-241112-477 | MAIN | 34 | 11.83 | -402.14 | 147 | 1,738.64 | Oct. 1, 2024: 34 @ 11.83 |
| Nov. 6, 2024 | issue | SO-241106-865 | MAIN | 15 | 11.83 | -177.41 | 181 | 2,140.78 | Oct. 1, 2024: 15 @ 11.83 |
| Nov. 5, 2024 | issue | SO-241105-303 | MAIN | 43 | 11.83 | -508.58 | 196 | 2,318.19 | Oct. 1, 2024: 43 @ 11.83 |
| Oct. 29, 2024 | issue | SO-241029-831 | MAIN | 9 | 11.83 | -106.45 | 239 | 2,826.77 | Oct. 1, 2024: 9 @ 11.83 |
| Oct. 17, 2024 | issue | SO-241017-111 | MAIN | 1 | 11.83 | -11.83 | 248 | 2,933.22 | Oct. 1, 2024: 1 @ 11.83 |
| Oct. 15, 2024 | issue | SO-241015-231 | MAIN | 51 | 11.83 | -603.20 | 249 | 2,945.05 | Oct. 1, 2024: 51 @ 11.83 |
| Oct. 12, 2024 | issue | SO-241012-352 | MAIN | 16 | 11.83 | -189.24 | 300 | 3,548.25 | Oct. 1, 2024: 16 @ 11.83 |
| Oct. 3, 2024 | issue | SO-241003-611 | MAIN | 4 | 11.83 | -47.31 | 316 | 3,737.49 | Oct. 1, 2024: 4 @ 11.83 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 320 | 11.83 | 3,784.80 | 320 | 3,784.80 | |