Items / LED-0015
Street Light 90W Classic LED-0015 · Lighting · BrightLine Lighting
On hand (EA)62MAIN 62
Value (FIFO)702.66avg 11.33
ClassBX / FCV 0.39
Turnover9.7xlast issue 1 days ago
Days of cover17lead time 10d
Reorder suggested: 800 units (position at or below reorder point: order EOQ), stockout risk low.
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 | 113.42 / 30.4375 | 3.726 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 44.03 / 5.517 | 7.981 |
| 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 * 7.981^2 + 3.726^2 * 2.2^2) | 42.7 |
| Reorder point | d * LT + safety stock | 3.726 * 9.6 + 42.7 | 78.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 78.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1360/yr, S = 45.00, h = 20%, price = 11.31 | 800.0 |
| Inventory position | on hand + on order | 62 + 0 | 62 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 11.78 | 228 | 16,559 | yes |
| 800 | 11.31 | 800 | 16,362 | yes (chosen if cheapest) |
| 1,600 | 10.84 | 1,600 | 16,512 | yes |
MOQ 400, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| June 19, 2026 | 60 / 400 | 11.33 | 680.00 | |
| Sept. 1, 2026 | 2 / 2 | 11.33 | 22.67 |
Movement ledger 119 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-912 | MAIN | 35 | 11.33 | -396.67 | 62 | 702.66 | June 19, 2026: 35 @ 11.33 |
| Oct. 14, 2026 | issue | SO-261014-406 | MAIN | 1 | 11.33 | -11.33 | 97 | 1,099.33 | June 19, 2026: 1 @ 11.33 |
| Oct. 5, 2026 | issue | SO-261005-261 | MAIN | 75 | 11.33 | -850.00 | 98 | 1,110.66 | June 19, 2026: 75 @ 11.33 |
| Sept. 28, 2026 | issue | SO-260928-232 | MAIN | 3 | 11.33 | -34.00 | 173 | 1,960.66 | June 19, 2026: 3 @ 11.33 |
| Sept. 24, 2026 | issue | SO-260924-331 | MAIN | 39 | 11.33 | -442.00 | 176 | 1,994.66 | June 19, 2026: 39 @ 11.33 |
| Sept. 23, 2026 | issue | SO-260923-352 | MAIN | 21 | 11.33 | -238.00 | 215 | 2,436.66 | June 19, 2026: 21 @ 11.33 |
| Sept. 16, 2026 | issue | SO-260916-292 | MAIN | 1 | 11.33 | -11.33 | 236 | 2,674.66 | June 19, 2026: 1 @ 11.33 |
| Sept. 13, 2026 | issue | SO-260913-467 | MAIN | 20 | 11.33 | -226.67 | 237 | 2,685.99 | June 19, 2026: 20 @ 11.33 |
| Sept. 12, 2026 | issue | SO-260912-693 | MAIN | 9 | 11.33 | -102.00 | 257 | 2,912.66 | June 19, 2026: 9 @ 11.33 |
| Sept. 2, 2026 | issue | SO-260902-760 | MAIN | 9 | 11.33 | -102.00 | 266 | 3,014.66 | June 19, 2026: 9 @ 11.33 |
| Sept. 1, 2026 | return | RMA | MAIN | 2 | 11.33 | 22.67 | 275 | 3,116.66 | |
| Aug. 29, 2026 | issue | SO-260829-383 | MAIN | 2 | 11.33 | -22.67 | 273 | 3,093.99 | June 19, 2026: 2 @ 11.33 |
| Aug. 24, 2026 | issue | SO-260824-502 | MAIN | 36 | 11.33 | -408.00 | 275 | 3,116.66 | June 19, 2026: 36 @ 11.33 |
| Aug. 19, 2026 | issue | SO-260819-488 | MAIN | 9 | 11.33 | -102.00 | 311 | 3,524.66 | June 19, 2026: 9 @ 11.33 |
| Aug. 14, 2026 | issue | SO-260814-605 | MAIN | 4 | 11.33 | -45.33 | 320 | 3,626.66 | June 19, 2026: 4 @ 11.33 |
| Aug. 7, 2026 | issue | SO-260807-730 | MAIN | 6 | 11.33 | -68.00 | 324 | 3,671.99 | June 19, 2026: 6 @ 11.33 |
| Aug. 6, 2026 | issue | SO-260806-768 | MAIN | 10 | 11.33 | -113.33 | 330 | 3,739.99 | June 19, 2026: 10 @ 11.33 |
| July 28, 2026 | issue | SO-260728-115 | MAIN | 58 | 11.33 | -657.33 | 340 | 3,853.32 | June 19, 2026: 58 @ 11.33 |
| July 25, 2026 | issue | SO-260725-130 | MAIN | 32 | 11.27 | -360.65 | 398 | 4,510.65 | Feb. 28, 2026: 16 @ 11.27; March 8, 2026: 14 @ 11.27; June 19, 2026: 2 @ 11.33 |
| July 8, 2026 | issue | SO-260708-749 | MAIN | 7 | 11.27 | -78.86 | 430 | 4,871.30 | Feb. 28, 2026: 7 @ 11.27 |
| June 25, 2026 | issue | SO-260625-615 | MAIN | 4 | 11.27 | -45.06 | 437 | 4,950.17 | Feb. 28, 2026: 4 @ 11.27 |
| June 19, 2026 | receipt | PO-001585 | MAIN | 400 | 11.33 | 4,533.32 | 441 | 4,995.23 | |
| June 14, 2026 | issue | SO-260614-286 | MAIN | 3 | 11.27 | -33.80 | 41 | 461.91 | Feb. 28, 2026: 3 @ 11.27 |
| June 12, 2026 | issue | SO-260612-343 | MAIN | 13 | 11.27 | -146.46 | 44 | 495.71 | Feb. 28, 2026: 13 @ 11.27 |
| June 9, 2026 | issue | SO-260609-262 | MAIN | 9 | 11.27 | -101.39 | 57 | 642.17 | Feb. 28, 2026: 9 @ 11.27 |
| June 8, 2026 | issue | SO-260608-416 | MAIN | 22 | 11.27 | -247.85 | 66 | 743.56 | Feb. 28, 2026: 22 @ 11.27 |
| June 2, 2026 | issue | SO-260602-886 | MAIN | 9 | 11.27 | -101.39 | 88 | 991.42 | Feb. 28, 2026: 9 @ 11.27 |
| June 1, 2026 | issue | SO-260601-844 | MAIN | 8 | 11.27 | -90.13 | 97 | 1,092.81 | Feb. 28, 2026: 8 @ 11.27 |
| May 31, 2026 | issue | SO-260531-361 | MAIN | 7 | 11.27 | -78.86 | 105 | 1,182.94 | Feb. 28, 2026: 7 @ 11.27 |
| May 22, 2026 | issue | SO-260522-374 | MAIN | 2 | 11.27 | -22.53 | 112 | 1,261.80 | Feb. 28, 2026: 2 @ 11.27 |
| May 14, 2026 | issue | SO-260514-244 | MAIN | 14 | 11.27 | -157.73 | 114 | 1,284.34 | Feb. 28, 2026: 14 @ 11.27 |
| May 13, 2026 | issue | SO-260513-279 | MAIN | 14 | 11.27 | -157.73 | 128 | 1,442.06 | Feb. 28, 2026: 14 @ 11.27 |
| May 9, 2026 | issue | SO-260509-548 | MAIN | 3 | 11.27 | -33.80 | 142 | 1,599.79 | Feb. 28, 2026: 3 @ 11.27 |
| May 8, 2026 | issue | SO-260508-478 | MAIN | 44 | 11.27 | -495.71 | 145 | 1,633.58 | Feb. 28, 2026: 44 @ 11.27 |
| May 2, 2026 | issue | SO-260502-380 | MAIN | 8 | 11.27 | -90.13 | 189 | 2,129.29 | Feb. 28, 2026: 8 @ 11.27 |
| April 28, 2026 | issue | SO-260428-161 | MAIN | 3 | 11.27 | -33.80 | 197 | 2,219.42 | Feb. 28, 2026: 3 @ 11.27 |
| April 27, 2026 | issue | SO-260427-716 | MAIN | 19 | 11.27 | -214.06 | 200 | 2,253.22 | Feb. 28, 2026: 19 @ 11.27 |
| April 26, 2026 | issue | SO-260426-898 | MAIN | 3 | 11.27 | -33.80 | 219 | 2,467.28 | Feb. 28, 2026: 3 @ 11.27 |
| April 21, 2026 | issue | SO-260421-193 | MAIN | 20 | 11.27 | -225.32 | 222 | 2,501.07 | Feb. 28, 2026: 20 @ 11.27 |
| April 19, 2026 | issue | SO-260419-892 | MAIN | 31 | 11.27 | -349.25 | 242 | 2,726.40 | Feb. 28, 2026: 31 @ 11.27 |
| April 8, 2026 | issue | SO-260408-563 | MAIN | 10 | 11.27 | -112.66 | 273 | 3,075.65 | Feb. 28, 2026: 10 @ 11.27 |
| March 14, 2026 | issue | SO-260314-732 | MAIN | 111 | 11.27 | -1,250.54 | 283 | 3,188.31 | Feb. 28, 2026: 111 @ 11.27 |
| March 8, 2026 | return | RMA | MAIN | 14 | 11.27 | 157.73 | 394 | 4,438.84 | |
| March 7, 2026 | issue | SO-260307-963 | MAIN | 20 | 11.27 | -225.32 | 380 | 4,281.12 | Feb. 28, 2026: 20 @ 11.27 |
| Feb. 28, 2026 | receipt | PO-001267 | MAIN | 400 | 11.27 | 4,506.44 | 400 | 4,506.44 | |
| Feb. 27, 2026 | issue | SO-260227-988 | MAIN | 10 | 11.30 | -113.02 | 0 | 0.00 | Nov. 23, 2025: 10 @ 11.30 |
| Feb. 22, 2026 | issue | SO-260222-275 | MAIN | 11 | 11.30 | -124.32 | 10 | 113.02 | Nov. 23, 2025: 11 @ 11.30 |
| Feb. 20, 2026 | issue | SO-260220-847 | MAIN | 18 | 11.30 | -203.43 | 21 | 237.34 | Nov. 23, 2025: 18 @ 11.30 |
| Feb. 18, 2026 | issue | SO-260218-138 | MAIN | 28 | 11.30 | -316.45 | 39 | 440.77 | Nov. 23, 2025: 28 @ 11.30 |
| Feb. 2, 2026 | issue | SO-260202-513 | MAIN | 7 | 11.30 | -79.11 | 67 | 757.22 | Nov. 23, 2025: 7 @ 11.30 |
| Jan. 19, 2026 | issue | SO-260119-330 | MAIN | 91 | 11.30 | -1,028.46 | 74 | 836.33 | Nov. 23, 2025: 91 @ 11.30 |
| Jan. 18, 2026 | issue | SO-260118-188 | MAIN | 9 | 11.30 | -101.72 | 165 | 1,864.80 | Nov. 23, 2025: 9 @ 11.30 |
| Jan. 14, 2026 | issue | SO-260114-839 | MAIN | 17 | 11.30 | -192.13 | 174 | 1,966.51 | Nov. 23, 2025: 17 @ 11.30 |
| Jan. 13, 2026 | issue | SO-260113-760 | MAIN | 22 | 11.30 | -248.64 | 191 | 2,158.64 | Nov. 23, 2025: 22 @ 11.30 |
| Jan. 8, 2026 | issue | SO-260108-957 | MAIN | 15 | 11.30 | -169.53 | 213 | 2,407.28 | Nov. 23, 2025: 15 @ 11.30 |
| Dec. 18, 2025 | issue | SO-251218-251 | MAIN | 25 | 11.30 | -282.54 | 228 | 2,576.81 | Nov. 23, 2025: 25 @ 11.30 |
| Dec. 13, 2025 | issue | SO-251213-883 | MAIN | 54 | 11.30 | -610.30 | 253 | 2,859.36 | Nov. 23, 2025: 54 @ 11.30 |
| Dec. 13, 2025 | issue | SO-251213-883 | EAST | 108 | 11.25 | -1,214.66 | 307 | 3,469.65 | Aug. 27, 2025: 15 @ 10.91; Nov. 23, 2025: 93 @ 11.30 |
| Nov. 30, 2025 | issue | SO-251130-593 | MAIN | 35 | 10.91 | -381.72 | 415 | 4,684.32 | Aug. 27, 2025: 35 @ 10.91 |
| Nov. 24, 2025 | issue | SO-251124-389 | EAST | 5 | 10.91 | -54.53 | 450 | 5,066.04 | Aug. 27, 2025: 5 @ 10.91 |