Items / LED-0013
Downlight 7W Eco LED-0013 · Lighting · BrightLine Lighting
On hand (EA)72MAIN 72
Value (FIFO)726.29avg 10.09
ClassCX / FCV 0.26
Turnover10.1xlast issue 7 days ago
Days of cover53lead 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 | 41.42 / 30.4375 | 1.361 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 10.62 / 5.517 | 1.925 |
| 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 * 1.925^2 + 1.361^2 * 2.2^2) | 8.5 |
| Reorder point | d * LT + safety stock | 1.361 * 9.6 + 8.5 | 21.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 21.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 497/yr, S = 45.00, h = 20%, price = 10.47 | 146.1 |
| Inventory position | on hand + on order | 72 + 0 | 72 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 10.47 | 146 | 5,506 | yes (chosen if cheapest) |
MOQ 190, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 23, 2026 | 71 / 190 | 10.09 | 716.21 | |
| Oct. 6, 2026 | 1 / 1 | 10.09 | 10.09 |
Movement ledger 106 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 9, 2026 | issue | SO-261009-845 | MAIN | 35 | 10.09 | -353.06 | 72 | 726.29 | July 23, 2026: 35 @ 10.09 |
| Oct. 8, 2026 | issue | SO-261008-879 | MAIN | 8 | 10.09 | -80.70 | 107 | 1,079.35 | July 23, 2026: 8 @ 10.09 |
| Oct. 6, 2026 | return | RMA | MAIN | 1 | 10.09 | 10.09 | 115 | 1,160.05 | |
| Sept. 22, 2026 | issue | SO-260922-297 | MAIN | 9 | 10.09 | -90.79 | 114 | 1,149.96 | July 23, 2026: 9 @ 10.09 |
| Sept. 18, 2026 | issue | SO-260918-116 | MAIN | 13 | 10.09 | -131.14 | 123 | 1,240.75 | July 23, 2026: 13 @ 10.09 |
| Sept. 16, 2026 | issue | SO-260916-179 | MAIN | 1 | 10.09 | -10.09 | 136 | 1,371.89 | July 23, 2026: 1 @ 10.09 |
| Sept. 12, 2026 | issue | SO-260912-434 | MAIN | 10 | 10.09 | -100.87 | 137 | 1,381.97 | July 23, 2026: 10 @ 10.09 |
| Aug. 30, 2026 | issue | SO-260830-769 | MAIN | 20 | 10.09 | -201.75 | 147 | 1,482.85 | July 23, 2026: 20 @ 10.09 |
| Aug. 15, 2026 | issue | SO-260815-932 | MAIN | 13 | 10.09 | -131.14 | 167 | 1,684.60 | July 23, 2026: 13 @ 10.09 |
| Aug. 8, 2026 | issue | SO-260808-708 | MAIN | 17 | 10.16 | -172.66 | 180 | 1,815.73 | March 26, 2026: 7 @ 10.26; July 23, 2026: 10 @ 10.09 |
| July 23, 2026 | receipt | PO-001663 | MAIN | 190 | 10.09 | 1,916.61 | 197 | 1,988.40 | |
| July 17, 2026 | issue | SO-260717-434 | MAIN | 15 | 10.26 | -153.83 | 7 | 71.79 | Feb. 7, 2026: 2 @ 10.26; March 26, 2026: 13 @ 10.26 |
| July 3, 2026 | issue | SO-260703-166 | MAIN | 12 | 10.26 | -123.07 | 22 | 225.62 | Feb. 7, 2026: 12 @ 10.26 |
| July 1, 2026 | issue | SO-260701-130 | MAIN | 1 | 10.26 | -10.26 | 34 | 348.69 | Feb. 7, 2026: 1 @ 10.26 |
| June 25, 2026 | issue | SO-260625-588 | MAIN | 4 | 10.26 | -41.02 | 35 | 358.95 | Feb. 7, 2026: 4 @ 10.26 |
| June 18, 2026 | issue | SO-260618-730 | MAIN | 1 | 10.26 | -10.26 | 39 | 399.97 | Feb. 7, 2026: 1 @ 10.26 |
| June 12, 2026 | issue | SO-260612-736 | MAIN | 3 | 10.26 | -30.77 | 40 | 410.22 | Feb. 7, 2026: 3 @ 10.26 |
| June 11, 2026 | issue | SO-260611-970 | MAIN | 5 | 10.26 | -51.28 | 43 | 440.99 | Feb. 7, 2026: 5 @ 10.26 |
| June 5, 2026 | issue | SO-260605-782 | MAIN | 4 | 10.26 | -41.02 | 48 | 492.27 | Feb. 7, 2026: 4 @ 10.26 |
| May 28, 2026 | issue | SO-260528-899 | MAIN | 15 | 10.26 | -153.83 | 52 | 533.29 | Feb. 7, 2026: 15 @ 10.26 |
| May 26, 2026 | issue | SO-260526-716 | MAIN | 2 | 10.26 | -20.51 | 67 | 687.13 | Feb. 7, 2026: 2 @ 10.26 |
| May 20, 2026 | issue | SO-260520-277 | MAIN | 20 | 10.26 | -205.11 | 69 | 707.64 | Feb. 7, 2026: 20 @ 10.26 |
| May 17, 2026 | issue | SO-260517-205 | MAIN | 1 | 10.26 | -10.26 | 89 | 912.75 | Feb. 7, 2026: 1 @ 10.26 |
| May 16, 2026 | issue | SO-260516-807 | MAIN | 3 | 10.26 | -30.77 | 90 | 923.00 | Feb. 7, 2026: 3 @ 10.26 |
| May 15, 2026 | issue | SO-260515-617 | MAIN | 1 | 10.26 | -10.26 | 93 | 953.77 | Feb. 7, 2026: 1 @ 10.26 |
| May 4, 2026 | issue | SO-260504-634 | MAIN | 3 | 10.26 | -30.77 | 94 | 964.03 | Feb. 7, 2026: 3 @ 10.26 |
| April 20, 2026 | issue | SO-260420-708 | MAIN | 18 | 10.26 | -184.60 | 97 | 994.79 | Feb. 7, 2026: 18 @ 10.26 |
| April 1, 2026 | issue | SO-260401-748 | MAIN | 26 | 10.26 | -266.65 | 115 | 1,179.39 | Feb. 7, 2026: 26 @ 10.26 |
| March 26, 2026 | return | RMA | MAIN | 20 | 10.26 | 205.11 | 141 | 1,446.04 | |
| March 17, 2026 | issue | SO-260317-709 | MAIN | 7 | 10.26 | -71.79 | 121 | 1,240.93 | Feb. 7, 2026: 7 @ 10.26 |
| March 9, 2026 | issue | SO-260309-523 | MAIN | 13 | 10.26 | -133.32 | 128 | 1,312.72 | Feb. 7, 2026: 13 @ 10.26 |
| March 6, 2026 | issue | SO-260306-542 | MAIN | 40 | 10.26 | -410.22 | 141 | 1,446.04 | Feb. 7, 2026: 40 @ 10.26 |
| Feb. 12, 2026 | issue | SO-260212-723 | MAIN | 10 | 10.23 | -102.26 | 181 | 1,856.26 | Nov. 1, 2025: 1 @ 9.96; Feb. 7, 2026: 9 @ 10.26 |
| Feb. 7, 2026 | receipt | PO-001205 | MAIN | 190 | 10.26 | 1,948.56 | 191 | 1,958.52 | |
| Feb. 1, 2026 | issue | SO-260201-632 | MAIN | 32 | 9.96 | -318.73 | 1 | 9.96 | Nov. 1, 2025: 32 @ 9.96 |
| Jan. 30, 2026 | issue | SO-260130-379 | MAIN | 12 | 9.96 | -119.52 | 33 | 328.69 | Nov. 1, 2025: 12 @ 9.96 |
| Jan. 17, 2026 | issue | SO-260117-558 | MAIN | 23 | 9.96 | -229.09 | 45 | 448.21 | Nov. 1, 2025: 23 @ 9.96 |
| Jan. 7, 2026 | issue | SO-260107-783 | MAIN | 18 | 9.96 | -179.29 | 68 | 677.30 | Nov. 1, 2025: 18 @ 9.96 |
| Jan. 4, 2026 | issue | SO-260104-129 | MAIN | 5 | 9.96 | -49.80 | 86 | 856.59 | Nov. 1, 2025: 5 @ 9.96 |
| Dec. 22, 2025 | issue | SO-251222-377 | MAIN | 5 | 9.96 | -49.80 | 91 | 906.39 | Nov. 1, 2025: 5 @ 9.96 |
| Dec. 21, 2025 | issue | SO-251221-551 | MAIN | 18 | 9.96 | -179.29 | 96 | 956.19 | Nov. 1, 2025: 18 @ 9.96 |
| Dec. 17, 2025 | issue | SO-251217-185 | MAIN | 28 | 9.96 | -278.89 | 114 | 1,135.47 | Nov. 1, 2025: 28 @ 9.96 |
| Nov. 29, 2025 | issue | SO-251129-151 | MAIN | 1 | 9.96 | -9.96 | 142 | 1,414.36 | Nov. 1, 2025: 1 @ 9.96 |
| Nov. 18, 2025 | issue | SO-251118-674 | MAIN | 20 | 9.96 | -199.21 | 143 | 1,424.32 | Nov. 1, 2025: 20 @ 9.96 |
| Nov. 16, 2025 | issue | SO-251116-941 | MAIN | 22 | 9.96 | -219.13 | 163 | 1,623.53 | Nov. 1, 2025: 22 @ 9.96 |
| Nov. 15, 2025 | issue | SO-251115-731 | MAIN | 1 | 9.96 | -9.96 | 185 | 1,842.66 | Nov. 1, 2025: 1 @ 9.96 |
| Nov. 11, 2025 | issue | SO-251111-114 | MAIN | 4 | 9.96 | -39.84 | 186 | 1,852.62 | Nov. 1, 2025: 4 @ 9.96 |
| Nov. 1, 2025 | receipt | PO-000969 | MAIN | 190 | 9.96 | 1,892.46 | 190 | 1,892.46 | |
| Oct. 28, 2025 | issue | SO-251028-652 | MAIN | 33 | 9.58 | -316.18 | 0 | 0.00 | May 5, 2025: 33 @ 9.58 |
| Oct. 17, 2025 | issue | SO-251017-954 | MAIN | 8 | 9.58 | -76.65 | 33 | 316.18 | May 5, 2025: 8 @ 9.58 |
| Sept. 28, 2025 | issue | SO-250928-526 | MAIN | 26 | 9.58 | -249.11 | 41 | 392.83 | May 5, 2025: 26 @ 9.58 |
| Sept. 20, 2025 | issue | SO-250920-812 | MAIN | 4 | 9.58 | -38.32 | 67 | 641.93 | May 5, 2025: 4 @ 9.58 |
| Aug. 23, 2025 | issue | SO-250823-967 | MAIN | 21 | 9.58 | -201.20 | 71 | 680.26 | May 5, 2025: 21 @ 9.58 |
| Aug. 23, 2025 | issue | SO-250823-967 | EAST | 21 | 9.58 | -201.20 | 92 | 881.46 | May 5, 2025: 21 @ 9.58 |
| Aug. 9, 2025 | issue | SO-250809-119 | EAST | 4 | 9.58 | -38.32 | 113 | 1,082.66 | May 5, 2025: 4 @ 9.58 |
| July 29, 2025 | issue | SO-250729-767 | EAST | 8 | 9.58 | -76.65 | 117 | 1,120.99 | May 5, 2025: 8 @ 9.58 |
| July 26, 2025 | issue | SO-250726-486 | MAIN | 5 | 9.58 | -47.91 | 125 | 1,197.64 | May 5, 2025: 5 @ 9.58 |
| July 25, 2025 | issue | SO-250725-940 | MAIN | 9 | 9.58 | -86.23 | 130 | 1,245.54 | May 5, 2025: 9 @ 9.58 |
| July 14, 2025 | issue | SO-250714-553 | EAST | 5 | 9.58 | -47.91 | 139 | 1,331.77 | May 5, 2025: 5 @ 9.58 |
| June 24, 2025 | issue | SO-250624-243 | MAIN | 3 | 9.58 | -28.74 | 144 | 1,379.68 | May 5, 2025: 3 @ 9.58 |
| June 22, 2025 | issue | SO-250622-222 | EAST | 8 | 9.58 | -76.65 | 147 | 1,408.42 | May 5, 2025: 8 @ 9.58 |
| June 18, 2025 | issue | SO-250618-999 | MAIN | 8 | 9.58 | -76.65 | 155 | 1,485.07 | May 5, 2025: 8 @ 9.58 |
| June 5, 2025 | issue | SO-250605-803 | MAIN | 7 | 9.58 | -67.07 | 163 | 1,561.72 | May 5, 2025: 7 @ 9.58 |
| June 4, 2025 | issue | SO-250604-353 | EAST | 15 | 9.58 | -143.72 | 170 | 1,628.79 | May 5, 2025: 15 @ 9.58 |
| June 3, 2025 | issue | SO-250603-858 | EAST | 3 | 9.58 | -28.74 | 185 | 1,772.50 | May 5, 2025: 3 @ 9.58 |
| May 21, 2025 | issue | SO-250521-402 | MAIN | 2 | 9.58 | -19.16 | 188 | 1,801.25 | May 5, 2025: 2 @ 9.58 |
| May 5, 2025 | transfer | TRF | MAIN → EAST | 64 | warehouse transfer, no cost effect | ||||
| May 5, 2025 | receipt | PO-000513 | MAIN | 190 | 9.58 | 1,820.41 | 190 | 1,820.41 | |
| May 1, 2025 | issue | SO-250501-744 | MAIN | 10 | 9.91 | -99.09 | 0 | 0.00 | Dec. 31, 2024: 7 @ 9.91; March 3, 2025: 3 @ 9.91 |
| April 26, 2025 | issue | SO-250426-480 | MAIN | 12 | 9.91 | -118.91 | 10 | 99.09 | Dec. 31, 2024: 12 @ 9.91 |
| April 24, 2025 | issue | SO-250424-680 | MAIN | 4 | 9.91 | -39.64 | 22 | 218.00 | Dec. 31, 2024: 4 @ 9.91 |
| April 21, 2025 | issue | SO-250421-719 | MAIN | 7 | 9.91 | -69.37 | 26 | 257.64 | Dec. 31, 2024: 7 @ 9.91 |
| April 14, 2025 | issue | SO-250414-419 | MAIN | 10 | 9.91 | -99.09 | 33 | 327.01 | Dec. 31, 2024: 10 @ 9.91 |
| April 12, 2025 | issue | SO-250412-850 | MAIN | 9 | 9.91 | -89.18 | 43 | 426.10 | Dec. 31, 2024: 9 @ 9.91 |
| April 7, 2025 | issue | SO-250407-684 | MAIN | 1 | 9.91 | -9.91 | 52 | 515.28 | Dec. 31, 2024: 1 @ 9.91 |
| April 1, 2025 | issue | SO-250401-509 | MAIN | 1 | 9.91 | -9.91 | 53 | 525.19 | Dec. 31, 2024: 1 @ 9.91 |
| March 31, 2025 | issue | SO-250331-403 | MAIN | 4 | 9.91 | -39.64 | 54 | 535.10 | Dec. 31, 2024: 4 @ 9.91 |
| March 26, 2025 | issue | SO-250326-229 | MAIN | 5 | 9.91 | -49.55 | 58 | 574.74 | Dec. 31, 2024: 5 @ 9.91 |
| March 25, 2025 | issue | SO-250325-451 | MAIN | 10 | 9.91 | -99.09 | 63 | 624.29 | Dec. 31, 2024: 10 @ 9.91 |
| March 23, 2025 | issue | SO-250323-294 | MAIN | 1 | 9.91 | -9.91 | 73 | 723.38 | Dec. 31, 2024: 1 @ 9.91 |
| March 13, 2025 | issue | SO-250313-249 | MAIN | 6 | 9.91 | -59.46 | 74 | 733.29 | Dec. 31, 2024: 6 @ 9.91 |
| March 12, 2025 | issue | SO-250312-771 | MAIN | 2 | 9.91 | -19.82 | 80 | 792.74 | Dec. 31, 2024: 2 @ 9.91 |
| March 3, 2025 | return | RMA | MAIN | 3 | 9.91 | 29.73 | 82 | 812.56 | |
| March 1, 2025 | issue | SO-250301-612 | MAIN | 14 | 9.91 | -138.73 | 79 | 782.83 | Dec. 31, 2024: 14 @ 9.91 |
| Feb. 18, 2025 | issue | SO-250218-868 | MAIN | 6 | 9.91 | -59.46 | 93 | 921.56 | Dec. 31, 2024: 6 @ 9.91 |
| Feb. 12, 2025 | issue | SO-250212-262 | MAIN | 24 | 9.91 | -237.82 | 99 | 981.02 | Dec. 31, 2024: 24 @ 9.91 |
| Feb. 11, 2025 | issue | SO-250211-148 | MAIN | 7 | 9.91 | -69.37 | 123 | 1,218.84 | Dec. 31, 2024: 7 @ 9.91 |
| Feb. 8, 2025 | issue | SO-250208-849 | MAIN | 8 | 9.91 | -79.27 | 130 | 1,288.21 | Dec. 31, 2024: 8 @ 9.91 |
| Jan. 27, 2025 | issue | SO-250127-904 | MAIN | 3 | 9.91 | -29.73 | 138 | 1,367.48 | Dec. 31, 2024: 3 @ 9.91 |
| Jan. 15, 2025 | issue | SO-250115-791 | MAIN | 32 | 9.91 | -317.10 | 141 | 1,397.21 | Dec. 31, 2024: 32 @ 9.91 |
| Jan. 12, 2025 | issue | SO-250112-580 | MAIN | 2 | 9.91 | -19.82 | 173 | 1,714.31 | Dec. 31, 2024: 2 @ 9.91 |
| Jan. 3, 2025 | issue | SO-250103-535 | MAIN | 29 | 9.93 | -287.89 | 175 | 1,734.13 | Oct. 1, 2024: 14 @ 9.95; Dec. 31, 2024: 15 @ 9.91 |
| Dec. 31, 2024 | receipt | PO-000153 | MAIN | 190 | 9.91 | 1,882.77 | 204 | 2,022.02 | |
| Dec. 30, 2024 | issue | SO-241230-116 | MAIN | 4 | 9.95 | -39.79 | 14 | 139.25 | Oct. 1, 2024: 4 @ 9.95 |
| Dec. 22, 2024 | issue | SO-241222-461 | MAIN | 34 | 9.95 | -338.18 | 18 | 179.04 | Oct. 1, 2024: 34 @ 9.95 |
| Dec. 12, 2024 | issue | SO-241212-766 | MAIN | 24 | 9.95 | -238.72 | 52 | 517.22 | Oct. 1, 2024: 24 @ 9.95 |
| Dec. 8, 2024 | issue | SO-241208-593 | MAIN | 5 | 9.95 | -49.73 | 76 | 755.93 | Oct. 1, 2024: 5 @ 9.95 |
| Dec. 1, 2024 | issue | SO-241201-385 | MAIN | 9 | 9.95 | -89.52 | 81 | 805.67 | Oct. 1, 2024: 9 @ 9.95 |
| Nov. 30, 2024 | issue | SO-241130-150 | MAIN | 3 | 9.95 | -29.84 | 90 | 895.18 | Oct. 1, 2024: 3 @ 9.95 |
| Nov. 26, 2024 | issue | SO-241126-802 | MAIN | 32 | 9.95 | -318.29 | 93 | 925.02 | Oct. 1, 2024: 32 @ 9.95 |
| Nov. 22, 2024 | issue | SO-241122-863 | MAIN | 7 | 9.95 | -69.63 | 125 | 1,243.31 | Oct. 1, 2024: 7 @ 9.95 |
| Nov. 15, 2024 | issue | SO-241115-951 | MAIN | 12 | 9.95 | -119.36 | 132 | 1,312.94 | Oct. 1, 2024: 12 @ 9.95 |
| Nov. 13, 2024 | issue | SO-241113-310 | MAIN | 3 | 9.95 | -29.84 | 144 | 1,432.30 | Oct. 1, 2024: 3 @ 9.95 |
| Oct. 26, 2024 | issue | SO-241026-507 | MAIN | 33 | 9.95 | -328.23 | 147 | 1,462.14 | Oct. 1, 2024: 33 @ 9.95 |
| Oct. 20, 2024 | issue | SO-241020-686 | MAIN | 10 | 9.95 | -99.46 | 180 | 1,790.37 | Oct. 1, 2024: 10 @ 9.95 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 190 | 9.95 | 1,889.84 | 190 | 1,889.84 | |