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
| 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 |
| Oct. 6, 2025 | issue | SO-251006-451 | MAIN | 2 | 27.92 | -55.83 | 19 | 530.41 | Sept. 25, 2025: 2 @ 27.92 |
| Oct. 3, 2025 | issue | SO-251003-168 | MAIN | 4 | 27.92 | -111.67 | 21 | 586.25 | Sept. 25, 2025: 4 @ 27.92 |
| Sept. 26, 2025 | issue | SO-250926-159 | MAIN | 16 | 27.66 | -442.60 | 25 | 697.91 | Sept. 5, 2025: 8 @ 27.41; Sept. 25, 2025: 8 @ 27.92 |
| Sept. 25, 2025 | receipt | PO-000871 | MAIN | 33 | 27.92 | 921.24 | 41 | 1,140.51 | |
| Sept. 18, 2025 | issue | SO-250918-435 | MAIN | 7 | 27.41 | -191.86 | 8 | 219.26 | Sept. 5, 2025: 7 @ 27.41 |
| Sept. 12, 2025 | issue | SO-250912-405 | MAIN | 4 | 27.41 | -109.63 | 15 | 411.12 | Sept. 5, 2025: 4 @ 27.41 |
| Sept. 8, 2025 | issue | SO-250908-306 | MAIN | 3 | 27.41 | -82.22 | 19 | 520.75 | Sept. 5, 2025: 3 @ 27.41 |
| Sept. 8, 2025 | issue | SO-250908-306 | EAST | 11 | 27.41 | -301.49 | 22 | 602.98 | Sept. 5, 2025: 11 @ 27.41 |
| Sept. 5, 2025 | transfer | TRF | MAIN → EAST | 11 | warehouse transfer, no cost effect | ||||
| Sept. 5, 2025 | receipt | PO-000818 | MAIN | 33 | 27.41 | 904.46 | 33 | 904.46 | |
| Aug. 27, 2025 | issue | SO-250827-152 | MAIN | 6 | 27.58 | -165.46 | 0 | 0.00 | July 11, 2025: 5 @ 27.54; July 31, 2025: 1 @ 27.78 |
| Aug. 26, 2025 | issue | SO-250826-122 | MAIN | 19 | 27.54 | -523.17 | 6 | 165.46 | July 11, 2025: 19 @ 27.54 |
| Aug. 18, 2025 | issue | SO-250818-482 | MAIN | 9 | 27.54 | -247.82 | 25 | 688.62 | July 11, 2025: 9 @ 27.54 |
| Aug. 16, 2025 | issue | SO-250816-881 | MAIN | 3 | 27.78 | -83.34 | 34 | 936.44 | March 28, 2025: 3 @ 27.78 |
| July 31, 2025 | return | RMA | MAIN | 1 | 27.78 | 27.78 | 37 | 1,019.78 | |
| July 26, 2025 | issue | SO-250726-360 | MAIN | 1 | 27.78 | -27.78 | 36 | 992.00 | March 28, 2025: 1 @ 27.78 |
| July 11, 2025 | receipt | PO-000700 | MAIN | 33 | 27.54 | 908.66 | 37 | 1,019.78 | |
| July 6, 2025 | issue | SO-250706-394 | MAIN | 3 | 27.78 | -83.34 | 4 | 111.13 | March 28, 2025: 3 @ 27.78 |
| July 5, 2025 | issue | SO-250705-996 | MAIN | 2 | 27.78 | -55.56 | 7 | 194.47 | March 28, 2025: 2 @ 27.78 |
| July 4, 2025 | issue | SO-250704-534 | MAIN | 2 | 27.78 | -55.56 | 9 | 250.03 | March 28, 2025: 2 @ 27.78 |
| June 28, 2025 | issue | SO-250628-730 | MAIN | 6 | 27.78 | -166.69 | 11 | 305.60 | March 28, 2025: 6 @ 27.78 |
| June 21, 2025 | issue | SO-250621-810 | MAIN | 1 | 27.78 | -27.78 | 17 | 472.29 | March 28, 2025: 1 @ 27.78 |
| May 22, 2025 | issue | SO-250522-802 | MAIN | 3 | 27.78 | -83.34 | 18 | 500.07 | March 28, 2025: 3 @ 27.78 |
| May 14, 2025 | issue | SO-250514-440 | MAIN | 2 | 27.78 | -55.56 | 21 | 583.41 | March 28, 2025: 2 @ 27.78 |
| May 5, 2025 | issue | SO-250505-971 | MAIN | 1 | 27.78 | -27.78 | 23 | 638.97 | March 28, 2025: 1 @ 27.78 |
| May 3, 2025 | issue | SO-250503-270 | MAIN | 1 | 27.78 | -27.78 | 24 | 666.76 | March 28, 2025: 1 @ 27.78 |
| April 28, 2025 | issue | SO-250428-469 | MAIN | 8 | 27.78 | -222.25 | 25 | 694.54 | March 28, 2025: 8 @ 27.78 |
| April 28, 2025 | issue | SO-250428-469 | EAST | 7 | 27.77 | -194.41 | 33 | 916.79 | Feb. 5, 2025: 7 @ 27.77 |
| April 7, 2025 | issue | SO-250407-190 | MAIN | 1 | 27.77 | -27.77 | 40 | 1,111.20 | Feb. 5, 2025: 1 @ 27.77 |
| March 28, 2025 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| March 28, 2025 | receipt | PO-000389 | MAIN | 33 | 27.78 | 916.79 | 41 | 1,138.97 | |
| March 23, 2025 | issue | SO-250323-100 | MAIN | 6 | 27.77 | -166.64 | 8 | 222.18 | Feb. 5, 2025: 6 @ 27.77 |
| March 22, 2025 | issue | SO-250322-250 | MAIN | 5 | 27.77 | -138.87 | 14 | 388.82 | Feb. 5, 2025: 5 @ 27.77 |
| March 21, 2025 | issue | SO-250321-184 | MAIN | 7 | 27.77 | -194.41 | 19 | 527.69 | Feb. 5, 2025: 7 @ 27.77 |
| Feb. 28, 2025 | issue | SO-250228-601 | MAIN | 2 | 27.77 | -55.55 | 26 | 722.10 | Feb. 5, 2025: 2 @ 27.77 |
| Feb. 19, 2025 | issue | SO-250219-876 | MAIN | 1 | 27.77 | -27.77 | 28 | 777.65 | Feb. 5, 2025: 1 @ 27.77 |
| Feb. 8, 2025 | issue | SO-250208-927 | MAIN | 4 | 27.77 | -111.09 | 29 | 805.42 | Feb. 5, 2025: 4 @ 27.77 |
| Feb. 5, 2025 | receipt | PO-000241 | MAIN | 33 | 27.77 | 916.51 | 33 | 916.51 | |
| Feb. 3, 2025 | issue | SO-250203-123 | MAIN | 5 | 27.28 | -136.39 | 0 | 0.00 | Nov. 26, 2024: 5 @ 27.28 |
| Feb. 1, 2025 | issue | SO-250201-871 | MAIN | 1 | 27.28 | -27.28 | 5 | 136.39 | Nov. 26, 2024: 1 @ 27.28 |
| Jan. 30, 2025 | issue | SO-250130-876 | MAIN | 3 | 27.28 | -81.84 | 6 | 163.67 | Nov. 26, 2024: 3 @ 27.28 |
| Jan. 29, 2025 | issue | SO-250129-465 | MAIN | 7 | 27.28 | -190.95 | 9 | 245.51 | Nov. 26, 2024: 7 @ 27.28 |
| Jan. 24, 2025 | issue | SO-250124-312 | MAIN | 1 | 27.28 | -27.28 | 16 | 436.46 | Nov. 26, 2024: 1 @ 27.28 |
| Jan. 23, 2025 | issue | SO-250123-515 | MAIN | 6 | 27.28 | -163.67 | 17 | 463.74 | Nov. 26, 2024: 6 @ 27.28 |
| Dec. 19, 2024 | issue | SO-241219-952 | MAIN | 7 | 27.28 | -190.95 | 23 | 627.41 | Nov. 26, 2024: 7 @ 27.28 |
| Dec. 16, 2024 | issue | SO-241216-757 | MAIN | 9 | 27.49 | -247.42 | 30 | 818.36 | Oct. 1, 2024: 3 @ 27.60; Oct. 27, 2024: 3 @ 27.60; Nov. 26, 2024: 3 @ 27.28 |
| Nov. 26, 2024 | receipt | PO-000062 | MAIN | 33 | 27.28 | 900.20 | 39 | 1,065.78 | |
| Nov. 21, 2024 | issue | SO-241121-747 | MAIN | 10 | 27.60 | -275.98 | 6 | 165.58 | Oct. 1, 2024: 10 @ 27.60 |
| Nov. 20, 2024 | issue | SO-241120-417 | MAIN | 8 | 27.60 | -220.78 | 16 | 441.56 | Oct. 1, 2024: 8 @ 27.60 |
| Nov. 15, 2024 | issue | SO-241115-877 | MAIN | 3 | 27.60 | -82.79 | 24 | 662.34 | Oct. 1, 2024: 3 @ 27.60 |
| Oct. 27, 2024 | return | RMA | MAIN | 3 | 27.60 | 82.79 | 27 | 745.13 | |
| Oct. 15, 2024 | issue | SO-241015-220 | MAIN | 5 | 27.60 | -137.99 | 24 | 662.34 | Oct. 1, 2024: 5 @ 27.60 |
| Oct. 8, 2024 | issue | SO-241008-712 | MAIN | 7 | 27.60 | -193.18 | 29 | 800.33 | Oct. 1, 2024: 7 @ 27.60 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 36 | 27.60 | 993.51 | 36 | 993.51 | |