Items / MCB-0013
MCB 6A SP Lite MCB-0013 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)0
Value (FIFO)0.00avg 0.00
ClassCX / FCV 0.46
Turnover12.4xlast issue 2 days ago
Days of cover0lead time 7d
Reorder suggested: 38 units (position at or below reorder point: order EOQ), stockout risk high.
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 | 12.67 / 30.4375 | 0.416 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 5.81 / 5.517 | 1.053 |
| 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.053^2 + 0.416^2 * 1.5^2) | 3.7 |
| Reorder point | d * LT + safety stock | 0.416 * 7.0 + 3.7 | 6.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 6.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 152/yr, S = 45.00, h = 20%, price = 49.56 | 37.1 |
| Inventory position | on hand + on order | 0 + 0 | 0 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 49.56 | 37 | 7,896 | yes (chosen if cheapest) |
MOQ 12, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| No stock. | ||||
Movement ledger 138 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | issue | SO-261014-584 | MAIN | 5 | 48.94 | -244.72 | 0 | 0.00 | July 22, 2026: 4 @ 48.94; Oct. 1, 2026: 1 @ 48.94 |
| Oct. 13, 2026 | issue | SO-261013-767 | MAIN | 1 | 48.94 | -48.94 | 5 | 244.72 | July 22, 2026: 1 @ 48.94 |
| Oct. 11, 2026 | issue | SO-261011-239 | MAIN | 1 | 48.94 | -48.94 | 6 | 293.66 | July 22, 2026: 1 @ 48.94 |
| Oct. 1, 2026 | return | RMA | MAIN | 1 | 48.94 | 48.94 | 7 | 342.61 | |
| Sept. 28, 2026 | issue | SO-260928-610 | MAIN | 1 | 48.94 | -48.94 | 6 | 293.66 | July 22, 2026: 1 @ 48.94 |
| Sept. 27, 2026 | issue | SO-260927-963 | MAIN | 1 | 48.94 | -48.94 | 7 | 342.61 | July 22, 2026: 1 @ 48.94 |
| Sept. 16, 2026 | issue | SO-260916-790 | MAIN | 1 | 48.94 | -48.94 | 8 | 391.55 | July 22, 2026: 1 @ 48.94 |
| Sept. 13, 2026 | issue | SO-260913-857 | MAIN | 2 | 48.94 | -97.89 | 9 | 440.50 | July 22, 2026: 2 @ 48.94 |
| Sept. 11, 2026 | issue | SO-260911-941 | MAIN | 1 | 48.94 | -48.94 | 11 | 538.38 | July 22, 2026: 1 @ 48.94 |
| Aug. 12, 2026 | issue | SO-260812-398 | MAIN | 1 | 48.94 | -48.94 | 12 | 587.33 | July 22, 2026: 1 @ 48.94 |
| Aug. 10, 2026 | issue | SO-260810-538 | MAIN | 1 | 48.94 | -48.94 | 13 | 636.27 | July 22, 2026: 1 @ 48.94 |
| Aug. 9, 2026 | issue | SO-260809-503 | MAIN | 5 | 48.94 | -244.72 | 14 | 685.21 | July 22, 2026: 5 @ 48.94 |
| July 27, 2026 | issue | SO-260727-508 | MAIN | 1 | 48.94 | -48.94 | 19 | 929.93 | July 22, 2026: 1 @ 48.94 |
| July 23, 2026 | issue | SO-260723-229 | MAIN | 2 | 48.94 | -97.89 | 20 | 978.88 | July 22, 2026: 2 @ 48.94 |
| July 22, 2026 | receipt | PO-001662 | MAIN | 22 | 48.94 | 1,076.77 | 22 | 1,076.77 | |
| July 17, 2026 | issue | SO-260717-195 | MAIN | 1 | 49.25 | -49.25 | 0 | 0.00 | June 30, 2026: 1 @ 49.25 |
| July 16, 2026 | issue | SO-260716-121 | MAIN | 10 | 49.25 | -492.48 | 1 | 49.25 | June 30, 2026: 10 @ 49.25 |
| July 11, 2026 | issue | SO-260711-122 | MAIN | 1 | 49.25 | -49.25 | 11 | 541.73 | June 30, 2026: 1 @ 49.25 |
| July 5, 2026 | issue | SO-260705-630 | MAIN | 8 | 49.25 | -393.99 | 12 | 590.98 | June 30, 2026: 8 @ 49.25 |
| July 1, 2026 | issue | SO-260701-127 | MAIN | 2 | 49.25 | -98.50 | 20 | 984.97 | June 30, 2026: 2 @ 49.25 |
| June 30, 2026 | receipt | PO-001613 | MAIN | 22 | 49.25 | 1,083.46 | 22 | 1,083.46 | |
| June 24, 2026 | issue | SO-260624-971 | EAST | 1 | 48.39 | -48.39 | 0 | 0.00 | May 28, 2026: 1 @ 48.39 |
| June 24, 2026 | issue | SO-260624-971 | MAIN | 1 | 48.39 | -48.39 | 1 | 48.39 | April 12, 2026: 1 @ 48.39 |
| June 22, 2026 | issue | SO-260622-918 | MAIN | 6 | 48.39 | -290.34 | 2 | 96.78 | April 12, 2026: 6 @ 48.39 |
| June 16, 2026 | issue | SO-260616-968 | EAST | 1 | 48.39 | -48.39 | 8 | 387.12 | April 12, 2026: 1 @ 48.39 |
| June 14, 2026 | issue | SO-260614-508 | EAST | 2 | 48.39 | -96.78 | 9 | 435.51 | April 12, 2026: 2 @ 48.39 |
| June 2, 2026 | issue | SO-260602-640 | MAIN | 1 | 48.39 | -48.39 | 11 | 532.29 | April 12, 2026: 1 @ 48.39 |
| May 31, 2026 | issue | SO-260531-987 | MAIN | 5 | 48.39 | -241.95 | 12 | 580.68 | April 12, 2026: 5 @ 48.39 |
| May 30, 2026 | issue | SO-260530-573 | MAIN | 1 | 48.39 | -48.39 | 17 | 822.64 | April 12, 2026: 1 @ 48.39 |
| May 28, 2026 | return | RMA | MAIN | 1 | 48.39 | 48.39 | 18 | 871.03 | |
| May 22, 2026 | issue | SO-260522-164 | MAIN | 1 | 48.39 | -48.39 | 17 | 822.64 | April 12, 2026: 1 @ 48.39 |
| May 15, 2026 | issue | SO-260515-840 | MAIN | 1 | 48.39 | -48.39 | 18 | 871.03 | April 12, 2026: 1 @ 48.39 |
| May 12, 2026 | issue | SO-260512-675 | MAIN | 1 | 48.39 | -48.39 | 19 | 919.42 | April 12, 2026: 1 @ 48.39 |
| May 2, 2026 | issue | SO-260502-142 | EAST | 1 | 48.39 | -48.39 | 20 | 967.81 | April 12, 2026: 1 @ 48.39 |
| April 16, 2026 | issue | SO-260416-791 | MAIN | 1 | 48.39 | -48.39 | 21 | 1,016.20 | April 12, 2026: 1 @ 48.39 |
| April 12, 2026 | issue | SO-260412-450 | MAIN | 1 | 48.06 | -48.06 | 22 | 1,064.59 | Feb. 6, 2026: 1 @ 48.06 |
| April 12, 2026 | transfer | TRF | MAIN → EAST | 5 | warehouse transfer, no cost effect | ||||
| April 12, 2026 | receipt | PO-001404 | MAIN | 22 | 48.39 | 1,064.59 | 23 | 1,112.65 | |
| April 10, 2026 | issue | SO-260410-946 | MAIN | 1 | 48.06 | -48.06 | 1 | 48.06 | Feb. 6, 2026: 1 @ 48.06 |
| April 4, 2026 | issue | SO-260404-842 | MAIN | 1 | 48.06 | -48.06 | 2 | 96.13 | Feb. 6, 2026: 1 @ 48.06 |
| April 4, 2026 | issue | SO-260404-842 | EAST | 5 | 48.06 | -240.32 | 3 | 144.19 | Feb. 6, 2026: 5 @ 48.06 |
| April 3, 2026 | issue | SO-260403-317 | MAIN | 1 | 48.06 | -48.06 | 8 | 384.50 | Feb. 6, 2026: 1 @ 48.06 |
| April 2, 2026 | issue | SO-260402-951 | EAST | 1 | 48.06 | -48.06 | 9 | 432.57 | Feb. 6, 2026: 1 @ 48.06 |
| March 28, 2026 | issue | SO-260328-114 | MAIN | 6 | 48.06 | -288.38 | 10 | 480.63 | Feb. 6, 2026: 6 @ 48.06 |
| March 26, 2026 | issue | SO-260326-585 | EAST | 1 | 48.06 | -48.06 | 16 | 769.01 | Feb. 6, 2026: 1 @ 48.06 |
| March 20, 2026 | issue | SO-260320-428 | MAIN | 3 | 48.06 | -144.19 | 17 | 817.07 | Feb. 6, 2026: 3 @ 48.06 |
| Feb. 7, 2026 | issue | SO-260207-396 | MAIN | 1 | 48.06 | -48.06 | 20 | 961.26 | Feb. 6, 2026: 1 @ 48.06 |
| Feb. 6, 2026 | issue | SO-260206-726 | MAIN | 1 | 48.06 | -48.06 | 21 | 1,009.33 | Feb. 6, 2026: 1 @ 48.06 |
| Feb. 6, 2026 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| Feb. 6, 2026 | receipt | PO-001204 | MAIN | 22 | 48.06 | 1,057.39 | 22 | 1,057.39 | |
| Feb. 2, 2026 | issue | SO-260202-803 | MAIN | 11 | 47.00 | -517.04 | 0 | 0.00 | Dec. 22, 2025: 11 @ 47.00 |
| Jan. 31, 2026 | issue | SO-260131-156 | MAIN | 2 | 47.00 | -94.01 | 11 | 517.04 | Dec. 22, 2025: 2 @ 47.00 |
| Jan. 25, 2026 | issue | SO-260125-960 | MAIN | 2 | 47.00 | -94.01 | 13 | 611.04 | Dec. 22, 2025: 2 @ 47.00 |
| Jan. 22, 2026 | issue | SO-260122-839 | MAIN | 1 | 47.00 | -47.00 | 15 | 705.05 | Dec. 22, 2025: 1 @ 47.00 |
| Jan. 17, 2026 | issue | SO-260117-163 | MAIN | 1 | 47.00 | -47.00 | 16 | 752.05 | Dec. 22, 2025: 1 @ 47.00 |
| Jan. 16, 2026 | issue | SO-260116-637 | MAIN | 1 | 47.00 | -47.00 | 17 | 799.05 | Dec. 22, 2025: 1 @ 47.00 |
| Jan. 4, 2026 | issue | SO-260104-708 | MAIN | 1 | 47.00 | -47.00 | 18 | 846.06 | Dec. 22, 2025: 1 @ 47.00 |
| Dec. 29, 2025 | issue | SO-251229-592 | MAIN | 1 | 47.00 | -47.00 | 19 | 893.06 | Dec. 22, 2025: 1 @ 47.00 |
| Dec. 23, 2025 | issue | SO-251223-410 | MAIN | 1 | 47.00 | -47.00 | 20 | 940.06 | Dec. 22, 2025: 1 @ 47.00 |
| Dec. 22, 2025 | issue | SO-251222-964 | MAIN | 6 | 46.72 | -280.31 | 21 | 987.07 | Nov. 7, 2025: 5 @ 46.66; Dec. 22, 2025: 1 @ 47.00 |