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, latest 60 shown - show all
| 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 | |