Items / MCB-0003
Isolator 63A Eco MCB-0003 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)21MAIN 21
Value (FIFO)2,905.74avg 138.37
ClassAY / FCV 0.62
Turnover16.0xlast issue 1 days ago
Days of cover32lead 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.75 / 30.4375 | 0.649 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 12.15 / 5.517 | 2.203 |
| 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 * 2.203^2 + 0.649^2 * 1.5^2) | 12.1 |
| Reorder point | d * LT + safety stock | 0.649 * 7.0 + 12.1 | 16.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 16.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 237/yr, S = 45.00, h = 20%, price = 137.17 | 27.9 |
| Inventory position | on hand + on order | 21 + 0 | 21 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 137.17 | 28 | 33,252 | yes (chosen if cheapest) |
MOQ 20, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 29, 2026 | 21 / 36 | 138.37 | 2,905.74 |
Movement ledger 130 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-469 | MAIN | 2 | 138.37 | -276.74 | 21 | 2,905.74 | Sept. 29, 2026: 2 @ 138.37 |
| Oct. 14, 2026 | issue | SO-261014-707 | MAIN | 3 | 138.37 | -415.11 | 23 | 3,182.48 | Sept. 29, 2026: 3 @ 138.37 |
| Oct. 13, 2026 | issue | SO-261013-756 | MAIN | 5 | 138.37 | -691.84 | 26 | 3,597.58 | Sept. 29, 2026: 5 @ 138.37 |
| Oct. 4, 2026 | issue | SO-261004-910 | MAIN | 3 | 138.37 | -415.11 | 31 | 4,289.43 | Sept. 29, 2026: 3 @ 138.37 |
| Oct. 3, 2026 | issue | SO-261003-225 | MAIN | 2 | 138.37 | -276.74 | 34 | 4,704.53 | Sept. 29, 2026: 2 @ 138.37 |
| Sept. 29, 2026 | receipt | PO-001840 | MAIN | 36 | 138.37 | 4,981.27 | 36 | 4,981.27 | |
| Sept. 22, 2026 | issue | SO-260922-571 | MAIN | 2 | 131.66 | -263.32 | 0 | 0.00 | Aug. 3, 2026: 2 @ 131.66 |
| Sept. 22, 2026 | issue | SO-260922-571 | EAST | 2 | 131.66 | -263.32 | 2 | 263.32 | Aug. 3, 2026: 2 @ 131.66 |
| Sept. 20, 2026 | issue | SO-260920-931 | MAIN | 9 | 133.89 | -1,205.01 | 4 | 526.64 | Aug. 3, 2026: 8 @ 134.17; Aug. 3, 2026: 1 @ 131.66 |
| Sept. 19, 2026 | issue | SO-260919-676 | MAIN | 1 | 134.17 | -134.17 | 13 | 1,731.65 | Aug. 3, 2026: 1 @ 134.17 |
| Sept. 11, 2026 | issue | SO-260911-922 | MAIN | 1 | 134.17 | -134.17 | 14 | 1,865.82 | Aug. 3, 2026: 1 @ 134.17 |
| Sept. 10, 2026 | issue | SO-260910-276 | MAIN | 4 | 134.17 | -536.68 | 15 | 1,999.99 | Aug. 3, 2026: 4 @ 134.17 |
| Aug. 24, 2026 | issue | SO-260824-167 | MAIN | 11 | 134.17 | -1,475.86 | 19 | 2,536.66 | Aug. 3, 2026: 11 @ 134.17 |
| Aug. 16, 2026 | issue | SO-260816-924 | MAIN | 3 | 134.17 | -402.51 | 30 | 4,012.52 | Aug. 3, 2026: 3 @ 134.17 |
| Aug. 11, 2026 | issue | SO-260811-155 | EAST | 6 | 134.17 | -805.01 | 33 | 4,415.03 | Aug. 3, 2026: 6 @ 134.17 |
| Aug. 8, 2026 | issue | SO-260808-542 | MAIN | 2 | 134.17 | -268.34 | 39 | 5,220.04 | Aug. 3, 2026: 2 @ 134.17 |
| Aug. 3, 2026 | return | RMA | MAIN | 5 | 131.66 | 658.30 | 41 | 5,488.38 | |
| Aug. 3, 2026 | transfer | TRF | MAIN → EAST | 8 | warehouse transfer, no cost effect | ||||
| Aug. 3, 2026 | receipt | PO-001695 | MAIN | 36 | 134.17 | 4,830.08 | 36 | 4,830.08 | |
| July 29, 2026 | issue | SO-260729-324 | MAIN | 4 | 131.66 | -526.64 | 0 | 0.00 | May 6, 2026: 3 @ 131.66; May 16, 2026: 1 @ 131.66 |
| July 28, 2026 | issue | SO-260728-942 | MAIN | 11 | 131.66 | -1,448.25 | 4 | 526.64 | May 6, 2026: 11 @ 131.66 |
| June 28, 2026 | issue | SO-260628-459 | MAIN | 2 | 131.66 | -263.32 | 15 | 1,974.89 | May 6, 2026: 2 @ 131.66 |
| June 28, 2026 | issue | SO-260628-459 | EAST | 6 | 131.66 | -789.96 | 17 | 2,238.21 | May 6, 2026: 6 @ 131.66 |
| June 26, 2026 | issue | SO-260626-732 | MAIN | 1 | 131.66 | -131.66 | 23 | 3,028.16 | May 6, 2026: 1 @ 131.66 |
| June 5, 2026 | issue | SO-260605-556 | EAST | 2 | 131.66 | -263.32 | 24 | 3,159.82 | May 6, 2026: 2 @ 131.66 |
| May 17, 2026 | issue | SO-260517-519 | MAIN | 1 | 131.66 | -131.66 | 26 | 3,423.14 | May 6, 2026: 1 @ 131.66 |
| May 16, 2026 | return | RMA | MAIN | 1 | 131.66 | 131.66 | 27 | 3,554.80 | |
| May 13, 2026 | issue | SO-260513-478 | MAIN | 1 | 131.66 | -131.66 | 26 | 3,423.14 | May 6, 2026: 1 @ 131.66 |
| May 11, 2026 | issue | SO-260511-454 | MAIN | 7 | 131.66 | -921.61 | 27 | 3,554.80 | May 6, 2026: 7 @ 131.66 |
| May 7, 2026 | issue | SO-260507-126 | MAIN | 3 | 132.93 | -398.79 | 34 | 4,476.41 | May 2, 2026: 1 @ 135.47; May 6, 2026: 2 @ 131.66 |
| May 6, 2026 | transfer | TRF | MAIN → EAST | 8 | warehouse transfer, no cost effect | ||||
| May 6, 2026 | receipt | PO-001468 | MAIN | 36 | 131.66 | 4,739.73 | 37 | 4,875.21 | |
| May 2, 2026 | return | RMA | MAIN | 1 | 135.47 | 135.47 | 1 | 135.47 | |
| May 2, 2026 | issue | SO-260502-937 | MAIN | 3 | 135.47 | -406.42 | 0 | 0.00 | Feb. 18, 2026: 3 @ 135.47 |
| April 30, 2026 | issue | SO-260430-687 | MAIN | 7 | 135.47 | -948.32 | 3 | 406.42 | Feb. 18, 2026: 7 @ 135.47 |
| April 26, 2026 | issue | SO-260426-983 | MAIN | 2 | 135.47 | -270.95 | 10 | 1,354.74 | Feb. 18, 2026: 2 @ 135.47 |
| April 20, 2026 | issue | SO-260420-698 | MAIN | 6 | 135.47 | -812.84 | 12 | 1,625.69 | Feb. 18, 2026: 6 @ 135.47 |
| April 20, 2026 | issue | SO-260420-698 | EAST | 1 | 135.47 | -135.47 | 18 | 2,438.53 | Feb. 18, 2026: 1 @ 135.47 |
| April 16, 2026 | issue | SO-260416-272 | EAST | 1 | 135.47 | -135.47 | 19 | 2,574.01 | Feb. 18, 2026: 1 @ 135.47 |
| April 14, 2026 | issue | SO-260414-696 | MAIN | 1 | 135.47 | -135.47 | 20 | 2,709.48 | Feb. 18, 2026: 1 @ 135.47 |
| April 13, 2026 | issue | SO-260413-323 | MAIN | 1 | 135.47 | -135.47 | 21 | 2,844.95 | Feb. 18, 2026: 1 @ 135.47 |
| April 5, 2026 | issue | SO-260405-663 | MAIN | 1 | 135.47 | -135.47 | 22 | 2,980.43 | Feb. 18, 2026: 1 @ 135.47 |
| March 30, 2026 | issue | SO-260330-118 | MAIN | 6 | 135.47 | -812.84 | 23 | 3,115.90 | Feb. 18, 2026: 6 @ 135.47 |
| March 20, 2026 | issue | SO-260320-671 | MAIN | 2 | 135.47 | -270.95 | 29 | 3,928.75 | Feb. 18, 2026: 2 @ 135.47 |
| March 6, 2026 | issue | SO-260306-708 | MAIN | 1 | 135.47 | -135.47 | 31 | 4,199.69 | Feb. 18, 2026: 1 @ 135.47 |
| March 4, 2026 | issue | SO-260304-952 | EAST | 2 | 135.47 | -270.95 | 32 | 4,335.17 | Feb. 18, 2026: 2 @ 135.47 |
| March 2, 2026 | issue | SO-260302-785 | EAST | 1 | 135.47 | -135.47 | 34 | 4,606.12 | Feb. 18, 2026: 1 @ 135.47 |
| Feb. 27, 2026 | issue | SO-260227-141 | MAIN | 6 | 134.47 | -806.80 | 35 | 4,741.59 | Jan. 12, 2026: 5 @ 134.27; Feb. 18, 2026: 1 @ 135.47 |
| Feb. 18, 2026 | receipt | PO-001237 | MAIN | 36 | 135.47 | 4,877.06 | 41 | 5,548.39 | |
| Feb. 14, 2026 | issue | SO-260214-212 | EAST | 1 | 134.27 | -134.27 | 5 | 671.33 | Jan. 12, 2026: 1 @ 134.27 |
| Feb. 13, 2026 | issue | SO-260213-195 | EAST | 2 | 134.27 | -268.53 | 6 | 805.59 | Jan. 12, 2026: 2 @ 134.27 |
| Feb. 12, 2026 | issue | SO-260212-769 | MAIN | 5 | 134.27 | -671.33 | 8 | 1,074.12 | Jan. 12, 2026: 5 @ 134.27 |
| Feb. 4, 2026 | issue | SO-260204-821 | MAIN | 1 | 134.27 | -134.27 | 13 | 1,745.45 | Jan. 12, 2026: 1 @ 134.27 |
| Jan. 17, 2026 | issue | SO-260117-340 | MAIN | 22 | 134.27 | -2,953.83 | 14 | 1,879.71 | Jan. 12, 2026: 22 @ 134.27 |
| Jan. 12, 2026 | transfer | TRF | MAIN → EAST | 8 | warehouse transfer, no cost effect | ||||
| Jan. 12, 2026 | receipt | PO-001140 | MAIN | 36 | 134.27 | 4,833.55 | 36 | 4,833.55 | |
| Jan. 1, 2026 | issue | SO-260101-408 | MAIN | 25 | 135.54 | -3,388.57 | 0 | 0.00 | Jan. 1, 2026: 25 @ 135.54 |
| Jan. 1, 2026 | issue | SO-260101-408 | EAST | 11 | 135.54 | -1,490.97 | 25 | 3,388.57 | Jan. 1, 2026: 11 @ 135.54 |
| Jan. 1, 2026 | transfer | TRF | MAIN → EAST | 11 | warehouse transfer, no cost effect | ||||
| Jan. 1, 2026 | receipt | PO-001111 | MAIN | 36 | 135.54 | 4,879.54 | 36 | 4,879.54 | |