Items / LED-0035
LED Bulb 12W Elite LED-0035 · Lighting · BrightLine Lighting
On hand (EA)204MAIN 204
Value (FIFO)3,420.86avg 16.77
ClassBX / FCV 0.17
Turnover3.8xlast issue 2 days ago
Days of cover51lead 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 | 122.00 / 30.4375 | 4.008 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 20.36 / 5.517 | 3.691 |
| 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 * 3.691^2 + 4.008^2 * 2.2^2) | 23.6 |
| Reorder point | d * LT + safety stock | 4.008 * 9.6 + 23.6 | 62.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 62.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1463/yr, S = 45.00, h = 20%, price = 16.77 | 198.1 |
| Inventory position | on hand + on order | 204 + 0 | 204 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 16.77 | 198 | 25,199 | yes (chosen if cheapest) |
| 1,100 | 16.10 | 1,100 | 25,384 | yes |
| 2,200 | 15.43 | 2,200 | 25,996 | yes |
MOQ 550, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 28, 2026 | 204 / 550 | 16.77 | 3,420.86 |
Movement ledger 115 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-965 | MAIN | 10 | 16.77 | -167.69 | 204 | 3,420.86 | July 28, 2026: 10 @ 16.77 |
| Oct. 13, 2026 | issue | SO-261013-478 | MAIN | 46 | 16.77 | -771.37 | 214 | 3,588.54 | July 28, 2026: 46 @ 16.77 |
| Oct. 12, 2026 | issue | SO-261012-960 | MAIN | 6 | 16.77 | -100.61 | 260 | 4,359.91 | July 28, 2026: 6 @ 16.77 |
| Oct. 11, 2026 | issue | SO-261011-806 | MAIN | 17 | 16.77 | -285.07 | 266 | 4,460.53 | July 28, 2026: 17 @ 16.77 |
| Oct. 8, 2026 | issue | SO-261008-447 | MAIN | 47 | 16.77 | -788.14 | 283 | 4,745.60 | July 28, 2026: 47 @ 16.77 |
| Oct. 1, 2026 | issue | SO-261001-719 | MAIN | 5 | 16.77 | -83.84 | 330 | 5,533.74 | July 28, 2026: 5 @ 16.77 |
| Sept. 25, 2026 | issue | SO-260925-282 | MAIN | 20 | 16.77 | -335.38 | 335 | 5,617.58 | July 28, 2026: 20 @ 16.77 |
| Sept. 21, 2026 | issue | SO-260921-239 | MAIN | 8 | 16.77 | -134.15 | 355 | 5,952.96 | July 28, 2026: 8 @ 16.77 |
| Sept. 19, 2026 | issue | SO-260919-538 | MAIN | 6 | 16.77 | -100.61 | 363 | 6,087.11 | July 28, 2026: 6 @ 16.77 |
| Sept. 10, 2026 | issue | SO-260910-342 | MAIN | 92 | 16.77 | -1,542.74 | 369 | 6,187.72 | July 28, 2026: 92 @ 16.77 |
| Sept. 9, 2026 | issue | SO-260909-223 | MAIN | 8 | 16.77 | -134.15 | 461 | 7,730.46 | July 28, 2026: 8 @ 16.77 |
| Aug. 28, 2026 | issue | SO-260828-714 | MAIN | 22 | 16.77 | -368.92 | 469 | 7,864.61 | July 28, 2026: 22 @ 16.77 |
| Aug. 15, 2026 | issue | SO-260815-616 | MAIN | 7 | 16.77 | -117.38 | 491 | 8,233.53 | July 28, 2026: 7 @ 16.77 |
| Aug. 3, 2026 | issue | SO-260803-664 | MAIN | 68 | 16.65 | -1,132.53 | 498 | 8,350.91 | March 3, 2026: 16 @ 16.28; July 28, 2026: 52 @ 16.77 |
| Aug. 1, 2026 | issue | SO-260801-104 | MAIN | 5 | 16.28 | -81.42 | 566 | 9,483.45 | March 3, 2026: 5 @ 16.28 |
| July 28, 2026 | receipt | PO-001680 | MAIN | 550 | 16.77 | 9,222.90 | 571 | 9,564.87 | |
| July 22, 2026 | issue | SO-260722-274 | MAIN | 35 | 16.28 | -569.95 | 21 | 341.97 | March 3, 2026: 35 @ 16.28 |
| July 18, 2026 | issue | SO-260718-567 | MAIN | 18 | 16.28 | -293.12 | 56 | 911.93 | March 3, 2026: 18 @ 16.28 |
| July 8, 2026 | issue | SO-260708-770 | MAIN | 54 | 16.28 | -879.36 | 74 | 1,205.05 | March 3, 2026: 54 @ 16.28 |
| June 27, 2026 | issue | SO-260627-956 | MAIN | 33 | 16.28 | -537.39 | 128 | 2,084.40 | March 3, 2026: 33 @ 16.28 |
| June 22, 2026 | issue | SO-260622-743 | MAIN | 26 | 16.28 | -423.39 | 161 | 2,621.79 | March 3, 2026: 26 @ 16.28 |
| June 19, 2026 | issue | SO-260619-608 | MAIN | 9 | 16.28 | -146.56 | 187 | 3,045.18 | March 3, 2026: 9 @ 16.28 |
| June 13, 2026 | issue | SO-260613-118 | MAIN | 10 | 16.28 | -162.84 | 196 | 3,191.74 | March 3, 2026: 10 @ 16.28 |
| June 9, 2026 | issue | SO-260609-377 | MAIN | 10 | 16.28 | -162.84 | 206 | 3,354.59 | March 3, 2026: 10 @ 16.28 |
| June 4, 2026 | issue | SO-260604-356 | MAIN | 22 | 16.28 | -358.26 | 216 | 3,517.43 | March 3, 2026: 22 @ 16.28 |
| May 28, 2026 | issue | SO-260528-319 | MAIN | 57 | 16.28 | -928.21 | 238 | 3,875.69 | March 3, 2026: 57 @ 16.28 |
| May 22, 2026 | issue | SO-260522-309 | MAIN | 12 | 16.28 | -195.41 | 295 | 4,803.90 | March 3, 2026: 12 @ 16.28 |
| May 21, 2026 | issue | SO-260521-459 | MAIN | 4 | 16.28 | -65.14 | 307 | 4,999.31 | March 3, 2026: 4 @ 16.28 |
| May 19, 2026 | issue | SO-260519-238 | MAIN | 40 | 16.28 | -651.38 | 311 | 5,064.45 | March 3, 2026: 40 @ 16.28 |
| May 7, 2026 | issue | SO-260507-944 | MAIN | 9 | 16.28 | -146.56 | 351 | 5,715.82 | March 3, 2026: 9 @ 16.28 |
| May 3, 2026 | issue | SO-260503-745 | MAIN | 1 | 16.28 | -16.28 | 360 | 5,862.38 | March 3, 2026: 1 @ 16.28 |
| April 30, 2026 | issue | SO-260430-301 | MAIN | 40 | 16.28 | -651.38 | 361 | 5,878.67 | March 3, 2026: 40 @ 16.28 |
| April 24, 2026 | issue | SO-260424-617 | MAIN | 3 | 16.28 | -48.85 | 401 | 6,530.04 | March 3, 2026: 3 @ 16.28 |
| April 20, 2026 | issue | SO-260420-512 | MAIN | 35 | 16.28 | -569.95 | 404 | 6,578.90 | March 3, 2026: 35 @ 16.28 |
| April 15, 2026 | issue | SO-260415-376 | MAIN | 7 | 16.28 | -113.99 | 439 | 7,148.85 | March 3, 2026: 7 @ 16.28 |
| April 10, 2026 | issue | SO-260410-683 | MAIN | 6 | 16.28 | -97.71 | 446 | 7,262.84 | March 3, 2026: 6 @ 16.28 |
| March 27, 2026 | issue | SO-260327-754 | MAIN | 8 | 16.28 | -130.28 | 452 | 7,360.55 | March 3, 2026: 8 @ 16.28 |
| March 13, 2026 | issue | SO-260313-864 | MAIN | 71 | 16.28 | -1,156.19 | 460 | 7,490.82 | March 3, 2026: 71 @ 16.28 |
| March 11, 2026 | issue | SO-260311-372 | MAIN | 22 | 16.19 | -356.24 | 531 | 8,647.02 | Oct. 9, 2025: 3 @ 15.61; March 3, 2026: 19 @ 16.28 |
| March 10, 2026 | issue | SO-260310-698 | MAIN | 26 | 15.61 | -405.91 | 553 | 9,003.26 | Oct. 9, 2025: 26 @ 15.61 |
| March 3, 2026 | receipt | PO-001277 | MAIN | 550 | 16.28 | 8,956.42 | 579 | 9,409.16 | |
| Feb. 20, 2026 | issue | SO-260220-940 | MAIN | 119 | 15.61 | -1,857.80 | 29 | 452.74 | Oct. 9, 2025: 119 @ 15.61 |
| Feb. 13, 2026 | issue | SO-260213-977 | MAIN | 10 | 15.61 | -156.12 | 148 | 2,310.55 | Oct. 9, 2025: 10 @ 15.61 |
| Jan. 18, 2026 | issue | SO-260118-383 | MAIN | 114 | 15.61 | -1,779.75 | 158 | 2,466.66 | Oct. 9, 2025: 114 @ 15.61 |
| Jan. 3, 2026 | issue | SO-260103-910 | MAIN | 1 | 15.61 | -15.61 | 272 | 4,246.41 | Oct. 9, 2025: 1 @ 15.61 |
| Dec. 30, 2025 | issue | SO-251230-680 | MAIN | 38 | 15.61 | -593.25 | 273 | 4,262.02 | Oct. 9, 2025: 38 @ 15.61 |
| Dec. 18, 2025 | issue | SO-251218-284 | MAIN | 99 | 15.61 | -1,545.57 | 311 | 4,855.27 | Oct. 9, 2025: 99 @ 15.61 |
| Dec. 2, 2025 | issue | SO-251202-643 | MAIN | 30 | 15.61 | -468.35 | 410 | 6,400.84 | Oct. 9, 2025: 30 @ 15.61 |
| Nov. 22, 2025 | issue | SO-251122-255 | MAIN | 3 | 15.61 | -46.84 | 440 | 6,869.19 | Oct. 9, 2025: 3 @ 15.61 |
| Nov. 16, 2025 | issue | SO-251116-829 | MAIN | 41 | 15.61 | -640.08 | 443 | 6,916.03 | Oct. 9, 2025: 41 @ 15.61 |
| Nov. 9, 2025 | issue | SO-251109-617 | MAIN | 26 | 15.61 | -405.91 | 484 | 7,556.11 | Oct. 9, 2025: 26 @ 15.61 |
| Nov. 6, 2025 | issue | SO-251106-956 | MAIN | 30 | 15.61 | -468.35 | 510 | 7,962.02 | Oct. 9, 2025: 30 @ 15.61 |
| Nov. 3, 2025 | issue | SO-251103-623 | MAIN | 9 | 15.61 | -140.51 | 540 | 8,430.37 | Oct. 9, 2025: 9 @ 15.61 |
| Oct. 24, 2025 | issue | SO-251024-863 | MAIN | 32 | 15.72 | -503.03 | 549 | 8,570.88 | May 27, 2025: 31 @ 15.72; Oct. 9, 2025: 1 @ 15.61 |
| Oct. 9, 2025 | receipt | PO-000909 | MAIN | 550 | 15.61 | 8,586.49 | 581 | 9,073.91 | |
| Oct. 4, 2025 | issue | SO-251004-825 | MAIN | 118 | 15.72 | -1,855.35 | 31 | 487.42 | May 27, 2025: 118 @ 15.72 |
| Sept. 24, 2025 | issue | SO-250924-321 | MAIN | 34 | 15.72 | -534.59 | 149 | 2,342.77 | May 27, 2025: 34 @ 15.72 |
| Sept. 20, 2025 | issue | SO-250920-516 | MAIN | 11 | 15.72 | -172.96 | 183 | 2,877.36 | May 27, 2025: 11 @ 15.72 |
| Sept. 19, 2025 | issue | SO-250919-211 | MAIN | 8 | 15.72 | -125.79 | 194 | 3,050.32 | May 27, 2025: 8 @ 15.72 |
| Sept. 13, 2025 | issue | SO-250913-273 | MAIN | 33 | 15.72 | -518.87 | 202 | 3,176.11 | May 27, 2025: 33 @ 15.72 |