Items / MCB-0014
MCB 16A DP Flex MCB-0014 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)8MAIN 7, EAST 1
Value (FIFO)494.96avg 61.87
ClassCY / FCV 0.56
Turnover14.0xlast 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 | 11.83 / 30.4375 | 0.389 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.64 / 5.517 | 1.204 |
| 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.204^2 + 0.389^2 * 1.5^2) | 4.1 |
| Reorder point | d * LT + safety stock | 0.389 * 7.0 + 4.1 | 6.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 6.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 142/yr, S = 45.00, h = 20%, price = 62.10 | 32.1 |
| Inventory position | on hand + on order | 8 + 0 | 8 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 62.10 | 32 | 9,210 | yes (chosen if cheapest) |
MOQ 11, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 2, 2026 | 5 / 20 | 61.65 | 308.24 | |
| Sept. 7, 2026 | 3 / 3 | 62.24 | 186.73 |
Movement ledger 130 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-647 | EAST | 1 | 61.65 | -61.65 | 8 | 494.96 | Sept. 2, 2026: 1 @ 61.65 |
| Oct. 13, 2026 | issue | SO-261013-156 | MAIN | 4 | 61.65 | -246.59 | 9 | 556.61 | Sept. 2, 2026: 4 @ 61.65 |
| Sept. 30, 2026 | issue | SO-260930-942 | MAIN | 1 | 61.65 | -61.65 | 13 | 803.20 | Sept. 2, 2026: 1 @ 61.65 |
| Sept. 29, 2026 | issue | SO-260929-411 | MAIN | 4 | 61.65 | -246.59 | 14 | 864.85 | Sept. 2, 2026: 4 @ 61.65 |
| Sept. 25, 2026 | issue | SO-260925-868 | MAIN | 1 | 61.65 | -61.65 | 18 | 1,111.44 | Sept. 2, 2026: 1 @ 61.65 |
| Sept. 19, 2026 | issue | SO-260919-748 | EAST | 4 | 61.65 | -246.59 | 19 | 1,173.09 | Sept. 2, 2026: 4 @ 61.65 |
| Sept. 7, 2026 | return | RMA | MAIN | 3 | 62.24 | 186.73 | 23 | 1,419.68 | |
| Sept. 2, 2026 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| Sept. 2, 2026 | receipt | PO-001771 | MAIN | 20 | 61.65 | 1,232.96 | 20 | 1,232.96 | |
| Aug. 25, 2026 | issue | SO-260825-157 | MAIN | 10 | 62.24 | -622.42 | 0 | 0.00 | Aug. 5, 2026: 10 @ 62.24 |
| Aug. 22, 2026 | issue | SO-260822-630 | MAIN | 1 | 62.24 | -62.24 | 10 | 622.42 | Aug. 5, 2026: 1 @ 62.24 |
| Aug. 18, 2026 | issue | SO-260818-623 | MAIN | 7 | 62.24 | -435.69 | 11 | 684.66 | Aug. 5, 2026: 7 @ 62.24 |
| Aug. 11, 2026 | issue | SO-260811-175 | MAIN | 2 | 62.24 | -124.48 | 18 | 1,120.36 | Aug. 5, 2026: 2 @ 62.24 |
| Aug. 5, 2026 | receipt | PO-001697 | MAIN | 20 | 62.24 | 1,244.84 | 20 | 1,244.84 | |
| July 31, 2026 | issue | SO-260731-739 | MAIN | 5 | 59.84 | -299.22 | 0 | 0.00 | June 30, 2026: 5 @ 59.84 |
| July 18, 2026 | issue | SO-260718-153 | MAIN | 5 | 59.84 | -299.22 | 5 | 299.22 | June 30, 2026: 5 @ 59.84 |
| July 10, 2026 | issue | SO-260710-583 | MAIN | 3 | 59.84 | -179.53 | 10 | 598.44 | June 30, 2026: 3 @ 59.84 |
| June 30, 2026 | issue | SO-260630-660 | MAIN | 7 | 59.84 | -418.91 | 13 | 777.97 | June 30, 2026: 7 @ 59.84 |
| June 30, 2026 | receipt | PO-001614 | MAIN | 20 | 59.84 | 1,196.88 | 20 | 1,196.88 | |
| June 25, 2026 | issue | SO-260625-634 | MAIN | 4 | 62.94 | -251.75 | 0 | 0.00 | June 7, 2026: 4 @ 62.94 |
| June 24, 2026 | issue | SO-260624-508 | EAST | 6 | 62.94 | -377.63 | 4 | 251.75 | June 7, 2026: 6 @ 62.94 |
| June 15, 2026 | issue | SO-260615-233 | MAIN | 10 | 62.94 | -629.39 | 10 | 629.39 | June 7, 2026: 10 @ 62.94 |
| June 7, 2026 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| June 7, 2026 | receipt | PO-001556 | MAIN | 20 | 62.94 | 1,258.77 | 20 | 1,258.77 | |
| June 2, 2026 | issue | SO-260602-735 | MAIN | 3 | 61.29 | -183.87 | 0 | 0.00 | March 20, 2026: 3 @ 61.29 |
| May 30, 2026 | issue | SO-260530-950 | MAIN | 5 | 61.29 | -306.45 | 3 | 183.87 | March 20, 2026: 5 @ 61.29 |
| May 22, 2026 | issue | SO-260522-959 | MAIN | 1 | 61.29 | -61.29 | 8 | 490.32 | March 20, 2026: 1 @ 61.29 |
| May 17, 2026 | issue | SO-260517-203 | MAIN | 1 | 61.29 | -61.29 | 9 | 551.61 | March 20, 2026: 1 @ 61.29 |
| May 14, 2026 | issue | SO-260514-341 | MAIN | 2 | 61.29 | -122.58 | 10 | 612.90 | March 20, 2026: 2 @ 61.29 |
| May 1, 2026 | issue | SO-260501-215 | MAIN | 1 | 61.29 | -61.29 | 12 | 735.48 | March 20, 2026: 1 @ 61.29 |
| April 21, 2026 | issue | SO-260421-456 | MAIN | 3 | 61.29 | -183.87 | 13 | 796.77 | March 20, 2026: 3 @ 61.29 |
| April 16, 2026 | issue | SO-260416-408 | MAIN | 1 | 61.29 | -61.29 | 16 | 980.64 | March 20, 2026: 1 @ 61.29 |
| April 4, 2026 | issue | SO-260404-533 | MAIN | 1 | 61.29 | -61.29 | 17 | 1,041.93 | March 20, 2026: 1 @ 61.29 |
| April 3, 2026 | issue | SO-260403-286 | MAIN | 2 | 61.29 | -122.58 | 18 | 1,103.22 | March 20, 2026: 2 @ 61.29 |
| April 2, 2026 | issue | SO-260402-268 | MAIN | 1 | 61.34 | -61.34 | 20 | 1,225.80 | Jan. 31, 2026: 1 @ 61.34 |
| March 31, 2026 | issue | SO-260331-272 | MAIN | 2 | 61.34 | -122.68 | 21 | 1,287.14 | Jan. 31, 2026: 2 @ 61.34 |
| March 26, 2026 | issue | SO-260326-410 | MAIN | 1 | 61.34 | -61.34 | 23 | 1,409.83 | Jan. 31, 2026: 1 @ 61.34 |
| March 20, 2026 | receipt | PO-001338 | MAIN | 20 | 61.29 | 1,225.80 | 24 | 1,471.17 | |
| March 11, 2026 | issue | SO-260311-178 | MAIN | 1 | 61.34 | -61.34 | 4 | 245.37 | Jan. 31, 2026: 1 @ 61.34 |
| March 9, 2026 | issue | SO-260309-641 | MAIN | 2 | 61.34 | -122.68 | 5 | 306.71 | Jan. 31, 2026: 2 @ 61.34 |
| March 7, 2026 | issue | SO-260307-850 | MAIN | 4 | 61.34 | -245.37 | 7 | 429.39 | Jan. 31, 2026: 4 @ 61.34 |
| March 1, 2026 | issue | SO-260301-307 | MAIN | 3 | 61.34 | -184.03 | 11 | 674.76 | Jan. 31, 2026: 3 @ 61.34 |
| Feb. 20, 2026 | issue | SO-260220-166 | MAIN | 5 | 61.34 | -306.71 | 14 | 858.79 | Jan. 31, 2026: 5 @ 61.34 |
| Feb. 20, 2026 | issue | SO-260220-166 | EAST | 1 | 61.34 | -61.34 | 19 | 1,165.49 | Jan. 31, 2026: 1 @ 61.34 |
| Feb. 6, 2026 | issue | SO-260206-777 | MAIN | 1 | 60.72 | -60.72 | 20 | 1,226.84 | Oct. 31, 2025: 1 @ 60.72 |
| Jan. 31, 2026 | receipt | PO-001189 | MAIN | 20 | 61.34 | 1,226.84 | 21 | 1,287.55 | |
| Jan. 25, 2026 | issue | SO-260125-575 | EAST | 2 | 60.72 | -121.43 | 1 | 60.72 | Oct. 31, 2025: 2 @ 60.72 |
| Jan. 24, 2026 | issue | SO-260124-629 | EAST | 1 | 60.72 | -60.72 | 3 | 182.15 | Oct. 31, 2025: 1 @ 60.72 |
| Jan. 24, 2026 | issue | SO-260124-629 | MAIN | 1 | 60.72 | -60.72 | 4 | 242.87 | Oct. 31, 2025: 1 @ 60.72 |
| Jan. 22, 2026 | issue | SO-260122-432 | MAIN | 3 | 60.72 | -182.15 | 5 | 303.58 | Oct. 31, 2025: 3 @ 60.72 |
| Jan. 15, 2026 | issue | SO-260115-420 | MAIN | 1 | 60.72 | -60.72 | 8 | 485.74 | Oct. 31, 2025: 1 @ 60.72 |
| Jan. 13, 2026 | issue | SO-260113-669 | MAIN | 1 | 60.72 | -60.72 | 9 | 546.45 | Oct. 31, 2025: 1 @ 60.72 |
| Jan. 1, 2026 | issue | SO-260101-820 | MAIN | 1 | 60.72 | -60.72 | 10 | 607.17 | Oct. 31, 2025: 1 @ 60.72 |
| Dec. 19, 2025 | issue | SO-251219-748 | MAIN | 1 | 60.72 | -60.72 | 11 | 667.89 | Oct. 31, 2025: 1 @ 60.72 |
| Dec. 6, 2025 | issue | SO-251206-144 | MAIN | 3 | 60.72 | -182.15 | 12 | 728.60 | Oct. 31, 2025: 3 @ 60.72 |
| Dec. 2, 2025 | issue | SO-251202-737 | MAIN | 1 | 60.72 | -60.72 | 15 | 910.75 | Oct. 31, 2025: 1 @ 60.72 |
| Nov. 26, 2025 | issue | SO-251126-272 | MAIN | 1 | 60.72 | -60.72 | 16 | 971.47 | Oct. 31, 2025: 1 @ 60.72 |
| Nov. 17, 2025 | issue | SO-251117-281 | MAIN | 2 | 60.72 | -121.43 | 17 | 1,032.19 | Oct. 31, 2025: 2 @ 60.72 |
| Nov. 10, 2025 | issue | SO-251110-210 | MAIN | 2 | 59.18 | -118.36 | 19 | 1,153.62 | Sept. 17, 2025: 1 @ 57.65; Oct. 31, 2025: 1 @ 60.72 |
| Nov. 5, 2025 | issue | SO-251105-648 | MAIN | 1 | 57.65 | -57.65 | 21 | 1,271.98 | Sept. 17, 2025: 1 @ 57.65 |