Items / LED-0018
LED Bulb 9W Lite LED-0018 · Lighting · BrightLine Lighting
On hand (EA)111MAIN 17, EAST 94
Value (FIFO)820.94avg 7.40
ClassCX / FCV 0.29
Turnover8.7xlast issue 3 days ago
Days of cover27lead 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 | 126.58 / 30.4375 | 4.159 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 36.96 / 5.517 | 6.700 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.900) | 1.282 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.282 * sqrt(9.6 * 6.700^2 + 4.159^2 * 2.2^2) | 29.0 |
| Reorder point | d * LT + safety stock | 4.159 * 9.6 + 29.0 | 68.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 68.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1518/yr, S = 45.00, h = 20%, price = 7.59 | 300.0 |
| Inventory position | on hand + on order | 111 + 0 | 111 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 7.59 | 300 | 11,977 | yes (chosen if cheapest) |
MOQ 470, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 15, 2026 | 111 / 470 | 7.40 | 820.94 |
Movement ledger 112 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 13, 2026 | issue | SO-261013-246 | MAIN | 13 | 7.40 | -96.15 | 111 | 820.94 | July 15, 2026: 13 @ 7.40 |
| Oct. 12, 2026 | issue | SO-261012-996 | MAIN | 1 | 7.40 | -7.40 | 124 | 917.09 | July 15, 2026: 1 @ 7.40 |
| Oct. 10, 2026 | issue | SO-261010-504 | MAIN | 94 | 7.40 | -695.21 | 125 | 924.49 | July 15, 2026: 94 @ 7.40 |
| Oct. 4, 2026 | issue | SO-261004-616 | EAST | 6 | 7.40 | -44.38 | 219 | 1,619.70 | July 15, 2026: 6 @ 7.40 |
| Sept. 30, 2026 | issue | SO-260930-384 | MAIN | 103 | 7.40 | -761.78 | 225 | 1,664.08 | July 15, 2026: 103 @ 7.40 |
| Sept. 15, 2026 | issue | SO-260915-261 | MAIN | 22 | 7.40 | -162.71 | 328 | 2,425.86 | July 15, 2026: 22 @ 7.40 |
| Sept. 13, 2026 | issue | SO-260913-868 | EAST | 1 | 7.40 | -7.40 | 350 | 2,588.56 | July 15, 2026: 1 @ 7.40 |
| Aug. 24, 2026 | issue | SO-260824-681 | MAIN | 6 | 7.40 | -44.38 | 351 | 2,595.96 | July 15, 2026: 6 @ 7.40 |
| Aug. 17, 2026 | issue | SO-260817-468 | MAIN | 42 | 7.40 | -310.63 | 357 | 2,640.34 | July 15, 2026: 42 @ 7.40 |
| Aug. 16, 2026 | issue | SO-260816-242 | EAST | 43 | 7.40 | -318.02 | 399 | 2,950.96 | July 15, 2026: 43 @ 7.40 |
| Aug. 2, 2026 | issue | SO-260802-806 | MAIN | 20 | 7.40 | -147.92 | 442 | 3,268.99 | July 15, 2026: 20 @ 7.40 |
| July 27, 2026 | issue | SO-260727-577 | MAIN | 14 | 7.41 | -103.68 | 462 | 3,416.91 | March 13, 2026: 6 @ 7.42; July 15, 2026: 8 @ 7.40 |
| July 24, 2026 | issue | SO-260724-975 | EAST | 9 | 7.42 | -66.77 | 476 | 3,520.59 | March 13, 2026: 9 @ 7.42 |
| July 17, 2026 | issue | SO-260717-114 | MAIN | 21 | 7.42 | -155.79 | 485 | 3,587.35 | March 13, 2026: 21 @ 7.42 |
| July 15, 2026 | transfer | TRF | MAIN → EAST | 153 | warehouse transfer, no cost effect | ||||
| July 15, 2026 | receipt | PO-001646 | MAIN | 470 | 7.40 | 3,476.07 | 506 | 3,743.15 | |
| July 4, 2026 | issue | SO-260704-405 | MAIN | 22 | 7.42 | -163.21 | 36 | 267.07 | March 13, 2026: 22 @ 7.42 |
| July 3, 2026 | issue | SO-260703-982 | MAIN | 13 | 7.42 | -96.44 | 58 | 430.28 | March 13, 2026: 13 @ 7.42 |
| July 2, 2026 | issue | SO-260702-232 | MAIN | 4 | 7.42 | -29.67 | 71 | 526.73 | March 13, 2026: 4 @ 7.42 |
| June 30, 2026 | issue | SO-260630-842 | MAIN | 9 | 7.42 | -66.77 | 75 | 556.40 | March 13, 2026: 9 @ 7.42 |
| June 17, 2026 | issue | SO-260617-131 | MAIN | 91 | 7.42 | -675.10 | 84 | 623.17 | March 13, 2026: 91 @ 7.42 |
| June 15, 2026 | issue | SO-260615-291 | MAIN | 8 | 7.42 | -59.35 | 175 | 1,298.27 | March 13, 2026: 8 @ 7.42 |
| June 7, 2026 | issue | SO-260607-942 | MAIN | 14 | 7.42 | -103.86 | 183 | 1,357.62 | March 13, 2026: 14 @ 7.42 |
| May 25, 2026 | issue | SO-260525-762 | MAIN | 5 | 7.42 | -37.09 | 197 | 1,461.48 | March 13, 2026: 5 @ 7.42 |
| May 23, 2026 | issue | SO-260523-791 | MAIN | 5 | 7.42 | -37.09 | 202 | 1,498.58 | March 13, 2026: 5 @ 7.42 |
| May 13, 2026 | issue | SO-260513-940 | MAIN | 49 | 7.42 | -363.52 | 207 | 1,535.67 | March 13, 2026: 49 @ 7.42 |
| May 6, 2026 | issue | SO-260506-814 | MAIN | 23 | 7.42 | -170.63 | 256 | 1,899.19 | March 13, 2026: 23 @ 7.42 |
| April 29, 2026 | issue | SO-260429-892 | MAIN | 1 | 7.42 | -7.42 | 279 | 2,069.82 | March 13, 2026: 1 @ 7.42 |
| April 29, 2026 | issue | SO-260429-892 | EAST | 38 | 7.42 | -281.91 | 280 | 2,077.24 | March 13, 2026: 38 @ 7.42 |
| April 24, 2026 | issue | SO-260424-393 | MAIN | 11 | 7.42 | -81.61 | 318 | 2,359.15 | March 13, 2026: 11 @ 7.42 |
| April 14, 2026 | issue | SO-260414-822 | MAIN | 57 | 7.42 | -422.87 | 329 | 2,440.75 | March 13, 2026: 57 @ 7.42 |
| April 1, 2026 | issue | SO-260401-960 | MAIN | 10 | 7.42 | -74.19 | 386 | 2,863.62 | March 13, 2026: 10 @ 7.42 |
| March 30, 2026 | issue | SO-260330-844 | EAST | 76 | 7.42 | -563.98 | 396 | 2,937.81 | Feb. 11, 2026: 2 @ 7.50; March 13, 2026: 74 @ 7.42 |
| March 28, 2026 | issue | SO-260328-703 | MAIN | 4 | 7.50 | -30.00 | 472 | 3,501.79 | Feb. 11, 2026: 4 @ 7.50 |
| March 13, 2026 | transfer | TRF | MAIN → EAST | 114 | warehouse transfer, no cost effect | ||||
| March 13, 2026 | receipt | PO-001311 | MAIN | 470 | 7.42 | 3,486.79 | 476 | 3,531.78 | |
| March 2, 2026 | issue | SO-260302-803 | MAIN | 68 | 7.50 | -509.94 | 6 | 44.99 | Nov. 24, 2025: 60 @ 7.50; Feb. 11, 2026: 8 @ 7.50 |
| Feb. 21, 2026 | issue | SO-260221-310 | MAIN | 14 | 7.50 | -104.99 | 74 | 554.93 | Nov. 24, 2025: 14 @ 7.50 |
| Feb. 13, 2026 | issue | SO-260213-917 | MAIN | 5 | 7.50 | -37.50 | 88 | 659.92 | Nov. 24, 2025: 5 @ 7.50 |
| Feb. 11, 2026 | return | RMA | MAIN | 14 | 7.50 | 104.99 | 93 | 697.42 | |
| Feb. 11, 2026 | issue | SO-260211-173 | MAIN | 6 | 7.50 | -44.99 | 79 | 592.43 | Nov. 24, 2025: 6 @ 7.50 |
| Feb. 10, 2026 | issue | SO-260210-867 | MAIN | 77 | 7.50 | -577.43 | 85 | 637.42 | Nov. 24, 2025: 77 @ 7.50 |
| Feb. 3, 2026 | issue | SO-260203-492 | MAIN | 14 | 7.50 | -104.99 | 162 | 1,214.85 | Nov. 24, 2025: 14 @ 7.50 |
| Feb. 2, 2026 | issue | SO-260202-354 | MAIN | 7 | 7.50 | -52.49 | 176 | 1,319.84 | Nov. 24, 2025: 7 @ 7.50 |
| Feb. 1, 2026 | issue | SO-260201-620 | MAIN | 18 | 7.50 | -134.98 | 183 | 1,372.34 | Nov. 24, 2025: 18 @ 7.50 |
| Jan. 30, 2026 | issue | SO-260130-743 | MAIN | 29 | 7.50 | -217.47 | 201 | 1,507.32 | Nov. 24, 2025: 29 @ 7.50 |
| Jan. 20, 2026 | issue | SO-260120-294 | MAIN | 152 | 7.50 | -1,139.86 | 230 | 1,724.79 | Nov. 24, 2025: 152 @ 7.50 |
| Jan. 13, 2026 | issue | SO-260113-435 | MAIN | 8 | 7.50 | -59.99 | 382 | 2,864.66 | Nov. 24, 2025: 8 @ 7.50 |
| Dec. 27, 2025 | issue | SO-251227-950 | MAIN | 40 | 7.50 | -299.96 | 390 | 2,924.65 | Nov. 24, 2025: 40 @ 7.50 |
| Dec. 17, 2025 | issue | SO-251217-857 | MAIN | 30 | 7.50 | -224.97 | 430 | 3,224.61 | Nov. 24, 2025: 30 @ 7.50 |
| Dec. 16, 2025 | issue | SO-251216-915 | MAIN | 22 | 7.31 | -160.88 | 460 | 3,449.59 | July 29, 2025: 12 @ 7.16; Nov. 24, 2025: 10 @ 7.50 |
| Nov. 26, 2025 | issue | SO-251126-302 | MAIN | 14 | 7.16 | -100.21 | 482 | 3,610.47 | July 29, 2025: 14 @ 7.16 |
| Nov. 24, 2025 | issue | SO-251124-302 | MAIN | 19 | 7.16 | -136.00 | 496 | 3,710.68 | July 29, 2025: 19 @ 7.16 |
| Nov. 24, 2025 | receipt | PO-001016 | MAIN | 470 | 7.50 | 3,524.58 | 515 | 3,846.67 | |
| Nov. 16, 2025 | issue | SO-251116-297 | MAIN | 16 | 7.16 | -114.52 | 45 | 322.10 | July 29, 2025: 16 @ 7.16 |
| Nov. 12, 2025 | issue | SO-251112-440 | MAIN | 26 | 7.16 | -186.10 | 61 | 436.62 | July 29, 2025: 26 @ 7.16 |
| Nov. 8, 2025 | issue | SO-251108-911 | MAIN | 84 | 7.16 | -601.25 | 87 | 622.72 | July 29, 2025: 84 @ 7.16 |
| Nov. 6, 2025 | issue | SO-251106-460 | MAIN | 41 | 7.16 | -293.47 | 171 | 1,223.97 | July 29, 2025: 41 @ 7.16 |
| Nov. 1, 2025 | issue | SO-251101-847 | MAIN | 7 | 7.16 | -50.10 | 212 | 1,517.43 | July 29, 2025: 7 @ 7.16 |
| Oct. 30, 2025 | issue | SO-251030-315 | MAIN | 42 | 7.16 | -300.62 | 219 | 1,567.54 | July 29, 2025: 42 @ 7.16 |