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, 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-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 |