Items / MCB-0025
MCB 16A DP Plus MCB-0025 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)32MAIN 32
Value (FIFO)4,120.78avg 128.77
ClassAX / FCV 0.41
Turnover14.2xlast issue 4 days ago
Days of cover29lead 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 | 33.75 / 30.4375 | 1.109 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 13.93 / 5.517 | 2.525 |
| 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.525^2 + 1.109^2 * 1.5^2) | 14.1 |
| Reorder point | d * LT + safety stock | 1.109 * 7.0 + 14.1 | 21.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 21.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 405/yr, S = 45.00, h = 20%, price = 121.90 | 156.0 |
| Inventory position | on hand + on order | 32 + 0 | 32 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 132.50 | 37 | 54,608 | yes |
| 78 | 127.20 | 78 | 52,706 | yes |
| 156 | 121.90 | 156 | 51,354 | yes (chosen if cheapest) |
MOQ 39, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 4, 2026 | 32 / 69 | 128.77 | 4,120.78 |
Movement ledger 132 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-166 | MAIN | 3 | 128.77 | -386.32 | 32 | 4,120.78 | Oct. 4, 2026: 3 @ 128.77 |
| Oct. 11, 2026 | issue | SO-261011-740 | MAIN | 19 | 128.77 | -2,446.72 | 35 | 4,507.11 | Oct. 4, 2026: 19 @ 128.77 |
| Oct. 4, 2026 | issue | SO-261004-394 | MAIN | 15 | 128.77 | -1,931.62 | 54 | 6,953.82 | Oct. 4, 2026: 15 @ 128.77 |
| Oct. 4, 2026 | receipt | PO-001850 | MAIN | 69 | 128.77 | 8,885.44 | 69 | 8,885.44 | |
| Sept. 28, 2026 | issue | SO-260928-181 | MAIN | 19 | 133.31 | -2,532.94 | 0 | 0.00 | June 22, 2026: 19 @ 133.31 |
| Sept. 8, 2026 | issue | SO-260908-431 | MAIN | 5 | 133.31 | -666.56 | 19 | 2,532.94 | June 22, 2026: 5 @ 133.31 |
| Aug. 22, 2026 | issue | SO-260822-142 | MAIN | 10 | 133.31 | -1,333.12 | 24 | 3,199.50 | June 22, 2026: 10 @ 133.31 |
| Aug. 6, 2026 | issue | SO-260806-185 | MAIN | 15 | 133.31 | -1,999.69 | 34 | 4,532.62 | June 22, 2026: 15 @ 133.31 |
| July 25, 2026 | issue | SO-260725-199 | MAIN | 2 | 133.31 | -266.62 | 49 | 6,532.31 | June 22, 2026: 2 @ 133.31 |
| July 24, 2026 | issue | SO-260724-249 | MAIN | 14 | 133.31 | -1,866.37 | 51 | 6,798.93 | June 22, 2026: 14 @ 133.31 |
| July 20, 2026 | issue | SO-260720-716 | MAIN | 3 | 133.31 | -399.94 | 65 | 8,665.31 | June 22, 2026: 3 @ 133.31 |
| July 8, 2026 | issue | SO-260708-240 | MAIN | 3 | 131.01 | -393.03 | 68 | 9,065.24 | April 8, 2026: 1 @ 129.86; May 14, 2026: 1 @ 129.86; June 22, 2026: 1 @ 133.31 |
| June 30, 2026 | issue | SO-260630-128 | MAIN | 3 | 129.86 | -389.57 | 71 | 9,458.27 | April 8, 2026: 3 @ 129.86 |
| June 28, 2026 | issue | SO-260628-159 | MAIN | 8 | 129.86 | -1,038.85 | 74 | 9,847.84 | April 8, 2026: 8 @ 129.86 |
| June 22, 2026 | adjustment | Cycle count | MAIN | -2 | 129.86 | -259.71 | 82 | 10,886.69 | April 8, 2026: 2 @ 129.86 |
| June 22, 2026 | receipt | PO-001595 | MAIN | 69 | 133.31 | 9,198.56 | 84 | 11,146.40 | |
| June 17, 2026 | issue | SO-260617-741 | MAIN | 6 | 129.86 | -779.14 | 15 | 1,947.85 | April 8, 2026: 6 @ 129.86 |
| June 10, 2026 | issue | SO-260610-670 | MAIN | 22 | 129.86 | -2,856.85 | 21 | 2,726.99 | April 8, 2026: 22 @ 129.86 |
| May 25, 2026 | issue | SO-260525-904 | MAIN | 3 | 129.86 | -389.57 | 43 | 5,583.83 | April 8, 2026: 3 @ 129.86 |
| May 14, 2026 | return | RMA | MAIN | 1 | 129.86 | 129.86 | 46 | 5,973.40 | |
| May 13, 2026 | issue | SO-260513-130 | MAIN | 17 | 129.86 | -2,207.56 | 45 | 5,843.55 | April 8, 2026: 17 @ 129.86 |
| May 11, 2026 | issue | SO-260511-718 | MAIN | 5 | 129.86 | -649.28 | 62 | 8,051.11 | April 8, 2026: 5 @ 129.86 |
| May 6, 2026 | issue | SO-260506-540 | MAIN | 1 | 129.86 | -129.86 | 67 | 8,700.39 | April 8, 2026: 1 @ 129.86 |
| May 2, 2026 | issue | SO-260502-737 | MAIN | 1 | 129.86 | -129.86 | 68 | 8,830.25 | April 8, 2026: 1 @ 129.86 |
| May 1, 2026 | issue | SO-260501-819 | MAIN | 4 | 129.14 | -516.55 | 69 | 8,960.11 | Feb. 9, 2026: 4 @ 129.14 |
| April 24, 2026 | issue | SO-260424-115 | MAIN | 2 | 129.14 | -258.27 | 73 | 9,476.65 | Feb. 9, 2026: 2 @ 129.14 |
| April 22, 2026 | issue | SO-260422-934 | MAIN | 4 | 129.14 | -516.55 | 75 | 9,734.93 | Feb. 9, 2026: 4 @ 129.14 |
| April 16, 2026 | issue | SO-260416-472 | MAIN | 5 | 129.14 | -645.68 | 79 | 10,251.47 | Feb. 9, 2026: 5 @ 129.14 |
| April 13, 2026 | issue | SO-260413-551 | MAIN | 2 | 129.14 | -258.27 | 84 | 10,897.16 | Feb. 9, 2026: 2 @ 129.14 |
| April 8, 2026 | receipt | PO-001393 | MAIN | 69 | 129.86 | 8,960.11 | 86 | 11,155.43 | |
| April 2, 2026 | issue | SO-260402-864 | MAIN | 11 | 129.14 | -1,420.51 | 17 | 2,195.33 | Feb. 9, 2026: 11 @ 129.14 |
| March 22, 2026 | issue | SO-260322-335 | MAIN | 20 | 129.14 | -2,582.74 | 28 | 3,615.83 | Feb. 9, 2026: 20 @ 129.14 |
| March 14, 2026 | issue | SO-260314-749 | MAIN | 5 | 129.14 | -645.68 | 48 | 6,198.57 | Feb. 9, 2026: 5 @ 129.14 |
| March 11, 2026 | issue | SO-260311-330 | MAIN | 9 | 129.14 | -1,162.23 | 53 | 6,844.26 | Feb. 9, 2026: 9 @ 129.14 |
| March 7, 2026 | issue | SO-260307-490 | MAIN | 1 | 129.14 | -129.14 | 62 | 8,006.49 | Feb. 9, 2026: 1 @ 129.14 |
| March 3, 2026 | issue | SO-260303-851 | MAIN | 6 | 129.14 | -774.82 | 63 | 8,135.62 | Feb. 9, 2026: 6 @ 129.14 |
| Feb. 9, 2026 | receipt | PO-001211 | MAIN | 69 | 129.14 | 8,910.45 | 69 | 8,910.45 | |
| Feb. 6, 2026 | issue | SO-260206-521 | MAIN | 4 | 125.20 | -500.78 | 0 | 0.00 | Dec. 3, 2025: 4 @ 125.20 |
| Feb. 2, 2026 | issue | SO-260202-220 | MAIN | 27 | 125.20 | -3,380.28 | 4 | 500.78 | Dec. 3, 2025: 27 @ 125.20 |
| Jan. 31, 2026 | issue | SO-260131-127 | MAIN | 2 | 125.20 | -250.39 | 31 | 3,881.07 | Dec. 3, 2025: 2 @ 125.20 |
| Jan. 28, 2026 | issue | SO-260128-478 | EAST | 3 | 125.20 | -375.59 | 33 | 4,131.46 | Dec. 3, 2025: 3 @ 125.20 |
| Jan. 24, 2026 | issue | SO-260124-937 | EAST | 2 | 125.20 | -250.39 | 36 | 4,507.05 | Dec. 3, 2025: 2 @ 125.20 |
| Jan. 14, 2026 | issue | SO-260114-582 | EAST | 7 | 125.20 | -876.37 | 38 | 4,757.44 | Dec. 3, 2025: 7 @ 125.20 |
| Jan. 8, 2026 | issue | SO-260108-316 | MAIN | 8 | 125.20 | -1,001.57 | 45 | 5,633.81 | Dec. 3, 2025: 8 @ 125.20 |
| Jan. 3, 2026 | issue | SO-260103-952 | MAIN | 6 | 125.20 | -751.17 | 53 | 6,635.37 | Dec. 3, 2025: 6 @ 125.20 |
| Dec. 28, 2025 | issue | SO-251228-557 | MAIN | 8 | 125.20 | -1,001.57 | 59 | 7,386.55 | Dec. 3, 2025: 8 @ 125.20 |
| Dec. 21, 2025 | issue | SO-251221-377 | MAIN | 2 | 125.20 | -250.39 | 67 | 8,388.11 | Dec. 3, 2025: 2 @ 125.20 |
| Dec. 13, 2025 | issue | SO-251213-198 | MAIN | 2 | 129.75 | -259.51 | 69 | 8,638.50 | Nov. 7, 2025: 2 @ 129.75 |
| Dec. 12, 2025 | issue | SO-251212-708 | EAST | 1 | 129.75 | -129.75 | 71 | 8,898.01 | Nov. 7, 2025: 1 @ 129.75 |
| Dec. 8, 2025 | issue | SO-251208-471 | MAIN | 2 | 129.75 | -259.51 | 72 | 9,027.76 | Nov. 7, 2025: 2 @ 129.75 |
| Dec. 3, 2025 | issue | SO-251203-691 | EAST | 1 | 129.75 | -129.75 | 74 | 9,287.27 | Nov. 7, 2025: 1 @ 129.75 |
| Dec. 3, 2025 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| Dec. 3, 2025 | receipt | PO-001033 | MAIN | 69 | 125.20 | 8,638.50 | 75 | 9,417.02 | |
| Dec. 1, 2025 | issue | SO-251201-819 | MAIN | 2 | 129.75 | -259.51 | 6 | 778.52 | Nov. 7, 2025: 2 @ 129.75 |
| Nov. 29, 2025 | issue | SO-251129-205 | MAIN | 2 | 129.75 | -259.51 | 8 | 1,038.03 | Nov. 7, 2025: 2 @ 129.75 |
| Nov. 28, 2025 | issue | SO-251128-859 | MAIN | 2 | 129.75 | -259.51 | 10 | 1,297.54 | Nov. 7, 2025: 2 @ 129.75 |
| Nov. 26, 2025 | issue | SO-251126-364 | MAIN | 11 | 129.75 | -1,427.29 | 12 | 1,557.04 | Nov. 7, 2025: 11 @ 129.75 |
| Nov. 24, 2025 | issue | SO-251124-736 | MAIN | 31 | 129.75 | -4,022.36 | 23 | 2,984.33 | Nov. 7, 2025: 31 @ 129.75 |
| Nov. 24, 2025 | issue | SO-251124-736 | EAST | 10 | 129.75 | -1,297.54 | 54 | 7,006.69 | Nov. 7, 2025: 10 @ 129.75 |
| Nov. 15, 2025 | issue | SO-251115-821 | EAST | 5 | 129.75 | -648.77 | 64 | 8,304.22 | Nov. 7, 2025: 5 @ 129.75 |