Items / LED-0004
LED Bulb 9W Pro LED-0004 · Lighting · BrightLine Lighting
On hand (EA)331MAIN 331
Value (FIFO)7,545.34avg 22.80
ClassBX / FCV 0.22
Turnover3.4xlast issue 2 days ago
Days of cover113lead 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 | 89.33 / 30.4375 | 2.935 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 19.25 / 5.517 | 3.489 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(9.6 * 3.489^2 + 2.935^2 * 2.2^2) | 20.6 |
| Reorder point | d * LT + safety stock | 2.935 * 9.6 + 20.6 | 48.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 48.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1071/yr, S = 45.00, h = 20%, price = 22.92 | 145.0 |
| Inventory position | on hand + on order | 331 + 0 | 331 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 22.92 | 145 | 25,218 | yes (chosen if cheapest) |
MOQ 370, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 2, 2026 | 331 / 370 | 22.80 | 7,545.34 |
Movement ledger 125 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-861 | MAIN | 6 | 22.80 | -136.77 | 331 | 7,545.34 | Oct. 2, 2026: 6 @ 22.80 |
| Oct. 13, 2026 | issue | SO-261013-682 | MAIN | 11 | 22.80 | -250.75 | 337 | 7,682.12 | Oct. 2, 2026: 11 @ 22.80 |
| Oct. 11, 2026 | issue | SO-261011-686 | MAIN | 74 | 22.21 | -1,643.67 | 348 | 7,932.87 | May 22, 2026: 52 @ 21.96; Oct. 2, 2026: 22 @ 22.80 |
| Oct. 7, 2026 | adjustment | Cycle count | MAIN | -1 | 21.96 | -21.96 | 422 | 9,576.54 | May 22, 2026: 1 @ 21.96 |
| Oct. 2, 2026 | receipt | PO-001843 | MAIN | 370 | 22.80 | 8,434.37 | 423 | 9,598.51 | |
| Sept. 25, 2026 | issue | SO-260925-918 | MAIN | 64 | 21.96 | -1,405.75 | 53 | 1,164.13 | May 22, 2026: 64 @ 21.96 |
| Sept. 22, 2026 | issue | SO-260922-261 | MAIN | 18 | 21.96 | -395.37 | 117 | 2,569.88 | May 22, 2026: 18 @ 21.96 |
| Sept. 14, 2026 | issue | SO-260914-411 | MAIN | 31 | 21.96 | -680.91 | 135 | 2,965.25 | May 22, 2026: 31 @ 21.96 |
| Sept. 11, 2026 | issue | SO-260911-456 | MAIN | 2 | 21.96 | -43.93 | 166 | 3,646.16 | May 22, 2026: 2 @ 21.96 |
| Sept. 4, 2026 | issue | SO-260904-222 | MAIN | 3 | 21.96 | -65.89 | 168 | 3,690.09 | May 22, 2026: 3 @ 21.96 |
| Aug. 27, 2026 | issue | SO-260827-651 | MAIN | 2 | 21.96 | -43.93 | 171 | 3,755.98 | May 22, 2026: 2 @ 21.96 |
| Aug. 26, 2026 | issue | SO-260826-449 | MAIN | 16 | 21.96 | -351.44 | 173 | 3,799.91 | May 22, 2026: 16 @ 21.96 |
| Aug. 10, 2026 | issue | SO-260810-971 | MAIN | 28 | 21.96 | -615.01 | 189 | 4,151.35 | May 22, 2026: 28 @ 21.96 |
| Aug. 9, 2026 | issue | SO-260809-678 | MAIN | 36 | 21.96 | -790.73 | 217 | 4,766.36 | May 22, 2026: 36 @ 21.96 |
| Aug. 5, 2026 | issue | SO-260805-361 | MAIN | 13 | 21.96 | -285.54 | 253 | 5,557.09 | May 22, 2026: 13 @ 21.96 |
| Aug. 1, 2026 | issue | SO-260801-596 | MAIN | 1 | 21.96 | -21.96 | 266 | 5,842.64 | May 22, 2026: 1 @ 21.96 |
| July 21, 2026 | issue | SO-260721-232 | MAIN | 10 | 21.96 | -219.65 | 267 | 5,864.60 | May 22, 2026: 10 @ 21.96 |
| July 17, 2026 | issue | SO-260717-398 | MAIN | 37 | 21.96 | -812.70 | 277 | 6,084.25 | May 22, 2026: 37 @ 21.96 |
| July 1, 2026 | issue | SO-260701-398 | MAIN | 11 | 21.96 | -241.61 | 314 | 6,896.95 | May 22, 2026: 11 @ 21.96 |
| June 24, 2026 | issue | SO-260624-578 | MAIN | 8 | 21.96 | -175.72 | 325 | 7,138.56 | May 22, 2026: 8 @ 21.96 |
| June 15, 2026 | issue | SO-260615-235 | MAIN | 29 | 21.96 | -636.98 | 333 | 7,314.28 | May 22, 2026: 29 @ 21.96 |
| June 13, 2026 | issue | SO-260613-698 | MAIN | 23 | 21.87 | -503.05 | 362 | 7,951.26 | Jan. 29, 2026: 15 @ 21.82; May 22, 2026: 8 @ 21.96 |
| June 4, 2026 | issue | SO-260604-800 | MAIN | 2 | 21.82 | -43.64 | 385 | 8,454.31 | Jan. 29, 2026: 2 @ 21.82 |
| May 28, 2026 | issue | SO-260528-951 | MAIN | 18 | 21.82 | -392.80 | 387 | 8,497.95 | Jan. 29, 2026: 18 @ 21.82 |
| May 22, 2026 | receipt | PO-001516 | MAIN | 370 | 21.96 | 8,126.98 | 405 | 8,890.75 | |
| May 14, 2026 | issue | SO-260514-663 | MAIN | 21 | 21.82 | -458.27 | 35 | 763.78 | Jan. 29, 2026: 21 @ 21.82 |
| May 2, 2026 | issue | SO-260502-751 | MAIN | 31 | 21.82 | -676.49 | 56 | 1,222.04 | Jan. 29, 2026: 31 @ 21.82 |
| April 23, 2026 | issue | SO-260423-542 | MAIN | 22 | 21.82 | -480.09 | 87 | 1,898.53 | Jan. 29, 2026: 22 @ 21.82 |
| April 17, 2026 | issue | SO-260417-396 | MAIN | 1 | 21.82 | -21.82 | 109 | 2,378.62 | Jan. 29, 2026: 1 @ 21.82 |
| April 12, 2026 | issue | SO-260412-375 | MAIN | 61 | 21.82 | -1,331.15 | 110 | 2,400.44 | Jan. 29, 2026: 61 @ 21.82 |
| March 28, 2026 | adjustment | Cycle count | MAIN | -2 | 21.82 | -43.64 | 171 | 3,731.60 | Jan. 29, 2026: 2 @ 21.82 |
| March 28, 2026 | issue | SO-260328-787 | MAIN | 16 | 21.82 | -349.16 | 173 | 3,775.24 | Jan. 29, 2026: 16 @ 21.82 |
| March 13, 2026 | issue | SO-260313-932 | MAIN | 2 | 21.82 | -43.64 | 189 | 4,124.40 | Jan. 29, 2026: 2 @ 21.82 |
| March 7, 2026 | issue | SO-260307-412 | MAIN | 57 | 21.82 | -1,243.87 | 191 | 4,168.04 | Jan. 29, 2026: 57 @ 21.82 |
| March 5, 2026 | issue | SO-260305-980 | MAIN | 5 | 21.82 | -109.11 | 248 | 5,411.91 | Jan. 29, 2026: 5 @ 21.82 |
| Feb. 22, 2026 | issue | SO-260222-184 | MAIN | 1 | 21.82 | -21.82 | 253 | 5,521.02 | Jan. 29, 2026: 1 @ 21.82 |
| Feb. 16, 2026 | issue | SO-260216-586 | MAIN | 50 | 21.82 | -1,091.11 | 254 | 5,542.84 | Jan. 29, 2026: 50 @ 21.82 |
| Feb. 11, 2026 | issue | SO-260211-513 | MAIN | 15 | 21.82 | -327.33 | 304 | 6,633.95 | Jan. 29, 2026: 15 @ 21.82 |
| Feb. 10, 2026 | issue | SO-260210-319 | MAIN | 19 | 21.82 | -414.62 | 319 | 6,961.28 | Jan. 29, 2026: 19 @ 21.82 |
| Feb. 2, 2026 | issue | SO-260202-358 | MAIN | 32 | 21.82 | -698.31 | 338 | 7,375.90 | Jan. 29, 2026: 32 @ 21.82 |
| Jan. 29, 2026 | receipt | PO-001183 | MAIN | 370 | 21.82 | 8,074.21 | 370 | 8,074.21 | |
| Jan. 28, 2026 | issue | SO-260128-636 | MAIN | 42 | 21.49 | -902.54 | 0 | 0.00 | Oct. 3, 2025: 39 @ 21.49; Dec. 25, 2025: 3 @ 21.49 |
| Jan. 18, 2026 | issue | SO-260118-307 | MAIN | 32 | 21.49 | -687.65 | 42 | 902.54 | Oct. 3, 2025: 32 @ 21.49 |
| Jan. 6, 2026 | issue | SO-260106-853 | MAIN | 11 | 21.49 | -236.38 | 74 | 1,590.19 | Oct. 3, 2025: 11 @ 21.49 |
| Dec. 30, 2025 | issue | SO-251230-492 | MAIN | 7 | 21.49 | -150.42 | 85 | 1,826.57 | Oct. 3, 2025: 7 @ 21.49 |
| Dec. 29, 2025 | issue | SO-251229-417 | MAIN | 7 | 21.49 | -150.42 | 92 | 1,977.00 | Oct. 3, 2025: 7 @ 21.49 |
| Dec. 25, 2025 | return | RMA | MAIN | 3 | 21.49 | 64.47 | 99 | 2,127.42 | |
| Dec. 23, 2025 | issue | SO-251223-919 | MAIN | 55 | 21.49 | -1,181.90 | 96 | 2,062.95 | Oct. 3, 2025: 55 @ 21.49 |
| Dec. 22, 2025 | issue | SO-251222-473 | MAIN | 2 | 21.49 | -42.98 | 151 | 3,244.85 | Oct. 3, 2025: 2 @ 21.49 |
| Dec. 7, 2025 | issue | SO-251207-396 | MAIN | 7 | 21.49 | -150.42 | 153 | 3,287.83 | Oct. 3, 2025: 7 @ 21.49 |
| Dec. 4, 2025 | issue | SO-251204-510 | MAIN | 20 | 21.49 | -429.78 | 160 | 3,438.26 | Oct. 3, 2025: 20 @ 21.49 |
| Nov. 30, 2025 | issue | SO-251130-378 | MAIN | 49 | 21.49 | -1,052.97 | 180 | 3,868.04 | Oct. 3, 2025: 49 @ 21.49 |
| Nov. 25, 2025 | issue | SO-251125-132 | MAIN | 36 | 21.49 | -773.61 | 229 | 4,921.00 | Oct. 3, 2025: 36 @ 21.49 |
| Nov. 13, 2025 | issue | SO-251113-654 | MAIN | 23 | 21.49 | -494.25 | 265 | 5,694.61 | Oct. 3, 2025: 23 @ 21.49 |
| Nov. 8, 2025 | issue | SO-251108-371 | MAIN | 4 | 21.49 | -85.96 | 288 | 6,188.86 | Oct. 3, 2025: 4 @ 21.49 |
| Oct. 23, 2025 | issue | SO-251023-956 | MAIN | 2 | 21.49 | -42.98 | 292 | 6,274.82 | Oct. 3, 2025: 2 @ 21.49 |
| Oct. 17, 2025 | issue | SO-251017-202 | MAIN | 8 | 21.49 | -171.91 | 294 | 6,317.80 | Oct. 3, 2025: 8 @ 21.49 |
| Oct. 15, 2025 | issue | SO-251015-926 | MAIN | 9 | 21.49 | -193.40 | 302 | 6,489.71 | Oct. 3, 2025: 9 @ 21.49 |
| Oct. 8, 2025 | issue | SO-251008-286 | MAIN | 15 | 21.49 | -322.34 | 311 | 6,683.11 | Oct. 3, 2025: 15 @ 21.49 |
| Oct. 3, 2025 | issue | SO-251003-366 | MAIN | 48 | 21.51 | -1,032.57 | 326 | 7,005.45 | June 5, 2025: 2 @ 22.15; June 8, 2025: 2 @ 21.37; Oct. 3, 2025: 44 @ 21.49 |