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