Items / LED-0038
Street Light 90W Prime LED-0038 · Lighting · BrightLine Lighting
On hand (EA)75MAIN 75
Value (FIFO)11,828.20avg 157.71
ClassAX / FCV 0.27
Turnover6.1xlast issue 7 days ago
Days of cover57lead 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 | 40.17 / 30.4375 | 1.320 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 10.98 / 5.517 | 1.991 |
| 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 * 1.991^2 + 1.320^2 * 2.2^2) | 13.9 |
| Reorder point | d * LT + safety stock | 1.320 * 9.6 + 13.9 | 26.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 26.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 482/yr, S = 45.00, h = 20%, price = 160.07 | 36.8 |
| Inventory position | on hand + on order | 75 + 0 | 75 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 160.07 | 37 | 78,279 | yes (chosen if cheapest) |
| 320 | 153.67 | 320 | 79,002 | yes |
| 640 | 147.26 | 640 | 80,392 | yes |
MOQ 160, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 23, 2026 | 75 / 160 | 157.71 | 11,828.20 |
Movement ledger 118 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 9, 2026 | issue | SO-261009-698 | MAIN | 1 | 157.71 | -157.71 | 75 | 11,828.20 | Aug. 23, 2026: 1 @ 157.71 |
| Oct. 9, 2026 | issue | SO-261009-698 | EAST | 8 | 157.71 | -1,261.68 | 76 | 11,985.91 | Aug. 23, 2026: 8 @ 157.71 |
| Oct. 7, 2026 | issue | SO-261007-777 | MAIN | 21 | 157.71 | -3,311.90 | 84 | 13,247.59 | Aug. 23, 2026: 21 @ 157.71 |
| Oct. 5, 2026 | issue | SO-261005-377 | MAIN | 4 | 157.71 | -630.84 | 105 | 16,559.49 | Aug. 23, 2026: 4 @ 157.71 |
| Oct. 2, 2026 | issue | SO-261002-326 | EAST | 5 | 157.71 | -788.55 | 109 | 17,190.32 | Aug. 23, 2026: 5 @ 157.71 |
| Oct. 1, 2026 | issue | SO-261001-648 | EAST | 15 | 157.71 | -2,365.64 | 114 | 17,978.87 | Aug. 23, 2026: 15 @ 157.71 |
| Sept. 25, 2026 | issue | SO-260925-413 | EAST | 4 | 157.71 | -630.84 | 129 | 20,344.51 | Aug. 23, 2026: 4 @ 157.71 |
| Sept. 15, 2026 | issue | SO-260915-154 | MAIN | 2 | 157.71 | -315.42 | 133 | 20,975.35 | Aug. 23, 2026: 2 @ 157.71 |
| Sept. 14, 2026 | issue | SO-260914-832 | MAIN | 13 | 157.71 | -2,050.22 | 135 | 21,290.77 | Aug. 23, 2026: 13 @ 157.71 |
| Sept. 13, 2026 | issue | SO-260913-523 | EAST | 3 | 157.71 | -473.13 | 148 | 23,340.99 | Aug. 23, 2026: 3 @ 157.71 |
| Sept. 4, 2026 | issue | SO-260904-357 | MAIN | 12 | 157.49 | -1,889.88 | 151 | 23,814.12 | July 18, 2026: 3 @ 156.83; Aug. 23, 2026: 9 @ 157.71 |
| Aug. 23, 2026 | transfer | TRF | MAIN → EAST | 35 | warehouse transfer, no cost effect | ||||
| Aug. 23, 2026 | receipt | PO-001737 | MAIN | 160 | 157.71 | 25,233.50 | 163 | 25,703.99 | |
| Aug. 22, 2026 | issue | SO-260822-555 | MAIN | 12 | 156.83 | -1,881.96 | 3 | 470.49 | March 24, 2026: 6 @ 156.83; July 18, 2026: 6 @ 156.83 |
| Aug. 11, 2026 | issue | SO-260811-266 | MAIN | 6 | 156.83 | -940.98 | 15 | 2,352.45 | March 24, 2026: 6 @ 156.83 |
| Aug. 9, 2026 | issue | SO-260809-553 | MAIN | 1 | 156.83 | -156.83 | 21 | 3,293.44 | March 24, 2026: 1 @ 156.83 |
| Aug. 3, 2026 | issue | SO-260803-267 | MAIN | 8 | 156.83 | -1,254.64 | 22 | 3,450.27 | March 24, 2026: 8 @ 156.83 |
| July 18, 2026 | return | RMA | MAIN | 9 | 156.83 | 1,411.47 | 30 | 4,704.91 | |
| July 10, 2026 | issue | SO-260710-782 | MAIN | 14 | 156.83 | -2,195.62 | 21 | 3,293.44 | March 24, 2026: 14 @ 156.83 |
| July 7, 2026 | issue | SO-260707-620 | MAIN | 18 | 156.83 | -2,822.95 | 35 | 5,489.06 | March 24, 2026: 18 @ 156.83 |
| June 17, 2026 | issue | SO-260617-228 | MAIN | 4 | 156.83 | -627.32 | 53 | 8,312.01 | March 24, 2026: 4 @ 156.83 |
| June 13, 2026 | issue | SO-260613-933 | MAIN | 4 | 156.83 | -627.32 | 57 | 8,939.33 | March 24, 2026: 4 @ 156.83 |
| June 10, 2026 | issue | SO-260610-507 | MAIN | 1 | 156.83 | -156.83 | 61 | 9,566.65 | March 24, 2026: 1 @ 156.83 |
| June 8, 2026 | issue | SO-260608-944 | MAIN | 11 | 156.83 | -1,725.13 | 62 | 9,723.48 | March 24, 2026: 11 @ 156.83 |
| June 6, 2026 | issue | SO-260606-731 | MAIN | 1 | 156.83 | -156.83 | 73 | 11,448.61 | March 24, 2026: 1 @ 156.83 |
| June 2, 2026 | issue | SO-260602-454 | MAIN | 13 | 156.83 | -2,038.79 | 74 | 11,605.44 | March 24, 2026: 13 @ 156.83 |
| May 19, 2026 | issue | SO-260519-353 | MAIN | 13 | 156.83 | -2,038.79 | 87 | 13,644.24 | March 24, 2026: 13 @ 156.83 |
| May 19, 2026 | issue | SO-260519-353 | EAST | 21 | 156.83 | -3,293.44 | 100 | 15,683.03 | March 24, 2026: 21 @ 156.83 |
| May 17, 2026 | issue | SO-260517-758 | MAIN | 2 | 156.83 | -313.66 | 121 | 18,976.47 | March 24, 2026: 2 @ 156.83 |
| May 13, 2026 | issue | SO-260513-739 | MAIN | 2 | 156.83 | -313.66 | 123 | 19,290.13 | March 24, 2026: 2 @ 156.83 |
| May 1, 2026 | issue | SO-260501-210 | EAST | 4 | 156.83 | -627.32 | 125 | 19,603.79 | March 24, 2026: 4 @ 156.83 |
| April 28, 2026 | issue | SO-260428-973 | MAIN | 21 | 156.83 | -3,293.44 | 129 | 20,231.11 | March 24, 2026: 21 @ 156.83 |
| April 27, 2026 | issue | SO-260427-520 | MAIN | 1 | 156.83 | -156.83 | 150 | 23,524.54 | March 24, 2026: 1 @ 156.83 |
| April 14, 2026 | issue | SO-260414-769 | MAIN | 9 | 156.83 | -1,411.47 | 151 | 23,681.38 | March 24, 2026: 9 @ 156.83 |
| April 13, 2026 | issue | SO-260413-702 | MAIN | 2 | 158.76 | -317.52 | 160 | 25,092.85 | Dec. 2, 2025: 2 @ 158.76 |
| April 2, 2026 | issue | SO-260402-121 | EAST | 1 | 158.76 | -158.76 | 162 | 25,410.36 | Dec. 2, 2025: 1 @ 158.76 |
| March 31, 2026 | issue | SO-260331-173 | EAST | 6 | 158.76 | -952.55 | 163 | 25,569.12 | Dec. 2, 2025: 6 @ 158.76 |
| March 24, 2026 | transfer | TRF | MAIN → EAST | 32 | warehouse transfer, no cost effect | ||||
| March 24, 2026 | receipt | PO-001346 | MAIN | 160 | 156.83 | 25,092.85 | 169 | 26,521.67 | |
| March 16, 2026 | issue | SO-260316-240 | MAIN | 22 | 158.76 | -3,492.68 | 9 | 1,428.82 | Dec. 2, 2025: 22 @ 158.76 |
| March 9, 2026 | issue | SO-260309-116 | MAIN | 13 | 158.76 | -2,063.85 | 31 | 4,921.50 | Dec. 2, 2025: 13 @ 158.76 |
| March 2, 2026 | issue | SO-260302-272 | MAIN | 6 | 158.76 | -952.55 | 44 | 6,985.35 | Dec. 2, 2025: 6 @ 158.76 |
| Feb. 28, 2026 | issue | SO-260228-845 | MAIN | 8 | 158.76 | -1,270.06 | 50 | 7,937.90 | Dec. 2, 2025: 8 @ 158.76 |
| Feb. 14, 2026 | issue | SO-260214-917 | MAIN | 25 | 158.76 | -3,968.95 | 58 | 9,207.96 | Dec. 2, 2025: 25 @ 158.76 |
| Jan. 19, 2026 | issue | SO-260119-758 | MAIN | 5 | 158.76 | -793.79 | 83 | 13,176.91 | Dec. 2, 2025: 5 @ 158.76 |
| Jan. 18, 2026 | issue | SO-260118-880 | MAIN | 9 | 158.76 | -1,428.82 | 88 | 13,970.70 | Dec. 2, 2025: 9 @ 158.76 |
| Jan. 13, 2026 | issue | SO-260113-944 | MAIN | 7 | 158.76 | -1,111.31 | 97 | 15,399.53 | Dec. 2, 2025: 7 @ 158.76 |
| Jan. 6, 2026 | issue | SO-260106-694 | MAIN | 29 | 158.76 | -4,603.98 | 104 | 16,510.83 | Dec. 2, 2025: 29 @ 158.76 |
| Jan. 5, 2026 | issue | SO-260105-788 | MAIN | 3 | 158.76 | -476.27 | 133 | 21,114.81 | Dec. 2, 2025: 3 @ 158.76 |
| Dec. 18, 2025 | issue | SO-251218-775 | MAIN | 3 | 158.76 | -476.27 | 136 | 21,591.09 | Dec. 2, 2025: 3 @ 158.76 |
| Dec. 6, 2025 | issue | SO-251206-405 | MAIN | 1 | 158.76 | -158.76 | 139 | 22,067.36 | Dec. 2, 2025: 1 @ 158.76 |
| Dec. 2, 2025 | issue | SO-251202-224 | MAIN | 37 | 154.07 | -5,700.57 | 140 | 22,226.12 | Aug. 31, 2025: 17 @ 148.55; Dec. 2, 2025: 20 @ 158.76 |
| Dec. 2, 2025 | receipt | PO-001030 | MAIN | 160 | 158.76 | 25,401.28 | 177 | 27,926.69 | |
| Nov. 22, 2025 | issue | SO-251122-264 | MAIN | 18 | 148.55 | -2,673.96 | 17 | 2,525.41 | Aug. 31, 2025: 18 @ 148.55 |
| Nov. 17, 2025 | issue | SO-251117-752 | MAIN | 1 | 148.55 | -148.55 | 35 | 5,199.37 | Aug. 31, 2025: 1 @ 148.55 |
| Nov. 14, 2025 | issue | SO-251114-422 | MAIN | 3 | 148.55 | -445.66 | 36 | 5,347.92 | Aug. 31, 2025: 3 @ 148.55 |
| Nov. 6, 2025 | issue | SO-251106-203 | MAIN | 7 | 148.55 | -1,039.87 | 39 | 5,793.58 | Aug. 31, 2025: 7 @ 148.55 |
| Nov. 1, 2025 | issue | SO-251101-308 | MAIN | 24 | 148.55 | -3,565.28 | 46 | 6,833.46 | Aug. 31, 2025: 24 @ 148.55 |
| Oct. 28, 2025 | issue | SO-251028-851 | MAIN | 27 | 148.55 | -4,010.94 | 70 | 10,398.74 | Aug. 31, 2025: 27 @ 148.55 |
| Oct. 28, 2025 | issue | SO-251028-851 | EAST | 2 | 148.55 | -297.11 | 97 | 14,409.68 | Aug. 31, 2025: 2 @ 148.55 |