Items / SWT-0025
Switch Plate 4M Flex SWT-0025 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)152MAIN 152
Value (FIFO)744.18avg 4.90
ClassCZ / NCV -
Turnover0.0xlast issue 536 days ago
Days of cover-lead time 7d
NRV 2.5897 is below cost: lower-of-cost-or-NRV write-down 350.54.
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 = 5.35 | 1.0 |
| Inventory position | on hand + on order | 152 + 0 | 152 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 5.35 | 1 | 1 | yes (chosen if cheapest) |
| 460 | 5.14 | 460 | 236 | yes |
| 920 | 4.92 | 920 | 453 | yes |
MOQ 230, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| March 22, 2025 | 152 / 230 | 4.90 | 744.18 |
Movement ledger 39 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| April 28, 2025 | issue | SO-250428-776 | MAIN | 9 | 4.90 | -44.06 | 152 | 744.18 | March 22, 2025: 9 @ 4.90 |
| April 26, 2025 | issue | SO-250426-303 | MAIN | 10 | 4.90 | -48.96 | 161 | 788.24 | March 22, 2025: 10 @ 4.90 |
| April 25, 2025 | issue | SO-250425-165 | MAIN | 20 | 4.90 | -97.92 | 171 | 837.20 | March 22, 2025: 20 @ 4.90 |
| April 20, 2025 | issue | SO-250420-786 | MAIN | 13 | 4.90 | -63.65 | 191 | 935.12 | March 22, 2025: 13 @ 4.90 |
| April 7, 2025 | issue | SO-250407-871 | MAIN | 12 | 4.90 | -58.75 | 204 | 998.76 | March 22, 2025: 12 @ 4.90 |
| March 29, 2025 | issue | SO-250329-455 | MAIN | 14 | 4.90 | -68.54 | 216 | 1,057.51 | March 22, 2025: 14 @ 4.90 |
| March 29, 2025 | issue | SO-250329-455 | EAST | 27 | 4.91 | -132.58 | 230 | 1,126.06 | Dec. 24, 2024: 27 @ 4.91 |
| March 22, 2025 | receipt | PO-000365 | MAIN | 230 | 4.90 | 1,126.06 | 257 | 1,258.64 | |
| March 16, 2025 | issue | SO-250316-869 | EAST | 8 | 4.91 | -39.28 | 27 | 132.58 | Dec. 24, 2024: 8 @ 4.91 |
| March 3, 2025 | issue | SO-250303-895 | EAST | 12 | 4.91 | -58.92 | 35 | 171.86 | Dec. 24, 2024: 12 @ 4.91 |
| March 3, 2025 | issue | SO-250303-895 | MAIN | 32 | 4.91 | -157.13 | 47 | 230.78 | Dec. 24, 2024: 32 @ 4.91 |
| Feb. 27, 2025 | issue | SO-250227-573 | EAST | 11 | 4.91 | -54.01 | 79 | 387.91 | Dec. 24, 2024: 11 @ 4.91 |
| Feb. 26, 2025 | issue | SO-250226-875 | MAIN | 2 | 4.91 | -9.82 | 90 | 441.93 | Dec. 24, 2024: 2 @ 4.91 |
| Feb. 23, 2025 | issue | SO-250223-344 | EAST | 21 | 4.91 | -103.12 | 92 | 451.75 | Dec. 24, 2024: 21 @ 4.91 |
| Feb. 22, 2025 | issue | SO-250222-250 | MAIN | 14 | 4.91 | -68.74 | 113 | 554.86 | Dec. 24, 2024: 14 @ 4.91 |
| Feb. 12, 2025 | issue | SO-250212-345 | MAIN | 6 | 4.91 | -29.46 | 127 | 623.61 | Dec. 24, 2024: 6 @ 4.91 |
| Feb. 7, 2025 | issue | SO-250207-103 | MAIN | 4 | 4.91 | -19.64 | 133 | 653.07 | Dec. 24, 2024: 4 @ 4.91 |
| Feb. 6, 2025 | issue | SO-250206-397 | MAIN | 22 | 4.91 | -108.03 | 137 | 672.71 | Dec. 24, 2024: 22 @ 4.91 |
| Jan. 30, 2025 | issue | SO-250130-205 | MAIN | 17 | 4.91 | -83.48 | 159 | 780.74 | Dec. 24, 2024: 17 @ 4.91 |
| Jan. 27, 2025 | issue | SO-250127-487 | MAIN | 61 | 4.93 | -300.73 | 176 | 864.21 | Oct. 1, 2024: 7 @ 5.08; Dec. 24, 2024: 54 @ 4.91 |
| Jan. 14, 2025 | issue | SO-250114-658 | MAIN | 5 | 5.08 | -25.41 | 237 | 1,164.95 | Oct. 1, 2024: 5 @ 5.08 |
| Dec. 29, 2024 | issue | SO-241229-898 | MAIN | 2 | 5.08 | -10.16 | 242 | 1,190.36 | Oct. 1, 2024: 2 @ 5.08 |
| Dec. 24, 2024 | transfer | TRF | MAIN → EAST | 79 | warehouse transfer, no cost effect | ||||
| Dec. 24, 2024 | receipt | PO-000131 | MAIN | 230 | 4.91 | 1,129.37 | 244 | 1,200.52 | |
| Dec. 20, 2024 | issue | SO-241220-958 | MAIN | 72 | 5.08 | -365.94 | 14 | 71.16 | Oct. 1, 2024: 72 @ 5.08 |
| Dec. 12, 2024 | issue | SO-241212-289 | MAIN | 9 | 5.08 | -45.74 | 86 | 437.10 | Oct. 1, 2024: 9 @ 5.08 |
| Dec. 10, 2024 | issue | SO-241210-341 | MAIN | 1 | 5.08 | -5.08 | 95 | 482.84 | Oct. 1, 2024: 1 @ 5.08 |
| Nov. 29, 2024 | issue | SO-241129-420 | MAIN | 20 | 5.08 | -101.65 | 96 | 487.92 | Oct. 1, 2024: 20 @ 5.08 |
| Nov. 27, 2024 | issue | SO-241127-903 | MAIN | 1 | 5.08 | -5.08 | 116 | 589.57 | Oct. 1, 2024: 1 @ 5.08 |
| Nov. 22, 2024 | issue | SO-241122-776 | MAIN | 30 | 5.08 | -152.48 | 117 | 594.65 | Oct. 1, 2024: 30 @ 5.08 |
| Nov. 21, 2024 | issue | SO-241121-530 | MAIN | 1 | 5.08 | -5.08 | 147 | 747.13 | Oct. 1, 2024: 1 @ 5.08 |
| Nov. 13, 2024 | issue | SO-241113-441 | MAIN | 2 | 5.08 | -10.16 | 148 | 752.21 | Oct. 1, 2024: 2 @ 5.08 |
| Nov. 9, 2024 | issue | SO-241109-798 | MAIN | 1 | 5.08 | -5.08 | 150 | 762.38 | Oct. 1, 2024: 1 @ 5.08 |
| Nov. 2, 2024 | issue | SO-241102-222 | MAIN | 15 | 5.08 | -76.24 | 151 | 767.46 | Oct. 1, 2024: 15 @ 5.08 |
| Oct. 29, 2024 | issue | SO-241029-917 | MAIN | 3 | 5.08 | -15.25 | 166 | 843.70 | Oct. 1, 2024: 3 @ 5.08 |
| Oct. 19, 2024 | issue | SO-241019-214 | MAIN | 50 | 5.08 | -254.12 | 169 | 858.94 | Oct. 1, 2024: 50 @ 5.08 |
| Oct. 8, 2024 | issue | SO-241008-413 | MAIN | 8 | 5.08 | -40.66 | 219 | 1,113.07 | Oct. 1, 2024: 8 @ 5.08 |
| Oct. 3, 2024 | issue | SO-241003-813 | MAIN | 3 | 5.08 | -15.25 | 227 | 1,153.73 | Oct. 1, 2024: 3 @ 5.08 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 230 | 5.08 | 1,168.98 | 230 | 1,168.98 | |