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
| 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 |
| Oct. 10, 2025 | issue | SO-251010-285 | MAIN | 37 | 7.16 | -264.83 | 261 | 1,868.16 | July 29, 2025: 37 @ 7.16 |
| Oct. 5, 2025 | issue | SO-251005-339 | MAIN | 36 | 7.16 | -257.68 | 298 | 2,132.99 | July 29, 2025: 36 @ 7.16 |
| Sept. 17, 2025 | issue | SO-250917-916 | MAIN | 19 | 7.16 | -136.00 | 334 | 2,390.67 | July 29, 2025: 19 @ 7.16 |
| Sept. 11, 2025 | issue | SO-250911-877 | MAIN | 16 | 7.16 | -114.52 | 353 | 2,526.67 | July 29, 2025: 16 @ 7.16 |
| Sept. 6, 2025 | issue | SO-250906-347 | MAIN | 33 | 7.16 | -236.20 | 369 | 2,641.19 | July 29, 2025: 33 @ 7.16 |
| Sept. 2, 2025 | issue | SO-250902-358 | MAIN | 9 | 7.16 | -64.42 | 402 | 2,877.40 | July 29, 2025: 9 @ 7.16 |
| Aug. 31, 2025 | issue | SO-250831-890 | MAIN | 8 | 7.16 | -57.26 | 411 | 2,941.81 | July 29, 2025: 8 @ 7.16 |
| Aug. 25, 2025 | issue | SO-250825-378 | MAIN | 1 | 7.16 | -7.16 | 419 | 2,999.08 | July 29, 2025: 1 @ 7.16 |
| Aug. 21, 2025 | issue | SO-250821-887 | EAST | 77 | 7.16 | -551.50 | 420 | 3,006.23 | March 27, 2025: 11 @ 7.17; April 14, 2025: 16 @ 7.17; July 29, 2025: 50 @ 7.16 |
| Aug. 4, 2025 | issue | SO-250804-158 | EAST | 21 | 7.17 | -150.59 | 497 | 3,557.74 | March 27, 2025: 21 @ 7.17 |
| July 29, 2025 | transfer | TRF | MAIN → EAST | 98 | warehouse transfer, no cost effect | ||||
| July 29, 2025 | receipt | PO-000741 | MAIN | 470 | 7.16 | 3,364.12 | 518 | 3,708.33 | |
| July 21, 2025 | issue | SO-250721-913 | MAIN | 38 | 7.17 | -272.50 | 48 | 344.21 | March 27, 2025: 38 @ 7.17 |
| July 18, 2025 | issue | SO-250718-930 | MAIN | 4 | 7.17 | -28.68 | 86 | 616.71 | March 27, 2025: 4 @ 7.17 |
| July 8, 2025 | issue | SO-250708-875 | MAIN | 61 | 7.17 | -437.43 | 90 | 645.39 | March 27, 2025: 61 @ 7.17 |
| June 27, 2025 | issue | SO-250627-641 | MAIN | 72 | 7.17 | -516.31 | 151 | 1,082.82 | March 27, 2025: 72 @ 7.17 |
| June 5, 2025 | issue | SO-250605-883 | MAIN | 21 | 7.17 | -150.59 | 223 | 1,599.13 | March 27, 2025: 21 @ 7.17 |
| May 27, 2025 | issue | SO-250527-943 | MAIN | 113 | 7.17 | -810.32 | 244 | 1,749.72 | March 27, 2025: 113 @ 7.17 |
| May 20, 2025 | issue | SO-250520-112 | MAIN | 8 | 7.17 | -57.37 | 357 | 2,560.05 | March 27, 2025: 8 @ 7.17 |
| April 27, 2025 | issue | SO-250427-370 | MAIN | 5 | 7.17 | -35.86 | 365 | 2,617.42 | March 27, 2025: 5 @ 7.17 |
| April 26, 2025 | issue | SO-250426-540 | MAIN | 70 | 7.17 | -501.97 | 370 | 2,653.27 | March 27, 2025: 70 @ 7.17 |
| April 14, 2025 | return | RMA | MAIN | 16 | 7.17 | 114.74 | 440 | 3,155.24 | |
| April 14, 2025 | issue | SO-250414-727 | MAIN | 37 | 7.17 | -265.33 | 424 | 3,040.50 | March 27, 2025: 37 @ 7.17 |
| April 13, 2025 | issue | SO-250413-512 | MAIN | 42 | 7.17 | -301.06 | 461 | 3,305.83 | Dec. 17, 2024: 23 @ 7.15; Dec. 22, 2024: 10 @ 7.21; March 27, 2025: 9 @ 7.17 |
| April 9, 2025 | issue | SO-250409-455 | MAIN | 32 | 7.15 | -228.76 | 503 | 3,606.90 | Dec. 17, 2024: 32 @ 7.15 |
| April 1, 2025 | issue | SO-250401-689 | MAIN | 1 | 7.15 | -7.15 | 535 | 3,835.65 | Dec. 17, 2024: 1 @ 7.15 |
| March 27, 2025 | receipt | PO-000386 | MAIN | 470 | 7.17 | 3,370.37 | 536 | 3,842.80 | |
| March 17, 2025 | issue | SO-250317-480 | MAIN | 42 | 7.15 | -300.25 | 66 | 472.43 | Dec. 17, 2024: 42 @ 7.15 |
| March 10, 2025 | issue | SO-250310-759 | MAIN | 16 | 7.15 | -114.38 | 108 | 772.68 | Dec. 17, 2024: 16 @ 7.15 |
| March 7, 2025 | issue | SO-250307-669 | MAIN | 58 | 7.15 | -414.62 | 124 | 887.06 | Dec. 17, 2024: 58 @ 7.15 |
| Feb. 26, 2025 | issue | SO-250226-588 | MAIN | 21 | 7.15 | -150.12 | 182 | 1,301.68 | Dec. 17, 2024: 21 @ 7.15 |
| Feb. 25, 2025 | issue | SO-250225-378 | MAIN | 33 | 7.15 | -235.91 | 203 | 1,451.80 | Dec. 17, 2024: 33 @ 7.15 |
| Feb. 23, 2025 | issue | SO-250223-907 | MAIN | 5 | 7.15 | -35.74 | 236 | 1,687.71 | Dec. 17, 2024: 5 @ 7.15 |
| Feb. 11, 2025 | issue | SO-250211-744 | MAIN | 52 | 7.15 | -371.73 | 241 | 1,723.45 | Dec. 17, 2024: 52 @ 7.15 |
| Feb. 9, 2025 | issue | SO-250209-711 | MAIN | 10 | 7.15 | -71.49 | 293 | 2,095.19 | Dec. 17, 2024: 10 @ 7.15 |
| Feb. 1, 2025 | issue | SO-250201-789 | MAIN | 2 | 7.15 | -14.30 | 303 | 2,166.67 | Dec. 17, 2024: 2 @ 7.15 |
| Jan. 30, 2025 | issue | SO-250130-302 | MAIN | 2 | 7.15 | -14.30 | 305 | 2,180.97 | Dec. 17, 2024: 2 @ 7.15 |
| Jan. 23, 2025 | issue | SO-250123-729 | MAIN | 89 | 7.15 | -636.23 | 307 | 2,195.27 | Dec. 17, 2024: 89 @ 7.15 |
| Jan. 14, 2025 | issue | SO-250114-305 | MAIN | 79 | 7.15 | -564.75 | 396 | 2,831.50 | Dec. 17, 2024: 79 @ 7.15 |
| Dec. 23, 2024 | issue | SO-241223-823 | MAIN | 10 | 7.18 | -71.80 | 475 | 3,396.25 | Oct. 1, 2024: 5 @ 7.21; Dec. 17, 2024: 5 @ 7.15 |
| Dec. 22, 2024 | return | RMA | MAIN | 10 | 7.21 | 72.10 | 485 | 3,468.05 | |
| Dec. 18, 2024 | issue | SO-241218-688 | MAIN | 20 | 7.21 | -144.21 | 475 | 3,395.94 | Oct. 1, 2024: 20 @ 7.21 |
| Dec. 17, 2024 | receipt | PO-000111 | MAIN | 470 | 7.15 | 3,359.89 | 495 | 3,540.15 | |
| Dec. 7, 2024 | issue | SO-241207-668 | MAIN | 159 | 7.21 | -1,146.47 | 25 | 180.26 | Oct. 1, 2024: 159 @ 7.21 |
| Nov. 28, 2024 | issue | SO-241128-473 | MAIN | 9 | 7.21 | -64.89 | 184 | 1,326.73 | Oct. 1, 2024: 9 @ 7.21 |
| Nov. 27, 2024 | issue | SO-241127-600 | MAIN | 65 | 7.21 | -468.68 | 193 | 1,391.63 | Oct. 1, 2024: 65 @ 7.21 |
| Nov. 20, 2024 | issue | SO-241120-975 | MAIN | 48 | 7.21 | -346.10 | 258 | 1,860.31 | Oct. 1, 2024: 48 @ 7.21 |
| Nov. 17, 2024 | issue | SO-241117-807 | MAIN | 17 | 7.21 | -122.58 | 306 | 2,206.41 | Oct. 1, 2024: 17 @ 7.21 |
| Nov. 14, 2024 | issue | SO-241114-493 | MAIN | 22 | 7.21 | -158.63 | 323 | 2,328.99 | Oct. 1, 2024: 22 @ 7.21 |
| Oct. 22, 2024 | issue | SO-241022-410 | MAIN | 28 | 7.21 | -201.89 | 345 | 2,487.62 | Oct. 1, 2024: 28 @ 7.21 |
| Oct. 6, 2024 | issue | SO-241006-329 | MAIN | 97 | 7.21 | -699.42 | 373 | 2,689.52 | Oct. 1, 2024: 97 @ 7.21 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 470 | 7.21 | 3,388.94 | 470 | 3,388.94 | |