Items / LED-0003
Downlight 7W Nova LED-0003 · Lighting · BrightLine Lighting
On hand (EA)920MAIN 920
Value (FIFO)94,601.21avg 102.83
ClassAX / FCV 0.27
Turnover3.2xlast issue 3 days ago
Days of cover117lead 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 | 240.17 / 30.4375 | 7.890 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 64.98 / 5.517 | 11.778 |
| 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 * 11.778^2 + 7.890^2 * 2.2^2) | 82.6 |
| Reorder point | d * LT + safety stock | 7.890 * 9.6 + 82.6 | 158.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 158.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2880/yr, S = 45.00, h = 20%, price = 104.64 | 111.3 |
| Inventory position | on hand + on order | 920 + 0 | 920 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 104.64 | 111 | 303,695 | yes (chosen if cheapest) |
| 1,940 | 100.45 | 1,940 | 308,866 | yes |
| 3,880 | 96.27 | 3,880 | 314,642 | yes |
MOQ 970, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 11, 2026 | 920 / 970 | 102.83 | 94,601.21 |
Movement ledger 110 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 13, 2026 | issue | SO-261013-645 | MAIN | 81 | 103.31 | -8,368.27 | 920 | 94,601.21 | May 15, 2026: 31 @ 104.09; Oct. 11, 2026: 50 @ 102.83 |
| Oct. 11, 2026 | issue | SO-261011-377 | MAIN | 97 | 104.09 | -10,097.07 | 1,001 | 102,969.48 | May 15, 2026: 97 @ 104.09 |
| Oct. 11, 2026 | receipt | PO-001867 | MAIN | 970 | 102.83 | 99,742.58 | 1,098 | 113,066.55 | |
| Oct. 10, 2026 | issue | SO-261010-743 | MAIN | 21 | 104.09 | -2,185.96 | 128 | 13,323.97 | May 15, 2026: 21 @ 104.09 |
| Sept. 26, 2026 | issue | SO-260926-107 | MAIN | 58 | 104.09 | -6,037.42 | 149 | 15,509.93 | May 15, 2026: 58 @ 104.09 |
| Sept. 22, 2026 | issue | SO-260922-550 | MAIN | 27 | 104.09 | -2,810.52 | 207 | 21,547.35 | May 15, 2026: 27 @ 104.09 |
| Sept. 20, 2026 | issue | SO-260920-990 | MAIN | 177 | 104.09 | -18,424.55 | 234 | 24,357.88 | May 15, 2026: 177 @ 104.09 |
| Aug. 29, 2026 | issue | SO-260829-915 | MAIN | 10 | 104.09 | -1,040.94 | 411 | 42,782.43 | May 15, 2026: 10 @ 104.09 |
| Aug. 25, 2026 | issue | SO-260825-800 | MAIN | 20 | 104.09 | -2,081.87 | 421 | 43,823.36 | May 15, 2026: 20 @ 104.09 |
| Aug. 23, 2026 | issue | SO-260823-193 | MAIN | 11 | 104.09 | -1,145.03 | 441 | 45,905.23 | May 15, 2026: 11 @ 104.09 |
| Aug. 20, 2026 | issue | SO-260820-767 | MAIN | 56 | 104.09 | -5,829.24 | 452 | 47,050.26 | May 15, 2026: 56 @ 104.09 |
| Aug. 17, 2026 | issue | SO-260817-811 | MAIN | 61 | 104.09 | -6,349.70 | 508 | 52,879.50 | May 15, 2026: 61 @ 104.09 |
| Aug. 9, 2026 | issue | SO-260809-777 | MAIN | 19 | 104.09 | -1,977.78 | 569 | 59,229.20 | May 15, 2026: 19 @ 104.09 |
| Aug. 6, 2026 | issue | SO-260806-412 | MAIN | 7 | 104.09 | -728.65 | 588 | 61,206.98 | May 15, 2026: 7 @ 104.09 |
| July 27, 2026 | issue | SO-260727-510 | MAIN | 102 | 104.09 | -10,617.54 | 595 | 61,935.63 | May 15, 2026: 102 @ 104.09 |
| July 20, 2026 | issue | SO-260720-557 | MAIN | 18 | 104.09 | -1,873.68 | 697 | 72,553.17 | May 15, 2026: 18 @ 104.09 |
| July 15, 2026 | issue | SO-260715-597 | MAIN | 3 | 104.09 | -312.28 | 715 | 74,426.85 | May 15, 2026: 3 @ 104.09 |
| July 1, 2026 | issue | SO-260701-957 | MAIN | 71 | 104.09 | -7,390.64 | 718 | 74,739.13 | May 15, 2026: 71 @ 104.09 |
| June 28, 2026 | issue | SO-260628-846 | MAIN | 42 | 104.09 | -4,371.93 | 789 | 82,129.77 | May 15, 2026: 42 @ 104.09 |
| June 26, 2026 | issue | SO-260626-189 | MAIN | 17 | 104.09 | -1,769.59 | 831 | 86,501.70 | May 15, 2026: 17 @ 104.09 |
| June 25, 2026 | issue | SO-260625-243 | MAIN | 46 | 104.09 | -4,788.30 | 848 | 88,271.29 | May 15, 2026: 46 @ 104.09 |
| June 15, 2026 | issue | SO-260615-108 | MAIN | 18 | 104.09 | -1,873.68 | 894 | 93,059.59 | May 15, 2026: 18 @ 104.09 |
| June 8, 2026 | issue | SO-260608-380 | MAIN | 13 | 104.09 | -1,353.22 | 912 | 94,933.27 | May 15, 2026: 13 @ 104.09 |
| May 26, 2026 | issue | SO-260526-363 | MAIN | 74 | 102.60 | -7,592.06 | 925 | 96,286.49 | Jan. 20, 2026: 29 @ 100.27; May 15, 2026: 45 @ 104.09 |
| May 24, 2026 | issue | SO-260524-411 | MAIN | 51 | 100.27 | -5,113.82 | 999 | 103,878.55 | Jan. 20, 2026: 51 @ 100.27 |
| May 15, 2026 | receipt | PO-001494 | MAIN | 970 | 104.09 | 100,970.70 | 1,050 | 108,992.37 | |
| May 14, 2026 | issue | SO-260514-444 | MAIN | 14 | 100.27 | -1,403.79 | 80 | 8,021.67 | Jan. 20, 2026: 14 @ 100.27 |
| May 6, 2026 | issue | SO-260506-305 | MAIN | 43 | 100.27 | -4,311.65 | 94 | 9,425.46 | Jan. 20, 2026: 43 @ 100.27 |
| May 1, 2026 | adjustment | Cycle count | MAIN | -2 | 100.27 | -200.54 | 137 | 13,737.11 | Jan. 20, 2026: 2 @ 100.27 |
| April 15, 2026 | issue | SO-260415-787 | MAIN | 52 | 100.27 | -5,214.09 | 139 | 13,937.66 | Jan. 20, 2026: 52 @ 100.27 |
| April 7, 2026 | issue | SO-260407-310 | MAIN | 132 | 100.27 | -13,235.76 | 191 | 19,151.74 | Jan. 20, 2026: 132 @ 100.27 |
| March 24, 2026 | issue | SO-260324-267 | MAIN | 147 | 100.27 | -14,739.82 | 323 | 32,387.50 | Jan. 20, 2026: 147 @ 100.27 |
| March 10, 2026 | issue | SO-260310-921 | MAIN | 150 | 100.27 | -15,040.64 | 470 | 47,127.32 | Jan. 20, 2026: 150 @ 100.27 |
| March 3, 2026 | issue | SO-260303-726 | MAIN | 8 | 100.27 | -802.17 | 620 | 62,167.96 | Jan. 20, 2026: 8 @ 100.27 |
| March 2, 2026 | issue | SO-260302-408 | MAIN | 25 | 100.27 | -2,506.77 | 628 | 62,970.13 | Jan. 20, 2026: 25 @ 100.27 |
| Feb. 25, 2026 | issue | SO-260225-356 | MAIN | 69 | 100.27 | -6,918.69 | 653 | 65,476.90 | Jan. 20, 2026: 69 @ 100.27 |
| Feb. 21, 2026 | issue | SO-260221-641 | MAIN | 135 | 100.27 | -13,536.57 | 722 | 72,395.59 | Jan. 20, 2026: 135 @ 100.27 |
| Feb. 17, 2026 | issue | SO-260217-211 | MAIN | 84 | 100.27 | -8,422.76 | 857 | 85,932.16 | Jan. 20, 2026: 84 @ 100.27 |
| Jan. 31, 2026 | issue | SO-260131-702 | MAIN | 29 | 100.27 | -2,907.86 | 941 | 94,354.92 | Jan. 20, 2026: 29 @ 100.27 |
| Jan. 20, 2026 | receipt | PO-001162 | MAIN | 970 | 100.27 | 97,262.77 | 970 | 97,262.77 | |
| Jan. 11, 2026 | issue | SO-260111-360 | MAIN | 245 | 100.04 | -24,510.80 | 0 | 0.00 | Oct. 7, 2025: 245 @ 100.04 |
| Dec. 27, 2025 | issue | SO-251227-797 | MAIN | 48 | 100.04 | -4,802.12 | 245 | 24,510.80 | Oct. 7, 2025: 48 @ 100.04 |
| Dec. 14, 2025 | issue | SO-251214-496 | MAIN | 43 | 100.04 | -4,301.90 | 293 | 29,312.92 | Oct. 7, 2025: 43 @ 100.04 |
| Dec. 10, 2025 | issue | SO-251210-993 | MAIN | 87 | 100.04 | -8,703.84 | 336 | 33,614.82 | Oct. 7, 2025: 87 @ 100.04 |
| Dec. 6, 2025 | issue | SO-251206-917 | MAIN | 41 | 100.04 | -4,101.81 | 423 | 42,318.65 | Oct. 7, 2025: 41 @ 100.04 |
| Nov. 30, 2025 | issue | SO-251130-253 | MAIN | 98 | 100.04 | -9,804.32 | 464 | 46,420.46 | Oct. 7, 2025: 98 @ 100.04 |
| Nov. 26, 2025 | issue | SO-251126-573 | MAIN | 49 | 100.04 | -4,902.16 | 562 | 56,224.78 | Oct. 7, 2025: 49 @ 100.04 |
| Nov. 24, 2025 | issue | SO-251124-285 | MAIN | 177 | 100.04 | -17,707.81 | 611 | 61,126.95 | Oct. 7, 2025: 177 @ 100.04 |
| Nov. 19, 2025 | issue | SO-251119-519 | MAIN | 38 | 100.04 | -3,801.68 | 788 | 78,834.75 | Oct. 7, 2025: 38 @ 100.04 |
| Oct. 27, 2025 | issue | SO-251027-206 | MAIN | 8 | 100.04 | -800.35 | 826 | 82,636.43 | Oct. 7, 2025: 8 @ 100.04 |
| Oct. 23, 2025 | issue | SO-251023-183 | MAIN | 70 | 100.04 | -7,003.09 | 834 | 83,436.78 | Oct. 7, 2025: 70 @ 100.04 |
| Oct. 21, 2025 | issue | SO-251021-483 | MAIN | 18 | 100.04 | -1,800.79 | 904 | 90,439.87 | Oct. 7, 2025: 18 @ 100.04 |
| Oct. 14, 2025 | issue | SO-251014-831 | MAIN | 53 | 99.93 | -5,296.38 | 922 | 92,240.66 | May 28, 2025: 5 @ 98.85; Oct. 7, 2025: 48 @ 100.04 |
| Oct. 9, 2025 | issue | SO-251009-191 | MAIN | 50 | 98.85 | -4,942.61 | 975 | 97,537.04 | May 28, 2025: 50 @ 98.85 |
| Oct. 7, 2025 | receipt | PO-000904 | MAIN | 970 | 100.04 | 97,042.78 | 1,025 | 102,479.65 | |
| Oct. 2, 2025 | issue | SO-251002-407 | MAIN | 5 | 98.85 | -494.26 | 55 | 5,436.87 | May 28, 2025: 5 @ 98.85 |
| Oct. 1, 2025 | issue | SO-251001-689 | MAIN | 63 | 98.85 | -6,227.69 | 60 | 5,931.13 | May 28, 2025: 63 @ 98.85 |
| Sept. 28, 2025 | issue | SO-250928-233 | MAIN | 76 | 98.85 | -7,512.77 | 123 | 12,158.82 | May 28, 2025: 76 @ 98.85 |
| Sept. 24, 2025 | issue | SO-250924-210 | MAIN | 10 | 98.85 | -988.52 | 199 | 19,671.59 | May 28, 2025: 10 @ 98.85 |
| Sept. 23, 2025 | issue | SO-250923-225 | MAIN | 18 | 98.85 | -1,779.34 | 209 | 20,660.11 | May 28, 2025: 18 @ 98.85 |
| Sept. 13, 2025 | issue | SO-250913-582 | MAIN | 56 | 98.85 | -5,535.72 | 227 | 22,439.45 | May 28, 2025: 56 @ 98.85 |
| Sept. 9, 2025 | issue | SO-250909-221 | MAIN | 17 | 98.85 | -1,680.49 | 283 | 27,975.17 | May 28, 2025: 17 @ 98.85 |
| Sept. 8, 2025 | issue | SO-250908-135 | MAIN | 55 | 98.85 | -5,436.87 | 300 | 29,655.66 | May 28, 2025: 55 @ 98.85 |
| Sept. 3, 2025 | issue | SO-250903-311 | MAIN | 35 | 98.85 | -3,459.83 | 355 | 35,092.53 | May 28, 2025: 35 @ 98.85 |
| Aug. 23, 2025 | issue | SO-250823-844 | MAIN | 16 | 98.85 | -1,581.64 | 390 | 38,552.36 | May 28, 2025: 16 @ 98.85 |
| Aug. 20, 2025 | issue | SO-250820-350 | MAIN | 27 | 98.85 | -2,669.01 | 406 | 40,133.99 | May 28, 2025: 27 @ 98.85 |
| Aug. 8, 2025 | issue | SO-250808-678 | MAIN | 99 | 98.85 | -9,786.37 | 433 | 42,803.00 | May 28, 2025: 99 @ 98.85 |
| Aug. 7, 2025 | issue | SO-250807-303 | MAIN | 7 | 98.85 | -691.97 | 532 | 52,589.37 | May 28, 2025: 7 @ 98.85 |
| Aug. 6, 2025 | issue | SO-250806-889 | MAIN | 14 | 98.85 | -1,383.93 | 539 | 53,281.34 | May 28, 2025: 14 @ 98.85 |
| Aug. 5, 2025 | issue | SO-250805-395 | MAIN | 59 | 98.85 | -5,832.28 | 553 | 54,665.27 | May 28, 2025: 59 @ 98.85 |
| July 20, 2025 | issue | SO-250720-708 | MAIN | 41 | 98.85 | -4,052.94 | 612 | 60,497.55 | May 28, 2025: 41 @ 98.85 |
| July 14, 2025 | issue | SO-250714-654 | MAIN | 70 | 98.85 | -6,919.65 | 653 | 64,550.49 | May 28, 2025: 70 @ 98.85 |
| July 13, 2025 | issue | SO-250713-157 | MAIN | 12 | 98.85 | -1,186.23 | 723 | 71,470.14 | May 28, 2025: 12 @ 98.85 |
| July 11, 2025 | issue | SO-250711-605 | MAIN | 15 | 98.85 | -1,482.78 | 735 | 72,656.37 | May 28, 2025: 15 @ 98.85 |
| June 25, 2025 | issue | SO-250625-374 | MAIN | 22 | 98.85 | -2,174.75 | 750 | 74,139.15 | May 28, 2025: 22 @ 98.85 |
| June 20, 2025 | issue | SO-250620-393 | MAIN | 168 | 98.85 | -16,607.17 | 772 | 76,313.90 | May 28, 2025: 168 @ 98.85 |
| June 2, 2025 | issue | SO-250602-619 | MAIN | 41 | 97.66 | -4,003.93 | 940 | 92,921.07 | Dec. 19, 2024: 11 @ 94.40; May 28, 2025: 30 @ 98.85 |
| May 28, 2025 | receipt | PO-000585 | MAIN | 970 | 98.85 | 95,886.63 | 981 | 96,925.00 | |
| May 25, 2025 | issue | SO-250525-816 | MAIN | 17 | 94.40 | -1,604.74 | 11 | 1,038.36 | Dec. 19, 2024: 17 @ 94.40 |
| May 21, 2025 | issue | SO-250521-809 | MAIN | 93 | 94.40 | -8,778.88 | 28 | 2,643.10 | Dec. 19, 2024: 93 @ 94.40 |
| May 7, 2025 | issue | SO-250507-666 | MAIN | 30 | 94.40 | -2,831.90 | 121 | 11,421.99 | Dec. 19, 2024: 30 @ 94.40 |
| May 4, 2025 | issue | SO-250504-584 | MAIN | 98 | 94.40 | -9,250.87 | 151 | 14,253.89 | Dec. 19, 2024: 98 @ 94.40 |
| April 20, 2025 | issue | SO-250420-338 | MAIN | 86 | 94.40 | -8,118.11 | 249 | 23,504.75 | Dec. 19, 2024: 86 @ 94.40 |
| April 17, 2025 | issue | SO-250417-198 | MAIN | 14 | 94.40 | -1,321.55 | 335 | 31,622.86 | Dec. 19, 2024: 14 @ 94.40 |
| April 10, 2025 | issue | SO-250410-213 | MAIN | 38 | 94.40 | -3,587.07 | 349 | 32,944.41 | Dec. 19, 2024: 38 @ 94.40 |
| March 24, 2025 | issue | SO-250324-366 | MAIN | 25 | 94.40 | -2,359.92 | 387 | 36,531.48 | Dec. 19, 2024: 25 @ 94.40 |
| March 22, 2025 | issue | SO-250322-519 | MAIN | 1 | 94.40 | -94.40 | 412 | 38,891.40 | Dec. 19, 2024: 1 @ 94.40 |
| March 21, 2025 | issue | SO-250321-745 | MAIN | 131 | 94.40 | -12,365.95 | 413 | 38,985.80 | Dec. 19, 2024: 131 @ 94.40 |
| March 14, 2025 | issue | SO-250314-621 | MAIN | 23 | 94.40 | -2,171.12 | 544 | 51,351.75 | Dec. 19, 2024: 23 @ 94.40 |
| March 13, 2025 | issue | SO-250313-302 | MAIN | 10 | 94.40 | -943.97 | 567 | 53,522.87 | Dec. 19, 2024: 10 @ 94.40 |
| March 1, 2025 | issue | SO-250301-131 | MAIN | 17 | 94.40 | -1,604.74 | 577 | 54,466.84 | Dec. 19, 2024: 17 @ 94.40 |
| Feb. 23, 2025 | issue | SO-250223-244 | MAIN | 25 | 94.40 | -2,359.92 | 594 | 56,071.58 | Dec. 19, 2024: 25 @ 94.40 |
| Feb. 14, 2025 | issue | SO-250214-572 | MAIN | 6 | 94.40 | -566.38 | 619 | 58,431.50 | Dec. 19, 2024: 6 @ 94.40 |
| Feb. 14, 2025 | issue | SO-250214-572 | EAST | 117 | 94.40 | -11,044.40 | 625 | 58,997.88 | Dec. 19, 2024: 117 @ 94.40 |
| Feb. 12, 2025 | issue | SO-250212-973 | EAST | 18 | 94.40 | -1,699.14 | 742 | 70,042.28 | Dec. 19, 2024: 18 @ 94.40 |
| Feb. 1, 2025 | issue | SO-250201-270 | EAST | 119 | 94.40 | -11,233.20 | 760 | 71,741.42 | Dec. 19, 2024: 119 @ 94.40 |
| Jan. 31, 2025 | issue | SO-250131-703 | EAST | 25 | 94.40 | -2,359.92 | 879 | 82,974.61 | Dec. 19, 2024: 25 @ 94.40 |
| Jan. 17, 2025 | issue | SO-250117-796 | MAIN | 160 | 97.34 | -15,574.53 | 904 | 85,334.53 | Oct. 1, 2024: 45 @ 99.41; Nov. 17, 2024: 49 @ 99.41; Dec. 19, 2024: 66 @ 94.40 |
| Jan. 6, 2025 | issue | SO-250106-315 | MAIN | 92 | 99.41 | -9,145.54 | 1,064 | 100,909.05 | Oct. 1, 2024: 92 @ 99.41 |
| Dec. 19, 2024 | transfer | TRF | MAIN → EAST | 279 | warehouse transfer, no cost effect | ||||
| Dec. 19, 2024 | receipt | PO-000115 | MAIN | 970 | 94.40 | 91,564.70 | 1,156 | 110,054.59 | |
| Dec. 10, 2024 | issue | SO-241210-273 | MAIN | 22 | 99.41 | -2,186.98 | 186 | 18,489.89 | Oct. 1, 2024: 22 @ 99.41 |
| Dec. 7, 2024 | issue | SO-241207-511 | MAIN | 226 | 99.41 | -22,466.21 | 208 | 20,676.86 | Oct. 1, 2024: 226 @ 99.41 |
| Nov. 17, 2024 | return | RMA | MAIN | 49 | 99.41 | 4,870.99 | 434 | 43,143.07 | |
| Nov. 14, 2024 | issue | SO-241114-738 | MAIN | 98 | 99.41 | -9,741.98 | 385 | 38,272.08 | Oct. 1, 2024: 98 @ 99.41 |
| Nov. 6, 2024 | issue | SO-241106-383 | MAIN | 11 | 99.41 | -1,093.49 | 483 | 48,014.06 | Oct. 1, 2024: 11 @ 99.41 |
| Nov. 1, 2024 | issue | SO-241101-268 | MAIN | 218 | 99.41 | -21,670.94 | 494 | 49,107.55 | Oct. 1, 2024: 218 @ 99.41 |
| Oct. 26, 2024 | issue | SO-241026-264 | MAIN | 178 | 99.41 | -17,694.62 | 712 | 70,778.50 | Oct. 1, 2024: 178 @ 99.41 |
| Oct. 14, 2024 | issue | SO-241014-399 | MAIN | 80 | 99.41 | -7,952.64 | 890 | 88,473.12 | Oct. 1, 2024: 80 @ 99.41 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 970 | 99.41 | 96,425.76 | 970 | 96,425.76 | |