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
| 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 |
| Oct. 28, 2025 | issue | SO-251028-888 | MAIN | 19 | 75.68 | -1,437.90 | 85 | 6,438.36 | Aug. 26, 2025: 19 @ 75.68 |
| Oct. 15, 2025 | issue | SO-251015-878 | MAIN | 10 | 75.68 | -756.79 | 104 | 7,876.25 | Aug. 26, 2025: 10 @ 75.68 |
| Sept. 20, 2025 | issue | SO-250920-112 | MAIN | 10 | 75.68 | -756.79 | 114 | 8,633.04 | Aug. 26, 2025: 10 @ 75.68 |
| Sept. 18, 2025 | issue | SO-250918-617 | MAIN | 11 | 76.02 | -836.24 | 124 | 9,389.83 | April 22, 2025: 2 @ 77.57; Aug. 26, 2025: 9 @ 75.68 |
| Sept. 7, 2025 | return | RMA | MAIN | 3 | 77.57 | 232.70 | 135 | 10,226.07 | |
| Aug. 26, 2025 | transfer | TRF | MAIN → EAST | 41 | warehouse transfer, no cost effect | ||||
| Aug. 26, 2025 | receipt | PO-000795 | MAIN | 130 | 75.68 | 9,838.23 | 132 | 9,993.37 | |
| Aug. 23, 2025 | issue | SO-250823-651 | MAIN | 6 | 77.57 | -465.41 | 2 | 155.14 | April 22, 2025: 6 @ 77.57 |
| Aug. 19, 2025 | issue | SO-250819-778 | MAIN | 12 | 77.57 | -930.82 | 8 | 620.54 | April 22, 2025: 12 @ 77.57 |
| Aug. 18, 2025 | issue | SO-250818-804 | MAIN | 5 | 77.57 | -387.84 | 20 | 1,551.36 | April 22, 2025: 5 @ 77.57 |
| Aug. 16, 2025 | issue | SO-250816-911 | MAIN | 1 | 77.57 | -77.57 | 25 | 1,939.20 | April 22, 2025: 1 @ 77.57 |
| Aug. 1, 2025 | issue | SO-250801-633 | MAIN | 1 | 77.57 | -77.57 | 26 | 2,016.77 | April 22, 2025: 1 @ 77.57 |
| July 10, 2025 | issue | SO-250710-684 | MAIN | 4 | 77.57 | -310.27 | 27 | 2,094.34 | April 22, 2025: 4 @ 77.57 |
| July 3, 2025 | issue | SO-250703-195 | MAIN | 21 | 77.57 | -1,628.93 | 31 | 2,404.61 | April 22, 2025: 21 @ 77.57 |
| June 28, 2025 | issue | SO-250628-440 | MAIN | 6 | 77.57 | -465.41 | 52 | 4,033.54 | April 22, 2025: 6 @ 77.57 |
| June 25, 2025 | issue | SO-250625-773 | MAIN | 10 | 77.57 | -775.68 | 58 | 4,498.95 | April 22, 2025: 10 @ 77.57 |
| June 8, 2025 | issue | SO-250608-574 | MAIN | 10 | 77.57 | -775.68 | 68 | 5,274.63 | April 22, 2025: 10 @ 77.57 |
| May 25, 2025 | issue | SO-250525-387 | MAIN | 14 | 77.57 | -1,085.95 | 78 | 6,050.31 | April 22, 2025: 14 @ 77.57 |
| May 24, 2025 | issue | SO-250524-761 | MAIN | 2 | 77.57 | -155.14 | 92 | 7,136.27 | April 22, 2025: 2 @ 77.57 |
| May 19, 2025 | issue | SO-250519-287 | MAIN | 11 | 77.57 | -853.25 | 94 | 7,291.40 | April 22, 2025: 11 @ 77.57 |
| May 18, 2025 | issue | SO-250518-793 | MAIN | 1 | 77.57 | -77.57 | 105 | 8,144.65 | April 22, 2025: 1 @ 77.57 |
| May 9, 2025 | issue | SO-250509-238 | MAIN | 3 | 77.57 | -232.70 | 106 | 8,222.22 | April 22, 2025: 3 @ 77.57 |
| May 4, 2025 | issue | SO-250504-771 | MAIN | 4 | 77.57 | -310.27 | 109 | 8,454.92 | April 22, 2025: 4 @ 77.57 |
| May 1, 2025 | issue | SO-250501-408 | MAIN | 2 | 77.57 | -155.14 | 113 | 8,765.20 | April 22, 2025: 2 @ 77.57 |
| April 28, 2025 | issue | SO-250428-643 | MAIN | 13 | 77.57 | -1,008.39 | 115 | 8,920.33 | April 22, 2025: 13 @ 77.57 |
| April 28, 2025 | issue | SO-250428-643 | EAST | 13 | 74.55 | -969.20 | 128 | 9,928.72 | Jan. 6, 2025: 9 @ 74.01; Jan. 22, 2025: 2 @ 74.01; April 22, 2025: 2 @ 77.57 |
| April 27, 2025 | issue | SO-250427-970 | MAIN | 2 | 74.01 | -148.01 | 141 | 10,897.92 | Jan. 6, 2025: 2 @ 74.01 |
| April 22, 2025 | receipt | PO-000469 | MAIN | 130 | 77.57 | 10,083.85 | 143 | 11,045.93 | |
| April 13, 2025 | issue | SO-250413-288 | EAST | 4 | 74.01 | -296.02 | 13 | 962.08 | Jan. 6, 2025: 4 @ 74.01 |
| March 27, 2025 | issue | SO-250327-563 | EAST | 1 | 74.01 | -74.01 | 17 | 1,258.10 | Jan. 6, 2025: 1 @ 74.01 |
| March 26, 2025 | issue | SO-250326-333 | EAST | 8 | 74.01 | -592.05 | 18 | 1,332.11 | Jan. 6, 2025: 8 @ 74.01 |
| March 26, 2025 | issue | SO-250326-333 | MAIN | 6 | 74.01 | -444.04 | 26 | 1,924.16 | Jan. 6, 2025: 6 @ 74.01 |
| March 19, 2025 | issue | SO-250319-331 | MAIN | 12 | 74.01 | -888.07 | 32 | 2,368.20 | Jan. 6, 2025: 12 @ 74.01 |
| March 4, 2025 | issue | SO-250304-979 | MAIN | 3 | 74.01 | -222.02 | 44 | 3,256.27 | Jan. 6, 2025: 3 @ 74.01 |
| Feb. 5, 2025 | issue | SO-250205-820 | MAIN | 37 | 74.01 | -2,738.23 | 47 | 3,478.29 | Jan. 6, 2025: 37 @ 74.01 |
| Feb. 4, 2025 | issue | SO-250204-894 | MAIN | 18 | 74.01 | -1,332.11 | 84 | 6,216.51 | Jan. 6, 2025: 18 @ 74.01 |
| Jan. 30, 2025 | issue | SO-250130-502 | MAIN | 11 | 74.01 | -814.07 | 102 | 7,548.62 | Jan. 6, 2025: 11 @ 74.01 |
| Jan. 27, 2025 | issue | SO-250127-108 | MAIN | 2 | 74.01 | -148.01 | 113 | 8,362.69 | Jan. 6, 2025: 2 @ 74.01 |
| Jan. 22, 2025 | return | RMA | MAIN | 2 | 74.01 | 148.01 | 115 | 8,510.70 | |
| Jan. 21, 2025 | issue | SO-250121-501 | MAIN | 9 | 74.01 | -666.05 | 113 | 8,362.69 | Jan. 6, 2025: 9 @ 74.01 |
| Jan. 12, 2025 | issue | SO-250112-168 | EAST | 4 | 74.01 | -296.02 | 122 | 9,028.74 | Jan. 6, 2025: 4 @ 74.01 |
| Jan. 10, 2025 | issue | SO-250110-508 | MAIN | 4 | 74.01 | -296.02 | 126 | 9,324.77 | Jan. 6, 2025: 4 @ 74.01 |
| Jan. 6, 2025 | transfer | TRF | MAIN → EAST | 30 | warehouse transfer, no cost effect | ||||
| Jan. 6, 2025 | receipt | PO-000166 | MAIN | 130 | 74.01 | 9,620.79 | 130 | 9,620.79 | |
| Dec. 28, 2024 | issue | SO-241228-311 | MAIN | 1 | 77.39 | -77.39 | 0 | 0.00 | Oct. 1, 2024: 1 @ 77.39 |
| Dec. 24, 2024 | issue | SO-241224-820 | MAIN | 25 | 77.39 | -1,934.68 | 1 | 77.39 | Oct. 1, 2024: 25 @ 77.39 |
| Dec. 21, 2024 | issue | SO-241221-643 | MAIN | 13 | 77.39 | -1,006.03 | 26 | 2,012.06 | Oct. 1, 2024: 13 @ 77.39 |
| Nov. 24, 2024 | issue | SO-241124-806 | MAIN | 38 | 77.39 | -2,940.71 | 39 | 3,018.09 | Oct. 1, 2024: 38 @ 77.39 |
| Nov. 16, 2024 | issue | SO-241116-745 | MAIN | 1 | 77.39 | -77.39 | 77 | 5,958.80 | Oct. 1, 2024: 1 @ 77.39 |
| Nov. 7, 2024 | issue | SO-241107-982 | MAIN | 15 | 77.39 | -1,160.80 | 78 | 6,036.19 | Oct. 1, 2024: 15 @ 77.39 |
| Oct. 26, 2024 | issue | SO-241026-391 | MAIN | 7 | 77.39 | -541.71 | 93 | 7,196.99 | Oct. 1, 2024: 7 @ 77.39 |
| Oct. 25, 2024 | issue | SO-241025-325 | MAIN | 25 | 77.39 | -1,934.68 | 100 | 7,738.70 | Oct. 1, 2024: 25 @ 77.39 |
| Oct. 15, 2024 | issue | SO-241015-566 | MAIN | 5 | 77.39 | -386.94 | 125 | 9,673.38 | Oct. 1, 2024: 5 @ 77.39 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 130 | 77.39 | 10,060.31 | 130 | 10,060.31 | |