Items / LED-0034
LED Tube 18W Classic LED-0034 · Lighting · BrightLine Lighting
On hand (EA)383MAIN 326, EAST 57
Value (FIFO)64,500.99avg 168.41
ClassAX / FCV 0.13
Turnover6.0xlast issue 6 days ago
Days of cover60lead 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 | 194.33 / 30.4375 | 6.385 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 24.71 / 5.517 | 4.478 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(9.6 * 4.478^2 + 6.385^2 * 2.2^2) | 40.2 |
| Reorder point | d * LT + safety stock | 6.385 * 9.6 + 40.2 | 101.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 101.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2330/yr, S = 45.00, h = 20%, price = 168.46 | 78.9 |
| Inventory position | on hand + on order | 383 + 0 | 383 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 168.46 | 79 | 395,238 | yes (chosen if cheapest) |
MOQ 770, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 29, 2026 | 373 / 770 | 168.41 | 62,816.89 | |
| Sept. 12, 2026 | 10 / 10 | 168.41 | 1,684.10 |
Movement ledger 122 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 10, 2026 | issue | SO-261010-480 | MAIN | 35 | 168.41 | -5,894.35 | 383 | 64,500.99 | Aug. 29, 2026: 35 @ 168.41 |
| Oct. 6, 2026 | issue | SO-261006-168 | MAIN | 59 | 168.41 | -9,936.18 | 418 | 70,395.34 | Aug. 29, 2026: 59 @ 168.41 |
| Oct. 3, 2026 | issue | SO-261003-727 | MAIN | 160 | 168.41 | -26,945.58 | 477 | 80,331.52 | Aug. 29, 2026: 160 @ 168.41 |
| Sept. 28, 2026 | issue | SO-260928-843 | MAIN | 13 | 168.41 | -2,189.33 | 637 | 107,277.11 | Aug. 29, 2026: 13 @ 168.41 |
| Sept. 18, 2026 | issue | SO-260918-928 | EAST | 1 | 168.41 | -168.41 | 650 | 109,466.44 | Aug. 29, 2026: 1 @ 168.41 |
| Sept. 16, 2026 | issue | SO-260916-831 | MAIN | 26 | 168.41 | -4,378.66 | 651 | 109,634.84 | Aug. 29, 2026: 26 @ 168.41 |
| Sept. 14, 2026 | issue | SO-260914-307 | MAIN | 39 | 168.41 | -6,567.99 | 677 | 114,013.50 | Aug. 29, 2026: 39 @ 168.41 |
| Sept. 12, 2026 | return | RMA | MAIN | 10 | 168.41 | 1,684.10 | 716 | 120,581.49 | |
| Sept. 9, 2026 | issue | SO-260909-915 | MAIN | 6 | 168.41 | -1,010.46 | 706 | 118,897.39 | Aug. 29, 2026: 6 @ 168.41 |
| Sept. 7, 2026 | issue | SO-260907-428 | EAST | 21 | 168.41 | -3,536.61 | 712 | 119,907.85 | Aug. 29, 2026: 21 @ 168.41 |
| Sept. 4, 2026 | issue | SO-260904-714 | EAST | 81 | 169.10 | -13,696.89 | 733 | 123,444.46 | May 5, 2026: 36 @ 169.68; June 4, 2026: 8 @ 169.68; Aug. 29, 2026: 37 @ 168.41 |
| Aug. 29, 2026 | transfer | TRF | MAIN → EAST | 160 | warehouse transfer, no cost effect | ||||
| Aug. 29, 2026 | receipt | PO-001756 | MAIN | 770 | 168.41 | 129,675.62 | 814 | 137,141.34 | |
| Aug. 25, 2026 | issue | SO-260825-415 | MAIN | 4 | 169.68 | -678.70 | 44 | 7,465.72 | May 5, 2026: 4 @ 169.68 |
| Aug. 20, 2026 | issue | SO-260820-400 | MAIN | 97 | 169.68 | -16,458.52 | 48 | 8,144.42 | May 5, 2026: 97 @ 169.68 |
| Aug. 13, 2026 | issue | SO-260813-201 | MAIN | 5 | 169.68 | -848.38 | 145 | 24,602.95 | May 5, 2026: 5 @ 169.68 |
| Aug. 12, 2026 | issue | SO-260812-203 | MAIN | 47 | 169.68 | -7,974.75 | 150 | 25,451.32 | May 5, 2026: 47 @ 169.68 |
| Aug. 7, 2026 | issue | SO-260807-745 | MAIN | 76 | 169.68 | -12,895.34 | 197 | 33,426.07 | May 5, 2026: 76 @ 169.68 |
| July 30, 2026 | issue | SO-260730-291 | MAIN | 16 | 169.68 | -2,714.81 | 273 | 46,321.41 | May 5, 2026: 16 @ 169.68 |
| July 29, 2026 | issue | SO-260729-602 | MAIN | 37 | 169.68 | -6,277.99 | 289 | 49,036.22 | May 5, 2026: 37 @ 169.68 |
| July 22, 2026 | issue | SO-260722-130 | MAIN | 49 | 169.68 | -8,314.10 | 326 | 55,314.21 | May 5, 2026: 49 @ 169.68 |
| July 7, 2026 | issue | SO-260707-619 | MAIN | 39 | 169.68 | -6,617.34 | 375 | 63,628.31 | May 5, 2026: 39 @ 169.68 |
| July 6, 2026 | issue | SO-260706-125 | MAIN | 50 | 169.68 | -8,483.78 | 414 | 70,245.66 | May 5, 2026: 50 @ 169.68 |
| June 29, 2026 | issue | SO-260629-695 | MAIN | 23 | 169.68 | -3,902.54 | 464 | 78,729.43 | May 5, 2026: 23 @ 169.68 |
| June 28, 2026 | issue | SO-260628-381 | MAIN | 35 | 169.68 | -5,938.64 | 487 | 82,631.97 | May 5, 2026: 35 @ 169.68 |
| June 16, 2026 | issue | SO-260616-877 | MAIN | 77 | 169.68 | -13,065.01 | 522 | 88,570.61 | May 5, 2026: 77 @ 169.68 |
| June 11, 2026 | issue | SO-260611-314 | MAIN | 40 | 169.68 | -6,787.02 | 599 | 101,635.62 | May 5, 2026: 40 @ 169.68 |
| June 4, 2026 | return | RMA | MAIN | 8 | 169.68 | 1,357.40 | 639 | 108,422.64 | |
| May 29, 2026 | issue | SO-260529-213 | MAIN | 90 | 169.68 | -15,270.80 | 631 | 107,065.24 | May 5, 2026: 90 @ 169.68 |
| May 28, 2026 | issue | SO-260528-207 | MAIN | 17 | 169.68 | -2,884.48 | 721 | 122,336.04 | May 5, 2026: 17 @ 169.68 |
| May 27, 2026 | issue | SO-260527-778 | MAIN | 11 | 169.68 | -1,866.43 | 738 | 125,220.52 | May 5, 2026: 11 @ 169.68 |
| May 25, 2026 | issue | SO-260525-882 | MAIN | 4 | 169.68 | -678.70 | 749 | 127,086.95 | May 5, 2026: 4 @ 169.68 |
| May 20, 2026 | issue | SO-260520-957 | MAIN | 17 | 169.68 | -2,884.48 | 753 | 127,765.65 | May 5, 2026: 17 @ 169.68 |
| May 5, 2026 | receipt | PO-001464 | MAIN | 770 | 169.68 | 130,650.14 | 770 | 130,650.14 | |
| May 4, 2026 | issue | SO-260504-814 | MAIN | 37 | 159.61 | -5,905.58 | 0 | 0.00 | Dec. 27, 2025: 16 @ 161.58; Jan. 1, 2026: 17 @ 157.29; Feb. 3, 2026: 4 @ 161.58 |
| April 26, 2026 | issue | SO-260426-209 | MAIN | 97 | 161.58 | -15,673.39 | 37 | 5,905.58 | Dec. 27, 2025: 97 @ 161.58 |
| April 11, 2026 | issue | SO-260411-737 | MAIN | 22 | 161.58 | -3,554.79 | 134 | 21,578.97 | Dec. 27, 2025: 22 @ 161.58 |
| April 8, 2026 | issue | SO-260408-516 | MAIN | 13 | 161.58 | -2,100.56 | 156 | 25,133.76 | Dec. 27, 2025: 13 @ 161.58 |
| April 8, 2026 | issue | SO-260408-516 | EAST | 40 | 161.58 | -6,463.25 | 169 | 27,234.31 | Dec. 27, 2025: 40 @ 161.58 |
| April 3, 2026 | issue | SO-260403-184 | MAIN | 4 | 161.58 | -646.33 | 209 | 33,697.57 | Dec. 27, 2025: 4 @ 161.58 |
| March 29, 2026 | issue | SO-260329-169 | EAST | 57 | 161.58 | -9,210.13 | 213 | 34,343.89 | Dec. 27, 2025: 57 @ 161.58 |
| March 27, 2026 | issue | SO-260327-574 | EAST | 97 | 161.58 | -15,673.39 | 270 | 43,554.03 | Dec. 27, 2025: 97 @ 161.58 |
| March 22, 2026 | issue | SO-260322-997 | MAIN | 15 | 161.58 | -2,423.72 | 367 | 59,227.41 | Dec. 27, 2025: 15 @ 161.58 |
| March 19, 2026 | issue | SO-260319-542 | MAIN | 10 | 161.58 | -1,615.81 | 382 | 61,651.13 | Dec. 27, 2025: 10 @ 161.58 |
| March 16, 2026 | issue | SO-260316-403 | MAIN | 5 | 161.58 | -807.91 | 392 | 63,266.94 | Dec. 27, 2025: 5 @ 161.58 |
| March 14, 2026 | issue | SO-260314-207 | MAIN | 14 | 161.58 | -2,262.14 | 397 | 64,074.85 | Dec. 27, 2025: 14 @ 161.58 |
| Feb. 23, 2026 | issue | SO-260223-626 | MAIN | 78 | 161.58 | -12,603.34 | 411 | 66,336.99 | Dec. 27, 2025: 78 @ 161.58 |
| Feb. 21, 2026 | issue | SO-260221-346 | EAST | 63 | 161.58 | -10,179.62 | 489 | 78,940.33 | Dec. 27, 2025: 63 @ 161.58 |
| Feb. 19, 2026 | issue | SO-260219-511 | MAIN | 62 | 161.58 | -10,018.04 | 552 | 89,119.95 | Dec. 27, 2025: 62 @ 161.58 |
| Feb. 3, 2026 | return | RMA | MAIN | 4 | 161.58 | 646.33 | 614 | 99,137.99 | |
| Jan. 31, 2026 | issue | SO-260131-201 | MAIN | 3 | 161.58 | -484.74 | 610 | 98,491.67 | Dec. 27, 2025: 3 @ 161.58 |
| Jan. 20, 2026 | issue | SO-260120-154 | MAIN | 90 | 161.58 | -14,542.32 | 613 | 98,976.41 | Dec. 27, 2025: 90 @ 161.58 |
| Jan. 19, 2026 | issue | SO-260119-429 | MAIN | 47 | 161.58 | -7,594.32 | 703 | 113,518.73 | Dec. 27, 2025: 47 @ 161.58 |
| Jan. 18, 2026 | issue | SO-260118-419 | MAIN | 41 | 161.16 | -6,607.67 | 750 | 121,113.05 | Sept. 4, 2025: 4 @ 157.29; Dec. 27, 2025: 37 @ 161.58 |
| Jan. 14, 2026 | issue | SO-260114-332 | MAIN | 8 | 157.29 | -1,258.33 | 791 | 127,720.72 | Sept. 4, 2025: 8 @ 157.29 |
| Jan. 5, 2026 | issue | SO-260105-167 | MAIN | 6 | 157.29 | -943.75 | 799 | 128,979.06 | Sept. 4, 2025: 6 @ 157.29 |
| Jan. 1, 2026 | return | RMA | MAIN | 17 | 157.29 | 2,673.96 | 805 | 129,922.81 | |
| Dec. 27, 2025 | transfer | TRF | MAIN → EAST | 257 | warehouse transfer, no cost effect | ||||
| Dec. 27, 2025 | receipt | PO-001093 | MAIN | 770 | 161.58 | 124,417.60 | 788 | 127,248.85 | |
| Dec. 17, 2025 | issue | SO-251217-773 | MAIN | 177 | 157.29 | -27,840.61 | 18 | 2,831.25 | Sept. 4, 2025: 177 @ 157.29 |