Items / LED-0024
LED Tube 18W Plus LED-0024 · Lighting · BrightLine Lighting
On hand (EA)96MAIN 96
Value (FIFO)1,795.56avg 18.70
ClassBX / FCV 0.34
Turnover7.8xlast issue 0 days ago
Days of cover35lead time 10d
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 | 82.42 / 30.4375 | 2.708 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 27.87 / 5.517 | 5.052 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(9.6 * 5.052^2 + 2.708^2 * 2.2^2) | 27.5 |
| Reorder point | d * LT + safety stock | 2.708 * 9.6 + 27.5 | 53.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 53.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 988/yr, S = 45.00, h = 20%, price = 18.84 | 153.6 |
| Inventory position | on hand + on order | 96 + 0 | 96 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 18.84 | 154 | 19,199 | yes (chosen if cheapest) |
MOQ 310, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 17, 2026 | 90 / 310 | 18.70 | 1,683.33 | |
| Sept. 13, 2026 | 6 / 6 | 18.70 | 112.22 |
Movement ledger 126 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-654 | MAIN | 11 | 18.70 | -205.74 | 96 | 1,795.56 | Aug. 17, 2026: 11 @ 18.70 |
| Oct. 7, 2026 | issue | SO-261007-425 | MAIN | 41 | 18.70 | -766.85 | 107 | 2,001.30 | Aug. 17, 2026: 41 @ 18.70 |
| Oct. 6, 2026 | issue | SO-261006-575 | MAIN | 8 | 18.70 | -149.63 | 148 | 2,768.15 | Aug. 17, 2026: 8 @ 18.70 |
| Oct. 4, 2026 | issue | SO-261004-851 | MAIN | 3 | 18.70 | -56.11 | 156 | 2,917.78 | Aug. 17, 2026: 3 @ 18.70 |
| Oct. 3, 2026 | issue | SO-261003-612 | MAIN | 2 | 18.70 | -37.41 | 159 | 2,973.89 | Aug. 17, 2026: 2 @ 18.70 |
| Oct. 2, 2026 | issue | SO-261002-622 | MAIN | 26 | 18.70 | -486.30 | 161 | 3,011.30 | Aug. 17, 2026: 26 @ 18.70 |
| Sept. 29, 2026 | issue | SO-260929-798 | MAIN | 11 | 18.70 | -205.74 | 187 | 3,497.59 | Aug. 17, 2026: 11 @ 18.70 |
| Sept. 21, 2026 | adjustment | Cycle count | MAIN | -2 | 18.70 | -37.41 | 198 | 3,703.33 | Aug. 17, 2026: 2 @ 18.70 |
| Sept. 17, 2026 | issue | SO-260917-442 | MAIN | 14 | 18.70 | -261.85 | 200 | 3,740.74 | Aug. 17, 2026: 14 @ 18.70 |
| Sept. 13, 2026 | return | RMA | MAIN | 6 | 18.70 | 112.22 | 214 | 4,002.59 | |
| Sept. 11, 2026 | issue | SO-260911-163 | MAIN | 6 | 18.70 | -112.22 | 208 | 3,890.37 | Aug. 17, 2026: 6 @ 18.70 |
| Sept. 9, 2026 | issue | SO-260909-772 | MAIN | 67 | 18.70 | -1,253.15 | 214 | 4,002.59 | Aug. 17, 2026: 67 @ 18.70 |
| Aug. 31, 2026 | issue | SO-260831-484 | MAIN | 15 | 18.70 | -280.56 | 281 | 5,255.74 | Aug. 17, 2026: 15 @ 18.70 |
| Aug. 26, 2026 | issue | SO-260826-594 | MAIN | 13 | 18.70 | -243.15 | 296 | 5,536.30 | Aug. 17, 2026: 13 @ 18.70 |
| Aug. 20, 2026 | issue | SO-260820-163 | MAIN | 14 | 18.88 | -264.36 | 309 | 5,779.44 | March 18, 2026: 13 @ 18.90; Aug. 17, 2026: 1 @ 18.70 |
| Aug. 17, 2026 | receipt | PO-001723 | MAIN | 310 | 18.70 | 5,798.15 | 323 | 6,043.81 | |
| Aug. 13, 2026 | issue | SO-260813-930 | MAIN | 10 | 18.90 | -188.97 | 13 | 245.66 | March 18, 2026: 10 @ 18.90 |
| Aug. 5, 2026 | issue | SO-260805-266 | MAIN | 19 | 18.90 | -359.04 | 23 | 434.63 | March 18, 2026: 19 @ 18.90 |
| July 31, 2026 | issue | SO-260731-750 | MAIN | 7 | 18.90 | -132.28 | 42 | 793.67 | March 18, 2026: 7 @ 18.90 |
| July 26, 2026 | issue | SO-260726-460 | MAIN | 5 | 18.90 | -94.48 | 49 | 925.95 | March 18, 2026: 5 @ 18.90 |
| July 25, 2026 | issue | SO-260725-982 | MAIN | 8 | 18.90 | -151.18 | 54 | 1,020.44 | March 18, 2026: 8 @ 18.90 |
| July 24, 2026 | issue | SO-260724-776 | MAIN | 4 | 18.90 | -75.59 | 62 | 1,171.61 | March 18, 2026: 4 @ 18.90 |
| July 16, 2026 | issue | SO-260716-551 | MAIN | 30 | 18.90 | -566.91 | 66 | 1,247.20 | March 18, 2026: 30 @ 18.90 |
| July 7, 2026 | issue | SO-260707-544 | MAIN | 7 | 18.90 | -132.28 | 96 | 1,814.11 | March 18, 2026: 7 @ 18.90 |
| July 4, 2026 | issue | SO-260704-942 | MAIN | 5 | 18.90 | -94.48 | 103 | 1,946.39 | March 18, 2026: 5 @ 18.90 |
| June 30, 2026 | issue | SO-260630-117 | MAIN | 17 | 18.90 | -321.25 | 108 | 2,040.88 | March 18, 2026: 17 @ 18.90 |
| June 24, 2026 | issue | SO-260624-221 | MAIN | 8 | 18.90 | -151.18 | 125 | 2,362.12 | March 18, 2026: 8 @ 18.90 |
| June 12, 2026 | issue | SO-260612-359 | MAIN | 18 | 18.90 | -340.15 | 133 | 2,513.30 | March 18, 2026: 18 @ 18.90 |
| June 8, 2026 | issue | SO-260608-284 | MAIN | 21 | 18.90 | -396.84 | 151 | 2,853.45 | March 18, 2026: 21 @ 18.90 |
| May 29, 2026 | issue | SO-260529-594 | MAIN | 51 | 18.90 | -963.75 | 172 | 3,250.28 | March 18, 2026: 51 @ 18.90 |
| May 22, 2026 | issue | SO-260522-974 | MAIN | 7 | 18.90 | -132.28 | 223 | 4,214.03 | March 18, 2026: 7 @ 18.90 |
| April 30, 2026 | issue | SO-260430-634 | MAIN | 1 | 18.90 | -18.90 | 230 | 4,346.31 | March 18, 2026: 1 @ 18.90 |
| April 28, 2026 | issue | SO-260428-785 | MAIN | 31 | 18.90 | -585.81 | 231 | 4,365.21 | March 18, 2026: 31 @ 18.90 |
| April 21, 2026 | issue | SO-260421-497 | MAIN | 31 | 18.90 | -585.81 | 262 | 4,951.01 | March 18, 2026: 31 @ 18.90 |
| April 13, 2026 | issue | SO-260413-626 | MAIN | 12 | 18.90 | -226.76 | 293 | 5,536.82 | March 18, 2026: 12 @ 18.90 |
| April 8, 2026 | issue | SO-260408-763 | MAIN | 2 | 18.90 | -37.79 | 305 | 5,763.58 | March 18, 2026: 2 @ 18.90 |
| March 23, 2026 | issue | SO-260323-668 | MAIN | 5 | 18.37 | -91.85 | 307 | 5,801.38 | Nov. 17, 2025: 2 @ 17.58; March 18, 2026: 3 @ 18.90 |
| March 20, 2026 | issue | SO-260320-506 | MAIN | 5 | 17.96 | -89.80 | 312 | 5,893.23 | Nov. 15, 2025: 5 @ 17.96 |
| March 18, 2026 | issue | SO-260318-935 | MAIN | 4 | 17.96 | -71.84 | 317 | 5,983.02 | Nov. 15, 2025: 4 @ 17.96 |
| March 18, 2026 | receipt | PO-001331 | MAIN | 310 | 18.90 | 5,858.07 | 321 | 6,054.86 | |
| March 14, 2026 | issue | SO-260314-692 | MAIN | 26 | 17.96 | -466.95 | 11 | 196.79 | Nov. 15, 2025: 26 @ 17.96 |
| March 10, 2026 | issue | SO-260310-933 | MAIN | 6 | 17.96 | -107.76 | 37 | 663.75 | Nov. 15, 2025: 6 @ 17.96 |
| March 7, 2026 | issue | SO-260307-763 | MAIN | 4 | 17.96 | -71.84 | 43 | 771.50 | Nov. 15, 2025: 4 @ 17.96 |
| Feb. 22, 2026 | issue | SO-260222-775 | MAIN | 21 | 17.96 | -377.15 | 47 | 843.34 | Nov. 15, 2025: 21 @ 17.96 |
| Feb. 18, 2026 | issue | SO-260218-522 | MAIN | 9 | 17.96 | -161.64 | 68 | 1,220.50 | Nov. 15, 2025: 9 @ 17.96 |
| Feb. 17, 2026 | issue | SO-260217-675 | MAIN | 6 | 17.96 | -107.76 | 77 | 1,382.13 | Nov. 15, 2025: 6 @ 17.96 |
| Feb. 13, 2026 | issue | SO-260213-786 | MAIN | 11 | 17.96 | -197.56 | 83 | 1,489.89 | Nov. 15, 2025: 11 @ 17.96 |
| Feb. 11, 2026 | issue | SO-260211-378 | MAIN | 1 | 17.96 | -17.96 | 94 | 1,687.45 | Nov. 15, 2025: 1 @ 17.96 |
| Feb. 10, 2026 | issue | SO-260210-384 | MAIN | 6 | 17.96 | -107.76 | 95 | 1,705.41 | Nov. 15, 2025: 6 @ 17.96 |
| Feb. 5, 2026 | issue | SO-260205-238 | MAIN | 7 | 17.96 | -125.72 | 101 | 1,813.17 | Nov. 15, 2025: 7 @ 17.96 |
| Jan. 26, 2026 | issue | SO-260126-976 | MAIN | 28 | 17.96 | -502.87 | 108 | 1,938.88 | Nov. 15, 2025: 28 @ 17.96 |
| Jan. 9, 2026 | issue | SO-260109-735 | MAIN | 33 | 17.96 | -592.67 | 136 | 2,441.76 | Nov. 15, 2025: 33 @ 17.96 |
| Jan. 5, 2026 | issue | SO-260105-716 | MAIN | 13 | 17.96 | -233.48 | 169 | 3,034.43 | Nov. 15, 2025: 13 @ 17.96 |
| Dec. 31, 2025 | issue | SO-251231-985 | MAIN | 20 | 17.96 | -359.19 | 182 | 3,267.90 | Nov. 15, 2025: 20 @ 17.96 |
| Dec. 30, 2025 | issue | SO-251230-183 | MAIN | 2 | 17.96 | -35.92 | 202 | 3,627.10 | Nov. 15, 2025: 2 @ 17.96 |
| Dec. 27, 2025 | issue | SO-251227-813 | MAIN | 35 | 17.96 | -628.59 | 204 | 3,663.02 | Nov. 15, 2025: 35 @ 17.96 |
| Dec. 20, 2025 | issue | SO-251220-246 | MAIN | 28 | 17.96 | -502.87 | 239 | 4,291.60 | Nov. 15, 2025: 28 @ 17.96 |
| Dec. 16, 2025 | issue | SO-251216-248 | MAIN | 7 | 17.96 | -125.72 | 267 | 4,794.48 | Nov. 15, 2025: 7 @ 17.96 |
| Dec. 9, 2025 | issue | SO-251209-608 | MAIN | 9 | 17.96 | -161.64 | 274 | 4,920.19 | Nov. 15, 2025: 9 @ 17.96 |
| Dec. 9, 2025 | issue | SO-251209-608 | EAST | 17 | 17.96 | -305.31 | 283 | 5,081.83 | Nov. 15, 2025: 17 @ 17.96 |