Items / LED-0009
Street Light 90W Eco LED-0009 · Lighting · BrightLine Lighting
On hand (EA)0
Value (FIFO)0.00avg 0.00
ClassAX / FCV 0.39
Turnover20.1xlast issue 1 days ago
Days of cover0lead time 10d
Reorder suggested: 470 units (position at or below reorder point: order EOQ), stockout risk high.
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 | 122.08 / 30.4375 | 4.011 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 47.15 / 5.517 | 8.547 |
| 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 * 8.547^2 + 4.011^2 * 2.2^2) | 57.2 |
| Reorder point | d * LT + safety stock | 4.011 * 9.6 + 57.2 | 95.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 95.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1464/yr, S = 45.00, h = 20%, price = 85.53 | 87.8 |
| Inventory position | on hand + on order | 0 + 0 | 0 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 85.53 | 88 | 126,717 | yes (chosen if cheapest) |
MOQ 470, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| No stock. | ||||
Movement ledger 131 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-896 | EAST | 26 | 84.20 | -2,189.16 | 0 | 0.00 | June 8, 2026: 26 @ 84.20 |
| Oct. 14, 2026 | issue | SO-261014-342 | EAST | 19 | 84.20 | -1,599.77 | 26 | 2,189.16 | June 8, 2026: 19 @ 84.20 |
| Oct. 13, 2026 | issue | SO-261013-101 | EAST | 34 | 84.20 | -2,862.75 | 45 | 3,788.94 | June 8, 2026: 34 @ 84.20 |
| Oct. 9, 2026 | issue | SO-261009-894 | EAST | 1 | 84.20 | -84.20 | 79 | 6,651.69 | June 8, 2026: 1 @ 84.20 |
| Oct. 9, 2026 | issue | SO-261009-894 | MAIN | 1 | 84.20 | -84.20 | 80 | 6,735.89 | June 8, 2026: 1 @ 84.20 |
| Oct. 8, 2026 | issue | SO-261008-800 | MAIN | 11 | 84.20 | -926.18 | 81 | 6,820.09 | June 8, 2026: 11 @ 84.20 |
| Oct. 5, 2026 | issue | SO-261005-505 | MAIN | 17 | 84.20 | -1,431.38 | 92 | 7,746.27 | June 8, 2026: 17 @ 84.20 |
| Sept. 29, 2026 | issue | SO-260929-866 | EAST | 51 | 84.20 | -4,294.13 | 109 | 9,177.65 | June 8, 2026: 51 @ 84.20 |
| Sept. 19, 2026 | issue | SO-260919-625 | EAST | 8 | 84.20 | -673.59 | 160 | 13,471.78 | June 8, 2026: 8 @ 84.20 |
| Sept. 17, 2026 | issue | SO-260917-326 | MAIN | 15 | 84.20 | -1,262.98 | 168 | 14,145.36 | June 8, 2026: 15 @ 84.20 |
| Sept. 10, 2026 | issue | SO-260910-417 | MAIN | 28 | 84.20 | -2,357.56 | 183 | 15,408.34 | June 8, 2026: 28 @ 84.20 |
| Sept. 7, 2026 | issue | SO-260907-423 | MAIN | 27 | 84.20 | -2,273.36 | 211 | 17,765.90 | June 8, 2026: 27 @ 84.20 |
| Aug. 29, 2026 | issue | SO-260829-751 | MAIN | 10 | 84.20 | -841.99 | 238 | 20,039.27 | June 8, 2026: 10 @ 84.20 |
| Aug. 23, 2026 | issue | SO-260823-641 | MAIN | 38 | 84.20 | -3,199.55 | 248 | 20,881.25 | June 8, 2026: 38 @ 84.20 |
| Aug. 22, 2026 | issue | SO-260822-851 | MAIN | 23 | 84.20 | -1,936.57 | 286 | 24,080.80 | June 8, 2026: 23 @ 84.20 |
| Aug. 1, 2026 | issue | SO-260801-699 | MAIN | 23 | 84.20 | -1,936.57 | 309 | 26,017.37 | June 8, 2026: 23 @ 84.20 |
| July 29, 2026 | issue | SO-260729-829 | MAIN | 3 | 84.20 | -252.60 | 332 | 27,953.94 | June 8, 2026: 3 @ 84.20 |
| July 24, 2026 | issue | SO-260724-420 | MAIN | 53 | 84.20 | -4,462.53 | 335 | 28,206.53 | June 8, 2026: 53 @ 84.20 |
| July 23, 2026 | issue | SO-260723-351 | MAIN | 19 | 84.20 | -1,599.77 | 388 | 32,669.06 | June 8, 2026: 19 @ 84.20 |
| July 15, 2026 | issue | SO-260715-301 | MAIN | 56 | 84.20 | -4,715.12 | 407 | 34,268.83 | June 8, 2026: 56 @ 84.20 |
| June 9, 2026 | issue | SO-260609-810 | MAIN | 7 | 84.20 | -589.39 | 463 | 38,983.95 | June 8, 2026: 7 @ 84.20 |
| June 8, 2026 | transfer | TRF | MAIN → EAST | 139 | warehouse transfer, no cost effect | ||||
| June 8, 2026 | receipt | PO-001558 | MAIN | 470 | 84.20 | 39,573.34 | 470 | 39,573.34 | |
| June 3, 2026 | issue | SO-260603-936 | MAIN | 52 | 84.66 | -4,402.24 | 0 | 0.00 | Jan. 19, 2026: 52 @ 84.66 |
| May 31, 2026 | issue | SO-260531-905 | MAIN | 24 | 84.66 | -2,031.80 | 52 | 4,402.24 | Jan. 19, 2026: 24 @ 84.66 |
| May 17, 2026 | issue | SO-260517-698 | MAIN | 5 | 84.66 | -423.29 | 76 | 6,434.04 | Jan. 19, 2026: 5 @ 84.66 |
| May 10, 2026 | issue | SO-260510-629 | MAIN | 14 | 84.66 | -1,185.22 | 81 | 6,857.33 | Jan. 19, 2026: 14 @ 84.66 |
| May 9, 2026 | issue | SO-260509-968 | MAIN | 2 | 84.66 | -169.32 | 95 | 8,042.55 | Jan. 19, 2026: 2 @ 84.66 |
| May 1, 2026 | issue | SO-260501-870 | MAIN | 20 | 84.66 | -1,693.17 | 97 | 8,211.86 | Jan. 19, 2026: 20 @ 84.66 |
| April 28, 2026 | issue | SO-260428-389 | MAIN | 5 | 84.66 | -423.29 | 117 | 9,905.03 | Jan. 19, 2026: 5 @ 84.66 |
| April 25, 2026 | issue | SO-260425-288 | MAIN | 5 | 84.66 | -423.29 | 122 | 10,328.32 | Jan. 19, 2026: 5 @ 84.66 |
| April 22, 2026 | issue | SO-260422-623 | MAIN | 2 | 84.66 | -169.32 | 127 | 10,751.62 | Jan. 19, 2026: 2 @ 84.66 |
| April 18, 2026 | issue | SO-260418-510 | MAIN | 29 | 84.66 | -2,455.09 | 129 | 10,920.93 | Jan. 19, 2026: 29 @ 84.66 |
| April 13, 2026 | issue | SO-260413-514 | MAIN | 17 | 84.66 | -1,439.19 | 158 | 13,376.03 | Jan. 19, 2026: 17 @ 84.66 |
| April 12, 2026 | issue | SO-260412-380 | MAIN | 29 | 84.66 | -2,455.09 | 175 | 14,815.22 | Jan. 19, 2026: 29 @ 84.66 |
| April 7, 2026 | issue | SO-260407-410 | MAIN | 6 | 84.66 | -507.95 | 204 | 17,270.31 | Jan. 19, 2026: 6 @ 84.66 |
| March 30, 2026 | issue | SO-260330-375 | MAIN | 4 | 84.66 | -338.63 | 210 | 17,778.26 | Jan. 19, 2026: 4 @ 84.66 |
| March 30, 2026 | issue | SO-260330-375 | EAST | 4 | 84.66 | -338.63 | 214 | 18,116.90 | Jan. 19, 2026: 4 @ 84.66 |
| March 21, 2026 | issue | SO-260321-308 | EAST | 38 | 84.66 | -3,217.02 | 218 | 18,455.53 | Jan. 19, 2026: 38 @ 84.66 |
| March 9, 2026 | issue | SO-260309-792 | EAST | 11 | 84.66 | -931.24 | 256 | 21,672.55 | Jan. 19, 2026: 11 @ 84.66 |
| March 3, 2026 | issue | SO-260303-846 | EAST | 34 | 84.66 | -2,878.39 | 267 | 22,603.79 | Jan. 19, 2026: 34 @ 84.66 |
| Feb. 28, 2026 | issue | SO-260228-189 | MAIN | 4 | 84.66 | -338.63 | 301 | 25,482.18 | Jan. 19, 2026: 4 @ 84.66 |
| Feb. 25, 2026 | issue | SO-260225-364 | MAIN | 26 | 84.66 | -2,201.12 | 305 | 25,820.81 | Jan. 19, 2026: 26 @ 84.66 |
| Feb. 23, 2026 | issue | SO-260223-465 | MAIN | 76 | 84.66 | -6,434.04 | 331 | 28,021.93 | Jan. 19, 2026: 76 @ 84.66 |
| Feb. 12, 2026 | issue | SO-260212-688 | MAIN | 17 | 84.66 | -1,439.19 | 407 | 34,455.97 | Jan. 19, 2026: 17 @ 84.66 |
| Feb. 4, 2026 | issue | SO-260204-376 | EAST | 9 | 84.66 | -761.93 | 424 | 35,895.16 | Jan. 19, 2026: 9 @ 84.66 |
| Jan. 21, 2026 | issue | SO-260121-207 | EAST | 37 | 84.66 | -3,132.36 | 433 | 36,657.09 | Jan. 19, 2026: 37 @ 84.66 |
| Jan. 19, 2026 | transfer | TRF | MAIN → EAST | 133 | warehouse transfer, no cost effect | ||||
| Jan. 19, 2026 | receipt | PO-001158 | MAIN | 470 | 84.66 | 39,789.45 | 470 | 39,789.45 | |
| Jan. 17, 2026 | issue | SO-260117-213 | MAIN | 73 | 82.83 | -6,046.85 | 0 | 0.00 | Oct. 31, 2025: 73 @ 82.83 |
| Jan. 13, 2026 | issue | SO-260113-600 | MAIN | 69 | 82.83 | -5,715.51 | 73 | 6,046.85 | Oct. 31, 2025: 69 @ 82.83 |
| Dec. 26, 2025 | issue | SO-251226-491 | MAIN | 9 | 82.83 | -745.50 | 142 | 11,762.36 | Oct. 31, 2025: 9 @ 82.83 |
| Dec. 23, 2025 | issue | SO-251223-932 | MAIN | 14 | 82.83 | -1,159.67 | 151 | 12,507.86 | Oct. 31, 2025: 14 @ 82.83 |
| Dec. 22, 2025 | issue | SO-251222-754 | MAIN | 13 | 82.83 | -1,076.84 | 165 | 13,667.53 | Oct. 31, 2025: 13 @ 82.83 |
| Dec. 17, 2025 | issue | SO-251217-110 | MAIN | 15 | 82.83 | -1,242.50 | 178 | 14,744.36 | Oct. 31, 2025: 15 @ 82.83 |
| Dec. 10, 2025 | issue | SO-251210-989 | MAIN | 44 | 82.83 | -3,644.67 | 193 | 15,986.87 | Oct. 31, 2025: 44 @ 82.83 |
| Dec. 4, 2025 | issue | SO-251204-409 | MAIN | 23 | 82.83 | -1,905.17 | 237 | 19,631.54 | Oct. 31, 2025: 23 @ 82.83 |
| Dec. 2, 2025 | issue | SO-251202-696 | MAIN | 90 | 82.83 | -7,455.02 | 260 | 21,536.71 | Oct. 31, 2025: 90 @ 82.83 |
| Nov. 12, 2025 | issue | SO-251112-623 | MAIN | 1 | 82.83 | -82.83 | 350 | 28,991.72 | Oct. 31, 2025: 1 @ 82.83 |
| Nov. 11, 2025 | issue | SO-251111-517 | MAIN | 58 | 82.83 | -4,804.34 | 351 | 29,074.56 | Oct. 31, 2025: 58 @ 82.83 |