Items / MCB-0021
Isolator 63A Eco MCB-0021 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)49MAIN 49
Value (FIFO)6,305.11avg 128.68
ClassAX / FCV 0.40
Turnover6.7xlast issue 10 days ago
Days of cover62lead 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 | 24.00 / 30.4375 | 0.789 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.71 / 5.517 | 1.760 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(7.0 * 1.760^2 + 0.789^2 * 1.5^2) | 9.9 |
| Reorder point | d * LT + safety stock | 0.789 * 7.0 + 9.9 | 15.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 15.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 288/yr, S = 45.00, h = 20%, price = 131.69 | 31.4 |
| Inventory position | on hand + on order | 49 + 0 | 49 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 131.69 | 31 | 38,727 | yes (chosen if cheapest) |
MOQ 25, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 8, 2026 | 5 / 44 | 127.80 | 638.98 | |
| Oct. 11, 2026 | 44 / 44 | 128.78 | 5,666.14 |
Movement ledger 142 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 11, 2026 | receipt | PO-001871 | MAIN | 44 | 128.78 | 5,666.14 | 49 | 6,305.11 | |
| Oct. 6, 2026 | issue | SO-261006-556 | MAIN | 32 | 127.80 | -4,089.44 | 5 | 638.98 | Sept. 8, 2026: 32 @ 127.80 |
| Oct. 5, 2026 | issue | SO-261005-638 | EAST | 3 | 127.80 | -383.38 | 37 | 4,728.42 | Sept. 8, 2026: 3 @ 127.80 |
| Sept. 27, 2026 | issue | SO-260927-234 | MAIN | 1 | 127.80 | -127.80 | 40 | 5,111.80 | Sept. 8, 2026: 1 @ 127.80 |
| Sept. 24, 2026 | issue | SO-260924-468 | MAIN | 6 | 129.94 | -779.64 | 41 | 5,239.60 | Aug. 28, 2026: 3 @ 132.09; Sept. 8, 2026: 3 @ 127.80 |
| Sept. 20, 2026 | issue | SO-260920-309 | MAIN | 2 | 132.09 | -264.17 | 47 | 6,019.24 | Aug. 28, 2026: 2 @ 132.09 |
| Sept. 10, 2026 | issue | SO-260910-234 | MAIN | 1 | 132.09 | -132.09 | 49 | 6,283.41 | Aug. 28, 2026: 1 @ 132.09 |
| Sept. 8, 2026 | receipt | PO-001783 | MAIN | 44 | 127.80 | 5,622.98 | 50 | 6,415.49 | |
| Sept. 7, 2026 | issue | SO-260907-544 | MAIN | 5 | 132.09 | -660.43 | 6 | 792.51 | Aug. 28, 2026: 5 @ 132.09 |
| Sept. 2, 2026 | issue | SO-260902-811 | MAIN | 3 | 132.09 | -396.26 | 11 | 1,452.94 | Aug. 28, 2026: 3 @ 132.09 |
| Aug. 30, 2026 | issue | SO-260830-561 | EAST | 11 | 132.09 | -1,452.94 | 14 | 1,849.19 | Aug. 28, 2026: 11 @ 132.09 |
| Aug. 29, 2026 | issue | SO-260829-544 | MAIN | 22 | 131.38 | -2,890.34 | 25 | 3,302.13 | Aug. 10, 2026: 3 @ 126.91; Aug. 28, 2026: 19 @ 132.09 |
| Aug. 28, 2026 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| Aug. 28, 2026 | receipt | PO-001755 | MAIN | 44 | 132.09 | 5,811.75 | 47 | 6,192.47 | |
| Aug. 26, 2026 | issue | SO-260826-949 | MAIN | 8 | 126.91 | -1,015.25 | 3 | 380.72 | July 16, 2026: 6 @ 126.91; Aug. 10, 2026: 2 @ 126.91 |
| Aug. 23, 2026 | issue | SO-260823-574 | MAIN | 5 | 126.91 | -634.53 | 11 | 1,395.97 | July 7, 2026: 5 @ 126.91 |
| Aug. 20, 2026 | issue | SO-260820-976 | MAIN | 10 | 126.91 | -1,269.06 | 16 | 2,030.50 | July 7, 2026: 10 @ 126.91 |
| Aug. 10, 2026 | return | RMA | MAIN | 5 | 126.91 | 634.53 | 26 | 3,299.56 | |
| July 28, 2026 | issue | SO-260728-484 | MAIN | 1 | 126.91 | -126.91 | 21 | 2,665.03 | July 7, 2026: 1 @ 126.91 |
| July 27, 2026 | issue | SO-260727-525 | MAIN | 10 | 126.91 | -1,269.06 | 22 | 2,791.94 | July 7, 2026: 10 @ 126.91 |
| July 21, 2026 | issue | SO-260721-324 | MAIN | 3 | 126.91 | -380.72 | 32 | 4,061.00 | July 7, 2026: 3 @ 126.91 |
| July 18, 2026 | issue | SO-260718-467 | MAIN | 11 | 126.91 | -1,395.97 | 35 | 4,441.72 | July 7, 2026: 11 @ 126.91 |
| July 16, 2026 | return | RMA | MAIN | 6 | 126.91 | 761.44 | 46 | 5,837.69 | |
| July 15, 2026 | issue | SO-260715-106 | MAIN | 4 | 126.91 | -507.63 | 40 | 5,076.25 | July 7, 2026: 4 @ 126.91 |
| July 7, 2026 | receipt | PO-001631 | MAIN | 44 | 126.91 | 5,583.88 | 44 | 5,583.88 | |
| June 28, 2026 | issue | SO-260628-793 | MAIN | 13 | 128.57 | -1,671.45 | 0 | 0.00 | April 2, 2026: 13 @ 128.57 |
| June 8, 2026 | issue | SO-260608-211 | MAIN | 9 | 128.57 | -1,157.16 | 13 | 1,671.45 | April 2, 2026: 9 @ 128.57 |
| May 28, 2026 | issue | SO-260528-643 | MAIN | 19 | 128.57 | -2,442.89 | 22 | 2,828.61 | April 2, 2026: 19 @ 128.57 |
| May 14, 2026 | issue | SO-260514-567 | MAIN | 1 | 128.57 | -128.57 | 41 | 5,271.51 | April 2, 2026: 1 @ 128.57 |
| April 27, 2026 | issue | SO-260427-815 | MAIN | 1 | 128.57 | -128.57 | 42 | 5,400.08 | April 2, 2026: 1 @ 128.57 |
| April 19, 2026 | issue | SO-260419-551 | MAIN | 4 | 127.72 | -510.89 | 43 | 5,528.66 | Feb. 7, 2026: 3 @ 127.44; April 2, 2026: 1 @ 128.57 |
| April 18, 2026 | issue | SO-260418-689 | MAIN | 1 | 127.44 | -127.44 | 47 | 6,039.54 | Feb. 7, 2026: 1 @ 127.44 |
| April 14, 2026 | issue | SO-260414-886 | MAIN | 3 | 127.44 | -382.31 | 48 | 6,166.98 | Feb. 7, 2026: 3 @ 127.44 |
| April 3, 2026 | issue | SO-260403-168 | MAIN | 2 | 127.44 | -254.88 | 51 | 6,549.29 | Feb. 7, 2026: 2 @ 127.44 |
| April 2, 2026 | receipt | PO-001376 | MAIN | 44 | 128.57 | 5,657.23 | 53 | 6,804.17 | |
| March 24, 2026 | issue | SO-260324-388 | MAIN | 7 | 127.44 | -892.07 | 9 | 1,146.94 | Feb. 7, 2026: 7 @ 127.44 |
| March 16, 2026 | issue | SO-260316-479 | MAIN | 1 | 127.44 | -127.44 | 16 | 2,039.01 | Feb. 7, 2026: 1 @ 127.44 |
| March 6, 2026 | issue | SO-260306-186 | MAIN | 2 | 127.44 | -254.88 | 17 | 2,166.44 | Feb. 7, 2026: 2 @ 127.44 |
| March 4, 2026 | issue | SO-260304-566 | MAIN | 5 | 127.44 | -637.19 | 19 | 2,421.32 | Feb. 7, 2026: 5 @ 127.44 |
| Feb. 10, 2026 | issue | SO-260210-843 | MAIN | 20 | 127.44 | -2,548.76 | 24 | 3,058.51 | Feb. 7, 2026: 20 @ 127.44 |
| Feb. 7, 2026 | receipt | PO-001207 | MAIN | 44 | 127.44 | 5,607.27 | 44 | 5,607.27 | |
| Feb. 3, 2026 | issue | SO-260203-516 | MAIN | 1 | 124.36 | -124.36 | 0 | 0.00 | Nov. 29, 2025: 1 @ 124.36 |
| Jan. 31, 2026 | issue | SO-260131-289 | MAIN | 16 | 124.36 | -1,989.74 | 1 | 124.36 | Nov. 29, 2025: 16 @ 124.36 |
| Jan. 25, 2026 | issue | SO-260125-285 | MAIN | 6 | 124.36 | -746.15 | 17 | 2,114.10 | Nov. 29, 2025: 6 @ 124.36 |
| Jan. 18, 2026 | issue | SO-260118-651 | MAIN | 2 | 124.36 | -248.72 | 23 | 2,860.25 | Nov. 29, 2025: 2 @ 124.36 |
| Jan. 4, 2026 | issue | SO-260104-101 | MAIN | 5 | 124.36 | -621.79 | 25 | 3,108.97 | Nov. 29, 2025: 5 @ 124.36 |
| Jan. 2, 2026 | issue | SO-260102-808 | MAIN | 2 | 124.36 | -248.72 | 30 | 3,730.76 | Nov. 29, 2025: 2 @ 124.36 |
| Dec. 30, 2025 | issue | SO-251230-960 | MAIN | 5 | 124.36 | -621.79 | 32 | 3,979.48 | Nov. 29, 2025: 5 @ 124.36 |
| Dec. 23, 2025 | issue | SO-251223-403 | MAIN | 1 | 124.36 | -124.36 | 37 | 4,601.28 | Nov. 29, 2025: 1 @ 124.36 |
| Dec. 16, 2025 | issue | SO-251216-963 | MAIN | 2 | 124.36 | -248.72 | 38 | 4,725.63 | Nov. 29, 2025: 2 @ 124.36 |
| Dec. 16, 2025 | issue | SO-251216-963 | EAST | 1 | 124.36 | -124.36 | 40 | 4,974.35 | Nov. 29, 2025: 1 @ 124.36 |
| Dec. 10, 2025 | issue | SO-251210-650 | EAST | 2 | 124.36 | -248.72 | 41 | 5,098.71 | Nov. 29, 2025: 2 @ 124.36 |
| Dec. 7, 2025 | issue | SO-251207-520 | MAIN | 9 | 123.78 | -1,114.02 | 43 | 5,347.43 | Oct. 12, 2025: 8 @ 123.71; Nov. 29, 2025: 1 @ 124.36 |
| Dec. 4, 2025 | issue | SO-251204-430 | MAIN | 1 | 123.71 | -123.71 | 52 | 6,461.45 | Oct. 12, 2025: 1 @ 123.71 |
| Nov. 29, 2025 | receipt | PO-001025 | MAIN | 44 | 124.36 | 5,471.79 | 53 | 6,585.15 | |
| Nov. 23, 2025 | issue | SO-251123-809 | MAIN | 10 | 123.71 | -1,237.08 | 9 | 1,113.37 | Oct. 12, 2025: 10 @ 123.71 |
| Nov. 19, 2025 | issue | SO-251119-608 | MAIN | 1 | 123.71 | -123.71 | 19 | 2,350.44 | Oct. 12, 2025: 1 @ 123.71 |
| Nov. 18, 2025 | issue | SO-251118-554 | MAIN | 2 | 123.71 | -247.42 | 20 | 2,474.15 | Oct. 12, 2025: 2 @ 123.71 |
| Nov. 16, 2025 | issue | SO-251116-121 | MAIN | 1 | 123.71 | -123.71 | 22 | 2,721.56 | Oct. 12, 2025: 1 @ 123.71 |
| Nov. 11, 2025 | issue | SO-251111-198 | EAST | 1 | 123.71 | -123.71 | 23 | 2,845.27 | Oct. 12, 2025: 1 @ 123.71 |