Items / LED-0019
Flood Light 50W Prime LED-0019 · Lighting · BrightLine Lighting
On hand (EA)785MAIN 609, EAST 176
Value (FIFO)6,845.12avg 8.72
ClassBX / FCV 0.26
Turnover4.4xlast issue 2 days ago
Days of cover92lead 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 | 258.92 / 30.4375 | 8.507 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 67.37 / 5.517 | 12.211 |
| 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 * 12.211^2 + 8.507^2 * 2.2^2) | 69.1 |
| Reorder point | d * LT + safety stock | 8.507 * 9.6 + 69.1 | 150.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 150.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 3105/yr, S = 45.00, h = 20%, price = 8.59 | 403.3 |
| Inventory position | on hand + on order | 785 + 0 | 785 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 8.59 | 403 | 27,364 | yes (chosen if cheapest) |
MOQ 1,080, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 12, 2026 | 785 / 1,080 | 8.72 | 6,845.12 |
Movement ledger 109 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | issue | SO-261014-269 | MAIN | 172 | 8.72 | -1,499.82 | 785 | 6,845.12 | Sept. 12, 2026: 172 @ 8.72 |
| Oct. 10, 2026 | issue | SO-261010-644 | EAST | 90 | 8.72 | -784.79 | 957 | 8,344.94 | Sept. 12, 2026: 90 @ 8.72 |
| Sept. 27, 2026 | issue | SO-260927-514 | EAST | 56 | 8.55 | -478.98 | 1,047 | 9,129.74 | April 28, 2026: 23 @ 8.31; Sept. 12, 2026: 33 @ 8.72 |
| Sept. 12, 2026 | transfer | TRF | MAIN → EAST | 322 | warehouse transfer, no cost effect | ||||
| Sept. 12, 2026 | receipt | PO-001791 | MAIN | 1,080 | 8.72 | 9,417.49 | 1,103 | 9,608.72 | |
| Sept. 6, 2026 | issue | SO-260906-954 | MAIN | 139 | 8.31 | -1,155.66 | 23 | 191.22 | April 28, 2026: 139 @ 8.31 |
| Aug. 19, 2026 | issue | SO-260819-499 | MAIN | 39 | 8.31 | -324.25 | 162 | 1,346.88 | April 28, 2026: 39 @ 8.31 |
| Aug. 12, 2026 | issue | SO-260812-823 | MAIN | 261 | 8.31 | -2,169.98 | 201 | 1,671.13 | April 28, 2026: 261 @ 8.31 |
| July 31, 2026 | issue | SO-260731-657 | MAIN | 47 | 8.31 | -390.76 | 462 | 3,841.11 | April 28, 2026: 47 @ 8.31 |
| July 30, 2026 | issue | SO-260730-915 | MAIN | 54 | 8.31 | -448.96 | 509 | 4,231.88 | April 28, 2026: 54 @ 8.31 |
| July 29, 2026 | issue | SO-260729-914 | MAIN | 21 | 8.31 | -174.60 | 563 | 4,680.84 | April 28, 2026: 21 @ 8.31 |
| July 21, 2026 | issue | SO-260721-964 | MAIN | 70 | 8.31 | -581.99 | 584 | 4,855.43 | April 28, 2026: 70 @ 8.31 |
| June 28, 2026 | issue | SO-260628-261 | MAIN | 70 | 8.31 | -581.99 | 654 | 5,437.42 | April 28, 2026: 70 @ 8.31 |
| June 27, 2026 | issue | SO-260627-264 | MAIN | 10 | 8.31 | -83.14 | 724 | 6,019.41 | April 28, 2026: 10 @ 8.31 |
| June 27, 2026 | issue | SO-260627-264 | EAST | 44 | 8.31 | -365.82 | 734 | 6,102.55 | April 28, 2026: 44 @ 8.31 |
| June 7, 2026 | issue | SO-260607-614 | MAIN | 141 | 8.31 | -1,172.29 | 778 | 6,468.37 | April 28, 2026: 141 @ 8.31 |
| May 27, 2026 | issue | SO-260527-758 | MAIN | 32 | 8.31 | -266.05 | 919 | 7,640.66 | April 28, 2026: 32 @ 8.31 |
| May 22, 2026 | issue | SO-260522-977 | EAST | 57 | 8.31 | -473.90 | 951 | 7,906.71 | April 28, 2026: 57 @ 8.31 |
| May 16, 2026 | issue | SO-260516-451 | EAST | 97 | 8.32 | -807.20 | 1,008 | 8,380.61 | April 27, 2026: 25 @ 8.34; April 28, 2026: 72 @ 8.31 |
| May 5, 2026 | issue | SO-260505-988 | MAIN | 5 | 8.34 | -41.72 | 1,105 | 9,187.82 | April 27, 2026: 5 @ 8.34 |
| April 30, 2026 | issue | SO-260430-869 | EAST | 104 | 8.34 | -867.72 | 1,110 | 9,229.53 | Dec. 11, 2025: 44 @ 8.34; Jan. 25, 2026: 39 @ 8.34; April 27, 2026: 21 @ 8.34 |
| April 28, 2026 | transfer | TRF | MAIN → EAST | 302 | warehouse transfer, no cost effect | ||||
| April 28, 2026 | receipt | PO-001444 | MAIN | 1,080 | 8.31 | 8,979.23 | 1,214 | 10,097.26 | |
| April 27, 2026 | return | RMA | MAIN | 51 | 8.34 | 425.52 | 134 | 1,118.03 | |
| April 23, 2026 | issue | SO-260423-278 | MAIN | 1 | 8.34 | -8.34 | 83 | 692.51 | Dec. 11, 2025: 1 @ 8.34 |
| April 21, 2026 | issue | SO-260421-954 | MAIN | 103 | 8.34 | -859.38 | 84 | 700.85 | Dec. 11, 2025: 103 @ 8.34 |
| April 20, 2026 | issue | SO-260420-624 | MAIN | 41 | 8.34 | -342.08 | 187 | 1,560.23 | Dec. 11, 2025: 41 @ 8.34 |
| April 18, 2026 | issue | SO-260418-473 | MAIN | 21 | 8.34 | -175.21 | 228 | 1,902.32 | Dec. 11, 2025: 21 @ 8.34 |
| April 17, 2026 | issue | SO-260417-756 | MAIN | 7 | 8.34 | -58.40 | 249 | 2,077.53 | Dec. 11, 2025: 7 @ 8.34 |
| April 16, 2026 | issue | SO-260416-218 | MAIN | 10 | 8.34 | -83.44 | 256 | 2,135.94 | Dec. 11, 2025: 10 @ 8.34 |
| March 23, 2026 | issue | SO-260323-679 | MAIN | 25 | 8.34 | -208.59 | 266 | 2,219.37 | Dec. 11, 2025: 25 @ 8.34 |
| March 20, 2026 | issue | SO-260320-549 | MAIN | 68 | 8.34 | -567.36 | 291 | 2,427.96 | Dec. 11, 2025: 68 @ 8.34 |
| March 11, 2026 | issue | SO-260311-712 | MAIN | 61 | 8.34 | -508.95 | 359 | 2,995.32 | Dec. 11, 2025: 61 @ 8.34 |
| Feb. 27, 2026 | issue | SO-260227-867 | MAIN | 63 | 8.34 | -525.64 | 420 | 3,504.27 | Dec. 11, 2025: 63 @ 8.34 |
| Feb. 15, 2026 | issue | SO-260215-592 | MAIN | 162 | 8.34 | -1,351.65 | 483 | 4,029.91 | Dec. 11, 2025: 162 @ 8.34 |
| Jan. 30, 2026 | issue | SO-260130-879 | MAIN | 82 | 8.34 | -684.17 | 645 | 5,381.56 | Dec. 11, 2025: 82 @ 8.34 |
| Jan. 29, 2026 | issue | SO-260129-302 | MAIN | 51 | 8.34 | -425.52 | 727 | 6,065.72 | Dec. 11, 2025: 51 @ 8.34 |
| Jan. 25, 2026 | return | RMA | MAIN | 39 | 8.34 | 325.40 | 778 | 6,491.24 | |
| Jan. 17, 2026 | issue | SO-260117-314 | MAIN | 120 | 8.34 | -1,001.22 | 739 | 6,165.85 | Dec. 11, 2025: 120 @ 8.34 |
| Jan. 15, 2026 | issue | SO-260115-398 | MAIN | 79 | 8.34 | -659.14 | 859 | 7,167.07 | Dec. 11, 2025: 79 @ 8.34 |
| Jan. 13, 2026 | issue | SO-260113-499 | MAIN | 22 | 8.34 | -183.56 | 938 | 7,826.20 | Dec. 11, 2025: 22 @ 8.34 |
| Jan. 11, 2026 | issue | SO-260111-151 | MAIN | 9 | 8.34 | -75.09 | 960 | 8,009.76 | Dec. 11, 2025: 9 @ 8.34 |
| Jan. 5, 2026 | issue | SO-260105-159 | MAIN | 15 | 8.34 | -125.15 | 969 | 8,084.85 | Dec. 11, 2025: 15 @ 8.34 |
| Dec. 29, 2025 | issue | SO-251229-321 | MAIN | 96 | 8.34 | -800.98 | 984 | 8,210.00 | Dec. 11, 2025: 96 @ 8.34 |
| Dec. 11, 2025 | receipt | PO-001043 | MAIN | 1,080 | 8.34 | 9,010.98 | 1,080 | 9,010.98 | |
| Dec. 7, 2025 | issue | SO-251207-424 | MAIN | 132 | 8.19 | -1,080.67 | 0 | 0.00 | Aug. 29, 2025: 132 @ 8.19 |
| Dec. 5, 2025 | issue | SO-251205-956 | MAIN | 101 | 8.19 | -826.88 | 132 | 1,080.67 | Aug. 29, 2025: 101 @ 8.19 |
| Nov. 30, 2025 | issue | SO-251130-478 | MAIN | 43 | 8.19 | -352.04 | 233 | 1,907.55 | Aug. 29, 2025: 43 @ 8.19 |
| Nov. 28, 2025 | issue | SO-251128-721 | MAIN | 7 | 8.19 | -57.31 | 276 | 2,259.58 | Aug. 29, 2025: 7 @ 8.19 |
| Nov. 20, 2025 | issue | SO-251120-619 | MAIN | 68 | 8.19 | -556.71 | 283 | 2,316.89 | Aug. 29, 2025: 68 @ 8.19 |
| Nov. 16, 2025 | issue | SO-251116-805 | MAIN | 125 | 8.19 | -1,023.36 | 351 | 2,873.60 | Aug. 29, 2025: 125 @ 8.19 |
| Nov. 15, 2025 | issue | SO-251115-919 | MAIN | 9 | 8.19 | -73.68 | 476 | 3,896.96 | Aug. 29, 2025: 9 @ 8.19 |
| Nov. 5, 2025 | issue | SO-251105-738 | MAIN | 24 | 8.19 | -196.49 | 485 | 3,970.65 | Aug. 29, 2025: 24 @ 8.19 |
| Nov. 2, 2025 | issue | SO-251102-417 | MAIN | 98 | 8.19 | -802.32 | 509 | 4,167.13 | Aug. 29, 2025: 98 @ 8.19 |
| Oct. 17, 2025 | issue | SO-251017-690 | MAIN | 13 | 8.19 | -106.43 | 607 | 4,969.45 | Aug. 29, 2025: 13 @ 8.19 |
| Oct. 14, 2025 | issue | SO-251014-348 | MAIN | 155 | 8.19 | -1,268.97 | 620 | 5,075.88 | Aug. 29, 2025: 155 @ 8.19 |
| Oct. 10, 2025 | issue | SO-251010-457 | MAIN | 125 | 8.19 | -1,023.36 | 775 | 6,344.85 | Aug. 29, 2025: 125 @ 8.19 |
| Oct. 3, 2025 | issue | SO-251003-990 | MAIN | 14 | 8.19 | -114.62 | 900 | 7,368.21 | Aug. 29, 2025: 14 @ 8.19 |
| Sept. 30, 2025 | issue | SO-250930-481 | MAIN | 125 | 8.19 | -1,023.36 | 914 | 7,482.83 | Aug. 29, 2025: 125 @ 8.19 |
| Sept. 28, 2025 | issue | SO-250928-514 | MAIN | 53 | 8.15 | -431.95 | 1,039 | 8,506.19 | March 29, 2025: 12 @ 8.02; Aug. 29, 2025: 41 @ 8.19 |
| Sept. 22, 2025 | issue | SO-250922-232 | MAIN | 121 | 8.02 | -970.87 | 1,092 | 8,938.14 | March 29, 2025: 121 @ 8.02 |
| Aug. 29, 2025 | receipt | PO-000800 | MAIN | 1,080 | 8.19 | 8,841.85 | 1,213 | 9,909.00 | |
| Aug. 25, 2025 | issue | SO-250825-518 | MAIN | 15 | 8.02 | -120.36 | 133 | 1,067.15 | March 29, 2025: 15 @ 8.02 |
| Aug. 16, 2025 | issue | SO-250816-983 | MAIN | 9 | 8.02 | -72.21 | 148 | 1,187.51 | March 29, 2025: 9 @ 8.02 |
| Aug. 14, 2025 | issue | SO-250814-339 | MAIN | 222 | 8.02 | -1,781.26 | 157 | 1,259.72 | March 29, 2025: 222 @ 8.02 |
| July 13, 2025 | issue | SO-250713-922 | MAIN | 122 | 8.02 | -978.89 | 379 | 3,040.98 | March 29, 2025: 122 @ 8.02 |
| July 11, 2025 | issue | SO-250711-970 | MAIN | 35 | 8.02 | -280.83 | 501 | 4,019.87 | March 29, 2025: 35 @ 8.02 |
| July 1, 2025 | issue | SO-250701-983 | MAIN | 4 | 8.02 | -32.09 | 536 | 4,300.70 | March 29, 2025: 4 @ 8.02 |
| June 30, 2025 | issue | SO-250630-135 | MAIN | 43 | 8.02 | -345.02 | 540 | 4,332.80 | March 29, 2025: 43 @ 8.02 |
| June 25, 2025 | issue | SO-250625-237 | MAIN | 84 | 8.02 | -673.99 | 583 | 4,677.82 | March 29, 2025: 84 @ 8.02 |
| June 17, 2025 | issue | SO-250617-554 | MAIN | 64 | 8.02 | -513.52 | 667 | 5,351.81 | March 29, 2025: 64 @ 8.02 |
| May 19, 2025 | issue | SO-250519-375 | MAIN | 95 | 8.02 | -762.25 | 731 | 5,865.32 | March 29, 2025: 95 @ 8.02 |
| May 18, 2025 | issue | SO-250518-701 | MAIN | 13 | 8.02 | -104.31 | 826 | 6,627.58 | March 29, 2025: 13 @ 8.02 |
| May 13, 2025 | issue | SO-250513-137 | MAIN | 93 | 8.02 | -746.20 | 839 | 6,731.88 | March 29, 2025: 93 @ 8.02 |
| May 12, 2025 | issue | SO-250512-995 | MAIN | 40 | 8.02 | -320.95 | 932 | 7,478.09 | March 29, 2025: 40 @ 8.02 |
| May 6, 2025 | issue | SO-250506-411 | MAIN | 16 | 8.02 | -128.38 | 972 | 7,799.04 | March 29, 2025: 16 @ 8.02 |
| April 28, 2025 | issue | SO-250428-907 | MAIN | 15 | 8.02 | -120.36 | 988 | 7,927.42 | March 29, 2025: 15 @ 8.02 |
| April 22, 2025 | issue | SO-250422-737 | MAIN | 37 | 8.02 | -296.88 | 1,003 | 8,047.77 | March 29, 2025: 37 @ 8.02 |
| April 16, 2025 | issue | SO-250416-331 | MAIN | 31 | 8.02 | -248.73 | 1,040 | 8,344.65 | March 29, 2025: 31 @ 8.02 |
| April 8, 2025 | issue | SO-250408-333 | MAIN | 29 | 8.13 | -235.69 | 1,071 | 8,593.38 | Dec. 19, 2024: 20 @ 8.17; March 29, 2025: 9 @ 8.02 |
| April 7, 2025 | issue | SO-250407-908 | MAIN | 36 | 8.17 | -294.26 | 1,100 | 8,829.08 | Dec. 19, 2024: 36 @ 8.17 |
| April 2, 2025 | issue | SO-250402-147 | MAIN | 17 | 8.17 | -138.96 | 1,136 | 9,123.34 | Dec. 19, 2024: 17 @ 8.17 |
| March 29, 2025 | receipt | PO-000390 | MAIN | 1,080 | 8.02 | 8,665.60 | 1,153 | 9,262.30 | |
| March 20, 2025 | issue | SO-250320-936 | MAIN | 191 | 8.17 | -1,561.23 | 73 | 596.70 | Dec. 19, 2024: 191 @ 8.17 |
| March 13, 2025 | issue | SO-250313-305 | MAIN | 11 | 8.17 | -89.91 | 264 | 2,157.94 | Dec. 19, 2024: 11 @ 8.17 |
| March 12, 2025 | issue | SO-250312-251 | MAIN | 3 | 8.17 | -24.52 | 275 | 2,247.85 | Dec. 19, 2024: 3 @ 8.17 |
| March 6, 2025 | issue | SO-250306-115 | MAIN | 31 | 8.17 | -253.39 | 278 | 2,272.37 | Dec. 19, 2024: 31 @ 8.17 |
| March 5, 2025 | issue | SO-250305-329 | MAIN | 19 | 8.17 | -155.31 | 309 | 2,525.77 | Dec. 19, 2024: 19 @ 8.17 |
| Feb. 27, 2025 | issue | SO-250227-450 | MAIN | 176 | 8.17 | -1,438.62 | 328 | 2,681.07 | Dec. 19, 2024: 176 @ 8.17 |
| Feb. 23, 2025 | issue | SO-250223-635 | MAIN | 75 | 8.17 | -613.05 | 504 | 4,119.70 | Dec. 19, 2024: 75 @ 8.17 |
| Feb. 17, 2025 | issue | SO-250217-953 | MAIN | 70 | 8.17 | -572.18 | 579 | 4,732.75 | Dec. 19, 2024: 70 @ 8.17 |
| Feb. 2, 2025 | issue | SO-250202-963 | MAIN | 25 | 8.17 | -204.35 | 649 | 5,304.93 | Dec. 19, 2024: 25 @ 8.17 |
| Jan. 24, 2025 | issue | SO-250124-858 | MAIN | 193 | 8.17 | -1,577.58 | 674 | 5,509.28 | Dec. 19, 2024: 193 @ 8.17 |
| Jan. 9, 2025 | issue | SO-250109-429 | MAIN | 91 | 8.17 | -743.83 | 867 | 7,086.86 | Dec. 19, 2024: 91 @ 8.17 |
| Jan. 6, 2025 | issue | SO-250106-296 | MAIN | 30 | 8.17 | -245.22 | 958 | 7,830.69 | Dec. 19, 2024: 30 @ 8.17 |
| Jan. 3, 2025 | issue | SO-250103-555 | MAIN | 7 | 8.17 | -57.22 | 988 | 8,075.91 | Dec. 19, 2024: 7 @ 8.17 |
| Dec. 19, 2024 | issue | SO-241219-238 | MAIN | 100 | 8.17 | -817.20 | 995 | 8,133.13 | Nov. 6, 2024: 15 @ 8.16; Dec. 19, 2024: 85 @ 8.17 |
| Dec. 19, 2024 | receipt | PO-000116 | MAIN | 1,080 | 8.17 | 8,827.92 | 1,095 | 8,950.33 | |
| Dec. 10, 2024 | issue | SO-241210-346 | MAIN | 132 | 8.16 | -1,077.19 | 15 | 122.41 | Oct. 1, 2024: 112 @ 8.16; Nov. 6, 2024: 20 @ 8.16 |
| Dec. 8, 2024 | issue | SO-241208-277 | MAIN | 142 | 8.16 | -1,158.79 | 147 | 1,199.59 | Oct. 1, 2024: 142 @ 8.16 |
| Nov. 23, 2024 | issue | SO-241123-177 | MAIN | 94 | 8.16 | -767.09 | 289 | 2,358.38 | Oct. 1, 2024: 94 @ 8.16 |
| Nov. 21, 2024 | issue | SO-241121-681 | MAIN | 11 | 8.16 | -89.77 | 383 | 3,125.47 | Oct. 1, 2024: 11 @ 8.16 |
| Nov. 19, 2024 | issue | SO-241119-396 | MAIN | 174 | 8.16 | -1,419.93 | 394 | 3,215.24 | Oct. 1, 2024: 174 @ 8.16 |
| Nov. 17, 2024 | issue | SO-241117-967 | MAIN | 67 | 8.16 | -546.75 | 568 | 4,635.16 | Oct. 1, 2024: 67 @ 8.16 |
| Nov. 6, 2024 | return | RMA | MAIN | 35 | 8.16 | 285.62 | 635 | 5,181.92 | |
| Oct. 26, 2024 | issue | SO-241026-819 | MAIN | 48 | 8.16 | -391.70 | 600 | 4,896.30 | Oct. 1, 2024: 48 @ 8.16 |
| Oct. 24, 2024 | issue | SO-241024-471 | MAIN | 71 | 8.16 | -579.40 | 648 | 5,288.00 | Oct. 1, 2024: 71 @ 8.16 |
| Oct. 18, 2024 | issue | SO-241018-179 | MAIN | 361 | 8.16 | -2,945.94 | 719 | 5,867.40 | Oct. 1, 2024: 361 @ 8.16 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 1,080 | 8.16 | 8,813.34 | 1,080 | 8,813.34 | |