Items / LED-0031
LED Tube 18W Classic LED-0031 · Lighting · BrightLine Lighting
On hand (EA)166MAIN 135, EAST 31
Value (FIFO)10,736.42avg 64.68
ClassBX / FCV 0.27
Turnover3.4xlast issue 0 days ago
Days of cover134lead 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 | 37.58 / 30.4375 | 1.235 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 10.26 / 5.517 | 1.859 |
| 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 * 1.859^2 + 1.235^2 * 2.2^2) | 10.4 |
| Reorder point | d * LT + safety stock | 1.235 * 9.6 + 10.4 | 22.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 22.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 451/yr, S = 45.00, h = 20%, price = 65.52 | 55.6 |
| Inventory position | on hand + on order | 166 + 0 | 166 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 65.52 | 56 | 30,258 | yes (chosen if cheapest) |
| 340 | 62.90 | 340 | 30,546 | yes |
| 680 | 60.28 | 680 | 31,296 | yes |
MOQ 170, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 16, 2026 | 166 / 170 | 64.68 | 10,736.42 |
Movement ledger 129 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-171 | EAST | 4 | 64.68 | -258.71 | 166 | 10,736.42 | Oct. 16, 2026: 4 @ 64.68 |
| Oct. 16, 2026 | transfer | TRF | MAIN → EAST | 35 | warehouse transfer, no cost effect | ||||
| Oct. 16, 2026 | receipt | PO-001883 | MAIN | 170 | 64.68 | 10,995.12 | 170 | 10,995.12 | |
| Oct. 15, 2026 | issue | SO-261015-665 | MAIN | 4 | 63.10 | -252.41 | 0 | 0.00 | Oct. 1, 2026: 4 @ 63.10 |
| Oct. 11, 2026 | issue | SO-261011-348 | MAIN | 12 | 64.35 | -772.20 | 4 | 252.41 | May 15, 2026: 2 @ 63.10; May 22, 2026: 9 @ 64.77; Oct. 1, 2026: 1 @ 63.10 |
| Oct. 8, 2026 | issue | SO-261008-901 | MAIN | 7 | 63.10 | -441.72 | 16 | 1,024.62 | May 15, 2026: 7 @ 63.10 |
| Oct. 4, 2026 | issue | SO-261004-526 | MAIN | 17 | 63.10 | -1,072.76 | 23 | 1,466.34 | May 15, 2026: 17 @ 63.10 |
| Oct. 1, 2026 | return | RMA | MAIN | 5 | 63.10 | 315.52 | 40 | 2,539.10 | |
| Sept. 28, 2026 | issue | SO-260928-921 | MAIN | 7 | 63.10 | -441.72 | 35 | 2,223.58 | May 15, 2026: 7 @ 63.10 |
| Sept. 26, 2026 | issue | SO-260926-914 | MAIN | 10 | 63.10 | -631.04 | 42 | 2,665.31 | May 15, 2026: 10 @ 63.10 |
| Sept. 15, 2026 | issue | SO-260915-147 | MAIN | 4 | 63.10 | -252.41 | 52 | 3,296.34 | May 15, 2026: 4 @ 63.10 |
| Sept. 12, 2026 | issue | SO-260912-544 | MAIN | 6 | 63.10 | -378.62 | 56 | 3,548.76 | May 15, 2026: 6 @ 63.10 |
| Sept. 9, 2026 | issue | SO-260909-601 | MAIN | 23 | 63.10 | -1,451.38 | 62 | 3,927.38 | May 15, 2026: 23 @ 63.10 |
| Aug. 31, 2026 | issue | SO-260831-425 | MAIN | 5 | 63.10 | -315.52 | 85 | 5,378.76 | May 15, 2026: 5 @ 63.10 |
| Aug. 31, 2026 | issue | SO-260831-425 | EAST | 4 | 63.10 | -252.41 | 90 | 5,694.27 | May 15, 2026: 4 @ 63.10 |
| Aug. 24, 2026 | issue | SO-260824-147 | MAIN | 1 | 63.10 | -63.10 | 94 | 5,946.69 | May 15, 2026: 1 @ 63.10 |
| Aug. 16, 2026 | issue | SO-260816-800 | EAST | 3 | 63.10 | -189.31 | 95 | 6,009.79 | May 15, 2026: 3 @ 63.10 |
| Aug. 8, 2026 | issue | SO-260808-778 | MAIN | 15 | 63.10 | -946.55 | 98 | 6,199.10 | May 15, 2026: 15 @ 63.10 |
| July 27, 2026 | issue | SO-260727-543 | MAIN | 3 | 63.10 | -189.31 | 113 | 7,145.66 | May 15, 2026: 3 @ 63.10 |
| July 25, 2026 | issue | SO-260725-703 | MAIN | 9 | 63.10 | -567.93 | 116 | 7,334.97 | May 15, 2026: 9 @ 63.10 |
| July 15, 2026 | issue | SO-260715-476 | MAIN | 10 | 63.10 | -631.04 | 125 | 7,902.90 | May 15, 2026: 10 @ 63.10 |
| July 11, 2026 | issue | SO-260711-289 | MAIN | 4 | 63.10 | -252.41 | 135 | 8,533.93 | May 15, 2026: 4 @ 63.10 |
| July 9, 2026 | issue | SO-260709-374 | MAIN | 5 | 63.10 | -315.52 | 139 | 8,786.35 | May 15, 2026: 5 @ 63.10 |
| June 30, 2026 | issue | SO-260630-648 | EAST | 22 | 63.10 | -1,388.28 | 144 | 9,101.86 | May 15, 2026: 22 @ 63.10 |
| June 16, 2026 | issue | SO-260616-903 | EAST | 13 | 63.10 | -820.35 | 166 | 10,490.14 | May 15, 2026: 13 @ 63.10 |
| May 22, 2026 | return | RMA | MAIN | 9 | 64.77 | 582.89 | 179 | 11,310.49 | |
| May 15, 2026 | transfer | TRF | MAIN → EAST | 42 | warehouse transfer, no cost effect | ||||
| May 15, 2026 | receipt | PO-001495 | MAIN | 170 | 63.10 | 10,727.60 | 170 | 10,727.60 | |
| May 11, 2026 | issue | SO-260511-586 | MAIN | 18 | 64.77 | -1,165.78 | 0 | 0.00 | Dec. 20, 2025: 18 @ 64.77 |
| May 4, 2026 | issue | SO-260504-500 | MAIN | 7 | 64.77 | -453.36 | 18 | 1,165.78 | Dec. 20, 2025: 7 @ 64.77 |
| April 20, 2026 | issue | SO-260420-970 | MAIN | 27 | 64.77 | -1,748.67 | 25 | 1,619.14 | Dec. 20, 2025: 27 @ 64.77 |
| April 20, 2026 | issue | SO-260420-970 | EAST | 5 | 64.77 | -323.83 | 52 | 3,367.82 | Dec. 20, 2025: 5 @ 64.77 |
| April 3, 2026 | issue | SO-260403-330 | MAIN | 2 | 64.77 | -129.53 | 57 | 3,691.64 | Dec. 20, 2025: 2 @ 64.77 |
| March 30, 2026 | issue | SO-260330-322 | EAST | 7 | 64.77 | -453.36 | 59 | 3,821.18 | Dec. 20, 2025: 7 @ 64.77 |
| March 18, 2026 | issue | SO-260318-362 | MAIN | 18 | 64.77 | -1,165.78 | 66 | 4,274.54 | Dec. 20, 2025: 18 @ 64.77 |
| March 12, 2026 | issue | SO-260312-772 | EAST | 6 | 64.77 | -388.59 | 84 | 5,440.32 | Dec. 20, 2025: 6 @ 64.77 |
| March 5, 2026 | issue | SO-260305-994 | MAIN | 6 | 64.77 | -388.59 | 90 | 5,828.91 | Dec. 20, 2025: 6 @ 64.77 |
| Feb. 14, 2026 | issue | SO-260214-820 | EAST | 1 | 64.77 | -64.77 | 96 | 6,217.51 | Dec. 20, 2025: 1 @ 64.77 |
| Feb. 10, 2026 | issue | SO-260210-153 | MAIN | 9 | 64.77 | -582.89 | 97 | 6,282.27 | Dec. 20, 2025: 9 @ 64.77 |
| Feb. 7, 2026 | issue | SO-260207-503 | MAIN | 2 | 64.77 | -129.53 | 106 | 6,865.16 | Dec. 20, 2025: 2 @ 64.77 |
| Feb. 4, 2026 | issue | SO-260204-501 | MAIN | 27 | 64.77 | -1,748.67 | 108 | 6,994.70 | Dec. 20, 2025: 27 @ 64.77 |
| Jan. 31, 2026 | issue | SO-260131-871 | EAST | 2 | 64.77 | -129.53 | 135 | 8,743.37 | Dec. 20, 2025: 2 @ 64.77 |
| Jan. 30, 2026 | issue | SO-260130-537 | MAIN | 16 | 64.77 | -1,036.25 | 137 | 8,872.90 | Dec. 20, 2025: 16 @ 64.77 |
| Jan. 19, 2026 | issue | SO-260119-859 | MAIN | 4 | 64.77 | -259.06 | 153 | 9,909.15 | Dec. 20, 2025: 4 @ 64.77 |
| Jan. 17, 2026 | issue | SO-260117-360 | EAST | 2 | 64.77 | -129.53 | 157 | 10,168.21 | Dec. 20, 2025: 2 @ 64.77 |
| Jan. 10, 2026 | issue | SO-260110-519 | EAST | 14 | 64.48 | -902.69 | 159 | 10,297.75 | Sept. 1, 2025: 3 @ 63.42; Dec. 20, 2025: 11 @ 64.77 |
| Dec. 27, 2025 | issue | SO-251227-296 | EAST | 21 | 63.42 | -1,331.90 | 173 | 11,200.44 | Sept. 1, 2025: 21 @ 63.42 |
| Dec. 20, 2025 | transfer | TRF | MAIN → EAST | 58 | warehouse transfer, no cost effect | ||||
| Dec. 20, 2025 | receipt | PO-001068 | MAIN | 170 | 64.77 | 11,010.17 | 194 | 12,532.34 | |
| Dec. 13, 2025 | issue | SO-251213-358 | MAIN | 2 | 63.42 | -126.85 | 24 | 1,522.18 | Sept. 1, 2025: 2 @ 63.42 |
| Dec. 12, 2025 | issue | SO-251212-768 | MAIN | 1 | 63.42 | -63.42 | 26 | 1,649.02 | Sept. 1, 2025: 1 @ 63.42 |
| Dec. 10, 2025 | issue | SO-251210-208 | MAIN | 9 | 63.42 | -570.82 | 27 | 1,712.45 | Sept. 1, 2025: 9 @ 63.42 |
| Dec. 7, 2025 | issue | SO-251207-962 | MAIN | 5 | 63.42 | -317.12 | 36 | 2,283.26 | Sept. 1, 2025: 5 @ 63.42 |
| Nov. 29, 2025 | issue | SO-251129-341 | MAIN | 7 | 63.42 | -443.97 | 41 | 2,600.38 | Sept. 1, 2025: 7 @ 63.42 |
| Nov. 16, 2025 | issue | SO-251116-563 | MAIN | 6 | 63.42 | -380.54 | 48 | 3,044.35 | Sept. 1, 2025: 6 @ 63.42 |
| Nov. 16, 2025 | issue | SO-251116-563 | EAST | 23 | 63.42 | -1,458.75 | 54 | 3,424.90 | Sept. 1, 2025: 23 @ 63.42 |
| Nov. 2, 2025 | issue | SO-251102-887 | EAST | 21 | 63.42 | -1,331.90 | 77 | 4,883.65 | Sept. 1, 2025: 21 @ 63.42 |
| Oct. 25, 2025 | issue | SO-251025-867 | MAIN | 13 | 63.42 | -824.51 | 98 | 6,215.55 | Sept. 1, 2025: 13 @ 63.42 |
| Oct. 22, 2025 | issue | SO-251022-176 | MAIN | 2 | 63.42 | -126.85 | 111 | 7,040.06 | Sept. 1, 2025: 2 @ 63.42 |
| Oct. 20, 2025 | issue | SO-251020-372 | MAIN | 2 | 63.42 | -126.85 | 113 | 7,166.91 | Sept. 1, 2025: 2 @ 63.42 |