Items / LED-0036
LED Bulb 12W Prime LED-0036 · Lighting · BrightLine Lighting
On hand (EA)85MAIN 85
Value (FIFO)604.65avg 7.11
ClassCX / FCV 0.41
Turnover5.5xlast issue 2 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 | 48.92 / 30.4375 | 1.607 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 20.24 / 5.517 | 3.668 |
| 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 * 3.668^2 + 1.607^2 * 2.2^2) | 15.2 |
| Reorder point | d * LT + safety stock | 1.607 * 9.6 + 15.2 | 30.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 30.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 587/yr, S = 45.00, h = 20%, price = 6.93 | 360.0 |
| Inventory position | on hand + on order | 85 + 0 | 85 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 7.22 | 191 | 4,511 | yes |
| 360 | 6.93 | 360 | 4,389 | yes (chosen if cheapest) |
| 720 | 6.64 | 720 | 4,411 | yes |
MOQ 180, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 13, 2026 | 85 / 180 | 7.11 | 604.65 |
Movement ledger 117 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | issue | SO-261014-188 | MAIN | 3 | 7.11 | -21.34 | 85 | 604.65 | Aug. 13, 2026: 3 @ 7.11 |
| Oct. 13, 2026 | issue | SO-261013-835 | MAIN | 3 | 7.11 | -21.34 | 88 | 625.99 | Aug. 13, 2026: 3 @ 7.11 |
| Oct. 12, 2026 | issue | SO-261012-533 | MAIN | 1 | 7.11 | -7.11 | 91 | 647.33 | Aug. 13, 2026: 1 @ 7.11 |
| Oct. 9, 2026 | issue | SO-261009-228 | MAIN | 28 | 7.11 | -199.18 | 92 | 654.44 | Aug. 13, 2026: 28 @ 7.11 |
| Oct. 8, 2026 | issue | SO-261008-466 | MAIN | 4 | 7.11 | -28.45 | 120 | 853.62 | Aug. 13, 2026: 4 @ 7.11 |
| Sept. 30, 2026 | issue | SO-260930-937 | MAIN | 7 | 7.11 | -49.79 | 124 | 882.07 | Aug. 13, 2026: 7 @ 7.11 |
| Sept. 27, 2026 | issue | SO-260927-635 | MAIN | 25 | 7.11 | -177.84 | 131 | 931.87 | Aug. 13, 2026: 25 @ 7.11 |
| Sept. 17, 2026 | issue | SO-260917-176 | MAIN | 1 | 7.11 | -7.11 | 156 | 1,109.71 | Aug. 13, 2026: 1 @ 7.11 |
| Sept. 15, 2026 | issue | SO-260915-828 | MAIN | 5 | 7.11 | -35.57 | 157 | 1,116.82 | Aug. 13, 2026: 5 @ 7.11 |
| Sept. 10, 2026 | issue | SO-260910-427 | MAIN | 10 | 7.11 | -71.14 | 162 | 1,152.39 | Aug. 13, 2026: 10 @ 7.11 |
| Aug. 22, 2026 | issue | SO-260822-393 | MAIN | 1 | 7.11 | -7.11 | 172 | 1,223.52 | Aug. 13, 2026: 1 @ 7.11 |
| Aug. 21, 2026 | issue | SO-260821-631 | MAIN | 6 | 7.11 | -42.68 | 173 | 1,230.64 | Aug. 13, 2026: 6 @ 7.11 |
| Aug. 15, 2026 | issue | SO-260815-221 | MAIN | 1 | 7.11 | -7.11 | 179 | 1,273.32 | Aug. 13, 2026: 1 @ 7.11 |
| Aug. 13, 2026 | receipt | PO-001716 | MAIN | 180 | 7.11 | 1,280.43 | 180 | 1,280.43 | |
| Aug. 6, 2026 | issue | SO-260806-466 | MAIN | 14 | 7.23 | -101.24 | 0 | 0.00 | March 21, 2026: 14 @ 7.23 |
| Aug. 2, 2026 | issue | SO-260802-859 | MAIN | 9 | 7.23 | -65.08 | 14 | 101.24 | March 21, 2026: 9 @ 7.23 |
| July 28, 2026 | issue | SO-260728-869 | MAIN | 4 | 7.23 | -28.92 | 23 | 166.32 | March 21, 2026: 4 @ 7.23 |
| July 23, 2026 | issue | SO-260723-197 | MAIN | 5 | 7.23 | -36.16 | 27 | 195.24 | March 21, 2026: 5 @ 7.23 |
| July 13, 2026 | issue | SO-260713-786 | MAIN | 5 | 7.23 | -36.16 | 32 | 231.40 | March 21, 2026: 5 @ 7.23 |
| July 7, 2026 | issue | SO-260707-158 | MAIN | 11 | 7.23 | -79.54 | 37 | 267.55 | March 21, 2026: 11 @ 7.23 |
| July 4, 2026 | issue | SO-260704-560 | MAIN | 8 | 7.23 | -57.85 | 48 | 347.09 | March 21, 2026: 8 @ 7.23 |
| June 23, 2026 | issue | SO-260623-736 | MAIN | 14 | 7.23 | -101.24 | 56 | 404.94 | March 21, 2026: 14 @ 7.23 |
| June 21, 2026 | issue | SO-260621-948 | MAIN | 1 | 7.23 | -7.23 | 70 | 506.18 | March 21, 2026: 1 @ 7.23 |
| June 20, 2026 | issue | SO-260620-562 | MAIN | 19 | 7.23 | -137.39 | 71 | 513.41 | March 21, 2026: 19 @ 7.23 |
| June 17, 2026 | issue | SO-260617-962 | MAIN | 1 | 7.23 | -7.23 | 90 | 650.80 | March 21, 2026: 1 @ 7.23 |
| June 11, 2026 | issue | SO-260611-155 | MAIN | 4 | 7.23 | -28.92 | 91 | 658.03 | March 21, 2026: 4 @ 7.23 |
| June 1, 2026 | issue | SO-260601-622 | MAIN | 1 | 7.23 | -7.23 | 95 | 686.95 | March 21, 2026: 1 @ 7.23 |
| May 30, 2026 | issue | SO-260530-929 | MAIN | 5 | 7.23 | -36.16 | 96 | 694.19 | March 21, 2026: 5 @ 7.23 |
| May 28, 2026 | issue | SO-260528-158 | MAIN | 6 | 7.23 | -43.39 | 101 | 730.34 | March 21, 2026: 6 @ 7.23 |
| May 4, 2026 | issue | SO-260504-387 | MAIN | 20 | 7.23 | -144.62 | 107 | 773.73 | March 21, 2026: 20 @ 7.23 |
| April 9, 2026 | issue | SO-260409-731 | MAIN | 10 | 7.23 | -72.31 | 127 | 918.35 | March 21, 2026: 10 @ 7.23 |
| April 8, 2026 | issue | SO-260408-221 | MAIN | 26 | 7.23 | -188.01 | 137 | 990.66 | March 21, 2026: 26 @ 7.23 |
| March 29, 2026 | issue | SO-260329-956 | MAIN | 25 | 7.13 | -178.23 | 163 | 1,178.67 | Dec. 3, 2025: 8 @ 6.91; March 21, 2026: 17 @ 7.23 |
| March 27, 2026 | issue | SO-260327-163 | MAIN | 2 | 6.91 | -13.83 | 188 | 1,356.90 | Dec. 3, 2025: 2 @ 6.91 |
| March 26, 2026 | issue | SO-260326-529 | MAIN | 4 | 6.91 | -27.65 | 190 | 1,370.72 | Dec. 3, 2025: 4 @ 6.91 |
| March 21, 2026 | receipt | PO-001339 | MAIN | 180 | 7.23 | 1,301.60 | 194 | 1,398.38 | |
| March 11, 2026 | issue | SO-260311-189 | MAIN | 11 | 6.91 | -76.04 | 14 | 96.78 | Dec. 3, 2025: 11 @ 6.91 |
| March 10, 2026 | issue | SO-260310-875 | MAIN | 5 | 6.91 | -34.56 | 25 | 172.82 | Dec. 3, 2025: 5 @ 6.91 |
| March 9, 2026 | issue | SO-260309-170 | MAIN | 3 | 6.91 | -20.74 | 30 | 207.38 | Dec. 3, 2025: 3 @ 6.91 |
| Feb. 9, 2026 | issue | SO-260209-171 | MAIN | 24 | 6.91 | -165.90 | 33 | 228.12 | Dec. 3, 2025: 24 @ 6.91 |
| Feb. 6, 2026 | issue | SO-260206-154 | MAIN | 18 | 6.91 | -124.43 | 57 | 394.02 | Dec. 3, 2025: 18 @ 6.91 |
| Feb. 3, 2026 | issue | SO-260203-245 | MAIN | 1 | 6.91 | -6.91 | 75 | 518.45 | Dec. 3, 2025: 1 @ 6.91 |
| Jan. 27, 2026 | issue | SO-260127-892 | MAIN | 32 | 6.91 | -221.21 | 76 | 525.37 | Dec. 3, 2025: 32 @ 6.91 |
| Jan. 2, 2026 | issue | SO-260102-145 | MAIN | 17 | 6.91 | -117.52 | 108 | 746.57 | Dec. 3, 2025: 17 @ 6.91 |
| Jan. 1, 2026 | issue | SO-260101-223 | MAIN | 16 | 6.91 | -110.60 | 125 | 864.09 | Dec. 3, 2025: 16 @ 6.91 |
| Dec. 27, 2025 | issue | SO-251227-175 | MAIN | 3 | 6.91 | -20.74 | 141 | 974.69 | Dec. 3, 2025: 3 @ 6.91 |
| Dec. 24, 2025 | issue | SO-251224-861 | MAIN | 18 | 6.91 | -124.43 | 144 | 995.43 | Dec. 3, 2025: 18 @ 6.91 |
| Dec. 12, 2025 | issue | SO-251212-255 | MAIN | 18 | 6.91 | -124.43 | 162 | 1,119.86 | Dec. 3, 2025: 18 @ 6.91 |
| Dec. 9, 2025 | issue | SO-251209-874 | MAIN | 14 | 6.74 | -94.33 | 180 | 1,244.29 | Sept. 13, 2025: 12 @ 6.74; Oct. 19, 2025: 2 @ 6.74 |
| Dec. 7, 2025 | issue | SO-251207-805 | MAIN | 9 | 6.74 | -60.64 | 194 | 1,338.62 | Sept. 13, 2025: 9 @ 6.74 |
| Dec. 3, 2025 | receipt | PO-001032 | MAIN | 180 | 6.91 | 1,244.29 | 203 | 1,399.26 | |
| Nov. 22, 2025 | issue | SO-251122-422 | MAIN | 77 | 6.74 | -518.81 | 23 | 154.97 | Sept. 13, 2025: 77 @ 6.74 |
| Nov. 6, 2025 | issue | SO-251106-721 | MAIN | 29 | 6.74 | -195.40 | 100 | 673.78 | Sept. 13, 2025: 29 @ 6.74 |
| Oct. 30, 2025 | issue | SO-251030-406 | MAIN | 4 | 6.74 | -26.95 | 129 | 869.18 | Sept. 13, 2025: 4 @ 6.74 |
| Oct. 26, 2025 | issue | SO-251026-710 | MAIN | 2 | 6.74 | -13.48 | 133 | 896.13 | Sept. 13, 2025: 2 @ 6.74 |
| Oct. 22, 2025 | issue | SO-251022-715 | MAIN | 1 | 6.74 | -6.74 | 135 | 909.60 | Sept. 13, 2025: 1 @ 6.74 |
| Oct. 19, 2025 | return | RMA | MAIN | 2 | 6.74 | 13.48 | 136 | 916.34 | |
| Oct. 16, 2025 | issue | SO-251016-261 | MAIN | 1 | 6.74 | -6.74 | 134 | 902.87 | Sept. 13, 2025: 1 @ 6.74 |
| Oct. 12, 2025 | issue | SO-251012-508 | MAIN | 15 | 6.74 | -101.07 | 135 | 909.60 | Sept. 13, 2025: 15 @ 6.74 |
| Oct. 9, 2025 | issue | SO-251009-141 | MAIN | 4 | 6.74 | -26.95 | 150 | 1,010.67 | Sept. 13, 2025: 4 @ 6.74 |
| Oct. 5, 2025 | issue | SO-251005-110 | MAIN | 17 | 6.74 | -114.54 | 154 | 1,037.62 | Sept. 13, 2025: 17 @ 6.74 |
| Sept. 25, 2025 | issue | SO-250925-338 | MAIN | 18 | 6.69 | -120.42 | 171 | 1,152.16 | April 19, 2025: 9 @ 6.64; Sept. 13, 2025: 9 @ 6.74 |
| Sept. 13, 2025 | receipt | PO-000837 | MAIN | 180 | 6.74 | 1,212.80 | 189 | 1,272.58 | |
| Sept. 6, 2025 | issue | SO-250906-606 | MAIN | 1 | 6.64 | -6.64 | 9 | 59.78 | April 19, 2025: 1 @ 6.64 |
| Sept. 1, 2025 | issue | SO-250901-933 | MAIN | 18 | 6.64 | -119.55 | 10 | 66.42 | April 19, 2025: 18 @ 6.64 |
| Aug. 31, 2025 | issue | SO-250831-791 | MAIN | 3 | 6.64 | -19.93 | 28 | 185.97 | April 19, 2025: 3 @ 6.64 |
| Aug. 28, 2025 | issue | SO-250828-942 | MAIN | 2 | 6.64 | -13.28 | 31 | 205.90 | April 19, 2025: 2 @ 6.64 |
| Aug. 13, 2025 | issue | SO-250813-285 | MAIN | 17 | 6.64 | -112.91 | 33 | 219.18 | April 19, 2025: 17 @ 6.64 |
| Aug. 6, 2025 | issue | SO-250806-723 | MAIN | 7 | 6.64 | -46.49 | 50 | 332.09 | April 19, 2025: 7 @ 6.64 |
| Aug. 2, 2025 | issue | SO-250802-814 | MAIN | 6 | 6.64 | -39.85 | 57 | 378.58 | April 19, 2025: 6 @ 6.64 |
| Aug. 1, 2025 | issue | SO-250801-292 | MAIN | 8 | 6.64 | -53.13 | 63 | 418.43 | April 19, 2025: 8 @ 6.64 |
| July 15, 2025 | issue | SO-250715-958 | MAIN | 15 | 6.64 | -99.63 | 71 | 471.57 | April 19, 2025: 15 @ 6.64 |
| July 8, 2025 | issue | SO-250708-826 | MAIN | 15 | 6.64 | -99.63 | 86 | 571.19 | April 19, 2025: 15 @ 6.64 |
| July 5, 2025 | issue | SO-250705-315 | MAIN | 5 | 6.64 | -33.21 | 101 | 670.82 | April 19, 2025: 5 @ 6.64 |
| June 27, 2025 | issue | SO-250627-304 | MAIN | 17 | 6.64 | -112.91 | 106 | 704.03 | April 19, 2025: 17 @ 6.64 |
| June 19, 2025 | issue | SO-250619-252 | MAIN | 11 | 6.64 | -73.06 | 123 | 816.94 | April 19, 2025: 11 @ 6.64 |
| June 18, 2025 | issue | SO-250618-558 | MAIN | 5 | 6.64 | -33.21 | 134 | 890.00 | April 19, 2025: 5 @ 6.64 |
| June 10, 2025 | issue | SO-250610-552 | MAIN | 1 | 6.64 | -6.64 | 139 | 923.21 | April 19, 2025: 1 @ 6.64 |
| June 5, 2025 | issue | SO-250605-522 | MAIN | 7 | 6.64 | -46.49 | 140 | 929.85 | April 19, 2025: 7 @ 6.64 |
| May 27, 2025 | issue | SO-250527-298 | MAIN | 13 | 6.64 | -86.34 | 147 | 976.34 | April 19, 2025: 13 @ 6.64 |
| May 15, 2025 | issue | SO-250515-413 | MAIN | 2 | 6.64 | -13.28 | 160 | 1,062.69 | April 19, 2025: 2 @ 6.64 |
| May 9, 2025 | issue | SO-250509-235 | MAIN | 1 | 6.64 | -6.64 | 162 | 1,075.97 | April 19, 2025: 1 @ 6.64 |
| May 7, 2025 | issue | SO-250507-216 | MAIN | 2 | 6.64 | -13.28 | 163 | 1,082.61 | April 19, 2025: 2 @ 6.64 |
| May 5, 2025 | issue | SO-250505-364 | MAIN | 10 | 6.64 | -66.42 | 165 | 1,095.90 | April 19, 2025: 10 @ 6.64 |
| May 4, 2025 | issue | SO-250504-462 | MAIN | 5 | 6.64 | -33.21 | 175 | 1,162.32 | April 19, 2025: 5 @ 6.64 |
| April 19, 2025 | receipt | PO-000460 | MAIN | 180 | 6.64 | 1,195.52 | 180 | 1,195.52 | |
| April 10, 2025 | issue | SO-250410-863 | MAIN | 20 | 6.51 | -130.26 | 0 | 0.00 | Dec. 19, 2024: 17 @ 6.51; March 31, 2025: 3 @ 6.51 |
| April 9, 2025 | issue | SO-250409-362 | MAIN | 13 | 6.51 | -84.67 | 20 | 130.26 | Dec. 19, 2024: 13 @ 6.51 |
| March 31, 2025 | return | RMA | MAIN | 3 | 6.51 | 19.54 | 33 | 214.93 | |
| March 25, 2025 | issue | SO-250325-190 | MAIN | 7 | 6.51 | -45.59 | 30 | 195.39 | Dec. 19, 2024: 7 @ 6.51 |
| March 12, 2025 | issue | SO-250312-894 | MAIN | 28 | 6.51 | -182.36 | 37 | 240.98 | Dec. 19, 2024: 28 @ 6.51 |
| Feb. 28, 2025 | issue | SO-250228-194 | MAIN | 13 | 6.51 | -84.67 | 65 | 423.34 | Dec. 19, 2024: 13 @ 6.51 |
| Feb. 25, 2025 | issue | SO-250225-855 | MAIN | 12 | 6.51 | -78.15 | 78 | 508.01 | Dec. 19, 2024: 12 @ 6.51 |
| Feb. 24, 2025 | issue | SO-250224-829 | MAIN | 3 | 6.51 | -19.54 | 90 | 586.16 | Dec. 19, 2024: 3 @ 6.51 |
| Feb. 22, 2025 | issue | SO-250222-360 | MAIN | 12 | 6.51 | -78.15 | 93 | 605.70 | Dec. 19, 2024: 12 @ 6.51 |
| Feb. 17, 2025 | issue | SO-250217-156 | MAIN | 6 | 6.51 | -39.08 | 105 | 683.85 | Dec. 19, 2024: 6 @ 6.51 |
| Feb. 15, 2025 | issue | SO-250215-256 | MAIN | 3 | 6.51 | -19.54 | 111 | 722.93 | Dec. 19, 2024: 3 @ 6.51 |
| Jan. 26, 2025 | issue | SO-250126-955 | MAIN | 9 | 6.51 | -58.62 | 114 | 742.47 | Dec. 19, 2024: 9 @ 6.51 |
| Jan. 24, 2025 | issue | SO-250124-287 | MAIN | 13 | 6.51 | -84.67 | 123 | 801.09 | Dec. 19, 2024: 13 @ 6.51 |
| Jan. 23, 2025 | issue | SO-250123-644 | MAIN | 28 | 6.51 | -182.36 | 136 | 885.75 | Dec. 19, 2024: 28 @ 6.51 |
| Dec. 30, 2024 | issue | SO-241230-325 | MAIN | 3 | 6.51 | -19.54 | 164 | 1,068.12 | Dec. 19, 2024: 3 @ 6.51 |
| Dec. 28, 2024 | issue | SO-241228-806 | MAIN | 33 | 6.72 | -221.85 | 167 | 1,087.65 | Oct. 1, 2024: 20 @ 6.86; Dec. 19, 2024: 13 @ 6.51 |
| Dec. 19, 2024 | receipt | PO-000115 | MAIN | 180 | 6.51 | 1,172.32 | 200 | 1,309.50 | |
| Dec. 10, 2024 | issue | SO-241210-843 | MAIN | 35 | 6.86 | -240.06 | 20 | 137.18 | Oct. 1, 2024: 35 @ 6.86 |
| Dec. 9, 2024 | issue | SO-241209-682 | MAIN | 10 | 6.86 | -68.59 | 55 | 377.24 | Oct. 1, 2024: 10 @ 6.86 |
| Dec. 8, 2024 | issue | SO-241208-388 | MAIN | 1 | 6.86 | -6.86 | 65 | 445.84 | Oct. 1, 2024: 1 @ 6.86 |
| Nov. 29, 2024 | issue | SO-241129-530 | MAIN | 2 | 6.86 | -13.72 | 66 | 452.69 | Oct. 1, 2024: 2 @ 6.86 |
| Nov. 24, 2024 | issue | SO-241124-731 | MAIN | 1 | 6.86 | -6.86 | 68 | 466.41 | Oct. 1, 2024: 1 @ 6.86 |
| Nov. 22, 2024 | issue | SO-241122-262 | MAIN | 22 | 6.86 | -150.90 | 69 | 473.27 | Oct. 1, 2024: 22 @ 6.86 |
| Nov. 18, 2024 | issue | SO-241118-195 | MAIN | 13 | 6.86 | -89.17 | 91 | 624.17 | Oct. 1, 2024: 13 @ 6.86 |
| Nov. 11, 2024 | issue | SO-241111-803 | MAIN | 7 | 6.86 | -48.01 | 104 | 713.34 | Oct. 1, 2024: 7 @ 6.86 |
| Nov. 10, 2024 | issue | SO-241110-933 | MAIN | 16 | 6.86 | -109.74 | 111 | 761.35 | Oct. 1, 2024: 16 @ 6.86 |
| Oct. 30, 2024 | issue | SO-241030-122 | MAIN | 3 | 6.86 | -20.58 | 127 | 871.09 | Oct. 1, 2024: 3 @ 6.86 |
| Oct. 29, 2024 | issue | SO-241029-935 | MAIN | 1 | 6.86 | -6.86 | 130 | 891.67 | Oct. 1, 2024: 1 @ 6.86 |
| Oct. 20, 2024 | issue | SO-241020-455 | MAIN | 27 | 6.86 | -185.19 | 131 | 898.53 | Oct. 1, 2024: 27 @ 6.86 |
| Oct. 7, 2024 | issue | SO-241007-806 | MAIN | 22 | 6.86 | -150.90 | 158 | 1,083.72 | Oct. 1, 2024: 22 @ 6.86 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 180 | 6.86 | 1,234.62 | 180 | 1,234.62 |