Items / MCB-0028
RCCB 40A Classic MCB-0028 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)124MAIN 124
Value (FIFO)3,900.64avg 31.46
ClassBX / FCV 0.27
Turnover5.6xlast issue 2 days ago
Days of cover73lead 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.83 / 30.4375 | 1.703 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 13.86 / 5.517 | 2.511 |
| 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 * 2.511^2 + 1.703^2 * 1.5^2) | 11.7 |
| Reorder point | d * LT + safety stock | 1.703 * 7.0 + 11.7 | 23.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 23.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 622/yr, S = 45.00, h = 20%, price = 31.54 | 94.2 |
| Inventory position | on hand + on order | 124 + 0 | 124 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 31.54 | 94 | 20,198 | yes (chosen if cheapest) |
MOQ 63, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 13, 2026 | 11 / 12 | 30.87 | 339.59 | |
| Oct. 14, 2026 | 113 / 113 | 31.51 | 3,561.06 |
Movement ledger 123 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-916 | MAIN | 1 | 30.87 | -30.87 | 124 | 3,900.64 | Oct. 13, 2026: 1 @ 30.87 |
| Oct. 14, 2026 | receipt | PO-001879 | MAIN | 113 | 31.51 | 3,561.06 | 125 | 3,931.52 | |
| Oct. 13, 2026 | return | RMA | MAIN | 12 | 30.87 | 370.46 | 12 | 370.46 | |
| Oct. 5, 2026 | issue | SO-261005-779 | MAIN | 35 | 30.87 | -1,080.50 | 0 | 0.00 | Aug. 2, 2026: 35 @ 30.87 |
| Oct. 1, 2026 | issue | SO-261001-510 | MAIN | 25 | 30.87 | -771.78 | 35 | 1,080.50 | Aug. 2, 2026: 25 @ 30.87 |
| Sept. 28, 2026 | issue | SO-260928-982 | MAIN | 3 | 30.87 | -92.61 | 60 | 1,852.28 | Aug. 2, 2026: 3 @ 30.87 |
| Sept. 20, 2026 | issue | SO-260920-212 | MAIN | 21 | 30.87 | -648.30 | 63 | 1,944.90 | Aug. 2, 2026: 21 @ 30.87 |
| Sept. 14, 2026 | issue | SO-260914-294 | MAIN | 3 | 30.87 | -92.61 | 84 | 2,593.20 | Aug. 2, 2026: 3 @ 30.87 |
| Sept. 5, 2026 | issue | SO-260905-209 | MAIN | 11 | 30.87 | -339.59 | 87 | 2,685.81 | Aug. 2, 2026: 11 @ 30.87 |
| Sept. 1, 2026 | issue | SO-260901-128 | MAIN | 2 | 30.87 | -61.74 | 98 | 3,025.40 | Aug. 2, 2026: 2 @ 30.87 |
| Aug. 17, 2026 | issue | SO-260817-421 | MAIN | 22 | 30.84 | -678.57 | 100 | 3,087.14 | May 20, 2026: 9 @ 30.81; Aug. 2, 2026: 13 @ 30.87 |
| Aug. 17, 2026 | issue | SO-260817-421 | EAST | 4 | 30.81 | -123.22 | 122 | 3,765.71 | May 20, 2026: 4 @ 30.81 |
| Aug. 2, 2026 | receipt | PO-001693 | MAIN | 113 | 30.87 | 3,488.47 | 126 | 3,888.93 | |
| Aug. 1, 2026 | issue | SO-260801-129 | MAIN | 10 | 30.81 | -308.05 | 13 | 400.47 | May 20, 2026: 10 @ 30.81 |
| July 27, 2026 | issue | SO-260727-708 | MAIN | 6 | 30.81 | -184.83 | 23 | 708.52 | May 20, 2026: 6 @ 30.81 |
| July 26, 2026 | issue | SO-260726-350 | MAIN | 15 | 30.81 | -462.08 | 29 | 893.35 | May 20, 2026: 15 @ 30.81 |
| July 24, 2026 | issue | SO-260724-834 | MAIN | 4 | 30.81 | -123.22 | 44 | 1,355.42 | May 20, 2026: 4 @ 30.81 |
| July 19, 2026 | issue | SO-260719-280 | MAIN | 4 | 30.81 | -123.22 | 48 | 1,478.64 | May 20, 2026: 4 @ 30.81 |
| July 18, 2026 | issue | SO-260718-122 | EAST | 1 | 30.81 | -30.81 | 52 | 1,601.87 | May 20, 2026: 1 @ 30.81 |
| July 5, 2026 | issue | SO-260705-934 | MAIN | 14 | 30.81 | -431.27 | 53 | 1,632.67 | May 20, 2026: 14 @ 30.81 |
| June 30, 2026 | issue | SO-260630-779 | MAIN | 21 | 30.81 | -646.91 | 67 | 2,063.94 | May 20, 2026: 21 @ 30.81 |
| June 29, 2026 | issue | SO-260629-858 | EAST | 19 | 30.81 | -585.30 | 88 | 2,710.85 | May 20, 2026: 19 @ 30.81 |
| June 24, 2026 | issue | SO-260624-575 | MAIN | 16 | 30.73 | -491.73 | 107 | 3,296.15 | March 23, 2026: 10 @ 30.69; May 20, 2026: 6 @ 30.81 |
| May 20, 2026 | transfer | TRF | MAIN → EAST | 24 | warehouse transfer, no cost effect | ||||
| May 20, 2026 | receipt | PO-001513 | MAIN | 113 | 30.81 | 3,480.98 | 123 | 3,787.88 | |
| May 19, 2026 | issue | SO-260519-351 | MAIN | 1 | 30.69 | -30.69 | 10 | 306.90 | March 23, 2026: 1 @ 30.69 |
| May 15, 2026 | issue | SO-260515-308 | MAIN | 50 | 30.69 | -1,534.50 | 11 | 337.59 | March 23, 2026: 50 @ 30.69 |
| April 25, 2026 | issue | SO-260425-930 | MAIN | 26 | 30.69 | -797.94 | 61 | 1,872.08 | March 23, 2026: 26 @ 30.69 |
| April 20, 2026 | issue | SO-260420-309 | MAIN | 15 | 30.69 | -460.35 | 87 | 2,670.02 | March 23, 2026: 15 @ 30.69 |
| April 18, 2026 | issue | SO-260418-756 | MAIN | 15 | 30.89 | -463.31 | 102 | 3,130.37 | Feb. 5, 2026: 4 @ 31.43; March 23, 2026: 11 @ 30.69 |
| April 1, 2026 | issue | SO-260401-437 | MAIN | 7 | 31.43 | -220.02 | 117 | 3,593.68 | Feb. 5, 2026: 7 @ 31.43 |
| March 26, 2026 | issue | SO-260326-669 | MAIN | 3 | 31.43 | -94.29 | 124 | 3,813.70 | Feb. 5, 2026: 3 @ 31.43 |
| March 23, 2026 | receipt | PO-001345 | MAIN | 113 | 30.69 | 3,467.96 | 127 | 3,907.99 | |
| March 16, 2026 | issue | SO-260316-122 | MAIN | 5 | 31.43 | -157.16 | 14 | 440.04 | Feb. 5, 2026: 5 @ 31.43 |
| March 16, 2026 | issue | SO-260316-122 | EAST | 29 | 31.43 | -911.50 | 19 | 597.19 | Feb. 5, 2026: 29 @ 31.43 |
| March 6, 2026 | issue | SO-260306-403 | MAIN | 39 | 31.43 | -1,225.81 | 48 | 1,508.69 | Feb. 5, 2026: 39 @ 31.43 |
| Feb. 26, 2026 | issue | SO-260226-824 | EAST | 4 | 31.43 | -125.72 | 87 | 2,734.51 | Feb. 5, 2026: 4 @ 31.43 |
| Feb. 25, 2026 | issue | SO-260225-486 | MAIN | 1 | 31.43 | -31.43 | 91 | 2,860.23 | Feb. 5, 2026: 1 @ 31.43 |
| Feb. 22, 2026 | issue | SO-260222-241 | MAIN | 18 | 31.43 | -565.76 | 92 | 2,891.66 | Feb. 5, 2026: 18 @ 31.43 |
| Feb. 13, 2026 | issue | SO-260213-788 | MAIN | 2 | 31.43 | -62.86 | 110 | 3,457.42 | Feb. 5, 2026: 2 @ 31.43 |
| Feb. 5, 2026 | issue | SO-260205-464 | MAIN | 1 | 31.43 | -31.43 | 112 | 3,520.28 | Feb. 5, 2026: 1 @ 31.43 |
| Feb. 5, 2026 | transfer | TRF | MAIN → EAST | 33 | warehouse transfer, no cost effect | ||||
| Feb. 5, 2026 | receipt | PO-001199 | MAIN | 113 | 31.43 | 3,551.71 | 113 | 3,551.71 | |
| Jan. 29, 2026 | issue | SO-260129-471 | MAIN | 60 | 30.15 | -1,809.07 | 0 | 0.00 | Nov. 26, 2025: 60 @ 30.15 |
| Jan. 26, 2026 | issue | SO-260126-554 | MAIN | 6 | 30.15 | -180.91 | 60 | 1,809.07 | Nov. 26, 2025: 6 @ 30.15 |
| Dec. 29, 2025 | issue | SO-251229-824 | MAIN | 1 | 30.15 | -30.15 | 66 | 1,989.97 | Nov. 26, 2025: 1 @ 30.15 |
| Dec. 14, 2025 | issue | SO-251214-922 | MAIN | 17 | 30.15 | -512.57 | 67 | 2,020.12 | Nov. 26, 2025: 17 @ 30.15 |
| Dec. 9, 2025 | issue | SO-251209-490 | MAIN | 3 | 30.15 | -90.45 | 84 | 2,532.69 | Nov. 26, 2025: 3 @ 30.15 |
| Dec. 7, 2025 | issue | SO-251207-805 | MAIN | 13 | 30.15 | -391.96 | 87 | 2,623.15 | Nov. 26, 2025: 13 @ 30.15 |
| Dec. 6, 2025 | issue | SO-251206-579 | MAIN | 1 | 30.15 | -30.15 | 100 | 3,015.11 | Nov. 26, 2025: 1 @ 30.15 |
| Dec. 5, 2025 | issue | SO-251205-785 | MAIN | 6 | 30.15 | -180.91 | 101 | 3,045.26 | Nov. 26, 2025: 6 @ 30.15 |
| Dec. 1, 2025 | issue | SO-251201-236 | MAIN | 6 | 30.15 | -180.91 | 107 | 3,226.17 | Nov. 26, 2025: 6 @ 30.15 |
| Nov. 26, 2025 | receipt | PO-001020 | MAIN | 113 | 30.15 | 3,407.07 | 113 | 3,407.07 | |
| Nov. 20, 2025 | issue | SO-251120-278 | MAIN | 43 | 30.98 | -1,332.26 | 0 | 0.00 | Sept. 23, 2025: 43 @ 30.98 |
| Nov. 12, 2025 | issue | SO-251112-741 | MAIN | 1 | 30.98 | -30.98 | 43 | 1,332.26 | Sept. 23, 2025: 1 @ 30.98 |
| Nov. 10, 2025 | issue | SO-251110-873 | MAIN | 6 | 30.98 | -185.90 | 44 | 1,363.24 | Sept. 23, 2025: 6 @ 30.98 |
| Oct. 30, 2025 | issue | SO-251030-186 | MAIN | 30 | 30.98 | -929.48 | 50 | 1,549.14 | Sept. 23, 2025: 30 @ 30.98 |
| Oct. 30, 2025 | issue | SO-251030-186 | EAST | 23 | 30.98 | -712.60 | 80 | 2,478.62 | Sept. 23, 2025: 23 @ 30.98 |
| Oct. 28, 2025 | issue | SO-251028-117 | MAIN | 12 | 30.73 | -368.70 | 103 | 3,191.22 | July 27, 2025: 2 @ 29.44; Sept. 23, 2025: 10 @ 30.98 |
| Oct. 14, 2025 | issue | SO-251014-821 | MAIN | 2 | 29.44 | -58.88 | 115 | 3,559.92 | July 27, 2025: 2 @ 29.44 |