Items / LED-0008
LED Tube 18W Classic LED-0008 · Lighting · BrightLine Lighting
On hand (EA)63MAIN 63
Value (FIFO)4,796.78avg 76.14
ClassBX / FCV 0.24
Turnover4.6xlast issue 0 days ago
Days of cover75lead 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 | 25.67 / 30.4375 | 0.843 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.13 / 5.517 | 1.111 |
| 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 * 1.111^2 + 0.843^2 * 2.2^2) | 6.4 |
| Reorder point | d * LT + safety stock | 0.843 * 9.6 + 6.4 | 14.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 14.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 308/yr, S = 45.00, h = 20%, price = 76.66 | 42.5 |
| Inventory position | on hand + on order | 63 + 0 | 63 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 76.66 | 43 | 24,247 | yes (chosen if cheapest) |
MOQ 100, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 17, 2026 | 61 / 100 | 76.14 | 4,644.50 | |
| Sept. 27, 2026 | 2 / 2 | 76.14 | 152.28 |
Movement ledger 119 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-946 | MAIN | 4 | 76.14 | -304.56 | 63 | 4,796.78 | Sept. 17, 2026: 4 @ 76.14 |
| Oct. 12, 2026 | issue | SO-261012-247 | MAIN | 19 | 76.14 | -1,446.65 | 67 | 5,101.34 | Sept. 17, 2026: 19 @ 76.14 |
| Oct. 6, 2026 | issue | SO-261006-667 | MAIN | 9 | 76.14 | -685.25 | 86 | 6,547.99 | Sept. 17, 2026: 9 @ 76.14 |
| Sept. 27, 2026 | return | RMA | MAIN | 2 | 76.14 | 152.28 | 95 | 7,233.24 | |
| Sept. 26, 2026 | issue | SO-260926-359 | MAIN | 7 | 76.14 | -532.98 | 93 | 7,080.96 | Sept. 17, 2026: 7 @ 76.14 |
| Sept. 17, 2026 | receipt | PO-001805 | MAIN | 100 | 76.14 | 7,613.94 | 100 | 7,613.94 | |
| Sept. 11, 2026 | issue | SO-260911-955 | MAIN | 7 | 73.99 | -517.91 | 0 | 0.00 | April 19, 2026: 5 @ 73.99; May 23, 2026: 2 @ 73.99 |
| Sept. 9, 2026 | issue | SO-260909-720 | MAIN | 2 | 73.99 | -147.98 | 7 | 517.91 | April 19, 2026: 2 @ 73.99 |
| Sept. 8, 2026 | issue | SO-260908-750 | MAIN | 5 | 73.99 | -369.94 | 9 | 665.89 | April 19, 2026: 5 @ 73.99 |
| Aug. 28, 2026 | issue | SO-260828-929 | MAIN | 7 | 73.99 | -517.91 | 14 | 1,035.82 | April 19, 2026: 7 @ 73.99 |
| Aug. 27, 2026 | issue | SO-260827-732 | MAIN | 2 | 73.99 | -147.98 | 21 | 1,553.74 | April 19, 2026: 2 @ 73.99 |
| Aug. 18, 2026 | issue | SO-260818-110 | MAIN | 8 | 73.99 | -591.90 | 23 | 1,701.71 | April 19, 2026: 8 @ 73.99 |
| Aug. 16, 2026 | issue | SO-260816-133 | MAIN | 4 | 73.99 | -295.95 | 31 | 2,293.61 | April 19, 2026: 4 @ 73.99 |
| Aug. 2, 2026 | issue | SO-260802-381 | MAIN | 3 | 73.99 | -221.96 | 35 | 2,589.56 | April 19, 2026: 3 @ 73.99 |
| July 28, 2026 | issue | SO-260728-315 | MAIN | 18 | 73.99 | -1,331.78 | 38 | 2,811.52 | April 19, 2026: 18 @ 73.99 |
| July 3, 2026 | issue | SO-260703-289 | MAIN | 6 | 73.99 | -443.92 | 56 | 4,143.30 | April 19, 2026: 6 @ 73.99 |
| June 30, 2026 | issue | SO-260630-865 | MAIN | 1 | 73.99 | -73.99 | 62 | 4,587.22 | April 19, 2026: 1 @ 73.99 |
| June 28, 2026 | issue | SO-260628-866 | MAIN | 1 | 73.99 | -73.99 | 63 | 4,661.21 | April 19, 2026: 1 @ 73.99 |
| June 18, 2026 | issue | SO-260618-793 | MAIN | 2 | 73.99 | -147.98 | 64 | 4,735.20 | April 19, 2026: 2 @ 73.99 |
| June 12, 2026 | issue | SO-260612-143 | MAIN | 1 | 73.99 | -73.99 | 66 | 4,883.18 | April 19, 2026: 1 @ 73.99 |
| June 7, 2026 | issue | SO-260607-909 | MAIN | 13 | 73.99 | -961.84 | 67 | 4,957.16 | April 19, 2026: 13 @ 73.99 |
| May 28, 2026 | issue | SO-260528-628 | MAIN | 1 | 73.99 | -73.99 | 80 | 5,919.00 | April 19, 2026: 1 @ 73.99 |
| May 23, 2026 | return | RMA | MAIN | 2 | 73.99 | 147.98 | 81 | 5,992.99 | |
| May 22, 2026 | issue | SO-260522-162 | MAIN | 5 | 73.99 | -369.94 | 79 | 5,845.01 | April 19, 2026: 5 @ 73.99 |
| May 19, 2026 | issue | SO-260519-777 | MAIN | 1 | 73.99 | -73.99 | 84 | 6,214.95 | April 19, 2026: 1 @ 73.99 |
| May 16, 2026 | issue | SO-260516-240 | MAIN | 10 | 73.99 | -739.88 | 85 | 6,288.94 | April 19, 2026: 10 @ 73.99 |
| May 14, 2026 | issue | SO-260514-792 | MAIN | 1 | 73.99 | -73.99 | 95 | 7,028.81 | April 19, 2026: 1 @ 73.99 |
| May 6, 2026 | issue | SO-260506-981 | MAIN | 4 | 73.99 | -295.95 | 96 | 7,102.80 | April 19, 2026: 4 @ 73.99 |
| April 19, 2026 | receipt | PO-001421 | MAIN | 100 | 73.99 | 7,398.75 | 100 | 7,398.75 | |
| April 15, 2026 | issue | SO-260415-171 | MAIN | 7 | 72.16 | -505.10 | 0 | 0.00 | Dec. 24, 2025: 7 @ 72.16 |
| April 12, 2026 | issue | SO-260412-772 | MAIN | 13 | 72.16 | -938.04 | 7 | 505.10 | Dec. 24, 2025: 13 @ 72.16 |
| April 3, 2026 | issue | SO-260403-303 | MAIN | 5 | 72.16 | -360.78 | 20 | 1,443.14 | Dec. 24, 2025: 5 @ 72.16 |
| March 30, 2026 | issue | SO-260330-383 | MAIN | 2 | 72.16 | -144.31 | 25 | 1,803.92 | Dec. 24, 2025: 2 @ 72.16 |
| March 26, 2026 | adjustment | Cycle count | MAIN | -1 | 72.16 | -72.16 | 27 | 1,948.24 | Dec. 24, 2025: 1 @ 72.16 |
| March 16, 2026 | issue | SO-260316-360 | MAIN | 6 | 72.16 | -432.94 | 28 | 2,020.40 | Dec. 24, 2025: 6 @ 72.16 |
| March 2, 2026 | issue | SO-260302-384 | MAIN | 14 | 72.16 | -1,010.20 | 34 | 2,453.34 | Dec. 24, 2025: 14 @ 72.16 |
| Feb. 26, 2026 | issue | SO-260226-678 | MAIN | 4 | 72.16 | -288.63 | 48 | 3,463.54 | Dec. 24, 2025: 4 @ 72.16 |
| Feb. 24, 2026 | issue | SO-260224-238 | MAIN | 1 | 72.16 | -72.16 | 52 | 3,752.16 | Dec. 24, 2025: 1 @ 72.16 |
| Feb. 13, 2026 | issue | SO-260213-190 | MAIN | 4 | 72.16 | -288.63 | 53 | 3,824.32 | Dec. 24, 2025: 4 @ 72.16 |
| Feb. 13, 2026 | issue | SO-260213-190 | EAST | 20 | 72.16 | -1,443.14 | 57 | 4,112.95 | Dec. 24, 2025: 20 @ 72.16 |
| Feb. 12, 2026 | issue | SO-260212-148 | MAIN | 3 | 72.16 | -216.47 | 77 | 5,556.09 | Dec. 24, 2025: 3 @ 72.16 |
| Jan. 30, 2026 | issue | SO-260130-740 | MAIN | 1 | 72.16 | -72.16 | 80 | 5,772.56 | Dec. 24, 2025: 1 @ 72.16 |
| Jan. 26, 2026 | issue | SO-260126-520 | MAIN | 3 | 72.16 | -216.47 | 81 | 5,844.72 | Dec. 24, 2025: 3 @ 72.16 |
| Jan. 23, 2026 | issue | SO-260123-923 | MAIN | 11 | 72.16 | -793.73 | 84 | 6,061.19 | Dec. 24, 2025: 11 @ 72.16 |
| Jan. 20, 2026 | issue | SO-260120-569 | MAIN | 1 | 72.16 | -72.16 | 95 | 6,854.92 | Dec. 24, 2025: 1 @ 72.16 |
| Jan. 17, 2026 | issue | SO-260117-745 | MAIN | 2 | 72.16 | -144.31 | 96 | 6,927.07 | Dec. 24, 2025: 2 @ 72.16 |
| Jan. 11, 2026 | issue | SO-260111-844 | MAIN | 9 | 72.61 | -653.49 | 98 | 7,071.39 | Dec. 9, 2025: 7 @ 72.74; Dec. 24, 2025: 2 @ 72.16 |
| Dec. 28, 2025 | issue | SO-251228-744 | EAST | 1 | 72.74 | -72.74 | 107 | 7,724.87 | Sept. 25, 2025: 1 @ 72.74 |
| Dec. 26, 2025 | issue | SO-251226-491 | MAIN | 7 | 72.74 | -509.17 | 108 | 7,797.61 | Sept. 25, 2025: 7 @ 72.74 |
| Dec. 24, 2025 | transfer | TRF | MAIN → EAST | 21 | warehouse transfer, no cost effect | ||||
| Dec. 24, 2025 | receipt | PO-001079 | MAIN | 100 | 72.16 | 7,215.70 | 115 | 8,306.78 | |
| Dec. 20, 2025 | issue | SO-251220-334 | MAIN | 1 | 72.74 | -72.74 | 15 | 1,091.08 | Sept. 25, 2025: 1 @ 72.74 |
| Dec. 18, 2025 | issue | SO-251218-679 | MAIN | 1 | 72.74 | -72.74 | 16 | 1,163.82 | Sept. 25, 2025: 1 @ 72.74 |
| Dec. 14, 2025 | issue | SO-251214-644 | MAIN | 4 | 72.74 | -290.96 | 17 | 1,236.56 | Sept. 25, 2025: 4 @ 72.74 |
| Dec. 9, 2025 | return | RMA | MAIN | 7 | 72.74 | 509.17 | 21 | 1,527.51 | |
| Dec. 9, 2025 | issue | SO-251209-908 | MAIN | 19 | 72.74 | -1,382.04 | 14 | 1,018.34 | Sept. 25, 2025: 19 @ 72.74 |
| Dec. 3, 2025 | issue | SO-251203-894 | MAIN | 15 | 72.74 | -1,091.08 | 33 | 2,400.38 | Sept. 25, 2025: 15 @ 72.74 |
| Nov. 26, 2025 | issue | SO-251126-925 | MAIN | 2 | 72.74 | -145.48 | 48 | 3,491.46 | Sept. 25, 2025: 2 @ 72.74 |
| Nov. 25, 2025 | issue | SO-251125-695 | MAIN | 5 | 72.74 | -363.69 | 50 | 3,636.94 | Sept. 25, 2025: 5 @ 72.74 |
| Nov. 22, 2025 | issue | SO-251122-912 | MAIN | 3 | 72.74 | -218.22 | 55 | 4,000.63 | Sept. 25, 2025: 3 @ 72.74 |