Items / LED-0011
LED Bulb 12W Prime LED-0011 · Lighting · BrightLine Lighting
On hand (EA)123MAIN 123
Value (FIFO)7,098.22avg 57.71
ClassAX / FCV 0.33
Turnover6.7xlast issue 3 days ago
Days of cover38lead 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 | 98.17 / 30.4375 | 3.225 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 31.91 / 5.517 | 5.784 |
| 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.784^2 + 3.225^2 * 2.2^2) | 39.5 |
| Reorder point | d * LT + safety stock | 3.225 * 9.6 + 39.5 | 70.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 70.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1177/yr, S = 45.00, h = 20%, price = 58.48 | 95.2 |
| Inventory position | on hand + on order | 123 + 0 | 123 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 58.48 | 95 | 69,955 | yes (chosen if cheapest) |
MOQ 370, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 22, 2026 | 123 / 370 | 57.71 | 7,098.22 |
Movement ledger 108 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-759 | MAIN | 16 | 57.71 | -923.35 | 123 | 7,098.22 | Aug. 22, 2026: 16 @ 57.71 |
| Oct. 12, 2026 | issue | SO-261012-453 | MAIN | 26 | 57.71 | -1,500.44 | 139 | 8,021.56 | Aug. 22, 2026: 26 @ 57.71 |
| Oct. 10, 2026 | issue | SO-261010-825 | MAIN | 11 | 57.71 | -634.80 | 165 | 9,522.00 | Aug. 22, 2026: 11 @ 57.71 |
| Oct. 8, 2026 | issue | SO-261008-982 | MAIN | 28 | 57.71 | -1,615.85 | 176 | 10,156.80 | Aug. 22, 2026: 28 @ 57.71 |
| Oct. 5, 2026 | issue | SO-261005-379 | MAIN | 1 | 57.71 | -57.71 | 204 | 11,772.66 | Aug. 22, 2026: 1 @ 57.71 |
| Oct. 5, 2026 | issue | SO-261005-379 | EAST | 1 | 57.71 | -57.71 | 205 | 11,830.37 | Aug. 22, 2026: 1 @ 57.71 |
| Oct. 3, 2026 | issue | SO-261003-382 | EAST | 21 | 57.71 | -1,211.89 | 206 | 11,888.07 | Aug. 22, 2026: 21 @ 57.71 |
| Sept. 27, 2026 | issue | SO-260927-231 | MAIN | 82 | 57.71 | -4,732.15 | 227 | 13,099.97 | Aug. 22, 2026: 82 @ 57.71 |
| Sept. 13, 2026 | issue | SO-260913-441 | EAST | 35 | 57.71 | -2,019.82 | 309 | 17,832.11 | Aug. 22, 2026: 35 @ 57.71 |
| Aug. 31, 2026 | issue | SO-260831-398 | EAST | 37 | 57.23 | -2,117.51 | 344 | 19,851.93 | March 16, 2026: 11 @ 56.10; Aug. 22, 2026: 26 @ 57.71 |
| Aug. 26, 2026 | issue | SO-260826-300 | EAST | 31 | 56.10 | -1,739.03 | 381 | 21,969.44 | March 16, 2026: 31 @ 56.10 |
| Aug. 22, 2026 | transfer | TRF | MAIN → EAST | 125 | warehouse transfer, no cost effect | ||||
| Aug. 22, 2026 | receipt | PO-001733 | MAIN | 370 | 57.71 | 21,352.37 | 412 | 23,708.47 | |
| Aug. 10, 2026 | issue | SO-260810-506 | MAIN | 31 | 56.10 | -1,739.03 | 42 | 2,356.10 | March 16, 2026: 31 @ 56.10 |
| July 22, 2026 | issue | SO-260722-967 | MAIN | 65 | 56.10 | -3,646.34 | 73 | 4,095.12 | March 16, 2026: 65 @ 56.10 |
| July 7, 2026 | issue | SO-260707-226 | MAIN | 17 | 56.10 | -953.66 | 138 | 7,741.47 | March 16, 2026: 17 @ 56.10 |
| June 27, 2026 | issue | SO-260627-669 | MAIN | 15 | 56.10 | -841.46 | 155 | 8,695.13 | March 16, 2026: 15 @ 56.10 |
| June 12, 2026 | issue | SO-260612-941 | MAIN | 27 | 56.10 | -1,514.64 | 170 | 9,536.59 | March 16, 2026: 27 @ 56.10 |
| June 12, 2026 | issue | SO-260612-941 | EAST | 3 | 56.10 | -168.29 | 197 | 11,051.23 | March 16, 2026: 3 @ 56.10 |
| June 6, 2026 | issue | SO-260606-385 | MAIN | 4 | 56.10 | -224.39 | 200 | 11,219.52 | March 16, 2026: 4 @ 56.10 |
| May 27, 2026 | issue | SO-260527-551 | EAST | 4 | 56.10 | -224.39 | 204 | 11,443.91 | March 16, 2026: 4 @ 56.10 |
| May 25, 2026 | issue | SO-260525-359 | MAIN | 4 | 56.10 | -224.39 | 208 | 11,668.30 | March 16, 2026: 4 @ 56.10 |
| May 22, 2026 | issue | SO-260522-472 | MAIN | 11 | 56.10 | -617.07 | 212 | 11,892.69 | March 16, 2026: 11 @ 56.10 |
| May 15, 2026 | issue | SO-260515-400 | MAIN | 21 | 56.10 | -1,178.05 | 223 | 12,509.76 | March 16, 2026: 21 @ 56.10 |
| May 13, 2026 | issue | SO-260513-717 | EAST | 9 | 56.10 | -504.88 | 244 | 13,687.81 | March 16, 2026: 9 @ 56.10 |
| May 8, 2026 | issue | SO-260508-404 | EAST | 60 | 56.10 | -3,365.86 | 253 | 14,192.69 | March 16, 2026: 60 @ 56.10 |
| April 24, 2026 | issue | SO-260424-656 | MAIN | 4 | 56.10 | -224.39 | 313 | 17,558.55 | March 16, 2026: 4 @ 56.10 |
| April 18, 2026 | issue | SO-260418-892 | MAIN | 17 | 56.10 | -953.66 | 317 | 17,782.94 | March 16, 2026: 17 @ 56.10 |
| April 14, 2026 | issue | SO-260414-679 | MAIN | 16 | 56.10 | -897.56 | 334 | 18,736.60 | March 16, 2026: 16 @ 56.10 |
| April 9, 2026 | issue | SO-260409-579 | EAST | 22 | 56.26 | -1,237.78 | 350 | 19,634.16 | Dec. 24, 2025: 2 @ 57.92; March 16, 2026: 20 @ 56.10 |
| April 6, 2026 | issue | SO-260406-438 | EAST | 10 | 57.92 | -579.16 | 372 | 20,871.94 | Dec. 24, 2025: 10 @ 57.92 |
| April 5, 2026 | issue | SO-260405-580 | MAIN | 22 | 57.92 | -1,274.15 | 382 | 21,451.10 | Dec. 24, 2025: 22 @ 57.92 |
| March 26, 2026 | issue | SO-260326-321 | MAIN | 10 | 57.92 | -579.16 | 404 | 22,725.26 | Dec. 24, 2025: 10 @ 57.92 |
| March 25, 2026 | issue | SO-260325-959 | MAIN | 5 | 57.92 | -289.58 | 414 | 23,304.42 | Dec. 24, 2025: 5 @ 57.92 |
| March 16, 2026 | transfer | TRF | MAIN → EAST | 108 | warehouse transfer, no cost effect | ||||
| March 16, 2026 | receipt | PO-001323 | MAIN | 370 | 56.10 | 20,756.11 | 419 | 23,594.00 | |
| March 8, 2026 | issue | SO-260308-352 | MAIN | 9 | 57.92 | -521.24 | 49 | 2,837.88 | Dec. 24, 2025: 9 @ 57.92 |
| March 7, 2026 | issue | SO-260307-945 | MAIN | 44 | 57.92 | -2,548.30 | 58 | 3,359.13 | Dec. 24, 2025: 44 @ 57.92 |
| Feb. 23, 2026 | issue | SO-260223-279 | MAIN | 15 | 57.92 | -868.74 | 102 | 5,907.43 | Dec. 24, 2025: 15 @ 57.92 |
| Feb. 16, 2026 | issue | SO-260216-175 | MAIN | 81 | 57.92 | -4,691.20 | 117 | 6,776.17 | Dec. 24, 2025: 81 @ 57.92 |
| Jan. 26, 2026 | issue | SO-260126-390 | MAIN | 87 | 57.92 | -5,038.69 | 198 | 11,467.37 | Dec. 24, 2025: 87 @ 57.92 |
| Jan. 14, 2026 | issue | SO-260114-933 | MAIN | 31 | 57.92 | -1,795.40 | 285 | 16,506.06 | Dec. 24, 2025: 31 @ 57.92 |
| Jan. 8, 2026 | issue | SO-260108-911 | MAIN | 1 | 57.92 | -57.92 | 316 | 18,301.46 | Dec. 24, 2025: 1 @ 57.92 |
| Jan. 7, 2026 | issue | SO-260107-810 | MAIN | 29 | 57.92 | -1,679.56 | 317 | 18,359.37 | Dec. 24, 2025: 29 @ 57.92 |
| Jan. 5, 2026 | issue | SO-260105-602 | MAIN | 36 | 57.29 | -2,062.60 | 346 | 20,038.94 | Sept. 9, 2025: 12 @ 56.05; Dec. 24, 2025: 24 @ 57.92 |
| Dec. 24, 2025 | receipt | PO-001080 | MAIN | 370 | 57.92 | 21,428.92 | 382 | 22,101.54 | |
| Dec. 22, 2025 | issue | SO-251222-940 | MAIN | 44 | 56.05 | -2,466.27 | 12 | 672.62 | Sept. 9, 2025: 44 @ 56.05 |
| Dec. 19, 2025 | issue | SO-251219-467 | MAIN | 8 | 56.05 | -448.41 | 56 | 3,138.90 | Sept. 9, 2025: 8 @ 56.05 |
| Dec. 18, 2025 | issue | SO-251218-253 | MAIN | 5 | 56.05 | -280.26 | 64 | 3,587.31 | Sept. 9, 2025: 5 @ 56.05 |
| Dec. 16, 2025 | issue | SO-251216-138 | MAIN | 32 | 56.05 | -1,793.65 | 69 | 3,867.57 | Sept. 9, 2025: 32 @ 56.05 |
| Dec. 10, 2025 | issue | SO-251210-231 | MAIN | 4 | 56.05 | -224.21 | 101 | 5,661.22 | Sept. 9, 2025: 4 @ 56.05 |
| Dec. 1, 2025 | issue | SO-251201-940 | MAIN | 22 | 56.05 | -1,233.14 | 105 | 5,885.43 | Sept. 9, 2025: 22 @ 56.05 |
| Nov. 27, 2025 | issue | SO-251127-853 | MAIN | 20 | 56.05 | -1,121.03 | 127 | 7,118.57 | Sept. 9, 2025: 20 @ 56.05 |
| Nov. 20, 2025 | issue | SO-251120-170 | MAIN | 5 | 56.05 | -280.26 | 147 | 8,239.60 | Sept. 9, 2025: 5 @ 56.05 |
| Nov. 19, 2025 | issue | SO-251119-677 | MAIN | 13 | 56.05 | -728.67 | 152 | 8,519.86 | Sept. 9, 2025: 13 @ 56.05 |
| Nov. 9, 2025 | issue | SO-251109-588 | MAIN | 6 | 56.05 | -336.31 | 165 | 9,248.53 | Sept. 9, 2025: 6 @ 56.05 |
| Nov. 7, 2025 | issue | SO-251107-235 | MAIN | 32 | 56.05 | -1,793.65 | 171 | 9,584.84 | Sept. 9, 2025: 32 @ 56.05 |
| Nov. 3, 2025 | issue | SO-251103-222 | MAIN | 13 | 56.05 | -728.67 | 203 | 11,378.50 | Sept. 9, 2025: 13 @ 56.05 |
| Oct. 29, 2025 | issue | SO-251029-711 | MAIN | 6 | 56.05 | -336.31 | 216 | 12,107.17 | Sept. 9, 2025: 6 @ 56.05 |
| Oct. 20, 2025 | issue | SO-251020-547 | MAIN | 27 | 56.05 | -1,513.40 | 222 | 12,443.48 | Sept. 9, 2025: 27 @ 56.05 |