Items / LED-0025
LED Tube 18W Flex LED-0025 · Lighting · BrightLine Lighting
On hand (EA)169MAIN 119, EAST 50
Value (FIFO)3,306.20avg 19.56
ClassCX / FCV 0.23
Turnover5.7xlast issue 1 days ago
Days of cover114lead 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 | 45.00 / 30.4375 | 1.478 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 10.47 / 5.517 | 1.898 |
| 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 * 1.898^2 + 1.478^2 * 2.2^2) | 8.6 |
| Reorder point | d * LT + safety stock | 1.478 * 9.6 + 8.6 | 22.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 22.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 540/yr, S = 45.00, h = 20%, price = 20.06 | 110.0 |
| Inventory position | on hand + on order | 169 + 0 | 169 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 20.06 | 110 | 11,266 | yes (chosen if cheapest) |
MOQ 170, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 11, 2026 | 169 / 170 | 19.56 | 3,306.20 |
Movement ledger 132 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-892 | MAIN | 1 | 19.56 | -19.56 | 169 | 3,306.20 | Oct. 11, 2026: 1 @ 19.56 |
| Oct. 11, 2026 | transfer | TRF | MAIN → EAST | 50 | warehouse transfer, no cost effect | ||||
| Oct. 11, 2026 | receipt | PO-001868 | MAIN | 170 | 19.56 | 3,325.76 | 170 | 3,325.76 | |
| Oct. 2, 2026 | issue | SO-261002-318 | MAIN | 39 | 20.34 | -793.10 | 0 | 0.00 | July 11, 2026: 39 @ 20.34 |
| Sept. 21, 2026 | issue | SO-260921-704 | MAIN | 3 | 20.34 | -61.01 | 39 | 793.10 | July 11, 2026: 3 @ 20.34 |
| Sept. 20, 2026 | issue | SO-260920-226 | MAIN | 2 | 20.34 | -40.67 | 42 | 854.11 | July 11, 2026: 2 @ 20.34 |
| Sept. 16, 2026 | issue | SO-260916-316 | MAIN | 2 | 20.34 | -40.67 | 44 | 894.78 | July 11, 2026: 2 @ 20.34 |
| Sept. 14, 2026 | issue | SO-260914-316 | MAIN | 3 | 20.34 | -61.01 | 46 | 935.46 | July 11, 2026: 3 @ 20.34 |
| Sept. 13, 2026 | issue | SO-260913-363 | MAIN | 18 | 20.34 | -366.05 | 49 | 996.46 | July 11, 2026: 18 @ 20.34 |
| Sept. 6, 2026 | issue | SO-260906-457 | MAIN | 1 | 20.34 | -20.34 | 67 | 1,362.51 | July 11, 2026: 1 @ 20.34 |
| Sept. 4, 2026 | issue | SO-260904-273 | MAIN | 21 | 20.34 | -427.06 | 68 | 1,382.85 | July 11, 2026: 21 @ 20.34 |
| Aug. 17, 2026 | issue | SO-260817-955 | MAIN | 5 | 20.34 | -101.68 | 89 | 1,809.90 | July 11, 2026: 5 @ 20.34 |
| Aug. 17, 2026 | issue | SO-260817-955 | EAST | 34 | 20.34 | -691.42 | 94 | 1,911.58 | July 11, 2026: 34 @ 20.34 |
| Aug. 2, 2026 | issue | SO-260802-285 | MAIN | 13 | 20.34 | -264.37 | 128 | 2,603.01 | July 11, 2026: 13 @ 20.34 |
| July 31, 2026 | issue | SO-260731-486 | MAIN | 2 | 20.34 | -40.67 | 141 | 2,867.38 | July 11, 2026: 2 @ 20.34 |
| July 26, 2026 | issue | SO-260726-956 | MAIN | 10 | 20.34 | -203.36 | 143 | 2,908.05 | July 11, 2026: 10 @ 20.34 |
| July 20, 2026 | issue | SO-260720-473 | MAIN | 2 | 20.34 | -40.67 | 153 | 3,111.41 | July 11, 2026: 2 @ 20.34 |
| July 11, 2026 | issue | SO-260711-628 | MAIN | 15 | 20.34 | -305.04 | 155 | 3,152.08 | July 11, 2026: 15 @ 20.34 |
| July 11, 2026 | transfer | TRF | MAIN → EAST | 34 | warehouse transfer, no cost effect | ||||
| July 11, 2026 | receipt | PO-001640 | MAIN | 170 | 20.34 | 3,457.12 | 170 | 3,457.12 | |
| July 2, 2026 | issue | SO-260702-223 | MAIN | 8 | 20.02 | -160.16 | 0 | 0.00 | Feb. 11, 2026: 5 @ 20.02; March 28, 2026: 1 @ 20.02; April 14, 2026: 1 @ 20.02; June 1, 2026: 1 @ 20.02 |
| June 30, 2026 | issue | SO-260630-133 | MAIN | 13 | 20.02 | -260.26 | 8 | 160.16 | Feb. 11, 2026: 13 @ 20.02 |
| June 28, 2026 | issue | SO-260628-542 | MAIN | 2 | 20.02 | -40.04 | 21 | 420.42 | Feb. 11, 2026: 2 @ 20.02 |
| June 26, 2026 | issue | SO-260626-537 | MAIN | 2 | 20.02 | -40.04 | 23 | 460.46 | Feb. 11, 2026: 2 @ 20.02 |
| June 20, 2026 | issue | SO-260620-984 | MAIN | 6 | 20.02 | -120.12 | 25 | 500.50 | Feb. 11, 2026: 6 @ 20.02 |
| June 15, 2026 | issue | SO-260615-124 | MAIN | 2 | 20.02 | -40.04 | 31 | 620.61 | Feb. 11, 2026: 2 @ 20.02 |
| June 11, 2026 | issue | SO-260611-881 | MAIN | 2 | 20.02 | -40.04 | 33 | 660.65 | Feb. 11, 2026: 2 @ 20.02 |
| June 10, 2026 | issue | SO-260610-399 | MAIN | 7 | 20.02 | -140.14 | 35 | 700.69 | Feb. 11, 2026: 7 @ 20.02 |
| June 1, 2026 | return | RMA | MAIN | 1 | 20.02 | 20.02 | 42 | 840.83 | |
| May 26, 2026 | issue | SO-260526-111 | MAIN | 1 | 20.02 | -20.02 | 41 | 820.81 | Feb. 11, 2026: 1 @ 20.02 |
| May 24, 2026 | issue | SO-260524-607 | MAIN | 1 | 20.02 | -20.02 | 42 | 840.83 | Feb. 11, 2026: 1 @ 20.02 |
| May 17, 2026 | issue | SO-260517-986 | MAIN | 21 | 20.02 | -420.42 | 43 | 860.85 | Feb. 11, 2026: 21 @ 20.02 |
| May 13, 2026 | issue | SO-260513-351 | MAIN | 5 | 20.02 | -100.10 | 64 | 1,281.27 | Feb. 11, 2026: 5 @ 20.02 |
| May 4, 2026 | issue | SO-260504-365 | MAIN | 2 | 20.02 | -40.04 | 69 | 1,381.37 | Feb. 11, 2026: 2 @ 20.02 |
| May 3, 2026 | issue | SO-260503-370 | MAIN | 7 | 20.02 | -140.14 | 71 | 1,421.41 | Feb. 11, 2026: 7 @ 20.02 |
| April 25, 2026 | issue | SO-260425-208 | MAIN | 11 | 20.02 | -220.22 | 78 | 1,561.54 | Feb. 11, 2026: 11 @ 20.02 |
| April 23, 2026 | issue | SO-260423-969 | MAIN | 8 | 20.02 | -160.16 | 89 | 1,781.76 | Feb. 11, 2026: 8 @ 20.02 |
| April 16, 2026 | issue | SO-260416-937 | MAIN | 1 | 20.02 | -20.02 | 97 | 1,941.92 | Feb. 11, 2026: 1 @ 20.02 |
| April 14, 2026 | return | RMA | MAIN | 1 | 20.02 | 20.02 | 98 | 1,961.94 | |
| April 11, 2026 | issue | SO-260411-214 | MAIN | 6 | 20.02 | -120.12 | 97 | 1,941.92 | Feb. 11, 2026: 6 @ 20.02 |
| April 5, 2026 | issue | SO-260405-858 | MAIN | 10 | 20.02 | -200.20 | 103 | 2,062.04 | Feb. 11, 2026: 10 @ 20.02 |
| March 28, 2026 | return | RMA | MAIN | 1 | 20.02 | 20.02 | 113 | 2,262.24 | |
| March 27, 2026 | issue | SO-260327-645 | MAIN | 1 | 20.02 | -20.02 | 112 | 2,242.22 | Feb. 11, 2026: 1 @ 20.02 |
| March 24, 2026 | issue | SO-260324-167 | MAIN | 1 | 20.02 | -20.02 | 113 | 2,262.24 | Feb. 11, 2026: 1 @ 20.02 |
| March 19, 2026 | issue | SO-260319-345 | MAIN | 2 | 20.02 | -40.04 | 114 | 2,282.26 | Feb. 11, 2026: 2 @ 20.02 |
| March 16, 2026 | issue | SO-260316-556 | MAIN | 6 | 20.02 | -120.12 | 116 | 2,322.30 | Feb. 11, 2026: 6 @ 20.02 |
| March 14, 2026 | issue | SO-260314-168 | MAIN | 11 | 20.02 | -220.22 | 122 | 2,442.42 | Feb. 11, 2026: 11 @ 20.02 |
| March 5, 2026 | issue | SO-260305-879 | MAIN | 6 | 20.02 | -120.12 | 133 | 2,662.63 | Feb. 11, 2026: 6 @ 20.02 |
| March 2, 2026 | issue | SO-260302-296 | MAIN | 5 | 20.02 | -100.10 | 139 | 2,782.75 | Feb. 11, 2026: 5 @ 20.02 |
| Feb. 22, 2026 | issue | SO-260222-599 | MAIN | 15 | 20.02 | -300.30 | 144 | 2,882.85 | Feb. 11, 2026: 15 @ 20.02 |
| Feb. 15, 2026 | issue | SO-260215-923 | MAIN | 7 | 20.02 | -140.14 | 159 | 3,183.15 | Feb. 11, 2026: 7 @ 20.02 |
| Feb. 11, 2026 | issue | SO-260211-466 | MAIN | 11 | 19.42 | -213.62 | 166 | 3,323.29 | Oct. 30, 2025: 2 @ 19.08; Jan. 8, 2026: 5 @ 19.08; Feb. 11, 2026: 4 @ 20.02 |
| Feb. 11, 2026 | receipt | PO-001215 | MAIN | 170 | 20.02 | 3,403.37 | 177 | 3,536.91 | |
| Feb. 10, 2026 | issue | SO-260210-436 | MAIN | 4 | 19.08 | -76.31 | 7 | 133.54 | Oct. 30, 2025: 4 @ 19.08 |
| Feb. 4, 2026 | issue | SO-260204-140 | MAIN | 6 | 19.08 | -114.47 | 11 | 209.86 | Oct. 30, 2025: 6 @ 19.08 |
| Jan. 29, 2026 | issue | SO-260129-769 | MAIN | 19 | 19.08 | -362.48 | 17 | 324.32 | Oct. 30, 2025: 19 @ 19.08 |
| Jan. 27, 2026 | issue | SO-260127-994 | MAIN | 31 | 19.08 | -591.41 | 36 | 686.80 | Oct. 30, 2025: 31 @ 19.08 |
| Jan. 8, 2026 | return | RMA | MAIN | 5 | 19.08 | 95.39 | 67 | 1,278.21 | |
| Jan. 4, 2026 | issue | SO-260104-290 | MAIN | 11 | 19.08 | -209.86 | 62 | 1,182.82 | Oct. 30, 2025: 11 @ 19.08 |
| Dec. 19, 2025 | issue | SO-251219-577 | MAIN | 6 | 19.08 | -114.47 | 73 | 1,392.68 | Oct. 30, 2025: 6 @ 19.08 |