Items / MCB-0007
Surge Protector Prime MCB-0007 · Circuit Protection · Volta Electricals Pvt Ltd
On hand (EA)22MAIN 11, EAST 11
Value (FIFO)716.64avg 32.57
ClassCX / FCV 0.34
Turnover7.3xlast issue 5 days ago
Days of cover39lead 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 | 17.33 / 30.4375 | 0.569 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 5.96 / 5.517 | 1.081 |
| 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.081^2 + 0.569^2 * 1.5^2) | 3.8 |
| Reorder point | d * LT + safety stock | 0.569 * 7.0 + 3.8 | 7.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 7.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 208/yr, S = 45.00, h = 20%, price = 29.90 | 76.0 |
| Inventory position | on hand + on order | 22 + 0 | 22 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 32.50 | 54 | 7,104 | no |
| 38 | 31.20 | 55 | 6,827 | yes |
| 76 | 29.90 | 76 | 6,565 | yes (chosen if cheapest) |
MOQ 19, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 12, 2026 | 20 / 34 | 32.52 | 650.44 | |
| Sept. 12, 2026 | 2 / 2 | 33.10 | 66.19 |
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. 11, 2026 | issue | SO-261011-618 | MAIN | 1 | 32.52 | -32.52 | 22 | 716.64 | Sept. 12, 2026: 1 @ 32.52 |
| Oct. 10, 2026 | issue | SO-261010-996 | MAIN | 5 | 32.52 | -162.61 | 23 | 749.16 | Sept. 12, 2026: 5 @ 32.52 |
| Oct. 8, 2026 | issue | SO-261008-195 | MAIN | 5 | 32.52 | -162.61 | 28 | 911.77 | Sept. 12, 2026: 5 @ 32.52 |
| Oct. 7, 2026 | issue | SO-261007-626 | MAIN | 1 | 32.52 | -32.52 | 33 | 1,074.38 | Sept. 12, 2026: 1 @ 32.52 |
| Oct. 6, 2026 | issue | SO-261006-572 | EAST | 1 | 32.52 | -32.52 | 34 | 1,106.90 | Sept. 12, 2026: 1 @ 32.52 |
| Oct. 3, 2026 | issue | SO-261003-191 | MAIN | 1 | 32.52 | -32.52 | 35 | 1,139.42 | Sept. 12, 2026: 1 @ 32.52 |
| Sept. 25, 2026 | issue | SO-260925-850 | MAIN | 4 | 33.10 | -132.38 | 36 | 1,171.95 | July 16, 2026: 4 @ 33.10 |
| Sept. 18, 2026 | issue | SO-260918-872 | MAIN | 2 | 33.10 | -66.19 | 40 | 1,304.33 | July 16, 2026: 2 @ 33.10 |
| Sept. 12, 2026 | return | RMA | MAIN | 2 | 33.10 | 66.19 | 42 | 1,370.52 | |
| Sept. 12, 2026 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||
| Sept. 12, 2026 | receipt | PO-001794 | MAIN | 34 | 32.52 | 1,105.75 | 40 | 1,304.33 | |
| Sept. 2, 2026 | issue | SO-260902-511 | MAIN | 5 | 33.10 | -165.48 | 6 | 198.57 | July 16, 2026: 5 @ 33.10 |
| Sept. 2, 2026 | issue | SO-260902-511 | EAST | 5 | 33.10 | -165.48 | 11 | 364.05 | July 16, 2026: 5 @ 33.10 |
| Aug. 25, 2026 | issue | SO-260825-743 | MAIN | 8 | 33.10 | -264.77 | 16 | 529.53 | July 16, 2026: 8 @ 33.10 |
| Aug. 24, 2026 | issue | SO-260824-625 | EAST | 2 | 33.10 | -66.19 | 24 | 794.30 | July 16, 2026: 2 @ 33.10 |
| Aug. 21, 2026 | issue | SO-260821-110 | MAIN | 3 | 33.10 | -99.29 | 26 | 860.49 | July 16, 2026: 3 @ 33.10 |
| Aug. 9, 2026 | issue | SO-260809-294 | MAIN | 3 | 33.10 | -99.29 | 29 | 959.78 | July 16, 2026: 3 @ 33.10 |
| Aug. 7, 2026 | issue | SO-260807-517 | MAIN | 1 | 33.10 | -33.10 | 32 | 1,059.07 | July 16, 2026: 1 @ 33.10 |
| Aug. 2, 2026 | issue | SO-260802-950 | EAST | 1 | 33.10 | -33.10 | 33 | 1,092.16 | July 16, 2026: 1 @ 33.10 |
| July 16, 2026 | transfer | TRF | MAIN → EAST | 8 | warehouse transfer, no cost effect | ||||
| July 16, 2026 | receipt | PO-001649 | MAIN | 34 | 33.10 | 1,125.26 | 34 | 1,125.26 | |
| July 15, 2026 | issue | SO-260715-478 | EAST | 7 | 32.73 | -229.09 | 0 | 0.00 | May 26, 2026: 7 @ 32.73 |
| July 5, 2026 | issue | SO-260705-211 | EAST | 5 | 32.73 | -163.64 | 7 | 229.09 | May 26, 2026: 5 @ 32.73 |
| June 25, 2026 | issue | SO-260625-112 | EAST | 2 | 32.73 | -65.45 | 12 | 392.73 | May 26, 2026: 2 @ 32.73 |
| June 8, 2026 | issue | SO-260608-339 | EAST | 1 | 32.73 | -32.73 | 14 | 458.18 | May 26, 2026: 1 @ 32.73 |
| June 8, 2026 | issue | SO-260608-339 | MAIN | 19 | 32.73 | -621.82 | 15 | 490.91 | May 26, 2026: 19 @ 32.73 |
| June 2, 2026 | adjustment | Cycle count | MAIN | -2 | 31.88 | -63.76 | 34 | 1,112.73 | May 5, 2026: 1 @ 31.88; May 25, 2026: 1 @ 31.88 |
| May 31, 2026 | issue | SO-260531-138 | MAIN | 5 | 31.88 | -159.40 | 36 | 1,176.49 | April 4, 2026: 4 @ 31.88; April 15, 2026: 1 @ 31.88 |
| May 26, 2026 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| May 26, 2026 | receipt | PO-001525 | MAIN | 34 | 32.73 | 1,112.73 | 41 | 1,335.89 | |
| May 25, 2026 | return | RMA | MAIN | 1 | 31.88 | 31.88 | 7 | 223.16 | |
| May 18, 2026 | issue | SO-260518-532 | EAST | 1 | 31.88 | -31.88 | 6 | 191.28 | April 4, 2026: 1 @ 31.88 |
| May 18, 2026 | issue | SO-260518-532 | MAIN | 4 | 31.88 | -127.52 | 7 | 223.16 | April 4, 2026: 4 @ 31.88 |
| May 13, 2026 | issue | SO-260513-180 | MAIN | 2 | 31.88 | -63.76 | 11 | 350.68 | April 4, 2026: 2 @ 31.88 |
| May 5, 2026 | return | RMA | MAIN | 1 | 31.88 | 31.88 | 13 | 414.43 | |
| May 4, 2026 | issue | SO-260504-558 | MAIN | 15 | 31.88 | -478.19 | 12 | 382.56 | April 4, 2026: 15 @ 31.88 |
| May 1, 2026 | issue | SO-260501-985 | MAIN | 1 | 31.88 | -31.88 | 27 | 860.75 | April 4, 2026: 1 @ 31.88 |
| April 29, 2026 | issue | SO-260429-144 | EAST | 1 | 31.88 | -31.88 | 28 | 892.63 | April 4, 2026: 1 @ 31.88 |
| April 28, 2026 | issue | SO-260428-314 | MAIN | 1 | 31.88 | -31.88 | 29 | 924.51 | April 4, 2026: 1 @ 31.88 |
| April 15, 2026 | return | RMA | MAIN | 1 | 31.88 | 31.88 | 30 | 956.39 | |
| April 13, 2026 | issue | SO-260413-929 | MAIN | 2 | 31.88 | -63.76 | 29 | 924.51 | April 4, 2026: 2 @ 31.88 |
| April 10, 2026 | issue | SO-260410-211 | MAIN | 3 | 31.88 | -95.64 | 31 | 988.27 | April 4, 2026: 3 @ 31.88 |
| April 5, 2026 | issue | SO-260405-645 | MAIN | 1 | 31.06 | -31.06 | 34 | 1,083.91 | Feb. 11, 2026: 1 @ 31.06 |
| April 4, 2026 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| April 4, 2026 | receipt | PO-001385 | MAIN | 34 | 31.88 | 1,083.91 | 35 | 1,114.97 | |
| April 3, 2026 | issue | SO-260403-784 | EAST | 1 | 31.06 | -31.06 | 1 | 31.06 | Feb. 11, 2026: 1 @ 31.06 |
| April 1, 2026 | issue | SO-260401-732 | EAST | 3 | 31.06 | -93.18 | 2 | 62.12 | Feb. 11, 2026: 3 @ 31.06 |
| March 29, 2026 | issue | SO-260329-241 | EAST | 2 | 31.06 | -62.12 | 5 | 155.31 | Feb. 11, 2026: 2 @ 31.06 |
| March 29, 2026 | issue | SO-260329-241 | MAIN | 5 | 31.06 | -155.31 | 7 | 217.43 | Feb. 11, 2026: 5 @ 31.06 |
| March 27, 2026 | issue | SO-260327-378 | MAIN | 6 | 31.06 | -186.37 | 12 | 372.73 | Feb. 11, 2026: 6 @ 31.06 |
| March 10, 2026 | issue | SO-260310-190 | MAIN | 10 | 31.06 | -310.61 | 18 | 559.10 | Feb. 11, 2026: 10 @ 31.06 |
| March 7, 2026 | issue | SO-260307-584 | MAIN | 2 | 31.06 | -62.12 | 28 | 869.71 | Feb. 11, 2026: 2 @ 31.06 |
| Feb. 23, 2026 | issue | SO-260223-522 | MAIN | 1 | 31.06 | -31.06 | 30 | 931.84 | Feb. 11, 2026: 1 @ 31.06 |
| Feb. 11, 2026 | issue | SO-260211-321 | EAST | 3 | 31.06 | -93.18 | 31 | 962.90 | Feb. 11, 2026: 3 @ 31.06 |
| Feb. 11, 2026 | transfer | TRF | MAIN → EAST | 10 | warehouse transfer, no cost effect | ||||
| Feb. 11, 2026 | receipt | PO-001218 | MAIN | 34 | 31.06 | 1,056.08 | 34 | 1,056.08 | |
| Feb. 5, 2026 | issue | SO-260205-485 | MAIN | 11 | 32.13 | -353.42 | 0 | 0.00 | Dec. 14, 2025: 11 @ 32.13 |
| Jan. 31, 2026 | issue | SO-260131-801 | MAIN | 8 | 32.13 | -257.03 | 11 | 353.42 | Dec. 14, 2025: 8 @ 32.13 |
| Jan. 18, 2026 | issue | SO-260118-259 | MAIN | 5 | 32.13 | -160.64 | 19 | 610.45 | Dec. 14, 2025: 5 @ 32.13 |
| Jan. 4, 2026 | issue | SO-260104-761 | MAIN | 2 | 32.13 | -64.26 | 24 | 771.10 | Dec. 14, 2025: 2 @ 32.13 |