Items / MCB-0001
Surge Protector Flex MCB-0001 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)52MAIN 52
Value (FIFO)4,531.91avg 87.15
ClassAX / FCV 0.39
Turnover11.4xlast issue 5 days ago
Days of cover35lead 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 | 44.92 / 30.4375 | 1.476 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 17.58 / 5.517 | 3.187 |
| 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 * 3.187^2 + 1.476^2 * 1.5^2) | 17.9 |
| Reorder point | d * LT + safety stock | 1.476 * 7.0 + 17.9 | 28.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 28.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 539/yr, S = 45.00, h = 20%, price = 79.44 | 152.0 |
| Inventory position | on hand + on order | 52 + 0 | 52 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 86.35 | 53 | 47,426 | yes |
| 76 | 82.90 | 76 | 45,599 | yes |
| 152 | 79.44 | 152 | 44,157 | yes (chosen if cheapest) |
MOQ 38, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 20, 2026 | 52 / 69 | 87.15 | 4,531.91 |
Movement ledger 143 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 | issue | SO-261011-869 | MAIN | 3 | 87.15 | -261.46 | 52 | 4,531.91 | Sept. 20, 2026: 3 @ 87.15 |
| Oct. 9, 2026 | issue | SO-261009-934 | MAIN | 8 | 87.15 | -697.22 | 55 | 4,793.37 | Sept. 20, 2026: 8 @ 87.15 |
| Oct. 3, 2026 | issue | SO-261003-444 | MAIN | 19 | 87.40 | -1,660.68 | 63 | 5,490.59 | Aug. 21, 2026: 13 @ 87.52; Sept. 20, 2026: 6 @ 87.15 |
| Sept. 20, 2026 | receipt | PO-001815 | MAIN | 69 | 87.15 | 6,013.50 | 82 | 7,151.27 | |
| Sept. 14, 2026 | issue | SO-260914-844 | MAIN | 27 | 87.52 | -2,363.05 | 13 | 1,137.77 | Aug. 21, 2026: 27 @ 87.52 |
| Sept. 7, 2026 | issue | SO-260907-239 | MAIN | 28 | 87.52 | -2,450.57 | 40 | 3,500.82 | Aug. 21, 2026: 28 @ 87.52 |
| Aug. 21, 2026 | issue | SO-260821-705 | MAIN | 1 | 87.52 | -87.52 | 68 | 5,951.39 | Aug. 21, 2026: 1 @ 87.52 |
| Aug. 21, 2026 | receipt | PO-001732 | MAIN | 69 | 87.52 | 6,038.91 | 69 | 6,038.91 | |
| Aug. 19, 2026 | issue | SO-260819-944 | MAIN | 11 | 83.46 | -918.04 | 0 | 0.00 | June 24, 2026: 10 @ 83.46; July 2, 2026: 1 @ 83.46 |
| Aug. 17, 2026 | issue | SO-260817-463 | MAIN | 10 | 83.46 | -834.58 | 11 | 918.04 | June 24, 2026: 10 @ 83.46 |
| Aug. 16, 2026 | issue | SO-260816-733 | MAIN | 3 | 83.46 | -250.37 | 21 | 1,752.61 | June 24, 2026: 3 @ 83.46 |
| Aug. 9, 2026 | issue | SO-260809-369 | MAIN | 2 | 83.46 | -166.92 | 24 | 2,002.99 | June 24, 2026: 2 @ 83.46 |
| Aug. 6, 2026 | issue | SO-260806-384 | MAIN | 9 | 83.46 | -751.12 | 26 | 2,169.90 | June 24, 2026: 9 @ 83.46 |
| July 31, 2026 | issue | SO-260731-842 | MAIN | 4 | 83.46 | -333.83 | 35 | 2,921.02 | June 24, 2026: 4 @ 83.46 |
| July 29, 2026 | issue | SO-260729-601 | MAIN | 10 | 83.46 | -834.58 | 39 | 3,254.85 | June 24, 2026: 10 @ 83.46 |
| July 23, 2026 | issue | SO-260723-743 | MAIN | 10 | 83.46 | -834.58 | 49 | 4,089.43 | June 24, 2026: 10 @ 83.46 |
| July 4, 2026 | issue | SO-260704-174 | MAIN | 7 | 83.46 | -584.20 | 59 | 4,924.01 | June 24, 2026: 7 @ 83.46 |
| July 2, 2026 | return | RMA | MAIN | 1 | 83.46 | 83.46 | 66 | 5,508.21 | |
| July 2, 2026 | issue | SO-260702-487 | MAIN | 3 | 83.46 | -250.37 | 65 | 5,424.76 | June 24, 2026: 3 @ 83.46 |
| June 26, 2026 | issue | SO-260626-593 | MAIN | 1 | 83.46 | -83.46 | 68 | 5,675.13 | June 24, 2026: 1 @ 83.46 |
| June 24, 2026 | receipt | PO-001601 | MAIN | 69 | 83.46 | 5,758.59 | 69 | 5,758.59 | |
| June 19, 2026 | issue | SO-260619-691 | MAIN | 27 | 85.46 | -2,307.54 | 0 | 0.00 | May 18, 2026: 27 @ 85.46 |
| June 16, 2026 | issue | SO-260616-570 | MAIN | 5 | 85.46 | -427.32 | 27 | 2,307.54 | May 18, 2026: 5 @ 85.46 |
| June 16, 2026 | issue | SO-260616-570 | EAST | 14 | 85.46 | -1,196.50 | 32 | 2,734.86 | May 18, 2026: 14 @ 85.46 |
| June 12, 2026 | issue | SO-260612-503 | MAIN | 19 | 85.46 | -1,623.83 | 46 | 3,931.37 | May 18, 2026: 19 @ 85.46 |
| May 25, 2026 | issue | SO-260525-453 | MAIN | 4 | 85.46 | -341.86 | 65 | 5,555.19 | May 18, 2026: 4 @ 85.46 |
| May 18, 2026 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| May 18, 2026 | receipt | PO-001505 | MAIN | 69 | 85.46 | 5,897.05 | 69 | 5,897.05 | |
| May 11, 2026 | issue | SO-260511-315 | EAST | 18 | 82.23 | -1,480.16 | 0 | 0.00 | April 16, 2026: 18 @ 82.23 |
| May 11, 2026 | issue | SO-260511-315 | MAIN | 7 | 82.23 | -575.62 | 18 | 1,480.16 | April 16, 2026: 7 @ 82.23 |
| May 9, 2026 | issue | SO-260509-244 | MAIN | 23 | 82.23 | -1,891.31 | 25 | 2,055.77 | April 16, 2026: 23 @ 82.23 |
| May 3, 2026 | issue | SO-260503-434 | MAIN | 20 | 82.23 | -1,644.62 | 48 | 3,947.08 | April 16, 2026: 20 @ 82.23 |
| April 27, 2026 | issue | SO-260427-144 | MAIN | 9 | 83.29 | -749.62 | 68 | 5,591.70 | Feb. 13, 2026: 7 @ 83.42; March 9, 2026: 1 @ 83.42; April 16, 2026: 1 @ 82.23 |
| April 25, 2026 | issue | SO-260425-752 | MAIN | 3 | 83.42 | -250.27 | 77 | 6,341.32 | Feb. 13, 2026: 3 @ 83.42 |
| April 20, 2026 | issue | SO-260420-995 | EAST | 3 | 83.42 | -250.27 | 80 | 6,591.60 | Feb. 13, 2026: 3 @ 83.42 |
| April 19, 2026 | issue | SO-260419-156 | MAIN | 3 | 83.42 | -250.27 | 83 | 6,841.87 | Feb. 13, 2026: 3 @ 83.42 |
| April 16, 2026 | transfer | TRF | MAIN → EAST | 21 | warehouse transfer, no cost effect | ||||
| April 16, 2026 | receipt | PO-001414 | MAIN | 69 | 82.23 | 5,673.93 | 86 | 7,092.14 | |
| April 5, 2026 | issue | SO-260405-226 | MAIN | 3 | 83.42 | -250.27 | 17 | 1,418.21 | Feb. 13, 2026: 3 @ 83.42 |
| March 29, 2026 | issue | SO-260329-382 | MAIN | 6 | 83.42 | -500.54 | 20 | 1,668.48 | Feb. 13, 2026: 6 @ 83.42 |
| March 22, 2026 | issue | SO-260322-698 | MAIN | 10 | 83.42 | -834.24 | 26 | 2,169.02 | Feb. 13, 2026: 10 @ 83.42 |
| March 20, 2026 | issue | SO-260320-190 | MAIN | 13 | 83.42 | -1,084.51 | 36 | 3,003.26 | Feb. 13, 2026: 13 @ 83.42 |
| March 17, 2026 | issue | SO-260317-838 | MAIN | 3 | 83.42 | -250.27 | 49 | 4,087.77 | Feb. 13, 2026: 3 @ 83.42 |
| March 15, 2026 | issue | SO-260315-418 | MAIN | 3 | 83.42 | -250.27 | 52 | 4,338.04 | Feb. 13, 2026: 3 @ 83.42 |
| March 9, 2026 | return | RMA | MAIN | 1 | 83.42 | 83.42 | 55 | 4,588.31 | |
| March 5, 2026 | issue | SO-260305-431 | MAIN | 1 | 83.42 | -83.42 | 54 | 4,504.89 | Feb. 13, 2026: 1 @ 83.42 |
| Feb. 24, 2026 | issue | SO-260224-430 | MAIN | 15 | 83.46 | -1,251.93 | 55 | 4,588.31 | Dec. 28, 2025: 1 @ 83.99; Feb. 13, 2026: 14 @ 83.42 |
| Feb. 21, 2026 | issue | SO-260221-561 | MAIN | 3 | 83.99 | -251.98 | 70 | 5,840.24 | Dec. 28, 2025: 3 @ 83.99 |
| Feb. 17, 2026 | issue | SO-260217-983 | MAIN | 7 | 83.99 | -587.96 | 73 | 6,092.23 | Dec. 28, 2025: 7 @ 83.99 |
| Feb. 17, 2026 | issue | SO-260217-983 | EAST | 3 | 83.99 | -251.98 | 80 | 6,680.19 | Dec. 28, 2025: 3 @ 83.99 |
| Feb. 13, 2026 | receipt | PO-001227 | MAIN | 69 | 83.42 | 5,756.25 | 83 | 6,932.17 | |
| Feb. 9, 2026 | issue | SO-260209-585 | EAST | 10 | 83.99 | -839.94 | 14 | 1,175.92 | Dec. 28, 2025: 10 @ 83.99 |
| Feb. 7, 2026 | issue | SO-260207-938 | MAIN | 10 | 83.99 | -839.94 | 24 | 2,015.86 | Dec. 28, 2025: 10 @ 83.99 |
| Feb. 2, 2026 | issue | SO-260202-737 | MAIN | 1 | 83.99 | -83.99 | 34 | 2,855.81 | Dec. 28, 2025: 1 @ 83.99 |
| Jan. 24, 2026 | issue | SO-260124-264 | EAST | 1 | 83.99 | -83.99 | 35 | 2,939.80 | Dec. 28, 2025: 1 @ 83.99 |
| Jan. 9, 2026 | issue | SO-260109-495 | MAIN | 32 | 83.99 | -2,687.82 | 36 | 3,023.79 | Dec. 28, 2025: 32 @ 83.99 |
| Jan. 8, 2026 | issue | SO-260108-437 | EAST | 1 | 83.99 | -83.99 | 68 | 5,711.61 | Dec. 28, 2025: 1 @ 83.99 |
| Jan. 2, 2026 | issue | SO-260102-191 | EAST | 1 | 82.03 | -82.03 | 69 | 5,795.61 | Nov. 30, 2025: 1 @ 82.03 |
| Dec. 29, 2025 | issue | SO-251229-438 | MAIN | 11 | 82.03 | -902.31 | 70 | 5,877.64 | Nov. 30, 2025: 11 @ 82.03 |
| Dec. 28, 2025 | transfer | TRF | MAIN → EAST | 16 | warehouse transfer, no cost effect | ||||