Items / LED-0001
LED Bulb 12W Prime LED-0001 · Lighting · BrightLine Lighting
On hand (EA)56MAIN 56
Value (FIFO)3,912.82avg 69.87
ClassAX / FCV 0.19
Turnover7.0xlast issue 2 days ago
Days of cover11lead time 10d
Reorder suggested: 700 units (position at or below reorder point: order EOQ), stockout risk medium.
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 | 153.00 / 30.4375 | 5.027 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 28.40 / 5.517 | 5.148 |
| 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 * 5.148^2 + 5.027^2 * 2.2^2) | 39.6 |
| Reorder point | d * LT + safety stock | 5.027 * 9.6 + 39.6 | 87.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 87.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1835/yr, S = 45.00, h = 20%, price = 73.00 | 106.3 |
| Inventory position | on hand + on order | 56 + 0 | 56 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 73.00 | 106 | 135,489 | yes (chosen if cheapest) |
| 1,400 | 70.08 | 1,400 | 138,449 | yes |
| 2,800 | 67.16 | 2,800 | 142,056 | yes |
MOQ 700, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| June 25, 2026 | 56 / 700 | 69.87 | 3,912.82 |
Movement ledger 113 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | issue | SO-261014-879 | MAIN | 4 | 69.87 | -279.49 | 56 | 3,912.82 | June 25, 2026: 4 @ 69.87 |
| Oct. 11, 2026 | issue | SO-261011-700 | MAIN | 10 | 69.87 | -698.72 | 60 | 4,192.30 | June 25, 2026: 10 @ 69.87 |
| Oct. 9, 2026 | issue | SO-261009-107 | MAIN | 46 | 69.87 | -3,214.10 | 70 | 4,891.02 | June 25, 2026: 46 @ 69.87 |
| Oct. 7, 2026 | issue | SO-261007-760 | MAIN | 62 | 69.87 | -4,332.05 | 116 | 8,105.12 | June 25, 2026: 62 @ 69.87 |
| Oct. 7, 2026 | issue | SO-261007-760 | EAST | 53 | 69.87 | -3,703.20 | 178 | 12,437.16 | June 25, 2026: 53 @ 69.87 |
| Sept. 27, 2026 | issue | SO-260927-460 | MAIN | 29 | 69.87 | -2,026.28 | 231 | 16,140.36 | June 25, 2026: 29 @ 69.87 |
| Sept. 20, 2026 | issue | SO-260920-879 | EAST | 13 | 69.87 | -908.33 | 260 | 18,166.64 | June 25, 2026: 13 @ 69.87 |
| Sept. 18, 2026 | issue | SO-260918-914 | MAIN | 47 | 69.87 | -3,283.97 | 273 | 19,074.97 | June 25, 2026: 47 @ 69.87 |
| Sept. 17, 2026 | adjustment | Cycle count | MAIN | -1 | 69.87 | -69.87 | 320 | 22,358.94 | June 25, 2026: 1 @ 69.87 |
| Sept. 12, 2026 | issue | SO-260912-896 | MAIN | 47 | 69.87 | -3,283.97 | 321 | 22,428.82 | June 25, 2026: 47 @ 69.87 |
| Aug. 30, 2026 | issue | SO-260830-531 | EAST | 55 | 69.87 | -3,842.94 | 368 | 25,712.79 | June 25, 2026: 55 @ 69.87 |
| Aug. 29, 2026 | issue | SO-260829-834 | MAIN | 5 | 69.87 | -349.36 | 423 | 29,555.73 | June 25, 2026: 5 @ 69.87 |
| Aug. 21, 2026 | issue | SO-260821-596 | MAIN | 32 | 69.87 | -2,235.89 | 428 | 29,905.09 | June 25, 2026: 32 @ 69.87 |
| Aug. 9, 2026 | issue | SO-260809-596 | EAST | 74 | 69.87 | -5,170.51 | 460 | 32,140.98 | June 25, 2026: 74 @ 69.87 |
| July 31, 2026 | issue | SO-260731-795 | MAIN | 2 | 69.87 | -139.74 | 534 | 37,311.49 | June 25, 2026: 2 @ 69.87 |
| July 27, 2026 | issue | SO-260727-447 | MAIN | 75 | 69.87 | -5,240.38 | 536 | 37,451.23 | June 25, 2026: 75 @ 69.87 |
| July 18, 2026 | issue | SO-260718-729 | MAIN | 9 | 69.87 | -628.85 | 611 | 42,691.61 | June 25, 2026: 9 @ 69.87 |
| July 15, 2026 | issue | SO-260715-704 | MAIN | 6 | 69.87 | -419.23 | 620 | 43,320.45 | June 25, 2026: 6 @ 69.87 |
| July 6, 2026 | issue | SO-260706-727 | MAIN | 22 | 69.87 | -1,537.18 | 626 | 43,739.68 | June 25, 2026: 22 @ 69.87 |
| July 3, 2026 | issue | SO-260703-408 | MAIN | 35 | 69.87 | -2,445.51 | 648 | 45,276.86 | June 25, 2026: 35 @ 69.87 |
| June 29, 2026 | issue | SO-260629-637 | MAIN | 10 | 69.87 | -698.72 | 683 | 47,722.37 | June 25, 2026: 10 @ 69.87 |
| June 28, 2026 | issue | SO-260628-155 | MAIN | 7 | 69.87 | -489.10 | 693 | 48,421.09 | June 25, 2026: 7 @ 69.87 |
| June 25, 2026 | transfer | TRF | MAIN → EAST | 195 | warehouse transfer, no cost effect | ||||
| June 25, 2026 | receipt | PO-001603 | MAIN | 700 | 69.87 | 48,910.19 | 700 | 48,910.19 | |
| June 21, 2026 | issue | SO-260621-827 | MAIN | 34 | 71.31 | -2,424.41 | 0 | 0.00 | Jan. 13, 2026: 34 @ 71.31 |
| June 19, 2026 | issue | SO-260619-270 | MAIN | 31 | 71.31 | -2,210.50 | 34 | 2,424.41 | Jan. 13, 2026: 31 @ 71.31 |
| June 10, 2026 | issue | SO-260610-906 | MAIN | 38 | 71.31 | -2,709.64 | 65 | 4,634.91 | Jan. 10, 2026: 24 @ 71.31; Jan. 13, 2026: 14 @ 71.31 |
| May 29, 2026 | issue | SO-260529-775 | MAIN | 54 | 71.31 | -3,850.54 | 103 | 7,344.55 | Jan. 10, 2026: 54 @ 71.31 |
| May 19, 2026 | issue | SO-260519-652 | MAIN | 82 | 71.31 | -5,847.12 | 157 | 11,195.09 | Jan. 10, 2026: 82 @ 71.31 |
| May 17, 2026 | issue | SO-260517-743 | MAIN | 1 | 71.31 | -71.31 | 239 | 17,042.21 | Jan. 10, 2026: 1 @ 71.31 |
| May 10, 2026 | issue | SO-260510-692 | MAIN | 12 | 71.31 | -855.68 | 240 | 17,113.51 | Jan. 10, 2026: 12 @ 71.31 |
| April 28, 2026 | issue | SO-260428-920 | MAIN | 23 | 71.31 | -1,640.04 | 252 | 17,969.19 | Jan. 10, 2026: 23 @ 71.31 |
| April 16, 2026 | issue | SO-260416-236 | MAIN | 14 | 71.31 | -998.29 | 275 | 19,609.23 | Jan. 10, 2026: 14 @ 71.31 |
| April 6, 2026 | issue | SO-260406-401 | MAIN | 83 | 71.31 | -5,918.42 | 289 | 20,607.52 | Jan. 10, 2026: 83 @ 71.31 |
| April 1, 2026 | issue | SO-260401-146 | MAIN | 39 | 71.31 | -2,780.95 | 372 | 26,525.94 | Jan. 10, 2026: 39 @ 71.31 |
| March 26, 2026 | issue | SO-260326-690 | MAIN | 14 | 71.31 | -998.29 | 411 | 29,306.89 | Jan. 10, 2026: 14 @ 71.31 |
| March 24, 2026 | issue | SO-260324-422 | MAIN | 71 | 71.31 | -5,062.75 | 425 | 30,305.18 | Jan. 10, 2026: 71 @ 71.31 |
| March 24, 2026 | issue | SO-260324-422 | EAST | 102 | 71.31 | -7,273.24 | 496 | 35,367.92 | Jan. 10, 2026: 102 @ 71.31 |
| Feb. 26, 2026 | issue | SO-260226-443 | MAIN | 113 | 71.31 | -8,057.61 | 598 | 42,641.17 | Jan. 10, 2026: 113 @ 71.31 |
| Feb. 12, 2026 | issue | SO-260212-101 | EAST | 31 | 71.31 | -2,210.50 | 711 | 50,698.78 | Jan. 10, 2026: 31 @ 71.31 |
| Feb. 8, 2026 | issue | SO-260208-710 | EAST | 27 | 71.31 | -1,925.27 | 742 | 52,909.27 | Jan. 10, 2026: 27 @ 71.31 |
| Jan. 13, 2026 | return | RMA | MAIN | 79 | 71.31 | 5,633.20 | 769 | 54,834.54 | |
| Jan. 12, 2026 | issue | SO-260112-603 | MAIN | 10 | 71.31 | -713.06 | 690 | 49,201.35 | Jan. 10, 2026: 10 @ 71.31 |
| Jan. 10, 2026 | transfer | TRF | MAIN → EAST | 160 | warehouse transfer, no cost effect | ||||
| Jan. 10, 2026 | receipt | PO-001133 | MAIN | 700 | 71.31 | 49,914.41 | 700 | 49,914.41 | |
| Jan. 1, 2026 | issue | SO-260101-868 | MAIN | 158 | 69.60 | -10,996.52 | 0 | 0.00 | Sept. 14, 2025: 158 @ 69.60 |
| Dec. 17, 2025 | issue | SO-251217-679 | MAIN | 88 | 69.60 | -6,124.64 | 158 | 10,996.52 | Sept. 14, 2025: 88 @ 69.60 |
| Dec. 7, 2025 | issue | SO-251207-110 | MAIN | 21 | 69.60 | -1,461.56 | 246 | 17,121.16 | Sept. 14, 2025: 21 @ 69.60 |
| Dec. 4, 2025 | issue | SO-251204-736 | MAIN | 56 | 69.60 | -3,897.50 | 267 | 18,582.72 | Sept. 14, 2025: 56 @ 69.60 |
| Dec. 3, 2025 | issue | SO-251203-935 | MAIN | 36 | 69.60 | -2,505.54 | 323 | 22,480.22 | Sept. 14, 2025: 36 @ 69.60 |
| Nov. 26, 2025 | issue | SO-251126-476 | MAIN | 68 | 69.60 | -4,732.68 | 359 | 24,985.75 | Sept. 14, 2025: 68 @ 69.60 |
| Nov. 13, 2025 | issue | SO-251113-488 | MAIN | 37 | 69.60 | -2,575.13 | 427 | 29,718.43 | Sept. 14, 2025: 37 @ 69.60 |
| Nov. 2, 2025 | issue | SO-251102-943 | MAIN | 40 | 69.60 | -2,783.93 | 464 | 32,293.56 | Sept. 14, 2025: 40 @ 69.60 |
| Oct. 13, 2025 | issue | SO-251013-601 | MAIN | 39 | 69.60 | -2,714.33 | 504 | 35,077.49 | Sept. 14, 2025: 39 @ 69.60 |
| Oct. 4, 2025 | issue | SO-251004-483 | MAIN | 20 | 69.60 | -1,391.96 | 543 | 37,791.82 | Sept. 14, 2025: 20 @ 69.60 |
| Oct. 2, 2025 | issue | SO-251002-622 | MAIN | 105 | 69.60 | -7,307.81 | 563 | 39,183.79 | Sept. 14, 2025: 105 @ 69.60 |
| Sept. 28, 2025 | issue | SO-250928-952 | MAIN | 44 | 69.43 | -3,054.98 | 668 | 46,491.60 | May 26, 2025: 12 @ 68.99; Sept. 14, 2025: 32 @ 69.60 |
| Sept. 23, 2025 | issue | SO-250923-696 | MAIN | 13 | 68.99 | -896.82 | 712 | 49,546.58 | May 26, 2025: 13 @ 68.99 |
| Sept. 14, 2025 | receipt | PO-000842 | MAIN | 700 | 69.60 | 48,718.74 | 725 | 50,443.40 | |
| Sept. 11, 2025 | issue | SO-250911-831 | MAIN | 59 | 68.99 | -4,070.19 | 25 | 1,724.66 | April 5, 2025: 56 @ 68.99; May 26, 2025: 3 @ 68.99 |
| Sept. 7, 2025 | issue | SO-250907-795 | MAIN | 28 | 68.99 | -1,931.62 | 84 | 5,794.85 | April 5, 2025: 28 @ 68.99 |
| Sept. 3, 2025 | issue | SO-250903-294 | MAIN | 35 | 68.99 | -2,414.52 | 112 | 7,726.47 | April 5, 2025: 35 @ 68.99 |
| Sept. 1, 2025 | issue | SO-250901-138 | MAIN | 5 | 68.99 | -344.93 | 147 | 10,140.99 | April 5, 2025: 5 @ 68.99 |
| Aug. 22, 2025 | issue | SO-250822-407 | MAIN | 24 | 68.99 | -1,655.67 | 152 | 10,485.92 | April 5, 2025: 24 @ 68.99 |
| Aug. 2, 2025 | issue | SO-250802-845 | MAIN | 136 | 68.99 | -9,382.14 | 176 | 12,141.59 | April 5, 2025: 136 @ 68.99 |
| July 31, 2025 | issue | SO-250731-306 | MAIN | 13 | 68.99 | -896.82 | 312 | 21,523.73 | April 5, 2025: 13 @ 68.99 |
| July 18, 2025 | issue | SO-250718-320 | MAIN | 17 | 68.99 | -1,172.77 | 325 | 22,420.55 | April 5, 2025: 17 @ 68.99 |
| July 12, 2025 | issue | SO-250712-922 | MAIN | 15 | 68.99 | -1,034.79 | 342 | 23,593.31 | April 5, 2025: 15 @ 68.99 |
| July 11, 2025 | issue | SO-250711-344 | MAIN | 79 | 68.99 | -5,449.92 | 357 | 24,628.11 | April 5, 2025: 79 @ 68.99 |
| June 29, 2025 | issue | SO-250629-356 | MAIN | 15 | 68.99 | -1,034.79 | 436 | 30,078.03 | April 5, 2025: 15 @ 68.99 |
| June 22, 2025 | issue | SO-250622-552 | MAIN | 4 | 68.99 | -275.95 | 451 | 31,112.82 | April 5, 2025: 4 @ 68.99 |
| June 18, 2025 | issue | SO-250618-421 | MAIN | 11 | 68.99 | -758.85 | 455 | 31,388.77 | April 5, 2025: 11 @ 68.99 |
| June 15, 2025 | issue | SO-250615-576 | MAIN | 25 | 68.99 | -1,724.66 | 466 | 32,147.62 | April 5, 2025: 25 @ 68.99 |
| June 13, 2025 | issue | SO-250613-333 | MAIN | 66 | 68.99 | -4,553.10 | 491 | 33,872.27 | April 5, 2025: 66 @ 68.99 |
| May 26, 2025 | return | RMA | MAIN | 28 | 68.99 | 1,931.62 | 557 | 38,425.37 | |
| May 20, 2025 | issue | SO-250520-490 | MAIN | 62 | 68.99 | -4,277.15 | 529 | 36,493.75 | April 5, 2025: 62 @ 68.99 |
| May 13, 2025 | issue | SO-250513-363 | MAIN | 57 | 68.99 | -3,932.22 | 591 | 40,770.90 | April 5, 2025: 57 @ 68.99 |
| May 6, 2025 | issue | SO-250506-685 | MAIN | 43 | 68.99 | -2,966.41 | 648 | 44,703.12 | April 5, 2025: 43 @ 68.99 |
| April 10, 2025 | issue | SO-250410-368 | MAIN | 74 | 67.44 | -4,990.68 | 691 | 47,669.53 | Dec. 29, 2024: 65 @ 67.23; April 5, 2025: 9 @ 68.99 |
| April 9, 2025 | issue | SO-250409-949 | MAIN | 19 | 67.23 | -1,277.33 | 765 | 52,660.21 | Dec. 29, 2024: 19 @ 67.23 |
| April 5, 2025 | receipt | PO-000413 | MAIN | 700 | 68.99 | 48,290.41 | 784 | 53,937.54 | |
| March 25, 2025 | issue | SO-250325-237 | MAIN | 18 | 67.23 | -1,210.10 | 84 | 5,647.13 | Dec. 29, 2024: 18 @ 67.23 |
| March 21, 2025 | issue | SO-250321-108 | MAIN | 48 | 67.23 | -3,226.93 | 102 | 6,857.23 | Dec. 29, 2024: 48 @ 67.23 |
| March 13, 2025 | issue | SO-250313-579 | MAIN | 16 | 67.23 | -1,075.64 | 150 | 10,084.16 | Dec. 29, 2024: 16 @ 67.23 |
| March 9, 2025 | issue | SO-250309-320 | MAIN | 69 | 67.23 | -4,638.71 | 166 | 11,159.80 | Dec. 29, 2024: 69 @ 67.23 |
| March 5, 2025 | issue | SO-250305-919 | MAIN | 8 | 67.23 | -537.82 | 235 | 15,798.51 | Dec. 29, 2024: 8 @ 67.23 |
| March 4, 2025 | issue | SO-250304-105 | MAIN | 9 | 67.23 | -605.05 | 243 | 16,336.33 | Dec. 29, 2024: 9 @ 67.23 |
| Feb. 24, 2025 | issue | SO-250224-746 | MAIN | 33 | 67.23 | -2,218.51 | 252 | 16,941.38 | Dec. 29, 2024: 33 @ 67.23 |
| Feb. 20, 2025 | issue | SO-250220-847 | MAIN | 22 | 67.23 | -1,479.01 | 285 | 19,159.89 | Dec. 29, 2024: 22 @ 67.23 |
| Feb. 17, 2025 | issue | SO-250217-907 | MAIN | 41 | 67.23 | -2,756.34 | 307 | 20,638.90 | Dec. 29, 2024: 41 @ 67.23 |
| Feb. 9, 2025 | issue | SO-250209-705 | MAIN | 38 | 67.23 | -2,554.65 | 348 | 23,395.24 | Dec. 29, 2024: 38 @ 67.23 |
| Feb. 2, 2025 | issue | SO-250202-433 | MAIN | 72 | 67.23 | -4,840.39 | 386 | 25,949.89 | Dec. 29, 2024: 72 @ 67.23 |
| Jan. 14, 2025 | issue | SO-250114-331 | MAIN | 77 | 67.23 | -5,176.53 | 458 | 30,790.29 | Dec. 29, 2024: 77 @ 67.23 |
| Jan. 9, 2025 | issue | SO-250109-195 | MAIN | 221 | 67.77 | -14,976.17 | 535 | 35,966.82 | Oct. 1, 2024: 54 @ 69.35; Nov. 1, 2024: 2 @ 69.35; Dec. 29, 2024: 165 @ 67.23 |
| Dec. 29, 2024 | receipt | PO-000144 | MAIN | 700 | 67.23 | 47,059.39 | 756 | 50,942.99 | |
| Dec. 28, 2024 | issue | SO-241228-469 | MAIN | 1 | 69.35 | -69.35 | 56 | 3,883.60 | Oct. 1, 2024: 1 @ 69.35 |
| Dec. 18, 2024 | issue | SO-241218-758 | MAIN | 1 | 69.35 | -69.35 | 57 | 3,952.95 | Oct. 1, 2024: 1 @ 69.35 |
| Dec. 17, 2024 | issue | SO-241217-767 | MAIN | 91 | 69.35 | -6,310.85 | 58 | 4,022.30 | Oct. 1, 2024: 91 @ 69.35 |
| Dec. 15, 2024 | issue | SO-241215-471 | MAIN | 86 | 69.35 | -5,964.10 | 149 | 10,333.15 | Oct. 1, 2024: 86 @ 69.35 |
| Dec. 1, 2024 | issue | SO-241201-335 | MAIN | 25 | 69.35 | -1,733.75 | 235 | 16,297.25 | Oct. 1, 2024: 25 @ 69.35 |
| Nov. 20, 2024 | issue | SO-241120-533 | MAIN | 10 | 69.35 | -693.50 | 260 | 18,031.00 | Oct. 1, 2024: 10 @ 69.35 |
| Nov. 18, 2024 | issue | SO-241118-720 | MAIN | 124 | 69.35 | -8,599.40 | 270 | 18,724.50 | Oct. 1, 2024: 124 @ 69.35 |
| Nov. 16, 2024 | issue | SO-241116-591 | MAIN | 2 | 69.35 | -138.70 | 394 | 27,323.90 | Oct. 1, 2024: 2 @ 69.35 |
| Nov. 11, 2024 | issue | SO-241111-808 | MAIN | 23 | 69.35 | -1,595.05 | 396 | 27,462.60 | Oct. 1, 2024: 23 @ 69.35 |
| Nov. 2, 2024 | issue | SO-241102-823 | MAIN | 12 | 69.35 | -832.20 | 419 | 29,057.65 | Oct. 1, 2024: 12 @ 69.35 |
| Nov. 1, 2024 | return | RMA | MAIN | 2 | 69.35 | 138.70 | 431 | 29,889.85 | |
| Nov. 1, 2024 | issue | SO-241101-673 | MAIN | 29 | 69.35 | -2,011.15 | 429 | 29,751.15 | Oct. 1, 2024: 29 @ 69.35 |
| Oct. 31, 2024 | issue | SO-241031-539 | MAIN | 8 | 69.35 | -554.80 | 458 | 31,762.30 | Oct. 1, 2024: 8 @ 69.35 |
| Oct. 25, 2024 | issue | SO-241025-359 | MAIN | 199 | 69.35 | -13,800.65 | 466 | 32,317.10 | Oct. 1, 2024: 199 @ 69.35 |
| Oct. 17, 2024 | issue | SO-241017-916 | MAIN | 24 | 69.35 | -1,664.40 | 665 | 46,117.75 | Oct. 1, 2024: 24 @ 69.35 |
| Oct. 13, 2024 | issue | SO-241013-305 | MAIN | 4 | 69.35 | -277.40 | 689 | 47,782.15 | Oct. 1, 2024: 4 @ 69.35 |
| Oct. 1, 2024 | issue | SO-241001-252 | MAIN | 7 | 69.35 | -485.45 | 693 | 48,059.55 | Oct. 1, 2024: 7 @ 69.35 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 700 | 69.35 | 48,545.00 | 700 | 48,545.00 | |