Items / MCB-0033
MCB 32A TP Nova MCB-0033 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)37MAIN 33, EAST 4
Value (FIFO)1,664.73avg 44.99
ClassBX / FCV 0.29
Turnover9.4xlast issue 4 days ago
Days of cover38lead 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 | 29.75 / 30.4375 | 0.977 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 8.55 / 5.517 | 1.549 |
| 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 * 1.549^2 + 0.977^2 * 1.5^2) | 7.2 |
| Reorder point | d * LT + safety stock | 0.977 * 7.0 + 7.2 | 14.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 14.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 357/yr, S = 45.00, h = 20%, price = 44.99 | 59.7 |
| Inventory position | on hand + on order | 37 + 0 | 37 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 44.99 | 60 | 16,588 | yes (chosen if cheapest) |
MOQ 29, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 8, 2026 | 37 / 53 | 44.99 | 1,664.73 |
Movement ledger 144 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-174 | EAST | 8 | 44.99 | -359.94 | 37 | 1,664.73 | Oct. 8, 2026: 8 @ 44.99 |
| Oct. 11, 2026 | issue | SO-261011-740 | MAIN | 4 | 44.99 | -179.97 | 45 | 2,024.67 | Oct. 8, 2026: 4 @ 44.99 |
| Oct. 10, 2026 | issue | SO-261010-966 | EAST | 1 | 44.99 | -44.99 | 49 | 2,204.64 | Oct. 8, 2026: 1 @ 44.99 |
| Oct. 8, 2026 | issue | SO-261008-809 | MAIN | 3 | 44.99 | -134.98 | 50 | 2,249.63 | Oct. 8, 2026: 3 @ 44.99 |
| Oct. 8, 2026 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| Oct. 8, 2026 | receipt | PO-001861 | MAIN | 53 | 44.99 | 2,384.61 | 53 | 2,384.61 | |
| Oct. 6, 2026 | issue | SO-261006-922 | EAST | 8 | 44.38 | -355.05 | 0 | 0.00 | Aug. 16, 2026: 8 @ 44.38 |
| Oct. 5, 2026 | issue | SO-261005-940 | EAST | 1 | 44.38 | -44.38 | 8 | 355.05 | Aug. 16, 2026: 1 @ 44.38 |
| Oct. 1, 2026 | issue | SO-261001-777 | EAST | 6 | 43.48 | -260.90 | 9 | 399.44 | Aug. 9, 2026: 6 @ 43.48 |
| Oct. 1, 2026 | issue | SO-261001-777 | MAIN | 4 | 43.48 | -173.93 | 15 | 660.33 | Aug. 9, 2026: 4 @ 43.48 |
| Sept. 24, 2026 | issue | SO-260924-786 | MAIN | 6 | 43.48 | -260.90 | 19 | 834.26 | Aug. 9, 2026: 6 @ 43.48 |
| Sept. 22, 2026 | issue | SO-260922-219 | MAIN | 31 | 43.48 | -1,347.97 | 25 | 1,095.16 | Aug. 9, 2026: 31 @ 43.48 |
| Sept. 11, 2026 | issue | SO-260911-982 | MAIN | 1 | 43.48 | -43.48 | 56 | 2,443.13 | Aug. 9, 2026: 1 @ 43.48 |
| Aug. 21, 2026 | issue | SO-260821-848 | MAIN | 2 | 43.48 | -86.97 | 57 | 2,486.61 | Aug. 9, 2026: 2 @ 43.48 |
| Aug. 20, 2026 | issue | SO-260820-726 | MAIN | 9 | 44.08 | -396.74 | 59 | 2,573.58 | July 1, 2026: 6 @ 44.38; Aug. 9, 2026: 3 @ 43.48 |
| Aug. 16, 2026 | return | RMA | MAIN | 9 | 44.38 | 399.44 | 68 | 2,970.32 | |
| Aug. 16, 2026 | issue | SO-260816-492 | EAST | 2 | 44.38 | -88.76 | 59 | 2,570.88 | July 1, 2026: 2 @ 44.38 |
| Aug. 13, 2026 | issue | SO-260813-675 | EAST | 1 | 44.38 | -44.38 | 61 | 2,659.65 | July 1, 2026: 1 @ 44.38 |
| Aug. 10, 2026 | issue | SO-260810-705 | MAIN | 3 | 44.38 | -133.15 | 62 | 2,704.03 | July 1, 2026: 3 @ 44.38 |
| Aug. 9, 2026 | transfer | TRF | MAIN → EAST | 18 | warehouse transfer, no cost effect | ||||
| Aug. 9, 2026 | receipt | PO-001709 | MAIN | 53 | 43.48 | 2,304.59 | 65 | 2,837.17 | |
| Aug. 3, 2026 | issue | SO-260803-626 | MAIN | 18 | 44.38 | -798.87 | 12 | 532.58 | July 1, 2026: 18 @ 44.38 |
| July 21, 2026 | issue | SO-260721-486 | MAIN | 7 | 44.38 | -310.67 | 30 | 1,331.45 | July 1, 2026: 7 @ 44.38 |
| July 20, 2026 | issue | SO-260720-964 | MAIN | 4 | 44.38 | -177.53 | 37 | 1,642.12 | July 1, 2026: 4 @ 44.38 |
| July 18, 2026 | issue | SO-260718-685 | MAIN | 3 | 44.38 | -133.15 | 41 | 1,819.65 | July 1, 2026: 3 @ 44.38 |
| July 12, 2026 | issue | SO-260712-235 | MAIN | 11 | 44.41 | -488.50 | 44 | 1,952.79 | May 12, 2026: 2 @ 44.53; July 1, 2026: 9 @ 44.38 |
| July 1, 2026 | receipt | PO-001618 | MAIN | 53 | 44.38 | 2,352.23 | 55 | 2,441.29 | |
| June 25, 2026 | issue | SO-260625-566 | MAIN | 26 | 44.53 | -1,157.81 | 2 | 89.06 | May 12, 2026: 26 @ 44.53 |
| June 11, 2026 | issue | SO-260611-160 | MAIN | 4 | 44.53 | -178.12 | 28 | 1,246.87 | May 12, 2026: 4 @ 44.53 |
| June 9, 2026 | issue | SO-260609-715 | MAIN | 2 | 44.53 | -89.06 | 32 | 1,425.00 | May 12, 2026: 2 @ 44.53 |
| June 6, 2026 | issue | SO-260606-342 | MAIN | 3 | 44.53 | -133.59 | 34 | 1,514.06 | May 12, 2026: 3 @ 44.53 |
| June 3, 2026 | issue | SO-260603-581 | MAIN | 4 | 44.53 | -178.12 | 37 | 1,647.65 | May 12, 2026: 4 @ 44.53 |
| May 29, 2026 | issue | SO-260529-343 | MAIN | 2 | 44.53 | -89.06 | 41 | 1,825.78 | May 12, 2026: 2 @ 44.53 |
| May 28, 2026 | issue | SO-260528-217 | MAIN | 1 | 44.53 | -44.53 | 43 | 1,914.84 | May 12, 2026: 1 @ 44.53 |
| May 26, 2026 | issue | SO-260526-878 | MAIN | 9 | 44.53 | -400.78 | 44 | 1,959.37 | May 12, 2026: 9 @ 44.53 |
| May 14, 2026 | issue | SO-260514-665 | EAST | 1 | 44.97 | -44.97 | 53 | 2,360.15 | March 14, 2026: 1 @ 44.97 |
| May 12, 2026 | receipt | PO-001487 | MAIN | 53 | 44.53 | 2,360.15 | 54 | 2,405.12 | |
| May 7, 2026 | issue | SO-260507-830 | EAST | 8 | 44.97 | -359.77 | 1 | 44.97 | March 14, 2026: 8 @ 44.97 |
| May 7, 2026 | issue | SO-260507-830 | MAIN | 1 | 44.97 | -44.97 | 9 | 404.74 | March 14, 2026: 1 @ 44.97 |
| May 5, 2026 | issue | SO-260505-766 | MAIN | 6 | 44.97 | -269.83 | 10 | 449.72 | March 14, 2026: 6 @ 44.97 |
| May 4, 2026 | issue | SO-260504-620 | MAIN | 3 | 44.97 | -134.91 | 16 | 719.54 | March 14, 2026: 3 @ 44.97 |
| April 13, 2026 | issue | SO-260413-263 | MAIN | 10 | 44.97 | -449.72 | 19 | 854.46 | March 14, 2026: 10 @ 44.97 |
| April 8, 2026 | issue | SO-260408-746 | MAIN | 10 | 44.97 | -449.72 | 29 | 1,304.17 | March 14, 2026: 10 @ 44.97 |
| April 7, 2026 | issue | SO-260407-183 | EAST | 2 | 44.97 | -89.94 | 39 | 1,753.89 | March 14, 2026: 2 @ 44.97 |
| March 27, 2026 | issue | SO-260327-540 | MAIN | 10 | 44.97 | -449.72 | 41 | 1,843.83 | March 14, 2026: 10 @ 44.97 |
| March 26, 2026 | issue | SO-260326-842 | MAIN | 2 | 44.97 | -89.94 | 51 | 2,293.55 | March 14, 2026: 2 @ 44.97 |
| March 14, 2026 | transfer | TRF | MAIN → EAST | 11 | warehouse transfer, no cost effect | ||||
| March 14, 2026 | receipt | PO-001320 | MAIN | 53 | 44.97 | 2,383.49 | 53 | 2,383.49 | |
| March 9, 2026 | issue | SO-260309-893 | MAIN | 8 | 43.69 | -349.48 | 0 | 0.00 | Feb. 20, 2026: 8 @ 43.69 |
| March 8, 2026 | issue | SO-260308-503 | MAIN | 2 | 43.69 | -87.37 | 8 | 349.48 | Feb. 20, 2026: 2 @ 43.69 |
| March 8, 2026 | issue | SO-260308-503 | EAST | 17 | 43.69 | -742.66 | 10 | 436.86 | Feb. 20, 2026: 17 @ 43.69 |
| March 7, 2026 | issue | SO-260307-686 | MAIN | 1 | 43.69 | -43.69 | 27 | 1,179.51 | Feb. 20, 2026: 1 @ 43.69 |
| Feb. 28, 2026 | issue | SO-260228-100 | MAIN | 19 | 43.69 | -830.03 | 28 | 1,223.20 | Feb. 20, 2026: 19 @ 43.69 |
| Feb. 23, 2026 | issue | SO-260223-548 | MAIN | 6 | 43.69 | -262.11 | 47 | 2,053.22 | Feb. 20, 2026: 6 @ 43.69 |
| Feb. 20, 2026 | transfer | TRF | MAIN → EAST | 17 | warehouse transfer, no cost effect | ||||
| Feb. 20, 2026 | receipt | PO-001247 | MAIN | 53 | 43.69 | 2,315.34 | 53 | 2,315.34 | |
| Feb. 18, 2026 | issue | SO-260218-511 | MAIN | 8 | 42.26 | -338.12 | 0 | 0.00 | Dec. 2, 2025: 8 @ 42.26 |
| Feb. 14, 2026 | issue | SO-260214-272 | MAIN | 1 | 42.26 | -42.26 | 8 | 338.12 | Dec. 2, 2025: 1 @ 42.26 |
| Feb. 12, 2026 | issue | SO-260212-313 | MAIN | 11 | 42.26 | -464.91 | 9 | 380.38 | Dec. 2, 2025: 11 @ 42.26 |
| Feb. 7, 2026 | issue | SO-260207-771 | MAIN | 1 | 42.26 | -42.26 | 20 | 845.30 | Dec. 2, 2025: 1 @ 42.26 |