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, latest 60 shown - show all
| 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 |