Items / MCB-0011
Isolator 63A Elite MCB-0011 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)60MAIN 60
Value (FIFO)2,014.84avg 33.58
ClassBY / FCV 0.52
Turnover7.2xlast issue 1 days ago
Days of cover34lead 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 | 53.00 / 30.4375 | 1.741 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 27.50 / 5.517 | 4.985 |
| 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 * 4.985^2 + 1.741^2 * 1.5^2) | 22.1 |
| Reorder point | d * LT + safety stock | 1.741 * 7.0 + 22.1 | 34.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 34.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 636/yr, S = 45.00, h = 20%, price = 33.83 | 91.9 |
| Inventory position | on hand + on order | 60 + 0 | 60 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 33.83 | 92 | 22,123 | yes (chosen if cheapest) |
MOQ 52, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 10, 2026 | 60 / 94 | 33.58 | 2,014.84 |
Movement ledger 129 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-567 | MAIN | 5 | 33.58 | -167.90 | 60 | 2,014.84 | Sept. 10, 2026: 5 @ 33.58 |
| Oct. 12, 2026 | issue | SO-261012-536 | MAIN | 3 | 33.58 | -100.74 | 65 | 2,182.75 | Sept. 10, 2026: 3 @ 33.58 |
| Oct. 8, 2026 | issue | SO-261008-895 | MAIN | 4 | 33.58 | -134.32 | 68 | 2,283.49 | Sept. 10, 2026: 4 @ 33.58 |
| Oct. 3, 2026 | issue | SO-261003-831 | MAIN | 2 | 33.58 | -67.16 | 72 | 2,417.81 | Sept. 10, 2026: 2 @ 33.58 |
| Oct. 1, 2026 | issue | SO-261001-111 | MAIN | 20 | 33.58 | -671.61 | 74 | 2,484.97 | Sept. 10, 2026: 20 @ 33.58 |
| Sept. 10, 2026 | receipt | PO-001788 | MAIN | 94 | 33.58 | 3,156.59 | 94 | 3,156.59 | |
| Sept. 2, 2026 | issue | SO-260902-731 | MAIN | 33 | 33.58 | -1,108.05 | 0 | 0.00 | July 8, 2026: 33 @ 33.58 |
| Aug. 19, 2026 | issue | SO-260819-935 | MAIN | 17 | 33.58 | -570.82 | 33 | 1,108.05 | July 8, 2026: 17 @ 33.58 |
| Aug. 15, 2026 | issue | SO-260815-636 | MAIN | 13 | 33.58 | -436.51 | 50 | 1,678.87 | July 8, 2026: 13 @ 33.58 |
| Aug. 2, 2026 | issue | SO-260802-226 | MAIN | 15 | 33.58 | -503.66 | 63 | 2,115.38 | July 8, 2026: 15 @ 33.58 |
| Aug. 1, 2026 | issue | SO-260801-628 | MAIN | 9 | 33.58 | -302.20 | 78 | 2,619.04 | July 8, 2026: 9 @ 33.58 |
| July 21, 2026 | issue | SO-260721-876 | MAIN | 7 | 33.58 | -235.04 | 87 | 2,921.23 | July 8, 2026: 7 @ 33.58 |
| July 16, 2026 | issue | SO-260716-504 | MAIN | 5 | 32.29 | -161.46 | 94 | 3,156.28 | June 25, 2026: 5 @ 32.29 |
| July 8, 2026 | receipt | PO-001636 | MAIN | 94 | 33.58 | 3,156.28 | 99 | 3,317.73 | |
| July 6, 2026 | issue | SO-260706-273 | MAIN | 5 | 32.29 | -161.46 | 5 | 161.46 | May 3, 2026: 1 @ 32.29; June 25, 2026: 4 @ 32.29 |
| July 4, 2026 | issue | SO-260704-145 | MAIN | 10 | 32.29 | -322.91 | 10 | 322.91 | May 3, 2026: 10 @ 32.29 |
| July 2, 2026 | issue | SO-260702-756 | MAIN | 10 | 32.29 | -322.91 | 20 | 645.82 | May 3, 2026: 10 @ 32.29 |
| June 29, 2026 | issue | SO-260629-227 | MAIN | 9 | 32.29 | -290.62 | 30 | 968.73 | May 3, 2026: 9 @ 32.29 |
| June 25, 2026 | return | RMA | MAIN | 9 | 32.29 | 290.62 | 39 | 1,259.35 | |
| June 21, 2026 | issue | SO-260621-137 | MAIN | 4 | 32.29 | -129.16 | 30 | 968.73 | May 3, 2026: 4 @ 32.29 |
| June 21, 2026 | issue | SO-260621-137 | EAST | 17 | 32.29 | -548.95 | 34 | 1,097.89 | May 3, 2026: 17 @ 32.29 |
| June 14, 2026 | issue | SO-260614-805 | MAIN | 18 | 32.29 | -581.24 | 51 | 1,646.84 | May 3, 2026: 18 @ 32.29 |
| May 30, 2026 | issue | SO-260530-540 | MAIN | 15 | 32.29 | -484.36 | 69 | 2,228.08 | May 3, 2026: 15 @ 32.29 |
| May 22, 2026 | issue | SO-260522-773 | EAST | 5 | 32.29 | -161.46 | 84 | 2,712.44 | May 3, 2026: 5 @ 32.29 |
| May 16, 2026 | issue | SO-260516-643 | EAST | 2 | 32.29 | -64.58 | 89 | 2,873.90 | May 3, 2026: 2 @ 32.29 |
| May 6, 2026 | issue | SO-260506-106 | MAIN | 14 | 32.40 | -453.65 | 91 | 2,938.48 | March 8, 2026: 11 @ 32.43; May 3, 2026: 3 @ 32.29 |
| May 5, 2026 | issue | SO-260505-392 | MAIN | 1 | 32.43 | -32.43 | 105 | 3,392.13 | March 8, 2026: 1 @ 32.43 |
| May 4, 2026 | issue | SO-260504-954 | MAIN | 2 | 32.43 | -64.87 | 106 | 3,424.57 | March 8, 2026: 2 @ 32.43 |
| May 3, 2026 | transfer | TRF | MAIN → EAST | 24 | warehouse transfer, no cost effect | ||||
| May 3, 2026 | receipt | PO-001461 | MAIN | 94 | 32.29 | 3,035.35 | 108 | 3,489.44 | |
| April 27, 2026 | issue | SO-260427-279 | MAIN | 11 | 32.43 | -356.78 | 14 | 454.08 | March 8, 2026: 11 @ 32.43 |
| April 24, 2026 | issue | SO-260424-597 | MAIN | 6 | 32.43 | -194.61 | 25 | 810.86 | March 8, 2026: 6 @ 32.43 |
| April 14, 2026 | issue | SO-260414-390 | MAIN | 4 | 32.43 | -129.74 | 31 | 1,005.47 | March 8, 2026: 4 @ 32.43 |
| April 2, 2026 | issue | SO-260402-622 | MAIN | 7 | 32.43 | -227.04 | 35 | 1,135.20 | March 8, 2026: 7 @ 32.43 |
| March 21, 2026 | issue | SO-260321-747 | MAIN | 33 | 32.43 | -1,070.34 | 42 | 1,362.24 | March 8, 2026: 33 @ 32.43 |
| March 12, 2026 | issue | SO-260312-794 | MAIN | 12 | 32.43 | -389.21 | 75 | 2,432.58 | March 8, 2026: 12 @ 32.43 |
| March 9, 2026 | issue | SO-260309-891 | MAIN | 25 | 32.90 | -822.49 | 87 | 2,821.79 | Dec. 29, 2025: 16 @ 33.08; March 5, 2026: 2 @ 33.08; March 8, 2026: 7 @ 32.43 |
| March 8, 2026 | receipt | PO-001297 | MAIN | 94 | 32.43 | 3,048.83 | 112 | 3,644.28 | |
| March 5, 2026 | return | RMA | MAIN | 2 | 33.08 | 66.16 | 18 | 595.45 | |
| March 4, 2026 | issue | SO-260304-206 | MAIN | 4 | 33.08 | -132.32 | 16 | 529.28 | Dec. 29, 2025: 4 @ 33.08 |
| Feb. 28, 2026 | issue | SO-260228-118 | MAIN | 8 | 33.08 | -264.64 | 20 | 661.61 | Dec. 29, 2025: 8 @ 33.08 |
| Feb. 20, 2026 | issue | SO-260220-244 | MAIN | 7 | 33.08 | -231.56 | 28 | 926.25 | Dec. 29, 2025: 7 @ 33.08 |
| Feb. 16, 2026 | issue | SO-260216-350 | MAIN | 4 | 33.08 | -132.32 | 35 | 1,157.81 | Dec. 29, 2025: 4 @ 33.08 |
| Feb. 14, 2026 | issue | SO-260214-698 | MAIN | 27 | 33.08 | -893.17 | 39 | 1,290.13 | Dec. 29, 2025: 27 @ 33.08 |
| Feb. 8, 2026 | issue | SO-260208-100 | MAIN | 1 | 33.08 | -33.08 | 66 | 2,183.30 | Dec. 29, 2025: 1 @ 33.08 |
| Feb. 6, 2026 | issue | SO-260206-171 | MAIN | 1 | 33.08 | -33.08 | 67 | 2,216.38 | Dec. 29, 2025: 1 @ 33.08 |
| Jan. 29, 2026 | issue | SO-260129-294 | MAIN | 8 | 33.08 | -264.64 | 68 | 2,249.46 | Dec. 29, 2025: 8 @ 33.08 |
| Jan. 26, 2026 | issue | SO-260126-411 | MAIN | 7 | 33.08 | -231.56 | 76 | 2,514.10 | Dec. 29, 2025: 7 @ 33.08 |
| Jan. 20, 2026 | issue | SO-260120-462 | MAIN | 5 | 33.08 | -165.40 | 83 | 2,745.66 | Dec. 29, 2025: 5 @ 33.08 |
| Jan. 10, 2026 | issue | SO-260110-793 | MAIN | 3 | 33.08 | -99.24 | 88 | 2,911.07 | Dec. 29, 2025: 3 @ 33.08 |
| Jan. 7, 2026 | issue | SO-260107-851 | MAIN | 3 | 33.08 | -99.24 | 91 | 3,010.31 | Dec. 29, 2025: 3 @ 33.08 |
| Dec. 29, 2025 | receipt | PO-001102 | MAIN | 94 | 33.08 | 3,109.55 | 94 | 3,109.55 | |
| Dec. 24, 2025 | issue | SO-251224-196 | MAIN | 22 | 31.74 | -698.30 | 0 | 0.00 | Dec. 8, 2025: 16 @ 31.74; Dec. 20, 2025: 6 @ 31.74 |
| Dec. 20, 2025 | return | RMA | MAIN | 6 | 31.74 | 190.45 | 22 | 698.30 | |
| Dec. 19, 2025 | issue | SO-251219-702 | MAIN | 70 | 31.74 | -2,221.88 | 16 | 507.86 | Dec. 8, 2025: 70 @ 31.74 |
| Dec. 13, 2025 | issue | SO-251213-540 | MAIN | 18 | 31.86 | -573.45 | 86 | 2,729.73 | Oct. 9, 2025: 10 @ 31.95; Dec. 8, 2025: 8 @ 31.74 |
| Dec. 8, 2025 | receipt | PO-001039 | MAIN | 94 | 31.74 | 2,983.66 | 104 | 3,303.18 | |
| Dec. 4, 2025 | issue | SO-251204-570 | MAIN | 12 | 31.95 | -383.42 | 10 | 319.52 | Oct. 9, 2025: 12 @ 31.95 |
| Dec. 1, 2025 | issue | SO-251201-497 | MAIN | 9 | 31.95 | -287.57 | 22 | 702.94 | Oct. 9, 2025: 9 @ 31.95 |
| Nov. 25, 2025 | issue | SO-251125-964 | MAIN | 57 | 31.95 | -1,821.26 | 31 | 990.51 | Oct. 9, 2025: 57 @ 31.95 |