stocksense

Items / LED-0024

LED Tube 18W Plus LED-0024 · Lighting · BrightLine Lighting

On hand (EA)96MAIN 96
Value (FIFO)1,795.56avg 18.70
ClassBX / FCV 0.34
Turnover7.8xlast issue 0 days ago
Days of cover35lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00240.039.979.8120160Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 49.0Nov 24: 90.0Dec 24: 120.0Jan 25: 91.0Feb 25: 87.0Mar 25: 94.0Apr 25: 69.0May 25: 83.0Jun 25: 59.0Jul 25: 58.0Aug 25: 117.0Sep 25: 75.0Oct 25: 125.0Nov 25: 106.0Dec 25: 145.0Jan 26: 74.0Feb 26: 61.0Mar 26: 50.0Apr 26: 77.0May 26: 58.0Jun 26: 64.0Jul 26: 66.0Aug 26: 71.0Sep 26: 92.0

actual forecast 90% prediction interval

No forecast run yet for this item. Run forecasts. Policy numbers use trailing 12-month demand.

Policy numbers explained

MetricFormulaSubstitutedResult
Daily demand dmonthly mean / 30.437582.42 / 30.43752.708
Daily demand sdmonthly sd / sqrt(30.4375)27.87 / 5.5175.052
Service level / zz = Phi^-1(service level)Phi^-1(0.950)1.645
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.645 * sqrt(9.6 * 5.052^2 + 2.708^2 * 2.2^2)27.5
Reorder pointd * LT + safety stock2.708 * 9.6 + 27.553.4
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days53.4
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 988/yr, S = 45.00, h = 20%, price = 18.84153.6
Inventory positionon hand + on order96 + 096

Price break evaluation (annual cost at each tier's EOQ)

From qtyUnit costOrder qtyAnnual costFeasible
018.8415419,199yes (chosen if cheapest)

MOQ 310, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 17, 202690 / 31018.701,683.33
Sept. 13, 20266 / 618.70112.22

Movement ledger 126 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-654MAIN 11 18.70-205.74961,795.56 Aug. 17, 2026: 11 @ 18.70
Oct. 7, 2026issueSO-261007-425MAIN 41 18.70-766.851072,001.30 Aug. 17, 2026: 41 @ 18.70
Oct. 6, 2026issueSO-261006-575MAIN 8 18.70-149.631482,768.15 Aug. 17, 2026: 8 @ 18.70
Oct. 4, 2026issueSO-261004-851MAIN 3 18.70-56.111562,917.78 Aug. 17, 2026: 3 @ 18.70
Oct. 3, 2026issueSO-261003-612MAIN 2 18.70-37.411592,973.89 Aug. 17, 2026: 2 @ 18.70
Oct. 2, 2026issueSO-261002-622MAIN 26 18.70-486.301613,011.30 Aug. 17, 2026: 26 @ 18.70
Sept. 29, 2026issueSO-260929-798MAIN 11 18.70-205.741873,497.59 Aug. 17, 2026: 11 @ 18.70
Sept. 21, 2026adjustmentCycle countMAIN -2 18.70-37.411983,703.33 Aug. 17, 2026: 2 @ 18.70
Sept. 17, 2026issueSO-260917-442MAIN 14 18.70-261.852003,740.74 Aug. 17, 2026: 14 @ 18.70
Sept. 13, 2026returnRMAMAIN 6 18.70112.222144,002.59
Sept. 11, 2026issueSO-260911-163MAIN 6 18.70-112.222083,890.37 Aug. 17, 2026: 6 @ 18.70
Sept. 9, 2026issueSO-260909-772MAIN 67 18.70-1,253.152144,002.59 Aug. 17, 2026: 67 @ 18.70
Aug. 31, 2026issueSO-260831-484MAIN 15 18.70-280.562815,255.74 Aug. 17, 2026: 15 @ 18.70
Aug. 26, 2026issueSO-260826-594MAIN 13 18.70-243.152965,536.30 Aug. 17, 2026: 13 @ 18.70
Aug. 20, 2026issueSO-260820-163MAIN 14 18.88-264.363095,779.44 March 18, 2026: 13 @ 18.90; Aug. 17, 2026: 1 @ 18.70
Aug. 17, 2026receiptPO-001723MAIN 310 18.705,798.153236,043.81
Aug. 13, 2026issueSO-260813-930MAIN 10 18.90-188.9713245.66 March 18, 2026: 10 @ 18.90
Aug. 5, 2026issueSO-260805-266MAIN 19 18.90-359.0423434.63 March 18, 2026: 19 @ 18.90
July 31, 2026issueSO-260731-750MAIN 7 18.90-132.2842793.67 March 18, 2026: 7 @ 18.90
July 26, 2026issueSO-260726-460MAIN 5 18.90-94.4849925.95 March 18, 2026: 5 @ 18.90
July 25, 2026issueSO-260725-982MAIN 8 18.90-151.18541,020.44 March 18, 2026: 8 @ 18.90
July 24, 2026issueSO-260724-776MAIN 4 18.90-75.59621,171.61 March 18, 2026: 4 @ 18.90
July 16, 2026issueSO-260716-551MAIN 30 18.90-566.91661,247.20 March 18, 2026: 30 @ 18.90
July 7, 2026issueSO-260707-544MAIN 7 18.90-132.28961,814.11 March 18, 2026: 7 @ 18.90
July 4, 2026issueSO-260704-942MAIN 5 18.90-94.481031,946.39 March 18, 2026: 5 @ 18.90
June 30, 2026issueSO-260630-117MAIN 17 18.90-321.251082,040.88 March 18, 2026: 17 @ 18.90
June 24, 2026issueSO-260624-221MAIN 8 18.90-151.181252,362.12 March 18, 2026: 8 @ 18.90
June 12, 2026issueSO-260612-359MAIN 18 18.90-340.151332,513.30 March 18, 2026: 18 @ 18.90
June 8, 2026issueSO-260608-284MAIN 21 18.90-396.841512,853.45 March 18, 2026: 21 @ 18.90
May 29, 2026issueSO-260529-594MAIN 51 18.90-963.751723,250.28 March 18, 2026: 51 @ 18.90
May 22, 2026issueSO-260522-974MAIN 7 18.90-132.282234,214.03 March 18, 2026: 7 @ 18.90
April 30, 2026issueSO-260430-634MAIN 1 18.90-18.902304,346.31 March 18, 2026: 1 @ 18.90
April 28, 2026issueSO-260428-785MAIN 31 18.90-585.812314,365.21 March 18, 2026: 31 @ 18.90
April 21, 2026issueSO-260421-497MAIN 31 18.90-585.812624,951.01 March 18, 2026: 31 @ 18.90
April 13, 2026issueSO-260413-626MAIN 12 18.90-226.762935,536.82 March 18, 2026: 12 @ 18.90
April 8, 2026issueSO-260408-763MAIN 2 18.90-37.793055,763.58 March 18, 2026: 2 @ 18.90
March 23, 2026issueSO-260323-668MAIN 5 18.37-91.853075,801.38 Nov. 17, 2025: 2 @ 17.58; March 18, 2026: 3 @ 18.90
March 20, 2026issueSO-260320-506MAIN 5 17.96-89.803125,893.23 Nov. 15, 2025: 5 @ 17.96
March 18, 2026issueSO-260318-935MAIN 4 17.96-71.843175,983.02 Nov. 15, 2025: 4 @ 17.96
March 18, 2026receiptPO-001331MAIN 310 18.905,858.073216,054.86
March 14, 2026issueSO-260314-692MAIN 26 17.96-466.9511196.79 Nov. 15, 2025: 26 @ 17.96
March 10, 2026issueSO-260310-933MAIN 6 17.96-107.7637663.75 Nov. 15, 2025: 6 @ 17.96
March 7, 2026issueSO-260307-763MAIN 4 17.96-71.8443771.50 Nov. 15, 2025: 4 @ 17.96
Feb. 22, 2026issueSO-260222-775MAIN 21 17.96-377.1547843.34 Nov. 15, 2025: 21 @ 17.96
Feb. 18, 2026issueSO-260218-522MAIN 9 17.96-161.64681,220.50 Nov. 15, 2025: 9 @ 17.96
Feb. 17, 2026issueSO-260217-675MAIN 6 17.96-107.76771,382.13 Nov. 15, 2025: 6 @ 17.96
Feb. 13, 2026issueSO-260213-786MAIN 11 17.96-197.56831,489.89 Nov. 15, 2025: 11 @ 17.96
Feb. 11, 2026issueSO-260211-378MAIN 1 17.96-17.96941,687.45 Nov. 15, 2025: 1 @ 17.96
Feb. 10, 2026issueSO-260210-384MAIN 6 17.96-107.76951,705.41 Nov. 15, 2025: 6 @ 17.96
Feb. 5, 2026issueSO-260205-238MAIN 7 17.96-125.721011,813.17 Nov. 15, 2025: 7 @ 17.96
Jan. 26, 2026issueSO-260126-976MAIN 28 17.96-502.871081,938.88 Nov. 15, 2025: 28 @ 17.96
Jan. 9, 2026issueSO-260109-735MAIN 33 17.96-592.671362,441.76 Nov. 15, 2025: 33 @ 17.96
Jan. 5, 2026issueSO-260105-716MAIN 13 17.96-233.481693,034.43 Nov. 15, 2025: 13 @ 17.96
Dec. 31, 2025issueSO-251231-985MAIN 20 17.96-359.191823,267.90 Nov. 15, 2025: 20 @ 17.96
Dec. 30, 2025issueSO-251230-183MAIN 2 17.96-35.922023,627.10 Nov. 15, 2025: 2 @ 17.96
Dec. 27, 2025issueSO-251227-813MAIN 35 17.96-628.592043,663.02 Nov. 15, 2025: 35 @ 17.96
Dec. 20, 2025issueSO-251220-246MAIN 28 17.96-502.872394,291.60 Nov. 15, 2025: 28 @ 17.96
Dec. 16, 2025issueSO-251216-248MAIN 7 17.96-125.722674,794.48 Nov. 15, 2025: 7 @ 17.96
Dec. 9, 2025issueSO-251209-608MAIN 9 17.96-161.642744,920.19 Nov. 15, 2025: 9 @ 17.96
Dec. 9, 2025issueSO-251209-608EAST 17 17.96-305.312835,081.83 Nov. 15, 2025: 17 @ 17.96
Dec. 6, 2025issueSO-251206-361MAIN 27 17.75-479.193005,387.15 Aug. 24, 2025: 15 @ 17.58; Nov. 15, 2025: 12 @ 17.96
Nov. 26, 2025issueSO-251126-669MAIN 2 17.58-35.163275,866.33 Aug. 24, 2025: 2 @ 17.58
Nov. 17, 2025returnRMAMAIN 2 17.5835.163295,901.49
Nov. 15, 2025receiptPO-001001MAIN 310 17.965,567.513275,866.33
Nov. 13, 2025issueSO-251113-421EAST 9 17.58-158.2017298.83 Aug. 24, 2025: 9 @ 17.58
Nov. 13, 2025issueSO-251113-421MAIN 28 17.58-492.1826457.03 Aug. 24, 2025: 28 @ 17.58
Nov. 5, 2025issueSO-251105-889MAIN 69 17.58-1,212.8854949.21 Aug. 24, 2025: 69 @ 17.58
Oct. 29, 2025issueSO-251029-265EAST 4 17.58-70.311232,162.09 Aug. 24, 2025: 4 @ 17.58
Oct. 23, 2025issueSO-251023-907EAST 39 17.58-685.541272,232.41 Aug. 24, 2025: 39 @ 17.58
Oct. 14, 2025issueSO-251014-931MAIN 68 17.58-1,195.301662,917.95 Aug. 24, 2025: 68 @ 17.58
Oct. 12, 2025issueSO-251012-454MAIN 14 17.58-246.092344,113.25 Aug. 24, 2025: 14 @ 17.58
Sept. 30, 2025issueSO-250930-762MAIN 13 17.58-228.512484,359.34 Aug. 24, 2025: 13 @ 17.58
Sept. 28, 2025issueSO-250928-401EAST 15 17.58-263.672614,587.86 Aug. 24, 2025: 15 @ 17.58
Sept. 24, 2025issueSO-250924-166MAIN 21 17.58-369.142764,851.53 Aug. 24, 2025: 21 @ 17.58
Sept. 19, 2025issueSO-250919-260MAIN 12 17.58-210.942975,220.67 Aug. 24, 2025: 12 @ 17.58
Sept. 14, 2025issueSO-250914-889MAIN 14 17.61-246.503095,431.60 April 30, 2025: 13 @ 17.61; Aug. 24, 2025: 1 @ 17.58
Aug. 31, 2025issueSO-250831-917MAIN 11 17.61-193.703235,678.10 April 30, 2025: 11 @ 17.61
Aug. 24, 2025transferTRFMAIN → EAST 84 warehouse transfer, no cost effect
Aug. 24, 2025receiptPO-000791MAIN 310 17.585,449.183345,871.81
Aug. 19, 2025issueSO-250819-705MAIN 5 17.61-88.0524422.63 April 30, 2025: 5 @ 17.61
Aug. 17, 2025issueSO-250817-930MAIN 48 17.61-845.2529510.67 April 30, 2025: 48 @ 17.61
Aug. 14, 2025issueSO-250814-964MAIN 27 17.61-475.45771,355.92 April 30, 2025: 27 @ 17.61
Aug. 5, 2025issueSO-250805-579MAIN 13 17.61-228.921041,831.38 April 30, 2025: 13 @ 17.61
Aug. 2, 2025issueSO-250802-760MAIN 13 17.61-228.921172,060.30 April 30, 2025: 13 @ 17.61
July 21, 2025issueSO-250721-322MAIN 22 17.61-387.411302,289.22 April 30, 2025: 22 @ 17.61
July 6, 2025issueSO-250706-507MAIN 31 17.61-545.891522,676.63 April 30, 2025: 31 @ 17.61
July 2, 2025issueSO-250702-690MAIN 5 17.61-88.051833,222.52 April 30, 2025: 5 @ 17.61
June 29, 2025issueSO-250629-209MAIN 44 17.61-774.811883,310.57 April 30, 2025: 44 @ 17.61
June 16, 2025issueSO-250616-771MAIN 13 17.61-228.922324,085.38 April 30, 2025: 13 @ 17.61
June 5, 2025issueSO-250605-836MAIN 2 17.61-35.222454,314.30 April 30, 2025: 2 @ 17.61
May 30, 2025issueSO-250530-914MAIN 1 17.61-17.612474,349.52 April 30, 2025: 1 @ 17.61
May 20, 2025issueSO-250520-751MAIN 37 17.61-651.552484,367.13 April 30, 2025: 37 @ 17.61
May 8, 2025issueSO-250508-195MAIN 13 17.61-228.922855,018.68 April 30, 2025: 13 @ 17.61
May 7, 2025issueSO-250507-858MAIN 6 17.61-105.662985,247.60 April 30, 2025: 6 @ 17.61
May 4, 2025issueSO-250504-712MAIN 6 17.61-105.663045,353.26 April 30, 2025: 6 @ 17.61
May 3, 2025issueSO-250503-403MAIN 20 17.06-341.223105,458.91 March 29, 2025: 20 @ 17.06
April 30, 2025receiptPO-000493MAIN 310 17.615,458.913305,800.13
April 23, 2025issueSO-250423-428MAIN 33 17.06-563.0120341.22 Dec. 30, 2024: 32 @ 17.06; March 29, 2025: 1 @ 17.06
April 5, 2025issueSO-250405-735MAIN 36 17.06-614.1953904.22 Dec. 30, 2024: 36 @ 17.06
March 29, 2025returnRMAMAIN 21 17.06358.28891,518.41
March 28, 2025issueSO-250328-165MAIN 4 17.06-68.24681,160.13 Dec. 30, 2024: 4 @ 17.06
March 12, 2025issueSO-250312-688MAIN 69 17.06-1,177.20721,228.38 Dec. 30, 2024: 69 @ 17.06
March 9, 2025issueSO-250309-789MAIN 42 17.06-716.551412,405.57 Dec. 30, 2024: 42 @ 17.06
Feb. 28, 2025issueSO-250228-816MAIN 12 17.06-204.731833,122.13 Dec. 30, 2024: 12 @ 17.06
Feb. 25, 2025issueSO-250225-853MAIN 25 17.06-426.521953,326.86 Dec. 30, 2024: 25 @ 17.06
Feb. 15, 2025issueSO-250215-530MAIN 9 17.06-153.552203,753.38 Dec. 30, 2024: 9 @ 17.06
Feb. 9, 2025issueSO-250209-192MAIN 5 17.06-85.302293,906.92 Dec. 30, 2024: 5 @ 17.06
Feb. 4, 2025issueSO-250204-185MAIN 30 17.06-511.822343,992.23 Dec. 30, 2024: 30 @ 17.06
Feb. 3, 2025issueSO-250203-414MAIN 6 17.06-102.362644,504.05 Dec. 30, 2024: 6 @ 17.06
Jan. 26, 2025issueSO-250126-989MAIN 20 17.06-341.222704,606.42 Dec. 30, 2024: 20 @ 17.06
Jan. 18, 2025issueSO-250118-949MAIN 1 17.06-17.062904,947.63 Dec. 30, 2024: 1 @ 17.06
Jan. 13, 2025issueSO-250113-949MAIN 17 17.06-290.032914,964.69 Dec. 30, 2024: 17 @ 17.06
Jan. 4, 2025issueSO-250104-919MAIN 9 17.71-159.413085,254.73 Oct. 1, 2024: 7 @ 17.90; Dec. 30, 2024: 2 @ 17.06
Jan. 2, 2025issueSO-250102-262MAIN 44 17.90-787.513175,414.13 Oct. 1, 2024: 44 @ 17.90
Dec. 30, 2024receiptPO-000150MAIN 310 17.065,288.853616,201.65
Dec. 25, 2024issueSO-241225-685MAIN 40 17.90-715.9251912.80 Oct. 1, 2024: 40 @ 17.90
Dec. 16, 2024issueSO-241216-876MAIN 80 17.90-1,431.84911,628.72 Oct. 1, 2024: 80 @ 17.90
Nov. 26, 2024issueSO-241126-373MAIN 5 17.90-89.491713,060.56 Oct. 1, 2024: 5 @ 17.90
Nov. 25, 2024issueSO-241125-195MAIN 6 17.90-107.391763,150.05 Oct. 1, 2024: 6 @ 17.90
Nov. 19, 2024issueSO-241119-507MAIN 7 17.90-125.291823,257.44 Oct. 1, 2024: 7 @ 17.90
Nov. 8, 2024issueSO-241108-680MAIN 2 17.90-35.801893,382.72 Oct. 1, 2024: 2 @ 17.90
Nov. 4, 2024issueSO-241104-999MAIN 67 17.90-1,199.171913,418.52 Oct. 1, 2024: 67 @ 17.90
Nov. 3, 2024issueSO-241103-816MAIN 3 17.90-53.692584,617.68 Oct. 1, 2024: 3 @ 17.90
Oct. 25, 2024issueSO-241025-746MAIN 9 17.90-161.082614,671.38 Oct. 1, 2024: 9 @ 17.90
Oct. 4, 2024issueSO-241004-842MAIN 40 17.90-715.922704,832.46 Oct. 1, 2024: 40 @ 17.90
Oct. 1, 2024receiptPO-000001MAIN 310 17.905,548.383105,548.38