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
| 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 |
| Oct. 7, 2025 | adjustment | Cycle count | MAIN | -2 | 11.76 | -23.52 | 188 | 2,210.56 | Sept. 21, 2025: 2 @ 11.76 |
| Oct. 7, 2025 | issue | SO-251007-662 | MAIN | 17 | 11.72 | -199.24 | 190 | 2,234.08 | April 20, 2025: 7 @ 11.67; Sept. 21, 2025: 10 @ 11.76 |
| Oct. 5, 2025 | issue | SO-251005-370 | MAIN | 1 | 11.67 | -11.67 | 207 | 2,433.32 | April 20, 2025: 1 @ 11.67 |
| Sept. 29, 2025 | issue | SO-250929-785 | MAIN | 6 | 11.67 | -70.00 | 208 | 2,444.99 | April 20, 2025: 6 @ 11.67 |
| Sept. 27, 2025 | issue | SO-250927-658 | MAIN | 6 | 11.67 | -70.00 | 214 | 2,514.98 | April 20, 2025: 6 @ 11.67 |
| Sept. 21, 2025 | transfer | TRF | MAIN → EAST | 53 | warehouse transfer, no cost effect | ||||
| Sept. 21, 2025 | receipt | PO-000861 | MAIN | 200 | 11.76 | 2,351.66 | 220 | 2,584.98 | |
| Sept. 12, 2025 | issue | SO-250912-706 | MAIN | 9 | 11.67 | -104.99 | 20 | 233.32 | April 20, 2025: 9 @ 11.67 |
| Sept. 7, 2025 | issue | SO-250907-604 | MAIN | 29 | 11.67 | -338.31 | 29 | 338.31 | April 20, 2025: 29 @ 11.67 |
| Aug. 31, 2025 | issue | SO-250831-935 | MAIN | 30 | 11.67 | -349.98 | 58 | 676.63 | April 20, 2025: 30 @ 11.67 |
| Aug. 30, 2025 | issue | SO-250830-285 | MAIN | 1 | 11.67 | -11.67 | 88 | 1,026.61 | April 20, 2025: 1 @ 11.67 |
| Aug. 28, 2025 | issue | SO-250828-738 | MAIN | 2 | 11.67 | -23.33 | 89 | 1,038.27 | April 20, 2025: 2 @ 11.67 |
| July 25, 2025 | issue | SO-250725-321 | MAIN | 22 | 11.67 | -256.65 | 91 | 1,061.61 | April 20, 2025: 22 @ 11.67 |
| July 18, 2025 | issue | SO-250718-759 | MAIN | 4 | 11.67 | -46.66 | 113 | 1,318.26 | April 20, 2025: 4 @ 11.67 |
| July 8, 2025 | issue | SO-250708-142 | MAIN | 1 | 11.67 | -11.67 | 117 | 1,364.92 | April 20, 2025: 1 @ 11.67 |
| June 21, 2025 | issue | SO-250621-173 | MAIN | 20 | 11.67 | -233.32 | 118 | 1,376.59 | April 20, 2025: 20 @ 11.67 |
| June 12, 2025 | issue | SO-250612-836 | MAIN | 2 | 11.67 | -23.33 | 138 | 1,609.91 | April 20, 2025: 2 @ 11.67 |
| June 4, 2025 | issue | SO-250604-908 | MAIN | 20 | 11.67 | -233.32 | 140 | 1,633.24 | April 20, 2025: 20 @ 11.67 |
| May 30, 2025 | issue | SO-250530-776 | MAIN | 3 | 11.67 | -35.00 | 160 | 1,866.56 | April 20, 2025: 3 @ 11.67 |
| May 24, 2025 | issue | SO-250524-504 | MAIN | 10 | 11.67 | -116.66 | 163 | 1,901.56 | April 20, 2025: 10 @ 11.67 |
| May 15, 2025 | issue | SO-250515-645 | MAIN | 1 | 11.67 | -11.67 | 173 | 2,018.22 | April 20, 2025: 1 @ 11.67 |
| May 1, 2025 | issue | SO-250501-745 | MAIN | 29 | 11.66 | -338.06 | 174 | 2,029.88 | March 23, 2025: 3 @ 11.58; April 20, 2025: 26 @ 11.67 |
| April 20, 2025 | receipt | PO-000464 | MAIN | 200 | 11.67 | 2,333.20 | 203 | 2,367.94 | |
| April 16, 2025 | issue | SO-250416-666 | MAIN | 6 | 11.58 | -69.49 | 3 | 34.74 | Dec. 9, 2024: 5 @ 11.58; March 23, 2025: 1 @ 11.58 |
| April 14, 2025 | issue | SO-250414-554 | MAIN | 3 | 11.58 | -34.74 | 9 | 104.23 | Dec. 9, 2024: 3 @ 11.58 |
| April 12, 2025 | issue | SO-250412-295 | MAIN | 22 | 11.58 | -254.78 | 12 | 138.97 | Dec. 9, 2024: 22 @ 11.58 |
| April 11, 2025 | issue | SO-250411-545 | EAST | 11 | 11.58 | -127.39 | 34 | 393.75 | Dec. 9, 2024: 11 @ 11.58 |
| April 7, 2025 | issue | SO-250407-381 | EAST | 2 | 11.58 | -23.16 | 45 | 521.14 | Dec. 9, 2024: 2 @ 11.58 |
| March 23, 2025 | return | RMA | MAIN | 4 | 11.58 | 46.32 | 47 | 544.31 | |
| March 18, 2025 | issue | SO-250318-448 | MAIN | 4 | 11.58 | -46.32 | 43 | 497.98 | Dec. 9, 2024: 4 @ 11.58 |
| March 12, 2025 | issue | SO-250312-422 | EAST | 8 | 11.58 | -92.65 | 47 | 544.31 | Dec. 9, 2024: 8 @ 11.58 |
| March 11, 2025 | issue | SO-250311-848 | MAIN | 33 | 11.58 | -382.17 | 55 | 636.96 | Dec. 9, 2024: 33 @ 11.58 |
| Feb. 22, 2025 | issue | SO-250222-960 | MAIN | 9 | 11.58 | -104.23 | 88 | 1,019.13 | Dec. 9, 2024: 9 @ 11.58 |
| Feb. 15, 2025 | issue | SO-250215-640 | MAIN | 26 | 11.58 | -301.11 | 97 | 1,123.36 | Dec. 9, 2024: 26 @ 11.58 |
| Feb. 5, 2025 | issue | SO-250205-841 | EAST | 13 | 11.58 | -150.55 | 123 | 1,424.46 | Dec. 9, 2024: 13 @ 11.58 |
| Jan. 16, 2025 | issue | SO-250116-936 | MAIN | 3 | 11.58 | -34.74 | 136 | 1,575.02 | Dec. 9, 2024: 3 @ 11.58 |
| Jan. 11, 2025 | issue | SO-250111-699 | MAIN | 21 | 11.58 | -243.20 | 139 | 1,609.76 | Dec. 9, 2024: 21 @ 11.58 |
| Jan. 10, 2025 | issue | SO-250110-205 | EAST | 3 | 11.58 | -34.74 | 160 | 1,852.96 | Dec. 9, 2024: 3 @ 11.58 |
| Jan. 8, 2025 | issue | SO-250108-222 | MAIN | 22 | 11.58 | -254.78 | 163 | 1,887.70 | Dec. 9, 2024: 22 @ 11.58 |
| Jan. 3, 2025 | issue | SO-250103-738 | EAST | 19 | 11.61 | -220.57 | 185 | 2,142.48 | Nov. 16, 2024: 4 @ 11.71; Dec. 9, 2024: 15 @ 11.58 |
| Dec. 20, 2024 | issue | SO-241220-648 | EAST | 11 | 11.71 | -128.85 | 204 | 2,363.05 | Nov. 16, 2024: 11 @ 11.71 |
| Dec. 19, 2024 | adjustment | Cycle count | MAIN | -1 | 11.71 | -11.71 | 215 | 2,491.90 | Nov. 16, 2024: 1 @ 11.71 |
| Dec. 9, 2024 | transfer | TRF | MAIN → EAST | 67 | warehouse transfer, no cost effect | ||||
| Dec. 9, 2024 | receipt | PO-000086 | MAIN | 200 | 11.58 | 2,316.20 | 216 | 2,503.62 | |
| Dec. 1, 2024 | issue | SO-241201-116 | MAIN | 52 | 11.71 | -609.10 | 16 | 187.42 | Oct. 1, 2024: 41 @ 11.71; Nov. 16, 2024: 11 @ 11.71 |
| Nov. 16, 2024 | return | RMA | MAIN | 27 | 11.71 | 316.26 | 68 | 796.52 | |
| Nov. 10, 2024 | issue | SO-241110-817 | MAIN | 23 | 11.71 | -269.41 | 41 | 480.25 | Oct. 1, 2024: 23 @ 11.71 |
| Nov. 2, 2024 | issue | SO-241102-172 | MAIN | 55 | 11.71 | -644.24 | 64 | 749.66 | Oct. 1, 2024: 55 @ 11.71 |
| Oct. 26, 2024 | issue | SO-241026-722 | MAIN | 5 | 11.71 | -58.57 | 119 | 1,393.91 | Oct. 1, 2024: 5 @ 11.71 |
| Oct. 19, 2024 | issue | SO-241019-348 | MAIN | 1 | 11.71 | -11.71 | 124 | 1,452.47 | Oct. 1, 2024: 1 @ 11.71 |
| Oct. 18, 2024 | issue | SO-241018-398 | MAIN | 6 | 11.71 | -70.28 | 125 | 1,464.19 | Oct. 1, 2024: 6 @ 11.71 |
| Oct. 15, 2024 | issue | SO-241015-895 | MAIN | 55 | 11.71 | -644.24 | 131 | 1,534.47 | Oct. 1, 2024: 55 @ 11.71 |
| Oct. 9, 2024 | issue | SO-241009-789 | MAIN | 14 | 11.71 | -163.99 | 186 | 2,178.71 | Oct. 1, 2024: 14 @ 11.71 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 200 | 11.71 | 2,342.70 | 200 | 2,342.70 | |