Items / MCB-0030
Surge Protector Lite MCB-0030 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)20MAIN 20
Value (FIFO)461.60avg 23.08
ClassCX / FCV 0.35
Turnover10.1xlast issue 2 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 | 11.08 / 30.4375 | 0.364 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 3.90 / 5.517 | 0.708 |
| 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 * 0.708^2 + 0.364^2 * 1.5^2) | 2.5 |
| Reorder point | d * LT + safety stock | 0.364 * 7.0 + 2.5 | 5.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 5.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 133/yr, S = 45.00, h = 20%, price = 21.91 | 52.2 |
| Inventory position | on hand + on order | 20 + 0 | 20 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 23.82 | 50 | 3,405 | no |
| 24 | 22.87 | 51 | 3,273 | no |
| 48 | 21.91 | 52 | 3,142 | yes (chosen if cheapest) |
MOQ 12, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 11, 2026 | 20 / 21 | 23.08 | 461.60 |
Movement ledger 126 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-642 | MAIN | 2 | 23.51 | -47.01 | 20 | 461.60 | Sept. 1, 2026: 1 @ 23.93; Oct. 11, 2026: 1 @ 23.08 |
| Oct. 11, 2026 | receipt | PO-001870 | MAIN | 21 | 23.08 | 484.68 | 22 | 508.61 | |
| Oct. 9, 2026 | issue | SO-261009-230 | MAIN | 3 | 23.93 | -71.80 | 1 | 23.93 | Sept. 1, 2026: 3 @ 23.93 |
| Oct. 7, 2026 | issue | SO-261007-781 | MAIN | 1 | 23.93 | -23.93 | 4 | 95.74 | Sept. 1, 2026: 1 @ 23.93 |
| Oct. 2, 2026 | issue | SO-261002-338 | MAIN | 1 | 23.93 | -23.93 | 5 | 119.67 | Sept. 1, 2026: 1 @ 23.93 |
| Oct. 1, 2026 | issue | SO-261001-992 | MAIN | 8 | 23.93 | -191.48 | 6 | 143.61 | Sept. 1, 2026: 8 @ 23.93 |
| Sept. 25, 2026 | issue | SO-260925-881 | MAIN | 1 | 23.93 | -23.93 | 14 | 335.09 | Sept. 1, 2026: 1 @ 23.93 |
| Sept. 21, 2026 | issue | SO-260921-168 | MAIN | 1 | 23.93 | -23.93 | 15 | 359.02 | Sept. 1, 2026: 1 @ 23.93 |
| Sept. 11, 2026 | issue | SO-260911-103 | MAIN | 1 | 23.93 | -23.93 | 16 | 382.96 | Sept. 1, 2026: 1 @ 23.93 |
| Sept. 1, 2026 | issue | SO-260901-806 | MAIN | 7 | 23.56 | -164.89 | 17 | 406.89 | July 30, 2026: 3 @ 23.05; Sept. 1, 2026: 4 @ 23.93 |
| Sept. 1, 2026 | receipt | PO-001767 | MAIN | 21 | 23.93 | 502.63 | 24 | 571.78 | |
| Aug. 25, 2026 | issue | SO-260825-660 | MAIN | 3 | 23.05 | -69.15 | 3 | 69.15 | July 30, 2026: 3 @ 23.05 |
| Aug. 18, 2026 | issue | SO-260818-282 | MAIN | 4 | 23.05 | -92.20 | 6 | 138.29 | July 30, 2026: 4 @ 23.05 |
| Aug. 17, 2026 | issue | SO-260817-943 | MAIN | 4 | 23.05 | -92.20 | 10 | 230.49 | July 30, 2026: 4 @ 23.05 |
| Aug. 15, 2026 | issue | SO-260815-111 | EAST | 1 | 23.05 | -23.05 | 14 | 322.68 | July 30, 2026: 1 @ 23.05 |
| Aug. 10, 2026 | issue | SO-260810-896 | MAIN | 4 | 23.05 | -92.20 | 15 | 345.73 | July 30, 2026: 4 @ 23.05 |
| Aug. 8, 2026 | issue | SO-260808-523 | EAST | 1 | 23.05 | -23.05 | 19 | 437.93 | July 30, 2026: 1 @ 23.05 |
| July 30, 2026 | issue | SO-260730-268 | EAST | 4 | 23.52 | -94.10 | 20 | 460.98 | May 12, 2026: 1 @ 23.68; July 16, 2026: 2 @ 23.68; July 30, 2026: 1 @ 23.05 |
| July 30, 2026 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| July 30, 2026 | receipt | PO-001686 | MAIN | 21 | 23.05 | 484.02 | 24 | 555.08 | |
| July 26, 2026 | issue | SO-260726-372 | MAIN | 1 | 23.68 | -23.68 | 3 | 71.05 | May 12, 2026: 1 @ 23.68 |
| July 24, 2026 | issue | SO-260724-928 | MAIN | 3 | 23.68 | -71.05 | 4 | 94.73 | May 12, 2026: 3 @ 23.68 |
| July 22, 2026 | issue | SO-260722-941 | MAIN | 1 | 23.68 | -23.68 | 7 | 165.79 | May 12, 2026: 1 @ 23.68 |
| July 16, 2026 | return | RMA | MAIN | 2 | 23.68 | 47.37 | 8 | 189.47 | |
| July 6, 2026 | issue | SO-260706-226 | MAIN | 4 | 23.68 | -94.73 | 6 | 142.10 | May 12, 2026: 4 @ 23.68 |
| July 5, 2026 | issue | SO-260705-700 | MAIN | 2 | 23.68 | -47.37 | 10 | 236.84 | May 12, 2026: 2 @ 23.68 |
| June 29, 2026 | issue | SO-260629-496 | MAIN | 1 | 23.68 | -23.68 | 12 | 284.20 | May 12, 2026: 1 @ 23.68 |
| June 26, 2026 | issue | SO-260626-665 | MAIN | 2 | 23.68 | -47.37 | 13 | 307.89 | May 12, 2026: 2 @ 23.68 |
| June 17, 2026 | issue | SO-260617-340 | MAIN | 1 | 23.68 | -23.68 | 15 | 355.25 | May 12, 2026: 1 @ 23.68 |
| June 10, 2026 | issue | SO-260610-191 | MAIN | 3 | 23.68 | -71.05 | 16 | 378.94 | May 12, 2026: 3 @ 23.68 |
| June 4, 2026 | issue | SO-260604-807 | MAIN | 2 | 23.68 | -47.37 | 19 | 449.99 | May 12, 2026: 2 @ 23.68 |
| May 15, 2026 | issue | SO-260515-858 | EAST | 1 | 22.77 | -22.77 | 21 | 497.36 | March 25, 2026: 1 @ 22.77 |
| May 12, 2026 | receipt | PO-001487 | MAIN | 21 | 23.68 | 497.36 | 22 | 520.13 | |
| May 7, 2026 | issue | SO-260507-907 | EAST | 1 | 22.77 | -22.77 | 1 | 22.77 | March 25, 2026: 1 @ 22.77 |
| May 7, 2026 | issue | SO-260507-907 | MAIN | 2 | 22.77 | -45.55 | 2 | 45.55 | March 25, 2026: 2 @ 22.77 |
| May 5, 2026 | issue | SO-260505-495 | MAIN | 3 | 22.77 | -68.32 | 4 | 91.10 | March 25, 2026: 3 @ 22.77 |
| April 23, 2026 | issue | SO-260423-537 | MAIN | 4 | 22.77 | -91.10 | 7 | 159.42 | March 25, 2026: 4 @ 22.77 |
| April 14, 2026 | issue | SO-260414-729 | MAIN | 1 | 22.77 | -22.77 | 11 | 250.52 | March 25, 2026: 1 @ 22.77 |
| April 7, 2026 | issue | SO-260407-326 | EAST | 4 | 22.77 | -91.10 | 12 | 273.30 | March 25, 2026: 4 @ 22.77 |
| April 1, 2026 | issue | SO-260401-367 | MAIN | 6 | 22.92 | -137.51 | 16 | 364.40 | Jan. 21, 2026: 1 @ 23.64; March 25, 2026: 5 @ 22.77 |
| March 25, 2026 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| March 25, 2026 | receipt | PO-001355 | MAIN | 21 | 22.77 | 478.27 | 22 | 501.91 | |
| March 23, 2026 | issue | SO-260323-792 | MAIN | 3 | 23.64 | -70.92 | 1 | 23.64 | Jan. 15, 2026: 1 @ 23.64; Jan. 21, 2026: 2 @ 23.64 |
| March 16, 2026 | issue | SO-260316-668 | MAIN | 2 | 23.64 | -47.28 | 4 | 94.55 | Jan. 15, 2026: 2 @ 23.64 |
| March 15, 2026 | issue | SO-260315-574 | MAIN | 2 | 23.64 | -47.28 | 6 | 141.83 | Jan. 15, 2026: 2 @ 23.64 |
| Feb. 21, 2026 | issue | SO-260221-749 | MAIN | 2 | 23.64 | -47.28 | 8 | 189.11 | Jan. 15, 2026: 2 @ 23.64 |
| Feb. 17, 2026 | issue | SO-260217-587 | MAIN | 4 | 23.64 | -94.55 | 10 | 236.38 | Jan. 15, 2026: 4 @ 23.64 |
| Feb. 15, 2026 | issue | SO-260215-667 | MAIN | 1 | 23.64 | -23.64 | 14 | 330.94 | Jan. 15, 2026: 1 @ 23.64 |
| Feb. 13, 2026 | issue | SO-260213-174 | MAIN | 1 | 23.64 | -23.64 | 15 | 354.58 | Jan. 15, 2026: 1 @ 23.64 |
| Feb. 6, 2026 | issue | SO-260206-956 | MAIN | 1 | 23.64 | -23.64 | 16 | 378.21 | Jan. 15, 2026: 1 @ 23.64 |
| Jan. 21, 2026 | return | RMA | MAIN | 3 | 23.64 | 70.92 | 17 | 401.85 | |
| Jan. 17, 2026 | issue | SO-260117-281 | MAIN | 7 | 23.64 | -165.47 | 14 | 330.94 | Jan. 15, 2026: 7 @ 23.64 |
| Jan. 15, 2026 | receipt | PO-001146 | MAIN | 21 | 23.64 | 496.41 | 21 | 496.41 | |
| Jan. 8, 2026 | issue | SO-260108-829 | MAIN | 7 | 22.98 | -160.83 | 0 | 0.00 | Nov. 13, 2025: 7 @ 22.98 |
| Jan. 3, 2026 | issue | SO-260103-741 | MAIN | 6 | 22.98 | -137.86 | 7 | 160.83 | Nov. 13, 2025: 6 @ 22.98 |
| Dec. 30, 2025 | issue | SO-251230-663 | MAIN | 2 | 22.98 | -45.95 | 13 | 298.69 | Nov. 13, 2025: 2 @ 22.98 |
| Dec. 26, 2025 | issue | SO-251226-395 | MAIN | 1 | 22.98 | -22.98 | 15 | 344.64 | Nov. 13, 2025: 1 @ 22.98 |
| Dec. 14, 2025 | issue | SO-251214-236 | MAIN | 1 | 22.98 | -22.98 | 16 | 367.62 | Nov. 13, 2025: 1 @ 22.98 |
| Dec. 9, 2025 | issue | SO-251209-132 | MAIN | 2 | 22.98 | -45.95 | 17 | 390.60 | Nov. 13, 2025: 2 @ 22.98 |
| Dec. 6, 2025 | issue | SO-251206-917 | MAIN | 2 | 22.98 | -45.95 | 19 | 436.55 | Nov. 13, 2025: 2 @ 22.98 |