Items / LED-0016
Downlight 7W Pro LED-0016 · Lighting · BrightLine Lighting
On hand (EA)352MAIN 352
Value (FIFO)29,082.20avg 82.62
ClassAX / FCV 0.14
Turnover5.6xlast 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 | 209.50 / 30.4375 | 6.883 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 29.88 / 5.517 | 5.416 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(9.6 * 5.416^2 + 6.883^2 * 2.2^2) | 46.0 |
| Reorder point | d * LT + safety stock | 6.883 * 9.6 + 46.0 | 111.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 111.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2512/yr, S = 45.00, h = 20%, price = 83.02 | 116.7 |
| Inventory position | on hand + on order | 352 + 0 | 352 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 83.02 | 117 | 210,507 | yes (chosen if cheapest) |
MOQ 810, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 4, 2026 | 352 / 810 | 82.62 | 29,082.20 |
Movement ledger 122 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-963 | MAIN | 115 | 82.62 | -9,501.29 | 352 | 29,082.20 | Sept. 4, 2026: 115 @ 82.62 |
| Oct. 11, 2026 | issue | SO-261011-324 | MAIN | 102 | 82.62 | -8,427.23 | 467 | 38,583.49 | Sept. 4, 2026: 102 @ 82.62 |
| Oct. 2, 2026 | issue | SO-261002-847 | MAIN | 75 | 82.62 | -6,196.49 | 569 | 47,010.72 | Sept. 4, 2026: 75 @ 82.62 |
| Oct. 1, 2026 | issue | SO-261001-485 | MAIN | 2 | 82.62 | -165.24 | 644 | 53,207.22 | Sept. 4, 2026: 2 @ 82.62 |
| Sept. 20, 2026 | issue | SO-260920-863 | MAIN | 139 | 82.62 | -11,484.17 | 646 | 53,372.46 | Sept. 4, 2026: 139 @ 82.62 |
| Sept. 19, 2026 | issue | SO-260919-592 | MAIN | 45 | 81.54 | -3,669.33 | 785 | 64,856.62 | May 16, 2026: 20 @ 80.19; Sept. 4, 2026: 25 @ 82.62 |
| Sept. 15, 2026 | issue | SO-260915-127 | MAIN | 15 | 80.19 | -1,202.87 | 830 | 68,525.95 | May 16, 2026: 15 @ 80.19 |
| Sept. 13, 2026 | issue | SO-260913-146 | MAIN | 20 | 80.19 | -1,603.83 | 845 | 69,728.82 | May 16, 2026: 20 @ 80.19 |
| Sept. 6, 2026 | issue | SO-260906-524 | MAIN | 20 | 80.19 | -1,603.83 | 865 | 71,332.66 | May 16, 2026: 20 @ 80.19 |
| Sept. 4, 2026 | receipt | PO-001774 | MAIN | 810 | 82.62 | 66,922.12 | 885 | 72,936.49 | |
| Aug. 25, 2026 | issue | SO-260825-853 | MAIN | 206 | 80.19 | -16,519.47 | 75 | 6,014.37 | May 16, 2026: 206 @ 80.19 |
| Aug. 18, 2026 | issue | SO-260818-639 | MAIN | 58 | 80.19 | -4,651.11 | 281 | 22,533.84 | May 16, 2026: 58 @ 80.19 |
| Aug. 3, 2026 | issue | SO-260803-894 | MAIN | 1 | 80.19 | -80.19 | 339 | 27,184.95 | May 16, 2026: 1 @ 80.19 |
| Aug. 1, 2026 | issue | SO-260801-678 | MAIN | 12 | 80.19 | -962.30 | 340 | 27,265.14 | May 16, 2026: 12 @ 80.19 |
| July 22, 2026 | issue | SO-260722-280 | MAIN | 35 | 80.19 | -2,806.71 | 352 | 28,227.44 | May 16, 2026: 35 @ 80.19 |
| July 10, 2026 | issue | SO-260710-167 | MAIN | 127 | 80.19 | -10,184.33 | 387 | 31,034.15 | May 16, 2026: 127 @ 80.19 |
| July 8, 2026 | issue | SO-260708-368 | MAIN | 22 | 80.19 | -1,764.22 | 514 | 41,218.48 | May 16, 2026: 22 @ 80.19 |
| June 15, 2026 | issue | SO-260615-825 | MAIN | 109 | 80.19 | -8,740.88 | 536 | 42,982.70 | May 16, 2026: 109 @ 80.19 |
| June 4, 2026 | issue | SO-260604-994 | MAIN | 74 | 80.19 | -5,934.18 | 645 | 51,723.58 | May 16, 2026: 74 @ 80.19 |
| May 31, 2026 | issue | SO-260531-512 | MAIN | 58 | 80.19 | -4,651.11 | 719 | 57,657.76 | May 16, 2026: 58 @ 80.19 |
| May 26, 2026 | issue | SO-260526-970 | MAIN | 33 | 80.19 | -2,646.32 | 777 | 62,308.87 | May 16, 2026: 33 @ 80.19 |
| May 16, 2026 | receipt | PO-001496 | MAIN | 810 | 80.19 | 64,955.20 | 810 | 64,955.20 | |
| May 11, 2026 | issue | SO-260511-506 | MAIN | 33 | 80.58 | -2,659.10 | 0 | 0.00 | Dec. 15, 2025: 33 @ 80.58 |
| May 9, 2026 | issue | SO-260509-569 | MAIN | 77 | 80.58 | -6,204.57 | 33 | 2,659.10 | Dec. 15, 2025: 77 @ 80.58 |
| April 28, 2026 | issue | SO-260428-324 | MAIN | 161 | 80.58 | -12,973.19 | 110 | 8,863.67 | Dec. 15, 2025: 161 @ 80.58 |
| April 21, 2026 | issue | SO-260421-964 | MAIN | 8 | 80.58 | -644.63 | 271 | 21,836.85 | Dec. 15, 2025: 8 @ 80.58 |
| April 9, 2026 | issue | SO-260409-544 | MAIN | 19 | 80.58 | -1,531.00 | 279 | 22,481.49 | Dec. 15, 2025: 19 @ 80.58 |
| March 26, 2026 | issue | SO-260326-714 | MAIN | 64 | 80.58 | -5,157.04 | 298 | 24,012.48 | Dec. 15, 2025: 64 @ 80.58 |
| March 23, 2026 | issue | SO-260323-361 | MAIN | 23 | 80.58 | -1,853.31 | 362 | 29,169.53 | Dec. 15, 2025: 23 @ 80.58 |
| March 21, 2026 | issue | SO-260321-593 | MAIN | 44 | 80.58 | -3,545.47 | 385 | 31,022.84 | Dec. 15, 2025: 44 @ 80.58 |
| March 16, 2026 | issue | SO-260316-689 | MAIN | 20 | 80.58 | -1,611.58 | 429 | 34,568.31 | Dec. 15, 2025: 20 @ 80.58 |
| March 3, 2026 | issue | SO-260303-979 | MAIN | 33 | 80.58 | -2,659.10 | 449 | 36,179.88 | Dec. 15, 2025: 33 @ 80.58 |
| March 2, 2026 | issue | SO-260302-345 | MAIN | 10 | 80.58 | -805.79 | 482 | 38,838.98 | Dec. 15, 2025: 10 @ 80.58 |
| Feb. 17, 2026 | issue | SO-260217-282 | MAIN | 179 | 80.58 | -14,423.61 | 492 | 39,644.77 | Dec. 15, 2025: 179 @ 80.58 |
| Feb. 9, 2026 | issue | SO-260209-272 | MAIN | 45 | 80.58 | -3,626.05 | 671 | 54,068.37 | Dec. 15, 2025: 45 @ 80.58 |
| Jan. 28, 2026 | issue | SO-260128-738 | MAIN | 3 | 80.58 | -241.74 | 716 | 57,694.42 | Dec. 15, 2025: 3 @ 80.58 |
| Jan. 14, 2026 | issue | SO-260114-458 | MAIN | 132 | 79.51 | -10,495.63 | 719 | 57,936.16 | Sept. 9, 2025: 26 @ 77.15; Dec. 9, 2025: 14 @ 77.15; Dec. 12, 2025: 1 @ 77.15; Dec. 15, 2025: 91 @ 80.58 |
| Jan. 13, 2026 | issue | SO-260113-377 | MAIN | 62 | 77.15 | -4,783.01 | 851 | 68,431.79 | Sept. 9, 2025: 62 @ 77.15 |
| Dec. 30, 2025 | issue | SO-251230-326 | MAIN | 46 | 77.15 | -3,548.68 | 913 | 73,214.79 | Sept. 9, 2025: 46 @ 77.15 |
| Dec. 29, 2025 | issue | SO-251229-103 | MAIN | 17 | 77.15 | -1,311.47 | 959 | 76,763.48 | Sept. 9, 2025: 17 @ 77.15 |
| Dec. 15, 2025 | receipt | PO-001054 | MAIN | 810 | 80.58 | 65,268.83 | 976 | 78,074.95 | |
| Dec. 12, 2025 | return | RMA | MAIN | 1 | 77.15 | 77.15 | 166 | 12,806.12 | |
| Dec. 11, 2025 | issue | SO-251211-726 | MAIN | 2 | 77.15 | -154.29 | 165 | 12,728.97 | Sept. 9, 2025: 2 @ 77.15 |
| Dec. 9, 2025 | return | RMA | MAIN | 14 | 77.15 | 1,080.03 | 167 | 12,883.27 | |
| Dec. 4, 2025 | issue | SO-251204-640 | MAIN | 165 | 77.15 | -12,728.97 | 153 | 11,803.23 | Sept. 9, 2025: 165 @ 77.15 |
| Nov. 27, 2025 | issue | SO-251127-470 | MAIN | 2 | 77.15 | -154.29 | 318 | 24,532.21 | Sept. 9, 2025: 2 @ 77.15 |
| Nov. 22, 2025 | issue | SO-251122-245 | MAIN | 28 | 77.15 | -2,160.07 | 320 | 24,686.50 | Sept. 9, 2025: 28 @ 77.15 |
| Nov. 21, 2025 | issue | SO-251121-747 | MAIN | 140 | 77.15 | -10,800.34 | 348 | 26,846.56 | Sept. 9, 2025: 140 @ 77.15 |
| Nov. 16, 2025 | issue | SO-251116-115 | MAIN | 12 | 77.15 | -925.74 | 488 | 37,646.91 | Sept. 9, 2025: 12 @ 77.15 |
| Nov. 14, 2025 | issue | SO-251114-491 | MAIN | 42 | 77.15 | -3,240.10 | 500 | 38,572.65 | Sept. 9, 2025: 42 @ 77.15 |
| Nov. 3, 2025 | issue | SO-251103-349 | MAIN | 19 | 77.15 | -1,465.76 | 542 | 41,812.75 | Sept. 9, 2025: 19 @ 77.15 |
| Oct. 27, 2025 | issue | SO-251027-683 | MAIN | 77 | 77.15 | -5,940.19 | 561 | 43,278.51 | Sept. 9, 2025: 77 @ 77.15 |
| Oct. 22, 2025 | issue | SO-251022-804 | MAIN | 8 | 77.15 | -617.16 | 638 | 49,218.70 | Sept. 9, 2025: 8 @ 77.15 |
| Oct. 2, 2025 | issue | SO-251002-678 | MAIN | 84 | 77.15 | -6,480.21 | 646 | 49,835.86 | Sept. 9, 2025: 84 @ 77.15 |
| Sept. 27, 2025 | issue | SO-250927-365 | MAIN | 62 | 77.15 | -4,783.01 | 730 | 56,316.07 | Sept. 9, 2025: 62 @ 77.15 |
| Sept. 18, 2025 | issue | SO-250918-963 | MAIN | 5 | 77.15 | -385.73 | 792 | 61,099.08 | Sept. 9, 2025: 5 @ 77.15 |
| Sept. 15, 2025 | issue | SO-250915-258 | MAIN | 41 | 77.20 | -3,165.33 | 797 | 61,484.80 | Sept. 5, 2025: 20 @ 77.23; Sept. 8, 2025: 8 @ 77.23; Sept. 9, 2025: 13 @ 77.15 |
| Sept. 12, 2025 | issue | SO-250912-465 | MAIN | 13 | 77.23 | -1,003.99 | 838 | 64,650.13 | Sept. 5, 2025: 13 @ 77.23 |
| Sept. 9, 2025 | receipt | PO-000824 | MAIN | 810 | 77.15 | 62,487.69 | 851 | 65,654.12 | |
| Sept. 8, 2025 | return | RMA | MAIN | 8 | 77.23 | 617.84 | 41 | 3,166.43 |