Items / MCB-0024
RCCB 40A Prime MCB-0024 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)55MAIN 55
Value (FIFO)3,007.16avg 54.68
ClassAX / FCV 0.43
Turnover23.6xlast issue 2 days ago
Days of cover21lead 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 | 80.00 / 30.4375 | 2.628 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 34.01 / 5.517 | 6.165 |
| 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 * 6.165^2 + 2.628^2 * 1.5^2) | 34.4 |
| Reorder point | d * LT + safety stock | 2.628 * 7.0 + 34.4 | 52.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 52.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 959/yr, S = 45.00, h = 20%, price = 51.09 | 308.0 |
| Inventory position | on hand + on order | 55 + 0 | 55 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 55.53 | 88 | 54,252 | yes |
| 154 | 53.31 | 154 | 52,243 | yes |
| 308 | 51.09 | 308 | 50,724 | yes (chosen if cheapest) |
MOQ 77, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 24, 2026 | 55 / 139 | 54.68 | 3,007.16 |
Movement ledger 138 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-963 | MAIN | 40 | 54.68 | -2,187.02 | 55 | 3,007.16 | Sept. 24, 2026: 40 @ 54.68 |
| Oct. 12, 2026 | issue | SO-261012-518 | MAIN | 13 | 54.68 | -710.78 | 95 | 5,194.18 | Sept. 24, 2026: 13 @ 54.68 |
| Oct. 5, 2026 | issue | SO-261005-844 | MAIN | 7 | 54.68 | -382.73 | 108 | 5,904.96 | Sept. 24, 2026: 7 @ 54.68 |
| Oct. 3, 2026 | issue | SO-261003-981 | MAIN | 2 | 54.68 | -109.35 | 115 | 6,287.69 | Sept. 24, 2026: 2 @ 54.68 |
| Sept. 26, 2026 | issue | SO-260926-518 | MAIN | 22 | 54.68 | -1,202.86 | 117 | 6,397.05 | Sept. 24, 2026: 22 @ 54.68 |
| Sept. 26, 2026 | issue | SO-260926-518 | EAST | 1 | 55.57 | -55.57 | 139 | 7,599.91 | July 24, 2026: 1 @ 55.57 |
| Sept. 24, 2026 | receipt | PO-001827 | MAIN | 139 | 54.68 | 7,599.91 | 140 | 7,655.47 | |
| Sept. 23, 2026 | issue | SO-260923-889 | EAST | 11 | 55.57 | -611.22 | 1 | 55.57 | July 24, 2026: 11 @ 55.57 |
| Sept. 23, 2026 | issue | SO-260923-889 | MAIN | 16 | 55.57 | -889.05 | 12 | 666.79 | July 24, 2026: 16 @ 55.57 |
| Sept. 19, 2026 | issue | SO-260919-568 | EAST | 15 | 55.57 | -833.48 | 28 | 1,555.84 | July 24, 2026: 15 @ 55.57 |
| Sept. 13, 2026 | issue | SO-260913-842 | MAIN | 1 | 55.57 | -55.57 | 43 | 2,389.32 | July 24, 2026: 1 @ 55.57 |
| Sept. 12, 2026 | issue | SO-260912-788 | MAIN | 26 | 55.57 | -1,444.71 | 44 | 2,444.89 | July 24, 2026: 26 @ 55.57 |
| Aug. 28, 2026 | issue | SO-260828-916 | EAST | 2 | 55.57 | -111.13 | 70 | 3,889.59 | July 24, 2026: 2 @ 55.57 |
| Aug. 23, 2026 | issue | SO-260823-288 | MAIN | 9 | 55.57 | -500.09 | 72 | 4,000.72 | July 24, 2026: 9 @ 55.57 |
| Aug. 15, 2026 | issue | SO-260815-674 | MAIN | 12 | 55.57 | -666.79 | 81 | 4,500.81 | July 24, 2026: 12 @ 55.57 |
| Aug. 11, 2026 | issue | SO-260811-827 | MAIN | 6 | 55.57 | -333.39 | 93 | 5,167.60 | July 24, 2026: 6 @ 55.57 |
| Aug. 10, 2026 | issue | SO-260810-665 | MAIN | 8 | 55.57 | -444.52 | 99 | 5,500.99 | July 24, 2026: 8 @ 55.57 |
| Aug. 7, 2026 | issue | SO-260807-735 | MAIN | 12 | 55.57 | -666.79 | 107 | 5,945.52 | July 24, 2026: 12 @ 55.57 |
| Aug. 3, 2026 | issue | SO-260803-530 | MAIN | 1 | 55.57 | -55.57 | 119 | 6,612.31 | July 24, 2026: 1 @ 55.57 |
| July 28, 2026 | issue | SO-260728-566 | EAST | 19 | 55.57 | -1,055.75 | 120 | 6,667.87 | July 24, 2026: 19 @ 55.57 |
| July 24, 2026 | transfer | TRF | MAIN → EAST | 48 | warehouse transfer, no cost effect | ||||
| July 24, 2026 | receipt | PO-001671 | MAIN | 139 | 55.57 | 7,723.62 | 139 | 7,723.62 | |
| July 22, 2026 | issue | SO-260722-732 | EAST | 20 | 53.66 | -1,073.11 | 0 | 0.00 | May 2, 2026: 20 @ 53.66 |
| July 22, 2026 | issue | SO-260722-732 | MAIN | 16 | 53.66 | -858.49 | 20 | 1,073.11 | May 2, 2026: 16 @ 53.66 |
| July 20, 2026 | issue | SO-260720-536 | MAIN | 20 | 53.66 | -1,073.11 | 36 | 1,931.59 | May 2, 2026: 20 @ 53.66 |
| June 22, 2026 | issue | SO-260622-505 | MAIN | 27 | 53.66 | -1,448.70 | 56 | 3,004.70 | May 2, 2026: 27 @ 53.66 |
| June 19, 2026 | issue | SO-260619-894 | MAIN | 3 | 53.66 | -160.97 | 83 | 4,453.40 | May 2, 2026: 3 @ 53.66 |
| June 6, 2026 | issue | SO-260606-290 | MAIN | 9 | 53.66 | -482.90 | 86 | 4,614.36 | May 2, 2026: 9 @ 53.66 |
| May 19, 2026 | issue | SO-260519-380 | MAIN | 42 | 53.66 | -2,253.53 | 95 | 5,097.26 | May 2, 2026: 42 @ 53.66 |
| May 17, 2026 | issue | SO-260517-683 | MAIN | 1 | 53.66 | -53.66 | 137 | 7,350.79 | May 2, 2026: 1 @ 53.66 |
| May 9, 2026 | issue | SO-260509-845 | MAIN | 7 | 53.16 | -372.09 | 138 | 7,404.45 | Feb. 18, 2026: 6 @ 53.07; May 2, 2026: 1 @ 53.66 |
| May 6, 2026 | issue | SO-260506-624 | MAIN | 4 | 53.07 | -212.29 | 145 | 7,776.53 | Feb. 18, 2026: 4 @ 53.07 |
| May 5, 2026 | issue | SO-260505-538 | MAIN | 21 | 53.07 | -1,114.51 | 149 | 7,988.82 | Feb. 18, 2026: 21 @ 53.07 |
| May 2, 2026 | receipt | PO-001459 | MAIN | 139 | 53.66 | 7,458.10 | 170 | 9,103.33 | |
| April 25, 2026 | issue | SO-260425-641 | EAST | 8 | 53.07 | -424.58 | 31 | 1,645.23 | Feb. 18, 2026: 8 @ 53.07 |
| April 20, 2026 | issue | SO-260420-982 | EAST | 2 | 53.07 | -106.14 | 39 | 2,069.81 | Feb. 18, 2026: 2 @ 53.07 |
| April 18, 2026 | issue | SO-260418-883 | MAIN | 15 | 53.07 | -796.08 | 41 | 2,175.95 | Feb. 18, 2026: 15 @ 53.07 |
| April 4, 2026 | issue | SO-260404-213 | MAIN | 25 | 53.07 | -1,326.80 | 56 | 2,972.03 | Feb. 18, 2026: 25 @ 53.07 |
| March 22, 2026 | issue | SO-260322-123 | MAIN | 5 | 53.07 | -265.36 | 81 | 4,298.83 | Feb. 18, 2026: 5 @ 53.07 |
| March 17, 2026 | issue | SO-260317-443 | MAIN | 11 | 53.07 | -583.79 | 86 | 4,564.19 | Feb. 18, 2026: 11 @ 53.07 |
| March 5, 2026 | issue | SO-260305-918 | MAIN | 5 | 53.07 | -265.36 | 97 | 5,147.98 | Feb. 18, 2026: 5 @ 53.07 |
| Feb. 23, 2026 | issue | SO-260223-708 | MAIN | 17 | 53.07 | -902.22 | 102 | 5,413.34 | Feb. 18, 2026: 17 @ 53.07 |
| Feb. 21, 2026 | issue | SO-260221-328 | MAIN | 21 | 53.12 | -1,115.44 | 119 | 6,315.57 | Jan. 18, 2026: 1 @ 54.00; Feb. 18, 2026: 20 @ 53.07 |
| Feb. 18, 2026 | transfer | TRF | MAIN → EAST | 30 | warehouse transfer, no cost effect | ||||
| Feb. 18, 2026 | receipt | PO-001238 | MAIN | 139 | 53.07 | 7,377.01 | 140 | 7,431.01 | |
| Feb. 13, 2026 | issue | SO-260213-703 | MAIN | 7 | 54.00 | -378.01 | 1 | 54.00 | Jan. 18, 2026: 7 @ 54.00 |
| Feb. 11, 2026 | issue | SO-260211-283 | MAIN | 25 | 54.00 | -1,350.02 | 8 | 432.01 | Jan. 18, 2026: 25 @ 54.00 |
| Feb. 9, 2026 | issue | SO-260209-200 | MAIN | 63 | 54.00 | -3,402.05 | 33 | 1,782.03 | Jan. 18, 2026: 63 @ 54.00 |
| Feb. 4, 2026 | issue | SO-260204-393 | MAIN | 3 | 54.00 | -162.00 | 96 | 5,184.08 | Jan. 18, 2026: 3 @ 54.00 |
| Feb. 3, 2026 | issue | SO-260203-394 | MAIN | 1 | 54.00 | -54.00 | 99 | 5,346.08 | Jan. 18, 2026: 1 @ 54.00 |
| Jan. 29, 2026 | issue | SO-260129-768 | MAIN | 39 | 54.00 | -2,106.03 | 100 | 5,400.08 | Jan. 18, 2026: 39 @ 54.00 |
| Jan. 18, 2026 | receipt | PO-001157 | MAIN | 139 | 54.00 | 7,506.11 | 139 | 7,506.11 | |
| Jan. 12, 2026 | issue | SO-260112-927 | MAIN | 41 | 54.18 | -2,221.24 | 0 | 0.00 | Dec. 16, 2025: 41 @ 54.18 |
| Jan. 1, 2026 | issue | SO-260101-792 | MAIN | 47 | 54.18 | -2,546.30 | 41 | 2,221.24 | Dec. 16, 2025: 47 @ 54.18 |
| Dec. 31, 2025 | issue | SO-251231-100 | MAIN | 20 | 54.18 | -1,083.53 | 88 | 4,767.53 | Dec. 16, 2025: 20 @ 54.18 |
| Dec. 25, 2025 | issue | SO-251225-136 | MAIN | 22 | 54.18 | -1,191.88 | 108 | 5,851.06 | Dec. 16, 2025: 22 @ 54.18 |
| Dec. 24, 2025 | issue | SO-251224-890 | MAIN | 2 | 54.18 | -108.35 | 130 | 7,042.94 | Dec. 16, 2025: 2 @ 54.18 |
| Dec. 23, 2025 | issue | SO-251223-873 | MAIN | 7 | 54.18 | -379.24 | 132 | 7,151.30 | Dec. 16, 2025: 7 @ 54.18 |
| Dec. 16, 2025 | receipt | PO-001056 | MAIN | 139 | 54.18 | 7,530.53 | 139 | 7,530.53 | |
| Dec. 11, 2025 | issue | SO-251211-734 | MAIN | 37 | 53.09 | -1,964.47 | 0 | 0.00 | Oct. 18, 2025: 37 @ 53.09 |