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
| 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 |
| July 28, 2025 | issue | SO-250728-245 | MAIN | 51 | 30.68 | -1,564.45 | 318 | 9,754.81 | May 18, 2025: 51 @ 30.68 |
| July 27, 2025 | issue | SO-250727-360 | MAIN | 16 | 30.68 | -490.81 | 369 | 11,319.26 | May 18, 2025: 16 @ 30.68 |
| July 19, 2025 | issue | SO-250719-452 | MAIN | 11 | 30.68 | -337.43 | 385 | 11,810.07 | May 18, 2025: 11 @ 30.68 |
| July 17, 2025 | issue | SO-250717-611 | MAIN | 2 | 30.68 | -61.35 | 396 | 12,147.50 | May 18, 2025: 2 @ 30.68 |
| July 7, 2025 | return | RMA | MAIN | 19 | 30.68 | 582.83 | 398 | 12,208.85 | |
| July 6, 2025 | issue | SO-250706-104 | MAIN | 7 | 30.68 | -214.73 | 379 | 11,626.01 | May 18, 2025: 7 @ 30.68 |
| July 5, 2025 | issue | SO-250705-638 | MAIN | 35 | 30.68 | -1,073.64 | 386 | 11,840.74 | May 18, 2025: 35 @ 30.68 |
| July 1, 2025 | issue | SO-250701-383 | MAIN | 24 | 30.68 | -736.21 | 421 | 12,914.39 | May 18, 2025: 24 @ 30.68 |
| June 29, 2025 | issue | SO-250629-322 | MAIN | 39 | 30.68 | -1,196.34 | 445 | 13,650.60 | May 18, 2025: 39 @ 30.68 |
| June 24, 2025 | issue | SO-250624-427 | MAIN | 37 | 30.68 | -1,134.99 | 484 | 14,846.94 | May 18, 2025: 37 @ 30.68 |
| June 21, 2025 | issue | SO-250621-100 | MAIN | 51 | 30.68 | -1,564.45 | 521 | 15,981.94 | May 18, 2025: 51 @ 30.68 |
| June 18, 2025 | issue | SO-250618-995 | MAIN | 2 | 30.68 | -61.35 | 572 | 17,546.39 | May 18, 2025: 2 @ 30.68 |
| June 16, 2025 | issue | SO-250616-572 | MAIN | 17 | 30.68 | -521.48 | 574 | 17,607.74 | May 18, 2025: 17 @ 30.68 |
| June 6, 2025 | issue | SO-250606-449 | MAIN | 11 | 30.68 | -337.43 | 591 | 18,129.22 | May 18, 2025: 11 @ 30.68 |
| June 3, 2025 | issue | SO-250603-662 | MAIN | 10 | 30.68 | -306.76 | 602 | 18,466.65 | May 18, 2025: 10 @ 30.68 |
| May 31, 2025 | issue | SO-250531-303 | MAIN | 52 | 30.68 | -1,595.13 | 612 | 18,773.41 | May 18, 2025: 52 @ 30.68 |
| May 31, 2025 | issue | SO-250531-303 | EAST | 67 | 30.06 | -2,014.14 | 664 | 20,368.53 | Jan. 15, 2025: 41 @ 29.67; May 18, 2025: 26 @ 30.68 |
| May 29, 2025 | issue | SO-250529-712 | MAIN | 26 | 29.67 | -771.49 | 731 | 22,382.67 | Jan. 15, 2025: 26 @ 29.67 |
| May 18, 2025 | receipt | PO-000544 | MAIN | 690 | 30.68 | 21,166.10 | 757 | 23,154.16 | |
| May 10, 2025 | issue | SO-250510-223 | EAST | 7 | 29.67 | -207.71 | 67 | 1,988.06 | Jan. 15, 2025: 7 @ 29.67 |
| May 10, 2025 | issue | SO-250510-223 | MAIN | 26 | 29.67 | -771.49 | 74 | 2,195.77 | Jan. 15, 2025: 26 @ 29.67 |
| April 24, 2025 | issue | SO-250424-480 | MAIN | 26 | 29.67 | -771.49 | 100 | 2,967.26 | Jan. 15, 2025: 26 @ 29.67 |
| April 17, 2025 | issue | SO-250417-609 | MAIN | 58 | 29.67 | -1,721.01 | 126 | 3,738.75 | Jan. 15, 2025: 58 @ 29.67 |
| April 12, 2025 | issue | SO-250412-646 | EAST | 3 | 29.67 | -89.02 | 184 | 5,459.76 | Jan. 15, 2025: 3 @ 29.67 |
| April 4, 2025 | issue | SO-250404-850 | MAIN | 95 | 29.67 | -2,818.90 | 187 | 5,548.78 | Jan. 15, 2025: 95 @ 29.67 |
| March 30, 2025 | issue | SO-250330-237 | EAST | 49 | 29.67 | -1,453.96 | 282 | 8,367.67 | Jan. 15, 2025: 49 @ 29.67 |
| March 24, 2025 | issue | SO-250324-517 | MAIN | 127 | 29.67 | -3,768.42 | 331 | 9,821.63 | Jan. 15, 2025: 127 @ 29.67 |
| March 14, 2025 | issue | SO-250314-338 | MAIN | 61 | 29.67 | -1,810.03 | 458 | 13,590.05 | Jan. 15, 2025: 61 @ 29.67 |
| March 10, 2025 | issue | SO-250310-779 | MAIN | 3 | 29.67 | -89.02 | 519 | 15,400.08 | Jan. 15, 2025: 3 @ 29.67 |
| Feb. 15, 2025 | issue | SO-250215-625 | EAST | 13 | 29.67 | -385.74 | 522 | 15,489.10 | Jan. 15, 2025: 13 @ 29.67 |
| Feb. 8, 2025 | issue | SO-250208-157 | MAIN | 148 | 29.67 | -4,391.54 | 535 | 15,874.84 | Jan. 15, 2025: 148 @ 29.67 |
| Jan. 20, 2025 | issue | SO-250120-731 | MAIN | 7 | 29.67 | -207.71 | 683 | 20,266.39 | Jan. 15, 2025: 7 @ 29.67 |
| Jan. 15, 2025 | transfer | TRF | MAIN → EAST | 139 | warehouse transfer, no cost effect | ||||
| Jan. 15, 2025 | receipt | PO-000186 | MAIN | 690 | 29.67 | 20,474.09 | 690 | 20,474.09 | |
| Jan. 5, 2025 | issue | SO-250105-998 | MAIN | 9 | 30.26 | -272.32 | 0 | 0.00 | Oct. 1, 2024: 9 @ 30.26 |
| Jan. 1, 2025 | issue | SO-250101-967 | MAIN | 7 | 30.26 | -211.80 | 9 | 272.32 | Oct. 1, 2024: 7 @ 30.26 |
| Jan. 1, 2025 | issue | SO-250101-967 | EAST | 113 | 30.26 | -3,419.10 | 16 | 484.12 | Oct. 1, 2024: 113 @ 30.26 |
| Dec. 24, 2024 | issue | SO-241224-836 | MAIN | 52 | 30.26 | -1,573.39 | 129 | 3,903.22 | Oct. 1, 2024: 52 @ 30.26 |
| Dec. 23, 2024 | issue | SO-241223-195 | MAIN | 85 | 30.26 | -2,571.89 | 181 | 5,476.61 | Oct. 1, 2024: 85 @ 30.26 |
| Nov. 9, 2024 | issue | SO-241109-285 | EAST | 84 | 30.26 | -2,541.63 | 266 | 8,048.50 | Oct. 1, 2024: 84 @ 30.26 |
| Nov. 6, 2024 | issue | SO-241106-784 | MAIN | 143 | 30.26 | -4,326.82 | 350 | 10,590.12 | Oct. 1, 2024: 143 @ 30.26 |
| Oct. 24, 2024 | issue | SO-241024-731 | MAIN | 55 | 30.26 | -1,664.16 | 493 | 14,916.95 | Oct. 1, 2024: 55 @ 30.26 |
| Oct. 3, 2024 | issue | SO-241003-386 | MAIN | 101 | 30.26 | -3,056.01 | 548 | 16,581.11 | Oct. 1, 2024: 101 @ 30.26 |
| Oct. 1, 2024 | issue | SO-241001-654 | MAIN | 41 | 30.26 | -1,240.56 | 649 | 19,637.12 | Oct. 1, 2024: 41 @ 30.26 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 197 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 690 | 30.26 | 20,877.68 | 690 | 20,877.68 | |