Items / LED-0022
LED Bulb 12W Pro LED-0022 · Lighting · BrightLine Lighting
On hand (EA)187MAIN 187
Value (FIFO)8,292.27avg 44.34
ClassBX / FCV 0.35
Turnover3.2xlast issue 3 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 | 50.50 / 30.4375 | 1.659 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 17.72 / 5.517 | 3.211 |
| 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.211^2 + 1.659^2 * 2.2^2) | 17.4 |
| Reorder point | d * LT + safety stock | 1.659 * 9.6 + 17.4 | 33.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 33.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 606/yr, S = 45.00, h = 20%, price = 45.01 | 77.8 |
| Inventory position | on hand + on order | 187 + 0 | 187 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 45.01 | 78 | 27,958 | yes (chosen if cheapest) |
| 400 | 43.21 | 400 | 27,964 | yes |
| 800 | 41.41 | 800 | 28,424 | yes |
MOQ 200, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 8, 2026 | 187 / 200 | 44.34 | 8,292.27 |
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-750 | MAIN | 9 | 44.34 | -399.09 | 187 | 8,292.27 | Oct. 8, 2026: 9 @ 44.34 |
| Oct. 11, 2026 | issue | SO-261011-938 | MAIN | 4 | 44.34 | -177.37 | 196 | 8,691.37 | Oct. 8, 2026: 4 @ 44.34 |
| Oct. 8, 2026 | receipt | PO-001858 | MAIN | 200 | 44.34 | 8,868.74 | 200 | 8,868.74 | |
| Oct. 4, 2026 | issue | SO-261004-628 | MAIN | 29 | 43.46 | -1,260.45 | 0 | 0.00 | May 20, 2026: 24 @ 43.46; June 27, 2026: 5 @ 43.46 |
| Sept. 30, 2026 | issue | SO-260930-936 | MAIN | 36 | 43.46 | -1,564.70 | 29 | 1,260.45 | May 20, 2026: 36 @ 43.46 |
| Sept. 8, 2026 | issue | SO-260908-465 | MAIN | 7 | 43.46 | -304.25 | 65 | 2,825.15 | May 20, 2026: 7 @ 43.46 |
| Aug. 29, 2026 | issue | SO-260829-600 | MAIN | 15 | 43.46 | -651.96 | 72 | 3,129.39 | May 20, 2026: 15 @ 43.46 |
| Aug. 27, 2026 | issue | SO-260827-551 | MAIN | 3 | 43.46 | -130.39 | 87 | 3,781.35 | May 20, 2026: 3 @ 43.46 |
| Aug. 25, 2026 | issue | SO-260825-647 | MAIN | 1 | 43.46 | -43.46 | 90 | 3,911.74 | May 20, 2026: 1 @ 43.46 |
| Aug. 24, 2026 | issue | SO-260824-465 | MAIN | 2 | 43.46 | -86.93 | 91 | 3,955.21 | May 20, 2026: 2 @ 43.46 |
| Aug. 9, 2026 | issue | SO-260809-606 | MAIN | 1 | 43.46 | -43.46 | 93 | 4,042.13 | May 20, 2026: 1 @ 43.46 |
| Aug. 5, 2026 | issue | SO-260805-741 | MAIN | 8 | 43.46 | -347.71 | 94 | 4,085.60 | May 20, 2026: 8 @ 43.46 |
| Aug. 1, 2026 | issue | SO-260801-584 | MAIN | 9 | 43.46 | -391.17 | 102 | 4,433.31 | May 20, 2026: 9 @ 43.46 |
| July 30, 2026 | issue | SO-260730-699 | MAIN | 22 | 43.46 | -956.20 | 111 | 4,824.48 | May 20, 2026: 22 @ 43.46 |
| July 29, 2026 | issue | SO-260729-718 | MAIN | 17 | 43.46 | -738.88 | 133 | 5,780.69 | May 20, 2026: 17 @ 43.46 |
| July 16, 2026 | issue | SO-260716-960 | MAIN | 6 | 43.46 | -260.78 | 150 | 6,519.57 | May 20, 2026: 6 @ 43.46 |
| July 9, 2026 | issue | SO-260709-568 | MAIN | 1 | 43.46 | -43.46 | 156 | 6,780.35 | May 20, 2026: 1 @ 43.46 |
| June 27, 2026 | return | RMA | MAIN | 5 | 43.46 | 217.32 | 157 | 6,823.82 | |
| June 23, 2026 | issue | SO-260623-877 | MAIN | 10 | 43.46 | -434.64 | 152 | 6,606.50 | May 20, 2026: 10 @ 43.46 |
| June 14, 2026 | issue | SO-260614-877 | MAIN | 17 | 43.46 | -738.88 | 162 | 7,041.14 | May 20, 2026: 17 @ 43.46 |
| June 5, 2026 | issue | SO-260605-178 | MAIN | 1 | 43.46 | -43.46 | 179 | 7,780.02 | May 20, 2026: 1 @ 43.46 |
| June 1, 2026 | issue | SO-260601-879 | MAIN | 3 | 43.46 | -130.39 | 180 | 7,823.48 | May 20, 2026: 3 @ 43.46 |
| May 24, 2026 | issue | SO-260524-712 | MAIN | 18 | 43.44 | -782.00 | 183 | 7,953.88 | Jan. 24, 2026: 1 @ 43.12; May 20, 2026: 17 @ 43.46 |
| May 20, 2026 | receipt | PO-001508 | MAIN | 200 | 43.46 | 8,692.76 | 201 | 8,735.88 | |
| May 11, 2026 | issue | SO-260511-476 | MAIN | 48 | 43.12 | -2,069.72 | 1 | 43.12 | Jan. 24, 2026: 48 @ 43.12 |
| April 28, 2026 | issue | SO-260428-618 | MAIN | 14 | 43.12 | -603.67 | 49 | 2,112.84 | Jan. 24, 2026: 14 @ 43.12 |
| April 15, 2026 | issue | SO-260415-860 | MAIN | 13 | 43.12 | -560.55 | 63 | 2,716.50 | Jan. 24, 2026: 13 @ 43.12 |
| April 7, 2026 | issue | SO-260407-989 | MAIN | 7 | 43.12 | -301.83 | 76 | 3,277.05 | Jan. 24, 2026: 7 @ 43.12 |
| March 21, 2026 | issue | SO-260321-707 | MAIN | 8 | 43.12 | -344.95 | 83 | 3,578.89 | Jan. 24, 2026: 8 @ 43.12 |
| March 11, 2026 | issue | SO-260311-600 | MAIN | 12 | 43.12 | -517.43 | 91 | 3,923.84 | Jan. 24, 2026: 12 @ 43.12 |
| March 6, 2026 | issue | SO-260306-646 | MAIN | 1 | 43.12 | -43.12 | 103 | 4,441.27 | Jan. 24, 2026: 1 @ 43.12 |
| March 2, 2026 | issue | SO-260302-999 | MAIN | 8 | 43.12 | -344.95 | 104 | 4,484.39 | Jan. 24, 2026: 8 @ 43.12 |
| March 2, 2026 | issue | SO-260302-999 | EAST | 28 | 43.12 | -1,207.33 | 112 | 4,829.34 | Jan. 24, 2026: 28 @ 43.12 |
| Feb. 27, 2026 | issue | SO-260227-295 | MAIN | 4 | 43.12 | -172.48 | 140 | 6,036.67 | Jan. 24, 2026: 4 @ 43.12 |
| Feb. 19, 2026 | issue | SO-260219-811 | EAST | 16 | 43.12 | -689.91 | 144 | 6,209.15 | Jan. 24, 2026: 16 @ 43.12 |
| Feb. 13, 2026 | issue | SO-260213-709 | MAIN | 9 | 43.12 | -388.07 | 160 | 6,899.06 | Jan. 24, 2026: 9 @ 43.12 |
| Feb. 11, 2026 | issue | SO-260211-313 | EAST | 14 | 43.12 | -603.67 | 169 | 7,287.13 | Jan. 24, 2026: 14 @ 43.12 |
| Feb. 4, 2026 | issue | SO-260204-555 | EAST | 7 | 43.12 | -301.83 | 183 | 7,890.80 | Jan. 24, 2026: 7 @ 43.12 |
| Jan. 24, 2026 | issue | SO-260124-823 | MAIN | 12 | 43.19 | -518.28 | 190 | 8,192.63 | Oct. 14, 2025: 2 @ 43.54; Jan. 24, 2026: 10 @ 43.12 |
| Jan. 24, 2026 | transfer | TRF | MAIN → EAST | 65 | warehouse transfer, no cost effect | ||||
| Jan. 24, 2026 | receipt | PO-001173 | MAIN | 200 | 43.12 | 8,623.82 | 202 | 8,710.90 | |
| Jan. 22, 2026 | issue | SO-260122-502 | MAIN | 1 | 43.54 | -43.54 | 2 | 87.08 | Oct. 14, 2025: 1 @ 43.54 |
| Jan. 16, 2026 | issue | SO-260116-380 | MAIN | 38 | 43.54 | -1,654.60 | 3 | 130.63 | Oct. 14, 2025: 38 @ 43.54 |
| Jan. 9, 2026 | issue | SO-260109-252 | MAIN | 6 | 43.54 | -261.25 | 41 | 1,785.23 | Oct. 14, 2025: 6 @ 43.54 |
| Jan. 4, 2026 | issue | SO-260104-325 | MAIN | 2 | 43.54 | -87.08 | 47 | 2,046.48 | Oct. 14, 2025: 2 @ 43.54 |
| Dec. 23, 2025 | issue | SO-251223-107 | MAIN | 48 | 43.54 | -2,090.03 | 49 | 2,133.57 | Oct. 14, 2025: 48 @ 43.54 |
| Dec. 5, 2025 | issue | SO-251205-120 | MAIN | 23 | 43.54 | -1,001.47 | 97 | 4,223.59 | Oct. 14, 2025: 23 @ 43.54 |
| Dec. 3, 2025 | issue | SO-251203-357 | MAIN | 25 | 43.54 | -1,088.56 | 120 | 5,225.06 | Oct. 14, 2025: 25 @ 43.54 |
| Nov. 29, 2025 | issue | SO-251129-643 | MAIN | 18 | 43.54 | -783.76 | 145 | 6,313.62 | Oct. 14, 2025: 18 @ 43.54 |
| Nov. 27, 2025 | issue | SO-251127-636 | MAIN | 1 | 43.54 | -43.54 | 163 | 7,097.38 | Oct. 14, 2025: 1 @ 43.54 |
| Nov. 26, 2025 | issue | SO-251126-706 | MAIN | 7 | 43.54 | -304.80 | 164 | 7,140.92 | Oct. 14, 2025: 7 @ 43.54 |
| Nov. 19, 2025 | issue | SO-251119-824 | MAIN | 22 | 43.54 | -957.93 | 171 | 7,445.72 | Oct. 14, 2025: 22 @ 43.54 |
| Nov. 18, 2025 | issue | SO-251118-238 | MAIN | 2 | 43.54 | -87.08 | 193 | 8,403.64 | Oct. 14, 2025: 2 @ 43.54 |
| Nov. 12, 2025 | issue | SO-251112-544 | MAIN | 5 | 43.54 | -217.71 | 195 | 8,490.73 | Oct. 14, 2025: 5 @ 43.54 |
| Oct. 14, 2025 | receipt | PO-000918 | MAIN | 200 | 43.54 | 8,708.44 | 200 | 8,708.44 | |
| Oct. 7, 2025 | issue | SO-251007-691 | MAIN | 35 | 41.20 | -1,442.08 | 0 | 0.00 | May 4, 2025: 35 @ 41.20 |
| Sept. 29, 2025 | issue | SO-250929-508 | MAIN | 4 | 41.20 | -164.81 | 35 | 1,442.08 | May 4, 2025: 4 @ 41.20 |
| Sept. 28, 2025 | issue | SO-250928-442 | MAIN | 13 | 41.20 | -535.63 | 39 | 1,606.89 | May 4, 2025: 13 @ 41.20 |
| Sept. 26, 2025 | issue | SO-250926-781 | MAIN | 4 | 41.20 | -164.81 | 52 | 2,142.52 | May 4, 2025: 4 @ 41.20 |
| Sept. 12, 2025 | issue | SO-250912-179 | MAIN | 2 | 41.20 | -82.40 | 56 | 2,307.33 | May 4, 2025: 2 @ 41.20 |