Items / LED-0017
Downlight 7W Lite LED-0017 · Lighting · BrightLine Lighting
On hand (EA)39MAIN 39
Value (FIFO)1,573.63avg 40.35
ClassBX / FCV 0.25
Turnover5.1xlast issue 2 days ago
Days of cover47lead 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 | 25.25 / 30.4375 | 0.830 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.33 / 5.517 | 1.147 |
| 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.147^2 + 0.830^2 * 2.2^2) | 6.5 |
| Reorder point | d * LT + safety stock | 0.830 * 9.6 + 6.5 | 14.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 14.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 303/yr, S = 45.00, h = 20%, price = 41.12 | 57.6 |
| Inventory position | on hand + on order | 39 + 0 | 39 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 41.12 | 58 | 12,924 | yes (chosen if cheapest) |
MOQ 90, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 21, 2026 | 39 / 90 | 40.35 | 1,573.63 |
Movement ledger 123 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-135 | MAIN | 7 | 40.35 | -282.45 | 39 | 1,573.63 | Aug. 21, 2026: 7 @ 40.35 |
| Oct. 4, 2026 | issue | SO-261004-570 | MAIN | 1 | 40.35 | -40.35 | 46 | 1,856.08 | Aug. 21, 2026: 1 @ 40.35 |
| Oct. 3, 2026 | issue | SO-261003-205 | MAIN | 2 | 40.35 | -80.70 | 47 | 1,896.43 | Aug. 21, 2026: 2 @ 40.35 |
| Oct. 2, 2026 | issue | SO-261002-115 | MAIN | 17 | 40.35 | -685.94 | 49 | 1,977.13 | Aug. 21, 2026: 17 @ 40.35 |
| Sept. 30, 2026 | issue | SO-260930-206 | MAIN | 16 | 40.35 | -645.59 | 66 | 2,663.07 | Aug. 21, 2026: 16 @ 40.35 |
| Sept. 21, 2026 | issue | SO-260921-333 | MAIN | 1 | 40.35 | -40.35 | 82 | 3,308.67 | Aug. 21, 2026: 1 @ 40.35 |
| Sept. 20, 2026 | issue | SO-260920-279 | MAIN | 1 | 40.35 | -40.35 | 83 | 3,349.02 | Aug. 21, 2026: 1 @ 40.35 |
| Sept. 10, 2026 | issue | SO-260910-744 | MAIN | 1 | 40.35 | -40.35 | 84 | 3,389.37 | Aug. 21, 2026: 1 @ 40.35 |
| Sept. 5, 2026 | issue | SO-260905-818 | MAIN | 2 | 40.35 | -80.70 | 85 | 3,429.72 | Aug. 21, 2026: 2 @ 40.35 |
| Sept. 2, 2026 | issue | SO-260902-389 | MAIN | 3 | 40.35 | -121.05 | 87 | 3,510.42 | Aug. 21, 2026: 3 @ 40.35 |
| Aug. 21, 2026 | receipt | PO-001731 | MAIN | 90 | 40.35 | 3,631.46 | 90 | 3,631.46 | |
| Aug. 13, 2026 | issue | SO-260813-795 | MAIN | 16 | 41.09 | -657.38 | 0 | 0.00 | April 3, 2026: 13 @ 41.38; April 13, 2026: 3 @ 39.80 |
| Aug. 2, 2026 | issue | SO-260802-216 | MAIN | 2 | 41.38 | -82.76 | 16 | 657.38 | April 3, 2026: 2 @ 41.38 |
| July 24, 2026 | issue | SO-260724-257 | MAIN | 1 | 41.38 | -41.38 | 18 | 740.14 | April 3, 2026: 1 @ 41.38 |
| July 22, 2026 | issue | SO-260722-228 | MAIN | 9 | 41.38 | -372.44 | 19 | 781.52 | April 3, 2026: 9 @ 41.38 |
| July 14, 2026 | issue | SO-260714-998 | MAIN | 5 | 41.38 | -206.91 | 28 | 1,153.96 | April 3, 2026: 5 @ 41.38 |
| July 8, 2026 | issue | SO-260708-960 | MAIN | 8 | 41.38 | -331.06 | 33 | 1,360.87 | April 3, 2026: 8 @ 41.38 |
| June 27, 2026 | issue | SO-260627-918 | MAIN | 3 | 41.38 | -124.15 | 41 | 1,691.93 | April 3, 2026: 3 @ 41.38 |
| June 24, 2026 | issue | SO-260624-860 | MAIN | 5 | 41.38 | -206.91 | 44 | 1,816.07 | April 3, 2026: 5 @ 41.38 |
| June 19, 2026 | issue | SO-260619-158 | MAIN | 2 | 41.38 | -82.76 | 49 | 2,022.98 | April 3, 2026: 2 @ 41.38 |
| June 16, 2026 | issue | SO-260616-443 | MAIN | 1 | 41.38 | -41.38 | 51 | 2,105.74 | April 3, 2026: 1 @ 41.38 |
| June 12, 2026 | issue | SO-260612-718 | MAIN | 5 | 41.38 | -206.91 | 52 | 2,147.13 | April 3, 2026: 5 @ 41.38 |
| June 9, 2026 | issue | SO-260609-451 | MAIN | 5 | 41.38 | -206.91 | 57 | 2,354.04 | April 3, 2026: 5 @ 41.38 |
| May 30, 2026 | issue | SO-260530-102 | MAIN | 2 | 41.38 | -82.76 | 62 | 2,560.95 | April 3, 2026: 2 @ 41.38 |
| May 25, 2026 | issue | SO-260525-596 | MAIN | 2 | 41.38 | -82.76 | 64 | 2,643.71 | April 3, 2026: 2 @ 41.38 |
| May 23, 2026 | issue | SO-260523-453 | MAIN | 1 | 41.38 | -41.38 | 66 | 2,726.47 | April 3, 2026: 1 @ 41.38 |
| May 17, 2026 | issue | SO-260517-983 | MAIN | 4 | 41.38 | -165.53 | 67 | 2,767.86 | April 3, 2026: 4 @ 41.38 |
| May 16, 2026 | issue | SO-260516-933 | MAIN | 7 | 41.38 | -289.67 | 71 | 2,933.38 | April 3, 2026: 7 @ 41.38 |
| May 9, 2026 | issue | SO-260509-929 | MAIN | 5 | 41.38 | -206.91 | 78 | 3,223.06 | April 3, 2026: 5 @ 41.38 |
| April 26, 2026 | issue | SO-260426-723 | MAIN | 8 | 41.38 | -331.06 | 83 | 3,429.97 | April 3, 2026: 8 @ 41.38 |
| April 25, 2026 | issue | SO-260425-517 | MAIN | 2 | 41.38 | -82.76 | 91 | 3,761.02 | April 3, 2026: 2 @ 41.38 |
| April 13, 2026 | return | RMA | MAIN | 3 | 39.80 | 119.41 | 93 | 3,843.78 | |
| April 3, 2026 | receipt | PO-001378 | MAIN | 90 | 41.38 | 3,724.37 | 90 | 3,724.37 | |
| April 1, 2026 | issue | SO-260401-374 | MAIN | 5 | 39.80 | -199.02 | 0 | 0.00 | Dec. 23, 2025: 5 @ 39.80 |
| March 29, 2026 | issue | SO-260329-587 | MAIN | 6 | 39.80 | -238.83 | 5 | 199.02 | Dec. 23, 2025: 6 @ 39.80 |
| March 21, 2026 | issue | SO-260321-661 | MAIN | 16 | 39.80 | -636.87 | 11 | 437.85 | Dec. 23, 2025: 16 @ 39.80 |
| March 2, 2026 | issue | SO-260302-713 | MAIN | 5 | 39.80 | -199.02 | 27 | 1,074.72 | Dec. 23, 2025: 5 @ 39.80 |
| Feb. 26, 2026 | issue | SO-260226-115 | MAIN | 7 | 39.80 | -278.63 | 32 | 1,273.75 | Dec. 23, 2025: 7 @ 39.80 |
| Feb. 23, 2026 | issue | SO-260223-696 | MAIN | 4 | 39.80 | -159.22 | 39 | 1,552.38 | Dec. 23, 2025: 4 @ 39.80 |
| Feb. 17, 2026 | issue | SO-260217-742 | MAIN | 6 | 39.80 | -238.83 | 43 | 1,711.60 | Dec. 23, 2025: 6 @ 39.80 |
| Feb. 13, 2026 | issue | SO-260213-143 | MAIN | 1 | 39.80 | -39.80 | 49 | 1,950.43 | Dec. 23, 2025: 1 @ 39.80 |
| Feb. 12, 2026 | issue | SO-260212-717 | MAIN | 8 | 39.80 | -318.44 | 50 | 1,990.23 | Dec. 23, 2025: 8 @ 39.80 |
| Feb. 4, 2026 | issue | SO-260204-833 | MAIN | 3 | 39.80 | -119.41 | 58 | 2,308.67 | Dec. 23, 2025: 3 @ 39.80 |
| Jan. 29, 2026 | issue | SO-260129-236 | MAIN | 7 | 39.80 | -278.63 | 61 | 2,428.08 | Dec. 23, 2025: 7 @ 39.80 |
| Jan. 27, 2026 | issue | SO-260127-143 | MAIN | 2 | 39.80 | -79.61 | 68 | 2,706.71 | Dec. 23, 2025: 2 @ 39.80 |
| Jan. 26, 2026 | issue | SO-260126-281 | MAIN | 3 | 39.80 | -119.41 | 70 | 2,786.32 | Dec. 23, 2025: 3 @ 39.80 |
| Jan. 23, 2026 | issue | SO-260123-922 | MAIN | 11 | 39.80 | -437.85 | 73 | 2,905.74 | Dec. 23, 2025: 11 @ 39.80 |
| Jan. 19, 2026 | issue | SO-260119-231 | MAIN | 1 | 39.80 | -39.80 | 84 | 3,343.59 | Dec. 23, 2025: 1 @ 39.80 |
| Jan. 1, 2026 | issue | SO-260101-192 | MAIN | 6 | 39.63 | -237.76 | 85 | 3,383.39 | Dec. 10, 2025: 1 @ 38.73; Dec. 23, 2025: 5 @ 39.80 |
| Dec. 23, 2025 | receipt | PO-001076 | MAIN | 90 | 39.80 | 3,582.41 | 91 | 3,621.15 | |
| Dec. 12, 2025 | issue | SO-251212-792 | MAIN | 2 | 38.73 | -77.46 | 1 | 38.73 | Dec. 10, 2025: 2 @ 38.73 |
| Dec. 12, 2025 | issue | SO-251212-792 | EAST | 23 | 38.73 | -890.84 | 3 | 116.20 | Sept. 27, 2025: 23 @ 38.73 |
| Dec. 10, 2025 | return | RMA | MAIN | 3 | 38.73 | 116.20 | 26 | 1,007.03 | |
| Dec. 7, 2025 | issue | SO-251207-234 | EAST | 7 | 38.73 | -271.12 | 23 | 890.84 | Sept. 27, 2025: 7 @ 38.73 |
| Dec. 7, 2025 | issue | SO-251207-234 | MAIN | 4 | 38.73 | -154.93 | 30 | 1,161.96 | Sept. 27, 2025: 4 @ 38.73 |
| Nov. 27, 2025 | issue | SO-251127-310 | MAIN | 4 | 38.73 | -154.93 | 34 | 1,316.89 | Sept. 27, 2025: 4 @ 38.73 |
| Nov. 25, 2025 | issue | SO-251125-954 | MAIN | 8 | 38.73 | -309.86 | 38 | 1,471.82 | Sept. 27, 2025: 8 @ 38.73 |
| Nov. 2, 2025 | issue | SO-251102-343 | MAIN | 19 | 38.73 | -735.91 | 46 | 1,781.67 | Sept. 27, 2025: 19 @ 38.73 |
| Oct. 24, 2025 | issue | SO-251024-405 | MAIN | 8 | 38.73 | -309.86 | 65 | 2,517.58 | Sept. 27, 2025: 8 @ 38.73 |
| Oct. 18, 2025 | issue | SO-251018-789 | MAIN | 20 | 38.69 | -773.73 | 73 | 2,827.44 | July 31, 2025: 2 @ 38.43; Aug. 6, 2025: 1 @ 38.43; Sept. 27, 2025: 17 @ 38.73 |