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
| 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 |
| Aug. 12, 2025 | issue | SO-250812-967 | MAIN | 33 | 25.12 | -829.08 | 162 | 4,070.01 | April 14, 2025: 33 @ 25.12 |
| July 26, 2025 | issue | SO-250726-407 | MAIN | 9 | 25.12 | -226.11 | 195 | 4,899.08 | April 14, 2025: 9 @ 25.12 |
| July 25, 2025 | issue | SO-250725-501 | MAIN | 3 | 25.12 | -75.37 | 204 | 5,125.19 | April 14, 2025: 3 @ 25.12 |
| July 11, 2025 | issue | SO-250711-895 | MAIN | 38 | 25.12 | -954.69 | 207 | 5,200.56 | April 14, 2025: 38 @ 25.12 |
| July 9, 2025 | issue | SO-250709-916 | MAIN | 66 | 25.12 | -1,658.15 | 245 | 6,155.26 | April 14, 2025: 66 @ 25.12 |
| July 2, 2025 | issue | SO-250702-728 | MAIN | 1 | 25.12 | -25.12 | 311 | 7,813.41 | April 14, 2025: 1 @ 25.12 |
| June 24, 2025 | issue | SO-250624-930 | MAIN | 77 | 25.12 | -1,934.51 | 312 | 7,838.53 | April 14, 2025: 77 @ 25.12 |
| June 21, 2025 | issue | SO-250621-853 | MAIN | 6 | 25.12 | -150.74 | 389 | 9,773.04 | April 14, 2025: 6 @ 25.12 |
| June 14, 2025 | issue | SO-250614-725 | MAIN | 52 | 25.12 | -1,306.42 | 395 | 9,923.78 | April 14, 2025: 52 @ 25.12 |
| June 8, 2025 | return | RMA | MAIN | 14 | 25.12 | 351.73 | 447 | 11,230.20 | |
| June 8, 2025 | issue | SO-250608-491 | MAIN | 16 | 25.12 | -401.98 | 433 | 10,878.48 | April 14, 2025: 16 @ 25.12 |
| May 24, 2025 | issue | SO-250524-504 | MAIN | 29 | 25.12 | -728.58 | 449 | 11,280.45 | April 14, 2025: 29 @ 25.12 |
| May 20, 2025 | issue | SO-250520-225 | MAIN | 21 | 25.12 | -527.59 | 478 | 12,009.03 | April 14, 2025: 21 @ 25.12 |
| May 19, 2025 | issue | SO-250519-722 | MAIN | 23 | 25.12 | -577.84 | 499 | 12,536.63 | April 14, 2025: 23 @ 25.12 |
| May 12, 2025 | issue | SO-250512-446 | MAIN | 12 | 25.12 | -301.48 | 522 | 13,114.47 | April 14, 2025: 12 @ 25.12 |
| May 9, 2025 | issue | SO-250509-775 | MAIN | 38 | 25.12 | -954.69 | 534 | 13,415.95 | April 14, 2025: 38 @ 25.12 |
| April 29, 2025 | issue | SO-250429-240 | MAIN | 7 | 25.12 | -175.86 | 572 | 14,370.64 | April 14, 2025: 7 @ 25.12 |
| April 29, 2025 | issue | SO-250429-240 | EAST | 34 | 24.78 | -842.67 | 579 | 14,546.51 | Dec. 26, 2024: 23 @ 24.62; April 14, 2025: 11 @ 25.12 |
| April 26, 2025 | issue | SO-250426-109 | MAIN | 53 | 24.62 | -1,304.98 | 613 | 15,389.18 | Dec. 26, 2024: 53 @ 24.62 |
| April 14, 2025 | receipt | PO-000444 | MAIN | 590 | 25.12 | 14,822.86 | 666 | 16,694.15 | |
| April 2, 2025 | issue | SO-250402-414 | MAIN | 38 | 24.62 | -935.64 | 76 | 1,871.29 | Dec. 26, 2024: 38 @ 24.62 |
| March 30, 2025 | issue | SO-250330-496 | MAIN | 52 | 24.62 | -1,280.35 | 114 | 2,806.93 | Dec. 26, 2024: 52 @ 24.62 |
| March 25, 2025 | issue | SO-250325-350 | MAIN | 25 | 24.62 | -615.56 | 166 | 4,087.29 | Dec. 26, 2024: 25 @ 24.62 |
| March 14, 2025 | issue | SO-250314-931 | EAST | 18 | 24.62 | -443.20 | 191 | 4,702.84 | Dec. 26, 2024: 18 @ 24.62 |
| March 13, 2025 | issue | SO-250313-540 | EAST | 68 | 24.62 | -1,674.31 | 209 | 5,146.04 | Dec. 26, 2024: 68 @ 24.62 |
| March 3, 2025 | issue | SO-250303-649 | MAIN | 8 | 24.62 | -196.98 | 277 | 6,820.35 | Dec. 26, 2024: 8 @ 24.62 |
| Feb. 21, 2025 | issue | SO-250221-606 | MAIN | 1 | 24.62 | -24.62 | 285 | 7,017.33 | Dec. 26, 2024: 1 @ 24.62 |
| Feb. 15, 2025 | issue | SO-250215-928 | EAST | 19 | 24.62 | -467.82 | 286 | 7,041.95 | Dec. 26, 2024: 19 @ 24.62 |
| Feb. 13, 2025 | issue | SO-250213-629 | MAIN | 18 | 24.62 | -443.20 | 305 | 7,509.77 | Dec. 26, 2024: 18 @ 24.62 |
| Feb. 11, 2025 | issue | SO-250211-465 | MAIN | 5 | 24.62 | -123.11 | 323 | 7,952.97 | Dec. 26, 2024: 5 @ 24.62 |
| Feb. 10, 2025 | issue | SO-250210-327 | MAIN | 44 | 24.62 | -1,083.38 | 328 | 8,076.08 | Dec. 26, 2024: 44 @ 24.62 |
| Feb. 5, 2025 | issue | SO-250205-589 | MAIN | 78 | 24.62 | -1,920.53 | 372 | 9,159.46 | Dec. 26, 2024: 78 @ 24.62 |
| Jan. 30, 2025 | issue | SO-250130-603 | MAIN | 4 | 24.62 | -98.49 | 450 | 11,079.99 | Dec. 26, 2024: 4 @ 24.62 |
| Jan. 26, 2025 | issue | SO-250126-595 | MAIN | 48 | 24.62 | -1,181.87 | 454 | 11,178.48 | Dec. 26, 2024: 48 @ 24.62 |
| Jan. 15, 2025 | issue | SO-250115-486 | MAIN | 7 | 24.62 | -172.36 | 502 | 12,360.34 | Dec. 26, 2024: 7 @ 24.62 |
| Jan. 12, 2025 | issue | SO-250112-993 | MAIN | 149 | 24.83 | -3,699.19 | 509 | 12,532.70 | Oct. 1, 2024: 68 @ 25.07; Dec. 26, 2024: 81 @ 24.62 |
| Dec. 26, 2024 | transfer | TRF | MAIN → EAST | 139 | warehouse transfer, no cost effect | ||||
| Dec. 26, 2024 | receipt | PO-000136 | MAIN | 590 | 24.62 | 14,527.10 | 658 | 16,231.89 | |
| Dec. 15, 2024 | issue | SO-241215-408 | MAIN | 79 | 25.07 | -1,980.57 | 68 | 1,704.79 | Oct. 1, 2024: 79 @ 25.07 |
| Dec. 13, 2024 | issue | SO-241213-137 | MAIN | 6 | 25.07 | -150.42 | 147 | 3,685.36 | Oct. 1, 2024: 6 @ 25.07 |
| Dec. 13, 2024 | issue | SO-241213-137 | EAST | 136 | 25.07 | -3,409.59 | 153 | 3,835.79 | Oct. 1, 2024: 136 @ 25.07 |
| Nov. 25, 2024 | issue | SO-241125-977 | EAST | 12 | 25.07 | -300.85 | 289 | 7,245.37 | Oct. 1, 2024: 12 @ 25.07 |
| Nov. 21, 2024 | issue | SO-241121-124 | EAST | 11 | 25.07 | -275.78 | 301 | 7,546.22 | Oct. 1, 2024: 11 @ 25.07 |
| Nov. 20, 2024 | issue | SO-241120-422 | EAST | 32 | 25.07 | -802.26 | 312 | 7,822.00 | Oct. 1, 2024: 32 @ 25.07 |
| Nov. 13, 2024 | issue | SO-241113-491 | MAIN | 93 | 25.07 | -2,331.56 | 344 | 8,624.25 | Oct. 1, 2024: 93 @ 25.07 |
| Nov. 1, 2024 | issue | SO-241101-366 | MAIN | 9 | 25.07 | -225.63 | 437 | 10,955.81 | Oct. 1, 2024: 9 @ 25.07 |
| Oct. 28, 2024 | issue | SO-241028-301 | MAIN | 2 | 25.07 | -50.14 | 446 | 11,181.44 | Oct. 1, 2024: 2 @ 25.07 |
| Oct. 25, 2024 | issue | SO-241025-988 | MAIN | 8 | 25.07 | -200.56 | 448 | 11,231.58 | Oct. 1, 2024: 8 @ 25.07 |
| Oct. 17, 2024 | issue | SO-241017-351 | MAIN | 57 | 25.07 | -1,429.02 | 456 | 11,432.15 | Oct. 1, 2024: 57 @ 25.07 |
| Oct. 11, 2024 | issue | SO-241011-122 | MAIN | 23 | 25.07 | -576.62 | 513 | 12,861.17 | Oct. 1, 2024: 23 @ 25.07 |
| Oct. 6, 2024 | issue | SO-241006-212 | MAIN | 33 | 25.07 | -827.33 | 536 | 13,437.79 | Oct. 1, 2024: 33 @ 25.07 |
| Oct. 1, 2024 | issue | SO-241001-479 | MAIN | 21 | 25.07 | -526.48 | 569 | 14,265.11 | Oct. 1, 2024: 21 @ 25.07 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 191 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 590 | 25.07 | 14,791.60 | 590 | 14,791.60 | |