stocksense

Items / LED-0002

LED Tube 18W Lite LED-0002 · Lighting · BrightLine Lighting

On hand (EA)82MAIN 59, EAST 23
Value (FIFO)2,213.22avg 26.99
ClassCX / FCV 0.32
Turnover3.2xlast issue 0 days ago
Days of cover110lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00020.09.418.728.137.4Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 21.0Nov 24: 25.0Dec 24: 34.0Jan 25: 26.0Feb 25: 24.0Mar 25: 29.0Apr 25: 18.0May 25: 15.0Jun 25: 15.0Jul 25: 14.0Aug 25: 17.0Sep 25: 19.0Oct 25: 27.0Nov 25: 33.0Dec 25: 29.0Jan 26: 31.0Feb 26: 14.0Mar 26: 14.0Apr 26: 32.0May 26: 16.0Jun 26: 14.0Jul 26: 20.0Aug 26: 17.0Sep 26: 25.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.437522.67 / 30.43750.745
Daily demand sdmonthly sd / sqrt(30.4375)7.28 / 5.5171.320
Service level / zz = Phi^-1(service level)Phi^-1(0.900)1.282
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.282 * sqrt(9.6 * 1.320^2 + 0.745^2 * 2.2^2)5.6
Reorder pointd * LT + safety stock0.745 * 9.6 + 5.612.8
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days12.8
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 272/yr, S = 45.00, h = 20%, price = 26.4268.0
Inventory positionon hand + on order82 + 082

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

From qtyUnit costOrder qtyAnnual costFeasible
026.42687,541yes (chosen if cheapest)

MOQ 90, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 9, 202682 / 9026.992,213.22

Movement ledger 126 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-150MAIN 7 26.99-188.93822,213.22 Oct. 9, 2026: 7 @ 26.99
Oct. 10, 2026issueSO-261010-919EAST 1 26.99-26.99892,402.15 Oct. 9, 2026: 1 @ 26.99
Oct. 9, 2026transferTRFMAIN → EAST 24 warehouse transfer, no cost effect
Oct. 9, 2026receiptPO-001862MAIN 90 26.992,429.14902,429.14
Oct. 5, 2026issueSO-261005-853MAIN 4 25.98-103.9100.00 May 26, 2026: 4 @ 25.98
Oct. 2, 2026issueSO-261002-714MAIN 7 25.98-181.844103.91 May 26, 2026: 7 @ 25.98
Sept. 26, 2026issueSO-260926-863MAIN 14 25.98-363.6711285.74 May 26, 2026: 14 @ 25.98
Sept. 14, 2026issueSO-260914-552MAIN 1 25.98-25.9825649.41 May 26, 2026: 1 @ 25.98
Sept. 13, 2026issueSO-260913-875MAIN 1 25.98-25.9826675.39 May 26, 2026: 1 @ 25.98
Sept. 5, 2026issueSO-260905-259MAIN 7 25.98-181.8427701.37 May 26, 2026: 7 @ 25.98
Sept. 4, 2026issueSO-260904-629MAIN 2 25.98-51.9534883.20 May 26, 2026: 2 @ 25.98
Aug. 29, 2026issueSO-260829-983MAIN 1 25.98-25.9836935.15 May 26, 2026: 1 @ 25.98
Aug. 24, 2026issueSO-260824-762MAIN 1 25.98-25.9837961.13 May 26, 2026: 1 @ 25.98
Aug. 23, 2026issueSO-260823-369MAIN 3 25.98-77.9338987.11 May 26, 2026: 3 @ 25.98
Aug. 23, 2026issueSO-260823-369EAST 7 25.98-181.84411,065.04 May 26, 2026: 7 @ 25.98
Aug. 15, 2026issueSO-260815-271MAIN 1 25.98-25.98481,246.87 May 26, 2026: 1 @ 25.98
Aug. 10, 2026issueSO-260810-820MAIN 2 25.98-51.95491,272.85 May 26, 2026: 2 @ 25.98
Aug. 7, 2026issueSO-260807-102MAIN 1 25.98-25.98511,324.80 May 26, 2026: 1 @ 25.98
Aug. 1, 2026issueSO-260801-475MAIN 1 25.98-25.98521,350.78 May 26, 2026: 1 @ 25.98
July 27, 2026issueSO-260727-238MAIN 8 25.98-207.81531,376.75 May 26, 2026: 8 @ 25.98
July 9, 2026issueSO-260709-251EAST 6 25.98-155.86611,584.57 May 26, 2026: 6 @ 25.98
July 6, 2026issueSO-260706-310EAST 6 25.98-155.86671,740.43 May 26, 2026: 6 @ 25.98
June 22, 2026issueSO-260622-412MAIN 8 25.98-207.81731,896.28 May 26, 2026: 8 @ 25.98
June 10, 2026issueSO-260610-283MAIN 6 25.98-155.86812,104.10 May 26, 2026: 6 @ 25.98
May 30, 2026issueSO-260530-819MAIN 3 25.98-77.93872,259.96 May 26, 2026: 3 @ 25.98
May 26, 2026transferTRFMAIN → EAST 19 warehouse transfer, no cost effect
May 26, 2026receiptPO-001521MAIN 90 25.982,337.88902,337.88
May 23, 2026issueSO-260523-304MAIN 1 26.33-26.3300.00 March 30, 2026: 1 @ 26.33
May 15, 2026issueSO-260515-814MAIN 12 26.33-315.90126.33 Jan. 9, 2026: 10 @ 26.33; Jan. 26, 2026: 1 @ 26.33; March 30, 2026: 1 @ 26.33
April 21, 2026issueSO-260421-513MAIN 14 26.33-368.5513342.23 Jan. 9, 2026: 14 @ 26.33
April 12, 2026issueSO-260412-500MAIN 6 26.33-157.9527710.78 Jan. 9, 2026: 6 @ 26.33
April 1, 2026issueSO-260401-851MAIN 12 26.33-315.9033868.73 Jan. 9, 2026: 12 @ 26.33
March 30, 2026returnRMAMAIN 2 26.3352.65451,184.63
March 26, 2026issueSO-260326-975MAIN 1 26.33-26.33431,131.98 Jan. 9, 2026: 1 @ 26.33
March 24, 2026issueSO-260324-847MAIN 1 26.33-26.33441,158.31 Jan. 9, 2026: 1 @ 26.33
March 22, 2026issueSO-260322-658MAIN 9 26.33-236.93451,184.63 Jan. 9, 2026: 9 @ 26.33
March 21, 2026issueSO-260321-172MAIN 1 26.33-26.33541,421.56 Jan. 9, 2026: 1 @ 26.33
March 17, 2026issueSO-260317-522MAIN 4 26.33-105.30551,447.89 Jan. 9, 2026: 4 @ 26.33
Feb. 21, 2026issueSO-260221-629MAIN 4 26.33-105.30591,553.19 Jan. 9, 2026: 4 @ 26.33
Feb. 8, 2026issueSO-260208-827MAIN 7 26.33-184.28631,658.49 Jan. 9, 2026: 7 @ 26.33
Feb. 1, 2026issueSO-260201-719MAIN 1 26.33-26.33701,842.76 Jan. 9, 2026: 1 @ 26.33
Feb. 1, 2026issueSO-260201-719EAST 2 26.33-52.65711,869.09 Jan. 9, 2026: 2 @ 26.33
Jan. 26, 2026returnRMAMAIN 1 26.3326.33731,921.74
Jan. 25, 2026issueSO-260125-838EAST 17 26.33-447.53721,895.41 Jan. 9, 2026: 17 @ 26.33
Jan. 16, 2026issueSO-260116-867MAIN 1 26.33-26.33892,342.94 Jan. 9, 2026: 1 @ 26.33
Jan. 11, 2026issueSO-260111-436MAIN 1 25.36-25.36902,369.27 Oct. 9, 2025: 1 @ 25.36
Jan. 9, 2026transferTRFMAIN → EAST 19 warehouse transfer, no cost effect
Jan. 9, 2026receiptPO-001129MAIN 90 26.332,369.27912,394.63
Jan. 6, 2026issueSO-260106-154MAIN 1 25.36-25.36125.36 Oct. 9, 2025: 1 @ 25.36
Jan. 3, 2026issueSO-260103-633MAIN 11 25.36-279.00250.73 Oct. 9, 2025: 11 @ 25.36
Jan. 1, 2026issueSO-260101-549MAIN 1 25.36-25.3613329.73 Oct. 9, 2025: 1 @ 25.36
Dec. 30, 2025issueSO-251230-575MAIN 4 25.36-101.4514355.09 Oct. 9, 2025: 4 @ 25.36
Dec. 22, 2025issueSO-251222-494MAIN 8 25.36-202.9118456.54 Oct. 9, 2025: 8 @ 25.36
Dec. 16, 2025issueSO-251216-644MAIN 1 25.36-25.3626659.45 Oct. 9, 2025: 1 @ 25.36
Dec. 10, 2025issueSO-251210-105MAIN 10 25.36-253.6427684.82 Oct. 9, 2025: 10 @ 25.36
Dec. 10, 2025issueSO-251210-105EAST 6 25.36-152.1837938.45 Oct. 9, 2025: 6 @ 25.36
Nov. 27, 2025issueSO-251127-579MAIN 13 25.36-329.73431,090.63 Oct. 9, 2025: 13 @ 25.36
Nov. 3, 2025issueSO-251103-592EAST 20 25.36-507.27561,420.36 Oct. 9, 2025: 20 @ 25.36
Oct. 27, 2025issueSO-251027-102MAIN 1 25.36-25.36761,927.63 Oct. 9, 2025: 1 @ 25.36
Oct. 26, 2025issueSO-251026-420EAST 1 25.36-25.36771,953.00 Oct. 9, 2025: 1 @ 25.36
Oct. 25, 2025issueSO-251025-182MAIN 1 25.36-25.36781,978.36 Oct. 9, 2025: 1 @ 25.36
Oct. 24, 2025issueSO-251024-148MAIN 15 25.41-381.18792,003.72 April 15, 2025: 3 @ 25.55; Aug. 1, 2025: 1 @ 25.55; Oct. 9, 2025: 11 @ 25.36
Oct. 13, 2025issueSO-251013-856EAST 2 25.55-51.09942,384.91 April 15, 2025: 2 @ 25.55
Oct. 9, 2025transferTRFMAIN → EAST 29 warehouse transfer, no cost effect
Oct. 9, 2025receiptPO-000908MAIN 90 25.362,282.72962,436.00
Oct. 3, 2025issueSO-251003-441MAIN 7 25.55-178.826153.27 April 15, 2025: 7 @ 25.55
Sept. 30, 2025issueSO-250930-294MAIN 2 25.55-51.0913332.09 April 15, 2025: 2 @ 25.55
Sept. 25, 2025issueSO-250925-316MAIN 2 25.55-51.0915383.18 April 15, 2025: 2 @ 25.55
Sept. 18, 2025issueSO-250918-262MAIN 5 25.55-127.7317434.28 April 15, 2025: 5 @ 25.55
Sept. 3, 2025issueSO-250903-335MAIN 3 25.55-76.6422562.00 April 15, 2025: 3 @ 25.55
Sept. 1, 2025issueSO-250901-735MAIN 7 25.55-178.8225638.64 April 15, 2025: 7 @ 25.55
Aug. 29, 2025issueSO-250829-126MAIN 6 25.55-153.2732817.46 April 15, 2025: 6 @ 25.55
Aug. 27, 2025issueSO-250827-353MAIN 1 25.55-25.5538970.73 April 15, 2025: 1 @ 25.55
Aug. 24, 2025issueSO-250824-895MAIN 1 25.55-25.5539996.28 April 15, 2025: 1 @ 25.55
Aug. 17, 2025issueSO-250817-186MAIN 2 25.55-51.09401,021.82 April 15, 2025: 2 @ 25.55
Aug. 15, 2025issueSO-250815-742MAIN 3 25.55-76.64421,072.92 April 15, 2025: 3 @ 25.55
Aug. 5, 2025issueSO-250805-199MAIN 5 25.55-127.73451,149.55 April 15, 2025: 5 @ 25.55
Aug. 1, 2025returnRMAMAIN 1 25.5525.55501,277.28
July 30, 2025issueSO-250730-833MAIN 5 25.55-127.73491,251.73 April 15, 2025: 5 @ 25.55
July 29, 2025issueSO-250729-800MAIN 1 25.55-25.55541,379.46 April 15, 2025: 1 @ 25.55
July 26, 2025issueSO-250726-529MAIN 3 25.55-76.64551,405.01 April 15, 2025: 3 @ 25.55
July 24, 2025issueSO-250724-393MAIN 5 25.55-127.73581,481.64 April 15, 2025: 5 @ 25.55
June 13, 2025issueSO-250613-592MAIN 2 25.55-51.09631,609.37 April 15, 2025: 2 @ 25.55
June 7, 2025issueSO-250607-384MAIN 1 25.55-25.55651,660.46 April 15, 2025: 1 @ 25.55
June 6, 2025issueSO-250606-398MAIN 2 25.55-51.09661,686.01 April 15, 2025: 2 @ 25.55
June 4, 2025issueSO-250604-974MAIN 10 25.55-255.46681,737.10 April 15, 2025: 10 @ 25.55
May 24, 2025issueSO-250524-718MAIN 4 25.55-102.18781,992.56 April 15, 2025: 4 @ 25.55
May 22, 2025issueSO-250522-183MAIN 3 25.55-76.64822,094.74 April 15, 2025: 3 @ 25.55
May 16, 2025issueSO-250516-445MAIN 2 25.55-51.09852,171.38 April 15, 2025: 2 @ 25.55
May 13, 2025issueSO-250513-970MAIN 2 25.55-51.09872,222.47 April 15, 2025: 2 @ 25.55
May 5, 2025issueSO-250505-370MAIN 2 24.82-49.64892,273.56 Jan. 8, 2025: 1 @ 24.09; April 15, 2025: 1 @ 25.55
May 4, 2025issueSO-250504-692MAIN 2 24.09-48.18912,323.19 Jan. 8, 2025: 2 @ 24.09
April 25, 2025issueSO-250425-289MAIN 6 24.09-144.54932,371.37 Jan. 8, 2025: 6 @ 24.09
April 15, 2025receiptPO-000448MAIN 90 25.552,299.10992,515.91
April 14, 2025issueSO-250414-184MAIN 1 24.09-24.099216.80 Jan. 8, 2025: 1 @ 24.09
April 8, 2025issueSO-250408-590MAIN 8 24.09-192.7210240.89 Jan. 8, 2025: 8 @ 24.09
April 5, 2025issueSO-250405-351MAIN 3 24.09-72.2718433.61 Jan. 8, 2025: 3 @ 24.09
March 27, 2025issueSO-250327-148MAIN 13 24.09-313.1621505.88 Jan. 8, 2025: 13 @ 24.09
March 20, 2025issueSO-250320-971MAIN 8 24.09-192.7234819.04 Jan. 8, 2025: 8 @ 24.09
March 9, 2025issueSO-250309-157MAIN 8 24.09-192.72421,011.75 Jan. 8, 2025: 8 @ 24.09
Feb. 25, 2025issueSO-250225-789MAIN 14 24.09-337.25501,204.47 Jan. 8, 2025: 14 @ 24.09
Feb. 19, 2025issueSO-250219-289MAIN 10 24.09-240.89641,541.72 Jan. 8, 2025: 10 @ 24.09
Jan. 30, 2025issueSO-250130-885MAIN 4 24.09-96.36741,782.62 Jan. 8, 2025: 4 @ 24.09
Jan. 25, 2025issueSO-250125-315EAST 5 24.09-120.45781,878.97 Jan. 8, 2025: 5 @ 24.09
Jan. 19, 2025issueSO-250119-751MAIN 13 24.56-319.22831,999.42 Oct. 1, 2024: 6 @ 25.10; Jan. 8, 2025: 7 @ 24.09
Jan. 8, 2025issueSO-250108-904MAIN 3 25.10-75.30962,318.64 Oct. 1, 2024: 3 @ 25.10
Jan. 8, 2025receiptPO-000169MAIN 90 24.092,168.05992,393.94
Jan. 2, 2025issueSO-250102-934MAIN 1 25.10-25.109225.89 Oct. 1, 2024: 1 @ 25.10
Dec. 31, 2024issueSO-241231-861MAIN 1 25.10-25.1010250.99 Oct. 1, 2024: 1 @ 25.10
Dec. 29, 2024issueSO-241229-586EAST 6 25.10-150.5911276.09 Oct. 1, 2024: 6 @ 25.10
Dec. 26, 2024issueSO-241226-359EAST 7 25.10-175.6917426.68 Oct. 1, 2024: 7 @ 25.10
Dec. 21, 2024issueSO-241221-476MAIN 6 25.10-150.5924602.38 Oct. 1, 2024: 6 @ 25.10
Dec. 5, 2024issueSO-241205-267MAIN 14 25.10-351.3930752.97 Oct. 1, 2024: 14 @ 25.10
Nov. 30, 2024issueSO-241130-493EAST 1 25.10-25.10441,104.36 Oct. 1, 2024: 1 @ 25.10
Nov. 24, 2024issueSO-241124-525MAIN 11 25.10-276.09451,129.46 Oct. 1, 2024: 11 @ 25.10
Nov. 22, 2024issueSO-241122-288MAIN 5 25.10-125.50561,405.54 Oct. 1, 2024: 5 @ 25.10
Nov. 16, 2024issueSO-241116-910MAIN 1 25.10-25.10611,531.04 Oct. 1, 2024: 1 @ 25.10
Nov. 9, 2024issueSO-241109-814MAIN 1 25.10-25.10621,556.14 Oct. 1, 2024: 1 @ 25.10
Nov. 5, 2024issueSO-241105-173MAIN 1 25.10-25.10631,581.24 Oct. 1, 2024: 1 @ 25.10
Nov. 4, 2024issueSO-241104-499EAST 5 25.10-125.50641,606.34 Oct. 1, 2024: 5 @ 25.10
Oct. 28, 2024issueSO-241028-759MAIN 4 25.10-100.40691,731.83 Oct. 1, 2024: 4 @ 25.10
Oct. 22, 2024issueSO-241022-133MAIN 10 25.10-250.99731,832.23 Oct. 1, 2024: 10 @ 25.10
Oct. 18, 2024issueSO-241018-336MAIN 6 25.10-150.59832,083.22 Oct. 1, 2024: 6 @ 25.10
Oct. 1, 2024issueSO-241001-197EAST 1 25.10-25.10892,233.81 Oct. 1, 2024: 1 @ 25.10
Oct. 1, 2024transferTRFMAIN → EAST 25 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000001MAIN 90 25.102,258.91902,258.91