Items / LED-0037
Panel Light 15W Prime LED-0037 · Lighting · BrightLine Lighting
On hand (EA)65MAIN 65
Value (FIFO)378.80avg 5.83
ClassCZ / NCV -
Turnover0.0xlast issue 454 days ago
Days of cover-lead time 10d
NRV 3.2841 is below cost: lower-of-cost-or-NRV write-down 165.33.
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 | 0.00 / 30.4375 | 0.000 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 0.00 / 5.517 | 0.000 |
| 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 * 0.000^2 + 0.000^2 * 2.2^2) | 0.0 |
| Reorder point | d * LT + safety stock | 0.000 * 9.6 + 0.0 | 0.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 0/yr, S = 45.00, h = 20%, price = 6.26 | 1.0 |
| Inventory position | on hand + on order | 65 + 0 | 65 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 6.26 | 1 | 1 | yes (chosen if cheapest) |
| 360 | 6.01 | 360 | 216 | yes |
| 720 | 5.76 | 720 | 415 | yes |
MOQ 180, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| April 26, 2025 | 65 / 180 | 5.83 | 378.80 |
Movement ledger 50 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Nov. 22, 2025 | adjustment | Cycle count | MAIN | -1 | 5.83 | -5.83 | 65 | 378.80 | April 26, 2025: 1 @ 5.83 |
| July 19, 2025 | issue | SO-250719-877 | MAIN | 1 | 5.83 | -5.83 | 66 | 384.63 | April 26, 2025: 1 @ 5.83 |
| July 18, 2025 | issue | SO-250718-819 | MAIN | 19 | 5.83 | -110.73 | 67 | 390.46 | April 26, 2025: 19 @ 5.83 |
| July 7, 2025 | issue | SO-250707-175 | MAIN | 1 | 5.83 | -5.83 | 86 | 501.18 | April 26, 2025: 1 @ 5.83 |
| July 4, 2025 | issue | SO-250704-357 | MAIN | 12 | 5.83 | -69.93 | 87 | 507.01 | April 26, 2025: 12 @ 5.83 |
| July 3, 2025 | issue | SO-250703-142 | MAIN | 4 | 5.83 | -23.31 | 99 | 576.94 | April 26, 2025: 4 @ 5.83 |
| June 30, 2025 | issue | SO-250630-658 | MAIN | 7 | 5.83 | -40.79 | 103 | 600.25 | April 26, 2025: 7 @ 5.83 |
| June 28, 2025 | issue | SO-250628-965 | MAIN | 8 | 5.83 | -46.62 | 110 | 641.05 | April 26, 2025: 8 @ 5.83 |
| June 18, 2025 | issue | SO-250618-838 | MAIN | 13 | 5.83 | -75.76 | 118 | 687.67 | April 26, 2025: 13 @ 5.83 |
| June 14, 2025 | issue | SO-250614-217 | MAIN | 4 | 5.83 | -23.31 | 131 | 763.43 | April 26, 2025: 4 @ 5.83 |
| June 9, 2025 | issue | SO-250609-989 | MAIN | 2 | 5.83 | -11.66 | 135 | 786.74 | April 26, 2025: 2 @ 5.83 |
| June 3, 2025 | issue | SO-250603-531 | MAIN | 6 | 5.83 | -34.97 | 137 | 798.39 | April 26, 2025: 6 @ 5.83 |
| May 18, 2025 | issue | SO-250518-332 | MAIN | 7 | 5.83 | -40.79 | 143 | 833.36 | April 26, 2025: 7 @ 5.83 |
| May 16, 2025 | issue | SO-250516-503 | MAIN | 7 | 5.83 | -40.79 | 150 | 874.16 | April 26, 2025: 7 @ 5.83 |
| May 15, 2025 | issue | SO-250515-365 | MAIN | 13 | 5.83 | -75.76 | 157 | 914.95 | April 26, 2025: 13 @ 5.83 |
| May 13, 2025 | issue | SO-250513-992 | MAIN | 8 | 5.83 | -46.62 | 170 | 990.71 | April 26, 2025: 8 @ 5.83 |
| May 1, 2025 | issue | SO-250501-221 | MAIN | 2 | 5.83 | -11.66 | 178 | 1,037.33 | April 26, 2025: 2 @ 5.83 |
| April 26, 2025 | receipt | PO-000483 | MAIN | 180 | 5.83 | 1,048.99 | 180 | 1,048.99 | |
| April 13, 2025 | issue | SO-250413-133 | MAIN | 26 | 5.84 | -151.83 | 0 | 0.00 | Dec. 19, 2024: 26 @ 5.84 |
| April 7, 2025 | issue | SO-250407-729 | MAIN | 4 | 5.84 | -23.36 | 26 | 151.83 | Dec. 19, 2024: 4 @ 5.84 |
| March 30, 2025 | issue | SO-250330-244 | MAIN | 1 | 5.84 | -5.84 | 30 | 175.19 | Dec. 19, 2024: 1 @ 5.84 |
| March 25, 2025 | issue | SO-250325-634 | MAIN | 14 | 5.84 | -81.76 | 31 | 181.03 | Dec. 19, 2024: 14 @ 5.84 |
| March 25, 2025 | issue | SO-250325-634 | EAST | 5 | 5.84 | -29.20 | 45 | 262.79 | Dec. 19, 2024: 5 @ 5.84 |
| March 22, 2025 | issue | SO-250322-637 | EAST | 3 | 5.84 | -17.52 | 50 | 291.99 | Dec. 19, 2024: 3 @ 5.84 |
| March 15, 2025 | issue | SO-250315-757 | MAIN | 2 | 5.84 | -11.68 | 53 | 309.51 | Dec. 19, 2024: 2 @ 5.84 |
| March 13, 2025 | issue | SO-250313-272 | MAIN | 24 | 5.84 | -140.16 | 55 | 321.19 | Dec. 19, 2024: 24 @ 5.84 |
| Feb. 26, 2025 | issue | SO-250226-513 | MAIN | 37 | 5.84 | -216.07 | 79 | 461.34 | Dec. 19, 2024: 37 @ 5.84 |
| Feb. 9, 2025 | issue | SO-250209-722 | EAST | 6 | 5.84 | -35.04 | 116 | 677.42 | Dec. 19, 2024: 6 @ 5.84 |
| Jan. 13, 2025 | issue | SO-250113-491 | EAST | 15 | 5.84 | -87.60 | 122 | 712.46 | Dec. 19, 2024: 15 @ 5.84 |
| Jan. 6, 2025 | issue | SO-250106-485 | EAST | 23 | 5.84 | -134.32 | 137 | 800.05 | Dec. 19, 2024: 23 @ 5.84 |
| Jan. 3, 2025 | issue | SO-250103-906 | MAIN | 9 | 5.84 | -52.56 | 160 | 934.37 | Dec. 19, 2024: 9 @ 5.84 |
| Dec. 30, 2024 | issue | SO-241230-933 | MAIN | 8 | 5.84 | -46.72 | 169 | 986.93 | Dec. 19, 2024: 8 @ 5.84 |
| Dec. 26, 2024 | issue | SO-241226-505 | MAIN | 15 | 5.93 | -88.88 | 177 | 1,033.64 | Oct. 1, 2024: 12 @ 5.95; Dec. 19, 2024: 3 @ 5.84 |
| Dec. 19, 2024 | transfer | TRF | MAIN → EAST | 52 | warehouse transfer, no cost effect | ||||
| Dec. 19, 2024 | receipt | PO-000115 | MAIN | 180 | 5.84 | 1,051.16 | 192 | 1,122.53 | |
| Dec. 15, 2024 | issue | SO-241215-352 | MAIN | 17 | 5.95 | -101.10 | 12 | 71.36 | Oct. 1, 2024: 17 @ 5.95 |
| Dec. 13, 2024 | issue | SO-241213-793 | MAIN | 3 | 5.95 | -17.84 | 29 | 172.46 | Oct. 1, 2024: 3 @ 5.95 |
| Dec. 10, 2024 | issue | SO-241210-483 | MAIN | 15 | 5.95 | -89.20 | 32 | 190.30 | Oct. 1, 2024: 15 @ 5.95 |
| Nov. 19, 2024 | issue | SO-241119-161 | MAIN | 18 | 5.95 | -107.05 | 47 | 279.51 | Oct. 1, 2024: 18 @ 5.95 |
| Nov. 16, 2024 | issue | SO-241116-816 | MAIN | 11 | 5.95 | -65.42 | 65 | 386.56 | Oct. 1, 2024: 11 @ 5.95 |
| Nov. 10, 2024 | issue | SO-241110-269 | MAIN | 18 | 5.95 | -107.05 | 76 | 451.97 | Oct. 1, 2024: 18 @ 5.95 |
| Nov. 6, 2024 | issue | SO-241106-569 | MAIN | 26 | 5.95 | -154.62 | 94 | 559.02 | Oct. 1, 2024: 26 @ 5.95 |
| Oct. 28, 2024 | issue | SO-241028-913 | MAIN | 5 | 5.95 | -29.74 | 120 | 713.64 | Oct. 1, 2024: 5 @ 5.95 |
| Oct. 27, 2024 | issue | SO-241027-724 | MAIN | 6 | 5.95 | -35.68 | 125 | 743.38 | Oct. 1, 2024: 6 @ 5.95 |
| Oct. 26, 2024 | issue | SO-241026-118 | MAIN | 7 | 5.95 | -41.63 | 131 | 779.06 | Oct. 1, 2024: 7 @ 5.95 |
| Oct. 23, 2024 | issue | SO-241023-829 | MAIN | 1 | 5.95 | -5.95 | 138 | 820.69 | Oct. 1, 2024: 1 @ 5.95 |
| Oct. 16, 2024 | issue | SO-241016-765 | MAIN | 2 | 5.95 | -11.89 | 139 | 826.63 | Oct. 1, 2024: 2 @ 5.95 |
| Oct. 14, 2024 | issue | SO-241014-317 | MAIN | 32 | 5.95 | -190.30 | 141 | 838.53 | Oct. 1, 2024: 32 @ 5.95 |
| Oct. 12, 2024 | issue | SO-241012-120 | MAIN | 7 | 5.95 | -41.63 | 173 | 1,028.83 | Oct. 1, 2024: 7 @ 5.95 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 180 | 5.95 | 1,070.46 | 180 | 1,070.46 | |