Items / MCB-0005
Isolator 63A Pro MCB-0005 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)28MAIN 25, EAST 3
Value (FIFO)592.13avg 21.15
ClassCX / FCV 0.50
Turnover14.2xlast issue 10 days ago
Days of cover45lead 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 | 19.00 / 30.4375 | 0.624 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.43 / 5.517 | 1.710 |
| 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 * 1.710^2 + 0.624^2 * 1.5^2) | 5.9 |
| Reorder point | d * LT + safety stock | 0.624 * 7.0 + 5.9 | 10.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 10.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 228/yr, S = 45.00, h = 20%, price = 19.56 | 72.4 |
| Inventory position | on hand + on order | 28 + 0 | 28 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 21.26 | 69 | 5,139 | no |
| 34 | 20.41 | 71 | 4,940 | no |
| 68 | 19.56 | 72 | 4,740 | yes (chosen if cheapest) |
MOQ 17, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 6, 2026 | 28 / 31 | 21.15 | 592.13 |
Movement ledger 134 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 6, 2026 | issue | SO-261006-765 | EAST | 3 | 21.15 | -63.44 | 28 | 592.13 | Oct. 6, 2026: 3 @ 21.15 |
| Oct. 6, 2026 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| Oct. 6, 2026 | receipt | PO-001854 | MAIN | 31 | 21.15 | 655.57 | 31 | 655.57 | |
| Sept. 29, 2026 | issue | SO-260929-744 | MAIN | 35 | 21.53 | -753.50 | 0 | 0.00 | June 29, 2026: 1 @ 20.87; July 8, 2026: 3 @ 20.87; Sept. 19, 2026: 31 @ 21.61 |
| Sept. 19, 2026 | receipt | PO-001811 | MAIN | 31 | 21.61 | 670.02 | 35 | 753.50 | |
| Sept. 11, 2026 | issue | SO-260911-549 | MAIN | 8 | 20.87 | -166.95 | 4 | 83.48 | June 29, 2026: 8 @ 20.87 |
| Sept. 1, 2026 | issue | SO-260901-480 | MAIN | 3 | 20.87 | -62.61 | 12 | 250.43 | June 29, 2026: 3 @ 20.87 |
| Aug. 21, 2026 | issue | SO-260821-711 | MAIN | 2 | 20.87 | -41.74 | 15 | 313.04 | June 29, 2026: 2 @ 20.87 |
| Aug. 16, 2026 | issue | SO-260816-155 | MAIN | 6 | 20.87 | -125.22 | 17 | 354.78 | June 29, 2026: 6 @ 20.87 |
| July 30, 2026 | issue | SO-260730-150 | MAIN | 3 | 20.87 | -62.61 | 23 | 479.99 | June 29, 2026: 3 @ 20.87 |
| July 24, 2026 | issue | SO-260724-686 | MAIN | 1 | 20.87 | -20.87 | 26 | 542.60 | June 29, 2026: 1 @ 20.87 |
| July 8, 2026 | return | RMA | MAIN | 3 | 20.87 | 62.61 | 27 | 563.47 | |
| July 8, 2026 | issue | SO-260708-679 | MAIN | 1 | 20.87 | -20.87 | 24 | 500.86 | June 29, 2026: 1 @ 20.87 |
| July 2, 2026 | issue | SO-260702-409 | MAIN | 6 | 20.87 | -125.22 | 25 | 521.73 | June 29, 2026: 6 @ 20.87 |
| June 29, 2026 | receipt | PO-001610 | MAIN | 31 | 20.87 | 646.95 | 31 | 646.95 | |
| June 26, 2026 | issue | SO-260626-175 | EAST | 1 | 21.26 | -21.26 | 0 | 0.00 | May 2, 2026: 1 @ 21.26 |
| June 26, 2026 | issue | SO-260626-175 | MAIN | 2 | 21.26 | -42.51 | 1 | 21.26 | May 2, 2026: 2 @ 21.26 |
| June 22, 2026 | issue | SO-260622-726 | MAIN | 5 | 21.26 | -106.28 | 3 | 63.77 | May 2, 2026: 5 @ 21.26 |
| June 21, 2026 | issue | SO-260621-276 | MAIN | 2 | 21.26 | -42.51 | 8 | 170.06 | May 2, 2026: 2 @ 21.26 |
| June 11, 2026 | issue | SO-260611-351 | EAST | 1 | 21.26 | -21.26 | 10 | 212.57 | May 2, 2026: 1 @ 21.26 |
| June 10, 2026 | issue | SO-260610-269 | MAIN | 1 | 21.26 | -21.26 | 11 | 233.83 | May 2, 2026: 1 @ 21.26 |
| June 9, 2026 | issue | SO-260609-440 | MAIN | 1 | 21.26 | -21.26 | 12 | 255.08 | May 2, 2026: 1 @ 21.26 |
| June 5, 2026 | adjustment | Cycle count | MAIN | -2 | 21.26 | -42.51 | 13 | 276.34 | May 2, 2026: 2 @ 21.26 |
| June 2, 2026 | issue | SO-260602-576 | EAST | 2 | 21.26 | -42.51 | 15 | 318.86 | May 2, 2026: 2 @ 21.26 |
| May 21, 2026 | issue | SO-260521-486 | MAIN | 15 | 21.20 | -318.04 | 17 | 361.37 | April 25, 2026: 1 @ 20.44; May 2, 2026: 14 @ 21.26 |
| May 12, 2026 | issue | SO-260512-679 | MAIN | 7 | 20.44 | -143.10 | 32 | 679.41 | March 10, 2026: 4 @ 20.44; April 25, 2026: 3 @ 20.44 |
| May 2, 2026 | receipt | PO-001458 | MAIN | 31 | 21.26 | 658.97 | 39 | 822.51 | |
| April 25, 2026 | return | RMA | MAIN | 4 | 20.44 | 81.77 | 8 | 163.55 | |
| April 22, 2026 | issue | SO-260422-997 | EAST | 7 | 20.44 | -143.10 | 4 | 81.77 | March 10, 2026: 7 @ 20.44 |
| April 22, 2026 | issue | SO-260422-997 | MAIN | 1 | 20.44 | -20.44 | 11 | 224.88 | March 10, 2026: 1 @ 20.44 |
| April 21, 2026 | issue | SO-260421-227 | MAIN | 8 | 20.44 | -163.55 | 12 | 245.32 | March 10, 2026: 8 @ 20.44 |
| April 4, 2026 | issue | SO-260404-834 | MAIN | 2 | 20.44 | -40.89 | 20 | 408.86 | March 10, 2026: 2 @ 20.44 |
| March 22, 2026 | issue | SO-260322-716 | MAIN | 1 | 20.44 | -20.44 | 22 | 449.75 | March 10, 2026: 1 @ 20.44 |
| March 17, 2026 | issue | SO-260317-596 | MAIN | 9 | 20.46 | -184.17 | 23 | 470.19 | Jan. 28, 2026: 1 @ 20.62; March 10, 2026: 8 @ 20.44 |
| March 10, 2026 | transfer | TRF | MAIN → EAST | 11 | warehouse transfer, no cost effect | ||||
| March 10, 2026 | receipt | PO-001305 | MAIN | 31 | 20.44 | 633.74 | 32 | 654.36 | |
| March 1, 2026 | issue | SO-260301-664 | MAIN | 11 | 20.62 | -226.85 | 1 | 20.62 | Jan. 28, 2026: 11 @ 20.62 |
| Feb. 22, 2026 | issue | SO-260222-273 | MAIN | 2 | 20.62 | -41.25 | 12 | 247.47 | Jan. 28, 2026: 2 @ 20.62 |
| Feb. 19, 2026 | issue | SO-260219-966 | MAIN | 1 | 20.62 | -20.62 | 14 | 288.72 | Jan. 28, 2026: 1 @ 20.62 |
| Feb. 8, 2026 | issue | SO-260208-865 | MAIN | 11 | 20.62 | -226.85 | 15 | 309.34 | Jan. 28, 2026: 11 @ 20.62 |
| Feb. 6, 2026 | issue | SO-260206-810 | MAIN | 1 | 20.62 | -20.62 | 26 | 536.19 | Jan. 28, 2026: 1 @ 20.62 |
| Feb. 3, 2026 | issue | SO-260203-889 | MAIN | 5 | 20.67 | -103.35 | 27 | 556.82 | Dec. 7, 2025: 1 @ 20.86; Jan. 28, 2026: 4 @ 20.62 |
| Jan. 28, 2026 | receipt | PO-001182 | MAIN | 31 | 20.62 | 639.31 | 32 | 660.16 | |
| Jan. 26, 2026 | issue | SO-260126-274 | MAIN | 1 | 20.86 | -20.86 | 1 | 20.86 | Dec. 7, 2025: 1 @ 20.86 |
| Jan. 22, 2026 | issue | SO-260122-823 | MAIN | 11 | 20.86 | -229.42 | 2 | 41.71 | Dec. 7, 2025: 11 @ 20.86 |
| Jan. 19, 2026 | issue | SO-260119-304 | MAIN | 1 | 20.86 | -20.86 | 13 | 271.13 | Dec. 7, 2025: 1 @ 20.86 |
| Jan. 16, 2026 | issue | SO-260116-493 | MAIN | 2 | 20.86 | -41.71 | 14 | 291.99 | Dec. 7, 2025: 2 @ 20.86 |
| Jan. 9, 2026 | issue | SO-260109-257 | MAIN | 3 | 20.86 | -62.57 | 16 | 333.70 | Dec. 7, 2025: 3 @ 20.86 |
| Dec. 30, 2025 | issue | SO-251230-929 | MAIN | 7 | 20.86 | -145.99 | 19 | 396.27 | Dec. 7, 2025: 7 @ 20.86 |
| Dec. 27, 2025 | issue | SO-251227-563 | MAIN | 2 | 20.86 | -41.71 | 26 | 542.26 | Dec. 7, 2025: 2 @ 20.86 |
| Dec. 13, 2025 | issue | SO-251213-161 | MAIN | 6 | 20.67 | -124.04 | 28 | 583.97 | Oct. 20, 2025: 3 @ 20.49; Dec. 7, 2025: 3 @ 20.86 |
| Dec. 12, 2025 | issue | SO-251212-547 | MAIN | 2 | 20.49 | -40.98 | 34 | 708.01 | Oct. 20, 2025: 2 @ 20.49 |
| Dec. 7, 2025 | receipt | PO-001037 | MAIN | 31 | 20.86 | 646.54 | 36 | 748.99 | |
| Dec. 4, 2025 | issue | SO-251204-695 | MAIN | 1 | 20.49 | -20.49 | 5 | 102.45 | Oct. 20, 2025: 1 @ 20.49 |
| Dec. 2, 2025 | issue | SO-251202-150 | MAIN | 1 | 20.49 | -20.49 | 6 | 122.94 | Oct. 20, 2025: 1 @ 20.49 |
| Nov. 28, 2025 | issue | SO-251128-784 | MAIN | 1 | 20.49 | -20.49 | 7 | 143.43 | Oct. 20, 2025: 1 @ 20.49 |
| Nov. 23, 2025 | issue | SO-251123-364 | MAIN | 14 | 20.49 | -286.86 | 8 | 163.92 | Oct. 20, 2025: 14 @ 20.49 |
| Nov. 18, 2025 | issue | SO-251118-279 | MAIN | 1 | 20.49 | -20.49 | 22 | 450.78 | Oct. 20, 2025: 1 @ 20.49 |
| Nov. 9, 2025 | issue | SO-251109-384 | MAIN | 7 | 20.49 | -143.43 | 23 | 471.27 | Oct. 20, 2025: 7 @ 20.49 |
| Oct. 30, 2025 | issue | SO-251030-826 | MAIN | 1 | 20.49 | -20.49 | 30 | 614.70 | Oct. 20, 2025: 1 @ 20.49 |