stocksense

Items / LED-0009

Street Light 90W Eco LED-0009 · Lighting · BrightLine Lighting

On hand (EA)0
Value (FIFO)0.00avg 0.00
ClassAX / FCV 0.39
Turnover20.1xlast issue 1 days ago
Days of cover0lead time 10d

Reorder suggested: 470 units (position at or below reorder point: order EOQ), stockout risk high.

Demand and forecast

Monthly demand and forecast for LED-00090.057.2114172229Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 67.0Nov 24: 147.0Dec 24: 127.0Jan 25: 101.0Feb 25: 158.0Mar 25: 134.0Apr 25: 124.0May 25: 87.0Jun 25: 56.0Jul 25: 53.0Aug 25: 79.0Sep 25: 113.0Oct 25: 91.0Nov 25: 193.0Dec 25: 208.0Jan 26: 179.0Feb 26: 132.0Mar 26: 91.0Apr 26: 93.0May 26: 65.0Jun 26: 59.0Jul 26: 131.0Aug 26: 94.0Sep 26: 129.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.4375122.08 / 30.43754.011
Daily demand sdmonthly sd / sqrt(30.4375)47.15 / 5.5178.547
Service level / zz = Phi^-1(service level)Phi^-1(0.980)2.054
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)2.054 * sqrt(9.6 * 8.547^2 + 4.011^2 * 2.2^2)57.2
Reorder pointd * LT + safety stock4.011 * 9.6 + 57.295.6
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days95.6
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1464/yr, S = 45.00, h = 20%, price = 85.5387.8
Inventory positionon hand + on order0 + 00

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

From qtyUnit costOrder qtyAnnual costFeasible
085.5388126,717yes (chosen if cheapest)

MOQ 470, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
No stock.

Movement ledger 131 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-896EAST 26 84.20-2,189.1600.00 June 8, 2026: 26 @ 84.20
Oct. 14, 2026issueSO-261014-342EAST 19 84.20-1,599.77262,189.16 June 8, 2026: 19 @ 84.20
Oct. 13, 2026issueSO-261013-101EAST 34 84.20-2,862.75453,788.94 June 8, 2026: 34 @ 84.20
Oct. 9, 2026issueSO-261009-894EAST 1 84.20-84.20796,651.69 June 8, 2026: 1 @ 84.20
Oct. 9, 2026issueSO-261009-894MAIN 1 84.20-84.20806,735.89 June 8, 2026: 1 @ 84.20
Oct. 8, 2026issueSO-261008-800MAIN 11 84.20-926.18816,820.09 June 8, 2026: 11 @ 84.20
Oct. 5, 2026issueSO-261005-505MAIN 17 84.20-1,431.38927,746.27 June 8, 2026: 17 @ 84.20
Sept. 29, 2026issueSO-260929-866EAST 51 84.20-4,294.131099,177.65 June 8, 2026: 51 @ 84.20
Sept. 19, 2026issueSO-260919-625EAST 8 84.20-673.5916013,471.78 June 8, 2026: 8 @ 84.20
Sept. 17, 2026issueSO-260917-326MAIN 15 84.20-1,262.9816814,145.36 June 8, 2026: 15 @ 84.20
Sept. 10, 2026issueSO-260910-417MAIN 28 84.20-2,357.5618315,408.34 June 8, 2026: 28 @ 84.20
Sept. 7, 2026issueSO-260907-423MAIN 27 84.20-2,273.3621117,765.90 June 8, 2026: 27 @ 84.20
Aug. 29, 2026issueSO-260829-751MAIN 10 84.20-841.9923820,039.27 June 8, 2026: 10 @ 84.20
Aug. 23, 2026issueSO-260823-641MAIN 38 84.20-3,199.5524820,881.25 June 8, 2026: 38 @ 84.20
Aug. 22, 2026issueSO-260822-851MAIN 23 84.20-1,936.5728624,080.80 June 8, 2026: 23 @ 84.20
Aug. 1, 2026issueSO-260801-699MAIN 23 84.20-1,936.5730926,017.37 June 8, 2026: 23 @ 84.20
July 29, 2026issueSO-260729-829MAIN 3 84.20-252.6033227,953.94 June 8, 2026: 3 @ 84.20
July 24, 2026issueSO-260724-420MAIN 53 84.20-4,462.5333528,206.53 June 8, 2026: 53 @ 84.20
July 23, 2026issueSO-260723-351MAIN 19 84.20-1,599.7738832,669.06 June 8, 2026: 19 @ 84.20
July 15, 2026issueSO-260715-301MAIN 56 84.20-4,715.1240734,268.83 June 8, 2026: 56 @ 84.20
June 9, 2026issueSO-260609-810MAIN 7 84.20-589.3946338,983.95 June 8, 2026: 7 @ 84.20
June 8, 2026transferTRFMAIN → EAST 139 warehouse transfer, no cost effect
June 8, 2026receiptPO-001558MAIN 470 84.2039,573.3447039,573.34
June 3, 2026issueSO-260603-936MAIN 52 84.66-4,402.2400.00 Jan. 19, 2026: 52 @ 84.66
May 31, 2026issueSO-260531-905MAIN 24 84.66-2,031.80524,402.24 Jan. 19, 2026: 24 @ 84.66
May 17, 2026issueSO-260517-698MAIN 5 84.66-423.29766,434.04 Jan. 19, 2026: 5 @ 84.66
May 10, 2026issueSO-260510-629MAIN 14 84.66-1,185.22816,857.33 Jan. 19, 2026: 14 @ 84.66
May 9, 2026issueSO-260509-968MAIN 2 84.66-169.32958,042.55 Jan. 19, 2026: 2 @ 84.66
May 1, 2026issueSO-260501-870MAIN 20 84.66-1,693.17978,211.86 Jan. 19, 2026: 20 @ 84.66
April 28, 2026issueSO-260428-389MAIN 5 84.66-423.291179,905.03 Jan. 19, 2026: 5 @ 84.66
April 25, 2026issueSO-260425-288MAIN 5 84.66-423.2912210,328.32 Jan. 19, 2026: 5 @ 84.66
April 22, 2026issueSO-260422-623MAIN 2 84.66-169.3212710,751.62 Jan. 19, 2026: 2 @ 84.66
April 18, 2026issueSO-260418-510MAIN 29 84.66-2,455.0912910,920.93 Jan. 19, 2026: 29 @ 84.66
April 13, 2026issueSO-260413-514MAIN 17 84.66-1,439.1915813,376.03 Jan. 19, 2026: 17 @ 84.66
April 12, 2026issueSO-260412-380MAIN 29 84.66-2,455.0917514,815.22 Jan. 19, 2026: 29 @ 84.66
April 7, 2026issueSO-260407-410MAIN 6 84.66-507.9520417,270.31 Jan. 19, 2026: 6 @ 84.66
March 30, 2026issueSO-260330-375MAIN 4 84.66-338.6321017,778.26 Jan. 19, 2026: 4 @ 84.66
March 30, 2026issueSO-260330-375EAST 4 84.66-338.6321418,116.90 Jan. 19, 2026: 4 @ 84.66
March 21, 2026issueSO-260321-308EAST 38 84.66-3,217.0221818,455.53 Jan. 19, 2026: 38 @ 84.66
March 9, 2026issueSO-260309-792EAST 11 84.66-931.2425621,672.55 Jan. 19, 2026: 11 @ 84.66
March 3, 2026issueSO-260303-846EAST 34 84.66-2,878.3926722,603.79 Jan. 19, 2026: 34 @ 84.66
Feb. 28, 2026issueSO-260228-189MAIN 4 84.66-338.6330125,482.18 Jan. 19, 2026: 4 @ 84.66
Feb. 25, 2026issueSO-260225-364MAIN 26 84.66-2,201.1230525,820.81 Jan. 19, 2026: 26 @ 84.66
Feb. 23, 2026issueSO-260223-465MAIN 76 84.66-6,434.0433128,021.93 Jan. 19, 2026: 76 @ 84.66
Feb. 12, 2026issueSO-260212-688MAIN 17 84.66-1,439.1940734,455.97 Jan. 19, 2026: 17 @ 84.66
Feb. 4, 2026issueSO-260204-376EAST 9 84.66-761.9342435,895.16 Jan. 19, 2026: 9 @ 84.66
Jan. 21, 2026issueSO-260121-207EAST 37 84.66-3,132.3643336,657.09 Jan. 19, 2026: 37 @ 84.66
Jan. 19, 2026transferTRFMAIN → EAST 133 warehouse transfer, no cost effect
Jan. 19, 2026receiptPO-001158MAIN 470 84.6639,789.4547039,789.45
Jan. 17, 2026issueSO-260117-213MAIN 73 82.83-6,046.8500.00 Oct. 31, 2025: 73 @ 82.83
Jan. 13, 2026issueSO-260113-600MAIN 69 82.83-5,715.51736,046.85 Oct. 31, 2025: 69 @ 82.83
Dec. 26, 2025issueSO-251226-491MAIN 9 82.83-745.5014211,762.36 Oct. 31, 2025: 9 @ 82.83
Dec. 23, 2025issueSO-251223-932MAIN 14 82.83-1,159.6715112,507.86 Oct. 31, 2025: 14 @ 82.83
Dec. 22, 2025issueSO-251222-754MAIN 13 82.83-1,076.8416513,667.53 Oct. 31, 2025: 13 @ 82.83
Dec. 17, 2025issueSO-251217-110MAIN 15 82.83-1,242.5017814,744.36 Oct. 31, 2025: 15 @ 82.83
Dec. 10, 2025issueSO-251210-989MAIN 44 82.83-3,644.6719315,986.87 Oct. 31, 2025: 44 @ 82.83
Dec. 4, 2025issueSO-251204-409MAIN 23 82.83-1,905.1723719,631.54 Oct. 31, 2025: 23 @ 82.83
Dec. 2, 2025issueSO-251202-696MAIN 90 82.83-7,455.0226021,536.71 Oct. 31, 2025: 90 @ 82.83
Nov. 12, 2025issueSO-251112-623MAIN 1 82.83-82.8335028,991.72 Oct. 31, 2025: 1 @ 82.83
Nov. 11, 2025issueSO-251111-517MAIN 58 82.83-4,804.3435129,074.56 Oct. 31, 2025: 58 @ 82.83
Nov. 2, 2025issueSO-251102-870MAIN 134 82.47-11,050.4840933,878.90 May 26, 2025: 37 @ 82.16; Aug. 4, 2025: 1 @ 82.16; Oct. 28, 2025: 35 @ 82.16; Oct. 31, 2025: 61 @ 82.83
Oct. 31, 2025receiptPO-000965MAIN 470 82.8338,931.7454344,929.38
Oct. 30, 2025issueSO-251030-680MAIN 5 82.16-410.80735,997.64 May 26, 2025: 5 @ 82.16
Oct. 28, 2025returnRMAMAIN 35 82.162,875.58786,408.43
Oct. 24, 2025issueSO-251024-848MAIN 49 82.16-4,025.81433,532.85 May 26, 2025: 49 @ 82.16
Oct. 23, 2025issueSO-251023-715MAIN 71 82.16-5,833.32927,558.66 May 26, 2025: 71 @ 82.16
Oct. 4, 2025issueSO-251004-906MAIN 1 82.16-82.1616313,391.98 May 26, 2025: 1 @ 82.16
Sept. 18, 2025issueSO-250918-490MAIN 4 82.16-328.6416413,474.14 May 26, 2025: 4 @ 82.16
Sept. 16, 2025issueSO-250916-633MAIN 36 82.16-2,957.7416813,802.78 May 26, 2025: 36 @ 82.16
Sept. 16, 2025issueSO-250916-633EAST 34 82.16-2,793.4220416,760.52 May 26, 2025: 34 @ 82.16
Sept. 14, 2025issueSO-250914-509MAIN 5 82.16-410.8023819,553.94 May 26, 2025: 5 @ 82.16
Sept. 6, 2025issueSO-250906-904MAIN 34 82.16-2,793.4224319,964.73 May 26, 2025: 34 @ 82.16
Aug. 31, 2025issueSO-250831-585EAST 6 82.16-492.9627722,758.15 May 26, 2025: 6 @ 82.16
Aug. 30, 2025issueSO-250830-587MAIN 10 82.16-821.5928323,251.11 May 26, 2025: 10 @ 82.16
Aug. 10, 2025issueSO-250810-749MAIN 44 82.16-3,615.0129324,072.70 May 26, 2025: 44 @ 82.16
Aug. 7, 2025issueSO-250807-251EAST 14 82.16-1,150.2333727,687.72 May 26, 2025: 14 @ 82.16
Aug. 4, 2025returnRMAMAIN 1 82.1682.1635128,837.95
Aug. 2, 2025issueSO-250802-348MAIN 4 82.16-328.6435028,755.79 May 26, 2025: 4 @ 82.16
Aug. 1, 2025issueSO-250801-530EAST 2 82.16-164.3235429,084.43 May 26, 2025: 2 @ 82.16
July 30, 2025issueSO-250730-565MAIN 2 82.16-164.3235629,248.75 May 26, 2025: 2 @ 82.16
July 25, 2025issueSO-250725-711EAST 12 82.16-985.9135829,413.07 May 26, 2025: 12 @ 82.16
July 21, 2025issueSO-250721-370MAIN 3 82.16-246.4837030,398.98 May 26, 2025: 3 @ 82.16
July 17, 2025issueSO-250717-140MAIN 1 82.16-82.1637330,645.46 May 26, 2025: 1 @ 82.16
July 12, 2025issueSO-250712-699MAIN 1 82.16-82.1637430,727.62 May 26, 2025: 1 @ 82.16
July 11, 2025issueSO-250711-865EAST 18 82.16-1,478.8737530,809.78 May 26, 2025: 18 @ 82.16
July 5, 2025issueSO-250705-837EAST 16 82.16-1,314.5539332,288.64 May 26, 2025: 16 @ 82.16
June 28, 2025issueSO-250628-359MAIN 6 82.16-492.9640933,603.19 May 26, 2025: 6 @ 82.16
June 26, 2025issueSO-250626-644EAST 22 82.16-1,807.5141534,096.15 May 26, 2025: 22 @ 82.16
June 17, 2025issueSO-250617-157EAST 1 82.16-82.1643735,903.66 May 26, 2025: 1 @ 82.16
June 13, 2025issueSO-250613-912MAIN 27 82.16-2,218.3043835,985.82 May 26, 2025: 27 @ 82.16
May 30, 2025issueSO-250530-310MAIN 5 82.16-410.8046538,204.12 May 26, 2025: 5 @ 82.16
May 26, 2025transferTRFMAIN → EAST 125 warehouse transfer, no cost effect
May 26, 2025receiptPO-000576MAIN 470 82.1638,614.9247038,614.92
May 25, 2025issueSO-250525-224MAIN 27 80.87-2,183.3700.00 Jan. 13, 2025: 11 @ 80.30; Jan. 18, 2025: 16 @ 81.25
May 21, 2025issueSO-250521-677MAIN 8 80.30-642.41272,183.37 Jan. 13, 2025: 8 @ 80.30
May 16, 2025issueSO-250516-773MAIN 35 80.30-2,810.55352,825.78 Jan. 13, 2025: 35 @ 80.30
May 14, 2025issueSO-250514-413MAIN 5 80.30-401.51705,636.33 Jan. 13, 2025: 5 @ 80.30
May 6, 2025issueSO-250506-540MAIN 7 80.30-562.11756,037.84 Jan. 13, 2025: 7 @ 80.30
April 29, 2025issueSO-250429-338MAIN 72 80.30-5,781.70826,599.95 Jan. 13, 2025: 72 @ 80.30
April 29, 2025issueSO-250429-338EAST 18 80.30-1,445.4315412,381.65 Jan. 13, 2025: 18 @ 80.30
April 12, 2025issueSO-250412-969MAIN 7 80.30-562.1117213,827.07 Jan. 13, 2025: 7 @ 80.30
April 2, 2025issueSO-250402-940MAIN 15 80.30-1,204.5217914,389.18 Jan. 13, 2025: 15 @ 80.30
April 1, 2025issueSO-250401-306EAST 12 80.30-963.6219415,593.71 Jan. 13, 2025: 12 @ 80.30
March 13, 2025issueSO-250313-286MAIN 16 80.30-1,284.8220616,557.32 Jan. 13, 2025: 16 @ 80.30
March 9, 2025issueSO-250309-977MAIN 52 80.30-4,175.6722217,842.14 Jan. 13, 2025: 52 @ 80.30
March 2, 2025issueSO-250302-889EAST 66 80.30-5,299.8927422,017.82 Jan. 13, 2025: 66 @ 80.30
Feb. 26, 2025issueSO-250226-687MAIN 43 80.30-3,452.9634027,317.71 Jan. 13, 2025: 43 @ 80.30
Feb. 16, 2025issueSO-250216-872MAIN 61 80.30-4,898.3938330,770.67 Jan. 13, 2025: 61 @ 80.30
Feb. 15, 2025issueSO-250215-822MAIN 17 80.30-1,365.1244435,669.06 Jan. 13, 2025: 17 @ 80.30
Feb. 1, 2025issueSO-250201-534MAIN 37 80.61-2,982.5846137,034.18 Dec. 24, 2024: 12 @ 81.25; Jan. 13, 2025: 25 @ 80.30
Jan. 31, 2025issueSO-250131-959MAIN 12 81.25-975.0449840,016.76 Oct. 22, 2024: 10 @ 81.25; Dec. 24, 2024: 2 @ 81.25
Jan. 18, 2025returnRMAMAIN 16 81.251,300.0651040,991.80
Jan. 13, 2025transferTRFMAIN → EAST 96 warehouse transfer, no cost effect
Jan. 13, 2025receiptPO-000182MAIN 470 80.3037,741.6649439,691.74
Jan. 5, 2025issueSO-250105-129MAIN 32 81.25-2,600.11241,950.08 Oct. 22, 2024: 32 @ 81.25
Jan. 4, 2025issueSO-250104-195MAIN 64 81.25-5,200.22564,550.20 Oct. 1, 2024: 62 @ 81.25; Oct. 22, 2024: 2 @ 81.25
Jan. 1, 2025issueSO-250101-976MAIN 9 81.25-731.281209,750.42 Oct. 1, 2024: 9 @ 81.25
Dec. 29, 2024issueSO-241229-702MAIN 30 81.25-2,437.6012910,481.70 Oct. 1, 2024: 30 @ 81.25
Dec. 26, 2024issueSO-241226-603MAIN 12 81.25-975.0415912,919.31 Oct. 1, 2024: 12 @ 81.25
Dec. 24, 2024returnRMAMAIN 14 81.251,137.5517113,894.35
Dec. 17, 2024issueSO-241217-398MAIN 28 81.25-2,275.1015712,756.80 Oct. 1, 2024: 28 @ 81.25
Dec. 17, 2024issueSO-241217-398EAST 54 81.25-4,387.6918515,031.90 Oct. 1, 2024: 54 @ 81.25
Dec. 8, 2024issueSO-241208-182MAIN 17 81.25-1,381.3123919,419.59 Oct. 1, 2024: 17 @ 81.25
Nov. 26, 2024issueSO-241126-669MAIN 5 81.25-406.2725620,800.90 Oct. 1, 2024: 5 @ 81.25
Nov. 21, 2024issueSO-241121-782MAIN 117 81.25-9,506.6626121,207.16 Oct. 1, 2024: 117 @ 81.25
Nov. 12, 2024issueSO-241112-643MAIN 25 81.25-2,031.3437830,713.82 Oct. 1, 2024: 25 @ 81.25
Oct. 22, 2024returnRMAMAIN 44 81.253,575.1540332,745.16
Oct. 5, 2024issueSO-241005-872MAIN 22 81.25-1,787.5835929,170.01 Oct. 1, 2024: 22 @ 81.25
Oct. 3, 2024issueSO-241003-645EAST 89 81.25-7,231.5638130,957.58 Oct. 1, 2024: 89 @ 81.25
Oct. 1, 2024transferTRFMAIN → EAST 143 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000001MAIN 470 81.2538,189.1447038,189.14