Items / LED-0012
Downlight 7W Pro LED-0012 · Lighting · BrightLine Lighting
On hand (EA)0
Value (FIFO)0.00avg 0.00
ClassBX / FCV 0.24
Turnover7.6xlast issue 5 days ago
Days of cover0lead time 10d
Reorder suggested: 130 units (position at or below reorder point: order EOQ), stockout risk high.
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 | 28.58 / 30.4375 | 0.939 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.79 / 5.517 | 1.230 |
| 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 * 1.230^2 + 0.939^2 * 2.2^2) | 7.1 |
| Reorder point | d * LT + safety stock | 0.939 * 9.6 + 7.1 | 16.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 16.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 343/yr, S = 45.00, h = 20%, price = 81.46 | 43.5 |
| Inventory position | on hand + on order | 0 + 0 | 0 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 81.46 | 44 | 28,631 | yes (chosen if cheapest) |
MOQ 130, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| No stock. | ||||
Movement ledger 114 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 11, 2026 | issue | SO-261011-414 | MAIN | 19 | 81.28 | -1,544.23 | 0 | 0.00 | May 15, 2026: 18 @ 81.37; May 26, 2026: 1 @ 79.51 |
| Oct. 8, 2026 | issue | SO-261008-715 | MAIN | 11 | 81.37 | -895.11 | 19 | 1,544.23 | May 15, 2026: 11 @ 81.37 |
| Oct. 7, 2026 | issue | SO-261007-882 | MAIN | 1 | 81.37 | -81.37 | 30 | 2,439.33 | May 15, 2026: 1 @ 81.37 |
| Sept. 22, 2026 | issue | SO-260922-457 | MAIN | 5 | 81.37 | -406.87 | 31 | 2,520.71 | May 15, 2026: 5 @ 81.37 |
| Sept. 17, 2026 | issue | SO-260917-849 | MAIN | 1 | 81.37 | -81.37 | 36 | 2,927.57 | May 15, 2026: 1 @ 81.37 |
| Sept. 15, 2026 | issue | SO-260915-477 | MAIN | 14 | 81.37 | -1,139.23 | 37 | 3,008.95 | May 15, 2026: 14 @ 81.37 |
| Sept. 9, 2026 | issue | SO-260909-487 | MAIN | 10 | 81.37 | -813.73 | 51 | 4,148.17 | May 15, 2026: 10 @ 81.37 |
| Sept. 3, 2026 | issue | SO-260903-325 | MAIN | 2 | 81.37 | -162.75 | 61 | 4,961.91 | May 15, 2026: 2 @ 81.37 |
| Aug. 30, 2026 | issue | SO-260830-697 | MAIN | 1 | 81.37 | -81.37 | 63 | 5,124.65 | May 15, 2026: 1 @ 81.37 |
| Aug. 29, 2026 | issue | SO-260829-204 | MAIN | 1 | 81.37 | -81.37 | 64 | 5,206.03 | May 15, 2026: 1 @ 81.37 |
| Aug. 16, 2026 | issue | SO-260816-858 | MAIN | 7 | 81.37 | -569.61 | 65 | 5,287.40 | May 15, 2026: 7 @ 81.37 |
| Aug. 7, 2026 | issue | SO-260807-497 | MAIN | 10 | 81.37 | -813.73 | 72 | 5,857.01 | May 15, 2026: 10 @ 81.37 |
| Aug. 4, 2026 | issue | SO-260804-611 | MAIN | 3 | 81.37 | -244.12 | 82 | 6,670.75 | May 15, 2026: 3 @ 81.37 |
| Aug. 1, 2026 | issue | SO-260801-972 | MAIN | 1 | 81.37 | -81.37 | 85 | 6,914.87 | May 15, 2026: 1 @ 81.37 |
| July 17, 2026 | issue | SO-260717-522 | MAIN | 1 | 81.37 | -81.37 | 86 | 6,996.24 | May 15, 2026: 1 @ 81.37 |
| July 7, 2026 | issue | SO-260707-419 | MAIN | 16 | 81.37 | -1,301.97 | 87 | 7,077.61 | May 15, 2026: 16 @ 81.37 |
| June 24, 2026 | issue | SO-260624-830 | MAIN | 4 | 81.37 | -325.49 | 103 | 8,379.59 | May 15, 2026: 4 @ 81.37 |
| June 20, 2026 | issue | SO-260620-647 | MAIN | 4 | 81.37 | -325.49 | 107 | 8,705.08 | May 15, 2026: 4 @ 81.37 |
| June 17, 2026 | issue | SO-260617-359 | MAIN | 8 | 81.37 | -650.99 | 111 | 9,030.57 | May 15, 2026: 8 @ 81.37 |
| June 4, 2026 | issue | SO-260604-280 | MAIN | 10 | 81.37 | -813.73 | 119 | 9,681.56 | May 15, 2026: 10 @ 81.37 |
| May 30, 2026 | issue | SO-260530-772 | MAIN | 5 | 80.25 | -401.27 | 129 | 10,495.29 | Jan. 31, 2026: 3 @ 79.51; May 15, 2026: 2 @ 81.37 |
| May 26, 2026 | return | RMA | MAIN | 1 | 79.51 | 79.51 | 134 | 10,896.56 | |
| May 20, 2026 | issue | SO-260520-349 | MAIN | 3 | 79.51 | -238.53 | 133 | 10,817.06 | Dec. 27, 2025: 1 @ 79.51; Jan. 31, 2026: 2 @ 79.51 |
| May 15, 2026 | receipt | PO-001494 | MAIN | 130 | 81.37 | 10,578.53 | 136 | 11,055.58 | |
| May 14, 2026 | issue | SO-260514-119 | MAIN | 1 | 79.51 | -79.51 | 6 | 477.05 | Dec. 27, 2025: 1 @ 79.51 |
| May 11, 2026 | issue | SO-260511-604 | MAIN | 1 | 79.51 | -79.51 | 7 | 556.56 | Dec. 27, 2025: 1 @ 79.51 |
| May 9, 2026 | issue | SO-260509-511 | MAIN | 4 | 79.51 | -318.04 | 8 | 636.07 | Dec. 27, 2025: 4 @ 79.51 |
| May 6, 2026 | issue | SO-260506-774 | MAIN | 8 | 79.51 | -636.07 | 12 | 954.11 | Dec. 27, 2025: 8 @ 79.51 |
| April 25, 2026 | issue | SO-260425-791 | MAIN | 6 | 79.51 | -477.05 | 20 | 1,590.18 | Dec. 27, 2025: 6 @ 79.51 |
| April 15, 2026 | issue | SO-260415-596 | MAIN | 4 | 79.51 | -318.04 | 26 | 2,067.23 | Dec. 27, 2025: 4 @ 79.51 |
| April 8, 2026 | issue | SO-260408-176 | MAIN | 4 | 79.51 | -318.04 | 30 | 2,385.26 | Dec. 27, 2025: 4 @ 79.51 |
| April 4, 2026 | issue | SO-260404-387 | MAIN | 6 | 79.51 | -477.05 | 34 | 2,703.30 | Dec. 27, 2025: 6 @ 79.51 |
| April 1, 2026 | issue | SO-260401-364 | MAIN | 12 | 79.51 | -954.11 | 40 | 3,180.35 | Dec. 27, 2025: 12 @ 79.51 |
| March 26, 2026 | issue | SO-260326-392 | MAIN | 5 | 79.51 | -397.54 | 52 | 4,134.46 | Dec. 27, 2025: 5 @ 79.51 |
| March 24, 2026 | issue | SO-260324-192 | MAIN | 6 | 79.51 | -477.05 | 57 | 4,532.00 | Dec. 27, 2025: 6 @ 79.51 |
| March 19, 2026 | issue | SO-260319-894 | MAIN | 9 | 79.51 | -715.58 | 63 | 5,009.05 | Dec. 27, 2025: 9 @ 79.51 |
| March 14, 2026 | issue | SO-260314-459 | MAIN | 8 | 79.51 | -636.07 | 72 | 5,724.63 | Dec. 27, 2025: 8 @ 79.51 |
| March 12, 2026 | issue | SO-260312-462 | MAIN | 1 | 79.51 | -79.51 | 80 | 6,360.70 | Dec. 27, 2025: 1 @ 79.51 |
| March 10, 2026 | issue | SO-260310-882 | MAIN | 2 | 79.51 | -159.02 | 81 | 6,440.21 | Dec. 27, 2025: 2 @ 79.51 |
| Feb. 23, 2026 | issue | SO-260223-314 | MAIN | 1 | 79.51 | -79.51 | 83 | 6,599.23 | Dec. 27, 2025: 1 @ 79.51 |
| Feb. 21, 2026 | issue | SO-260221-346 | MAIN | 10 | 79.51 | -795.09 | 84 | 6,678.74 | Dec. 27, 2025: 10 @ 79.51 |
| Feb. 17, 2026 | issue | SO-260217-712 | MAIN | 1 | 79.51 | -79.51 | 94 | 7,473.83 | Dec. 27, 2025: 1 @ 79.51 |
| Feb. 15, 2026 | issue | SO-260215-520 | MAIN | 7 | 79.51 | -556.56 | 95 | 7,553.34 | Dec. 27, 2025: 7 @ 79.51 |
| Feb. 1, 2026 | issue | SO-260201-280 | MAIN | 12 | 79.51 | -954.11 | 102 | 8,109.90 | Dec. 27, 2025: 12 @ 79.51 |
| Jan. 31, 2026 | return | RMA | MAIN | 5 | 79.51 | 397.54 | 114 | 9,064.00 | |
| Jan. 31, 2026 | issue | SO-260131-301 | MAIN | 4 | 79.51 | -318.04 | 109 | 8,666.46 | Dec. 27, 2025: 4 @ 79.51 |
| Jan. 25, 2026 | issue | SO-260125-337 | MAIN | 10 | 79.51 | -795.09 | 113 | 8,984.49 | Dec. 27, 2025: 10 @ 79.51 |
| Jan. 21, 2026 | issue | SO-260121-380 | MAIN | 6 | 79.51 | -477.05 | 123 | 9,779.58 | Dec. 27, 2025: 6 @ 79.51 |
| Jan. 16, 2026 | issue | SO-260116-692 | MAIN | 6 | 76.32 | -457.90 | 129 | 10,256.64 | Dec. 19, 2025: 5 @ 75.68; Dec. 27, 2025: 1 @ 79.51 |
| Jan. 14, 2026 | issue | SO-260114-636 | MAIN | 1 | 75.68 | -75.68 | 135 | 10,714.54 | Dec. 19, 2025: 1 @ 75.68 |
| Jan. 7, 2026 | issue | SO-260107-883 | MAIN | 3 | 76.94 | -230.81 | 136 | 10,790.22 | Sept. 7, 2025: 2 @ 77.57; Dec. 19, 2025: 1 @ 75.68 |
| Dec. 29, 2025 | issue | SO-251229-497 | MAIN | 15 | 75.80 | -1,137.07 | 139 | 11,021.03 | Aug. 26, 2025: 14 @ 75.68; Sept. 7, 2025: 1 @ 77.57 |
| Dec. 27, 2025 | receipt | PO-001092 | MAIN | 130 | 79.51 | 10,336.14 | 154 | 12,158.10 | |
| Dec. 19, 2025 | return | RMA | MAIN | 7 | 75.68 | 529.75 | 24 | 1,821.96 | |
| Dec. 19, 2025 | issue | SO-251219-570 | MAIN | 4 | 75.68 | -302.71 | 17 | 1,292.21 | Aug. 26, 2025: 4 @ 75.68 |
| Dec. 16, 2025 | issue | SO-251216-843 | EAST | 14 | 75.68 | -1,059.50 | 21 | 1,594.92 | Aug. 26, 2025: 14 @ 75.68 |
| Dec. 12, 2025 | issue | SO-251212-134 | MAIN | 17 | 75.68 | -1,286.54 | 35 | 2,654.42 | Aug. 26, 2025: 17 @ 75.68 |
| Dec. 1, 2025 | issue | SO-251201-405 | EAST | 2 | 75.68 | -151.36 | 52 | 3,940.96 | Aug. 26, 2025: 2 @ 75.68 |
| Nov. 27, 2025 | issue | SO-251127-148 | MAIN | 6 | 75.68 | -454.07 | 54 | 4,092.32 | Aug. 26, 2025: 6 @ 75.68 |
| Nov. 21, 2025 | issue | SO-251121-661 | EAST | 25 | 75.68 | -1,891.97 | 60 | 4,546.39 | Aug. 26, 2025: 25 @ 75.68 |