Items / LED-0020
Flood Light 50W Elite LED-0020 · Lighting · BrightLine Lighting
On hand (EA)381MAIN 381
Value (FIFO)10,113.00avg 26.54
ClassAX / FCV 0.19
Turnover4.7xlast issue 3 days ago
Days of cover86lead 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 | 134.42 / 30.4375 | 4.416 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 25.58 / 5.517 | 4.637 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(9.6 * 4.637^2 + 4.416^2 * 2.2^2) | 35.4 |
| Reorder point | d * LT + safety stock | 4.416 * 9.6 + 35.4 | 77.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 77.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1612/yr, S = 45.00, h = 20%, price = 26.39 | 165.8 |
| Inventory position | on hand + on order | 381 + 0 | 381 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 26.39 | 166 | 43,413 | yes (chosen if cheapest) |
MOQ 590, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 8, 2026 | 381 / 590 | 26.54 | 10,113.00 |
Movement ledger 114 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 13, 2026 | issue | SO-261013-815 | MAIN | 22 | 26.54 | -583.95 | 381 | 10,113.00 | Sept. 8, 2026: 22 @ 26.54 |
| Oct. 11, 2026 | issue | SO-261011-215 | MAIN | 13 | 26.54 | -345.06 | 403 | 10,696.95 | Sept. 8, 2026: 13 @ 26.54 |
| Oct. 6, 2026 | issue | SO-261006-505 | MAIN | 97 | 26.54 | -2,574.70 | 416 | 11,042.01 | Sept. 8, 2026: 97 @ 26.54 |
| Oct. 3, 2026 | issue | SO-261003-886 | MAIN | 86 | 26.50 | -2,278.70 | 513 | 13,616.71 | May 6, 2026: 9 @ 26.10; Sept. 8, 2026: 77 @ 26.54 |
| Sept. 25, 2026 | issue | SO-260925-819 | MAIN | 1 | 26.10 | -26.10 | 599 | 15,895.41 | May 6, 2026: 1 @ 26.10 |
| Sept. 19, 2026 | issue | SO-260919-203 | MAIN | 27 | 26.10 | -704.59 | 600 | 15,921.51 | May 6, 2026: 27 @ 26.10 |
| Sept. 8, 2026 | receipt | PO-001781 | MAIN | 590 | 26.54 | 15,660.55 | 627 | 16,626.10 | |
| Sept. 3, 2026 | issue | SO-260903-980 | MAIN | 82 | 26.10 | -2,139.86 | 37 | 965.55 | May 6, 2026: 82 @ 26.10 |
| Sept. 1, 2026 | issue | SO-260901-700 | MAIN | 10 | 26.10 | -260.96 | 119 | 3,105.41 | May 6, 2026: 10 @ 26.10 |
| Aug. 29, 2026 | issue | SO-260829-877 | MAIN | 19 | 26.10 | -495.82 | 129 | 3,366.37 | May 6, 2026: 19 @ 26.10 |
| Aug. 26, 2026 | issue | SO-260826-376 | MAIN | 88 | 26.10 | -2,296.44 | 148 | 3,862.19 | May 6, 2026: 88 @ 26.10 |
| Aug. 20, 2026 | issue | SO-260820-817 | MAIN | 13 | 26.10 | -339.25 | 236 | 6,158.63 | May 6, 2026: 13 @ 26.10 |
| Aug. 15, 2026 | issue | SO-260815-897 | MAIN | 23 | 26.10 | -600.21 | 249 | 6,497.88 | May 6, 2026: 23 @ 26.10 |
| July 31, 2026 | issue | SO-260731-556 | MAIN | 21 | 26.10 | -548.01 | 272 | 7,098.08 | May 6, 2026: 21 @ 26.10 |
| July 30, 2026 | issue | SO-260730-846 | MAIN | 4 | 26.10 | -104.38 | 293 | 7,646.10 | May 6, 2026: 4 @ 26.10 |
| July 25, 2026 | issue | SO-260725-460 | MAIN | 28 | 26.10 | -730.69 | 297 | 7,750.48 | May 6, 2026: 28 @ 26.10 |
| July 21, 2026 | issue | SO-260721-141 | MAIN | 45 | 26.10 | -1,174.32 | 325 | 8,481.17 | May 6, 2026: 45 @ 26.10 |
| July 16, 2026 | issue | SO-260716-489 | MAIN | 21 | 26.10 | -548.01 | 370 | 9,655.48 | May 6, 2026: 21 @ 26.10 |
| July 4, 2026 | issue | SO-260704-336 | MAIN | 32 | 26.10 | -835.07 | 391 | 10,203.50 | May 6, 2026: 32 @ 26.10 |
| June 25, 2026 | issue | SO-260625-681 | MAIN | 25 | 26.10 | -652.40 | 423 | 11,038.57 | May 6, 2026: 25 @ 26.10 |
| June 20, 2026 | issue | SO-260620-858 | MAIN | 11 | 26.10 | -287.05 | 448 | 11,690.96 | May 6, 2026: 11 @ 26.10 |
| June 18, 2026 | issue | SO-260618-687 | MAIN | 37 | 26.10 | -965.55 | 459 | 11,978.02 | May 6, 2026: 37 @ 26.10 |
| June 14, 2026 | issue | SO-260614-608 | MAIN | 25 | 26.10 | -652.40 | 496 | 12,943.57 | May 6, 2026: 25 @ 26.10 |
| June 3, 2026 | issue | SO-260603-314 | MAIN | 26 | 26.10 | -678.49 | 521 | 13,595.96 | May 6, 2026: 26 @ 26.10 |
| May 25, 2026 | issue | SO-260525-203 | MAIN | 7 | 26.10 | -182.67 | 547 | 14,274.46 | May 6, 2026: 7 @ 26.10 |
| May 21, 2026 | issue | SO-260521-366 | MAIN | 17 | 26.10 | -443.63 | 554 | 14,457.13 | May 6, 2026: 17 @ 26.10 |
| May 17, 2026 | issue | SO-260517-404 | MAIN | 6 | 26.10 | -156.58 | 571 | 14,900.76 | May 6, 2026: 6 @ 26.10 |
| May 12, 2026 | issue | SO-260512-999 | MAIN | 31 | 25.63 | -794.44 | 577 | 15,057.33 | Jan. 25, 2026: 16 @ 25.29; Jan. 29, 2026: 2 @ 25.29; May 6, 2026: 13 @ 26.10 |
| May 8, 2026 | issue | SO-260508-420 | MAIN | 40 | 25.29 | -1,011.54 | 608 | 15,851.78 | Jan. 25, 2026: 40 @ 25.29 |
| May 6, 2026 | receipt | PO-001467 | MAIN | 590 | 26.10 | 15,396.58 | 648 | 16,863.32 | |
| May 2, 2026 | issue | SO-260502-234 | MAIN | 1 | 25.29 | -25.29 | 58 | 1,466.74 | Jan. 25, 2026: 1 @ 25.29 |
| April 26, 2026 | issue | SO-260426-892 | MAIN | 79 | 25.29 | -1,997.80 | 59 | 1,492.03 | Dec. 17, 2025: 55 @ 25.29; Jan. 25, 2026: 24 @ 25.29 |
| April 23, 2026 | issue | SO-260423-603 | MAIN | 9 | 25.29 | -227.60 | 138 | 3,489.83 | Dec. 17, 2025: 9 @ 25.29 |
| April 7, 2026 | issue | SO-260407-220 | MAIN | 7 | 25.29 | -177.02 | 147 | 3,717.42 | Dec. 17, 2025: 7 @ 25.29 |
| March 8, 2026 | issue | SO-260308-296 | MAIN | 14 | 25.29 | -354.04 | 154 | 3,894.44 | Dec. 17, 2025: 14 @ 25.29 |
| March 3, 2026 | issue | SO-260303-960 | MAIN | 156 | 25.29 | -3,945.02 | 168 | 4,248.48 | Dec. 17, 2025: 156 @ 25.29 |
| Feb. 28, 2026 | issue | SO-260228-635 | MAIN | 24 | 25.29 | -606.93 | 324 | 8,193.51 | Dec. 17, 2025: 24 @ 25.29 |
| Feb. 26, 2026 | issue | SO-260226-492 | MAIN | 28 | 25.29 | -708.08 | 348 | 8,800.43 | Dec. 17, 2025: 28 @ 25.29 |
| Feb. 26, 2026 | issue | SO-260226-492 | EAST | 22 | 25.29 | -556.35 | 376 | 9,508.51 | Dec. 17, 2025: 22 @ 25.29 |
| Feb. 12, 2026 | issue | SO-260212-938 | MAIN | 10 | 25.29 | -252.89 | 398 | 10,064.86 | Dec. 17, 2025: 10 @ 25.29 |
| Feb. 9, 2026 | issue | SO-260209-207 | MAIN | 70 | 25.29 | -1,770.20 | 408 | 10,317.75 | Dec. 17, 2025: 70 @ 25.29 |
| Jan. 29, 2026 | return | RMA | MAIN | 2 | 25.29 | 50.58 | 478 | 12,087.95 | |
| Jan. 26, 2026 | issue | SO-260126-626 | MAIN | 5 | 25.29 | -126.44 | 476 | 12,037.37 | Dec. 17, 2025: 5 @ 25.29 |
| Jan. 25, 2026 | return | RMA | MAIN | 81 | 25.29 | 2,048.38 | 481 | 12,163.82 | |
| Jan. 17, 2026 | issue | SO-260117-723 | MAIN | 22 | 25.29 | -556.35 | 400 | 10,115.44 | Dec. 17, 2025: 22 @ 25.29 |
| Jan. 8, 2026 | issue | SO-260108-667 | EAST | 162 | 25.29 | -4,096.75 | 422 | 10,671.79 | Dec. 17, 2025: 162 @ 25.29 |
| Dec. 21, 2025 | issue | SO-251221-610 | MAIN | 6 | 25.29 | -151.73 | 584 | 14,768.54 | Dec. 17, 2025: 6 @ 25.29 |
| Dec. 17, 2025 | transfer | TRF | MAIN → EAST | 184 | warehouse transfer, no cost effect | ||||
| Dec. 17, 2025 | receipt | PO-001057 | MAIN | 590 | 25.29 | 14,920.27 | 590 | 14,920.27 | |
| Dec. 6, 2025 | issue | SO-251206-707 | MAIN | 171 | 24.48 | -4,186.64 | 0 | 0.00 | Aug. 25, 2025: 171 @ 24.48 |
| Nov. 23, 2025 | issue | SO-251123-296 | MAIN | 13 | 24.48 | -318.28 | 171 | 4,186.64 | Aug. 25, 2025: 13 @ 24.48 |
| Nov. 22, 2025 | issue | SO-251122-546 | MAIN | 10 | 24.48 | -244.83 | 184 | 4,504.93 | Aug. 25, 2025: 10 @ 24.48 |
| Nov. 5, 2025 | issue | SO-251105-963 | MAIN | 68 | 24.48 | -1,664.86 | 194 | 4,749.76 | Aug. 25, 2025: 68 @ 24.48 |
| Nov. 3, 2025 | issue | SO-251103-942 | MAIN | 32 | 24.48 | -783.47 | 262 | 6,414.62 | Aug. 25, 2025: 32 @ 24.48 |
| Oct. 27, 2025 | issue | SO-251027-900 | MAIN | 133 | 24.48 | -3,256.28 | 294 | 7,198.09 | Aug. 25, 2025: 133 @ 24.48 |
| Oct. 8, 2025 | issue | SO-251008-659 | MAIN | 8 | 24.48 | -195.87 | 427 | 10,454.37 | Aug. 25, 2025: 8 @ 24.48 |
| Oct. 4, 2025 | issue | SO-251004-472 | MAIN | 7 | 24.48 | -171.38 | 435 | 10,650.24 | Aug. 25, 2025: 7 @ 24.48 |
| Sept. 19, 2025 | issue | SO-250919-338 | MAIN | 190 | 24.62 | -4,678.72 | 442 | 10,821.62 | April 14, 2025: 28 @ 25.12; June 8, 2025: 14 @ 25.12; Aug. 25, 2025: 148 @ 24.48 |
| Aug. 25, 2025 | receipt | PO-000794 | MAIN | 590 | 24.48 | 14,445.15 | 632 | 15,500.33 | |
| Aug. 14, 2025 | issue | SO-250814-786 | MAIN | 120 | 25.12 | -3,014.82 | 42 | 1,055.19 | April 14, 2025: 120 @ 25.12 |