Items / MCB-0012
RCCB 40A Elite MCB-0012 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)25MAIN 25
Value (FIFO)1,192.11avg 47.68
ClassCX / FCV 0.41
Turnover17.3xlast issue 0 days ago
Days of cover42lead 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 | 18.33 / 30.4375 | 0.602 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 7.43 / 5.517 | 1.347 |
| 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.347^2 + 0.602^2 * 1.5^2) | 4.7 |
| Reorder point | d * LT + safety stock | 0.602 * 7.0 + 4.7 | 8.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 8.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 220/yr, S = 45.00, h = 20%, price = 47.08 | 45.8 |
| Inventory position | on hand + on order | 25 + 0 | 25 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 47.08 | 46 | 10,782 | yes (chosen if cheapest) |
MOQ 20, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 21, 2026 | 25 / 36 | 47.68 | 1,192.11 |
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. 16, 2026 | issue | SO-261016-608 | MAIN | 4 | 47.68 | -190.74 | 25 | 1,192.11 | Sept. 21, 2026: 4 @ 47.68 |
| Oct. 14, 2026 | issue | SO-261014-600 | MAIN | 2 | 47.68 | -95.37 | 29 | 1,382.85 | Sept. 21, 2026: 2 @ 47.68 |
| Oct. 9, 2026 | issue | SO-261009-788 | MAIN | 1 | 47.68 | -47.68 | 31 | 1,478.22 | Sept. 21, 2026: 1 @ 47.68 |
| Oct. 8, 2026 | issue | SO-261008-934 | MAIN | 3 | 47.68 | -143.05 | 32 | 1,525.90 | Sept. 21, 2026: 3 @ 47.68 |
| Oct. 3, 2026 | issue | SO-261003-230 | MAIN | 9 | 46.76 | -420.83 | 35 | 1,668.96 | Sept. 6, 2026: 7 @ 46.70; Sept. 6, 2026: 1 @ 46.23; Sept. 21, 2026: 1 @ 47.68 |
| Sept. 21, 2026 | receipt | PO-001818 | MAIN | 36 | 47.68 | 1,716.64 | 44 | 2,089.78 | |
| Sept. 15, 2026 | issue | SO-260915-832 | MAIN | 12 | 46.70 | -560.42 | 8 | 373.14 | Sept. 6, 2026: 12 @ 46.70 |
| Sept. 12, 2026 | issue | SO-260912-419 | MAIN | 23 | 46.58 | -1,071.31 | 20 | 933.56 | Aug. 8, 2026: 6 @ 46.23; Sept. 6, 2026: 17 @ 46.70 |
| Sept. 6, 2026 | return | RMA | MAIN | 1 | 46.23 | 46.23 | 43 | 2,004.87 | |
| Sept. 6, 2026 | receipt | PO-001776 | MAIN | 36 | 46.70 | 1,681.25 | 42 | 1,958.64 | |
| Aug. 30, 2026 | issue | SO-260830-872 | MAIN | 7 | 46.23 | -323.62 | 6 | 277.39 | Aug. 8, 2026: 7 @ 46.23 |
| Aug. 29, 2026 | issue | SO-260829-657 | MAIN | 17 | 46.23 | -785.93 | 13 | 601.01 | Aug. 8, 2026: 17 @ 46.23 |
| Aug. 26, 2026 | issue | SO-260826-704 | MAIN | 3 | 46.23 | -138.69 | 30 | 1,386.94 | Aug. 8, 2026: 3 @ 46.23 |
| Aug. 20, 2026 | issue | SO-260820-877 | MAIN | 1 | 46.23 | -46.23 | 33 | 1,525.63 | Aug. 8, 2026: 1 @ 46.23 |
| Aug. 8, 2026 | issue | SO-260808-537 | MAIN | 2 | 46.23 | -92.46 | 34 | 1,571.86 | Aug. 8, 2026: 2 @ 46.23 |
| Aug. 8, 2026 | receipt | PO-001706 | MAIN | 36 | 46.23 | 1,664.33 | 36 | 1,664.33 | |
| July 30, 2026 | issue | SO-260730-434 | EAST | 7 | 46.11 | -322.77 | 0 | 0.00 | May 13, 2026: 4 @ 45.99; May 22, 2026: 3 @ 46.27 |
| July 30, 2026 | issue | SO-260730-434 | MAIN | 6 | 45.99 | -275.94 | 7 | 322.77 | May 13, 2026: 6 @ 45.99 |
| July 19, 2026 | adjustment | Cycle count | MAIN | -2 | 45.99 | -91.98 | 13 | 598.71 | May 13, 2026: 2 @ 45.99 |
| July 15, 2026 | issue | SO-260715-211 | MAIN | 1 | 45.99 | -45.99 | 15 | 690.69 | May 13, 2026: 1 @ 45.99 |
| June 22, 2026 | issue | SO-260622-586 | MAIN | 10 | 45.99 | -459.90 | 16 | 736.68 | May 13, 2026: 10 @ 45.99 |
| June 20, 2026 | issue | SO-260620-814 | MAIN | 6 | 45.99 | -275.94 | 26 | 1,196.58 | May 13, 2026: 6 @ 45.99 |
| June 19, 2026 | issue | SO-260619-477 | MAIN | 1 | 45.99 | -45.99 | 32 | 1,472.52 | May 13, 2026: 1 @ 45.99 |
| June 14, 2026 | issue | SO-260614-632 | MAIN | 3 | 45.99 | -137.97 | 33 | 1,518.51 | May 13, 2026: 3 @ 45.99 |
| June 5, 2026 | issue | SO-260605-623 | MAIN | 1 | 45.99 | -45.99 | 36 | 1,656.48 | May 13, 2026: 1 @ 45.99 |
| May 31, 2026 | issue | SO-260531-779 | EAST | 1 | 45.99 | -45.99 | 37 | 1,702.47 | May 13, 2026: 1 @ 45.99 |
| May 23, 2026 | issue | SO-260523-130 | EAST | 3 | 46.18 | -138.53 | 38 | 1,748.46 | April 10, 2026: 2 @ 46.27; May 13, 2026: 1 @ 45.99 |
| May 22, 2026 | return | RMA | MAIN | 3 | 46.27 | 138.81 | 41 | 1,886.98 | |
| May 13, 2026 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| May 13, 2026 | receipt | PO-001490 | MAIN | 36 | 45.99 | 1,655.64 | 38 | 1,748.18 | |
| May 8, 2026 | issue | SO-260508-576 | EAST | 3 | 46.27 | -138.81 | 2 | 92.54 | Feb. 13, 2026: 3 @ 46.27 |
| May 7, 2026 | issue | SO-260507-681 | EAST | 1 | 46.27 | -46.27 | 5 | 231.34 | Feb. 13, 2026: 1 @ 46.27 |
| May 5, 2026 | issue | SO-260505-897 | EAST | 7 | 46.27 | -323.88 | 6 | 277.61 | Feb. 13, 2026: 7 @ 46.27 |
| May 5, 2026 | issue | SO-260505-897 | MAIN | 6 | 46.27 | -277.61 | 13 | 601.49 | Feb. 13, 2026: 6 @ 46.27 |
| April 20, 2026 | issue | SO-260420-501 | MAIN | 1 | 46.27 | -46.27 | 19 | 879.11 | Feb. 13, 2026: 1 @ 46.27 |
| April 17, 2026 | issue | SO-260417-485 | EAST | 1 | 46.27 | -46.27 | 20 | 925.37 | Feb. 13, 2026: 1 @ 46.27 |
| April 15, 2026 | issue | SO-260415-885 | MAIN | 1 | 46.27 | -46.27 | 21 | 971.64 | Feb. 13, 2026: 1 @ 46.27 |
| April 12, 2026 | issue | SO-260412-442 | MAIN | 5 | 46.27 | -231.34 | 22 | 1,017.91 | Feb. 13, 2026: 5 @ 46.27 |
| April 10, 2026 | return | RMA | MAIN | 2 | 46.27 | 92.54 | 27 | 1,249.25 | |
| April 10, 2026 | issue | SO-260410-890 | EAST | 1 | 46.27 | -46.27 | 25 | 1,156.72 | Feb. 13, 2026: 1 @ 46.27 |
| April 1, 2026 | issue | SO-260401-865 | MAIN | 1 | 46.27 | -46.27 | 26 | 1,202.99 | Feb. 13, 2026: 1 @ 46.27 |
| March 24, 2026 | issue | SO-260324-513 | MAIN | 4 | 46.27 | -185.07 | 27 | 1,249.25 | Feb. 13, 2026: 4 @ 46.27 |
| March 20, 2026 | issue | SO-260320-388 | MAIN | 2 | 46.27 | -92.54 | 31 | 1,434.33 | Feb. 13, 2026: 2 @ 46.27 |
| March 2, 2026 | issue | SO-260302-358 | MAIN | 10 | 46.47 | -464.73 | 33 | 1,526.87 | Dec. 19, 2025: 7 @ 46.56; Feb. 13, 2026: 3 @ 46.27 |
| Feb. 16, 2026 | issue | SO-260216-847 | EAST | 2 | 46.56 | -93.12 | 43 | 1,991.60 | Dec. 19, 2025: 2 @ 46.56 |
| Feb. 13, 2026 | transfer | TRF | MAIN → EAST | 8 | warehouse transfer, no cost effect | ||||
| Feb. 13, 2026 | receipt | PO-001228 | MAIN | 36 | 46.27 | 1,665.67 | 45 | 2,084.72 | |
| Feb. 8, 2026 | issue | SO-260208-621 | EAST | 3 | 46.56 | -139.68 | 9 | 419.05 | Dec. 19, 2025: 3 @ 46.56 |
| Feb. 8, 2026 | issue | SO-260208-621 | MAIN | 5 | 46.56 | -232.80 | 12 | 558.73 | Dec. 19, 2025: 5 @ 46.56 |
| Feb. 7, 2026 | issue | SO-260207-480 | MAIN | 3 | 46.56 | -139.68 | 17 | 791.53 | Dec. 19, 2025: 3 @ 46.56 |
| Feb. 5, 2026 | issue | SO-260205-640 | MAIN | 6 | 46.56 | -279.36 | 20 | 931.21 | Dec. 19, 2025: 6 @ 46.56 |
| Feb. 2, 2026 | issue | SO-260202-155 | MAIN | 2 | 46.56 | -93.12 | 26 | 1,210.58 | Dec. 19, 2025: 2 @ 46.56 |
| Jan. 25, 2026 | issue | SO-260125-668 | MAIN | 3 | 46.56 | -139.68 | 28 | 1,303.70 | Dec. 19, 2025: 3 @ 46.56 |
| Jan. 11, 2026 | issue | SO-260111-682 | MAIN | 4 | 46.56 | -186.24 | 31 | 1,443.38 | Dec. 19, 2025: 4 @ 46.56 |
| Jan. 6, 2026 | issue | SO-260106-808 | MAIN | 1 | 46.56 | -46.56 | 35 | 1,629.62 | Dec. 19, 2025: 1 @ 46.56 |
| Dec. 19, 2025 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||
| Dec. 19, 2025 | receipt | PO-001066 | MAIN | 36 | 46.56 | 1,676.18 | 36 | 1,676.18 | |
| Dec. 13, 2025 | issue | SO-251213-757 | MAIN | 13 | 44.72 | -581.41 | 0 | 0.00 | Oct. 19, 2025: 13 @ 44.72 |
| Nov. 26, 2025 | issue | SO-251126-419 | MAIN | 7 | 44.72 | -313.07 | 13 | 581.41 | Oct. 19, 2025: 7 @ 44.72 |
| Nov. 23, 2025 | issue | SO-251123-704 | MAIN | 1 | 44.72 | -44.72 | 20 | 894.47 | Oct. 19, 2025: 1 @ 44.72 |