Items / MCB-0010
MCB 6A SP Eco MCB-0010 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)109MAIN 109
Value (FIFO)13,008.18avg 119.34
ClassAX / FCV 0.35
Turnover8.2xlast issue 2 days ago
Days of cover47lead 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 | 70.42 / 30.4375 | 2.313 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 24.98 / 5.517 | 4.528 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(7.0 * 4.528^2 + 2.313^2 * 1.5^2) | 25.6 |
| Reorder point | d * LT + safety stock | 2.313 * 7.0 + 25.6 | 41.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 41.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 844/yr, S = 45.00, h = 20%, price = 106.74 | 248.0 |
| Inventory position | on hand + on order | 109 + 0 | 109 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 116.02 | 57 | 99,298 | yes |
| 124 | 111.38 | 124 | 95,739 | yes |
| 248 | 106.74 | 248 | 92,933 | yes (chosen if cheapest) |
MOQ 62, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 9, 2026 | 109 / 111 | 119.34 | 13,008.18 |
Movement ledger 135 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-921 | MAIN | 2 | 119.34 | -238.68 | 109 | 13,008.18 | Oct. 9, 2026: 2 @ 119.34 |
| Oct. 9, 2026 | receipt | PO-001863 | MAIN | 111 | 119.34 | 13,246.86 | 111 | 13,246.86 | |
| Oct. 6, 2026 | issue | SO-261006-332 | MAIN | 10 | 118.12 | -1,181.18 | 0 | 0.00 | Aug. 23, 2026: 10 @ 118.12 |
| Oct. 5, 2026 | issue | SO-261005-230 | MAIN | 1 | 118.12 | -118.12 | 10 | 1,181.18 | Aug. 23, 2026: 1 @ 118.12 |
| Oct. 4, 2026 | issue | SO-261004-208 | MAIN | 23 | 118.12 | -2,716.73 | 11 | 1,299.30 | Aug. 23, 2026: 23 @ 118.12 |
| Sept. 13, 2026 | issue | SO-260913-220 | MAIN | 33 | 118.12 | -3,897.91 | 34 | 4,016.03 | Aug. 23, 2026: 33 @ 118.12 |
| Sept. 7, 2026 | issue | SO-260907-580 | MAIN | 5 | 118.12 | -590.59 | 67 | 7,913.94 | Aug. 23, 2026: 5 @ 118.12 |
| Sept. 1, 2026 | issue | SO-260901-349 | EAST | 31 | 118.12 | -3,661.67 | 72 | 8,504.53 | Aug. 23, 2026: 31 @ 118.12 |
| Aug. 27, 2026 | issue | SO-260827-719 | EAST | 20 | 114.74 | -2,294.88 | 103 | 12,166.21 | July 12, 2026: 12 @ 112.49; Aug. 23, 2026: 8 @ 118.12 |
| Aug. 23, 2026 | transfer | TRF | MAIN → EAST | 39 | warehouse transfer, no cost effect | ||||
| Aug. 23, 2026 | receipt | PO-001742 | MAIN | 111 | 118.12 | 13,111.15 | 123 | 14,461.09 | |
| Aug. 15, 2026 | issue | SO-260815-548 | EAST | 13 | 112.49 | -1,462.43 | 12 | 1,349.94 | July 12, 2026: 13 @ 112.49 |
| Aug. 15, 2026 | issue | SO-260815-548 | MAIN | 31 | 112.49 | -3,487.33 | 25 | 2,812.36 | July 12, 2026: 31 @ 112.49 |
| Aug. 7, 2026 | issue | SO-260807-421 | MAIN | 4 | 112.49 | -449.98 | 56 | 6,299.70 | July 12, 2026: 4 @ 112.49 |
| Aug. 2, 2026 | issue | SO-260802-650 | EAST | 27 | 112.49 | -3,037.35 | 60 | 6,749.68 | July 12, 2026: 27 @ 112.49 |
| July 12, 2026 | issue | SO-260712-521 | MAIN | 41 | 114.05 | -4,675.89 | 87 | 9,787.03 | May 10, 2026: 16 @ 116.24; July 2, 2026: 1 @ 116.24; July 12, 2026: 24 @ 112.49 |
| July 12, 2026 | transfer | TRF | MAIN → EAST | 35 | warehouse transfer, no cost effect | ||||
| July 12, 2026 | receipt | PO-001645 | MAIN | 111 | 112.49 | 12,486.90 | 128 | 14,462.92 | |
| July 3, 2026 | issue | SO-260703-154 | EAST | 7 | 116.24 | -813.66 | 17 | 1,976.02 | May 10, 2026: 7 @ 116.24 |
| July 3, 2026 | issue | SO-260703-154 | MAIN | 41 | 116.24 | -4,765.70 | 24 | 2,789.68 | May 10, 2026: 41 @ 116.24 |
| July 2, 2026 | return | RMA | MAIN | 1 | 116.24 | 116.24 | 65 | 7,555.37 | |
| June 24, 2026 | issue | SO-260624-702 | MAIN | 2 | 116.24 | -232.47 | 64 | 7,439.14 | May 10, 2026: 2 @ 116.24 |
| June 21, 2026 | issue | SO-260621-437 | MAIN | 12 | 116.24 | -1,394.84 | 66 | 7,671.61 | May 10, 2026: 12 @ 116.24 |
| June 17, 2026 | issue | SO-260617-879 | MAIN | 8 | 116.24 | -929.89 | 78 | 9,066.45 | May 10, 2026: 8 @ 116.24 |
| May 29, 2026 | issue | SO-260529-309 | MAIN | 26 | 116.01 | -3,016.19 | 86 | 9,996.34 | March 12, 2026: 1 @ 110.28; May 10, 2026: 25 @ 116.24 |
| May 28, 2026 | issue | SO-260528-239 | MAIN | 1 | 110.28 | -110.28 | 112 | 13,012.53 | March 12, 2026: 1 @ 110.28 |
| May 10, 2026 | transfer | TRF | MAIN → EAST | 24 | warehouse transfer, no cost effect | ||||
| May 10, 2026 | receipt | PO-001480 | MAIN | 111 | 116.24 | 12,902.25 | 113 | 13,122.80 | |
| May 6, 2026 | issue | SO-260506-282 | MAIN | 23 | 110.28 | -2,536.34 | 2 | 220.55 | March 12, 2026: 23 @ 110.28 |
| May 3, 2026 | issue | SO-260503-993 | MAIN | 18 | 110.28 | -1,984.96 | 25 | 2,756.89 | March 12, 2026: 18 @ 110.28 |
| April 26, 2026 | issue | SO-260426-601 | MAIN | 1 | 110.28 | -110.28 | 43 | 4,741.85 | March 12, 2026: 1 @ 110.28 |
| April 23, 2026 | issue | SO-260423-330 | MAIN | 2 | 110.28 | -220.55 | 44 | 4,852.13 | March 12, 2026: 2 @ 110.28 |
| April 19, 2026 | issue | SO-260419-695 | MAIN | 9 | 110.28 | -992.48 | 46 | 5,072.68 | March 12, 2026: 9 @ 110.28 |
| April 12, 2026 | issue | SO-260412-515 | MAIN | 21 | 110.28 | -2,315.79 | 55 | 6,065.16 | March 12, 2026: 21 @ 110.28 |
| April 11, 2026 | issue | SO-260411-753 | MAIN | 7 | 110.28 | -771.93 | 76 | 8,380.95 | March 12, 2026: 7 @ 110.28 |
| March 30, 2026 | issue | SO-260330-756 | EAST | 28 | 110.28 | -3,087.72 | 83 | 9,152.87 | March 12, 2026: 28 @ 110.28 |
| March 12, 2026 | transfer | TRF | MAIN → EAST | 28 | warehouse transfer, no cost effect | ||||
| March 12, 2026 | receipt | PO-001309 | MAIN | 111 | 110.28 | 12,240.59 | 111 | 12,240.59 | |
| March 6, 2026 | issue | SO-260306-130 | MAIN | 43 | 110.79 | -4,764.06 | 0 | 0.00 | Feb. 6, 2026: 43 @ 110.79 |
| Feb. 23, 2026 | issue | SO-260223-990 | MAIN | 6 | 110.79 | -664.75 | 43 | 4,764.06 | Feb. 6, 2026: 6 @ 110.79 |
| Feb. 21, 2026 | issue | SO-260221-922 | MAIN | 26 | 110.79 | -2,880.59 | 49 | 5,428.81 | Feb. 6, 2026: 26 @ 110.79 |
| Feb. 8, 2026 | issue | SO-260208-396 | MAIN | 7 | 110.79 | -775.54 | 75 | 8,309.40 | Feb. 6, 2026: 7 @ 110.79 |
| Feb. 8, 2026 | issue | SO-260208-396 | EAST | 19 | 110.79 | -2,105.05 | 82 | 9,084.94 | Feb. 6, 2026: 19 @ 110.79 |
| Feb. 6, 2026 | issue | SO-260206-335 | EAST | 36 | 111.00 | -3,995.92 | 101 | 11,189.99 | Dec. 13, 2025: 26 @ 111.08; Feb. 6, 2026: 10 @ 110.79 |
| Feb. 6, 2026 | transfer | TRF | MAIN → EAST | 39 | warehouse transfer, no cost effect | ||||
| Feb. 6, 2026 | receipt | PO-001203 | MAIN | 111 | 110.79 | 12,297.91 | 137 | 15,185.91 | |
| Jan. 30, 2026 | issue | SO-260130-683 | MAIN | 5 | 111.08 | -555.38 | 26 | 2,888.00 | Dec. 13, 2025: 5 @ 111.08 |
| Jan. 26, 2026 | issue | SO-260126-807 | MAIN | 11 | 111.08 | -1,221.85 | 31 | 3,443.38 | Dec. 13, 2025: 11 @ 111.08 |
| Jan. 16, 2026 | issue | SO-260116-180 | EAST | 6 | 111.08 | -666.46 | 42 | 4,665.23 | Dec. 13, 2025: 6 @ 111.08 |
| Jan. 9, 2026 | issue | SO-260109-432 | MAIN | 12 | 111.08 | -1,332.92 | 48 | 5,331.69 | Dec. 13, 2025: 12 @ 111.08 |
| Dec. 31, 2025 | issue | SO-251231-618 | MAIN | 11 | 111.08 | -1,221.85 | 60 | 6,664.61 | Dec. 13, 2025: 11 @ 111.08 |
| Dec. 26, 2025 | issue | SO-251226-276 | MAIN | 31 | 111.08 | -3,443.38 | 71 | 7,886.46 | Dec. 13, 2025: 31 @ 111.08 |
| Dec. 14, 2025 | issue | SO-251214-819 | EAST | 29 | 109.28 | -3,169.10 | 102 | 11,329.84 | Oct. 24, 2025: 20 @ 108.47; Dec. 13, 2025: 9 @ 111.08 |
| Dec. 13, 2025 | transfer | TRF | MAIN → EAST | 31 | warehouse transfer, no cost effect | ||||
| Dec. 13, 2025 | receipt | PO-001049 | MAIN | 111 | 111.08 | 12,329.54 | 131 | 14,498.94 | |
| Dec. 8, 2025 | issue | SO-251208-613 | EAST | 1 | 108.47 | -108.47 | 20 | 2,169.41 | Oct. 24, 2025: 1 @ 108.47 |
| Dec. 6, 2025 | issue | SO-251206-198 | EAST | 8 | 108.47 | -867.76 | 21 | 2,277.88 | Oct. 24, 2025: 8 @ 108.47 |
| Nov. 29, 2025 | issue | SO-251129-879 | EAST | 7 | 108.47 | -759.29 | 29 | 3,145.64 | Oct. 24, 2025: 7 @ 108.47 |
| Nov. 24, 2025 | issue | SO-251124-310 | EAST | 10 | 108.47 | -1,084.70 | 36 | 3,904.93 | Oct. 24, 2025: 10 @ 108.47 |
| Nov. 23, 2025 | issue | SO-251123-321 | EAST | 3 | 108.47 | -325.41 | 46 | 4,989.64 | Oct. 24, 2025: 3 @ 108.47 |