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
| 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 |
| Aug. 27, 2025 | issue | SO-250827-310 | MAIN | 6 | 15.72 | -94.34 | 235 | 3,694.98 | May 27, 2025: 6 @ 15.72 |
| Aug. 15, 2025 | issue | SO-250815-349 | MAIN | 33 | 15.72 | -518.87 | 241 | 3,789.32 | May 27, 2025: 33 @ 15.72 |
| Aug. 13, 2025 | issue | SO-250813-748 | MAIN | 15 | 15.72 | -235.85 | 274 | 4,308.18 | May 27, 2025: 15 @ 15.72 |
| Aug. 5, 2025 | issue | SO-250805-516 | MAIN | 50 | 15.72 | -786.16 | 289 | 4,544.03 | May 27, 2025: 50 @ 15.72 |
| Aug. 4, 2025 | issue | SO-250804-778 | MAIN | 1 | 15.72 | -15.72 | 339 | 5,330.20 | May 27, 2025: 1 @ 15.72 |
| July 29, 2025 | issue | SO-250729-295 | MAIN | 30 | 15.72 | -471.70 | 340 | 5,345.92 | May 27, 2025: 30 @ 15.72 |
| July 15, 2025 | issue | SO-250715-431 | MAIN | 63 | 15.72 | -990.57 | 370 | 5,817.62 | May 27, 2025: 63 @ 15.72 |
| July 13, 2025 | issue | SO-250713-918 | MAIN | 8 | 15.72 | -125.79 | 433 | 6,808.19 | May 27, 2025: 8 @ 15.72 |
| June 21, 2025 | issue | SO-250621-200 | MAIN | 108 | 15.72 | -1,698.12 | 441 | 6,933.98 | May 27, 2025: 108 @ 15.72 |
| June 18, 2025 | issue | SO-250618-911 | MAIN | 7 | 15.53 | -108.69 | 549 | 8,632.09 | April 1, 2025: 6 @ 15.49; May 27, 2025: 1 @ 15.72 |
| May 27, 2025 | receipt | PO-000580 | MAIN | 550 | 15.72 | 8,647.82 | 556 | 8,740.78 | |
| May 23, 2025 | adjustment | Cycle count | MAIN | -2 | 15.49 | -30.99 | 6 | 92.96 | April 1, 2025: 2 @ 15.49 |
| May 17, 2025 | issue | SO-250517-392 | MAIN | 126 | 15.49 | -1,952.24 | 8 | 123.95 | Dec. 27, 2024: 83 @ 15.49; April 1, 2025: 43 @ 15.49 |
| May 3, 2025 | issue | SO-250503-732 | MAIN | 17 | 15.49 | -263.40 | 134 | 2,076.20 | Dec. 27, 2024: 17 @ 15.49 |
| April 30, 2025 | issue | SO-250430-704 | MAIN | 30 | 15.49 | -464.82 | 151 | 2,339.59 | Dec. 27, 2024: 30 @ 15.49 |
| April 27, 2025 | issue | SO-250427-362 | MAIN | 2 | 15.49 | -30.99 | 181 | 2,804.41 | Dec. 27, 2024: 2 @ 15.49 |
| April 26, 2025 | issue | SO-250426-156 | MAIN | 26 | 15.49 | -402.84 | 183 | 2,835.40 | Dec. 27, 2024: 26 @ 15.49 |
| April 18, 2025 | issue | SO-250418-708 | MAIN | 17 | 15.49 | -263.40 | 209 | 3,238.25 | Dec. 27, 2024: 17 @ 15.49 |
| April 8, 2025 | issue | SO-250408-605 | MAIN | 28 | 15.49 | -433.83 | 226 | 3,501.64 | Dec. 27, 2024: 28 @ 15.49 |
| April 3, 2025 | issue | SO-250403-741 | MAIN | 2 | 15.49 | -30.99 | 254 | 3,935.48 | Dec. 27, 2024: 2 @ 15.49 |
| April 3, 2025 | issue | SO-250403-741 | EAST | 1 | 15.49 | -15.49 | 256 | 3,966.46 | Dec. 27, 2024: 1 @ 15.49 |
| April 1, 2025 | return | RMA | MAIN | 51 | 15.49 | 790.19 | 257 | 3,981.96 | |
| March 28, 2025 | issue | SO-250328-758 | EAST | 13 | 15.49 | -201.42 | 206 | 3,191.76 | Dec. 27, 2024: 13 @ 15.49 |
| March 20, 2025 | issue | SO-250320-600 | EAST | 103 | 15.49 | -1,595.88 | 219 | 3,393.19 | Dec. 27, 2024: 103 @ 15.49 |
| March 13, 2025 | issue | SO-250313-845 | EAST | 5 | 15.49 | -77.47 | 322 | 4,989.07 | Dec. 27, 2024: 5 @ 15.49 |
| Feb. 12, 2025 | issue | SO-250212-146 | MAIN | 36 | 15.49 | -557.78 | 327 | 5,066.54 | Dec. 27, 2024: 36 @ 15.49 |
| Feb. 3, 2025 | issue | SO-250203-909 | MAIN | 26 | 15.49 | -402.84 | 363 | 5,624.32 | Dec. 27, 2024: 26 @ 15.49 |
| Feb. 2, 2025 | issue | SO-250202-779 | EAST | 82 | 15.49 | -1,270.51 | 389 | 6,027.17 | Dec. 27, 2024: 82 @ 15.49 |
| Jan. 17, 2025 | issue | SO-250117-699 | MAIN | 36 | 15.49 | -557.78 | 471 | 7,297.67 | Dec. 27, 2024: 36 @ 15.49 |
| Jan. 12, 2025 | issue | SO-250112-944 | MAIN | 69 | 15.66 | -1,080.46 | 507 | 7,855.46 | Oct. 1, 2024: 26 @ 15.93; Dec. 27, 2024: 43 @ 15.49 |
| Jan. 11, 2025 | issue | SO-250111-606 | EAST | 10 | 15.93 | -159.32 | 576 | 8,935.92 | Oct. 1, 2024: 10 @ 15.93 |
| Jan. 6, 2025 | issue | SO-250106-596 | MAIN | 10 | 15.93 | -159.32 | 586 | 9,095.23 | Oct. 1, 2024: 10 @ 15.93 |
| Jan. 4, 2025 | issue | SO-250104-520 | MAIN | 35 | 15.93 | -557.60 | 596 | 9,254.55 | Oct. 1, 2024: 35 @ 15.93 |
| Dec. 27, 2024 | transfer | TRF | MAIN → EAST | 133 | warehouse transfer, no cost effect | ||||
| Dec. 27, 2024 | receipt | PO-000140 | MAIN | 550 | 15.49 | 8,521.70 | 631 | 9,812.15 | |
| Dec. 18, 2024 | issue | SO-241218-464 | EAST | 39 | 15.93 | -621.33 | 81 | 1,290.45 | Oct. 1, 2024: 39 @ 15.93 |
| Dec. 16, 2024 | issue | SO-241216-255 | EAST | 3 | 15.93 | -47.79 | 120 | 1,911.78 | Oct. 1, 2024: 3 @ 15.93 |
| Dec. 16, 2024 | issue | SO-241216-255 | MAIN | 20 | 15.93 | -318.63 | 123 | 1,959.57 | Oct. 1, 2024: 20 @ 15.93 |
| Dec. 13, 2024 | issue | SO-241213-752 | MAIN | 35 | 15.93 | -557.60 | 143 | 2,278.20 | Oct. 1, 2024: 35 @ 15.93 |
| Dec. 9, 2024 | issue | SO-241209-139 | MAIN | 48 | 15.93 | -764.71 | 178 | 2,835.81 | Oct. 1, 2024: 48 @ 15.93 |
| Dec. 8, 2024 | issue | SO-241208-629 | MAIN | 5 | 15.93 | -79.66 | 226 | 3,600.52 | Oct. 1, 2024: 5 @ 15.93 |
| Dec. 2, 2024 | issue | SO-241202-167 | MAIN | 21 | 15.93 | -334.56 | 231 | 3,680.18 | Oct. 1, 2024: 21 @ 15.93 |
| Nov. 30, 2024 | issue | SO-241130-726 | EAST | 28 | 15.93 | -446.08 | 252 | 4,014.74 | Oct. 1, 2024: 28 @ 15.93 |
| Nov. 18, 2024 | issue | SO-241118-694 | MAIN | 45 | 15.93 | -716.92 | 280 | 4,460.82 | Oct. 1, 2024: 45 @ 15.93 |
| Nov. 11, 2024 | issue | SO-241111-958 | EAST | 3 | 15.93 | -47.79 | 325 | 5,177.74 | Oct. 1, 2024: 3 @ 15.93 |
| Nov. 10, 2024 | issue | SO-241110-608 | MAIN | 32 | 15.93 | -509.81 | 328 | 5,225.53 | Oct. 1, 2024: 32 @ 15.93 |
| Nov. 5, 2024 | issue | SO-241105-450 | MAIN | 18 | 15.93 | -286.77 | 360 | 5,735.34 | Oct. 1, 2024: 18 @ 15.93 |
| Nov. 1, 2024 | issue | SO-241101-199 | MAIN | 15 | 15.93 | -238.97 | 378 | 6,022.11 | Oct. 1, 2024: 15 @ 15.93 |
| Oct. 24, 2024 | issue | SO-241024-395 | MAIN | 26 | 15.93 | -414.22 | 393 | 6,261.08 | Oct. 1, 2024: 26 @ 15.93 |
| Oct. 23, 2024 | issue | SO-241023-328 | EAST | 4 | 15.93 | -63.73 | 419 | 6,675.30 | Oct. 1, 2024: 4 @ 15.93 |
| Oct. 22, 2024 | issue | SO-241022-286 | MAIN | 43 | 15.93 | -685.05 | 423 | 6,739.02 | Oct. 1, 2024: 43 @ 15.93 |
| Oct. 18, 2024 | issue | SO-241018-103 | EAST | 14 | 15.93 | -223.04 | 466 | 7,424.08 | Oct. 1, 2024: 14 @ 15.93 |
| Oct. 16, 2024 | issue | SO-241016-504 | MAIN | 70 | 15.93 | -1,115.20 | 480 | 7,647.12 | Oct. 1, 2024: 70 @ 15.93 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 172 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 550 | 15.93 | 8,762.32 | 550 | 8,762.32 | |