Items / LED-0027
LED Bulb 12W Prime LED-0027 · Lighting · BrightLine Lighting
On hand (EA)100MAIN 100
Value (FIFO)2,373.50avg 23.74
ClassBX / FCV 0.34
Turnover13.1xlast issue 7 days ago
Days of cover37lead 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 | 82.25 / 30.4375 | 2.702 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 27.56 / 5.517 | 4.996 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(9.6 * 4.996^2 + 2.702^2 * 2.2^2) | 27.2 |
| Reorder point | d * LT + safety stock | 2.702 * 9.6 + 27.2 | 53.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 53.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 986/yr, S = 45.00, h = 20%, price = 23.91 | 136.2 |
| Inventory position | on hand + on order | 100 + 0 | 100 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 23.91 | 136 | 24,235 | yes (chosen if cheapest) |
MOQ 360, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 15, 2026 | 95 / 360 | 23.74 | 2,254.82 | |
| Aug. 29, 2026 | 3 / 3 | 23.74 | 71.20 | |
| Sept. 14, 2026 | 2 / 2 | 23.74 | 47.47 |
Movement ledger 130 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-583 | MAIN | 15 | 23.74 | -356.02 | 100 | 2,373.50 | July 15, 2026: 15 @ 23.74 |
| Oct. 5, 2026 | issue | SO-261005-716 | MAIN | 23 | 23.74 | -545.90 | 115 | 2,729.52 | July 15, 2026: 23 @ 23.74 |
| Oct. 1, 2026 | issue | SO-261001-685 | MAIN | 47 | 23.74 | -1,115.54 | 138 | 3,275.43 | July 15, 2026: 47 @ 23.74 |
| Sept. 29, 2026 | issue | SO-260929-891 | MAIN | 45 | 23.74 | -1,068.08 | 185 | 4,390.98 | July 15, 2026: 45 @ 23.74 |
| Sept. 24, 2026 | issue | SO-260924-318 | MAIN | 7 | 23.74 | -166.14 | 230 | 5,459.05 | July 15, 2026: 7 @ 23.74 |
| Sept. 14, 2026 | return | RMA | MAIN | 2 | 23.74 | 47.47 | 237 | 5,625.20 | |
| Sept. 9, 2026 | issue | SO-260909-545 | MAIN | 15 | 23.74 | -356.02 | 235 | 5,577.72 | July 15, 2026: 15 @ 23.74 |
| Sept. 7, 2026 | issue | SO-260907-370 | MAIN | 6 | 23.74 | -142.41 | 250 | 5,933.75 | July 15, 2026: 6 @ 23.74 |
| Sept. 6, 2026 | issue | SO-260906-732 | MAIN | 9 | 23.74 | -213.62 | 256 | 6,076.16 | July 15, 2026: 9 @ 23.74 |
| Sept. 5, 2026 | issue | SO-260905-306 | MAIN | 27 | 23.74 | -640.84 | 265 | 6,289.78 | July 15, 2026: 27 @ 23.74 |
| Sept. 2, 2026 | issue | SO-260902-453 | MAIN | 5 | 23.74 | -118.68 | 292 | 6,930.62 | July 15, 2026: 5 @ 23.74 |
| Aug. 31, 2026 | issue | SO-260831-293 | MAIN | 5 | 23.74 | -118.68 | 297 | 7,049.30 | July 15, 2026: 5 @ 23.74 |
| Aug. 29, 2026 | return | RMA | MAIN | 3 | 23.74 | 71.20 | 302 | 7,167.97 | |
| Aug. 27, 2026 | issue | SO-260827-189 | MAIN | 4 | 23.74 | -94.94 | 299 | 7,096.76 | July 15, 2026: 4 @ 23.74 |
| Aug. 19, 2026 | issue | SO-260819-225 | MAIN | 2 | 23.74 | -47.47 | 303 | 7,191.70 | July 15, 2026: 2 @ 23.74 |
| Aug. 16, 2026 | issue | SO-260816-772 | MAIN | 9 | 23.74 | -213.62 | 305 | 7,239.18 | July 15, 2026: 9 @ 23.74 |
| Aug. 13, 2026 | issue | SO-260813-975 | MAIN | 7 | 23.74 | -166.14 | 314 | 7,452.79 | July 15, 2026: 7 @ 23.74 |
| Aug. 2, 2026 | issue | SO-260802-472 | MAIN | 38 | 23.74 | -901.93 | 321 | 7,618.94 | July 15, 2026: 38 @ 23.74 |
| July 25, 2026 | issue | SO-260725-891 | MAIN | 1 | 23.74 | -23.74 | 359 | 8,520.86 | July 15, 2026: 1 @ 23.74 |
| July 15, 2026 | receipt | PO-001646 | MAIN | 360 | 23.74 | 8,544.60 | 360 | 8,544.60 | |
| July 4, 2026 | issue | SO-260704-159 | MAIN | 43 | 23.89 | -1,027.43 | 0 | 0.00 | Feb. 27, 2026: 41 @ 23.89; May 15, 2026: 2 @ 23.89 |
| June 30, 2026 | issue | SO-260630-484 | MAIN | 27 | 23.89 | -645.13 | 43 | 1,027.43 | Feb. 27, 2026: 27 @ 23.89 |
| June 10, 2026 | issue | SO-260610-206 | MAIN | 19 | 23.89 | -453.98 | 70 | 1,672.57 | Feb. 27, 2026: 19 @ 23.89 |
| June 3, 2026 | issue | SO-260603-981 | MAIN | 15 | 23.89 | -358.41 | 89 | 2,126.55 | Feb. 27, 2026: 15 @ 23.89 |
| May 15, 2026 | return | RMA | MAIN | 2 | 23.89 | 47.79 | 104 | 2,484.96 | |
| May 9, 2026 | issue | SO-260509-585 | MAIN | 2 | 23.89 | -47.79 | 102 | 2,437.17 | Feb. 27, 2026: 2 @ 23.89 |
| May 1, 2026 | issue | SO-260501-315 | MAIN | 56 | 23.89 | -1,338.05 | 104 | 2,484.96 | Feb. 27, 2026: 56 @ 23.89 |
| April 30, 2026 | issue | SO-260430-231 | MAIN | 4 | 23.89 | -95.58 | 160 | 3,823.01 | Feb. 27, 2026: 4 @ 23.89 |
| April 22, 2026 | issue | SO-260422-606 | MAIN | 19 | 23.89 | -453.98 | 164 | 3,918.58 | Feb. 27, 2026: 19 @ 23.89 |
| April 20, 2026 | issue | SO-260420-782 | MAIN | 10 | 23.89 | -238.94 | 183 | 4,372.57 | Feb. 27, 2026: 10 @ 23.89 |
| April 16, 2026 | issue | SO-260416-900 | MAIN | 11 | 23.89 | -262.83 | 193 | 4,611.50 | Feb. 27, 2026: 11 @ 23.89 |
| April 8, 2026 | issue | SO-260408-174 | MAIN | 4 | 23.89 | -95.58 | 204 | 4,874.34 | Feb. 27, 2026: 4 @ 23.89 |
| April 5, 2026 | issue | SO-260405-511 | MAIN | 43 | 23.89 | -1,027.43 | 208 | 4,969.91 | Feb. 27, 2026: 43 @ 23.89 |
| April 5, 2026 | issue | SO-260405-511 | EAST | 12 | 23.89 | -286.73 | 251 | 5,997.34 | Feb. 27, 2026: 12 @ 23.89 |
| March 16, 2026 | issue | SO-260316-549 | EAST | 107 | 23.85 | -2,552.22 | 263 | 6,284.07 | Oct. 28, 2025: 6 @ 23.45; Jan. 13, 2026: 4 @ 23.45; Feb. 27, 2026: 97 @ 23.89 |
| March 1, 2026 | issue | SO-260301-723 | MAIN | 5 | 23.45 | -117.26 | 370 | 8,836.29 | Oct. 28, 2025: 5 @ 23.45 |
| Feb. 27, 2026 | issue | SO-260227-165 | MAIN | 29 | 23.45 | -680.11 | 375 | 8,953.55 | Oct. 28, 2025: 29 @ 23.45 |
| Feb. 27, 2026 | transfer | TRF | MAIN → EAST | 90 | warehouse transfer, no cost effect | ||||
| Feb. 27, 2026 | receipt | PO-001262 | MAIN | 360 | 23.89 | 8,601.77 | 404 | 9,633.66 | |
| Feb. 20, 2026 | issue | SO-260220-222 | MAIN | 13 | 23.45 | -304.88 | 44 | 1,031.89 | Oct. 28, 2025: 13 @ 23.45 |
| Feb. 15, 2026 | issue | SO-260215-782 | MAIN | 4 | 23.45 | -93.81 | 57 | 1,336.77 | Oct. 28, 2025: 4 @ 23.45 |
| Feb. 14, 2026 | issue | SO-260214-156 | MAIN | 25 | 23.45 | -586.30 | 61 | 1,430.58 | Oct. 28, 2025: 25 @ 23.45 |
| Jan. 30, 2026 | issue | SO-260130-561 | MAIN | 5 | 23.45 | -117.26 | 86 | 2,016.88 | Oct. 28, 2025: 5 @ 23.45 |
| Jan. 27, 2026 | issue | SO-260127-839 | MAIN | 22 | 23.45 | -515.95 | 91 | 2,134.14 | Oct. 28, 2025: 22 @ 23.45 |
| Jan. 26, 2026 | issue | SO-260126-833 | EAST | 13 | 23.45 | -304.88 | 113 | 2,650.09 | Oct. 28, 2025: 13 @ 23.45 |
| Jan. 19, 2026 | issue | SO-260119-683 | MAIN | 3 | 23.45 | -70.36 | 126 | 2,954.96 | Oct. 28, 2025: 3 @ 23.45 |
| Jan. 13, 2026 | return | RMA | MAIN | 4 | 23.45 | 93.81 | 129 | 3,025.32 | |
| Jan. 3, 2026 | adjustment | Cycle count | MAIN | -2 | 23.45 | -46.90 | 125 | 2,931.51 | Oct. 28, 2025: 2 @ 23.45 |
| Jan. 2, 2026 | issue | SO-260102-990 | MAIN | 23 | 23.45 | -539.40 | 127 | 2,978.42 | Oct. 28, 2025: 23 @ 23.45 |
| Jan. 1, 2026 | issue | SO-260101-184 | MAIN | 9 | 23.45 | -211.07 | 150 | 3,517.82 | Oct. 28, 2025: 9 @ 23.45 |
| Dec. 26, 2025 | issue | SO-251226-610 | MAIN | 70 | 23.45 | -1,641.65 | 159 | 3,728.88 | Oct. 28, 2025: 70 @ 23.45 |
| Dec. 21, 2025 | issue | SO-251221-649 | MAIN | 6 | 23.45 | -140.71 | 229 | 5,370.53 | Oct. 28, 2025: 6 @ 23.45 |
| Dec. 12, 2025 | issue | SO-251212-588 | EAST | 22 | 23.45 | -515.95 | 235 | 5,511.24 | Oct. 28, 2025: 22 @ 23.45 |
| Dec. 11, 2025 | issue | SO-251211-822 | EAST | 23 | 23.45 | -539.40 | 257 | 6,027.19 | Oct. 28, 2025: 23 @ 23.45 |
| Dec. 5, 2025 | issue | SO-251205-170 | EAST | 10 | 23.45 | -234.52 | 280 | 6,566.59 | Oct. 28, 2025: 10 @ 23.45 |
| Dec. 4, 2025 | issue | SO-251204-552 | MAIN | 11 | 23.45 | -257.97 | 290 | 6,801.11 | Oct. 28, 2025: 11 @ 23.45 |
| Nov. 30, 2025 | issue | SO-251130-544 | MAIN | 12 | 23.45 | -281.43 | 301 | 7,059.08 | Oct. 28, 2025: 12 @ 23.45 |
| Nov. 18, 2025 | issue | SO-251118-916 | MAIN | 6 | 23.45 | -140.71 | 313 | 7,340.51 | Oct. 28, 2025: 6 @ 23.45 |
| Nov. 10, 2025 | issue | SO-251110-594 | MAIN | 29 | 23.45 | -680.11 | 319 | 7,481.22 | Oct. 28, 2025: 29 @ 23.45 |
| Nov. 8, 2025 | issue | SO-251108-533 | MAIN | 27 | 23.06 | -622.51 | 348 | 8,161.33 | May 25, 2025: 6 @ 22.74; June 18, 2025: 1 @ 22.74; Oct. 12, 2025: 8 @ 22.74; Oct. 28, 2025: 12 @ 23.45 |