Items / LED-0007
Street Light 90W Pro LED-0007 · Lighting · BrightLine Lighting
On hand (EA)185MAIN 185
Value (FIFO)28,798.37avg 155.67
ClassAX / FCV 0.27
Turnover4.3xlast issue 12 days ago
Days of cover88lead 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 | 63.75 / 30.4375 | 2.094 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 17.22 / 5.517 | 3.121 |
| 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 * 3.121^2 + 2.094^2 * 2.2^2) | 21.9 |
| Reorder point | d * LT + safety stock | 2.094 * 9.6 + 21.9 | 42.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 42.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 764/yr, S = 45.00, h = 20%, price = 152.47 | 47.5 |
| Inventory position | on hand + on order | 185 + 0 | 185 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 152.47 | 48 | 118,008 | yes (chosen if cheapest) |
MOQ 260, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 27, 2026 | 179 / 260 | 155.77 | 27,882.51 | |
| Sept. 12, 2026 | 6 / 6 | 152.64 | 915.86 |
Movement ledger 130 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 4, 2026 | issue | SO-261004-341 | MAIN | 2 | 155.77 | -311.54 | 185 | 28,798.37 | Aug. 27, 2026: 2 @ 155.77 |
| Oct. 3, 2026 | issue | SO-261003-426 | MAIN | 53 | 155.77 | -8,255.71 | 187 | 29,109.91 | Aug. 27, 2026: 53 @ 155.77 |
| Sept. 25, 2026 | issue | SO-260925-755 | MAIN | 12 | 155.77 | -1,869.22 | 240 | 37,365.62 | Aug. 27, 2026: 12 @ 155.77 |
| Sept. 21, 2026 | issue | SO-260921-874 | MAIN | 4 | 155.77 | -623.07 | 252 | 39,234.84 | Aug. 27, 2026: 4 @ 155.77 |
| Sept. 13, 2026 | issue | SO-260913-181 | MAIN | 9 | 155.77 | -1,401.91 | 256 | 39,857.91 | Aug. 27, 2026: 9 @ 155.77 |
| Sept. 12, 2026 | return | RMA | MAIN | 6 | 152.64 | 915.86 | 265 | 41,259.83 | |
| Sept. 12, 2026 | issue | SO-260912-563 | MAIN | 2 | 152.64 | -305.29 | 259 | 40,343.96 | April 22, 2026: 1 @ 149.52; Aug. 27, 2026: 1 @ 155.77 |
| Sept. 8, 2026 | issue | SO-260908-540 | MAIN | 4 | 149.52 | -598.08 | 261 | 40,649.25 | April 22, 2026: 4 @ 149.52 |
| Sept. 6, 2026 | issue | SO-260906-943 | MAIN | 13 | 149.52 | -1,943.75 | 265 | 41,247.33 | April 22, 2026: 13 @ 149.52 |
| Aug. 29, 2026 | issue | SO-260829-953 | MAIN | 12 | 149.52 | -1,794.23 | 278 | 43,191.08 | April 22, 2026: 12 @ 149.52 |
| Aug. 27, 2026 | receipt | PO-001750 | MAIN | 260 | 155.77 | 40,499.73 | 290 | 44,985.30 | |
| Aug. 22, 2026 | issue | SO-260822-581 | MAIN | 1 | 149.52 | -149.52 | 30 | 4,485.57 | April 22, 2026: 1 @ 149.52 |
| Aug. 15, 2026 | issue | SO-260815-105 | MAIN | 5 | 149.52 | -747.60 | 31 | 4,635.09 | April 22, 2026: 5 @ 149.52 |
| Aug. 11, 2026 | issue | SO-260811-572 | MAIN | 2 | 149.52 | -299.04 | 36 | 5,382.69 | April 22, 2026: 2 @ 149.52 |
| Aug. 9, 2026 | issue | SO-260809-615 | MAIN | 28 | 149.52 | -4,186.53 | 38 | 5,681.73 | April 22, 2026: 28 @ 149.52 |
| Aug. 6, 2026 | issue | SO-260806-702 | MAIN | 1 | 149.52 | -149.52 | 66 | 9,868.26 | April 22, 2026: 1 @ 149.52 |
| July 17, 2026 | issue | SO-260717-663 | MAIN | 1 | 149.52 | -149.52 | 67 | 10,017.78 | April 22, 2026: 1 @ 149.52 |
| July 15, 2026 | issue | SO-260715-159 | MAIN | 14 | 149.52 | -2,093.27 | 68 | 10,167.30 | April 22, 2026: 14 @ 149.52 |
| July 13, 2026 | issue | SO-260713-414 | MAIN | 24 | 149.52 | -3,588.46 | 82 | 12,260.57 | April 22, 2026: 24 @ 149.52 |
| July 9, 2026 | issue | SO-260709-925 | MAIN | 3 | 149.52 | -448.56 | 106 | 15,849.02 | April 22, 2026: 3 @ 149.52 |
| July 3, 2026 | issue | SO-260703-899 | MAIN | 1 | 149.52 | -149.52 | 109 | 16,297.58 | April 22, 2026: 1 @ 149.52 |
| July 1, 2026 | issue | SO-260701-827 | MAIN | 6 | 149.52 | -897.11 | 110 | 16,447.10 | April 22, 2026: 6 @ 149.52 |
| June 20, 2026 | issue | SO-260620-646 | MAIN | 16 | 149.52 | -2,392.31 | 116 | 17,344.22 | April 22, 2026: 16 @ 149.52 |
| June 11, 2026 | issue | SO-260611-203 | MAIN | 36 | 149.52 | -5,382.69 | 132 | 19,736.52 | April 22, 2026: 36 @ 149.52 |
| June 2, 2026 | issue | SO-260602-552 | MAIN | 11 | 149.52 | -1,644.71 | 168 | 25,119.21 | April 22, 2026: 11 @ 149.52 |
| May 26, 2026 | issue | SO-260526-393 | MAIN | 4 | 149.52 | -598.08 | 179 | 26,763.92 | April 22, 2026: 4 @ 149.52 |
| May 17, 2026 | issue | SO-260517-660 | MAIN | 24 | 149.52 | -3,588.46 | 183 | 27,362.00 | April 22, 2026: 24 @ 149.52 |
| May 10, 2026 | issue | SO-260510-723 | MAIN | 1 | 149.52 | -149.52 | 207 | 30,950.45 | April 22, 2026: 1 @ 149.52 |
| May 5, 2026 | issue | SO-260505-749 | MAIN | 21 | 149.52 | -3,139.90 | 208 | 31,099.97 | April 22, 2026: 21 @ 149.52 |
| April 22, 2026 | issue | SO-260422-381 | MAIN | 31 | 149.52 | -4,635.09 | 229 | 34,239.87 | April 22, 2026: 31 @ 149.52 |
| April 22, 2026 | receipt | PO-001429 | MAIN | 260 | 149.52 | 38,874.97 | 260 | 38,874.97 | |
| April 14, 2026 | issue | SO-260414-687 | MAIN | 42 | 146.67 | -6,160.30 | 0 | 0.00 | Jan. 1, 2026: 38 @ 146.67; Feb. 11, 2026: 4 @ 146.67 |
| April 14, 2026 | issue | SO-260414-687 | EAST | 6 | 146.67 | -880.04 | 42 | 6,160.30 | Jan. 1, 2026: 6 @ 146.67 |
| April 7, 2026 | adjustment | Cycle count | MAIN | -2 | 146.67 | -293.35 | 48 | 7,040.34 | Jan. 1, 2026: 2 @ 146.67 |
| March 29, 2026 | issue | SO-260329-240 | MAIN | 4 | 146.67 | -586.70 | 50 | 7,333.69 | Jan. 1, 2026: 4 @ 146.67 |
| March 16, 2026 | issue | SO-260316-330 | MAIN | 30 | 146.67 | -4,400.21 | 54 | 7,920.39 | Jan. 1, 2026: 30 @ 146.67 |
| March 7, 2026 | issue | SO-260307-533 | EAST | 15 | 146.67 | -2,200.11 | 84 | 12,320.60 | Jan. 1, 2026: 15 @ 146.67 |
| Feb. 21, 2026 | issue | SO-260221-367 | MAIN | 56 | 146.67 | -8,213.73 | 99 | 14,520.71 | Jan. 1, 2026: 56 @ 146.67 |
| Feb. 17, 2026 | issue | SO-260217-681 | MAIN | 1 | 146.67 | -146.67 | 155 | 22,734.44 | Jan. 1, 2026: 1 @ 146.67 |
| Feb. 12, 2026 | issue | SO-260212-434 | MAIN | 7 | 146.67 | -1,026.72 | 156 | 22,881.11 | Jan. 1, 2026: 7 @ 146.67 |
| Feb. 11, 2026 | return | RMA | MAIN | 4 | 146.67 | 586.70 | 163 | 23,907.83 | |
| Feb. 8, 2026 | issue | SO-260208-677 | EAST | 31 | 146.67 | -4,546.89 | 159 | 23,321.13 | Jan. 1, 2026: 31 @ 146.67 |
| Feb. 5, 2026 | issue | SO-260205-996 | MAIN | 4 | 146.67 | -586.70 | 190 | 27,868.02 | Jan. 1, 2026: 4 @ 146.67 |
| Feb. 4, 2026 | adjustment | Cycle count | MAIN | -1 | 146.67 | -146.67 | 194 | 28,454.72 | Jan. 1, 2026: 1 @ 146.67 |
| Jan. 30, 2026 | issue | SO-260130-990 | EAST | 9 | 146.67 | -1,320.06 | 195 | 28,601.39 | Jan. 1, 2026: 9 @ 146.67 |
| Jan. 29, 2026 | issue | SO-260129-151 | MAIN | 2 | 146.67 | -293.35 | 204 | 29,921.46 | Jan. 1, 2026: 2 @ 146.67 |
| Jan. 28, 2026 | issue | SO-260128-173 | MAIN | 9 | 146.67 | -1,320.06 | 206 | 30,214.80 | Jan. 1, 2026: 9 @ 146.67 |
| Jan. 22, 2026 | issue | SO-260122-803 | MAIN | 14 | 146.67 | -2,053.43 | 215 | 31,534.87 | Jan. 1, 2026: 14 @ 146.67 |
| Jan. 13, 2026 | issue | SO-260113-166 | EAST | 24 | 146.67 | -3,520.17 | 229 | 33,588.30 | Jan. 1, 2026: 24 @ 146.67 |
| Jan. 11, 2026 | issue | SO-260111-898 | MAIN | 8 | 146.89 | -1,175.13 | 253 | 37,108.47 | Nov. 27, 2025: 1 @ 148.41; Jan. 1, 2026: 7 @ 146.67 |
| Jan. 6, 2026 | issue | SO-260106-348 | MAIN | 2 | 148.41 | -296.82 | 261 | 38,283.60 | Nov. 27, 2025: 2 @ 148.41 |
| Jan. 1, 2026 | transfer | TRF | MAIN → EAST | 85 | warehouse transfer, no cost effect | ||||
| Jan. 1, 2026 | receipt | PO-001109 | MAIN | 260 | 146.67 | 38,135.19 | 263 | 38,580.42 | |
| Dec. 31, 2025 | issue | SO-251231-967 | MAIN | 20 | 148.41 | -2,968.22 | 3 | 445.23 | Sept. 3, 2025: 1 @ 148.41; Oct. 9, 2025: 5 @ 148.41; Nov. 27, 2025: 14 @ 148.41 |
| Dec. 29, 2025 | issue | SO-251229-768 | MAIN | 5 | 148.41 | -742.06 | 23 | 3,413.46 | Sept. 3, 2025: 5 @ 148.41 |
| Dec. 22, 2025 | issue | SO-251222-672 | MAIN | 11 | 148.41 | -1,632.52 | 28 | 4,155.51 | Sept. 3, 2025: 11 @ 148.41 |
| Dec. 21, 2025 | issue | SO-251221-602 | MAIN | 11 | 148.41 | -1,632.52 | 39 | 5,788.04 | Sept. 3, 2025: 11 @ 148.41 |
| Dec. 18, 2025 | issue | SO-251218-601 | MAIN | 16 | 148.41 | -2,374.58 | 50 | 7,420.56 | Sept. 3, 2025: 16 @ 148.41 |
| Dec. 9, 2025 | issue | SO-251209-170 | MAIN | 11 | 148.41 | -1,632.52 | 66 | 9,795.14 | Sept. 3, 2025: 11 @ 148.41 |
| Dec. 2, 2025 | issue | SO-251202-142 | MAIN | 7 | 148.41 | -1,038.88 | 77 | 11,427.66 | Sept. 3, 2025: 7 @ 148.41 |