Items / LED-0032
Downlight 7W Plus LED-0032 · Lighting · BrightLine Lighting
On hand (EA)87MAIN 65, EAST 22
Value (FIFO)1,029.37avg 11.83
ClassCX / FCV 0.32
Turnover4.1xlast issue 0 days ago
Days of cover85lead 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 | 31.33 / 30.4375 | 1.029 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 10.14 / 5.517 | 1.839 |
| 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.839^2 + 1.029^2 * 2.2^2) | 7.8 |
| Reorder point | d * LT + safety stock | 1.029 * 9.6 + 7.8 | 17.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 17.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 376/yr, S = 45.00, h = 20%, price = 11.09 | 240.0 |
| Inventory position | on hand + on order | 87 + 0 | 87 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 11.55 | 121 | 4,619 | yes |
| 240 | 11.09 | 240 | 4,503 | yes (chosen if cheapest) |
| 480 | 10.63 | 480 | 4,538 | yes |
MOQ 120, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 24, 2026 | 87 / 120 | 11.83 | 1,029.37 |
Movement ledger 117 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-574 | MAIN | 2 | 11.83 | -23.66 | 87 | 1,029.37 | Sept. 24, 2026: 2 @ 11.83 |
| Oct. 14, 2026 | issue | SO-261014-350 | MAIN | 1 | 11.83 | -11.83 | 89 | 1,053.03 | Sept. 24, 2026: 1 @ 11.83 |
| Oct. 12, 2026 | issue | SO-261012-407 | EAST | 3 | 11.83 | -35.50 | 90 | 1,064.86 | Sept. 24, 2026: 3 @ 11.83 |
| Oct. 11, 2026 | issue | SO-261011-933 | EAST | 14 | 11.83 | -165.65 | 93 | 1,100.36 | Sept. 24, 2026: 14 @ 11.83 |
| Oct. 2, 2026 | issue | SO-261002-610 | MAIN | 13 | 11.83 | -153.81 | 107 | 1,266.00 | Sept. 24, 2026: 13 @ 11.83 |
| Sept. 24, 2026 | transfer | TRF | MAIN → EAST | 39 | warehouse transfer, no cost effect | ||||
| Sept. 24, 2026 | receipt | PO-001824 | MAIN | 120 | 11.83 | 1,419.82 | 120 | 1,419.82 | |
| Sept. 13, 2026 | issue | SO-260913-759 | MAIN | 5 | 11.23 | -56.16 | 0 | 0.00 | May 7, 2026: 5 @ 11.23 |
| Sept. 12, 2026 | issue | SO-260912-257 | MAIN | 18 | 11.23 | -202.17 | 5 | 56.16 | May 7, 2026: 18 @ 11.23 |
| Aug. 31, 2026 | issue | SO-260831-508 | MAIN | 26 | 11.23 | -292.02 | 23 | 258.33 | May 7, 2026: 26 @ 11.23 |
| Aug. 18, 2026 | issue | SO-260818-170 | MAIN | 13 | 11.23 | -146.01 | 49 | 550.35 | May 7, 2026: 13 @ 11.23 |
| Aug. 10, 2026 | adjustment | Cycle count | MAIN | -1 | 11.23 | -11.23 | 62 | 696.36 | May 7, 2026: 1 @ 11.23 |
| July 29, 2026 | issue | SO-260729-133 | MAIN | 1 | 11.23 | -11.23 | 63 | 707.59 | May 7, 2026: 1 @ 11.23 |
| July 25, 2026 | issue | SO-260725-190 | MAIN | 1 | 11.23 | -11.23 | 64 | 718.82 | May 7, 2026: 1 @ 11.23 |
| July 16, 2026 | issue | SO-260716-779 | MAIN | 10 | 11.23 | -112.32 | 65 | 730.05 | May 7, 2026: 10 @ 11.23 |
| July 13, 2026 | issue | SO-260713-396 | MAIN | 1 | 11.23 | -11.23 | 75 | 842.37 | May 7, 2026: 1 @ 11.23 |
| July 6, 2026 | issue | SO-260706-966 | MAIN | 7 | 11.23 | -78.62 | 76 | 853.60 | May 7, 2026: 7 @ 11.23 |
| July 5, 2026 | issue | SO-260705-284 | MAIN | 5 | 11.23 | -56.16 | 83 | 932.22 | May 7, 2026: 5 @ 11.23 |
| June 19, 2026 | issue | SO-260619-247 | MAIN | 22 | 11.23 | -247.10 | 88 | 988.38 | May 7, 2026: 22 @ 11.23 |
| June 8, 2026 | issue | SO-260608-368 | MAIN | 4 | 11.23 | -44.93 | 110 | 1,235.48 | May 7, 2026: 4 @ 11.23 |
| May 30, 2026 | issue | SO-260530-695 | MAIN | 11 | 11.18 | -123.03 | 114 | 1,280.40 | Feb. 22, 2026: 5 @ 11.13; May 7, 2026: 6 @ 11.23 |
| May 7, 2026 | issue | SO-260507-847 | MAIN | 4 | 11.17 | -44.68 | 125 | 1,403.43 | Jan. 20, 2026: 3 @ 11.18; Feb. 22, 2026: 1 @ 11.13 |
| May 7, 2026 | receipt | PO-001469 | MAIN | 120 | 11.23 | 1,347.79 | 129 | 1,448.11 | |
| April 26, 2026 | issue | SO-260426-586 | MAIN | 9 | 11.13 | -100.20 | 9 | 100.32 | Dec. 28, 2025: 8 @ 11.13; Jan. 20, 2026: 1 @ 11.18 |
| April 23, 2026 | issue | SO-260423-605 | MAIN | 5 | 11.13 | -55.64 | 18 | 200.52 | Dec. 28, 2025: 5 @ 11.13 |
| April 18, 2026 | issue | SO-260418-994 | MAIN | 2 | 11.13 | -22.26 | 23 | 256.16 | Dec. 28, 2025: 2 @ 11.13 |
| April 15, 2026 | issue | SO-260415-607 | MAIN | 9 | 11.13 | -100.15 | 25 | 278.41 | Dec. 28, 2025: 9 @ 11.13 |
| April 3, 2026 | issue | SO-260403-263 | MAIN | 1 | 11.13 | -11.13 | 34 | 378.56 | Dec. 28, 2025: 1 @ 11.13 |
| March 31, 2026 | issue | SO-260331-909 | MAIN | 1 | 11.13 | -11.13 | 35 | 389.69 | Dec. 28, 2025: 1 @ 11.13 |
| March 29, 2026 | issue | SO-260329-798 | MAIN | 5 | 11.13 | -55.64 | 36 | 400.82 | Dec. 28, 2025: 5 @ 11.13 |
| March 27, 2026 | issue | SO-260327-789 | MAIN | 4 | 11.13 | -44.51 | 41 | 456.45 | Dec. 28, 2025: 4 @ 11.13 |
| March 24, 2026 | issue | SO-260324-987 | MAIN | 1 | 11.13 | -11.13 | 45 | 500.96 | Dec. 28, 2025: 1 @ 11.13 |
| March 19, 2026 | issue | SO-260319-941 | MAIN | 6 | 11.13 | -66.76 | 46 | 512.09 | Dec. 28, 2025: 6 @ 11.13 |
| March 5, 2026 | issue | SO-260305-499 | MAIN | 4 | 11.13 | -44.51 | 52 | 578.86 | Dec. 28, 2025: 4 @ 11.13 |
| Feb. 22, 2026 | return | RMA | MAIN | 6 | 11.13 | 66.76 | 56 | 623.37 | |
| Feb. 10, 2026 | issue | SO-260210-324 | MAIN | 1 | 11.13 | -11.13 | 50 | 556.60 | Dec. 28, 2025: 1 @ 11.13 |
| Feb. 8, 2026 | issue | SO-260208-607 | MAIN | 14 | 11.13 | -155.78 | 51 | 567.73 | Dec. 28, 2025: 14 @ 11.13 |
| Feb. 7, 2026 | issue | SO-260207-554 | MAIN | 5 | 11.13 | -55.64 | 65 | 723.51 | Dec. 28, 2025: 5 @ 11.13 |
| Feb. 6, 2026 | issue | SO-260206-716 | MAIN | 13 | 11.13 | -144.66 | 70 | 779.15 | Dec. 28, 2025: 13 @ 11.13 |
| Feb. 5, 2026 | issue | SO-260205-262 | MAIN | 7 | 11.13 | -77.89 | 83 | 923.81 | Dec. 28, 2025: 7 @ 11.13 |
| Feb. 2, 2026 | issue | SO-260202-341 | MAIN | 1 | 11.13 | -11.13 | 90 | 1,001.70 | Dec. 28, 2025: 1 @ 11.13 |
| Jan. 26, 2026 | issue | SO-260126-940 | MAIN | 2 | 11.13 | -22.26 | 91 | 1,012.83 | Dec. 28, 2025: 2 @ 11.13 |
| Jan. 26, 2026 | issue | SO-260126-940 | EAST | 8 | 11.13 | -89.02 | 93 | 1,035.08 | Dec. 28, 2025: 8 @ 11.13 |
| Jan. 25, 2026 | issue | SO-260125-226 | EAST | 10 | 11.13 | -111.28 | 101 | 1,124.10 | Dec. 28, 2025: 10 @ 11.13 |
| Jan. 20, 2026 | return | RMA | MAIN | 4 | 11.18 | 44.74 | 111 | 1,235.38 | |
| Jan. 20, 2026 | issue | SO-260120-445 | EAST | 23 | 11.18 | -257.24 | 107 | 1,190.64 | Oct. 5, 2025: 10 @ 11.26; Dec. 28, 2025: 13 @ 11.13 |
| Dec. 31, 2025 | issue | SO-251231-169 | MAIN | 8 | 11.26 | -90.07 | 130 | 1,447.88 | Oct. 5, 2025: 8 @ 11.26 |
| Dec. 28, 2025 | transfer | TRF | MAIN → EAST | 38 | warehouse transfer, no cost effect | ||||
| Dec. 28, 2025 | receipt | PO-001096 | MAIN | 120 | 11.13 | 1,335.30 | 138 | 1,537.95 | |
| Dec. 18, 2025 | issue | SO-251218-431 | EAST | 4 | 11.26 | -45.03 | 18 | 202.65 | Oct. 5, 2025: 4 @ 11.26 |
| Dec. 16, 2025 | issue | SO-251216-556 | MAIN | 15 | 11.26 | -168.87 | 22 | 247.68 | Oct. 5, 2025: 15 @ 11.26 |
| Dec. 9, 2025 | issue | SO-251209-896 | MAIN | 2 | 11.26 | -22.52 | 37 | 416.56 | Oct. 5, 2025: 2 @ 11.26 |
| Dec. 6, 2025 | issue | SO-251206-461 | EAST | 3 | 11.26 | -33.77 | 39 | 439.07 | Oct. 5, 2025: 3 @ 11.26 |
| Nov. 22, 2025 | issue | SO-251122-116 | MAIN | 26 | 11.26 | -292.72 | 42 | 472.85 | Oct. 5, 2025: 26 @ 11.26 |
| Nov. 21, 2025 | issue | SO-251121-682 | EAST | 17 | 11.26 | -191.39 | 68 | 765.56 | Oct. 5, 2025: 17 @ 11.26 |
| Oct. 28, 2025 | issue | SO-251028-907 | EAST | 1 | 11.26 | -11.26 | 85 | 956.96 | Oct. 5, 2025: 1 @ 11.26 |
| Oct. 21, 2025 | issue | SO-251021-747 | MAIN | 1 | 11.26 | -11.26 | 86 | 968.21 | Oct. 5, 2025: 1 @ 11.26 |
| Oct. 10, 2025 | issue | SO-251010-198 | MAIN | 39 | 11.15 | -435.04 | 87 | 979.47 | April 16, 2025: 4 @ 10.59; July 27, 2025: 2 @ 10.59; Oct. 5, 2025: 33 @ 11.26 |
| Oct. 5, 2025 | transfer | TRF | MAIN → EAST | 28 | warehouse transfer, no cost effect | ||||
| Oct. 5, 2025 | receipt | PO-000899 | MAIN | 120 | 11.26 | 1,351.00 | 126 | 1,414.51 | |
| Oct. 2, 2025 | issue | SO-251002-835 | MAIN | 11 | 10.59 | -116.44 | 6 | 63.51 | April 16, 2025: 11 @ 10.59 |
| Sept. 30, 2025 | issue | SO-250930-430 | MAIN | 3 | 10.59 | -31.76 | 17 | 179.95 | April 16, 2025: 3 @ 10.59 |
| Sept. 28, 2025 | issue | SO-250928-889 | MAIN | 9 | 10.59 | -95.27 | 20 | 211.70 | April 16, 2025: 9 @ 10.59 |
| Sept. 24, 2025 | issue | SO-250924-706 | MAIN | 5 | 10.59 | -52.93 | 29 | 306.97 | April 16, 2025: 5 @ 10.59 |
| Sept. 15, 2025 | issue | SO-250915-467 | MAIN | 6 | 10.59 | -63.51 | 34 | 359.90 | April 16, 2025: 6 @ 10.59 |
| Sept. 2, 2025 | issue | SO-250902-393 | MAIN | 7 | 10.59 | -74.10 | 40 | 423.41 | April 16, 2025: 7 @ 10.59 |
| Aug. 30, 2025 | issue | SO-250830-687 | MAIN | 11 | 10.59 | -116.44 | 47 | 497.50 | April 16, 2025: 11 @ 10.59 |
| Aug. 21, 2025 | issue | SO-250821-168 | MAIN | 6 | 10.59 | -63.51 | 58 | 613.94 | April 16, 2025: 6 @ 10.59 |
| Aug. 17, 2025 | issue | SO-250817-558 | MAIN | 2 | 10.59 | -21.17 | 64 | 677.45 | April 16, 2025: 2 @ 10.59 |
| July 30, 2025 | issue | SO-250730-885 | MAIN | 1 | 10.59 | -10.59 | 66 | 698.62 | April 16, 2025: 1 @ 10.59 |
| July 27, 2025 | return | RMA | MAIN | 2 | 10.59 | 21.17 | 67 | 709.21 | |
| July 22, 2025 | issue | SO-250722-920 | MAIN | 2 | 10.59 | -21.17 | 65 | 688.04 | April 16, 2025: 2 @ 10.59 |
| July 22, 2025 | issue | SO-250722-920 | EAST | 4 | 10.59 | -42.34 | 67 | 709.21 | April 16, 2025: 4 @ 10.59 |
| July 3, 2025 | issue | SO-250703-324 | EAST | 13 | 10.59 | -137.61 | 71 | 751.55 | April 16, 2025: 13 @ 10.59 |
| June 27, 2025 | issue | SO-250627-218 | MAIN | 6 | 10.59 | -63.51 | 84 | 889.16 | April 16, 2025: 6 @ 10.59 |
| June 13, 2025 | issue | SO-250613-296 | MAIN | 7 | 10.59 | -74.10 | 90 | 952.67 | April 16, 2025: 7 @ 10.59 |
| June 11, 2025 | issue | SO-250611-596 | MAIN | 4 | 10.59 | -42.34 | 97 | 1,026.76 | April 16, 2025: 4 @ 10.59 |
| May 30, 2025 | issue | SO-250530-758 | MAIN | 8 | 10.59 | -84.68 | 101 | 1,069.11 | April 16, 2025: 8 @ 10.59 |
| May 19, 2025 | issue | SO-250519-424 | MAIN | 1 | 10.59 | -10.59 | 109 | 1,153.79 | April 16, 2025: 1 @ 10.59 |
| May 11, 2025 | issue | SO-250511-154 | EAST | 1 | 10.59 | -10.59 | 110 | 1,164.37 | April 16, 2025: 1 @ 10.59 |
| May 3, 2025 | issue | SO-250503-899 | EAST | 9 | 10.59 | -95.27 | 111 | 1,174.96 | April 16, 2025: 9 @ 10.59 |
| April 22, 2025 | issue | SO-250422-498 | MAIN | 5 | 10.88 | -54.41 | 120 | 1,270.22 | Jan. 7, 2025: 5 @ 10.88 |
| April 16, 2025 | transfer | TRF | MAIN → EAST | 27 | warehouse transfer, no cost effect | ||||
| April 16, 2025 | receipt | PO-000451 | MAIN | 120 | 10.59 | 1,270.22 | 125 | 1,324.64 | |
| April 6, 2025 | issue | SO-250406-869 | MAIN | 17 | 10.88 | -185.00 | 5 | 54.41 | Jan. 7, 2025: 17 @ 10.88 |
| April 2, 2025 | issue | SO-250402-276 | MAIN | 3 | 10.88 | -32.65 | 22 | 239.41 | Jan. 7, 2025: 3 @ 10.88 |
| March 18, 2025 | issue | SO-250318-502 | MAIN | 14 | 10.88 | -152.35 | 25 | 272.06 | Jan. 7, 2025: 14 @ 10.88 |
| March 12, 2025 | issue | SO-250312-496 | MAIN | 13 | 10.88 | -141.47 | 39 | 424.41 | Jan. 7, 2025: 13 @ 10.88 |
| March 9, 2025 | issue | SO-250309-813 | MAIN | 1 | 10.88 | -10.88 | 52 | 565.87 | Jan. 7, 2025: 1 @ 10.88 |
| March 1, 2025 | issue | SO-250301-139 | MAIN | 4 | 10.88 | -43.53 | 53 | 576.76 | Jan. 7, 2025: 4 @ 10.88 |
| Feb. 23, 2025 | issue | SO-250223-804 | MAIN | 23 | 10.88 | -250.29 | 57 | 620.29 | Jan. 7, 2025: 23 @ 10.88 |
| Feb. 16, 2025 | issue | SO-250216-752 | MAIN | 3 | 10.88 | -32.65 | 80 | 870.58 | Jan. 7, 2025: 3 @ 10.88 |
| Feb. 15, 2025 | issue | SO-250215-398 | MAIN | 8 | 10.88 | -87.06 | 83 | 903.22 | Jan. 7, 2025: 8 @ 10.88 |
| Feb. 10, 2025 | issue | SO-250210-797 | MAIN | 3 | 10.88 | -32.65 | 91 | 990.28 | Jan. 7, 2025: 3 @ 10.88 |
| Feb. 3, 2025 | issue | SO-250203-386 | MAIN | 4 | 10.88 | -43.53 | 94 | 1,022.93 | Jan. 7, 2025: 4 @ 10.88 |
| Jan. 31, 2025 | issue | SO-250131-715 | MAIN | 10 | 10.88 | -108.82 | 98 | 1,066.46 | Jan. 7, 2025: 10 @ 10.88 |
| Jan. 13, 2025 | issue | SO-250113-613 | MAIN | 5 | 10.88 | -54.41 | 108 | 1,175.28 | Jan. 7, 2025: 5 @ 10.88 |
| Jan. 12, 2025 | issue | SO-250112-255 | MAIN | 3 | 10.88 | -32.65 | 113 | 1,229.69 | Jan. 7, 2025: 3 @ 10.88 |
| Jan. 8, 2025 | issue | SO-250108-884 | MAIN | 4 | 10.88 | -43.53 | 116 | 1,262.34 | Jan. 7, 2025: 4 @ 10.88 |
| Jan. 8, 2025 | issue | SO-250108-884 | EAST | 5 | 10.97 | -54.86 | 120 | 1,305.86 | Oct. 1, 2024: 5 @ 10.97 |
| Jan. 7, 2025 | receipt | PO-000167 | MAIN | 120 | 10.88 | 1,305.86 | 125 | 1,360.73 | |
| Dec. 30, 2024 | issue | SO-241230-855 | EAST | 18 | 10.97 | -197.50 | 5 | 54.86 | Oct. 1, 2024: 18 @ 10.97 |
| Dec. 30, 2024 | issue | SO-241230-855 | MAIN | 7 | 10.97 | -76.81 | 23 | 252.37 | Oct. 1, 2024: 7 @ 10.97 |
| Dec. 26, 2024 | issue | SO-241226-503 | EAST | 7 | 10.97 | -76.81 | 30 | 329.18 | Oct. 1, 2024: 7 @ 10.97 |
| Dec. 20, 2024 | issue | SO-241220-502 | MAIN | 4 | 10.97 | -43.89 | 37 | 405.98 | Oct. 1, 2024: 4 @ 10.97 |
| Nov. 30, 2024 | issue | SO-241130-341 | MAIN | 1 | 10.97 | -10.97 | 41 | 449.87 | Oct. 1, 2024: 1 @ 10.97 |
| Nov. 22, 2024 | issue | SO-241122-792 | MAIN | 5 | 10.97 | -54.86 | 42 | 460.84 | Oct. 1, 2024: 5 @ 10.97 |
| Nov. 16, 2024 | issue | SO-241116-846 | MAIN | 30 | 10.97 | -329.18 | 47 | 515.71 | Oct. 1, 2024: 30 @ 10.97 |
| Nov. 11, 2024 | issue | SO-241111-925 | MAIN | 1 | 10.97 | -10.97 | 77 | 844.88 | Oct. 1, 2024: 1 @ 10.97 |
| Nov. 9, 2024 | issue | SO-241109-738 | EAST | 3 | 10.97 | -32.92 | 78 | 855.86 | Oct. 1, 2024: 3 @ 10.97 |
| Oct. 16, 2024 | issue | SO-241016-507 | MAIN | 1 | 10.97 | -10.97 | 81 | 888.77 | Oct. 1, 2024: 1 @ 10.97 |
| Oct. 12, 2024 | issue | SO-241012-954 | MAIN | 15 | 10.97 | -164.59 | 82 | 899.74 | Oct. 1, 2024: 15 @ 10.97 |
| Oct. 7, 2024 | issue | SO-241007-960 | MAIN | 12 | 10.97 | -131.67 | 97 | 1,064.33 | Oct. 1, 2024: 12 @ 10.97 |
| Oct. 4, 2024 | issue | SO-241004-398 | MAIN | 7 | 10.97 | -76.81 | 109 | 1,196.00 | Oct. 1, 2024: 7 @ 10.97 |
| Oct. 2, 2024 | issue | SO-241002-783 | EAST | 4 | 10.97 | -43.89 | 116 | 1,272.81 | Oct. 1, 2024: 4 @ 10.97 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 37 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 120 | 10.97 | 1,316.70 | 120 | 1,316.70 | |