Items / SWT-0013
Switch Plate 4M Lite SWT-0013 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)86MAIN 86
Value (FIFO)1,512.20avg 17.58
ClassCX / FCV 0.24
Turnover8.6xlast issue 0 days ago
Days of cover54lead 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 | 48.67 / 30.4375 | 1.599 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 11.71 / 5.517 | 2.123 |
| 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 * 2.123^2 + 1.599^2 * 1.5^2) | 7.8 |
| Reorder point | d * LT + safety stock | 1.599 * 7.0 + 7.8 | 19.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 19.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 584/yr, S = 45.00, h = 20%, price = 16.92 | 320.0 |
| Inventory position | on hand + on order | 86 + 0 | 86 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 17.62 | 122 | 10,713 | yes |
| 320 | 16.92 | 320 | 10,495 | yes (chosen if cheapest) |
| 640 | 16.21 | 640 | 10,539 | yes |
MOQ 160, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 7, 2026 | 86 / 160 | 17.58 | 1,512.20 |
Movement ledger 112 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-137 | MAIN | 10 | 17.58 | -175.84 | 86 | 1,512.20 | Sept. 7, 2026: 10 @ 17.58 |
| Oct. 12, 2026 | issue | SO-261012-168 | MAIN | 28 | 17.58 | -492.34 | 96 | 1,688.04 | Sept. 7, 2026: 28 @ 17.58 |
| Oct. 1, 2026 | issue | SO-261001-811 | MAIN | 7 | 17.58 | -123.09 | 124 | 2,180.38 | Sept. 7, 2026: 7 @ 17.58 |
| Sept. 27, 2026 | issue | SO-260927-710 | MAIN | 5 | 17.58 | -87.92 | 131 | 2,303.46 | Sept. 7, 2026: 5 @ 17.58 |
| Sept. 25, 2026 | issue | SO-260925-474 | MAIN | 6 | 17.58 | -105.50 | 136 | 2,391.38 | Sept. 7, 2026: 6 @ 17.58 |
| Sept. 19, 2026 | issue | SO-260919-526 | MAIN | 9 | 17.58 | -158.25 | 142 | 2,496.89 | Sept. 7, 2026: 9 @ 17.58 |
| Sept. 8, 2026 | issue | SO-260908-841 | MAIN | 9 | 17.58 | -158.25 | 151 | 2,655.14 | Sept. 7, 2026: 9 @ 17.58 |
| Sept. 7, 2026 | receipt | PO-001779 | MAIN | 160 | 17.58 | 2,813.39 | 160 | 2,813.39 | |
| Sept. 3, 2026 | issue | SO-260903-221 | MAIN | 20 | 16.86 | -337.28 | 0 | 0.00 | June 1, 2026: 20 @ 16.86 |
| Aug. 31, 2026 | issue | SO-260831-287 | MAIN | 20 | 16.86 | -337.28 | 20 | 337.28 | June 1, 2026: 20 @ 16.86 |
| Aug. 21, 2026 | issue | SO-260821-902 | MAIN | 6 | 16.86 | -101.18 | 40 | 674.56 | June 1, 2026: 6 @ 16.86 |
| Aug. 18, 2026 | issue | SO-260818-805 | MAIN | 8 | 16.86 | -134.91 | 46 | 775.74 | June 1, 2026: 8 @ 16.86 |
| Aug. 15, 2026 | issue | SO-260815-264 | MAIN | 3 | 16.86 | -50.59 | 54 | 910.66 | June 1, 2026: 3 @ 16.86 |
| Aug. 13, 2026 | issue | SO-260813-997 | MAIN | 1 | 16.86 | -16.86 | 57 | 961.25 | June 1, 2026: 1 @ 16.86 |
| Aug. 2, 2026 | issue | SO-260802-254 | MAIN | 3 | 16.86 | -50.59 | 58 | 978.11 | June 1, 2026: 3 @ 16.86 |
| July 22, 2026 | issue | SO-260722-394 | MAIN | 34 | 16.86 | -573.38 | 61 | 1,028.70 | June 1, 2026: 34 @ 16.86 |
| July 1, 2026 | issue | SO-260701-694 | MAIN | 18 | 16.86 | -303.55 | 95 | 1,602.08 | June 1, 2026: 18 @ 16.86 |
| June 22, 2026 | issue | SO-260622-223 | MAIN | 8 | 16.86 | -134.91 | 113 | 1,905.63 | June 1, 2026: 8 @ 16.86 |
| June 17, 2026 | issue | SO-260617-227 | MAIN | 1 | 16.86 | -16.86 | 121 | 2,040.54 | June 1, 2026: 1 @ 16.86 |
| June 12, 2026 | issue | SO-260612-484 | MAIN | 17 | 16.86 | -286.69 | 122 | 2,057.41 | June 1, 2026: 17 @ 16.86 |
| June 5, 2026 | issue | SO-260605-962 | MAIN | 13 | 16.86 | -219.23 | 139 | 2,344.10 | June 1, 2026: 13 @ 16.86 |
| June 3, 2026 | issue | SO-260603-983 | MAIN | 8 | 16.86 | -134.91 | 152 | 2,563.33 | June 1, 2026: 8 @ 16.86 |
| June 1, 2026 | receipt | PO-001541 | MAIN | 160 | 16.86 | 2,698.24 | 160 | 2,698.24 | |
| May 31, 2026 | issue | SO-260531-458 | MAIN | 6 | 16.77 | -100.63 | 0 | 0.00 | Feb. 23, 2026: 6 @ 16.77 |
| May 25, 2026 | issue | SO-260525-342 | MAIN | 32 | 16.77 | -536.70 | 6 | 100.63 | Feb. 23, 2026: 32 @ 16.77 |
| April 8, 2026 | issue | SO-260408-576 | MAIN | 10 | 16.77 | -167.72 | 38 | 637.33 | Feb. 23, 2026: 10 @ 16.77 |
| April 1, 2026 | issue | SO-260401-724 | MAIN | 56 | 16.77 | -939.22 | 48 | 805.05 | Feb. 23, 2026: 56 @ 16.77 |
| March 28, 2026 | issue | SO-260328-531 | MAIN | 31 | 16.77 | -519.93 | 104 | 1,744.27 | Feb. 23, 2026: 31 @ 16.77 |
| March 14, 2026 | issue | SO-260314-171 | MAIN | 16 | 16.77 | -268.35 | 135 | 2,264.19 | Feb. 23, 2026: 16 @ 16.77 |
| Feb. 27, 2026 | issue | SO-260227-203 | MAIN | 10 | 16.76 | -167.56 | 151 | 2,532.54 | Dec. 3, 2025: 1 @ 16.61; Feb. 23, 2026: 9 @ 16.77 |
| Feb. 23, 2026 | receipt | PO-001255 | MAIN | 160 | 16.77 | 2,683.49 | 161 | 2,700.10 | |
| Feb. 21, 2026 | issue | SO-260221-762 | MAIN | 7 | 16.60 | -116.18 | 1 | 16.61 | Nov. 11, 2025: 4 @ 16.59; Dec. 3, 2025: 3 @ 16.61 |
| Feb. 16, 2026 | issue | SO-260216-750 | MAIN | 17 | 16.59 | -282.01 | 8 | 132.79 | Nov. 11, 2025: 17 @ 16.59 |
| Feb. 10, 2026 | issue | SO-260210-963 | MAIN | 5 | 16.59 | -82.95 | 25 | 414.81 | Nov. 11, 2025: 5 @ 16.59 |
| Feb. 3, 2026 | issue | SO-260203-424 | MAIN | 22 | 16.59 | -364.96 | 30 | 497.75 | Nov. 11, 2025: 22 @ 16.59 |
| Jan. 20, 2026 | issue | SO-260120-862 | MAIN | 18 | 16.59 | -298.60 | 52 | 862.71 | Nov. 11, 2025: 18 @ 16.59 |
| Jan. 15, 2026 | issue | SO-260115-982 | MAIN | 13 | 16.59 | -215.66 | 70 | 1,161.32 | Nov. 11, 2025: 13 @ 16.59 |
| Jan. 4, 2026 | issue | SO-260104-549 | MAIN | 19 | 16.59 | -315.19 | 83 | 1,376.98 | Nov. 11, 2025: 19 @ 16.59 |
| Jan. 2, 2026 | issue | SO-260102-936 | MAIN | 21 | 16.59 | -348.37 | 102 | 1,692.17 | Nov. 11, 2025: 21 @ 16.59 |
| Dec. 24, 2025 | issue | SO-251224-804 | MAIN | 6 | 16.59 | -99.53 | 123 | 2,040.54 | Nov. 11, 2025: 6 @ 16.59 |
| Dec. 12, 2025 | issue | SO-251212-514 | MAIN | 29 | 16.59 | -481.08 | 129 | 2,140.08 | Nov. 11, 2025: 29 @ 16.59 |
| Dec. 3, 2025 | return | RMA | MAIN | 4 | 16.61 | 66.44 | 158 | 2,621.16 | |
| Nov. 30, 2025 | issue | SO-251130-406 | MAIN | 9 | 16.61 | -149.49 | 154 | 2,554.72 | July 11, 2025: 3 @ 16.65; Nov. 11, 2025: 6 @ 16.59 |
| Nov. 17, 2025 | issue | SO-251117-427 | MAIN | 1 | 16.65 | -16.65 | 163 | 2,704.21 | July 11, 2025: 1 @ 16.65 |
| Nov. 11, 2025 | receipt | PO-000994 | MAIN | 160 | 16.59 | 2,654.26 | 164 | 2,720.86 | |
| Nov. 9, 2025 | issue | SO-251109-821 | MAIN | 4 | 16.65 | -66.60 | 4 | 66.60 | July 11, 2025: 4 @ 16.65 |
| Nov. 8, 2025 | issue | SO-251108-651 | MAIN | 4 | 16.65 | -66.60 | 8 | 133.20 | July 11, 2025: 4 @ 16.65 |
| Nov. 4, 2025 | issue | SO-251104-208 | MAIN | 28 | 16.65 | -466.21 | 12 | 199.80 | July 11, 2025: 28 @ 16.65 |
| Oct. 28, 2025 | issue | SO-251028-560 | MAIN | 7 | 16.65 | -116.55 | 40 | 666.01 | July 11, 2025: 7 @ 16.65 |
| Oct. 21, 2025 | issue | SO-251021-900 | MAIN | 1 | 16.65 | -16.65 | 47 | 782.56 | July 11, 2025: 1 @ 16.65 |
| Oct. 20, 2025 | issue | SO-251020-998 | MAIN | 4 | 16.65 | -66.60 | 48 | 799.21 | July 11, 2025: 4 @ 16.65 |
| Oct. 14, 2025 | issue | SO-251014-540 | MAIN | 14 | 16.65 | -233.10 | 52 | 865.81 | July 11, 2025: 14 @ 16.65 |
| Oct. 12, 2025 | issue | SO-251012-953 | MAIN | 3 | 16.65 | -49.95 | 66 | 1,098.91 | July 11, 2025: 3 @ 16.65 |
| Oct. 11, 2025 | issue | SO-251011-619 | MAIN | 3 | 16.65 | -49.95 | 69 | 1,148.86 | July 11, 2025: 3 @ 16.65 |
| Oct. 5, 2025 | issue | SO-251005-203 | MAIN | 3 | 16.65 | -49.95 | 72 | 1,198.81 | July 11, 2025: 3 @ 16.65 |
| Sept. 27, 2025 | issue | SO-250927-231 | MAIN | 5 | 16.65 | -83.25 | 75 | 1,248.76 | July 11, 2025: 5 @ 16.65 |
| Sept. 26, 2025 | issue | SO-250926-817 | MAIN | 1 | 16.65 | -16.65 | 80 | 1,332.02 | July 11, 2025: 1 @ 16.65 |
| Sept. 24, 2025 | issue | SO-250924-129 | MAIN | 36 | 16.65 | -599.41 | 81 | 1,348.67 | July 11, 2025: 36 @ 16.65 |
| Sept. 13, 2025 | issue | SO-250913-877 | MAIN | 8 | 16.65 | -133.20 | 117 | 1,948.07 | July 11, 2025: 8 @ 16.65 |
| Aug. 26, 2025 | issue | SO-250826-752 | MAIN | 17 | 16.65 | -283.05 | 125 | 2,081.28 | July 11, 2025: 17 @ 16.65 |
| Aug. 10, 2025 | issue | SO-250810-342 | MAIN | 12 | 16.65 | -199.80 | 142 | 2,364.33 | July 11, 2025: 12 @ 16.65 |
| July 31, 2025 | issue | SO-250731-416 | MAIN | 9 | 16.61 | -149.49 | 154 | 2,564.13 | April 11, 2025: 3 @ 16.53; July 11, 2025: 6 @ 16.65 |
| July 21, 2025 | issue | SO-250721-941 | MAIN | 11 | 16.53 | -181.83 | 163 | 2,713.62 | April 11, 2025: 11 @ 16.53 |
| July 11, 2025 | receipt | PO-000699 | MAIN | 160 | 16.65 | 2,664.03 | 174 | 2,895.45 | |
| July 4, 2025 | issue | SO-250704-616 | MAIN | 17 | 16.53 | -281.01 | 14 | 231.42 | April 11, 2025: 17 @ 16.53 |
| July 3, 2025 | issue | SO-250703-191 | MAIN | 1 | 16.53 | -16.53 | 31 | 512.43 | April 11, 2025: 1 @ 16.53 |
| July 1, 2025 | issue | SO-250701-903 | MAIN | 19 | 16.53 | -314.07 | 32 | 528.96 | April 11, 2025: 19 @ 16.53 |
| June 30, 2025 | issue | SO-250630-355 | MAIN | 6 | 16.53 | -99.18 | 51 | 843.04 | April 11, 2025: 6 @ 16.53 |
| June 28, 2025 | issue | SO-250628-632 | MAIN | 3 | 16.53 | -49.59 | 57 | 942.22 | April 11, 2025: 3 @ 16.53 |
| June 24, 2025 | issue | SO-250624-159 | MAIN | 1 | 16.53 | -16.53 | 60 | 991.81 | April 11, 2025: 1 @ 16.53 |
| June 22, 2025 | issue | SO-250622-934 | MAIN | 6 | 16.53 | -99.18 | 61 | 1,008.34 | April 11, 2025: 6 @ 16.53 |
| June 21, 2025 | issue | SO-250621-204 | MAIN | 6 | 16.53 | -99.18 | 67 | 1,107.52 | April 11, 2025: 6 @ 16.53 |
| June 9, 2025 | issue | SO-250609-968 | MAIN | 5 | 16.53 | -82.65 | 73 | 1,206.70 | April 11, 2025: 5 @ 16.53 |
| June 2, 2025 | issue | SO-250602-772 | MAIN | 15 | 16.53 | -247.95 | 78 | 1,289.35 | April 11, 2025: 15 @ 16.53 |
| May 31, 2025 | issue | SO-250531-975 | MAIN | 11 | 16.53 | -181.83 | 93 | 1,537.30 | April 11, 2025: 11 @ 16.53 |
| May 30, 2025 | issue | SO-250530-749 | MAIN | 5 | 16.53 | -82.65 | 104 | 1,719.13 | April 11, 2025: 5 @ 16.53 |
| May 15, 2025 | issue | SO-250515-968 | MAIN | 9 | 16.53 | -148.77 | 109 | 1,801.78 | April 11, 2025: 9 @ 16.53 |
| May 11, 2025 | issue | SO-250511-997 | MAIN | 2 | 16.53 | -33.06 | 118 | 1,950.55 | April 11, 2025: 2 @ 16.53 |
| May 6, 2025 | issue | SO-250506-919 | MAIN | 32 | 16.53 | -528.96 | 120 | 1,983.61 | April 11, 2025: 32 @ 16.53 |
| May 5, 2025 | issue | SO-250505-241 | MAIN | 11 | 16.37 | -180.05 | 152 | 2,512.58 | Jan. 9, 2025: 3 @ 15.94; April 11, 2025: 8 @ 16.53 |
| April 24, 2025 | issue | SO-250424-816 | MAIN | 20 | 15.94 | -318.74 | 163 | 2,692.63 | Jan. 9, 2025: 20 @ 15.94 |
| April 11, 2025 | receipt | PO-000438 | MAIN | 160 | 16.53 | 2,644.82 | 183 | 3,011.37 | |
| April 5, 2025 | issue | SO-250405-392 | MAIN | 26 | 15.94 | -414.36 | 23 | 366.55 | Jan. 9, 2025: 26 @ 15.94 |
| March 29, 2025 | issue | SO-250329-984 | MAIN | 3 | 15.94 | -47.81 | 49 | 780.92 | Jan. 9, 2025: 3 @ 15.94 |
| March 27, 2025 | issue | SO-250327-707 | MAIN | 10 | 15.94 | -159.37 | 52 | 828.73 | Jan. 9, 2025: 10 @ 15.94 |
| March 27, 2025 | issue | SO-250327-707 | EAST | 25 | 15.94 | -398.43 | 62 | 988.10 | Jan. 9, 2025: 25 @ 15.94 |
| March 17, 2025 | issue | SO-250317-548 | MAIN | 22 | 15.94 | -350.62 | 87 | 1,386.53 | Jan. 9, 2025: 22 @ 15.94 |
| Feb. 20, 2025 | issue | SO-250220-581 | MAIN | 12 | 15.94 | -191.25 | 109 | 1,737.14 | Jan. 9, 2025: 12 @ 15.94 |
| Feb. 17, 2025 | issue | SO-250217-729 | EAST | 27 | 15.94 | -430.30 | 121 | 1,928.39 | Jan. 9, 2025: 27 @ 15.94 |
| Feb. 12, 2025 | issue | SO-250212-794 | MAIN | 11 | 15.94 | -175.31 | 148 | 2,358.69 | Jan. 9, 2025: 11 @ 15.94 |
| Feb. 1, 2025 | issue | SO-250201-133 | MAIN | 1 | 15.94 | -15.94 | 159 | 2,534.00 | Jan. 9, 2025: 1 @ 15.94 |
| Jan. 22, 2025 | issue | SO-250122-731 | MAIN | 10 | 16.74 | -167.39 | 160 | 2,549.94 | Oct. 1, 2024: 4 @ 16.74; Dec. 8, 2024: 6 @ 16.74 |
| Jan. 19, 2025 | issue | SO-250119-292 | MAIN | 10 | 16.74 | -167.39 | 170 | 2,717.33 | Oct. 1, 2024: 10 @ 16.74 |
| Jan. 9, 2025 | transfer | TRF | MAIN → EAST | 52 | warehouse transfer, no cost effect | ||||
| Jan. 9, 2025 | receipt | PO-000177 | MAIN | 160 | 15.94 | 2,549.94 | 180 | 2,884.72 | |
| Jan. 3, 2025 | issue | SO-250103-679 | MAIN | 29 | 16.74 | -485.43 | 20 | 334.78 | Oct. 1, 2024: 29 @ 16.74 |
| Jan. 3, 2025 | issue | SO-250103-679 | EAST | 23 | 16.74 | -385.00 | 49 | 820.21 | Oct. 1, 2024: 23 @ 16.74 |
| Dec. 28, 2024 | issue | SO-241228-979 | MAIN | 4 | 16.74 | -66.96 | 72 | 1,205.21 | Oct. 1, 2024: 4 @ 16.74 |
| Dec. 11, 2024 | issue | SO-241211-776 | MAIN | 12 | 16.74 | -200.87 | 76 | 1,272.16 | Oct. 1, 2024: 12 @ 16.74 |
| Dec. 8, 2024 | return | RMA | MAIN | 6 | 16.74 | 100.43 | 88 | 1,473.03 | |
| Dec. 8, 2024 | issue | SO-241208-357 | MAIN | 24 | 16.74 | -401.74 | 82 | 1,372.60 | Oct. 1, 2024: 24 @ 16.74 |
| Nov. 22, 2024 | issue | SO-241122-135 | EAST | 13 | 16.74 | -217.61 | 106 | 1,774.33 | Oct. 1, 2024: 13 @ 16.74 |
| Nov. 18, 2024 | issue | SO-241118-482 | MAIN | 5 | 16.74 | -83.70 | 119 | 1,991.94 | Oct. 1, 2024: 5 @ 16.74 |
| Nov. 8, 2024 | issue | SO-241108-827 | MAIN | 3 | 16.74 | -50.22 | 124 | 2,075.64 | Oct. 1, 2024: 3 @ 16.74 |
| Oct. 31, 2024 | issue | SO-241031-493 | MAIN | 11 | 16.74 | -184.13 | 127 | 2,125.85 | Oct. 1, 2024: 11 @ 16.74 |
| Oct. 23, 2024 | issue | SO-241023-156 | MAIN | 1 | 16.74 | -16.74 | 138 | 2,309.98 | Oct. 1, 2024: 1 @ 16.74 |
| Oct. 16, 2024 | issue | SO-241016-108 | EAST | 1 | 16.74 | -16.74 | 139 | 2,326.72 | Oct. 1, 2024: 1 @ 16.74 |
| Oct. 15, 2024 | issue | SO-241015-782 | MAIN | 10 | 16.74 | -167.39 | 140 | 2,343.46 | Oct. 1, 2024: 10 @ 16.74 |
| Oct. 12, 2024 | issue | SO-241012-481 | MAIN | 3 | 16.74 | -50.22 | 150 | 2,510.85 | Oct. 1, 2024: 3 @ 16.74 |
| Oct. 4, 2024 | issue | SO-241004-153 | MAIN | 7 | 16.74 | -117.17 | 153 | 2,561.07 | Oct. 1, 2024: 7 @ 16.74 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 37 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 160 | 16.74 | 2,678.24 | 160 | 2,678.24 | |