Items / LED-0028
LED Bulb 9W Elite LED-0028 · Lighting · BrightLine Lighting
On hand (EA)393MAIN 393
Value (FIFO)12,123.22avg 30.85
ClassAX / FCV 0.42
Turnover5.3xlast issue 0 days ago
Days of cover72lead 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 | 167.08 / 30.4375 | 5.489 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 70.36 / 5.517 | 12.754 |
| 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 * 12.754^2 + 5.489^2 * 2.2^2) | 84.6 |
| Reorder point | d * LT + safety stock | 5.489 * 9.6 + 84.6 | 137.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 137.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2004/yr, S = 45.00, h = 20%, price = 31.85 | 168.3 |
| Inventory position | on hand + on order | 393 + 0 | 393 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 31.85 | 168 | 64,887 | yes (chosen if cheapest) |
| 1,380 | 30.58 | 1,380 | 65,548 | yes |
| 2,760 | 29.30 | 2,760 | 66,830 | yes |
MOQ 690, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 3, 2026 | 393 / 690 | 30.85 | 12,123.22 |
Movement ledger 106 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-685 | MAIN | 33 | 30.85 | -1,017.98 | 393 | 12,123.22 | Sept. 3, 2026: 33 @ 30.85 |
| Oct. 14, 2026 | issue | SO-261014-761 | MAIN | 20 | 30.85 | -616.96 | 426 | 13,141.21 | Sept. 3, 2026: 20 @ 30.85 |
| Oct. 12, 2026 | issue | SO-261012-992 | MAIN | 49 | 30.85 | -1,511.55 | 446 | 13,758.16 | Sept. 3, 2026: 49 @ 30.85 |
| Oct. 5, 2026 | issue | SO-261005-854 | MAIN | 44 | 30.85 | -1,357.31 | 495 | 15,269.71 | Sept. 3, 2026: 44 @ 30.85 |
| Oct. 3, 2026 | issue | SO-261003-767 | MAIN | 42 | 30.85 | -1,295.61 | 539 | 16,627.02 | Sept. 3, 2026: 42 @ 30.85 |
| Sept. 21, 2026 | issue | SO-260921-559 | MAIN | 16 | 30.85 | -493.57 | 581 | 17,922.63 | Sept. 3, 2026: 16 @ 30.85 |
| Sept. 19, 2026 | issue | SO-260919-722 | MAIN | 76 | 30.85 | -2,344.44 | 597 | 18,416.20 | Sept. 3, 2026: 76 @ 30.85 |
| Sept. 19, 2026 | issue | SO-260919-722 | EAST | 19 | 30.89 | -587.00 | 673 | 20,760.64 | March 14, 2026: 2 @ 31.29; Sept. 3, 2026: 17 @ 30.85 |
| Sept. 18, 2026 | issue | SO-260918-988 | EAST | 2 | 31.29 | -62.59 | 692 | 21,347.64 | March 14, 2026: 2 @ 31.29 |
| Sept. 13, 2026 | issue | SO-260913-436 | MAIN | 3 | 31.29 | -93.88 | 694 | 21,410.22 | March 14, 2026: 3 @ 31.29 |
| Sept. 7, 2026 | issue | SO-260907-220 | MAIN | 20 | 31.29 | -625.85 | 697 | 21,504.10 | March 14, 2026: 20 @ 31.29 |
| Sept. 3, 2026 | receipt | PO-001772 | MAIN | 690 | 30.85 | 21,285.05 | 717 | 22,129.95 | |
| Aug. 26, 2026 | issue | SO-260826-697 | EAST | 2 | 31.29 | -62.59 | 27 | 844.90 | March 14, 2026: 2 @ 31.29 |
| Aug. 22, 2026 | issue | SO-260822-292 | MAIN | 71 | 31.29 | -2,221.77 | 29 | 907.49 | March 14, 2026: 71 @ 31.29 |
| Aug. 21, 2026 | issue | SO-260821-238 | MAIN | 67 | 31.29 | -2,096.60 | 100 | 3,129.26 | March 14, 2026: 67 @ 31.29 |
| Aug. 5, 2026 | issue | SO-260805-849 | MAIN | 7 | 31.29 | -219.05 | 167 | 5,225.86 | March 14, 2026: 7 @ 31.29 |
| July 27, 2026 | issue | SO-260727-649 | MAIN | 1 | 31.29 | -31.29 | 174 | 5,444.91 | March 14, 2026: 1 @ 31.29 |
| July 22, 2026 | issue | SO-260722-266 | MAIN | 97 | 31.29 | -3,035.38 | 175 | 5,476.20 | March 14, 2026: 97 @ 31.29 |
| July 9, 2026 | issue | SO-260709-924 | EAST | 30 | 31.29 | -938.78 | 272 | 8,511.59 | March 14, 2026: 30 @ 31.29 |
| June 25, 2026 | issue | SO-260625-320 | MAIN | 8 | 31.29 | -250.34 | 302 | 9,450.37 | March 14, 2026: 8 @ 31.29 |
| June 14, 2026 | issue | SO-260614-845 | MAIN | 63 | 31.29 | -1,971.43 | 310 | 9,700.71 | March 14, 2026: 63 @ 31.29 |
| June 6, 2026 | issue | SO-260606-464 | EAST | 40 | 31.29 | -1,251.70 | 373 | 11,672.14 | March 14, 2026: 40 @ 31.29 |
| May 29, 2026 | issue | SO-260529-441 | EAST | 92 | 31.29 | -2,878.92 | 413 | 12,923.84 | March 14, 2026: 92 @ 31.29 |
| May 23, 2026 | issue | SO-260523-531 | MAIN | 31 | 31.29 | -970.07 | 505 | 15,802.76 | March 14, 2026: 31 @ 31.29 |
| April 19, 2026 | issue | SO-260419-575 | MAIN | 19 | 31.29 | -594.56 | 536 | 16,772.83 | March 14, 2026: 19 @ 31.29 |
| April 18, 2026 | issue | SO-260418-133 | MAIN | 42 | 31.29 | -1,314.29 | 555 | 17,367.39 | March 14, 2026: 42 @ 31.29 |
| April 13, 2026 | issue | SO-260413-449 | MAIN | 77 | 31.29 | -2,409.53 | 597 | 18,681.68 | March 14, 2026: 77 @ 31.29 |
| April 1, 2026 | issue | SO-260401-772 | EAST | 1 | 31.29 | -31.29 | 674 | 21,091.21 | March 14, 2026: 1 @ 31.29 |
| March 15, 2026 | issue | SO-260315-101 | MAIN | 33 | 30.97 | -1,021.96 | 675 | 21,122.50 | Nov. 30, 2025: 18 @ 30.70; March 14, 2026: 15 @ 31.29 |
| March 14, 2026 | transfer | TRF | MAIN → EAST | 168 | warehouse transfer, no cost effect | ||||
| March 14, 2026 | receipt | PO-001316 | MAIN | 690 | 31.29 | 21,591.89 | 708 | 22,144.47 | |
| March 10, 2026 | issue | SO-260310-774 | EAST | 68 | 30.70 | -2,087.50 | 18 | 552.57 | Nov. 30, 2025: 68 @ 30.70 |
| March 5, 2026 | issue | SO-260305-996 | EAST | 20 | 30.70 | -613.97 | 86 | 2,640.08 | Nov. 30, 2025: 20 @ 30.70 |
| Feb. 26, 2026 | issue | SO-260226-925 | EAST | 101 | 30.70 | -3,100.56 | 106 | 3,254.05 | Nov. 30, 2025: 101 @ 30.70 |
| Feb. 8, 2026 | issue | SO-260208-536 | EAST | 5 | 30.70 | -153.49 | 207 | 6,354.61 | Nov. 30, 2025: 5 @ 30.70 |
| Feb. 8, 2026 | issue | SO-260208-536 | MAIN | 85 | 30.70 | -2,609.38 | 212 | 6,508.10 | Nov. 30, 2025: 85 @ 30.70 |
| Jan. 7, 2026 | issue | SO-260107-867 | MAIN | 88 | 30.70 | -2,701.48 | 297 | 9,117.48 | Nov. 30, 2025: 88 @ 30.70 |
| Jan. 1, 2026 | issue | SO-260101-426 | MAIN | 34 | 30.70 | -1,043.75 | 385 | 11,818.96 | Nov. 30, 2025: 34 @ 30.70 |
| Dec. 20, 2025 | issue | SO-251220-125 | MAIN | 42 | 30.70 | -1,289.34 | 419 | 12,862.71 | Nov. 30, 2025: 42 @ 30.70 |
| Dec. 15, 2025 | issue | SO-251215-549 | MAIN | 235 | 30.70 | -7,215.01 | 461 | 14,152.05 | Sept. 4, 2025: 6 @ 30.84; Nov. 30, 2025: 229 @ 30.70 |
| Dec. 6, 2025 | issue | SO-251206-122 | MAIN | 10 | 30.84 | -308.38 | 696 | 21,367.06 | Sept. 4, 2025: 10 @ 30.84 |
| Dec. 4, 2025 | issue | SO-251204-342 | MAIN | 60 | 30.84 | -1,850.30 | 706 | 21,675.45 | Sept. 4, 2025: 60 @ 30.84 |
| Nov. 30, 2025 | transfer | TRF | MAIN → EAST | 212 | warehouse transfer, no cost effect | ||||
| Nov. 30, 2025 | receipt | PO-001026 | MAIN | 690 | 30.70 | 21,182.03 | 766 | 23,525.75 | |
| Nov. 26, 2025 | issue | SO-251126-214 | MAIN | 5 | 30.84 | -154.19 | 76 | 2,343.72 | Sept. 4, 2025: 5 @ 30.84 |
| Nov. 18, 2025 | issue | SO-251118-754 | MAIN | 67 | 30.84 | -2,066.17 | 81 | 2,497.91 | Sept. 4, 2025: 67 @ 30.84 |
| Nov. 7, 2025 | issue | SO-251107-806 | MAIN | 27 | 30.84 | -832.64 | 148 | 4,564.08 | Sept. 4, 2025: 27 @ 30.84 |
| Nov. 3, 2025 | issue | SO-251103-523 | MAIN | 164 | 30.84 | -5,057.50 | 175 | 5,396.72 | Sept. 4, 2025: 164 @ 30.84 |
| Nov. 2, 2025 | issue | SO-251102-589 | MAIN | 20 | 30.84 | -616.77 | 339 | 10,454.22 | Sept. 4, 2025: 20 @ 30.84 |
| Oct. 23, 2025 | issue | SO-251023-892 | MAIN | 35 | 30.84 | -1,079.34 | 359 | 11,070.99 | Sept. 4, 2025: 35 @ 30.84 |
| Oct. 5, 2025 | issue | SO-251005-991 | MAIN | 113 | 30.84 | -3,484.74 | 394 | 12,150.33 | Sept. 4, 2025: 113 @ 30.84 |
| Oct. 1, 2025 | issue | SO-251001-362 | MAIN | 9 | 30.84 | -277.55 | 507 | 15,635.07 | Sept. 4, 2025: 9 @ 30.84 |
| Sept. 21, 2025 | issue | SO-250921-666 | MAIN | 10 | 30.84 | -308.38 | 516 | 15,912.61 | Sept. 4, 2025: 10 @ 30.84 |
| Sept. 20, 2025 | issue | SO-250920-240 | MAIN | 6 | 30.84 | -185.03 | 526 | 16,221.00 | Sept. 4, 2025: 6 @ 30.84 |
| Sept. 9, 2025 | issue | SO-250909-594 | MAIN | 118 | 30.84 | -3,638.93 | 532 | 16,406.03 | Sept. 4, 2025: 118 @ 30.84 |
| Sept. 8, 2025 | issue | SO-250908-592 | MAIN | 39 | 30.84 | -1,202.70 | 650 | 20,044.96 | Sept. 4, 2025: 39 @ 30.84 |
| Sept. 7, 2025 | issue | SO-250907-973 | MAIN | 68 | 30.68 | -2,086.10 | 689 | 21,247.66 | May 18, 2025: 48 @ 30.68; July 7, 2025: 19 @ 30.68; Sept. 4, 2025: 1 @ 30.84 |
| Sept. 4, 2025 | receipt | PO-000813 | MAIN | 690 | 30.84 | 21,278.50 | 757 | 23,333.75 | |
| Aug. 28, 2025 | issue | SO-250828-839 | MAIN | 52 | 30.68 | -1,595.13 | 67 | 2,055.26 | May 18, 2025: 52 @ 30.68 |
| Aug. 3, 2025 | issue | SO-250803-481 | MAIN | 199 | 30.68 | -6,104.42 | 119 | 3,650.38 | May 18, 2025: 199 @ 30.68 |