Items / LED-0026
LED Bulb 12W Pro LED-0026 · Lighting · BrightLine Lighting
On hand (EA)17MAIN 5, EAST 12
Value (FIFO)254.46avg 14.97
ClassCX / FCV 0.34
Turnover17.1xlast issue 1 days ago
Days of cover26lead 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 | 20.25 / 30.4375 | 0.665 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.81 / 5.517 | 1.234 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.900) | 1.282 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.282 * sqrt(9.6 * 1.234^2 + 0.665^2 * 2.2^2) | 5.2 |
| Reorder point | d * LT + safety stock | 0.665 * 9.6 + 5.2 | 11.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 11.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 243/yr, S = 45.00, h = 20%, price = 14.74 | 180.0 |
| Inventory position | on hand + on order | 17 + 0 | 17 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 15.35 | 84 | 3,987 | yes |
| 180 | 14.74 | 180 | 3,904 | yes (chosen if cheapest) |
| 360 | 14.12 | 360 | 3,968 | yes |
MOQ 90, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 5, 2026 | 11 / 90 | 14.97 | 164.65 | |
| Sept. 17, 2026 | 1 / 1 | 14.97 | 14.97 | |
| Sept. 29, 2026 | 5 / 5 | 14.97 | 74.84 |
Movement ledger 115 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-705 | MAIN | 10 | 14.97 | -149.68 | 17 | 254.46 | July 5, 2026: 10 @ 14.97 |
| Oct. 10, 2026 | issue | SO-261010-374 | MAIN | 2 | 14.97 | -29.94 | 27 | 404.15 | July 5, 2026: 2 @ 14.97 |
| Oct. 8, 2026 | issue | SO-261008-997 | MAIN | 2 | 14.97 | -29.94 | 29 | 434.09 | July 5, 2026: 2 @ 14.97 |
| Oct. 7, 2026 | issue | SO-261007-844 | MAIN | 8 | 14.97 | -119.75 | 31 | 464.02 | July 5, 2026: 8 @ 14.97 |
| Oct. 1, 2026 | issue | SO-261001-121 | MAIN | 4 | 14.97 | -59.87 | 39 | 583.77 | July 5, 2026: 4 @ 14.97 |
| Sept. 29, 2026 | return | RMA | MAIN | 5 | 14.97 | 74.84 | 43 | 643.65 | |
| Sept. 29, 2026 | issue | SO-260929-547 | MAIN | 1 | 14.97 | -14.97 | 38 | 568.80 | July 5, 2026: 1 @ 14.97 |
| Sept. 27, 2026 | issue | SO-260927-540 | MAIN | 1 | 14.97 | -14.97 | 39 | 583.77 | July 5, 2026: 1 @ 14.97 |
| Sept. 17, 2026 | return | RMA | MAIN | 1 | 14.97 | 14.97 | 40 | 598.74 | |
| Sept. 17, 2026 | issue | SO-260917-639 | EAST | 1 | 14.97 | -14.97 | 39 | 583.77 | July 5, 2026: 1 @ 14.97 |
| Sept. 14, 2026 | issue | SO-260914-665 | EAST | 9 | 14.97 | -134.72 | 40 | 598.74 | July 5, 2026: 9 @ 14.97 |
| Sept. 11, 2026 | issue | SO-260911-170 | MAIN | 6 | 14.97 | -89.81 | 49 | 733.46 | July 5, 2026: 6 @ 14.97 |
| Sept. 10, 2026 | issue | SO-260910-524 | MAIN | 10 | 14.97 | -149.68 | 55 | 823.27 | July 5, 2026: 10 @ 14.97 |
| Aug. 28, 2026 | issue | SO-260828-636 | MAIN | 1 | 14.97 | -14.97 | 65 | 972.95 | July 5, 2026: 1 @ 14.97 |
| Aug. 24, 2026 | issue | SO-260824-519 | MAIN | 1 | 14.97 | -14.97 | 66 | 987.92 | July 5, 2026: 1 @ 14.97 |
| Aug. 19, 2026 | issue | SO-260819-933 | MAIN | 11 | 14.97 | -164.65 | 67 | 1,002.89 | July 5, 2026: 11 @ 14.97 |
| Aug. 11, 2026 | issue | SO-260811-311 | EAST | 2 | 14.97 | -29.94 | 78 | 1,167.54 | July 5, 2026: 2 @ 14.97 |
| July 30, 2026 | issue | SO-260730-229 | MAIN | 7 | 14.97 | -104.78 | 80 | 1,197.48 | July 5, 2026: 7 @ 14.97 |
| July 21, 2026 | issue | SO-260721-986 | MAIN | 1 | 14.97 | -14.97 | 87 | 1,302.26 | July 5, 2026: 1 @ 14.97 |
| July 6, 2026 | issue | SO-260706-435 | MAIN | 7 | 14.99 | -104.90 | 88 | 1,317.23 | Jan. 27, 2026: 5 @ 14.99; July 5, 2026: 2 @ 14.97 |
| July 5, 2026 | transfer | TRF | MAIN → EAST | 24 | warehouse transfer, no cost effect | ||||
| July 5, 2026 | receipt | PO-001626 | MAIN | 90 | 14.97 | 1,347.16 | 95 | 1,422.13 | |
| June 29, 2026 | issue | SO-260629-801 | MAIN | 1 | 14.99 | -14.99 | 5 | 74.97 | Jan. 27, 2026: 1 @ 14.99 |
| June 25, 2026 | issue | SO-260625-830 | MAIN | 1 | 14.99 | -14.99 | 6 | 89.96 | Jan. 27, 2026: 1 @ 14.99 |
| June 20, 2026 | issue | SO-260620-241 | MAIN | 3 | 14.99 | -44.98 | 7 | 104.96 | Jan. 27, 2026: 3 @ 14.99 |
| June 15, 2026 | issue | SO-260615-429 | MAIN | 1 | 14.99 | -14.99 | 10 | 149.94 | Jan. 27, 2026: 1 @ 14.99 |
| June 10, 2026 | issue | SO-260610-734 | MAIN | 1 | 14.99 | -14.99 | 11 | 164.93 | Jan. 27, 2026: 1 @ 14.99 |
| June 9, 2026 | issue | SO-260609-507 | MAIN | 5 | 14.99 | -74.97 | 12 | 179.92 | Jan. 27, 2026: 5 @ 14.99 |
| June 1, 2026 | issue | SO-260601-825 | MAIN | 2 | 14.99 | -29.99 | 17 | 254.89 | Jan. 27, 2026: 2 @ 14.99 |
| May 19, 2026 | issue | SO-260519-416 | MAIN | 2 | 14.99 | -29.99 | 19 | 284.88 | Jan. 27, 2026: 2 @ 14.99 |
| May 15, 2026 | issue | SO-260515-255 | MAIN | 9 | 14.99 | -134.94 | 21 | 314.87 | Jan. 27, 2026: 9 @ 14.99 |
| May 10, 2026 | issue | SO-260510-892 | MAIN | 1 | 14.99 | -14.99 | 30 | 449.81 | Jan. 27, 2026: 1 @ 14.99 |
| May 3, 2026 | issue | SO-260503-535 | MAIN | 1 | 14.99 | -14.99 | 31 | 464.80 | Jan. 27, 2026: 1 @ 14.99 |
| April 27, 2026 | issue | SO-260427-633 | MAIN | 1 | 14.99 | -14.99 | 32 | 479.80 | Jan. 27, 2026: 1 @ 14.99 |
| April 24, 2026 | issue | SO-260424-411 | MAIN | 11 | 14.99 | -164.93 | 33 | 494.79 | Jan. 27, 2026: 11 @ 14.99 |
| April 21, 2026 | issue | SO-260421-576 | MAIN | 1 | 14.99 | -14.99 | 44 | 659.72 | Jan. 27, 2026: 1 @ 14.99 |
| April 16, 2026 | issue | SO-260416-396 | MAIN | 1 | 14.99 | -14.99 | 45 | 674.71 | Jan. 27, 2026: 1 @ 14.99 |
| March 31, 2026 | issue | SO-260331-384 | MAIN | 6 | 14.99 | -89.96 | 46 | 689.71 | Jan. 27, 2026: 6 @ 14.99 |
| March 23, 2026 | issue | SO-260323-145 | MAIN | 1 | 14.99 | -14.99 | 52 | 779.67 | Jan. 27, 2026: 1 @ 14.99 |
| March 11, 2026 | issue | SO-260311-866 | MAIN | 17 | 14.99 | -254.89 | 53 | 794.66 | Jan. 27, 2026: 17 @ 14.99 |
| Feb. 19, 2026 | issue | SO-260219-589 | MAIN | 1 | 14.99 | -14.99 | 70 | 1,049.55 | Jan. 27, 2026: 1 @ 14.99 |
| Feb. 11, 2026 | issue | SO-260211-323 | MAIN | 2 | 14.99 | -29.99 | 71 | 1,064.55 | Jan. 27, 2026: 2 @ 14.99 |
| Feb. 10, 2026 | issue | SO-260210-821 | MAIN | 1 | 14.99 | -14.99 | 73 | 1,094.53 | Jan. 27, 2026: 1 @ 14.99 |
| Feb. 8, 2026 | issue | SO-260208-146 | MAIN | 16 | 14.99 | -239.90 | 74 | 1,109.53 | Jan. 27, 2026: 16 @ 14.99 |
| Jan. 27, 2026 | receipt | PO-001178 | MAIN | 90 | 14.99 | 1,349.42 | 90 | 1,349.42 | |
| Jan. 20, 2026 | issue | SO-260120-532 | MAIN | 10 | 14.34 | -143.43 | 0 | 0.00 | Nov. 1, 2025: 10 @ 14.34 |
| Jan. 16, 2026 | issue | SO-260116-126 | MAIN | 6 | 14.34 | -86.06 | 10 | 143.43 | Nov. 1, 2025: 6 @ 14.34 |
| Jan. 7, 2026 | issue | SO-260107-953 | MAIN | 3 | 14.34 | -43.03 | 16 | 229.48 | Nov. 1, 2025: 3 @ 14.34 |
| Jan. 3, 2026 | issue | SO-260103-452 | MAIN | 6 | 14.34 | -86.06 | 19 | 272.51 | Nov. 1, 2025: 6 @ 14.34 |
| Dec. 29, 2025 | issue | SO-251229-707 | MAIN | 4 | 14.34 | -57.37 | 25 | 358.56 | Nov. 1, 2025: 4 @ 14.34 |
| Dec. 22, 2025 | issue | SO-251222-371 | MAIN | 6 | 14.34 | -86.06 | 29 | 415.94 | Nov. 1, 2025: 6 @ 14.34 |
| Dec. 20, 2025 | issue | SO-251220-847 | MAIN | 2 | 14.34 | -28.69 | 35 | 501.99 | Nov. 1, 2025: 2 @ 14.34 |
| Dec. 17, 2025 | issue | SO-251217-231 | MAIN | 21 | 14.34 | -301.19 | 37 | 530.68 | Nov. 1, 2025: 21 @ 14.34 |
| Dec. 2, 2025 | issue | SO-251202-649 | MAIN | 2 | 14.34 | -28.69 | 58 | 831.87 | Nov. 1, 2025: 2 @ 14.34 |
| Nov. 30, 2025 | issue | SO-251130-736 | MAIN | 5 | 14.34 | -71.71 | 60 | 860.56 | Nov. 1, 2025: 5 @ 14.34 |
| Nov. 13, 2025 | issue | SO-251113-912 | MAIN | 6 | 14.34 | -86.06 | 65 | 932.27 | Nov. 1, 2025: 6 @ 14.34 |
| Nov. 8, 2025 | issue | SO-251108-461 | MAIN | 7 | 14.34 | -100.40 | 71 | 1,018.32 | Nov. 1, 2025: 7 @ 14.34 |
| Nov. 1, 2025 | issue | SO-251101-677 | MAIN | 12 | 14.34 | -172.11 | 78 | 1,118.72 | Nov. 1, 2025: 12 @ 14.34 |
| Nov. 1, 2025 | receipt | PO-000970 | MAIN | 90 | 14.34 | 1,290.83 | 90 | 1,290.83 | |
| Oct. 21, 2025 | issue | SO-251021-458 | MAIN | 14 | 14.51 | -203.09 | 0 | 0.00 | May 25, 2025: 11 @ 14.51; Sept. 21, 2025: 3 @ 14.51 |
| Oct. 19, 2025 | issue | SO-251019-939 | MAIN | 1 | 14.51 | -14.51 | 14 | 203.09 | May 25, 2025: 1 @ 14.51 |
| Oct. 7, 2025 | issue | SO-251007-961 | MAIN | 1 | 14.51 | -14.51 | 15 | 217.60 | May 25, 2025: 1 @ 14.51 |
| Sept. 27, 2025 | issue | SO-250927-457 | MAIN | 1 | 14.51 | -14.51 | 16 | 232.11 | May 25, 2025: 1 @ 14.51 |
| Sept. 26, 2025 | issue | SO-250926-975 | MAIN | 4 | 14.51 | -58.03 | 17 | 246.61 | May 25, 2025: 4 @ 14.51 |
| Sept. 21, 2025 | return | RMA | MAIN | 3 | 14.51 | 43.52 | 21 | 304.64 | |
| Sept. 17, 2025 | issue | SO-250917-198 | MAIN | 12 | 14.51 | -174.08 | 18 | 261.12 | May 25, 2025: 12 @ 14.51 |
| Sept. 14, 2025 | issue | SO-250914-420 | MAIN | 3 | 14.51 | -43.52 | 30 | 435.20 | May 25, 2025: 3 @ 14.51 |
| Sept. 9, 2025 | issue | SO-250909-464 | MAIN | 7 | 14.51 | -101.55 | 33 | 478.72 | May 25, 2025: 7 @ 14.51 |
| Sept. 1, 2025 | issue | SO-250901-302 | MAIN | 2 | 14.51 | -29.01 | 40 | 580.27 | May 25, 2025: 2 @ 14.51 |
| Aug. 30, 2025 | issue | SO-250830-958 | MAIN | 12 | 14.51 | -174.08 | 42 | 609.28 | May 25, 2025: 12 @ 14.51 |
| Aug. 22, 2025 | issue | SO-250822-295 | MAIN | 12 | 14.51 | -174.08 | 54 | 783.36 | May 25, 2025: 12 @ 14.51 |
| July 31, 2025 | issue | SO-250731-914 | MAIN | 2 | 14.51 | -29.01 | 66 | 957.44 | May 25, 2025: 2 @ 14.51 |
| July 18, 2025 | issue | SO-250718-800 | MAIN | 3 | 14.51 | -43.52 | 68 | 986.46 | May 25, 2025: 3 @ 14.51 |
| July 7, 2025 | issue | SO-250707-372 | MAIN | 5 | 14.51 | -72.53 | 71 | 1,029.98 | May 25, 2025: 5 @ 14.51 |
| June 14, 2025 | issue | SO-250614-354 | MAIN | 12 | 14.51 | -174.08 | 76 | 1,102.51 | May 25, 2025: 12 @ 14.51 |
| June 9, 2025 | issue | SO-250609-318 | MAIN | 2 | 14.51 | -29.01 | 88 | 1,276.59 | May 25, 2025: 2 @ 14.51 |
| May 25, 2025 | receipt | PO-000572 | MAIN | 90 | 14.51 | 1,305.60 | 90 | 1,305.60 | |
| May 23, 2025 | issue | SO-250523-476 | EAST | 8 | 14.32 | -114.55 | 0 | 0.00 | Dec. 24, 2024: 8 @ 14.32 |
| May 17, 2025 | issue | SO-250517-722 | EAST | 6 | 14.32 | -85.91 | 8 | 114.55 | Dec. 24, 2024: 6 @ 14.32 |
| April 16, 2025 | issue | SO-250416-489 | EAST | 4 | 14.32 | -57.28 | 14 | 200.46 | Dec. 24, 2024: 4 @ 14.32 |
| April 13, 2025 | issue | SO-250413-298 | EAST | 2 | 14.32 | -28.64 | 18 | 257.74 | Dec. 24, 2024: 2 @ 14.32 |
| April 13, 2025 | issue | SO-250413-298 | MAIN | 3 | 14.32 | -42.96 | 20 | 286.38 | Dec. 24, 2024: 3 @ 14.32 |
| April 7, 2025 | issue | SO-250407-910 | MAIN | 5 | 14.32 | -71.59 | 23 | 329.33 | Dec. 24, 2024: 5 @ 14.32 |
| April 4, 2025 | issue | SO-250404-520 | MAIN | 3 | 14.32 | -42.96 | 28 | 400.93 | Dec. 24, 2024: 3 @ 14.32 |
| March 19, 2025 | issue | SO-250319-425 | EAST | 13 | 14.32 | -186.14 | 31 | 443.88 | Dec. 24, 2024: 13 @ 14.32 |
| March 18, 2025 | issue | SO-250318-215 | EAST | 1 | 14.32 | -14.32 | 44 | 630.03 | Dec. 24, 2024: 1 @ 14.32 |
| March 10, 2025 | issue | SO-250310-373 | MAIN | 1 | 14.32 | -14.32 | 45 | 644.35 | Dec. 24, 2024: 1 @ 14.32 |
| March 7, 2025 | issue | SO-250307-483 | MAIN | 2 | 14.32 | -28.64 | 46 | 658.66 | Dec. 24, 2024: 2 @ 14.32 |
| March 3, 2025 | issue | SO-250303-662 | MAIN | 1 | 14.32 | -14.32 | 48 | 687.30 | Dec. 24, 2024: 1 @ 14.32 |
| March 1, 2025 | issue | SO-250301-702 | MAIN | 1 | 14.32 | -14.32 | 49 | 701.62 | Dec. 24, 2024: 1 @ 14.32 |
| Feb. 22, 2025 | issue | SO-250222-995 | MAIN | 10 | 14.32 | -143.19 | 50 | 715.94 | Dec. 24, 2024: 10 @ 14.32 |
| Feb. 19, 2025 | issue | SO-250219-988 | EAST | 5 | 14.32 | -71.59 | 60 | 859.13 | Dec. 24, 2024: 5 @ 14.32 |
| Feb. 15, 2025 | issue | SO-250215-531 | MAIN | 10 | 14.32 | -143.19 | 65 | 930.72 | Dec. 24, 2024: 10 @ 14.32 |
| Feb. 7, 2025 | issue | SO-250207-698 | MAIN | 1 | 14.32 | -14.32 | 75 | 1,073.91 | Dec. 24, 2024: 1 @ 14.32 |
| Jan. 25, 2025 | issue | SO-250125-862 | MAIN | 9 | 14.32 | -128.87 | 76 | 1,088.23 | Dec. 24, 2024: 9 @ 14.32 |
| Jan. 17, 2025 | issue | SO-250117-953 | MAIN | 2 | 14.32 | -28.64 | 85 | 1,217.10 | Dec. 24, 2024: 2 @ 14.32 |
| Jan. 2, 2025 | issue | SO-250102-899 | MAIN | 7 | 14.47 | -101.29 | 87 | 1,245.74 | Oct. 1, 2024: 4 @ 14.58; Dec. 24, 2024: 3 @ 14.32 |
| Dec. 24, 2024 | issue | SO-241224-906 | MAIN | 4 | 14.58 | -58.33 | 94 | 1,347.02 | Oct. 1, 2024: 4 @ 14.58 |
| Dec. 24, 2024 | transfer | TRF | MAIN → EAST | 31 | warehouse transfer, no cost effect | ||||
| Dec. 24, 2024 | receipt | PO-000129 | MAIN | 90 | 14.32 | 1,288.69 | 98 | 1,405.35 | |
| Dec. 21, 2024 | issue | SO-241221-117 | EAST | 3 | 14.58 | -43.75 | 8 | 116.66 | Oct. 1, 2024: 3 @ 14.58 |
| Dec. 16, 2024 | issue | SO-241216-169 | EAST | 1 | 14.58 | -14.58 | 11 | 160.41 | Oct. 1, 2024: 1 @ 14.58 |
| Dec. 13, 2024 | issue | SO-241213-814 | MAIN | 16 | 14.58 | -233.32 | 12 | 174.99 | Oct. 1, 2024: 16 @ 14.58 |
| Dec. 6, 2024 | issue | SO-241206-836 | MAIN | 6 | 14.58 | -87.50 | 28 | 408.31 | Oct. 1, 2024: 6 @ 14.58 |
| Dec. 1, 2024 | issue | SO-241201-279 | MAIN | 10 | 14.58 | -145.82 | 34 | 495.80 | Oct. 1, 2024: 10 @ 14.58 |
| Nov. 30, 2024 | issue | SO-241130-180 | EAST | 12 | 14.58 | -174.99 | 44 | 641.63 | Oct. 1, 2024: 12 @ 14.58 |
| Nov. 13, 2024 | issue | SO-241113-260 | MAIN | 15 | 14.58 | -218.74 | 56 | 816.62 | Oct. 1, 2024: 15 @ 14.58 |
| Oct. 27, 2024 | issue | SO-241027-931 | MAIN | 2 | 14.58 | -29.16 | 71 | 1,035.36 | Oct. 1, 2024: 2 @ 14.58 |
| Oct. 22, 2024 | issue | SO-241022-280 | MAIN | 9 | 14.58 | -131.24 | 73 | 1,064.52 | Oct. 1, 2024: 9 @ 14.58 |
| Oct. 14, 2024 | issue | SO-241014-250 | MAIN | 3 | 14.58 | -43.75 | 82 | 1,195.76 | Oct. 1, 2024: 3 @ 14.58 |
| Oct. 10, 2024 | issue | SO-241010-319 | MAIN | 2 | 14.58 | -29.16 | 85 | 1,239.51 | Oct. 1, 2024: 2 @ 14.58 |
| Oct. 9, 2024 | issue | SO-241009-786 | MAIN | 1 | 14.58 | -14.58 | 87 | 1,268.68 | Oct. 1, 2024: 1 @ 14.58 |
| Oct. 7, 2024 | issue | SO-241007-541 | MAIN | 2 | 14.58 | -29.16 | 88 | 1,283.26 | Oct. 1, 2024: 2 @ 14.58 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 24 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 90 | 14.58 | 1,312.42 | 90 | 1,312.42 | |