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, latest 60 shown - show all
| 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 |