Items / LED-0021
Panel Light 15W Lite LED-0021 · Lighting · BrightLine Lighting
On hand (EA)325MAIN 325
Value (FIFO)44,113.84avg 135.73
ClassAX / FCV 0.23
Turnover5.8xlast issue 0 days ago
Days of cover58lead 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 | 169.58 / 30.4375 | 5.572 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 38.73 / 5.517 | 7.019 |
| 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 * 7.019^2 + 5.572^2 * 2.2^2) | 51.0 |
| Reorder point | d * LT + safety stock | 5.572 * 9.6 + 51.0 | 104.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 104.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2034/yr, S = 45.00, h = 20%, price = 136.94 | 81.7 |
| Inventory position | on hand + on order | 325 + 0 | 325 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 136.94 | 82 | 280,721 | yes (chosen if cheapest) |
MOQ 660, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 26, 2026 | 325 / 660 | 135.73 | 44,113.84 |
Movement ledger 120 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-872 | MAIN | 21 | 135.73 | -2,850.43 | 325 | 44,113.84 | Aug. 26, 2026: 21 @ 135.73 |
| Oct. 7, 2026 | issue | SO-261007-663 | MAIN | 29 | 135.73 | -3,936.31 | 346 | 46,964.28 | Aug. 26, 2026: 29 @ 135.73 |
| Oct. 6, 2026 | issue | SO-261006-925 | MAIN | 7 | 135.73 | -950.14 | 375 | 50,900.59 | Aug. 26, 2026: 7 @ 135.73 |
| Oct. 3, 2026 | issue | SO-261003-170 | MAIN | 74 | 135.73 | -10,044.38 | 382 | 51,850.73 | Aug. 26, 2026: 74 @ 135.73 |
| Oct. 2, 2026 | issue | SO-261002-336 | MAIN | 61 | 135.73 | -8,279.83 | 456 | 61,895.11 | Aug. 26, 2026: 61 @ 135.73 |
| Sept. 26, 2026 | issue | SO-260926-477 | MAIN | 37 | 135.73 | -5,022.19 | 517 | 70,174.94 | Aug. 26, 2026: 37 @ 135.73 |
| Sept. 25, 2026 | issue | SO-260925-571 | MAIN | 46 | 135.73 | -6,243.81 | 554 | 75,197.13 | Aug. 26, 2026: 46 @ 135.73 |
| Sept. 14, 2026 | issue | SO-260914-350 | MAIN | 7 | 135.73 | -950.14 | 600 | 81,440.94 | Aug. 26, 2026: 7 @ 135.73 |
| Sept. 12, 2026 | issue | SO-260912-275 | MAIN | 1 | 135.73 | -135.73 | 607 | 82,391.08 | Aug. 26, 2026: 1 @ 135.73 |
| Sept. 11, 2026 | issue | SO-260911-653 | MAIN | 9 | 135.73 | -1,221.61 | 608 | 82,526.82 | Aug. 26, 2026: 9 @ 135.73 |
| Sept. 9, 2026 | issue | SO-260909-258 | MAIN | 43 | 135.73 | -5,836.60 | 617 | 83,748.43 | Aug. 26, 2026: 43 @ 135.73 |
| Aug. 26, 2026 | receipt | PO-001748 | MAIN | 660 | 135.73 | 89,585.03 | 660 | 89,585.03 | |
| Aug. 18, 2026 | issue | SO-260818-148 | MAIN | 90 | 129.87 | -11,688.32 | 0 | 0.00 | March 30, 2026: 90 @ 129.87 |
| Aug. 7, 2026 | issue | SO-260807-660 | MAIN | 45 | 129.87 | -5,844.16 | 90 | 11,688.32 | March 30, 2026: 45 @ 129.87 |
| July 9, 2026 | issue | SO-260709-449 | MAIN | 112 | 129.87 | -14,545.46 | 135 | 17,532.48 | March 30, 2026: 112 @ 129.87 |
| July 7, 2026 | issue | SO-260707-862 | MAIN | 21 | 129.87 | -2,727.27 | 247 | 32,077.94 | March 30, 2026: 21 @ 129.87 |
| June 21, 2026 | issue | SO-260621-968 | MAIN | 33 | 129.87 | -4,285.72 | 268 | 34,805.21 | March 30, 2026: 33 @ 129.87 |
| June 18, 2026 | issue | SO-260618-759 | MAIN | 52 | 129.87 | -6,753.25 | 301 | 39,090.93 | March 30, 2026: 52 @ 129.87 |
| June 15, 2026 | issue | SO-260615-414 | MAIN | 68 | 129.87 | -8,831.17 | 353 | 45,844.18 | March 30, 2026: 68 @ 129.87 |
| June 7, 2026 | issue | SO-260607-763 | MAIN | 24 | 129.87 | -3,116.88 | 421 | 54,675.35 | March 30, 2026: 24 @ 129.87 |
| June 7, 2026 | issue | SO-260607-763 | EAST | 15 | 129.87 | -1,948.05 | 445 | 57,792.24 | March 30, 2026: 15 @ 129.87 |
| May 26, 2026 | issue | SO-260526-553 | MAIN | 18 | 129.87 | -2,337.66 | 460 | 59,740.29 | March 30, 2026: 18 @ 129.87 |
| May 24, 2026 | issue | SO-260524-929 | MAIN | 98 | 129.87 | -12,727.28 | 478 | 62,077.96 | March 30, 2026: 98 @ 129.87 |
| April 29, 2026 | issue | SO-260429-309 | MAIN | 43 | 129.87 | -5,584.42 | 576 | 74,805.24 | March 30, 2026: 43 @ 129.87 |
| April 21, 2026 | issue | SO-260421-391 | MAIN | 70 | 130.17 | -9,112.04 | 619 | 80,389.65 | Dec. 17, 2025: 29 @ 130.60; March 30, 2026: 41 @ 129.87 |
| April 15, 2026 | issue | SO-260415-249 | MAIN | 1 | 130.60 | -130.60 | 689 | 89,501.70 | Dec. 17, 2025: 1 @ 130.60 |
| April 11, 2026 | issue | SO-260411-324 | MAIN | 9 | 130.60 | -1,175.39 | 690 | 89,632.30 | Dec. 17, 2025: 9 @ 130.60 |
| March 30, 2026 | receipt | PO-001366 | MAIN | 660 | 129.87 | 85,714.33 | 699 | 90,807.69 | |
| March 26, 2026 | issue | SO-260326-213 | MAIN | 54 | 130.60 | -7,052.34 | 39 | 5,093.35 | Dec. 17, 2025: 54 @ 130.60 |
| March 21, 2026 | issue | SO-260321-382 | MAIN | 154 | 130.60 | -20,112.22 | 93 | 12,145.69 | Dec. 17, 2025: 154 @ 130.60 |
| March 11, 2026 | issue | SO-260311-749 | EAST | 11 | 130.60 | -1,436.59 | 247 | 32,257.90 | Dec. 17, 2025: 11 @ 130.60 |
| Feb. 22, 2026 | issue | SO-260222-857 | MAIN | 13 | 130.60 | -1,697.78 | 258 | 33,694.49 | Dec. 17, 2025: 13 @ 130.60 |
| Feb. 18, 2026 | issue | SO-260218-864 | MAIN | 36 | 130.60 | -4,701.56 | 271 | 35,392.27 | Dec. 17, 2025: 36 @ 130.60 |
| Feb. 13, 2026 | issue | SO-260213-164 | MAIN | 106 | 130.60 | -13,843.47 | 307 | 40,093.83 | Dec. 17, 2025: 106 @ 130.60 |
| Feb. 3, 2026 | issue | SO-260203-329 | MAIN | 1 | 130.60 | -130.60 | 413 | 53,937.30 | Dec. 17, 2025: 1 @ 130.60 |
| Jan. 30, 2026 | issue | SO-260130-658 | MAIN | 76 | 130.60 | -9,925.51 | 414 | 54,067.90 | Dec. 17, 2025: 76 @ 130.60 |
| Jan. 27, 2026 | issue | SO-260127-164 | MAIN | 5 | 130.60 | -652.99 | 490 | 63,993.41 | Dec. 17, 2025: 5 @ 130.60 |
| Jan. 17, 2026 | issue | SO-260117-187 | MAIN | 100 | 130.60 | -13,059.88 | 495 | 64,646.41 | Dec. 17, 2025: 100 @ 130.60 |
| Jan. 5, 2026 | issue | SO-260105-698 | EAST | 41 | 130.60 | -5,354.55 | 595 | 77,706.29 | Dec. 17, 2025: 41 @ 130.60 |
| Jan. 2, 2026 | issue | SO-260102-617 | EAST | 6 | 130.60 | -783.59 | 636 | 83,060.84 | Dec. 17, 2025: 6 @ 130.60 |
| Dec. 31, 2025 | issue | SO-251231-135 | MAIN | 56 | 132.28 | -7,407.61 | 642 | 83,844.43 | Sept. 16, 2025: 3 @ 133.07; Sept. 24, 2025: 9 @ 133.07; Oct. 12, 2025: 26 @ 133.07; Dec. 17, 2025: 18 @ 130.60 |
| Dec. 30, 2025 | issue | SO-251230-961 | EAST | 42 | 133.07 | -5,589.13 | 698 | 91,252.04 | Sept. 16, 2025: 42 @ 133.07 |
| Dec. 24, 2025 | issue | SO-251224-809 | EAST | 42 | 133.07 | -5,589.13 | 740 | 96,841.18 | Sept. 16, 2025: 42 @ 133.07 |
| Dec. 17, 2025 | transfer | TRF | MAIN → EAST | 157 | warehouse transfer, no cost effect | ||||
| Dec. 17, 2025 | receipt | PO-001058 | MAIN | 660 | 130.60 | 86,195.21 | 782 | 102,430.31 | |
| Dec. 16, 2025 | issue | SO-251216-642 | MAIN | 5 | 133.07 | -665.37 | 122 | 16,235.10 | Sept. 16, 2025: 5 @ 133.07 |
| Dec. 8, 2025 | issue | SO-251208-352 | MAIN | 3 | 133.07 | -399.22 | 127 | 16,900.47 | Sept. 16, 2025: 3 @ 133.07 |
| Dec. 5, 2025 | issue | SO-251205-645 | MAIN | 19 | 133.07 | -2,528.42 | 130 | 17,299.70 | Sept. 16, 2025: 19 @ 133.07 |
| Dec. 3, 2025 | issue | SO-251203-180 | MAIN | 24 | 133.07 | -3,193.79 | 149 | 19,828.12 | Sept. 16, 2025: 24 @ 133.07 |
| Nov. 30, 2025 | issue | SO-251130-759 | MAIN | 44 | 133.07 | -5,855.28 | 173 | 23,021.91 | Sept. 16, 2025: 44 @ 133.07 |
| Nov. 14, 2025 | issue | SO-251114-104 | MAIN | 125 | 133.07 | -16,634.32 | 217 | 28,877.19 | Sept. 16, 2025: 125 @ 133.07 |
| Nov. 5, 2025 | issue | SO-251105-687 | MAIN | 9 | 133.07 | -1,197.67 | 342 | 45,511.51 | Sept. 16, 2025: 9 @ 133.07 |
| Oct. 29, 2025 | issue | SO-251029-663 | MAIN | 10 | 133.07 | -1,330.75 | 351 | 46,709.18 | Sept. 16, 2025: 10 @ 133.07 |
| Oct. 14, 2025 | issue | SO-251014-501 | MAIN | 106 | 133.07 | -14,105.91 | 361 | 48,039.93 | Sept. 16, 2025: 106 @ 133.07 |
| Oct. 12, 2025 | return | RMA | MAIN | 26 | 133.07 | 3,459.94 | 467 | 62,145.84 | |
| Oct. 11, 2025 | issue | SO-251011-618 | MAIN | 71 | 133.07 | -9,448.30 | 441 | 58,685.90 | Sept. 16, 2025: 71 @ 133.07 |
| Oct. 9, 2025 | issue | SO-251009-169 | MAIN | 53 | 133.07 | -7,052.95 | 512 | 68,134.20 | Sept. 16, 2025: 53 @ 133.07 |
| Oct. 5, 2025 | issue | SO-251005-182 | MAIN | 7 | 133.07 | -931.52 | 565 | 75,187.15 | Sept. 16, 2025: 7 @ 133.07 |
| Sept. 24, 2025 | return | RMA | MAIN | 9 | 133.07 | 1,197.67 | 572 | 76,118.67 | |
| Sept. 22, 2025 | issue | SO-250922-413 | MAIN | 76 | 133.07 | -10,113.67 | 563 | 74,921.00 | Sept. 16, 2025: 76 @ 133.07 |