Items / LED-0029
Downlight 7W Max LED-0029 · Lighting · BrightLine Lighting
On hand (EA)73MAIN 73
Value (FIFO)4,608.25avg 63.13
ClassAX / FCV 0.23
Turnover6.2xlast issue 6 days ago
Days of cover44lead 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 | 50.58 / 30.4375 | 1.662 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 11.85 / 5.517 | 2.148 |
| 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 * 2.148^2 + 1.662^2 * 2.2^2) | 15.5 |
| Reorder point | d * LT + safety stock | 1.662 * 9.6 + 15.5 | 31.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 31.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 607/yr, S = 45.00, h = 20%, price = 63.10 | 65.8 |
| Inventory position | on hand + on order | 73 + 0 | 73 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 63.10 | 66 | 39,106 | yes (chosen if cheapest) |
MOQ 190, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 23, 2026 | 73 / 190 | 63.13 | 4,608.25 |
Movement ledger 122 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 10, 2026 | issue | SO-261010-560 | MAIN | 2 | 63.13 | -126.25 | 73 | 4,608.25 | Aug. 23, 2026: 2 @ 63.13 |
| Oct. 7, 2026 | issue | SO-261007-310 | MAIN | 17 | 63.13 | -1,073.15 | 75 | 4,734.50 | Aug. 23, 2026: 17 @ 63.13 |
| Oct. 4, 2026 | issue | SO-261004-320 | MAIN | 29 | 63.13 | -1,830.67 | 92 | 5,807.66 | Aug. 23, 2026: 29 @ 63.13 |
| Sept. 21, 2026 | issue | SO-260921-835 | MAIN | 44 | 63.13 | -2,777.57 | 121 | 7,638.33 | Aug. 23, 2026: 44 @ 63.13 |
| Sept. 7, 2026 | issue | SO-260907-764 | MAIN | 23 | 63.13 | -1,451.91 | 165 | 10,415.91 | Aug. 23, 2026: 23 @ 63.13 |
| Sept. 4, 2026 | issue | SO-260904-350 | MAIN | 2 | 63.13 | -126.25 | 188 | 11,867.82 | Aug. 23, 2026: 2 @ 63.13 |
| Aug. 23, 2026 | receipt | PO-001736 | MAIN | 190 | 63.13 | 11,994.07 | 190 | 11,994.07 | |
| Aug. 13, 2026 | issue | SO-260813-585 | EAST | 33 | 63.06 | -2,081.02 | 0 | 0.00 | April 12, 2026: 33 @ 63.06 |
| Aug. 1, 2026 | issue | SO-260801-608 | EAST | 15 | 63.06 | -945.92 | 33 | 2,081.02 | April 12, 2026: 15 @ 63.06 |
| July 29, 2026 | issue | SO-260729-794 | EAST | 9 | 63.06 | -567.55 | 48 | 3,026.93 | April 12, 2026: 9 @ 63.06 |
| July 29, 2026 | issue | SO-260729-794 | MAIN | 12 | 63.06 | -756.73 | 57 | 3,594.48 | April 12, 2026: 12 @ 63.06 |
| July 26, 2026 | issue | SO-260726-603 | MAIN | 1 | 63.06 | -63.06 | 69 | 4,351.22 | April 12, 2026: 1 @ 63.06 |
| July 18, 2026 | issue | SO-260718-615 | EAST | 4 | 63.06 | -252.24 | 70 | 4,414.28 | April 12, 2026: 4 @ 63.06 |
| July 16, 2026 | issue | SO-260716-832 | MAIN | 3 | 63.06 | -189.18 | 74 | 4,666.52 | April 12, 2026: 3 @ 63.06 |
| July 15, 2026 | issue | SO-260715-318 | MAIN | 1 | 63.06 | -63.06 | 77 | 4,855.70 | April 12, 2026: 1 @ 63.06 |
| July 6, 2026 | issue | SO-260706-501 | MAIN | 12 | 63.06 | -756.73 | 78 | 4,918.77 | April 12, 2026: 12 @ 63.06 |
| July 3, 2026 | issue | SO-260703-322 | EAST | 1 | 63.06 | -63.06 | 90 | 5,675.50 | April 12, 2026: 1 @ 63.06 |
| June 16, 2026 | issue | SO-260616-313 | MAIN | 49 | 63.06 | -3,089.99 | 91 | 5,738.56 | April 12, 2026: 49 @ 63.06 |
| June 12, 2026 | issue | SO-260612-220 | MAIN | 3 | 63.06 | -189.18 | 140 | 8,828.55 | April 12, 2026: 3 @ 63.06 |
| May 27, 2026 | issue | SO-260527-734 | MAIN | 15 | 63.06 | -945.92 | 143 | 9,017.74 | April 12, 2026: 15 @ 63.06 |
| May 25, 2026 | issue | SO-260525-226 | MAIN | 7 | 63.06 | -441.43 | 158 | 9,963.65 | April 12, 2026: 7 @ 63.06 |
| May 4, 2026 | issue | SO-260504-994 | EAST | 3 | 63.06 | -189.18 | 165 | 10,405.08 | April 12, 2026: 3 @ 63.06 |
| May 2, 2026 | issue | SO-260502-567 | MAIN | 2 | 63.06 | -126.12 | 168 | 10,594.26 | April 12, 2026: 2 @ 63.06 |
| April 17, 2026 | issue | SO-260417-480 | MAIN | 20 | 63.06 | -1,261.22 | 170 | 10,720.39 | April 12, 2026: 20 @ 63.06 |
| April 12, 2026 | transfer | TRF | MAIN → EAST | 65 | warehouse transfer, no cost effect | ||||
| April 12, 2026 | receipt | PO-001399 | MAIN | 190 | 63.06 | 11,981.61 | 190 | 11,981.61 | |
| April 2, 2026 | issue | SO-260402-346 | MAIN | 29 | 60.64 | -1,758.61 | 0 | 0.00 | Jan. 1, 2026: 28 @ 60.64; March 12, 2026: 1 @ 60.64 |
| March 25, 2026 | issue | SO-260325-146 | MAIN | 8 | 60.64 | -485.13 | 29 | 1,758.61 | Jan. 1, 2026: 8 @ 60.64 |
| March 21, 2026 | issue | SO-260321-407 | MAIN | 13 | 60.64 | -788.34 | 37 | 2,243.75 | Jan. 1, 2026: 13 @ 60.64 |
| March 21, 2026 | issue | SO-260321-407 | EAST | 2 | 60.64 | -121.28 | 50 | 3,032.09 | Jan. 1, 2026: 2 @ 60.64 |
| March 17, 2026 | issue | SO-260317-629 | MAIN | 6 | 60.64 | -363.85 | 52 | 3,153.37 | Jan. 1, 2026: 6 @ 60.64 |
| March 16, 2026 | issue | SO-260316-439 | MAIN | 3 | 60.64 | -181.93 | 58 | 3,517.22 | Jan. 1, 2026: 3 @ 60.64 |
| March 12, 2026 | return | RMA | MAIN | 1 | 60.64 | 60.64 | 61 | 3,699.15 | |
| March 12, 2026 | issue | SO-260312-242 | MAIN | 7 | 60.64 | -424.49 | 60 | 3,638.51 | Jan. 1, 2026: 7 @ 60.64 |
| March 9, 2026 | issue | SO-260309-319 | MAIN | 7 | 60.64 | -424.49 | 67 | 4,063.00 | Jan. 1, 2026: 7 @ 60.64 |
| March 3, 2026 | issue | SO-260303-109 | MAIN | 3 | 60.64 | -181.93 | 74 | 4,487.49 | Jan. 1, 2026: 3 @ 60.64 |
| Feb. 26, 2026 | issue | SO-260226-617 | EAST | 21 | 60.64 | -1,273.48 | 77 | 4,669.42 | Jan. 1, 2026: 21 @ 60.64 |
| Feb. 20, 2026 | issue | SO-260220-316 | MAIN | 1 | 60.64 | -60.64 | 98 | 5,942.90 | Jan. 1, 2026: 1 @ 60.64 |
| Feb. 16, 2026 | issue | SO-260216-846 | MAIN | 8 | 60.64 | -485.13 | 99 | 6,003.54 | Jan. 1, 2026: 8 @ 60.64 |
| Feb. 14, 2026 | issue | SO-260214-282 | MAIN | 7 | 60.64 | -424.49 | 107 | 6,488.67 | Jan. 1, 2026: 7 @ 60.64 |
| Feb. 2, 2026 | issue | SO-260202-378 | EAST | 9 | 60.64 | -545.78 | 114 | 6,913.17 | Jan. 1, 2026: 9 @ 60.64 |
| Jan. 27, 2026 | issue | SO-260127-601 | MAIN | 30 | 60.64 | -1,819.25 | 123 | 7,458.94 | Jan. 1, 2026: 30 @ 60.64 |
| Jan. 23, 2026 | issue | SO-260123-768 | MAIN | 22 | 60.64 | -1,334.12 | 153 | 9,278.20 | Jan. 1, 2026: 22 @ 60.64 |
| Jan. 12, 2026 | issue | SO-260112-365 | EAST | 18 | 60.76 | -1,093.64 | 175 | 10,612.32 | Sept. 13, 2025: 3 @ 61.34; Jan. 1, 2026: 15 @ 60.64 |
| Jan. 1, 2026 | transfer | TRF | MAIN → EAST | 47 | warehouse transfer, no cost effect | ||||
| Jan. 1, 2026 | receipt | PO-001110 | MAIN | 190 | 60.64 | 11,521.94 | 193 | 11,705.96 | |
| Dec. 26, 2025 | issue | SO-251226-108 | EAST | 5 | 61.34 | -306.69 | 3 | 184.01 | Sept. 13, 2025: 5 @ 61.34 |
| Dec. 26, 2025 | issue | SO-251226-108 | MAIN | 2 | 61.34 | -122.68 | 8 | 490.70 | Sept. 13, 2025: 2 @ 61.34 |
| Dec. 23, 2025 | issue | SO-251223-247 | MAIN | 10 | 61.34 | -613.38 | 10 | 613.38 | Sept. 13, 2025: 10 @ 61.34 |
| Dec. 19, 2025 | issue | SO-251219-522 | MAIN | 22 | 61.34 | -1,349.43 | 20 | 1,226.76 | Sept. 13, 2025: 22 @ 61.34 |
| Nov. 21, 2025 | adjustment | Cycle count | MAIN | -1 | 61.34 | -61.34 | 42 | 2,576.19 | Sept. 13, 2025: 1 @ 61.34 |
| Nov. 16, 2025 | issue | SO-251116-273 | MAIN | 14 | 61.34 | -858.73 | 43 | 2,637.53 | Sept. 13, 2025: 14 @ 61.34 |
| Nov. 15, 2025 | issue | SO-251115-535 | EAST | 17 | 61.34 | -1,042.74 | 57 | 3,496.26 | Sept. 13, 2025: 17 @ 61.34 |
| Nov. 12, 2025 | issue | SO-251112-392 | MAIN | 33 | 61.34 | -2,024.15 | 74 | 4,539.00 | Sept. 13, 2025: 33 @ 61.34 |
| Oct. 30, 2025 | issue | SO-251030-211 | MAIN | 8 | 61.34 | -490.70 | 107 | 6,563.16 | Sept. 13, 2025: 8 @ 61.34 |
| Oct. 20, 2025 | issue | SO-251020-954 | MAIN | 12 | 61.34 | -736.05 | 115 | 7,053.86 | Sept. 13, 2025: 12 @ 61.34 |
| Oct. 5, 2025 | issue | SO-251005-347 | MAIN | 22 | 61.34 | -1,349.43 | 127 | 7,789.91 | Sept. 13, 2025: 22 @ 61.34 |
| Oct. 2, 2025 | issue | SO-251002-636 | EAST | 10 | 61.34 | -613.38 | 149 | 9,139.35 | Sept. 13, 2025: 10 @ 61.34 |
| Sept. 28, 2025 | issue | SO-250928-538 | EAST | 6 | 61.34 | -368.03 | 159 | 9,752.73 | Sept. 13, 2025: 6 @ 61.34 |
| Sept. 26, 2025 | issue | SO-250926-597 | MAIN | 15 | 61.34 | -920.07 | 165 | 10,120.75 | Sept. 13, 2025: 15 @ 61.34 |