Items / LED-0002
LED Tube 18W Lite LED-0002 · Lighting · BrightLine Lighting
On hand (EA)82MAIN 59, EAST 23
Value (FIFO)2,213.22avg 26.99
ClassCX / FCV 0.32
Turnover3.2xlast issue 0 days ago
Days of cover110lead 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 | 22.67 / 30.4375 | 0.745 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 7.28 / 5.517 | 1.320 |
| 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(9.6 * 1.320^2 + 0.745^2 * 2.2^2) | 5.6 |
| Reorder point | d * LT + safety stock | 0.745 * 9.6 + 5.6 | 12.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 12.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 272/yr, S = 45.00, h = 20%, price = 26.42 | 68.0 |
| Inventory position | on hand + on order | 82 + 0 | 82 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 26.42 | 68 | 7,541 | yes (chosen if cheapest) |
MOQ 90, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 9, 2026 | 82 / 90 | 26.99 | 2,213.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-150 | MAIN | 7 | 26.99 | -188.93 | 82 | 2,213.22 | Oct. 9, 2026: 7 @ 26.99 |
| Oct. 10, 2026 | issue | SO-261010-919 | EAST | 1 | 26.99 | -26.99 | 89 | 2,402.15 | Oct. 9, 2026: 1 @ 26.99 |
| Oct. 9, 2026 | transfer | TRF | MAIN → EAST | 24 | warehouse transfer, no cost effect | ||||
| Oct. 9, 2026 | receipt | PO-001862 | MAIN | 90 | 26.99 | 2,429.14 | 90 | 2,429.14 | |
| Oct. 5, 2026 | issue | SO-261005-853 | MAIN | 4 | 25.98 | -103.91 | 0 | 0.00 | May 26, 2026: 4 @ 25.98 |
| Oct. 2, 2026 | issue | SO-261002-714 | MAIN | 7 | 25.98 | -181.84 | 4 | 103.91 | May 26, 2026: 7 @ 25.98 |
| Sept. 26, 2026 | issue | SO-260926-863 | MAIN | 14 | 25.98 | -363.67 | 11 | 285.74 | May 26, 2026: 14 @ 25.98 |
| Sept. 14, 2026 | issue | SO-260914-552 | MAIN | 1 | 25.98 | -25.98 | 25 | 649.41 | May 26, 2026: 1 @ 25.98 |
| Sept. 13, 2026 | issue | SO-260913-875 | MAIN | 1 | 25.98 | -25.98 | 26 | 675.39 | May 26, 2026: 1 @ 25.98 |
| Sept. 5, 2026 | issue | SO-260905-259 | MAIN | 7 | 25.98 | -181.84 | 27 | 701.37 | May 26, 2026: 7 @ 25.98 |
| Sept. 4, 2026 | issue | SO-260904-629 | MAIN | 2 | 25.98 | -51.95 | 34 | 883.20 | May 26, 2026: 2 @ 25.98 |
| Aug. 29, 2026 | issue | SO-260829-983 | MAIN | 1 | 25.98 | -25.98 | 36 | 935.15 | May 26, 2026: 1 @ 25.98 |
| Aug. 24, 2026 | issue | SO-260824-762 | MAIN | 1 | 25.98 | -25.98 | 37 | 961.13 | May 26, 2026: 1 @ 25.98 |
| Aug. 23, 2026 | issue | SO-260823-369 | MAIN | 3 | 25.98 | -77.93 | 38 | 987.11 | May 26, 2026: 3 @ 25.98 |
| Aug. 23, 2026 | issue | SO-260823-369 | EAST | 7 | 25.98 | -181.84 | 41 | 1,065.04 | May 26, 2026: 7 @ 25.98 |
| Aug. 15, 2026 | issue | SO-260815-271 | MAIN | 1 | 25.98 | -25.98 | 48 | 1,246.87 | May 26, 2026: 1 @ 25.98 |
| Aug. 10, 2026 | issue | SO-260810-820 | MAIN | 2 | 25.98 | -51.95 | 49 | 1,272.85 | May 26, 2026: 2 @ 25.98 |
| Aug. 7, 2026 | issue | SO-260807-102 | MAIN | 1 | 25.98 | -25.98 | 51 | 1,324.80 | May 26, 2026: 1 @ 25.98 |
| Aug. 1, 2026 | issue | SO-260801-475 | MAIN | 1 | 25.98 | -25.98 | 52 | 1,350.78 | May 26, 2026: 1 @ 25.98 |
| July 27, 2026 | issue | SO-260727-238 | MAIN | 8 | 25.98 | -207.81 | 53 | 1,376.75 | May 26, 2026: 8 @ 25.98 |
| July 9, 2026 | issue | SO-260709-251 | EAST | 6 | 25.98 | -155.86 | 61 | 1,584.57 | May 26, 2026: 6 @ 25.98 |
| July 6, 2026 | issue | SO-260706-310 | EAST | 6 | 25.98 | -155.86 | 67 | 1,740.43 | May 26, 2026: 6 @ 25.98 |
| June 22, 2026 | issue | SO-260622-412 | MAIN | 8 | 25.98 | -207.81 | 73 | 1,896.28 | May 26, 2026: 8 @ 25.98 |
| June 10, 2026 | issue | SO-260610-283 | MAIN | 6 | 25.98 | -155.86 | 81 | 2,104.10 | May 26, 2026: 6 @ 25.98 |
| May 30, 2026 | issue | SO-260530-819 | MAIN | 3 | 25.98 | -77.93 | 87 | 2,259.96 | May 26, 2026: 3 @ 25.98 |
| May 26, 2026 | transfer | TRF | MAIN → EAST | 19 | warehouse transfer, no cost effect | ||||
| May 26, 2026 | receipt | PO-001521 | MAIN | 90 | 25.98 | 2,337.88 | 90 | 2,337.88 | |
| May 23, 2026 | issue | SO-260523-304 | MAIN | 1 | 26.33 | -26.33 | 0 | 0.00 | March 30, 2026: 1 @ 26.33 |
| May 15, 2026 | issue | SO-260515-814 | MAIN | 12 | 26.33 | -315.90 | 1 | 26.33 | Jan. 9, 2026: 10 @ 26.33; Jan. 26, 2026: 1 @ 26.33; March 30, 2026: 1 @ 26.33 |
| April 21, 2026 | issue | SO-260421-513 | MAIN | 14 | 26.33 | -368.55 | 13 | 342.23 | Jan. 9, 2026: 14 @ 26.33 |
| April 12, 2026 | issue | SO-260412-500 | MAIN | 6 | 26.33 | -157.95 | 27 | 710.78 | Jan. 9, 2026: 6 @ 26.33 |
| April 1, 2026 | issue | SO-260401-851 | MAIN | 12 | 26.33 | -315.90 | 33 | 868.73 | Jan. 9, 2026: 12 @ 26.33 |
| March 30, 2026 | return | RMA | MAIN | 2 | 26.33 | 52.65 | 45 | 1,184.63 | |
| March 26, 2026 | issue | SO-260326-975 | MAIN | 1 | 26.33 | -26.33 | 43 | 1,131.98 | Jan. 9, 2026: 1 @ 26.33 |
| March 24, 2026 | issue | SO-260324-847 | MAIN | 1 | 26.33 | -26.33 | 44 | 1,158.31 | Jan. 9, 2026: 1 @ 26.33 |
| March 22, 2026 | issue | SO-260322-658 | MAIN | 9 | 26.33 | -236.93 | 45 | 1,184.63 | Jan. 9, 2026: 9 @ 26.33 |
| March 21, 2026 | issue | SO-260321-172 | MAIN | 1 | 26.33 | -26.33 | 54 | 1,421.56 | Jan. 9, 2026: 1 @ 26.33 |
| March 17, 2026 | issue | SO-260317-522 | MAIN | 4 | 26.33 | -105.30 | 55 | 1,447.89 | Jan. 9, 2026: 4 @ 26.33 |
| Feb. 21, 2026 | issue | SO-260221-629 | MAIN | 4 | 26.33 | -105.30 | 59 | 1,553.19 | Jan. 9, 2026: 4 @ 26.33 |
| Feb. 8, 2026 | issue | SO-260208-827 | MAIN | 7 | 26.33 | -184.28 | 63 | 1,658.49 | Jan. 9, 2026: 7 @ 26.33 |
| Feb. 1, 2026 | issue | SO-260201-719 | MAIN | 1 | 26.33 | -26.33 | 70 | 1,842.76 | Jan. 9, 2026: 1 @ 26.33 |
| Feb. 1, 2026 | issue | SO-260201-719 | EAST | 2 | 26.33 | -52.65 | 71 | 1,869.09 | Jan. 9, 2026: 2 @ 26.33 |
| Jan. 26, 2026 | return | RMA | MAIN | 1 | 26.33 | 26.33 | 73 | 1,921.74 | |
| Jan. 25, 2026 | issue | SO-260125-838 | EAST | 17 | 26.33 | -447.53 | 72 | 1,895.41 | Jan. 9, 2026: 17 @ 26.33 |
| Jan. 16, 2026 | issue | SO-260116-867 | MAIN | 1 | 26.33 | -26.33 | 89 | 2,342.94 | Jan. 9, 2026: 1 @ 26.33 |
| Jan. 11, 2026 | issue | SO-260111-436 | MAIN | 1 | 25.36 | -25.36 | 90 | 2,369.27 | Oct. 9, 2025: 1 @ 25.36 |
| Jan. 9, 2026 | transfer | TRF | MAIN → EAST | 19 | warehouse transfer, no cost effect | ||||
| Jan. 9, 2026 | receipt | PO-001129 | MAIN | 90 | 26.33 | 2,369.27 | 91 | 2,394.63 | |
| Jan. 6, 2026 | issue | SO-260106-154 | MAIN | 1 | 25.36 | -25.36 | 1 | 25.36 | Oct. 9, 2025: 1 @ 25.36 |
| Jan. 3, 2026 | issue | SO-260103-633 | MAIN | 11 | 25.36 | -279.00 | 2 | 50.73 | Oct. 9, 2025: 11 @ 25.36 |
| Jan. 1, 2026 | issue | SO-260101-549 | MAIN | 1 | 25.36 | -25.36 | 13 | 329.73 | Oct. 9, 2025: 1 @ 25.36 |
| Dec. 30, 2025 | issue | SO-251230-575 | MAIN | 4 | 25.36 | -101.45 | 14 | 355.09 | Oct. 9, 2025: 4 @ 25.36 |
| Dec. 22, 2025 | issue | SO-251222-494 | MAIN | 8 | 25.36 | -202.91 | 18 | 456.54 | Oct. 9, 2025: 8 @ 25.36 |
| Dec. 16, 2025 | issue | SO-251216-644 | MAIN | 1 | 25.36 | -25.36 | 26 | 659.45 | Oct. 9, 2025: 1 @ 25.36 |
| Dec. 10, 2025 | issue | SO-251210-105 | MAIN | 10 | 25.36 | -253.64 | 27 | 684.82 | Oct. 9, 2025: 10 @ 25.36 |
| Dec. 10, 2025 | issue | SO-251210-105 | EAST | 6 | 25.36 | -152.18 | 37 | 938.45 | Oct. 9, 2025: 6 @ 25.36 |
| Nov. 27, 2025 | issue | SO-251127-579 | MAIN | 13 | 25.36 | -329.73 | 43 | 1,090.63 | Oct. 9, 2025: 13 @ 25.36 |
| Nov. 3, 2025 | issue | SO-251103-592 | EAST | 20 | 25.36 | -507.27 | 56 | 1,420.36 | Oct. 9, 2025: 20 @ 25.36 |
| Oct. 27, 2025 | issue | SO-251027-102 | MAIN | 1 | 25.36 | -25.36 | 76 | 1,927.63 | Oct. 9, 2025: 1 @ 25.36 |
| Oct. 26, 2025 | issue | SO-251026-420 | EAST | 1 | 25.36 | -25.36 | 77 | 1,953.00 | Oct. 9, 2025: 1 @ 25.36 |