Items / MCB-0017
Distribution Board 8-way Prime MCB-0017 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)60MAIN 60
Value (FIFO)1,609.75avg 26.83
ClassCX / FCV 0.33
Turnover9.2xlast issue 5 days ago
Days of cover51lead 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 | 35.75 / 30.4375 | 1.175 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 11.63 / 5.517 | 2.107 |
| 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 * 2.107^2 + 1.175^2 * 1.5^2) | 7.5 |
| Reorder point | d * LT + safety stock | 1.175 * 7.0 + 7.5 | 15.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 15.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 429/yr, S = 45.00, h = 20%, price = 26.12 | 85.9 |
| Inventory position | on hand + on order | 60 + 0 | 60 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 26.12 | 86 | 11,647 | yes (chosen if cheapest) |
MOQ 37, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 7, 2026 | 60 / 66 | 26.83 | 1,609.75 |
Movement ledger 129 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 11, 2026 | issue | SO-261011-697 | MAIN | 6 | 26.83 | -160.98 | 60 | 1,609.75 | Oct. 7, 2026: 6 @ 26.83 |
| Oct. 7, 2026 | receipt | PO-001856 | MAIN | 66 | 26.83 | 1,770.73 | 66 | 1,770.73 | |
| Sept. 29, 2026 | issue | SO-260929-482 | EAST | 1 | 25.96 | -25.96 | 0 | 0.00 | Aug. 7, 2026: 1 @ 25.96 |
| Sept. 29, 2026 | issue | SO-260929-482 | MAIN | 31 | 25.96 | -804.67 | 1 | 25.96 | Aug. 7, 2026: 31 @ 25.96 |
| Sept. 15, 2026 | issue | SO-260915-442 | MAIN | 13 | 25.96 | -337.44 | 32 | 830.62 | Aug. 7, 2026: 13 @ 25.96 |
| Aug. 27, 2026 | issue | SO-260827-544 | MAIN | 4 | 25.96 | -103.83 | 45 | 1,168.06 | Aug. 7, 2026: 4 @ 25.96 |
| Aug. 19, 2026 | issue | SO-260819-168 | EAST | 17 | 25.96 | -441.27 | 49 | 1,271.89 | Aug. 7, 2026: 17 @ 25.96 |
| Aug. 7, 2026 | transfer | TRF | MAIN → EAST | 18 | warehouse transfer, no cost effect | ||||
| Aug. 7, 2026 | receipt | PO-001703 | MAIN | 66 | 25.96 | 1,713.16 | 66 | 1,713.16 | |
| Aug. 2, 2026 | issue | SO-260802-405 | MAIN | 3 | 26.02 | -78.05 | 0 | 0.00 | May 29, 2026: 3 @ 26.02 |
| Aug. 1, 2026 | issue | SO-260801-563 | MAIN | 13 | 26.02 | -338.22 | 3 | 78.05 | May 29, 2026: 13 @ 26.02 |
| July 30, 2026 | issue | SO-260730-208 | MAIN | 9 | 26.02 | -234.15 | 16 | 416.27 | May 29, 2026: 9 @ 26.02 |
| July 26, 2026 | issue | SO-260726-280 | MAIN | 5 | 26.02 | -130.09 | 25 | 650.43 | May 29, 2026: 5 @ 26.02 |
| July 25, 2026 | issue | SO-260725-830 | MAIN | 8 | 26.02 | -208.14 | 30 | 780.51 | May 29, 2026: 8 @ 26.02 |
| July 20, 2026 | issue | SO-260720-561 | MAIN | 8 | 26.02 | -208.14 | 38 | 988.65 | May 29, 2026: 8 @ 26.02 |
| July 19, 2026 | issue | SO-260719-954 | MAIN | 5 | 26.02 | -130.09 | 46 | 1,196.79 | May 29, 2026: 5 @ 26.02 |
| July 14, 2026 | issue | SO-260714-211 | MAIN | 1 | 26.02 | -26.02 | 51 | 1,326.87 | May 29, 2026: 1 @ 26.02 |
| July 10, 2026 | issue | SO-260710-670 | MAIN | 8 | 26.02 | -208.14 | 52 | 1,352.89 | May 29, 2026: 8 @ 26.02 |
| June 21, 2026 | issue | SO-260621-254 | MAIN | 2 | 26.02 | -52.03 | 60 | 1,561.03 | May 29, 2026: 2 @ 26.02 |
| June 19, 2026 | issue | SO-260619-131 | MAIN | 3 | 26.02 | -78.05 | 62 | 1,613.06 | May 29, 2026: 3 @ 26.02 |
| June 16, 2026 | issue | SO-260616-794 | MAIN | 1 | 26.02 | -26.02 | 65 | 1,691.11 | May 29, 2026: 1 @ 26.02 |
| June 15, 2026 | issue | SO-260615-916 | MAIN | 10 | 25.89 | -258.91 | 66 | 1,717.13 | April 30, 2026: 10 @ 25.89 |
| June 10, 2026 | issue | SO-260610-531 | MAIN | 5 | 25.89 | -129.45 | 76 | 1,976.04 | April 30, 2026: 5 @ 25.89 |
| June 9, 2026 | issue | SO-260609-982 | MAIN | 1 | 25.89 | -25.89 | 81 | 2,105.49 | April 30, 2026: 1 @ 25.89 |
| May 29, 2026 | receipt | PO-001532 | MAIN | 66 | 26.02 | 1,717.13 | 82 | 2,131.38 | |
| May 24, 2026 | issue | SO-260524-847 | MAIN | 10 | 25.89 | -258.91 | 16 | 414.25 | April 30, 2026: 10 @ 25.89 |
| May 10, 2026 | issue | SO-260510-769 | MAIN | 40 | 25.89 | -1,035.63 | 26 | 673.16 | April 30, 2026: 40 @ 25.89 |
| April 30, 2026 | receipt | PO-001454 | MAIN | 66 | 25.89 | 1,708.79 | 66 | 1,708.79 | |
| April 23, 2026 | issue | SO-260423-729 | MAIN | 32 | 25.54 | -817.22 | 0 | 0.00 | March 5, 2026: 32 @ 25.54 |
| March 27, 2026 | issue | SO-260327-129 | MAIN | 11 | 25.54 | -280.92 | 32 | 817.22 | March 5, 2026: 11 @ 25.54 |
| March 25, 2026 | issue | SO-260325-445 | MAIN | 5 | 25.54 | -127.69 | 43 | 1,098.13 | March 5, 2026: 5 @ 25.54 |
| March 15, 2026 | issue | SO-260315-758 | MAIN | 12 | 25.54 | -306.46 | 48 | 1,225.82 | March 5, 2026: 12 @ 25.54 |
| March 7, 2026 | issue | SO-260307-655 | MAIN | 6 | 25.54 | -153.23 | 60 | 1,532.28 | March 5, 2026: 6 @ 25.54 |
| March 5, 2026 | receipt | PO-001289 | MAIN | 66 | 25.54 | 1,685.51 | 66 | 1,685.51 | |
| Feb. 25, 2026 | issue | SO-260225-620 | MAIN | 28 | 25.01 | -700.28 | 0 | 0.00 | Dec. 18, 2025: 28 @ 25.01 |
| Jan. 31, 2026 | issue | SO-260131-694 | MAIN | 17 | 25.01 | -425.17 | 28 | 700.28 | Dec. 18, 2025: 17 @ 25.01 |
| Jan. 20, 2026 | issue | SO-260120-245 | MAIN | 4 | 25.01 | -100.04 | 45 | 1,125.45 | Dec. 18, 2025: 4 @ 25.01 |
| Jan. 20, 2026 | issue | SO-260120-245 | EAST | 5 | 25.01 | -125.05 | 49 | 1,225.49 | Dec. 18, 2025: 5 @ 25.01 |
| Jan. 19, 2026 | issue | SO-260119-402 | MAIN | 1 | 25.01 | -25.01 | 54 | 1,350.55 | Dec. 18, 2025: 1 @ 25.01 |
| Jan. 13, 2026 | issue | SO-260113-880 | MAIN | 10 | 25.01 | -250.10 | 55 | 1,375.56 | Dec. 18, 2025: 10 @ 25.01 |
| Jan. 3, 2026 | issue | SO-260103-581 | MAIN | 3 | 25.03 | -75.09 | 65 | 1,625.66 | Oct. 24, 2025: 2 @ 25.04; Dec. 18, 2025: 1 @ 25.01 |
| Dec. 27, 2025 | issue | SO-251227-177 | MAIN | 14 | 25.04 | -350.55 | 68 | 1,700.75 | Oct. 24, 2025: 14 @ 25.04 |
| Dec. 19, 2025 | issue | SO-251219-925 | MAIN | 1 | 25.04 | -25.04 | 82 | 2,051.30 | Oct. 24, 2025: 1 @ 25.04 |
| Dec. 18, 2025 | receipt | PO-001064 | MAIN | 66 | 25.01 | 1,650.67 | 83 | 2,076.34 | |
| Dec. 12, 2025 | issue | SO-251212-317 | MAIN | 4 | 25.04 | -100.16 | 17 | 425.67 | Oct. 24, 2025: 4 @ 25.04 |
| Dec. 9, 2025 | issue | SO-251209-232 | MAIN | 2 | 25.04 | -50.08 | 21 | 525.83 | Oct. 24, 2025: 2 @ 25.04 |
| Dec. 8, 2025 | issue | SO-251208-426 | EAST | 18 | 25.04 | -450.71 | 23 | 575.91 | Oct. 24, 2025: 18 @ 25.04 |
| Dec. 4, 2025 | issue | SO-251204-573 | MAIN | 11 | 25.04 | -275.44 | 41 | 1,026.62 | Oct. 24, 2025: 11 @ 25.04 |
| Dec. 2, 2025 | issue | SO-251202-204 | MAIN | 7 | 25.04 | -175.28 | 52 | 1,302.06 | Oct. 24, 2025: 7 @ 25.04 |
| Nov. 21, 2025 | issue | SO-251121-318 | MAIN | 4 | 25.04 | -100.16 | 59 | 1,477.34 | Oct. 24, 2025: 4 @ 25.04 |
| Nov. 13, 2025 | issue | SO-251113-313 | MAIN | 4 | 24.89 | -99.56 | 63 | 1,577.49 | Sept. 2, 2025: 1 @ 24.44; Oct. 24, 2025: 3 @ 25.04 |
| Nov. 7, 2025 | issue | SO-251107-961 | EAST | 8 | 24.44 | -195.54 | 67 | 1,677.06 | Sept. 2, 2025: 8 @ 24.44 |
| Oct. 24, 2025 | transfer | TRF | MAIN → EAST | 22 | warehouse transfer, no cost effect | ||||
| Oct. 24, 2025 | receipt | PO-000947 | MAIN | 66 | 25.04 | 1,652.61 | 75 | 1,872.59 | |
| Oct. 17, 2025 | issue | SO-251017-477 | EAST | 14 | 24.44 | -342.19 | 9 | 219.98 | Sept. 2, 2025: 14 @ 24.44 |
| Oct. 17, 2025 | issue | SO-251017-477 | MAIN | 10 | 24.44 | -244.42 | 23 | 562.17 | Sept. 2, 2025: 10 @ 24.44 |
| Sept. 24, 2025 | issue | SO-250924-750 | MAIN | 25 | 24.44 | -611.05 | 33 | 806.59 | Sept. 2, 2025: 25 @ 24.44 |
| Sept. 7, 2025 | issue | SO-250907-722 | MAIN | 9 | 24.53 | -220.73 | 58 | 1,417.64 | July 20, 2025: 1 @ 25.19; Sept. 2, 2025: 8 @ 24.44 |
| Sept. 2, 2025 | transfer | TRF | MAIN → EAST | 23 | warehouse transfer, no cost effect | ||||
| Sept. 2, 2025 | receipt | PO-000811 | MAIN | 66 | 24.44 | 1,613.17 | 67 | 1,638.36 | |