Items / MCB-0019
MCB 32A TP Lite MCB-0019 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)35MAIN 35
Value (FIFO)1,142.28avg 32.64
ClassCZ / NCV -
Turnover0.0xlast issue 483 days ago
Days of cover-lead time 7d
NRV 23.0030 is below cost: lower-of-cost-or-NRV write-down 337.18.
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 = 35.41 | 1.0 |
| Inventory position | on hand + on order | 35 + 0 | 35 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 35.41 | 1 | 4 | yes (chosen if cheapest) |
MOQ 46, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| April 26, 2025 | 34 / 83 | 32.64 | 1,109.64 | |
| May 20, 2025 | 1 / 1 | 32.64 | 32.64 |
Movement ledger 51 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| June 20, 2025 | issue | SO-250620-115 | MAIN | 8 | 32.64 | -261.09 | 35 | 1,142.28 | April 26, 2025: 8 @ 32.64 |
| June 14, 2025 | issue | SO-250614-421 | MAIN | 4 | 32.64 | -130.55 | 43 | 1,403.37 | April 26, 2025: 4 @ 32.64 |
| June 5, 2025 | issue | SO-250605-578 | MAIN | 20 | 32.64 | -652.73 | 47 | 1,533.92 | April 26, 2025: 20 @ 32.64 |
| May 31, 2025 | issue | SO-250531-882 | MAIN | 3 | 32.64 | -97.91 | 67 | 2,186.65 | April 26, 2025: 3 @ 32.64 |
| May 20, 2025 | return | RMA | MAIN | 1 | 32.64 | 32.64 | 70 | 2,284.56 | |
| May 19, 2025 | issue | SO-250519-410 | MAIN | 4 | 32.64 | -130.55 | 69 | 2,251.93 | April 26, 2025: 4 @ 32.64 |
| May 15, 2025 | issue | SO-250515-401 | MAIN | 1 | 32.64 | -32.64 | 73 | 2,382.47 | April 26, 2025: 1 @ 32.64 |
| May 12, 2025 | issue | SO-250512-966 | MAIN | 1 | 32.64 | -32.64 | 74 | 2,415.11 | April 26, 2025: 1 @ 32.64 |
| May 8, 2025 | issue | SO-250508-825 | MAIN | 2 | 32.64 | -65.27 | 75 | 2,447.74 | April 26, 2025: 2 @ 32.64 |
| May 4, 2025 | issue | SO-250504-902 | MAIN | 11 | 32.80 | -360.78 | 77 | 2,513.02 | March 10, 2025: 5 @ 32.99; April 26, 2025: 6 @ 32.64 |
| April 29, 2025 | issue | SO-250429-224 | MAIN | 14 | 32.99 | -461.89 | 88 | 2,873.80 | March 10, 2025: 14 @ 32.99 |
| April 26, 2025 | receipt | PO-000486 | MAIN | 83 | 32.64 | 2,708.84 | 102 | 3,335.69 | |
| April 18, 2025 | issue | SO-250418-381 | MAIN | 3 | 32.99 | -98.98 | 19 | 626.85 | March 10, 2025: 3 @ 32.99 |
| April 14, 2025 | issue | SO-250414-414 | MAIN | 4 | 32.99 | -131.97 | 22 | 725.82 | March 10, 2025: 4 @ 32.99 |
| April 5, 2025 | issue | SO-250405-833 | MAIN | 16 | 32.99 | -527.87 | 26 | 857.79 | March 10, 2025: 16 @ 32.99 |
| March 26, 2025 | issue | SO-250326-284 | MAIN | 2 | 32.99 | -65.98 | 42 | 1,385.66 | March 10, 2025: 2 @ 32.99 |
| March 18, 2025 | issue | SO-250318-108 | MAIN | 49 | 33.06 | -1,620.05 | 44 | 1,451.65 | Feb. 10, 2025: 10 @ 33.34; March 10, 2025: 39 @ 32.99 |
| March 13, 2025 | issue | SO-250313-892 | MAIN | 5 | 33.34 | -166.68 | 93 | 3,071.70 | Feb. 10, 2025: 5 @ 33.34 |
| March 10, 2025 | receipt | PO-000335 | MAIN | 83 | 32.99 | 2,738.34 | 98 | 3,238.38 | |
| March 3, 2025 | issue | SO-250303-453 | MAIN | 11 | 33.34 | -366.70 | 15 | 500.05 | Feb. 10, 2025: 11 @ 33.34 |
| Feb. 22, 2025 | issue | SO-250222-548 | MAIN | 57 | 33.34 | -1,900.18 | 26 | 866.75 | Feb. 10, 2025: 57 @ 33.34 |
| Feb. 10, 2025 | receipt | PO-000255 | MAIN | 83 | 33.34 | 2,766.93 | 83 | 2,766.93 | |
| Feb. 8, 2025 | issue | SO-250208-532 | MAIN | 5 | 33.69 | -168.44 | 0 | 0.00 | Jan. 5, 2025: 5 @ 33.69 |
| Feb. 6, 2025 | issue | SO-250206-443 | MAIN | 1 | 33.69 | -33.69 | 5 | 168.44 | Jan. 5, 2025: 1 @ 33.69 |
| Feb. 2, 2025 | issue | SO-250202-226 | MAIN | 17 | 33.69 | -572.71 | 6 | 202.13 | Jan. 5, 2025: 17 @ 33.69 |
| Jan. 27, 2025 | issue | SO-250127-821 | MAIN | 26 | 33.69 | -875.91 | 23 | 774.84 | Jan. 5, 2025: 26 @ 33.69 |
| Jan. 24, 2025 | issue | SO-250124-223 | MAIN | 1 | 33.69 | -33.69 | 49 | 1,650.75 | Jan. 5, 2025: 1 @ 33.69 |
| Jan. 19, 2025 | issue | SO-250119-905 | MAIN | 5 | 33.69 | -168.44 | 50 | 1,684.44 | Jan. 5, 2025: 5 @ 33.69 |
| Jan. 12, 2025 | issue | SO-250112-225 | MAIN | 25 | 33.69 | -842.22 | 55 | 1,852.88 | Jan. 5, 2025: 25 @ 33.69 |
| Jan. 8, 2025 | issue | SO-250108-402 | MAIN | 3 | 33.69 | -101.07 | 80 | 2,695.10 | Jan. 5, 2025: 3 @ 33.69 |
| Jan. 5, 2025 | receipt | PO-000165 | MAIN | 83 | 33.69 | 2,796.16 | 83 | 2,796.16 | |
| Dec. 31, 2024 | issue | SO-241231-907 | EAST | 13 | 32.39 | -421.13 | 0 | 0.00 | Dec. 11, 2024: 13 @ 32.39 |
| Dec. 28, 2024 | issue | SO-241228-610 | EAST | 8 | 32.39 | -259.16 | 13 | 421.13 | Dec. 11, 2024: 8 @ 32.39 |
| Dec. 28, 2024 | issue | SO-241228-610 | MAIN | 13 | 32.39 | -421.13 | 21 | 680.29 | Dec. 11, 2024: 13 @ 32.39 |
| Dec. 25, 2024 | issue | SO-241225-487 | MAIN | 14 | 32.39 | -453.53 | 34 | 1,101.42 | Dec. 11, 2024: 14 @ 32.39 |
| Dec. 24, 2024 | issue | SO-241224-361 | MAIN | 35 | 32.39 | -1,133.82 | 48 | 1,554.95 | Dec. 11, 2024: 35 @ 32.39 |
| Dec. 17, 2024 | issue | SO-241217-576 | MAIN | 10 | 33.64 | -336.40 | 83 | 2,688.77 | Oct. 1, 2024: 10 @ 33.64 |
| Dec. 11, 2024 | transfer | TRF | MAIN → EAST | 21 | warehouse transfer, no cost effect | ||||
| Dec. 11, 2024 | receipt | PO-000093 | MAIN | 83 | 32.39 | 2,688.77 | 93 | 3,025.16 | |
| Dec. 3, 2024 | issue | SO-241203-456 | MAIN | 14 | 33.64 | -470.95 | 10 | 336.40 | Oct. 1, 2024: 14 @ 33.64 |
| Dec. 1, 2024 | issue | SO-241201-440 | MAIN | 1 | 33.64 | -33.64 | 24 | 807.35 | Oct. 1, 2024: 1 @ 33.64 |
| Nov. 17, 2024 | issue | SO-241117-634 | MAIN | 24 | 33.64 | -807.35 | 25 | 840.99 | Oct. 1, 2024: 24 @ 33.64 |
| Nov. 5, 2024 | issue | SO-241105-439 | MAIN | 3 | 33.64 | -100.92 | 49 | 1,648.34 | Oct. 1, 2024: 3 @ 33.64 |
| Nov. 4, 2024 | issue | SO-241104-829 | MAIN | 9 | 33.64 | -302.76 | 52 | 1,749.25 | Oct. 1, 2024: 9 @ 33.64 |
| Oct. 18, 2024 | issue | SO-241018-942 | MAIN | 3 | 33.64 | -100.92 | 61 | 2,052.01 | Oct. 1, 2024: 3 @ 33.64 |
| Oct. 16, 2024 | issue | SO-241016-365 | MAIN | 3 | 33.64 | -100.92 | 64 | 2,152.93 | Oct. 1, 2024: 3 @ 33.64 |
| Oct. 15, 2024 | issue | SO-241015-827 | MAIN | 2 | 33.64 | -67.28 | 67 | 2,253.85 | Oct. 1, 2024: 2 @ 33.64 |
| Oct. 14, 2024 | issue | SO-241014-465 | MAIN | 11 | 33.64 | -370.03 | 69 | 2,321.13 | Oct. 1, 2024: 11 @ 33.64 |
| Oct. 13, 2024 | issue | SO-241013-498 | MAIN | 7 | 33.64 | -235.48 | 80 | 2,691.16 | Oct. 1, 2024: 7 @ 33.64 |
| Oct. 9, 2024 | issue | SO-241009-625 | MAIN | 5 | 33.64 | -168.20 | 87 | 2,926.64 | Oct. 1, 2024: 5 @ 33.64 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 92 | 33.64 | 3,094.83 | 92 | 3,094.83 | |