Items / MCB-0022
MCB 16A DP Nova MCB-0022 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)16MAIN 16
Value (FIFO)865.46avg 54.09
ClassBY / FCV 0.62
Turnover12.2xlast issue 8 days ago
Days of cover18lead time 7d
Reorder suggested: 52 units (position at or below reorder point: order EOQ), stockout risk low.
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.92 / 30.4375 | 0.884 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 16.68 / 5.517 | 3.023 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(7.0 * 3.023^2 + 0.884^2 * 1.5^2) | 13.3 |
| Reorder point | d * LT + safety stock | 0.884 * 7.0 + 13.3 | 19.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 19.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 323/yr, S = 45.00, h = 20%, price = 54.78 | 51.5 |
| Inventory position | on hand + on order | 16 + 0 | 16 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 54.78 | 51 | 18,246 | yes (chosen if cheapest) |
MOQ 25, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 18, 2026 | 16 / 45 | 54.09 | 865.46 |
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. 8, 2026 | issue | SO-261008-386 | MAIN | 10 | 54.09 | -540.91 | 16 | 865.46 | Sept. 18, 2026: 10 @ 54.09 |
| Oct. 8, 2026 | issue | SO-261008-386 | EAST | 6 | 54.09 | -324.55 | 26 | 1,406.37 | Sept. 18, 2026: 6 @ 54.09 |
| Oct. 6, 2026 | issue | SO-261006-205 | MAIN | 1 | 54.09 | -54.09 | 32 | 1,730.92 | Sept. 18, 2026: 1 @ 54.09 |
| Oct. 4, 2026 | issue | SO-261004-833 | EAST | 1 | 54.09 | -54.09 | 33 | 1,785.01 | Sept. 18, 2026: 1 @ 54.09 |
| Oct. 2, 2026 | issue | SO-261002-776 | EAST | 2 | 54.09 | -108.18 | 34 | 1,839.10 | Sept. 18, 2026: 2 @ 54.09 |
| Sept. 27, 2026 | issue | SO-260927-691 | MAIN | 10 | 54.06 | -540.61 | 36 | 1,947.28 | Aug. 22, 2026: 1 @ 53.79; Sept. 18, 2026: 9 @ 54.09 |
| Sept. 18, 2026 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| Sept. 18, 2026 | receipt | PO-001810 | MAIN | 45 | 54.09 | 2,434.10 | 46 | 2,487.89 | |
| Sept. 11, 2026 | issue | SO-260911-309 | MAIN | 13 | 53.79 | -699.31 | 1 | 53.79 | Aug. 22, 2026: 13 @ 53.79 |
| Sept. 2, 2026 | issue | SO-260902-130 | MAIN | 7 | 53.79 | -376.55 | 14 | 753.10 | Aug. 22, 2026: 7 @ 53.79 |
| Aug. 27, 2026 | issue | SO-260827-754 | MAIN | 31 | 54.05 | -1,675.58 | 21 | 1,129.65 | June 24, 2026: 7 @ 54.94; Aug. 22, 2026: 24 @ 53.79 |
| Aug. 22, 2026 | receipt | PO-001734 | MAIN | 45 | 53.79 | 2,420.68 | 52 | 2,805.23 | |
| Aug. 16, 2026 | issue | SO-260816-135 | MAIN | 17 | 54.94 | -933.91 | 7 | 384.55 | June 24, 2026: 17 @ 54.94 |
| July 15, 2026 | issue | SO-260715-723 | MAIN | 1 | 54.94 | -54.94 | 24 | 1,318.46 | June 24, 2026: 1 @ 54.94 |
| July 9, 2026 | issue | SO-260709-769 | MAIN | 2 | 54.94 | -109.87 | 25 | 1,373.39 | June 24, 2026: 2 @ 54.94 |
| July 7, 2026 | issue | SO-260707-242 | MAIN | 5 | 54.94 | -274.68 | 27 | 1,483.26 | June 24, 2026: 5 @ 54.94 |
| July 2, 2026 | issue | SO-260702-397 | MAIN | 5 | 54.94 | -274.68 | 32 | 1,757.94 | June 24, 2026: 5 @ 54.94 |
| June 25, 2026 | issue | SO-260625-225 | MAIN | 8 | 54.94 | -439.49 | 37 | 2,032.62 | June 24, 2026: 8 @ 54.94 |
| June 24, 2026 | receipt | PO-001602 | MAIN | 45 | 54.94 | 2,472.11 | 45 | 2,472.11 | |
| June 22, 2026 | issue | SO-260622-438 | MAIN | 5 | 54.78 | -273.92 | 0 | 0.00 | April 2, 2026: 5 @ 54.78 |
| June 19, 2026 | issue | SO-260619-541 | MAIN | 6 | 54.78 | -328.70 | 5 | 273.92 | April 2, 2026: 6 @ 54.78 |
| June 18, 2026 | issue | SO-260618-811 | MAIN | 1 | 54.78 | -54.78 | 11 | 602.62 | April 2, 2026: 1 @ 54.78 |
| June 3, 2026 | issue | SO-260603-602 | MAIN | 2 | 54.78 | -109.57 | 12 | 657.40 | April 2, 2026: 2 @ 54.78 |
| May 24, 2026 | issue | SO-260524-577 | MAIN | 1 | 54.78 | -54.78 | 14 | 766.97 | April 2, 2026: 1 @ 54.78 |
| May 24, 2026 | issue | SO-260524-577 | EAST | 8 | 54.78 | -438.27 | 15 | 821.75 | April 2, 2026: 8 @ 54.78 |
| May 10, 2026 | issue | SO-260510-327 | MAIN | 1 | 54.78 | -54.78 | 23 | 1,260.02 | April 2, 2026: 1 @ 54.78 |
| April 20, 2026 | issue | SO-260420-793 | MAIN | 7 | 54.78 | -383.48 | 24 | 1,314.80 | April 2, 2026: 7 @ 54.78 |
| April 16, 2026 | issue | SO-260416-419 | MAIN | 2 | 54.78 | -109.57 | 31 | 1,698.29 | April 2, 2026: 2 @ 54.78 |
| April 14, 2026 | issue | SO-260414-247 | EAST | 1 | 54.78 | -54.78 | 33 | 1,807.85 | April 2, 2026: 1 @ 54.78 |
| April 8, 2026 | issue | SO-260408-877 | MAIN | 11 | 54.78 | -602.62 | 34 | 1,862.64 | April 2, 2026: 11 @ 54.78 |
| April 2, 2026 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| April 2, 2026 | receipt | PO-001377 | MAIN | 45 | 54.78 | 2,465.25 | 45 | 2,465.25 | |
| March 28, 2026 | issue | SO-260328-234 | EAST | 14 | 53.90 | -754.63 | 0 | 0.00 | Jan. 16, 2026: 13 @ 53.90; Feb. 27, 2026: 1 @ 53.90 |
| March 18, 2026 | issue | SO-260318-765 | EAST | 9 | 53.90 | -485.12 | 14 | 754.63 | Jan. 16, 2026: 9 @ 53.90 |
| March 18, 2026 | issue | SO-260318-765 | MAIN | 13 | 53.90 | -700.73 | 23 | 1,239.75 | Jan. 16, 2026: 13 @ 53.90 |
| March 6, 2026 | issue | SO-260306-923 | EAST | 1 | 53.90 | -53.90 | 36 | 1,940.48 | Jan. 16, 2026: 1 @ 53.90 |
| Feb. 27, 2026 | return | RMA | MAIN | 1 | 53.90 | 53.90 | 37 | 1,994.38 | |
| Feb. 25, 2026 | issue | SO-260225-842 | MAIN | 1 | 53.90 | -53.90 | 36 | 1,940.48 | Jan. 16, 2026: 1 @ 53.90 |
| Feb. 19, 2026 | issue | SO-260219-846 | MAIN | 1 | 53.90 | -53.90 | 37 | 1,994.38 | Jan. 16, 2026: 1 @ 53.90 |
| Feb. 7, 2026 | issue | SO-260207-556 | MAIN | 15 | 54.01 | -810.20 | 38 | 2,048.28 | Dec. 19, 2025: 8 @ 54.11; Jan. 16, 2026: 7 @ 53.90 |
| Feb. 6, 2026 | issue | SO-260206-782 | MAIN | 1 | 54.11 | -54.11 | 53 | 2,858.48 | Dec. 19, 2025: 1 @ 54.11 |
| Jan. 16, 2026 | transfer | TRF | MAIN → EAST | 15 | warehouse transfer, no cost effect | ||||
| Jan. 16, 2026 | receipt | PO-001148 | MAIN | 45 | 53.90 | 2,425.59 | 54 | 2,912.59 | |
| Jan. 8, 2026 | issue | SO-260108-931 | MAIN | 13 | 54.11 | -703.43 | 9 | 486.99 | Dec. 19, 2025: 13 @ 54.11 |
| Jan. 3, 2026 | issue | SO-260103-167 | MAIN | 1 | 54.11 | -54.11 | 22 | 1,190.43 | Dec. 19, 2025: 1 @ 54.11 |
| Dec. 28, 2025 | issue | SO-251228-414 | MAIN | 18 | 54.11 | -973.99 | 23 | 1,244.54 | Dec. 19, 2025: 18 @ 54.11 |
| Dec. 27, 2025 | issue | SO-251227-515 | MAIN | 6 | 54.07 | -324.39 | 41 | 2,218.52 | Nov. 18, 2025: 2 @ 53.98; Dec. 19, 2025: 4 @ 54.11 |
| Dec. 22, 2025 | issue | SO-251222-592 | EAST | 6 | 53.98 | -323.86 | 47 | 2,542.92 | Nov. 18, 2025: 6 @ 53.98 |
| Dec. 19, 2025 | transfer | TRF | MAIN → EAST | 15 | warehouse transfer, no cost effect | ||||
| Dec. 19, 2025 | receipt | PO-001067 | MAIN | 45 | 54.11 | 2,434.96 | 53 | 2,866.78 | |
| Dec. 12, 2025 | issue | SO-251212-847 | MAIN | 3 | 53.98 | -161.93 | 8 | 431.81 | Nov. 18, 2025: 3 @ 53.98 |
| Dec. 11, 2025 | issue | SO-251211-381 | MAIN | 17 | 53.98 | -917.60 | 11 | 593.74 | Nov. 18, 2025: 17 @ 53.98 |
| Dec. 10, 2025 | issue | SO-251210-411 | MAIN | 3 | 53.98 | -161.93 | 28 | 1,511.34 | Nov. 18, 2025: 3 @ 53.98 |
| Dec. 4, 2025 | issue | SO-251204-947 | MAIN | 1 | 53.98 | -53.98 | 31 | 1,673.27 | Nov. 18, 2025: 1 @ 53.98 |
| Dec. 4, 2025 | issue | SO-251204-947 | EAST | 16 | 53.55 | -856.85 | 32 | 1,727.25 | Sept. 16, 2025: 1 @ 51.72; Nov. 7, 2025: 2 @ 51.72; Nov. 18, 2025: 13 @ 53.98 |
| Nov. 27, 2025 | issue | SO-251127-277 | MAIN | 3 | 51.72 | -155.16 | 48 | 2,584.10 | Sept. 16, 2025: 3 @ 51.72 |
| Nov. 19, 2025 | issue | SO-251119-217 | EAST | 1 | 51.72 | -51.72 | 51 | 2,739.26 | Sept. 16, 2025: 1 @ 51.72 |
| Nov. 18, 2025 | issue | SO-251118-579 | MAIN | 3 | 51.72 | -155.16 | 52 | 2,790.98 | Sept. 16, 2025: 3 @ 51.72 |
| Nov. 18, 2025 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| Nov. 18, 2025 | receipt | PO-001007 | MAIN | 45 | 53.98 | 2,428.94 | 55 | 2,946.14 | |