Items / MCB-0016
Isolator 63A Prime MCB-0016 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)18MAIN 13, EAST 5
Value (FIFO)1,556.92avg 86.50
ClassBX / FCV 0.41
Turnover11.0xlast issue 3 days ago
Days of cover44lead 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 | 12.42 / 30.4375 | 0.408 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 5.11 / 5.517 | 0.926 |
| 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 * 0.926^2 + 0.408^2 * 1.5^2) | 4.1 |
| Reorder point | d * LT + safety stock | 0.408 * 7.0 + 4.1 | 7.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 7.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 149/yr, S = 45.00, h = 20%, price = 86.12 | 27.9 |
| Inventory position | on hand + on order | 18 + 0 | 18 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 86.12 | 28 | 13,304 | yes (chosen if cheapest) |
MOQ 15, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 30, 2026 | 18 / 27 | 86.50 | 1,556.92 |
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. 13, 2026 | issue | SO-261013-189 | EAST | 2 | 86.50 | -172.99 | 18 | 1,556.92 | Sept. 30, 2026: 2 @ 86.50 |
| Oct. 9, 2026 | issue | SO-261009-766 | MAIN | 5 | 86.50 | -432.48 | 20 | 1,729.91 | Sept. 30, 2026: 5 @ 86.50 |
| Oct. 6, 2026 | issue | SO-261006-763 | MAIN | 2 | 86.50 | -172.99 | 25 | 2,162.38 | Sept. 30, 2026: 2 @ 86.50 |
| Sept. 30, 2026 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| Sept. 30, 2026 | receipt | PO-001842 | MAIN | 27 | 86.50 | 2,335.37 | 27 | 2,335.37 | |
| Sept. 23, 2026 | issue | SO-260923-856 | MAIN | 1 | 82.84 | -82.84 | 0 | 0.00 | Aug. 14, 2026: 1 @ 82.84 |
| Sept. 22, 2026 | issue | SO-260922-370 | MAIN | 7 | 82.84 | -579.88 | 1 | 82.84 | July 17, 2026: 7 @ 82.84 |
| Sept. 11, 2026 | issue | SO-260911-503 | MAIN | 5 | 82.84 | -414.20 | 8 | 662.72 | July 17, 2026: 5 @ 82.84 |
| Aug. 31, 2026 | issue | SO-260831-508 | MAIN | 4 | 82.84 | -331.36 | 13 | 1,076.91 | July 17, 2026: 4 @ 82.84 |
| Aug. 29, 2026 | issue | SO-260829-579 | MAIN | 1 | 82.84 | -82.84 | 17 | 1,408.27 | July 17, 2026: 1 @ 82.84 |
| Aug. 21, 2026 | issue | SO-260821-953 | MAIN | 1 | 82.84 | -82.84 | 18 | 1,491.11 | July 17, 2026: 1 @ 82.84 |
| Aug. 17, 2026 | issue | SO-260817-387 | MAIN | 1 | 82.84 | -82.84 | 19 | 1,573.95 | July 17, 2026: 1 @ 82.84 |
| Aug. 14, 2026 | return | RMA | MAIN | 1 | 82.84 | 82.84 | 20 | 1,656.79 | |
| Aug. 10, 2026 | issue | SO-260810-884 | MAIN | 4 | 82.84 | -331.36 | 19 | 1,573.95 | July 17, 2026: 4 @ 82.84 |
| Aug. 1, 2026 | issue | SO-260801-811 | MAIN | 2 | 82.84 | -165.68 | 23 | 1,905.31 | July 17, 2026: 2 @ 82.84 |
| July 29, 2026 | issue | SO-260729-177 | MAIN | 3 | 82.83 | -248.50 | 25 | 2,070.98 | July 16, 2026: 1 @ 82.82; July 17, 2026: 2 @ 82.84 |
| July 25, 2026 | issue | SO-260725-490 | MAIN | 1 | 82.82 | -82.82 | 28 | 2,319.48 | July 16, 2026: 1 @ 82.82 |
| July 24, 2026 | issue | SO-260724-960 | MAIN | 6 | 82.82 | -496.91 | 29 | 2,402.30 | June 8, 2026: 4 @ 82.82; July 16, 2026: 2 @ 82.82 |
| July 22, 2026 | issue | SO-260722-505 | MAIN | 1 | 82.82 | -82.82 | 35 | 2,899.21 | June 8, 2026: 1 @ 82.82 |
| July 17, 2026 | receipt | PO-001654 | MAIN | 27 | 82.84 | 2,236.66 | 36 | 2,982.03 | |
| July 16, 2026 | return | RMA | MAIN | 4 | 82.82 | 331.27 | 9 | 745.36 | |
| July 9, 2026 | issue | SO-260709-459 | MAIN | 5 | 82.82 | -414.09 | 5 | 414.09 | June 8, 2026: 5 @ 82.82 |
| July 3, 2026 | issue | SO-260703-433 | MAIN | 9 | 82.82 | -745.36 | 10 | 828.18 | June 8, 2026: 9 @ 82.82 |
| June 28, 2026 | issue | SO-260628-734 | MAIN | 1 | 82.82 | -82.82 | 19 | 1,573.55 | June 8, 2026: 1 @ 82.82 |
| June 16, 2026 | issue | SO-260616-858 | MAIN | 1 | 82.82 | -82.82 | 20 | 1,656.36 | June 8, 2026: 1 @ 82.82 |
| June 14, 2026 | issue | SO-260614-762 | MAIN | 3 | 82.82 | -248.45 | 21 | 1,739.18 | June 8, 2026: 3 @ 82.82 |
| June 10, 2026 | issue | SO-260610-523 | MAIN | 3 | 82.82 | -248.45 | 24 | 1,987.64 | June 8, 2026: 3 @ 82.82 |
| June 8, 2026 | receipt | PO-001562 | MAIN | 27 | 82.82 | 2,236.09 | 27 | 2,236.09 | |
| May 30, 2026 | issue | SO-260530-251 | MAIN | 11 | 86.28 | -949.12 | 0 | 0.00 | March 9, 2026: 9 @ 86.28; April 7, 2026: 2 @ 86.28 |
| May 29, 2026 | issue | SO-260529-354 | MAIN | 2 | 86.28 | -172.57 | 11 | 949.12 | March 9, 2026: 2 @ 86.28 |
| May 22, 2026 | issue | SO-260522-714 | MAIN | 2 | 86.28 | -172.57 | 13 | 1,121.69 | March 9, 2026: 2 @ 86.28 |
| May 12, 2026 | issue | SO-260512-765 | MAIN | 5 | 86.28 | -431.42 | 15 | 1,294.25 | March 9, 2026: 5 @ 86.28 |
| May 9, 2026 | issue | SO-260509-968 | MAIN | 1 | 86.28 | -86.28 | 20 | 1,725.67 | March 9, 2026: 1 @ 86.28 |
| April 8, 2026 | issue | SO-260408-235 | MAIN | 1 | 86.28 | -86.28 | 21 | 1,811.95 | March 9, 2026: 1 @ 86.28 |
| April 7, 2026 | return | RMA | MAIN | 2 | 86.28 | 172.57 | 22 | 1,898.24 | |
| April 1, 2026 | issue | SO-260401-871 | MAIN | 2 | 86.28 | -172.57 | 20 | 1,725.67 | March 9, 2026: 2 @ 86.28 |
| March 29, 2026 | issue | SO-260329-738 | MAIN | 2 | 86.28 | -172.57 | 22 | 1,898.24 | March 9, 2026: 2 @ 86.28 |
| March 23, 2026 | issue | SO-260323-964 | MAIN | 4 | 85.48 | -341.90 | 24 | 2,070.80 | Dec. 29, 2025: 1 @ 83.05; March 9, 2026: 3 @ 86.28 |
| March 18, 2026 | issue | SO-260318-987 | MAIN | 1 | 83.05 | -83.05 | 28 | 2,412.70 | Dec. 29, 2025: 1 @ 83.05 |
| March 9, 2026 | receipt | PO-001301 | MAIN | 27 | 86.28 | 2,329.65 | 29 | 2,495.75 | |
| March 7, 2026 | issue | SO-260307-371 | MAIN | 3 | 83.05 | -249.15 | 2 | 166.10 | Dec. 29, 2025: 3 @ 83.05 |
| March 6, 2026 | issue | SO-260306-209 | MAIN | 1 | 83.05 | -83.05 | 5 | 415.25 | Dec. 29, 2025: 1 @ 83.05 |
| March 2, 2026 | issue | SO-260302-144 | MAIN | 1 | 83.05 | -83.05 | 6 | 498.30 | Dec. 29, 2025: 1 @ 83.05 |
| Feb. 28, 2026 | issue | SO-260228-637 | MAIN | 2 | 83.05 | -166.10 | 7 | 581.35 | Dec. 29, 2025: 2 @ 83.05 |
| Feb. 9, 2026 | issue | SO-260209-629 | MAIN | 8 | 83.05 | -664.40 | 9 | 747.45 | Dec. 29, 2025: 8 @ 83.05 |
| Jan. 26, 2026 | issue | SO-260126-264 | MAIN | 1 | 83.05 | -83.05 | 17 | 1,411.84 | Dec. 29, 2025: 1 @ 83.05 |
| Jan. 23, 2026 | issue | SO-260123-339 | MAIN | 2 | 83.05 | -166.10 | 18 | 1,494.89 | Dec. 29, 2025: 2 @ 83.05 |
| Jan. 22, 2026 | issue | SO-260122-709 | MAIN | 1 | 83.05 | -83.05 | 20 | 1,660.99 | Dec. 29, 2025: 1 @ 83.05 |
| Jan. 5, 2026 | issue | SO-260105-920 | MAIN | 8 | 83.11 | -664.85 | 21 | 1,744.04 | Oct. 25, 2025: 2 @ 83.28; Dec. 29, 2025: 6 @ 83.05 |
| Jan. 1, 2026 | issue | SO-260101-957 | MAIN | 1 | 83.28 | -83.28 | 29 | 2,408.89 | Oct. 25, 2025: 1 @ 83.28 |
| Dec. 29, 2025 | issue | SO-251229-566 | MAIN | 1 | 83.28 | -83.28 | 30 | 2,492.17 | Oct. 25, 2025: 1 @ 83.28 |
| Dec. 29, 2025 | receipt | PO-001103 | MAIN | 27 | 83.05 | 2,242.34 | 31 | 2,575.45 | |
| Dec. 22, 2025 | issue | SO-251222-590 | MAIN | 9 | 83.28 | -749.49 | 4 | 333.11 | Oct. 25, 2025: 9 @ 83.28 |
| Dec. 2, 2025 | issue | SO-251202-672 | MAIN | 2 | 83.28 | -166.55 | 13 | 1,082.60 | Oct. 25, 2025: 2 @ 83.28 |
| Nov. 24, 2025 | issue | SO-251124-789 | MAIN | 4 | 83.28 | -333.11 | 15 | 1,249.15 | Oct. 25, 2025: 4 @ 83.28 |
| Nov. 14, 2025 | issue | SO-251114-346 | MAIN | 1 | 83.28 | -83.28 | 19 | 1,582.26 | Oct. 25, 2025: 1 @ 83.28 |
| Nov. 4, 2025 | issue | SO-251104-587 | MAIN | 8 | 83.22 | -665.77 | 20 | 1,665.53 | Aug. 30, 2025: 1 @ 82.84; Oct. 25, 2025: 7 @ 83.28 |
| Nov. 2, 2025 | issue | SO-251102-734 | MAIN | 2 | 82.84 | -165.67 | 28 | 2,331.30 | Aug. 30, 2025: 2 @ 82.84 |
| Oct. 28, 2025 | issue | SO-251028-299 | MAIN | 1 | 82.84 | -82.84 | 30 | 2,496.98 | Aug. 30, 2025: 1 @ 82.84 |
| Oct. 28, 2025 | issue | SO-251028-299 | EAST | 1 | 82.84 | -82.84 | 31 | 2,579.81 | Aug. 30, 2025: 1 @ 82.84 |