Items / MCB-0027
RCCB 40A Elite MCB-0027 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)59MAIN 59
Value (FIFO)1,376.26avg 23.33
ClassBX / FCV 0.45
Turnover20.2xlast issue 0 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 | 86.33 / 30.4375 | 2.836 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 38.79 / 5.517 | 7.031 |
| 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 * 7.031^2 + 2.836^2 * 1.5^2) | 31.4 |
| Reorder point | d * LT + safety stock | 2.836 * 7.0 + 31.4 | 51.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 51.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1035/yr, S = 45.00, h = 20%, price = 22.90 | 142.6 |
| Inventory position | on hand + on order | 59 + 0 | 59 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 22.90 | 143 | 24,361 | yes (chosen if cheapest) |
MOQ 63, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 7, 2026 | 59 / 113 | 23.33 | 1,376.26 |
Movement ledger 139 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-578 | MAIN | 19 | 23.33 | -443.20 | 59 | 1,376.26 | Sept. 7, 2026: 19 @ 23.33 |
| Oct. 14, 2026 | issue | SO-261014-970 | MAIN | 5 | 23.33 | -116.63 | 78 | 1,819.46 | Sept. 7, 2026: 5 @ 23.33 |
| Oct. 7, 2026 | issue | SO-261007-981 | MAIN | 5 | 23.33 | -116.63 | 83 | 1,936.09 | Sept. 7, 2026: 5 @ 23.33 |
| Sept. 25, 2026 | issue | SO-260925-197 | MAIN | 15 | 23.33 | -349.90 | 88 | 2,052.72 | Sept. 7, 2026: 15 @ 23.33 |
| Sept. 20, 2026 | issue | SO-260920-682 | MAIN | 16 | 22.80 | -364.84 | 103 | 2,402.62 | June 27, 2026: 6 @ 21.93; Sept. 7, 2026: 10 @ 23.33 |
| Sept. 12, 2026 | issue | SO-260912-125 | MAIN | 2 | 21.93 | -43.86 | 119 | 2,767.46 | June 27, 2026: 2 @ 21.93 |
| Sept. 9, 2026 | issue | SO-260909-708 | MAIN | 2 | 21.93 | -43.86 | 121 | 2,811.32 | June 27, 2026: 2 @ 21.93 |
| Sept. 7, 2026 | receipt | PO-001780 | MAIN | 113 | 23.33 | 2,635.88 | 123 | 2,855.18 | |
| Sept. 3, 2026 | issue | SO-260903-878 | MAIN | 16 | 21.93 | -350.88 | 10 | 219.30 | June 27, 2026: 16 @ 21.93 |
| Aug. 30, 2026 | issue | SO-260830-490 | MAIN | 16 | 21.93 | -350.88 | 26 | 570.17 | June 27, 2026: 16 @ 21.93 |
| Aug. 25, 2026 | issue | SO-260825-224 | MAIN | 1 | 21.93 | -21.93 | 42 | 921.05 | June 27, 2026: 1 @ 21.93 |
| Aug. 23, 2026 | issue | SO-260823-741 | MAIN | 5 | 21.93 | -109.65 | 43 | 942.98 | June 27, 2026: 5 @ 21.93 |
| Aug. 15, 2026 | issue | SO-260815-311 | MAIN | 6 | 21.93 | -131.58 | 48 | 1,052.63 | June 27, 2026: 6 @ 21.93 |
| Aug. 13, 2026 | issue | SO-260813-358 | MAIN | 2 | 21.93 | -43.86 | 54 | 1,184.21 | June 27, 2026: 2 @ 21.93 |
| Aug. 11, 2026 | issue | SO-260811-458 | MAIN | 1 | 21.93 | -21.93 | 56 | 1,228.07 | June 27, 2026: 1 @ 21.93 |
| July 10, 2026 | issue | SO-260710-682 | MAIN | 22 | 21.93 | -482.46 | 57 | 1,250.00 | June 27, 2026: 22 @ 21.93 |
| July 10, 2026 | issue | SO-260710-682 | EAST | 9 | 21.93 | -197.37 | 79 | 1,732.45 | June 27, 2026: 9 @ 21.93 |
| July 9, 2026 | issue | SO-260709-639 | EAST | 30 | 22.02 | -660.64 | 88 | 1,929.82 | May 21, 2026: 5 @ 22.48; June 27, 2026: 25 @ 21.93 |
| July 1, 2026 | issue | SO-260701-557 | MAIN | 16 | 22.48 | -359.65 | 118 | 2,590.46 | May 21, 2026: 16 @ 22.48 |
| June 27, 2026 | transfer | TRF | MAIN → EAST | 39 | warehouse transfer, no cost effect | ||||
| June 27, 2026 | receipt | PO-001606 | MAIN | 113 | 21.93 | 2,478.07 | 134 | 2,950.11 | |
| June 24, 2026 | issue | SO-260624-289 | MAIN | 1 | 22.48 | -22.48 | 21 | 472.04 | May 21, 2026: 1 @ 22.48 |
| June 21, 2026 | issue | SO-260621-746 | MAIN | 22 | 22.48 | -494.52 | 22 | 494.52 | May 21, 2026: 22 @ 22.48 |
| June 20, 2026 | issue | SO-260620-432 | MAIN | 7 | 22.48 | -157.35 | 44 | 989.03 | May 21, 2026: 7 @ 22.48 |
| June 19, 2026 | issue | SO-260619-991 | MAIN | 7 | 22.48 | -157.35 | 51 | 1,146.38 | May 21, 2026: 7 @ 22.48 |
| June 12, 2026 | issue | SO-260612-291 | MAIN | 14 | 22.48 | -314.69 | 58 | 1,303.72 | May 21, 2026: 14 @ 22.48 |
| June 5, 2026 | issue | SO-260605-873 | MAIN | 42 | 22.46 | -943.50 | 72 | 1,618.42 | May 7, 2026: 1 @ 21.90; May 21, 2026: 41 @ 22.48 |
| May 21, 2026 | receipt | PO-001515 | MAIN | 113 | 22.48 | 2,540.01 | 114 | 2,561.92 | |
| May 17, 2026 | issue | SO-260517-702 | MAIN | 112 | 21.90 | -2,453.35 | 1 | 21.90 | May 7, 2026: 112 @ 21.90 |
| May 7, 2026 | receipt | PO-001475 | MAIN | 113 | 21.90 | 2,475.25 | 113 | 2,475.25 | |
| May 2, 2026 | issue | SO-260502-732 | MAIN | 55 | 21.82 | -1,199.85 | 0 | 0.00 | March 27, 2026: 55 @ 21.82 |
| April 15, 2026 | issue | SO-260415-199 | MAIN | 46 | 21.82 | -1,003.51 | 55 | 1,199.85 | March 27, 2026: 46 @ 21.82 |
| April 9, 2026 | issue | SO-260409-305 | MAIN | 18 | 22.12 | -398.25 | 101 | 2,203.37 | March 12, 2026: 6 @ 22.74; March 27, 2026: 12 @ 21.82 |
| March 27, 2026 | receipt | PO-001361 | MAIN | 113 | 21.82 | 2,465.15 | 119 | 2,601.61 | |
| March 21, 2026 | issue | SO-260321-548 | MAIN | 13 | 22.74 | -295.67 | 6 | 136.46 | March 12, 2026: 13 @ 22.74 |
| March 21, 2026 | issue | SO-260321-548 | EAST | 1 | 22.74 | -22.74 | 19 | 432.13 | March 12, 2026: 1 @ 22.74 |
| March 19, 2026 | issue | SO-260319-969 | MAIN | 15 | 22.74 | -341.16 | 20 | 454.88 | March 12, 2026: 15 @ 22.74 |
| March 16, 2026 | issue | SO-260316-476 | MAIN | 74 | 22.74 | -1,683.04 | 35 | 796.03 | March 12, 2026: 74 @ 22.74 |
| March 13, 2026 | issue | SO-260313-339 | MAIN | 5 | 22.61 | -113.04 | 109 | 2,479.07 | Jan. 16, 2026: 1 @ 22.07; March 12, 2026: 4 @ 22.74 |
| March 12, 2026 | receipt | PO-001310 | MAIN | 113 | 22.74 | 2,570.05 | 114 | 2,592.12 | |
| March 9, 2026 | issue | SO-260309-864 | EAST | 5 | 22.07 | -110.35 | 1 | 22.07 | Jan. 16, 2026: 5 @ 22.07 |
| March 9, 2026 | issue | SO-260309-864 | MAIN | 14 | 22.07 | -308.98 | 6 | 132.42 | Jan. 16, 2026: 14 @ 22.07 |
| March 8, 2026 | issue | SO-260308-742 | MAIN | 2 | 22.07 | -44.14 | 20 | 441.40 | Jan. 16, 2026: 2 @ 22.07 |
| March 3, 2026 | issue | SO-260303-510 | MAIN | 23 | 22.07 | -507.61 | 22 | 485.54 | Jan. 16, 2026: 23 @ 22.07 |
| Feb. 26, 2026 | issue | SO-260226-938 | MAIN | 23 | 22.07 | -507.61 | 45 | 993.14 | Jan. 16, 2026: 23 @ 22.07 |
| Feb. 21, 2026 | issue | SO-260221-485 | EAST | 21 | 22.07 | -463.47 | 68 | 1,500.75 | Jan. 16, 2026: 21 @ 22.07 |
| Feb. 9, 2026 | issue | SO-260209-909 | MAIN | 26 | 22.05 | -573.33 | 89 | 1,964.21 | Nov. 30, 2025: 2 @ 21.83; Jan. 16, 2026: 24 @ 22.07 |
| Feb. 4, 2026 | issue | SO-260204-468 | MAIN | 7 | 21.83 | -152.81 | 115 | 2,537.55 | Nov. 30, 2025: 7 @ 21.83 |
| Feb. 3, 2026 | issue | SO-260203-575 | MAIN | 7 | 21.83 | -152.81 | 122 | 2,690.35 | Nov. 30, 2025: 7 @ 21.83 |
| Jan. 18, 2026 | issue | SO-260118-188 | MAIN | 11 | 21.83 | -240.13 | 129 | 2,843.16 | Nov. 30, 2025: 11 @ 21.83 |
| Jan. 16, 2026 | receipt | PO-001149 | MAIN | 113 | 22.07 | 2,493.89 | 140 | 3,083.29 | |
| Jan. 7, 2026 | issue | SO-260107-840 | MAIN | 29 | 21.83 | -633.06 | 27 | 589.40 | Nov. 30, 2025: 29 @ 21.83 |
| Jan. 4, 2026 | issue | SO-260104-806 | EAST | 10 | 21.83 | -218.30 | 56 | 1,222.46 | Nov. 30, 2025: 10 @ 21.83 |
| Dec. 25, 2025 | issue | SO-251225-117 | MAIN | 1 | 21.83 | -21.83 | 66 | 1,440.76 | Nov. 30, 2025: 1 @ 21.83 |
| Dec. 24, 2025 | issue | SO-251224-923 | MAIN | 5 | 21.83 | -109.15 | 67 | 1,462.59 | Nov. 30, 2025: 5 @ 21.83 |
| Dec. 23, 2025 | issue | SO-251223-504 | MAIN | 9 | 21.83 | -196.47 | 72 | 1,571.74 | Nov. 30, 2025: 9 @ 21.83 |
| Dec. 22, 2025 | issue | SO-251222-758 | MAIN | 38 | 21.89 | -831.78 | 81 | 1,768.21 | Oct. 31, 2025: 6 @ 22.20; Nov. 30, 2025: 32 @ 21.83 |
| Dec. 16, 2025 | issue | SO-251216-236 | MAIN | 11 | 22.20 | -244.25 | 119 | 2,599.98 | Oct. 31, 2025: 11 @ 22.20 |
| Nov. 30, 2025 | transfer | TRF | MAIN → EAST | 37 | warehouse transfer, no cost effect | ||||
| Nov. 30, 2025 | receipt | PO-001028 | MAIN | 113 | 21.83 | 2,466.76 | 130 | 2,844.23 | |