Items / LED-0030
Flood Light 50W Nova LED-0030 · Lighting · BrightLine Lighting
On hand (EA)125MAIN 125
Value (FIFO)4,441.28avg 35.53
ClassBX / FCV 0.23
Turnover5.6xlast issue 2 days ago
Days of cover54lead 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 | 70.92 / 30.4375 | 2.330 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 16.55 / 5.517 | 2.999 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(9.6 * 2.999^2 + 2.330^2 * 2.2^2) | 17.4 |
| Reorder point | d * LT + safety stock | 2.330 * 9.6 + 17.4 | 39.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 39.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 850/yr, S = 45.00, h = 20%, price = 35.05 | 520.0 |
| Inventory position | on hand + on order | 125 + 0 | 125 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 36.51 | 102 | 31,796 | yes |
| 520 | 35.05 | 520 | 31,703 | yes (chosen if cheapest) |
| 1,040 | 33.59 | 1,040 | 32,095 | yes |
MOQ 260, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 14, 2026 | 125 / 260 | 35.53 | 4,441.28 |
Movement ledger 127 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | issue | SO-261014-655 | MAIN | 18 | 35.53 | -639.54 | 125 | 4,441.28 | Aug. 14, 2026: 18 @ 35.53 |
| Oct. 11, 2026 | issue | SO-261011-460 | MAIN | 1 | 35.53 | -35.53 | 143 | 5,080.82 | Aug. 14, 2026: 1 @ 35.53 |
| Oct. 10, 2026 | issue | SO-261010-246 | MAIN | 41 | 35.53 | -1,456.74 | 144 | 5,116.35 | Aug. 14, 2026: 41 @ 35.53 |
| Oct. 9, 2026 | issue | SO-261009-375 | MAIN | 5 | 35.53 | -177.65 | 185 | 6,573.09 | Aug. 14, 2026: 5 @ 35.53 |
| Oct. 2, 2026 | issue | SO-261002-707 | MAIN | 17 | 35.53 | -604.01 | 190 | 6,750.74 | Aug. 14, 2026: 17 @ 35.53 |
| Sept. 28, 2026 | issue | SO-260928-349 | MAIN | 34 | 35.53 | -1,208.03 | 207 | 7,354.75 | Aug. 14, 2026: 34 @ 35.53 |
| Sept. 28, 2026 | issue | SO-260928-349 | EAST | 4 | 35.53 | -142.12 | 241 | 8,562.78 | Aug. 14, 2026: 4 @ 35.53 |
| Sept. 10, 2026 | issue | SO-260910-244 | MAIN | 12 | 35.53 | -426.36 | 245 | 8,704.90 | Aug. 14, 2026: 12 @ 35.53 |
| Sept. 4, 2026 | issue | SO-260904-256 | MAIN | 17 | 36.04 | -612.70 | 257 | 9,131.26 | Aug. 6, 2026: 14 @ 36.15; Aug. 14, 2026: 3 @ 35.53 |
| Aug. 19, 2026 | issue | SO-260819-293 | MAIN | 2 | 36.15 | -72.30 | 274 | 9,743.96 | April 15, 2026: 2 @ 36.15 |
| Aug. 14, 2026 | issue | SO-260814-704 | MAIN | 2 | 36.15 | -72.30 | 276 | 9,816.26 | April 15, 2026: 2 @ 36.15 |
| Aug. 14, 2026 | receipt | PO-001719 | MAIN | 260 | 35.53 | 9,237.85 | 278 | 9,888.56 | |
| Aug. 12, 2026 | issue | SO-260812-157 | EAST | 15 | 36.15 | -542.26 | 18 | 650.71 | April 15, 2026: 15 @ 36.15 |
| Aug. 6, 2026 | return | RMA | MAIN | 14 | 36.15 | 506.11 | 33 | 1,192.96 | |
| Aug. 5, 2026 | issue | SO-260805-467 | EAST | 6 | 36.15 | -216.90 | 19 | 686.86 | April 15, 2026: 6 @ 36.15 |
| Aug. 4, 2026 | issue | SO-260804-877 | EAST | 8 | 36.15 | -289.20 | 25 | 903.76 | April 15, 2026: 8 @ 36.15 |
| Aug. 4, 2026 | issue | SO-260804-877 | MAIN | 1 | 36.15 | -36.15 | 33 | 1,192.96 | April 15, 2026: 1 @ 36.15 |
| Aug. 2, 2026 | issue | SO-260802-528 | EAST | 28 | 36.15 | -1,012.21 | 34 | 1,229.11 | April 15, 2026: 28 @ 36.15 |
| July 28, 2026 | issue | SO-260728-362 | MAIN | 8 | 36.15 | -289.20 | 62 | 2,241.32 | April 15, 2026: 8 @ 36.15 |
| July 14, 2026 | issue | SO-260714-142 | MAIN | 37 | 36.15 | -1,337.56 | 70 | 2,530.53 | April 15, 2026: 37 @ 36.15 |
| July 12, 2026 | issue | SO-260712-291 | MAIN | 8 | 36.15 | -289.20 | 107 | 3,868.09 | April 15, 2026: 8 @ 36.15 |
| June 27, 2026 | issue | SO-260627-394 | EAST | 4 | 36.15 | -144.60 | 115 | 4,157.30 | April 15, 2026: 4 @ 36.15 |
| June 24, 2026 | issue | SO-260624-368 | MAIN | 88 | 36.15 | -3,181.24 | 119 | 4,301.90 | April 15, 2026: 88 @ 36.15 |
| May 22, 2026 | issue | SO-260522-295 | EAST | 20 | 36.15 | -723.01 | 207 | 7,483.13 | April 15, 2026: 20 @ 36.15 |
| May 21, 2026 | issue | SO-260521-349 | MAIN | 33 | 36.15 | -1,192.96 | 227 | 8,206.14 | April 15, 2026: 33 @ 36.15 |
| May 15, 2026 | issue | SO-260515-755 | EAST | 2 | 35.14 | -70.29 | 260 | 9,399.10 | Dec. 13, 2025: 2 @ 35.14 |
| May 3, 2026 | issue | SO-260503-527 | MAIN | 13 | 35.14 | -456.86 | 262 | 9,469.39 | Dec. 13, 2025: 13 @ 35.14 |
| April 30, 2026 | issue | SO-260430-767 | EAST | 2 | 35.14 | -70.29 | 275 | 9,926.26 | Dec. 13, 2025: 2 @ 35.14 |
| April 15, 2026 | transfer | TRF | MAIN → EAST | 89 | warehouse transfer, no cost effect | ||||
| April 15, 2026 | receipt | PO-001409 | MAIN | 260 | 36.15 | 9,399.10 | 277 | 9,996.54 | |
| April 6, 2026 | issue | SO-260406-941 | MAIN | 29 | 35.14 | -1,019.16 | 17 | 597.44 | Dec. 13, 2025: 29 @ 35.14 |
| April 4, 2026 | issue | SO-260404-245 | MAIN | 13 | 35.14 | -456.86 | 46 | 1,616.60 | Dec. 13, 2025: 13 @ 35.14 |
| April 1, 2026 | issue | SO-260401-458 | MAIN | 31 | 35.14 | -1,089.45 | 59 | 2,073.46 | Dec. 13, 2025: 31 @ 35.14 |
| March 22, 2026 | issue | SO-260322-107 | MAIN | 21 | 35.14 | -738.01 | 90 | 3,162.91 | Dec. 13, 2025: 21 @ 35.14 |
| March 20, 2026 | issue | SO-260320-275 | MAIN | 22 | 35.14 | -773.15 | 111 | 3,900.92 | Dec. 13, 2025: 22 @ 35.14 |
| Feb. 24, 2026 | issue | SO-260224-279 | MAIN | 2 | 35.14 | -70.29 | 133 | 4,674.07 | Dec. 13, 2025: 2 @ 35.14 |
| Feb. 21, 2026 | issue | SO-260221-992 | MAIN | 6 | 35.14 | -210.86 | 135 | 4,744.36 | Dec. 13, 2025: 6 @ 35.14 |
| Feb. 15, 2026 | issue | SO-260215-290 | MAIN | 12 | 35.14 | -421.72 | 141 | 4,955.22 | Dec. 13, 2025: 12 @ 35.14 |
| Feb. 8, 2026 | issue | SO-260208-902 | MAIN | 6 | 35.14 | -210.86 | 153 | 5,376.94 | Dec. 13, 2025: 6 @ 35.14 |
| Feb. 6, 2026 | issue | SO-260206-517 | MAIN | 4 | 35.14 | -140.57 | 159 | 5,587.80 | Dec. 13, 2025: 4 @ 35.14 |
| Feb. 2, 2026 | issue | SO-260202-160 | MAIN | 41 | 35.14 | -1,440.88 | 163 | 5,728.37 | Dec. 13, 2025: 41 @ 35.14 |
| Jan. 31, 2026 | issue | SO-260131-771 | MAIN | 14 | 35.14 | -492.01 | 204 | 7,169.25 | Dec. 13, 2025: 14 @ 35.14 |
| Jan. 21, 2026 | issue | SO-260121-782 | MAIN | 1 | 35.14 | -35.14 | 218 | 7,661.26 | Dec. 13, 2025: 1 @ 35.14 |
| Jan. 19, 2026 | issue | SO-260119-207 | MAIN | 17 | 35.14 | -597.44 | 219 | 7,696.40 | Dec. 13, 2025: 17 @ 35.14 |
| Jan. 16, 2026 | issue | SO-260116-218 | MAIN | 8 | 35.14 | -281.15 | 236 | 8,293.84 | Dec. 13, 2025: 8 @ 35.14 |
| Jan. 14, 2026 | issue | SO-260114-598 | MAIN | 6 | 35.14 | -210.86 | 244 | 8,574.99 | Dec. 13, 2025: 6 @ 35.14 |
| Jan. 14, 2026 | issue | SO-260114-598 | EAST | 12 | 35.12 | -421.39 | 250 | 8,785.85 | Sept. 21, 2025: 2 @ 34.98; Dec. 13, 2025: 10 @ 35.14 |
| Jan. 7, 2026 | issue | SO-260107-177 | MAIN | 8 | 34.98 | -279.82 | 262 | 9,207.24 | Sept. 21, 2025: 8 @ 34.98 |
| Dec. 20, 2025 | issue | SO-251220-283 | MAIN | 6 | 34.98 | -209.87 | 270 | 9,487.06 | Sept. 21, 2025: 6 @ 34.98 |
| Dec. 16, 2025 | issue | SO-251216-441 | MAIN | 11 | 34.98 | -384.76 | 276 | 9,696.93 | Sept. 21, 2025: 11 @ 34.98 |
| Dec. 13, 2025 | receipt | PO-001047 | MAIN | 260 | 35.14 | 9,137.28 | 287 | 10,081.68 | |
| Dec. 12, 2025 | issue | SO-251212-200 | EAST | 3 | 34.98 | -104.93 | 27 | 944.40 | Sept. 21, 2025: 3 @ 34.98 |
| Dec. 6, 2025 | issue | SO-251206-444 | MAIN | 16 | 34.98 | -559.64 | 30 | 1,049.33 | Sept. 21, 2025: 16 @ 34.98 |
| Dec. 5, 2025 | issue | SO-251205-894 | MAIN | 9 | 34.98 | -314.80 | 46 | 1,608.98 | Sept. 21, 2025: 9 @ 34.98 |
| Dec. 1, 2025 | issue | SO-251201-271 | MAIN | 35 | 34.98 | -1,224.22 | 55 | 1,923.78 | Sept. 21, 2025: 35 @ 34.98 |
| Nov. 17, 2025 | issue | SO-251117-801 | MAIN | 80 | 34.98 | -2,798.22 | 90 | 3,148.00 | Sept. 21, 2025: 80 @ 34.98 |
| Nov. 5, 2025 | issue | SO-251105-632 | MAIN | 13 | 34.98 | -454.71 | 170 | 5,946.23 | Sept. 21, 2025: 13 @ 34.98 |
| Oct. 8, 2025 | issue | SO-251008-328 | MAIN | 26 | 34.98 | -909.42 | 183 | 6,400.94 | Sept. 21, 2025: 26 @ 34.98 |
| Oct. 5, 2025 | issue | SO-251005-265 | EAST | 69 | 34.85 | -2,404.51 | 209 | 7,310.36 | May 22, 2025: 18 @ 34.48; Sept. 21, 2025: 51 @ 34.98 |
| Sept. 27, 2025 | issue | SO-250927-333 | EAST | 4 | 34.48 | -137.92 | 278 | 9,714.87 | May 22, 2025: 4 @ 34.48 |