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
| 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 |
| Oct. 16, 2025 | issue | SO-251016-699 | EAST | 2 | 148.55 | -297.11 | 99 | 14,706.79 | Aug. 31, 2025: 2 @ 148.55 |
| Oct. 12, 2025 | issue | SO-251012-106 | MAIN | 4 | 148.55 | -594.21 | 101 | 15,003.89 | Aug. 31, 2025: 4 @ 148.55 |
| Oct. 5, 2025 | issue | SO-251005-452 | MAIN | 9 | 148.55 | -1,336.98 | 105 | 15,598.11 | Aug. 31, 2025: 9 @ 148.55 |
| Oct. 2, 2025 | issue | SO-251002-463 | MAIN | 15 | 148.55 | -2,228.30 | 114 | 16,935.09 | Aug. 31, 2025: 15 @ 148.55 |
| Oct. 1, 2025 | issue | SO-251001-345 | MAIN | 2 | 148.55 | -297.11 | 129 | 19,163.39 | Aug. 31, 2025: 2 @ 148.55 |
| Sept. 30, 2025 | issue | SO-250930-910 | MAIN | 5 | 148.55 | -742.77 | 131 | 19,460.50 | Aug. 31, 2025: 5 @ 148.55 |
| Sept. 29, 2025 | issue | SO-250929-179 | MAIN | 6 | 148.55 | -891.32 | 136 | 20,203.26 | Aug. 31, 2025: 6 @ 148.55 |
| Sept. 28, 2025 | issue | SO-250928-745 | EAST | 26 | 149.44 | -3,885.35 | 142 | 21,094.58 | April 23, 2025: 8 @ 151.42; Aug. 31, 2025: 18 @ 148.55 |
| Sept. 25, 2025 | issue | SO-250925-504 | EAST | 8 | 151.42 | -1,211.39 | 168 | 24,979.94 | April 23, 2025: 8 @ 151.42 |
| Sept. 16, 2025 | issue | SO-250916-849 | MAIN | 1 | 151.42 | -151.42 | 176 | 26,191.33 | April 23, 2025: 1 @ 151.42 |
| Sept. 13, 2025 | issue | SO-250913-346 | EAST | 2 | 151.42 | -302.85 | 177 | 26,342.76 | April 23, 2025: 2 @ 151.42 |
| Sept. 10, 2025 | issue | SO-250910-248 | MAIN | 1 | 151.42 | -151.42 | 179 | 26,645.60 | April 23, 2025: 1 @ 151.42 |
| Aug. 31, 2025 | transfer | TRF | MAIN → EAST | 40 | warehouse transfer, no cost effect | ||||
| Aug. 31, 2025 | receipt | PO-000807 | MAIN | 160 | 148.55 | 23,768.54 | 180 | 26,797.03 | |
| Aug. 21, 2025 | issue | SO-250821-288 | MAIN | 5 | 151.42 | -757.12 | 20 | 3,028.48 | April 23, 2025: 5 @ 151.42 |
| Aug. 20, 2025 | issue | SO-250820-390 | MAIN | 3 | 151.42 | -454.27 | 25 | 3,785.60 | April 23, 2025: 3 @ 151.42 |
| Aug. 6, 2025 | issue | SO-250806-393 | MAIN | 12 | 151.42 | -1,817.09 | 28 | 4,239.88 | April 23, 2025: 12 @ 151.42 |
| Aug. 6, 2025 | issue | SO-250806-393 | EAST | 6 | 151.42 | -908.55 | 40 | 6,056.97 | April 23, 2025: 6 @ 151.42 |
| Aug. 3, 2025 | issue | SO-250803-890 | MAIN | 1 | 151.42 | -151.42 | 46 | 6,965.51 | April 23, 2025: 1 @ 151.42 |
| July 22, 2025 | issue | SO-250722-592 | MAIN | 23 | 151.42 | -3,482.76 | 47 | 7,116.94 | April 23, 2025: 23 @ 151.42 |
| July 16, 2025 | issue | SO-250716-242 | EAST | 7 | 151.42 | -1,059.97 | 70 | 10,599.69 | April 23, 2025: 7 @ 151.42 |
| June 4, 2025 | issue | SO-250604-362 | EAST | 19 | 151.42 | -2,877.06 | 77 | 11,659.66 | April 23, 2025: 19 @ 151.42 |
| June 1, 2025 | issue | SO-250601-433 | MAIN | 20 | 151.42 | -3,028.48 | 96 | 14,536.72 | April 23, 2025: 20 @ 151.42 |
| May 20, 2025 | issue | SO-250520-847 | MAIN | 6 | 151.42 | -908.55 | 116 | 17,565.21 | April 23, 2025: 6 @ 151.42 |
| May 4, 2025 | issue | SO-250504-728 | MAIN | 24 | 151.42 | -3,634.18 | 122 | 18,473.75 | April 23, 2025: 24 @ 151.42 |
| April 26, 2025 | issue | SO-250426-347 | MAIN | 7 | 151.42 | -1,059.97 | 146 | 22,107.93 | April 23, 2025: 7 @ 151.42 |
| April 24, 2025 | issue | SO-250424-855 | EAST | 11 | 150.32 | -1,653.52 | 153 | 23,167.90 | Dec. 22, 2024: 4 @ 148.39; April 23, 2025: 7 @ 151.42 |
| April 23, 2025 | transfer | TRF | MAIN → EAST | 43 | warehouse transfer, no cost effect | ||||
| April 23, 2025 | receipt | PO-000475 | MAIN | 160 | 151.42 | 24,227.87 | 164 | 24,821.42 | |
| April 21, 2025 | issue | SO-250421-540 | MAIN | 2 | 148.39 | -296.78 | 4 | 593.55 | Dec. 22, 2024: 2 @ 148.39 |
| April 21, 2025 | issue | SO-250421-540 | EAST | 7 | 148.39 | -1,038.71 | 6 | 890.33 | Dec. 22, 2024: 7 @ 148.39 |
| April 14, 2025 | issue | SO-250414-420 | MAIN | 19 | 148.39 | -2,819.37 | 13 | 1,929.04 | Dec. 22, 2024: 19 @ 148.39 |
| April 10, 2025 | issue | SO-250410-997 | MAIN | 10 | 148.39 | -1,483.88 | 32 | 4,748.41 | Dec. 22, 2024: 10 @ 148.39 |
| March 21, 2025 | issue | SO-250321-785 | EAST | 1 | 148.39 | -148.39 | 42 | 6,232.28 | Dec. 22, 2024: 1 @ 148.39 |
| March 13, 2025 | issue | SO-250313-614 | MAIN | 21 | 148.39 | -3,116.14 | 43 | 6,380.67 | Dec. 22, 2024: 21 @ 148.39 |
| March 11, 2025 | issue | SO-250311-390 | MAIN | 23 | 148.39 | -3,412.92 | 64 | 9,496.81 | Dec. 22, 2024: 23 @ 148.39 |
| Feb. 3, 2025 | issue | SO-250203-902 | EAST | 1 | 148.39 | -148.39 | 87 | 12,909.73 | Dec. 22, 2024: 1 @ 148.39 |
| Feb. 1, 2025 | issue | SO-250201-358 | MAIN | 35 | 148.39 | -5,193.57 | 88 | 13,058.12 | Dec. 22, 2024: 35 @ 148.39 |
| Jan. 22, 2025 | issue | SO-250122-888 | MAIN | 12 | 148.39 | -1,780.65 | 123 | 18,251.69 | Dec. 22, 2024: 12 @ 148.39 |
| Jan. 18, 2025 | issue | SO-250118-405 | EAST | 27 | 148.66 | -4,013.83 | 135 | 20,032.34 | Oct. 1, 2024: 2 @ 152.07; Dec. 22, 2024: 25 @ 148.39 |
| Jan. 5, 2025 | issue | SO-250105-545 | MAIN | 10 | 152.07 | -1,520.66 | 162 | 24,046.16 | Oct. 1, 2024: 10 @ 152.07 |
| Jan. 3, 2025 | issue | SO-250103-244 | MAIN | 4 | 152.07 | -608.27 | 172 | 25,566.83 | Oct. 1, 2024: 4 @ 152.07 |
| Dec. 22, 2024 | transfer | TRF | MAIN → EAST | 36 | warehouse transfer, no cost effect | ||||
| Dec. 22, 2024 | receipt | PO-000126 | MAIN | 160 | 148.39 | 23,742.03 | 176 | 26,175.10 | |
| Dec. 21, 2024 | issue | SO-241221-260 | MAIN | 6 | 152.07 | -912.40 | 16 | 2,433.06 | Oct. 1, 2024: 6 @ 152.07 |
| Dec. 20, 2024 | issue | SO-241220-106 | MAIN | 8 | 152.07 | -1,216.53 | 22 | 3,345.46 | Oct. 1, 2024: 8 @ 152.07 |
| Dec. 11, 2024 | issue | SO-241211-127 | MAIN | 24 | 152.07 | -3,649.60 | 30 | 4,562.00 | Oct. 1, 2024: 24 @ 152.07 |
| Dec. 7, 2024 | issue | SO-241207-551 | MAIN | 5 | 152.07 | -760.33 | 54 | 8,211.59 | Oct. 1, 2024: 5 @ 152.07 |
| Dec. 5, 2024 | issue | SO-241205-995 | MAIN | 3 | 152.07 | -456.20 | 59 | 8,971.92 | Oct. 1, 2024: 3 @ 152.07 |
| Dec. 1, 2024 | issue | SO-241201-390 | MAIN | 6 | 152.07 | -912.40 | 62 | 9,428.12 | Oct. 1, 2024: 6 @ 152.07 |
| Nov. 27, 2024 | issue | SO-241127-243 | MAIN | 9 | 152.07 | -1,368.60 | 68 | 10,340.52 | Oct. 1, 2024: 9 @ 152.07 |
| Nov. 24, 2024 | issue | SO-241124-361 | MAIN | 8 | 152.07 | -1,216.53 | 77 | 11,709.12 | Oct. 1, 2024: 8 @ 152.07 |
| Nov. 20, 2024 | issue | SO-241120-700 | MAIN | 8 | 152.07 | -1,216.53 | 85 | 12,925.65 | Oct. 1, 2024: 8 @ 152.07 |
| Nov. 9, 2024 | issue | SO-241109-666 | MAIN | 12 | 152.07 | -1,824.80 | 93 | 14,142.18 | Oct. 1, 2024: 12 @ 152.07 |
| Nov. 8, 2024 | issue | SO-241108-660 | MAIN | 8 | 152.07 | -1,216.53 | 105 | 15,966.98 | Oct. 1, 2024: 8 @ 152.07 |
| Oct. 27, 2024 | issue | SO-241027-226 | MAIN | 33 | 152.07 | -5,018.19 | 113 | 17,183.51 | Oct. 1, 2024: 33 @ 152.07 |
| Oct. 25, 2024 | issue | SO-241025-538 | MAIN | 14 | 152.07 | -2,128.93 | 146 | 22,201.71 | Oct. 1, 2024: 14 @ 152.07 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 160 | 152.07 | 24,330.64 | 160 | 24,330.64 | |