Items / MCB-0020
MCB 32A TP Elite MCB-0020 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)18MAIN 18
Value (FIFO)996.61avg 55.37
ClassBX / FCV 0.32
Turnover13.6xlast issue 7 days ago
Days of cover19lead 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 | 29.58 / 30.4375 | 0.972 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.61 / 5.517 | 1.742 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(7.0 * 1.742^2 + 0.972^2 * 1.5^2) | 8.0 |
| Reorder point | d * LT + safety stock | 0.972 * 7.0 + 8.0 | 14.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 14.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 355/yr, S = 45.00, h = 20%, price = 51.18 | 112.0 |
| Inventory position | on hand + on order | 18 + 0 | 18 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 55.63 | 54 | 20,331 | yes |
| 56 | 53.40 | 56 | 19,530 | yes |
| 112 | 51.18 | 112 | 18,872 | yes (chosen if cheapest) |
MOQ 28, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 19, 2026 | 11 / 49 | 55.27 | 607.98 | |
| Aug. 29, 2026 | 7 / 7 | 55.52 | 388.63 |
Movement ledger 126 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-629 | MAIN | 2 | 55.27 | -110.54 | 18 | 996.61 | Aug. 19, 2026: 2 @ 55.27 |
| Oct. 8, 2026 | issue | SO-261008-735 | MAIN | 6 | 55.27 | -331.63 | 20 | 1,107.15 | Aug. 19, 2026: 6 @ 55.27 |
| Oct. 6, 2026 | issue | SO-261006-692 | MAIN | 2 | 55.27 | -110.54 | 26 | 1,438.78 | Aug. 19, 2026: 2 @ 55.27 |
| Oct. 3, 2026 | issue | SO-261003-415 | MAIN | 5 | 55.27 | -276.35 | 28 | 1,549.32 | Aug. 19, 2026: 5 @ 55.27 |
| Sept. 22, 2026 | issue | SO-260922-253 | MAIN | 4 | 55.27 | -221.08 | 33 | 1,825.67 | Aug. 19, 2026: 4 @ 55.27 |
| Sept. 16, 2026 | issue | SO-260916-747 | MAIN | 7 | 55.27 | -386.90 | 37 | 2,046.76 | Aug. 19, 2026: 7 @ 55.27 |
| Sept. 12, 2026 | issue | SO-260912-378 | MAIN | 1 | 55.27 | -55.27 | 44 | 2,433.65 | Aug. 19, 2026: 1 @ 55.27 |
| Sept. 6, 2026 | issue | SO-260906-414 | MAIN | 4 | 55.27 | -221.08 | 45 | 2,488.92 | Aug. 19, 2026: 4 @ 55.27 |
| Sept. 3, 2026 | issue | SO-260903-721 | MAIN | 1 | 55.27 | -55.27 | 49 | 2,710.01 | Aug. 19, 2026: 1 @ 55.27 |
| Sept. 1, 2026 | issue | SO-260901-697 | MAIN | 6 | 55.27 | -331.63 | 50 | 2,765.28 | Aug. 19, 2026: 6 @ 55.27 |
| Aug. 29, 2026 | return | RMA | MAIN | 7 | 55.52 | 388.63 | 56 | 3,096.90 | |
| Aug. 22, 2026 | issue | SO-260822-464 | MAIN | 2 | 55.52 | -111.04 | 49 | 2,708.27 | Aug. 2, 2026: 2 @ 55.52 |
| Aug. 21, 2026 | issue | SO-260821-254 | MAIN | 5 | 55.52 | -277.59 | 51 | 2,819.31 | Aug. 2, 2026: 5 @ 55.52 |
| Aug. 19, 2026 | receipt | PO-001730 | MAIN | 49 | 55.27 | 2,708.27 | 56 | 3,096.90 | |
| Aug. 13, 2026 | issue | SO-260813-529 | MAIN | 18 | 55.52 | -999.33 | 7 | 388.63 | Aug. 2, 2026: 18 @ 55.52 |
| Aug. 13, 2026 | issue | SO-260813-529 | EAST | 14 | 55.52 | -777.26 | 25 | 1,387.96 | Aug. 2, 2026: 14 @ 55.52 |
| Aug. 5, 2026 | issue | SO-260805-773 | MAIN | 21 | 54.96 | -1,154.11 | 39 | 2,165.22 | June 20, 2026: 11 @ 54.45; Aug. 2, 2026: 10 @ 55.52 |
| Aug. 2, 2026 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| Aug. 2, 2026 | receipt | PO-001692 | MAIN | 49 | 55.52 | 2,720.41 | 60 | 3,319.33 | |
| July 27, 2026 | issue | SO-260727-989 | MAIN | 6 | 54.45 | -326.69 | 11 | 598.93 | June 20, 2026: 6 @ 54.45 |
| July 20, 2026 | issue | SO-260720-302 | MAIN | 7 | 54.45 | -381.13 | 17 | 925.61 | June 20, 2026: 7 @ 54.45 |
| July 17, 2026 | issue | SO-260717-978 | MAIN | 1 | 54.45 | -54.45 | 24 | 1,306.75 | June 20, 2026: 1 @ 54.45 |
| July 14, 2026 | issue | SO-260714-964 | MAIN | 2 | 54.45 | -108.90 | 25 | 1,361.20 | June 20, 2026: 2 @ 54.45 |
| July 11, 2026 | issue | SO-260711-959 | MAIN | 22 | 54.45 | -1,197.85 | 27 | 1,470.09 | June 20, 2026: 22 @ 54.45 |
| June 20, 2026 | receipt | PO-001589 | MAIN | 49 | 54.45 | 2,667.94 | 49 | 2,667.94 | |
| June 13, 2026 | issue | SO-260613-802 | MAIN | 13 | 53.56 | -696.30 | 0 | 0.00 | May 9, 2026: 13 @ 53.56 |
| June 11, 2026 | issue | SO-260611-218 | MAIN | 1 | 53.56 | -53.56 | 13 | 696.30 | May 9, 2026: 1 @ 53.56 |
| June 10, 2026 | issue | SO-260610-684 | MAIN | 15 | 53.56 | -803.43 | 14 | 749.87 | May 9, 2026: 15 @ 53.56 |
| June 10, 2026 | issue | SO-260610-684 | EAST | 4 | 53.56 | -214.25 | 29 | 1,553.29 | May 9, 2026: 4 @ 53.56 |
| May 24, 2026 | issue | SO-260524-164 | MAIN | 7 | 53.56 | -374.93 | 33 | 1,767.54 | May 9, 2026: 7 @ 53.56 |
| May 12, 2026 | issue | SO-260512-446 | MAIN | 7 | 53.56 | -374.93 | 40 | 2,142.47 | May 9, 2026: 7 @ 53.56 |
| May 10, 2026 | issue | SO-260510-678 | EAST | 10 | 54.94 | -549.44 | 47 | 2,517.40 | March 4, 2026: 8 @ 55.29; May 9, 2026: 2 @ 53.56 |
| May 9, 2026 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| May 9, 2026 | receipt | PO-001478 | MAIN | 49 | 53.56 | 2,624.53 | 57 | 3,066.85 | |
| April 29, 2026 | issue | SO-260429-916 | MAIN | 13 | 55.29 | -718.77 | 8 | 442.32 | March 4, 2026: 13 @ 55.29 |
| April 11, 2026 | issue | SO-260411-437 | MAIN | 10 | 55.29 | -552.90 | 21 | 1,161.08 | March 4, 2026: 10 @ 55.29 |
| March 10, 2026 | issue | SO-260310-722 | MAIN | 18 | 55.29 | -995.21 | 31 | 1,713.98 | March 4, 2026: 18 @ 55.29 |
| March 4, 2026 | receipt | PO-001283 | MAIN | 49 | 55.29 | 2,709.20 | 49 | 2,709.20 | |
| March 2, 2026 | issue | SO-260302-943 | MAIN | 9 | 54.58 | -491.19 | 0 | 0.00 | Jan. 26, 2026: 4 @ 54.58; Feb. 9, 2026: 5 @ 54.58 |
| Feb. 26, 2026 | issue | SO-260226-377 | MAIN | 14 | 54.58 | -764.08 | 9 | 491.19 | Jan. 26, 2026: 14 @ 54.58 |
| Feb. 9, 2026 | return | RMA | MAIN | 5 | 54.58 | 272.88 | 23 | 1,255.27 | |
| Feb. 8, 2026 | issue | SO-260208-832 | MAIN | 4 | 54.58 | -218.31 | 18 | 982.39 | Jan. 26, 2026: 4 @ 54.58 |
| Feb. 3, 2026 | issue | SO-260203-984 | MAIN | 10 | 54.58 | -545.77 | 22 | 1,200.69 | Jan. 26, 2026: 10 @ 54.58 |
| Jan. 27, 2026 | issue | SO-260127-877 | MAIN | 21 | 54.33 | -1,140.95 | 32 | 1,746.46 | Nov. 9, 2025: 4 @ 53.29; Jan. 26, 2026: 17 @ 54.58 |
| Jan. 26, 2026 | receipt | PO-001177 | MAIN | 49 | 54.58 | 2,674.27 | 53 | 2,887.41 | |
| Jan. 17, 2026 | issue | SO-260117-286 | MAIN | 12 | 53.29 | -639.42 | 4 | 213.14 | Nov. 9, 2025: 12 @ 53.29 |
| Jan. 11, 2026 | issue | SO-260111-403 | MAIN | 1 | 53.29 | -53.29 | 16 | 852.56 | Nov. 9, 2025: 1 @ 53.29 |
| Dec. 26, 2025 | issue | SO-251226-244 | MAIN | 22 | 53.29 | -1,172.27 | 17 | 905.85 | Nov. 9, 2025: 22 @ 53.29 |
| Dec. 25, 2025 | issue | SO-251225-410 | MAIN | 3 | 53.29 | -159.86 | 39 | 2,078.12 | Nov. 9, 2025: 3 @ 53.29 |
| Dec. 17, 2025 | issue | SO-251217-805 | MAIN | 1 | 53.29 | -53.29 | 42 | 2,237.97 | Nov. 9, 2025: 1 @ 53.29 |
| Dec. 2, 2025 | issue | SO-251202-479 | MAIN | 1 | 53.29 | -53.29 | 43 | 2,291.26 | Nov. 9, 2025: 1 @ 53.29 |
| Nov. 26, 2025 | issue | SO-251126-462 | MAIN | 3 | 53.29 | -159.86 | 44 | 2,344.54 | Nov. 9, 2025: 3 @ 53.29 |
| Nov. 10, 2025 | issue | SO-251110-764 | MAIN | 2 | 53.29 | -106.57 | 47 | 2,504.40 | Nov. 9, 2025: 2 @ 53.29 |
| Nov. 9, 2025 | receipt | PO-000988 | MAIN | 49 | 53.29 | 2,610.97 | 49 | 2,610.97 | |
| Nov. 2, 2025 | issue | SO-251102-657 | EAST | 8 | 54.26 | -434.06 | 0 | 0.00 | Aug. 22, 2025: 8 @ 54.26 |
| Nov. 1, 2025 | issue | SO-251101-151 | EAST | 1 | 54.26 | -54.26 | 8 | 434.06 | Aug. 22, 2025: 1 @ 54.26 |
| Oct. 31, 2025 | issue | SO-251031-349 | EAST | 1 | 54.26 | -54.26 | 9 | 488.31 | Aug. 22, 2025: 1 @ 54.26 |
| Oct. 31, 2025 | issue | SO-251031-349 | MAIN | 20 | 54.26 | -1,085.14 | 10 | 542.57 | Aug. 22, 2025: 20 @ 54.26 |
| Oct. 23, 2025 | issue | SO-251023-144 | MAIN | 4 | 54.26 | -217.03 | 30 | 1,627.72 | Aug. 22, 2025: 4 @ 54.26 |
| Oct. 17, 2025 | issue | SO-251017-746 | MAIN | 4 | 54.26 | -217.03 | 34 | 1,844.74 | Aug. 22, 2025: 4 @ 54.26 |