Items / MCB-0023
Surge Protector Eco MCB-0023 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)72MAIN 72
Value (FIFO)6,232.42avg 86.56
ClassAX / FCV 0.39
Turnover7.7xlast issue 5 days ago
Days of cover55lead 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 | 40.00 / 30.4375 | 1.314 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 15.69 / 5.517 | 2.844 |
| 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.844^2 + 1.314^2 * 1.5^2) | 16.0 |
| Reorder point | d * LT + safety stock | 1.314 * 7.0 + 16.0 | 25.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 25.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 480/yr, S = 45.00, h = 20%, price = 78.15 | 160.0 |
| Inventory position | on hand + on order | 72 + 0 | 72 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 84.95 | 50 | 41,605 | yes |
| 80 | 81.55 | 80 | 40,040 | yes |
| 160 | 78.15 | 160 | 38,874 | yes (chosen if cheapest) |
MOQ 40, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 13, 2026 | 72 / 72 | 86.56 | 6,232.42 |
Movement ledger 133 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 13, 2026 | receipt | PO-001878 | MAIN | 72 | 86.56 | 6,232.42 | 72 | 6,232.42 | |
| Oct. 11, 2026 | issue | SO-261011-807 | MAIN | 14 | 83.90 | -1,174.55 | 0 | 0.00 | July 29, 2026: 14 @ 83.90 |
| Oct. 5, 2026 | issue | SO-261005-671 | MAIN | 8 | 83.90 | -671.17 | 14 | 1,174.55 | July 29, 2026: 8 @ 83.90 |
| Oct. 2, 2026 | issue | SO-261002-604 | MAIN | 2 | 83.90 | -167.79 | 22 | 1,845.72 | July 29, 2026: 2 @ 83.90 |
| Sept. 27, 2026 | issue | SO-260927-567 | MAIN | 4 | 83.90 | -335.59 | 24 | 2,013.51 | July 29, 2026: 4 @ 83.90 |
| Sept. 17, 2026 | issue | SO-260917-156 | MAIN | 4 | 83.90 | -335.59 | 28 | 2,349.10 | July 29, 2026: 4 @ 83.90 |
| Sept. 13, 2026 | issue | SO-260913-897 | MAIN | 8 | 83.90 | -671.17 | 32 | 2,684.68 | July 29, 2026: 8 @ 83.90 |
| Sept. 6, 2026 | issue | SO-260906-491 | MAIN | 7 | 83.90 | -587.27 | 40 | 3,355.85 | July 29, 2026: 7 @ 83.90 |
| Sept. 3, 2026 | issue | SO-260903-808 | MAIN | 1 | 83.90 | -83.90 | 47 | 3,943.13 | July 29, 2026: 1 @ 83.90 |
| Sept. 1, 2026 | issue | SO-260901-484 | MAIN | 1 | 83.90 | -83.90 | 48 | 4,027.02 | July 29, 2026: 1 @ 83.90 |
| Aug. 27, 2026 | issue | SO-260827-642 | MAIN | 3 | 83.90 | -251.69 | 49 | 4,110.92 | July 29, 2026: 3 @ 83.90 |
| Aug. 16, 2026 | issue | SO-260816-155 | MAIN | 6 | 83.90 | -503.38 | 52 | 4,362.61 | July 29, 2026: 6 @ 83.90 |
| Aug. 13, 2026 | issue | SO-260813-572 | MAIN | 1 | 83.90 | -83.90 | 58 | 4,865.99 | July 29, 2026: 1 @ 83.90 |
| Aug. 11, 2026 | issue | SO-260811-928 | MAIN | 7 | 83.90 | -587.27 | 59 | 4,949.88 | July 29, 2026: 7 @ 83.90 |
| Aug. 8, 2026 | issue | SO-260808-657 | MAIN | 5 | 83.90 | -419.48 | 66 | 5,537.16 | July 29, 2026: 5 @ 83.90 |
| Aug. 7, 2026 | issue | SO-260807-724 | MAIN | 1 | 83.90 | -83.90 | 71 | 5,956.64 | July 29, 2026: 1 @ 83.90 |
| July 29, 2026 | receipt | PO-001685 | MAIN | 72 | 83.90 | 6,040.53 | 72 | 6,040.53 | |
| July 24, 2026 | issue | SO-260724-306 | EAST | 8 | 83.88 | -671.01 | 0 | 0.00 | May 14, 2026: 8 @ 83.88 |
| July 22, 2026 | issue | SO-260722-883 | EAST | 3 | 83.88 | -251.63 | 8 | 671.01 | May 14, 2026: 3 @ 83.88 |
| July 21, 2026 | issue | SO-260721-277 | EAST | 2 | 83.88 | -167.75 | 11 | 922.64 | May 14, 2026: 2 @ 83.88 |
| July 21, 2026 | issue | SO-260721-277 | MAIN | 7 | 83.88 | -587.14 | 13 | 1,090.39 | May 14, 2026: 7 @ 83.88 |
| July 15, 2026 | issue | SO-260715-107 | EAST | 6 | 83.88 | -503.26 | 20 | 1,677.53 | May 14, 2026: 6 @ 83.88 |
| June 16, 2026 | issue | SO-260616-972 | MAIN | 17 | 83.88 | -1,425.90 | 26 | 2,180.79 | May 14, 2026: 17 @ 83.88 |
| June 15, 2026 | issue | SO-260615-126 | MAIN | 7 | 83.88 | -587.14 | 43 | 3,606.69 | May 14, 2026: 7 @ 83.88 |
| June 14, 2026 | issue | SO-260614-504 | MAIN | 11 | 83.88 | -922.64 | 50 | 4,193.82 | May 14, 2026: 11 @ 83.88 |
| June 10, 2026 | issue | SO-260610-517 | MAIN | 14 | 84.06 | -1,176.86 | 61 | 5,116.47 | April 21, 2026: 3 @ 84.74; May 14, 2026: 11 @ 83.88 |
| June 4, 2026 | issue | SO-260604-485 | EAST | 5 | 84.74 | -423.70 | 75 | 6,293.33 | April 21, 2026: 5 @ 84.74 |
| May 23, 2026 | issue | SO-260523-390 | MAIN | 8 | 84.74 | -677.93 | 80 | 6,717.04 | April 21, 2026: 8 @ 84.74 |
| May 14, 2026 | transfer | TRF | MAIN → EAST | 24 | warehouse transfer, no cost effect | ||||
| May 14, 2026 | receipt | PO-001493 | MAIN | 72 | 83.88 | 6,039.11 | 88 | 7,394.96 | |
| May 6, 2026 | issue | SO-260506-907 | MAIN | 47 | 84.74 | -3,982.83 | 16 | 1,355.86 | April 21, 2026: 47 @ 84.74 |
| April 29, 2026 | issue | SO-260429-281 | MAIN | 9 | 84.74 | -762.67 | 63 | 5,338.68 | April 21, 2026: 9 @ 84.74 |
| April 22, 2026 | issue | SO-260422-613 | EAST | 8 | 82.30 | -658.44 | 72 | 6,101.35 | Feb. 1, 2026: 4 @ 82.30; Feb. 27, 2026: 4 @ 82.30 |
| April 21, 2026 | receipt | PO-001427 | MAIN | 72 | 84.74 | 6,101.35 | 80 | 6,759.79 | |
| April 16, 2026 | issue | SO-260416-199 | EAST | 14 | 82.30 | -1,152.27 | 8 | 658.44 | Feb. 1, 2026: 14 @ 82.30 |
| April 16, 2026 | issue | SO-260416-199 | MAIN | 3 | 82.30 | -246.91 | 22 | 1,810.71 | Feb. 1, 2026: 3 @ 82.30 |
| April 13, 2026 | issue | SO-260413-252 | MAIN | 2 | 82.30 | -164.61 | 25 | 2,057.62 | Feb. 1, 2026: 2 @ 82.30 |
| March 16, 2026 | issue | SO-260316-310 | MAIN | 11 | 82.30 | -905.35 | 27 | 2,222.23 | Feb. 1, 2026: 11 @ 82.30 |
| March 13, 2026 | issue | SO-260313-953 | MAIN | 21 | 82.30 | -1,728.40 | 38 | 3,127.59 | Feb. 1, 2026: 21 @ 82.30 |
| Feb. 27, 2026 | return | RMA | MAIN | 4 | 82.30 | 329.22 | 59 | 4,855.99 | |
| Feb. 21, 2026 | issue | SO-260221-119 | MAIN | 3 | 82.30 | -246.91 | 55 | 4,526.77 | Feb. 1, 2026: 3 @ 82.30 |
| Feb. 12, 2026 | issue | SO-260212-266 | MAIN | 9 | 82.30 | -740.74 | 58 | 4,773.68 | Feb. 1, 2026: 9 @ 82.30 |
| Feb. 7, 2026 | issue | SO-260207-512 | MAIN | 20 | 80.41 | -1,608.14 | 67 | 5,514.43 | Dec. 15, 2025: 15 @ 79.77; Feb. 1, 2026: 5 @ 82.30 |
| Feb. 1, 2026 | transfer | TRF | MAIN → EAST | 22 | warehouse transfer, no cost effect | ||||
| Feb. 1, 2026 | receipt | PO-001192 | MAIN | 72 | 82.30 | 5,925.95 | 87 | 7,122.57 | |
| Jan. 25, 2026 | issue | SO-260125-632 | MAIN | 12 | 79.77 | -957.29 | 15 | 1,196.61 | Dec. 15, 2025: 12 @ 79.77 |
| Jan. 23, 2026 | issue | SO-260123-569 | MAIN | 2 | 79.77 | -159.55 | 27 | 2,153.91 | Dec. 15, 2025: 2 @ 79.77 |
| Jan. 20, 2026 | issue | SO-260120-263 | MAIN | 8 | 79.77 | -638.19 | 29 | 2,313.45 | Dec. 15, 2025: 8 @ 79.77 |
| Jan. 17, 2026 | issue | SO-260117-855 | MAIN | 8 | 79.77 | -638.19 | 37 | 2,951.65 | Dec. 15, 2025: 8 @ 79.77 |
| Jan. 10, 2026 | issue | SO-260110-452 | MAIN | 1 | 79.77 | -79.77 | 45 | 3,589.84 | Dec. 15, 2025: 1 @ 79.77 |
| Jan. 4, 2026 | issue | SO-260104-900 | MAIN | 26 | 79.77 | -2,074.13 | 46 | 3,669.62 | Dec. 15, 2025: 26 @ 79.77 |
| Dec. 15, 2025 | receipt | PO-001055 | MAIN | 72 | 79.77 | 5,743.75 | 72 | 5,743.75 | |
| Dec. 7, 2025 | issue | SO-251207-165 | MAIN | 75 | 81.18 | -6,088.28 | 0 | 0.00 | Oct. 1, 2025: 3 @ 82.76; Nov. 29, 2025: 72 @ 81.11 |
| Nov. 29, 2025 | receipt | PO-001025 | MAIN | 72 | 81.11 | 5,839.99 | 75 | 6,088.28 | |
| Nov. 23, 2025 | issue | SO-251123-188 | MAIN | 36 | 82.76 | -2,979.44 | 3 | 248.29 | Oct. 1, 2025: 36 @ 82.76 |
| Nov. 23, 2025 | issue | SO-251123-188 | EAST | 1 | 82.76 | -82.76 | 39 | 3,227.73 | Oct. 1, 2025: 1 @ 82.76 |
| Nov. 22, 2025 | issue | SO-251122-150 | EAST | 1 | 82.76 | -82.76 | 40 | 3,310.49 | Oct. 1, 2025: 1 @ 82.76 |
| Oct. 26, 2025 | issue | SO-251026-142 | EAST | 9 | 82.76 | -744.86 | 41 | 3,393.25 | Oct. 1, 2025: 9 @ 82.76 |
| Oct. 7, 2025 | issue | SO-251007-130 | EAST | 11 | 82.76 | -910.39 | 50 | 4,138.12 | Oct. 1, 2025: 11 @ 82.76 |
| Oct. 6, 2025 | issue | SO-251006-820 | MAIN | 11 | 82.76 | -910.39 | 61 | 5,048.50 | Oct. 1, 2025: 11 @ 82.76 |