Items / SWT-0002
Bell Push Plus SWT-0002 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)125MAIN 125
Value (FIFO)4,248.72avg 33.99
ClassCZ / NCV -
Turnover0.0xlast issue 534 days ago
Days of cover-lead time 7d
NRV 24.8185 is below cost: lower-of-cost-or-NRV write-down 1,146.41.
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 = 36.49 | 1.0 |
| Inventory position | on hand + on order | 125 + 0 | 125 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 36.49 | 1 | 4 | yes (chosen if cheapest) |
MOQ 220, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| March 9, 2025 | 125 / 220 | 33.99 | 4,248.72 |
Movement ledger 40 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| April 30, 2025 | issue | SO-250430-467 | MAIN | 3 | 33.99 | -101.97 | 125 | 4,248.72 | March 9, 2025: 3 @ 33.99 |
| April 23, 2025 | issue | SO-250423-588 | MAIN | 28 | 33.99 | -951.71 | 128 | 4,350.69 | March 9, 2025: 28 @ 33.99 |
| April 15, 2025 | issue | SO-250415-346 | MAIN | 1 | 33.99 | -33.99 | 156 | 5,302.41 | March 9, 2025: 1 @ 33.99 |
| April 10, 2025 | issue | SO-250410-321 | MAIN | 1 | 33.99 | -33.99 | 157 | 5,336.40 | March 9, 2025: 1 @ 33.99 |
| April 7, 2025 | issue | SO-250407-699 | MAIN | 6 | 33.99 | -203.94 | 158 | 5,370.39 | March 9, 2025: 6 @ 33.99 |
| April 2, 2025 | issue | SO-250402-396 | MAIN | 18 | 33.99 | -611.82 | 164 | 5,574.33 | March 9, 2025: 18 @ 33.99 |
| March 29, 2025 | issue | SO-250329-859 | MAIN | 24 | 33.99 | -815.76 | 182 | 6,186.14 | March 9, 2025: 24 @ 33.99 |
| March 26, 2025 | issue | SO-250326-602 | MAIN | 14 | 33.99 | -475.86 | 206 | 7,001.90 | March 9, 2025: 14 @ 33.99 |
| March 9, 2025 | receipt | PO-000331 | MAIN | 220 | 33.99 | 7,477.76 | 220 | 7,477.76 | |
| March 8, 2025 | issue | SO-250308-175 | MAIN | 18 | 33.54 | -603.75 | 0 | 0.00 | Dec. 11, 2024: 17 @ 33.54; March 1, 2025: 1 @ 33.54 |
| March 6, 2025 | issue | SO-250306-988 | MAIN | 6 | 33.54 | -201.25 | 18 | 603.75 | Dec. 11, 2024: 6 @ 33.54 |
| March 3, 2025 | issue | SO-250303-587 | MAIN | 19 | 33.54 | -637.30 | 24 | 805.01 | Dec. 11, 2024: 19 @ 33.54 |
| March 1, 2025 | return | RMA | MAIN | 1 | 33.54 | 33.54 | 43 | 1,442.30 | |
| Feb. 18, 2025 | issue | SO-250218-739 | MAIN | 10 | 33.54 | -335.42 | 42 | 1,408.76 | Dec. 11, 2024: 10 @ 33.54 |
| Feb. 16, 2025 | issue | SO-250216-108 | MAIN | 30 | 33.54 | -1,006.26 | 52 | 1,744.18 | Dec. 11, 2024: 30 @ 33.54 |
| Feb. 12, 2025 | issue | SO-250212-145 | MAIN | 3 | 33.54 | -100.63 | 82 | 2,750.44 | Dec. 11, 2024: 3 @ 33.54 |
| Feb. 2, 2025 | issue | SO-250202-440 | MAIN | 2 | 33.54 | -67.08 | 85 | 2,851.06 | Dec. 11, 2024: 2 @ 33.54 |
| Jan. 26, 2025 | issue | SO-250126-941 | MAIN | 6 | 33.54 | -201.25 | 87 | 2,918.15 | Dec. 11, 2024: 6 @ 33.54 |
| Jan. 23, 2025 | issue | SO-250123-402 | MAIN | 3 | 33.54 | -100.63 | 93 | 3,119.40 | Dec. 11, 2024: 3 @ 33.54 |
| Jan. 15, 2025 | issue | SO-250115-848 | MAIN | 3 | 33.54 | -100.63 | 96 | 3,220.02 | Dec. 11, 2024: 3 @ 33.54 |
| Jan. 13, 2025 | issue | SO-250113-581 | MAIN | 18 | 33.54 | -603.75 | 99 | 3,320.65 | Dec. 11, 2024: 18 @ 33.54 |
| Jan. 11, 2025 | issue | SO-250111-933 | MAIN | 7 | 33.54 | -234.79 | 117 | 3,924.40 | Dec. 11, 2024: 7 @ 33.54 |
| Jan. 9, 2025 | issue | SO-250109-698 | MAIN | 49 | 33.54 | -1,643.55 | 124 | 4,159.20 | Dec. 11, 2024: 49 @ 33.54 |
| Dec. 27, 2024 | issue | SO-241227-693 | MAIN | 12 | 33.54 | -402.50 | 173 | 5,802.75 | Dec. 11, 2024: 12 @ 33.54 |
| Dec. 26, 2024 | issue | SO-241226-907 | MAIN | 46 | 33.81 | -1,555.29 | 185 | 6,205.25 | Oct. 1, 2024: 6 @ 34.67; Nov. 15, 2024: 5 @ 34.67; Dec. 11, 2024: 35 @ 33.54 |
| Dec. 16, 2024 | issue | SO-241216-564 | MAIN | 4 | 34.67 | -138.66 | 231 | 7,760.54 | Oct. 1, 2024: 4 @ 34.67 |
| Dec. 13, 2024 | issue | SO-241213-231 | MAIN | 7 | 34.67 | -242.66 | 235 | 7,899.20 | Oct. 1, 2024: 7 @ 34.67 |
| Dec. 11, 2024 | receipt | PO-000091 | MAIN | 220 | 33.54 | 7,379.22 | 242 | 8,141.86 | |
| Dec. 6, 2024 | issue | SO-241206-805 | MAIN | 36 | 34.67 | -1,247.96 | 22 | 762.64 | Oct. 1, 2024: 36 @ 34.67 |
| Nov. 23, 2024 | issue | SO-241123-430 | MAIN | 39 | 34.67 | -1,351.95 | 58 | 2,010.60 | Oct. 1, 2024: 39 @ 34.67 |
| Nov. 23, 2024 | issue | SO-241123-430 | EAST | 21 | 34.67 | -727.98 | 97 | 3,362.55 | Oct. 1, 2024: 21 @ 34.67 |
| Nov. 22, 2024 | issue | SO-241122-812 | MAIN | 37 | 34.67 | -1,282.62 | 118 | 4,090.53 | Oct. 1, 2024: 37 @ 34.67 |
| Nov. 15, 2024 | return | RMA | MAIN | 5 | 34.67 | 173.33 | 155 | 5,373.15 | |
| Oct. 31, 2024 | issue | SO-241031-618 | EAST | 14 | 34.67 | -485.32 | 150 | 5,199.82 | Oct. 1, 2024: 14 @ 34.67 |
| Oct. 30, 2024 | issue | SO-241030-740 | MAIN | 10 | 34.67 | -346.66 | 164 | 5,685.14 | Oct. 1, 2024: 10 @ 34.67 |
| Oct. 17, 2024 | issue | SO-241017-629 | EAST | 8 | 34.67 | -277.32 | 174 | 6,031.80 | Oct. 1, 2024: 8 @ 34.67 |
| Oct. 7, 2024 | issue | SO-241007-352 | EAST | 18 | 34.67 | -623.98 | 182 | 6,309.12 | Oct. 1, 2024: 18 @ 34.67 |
| Oct. 4, 2024 | issue | SO-241004-214 | MAIN | 20 | 34.67 | -693.31 | 200 | 6,933.10 | Oct. 1, 2024: 20 @ 34.67 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 61 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 220 | 34.67 | 7,626.41 | 220 | 7,626.41 | |