Items / LED-0039
Downlight 7W Eco LED-0039 · Lighting · BrightLine Lighting
On hand (EA)28MAIN 28
Value (FIFO)202.98avg 7.25
ClassCX / FCV 0.26
Turnover17.7xlast issue 4 days ago
Days of cover11lead time 10d
Reorder suggested: 620 units (position at or below reorder point: order EOQ), stockout risk medium.
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 | 75.08 / 30.4375 | 2.467 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 19.77 / 5.517 | 3.583 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.900) | 1.282 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.282 * sqrt(9.6 * 3.583^2 + 2.467^2 * 2.2^2) | 15.8 |
| Reorder point | d * LT + safety stock | 2.467 * 9.6 + 15.8 | 39.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 39.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 900/yr, S = 45.00, h = 20%, price = 7.19 | 620.0 |
| Inventory position | on hand + on order | 28 + 0 | 28 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 7.49 | 233 | 7,092 | yes |
| 620 | 7.19 | 620 | 6,985 | yes (chosen if cheapest) |
| 1,240 | 6.89 | 1,240 | 7,091 | yes |
MOQ 310, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| June 26, 2026 | 28 / 310 | 7.25 | 202.98 |
Movement ledger 105 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-679 | MAIN | 49 | 7.25 | -355.22 | 28 | 202.98 | June 26, 2026: 49 @ 7.25 |
| Oct. 2, 2026 | issue | SO-261002-194 | MAIN | 7 | 7.25 | -50.75 | 77 | 558.20 | June 26, 2026: 7 @ 7.25 |
| Oct. 1, 2026 | issue | SO-261001-420 | MAIN | 32 | 7.25 | -231.98 | 84 | 608.95 | June 26, 2026: 32 @ 7.25 |
| Sept. 30, 2026 | issue | SO-260930-311 | MAIN | 12 | 7.25 | -86.99 | 116 | 840.93 | June 26, 2026: 12 @ 7.25 |
| Sept. 26, 2026 | issue | SO-260926-939 | MAIN | 40 | 7.25 | -289.98 | 128 | 927.92 | June 26, 2026: 40 @ 7.25 |
| Sept. 20, 2026 | issue | SO-260920-542 | MAIN | 1 | 7.25 | -7.25 | 168 | 1,217.90 | June 26, 2026: 1 @ 7.25 |
| Sept. 14, 2026 | issue | SO-260914-664 | MAIN | 34 | 7.25 | -246.48 | 169 | 1,225.15 | June 26, 2026: 34 @ 7.25 |
| Aug. 31, 2026 | issue | SO-260831-240 | MAIN | 1 | 7.25 | -7.25 | 203 | 1,471.63 | June 26, 2026: 1 @ 7.25 |
| Aug. 28, 2026 | issue | SO-260828-929 | MAIN | 57 | 7.25 | -413.22 | 204 | 1,478.88 | June 26, 2026: 57 @ 7.25 |
| July 22, 2026 | issue | SO-260722-637 | MAIN | 2 | 7.25 | -14.50 | 261 | 1,892.09 | June 26, 2026: 2 @ 7.25 |
| July 21, 2026 | issue | SO-260721-719 | MAIN | 29 | 7.25 | -210.23 | 263 | 1,906.59 | June 26, 2026: 29 @ 7.25 |
| July 12, 2026 | issue | SO-260712-322 | MAIN | 16 | 7.25 | -115.99 | 292 | 2,116.82 | June 26, 2026: 16 @ 7.25 |
| July 10, 2026 | issue | SO-260710-846 | MAIN | 16 | 7.40 | -118.40 | 308 | 2,232.82 | March 5, 2026: 14 @ 7.42; June 26, 2026: 2 @ 7.25 |
| July 9, 2026 | issue | SO-260709-227 | MAIN | 14 | 7.42 | -103.90 | 324 | 2,351.21 | March 5, 2026: 14 @ 7.42 |
| June 26, 2026 | receipt | PO-001604 | MAIN | 310 | 7.25 | 2,247.31 | 338 | 2,455.11 | |
| June 18, 2026 | issue | SO-260618-725 | MAIN | 11 | 7.42 | -81.64 | 28 | 207.80 | March 5, 2026: 11 @ 7.42 |
| June 8, 2026 | issue | SO-260608-720 | MAIN | 34 | 7.42 | -252.33 | 39 | 289.43 | March 5, 2026: 34 @ 7.42 |
| June 3, 2026 | issue | SO-260603-476 | MAIN | 13 | 7.42 | -96.48 | 73 | 541.76 | March 5, 2026: 13 @ 7.42 |
| May 23, 2026 | issue | SO-260523-468 | MAIN | 23 | 7.42 | -170.69 | 86 | 638.24 | March 5, 2026: 23 @ 7.42 |
| May 11, 2026 | issue | SO-260511-699 | MAIN | 42 | 7.42 | -311.70 | 109 | 808.93 | March 5, 2026: 42 @ 7.42 |
| May 5, 2026 | issue | SO-260505-703 | MAIN | 6 | 7.42 | -44.53 | 151 | 1,120.63 | March 5, 2026: 6 @ 7.42 |
| April 19, 2026 | issue | SO-260419-592 | MAIN | 4 | 7.42 | -29.69 | 157 | 1,165.16 | March 5, 2026: 4 @ 7.42 |
| April 12, 2026 | issue | SO-260412-800 | MAIN | 70 | 7.42 | -519.50 | 161 | 1,194.85 | March 5, 2026: 70 @ 7.42 |
| April 10, 2026 | issue | SO-260410-104 | MAIN | 24 | 7.42 | -178.11 | 231 | 1,714.34 | March 5, 2026: 24 @ 7.42 |
| April 6, 2026 | issue | SO-260406-232 | MAIN | 9 | 7.42 | -66.79 | 255 | 1,892.46 | March 5, 2026: 9 @ 7.42 |
| April 5, 2026 | issue | SO-260405-174 | MAIN | 10 | 7.42 | -74.21 | 264 | 1,959.25 | March 5, 2026: 10 @ 7.42 |
| April 4, 2026 | issue | SO-260404-472 | MAIN | 3 | 7.42 | -22.26 | 274 | 2,033.46 | March 5, 2026: 3 @ 7.42 |
| March 22, 2026 | issue | SO-260322-154 | MAIN | 3 | 7.42 | -22.26 | 277 | 2,055.73 | March 5, 2026: 3 @ 7.42 |
| March 12, 2026 | issue | SO-260312-933 | MAIN | 52 | 7.38 | -383.51 | 280 | 2,077.99 | Nov. 7, 2025: 22 @ 7.31; March 5, 2026: 30 @ 7.42 |
| March 10, 2026 | issue | SO-260310-833 | MAIN | 3 | 7.31 | -21.94 | 332 | 2,461.51 | Nov. 7, 2025: 3 @ 7.31 |
| March 8, 2026 | issue | SO-260308-966 | MAIN | 11 | 7.31 | -80.44 | 335 | 2,483.44 | Nov. 7, 2025: 11 @ 7.31 |
| March 5, 2026 | issue | SO-260305-467 | MAIN | 2 | 7.31 | -14.62 | 346 | 2,563.88 | Nov. 7, 2025: 2 @ 7.31 |
| March 5, 2026 | receipt | PO-001285 | MAIN | 310 | 7.42 | 2,300.63 | 348 | 2,578.51 | |
| Feb. 27, 2026 | issue | SO-260227-740 | MAIN | 5 | 7.31 | -36.56 | 38 | 277.87 | Nov. 7, 2025: 5 @ 7.31 |
| Feb. 23, 2026 | issue | SO-260223-645 | MAIN | 1 | 7.31 | -7.31 | 43 | 314.43 | Nov. 7, 2025: 1 @ 7.31 |
| Feb. 22, 2026 | issue | SO-260222-763 | MAIN | 19 | 7.31 | -138.94 | 44 | 321.75 | Nov. 7, 2025: 19 @ 7.31 |
| Feb. 17, 2026 | issue | SO-260217-599 | MAIN | 12 | 7.31 | -87.75 | 63 | 460.68 | Nov. 7, 2025: 12 @ 7.31 |
| Feb. 14, 2026 | issue | SO-260214-577 | MAIN | 8 | 7.31 | -58.50 | 75 | 548.43 | Nov. 7, 2025: 8 @ 7.31 |
| Feb. 2, 2026 | issue | SO-260202-345 | MAIN | 11 | 7.31 | -80.44 | 83 | 606.93 | Nov. 7, 2025: 11 @ 7.31 |
| Jan. 15, 2026 | issue | SO-260115-121 | MAIN | 49 | 7.31 | -358.31 | 94 | 687.37 | Nov. 7, 2025: 49 @ 7.31 |
| Jan. 9, 2026 | issue | SO-260109-919 | MAIN | 5 | 7.31 | -36.56 | 143 | 1,045.67 | Nov. 7, 2025: 5 @ 7.31 |
| Jan. 8, 2026 | issue | SO-260108-581 | MAIN | 39 | 7.31 | -285.18 | 148 | 1,082.24 | Nov. 7, 2025: 39 @ 7.31 |
| Jan. 3, 2026 | issue | SO-260103-309 | MAIN | 5 | 7.31 | -36.56 | 187 | 1,367.42 | Nov. 7, 2025: 5 @ 7.31 |
| Dec. 22, 2025 | issue | SO-251222-958 | MAIN | 49 | 7.31 | -358.31 | 192 | 1,403.98 | Nov. 7, 2025: 49 @ 7.31 |
| Dec. 20, 2025 | issue | SO-251220-286 | MAIN | 40 | 7.31 | -292.50 | 241 | 1,762.29 | Nov. 7, 2025: 40 @ 7.31 |
| Nov. 30, 2025 | issue | SO-251130-645 | MAIN | 16 | 7.31 | -117.00 | 281 | 2,054.78 | Nov. 7, 2025: 16 @ 7.31 |
| Nov. 27, 2025 | issue | SO-251127-359 | MAIN | 10 | 7.31 | -73.12 | 297 | 2,171.78 | Nov. 7, 2025: 10 @ 7.31 |
| Nov. 19, 2025 | issue | SO-251119-867 | MAIN | 3 | 7.31 | -21.94 | 307 | 2,244.91 | Nov. 7, 2025: 3 @ 7.31 |
| Nov. 7, 2025 | receipt | PO-000982 | MAIN | 310 | 7.31 | 2,266.84 | 310 | 2,266.84 | |
| Nov. 2, 2025 | issue | SO-251102-558 | MAIN | 18 | 7.21 | -129.86 | 0 | 0.00 | May 21, 2025: 18 @ 7.21 |
| Oct. 30, 2025 | issue | SO-251030-884 | MAIN | 5 | 7.21 | -36.07 | 18 | 129.86 | May 21, 2025: 5 @ 7.21 |
| Oct. 29, 2025 | issue | SO-251029-561 | MAIN | 1 | 7.21 | -7.21 | 23 | 165.94 | May 21, 2025: 1 @ 7.21 |
| Oct. 27, 2025 | issue | SO-251027-666 | MAIN | 35 | 7.21 | -252.51 | 24 | 173.15 | May 21, 2025: 35 @ 7.21 |
| Oct. 17, 2025 | issue | SO-251017-713 | MAIN | 26 | 7.21 | -187.58 | 59 | 425.66 | May 21, 2025: 26 @ 7.21 |
| Oct. 16, 2025 | issue | SO-251016-767 | MAIN | 2 | 7.21 | -14.43 | 85 | 613.24 | May 21, 2025: 2 @ 7.21 |
| Sept. 24, 2025 | issue | SO-250924-974 | MAIN | 4 | 7.21 | -28.86 | 87 | 627.67 | May 21, 2025: 4 @ 7.21 |
| Sept. 18, 2025 | issue | SO-250918-922 | MAIN | 33 | 7.21 | -238.08 | 91 | 656.53 | May 21, 2025: 33 @ 7.21 |
| Sept. 10, 2025 | issue | SO-250910-828 | MAIN | 7 | 7.21 | -50.50 | 124 | 894.61 | May 21, 2025: 7 @ 7.21 |
| Aug. 30, 2025 | issue | SO-250830-447 | MAIN | 5 | 7.21 | -36.07 | 131 | 945.11 | May 21, 2025: 5 @ 7.21 |
| Aug. 29, 2025 | issue | SO-250829-478 | MAIN | 15 | 7.21 | -108.22 | 136 | 981.19 | May 21, 2025: 15 @ 7.21 |