Items / LED-0033
Downlight 7W Nova LED-0033 · Lighting · BrightLine Lighting
On hand (EA)40MAIN 40
Value (FIFO)2,775.17avg 69.38
ClassCZ / NCV -
Turnover0.0xlast issue 535 days ago
Days of cover-lead time 10d
NRV 48.4656 is below cost: lower-of-cost-or-NRV write-down 836.55.
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 | 0.00 / 30.4375 | 0.000 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 0.00 / 5.517 | 0.000 |
| 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 * 0.000^2 + 0.000^2 * 2.2^2) | 0.0 |
| Reorder point | d * LT + safety stock | 0.000 * 9.6 + 0.0 | 0.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 0/yr, S = 45.00, h = 20%, price = 73.99 | 1.0 |
| Inventory position | on hand + on order | 40 + 0 | 40 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 73.99 | 1 | 7 | yes (chosen if cheapest) |
MOQ 170, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Jan. 30, 2025 | 40 / 170 | 69.38 | 2,775.17 |
Movement ledger 32 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| April 29, 2025 | issue | SO-250429-214 | MAIN | 5 | 69.38 | -346.90 | 40 | 2,775.17 | Jan. 30, 2025: 5 @ 69.38 |
| April 18, 2025 | issue | SO-250418-635 | MAIN | 1 | 69.38 | -69.38 | 45 | 3,122.07 | Jan. 30, 2025: 1 @ 69.38 |
| April 17, 2025 | issue | SO-250417-558 | MAIN | 11 | 69.38 | -763.17 | 46 | 3,191.45 | Jan. 30, 2025: 11 @ 69.38 |
| April 14, 2025 | issue | SO-250414-612 | MAIN | 6 | 69.38 | -416.28 | 57 | 3,954.62 | Jan. 30, 2025: 6 @ 69.38 |
| April 9, 2025 | issue | SO-250409-356 | MAIN | 2 | 69.38 | -138.76 | 63 | 4,370.90 | Jan. 30, 2025: 2 @ 69.38 |
| April 6, 2025 | issue | SO-250406-253 | MAIN | 5 | 69.38 | -346.90 | 65 | 4,509.65 | Jan. 30, 2025: 5 @ 69.38 |
| March 31, 2025 | issue | SO-250331-344 | MAIN | 6 | 69.38 | -416.28 | 70 | 4,856.55 | Jan. 30, 2025: 6 @ 69.38 |
| March 19, 2025 | issue | SO-250319-668 | MAIN | 11 | 69.38 | -763.17 | 76 | 5,272.83 | Jan. 30, 2025: 11 @ 69.38 |
| March 18, 2025 | issue | SO-250318-998 | MAIN | 11 | 69.38 | -763.17 | 87 | 6,036.00 | Jan. 30, 2025: 11 @ 69.38 |
| March 16, 2025 | issue | SO-250316-457 | MAIN | 12 | 69.38 | -832.55 | 98 | 6,799.17 | Jan. 30, 2025: 12 @ 69.38 |
| Feb. 25, 2025 | issue | SO-250225-373 | MAIN | 21 | 69.38 | -1,456.97 | 110 | 7,631.72 | Jan. 30, 2025: 21 @ 69.38 |
| Feb. 20, 2025 | issue | SO-250220-726 | MAIN | 1 | 69.38 | -69.38 | 131 | 9,088.69 | Jan. 30, 2025: 1 @ 69.38 |
| Feb. 15, 2025 | issue | SO-250215-918 | MAIN | 11 | 69.38 | -763.17 | 132 | 9,158.07 | Jan. 30, 2025: 11 @ 69.38 |
| Feb. 12, 2025 | issue | SO-250212-153 | MAIN | 9 | 69.38 | -624.41 | 143 | 9,921.24 | Jan. 30, 2025: 9 @ 69.38 |
| Feb. 11, 2025 | issue | SO-250211-239 | MAIN | 26 | 69.66 | -1,811.15 | 152 | 10,545.65 | Oct. 10, 2024: 8 @ 70.29; Jan. 30, 2025: 18 @ 69.38 |
| Feb. 7, 2025 | issue | SO-250207-379 | MAIN | 4 | 70.29 | -281.16 | 178 | 12,356.80 | Oct. 10, 2024: 4 @ 70.29 |
| Jan. 30, 2025 | receipt | PO-000230 | MAIN | 170 | 69.38 | 11,794.48 | 182 | 12,637.97 | |
| Jan. 20, 2025 | issue | SO-250120-560 | MAIN | 23 | 70.29 | -1,616.68 | 12 | 843.49 | Oct. 1, 2024: 17 @ 70.29; Oct. 10, 2024: 6 @ 70.29 |
| Jan. 12, 2025 | issue | SO-250112-651 | MAIN | 12 | 70.29 | -843.49 | 35 | 2,460.17 | Oct. 1, 2024: 12 @ 70.29 |
| Jan. 9, 2025 | issue | SO-250109-158 | MAIN | 15 | 70.29 | -1,054.36 | 47 | 3,303.65 | Oct. 1, 2024: 15 @ 70.29 |
| Jan. 2, 2025 | issue | SO-250102-242 | MAIN | 5 | 70.29 | -351.45 | 62 | 4,358.01 | Oct. 1, 2024: 5 @ 70.29 |
| Dec. 29, 2024 | issue | SO-241229-862 | MAIN | 18 | 70.29 | -1,265.23 | 67 | 4,709.46 | Oct. 1, 2024: 18 @ 70.29 |
| Dec. 24, 2024 | issue | SO-241224-395 | MAIN | 6 | 70.29 | -421.74 | 85 | 5,974.69 | Oct. 1, 2024: 6 @ 70.29 |
| Dec. 15, 2024 | issue | SO-241215-418 | MAIN | 3 | 70.29 | -210.87 | 91 | 6,396.44 | Oct. 1, 2024: 3 @ 70.29 |
| Dec. 11, 2024 | issue | SO-241211-895 | MAIN | 1 | 70.29 | -70.29 | 94 | 6,607.31 | Oct. 1, 2024: 1 @ 70.29 |
| Dec. 9, 2024 | issue | SO-241209-184 | MAIN | 11 | 70.29 | -773.20 | 95 | 6,677.60 | Oct. 1, 2024: 11 @ 70.29 |
| Nov. 14, 2024 | issue | SO-241114-122 | MAIN | 3 | 70.29 | -210.87 | 106 | 7,450.79 | Oct. 1, 2024: 3 @ 70.29 |
| Nov. 1, 2024 | issue | SO-241101-444 | MAIN | 32 | 70.29 | -2,249.30 | 109 | 7,661.66 | Oct. 1, 2024: 32 @ 70.29 |
| Oct. 30, 2024 | issue | SO-241030-708 | MAIN | 10 | 70.29 | -702.90 | 141 | 9,910.96 | Oct. 1, 2024: 10 @ 70.29 |
| Oct. 10, 2024 | return | RMA | MAIN | 18 | 70.29 | 1,265.23 | 151 | 10,613.87 | |
| Oct. 7, 2024 | issue | SO-241007-736 | MAIN | 37 | 70.29 | -2,600.75 | 133 | 9,348.64 | Oct. 1, 2024: 37 @ 70.29 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 170 | 70.29 | 11,949.38 | 170 | 11,949.38 |