Items / LED-0040
LED Bulb 9W Classic LED-0040 · Lighting · BrightLine Lighting
On hand (EA)704MAIN 704
Value (FIFO)64,850.65avg 92.12
ClassAX / FCV 0.31
Turnover4.8xlast issue 2 days ago
Days of cover89lead 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 | 240.25 / 30.4375 | 7.893 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 74.53 / 5.517 | 13.510 |
| 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 * 13.510^2 + 7.893^2 * 2.2^2) | 92.7 |
| Reorder point | d * LT + safety stock | 7.893 * 9.6 + 92.7 | 168.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 168.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2881/yr, S = 45.00, h = 20%, price = 94.69 | 117.0 |
| Inventory position | on hand + on order | 704 + 0 | 704 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 94.69 | 117 | 275,020 | yes (chosen if cheapest) |
| 2,100 | 90.90 | 2,100 | 281,043 | yes |
| 4,200 | 87.11 | 4,200 | 287,599 | yes |
MOQ 1,050, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 24, 2026 | 704 / 1,050 | 92.12 | 64,850.65 |
Movement ledger 118 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-780 | MAIN | 27 | 92.12 | -2,487.17 | 704 | 64,850.65 | Sept. 24, 2026: 27 @ 92.12 |
| Oct. 7, 2026 | issue | SO-261007-523 | MAIN | 117 | 92.12 | -10,777.74 | 731 | 67,337.82 | Sept. 24, 2026: 117 @ 92.12 |
| Oct. 5, 2026 | issue | SO-261005-731 | MAIN | 6 | 92.12 | -552.70 | 848 | 78,115.56 | Sept. 24, 2026: 6 @ 92.12 |
| Oct. 3, 2026 | issue | SO-261003-786 | MAIN | 196 | 92.12 | -18,055.01 | 854 | 78,668.26 | Sept. 24, 2026: 196 @ 92.12 |
| Sept. 24, 2026 | receipt | PO-001825 | MAIN | 1,050 | 92.12 | 96,723.27 | 1,050 | 96,723.27 | |
| Sept. 18, 2026 | issue | SO-260918-677 | MAIN | 134 | 91.91 | -12,316.58 | 0 | 0.00 | April 11, 2026: 134 @ 91.91 |
| Sept. 14, 2026 | issue | SO-260914-534 | MAIN | 59 | 91.91 | -5,422.97 | 134 | 12,316.58 | April 11, 2026: 59 @ 91.91 |
| Aug. 19, 2026 | issue | SO-260819-214 | MAIN | 65 | 91.91 | -5,974.46 | 193 | 17,739.56 | April 11, 2026: 65 @ 91.91 |
| Aug. 9, 2026 | issue | SO-260809-183 | MAIN | 103 | 91.91 | -9,467.22 | 258 | 23,714.02 | April 11, 2026: 103 @ 91.91 |
| Aug. 2, 2026 | issue | SO-260802-627 | MAIN | 29 | 91.91 | -2,665.53 | 361 | 33,181.24 | April 11, 2026: 29 @ 91.91 |
| July 26, 2026 | issue | SO-260726-366 | MAIN | 3 | 91.91 | -275.74 | 390 | 35,846.77 | April 11, 2026: 3 @ 91.91 |
| July 24, 2026 | issue | SO-260724-994 | MAIN | 47 | 91.91 | -4,320.00 | 393 | 36,122.52 | April 11, 2026: 47 @ 91.91 |
| July 8, 2026 | issue | SO-260708-915 | MAIN | 141 | 91.91 | -12,959.99 | 440 | 40,442.51 | April 11, 2026: 141 @ 91.91 |
| June 20, 2026 | issue | SO-260620-210 | MAIN | 153 | 91.91 | -14,062.96 | 581 | 53,402.50 | April 11, 2026: 153 @ 91.91 |
| June 8, 2026 | issue | SO-260608-122 | MAIN | 14 | 91.91 | -1,286.81 | 734 | 67,465.46 | April 11, 2026: 14 @ 91.91 |
| May 29, 2026 | issue | SO-260529-312 | MAIN | 21 | 91.91 | -1,930.21 | 748 | 68,752.27 | April 11, 2026: 21 @ 91.91 |
| May 22, 2026 | issue | SO-260522-288 | MAIN | 10 | 91.91 | -919.15 | 769 | 70,682.48 | April 11, 2026: 10 @ 91.91 |
| May 16, 2026 | issue | SO-260516-430 | MAIN | 31 | 91.91 | -2,849.36 | 779 | 71,601.63 | April 11, 2026: 31 @ 91.91 |
| May 12, 2026 | issue | SO-260512-935 | MAIN | 29 | 91.91 | -2,665.53 | 810 | 74,450.99 | April 11, 2026: 29 @ 91.91 |
| May 9, 2026 | issue | SO-260509-642 | MAIN | 8 | 91.91 | -735.32 | 839 | 77,116.52 | April 11, 2026: 8 @ 91.91 |
| May 8, 2026 | issue | SO-260508-412 | MAIN | 146 | 91.91 | -13,419.56 | 847 | 77,851.84 | April 11, 2026: 146 @ 91.91 |
| April 26, 2026 | issue | SO-260426-100 | MAIN | 14 | 91.91 | -1,286.81 | 993 | 91,271.40 | April 11, 2026: 14 @ 91.91 |
| April 20, 2026 | issue | SO-260420-489 | MAIN | 43 | 91.91 | -3,952.34 | 1,007 | 92,558.20 | April 11, 2026: 43 @ 91.91 |
| April 11, 2026 | receipt | PO-001397 | MAIN | 1,050 | 91.91 | 96,510.54 | 1,050 | 96,510.54 | |
| April 2, 2026 | issue | SO-260402-531 | MAIN | 14 | 92.80 | -1,299.24 | 0 | 0.00 | Dec. 28, 2025: 14 @ 92.80 |
| March 29, 2026 | issue | SO-260329-856 | MAIN | 137 | 92.80 | -12,713.96 | 14 | 1,299.24 | Nov. 27, 2025: 100 @ 92.80; Dec. 28, 2025: 37 @ 92.80 |
| March 22, 2026 | issue | SO-260322-452 | MAIN | 62 | 92.80 | -5,753.76 | 151 | 14,013.19 | Nov. 27, 2025: 62 @ 92.80 |
| March 19, 2026 | issue | SO-260319-935 | MAIN | 23 | 92.80 | -2,134.46 | 213 | 19,766.95 | Nov. 27, 2025: 23 @ 92.80 |
| March 18, 2026 | issue | SO-260318-757 | MAIN | 71 | 92.80 | -6,588.98 | 236 | 21,901.41 | Nov. 27, 2025: 71 @ 92.80 |
| March 11, 2026 | issue | SO-260311-221 | MAIN | 6 | 92.80 | -556.82 | 307 | 28,490.40 | Nov. 27, 2025: 6 @ 92.80 |
| Feb. 25, 2026 | issue | SO-260225-526 | MAIN | 35 | 92.80 | -3,248.09 | 313 | 29,047.21 | Nov. 27, 2025: 35 @ 92.80 |
| Feb. 10, 2026 | issue | SO-260210-346 | MAIN | 2 | 92.80 | -185.61 | 348 | 32,295.30 | Nov. 27, 2025: 2 @ 92.80 |
| Feb. 8, 2026 | issue | SO-260208-781 | MAIN | 50 | 92.80 | -4,640.13 | 350 | 32,480.91 | Nov. 27, 2025: 50 @ 92.80 |
| Feb. 3, 2026 | issue | SO-260203-969 | MAIN | 71 | 92.80 | -6,588.98 | 400 | 37,121.04 | Nov. 27, 2025: 71 @ 92.80 |
| Feb. 1, 2026 | issue | SO-260201-317 | MAIN | 128 | 92.80 | -11,878.73 | 471 | 43,710.02 | Nov. 27, 2025: 128 @ 92.80 |
| Jan. 29, 2026 | issue | SO-260129-643 | MAIN | 85 | 92.80 | -7,888.22 | 599 | 55,588.76 | Nov. 27, 2025: 85 @ 92.80 |
| Jan. 26, 2026 | issue | SO-260126-626 | MAIN | 215 | 92.80 | -19,952.56 | 684 | 63,476.98 | Nov. 27, 2025: 215 @ 92.80 |
| Dec. 28, 2025 | return | RMA | MAIN | 51 | 92.80 | 4,732.93 | 899 | 83,429.54 | |
| Dec. 21, 2025 | issue | SO-251221-530 | MAIN | 27 | 92.80 | -2,505.67 | 848 | 78,696.60 | Nov. 27, 2025: 27 @ 92.80 |
| Dec. 18, 2025 | issue | SO-251218-209 | MAIN | 94 | 92.80 | -8,723.44 | 875 | 81,202.28 | Nov. 27, 2025: 94 @ 92.80 |
| Dec. 9, 2025 | issue | SO-251209-806 | MAIN | 102 | 92.22 | -9,406.31 | 969 | 89,925.72 | Aug. 12, 2025: 18 @ 89.97; Sept. 25, 2025: 3 @ 89.97; Nov. 27, 2025: 81 @ 92.80 |
| Dec. 1, 2025 | issue | SO-251201-172 | MAIN | 105 | 89.97 | -9,446.49 | 1,071 | 99,332.03 | Aug. 12, 2025: 105 @ 89.97 |
| Nov. 27, 2025 | issue | SO-251127-937 | MAIN | 35 | 89.97 | -3,148.83 | 1,176 | 108,778.52 | Aug. 12, 2025: 35 @ 89.97 |
| Nov. 27, 2025 | receipt | PO-001021 | MAIN | 1,050 | 92.80 | 97,442.73 | 1,211 | 111,927.35 | |
| Nov. 22, 2025 | issue | SO-251122-138 | MAIN | 2 | 89.97 | -179.93 | 161 | 14,484.62 | Aug. 12, 2025: 2 @ 89.97 |
| Nov. 21, 2025 | issue | SO-251121-812 | MAIN | 212 | 89.97 | -19,072.92 | 163 | 14,664.56 | Aug. 12, 2025: 212 @ 89.97 |
| Nov. 16, 2025 | issue | SO-251116-508 | MAIN | 4 | 89.97 | -359.87 | 375 | 33,737.48 | Aug. 12, 2025: 4 @ 89.97 |
| Nov. 14, 2025 | issue | SO-251114-376 | MAIN | 71 | 89.97 | -6,387.63 | 379 | 34,097.34 | Aug. 12, 2025: 71 @ 89.97 |
| Nov. 9, 2025 | issue | SO-251109-468 | MAIN | 10 | 89.97 | -899.67 | 450 | 40,484.97 | Aug. 12, 2025: 10 @ 89.97 |
| Oct. 31, 2025 | issue | SO-251031-304 | MAIN | 12 | 89.97 | -1,079.60 | 460 | 41,384.64 | Aug. 12, 2025: 12 @ 89.97 |
| Oct. 27, 2025 | issue | SO-251027-528 | MAIN | 23 | 89.97 | -2,069.23 | 472 | 42,464.24 | Aug. 12, 2025: 23 @ 89.97 |
| Oct. 26, 2025 | issue | SO-251026-630 | MAIN | 27 | 89.97 | -2,429.10 | 495 | 44,533.47 | Aug. 12, 2025: 27 @ 89.97 |
| Oct. 18, 2025 | issue | SO-251018-110 | MAIN | 26 | 89.97 | -2,339.13 | 522 | 46,962.57 | Aug. 12, 2025: 26 @ 89.97 |
| Oct. 17, 2025 | issue | SO-251017-195 | MAIN | 33 | 89.97 | -2,968.90 | 548 | 49,301.70 | Aug. 12, 2025: 33 @ 89.97 |
| Oct. 11, 2025 | issue | SO-251011-602 | MAIN | 114 | 89.97 | -10,256.19 | 581 | 52,270.59 | Aug. 12, 2025: 114 @ 89.97 |
| Oct. 4, 2025 | issue | SO-251004-468 | MAIN | 88 | 89.97 | -7,917.06 | 695 | 62,526.79 | Aug. 12, 2025: 88 @ 89.97 |
| Sept. 28, 2025 | issue | SO-250928-327 | MAIN | 3 | 89.97 | -269.90 | 783 | 70,443.85 | Aug. 12, 2025: 3 @ 89.97 |
| Sept. 25, 2025 | return | RMA | MAIN | 3 | 89.97 | 269.90 | 786 | 70,713.75 | |
| Sept. 16, 2025 | issue | SO-250916-603 | MAIN | 138 | 89.97 | -12,415.39 | 783 | 70,443.85 | Aug. 12, 2025: 138 @ 89.97 |
| Sept. 14, 2025 | issue | SO-250914-703 | MAIN | 21 | 89.97 | -1,889.30 | 921 | 82,859.24 | Aug. 12, 2025: 21 @ 89.97 |