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, latest 60 shown - show all
| 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 |