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
| 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 |
| Oct. 7, 2025 | issue | SO-251007-350 | MAIN | 13 | 56.05 | -728.67 | 249 | 13,956.87 | Sept. 9, 2025: 13 @ 56.05 |
| Oct. 5, 2025 | issue | SO-251005-362 | MAIN | 19 | 56.05 | -1,064.98 | 262 | 14,685.55 | Sept. 9, 2025: 19 @ 56.05 |
| Oct. 3, 2025 | issue | SO-251003-239 | MAIN | 14 | 56.05 | -784.72 | 281 | 15,750.53 | Sept. 9, 2025: 14 @ 56.05 |
| Sept. 18, 2025 | issue | SO-250918-320 | MAIN | 68 | 56.05 | -3,811.52 | 295 | 16,535.25 | Sept. 9, 2025: 68 @ 56.05 |
| Sept. 10, 2025 | issue | SO-250910-286 | MAIN | 26 | 55.68 | -1,447.64 | 363 | 20,346.77 | April 20, 2025: 19 @ 55.54; Sept. 9, 2025: 7 @ 56.05 |
| Sept. 9, 2025 | receipt | PO-000823 | MAIN | 370 | 56.05 | 20,739.13 | 389 | 21,794.41 | |
| Sept. 3, 2025 | issue | SO-250903-877 | MAIN | 4 | 55.54 | -222.16 | 19 | 1,055.28 | April 20, 2025: 4 @ 55.54 |
| Aug. 29, 2025 | issue | SO-250829-364 | MAIN | 36 | 55.54 | -1,999.48 | 23 | 1,277.45 | April 20, 2025: 36 @ 55.54 |
| Aug. 26, 2025 | issue | SO-250826-545 | MAIN | 3 | 55.54 | -166.62 | 59 | 3,276.93 | April 20, 2025: 3 @ 55.54 |
| Aug. 24, 2025 | issue | SO-250824-293 | MAIN | 37 | 55.54 | -2,055.02 | 62 | 3,443.55 | April 20, 2025: 37 @ 55.54 |
| Aug. 9, 2025 | issue | SO-250809-666 | MAIN | 5 | 55.54 | -277.71 | 99 | 5,498.58 | April 20, 2025: 5 @ 55.54 |
| July 23, 2025 | issue | SO-250723-652 | MAIN | 29 | 55.54 | -1,610.69 | 104 | 5,776.28 | April 20, 2025: 29 @ 55.54 |
| July 22, 2025 | issue | SO-250722-246 | MAIN | 3 | 55.54 | -166.62 | 133 | 7,386.98 | April 20, 2025: 3 @ 55.54 |
| July 15, 2025 | issue | SO-250715-490 | MAIN | 43 | 55.54 | -2,388.27 | 136 | 7,553.60 | April 20, 2025: 43 @ 55.54 |
| July 5, 2025 | issue | SO-250705-991 | MAIN | 15 | 55.54 | -833.12 | 179 | 9,941.87 | April 20, 2025: 15 @ 55.54 |
| June 28, 2025 | issue | SO-250628-685 | MAIN | 22 | 55.54 | -1,221.91 | 194 | 10,774.99 | April 20, 2025: 22 @ 55.54 |
| June 24, 2025 | issue | SO-250624-566 | MAIN | 17 | 55.54 | -944.20 | 216 | 11,996.90 | April 20, 2025: 17 @ 55.54 |
| June 23, 2025 | issue | SO-250623-349 | MAIN | 26 | 55.54 | -1,444.07 | 233 | 12,941.10 | April 20, 2025: 26 @ 55.54 |
| June 4, 2025 | issue | SO-250604-708 | MAIN | 5 | 55.54 | -277.71 | 259 | 14,385.17 | April 20, 2025: 5 @ 55.54 |
| May 16, 2025 | issue | SO-250516-527 | MAIN | 14 | 55.54 | -777.58 | 264 | 14,662.88 | April 20, 2025: 14 @ 55.54 |
| May 10, 2025 | issue | SO-250510-906 | MAIN | 25 | 55.54 | -1,388.53 | 278 | 15,440.45 | April 20, 2025: 25 @ 55.54 |
| May 7, 2025 | issue | SO-250507-176 | MAIN | 42 | 55.54 | -2,332.73 | 303 | 16,828.98 | April 20, 2025: 42 @ 55.54 |
| May 3, 2025 | issue | SO-250503-613 | MAIN | 25 | 55.54 | -1,388.53 | 345 | 19,161.71 | April 20, 2025: 25 @ 55.54 |
| April 20, 2025 | receipt | PO-000464 | MAIN | 370 | 55.54 | 20,550.24 | 370 | 20,550.24 | |
| April 18, 2025 | issue | SO-250418-885 | MAIN | 21 | 55.43 | -1,164.12 | 0 | 0.00 | Dec. 13, 2024: 21 @ 55.43 |
| April 12, 2025 | issue | SO-250412-415 | MAIN | 39 | 55.43 | -2,161.94 | 21 | 1,164.12 | Dec. 13, 2024: 39 @ 55.43 |
| March 31, 2025 | issue | SO-250331-118 | MAIN | 11 | 55.43 | -609.78 | 60 | 3,326.06 | Dec. 13, 2024: 11 @ 55.43 |
| March 31, 2025 | issue | SO-250331-118 | EAST | 77 | 55.43 | -4,268.45 | 71 | 3,935.84 | Dec. 13, 2024: 77 @ 55.43 |
| March 27, 2025 | issue | SO-250327-858 | EAST | 4 | 55.43 | -221.74 | 148 | 8,204.29 | Dec. 13, 2024: 4 @ 55.43 |
| March 22, 2025 | issue | SO-250322-621 | EAST | 1 | 55.43 | -55.43 | 152 | 8,426.03 | Dec. 13, 2024: 1 @ 55.43 |
| March 19, 2025 | issue | SO-250319-734 | MAIN | 10 | 55.43 | -554.34 | 153 | 8,481.46 | Dec. 13, 2024: 10 @ 55.43 |
| Feb. 20, 2025 | issue | SO-250220-324 | MAIN | 28 | 55.43 | -1,552.16 | 163 | 9,035.81 | Dec. 13, 2024: 28 @ 55.43 |
| Feb. 19, 2025 | issue | SO-250219-895 | MAIN | 55 | 55.43 | -3,048.89 | 191 | 10,587.97 | Dec. 13, 2024: 55 @ 55.43 |
| Feb. 5, 2025 | issue | SO-250205-901 | MAIN | 44 | 55.43 | -2,439.11 | 246 | 13,636.86 | Dec. 13, 2024: 44 @ 55.43 |
| Jan. 18, 2025 | issue | SO-250118-259 | MAIN | 1 | 55.43 | -55.43 | 290 | 16,075.98 | Dec. 13, 2024: 1 @ 55.43 |
| Jan. 14, 2025 | issue | SO-250114-748 | MAIN | 76 | 55.43 | -4,213.01 | 291 | 16,131.41 | Dec. 13, 2024: 76 @ 55.43 |
| Jan. 2, 2025 | issue | SO-250102-576 | MAIN | 16 | 55.53 | -888.53 | 367 | 20,344.42 | Oct. 1, 2024: 13 @ 55.56; Dec. 13, 2024: 3 @ 55.43 |
| Dec. 18, 2024 | issue | SO-241218-465 | EAST | 29 | 55.56 | -1,611.12 | 383 | 21,232.96 | Oct. 1, 2024: 29 @ 55.56 |
| Dec. 13, 2024 | transfer | TRF | MAIN → EAST | 111 | warehouse transfer, no cost effect | ||||
| Dec. 13, 2024 | receipt | PO-000099 | MAIN | 370 | 55.43 | 20,510.73 | 412 | 22,844.08 | |
| Dec. 4, 2024 | issue | SO-241204-567 | MAIN | 69 | 55.56 | -3,833.36 | 42 | 2,333.35 | Oct. 1, 2024: 69 @ 55.56 |
| Dec. 1, 2024 | issue | SO-241201-120 | MAIN | 25 | 55.56 | -1,388.90 | 111 | 6,166.72 | Oct. 1, 2024: 25 @ 55.56 |
| Nov. 8, 2024 | issue | SO-241108-666 | MAIN | 56 | 55.56 | -3,111.14 | 136 | 7,555.62 | Oct. 1, 2024: 56 @ 55.56 |
| Nov. 3, 2024 | issue | SO-241103-150 | MAIN | 72 | 55.56 | -4,000.03 | 192 | 10,666.75 | Oct. 1, 2024: 72 @ 55.56 |
| Oct. 25, 2024 | issue | SO-241025-440 | MAIN | 62 | 55.56 | -3,444.47 | 264 | 14,666.78 | Oct. 1, 2024: 62 @ 55.56 |
| Oct. 24, 2024 | issue | SO-241024-610 | MAIN | 7 | 55.56 | -388.89 | 326 | 18,111.26 | Oct. 1, 2024: 7 @ 55.56 |
| Oct. 1, 2024 | issue | SO-241001-511 | MAIN | 37 | 55.56 | -2,055.57 | 333 | 18,500.15 | Oct. 1, 2024: 37 @ 55.56 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 370 | 55.56 | 20,555.72 | 370 | 20,555.72 | |