Items / LED-0006
Street Light 90W Lite LED-0006 · Lighting · BrightLine Lighting
On hand (EA)91MAIN 82, EAST 9
Value (FIFO)1,108.42avg 12.18
ClassCX / FCV 0.32
Turnover5.3xlast issue 5 days ago
Days of cover51lead 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 | 54.50 / 30.4375 | 1.791 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 17.50 / 5.517 | 3.171 |
| 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 * 3.171^2 + 1.791^2 * 2.2^2) | 13.5 |
| Reorder point | d * LT + safety stock | 1.791 * 9.6 + 13.5 | 30.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 30.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 654/yr, S = 45.00, h = 20%, price = 11.84 | 400.0 |
| Inventory position | on hand + on order | 91 + 0 | 91 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 12.33 | 154 | 8,439 | yes |
| 400 | 11.84 | 400 | 8,283 | yes (chosen if cheapest) |
| 800 | 11.34 | 800 | 8,358 | yes |
MOQ 200, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 24, 2026 | 91 / 200 | 12.18 | 1,108.42 |
Movement ledger 114 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 11, 2026 | issue | SO-261011-671 | MAIN | 23 | 12.18 | -280.15 | 91 | 1,108.42 | Aug. 24, 2026: 23 @ 12.18 |
| Oct. 6, 2026 | issue | SO-261006-169 | MAIN | 4 | 12.18 | -48.72 | 114 | 1,388.57 | Aug. 24, 2026: 4 @ 12.18 |
| Oct. 3, 2026 | issue | SO-261003-418 | MAIN | 34 | 12.18 | -414.13 | 118 | 1,437.29 | Aug. 24, 2026: 34 @ 12.18 |
| Sept. 25, 2026 | issue | SO-260925-439 | MAIN | 26 | 12.18 | -316.69 | 152 | 1,851.42 | Aug. 24, 2026: 26 @ 12.18 |
| Sept. 16, 2026 | issue | SO-260916-910 | MAIN | 4 | 12.18 | -48.72 | 178 | 2,168.11 | Aug. 24, 2026: 4 @ 12.18 |
| Sept. 11, 2026 | issue | SO-260911-485 | MAIN | 12 | 12.18 | -146.16 | 182 | 2,216.83 | Aug. 24, 2026: 12 @ 12.18 |
| Sept. 8, 2026 | issue | SO-260908-796 | MAIN | 15 | 12.28 | -184.27 | 194 | 2,363.00 | May 7, 2026: 9 @ 12.35; Aug. 24, 2026: 6 @ 12.18 |
| Aug. 30, 2026 | issue | SO-260830-148 | MAIN | 4 | 12.35 | -49.42 | 209 | 2,547.27 | May 7, 2026: 4 @ 12.35 |
| Aug. 25, 2026 | issue | SO-260825-278 | MAIN | 11 | 12.35 | -135.89 | 213 | 2,596.68 | April 9, 2026: 8 @ 12.35; May 7, 2026: 3 @ 12.35 |
| Aug. 24, 2026 | issue | SO-260824-560 | MAIN | 1 | 12.35 | -12.35 | 224 | 2,732.57 | April 9, 2026: 1 @ 12.35 |
| Aug. 24, 2026 | receipt | PO-001743 | MAIN | 200 | 12.18 | 2,436.08 | 225 | 2,744.93 | |
| Aug. 15, 2026 | issue | SO-260815-941 | MAIN | 4 | 12.35 | -49.42 | 25 | 308.85 | April 9, 2026: 4 @ 12.35 |
| Aug. 12, 2026 | issue | SO-260812-310 | MAIN | 3 | 12.35 | -37.06 | 29 | 358.26 | April 9, 2026: 3 @ 12.35 |
| Aug. 11, 2026 | issue | SO-260811-320 | MAIN | 12 | 12.35 | -148.25 | 32 | 395.32 | April 9, 2026: 12 @ 12.35 |
| Aug. 3, 2026 | issue | SO-260803-673 | MAIN | 1 | 12.35 | -12.35 | 44 | 543.57 | April 9, 2026: 1 @ 12.35 |
| July 30, 2026 | issue | SO-260730-934 | MAIN | 5 | 12.35 | -61.77 | 45 | 555.93 | April 9, 2026: 5 @ 12.35 |
| July 28, 2026 | issue | SO-260728-969 | MAIN | 18 | 12.35 | -222.37 | 50 | 617.70 | April 9, 2026: 18 @ 12.35 |
| July 27, 2026 | issue | SO-260727-936 | MAIN | 9 | 12.35 | -111.19 | 68 | 840.07 | April 9, 2026: 9 @ 12.35 |
| July 9, 2026 | issue | SO-260709-113 | EAST | 2 | 12.35 | -24.71 | 77 | 951.25 | April 9, 2026: 2 @ 12.35 |
| July 2, 2026 | issue | SO-260702-645 | MAIN | 2 | 12.35 | -24.71 | 79 | 975.96 | April 9, 2026: 2 @ 12.35 |
| June 28, 2026 | issue | SO-260628-560 | MAIN | 12 | 12.35 | -148.25 | 81 | 1,000.67 | April 9, 2026: 12 @ 12.35 |
| June 17, 2026 | issue | SO-260617-490 | MAIN | 13 | 12.35 | -160.60 | 93 | 1,148.91 | April 9, 2026: 13 @ 12.35 |
| June 14, 2026 | issue | SO-260614-936 | MAIN | 24 | 12.35 | -296.49 | 106 | 1,309.51 | April 9, 2026: 24 @ 12.35 |
| June 3, 2026 | issue | SO-260603-106 | MAIN | 3 | 12.35 | -37.06 | 130 | 1,606.01 | April 9, 2026: 3 @ 12.35 |
| May 28, 2026 | issue | SO-260528-518 | MAIN | 5 | 12.35 | -61.77 | 133 | 1,643.07 | April 9, 2026: 5 @ 12.35 |
| May 15, 2026 | issue | SO-260515-180 | MAIN | 9 | 12.35 | -111.19 | 138 | 1,704.84 | April 9, 2026: 9 @ 12.35 |
| May 7, 2026 | return | RMA | MAIN | 16 | 12.35 | 197.66 | 147 | 1,816.02 | |
| May 5, 2026 | issue | SO-260505-169 | MAIN | 6 | 12.35 | -74.12 | 131 | 1,618.36 | April 9, 2026: 6 @ 12.35 |
| May 2, 2026 | issue | SO-260502-570 | MAIN | 19 | 12.35 | -234.72 | 137 | 1,692.48 | April 9, 2026: 19 @ 12.35 |
| April 25, 2026 | issue | SO-260425-714 | EAST | 32 | 12.35 | -395.32 | 156 | 1,927.21 | April 9, 2026: 32 @ 12.35 |
| April 22, 2026 | issue | SO-260422-809 | EAST | 12 | 12.35 | -148.25 | 188 | 2,322.53 | April 9, 2026: 12 @ 12.35 |
| April 9, 2026 | transfer | TRF | MAIN → EAST | 55 | warehouse transfer, no cost effect | ||||
| April 9, 2026 | receipt | PO-001394 | MAIN | 200 | 12.35 | 2,470.78 | 200 | 2,470.78 | |
| March 31, 2026 | issue | SO-260331-595 | MAIN | 31 | 11.62 | -360.31 | 0 | 0.00 | Dec. 24, 2025: 29 @ 11.61; Jan. 5, 2026: 2 @ 11.76 |
| March 10, 2026 | issue | SO-260310-759 | MAIN | 22 | 11.61 | -255.50 | 31 | 360.31 | Dec. 24, 2025: 22 @ 11.61 |
| March 3, 2026 | issue | SO-260303-156 | MAIN | 12 | 11.61 | -139.36 | 53 | 615.81 | Dec. 24, 2025: 12 @ 11.61 |
| Feb. 23, 2026 | issue | SO-260223-675 | MAIN | 7 | 11.61 | -81.29 | 65 | 755.17 | Dec. 24, 2025: 7 @ 11.61 |
| Feb. 22, 2026 | issue | SO-260222-633 | MAIN | 2 | 11.61 | -23.23 | 72 | 836.46 | Dec. 24, 2025: 2 @ 11.61 |
| Feb. 17, 2026 | issue | SO-260217-233 | MAIN | 33 | 11.61 | -383.25 | 74 | 859.69 | Dec. 24, 2025: 33 @ 11.61 |
| Feb. 16, 2026 | issue | SO-260216-475 | MAIN | 9 | 11.61 | -104.52 | 107 | 1,242.93 | Dec. 24, 2025: 9 @ 11.61 |
| Feb. 8, 2026 | issue | SO-260208-493 | MAIN | 17 | 11.61 | -197.43 | 116 | 1,347.46 | Dec. 24, 2025: 17 @ 11.61 |
| Feb. 5, 2026 | issue | SO-260205-428 | MAIN | 3 | 11.61 | -34.84 | 133 | 1,544.89 | Dec. 24, 2025: 3 @ 11.61 |
| Feb. 2, 2026 | issue | SO-260202-687 | MAIN | 1 | 11.61 | -11.61 | 136 | 1,579.73 | Dec. 24, 2025: 1 @ 11.61 |
| Jan. 28, 2026 | issue | SO-260128-265 | MAIN | 2 | 11.61 | -23.23 | 137 | 1,591.34 | Dec. 24, 2025: 2 @ 11.61 |
| Jan. 26, 2026 | issue | SO-260126-770 | MAIN | 36 | 11.61 | -418.09 | 139 | 1,614.57 | Dec. 24, 2025: 36 @ 11.61 |
| Jan. 16, 2026 | issue | SO-260116-417 | MAIN | 26 | 11.61 | -301.95 | 175 | 2,032.65 | Dec. 24, 2025: 26 @ 11.61 |
| Jan. 12, 2026 | issue | SO-260112-816 | MAIN | 6 | 11.73 | -70.40 | 201 | 2,334.60 | Nov. 13, 2025: 5 @ 11.76; Dec. 24, 2025: 1 @ 11.61 |
| Jan. 5, 2026 | return | RMA | MAIN | 2 | 11.76 | 23.52 | 207 | 2,405.01 | |
| Dec. 24, 2025 | issue | SO-251224-233 | MAIN | 4 | 11.76 | -47.03 | 205 | 2,381.49 | Sept. 21, 2025: 1 @ 11.76; Nov. 13, 2025: 3 @ 11.76 |
| Dec. 24, 2025 | receipt | PO-001078 | MAIN | 200 | 11.61 | 2,322.70 | 209 | 2,428.52 | |
| Dec. 15, 2025 | issue | SO-251215-820 | MAIN | 46 | 11.76 | -540.88 | 9 | 105.82 | Sept. 21, 2025: 46 @ 11.76 |
| Dec. 15, 2025 | issue | SO-251215-820 | EAST | 26 | 11.76 | -305.72 | 55 | 646.71 | Sept. 21, 2025: 26 @ 11.76 |
| Nov. 30, 2025 | issue | SO-251130-515 | MAIN | 22 | 11.76 | -258.68 | 81 | 952.42 | Sept. 21, 2025: 22 @ 11.76 |
| Nov. 27, 2025 | issue | SO-251127-961 | MAIN | 9 | 11.76 | -105.82 | 103 | 1,211.10 | Sept. 21, 2025: 9 @ 11.76 |
| Nov. 26, 2025 | issue | SO-251126-187 | EAST | 11 | 11.76 | -129.34 | 112 | 1,316.93 | Sept. 21, 2025: 11 @ 11.76 |
| Nov. 13, 2025 | return | RMA | MAIN | 8 | 11.76 | 94.07 | 123 | 1,446.27 | |
| Nov. 10, 2025 | issue | SO-251110-333 | MAIN | 30 | 11.76 | -352.75 | 115 | 1,352.20 | Sept. 21, 2025: 30 @ 11.76 |
| Nov. 3, 2025 | issue | SO-251103-762 | MAIN | 17 | 11.76 | -199.89 | 145 | 1,704.95 | Sept. 21, 2025: 17 @ 11.76 |
| Oct. 30, 2025 | issue | SO-251030-810 | EAST | 16 | 11.76 | -188.13 | 162 | 1,904.84 | Sept. 21, 2025: 16 @ 11.76 |
| Oct. 9, 2025 | issue | SO-251009-205 | MAIN | 10 | 11.76 | -117.58 | 178 | 2,092.98 | Sept. 21, 2025: 10 @ 11.76 |