Items / MCB-0006
RCCB 40A Elite MCB-0006 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)80MAIN 57, EAST 23
Value (FIFO)3,234.63avg 40.43
ClassBY / FCV 0.72
Turnover14.1xlast issue 0 days ago
Days of cover48lead 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 | 51.08 / 30.4375 | 1.678 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 36.82 / 5.517 | 6.674 |
| 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 * 6.674^2 + 1.678^2 * 1.5^2) | 29.3 |
| Reorder point | d * LT + safety stock | 1.678 * 7.0 + 29.3 | 41.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 41.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 613/yr, S = 45.00, h = 20%, price = 38.28 | 184.0 |
| Inventory position | on hand + on order | 80 + 0 | 80 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 41.61 | 81 | 26,167 | yes |
| 92 | 39.95 | 92 | 25,137 | yes |
| 184 | 38.28 | 184 | 24,305 | yes (chosen if cheapest) |
MOQ 46, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 13, 2026 | 80 / 82 | 40.43 | 3,234.63 |
Movement ledger 128 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-105 | MAIN | 3 | 40.63 | -121.90 | 80 | 3,234.63 | Aug. 15, 2026: 1 @ 41.03; Oct. 13, 2026: 2 @ 40.43 |
| Oct. 14, 2026 | issue | SO-261014-253 | MAIN | 16 | 41.10 | -657.60 | 83 | 3,356.53 | Aug. 7, 2026: 13 @ 41.12; Aug. 15, 2026: 3 @ 41.03 |
| Oct. 13, 2026 | transfer | TRF | MAIN → EAST | 23 | warehouse transfer, no cost effect | ||||
| Oct. 13, 2026 | receipt | PO-001877 | MAIN | 82 | 40.43 | 3,315.50 | 99 | 4,014.13 | |
| Oct. 9, 2026 | issue | SO-261009-437 | MAIN | 9 | 41.12 | -370.04 | 17 | 698.63 | Aug. 7, 2026: 9 @ 41.12 |
| Sept. 13, 2026 | issue | SO-260913-624 | MAIN | 46 | 41.12 | -1,891.31 | 26 | 1,068.67 | Aug. 7, 2026: 46 @ 41.12 |
| Sept. 5, 2026 | issue | SO-260905-764 | MAIN | 1 | 41.12 | -41.12 | 72 | 2,959.98 | Aug. 7, 2026: 1 @ 41.12 |
| Aug. 22, 2026 | issue | SO-260822-368 | MAIN | 9 | 41.12 | -370.04 | 73 | 3,001.10 | Aug. 7, 2026: 9 @ 41.12 |
| Aug. 15, 2026 | return | RMA | MAIN | 4 | 41.03 | 164.13 | 82 | 3,371.14 | |
| Aug. 9, 2026 | issue | SO-260809-334 | MAIN | 9 | 41.03 | -369.30 | 78 | 3,207.00 | Aug. 6, 2026: 5 @ 40.97; Aug. 7, 2026: 4 @ 41.12 |
| Aug. 7, 2026 | receipt | PO-001703 | MAIN | 82 | 41.12 | 3,371.46 | 87 | 3,576.30 | |
| Aug. 6, 2026 | return | RMA | MAIN | 5 | 40.97 | 204.84 | 5 | 204.84 | |
| July 30, 2026 | issue | SO-260730-447 | EAST | 17 | 40.97 | -696.46 | 0 | 0.00 | July 25, 2026: 17 @ 40.97 |
| July 30, 2026 | issue | SO-260730-447 | MAIN | 65 | 40.97 | -2,662.94 | 17 | 696.46 | July 25, 2026: 65 @ 40.97 |
| July 26, 2026 | issue | SO-260726-403 | EAST | 20 | 40.09 | -801.90 | 82 | 3,359.40 | June 8, 2026: 20 @ 40.09 |
| July 25, 2026 | transfer | TRF | MAIN → EAST | 17 | warehouse transfer, no cost effect | ||||
| July 25, 2026 | receipt | PO-001672 | MAIN | 82 | 40.97 | 3,359.40 | 102 | 4,161.30 | |
| July 18, 2026 | issue | SO-260718-611 | EAST | 6 | 40.09 | -240.57 | 20 | 801.90 | June 8, 2026: 6 @ 40.09 |
| July 18, 2026 | issue | SO-260718-611 | MAIN | 10 | 40.09 | -400.95 | 26 | 1,042.46 | June 8, 2026: 10 @ 40.09 |
| July 9, 2026 | issue | SO-260709-708 | MAIN | 15 | 40.09 | -601.42 | 36 | 1,443.41 | June 8, 2026: 15 @ 40.09 |
| June 23, 2026 | issue | SO-260623-321 | MAIN | 15 | 40.09 | -601.42 | 51 | 2,044.83 | June 8, 2026: 15 @ 40.09 |
| June 16, 2026 | issue | SO-260616-853 | MAIN | 16 | 40.09 | -641.52 | 66 | 2,646.26 | June 8, 2026: 16 @ 40.09 |
| June 8, 2026 | transfer | TRF | MAIN → EAST | 26 | warehouse transfer, no cost effect | ||||
| June 8, 2026 | receipt | PO-001561 | MAIN | 82 | 40.09 | 3,287.77 | 82 | 3,287.77 | |
| May 31, 2026 | issue | SO-260531-590 | MAIN | 36 | 40.35 | -1,452.51 | 0 | 0.00 | March 17, 2026: 36 @ 40.35 |
| May 29, 2026 | issue | SO-260529-401 | MAIN | 5 | 40.35 | -201.74 | 36 | 1,452.51 | March 17, 2026: 5 @ 40.35 |
| April 23, 2026 | issue | SO-260423-474 | MAIN | 8 | 40.35 | -322.78 | 41 | 1,654.25 | March 17, 2026: 8 @ 40.35 |
| April 12, 2026 | issue | SO-260412-139 | MAIN | 12 | 40.35 | -484.17 | 49 | 1,977.03 | March 17, 2026: 12 @ 40.35 |
| April 11, 2026 | issue | SO-260411-845 | MAIN | 20 | 40.35 | -806.95 | 61 | 2,461.20 | March 17, 2026: 20 @ 40.35 |
| April 10, 2026 | issue | SO-260410-347 | MAIN | 4 | 39.74 | -158.95 | 81 | 3,268.15 | Jan. 26, 2026: 3 @ 39.54; March 17, 2026: 1 @ 40.35 |
| April 4, 2026 | issue | SO-260404-507 | MAIN | 5 | 39.54 | -197.68 | 85 | 3,427.10 | Jan. 26, 2026: 5 @ 39.54 |
| March 17, 2026 | receipt | PO-001330 | MAIN | 82 | 40.35 | 3,308.50 | 90 | 3,624.78 | |
| March 13, 2026 | issue | SO-260313-836 | MAIN | 7 | 39.54 | -276.75 | 8 | 316.29 | Jan. 26, 2026: 7 @ 39.54 |
| March 8, 2026 | issue | SO-260308-921 | MAIN | 16 | 39.54 | -632.57 | 15 | 593.04 | Jan. 26, 2026: 16 @ 39.54 |
| Feb. 26, 2026 | issue | SO-260226-533 | MAIN | 3 | 39.54 | -118.61 | 31 | 1,225.61 | Jan. 26, 2026: 3 @ 39.54 |
| Feb. 25, 2026 | issue | SO-260225-675 | MAIN | 4 | 39.54 | -158.14 | 34 | 1,344.22 | Jan. 26, 2026: 4 @ 39.54 |
| Feb. 13, 2026 | issue | SO-260213-281 | MAIN | 1 | 39.54 | -39.54 | 38 | 1,502.36 | Jan. 26, 2026: 1 @ 39.54 |
| Feb. 10, 2026 | issue | SO-260210-223 | MAIN | 5 | 39.54 | -197.68 | 39 | 1,541.90 | Jan. 26, 2026: 5 @ 39.54 |
| Feb. 9, 2026 | issue | SO-260209-766 | MAIN | 2 | 39.54 | -79.07 | 44 | 1,739.58 | Jan. 26, 2026: 2 @ 39.54 |
| Feb. 8, 2026 | issue | SO-260208-944 | MAIN | 3 | 39.54 | -118.61 | 46 | 1,818.65 | Jan. 26, 2026: 3 @ 39.54 |
| Feb. 5, 2026 | issue | SO-260205-705 | MAIN | 1 | 39.54 | -39.54 | 49 | 1,937.25 | Jan. 26, 2026: 1 @ 39.54 |
| Jan. 29, 2026 | issue | SO-260129-450 | MAIN | 9 | 39.54 | -355.82 | 50 | 1,976.79 | Jan. 26, 2026: 9 @ 39.54 |
| Jan. 29, 2026 | issue | SO-260129-450 | EAST | 17 | 39.54 | -672.11 | 59 | 2,332.61 | Jan. 26, 2026: 17 @ 39.54 |
| Jan. 26, 2026 | issue | SO-260126-639 | MAIN | 6 | 39.54 | -237.21 | 76 | 3,004.72 | Jan. 26, 2026: 6 @ 39.54 |
| Jan. 26, 2026 | transfer | TRF | MAIN → EAST | 17 | warehouse transfer, no cost effect | ||||
| Jan. 26, 2026 | receipt | PO-001176 | MAIN | 82 | 39.54 | 3,241.94 | 82 | 3,241.94 | |
| Jan. 18, 2026 | issue | SO-260118-395 | MAIN | 31 | 39.38 | -1,220.92 | 0 | 0.00 | Dec. 27, 2025: 31 @ 39.38 |
| Jan. 16, 2026 | issue | SO-260116-464 | MAIN | 17 | 39.38 | -669.54 | 31 | 1,220.92 | Dec. 27, 2025: 17 @ 39.38 |
| Jan. 1, 2026 | issue | SO-260101-934 | MAIN | 31 | 39.38 | -1,220.92 | 48 | 1,890.46 | Dec. 27, 2025: 31 @ 39.38 |
| Jan. 1, 2026 | issue | SO-260101-934 | EAST | 1 | 39.38 | -39.38 | 79 | 3,111.38 | Dec. 27, 2025: 1 @ 39.38 |
| Dec. 28, 2025 | issue | SO-251228-123 | MAIN | 3 | 39.91 | -119.72 | 80 | 3,150.76 | Oct. 24, 2025: 1 @ 40.95; Dec. 27, 2025: 2 @ 39.38 |
| Dec. 27, 2025 | receipt | PO-001095 | MAIN | 82 | 39.38 | 3,229.53 | 83 | 3,270.48 | |
| Dec. 24, 2025 | issue | SO-251224-504 | EAST | 17 | 40.95 | -696.21 | 1 | 40.95 | Oct. 24, 2025: 17 @ 40.95 |
| Dec. 22, 2025 | issue | SO-251222-901 | EAST | 2 | 40.95 | -81.91 | 18 | 737.16 | Oct. 24, 2025: 2 @ 40.95 |
| Dec. 22, 2025 | issue | SO-251222-901 | MAIN | 11 | 40.95 | -450.49 | 20 | 819.07 | Oct. 24, 2025: 11 @ 40.95 |
| Dec. 6, 2025 | issue | SO-251206-494 | MAIN | 5 | 40.95 | -204.77 | 31 | 1,269.55 | Oct. 24, 2025: 5 @ 40.95 |
| Dec. 4, 2025 | issue | SO-251204-138 | MAIN | 5 | 40.95 | -204.77 | 36 | 1,474.32 | Oct. 24, 2025: 5 @ 40.95 |
| Dec. 3, 2025 | issue | SO-251203-213 | MAIN | 20 | 40.95 | -819.07 | 41 | 1,679.09 | Oct. 24, 2025: 20 @ 40.95 |
| Nov. 24, 2025 | issue | SO-251124-274 | EAST | 1 | 40.95 | -40.95 | 61 | 2,498.15 | Oct. 24, 2025: 1 @ 40.95 |
| Nov. 18, 2025 | issue | SO-251118-866 | MAIN | 8 | 40.95 | -327.63 | 62 | 2,539.10 | Oct. 24, 2025: 8 @ 40.95 |