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, latest 60 shown - show all
| 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 |