Items / LED-0023
Downlight 7W Flex LED-0023 · Lighting · BrightLine Lighting
On hand (EA)259MAIN 259
Value (FIFO)7,063.37avg 27.27
ClassAX / FCV 0.29
Turnover5.4xlast issue 1 days ago
Days of cover47lead 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 | 166.92 / 30.4375 | 5.484 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 47.59 / 5.517 | 8.626 |
| 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 * 8.626^2 + 5.484^2 * 2.2^2) | 60.0 |
| Reorder point | d * LT + safety stock | 5.484 * 9.6 + 60.0 | 112.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 112.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2002/yr, S = 45.00, h = 20%, price = 27.80 | 180.0 |
| Inventory position | on hand + on order | 259 + 0 | 259 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 27.80 | 180 | 56,646 | yes (chosen if cheapest) |
MOQ 620, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 10, 2026 | 259 / 620 | 27.27 | 7,063.37 |
Movement ledger 117 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-783 | MAIN | 46 | 27.27 | -1,254.50 | 259 | 7,063.37 | Sept. 10, 2026: 46 @ 27.27 |
| Oct. 11, 2026 | issue | SO-261011-242 | MAIN | 92 | 27.27 | -2,509.00 | 305 | 8,317.87 | Sept. 10, 2026: 92 @ 27.27 |
| Oct. 6, 2026 | issue | SO-261006-520 | MAIN | 63 | 27.27 | -1,718.12 | 397 | 10,826.86 | Sept. 10, 2026: 63 @ 27.27 |
| Oct. 1, 2026 | issue | SO-261001-959 | MAIN | 17 | 27.27 | -463.62 | 460 | 12,544.98 | Sept. 10, 2026: 17 @ 27.27 |
| Sept. 23, 2026 | issue | SO-260923-943 | MAIN | 2 | 27.27 | -54.54 | 477 | 13,008.60 | Sept. 10, 2026: 2 @ 27.27 |
| Sept. 23, 2026 | issue | SO-260923-943 | EAST | 59 | 27.27 | -1,609.03 | 479 | 13,063.14 | Sept. 10, 2026: 59 @ 27.27 |
| Sept. 20, 2026 | issue | SO-260920-473 | EAST | 33 | 27.27 | -899.97 | 538 | 14,672.17 | Sept. 10, 2026: 33 @ 27.27 |
| Sept. 11, 2026 | issue | SO-260911-720 | EAST | 49 | 27.27 | -1,336.31 | 571 | 15,572.14 | Sept. 10, 2026: 49 @ 27.27 |
| Sept. 10, 2026 | transfer | TRF | MAIN → EAST | 141 | warehouse transfer, no cost effect | ||||
| Sept. 10, 2026 | receipt | PO-001787 | MAIN | 620 | 27.27 | 16,908.45 | 620 | 16,908.45 | |
| Sept. 5, 2026 | issue | SO-260905-964 | MAIN | 9 | 27.78 | -250.01 | 0 | 0.00 | May 18, 2026: 9 @ 27.78 |
| Sept. 2, 2026 | issue | SO-260902-583 | MAIN | 8 | 27.78 | -222.23 | 9 | 250.01 | May 18, 2026: 8 @ 27.78 |
| Sept. 1, 2026 | issue | SO-260901-645 | MAIN | 73 | 27.78 | -2,027.89 | 17 | 472.25 | May 18, 2026: 73 @ 27.78 |
| Aug. 30, 2026 | issue | SO-260830-469 | MAIN | 61 | 27.78 | -1,694.54 | 90 | 2,500.14 | May 18, 2026: 61 @ 27.78 |
| Aug. 26, 2026 | issue | SO-260826-593 | MAIN | 94 | 27.78 | -2,611.25 | 151 | 4,194.67 | May 18, 2026: 94 @ 27.78 |
| Aug. 25, 2026 | issue | SO-260825-335 | MAIN | 1 | 27.78 | -27.78 | 245 | 6,805.93 | May 18, 2026: 1 @ 27.78 |
| Aug. 24, 2026 | issue | SO-260824-857 | MAIN | 71 | 27.78 | -1,972.33 | 246 | 6,833.71 | May 18, 2026: 71 @ 27.78 |
| July 29, 2026 | issue | SO-260729-962 | MAIN | 13 | 27.78 | -361.13 | 317 | 8,806.04 | May 18, 2026: 13 @ 27.78 |
| July 29, 2026 | issue | SO-260729-962 | EAST | 16 | 27.78 | -444.47 | 330 | 9,167.17 | May 18, 2026: 16 @ 27.78 |
| July 26, 2026 | issue | SO-260726-187 | EAST | 6 | 27.78 | -166.68 | 346 | 9,611.64 | May 18, 2026: 6 @ 27.78 |
| July 14, 2026 | issue | SO-260714-420 | EAST | 28 | 27.78 | -777.82 | 352 | 9,778.31 | May 18, 2026: 28 @ 27.78 |
| July 13, 2026 | issue | SO-260713-563 | EAST | 67 | 27.78 | -1,861.21 | 380 | 10,556.13 | May 18, 2026: 67 @ 27.78 |
| June 30, 2026 | issue | SO-260630-482 | EAST | 29 | 27.78 | -805.60 | 447 | 12,417.35 | May 18, 2026: 29 @ 27.78 |
| June 17, 2026 | issue | SO-260617-827 | EAST | 22 | 27.78 | -611.14 | 476 | 13,222.95 | May 18, 2026: 22 @ 27.78 |
| June 16, 2026 | issue | SO-260616-569 | MAIN | 22 | 27.78 | -611.14 | 498 | 13,834.09 | May 18, 2026: 22 @ 27.78 |
| June 8, 2026 | issue | SO-260608-423 | MAIN | 27 | 27.78 | -750.04 | 520 | 14,445.24 | May 18, 2026: 27 @ 27.78 |
| June 5, 2026 | issue | SO-260605-194 | MAIN | 34 | 27.78 | -944.50 | 547 | 15,195.28 | May 18, 2026: 34 @ 27.78 |
| May 26, 2026 | issue | SO-260526-660 | MAIN | 69 | 27.56 | -1,901.36 | 581 | 16,139.77 | Jan. 4, 2026: 30 @ 27.27; May 18, 2026: 39 @ 27.78 |
| May 23, 2026 | issue | SO-260523-911 | EAST | 10 | 27.27 | -272.66 | 650 | 18,041.13 | Jan. 4, 2026: 10 @ 27.27 |
| May 20, 2026 | issue | SO-260520-721 | MAIN | 3 | 27.27 | -81.80 | 660 | 18,313.79 | Jan. 4, 2026: 3 @ 27.27 |
| May 18, 2026 | transfer | TRF | MAIN → EAST | 178 | warehouse transfer, no cost effect | ||||
| May 18, 2026 | receipt | PO-001503 | MAIN | 620 | 27.78 | 17,223.17 | 663 | 18,395.58 | |
| May 8, 2026 | issue | SO-260508-437 | MAIN | 54 | 27.27 | -1,472.34 | 43 | 1,172.42 | Jan. 4, 2026: 54 @ 27.27 |
| April 27, 2026 | issue | SO-260427-899 | MAIN | 34 | 27.27 | -927.03 | 97 | 2,644.75 | Jan. 4, 2026: 34 @ 27.27 |
| April 21, 2026 | issue | SO-260421-298 | MAIN | 10 | 27.27 | -272.66 | 131 | 3,571.78 | Jan. 4, 2026: 10 @ 27.27 |
| April 16, 2026 | issue | SO-260416-858 | MAIN | 26 | 27.27 | -708.90 | 141 | 3,844.44 | Jan. 4, 2026: 26 @ 27.27 |
| April 16, 2026 | issue | SO-260416-858 | EAST | 14 | 27.27 | -381.72 | 167 | 4,553.34 | Jan. 4, 2026: 14 @ 27.27 |
| April 12, 2026 | issue | SO-260412-803 | MAIN | 20 | 27.27 | -545.31 | 181 | 4,935.06 | Jan. 4, 2026: 20 @ 27.27 |
| April 11, 2026 | issue | SO-260411-605 | EAST | 3 | 27.27 | -81.80 | 201 | 5,480.37 | Jan. 4, 2026: 3 @ 27.27 |
| April 2, 2026 | issue | SO-260402-714 | MAIN | 5 | 27.27 | -136.33 | 204 | 5,562.16 | Jan. 4, 2026: 5 @ 27.27 |
| March 29, 2026 | issue | SO-260329-165 | MAIN | 37 | 27.27 | -1,008.82 | 209 | 5,698.49 | Jan. 4, 2026: 37 @ 27.27 |
| March 24, 2026 | issue | SO-260324-784 | MAIN | 23 | 27.27 | -627.11 | 246 | 6,707.31 | Jan. 4, 2026: 23 @ 27.27 |
| March 23, 2026 | issue | SO-260323-615 | MAIN | 3 | 27.27 | -81.80 | 269 | 7,334.42 | Jan. 4, 2026: 3 @ 27.27 |
| March 22, 2026 | issue | SO-260322-221 | EAST | 14 | 27.27 | -381.72 | 272 | 7,416.22 | Jan. 4, 2026: 14 @ 27.27 |
| March 6, 2026 | issue | SO-260306-614 | MAIN | 9 | 27.27 | -245.39 | 286 | 7,797.93 | Jan. 4, 2026: 9 @ 27.27 |
| March 5, 2026 | issue | SO-260305-284 | EAST | 52 | 27.27 | -1,417.81 | 295 | 8,043.32 | Jan. 4, 2026: 52 @ 27.27 |
| Feb. 21, 2026 | issue | SO-260221-538 | EAST | 10 | 27.27 | -272.66 | 347 | 9,461.13 | Jan. 4, 2026: 10 @ 27.27 |
| Feb. 19, 2026 | issue | SO-260219-487 | MAIN | 35 | 27.27 | -954.29 | 357 | 9,733.78 | Jan. 4, 2026: 35 @ 27.27 |
| Feb. 16, 2026 | issue | SO-260216-394 | EAST | 46 | 27.27 | -1,254.21 | 392 | 10,688.08 | Jan. 4, 2026: 46 @ 27.27 |
| Feb. 13, 2026 | issue | SO-260213-721 | MAIN | 10 | 27.27 | -272.66 | 438 | 11,942.29 | Jan. 4, 2026: 10 @ 27.27 |
| Feb. 5, 2026 | issue | SO-260205-961 | MAIN | 15 | 27.27 | -408.98 | 448 | 12,214.94 | Jan. 4, 2026: 15 @ 27.27 |
| Feb. 1, 2026 | issue | SO-260201-420 | MAIN | 86 | 27.27 | -2,344.83 | 463 | 12,623.93 | Jan. 4, 2026: 86 @ 27.27 |
| Jan. 10, 2026 | issue | SO-260110-581 | MAIN | 71 | 27.27 | -1,935.85 | 549 | 14,968.76 | Jan. 4, 2026: 71 @ 27.27 |
| Jan. 4, 2026 | transfer | TRF | MAIN → EAST | 139 | warehouse transfer, no cost effect | ||||
| Jan. 4, 2026 | receipt | PO-001117 | MAIN | 620 | 27.27 | 16,904.61 | 620 | 16,904.61 | |
| Jan. 1, 2026 | issue | SO-260101-218 | EAST | 67 | 26.42 | -1,769.97 | 0 | 0.00 | Sept. 21, 2025: 67 @ 26.42 |
| Jan. 1, 2026 | issue | SO-260101-218 | MAIN | 33 | 26.42 | -871.77 | 67 | 1,769.97 | Sept. 21, 2025: 33 @ 26.42 |
| Dec. 24, 2025 | issue | SO-251224-180 | MAIN | 94 | 26.42 | -2,483.24 | 100 | 2,641.74 | Sept. 21, 2025: 94 @ 26.42 |
| Dec. 19, 2025 | issue | SO-251219-570 | MAIN | 14 | 26.42 | -369.84 | 194 | 5,124.98 | Sept. 21, 2025: 14 @ 26.42 |
| Dec. 15, 2025 | issue | SO-251215-157 | MAIN | 46 | 26.42 | -1,215.20 | 208 | 5,494.82 | Sept. 21, 2025: 46 @ 26.42 |
| Dec. 11, 2025 | issue | SO-251211-268 | EAST | 95 | 26.42 | -2,509.65 | 254 | 6,710.02 | Sept. 21, 2025: 95 @ 26.42 |
| Nov. 30, 2025 | issue | SO-251130-750 | MAIN | 12 | 26.42 | -317.01 | 349 | 9,219.67 | Sept. 21, 2025: 12 @ 26.42 |
| Nov. 18, 2025 | issue | SO-251118-282 | MAIN | 2 | 26.42 | -52.83 | 361 | 9,536.68 | Sept. 21, 2025: 2 @ 26.42 |
| Nov. 14, 2025 | issue | SO-251114-917 | MAIN | 20 | 26.42 | -528.35 | 363 | 9,589.52 | Sept. 21, 2025: 20 @ 26.42 |
| Nov. 10, 2025 | issue | SO-251110-592 | MAIN | 133 | 26.42 | -3,513.51 | 383 | 10,117.86 | Sept. 21, 2025: 133 @ 26.42 |
| Oct. 30, 2025 | issue | SO-251030-399 | EAST | 2 | 26.42 | -52.83 | 516 | 13,631.38 | Sept. 21, 2025: 2 @ 26.42 |
| Oct. 28, 2025 | issue | SO-251028-148 | MAIN | 37 | 26.42 | -977.44 | 518 | 13,684.21 | Sept. 21, 2025: 37 @ 26.42 |
| Oct. 26, 2025 | issue | SO-251026-815 | EAST | 2 | 26.42 | -52.83 | 555 | 14,661.66 | Sept. 21, 2025: 2 @ 26.42 |
| Oct. 16, 2025 | issue | SO-251016-712 | EAST | 3 | 26.42 | -79.25 | 557 | 14,714.49 | Sept. 21, 2025: 3 @ 26.42 |
| Oct. 12, 2025 | issue | SO-251012-389 | MAIN | 29 | 26.42 | -766.10 | 560 | 14,793.74 | Sept. 21, 2025: 29 @ 26.42 |
| Oct. 6, 2025 | issue | SO-251006-229 | EAST | 7 | 26.42 | -184.92 | 589 | 15,559.85 | Sept. 21, 2025: 7 @ 26.42 |
| Oct. 3, 2025 | issue | SO-251003-186 | MAIN | 24 | 26.42 | -634.02 | 596 | 15,744.77 | Sept. 21, 2025: 24 @ 26.42 |
| Sept. 21, 2025 | transfer | TRF | MAIN → EAST | 176 | warehouse transfer, no cost effect | ||||
| Sept. 21, 2025 | receipt | PO-000862 | MAIN | 620 | 26.42 | 16,378.79 | 620 | 16,378.79 | |
| Sept. 10, 2025 | issue | SO-250910-743 | MAIN | 32 | 26.75 | -856.10 | 0 | 0.00 | April 25, 2025: 30 @ 26.75; June 30, 2025: 2 @ 26.75 |
| Sept. 10, 2025 | issue | SO-250910-743 | EAST | 57 | 26.75 | -1,524.93 | 32 | 856.10 | April 25, 2025: 57 @ 26.75 |
| Sept. 5, 2025 | issue | SO-250905-553 | MAIN | 57 | 26.75 | -1,524.93 | 89 | 2,381.03 | April 25, 2025: 57 @ 26.75 |
| Sept. 2, 2025 | issue | SO-250902-682 | MAIN | 32 | 26.75 | -856.10 | 146 | 3,905.95 | April 25, 2025: 32 @ 26.75 |
| Aug. 10, 2025 | issue | SO-250810-154 | EAST | 25 | 26.75 | -668.83 | 178 | 4,762.05 | April 25, 2025: 25 @ 26.75 |
| Aug. 9, 2025 | issue | SO-250809-739 | MAIN | 50 | 26.75 | -1,337.66 | 203 | 5,430.88 | April 25, 2025: 50 @ 26.75 |
| Aug. 3, 2025 | issue | SO-250803-765 | MAIN | 47 | 26.75 | -1,257.40 | 253 | 6,768.53 | April 25, 2025: 47 @ 26.75 |
| July 16, 2025 | issue | SO-250716-429 | MAIN | 97 | 26.75 | -2,595.05 | 300 | 8,025.93 | April 25, 2025: 97 @ 26.75 |
| July 13, 2025 | issue | SO-250713-102 | MAIN | 80 | 26.75 | -2,140.25 | 397 | 10,620.98 | April 25, 2025: 80 @ 26.75 |
| July 11, 2025 | issue | SO-250711-702 | MAIN | 13 | 26.75 | -347.79 | 477 | 12,761.23 | April 25, 2025: 13 @ 26.75 |
| June 30, 2025 | return | RMA | MAIN | 2 | 26.75 | 53.51 | 490 | 13,109.02 | |
| June 26, 2025 | issue | SO-250626-891 | EAST | 40 | 26.75 | -1,070.12 | 488 | 13,055.51 | April 25, 2025: 40 @ 26.75 |
| June 23, 2025 | issue | SO-250623-536 | MAIN | 5 | 26.75 | -133.77 | 528 | 14,125.64 | April 25, 2025: 5 @ 26.75 |
| June 22, 2025 | issue | SO-250622-174 | MAIN | 18 | 26.75 | -481.56 | 533 | 14,259.40 | April 25, 2025: 18 @ 26.75 |
| June 13, 2025 | issue | SO-250613-747 | EAST | 23 | 26.75 | -615.32 | 551 | 14,740.96 | April 25, 2025: 23 @ 26.75 |
| May 9, 2025 | issue | SO-250509-130 | MAIN | 98 | 26.39 | -2,586.70 | 574 | 15,356.28 | Dec. 20, 2024: 52 @ 26.08; April 25, 2025: 46 @ 26.75 |
| May 4, 2025 | issue | SO-250504-471 | MAIN | 21 | 26.08 | -547.64 | 672 | 17,942.98 | Dec. 20, 2024: 21 @ 26.08 |
| April 25, 2025 | transfer | TRF | MAIN → EAST | 145 | warehouse transfer, no cost effect | ||||
| April 25, 2025 | receipt | PO-000481 | MAIN | 620 | 26.75 | 16,586.92 | 693 | 18,490.62 | |
| April 17, 2025 | issue | SO-250417-585 | MAIN | 59 | 26.08 | -1,538.60 | 73 | 1,903.69 | Dec. 20, 2024: 59 @ 26.08 |
| April 15, 2025 | issue | SO-250415-289 | MAIN | 55 | 26.08 | -1,434.29 | 132 | 3,442.30 | Dec. 20, 2024: 55 @ 26.08 |
| March 23, 2025 | issue | SO-250323-714 | MAIN | 30 | 26.08 | -782.34 | 187 | 4,876.59 | Dec. 20, 2024: 30 @ 26.08 |
| March 13, 2025 | issue | SO-250313-901 | MAIN | 110 | 26.08 | -2,868.58 | 217 | 5,658.93 | Dec. 20, 2024: 110 @ 26.08 |
| March 8, 2025 | issue | SO-250308-340 | MAIN | 7 | 26.08 | -182.55 | 327 | 8,527.51 | Dec. 20, 2024: 7 @ 26.08 |
| Feb. 17, 2025 | issue | SO-250217-165 | MAIN | 60 | 26.08 | -1,564.68 | 334 | 8,710.05 | Dec. 20, 2024: 60 @ 26.08 |
| Feb. 5, 2025 | issue | SO-250205-844 | MAIN | 108 | 26.08 | -2,816.42 | 394 | 10,274.73 | Dec. 20, 2024: 108 @ 26.08 |
| Jan. 29, 2025 | issue | SO-250129-695 | MAIN | 85 | 26.08 | -2,216.63 | 502 | 13,091.16 | Dec. 20, 2024: 85 @ 26.08 |
| Jan. 20, 2025 | issue | SO-250120-427 | MAIN | 13 | 26.08 | -339.01 | 587 | 15,307.79 | Dec. 20, 2024: 13 @ 26.08 |
| Jan. 17, 2025 | issue | SO-250117-795 | MAIN | 17 | 26.08 | -443.33 | 600 | 15,646.80 | Dec. 20, 2024: 17 @ 26.08 |
| Jan. 16, 2025 | issue | SO-250116-705 | MAIN | 16 | 26.35 | -421.56 | 617 | 16,090.13 | Oct. 1, 2024: 13 @ 26.41; Dec. 20, 2024: 3 @ 26.08 |
| Jan. 11, 2025 | issue | SO-250111-822 | MAIN | 65 | 26.41 | -1,716.65 | 633 | 16,511.69 | Oct. 1, 2024: 65 @ 26.41 |
| Jan. 5, 2025 | issue | SO-250105-374 | MAIN | 13 | 26.41 | -343.33 | 698 | 18,228.34 | Oct. 1, 2024: 13 @ 26.41 |
| Dec. 20, 2024 | receipt | PO-000120 | MAIN | 620 | 26.08 | 16,168.36 | 711 | 18,571.67 | |
| Dec. 13, 2024 | issue | SO-241213-248 | MAIN | 10 | 26.41 | -264.10 | 91 | 2,403.31 | Oct. 1, 2024: 10 @ 26.41 |
| Dec. 9, 2024 | issue | SO-241209-263 | MAIN | 114 | 26.41 | -3,010.74 | 101 | 2,667.41 | Oct. 1, 2024: 114 @ 26.41 |
| Dec. 2, 2024 | issue | SO-241202-887 | MAIN | 44 | 26.41 | -1,162.04 | 215 | 5,678.15 | Oct. 1, 2024: 44 @ 26.41 |
| Nov. 18, 2024 | issue | SO-241118-522 | MAIN | 111 | 26.41 | -2,931.51 | 259 | 6,840.19 | Oct. 1, 2024: 111 @ 26.41 |
| Nov. 9, 2024 | issue | SO-241109-693 | MAIN | 61 | 26.41 | -1,611.01 | 370 | 9,771.70 | Oct. 1, 2024: 61 @ 26.41 |
| Nov. 7, 2024 | issue | SO-241107-910 | MAIN | 3 | 26.41 | -79.23 | 431 | 11,382.71 | Oct. 1, 2024: 3 @ 26.41 |
| Nov. 5, 2024 | issue | SO-241105-870 | MAIN | 8 | 26.41 | -211.28 | 434 | 11,461.94 | Oct. 1, 2024: 8 @ 26.41 |
| Oct. 25, 2024 | issue | SO-241025-309 | MAIN | 55 | 26.41 | -1,452.55 | 442 | 11,673.22 | Oct. 1, 2024: 55 @ 26.41 |
| Oct. 7, 2024 | issue | SO-241007-259 | MAIN | 123 | 26.41 | -3,248.43 | 497 | 13,125.77 | Oct. 1, 2024: 123 @ 26.41 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 620 | 26.41 | 16,374.20 | 620 | 16,374.20 | |