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
| 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 |
| Aug. 26, 2025 | issue | SO-250826-731 | MAIN | 37 | 7.21 | -266.94 | 151 | 1,089.40 | May 21, 2025: 37 @ 7.21 |
| Aug. 10, 2025 | issue | SO-250810-401 | MAIN | 4 | 7.21 | -28.86 | 188 | 1,356.34 | May 21, 2025: 4 @ 7.21 |
| July 18, 2025 | issue | SO-250718-201 | MAIN | 13 | 7.21 | -93.79 | 192 | 1,385.20 | May 21, 2025: 13 @ 7.21 |
| July 17, 2025 | issue | SO-250717-284 | MAIN | 16 | 7.21 | -115.43 | 205 | 1,478.99 | May 21, 2025: 16 @ 7.21 |
| July 14, 2025 | issue | SO-250714-202 | MAIN | 7 | 7.21 | -50.50 | 221 | 1,594.43 | May 21, 2025: 7 @ 7.21 |
| July 5, 2025 | issue | SO-250705-933 | MAIN | 7 | 7.21 | -50.50 | 228 | 1,644.93 | May 21, 2025: 7 @ 7.21 |
| June 23, 2025 | issue | SO-250623-959 | MAIN | 11 | 7.21 | -79.36 | 235 | 1,695.43 | May 21, 2025: 11 @ 7.21 |
| June 22, 2025 | issue | SO-250622-553 | MAIN | 14 | 7.21 | -101.00 | 246 | 1,774.79 | May 21, 2025: 14 @ 7.21 |
| June 19, 2025 | issue | SO-250619-926 | MAIN | 12 | 7.21 | -86.58 | 260 | 1,875.80 | May 21, 2025: 12 @ 7.21 |
| June 14, 2025 | issue | SO-250614-251 | MAIN | 30 | 7.21 | -216.44 | 272 | 1,962.37 | May 21, 2025: 30 @ 7.21 |
| June 12, 2025 | issue | SO-250612-710 | MAIN | 3 | 7.21 | -21.64 | 302 | 2,178.81 | May 21, 2025: 3 @ 7.21 |
| May 24, 2025 | issue | SO-250524-734 | MAIN | 5 | 7.21 | -36.07 | 305 | 2,200.45 | May 21, 2025: 5 @ 7.21 |
| May 21, 2025 | receipt | PO-000553 | MAIN | 310 | 7.21 | 2,236.53 | 310 | 2,236.53 | |
| May 20, 2025 | issue | SO-250520-743 | MAIN | 1 | 6.83 | -6.83 | 0 | 0.00 | Dec. 31, 2024: 1 @ 6.83 |
| May 14, 2025 | issue | SO-250514-121 | MAIN | 37 | 6.83 | -252.86 | 1 | 6.83 | Dec. 31, 2024: 37 @ 6.83 |
| May 4, 2025 | issue | SO-250504-756 | MAIN | 9 | 6.83 | -61.51 | 38 | 259.69 | Dec. 31, 2024: 9 @ 6.83 |
| May 2, 2025 | issue | SO-250502-961 | MAIN | 7 | 6.83 | -47.84 | 47 | 321.20 | Dec. 31, 2024: 7 @ 6.83 |
| April 24, 2025 | issue | SO-250424-755 | MAIN | 7 | 6.83 | -47.84 | 54 | 369.04 | Dec. 31, 2024: 7 @ 6.83 |
| April 22, 2025 | issue | SO-250422-970 | MAIN | 14 | 6.83 | -95.68 | 61 | 416.87 | Dec. 31, 2024: 14 @ 6.83 |
| April 20, 2025 | issue | SO-250420-902 | MAIN | 2 | 6.83 | -13.67 | 75 | 512.55 | Dec. 31, 2024: 2 @ 6.83 |
| April 19, 2025 | issue | SO-250419-769 | MAIN | 24 | 6.83 | -164.02 | 77 | 526.22 | Dec. 31, 2024: 24 @ 6.83 |
| April 9, 2025 | issue | SO-250409-148 | MAIN | 23 | 6.83 | -157.18 | 101 | 690.23 | Dec. 31, 2024: 23 @ 6.83 |
| March 29, 2025 | issue | SO-250329-359 | MAIN | 13 | 6.83 | -88.84 | 124 | 847.42 | Dec. 31, 2024: 13 @ 6.83 |
| March 12, 2025 | issue | SO-250312-176 | MAIN | 17 | 6.83 | -116.18 | 137 | 936.26 | Dec. 31, 2024: 17 @ 6.83 |
| March 8, 2025 | issue | SO-250308-607 | MAIN | 42 | 6.83 | -287.03 | 154 | 1,052.44 | Dec. 31, 2024: 42 @ 6.83 |
| March 7, 2025 | issue | SO-250307-590 | MAIN | 2 | 6.83 | -13.67 | 196 | 1,339.46 | Dec. 31, 2024: 2 @ 6.83 |
| Feb. 28, 2025 | issue | SO-250228-136 | MAIN | 48 | 6.83 | -328.03 | 198 | 1,353.13 | Dec. 31, 2024: 48 @ 6.83 |
| Feb. 17, 2025 | issue | SO-250217-310 | MAIN | 27 | 6.83 | -184.52 | 246 | 1,681.16 | Dec. 31, 2024: 27 @ 6.83 |
| Jan. 30, 2025 | issue | SO-250130-237 | MAIN | 38 | 6.84 | -259.97 | 273 | 1,865.68 | Oct. 1, 2024: 1 @ 7.12; Dec. 31, 2024: 37 @ 6.83 |
| Jan. 20, 2025 | issue | SO-250120-524 | MAIN | 48 | 7.12 | -341.54 | 311 | 2,125.66 | Oct. 1, 2024: 48 @ 7.12 |
| Dec. 31, 2024 | receipt | PO-000154 | MAIN | 310 | 6.83 | 2,118.54 | 359 | 2,467.20 | |
| Dec. 19, 2024 | issue | SO-241219-945 | MAIN | 24 | 7.12 | -170.77 | 49 | 348.66 | Oct. 1, 2024: 24 @ 7.12 |
| Dec. 12, 2024 | issue | SO-241212-245 | MAIN | 15 | 7.12 | -106.73 | 73 | 519.43 | Oct. 1, 2024: 15 @ 7.12 |
| Dec. 1, 2024 | issue | SO-241201-598 | MAIN | 37 | 7.12 | -263.27 | 88 | 626.16 | Oct. 1, 2024: 37 @ 7.12 |
| Nov. 28, 2024 | issue | SO-241128-742 | MAIN | 48 | 7.12 | -341.54 | 125 | 889.44 | Oct. 1, 2024: 48 @ 7.12 |
| Nov. 23, 2024 | issue | SO-241123-366 | MAIN | 19 | 7.12 | -135.19 | 173 | 1,230.98 | Oct. 1, 2024: 19 @ 7.12 |
| Nov. 19, 2024 | issue | SO-241119-383 | MAIN | 1 | 7.12 | -7.12 | 192 | 1,366.18 | Oct. 1, 2024: 1 @ 7.12 |
| Nov. 18, 2024 | issue | SO-241118-653 | MAIN | 16 | 7.12 | -113.85 | 193 | 1,373.29 | Oct. 1, 2024: 16 @ 7.12 |
| Nov. 8, 2024 | issue | SO-241108-244 | MAIN | 1 | 7.12 | -7.12 | 209 | 1,487.14 | Oct. 1, 2024: 1 @ 7.12 |
| Nov. 5, 2024 | issue | SO-241105-485 | MAIN | 14 | 7.12 | -99.62 | 210 | 1,494.26 | Oct. 1, 2024: 14 @ 7.12 |
| Nov. 1, 2024 | issue | SO-241101-684 | MAIN | 3 | 7.12 | -21.35 | 224 | 1,593.87 | Oct. 1, 2024: 3 @ 7.12 |
| Oct. 18, 2024 | issue | SO-241018-832 | MAIN | 9 | 7.12 | -64.04 | 227 | 1,615.22 | Oct. 1, 2024: 9 @ 7.12 |
| Oct. 5, 2024 | issue | SO-241005-224 | MAIN | 69 | 7.12 | -490.97 | 236 | 1,679.26 | Oct. 1, 2024: 69 @ 7.12 |
| Oct. 2, 2024 | issue | SO-241002-647 | MAIN | 5 | 7.12 | -35.58 | 305 | 2,170.23 | Oct. 1, 2024: 5 @ 7.12 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 310 | 7.12 | 2,205.80 | 310 | 2,205.80 |