Items / MCB-0008
Surge Protector Flex MCB-0008 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)4MAIN 4
Value (FIFO)113.84avg 28.46
ClassCX / FCV 0.41
Turnover23.8xlast issue 3 days ago
Days of cover6lead time 7d
Reorder suggested: 60 units (position at or below reorder point: order EOQ), stockout risk high.
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 | 19.33 / 30.4375 | 0.635 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 8.00 / 5.517 | 1.451 |
| 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 * 1.451^2 + 0.635^2 * 1.5^2) | 5.1 |
| Reorder point | d * LT + safety stock | 0.635 * 7.0 + 5.1 | 9.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 9.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 232/yr, S = 45.00, h = 20%, price = 29.05 | 59.9 |
| Inventory position | on hand + on order | 4 + 0 | 4 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 29.05 | 60 | 7,083 | yes (chosen if cheapest) |
MOQ 18, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 12, 2026 | 4 / 33 | 28.46 | 113.84 |
Movement ledger 114 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-532 | MAIN | 1 | 28.46 | -28.46 | 4 | 113.84 | Sept. 12, 2026: 1 @ 28.46 |
| Oct. 10, 2026 | issue | SO-261010-626 | MAIN | 4 | 28.46 | -113.84 | 5 | 142.30 | Sept. 12, 2026: 4 @ 28.46 |
| Oct. 6, 2026 | issue | SO-261006-554 | MAIN | 15 | 28.46 | -426.88 | 9 | 256.13 | Sept. 12, 2026: 15 @ 28.46 |
| Sept. 28, 2026 | issue | SO-260928-469 | MAIN | 7 | 28.46 | -199.21 | 24 | 683.02 | Sept. 12, 2026: 7 @ 28.46 |
| Sept. 18, 2026 | issue | SO-260918-938 | MAIN | 4 | 28.87 | -115.47 | 31 | 882.23 | Aug. 3, 2026: 2 @ 29.28; Sept. 12, 2026: 2 @ 28.46 |
| Sept. 17, 2026 | issue | SO-260917-199 | MAIN | 1 | 29.28 | -29.28 | 35 | 997.70 | Aug. 3, 2026: 1 @ 29.28 |
| Sept. 12, 2026 | receipt | PO-001795 | MAIN | 33 | 28.46 | 939.15 | 36 | 1,026.98 | |
| Sept. 5, 2026 | issue | SO-260905-310 | MAIN | 4 | 29.28 | -117.11 | 3 | 87.83 | Aug. 3, 2026: 4 @ 29.28 |
| Sept. 4, 2026 | issue | SO-260904-280 | MAIN | 11 | 29.28 | -322.04 | 7 | 204.93 | Aug. 3, 2026: 11 @ 29.28 |
| Sept. 3, 2026 | issue | SO-260903-867 | MAIN | 3 | 29.28 | -87.83 | 18 | 526.98 | Aug. 3, 2026: 3 @ 29.28 |
| Aug. 30, 2026 | issue | SO-260830-311 | MAIN | 1 | 29.28 | -29.28 | 21 | 614.80 | Aug. 3, 2026: 1 @ 29.28 |
| Aug. 26, 2026 | issue | SO-260826-111 | MAIN | 1 | 29.28 | -29.28 | 22 | 644.08 | Aug. 3, 2026: 1 @ 29.28 |
| Aug. 22, 2026 | issue | SO-260822-766 | EAST | 1 | 29.28 | -29.28 | 23 | 673.36 | Aug. 3, 2026: 1 @ 29.28 |
| Aug. 13, 2026 | issue | SO-260813-595 | MAIN | 1 | 29.28 | -29.28 | 24 | 702.63 | Aug. 3, 2026: 1 @ 29.28 |
| Aug. 7, 2026 | issue | SO-260807-959 | EAST | 7 | 29.28 | -204.93 | 25 | 731.91 | Aug. 3, 2026: 7 @ 29.28 |
| Aug. 5, 2026 | issue | SO-260805-711 | EAST | 1 | 29.28 | -29.28 | 32 | 936.84 | Aug. 3, 2026: 1 @ 29.28 |
| Aug. 3, 2026 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| Aug. 3, 2026 | receipt | PO-001696 | MAIN | 33 | 29.28 | 966.12 | 33 | 966.12 | |
| Aug. 1, 2026 | issue | SO-260801-562 | MAIN | 5 | 29.07 | -145.33 | 0 | 0.00 | June 20, 2026: 5 @ 29.07 |
| July 29, 2026 | issue | SO-260729-200 | MAIN | 3 | 29.07 | -87.20 | 5 | 145.33 | June 20, 2026: 3 @ 29.07 |
| July 27, 2026 | issue | SO-260727-539 | MAIN | 15 | 29.07 | -435.99 | 8 | 232.53 | June 20, 2026: 15 @ 29.07 |
| July 17, 2026 | issue | SO-260717-844 | MAIN | 1 | 29.07 | -29.07 | 23 | 668.52 | June 20, 2026: 1 @ 29.07 |
| July 13, 2026 | issue | SO-260713-757 | MAIN | 3 | 29.07 | -87.20 | 24 | 697.59 | June 20, 2026: 3 @ 29.07 |
| July 4, 2026 | issue | SO-260704-619 | MAIN | 1 | 29.07 | -29.07 | 27 | 784.79 | June 20, 2026: 1 @ 29.07 |
| July 1, 2026 | issue | SO-260701-768 | MAIN | 5 | 29.07 | -145.33 | 28 | 813.86 | June 20, 2026: 5 @ 29.07 |
| June 20, 2026 | receipt | PO-001589 | MAIN | 33 | 29.07 | 959.19 | 33 | 959.19 | |
| June 17, 2026 | issue | SO-260617-345 | MAIN | 2 | 27.66 | -55.33 | 0 | 0.00 | May 4, 2026: 2 @ 27.66 |
| June 13, 2026 | issue | SO-260613-508 | MAIN | 10 | 28.44 | -284.44 | 2 | 55.33 | April 26, 2026: 9 @ 28.53; May 4, 2026: 1 @ 27.66 |
| June 1, 2026 | issue | SO-260601-301 | MAIN | 10 | 28.53 | -285.30 | 12 | 339.76 | April 26, 2026: 10 @ 28.53 |
| May 29, 2026 | issue | SO-260529-807 | MAIN | 10 | 28.53 | -285.30 | 22 | 625.06 | April 26, 2026: 10 @ 28.53 |
| May 17, 2026 | issue | SO-260517-255 | MAIN | 4 | 28.53 | -114.12 | 32 | 910.36 | April 26, 2026: 4 @ 28.53 |
| May 4, 2026 | return | RMA | MAIN | 3 | 27.66 | 83.00 | 36 | 1,024.48 | |
| April 26, 2026 | receipt | PO-001441 | MAIN | 33 | 28.53 | 941.49 | 33 | 941.49 | |
| April 19, 2026 | issue | SO-260419-793 | EAST | 1 | 27.66 | -27.66 | 0 | 0.00 | Jan. 17, 2026: 1 @ 27.66 |
| April 19, 2026 | issue | SO-260419-793 | MAIN | 6 | 27.66 | -165.99 | 1 | 27.66 | Jan. 17, 2026: 6 @ 27.66 |
| April 18, 2026 | issue | SO-260418-243 | MAIN | 3 | 27.66 | -83.00 | 7 | 193.66 | Jan. 17, 2026: 3 @ 27.66 |
| April 8, 2026 | issue | SO-260408-374 | EAST | 1 | 27.66 | -27.66 | 10 | 276.65 | Jan. 17, 2026: 1 @ 27.66 |
| March 30, 2026 | issue | SO-260330-710 | EAST | 1 | 27.66 | -27.66 | 11 | 304.32 | Jan. 17, 2026: 1 @ 27.66 |
| March 28, 2026 | issue | SO-260328-393 | MAIN | 1 | 27.66 | -27.66 | 12 | 331.98 | Jan. 17, 2026: 1 @ 27.66 |
| March 19, 2026 | issue | SO-260319-380 | EAST | 1 | 27.66 | -27.66 | 13 | 359.64 | Jan. 17, 2026: 1 @ 27.66 |
| March 16, 2026 | issue | SO-260316-397 | MAIN | 1 | 27.66 | -27.66 | 14 | 387.31 | Jan. 17, 2026: 1 @ 27.66 |
| March 9, 2026 | issue | SO-260309-705 | MAIN | 2 | 27.66 | -55.33 | 15 | 414.98 | Jan. 17, 2026: 2 @ 27.66 |
| Feb. 27, 2026 | issue | SO-260227-925 | MAIN | 1 | 27.66 | -27.66 | 17 | 470.30 | Jan. 17, 2026: 1 @ 27.66 |
| Feb. 25, 2026 | issue | SO-260225-877 | MAIN | 7 | 27.66 | -193.66 | 18 | 497.97 | Jan. 17, 2026: 7 @ 27.66 |
| Feb. 4, 2026 | issue | SO-260204-989 | EAST | 3 | 27.66 | -83.00 | 25 | 691.62 | Jan. 17, 2026: 3 @ 27.66 |
| Jan. 23, 2026 | issue | SO-260123-650 | MAIN | 4 | 27.66 | -110.66 | 28 | 774.62 | Jan. 17, 2026: 4 @ 27.66 |
| Jan. 18, 2026 | issue | SO-260118-589 | MAIN | 6 | 27.59 | -165.53 | 32 | 885.28 | Nov. 19, 2025: 5 @ 27.57; Jan. 17, 2026: 1 @ 27.66 |
| Jan. 17, 2026 | issue | SO-260117-508 | MAIN | 1 | 27.57 | -27.57 | 38 | 1,050.81 | Nov. 19, 2025: 1 @ 27.57 |
| Jan. 17, 2026 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| Jan. 17, 2026 | receipt | PO-001155 | MAIN | 33 | 27.66 | 912.94 | 39 | 1,078.38 | |
| Jan. 11, 2026 | issue | SO-260111-381 | MAIN | 6 | 27.57 | -165.44 | 6 | 165.44 | Nov. 19, 2025: 6 @ 27.57 |
| Jan. 1, 2026 | issue | SO-260101-200 | MAIN | 2 | 27.57 | -55.15 | 12 | 330.87 | Nov. 19, 2025: 2 @ 27.57 |
| Dec. 24, 2025 | issue | SO-251224-530 | MAIN | 8 | 27.57 | -220.58 | 14 | 386.02 | Nov. 19, 2025: 8 @ 27.57 |
| Dec. 21, 2025 | issue | SO-251221-665 | MAIN | 15 | 27.78 | -416.77 | 22 | 606.60 | Oct. 31, 2025: 4 @ 28.37; Nov. 19, 2025: 11 @ 27.57 |
| Nov. 19, 2025 | receipt | PO-001009 | MAIN | 33 | 27.57 | 909.90 | 37 | 1,023.37 | |
| Nov. 12, 2025 | issue | SO-251112-338 | MAIN | 32 | 28.32 | -906.37 | 4 | 113.46 | Sept. 25, 2025: 3 @ 27.92; Oct. 31, 2025: 29 @ 28.37 |
| Oct. 31, 2025 | receipt | PO-000966 | MAIN | 33 | 28.37 | 936.08 | 36 | 1,019.83 | |
| Oct. 28, 2025 | issue | SO-251028-522 | MAIN | 2 | 27.92 | -55.83 | 3 | 83.75 | Sept. 25, 2025: 2 @ 27.92 |
| Oct. 25, 2025 | issue | SO-251025-695 | MAIN | 12 | 27.92 | -335.00 | 5 | 139.58 | Sept. 25, 2025: 12 @ 27.92 |
| Oct. 8, 2025 | issue | SO-251008-736 | MAIN | 2 | 27.92 | -55.83 | 17 | 474.58 | Sept. 25, 2025: 2 @ 27.92 |