Items / MCB-0018
MCB 32A TP Pro MCB-0018 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)45MAIN 36, EAST 9
Value (FIFO)2,093.18avg 46.52
ClassBX / FCV 0.44
Turnover8.5xlast issue 9 days ago
Days of cover58lead 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 | 23.50 / 30.4375 | 0.772 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 10.37 / 5.517 | 1.880 |
| 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.880^2 + 0.772^2 * 1.5^2) | 8.4 |
| Reorder point | d * LT + safety stock | 0.772 * 7.0 + 8.4 | 13.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 13.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 282/yr, S = 45.00, h = 20%, price = 47.20 | 51.8 |
| Inventory position | on hand + on order | 45 + 0 | 45 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 47.20 | 52 | 13,791 | yes (chosen if cheapest) |
MOQ 25, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 14, 2026 | 45 / 45 | 46.52 | 2,093.18 |
Movement ledger 131 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 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| Oct. 14, 2026 | receipt | PO-001879 | MAIN | 45 | 46.52 | 2,093.18 | 45 | 2,093.18 | |
| Oct. 7, 2026 | issue | SO-261007-875 | MAIN | 8 | 46.47 | -371.78 | 0 | 0.00 | Aug. 2, 2026: 6 @ 46.31; Aug. 2, 2026: 2 @ 46.98 |
| Oct. 5, 2026 | issue | SO-261005-719 | MAIN | 9 | 46.31 | -416.75 | 8 | 371.78 | Aug. 2, 2026: 9 @ 46.31 |
| Oct. 4, 2026 | issue | SO-261004-985 | MAIN | 1 | 46.31 | -46.31 | 17 | 788.53 | Aug. 2, 2026: 1 @ 46.31 |
| Sept. 20, 2026 | issue | SO-260920-784 | MAIN | 2 | 46.31 | -92.61 | 18 | 834.84 | Aug. 2, 2026: 2 @ 46.31 |
| Sept. 12, 2026 | issue | SO-260912-543 | MAIN | 4 | 46.31 | -185.22 | 20 | 927.45 | Aug. 2, 2026: 4 @ 46.31 |
| Sept. 11, 2026 | issue | SO-260911-453 | MAIN | 5 | 46.31 | -231.53 | 24 | 1,112.67 | Aug. 2, 2026: 5 @ 46.31 |
| Sept. 10, 2026 | issue | SO-260910-487 | MAIN | 1 | 46.31 | -46.31 | 29 | 1,344.19 | Aug. 2, 2026: 1 @ 46.31 |
| Sept. 6, 2026 | issue | SO-260906-271 | MAIN | 3 | 46.31 | -138.92 | 30 | 1,390.50 | Aug. 2, 2026: 3 @ 46.31 |
| Aug. 29, 2026 | issue | SO-260829-573 | MAIN | 11 | 46.31 | -509.36 | 33 | 1,529.41 | Aug. 2, 2026: 11 @ 46.31 |
| Aug. 20, 2026 | issue | SO-260820-829 | MAIN | 2 | 46.31 | -92.61 | 44 | 2,038.77 | Aug. 2, 2026: 2 @ 46.31 |
| Aug. 5, 2026 | issue | SO-260805-496 | MAIN | 1 | 46.31 | -46.31 | 46 | 2,131.38 | Aug. 2, 2026: 1 @ 46.31 |
| Aug. 2, 2026 | return | RMA | MAIN | 2 | 46.98 | 93.95 | 47 | 2,177.68 | |
| Aug. 2, 2026 | receipt | PO-001692 | MAIN | 45 | 46.31 | 2,083.73 | 45 | 2,083.73 | |
| Aug. 1, 2026 | issue | SO-260801-329 | MAIN | 4 | 46.98 | -187.91 | 0 | 0.00 | June 20, 2026: 4 @ 46.98 |
| July 27, 2026 | issue | SO-260727-792 | MAIN | 11 | 46.98 | -516.75 | 4 | 187.91 | June 20, 2026: 11 @ 46.98 |
| July 19, 2026 | issue | SO-260719-272 | MAIN | 4 | 46.98 | -187.91 | 15 | 704.66 | June 20, 2026: 4 @ 46.98 |
| July 16, 2026 | issue | SO-260716-873 | MAIN | 16 | 46.98 | -751.63 | 19 | 892.56 | June 20, 2026: 16 @ 46.98 |
| July 14, 2026 | issue | SO-260714-333 | MAIN | 1 | 46.98 | -46.98 | 35 | 1,644.20 | June 20, 2026: 1 @ 46.98 |
| July 1, 2026 | issue | SO-260701-495 | MAIN | 9 | 46.98 | -422.79 | 36 | 1,691.17 | June 20, 2026: 9 @ 46.98 |
| June 21, 2026 | issue | SO-260621-304 | MAIN | 7 | 45.11 | -315.77 | 45 | 2,113.96 | April 12, 2026: 7 @ 45.11 |
| June 20, 2026 | receipt | PO-001590 | MAIN | 45 | 46.98 | 2,113.96 | 52 | 2,429.74 | |
| June 14, 2026 | issue | SO-260614-528 | MAIN | 14 | 45.11 | -631.54 | 7 | 315.77 | April 12, 2026: 14 @ 45.11 |
| June 13, 2026 | issue | SO-260613-699 | MAIN | 3 | 45.11 | -135.33 | 21 | 947.31 | April 12, 2026: 3 @ 45.11 |
| June 7, 2026 | issue | SO-260607-215 | MAIN | 7 | 45.11 | -315.77 | 24 | 1,082.64 | April 12, 2026: 7 @ 45.11 |
| June 5, 2026 | issue | SO-260605-211 | MAIN | 4 | 45.11 | -180.44 | 31 | 1,398.41 | April 12, 2026: 4 @ 45.11 |
| May 29, 2026 | issue | SO-260529-300 | MAIN | 1 | 45.11 | -45.11 | 35 | 1,578.85 | April 12, 2026: 1 @ 45.11 |
| May 25, 2026 | issue | SO-260525-483 | MAIN | 2 | 45.11 | -90.22 | 36 | 1,623.96 | April 12, 2026: 2 @ 45.11 |
| May 24, 2026 | issue | SO-260524-153 | MAIN | 4 | 45.11 | -180.44 | 38 | 1,714.18 | April 12, 2026: 4 @ 45.11 |
| May 21, 2026 | issue | SO-260521-406 | MAIN | 3 | 45.11 | -135.33 | 42 | 1,894.62 | April 12, 2026: 3 @ 45.11 |
| May 19, 2026 | issue | SO-260519-747 | MAIN | 4 | 46.82 | -187.29 | 45 | 2,029.95 | Feb. 21, 2026: 4 @ 46.82 |
| May 8, 2026 | issue | SO-260508-720 | MAIN | 1 | 46.82 | -46.82 | 49 | 2,217.25 | Feb. 21, 2026: 1 @ 46.82 |
| April 27, 2026 | issue | SO-260427-774 | MAIN | 1 | 46.82 | -46.82 | 50 | 2,264.07 | Feb. 21, 2026: 1 @ 46.82 |
| April 21, 2026 | issue | SO-260421-843 | MAIN | 4 | 46.82 | -187.29 | 51 | 2,310.89 | Feb. 21, 2026: 4 @ 46.82 |
| April 12, 2026 | receipt | PO-001404 | MAIN | 45 | 45.11 | 2,029.95 | 55 | 2,498.18 | |
| April 10, 2026 | issue | SO-260410-166 | MAIN | 1 | 46.82 | -46.82 | 10 | 468.23 | Feb. 21, 2026: 1 @ 46.82 |
| April 4, 2026 | issue | SO-260404-434 | MAIN | 3 | 46.82 | -140.47 | 11 | 515.05 | Feb. 21, 2026: 3 @ 46.82 |
| April 3, 2026 | issue | SO-260403-565 | MAIN | 1 | 46.82 | -46.82 | 14 | 655.52 | Feb. 21, 2026: 1 @ 46.82 |
| March 25, 2026 | issue | SO-260325-947 | MAIN | 7 | 46.82 | -327.76 | 15 | 702.34 | Feb. 21, 2026: 7 @ 46.82 |
| March 21, 2026 | issue | SO-260321-810 | MAIN | 3 | 46.82 | -140.47 | 22 | 1,030.10 | Feb. 21, 2026: 3 @ 46.82 |
| March 4, 2026 | issue | SO-260304-783 | MAIN | 23 | 46.61 | -1,071.98 | 25 | 1,170.57 | Dec. 25, 2025: 2 @ 45.17; Jan. 27, 2026: 1 @ 45.17; Feb. 21, 2026: 20 @ 46.82 |
| Feb. 26, 2026 | issue | SO-260226-720 | MAIN | 5 | 45.17 | -225.87 | 48 | 2,242.55 | Dec. 25, 2025: 5 @ 45.17 |
| Feb. 21, 2026 | receipt | PO-001249 | MAIN | 45 | 46.82 | 2,107.03 | 53 | 2,468.42 | |
| Feb. 14, 2026 | issue | SO-260214-115 | MAIN | 5 | 45.17 | -225.87 | 8 | 361.39 | Dec. 25, 2025: 5 @ 45.17 |
| Feb. 12, 2026 | issue | SO-260212-366 | MAIN | 10 | 45.17 | -451.74 | 13 | 587.26 | Dec. 25, 2025: 10 @ 45.17 |
| Feb. 10, 2026 | issue | SO-260210-282 | MAIN | 4 | 45.17 | -180.70 | 23 | 1,039.00 | Dec. 25, 2025: 4 @ 45.17 |
| Jan. 27, 2026 | return | RMA | MAIN | 1 | 45.17 | 45.17 | 27 | 1,219.70 | |
| Jan. 23, 2026 | issue | SO-260123-513 | MAIN | 2 | 45.17 | -90.35 | 26 | 1,174.53 | Dec. 25, 2025: 2 @ 45.17 |
| Jan. 19, 2026 | issue | SO-260119-312 | MAIN | 1 | 45.17 | -45.17 | 28 | 1,264.87 | Dec. 25, 2025: 1 @ 45.17 |
| Jan. 19, 2026 | issue | SO-260119-312 | EAST | 3 | 45.17 | -135.52 | 29 | 1,310.05 | Dec. 25, 2025: 3 @ 45.17 |
| Jan. 18, 2026 | issue | SO-260118-282 | EAST | 2 | 45.17 | -90.35 | 32 | 1,445.57 | Dec. 25, 2025: 2 @ 45.17 |
| Jan. 9, 2026 | issue | SO-260109-745 | EAST | 7 | 45.17 | -316.22 | 34 | 1,535.92 | Dec. 25, 2025: 7 @ 45.17 |
| Jan. 8, 2026 | issue | SO-260108-483 | EAST | 3 | 45.17 | -135.52 | 41 | 1,852.14 | Dec. 25, 2025: 3 @ 45.17 |
| Jan. 7, 2026 | issue | SO-260107-390 | MAIN | 1 | 45.17 | -45.17 | 44 | 1,987.66 | Dec. 25, 2025: 1 @ 45.17 |
| Dec. 25, 2025 | transfer | TRF | MAIN → EAST | 15 | warehouse transfer, no cost effect | ||||
| Dec. 25, 2025 | receipt | PO-001088 | MAIN | 45 | 45.17 | 2,032.83 | 45 | 2,032.83 | |
| Dec. 22, 2025 | issue | SO-251222-528 | MAIN | 6 | 46.13 | -276.76 | 0 | 0.00 | Nov. 17, 2025: 6 @ 46.13 |
| Dec. 18, 2025 | issue | SO-251218-281 | MAIN | 34 | 46.13 | -1,568.31 | 6 | 276.76 | Nov. 17, 2025: 34 @ 46.13 |
| Nov. 22, 2025 | issue | SO-251122-326 | MAIN | 3 | 46.13 | -138.38 | 40 | 1,845.07 | Nov. 17, 2025: 3 @ 46.13 |