Items / MCB-0026
MCB 16A DP Pro MCB-0026 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)1EAST 1
Value (FIFO)18.85avg 18.85
ClassCX / FCV 0.30
Turnover13.8xlast issue 1 days ago
Days of cover1lead time 7d
Reorder suggested: 88 units (position at or below reorder point: order EOQ), stockout risk high.
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 | 26.42 / 30.4375 | 0.868 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 8.03 / 5.517 | 1.455 |
| 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 * 1.455^2 + 0.868^2 * 1.5^2) | 5.2 |
| Reorder point | d * LT + safety stock | 0.868 * 7.0 + 5.2 | 11.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 11.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 317/yr, S = 45.00, h = 20%, price = 18.51 | 87.8 |
| Inventory position | on hand + on order | 1 + 0 | 1 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 18.51 | 88 | 6,189 | yes (chosen if cheapest) |
MOQ 25, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 15, 2026 | 1 / 45 | 18.85 | 18.85 |
Movement ledger 146 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-852 | EAST | 11 | 18.85 | -207.31 | 1 | 18.85 | Aug. 15, 2026: 11 @ 18.85 |
| Oct. 14, 2026 | issue | SO-261014-230 | EAST | 3 | 18.85 | -56.54 | 12 | 226.15 | Aug. 15, 2026: 3 @ 18.85 |
| Oct. 4, 2026 | issue | SO-261004-715 | MAIN | 1 | 18.85 | -18.85 | 15 | 282.69 | Aug. 15, 2026: 1 @ 18.85 |
| Sept. 24, 2026 | issue | SO-260924-999 | MAIN | 13 | 18.85 | -245.00 | 16 | 301.54 | Aug. 15, 2026: 13 @ 18.85 |
| Sept. 12, 2026 | issue | SO-260912-885 | MAIN | 6 | 18.85 | -113.08 | 29 | 546.53 | Aug. 15, 2026: 6 @ 18.85 |
| Sept. 9, 2026 | issue | SO-260909-340 | MAIN | 8 | 18.85 | -150.77 | 35 | 659.61 | Aug. 15, 2026: 8 @ 18.85 |
| Aug. 23, 2026 | issue | SO-260823-745 | MAIN | 3 | 18.58 | -55.73 | 43 | 810.38 | July 6, 2026: 1 @ 18.04; Aug. 15, 2026: 2 @ 18.85 |
| Aug. 19, 2026 | issue | SO-260819-584 | MAIN | 4 | 18.04 | -72.16 | 46 | 866.11 | July 6, 2026: 4 @ 18.04 |
| Aug. 15, 2026 | transfer | TRF | MAIN → EAST | 15 | warehouse transfer, no cost effect | ||||
| Aug. 15, 2026 | receipt | PO-001722 | MAIN | 45 | 18.85 | 848.07 | 50 | 938.26 | |
| Aug. 12, 2026 | issue | SO-260812-296 | MAIN | 1 | 18.04 | -18.04 | 5 | 90.19 | July 6, 2026: 1 @ 18.04 |
| Aug. 8, 2026 | issue | SO-260808-191 | MAIN | 8 | 18.04 | -144.31 | 6 | 108.23 | July 6, 2026: 8 @ 18.04 |
| Aug. 5, 2026 | issue | SO-260805-918 | MAIN | 3 | 18.04 | -54.12 | 14 | 252.54 | July 6, 2026: 3 @ 18.04 |
| Aug. 2, 2026 | issue | SO-260802-713 | MAIN | 7 | 18.04 | -126.27 | 17 | 306.66 | July 6, 2026: 7 @ 18.04 |
| Aug. 1, 2026 | issue | SO-260801-371 | MAIN | 2 | 18.04 | -36.08 | 24 | 432.93 | July 6, 2026: 2 @ 18.04 |
| July 18, 2026 | issue | SO-260718-348 | MAIN | 1 | 18.04 | -18.04 | 26 | 469.01 | July 6, 2026: 1 @ 18.04 |
| July 17, 2026 | issue | SO-260717-653 | MAIN | 7 | 18.04 | -126.27 | 27 | 487.05 | July 6, 2026: 7 @ 18.04 |
| July 14, 2026 | issue | SO-260714-923 | MAIN | 4 | 18.04 | -72.16 | 34 | 613.32 | July 6, 2026: 4 @ 18.04 |
| July 14, 2026 | issue | SO-260714-923 | EAST | 2 | 18.04 | -36.08 | 38 | 685.48 | July 6, 2026: 2 @ 18.04 |
| July 12, 2026 | issue | SO-260712-594 | EAST | 12 | 18.42 | -221.04 | 40 | 721.56 | May 8, 2026: 3 @ 18.69; May 30, 2026: 3 @ 18.69; July 1, 2026: 1 @ 18.69; July 6, 2026: 5 @ 18.04 |
| July 10, 2026 | issue | SO-260710-910 | MAIN | 2 | 18.69 | -37.38 | 52 | 942.60 | May 8, 2026: 2 @ 18.69 |
| July 6, 2026 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| July 6, 2026 | receipt | PO-001628 | MAIN | 45 | 18.04 | 811.75 | 54 | 979.98 | |
| July 1, 2026 | return | RMA | MAIN | 1 | 18.69 | 18.69 | 9 | 168.23 | |
| June 30, 2026 | issue | SO-260630-221 | MAIN | 1 | 18.69 | -18.69 | 8 | 149.54 | May 8, 2026: 1 @ 18.69 |
| June 30, 2026 | issue | SO-260630-221 | EAST | 7 | 18.69 | -130.84 | 9 | 168.23 | May 3, 2026: 7 @ 18.69 |
| June 25, 2026 | issue | SO-260625-839 | MAIN | 6 | 18.69 | -112.15 | 16 | 299.07 | May 3, 2026: 6 @ 18.69 |
| June 22, 2026 | issue | SO-260622-772 | MAIN | 1 | 18.69 | -18.69 | 22 | 411.23 | May 3, 2026: 1 @ 18.69 |
| June 14, 2026 | issue | SO-260614-966 | MAIN | 1 | 18.69 | -18.69 | 23 | 429.92 | May 3, 2026: 1 @ 18.69 |
| June 11, 2026 | adjustment | Cycle count | MAIN | -1 | 18.69 | -18.69 | 24 | 448.61 | May 3, 2026: 1 @ 18.69 |
| June 5, 2026 | issue | SO-260605-573 | MAIN | 2 | 18.69 | -37.38 | 25 | 467.30 | May 3, 2026: 2 @ 18.69 |
| June 2, 2026 | issue | SO-260602-810 | MAIN | 5 | 18.69 | -93.46 | 27 | 504.69 | May 3, 2026: 5 @ 18.69 |
| May 30, 2026 | return | RMA | MAIN | 3 | 18.69 | 56.08 | 32 | 598.15 | |
| May 26, 2026 | issue | SO-260526-111 | EAST | 1 | 18.69 | -18.69 | 29 | 542.07 | May 3, 2026: 1 @ 18.69 |
| May 19, 2026 | issue | SO-260519-677 | EAST | 4 | 18.69 | -74.77 | 30 | 560.76 | May 3, 2026: 4 @ 18.69 |
| May 16, 2026 | issue | SO-260516-916 | MAIN | 6 | 18.69 | -112.15 | 34 | 635.53 | May 3, 2026: 6 @ 18.69 |
| May 13, 2026 | issue | SO-260513-499 | MAIN | 4 | 18.69 | -74.77 | 40 | 747.68 | May 3, 2026: 4 @ 18.69 |
| May 8, 2026 | return | RMA | MAIN | 6 | 18.69 | 112.15 | 44 | 822.45 | |
| May 8, 2026 | issue | SO-260508-382 | MAIN | 7 | 18.69 | -130.84 | 38 | 710.30 | May 3, 2026: 7 @ 18.69 |
| May 3, 2026 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||
| May 3, 2026 | receipt | PO-001461 | MAIN | 45 | 18.69 | 841.14 | 45 | 841.14 | |
| April 27, 2026 | issue | SO-260427-816 | MAIN | 12 | 17.54 | -210.43 | 0 | 0.00 | March 1, 2026: 12 @ 17.54 |
| April 21, 2026 | issue | SO-260421-413 | MAIN | 3 | 17.54 | -52.61 | 12 | 210.43 | March 1, 2026: 3 @ 17.54 |
| April 11, 2026 | issue | SO-260411-290 | MAIN | 25 | 17.54 | -438.40 | 15 | 263.04 | March 1, 2026: 25 @ 17.54 |
| March 29, 2026 | issue | SO-260329-638 | MAIN | 4 | 17.54 | -70.14 | 40 | 701.43 | March 1, 2026: 4 @ 17.54 |
| March 26, 2026 | issue | SO-260326-363 | MAIN | 1 | 17.54 | -17.54 | 44 | 771.58 | March 1, 2026: 1 @ 17.54 |
| March 21, 2026 | issue | SO-260321-608 | MAIN | 3 | 17.74 | -53.21 | 45 | 789.11 | Jan. 11, 2026: 3 @ 17.74 |
| March 9, 2026 | issue | SO-260309-168 | MAIN | 5 | 17.74 | -88.68 | 48 | 842.32 | Jan. 11, 2026: 5 @ 17.74 |
| March 1, 2026 | receipt | PO-001272 | MAIN | 45 | 17.54 | 789.11 | 53 | 930.99 | |
| Feb. 26, 2026 | issue | SO-260226-362 | MAIN | 2 | 17.74 | -35.47 | 8 | 141.88 | Jan. 11, 2026: 2 @ 17.74 |
| Feb. 24, 2026 | issue | SO-260224-650 | MAIN | 5 | 17.74 | -88.68 | 10 | 177.35 | Jan. 11, 2026: 5 @ 17.74 |
| Feb. 13, 2026 | issue | SO-260213-698 | MAIN | 2 | 17.74 | -35.47 | 15 | 266.03 | Jan. 11, 2026: 2 @ 17.74 |
| Feb. 11, 2026 | issue | SO-260211-562 | MAIN | 16 | 17.74 | -283.77 | 17 | 301.50 | Jan. 11, 2026: 16 @ 17.74 |
| Feb. 10, 2026 | issue | SO-260210-744 | MAIN | 3 | 17.74 | -53.21 | 33 | 585.27 | Jan. 11, 2026: 3 @ 17.74 |
| Feb. 9, 2026 | issue | SO-260209-217 | MAIN | 3 | 17.74 | -53.21 | 36 | 638.48 | Jan. 11, 2026: 3 @ 17.74 |
| Jan. 25, 2026 | issue | SO-260125-666 | MAIN | 8 | 17.84 | -142.70 | 39 | 691.68 | Nov. 19, 2025: 2 @ 18.14; Jan. 11, 2026: 6 @ 17.74 |
| Jan. 15, 2026 | issue | SO-260115-293 | MAIN | 2 | 18.14 | -36.29 | 47 | 834.38 | Nov. 19, 2025: 2 @ 18.14 |
| Jan. 14, 2026 | issue | SO-260114-227 | MAIN | 5 | 17.97 | -89.85 | 49 | 870.67 | Nov. 9, 2025: 3 @ 17.86; Nov. 19, 2025: 2 @ 18.14 |
| Jan. 11, 2026 | receipt | PO-001136 | MAIN | 45 | 17.74 | 798.10 | 54 | 960.52 | |
| Jan. 4, 2026 | issue | SO-260104-542 | MAIN | 7 | 17.86 | -124.99 | 9 | 162.42 | Nov. 9, 2025: 7 @ 17.86 |