Items / LED-0005
LED Bulb 9W Elite LED-0005 · Lighting · BrightLine Lighting
On hand (EA)165MAIN 79, EAST 86
Value (FIFO)1,568.00avg 9.50
ClassCX / FCV 0.18
Turnover5.2xlast issue 4 days ago
Days of cover76lead 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 | 65.75 / 30.4375 | 2.160 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 11.52 / 5.517 | 2.088 |
| 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 * 2.088^2 + 2.160^2 * 2.2^2) | 10.2 |
| Reorder point | d * LT + safety stock | 2.160 * 9.6 + 10.2 | 30.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 30.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 788/yr, S = 45.00, h = 20%, price = 9.52 | 193.1 |
| Inventory position | on hand + on order | 165 + 0 | 165 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 9.52 | 193 | 7,874 | yes (chosen if cheapest) |
MOQ 280, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 5, 2026 | 165 / 280 | 9.50 | 1,568.00 |
Movement ledger 135 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-892 | MAIN | 26 | 9.50 | -247.08 | 165 | 1,568.00 | Sept. 5, 2026: 26 @ 9.50 |
| Oct. 11, 2026 | issue | SO-261011-642 | MAIN | 13 | 9.50 | -123.54 | 191 | 1,815.07 | Sept. 5, 2026: 13 @ 9.50 |
| Oct. 10, 2026 | issue | SO-261010-688 | MAIN | 6 | 9.50 | -57.02 | 204 | 1,938.61 | Sept. 5, 2026: 6 @ 9.50 |
| Oct. 9, 2026 | issue | SO-261009-361 | MAIN | 1 | 9.50 | -9.50 | 210 | 1,995.63 | Sept. 5, 2026: 1 @ 9.50 |
| Oct. 5, 2026 | issue | SO-261005-822 | MAIN | 6 | 9.50 | -57.02 | 211 | 2,005.13 | Sept. 5, 2026: 6 @ 9.50 |
| Oct. 4, 2026 | issue | SO-261004-888 | MAIN | 4 | 9.50 | -38.01 | 217 | 2,062.15 | Sept. 5, 2026: 4 @ 9.50 |
| Sept. 22, 2026 | issue | SO-260922-317 | MAIN | 25 | 9.50 | -237.58 | 221 | 2,100.16 | Sept. 5, 2026: 25 @ 9.50 |
| Sept. 17, 2026 | issue | SO-260917-201 | EAST | 1 | 9.50 | -9.50 | 246 | 2,337.74 | Sept. 5, 2026: 1 @ 9.50 |
| Sept. 11, 2026 | issue | SO-260911-776 | MAIN | 14 | 9.50 | -133.04 | 247 | 2,347.24 | Sept. 5, 2026: 14 @ 9.50 |
| Sept. 9, 2026 | issue | SO-260909-879 | MAIN | 27 | 9.53 | -257.27 | 261 | 2,480.28 | April 21, 2026: 8 @ 9.59; Sept. 5, 2026: 19 @ 9.50 |
| Sept. 5, 2026 | transfer | TRF | MAIN → EAST | 87 | warehouse transfer, no cost effect | ||||
| Sept. 5, 2026 | receipt | PO-001775 | MAIN | 280 | 9.50 | 2,660.84 | 288 | 2,737.55 | |
| Aug. 29, 2026 | issue | SO-260829-352 | MAIN | 11 | 9.59 | -105.48 | 8 | 76.71 | April 21, 2026: 11 @ 9.59 |
| Aug. 29, 2026 | issue | SO-260829-352 | EAST | 33 | 9.59 | -316.44 | 19 | 182.19 | April 21, 2026: 33 @ 9.59 |
| Aug. 27, 2026 | issue | SO-260827-463 | MAIN | 7 | 9.59 | -67.12 | 52 | 498.64 | April 21, 2026: 7 @ 9.59 |
| Aug. 13, 2026 | issue | SO-260813-745 | EAST | 14 | 9.59 | -134.25 | 59 | 565.76 | April 21, 2026: 14 @ 9.59 |
| Aug. 1, 2026 | issue | SO-260801-424 | EAST | 4 | 9.59 | -38.36 | 73 | 700.01 | April 21, 2026: 4 @ 9.59 |
| July 28, 2026 | issue | SO-260728-148 | MAIN | 35 | 9.59 | -335.62 | 77 | 738.37 | April 21, 2026: 35 @ 9.59 |
| July 19, 2026 | issue | SO-260719-777 | MAIN | 11 | 9.59 | -105.48 | 112 | 1,073.99 | April 21, 2026: 11 @ 9.59 |
| July 16, 2026 | issue | SO-260716-312 | MAIN | 4 | 9.59 | -38.36 | 123 | 1,179.47 | April 21, 2026: 4 @ 9.59 |
| July 14, 2026 | issue | SO-260714-384 | MAIN | 4 | 9.59 | -38.36 | 127 | 1,217.83 | April 21, 2026: 4 @ 9.59 |
| July 4, 2026 | issue | SO-260704-357 | EAST | 12 | 9.59 | -115.07 | 131 | 1,256.19 | April 21, 2026: 12 @ 9.59 |
| June 11, 2026 | issue | SO-260611-134 | MAIN | 1 | 9.59 | -9.59 | 143 | 1,371.26 | April 21, 2026: 1 @ 9.59 |
| June 8, 2026 | issue | SO-260608-271 | MAIN | 49 | 9.59 | -469.87 | 144 | 1,380.84 | April 21, 2026: 49 @ 9.59 |
| June 5, 2026 | issue | SO-260605-874 | MAIN | 14 | 9.59 | -134.25 | 193 | 1,850.72 | April 21, 2026: 14 @ 9.59 |
| May 30, 2026 | issue | SO-260530-984 | MAIN | 22 | 9.59 | -210.96 | 207 | 1,984.96 | April 21, 2026: 22 @ 9.59 |
| May 21, 2026 | issue | SO-260521-167 | EAST | 1 | 9.59 | -9.59 | 229 | 2,195.93 | April 21, 2026: 1 @ 9.59 |
| May 17, 2026 | issue | SO-260517-625 | MAIN | 6 | 9.59 | -57.54 | 230 | 2,205.52 | April 21, 2026: 6 @ 9.59 |
| May 16, 2026 | issue | SO-260516-851 | EAST | 10 | 9.59 | -95.89 | 236 | 2,263.05 | April 21, 2026: 10 @ 9.59 |
| May 6, 2026 | issue | SO-260506-166 | EAST | 16 | 9.59 | -153.43 | 246 | 2,358.94 | April 21, 2026: 16 @ 9.59 |
| May 5, 2026 | issue | SO-260505-284 | MAIN | 13 | 9.59 | -124.66 | 262 | 2,512.37 | April 21, 2026: 13 @ 9.59 |
| April 22, 2026 | issue | SO-260422-904 | MAIN | 5 | 9.59 | -47.95 | 275 | 2,637.03 | April 21, 2026: 5 @ 9.59 |
| April 21, 2026 | transfer | TRF | MAIN → EAST | 90 | warehouse transfer, no cost effect | ||||
| April 21, 2026 | receipt | PO-001424 | MAIN | 280 | 9.59 | 2,684.98 | 280 | 2,684.98 | |
| April 17, 2026 | issue | SO-260417-240 | MAIN | 36 | 9.34 | -336.26 | 0 | 0.00 | Dec. 15, 2025: 36 @ 9.34 |
| April 11, 2026 | issue | SO-260411-797 | MAIN | 8 | 9.34 | -74.72 | 36 | 336.26 | Dec. 15, 2025: 8 @ 9.34 |
| April 6, 2026 | issue | SO-260406-443 | MAIN | 1 | 9.34 | -9.34 | 44 | 410.99 | Dec. 15, 2025: 1 @ 9.34 |
| April 2, 2026 | issue | SO-260402-762 | MAIN | 1 | 9.34 | -9.34 | 45 | 420.33 | Dec. 15, 2025: 1 @ 9.34 |
| April 1, 2026 | issue | SO-260401-932 | MAIN | 2 | 9.34 | -18.68 | 46 | 429.67 | Dec. 15, 2025: 2 @ 9.34 |
| March 30, 2026 | issue | SO-260330-184 | MAIN | 2 | 9.34 | -18.68 | 48 | 448.35 | Dec. 15, 2025: 2 @ 9.34 |
| March 16, 2026 | issue | SO-260316-739 | MAIN | 18 | 9.34 | -168.13 | 50 | 467.03 | Dec. 15, 2025: 18 @ 9.34 |
| March 15, 2026 | issue | SO-260315-221 | MAIN | 3 | 9.34 | -28.02 | 68 | 635.16 | Dec. 15, 2025: 3 @ 9.34 |
| March 12, 2026 | issue | SO-260312-990 | MAIN | 29 | 9.34 | -270.88 | 71 | 663.18 | Dec. 15, 2025: 29 @ 9.34 |
| March 1, 2026 | issue | SO-260301-309 | MAIN | 16 | 9.34 | -149.45 | 100 | 934.06 | Dec. 15, 2025: 16 @ 9.34 |
| Feb. 27, 2026 | issue | SO-260227-423 | MAIN | 28 | 9.34 | -261.54 | 116 | 1,083.51 | Dec. 15, 2025: 28 @ 9.34 |
| Feb. 13, 2026 | issue | SO-260213-505 | MAIN | 7 | 9.34 | -65.38 | 144 | 1,345.05 | Dec. 15, 2025: 7 @ 9.34 |
| Feb. 2, 2026 | issue | SO-260202-482 | MAIN | 18 | 9.34 | -168.13 | 151 | 1,410.43 | Dec. 15, 2025: 18 @ 9.34 |
| Feb. 1, 2026 | issue | SO-260201-824 | MAIN | 35 | 9.34 | -326.92 | 169 | 1,578.56 | Dec. 15, 2025: 35 @ 9.34 |
| Jan. 29, 2026 | issue | SO-260129-658 | MAIN | 6 | 9.34 | -56.04 | 204 | 1,905.48 | Dec. 15, 2025: 6 @ 9.34 |
| Jan. 28, 2026 | issue | SO-260128-556 | MAIN | 34 | 9.34 | -317.58 | 210 | 1,961.53 | Dec. 15, 2025: 34 @ 9.34 |
| Jan. 19, 2026 | issue | SO-260119-721 | MAIN | 31 | 9.34 | -289.56 | 244 | 2,279.11 | Dec. 15, 2025: 31 @ 9.34 |
| Dec. 22, 2025 | issue | SO-251222-209 | MAIN | 5 | 9.34 | -46.70 | 275 | 2,568.66 | Dec. 15, 2025: 5 @ 9.34 |
| Dec. 15, 2025 | receipt | PO-001053 | MAIN | 280 | 9.34 | 2,615.37 | 280 | 2,615.37 | |
| Dec. 4, 2025 | issue | SO-251204-410 | MAIN | 17 | 8.86 | -150.65 | 0 | 0.00 | Aug. 12, 2025: 13 @ 8.86; Oct. 26, 2025: 4 @ 8.86 |
| Dec. 2, 2025 | issue | SO-251202-643 | MAIN | 58 | 8.86 | -513.97 | 17 | 150.65 | Aug. 12, 2025: 58 @ 8.86 |
| Nov. 21, 2025 | issue | SO-251121-949 | MAIN | 3 | 8.86 | -26.58 | 75 | 664.62 | Aug. 12, 2025: 3 @ 8.86 |
| Nov. 14, 2025 | issue | SO-251114-753 | MAIN | 13 | 8.86 | -115.20 | 78 | 691.20 | Aug. 12, 2025: 13 @ 8.86 |
| Nov. 12, 2025 | issue | SO-251112-652 | MAIN | 12 | 8.86 | -106.34 | 91 | 806.41 | Aug. 12, 2025: 12 @ 8.86 |
| Nov. 6, 2025 | issue | SO-251106-808 | MAIN | 6 | 8.86 | -53.17 | 103 | 912.74 | Aug. 12, 2025: 6 @ 8.86 |
| Nov. 2, 2025 | issue | SO-251102-109 | MAIN | 4 | 8.86 | -35.45 | 109 | 965.91 | Aug. 12, 2025: 4 @ 8.86 |